APPS.JA_CN_JE_EXPORT_PKG dependencies on FND_LOG

Line 81: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

77: ,pv_period_to IN VARCHAR2
78: )
79: IS
80: lv_procedure_name VARCHAR2(40) := 'Add_Journal';
81: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
82: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
83: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
84: ln_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
85: NO_DATA EXCEPTION;

Line 82: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

78: )
79: IS
80: lv_procedure_name VARCHAR2(40) := 'Add_Journal';
81: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
82: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
83: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
84: ln_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
85: NO_DATA EXCEPTION;
86:

Line 83: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

79: IS
80: lv_procedure_name VARCHAR2(40) := 'Add_Journal';
81: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
82: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
83: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
84: ln_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
85: NO_DATA EXCEPTION;
86:
87: lv_message VARCHAR2(300);

Line 84: ln_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

80: lv_procedure_name VARCHAR2(40) := 'Add_Journal';
81: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
82: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
83: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
84: ln_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
85: NO_DATA EXCEPTION;
86:
87: lv_message VARCHAR2(300);
88: ln_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;

Line 340: FND_LOG.STRING(ln_proc_level,

336:
337: BEGIN
338: --log the parameters
339: IF (ln_proc_level >= ln_dbg_level) THEN
340: FND_LOG.STRING(ln_proc_level,
341: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
342: '.begin',
343: 'Enter procedure');
344: -- logging the parameters

Line 345: FND_LOG.STRING(ln_proc_level,

341: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
342: '.begin',
343: 'Enter procedure');
344: -- logging the parameters
345: FND_LOG.STRING(ln_proc_level,
346: lv_procedure_name ||
347: '.parameters',
348: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
349: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 402: FND_LOG.STRING(ln_statement_level,

398:
399: --logging the variables
400: IF (ln_statement_level >= ln_dbg_level)
401: THEN
402: FND_LOG.STRING(ln_statement_level,
403: lv_procedure_name,
404: 'ld_start_date=' || ld_start_date || ',' ||
405: 'ld_end_date=' || ld_end_date);
406: END IF; --(ln_statement_level >= ln_dbg_level)

Line 431: FND_LOG.STRING(ln_statement_level,

427:
428: --logging the variables
429: IF (ln_statement_level >= ln_dbg_level)
430: THEN
431: FND_LOG.STRING(ln_statement_level,
432: lv_procedure_name,
433: 'ln_flex_value_set_id=' || ln_flex_value_set_id);
434: END IF; --(ln_statement_level >= ln_dbg_level)
435: FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

Line 448: FND_LOG.STRING(ln_statement_level,

444: --fetch the account and save it temp table
445: OPEN c_in_ja_cn_journal_lines;
446: --log
447: IF (ln_statement_level >= ln_dbg_level) THEN
448: FND_LOG.STRING(ln_statement_level,
449: lv_procedure_name,
450: 'Fetched account segments start below:');
451:
452: END IF; --ln_statement_level >= ln_dbg_level

Line 472: FND_LOG.STRING(ln_exception_level, lv_procedure_name, lv_message);

468: FND_MESSAGE.set_name('JA', 'JA_CN_NO_DATA_FOUND');
469: lv_message := FND_MESSAGE.get();
470: FND_FILE.put_line(FND_FILE.LOG, lv_message);
471: IF (ln_exception_level >= ln_dbg_level) THEN
472: FND_LOG.STRING(ln_exception_level, lv_procedure_name, lv_message);
473: END IF;
474: ln_row_count := 0;
475: END IF;
476: CLOSE c_in_ja_cn_journal_lines;

Line 495: FND_LOG.STRING(ln_statement_level,

491: AND period_name = l_current_period;
492:
493: --log current period and it's start date
494: IF (ln_statement_level >= ln_dbg_level) THEN
495: FND_LOG.STRING(ln_statement_level,
496: lv_procedure_name,
497: 'about to generate journal lines info for period:' ||
498: l_current_period || ' start date:' ||
499: ld_current_start_date);

Line 509: FND_LOG.STRING(ln_statement_level,

505: INTO l_ja_cn_subsidiary_gbl_tmp_row;
506: EXIT WHEN c_in_ja_cn_subsidiary_gbl_tmp%NOTFOUND;
507: --log
508: IF (ln_statement_level >= ln_dbg_level) THEN
509: FND_LOG.STRING(ln_statement_level,
510: lv_procedure_name,
511: 'about to generate group clause for account:' ||
512: l_ja_cn_subsidiary_gbl_tmp_row.account_segment_value);
513: END IF;

Line 546: FND_LOG.STRING(ln_statement_level,

542:
543: --logging the variables
544: IF (ln_statement_level >= ln_dbg_level)
545: THEN
546: FND_LOG.STRING(ln_statement_level,
547: lv_procedure_name,
548: 'l_functional_currency=' || l_functional_currency);
549: END IF; --(ln_statement_level >= ln_dbg_level)
550: FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

Line 852: FND_LOG.STRING(ln_proc_level,

848:
849: --logging for debug
850: IF (ln_proc_level >= ln_dbg_level)
851: THEN
852: FND_LOG.STRING(ln_proc_level,
853: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
854: 'Exit procedure');
855: END IF; -- (ln_proc_level>=ln_dbg_level
856:

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

855: END IF; -- (ln_proc_level>=ln_dbg_level
856:
857: EXCEPTION
858: WHEN OTHERS THEN
859: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
860: THEN
861: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
862: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
863: '.Other_Exception ',

Line 861: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

857: EXCEPTION
858: WHEN OTHERS THEN
859: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
860: THEN
861: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
862: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
863: '.Other_Exception ',
864: SQLCODE || SQLERRM);
865: END IF;