APPS.RLM_DP_SV dependencies on RLM_DP_SV

Line 1: PACKAGE BODY RLM_DP_SV as

1: PACKAGE BODY RLM_DP_SV as
2: /*$Header: RLMDPWPB.pls 120.10 2011/12/20 07:37:43 sunilku ship $*/
3: /*========================== rlm_dp_sv =============================*/
4:
5: --

Line 3: /*========================== rlm_dp_sv =============================*/

1: PACKAGE BODY RLM_DP_SV as
2: /*$Header: RLMDPWPB.pls 120.10 2011/12/20 07:37:43 sunilku ship $*/
3: /*========================== rlm_dp_sv =============================*/
4:
5: --
6: l_DEBUG NUMBER := NVL(fnd_profile.value('RLM_DEBUG_MODE'),-1);
7: --

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

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

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

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

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

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

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

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

Line 932: x_Group_rec IN rlm_dp_sv.t_Group_rec,

928: ===========================================================================*/
929:
930: PROCEDURE UpdateGroupPS(x_header_id IN NUMBER,
931: x_ScheduleHeaderId IN NUMBER,
932: x_Group_rec IN rlm_dp_sv.t_Group_rec,
933: x_status IN NUMBER,
934: x_UpdateLevel IN VARCHAR2)
935: IS
936: --

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

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

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

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

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

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

Line 1365: x_Group_rec IN rlm_dp_sv.t_Group_rec)

1361:
1362: ===========================================================================*/
1363:
1364: FUNCTION CheckForecast(x_header_id IN NUMBER,
1365: x_Group_rec IN rlm_dp_sv.t_Group_rec)
1366: RETURN BOOLEAN
1367:
1368: IS
1369: --

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

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

Line 2243: END RLM_DP_SV;

2239: raise;
2240: --
2241: END ProcessGroups;
2242:
2243: END RLM_DP_SV;