APPS.JA_CN_SM_EXPORT_PKG dependencies on FND_LOG

Line 61: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

57: PROCEDURE Add_Settlement_Method(pn_ledger_id IN NUMBER,
58: pn_legal_entity_id IN NUMBER,
59: pv_accounting_year IN VARCHAR2) IS
60: lv_procedure_name VARCHAR2(40) := 'Add_Settlement_Method';
61: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
62: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
63: --ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
64: NO_DATA EXCEPTION;
65: ln_row_count NUMBER := 0;

Line 62: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

58: pn_legal_entity_id IN NUMBER,
59: pv_accounting_year IN VARCHAR2) IS
60: lv_procedure_name VARCHAR2(40) := 'Add_Settlement_Method';
61: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
62: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
63: --ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
64: NO_DATA EXCEPTION;
65: ln_row_count NUMBER := 0;
66:

Line 63: --ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

59: pv_accounting_year IN VARCHAR2) IS
60: lv_procedure_name VARCHAR2(40) := 'Add_Settlement_Method';
61: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
62: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
63: --ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
64: NO_DATA EXCEPTION;
65: ln_row_count NUMBER := 0;
66:
67: CURSOR settlement_method_cur IS

Line 113: FND_LOG.STRING(ln_proc_level,

109:
110: BEGIN
111: --logging for debug
112: IF (ln_proc_level >= ln_dbg_level) THEN
113: FND_LOG.STRING(ln_proc_level,
114: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
115: '.begin',
116: 'Enter procedure');
117: -- logging the parameters

Line 118: FND_LOG.STRING(ln_proc_level,

114: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
115: '.begin',
116: 'Enter procedure');
117: -- logging the parameters
118: FND_LOG.STRING(ln_proc_level,
119: lv_procedure_name || '.parameters',
120: 'pn_ledger_id=' || pn_ledger_id || ',' ||
121: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
122: 'pv_accounting_year=' || pv_accounting_year);

Line 158: FND_LOG.STRING(ln_proc_level,

154: END IF;
155:
156: --logging for debug
157: IF (ln_proc_level >= ln_dbg_level) THEN
158: FND_LOG.STRING(ln_proc_level,
159: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
160: 'Exit procedure');
161: END IF; -- (ln_proc_level>=ln_dbg_level)
162:

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

162:
163: --To handle the No Data Found Exception
164: EXCEPTION
165: WHEN OTHERS THEN
166: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
167: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
168: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
169: '.Other_Exception ',
170: SQLCODE || SQLERRM);

Line 167: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

163: --To handle the No Data Found Exception
164: EXCEPTION
165: WHEN OTHERS THEN
166: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
167: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
168: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
169: '.Other_Exception ',
170: SQLCODE || SQLERRM);
171: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

167: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
168: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
169: '.Other_Exception ',
170: SQLCODE || SQLERRM);
171: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
172: FND_FILE.put_line(FND_FILE.log,
173: lv_procedure_name || SQLCODE || SQLERRM);
174: RAISE;
175: