How to submit request set from backend in oracle apps

How to submit request set from backend in oracle apps

In this post , We will be discuss about how to submit request set from backend in oracle apps. Oracle has provided the standard API to submit the request set in oracle apps from backend. We can submit any request set from backend in oracle apps to execute in oracle apps using this standard api. We can also pass the concurrent program parameters using this API in oracle apps. Here below is the complete detail about How to submit request set from backend in oracle apps.

How to submit request set from backend in oracle apps

Important API to submit request set from backend in oracle apps

FND_SUBMIT.SUBMIT_SET

PLSQL Script to submit request set from backend in oracle apps

DECLARE 

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

V_REQUEST_SET_EXIST :=

FND_SUBMIT.set_request_set (application   => 'XXGL',

request_set   => 'XXTEST');

IF (NOT V_REQUEST_SET_EXIST)

THEN

RAISE srs_failed;

END IF;

fnd_file.put_line (fnd_file.LOG, 'Calling REQUEST SET first stage');

l_CONC_PROG_SUBMIT :=

fnd_submit.submit_program ('XXGL',

'FIRST_PROGRAM',

'STAGE10',

'ARGUMENT1');

IF (NOT l_CONC_PROG_SUBMIT)

THEN

RAISE submitprog_failed;

END IF;

l_CONC_PROG_SUBMIT :=

fnd_submit.submit_program ('XXGL',

'SECOND_PROGRAM',

'STAGE20');

IF (NOT l_CONC_PROG_SUBMIT)

THEN

RAISE submitprog_failed;

END IF;

l_CONC_PROG_SUBMIT :=

fnd_submit.submit_program ('XXGL',

'THIRD_PROGRAM',

'STAGE30');

IF (NOT l_CONC_PROG_SUBMIT)

THEN

RAISE submitprog_failed;

END IF;

l_CONC_PROG_SUBMIT :=

fnd_submit.submit_program ('XXGL',

'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');

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;

How to submit request set from backend in oracle apps

How to submit request set from backend in oracle apps