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.

APPS.RLM_FORECAST_SV dependencies on RLM_MESSAGE_SV

Line 165: rlm_message_sv.app_error(

161: AND ship_to_address_id = x_Group_rec.ship_to_address_id
162: AND customer_item_id = x_Group_rec.customer_item_id
163: AND rownum = 1;
164: --
165: rlm_message_sv.app_error(
166: x_ExceptionLevel => rlm_message_sv.k_error_level,
167: x_MessageName => 'RLM_FORECAST_API_FAILED',
168: x_InterfaceHeaderId => x_sched_rec.header_id,
169: x_InterfaceLineId => v_InterfaceLineId,

Line 166: x_ExceptionLevel => rlm_message_sv.k_error_level,

162: AND customer_item_id = x_Group_rec.customer_item_id
163: AND rownum = 1;
164: --
165: rlm_message_sv.app_error(
166: x_ExceptionLevel => rlm_message_sv.k_error_level,
167: x_MessageName => 'RLM_FORECAST_API_FAILED',
168: x_InterfaceHeaderId => x_sched_rec.header_id,
169: x_InterfaceLineId => v_InterfaceLineId,
170: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

Line 220: rlm_message_sv.app_error(

216: AND ship_to_address_id = x_Group_rec.ship_to_address_id
217: AND customer_item_id = x_Group_rec.customer_item_id
218: AND rownum = 1;
219: --
220: rlm_message_sv.app_error(
221: x_ExceptionLevel => rlm_message_sv.k_error_level,
222: x_MessageName => 'RLM_LOCK_NOT_OBTAINED',
223: x_InterfaceHeaderId => x_sched_rec.header_id,
224: x_InterfaceLineId => v_InterfaceLineId,

Line 221: x_ExceptionLevel => rlm_message_sv.k_error_level,

217: AND customer_item_id = x_Group_rec.customer_item_id
218: AND rownum = 1;
219: --
220: rlm_message_sv.app_error(
221: x_ExceptionLevel => rlm_message_sv.k_error_level,
222: x_MessageName => 'RLM_LOCK_NOT_OBTAINED',
223: x_InterfaceHeaderId => x_sched_rec.header_id,
224: x_InterfaceLineId => v_InterfaceLineId,
225: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

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

254: t_forecast.DELETE;
255: t_designator.DELETE;
256: x_ReturnStatus := rlm_core_sv.k_PROC_ERROR;
257: --
258: rlm_message_sv.sql_error('rlm_forecast_sv.ManageForecast',x_progress);
259: --
260: IF (l_debug <> -1) THEN
261: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
262: END IF;

Line 336: rlm_message_sv.app_error(

332: AND ship_to_address_id = x_Group_rec.ship_to_address_id
333: AND customer_item_id = x_Group_rec.customer_item_id
334: AND rownum = 1;
335: --
336: rlm_message_sv.app_error(
337: x_ExceptionLevel => rlm_message_sv.k_error_level,
338: x_MessageName => 'RLM_NO_FORECAST_DESIG',
339: x_InterfaceHeaderId => x_Sched_rec.header_id,
340: x_InterfaceLineId => v_InterfaceLineId,

Line 337: x_ExceptionLevel => rlm_message_sv.k_error_level,

333: AND customer_item_id = x_Group_rec.customer_item_id
334: AND rownum = 1;
335: --
336: rlm_message_sv.app_error(
337: x_ExceptionLevel => rlm_message_sv.k_error_level,
338: x_MessageName => 'RLM_NO_FORECAST_DESIG',
339: x_InterfaceHeaderId => x_Sched_rec.header_id,
340: x_InterfaceLineId => v_InterfaceLineId,
341: x_ScheduleHeaderId => x_Sched_rec.schedule_header_id,

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

407: --
408: WHEN OTHERS THEN
409: --
410: x_ReturnStatus := rlm_core_sv.k_PROC_ERROR;
411: rlm_message_sv.sql_error('rlm_forecast_sv.ManageForecast',x_progress);
412: --
413: IF (l_debug <> -1) THEN
414: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
415: END IF;

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

476: END IF;
477: --
478: EXCEPTION
479: WHEN OTHERS THEN
480: rlm_message_sv.sql_error('RLM_FORECAST_SV.InitializeGroup',x_progress);
481: --
482: IF (l_debug <> -1) THEN
483: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
484: END IF;

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

535: END IF;
536:
537: EXCEPTION
538: WHEN OTHERS THEN
539: rlm_message_sv.sql_error('rlm_forecast_sv.FetchGroup',x_progress);
540: --
541: IF (l_debug <> -1) THEN
542: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
543: END IF;

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

592: --
593: RETURN FALSE;
594:
595: WHEN OTHERS THEN
596: rlm_message_sv.sql_error('rlm_forecast_sv.LockHeaders',x_progress);
597: --
598: IF (l_debug <> -1) THEN
599: rlm_core_sv.dlog(k_DEBUG,'Returning FALSE from WHEN OTHERS ');
600: rlm_core_sv.dlog(k_DEBUG,'progress',x_Progress);

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

638: EXCEPTION
639: --
640: WHEN OTHERS THEN
641: --
642: rlm_message_sv.sql_error('rlm_forecast_sv.UpdateHeaderStatus',x_progress);
643: --
644: IF (l_debug <> -1) THEN
645: rlm_core_sv.dlog(k_DEBUG,'progress',x_Progress);
646: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: OTHER - sql error');

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

702: --
703: RETURN FALSE;
704:
705: WHEN OTHERS THEN
706: rlm_message_sv.sql_error('rlm_forecast_sv.LockLines',x_progress);
707: --
708: IF (l_debug <> -1) THEN
709: rlm_core_sv.dlog(k_DEBUG,'Returning FALSE OTHERS ');
710: rlm_core_sv.dlog(k_DEBUG,'progress',x_Progress);

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

816: EXCEPTION
817: --
818: WHEN OTHERS THEN
819: --
820: rlm_message_sv.sql_error('rlm_forecast_sv.UpdateGroupStatus',x_progress);
821: --
822: IF (l_debug <> -1) THEN
823: rlm_core_sv.dlog(k_DEBUG,'progress',x_Progress);
824: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: OTHER - sql error');

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

853: END IF;
854: --
855: EXCEPTION
856: WHEN OTHERS THEN
857: rlm_message_sv.sql_error ('RLM_forecast_sv.initialize_table', x_progress);
858: --
859: IF (l_debug <> -1) THEN
860: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: OTHERS - sql error');
861: END IF;

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

1262: --
1263: raise;
1264:
1265: WHEN OTHERS THEN
1266: rlm_message_sv.sql_error ('RLM_forecast_sv.LoadForecast', x_progress);
1267: --
1268: IF (l_debug <> -1) THEN
1269: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: OTHERS - sql error');
1270: END IF;

Line 1321: rlm_message_sv.app_error(

1317: rlm_core_sv.dlog(k_DEBUG,'RLM_FORECAST_FAILED',
1318: t_Forecast(v_Count).error_message);
1319: END IF;
1320: --
1321: rlm_message_sv.app_error(
1322: x_ExceptionLevel => rlm_message_sv.k_error_level,
1323: x_MessageName => 'RLM_FORECAST_FAILED',
1324: x_InterfaceHeaderId => x_sched_rec.header_id,
1325: x_InterfaceLineId => t_forecast(v_Count).source_line_id,

Line 1322: x_ExceptionLevel => rlm_message_sv.k_error_level,

1318: t_Forecast(v_Count).error_message);
1319: END IF;
1320: --
1321: rlm_message_sv.app_error(
1322: x_ExceptionLevel => rlm_message_sv.k_error_level,
1323: x_MessageName => 'RLM_FORECAST_FAILED',
1324: x_InterfaceHeaderId => x_sched_rec.header_id,
1325: x_InterfaceLineId => t_forecast(v_Count).source_line_id,
1326: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

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

1376: --
1377: RAISE;
1378: --
1379: WHEN OTHERS THEN
1380: rlm_message_sv.sql_error ('RLM_forecast_sv.process_table', x_progress);
1381: --
1382: IF (l_debug <> -1) THEN
1383: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: OTHERS - sql error');
1384: END IF;

Line 1756: rlm_message_sv.app_error(

1752: AND ship_to_address_id = x_Group_rec.ship_to_address_id
1753: AND customer_item_id = x_Group_rec.customer_item_id
1754: AND rownum = 1;
1755: --
1756: rlm_message_sv.app_error(
1757: x_ExceptionLevel => rlm_message_sv.k_error_level,
1758: x_MessageName => 'RLM_FORECAST_API_FAILED',
1759: x_InterfaceHeaderId => x_sched_rec.header_id,
1760: x_InterfaceLineId => v_InterfaceLineId,

Line 1757: x_ExceptionLevel => rlm_message_sv.k_error_level,

1753: AND customer_item_id = x_Group_rec.customer_item_id
1754: AND rownum = 1;
1755: --
1756: rlm_message_sv.app_error(
1757: x_ExceptionLevel => rlm_message_sv.k_error_level,
1758: x_MessageName => 'RLM_FORECAST_API_FAILED',
1759: x_InterfaceHeaderId => x_sched_rec.header_id,
1760: x_InterfaceLineId => v_InterfaceLineId,
1761: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,

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

2006: END IF;
2007: --
2008: WHEN OTHERS THEN
2009: --
2010: rlm_message_sv.sql_error('rlm_validatedemand_sv.GetTPContext',v_Progress);
2011: IF (l_debug <> -1) THEN
2012: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
2013: END IF;
2014: raise;

Line 2097: rlm_message_sv.app_error(

2093: FETCH c into v_item_number;
2094: --
2095: v_ShipFromOrgName := RLM_CORE_SV.get_ship_from(p_org_id);
2096: --
2097: rlm_message_sv.app_error(
2098: x_ExceptionLevel => rlm_message_sv.k_error_level,
2099: x_MessageName => 'RLM_ERROR_NO_PRIMARY_UOM',
2100: x_token1=> 'INVITM',
2101: x_value1=> v_item_number,

Line 2098: x_ExceptionLevel => rlm_message_sv.k_error_level,

2094: --
2095: v_ShipFromOrgName := RLM_CORE_SV.get_ship_from(p_org_id);
2096: --
2097: rlm_message_sv.app_error(
2098: x_ExceptionLevel => rlm_message_sv.k_error_level,
2099: x_MessageName => 'RLM_ERROR_NO_PRIMARY_UOM',
2100: x_token1=> 'INVITM',
2101: x_value1=> v_item_number,
2102: x_token2=> 'SHP_FRM_ORG',

Line 2129: rlm_message_sv.app_error(

2125: --
2126: OPEN c;
2127: FETCH c into v_item_number;
2128: --
2129: rlm_message_sv.app_error(
2130: x_ExceptionLevel => rlm_message_sv.k_error_level,
2131: x_MessageName => 'RLM_UNDEF_UOM_CONVERSION',
2132: x_token1=> 'FROM_UOM',
2133: x_value1=> from_uom,

Line 2130: x_ExceptionLevel => rlm_message_sv.k_error_level,

2126: OPEN c;
2127: FETCH c into v_item_number;
2128: --
2129: rlm_message_sv.app_error(
2130: x_ExceptionLevel => rlm_message_sv.k_error_level,
2131: x_MessageName => 'RLM_UNDEF_UOM_CONVERSION',
2132: x_token1=> 'FROM_UOM',
2133: x_value1=> from_uom,
2134: x_token2=> 'TO_UOM',