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 186: fnd_log.string

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
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'

Line 212: fnd_log.string

208: AHL_SCHEDULE_MATERIALS_PKG.delete_row(x_scheduled_material_id => delete_mtl_forecast_rec.scheduled_material_id);
209: END LOOP;*/
210:
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'

Line 224: fnd_log.string

220: --Collect the material requirements and forecast them
221: IF(P_applicable_instances_tbl IS NOT NULL AND P_applicable_instances_tbl.COUNT > 0)THEN
222: FOR i IN P_applicable_instances_tbl.FIRST..P_applicable_instances_tbl.LAST LOOP
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

Line 233: fnd_log.string

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
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'

Line 250: fnd_log.string

246: IF NOT(TRUNC(NVL(ue_mr_routes_rec.start_date_active,SYSDATE)) <= TRUNC(SYSDATE)
247: AND TRUNC(NVL(ue_mr_routes_rec.end_date_active,SYSDATE+1))>TRUNC(SYSDATE))THEN
248: -- route is expired so delete 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 : '

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

293: l_previous_route_id := ue_mr_routes_rec.route_id;
294: l_previous_req_date := l_requirement_date;
295:
296: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
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',

Line 298: fnd_log.string

294: l_previous_req_date := l_requirement_date;
295:
296: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
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'

Line 300: fnd_log.level_error,

296: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
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;

Line 311: fnd_log.string

307: END IF;
308:
309: IF (l_Route_Mtl_Req_Tbl IS NOT NULL AND l_Route_Mtl_Req_Tbl.COUNT > 0)THEN
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

Line 324: fnd_log.string

320: 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);
321: FETCH schedule_mtl_exists_csr INTO l_Schedule_Mtl_Req_rec;
322: IF(schedule_mtl_exists_csr%NOTFOUND)THEN
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 '

Line 330: fnd_log.string

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: (
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

Line 336: fnd_log.string

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: (
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

Line 342: fnd_log.string

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: (
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

Line 348: fnd_log.string

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: (
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

Line 354: fnd_log.string

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: (
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

Line 360: fnd_log.string

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: (
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

Line 427: fnd_log.string

423: X_ATTRIBUTE15 => NULL
424: );
425: ELSE
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 '

Line 433: fnd_log.string

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: (
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

Line 439: fnd_log.string

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: (
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

Line 445: fnd_log.string

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: (
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

Line 451: fnd_log.string

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: (
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

Line 457: fnd_log.string

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: (
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

Line 463: fnd_log.string

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: (
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

Line 536: fnd_log.string

532: END LOOP;-- for all item instances
533: END IF;-- if there is a list of item instances
534:
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'

Line 555: fnd_log.string

551: COMMIT WORK;
552: END IF;
553:
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'

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

680:
681: BEGIN
682:
683: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
684: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Start Build_Mat_Forecast_Stream');
685: fnd_log.string ( G_DEBUG_PROC, l_debug_module,
686: 'Input Parameter: p_unit_config_hdr_id:' || p_unit_config_hdr_id);
687: fnd_log.string ( G_DEBUG_PROC, l_debug_module,
688: 'Input Parameter: p_item_instance_id:' || p_item_instance_id);

Line 685: fnd_log.string ( G_DEBUG_PROC, l_debug_module,

681: BEGIN
682:
683: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
684: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Start Build_Mat_Forecast_Stream');
685: fnd_log.string ( G_DEBUG_PROC, l_debug_module,
686: 'Input Parameter: p_unit_config_hdr_id:' || p_unit_config_hdr_id);
687: fnd_log.string ( G_DEBUG_PROC, l_debug_module,
688: 'Input Parameter: p_item_instance_id:' || p_item_instance_id);
689: END IF;

Line 687: fnd_log.string ( G_DEBUG_PROC, l_debug_module,

683: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
684: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Start Build_Mat_Forecast_Stream');
685: fnd_log.string ( G_DEBUG_PROC, l_debug_module,
686: 'Input Parameter: p_unit_config_hdr_id:' || p_unit_config_hdr_id);
687: fnd_log.string ( G_DEBUG_PROC, l_debug_module,
688: 'Input Parameter: p_item_instance_id:' || p_item_instance_id);
689: END IF;
690:
691: -- initialize return status.

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

773: RETURN;
774: END IF;
775:
776: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
777: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Master Config ID:' || l_master_config_id);
778: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Root Instance ID:' || l_csi_item_instance_id);
779: END IF;
780:
781: -- Build the Configuration tree structure.(G_config_node_tbl).

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

774: END IF;
775:
776: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
777: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Master Config ID:' || l_master_config_id);
778: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Root Instance ID:' || l_csi_item_instance_id);
779: END IF;
780:
781: -- Build the Configuration tree structure.(G_config_node_tbl).
782: Build_Config_Tree(l_csi_item_instance_id, l_master_config_id, l_config_node_tbl);

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

824: -- set savepoint for MR and commit after processing MR.
825: SAVEPOINT Build_Mrl_Forecast_Stream_s;
826:
827: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
828: fnd_log.string ( G_DEBUG_STMT, l_debug_module, 'MR Header ID:' || l_mr_header_id_tbl(j));
829: END IF;
830:
831: OPEN ahl_mr_route_csr(l_mr_header_id_tbl(j));
832: FETCH ahl_mr_route_csr BULK COLLECT INTO l_mr_route_id_tbl, l_route_id_tbl,

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

867: END IF; -- p_unit_config_hdr_id IS NULL AND p_item_instance_id IS NULL
868:
869:
870: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
871: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Out Parameter: retcode:' || retcode);
872: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Out Parameter: errbuf:' || errbuf);
873: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'End Build_Mat_Forecast_Stream');
874: END IF;
875:

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

868:
869:
870: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
871: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Out Parameter: retcode:' || retcode);
872: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Out Parameter: errbuf:' || errbuf);
873: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'End Build_Mat_Forecast_Stream');
874: END IF;
875:
876:

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

869:
870: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
871: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Out Parameter: retcode:' || retcode);
872: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'Out Parameter: errbuf:' || errbuf);
873: fnd_log.string ( G_DEBUG_PROC, l_debug_module, 'End Build_Mat_Forecast_Stream');
874: END IF;
875:
876:
877: EXCEPTION

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 1083: fnd_log.string (G_DEBUG_STMT , l_debug_module,

1079:
1080: BEGIN
1081:
1082: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1083: fnd_log.string (G_DEBUG_STMT , l_debug_module,
1084: '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);
1085:
1086: -- log into concurrent log file.
1087: 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 1097: fnd_log.string (G_DEBUG_STMT ,l_debug_module,

1093: IF NOT(TRUNC(NVL(p_r_start_date_active,SYSDATE)) <= TRUNC(SYSDATE)
1094: AND TRUNC(NVL(p_r_end_date_active,SYSDATE+1))>TRUNC(SYSDATE)) THEN
1095: -- route is expired so delete forecast
1096: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1097: fnd_log.string (G_DEBUG_STMT ,l_debug_module,
1098: 'p_route_id :p_mr_route_id : ' || p_route_id || ':' || p_mr_route_id);
1099: END IF;
1100:
1101: FOR del_exp_route_rec IN del_exp_route_schedule_mtl_csr(p_unit_effectivity_id,p_mr_route_id) LOOP

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

1138: --G_previous_route_id := p_route_id;
1139: --G_previous_req_date := l_requirement_date;
1140:
1141: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1142: IF (fnd_log.level_error >= G_DEBUG_LEVEL) THEN
1143: fnd_log.string(fnd_log.level_error, l_debug_module,
1144: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req Threw error');
1145: END IF;
1146: RAISE FND_API.G_EXC_ERROR;

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

1139: --G_previous_req_date := l_requirement_date;
1140:
1141: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1142: IF (fnd_log.level_error >= G_DEBUG_LEVEL) THEN
1143: fnd_log.string(fnd_log.level_error, l_debug_module,
1144: 'AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req Threw error');
1145: END IF;
1146: RAISE FND_API.G_EXC_ERROR;
1147: END IF;

Line 1153: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

1149: -- END IF; -- (NVL(G_previous_route_id,-1)
1150:
1151: IF (l_Route_Mtl_Req_Tbl IS NOT NULL AND l_Route_Mtl_Req_Tbl.COUNT > 0) THEN
1152: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
1153: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1154: 'After call AHL_LTP_MTL_REQ_PVT.Get_Route_Mtl_Req API : l_Route_Mtl_Req_Tbl.COUNT : ' ||
1155: l_Route_Mtl_Req_Tbl.COUNT);
1156: END IF;
1157:

Line 1166: fnd_log.string (G_DEBUG_STMT, l_debug_module,

1162: l_Route_Mtl_Req_Tbl(j).rt_oper_material_id);
1163: FETCH schedule_mtl_exists_csr INTO l_Schedule_Mtl_Req_rec;
1164: IF(schedule_mtl_exists_csr%NOTFOUND)THEN
1165: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1166: fnd_log.string (G_DEBUG_STMT, l_debug_module,
1167: 'Inserting record in AHL_SCHEDULE_MATERIALS ');
1168: fnd_log.string (G_DEBUG_STMT,l_debug_module,
1169: 'unit_effectivity_id : ' || p_unit_effectivity_id);
1170: fnd_log.string (G_DEBUG_STMT,l_debug_module,

Line 1168: fnd_log.string (G_DEBUG_STMT,l_debug_module,

1164: IF(schedule_mtl_exists_csr%NOTFOUND)THEN
1165: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1166: fnd_log.string (G_DEBUG_STMT, l_debug_module,
1167: 'Inserting record in AHL_SCHEDULE_MATERIALS ');
1168: fnd_log.string (G_DEBUG_STMT,l_debug_module,
1169: 'unit_effectivity_id : ' || p_unit_effectivity_id);
1170: fnd_log.string (G_DEBUG_STMT,l_debug_module,
1171: 'requested_date : ' || p_due_date);
1172: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

Line 1170: fnd_log.string (G_DEBUG_STMT,l_debug_module,

1166: fnd_log.string (G_DEBUG_STMT, l_debug_module,
1167: 'Inserting record in AHL_SCHEDULE_MATERIALS ');
1168: fnd_log.string (G_DEBUG_STMT,l_debug_module,
1169: 'unit_effectivity_id : ' || p_unit_effectivity_id);
1170: fnd_log.string (G_DEBUG_STMT,l_debug_module,
1171: 'requested_date : ' || p_due_date);
1172: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1173: 'mr_route_id : '|| p_mr_route_id);
1174: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

Line 1172: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

1168: fnd_log.string (G_DEBUG_STMT,l_debug_module,
1169: 'unit_effectivity_id : ' || p_unit_effectivity_id);
1170: fnd_log.string (G_DEBUG_STMT,l_debug_module,
1171: 'requested_date : ' || p_due_date);
1172: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1173: 'mr_route_id : '|| p_mr_route_id);
1174: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1175: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id);
1176: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

Line 1174: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

1170: fnd_log.string (G_DEBUG_STMT,l_debug_module,
1171: 'requested_date : ' || p_due_date);
1172: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1173: 'mr_route_id : '|| p_mr_route_id);
1174: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1175: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id);
1176: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1177: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity);
1178: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

Line 1176: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

1172: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1173: 'mr_route_id : '|| p_mr_route_id);
1174: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1175: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id);
1176: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1177: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity);
1178: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1179: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code);
1180: END IF;

Line 1178: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

1174: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1175: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id);
1176: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1177: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity);
1178: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1179: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code);
1180: END IF;
1181: AHL_SCHEDULE_MATERIALS_PKG.INSERT_ROW
1182: (

Line 1241: fnd_log.string ( G_DEBUG_STMT, l_debug_module,

1237: X_ATTRIBUTE15 => NULL
1238: );
1239: ELSE -- schedule_mtl_exists
1240: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1241: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1242: 'Updating record in AHL_SCHEDULE_MATERIALS ');
1243: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1244: 'unit_effectivity_id : ' || p_unit_effectivity_id);
1245: fnd_log.string ( G_DEBUG_STMT, l_debug_module,

Line 1243: fnd_log.string ( G_DEBUG_STMT, l_debug_module,

1239: ELSE -- schedule_mtl_exists
1240: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)THEN
1241: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1242: 'Updating record in AHL_SCHEDULE_MATERIALS ');
1243: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1244: 'unit_effectivity_id : ' || p_unit_effectivity_id);
1245: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1246: 'requested_date : ' || p_due_date);
1247: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

Line 1245: fnd_log.string ( G_DEBUG_STMT, l_debug_module,

1241: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1242: 'Updating record in AHL_SCHEDULE_MATERIALS ');
1243: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1244: 'unit_effectivity_id : ' || p_unit_effectivity_id);
1245: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1246: 'requested_date : ' || p_due_date);
1247: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1248: 'mr_route_id : '|| p_mr_route_id);
1249: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

Line 1247: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

1243: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1244: 'unit_effectivity_id : ' || p_unit_effectivity_id);
1245: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1246: 'requested_date : ' || p_due_date);
1247: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1248: 'mr_route_id : '|| p_mr_route_id);
1249: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1250: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id);
1251: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

Line 1249: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

1245: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1246: 'requested_date : ' || p_due_date);
1247: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1248: 'mr_route_id : '|| p_mr_route_id);
1249: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1250: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id);
1251: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1252: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity);
1253: fnd_log.string ( G_DEBUG_STMT, l_debug_module,

Line 1251: fnd_log.string ( G_DEBUG_STMT,l_debug_module,

1247: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1248: 'mr_route_id : '|| p_mr_route_id);
1249: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1250: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id);
1251: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1252: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity);
1253: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1254: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code);
1255: fnd_log.string ( G_DEBUG_STMT, l_debug_module,

Line 1253: fnd_log.string ( G_DEBUG_STMT, l_debug_module,

1249: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1250: 'inventory_item_id : ' || l_Route_Mtl_Req_Tbl(j).inventory_item_id);
1251: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1252: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity);
1253: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1254: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code);
1255: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1256: 'SCHEDULED_MATERIAL_ID:' || l_Schedule_Mtl_Req_rec.SCHEDULED_MATERIAL_ID);
1257: END IF;

Line 1255: fnd_log.string ( G_DEBUG_STMT, l_debug_module,

1251: fnd_log.string ( G_DEBUG_STMT,l_debug_module,
1252: 'quantity : ' || l_Route_Mtl_Req_Tbl(j).quantity);
1253: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1254: 'uom : ' || l_Route_Mtl_Req_Tbl(j).uom_code);
1255: fnd_log.string ( G_DEBUG_STMT, l_debug_module,
1256: 'SCHEDULED_MATERIAL_ID:' || l_Schedule_Mtl_Req_rec.SCHEDULED_MATERIAL_ID);
1257: END IF;
1258: AHL_SCHEDULE_MATERIALS_PKG.UPDATE_ROW
1259: (

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;