DBA Data[Home] [Help]

APPS.RLM_FORECAST_SV dependencies on RLM_FORECAST_SV

Line 1: PACKAGE BODY RLM_FORECAST_SV as

1: PACKAGE BODY RLM_FORECAST_SV as
2: /* $Header: RLMDPFPB.pls 120.7 2011/12/20 07:25:14 sunilku ship $ */
3: /*======================= RLM_FORECAST_SV ============================*/
4:
5: --

Line 3: /*======================= RLM_FORECAST_SV ============================*/

1: PACKAGE BODY RLM_FORECAST_SV as
2: /* $Header: RLMDPFPB.pls 120.7 2011/12/20 07:25:14 sunilku ship $ */
3: /*======================= RLM_FORECAST_SV ============================*/
4:
5: --
6: l_DEBUG NUMBER := NVL(fnd_profile.value('RLM_DEBUG_MODE'),-1);
7: --

Line 275: rlm_message_sv.sql_error('rlm_forecast_sv.ManageForecast',x_progress);

271: t_forecast.DELETE;
272: t_designator.DELETE;
273: x_ReturnStatus := rlm_core_sv.k_PROC_ERROR;
274: --
275: rlm_message_sv.sql_error('rlm_forecast_sv.ManageForecast',x_progress);
276: --
277: IF (l_debug <> -1) THEN
278: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
279: END IF;

Line 428: rlm_message_sv.sql_error('rlm_forecast_sv.ManageForecast',x_progress);

424: --
425: WHEN OTHERS THEN
426: --
427: x_ReturnStatus := rlm_core_sv.k_PROC_ERROR;
428: rlm_message_sv.sql_error('rlm_forecast_sv.ManageForecast',x_progress);
429: --
430: IF (l_debug <> -1) THEN
431: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
432: END IF;

Line 444: x_Group_ref IN OUT NOCOPY rlm_forecast_sv.t_Cursor_ref,

440: PROCEDURE InitializeGroup
441:
442: ===========================================================================*/
443: PROCEDURE InitializeGroup(x_Sched_rec IN rlm_interface_headers%ROWTYPE,
444: x_Group_ref IN OUT NOCOPY rlm_forecast_sv.t_Cursor_ref,
445: x_Group_rec IN rlm_dp_sv.t_Group_rec)
446: IS
447: x_progress VARCHAR2(3) := '010';
448:

Line 497: rlm_message_sv.sql_error('RLM_FORECAST_SV.InitializeGroup',x_progress);

493: END IF;
494: --
495: EXCEPTION
496: WHEN OTHERS THEN
497: rlm_message_sv.sql_error('RLM_FORECAST_SV.InitializeGroup',x_progress);
498: --
499: IF (l_debug <> -1) THEN
500: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
501: END IF;

Line 556: rlm_message_sv.sql_error('rlm_forecast_sv.FetchGroup',x_progress);

552: END IF;
553:
554: EXCEPTION
555: WHEN OTHERS THEN
556: rlm_message_sv.sql_error('rlm_forecast_sv.FetchGroup',x_progress);
557: --
558: IF (l_debug <> -1) THEN
559: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
560: END IF;

Line 613: rlm_message_sv.sql_error('rlm_forecast_sv.LockHeaders',x_progress);

609: --
610: RETURN FALSE;
611:
612: WHEN OTHERS THEN
613: rlm_message_sv.sql_error('rlm_forecast_sv.LockHeaders',x_progress);
614: --
615: IF (l_debug <> -1) THEN
616: rlm_core_sv.dlog(k_DEBUG,'Returning FALSE from WHEN OTHERS ');
617: rlm_core_sv.dlog(k_DEBUG,'progress',x_Progress);

Line 659: rlm_message_sv.sql_error('rlm_forecast_sv.UpdateHeaderStatus',x_progress);

655: EXCEPTION
656: --
657: WHEN OTHERS THEN
658: --
659: rlm_message_sv.sql_error('rlm_forecast_sv.UpdateHeaderStatus',x_progress);
660: --
661: IF (l_debug <> -1) THEN
662: rlm_core_sv.dlog(k_DEBUG,'progress',x_Progress);
663: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: OTHER - sql error');

Line 723: rlm_message_sv.sql_error('rlm_forecast_sv.LockLines',x_progress);

719: --
720: RETURN FALSE;
721:
722: WHEN OTHERS THEN
723: rlm_message_sv.sql_error('rlm_forecast_sv.LockLines',x_progress);
724: --
725: IF (l_debug <> -1) THEN
726: rlm_core_sv.dlog(k_DEBUG,'Returning FALSE OTHERS ');
727: rlm_core_sv.dlog(k_DEBUG,'progress',x_Progress);

Line 837: rlm_message_sv.sql_error('rlm_forecast_sv.UpdateGroupStatus',x_progress);

833: EXCEPTION
834: --
835: WHEN OTHERS THEN
836: --
837: rlm_message_sv.sql_error('rlm_forecast_sv.UpdateGroupStatus',x_progress);
838: --
839: IF (l_debug <> -1) THEN
840: rlm_core_sv.dlog(k_DEBUG,'progress',x_Progress);
841: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: OTHER - sql error');

Line 874: rlm_message_sv.sql_error ('RLM_forecast_sv.initialize_table', x_progress);

870: END IF;
871: --
872: EXCEPTION
873: WHEN OTHERS THEN
874: rlm_message_sv.sql_error ('RLM_forecast_sv.initialize_table', x_progress);
875: --
876: IF (l_debug <> -1) THEN
877: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: OTHERS - sql error');
878: END IF;

Line 1285: rlm_message_sv.sql_error ('RLM_forecast_sv.LoadForecast', x_progress);

1281: --
1282: raise;
1283:
1284: WHEN OTHERS THEN
1285: rlm_message_sv.sql_error ('RLM_forecast_sv.LoadForecast', x_progress);
1286: --
1287: IF (l_debug <> -1) THEN
1288: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: OTHERS - sql error');
1289: END IF;

Line 1399: rlm_message_sv.sql_error ('RLM_forecast_sv.process_table', x_progress);

1395: --
1396: RAISE;
1397: --
1398: WHEN OTHERS THEN
1399: rlm_message_sv.sql_error ('RLM_forecast_sv.process_table', x_progress);
1400: --
1401: IF (l_debug <> -1) THEN
1402: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: OTHERS - sql error');
1403: END IF;

Line 2201: END RLM_FORECAST_SV;

2197: raise;
2198: --
2199: END Convert_UOM;
2200:
2201: END RLM_FORECAST_SV;