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.AHL_FLEET_UTIL_HISTORY_PVT dependencies on FND_LOG

Line 4: ---------------------------- FND Logging Constants -----------------------------

1: PACKAGE BODY AHL_FLEET_UTIL_HISTORY_PVT AS
2: /* $Header: AHLVFUHB.pls 120.0.12020000.2 2012/12/10 13:37:52 shnatu noship $ */
3:
4: ---------------------------- FND Logging Constants -----------------------------
5: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
8: G_REQ_TYPE_FORECAST CONSTANT VARCHAR2(30) := 'FORECAST';

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

1: PACKAGE BODY AHL_FLEET_UTIL_HISTORY_PVT AS
2: /* $Header: AHLVFUHB.pls 120.0.12020000.2 2012/12/10 13:37:52 shnatu noship $ */
3:
4: ---------------------------- FND Logging Constants -----------------------------
5: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
8: G_REQ_TYPE_FORECAST CONSTANT VARCHAR2(30) := 'FORECAST';
9: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

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

2: /* $Header: AHLVFUHB.pls 120.0.12020000.2 2012/12/10 13:37:52 shnatu noship $ */
3:
4: ---------------------------- FND Logging Constants -----------------------------
5: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
8: G_REQ_TYPE_FORECAST CONSTANT VARCHAR2(30) := 'FORECAST';
9: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
10: G_IS_PM_INSTALLED CONSTANT VARCHAR2(1) := AHL_UTIL_PKG.IS_PM_INSTALLED;

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

3:
4: ---------------------------- FND Logging Constants -----------------------------
5: G_DEBUG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_DEBUG_PROC CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: G_DEBUG_STMT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
8: G_REQ_TYPE_FORECAST CONSTANT VARCHAR2(30) := 'FORECAST';
9: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
10: G_IS_PM_INSTALLED CONSTANT VARCHAR2(1) := AHL_UTIL_PKG.IS_PM_INSTALLED;
11:

Line 91: FND_LOG.STRING(G_DEBUG_STMT, l_debug_module, 'AHL_FLEET_UTILIZATION table refreshed and committed.');

87: DELETE FROM AHL_FLEET_UTILIZATION;
88: --COMMIT;
89: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
90: THEN
91: FND_LOG.STRING(G_DEBUG_STMT, l_debug_module, 'AHL_FLEET_UTILIZATION table refreshed and committed.');
92: END IF;
93:
94: END refresh_utilization_table;
95:

Line 283: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Start populate_utilization_history');

279: END IF;
280:
281: G_DEBUG_LINE_NUM := 1;
282: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
283: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Start populate_utilization_history');
284: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Input Parameter: p_sim_plan_id:' || p_sim_plan_id);
285: END IF;
286:
287: -- Initialize return status.

Line 284: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Input Parameter: p_sim_plan_id:' || p_sim_plan_id);

280:
281: G_DEBUG_LINE_NUM := 1;
282: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL) THEN
283: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Start populate_utilization_history');
284: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Input Parameter: p_sim_plan_id:' || p_sim_plan_id);
285: END IF;
286:
287: -- Initialize return status.
288: retcode := 0;

Line 306: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' passed sim plan Id is null, hence get the primary plan id');

302:
303: G_DEBUG_LINE_NUM := 10;
304: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
305: THEN
306: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' passed sim plan Id is null, hence get the primary plan id');
307: END IF;
308:
309: BEGIN
310: OPEN GetPrmPlanId;

Line 324: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' calculated l_sim_plan_id = ' || l_sim_plan_id);

320:
321: G_DEBUG_LINE_NUM := 20;
322: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
323: THEN
324: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' calculated l_sim_plan_id = ' || l_sim_plan_id);
325: END IF;
326: -- Calculate primaly plan id end
327:
328:

Line 340: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' Sorties counter data from setup UI not found.');

336: THEN
337: G_DEBUG_LINE_NUM := 30;
338: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
339: THEN
340: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' Sorties counter data from setup UI not found.');
341: END IF;
342: end if;
343: CLOSE GetSortiesCounter;
344: -- getting Sorties counter name ends

Line 348: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' l_sorties_counter_name = ' || l_sorties_counter_name

344: -- getting Sorties counter name ends
345: G_DEBUG_LINE_NUM := 40;
346: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
347: THEN
348: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' l_sorties_counter_name = ' || l_sorties_counter_name
349: || ' and l_sorties_counter_uom_code = ' || l_sorties_counter_uom_code);
350: END IF;
351:
352:

Line 362: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' l_fleet_header_id = ' || l_fleet_header_id

358: l_fleet_op_org_id := fleet_header_id_rec.operating_org_id;
359: G_DEBUG_LINE_NUM := 40;
360: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
361: THEN
362: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' l_fleet_header_id = ' || l_fleet_header_id
363: || ' and l_fleet_name = ' || l_fleet_name || ' and l_fleet_op_org_id = ' || l_fleet_op_org_id);
364: END IF;
365:
366:

Line 376: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' Min and max unit association could not be found for the fleet - ' || l_fleet_name);

372: THEN
373: G_DEBUG_LINE_NUM := 50;
374: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
375: THEN
376: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' Min and max unit association could not be found for the fleet - ' || l_fleet_name);
377: END IF;
378: end if;
379: CLOSE GetCalculationWindowActual;
380:

Line 392: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' l_window_start = ' || l_window_start

388:
389: G_DEBUG_LINE_NUM := 60;
390: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
391: THEN
392: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' l_window_start = ' || l_window_start
393: || ' and l_window_end = ' || l_window_end);
394: END IF;
395:
396: l_period_start := add_months(last_day(l_window_start) + 1, -1);

Line 409: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' current l_period_start = ' || l_period_start

405: LOOP
406: G_DEBUG_LINE_NUM := 70;
407: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
408: THEN
409: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' current l_period_start = ' || l_period_start
410: || ' and current l_period_end = ' || l_period_end);
411: END IF;
412:
413:

Line 424: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' fleet size = ' || l_fleet_size || ' for fleet - ' || l_fleet_name);

420: l_fleet_size := ROUND(l_fleet_size,2);
421: G_DEBUG_LINE_NUM := 80;
422: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
423: THEN
424: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' fleet size = ' || l_fleet_size || ' for fleet - ' || l_fleet_name);
425: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' Historical utilization calculation begins for fleet - ' || l_fleet_name);
426: END IF;
427:
428:

Line 425: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' Historical utilization calculation begins for fleet - ' || l_fleet_name);

421: G_DEBUG_LINE_NUM := 80;
422: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
423: THEN
424: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' fleet size = ' || l_fleet_size || ' for fleet - ' || l_fleet_name);
425: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' Historical utilization calculation begins for fleet - ' || l_fleet_name);
426: END IF;
427:
428:
429:

Line 457: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' l_daily_sorties_val for the period = ' || l_daily_sorties_val);

453: l_daily_sorties_val := l_all_unit_sorties_counter_val; --/(l_period_end - l_period_start);
454: G_DEBUG_LINE_NUM := 90;
455: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
456: THEN
457: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' l_daily_sorties_val for the period = ' || l_daily_sorties_val);
458: END IF;
459:
460:
461: -- Monthly Usage caluclation Starts

Line 470: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' current l_usage_counter_name = ' || l_usage_counter_name

466: l_usage_counter_uom_code := usage_counter_rec.parameter_value;
467: G_DEBUG_LINE_NUM := 100;
468: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
469: THEN
470: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' current l_usage_counter_name = ' || l_usage_counter_name
471: || ' and l_usage_counter_uom_code = ' || l_usage_counter_uom_code);
472: END IF;
473:
474: l_all_unit_counter_usage := 0;

Line 505: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' calculated daily usage for the fleet = ' || l_daily_usage_val);

501: l_daily_usage_val := ROUND(l_all_unit_counter_usage/(l_period_end - l_period_start + 1), 2);
502: G_DEBUG_LINE_NUM := 110;
503: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
504: THEN
505: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' calculated daily usage for the fleet = ' || l_daily_usage_val);
506: END IF;
507:
508: -- Insert a record to table for usage UOM for current period
509: util_forecasts_table(l_record_num).FLEET_UTILIZATION_ID := AHL_FLEET_UTILIZATION_S.nextval;

Line 565: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' Historical utilization calculation ends for fleet - ' || l_fleet_name);

561: END IF;
562: G_DEBUG_LINE_NUM := 120;
563: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
564: THEN
565: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' Historical utilization calculation ends for fleet - ' || l_fleet_name);
566: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' Forecasted utilization calculation begins for fleet - ' || l_fleet_name);
567: END IF;
568:
569: --forecasted utilization data calculation is to be updated for the fleet

Line 566: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' Forecasted utilization calculation begins for fleet - ' || l_fleet_name);

562: G_DEBUG_LINE_NUM := 120;
563: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
564: THEN
565: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' Historical utilization calculation ends for fleet - ' || l_fleet_name);
566: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' Forecasted utilization calculation begins for fleet - ' || l_fleet_name);
567: END IF;
568:
569: --forecasted utilization data calculation is to be updated for the fleet
570: -- Loop through each usage counter UOM from setup

Line 580: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' call Get_Forecast_Records procedure to get the forecatsed utilization data for fleet - ' || l_fleet_name);

576: -- Get the forecatsed records for the fleet
577: G_DEBUG_LINE_NUM := 130;
578: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
579: THEN
580: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' call Get_Forecast_Records procedure to get the forecatsed utilization data for fleet - ' || l_fleet_name);
581: END IF;
582: Get_Forecast_Records(l_fleet_header_id,l_sim_plan_id,l_usage_counter_uom_code,l_sorties_counter_uom_code,l_forecast_details_tbl);
583:
584: IF(l_forecast_details_tbl.count > 0) THEN

Line 635: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' Forecasted utilization calculation ends for fleet - ' || l_fleet_name);

631: -- usage counters traversal over
632: G_DEBUG_LINE_NUM := 140;
633: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
634: THEN
635: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' Forecasted utilization calculation ends for fleet - ' || l_fleet_name);
636: END IF;
637:
638: END LOOP;
639: -- Looping through all fleets over

Line 648: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'util_forecasts_table -- record - ' || l_run_no || ' - FLEET_UTILIZATION_ID = ' || util_forecasts_table(l_run_no).FLEET_UTILIZATION_ID);

644: LOOP
645: G_DEBUG_LINE_NUM := 150;
646: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
647: THEN
648: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'util_forecasts_table -- record - ' || l_run_no || ' - FLEET_UTILIZATION_ID = ' || util_forecasts_table(l_run_no).FLEET_UTILIZATION_ID);
649: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - PERIOD_START_DATE = ' || util_forecasts_table(l_run_no).PERIOD_START_DATE || ' - PERIOD_END_DATE = ' || util_forecasts_table(l_run_no).PERIOD_END_DATE);
650: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - UOM_CODE = ' || util_forecasts_table(l_run_no).UOM_CODE || ' - FLEET_SIZE = ' || util_forecasts_table(l_run_no).FLEET_SIZE);
651: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - ACTUAL_DAILY_USAGE = ' || util_forecasts_table(l_run_no).ACTUAL_DAILY_USAGE || ' - ACTUAL_DAILY_SORTIES = ' || util_forecasts_table(l_run_no).ACTUAL_DAILY_SORTIES);
652: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - FORECASTED_DAILY_USAGE = ' || util_forecasts_table(l_run_no).FORECASTED_DAILY_USAGE || ' - FORECASTED_DAILY_SORTIES = ' || util_forecasts_table(l_run_no).FORECASTED_DAILY_SORTIES);

Line 649: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - PERIOD_START_DATE = ' || util_forecasts_table(l_run_no).PERIOD_START_DATE || ' - PERIOD_END_DATE = ' || util_forecasts_table(l_run_no).PERIOD_END_DATE);

645: G_DEBUG_LINE_NUM := 150;
646: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
647: THEN
648: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'util_forecasts_table -- record - ' || l_run_no || ' - FLEET_UTILIZATION_ID = ' || util_forecasts_table(l_run_no).FLEET_UTILIZATION_ID);
649: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - PERIOD_START_DATE = ' || util_forecasts_table(l_run_no).PERIOD_START_DATE || ' - PERIOD_END_DATE = ' || util_forecasts_table(l_run_no).PERIOD_END_DATE);
650: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - UOM_CODE = ' || util_forecasts_table(l_run_no).UOM_CODE || ' - FLEET_SIZE = ' || util_forecasts_table(l_run_no).FLEET_SIZE);
651: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - ACTUAL_DAILY_USAGE = ' || util_forecasts_table(l_run_no).ACTUAL_DAILY_USAGE || ' - ACTUAL_DAILY_SORTIES = ' || util_forecasts_table(l_run_no).ACTUAL_DAILY_SORTIES);
652: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - FORECASTED_DAILY_USAGE = ' || util_forecasts_table(l_run_no).FORECASTED_DAILY_USAGE || ' - FORECASTED_DAILY_SORTIES = ' || util_forecasts_table(l_run_no).FORECASTED_DAILY_SORTIES);
653: END IF;

Line 650: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - UOM_CODE = ' || util_forecasts_table(l_run_no).UOM_CODE || ' - FLEET_SIZE = ' || util_forecasts_table(l_run_no).FLEET_SIZE);

646: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
647: THEN
648: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'util_forecasts_table -- record - ' || l_run_no || ' - FLEET_UTILIZATION_ID = ' || util_forecasts_table(l_run_no).FLEET_UTILIZATION_ID);
649: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - PERIOD_START_DATE = ' || util_forecasts_table(l_run_no).PERIOD_START_DATE || ' - PERIOD_END_DATE = ' || util_forecasts_table(l_run_no).PERIOD_END_DATE);
650: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - UOM_CODE = ' || util_forecasts_table(l_run_no).UOM_CODE || ' - FLEET_SIZE = ' || util_forecasts_table(l_run_no).FLEET_SIZE);
651: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - ACTUAL_DAILY_USAGE = ' || util_forecasts_table(l_run_no).ACTUAL_DAILY_USAGE || ' - ACTUAL_DAILY_SORTIES = ' || util_forecasts_table(l_run_no).ACTUAL_DAILY_SORTIES);
652: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - FORECASTED_DAILY_USAGE = ' || util_forecasts_table(l_run_no).FORECASTED_DAILY_USAGE || ' - FORECASTED_DAILY_SORTIES = ' || util_forecasts_table(l_run_no).FORECASTED_DAILY_SORTIES);
653: END IF;
654:

Line 651: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - ACTUAL_DAILY_USAGE = ' || util_forecasts_table(l_run_no).ACTUAL_DAILY_USAGE || ' - ACTUAL_DAILY_SORTIES = ' || util_forecasts_table(l_run_no).ACTUAL_DAILY_SORTIES);

647: THEN
648: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'util_forecasts_table -- record - ' || l_run_no || ' - FLEET_UTILIZATION_ID = ' || util_forecasts_table(l_run_no).FLEET_UTILIZATION_ID);
649: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - PERIOD_START_DATE = ' || util_forecasts_table(l_run_no).PERIOD_START_DATE || ' - PERIOD_END_DATE = ' || util_forecasts_table(l_run_no).PERIOD_END_DATE);
650: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - UOM_CODE = ' || util_forecasts_table(l_run_no).UOM_CODE || ' - FLEET_SIZE = ' || util_forecasts_table(l_run_no).FLEET_SIZE);
651: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - ACTUAL_DAILY_USAGE = ' || util_forecasts_table(l_run_no).ACTUAL_DAILY_USAGE || ' - ACTUAL_DAILY_SORTIES = ' || util_forecasts_table(l_run_no).ACTUAL_DAILY_SORTIES);
652: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - FORECASTED_DAILY_USAGE = ' || util_forecasts_table(l_run_no).FORECASTED_DAILY_USAGE || ' - FORECASTED_DAILY_SORTIES = ' || util_forecasts_table(l_run_no).FORECASTED_DAILY_SORTIES);
653: END IF;
654:
655: l_run_no := util_forecasts_table.NEXT(l_run_no); -- get index of next element

Line 652: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - FORECASTED_DAILY_USAGE = ' || util_forecasts_table(l_run_no).FORECASTED_DAILY_USAGE || ' - FORECASTED_DAILY_SORTIES = ' || util_forecasts_table(l_run_no).FORECASTED_DAILY_SORTIES);

648: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'util_forecasts_table -- record - ' || l_run_no || ' - FLEET_UTILIZATION_ID = ' || util_forecasts_table(l_run_no).FLEET_UTILIZATION_ID);
649: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - PERIOD_START_DATE = ' || util_forecasts_table(l_run_no).PERIOD_START_DATE || ' - PERIOD_END_DATE = ' || util_forecasts_table(l_run_no).PERIOD_END_DATE);
650: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - UOM_CODE = ' || util_forecasts_table(l_run_no).UOM_CODE || ' - FLEET_SIZE = ' || util_forecasts_table(l_run_no).FLEET_SIZE);
651: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - ACTUAL_DAILY_USAGE = ' || util_forecasts_table(l_run_no).ACTUAL_DAILY_USAGE || ' - ACTUAL_DAILY_SORTIES = ' || util_forecasts_table(l_run_no).ACTUAL_DAILY_SORTIES);
652: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' - FORECASTED_DAILY_USAGE = ' || util_forecasts_table(l_run_no).FORECASTED_DAILY_USAGE || ' - FORECASTED_DAILY_SORTIES = ' || util_forecasts_table(l_run_no).FORECASTED_DAILY_SORTIES);
653: END IF;
654:
655: l_run_no := util_forecasts_table.NEXT(l_run_no); -- get index of next element
656: END LOOP;

Line 662: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' utilization calculation over for all fleets. insertion of data into AHL_FLEET_UTILIZATION begins');

658:
659: G_DEBUG_LINE_NUM := 160;
660: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
661: THEN
662: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' utilization calculation over for all fleets. insertion of data into AHL_FLEET_UTILIZATION begins');
663: END IF;
664:
665: -- Isert bulk data into DB table
666: FORALL x IN util_forecasts_table.FIRST..util_forecasts_table.LAST

Line 750: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' insertion of data into AHL_FLEET_UTILIZATION ends');

746:
747: G_DEBUG_LINE_NUM := 170;
748: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
749: THEN
750: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' insertion of data into AHL_FLEET_UTILIZATION ends');
751: END IF;
752:
753: IF (util_forecasts_table IS NOT NULL AND util_forecasts_table.COUNT > 0)
754: THEN

Line 762: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' util_forecasts_table deleted');

758:
759: G_DEBUG_LINE_NUM := 180;
760: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
761: THEN
762: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' util_forecasts_table deleted');
763: END IF;
764:
765: -- Commit the data to table
766: COMMIT;

Line 774: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' data committed');

770:
771: G_DEBUG_LINE_NUM := 180;
772: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
773: THEN
774: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' data committed');
775: END IF;
776:
777: EXCEPTION
778: WHEN FND_API.G_EXC_ERROR

Line 789: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'Error in procedure populate_fleet_utilization procedure');

785: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
786: THEN
787: g_err_msg := substr(SQLERRM, 1, 3900);
788: g_err_code := SQLCODE;
789: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'Error in procedure populate_fleet_utilization procedure');
790: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error code is '|| g_err_code);
791: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error message is '|| g_err_msg);
792: fnd_file.put_line(fnd_file.log, 'AHL_FLEET_UTIL_HISTORY_PVT.populate_fleet_utilization Threw unexpected error with error code - '
793: || g_err_code || ' and error message as - ' || g_err_msg || ' and errbuf - ' || errbuf);

Line 790: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error code is '|| g_err_code);

786: THEN
787: g_err_msg := substr(SQLERRM, 1, 3900);
788: g_err_code := SQLCODE;
789: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'Error in procedure populate_fleet_utilization procedure');
790: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error code is '|| g_err_code);
791: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error message is '|| g_err_msg);
792: fnd_file.put_line(fnd_file.log, 'AHL_FLEET_UTIL_HISTORY_PVT.populate_fleet_utilization Threw unexpected error with error code - '
793: || g_err_code || ' and error message as - ' || g_err_msg || ' and errbuf - ' || errbuf);
794: END IF;

Line 791: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error message is '|| g_err_msg);

787: g_err_msg := substr(SQLERRM, 1, 3900);
788: g_err_code := SQLCODE;
789: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'Error in procedure populate_fleet_utilization procedure');
790: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error code is '|| g_err_code);
791: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error message is '|| g_err_msg);
792: fnd_file.put_line(fnd_file.log, 'AHL_FLEET_UTIL_HISTORY_PVT.populate_fleet_utilization Threw unexpected error with error code - '
793: || g_err_code || ' and error message as - ' || g_err_msg || ' and errbuf - ' || errbuf);
794: END IF;
795:

Line 807: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'Error in procedure populate_fleet_utilization procedure');

803: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
804: THEN
805: g_err_msg := substr(SQLERRM, 1, 3900);
806: g_err_code := SQLCODE;
807: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'Error in procedure populate_fleet_utilization procedure');
808: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error code is '|| g_err_code);
809: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error message is '|| g_err_msg);
810: fnd_file.put_line(fnd_file.log, 'AHL_FLEET_UTIL_HISTORY_PVT.populate_fleet_utilization Threw unexpected error with error code - '
811: || g_err_code || ' and error message as - ' || g_err_msg || ' and errbuf - ' || errbuf);

Line 808: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error code is '|| g_err_code);

804: THEN
805: g_err_msg := substr(SQLERRM, 1, 3900);
806: g_err_code := SQLCODE;
807: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'Error in procedure populate_fleet_utilization procedure');
808: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error code is '|| g_err_code);
809: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error message is '|| g_err_msg);
810: fnd_file.put_line(fnd_file.log, 'AHL_FLEET_UTIL_HISTORY_PVT.populate_fleet_utilization Threw unexpected error with error code - '
811: || g_err_code || ' and error message as - ' || g_err_msg || ' and errbuf - ' || errbuf);
812: END IF;

Line 809: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error message is '|| g_err_msg);

805: g_err_msg := substr(SQLERRM, 1, 3900);
806: g_err_code := SQLCODE;
807: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'Error in procedure populate_fleet_utilization procedure');
808: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error code is '|| g_err_code);
809: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error message is '|| g_err_msg);
810: fnd_file.put_line(fnd_file.log, 'AHL_FLEET_UTIL_HISTORY_PVT.populate_fleet_utilization Threw unexpected error with error code - '
811: || g_err_code || ' and error message as - ' || g_err_msg || ' and errbuf - ' || errbuf);
812: END IF;
813:

Line 825: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'Error in procedure populate_fleet_utilization procedure');

821: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
822: THEN
823: g_err_msg := substr(SQLERRM, 1, 3900);
824: g_err_code := SQLCODE;
825: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'Error in procedure populate_fleet_utilization procedure');
826: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error code is '|| g_err_code);
827: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error message is '|| g_err_msg);
828: fnd_file.put_line(fnd_file.log, 'AHL_FLEET_UTIL_HISTORY_PVT.populate_fleet_utilization Threw unexpected error with error code - '
829: || g_err_code || ' and error message as - ' || g_err_msg || ' and errbuf - ' || errbuf);

Line 826: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error code is '|| g_err_code);

822: THEN
823: g_err_msg := substr(SQLERRM, 1, 3900);
824: g_err_code := SQLCODE;
825: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'Error in procedure populate_fleet_utilization procedure');
826: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error code is '|| g_err_code);
827: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error message is '|| g_err_msg);
828: fnd_file.put_line(fnd_file.log, 'AHL_FLEET_UTIL_HISTORY_PVT.populate_fleet_utilization Threw unexpected error with error code - '
829: || g_err_code || ' and error message as - ' || g_err_msg || ' and errbuf - ' || errbuf);
830: END IF;

Line 827: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error message is '|| g_err_msg);

823: g_err_msg := substr(SQLERRM, 1, 3900);
824: g_err_code := SQLCODE;
825: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'Error in procedure populate_fleet_utilization procedure');
826: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error code is '|| g_err_code);
827: fnd_log.string (G_DEBUG_STMT, l_debug_module, 'error message is '|| g_err_msg);
828: fnd_file.put_line(fnd_file.log, 'AHL_FLEET_UTIL_HISTORY_PVT.populate_fleet_utilization Threw unexpected error with error code - '
829: || g_err_code || ' and error message as - ' || g_err_msg || ' and errbuf - ' || errbuf);
830: END IF;
831:

Line 954: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Start Get_Forecast_Records');

950:
951: G_DEBUG_LINE_NUM := 1;
952: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
953: THEN
954: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Start Get_Forecast_Records');
955: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Input Parameter: p_fleet_header_id:' || p_fleet_header_id || ', p_simulation_plan_id:' || p_simulation_plan_id
956: || ', p_usage_counter_uom_code:' || p_sorties_counter_uom_code || ', p_sorties_counter_uom_code:' || p_usage_counter_uom_code);
957: END IF;
958:

Line 955: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Input Parameter: p_fleet_header_id:' || p_fleet_header_id || ', p_simulation_plan_id:' || p_simulation_plan_id

951: G_DEBUG_LINE_NUM := 1;
952: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
953: THEN
954: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Start Get_Forecast_Records');
955: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Input Parameter: p_fleet_header_id:' || p_fleet_header_id || ', p_simulation_plan_id:' || p_simulation_plan_id
956: || ', p_usage_counter_uom_code:' || p_sorties_counter_uom_code || ', p_sorties_counter_uom_code:' || p_usage_counter_uom_code);
957: END IF;
958:
959: -- get the forecast data from the setup table for the fleet and UOM code

Line 971: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' current l_forecast_start = ' || l_forecast_start || ', l_forecast_end = ' || l_forecast_end

967: end if;
968: G_DEBUG_LINE_NUM := 10;
969: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
970: THEN
971: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' current l_forecast_start = ' || l_forecast_start || ', l_forecast_end = ' || l_forecast_end
972: || ', l_daily_usage:' || l_daily_usage);
973: END IF;
974:
975: -- get the fleet size for the period

Line 983: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' calculated l_fleet_size = ' || l_fleet_size || ' for p_fleet_header_id - ' || p_fleet_header_id);

979: l_fleet_size := ROUND(l_fleet_size, 2);
980: G_DEBUG_LINE_NUM := 20;
981: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
982: THEN
983: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' calculated l_fleet_size = ' || l_fleet_size || ' for p_fleet_header_id - ' || p_fleet_header_id);
984: END IF;
985: CLOSE GetFleetSize;
986:
987: if(l_fleet_size = 0)

Line 1002: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' forecasted l_sorties_val = ' || l_sorties_val);

998: l_sorties_val := ROUND((l_sorties_val * l_fleet_size * 30), 2);
999: G_DEBUG_LINE_NUM := 30;
1000: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
1001: THEN
1002: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' forecasted l_sorties_val = ' || l_sorties_val);
1003: END IF;
1004:
1005: -- calculate daily usage considering all asociated units
1006: /*FOR l_unit_config_rec IN GetAssociatedUnits(p_fleet_header_id,p_simulation_plan_id, l_forecast_start, l_forecast_end)

Line 1024: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' forecasted l_daily_usage_avg = ' || l_daily_usage_avg);

1020: l_daily_usage_avg := ROUND((l_daily_usage * l_fleet_size), 2);
1021: G_DEBUG_LINE_NUM := 40;
1022: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
1023: THEN
1024: fnd_log.string (G_DEBUG_STMT, l_debug_module, ' forecasted l_daily_usage_avg = ' || l_daily_usage_avg);
1025: END IF; */
1026:
1027: -- Populate table for the calculated data.
1028: p_forecast_details_tbl(l_index).uom_code := p_usage_counter_uom_code;

Line 1064: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Start Get_Forecasting_Window_Date');

1060:
1061: G_DEBUG_LINE_NUM := 1;
1062: IF (G_DEBUG_PROC >= G_DEBUG_LEVEL)
1063: THEN
1064: fnd_log.string (G_DEBUG_PROC, l_debug_module, 'Start Get_Forecasting_Window_Date');
1065: END IF;
1066:
1067: BEGIN
1068: l_date_uom := FND_PROFILE.VALUE('AHL_UMP_MAX_PLANNING_UOM');

Line 1094: fnd_log.string(G_DEBUG_STMT, l_debug_module, 'last day of window' || l_last_day_of_window || ', profile uom:' || l_date_uom

1090:
1091: G_DEBUG_LINE_NUM := 10;
1092: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
1093: THEN
1094: fnd_log.string(G_DEBUG_STMT, l_debug_module, 'last day of window' || l_last_day_of_window || ', profile uom:' || l_date_uom
1095: || ', profile value:' || l_value);
1096: END IF;
1097:
1098: -- return date.