APPS.JA_CN_PS_CYB_EXPORT_PKG dependencies on FND_FILE

Line 135: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'lv_bea_cursor_sql='||lv_bea_cursor_sql);

131: lv_bea_cursor_sql := lv_bea_cursor_sql || ' AND Gp2.period_year = '''|| pv_accounting_year ||''')'; --parameter: pv_accounting_year
132: lv_bea_cursor_sql := lv_bea_cursor_sql || ' OR ('''|| pv_period_to ||''' IS NOT NULL'; --parameter: pv_period_to
133: lv_bea_cursor_sql := lv_bea_cursor_sql || ' AND Gp2.period_name = '''|| pv_period_to ||''')))'; --parameter: pv_period_to
134:
135: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'lv_bea_cursor_sql='||lv_bea_cursor_sql);
136:
137: OPEN lc_budget_exp_amount FOR lv_bea_cursor_sql;
138: FETCH lc_budget_exp_amount
139: INTO ln_budget_exp_amount;

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

157: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
158: '.Other_Exception ',
159: SQLCODE || SQLERRM);
160: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
161: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
162:
163: END Get_Budget_Expenditure_Amount;
164: --==========================================================================
165: -- PROCEDURE NAME:

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

248: 'pv_accounting_year=' || pv_accounting_year || ',' ||
249: 'pv_period_from=' || pv_period_from || ',' ||
250: 'pv_period_to=' || pv_period_to);
251: END IF; --ln_proc_level>=ln_dbg_level
252: -- FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||
253: -- '.parameters:' ||
254: -- 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
255: -- 'pn_ledger_id=' || pn_ledger_id || ',' ||
256: -- 'pv_accounting_year=' || pv_accounting_year || ',' ||

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

310: lv_pi_cursor_sql := lv_pi_cursor_sql || ' ) ';
311: lv_pi_cursor_sql := lv_pi_cursor_sql || ' order by Gp.Period_Num ';
312:
313:
314: --FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||
315: --'.lv_pi_cursor_sql:' || lv_pi_cursor_sql);
316:
317: lv_bi_cursor_sql := 'SELECT DISTINCT *'; ----fixed bug 10316565 by ChuanLing Shao as ChaoQun's great help
318: --lv_bi_cursor_sql := lv_bi_cursor_sql || ' FROM (SELECT Gp.Period_Num Accounting_Period_Num,';

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

373: lv_bi_cursor_sql := lv_bi_cursor_sql || ' Exp_Fun_Category_Code';
374: lv_bi_cursor_sql := lv_bi_cursor_sql || ' ,Exp_Eco_Category_Code';
375: lv_bi_cursor_sql := lv_bi_cursor_sql || ' ,Project_Id';
376:
377: --FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||
378: --'.lv_bi_cursor_sql:' || lv_bi_cursor_sql);
379:
380: --fixed bug 10316565 by ChuanLing Shao
381: OPEN lc_budget_period_information FOR lv_pi_cursor_sql;

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

628: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
629: '.Other_Exception ',
630: SQLCODE || SQLERRM);
631: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
632: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
633:
634: END Add_Current_Year_Budget;
635:
636: END JA_CN_PS_CYB_EXPORT_PKG;