399: hr_utility.set_location('Entering:'||l_proc, 5);
400: --
401: -- Ensure that all the mandatory arguments are not null
402: --
403: hr_api.mandatory_arg_error(p_api_name => l_proc
404: ,p_argument => 'effective_date'
405: ,p_argument_value => p_effective_date
406: );
407: --
404: ,p_argument => 'effective_date'
405: ,p_argument_value => p_effective_date
406: );
407: --
408: hr_api.mandatory_arg_error(p_api_name => l_proc
409: ,p_argument => 'datetrack_mode'
410: ,p_argument_value => p_datetrack_mode
411: );
412: --
409: ,p_argument => 'datetrack_mode'
410: ,p_argument_value => p_datetrack_mode
411: );
412: --
413: hr_api.mandatory_arg_error(p_api_name => l_proc
414: ,p_argument => 'contact_extra_info_id'
415: ,p_argument_value => p_contact_extra_info_id
416: );
417: --
414: ,p_argument => 'contact_extra_info_id'
415: ,p_argument_value => p_contact_extra_info_id
416: );
417: --
418: hr_api.mandatory_arg_error(p_api_name => l_proc
419: ,p_argument => 'object_version_number'
420: ,p_argument_value => p_object_version_number
421: );
422: --
421: );
422: --
423: -- Check to ensure the datetrack mode is not INSERT.
424: --
425: If (p_datetrack_mode <> hr_api.g_insert) then
426: --
427: -- We must select and lock the current row.
428: --
429: Open C_Sel1;
490: --
491: -- We need to trap the ORA LOCK exception
492: --
493: Exception
494: When HR_Api.Object_Locked then
495: --
496: -- The object is locked therefore we need to supply a meaningful
497: -- error message.
498: --