68: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
69: jtm_message_log_pkg.Log_Msg
70: ( null
71: , g_table_name
72: , 'Calling CSL_CS_INCIDENTS_ALL_ACC_PKG.INSERT_ALL_ACC_RECORDS'
73: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
74: END IF;
75: CSL_CS_INCIDENTS_ALL_ACC_PKG.INSERT_ALL_ACC_RECORDS
76: ( p_resource_id
71: , g_table_name
72: , 'Calling CSL_CS_INCIDENTS_ALL_ACC_PKG.INSERT_ALL_ACC_RECORDS'
73: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
74: END IF;
75: CSL_CS_INCIDENTS_ALL_ACC_PKG.INSERT_ALL_ACC_RECORDS
76: ( p_resource_id
77: , x_return_status );
78: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
79: RAISE FND_API.G_EXC_ERROR;
328: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
329: jtm_message_log_pkg.Log_Msg
330: ( null
331: , g_table_name
332: , 'Delete from CSL_CS_INCIDENTS_ALL_ACC for resource '||p_resource_id
333: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
334: , 'csl_user_pkg');
335: END IF;
336: DELETE CSL_CS_INCIDENTS_ALL_ACC
332: , 'Delete from CSL_CS_INCIDENTS_ALL_ACC for resource '||p_resource_id
333: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
334: , 'csl_user_pkg');
335: END IF;
336: DELETE CSL_CS_INCIDENTS_ALL_ACC
337: WHERE RESOURCE_ID = p_resource_id;
338: COMMIT;
339:
340: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN