205: ,P_PK1_NUM_VALUE => r_no_esc.task_reference_id
206: );
207: END LOOP;
208:
209: x_return_status := FND_API.G_RET_STS_SUCCESS;
210:
211: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
212: jtm_message_log_pkg.Log_Msg
213: ( p_resource_id
217: );
218: END IF;
219: EXCEPTION
220: WHEN OTHERS THEN
221: -- x_return_status := FND_API.G_RET_STS_ERROR;
222: x_return_status := FND_API.G_RET_STS_SUCCESS;
223: jtm_message_log_pkg.Log_Msg
224: ( p_resource_id
225: , g_table_name
218: END IF;
219: EXCEPTION
220: WHEN OTHERS THEN
221: -- x_return_status := FND_API.G_RET_STS_ERROR;
222: x_return_status := FND_API.G_RET_STS_SUCCESS;
223: jtm_message_log_pkg.Log_Msg
224: ( p_resource_id
225: , g_table_name
226: , 'CON_REQUEST_TASK_REFERENCES'||fnd_global.local_chr(10)||