DBA Data[Home] [Help]

APPS.JA_CN_GL_EXPORT_REPORT_PROG dependencies on FND_LOG

Line 117: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

113: ,pv_accounting_date IN VARCHAR2
114: )
115: IS
116: lv_procedure_name VARCHAR2(40) := 'Export_GL';
117: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
118: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
119: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
120: lv_error_status BOOLEAN;
121:

Line 118: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

114: )
115: IS
116: lv_procedure_name VARCHAR2(40) := 'Export_GL';
117: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
118: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
119: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
120: lv_error_status BOOLEAN;
121:
122: ln_reqid_gle NUMBER;

Line 119: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

115: IS
116: lv_procedure_name VARCHAR2(40) := 'Export_GL';
117: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
118: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
119: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
120: lv_error_status BOOLEAN;
121:
122: ln_reqid_gle NUMBER;
123: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;

Line 153: FND_LOG.STRING(ln_proc_level,

149: BEGIN
150: --logging for debug
151: IF (ln_proc_level >= ln_dbg_level)
152: THEN
153: FND_LOG.STRING(ln_proc_level,
154: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
155: '.begin',
156: 'Enter procedure');
157: -- logging the parameters

Line 158: FND_LOG.STRING(ln_proc_level,

154: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
155: '.begin',
156: 'Enter procedure');
157: -- logging the parameters
158: FND_LOG.STRING(ln_proc_level,
159: lv_procedure_name ||
160: '.parameters',
161: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
162: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 351: FND_LOG.STRING(ln_statement_level,

347: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 3: Submit FSG report');
348: --logging the variables
349: IF (ln_statement_level >= ln_dbg_level)
350: THEN
351: FND_LOG.STRING(ln_statement_level,
352: lv_procedure_name,
353: 'lv_period_to:' || lv_period_to || ',' ||
354: 'lv_accounting_date:' || lv_accounting_date);
355: END IF; --(ln_statement_level >= ln_dbg_level)

Line 460: FND_LOG.STRING(ln_statement_level,

456: );
457: --logging the variables
458: IF (ln_statement_level >= ln_dbg_level)
459: THEN
460: FND_LOG.STRING(ln_statement_level,
461: lv_procedure_name,
462: 'lv_output_file_name:' || lv_output_file_name);
463: END IF; --(ln_statement_level >= ln_dbg_level)
464: FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

Line 543: FND_LOG.STRING(ln_proc_level,

539:
540: --logging for debug
541: IF (ln_proc_level >= ln_dbg_level)
542: THEN
543: FND_LOG.STRING(ln_proc_level,
544: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
545: 'Exit procedure');
546: END IF; -- (ln_proc_level>=ln_dbg_level)
547:

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

546: END IF; -- (ln_proc_level>=ln_dbg_level)
547:
548: EXCEPTION
549: WHEN OTHERS THEN
550: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
551: THEN
552: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
553: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
554: '.Other_Exception ',

Line 552: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

548: EXCEPTION
549: WHEN OTHERS THEN
550: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
551: THEN
552: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
553: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
554: '.Other_Exception ',
555: SQLCODE || SQLERRM);
556: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

552: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
553: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
554: '.Other_Exception ',
555: SQLCODE || SQLERRM);
556: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
557: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
558:
559: END Submit_Request;
560: