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.JA_CN_PS_BE_EXPORT_PKG dependencies on FND_LOG

Line 84: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

80: ,lv_period_to IN VARCHAR2
81: ) RETURN NUMBER IS
82: /* define variables */
83: lv_procedure_name VARCHAR2(40) := 'Get_Budget_Expenditure_Amount';
84: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
85: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
86: --ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
87: --lv_error_msg VARCHAR2(2000) := NULL;
88:

Line 85: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

81: ) RETURN NUMBER IS
82: /* define variables */
83: lv_procedure_name VARCHAR2(40) := 'Get_Budget_Expenditure_Amount';
84: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
85: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
86: --ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
87: --lv_error_msg VARCHAR2(2000) := NULL;
88:
89: ln_amount NUMBER;

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

82: /* define variables */
83: lv_procedure_name VARCHAR2(40) := 'Get_Budget_Expenditure_Amount';
84: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
85: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
86: --ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
87: --lv_error_msg VARCHAR2(2000) := NULL;
88:
89: ln_amount NUMBER;
90: lv_sql_text VARCHAR2(2000);

Line 96: FND_LOG.STRING(ln_proc_level,

92: BEGIN
93: --logging for debug
94: IF (ln_proc_level >= ln_dbg_level)
95: THEN
96: FND_LOG.STRING(ln_proc_level,
97: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
98: '.begin',
99: 'Enter procedure');
100: -- logging the parameters

Line 101: FND_LOG.STRING(ln_proc_level,

97: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
98: '.begin',
99: 'Enter procedure');
100: -- logging the parameters
101: FND_LOG.STRING(ln_proc_level,
102: lv_procedure_name ||
103: '.parameters',
104: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
105: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 199: FND_LOG.STRING(ln_proc_level,

195:
196: --logging for debug
197: IF (ln_proc_level >= ln_dbg_level)
198: THEN
199: FND_LOG.STRING(ln_proc_level,
200: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
201: 'Exit procedure');
202: END IF; -- (ln_proc_level>=ln_dbg_level)
203:

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

204: RETURN ln_amount;
205:
206: EXCEPTION
207: WHEN OTHERS THEN
208: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
209: THEN
210: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
211: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
212: '.Other_Exception ',

Line 210: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

206: EXCEPTION
207: WHEN OTHERS THEN
208: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
209: THEN
210: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
211: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
212: '.Other_Exception ',
213: SQLCODE || SQLERRM);
214: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

210: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
211: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
212: '.Other_Exception ',
213: SQLCODE || SQLERRM);
214: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
215: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
216:
217: END Get_Budget_Expenditure_Amount;
218:

Line 269: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

265: ,lv_period_to IN VARCHAR2
266: ) RETURN NUMBER IS
267: /* define variables */
268: lv_procedure_name VARCHAR2(40) := 'Get_Actual_Expenditure_Amount';
269: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
270: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
271: --ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
272: --lv_error_msg VARCHAR2(2000) := NULL;
273:

Line 270: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

266: ) RETURN NUMBER IS
267: /* define variables */
268: lv_procedure_name VARCHAR2(40) := 'Get_Actual_Expenditure_Amount';
269: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
270: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
271: --ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
272: --lv_error_msg VARCHAR2(2000) := NULL;
273:
274: ln_amount NUMBER;

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

267: /* define variables */
268: lv_procedure_name VARCHAR2(40) := 'Get_Actual_Expenditure_Amount';
269: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
270: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
271: --ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
272: --lv_error_msg VARCHAR2(2000) := NULL;
273:
274: ln_amount NUMBER;
275: lv_sql_text VARCHAR2(2000);

Line 281: FND_LOG.STRING(ln_proc_level,

277: BEGIN
278: --logging for debug
279: IF (ln_proc_level >= ln_dbg_level)
280: THEN
281: FND_LOG.STRING(ln_proc_level,
282: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
283: '.begin',
284: 'Enter procedure');
285: -- logging the parameters

Line 286: FND_LOG.STRING(ln_proc_level,

282: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
283: '.begin',
284: 'Enter procedure');
285: -- logging the parameters
286: FND_LOG.STRING(ln_proc_level,
287: lv_procedure_name ||
288: '.parameters',
289: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
290: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 370: FND_LOG.STRING(ln_proc_level,

366:
367: --logging for debug
368: IF (ln_proc_level >= ln_dbg_level)
369: THEN
370: FND_LOG.STRING(ln_proc_level,
371: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
372: 'Exit procedure');
373: END IF; -- (ln_proc_level>=ln_dbg_level)
374:

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

375: RETURN ln_amount;
376:
377: EXCEPTION
378: WHEN OTHERS THEN
379: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
380: THEN
381: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
382: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
383: '.Other_Exception ',

Line 381: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

377: EXCEPTION
378: WHEN OTHERS THEN
379: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
380: THEN
381: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
382: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
383: '.Other_Exception ',
384: SQLCODE || SQLERRM);
385: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

381: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
382: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
383: '.Other_Exception ',
384: SQLCODE || SQLERRM);
385: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
386: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
387:
388: END Get_Actual_Expenditure_Amount;
389:

Line 426: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

422: ,pv_period_to IN VARCHAR2 -- Period To
423: ) IS
424:
425: lv_procedure_name VARCHAR2(40) := 'Add_Budget_Expenditure';
426: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
427: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
428: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
429: --lv_error_msg VARCHAR2(2000) := NULL;
430: ln_rec_count NUMBER := 0;

Line 427: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

423: ) IS
424:
425: lv_procedure_name VARCHAR2(40) := 'Add_Budget_Expenditure';
426: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
427: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
428: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
429: --lv_error_msg VARCHAR2(2000) := NULL;
430: ln_rec_count NUMBER := 0;
431:

Line 428: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

424:
425: lv_procedure_name VARCHAR2(40) := 'Add_Budget_Expenditure';
426: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
427: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
428: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
429: --lv_error_msg VARCHAR2(2000) := NULL;
430: ln_rec_count NUMBER := 0;
431:
432: ln_last_year_balance_amount NUMBER := 0; -- added to fix bug#: 10111527

Line 459: FND_LOG.STRING(ln_proc_level,

455: BEGIN
456: --logging for debug
457: IF (ln_proc_level >= ln_dbg_level)
458: THEN
459: FND_LOG.STRING(ln_proc_level,
460: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
461: '.begin',
462: 'Enter procedure');
463: -- logging the parameters

Line 464: FND_LOG.STRING(ln_proc_level,

460: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
461: '.begin',
462: 'Enter procedure');
463: -- logging the parameters
464: FND_LOG.STRING(ln_proc_level,
465: lv_procedure_name ||
466: '.parameters',
467: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
468: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 858: FND_LOG.STRING(ln_statement_level,

854:
855: --logging the variables
856: IF (ln_statement_level >= ln_dbg_level)
857: THEN
858: FND_LOG.STRING(ln_statement_level,
859: lv_procedure_name,
860: 'ln_rec_count:' || ln_rec_count);
861: END IF; --(ln_statement_level >= ln_dbg_level)
862: -- FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

Line 992: FND_LOG.STRING(ln_proc_level,

988:
989: --logging for debug
990: IF (ln_proc_level >= ln_dbg_level)
991: THEN
992: FND_LOG.STRING(ln_proc_level,
993: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
994: 'Exit procedure');
995: END IF; -- (ln_proc_level>=ln_dbg_level)
996:

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

995: END IF; -- (ln_proc_level>=ln_dbg_level)
996:
997: EXCEPTION
998: WHEN OTHERS THEN
999: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1000: THEN
1001: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1002: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1003: '.Other_Exception ',

Line 1001: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

997: EXCEPTION
998: WHEN OTHERS THEN
999: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1000: THEN
1001: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1002: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1003: '.Other_Exception ',
1004: SQLCODE || SQLERRM);
1005: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

1001: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1002: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1003: '.Other_Exception ',
1004: SQLCODE || SQLERRM);
1005: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1006: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
1007: --RAISE;
1008:
1009: END Add_Budget_Expenditure;