DBA Data[Home] [Help]

APPS.JA_CN_PS_GL_EXPORT_PROG dependencies on FND_LOG

Line 70: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

66: )
67: IS
68: lv_gl_element VARCHAR2(1000);
69: lv_procedure_name VARCHAR2(40) := 'Export_GL';
70: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
71: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
72: NO_DATA EXCEPTION;
73:
74: BEGIN

Line 71: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

67: IS
68: lv_gl_element VARCHAR2(1000);
69: lv_procedure_name VARCHAR2(40) := 'Export_GL';
70: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
71: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
72: NO_DATA EXCEPTION;
73:
74: BEGIN
75: --logging for debug

Line 78: FND_LOG.STRING(ln_proc_level,

74: BEGIN
75: --logging for debug
76: IF (ln_proc_level >= ln_dbg_level)
77: THEN
78: FND_LOG.STRING(ln_proc_level,
79: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
80: '.begin',
81: 'Enter procedure');
82: -- logging the parameters

Line 83: FND_LOG.STRING(ln_proc_level,

79: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
80: '.begin',
81: 'Enter procedure');
82: -- logging the parameters
83: FND_LOG.STRING(ln_proc_level,
84: lv_procedure_name ||
85: '.parameters',
86: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
87: 'pn_chart_of_account_id=' || pn_chart_of_account_id || ',' ||

Line 197: FND_LOG.STRING(ln_proc_level,

193:
194: --logging for debug
195: IF (ln_proc_level >= ln_dbg_level)
196: THEN
197: FND_LOG.STRING(ln_proc_level,
198: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
199: 'Exit procedure');
200: END IF; -- (ln_proc_level>=ln_dbg_level)
201:

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

200: END IF; -- (ln_proc_level>=ln_dbg_level)
201:
202: EXCEPTION
203: WHEN OTHERS THEN
204: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
205: THEN
206: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
207: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
208: '.Other_Exception ',

Line 206: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

202: EXCEPTION
203: WHEN OTHERS THEN
204: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
205: THEN
206: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
207: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
208: '.Other_Exception ',
209: SQLCODE || SQLERRM);
210: END IF;

Line 299: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

295: ,pn_exp_detail_num IN NUMBER
296: )
297: IS
298: lv_procedure_name VARCHAR2(40) := 'Export_GL';
299: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
300: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
301: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
302: lv_error_status BOOLEAN;
303:

Line 300: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

296: )
297: IS
298: lv_procedure_name VARCHAR2(40) := 'Export_GL';
299: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
300: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
301: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
302: lv_error_status BOOLEAN;
303:
304: ln_reqid_gle NUMBER;

Line 301: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

297: IS
298: lv_procedure_name VARCHAR2(40) := 'Export_GL';
299: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
300: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
301: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
302: lv_error_status BOOLEAN;
303:
304: ln_reqid_gle NUMBER;
305: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;

Line 335: FND_LOG.STRING(ln_proc_level,

331: BEGIN
332: --logging for debug
333: IF (ln_proc_level >= ln_dbg_level)
334: THEN
335: FND_LOG.STRING(ln_proc_level,
336: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
337: '.begin',
338: 'Enter procedure');
339: -- logging the parameters

Line 340: FND_LOG.STRING(ln_proc_level,

336: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
337: '.begin',
338: 'Enter procedure');
339: -- logging the parameters
340: FND_LOG.STRING(ln_proc_level,
341: lv_procedure_name ||
342: '.parameters',
343: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
344: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 620: FND_LOG.STRING(ln_statement_level,

616: );
617: --logging the variables
618: IF (ln_statement_level >= ln_dbg_level)
619: THEN
620: FND_LOG.STRING(ln_statement_level,
621: lv_procedure_name,
622: 'lv_output_file_name:' || lv_output_file_name);
623: END IF; --(ln_statement_level >= ln_dbg_level)
624: FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

Line 703: FND_LOG.STRING(ln_proc_level,

699:
700: --logging for debug
701: IF (ln_proc_level >= ln_dbg_level)
702: THEN
703: FND_LOG.STRING(ln_proc_level,
704: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
705: 'Exit procedure');
706: END IF; -- (ln_proc_level>=ln_dbg_level)
707:

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

706: END IF; -- (ln_proc_level>=ln_dbg_level)
707:
708: EXCEPTION
709: WHEN OTHERS THEN
710: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
711: THEN
712: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
713: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
714: '.Other_Exception ',

Line 712: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

708: EXCEPTION
709: WHEN OTHERS THEN
710: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
711: THEN
712: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
713: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
714: '.Other_Exception ',
715: SQLCODE || SQLERRM);
716: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

712: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
713: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
714: '.Other_Exception ',
715: SQLCODE || SQLERRM);
716: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
717: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
718:
719: END Submit_Request;
720: