APPS.JA_CN_FA_AU_EXPORT_PKG dependencies on FND_LOG

Line 52: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

48: , pv_period_from IN VARCHAR2
49: , pv_period_to IN VARCHAR2
50: , pn_coa_id NUMBER
51: )IS
52: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
53: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
54: lv_procedure_name VARCHAR2(40) := 'Add_FA_Usage';
55: lv_segment VARCHAR2(30);
56: lv_usage_status_code VARCHAR2(150);

Line 53: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

49: , pv_period_to IN VARCHAR2
50: , pn_coa_id NUMBER
51: )IS
52: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
53: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
54: lv_procedure_name VARCHAR2(40) := 'Add_FA_Usage';
55: lv_segment VARCHAR2(30);
56: lv_usage_status_code VARCHAR2(150);
57: lv_usage_name VARCHAR2(240);

Line 82: FND_LOG.STRING( ln_proc_level

78: BEGIN
79: --logging for debug
80: IF (ln_proc_level>=ln_dbg_level)
81: THEN
82: FND_LOG.STRING( ln_proc_level
83: , GV_MODULE_PREFIX ||'.' || lv_procedure_name ||
84: '.begin'
85: , 'Enter procedure'
86: );

Line 89: FND_LOG.STRING(ln_proc_level,

85: , 'Enter procedure'
86: );
87:
88: -- logging the parameters
89: FND_LOG.STRING(ln_proc_level,
90: lv_procedure_name ||
91: '.parameters',
92: 'pn_legal_entity_id=' || pn_legal_entity_id|| ',' ||
93: 'pn_ledger_id=' || pn_ledger_id || ',' ||

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

145: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
146: );
147: EXCEPTION
148: WHEN OTHERS THEN
149: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
150: THEN
151: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
152: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
153: '.Other_Exception ',

Line 151: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

147: EXCEPTION
148: WHEN OTHERS THEN
149: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
150: THEN
151: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
152: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
153: '.Other_Exception ',
154: SQLCODE || SQLERRM);
155: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

151: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
152: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
153: '.Other_Exception ',
154: SQLCODE || SQLERRM);
155: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
156: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
157: END;
158: END LOOP;
159: CLOSE asset_detail_cur;

Line 191: FND_LOG.STRING( ln_proc_level

187: END IF; --(ln_row_count = 0)
188: --logging for debug
189: IF (ln_proc_level>=ln_dbg_level)
190: THEN
191: FND_LOG.STRING( ln_proc_level
192: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
193: , 'Exit procedure'
194: );
195: END IF; -- (ln_proc_level>=ln_dbg_level)

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

195: END IF; -- (ln_proc_level>=ln_dbg_level)
196:
197: EXCEPTION
198: WHEN OTHERS THEN
199: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
200: THEN
201: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
202: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
203: '.Other_Exception ',

Line 201: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

197: EXCEPTION
198: WHEN OTHERS THEN
199: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
200: THEN
201: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
202: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
203: '.Other_Exception ',
204: SQLCODE || SQLERRM);
205: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

201: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
202: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
203: '.Other_Exception ',
204: SQLCODE || SQLERRM);
205: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
206: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
207:
208: END Add_FA_Usage;
209: END JA_CN_FA_AU_EXPORT_PKG;