DBA Data[Home] [Help]

APPS.FV_FACTS1_GL_PKG dependencies on FND_FILE

Line 1603: fnd_file.put_line(fnd_file.output , 'Set of books id ' || gbl_sob_id || rpad(' ', 70) || ' Period : ' || gbl_period_name);

1599: BEGIN
1600: l_module_name := g_module_name||'INSERT_EXCEPTION_RECS';
1601: FV_UTILITY.LOG_MESG('In '||l_module_name);
1602: gbl_exception_rec_count := 0;
1603: fnd_file.put_line(fnd_file.output , 'Set of books id ' || gbl_sob_id || rpad(' ', 70) || ' Period : ' || gbl_period_name);
1604: fnd_file.put_line(fnd_file.output , ' Fact-1 Journals that do not have Vendor/Supplier information or Vendor/Customer type is NON FEDERAL ');
1605: fnd_file.put_line(fnd_file.output , '---------------------------------------- ----------------------------------------------------------');
1606: fnd_file.put_line(fnd_file.output ,rpad('Exception' , 15) || rpad('Batch Name', 41) || rpad('Category' , 16) || rpad('Account',10) || rpad('Fund ', 21) || ' Amount' );
1607: fnd_file.put_line(fnd_file.output,' ');

Line 1604: fnd_file.put_line(fnd_file.output , ' Fact-1 Journals that do not have Vendor/Supplier information or Vendor/Customer type is NON FEDERAL ');

1600: l_module_name := g_module_name||'INSERT_EXCEPTION_RECS';
1601: FV_UTILITY.LOG_MESG('In '||l_module_name);
1602: gbl_exception_rec_count := 0;
1603: fnd_file.put_line(fnd_file.output , 'Set of books id ' || gbl_sob_id || rpad(' ', 70) || ' Period : ' || gbl_period_name);
1604: fnd_file.put_line(fnd_file.output , ' Fact-1 Journals that do not have Vendor/Supplier information or Vendor/Customer type is NON FEDERAL ');
1605: fnd_file.put_line(fnd_file.output , '---------------------------------------- ----------------------------------------------------------');
1606: fnd_file.put_line(fnd_file.output ,rpad('Exception' , 15) || rpad('Batch Name', 41) || rpad('Category' , 16) || rpad('Account',10) || rpad('Fund ', 21) || ' Amount' );
1607: fnd_file.put_line(fnd_file.output,' ');
1608: l_stmt := ' select substr(rpad(l.record_category, 14,'' ''),1,14) || '' '' ||

Line 1605: fnd_file.put_line(fnd_file.output , '---------------------------------------- ----------------------------------------------------------');

1601: FV_UTILITY.LOG_MESG('In '||l_module_name);
1602: gbl_exception_rec_count := 0;
1603: fnd_file.put_line(fnd_file.output , 'Set of books id ' || gbl_sob_id || rpad(' ', 70) || ' Period : ' || gbl_period_name);
1604: fnd_file.put_line(fnd_file.output , ' Fact-1 Journals that do not have Vendor/Supplier information or Vendor/Customer type is NON FEDERAL ');
1605: fnd_file.put_line(fnd_file.output , '---------------------------------------- ----------------------------------------------------------');
1606: fnd_file.put_line(fnd_file.output ,rpad('Exception' , 15) || rpad('Batch Name', 41) || rpad('Category' , 16) || rpad('Account',10) || rpad('Fund ', 21) || ' Amount' );
1607: fnd_file.put_line(fnd_file.output,' ');
1608: l_stmt := ' select substr(rpad(l.record_category, 14,'' ''),1,14) || '' '' ||
1609: substr(rpad(b.name, 40, '' ''),1,40) || '' '' ||

Line 1606: fnd_file.put_line(fnd_file.output ,rpad('Exception' , 15) || rpad('Batch Name', 41) || rpad('Category' , 16) || rpad('Account',10) || rpad('Fund ', 21) || ' Amount' );

1602: gbl_exception_rec_count := 0;
1603: fnd_file.put_line(fnd_file.output , 'Set of books id ' || gbl_sob_id || rpad(' ', 70) || ' Period : ' || gbl_period_name);
1604: fnd_file.put_line(fnd_file.output , ' Fact-1 Journals that do not have Vendor/Supplier information or Vendor/Customer type is NON FEDERAL ');
1605: fnd_file.put_line(fnd_file.output , '---------------------------------------- ----------------------------------------------------------');
1606: fnd_file.put_line(fnd_file.output ,rpad('Exception' , 15) || rpad('Batch Name', 41) || rpad('Category' , 16) || rpad('Account',10) || rpad('Fund ', 21) || ' Amount' );
1607: fnd_file.put_line(fnd_file.output,' ');
1608: l_stmt := ' select substr(rpad(l.record_category, 14,'' ''),1,14) || '' '' ||
1609: substr(rpad(b.name, 40, '' ''),1,40) || '' '' ||
1610: substr(rpad(h.je_category, 15, '' ''),1,15) || '' '' ||

Line 1607: fnd_file.put_line(fnd_file.output,' ');

1603: fnd_file.put_line(fnd_file.output , 'Set of books id ' || gbl_sob_id || rpad(' ', 70) || ' Period : ' || gbl_period_name);
1604: fnd_file.put_line(fnd_file.output , ' Fact-1 Journals that do not have Vendor/Supplier information or Vendor/Customer type is NON FEDERAL ');
1605: fnd_file.put_line(fnd_file.output , '---------------------------------------- ----------------------------------------------------------');
1606: fnd_file.put_line(fnd_file.output ,rpad('Exception' , 15) || rpad('Batch Name', 41) || rpad('Category' , 16) || rpad('Account',10) || rpad('Fund ', 21) || ' Amount' );
1607: fnd_file.put_line(fnd_file.output,' ');
1608: l_stmt := ' select substr(rpad(l.record_category, 14,'' ''),1,14) || '' '' ||
1609: substr(rpad(b.name, 40, '' ''),1,40) || '' '' ||
1610: substr(rpad(h.je_category, 15, '' ''),1,15) || '' '' ||
1611: substr(rpad(l.account_number, 9, '' ''),1,9) || '' '' ||