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.5.12000000.3 2007/10/17 06:22:21 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.5.12000000.3 2007/10/17 06:22:21 sunilku ship $*/
3: /*========================== rlm_dp_sv =============================*/
4:
5: --
6: l_DEBUG NUMBER := NVL(fnd_profile.value('RLM_DEBUG_MODE'),-1);
7: --

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

661: --
662: UpdateHeaderPS(v_header_id,
663: v_schedule_header_id);
664: --
665: rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);
666: --
667: rlm_message_sv.dump_messages(v_header_id);
668: --
669: COMMIT;

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

757: --
758: WHEN OTHERS THEN
759: --
760: retcode := 2;
761: rlm_message_sv.sql_error('rlm_dp_sv.DemandProcessor', v_Progress);
762: rlm_message_sv.dump_messages(v_header_id);
763: --
764: IF (l_debug <> -1) THEN
765: rlm_core_sv.dlog(C_DEBUG, 'Return Code', retcode);

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

820: EXCEPTION
821: --
822: WHEN NO_DATA_FOUND THEN
823: --
824: rlm_message_sv.sql_error('rlm_dp_sv.PurgeInterfaceLines', v_Progress);
825: --
826: IF (l_debug <> -1) THEN
827: rlm_core_sv.dlog(C_DEBUG, 'No records to delete' );
828: rlm_core_sv.dpop(C_SDEBUG);

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

829: END IF;
830: --
831: WHEN OTHERS THEN
832: --
833: rlm_message_sv.sql_error('rlm_dp_sv.PurgeInterfaceLines', v_Progress);
834: --
835: IF (l_debug <> -1) THEN
836: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
837: END IF;

Line 925: x_Group_rec IN rlm_dp_sv.t_Group_rec,

921: ===========================================================================*/
922:
923: PROCEDURE UpdateGroupPS(x_header_id IN NUMBER,
924: x_ScheduleHeaderId IN NUMBER,
925: x_Group_rec IN rlm_dp_sv.t_Group_rec,
926: x_status IN NUMBER,
927: x_UpdateLevel IN VARCHAR2)
928: IS
929: --

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

1063: EXCEPTION
1064: --
1065: WHEN OTHERS THEN
1066: --
1067: rlm_message_sv.sql_error('rlm_dp_sv.UpdateGroupPS', v_Progress);
1068: --
1069: IF (l_debug <> -1) THEN
1070: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
1071: END IF;

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

1219: END IF;
1220: --
1221: WHEN OTHERS THEN
1222: --
1223: rlm_message_sv.sql_error('rlm_dp_sv.UpdateHeaderStatus', x_progress);
1224: --
1225: IF (l_debug <> -1) THEN
1226: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: OTHER - sql error');
1227: END IF;

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

1339: END IF;
1340: --
1341: WHEN OTHERS THEN
1342: --
1343: rlm_message_sv.sql_error('rlm_dp_sv.RunExceptionReport', x_progress);
1344: --
1345: IF (l_debug <> -1) THEN
1346: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: OTHER - sql error');
1347: END IF;

Line 1358: x_Group_rec IN rlm_dp_sv.t_Group_rec)

1354:
1355: ===========================================================================*/
1356:
1357: FUNCTION CheckForecast(x_header_id IN NUMBER,
1358: x_Group_rec IN rlm_dp_sv.t_Group_rec)
1359: RETURN BOOLEAN
1360:
1361: IS
1362: --

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

1394: EXCEPTION
1395: --
1396: WHEN OTHERS THEN
1397: --
1398: rlm_message_sv.sql_error('rlm_dp_sv.CheckForecast', v_Progress);
1399: --
1400: IF (l_debug <> -1) THEN
1401: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
1402: END IF;

Line 2236: END RLM_DP_SV;

2232: raise;
2233: --
2234: END ProcessGroups;
2235:
2236: END RLM_DP_SV;