APPS.JA_CN_GL_BANK_EXP_REPORT_PKG dependencies on FND_LOG

Line 113: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

109: pn_profit_statement_num IN NUMBER,
110: pn_owners_equity_num IN NUMBER,
111: pv_accounting_date IN VARCHAR2) IS
112: lv_procedure_name VARCHAR2(40) := 'Export_GL';
113: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
114: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
115: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
116: lv_error_status BOOLEAN;
117:

Line 114: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

110: pn_owners_equity_num IN NUMBER,
111: pv_accounting_date IN VARCHAR2) IS
112: lv_procedure_name VARCHAR2(40) := 'Export_GL';
113: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
114: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
115: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
116: lv_error_status BOOLEAN;
117:
118: ln_reqid_gle NUMBER;

Line 115: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

111: pv_accounting_date IN VARCHAR2) IS
112: lv_procedure_name VARCHAR2(40) := 'Export_GL';
113: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
114: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
115: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
116: lv_error_status BOOLEAN;
117:
118: ln_reqid_gle NUMBER;
119: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;

Line 151: FND_LOG.STRING(ln_proc_level,

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

Line 156: FND_LOG.STRING(ln_proc_level,

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

Line 362: FND_LOG.STRING(ln_statement_level,

358: --Step3: submit FSG report
359: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 3: Submit FSG report');
360: --logging the variables
361: IF (ln_statement_level >= ln_dbg_level) THEN
362: FND_LOG.STRING(ln_statement_level,
363: lv_procedure_name,
364: 'lv_period_to:' || lv_period_to || ',' ||
365: 'lv_accounting_date:' || lv_accounting_date);
366: END IF; --(ln_statement_level >= ln_dbg_level)

Line 461: FND_LOG.STRING(ln_statement_level,

457: pv_from_period => lv_period_from,
458: pv_to_period => lv_period_to);
459: --logging the variables
460: IF (ln_statement_level >= ln_dbg_level) THEN
461: FND_LOG.STRING(ln_statement_level,
462: lv_procedure_name,
463: 'lv_output_file_name:' ||
464: lv_output_file_name);
465: END IF; --(ln_statement_level >= ln_dbg_level)

Line 530: FND_LOG.STRING(ln_proc_level,

526: END IF; --lv_error_flag='W'
527:
528: --logging for debug
529: IF (ln_proc_level >= ln_dbg_level) THEN
530: FND_LOG.STRING(ln_proc_level,
531: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
532: 'Exit procedure');
533: END IF; -- (ln_proc_level>=ln_dbg_level)
534:

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

533: END IF; -- (ln_proc_level>=ln_dbg_level)
534:
535: EXCEPTION
536: WHEN OTHERS THEN
537: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
538: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
539: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
540: '.Other_Exception ',
541: SQLCODE || SQLERRM);

Line 538: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

534:
535: EXCEPTION
536: WHEN OTHERS THEN
537: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
538: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
539: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
540: '.Other_Exception ',
541: SQLCODE || SQLERRM);
542: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

538: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
539: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
540: '.Other_Exception ',
541: SQLCODE || SQLERRM);
542: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
543: FND_FILE.put_line(FND_FILE.log,
544: lv_procedure_name || SQLCODE || SQLERRM);
545: pv_retcode := 2;
546: RAISE;