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.ENI_DBI_PCO_LOAD_PKG dependencies on FND_FILE

Line 43: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch size in validate = ' || g_batch_size);

39: g_batch_size := 200;
40: END IF;
41: g_number_of_batches := ceil(g_actual_recs_to_process/g_batch_size);
42: g_recs_per_batch := ceil(g_actual_recs_to_process/g_number_of_batches);
43: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch size in validate = ' || g_batch_size);
44:
45: -- Set the number of workers
46: g_actual_workers := least(ceil(g_actual_recs_to_process/g_batch_size), least(p_num_workers, 10)); --FND_PROFILE.get('DBI_MAX_WORKERS'));
47: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Second Batch size in validate = ' || g_batch_size);

Line 47: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Second Batch size in validate = ' || g_batch_size);

43: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch size in validate = ' || g_batch_size);
44:
45: -- Set the number of workers
46: g_actual_workers := least(ceil(g_actual_recs_to_process/g_batch_size), least(p_num_workers, 10)); --FND_PROFILE.get('DBI_MAX_WORKERS'));
47: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Second Batch size in validate = ' || g_batch_size);
48:
49: IF (g_actual_workers = 0) THEN
50: g_actual_workers := 1;
51: END IF;

Line 333: FND_FILE.PUT_LINE(FND_FILE.LOG,'Incremental Collection has errored out.');

329: FROM ENI_DBI_PCO_WORKER_ASSIGNMENTS
330: WHERE incr_status = -1;
331:
332: IF (l_error_occured <> 0) THEN
333: FND_FILE.PUT_LINE(FND_FILE.LOG,'Incremental Collection has errored out.');
334: RETURN;
335: END IF;
336:
337: IF (p_collect_mode = 'INIT') THEN -- when initial collection, complete refresh the MV

Line 431: FND_FILE.PUT_LINE(FND_FILE.LOG, 'collection mode parameter is = ' || p_collect_mode);

427: g_organization_id := p_organization_id;
428: g_actual_workers := p_num_workers;
429: g_batch_size := NVL(p_batch_size,1);
430:
431: FND_FILE.PUT_LINE(FND_FILE.LOG, 'collection mode parameter is = ' || p_collect_mode);
432: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch size = ' || g_batch_size);
433:
434: IF(FND_INSTALLATION.GET_APP_INFO('ENI', l_status, l_industry, g_eni_schema))
435: THEN NULL;

Line 432: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch size = ' || g_batch_size);

428: g_actual_workers := p_num_workers;
429: g_batch_size := NVL(p_batch_size,1);
430:
431: FND_FILE.PUT_LINE(FND_FILE.LOG, 'collection mode parameter is = ' || p_collect_mode);
432: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch size = ' || g_batch_size);
433:
434: IF(FND_INSTALLATION.GET_APP_INFO('ENI', l_status, l_industry, g_eni_schema))
435: THEN NULL;
436: END IF;

Line 486: FND_FILE.PUT_LINE(FND_FILE.LOG, 'assign worker ids');

482: END IF;
483:
484: -- Assign worker ids to the interface table records
485: ENI_DBI_PCO_LOAD_PKG.assign_worker_ids(p_collect_mode);
486: FND_FILE.PUT_LINE(FND_FILE.LOG, 'assign worker ids');
487: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Started Execution...............');
488:
489: SELECT count(*)
490: INTO l_num_recs_to_process

Line 487: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Started Execution...............');

483:
484: -- Assign worker ids to the interface table records
485: ENI_DBI_PCO_LOAD_PKG.assign_worker_ids(p_collect_mode);
486: FND_FILE.PUT_LINE(FND_FILE.LOG, 'assign worker ids');
487: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Started Execution...............');
488:
489: SELECT count(*)
490: INTO l_num_recs_to_process
491: FROM eni_dbi_pco_worker_assignments;

Line 494: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Bills to work upon');

490: INTO l_num_recs_to_process
491: FROM eni_dbi_pco_worker_assignments;
492:
493: IF (l_num_recs_to_process <= 0) THEN
494: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Bills to work upon');
495: RETURN;
496: ELSE
497: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number of Bills to work upon is:' || l_num_recs_to_process);
498: END IF;

Line 497: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number of Bills to work upon is:' || l_num_recs_to_process);

493: IF (l_num_recs_to_process <= 0) THEN
494: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Bills to work upon');
495: RETURN;
496: ELSE
497: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number of Bills to work upon is:' || l_num_recs_to_process);
498: END IF;
499:
500: -- Validate the parameters and reset them if required
501: ENI_DBI_PCO_LOAD_PKG.validate_set_parameters(p_num_workers,p_batch_size);

Line 502: FND_FILE.PUT_LINE(FND_FILE.LOG, 'validate_set_parameters');

498: END IF;
499:
500: -- Validate the parameters and reset them if required
501: ENI_DBI_PCO_LOAD_PKG.validate_set_parameters(p_num_workers,p_batch_size);
502: FND_FILE.PUT_LINE(FND_FILE.LOG, 'validate_set_parameters');
503: FND_FILE.PUT_LINE(FND_FILE.LOG, 'after validate Batch size = ' || g_batch_size);
504:
505:
506: -- Launch workers

Line 503: FND_FILE.PUT_LINE(FND_FILE.LOG, 'after validate Batch size = ' || g_batch_size);

499:
500: -- Validate the parameters and reset them if required
501: ENI_DBI_PCO_LOAD_PKG.validate_set_parameters(p_num_workers,p_batch_size);
502: FND_FILE.PUT_LINE(FND_FILE.LOG, 'validate_set_parameters');
503: FND_FILE.PUT_LINE(FND_FILE.LOG, 'after validate Batch size = ' || g_batch_size);
504:
505:
506: -- Launch workers
507: ENI_DBI_PCO_LOAD_PKG.launch_workers(p_collect_mode);

Line 508: FND_FILE.PUT_LINE(FND_FILE.LOG, 'launch workers..');

504:
505:
506: -- Launch workers
507: ENI_DBI_PCO_LOAD_PKG.launch_workers(p_collect_mode);
508: FND_FILE.PUT_LINE(FND_FILE.LOG, 'launch workers..');
509:
510: -- Wait for the workers to complete the collection.
511: IF (p_collect_mode = 'INCR') THEN
512: ENI_DBI_PCO_LOAD_PKG.wait_for_workers('INCR');

Line 514: FND_FILE.PUT_LINE(FND_FILE.LOG, 'wait for workers is complete');

510: -- Wait for the workers to complete the collection.
511: IF (p_collect_mode = 'INCR') THEN
512: ENI_DBI_PCO_LOAD_PKG.wait_for_workers('INCR');
513: ENI_DBI_PCO_LOAD_PKG.cleanup;
514: FND_FILE.PUT_LINE(FND_FILE.LOG, 'wait for workers is complete');
515: BIS_COLLECTION_UTILITIES.WRAPUP(
516: p_status => true,
517: p_period_from => sysdate,
518: p_period_to => g_collection_date);

Line 562: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error has occured during the collection');

558: FROM eni_Dbi_pco_worker_assignments
559: WHERE incr_status = -1;
560:
561: IF (l_error > 0) THEN
562: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error has occured during the collection');
563: o_error_code := 2;
564: o_error_msg := 'Error';
565: EXIT;
566: END IF;

Line 790: FND_FILE.PUT_LINE(FND_FILE.LOG,'The following error has occured while inserting into the Part Count fact table');

786: WHEN OTHERS THEN
787: l_error_msg := SQLERRM;
788: l_error_code := 2;
789: -- Modified as part of the fix for the Bug # 3127260
790: FND_FILE.PUT_LINE(FND_FILE.LOG,'The following error has occured while inserting into the Part Count fact table');
791: ENI_DBI_UTIL_PKG.LOG(l_error_code||':'||l_error_msg);
792: ENI_DBI_UTIL_PKG.LOG('An error prevented the INCREMENTAL part count collection from completing successfully');
793: EXECUTE IMMEDIATE 'truncate table '||g_eni_schema||'.eni_dbi_part_count_f';
794: RETURN; -- Return from the for loop after the explosion.