APPS.JA_CN_CUR_EXPORT_PKG dependencies on FND_LOG

Line 53: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 91: FND_LOG.STRING(ln_proc_level,

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

Line 95: FND_LOG.STRING(ln_proc_level,

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

Line 130: FND_LOG.STRING(ln_proc_level,

126: Ja_Cn_Utility.GV_TAG_TYPE_END);
127: END IF; --ln_row_count = 0
128: --logging for debug
129: IF (ln_proc_level >= ln_dbg_level) THEN
130: FND_LOG.STRING(ln_proc_level,
131: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
132: 'Exit procedure');
133: END IF; -- (ln_proc_level>=ln_dbg_level)
134: EXCEPTION

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

132: 'Exit procedure');
133: END IF; -- (ln_proc_level>=ln_dbg_level)
134: EXCEPTION
135: WHEN OTHERS THEN
136: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
137: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
138: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
139: '.Other_Exception ',
140: SQLCODE || SQLERRM);

Line 137: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

133: END IF; -- (ln_proc_level>=ln_dbg_level)
134: EXCEPTION
135: WHEN OTHERS THEN
136: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
137: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
138: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
139: '.Other_Exception ',
140: SQLCODE || SQLERRM);
141: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

137: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
138: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
139: '.Other_Exception ',
140: SQLCODE || SQLERRM);
141: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
142: FND_FILE.put_line(FND_FILE.log,
143: lv_procedure_name || SQLCODE || SQLERRM);
144: RAISE;
145: END Add_Currencies;