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.AHL_UMP_FORECAST_REQ_PVT dependencies on AHL_UMP_FORECAST_REQ_PVT

Line 1: PACKAGE BODY AHL_UMP_FORECAST_REQ_PVT AS

1: PACKAGE BODY AHL_UMP_FORECAST_REQ_PVT AS
2: /* $Header: AHLVURQB.pls 120.3.12020000.2 2012/12/11 03:22:05 prakkum ship $ */
3:
4: -----------------------
5: -- Declare Constants --

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UMP_FORECAST_REQ_PVT';

3:
4: -----------------------
5: -- Declare Constants --
6: -----------------------
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UMP_FORECAST_REQ_PVT';
8: --G_APP_MODULE CONSTANT VARCHAR2(30) := 'AHL';
9: G_APP_MODULE CONSTANT VARCHAR2(30) := RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')));
10:
11: -- UMP Statuses

Line 182: l_debug_module varchar2(400) := 'AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast';

178: l_previous_route_id NUMBER;
179: l_previous_req_date DATE;
180: l_visit_id NUMBER;
181:
182: l_debug_module varchar2(400) := 'AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast';
183:
184: BEGIN
185: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
186: fnd_log.string

Line 189: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast.begin',

185: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
186: fnd_log.string
187: (
188: G_DEBUG_PROC,
189: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast.begin',
190: 'At the start of PLSQL procedure'
191: );
192: END IF;
193:

Line 215: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

211: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
212: fnd_log.string
213: (
214: G_DEBUG_STMT,
215: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
216: 'Have succesfully deleted the orphan forecasts'
217: );
218: END IF;
219:

Line 227: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

223: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
224: fnd_log.string
225: (
226: G_DEBUG_STMT,
227: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
228: 'Processing unit effectivities for csi_item_instance_id : ' || P_applicable_instances_tbl(i).csi_item_instance_id
229: );
230: END IF;
231: FOR ue_mr_routes_rec IN ue_mr_routes_csr (P_applicable_instances_tbl(i).csi_item_instance_id) LOOP

Line 236: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

232: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
233: fnd_log.string
234: (
235: G_DEBUG_STMT ,
236: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
237: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req API :p_route_id :p_mr_route_id : p_item_instance_id : p_requirement_date'
238: || ue_mr_routes_rec.route_id || ':' || ue_mr_routes_rec.mr_route_id || ':' ||P_applicable_instances_tbl(i).csi_item_instance_id
239: || ':' ||ue_mr_routes_rec.due_date
240: );

Line 253: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

249: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
250: fnd_log.string
251: (
252: G_DEBUG_STMT ,
253: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
254: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req API :p_route_id :p_mr_route_id : '
255: || ue_mr_routes_rec.route_id || ':' || ue_mr_routes_rec.mr_route_id
256: );
257: END IF;

Line 301: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

297: IF(fnd_log.level_error >= G_DEBUG_LEVEL)THEN
298: fnd_log.string
299: (
300: fnd_log.level_error,
301: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
302: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req Threw error'
303: );
304: END IF;
305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 314: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

310: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
311: fnd_log.string
312: (
313: G_DEBUG_STMT,
314: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
315: 'After call AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req API : l_Route_Mtl_Req_Tbl.COUNT : ' || l_Route_Mtl_Req_Tbl.COUNT
316: );
317: END IF;
318: FOR j IN l_Route_Mtl_Req_Tbl.FIRST..l_Route_Mtl_Req_Tbl.LAST LOOP

Line 327: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

323: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
324: fnd_log.string
325: (
326: G_DEBUG_STMT,
327: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
328: 'Inserting record in AHL_SCHEDULE_MATERIALS '
329: );
330: fnd_log.string
331: (

Line 333: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

329: );
330: fnd_log.string
331: (
332: G_DEBUG_STMT,
333: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
334: 'unit_effectivity_id : ' || ue_mr_routes_rec.unit_effectivity_id
335: );
336: fnd_log.string
337: (

Line 339: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

335: );
336: fnd_log.string
337: (
338: G_DEBUG_STMT,
339: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
340: 'requested_date : ' || ue_mr_routes_rec.due_date
341: );
342: fnd_log.string
343: (

Line 345: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

341: );
342: fnd_log.string
343: (
344: G_DEBUG_STMT,
345: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
346: 'mr_route_id : '|| ue_mr_routes_rec.mr_route_id
347: );
348: fnd_log.string
349: (

Line 351: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

347: );
348: fnd_log.string
349: (
350: G_DEBUG_STMT,
351: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
352: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id
353: );
354: fnd_log.string
355: (

Line 357: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

353: );
354: fnd_log.string
355: (
356: G_DEBUG_STMT,
357: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
358: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity
359: );
360: fnd_log.string
361: (

Line 363: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

359: );
360: fnd_log.string
361: (
362: G_DEBUG_STMT,
363: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
364: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code
365: );
366: END IF;
367: AHL_SCHEDULE_MATERIALS_PKG.INSERT_ROW

Line 430: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

426: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
427: fnd_log.string
428: (
429: G_DEBUG_STMT,
430: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
431: 'Updating record in AHL_SCHEDULE_MATERIALS '
432: );
433: fnd_log.string
434: (

Line 436: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

432: );
433: fnd_log.string
434: (
435: G_DEBUG_STMT,
436: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
437: 'unit_effectivity_id : ' || ue_mr_routes_rec.unit_effectivity_id
438: );
439: fnd_log.string
440: (

Line 442: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

438: );
439: fnd_log.string
440: (
441: G_DEBUG_STMT,
442: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
443: 'requested_date : ' || ue_mr_routes_rec.due_date
444: );
445: fnd_log.string
446: (

Line 448: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

444: );
445: fnd_log.string
446: (
447: G_DEBUG_STMT,
448: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
449: 'mr_route_id : '|| ue_mr_routes_rec.mr_route_id
450: );
451: fnd_log.string
452: (

Line 454: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

450: );
451: fnd_log.string
452: (
453: G_DEBUG_STMT,
454: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
455: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id
456: );
457: fnd_log.string
458: (

Line 460: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

456: );
457: fnd_log.string
458: (
459: G_DEBUG_STMT,
460: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
461: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity
462: );
463: fnd_log.string
464: (

Line 466: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

462: );
463: fnd_log.string
464: (
465: G_DEBUG_STMT,
466: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
467: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code
468: );
469: END IF;
470: AHL_SCHEDULE_MATERIALS_PKG.UPDATE_ROW

Line 539: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

535: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
536: fnd_log.string
537: (
538: G_DEBUG_STMT,
539: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
540: 'Have succesfully finished forecasting'
541: );
542: END IF;
543: -- Check Error Message stack.

Line 558: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast.end',

554: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
555: fnd_log.string
556: (
557: G_DEBUG_PROC,
558: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast.end',
559: 'At the end of PLSQL procedure'
560: );
561: END IF;
562:

Line 654: l_debug_module VARCHAR2(400) := 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Mat_Forecast_Stream';

650: AND UE.due_date IS NOT NULL
651: AND (UE.status_code IS NULL OR UE.status_code = 'INIT-DUE');
652: --ORDER BY csi_item_instance_id, due_date;
653:
654: l_debug_module VARCHAR2(400) := 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Mat_Forecast_Stream';
655:
656: l_csi_item_instance_id NUMBER;
657: l_name ahl_unit_config_headers.name%TYPE;
658: l_instance_number csi_item_instances.instance_number%TYPE;

Line 787: AHL_UMP_FORECAST_REQ_PVT.process_mrl_req_forecast

783:
784: SAVEPOINT Build_Mrl_Forecast_Stream_s;
785:
786: --call for material requirement forecast
787: AHL_UMP_FORECAST_REQ_PVT.process_mrl_req_forecast
788: (
789: p_api_version => 1.0,
790: p_init_msg_list => FND_API.G_TRUE,
791: p_commit => FND_API.G_FALSE,

Line 846: AHL_UMP_FORECAST_REQ_PVT.Process_Material_Req

842: IF (l_mr_route_id_tbl.COUNT > 0) THEN
843: FOR k IN l_mr_route_id_tbl.FIRST..l_mr_route_id_tbl.LAST LOOP
844: -- validate and update/insert into schedule materials for
845: -- every combination of UE and mr_route_id.
846: AHL_UMP_FORECAST_REQ_PVT.Process_Material_Req
847: (p_unit_effectivity_id => l_ue_id_tbl(i),
848: p_csi_item_instance_id => l_ue_ii_id_tbl(i),
849: p_due_date => l_ue_due_date_tbl(i),
850: p_mr_route_id => l_mr_route_id_tbl(k),

Line 977: fnd_log.string ( G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Config_Tree',

973:
974: BEGIN
975:
976: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
977: fnd_log.string ( G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Config_Tree',
978: 'Start Build_Config_Tree');
979: END IF;
980:
981: -- For top node.

Line 1022: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Config_Tree',

1018:
1019: X_CONFIG_NODE_TBL := l_config_node_tbl;
1020:
1021: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
1022: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Config_Tree',
1023: 'Count on config' || x_config_node_tbl.COUNT);
1024:
1025: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Config_Tree',
1026: 'End Build_Config_Tree');

Line 1025: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Config_Tree',

1021: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
1022: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Config_Tree',
1023: 'Count on config' || x_config_node_tbl.COUNT);
1024:
1025: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Config_Tree',
1026: 'End Build_Config_Tree');
1027: END IF;
1028:
1029: END Build_Config_Tree;

Line 1070: l_debug_module VARCHAR2(1000) := 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Material_Req';

1066: SELECT DISTINCT visit_id
1067: FROM ahl_visit_tasks_b
1068: WHERE unit_effectivity_id = p_unit_effectivity_id;
1069:
1070: l_debug_module VARCHAR2(1000) := 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Material_Req';
1071: l_Schedule_Mtl_Req_rec AHL_SCHEDULE_MATERIALS%ROWTYPE;
1072: l_requirement_date DATE;
1073: l_Route_Mtl_Req_Tbl AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;
1074: l_visit_id NUMBER;

Line 1333: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.log_error_messages',

1329:
1330: BEGIN
1331:
1332: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
1333: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.log_error_messages',
1334: 'Start log error messages');
1335: END IF;
1336:
1337: -- Standard call to get message count.

Line 1349: fnd_log.string (G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.log_error_messages',

1345: p_msg_index_out => l_msg_index_out );
1346:
1347: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_msg_data);
1348: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1349: fnd_log.string (G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.log_error_messages',
1350: 'Err message-'||l_msg_index_out||':' || substr(l_msg_data,1,240));
1351: END IF;
1352:
1353: END LOOP;

Line 1356: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.log_error_messages',

1352:
1353: END LOOP;
1354:
1355: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
1356: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.log_error_messages',
1357: 'End log error messages');
1358: END IF;
1359:
1360: END log_error_messages;

Line 1362: END AHL_UMP_FORECAST_REQ_PVT;

1358: END IF;
1359:
1360: END log_error_messages;
1361:
1362: END AHL_UMP_FORECAST_REQ_PVT;