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.

[Home] [Help]

APPS.RLM_FORECAST_SV dependencies on RLM_MESSAGE_SV

Line 182: rlm_message_sv.app_error(

178: AND ship_to_address_id = x_Group_rec.ship_to_address_id
179: AND customer_item_id = x_Group_rec.customer_item_id
180: AND rownum = 1;
181: --
182: rlm_message_sv.app_error(
183: x_ExceptionLevel => rlm_message_sv.k_error_level,
184: x_MessageName => 'RLM_FORECAST_API_FAILED',
185: x_InterfaceHeaderId => x_sched_rec.header_id,
186: x_InterfaceLineId => v_InterfaceLineId,

Line 183: x_ExceptionLevel => rlm_message_sv.k_error_level,

179: AND customer_item_id = x_Group_rec.customer_item_id
180: AND rownum = 1;
181: --
182: rlm_message_sv.app_error(
183: x_ExceptionLevel => rlm_message_sv.k_error_level,
184: x_MessageName => 'RLM_FORECAST_API_FAILED',
185: x_InterfaceHeaderId => x_sched_rec.header_id,
186: x_InterfaceLineId => v_InterfaceLineId,
187: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 237: rlm_message_sv.app_error(

233: AND ship_to_address_id = x_Group_rec.ship_to_address_id
234: AND customer_item_id = x_Group_rec.customer_item_id
235: AND rownum = 1;
236: --
237: rlm_message_sv.app_error(
238: x_ExceptionLevel => rlm_message_sv.k_error_level,
239: x_MessageName => 'RLM_LOCK_NOT_OBTAINED',
240: x_InterfaceHeaderId => x_sched_rec.header_id,
241: x_InterfaceLineId => v_InterfaceLineId,

Line 238: x_ExceptionLevel => rlm_message_sv.k_error_level,

234: AND customer_item_id = x_Group_rec.customer_item_id
235: AND rownum = 1;
236: --
237: rlm_message_sv.app_error(
238: x_ExceptionLevel => rlm_message_sv.k_error_level,
239: x_MessageName => 'RLM_LOCK_NOT_OBTAINED',
240: x_InterfaceHeaderId => x_sched_rec.header_id,
241: x_InterfaceLineId => v_InterfaceLineId,
242: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

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

349: AND ship_to_address_id = x_Group_rec.ship_to_address_id
350: AND customer_item_id = x_Group_rec.customer_item_id
351: AND rownum = 1;
352: --
353: rlm_message_sv.app_error(
354: x_ExceptionLevel => rlm_message_sv.k_error_level,
355: x_MessageName => 'RLM_NO_FORECAST_DESIG',
356: x_InterfaceHeaderId => x_Sched_rec.header_id,
357: x_InterfaceLineId => v_InterfaceLineId,

Line 354: x_ExceptionLevel => rlm_message_sv.k_error_level,

350: AND customer_item_id = x_Group_rec.customer_item_id
351: AND rownum = 1;
352: --
353: rlm_message_sv.app_error(
354: x_ExceptionLevel => rlm_message_sv.k_error_level,
355: x_MessageName => 'RLM_NO_FORECAST_DESIG',
356: x_InterfaceHeaderId => x_Sched_rec.header_id,
357: x_InterfaceLineId => v_InterfaceLineId,
358: x_ScheduleHeaderId => x_Sched_rec.schedule_header_id,

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

1336: rlm_core_sv.dlog(k_DEBUG,'RLM_FORECAST_FAILED',
1337: t_Forecast(v_Count).error_message);
1338: END IF;
1339: --
1340: rlm_message_sv.app_error(
1341: x_ExceptionLevel => rlm_message_sv.k_error_level,
1342: x_MessageName => 'RLM_FORECAST_FAILED',
1343: x_InterfaceHeaderId => x_sched_rec.header_id,
1344: x_InterfaceLineId => t_forecast(v_Count).source_line_id,

Line 1341: x_ExceptionLevel => rlm_message_sv.k_error_level,

1337: t_Forecast(v_Count).error_message);
1338: END IF;
1339: --
1340: rlm_message_sv.app_error(
1341: x_ExceptionLevel => rlm_message_sv.k_error_level,
1342: x_MessageName => 'RLM_FORECAST_FAILED',
1343: x_InterfaceHeaderId => x_sched_rec.header_id,
1344: x_InterfaceLineId => t_forecast(v_Count).source_line_id,
1345: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

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

1787: AND ship_to_address_id = x_Group_rec.ship_to_address_id
1788: AND customer_item_id = x_Group_rec.customer_item_id
1789: AND rownum = 1;
1790: --
1791: rlm_message_sv.app_error(
1792: x_ExceptionLevel => rlm_message_sv.k_error_level,
1793: x_MessageName => 'RLM_FORECAST_API_FAILED',
1794: x_InterfaceHeaderId => x_sched_rec.header_id,
1795: x_InterfaceLineId => v_InterfaceLineId,

Line 1792: x_ExceptionLevel => rlm_message_sv.k_error_level,

1788: AND customer_item_id = x_Group_rec.customer_item_id
1789: AND rownum = 1;
1790: --
1791: rlm_message_sv.app_error(
1792: x_ExceptionLevel => rlm_message_sv.k_error_level,
1793: x_MessageName => 'RLM_FORECAST_API_FAILED',
1794: x_InterfaceHeaderId => x_sched_rec.header_id,
1795: x_InterfaceLineId => v_InterfaceLineId,
1796: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 2045: rlm_message_sv.sql_error('rlm_validatedemand_sv.GetTPContext',v_Progress);

2041: END IF;
2042: --
2043: WHEN OTHERS THEN
2044: --
2045: rlm_message_sv.sql_error('rlm_validatedemand_sv.GetTPContext',v_Progress);
2046: IF (l_debug <> -1) THEN
2047: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
2048: END IF;
2049: raise;

Line 2132: rlm_message_sv.app_error(

2128: FETCH c into v_item_number;
2129: --
2130: v_ShipFromOrgName := RLM_CORE_SV.get_ship_from(p_org_id);
2131: --
2132: rlm_message_sv.app_error(
2133: x_ExceptionLevel => rlm_message_sv.k_error_level,
2134: x_MessageName => 'RLM_ERROR_NO_PRIMARY_UOM',
2135: x_token1=> 'INVITM',
2136: x_value1=> v_item_number,

Line 2133: x_ExceptionLevel => rlm_message_sv.k_error_level,

2129: --
2130: v_ShipFromOrgName := RLM_CORE_SV.get_ship_from(p_org_id);
2131: --
2132: rlm_message_sv.app_error(
2133: x_ExceptionLevel => rlm_message_sv.k_error_level,
2134: x_MessageName => 'RLM_ERROR_NO_PRIMARY_UOM',
2135: x_token1=> 'INVITM',
2136: x_value1=> v_item_number,
2137: x_token2=> 'SHP_FRM_ORG',

Line 2164: rlm_message_sv.app_error(

2160: --
2161: OPEN c;
2162: FETCH c into v_item_number;
2163: --
2164: rlm_message_sv.app_error(
2165: x_ExceptionLevel => rlm_message_sv.k_error_level,
2166: x_MessageName => 'RLM_UNDEF_UOM_CONVERSION',
2167: x_token1=> 'FROM_UOM',
2168: x_value1=> from_uom,

Line 2165: x_ExceptionLevel => rlm_message_sv.k_error_level,

2161: OPEN c;
2162: FETCH c into v_item_number;
2163: --
2164: rlm_message_sv.app_error(
2165: x_ExceptionLevel => rlm_message_sv.k_error_level,
2166: x_MessageName => 'RLM_UNDEF_UOM_CONVERSION',
2167: x_token1=> 'FROM_UOM',
2168: x_value1=> from_uom,
2169: x_token2=> 'TO_UOM',