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.12.12010000.1 2008/07/28 06:31:04 appldev ship $*/
3: g_module_name VARCHAR2(100) ;
4:
5: vp_errbuf VARCHAR2(1000);

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

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

Line 80: fv_flatfiles.create_flat_file(statement);

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

Line 89: fv_flatfiles.create_flat_file(statement);

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

Line 105: fv_flatfiles.create_flat_file(statement);

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

Line 127: fv_flatfiles.create_flat_file(statement);

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

Line 147: fv_flatfiles.create_flat_file(statement);

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

Line 173: fv_flatfiles.create_flat_file(statement);

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

Line 201: fv_flatfiles.create_flat_file(statement);

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

Line 235: fv_flatfiles.create_flat_file(statement);

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

Line 249: fv_flatfiles.create_flat_file(statement);

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

Line 263: fv_flatfiles.create_flat_file(statement);

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

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

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

Line 314: fv_flatfiles.create_flat_file(statement);

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

Line 331: fv_flatfiles.create_flat_file(statement);

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

Line 381: fv_flatfiles.create_flat_file(statement);

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

Line 414: fv_flatfiles.create_flat_file(statement);

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

Line 430: fv_flatfiles.create_flat_file(statement);

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: -- -----------------------------------------------------------------------------------
432: -- Create Flat File for FVTI133R
433: -- -----------------------------------------------------------------------------------
434: ELSIF conc_prog = 'FVTI133R' THEN

Line 488: fv_flatfiles.create_flat_file(statement);

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: -- ---------------------------------------------------
490: -- Create Debtor 'B' Record
491: -- ---------------------------------------------------
492: statement :=

Line 501: fv_flatfiles.create_flat_file(statement);

497: WHERE amount >= invoice_minimum
498: AND reportable_flag = ''Y''
499: AND set_of_books_id = sob_id';
500:
501: fv_flatfiles.create_flat_file(statement);
502: -- ---------------------------------------------------
503: -- Create Debtor 'C' Record
504: -- ---------------------------------------------------
505: statement :=

Line 524: fv_flatfiles.create_flat_file(statement);

520: WHERE amount > invoice_minimum
521: AND reportable_flag = ''Y''
522: AND set_of_books_id = sob_id';
523:
524: fv_flatfiles.create_flat_file(statement);
525: -- ---------------------------------------------------
526: -- Create Debtor 'F' Record
527: -- ---------------------------------------------------
528: statement :=

Line 535: fv_flatfiles.create_flat_file(statement);

531: ||''0000000000000000000000000''
532: ||lpad('' '',390)
533: FROM dual';
534:
535: fv_flatfiles.create_flat_file(statement);
536: -- -----------------------------------------------------------------------------------
537: END IF;
538: EXCEPTION
539: WHEN OTHERS THEN

Line 601: end fv_flatfiles;

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;