Warning
DECLARE l_result BOOLEAN; l_session_id NUMBER; l_reqid NUMBER; BEGIN l_reqid := '&&1'; dbms_output.put_line('l_reqid '||l_reqid); fnd_global.INITIALIZE(l_session_id, null, null, null,null, -1, null, null, null, null, l_reqid, null,null,null,null,null,null,-1); l_result := fnd_concurrent.set_completion_status('WARNING','Review log file for details.'); COMMIT; END; / exit 0;Error
DECLARE l_result BOOLEAN; l_session_id NUMBER; l_reqid NUMBER; BEGIN l_reqid := '&&1'; dbms_output.put_line('l_reqid '||l_reqid); fnd_global.INITIALIZE(l_session_id, null, null, null,null, -1, null, null, null, null, l_reqid, null,null,null,null,null,null,-1); l_result := fnd_concurrent.set_completion_status('ERROR','Review log file for details.'); COMMIT; END; / exit 0;Call the script. from your shell script.
sqlplus $unpw @$XX_TOP/sql/your file name.sql "$conc_request_id"You can of course handle both Warning and Error in the same SQL-file.