480: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT for incident_id ' || p_record.incident_id ,
481: 'CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
482:
483: EXCEPTION WHEN OTHERS THEN
484: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
485: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
486: (
487: p_api_error => TRUE
488: );
838: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE for incident_id ' || p_record.incident_id ,
839: 'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_PROCEDURE);
840:
841: EXCEPTION WHEN OTHERS THEN
842: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);
843: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
844: (
845: p_api_error => TRUE
846: );
863: l_access_id NUMBER;
864: BEGIN
865: /*** initialize return status and message list ***/
866: x_return_status := FND_API.G_RET_STS_SUCCESS;
867: FND_MSG_PUB.INITIALIZE;
868:
869: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD for incident_id ' || p_record.incident_id ,
870: 'CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
871:
916:
917: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD for incident_id ' || p_record.incident_id ,
918: 'CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
919: EXCEPTION WHEN OTHERS THEN
920: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
921: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
922: (
923: p_api_error => TRUE
924: );