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_DP_SV dependencies on RLM_MESSAGE_SV

Line 99: rlm_message_sv.populate_req_id;

95: IF (l_debug <> -1) THEN
96: rlm_core_sv.dlog(C_DEBUG,'DSP Start time',g_dsp_start_time); --Bugfix 10053830
97: END IF;
98: --
99: rlm_message_sv.populate_req_id;
100: --
101: MO_GLOBAL.set_policy_context(p_access_mode => 'S',
102: p_org_id => p_org_id);
103: --

Line 283: rlm_message_sv.initialize_messages;

279: END IF;
280: --
281: EXIT WHEN c_demand%NOTFOUND;
282: --
283: rlm_message_sv.initialize_messages;
284: --
285: -- bug 2721219
286: --
287: RLM_FORECAST_SV.k_REPLACE_FLAG := TRUE;

Line 327: set request_id = rlm_message_sv.g_conc_req_id

323: END IF;
324: --
325: --Bugfix 6453415 Start
326: update rlm_demand_exceptions
327: set request_id = rlm_message_sv.g_conc_req_id
328: where interface_header_id = v_header_id;
329: --Bugfix 6453415 End
330: --
331: END IF;

Line 488: rlm_message_sv.dump_messages(v_header_id);

484: --
485: UpdateHeaderPS(v_Sched_rec.header_id,
486: v_Sched_rec.schedule_header_id);
487: --
488: rlm_message_sv.dump_messages(v_header_id);
489: --
490: PurgeInterfaceLines(v_header_id);
491: --
492: COMMIT;

Line 527: rlm_message_sv.app_error(

523: IF (l_debug <> -1) THEN
524: rlm_core_sv.dlog(C_DEBUG,'RLM_CONF_SCH_RCD');
525: END IF;
526: --
527: rlm_message_sv.app_error(
528: x_ExceptionLevel => rlm_message_sv.k_warn_level,
529: x_MessageName => 'RLM_CONF_SCH_RCD',
530: x_InterfaceHeaderId => v_sched_rec.header_id,
531: x_InterfaceLineId => null,

Line 528: x_ExceptionLevel => rlm_message_sv.k_warn_level,

524: rlm_core_sv.dlog(C_DEBUG,'RLM_CONF_SCH_RCD');
525: END IF;
526: --
527: rlm_message_sv.app_error(
528: x_ExceptionLevel => rlm_message_sv.k_warn_level,
529: x_MessageName => 'RLM_CONF_SCH_RCD',
530: x_InterfaceHeaderId => v_sched_rec.header_id,
531: x_InterfaceLineId => null,
532: x_ScheduleHeaderId => v_sched_rec.schedule_header_id,

Line 548: rlm_message_sv.dump_messages(v_header_id);

544: --
545: UpdateHeaderPS(v_Sched_rec.header_id,
546: v_Sched_rec.Schedule_header_id);
547: --
548: rlm_message_sv.dump_messages(v_header_id);
549: PurgeInterfaceLines(v_header_id); /*2699981*/
550: --
551: COMMIT;
552: --

Line 559: rlm_message_sv.dump_messages(v_header_id);

555: IF (l_debug <> -1) THEN
556: rlm_core_sv.dlog(C_DEBUG,'No data found ');
557: END IF;
558: --
559: rlm_message_sv.dump_messages(v_header_id);
560: --
561: WHEN e_VDFailed THEN
562: --
563: IF (l_debug <> -1) THEN

Line 578: rlm_message_sv.dump_messages(v_header_id);

574: --
575: UpdateHeaderPS(v_header_id,
576: v_schedule_header_id);
577: --
578: rlm_message_sv.dump_messages(v_header_id);
579: --
580: COMMIT;
581: --
582: WHEN e_ReplaceSchedule THEN

Line 593: rlm_message_sv.dump_messages(v_header_id);

589: rlm_core_sv.k_PS_ERROR);
590:
591: --
592: UpdateHeaderPS(v_header_id, v_schedule_header_id);
593: rlm_message_sv.dump_messages(v_header_id);
594: --
595: COMMIT;
596: --
597: /* Bug 2554058 */

Line 602: rlm_core_sv.dlog(C_DEBUG, 'request ID', RLM_MESSAGE_SV.g_conc_req_id);

598: --
599: WHEN e_testschedule THEN
600: --
601: IF (l_debug <> -1) THEN
602: rlm_core_sv.dlog(C_DEBUG, 'request ID', RLM_MESSAGE_SV.g_conc_req_id);
603: END IF;
604: --
605: rlm_message_sv.app_error(
606: x_ExceptionLevel => rlm_message_sv.k_warn_level,

Line 605: rlm_message_sv.app_error(

601: IF (l_debug <> -1) THEN
602: rlm_core_sv.dlog(C_DEBUG, 'request ID', RLM_MESSAGE_SV.g_conc_req_id);
603: END IF;
604: --
605: rlm_message_sv.app_error(
606: x_ExceptionLevel => rlm_message_sv.k_warn_level,
607: x_MessageName => 'RLM_TEST_SCHEDULE_DETECTED',
608: x_InterfaceHeaderId => v_header_id,
609: x_InterfaceLineId => NULL,

Line 606: x_ExceptionLevel => rlm_message_sv.k_warn_level,

602: rlm_core_sv.dlog(C_DEBUG, 'request ID', RLM_MESSAGE_SV.g_conc_req_id);
603: END IF;
604: --
605: rlm_message_sv.app_error(
606: x_ExceptionLevel => rlm_message_sv.k_warn_level,
607: x_MessageName => 'RLM_TEST_SCHEDULE_DETECTED',
608: x_InterfaceHeaderId => v_header_id,
609: x_InterfaceLineId => NULL,
610: x_OrderLineId => NULL,

Line 614: rlm_message_sv.dump_messages(v_header_id);

610: x_OrderLineId => NULL,
611: x_Token1 => 'SCHED_REF',
612: x_Value1 =>rlm_core_sv.get_schedule_reference_num(v_header_id));
613: --
614: rlm_message_sv.dump_messages(v_header_id);
615: PurgeInterfaceLines(v_header_id); /*2699981*/
616: --
617: COMMIT;
618: --

Line 632: rlm_message_sv.app_error(

628: --
629: /* UpdateHeaderPS(v_header_id,
630: v_schedule_header_id); */
631: --
632: rlm_message_sv.app_error(
633: x_ExceptionLevel => rlm_message_sv.k_error_level,
634: x_MessageName => 'RLM_HEADER_LOCK_NOT_OBTAINED',
635: x_InterfaceHeaderId => v_header_id,
636: x_InterfaceLineId => NULL,

Line 633: x_ExceptionLevel => rlm_message_sv.k_error_level,

629: /* UpdateHeaderPS(v_header_id,
630: v_schedule_header_id); */
631: --
632: rlm_message_sv.app_error(
633: x_ExceptionLevel => rlm_message_sv.k_error_level,
634: x_MessageName => 'RLM_HEADER_LOCK_NOT_OBTAINED',
635: x_InterfaceHeaderId => v_header_id,
636: x_InterfaceLineId => NULL,
637: x_OrderLineId => NULL,

Line 646: rlm_message_sv.dump_messages(v_header_id);

642: rlm_core_sv.dlog(C_DEBUG,'Header could not be locked');
643: rlm_core_sv.dpop(C_SDEBUG, 'RLM_LOCK_NOT_OBTAINED');
644: END IF;
645: --
646: rlm_message_sv.dump_messages(v_header_id);
647: --
648: COMMIT;
649: --
650: WHEN OTHERS THEN

Line 660: rlm_core_sv.dlog(C_DEBUG, 'request ID', RLM_MESSAGE_SV.g_conc_req_id);

656: IF (l_debug <> -1) THEN
657: rlm_core_sv.dlog(C_DEBUG,'when others');
658: rlm_core_sv.dlog(C_DEBUG, 'Return Code', retcode);
659: rlm_core_sv.dlog(C_DEBUG, 'ERROR:', SUBSTR(SQLERRM,1,200));
660: rlm_core_sv.dlog(C_DEBUG, 'request ID', RLM_MESSAGE_SV.g_conc_req_id);
661: END IF;
662: --
663: UpdateGroupPS(v_header_id,
664: v_schedule_header_id,

Line 672: rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);

668: --
669: UpdateHeaderPS(v_header_id,
670: v_schedule_header_id);
671: --
672: rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);
673: --
674: rlm_message_sv.dump_messages(v_header_id);
675: --
676: COMMIT;

Line 674: rlm_message_sv.dump_messages(v_header_id);

670: v_schedule_header_id);
671: --
672: rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);
673: --
674: rlm_message_sv.dump_messages(v_header_id);
675: --
676: COMMIT;
677: --
678: END;

Line 688: rlm_message_sv.initialize_messages;

684: END IF;
685: --
686: IF c_demand%ROWCOUNT = 0 THEN
687: --
688: rlm_message_sv.initialize_messages;
689: --
690: rlm_message_sv.app_error(
691: x_ExceptionLevel => rlm_message_sv.k_error_level,
692: x_MessageName => 'RLM_NO_DATA_FOR_CRITERIA',

Line 690: rlm_message_sv.app_error(

686: IF c_demand%ROWCOUNT = 0 THEN
687: --
688: rlm_message_sv.initialize_messages;
689: --
690: rlm_message_sv.app_error(
691: x_ExceptionLevel => rlm_message_sv.k_error_level,
692: x_MessageName => 'RLM_NO_DATA_FOR_CRITERIA',
693: x_InterfaceHeaderId => null,
694: x_InterfaceLineId => NULL,

Line 691: x_ExceptionLevel => rlm_message_sv.k_error_level,

687: --
688: rlm_message_sv.initialize_messages;
689: --
690: rlm_message_sv.app_error(
691: x_ExceptionLevel => rlm_message_sv.k_error_level,
692: x_MessageName => 'RLM_NO_DATA_FOR_CRITERIA',
693: x_InterfaceHeaderId => null,
694: x_InterfaceLineId => NULL,
695: x_ScheduleHeaderId => null,

Line 711: rlm_message_sv.dump_messages;

707: IF (l_debug <> -1) THEN
708: rlm_core_sv.dlog(C_DEBUG,'RLM_NO_DATA_FOR_CRITERIA' );
709: END IF;
710: --
711: rlm_message_sv.dump_messages;
712: --
713: END IF;
714: --
715: CLOSE c_demand;

Line 717: RunExceptionReport(x_requestId => rlm_message_sv.g_conc_req_id,

713: END IF;
714: --
715: CLOSE c_demand;
716: --
717: RunExceptionReport(x_requestId => rlm_message_sv.g_conc_req_id,
718: x_OrgId => p_org_id);
719:
720: SELECT hsecs INTO l_end_time from v$timer;
721: g_dsp_start_time := NULL; --Bugfix 10053830

Line 768: rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);

764: --
765: WHEN OTHERS THEN
766: --
767: retcode := 2;
768: rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);
769: rlm_message_sv.dump_messages(v_header_id);
770: --
771: IF (l_debug <> -1) THEN
772: rlm_core_sv.dlog(C_DEBUG, 'Return Code', retcode);

Line 769: rlm_message_sv.dump_messages(v_header_id);

765: WHEN OTHERS THEN
766: --
767: retcode := 2;
768: rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);
769: rlm_message_sv.dump_messages(v_header_id);
770: --
771: IF (l_debug <> -1) THEN
772: rlm_core_sv.dlog(C_DEBUG, 'Return Code', retcode);
773: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));

Line 831: rlm_message_sv.sql_error('rlm_dp_sv.PurgeInterfaceLines', v_Progress);

827: EXCEPTION
828: --
829: WHEN NO_DATA_FOUND THEN
830: --
831: rlm_message_sv.sql_error('rlm_dp_sv.PurgeInterfaceLines', v_Progress);
832: --
833: IF (l_debug <> -1) THEN
834: rlm_core_sv.dlog(C_DEBUG, 'No records to delete' );
835: rlm_core_sv.dpop(C_SDEBUG);

Line 840: rlm_message_sv.sql_error('rlm_dp_sv.PurgeInterfaceLines', v_Progress);

836: END IF;
837: --
838: WHEN OTHERS THEN
839: --
840: rlm_message_sv.sql_error('rlm_dp_sv.PurgeInterfaceLines', v_Progress);
841: --
842: IF (l_debug <> -1) THEN
843: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
844: END IF;

Line 913: rlm_message_sv.sql_error('rlm_managedemand_sv.lockHeader', x_progress);

909: --
910: RETURN(FALSE);
911: --
912: WHEN OTHERS THEN
913: rlm_message_sv.sql_error('rlm_managedemand_sv.lockHeader', x_progress);
914: --
915: IF (l_debug <> -1) THEN
916: rlm_core_sv.dlog(C_DEBUG,'progress',x_Progress);
917: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: OTHER - sql error');

Line 960: rlm_core_sv.dlog(C_DEBUG, 'request ID', RLM_MESSAGE_SV.g_conc_req_id);

956: x_Group_rec.ship_to_org_id);
957: rlm_core_sv.dlog(C_DEBUG,'x_Group_rec.customer_item_id ',
958: x_Group_rec.customer_item_id);
959: rlm_core_sv.dlog(C_DEBUG,'x_UpdateLevel to ', x_UpdateLevel);
960: rlm_core_sv.dlog(C_DEBUG, 'request ID', RLM_MESSAGE_SV.g_conc_req_id);
961: END IF;
962: --
963: v_login_id := fnd_global.login_id ;
964: v_request_id := RLM_MESSAGE_SV.g_conc_req_id ;

Line 964: v_request_id := RLM_MESSAGE_SV.g_conc_req_id ;

960: rlm_core_sv.dlog(C_DEBUG, 'request ID', RLM_MESSAGE_SV.g_conc_req_id);
961: END IF;
962: --
963: v_login_id := fnd_global.login_id ;
964: v_request_id := RLM_MESSAGE_SV.g_conc_req_id ;
965: v_program_app_id := fnd_global.PROG_APPL_ID ;
966: v_program_id := fnd_global.conc_program_id;
967: --
968: SELECT schedule_header_id

Line 1074: rlm_message_sv.sql_error('rlm_dp_sv.UpdateGroupPS', v_Progress);

1070: EXCEPTION
1071: --
1072: WHEN OTHERS THEN
1073: --
1074: rlm_message_sv.sql_error('rlm_dp_sv.UpdateGroupPS', v_Progress);
1075: --
1076: IF (l_debug <> -1) THEN
1077: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
1078: END IF;

Line 1109: rlm_core_sv.dlog(C_DEBUG, 'request ID', RLM_MESSAGE_SV.g_conc_req_id);

1105: --
1106: IF (l_debug <> -1) THEN
1107: rlm_core_sv.dpush(C_SDEBUG,'UpdateHeaderPS');
1108: rlm_core_sv.dlog(C_DEBUG,'x_HeaderId',x_HeaderId);
1109: rlm_core_sv.dlog(C_DEBUG, 'request ID', RLM_MESSAGE_SV.g_conc_req_id);
1110: END IF;
1111: --
1112: SELECT schedule_header_id
1113: INTO v_SchedHeaderId

Line 1194: REQUEST_ID = RLM_MESSAGE_SV.g_conc_req_id ,

1190: --
1191: UPDATE rlm_interface_headers
1192: SET process_status = x_HeaderStatus,
1193: LAST_UPDATE_LOGIN = fnd_global.login_id ,
1194: REQUEST_ID = RLM_MESSAGE_SV.g_conc_req_id ,
1195: PROGRAM_APPLICATION_ID = fnd_global.PROG_APPL_ID ,
1196: PROGRAM_ID = fnd_global.conc_program_id,
1197: PROGRAM_UPDATE_DATE = sysdate
1198: WHERE header_id = x_HeaderId;

Line 1208: REQUEST_ID = RLM_MESSAGE_SV.g_conc_req_id ,

1204: --
1205: UPDATE rlm_schedule_headers
1206: SET process_status = x_HeaderStatus,
1207: LAST_UPDATE_LOGIN = fnd_global.login_id ,
1208: REQUEST_ID = RLM_MESSAGE_SV.g_conc_req_id ,
1209: PROGRAM_APPLICATION_ID = fnd_global.PROG_APPL_ID ,
1210: PROGRAM_ID = fnd_global.conc_program_id,
1211: PROGRAM_UPDATE_DATE = sysdate
1212: WHERE header_id = v_SchedHeaderId ;

Line 1230: rlm_message_sv.sql_error('rlm_dp_sv.UpdateHeaderStatus', x_progress);

1226: END IF;
1227: --
1228: WHEN OTHERS THEN
1229: --
1230: rlm_message_sv.sql_error('rlm_dp_sv.UpdateHeaderStatus', x_progress);
1231: --
1232: IF (l_debug <> -1) THEN
1233: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: OTHER - sql error');
1234: END IF;

Line 1350: rlm_message_sv.sql_error('rlm_dp_sv.RunExceptionReport', x_progress);

1346: END IF;
1347: --
1348: WHEN OTHERS THEN
1349: --
1350: rlm_message_sv.sql_error('rlm_dp_sv.RunExceptionReport', x_progress);
1351: --
1352: IF (l_debug <> -1) THEN
1353: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: OTHER - sql error');
1354: END IF;

Line 1405: rlm_message_sv.sql_error('rlm_dp_sv.CheckForecast', v_Progress);

1401: EXCEPTION
1402: --
1403: WHEN OTHERS THEN
1404: --
1405: rlm_message_sv.sql_error('rlm_dp_sv.CheckForecast', v_Progress);
1406: --
1407: IF (l_debug <> -1) THEN
1408: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
1409: END IF;

Line 1633: set request_id = RLM_MESSAGE_SV.g_conc_req_id

1629: v_devstatus,
1630: v_reqmessage);
1631: --
1632: update rlm_demand_exceptions
1633: set request_id = RLM_MESSAGE_SV.g_conc_req_id
1634: where request_id = x_child_req_id(i);
1635: --
1636: /* update group status for all lines with child req id*/
1637: --

Line 1719: rlm_message_sv.populate_req_id;

1715: v_temp NUMBER;
1716: --
1717: BEGIN
1718: --
1719: rlm_message_sv.populate_req_id;
1720: --
1721: IF (l_debug <> -1) THEN
1722: rlm_core_sv.start_debug;
1723: rlm_core_sv.dpush(C_SDEBUG, 'ChildProcess');

Line 2032: rlm_message_sv.removeMessages(

2028: rlm_core_sv.k_PS_ERROR);
2029: -- Bug#: 2771756 - Start
2030: -- Bug 4198330 added group information
2031: rlm_core_sv.dlog(C_DEBUG,'Manage Demand remove messages');
2032: rlm_message_sv.removeMessages(
2033: p_header_id => p_header_id,
2034: p_message => 'RLM_RSO_CREATION_INFO',
2035: p_message_type => 'I',
2036: p_ship_from_org_id => v_group_rec.ship_from_org_id,

Line 2041: rlm_message_sv.dump_messages(p_header_id);

2037: p_ship_to_address_id => v_group_rec.ship_to_address_id,
2038: p_customer_item_id => v_group_rec.customer_item_id,
2039: p_inventory_item_id => v_group_rec.inventory_item_id);
2040: -- Bug#: 2771756 - End
2041: rlm_message_sv.dump_messages(p_header_id);
2042: --
2043: COMMIT;
2044: --
2045: IF (p_dspMode = k_SEQ_DSP) THEN

Line 2073: rlm_message_sv.removeMessages(

2069: v_Group_rec,
2070: rlm_core_sv.k_PS_ERROR);
2071: -- Bug#: 2771756 - Start
2072: -- Start bug 4198330 added grouping information
2073: rlm_message_sv.removeMessages(
2074: p_header_id => p_header_id,
2075: p_message => 'RLM_RSO_CREATION_INFO',
2076: p_message_type => 'I',
2077: p_ship_from_org_id => v_group_rec.ship_from_org_id,

Line 2082: rlm_message_sv.dump_messages(p_header_id);

2078: p_ship_to_address_id => v_group_rec.ship_to_address_id,
2079: p_customer_item_id => v_group_rec.customer_item_id,
2080: p_inventory_item_id => v_group_rec.inventory_item_id);
2081: -- Bug#: 2771756 - End
2082: rlm_message_sv.dump_messages(p_header_id);
2083: --
2084: COMMIT;
2085: --
2086: IF (p_dspMode = k_SEQ_DSP) THEN

Line 2115: rlm_message_sv.removeMessages(

2111: rlm_core_sv.k_PS_ERROR);
2112: -- Bug#: 2771756 - Start
2113: -- Start bug 4198330 added grouping information
2114: rlm_core_sv.dlog(C_DEBUG,' before remove messages');
2115: rlm_message_sv.removeMessages(
2116: p_header_id => p_header_id,
2117: p_message => 'RLM_RSO_CREATION_INFO',
2118: p_message_type => 'I',
2119: p_ship_from_org_id => v_group_rec.ship_from_org_id,

Line 2124: rlm_message_sv.dump_messages(p_header_id);

2120: p_ship_to_address_id => v_group_rec.ship_to_address_id,
2121: p_customer_item_id => v_group_rec.customer_item_id,
2122: p_inventory_item_id => v_group_rec.inventory_item_id);
2123: -- Bug#: 2771756 - End
2124: rlm_message_sv.dump_messages(p_header_id);
2125: --
2126: COMMIT;
2127: --
2128: IF (p_dspMode = k_SEQ_DSP) THEN

Line 2164: rlm_message_sv.removeMessages(

2160: v_Group_rec,
2161: rlm_core_sv.k_PS_ERROR);
2162: -- Bug#: 2771756 - Start
2163: -- Start bug 4198330 added grouping information
2164: rlm_message_sv.removeMessages(
2165: p_header_id => p_header_id,
2166: p_message => 'RLM_RSO_CREATION_INFO',
2167: p_message_type => 'I',
2168: p_ship_from_org_id => v_group_rec.ship_from_org_id,

Line 2173: rlm_message_sv.dump_messages(p_header_id);

2169: p_ship_to_address_id => v_group_rec.ship_to_address_id,
2170: p_customer_item_id => v_group_rec.customer_item_id,
2171: p_inventory_item_id => v_group_rec.inventory_item_id);
2172: -- Bug#: 2771756 - End
2173: rlm_message_sv.dump_messages(p_header_id);
2174: --
2175: COMMIT;
2176: --
2177: IF (p_dspMode = k_SEQ_DSP) THEN

Line 2235: rlm_message_sv.dump_messages(p_header_id);

2231: --
2232: WHEN OTHERS THEN
2233: --
2234: IF (l_debug <> -1) THEN
2235: rlm_message_sv.dump_messages(p_header_id);
2236: rlm_core_sv.dpop(C_SDEBUG, 'Error: '||SUBSTR(SQLERRM,1,200));
2237: END IF;
2238: --
2239: raise;