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, ...)
For PL/SQL executable, you must define ERRBUF and RETCODE. Value of RETCODE set the completion status. 0= Success, 1=Warning, 2=Error.
ReplyDeleteThere is no need to use SET_COMPLETION_STATUS for PL/SQL.