DBA Data[Home] [Help]

APPS.JA_CN_SI_EXPORT_PROG dependencies on FND_LOG

Line 64: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

60: , pv_accounting_year IN VARCHAR2
61: )
62: IS
63: lv_procedure_name VARCHAR2(40) := 'Export_Shared_Information';
64: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
65: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
66: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
67: lv_gl_element VARCHAR2(1000);
68:

Line 65: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

61: )
62: IS
63: lv_procedure_name VARCHAR2(40) := 'Export_Shared_Information';
64: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
65: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
66: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
67: lv_gl_element VARCHAR2(1000);
68:
69: BEGIN

Line 66: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

62: IS
63: lv_procedure_name VARCHAR2(40) := 'Export_Shared_Information';
64: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
65: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
66: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
67: lv_gl_element VARCHAR2(1000);
68:
69: BEGIN
70: --logging for debug

Line 73: FND_LOG.STRING( ln_proc_level

69: BEGIN
70: --logging for debug
71: IF (ln_proc_level>=ln_dbg_level)
72: THEN
73: FND_LOG.STRING( ln_proc_level
74: , GV_MODULE_PREFIX ||'.' || lv_procedure_name ||
75: '.begin'
76: , 'Enter procedure'
77: );

Line 80: FND_LOG.STRING(ln_proc_level,

76: , 'Enter procedure'
77: );
78:
79: -- logging the parameters
80: FND_LOG.STRING(ln_proc_level,
81: lv_procedure_name ||
82: '.parameters',
83: 'pn_legal_entity_id=' || pn_legal_entity_id|| ',' ||
84: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 188: FND_LOG.STRING( ln_proc_level

184:
185: --logging for debug
186: IF (ln_proc_level >= ln_dbg_level)
187: THEN
188: FND_LOG.STRING( ln_proc_level
189: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
190: 'Exit procedure');
191: END IF; -- (ln_proc_level>=ln_dbg_level)
192: EXCEPTION

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

190: 'Exit procedure');
191: END IF; -- (ln_proc_level>=ln_dbg_level)
192: EXCEPTION
193: WHEN OTHERS THEN
194: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
195: THEN
196: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
197: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
198: '.Other_Exception ',

Line 196: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

192: EXCEPTION
193: WHEN OTHERS THEN
194: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
195: THEN
196: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
197: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
198: '.Other_Exception ',
199: SQLCODE || SQLERRM);
200: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

196: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
197: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
198: '.Other_Exception ',
199: SQLCODE || SQLERRM);
200: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
201: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
202: pv_retcode := 2;
203: END Export_Shared_Information;
204:

Line 246: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

242: IS
243: NO_DATA EXCEPTION;
244:
245: lv_procedure_name VARCHAR2(40) := 'Export_SI';
246: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
247: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
248: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
249: lv_error_status BOOLEAN;
250:

Line 247: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

243: NO_DATA EXCEPTION;
244:
245: lv_procedure_name VARCHAR2(40) := 'Export_SI';
246: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
247: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
248: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
249: lv_error_status BOOLEAN;
250:
251: ln_reqid_gle NUMBER;

Line 248: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

244:
245: lv_procedure_name VARCHAR2(40) := 'Export_SI';
246: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
247: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
248: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
249: lv_error_status BOOLEAN;
250:
251: ln_reqid_gle NUMBER;
252: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;

Line 275: FND_LOG.STRING( ln_proc_level

271: BEGIN
272: --logging for debug
273: IF (ln_proc_level>=ln_dbg_level)
274: THEN
275: FND_LOG.STRING( ln_proc_level
276: , GV_MODULE_PREFIX ||'.' || lv_procedure_name ||
277: '.begin'
278: , 'Enter procedure'
279: );

Line 282: FND_LOG.STRING(ln_proc_level,

278: , 'Enter procedure'
279: );
280:
281: -- logging the parameters
282: FND_LOG.STRING(ln_proc_level,
283: lv_procedure_name ||
284: '.parameters',
285: 'pn_legal_entity_id=' || pn_legal_entity_id|| ',' ||
286: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 378: FND_LOG.STRING(ln_statement_level,

374: );
375: --logging the variables
376: IF (ln_statement_level >= ln_dbg_level)
377: THEN
378: FND_LOG.STRING(ln_statement_level,
379: lv_procedure_name,
380: 'lv_output_file_name:' || lv_output_file_name);
381: END IF; --(ln_statement_level >= ln_dbg_level)
382: FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

Line 444: FND_LOG.STRING( ln_proc_level

440:
441: --logging for debug
442: IF (ln_proc_level >= ln_dbg_level)
443: THEN
444: FND_LOG.STRING( ln_proc_level
445: ,GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
446: 'Exit procedure');
447: END IF; -- (ln_proc_level>=ln_dbg_level)
448:

Line 452: FND_LOG.STRING( ln_proc_level

448:
449: --logging for debug
450: IF (ln_proc_level>=ln_dbg_level)
451: THEN
452: FND_LOG.STRING( ln_proc_level
453: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
454: , 'Exit procedure'
455: );
456: END IF; -- (ln_proc_level>=ln_dbg_level)

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

456: END IF; -- (ln_proc_level>=ln_dbg_level)
457:
458: EXCEPTION
459: WHEN OTHERS THEN
460: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
461: THEN
462: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
463: , GV_MODULE_PREFIX || '.' || lv_procedure_name ||
464: '.Other_Exception ',

Line 462: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

458: EXCEPTION
459: WHEN OTHERS THEN
460: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
461: THEN
462: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
463: , GV_MODULE_PREFIX || '.' || lv_procedure_name ||
464: '.Other_Exception ',
465: SQLCODE || SQLERRM);
466: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

462: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
463: , GV_MODULE_PREFIX || '.' || lv_procedure_name ||
464: '.Other_Exception ',
465: SQLCODE || SQLERRM);
466: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
467: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
468:
469: END Submit_Request;
470: