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.

[Home] [Help]

APPS.JA_CN_PS_BI_EXPORT_PKG dependencies on FND_LOG

Line 77: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

73: ,lv_period_to IN VARCHAR2
74: ) RETURN NUMBER IS
75: /* define variables */
76: lv_procedure_name VARCHAR2(40) := 'Get_Budget_Income_Amount';
77: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
78: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
79: --ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
80: --lv_error_msg VARCHAR2(2000) := NULL;
81:

Line 78: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

74: ) RETURN NUMBER IS
75: /* define variables */
76: lv_procedure_name VARCHAR2(40) := 'Get_Budget_Income_Amount';
77: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
78: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
79: --ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
80: --lv_error_msg VARCHAR2(2000) := NULL;
81:
82: ln_amount NUMBER;

Line 79: --ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

75: /* define variables */
76: lv_procedure_name VARCHAR2(40) := 'Get_Budget_Income_Amount';
77: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
78: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
79: --ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
80: --lv_error_msg VARCHAR2(2000) := NULL;
81:
82: ln_amount NUMBER;
83: lv_sql_text VARCHAR2(2000);

Line 89: FND_LOG.STRING(ln_proc_level,

85: BEGIN
86: --logging for debug
87: IF (ln_proc_level >= ln_dbg_level)
88: THEN
89: FND_LOG.STRING(ln_proc_level,
90: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
91: '.begin',
92: 'Enter procedure');
93: -- logging the parameters

Line 94: FND_LOG.STRING(ln_proc_level,

90: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
91: '.begin',
92: 'Enter procedure');
93: -- logging the parameters
94: FND_LOG.STRING(ln_proc_level,
95: lv_procedure_name ||
96: '.parameters',
97: 'pn_ledger_id=' || pn_ledger_id || ',' ||
98: 'lv_income_cat_seg_col =' || lv_income_cat_seg_col || ',' ||

Line 176: FND_LOG.STRING(ln_proc_level,

172:
173: --logging for debug
174: IF (ln_proc_level >= ln_dbg_level)
175: THEN
176: FND_LOG.STRING(ln_proc_level,
177: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
178: 'Exit procedure');
179: END IF; -- (ln_proc_level>=ln_dbg_level)
180:

Line 185: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

181: RETURN ln_amount;
182:
183: EXCEPTION
184: WHEN OTHERS THEN
185: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
186: THEN
187: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
188: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
189: '.Other_Exception ',

Line 187: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

183: EXCEPTION
184: WHEN OTHERS THEN
185: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
186: THEN
187: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
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)

Line 191: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

187: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
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:

Line 238: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

234: ,lv_period_to IN VARCHAR2
235: ) RETURN NUMBER IS
236: /* define variables */
237: lv_procedure_name VARCHAR2(40) := 'Get_Actual_Income_Amount';
238: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
239: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
240: --ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
241: --lv_error_msg VARCHAR2(2000) := NULL;
242:

Line 239: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

235: ) RETURN NUMBER IS
236: /* define variables */
237: lv_procedure_name VARCHAR2(40) := 'Get_Actual_Income_Amount';
238: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
239: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
240: --ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
241: --lv_error_msg VARCHAR2(2000) := NULL;
242:
243: ln_amount NUMBER;

Line 240: --ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

236: /* define variables */
237: lv_procedure_name VARCHAR2(40) := 'Get_Actual_Income_Amount';
238: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
239: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
240: --ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
241: --lv_error_msg VARCHAR2(2000) := NULL;
242:
243: ln_amount NUMBER;
244: lv_sql_text VARCHAR2(2000);

Line 250: FND_LOG.STRING(ln_proc_level,

246: BEGIN
247: --logging for debug
248: IF (ln_proc_level >= ln_dbg_level)
249: THEN
250: FND_LOG.STRING(ln_proc_level,
251: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
252: '.begin',
253: 'Enter procedure');
254: -- logging the parameters

Line 255: FND_LOG.STRING(ln_proc_level,

251: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
252: '.begin',
253: 'Enter procedure');
254: -- logging the parameters
255: FND_LOG.STRING(ln_proc_level,
256: lv_procedure_name ||
257: '.parameters',
258: 'pn_ledger_id=' || pn_ledger_id || ',' ||
259: 'lv_income_cat_seg_col =' || lv_income_cat_seg_col || ',' ||

Line 325: FND_LOG.STRING(ln_proc_level,

321:
322: --logging for debug
323: IF (ln_proc_level >= ln_dbg_level)
324: THEN
325: FND_LOG.STRING(ln_proc_level,
326: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
327: 'Exit procedure');
328: END IF; -- (ln_proc_level>=ln_dbg_level)
329:

Line 334: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

330: RETURN ln_amount;
331:
332: EXCEPTION
333: WHEN OTHERS THEN
334: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
335: THEN
336: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
337: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
338: '.Other_Exception ',

Line 336: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

332: EXCEPTION
333: WHEN OTHERS THEN
334: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
335: THEN
336: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
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)

Line 340: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

336: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
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:

Line 381: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

377: ,pv_period_to IN VARCHAR2 -- Period To
378: ) IS
379:
380: lv_procedure_name VARCHAR2(40) := 'Add_Budget_Income';
381: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
382: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
383: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
384: --lv_error_msg VARCHAR2(2000) := NULL;
385: ln_rec_count NUMBER := 0;

Line 382: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

378: ) IS
379:
380: lv_procedure_name VARCHAR2(40) := 'Add_Budget_Income';
381: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
382: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
383: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
384: --lv_error_msg VARCHAR2(2000) := NULL;
385: ln_rec_count NUMBER := 0;
386:

Line 383: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

379:
380: lv_procedure_name VARCHAR2(40) := 'Add_Budget_Income';
381: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
382: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
383: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
384: --lv_error_msg VARCHAR2(2000) := NULL;
385: ln_rec_count NUMBER := 0;
386:
387: lv_accounting_period_num NUMBER; -- Accounting_Period_Num,

Line 406: FND_LOG.STRING(ln_proc_level,

402: BEGIN
403: --logging for debug
404: IF (ln_proc_level >= ln_dbg_level)
405: THEN
406: FND_LOG.STRING(ln_proc_level,
407: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
408: '.begin',
409: 'Enter procedure');
410: -- logging the parameters

Line 411: FND_LOG.STRING(ln_proc_level,

407: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
408: '.begin',
409: 'Enter procedure');
410: -- logging the parameters
411: FND_LOG.STRING(ln_proc_level,
412: lv_procedure_name ||
413: '.parameters',
414: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
415: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 709: FND_LOG.STRING(ln_statement_level,

705:
706: --logging the variables
707: IF (ln_statement_level >= ln_dbg_level)
708: THEN
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 ||

Line 797: FND_LOG.STRING(ln_proc_level,

793:
794: --logging for debug
795: IF (ln_proc_level >= ln_dbg_level)
796: THEN
797: FND_LOG.STRING(ln_proc_level,
798: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
799: 'Exit procedure');
800: END IF; -- (ln_proc_level>=ln_dbg_level)
801:

Line 804: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

800: END IF; -- (ln_proc_level>=ln_dbg_level)
801:
802: EXCEPTION
803: WHEN OTHERS THEN
804: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
805: THEN
806: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
807: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
808: '.Other_Exception ',

Line 806: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

802: EXCEPTION
803: WHEN OTHERS THEN
804: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
805: THEN
806: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
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)

Line 810: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

806: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
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;