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 1193: rlm_message_sv.app_error(

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

Line 1194: x_ExceptionLevel => rlm_message_sv.k_warn_level,

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

Line 1227: rlm_message_sv.app_error(

1223: END IF;
1224: --
1225: ELSE
1226: --
1227: rlm_message_sv.app_error(
1228: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1229: x_MessageName => 'RLM_FROZEN_DELETE',
1230: x_InterfaceHeaderId => x_sched_rec.header_id,
1231: x_InterfaceLineId => NULL,

Line 1228: x_ExceptionLevel => rlm_message_sv.k_warn_level,

1224: --
1225: ELSE
1226: --
1227: rlm_message_sv.app_error(
1228: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1229: x_MessageName => 'RLM_FROZEN_DELETE',
1230: x_InterfaceHeaderId => x_sched_rec.header_id,
1231: x_InterfaceLineId => NULL,
1232: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 1421: rlm_message_sv.app_error(

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

Line 1422: x_ExceptionLevel => rlm_message_sv.k_warn_level,

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

Line 1462: rlm_message_sv.app_error(

1458: END IF;
1459: --
1460: ELSE
1461: --
1462: rlm_message_sv.app_error(
1463: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1464: x_MessageName => 'RLM_RECONCILE_DELETE',
1465: x_InterfaceHeaderId => x_sched_rec.header_id,
1466: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 1463: x_ExceptionLevel => rlm_message_sv.k_warn_level,

1459: --
1460: ELSE
1461: --
1462: rlm_message_sv.app_error(
1463: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1464: x_MessageName => 'RLM_RECONCILE_DELETE',
1465: x_InterfaceHeaderId => x_sched_rec.header_id,
1466: x_InterfaceLineId => x_key_rec.req_rec.line_id,
1467: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

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

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

Line 1601: rlm_message_sv.app_error(

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

Line 1602: x_ExceptionLevel => rlm_message_sv.k_warn_level,

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

Line 1638: rlm_message_sv.app_error(

1634: END IF;
1635: --
1636: ELSE
1637: --
1638: rlm_message_sv.app_error(
1639: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1640: x_MessageName => 'RLM_RECONCILE_ZERO_INSERT',
1641: x_InterfaceHeaderId => x_sched_rec.header_id,
1642: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 1639: x_ExceptionLevel => rlm_message_sv.k_warn_level,

1635: --
1636: ELSE
1637: --
1638: rlm_message_sv.app_error(
1639: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1640: x_MessageName => 'RLM_RECONCILE_ZERO_INSERT',
1641: x_InterfaceHeaderId => x_sched_rec.header_id,
1642: x_InterfaceLineId => x_key_rec.req_rec.line_id,
1643: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 1776: rlm_message_sv.app_error(

1772: GetMatchAttributes(x_sched_rec, x_group_rec, x_key_rec.req_rec, v_MatchAttrTxt);
1773: --
1774: IF (x_sched_rec.schedule_type = 'SEQUENCED') THEN
1775: --
1776: rlm_message_sv.app_error(
1777: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1778: x_MessageName => 'RLM_LOW_PRECEDENCE_INSERT_SEQ',
1779: x_InterfaceHeaderId => x_sched_rec.header_id,
1780: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 1777: x_ExceptionLevel => rlm_message_sv.k_warn_level,

1773: --
1774: IF (x_sched_rec.schedule_type = 'SEQUENCED') THEN
1775: --
1776: rlm_message_sv.app_error(
1777: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1778: x_MessageName => 'RLM_LOW_PRECEDENCE_INSERT_SEQ',
1779: x_InterfaceHeaderId => x_sched_rec.header_id,
1780: x_InterfaceLineId => x_key_rec.req_rec.line_id,
1781: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 1821: rlm_message_sv.app_error(

1817: END IF;
1818: --
1819: ELSE
1820: --
1821: rlm_message_sv.app_error(
1822: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1823: x_MessageName => 'RLM_LOW_PRECEDENCE_INSERT',
1824: x_InterfaceHeaderId => x_sched_rec.header_id,
1825: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 1822: x_ExceptionLevel => rlm_message_sv.k_warn_level,

1818: --
1819: ELSE
1820: --
1821: rlm_message_sv.app_error(
1822: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1823: x_MessageName => 'RLM_LOW_PRECEDENCE_INSERT',
1824: x_InterfaceHeaderId => x_sched_rec.header_id,
1825: x_InterfaceLineId => x_key_rec.req_rec.line_id,
1826: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 1890: rlm_message_sv.app_error(

1886: --
1887: IF g_inc_exception <> 'Y' THEN --Bugfix 6159269
1888: IF (x_sched_rec.schedule_type = 'SEQUENCED') THEN
1889: --
1890: rlm_message_sv.app_error(
1891: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1892: x_MessageName => 'RLM_FROZEN_INSERT_SEQ',
1893: x_InterfaceHeaderId => x_sched_rec.header_id,
1894: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 1891: x_ExceptionLevel => rlm_message_sv.k_warn_level,

1887: IF g_inc_exception <> 'Y' THEN --Bugfix 6159269
1888: IF (x_sched_rec.schedule_type = 'SEQUENCED') THEN
1889: --
1890: rlm_message_sv.app_error(
1891: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1892: x_MessageName => 'RLM_FROZEN_INSERT_SEQ',
1893: x_InterfaceHeaderId => x_sched_rec.header_id,
1894: x_InterfaceLineId => x_key_rec.req_rec.line_id,
1895: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 1924: rlm_message_sv.app_error(

1920: END IF;
1921: --
1922: ELSE
1923: --
1924: rlm_message_sv.app_error(
1925: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1926: x_MessageName => 'RLM_FROZEN_INSERT',
1927: x_InterfaceHeaderId => x_sched_rec.header_id,
1928: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 1925: x_ExceptionLevel => rlm_message_sv.k_warn_level,

1921: --
1922: ELSE
1923: --
1924: rlm_message_sv.app_error(
1925: x_ExceptionLevel => rlm_message_sv.k_warn_level,
1926: x_MessageName => 'RLM_FROZEN_INSERT',
1927: x_InterfaceHeaderId => x_sched_rec.header_id,
1928: x_InterfaceLineId => x_key_rec.req_rec.line_id,
1929: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

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

1955: END IF; /*IF g_inc_exception */ --Bugfix 6159269
1956:
1957: -- Bug 4297984 End
1958: WHEN OTHERS THEN
1959: rlm_message_sv.sql_error('rlm_rd_sv.InsertRequirement',x_progress);
1960: --
1961: IF (l_debug <> -1) THEN
1962: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
1963: END IF;

Line 2015: rlm_message_sv.app_error(

2011: IF x_Key_rec.dem_rec.ordered_quantity <> g_sch_line_qty THEN --Bugfix 6159269
2012: --
2013: IF (x_key_rec.dem_rec.schedule_type = 'SEQUENCED') THEN
2014: --
2015: rlm_message_sv.app_error(
2016: x_ExceptionLevel => rlm_message_sv.k_warn_level,
2017: x_MessageName => 'RLM_FROZEN_UPDATE_SEQ',
2018: x_InterfaceHeaderId => x_sched_rec.header_id,
2019: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 2016: x_ExceptionLevel => rlm_message_sv.k_warn_level,

2012: --
2013: IF (x_key_rec.dem_rec.schedule_type = 'SEQUENCED') THEN
2014: --
2015: rlm_message_sv.app_error(
2016: x_ExceptionLevel => rlm_message_sv.k_warn_level,
2017: x_MessageName => 'RLM_FROZEN_UPDATE_SEQ',
2018: x_InterfaceHeaderId => x_sched_rec.header_id,
2019: x_InterfaceLineId => x_key_rec.req_rec.line_id,
2020: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 2052: rlm_message_sv.app_error(

2048: END IF;
2049: --
2050: ELSE
2051: --
2052: rlm_message_sv.app_error(
2053: x_ExceptionLevel => rlm_message_sv.k_warn_level,
2054: x_MessageName => 'RLM_FROZEN_UPDATE',
2055: x_InterfaceHeaderId => x_sched_rec.header_id,
2056: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 2053: x_ExceptionLevel => rlm_message_sv.k_warn_level,

2049: --
2050: ELSE
2051: --
2052: rlm_message_sv.app_error(
2053: x_ExceptionLevel => rlm_message_sv.k_warn_level,
2054: x_MessageName => 'RLM_FROZEN_UPDATE',
2055: x_InterfaceHeaderId => x_sched_rec.header_id,
2056: x_InterfaceLineId => x_key_rec.req_rec.line_id,
2057: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

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

2141: END IF;
2142: --
2143: EXCEPTION
2144: WHEN OTHERS THEN
2145: rlm_message_sv.sql_error('rlm_rd_sv.UpdateRequirement',x_progress);
2146: --
2147: IF (l_debug <> -1) THEN
2148: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
2149: END IF;

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

2170: END IF;
2171:
2172: EXCEPTION
2173: WHEN OTHERS THEN
2174: rlm_message_sv.sql_error('rlm_rd_sv.GetQtyRec',x_progress);
2175: --
2176: IF (l_debug <> -1) THEN
2177: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
2178: END IF;

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

2208: END IF;
2209: --
2210: EXCEPTION
2211: WHEN OTHERS THEN
2212: rlm_message_sv.sql_error('rlm_rd_sv.GetReq',x_progress);
2213: --
2214: IF (l_debug <> -1) THEN
2215: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
2216: END IF;

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

2418: END IF;
2419: --
2420: EXCEPTION
2421: WHEN OTHERS THEN
2422: rlm_message_sv.sql_error('rlm_rd_sv.GetDemand',x_progress);
2423: --
2424: IF (l_debug <> -1) THEN
2425: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
2426: END IF;

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

3346: WHEN e_no_init THEN
3347: rlm_core_sv.dpop(k_SDEBUG,'Demand Type is not ATS or NATS');
3348:
3349: WHEN OTHERS THEN
3350: rlm_message_sv.sql_error('rlm_rd_sv.InitializeDemand',x_progress);
3351: --
3352: IF (l_debug <> -1) THEN
3353: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
3354: END IF;

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

3419: END IF;
3420: --
3421: EXCEPTION
3422: WHEN OTHERS THEN
3423: rlm_message_sv.sql_error('rlm_rd_sv.InitializeSoGroup',x_progress);
3424: --
3425: IF (l_debug <> -1) THEN
3426: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
3427: END IF;

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

3668: END IF;
3669: --
3670: EXCEPTION
3671: WHEN OTHERS THEN
3672: rlm_message_sv.sql_error('rlm_rd_sv.InitializeReq',x_progress);
3673: --
3674: IF (l_debug <> -1) THEN
3675: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
3676: END IF;

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

3707: END IF;
3708: --
3709: EXCEPTION
3710: WHEN OTHERS THEN
3711: rlm_message_sv.sql_error('rlm_rd_sv.CancelRequirement',x_progress);
3712: --
3713: IF (l_debug <> -1) THEN
3714: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
3715: END IF;

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

4080: rlm_core_sv.dpop(k_SDEBUG,'e_cumDiscrete');
4081: END IF;
4082: --
4083: WHEN OTHERS THEN
4084: rlm_message_sv.sql_error('rlm_rd_sv.SynchronizeShipments',x_progress);
4085: --
4086: IF (l_debug <> -1) THEN
4087: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
4088: END IF;

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

4114: RETURN('Y');
4115:
4116: EXCEPTION
4117: WHEN OTHERS THEN
4118: rlm_message_sv.sql_error('rlm_rd_sv.MatchWithin',x_progress);
4119: --
4120: IF (l_debug <> -1) THEN
4121: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
4122: END IF;

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

4147: RETURN('Y');
4148:
4149: EXCEPTION
4150: WHEN OTHERS THEN
4151: rlm_message_sv.sql_error('rlm_rd_sv.MatchAcross',x_progress);
4152: --
4153: IF (l_debug <> -1) THEN
4154: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
4155: END IF;

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

4255: END IF;
4256: --
4257: EXCEPTION
4258: WHEN OTHERS THEN
4259: rlm_message_sv.sql_error('rlm_rd_sv.StoreShipments',x_progress);
4260: --
4261: IF (l_debug <> -1) THEN
4262: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
4263: END IF;

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

4335: END IF;
4336: --
4337: EXCEPTION
4338: WHEN OTHERS THEN
4339: rlm_message_sv.sql_error('rlm_rd_sv.ReconcileShipments',x_progress);
4340: --
4341: IF (l_debug <> -1) THEN
4342: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
4343: END IF;

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

4424: RETURN(b_Match);
4425:
4426: EXCEPTION
4427: WHEN OTHERS THEN
4428: rlm_message_sv.sql_error('rlm_rd_sv.MatchShipments',x_progress);
4429: --
4430: IF (l_debug <> -1) THEN
4431: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
4432: END IF;

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

5506: RETURN(b_Match);
5507: --
5508: EXCEPTION
5509: WHEN OTHERS THEN
5510: rlm_message_sv.sql_error('rlm_rd_sv.MatchFrozen',x_progress);
5511: --
5512: IF (l_debug <> -1) THEN
5513: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
5514: END IF;

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

6643: RETURN(b_Match);
6644: --
6645: EXCEPTION
6646: WHEN OTHERS THEN
6647: rlm_message_sv.sql_error('rlm_rd_sv.MatchReconcile',x_progress);
6648: --
6649: IF (l_debug <> -1) THEN
6650: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
6651: END IF;

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

6714: END IF;
6715:
6716: EXCEPTION
6717: WHEN OTHERS THEN
6718: rlm_message_sv.sql_error('rlm_rd_sv.StoreReconcile',x_progress);
6719: --
6720: IF (l_debug <> -1) THEN
6721: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
6722: END IF;

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

6802: END IF;
6803: --
6804: EXCEPTION
6805: WHEN OTHERS THEN
6806: rlm_message_sv.sql_error('rlm_rd_sv.Reconcile',x_progress);
6807: --
6808: IF (l_debug <> -1) THEN
6809: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
6810: END IF;

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

7043: RETURN(b_Change);
7044:
7045: EXCEPTION
7046: WHEN OTHERS THEN
7047: rlm_message_sv.sql_error('rlm_rd_sv.AttributeChange',x_progress);
7048: --
7049: IF (l_debug <> -1) THEN
7050: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
7051: END IF;

Line 7133: rlm_message_sv.app_error(

7129: SELECT line_number INTO v_line_num
7130: FROM oe_order_lines_all
7131: WHERE line_id = c_PreHorizonDisp_rec.line_id;
7132: --
7133: rlm_message_sv.app_error(
7134: x_ExceptionLevel => rlm_message_sv.k_warn_level,
7135: x_MessageName => 'RLM_WRONG_SCHEDTYPE',
7136: x_InterfaceHeaderId => x_sched_rec.header_id,
7137: x_InterfaceLineId => NULL,

Line 7134: x_ExceptionLevel => rlm_message_sv.k_warn_level,

7130: FROM oe_order_lines_all
7131: WHERE line_id = c_PreHorizonDisp_rec.line_id;
7132: --
7133: rlm_message_sv.app_error(
7134: x_ExceptionLevel => rlm_message_sv.k_warn_level,
7135: x_MessageName => 'RLM_WRONG_SCHEDTYPE',
7136: x_InterfaceHeaderId => x_sched_rec.header_id,
7137: x_InterfaceLineId => NULL,
7138: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

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

7175: --
7176: raise e_group_error;
7177:
7178: WHEN OTHERS THEN
7179: rlm_message_sv.sql_error('rlm_rd_sv.ProcessPreHorizonATS',x_progress);
7180: --
7181: IF (l_debug <> -1) THEN
7182: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
7183: END IF;

Line 7762: rlm_message_sv.app_error(

7758: GetMatchAttributes(x_sched_rec,x_group_rec, v_Key_rec.dem_rec,v_MatchAttrTxt);
7759: --
7760: IF (c_OldDemand_rec.rla_schedule_type_code = 'SEQUENCED') THEN
7761: --
7762: rlm_message_sv.app_error(
7763: x_ExceptionLevel => rlm_message_sv.k_warn_level,
7764: x_MessageName => 'RLM_FROZEN_DELETE_SEQ',
7765: x_InterfaceHeaderId => x_sched_rec.header_id,
7766: x_InterfaceLineId => NULL,

Line 7763: x_ExceptionLevel => rlm_message_sv.k_warn_level,

7759: --
7760: IF (c_OldDemand_rec.rla_schedule_type_code = 'SEQUENCED') THEN
7761: --
7762: rlm_message_sv.app_error(
7763: x_ExceptionLevel => rlm_message_sv.k_warn_level,
7764: x_MessageName => 'RLM_FROZEN_DELETE_SEQ',
7765: x_InterfaceHeaderId => x_sched_rec.header_id,
7766: x_InterfaceLineId => NULL,
7767: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 7797: rlm_message_sv.app_error(

7793: END IF;
7794: --
7795: ELSE
7796: --
7797: rlm_message_sv.app_error(
7798: x_ExceptionLevel => rlm_message_sv.k_warn_level,
7799: x_MessageName => 'RLM_FROZEN_DELETE',
7800: x_InterfaceHeaderId => x_sched_rec.header_id,
7801: x_InterfaceLineId => NULL,

Line 7798: x_ExceptionLevel => rlm_message_sv.k_warn_level,

7794: --
7795: ELSE
7796: --
7797: rlm_message_sv.app_error(
7798: x_ExceptionLevel => rlm_message_sv.k_warn_level,
7799: x_MessageName => 'RLM_FROZEN_DELETE',
7800: x_InterfaceHeaderId => x_sched_rec.header_id,
7801: x_InterfaceLineId => NULL,
7802: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 8400: rlm_message_sv.app_error(

8396: rlm_core_sv.dlog(k_DEBUG,'line_number', v_line_num);
8397: rlm_core_sv.dlog(k_DEBUG,'RLM_WRONG_SCHEDTYPE');
8398: END IF;
8399: --
8400: rlm_message_sv.app_error(
8401: x_ExceptionLevel => rlm_message_sv.k_warn_level,
8402: x_MessageName => 'RLM_WRONG_SCHEDTYPE',
8403: x_InterfaceHeaderId => x_sched_rec.header_id,
8404: x_InterfaceLineId => NULL,

Line 8401: x_ExceptionLevel => rlm_message_sv.k_warn_level,

8397: rlm_core_sv.dlog(k_DEBUG,'RLM_WRONG_SCHEDTYPE');
8398: END IF;
8399: --
8400: rlm_message_sv.app_error(
8401: x_ExceptionLevel => rlm_message_sv.k_warn_level,
8402: x_MessageName => 'RLM_WRONG_SCHEDTYPE',
8403: x_InterfaceHeaderId => x_sched_rec.header_id,
8404: x_InterfaceLineId => NULL,
8405: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

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

8433: --
8434: raise e_group_error;
8435:
8436: WHEN OTHERS THEN
8437: rlm_message_sv.sql_error('rlm_rd_sv.ProcessOld',x_progress);
8438: --
8439: IF (l_debug <> -1) THEN
8440: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
8441: END IF;

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

8577: END IF;
8578: --
8579: EXCEPTION
8580: WHEN OTHERS THEN
8581: rlm_message_sv.sql_error('rlm_rd_sv.FetchReq',x_progress);
8582: --
8583: IF (l_debug <> -1) THEN
8584: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
8585: END IF;

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

8705: END IF;
8706:
8707: EXCEPTION
8708: WHEN OTHERS THEN
8709: rlm_message_sv.sql_error('rlm_rd_sv.FetchDemand',x_progress);
8710: --
8711: IF (l_debug <> -1) THEN
8712: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
8713: END IF;

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

8775: END IF;
8776:
8777: EXCEPTION
8778: WHEN OTHERS THEN
8779: rlm_message_sv.sql_error('rlm_rd_sv.SchedulePrecedence',x_progress);
8780: --
8781: IF (l_debug <> -1) THEN
8782: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
8783: END IF;

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

8863: --
8864: raise e_group_error;
8865:
8866: WHEN OTHERS THEN
8867: rlm_message_sv.sql_error('rlm_rd_sv.CountMatchedDemand',x_progress);
8868: --
8869: IF (l_debug <> -1) THEN
8870: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
8871: END IF;

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

8961: --
8962: raise e_group_error;
8963:
8964: WHEN OTHERS THEN
8965: rlm_message_sv.sql_error('rlm_rd_sv.ReconcileAction',x_progress);
8966: --
8967: IF (l_debug <> -1) THEN
8968: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
8969: END IF;

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

10003:
10004: EXCEPTION
10005:
10006: WHEN OTHERS THEN
10007: rlm_message_sv.sql_error('rlm_rd_sv.BuildMatchQuery',x_progress);
10008: IF (l_debug <> -1) THEN
10009: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
10010: END IF;
10011: RAISE;

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

10475: --
10476: raise e_group_error;
10477:
10478: WHEN OTHERS THEN
10479: rlm_message_sv.sql_error('rlm_rd_sv.ProcessATS',x_progress);
10480: --
10481: IF (l_debug <> -1) THEN
10482: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
10483: END IF;

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

10781: --
10782: raise e_group_error;
10783:
10784: WHEN OTHERS THEN
10785: rlm_message_sv.sql_error('rlm_rd_sv.ProcessNATS',x_progress);
10786: --
10787: IF (l_debug <> -1) THEN
10788: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
10789: END IF;

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

10883: END IF;
10884: --
10885: EXCEPTION
10886: WHEN OTHERS THEN
10887: rlm_message_sv.sql_error('rlm_rd_sv.UpdateDemand',x_progress);
10888: --
10889: IF (l_debug <> -1) THEN
10890: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
10891: END IF;

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

10944: --
10945: raise e_group_error;
10946:
10947: WHEN OTHERS THEN
10948: rlm_message_sv.sql_error('rlm_rd_sv.DeleteDemand',x_progress);
10949: --
10950: IF (l_debug <> -1) THEN
10951: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
10952: END IF;

Line 11025: rlm_message_sv.app_error(

11021: GetMatchAttributes(x_sched_rec, x_group_rec, x_Key_rec.dem_rec,v_MatchAttrTxt);
11022: --
11023: IF (x_key_rec.dem_rec.schedule_type = 'SEQUENCED') THEN
11024: --
11025: rlm_message_sv.app_error(
11026: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11027: x_MessageName => 'RLM_FROZEN_UPDATE_SEQ',
11028: x_InterfaceHeaderId => x_sched_rec.header_id,
11029: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 11026: x_ExceptionLevel => rlm_message_sv.k_warn_level,

11022: --
11023: IF (x_key_rec.dem_rec.schedule_type = 'SEQUENCED') THEN
11024: --
11025: rlm_message_sv.app_error(
11026: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11027: x_MessageName => 'RLM_FROZEN_UPDATE_SEQ',
11028: x_InterfaceHeaderId => x_sched_rec.header_id,
11029: x_InterfaceLineId => x_key_rec.req_rec.line_id,
11030: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 11062: rlm_message_sv.app_error(

11058: END IF;
11059: --
11060: ELSE
11061: --
11062: rlm_message_sv.app_error(
11063: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11064: x_MessageName => 'RLM_FROZEN_UPDATE',
11065: x_InterfaceHeaderId => x_sched_rec.header_id,
11066: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 11063: x_ExceptionLevel => rlm_message_sv.k_warn_level,

11059: --
11060: ELSE
11061: --
11062: rlm_message_sv.app_error(
11063: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11064: x_MessageName => 'RLM_FROZEN_UPDATE',
11065: x_InterfaceHeaderId => x_sched_rec.header_id,
11066: x_InterfaceLineId => x_key_rec.req_rec.line_id,
11067: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

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

11132: END IF;
11133: --
11134: EXCEPTION
11135: WHEN OTHERS THEN
11136: rlm_message_sv.sql_error('rlm_rd_sv.IncreaseDemand',x_progress);
11137: --
11138: IF (l_debug <> -1) THEN
11139: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
11140: END IF;

Line 11226: rlm_message_sv.app_error(

11222: GetMatchAttributes(x_sched_rec, x_group_rec, x_Key_rec.dem_rec,v_MatchAttrTxt);
11223: --
11224: IF (x_key_rec.dem_rec.schedule_type = 'SEQUENCED') THEN
11225: --
11226: rlm_message_sv.app_error(
11227: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11228: x_MessageName => 'RLM_FROZEN_UPDATE_SEQ',
11229: x_InterfaceHeaderId => x_sched_rec.header_id,
11230: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 11227: x_ExceptionLevel => rlm_message_sv.k_warn_level,

11223: --
11224: IF (x_key_rec.dem_rec.schedule_type = 'SEQUENCED') THEN
11225: --
11226: rlm_message_sv.app_error(
11227: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11228: x_MessageName => 'RLM_FROZEN_UPDATE_SEQ',
11229: x_InterfaceHeaderId => x_sched_rec.header_id,
11230: x_InterfaceLineId => x_key_rec.req_rec.line_id,
11231: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 11263: rlm_message_sv.app_error(

11259: END IF;
11260: --
11261: ELSE
11262: --
11263: rlm_message_sv.app_error(
11264: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11265: x_MessageName => 'RLM_FROZEN_UPDATE',
11266: x_InterfaceHeaderId => x_sched_rec.header_id,
11267: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 11264: x_ExceptionLevel => rlm_message_sv.k_warn_level,

11260: --
11261: ELSE
11262: --
11263: rlm_message_sv.app_error(
11264: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11265: x_MessageName => 'RLM_FROZEN_UPDATE',
11266: x_InterfaceHeaderId => x_sched_rec.header_id,
11267: x_InterfaceLineId => x_key_rec.req_rec.line_id,
11268: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

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

11334: --
11335: raise e_group_error;
11336:
11337: WHEN OTHERS THEN
11338: rlm_message_sv.sql_error('rlm_rd_sv.DecreaseDemand',x_progress);
11339: --
11340: IF (l_debug <> -1) THEN
11341: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
11342: END IF;

Line 11419: rlm_message_sv.app_error(

11415: GetMatchAttributes(x_sched_rec, x_group_rec, x_Key_rec.dem_rec,v_MatchAttrTxt);
11416: --
11417: IF (x_Key_rec.dem_rec.schedule_type = 'SEQUENCED') THEN
11418: --
11419: rlm_message_sv.app_error(
11420: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11421: x_MessageName => 'RLM_UNABLE_ATTR_UPDATE_SEQ',
11422: x_InterfaceHeaderId => x_sched_rec.header_id,
11423: x_InterfaceLineId => x_Key_rec.req_rec.line_id,

Line 11420: x_ExceptionLevel => rlm_message_sv.k_warn_level,

11416: --
11417: IF (x_Key_rec.dem_rec.schedule_type = 'SEQUENCED') THEN
11418: --
11419: rlm_message_sv.app_error(
11420: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11421: x_MessageName => 'RLM_UNABLE_ATTR_UPDATE_SEQ',
11422: x_InterfaceHeaderId => x_sched_rec.header_id,
11423: x_InterfaceLineId => x_Key_rec.req_rec.line_id,
11424: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 11454: rlm_message_sv.app_error(

11450: END IF;
11451: --
11452: ELSE
11453: --
11454: rlm_message_sv.app_error(
11455: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11456: x_MessageName => 'RLM_UNABLE_ATTR_UPDATE',
11457: x_InterfaceHeaderId => x_sched_rec.header_id,
11458: x_InterfaceLineId => x_Key_rec.req_rec.line_id,

Line 11455: x_ExceptionLevel => rlm_message_sv.k_warn_level,

11451: --
11452: ELSE
11453: --
11454: rlm_message_sv.app_error(
11455: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11456: x_MessageName => 'RLM_UNABLE_ATTR_UPDATE',
11457: x_InterfaceHeaderId => x_sched_rec.header_id,
11458: x_InterfaceLineId => x_Key_rec.req_rec.line_id,
11459: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 11493: rlm_message_sv.app_error(

11489: GetMatchAttributes(x_sched_rec, x_group_rec, x_Key_rec.dem_rec,v_MatchAttrTxt);
11490: --
11491: IF (x_key_rec.dem_rec.schedule_type = 'SEQUENCED') THEN
11492: --
11493: rlm_message_sv.app_error(
11494: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11495: x_MessageName => 'RLM_FROZEN_UPDATE_SEQ',
11496: x_InterfaceHeaderId => x_sched_rec.header_id,
11497: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 11494: x_ExceptionLevel => rlm_message_sv.k_warn_level,

11490: --
11491: IF (x_key_rec.dem_rec.schedule_type = 'SEQUENCED') THEN
11492: --
11493: rlm_message_sv.app_error(
11494: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11495: x_MessageName => 'RLM_FROZEN_UPDATE_SEQ',
11496: x_InterfaceHeaderId => x_sched_rec.header_id,
11497: x_InterfaceLineId => x_key_rec.req_rec.line_id,
11498: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 11530: rlm_message_sv.app_error(

11526: END IF;
11527: --
11528: ELSE
11529: --
11530: rlm_message_sv.app_error(
11531: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11532: x_MessageName => 'RLM_FROZEN_UPDATE',
11533: x_InterfaceHeaderId => x_sched_rec.header_id,
11534: x_InterfaceLineId => x_key_rec.req_rec.line_id,

Line 11531: x_ExceptionLevel => rlm_message_sv.k_warn_level,

11527: --
11528: ELSE
11529: --
11530: rlm_message_sv.app_error(
11531: x_ExceptionLevel => rlm_message_sv.k_warn_level,
11532: x_MessageName => 'RLM_FROZEN_UPDATE',
11533: x_InterfaceHeaderId => x_sched_rec.header_id,
11534: x_InterfaceLineId => x_key_rec.req_rec.line_id,
11535: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

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

11572: END IF;
11573: --
11574: EXCEPTION
11575: WHEN OTHERS THEN
11576: rlm_message_sv.sql_error('rlm_rd_sv.OtherDemand',x_progress);
11577: --
11578: IF (l_debug <> -1) THEN
11579: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
11580: END IF;

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

11721: END IF;
11722: --
11723: EXCEPTION
11724: WHEN OTHERS THEN
11725: rlm_message_sv.sql_error('rlm_rd_sv.SetOperation',x_progress);
11726: --
11727: IF (l_debug <> -1) THEN
11728: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
11729: END IF;

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

11776: RETURN TRUE;
11777: --
11778: EXCEPTION
11779: WHEN OTHERS THEN
11780: rlm_message_sv.sql_error('rlm_rd_sv.IsLineConsumable',x_progress);
11781: --
11782: IF (l_debug <> -1) THEN
11783: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
11784: END IF;

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

11883: EXCEPTION
11884: --
11885: WHEN OTHERS THEN
11886: --
11887: rlm_message_sv.sql_error('rlm_rd_sv.UpdateGroupStatus',x_progress);
11888: --
11889: IF (l_debug <> -1) THEN
11890: rlm_core_sv.dlog(k_DEBUG,'progress',x_Progress);
11891: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: OTHER - sql error');

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

11957: EXCEPTION
11958: --
11959: WHEN OTHERS THEN
11960: --
11961: rlm_message_sv.sql_error('rlm_rd_sv.IsFrozen', x_progress);
11962: --
11963: IF (l_debug <> -1) THEN
11964: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
11965: END IF;

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

12014: --
12015: RETURN FALSE;
12016: --
12017: WHEN OTHERS THEN
12018: rlm_message_sv.sql_error('rlm_rd_sv.LockHeaders',x_progress);
12019: --
12020: IF (l_debug <> -1) THEN
12021: rlm_core_sv.dlog(k_DEBUG,'REturning FALSE OTHERS ');
12022: rlm_core_sv.dlog(k_DEBUG,'progress',x_Progress);

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

12061: EXCEPTION
12062: --
12063: WHEN OTHERS THEN
12064: --
12065: rlm_message_sv.sql_error('rlm_rd_sv.UpdateHeaderStatus',x_progress);
12066: --
12067: IF (l_debug <> -1) THEN
12068: rlm_core_sv.dlog(k_DEBUG,'progress',x_Progress);
12069: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: OTHER - sql error');

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

12127: --
12128: RETURN FALSE;
12129: --
12130: WHEN OTHERS THEN
12131: rlm_message_sv.sql_error('rlm_rd_sv.LockLines',x_progress);
12132: --
12133: IF (l_debug <> -1) THEN
12134: rlm_core_sv.dlog(k_DEBUG,'REturning FALSE OTHERS ');
12135: rlm_core_sv.dlog(k_DEBUG,'progress',x_Progress);

Line 12193: rlm_message_sv.app_error(

12189: --
12190: IF (x_DemandTolerancePos < v_PctDelta) OR
12191: (x_DemandToleranceNeg < ABS(v_PctDelta)) THEN
12192: --
12193: rlm_message_sv.app_error(
12194: x_ExceptionLevel => rlm_message_sv.k_warn_level,
12195: x_MessageName => 'RLM_TOLERANCE_CHECK_FAILED',
12196: x_InterfaceHeaderId => x_sched_rec.header_id,
12197: x_InterfaceLineId => x_Key_rec.req_rec.line_id,

Line 12194: x_ExceptionLevel => rlm_message_sv.k_warn_level,

12190: IF (x_DemandTolerancePos < v_PctDelta) OR
12191: (x_DemandToleranceNeg < ABS(v_PctDelta)) THEN
12192: --
12193: rlm_message_sv.app_error(
12194: x_ExceptionLevel => rlm_message_sv.k_warn_level,
12195: x_MessageName => 'RLM_TOLERANCE_CHECK_FAILED',
12196: x_InterfaceHeaderId => x_sched_rec.header_id,
12197: x_InterfaceLineId => x_Key_rec.req_rec.line_id,
12198: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

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

12224: EXCEPTION
12225: --
12226: WHEN OTHERS THEN
12227: --
12228: rlm_message_sv.sql_error('rlm_rd_sv.CheckTolerance', v_Progress);
12229: --
12230: IF (l_debug <> -1) THEN
12231: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: OTHERS - sql error');
12232: END IF;

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

12611: rlm_core_sv.dpop(k_SDEBUG);
12612: END IF;
12613: --
12614: WHEN OTHERS THEN
12615: rlm_message_sv.sql_error('rlm_rd_sv.GetTPContext',v_Progress);
12616: --
12617: IF (l_debug <> -1) THEN
12618: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
12619: END IF;

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

12697: END IF;
12698: --
12699: EXCEPTION
12700: WHEN OTHERS THEN
12701: rlm_message_sv.sql_error('RLM_RD_SV.InitializeMatchRec', x_progress);
12702: --
12703: IF (l_debug <> -1) THEN
12704: rlm_core_sv.dpop(k_SDEBUG, 'EXCEPTION: ' || SUBSTR(SQLERRM,1,200));
12705: END IF;

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

12781: END IF;
12782: --
12783: EXCEPTION
12784: WHEN OTHERS THEN
12785: rlm_message_sv.sql_error('RLM_RD_SV.FetchMatchRec', x_progress);
12786: --
12787: IF (l_debug <> -1) THEN
12788: rlm_core_sv.dpop(k_SDEBUG, 'EXCEPTION: ' || SUBSTR(SQLERRM,1,200));
12789: END IF;

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

13369: EXCEPTION
13370: --
13371: WHEN OTHERS THEN
13372: --
13373: rlm_message_sv.sql_error('RLM_RD_SV.MRPOnly', v_Progress);
13374: --
13375: IF (l_debug <> -1) THEN
13376: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
13377: END IF;

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

13804: --
13805: EXCEPTION
13806: --
13807: WHEN OTHERS THEN
13808: rlm_message_sv.sql_error('rlm_rd_sv.InitializeBlktGrp',x_progress);
13809: --
13810: IF (l_debug <> -1) THEN
13811: rlm_core_sv.dlog(k_DEBUG, 'When others of InitializeBlktGrp');
13812: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

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

13874: --
13875: EXCEPTION
13876: --
13877: WHEN OTHERS THEN
13878: rlm_message_sv.sql_error('rlm_rd_sv.FetchBlktGrp',x_progress);
13879: --
13880: IF (l_debug <> -1) THEN
13881: rlm_core_sv.dlog(k_DEBUG, 'When others of FetchBlktGrp');
13882: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

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

13926: EXCEPTION
13927: --
13928: WHEN OTHERS THEN
13929: --
13930: rlm_message_sv.sql_error('rlm_rd_sv.BuildBindVarTab3',x_progress);
13931: --
13932: IF (l_debug <> -1) THEN
13933: rlm_core_sv.dpop(k_SDEBUG, 'Exception ' || substr(SQLERRM, 1, 200));
13934: END IF;

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

13983: EXCEPTION
13984: --
13985: WHEN OTHERS THEN
13986: --
13987: rlm_message_sv.sql_error('rlm_rd_sv.BuildBindVarTab5',x_progress);
13988: --
13989: IF (l_debug <> -1) THEN
13990: rlm_core_sv.dpop(k_SDEBUG, 'Exception ' || substr(SQLERRM, 1, 200));
13991: END IF;

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

14025: EXCEPTION
14026: --
14027: WHEN OTHERS THEN
14028: --
14029: rlm_message_sv.sql_error('rlm_rd_sv.BuildBindVarTab2',x_progress);
14030: --
14031: IF (l_debug <> -1) THEN
14032: rlm_core_sv.dpop(k_SDEBUG, 'Exception ' || substr(SQLERRM, 1, 200));
14033: END IF;

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

14135: EXCEPTION
14136: --
14137: WHEN OTHERS THEN
14138: --
14139: rlm_message_sv.sql_error('RLM_RD_SV.SourceCUMIntransitQty',v_Progress);
14140: --
14141: IF (l_debug <> -1) THEN
14142: rlm_core_sv.dlog(k_DEBUG,'progress',v_Progress);
14143: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 14227: rlm_message_sv.get_msg_text(

14223: --
14224: IF v_cum_record.cum_key_id IS NULL THEN
14225: --Bugfix 7007638
14226: IF x_Group_rec.setup_terms_rec.cum_control_code IN ('CUM_BY_DATE_PO','CUM_BY_PO_ONLY') THEN
14227: rlm_message_sv.get_msg_text(
14228: x_message_name => 'RLM_CUM_CONTROL_PO',
14229: x_text => v_control_text);
14230: v_control_value := v_cum_key_record.purchase_order_number;
14231: ELSIF x_Group_rec.setup_terms_rec.cum_control_code IN ('CUM_BY_DATE_RECORD_YEAR') THEN

Line 14232: rlm_message_sv.get_msg_text(

14228: x_message_name => 'RLM_CUM_CONTROL_PO',
14229: x_text => v_control_text);
14230: v_control_value := v_cum_key_record.purchase_order_number;
14231: ELSIF x_Group_rec.setup_terms_rec.cum_control_code IN ('CUM_BY_DATE_RECORD_YEAR') THEN
14232: rlm_message_sv.get_msg_text(
14233: x_message_name => 'RLM_CUM_CONTROL_RY',
14234: x_text => v_control_text);
14235: v_control_value := v_cum_key_record.cust_record_year;
14236: ELSIF x_Group_rec.setup_terms_rec.cum_control_code IN ('CUM_BY_DATE_ONLY') THEN

Line 14237: rlm_message_sv.get_msg_text(

14233: x_message_name => 'RLM_CUM_CONTROL_RY',
14234: x_text => v_control_text);
14235: v_control_value := v_cum_key_record.cust_record_year;
14236: ELSIF x_Group_rec.setup_terms_rec.cum_control_code IN ('CUM_BY_DATE_ONLY') THEN
14237: rlm_message_sv.get_msg_text(
14238: x_message_name => 'RLM_CUM_CONTROL_DATE',
14239: x_text => v_control_text);
14240: v_control_value := v_cum_key_record.cum_start_date;
14241: END IF;

Line 14275: rlm_message_sv.app_error(

14271: -- 4307505 [
14272: WHEN NO_DATA_FOUND THEN
14273: v_Intransit := 0;
14274: x_Intransit := 0;
14275: rlm_message_sv.app_error(
14276: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14277: x_MessageName => 'RLM_NO_CUM_INTRST_CUST_CUM',
14278: x_InterfaceHeaderId => x_sched_rec.header_id,
14279: x_InterfaceLineId => NULL,

Line 14276: x_ExceptionLevel => rlm_message_sv.k_warn_level,

14272: WHEN NO_DATA_FOUND THEN
14273: v_Intransit := 0;
14274: x_Intransit := 0;
14275: rlm_message_sv.app_error(
14276: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14277: x_MessageName => 'RLM_NO_CUM_INTRST_CUST_CUM',
14278: x_InterfaceHeaderId => x_sched_rec.header_id,
14279: x_InterfaceLineId => NULL,
14280: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 14300: rlm_message_sv.app_error(

14296: END IF;
14297: -- 4307505 ]
14298: WHEN e_no_cum_key THEN
14299: --
14300: rlm_message_sv.app_error(
14301: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14302: x_MessageName => 'RLM_CUM_KEY_MISSING',
14303: x_InterfaceHeaderId => x_sched_rec.header_id,
14304: x_InterfaceLineId => NULL,

Line 14301: x_ExceptionLevel => rlm_message_sv.k_warn_level,

14297: -- 4307505 ]
14298: WHEN e_no_cum_key THEN
14299: --
14300: rlm_message_sv.app_error(
14301: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14302: x_MessageName => 'RLM_CUM_KEY_MISSING',
14303: x_InterfaceHeaderId => x_sched_rec.header_id,
14304: x_InterfaceLineId => NULL,
14305: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

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

14319: rlm_core_sv.dpop(k_SDEBUG);
14320: END IF;
14321: --
14322: WHEN OTHERS THEN
14323: rlm_message_sv.sql_error('rlm_rd_sv.CalculateCUMIntransit',v_progress);
14324: --
14325: IF (l_debug <> -1) THEN
14326: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
14327: END IF;

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

14418: EXCEPTION
14419: --
14420: WHEN OTHERS THEN
14421: --
14422: rlm_message_sv.sql_error('RLM_RD_SV.AssignOEAttribValues', '010');
14423: --
14424: IF (l_debug <> -1) THEN
14425: rlm_core_sv.dlog(k_DEBUG, 'Unexpected error', SUBSTRB(SQLERRM, 1, 200));
14426: rlm_core_sv.dpop(k_SDEBUG);

Line 14556: rlm_message_sv.app_error(

14552: rlm_core_sv.dlog(k_DEBUG,'Customer Item Id', x_group_rec.customer_item_id);
14553: rlm_core_sv.dlog(k_DEBUG,'Matching Attributes', v_MatchAttrTxt);
14554: END IF;
14555: --
14556: rlm_message_sv.app_error(
14557: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14558: x_MessageName => 'RLM_FROZEN_OVERALL_WARN_UNDER',
14559: x_InterfaceHeaderId => x_sched_rec.header_id,
14560: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 14557: x_ExceptionLevel => rlm_message_sv.k_warn_level,

14553: rlm_core_sv.dlog(k_DEBUG,'Matching Attributes', v_MatchAttrTxt);
14554: END IF;
14555: --
14556: rlm_message_sv.app_error(
14557: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14558: x_MessageName => 'RLM_FROZEN_OVERALL_WARN_UNDER',
14559: x_InterfaceHeaderId => x_sched_rec.header_id,
14560: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,
14561: x_OrderHeaderId => x_group_rec.setup_terms_rec.header_id,

Line 14587: rlm_message_sv.app_error(

14583: rlm_core_sv.dlog(k_DEBUG,'Matching Attributes', v_MatchAttrTxt);
14584: --
14585: END IF;
14586: --
14587: rlm_message_sv.app_error(
14588: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14589: x_MessageName => 'RLM_FROZEN_OVERALL_WARN_OVER',
14590: x_InterfaceHeaderId => x_sched_rec.header_id,
14591: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 14588: x_ExceptionLevel => rlm_message_sv.k_warn_level,

14584: --
14585: END IF;
14586: --
14587: rlm_message_sv.app_error(
14588: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14589: x_MessageName => 'RLM_FROZEN_OVERALL_WARN_OVER',
14590: x_InterfaceHeaderId => x_sched_rec.header_id,
14591: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,
14592: x_OrderHeaderId => x_group_rec.setup_terms_rec.header_id,

Line 14620: rlm_message_sv.app_error(

14616: rlm_core_sv.dlog(k_DEBUG,'Customer Item Id', x_group_rec.customer_item_id);
14617: rlm_core_sv.dlog(k_DEBUG,'Matching Attributes', v_MatchAttrTxt);
14618: END IF;
14619: --
14620: rlm_message_sv.app_error(
14621: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14622: x_MessageName => 'RLM_FROZEN_OVERALL_QTY_UNDER',
14623: x_InterfaceHeaderId => x_sched_rec.header_id,
14624: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 14621: x_ExceptionLevel => rlm_message_sv.k_warn_level,

14617: rlm_core_sv.dlog(k_DEBUG,'Matching Attributes', v_MatchAttrTxt);
14618: END IF;
14619: --
14620: rlm_message_sv.app_error(
14621: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14622: x_MessageName => 'RLM_FROZEN_OVERALL_QTY_UNDER',
14623: x_InterfaceHeaderId => x_sched_rec.header_id,
14624: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,
14625: x_OrderHeaderId => x_group_rec.setup_terms_rec.header_id,

Line 14653: rlm_message_sv.app_error(

14649: rlm_core_sv.dlog(k_DEBUG,'Matching Attributes', v_MatchAttrTxt);
14650: --
14651: END IF;
14652: --
14653: rlm_message_sv.app_error(
14654: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14655: x_MessageName => 'RLM_FROZEN_OVERALL_QTY_OVER',
14656: x_InterfaceHeaderId => x_sched_rec.header_id,
14657: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 14654: x_ExceptionLevel => rlm_message_sv.k_warn_level,

14650: --
14651: END IF;
14652: --
14653: rlm_message_sv.app_error(
14654: x_ExceptionLevel => rlm_message_sv.k_warn_level,
14655: x_MessageName => 'RLM_FROZEN_OVERALL_QTY_OVER',
14656: x_InterfaceHeaderId => x_sched_rec.header_id,
14657: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,
14658: x_OrderHeaderId => x_group_rec.setup_terms_rec.header_id,

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

14686: --}
14687: EXCEPTION
14688: WHEN OTHERS THEN
14689: --
14690: rlm_message_sv.sql_error('RLM_RD_SV.FrozenFenceWarning', '010');
14691: --
14692: IF (l_debug <> -1) THEN
14693: rlm_core_sv.dlog(k_DEBUG, 'Unexpected error', SUBSTRB(SQLERRM, 1, 200));
14694: rlm_core_sv.dpop(k_SDEBUG);

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

14963: --
14964: EXCEPTION
14965: WHEN OTHERS THEN
14966: --
14967: rlm_message_sv.sql_error('RLM_RD_SV.GetMatchAttributes', '010');
14968: --
14969: IF (l_debug <> -1) THEN
14970: rlm_core_sv.dlog(k_DEBUG, 'Unexpected error', SUBSTRB(SQLERRM, 1, 200));
14971: rlm_core_sv.dpop(k_SDEBUG);

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

15236: EXCEPTION
15237:
15238: WHEN OTHERS THEN
15239: --
15240: rlm_message_sv.sql_error('rlm_rd_sv.PopulateReconcileCumRec',
15241: v_Progress);
15242: --
15243: IF (l_debug <> -1) THEN
15244: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

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

15346: RETURN(b_Match);
15347: --
15348: EXCEPTION
15349: WHEN OTHERS THEN
15350: rlm_message_sv.sql_error('rlm_rd_sv.Match_PO_RY_Reconcile',x_progress);
15351: --
15352: IF (l_debug <> -1) THEN
15353: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
15354: END IF;