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.RLM_PS_SV dependencies on RLM_MESSAGE_SV

Line 56: x_purge_rec rlm_message_sv.t_PurExp_rec;

52: v_partial_schedule BOOLEAN;
53: x_request_id NUMBER;
54: e_no_data_found EXCEPTION;
55: -- p_org_id NUMBER := NULL;
56: x_purge_rec rlm_message_sv.t_PurExp_rec;
57: v_statement VARCHAR2(32000);
58: v_int_statement VARCHAR2(32000);
59: v_arch_statement VARCHAR2(32000);
60: v_schedule_ref_no NUMBER;

Line 84: rlm_message_sv.populate_req_id;

80: rlm_core_sv.start_debug;
81: rlm_core_sv.dpush(C_SDEBUG,'PurgeSchedule');
82: END IF;
83: --
84: rlm_message_sv.populate_req_id;
85: --
86: IF(p_schedule_ref_no IS NOT NULL) THEN
87: --
88: v_schedule_source := substr(p_schedule_ref_no,1,1);

Line 311: rlm_message_sv.sql_error('rlm_ps_sv.PurgeSchedule', v_Progress);

307: p_delete_beyond_days => p_delete_beyond_days,
308: p_authorization => p_authorization,
309: p_status => p_status);
310: --
311: rlm_message_sv.sql_error('rlm_ps_sv.PurgeSchedule', v_Progress);
312: --
313: IF (l_debug <> -1) THEN
314: rlm_core_sv.dpop(C_SDEBUG);
315: END IF;

Line 340: rlm_message_sv.sql_error('rlm_ps_sv.PurgeSchedule', v_Progress);

336: p_delete_beyond_days => p_delete_beyond_days,
337: p_authorization => p_authorization,
338: p_status => p_status);
339: --
340: rlm_message_sv.sql_error('rlm_ps_sv.PurgeSchedule', v_Progress);
341: rlm_message_sv.dump_messages;
342: --
343: IF (l_debug <> -1) THEN
344: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));

Line 341: rlm_message_sv.dump_messages;

337: p_authorization => p_authorization,
338: p_status => p_status);
339: --
340: rlm_message_sv.sql_error('rlm_ps_sv.PurgeSchedule', v_Progress);
341: rlm_message_sv.dump_messages;
342: --
343: IF (l_debug <> -1) THEN
344: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
345: END IF;

Line 389: x_purge_rec rlm_message_sv.t_PurExp_rec;

385: v_partial_schedule BOOLEAN;
386: x_request_id NUMBER;
387: e_no_data_found EXCEPTION;
388: p_org_id NUMBER := NULL;
389: x_purge_rec rlm_message_sv.t_PurExp_rec;
390: --
391: TYPE ref_demand_cur IS REF CURSOR;
392: c_demand ref_demand_cur;
393: oe_demand ref_demand_cur;

Line 468: rlm_message_sv.app_purge_error (x_ExceptionLevel => 'E',

464: END IF;
465:
466: --insert exception
467:
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,

Line 535: rlm_message_sv.insert_purge_row (x_ExceptionLevel => 'X',

531: END IF;
532:
533:
534: --store exception
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,

Line 566: rlm_message_sv.app_purge_error (x_ExceptionLevel => 'E',

562: rlm_core_sv.dlog(C_DEBUG,'Authorization exists, Retaining....',v_sched_header_id);
563: END IF;
564:
565: --store exception retained
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,

Line 580: rlm_message_sv.insert_purge_row (x_ExceptionLevel => 'X',

576: ELSE
577:
578: --store exception
579:
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,

Line 634: rlm_message_sv.insert_purge_row (x_ExceptionLevel => 'X',

630:
631: IF(p_authorization = 'Y') THEN
632:
633: --store exception purgable
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,

Line 660: rlm_message_sv.app_purge_error (x_ExceptionLevel => 'E',

656:
657: IF(v_line_count > 0) THEN
658:
659: --store exception retained
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,

Line 680: rlm_message_sv.insert_purge_row (x_ExceptionLevel => 'X',

676:
677: null;
678:
679: --store exception purgable
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,

Line 720: rlm_message_sv.sql_error('rlm_ps_sv.PurgeArchive', v_Progress);

716: EXCEPTION
717:
718: when others then
719:
720: rlm_message_sv.sql_error('rlm_ps_sv.PurgeArchive', v_Progress);
721: rlm_message_sv.dump_messages;
722: --
723: IF (l_debug <> -1) THEN
724: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));

Line 721: rlm_message_sv.dump_messages;

717:
718: when others then
719:
720: rlm_message_sv.sql_error('rlm_ps_sv.PurgeArchive', v_Progress);
721: rlm_message_sv.dump_messages;
722: --
723: IF (l_debug <> -1) THEN
724: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
725: END IF;

Line 772: x_purge_rec rlm_message_sv.t_PurExp_rec;

768: v_partial_schedule BOOLEAN;
769: x_request_id NUMBER;
770: e_no_data_found EXCEPTION;
771: p_org_id NUMBER := NULL;
772: x_purge_rec rlm_message_sv.t_PurExp_rec;
773: --
774: TYPE ref_demand_cur IS REF CURSOR;
775: c_demand ref_demand_cur;
776: oe_demand ref_demand_cur;

Line 852: rlm_message_sv.app_purge_error (x_ExceptionLevel => 'E',

848: END IF;
849:
850: --insert exception
851:
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,

Line 911: rlm_message_sv.insert_purge_row (x_ExceptionLevel => 'X',

907: rlm_core_sv.dlog(C_DEBUG,'Deleting...',v_sched_header_id);
908: END IF;
909:
910: --store exception
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,

Line 952: rlm_message_sv.app_purge_error (x_ExceptionLevel => 'E',

948: rlm_core_sv.dlog(C_DEBUG,'Authorization exists, Retaining....',v_sched_header_id);
949: END IF;
950:
951: --store exception retained
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,

Line 964: rlm_message_sv.insert_purge_row (x_ExceptionLevel => 'X',

960: ELSE
961:
962: --store exception
963:
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,

Line 1008: rlm_message_sv.insert_purge_row (x_ExceptionLevel => 'X',

1004:
1005: IF(p_authorization = 'Y') THEN
1006:
1007: --store exception purgable
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,

Line 1033: rlm_message_sv.app_purge_error (x_ExceptionLevel => 'E',

1029:
1030: IF(v_line_count > 0) THEN
1031:
1032: --store exception retained
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,

Line 1052: rlm_message_sv.insert_purge_row (x_ExceptionLevel => 'X',

1048:
1049: null;
1050:
1051: --store exception purgable
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,

Line 1088: rlm_message_sv.sql_error('rlm_ps_sv.PurgeInterface', v_Progress);

1084: --
1085: EXCEPTION
1086: WHEN OTHERS THEN
1087: --
1088: rlm_message_sv.sql_error('rlm_ps_sv.PurgeInterface', v_Progress);
1089: rlm_message_sv.dump_messages;
1090: --
1091: IF (l_debug <> -1) THEN
1092: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));

Line 1089: rlm_message_sv.dump_messages;

1085: EXCEPTION
1086: WHEN OTHERS THEN
1087: --
1088: rlm_message_sv.sql_error('rlm_ps_sv.PurgeInterface', v_Progress);
1089: rlm_message_sv.dump_messages;
1090: --
1091: IF (l_debug <> -1) THEN
1092: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
1093: END IF;

Line 1165: rlm_message_sv.sql_error('rlm_ps_sv.RunReport', v_Progress);

1161: EXCEPTION
1162: --
1163: WHEN OTHERS THEN
1164: --
1165: rlm_message_sv.sql_error('rlm_ps_sv.RunReport', v_Progress);
1166: rlm_message_sv.dump_messages;
1167: --
1168: IF (l_debug <> -1) THEN
1169: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));

Line 1166: rlm_message_sv.dump_messages;

1162: --
1163: WHEN OTHERS THEN
1164: --
1165: rlm_message_sv.sql_error('rlm_ps_sv.RunReport', v_Progress);
1166: rlm_message_sv.dump_messages;
1167: --
1168: IF (l_debug <> -1) THEN
1169: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
1170: END IF;

Line 1407: rlm_message_sv.sql_error('rlm_ps_sv.BuildQuery', v_Progress);

1403: --
1404: EXCEPTION
1405:
1406: When others then
1407: rlm_message_sv.sql_error('rlm_ps_sv.BuildQuery', v_Progress);
1408: rlm_message_sv.dump_messages;
1409: --
1410: IF (l_debug <> -1) THEN
1411: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));

Line 1408: rlm_message_sv.dump_messages;

1404: EXCEPTION
1405:
1406: When others then
1407: rlm_message_sv.sql_error('rlm_ps_sv.BuildQuery', v_Progress);
1408: rlm_message_sv.dump_messages;
1409: --
1410: IF (l_debug <> -1) THEN
1411: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
1412: END IF;

Line 1422: x_purge_rec rlm_message_sv.t_PurExp_rec)

1418:
1419: /* Checks for Open Order Associated with a Schedule */
1420:
1421: FUNCTION CheckOpenOrder (p_schedule_header_id NUMBER,
1422: x_purge_rec rlm_message_sv.t_PurExp_rec)
1423: RETURN BOOLEAN
1424:
1425: IS
1426:

Line 1534: rlm_message_sv.app_purge_error (x_ExceptionLevel => 'E',

1530: END IF;
1531:
1532: --insert exception
1533:
1534: rlm_message_sv.app_purge_error (x_ExceptionLevel => 'E',
1535: x_MessageName => 'RLM_OPEN_ORDER',
1536: x_ErrorText => 'RLM_OPEN_ORDER',
1537: x_ScheduleHeaderId => p_schedule_header_id,
1538: x_ScheduleLineId => v_sched_line_id,

Line 1565: rlm_message_sv.sql_error('rlm_ps_sv.CheckOpenOrder', v_Progress);

1561:
1562: EXCEPTION
1563:
1564: When others then
1565: rlm_message_sv.sql_error('rlm_ps_sv.CheckOpenOrder', v_Progress);
1566: rlm_message_sv.dump_messages;
1567: --
1568: IF (l_debug <> -1) THEN
1569: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));

Line 1566: rlm_message_sv.dump_messages;

1562: EXCEPTION
1563:
1564: When others then
1565: rlm_message_sv.sql_error('rlm_ps_sv.CheckOpenOrder', v_Progress);
1566: rlm_message_sv.dump_messages;
1567: --
1568: IF (l_debug <> -1) THEN
1569: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
1570: END IF;