DBA Data[Home] [Help]

APPS.JA_CN_APAR_EXPORT_PROG dependencies on FND_LOG

Line 63: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

59: )
60: IS
61: lv_gl_element VARCHAR2(1000);
62: lv_procedure_name VARCHAR2(40) := 'Export_APAR';
63: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
64: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
65: NO_DATA EXCEPTION;
66:
67: BEGIN

Line 64: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

60: IS
61: lv_gl_element VARCHAR2(1000);
62: lv_procedure_name VARCHAR2(40) := 'Export_APAR';
63: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
64: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
65: NO_DATA EXCEPTION;
66:
67: BEGIN
68: --logging for debug

Line 71: FND_LOG.STRING(ln_proc_level,

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

Line 76: FND_LOG.STRING(ln_proc_level,

72: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
73: '.begin',
74: 'Enter procedure');
75: -- logging the parameters
76: FND_LOG.STRING(ln_proc_level,
77: lv_procedure_name ||
78: '.parameters',
79: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
80: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 162: FND_LOG.STRING(ln_proc_level,

158:
159: --logging for debug
160: IF (ln_proc_level >= ln_dbg_level)
161: THEN
162: FND_LOG.STRING(ln_proc_level,
163: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
164: 'Exit procedure');
165: END IF; -- (ln_proc_level>=ln_dbg_level)
166:

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

165: END IF; -- (ln_proc_level>=ln_dbg_level)
166:
167: EXCEPTION
168: WHEN OTHERS THEN
169: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
170: THEN
171: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
172: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
173: '.Other_Exception ',

Line 171: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

167: EXCEPTION
168: WHEN OTHERS THEN
169: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
170: THEN
171: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
172: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
173: '.Other_Exception ',
174: SQLCODE || SQLERRM);
175: END IF;

Line 231: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

227: ,pv_output_format IN VARCHAR2
228: )
229: IS
230: lv_procedure_name VARCHAR2(40) := 'Submit_Request';
231: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
232: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
233: lv_error_status BOOLEAN;
234:
235: ln_reqid_pre NUMBER;

Line 232: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

228: )
229: IS
230: lv_procedure_name VARCHAR2(40) := 'Submit_Request';
231: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
232: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
233: lv_error_status BOOLEAN;
234:
235: ln_reqid_pre NUMBER;
236: lv_pre_phase fnd_lookup_values.meaning%TYPE;

Line 271: FND_LOG.STRING(ln_proc_level,

267: BEGIN
268: --logging for debug
269: IF (ln_proc_level >= ln_dbg_level)
270: THEN
271: FND_LOG.STRING(ln_proc_level,
272: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
273: '.begin',
274: 'Enter procedure');
275: -- logging the parameters

Line 276: FND_LOG.STRING(ln_proc_level,

272: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
273: '.begin',
274: 'Enter procedure');
275: -- logging the parameters
276: FND_LOG.STRING(ln_proc_level,
277: lv_procedure_name ||
278: '.parameters',
279: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
280: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 595: FND_LOG.STRING(ln_proc_level,

591:
592: --logging for debug
593: IF (ln_proc_level >= ln_dbg_level)
594: THEN
595: FND_LOG.STRING(ln_proc_level,
596: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
597: 'Exit procedure');
598: END IF; -- (ln_proc_level>=ln_dbg_level)
599:

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

598: END IF; -- (ln_proc_level>=ln_dbg_level)
599:
600: EXCEPTION
601: WHEN OTHERS THEN
602: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
603: THEN
604: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
605: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
606: '.Other_Exception ',

Line 604: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

600: EXCEPTION
601: WHEN OTHERS THEN
602: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
603: THEN
604: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
605: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
606: '.Other_Exception ',
607: SQLCODE || SQLERRM);
608: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

604: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
605: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
606: '.Other_Exception ',
607: SQLCODE || SQLERRM);
608: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
609: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
610:
611: END Submit_Request;
612: