CREATE OR REPLACE PROCEDURE XX_SUBMIT_REQUEST_SET (P_errbuf OUT VARCHAR2, P_retcode OUT NUMBER) AS V_REQUEST_SET_EXIST BOOLEAN := FALSE; req_id INTEGER := 0; l_CONC_PROG_SUBMIT BOOLEAN := FALSE; srs_failed EXCEPTION; submitprog_failed EXCEPTION; submitset_failed EXCEPTION; l_start_date VARCHAR2 (250); BEGIN fnd_file.put_line (fnd_file.LOG, 'Calling set_request_set'); V_REQUEST_SET_EXIST := FND_SUBMIT.set_request_set (application => ‘XXAP’, request_set => ‘FNDRSSUB1786’); IF (NOT V_REQUEST_SET_EXIST) THEN RAISE srs_failed; END IF; fnd_file.put_line (fnd_file.LOG, 'Calling submit program first stage'); l_CONC_PROG_SUBMIT := fnd_submit.submit_program (‘XXAP’, ‘XXAP_FIRST_PROGRAM’, ‘STAGE10’, ‘ARGUMENT1’); IF (NOT l_CONC_PROG_SUBMIT) THEN RAISE submitprog_failed; END IF; l_CONC_PROG_SUBMIT := fnd_submit.submit_program (‘XXAP’, ‘XXAP_SECOND_PROGRAM’, ‘STAGE20’); IF (NOT l_CONC_PROG_SUBMIT) THEN RAISE submitprog_failed; END IF; l_CONC_PROG_SUBMIT := fnd_submit.submit_program (‘XXAP’, ‘XXAP_THIRD_PROGRAM’, ‘STAGE30’); IF (NOT l_CONC_PROG_SUBMIT) THEN RAISE submitprog_failed; END IF; l_CONC_PROG_SUBMIT := fnd_submit.submit_program (‘XXAP’, ‘XXAP_FOURTH_PROGRAM’, ‘STAGE40’); IF (NOT l_CONC_PROG_SUBMIT) THEN RAISE submitprog_failed; END IF; fnd_file.put_line (fnd_file.LOG, 'Calling submit_set'); --l_start_date is to schedule the request SELECT TO_CHAR (SYSDATE, 'DD - MON - YYYY HH24:MI:SS') INTO l_start_date FROM DUAL; req_id := FND_SUBMIT.submit_set (start_time => l_start_date, sub_request => FALSE); IF (req_id = 0) THEN RAISE submitset_failed; END IF; EXCEPTION WHEN srs_failed THEN p_errbuf := 'Call to set_request_set failed: ' || fnd_message.get; p_retcode := 2; fnd_file.put_line (fnd_file.LOG, p_errbuf); WHEN submitprog_failed THEN p_errbuf := 'Call to submit_program failed: ' || fnd_message.get; p_retcode := 2; fnd_file.put_line (fnd_file.LOG, p_errbuf); WHEN submitset_failed THEN p_errbuf := 'Call to submit_set failed: ' || fnd_message.get; p_retcode := 2; fnd_file.put_line (fnd_file.LOG, p_errbuf); WHEN OTHERS THEN p_errbuf := 'Request set submission failed - unknown error: ' || SQLERRM; p_retcode := 2; fnd_file.put_line (fnd_file.LOG, p_errbuf); END;
Source: https://oraclesoadiscussion.wordpress.com/2015/03/05/submitting-request-set-from-backend/
thanks for sharing this useful information
ReplyDelete