APPS.JA_CN_PS_SI_SM_EXPORT_PKG dependencies on FND_LOG

Line 55: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

51: PROCEDURE Add_Settlement_Method(pn_legal_entity_id IN NUMBER,
52: pn_ledger_id IN NUMBER,
53: pn_accounting_year IN NUMBER) IS
54: lv_procedure_name VARCHAR2(40) := 'Add_Settlement_Method';
55: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
56: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
57: ln_row_count NUMBER := 0;
58:
59: CURSOR settlement_method_cur(pn_legal_entity NUMBER,

Line 56: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

52: pn_ledger_id IN NUMBER,
53: pn_accounting_year IN NUMBER) IS
54: lv_procedure_name VARCHAR2(40) := 'Add_Settlement_Method';
55: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
56: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
57: ln_row_count NUMBER := 0;
58:
59: CURSOR settlement_method_cur(pn_legal_entity NUMBER,
60: pn_ledger NUMBER,

Line 97: FND_LOG.STRING(ln_proc_level,

93:
94: BEGIN
95: --logging for debug
96: IF (ln_proc_level >= ln_dbg_level) THEN
97: FND_LOG.STRING(ln_proc_level,
98: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
99: '.begin',
100: 'Enter procedure');
101: -- logging the parameters

Line 102: FND_LOG.STRING(ln_proc_level,

98: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
99: '.begin',
100: 'Enter procedure');
101: -- logging the parameters
102: FND_LOG.STRING(ln_proc_level,
103: lv_procedure_name || '.parameters',
104: 'pn_ledger_id=' || pn_ledger_id || ',' ||
105: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
106: 'pn_accounting_year=' || pn_accounting_year);

Line 140: FND_LOG.STRING(ln_proc_level,

136: JA_CN_UTILITY.GV_TAG_TYPE_END);
137: END IF; -- (ln_row_count = 0)
138: --logging for debug
139: IF (ln_proc_level >= ln_dbg_level) THEN
140: FND_LOG.STRING(ln_proc_level,
141: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
142: 'Exit procedure');
143: END IF; -- (ln_proc_level>=ln_dbg_level)
144: FND_FILE.PUT_LINE(FND_FILE.LOG,

Line 150: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

146: '.end');
147: --To handle the Exception
148: EXCEPTION
149: WHEN OTHERS THEN
150: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
151: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
152: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
153: '.Other_Exception ',
154: SQLCODE || SQLERRM);

Line 151: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

147: --To handle the Exception
148: EXCEPTION
149: WHEN OTHERS THEN
150: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
151: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
152: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
153: '.Other_Exception ',
154: SQLCODE || SQLERRM);
155: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

151: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
152: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
153: '.Other_Exception ',
154: SQLCODE || SQLERRM);
155: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
156: FND_FILE.put_line(FND_FILE.log,
157: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
158: SQLCODE || SQLERRM);
159: RAISE;