DBA Data[Home] [Help]

APPS.RLM_PS_SV dependencies on RLM_PS_SV

Line 1: PACKAGE BODY RLM_PS_SV as

1: PACKAGE BODY RLM_PS_SV as
2: /*$Header: RLMDPPSB.pls 120.5.12010000.2 2009/09/01 07:46:29 sunilku ship $*/
3: /*========================== rlm_ps_sv========================*/
4: --
5: l_DEBUG NUMBER := NVL(fnd_profile.value('RLM_DEBUG_MODE'),-1);

Line 3: /*========================== rlm_ps_sv========================*/

1: PACKAGE BODY RLM_PS_SV as
2: /*$Header: RLMDPPSB.pls 120.5.12010000.2 2009/09/01 07:46:29 sunilku ship $*/
3: /*========================== rlm_ps_sv========================*/
4: --
5: l_DEBUG NUMBER := NVL(fnd_profile.value('RLM_DEBUG_MODE'),-1);
6: TYPE g_number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
7: g_BindVarTab RLM_CORE_SV.t_dynamic_tab;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1577: END RLM_PS_SV;

1573:
1574: END CheckOpenOrder;
1575:
1576:
1577: END RLM_PS_SV;