DBA Data[Home] [Help]

APPS.JA_CN_GL_EXPORT_PKG dependencies on FND_LOG

Line 78: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

74: ln_legal_entity_id NUMBER(15);
75: lv_xml_directory VARCHAR2(500);
76: ln_request_id NUMBER(15);
77: lv_procedure_name VARCHAR2(40) := 'Export_GL';
78: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
79: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
80: ln_ledger_le_rls NUMBER := NULL;
81: lv_false_flag VARCHAR(1) := 'Y';
82: lv_error_msg VARCHAR2(2000) := NULL;

Line 79: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

75: lv_xml_directory VARCHAR2(500);
76: ln_request_id NUMBER(15);
77: lv_procedure_name VARCHAR2(40) := 'Export_GL';
78: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
79: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
80: ln_ledger_le_rls NUMBER := NULL;
81: lv_false_flag VARCHAR(1) := 'Y';
82: lv_error_msg VARCHAR2(2000) := NULL;
83: lv_error_status BOOLEAN;

Line 90: FND_LOG.STRING(ln_proc_level,

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

Line 95: FND_LOG.STRING(ln_proc_level,

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

Line 203: FND_LOG.STRING(ln_proc_level,

199:
200: --logging for debug
201: IF (ln_proc_level >= ln_dbg_level)
202: THEN
203: FND_LOG.STRING(ln_proc_level,
204: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
205: 'Exit procedure');
206: END IF; -- (ln_proc_level>=ln_dbg_level)
207:

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

206: END IF; -- (ln_proc_level>=ln_dbg_level)
207:
208: EXCEPTION
209: WHEN OTHERS THEN
210: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
211: THEN
212: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
213: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
214: '.Other_Exception ',

Line 212: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

208: EXCEPTION
209: WHEN OTHERS THEN
210: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
211: THEN
212: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
213: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
214: '.Other_Exception ',
215: SQLCODE || SQLERRM);
216: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

212: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
213: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
214: '.Other_Exception ',
215: SQLCODE || SQLERRM);
216: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
217: pv_retcode := '2';
218: pv_errbuf := SQLCODE || SQLERRM;
219: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
220: