APPS.JA_CN_PS_SI_BAI_EXPORT_PKG dependencies on FND_LOG

Line 55: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

51: , pn_accounting_year IN NUMBER
52: )
53: IS
54: lv_procedure_name VARCHAR2(40) := 'Add_Bank_Account_Information';
55: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
56: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
57: ln_row_count NUMBER := 0;
58:
59: --To get bank account information

Line 56: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

52: )
53: IS
54: lv_procedure_name VARCHAR2(40) := 'Add_Bank_Account_Information';
55: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
56: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
57: ln_row_count NUMBER := 0;
58:
59: --To get bank account information
60: CURSOR bank_account_cur

Line 120: FND_LOG.STRING( ln_proc_level

116: BEGIN
117: --logging for debug
118: IF (ln_proc_level >= ln_dbg_level)
119: THEN
120: FND_LOG.STRING( ln_proc_level
121: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.begin'
122: , 'Enter procedure');
123: --logging the parameters
124: FND_LOG.STRING( ln_proc_level

Line 124: FND_LOG.STRING( ln_proc_level

120: FND_LOG.STRING( ln_proc_level
121: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.begin'
122: , 'Enter procedure');
123: --logging the parameters
124: FND_LOG.STRING( ln_proc_level
125: , GV_MODULE_PREFIX|| '.' || lv_procedure_name
126: || '.parameters'
127: , 'pn_legal_entity_id=' || pn_legal_entity_id|| ','
128: || 'pv_accounting_year=' || pn_accounting_year);

Line 187: FND_LOG.STRING( ln_proc_level

183: END IF; -- (ln_row_count = 0)
184: --logging for debug
185: IF (ln_proc_level >= ln_dbg_level)
186: THEN
187: FND_LOG.STRING( ln_proc_level
188: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end'
189: , 'Exit procedure');
190: END IF; -- (ln_proc_level>=ln_dbg_level)
191: EXCEPTION

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

189: , 'Exit procedure');
190: END IF; -- (ln_proc_level>=ln_dbg_level)
191: EXCEPTION
192: WHEN OTHERS THEN
193: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
194: THEN
195: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
196: , GV_MODULE_PREFIX || '.' || lv_procedure_name ||
197: ' .Other_Exception '

Line 195: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

191: EXCEPTION
192: WHEN OTHERS THEN
193: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
194: THEN
195: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
196: , GV_MODULE_PREFIX || '.' || lv_procedure_name ||
197: ' .Other_Exception '
198: , SQLCODE || SQLERRM);
199: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

195: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
196: , GV_MODULE_PREFIX || '.' || lv_procedure_name ||
197: ' .Other_Exception '
198: , SQLCODE || SQLERRM);
199: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
200: FND_FILE.PUT_LINE( FND_FILE.log
201: , GV_MODULE_PREFIX || '.' || lv_procedure_name
202: || SQLCODE || SQLERRM );
203: RAISE;