APPS.JA_CN_PS_SI_EAB_EXPORT_PKG dependencies on FND_LOG

Line 51: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

47: , pn_accounting_year IN NUMBER
48: )
49: IS
50: lv_procedure_name VARCHAR2(40) := 'Add_Electronic_Accounting_Book';
51: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
52: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
53: ln_row_count NUMBER := 0;
54:
55: --To get Electronic Accounting Book

Line 52: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

48: )
49: IS
50: lv_procedure_name VARCHAR2(40) := 'Add_Electronic_Accounting_Book';
51: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
52: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
53: ln_row_count NUMBER := 0;
54:
55: --To get Electronic Accounting Book
56: CURSOR electronic_accounting_book_cur

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 || '.begin'
91: , 'Enter procedure');
92: FND_LOG.STRING( ln_proc_level
93: , GV_MODULE_PREFIX || '.' || lv_procedure_name

Line 92: FND_LOG.STRING( ln_proc_level

88: THEN
89: FND_LOG.STRING( ln_proc_level
90: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.begin'
91: , 'Enter procedure');
92: FND_LOG.STRING( ln_proc_level
93: , GV_MODULE_PREFIX || '.' || lv_procedure_name
94: || '.parameters'
95: , 'pn_ledger_id=' || pn_ledger_id || ','
96: || 'pn_legal_entity_id=' || pn_legal_entity_id || ','

Line 217: FND_LOG.STRING( ln_proc_level

213: END IF; --(ln_row_count = 0)
214: --logging for debug
215: IF (ln_proc_level >= ln_dbg_level)
216: THEN
217: FND_LOG.STRING( ln_proc_level
218: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end'
219: , 'Exit procedure');
220: END IF; -- (ln_proc_level>=ln_dbg_level)
221: EXCEPTION

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

219: , 'Exit procedure');
220: END IF; -- (ln_proc_level>=ln_dbg_level)
221: EXCEPTION
222: WHEN OTHERS THEN
223: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
224: THEN
225: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
226: , GV_MODULE_PREFIX || '.' || lv_procedure_name ||
227: '.Other_Exception '

Line 225: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

221: EXCEPTION
222: WHEN OTHERS THEN
223: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
224: THEN
225: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
226: , GV_MODULE_PREFIX || '.' || lv_procedure_name ||
227: '.Other_Exception '
228: , SQLCODE || SQLERRM);
229: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

225: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
226: , GV_MODULE_PREFIX || '.' || lv_procedure_name ||
227: '.Other_Exception '
228: , SQLCODE || SQLERRM);
229: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
230: FND_FILE.PUT_LINE( FND_FILE.LOG
231: , GV_MODULE_PREFIX || '.' || lv_procedure_name || ','
232: || SQLCODE || SQLERRM );
233: RAISE;