eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_REQUEST_SET dependencies on FND_REQUEST

Line 1: package body FND_REQUEST_SET as

1: package body FND_REQUEST_SET as
2: /* $Header: AFRSSUBB.pls 120.18 2011/12/21 23:13:00 ckclark ship $ */
3:
4:
5: -- Used to get stage function values

Line 82: from fnd_request_sets_vl frs, fnd_application fa

78:
79: /*Bug 5680669 -START-*/
80: select fa.application_short_name,frs.request_set_name
81: into t_app_name, req_set_name
82: from fnd_request_sets_vl frs, fnd_application fa
83: where frs.application_id=appl_id
84: and frs.request_set_id=set_id
85: and frs.application_id=fa.application_id;
86:

Line 111: from fnd_request_sets sets,

107: /* Get info for first stage. */
108: begin
109: select request_set_stage_id, request_set_stage_id, user_stage_name
110: into stage_id, next_stage, request_desc
111: from fnd_request_sets sets,
112: fnd_request_set_stages_vl stages
113: where sets.application_id = appl_id
114: and sets.request_set_id = set_id
115: and stages.set_application_id = sets.application_id

Line 112: fnd_request_set_stages_vl stages

108: begin
109: select request_set_stage_id, request_set_stage_id, user_stage_name
110: into stage_id, next_stage, request_desc
111: from fnd_request_sets sets,
112: fnd_request_set_stages_vl stages
113: where sets.application_id = appl_id
114: and sets.request_set_id = set_id
115: and stages.set_application_id = sets.application_id
116: and stages.request_set_id = sets.request_set_id

Line 151: select LAST_UPDATE_DATE into rset_last_updated_date from FND_REQUEST_SETS sets

147: critical_outcome := substr(req_data, pos2 + 1);
148: if (runinfo_id = 'C') then
149: begin
150: select REQUEST_DATE into req_request_date from FND_CONCURRENT_REQUESTS where REQUEST_ID = conc_req_id;
151: select LAST_UPDATE_DATE into rset_last_updated_date from FND_REQUEST_SETS sets
152: where REQUEST_SET_ID = set_id AND application_id = appl_id;
153: SELECT max(last_update_date) INTO tmpDate FROM fnd_request_set_stages
154: WHERE request_set_id = set_id
155: AND SET_APPLICATION_ID = appl_id;

Line 153: SELECT max(last_update_date) INTO tmpDate FROM fnd_request_set_stages

149: begin
150: select REQUEST_DATE into req_request_date from FND_CONCURRENT_REQUESTS where REQUEST_ID = conc_req_id;
151: select LAST_UPDATE_DATE into rset_last_updated_date from FND_REQUEST_SETS sets
152: where REQUEST_SET_ID = set_id AND application_id = appl_id;
153: SELECT max(last_update_date) INTO tmpDate FROM fnd_request_set_stages
154: WHERE request_set_id = set_id
155: AND SET_APPLICATION_ID = appl_id;
156: IF( tmpDate > rset_last_updated_date) THEN
157: rset_last_updated_date := tmpDate;

Line 159: SELECT max(last_update_date) INTO tmpDate FROM fnd_request_set_programs

155: AND SET_APPLICATION_ID = appl_id;
156: IF( tmpDate > rset_last_updated_date) THEN
157: rset_last_updated_date := tmpDate;
158: END IF;
159: SELECT max(last_update_date) INTO tmpDate FROM fnd_request_set_programs
160: WHERE request_set_id = set_id AND set_application_id = appl_id;
161: IF( tmpDate > rset_last_updated_date) THEN
162: rset_last_updated_date := tmpDate;
163: END IF;

Line 188: SELECT REQUEST_SET_PROGRAM_ID FROM FND_REQUEST_SET_PROGRAMS WHERE SET_APPLICATION_ID = appl_id

184: and error_stage_id = to_number(fcr2.argument3)
185: AND r.request_set_program_id IS NOT NULL
186: AND r.request_set_program_id NOT IN
187: (
188: SELECT REQUEST_SET_PROGRAM_ID FROM FND_REQUEST_SET_PROGRAMS WHERE SET_APPLICATION_ID = appl_id
189: AND REQUEST_SET_ID = set_id AND REQUEST_SET_STAGE_ID = error_stage_id
190: );
191: if( tmp_number <> 0)THEN
192: errbuf := gen_error('FNDRSSUB', SQLCODE, 'Request Set Definition Changed');

Line 212: from fnd_request_set_stages_vl stages

208: stage_id := error_stage_id;
209: error_stage_id := null;
210: select request_set_stage_id, user_stage_name
211: into next_stage, request_desc
212: from fnd_request_set_stages_vl stages
213: where stages.set_application_id = appl_id
214: and stages.request_set_id = set_id
215: and stages.request_set_stage_id = stage_id;
216: exception

Line 234: fnd_message.set_token('ROUTINE', 'FND_REQUEST_SET.FNDRSSUB');

230: where request_id = req_id;
231: exception
232: when NO_DATA_FOUND then
233: fnd_message.set_name('FND','CONC-Missing Request');
234: fnd_message.set_token('ROUTINE', 'FND_REQUEST_SET.FNDRSSUB');
235: fnd_message.set_token('REQUEST', to_char(req_id));
236: errbuf := fnd_message.get;
237: retcode := 2;
238: return;

Line 244: from fnd_request_set_stages_vl

240: /* Get Next Stage and Critical info*/
241: begin
242: select decode(current_outcome, 'S', success_link, 'W', warning_link, error_link), critical, user_stage_name
243: into next_stage, is_critical, user_stage_name
244: from fnd_request_set_stages_vl
245: where request_set_id = set_id
246: and set_application_id = appl_id
247: and request_set_stage_id = stage_id;
248: exception

Line 323: from fnd_request_set_stages_vl

319: /* Get next stage */
320: begin
321: Select user_stage_name
322: into request_desc
323: from fnd_request_set_stages_vl
324: where request_set_id = set_id
325: and set_application_id = appl_id
326: and request_set_stage_id = next_stage;
327: exception

Line 343: fnd_request.internal(type=>'S');

339: end;
340: end if;
341: end if;
342: /* Submit Request for the stage. */
343: fnd_request.internal(type=>'S');
344: req_id := fnd_request.submit_request('FND', 'FNDRSSTG',
345: request_desc, NULL, TRUE,
346: to_char(appl_id), to_char(set_Id),
347: to_char(next_stage),

Line 344: req_id := fnd_request.submit_request('FND', 'FNDRSSTG',

340: end if;
341: end if;
342: /* Submit Request for the stage. */
343: fnd_request.internal(type=>'S');
344: req_id := fnd_request.submit_request('FND', 'FNDRSSTG',
345: request_desc, NULL, TRUE,
346: to_char(appl_id), to_char(set_Id),
347: to_char(next_stage),
348: to_char(fnd_global.conc_request_id),to_char(restart_flag));

Line 427: from fnd_request_set_programs sp, fnd_run_requests r,

423: argument81, argument82, argument83, argument84, argument85,
424: argument86, argument87, argument88, argument89, argument90,
425: argument91, argument92, argument93, argument94, argument95,
426: argument96, argument97, argument98, argument99, argument100, r.org_id
427: from fnd_request_set_programs sp, fnd_run_requests r,
428: fnd_concurrent_programs cp, fnd_application a
429: where sp.set_application_id = appl_id
430: and sp.request_set_id = set_id
431: and sp.request_set_stage_id = stage_id

Line 479: from fnd_request_set_programs sp, fnd_run_requests r,

475: r.argument81, r.argument82, r.argument83, r.argument84, r.argument85,
476: r.argument86, r.argument87, r.argument88, r.argument89, r.argument90,
477: r.argument91, r.argument92, r.argument93, r.argument94, r.argument95,
478: r.argument96, r.argument97, r.argument98, r.argument99, r.argument100, r.org_id
479: from fnd_request_set_programs sp, fnd_run_requests r,
480: fnd_concurrent_programs cp, fnd_application a, fnd_concurrent_requests fcr1, fnd_concurrent_requests fcr2
481: where sp.set_application_id = appl_id
482: and sp.request_set_id = set_id
483: and sp.request_set_stage_id = stage_id

Line 577: from fnd_request_set_stages s, fnd_executables e

573: s.function_id, s.function_application_id
574: into hardwired_outcome, funct,
575: g_set_appl_id, g_set_id, g_stage_id,
576: g_function_id, g_function_appl_id
577: from fnd_request_set_stages s, fnd_executables e
578: where s.set_application_id = appl_id
579: and s.request_set_id = set_id
580: and s.request_set_stage_id = stage_id
581: and e.executable_id(+) = s.function_id

Line 620: if (not fnd_request.set_print_options(

616:
617: open stage_req_printers(parent_id, req.request_set_program_id);
618: fetch stage_req_printers into printer, copies;
619: if (stage_req_printers%found) then
620: if (not fnd_request.set_print_options(
621: printer => printer,
622: style => req.print_style,
623: copies => copies,
624: save_output => (req.save_output_flag = 'Y'),

Line 636: if (not fnd_request.add_printer(

632: end if;
633:
634: fetch stage_req_printers into printer, copies;
635: while (stage_req_printers%found) loop
636: if (not fnd_request.add_printer(
637: printer => printer,
638: copies => copies)) then
639: errbuf := substr(fnd_message.get, 1, 240);
640: retcode := 2;

Line 648: if (not fnd_request.set_print_options(

644: end if;
645: fetch stage_req_printers into printer, copies;
646: end loop;
647: else
648: if (not fnd_request.set_print_options(
649: printer => null,
650: style => req.print_style,
651: copies => 0,
652: save_output => (req.save_output_flag = 'Y'),

Line 666: if (not fnd_request.add_notification(

662: close stage_req_printers;
663:
664: for notify_rec in stage_req_notifications
665: (parent_id, req.request_set_program_id) loop
666: if (not fnd_request.add_notification(
667: user=>notify_rec.notify)) then
668: /* 3900886: User not found in wf_roles, continue with warning */
669: if (errbuf is NULL) then
670: errbuf := substr(fnd_message.get||

Line 690: if (not fnd_request.add_layout(

686: t_language,
687: t_territory,
688: t_format;
689: while (stage_req_layouts%found) loop
690: if (not fnd_request.add_layout(
691: t_app_name,
692: t_code,
693: t_language,
694: t_territory,

Line 716: if (not fnd_request.add_delivery_option(

712: /* set delivery pp actions for this request */
713: for delivery_rec in stage_req_delivery
714: (parent_id, req.request_set_program_id)
715: loop
716: if (not fnd_request.add_delivery_option(
717: delivery_rec.argument1,
718: delivery_rec.argument2,
719: delivery_rec.argument3,
720: delivery_rec.argument4,

Line 737: if (not fnd_request.set_options(language=>req.nls_language,

733: end loop;
734:
735:
736: /* NLS Project - Added Numeric Character to set_options */
737: if (not fnd_request.set_options(language=>req.nls_language,
738: territory=>req.nls_territory,
739: datagroup=>'',
740: numeric_characters=>req.numeric_characters)) then
741: errbuf := substr(fnd_message.get, 1, 240);

Line 747: fnd_request.internal(critical => req.critical, type=>'P');

743: rollback;
744: return;
745: end if;
746:
747: fnd_request.internal(critical => req.critical, type=>'P');
748:
749: /* MOAC */
750: fnd_request.set_org_id(req.org_id);
751:

Line 750: fnd_request.set_org_id(req.org_id);

746:
747: fnd_request.internal(critical => req.critical, type=>'P');
748:
749: /* MOAC */
750: fnd_request.set_org_id(req.org_id);
751:
752: req_id := fnd_request.submit_request(
753: req.application_short_name, req.concurrent_program_name,
754: Null, NULL, TRUE,

Line 752: req_id := fnd_request.submit_request(

748:
749: /* MOAC */
750: fnd_request.set_org_id(req.org_id);
751:
752: req_id := fnd_request.submit_request(
753: req.application_short_name, req.concurrent_program_name,
754: Null, NULL, TRUE,
755: req.argument1, req.argument2, req.argument3,
756: req.argument4, req.argument5, req.argument6,

Line 922: for request in fnd_request_set.stage_request_info loop

918:
919: <>
920: for i in 1 .. stage_looptimes loop
921: stillrunning := FALSE;
922: for request in fnd_request_set.stage_request_info loop
923: if (request.exit_status = 'E') then
924: return 'E';
925: elsif (request.exit_status = 'R') then
926: stillrunning := TRUE;

Line 977: end FND_REQUEST_SET;

973: return null;
974: end;
975:
976:
977: end FND_REQUEST_SET;