APPS.JA_CN_VOUCHER_NUM_MIG_PKG dependencies on FND_LOG

Line 59: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

55: pn_legal_entity_id IN NUMBER,
56: pv_period_name IN VARCHAR2) IS
57:
58: lv_procedure_name VARCHAR2(40) := 'Migrate_voucher_number';
59: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
60: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
61: ln_bsv_assigned_num NUMBER;
62: ln_bsv_mig_num NUMBER;
63: ln_no_bsv_mig_num NUMBER;

Line 60: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

56: pv_period_name IN VARCHAR2) IS
57:
58: lv_procedure_name VARCHAR2(40) := 'Migrate_voucher_number';
59: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
60: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
61: ln_bsv_assigned_num NUMBER;
62: ln_bsv_mig_num NUMBER;
63: ln_no_bsv_mig_num NUMBER;
64:

Line 133: FND_LOG.STRING(ln_proc_level,

129: gjh.je_header_id ASC;
130: BEGIN
131: --logging for debug
132: IF (ln_proc_level >= ln_dbg_level) THEN
133: FND_LOG.STRING(ln_proc_level,
134: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
135: '.begin',
136: 'Enter procedure');
137: END IF; --ln_proc_level>=ln_dbg_level

Line 282: FND_LOG.STRING(ln_proc_level,

278: RAISE;
279: END;
280: --logging for debug
281: IF (ln_proc_level >= ln_dbg_level) THEN
282: FND_LOG.STRING(ln_proc_level,
283: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
284: 'Exit procedure');
285: END IF; -- (ln_proc_level>=ln_dbg_level)
286:

Line 315: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

311: PROCEDURE Migrate_voucher_num_periods(pn_ledger_id IN NUMBER,
312: pn_legal_entity_id IN NUMBER) IS
313: ln_flag VARCHAR2(10);
314: lv_procedure_name VARCHAR2(40) := 'Migrate_voucher_num_periods';
315: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
316: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
317: CURSOR periods_cur IS
318: SELECT period_name
319: FROM gl_period_statuses

Line 316: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

312: pn_legal_entity_id IN NUMBER) IS
313: ln_flag VARCHAR2(10);
314: lv_procedure_name VARCHAR2(40) := 'Migrate_voucher_num_periods';
315: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
316: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
317: CURSOR periods_cur IS
318: SELECT period_name
319: FROM gl_period_statuses
320: WHERE application_id = 101

Line 334: FND_LOG.STRING(ln_proc_level,

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

Line 362: FND_LOG.STRING(ln_proc_level,

358: RAISE;
359: END;
360: --logging for debug
361: IF (ln_proc_level >= ln_dbg_level) THEN
362: FND_LOG.STRING(ln_proc_level,
363: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
364: 'Exit procedure');
365: END IF; -- (ln_proc_level>=ln_dbg_level)
366: END Migrate_voucher_num_periods;

Line 400: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

396: P_LEGAL_ENTITY_ID IN NUMBER,
397: P_LEGAL_ENTITY IN VARCHAR2) IS
398:
399: lv_procedure_name VARCHAR2(40) := 'beforeReport';
400: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
401: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
402: VOUCHER_NUMBER_FROM NUMBER;
403: VOUCHER_NUMBER_TO NUMBER;
404: JOURNAL_AMOUNT NUMBER;

Line 401: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

397: P_LEGAL_ENTITY IN VARCHAR2) IS
398:
399: lv_procedure_name VARCHAR2(40) := 'beforeReport';
400: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
401: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
402: VOUCHER_NUMBER_FROM NUMBER;
403: VOUCHER_NUMBER_TO NUMBER;
404: JOURNAL_AMOUNT NUMBER;
405: l_Error_Msg VARCHAR2(300);

Line 423: FND_LOG.STRING(ln_proc_level,

419: ORDER BY start_date;
420: BEGIN
421: --logging for debug
422: IF (ln_proc_level >= ln_dbg_level) THEN
423: FND_LOG.STRING(ln_proc_level,
424: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
425: '.begin',
426: 'Enter procedure');
427: END IF; --ln_proc_level>=ln_dbg_level

Line 476: Fnd_Log.STRING(ln_Proc_Level,

472: END IF;
473: EXCEPTION
474: WHEN OTHERS THEN
475: IF (ln_Proc_Level >= ln_dbg_level) THEN
476: Fnd_Log.STRING(ln_Proc_Level,
477: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
478: '. Other_Exception ',
479: SQLCODE || ':' || SQLERRM);
480: END IF; --(l_proc_level >= l_dbg_level)