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.FV_FLATFILES dependencies on FND_LOG

Line 75: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

71: AND ffs.Bulk_File_Sub_Id = '||request_id||
72: ' AND ffs.set_of_books_id = '||sob_id||
73: ' ORDER BY fts.treasury_symbol';
74:
75: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
76: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVFCTHRC');
77: END IF;
78:
79:

Line 76: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVFCTHRC');

72: ' AND ffs.set_of_books_id = '||sob_id||
73: ' ORDER BY fts.treasury_symbol';
74:
75: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
76: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVFCTHRC');
77: END IF;
78:
79:
80: fv_flatfiles.create_flat_file(statement);

Line 100: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

96: 'SELECT record
97: FROM fv_ecs_ncrpay_temp
98: ORDER by line_no';
99:
100: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
101: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVXTIVC1');
102: END IF;
103:
104:

Line 101: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVXTIVC1');

97: FROM fv_ecs_ncrpay_temp
98: ORDER by line_no';
99:
100: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
101: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVXTIVC1');
102: END IF;
103:
104:
105: fv_flatfiles.create_flat_file(statement);

Line 123: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

119: ' AND org_id = '||parameter2||
120: ' AND checkrun_name = '||''''||parameter3||''''||
121: ' ORDER by line_no';
122:
123: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
124: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVTICTXR');
125: END IF;
126:
127: fv_flatfiles.create_flat_file(statement);

Line 124: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVTICTXR');

120: ' AND checkrun_name = '||''''||parameter3||''''||
121: ' ORDER by line_no';
122:
123: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
124: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVTICTXR');
125: END IF;
126:
127: fv_flatfiles.create_flat_file(statement);
128: DELETE FROM fv_payment_format_temp

Line 143: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

139: 'SELECT record
140: FROM fv_ecs_ach_vendor_temp
141: ORDER by line_no';
142:
143: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
144: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVTIACHR');
145: END IF;
146:
147: fv_flatfiles.create_flat_file(statement);

Line 144: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVTIACHR');

140: FROM fv_ecs_ach_vendor_temp
141: ORDER by line_no';
142:
143: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
144: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVTIACHR');
145: END IF;
146:
147: fv_flatfiles.create_flat_file(statement);
148:

Line 168: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

164: ' AND ffs.set_of_books_id = '||sob_id||
165: ' AND fts.set_of_books_id = '||sob_id||
166: ' ORDER BY fts.treasury_symbol, fft.sgl_acct_number' ;
167:
168: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
169: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVFCTDRC');
170: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Detail Records...');
171: END IF;
172:

Line 169: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVFCTDRC');

165: ' AND fts.set_of_books_id = '||sob_id||
166: ' ORDER BY fts.treasury_symbol, fft.sgl_acct_number' ;
167:
168: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
169: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVFCTDRC');
170: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Detail Records...');
171: END IF;
172:
173: fv_flatfiles.create_flat_file(statement);

Line 170: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Detail Records...');

166: ' ORDER BY fts.treasury_symbol, fft.sgl_acct_number' ;
167:
168: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
169: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVFCTDRC');
170: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Detail Records...');
171: END IF;
172:
173: fv_flatfiles.create_flat_file(statement);
174:

Line 245: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

241: 'SELECT goals_224_record
242: FROM fv_goals_224_temp
243: ORDER BY goals_224_temp_id';
244:
245: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
246: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVTI224R');
247: END IF;
248:
249: fv_flatfiles.create_flat_file(statement);

Line 246: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVTI224R');

242: FROM fv_goals_224_temp
243: ORDER BY goals_224_temp_id';
244:
245: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
246: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVTI224R');
247: END IF;
248:
249: fv_flatfiles.create_flat_file(statement);
250: -- -----------------------------------------------------------------------------------

Line 259: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

255: 'SELECT record
256: FROM fv_opac_upload_temp
257: ORDER BY line_no';
258:
259: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
260: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVTIOBUR');
261: END IF;
262:
263: fv_flatfiles.create_flat_file(statement);

Line 260: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVTIOBUR');

256: FROM fv_opac_upload_temp
257: ORDER BY line_no';
258:
259: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
260: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVTIOBUR');
261: END IF;
262:
263: fv_flatfiles.create_flat_file(statement);
264: -- -----------------------------------------------------------------------------------

Line 276: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

272: -- statement :=
273: -- 'SELECT ''ENTITY IS ''' || entity_code ||' From Dual' ;
274:
275: -- Enh No:1541559
276: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
277: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVFACTSR');
278: END IF;
279: --fnd_file.put_line(fnd_file.output, 'ENTITY IS '||entity_code);
280:

Line 277: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVFACTSR');

273: -- 'SELECT ''ENTITY IS ''' || entity_code ||' From Dual' ;
274:
275: -- Enh No:1541559
276: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
277: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVFACTSR');
278: END IF;
279: --fnd_file.put_line(fnd_file.output, 'ENTITY IS '||entity_code);
280:
281: -- fv_flatfiles.create_flat_file(statement);

Line 426: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

422: 'SELECT substr(goals_133_record,1,75)
423: FROM fv_goals_133_temp
424: ORDER BY goals_133_record_type, goals_133_temp_id';
425:
426: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
427: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVTI133R');
428: END IF;
429:
430: fv_flatfiles.create_flat_file(statement);

Line 427: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVTI133R');

423: FROM fv_goals_133_temp
424: ORDER BY goals_133_record_type, goals_133_temp_id';
425:
426: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
427: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVTI133R');
428: END IF;
429:
430: fv_flatfiles.create_flat_file(statement);
431: -- -----------------------------------------------------------------------------------

Line 484: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

480: WHERE hou.organization_id = fou.organization_id
481: AND hl.location_id = hou.location_id
482: AND fou.set_of_books_id = sob_id';
483:
484: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
485: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVTI133R');
486: END IF;
487:
488: fv_flatfiles.create_flat_file(statement);

Line 485: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVTI133R');

481: AND hl.location_id = hou.location_id
482: AND fou.set_of_books_id = sob_id';
483:
484: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
485: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVTI133R');
486: END IF;
487:
488: fv_flatfiles.create_flat_file(statement);
489: -- ---------------------------------------------------

Line 541: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',vp_errbuf);

537: END IF;
538: EXCEPTION
539: WHEN OTHERS THEN
540: vp_errbuf := SQLERRM;
541: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',vp_errbuf);
542: RAISE;
543: end main;
544: -- ----------------------------------------------------------------------------
545: PROCEDURE create_flat_file(v_statement VARCHAR2) IS

Line 559: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.open_v_cursor',vp_errbuf);

555: v_cursor := DBMS_SQL.OPEN_CURSOR;
556: EXCEPTION WHEN OTHERS THEN
557: vp_errbuf := sqlerrm;
558: vp_retcode := sqlcode;
559: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.open_v_cursor',vp_errbuf);
560: RETURN;
561: END;
562:
563: BEGIN

Line 568: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.parse_v_cursor',vp_errbuf);

564: DBMS_SQL.PARSE(v_cursor, v_statement, DBMS_SQL.V7);
565: EXCEPTION WHEN OTHERS THEN
566: vp_retcode := sqlcode ;
567: VP_ERRBUF := sqlerrm ;
568: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.parse_v_cursor',vp_errbuf);
569: RETURN ;
570: END ;
571:
572: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, col1, 2000);

Line 579: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.execute_v_cursor',vp_errbuf);

575: l_fetch_count := DBMS_SQL.EXECUTE(v_cursor);
576: EXCEPTION WHEN OTHERS THEN
577: vp_retcode := sqlcode ;
578: VP_ERRBUF := sqlerrm ;
579: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.execute_v_cursor',vp_errbuf);
580: RETURN ;
581: END;
582:
583: gbl_count := 0;

Line 597: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',vp_errbuf);

593: END LOOP;
594: EXCEPTION
595: WHEN OTHERS THEN
596: vp_errbuf := SQLERRM;
597: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',vp_errbuf);
598: RAISE;
599: end create_flat_file;
600: -- ----------------------------------------------------------------------------
601: end fv_flatfiles;