APPS.JA_CN_JC_EXPORT_PKG dependencies on FND_LOG

Line 53: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

49: PROCEDURE Add_Journal_Categories(pn_legal_entity_id NUMBER,
50: pn_ledger_id NUMBER,
51: pn_accounting_year NUMBER) IS
52: lv_procedure_name VARCHAR2(40) := 'Add_Journal_Categories';
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_Journal_Categories';
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 journal categories

Line 93: FND_LOG.STRING(ln_proc_level,

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

Line 97: FND_LOG.STRING(ln_proc_level,

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

Line 138: FND_LOG.STRING(ln_proc_level,

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

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

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

Line 145: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

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

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

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