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

Line 658: FND_FILE.put_line(which => FND_FILE.LOG

654:
655: -- bug 10370545 Starts
656: BEGIN
657: IF (nvl(P_REQUEST_ID,-1) <> -1) THEN
658: FND_FILE.put_line(which => FND_FILE.LOG
659: ,buff => '+-------------------------------+');
660: FND_FILE.put_line(which => FND_FILE.LOG
661: ,buff => '| Report run statistics for TRL |');
662: FND_FILE.put_line(which => FND_FILE.LOG

Line 660: FND_FILE.put_line(which => FND_FILE.LOG

656: BEGIN
657: IF (nvl(P_REQUEST_ID,-1) <> -1) THEN
658: FND_FILE.put_line(which => FND_FILE.LOG
659: ,buff => '+-------------------------------+');
660: FND_FILE.put_line(which => FND_FILE.LOG
661: ,buff => '| Report run statistics for TRL |');
662: FND_FILE.put_line(which => FND_FILE.LOG
663: ,buff => '+-------------------------------+');
664: FND_FILE.put_line(which => FND_FILE.LOG

Line 662: FND_FILE.put_line(which => FND_FILE.LOG

658: FND_FILE.put_line(which => FND_FILE.LOG
659: ,buff => '+-------------------------------+');
660: FND_FILE.put_line(which => FND_FILE.LOG
661: ,buff => '| Report run statistics for TRL |');
662: FND_FILE.put_line(which => FND_FILE.LOG
663: ,buff => '+-------------------------------+');
664: FND_FILE.put_line(which => FND_FILE.LOG
665: ,buff => ' ');
666: FND_FILE.put_line(which => FND_FILE.LOG

Line 664: FND_FILE.put_line(which => FND_FILE.LOG

660: FND_FILE.put_line(which => FND_FILE.LOG
661: ,buff => '| Report run statistics for TRL |');
662: FND_FILE.put_line(which => FND_FILE.LOG
663: ,buff => '+-------------------------------+');
664: FND_FILE.put_line(which => FND_FILE.LOG
665: ,buff => ' ');
666: FND_FILE.put_line(which => FND_FILE.LOG
667: ,buff => 'Data in tables (before the report is run)');
668:

Line 666: FND_FILE.put_line(which => FND_FILE.LOG

662: FND_FILE.put_line(which => FND_FILE.LOG
663: ,buff => '+-------------------------------+');
664: FND_FILE.put_line(which => FND_FILE.LOG
665: ,buff => ' ');
666: FND_FILE.put_line(which => FND_FILE.LOG
667: ,buff => 'Data in tables (before the report is run)');
668:
669: SELECT COUNT(detail_tax_line_id)
670: INTO l_count

Line 673: FND_FILE.put_line(which => FND_FILE.LOG

669: SELECT COUNT(detail_tax_line_id)
670: INTO l_count
671: FROM zx_rep_trx_detail_t;
672:
673: FND_FILE.put_line(which => FND_FILE.LOG
674: ,buff => 'zx_rep_trx_detail_t : '||l_count);
675:
676: SELECT COUNT(actg_ext_line_id)
677: INTO l_count

Line 680: FND_FILE.put_line(which => FND_FILE.LOG

676: SELECT COUNT(actg_ext_line_id)
677: INTO l_count
678: FROM zx_rep_actg_ext_t;
679:
680: FND_FILE.put_line(which => FND_FILE.LOG
681: ,buff => 'zx_rep_actg_ext_t : '||l_count);
682:
683: SELECT COUNT(detail_tax_line_ext_id)
684: INTO l_count

Line 687: FND_FILE.put_line(which => FND_FILE.LOG

683: SELECT COUNT(detail_tax_line_ext_id)
684: INTO l_count
685: FROM zx_rep_trx_jx_ext_t;
686:
687: FND_FILE.put_line(which => FND_FILE.LOG
688: ,buff => 'zx_rep_trx_jx_ext_t : '||l_count);
689:
690: SELECT COUNT(rep_context_id)
691: INTO l_count

Line 694: FND_FILE.put_line(which => FND_FILE.LOG

690: SELECT COUNT(rep_context_id)
691: INTO l_count
692: FROM zx_rep_context_t;
693:
694: FND_FILE.put_line(which => FND_FILE.LOG
695: ,buff => 'zx_rep_context_t : '||l_count);
696:
697: l_start_time := SYSDATE;
698: END IF;

Line 907: FND_FILE.put_line(which => FND_FILE.LOG

903:
904: BEGIN
905: IF (nvl(P_REQUEST_ID,-1) <> -1) THEN
906: l_end_time := SYSDATE;
907: FND_FILE.put_line(which => FND_FILE.LOG
908: ,buff => ' ');
909: FND_FILE.put_line(which => FND_FILE.LOG
910: ,buff => 'TRL Start Time :'||To_Char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
911: FND_FILE.put_line(which => FND_FILE.LOG

Line 909: FND_FILE.put_line(which => FND_FILE.LOG

905: IF (nvl(P_REQUEST_ID,-1) <> -1) THEN
906: l_end_time := SYSDATE;
907: FND_FILE.put_line(which => FND_FILE.LOG
908: ,buff => ' ');
909: FND_FILE.put_line(which => FND_FILE.LOG
910: ,buff => 'TRL Start Time :'||To_Char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
911: FND_FILE.put_line(which => FND_FILE.LOG
912: ,buff => 'TRL End Time :'||To_Char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
913:

Line 911: FND_FILE.put_line(which => FND_FILE.LOG

907: FND_FILE.put_line(which => FND_FILE.LOG
908: ,buff => ' ');
909: FND_FILE.put_line(which => FND_FILE.LOG
910: ,buff => 'TRL Start Time :'||To_Char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
911: FND_FILE.put_line(which => FND_FILE.LOG
912: ,buff => 'TRL End Time :'||To_Char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
913:
914:
915: SELECT floor((l_end_time-l_start_time)*24)

Line 925: FND_FILE.put_line(which => FND_FILE.LOG

921: INTO l_total_time
922: FROM dual;
923:
924:
925: FND_FILE.put_line(which => FND_FILE.LOG
926: ,buff => 'Total Time Taken :'||l_total_time);
927: END IF;
928:
929: EXCEPTION