Labels

[ALRT] (3) [AR] (2) [BOM] (3) [GL] (2) [GTM] (1) [INV] (18) [MRP] (1) [OM] (27) [PO] (58) [QP] (3) [SYS] (39) [WIP] (4) AGIS (1) OM (1)

Saturday, January 8, 2011

[SYS] FND_CONCURRENT.SET_COMPLETION_STATUS

To set concurrent program completion status, use FND_CONCURRENT.SET_COMPLETION_STATUS in your SQL file. However, will it work if your executable is PL/SQL package? Yes, it will still work but you need to define 2 extra parameters in your procedure (first 2).

e.g.
Procedure XXX (errbuf VARCHAR2(100), retcode INTEGER, ...)

1 comment:

  1. For PL/SQL executable, you must define ERRBUF and RETCODE. Value of RETCODE set the completion status. 0= Success, 1=Warning, 2=Error.
    There is no need to use SET_COMPLETION_STATUS for PL/SQL.

    ReplyDelete