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_PERIODS_API dependencies on FND_FILE

Line 214: fnd_file.put_line(fnd_file.Log, 'Step 5 : Parallel Process Starts');

210: primary_ptr := 1;
211: l_completed_batch_count := 0;
212: g_batch_total := 0;
213: ---------------------------------------------------------------------
214: fnd_file.put_line(fnd_file.Log, 'Step 5 : Parallel Process Starts');
215: ---------------------------------------------------------------------
216: FOR physical_rec IN physical_batches LOOP
217: fnd_request.set_org_id(p_org_id);
218: l_temp_id := fnd_request.submit_request

Line 249: fnd_file.put_line(fnd_file.Log, 'Step 6 : Total Batches Submitted => ' || g_batch_total);

245: END IF;
246:
247: cn_message_pkg.debug('Number of batches submitted: ' || g_batch_total);
248: ------------------------------------------------------------------------------------------
249: fnd_file.put_line(fnd_file.Log, 'Step 6 : Total Batches Submitted => ' || g_batch_total);
250: ------------------------------------------------------------------------------------------
251: dbms_lock.sleep(l_sleep_time);
252:
253: WHILE l_completed_batch_count <= g_batch_total LOOP

Line 300: fnd_file.put_line(fnd_file.Log, 'Step 7 : No Physical Batches to process');

296: EXCEPTION
297: WHEN no_data_found THEN
298: cn_message_pkg.debug('Conc_dispatch: no physical batches to process');
299: ---------------------------------------------------------------------------
300: fnd_file.put_line(fnd_file.Log, 'Step 7 : No Physical Batches to process');
301: ---------------------------------------------------------------------------
302: WHEN conc_fail THEN
303: update_error(l_temp_phys_batch_id);
304: cn_message_pkg.debug('Concurrent program fails: ' || l_temp_phys_batch_id);

Line 306: fnd_file.put_line(fnd_file.Log, 'Step 7 : Concurrent Program (Physical Batch) Failed => ' || l_temp_phys_batch_id);

302: WHEN conc_fail THEN
303: update_error(l_temp_phys_batch_id);
304: cn_message_pkg.debug('Concurrent program fails: ' || l_temp_phys_batch_id);
305: --------------------------------------------------------------------------------------------------------------------
306: fnd_file.put_line(fnd_file.Log, 'Step 7 : Concurrent Program (Physical Batch) Failed => ' || l_temp_phys_batch_id);
307: --------------------------------------------------------------------------------------------------------------------
308: WHEN others THEN
309: cn_message_pkg.debug(sqlerrm);
310: cn_message_pkg.rollback_errormsg_commit('Exception in conc_dispatch');

Line 312: fnd_file.put_line(fnd_file.Log, 'Step 7 : Some Other Exception in Conc Dispatch');

308: WHEN others THEN
309: cn_message_pkg.debug(sqlerrm);
310: cn_message_pkg.rollback_errormsg_commit('Exception in conc_dispatch');
311: ---------------------------------------------------------------------------------
312: fnd_file.put_line(fnd_file.Log, 'Step 7 : Some Other Exception in Conc Dispatch');
313: ---------------------------------------------------------------------------------
314: RAISE;
315: END conc_dispatch;
316:

Line 371: fnd_file.put_line(fnd_file.Log, 'Open Period Process - Start');

367: p_org_id => l_org_id);
368:
369: cn_message_pkg.debug('Beginning of open periods process.');
370: ---------------------------------------------------------------
371: fnd_file.put_line(fnd_file.Log, 'Open Period Process - Start');
372: ---------------------------------------------------------------
373: --initialize message list
374: fnd_msg_pub.initialize;
375:

Line 386: fnd_file.put_line(fnd_file.Log, 'Step 1 : Period Information');

382: from cn_period_statuses
383: where processing_status_code = 'PROCESSING';
384:
385: ----------------------------------------------------------------------------------
386: fnd_file.put_line(fnd_file.Log, 'Step 1 : Period Information');
387: fnd_file.put_line(fnd_file.Log, ' : Min Period Id => '||l_start_period_id);
388: fnd_file.put_line(fnd_file.Log, ' : Max Period Id => '||l_end_period_id);
389: ----------------------------------------------------------------------------------
390:

Line 387: fnd_file.put_line(fnd_file.Log, ' : Min Period Id => '||l_start_period_id);

383: where processing_status_code = 'PROCESSING';
384:
385: ----------------------------------------------------------------------------------
386: fnd_file.put_line(fnd_file.Log, 'Step 1 : Period Information');
387: fnd_file.put_line(fnd_file.Log, ' : Min Period Id => '||l_start_period_id);
388: fnd_file.put_line(fnd_file.Log, ' : Max Period Id => '||l_end_period_id);
389: ----------------------------------------------------------------------------------
390:
391: insert into cn_process_batches

Line 388: fnd_file.put_line(fnd_file.Log, ' : Max Period Id => '||l_end_period_id);

384:
385: ----------------------------------------------------------------------------------
386: fnd_file.put_line(fnd_file.Log, 'Step 1 : Period Information');
387: fnd_file.put_line(fnd_file.Log, ' : Min Period Id => '||l_start_period_id);
388: fnd_file.put_line(fnd_file.Log, ' : Max Period Id => '||l_end_period_id);
389: ----------------------------------------------------------------------------------
390:
391: insert into cn_process_batches
392: (process_batch_id,

Line 449: fnd_file.put_line(fnd_file.Log, 'Step 2 : Salesrep Batch Size => '||l_temp);

445:
446: l_temp := cn_global_var.get_salesrep_batch_size(l_org_id);
447:
448: ----------------------------------------------------------------------------
449: fnd_file.put_line(fnd_file.Log, 'Step 2 : Salesrep Batch Size => '||l_temp);
450: fnd_file.put_line(fnd_file.Log, ' : Logical Batch Id => '||l_logical_batch_id);
451: ----------------------------------------------------------------------------
452:
453: loop

Line 450: fnd_file.put_line(fnd_file.Log, ' : Logical Batch Id => '||l_logical_batch_id);

446: l_temp := cn_global_var.get_salesrep_batch_size(l_org_id);
447:
448: ----------------------------------------------------------------------------
449: fnd_file.put_line(fnd_file.Log, 'Step 2 : Salesrep Batch Size => '||l_temp);
450: fnd_file.put_line(fnd_file.Log, ' : Logical Batch Id => '||l_logical_batch_id);
451: ----------------------------------------------------------------------------
452:
453: loop
454: select cn_process_batches_s3.nextval into l_physical_batch_id from dual;

Line 456: fnd_file.put_line(fnd_file.Log, ' : Physical Batch Id => '||l_physical_batch_id);

452:
453: loop
454: select cn_process_batches_s3.nextval into l_physical_batch_id from dual;
455: ----------------------------------------------------------------------------
456: fnd_file.put_line(fnd_file.Log, ' : Physical Batch Id => '||l_physical_batch_id);
457: ----------------------------------------------------------------------------
458: update cn_process_batches
459: set physical_batch_id = l_physical_batch_id
460: where logical_batch_id = l_logical_batch_id

Line 511: fnd_file.put_line(fnd_file.Log, 'Step 3 : Quotas are updated successfully');

507: WHERE processing_status_code = 'PROCESSING'
508: AND period_id between l_start_period_id AND l_end_period_id;
509:
510: -----------------------------------------------------------------------------
511: fnd_file.put_line(fnd_file.Log, 'Step 3 : Quotas are updated successfully');
512: -----------------------------------------------------------------------------
513:
514: -----------------------------------------------------------------------------
515: fnd_file.put_line(fnd_file.Log, 'Step 4 : Processing Status => PROCESSING ');

Line 515: fnd_file.put_line(fnd_file.Log, 'Step 4 : Processing Status => PROCESSING ');

511: fnd_file.put_line(fnd_file.Log, 'Step 3 : Quotas are updated successfully');
512: -----------------------------------------------------------------------------
513:
514: -----------------------------------------------------------------------------
515: fnd_file.put_line(fnd_file.Log, 'Step 4 : Processing Status => PROCESSING ');
516: -----------------------------------------------------------------------------
517:
518: commit;
519:

Line 536: fnd_file.put_line(fnd_file.Log, ' : No Exceptions found in Step 7');

532: RAISE;
533: END;
534:
535: ----------------------------------------------------------------------------------------
536: fnd_file.put_line(fnd_file.Log, ' : No Exceptions found in Step 7');
537: fnd_file.put_line(fnd_file.Log, 'Step 8 : All Physical Batches completed successfully');
538: ----------------------------------------------------------------------------------------
539:
540: -------------------------------------------------------------------

Line 537: fnd_file.put_line(fnd_file.Log, 'Step 8 : All Physical Batches completed successfully');

533: END;
534:
535: ----------------------------------------------------------------------------------------
536: fnd_file.put_line(fnd_file.Log, ' : No Exceptions found in Step 7');
537: fnd_file.put_line(fnd_file.Log, 'Step 8 : All Physical Batches completed successfully');
538: ----------------------------------------------------------------------------------------
539:
540: -------------------------------------------------------------------
541: fnd_file.put_line(fnd_file.Log, 'Step 9 : Parallel Process Ends');

Line 541: fnd_file.put_line(fnd_file.Log, 'Step 9 : Parallel Process Ends');

537: fnd_file.put_line(fnd_file.Log, 'Step 8 : All Physical Batches completed successfully');
538: ----------------------------------------------------------------------------------------
539:
540: -------------------------------------------------------------------
541: fnd_file.put_line(fnd_file.Log, 'Step 9 : Parallel Process Ends');
542: -------------------------------------------------------------------
543:
544: UPDATE cn_period_statuses
545: SET processing_status_code = 'CLEAN'

Line 550: fnd_file.put_line(fnd_file.Log, 'Step 10 : Processing Status => CLEAN ');

546: WHERE processing_status_code = 'PROCESSING'
547: AND period_id between l_start_period_id AND l_end_period_id;
548:
549: ------------------------------------------------------------------------
550: fnd_file.put_line(fnd_file.Log, 'Step 10 : Processing Status => CLEAN ');
551: ------------------------------------------------------------------------
552:
553: cn_message_pkg.debug('End of open periods process.');
554: COMMIT;

Line 557: fnd_file.put_line(fnd_file.Log, 'Open Period Process - End');

553: cn_message_pkg.debug('End of open periods process.');
554: COMMIT;
555:
556: -------------------------------------------------------------
557: fnd_file.put_line(fnd_file.Log, 'Open Period Process - End');
558: -------------------------------------------------------------
559:
560: cn_message_pkg.end_batch(l_proc_audit_id);
561: EXCEPTION

Line 779: fnd_file.put_line(fnd_file.Log, l_loading_status);

775: p_quota_id => NULL, -- do all quotas
776: p_sync_flag => FND_API.G_FALSE, -- don't sync right here
777: x_loading_status => l_loading_status);
778:
779: fnd_file.put_line(fnd_file.Log, l_loading_status);
780: fnd_file.put_line(fnd_file.Log, l_msg_data);
781: fnd_file.put_line(fnd_file.Log, 'role ' || c.role_id);
782: fnd_file.put_line(fnd_file.Log, 'plan ' || c.comp_plan_id);
783: fnd_file.put_line(fnd_file.Log, 'dates ' || c.start_date || ', ' || c.end_date);

Line 780: fnd_file.put_line(fnd_file.Log, l_msg_data);

776: p_sync_flag => FND_API.G_FALSE, -- don't sync right here
777: x_loading_status => l_loading_status);
778:
779: fnd_file.put_line(fnd_file.Log, l_loading_status);
780: fnd_file.put_line(fnd_file.Log, l_msg_data);
781: fnd_file.put_line(fnd_file.Log, 'role ' || c.role_id);
782: fnd_file.put_line(fnd_file.Log, 'plan ' || c.comp_plan_id);
783: fnd_file.put_line(fnd_file.Log, 'dates ' || c.start_date || ', ' || c.end_date);
784:

Line 781: fnd_file.put_line(fnd_file.Log, 'role ' || c.role_id);

777: x_loading_status => l_loading_status);
778:
779: fnd_file.put_line(fnd_file.Log, l_loading_status);
780: fnd_file.put_line(fnd_file.Log, l_msg_data);
781: fnd_file.put_line(fnd_file.Log, 'role ' || c.role_id);
782: fnd_file.put_line(fnd_file.Log, 'plan ' || c.comp_plan_id);
783: fnd_file.put_line(fnd_file.Log, 'dates ' || c.start_date || ', ' || c.end_date);
784:
785:

Line 782: fnd_file.put_line(fnd_file.Log, 'plan ' || c.comp_plan_id);

778:
779: fnd_file.put_line(fnd_file.Log, l_loading_status);
780: fnd_file.put_line(fnd_file.Log, l_msg_data);
781: fnd_file.put_line(fnd_file.Log, 'role ' || c.role_id);
782: fnd_file.put_line(fnd_file.Log, 'plan ' || c.comp_plan_id);
783: fnd_file.put_line(fnd_file.Log, 'dates ' || c.start_date || ', ' || c.end_date);
784:
785:
786: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 783: fnd_file.put_line(fnd_file.Log, 'dates ' || c.start_date || ', ' || c.end_date);

779: fnd_file.put_line(fnd_file.Log, l_loading_status);
780: fnd_file.put_line(fnd_file.Log, l_msg_data);
781: fnd_file.put_line(fnd_file.Log, 'role ' || c.role_id);
782: fnd_file.put_line(fnd_file.Log, 'plan ' || c.comp_plan_id);
783: fnd_file.put_line(fnd_file.Log, 'dates ' || c.start_date || ', ' || c.end_date);
784:
785:
786: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
787: RAISE srp_pop_failed;

Line 890: fnd_file.put_line(fnd_file.Log, 'Payee Population Failed');

886: AND period_id = l_curr_pd_id;
887: -- commit status change
888: COMMIT;
889:
890: fnd_file.put_line(fnd_file.Log, 'Payee Population Failed');
891: fnd_file.put_line(fnd_file.Log, 'salesrep id'||l_err_srp_id);
892: fnd_file.put_line(fnd_file.Log, 'period id'||l_period_id);
893: fnd_file.put_line(fnd_file.Log, 'quota id'||l_err_quota_id);
894: WHEN srp_pop_failed THEN

Line 891: fnd_file.put_line(fnd_file.Log, 'salesrep id'||l_err_srp_id);

887: -- commit status change
888: COMMIT;
889:
890: fnd_file.put_line(fnd_file.Log, 'Payee Population Failed');
891: fnd_file.put_line(fnd_file.Log, 'salesrep id'||l_err_srp_id);
892: fnd_file.put_line(fnd_file.Log, 'period id'||l_period_id);
893: fnd_file.put_line(fnd_file.Log, 'quota id'||l_err_quota_id);
894: WHEN srp_pop_failed THEN
895: --ROLLBACK TO populate_srp_tables_runner;

Line 892: fnd_file.put_line(fnd_file.Log, 'period id'||l_period_id);

888: COMMIT;
889:
890: fnd_file.put_line(fnd_file.Log, 'Payee Population Failed');
891: fnd_file.put_line(fnd_file.Log, 'salesrep id'||l_err_srp_id);
892: fnd_file.put_line(fnd_file.Log, 'period id'||l_period_id);
893: fnd_file.put_line(fnd_file.Log, 'quota id'||l_err_quota_id);
894: WHEN srp_pop_failed THEN
895: --ROLLBACK TO populate_srp_tables_runner;
896: retcode := 2;

Line 893: fnd_file.put_line(fnd_file.Log, 'quota id'||l_err_quota_id);

889:
890: fnd_file.put_line(fnd_file.Log, 'Payee Population Failed');
891: fnd_file.put_line(fnd_file.Log, 'salesrep id'||l_err_srp_id);
892: fnd_file.put_line(fnd_file.Log, 'period id'||l_period_id);
893: fnd_file.put_line(fnd_file.Log, 'quota id'||l_err_quota_id);
894: WHEN srp_pop_failed THEN
895: --ROLLBACK TO populate_srp_tables_runner;
896: retcode := 2;
897:

Line 906: fnd_file.put_line(fnd_file.Log, 'Srp Periods Population Failed');

902: AND period_id = l_curr_pd_id;
903: -- commit status change
904: COMMIT;
905:
906: fnd_file.put_line(fnd_file.Log, 'Srp Periods Population Failed');
907: fnd_file.put_line(fnd_file.Log, 'salesrep id'||l_curr_srp_id);
908: fnd_file.put_line(fnd_file.Log, 'period id'||l_curr_pd_id);
909: WHEN OTHERS THEN
910: --ROLLBACK TO populate_srp_tables_runner;

Line 907: fnd_file.put_line(fnd_file.Log, 'salesrep id'||l_curr_srp_id);

903: -- commit status change
904: COMMIT;
905:
906: fnd_file.put_line(fnd_file.Log, 'Srp Periods Population Failed');
907: fnd_file.put_line(fnd_file.Log, 'salesrep id'||l_curr_srp_id);
908: fnd_file.put_line(fnd_file.Log, 'period id'||l_curr_pd_id);
909: WHEN OTHERS THEN
910: --ROLLBACK TO populate_srp_tables_runner;
911: errbuf := substr(sqlerrm,1,250);

Line 908: fnd_file.put_line(fnd_file.Log, 'period id'||l_curr_pd_id);

904: COMMIT;
905:
906: fnd_file.put_line(fnd_file.Log, 'Srp Periods Population Failed');
907: fnd_file.put_line(fnd_file.Log, 'salesrep id'||l_curr_srp_id);
908: fnd_file.put_line(fnd_file.Log, 'period id'||l_curr_pd_id);
909: WHEN OTHERS THEN
910: --ROLLBACK TO populate_srp_tables_runner;
911: errbuf := substr(sqlerrm,1,250);
912: retcode := 2;

Line 922: fnd_file.put_line(fnd_file.Log, 'Unknown Failure');

918: AND period_id = l_curr_pd_id;
919: -- commit status change
920: COMMIT;
921:
922: fnd_file.put_line(fnd_file.Log, 'Unknown Failure');
923: fnd_file.put_line(fnd_file.Log, 'salesrep id'||l_curr_srp_id);
924: fnd_file.put_line(fnd_file.Log, 'period id'||l_curr_pd_id);
925: fnd_file.put_line(fnd_file.Log, 'errbuf'||errbuf);
926: END populate_srp_tables_runner;

Line 923: fnd_file.put_line(fnd_file.Log, 'salesrep id'||l_curr_srp_id);

919: -- commit status change
920: COMMIT;
921:
922: fnd_file.put_line(fnd_file.Log, 'Unknown Failure');
923: fnd_file.put_line(fnd_file.Log, 'salesrep id'||l_curr_srp_id);
924: fnd_file.put_line(fnd_file.Log, 'period id'||l_curr_pd_id);
925: fnd_file.put_line(fnd_file.Log, 'errbuf'||errbuf);
926: END populate_srp_tables_runner;
927:

Line 924: fnd_file.put_line(fnd_file.Log, 'period id'||l_curr_pd_id);

920: COMMIT;
921:
922: fnd_file.put_line(fnd_file.Log, 'Unknown Failure');
923: fnd_file.put_line(fnd_file.Log, 'salesrep id'||l_curr_srp_id);
924: fnd_file.put_line(fnd_file.Log, 'period id'||l_curr_pd_id);
925: fnd_file.put_line(fnd_file.Log, 'errbuf'||errbuf);
926: END populate_srp_tables_runner;
927:
928:

Line 925: fnd_file.put_line(fnd_file.Log, 'errbuf'||errbuf);

921:
922: fnd_file.put_line(fnd_file.Log, 'Unknown Failure');
923: fnd_file.put_line(fnd_file.Log, 'salesrep id'||l_curr_srp_id);
924: fnd_file.put_line(fnd_file.Log, 'period id'||l_curr_pd_id);
925: fnd_file.put_line(fnd_file.Log, 'errbuf'||errbuf);
926: END populate_srp_tables_runner;
927:
928:
929: /* ----------------------------------------------------------------------- */