APPS.JA_CN_VOUCHER_NUM_PKG dependencies on FND_LOG

Line 58: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

54: pv_period_name IN VARCHAR2,
55: pv_regenerate_flag IN VARCHAR2) IS
56:
57: lv_procedure_name VARCHAR2(40) := 'Generate_voucher_number';
58: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
59: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
60: ln_voucher_number NUMBER;
61: ln_last_header_id NUMBER;
62: ln_je_header_id NUMBER;

Line 59: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

55: pv_regenerate_flag IN VARCHAR2) IS
56:
57: lv_procedure_name VARCHAR2(40) := 'Generate_voucher_number';
58: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
59: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
60: ln_voucher_number NUMBER;
61: ln_last_header_id NUMBER;
62: ln_je_header_id NUMBER;
63: ln_bsv_assigned_num NUMBER;

Line 136: FND_LOG.STRING(ln_proc_level,

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

Line 262: FND_LOG.STRING(ln_proc_level,

258: RAISE;
259: END;
260: --logging for debug
261: IF (ln_proc_level >= ln_dbg_level) THEN
262: FND_LOG.STRING(ln_proc_level,
263: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
264: 'Exit procedure');
265: END IF; -- (ln_proc_level>=ln_dbg_level)
266:

Line 300: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

296: pv_period_to IN VARCHAR2,
297: pv_regenerate_flag IN VARCHAR2) IS
298: ln_flag VARCHAR2(10);
299: lv_procedure_name VARCHAR2(40) := 'Generate_voucher_num_periods';
300: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
301: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
302: CURSOR periods_cur IS
303: SELECT period_name
304: FROM gl_period_statuses

Line 301: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

297: pv_regenerate_flag IN VARCHAR2) IS
298: ln_flag VARCHAR2(10);
299: lv_procedure_name VARCHAR2(40) := 'Generate_voucher_num_periods';
300: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
301: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
302: CURSOR periods_cur IS
303: SELECT period_name
304: FROM gl_period_statuses
305: WHERE application_id = 101

Line 325: FND_LOG.STRING(ln_proc_level,

321: ORDER BY start_date;
322: BEGIN
323: --logging for debug
324: IF (ln_proc_level >= ln_dbg_level) THEN
325: FND_LOG.STRING(ln_proc_level,
326: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
327: '.begin',
328: 'Enter procedure');
329: END IF; --ln_proc_level>=ln_dbg_level

Line 357: FND_LOG.STRING(ln_proc_level,

353: RAISE;
354: END;
355: --logging for debug
356: IF (ln_proc_level >= ln_dbg_level) THEN
357: FND_LOG.STRING(ln_proc_level,
358: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
359: 'Exit procedure');
360: END IF; -- (ln_proc_level>=ln_dbg_level)
361: END Generate_voucher_num_periods;

Line 398: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

394: P_PERIOD_TO IN VARCHAR2,
395: P_REGENERATE_FLAG IN VARCHAR2) IS
396:
397: lv_procedure_name VARCHAR2(40) := 'beforeReport';
398: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
399: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
400: VOUCHER_NUMBER_FROM NUMBER;
401: VOUCHER_NUMBER_TO NUMBER;
402: JOURNAL_AMOUNT NUMBER;

Line 399: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

Line 426: FND_LOG.STRING(ln_proc_level,

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

Line 480: Fnd_Log.STRING(ln_Proc_Level,

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