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

Line 93: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

89: create_status_record(v_edit_check_number, v_edit_check_status) ;
90:
91: EXCEPTION WHEN OTHERS THEN
92: v_log_text := 'Exception when others in Edit Check 1. SQLCODE: '|| SQLCODE ;
93: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
94:
95: v_log_text := 'SQLERRM: '|| SQLERRM ;
96: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
97:

Line 96: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

92: v_log_text := 'Exception when others in Edit Check 1. SQLCODE: '|| SQLCODE ;
93: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
94:
95: v_log_text := 'SQLERRM: '|| SQLERRM ;
96: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
97:
98: g_error_flag := 2;
99: END; --edit_check_1
100:

Line 303: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

299:
300:
301: EXCEPTION WHEN OTHERS THEN
302: v_log_text := 'Exception when others in Edit Check 2. SQLCODE: '|| SQLCODE ;
303: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
304:
305: v_log_text := 'SQLERRM: '|| SQLERRM ;
306: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
307:

Line 306: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

302: v_log_text := 'Exception when others in Edit Check 2. SQLCODE: '|| SQLCODE ;
303: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
304:
305: v_log_text := 'SQLERRM: '|| SQLERRM ;
306: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
307:
308: g_error_flag := 2;
309: END; --edit_check_2
310:

Line 360: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

356:
357:
358: EXCEPTION WHEN OTHERS THEN
359: v_log_text := 'Exception when others in Edit Check 3. SQLCODE: '|| SQLCODE ;
360: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
361:
362: v_log_text := 'SQLERRM: '|| SQLERRM ;
363: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
364:

Line 363: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

359: v_log_text := 'Exception when others in Edit Check 3. SQLCODE: '|| SQLCODE ;
360: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
361:
362: v_log_text := 'SQLERRM: '|| SQLERRM ;
363: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
364:
365: g_error_flag := 2;
366: END; --edit_check_3
367:

Line 431: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

427:
428: EXCEPTION WHEN OTHERS THEN
429:
430: v_log_text := 'Exception when others in Edit Check 4. SQLCODE: '|| SQLCODE ;
431: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
432:
433: v_log_text := 'SQLERRM: '|| SQLERRM ;
434: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
435:

Line 434: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

430: v_log_text := 'Exception when others in Edit Check 4. SQLCODE: '|| SQLCODE ;
431: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
432:
433: v_log_text := 'SQLERRM: '|| SQLERRM ;
434: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
435:
436: g_error_flag := 2;
437: END; --edit_check_4
438:

Line 494: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

490:
491: EXCEPTION WHEN OTHERS THEN
492:
493: v_log_text := 'Exception when others in Edit Check 5. SQLCODE: '|| SQLCODE ;
494: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
495:
496: v_log_text := 'SQLERRM: '|| SQLERRM ;
497: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
498:

Line 497: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

493: v_log_text := 'Exception when others in Edit Check 5. SQLCODE: '|| SQLCODE ;
494: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
495:
496: v_log_text := 'SQLERRM: '|| SQLERRM ;
497: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
498:
499: g_error_flag := 2;
500: END; --edit_check_5
501:

Line 591: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

587:
588: EXCEPTION WHEN OTHERS THEN
589:
590: v_log_text := 'Exception when others in Edit Check 6. SQLCODE: '|| SQLCODE ;
591: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
592:
593: v_log_text := 'SQLERRM: '|| SQLERRM ;
594: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
595:

Line 594: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

590: v_log_text := 'Exception when others in Edit Check 6. SQLCODE: '|| SQLCODE ;
591: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
592:
593: v_log_text := 'SQLERRM: '|| SQLERRM ;
594: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
595:
596: g_error_flag := 2;
597: END; --edit_check_6
598:

Line 660: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

656:
657: EXCEPTION WHEN OTHERS THEN
658:
659: v_log_text := 'Exception when others in Edit Check 7. SQLCODE: '|| SQLCODE ;
660: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
661:
662: v_log_text := 'SQLERRM: '|| SQLERRM ;
663: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
664:

Line 663: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

659: v_log_text := 'Exception when others in Edit Check 7. SQLCODE: '|| SQLCODE ;
660: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
661:
662: v_log_text := 'SQLERRM: '|| SQLERRM ;
663: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
664:
665: g_error_flag := 2;
666: END; -- edit_check_7
667:

Line 710: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

706:
707: EXCEPTION WHEN OTHERS THEN
708:
709: v_log_text := 'Exception when others in Edit Check 10. SQLCODE: '||SQLCODE ;
710: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
711:
712: v_log_text := 'SQLERRM: '||SQLERRM ;
713: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
714:

Line 713: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

709: v_log_text := 'Exception when others in Edit Check 10. SQLCODE: '||SQLCODE ;
710: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
711:
712: v_log_text := 'SQLERRM: '||SQLERRM ;
713: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
714:
715: g_error_flag := 2;
716: END; --edit_check_10
717:

Line 890: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

886:
887: EXCEPTION WHEN OTHERS THEN
888:
889: v_log_text := 'Exception when others in Edit Check 11. SQLCODE: '||SQLCODE ;
890: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
891:
892: v_log_text := 'SQLERRM: '|| SQLERRM ;
893: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
894:

Line 893: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

889: v_log_text := 'Exception when others in Edit Check 11. SQLCODE: '||SQLCODE ;
890: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
891:
892: v_log_text := 'SQLERRM: '|| SQLERRM ;
893: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
894:
895: IF (g_error_flag = 0) THEN
896: g_error_flag := 1;
897: END IF;

Line 1021: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

1017:
1018: EXCEPTION WHEN OTHERS THEN
1019:
1020: v_log_text := 'Exception when others in Edit Check 12. SQLCODE: '||SQLCODE ;
1021: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1022:
1023: v_log_text := 'SQLERRM: '|| SQLERRM ;
1024: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1025:

Line 1024: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

1020: v_log_text := 'Exception when others in Edit Check 12. SQLCODE: '||SQLCODE ;
1021: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1022:
1023: v_log_text := 'SQLERRM: '|| SQLERRM ;
1024: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1025:
1026: g_error_flag := 2;
1027: END; --edit_check_12
1028:

Line 1052: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

1048: FROM fv_treasury_symbols
1049: WHERE treasury_symbol_id = g_treasury_symbol_id;
1050:
1051: v_log_text := 'Edit Check process start...' ;
1052: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1053:
1054: v_log_text := ' ' ;
1055: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1056:

Line 1055: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

1051: v_log_text := 'Edit Check process start...' ;
1052: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1053:
1054: v_log_text := ' ' ;
1055: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1056:
1057: edit_check_1;
1058: edit_check_2;
1059: edit_check_3;

Line 1088: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

1084:
1085: -- Changed log text for bug 2053780
1086:
1087: v_log_text := 'Edit Checks 4,5,6,7,10 and 11 are not needed' ;
1088: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1089:
1090: v_log_text := ' ';
1091: v_edit_check_status := 'Not Needed';
1092:

Line 1119: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

1115: retcode := g_error_flag;
1116: if (retcode = 1) then
1117: errbuf := 'Soft Edit Check Failed.' ;
1118: v_log_text := 'Soft Edit Check Failed.' ;
1119: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1120:
1121: elsif (retcode = 2) then
1122: errbuf := 'Hard Edit Check Failed';
1123: v_log_text := 'Hard Edit Check Failed.' ;

Line 1124: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

1120:
1121: elsif (retcode = 2) then
1122: errbuf := 'Hard Edit Check Failed';
1123: v_log_text := 'Hard Edit Check Failed.' ;
1124: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1125:
1126: else
1127: v_log_text := 'Edit Check Passed.' ;
1128: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

Line 1128: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

1124: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1125:
1126: else
1127: v_log_text := 'Edit Check Passed.' ;
1128: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1129: end if;
1130:
1131: end; --perform_edit_checks
1132:

Line 1155: fnd_file.put_line(FND_FILE.LOG, sqlerrm || ' [CREATE_STATUS_RECORD] ') ;

1151: p_edit_check_status) ;
1152: EXCEPTION
1153: when others then
1154: g_error_flag := sqlcode ;
1155: fnd_file.put_line(FND_FILE.LOG, sqlerrm || ' [CREATE_STATUS_RECORD] ') ;
1156: return;
1157: END; -- create_status_record
1158: -------------------------------------------------------------------------
1159: -- Procedure CREATE_LOG_RECORD

Line 1194: fnd_file.put_line(FND_FILE.LOG, sqlerrm || ' [CREATE_LOG_RECORD] ') ;

1190: v_dummy_var ) ;
1191: EXCEPTION
1192: When Others Then
1193: g_error_flag := sqlcode ;
1194: fnd_file.put_line(FND_FILE.LOG, sqlerrm || ' [CREATE_LOG_RECORD] ') ;
1195: return;
1196:
1197: END CREATE_LOG_RECORD ;
1198: