DBA Data[Home] [Help]

APPS.RLM_PS_SV dependencies on FND_GLOBAL

Line 248: and request_id <> fnd_global.conc_request_id;

244: FORALL counter in 1..g_schedule_headers_tab.COUNT
245: --
246: DELETE from rlm_demand_exceptions
247: where schedule_header_id= g_schedule_headers_tab(counter)
248: and request_id <> fnd_global.conc_request_id;
249: --
250: IF (l_debug <> -1) THEN
251: rlm_core_sv.dlog(C_DEBUG, 'No of Schedule Exception Lines Deleted ', SQL%ROWCOUNT);
252: END IF;

Line 258: and request_id <> fnd_global.conc_request_id;

254: FORALL counter in 1..g_interface_headers_tab.COUNT
255: --
256: DELETE from rlm_demand_exceptions
257: where interface_header_id= g_interface_headers_tab(counter)
258: and request_id <> fnd_global.conc_request_id;
259: --
260: IF (l_debug <> -1) THEN
261: rlm_core_sv.dlog(C_DEBUG, 'No of Interface Exception Lines Deleted ', SQL%ROWCOUNT);
262: END IF;

Line 472: x_conc_req_id => fnd_global.conc_request_id,

468: rlm_message_sv.app_purge_error (x_ExceptionLevel => 'E',
469: x_MessageName => 'RLM_PARTIAL_SELECTION',
470: x_ErrorText => 'RLM_PARTIAL_SELECTION',
471: x_ScheduleHeaderId => v_sched_header_id,
472: x_conc_req_id => fnd_global.conc_request_id,
473: x_PurgeStatus => 'N',
474: x_PurgeExp_rec=>x_purge_rec);
475:
476: v_partial_schedule := TRUE;

Line 539: x_conc_req_id => fnd_global.conc_request_id,

535: rlm_message_sv.insert_purge_row (x_ExceptionLevel => 'X',
536: x_MessageName => 'SUCCESS',
537: x_ErrorText => '',
538: x_ScheduleHeaderId => v_sched_header_id,
539: x_conc_req_id => fnd_global.conc_request_id,
540: x_PurgeStatus => 'Y',
541: x_PurgeExp_rec=>x_purge_rec );
542:
543:

Line 570: x_conc_req_id => fnd_global.conc_request_id,

566: rlm_message_sv.app_purge_error (x_ExceptionLevel => 'E',
567: x_MessageName => 'RLM_AUTHORIZATION_FOUND',
568: x_ErrorText => 'RLM_AUTHORIZATION_FOUND',
569: x_ScheduleHeaderId => v_sched_header_id,
570: x_conc_req_id => fnd_global.conc_request_id,
571: x_PurgeStatus => 'N',
572: x_PurgeExp_rec=>x_purge_rec );
573:
574: null;

Line 584: x_conc_req_id => fnd_global.conc_request_id,

580: rlm_message_sv.insert_purge_row (x_ExceptionLevel => 'X',
581: x_MessageName => 'SUCCESS',
582: x_ErrorText => '',
583: x_ScheduleHeaderId => v_sched_header_id,
584: x_conc_req_id => fnd_global.conc_request_id,
585: x_PurgeStatus => 'Y',
586: x_PurgeExp_rec=>x_purge_rec );
587:
588:

Line 638: x_conc_req_id => fnd_global.conc_request_id,

634: rlm_message_sv.insert_purge_row (x_ExceptionLevel => 'X',
635: x_MessageName => 'PURGABLE',
636: x_ErrorText => '',
637: x_ScheduleHeaderId => v_sched_header_id,
638: x_conc_req_id => fnd_global.conc_request_id,
639: x_PurgeStatus => 'Y',
640: x_PurgeExp_rec=>x_purge_rec );
641:
642: IF (l_debug <> -1) THEN

Line 664: x_conc_req_id => fnd_global.conc_request_id,

660: rlm_message_sv.app_purge_error (x_ExceptionLevel => 'E',
661: x_MessageName => 'RLM_AUTHORIZATION_FOUND',
662: x_ErrorText => 'RLM_AUTHORIZATION_FOUND',
663: x_ScheduleHeaderId => v_sched_header_id,
664: x_conc_req_id => fnd_global.conc_request_id,
665: x_PurgeStatus => 'N',
666: x_PurgeExp_rec=>x_purge_rec );
667:
668:

Line 684: x_conc_req_id => fnd_global.conc_request_id,

680: rlm_message_sv.insert_purge_row (x_ExceptionLevel => 'X',
681: x_MessageName => 'PURGABLE',
682: x_ErrorText => '',
683: x_ScheduleHeaderId => v_sched_header_id,
684: x_conc_req_id => fnd_global.conc_request_id,
685: x_PurgeStatus => 'Y',
686: x_PurgeExp_rec=>x_purge_rec );
687:
688:

Line 856: x_conc_req_id => fnd_global.conc_request_id,

852: rlm_message_sv.app_purge_error (x_ExceptionLevel => 'E',
853: x_MessageName => 'RLM_PARTIAL_SELECTION',
854: x_ErrorText => 'RLM_PARTIAL_SELECTION',
855: x_ScheduleHeaderId => v_sched_header_id,
856: x_conc_req_id => fnd_global.conc_request_id,
857: x_PurgeStatus => 'N',
858: x_PurgeExp_rec=>x_purge_rec);
859:
860: v_partial_schedule := TRUE;

Line 915: x_conc_req_id => fnd_global.conc_request_id,

911: rlm_message_sv.insert_purge_row (x_ExceptionLevel => 'X',
912: x_MessageName => 'SUCCESS',
913: x_ErrorText => '',
914: x_ScheduleHeaderId => v_sched_header_id,
915: x_conc_req_id => fnd_global.conc_request_id,
916: x_PurgeStatus => 'Y',
917: x_PurgeExp_rec=>x_purge_rec );
918: --
919: delete from rlm_interface_lines where header_id = v_sched_header_id;

Line 956: x_conc_req_id => fnd_global.conc_request_id,

952: rlm_message_sv.app_purge_error (x_ExceptionLevel => 'E',
953: x_MessageName => 'RLM_AUTHORIZATION_FOUND',
954: x_ErrorText => 'RLM_AUTHORIZATION_FOUND',
955: x_ScheduleHeaderId => v_sched_header_id,
956: x_conc_req_id => fnd_global.conc_request_id,
957: x_PurgeStatus => 'N',
958: x_PurgeExp_rec=>x_purge_rec );
959:
960: ELSE

Line 968: x_conc_req_id => fnd_global.conc_request_id,

964: rlm_message_sv.insert_purge_row (x_ExceptionLevel => 'X',
965: x_MessageName => 'SUCCESS',
966: x_ErrorText => '',
967: x_ScheduleHeaderId => v_sched_header_id,
968: x_conc_req_id => fnd_global.conc_request_id,
969: x_PurgeStatus => 'Y',
970: x_PurgeExp_rec=>x_purge_rec );
971:
972:

Line 1012: x_conc_req_id => fnd_global.conc_request_id,

1008: rlm_message_sv.insert_purge_row (x_ExceptionLevel => 'X',
1009: x_MessageName => 'PURGABLE',
1010: x_ErrorText => '',
1011: x_ScheduleHeaderId => v_sched_header_id,
1012: x_conc_req_id => fnd_global.conc_request_id,
1013: x_PurgeStatus => 'Y',
1014: x_PurgeExp_rec=>x_purge_rec );
1015:
1016: IF (l_debug <> -1) THEN

Line 1037: x_conc_req_id => fnd_global.conc_request_id,

1033: rlm_message_sv.app_purge_error (x_ExceptionLevel => 'E',
1034: x_MessageName => 'RLM_AUTHORIZATION_FOUND',
1035: x_ErrorText => 'RLM_AUTHORIZATION_FOUND',
1036: x_ScheduleHeaderId => v_sched_header_id,
1037: x_conc_req_id => fnd_global.conc_request_id,
1038: x_PurgeStatus => 'N',
1039: x_PurgeExp_rec=>x_purge_rec );
1040:
1041:

Line 1056: x_conc_req_id => fnd_global.conc_request_id,

1052: rlm_message_sv.insert_purge_row (x_ExceptionLevel => 'X',
1053: x_MessageName => 'PURGABLE',
1054: x_ErrorText => '',
1055: x_ScheduleHeaderId => v_sched_header_id,
1056: x_conc_req_id => fnd_global.conc_request_id,
1057: x_PurgeStatus => 'Y',
1058: x_PurgeExp_rec=>x_purge_rec );
1059:
1060:

Line 1138: argument1 =>fnd_global.conc_request_id,

1134: fnd_request.set_org_id(p_org_id);
1135: --
1136: x_request_id := fnd_request.submit_request (application => 'RLM',
1137: program => 'RLMPSRP',
1138: argument1 =>fnd_global.conc_request_id,
1139: argument2 =>p_execution_mode,
1140: argument3 =>p_translator_code_from,
1141: argument4 =>p_translator_code_to,
1142: argument5 =>p_customer,

Line 1542: x_conc_req_id => fnd_global.conc_request_id,

1538: x_ScheduleLineId => v_sched_line_id,
1539: x_OrderHeaderId => v_order_header,
1540: x_OrderLineId => v_order_line,
1541: x_ScheduleLineNum => v_line_number, --bugfix 6319027
1542: x_conc_req_id => fnd_global.conc_request_id,
1543: x_PurgeStatus => 'N',
1544: x_PurgeExp_rec=>x_purge_rec );
1545:
1546: --EXIT;