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

Line 116: rlm_message_sv.app_error(

112: WHEN e_lines_locked THEN
113: --
114: x_ReturnStatus := rlm_core_sv.k_PROC_ERROR;
115: --
116: rlm_message_sv.app_error(
117: x_ExceptionLevel => rlm_message_sv.k_error_level,
118: x_MessageName => 'RLM_LOCK_NOT_OBTAINED',
119: x_InterfaceHeaderId => x_Sched_rec.header_id,
120: x_InterfaceLineId => NULL,

Line 117: x_ExceptionLevel => rlm_message_sv.k_error_level,

113: --
114: x_ReturnStatus := rlm_core_sv.k_PROC_ERROR;
115: --
116: rlm_message_sv.app_error(
117: x_ExceptionLevel => rlm_message_sv.k_error_level,
118: x_MessageName => 'RLM_LOCK_NOT_OBTAINED',
119: x_InterfaceHeaderId => x_Sched_rec.header_id,
120: x_InterfaceLineId => NULL,
121: x_ScheduleHeaderId => x_Sched_rec.schedule_header_id,

Line 154: rlm_message_sv.sql_error('rlm_rd_sv.RecDemand',x_progress);

150: --
151: WHEN OTHERS THEN
152: --
153: x_ReturnStatus := rlm_core_sv.k_PROC_ERROR;
154: rlm_message_sv.sql_error('rlm_rd_sv.RecDemand',x_progress);
155: --
156: IF (l_debug <> -1) THEN
157: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
158: END IF;

Line 428: rlm_message_sv.sql_error('rlm_rd_sv.RecGroupDemand',x_progress);

424: raise e_group_error;
425: --
426: WHEN OTHERS THEN
427: --
428: rlm_message_sv.sql_error('rlm_rd_sv.RecGroupDemand',x_progress);
429: --
430: IF (l_debug <> -1) THEN
431: rlm_core_sv.dpop(k_SDEBUG);
432: END IF;

Line 675: rlm_message_sv.app_error(

671: AND ship_to_address_id = x_Group_rec.ship_to_address_id
672: AND customer_item_id = x_Group_rec.customer_item_id
673: AND rownum = 1;
674: --
675: rlm_message_sv.app_error(
676: x_ExceptionLevel => rlm_message_sv.k_error_level,
677: x_MessageName => 'RLM_SETUPAPI_FAILED',
678: x_ChildMessageName => v_SetupTerms_rec.msg_name,
679: x_InterfaceHeaderId => x_sched_rec.header_id,

Line 676: x_ExceptionLevel => rlm_message_sv.k_error_level,

672: AND customer_item_id = x_Group_rec.customer_item_id
673: AND rownum = 1;
674: --
675: rlm_message_sv.app_error(
676: x_ExceptionLevel => rlm_message_sv.k_error_level,
677: x_MessageName => 'RLM_SETUPAPI_FAILED',
678: x_ChildMessageName => v_SetupTerms_rec.msg_name,
679: x_InterfaceHeaderId => x_sched_rec.header_id,
680: x_InterfaceLineId => v_InterfaceLineId,

Line 698: rlm_message_sv.sql_error('rlm_rd_sv.CallSetups',x_progress);

694: raise e_group_error;
695: --
696: WHEN OTHERS THEN
697: --
698: rlm_message_sv.sql_error('rlm_rd_sv.CallSetups',x_progress);
699: --
700: IF (l_debug <> -1) THEN
701: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
702: END IF;

Line 794: rlm_message_sv.sql_error('rlm_rd_sv.ExecOperations', x_progress);

790: --
791: raise;
792: --
793: WHEN OTHERS THEN
794: rlm_message_sv.sql_error('rlm_rd_sv.ExecOperations', x_progress);
795: --
796: IF (l_debug <> -1) THEN
797: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
798: END IF;

Line 898: rlm_message_sv.sql_error('rlm_rd_sv.CancelPreHorizonNATS',x_progress);

894: --
895: raise e_group_error;
896:
897: WHEN OTHERS THEN
898: rlm_message_sv.sql_error('rlm_rd_sv.CancelPreHorizonNATS',x_progress);
899: --
900: IF (l_debug <> -1) THEN
901: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
902: END IF;

Line 994: rlm_message_sv.sql_error('rlm_rd_sv.ProcessConstraint',x_progress);

990: RETURN(b_Result);
991: --
992: EXCEPTION
993: WHEN OTHERS THEN
994: rlm_message_sv.sql_error('rlm_rd_sv.ProcessConstraint',x_progress);
995: --
996: IF (l_debug <> -1) THEN
997: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
998: END IF;

Line 1055: rlm_message_sv.sql_error('rlm_rd_sv.FetchGroup',x_progress);

1051: END IF;
1052:
1053: EXCEPTION
1054: WHEN OTHERS THEN
1055: rlm_message_sv.sql_error('rlm_rd_sv.FetchGroup',x_progress);
1056: --
1057: IF (l_debug <> -1) THEN
1058: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
1059: END IF;

Line 1118: rlm_message_sv.sql_error('RLM_RD_SV.RemainOnFile', v_Progress);

1114: EXCEPTION
1115:
1116: WHEN OTHERS THEN
1117: --
1118: rlm_message_sv.sql_error('RLM_RD_SV.RemainOnFile', v_Progress);
1119: IF (l_debug <> -1) THEN
1120: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
1121: END IF;
1122: RAISE;

Line 1197: rlm_message_sv.app_error(

1193: IF x_Key_rec.dem_rec.ordered_quantity <> g_sch_line_qty THEN --Bugfix 6159269
1194:
1195: IF (x_Key_rec.dem_rec.schedule_type = 'SEQUENCED') THEN
1196: --
1197: rlm_message_sv.app_error(
1198: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1199: x_MessageName => 'RLM_FROZEN_DELETE_SEQ',
1200: x_InterfaceHeaderId => x_sched_rec.header_id,
1201: x_InterfaceLineId => NULL,

Line 1198: x_ExceptionLevel => rlm_message_sv.k_warn_level,

1194:
1195: IF (x_Key_rec.dem_rec.schedule_type = 'SEQUENCED') THEN
1196: --
1197: rlm_message_sv.app_error(
1198: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1199: x_MessageName => 'RLM_FROZEN_DELETE_SEQ',
1200: x_InterfaceHeaderId => x_sched_rec.header_id,
1201: x_InterfaceLineId => NULL,
1202: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 1231: rlm_message_sv.app_error(

1227: END IF;
1228: --
1229: ELSE
1230: --
1231: rlm_message_sv.app_error(
1232: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1233: x_MessageName => 'RLM_FROZEN_DELETE',
1234: x_InterfaceHeaderId => x_sched_rec.header_id,
1235: x_InterfaceLineId => NULL,

Line 1232: x_ExceptionLevel => rlm_message_sv.k_warn_level,

1228: --
1229: ELSE
1230: --
1231: rlm_message_sv.app_error(
1232: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1233: x_MessageName => 'RLM_FROZEN_DELETE',
1234: x_InterfaceHeaderId => x_sched_rec.header_id,
1235: x_InterfaceLineId => NULL,
1236: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 1425: rlm_message_sv.app_error(

1421: IF g_sch_line_qty >0 AND g_del_reconcile = 'Y' THEN
1422: GetMatchAttributes(x_sched_rec, x_group_rec, x_key_rec.req_rec,v_MatchAttrTxt);
1423: IF (x_sched_rec.schedule_type = 'SEQUENCED') THEN
1424: --
1425: rlm_message_sv.app_error(
1426: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1427: x_MessageName => 'RLM_RECONCILE_DELETE_SEQ',
1428: x_InterfaceHeaderId => x_sched_rec.header_id,
1429: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 1426: x_ExceptionLevel => rlm_message_sv.k_warn_level,

1422: GetMatchAttributes(x_sched_rec, x_group_rec, x_key_rec.req_rec,v_MatchAttrTxt);
1423: IF (x_sched_rec.schedule_type = 'SEQUENCED') THEN
1424: --
1425: rlm_message_sv.app_error(
1426: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1427: x_MessageName => 'RLM_RECONCILE_DELETE_SEQ',
1428: x_InterfaceHeaderId => x_sched_rec.header_id,
1429: x_InterfaceLineId => x_key_rec.req_rec.line_id,
1430: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 1466: rlm_message_sv.app_error(

1462: END IF;
1463: --
1464: ELSE
1465: --
1466: rlm_message_sv.app_error(
1467: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1468: x_MessageName => 'RLM_RECONCILE_DELETE',
1469: x_InterfaceHeaderId => x_sched_rec.header_id,
1470: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 1467: x_ExceptionLevel => rlm_message_sv.k_warn_level,

1463: --
1464: ELSE
1465: --
1466: rlm_message_sv.app_error(
1467: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1468: x_MessageName => 'RLM_RECONCILE_DELETE',
1469: x_InterfaceHeaderId => x_sched_rec.header_id,
1470: x_InterfaceLineId => x_key_rec.req_rec.line_id,
1471: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 1530: rlm_message_sv.sql_error('rlm_rd_sv.DeleteRequirement',x_progress);

1526: RAISE;
1527: --
1528: WHEN OTHERS THEN
1529: --
1530: rlm_message_sv.sql_error('rlm_rd_sv.DeleteRequirement',x_progress);
1531: --
1532: IF (l_debug <> -1) THEN
1533: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
1534: END IF;

Line 1605: rlm_message_sv.app_error(

1601: GetMatchAttributes(x_sched_rec, x_group_rec, x_key_rec.req_rec,v_MatchAttrTxt);
1602: --
1603: IF (x_sched_rec.schedule_type = 'SEQUENCED') THEN
1604: --
1605: rlm_message_sv.app_error(
1606: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1607: x_MessageName => 'RLM_RECONCILE_ZERO_INSERT_SEQ',
1608: x_InterfaceHeaderId => x_sched_rec.header_id,
1609: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 1606: x_ExceptionLevel => rlm_message_sv.k_warn_level,

1602: --
1603: IF (x_sched_rec.schedule_type = 'SEQUENCED') THEN
1604: --
1605: rlm_message_sv.app_error(
1606: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1607: x_MessageName => 'RLM_RECONCILE_ZERO_INSERT_SEQ',
1608: x_InterfaceHeaderId => x_sched_rec.header_id,
1609: x_InterfaceLineId => x_key_rec.req_rec.line_id,
1610: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 1642: rlm_message_sv.app_error(

1638: END IF;
1639: --
1640: ELSE
1641: --
1642: rlm_message_sv.app_error(
1643: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1644: x_MessageName => 'RLM_RECONCILE_ZERO_INSERT',
1645: x_InterfaceHeaderId => x_sched_rec.header_id,
1646: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 1643: x_ExceptionLevel => rlm_message_sv.k_warn_level,

1639: --
1640: ELSE
1641: --
1642: rlm_message_sv.app_error(
1643: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1644: x_MessageName => 'RLM_RECONCILE_ZERO_INSERT',
1645: x_InterfaceHeaderId => x_sched_rec.header_id,
1646: x_InterfaceLineId => x_key_rec.req_rec.line_id,
1647: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 1744: rlm_message_sv.app_error(

1740: -- Bugfix 8279132 Start
1741: GetMatchAttributes(x_sched_rec, x_group_rec, x_key_rec.req_rec,v_MatchAttrTxt);
1742:
1743: IF (x_sched_rec.schedule_type = 'SEQUENCED') THEN
1744: rlm_message_sv.app_error(
1745: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1746: x_MessageName => 'RLM_ROLL_FORWARD_SEQ',
1747: x_InterfaceHeaderId => x_sched_rec.header_id,
1748: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 1745: x_ExceptionLevel => rlm_message_sv.k_warn_level,

1741: GetMatchAttributes(x_sched_rec, x_group_rec, x_key_rec.req_rec,v_MatchAttrTxt);
1742:
1743: IF (x_sched_rec.schedule_type = 'SEQUENCED') THEN
1744: rlm_message_sv.app_error(
1745: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1746: x_MessageName => 'RLM_ROLL_FORWARD_SEQ',
1747: x_InterfaceHeaderId => x_sched_rec.header_id,
1748: x_InterfaceLineId => x_key_rec.req_rec.line_id,
1749: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 1778: rlm_message_sv.app_error(

1774: x_key_rec.req_rec.line_id);
1775: END IF;
1776:
1777: ELSE
1778: rlm_message_sv.app_error(
1779: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1780: x_MessageName => 'RLM_ROLL_FORWARD',
1781: x_InterfaceHeaderId => x_sched_rec.header_id,
1782: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 1779: x_ExceptionLevel => rlm_message_sv.k_warn_level,

1775: END IF;
1776:
1777: ELSE
1778: rlm_message_sv.app_error(
1779: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1780: x_MessageName => 'RLM_ROLL_FORWARD',
1781: x_InterfaceHeaderId => x_sched_rec.header_id,
1782: x_InterfaceLineId => x_key_rec.req_rec.line_id,
1783: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 1865: rlm_message_sv.app_error(

1861: GetMatchAttributes(x_sched_rec, x_group_rec, x_key_rec.req_rec, v_MatchAttrTxt);
1862: --
1863: IF (x_sched_rec.schedule_type = 'SEQUENCED') THEN
1864: --
1865: rlm_message_sv.app_error(
1866: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1867: x_MessageName => 'RLM_LOW_PRECEDENCE_INSERT_SEQ',
1868: x_InterfaceHeaderId => x_sched_rec.header_id,
1869: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 1866: x_ExceptionLevel => rlm_message_sv.k_warn_level,

1862: --
1863: IF (x_sched_rec.schedule_type = 'SEQUENCED') THEN
1864: --
1865: rlm_message_sv.app_error(
1866: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1867: x_MessageName => 'RLM_LOW_PRECEDENCE_INSERT_SEQ',
1868: x_InterfaceHeaderId => x_sched_rec.header_id,
1869: x_InterfaceLineId => x_key_rec.req_rec.line_id,
1870: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 1910: rlm_message_sv.app_error(

1906: END IF;
1907: --
1908: ELSE
1909: --
1910: rlm_message_sv.app_error(
1911: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1912: x_MessageName => 'RLM_LOW_PRECEDENCE_INSERT',
1913: x_InterfaceHeaderId => x_sched_rec.header_id,
1914: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 1911: x_ExceptionLevel => rlm_message_sv.k_warn_level,

1907: --
1908: ELSE
1909: --
1910: rlm_message_sv.app_error(
1911: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1912: x_MessageName => 'RLM_LOW_PRECEDENCE_INSERT',
1913: x_InterfaceHeaderId => x_sched_rec.header_id,
1914: x_InterfaceLineId => x_key_rec.req_rec.line_id,
1915: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 1979: rlm_message_sv.app_error(

1975: --
1976: IF g_inc_exception <> 'Y' THEN --Bugfix 6159269
1977: IF (x_sched_rec.schedule_type = 'SEQUENCED') THEN
1978: --
1979: rlm_message_sv.app_error(
1980: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1981: x_MessageName => 'RLM_FROZEN_INSERT_SEQ',
1982: x_InterfaceHeaderId => x_sched_rec.header_id,
1983: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 1980: x_ExceptionLevel => rlm_message_sv.k_warn_level,

1976: IF g_inc_exception <> 'Y' THEN --Bugfix 6159269
1977: IF (x_sched_rec.schedule_type = 'SEQUENCED') THEN
1978: --
1979: rlm_message_sv.app_error(
1980: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1981: x_MessageName => 'RLM_FROZEN_INSERT_SEQ',
1982: x_InterfaceHeaderId => x_sched_rec.header_id,
1983: x_InterfaceLineId => x_key_rec.req_rec.line_id,
1984: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 2013: rlm_message_sv.app_error(

2009: END IF;
2010: --
2011: ELSE
2012: --
2013: rlm_message_sv.app_error(
2014: x_ExceptionLevel => rlm_message_sv.k_warn_level,
2015: x_MessageName => 'RLM_FROZEN_INSERT',
2016: x_InterfaceHeaderId => x_sched_rec.header_id,
2017: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 2014: x_ExceptionLevel => rlm_message_sv.k_warn_level,

2010: --
2011: ELSE
2012: --
2013: rlm_message_sv.app_error(
2014: x_ExceptionLevel => rlm_message_sv.k_warn_level,
2015: x_MessageName => 'RLM_FROZEN_INSERT',
2016: x_InterfaceHeaderId => x_sched_rec.header_id,
2017: x_InterfaceLineId => x_key_rec.req_rec.line_id,
2018: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 2048: rlm_message_sv.sql_error('rlm_rd_sv.InsertRequirement',x_progress);

2044: END IF; /*IF g_inc_exception */ --Bugfix 6159269
2045:
2046: -- Bug 4297984 End
2047: WHEN OTHERS THEN
2048: rlm_message_sv.sql_error('rlm_rd_sv.InsertRequirement',x_progress);
2049: --
2050: IF (l_debug <> -1) THEN
2051: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
2052: END IF;

Line 2108: rlm_message_sv.app_error(

2104: IF x_Key_rec.dem_rec.ordered_quantity <> g_sch_line_qty THEN --Bugfix 6159269
2105: --
2106: IF (x_key_rec.dem_rec.schedule_type = 'SEQUENCED') THEN
2107: --
2108: rlm_message_sv.app_error(
2109: x_ExceptionLevel => rlm_message_sv.k_warn_level,
2110: x_MessageName => 'RLM_FROZEN_UPDATE_SEQ',
2111: x_InterfaceHeaderId => x_sched_rec.header_id,
2112: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 2109: x_ExceptionLevel => rlm_message_sv.k_warn_level,

2105: --
2106: IF (x_key_rec.dem_rec.schedule_type = 'SEQUENCED') THEN
2107: --
2108: rlm_message_sv.app_error(
2109: x_ExceptionLevel => rlm_message_sv.k_warn_level,
2110: x_MessageName => 'RLM_FROZEN_UPDATE_SEQ',
2111: x_InterfaceHeaderId => x_sched_rec.header_id,
2112: x_InterfaceLineId => x_key_rec.req_rec.line_id,
2113: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 2145: rlm_message_sv.app_error(

2141: END IF;
2142: --
2143: ELSE
2144: --
2145: rlm_message_sv.app_error(
2146: x_ExceptionLevel => rlm_message_sv.k_warn_level,
2147: x_MessageName => 'RLM_FROZEN_UPDATE',
2148: x_InterfaceHeaderId => x_sched_rec.header_id,
2149: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 2146: x_ExceptionLevel => rlm_message_sv.k_warn_level,

2142: --
2143: ELSE
2144: --
2145: rlm_message_sv.app_error(
2146: x_ExceptionLevel => rlm_message_sv.k_warn_level,
2147: x_MessageName => 'RLM_FROZEN_UPDATE',
2148: x_InterfaceHeaderId => x_sched_rec.header_id,
2149: x_InterfaceLineId => x_key_rec.req_rec.line_id,
2150: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 2194: rlm_message_sv.app_error(

2190: -- Bugfix 8279132 Start
2191: GetMatchAttributes(x_sched_rec, x_group_rec, x_key_rec.req_rec,v_MatchAttrTxt);
2192:
2193: IF (x_sched_rec.schedule_type = 'SEQUENCED') THEN
2194: rlm_message_sv.app_error(
2195: x_ExceptionLevel => rlm_message_sv.k_warn_level,
2196: x_MessageName => 'RLM_ROLL_FORWARD_SEQ',
2197: x_InterfaceHeaderId => x_sched_rec.header_id,
2198: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 2195: x_ExceptionLevel => rlm_message_sv.k_warn_level,

2191: GetMatchAttributes(x_sched_rec, x_group_rec, x_key_rec.req_rec,v_MatchAttrTxt);
2192:
2193: IF (x_sched_rec.schedule_type = 'SEQUENCED') THEN
2194: rlm_message_sv.app_error(
2195: x_ExceptionLevel => rlm_message_sv.k_warn_level,
2196: x_MessageName => 'RLM_ROLL_FORWARD_SEQ',
2197: x_InterfaceHeaderId => x_sched_rec.header_id,
2198: x_InterfaceLineId => x_key_rec.req_rec.line_id,
2199: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 2228: rlm_message_sv.app_error(

2224: x_key_rec.req_rec.line_id);
2225: END IF;
2226:
2227: ELSE
2228: rlm_message_sv.app_error(
2229: x_ExceptionLevel => rlm_message_sv.k_warn_level,
2230: x_MessageName => 'RLM_ROLL_FORWARD',
2231: x_InterfaceHeaderId => x_sched_rec.header_id,
2232: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 2229: x_ExceptionLevel => rlm_message_sv.k_warn_level,

2225: END IF;
2226:
2227: ELSE
2228: rlm_message_sv.app_error(
2229: x_ExceptionLevel => rlm_message_sv.k_warn_level,
2230: x_MessageName => 'RLM_ROLL_FORWARD',
2231: x_InterfaceHeaderId => x_sched_rec.header_id,
2232: x_InterfaceLineId => x_key_rec.req_rec.line_id,
2233: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 2310: rlm_message_sv.sql_error('rlm_rd_sv.UpdateRequirement',x_progress);

2306: END IF;
2307: --
2308: EXCEPTION
2309: WHEN OTHERS THEN
2310: rlm_message_sv.sql_error('rlm_rd_sv.UpdateRequirement',x_progress);
2311: --
2312: IF (l_debug <> -1) THEN
2313: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
2314: END IF;

Line 2339: rlm_message_sv.sql_error('rlm_rd_sv.GetQtyRec',x_progress);

2335: END IF;
2336:
2337: EXCEPTION
2338: WHEN OTHERS THEN
2339: rlm_message_sv.sql_error('rlm_rd_sv.GetQtyRec',x_progress);
2340: --
2341: IF (l_debug <> -1) THEN
2342: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
2343: END IF;

Line 2377: rlm_message_sv.sql_error('rlm_rd_sv.GetReq',x_progress);

2373: END IF;
2374: --
2375: EXCEPTION
2376: WHEN OTHERS THEN
2377: rlm_message_sv.sql_error('rlm_rd_sv.GetReq',x_progress);
2378: --
2379: IF (l_debug <> -1) THEN
2380: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
2381: END IF;

Line 2587: rlm_message_sv.sql_error('rlm_rd_sv.GetDemand',x_progress);

2583: END IF;
2584: --
2585: EXCEPTION
2586: WHEN OTHERS THEN
2587: rlm_message_sv.sql_error('rlm_rd_sv.GetDemand',x_progress);
2588: --
2589: IF (l_debug <> -1) THEN
2590: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
2591: END IF;

Line 3515: rlm_message_sv.sql_error('rlm_rd_sv.InitializeDemand',x_progress);

3511: WHEN e_no_init THEN
3512: rlm_core_sv.dpop(k_SDEBUG,'Demand Type is not ATS or NATS');
3513:
3514: WHEN OTHERS THEN
3515: rlm_message_sv.sql_error('rlm_rd_sv.InitializeDemand',x_progress);
3516: --
3517: IF (l_debug <> -1) THEN
3518: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
3519: END IF;

Line 3588: rlm_message_sv.sql_error('rlm_rd_sv.InitializeSoGroup',x_progress);

3584: END IF;
3585: --
3586: EXCEPTION
3587: WHEN OTHERS THEN
3588: rlm_message_sv.sql_error('rlm_rd_sv.InitializeSoGroup',x_progress);
3589: --
3590: IF (l_debug <> -1) THEN
3591: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
3592: END IF;

Line 3837: rlm_message_sv.sql_error('rlm_rd_sv.InitializeReq',x_progress);

3833: END IF;
3834: --
3835: EXCEPTION
3836: WHEN OTHERS THEN
3837: rlm_message_sv.sql_error('rlm_rd_sv.InitializeReq',x_progress);
3838: --
3839: IF (l_debug <> -1) THEN
3840: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
3841: END IF;

Line 3876: rlm_message_sv.sql_error('rlm_rd_sv.CancelRequirement',x_progress);

3872: END IF;
3873: --
3874: EXCEPTION
3875: WHEN OTHERS THEN
3876: rlm_message_sv.sql_error('rlm_rd_sv.CancelRequirement',x_progress);
3877: --
3878: IF (l_debug <> -1) THEN
3879: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
3880: END IF;

Line 4249: rlm_message_sv.sql_error('rlm_rd_sv.SynchronizeShipments',x_progress);

4245: rlm_core_sv.dpop(k_SDEBUG,'e_cumDiscrete');
4246: END IF;
4247: --
4248: WHEN OTHERS THEN
4249: rlm_message_sv.sql_error('rlm_rd_sv.SynchronizeShipments',x_progress);
4250: --
4251: IF (l_debug <> -1) THEN
4252: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
4253: END IF;

Line 4283: rlm_message_sv.sql_error('rlm_rd_sv.MatchWithin',x_progress);

4279: RETURN('Y');
4280:
4281: EXCEPTION
4282: WHEN OTHERS THEN
4283: rlm_message_sv.sql_error('rlm_rd_sv.MatchWithin',x_progress);
4284: --
4285: IF (l_debug <> -1) THEN
4286: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
4287: END IF;

Line 4316: rlm_message_sv.sql_error('rlm_rd_sv.MatchAcross',x_progress);

4312: RETURN('Y');
4313:
4314: EXCEPTION
4315: WHEN OTHERS THEN
4316: rlm_message_sv.sql_error('rlm_rd_sv.MatchAcross',x_progress);
4317: --
4318: IF (l_debug <> -1) THEN
4319: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
4320: END IF;

Line 4424: rlm_message_sv.sql_error('rlm_rd_sv.StoreShipments',x_progress);

4420: END IF;
4421: --
4422: EXCEPTION
4423: WHEN OTHERS THEN
4424: rlm_message_sv.sql_error('rlm_rd_sv.StoreShipments',x_progress);
4425: --
4426: IF (l_debug <> -1) THEN
4427: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
4428: END IF;

Line 4504: rlm_message_sv.sql_error('rlm_rd_sv.ReconcileShipments',x_progress);

4500: END IF;
4501: --
4502: EXCEPTION
4503: WHEN OTHERS THEN
4504: rlm_message_sv.sql_error('rlm_rd_sv.ReconcileShipments',x_progress);
4505: --
4506: IF (l_debug <> -1) THEN
4507: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
4508: END IF;

Line 4593: rlm_message_sv.sql_error('rlm_rd_sv.MatchShipments',x_progress);

4589: RETURN(b_Match);
4590:
4591: EXCEPTION
4592: WHEN OTHERS THEN
4593: rlm_message_sv.sql_error('rlm_rd_sv.MatchShipments',x_progress);
4594: --
4595: IF (l_debug <> -1) THEN
4596: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
4597: END IF;

Line 5675: rlm_message_sv.sql_error('rlm_rd_sv.MatchFrozen',x_progress);

5671: RETURN(b_Match);
5672: --
5673: EXCEPTION
5674: WHEN OTHERS THEN
5675: rlm_message_sv.sql_error('rlm_rd_sv.MatchFrozen',x_progress);
5676: --
5677: IF (l_debug <> -1) THEN
5678: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
5679: END IF;

Line 6812: rlm_message_sv.sql_error('rlm_rd_sv.MatchReconcile',x_progress);

6808: RETURN(b_Match);
6809: --
6810: EXCEPTION
6811: WHEN OTHERS THEN
6812: rlm_message_sv.sql_error('rlm_rd_sv.MatchReconcile',x_progress);
6813: --
6814: IF (l_debug <> -1) THEN
6815: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
6816: END IF;

Line 6883: rlm_message_sv.sql_error('rlm_rd_sv.StoreReconcile',x_progress);

6879: END IF;
6880:
6881: EXCEPTION
6882: WHEN OTHERS THEN
6883: rlm_message_sv.sql_error('rlm_rd_sv.StoreReconcile',x_progress);
6884: --
6885: IF (l_debug <> -1) THEN
6886: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
6887: END IF;

Line 6971: rlm_message_sv.sql_error('rlm_rd_sv.Reconcile',x_progress);

6967: END IF;
6968: --
6969: EXCEPTION
6970: WHEN OTHERS THEN
6971: rlm_message_sv.sql_error('rlm_rd_sv.Reconcile',x_progress);
6972: --
6973: IF (l_debug <> -1) THEN
6974: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
6975: END IF;

Line 7212: rlm_message_sv.sql_error('rlm_rd_sv.AttributeChange',x_progress);

7208: RETURN(b_Change);
7209:
7210: EXCEPTION
7211: WHEN OTHERS THEN
7212: rlm_message_sv.sql_error('rlm_rd_sv.AttributeChange',x_progress);
7213: --
7214: IF (l_debug <> -1) THEN
7215: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
7216: END IF;

Line 7298: rlm_message_sv.app_error(

7294: SELECT line_number INTO v_line_num
7295: FROM oe_order_lines_all
7296: WHERE line_id = c_PreHorizonDisp_rec.line_id;
7297: --
7298: rlm_message_sv.app_error(
7299: x_ExceptionLevel => rlm_message_sv.k_warn_level,
7300: x_MessageName => 'RLM_WRONG_SCHEDTYPE',
7301: x_InterfaceHeaderId => x_sched_rec.header_id,
7302: x_InterfaceLineId => NULL,

Line 7299: x_ExceptionLevel => rlm_message_sv.k_warn_level,

7295: FROM oe_order_lines_all
7296: WHERE line_id = c_PreHorizonDisp_rec.line_id;
7297: --
7298: rlm_message_sv.app_error(
7299: x_ExceptionLevel => rlm_message_sv.k_warn_level,
7300: x_MessageName => 'RLM_WRONG_SCHEDTYPE',
7301: x_InterfaceHeaderId => x_sched_rec.header_id,
7302: x_InterfaceLineId => NULL,
7303: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 7344: rlm_message_sv.sql_error('rlm_rd_sv.ProcessPreHorizonATS',x_progress);

7340: --
7341: raise e_group_error;
7342:
7343: WHEN OTHERS THEN
7344: rlm_message_sv.sql_error('rlm_rd_sv.ProcessPreHorizonATS',x_progress);
7345: --
7346: IF (l_debug <> -1) THEN
7347: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
7348: END IF;

Line 7930: rlm_message_sv.app_error(

7926: GetMatchAttributes(x_sched_rec,x_group_rec, v_Key_rec.dem_rec,v_MatchAttrTxt);
7927: --
7928: IF (c_OldDemand_rec.rla_schedule_type_code = 'SEQUENCED') THEN
7929: --
7930: rlm_message_sv.app_error(
7931: x_ExceptionLevel => rlm_message_sv.k_warn_level,
7932: x_MessageName => 'RLM_FROZEN_DELETE_SEQ',
7933: x_InterfaceHeaderId => x_sched_rec.header_id,
7934: x_InterfaceLineId => NULL,

Line 7931: x_ExceptionLevel => rlm_message_sv.k_warn_level,

7927: --
7928: IF (c_OldDemand_rec.rla_schedule_type_code = 'SEQUENCED') THEN
7929: --
7930: rlm_message_sv.app_error(
7931: x_ExceptionLevel => rlm_message_sv.k_warn_level,
7932: x_MessageName => 'RLM_FROZEN_DELETE_SEQ',
7933: x_InterfaceHeaderId => x_sched_rec.header_id,
7934: x_InterfaceLineId => NULL,
7935: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 7965: rlm_message_sv.app_error(

7961: END IF;
7962: --
7963: ELSE
7964: --
7965: rlm_message_sv.app_error(
7966: x_ExceptionLevel => rlm_message_sv.k_warn_level,
7967: x_MessageName => 'RLM_FROZEN_DELETE',
7968: x_InterfaceHeaderId => x_sched_rec.header_id,
7969: x_InterfaceLineId => NULL,

Line 7966: x_ExceptionLevel => rlm_message_sv.k_warn_level,

7962: --
7963: ELSE
7964: --
7965: rlm_message_sv.app_error(
7966: x_ExceptionLevel => rlm_message_sv.k_warn_level,
7967: x_MessageName => 'RLM_FROZEN_DELETE',
7968: x_InterfaceHeaderId => x_sched_rec.header_id,
7969: x_InterfaceLineId => NULL,
7970: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 8574: rlm_message_sv.app_error(

8570: rlm_core_sv.dlog(k_DEBUG,'line_number', v_line_num);
8571: rlm_core_sv.dlog(k_DEBUG,'RLM_WRONG_SCHEDTYPE');
8572: END IF;
8573: --
8574: rlm_message_sv.app_error(
8575: x_ExceptionLevel => rlm_message_sv.k_warn_level,
8576: x_MessageName => 'RLM_WRONG_SCHEDTYPE',
8577: x_InterfaceHeaderId => x_sched_rec.header_id,
8578: x_InterfaceLineId => NULL,

Line 8575: x_ExceptionLevel => rlm_message_sv.k_warn_level,

8571: rlm_core_sv.dlog(k_DEBUG,'RLM_WRONG_SCHEDTYPE');
8572: END IF;
8573: --
8574: rlm_message_sv.app_error(
8575: x_ExceptionLevel => rlm_message_sv.k_warn_level,
8576: x_MessageName => 'RLM_WRONG_SCHEDTYPE',
8577: x_InterfaceHeaderId => x_sched_rec.header_id,
8578: x_InterfaceLineId => NULL,
8579: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 8611: rlm_message_sv.sql_error('rlm_rd_sv.ProcessOld',x_progress);

8607: --
8608: raise e_group_error;
8609:
8610: WHEN OTHERS THEN
8611: rlm_message_sv.sql_error('rlm_rd_sv.ProcessOld',x_progress);
8612: --
8613: IF (l_debug <> -1) THEN
8614: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
8615: END IF;

Line 8755: rlm_message_sv.sql_error('rlm_rd_sv.FetchReq',x_progress);

8751: END IF;
8752: --
8753: EXCEPTION
8754: WHEN OTHERS THEN
8755: rlm_message_sv.sql_error('rlm_rd_sv.FetchReq',x_progress);
8756: --
8757: IF (l_debug <> -1) THEN
8758: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
8759: END IF;

Line 8883: rlm_message_sv.sql_error('rlm_rd_sv.FetchDemand',x_progress);

8879: END IF;
8880:
8881: EXCEPTION
8882: WHEN OTHERS THEN
8883: rlm_message_sv.sql_error('rlm_rd_sv.FetchDemand',x_progress);
8884: --
8885: IF (l_debug <> -1) THEN
8886: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
8887: END IF;

Line 8953: rlm_message_sv.sql_error('rlm_rd_sv.SchedulePrecedence',x_progress);

8949: END IF;
8950:
8951: EXCEPTION
8952: WHEN OTHERS THEN
8953: rlm_message_sv.sql_error('rlm_rd_sv.SchedulePrecedence',x_progress);
8954: --
8955: IF (l_debug <> -1) THEN
8956: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
8957: END IF;

Line 9041: rlm_message_sv.sql_error('rlm_rd_sv.CountMatchedDemand',x_progress);

9037: --
9038: raise e_group_error;
9039:
9040: WHEN OTHERS THEN
9041: rlm_message_sv.sql_error('rlm_rd_sv.CountMatchedDemand',x_progress);
9042: --
9043: IF (l_debug <> -1) THEN
9044: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
9045: END IF;

Line 9139: rlm_message_sv.sql_error('rlm_rd_sv.ReconcileAction',x_progress);

9135: --
9136: raise e_group_error;
9137:
9138: WHEN OTHERS THEN
9139: rlm_message_sv.sql_error('rlm_rd_sv.ReconcileAction',x_progress);
9140: --
9141: IF (l_debug <> -1) THEN
9142: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
9143: END IF;

Line 10181: rlm_message_sv.sql_error('rlm_rd_sv.BuildMatchQuery',x_progress);

10177:
10178: EXCEPTION
10179:
10180: WHEN OTHERS THEN
10181: rlm_message_sv.sql_error('rlm_rd_sv.BuildMatchQuery',x_progress);
10182: IF (l_debug <> -1) THEN
10183: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
10184: END IF;
10185: RAISE;

Line 10653: rlm_message_sv.sql_error('rlm_rd_sv.ProcessATS',x_progress);

10649: --
10650: raise e_group_error;
10651:
10652: WHEN OTHERS THEN
10653: rlm_message_sv.sql_error('rlm_rd_sv.ProcessATS',x_progress);
10654: --
10655: IF (l_debug <> -1) THEN
10656: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
10657: END IF;

Line 10959: rlm_message_sv.sql_error('rlm_rd_sv.ProcessNATS',x_progress);

10955: --
10956: raise e_group_error;
10957:
10958: WHEN OTHERS THEN
10959: rlm_message_sv.sql_error('rlm_rd_sv.ProcessNATS',x_progress);
10960: --
10961: IF (l_debug <> -1) THEN
10962: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
10963: END IF;

Line 11061: rlm_message_sv.sql_error('rlm_rd_sv.UpdateDemand',x_progress);

11057: END IF;
11058: --
11059: EXCEPTION
11060: WHEN OTHERS THEN
11061: rlm_message_sv.sql_error('rlm_rd_sv.UpdateDemand',x_progress);
11062: --
11063: IF (l_debug <> -1) THEN
11064: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
11065: END IF;

Line 11122: rlm_message_sv.sql_error('rlm_rd_sv.DeleteDemand',x_progress);

11118: --
11119: raise e_group_error;
11120:
11121: WHEN OTHERS THEN
11122: rlm_message_sv.sql_error('rlm_rd_sv.DeleteDemand',x_progress);
11123: --
11124: IF (l_debug <> -1) THEN
11125: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
11126: END IF;

Line 11203: rlm_message_sv.app_error(

11199: GetMatchAttributes(x_sched_rec, x_group_rec, x_Key_rec.dem_rec,v_MatchAttrTxt);
11200: --
11201: IF (x_key_rec.dem_rec.schedule_type = 'SEQUENCED') THEN
11202: --
11203: rlm_message_sv.app_error(
11204: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11205: x_MessageName => 'RLM_FROZEN_UPDATE_SEQ',
11206: x_InterfaceHeaderId => x_sched_rec.header_id,
11207: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 11204: x_ExceptionLevel => rlm_message_sv.k_warn_level,

11200: --
11201: IF (x_key_rec.dem_rec.schedule_type = 'SEQUENCED') THEN
11202: --
11203: rlm_message_sv.app_error(
11204: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11205: x_MessageName => 'RLM_FROZEN_UPDATE_SEQ',
11206: x_InterfaceHeaderId => x_sched_rec.header_id,
11207: x_InterfaceLineId => x_key_rec.req_rec.line_id,
11208: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 11240: rlm_message_sv.app_error(

11236: END IF;
11237: --
11238: ELSE
11239: --
11240: rlm_message_sv.app_error(
11241: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11242: x_MessageName => 'RLM_FROZEN_UPDATE',
11243: x_InterfaceHeaderId => x_sched_rec.header_id,
11244: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 11241: x_ExceptionLevel => rlm_message_sv.k_warn_level,

11237: --
11238: ELSE
11239: --
11240: rlm_message_sv.app_error(
11241: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11242: x_MessageName => 'RLM_FROZEN_UPDATE',
11243: x_InterfaceHeaderId => x_sched_rec.header_id,
11244: x_InterfaceLineId => x_key_rec.req_rec.line_id,
11245: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 11314: rlm_message_sv.sql_error('rlm_rd_sv.IncreaseDemand',x_progress);

11310: END IF;
11311: --
11312: EXCEPTION
11313: WHEN OTHERS THEN
11314: rlm_message_sv.sql_error('rlm_rd_sv.IncreaseDemand',x_progress);
11315: --
11316: IF (l_debug <> -1) THEN
11317: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
11318: END IF;

Line 11412: rlm_message_sv.app_error(

11408: GetMatchAttributes(x_sched_rec, x_group_rec, x_Key_rec.dem_rec,v_MatchAttrTxt);
11409: --
11410: IF (x_key_rec.dem_rec.schedule_type = 'SEQUENCED') THEN
11411: --
11412: rlm_message_sv.app_error(
11413: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11414: x_MessageName => 'RLM_FROZEN_UPDATE_SEQ',
11415: x_InterfaceHeaderId => x_sched_rec.header_id,
11416: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 11413: x_ExceptionLevel => rlm_message_sv.k_warn_level,

11409: --
11410: IF (x_key_rec.dem_rec.schedule_type = 'SEQUENCED') THEN
11411: --
11412: rlm_message_sv.app_error(
11413: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11414: x_MessageName => 'RLM_FROZEN_UPDATE_SEQ',
11415: x_InterfaceHeaderId => x_sched_rec.header_id,
11416: x_InterfaceLineId => x_key_rec.req_rec.line_id,
11417: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 11449: rlm_message_sv.app_error(

11445: END IF;
11446: --
11447: ELSE
11448: --
11449: rlm_message_sv.app_error(
11450: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11451: x_MessageName => 'RLM_FROZEN_UPDATE',
11452: x_InterfaceHeaderId => x_sched_rec.header_id,
11453: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 11450: x_ExceptionLevel => rlm_message_sv.k_warn_level,

11446: --
11447: ELSE
11448: --
11449: rlm_message_sv.app_error(
11450: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11451: x_MessageName => 'RLM_FROZEN_UPDATE',
11452: x_InterfaceHeaderId => x_sched_rec.header_id,
11453: x_InterfaceLineId => x_key_rec.req_rec.line_id,
11454: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 11524: rlm_message_sv.sql_error('rlm_rd_sv.DecreaseDemand',x_progress);

11520: --
11521: raise e_group_error;
11522:
11523: WHEN OTHERS THEN
11524: rlm_message_sv.sql_error('rlm_rd_sv.DecreaseDemand',x_progress);
11525: --
11526: IF (l_debug <> -1) THEN
11527: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
11528: END IF;

Line 11603: rlm_message_sv.app_error(

11599: GetMatchAttributes(x_sched_rec, x_group_rec, x_Key_rec.dem_rec,v_MatchAttrTxt);
11600: --
11601: IF (x_Key_rec.dem_rec.schedule_type = 'SEQUENCED') THEN
11602: --
11603: rlm_message_sv.app_error(
11604: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11605: x_MessageName => 'RLM_UNABLE_ATTR_UPDATE_SEQ',
11606: x_InterfaceHeaderId => x_sched_rec.header_id,
11607: x_InterfaceLineId => x_Key_rec.req_rec.line_id,

Line 11604: x_ExceptionLevel => rlm_message_sv.k_warn_level,

11600: --
11601: IF (x_Key_rec.dem_rec.schedule_type = 'SEQUENCED') THEN
11602: --
11603: rlm_message_sv.app_error(
11604: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11605: x_MessageName => 'RLM_UNABLE_ATTR_UPDATE_SEQ',
11606: x_InterfaceHeaderId => x_sched_rec.header_id,
11607: x_InterfaceLineId => x_Key_rec.req_rec.line_id,
11608: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 11638: rlm_message_sv.app_error(

11634: END IF;
11635: --
11636: ELSE
11637: --
11638: rlm_message_sv.app_error(
11639: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11640: x_MessageName => 'RLM_UNABLE_ATTR_UPDATE',
11641: x_InterfaceHeaderId => x_sched_rec.header_id,
11642: x_InterfaceLineId => x_Key_rec.req_rec.line_id,

Line 11639: x_ExceptionLevel => rlm_message_sv.k_warn_level,

11635: --
11636: ELSE
11637: --
11638: rlm_message_sv.app_error(
11639: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11640: x_MessageName => 'RLM_UNABLE_ATTR_UPDATE',
11641: x_InterfaceHeaderId => x_sched_rec.header_id,
11642: x_InterfaceLineId => x_Key_rec.req_rec.line_id,
11643: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 11677: rlm_message_sv.app_error(

11673: GetMatchAttributes(x_sched_rec, x_group_rec, x_Key_rec.dem_rec,v_MatchAttrTxt);
11674: --
11675: IF (x_key_rec.dem_rec.schedule_type = 'SEQUENCED') THEN
11676: --
11677: rlm_message_sv.app_error(
11678: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11679: x_MessageName => 'RLM_FROZEN_UPDATE_SEQ',
11680: x_InterfaceHeaderId => x_sched_rec.header_id,
11681: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 11678: x_ExceptionLevel => rlm_message_sv.k_warn_level,

11674: --
11675: IF (x_key_rec.dem_rec.schedule_type = 'SEQUENCED') THEN
11676: --
11677: rlm_message_sv.app_error(
11678: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11679: x_MessageName => 'RLM_FROZEN_UPDATE_SEQ',
11680: x_InterfaceHeaderId => x_sched_rec.header_id,
11681: x_InterfaceLineId => x_key_rec.req_rec.line_id,
11682: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 11714: rlm_message_sv.app_error(

11710: END IF;
11711: --
11712: ELSE
11713: --
11714: rlm_message_sv.app_error(
11715: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11716: x_MessageName => 'RLM_FROZEN_UPDATE',
11717: x_InterfaceHeaderId => x_sched_rec.header_id,
11718: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 11715: x_ExceptionLevel => rlm_message_sv.k_warn_level,

11711: --
11712: ELSE
11713: --
11714: rlm_message_sv.app_error(
11715: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11716: x_MessageName => 'RLM_FROZEN_UPDATE',
11717: x_InterfaceHeaderId => x_sched_rec.header_id,
11718: x_InterfaceLineId => x_key_rec.req_rec.line_id,
11719: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 11770: rlm_message_sv.sql_error('rlm_rd_sv.OtherDemand',x_progress);

11766: END IF;
11767: --
11768: EXCEPTION
11769: WHEN OTHERS THEN
11770: rlm_message_sv.sql_error('rlm_rd_sv.OtherDemand',x_progress);
11771: --
11772: IF (l_debug <> -1) THEN
11773: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
11774: END IF;

Line 11919: rlm_message_sv.sql_error('rlm_rd_sv.SetOperation',x_progress);

11915: END IF;
11916: --
11917: EXCEPTION
11918: WHEN OTHERS THEN
11919: rlm_message_sv.sql_error('rlm_rd_sv.SetOperation',x_progress);
11920: --
11921: IF (l_debug <> -1) THEN
11922: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
11923: END IF;

Line 11974: rlm_message_sv.sql_error('rlm_rd_sv.IsLineConsumable',x_progress);

11970: RETURN TRUE;
11971: --
11972: EXCEPTION
11973: WHEN OTHERS THEN
11974: rlm_message_sv.sql_error('rlm_rd_sv.IsLineConsumable',x_progress);
11975: --
11976: IF (l_debug <> -1) THEN
11977: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
11978: END IF;

Line 12081: rlm_message_sv.sql_error('rlm_rd_sv.UpdateGroupStatus',x_progress);

12077: EXCEPTION
12078: --
12079: WHEN OTHERS THEN
12080: --
12081: rlm_message_sv.sql_error('rlm_rd_sv.UpdateGroupStatus',x_progress);
12082: --
12083: IF (l_debug <> -1) THEN
12084: rlm_core_sv.dlog(k_DEBUG,'progress',x_Progress);
12085: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: OTHER - sql error');

Line 12155: rlm_message_sv.sql_error('rlm_rd_sv.IsFrozen', x_progress);

12151: EXCEPTION
12152: --
12153: WHEN OTHERS THEN
12154: --
12155: rlm_message_sv.sql_error('rlm_rd_sv.IsFrozen', x_progress);
12156: --
12157: IF (l_debug <> -1) THEN
12158: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
12159: END IF;

Line 12212: rlm_message_sv.sql_error('rlm_rd_sv.LockHeaders',x_progress);

12208: --
12209: RETURN FALSE;
12210: --
12211: WHEN OTHERS THEN
12212: rlm_message_sv.sql_error('rlm_rd_sv.LockHeaders',x_progress);
12213: --
12214: IF (l_debug <> -1) THEN
12215: rlm_core_sv.dlog(k_DEBUG,'REturning FALSE OTHERS ');
12216: rlm_core_sv.dlog(k_DEBUG,'progress',x_Progress);

Line 12259: rlm_message_sv.sql_error('rlm_rd_sv.UpdateHeaderStatus',x_progress);

12255: EXCEPTION
12256: --
12257: WHEN OTHERS THEN
12258: --
12259: rlm_message_sv.sql_error('rlm_rd_sv.UpdateHeaderStatus',x_progress);
12260: --
12261: IF (l_debug <> -1) THEN
12262: rlm_core_sv.dlog(k_DEBUG,'progress',x_Progress);
12263: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: OTHER - sql error');

Line 12325: rlm_message_sv.sql_error('rlm_rd_sv.LockLines',x_progress);

12321: --
12322: RETURN FALSE;
12323: --
12324: WHEN OTHERS THEN
12325: rlm_message_sv.sql_error('rlm_rd_sv.LockLines',x_progress);
12326: --
12327: IF (l_debug <> -1) THEN
12328: rlm_core_sv.dlog(k_DEBUG,'REturning FALSE OTHERS ');
12329: rlm_core_sv.dlog(k_DEBUG,'progress',x_Progress);

Line 12387: rlm_message_sv.app_error(

12383: --
12384: IF (x_DemandTolerancePos < v_PctDelta) OR
12385: (x_DemandToleranceNeg < ABS(v_PctDelta)) THEN
12386: --
12387: rlm_message_sv.app_error(
12388: x_ExceptionLevel => rlm_message_sv.k_warn_level,
12389: x_MessageName => 'RLM_TOLERANCE_CHECK_FAILED',
12390: x_InterfaceHeaderId => x_sched_rec.header_id,
12391: x_InterfaceLineId => x_Key_rec.req_rec.line_id,

Line 12388: x_ExceptionLevel => rlm_message_sv.k_warn_level,

12384: IF (x_DemandTolerancePos < v_PctDelta) OR
12385: (x_DemandToleranceNeg < ABS(v_PctDelta)) THEN
12386: --
12387: rlm_message_sv.app_error(
12388: x_ExceptionLevel => rlm_message_sv.k_warn_level,
12389: x_MessageName => 'RLM_TOLERANCE_CHECK_FAILED',
12390: x_InterfaceHeaderId => x_sched_rec.header_id,
12391: x_InterfaceLineId => x_Key_rec.req_rec.line_id,
12392: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 12422: rlm_message_sv.sql_error('rlm_rd_sv.CheckTolerance', v_Progress);

12418: EXCEPTION
12419: --
12420: WHEN OTHERS THEN
12421: --
12422: rlm_message_sv.sql_error('rlm_rd_sv.CheckTolerance', v_Progress);
12423: --
12424: IF (l_debug <> -1) THEN
12425: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: OTHERS - sql error');
12426: END IF;

Line 12809: rlm_message_sv.sql_error('rlm_rd_sv.GetTPContext',v_Progress);

12805: rlm_core_sv.dpop(k_SDEBUG);
12806: END IF;
12807: --
12808: WHEN OTHERS THEN
12809: rlm_message_sv.sql_error('rlm_rd_sv.GetTPContext',v_Progress);
12810: --
12811: IF (l_debug <> -1) THEN
12812: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
12813: END IF;

Line 12895: rlm_message_sv.sql_error('RLM_RD_SV.InitializeMatchRec', x_progress);

12891: END IF;
12892: --
12893: EXCEPTION
12894: WHEN OTHERS THEN
12895: rlm_message_sv.sql_error('RLM_RD_SV.InitializeMatchRec', x_progress);
12896: --
12897: IF (l_debug <> -1) THEN
12898: rlm_core_sv.dpop(k_SDEBUG, 'EXCEPTION: ' || SUBSTR(SQLERRM,1,200));
12899: END IF;

Line 12979: rlm_message_sv.sql_error('RLM_RD_SV.FetchMatchRec', x_progress);

12975: END IF;
12976: --
12977: EXCEPTION
12978: WHEN OTHERS THEN
12979: rlm_message_sv.sql_error('RLM_RD_SV.FetchMatchRec', x_progress);
12980: --
12981: IF (l_debug <> -1) THEN
12982: rlm_core_sv.dpop(k_SDEBUG, 'EXCEPTION: ' || SUBSTR(SQLERRM,1,200));
12983: END IF;

Line 13567: rlm_message_sv.sql_error('RLM_RD_SV.MRPOnly', v_Progress);

13563: EXCEPTION
13564: --
13565: WHEN OTHERS THEN
13566: --
13567: rlm_message_sv.sql_error('RLM_RD_SV.MRPOnly', v_Progress);
13568: --
13569: IF (l_debug <> -1) THEN
13570: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
13571: END IF;

Line 14002: rlm_message_sv.sql_error('rlm_rd_sv.InitializeBlktGrp',x_progress);

13998: --
13999: EXCEPTION
14000: --
14001: WHEN OTHERS THEN
14002: rlm_message_sv.sql_error('rlm_rd_sv.InitializeBlktGrp',x_progress);
14003: --
14004: IF (l_debug <> -1) THEN
14005: rlm_core_sv.dlog(k_DEBUG, 'When others of InitializeBlktGrp');
14006: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 14072: rlm_message_sv.sql_error('rlm_rd_sv.FetchBlktGrp',x_progress);

14068: --
14069: EXCEPTION
14070: --
14071: WHEN OTHERS THEN
14072: rlm_message_sv.sql_error('rlm_rd_sv.FetchBlktGrp',x_progress);
14073: --
14074: IF (l_debug <> -1) THEN
14075: rlm_core_sv.dlog(k_DEBUG, 'When others of FetchBlktGrp');
14076: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 14124: rlm_message_sv.sql_error('rlm_rd_sv.BuildBindVarTab3',x_progress);

14120: EXCEPTION
14121: --
14122: WHEN OTHERS THEN
14123: --
14124: rlm_message_sv.sql_error('rlm_rd_sv.BuildBindVarTab3',x_progress);
14125: --
14126: IF (l_debug <> -1) THEN
14127: rlm_core_sv.dpop(k_SDEBUG, 'Exception ' || substr(SQLERRM, 1, 200));
14128: END IF;

Line 14181: rlm_message_sv.sql_error('rlm_rd_sv.BuildBindVarTab5',x_progress);

14177: EXCEPTION
14178: --
14179: WHEN OTHERS THEN
14180: --
14181: rlm_message_sv.sql_error('rlm_rd_sv.BuildBindVarTab5',x_progress);
14182: --
14183: IF (l_debug <> -1) THEN
14184: rlm_core_sv.dpop(k_SDEBUG, 'Exception ' || substr(SQLERRM, 1, 200));
14185: END IF;

Line 14223: rlm_message_sv.sql_error('rlm_rd_sv.BuildBindVarTab2',x_progress);

14219: EXCEPTION
14220: --
14221: WHEN OTHERS THEN
14222: --
14223: rlm_message_sv.sql_error('rlm_rd_sv.BuildBindVarTab2',x_progress);
14224: --
14225: IF (l_debug <> -1) THEN
14226: rlm_core_sv.dpop(k_SDEBUG, 'Exception ' || substr(SQLERRM, 1, 200));
14227: END IF;

Line 14333: rlm_message_sv.sql_error('RLM_RD_SV.SourceCUMIntransitQty',v_Progress);

14329: EXCEPTION
14330: --
14331: WHEN OTHERS THEN
14332: --
14333: rlm_message_sv.sql_error('RLM_RD_SV.SourceCUMIntransitQty',v_Progress);
14334: --
14335: IF (l_debug <> -1) THEN
14336: rlm_core_sv.dlog(k_DEBUG,'progress',v_Progress);
14337: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 14421: rlm_message_sv.get_msg_text(

14417: --
14418: IF v_cum_record.cum_key_id IS NULL THEN
14419: --Bugfix 7007638
14420: IF x_Group_rec.setup_terms_rec.cum_control_code IN ('CUM_BY_DATE_PO','CUM_BY_PO_ONLY') THEN
14421: rlm_message_sv.get_msg_text(
14422: x_message_name => 'RLM_CUM_CONTROL_PO',
14423: x_text => v_control_text);
14424: v_control_value := v_cum_key_record.purchase_order_number;
14425: ELSIF x_Group_rec.setup_terms_rec.cum_control_code IN ('CUM_BY_DATE_RECORD_YEAR') THEN

Line 14426: rlm_message_sv.get_msg_text(

14422: x_message_name => 'RLM_CUM_CONTROL_PO',
14423: x_text => v_control_text);
14424: v_control_value := v_cum_key_record.purchase_order_number;
14425: ELSIF x_Group_rec.setup_terms_rec.cum_control_code IN ('CUM_BY_DATE_RECORD_YEAR') THEN
14426: rlm_message_sv.get_msg_text(
14427: x_message_name => 'RLM_CUM_CONTROL_RY',
14428: x_text => v_control_text);
14429: v_control_value := v_cum_key_record.cust_record_year;
14430: ELSIF x_Group_rec.setup_terms_rec.cum_control_code IN ('CUM_BY_DATE_ONLY') THEN

Line 14431: rlm_message_sv.get_msg_text(

14427: x_message_name => 'RLM_CUM_CONTROL_RY',
14428: x_text => v_control_text);
14429: v_control_value := v_cum_key_record.cust_record_year;
14430: ELSIF x_Group_rec.setup_terms_rec.cum_control_code IN ('CUM_BY_DATE_ONLY') THEN
14431: rlm_message_sv.get_msg_text(
14432: x_message_name => 'RLM_CUM_CONTROL_DATE',
14433: x_text => v_control_text);
14434: v_control_value := v_cum_key_record.cum_start_date;
14435: END IF;

Line 14469: rlm_message_sv.app_error(

14465: -- 4307505 [
14466: WHEN NO_DATA_FOUND THEN
14467: v_Intransit := 0;
14468: x_Intransit := 0;
14469: rlm_message_sv.app_error(
14470: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14471: x_MessageName => 'RLM_NO_CUM_INTRST_CUST_CUM',
14472: x_InterfaceHeaderId => x_sched_rec.header_id,
14473: x_InterfaceLineId => NULL,

Line 14470: x_ExceptionLevel => rlm_message_sv.k_warn_level,

14466: WHEN NO_DATA_FOUND THEN
14467: v_Intransit := 0;
14468: x_Intransit := 0;
14469: rlm_message_sv.app_error(
14470: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14471: x_MessageName => 'RLM_NO_CUM_INTRST_CUST_CUM',
14472: x_InterfaceHeaderId => x_sched_rec.header_id,
14473: x_InterfaceLineId => NULL,
14474: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 14494: rlm_message_sv.app_error(

14490: END IF;
14491: -- 4307505 ]
14492: WHEN e_no_cum_key THEN
14493: --
14494: rlm_message_sv.app_error(
14495: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14496: x_MessageName => 'RLM_CUM_KEY_MISSING',
14497: x_InterfaceHeaderId => x_sched_rec.header_id,
14498: x_InterfaceLineId => NULL,

Line 14495: x_ExceptionLevel => rlm_message_sv.k_warn_level,

14491: -- 4307505 ]
14492: WHEN e_no_cum_key THEN
14493: --
14494: rlm_message_sv.app_error(
14495: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14496: x_MessageName => 'RLM_CUM_KEY_MISSING',
14497: x_InterfaceHeaderId => x_sched_rec.header_id,
14498: x_InterfaceLineId => NULL,
14499: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 14517: rlm_message_sv.sql_error('rlm_rd_sv.CalculateCUMIntransit',v_progress);

14513: rlm_core_sv.dpop(k_SDEBUG);
14514: END IF;
14515: --
14516: WHEN OTHERS THEN
14517: rlm_message_sv.sql_error('rlm_rd_sv.CalculateCUMIntransit',v_progress);
14518: --
14519: IF (l_debug <> -1) THEN
14520: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
14521: END IF;

Line 14616: rlm_message_sv.sql_error('RLM_RD_SV.AssignOEAttribValues', '010');

14612: EXCEPTION
14613: --
14614: WHEN OTHERS THEN
14615: --
14616: rlm_message_sv.sql_error('RLM_RD_SV.AssignOEAttribValues', '010');
14617: --
14618: IF (l_debug <> -1) THEN
14619: rlm_core_sv.dlog(k_DEBUG, 'Unexpected error', SUBSTRB(SQLERRM, 1, 200));
14620: rlm_core_sv.dpop(k_SDEBUG);

Line 14750: rlm_message_sv.app_error(

14746: rlm_core_sv.dlog(k_DEBUG,'Customer Item Id', x_group_rec.customer_item_id);
14747: rlm_core_sv.dlog(k_DEBUG,'Matching Attributes', v_MatchAttrTxt);
14748: END IF;
14749: --
14750: rlm_message_sv.app_error(
14751: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14752: x_MessageName => 'RLM_FROZEN_OVERALL_WARN_UNDER',
14753: x_InterfaceHeaderId => x_sched_rec.header_id,
14754: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 14751: x_ExceptionLevel => rlm_message_sv.k_warn_level,

14747: rlm_core_sv.dlog(k_DEBUG,'Matching Attributes', v_MatchAttrTxt);
14748: END IF;
14749: --
14750: rlm_message_sv.app_error(
14751: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14752: x_MessageName => 'RLM_FROZEN_OVERALL_WARN_UNDER',
14753: x_InterfaceHeaderId => x_sched_rec.header_id,
14754: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,
14755: x_OrderHeaderId => x_group_rec.setup_terms_rec.header_id,

Line 14781: rlm_message_sv.app_error(

14777: rlm_core_sv.dlog(k_DEBUG,'Matching Attributes', v_MatchAttrTxt);
14778: --
14779: END IF;
14780: --
14781: rlm_message_sv.app_error(
14782: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14783: x_MessageName => 'RLM_FROZEN_OVERALL_WARN_OVER',
14784: x_InterfaceHeaderId => x_sched_rec.header_id,
14785: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 14782: x_ExceptionLevel => rlm_message_sv.k_warn_level,

14778: --
14779: END IF;
14780: --
14781: rlm_message_sv.app_error(
14782: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14783: x_MessageName => 'RLM_FROZEN_OVERALL_WARN_OVER',
14784: x_InterfaceHeaderId => x_sched_rec.header_id,
14785: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,
14786: x_OrderHeaderId => x_group_rec.setup_terms_rec.header_id,

Line 14814: rlm_message_sv.app_error(

14810: rlm_core_sv.dlog(k_DEBUG,'Customer Item Id', x_group_rec.customer_item_id);
14811: rlm_core_sv.dlog(k_DEBUG,'Matching Attributes', v_MatchAttrTxt);
14812: END IF;
14813: --
14814: rlm_message_sv.app_error(
14815: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14816: x_MessageName => 'RLM_FROZEN_OVERALL_QTY_UNDER',
14817: x_InterfaceHeaderId => x_sched_rec.header_id,
14818: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 14815: x_ExceptionLevel => rlm_message_sv.k_warn_level,

14811: rlm_core_sv.dlog(k_DEBUG,'Matching Attributes', v_MatchAttrTxt);
14812: END IF;
14813: --
14814: rlm_message_sv.app_error(
14815: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14816: x_MessageName => 'RLM_FROZEN_OVERALL_QTY_UNDER',
14817: x_InterfaceHeaderId => x_sched_rec.header_id,
14818: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,
14819: x_OrderHeaderId => x_group_rec.setup_terms_rec.header_id,

Line 14847: rlm_message_sv.app_error(

14843: rlm_core_sv.dlog(k_DEBUG,'Matching Attributes', v_MatchAttrTxt);
14844: --
14845: END IF;
14846: --
14847: rlm_message_sv.app_error(
14848: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14849: x_MessageName => 'RLM_FROZEN_OVERALL_QTY_OVER',
14850: x_InterfaceHeaderId => x_sched_rec.header_id,
14851: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 14848: x_ExceptionLevel => rlm_message_sv.k_warn_level,

14844: --
14845: END IF;
14846: --
14847: rlm_message_sv.app_error(
14848: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14849: x_MessageName => 'RLM_FROZEN_OVERALL_QTY_OVER',
14850: x_InterfaceHeaderId => x_sched_rec.header_id,
14851: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,
14852: x_OrderHeaderId => x_group_rec.setup_terms_rec.header_id,

Line 14884: rlm_message_sv.sql_error('RLM_RD_SV.FrozenFenceWarning', '010');

14880: --}
14881: EXCEPTION
14882: WHEN OTHERS THEN
14883: --
14884: rlm_message_sv.sql_error('RLM_RD_SV.FrozenFenceWarning', '010');
14885: --
14886: IF (l_debug <> -1) THEN
14887: rlm_core_sv.dlog(k_DEBUG, 'Unexpected error', SUBSTRB(SQLERRM, 1, 200));
14888: rlm_core_sv.dpop(k_SDEBUG);

Line 15161: rlm_message_sv.sql_error('RLM_RD_SV.GetMatchAttributes', '010');

15157: --
15158: EXCEPTION
15159: WHEN OTHERS THEN
15160: --
15161: rlm_message_sv.sql_error('RLM_RD_SV.GetMatchAttributes', '010');
15162: --
15163: IF (l_debug <> -1) THEN
15164: rlm_core_sv.dlog(k_DEBUG, 'Unexpected error', SUBSTRB(SQLERRM, 1, 200));
15165: rlm_core_sv.dpop(k_SDEBUG);

Line 15434: rlm_message_sv.sql_error('rlm_rd_sv.PopulateReconcileCumRec',

15430: EXCEPTION
15431:
15432: WHEN OTHERS THEN
15433: --
15434: rlm_message_sv.sql_error('rlm_rd_sv.PopulateReconcileCumRec',
15435: v_Progress);
15436: --
15437: IF (l_debug <> -1) THEN
15438: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 15544: rlm_message_sv.sql_error('rlm_rd_sv.Match_PO_RY_Reconcile',x_progress);

15540: RETURN(b_Match);
15541: --
15542: EXCEPTION
15543: WHEN OTHERS THEN
15544: rlm_message_sv.sql_error('rlm_rd_sv.Match_PO_RY_Reconcile',x_progress);
15545: --
15546: IF (l_debug <> -1) THEN
15547: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
15548: END IF;