APPS.JA_CN_ACP_EXPORT_PKG dependencies on FND_LOG

Line 50: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

46: PROCEDURE Add_Accounting_Periods(pn_legal_entity_id NUMBER
47: ,pn_ledger_id NUMBER
48: ,pn_accounting_year NUMBER) IS
49: lv_procedure_name VARCHAR2(40) := 'Add_Accounting_Periods';
50: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
51: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
52: ln_row_count NUMBER;
53: --NO_DATA EXCEPTION;
54:

Line 51: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

47: ,pn_ledger_id NUMBER
48: ,pn_accounting_year NUMBER) IS
49: lv_procedure_name VARCHAR2(40) := 'Add_Accounting_Periods';
50: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
51: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
52: ln_row_count NUMBER;
53: --NO_DATA EXCEPTION;
54:
55: -- to get accounting periods

Line 69: FND_LOG.STRING(ln_proc_level,

65: BEGIN
66: --logging for debug
67: IF (ln_proc_level >= ln_dbg_level)
68: THEN
69: FND_LOG.STRING(ln_proc_level,
70: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
71: '.begin',
72: 'Enter procedure');
73: FND_LOG.STRING(ln_proc_level,

Line 73: FND_LOG.STRING(ln_proc_level,

69: FND_LOG.STRING(ln_proc_level,
70: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
71: '.begin',
72: 'Enter procedure');
73: FND_LOG.STRING(ln_proc_level,
74: lv_procedure_name ||
75: '.parameters',
76: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
77: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 132: FND_LOG.STRING(ln_proc_level,

128:
129: --logging for debug
130: IF (ln_proc_level >= ln_dbg_level)
131: THEN
132: FND_LOG.STRING(ln_proc_level,
133: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
134: 'Exit procedure');
135: END IF; -- (ln_proc_level>=ln_dbg_level)
136: EXCEPTION

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

134: 'Exit procedure');
135: END IF; -- (ln_proc_level>=ln_dbg_level)
136: EXCEPTION
137: WHEN OTHERS THEN
138: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
139: THEN
140: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
141: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
142: '.Other_Exception ',

Line 140: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

136: EXCEPTION
137: WHEN OTHERS THEN
138: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
139: THEN
140: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
141: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
142: '.Other_Exception ',
143: SQLCODE || SQLERRM);
144: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

140: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
141: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
142: '.Other_Exception ',
143: SQLCODE || SQLERRM);
144: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
145: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
146: RAISE;
147: END Add_Accounting_Periods;
148: END JA_CN_ACP_EXPORT_PKG;