297:
298: DELETE JTM_MTL_TRANS_LOT_NUM_ACC
299: WHERE RESOURCE_ID = p_resource_id;
300:
301: x_return_status := FND_API.G_RET_STS_SUCCESS;
302:
303: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
304: jtm_message_log_pkg.Log_Msg
305: ( p_resource_id
309: );
310: END IF;
311: EXCEPTION WHEN OTHERS THEN
312: /*** hook failed -> log error ***/
313: -- x_return_status := FND_API.G_RET_STS_ERROR;
314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
316: jtm_message_log_pkg.Log_Msg
317: ( v_object_id => 1
310: END IF;
311: EXCEPTION WHEN OTHERS THEN
312: /*** hook failed -> log error ***/
313: -- x_return_status := FND_API.G_RET_STS_ERROR;
314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
316: jtm_message_log_pkg.Log_Msg
317: ( v_object_id => 1
318: , v_object_name => g_table_name