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

Line 770: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(sysdate,'HH:MI:SS: ')|| p_message);

766: begin
767:
768: -- IF ( G_DEBUG_MODE = 'Y') THEN
769:
770: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(sysdate,'HH:MI:SS: ')|| p_message);
771:
772: -- END IF;
773:
774: EXCEPTION

Line 823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_tblock);

819: SELECT rpad(l_sob_name,30,' ')||lpad(l_tmp_str,75,' ')||sysdate
820: INTO l_tblock
821: FROM DUAL;
822:
823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_tblock);
824: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
825:
826: SELECT meaning
827: INTO l_tmp_str

Line 824: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);

820: INTO l_tblock
821: FROM DUAL;
822:
823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_tblock);
824: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
825:
826: SELECT meaning
827: INTO l_tmp_str
828: FROM PA_LOOKUPS

Line 836: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_tblock);

832: SELECT lpad(l_tmp_str,66+length(l_tmp_str)/2,' ')
833: INTO l_tblock
834: FROM DUAL;
835:
836: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_tblock);
837: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);
838:
839: SELECT lpad(meaning,32,' ')
840: INTO l_tmp_str

Line 837: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);

833: INTO l_tblock
834: FROM DUAL;
835:
836: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_tblock);
837: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);
838:
839: SELECT lpad(meaning,32,' ')
840: INTO l_tmp_str
841: FROM PA_LOOKUPS

Line 845: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tmp_str||p_archive_flag);

841: FROM PA_LOOKUPS
842: WHERE lookup_type = 'UNASSIGNED_PURGE_REPORT'
843: AND lookup_code = 'PA_R_UNASS_TIME_03';
844:
845: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tmp_str||p_archive_flag);
846: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
847:
848: SELECT lpad(meaning,32,' ')
849: INTO l_tmp_str

Line 846: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

842: WHERE lookup_type = 'UNASSIGNED_PURGE_REPORT'
843: AND lookup_code = 'PA_R_UNASS_TIME_03';
844:
845: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tmp_str||p_archive_flag);
846: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
847:
848: SELECT lpad(meaning,32,' ')
849: INTO l_tmp_str
850: FROM PA_LOOKUPS

Line 854: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tmp_str||p_txn_to_date);

850: FROM PA_LOOKUPS
851: WHERE lookup_type = 'UNASSIGNED_PURGE_REPORT'
852: AND lookup_code = 'PA_R_UNASS_TIME_04';
853:
854: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tmp_str||p_txn_to_date);
855: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);
856:
857: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------------------------------------');
858: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

Line 855: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);

851: WHERE lookup_type = 'UNASSIGNED_PURGE_REPORT'
852: AND lookup_code = 'PA_R_UNASS_TIME_04';
853:
854: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tmp_str||p_txn_to_date);
855: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);
856:
857: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------------------------------------');
858: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
859:

Line 857: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------------------------------------');

853:
854: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tmp_str||p_txn_to_date);
855: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);
856:
857: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------------------------------------');
858: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
859:
860: SELECT ' '||rpad(meaning,20,' ')
861: INTO l_tmp_str

Line 858: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

854: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tmp_str||p_txn_to_date);
855: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);
856:
857: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------------------------------------');
858: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
859:
860: SELECT ' '||rpad(meaning,20,' ')
861: INTO l_tmp_str
862: FROM PA_LOOKUPS

Line 882: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tblock);

878: SELECT l_tmp_str||' '||l_tmp_str2||l_tmp_str3
879: INTO l_tblock
880: FROM DUAL;
881:
882: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tblock);
883:
884: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
885: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------------------------------------');
886: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

Line 884: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

880: FROM DUAL;
881:
882: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tblock);
883:
884: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
885: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------------------------------------');
886: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
887: For i in c_arpr_details LOOP
888:

Line 885: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------------------------------------');

881:
882: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tblock);
883:
884: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
885: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------------------------------------');
886: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
887: For i in c_arpr_details LOOP
888:
889: SELECT ' '||rpad(i.table_name,30,' ')||lpad(i.num_recs_archived,26,' ')||' '||lpad(i.num_recs_purged,24,' ')

Line 886: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

882: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tblock);
883:
884: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
885: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------------------------------------');
886: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
887: For i in c_arpr_details LOOP
888:
889: SELECT ' '||rpad(i.table_name,30,' ')||lpad(i.num_recs_archived,26,' ')||' '||lpad(i.num_recs_purged,24,' ')
890: INTO

Line 894: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tmp_str);

890: INTO
891: l_tmp_str
892: FROM DUAL;
893:
894: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tmp_str);
895:
896: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
897:
898: END LOOP;

Line 896: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

892: FROM DUAL;
893:
894: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tmp_str);
895:
896: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
897:
898: END LOOP;
899:
900: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------------------------------------');

Line 900: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------------------------------------');

896: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
897:
898: END LOOP;
899:
900: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------------------------------------');
901:
902: EXCEPTION
903:
904: WHEN OTHERS THEN