APPS.JA_CN_GL_EAB_EXPORT_PKG dependencies on FND_LOG

Line 47: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

43: PROCEDURE Add_Electronic_Accounting_Book(pn_legal_entity_id NUMBER
44: ,pn_ledger_id NUMBER
45: ,pn_accounting_year NUMBER) IS
46: lv_procedure_name VARCHAR2(40) := 'Add_Electronic_Accounting_Book';
47: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
48: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
49: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
50: ln_row_count NUMBER;
51: NO_DATA EXCEPTION;

Line 48: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

44: ,pn_ledger_id NUMBER
45: ,pn_accounting_year NUMBER) IS
46: lv_procedure_name VARCHAR2(40) := 'Add_Electronic_Accounting_Book';
47: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
48: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
49: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
50: ln_row_count NUMBER;
51: NO_DATA EXCEPTION;
52:

Line 49: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

45: ,pn_accounting_year NUMBER) IS
46: lv_procedure_name VARCHAR2(40) := 'Add_Electronic_Accounting_Book';
47: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
48: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
49: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
50: ln_row_count NUMBER;
51: NO_DATA EXCEPTION;
52:
53: -- to get Electronic Accounting Book

Line 79: FND_LOG.STRING(ln_proc_level,

75: --logging for debug
76: FND_FILE.PUT_LINE(FND_FILE.log, lv_procedure_name);
77: IF (ln_proc_level >= ln_dbg_level)
78: THEN
79: FND_LOG.STRING(ln_proc_level,
80: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
81: '.begin',
82: 'Enter procedure');
83: FND_LOG.STRING(ln_proc_level,

Line 83: FND_LOG.STRING(ln_proc_level,

79: FND_LOG.STRING(ln_proc_level,
80: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
81: '.begin',
82: 'Enter procedure');
83: FND_LOG.STRING(ln_proc_level,
84: lv_procedure_name ||
85: '.parameters',
86: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
87: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 168: FND_LOG.STRING(ln_proc_level,

164: END IF; --ln_row_count = 0
165:
166: --logging for debug
167: IF (ln_proc_level >= ln_dbg_level) THEN
168: FND_LOG.STRING(ln_proc_level,
169: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
170: 'Exit procedure');
171: END IF; -- (ln_proc_level>=ln_dbg_level)
172: EXCEPTION

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

170: 'Exit procedure');
171: END IF; -- (ln_proc_level>=ln_dbg_level)
172: EXCEPTION
173: WHEN OTHERS THEN
174: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
175: THEN
176: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
177: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
178: '.Other_Exception ',

Line 176: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

172: EXCEPTION
173: WHEN OTHERS THEN
174: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
175: THEN
176: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
177: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
178: '.Other_Exception ',
179: SQLCODE || SQLERRM);
180: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

176: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
177: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
178: '.Other_Exception ',
179: SQLCODE || SQLERRM);
180: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
181: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
182: RAISE;
183: END Add_Electronic_Accounting_Book;
184: