DBA Data[Home] [Help]

APPS.JA_CN_SI_BANK_EXPORT_PKG dependencies on FND_LOG

Line 48: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

44: pn_legal_entity_id IN NUMBER,
45: pv_bsv IN VARCHAR2,
46: pv_accounting_year IN VARCHAR2) IS
47: lv_procedure_name VARCHAR2(40) := 'Export_Shared_Information';
48: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
49: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
50: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
51: lv_gl_element VARCHAR2(1000);
52:

Line 49: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

45: pv_bsv IN VARCHAR2,
46: pv_accounting_year IN VARCHAR2) IS
47: lv_procedure_name VARCHAR2(40) := 'Export_Shared_Information';
48: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
49: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
50: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
51: lv_gl_element VARCHAR2(1000);
52:
53: BEGIN

Line 50: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

46: pv_accounting_year IN VARCHAR2) IS
47: lv_procedure_name VARCHAR2(40) := 'Export_Shared_Information';
48: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
49: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
50: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
51: lv_gl_element VARCHAR2(1000);
52:
53: BEGIN
54: --logging for debug

Line 56: FND_LOG.STRING(ln_proc_level,

52:
53: BEGIN
54: --logging for debug
55: IF (ln_proc_level >= ln_dbg_level) THEN
56: FND_LOG.STRING(ln_proc_level,
57: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
58: '.begin',
59: 'Enter procedure');
60:

Line 62: FND_LOG.STRING(ln_proc_level,

58: '.begin',
59: 'Enter procedure');
60:
61: -- logging the parameters
62: FND_LOG.STRING(ln_proc_level,
63: lv_procedure_name || '.parameters',
64: 'pn_ledger_id=' || pn_ledger_id || ',' ||
65: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
66: 'pv_bsv=' || pv_bsv || ',' ||

Line 167: FND_LOG.STRING(ln_proc_level,

163: FND_FILE.put_line(FND_FILE.output, Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION', Ja_Cn_Utility.GV_TAG_TYPE_END));
164:
165: --logging for debug
166: IF (ln_proc_level >= ln_dbg_level) THEN
167: FND_LOG.STRING(ln_proc_level,
168: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
169: 'Exit procedure');
170: END IF; -- (ln_proc_level>=ln_dbg_level)
171: EXCEPTION

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

169: 'Exit procedure');
170: END IF; -- (ln_proc_level>=ln_dbg_level)
171: EXCEPTION
172: WHEN OTHERS THEN
173: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
174: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
175: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
176: '.Other_Exception ',
177: SQLCODE || SQLERRM);

Line 174: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

170: END IF; -- (ln_proc_level>=ln_dbg_level)
171: EXCEPTION
172: WHEN OTHERS THEN
173: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
174: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
175: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
176: '.Other_Exception ',
177: SQLCODE || SQLERRM);
178: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

174: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
175: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
176: '.Other_Exception ',
177: SQLCODE || SQLERRM);
178: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
179: FND_FILE.put_line(FND_FILE.log,
180: lv_procedure_name || SQLCODE || SQLERRM);
181: pv_retcode := 2;
182: raise;

Line 216: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

212: pv_dest_char_set IN VARCHAR2) IS
213: NO_DATA EXCEPTION;
214:
215: lv_procedure_name VARCHAR2(40) := 'Submit_Request';
216: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
217: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
218: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
219: lv_error_status BOOLEAN;
220:

Line 217: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

213: NO_DATA EXCEPTION;
214:
215: lv_procedure_name VARCHAR2(40) := 'Submit_Request';
216: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
217: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
218: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
219: lv_error_status BOOLEAN;
220:
221: ln_reqid_gle NUMBER;

Line 218: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

214:
215: lv_procedure_name VARCHAR2(40) := 'Submit_Request';
216: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
217: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
218: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
219: lv_error_status BOOLEAN;
220:
221: ln_reqid_gle NUMBER;
222: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;

Line 246: FND_LOG.STRING(ln_proc_level,

242: l_access_set PLS_INTEGER:=FND_PROFILE.VALUE('GL_ACCESS_SET_ID');
243: BEGIN
244: --logging for debug
245: IF (ln_proc_level >= ln_dbg_level) THEN
246: FND_LOG.STRING(ln_proc_level,
247: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
248: '.begin',
249: 'Enter procedure');
250:

Line 252: FND_LOG.STRING(ln_proc_level,

248: '.begin',
249: 'Enter procedure');
250:
251: -- logging the parameters
252: FND_LOG.STRING(ln_proc_level,
253: lv_procedure_name || '.parameters',
254: 'pn_ledger_id=' || pn_ledger_id || ',' ||
255: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
256: 'pv_bsv=' || pv_bsv || ',' ||

Line 363: FND_LOG.STRING(ln_statement_level,

359: pv_from_period => null,
360: pv_to_period => null);
361: --logging the variables
362: IF (ln_statement_level >= ln_dbg_level) THEN
363: FND_LOG.STRING(ln_statement_level,
364: lv_procedure_name,
365: 'lv_output_file_name:' || lv_output_file_name);
366: END IF; --(ln_statement_level >= ln_dbg_level)
367: FND_FILE.put_line(FND_FILE.log,

Line 417: FND_LOG.STRING(ln_proc_level,

413: END IF; --lv_error_flag='W'
414:
415: --logging for debug
416: IF (ln_proc_level >= ln_dbg_level) THEN
417: FND_LOG.STRING(ln_proc_level,
418: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
419: 'Exit procedure');
420: END IF; -- (ln_proc_level>=ln_dbg_level)
421:

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

421:
422:
423: EXCEPTION
424: WHEN OTHERS THEN
425: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
426: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
427: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
428: '.Other_Exception ',
429: SQLCODE || SQLERRM);

Line 426: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

422:
423: EXCEPTION
424: WHEN OTHERS THEN
425: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
426: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
427: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
428: '.Other_Exception ',
429: SQLCODE || SQLERRM);
430: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

426: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
427: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
428: '.Other_Exception ',
429: SQLCODE || SQLERRM);
430: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
431: FND_FILE.put_line(FND_FILE.log,
432: lv_procedure_name || SQLCODE || SQLERRM);
433: IF pv_retcode IS NULL THEN
434: pv_retcode := 2;