5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdtclnb.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_LINE_ID IN OUT NOCOPY NUMBER
13: ,p_OBJECT_VERSION_NUMBER NUMBER
335: p_REPAIR_ACTUAL_LINE_ID NUMBER
336: ,p_OBJECT_VERSION_NUMBER NUMBER)
337:
338: IS
339: -- Variables used in FND Log
340: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
341: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
342: l_event_level number := FND_LOG.LEVEL_EVENT;
343: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
336: ,p_OBJECT_VERSION_NUMBER NUMBER)
337:
338: IS
339: -- Variables used in FND Log
340: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
341: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
342: l_event_level number := FND_LOG.LEVEL_EVENT;
343: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
344: l_error_level number := FND_LOG.LEVEL_ERROR;
337:
338: IS
339: -- Variables used in FND Log
340: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
341: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
342: l_event_level number := FND_LOG.LEVEL_EVENT;
343: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
344: l_error_level number := FND_LOG.LEVEL_ERROR;
345: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
338: IS
339: -- Variables used in FND Log
340: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
341: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
342: l_event_level number := FND_LOG.LEVEL_EVENT;
343: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
344: l_error_level number := FND_LOG.LEVEL_ERROR;
345: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
346: l_mod_name varchar2(2000) := 'csd.plsql.CSD_REPAIR_ACTUAL_LINES_PKG.Lock_Row';
339: -- Variables used in FND Log
340: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
341: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
342: l_event_level number := FND_LOG.LEVEL_EVENT;
343: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
344: l_error_level number := FND_LOG.LEVEL_ERROR;
345: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
346: l_mod_name varchar2(2000) := 'csd.plsql.CSD_REPAIR_ACTUAL_LINES_PKG.Lock_Row';
347:
340: l_stat_level number := FND_LOG.LEVEL_STATEMENT;
341: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
342: l_event_level number := FND_LOG.LEVEL_EVENT;
343: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
344: l_error_level number := FND_LOG.LEVEL_ERROR;
345: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
346: l_mod_name varchar2(2000) := 'csd.plsql.CSD_REPAIR_ACTUAL_LINES_PKG.Lock_Row';
347:
348: CURSOR C IS
341: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
342: l_event_level number := FND_LOG.LEVEL_EVENT;
343: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
344: l_error_level number := FND_LOG.LEVEL_ERROR;
345: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
346: l_mod_name varchar2(2000) := 'csd.plsql.CSD_REPAIR_ACTUAL_LINES_PKG.Lock_Row';
347:
348: CURSOR C IS
349: SELECT *
361: End If;
362: CLOSE C;
363:
364: IF ( l_stat_level >= G_debug_level) THEN
365: FND_LOG.STRING(l_stat_level,l_mod_name,'CSD_REPAIR_ACTUAL_LINES_PKG Recinfo.OBJECT_VERSION_NUMBER : '||Recinfo.OBJECT_VERSION_NUMBER);
366: FND_LOG.STRING(l_stat_level,l_mod_name,'CSD_REPAIR_ACTUAL_LINES_PKG p_OBJECT_VERSION_NUMBER : '||p_OBJECT_VERSION_NUMBER);
367: END IF;
368:
369: If ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER) then
362: CLOSE C;
363:
364: IF ( l_stat_level >= G_debug_level) THEN
365: FND_LOG.STRING(l_stat_level,l_mod_name,'CSD_REPAIR_ACTUAL_LINES_PKG Recinfo.OBJECT_VERSION_NUMBER : '||Recinfo.OBJECT_VERSION_NUMBER);
366: FND_LOG.STRING(l_stat_level,l_mod_name,'CSD_REPAIR_ACTUAL_LINES_PKG p_OBJECT_VERSION_NUMBER : '||p_OBJECT_VERSION_NUMBER);
367: END IF;
368:
369: If ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER) then
370: return;