Sign in or 

| Platform: | Oracle | App: | Application Object Library | Tool: | |
| DB Ver: | 9.2 | App Ver: | 11.5.8 | Tool Ver: | |
| Revision Date: | 02-Aug-2006 | Keywords: | HOWTO, CONCURRENT REQUEST SET, PROGRAMMATICALLY LAUNCH | ||
| Goal | |||||
| To launch a request set programmatically. | |||||
| Facts | |||||
| Solution | |||||
When programmatically launching a request set, base it on the following skeleton code. Couple of points to note first:
l_action := 'Launching Request Set'; DBMS_OUTPUT.PUT_LINE(l_action); l_ok := fnd_submit.set_request_set -- ------------------------------------(application => 'XX' -- Stage 1 with 2 requests in the stage -- ----------------------------------- IF l_ok AND l_success = 0 THEN -- ---------------------------------------------------- l_action := '1st job - 1st stage 1st request'; ELSE(application => 'XX' l_success := -100;END IF; IF l_ok AND l_success = 0 THEN -- ---------------------------------------------------- l_action := '2nd job - 1st stage 2nd request'; ELSE(application => 'XX' l_success := -110;END IF; -- -------------------------------------- -- New stage with 1 request -- -------------------------------------- IF l_ok AND l_success = 0 THEN l_action := '3rd job - 2nd stage 1st request'; ELSE(application => 'XX' l_success := -120;END IF; -- -------------------------------------- -- New stage with 1 request with LOTS of -- parameters -- -------------------------------------- IF l_ok AND l_success = 0 THEN l_action := '4th job - 3rd stage 1st request'; ELSE(application => 'AR' l_success := -145;END IF; -- ----------------------------------------------- -- All requests in the set have been submitted now -- ----------------------------------------------- IF l_ok AND l_success = 0 THEN -- ---------------------------------------------------- l_request_id := fnd_submit.submit_set(NULL,FALSE); ELSE(request_id => l_request_id l_success := -150;END IF; IF l_success = 0 THEN p_success := l_request_id;ELSE DBMS_OUTPUT.PUT_LINE('Error: '||l_success||' - Problem with '||l_action);END IF; | |||||
| | |||||
| | |||||
|
consultium |
Latest page update: made by consultium
, Oct 6 2009, 3:02 PM EDT
(about this update
About This Update
No content added or deleted. - complete history) |
|
Keyword tags:
CONCURRENT REQUEST SET
HOW TO
PROGRAMMATICALLY LAUNCH
More Info: links to this page
|