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 FV_FLATFILES

Line 1: PACKAGE BODY fv_flatfiles AS

1: PACKAGE BODY fv_flatfiles AS
2: /* $Header: FVFILCRB.pls 120.13.12020000.11 2013/02/13 14:27:13 snama ship $*/
3: g_module_name VARCHAR2(100) ;
4:
5: vp_errbuf VARCHAR2(1000);

Line 44: g_module_name := 'fv.plsql.FV_FLATFILES.';

40:
41: request_id := parameter1;
42: sob_id := parameter2;
43:
44: g_module_name := 'fv.plsql.FV_FLATFILES.';
45: l_module_name := g_module_name || 'main';
46: -- -----------------------------------------------------------------------------------
47: -- Create Flat File for FV1219BF
48: -- -----------------------------------------------------------------------------------

Line 81: fv_flatfiles.create_flat_file(statement);

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);
82:
83: statement :=
84: 'SELECT ''TRL'' || LPAD(to_char(count(*)), 10, ''0'') || LPAD('' '', 403)
85: FROM fv_facts_submission ffs

Line 90: fv_flatfiles.create_flat_file(statement);

86: WHERE ffs.bulk_flag = ''Y''
87: AND ffs.Bulk_File_Sub_Id = '||request_id||
88: ' AND ffs.set_of_books_id = '||sob_id ;
89:
90: fv_flatfiles.create_flat_file(statement);
91:
92: -- -----------------------------------------------------------------------------------
93: -- Create Flat File for FVXTIVC1
94: -- -----------------------------------------------------------------------------------

Line 106: fv_flatfiles.create_flat_file(statement);

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);
107:
108: -- -----------------------------------------------------------------------------------
109: -- Create Flat File for FVTICTXR
110: -- -----------------------------------------------------------------------------------

Line 128: fv_flatfiles.create_flat_file(statement);

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
130: WHERE set_of_books_id = parameter1
131: AND org_id = parameter2
132: AND checkrun_name = parameter3 ;

Line 148: fv_flatfiles.create_flat_file(statement);

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:
150: -- -----------------------------------------------------------------------------------
151: -- Create Flat File for FVFCTDRC
152: -- -----------------------------------------------------------------------------------

Line 174: fv_flatfiles.create_flat_file(statement);

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:
176: -- Modified the foll for Facts II 2002 enhancements
177: statement :=
178: 'SELECT SUBSTR(fft.facts_report_info,1,50)

Line 202: fv_flatfiles.create_flat_file(statement);

198: AND fts.treasury_symbol_id = fft.treasury_symbol_id
199: ORDER BY fts.treasury_symbol, ffh.sgl_acct_number,
200: ffl.footnote_seq_number' ;
201:
202: fv_flatfiles.create_flat_file(statement);
203:
204: -- count the footnotes to print in the trailer record
205: SELECT LPAD(to_char(count(*)), 10, '0')
206: INTO v_footnote_count

Line 236: fv_flatfiles.create_flat_file(statement);

232: ||'||''''||v_footnote_count||''''||'
233: ||LPAD('' '', 378)
234: FROM DUAL' ;
235:
236: fv_flatfiles.create_flat_file(statement);
237: -- -----------------------------------------------------------------------------------
238: -- Create Flat File for FVTI224R
239: -- -----------------------------------------------------------------------------------
240: ELSIF conc_prog = 'FVTI224R' THEN

Line 250: fv_flatfiles.create_flat_file(statement);

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: -- -----------------------------------------------------------------------------------
252: -- Create Flat File for FVTIOBUR
253: -- -----------------------------------------------------------------------------------
254: ELSIF conc_prog = 'FVTIOBUR' THEN

Line 264: fv_flatfiles.create_flat_file(statement);

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: -- -----------------------------------------------------------------------------------
266: -- Create Flat File for FVFACTSR
267: -- -----------------------------------------------------------------------------------
268: ELSIF conc_prog = 'FVFACTSR' THEN

Line 282: -- fv_flatfiles.create_flat_file(statement);

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);
283:
284: statement :=
285: 'SELECT '||parameter1||'||
286: RPAD(dept_id, 2,'' '') ||

Line 315: fv_flatfiles.create_flat_file(statement);

311: g_ng_indicator' ;
312:
313: --fnd_file.put_line(fnd_file.log,statement );
314:
315: fv_flatfiles.create_flat_file(statement);
316:
317: statement :=
318: 'SELECT ''TRL'' ||
319: LPAD(TO_CHAR(COUNT(*)),10,''0'')||

Line 332: fv_flatfiles.create_flat_file(statement);

328: FUND_GROUP,
329: USSGL_ACCOUNT,
330: ELIMINATIONS_DEPT,
331: g_ng_indicator';
332: fv_flatfiles.create_flat_file(statement);
333:
334: -- -----------------------------------------------------------------------------------
335: -- Create Flat File for FVFC1ATB
336: -- -----------------------------------------------------------------------------------

Line 382: fv_flatfiles.create_flat_file(statement);

378: RPAD(NVL(ussgl_account,'' ''),4,'' ''),
379: NVL(RPAD(eliminations_dept,2,'' ''),'' ''),
380: NVL(g_ng_indicator,'' '')';
381:
382: fv_flatfiles.create_flat_file(statement);
383:
384:
385: /*
386: statement :=

Line 415: fv_flatfiles.create_flat_file(statement);

411: v_str := 'TRL' || LPAD(TO_CHAR(gbl_count),10,'0')|| RPAD(' ',32,' ');
412: statement := 'SELECT ''' || v_str || ''' FROM dual ';
413:
414: fnd_file.put_line (fnd_file.log, statement);
415: fv_flatfiles.create_flat_file(statement);
416:
417: -- -----------------------------------------------------------------------------------
418: --Create Flat file for GTAS Bulk File
419: -- -----------------------------------------------------------------------------------

Line 529: fv_flatfiles.create_flat_file(statement);

525: ';
526:
527: --fnd_file.put_line(fnd_file.log,statement );
528: FV_UTILITY.log_MESG(statement);
529: fv_flatfiles.create_flat_file(statement);
530: -- -----------------------------------------------------------------------------------
531: -- Create Flat File for FVTI133R
532: -- -----------------------------------------------------------------------------------
533: ELSIF conc_prog = 'FVTI133R' THEN

Line 543: fv_flatfiles.create_flat_file(statement);

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: -- -----------------------------------------------------------------------------------
545: -- Create Flat File for FVTI133R
546: -- -----------------------------------------------------------------------------------
547: ELSIF conc_prog = 'FVTI133R' THEN

Line 601: fv_flatfiles.create_flat_file(statement);

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: -- ---------------------------------------------------
603: -- Create Debtor 'B' Record
604: -- ---------------------------------------------------
605: statement :=

Line 614: fv_flatfiles.create_flat_file(statement);

610: WHERE amount >= invoice_minimum
611: AND reportable_flag = ''Y''
612: AND set_of_books_id = sob_id';
613:
614: fv_flatfiles.create_flat_file(statement);
615: -- ---------------------------------------------------
616: -- Create Debtor 'C' Record
617: -- ---------------------------------------------------
618: statement :=

Line 637: fv_flatfiles.create_flat_file(statement);

633: WHERE amount > invoice_minimum
634: AND reportable_flag = ''Y''
635: AND set_of_books_id = sob_id';
636:
637: fv_flatfiles.create_flat_file(statement);
638: -- ---------------------------------------------------
639: -- Create Debtor 'F' Record
640: -- ---------------------------------------------------
641: statement :=

Line 648: fv_flatfiles.create_flat_file(statement);

644: ||''0000000000000000000000000''
645: ||lpad('' '',390)
646: FROM dual';
647:
648: fv_flatfiles.create_flat_file(statement);
649: -- -----------------------------------------------------------------------------------
650: END IF;
651: EXCEPTION
652: WHEN OTHERS THEN

Line 714: end fv_flatfiles;

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;