DBA Data[Home] [Help]

APPS.JA_CN_AR_VALIDATION_PKG dependencies on FND_LOG

Line 69: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

65: ,pv_period_to IN VARCHAR2
66: )
67: IS
68: lv_procedure_name VARCHAR2(40) := 'Validate_Receivables';
69: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
70: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
71: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
72: NO_DATA EXCEPTION;
73:

Line 70: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

66: )
67: IS
68: lv_procedure_name VARCHAR2(40) := 'Validate_Receivables';
69: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
70: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
71: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
72: NO_DATA EXCEPTION;
73:
74: ld_start_date DATE;

Line 71: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

67: IS
68: lv_procedure_name VARCHAR2(40) := 'Validate_Receivables';
69: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
70: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
71: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
72: NO_DATA EXCEPTION;
73:
74: ld_start_date DATE;
75: ld_end_date DATE;

Line 254: FND_LOG.STRING(ln_proc_level,

250: BEGIN
251: --logging for debug
252: IF (ln_proc_level >= ln_dbg_level)
253: THEN
254: FND_LOG.STRING(ln_proc_level,
255: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
256: '.begin',
257: 'Enter procedure');
258: -- logging the parameters

Line 259: FND_LOG.STRING(ln_proc_level,

255: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
256: '.begin',
257: 'Enter procedure');
258: -- logging the parameters
259: FND_LOG.STRING(ln_proc_level,
260: lv_procedure_name ||
261: '.parameters',
262: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
263: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 316: FND_LOG.STRING(ln_statement_level,

312:
313: --logging the variables
314: IF (ln_statement_level >= ln_dbg_level)
315: THEN
316: FND_LOG.STRING(ln_statement_level,
317: lv_procedure_name,
318: 'ld_start_date=' || ld_start_date || ',' ||
319: 'ld_end_date=' || ld_end_date);
320: END IF; --(ln_statement_level >= ln_dbg_level)

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: pv_retcode := '2';
558: pv_errbuf := SQLCODE || SQLERRM;
559: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
560: