APPS.JA_CN_PS_BI_EXPORT_PKG dependencies on FND_FILE

Line 168: --FND_FILE.put_line(FND_FILE.log, 'Get_Budget_Income_Amount' ||

164: lv_sql_text := lv_sql_text || ' AND Gp2.period_name = ''' || lv_period_to || ''''; --variable: lv_period_to
165: END IF;
166: lv_sql_text := lv_sql_text || ' )';
167:
168: --FND_FILE.put_line(FND_FILE.log, 'Get_Budget_Income_Amount' ||
169: -- '.lv_sql_text:' || lv_sql_text);
170:
171: EXECUTE IMMEDIATE lv_sql_text INTO ln_amount;
172:

Line 192: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);

188: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
189: '.Other_Exception ',
190: SQLCODE || SQLERRM);
191: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
192: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
193:
194: END Get_Budget_Income_Amount;
195:
196: --==========================================================================

Line 317: --FND_FILE.put_line(FND_FILE.log, 'Get_Actual_Income_Amount' ||

313: lv_sql_text := lv_sql_text || ' AND Gle.accounted_period_type = Gp2.period_type';
314: lv_sql_text := lv_sql_text || ' AND Gp2.period_name = ''' || lv_period_to || ''''; --variable: lv_period_to
315: lv_sql_text := lv_sql_text || ' )';
316:
317: --FND_FILE.put_line(FND_FILE.log, 'Get_Actual_Income_Amount' ||
318: -- '.lv_sql_text:' || lv_sql_text);
319:
320: EXECUTE IMMEDIATE lv_sql_text INTO ln_amount;
321:

Line 341: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);

337: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
338: '.Other_Exception ',
339: SQLCODE || SQLERRM);
340: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
341: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
342:
343: END Get_Actual_Income_Amount;
344:
345: --==========================================================================

Line 418: -- FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

414: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
415: 'pn_ledger_id=' || pn_ledger_id || ',' ||
416: 'pv_accounting_year=' || pv_accounting_year);
417: END IF; --ln_proc_level>=ln_dbg_level
418: -- FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||
419: -- '.parameters:' ||
420: -- 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
421: -- 'pn_ledger_id=' || pn_ledger_id || ',' ||
422: -- 'pv_accounting_year=' || pv_accounting_year);

Line 543: --FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

539: lv_bi_cursor_sql := lv_bi_cursor_sql || ' ORDER BY Accounting_Period_Num';
540: lv_bi_cursor_sql := lv_bi_cursor_sql || ' ,Income_Category_Code';
541: lv_bi_cursor_sql := lv_bi_cursor_sql || ' ,Income_Project_Code';
542: */
543: --FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||
544: --'.lv_bi_cursor_sql:' || lv_bi_cursor_sql);
545:
546: --fixed bug 10316565 by ChuanLing Shao
547:

Line 713: -- FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

709: FND_LOG.STRING(ln_statement_level,
710: lv_procedure_name,
711: 'ln_rec_count:' || ln_rec_count);
712: END IF; --(ln_statement_level >= ln_dbg_level)
713: -- FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||
714: -- '.variable:' ||
715: -- 'ln_rec_count=' || ln_rec_count);
716:
717: -- There is no data found for employee record

Line 811: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);

807: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
808: '.Other_Exception ',
809: SQLCODE || SQLERRM);
810: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
811: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
812: --RAISE;
813:
814: END Add_Budget_Income;
815: