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.

[Home] [Help]

APPS.FV_FLATFILES dependencies on FND_LOG

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

423: period_year := parameter3;
424: sob_id := parameter4;
425: reporting_period := parameter5;
426:
427: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
428: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for GTAS Bulk File process');
429: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Parameters:');
430: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'period_num:'||period_num);
431: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'period_year:'||period_year);

Line 428: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for GTAS Bulk File process');

424: sob_id := parameter4;
425: reporting_period := parameter5;
426:
427: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
428: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for GTAS Bulk File process');
429: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Parameters:');
430: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'period_num:'||period_num);
431: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'period_year:'||period_year);
432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'sob_id:'||sob_id);

Line 429: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Parameters:');

425: reporting_period := parameter5;
426:
427: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
428: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for GTAS Bulk File process');
429: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Parameters:');
430: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'period_num:'||period_num);
431: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'period_year:'||period_year);
432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'sob_id:'||sob_id);
433: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'reporting_period:'||reporting_period);

Line 430: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'period_num:'||period_num);

426:
427: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
428: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for GTAS Bulk File process');
429: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Parameters:');
430: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'period_num:'||period_num);
431: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'period_year:'||period_year);
432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'sob_id:'||sob_id);
433: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'reporting_period:'||reporting_period);
434: END IF;

Line 431: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'period_year:'||period_year);

427: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
428: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for GTAS Bulk File process');
429: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Parameters:');
430: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'period_num:'||period_num);
431: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'period_year:'||period_year);
432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'sob_id:'||sob_id);
433: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'reporting_period:'||reporting_period);
434: END IF;
435:

Line 432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'sob_id:'||sob_id);

428: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for GTAS Bulk File process');
429: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Parameters:');
430: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'period_num:'||period_num);
431: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'period_year:'||period_year);
432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'sob_id:'||sob_id);
433: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'reporting_period:'||reporting_period);
434: END IF;
435:
436: statement :=

Line 433: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'reporting_period:'||reporting_period);

429: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Parameters:');
430: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'period_num:'||period_num);
431: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'period_year:'||period_year);
432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'sob_id:'||sob_id);
433: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'reporting_period:'||reporting_period);
434: END IF;
435:
436: statement :=
437: 'select f1.period_year ||' ||''''||reporting_period||''''||

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

535: 'SELECT substr(goals_133_record,1,75)
536: FROM fv_goals_133_temp
537: ORDER BY goals_133_record_type, goals_133_temp_id';
538:
539: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
540: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVTI133R');
541: END IF;
542:
543: fv_flatfiles.create_flat_file(statement);

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

536: FROM fv_goals_133_temp
537: ORDER BY goals_133_record_type, goals_133_temp_id';
538:
539: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
540: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVTI133R');
541: END IF;
542:
543: fv_flatfiles.create_flat_file(statement);
544: -- -----------------------------------------------------------------------------------

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

593: WHERE hou.organization_id = fou.organization_id
594: AND hl.location_id = hou.location_id
595: AND fou.set_of_books_id = sob_id';
596:
597: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
598: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVTI133R');
599: END IF;
600:
601: fv_flatfiles.create_flat_file(statement);

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

594: AND hl.location_id = hou.location_id
595: AND fou.set_of_books_id = sob_id';
596:
597: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
598: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Creating Flat File for FVTI133R');
599: END IF;
600:
601: fv_flatfiles.create_flat_file(statement);
602: -- ---------------------------------------------------

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

650: END IF;
651: EXCEPTION
652: WHEN OTHERS THEN
653: vp_errbuf := SQLERRM;
654: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',vp_errbuf);
655: RAISE;
656: end main;
657: -- ----------------------------------------------------------------------------
658: PROCEDURE create_flat_file(v_statement VARCHAR2) IS

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

668: v_cursor := DBMS_SQL.OPEN_CURSOR;
669: EXCEPTION WHEN OTHERS THEN
670: vp_errbuf := sqlerrm;
671: vp_retcode := sqlcode;
672: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.open_v_cursor',vp_errbuf);
673: RETURN;
674: END;
675:
676: BEGIN

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

677: DBMS_SQL.PARSE(v_cursor, v_statement, DBMS_SQL.V7);
678: EXCEPTION WHEN OTHERS THEN
679: vp_retcode := sqlcode ;
680: VP_ERRBUF := sqlerrm ;
681: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.parse_v_cursor',vp_errbuf);
682: RETURN ;
683: END ;
684:
685: DBMS_SQL.DEFINE_COLUMN(v_cursor, 1, col1, 2000);

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

688: l_fetch_count := DBMS_SQL.EXECUTE(v_cursor);
689: EXCEPTION WHEN OTHERS THEN
690: vp_retcode := sqlcode ;
691: VP_ERRBUF := sqlerrm ;
692: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.execute_v_cursor',vp_errbuf);
693: RETURN ;
694: END;
695:
696: gbl_count := 0;

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

706: END LOOP;
707: EXCEPTION
708: WHEN OTHERS THEN
709: vp_errbuf := SQLERRM;
710: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',vp_errbuf);
711: RAISE;
712: end create_flat_file;
713: -- ----------------------------------------------------------------------------
714: end fv_flatfiles;