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 FND_LOG

Line 16: -- FND Logging Constants

12: G_REQ_TYPE_FORECAST CONSTANT VARCHAR2(30) := 'FORECAST';
13:
14: G_IS_PM_INSTALLED CONSTANT VARCHAR2(1) := AHL_UTIL_PKG.IS_PM_INSTALLED;
15:
16: -- FND Logging Constants
17: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
18: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 17: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

13:
14: G_IS_PM_INSTALLED CONSTANT VARCHAR2(1) := AHL_UTIL_PKG.IS_PM_INSTALLED;
15:
16: -- FND Logging Constants
17: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
18: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
21:

Line 18: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

14: G_IS_PM_INSTALLED CONSTANT VARCHAR2(1) := AHL_UTIL_PKG.IS_PM_INSTALLED;
15:
16: -- FND Logging Constants
17: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
18: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
21:
22: ------------------------------

Line 19: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

15:
16: -- FND Logging Constants
17: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
18: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
21:
22: ------------------------------
23: -- Declare Global Variables --

Line 20: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

16: -- FND Logging Constants
17: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
18: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
19: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
20: G_DEBUG_UEXP CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
21:
22: ------------------------------
23: -- Declare Global Variables --
24: ------------------------------

Line 178: fnd_log.string

174: l_debug_module varchar2(400) := 'AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast';
175:
176: BEGIN
177: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
178: fnd_log.string
179: (
180: G_DEBUG_PROC,
181: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast.begin',
182: 'At the start of PLSQL procedure'

Line 204: fnd_log.string

200: AHL_SCHEDULE_MATERIALS_PKG.delete_row(x_scheduled_material_id => delete_mtl_forecast_rec.scheduled_material_id);
201: END LOOP;*/
202:
203: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
204: fnd_log.string
205: (
206: G_DEBUG_STMT,
207: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
208: 'Have succesfully deleted the orphan forecasts'

Line 216: fnd_log.string

212: --Collect the material requirements and forecast them
213: IF(P_applicable_instances_tbl IS NOT NULL AND P_applicable_instances_tbl.COUNT > 0)THEN
214: FOR i IN P_applicable_instances_tbl.FIRST..P_applicable_instances_tbl.LAST LOOP
215: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
216: fnd_log.string
217: (
218: G_DEBUG_STMT,
219: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
220: 'Processing unit effectivities for csi_item_instance_id : ' || P_applicable_instances_tbl(i).csi_item_instance_id

Line 225: fnd_log.string

221: );
222: END IF;
223: FOR ue_mr_routes_rec IN ue_mr_routes_csr (P_applicable_instances_tbl(i).csi_item_instance_id) LOOP
224: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
225: fnd_log.string
226: (
227: G_DEBUG_STMT ,
228: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
229: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req API :p_route_id :p_mr_route_id : p_item_instance_id : p_requirement_date'

Line 242: fnd_log.string

238: IF NOT(TRUNC(NVL(ue_mr_routes_rec.start_date_active,SYSDATE)) <= TRUNC(SYSDATE)
239: AND TRUNC(NVL(ue_mr_routes_rec.end_date_active,SYSDATE+1))>TRUNC(SYSDATE))THEN
240: -- route is expired so delete forecast
241: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
242: fnd_log.string
243: (
244: G_DEBUG_STMT ,
245: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
246: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req API :p_route_id :p_mr_route_id : '

Line 283: IF(fnd_log.level_error >= G_DEBUG_LEVEL)THEN

279: l_previous_route_id := ue_mr_routes_rec.route_id;
280: l_previous_req_date := l_requirement_date;
281:
282: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
283: IF(fnd_log.level_error >= G_DEBUG_LEVEL)THEN
284: fnd_log.string
285: (
286: fnd_log.level_error,
287: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',

Line 284: fnd_log.string

280: l_previous_req_date := l_requirement_date;
281:
282: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
283: IF(fnd_log.level_error >= G_DEBUG_LEVEL)THEN
284: fnd_log.string
285: (
286: fnd_log.level_error,
287: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
288: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req Threw error'

Line 286: fnd_log.level_error,

282: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
283: IF(fnd_log.level_error >= G_DEBUG_LEVEL)THEN
284: fnd_log.string
285: (
286: fnd_log.level_error,
287: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
288: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req Threw error'
289: );
290: END IF;

Line 297: fnd_log.string

293: END IF;
294:
295: IF (l_Route_Mtl_Req_Tbl IS NOT NULL AND l_Route_Mtl_Req_Tbl.COUNT > 0)THEN
296: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
297: fnd_log.string
298: (
299: G_DEBUG_STMT,
300: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
301: 'After call AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req API : l_Route_Mtl_Req_Tbl.COUNT : ' || l_Route_Mtl_Req_Tbl.COUNT

Line 310: fnd_log.string

306: ue_mr_routes_rec.mr_route_id, l_Route_Mtl_Req_Tbl(j).inventory_item_id, l_Route_Mtl_Req_Tbl(j).rt_oper_material_id);
307: FETCH schedule_mtl_exists_csr INTO l_Schedule_Mtl_Req_rec;
308: IF(schedule_mtl_exists_csr%NOTFOUND)THEN
309: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
310: fnd_log.string
311: (
312: G_DEBUG_STMT,
313: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
314: 'Inserting record in AHL_SCHEDULE_MATERIALS '

Line 316: fnd_log.string

312: G_DEBUG_STMT,
313: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
314: 'Inserting record in AHL_SCHEDULE_MATERIALS '
315: );
316: fnd_log.string
317: (
318: G_DEBUG_STMT,
319: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
320: 'unit_effectivity_id : ' || ue_mr_routes_rec.unit_effectivity_id

Line 322: fnd_log.string

318: G_DEBUG_STMT,
319: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
320: 'unit_effectivity_id : ' || ue_mr_routes_rec.unit_effectivity_id
321: );
322: fnd_log.string
323: (
324: G_DEBUG_STMT,
325: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
326: 'requested_date : ' || ue_mr_routes_rec.due_date

Line 328: fnd_log.string

324: G_DEBUG_STMT,
325: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
326: 'requested_date : ' || ue_mr_routes_rec.due_date
327: );
328: fnd_log.string
329: (
330: G_DEBUG_STMT,
331: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
332: 'mr_route_id : '|| ue_mr_routes_rec.mr_route_id

Line 334: fnd_log.string

330: G_DEBUG_STMT,
331: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
332: 'mr_route_id : '|| ue_mr_routes_rec.mr_route_id
333: );
334: fnd_log.string
335: (
336: G_DEBUG_STMT,
337: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
338: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id

Line 340: fnd_log.string

336: G_DEBUG_STMT,
337: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
338: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id
339: );
340: fnd_log.string
341: (
342: G_DEBUG_STMT,
343: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
344: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity

Line 346: fnd_log.string

342: G_DEBUG_STMT,
343: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
344: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity
345: );
346: fnd_log.string
347: (
348: G_DEBUG_STMT,
349: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
350: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code

Line 410: fnd_log.string

406: X_ATTRIBUTE15 => NULL
407: );
408: ELSE
409: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
410: fnd_log.string
411: (
412: G_DEBUG_STMT,
413: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
414: 'Updating record in AHL_SCHEDULE_MATERIALS '

Line 416: fnd_log.string

412: G_DEBUG_STMT,
413: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
414: 'Updating record in AHL_SCHEDULE_MATERIALS '
415: );
416: fnd_log.string
417: (
418: G_DEBUG_STMT,
419: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
420: 'unit_effectivity_id : ' || ue_mr_routes_rec.unit_effectivity_id

Line 422: fnd_log.string

418: G_DEBUG_STMT,
419: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
420: 'unit_effectivity_id : ' || ue_mr_routes_rec.unit_effectivity_id
421: );
422: fnd_log.string
423: (
424: G_DEBUG_STMT,
425: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
426: 'requested_date : ' || ue_mr_routes_rec.due_date

Line 428: fnd_log.string

424: G_DEBUG_STMT,
425: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
426: 'requested_date : ' || ue_mr_routes_rec.due_date
427: );
428: fnd_log.string
429: (
430: G_DEBUG_STMT,
431: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
432: 'mr_route_id : '|| ue_mr_routes_rec.mr_route_id

Line 434: fnd_log.string

430: G_DEBUG_STMT,
431: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
432: 'mr_route_id : '|| ue_mr_routes_rec.mr_route_id
433: );
434: fnd_log.string
435: (
436: G_DEBUG_STMT,
437: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
438: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id

Line 440: fnd_log.string

436: G_DEBUG_STMT,
437: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
438: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id
439: );
440: fnd_log.string
441: (
442: G_DEBUG_STMT,
443: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
444: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity

Line 446: fnd_log.string

442: G_DEBUG_STMT,
443: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
444: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity
445: );
446: fnd_log.string
447: (
448: G_DEBUG_STMT,
449: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
450: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code

Line 516: fnd_log.string

512: END LOOP;-- for all item instances
513: END IF;-- if there is a list of item instances
514:
515: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
516: fnd_log.string
517: (
518: G_DEBUG_STMT,
519: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast',
520: 'Have succesfully finished forecasting'

Line 535: fnd_log.string

531: COMMIT WORK;
532: END IF;
533:
534: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
535: fnd_log.string
536: (
537: G_DEBUG_PROC,
538: 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Mrl_Req_Forecast.end',
539: 'At the end of PLSQL procedure'

Line 661: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Start Build_Mat_Forecast_Stream');

657:
658: BEGIN
659:
660: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
661: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Start Build_Mat_Forecast_Stream');
662: fnd_log.string ( G_DEBUG_PROC, l_debug_module,
663: 'Input Parameter: p_unit_config_hdr_id:' || p_unit_config_hdr_id);
664: fnd_log.string ( G_DEBUG_PROC, l_debug_module,
665: 'Input Parameter: p_item_instance_id:' || p_item_instance_id);

Line 662: fnd_log.string ( G_DEBUG_PROC, l_debug_module,

658: BEGIN
659:
660: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
661: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Start Build_Mat_Forecast_Stream');
662: fnd_log.string ( G_DEBUG_PROC, l_debug_module,
663: 'Input Parameter: p_unit_config_hdr_id:' || p_unit_config_hdr_id);
664: fnd_log.string ( G_DEBUG_PROC, l_debug_module,
665: 'Input Parameter: p_item_instance_id:' || p_item_instance_id);
666: END IF;

Line 664: fnd_log.string ( G_DEBUG_PROC, l_debug_module,

660: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
661: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Start Build_Mat_Forecast_Stream');
662: fnd_log.string ( G_DEBUG_PROC, l_debug_module,
663: 'Input Parameter: p_unit_config_hdr_id:' || p_unit_config_hdr_id);
664: fnd_log.string ( G_DEBUG_PROC, l_debug_module,
665: 'Input Parameter: p_item_instance_id:' || p_item_instance_id);
666: END IF;
667:
668: -- initialize return status.

Line 754: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Master Config ID:' || l_master_config_id);

750: RETURN;
751: END IF;
752:
753: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
754: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Master Config ID:' || l_master_config_id);
755: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Root Instance ID:' || l_csi_item_instance_id);
756: END IF;
757:
758: -- Build the Configuration tree structure.(G_config_node_tbl).

Line 755: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Root Instance ID:' || l_csi_item_instance_id);

751: END IF;
752:
753: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
754: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Master Config ID:' || l_master_config_id);
755: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Root Instance ID:' || l_csi_item_instance_id);
756: END IF;
757:
758: -- Build the Configuration tree structure.(G_config_node_tbl).
759: Build_Config_Tree(l_csi_item_instance_id, l_master_config_id, l_config_node_tbl);

Line 805: fnd_log.string ( G_DEBUG_STMT, l_debug_module, 'MR Header ID:' || l_mr_header_id_tbl(j));

801: -- set savepoint for MR and commit after processing MR.
802: SAVEPOINT Build_Mrl_Forecast_Stream_s;
803:
804: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
805: fnd_log.string ( G_DEBUG_STMT, l_debug_module, 'MR Header ID:' || l_mr_header_id_tbl(j));
806: END IF;
807:
808: OPEN ahl_mr_route_csr(l_mr_header_id_tbl(j));
809: FETCH ahl_mr_route_csr BULK COLLECT INTO l_mr_route_id_tbl, l_route_id_tbl,

Line 848: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Out Parameter: retcode:' || retcode);

844: END IF; -- p_unit_config_hdr_id IS NULL AND p_item_instance_id IS NULL
845:
846:
847: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
848: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Out Parameter: retcode:' || retcode);
849: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Out Parameter: errbuf:' || errbuf);
850: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'End Build_Mat_Forecast_Stream');
851: END IF;
852:

Line 849: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Out Parameter: errbuf:' || errbuf);

845:
846:
847: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
848: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Out Parameter: retcode:' || retcode);
849: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Out Parameter: errbuf:' || errbuf);
850: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'End Build_Mat_Forecast_Stream');
851: END IF;
852:
853:

Line 850: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'End Build_Mat_Forecast_Stream');

846:
847: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
848: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Out Parameter: retcode:' || retcode);
849: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Out Parameter: errbuf:' || errbuf);
850: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'End Build_Mat_Forecast_Stream');
851: END IF;
852:
853:
854: EXCEPTION

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

950:
951: BEGIN
952:
953: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
954: fnd_log.string ( G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Config_Tree',
955: 'Start Build_Config_Tree');
956: END IF;
957:
958: -- For top node.

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

995:
996: X_CONFIG_NODE_TBL := l_config_node_tbl;
997:
998: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
999: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Config_Tree',
1000: 'Count on config' || x_config_node_tbl.COUNT);
1001:
1002: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Config_Tree',
1003: 'End Build_Config_Tree');

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

998: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
999: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Config_Tree',
1000: 'Count on config' || x_config_node_tbl.COUNT);
1001:
1002: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Build_Config_Tree',
1003: 'End Build_Config_Tree');
1004: END IF;
1005:
1006: END Build_Config_Tree;

Line 1052: fnd_log.string (G_DEBUG_STMT , l_debug_module,

1048:
1049: BEGIN
1050:
1051: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1052: fnd_log.string (G_DEBUG_STMT , l_debug_module,
1053: 'p_route_id:p_mr_route_id:p_item_instance_id:p_requirement_date:' || p_route_id || ':' || p_mr_route_id || ':' ||p_csi_item_instance_id || ':' || p_due_date);
1054:
1055: -- log into concurrent log file.
1056: fnd_file.put_line(fnd_file.log,l_debug_module || ':p_route_id :p_mr_route_id : p_item_instance_id : p_requirement_date' || p_route_id || ':' || p_mr_route_id || ':' ||p_csi_item_instance_id || ':' || p_due_date);

Line 1066: fnd_log.string (G_DEBUG_STMT ,l_debug_module,

1062: IF NOT(TRUNC(NVL(p_r_start_date_active,SYSDATE)) <= TRUNC(SYSDATE)
1063: AND TRUNC(NVL(p_r_end_date_active,SYSDATE+1))>TRUNC(SYSDATE)) THEN
1064: -- route is expired so delete forecast
1065: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1066: fnd_log.string (G_DEBUG_STMT ,l_debug_module,
1067: 'p_route_id :p_mr_route_id : ' || p_route_id || ':' || p_mr_route_id);
1068: END IF;
1069:
1070: FOR del_exp_route_rec IN del_exp_route_schedule_mtl_csr(p_unit_effectivity_id,p_mr_route_id) LOOP

Line 1105: IF (fnd_log.level_error >= G_DEBUG_LEVEL) THEN

1101: --G_previous_route_id := p_route_id;
1102: --G_previous_req_date := l_requirement_date;
1103:
1104: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1105: IF (fnd_log.level_error >= G_DEBUG_LEVEL) THEN
1106: fnd_log.string(fnd_log.level_error, l_debug_module,
1107: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req Threw error');
1108: END IF;
1109: RAISE FND_API.G_EXC_ERROR;

Line 1106: fnd_log.string(fnd_log.level_error, l_debug_module,

1102: --G_previous_req_date := l_requirement_date;
1103:
1104: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1105: IF (fnd_log.level_error >= G_DEBUG_LEVEL) THEN
1106: fnd_log.string(fnd_log.level_error, l_debug_module,
1107: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req Threw error');
1108: END IF;
1109: RAISE FND_API.G_EXC_ERROR;
1110: END IF;

Line 1116: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

1112: -- END IF; -- (NVL(G_previous_route_id,-1)
1113:
1114: IF (l_Route_Mtl_Req_Tbl IS NOT NULL AND l_Route_Mtl_Req_Tbl.COUNT > 0) THEN
1115: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1116: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1117: 'After call AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req API : l_Route_Mtl_Req_Tbl.COUNT : ' ||
1118: l_Route_Mtl_Req_Tbl.COUNT);
1119: END IF;
1120:

Line 1129: fnd_log.string (G_DEBUG_STMT, l_debug_module,

1125: l_Route_Mtl_Req_Tbl(j).rt_oper_material_id);
1126: FETCH schedule_mtl_exists_csr INTO l_Schedule_Mtl_Req_rec;
1127: IF(schedule_mtl_exists_csr%NOTFOUND)THEN
1128: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1129: fnd_log.string (G_DEBUG_STMT, l_debug_module,
1130: 'Inserting record in AHL_SCHEDULE_MATERIALS ');
1131: fnd_log.string (G_DEBUG_STMT,l_debug_module,
1132: 'unit_effectivity_id : ' || p_unit_effectivity_id);
1133: fnd_log.string (G_DEBUG_STMT,l_debug_module,

Line 1131: fnd_log.string (G_DEBUG_STMT,l_debug_module,

1127: IF(schedule_mtl_exists_csr%NOTFOUND)THEN
1128: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1129: fnd_log.string (G_DEBUG_STMT, l_debug_module,
1130: 'Inserting record in AHL_SCHEDULE_MATERIALS ');
1131: fnd_log.string (G_DEBUG_STMT,l_debug_module,
1132: 'unit_effectivity_id : ' || p_unit_effectivity_id);
1133: fnd_log.string (G_DEBUG_STMT,l_debug_module,
1134: 'requested_date : ' || p_due_date);
1135: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

Line 1133: fnd_log.string (G_DEBUG_STMT,l_debug_module,

1129: fnd_log.string (G_DEBUG_STMT, l_debug_module,
1130: 'Inserting record in AHL_SCHEDULE_MATERIALS ');
1131: fnd_log.string (G_DEBUG_STMT,l_debug_module,
1132: 'unit_effectivity_id : ' || p_unit_effectivity_id);
1133: fnd_log.string (G_DEBUG_STMT,l_debug_module,
1134: 'requested_date : ' || p_due_date);
1135: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1136: 'mr_route_id : '|| p_mr_route_id);
1137: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

Line 1135: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

1131: fnd_log.string (G_DEBUG_STMT,l_debug_module,
1132: 'unit_effectivity_id : ' || p_unit_effectivity_id);
1133: fnd_log.string (G_DEBUG_STMT,l_debug_module,
1134: 'requested_date : ' || p_due_date);
1135: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1136: 'mr_route_id : '|| p_mr_route_id);
1137: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1138: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id);
1139: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

Line 1137: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

1133: fnd_log.string (G_DEBUG_STMT,l_debug_module,
1134: 'requested_date : ' || p_due_date);
1135: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1136: 'mr_route_id : '|| p_mr_route_id);
1137: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1138: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id);
1139: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1140: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity);
1141: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

Line 1139: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

1135: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1136: 'mr_route_id : '|| p_mr_route_id);
1137: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1138: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id);
1139: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1140: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity);
1141: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1142: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code);
1143: END IF;

Line 1141: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

1137: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1138: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id);
1139: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1140: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity);
1141: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1142: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code);
1143: END IF;
1144: AHL_SCHEDULE_MATERIALS_PKG.INSERT_ROW
1145: (

Line 1201: fnd_log.string ( G_DEBUG_STMT, l_debug_module,

1197: X_ATTRIBUTE15 => NULL
1198: );
1199: ELSE -- schedule_mtl_exists
1200: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1201: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1202: 'Updating record in AHL_SCHEDULE_MATERIALS ');
1203: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1204: 'unit_effectivity_id : ' || p_unit_effectivity_id);
1205: fnd_log.string ( G_DEBUG_STMT, l_debug_module,

Line 1203: fnd_log.string ( G_DEBUG_STMT, l_debug_module,

1199: ELSE -- schedule_mtl_exists
1200: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1201: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1202: 'Updating record in AHL_SCHEDULE_MATERIALS ');
1203: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1204: 'unit_effectivity_id : ' || p_unit_effectivity_id);
1205: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1206: 'requested_date : ' || p_due_date);
1207: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

Line 1205: fnd_log.string ( G_DEBUG_STMT, l_debug_module,

1201: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1202: 'Updating record in AHL_SCHEDULE_MATERIALS ');
1203: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1204: 'unit_effectivity_id : ' || p_unit_effectivity_id);
1205: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1206: 'requested_date : ' || p_due_date);
1207: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1208: 'mr_route_id : '|| p_mr_route_id);
1209: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

Line 1207: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

1203: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1204: 'unit_effectivity_id : ' || p_unit_effectivity_id);
1205: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1206: 'requested_date : ' || p_due_date);
1207: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1208: 'mr_route_id : '|| p_mr_route_id);
1209: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1210: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id);
1211: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

Line 1209: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

1205: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1206: 'requested_date : ' || p_due_date);
1207: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1208: 'mr_route_id : '|| p_mr_route_id);
1209: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1210: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id);
1211: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1212: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity);
1213: fnd_log.string ( G_DEBUG_STMT, l_debug_module,

Line 1211: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

1207: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1208: 'mr_route_id : '|| p_mr_route_id);
1209: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1210: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id);
1211: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1212: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity);
1213: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1214: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code);
1215: fnd_log.string ( G_DEBUG_STMT, l_debug_module,

Line 1213: fnd_log.string ( G_DEBUG_STMT, l_debug_module,

1209: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1210: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id);
1211: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1212: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity);
1213: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1214: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code);
1215: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1216: 'SCHEDULED_MATERIAL_ID:' || l_Schedule_Mtl_Req_rec.SCHEDULED_MATERIAL_ID);
1217: END IF;

Line 1215: fnd_log.string ( G_DEBUG_STMT, l_debug_module,

1211: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1212: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity);
1213: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1214: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code);
1215: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1216: 'SCHEDULED_MATERIAL_ID:' || l_Schedule_Mtl_Req_rec.SCHEDULED_MATERIAL_ID);
1217: END IF;
1218: AHL_SCHEDULE_MATERIALS_PKG.UPDATE_ROW
1219: (

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

1286:
1287: BEGIN
1288:
1289: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
1290: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.log_error_messages',
1291: 'Start log error messages');
1292: END IF;
1293:
1294: -- Standard call to get message count.

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

1302: p_msg_index_out => l_msg_index_out );
1303:
1304: fnd_file.put_line(FND_FILE.LOG, 'Err message-'||l_msg_index_out||':' || l_msg_data);
1305: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1306: fnd_log.string (G_DEBUG_STMT, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.log_error_messages',
1307: 'Err message-'||l_msg_index_out||':' || substr(l_msg_data,1,240));
1308: END IF;
1309:
1310: END LOOP;

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

1309:
1310: END LOOP;
1311:
1312: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)THEN
1313: fnd_log.string (G_DEBUG_PROC, 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.log_error_messages',
1314: 'End log error messages');
1315: END IF;
1316:
1317: END log_error_messages;