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

Line 447: fnd_file.put_line(FND_FILE.LOG, 'Updating Comm Lines API => NVL(adjust_status,NEW), NVL(PRESERVE_CREDIT_OVERRIDE_FLAG,N) to improve performance for SCA process');

443: l_batch_size := p_batch_size;
444: l_num_workers := p_num_workers;
445: l_worker_id := p_worker_id;
446:
447: fnd_file.put_line(FND_FILE.LOG, 'Updating Comm Lines API => NVL(adjust_status,NEW), NVL(PRESERVE_CREDIT_OVERRIDE_FLAG,N) to improve performance for SCA process');
448: -- get schema name of the table for ROWID range processing
449: l_retstatus := fnd_installation.get_app_info(l_product, l_status, l_industry, l_table_owner);
450:
451: if ((l_retstatus = FALSE) OR (l_table_owner is null))

Line 456: fnd_file.put_line(FND_FILE.LOG, 'Batch size : '||l_batch_size);

452: then
453: raise_application_error(-20001, 'Cannot get schema name for product : '||l_product);
454: end if;
455:
456: fnd_file.put_line(FND_FILE.LOG, 'Batch size : '||l_batch_size);
457: fnd_file.put_line(FND_FILE.LOG, 'Number of Workers : '||l_Num_Workers);
458: fnd_file.put_line(FND_FILE.LOG, 'Worker Id : '||l_Worker_Id);
459:
460: l_rows_processed := 0;

Line 457: fnd_file.put_line(FND_FILE.LOG, 'Number of Workers : '||l_Num_Workers);

453: raise_application_error(-20001, 'Cannot get schema name for product : '||l_product);
454: end if;
455:
456: fnd_file.put_line(FND_FILE.LOG, 'Batch size : '||l_batch_size);
457: fnd_file.put_line(FND_FILE.LOG, 'Number of Workers : '||l_Num_Workers);
458: fnd_file.put_line(FND_FILE.LOG, 'Worker Id : '||l_Worker_Id);
459:
460: l_rows_processed := 0;
461: l_total_rows := 0;

Line 458: fnd_file.put_line(FND_FILE.LOG, 'Worker Id : '||l_Worker_Id);

454: end if;
455:
456: fnd_file.put_line(FND_FILE.LOG, 'Batch size : '||l_batch_size);
457: fnd_file.put_line(FND_FILE.LOG, 'Number of Workers : '||l_Num_Workers);
458: fnd_file.put_line(FND_FILE.LOG, 'Worker Id : '||l_Worker_Id);
459:
460: l_rows_processed := 0;
461: l_total_rows := 0;
462:

Line 511: fnd_file.put_line(FND_FILE.LOG, l_rows_processed ||' rows updated ');

507:
508: l_rows_processed := SQL%ROWCOUNT;
509: l_total_rows := l_total_rows + l_rows_processed;
510:
511: fnd_file.put_line(FND_FILE.LOG, l_rows_processed ||' rows updated ');
512:
513: END;
514:
515: ad_parallel_updates_pkg.processed_rowid_range(l_rows_processed,l_END_rowid);

Line 530: fnd_file.put_line(FND_FILE.LOG, 'Total number of Comm Lines API rows that are updated with NVL(adjust_status,NEW); NVL(PRESERVE_CREDIT_OVERRIDE_FLAG,N) = '||l_total_rows);

526: FALSE);
527:
528: END LOOP;
529:
530: fnd_file.put_line(FND_FILE.LOG, 'Total number of Comm Lines API rows that are updated with NVL(adjust_status,NEW); NVL(PRESERVE_CREDIT_OVERRIDE_FLAG,N) = '||l_total_rows);
531: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
532:
533: EXCEPTION
534: WHEN OTHERS THEN

Line 578: fnd_file.put_line(FND_FILE.LOG, 'Updating Commission Headers => NVL(adjust_status,NEW) to improve performance for SCA process');

574: l_batch_size := p_batch_size;
575: l_num_workers := p_num_workers;
576: l_worker_id := p_worker_id;
577:
578: fnd_file.put_line(FND_FILE.LOG, 'Updating Commission Headers => NVL(adjust_status,NEW) to improve performance for SCA process');
579: -- get schema name of the table for ROWID range processing
580: l_retstatus := fnd_installation.get_app_info(l_product, l_status, l_industry, l_table_owner);
581:
582: if ((l_retstatus = FALSE) OR (l_table_owner is null))

Line 587: fnd_file.put_line(FND_FILE.LOG, 'Batch size : '||l_batch_size);

583: then
584: raise_application_error(-20001, 'Cannot get schema name for product : '||l_product);
585: end if;
586:
587: fnd_file.put_line(FND_FILE.LOG, 'Batch size : '||l_batch_size);
588: fnd_file.put_line(FND_FILE.LOG, 'Number of Workers : '||l_Num_Workers);
589: fnd_file.put_line(FND_FILE.LOG, 'Worker Id : '||l_Worker_Id);
590:
591: l_rows_processed := 0;

Line 588: fnd_file.put_line(FND_FILE.LOG, 'Number of Workers : '||l_Num_Workers);

584: raise_application_error(-20001, 'Cannot get schema name for product : '||l_product);
585: end if;
586:
587: fnd_file.put_line(FND_FILE.LOG, 'Batch size : '||l_batch_size);
588: fnd_file.put_line(FND_FILE.LOG, 'Number of Workers : '||l_Num_Workers);
589: fnd_file.put_line(FND_FILE.LOG, 'Worker Id : '||l_Worker_Id);
590:
591: l_rows_processed := 0;
592: l_total_rows := 0;

Line 589: fnd_file.put_line(FND_FILE.LOG, 'Worker Id : '||l_Worker_Id);

585: end if;
586:
587: fnd_file.put_line(FND_FILE.LOG, 'Batch size : '||l_batch_size);
588: fnd_file.put_line(FND_FILE.LOG, 'Number of Workers : '||l_Num_Workers);
589: fnd_file.put_line(FND_FILE.LOG, 'Worker Id : '||l_Worker_Id);
590:
591: l_rows_processed := 0;
592: l_total_rows := 0;
593:

Line 638: fnd_file.put_line(FND_FILE.LOG, l_rows_processed ||' rows updated ');

634:
635: l_rows_processed := SQL%ROWCOUNT;
636: l_total_rows := l_total_rows + l_rows_processed;
637:
638: fnd_file.put_line(FND_FILE.LOG, l_rows_processed ||' rows updated ');
639:
640: END;
641:
642: ad_parallel_updates_pkg.processed_rowid_range(l_rows_processed,l_END_rowid);

Line 657: fnd_file.put_line(FND_FILE.LOG, 'Total number of Commission Headers rows that are updated with NVL(adjust_status,NEW) = '||l_total_rows);

653: FALSE);
654:
655: END LOOP;
656:
657: fnd_file.put_line(FND_FILE.LOG, 'Total number of Commission Headers rows that are updated with NVL(adjust_status,NEW) = '||l_total_rows);
658: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
659:
660: EXCEPTION
661: WHEN OTHERS THEN

Line 707: fnd_file.put_line(FND_FILE.LOG, 'Updating CN_SRP_PERIOD_QUOTAS_ALL to populate transaction_amount_ptd ');

703: l_batch_size := p_batch_size;
704: l_num_workers := p_num_workers;
705: l_worker_id := p_worker_id;
706:
707: fnd_file.put_line(FND_FILE.LOG, 'Updating CN_SRP_PERIOD_QUOTAS_ALL to populate transaction_amount_ptd ');
708: -- get schema name of the table for ROWID range processing
709: l_retstatus := fnd_installation.get_app_info(l_product, l_status, l_industry, l_table_owner);
710:
711: if ((l_retstatus = FALSE) OR (l_table_owner is null))

Line 716: fnd_file.put_line(FND_FILE.LOG, 'Batch size : '||l_batch_size);

712: then
713: raise_application_error(-20001, 'Cannot get schema name for product : '||l_product);
714: end if;
715:
716: fnd_file.put_line(FND_FILE.LOG, 'Batch size : '||l_batch_size);
717: fnd_file.put_line(FND_FILE.LOG, 'Number of Workers : '||l_Num_Workers);
718: fnd_file.put_line(FND_FILE.LOG, 'Worker Id : '||l_Worker_Id);
719:
720: l_rows_processed := 0;

Line 717: fnd_file.put_line(FND_FILE.LOG, 'Number of Workers : '||l_Num_Workers);

713: raise_application_error(-20001, 'Cannot get schema name for product : '||l_product);
714: end if;
715:
716: fnd_file.put_line(FND_FILE.LOG, 'Batch size : '||l_batch_size);
717: fnd_file.put_line(FND_FILE.LOG, 'Number of Workers : '||l_Num_Workers);
718: fnd_file.put_line(FND_FILE.LOG, 'Worker Id : '||l_Worker_Id);
719:
720: l_rows_processed := 0;
721: l_total_rows := 0;

Line 718: fnd_file.put_line(FND_FILE.LOG, 'Worker Id : '||l_Worker_Id);

714: end if;
715:
716: fnd_file.put_line(FND_FILE.LOG, 'Batch size : '||l_batch_size);
717: fnd_file.put_line(FND_FILE.LOG, 'Number of Workers : '||l_Num_Workers);
718: fnd_file.put_line(FND_FILE.LOG, 'Worker Id : '||l_Worker_Id);
719:
720: l_rows_processed := 0;
721: l_total_rows := 0;
722:

Line 798: fnd_file.put_line(FND_FILE.LOG, l_rows_processed ||' rows updated ');

794:
795: l_rows_processed := SQL%ROWCOUNT;
796: l_total_rows := l_total_rows + l_rows_processed;
797:
798: fnd_file.put_line(FND_FILE.LOG, l_rows_processed ||' rows updated ');
799:
800: END;
801:
802: ad_parallel_updates_pkg.processed_rowid_range(l_rows_processed,l_END_rowid);

Line 817: fnd_file.put_line(FND_FILE.LOG, 'Total number of SRP Period Quotas rows that are updated to populate transaction_amount_ptd = '||l_total_rows);

813: FALSE);
814:
815: END LOOP;
816:
817: fnd_file.put_line(FND_FILE.LOG, 'Total number of SRP Period Quotas rows that are updated to populate transaction_amount_ptd = '||l_total_rows);
818: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
819:
820: EXCEPTION
821: WHEN OTHERS THEN