DBA Data[Home] [Help]

APPS.CSD_REPAIR_ACTUALS_PKG dependencies on FND_LOG

Line 9: G_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdtactb.pls';
6: l_debug NUMBER := csd_gen_utility_pvt.g_debug_level;
7:
8: -- Global variable for storing the debug level
9: G_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
10:
11: PROCEDURE Insert_Row(
12: px_REPAIR_ACTUAL_ID IN OUT NOCOPY NUMBER
13: ,p_OBJECT_VERSION_NUMBER NUMBER

Line 193: -- Variables used in FND Log

189: ,p_OBJECT_VERSION_NUMBER NUMBER)
190:
191: IS
192:
193: -- Variables used in FND Log
194: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
195: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
196: l_event_level number := FND_LOG.LEVEL_EVENT;
197: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;

Line 194: l_stat_level number := FND_LOG.LEVEL_STATEMENT;

190:
191: IS
192:
193: -- Variables used in FND Log
194: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
195: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
196: l_event_level number := FND_LOG.LEVEL_EVENT;
197: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
198: l_error_level number := FND_LOG.LEVEL_ERROR;

Line 195: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;

191: IS
192:
193: -- Variables used in FND Log
194: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
195: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
196: l_event_level number := FND_LOG.LEVEL_EVENT;
197: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
198: l_error_level number := FND_LOG.LEVEL_ERROR;
199: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

Line 196: l_event_level number := FND_LOG.LEVEL_EVENT;

192:
193: -- Variables used in FND Log
194: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
195: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
196: l_event_level number := FND_LOG.LEVEL_EVENT;
197: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
198: l_error_level number := FND_LOG.LEVEL_ERROR;
199: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
200: l_mod_name varchar2(2000) := 'csd.plsql.CSD_REPAIR_ACTUALS_PKG.Lock_Row';

Line 197: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;

193: -- Variables used in FND Log
194: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
195: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
196: l_event_level number := FND_LOG.LEVEL_EVENT;
197: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
198: l_error_level number := FND_LOG.LEVEL_ERROR;
199: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
200: l_mod_name varchar2(2000) := 'csd.plsql.CSD_REPAIR_ACTUALS_PKG.Lock_Row';
201:

Line 198: l_error_level number := FND_LOG.LEVEL_ERROR;

194: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
195: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
196: l_event_level number := FND_LOG.LEVEL_EVENT;
197: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
198: l_error_level number := FND_LOG.LEVEL_ERROR;
199: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
200: l_mod_name varchar2(2000) := 'csd.plsql.CSD_REPAIR_ACTUALS_PKG.Lock_Row';
201:
202: CURSOR C IS

Line 199: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

195: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
196: l_event_level number := FND_LOG.LEVEL_EVENT;
197: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
198: l_error_level number := FND_LOG.LEVEL_ERROR;
199: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
200: l_mod_name varchar2(2000) := 'csd.plsql.CSD_REPAIR_ACTUALS_PKG.Lock_Row';
201:
202: CURSOR C IS
203: SELECT *

Line 220: FND_LOG.STRING(l_stat_level,l_mod_name,'CSD_REPAIR_ACTUALS_PKG Recinfo.OBJECT_VERSION_NUMBER : '||Recinfo.OBJECT_VERSION_NUMBER);

216: End If;
217: CLOSE C;
218:
219: IF ( l_stat_level >= G_debug_level) THEN
220: FND_LOG.STRING(l_stat_level,l_mod_name,'CSD_REPAIR_ACTUALS_PKG Recinfo.OBJECT_VERSION_NUMBER : '||Recinfo.OBJECT_VERSION_NUMBER);
221: FND_LOG.STRING(l_stat_level,l_mod_name,'CSD_REPAIR_ACTUALS_PKG p_OBJECT_VERSION_NUMBER : '||p_OBJECT_VERSION_NUMBER);
222: END IF;
223:
224: If ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER) then

Line 221: FND_LOG.STRING(l_stat_level,l_mod_name,'CSD_REPAIR_ACTUALS_PKG p_OBJECT_VERSION_NUMBER : '||p_OBJECT_VERSION_NUMBER);

217: CLOSE C;
218:
219: IF ( l_stat_level >= G_debug_level) THEN
220: FND_LOG.STRING(l_stat_level,l_mod_name,'CSD_REPAIR_ACTUALS_PKG Recinfo.OBJECT_VERSION_NUMBER : '||Recinfo.OBJECT_VERSION_NUMBER);
221: FND_LOG.STRING(l_stat_level,l_mod_name,'CSD_REPAIR_ACTUALS_PKG p_OBJECT_VERSION_NUMBER : '||p_OBJECT_VERSION_NUMBER);
222: END IF;
223:
224: If ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER) then
225: return;