APPS.JA_CN_ERT_EXPORT_PKG dependencies on FND_LOG

Line 53: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

49: PROCEDURE Add_Exchange_Rate_Types(pn_legal_entity_id NUMBER,
50: pn_ledger_id NUMBER,
51: pn_accounting_year NUMBER) IS
52: lv_procedure_name VARCHAR2(40) := 'Add_Exchange_Rate_Types';
53: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
54: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
55: ln_row_count NUMBER;
56: --NO_DATA EXCEPTION;
57:

Line 54: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

50: pn_ledger_id NUMBER,
51: pn_accounting_year NUMBER) IS
52: lv_procedure_name VARCHAR2(40) := 'Add_Exchange_Rate_Types';
53: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
54: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
55: ln_row_count NUMBER;
56: --NO_DATA EXCEPTION;
57:
58: -- to get Electronic Accounting Book

Line 92: FND_LOG.STRING(ln_proc_level,

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

Line 96: FND_LOG.STRING(ln_proc_level,

92: FND_LOG.STRING(ln_proc_level,
93: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
94: '.begin',
95: 'Enter procedure');
96: FND_LOG.STRING(ln_proc_level,
97: lv_procedure_name || '.parameters',
98: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
99: 'pn_ledger_id=' || pn_ledger_id || ',' ||
100: 'pn_accounting_year=' || pn_accounting_year);

Line 136: FND_LOG.STRING(ln_proc_level,

132:
133: END IF; --ln_row_count = 0
134: --logging for debug
135: IF (ln_proc_level >= ln_dbg_level) THEN
136: FND_LOG.STRING(ln_proc_level,
137: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
138: 'Exit procedure');
139: END IF; -- (ln_proc_level>=ln_dbg_level)
140: EXCEPTION

Line 142: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

138: 'Exit procedure');
139: END IF; -- (ln_proc_level>=ln_dbg_level)
140: EXCEPTION
141: WHEN OTHERS THEN
142: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
143: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
144: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
145: '.Other_Exception ',
146: SQLCODE || SQLERRM);

Line 143: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

139: END IF; -- (ln_proc_level>=ln_dbg_level)
140: EXCEPTION
141: WHEN OTHERS THEN
142: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
143: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
144: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
145: '.Other_Exception ',
146: SQLCODE || SQLERRM);
147: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

143: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
144: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
145: '.Other_Exception ',
146: SQLCODE || SQLERRM);
147: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
148: FND_FILE.put_line(FND_FILE.log,
149: lv_procedure_name || SQLCODE || SQLERRM);
150: RAISE;
151: END Add_Exchange_Rate_Types;