Submitting a Concurrent Request from BackEnd in Oracle apps


Sometimes there will be some validation that prevents us to submit Concurrent Request from frontend. So at that time we can submit the concurrent request from backend.

Below is the script to submit concurrent request from backend.

DECLARE
LN_REQUEST_ID   NUMBER := 0;
BEGIN
MO_GLOBAL.SET_POLICY_CONTEXT (‘S’, 567);
FND_GLOBAL.APPS_INITIALIZE (USER_ID           => 10835,
RESP_ID           => 51546,
RESP_APPL_ID      => 200
);
LN_REQUEST_ID :=
FND_REQUEST.SUBMIT_REQUEST
(APPLICATION      => ‘IBY’,
PROGRAM          => ‘IBY_FD_PAYMENT_FORMAT’,
DESCRIPTION      => ‘Format Payment Instructions’,
START_TIME       => SYSDATE,
SUB_REQUEST      => FALSE,
ARGUMENT1        => 46602,
ARGUMENT2        => ‘N’
);

IF LN_REQUEST_ID = 0
THEN
INSERT INTO OAF_DEBUG_TEMP
VALUES (SYSDATE, 1, ‘Concurrent Request Failed to Submit.’, NULL);
ELSE
INSERT INTO OAF_DEBUG_TEMP
VALUES (SYSDATE, 1, ‘Concurrent Request Successfully  Submitted’,
LN_REQUEST_ID);
END IF;

COMMIT;
EXCEPTION
WHEN OTHERS
THEN
INSERT INTO OAF_DEBUG_TEMP
VALUES (SYSDATE, 1, ‘Inside Exception’, NULL);
END;

Thank you.

 

About pacesettergraam

A good and realistic person

Posted on March 24, 2016, in Oracle, oracle apps and tagged , , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: