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_RA_ANALYSER_PVT dependencies on FND_LOG

Line 369: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

365: l_dummy_identifier NUMBER;
366:
367: BEGIN
368:
369: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
370: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.begin','At the start of PLSQL procedure');
371: END IF;
372:
373: IF (p_concurrent_flag = 'Y') THEN

Line 370: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.begin','At the start of PLSQL procedure');

366:
367: BEGIN
368:
369: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
370: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.begin','At the start of PLSQL procedure');
371: END IF;
372:
373: IF (p_concurrent_flag = 'Y') THEN
374: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- START ----');

Line 392: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

388: END IF;
389:
390: x_return_status := FND_API.G_RET_STS_SUCCESS;
391:
392: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
393: fnd_log.string(fnd_log.level_statement,l_full_name,'RA -- PKG -- PROCESS_RA_DATA -------BEGIN-----------');
394: fnd_log.string(fnd_log.level_statement,l_full_name,'RA -- PKG -- PROCESS_RA_DATA -------p_start_date-----------' || p_start_date);
395: fnd_log.string(fnd_log.level_statement,l_full_name,'RA -- PKG -- PROCESS_RA_DATA -------p_end_date-----------' || p_end_date);
396: END IF;

Line 393: fnd_log.string(fnd_log.level_statement,l_full_name,'RA -- PKG -- PROCESS_RA_DATA -------BEGIN-----------');

389:
390: x_return_status := FND_API.G_RET_STS_SUCCESS;
391:
392: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
393: fnd_log.string(fnd_log.level_statement,l_full_name,'RA -- PKG -- PROCESS_RA_DATA -------BEGIN-----------');
394: fnd_log.string(fnd_log.level_statement,l_full_name,'RA -- PKG -- PROCESS_RA_DATA -------p_start_date-----------' || p_start_date);
395: fnd_log.string(fnd_log.level_statement,l_full_name,'RA -- PKG -- PROCESS_RA_DATA -------p_end_date-----------' || p_end_date);
396: END IF;
397:

Line 394: fnd_log.string(fnd_log.level_statement,l_full_name,'RA -- PKG -- PROCESS_RA_DATA -------p_start_date-----------' || p_start_date);

390: x_return_status := FND_API.G_RET_STS_SUCCESS;
391:
392: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
393: fnd_log.string(fnd_log.level_statement,l_full_name,'RA -- PKG -- PROCESS_RA_DATA -------BEGIN-----------');
394: fnd_log.string(fnd_log.level_statement,l_full_name,'RA -- PKG -- PROCESS_RA_DATA -------p_start_date-----------' || p_start_date);
395: fnd_log.string(fnd_log.level_statement,l_full_name,'RA -- PKG -- PROCESS_RA_DATA -------p_end_date-----------' || p_end_date);
396: END IF;
397:
398: IF (p_concurrent_flag = 'Y') THEN

Line 395: fnd_log.string(fnd_log.level_statement,l_full_name,'RA -- PKG -- PROCESS_RA_DATA -------p_end_date-----------' || p_end_date);

391:
392: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
393: fnd_log.string(fnd_log.level_statement,l_full_name,'RA -- PKG -- PROCESS_RA_DATA -------BEGIN-----------');
394: fnd_log.string(fnd_log.level_statement,l_full_name,'RA -- PKG -- PROCESS_RA_DATA -------p_start_date-----------' || p_start_date);
395: fnd_log.string(fnd_log.level_statement,l_full_name,'RA -- PKG -- PROCESS_RA_DATA -------p_end_date-----------' || p_end_date);
396: END IF;
397:
398: IF (p_concurrent_flag = 'Y') THEN
399: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Validating Start / End Date ----');

Line 413: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

409: OR (p_start_date < trunc(sysdate))
410: OR (p_end_date < trunc(sysdate))
411: ) THEN
412:
413: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
414: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed --');
415: fnd_log.string(fnd_log.level_statement,l_full_name,'-- p_start_date -- '||p_start_date);
416: fnd_log.string(fnd_log.level_statement,l_full_name,'-- p_end_date -- '||p_end_date);
417: END IF;

Line 414: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed --');

410: OR (p_end_date < trunc(sysdate))
411: ) THEN
412:
413: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
414: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed --');
415: fnd_log.string(fnd_log.level_statement,l_full_name,'-- p_start_date -- '||p_start_date);
416: fnd_log.string(fnd_log.level_statement,l_full_name,'-- p_end_date -- '||p_end_date);
417: END IF;
418: IF (p_concurrent_flag = 'Y') THEN

Line 415: fnd_log.string(fnd_log.level_statement,l_full_name,'-- p_start_date -- '||p_start_date);

411: ) THEN
412:
413: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
414: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed --');
415: fnd_log.string(fnd_log.level_statement,l_full_name,'-- p_start_date -- '||p_start_date);
416: fnd_log.string(fnd_log.level_statement,l_full_name,'-- p_end_date -- '||p_end_date);
417: END IF;
418: IF (p_concurrent_flag = 'Y') THEN
419: fnd_file.put_line(fnd_file.log, '-- Invalid Param Passed -- Dates Validation Failed');

Line 416: fnd_log.string(fnd_log.level_statement,l_full_name,'-- p_end_date -- '||p_end_date);

412:
413: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
414: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed --');
415: fnd_log.string(fnd_log.level_statement,l_full_name,'-- p_start_date -- '||p_start_date);
416: fnd_log.string(fnd_log.level_statement,l_full_name,'-- p_end_date -- '||p_end_date);
417: END IF;
418: IF (p_concurrent_flag = 'Y') THEN
419: fnd_file.put_line(fnd_file.log, '-- Invalid Param Passed -- Dates Validation Failed');
420: END IF;

Line 433: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

429: END IF;
430:
431: -- Fetch Counter Details Data from Setup
432: OPEN c_setup_counter_data;
433: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
434: fnd_log.string(fnd_log.level_statement,l_full_name,' Bulk Fetching Counter Details Data from Setup');
435: END IF;
436: IF (p_concurrent_flag = 'Y') THEN
437: fnd_file.put_line(fnd_file.log, '-- Bulk Fetching Counter Details Data from Setup --');

Line 434: fnd_log.string(fnd_log.level_statement,l_full_name,' Bulk Fetching Counter Details Data from Setup');

430:
431: -- Fetch Counter Details Data from Setup
432: OPEN c_setup_counter_data;
433: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
434: fnd_log.string(fnd_log.level_statement,l_full_name,' Bulk Fetching Counter Details Data from Setup');
435: END IF;
436: IF (p_concurrent_flag = 'Y') THEN
437: fnd_file.put_line(fnd_file.log, '-- Bulk Fetching Counter Details Data from Setup --');
438: END IF;

Line 447: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

443: l_tmp_over_ctr_id_tbl,
444: l_tmp_over_start_date_tbl,
445: l_tmp_over_end_date_tbl;
446: IF l_tmp_new_ctr_id_tbl.COUNT = 0 THEN
447: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
448: fnd_log.string(fnd_log.level_statement,l_full_name,' No Setup Data Found for Counters');
449: END IF;
450: IF (p_concurrent_flag = 'Y') THEN
451: fnd_file.put_line(fnd_file.log, '-- No Setup Data Found for Counters --');

Line 448: fnd_log.string(fnd_log.level_statement,l_full_name,' No Setup Data Found for Counters');

444: l_tmp_over_start_date_tbl,
445: l_tmp_over_end_date_tbl;
446: IF l_tmp_new_ctr_id_tbl.COUNT = 0 THEN
447: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
448: fnd_log.string(fnd_log.level_statement,l_full_name,' No Setup Data Found for Counters');
449: END IF;
450: IF (p_concurrent_flag = 'Y') THEN
451: fnd_file.put_line(fnd_file.log, '-- No Setup Data Found for Counters --');
452: END IF;

Line 459: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

455:
456: --Filtering Counter Setup Data based on Active Dates
457: IF l_tmp_new_ctr_id_tbl.COUNT > 0 THEN
458:
459: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
460: fnd_log.string(fnd_log.level_statement,l_full_name,'Filtering Counter Setup Data based on Active Dates - '||l_tmp_new_ctr_id_tbl.COUNT);
461: fnd_log.string(fnd_log.level_statement,l_full_name,'Analyser Start Date - '||p_start_date);
462: fnd_log.string(fnd_log.level_statement,l_full_name,'Analyser End Date - '||p_end_date);
463: END IF;

Line 460: fnd_log.string(fnd_log.level_statement,l_full_name,'Filtering Counter Setup Data based on Active Dates - '||l_tmp_new_ctr_id_tbl.COUNT);

456: --Filtering Counter Setup Data based on Active Dates
457: IF l_tmp_new_ctr_id_tbl.COUNT > 0 THEN
458:
459: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
460: fnd_log.string(fnd_log.level_statement,l_full_name,'Filtering Counter Setup Data based on Active Dates - '||l_tmp_new_ctr_id_tbl.COUNT);
461: fnd_log.string(fnd_log.level_statement,l_full_name,'Analyser Start Date - '||p_start_date);
462: fnd_log.string(fnd_log.level_statement,l_full_name,'Analyser End Date - '||p_end_date);
463: END IF;
464:

Line 461: fnd_log.string(fnd_log.level_statement,l_full_name,'Analyser Start Date - '||p_start_date);

457: IF l_tmp_new_ctr_id_tbl.COUNT > 0 THEN
458:
459: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
460: fnd_log.string(fnd_log.level_statement,l_full_name,'Filtering Counter Setup Data based on Active Dates - '||l_tmp_new_ctr_id_tbl.COUNT);
461: fnd_log.string(fnd_log.level_statement,l_full_name,'Analyser Start Date - '||p_start_date);
462: fnd_log.string(fnd_log.level_statement,l_full_name,'Analyser End Date - '||p_end_date);
463: END IF;
464:
465: IF (p_concurrent_flag = 'Y') THEN

Line 462: fnd_log.string(fnd_log.level_statement,l_full_name,'Analyser End Date - '||p_end_date);

458:
459: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
460: fnd_log.string(fnd_log.level_statement,l_full_name,'Filtering Counter Setup Data based on Active Dates - '||l_tmp_new_ctr_id_tbl.COUNT);
461: fnd_log.string(fnd_log.level_statement,l_full_name,'Analyser Start Date - '||p_start_date);
462: fnd_log.string(fnd_log.level_statement,l_full_name,'Analyser End Date - '||p_end_date);
463: END IF;
464:
465: IF (p_concurrent_flag = 'Y') THEN
466: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Validating Active Dates of Counter Setup Data ----');

Line 471: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

467: END IF;
468:
469: FOR i IN l_tmp_new_ctr_id_tbl.FIRST .. l_tmp_new_ctr_id_tbl.LAST LOOP -- loop for Setup Cunters fetched
470:
471: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
472: fnd_log.string(fnd_log.level_statement,l_full_name,'Looping for (i) - '||i);
473: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_ctr_id_tbl - '||l_tmp_new_ctr_id_tbl(i));
474: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_start_date_tbl - '||l_tmp_new_start_date_tbl(i));
475: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_end_date_tbl - '||l_tmp_new_end_date_tbl(i));

Line 472: fnd_log.string(fnd_log.level_statement,l_full_name,'Looping for (i) - '||i);

468:
469: FOR i IN l_tmp_new_ctr_id_tbl.FIRST .. l_tmp_new_ctr_id_tbl.LAST LOOP -- loop for Setup Cunters fetched
470:
471: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
472: fnd_log.string(fnd_log.level_statement,l_full_name,'Looping for (i) - '||i);
473: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_ctr_id_tbl - '||l_tmp_new_ctr_id_tbl(i));
474: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_start_date_tbl - '||l_tmp_new_start_date_tbl(i));
475: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_end_date_tbl - '||l_tmp_new_end_date_tbl(i));
476: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_over_ctr_id_tbl - '||l_tmp_over_ctr_id_tbl(i));

Line 473: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_ctr_id_tbl - '||l_tmp_new_ctr_id_tbl(i));

469: FOR i IN l_tmp_new_ctr_id_tbl.FIRST .. l_tmp_new_ctr_id_tbl.LAST LOOP -- loop for Setup Cunters fetched
470:
471: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
472: fnd_log.string(fnd_log.level_statement,l_full_name,'Looping for (i) - '||i);
473: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_ctr_id_tbl - '||l_tmp_new_ctr_id_tbl(i));
474: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_start_date_tbl - '||l_tmp_new_start_date_tbl(i));
475: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_end_date_tbl - '||l_tmp_new_end_date_tbl(i));
476: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_over_ctr_id_tbl - '||l_tmp_over_ctr_id_tbl(i));
477: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_over_start_date_tbl - '||l_tmp_over_start_date_tbl(i));

Line 474: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_start_date_tbl - '||l_tmp_new_start_date_tbl(i));

470:
471: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
472: fnd_log.string(fnd_log.level_statement,l_full_name,'Looping for (i) - '||i);
473: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_ctr_id_tbl - '||l_tmp_new_ctr_id_tbl(i));
474: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_start_date_tbl - '||l_tmp_new_start_date_tbl(i));
475: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_end_date_tbl - '||l_tmp_new_end_date_tbl(i));
476: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_over_ctr_id_tbl - '||l_tmp_over_ctr_id_tbl(i));
477: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_over_start_date_tbl - '||l_tmp_over_start_date_tbl(i));
478: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_over_end_date_tbl - '||l_tmp_over_end_date_tbl(i));

Line 475: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_end_date_tbl - '||l_tmp_new_end_date_tbl(i));

471: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
472: fnd_log.string(fnd_log.level_statement,l_full_name,'Looping for (i) - '||i);
473: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_ctr_id_tbl - '||l_tmp_new_ctr_id_tbl(i));
474: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_start_date_tbl - '||l_tmp_new_start_date_tbl(i));
475: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_end_date_tbl - '||l_tmp_new_end_date_tbl(i));
476: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_over_ctr_id_tbl - '||l_tmp_over_ctr_id_tbl(i));
477: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_over_start_date_tbl - '||l_tmp_over_start_date_tbl(i));
478: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_over_end_date_tbl - '||l_tmp_over_end_date_tbl(i));
479: END IF;

Line 476: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_over_ctr_id_tbl - '||l_tmp_over_ctr_id_tbl(i));

472: fnd_log.string(fnd_log.level_statement,l_full_name,'Looping for (i) - '||i);
473: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_ctr_id_tbl - '||l_tmp_new_ctr_id_tbl(i));
474: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_start_date_tbl - '||l_tmp_new_start_date_tbl(i));
475: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_end_date_tbl - '||l_tmp_new_end_date_tbl(i));
476: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_over_ctr_id_tbl - '||l_tmp_over_ctr_id_tbl(i));
477: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_over_start_date_tbl - '||l_tmp_over_start_date_tbl(i));
478: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_over_end_date_tbl - '||l_tmp_over_end_date_tbl(i));
479: END IF;
480:

Line 477: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_over_start_date_tbl - '||l_tmp_over_start_date_tbl(i));

473: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_ctr_id_tbl - '||l_tmp_new_ctr_id_tbl(i));
474: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_start_date_tbl - '||l_tmp_new_start_date_tbl(i));
475: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_end_date_tbl - '||l_tmp_new_end_date_tbl(i));
476: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_over_ctr_id_tbl - '||l_tmp_over_ctr_id_tbl(i));
477: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_over_start_date_tbl - '||l_tmp_over_start_date_tbl(i));
478: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_over_end_date_tbl - '||l_tmp_over_end_date_tbl(i));
479: END IF;
480:
481: IF ((trunc(nvl(l_tmp_new_start_date_tbl(i),p_start_date)) <= trunc(p_start_date)) AND

Line 478: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_over_end_date_tbl - '||l_tmp_over_end_date_tbl(i));

474: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_start_date_tbl - '||l_tmp_new_start_date_tbl(i));
475: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_new_end_date_tbl - '||l_tmp_new_end_date_tbl(i));
476: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_over_ctr_id_tbl - '||l_tmp_over_ctr_id_tbl(i));
477: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_over_start_date_tbl - '||l_tmp_over_start_date_tbl(i));
478: fnd_log.string(fnd_log.level_statement,l_full_name,'l_tmp_over_end_date_tbl - '||l_tmp_over_end_date_tbl(i));
479: END IF;
480:
481: IF ((trunc(nvl(l_tmp_new_start_date_tbl(i),p_start_date)) <= trunc(p_start_date)) AND
482: (trunc(nvl(l_tmp_new_end_date_tbl(i),p_end_date + 1)) > trunc(p_end_date))) THEN

Line 483: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

479: END IF;
480:
481: IF ((trunc(nvl(l_tmp_new_start_date_tbl(i),p_start_date)) <= trunc(p_start_date)) AND
482: (trunc(nvl(l_tmp_new_end_date_tbl(i),p_end_date + 1)) > trunc(p_end_date))) THEN
483: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
484: fnd_log.string(fnd_log.level_statement,l_full_name,'Including Since New - l_since_new_ctr_id_tbl -'||i||'-'||l_tmp_new_ctr_id_tbl(i));
485: END IF;
486: l_since_new_ctr_id_tbl(i) := l_tmp_new_ctr_id_tbl(i);
487: ELSE

Line 484: fnd_log.string(fnd_log.level_statement,l_full_name,'Including Since New - l_since_new_ctr_id_tbl -'||i||'-'||l_tmp_new_ctr_id_tbl(i));

480:
481: IF ((trunc(nvl(l_tmp_new_start_date_tbl(i),p_start_date)) <= trunc(p_start_date)) AND
482: (trunc(nvl(l_tmp_new_end_date_tbl(i),p_end_date + 1)) > trunc(p_end_date))) THEN
483: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
484: fnd_log.string(fnd_log.level_statement,l_full_name,'Including Since New - l_since_new_ctr_id_tbl -'||i||'-'||l_tmp_new_ctr_id_tbl(i));
485: END IF;
486: l_since_new_ctr_id_tbl(i) := l_tmp_new_ctr_id_tbl(i);
487: ELSE
488: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 488: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

484: fnd_log.string(fnd_log.level_statement,l_full_name,'Including Since New - l_since_new_ctr_id_tbl -'||i||'-'||l_tmp_new_ctr_id_tbl(i));
485: END IF;
486: l_since_new_ctr_id_tbl(i) := l_tmp_new_ctr_id_tbl(i);
487: ELSE
488: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
489: fnd_log.string(fnd_log.level_statement,l_full_name,'Omiting Since New - l_tmp_new_ctr_id_tbl -'||i||'-'||l_tmp_new_ctr_id_tbl(i));
490: END IF;
491: l_since_new_ctr_id_tbl(i) := null;
492: END IF;

Line 489: fnd_log.string(fnd_log.level_statement,l_full_name,'Omiting Since New - l_tmp_new_ctr_id_tbl -'||i||'-'||l_tmp_new_ctr_id_tbl(i));

485: END IF;
486: l_since_new_ctr_id_tbl(i) := l_tmp_new_ctr_id_tbl(i);
487: ELSE
488: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
489: fnd_log.string(fnd_log.level_statement,l_full_name,'Omiting Since New - l_tmp_new_ctr_id_tbl -'||i||'-'||l_tmp_new_ctr_id_tbl(i));
490: END IF;
491: l_since_new_ctr_id_tbl(i) := null;
492: END IF;
493:

Line 497: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

493:
494: IF (l_tmp_over_ctr_id_tbl(i) IS NOT NULL) THEN
495: IF ((trunc(nvl(l_tmp_over_start_date_tbl(i),p_start_date)) <= trunc(p_start_date)) AND
496: (trunc(nvl(l_tmp_over_end_date_tbl(i),p_end_date + 1)) > trunc(p_end_date))) THEN
497: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
498: fnd_log.string(fnd_log.level_statement,l_full_name,'Including Since Overhaul - l_since_oh_ctr_id_tbl -'||i||'-'||l_tmp_over_ctr_id_tbl(i));
499: END IF;
500: l_since_oh_ctr_id_tbl(i) := l_tmp_over_ctr_id_tbl(i);
501: ELSE

Line 498: fnd_log.string(fnd_log.level_statement,l_full_name,'Including Since Overhaul - l_since_oh_ctr_id_tbl -'||i||'-'||l_tmp_over_ctr_id_tbl(i));

494: IF (l_tmp_over_ctr_id_tbl(i) IS NOT NULL) THEN
495: IF ((trunc(nvl(l_tmp_over_start_date_tbl(i),p_start_date)) <= trunc(p_start_date)) AND
496: (trunc(nvl(l_tmp_over_end_date_tbl(i),p_end_date + 1)) > trunc(p_end_date))) THEN
497: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
498: fnd_log.string(fnd_log.level_statement,l_full_name,'Including Since Overhaul - l_since_oh_ctr_id_tbl -'||i||'-'||l_tmp_over_ctr_id_tbl(i));
499: END IF;
500: l_since_oh_ctr_id_tbl(i) := l_tmp_over_ctr_id_tbl(i);
501: ELSE
502: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 502: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

498: fnd_log.string(fnd_log.level_statement,l_full_name,'Including Since Overhaul - l_since_oh_ctr_id_tbl -'||i||'-'||l_tmp_over_ctr_id_tbl(i));
499: END IF;
500: l_since_oh_ctr_id_tbl(i) := l_tmp_over_ctr_id_tbl(i);
501: ELSE
502: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
503: fnd_log.string(fnd_log.level_statement,l_full_name,'Omiting Since Overhaul - l_tmp_over_ctr_id_tbl -'||i||'-'||l_tmp_over_ctr_id_tbl(i));
504: END IF;
505: l_since_oh_ctr_id_tbl(i) := null;
506: END IF;

Line 503: fnd_log.string(fnd_log.level_statement,l_full_name,'Omiting Since Overhaul - l_tmp_over_ctr_id_tbl -'||i||'-'||l_tmp_over_ctr_id_tbl(i));

499: END IF;
500: l_since_oh_ctr_id_tbl(i) := l_tmp_over_ctr_id_tbl(i);
501: ELSE
502: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
503: fnd_log.string(fnd_log.level_statement,l_full_name,'Omiting Since Overhaul - l_tmp_over_ctr_id_tbl -'||i||'-'||l_tmp_over_ctr_id_tbl(i));
504: END IF;
505: l_since_oh_ctr_id_tbl(i) := null;
506: END IF;
507: ELSE

Line 508: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

504: END IF;
505: l_since_oh_ctr_id_tbl(i) := null;
506: END IF;
507: ELSE
508: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
509: fnd_log.string(fnd_log.level_statement,l_full_name,'Omiting Since Overhaul - l_tmp_over_ctr_id_tbl -'||i||'-'||l_tmp_over_ctr_id_tbl(i));
510: END IF;
511: l_since_oh_ctr_id_tbl(i) := null;
512: END IF;

Line 509: fnd_log.string(fnd_log.level_statement,l_full_name,'Omiting Since Overhaul - l_tmp_over_ctr_id_tbl -'||i||'-'||l_tmp_over_ctr_id_tbl(i));

505: l_since_oh_ctr_id_tbl(i) := null;
506: END IF;
507: ELSE
508: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
509: fnd_log.string(fnd_log.level_statement,l_full_name,'Omiting Since Overhaul - l_tmp_over_ctr_id_tbl -'||i||'-'||l_tmp_over_ctr_id_tbl(i));
510: END IF;
511: l_since_oh_ctr_id_tbl(i) := null;
512: END IF;
513:

Line 516: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

512: END IF;
513:
514: END LOOP; -- End Loop for Setup Counters Fetched
515:
516: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
517: IF l_since_new_ctr_id_tbl.COUNT > 0 THEN
518: FOR t in l_since_new_ctr_id_tbl.FIRST .. l_since_new_ctr_id_tbl.LAST LOOP
519: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_since_new_ctr_id_tbl --- '||l_since_new_ctr_id_tbl(t));
520: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_since_oh_ctr_id_tbl --- '||l_since_oh_ctr_id_tbl(t));

Line 519: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_since_new_ctr_id_tbl --- '||l_since_new_ctr_id_tbl(t));

515:
516: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
517: IF l_since_new_ctr_id_tbl.COUNT > 0 THEN
518: FOR t in l_since_new_ctr_id_tbl.FIRST .. l_since_new_ctr_id_tbl.LAST LOOP
519: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_since_new_ctr_id_tbl --- '||l_since_new_ctr_id_tbl(t));
520: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_since_oh_ctr_id_tbl --- '||l_since_oh_ctr_id_tbl(t));
521: END LOOP;
522: END IF;
523: END IF;

Line 520: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_since_oh_ctr_id_tbl --- '||l_since_oh_ctr_id_tbl(t));

516: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
517: IF l_since_new_ctr_id_tbl.COUNT > 0 THEN
518: FOR t in l_since_new_ctr_id_tbl.FIRST .. l_since_new_ctr_id_tbl.LAST LOOP
519: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_since_new_ctr_id_tbl --- '||l_since_new_ctr_id_tbl(t));
520: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_since_oh_ctr_id_tbl --- '||l_since_oh_ctr_id_tbl(t));
521: END LOOP;
522: END IF;
523: END IF;
524:

Line 531: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

527: IF (p_concurrent_flag = 'Y') THEN
528: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- No Counter Setup Done for Active Counters --');
529: END IF;
530:
531: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
532: fnd_log.string(fnd_log.level_statement,l_full_name,' No Setup Data Found for Counters - In Loop Else Clause');
533: END IF;
534: END IF;
535:

Line 532: fnd_log.string(fnd_log.level_statement,l_full_name,' No Setup Data Found for Counters - In Loop Else Clause');

528: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- No Counter Setup Done for Active Counters --');
529: END IF;
530:
531: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
532: fnd_log.string(fnd_log.level_statement,l_full_name,' No Setup Data Found for Counters - In Loop Else Clause');
533: END IF;
534: END IF;
535:
536: -- Return if no applicable Counters are retrieved

Line 538: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

534: END IF;
535:
536: -- Return if no applicable Counters are retrieved
537: IF l_since_new_ctr_id_tbl.COUNT = 0 THEN
538: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
539: fnd_log.string(fnd_log.level_statement,l_full_name,'None of the defined counters - are active as per date');
540: END IF;
541: IF (p_concurrent_flag = 'Y') THEN
542: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- No Counter Setup - Non Active afer Data Validation - so returning ----');

Line 539: fnd_log.string(fnd_log.level_statement,l_full_name,'None of the defined counters - are active as per date');

535:
536: -- Return if no applicable Counters are retrieved
537: IF l_since_new_ctr_id_tbl.COUNT = 0 THEN
538: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
539: fnd_log.string(fnd_log.level_statement,l_full_name,'None of the defined counters - are active as per date');
540: END IF;
541: IF (p_concurrent_flag = 'Y') THEN
542: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- No Counter Setup - Non Active afer Data Validation - so returning ----');
543: END IF;

Line 557: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

553: -- Commenting out Code Below for fetching Flight Schedule Data using cursor c_flight_schedule_data
554: -- Instead UA API is being called to derive the flight schedule data
555: -- Fetch Flight Schedules Data For Processing
556: OPEN c_flight_schedule_data(p_start_date,p_end_date);
557: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
558: fnd_log.string(fnd_log.level_statement,l_full_name,' Bulk Fetching Flight Schedules Data For Processing');
559: END IF;
560: IF (p_concurrent_flag = 'Y') THEN
561: fnd_file.put_line(fnd_file.log, ' Bulk Fetching Flight Schedules Data For Processing');

Line 558: fnd_log.string(fnd_log.level_statement,l_full_name,' Bulk Fetching Flight Schedules Data For Processing');

554: -- Instead UA API is being called to derive the flight schedule data
555: -- Fetch Flight Schedules Data For Processing
556: OPEN c_flight_schedule_data(p_start_date,p_end_date);
557: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
558: fnd_log.string(fnd_log.level_statement,l_full_name,' Bulk Fetching Flight Schedules Data For Processing');
559: END IF;
560: IF (p_concurrent_flag = 'Y') THEN
561: fnd_file.put_line(fnd_file.log, ' Bulk Fetching Flight Schedules Data For Processing');
562: END IF;

Line 571: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

567: l_fs_csi_instance_id_tbl,
568: l_fs_org_code_tbl,
569: l_fs_arrival_date_tbl;
570: IF l_fs_unit_sch_id_tbl.COUNT = 0 THEN
571: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
572: fnd_log.string(fnd_log.level_statement,l_full_name,' No Flight Schedules Data Retrieved');
573: END IF;
574: IF (p_concurrent_flag = 'Y') THEN
575: fnd_file.put_line(fnd_file.log, ' No Flight Schedules Data Retrieved');

Line 572: fnd_log.string(fnd_log.level_statement,l_full_name,' No Flight Schedules Data Retrieved');

568: l_fs_org_code_tbl,
569: l_fs_arrival_date_tbl;
570: IF l_fs_unit_sch_id_tbl.COUNT = 0 THEN
571: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
572: fnd_log.string(fnd_log.level_statement,l_full_name,' No Flight Schedules Data Retrieved');
573: END IF;
574: IF (p_concurrent_flag = 'Y') THEN
575: fnd_file.put_line(fnd_file.log, ' No Flight Schedules Data Retrieved');
576: END IF;

Line 578: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

574: IF (p_concurrent_flag = 'Y') THEN
575: fnd_file.put_line(fnd_file.log, ' No Flight Schedules Data Retrieved');
576: END IF;
577: ELSE
578: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
579: fnd_log.string(fnd_log.level_statement,l_full_name,' Flight Schedules Data Retrieved'||l_fs_unit_sch_id_tbl.COUNT);
580: END IF;
581: IF (p_concurrent_flag = 'Y') THEN
582: fnd_file.put_line(fnd_file.log, 'Flight Schedules Data Retrieved'||l_fs_unit_sch_id_tbl.COUNT);

Line 579: fnd_log.string(fnd_log.level_statement,l_full_name,' Flight Schedules Data Retrieved'||l_fs_unit_sch_id_tbl.COUNT);

575: fnd_file.put_line(fnd_file.log, ' No Flight Schedules Data Retrieved');
576: END IF;
577: ELSE
578: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
579: fnd_log.string(fnd_log.level_statement,l_full_name,' Flight Schedules Data Retrieved'||l_fs_unit_sch_id_tbl.COUNT);
580: END IF;
581: IF (p_concurrent_flag = 'Y') THEN
582: fnd_file.put_line(fnd_file.log, 'Flight Schedules Data Retrieved'||l_fs_unit_sch_id_tbl.COUNT);
583: END IF;

Line 589: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

585: CLOSE c_flight_schedule_data;
586: -- Comment Here Ends
587: */
588:
589: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
590: fnd_log.string(fnd_log.level_statement,l_full_name,' Bulk Fetching Flight Schedules Data For Processing - UA API');
591: END IF;
592: IF (p_concurrent_flag = 'Y') THEN
593: fnd_file.put_line(fnd_file.log, ' Bulk Fetching Flight Schedules Data For Processing - UA API');

Line 590: fnd_log.string(fnd_log.level_statement,l_full_name,' Bulk Fetching Flight Schedules Data For Processing - UA API');

586: -- Comment Here Ends
587: */
588:
589: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
590: fnd_log.string(fnd_log.level_statement,l_full_name,' Bulk Fetching Flight Schedules Data For Processing - UA API');
591: END IF;
592: IF (p_concurrent_flag = 'Y') THEN
593: fnd_file.put_line(fnd_file.log, ' Bulk Fetching Flight Schedules Data For Processing - UA API');
594: END IF;

Line 600: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

596: l_flight_search_rec_type.START_DATE := p_start_date - 1;
597: l_flight_search_rec_type.END_DATE := p_end_date + 1;
598: l_flight_search_rec_type.DATE_APPLY_TO_FLAG := AHL_UA_FLIGHT_SCHEDULES_PUB.G_APPLY_TO_ARRIVAL;
599:
600: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
601: fnd_log.string(fnd_log.level_statement,l_full_name,' START_DATE - UA API' || l_flight_search_rec_type.START_DATE);
602: fnd_log.string(fnd_log.level_statement,l_full_name,' END_DATE - UA API' || l_flight_search_rec_type.END_DATE);
603: fnd_log.string(fnd_log.level_statement,l_full_name,' DATE_APPLY_TO_FLAG - UA API : ' || l_flight_search_rec_type.DATE_APPLY_TO_FLAG);
604: END IF;

Line 601: fnd_log.string(fnd_log.level_statement,l_full_name,' START_DATE - UA API' || l_flight_search_rec_type.START_DATE);

597: l_flight_search_rec_type.END_DATE := p_end_date + 1;
598: l_flight_search_rec_type.DATE_APPLY_TO_FLAG := AHL_UA_FLIGHT_SCHEDULES_PUB.G_APPLY_TO_ARRIVAL;
599:
600: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
601: fnd_log.string(fnd_log.level_statement,l_full_name,' START_DATE - UA API' || l_flight_search_rec_type.START_DATE);
602: fnd_log.string(fnd_log.level_statement,l_full_name,' END_DATE - UA API' || l_flight_search_rec_type.END_DATE);
603: fnd_log.string(fnd_log.level_statement,l_full_name,' DATE_APPLY_TO_FLAG - UA API : ' || l_flight_search_rec_type.DATE_APPLY_TO_FLAG);
604: END IF;
605:

Line 602: fnd_log.string(fnd_log.level_statement,l_full_name,' END_DATE - UA API' || l_flight_search_rec_type.END_DATE);

598: l_flight_search_rec_type.DATE_APPLY_TO_FLAG := AHL_UA_FLIGHT_SCHEDULES_PUB.G_APPLY_TO_ARRIVAL;
599:
600: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
601: fnd_log.string(fnd_log.level_statement,l_full_name,' START_DATE - UA API' || l_flight_search_rec_type.START_DATE);
602: fnd_log.string(fnd_log.level_statement,l_full_name,' END_DATE - UA API' || l_flight_search_rec_type.END_DATE);
603: fnd_log.string(fnd_log.level_statement,l_full_name,' DATE_APPLY_TO_FLAG - UA API : ' || l_flight_search_rec_type.DATE_APPLY_TO_FLAG);
604: END IF;
605:
606: AHL_UA_FLIGHT_SCHEDULES_PUB.Get_Flight_Schedule_Details(

Line 603: fnd_log.string(fnd_log.level_statement,l_full_name,' DATE_APPLY_TO_FLAG - UA API : ' || l_flight_search_rec_type.DATE_APPLY_TO_FLAG);

599:
600: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
601: fnd_log.string(fnd_log.level_statement,l_full_name,' START_DATE - UA API' || l_flight_search_rec_type.START_DATE);
602: fnd_log.string(fnd_log.level_statement,l_full_name,' END_DATE - UA API' || l_flight_search_rec_type.END_DATE);
603: fnd_log.string(fnd_log.level_statement,l_full_name,' DATE_APPLY_TO_FLAG - UA API : ' || l_flight_search_rec_type.DATE_APPLY_TO_FLAG);
604: END IF;
605:
606: AHL_UA_FLIGHT_SCHEDULES_PUB.Get_Flight_Schedule_Details(
607: -- standard IN params

Line 623: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

619: p_flight_search_rec => l_flight_search_rec_type,
620: x_flight_schedules_tbl => l_flight_schedules_tbl);
621:
622: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
623: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
624: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API AHL_UA_FLIGHT_SCHEDULES_PUB.Get_Flight_Schedule_Details Errored');
625: END IF;
626: IF (p_concurrent_flag = 'Y') THEN
627: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting Flight Scedule Details --');

Line 624: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API AHL_UA_FLIGHT_SCHEDULES_PUB.Get_Flight_Schedule_Details Errored');

620: x_flight_schedules_tbl => l_flight_schedules_tbl);
621:
622: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
623: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
624: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API AHL_UA_FLIGHT_SCHEDULES_PUB.Get_Flight_Schedule_Details Errored');
625: END IF;
626: IF (p_concurrent_flag = 'Y') THEN
627: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting Flight Scedule Details --');
628: END IF;

Line 655: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

651: END IF;
652:
653: IF l_fs_unit_sch_id_tbl.COUNT > 0 THEN
654: -- Loop for each Unit in the Unit Schedule Record fetched above.
655: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
656: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- LOOP FOR FLIGHT SCHEDULE BEGINS ----- '||l_fs_unit_sch_id_tbl.COUNT);
657: END IF;
658: IF (p_concurrent_flag = 'Y') THEN
659: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Processing Fligth Schedule Data ----');

Line 656: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- LOOP FOR FLIGHT SCHEDULE BEGINS ----- '||l_fs_unit_sch_id_tbl.COUNT);

652:
653: IF l_fs_unit_sch_id_tbl.COUNT > 0 THEN
654: -- Loop for each Unit in the Unit Schedule Record fetched above.
655: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
656: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- LOOP FOR FLIGHT SCHEDULE BEGINS ----- '||l_fs_unit_sch_id_tbl.COUNT);
657: END IF;
658: IF (p_concurrent_flag = 'Y') THEN
659: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Processing Fligth Schedule Data ----');
660: END IF;

Line 666: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

662: FOR i in l_fs_unit_sch_id_tbl.FIRST .. l_fs_unit_sch_id_tbl.LAST LOOP -- Loop for each Unit in the Unit Schedule Record fetched above.
663: -- Fetch details of the Root node of the UC
664: BEGIN
665:
666: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
667: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_unit_sch_id_tbl ----- '||l_fs_unit_sch_id_tbl(i));
668: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_arr_org_id_tbl ----- '||l_fs_arr_org_id_tbl(i));
669: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_uc_header_id_tbl ----- '||l_fs_uc_header_id_tbl(i));
670: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_csi_instance_id_tbl ----- '||l_fs_csi_instance_id_tbl(i));

Line 667: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_unit_sch_id_tbl ----- '||l_fs_unit_sch_id_tbl(i));

663: -- Fetch details of the Root node of the UC
664: BEGIN
665:
666: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
667: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_unit_sch_id_tbl ----- '||l_fs_unit_sch_id_tbl(i));
668: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_arr_org_id_tbl ----- '||l_fs_arr_org_id_tbl(i));
669: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_uc_header_id_tbl ----- '||l_fs_uc_header_id_tbl(i));
670: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_csi_instance_id_tbl ----- '||l_fs_csi_instance_id_tbl(i));
671: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_org_code_tbl ----- '||l_fs_org_code_tbl(i));

Line 668: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_arr_org_id_tbl ----- '||l_fs_arr_org_id_tbl(i));

664: BEGIN
665:
666: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
667: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_unit_sch_id_tbl ----- '||l_fs_unit_sch_id_tbl(i));
668: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_arr_org_id_tbl ----- '||l_fs_arr_org_id_tbl(i));
669: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_uc_header_id_tbl ----- '||l_fs_uc_header_id_tbl(i));
670: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_csi_instance_id_tbl ----- '||l_fs_csi_instance_id_tbl(i));
671: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_org_code_tbl ----- '||l_fs_org_code_tbl(i));
672: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_arrival_date_tbl ----- '||l_fs_arrival_date_tbl(i));

Line 669: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_uc_header_id_tbl ----- '||l_fs_uc_header_id_tbl(i));

665:
666: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
667: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_unit_sch_id_tbl ----- '||l_fs_unit_sch_id_tbl(i));
668: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_arr_org_id_tbl ----- '||l_fs_arr_org_id_tbl(i));
669: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_uc_header_id_tbl ----- '||l_fs_uc_header_id_tbl(i));
670: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_csi_instance_id_tbl ----- '||l_fs_csi_instance_id_tbl(i));
671: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_org_code_tbl ----- '||l_fs_org_code_tbl(i));
672: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_arrival_date_tbl ----- '||l_fs_arrival_date_tbl(i));
673: END IF;

Line 670: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_csi_instance_id_tbl ----- '||l_fs_csi_instance_id_tbl(i));

666: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
667: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_unit_sch_id_tbl ----- '||l_fs_unit_sch_id_tbl(i));
668: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_arr_org_id_tbl ----- '||l_fs_arr_org_id_tbl(i));
669: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_uc_header_id_tbl ----- '||l_fs_uc_header_id_tbl(i));
670: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_csi_instance_id_tbl ----- '||l_fs_csi_instance_id_tbl(i));
671: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_org_code_tbl ----- '||l_fs_org_code_tbl(i));
672: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_arrival_date_tbl ----- '||l_fs_arrival_date_tbl(i));
673: END IF;
674: IF (p_concurrent_flag = 'Y') THEN

Line 671: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_org_code_tbl ----- '||l_fs_org_code_tbl(i));

667: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_unit_sch_id_tbl ----- '||l_fs_unit_sch_id_tbl(i));
668: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_arr_org_id_tbl ----- '||l_fs_arr_org_id_tbl(i));
669: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_uc_header_id_tbl ----- '||l_fs_uc_header_id_tbl(i));
670: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_csi_instance_id_tbl ----- '||l_fs_csi_instance_id_tbl(i));
671: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_org_code_tbl ----- '||l_fs_org_code_tbl(i));
672: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_arrival_date_tbl ----- '||l_fs_arrival_date_tbl(i));
673: END IF;
674: IF (p_concurrent_flag = 'Y') THEN
675: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Fetching UC Root Node Details ----');

Line 672: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_arrival_date_tbl ----- '||l_fs_arrival_date_tbl(i));

668: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_arr_org_id_tbl ----- '||l_fs_arr_org_id_tbl(i));
669: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_uc_header_id_tbl ----- '||l_fs_uc_header_id_tbl(i));
670: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_csi_instance_id_tbl ----- '||l_fs_csi_instance_id_tbl(i));
671: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_org_code_tbl ----- '||l_fs_org_code_tbl(i));
672: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- IN FS LOOP - l_fs_arrival_date_tbl ----- '||l_fs_arrival_date_tbl(i));
673: END IF;
674: IF (p_concurrent_flag = 'Y') THEN
675: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Fetching UC Root Node Details ----');
676: END IF;

Line 708: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

704: AND MCR.mc_header_id = UC.MASTER_CONFIG_ID
705: and MCR.parent_relationship_id is null;
706: EXCEPTION
707: WHEN NO_DATA_FOUND THEN
708: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
709: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- Invalid -- UC_HEADER_ID ----- '||l_fs_uc_header_id_tbl(i));
710: END IF;
711: IF (p_concurrent_flag = 'Y') THEN
712: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Invalid UC Header Id - Data Corruption ----');

Line 709: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- Invalid -- UC_HEADER_ID ----- '||l_fs_uc_header_id_tbl(i));

705: and MCR.parent_relationship_id is null;
706: EXCEPTION
707: WHEN NO_DATA_FOUND THEN
708: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
709: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- Invalid -- UC_HEADER_ID ----- '||l_fs_uc_header_id_tbl(i));
710: END IF;
711: IF (p_concurrent_flag = 'Y') THEN
712: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Invalid UC Header Id - Data Corruption ----');
713: END IF;

Line 716: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

712: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Invalid UC Header Id - Data Corruption ----');
713: END IF;
714: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
715: WHEN OTHERS THEN
716: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
717: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- OTHERS EXEC BLOCK -- UC_HEADER_ID ----- '||l_fs_uc_header_id_tbl(i));
718: END IF;
719: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
720: END;

Line 717: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- OTHERS EXEC BLOCK -- UC_HEADER_ID ----- '||l_fs_uc_header_id_tbl(i));

713: END IF;
714: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
715: WHEN OTHERS THEN
716: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
717: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- OTHERS EXEC BLOCK -- UC_HEADER_ID ----- '||l_fs_uc_header_id_tbl(i));
718: END IF;
719: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
720: END;
721:

Line 723: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

719: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
720: END;
721:
722: -- Fetch Unit Config Tree Node Details for the Unit under consideration in the Loop.
723: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
724: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- Fetching UC Node Data -----Flight Schedule Id --- '||l_fs_unit_sch_id_tbl(i));
725: END IF;
726: IF (p_concurrent_flag = 'Y') THEN
727: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- For Each UC - Fetching Tree Structure ----');

Line 724: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- Fetching UC Node Data -----Flight Schedule Id --- '||l_fs_unit_sch_id_tbl(i));

720: END;
721:
722: -- Fetch Unit Config Tree Node Details for the Unit under consideration in the Loop.
723: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
724: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- Fetching UC Node Data -----Flight Schedule Id --- '||l_fs_unit_sch_id_tbl(i));
725: END IF;
726: IF (p_concurrent_flag = 'Y') THEN
727: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- For Each UC - Fetching Tree Structure ----');
728: END IF;

Line 731: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

727: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- For Each UC - Fetching Tree Structure ----');
728: END IF;
729:
730: OPEN c_uc_node_details(l_fs_csi_instance_id_tbl(i));
731: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
732: fnd_log.string(fnd_log.level_statement,l_full_name,' Bulk Fetching UC Tree for Root_Instance_id -- '||l_fs_csi_instance_id_tbl(i));
733: END IF;
734: FETCH c_uc_node_details
735: BULK COLLECT INTO l_dtls_object_id_tbl,

Line 732: fnd_log.string(fnd_log.level_statement,l_full_name,' Bulk Fetching UC Tree for Root_Instance_id -- '||l_fs_csi_instance_id_tbl(i));

728: END IF;
729:
730: OPEN c_uc_node_details(l_fs_csi_instance_id_tbl(i));
731: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
732: fnd_log.string(fnd_log.level_statement,l_full_name,' Bulk Fetching UC Tree for Root_Instance_id -- '||l_fs_csi_instance_id_tbl(i));
733: END IF;
734: FETCH c_uc_node_details
735: BULK COLLECT INTO l_dtls_object_id_tbl,
736: l_dtls_subject_id_tbl,

Line 749: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

745: l_dtls_item_desc_tbl,
746: --Modified by mpothuku on 09-Nov-2006 for fixing the Bug# 5651645
747: l_dtls_pos_ref_his_tbl;
748: IF l_dtls_subject_id_tbl.COUNT = 0 THEN
749: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
750: fnd_log.string(fnd_log.level_statement,l_full_name,' No Nodes are Returned - Inserting Root Node at FIRST - index 1');
751: END IF;
752: IF (p_concurrent_flag = 'Y') THEN
753: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- No Nodes Fetched --Inserting Root Node at FIRST --');

Line 750: fnd_log.string(fnd_log.level_statement,l_full_name,' No Nodes are Returned - Inserting Root Node at FIRST - index 1');

746: --Modified by mpothuku on 09-Nov-2006 for fixing the Bug# 5651645
747: l_dtls_pos_ref_his_tbl;
748: IF l_dtls_subject_id_tbl.COUNT = 0 THEN
749: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
750: fnd_log.string(fnd_log.level_statement,l_full_name,' No Nodes are Returned - Inserting Root Node at FIRST - index 1');
751: END IF;
752: IF (p_concurrent_flag = 'Y') THEN
753: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- No Nodes Fetched --Inserting Root Node at FIRST --');
754: END IF;

Line 769: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

765: l_dtls_item_desc_tbl(1) := l_root_item_desc;
766: --Added by mpothuku on 09-Nov-2006 for fixing the Bug# 5651645
767: l_dtls_pos_ref_his_tbl(1) := l_root_pos_ref_code;
768: ELSE
769: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
770: fnd_log.string(fnd_log.level_statement,l_full_name,' Nodes are Returned - Inserting Root Node at LAST - index LAST + 1');
771: END IF;
772: IF (p_concurrent_flag = 'Y') THEN
773: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- All Nodes Fetched --Inserting Root Node at LAST --');

Line 770: fnd_log.string(fnd_log.level_statement,l_full_name,' Nodes are Returned - Inserting Root Node at LAST - index LAST + 1');

766: --Added by mpothuku on 09-Nov-2006 for fixing the Bug# 5651645
767: l_dtls_pos_ref_his_tbl(1) := l_root_pos_ref_code;
768: ELSE
769: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
770: fnd_log.string(fnd_log.level_statement,l_full_name,' Nodes are Returned - Inserting Root Node at LAST - index LAST + 1');
771: END IF;
772: IF (p_concurrent_flag = 'Y') THEN
773: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- All Nodes Fetched --Inserting Root Node at LAST --');
774: END IF;

Line 803: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

799: l_prob_value := 0; -- Final Probability Value - Reset for Each Item Instance
800: l_ds_rec_found := 'N'; -- To indicate if duplicate forecast_desginator is already populated in l_forecast_designator_tbl
801: l_mtbf_value_exceeds := 'N'; -- To Indicates if MTBF Value exceeds for any of the Active counters of the Instance
802:
803: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
804: fnd_log.string(fnd_log.level_statement,l_full_name,'Calling API AHL_UMP_PROCESSUNIT_PVT.Get_Forecasted_Counter_Values');
805: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_subject_id_tbl - ' ||l_dtls_subject_id_tbl(j));
806: fnd_log.string(fnd_log.level_statement,l_full_name,'p_end_date - '||to_char(p_end_date, 'DD-MON-YYYY HH24:MI:SS'));
807: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_object_id_tbl - ' ||l_dtls_object_id_tbl(j));

Line 804: fnd_log.string(fnd_log.level_statement,l_full_name,'Calling API AHL_UMP_PROCESSUNIT_PVT.Get_Forecasted_Counter_Values');

800: l_ds_rec_found := 'N'; -- To indicate if duplicate forecast_desginator is already populated in l_forecast_designator_tbl
801: l_mtbf_value_exceeds := 'N'; -- To Indicates if MTBF Value exceeds for any of the Active counters of the Instance
802:
803: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
804: fnd_log.string(fnd_log.level_statement,l_full_name,'Calling API AHL_UMP_PROCESSUNIT_PVT.Get_Forecasted_Counter_Values');
805: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_subject_id_tbl - ' ||l_dtls_subject_id_tbl(j));
806: fnd_log.string(fnd_log.level_statement,l_full_name,'p_end_date - '||to_char(p_end_date, 'DD-MON-YYYY HH24:MI:SS'));
807: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_object_id_tbl - ' ||l_dtls_object_id_tbl(j));
808: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_pos_ref_tbl - ' ||l_dtls_pos_ref_tbl(j));

Line 805: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_subject_id_tbl - ' ||l_dtls_subject_id_tbl(j));

801: l_mtbf_value_exceeds := 'N'; -- To Indicates if MTBF Value exceeds for any of the Active counters of the Instance
802:
803: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
804: fnd_log.string(fnd_log.level_statement,l_full_name,'Calling API AHL_UMP_PROCESSUNIT_PVT.Get_Forecasted_Counter_Values');
805: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_subject_id_tbl - ' ||l_dtls_subject_id_tbl(j));
806: fnd_log.string(fnd_log.level_statement,l_full_name,'p_end_date - '||to_char(p_end_date, 'DD-MON-YYYY HH24:MI:SS'));
807: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_object_id_tbl - ' ||l_dtls_object_id_tbl(j));
808: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_pos_ref_tbl - ' ||l_dtls_pos_ref_tbl(j));
809: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_item_id_tbl - ' ||l_dtls_inv_item_id_tbl(j));

Line 806: fnd_log.string(fnd_log.level_statement,l_full_name,'p_end_date - '||to_char(p_end_date, 'DD-MON-YYYY HH24:MI:SS'));

802:
803: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
804: fnd_log.string(fnd_log.level_statement,l_full_name,'Calling API AHL_UMP_PROCESSUNIT_PVT.Get_Forecasted_Counter_Values');
805: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_subject_id_tbl - ' ||l_dtls_subject_id_tbl(j));
806: fnd_log.string(fnd_log.level_statement,l_full_name,'p_end_date - '||to_char(p_end_date, 'DD-MON-YYYY HH24:MI:SS'));
807: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_object_id_tbl - ' ||l_dtls_object_id_tbl(j));
808: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_pos_ref_tbl - ' ||l_dtls_pos_ref_tbl(j));
809: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_item_id_tbl - ' ||l_dtls_inv_item_id_tbl(j));
810: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_master_org_id_tbl - ' ||l_dtls_inv_master_org_id_tbl(j));

Line 807: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_object_id_tbl - ' ||l_dtls_object_id_tbl(j));

803: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
804: fnd_log.string(fnd_log.level_statement,l_full_name,'Calling API AHL_UMP_PROCESSUNIT_PVT.Get_Forecasted_Counter_Values');
805: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_subject_id_tbl - ' ||l_dtls_subject_id_tbl(j));
806: fnd_log.string(fnd_log.level_statement,l_full_name,'p_end_date - '||to_char(p_end_date, 'DD-MON-YYYY HH24:MI:SS'));
807: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_object_id_tbl - ' ||l_dtls_object_id_tbl(j));
808: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_pos_ref_tbl - ' ||l_dtls_pos_ref_tbl(j));
809: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_item_id_tbl - ' ||l_dtls_inv_item_id_tbl(j));
810: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_master_org_id_tbl - ' ||l_dtls_inv_master_org_id_tbl(j));
811: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_revision_tbl - ' ||l_dtls_inv_revision_tbl(j));

Line 808: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_pos_ref_tbl - ' ||l_dtls_pos_ref_tbl(j));

804: fnd_log.string(fnd_log.level_statement,l_full_name,'Calling API AHL_UMP_PROCESSUNIT_PVT.Get_Forecasted_Counter_Values');
805: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_subject_id_tbl - ' ||l_dtls_subject_id_tbl(j));
806: fnd_log.string(fnd_log.level_statement,l_full_name,'p_end_date - '||to_char(p_end_date, 'DD-MON-YYYY HH24:MI:SS'));
807: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_object_id_tbl - ' ||l_dtls_object_id_tbl(j));
808: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_pos_ref_tbl - ' ||l_dtls_pos_ref_tbl(j));
809: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_item_id_tbl - ' ||l_dtls_inv_item_id_tbl(j));
810: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_master_org_id_tbl - ' ||l_dtls_inv_master_org_id_tbl(j));
811: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_revision_tbl - ' ||l_dtls_inv_revision_tbl(j));
812: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_quantity_tbl - ' ||l_dtls_quantity_tbl(j));

Line 809: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_item_id_tbl - ' ||l_dtls_inv_item_id_tbl(j));

805: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_subject_id_tbl - ' ||l_dtls_subject_id_tbl(j));
806: fnd_log.string(fnd_log.level_statement,l_full_name,'p_end_date - '||to_char(p_end_date, 'DD-MON-YYYY HH24:MI:SS'));
807: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_object_id_tbl - ' ||l_dtls_object_id_tbl(j));
808: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_pos_ref_tbl - ' ||l_dtls_pos_ref_tbl(j));
809: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_item_id_tbl - ' ||l_dtls_inv_item_id_tbl(j));
810: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_master_org_id_tbl - ' ||l_dtls_inv_master_org_id_tbl(j));
811: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_revision_tbl - ' ||l_dtls_inv_revision_tbl(j));
812: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_quantity_tbl - ' ||l_dtls_quantity_tbl(j));
813: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_srl_no_tbl - ' ||l_dtls_srl_no_tbl(j));

Line 810: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_master_org_id_tbl - ' ||l_dtls_inv_master_org_id_tbl(j));

806: fnd_log.string(fnd_log.level_statement,l_full_name,'p_end_date - '||to_char(p_end_date, 'DD-MON-YYYY HH24:MI:SS'));
807: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_object_id_tbl - ' ||l_dtls_object_id_tbl(j));
808: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_pos_ref_tbl - ' ||l_dtls_pos_ref_tbl(j));
809: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_item_id_tbl - ' ||l_dtls_inv_item_id_tbl(j));
810: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_master_org_id_tbl - ' ||l_dtls_inv_master_org_id_tbl(j));
811: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_revision_tbl - ' ||l_dtls_inv_revision_tbl(j));
812: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_quantity_tbl - ' ||l_dtls_quantity_tbl(j));
813: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_srl_no_tbl - ' ||l_dtls_srl_no_tbl(j));
814: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_item_name_tbl - ' ||l_dtls_item_name_tbl(j));

Line 811: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_revision_tbl - ' ||l_dtls_inv_revision_tbl(j));

807: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_object_id_tbl - ' ||l_dtls_object_id_tbl(j));
808: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_pos_ref_tbl - ' ||l_dtls_pos_ref_tbl(j));
809: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_item_id_tbl - ' ||l_dtls_inv_item_id_tbl(j));
810: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_master_org_id_tbl - ' ||l_dtls_inv_master_org_id_tbl(j));
811: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_revision_tbl - ' ||l_dtls_inv_revision_tbl(j));
812: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_quantity_tbl - ' ||l_dtls_quantity_tbl(j));
813: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_srl_no_tbl - ' ||l_dtls_srl_no_tbl(j));
814: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_item_name_tbl - ' ||l_dtls_item_name_tbl(j));
815: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_item_desc_tbl - ' ||l_dtls_item_desc_tbl(j));

Line 812: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_quantity_tbl - ' ||l_dtls_quantity_tbl(j));

808: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_pos_ref_tbl - ' ||l_dtls_pos_ref_tbl(j));
809: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_item_id_tbl - ' ||l_dtls_inv_item_id_tbl(j));
810: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_master_org_id_tbl - ' ||l_dtls_inv_master_org_id_tbl(j));
811: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_revision_tbl - ' ||l_dtls_inv_revision_tbl(j));
812: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_quantity_tbl - ' ||l_dtls_quantity_tbl(j));
813: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_srl_no_tbl - ' ||l_dtls_srl_no_tbl(j));
814: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_item_name_tbl - ' ||l_dtls_item_name_tbl(j));
815: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_item_desc_tbl - ' ||l_dtls_item_desc_tbl(j));
816: --Added by mpothuku on 09-Nov-2006 for fixing the Bug# 5651645

Line 813: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_srl_no_tbl - ' ||l_dtls_srl_no_tbl(j));

809: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_item_id_tbl - ' ||l_dtls_inv_item_id_tbl(j));
810: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_master_org_id_tbl - ' ||l_dtls_inv_master_org_id_tbl(j));
811: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_revision_tbl - ' ||l_dtls_inv_revision_tbl(j));
812: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_quantity_tbl - ' ||l_dtls_quantity_tbl(j));
813: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_srl_no_tbl - ' ||l_dtls_srl_no_tbl(j));
814: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_item_name_tbl - ' ||l_dtls_item_name_tbl(j));
815: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_item_desc_tbl - ' ||l_dtls_item_desc_tbl(j));
816: --Added by mpothuku on 09-Nov-2006 for fixing the Bug# 5651645
817: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_pos_ref_his_tbl - ' ||l_dtls_pos_ref_his_tbl(j));

Line 814: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_item_name_tbl - ' ||l_dtls_item_name_tbl(j));

810: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_master_org_id_tbl - ' ||l_dtls_inv_master_org_id_tbl(j));
811: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_revision_tbl - ' ||l_dtls_inv_revision_tbl(j));
812: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_quantity_tbl - ' ||l_dtls_quantity_tbl(j));
813: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_srl_no_tbl - ' ||l_dtls_srl_no_tbl(j));
814: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_item_name_tbl - ' ||l_dtls_item_name_tbl(j));
815: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_item_desc_tbl - ' ||l_dtls_item_desc_tbl(j));
816: --Added by mpothuku on 09-Nov-2006 for fixing the Bug# 5651645
817: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_pos_ref_his_tbl - ' ||l_dtls_pos_ref_his_tbl(j));
818: END IF;

Line 815: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_item_desc_tbl - ' ||l_dtls_item_desc_tbl(j));

811: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_inv_revision_tbl - ' ||l_dtls_inv_revision_tbl(j));
812: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_quantity_tbl - ' ||l_dtls_quantity_tbl(j));
813: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_srl_no_tbl - ' ||l_dtls_srl_no_tbl(j));
814: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_item_name_tbl - ' ||l_dtls_item_name_tbl(j));
815: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_item_desc_tbl - ' ||l_dtls_item_desc_tbl(j));
816: --Added by mpothuku on 09-Nov-2006 for fixing the Bug# 5651645
817: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_pos_ref_his_tbl - ' ||l_dtls_pos_ref_his_tbl(j));
818: END IF;
819:

Line 817: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_pos_ref_his_tbl - ' ||l_dtls_pos_ref_his_tbl(j));

813: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_srl_no_tbl - ' ||l_dtls_srl_no_tbl(j));
814: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_item_name_tbl - ' ||l_dtls_item_name_tbl(j));
815: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_item_desc_tbl - ' ||l_dtls_item_desc_tbl(j));
816: --Added by mpothuku on 09-Nov-2006 for fixing the Bug# 5651645
817: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_pos_ref_his_tbl - ' ||l_dtls_pos_ref_his_tbl(j));
818: END IF;
819:
820: IF (p_concurrent_flag = 'Y') THEN
821: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Fetch Forecast Counter Value for Node in Context --');

Line 834: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

830: p_forecasted_date => l_fs_arrival_date_tbl(i),
831: x_counter_values_tbl => l_ctr_values_tbl);
832:
833: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
834: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
835: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API AHL_UMP_PROCESSUNIT_PVT.Get_Forecasted_Counter_Values Errored');
836: END IF;
837: IF (p_concurrent_flag = 'Y') THEN
838: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting Forecasted Counter Value for Node in Context --');

Line 835: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API AHL_UMP_PROCESSUNIT_PVT.Get_Forecasted_Counter_Values Errored');

831: x_counter_values_tbl => l_ctr_values_tbl);
832:
833: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
834: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
835: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API AHL_UMP_PROCESSUNIT_PVT.Get_Forecasted_Counter_Values Errored');
836: END IF;
837: IF (p_concurrent_flag = 'Y') THEN
838: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting Forecasted Counter Value for Node in Context --');
839: END IF;

Line 843: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

839: END IF;
840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
841: END IF;
842:
843: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
844: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API AHL_UMP_PROCESSUNIT_PVT.Get_Forecasted_Counter_Values After');
845: fnd_log.string(fnd_log.level_statement,l_full_name,'l_ctr_values_tbl - COUNT - '||l_ctr_values_tbl.COUNT);
846: fnd_log.string(fnd_log.level_statement,l_full_name,'l_return_status - '||l_return_status);
847: fnd_log.string(fnd_log.level_statement,l_full_name,'l_msg_data - '||l_msg_data);

Line 844: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API AHL_UMP_PROCESSUNIT_PVT.Get_Forecasted_Counter_Values After');

840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
841: END IF;
842:
843: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
844: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API AHL_UMP_PROCESSUNIT_PVT.Get_Forecasted_Counter_Values After');
845: fnd_log.string(fnd_log.level_statement,l_full_name,'l_ctr_values_tbl - COUNT - '||l_ctr_values_tbl.COUNT);
846: fnd_log.string(fnd_log.level_statement,l_full_name,'l_return_status - '||l_return_status);
847: fnd_log.string(fnd_log.level_statement,l_full_name,'l_msg_data - '||l_msg_data);
848: fnd_log.string(fnd_log.level_statement,l_full_name,'l_msg_count - '||l_msg_count);

Line 845: fnd_log.string(fnd_log.level_statement,l_full_name,'l_ctr_values_tbl - COUNT - '||l_ctr_values_tbl.COUNT);

841: END IF;
842:
843: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
844: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API AHL_UMP_PROCESSUNIT_PVT.Get_Forecasted_Counter_Values After');
845: fnd_log.string(fnd_log.level_statement,l_full_name,'l_ctr_values_tbl - COUNT - '||l_ctr_values_tbl.COUNT);
846: fnd_log.string(fnd_log.level_statement,l_full_name,'l_return_status - '||l_return_status);
847: fnd_log.string(fnd_log.level_statement,l_full_name,'l_msg_data - '||l_msg_data);
848: fnd_log.string(fnd_log.level_statement,l_full_name,'l_msg_count - '||l_msg_count);
849:

Line 846: fnd_log.string(fnd_log.level_statement,l_full_name,'l_return_status - '||l_return_status);

842:
843: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
844: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API AHL_UMP_PROCESSUNIT_PVT.Get_Forecasted_Counter_Values After');
845: fnd_log.string(fnd_log.level_statement,l_full_name,'l_ctr_values_tbl - COUNT - '||l_ctr_values_tbl.COUNT);
846: fnd_log.string(fnd_log.level_statement,l_full_name,'l_return_status - '||l_return_status);
847: fnd_log.string(fnd_log.level_statement,l_full_name,'l_msg_data - '||l_msg_data);
848: fnd_log.string(fnd_log.level_statement,l_full_name,'l_msg_count - '||l_msg_count);
849:
850: IF (fnd_msg_pub.count_msg > 0 ) THEN

Line 847: fnd_log.string(fnd_log.level_statement,l_full_name,'l_msg_data - '||l_msg_data);

843: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
844: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API AHL_UMP_PROCESSUNIT_PVT.Get_Forecasted_Counter_Values After');
845: fnd_log.string(fnd_log.level_statement,l_full_name,'l_ctr_values_tbl - COUNT - '||l_ctr_values_tbl.COUNT);
846: fnd_log.string(fnd_log.level_statement,l_full_name,'l_return_status - '||l_return_status);
847: fnd_log.string(fnd_log.level_statement,l_full_name,'l_msg_data - '||l_msg_data);
848: fnd_log.string(fnd_log.level_statement,l_full_name,'l_msg_count - '||l_msg_count);
849:
850: IF (fnd_msg_pub.count_msg > 0 ) THEN
851:

Line 848: fnd_log.string(fnd_log.level_statement,l_full_name,'l_msg_count - '||l_msg_count);

844: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API AHL_UMP_PROCESSUNIT_PVT.Get_Forecasted_Counter_Values After');
845: fnd_log.string(fnd_log.level_statement,l_full_name,'l_ctr_values_tbl - COUNT - '||l_ctr_values_tbl.COUNT);
846: fnd_log.string(fnd_log.level_statement,l_full_name,'l_return_status - '||l_return_status);
847: fnd_log.string(fnd_log.level_statement,l_full_name,'l_msg_data - '||l_msg_data);
848: fnd_log.string(fnd_log.level_statement,l_full_name,'l_msg_count - '||l_msg_count);
849:
850: IF (fnd_msg_pub.count_msg > 0 ) THEN
851:
852: FOR msg IN 1..fnd_msg_pub.count_msg LOOP

Line 859: fnd_log.string(fnd_log.level_statement,l_full_name,'UMP Returned - '||l_msg_data);

855: p_encoded => FND_API.G_FALSE,
856: p_data => l_msg_data,
857: p_msg_index_out => l_msg_index_out);
858:
859: fnd_log.string(fnd_log.level_statement,l_full_name,'UMP Returned - '||l_msg_data);
860:
861: END LOOP;
862:
863: END IF;

Line 867: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Returned From Get_Forecasted_Counter_Values - COUNTER_ID - '||l_ctr_values_tbl(u).COUNTER_ID);

863: END IF;
864:
865: IF l_ctr_values_tbl.COUNT > 0 THEN
866: FOR u in l_ctr_values_tbl.FIRST .. l_ctr_values_tbl.LAST LOOP
867: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Returned From Get_Forecasted_Counter_Values - COUNTER_ID - '||l_ctr_values_tbl(u).COUNTER_ID);
868: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Returned From Get_Forecasted_Counter_Values - COUNTER_NAME - '||l_ctr_values_tbl(u).COUNTER_NAME);
869: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Returned From Get_Forecasted_Counter_Values - COUNTER_VALUE - '||l_ctr_values_tbl(u).COUNTER_VALUE);
870: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Returned From Get_Forecasted_Counter_Values - UOM_CODE - '||l_ctr_values_tbl(u).UOM_CODE);
871: END LOOP;

Line 868: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Returned From Get_Forecasted_Counter_Values - COUNTER_NAME - '||l_ctr_values_tbl(u).COUNTER_NAME);

864:
865: IF l_ctr_values_tbl.COUNT > 0 THEN
866: FOR u in l_ctr_values_tbl.FIRST .. l_ctr_values_tbl.LAST LOOP
867: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Returned From Get_Forecasted_Counter_Values - COUNTER_ID - '||l_ctr_values_tbl(u).COUNTER_ID);
868: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Returned From Get_Forecasted_Counter_Values - COUNTER_NAME - '||l_ctr_values_tbl(u).COUNTER_NAME);
869: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Returned From Get_Forecasted_Counter_Values - COUNTER_VALUE - '||l_ctr_values_tbl(u).COUNTER_VALUE);
870: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Returned From Get_Forecasted_Counter_Values - UOM_CODE - '||l_ctr_values_tbl(u).UOM_CODE);
871: END LOOP;
872: END IF;

Line 869: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Returned From Get_Forecasted_Counter_Values - COUNTER_VALUE - '||l_ctr_values_tbl(u).COUNTER_VALUE);

865: IF l_ctr_values_tbl.COUNT > 0 THEN
866: FOR u in l_ctr_values_tbl.FIRST .. l_ctr_values_tbl.LAST LOOP
867: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Returned From Get_Forecasted_Counter_Values - COUNTER_ID - '||l_ctr_values_tbl(u).COUNTER_ID);
868: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Returned From Get_Forecasted_Counter_Values - COUNTER_NAME - '||l_ctr_values_tbl(u).COUNTER_NAME);
869: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Returned From Get_Forecasted_Counter_Values - COUNTER_VALUE - '||l_ctr_values_tbl(u).COUNTER_VALUE);
870: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Returned From Get_Forecasted_Counter_Values - UOM_CODE - '||l_ctr_values_tbl(u).UOM_CODE);
871: END LOOP;
872: END IF;
873: fnd_log.string(fnd_log.level_statement,l_full_name,' - Deriving Active Counters - ');

Line 870: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Returned From Get_Forecasted_Counter_Values - UOM_CODE - '||l_ctr_values_tbl(u).UOM_CODE);

866: FOR u in l_ctr_values_tbl.FIRST .. l_ctr_values_tbl.LAST LOOP
867: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Returned From Get_Forecasted_Counter_Values - COUNTER_ID - '||l_ctr_values_tbl(u).COUNTER_ID);
868: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Returned From Get_Forecasted_Counter_Values - COUNTER_NAME - '||l_ctr_values_tbl(u).COUNTER_NAME);
869: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Returned From Get_Forecasted_Counter_Values - COUNTER_VALUE - '||l_ctr_values_tbl(u).COUNTER_VALUE);
870: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Returned From Get_Forecasted_Counter_Values - UOM_CODE - '||l_ctr_values_tbl(u).UOM_CODE);
871: END LOOP;
872: END IF;
873: fnd_log.string(fnd_log.level_statement,l_full_name,' - Deriving Active Counters - ');
874: END IF;

Line 873: fnd_log.string(fnd_log.level_statement,l_full_name,' - Deriving Active Counters - ');

869: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Returned From Get_Forecasted_Counter_Values - COUNTER_VALUE - '||l_ctr_values_tbl(u).COUNTER_VALUE);
870: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Returned From Get_Forecasted_Counter_Values - UOM_CODE - '||l_ctr_values_tbl(u).UOM_CODE);
871: END LOOP;
872: END IF;
873: fnd_log.string(fnd_log.level_statement,l_full_name,' - Deriving Active Counters - ');
874: END IF;
875:
876: IF (p_concurrent_flag = 'Y') THEN
877: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Ater fetching the Foprecast Counter details for instance in context --');

Line 910: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

906: FOR m in l_since_new_ctr_id_tbl.FIRST .. l_since_new_ctr_id_tbl.LAST LOOP
907: FOR n in l_ctr_values_tbl.FIRST .. l_ctr_values_tbl.LAST LOOP
908:
909: -- Fetching Corresponding Counter Template Id for the Counter Id Passed.
910: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
911: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_ctr_values_tbl.COUNTER_ID --- '||n||' - ' || l_ctr_values_tbl(n).COUNTER_ID);
912: END IF;
913:
914: BEGIN

Line 911: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_ctr_values_tbl.COUNTER_ID --- '||n||' - ' || l_ctr_values_tbl(n).COUNTER_ID);

907: FOR n in l_ctr_values_tbl.FIRST .. l_ctr_values_tbl.LAST LOOP
908:
909: -- Fetching Corresponding Counter Template Id for the Counter Id Passed.
910: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
911: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_ctr_values_tbl.COUNTER_ID --- '||n||' - ' || l_ctr_values_tbl(n).COUNTER_ID);
912: END IF;
913:
914: BEGIN
915: -- Bug Fix for 5296759

Line 932: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

928: AND DISABLED_FLAG = 'N')
929: )
930: );
931:
932: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
933: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_ctr_template_id --- '||l_ctr_template_id);
934: END IF;
935:
936: EXCEPTION

Line 933: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_ctr_template_id --- '||l_ctr_template_id);

929: )
930: );
931:
932: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
933: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_ctr_template_id --- '||l_ctr_template_id);
934: END IF;
935:
936: EXCEPTION
937: WHEN OTHERS THEN

Line 938: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

934: END IF;
935:
936: EXCEPTION
937: WHEN OTHERS THEN
938: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
939: fnd_log.string(fnd_log.level_statement,l_full_name,' --- CSI Data Not Retrieved --- ');
940: END IF;
941: l_ctr_template_id := NULL;
942: NULL;

Line 939: fnd_log.string(fnd_log.level_statement,l_full_name,' --- CSI Data Not Retrieved --- ');

935:
936: EXCEPTION
937: WHEN OTHERS THEN
938: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
939: fnd_log.string(fnd_log.level_statement,l_full_name,' --- CSI Data Not Retrieved --- ');
940: END IF;
941: l_ctr_template_id := NULL;
942: NULL;
943: END;

Line 977: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

973: END IF;
974:
975: -- Active Counters are derived and Processing starts.
976: IF (l_active_ctr_id_tbl.COUNT > 0) THEN
977: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
978: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_id_tbl --- '||l_active_ctr_id_tbl.COUNT);
979: END IF;
980: FOR g in l_active_ctr_id_tbl.FIRST .. l_active_ctr_id_tbl.LAST LOOP
981: IF l_active_ctr_id_tbl.EXISTS(g) THEN

Line 978: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_id_tbl --- '||l_active_ctr_id_tbl.COUNT);

974:
975: -- Active Counters are derived and Processing starts.
976: IF (l_active_ctr_id_tbl.COUNT > 0) THEN
977: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
978: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_id_tbl --- '||l_active_ctr_id_tbl.COUNT);
979: END IF;
980: FOR g in l_active_ctr_id_tbl.FIRST .. l_active_ctr_id_tbl.LAST LOOP
981: IF l_active_ctr_id_tbl.EXISTS(g) THEN
982: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 982: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

978: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_id_tbl --- '||l_active_ctr_id_tbl.COUNT);
979: END IF;
980: FOR g in l_active_ctr_id_tbl.FIRST .. l_active_ctr_id_tbl.LAST LOOP
981: IF l_active_ctr_id_tbl.EXISTS(g) THEN
982: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
983: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_id_tbl --- '||g||' - ' || l_active_ctr_id_tbl(g));
984: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_temp_id_tbl --- '||g||' - ' || l_active_ctr_temp_id_tbl(g));
985: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_name_tbl --- '||g||' - ' || l_active_ctr_name_tbl(g));
986: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_value_tbl --- '||g||' - ' || l_active_ctr_value_tbl(g));

Line 983: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_id_tbl --- '||g||' - ' || l_active_ctr_id_tbl(g));

979: END IF;
980: FOR g in l_active_ctr_id_tbl.FIRST .. l_active_ctr_id_tbl.LAST LOOP
981: IF l_active_ctr_id_tbl.EXISTS(g) THEN
982: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
983: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_id_tbl --- '||g||' - ' || l_active_ctr_id_tbl(g));
984: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_temp_id_tbl --- '||g||' - ' || l_active_ctr_temp_id_tbl(g));
985: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_name_tbl --- '||g||' - ' || l_active_ctr_name_tbl(g));
986: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_value_tbl --- '||g||' - ' || l_active_ctr_value_tbl(g));
987: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_uom_code_tbl --- '||g||' - ' || l_active_uom_code_tbl(g));

Line 984: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_temp_id_tbl --- '||g||' - ' || l_active_ctr_temp_id_tbl(g));

980: FOR g in l_active_ctr_id_tbl.FIRST .. l_active_ctr_id_tbl.LAST LOOP
981: IF l_active_ctr_id_tbl.EXISTS(g) THEN
982: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
983: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_id_tbl --- '||g||' - ' || l_active_ctr_id_tbl(g));
984: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_temp_id_tbl --- '||g||' - ' || l_active_ctr_temp_id_tbl(g));
985: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_name_tbl --- '||g||' - ' || l_active_ctr_name_tbl(g));
986: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_value_tbl --- '||g||' - ' || l_active_ctr_value_tbl(g));
987: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_uom_code_tbl --- '||g||' - ' || l_active_uom_code_tbl(g));
988: END IF;

Line 985: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_name_tbl --- '||g||' - ' || l_active_ctr_name_tbl(g));

981: IF l_active_ctr_id_tbl.EXISTS(g) THEN
982: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
983: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_id_tbl --- '||g||' - ' || l_active_ctr_id_tbl(g));
984: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_temp_id_tbl --- '||g||' - ' || l_active_ctr_temp_id_tbl(g));
985: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_name_tbl --- '||g||' - ' || l_active_ctr_name_tbl(g));
986: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_value_tbl --- '||g||' - ' || l_active_ctr_value_tbl(g));
987: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_uom_code_tbl --- '||g||' - ' || l_active_uom_code_tbl(g));
988: END IF;
989: END IF;

Line 986: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_value_tbl --- '||g||' - ' || l_active_ctr_value_tbl(g));

982: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
983: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_id_tbl --- '||g||' - ' || l_active_ctr_id_tbl(g));
984: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_temp_id_tbl --- '||g||' - ' || l_active_ctr_temp_id_tbl(g));
985: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_name_tbl --- '||g||' - ' || l_active_ctr_name_tbl(g));
986: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_value_tbl --- '||g||' - ' || l_active_ctr_value_tbl(g));
987: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_uom_code_tbl --- '||g||' - ' || l_active_uom_code_tbl(g));
988: END IF;
989: END IF;
990: END LOOP;

Line 987: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_uom_code_tbl --- '||g||' - ' || l_active_uom_code_tbl(g));

983: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_id_tbl --- '||g||' - ' || l_active_ctr_id_tbl(g));
984: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_temp_id_tbl --- '||g||' - ' || l_active_ctr_temp_id_tbl(g));
985: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_name_tbl --- '||g||' - ' || l_active_ctr_name_tbl(g));
986: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_ctr_value_tbl --- '||g||' - ' || l_active_ctr_value_tbl(g));
987: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_active_uom_code_tbl --- '||g||' - ' || l_active_uom_code_tbl(g));
988: END IF;
989: END IF;
990: END LOOP;
991:

Line 992: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

988: END IF;
989: END IF;
990: END LOOP;
991:
992: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
993: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Bulk Fetching MTBF DATA --- ');
994: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Position Reference --- '||l_dtls_pos_ref_tbl(j));
995: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Item Id --- '||l_dtls_inv_item_id_tbl(j));
996: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Item Org Id --- '||l_dtls_inv_master_org_id_tbl(j));

Line 993: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Bulk Fetching MTBF DATA --- ');

989: END IF;
990: END LOOP;
991:
992: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
993: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Bulk Fetching MTBF DATA --- ');
994: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Position Reference --- '||l_dtls_pos_ref_tbl(j));
995: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Item Id --- '||l_dtls_inv_item_id_tbl(j));
996: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Item Org Id --- '||l_dtls_inv_master_org_id_tbl(j));
997: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Item Revision --- '||l_dtls_inv_revision_tbl(j));

Line 994: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Position Reference --- '||l_dtls_pos_ref_tbl(j));

990: END LOOP;
991:
992: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
993: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Bulk Fetching MTBF DATA --- ');
994: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Position Reference --- '||l_dtls_pos_ref_tbl(j));
995: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Item Id --- '||l_dtls_inv_item_id_tbl(j));
996: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Item Org Id --- '||l_dtls_inv_master_org_id_tbl(j));
997: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Item Revision --- '||l_dtls_inv_revision_tbl(j));
998: --Added by mpothuku on 09-Nov-2006 for fixing the Bug# 5651645

Line 995: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Item Id --- '||l_dtls_inv_item_id_tbl(j));

991:
992: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
993: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Bulk Fetching MTBF DATA --- ');
994: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Position Reference --- '||l_dtls_pos_ref_tbl(j));
995: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Item Id --- '||l_dtls_inv_item_id_tbl(j));
996: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Item Org Id --- '||l_dtls_inv_master_org_id_tbl(j));
997: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Item Revision --- '||l_dtls_inv_revision_tbl(j));
998: --Added by mpothuku on 09-Nov-2006 for fixing the Bug# 5651645
999: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Pos Reference for Historical Flow --- ' ||l_dtls_pos_ref_his_tbl(j));

Line 996: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Item Org Id --- '||l_dtls_inv_master_org_id_tbl(j));

992: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
993: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Bulk Fetching MTBF DATA --- ');
994: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Position Reference --- '||l_dtls_pos_ref_tbl(j));
995: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Item Id --- '||l_dtls_inv_item_id_tbl(j));
996: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Item Org Id --- '||l_dtls_inv_master_org_id_tbl(j));
997: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Item Revision --- '||l_dtls_inv_revision_tbl(j));
998: --Added by mpothuku on 09-Nov-2006 for fixing the Bug# 5651645
999: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Pos Reference for Historical Flow --- ' ||l_dtls_pos_ref_his_tbl(j));
1000: END IF;

Line 997: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Item Revision --- '||l_dtls_inv_revision_tbl(j));

993: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Bulk Fetching MTBF DATA --- ');
994: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Position Reference --- '||l_dtls_pos_ref_tbl(j));
995: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Item Id --- '||l_dtls_inv_item_id_tbl(j));
996: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Item Org Id --- '||l_dtls_inv_master_org_id_tbl(j));
997: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Item Revision --- '||l_dtls_inv_revision_tbl(j));
998: --Added by mpothuku on 09-Nov-2006 for fixing the Bug# 5651645
999: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Pos Reference for Historical Flow --- ' ||l_dtls_pos_ref_his_tbl(j));
1000: END IF;
1001: IF (p_concurrent_flag = 'Y') THEN

Line 999: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Pos Reference for Historical Flow --- ' ||l_dtls_pos_ref_his_tbl(j));

995: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Item Id --- '||l_dtls_inv_item_id_tbl(j));
996: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Item Org Id --- '||l_dtls_inv_master_org_id_tbl(j));
997: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Item Revision --- '||l_dtls_inv_revision_tbl(j));
998: --Added by mpothuku on 09-Nov-2006 for fixing the Bug# 5651645
999: fnd_log.string(fnd_log.level_statement,l_full_name,' --- Pos Reference for Historical Flow --- ' ||l_dtls_pos_ref_his_tbl(j));
1000: END IF;
1001: IF (p_concurrent_flag = 'Y') THEN
1002: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Deriving MTBF Data for Active Counter if present - BEFORE -');
1003: END IF;

Line 1013: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1009: FETCH c_get_mtbf_data
1010: BULK COLLECT INTO l_mtbf_ctr_id_tbl,
1011: l_mtbf_value_tbl;
1012: IF l_mtbf_ctr_id_tbl.COUNT = 0 THEN
1013: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1014: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- MTBF SETUP DATA IS NOT DEFINED ----');
1015: END IF;
1016: l_mtbf_data_defined := 'N';
1017: ELSE

Line 1014: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- MTBF SETUP DATA IS NOT DEFINED ----');

1010: BULK COLLECT INTO l_mtbf_ctr_id_tbl,
1011: l_mtbf_value_tbl;
1012: IF l_mtbf_ctr_id_tbl.COUNT = 0 THEN
1013: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1014: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- MTBF SETUP DATA IS NOT DEFINED ----');
1015: END IF;
1016: l_mtbf_data_defined := 'N';
1017: ELSE
1018: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1018: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1014: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- MTBF SETUP DATA IS NOT DEFINED ----');
1015: END IF;
1016: l_mtbf_data_defined := 'N';
1017: ELSE
1018: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1019: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- MTBF SETUP DATA IS DEFINED ----');
1020: END IF;
1021: l_mtbf_data_defined := 'Y';
1022: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 1019: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- MTBF SETUP DATA IS DEFINED ----');

1015: END IF;
1016: l_mtbf_data_defined := 'N';
1017: ELSE
1018: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1019: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- MTBF SETUP DATA IS DEFINED ----');
1020: END IF;
1021: l_mtbf_data_defined := 'Y';
1022: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1023: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_mtbf_ctr_id_tbl --COUNT-- '||l_mtbf_ctr_id_tbl.COUNT);

Line 1022: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1018: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1019: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- MTBF SETUP DATA IS DEFINED ----');
1020: END IF;
1021: l_mtbf_data_defined := 'Y';
1022: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1023: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_mtbf_ctr_id_tbl --COUNT-- '||l_mtbf_ctr_id_tbl.COUNT);
1024: FOR a in l_mtbf_ctr_id_tbl.FIRST .. l_mtbf_ctr_id_tbl.LAST LOOP
1025: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_mtbf_ctr_id_tbl --- '||l_mtbf_ctr_id_tbl(a));
1026: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_mtbf_value_tbl --- '||l_mtbf_value_tbl(a));

Line 1023: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_mtbf_ctr_id_tbl --COUNT-- '||l_mtbf_ctr_id_tbl.COUNT);

1019: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- MTBF SETUP DATA IS DEFINED ----');
1020: END IF;
1021: l_mtbf_data_defined := 'Y';
1022: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1023: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_mtbf_ctr_id_tbl --COUNT-- '||l_mtbf_ctr_id_tbl.COUNT);
1024: FOR a in l_mtbf_ctr_id_tbl.FIRST .. l_mtbf_ctr_id_tbl.LAST LOOP
1025: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_mtbf_ctr_id_tbl --- '||l_mtbf_ctr_id_tbl(a));
1026: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_mtbf_value_tbl --- '||l_mtbf_value_tbl(a));
1027: END LOOP;

Line 1025: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_mtbf_ctr_id_tbl --- '||l_mtbf_ctr_id_tbl(a));

1021: l_mtbf_data_defined := 'Y';
1022: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1023: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_mtbf_ctr_id_tbl --COUNT-- '||l_mtbf_ctr_id_tbl.COUNT);
1024: FOR a in l_mtbf_ctr_id_tbl.FIRST .. l_mtbf_ctr_id_tbl.LAST LOOP
1025: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_mtbf_ctr_id_tbl --- '||l_mtbf_ctr_id_tbl(a));
1026: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_mtbf_value_tbl --- '||l_mtbf_value_tbl(a));
1027: END LOOP;
1028: END IF;
1029: END IF;

Line 1026: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_mtbf_value_tbl --- '||l_mtbf_value_tbl(a));

1022: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1023: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_mtbf_ctr_id_tbl --COUNT-- '||l_mtbf_ctr_id_tbl.COUNT);
1024: FOR a in l_mtbf_ctr_id_tbl.FIRST .. l_mtbf_ctr_id_tbl.LAST LOOP
1025: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_mtbf_ctr_id_tbl --- '||l_mtbf_ctr_id_tbl(a));
1026: fnd_log.string(fnd_log.level_statement,l_full_name,' --- l_mtbf_value_tbl --- '||l_mtbf_value_tbl(a));
1027: END LOOP;
1028: END IF;
1029: END IF;
1030: CLOSE c_get_mtbf_data;

Line 1051: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1047: FOR s in l_mtbf_ctr_id_tbl.FIRST .. l_mtbf_ctr_id_tbl.LAST LOOP
1048: IF (l_active_ctr_temp_id_tbl(r) = l_mtbf_ctr_id_tbl(s) AND
1049: l_active_ctr_value_tbl(r) >= l_mtbf_value_tbl(s)) THEN
1050: l_mtbf_value_exceeds := 'Y';
1051: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1052: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- MTBF VALUE EXCEEDS ----');
1053: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- l_active_ctr_temp_id_tbl ----'||l_active_ctr_temp_id_tbl(r));
1054: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- l_active_ctr_value_tbl ----'||l_active_ctr_value_tbl(r));
1055: END IF;

Line 1052: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- MTBF VALUE EXCEEDS ----');

1048: IF (l_active_ctr_temp_id_tbl(r) = l_mtbf_ctr_id_tbl(s) AND
1049: l_active_ctr_value_tbl(r) >= l_mtbf_value_tbl(s)) THEN
1050: l_mtbf_value_exceeds := 'Y';
1051: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1052: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- MTBF VALUE EXCEEDS ----');
1053: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- l_active_ctr_temp_id_tbl ----'||l_active_ctr_temp_id_tbl(r));
1054: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- l_active_ctr_value_tbl ----'||l_active_ctr_value_tbl(r));
1055: END IF;
1056: EXIT;

Line 1053: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- l_active_ctr_temp_id_tbl ----'||l_active_ctr_temp_id_tbl(r));

1049: l_active_ctr_value_tbl(r) >= l_mtbf_value_tbl(s)) THEN
1050: l_mtbf_value_exceeds := 'Y';
1051: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1052: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- MTBF VALUE EXCEEDS ----');
1053: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- l_active_ctr_temp_id_tbl ----'||l_active_ctr_temp_id_tbl(r));
1054: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- l_active_ctr_value_tbl ----'||l_active_ctr_value_tbl(r));
1055: END IF;
1056: EXIT;
1057: END IF;

Line 1054: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- l_active_ctr_value_tbl ----'||l_active_ctr_value_tbl(r));

1050: l_mtbf_value_exceeds := 'Y';
1051: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1052: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- MTBF VALUE EXCEEDS ----');
1053: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- l_active_ctr_temp_id_tbl ----'||l_active_ctr_temp_id_tbl(r));
1054: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- l_active_ctr_value_tbl ----'||l_active_ctr_value_tbl(r));
1055: END IF;
1056: EXIT;
1057: END IF;
1058: END LOOP;

Line 1070: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1066: IF (p_concurrent_flag = 'Y') THEN
1067: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- MTBF Defined - Fetching Forecast Designator - BEFORE');
1068: END IF;
1069:
1070: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1071: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- MTBF SETUP DATA IS DEFINED --VALUE EXCEEDS--');
1072: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- Deriving Fct Designator ----');
1073: END IF;
1074:

Line 1071: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- MTBF SETUP DATA IS DEFINED --VALUE EXCEEDS--');

1067: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- MTBF Defined - Fetching Forecast Designator - BEFORE');
1068: END IF;
1069:
1070: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1071: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- MTBF SETUP DATA IS DEFINED --VALUE EXCEEDS--');
1072: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- Deriving Fct Designator ----');
1073: END IF;
1074:
1075: BEGIN

Line 1072: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- Deriving Fct Designator ----');

1068: END IF;
1069:
1070: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1071: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- MTBF SETUP DATA IS DEFINED --VALUE EXCEEDS--');
1072: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- Deriving Fct Designator ----');
1073: END IF;
1074:
1075: BEGIN
1076: Select FORECAST_DESIGNATOR

Line 1082: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1078: from AHL_RA_FCT_ASSOCIATIONS
1079: where ASSOCIATION_TYPE_CODE = 'ASSOC_MTBF'
1080: and ORGANIZATION_ID = l_fs_arr_org_id_tbl(i);
1081:
1082: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1083: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- Derived Fct Designator ----'||l_fct_designator);
1084: END IF;
1085:
1086: l_prob_value := 100;

Line 1083: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- Derived Fct Designator ----'||l_fct_designator);

1079: where ASSOCIATION_TYPE_CODE = 'ASSOC_MTBF'
1080: and ORGANIZATION_ID = l_fs_arr_org_id_tbl(i);
1081:
1082: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1083: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- Derived Fct Designator ----'||l_fct_designator);
1084: END IF;
1085:
1086: l_prob_value := 100;
1087:

Line 1090: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1086: l_prob_value := 100;
1087:
1088: EXCEPTION
1089: WHEN NO_DATA_FOUND THEN
1090: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1091: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- No Fct Designator Defined ----');
1092: END IF;
1093: l_fct_designator := null;
1094: WHEN TOO_MANY_ROWS THEN

Line 1091: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- No Fct Designator Defined ----');

1087:
1088: EXCEPTION
1089: WHEN NO_DATA_FOUND THEN
1090: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1091: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- No Fct Designator Defined ----');
1092: END IF;
1093: l_fct_designator := null;
1094: WHEN TOO_MANY_ROWS THEN
1095: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1095: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1091: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- No Fct Designator Defined ----');
1092: END IF;
1093: l_fct_designator := null;
1094: WHEN TOO_MANY_ROWS THEN
1095: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1096: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- TOO_MANY_ROWS EXEC BLOCK -M- ORG_ID ----- '||l_fs_arr_org_id_tbl(i));
1097: END IF;
1098: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1099: WHEN OTHERS THEN

Line 1096: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- TOO_MANY_ROWS EXEC BLOCK -M- ORG_ID ----- '||l_fs_arr_org_id_tbl(i));

1092: END IF;
1093: l_fct_designator := null;
1094: WHEN TOO_MANY_ROWS THEN
1095: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1096: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- TOO_MANY_ROWS EXEC BLOCK -M- ORG_ID ----- '||l_fs_arr_org_id_tbl(i));
1097: END IF;
1098: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1099: WHEN OTHERS THEN
1100: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1100: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1096: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- TOO_MANY_ROWS EXEC BLOCK -M- ORG_ID ----- '||l_fs_arr_org_id_tbl(i));
1097: END IF;
1098: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1099: WHEN OTHERS THEN
1100: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1101: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- OTHERS EXEC BLOCK -M- ORG_ID ----- '||l_fs_arr_org_id_tbl(i));
1102: END IF;
1103: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1104: END;

Line 1101: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- OTHERS EXEC BLOCK -M- ORG_ID ----- '||l_fs_arr_org_id_tbl(i));

1097: END IF;
1098: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1099: WHEN OTHERS THEN
1100: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1101: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- OTHERS EXEC BLOCK -M- ORG_ID ----- '||l_fs_arr_org_id_tbl(i));
1102: END IF;
1103: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1104: END;
1105:

Line 1114: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1110: l_fct_designator := null;
1111: IF (p_concurrent_flag = 'Y') THEN
1112: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Ctr Value Does not Exceed MTBF Value');
1113: END IF;
1114: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1115: fnd_log.string(fnd_log.level_statement,l_full_name,'RA Analyser Process ---- Ctr Value Does not Exceed MTBF Value');
1116: END IF;
1117: END IF;
1118:

Line 1115: fnd_log.string(fnd_log.level_statement,l_full_name,'RA Analyser Process ---- Ctr Value Does not Exceed MTBF Value');

1111: IF (p_concurrent_flag = 'Y') THEN
1112: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Ctr Value Does not Exceed MTBF Value');
1113: END IF;
1114: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1115: fnd_log.string(fnd_log.level_statement,l_full_name,'RA Analyser Process ---- Ctr Value Does not Exceed MTBF Value');
1116: END IF;
1117: END IF;
1118:
1119: ELSIF l_mtbf_data_defined = 'N' THEN

Line 1123: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1119: ELSIF l_mtbf_data_defined = 'N' THEN
1120: -- Derive Probability of Failure of the Item using the Part Removal Data of the item.
1121: -- Derive this Probabilty for each Counter Assigned to the Item
1122: -- Derive the Forecast Designator using the Forecast Association Setup using the highest value
1123: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1124: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- MTBF SETUP DATA IS NOT DEFINED --Processing--');
1125: END IF;
1126: IF (p_concurrent_flag = 'Y') THEN
1127: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- MTBF Not Defined - Fetching Path Positions Ids for Instance - BEFORE');

Line 1124: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- MTBF SETUP DATA IS NOT DEFINED --Processing--');

1120: -- Derive Probability of Failure of the Item using the Part Removal Data of the item.
1121: -- Derive this Probabilty for each Counter Assigned to the Item
1122: -- Derive the Forecast Designator using the Forecast Association Setup using the highest value
1123: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1124: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- MTBF SETUP DATA IS NOT DEFINED --Processing--');
1125: END IF;
1126: IF (p_concurrent_flag = 'Y') THEN
1127: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- MTBF Not Defined - Fetching Path Positions Ids for Instance - BEFORE');
1128: END IF;

Line 1136: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1132: OPEN c_get_path_postions(l_dtls_pos_ref_his_tbl(j));-- Derive all Path Positions for the Position Reference
1133: FETCH c_get_path_postions
1134: BULK COLLECT INTO l_path_position_id_tbl;
1135: IF l_path_position_id_tbl.COUNT = 0 THEN
1136: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1137: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- NO CORRESPONDING PATH POSITIONS FOUND ----');
1138: END IF;
1139: l_path_pos_exist_flag := 'N';
1140: ELSE

Line 1137: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- NO CORRESPONDING PATH POSITIONS FOUND ----');

1133: FETCH c_get_path_postions
1134: BULK COLLECT INTO l_path_position_id_tbl;
1135: IF l_path_position_id_tbl.COUNT = 0 THEN
1136: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1137: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- NO CORRESPONDING PATH POSITIONS FOUND ----');
1138: END IF;
1139: l_path_pos_exist_flag := 'N';
1140: ELSE
1141: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1141: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1137: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- NO CORRESPONDING PATH POSITIONS FOUND ----');
1138: END IF;
1139: l_path_pos_exist_flag := 'N';
1140: ELSE
1141: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1142: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- CORRESPONDING PATH POSITIONS RETRIEVED ----');
1143: FOR pos_index in l_path_position_id_tbl.FIRST .. l_path_position_id_tbl.LAST LOOP
1144: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- l_path_position_id_tbl ----'||l_path_position_id_tbl(pos_index));
1145: END LOOP;

Line 1142: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- CORRESPONDING PATH POSITIONS RETRIEVED ----');

1138: END IF;
1139: l_path_pos_exist_flag := 'N';
1140: ELSE
1141: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1142: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- CORRESPONDING PATH POSITIONS RETRIEVED ----');
1143: FOR pos_index in l_path_position_id_tbl.FIRST .. l_path_position_id_tbl.LAST LOOP
1144: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- l_path_position_id_tbl ----'||l_path_position_id_tbl(pos_index));
1145: END LOOP;
1146: END IF;

Line 1144: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- l_path_position_id_tbl ----'||l_path_position_id_tbl(pos_index));

1140: ELSE
1141: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1142: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- CORRESPONDING PATH POSITIONS RETRIEVED ----');
1143: FOR pos_index in l_path_position_id_tbl.FIRST .. l_path_position_id_tbl.LAST LOOP
1144: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- l_path_position_id_tbl ----'||l_path_position_id_tbl(pos_index));
1145: END LOOP;
1146: END IF;
1147: l_path_pos_exist_flag := 'Y';
1148: END IF;

Line 1163: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1159: END IF;
1160:
1161: FOR p in l_active_ctr_id_tbl.FIRST .. l_active_ctr_id_tbl.LAST LOOP
1162: IF l_active_ctr_id_tbl.EXISTS(p) THEN
1163: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1164: fnd_log.string(fnd_log.level_statement,l_full_name,' ----Looping for active counters --'||l_active_ctr_id_tbl(p));
1165: fnd_log.string(fnd_log.level_statement,l_full_name,' ----Active Counter Value -- A --'||l_active_ctr_value_tbl(p));
1166: END IF;
1167:

Line 1164: fnd_log.string(fnd_log.level_statement,l_full_name,' ----Looping for active counters --'||l_active_ctr_id_tbl(p));

1160:
1161: FOR p in l_active_ctr_id_tbl.FIRST .. l_active_ctr_id_tbl.LAST LOOP
1162: IF l_active_ctr_id_tbl.EXISTS(p) THEN
1163: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1164: fnd_log.string(fnd_log.level_statement,l_full_name,' ----Looping for active counters --'||l_active_ctr_id_tbl(p));
1165: fnd_log.string(fnd_log.level_statement,l_full_name,' ----Active Counter Value -- A --'||l_active_ctr_value_tbl(p));
1166: END IF;
1167:
1168: l_prob_attrib_a := 0; -- Indicates Current Value of Counter

Line 1165: fnd_log.string(fnd_log.level_statement,l_full_name,' ----Active Counter Value -- A --'||l_active_ctr_value_tbl(p));

1161: FOR p in l_active_ctr_id_tbl.FIRST .. l_active_ctr_id_tbl.LAST LOOP
1162: IF l_active_ctr_id_tbl.EXISTS(p) THEN
1163: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1164: fnd_log.string(fnd_log.level_statement,l_full_name,' ----Looping for active counters --'||l_active_ctr_id_tbl(p));
1165: fnd_log.string(fnd_log.level_statement,l_full_name,' ----Active Counter Value -- A --'||l_active_ctr_value_tbl(p));
1166: END IF;
1167:
1168: l_prob_attrib_a := 0; -- Indicates Current Value of Counter
1169: l_prob_attrib_b := 0; -- Number of items per position that failed with counter values less than or equal to A from CMRO's unscheduled removals

Line 1180: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1176: -- postion reference and then summed up to get the final values.
1177:
1178: l_prob_attrib_a := l_active_ctr_value_tbl(p);
1179:
1180: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1181: fnd_log.string(fnd_log.level_statement,l_full_name,' ----deriving l_prob_attrib_c_tmp ----');
1182: END IF;
1183:
1184: IF l_path_position_id_tbl.COUNT > 0 THEN -- This should always be true due to l_path_pos_exist_flag = 'Y' check above

Line 1181: fnd_log.string(fnd_log.level_statement,l_full_name,' ----deriving l_prob_attrib_c_tmp ----');

1177:
1178: l_prob_attrib_a := l_active_ctr_value_tbl(p);
1179:
1180: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1181: fnd_log.string(fnd_log.level_statement,l_full_name,' ----deriving l_prob_attrib_c_tmp ----');
1182: END IF;
1183:
1184: IF l_path_position_id_tbl.COUNT > 0 THEN -- This should always be true due to l_path_pos_exist_flag = 'Y' check above
1185: FOR q in l_path_position_id_tbl.FIRST .. l_path_position_id_tbl.LAST LOOP

Line 1211: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1207: AND cii.instance_id = chg.removed_instance_id
1208: AND cii.inventory_item_id = l_dtls_inv_item_id_tbl(j)
1209: AND cii.inv_master_organization_id = l_dtls_inv_master_org_id_tbl(j)) query_c;
1210:
1211: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1212: fnd_log.string(fnd_log.level_statement,l_full_name,' ----derived l_prob_attrib_c_tmp ----' || l_prob_attrib_c_tmp);
1213: fnd_log.string(fnd_log.level_statement,l_full_name,' ----deriving l_prob_attrib_b_tmp ----');
1214: END IF;
1215:

Line 1212: fnd_log.string(fnd_log.level_statement,l_full_name,' ----derived l_prob_attrib_c_tmp ----' || l_prob_attrib_c_tmp);

1208: AND cii.inventory_item_id = l_dtls_inv_item_id_tbl(j)
1209: AND cii.inv_master_organization_id = l_dtls_inv_master_org_id_tbl(j)) query_c;
1210:
1211: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1212: fnd_log.string(fnd_log.level_statement,l_full_name,' ----derived l_prob_attrib_c_tmp ----' || l_prob_attrib_c_tmp);
1213: fnd_log.string(fnd_log.level_statement,l_full_name,' ----deriving l_prob_attrib_b_tmp ----');
1214: END IF;
1215:
1216: -- For deriving l_prob_attrib_b_tmp

Line 1213: fnd_log.string(fnd_log.level_statement,l_full_name,' ----deriving l_prob_attrib_b_tmp ----');

1209: AND cii.inv_master_organization_id = l_dtls_inv_master_org_id_tbl(j)) query_c;
1210:
1211: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1212: fnd_log.string(fnd_log.level_statement,l_full_name,' ----derived l_prob_attrib_c_tmp ----' || l_prob_attrib_c_tmp);
1213: fnd_log.string(fnd_log.level_statement,l_full_name,' ----deriving l_prob_attrib_b_tmp ----');
1214: END IF;
1215:
1216: -- For deriving l_prob_attrib_b_tmp
1217: -- If l_prob_attrib_c_tmp = 0, it indicates that part removal history contains no data

Line 1256: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1252: AND cii.inventory_item_id = l_dtls_inv_item_id_tbl(j)
1253: AND cii.inv_master_organization_id = l_dtls_inv_master_org_id_tbl(j)) query_b
1254: where l_prob_attrib_a > query_b.net_reading;
1255:
1256: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1257: fnd_log.string(fnd_log.level_statement,l_full_name,' ----derived l_prob_attrib_b_tmp as ----'||l_prob_attrib_b_tmp);
1258: END IF;
1259:
1260: ELSE

Line 1257: fnd_log.string(fnd_log.level_statement,l_full_name,' ----derived l_prob_attrib_b_tmp as ----'||l_prob_attrib_b_tmp);

1253: AND cii.inv_master_organization_id = l_dtls_inv_master_org_id_tbl(j)) query_b
1254: where l_prob_attrib_a > query_b.net_reading;
1255:
1256: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1257: fnd_log.string(fnd_log.level_statement,l_full_name,' ----derived l_prob_attrib_b_tmp as ----'||l_prob_attrib_b_tmp);
1258: END IF;
1259:
1260: ELSE
1261:

Line 1262: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1258: END IF;
1259:
1260: ELSE
1261:
1262: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1263: fnd_log.string(fnd_log.level_statement,l_full_name,' ----derived l_prob_attrib_b_tmp as 0 since l_prob_attrib_c is 0 ----');
1264: END IF;
1265:
1266: IF (p_concurrent_flag = 'Y') THEN

Line 1263: fnd_log.string(fnd_log.level_statement,l_full_name,' ----derived l_prob_attrib_b_tmp as 0 since l_prob_attrib_c is 0 ----');

1259:
1260: ELSE
1261:
1262: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1263: fnd_log.string(fnd_log.level_statement,l_full_name,' ----derived l_prob_attrib_b_tmp as 0 since l_prob_attrib_c is 0 ----');
1264: END IF;
1265:
1266: IF (p_concurrent_flag = 'Y') THEN
1267: fnd_file.put_line(fnd_file.log, 'Setting Attrib B to 0 as C is also 0');

Line 1282: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1278: l_prob_attrib_c := l_prob_attrib_c + l_prob_attrib_c_tmp;
1279:
1280: END LOOP; -- l_path_position_id_tbl -- q
1281:
1282: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1283: fnd_log.string(fnd_log.level_statement,l_full_name,' ----deriving l_prob_attrib_d_tmp ----');
1284: END IF;
1285: IF (p_concurrent_flag = 'Y') THEN
1286: fnd_file.put_line(fnd_file.log, 'Derive Attribute D for Probability');

Line 1283: fnd_log.string(fnd_log.level_statement,l_full_name,' ----deriving l_prob_attrib_d_tmp ----');

1279:
1280: END LOOP; -- l_path_position_id_tbl -- q
1281:
1282: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1283: fnd_log.string(fnd_log.level_statement,l_full_name,' ----deriving l_prob_attrib_d_tmp ----');
1284: END IF;
1285: IF (p_concurrent_flag = 'Y') THEN
1286: fnd_file.put_line(fnd_file.log, 'Derive Attribute D for Probability');
1287: END IF;

Line 1322: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1318: AND ciir.relationship_type_code = 'COMPONENT-OF'
1319: AND TRUNC(NVL(CIIR.ACTIVE_START_DATE,SYSDATE)) <= TRUNC(SYSDATE)
1320: AND TRUNC(SYSDATE) < TRUNC(NVL(CIIR.ACTIVE_END_DATE,SYSDATE+1));
1321:
1322: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1323: fnd_log.string(fnd_log.level_statement,l_full_name,' ----derived l_prob_attrib_d as ----'|| l_prob_attrib_d);
1324: END IF;
1325:
1326: IF (p_concurrent_flag = 'Y') THEN

Line 1323: fnd_log.string(fnd_log.level_statement,l_full_name,' ----derived l_prob_attrib_d as ----'|| l_prob_attrib_d);

1319: AND TRUNC(NVL(CIIR.ACTIVE_START_DATE,SYSDATE)) <= TRUNC(SYSDATE)
1320: AND TRUNC(SYSDATE) < TRUNC(NVL(CIIR.ACTIVE_END_DATE,SYSDATE+1));
1321:
1322: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1323: fnd_log.string(fnd_log.level_statement,l_full_name,' ----derived l_prob_attrib_d as ----'|| l_prob_attrib_d);
1324: END IF;
1325:
1326: IF (p_concurrent_flag = 'Y') THEN
1327: fnd_file.put_line(fnd_file.log, 'Derive Probability using B C and D');

Line 1333: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1329:
1330: IF ((l_prob_attrib_c + l_prob_attrib_d) > 0) THEN
1331: l_prob_value_tmp := (l_prob_attrib_b)/(l_prob_attrib_c + l_prob_attrib_d);
1332: l_prob_value_tmp := l_prob_value_tmp * 100;
1333: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1334: fnd_log.string(fnd_log.level_statement,l_full_name,' ----denom > 0 .. compute temp prob ----'||l_prob_value_tmp);
1335: END IF;
1336: ELSE
1337: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1334: fnd_log.string(fnd_log.level_statement,l_full_name,' ----denom > 0 .. compute temp prob ----'||l_prob_value_tmp);

1330: IF ((l_prob_attrib_c + l_prob_attrib_d) > 0) THEN
1331: l_prob_value_tmp := (l_prob_attrib_b)/(l_prob_attrib_c + l_prob_attrib_d);
1332: l_prob_value_tmp := l_prob_value_tmp * 100;
1333: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1334: fnd_log.string(fnd_log.level_statement,l_full_name,' ----denom > 0 .. compute temp prob ----'||l_prob_value_tmp);
1335: END IF;
1336: ELSE
1337: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1338: fnd_log.string(fnd_log.level_statement,l_full_name,' ----denom = 0 .. set temp prob to 0----');

Line 1337: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1333: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1334: fnd_log.string(fnd_log.level_statement,l_full_name,' ----denom > 0 .. compute temp prob ----'||l_prob_value_tmp);
1335: END IF;
1336: ELSE
1337: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1338: fnd_log.string(fnd_log.level_statement,l_full_name,' ----denom = 0 .. set temp prob to 0----');
1339: END IF;
1340: l_prob_value_tmp := 0;
1341: END IF;

Line 1338: fnd_log.string(fnd_log.level_statement,l_full_name,' ----denom = 0 .. set temp prob to 0----');

1334: fnd_log.string(fnd_log.level_statement,l_full_name,' ----denom > 0 .. compute temp prob ----'||l_prob_value_tmp);
1335: END IF;
1336: ELSE
1337: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1338: fnd_log.string(fnd_log.level_statement,l_full_name,' ----denom = 0 .. set temp prob to 0----');
1339: END IF;
1340: l_prob_value_tmp := 0;
1341: END IF;
1342:

Line 1348: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1344: fnd_file.put_line(fnd_file.log, 'Retain Probability if Higher than Previous Value');
1345: END IF;
1346:
1347: IF l_prob_value_tmp > l_prob_value THEN
1348: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1349: fnd_log.string(fnd_log.level_statement,l_full_name,' ----higher value of prob found .. Set final value ----'||l_prob_value_tmp);
1350: END IF;
1351: l_prob_value := l_prob_value_tmp;
1352: IF (p_concurrent_flag = 'Y') THEN

Line 1349: fnd_log.string(fnd_log.level_statement,l_full_name,' ----higher value of prob found .. Set final value ----'||l_prob_value_tmp);

1345: END IF;
1346:
1347: IF l_prob_value_tmp > l_prob_value THEN
1348: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1349: fnd_log.string(fnd_log.level_statement,l_full_name,' ----higher value of prob found .. Set final value ----'||l_prob_value_tmp);
1350: END IF;
1351: l_prob_value := l_prob_value_tmp;
1352: IF (p_concurrent_flag = 'Y') THEN
1353: fnd_file.put_line(fnd_file.log, 'Retained Probability');

Line 1358: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1354: END IF;
1355: END IF;
1356: ELSE -- l_path_position_id_tbl.COUNT = 0
1357: -- This should never be true due to l_path_pos_exist_flag = 'Y' check above
1358: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1359: fnd_log.string(fnd_log.level_statement,l_full_name,' ----No Path Position Found -- so ----');
1360: fnd_log.string(fnd_log.level_statement,l_full_name,' ----Exit Counter Loop Jump to Next Item ----');
1361: fnd_log.string(fnd_log.level_statement,l_full_name,' ----This Code Should not be executed -- Extra redundant check ----');
1362: END IF;

Line 1359: fnd_log.string(fnd_log.level_statement,l_full_name,' ----No Path Position Found -- so ----');

1355: END IF;
1356: ELSE -- l_path_position_id_tbl.COUNT = 0
1357: -- This should never be true due to l_path_pos_exist_flag = 'Y' check above
1358: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1359: fnd_log.string(fnd_log.level_statement,l_full_name,' ----No Path Position Found -- so ----');
1360: fnd_log.string(fnd_log.level_statement,l_full_name,' ----Exit Counter Loop Jump to Next Item ----');
1361: fnd_log.string(fnd_log.level_statement,l_full_name,' ----This Code Should not be executed -- Extra redundant check ----');
1362: END IF;
1363: IF (p_concurrent_flag = 'Y') THEN

Line 1360: fnd_log.string(fnd_log.level_statement,l_full_name,' ----Exit Counter Loop Jump to Next Item ----');

1356: ELSE -- l_path_position_id_tbl.COUNT = 0
1357: -- This should never be true due to l_path_pos_exist_flag = 'Y' check above
1358: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1359: fnd_log.string(fnd_log.level_statement,l_full_name,' ----No Path Position Found -- so ----');
1360: fnd_log.string(fnd_log.level_statement,l_full_name,' ----Exit Counter Loop Jump to Next Item ----');
1361: fnd_log.string(fnd_log.level_statement,l_full_name,' ----This Code Should not be executed -- Extra redundant check ----');
1362: END IF;
1363: IF (p_concurrent_flag = 'Y') THEN
1364: fnd_file.put_line(fnd_file.log, ' ----No Path Position Found -- so ----');

Line 1361: fnd_log.string(fnd_log.level_statement,l_full_name,' ----This Code Should not be executed -- Extra redundant check ----');

1357: -- This should never be true due to l_path_pos_exist_flag = 'Y' check above
1358: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1359: fnd_log.string(fnd_log.level_statement,l_full_name,' ----No Path Position Found -- so ----');
1360: fnd_log.string(fnd_log.level_statement,l_full_name,' ----Exit Counter Loop Jump to Next Item ----');
1361: fnd_log.string(fnd_log.level_statement,l_full_name,' ----This Code Should not be executed -- Extra redundant check ----');
1362: END IF;
1363: IF (p_concurrent_flag = 'Y') THEN
1364: fnd_file.put_line(fnd_file.log, ' ----No Path Position Found -- so ----');
1365: fnd_file.put_line(fnd_file.log, ' ----Exit Counter Loop Jump to Next Item ----');

Line 1384: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1380: --irrespective of whether a FD for zero is defined.
1381: IF l_prob_value > 0 THEN
1382:
1383: BEGIN
1384: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1385: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- Deriving Fct Designator -- for historical--');
1386: END IF;
1387: IF (p_concurrent_flag = 'Y') THEN
1388: fnd_file.put_line(fnd_file.log, ' ----No MTBF Data Found -- Retreive Forecast Designator ----');

Line 1385: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- Deriving Fct Designator -- for historical--');

1381: IF l_prob_value > 0 THEN
1382:
1383: BEGIN
1384: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1385: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- Deriving Fct Designator -- for historical--');
1386: END IF;
1387: IF (p_concurrent_flag = 'Y') THEN
1388: fnd_file.put_line(fnd_file.log, ' ----No MTBF Data Found -- Retreive Forecast Designator ----');
1389: END IF;

Line 1400: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1396: OR (l_prob_value = 100 AND PROBABILITY_TO >= l_prob_value))
1397: and ORGANIZATION_ID = l_fs_arr_org_id_tbl(i);
1398: EXCEPTION
1399: WHEN NO_DATA_FOUND THEN
1400: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1401: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- No Fct Designator Defined ----');
1402: END IF;
1403: IF (p_concurrent_flag = 'Y') THEN
1404: fnd_file.put_line(fnd_file.log, ' ----No MTBF Data Found -- No Forecast Designator Found ----');

Line 1401: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- No Fct Designator Defined ----');

1397: and ORGANIZATION_ID = l_fs_arr_org_id_tbl(i);
1398: EXCEPTION
1399: WHEN NO_DATA_FOUND THEN
1400: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1401: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- No Fct Designator Defined ----');
1402: END IF;
1403: IF (p_concurrent_flag = 'Y') THEN
1404: fnd_file.put_line(fnd_file.log, ' ----No MTBF Data Found -- No Forecast Designator Found ----');
1405: END IF;

Line 1408: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1404: fnd_file.put_line(fnd_file.log, ' ----No MTBF Data Found -- No Forecast Designator Found ----');
1405: END IF;
1406: l_fct_designator := null;
1407: WHEN TOO_MANY_ROWS THEN
1408: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1409: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- TOO_MANY_ROWS EXEC BLOCK -H- ORG_ID ----- '||l_fs_arr_org_id_tbl(i));
1410: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- TOO_MANY_ROWS EXEC BLOCK -H- l_prob_value ----- '||l_prob_value);
1411: END IF;
1412: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1409: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- TOO_MANY_ROWS EXEC BLOCK -H- ORG_ID ----- '||l_fs_arr_org_id_tbl(i));

1405: END IF;
1406: l_fct_designator := null;
1407: WHEN TOO_MANY_ROWS THEN
1408: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1409: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- TOO_MANY_ROWS EXEC BLOCK -H- ORG_ID ----- '||l_fs_arr_org_id_tbl(i));
1410: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- TOO_MANY_ROWS EXEC BLOCK -H- l_prob_value ----- '||l_prob_value);
1411: END IF;
1412: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1413: WHEN OTHERS THEN

Line 1410: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- TOO_MANY_ROWS EXEC BLOCK -H- l_prob_value ----- '||l_prob_value);

1406: l_fct_designator := null;
1407: WHEN TOO_MANY_ROWS THEN
1408: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1409: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- TOO_MANY_ROWS EXEC BLOCK -H- ORG_ID ----- '||l_fs_arr_org_id_tbl(i));
1410: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- TOO_MANY_ROWS EXEC BLOCK -H- l_prob_value ----- '||l_prob_value);
1411: END IF;
1412: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1413: WHEN OTHERS THEN
1414: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1414: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1410: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- TOO_MANY_ROWS EXEC BLOCK -H- l_prob_value ----- '||l_prob_value);
1411: END IF;
1412: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1413: WHEN OTHERS THEN
1414: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1415: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- OTHERS EXEC BLOCK -H- ORG_ID ----- '||l_fs_arr_org_id_tbl(i));
1416: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- OTHERS EXEC BLOCK -H- l_prob_value ----- '||l_prob_value);
1417: END IF;
1418: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1415: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- OTHERS EXEC BLOCK -H- ORG_ID ----- '||l_fs_arr_org_id_tbl(i));

1411: END IF;
1412: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1413: WHEN OTHERS THEN
1414: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1415: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- OTHERS EXEC BLOCK -H- ORG_ID ----- '||l_fs_arr_org_id_tbl(i));
1416: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- OTHERS EXEC BLOCK -H- l_prob_value ----- '||l_prob_value);
1417: END IF;
1418: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1419: END;

Line 1416: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- OTHERS EXEC BLOCK -H- l_prob_value ----- '||l_prob_value);

1412: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1413: WHEN OTHERS THEN
1414: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1415: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- OTHERS EXEC BLOCK -H- ORG_ID ----- '||l_fs_arr_org_id_tbl(i));
1416: fnd_log.string(fnd_log.level_statement,l_full_name,' ----- OTHERS EXEC BLOCK -H- l_prob_value ----- '||l_prob_value);
1417: END IF;
1418: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1419: END;
1420: ELSE

Line 1421: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1417: END IF;
1418: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1419: END;
1420: ELSE
1421: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1422: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- l_prob_value -- for historical--'||l_prob_value);
1423: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- Since the derived Prob Value is Zero -- Assigning null to l_fct_designator--');
1424: END IF;
1425: l_fct_designator := null;

Line 1422: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- l_prob_value -- for historical--'||l_prob_value);

1418: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1419: END;
1420: ELSE
1421: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1422: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- l_prob_value -- for historical--'||l_prob_value);
1423: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- Since the derived Prob Value is Zero -- Assigning null to l_fct_designator--');
1424: END IF;
1425: l_fct_designator := null;
1426: END IF; --IF l_prob_value > 0

Line 1423: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- Since the derived Prob Value is Zero -- Assigning null to l_fct_designator--');

1419: END;
1420: ELSE
1421: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1422: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- l_prob_value -- for historical--'||l_prob_value);
1423: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- Since the derived Prob Value is Zero -- Assigning null to l_fct_designator--');
1424: END IF;
1425: l_fct_designator := null;
1426: END IF; --IF l_prob_value > 0
1427:

Line 1429: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1425: l_fct_designator := null;
1426: END IF; --IF l_prob_value > 0
1427:
1428: ELSE -- This Code Should not be executed -- Extra redundant check
1429: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1430: fnd_log.string(fnd_log.level_statement,l_full_name,' ----No Path Position Found -- so ----');
1431: fnd_log.string(fnd_log.level_statement,l_full_name,' ----Set Fct Assoc Designator to NULL and Continue ----');
1432: fnd_log.string(fnd_log.level_statement,l_full_name,' ----This Code Should not be executed -- Extra redundant check ----');
1433: END IF;

Line 1430: fnd_log.string(fnd_log.level_statement,l_full_name,' ----No Path Position Found -- so ----');

1426: END IF; --IF l_prob_value > 0
1427:
1428: ELSE -- This Code Should not be executed -- Extra redundant check
1429: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1430: fnd_log.string(fnd_log.level_statement,l_full_name,' ----No Path Position Found -- so ----');
1431: fnd_log.string(fnd_log.level_statement,l_full_name,' ----Set Fct Assoc Designator to NULL and Continue ----');
1432: fnd_log.string(fnd_log.level_statement,l_full_name,' ----This Code Should not be executed -- Extra redundant check ----');
1433: END IF;
1434: IF (p_concurrent_flag = 'Y') THEN

Line 1431: fnd_log.string(fnd_log.level_statement,l_full_name,' ----Set Fct Assoc Designator to NULL and Continue ----');

1427:
1428: ELSE -- This Code Should not be executed -- Extra redundant check
1429: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1430: fnd_log.string(fnd_log.level_statement,l_full_name,' ----No Path Position Found -- so ----');
1431: fnd_log.string(fnd_log.level_statement,l_full_name,' ----Set Fct Assoc Designator to NULL and Continue ----');
1432: fnd_log.string(fnd_log.level_statement,l_full_name,' ----This Code Should not be executed -- Extra redundant check ----');
1433: END IF;
1434: IF (p_concurrent_flag = 'Y') THEN
1435: fnd_file.put_line(fnd_file.log, ' ----No Path Position Found -- so ----');

Line 1432: fnd_log.string(fnd_log.level_statement,l_full_name,' ----This Code Should not be executed -- Extra redundant check ----');

1428: ELSE -- This Code Should not be executed -- Extra redundant check
1429: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1430: fnd_log.string(fnd_log.level_statement,l_full_name,' ----No Path Position Found -- so ----');
1431: fnd_log.string(fnd_log.level_statement,l_full_name,' ----Set Fct Assoc Designator to NULL and Continue ----');
1432: fnd_log.string(fnd_log.level_statement,l_full_name,' ----This Code Should not be executed -- Extra redundant check ----');
1433: END IF;
1434: IF (p_concurrent_flag = 'Y') THEN
1435: fnd_file.put_line(fnd_file.log, ' ----No Path Position Found -- so ----');
1436: fnd_file.put_line(fnd_file.log, ' ----Set Fct Assoc Designator to NULL and Continue ----');

Line 1441: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1437: END IF;
1438: l_fct_designator := null;
1439: END IF;
1440: ELSE
1441: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1442: fnd_log.string(fnd_log.level_statement,l_full_name,' ----No Path Position Found -- First Check -- so bypass ----');
1443: fnd_log.string(fnd_log.level_statement,l_full_name,' ----Set Fct Assoc Designator to NULL and Continue ----');
1444: END IF;
1445: IF (p_concurrent_flag = 'Y') THEN

Line 1442: fnd_log.string(fnd_log.level_statement,l_full_name,' ----No Path Position Found -- First Check -- so bypass ----');

1438: l_fct_designator := null;
1439: END IF;
1440: ELSE
1441: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1442: fnd_log.string(fnd_log.level_statement,l_full_name,' ----No Path Position Found -- First Check -- so bypass ----');
1443: fnd_log.string(fnd_log.level_statement,l_full_name,' ----Set Fct Assoc Designator to NULL and Continue ----');
1444: END IF;
1445: IF (p_concurrent_flag = 'Y') THEN
1446: fnd_file.put_line(fnd_file.log, ' ----No Path Position Found -- First Check -- so bypass ----');

Line 1443: fnd_log.string(fnd_log.level_statement,l_full_name,' ----Set Fct Assoc Designator to NULL and Continue ----');

1439: END IF;
1440: ELSE
1441: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1442: fnd_log.string(fnd_log.level_statement,l_full_name,' ----No Path Position Found -- First Check -- so bypass ----');
1443: fnd_log.string(fnd_log.level_statement,l_full_name,' ----Set Fct Assoc Designator to NULL and Continue ----');
1444: END IF;
1445: IF (p_concurrent_flag = 'Y') THEN
1446: fnd_file.put_line(fnd_file.log, ' ----No Path Position Found -- First Check -- so bypass ----');
1447: END IF;

Line 1453: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1449: END IF; -- l_path_pos_exist_flag = 'Y'
1450: END IF; -- l_mtbf_data_defined -- Y or N
1451:
1452: IF l_fct_designator IS NOT NULL THEN
1453: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1454: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Prepare IO Interface Data -- ');
1455: fnd_log.string(fnd_log.level_statement,l_full_name,' -- l_fct_designator -- ' || l_fct_designator);
1456: END IF;
1457: IF (p_concurrent_flag = 'Y') THEN

Line 1454: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Prepare IO Interface Data -- ');

1450: END IF; -- l_mtbf_data_defined -- Y or N
1451:
1452: IF l_fct_designator IS NOT NULL THEN
1453: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1454: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Prepare IO Interface Data -- ');
1455: fnd_log.string(fnd_log.level_statement,l_full_name,' -- l_fct_designator -- ' || l_fct_designator);
1456: END IF;
1457: IF (p_concurrent_flag = 'Y') THEN
1458: fnd_file.put_line(fnd_file.log, ' -- Preparing IO Interface Data -- ');

Line 1455: fnd_log.string(fnd_log.level_statement,l_full_name,' -- l_fct_designator -- ' || l_fct_designator);

1451:
1452: IF l_fct_designator IS NOT NULL THEN
1453: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1454: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Prepare IO Interface Data -- ');
1455: fnd_log.string(fnd_log.level_statement,l_full_name,' -- l_fct_designator -- ' || l_fct_designator);
1456: END IF;
1457: IF (p_concurrent_flag = 'Y') THEN
1458: fnd_file.put_line(fnd_file.log, ' -- Preparing IO Interface Data -- ');
1459: END IF;

Line 1509: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1505:
1506: IF (p_concurrent_flag = 'Y') THEN
1507: fnd_file.put_line(fnd_file.log, ' -- Preparing Designator Interface Data -- ');
1508: END IF;
1509: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1510: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Preparing Designator Interface Data -- ');
1511: END IF;
1512:
1513: IF l_forecast_designator_tbl.COUNT > 0 THEN

Line 1510: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Preparing Designator Interface Data -- ');

1506: IF (p_concurrent_flag = 'Y') THEN
1507: fnd_file.put_line(fnd_file.log, ' -- Preparing Designator Interface Data -- ');
1508: END IF;
1509: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1510: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Preparing Designator Interface Data -- ');
1511: END IF;
1512:
1513: IF l_forecast_designator_tbl.COUNT > 0 THEN
1514: FOR d in l_forecast_designator_tbl.FIRST .. l_forecast_designator_tbl.LAST LOOP

Line 1520: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1516: l_ds_rec_found := 'Y';
1517: IF (p_concurrent_flag = 'Y') THEN
1518: fnd_file.put_line(fnd_file.log, ' -- Designator already exists in Interface Data -- ');
1519: END IF;
1520: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1521: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Designator already exists in Interface Data -- ');
1522: END IF;
1523: EXIT;
1524: END IF;

Line 1521: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Designator already exists in Interface Data -- ');

1517: IF (p_concurrent_flag = 'Y') THEN
1518: fnd_file.put_line(fnd_file.log, ' -- Designator already exists in Interface Data -- ');
1519: END IF;
1520: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1521: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Designator already exists in Interface Data -- ');
1522: END IF;
1523: EXIT;
1524: END IF;
1525: END LOOP;

Line 1530: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1526: IF l_ds_rec_found = 'N' THEN
1527: IF (p_concurrent_flag = 'Y') THEN
1528: fnd_file.put_line(fnd_file.log, ' -- Designator does not exists in Interface Data -- ');
1529: END IF;
1530: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1531: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Designator does not exists in Interface Data -- ');
1532: END IF;
1533: l_forecast_designator_tbl(l_dsg_index).ORGANIZATION_ID := l_fs_arr_org_id_tbl(i);
1534: l_forecast_designator_tbl(l_dsg_index).FORECAST_DESIGNATOR := l_fct_designator;

Line 1531: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Designator does not exists in Interface Data -- ');

1527: IF (p_concurrent_flag = 'Y') THEN
1528: fnd_file.put_line(fnd_file.log, ' -- Designator does not exists in Interface Data -- ');
1529: END IF;
1530: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1531: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Designator does not exists in Interface Data -- ');
1532: END IF;
1533: l_forecast_designator_tbl(l_dsg_index).ORGANIZATION_ID := l_fs_arr_org_id_tbl(i);
1534: l_forecast_designator_tbl(l_dsg_index).FORECAST_DESIGNATOR := l_fct_designator;
1535: l_dsg_index := l_dsg_index + 1;

Line 1541: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1537: ELSE
1538: IF (p_concurrent_flag = 'Y') THEN
1539: fnd_file.put_line(fnd_file.log, ' -- Inserting first rec in Designator Data -- ');
1540: END IF;
1541: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1542: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Insertinf first rec in Designator Data -- ');
1543: END IF;
1544: l_forecast_designator_tbl(l_dsg_index).ORGANIZATION_ID := l_fs_arr_org_id_tbl(i);
1545: l_forecast_designator_tbl(l_dsg_index).FORECAST_DESIGNATOR := l_fct_designator;

Line 1542: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Insertinf first rec in Designator Data -- ');

1538: IF (p_concurrent_flag = 'Y') THEN
1539: fnd_file.put_line(fnd_file.log, ' -- Inserting first rec in Designator Data -- ');
1540: END IF;
1541: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1542: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Insertinf first rec in Designator Data -- ');
1543: END IF;
1544: l_forecast_designator_tbl(l_dsg_index).ORGANIZATION_ID := l_fs_arr_org_id_tbl(i);
1545: l_forecast_designator_tbl(l_dsg_index).FORECAST_DESIGNATOR := l_fct_designator;
1546: l_dsg_index := l_dsg_index + 1;

Line 1563: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1559:
1560: MSC_ATP_GLOBAL.GET_ATP_SESSION_ID(l_session_id,l_return_status);
1561:
1562: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1563: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1564: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API MSC_ATP_GLOBAL.GET_SESSION_ID U Errored');
1565: END IF;
1566: IF (p_concurrent_flag = 'Y') THEN
1567: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting on Session Id --');

Line 1564: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API MSC_ATP_GLOBAL.GET_SESSION_ID U Errored');

1560: MSC_ATP_GLOBAL.GET_ATP_SESSION_ID(l_session_id,l_return_status);
1561:
1562: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1563: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1564: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API MSC_ATP_GLOBAL.GET_SESSION_ID U Errored');
1565: END IF;
1566: IF (p_concurrent_flag = 'Y') THEN
1567: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting on Session Id --');
1568: END IF;

Line 1571: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1567: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting on Session Id --');
1568: END IF;
1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1570: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1571: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1572: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API MSC_ATP_GLOBAL.GET_SESSION_ID E Errored');
1573: END IF;
1574: IF (p_concurrent_flag = 'Y') THEN
1575: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting on Session Id');

Line 1572: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API MSC_ATP_GLOBAL.GET_SESSION_ID E Errored');

1568: END IF;
1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1570: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1571: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1572: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API MSC_ATP_GLOBAL.GET_SESSION_ID E Errored');
1573: END IF;
1574: IF (p_concurrent_flag = 'Y') THEN
1575: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting on Session Id');
1576: END IF;

Line 1600: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1596:
1597: IF (p_concurrent_flag = 'Y') THEN
1598: fnd_file.put_line(fnd_file.log, ' - B - Calling ATP API -- ' || l_dtls_inv_item_id_tbl(j));
1599: END IF;
1600: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1601: fnd_log.string(fnd_log.level_statement,l_full_name,' -B- Calling ATP API -- ' || l_dtls_inv_item_id_tbl(j));
1602: END IF;
1603:
1604: MRP_ATP_PUB.Call_ATP (l_session_id,

Line 1601: fnd_log.string(fnd_log.level_statement,l_full_name,' -B- Calling ATP API -- ' || l_dtls_inv_item_id_tbl(j));

1597: IF (p_concurrent_flag = 'Y') THEN
1598: fnd_file.put_line(fnd_file.log, ' - B - Calling ATP API -- ' || l_dtls_inv_item_id_tbl(j));
1599: END IF;
1600: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1601: fnd_log.string(fnd_log.level_statement,l_full_name,' -B- Calling ATP API -- ' || l_dtls_inv_item_id_tbl(j));
1602: END IF;
1603:
1604: MRP_ATP_PUB.Call_ATP (l_session_id,
1605: l_atp_rec,

Line 1616: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1612: l_msg_count
1613: );
1614:
1615: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1616: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1617: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API MRP_ATP_PUB.Call_ATP U Errored');
1618: END IF;
1619: IF (p_concurrent_flag = 'Y') THEN
1620: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting on Hand Quantity --' || l_session_id);

Line 1617: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API MRP_ATP_PUB.Call_ATP U Errored');

1613: );
1614:
1615: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1616: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1617: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API MRP_ATP_PUB.Call_ATP U Errored');
1618: END IF;
1619: IF (p_concurrent_flag = 'Y') THEN
1620: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting on Hand Quantity --' || l_session_id);
1621: END IF;

Line 1624: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1620: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting on Hand Quantity --' || l_session_id);
1621: END IF;
1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1623: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1624: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1625: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API MRP_ATP_PUB.Call_ATP E Errored');
1626: END IF;
1627: IF (p_concurrent_flag = 'Y') THEN
1628: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting on Hand Quantity --' || l_session_id);

Line 1625: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API MRP_ATP_PUB.Call_ATP E Errored');

1621: END IF;
1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1623: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1624: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1625: fnd_log.string(fnd_log.level_statement,l_full_name,'Called API MRP_ATP_PUB.Call_ATP E Errored');
1626: END IF;
1627: IF (p_concurrent_flag = 'Y') THEN
1628: fnd_file.put_line(fnd_file.log, 'RA Analyser Process ---- Error in getting on Hand Quantity --' || l_session_id);
1629: END IF;

Line 1636: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1632:
1633: IF (p_concurrent_flag = 'Y') THEN
1634: fnd_file.put_line(fnd_file.log, ' - A - Calling ATP API -- ' || x_atp_rec.Requested_Date_Quantity(1));
1635: END IF;
1636: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1637: fnd_log.string(fnd_log.level_statement,l_full_name,' -A- Calling ATP API -- ' || l_dtls_inv_item_id_tbl(j));
1638: END IF;
1639:
1640: l_forecast_onhand_qty_tbl(l_fct_index) := nvl(x_atp_rec.Requested_Date_Quantity(1),0);

Line 1637: fnd_log.string(fnd_log.level_statement,l_full_name,' -A- Calling ATP API -- ' || l_dtls_inv_item_id_tbl(j));

1633: IF (p_concurrent_flag = 'Y') THEN
1634: fnd_file.put_line(fnd_file.log, ' - A - Calling ATP API -- ' || x_atp_rec.Requested_Date_Quantity(1));
1635: END IF;
1636: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1637: fnd_log.string(fnd_log.level_statement,l_full_name,' -A- Calling ATP API -- ' || l_dtls_inv_item_id_tbl(j));
1638: END IF;
1639:
1640: l_forecast_onhand_qty_tbl(l_fct_index) := nvl(x_atp_rec.Requested_Date_Quantity(1),0);
1641:

Line 1655: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1651:
1652: IF (p_concurrent_flag = 'Y') THEN
1653: fnd_file.put_line(fnd_file.log, ' - B - Deriving VWP Figure -- ');
1654: END IF;
1655: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1656: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Deriving VWP Figure -- ');
1657: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item ID -- '||l_dtls_inv_item_id_tbl(j));
1658: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item Org ID -- '||l_dtls_inv_master_org_id_tbl(j));
1659: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item Revision -- '||l_dtls_inv_revision_tbl(j));

Line 1656: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Deriving VWP Figure -- ');

1652: IF (p_concurrent_flag = 'Y') THEN
1653: fnd_file.put_line(fnd_file.log, ' - B - Deriving VWP Figure -- ');
1654: END IF;
1655: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1656: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Deriving VWP Figure -- ');
1657: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item ID -- '||l_dtls_inv_item_id_tbl(j));
1658: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item Org ID -- '||l_dtls_inv_master_org_id_tbl(j));
1659: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item Revision -- '||l_dtls_inv_revision_tbl(j));
1660: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Arrival Org -- '||l_fs_arr_org_id_tbl(i));

Line 1657: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item ID -- '||l_dtls_inv_item_id_tbl(j));

1653: fnd_file.put_line(fnd_file.log, ' - B - Deriving VWP Figure -- ');
1654: END IF;
1655: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1656: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Deriving VWP Figure -- ');
1657: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item ID -- '||l_dtls_inv_item_id_tbl(j));
1658: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item Org ID -- '||l_dtls_inv_master_org_id_tbl(j));
1659: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item Revision -- '||l_dtls_inv_revision_tbl(j));
1660: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Arrival Org -- '||l_fs_arr_org_id_tbl(i));
1661: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Arrival Date -- '||l_fs_arrival_date_tbl(i));

Line 1658: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item Org ID -- '||l_dtls_inv_master_org_id_tbl(j));

1654: END IF;
1655: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1656: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Deriving VWP Figure -- ');
1657: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item ID -- '||l_dtls_inv_item_id_tbl(j));
1658: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item Org ID -- '||l_dtls_inv_master_org_id_tbl(j));
1659: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item Revision -- '||l_dtls_inv_revision_tbl(j));
1660: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Arrival Org -- '||l_fs_arr_org_id_tbl(i));
1661: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Arrival Date -- '||l_fs_arrival_date_tbl(i));
1662: END IF;

Line 1659: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item Revision -- '||l_dtls_inv_revision_tbl(j));

1655: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1656: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Deriving VWP Figure -- ');
1657: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item ID -- '||l_dtls_inv_item_id_tbl(j));
1658: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item Org ID -- '||l_dtls_inv_master_org_id_tbl(j));
1659: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item Revision -- '||l_dtls_inv_revision_tbl(j));
1660: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Arrival Org -- '||l_fs_arr_org_id_tbl(i));
1661: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Arrival Date -- '||l_fs_arrival_date_tbl(i));
1662: END IF;
1663:

Line 1660: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Arrival Org -- '||l_fs_arr_org_id_tbl(i));

1656: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Deriving VWP Figure -- ');
1657: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item ID -- '||l_dtls_inv_item_id_tbl(j));
1658: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item Org ID -- '||l_dtls_inv_master_org_id_tbl(j));
1659: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item Revision -- '||l_dtls_inv_revision_tbl(j));
1660: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Arrival Org -- '||l_fs_arr_org_id_tbl(i));
1661: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Arrival Date -- '||l_fs_arrival_date_tbl(i));
1662: END IF;
1663:
1664: Select nvl(sum(nvl(QTY_GRP,0)),0) QTY

Line 1661: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Arrival Date -- '||l_fs_arrival_date_tbl(i));

1657: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item ID -- '||l_dtls_inv_item_id_tbl(j));
1658: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item Org ID -- '||l_dtls_inv_master_org_id_tbl(j));
1659: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Item Revision -- '||l_dtls_inv_revision_tbl(j));
1660: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Arrival Org -- '||l_fs_arr_org_id_tbl(i));
1661: fnd_log.string(fnd_log.level_statement,l_full_name,' - B - Param - Arrival Date -- '||l_fs_arrival_date_tbl(i));
1662: END IF;
1663:
1664: Select nvl(sum(nvl(QTY_GRP,0)),0) QTY
1665: INTO l_forecast_vwp_qty_tbl(l_fct_index)

Line 1784: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1780:
1781: IF (p_concurrent_flag = 'Y') THEN
1782: fnd_file.put_line(fnd_file.log, ' - A - Deriving VWP Figure -- ' || l_forecast_vwp_qty_tbl(l_fct_index));
1783: END IF;
1784: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1785: fnd_log.string(fnd_log.level_statement,l_full_name,' - A - Deriving VWP Figure -- ' || l_forecast_vwp_qty_tbl(l_fct_index));
1786: END IF;
1787:
1788: SELECT nvl(SUM(nvl(TRANSACTION_QUANTITY,0)),0)

Line 1785: fnd_log.string(fnd_log.level_statement,l_full_name,' - A - Deriving VWP Figure -- ' || l_forecast_vwp_qty_tbl(l_fct_index));

1781: IF (p_concurrent_flag = 'Y') THEN
1782: fnd_file.put_line(fnd_file.log, ' - A - Deriving VWP Figure -- ' || l_forecast_vwp_qty_tbl(l_fct_index));
1783: END IF;
1784: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1785: fnd_log.string(fnd_log.level_statement,l_full_name,' - A - Deriving VWP Figure -- ' || l_forecast_vwp_qty_tbl(l_fct_index));
1786: END IF;
1787:
1788: SELECT nvl(SUM(nvl(TRANSACTION_QUANTITY,0)),0)
1789: INTO l_forecast_non_qty_tbl(l_fct_index)

Line 1813: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1809: -- 100% exactly, is marked as a User Setup Data Creation Outline.
1810: IF (p_concurrent_flag = 'Y') THEN
1811: fnd_file.put_line(fnd_file.log, ' -- Creating Dummy Data in FCT Interface Table -- ');
1812: END IF;
1813: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1814: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Creating Dummy Data in FCT Interface Table -- ');
1815: END IF;
1816:
1817: IF l_mtbf_data_defined = 'N' THEN

Line 1814: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Creating Dummy Data in FCT Interface Table -- ');

1810: IF (p_concurrent_flag = 'Y') THEN
1811: fnd_file.put_line(fnd_file.log, ' -- Creating Dummy Data in FCT Interface Table -- ');
1812: END IF;
1813: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1814: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Creating Dummy Data in FCT Interface Table -- ');
1815: END IF;
1816:
1817: IF l_mtbf_data_defined = 'N' THEN
1818: -- Dummy Data is created only if Prob of Failure is derived using Historical Data

Line 1825: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1821:
1822: IF (p_concurrent_flag = 'Y') THEN
1823: fnd_file.put_line(fnd_file.log, ' ---- FETCHING FCT ASSOCIATIONS ----');
1824: END IF;
1825: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1826: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- FETCHING FCT ASSOCIATIONS ----');
1827: END IF;
1828: OPEN c_fetch_dummy_assocs(l_fct_designator,l_fs_arr_org_id_tbl(i));
1829: FETCH c_fetch_dummy_assocs

Line 1826: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- FETCHING FCT ASSOCIATIONS ----');

1822: IF (p_concurrent_flag = 'Y') THEN
1823: fnd_file.put_line(fnd_file.log, ' ---- FETCHING FCT ASSOCIATIONS ----');
1824: END IF;
1825: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1826: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- FETCHING FCT ASSOCIATIONS ----');
1827: END IF;
1828: OPEN c_fetch_dummy_assocs(l_fct_designator,l_fs_arr_org_id_tbl(i));
1829: FETCH c_fetch_dummy_assocs
1830: BULK COLLECT INTO l_dummy_fct_desg_tbl;

Line 1832: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1828: OPEN c_fetch_dummy_assocs(l_fct_designator,l_fs_arr_org_id_tbl(i));
1829: FETCH c_fetch_dummy_assocs
1830: BULK COLLECT INTO l_dummy_fct_desg_tbl;
1831: IF l_dummy_fct_desg_tbl.COUNT = 0 THEN
1832: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1833: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- NO DUMMY FCT ASSOCIATIONS DERIVED ----');
1834: END IF;
1835: ELSE
1836: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1833: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- NO DUMMY FCT ASSOCIATIONS DERIVED ----');

1829: FETCH c_fetch_dummy_assocs
1830: BULK COLLECT INTO l_dummy_fct_desg_tbl;
1831: IF l_dummy_fct_desg_tbl.COUNT = 0 THEN
1832: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1833: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- NO DUMMY FCT ASSOCIATIONS DERIVED ----');
1834: END IF;
1835: ELSE
1836: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1837: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- DUMMY FCT ASSOCIATIONS RETRIEVED----');

Line 1836: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1832: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1833: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- NO DUMMY FCT ASSOCIATIONS DERIVED ----');
1834: END IF;
1835: ELSE
1836: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1837: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- DUMMY FCT ASSOCIATIONS RETRIEVED----');
1838: END IF;
1839: END IF;
1840: CLOSE c_fetch_dummy_assocs;

Line 1837: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- DUMMY FCT ASSOCIATIONS RETRIEVED----');

1833: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- NO DUMMY FCT ASSOCIATIONS DERIVED ----');
1834: END IF;
1835: ELSE
1836: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1837: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- DUMMY FCT ASSOCIATIONS RETRIEVED----');
1838: END IF;
1839: END IF;
1840: CLOSE c_fetch_dummy_assocs;
1841:

Line 1843: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1839: END IF;
1840: CLOSE c_fetch_dummy_assocs;
1841:
1842: IF l_dummy_fct_desg_tbl.COUNT > 0 THEN
1843: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1844: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- INSERTING MRP Recs for Dummy FCT ASSOCIATIONS ----');
1845: END IF;
1846: IF (p_concurrent_flag = 'Y') THEN
1847: fnd_file.put_line(fnd_file.log, ' ---- INSERTING MRP Recs for Dummy FCT ASSOCIATIONS ----');

Line 1844: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- INSERTING MRP Recs for Dummy FCT ASSOCIATIONS ----');

1840: CLOSE c_fetch_dummy_assocs;
1841:
1842: IF l_dummy_fct_desg_tbl.COUNT > 0 THEN
1843: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1844: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- INSERTING MRP Recs for Dummy FCT ASSOCIATIONS ----');
1845: END IF;
1846: IF (p_concurrent_flag = 'Y') THEN
1847: fnd_file.put_line(fnd_file.log, ' ---- INSERTING MRP Recs for Dummy FCT ASSOCIATIONS ----');
1848: END IF;

Line 1850: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1846: IF (p_concurrent_flag = 'Y') THEN
1847: fnd_file.put_line(fnd_file.log, ' ---- INSERTING MRP Recs for Dummy FCT ASSOCIATIONS ----');
1848: END IF;
1849: for f in l_dummy_fct_desg_tbl.FIRST .. l_dummy_fct_desg_tbl.LAST LOOP
1850: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1851: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- INSERTING FOR DUMMY ASSOC ----' || l_dummy_fct_desg_tbl(f));
1852: END IF;
1853:
1854: l_forecast_interface_tbl(l_fct_index).INVENTORY_ITEM_ID := l_dtls_inv_item_id_tbl(j);

Line 1851: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- INSERTING FOR DUMMY ASSOC ----' || l_dummy_fct_desg_tbl(f));

1847: fnd_file.put_line(fnd_file.log, ' ---- INSERTING MRP Recs for Dummy FCT ASSOCIATIONS ----');
1848: END IF;
1849: for f in l_dummy_fct_desg_tbl.FIRST .. l_dummy_fct_desg_tbl.LAST LOOP
1850: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1851: fnd_log.string(fnd_log.level_statement,l_full_name,' ---- INSERTING FOR DUMMY ASSOC ----' || l_dummy_fct_desg_tbl(f));
1852: END IF;
1853:
1854: l_forecast_interface_tbl(l_fct_index).INVENTORY_ITEM_ID := l_dtls_inv_item_id_tbl(j);
1855: l_forecast_interface_tbl(l_fct_index).FORECAST_DESIGNATOR := l_dummy_fct_desg_tbl(f);

Line 1900: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1896: l_forecast_interface_tbl(l_fct_index).ACTION := 'I';
1897: l_forecast_interface_tbl(l_fct_index).ATTRIBUTE_CATEGORY := null;
1898:
1899:
1900: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1901: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Preparing Designator Interface Data -DUMMY- ');
1902: END IF;
1903:
1904: IF l_forecast_designator_tbl.COUNT > 0 THEN

Line 1901: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Preparing Designator Interface Data -DUMMY- ');

1897: l_forecast_interface_tbl(l_fct_index).ATTRIBUTE_CATEGORY := null;
1898:
1899:
1900: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1901: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Preparing Designator Interface Data -DUMMY- ');
1902: END IF;
1903:
1904: IF l_forecast_designator_tbl.COUNT > 0 THEN
1905: FOR h in l_forecast_designator_tbl.FIRST .. l_forecast_designator_tbl.LAST LOOP

Line 1908: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1904: IF l_forecast_designator_tbl.COUNT > 0 THEN
1905: FOR h in l_forecast_designator_tbl.FIRST .. l_forecast_designator_tbl.LAST LOOP
1906: IF l_forecast_designator_tbl(h).FORECAST_DESIGNATOR = l_dummy_fct_desg_tbl(f) THEN
1907: l_ds_rec_found := 'Y';
1908: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1909: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Designator already exists in Interface Data -DUMMY- ');
1910: END IF;
1911: EXIT;
1912: END IF;

Line 1909: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Designator already exists in Interface Data -DUMMY- ');

1905: FOR h in l_forecast_designator_tbl.FIRST .. l_forecast_designator_tbl.LAST LOOP
1906: IF l_forecast_designator_tbl(h).FORECAST_DESIGNATOR = l_dummy_fct_desg_tbl(f) THEN
1907: l_ds_rec_found := 'Y';
1908: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1909: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Designator already exists in Interface Data -DUMMY- ');
1910: END IF;
1911: EXIT;
1912: END IF;
1913: END LOOP;

Line 1915: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1911: EXIT;
1912: END IF;
1913: END LOOP;
1914: IF l_ds_rec_found = 'N' THEN
1915: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1916: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Designator does not exists in Interface Data -DUMMY- ');
1917: END IF;
1918: l_forecast_designator_tbl(l_dsg_index).ORGANIZATION_ID := l_fs_arr_org_id_tbl(i);
1919: l_forecast_designator_tbl(l_dsg_index).FORECAST_DESIGNATOR := l_dummy_fct_desg_tbl(f);

Line 1916: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Designator does not exists in Interface Data -DUMMY- ');

1912: END IF;
1913: END LOOP;
1914: IF l_ds_rec_found = 'N' THEN
1915: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1916: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Designator does not exists in Interface Data -DUMMY- ');
1917: END IF;
1918: l_forecast_designator_tbl(l_dsg_index).ORGANIZATION_ID := l_fs_arr_org_id_tbl(i);
1919: l_forecast_designator_tbl(l_dsg_index).FORECAST_DESIGNATOR := l_dummy_fct_desg_tbl(f);
1920: l_dsg_index := l_dsg_index + 1;

Line 1923: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1919: l_forecast_designator_tbl(l_dsg_index).FORECAST_DESIGNATOR := l_dummy_fct_desg_tbl(f);
1920: l_dsg_index := l_dsg_index + 1;
1921: END IF;
1922: ELSE
1923: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1924: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Inserting first rec in Designator Data -DUMMY- ');
1925: END IF;
1926: l_forecast_designator_tbl(l_dsg_index).ORGANIZATION_ID := l_fs_arr_org_id_tbl(i);
1927: l_forecast_designator_tbl(l_dsg_index).FORECAST_DESIGNATOR := l_dummy_fct_desg_tbl(f);

Line 1924: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Inserting first rec in Designator Data -DUMMY- ');

1920: l_dsg_index := l_dsg_index + 1;
1921: END IF;
1922: ELSE
1923: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1924: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Inserting first rec in Designator Data -DUMMY- ');
1925: END IF;
1926: l_forecast_designator_tbl(l_dsg_index).ORGANIZATION_ID := l_fs_arr_org_id_tbl(i);
1927: l_forecast_designator_tbl(l_dsg_index).FORECAST_DESIGNATOR := l_dummy_fct_desg_tbl(f);
1928: l_dsg_index := l_dsg_index + 1;

Line 1954: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1950: fnd_file.put_line(fnd_file.log, ' -- Prepared IO Interface Data -- ');
1951: END IF;
1952:
1953: ELSE -- l_fct_designator IS NULL
1954: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1955: fnd_log.string(fnd_log.level_statement,l_full_name,' -- No Fct Designator Found -- ');
1956: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Jump to Next instance -- ' || l_fct_designator);
1957: END IF;
1958:

Line 1955: fnd_log.string(fnd_log.level_statement,l_full_name,' -- No Fct Designator Found -- ');

1951: END IF;
1952:
1953: ELSE -- l_fct_designator IS NULL
1954: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1955: fnd_log.string(fnd_log.level_statement,l_full_name,' -- No Fct Designator Found -- ');
1956: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Jump to Next instance -- ' || l_fct_designator);
1957: END IF;
1958:
1959: IF (p_concurrent_flag = 'Y') THEN

Line 1956: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Jump to Next instance -- ' || l_fct_designator);

1952:
1953: ELSE -- l_fct_designator IS NULL
1954: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1955: fnd_log.string(fnd_log.level_statement,l_full_name,' -- No Fct Designator Found -- ');
1956: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Jump to Next instance -- ' || l_fct_designator);
1957: END IF;
1958:
1959: IF (p_concurrent_flag = 'Y') THEN
1960: fnd_file.put_line(fnd_file.log, ' -- No Fct Designator Found so No Interfacing to be done -- ');

Line 1966: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1962:
1963: END IF;
1964:
1965: ELSE -- l_active_ctr_id_tbl.COUNT = 0
1966: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1967: fnd_log.string(fnd_log.level_statement,l_full_name,' -- No Matching ACTIVE COUNTERS derived -- ');
1968: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Move to next item instace -- l_dtls_subject_id_tbl - '||l_dtls_subject_id_tbl(j));
1969: END IF;
1970: IF (p_concurrent_flag = 'Y') THEN

Line 1967: fnd_log.string(fnd_log.level_statement,l_full_name,' -- No Matching ACTIVE COUNTERS derived -- ');

1963: END IF;
1964:
1965: ELSE -- l_active_ctr_id_tbl.COUNT = 0
1966: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1967: fnd_log.string(fnd_log.level_statement,l_full_name,' -- No Matching ACTIVE COUNTERS derived -- ');
1968: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Move to next item instace -- l_dtls_subject_id_tbl - '||l_dtls_subject_id_tbl(j));
1969: END IF;
1970: IF (p_concurrent_flag = 'Y') THEN
1971: fnd_file.put_line(fnd_file.log, ' -- No Matching ACTIVE COUNTERS derived -- ');

Line 1968: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Move to next item instace -- l_dtls_subject_id_tbl - '||l_dtls_subject_id_tbl(j));

1964:
1965: ELSE -- l_active_ctr_id_tbl.COUNT = 0
1966: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1967: fnd_log.string(fnd_log.level_statement,l_full_name,' -- No Matching ACTIVE COUNTERS derived -- ');
1968: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Move to next item instace -- l_dtls_subject_id_tbl - '||l_dtls_subject_id_tbl(j));
1969: END IF;
1970: IF (p_concurrent_flag = 'Y') THEN
1971: fnd_file.put_line(fnd_file.log, ' -- No Matching ACTIVE COUNTERS derived -- ');
1972: END IF;

Line 1976: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1972: END IF;
1973:
1974: END IF; -- l_active_ctr_id_tbl.COUNT > 0
1975: ELSE -- Setup or Retrieved counters are NULL
1976: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1977: fnd_log.string(fnd_log.level_statement,l_full_name,'Setup or Retrieved counters are NULL');
1978: fnd_log.string(fnd_log.level_statement,l_full_name,'l_since_new_ctr_id_tbl - COUNT - '||l_since_new_ctr_id_tbl.COUNT);
1979: fnd_log.string(fnd_log.level_statement,l_full_name,'l_ctr_values_tbl - COUNT - '||l_ctr_values_tbl.COUNT);
1980: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_subject_id_tbl - '||l_dtls_subject_id_tbl(j));

Line 1977: fnd_log.string(fnd_log.level_statement,l_full_name,'Setup or Retrieved counters are NULL');

1973:
1974: END IF; -- l_active_ctr_id_tbl.COUNT > 0
1975: ELSE -- Setup or Retrieved counters are NULL
1976: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1977: fnd_log.string(fnd_log.level_statement,l_full_name,'Setup or Retrieved counters are NULL');
1978: fnd_log.string(fnd_log.level_statement,l_full_name,'l_since_new_ctr_id_tbl - COUNT - '||l_since_new_ctr_id_tbl.COUNT);
1979: fnd_log.string(fnd_log.level_statement,l_full_name,'l_ctr_values_tbl - COUNT - '||l_ctr_values_tbl.COUNT);
1980: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_subject_id_tbl - '||l_dtls_subject_id_tbl(j));
1981: END IF;

Line 1978: fnd_log.string(fnd_log.level_statement,l_full_name,'l_since_new_ctr_id_tbl - COUNT - '||l_since_new_ctr_id_tbl.COUNT);

1974: END IF; -- l_active_ctr_id_tbl.COUNT > 0
1975: ELSE -- Setup or Retrieved counters are NULL
1976: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1977: fnd_log.string(fnd_log.level_statement,l_full_name,'Setup or Retrieved counters are NULL');
1978: fnd_log.string(fnd_log.level_statement,l_full_name,'l_since_new_ctr_id_tbl - COUNT - '||l_since_new_ctr_id_tbl.COUNT);
1979: fnd_log.string(fnd_log.level_statement,l_full_name,'l_ctr_values_tbl - COUNT - '||l_ctr_values_tbl.COUNT);
1980: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_subject_id_tbl - '||l_dtls_subject_id_tbl(j));
1981: END IF;
1982: IF (p_concurrent_flag = 'Y') THEN

Line 1979: fnd_log.string(fnd_log.level_statement,l_full_name,'l_ctr_values_tbl - COUNT - '||l_ctr_values_tbl.COUNT);

1975: ELSE -- Setup or Retrieved counters are NULL
1976: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1977: fnd_log.string(fnd_log.level_statement,l_full_name,'Setup or Retrieved counters are NULL');
1978: fnd_log.string(fnd_log.level_statement,l_full_name,'l_since_new_ctr_id_tbl - COUNT - '||l_since_new_ctr_id_tbl.COUNT);
1979: fnd_log.string(fnd_log.level_statement,l_full_name,'l_ctr_values_tbl - COUNT - '||l_ctr_values_tbl.COUNT);
1980: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_subject_id_tbl - '||l_dtls_subject_id_tbl(j));
1981: END IF;
1982: IF (p_concurrent_flag = 'Y') THEN
1983: fnd_file.put_line(fnd_file.log, ' -- Setup or Retrieved counters are NULL -- ');

Line 1980: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_subject_id_tbl - '||l_dtls_subject_id_tbl(j));

1976: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1977: fnd_log.string(fnd_log.level_statement,l_full_name,'Setup or Retrieved counters are NULL');
1978: fnd_log.string(fnd_log.level_statement,l_full_name,'l_since_new_ctr_id_tbl - COUNT - '||l_since_new_ctr_id_tbl.COUNT);
1979: fnd_log.string(fnd_log.level_statement,l_full_name,'l_ctr_values_tbl - COUNT - '||l_ctr_values_tbl.COUNT);
1980: fnd_log.string(fnd_log.level_statement,l_full_name,'l_dtls_subject_id_tbl - '||l_dtls_subject_id_tbl(j));
1981: END IF;
1982: IF (p_concurrent_flag = 'Y') THEN
1983: fnd_file.put_line(fnd_file.log, ' -- Setup or Retrieved counters are NULL -- ');
1984: END IF;

Line 1988: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1984: END IF;
1985: END IF; -- l_since_new_ctr_id_tbl.COUNT > 0 AND l_ctr_values_tbl.COUNT > 0
1986: END LOOP; -- Loop for Item Instance - UC Nodes - index j
1987: ELSE
1988: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1989: fnd_log.string(fnd_log.level_statement,l_full_name,'No Nodes for Current Unit - Move to Next Sch-Unit');
1990: fnd_log.string(fnd_log.level_statement,l_full_name,'l_fs_unit_sch_id_tbl - '||l_fs_unit_sch_id_tbl(i));
1991: fnd_log.string(fnd_log.level_statement,l_full_name,'l_fs_uc_header_id_tbl - '||l_fs_uc_header_id_tbl(i));
1992: fnd_log.string(fnd_log.level_statement,l_full_name,'l_fs_csi_instance_id_tbl - '||l_fs_csi_instance_id_tbl(i));

Line 1989: fnd_log.string(fnd_log.level_statement,l_full_name,'No Nodes for Current Unit - Move to Next Sch-Unit');

1985: END IF; -- l_since_new_ctr_id_tbl.COUNT > 0 AND l_ctr_values_tbl.COUNT > 0
1986: END LOOP; -- Loop for Item Instance - UC Nodes - index j
1987: ELSE
1988: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1989: fnd_log.string(fnd_log.level_statement,l_full_name,'No Nodes for Current Unit - Move to Next Sch-Unit');
1990: fnd_log.string(fnd_log.level_statement,l_full_name,'l_fs_unit_sch_id_tbl - '||l_fs_unit_sch_id_tbl(i));
1991: fnd_log.string(fnd_log.level_statement,l_full_name,'l_fs_uc_header_id_tbl - '||l_fs_uc_header_id_tbl(i));
1992: fnd_log.string(fnd_log.level_statement,l_full_name,'l_fs_csi_instance_id_tbl - '||l_fs_csi_instance_id_tbl(i));
1993: END IF;

Line 1990: fnd_log.string(fnd_log.level_statement,l_full_name,'l_fs_unit_sch_id_tbl - '||l_fs_unit_sch_id_tbl(i));

1986: END LOOP; -- Loop for Item Instance - UC Nodes - index j
1987: ELSE
1988: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1989: fnd_log.string(fnd_log.level_statement,l_full_name,'No Nodes for Current Unit - Move to Next Sch-Unit');
1990: fnd_log.string(fnd_log.level_statement,l_full_name,'l_fs_unit_sch_id_tbl - '||l_fs_unit_sch_id_tbl(i));
1991: fnd_log.string(fnd_log.level_statement,l_full_name,'l_fs_uc_header_id_tbl - '||l_fs_uc_header_id_tbl(i));
1992: fnd_log.string(fnd_log.level_statement,l_full_name,'l_fs_csi_instance_id_tbl - '||l_fs_csi_instance_id_tbl(i));
1993: END IF;
1994: IF (p_concurrent_flag = 'Y') THEN

Line 1991: fnd_log.string(fnd_log.level_statement,l_full_name,'l_fs_uc_header_id_tbl - '||l_fs_uc_header_id_tbl(i));

1987: ELSE
1988: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1989: fnd_log.string(fnd_log.level_statement,l_full_name,'No Nodes for Current Unit - Move to Next Sch-Unit');
1990: fnd_log.string(fnd_log.level_statement,l_full_name,'l_fs_unit_sch_id_tbl - '||l_fs_unit_sch_id_tbl(i));
1991: fnd_log.string(fnd_log.level_statement,l_full_name,'l_fs_uc_header_id_tbl - '||l_fs_uc_header_id_tbl(i));
1992: fnd_log.string(fnd_log.level_statement,l_full_name,'l_fs_csi_instance_id_tbl - '||l_fs_csi_instance_id_tbl(i));
1993: END IF;
1994: IF (p_concurrent_flag = 'Y') THEN
1995: fnd_file.put_line(fnd_file.log, ' -- No Nodes for Current Unit - Move to Next Sch-Unit -- ');

Line 1992: fnd_log.string(fnd_log.level_statement,l_full_name,'l_fs_csi_instance_id_tbl - '||l_fs_csi_instance_id_tbl(i));

1988: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1989: fnd_log.string(fnd_log.level_statement,l_full_name,'No Nodes for Current Unit - Move to Next Sch-Unit');
1990: fnd_log.string(fnd_log.level_statement,l_full_name,'l_fs_unit_sch_id_tbl - '||l_fs_unit_sch_id_tbl(i));
1991: fnd_log.string(fnd_log.level_statement,l_full_name,'l_fs_uc_header_id_tbl - '||l_fs_uc_header_id_tbl(i));
1992: fnd_log.string(fnd_log.level_statement,l_full_name,'l_fs_csi_instance_id_tbl - '||l_fs_csi_instance_id_tbl(i));
1993: END IF;
1994: IF (p_concurrent_flag = 'Y') THEN
1995: fnd_file.put_line(fnd_file.log, ' -- No Nodes for Current Unit - Move to Next Sch-Unit -- ');
1996: END IF;

Line 2000: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

1996: END IF;
1997: END IF; -- l_dtls_subject_id_tbl.COUNT > 0
1998: END LOOP; -- Loop for Unit Schedules - i
1999: ELSE -- l_fs_unit_sch_id_tbl.COUNT = 0
2000: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2001: fnd_log.string(fnd_log.level_statement,l_full_name,'No Flight Schedules to Process');
2002: END IF;
2003: IF (p_concurrent_flag = 'Y') THEN
2004: fnd_file.put_line(fnd_file.log, ' -- No Flight Schedules to Process -- ');

Line 2001: fnd_log.string(fnd_log.level_statement,l_full_name,'No Flight Schedules to Process');

1997: END IF; -- l_dtls_subject_id_tbl.COUNT > 0
1998: END LOOP; -- Loop for Unit Schedules - i
1999: ELSE -- l_fs_unit_sch_id_tbl.COUNT = 0
2000: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2001: fnd_log.string(fnd_log.level_statement,l_full_name,'No Flight Schedules to Process');
2002: END IF;
2003: IF (p_concurrent_flag = 'Y') THEN
2004: fnd_file.put_line(fnd_file.log, ' -- No Flight Schedules to Process -- ');
2005: END IF;

Line 2010: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2006: END IF; -- l_fs_unit_sch_id_tbl.COUNT > 0
2007: END IF; -- l_since_new_ctr_id_tbl.COUNT = 0
2008:
2009: IF l_forecast_interface_tbl.COUNT > 0 THEN
2010: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2011: fnd_log.string(fnd_log.level_statement,l_full_name,'Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- Before');
2012: fnd_log.string(fnd_log.level_statement,l_full_name,' -- INTERFACE DATA -- ');
2013: FOR b IN l_forecast_interface_tbl.FIRST .. l_forecast_interface_tbl.LAST LOOP
2014: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FCT REC STARTS -- '||b);

Line 2011: fnd_log.string(fnd_log.level_statement,l_full_name,'Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- Before');

2007: END IF; -- l_since_new_ctr_id_tbl.COUNT = 0
2008:
2009: IF l_forecast_interface_tbl.COUNT > 0 THEN
2010: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2011: fnd_log.string(fnd_log.level_statement,l_full_name,'Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- Before');
2012: fnd_log.string(fnd_log.level_statement,l_full_name,' -- INTERFACE DATA -- ');
2013: FOR b IN l_forecast_interface_tbl.FIRST .. l_forecast_interface_tbl.LAST LOOP
2014: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FCT REC STARTS -- '||b);
2015: fnd_log.string(fnd_log.level_statement,l_full_name,' -- INVENTORY_ITEM_ID -- '||l_forecast_interface_tbl(b).INVENTORY_ITEM_ID);

Line 2012: fnd_log.string(fnd_log.level_statement,l_full_name,' -- INTERFACE DATA -- ');

2008:
2009: IF l_forecast_interface_tbl.COUNT > 0 THEN
2010: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2011: fnd_log.string(fnd_log.level_statement,l_full_name,'Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- Before');
2012: fnd_log.string(fnd_log.level_statement,l_full_name,' -- INTERFACE DATA -- ');
2013: FOR b IN l_forecast_interface_tbl.FIRST .. l_forecast_interface_tbl.LAST LOOP
2014: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FCT REC STARTS -- '||b);
2015: fnd_log.string(fnd_log.level_statement,l_full_name,' -- INVENTORY_ITEM_ID -- '||l_forecast_interface_tbl(b).INVENTORY_ITEM_ID);
2016: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECAST_DESIGNATOR -- '||l_forecast_interface_tbl(b).FORECAST_DESIGNATOR);

Line 2014: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FCT REC STARTS -- '||b);

2010: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2011: fnd_log.string(fnd_log.level_statement,l_full_name,'Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- Before');
2012: fnd_log.string(fnd_log.level_statement,l_full_name,' -- INTERFACE DATA -- ');
2013: FOR b IN l_forecast_interface_tbl.FIRST .. l_forecast_interface_tbl.LAST LOOP
2014: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FCT REC STARTS -- '||b);
2015: fnd_log.string(fnd_log.level_statement,l_full_name,' -- INVENTORY_ITEM_ID -- '||l_forecast_interface_tbl(b).INVENTORY_ITEM_ID);
2016: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECAST_DESIGNATOR -- '||l_forecast_interface_tbl(b).FORECAST_DESIGNATOR);
2017: fnd_log.string(fnd_log.level_statement,l_full_name,' -- ORGANIZATION_ID -- '||l_forecast_interface_tbl(b).ORGANIZATION_ID);
2018: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECAST_DATE -- '||l_forecast_interface_tbl(b).FORECAST_DATE);

Line 2015: fnd_log.string(fnd_log.level_statement,l_full_name,' -- INVENTORY_ITEM_ID -- '||l_forecast_interface_tbl(b).INVENTORY_ITEM_ID);

2011: fnd_log.string(fnd_log.level_statement,l_full_name,'Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- Before');
2012: fnd_log.string(fnd_log.level_statement,l_full_name,' -- INTERFACE DATA -- ');
2013: FOR b IN l_forecast_interface_tbl.FIRST .. l_forecast_interface_tbl.LAST LOOP
2014: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FCT REC STARTS -- '||b);
2015: fnd_log.string(fnd_log.level_statement,l_full_name,' -- INVENTORY_ITEM_ID -- '||l_forecast_interface_tbl(b).INVENTORY_ITEM_ID);
2016: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECAST_DESIGNATOR -- '||l_forecast_interface_tbl(b).FORECAST_DESIGNATOR);
2017: fnd_log.string(fnd_log.level_statement,l_full_name,' -- ORGANIZATION_ID -- '||l_forecast_interface_tbl(b).ORGANIZATION_ID);
2018: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECAST_DATE -- '||l_forecast_interface_tbl(b).FORECAST_DATE);
2019: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECASTED MONTH -- '||to_char(l_forecast_interface_tbl(b).FORECAST_DATE,'MON-YYYY'));

Line 2016: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECAST_DESIGNATOR -- '||l_forecast_interface_tbl(b).FORECAST_DESIGNATOR);

2012: fnd_log.string(fnd_log.level_statement,l_full_name,' -- INTERFACE DATA -- ');
2013: FOR b IN l_forecast_interface_tbl.FIRST .. l_forecast_interface_tbl.LAST LOOP
2014: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FCT REC STARTS -- '||b);
2015: fnd_log.string(fnd_log.level_statement,l_full_name,' -- INVENTORY_ITEM_ID -- '||l_forecast_interface_tbl(b).INVENTORY_ITEM_ID);
2016: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECAST_DESIGNATOR -- '||l_forecast_interface_tbl(b).FORECAST_DESIGNATOR);
2017: fnd_log.string(fnd_log.level_statement,l_full_name,' -- ORGANIZATION_ID -- '||l_forecast_interface_tbl(b).ORGANIZATION_ID);
2018: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECAST_DATE -- '||l_forecast_interface_tbl(b).FORECAST_DATE);
2019: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECASTED MONTH -- '||to_char(l_forecast_interface_tbl(b).FORECAST_DATE,'MON-YYYY'));
2020: fnd_log.string(fnd_log.level_statement,l_full_name,' -- REQUIRED_QUANTITY -- '||l_forecast_interface_tbl(b).QUANTITY);

Line 2017: fnd_log.string(fnd_log.level_statement,l_full_name,' -- ORGANIZATION_ID -- '||l_forecast_interface_tbl(b).ORGANIZATION_ID);

2013: FOR b IN l_forecast_interface_tbl.FIRST .. l_forecast_interface_tbl.LAST LOOP
2014: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FCT REC STARTS -- '||b);
2015: fnd_log.string(fnd_log.level_statement,l_full_name,' -- INVENTORY_ITEM_ID -- '||l_forecast_interface_tbl(b).INVENTORY_ITEM_ID);
2016: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECAST_DESIGNATOR -- '||l_forecast_interface_tbl(b).FORECAST_DESIGNATOR);
2017: fnd_log.string(fnd_log.level_statement,l_full_name,' -- ORGANIZATION_ID -- '||l_forecast_interface_tbl(b).ORGANIZATION_ID);
2018: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECAST_DATE -- '||l_forecast_interface_tbl(b).FORECAST_DATE);
2019: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECASTED MONTH -- '||to_char(l_forecast_interface_tbl(b).FORECAST_DATE,'MON-YYYY'));
2020: fnd_log.string(fnd_log.level_statement,l_full_name,' -- REQUIRED_QUANTITY -- '||l_forecast_interface_tbl(b).QUANTITY);
2021: fnd_log.string(fnd_log.level_statement,l_full_name,' -- PROCESS_STATUS -- '||l_forecast_interface_tbl(b).PROCESS_STATUS);

Line 2018: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECAST_DATE -- '||l_forecast_interface_tbl(b).FORECAST_DATE);

2014: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FCT REC STARTS -- '||b);
2015: fnd_log.string(fnd_log.level_statement,l_full_name,' -- INVENTORY_ITEM_ID -- '||l_forecast_interface_tbl(b).INVENTORY_ITEM_ID);
2016: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECAST_DESIGNATOR -- '||l_forecast_interface_tbl(b).FORECAST_DESIGNATOR);
2017: fnd_log.string(fnd_log.level_statement,l_full_name,' -- ORGANIZATION_ID -- '||l_forecast_interface_tbl(b).ORGANIZATION_ID);
2018: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECAST_DATE -- '||l_forecast_interface_tbl(b).FORECAST_DATE);
2019: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECASTED MONTH -- '||to_char(l_forecast_interface_tbl(b).FORECAST_DATE,'MON-YYYY'));
2020: fnd_log.string(fnd_log.level_statement,l_full_name,' -- REQUIRED_QUANTITY -- '||l_forecast_interface_tbl(b).QUANTITY);
2021: fnd_log.string(fnd_log.level_statement,l_full_name,' -- PROCESS_STATUS -- '||l_forecast_interface_tbl(b).PROCESS_STATUS);
2022: fnd_log.string(fnd_log.level_statement,l_full_name,' -- CONFIDENCE_PERCENTAGE -- '||l_forecast_interface_tbl(b).CONFIDENCE_PERCENTAGE);

Line 2019: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECASTED MONTH -- '||to_char(l_forecast_interface_tbl(b).FORECAST_DATE,'MON-YYYY'));

2015: fnd_log.string(fnd_log.level_statement,l_full_name,' -- INVENTORY_ITEM_ID -- '||l_forecast_interface_tbl(b).INVENTORY_ITEM_ID);
2016: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECAST_DESIGNATOR -- '||l_forecast_interface_tbl(b).FORECAST_DESIGNATOR);
2017: fnd_log.string(fnd_log.level_statement,l_full_name,' -- ORGANIZATION_ID -- '||l_forecast_interface_tbl(b).ORGANIZATION_ID);
2018: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECAST_DATE -- '||l_forecast_interface_tbl(b).FORECAST_DATE);
2019: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECASTED MONTH -- '||to_char(l_forecast_interface_tbl(b).FORECAST_DATE,'MON-YYYY'));
2020: fnd_log.string(fnd_log.level_statement,l_full_name,' -- REQUIRED_QUANTITY -- '||l_forecast_interface_tbl(b).QUANTITY);
2021: fnd_log.string(fnd_log.level_statement,l_full_name,' -- PROCESS_STATUS -- '||l_forecast_interface_tbl(b).PROCESS_STATUS);
2022: fnd_log.string(fnd_log.level_statement,l_full_name,' -- CONFIDENCE_PERCENTAGE -- '||l_forecast_interface_tbl(b).CONFIDENCE_PERCENTAGE);
2023: fnd_log.string(fnd_log.level_statement,l_full_name,' -- WORKDAY_CONTROL -- '||l_forecast_interface_tbl(b).WORKDAY_CONTROL);

Line 2020: fnd_log.string(fnd_log.level_statement,l_full_name,' -- REQUIRED_QUANTITY -- '||l_forecast_interface_tbl(b).QUANTITY);

2016: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECAST_DESIGNATOR -- '||l_forecast_interface_tbl(b).FORECAST_DESIGNATOR);
2017: fnd_log.string(fnd_log.level_statement,l_full_name,' -- ORGANIZATION_ID -- '||l_forecast_interface_tbl(b).ORGANIZATION_ID);
2018: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECAST_DATE -- '||l_forecast_interface_tbl(b).FORECAST_DATE);
2019: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECASTED MONTH -- '||to_char(l_forecast_interface_tbl(b).FORECAST_DATE,'MON-YYYY'));
2020: fnd_log.string(fnd_log.level_statement,l_full_name,' -- REQUIRED_QUANTITY -- '||l_forecast_interface_tbl(b).QUANTITY);
2021: fnd_log.string(fnd_log.level_statement,l_full_name,' -- PROCESS_STATUS -- '||l_forecast_interface_tbl(b).PROCESS_STATUS);
2022: fnd_log.string(fnd_log.level_statement,l_full_name,' -- CONFIDENCE_PERCENTAGE -- '||l_forecast_interface_tbl(b).CONFIDENCE_PERCENTAGE);
2023: fnd_log.string(fnd_log.level_statement,l_full_name,' -- WORKDAY_CONTROL -- '||l_forecast_interface_tbl(b).WORKDAY_CONTROL);
2024: fnd_log.string(fnd_log.level_statement,l_full_name,' -- BUCKET_TYPE -- '||l_forecast_interface_tbl(b).BUCKET_TYPE);

Line 2021: fnd_log.string(fnd_log.level_statement,l_full_name,' -- PROCESS_STATUS -- '||l_forecast_interface_tbl(b).PROCESS_STATUS);

2017: fnd_log.string(fnd_log.level_statement,l_full_name,' -- ORGANIZATION_ID -- '||l_forecast_interface_tbl(b).ORGANIZATION_ID);
2018: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECAST_DATE -- '||l_forecast_interface_tbl(b).FORECAST_DATE);
2019: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECASTED MONTH -- '||to_char(l_forecast_interface_tbl(b).FORECAST_DATE,'MON-YYYY'));
2020: fnd_log.string(fnd_log.level_statement,l_full_name,' -- REQUIRED_QUANTITY -- '||l_forecast_interface_tbl(b).QUANTITY);
2021: fnd_log.string(fnd_log.level_statement,l_full_name,' -- PROCESS_STATUS -- '||l_forecast_interface_tbl(b).PROCESS_STATUS);
2022: fnd_log.string(fnd_log.level_statement,l_full_name,' -- CONFIDENCE_PERCENTAGE -- '||l_forecast_interface_tbl(b).CONFIDENCE_PERCENTAGE);
2023: fnd_log.string(fnd_log.level_statement,l_full_name,' -- WORKDAY_CONTROL -- '||l_forecast_interface_tbl(b).WORKDAY_CONTROL);
2024: fnd_log.string(fnd_log.level_statement,l_full_name,' -- BUCKET_TYPE -- '||l_forecast_interface_tbl(b).BUCKET_TYPE);
2025: fnd_log.string(fnd_log.level_statement,l_full_name,' -- SOURCE_CODE -- '||l_forecast_interface_tbl(b).SOURCE_CODE);

Line 2022: fnd_log.string(fnd_log.level_statement,l_full_name,' -- CONFIDENCE_PERCENTAGE -- '||l_forecast_interface_tbl(b).CONFIDENCE_PERCENTAGE);

2018: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECAST_DATE -- '||l_forecast_interface_tbl(b).FORECAST_DATE);
2019: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECASTED MONTH -- '||to_char(l_forecast_interface_tbl(b).FORECAST_DATE,'MON-YYYY'));
2020: fnd_log.string(fnd_log.level_statement,l_full_name,' -- REQUIRED_QUANTITY -- '||l_forecast_interface_tbl(b).QUANTITY);
2021: fnd_log.string(fnd_log.level_statement,l_full_name,' -- PROCESS_STATUS -- '||l_forecast_interface_tbl(b).PROCESS_STATUS);
2022: fnd_log.string(fnd_log.level_statement,l_full_name,' -- CONFIDENCE_PERCENTAGE -- '||l_forecast_interface_tbl(b).CONFIDENCE_PERCENTAGE);
2023: fnd_log.string(fnd_log.level_statement,l_full_name,' -- WORKDAY_CONTROL -- '||l_forecast_interface_tbl(b).WORKDAY_CONTROL);
2024: fnd_log.string(fnd_log.level_statement,l_full_name,' -- BUCKET_TYPE -- '||l_forecast_interface_tbl(b).BUCKET_TYPE);
2025: fnd_log.string(fnd_log.level_statement,l_full_name,' -- SOURCE_CODE -- '||l_forecast_interface_tbl(b).SOURCE_CODE);
2026: fnd_log.string(fnd_log.level_statement,l_full_name,' -- SOURCE_LINE_ID -- '||l_forecast_interface_tbl(b).SOURCE_LINE_ID);

Line 2023: fnd_log.string(fnd_log.level_statement,l_full_name,' -- WORKDAY_CONTROL -- '||l_forecast_interface_tbl(b).WORKDAY_CONTROL);

2019: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECASTED MONTH -- '||to_char(l_forecast_interface_tbl(b).FORECAST_DATE,'MON-YYYY'));
2020: fnd_log.string(fnd_log.level_statement,l_full_name,' -- REQUIRED_QUANTITY -- '||l_forecast_interface_tbl(b).QUANTITY);
2021: fnd_log.string(fnd_log.level_statement,l_full_name,' -- PROCESS_STATUS -- '||l_forecast_interface_tbl(b).PROCESS_STATUS);
2022: fnd_log.string(fnd_log.level_statement,l_full_name,' -- CONFIDENCE_PERCENTAGE -- '||l_forecast_interface_tbl(b).CONFIDENCE_PERCENTAGE);
2023: fnd_log.string(fnd_log.level_statement,l_full_name,' -- WORKDAY_CONTROL -- '||l_forecast_interface_tbl(b).WORKDAY_CONTROL);
2024: fnd_log.string(fnd_log.level_statement,l_full_name,' -- BUCKET_TYPE -- '||l_forecast_interface_tbl(b).BUCKET_TYPE);
2025: fnd_log.string(fnd_log.level_statement,l_full_name,' -- SOURCE_CODE -- '||l_forecast_interface_tbl(b).SOURCE_CODE);
2026: fnd_log.string(fnd_log.level_statement,l_full_name,' -- SOURCE_LINE_ID -- '||l_forecast_interface_tbl(b).SOURCE_LINE_ID);
2027: fnd_log.string(fnd_log.level_statement,l_full_name,' -- ACTION -- '||l_forecast_interface_tbl(b).ACTION);

Line 2024: fnd_log.string(fnd_log.level_statement,l_full_name,' -- BUCKET_TYPE -- '||l_forecast_interface_tbl(b).BUCKET_TYPE);

2020: fnd_log.string(fnd_log.level_statement,l_full_name,' -- REQUIRED_QUANTITY -- '||l_forecast_interface_tbl(b).QUANTITY);
2021: fnd_log.string(fnd_log.level_statement,l_full_name,' -- PROCESS_STATUS -- '||l_forecast_interface_tbl(b).PROCESS_STATUS);
2022: fnd_log.string(fnd_log.level_statement,l_full_name,' -- CONFIDENCE_PERCENTAGE -- '||l_forecast_interface_tbl(b).CONFIDENCE_PERCENTAGE);
2023: fnd_log.string(fnd_log.level_statement,l_full_name,' -- WORKDAY_CONTROL -- '||l_forecast_interface_tbl(b).WORKDAY_CONTROL);
2024: fnd_log.string(fnd_log.level_statement,l_full_name,' -- BUCKET_TYPE -- '||l_forecast_interface_tbl(b).BUCKET_TYPE);
2025: fnd_log.string(fnd_log.level_statement,l_full_name,' -- SOURCE_CODE -- '||l_forecast_interface_tbl(b).SOURCE_CODE);
2026: fnd_log.string(fnd_log.level_statement,l_full_name,' -- SOURCE_LINE_ID -- '||l_forecast_interface_tbl(b).SOURCE_LINE_ID);
2027: fnd_log.string(fnd_log.level_statement,l_full_name,' -- ACTION -- '||l_forecast_interface_tbl(b).ACTION);
2028:

Line 2025: fnd_log.string(fnd_log.level_statement,l_full_name,' -- SOURCE_CODE -- '||l_forecast_interface_tbl(b).SOURCE_CODE);

2021: fnd_log.string(fnd_log.level_statement,l_full_name,' -- PROCESS_STATUS -- '||l_forecast_interface_tbl(b).PROCESS_STATUS);
2022: fnd_log.string(fnd_log.level_statement,l_full_name,' -- CONFIDENCE_PERCENTAGE -- '||l_forecast_interface_tbl(b).CONFIDENCE_PERCENTAGE);
2023: fnd_log.string(fnd_log.level_statement,l_full_name,' -- WORKDAY_CONTROL -- '||l_forecast_interface_tbl(b).WORKDAY_CONTROL);
2024: fnd_log.string(fnd_log.level_statement,l_full_name,' -- BUCKET_TYPE -- '||l_forecast_interface_tbl(b).BUCKET_TYPE);
2025: fnd_log.string(fnd_log.level_statement,l_full_name,' -- SOURCE_CODE -- '||l_forecast_interface_tbl(b).SOURCE_CODE);
2026: fnd_log.string(fnd_log.level_statement,l_full_name,' -- SOURCE_LINE_ID -- '||l_forecast_interface_tbl(b).SOURCE_LINE_ID);
2027: fnd_log.string(fnd_log.level_statement,l_full_name,' -- ACTION -- '||l_forecast_interface_tbl(b).ACTION);
2028:
2029: END LOOP;

Line 2026: fnd_log.string(fnd_log.level_statement,l_full_name,' -- SOURCE_LINE_ID -- '||l_forecast_interface_tbl(b).SOURCE_LINE_ID);

2022: fnd_log.string(fnd_log.level_statement,l_full_name,' -- CONFIDENCE_PERCENTAGE -- '||l_forecast_interface_tbl(b).CONFIDENCE_PERCENTAGE);
2023: fnd_log.string(fnd_log.level_statement,l_full_name,' -- WORKDAY_CONTROL -- '||l_forecast_interface_tbl(b).WORKDAY_CONTROL);
2024: fnd_log.string(fnd_log.level_statement,l_full_name,' -- BUCKET_TYPE -- '||l_forecast_interface_tbl(b).BUCKET_TYPE);
2025: fnd_log.string(fnd_log.level_statement,l_full_name,' -- SOURCE_CODE -- '||l_forecast_interface_tbl(b).SOURCE_CODE);
2026: fnd_log.string(fnd_log.level_statement,l_full_name,' -- SOURCE_LINE_ID -- '||l_forecast_interface_tbl(b).SOURCE_LINE_ID);
2027: fnd_log.string(fnd_log.level_statement,l_full_name,' -- ACTION -- '||l_forecast_interface_tbl(b).ACTION);
2028:
2029: END LOOP;
2030: IF l_forecast_designator_tbl.COUNT > 0 THEN

Line 2027: fnd_log.string(fnd_log.level_statement,l_full_name,' -- ACTION -- '||l_forecast_interface_tbl(b).ACTION);

2023: fnd_log.string(fnd_log.level_statement,l_full_name,' -- WORKDAY_CONTROL -- '||l_forecast_interface_tbl(b).WORKDAY_CONTROL);
2024: fnd_log.string(fnd_log.level_statement,l_full_name,' -- BUCKET_TYPE -- '||l_forecast_interface_tbl(b).BUCKET_TYPE);
2025: fnd_log.string(fnd_log.level_statement,l_full_name,' -- SOURCE_CODE -- '||l_forecast_interface_tbl(b).SOURCE_CODE);
2026: fnd_log.string(fnd_log.level_statement,l_full_name,' -- SOURCE_LINE_ID -- '||l_forecast_interface_tbl(b).SOURCE_LINE_ID);
2027: fnd_log.string(fnd_log.level_statement,l_full_name,' -- ACTION -- '||l_forecast_interface_tbl(b).ACTION);
2028:
2029: END LOOP;
2030: IF l_forecast_designator_tbl.COUNT > 0 THEN
2031: FOR c IN l_forecast_designator_tbl.FIRST .. l_forecast_designator_tbl.LAST LOOP

Line 2032: fnd_log.string(fnd_log.level_statement,l_full_name,' -- DESIGNATOR REC STARTS -- '||c);

2028:
2029: END LOOP;
2030: IF l_forecast_designator_tbl.COUNT > 0 THEN
2031: FOR c IN l_forecast_designator_tbl.FIRST .. l_forecast_designator_tbl.LAST LOOP
2032: fnd_log.string(fnd_log.level_statement,l_full_name,' -- DESIGNATOR REC STARTS -- '||c);
2033: fnd_log.string(fnd_log.level_statement,l_full_name,' -- ORGANIZATION_ID -- '||l_forecast_designator_tbl(c).ORGANIZATION_ID);
2034: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECAST_DESIGNATOR -- '||l_forecast_designator_tbl(c).FORECAST_DESIGNATOR);
2035: END LOOP;
2036: END IF;

Line 2033: fnd_log.string(fnd_log.level_statement,l_full_name,' -- ORGANIZATION_ID -- '||l_forecast_designator_tbl(c).ORGANIZATION_ID);

2029: END LOOP;
2030: IF l_forecast_designator_tbl.COUNT > 0 THEN
2031: FOR c IN l_forecast_designator_tbl.FIRST .. l_forecast_designator_tbl.LAST LOOP
2032: fnd_log.string(fnd_log.level_statement,l_full_name,' -- DESIGNATOR REC STARTS -- '||c);
2033: fnd_log.string(fnd_log.level_statement,l_full_name,' -- ORGANIZATION_ID -- '||l_forecast_designator_tbl(c).ORGANIZATION_ID);
2034: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECAST_DESIGNATOR -- '||l_forecast_designator_tbl(c).FORECAST_DESIGNATOR);
2035: END LOOP;
2036: END IF;
2037: END IF;

Line 2034: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECAST_DESIGNATOR -- '||l_forecast_designator_tbl(c).FORECAST_DESIGNATOR);

2030: IF l_forecast_designator_tbl.COUNT > 0 THEN
2031: FOR c IN l_forecast_designator_tbl.FIRST .. l_forecast_designator_tbl.LAST LOOP
2032: fnd_log.string(fnd_log.level_statement,l_full_name,' -- DESIGNATOR REC STARTS -- '||c);
2033: fnd_log.string(fnd_log.level_statement,l_full_name,' -- ORGANIZATION_ID -- '||l_forecast_designator_tbl(c).ORGANIZATION_ID);
2034: fnd_log.string(fnd_log.level_statement,l_full_name,' -- FORECAST_DESIGNATOR -- '||l_forecast_designator_tbl(c).FORECAST_DESIGNATOR);
2035: END LOOP;
2036: END IF;
2037: END IF;
2038: IF (p_concurrent_flag = 'Y') THEN

Line 2045: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2041:
2042: IF (MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE
2043: (l_forecast_interface_tbl,
2044: l_forecast_designator_tbl)) THEN
2045: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2046: fnd_log.string(fnd_log.level_statement,l_full_name,'Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- After');
2047: END IF;
2048: IF (p_concurrent_flag = 'Y') THEN
2049: fnd_file.put_line(fnd_file.log, ' -- Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- After -- ');

Line 2046: fnd_log.string(fnd_log.level_statement,l_full_name,'Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- After');

2042: IF (MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE
2043: (l_forecast_interface_tbl,
2044: l_forecast_designator_tbl)) THEN
2045: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2046: fnd_log.string(fnd_log.level_statement,l_full_name,'Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- After');
2047: END IF;
2048: IF (p_concurrent_flag = 'Y') THEN
2049: fnd_file.put_line(fnd_file.log, ' -- Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- After -- ');
2050: END IF;

Line 2052: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2048: IF (p_concurrent_flag = 'Y') THEN
2049: fnd_file.put_line(fnd_file.log, ' -- Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- After -- ');
2050: END IF;
2051: ELSE
2052: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2053: fnd_log.string(fnd_log.level_statement,l_full_name,'Failure Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- ');
2054: END IF;
2055: IF (p_concurrent_flag = 'Y') THEN
2056: fnd_file.put_line(fnd_file.log, ' -- Failure Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE ---- ');

Line 2053: fnd_log.string(fnd_log.level_statement,l_full_name,'Failure Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- ');

2049: fnd_file.put_line(fnd_file.log, ' -- Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- After -- ');
2050: END IF;
2051: ELSE
2052: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2053: fnd_log.string(fnd_log.level_statement,l_full_name,'Failure Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE -- ');
2054: END IF;
2055: IF (p_concurrent_flag = 'Y') THEN
2056: fnd_file.put_line(fnd_file.log, ' -- Failure Calling MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE ---- ');
2057: END IF;

Line 2061: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2057: END IF;
2058: END IF;
2059:
2060: ELSE
2061: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2062: fnd_log.string(fnd_log.level_statement,l_full_name,'MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE Not to be called');
2063: END IF;
2064: IF (p_concurrent_flag = 'Y') THEN
2065: fnd_file.put_line(fnd_file.log, ' -- MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE Not to be called ---- ');

Line 2062: fnd_log.string(fnd_log.level_statement,l_full_name,'MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE Not to be called');

2058: END IF;
2059:
2060: ELSE
2061: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2062: fnd_log.string(fnd_log.level_statement,l_full_name,'MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE Not to be called');
2063: END IF;
2064: IF (p_concurrent_flag = 'Y') THEN
2065: fnd_file.put_line(fnd_file.log, ' -- MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE Not to be called ---- ');
2066: END IF;

Line 2091: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2087: l_dummy_string := l_dummy_string || '' || to_char(p_end_date,'YYYY-MM-DD') || '' ||fnd_global.local_chr(10);
2088: dbms_lob.write(l_fct_data_lob, length(l_dummy_string),length(l_fct_data_lob)+1, l_dummy_string);
2089:
2090: IF l_forecast_interface_tbl.COUNT > 0 THEN
2091: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2092: fnd_log.string(fnd_log.level_statement,l_full_name,'Creating Clob for Output File');
2093: END IF;
2094: IF (p_concurrent_flag = 'Y') THEN
2095: fnd_file.put_line(fnd_file.log, ' -- Creating Clob for Output File -- ');

Line 2092: fnd_log.string(fnd_log.level_statement,l_full_name,'Creating Clob for Output File');

2088: dbms_lob.write(l_fct_data_lob, length(l_dummy_string),length(l_fct_data_lob)+1, l_dummy_string);
2089:
2090: IF l_forecast_interface_tbl.COUNT > 0 THEN
2091: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2092: fnd_log.string(fnd_log.level_statement,l_full_name,'Creating Clob for Output File');
2093: END IF;
2094: IF (p_concurrent_flag = 'Y') THEN
2095: fnd_file.put_line(fnd_file.log, ' -- Creating Clob for Output File -- ');
2096: END IF;

Line 2147: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2143: END IF;
2144: END LOOP;
2145:
2146: ELSE
2147: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2148: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Clob content empty for Output File --');
2149: END IF;
2150: IF (p_concurrent_flag = 'Y') THEN
2151: fnd_file.put_line(fnd_file.log, ' -- Clob content empty for Output File ---- ');

Line 2148: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Clob content empty for Output File --');

2144: END LOOP;
2145:
2146: ELSE
2147: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2148: fnd_log.string(fnd_log.level_statement,l_full_name,' -- Clob content empty for Output File --');
2149: END IF;
2150: IF (p_concurrent_flag = 'Y') THEN
2151: fnd_file.put_line(fnd_file.log, ' -- Clob content empty for Output File ---- ');
2152: END IF;

Line 2174: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

2170:
2171: IF (p_concurrent_flag = 'Y') THEN
2172: fnd_file.put_line(fnd_file.log, ' -- RA -- PKG -- PROCESS_RA_DATA -------END--------------- ');
2173: END IF;
2174: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2175: fnd_log.string(fnd_log.level_statement,l_full_name,'RA -- PKG -- PROCESS_RA_DATA -------END-----------');
2176: END IF;
2177:
2178: -- Standard call to get message count and if count is 1, get message

Line 2175: fnd_log.string(fnd_log.level_statement,l_full_name,'RA -- PKG -- PROCESS_RA_DATA -------END-----------');

2171: IF (p_concurrent_flag = 'Y') THEN
2172: fnd_file.put_line(fnd_file.log, ' -- RA -- PKG -- PROCESS_RA_DATA -------END--------------- ');
2173: END IF;
2174: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2175: fnd_log.string(fnd_log.level_statement,l_full_name,'RA -- PKG -- PROCESS_RA_DATA -------END-----------');
2176: END IF;
2177:
2178: -- Standard call to get message count and if count is 1, get message
2179: FND_MSG_PUB.Count_And_Get

Line 2184: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

2180: ( p_count => x_msg_count,
2181: p_data => x_msg_data,
2182: p_encoded => fnd_api.g_false);
2183:
2184: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2185: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.end','Return Status = ' || x_return_status);
2186: END IF;
2187:
2188: EXCEPTION

Line 2185: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.end','Return Status = ' || x_return_status);

2181: p_data => x_msg_data,
2182: p_encoded => fnd_api.g_false);
2183:
2184: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2185: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.end','Return Status = ' || x_return_status);
2186: END IF;
2187:
2188: EXCEPTION
2189: WHEN FND_API.G_EXC_ERROR THEN