294: hr_utility.set_location('Entering:'||l_proc, 5);
295: --
296: -- Ensure that all the mandatory arguments are not null
297: --
298: hr_api.mandatory_arg_error(p_api_name => l_proc
299: ,p_argument => 'effective_date'
300: ,p_argument_value => p_effective_date
301: );
302: --
299: ,p_argument => 'effective_date'
300: ,p_argument_value => p_effective_date
301: );
302: --
303: hr_api.mandatory_arg_error(p_api_name => l_proc
304: ,p_argument => 'datetrack_mode'
305: ,p_argument_value => p_datetrack_mode
306: );
307: --
304: ,p_argument => 'datetrack_mode'
305: ,p_argument_value => p_datetrack_mode
306: );
307: --
308: hr_api.mandatory_arg_error(p_api_name => l_proc
309: ,p_argument => 'global_id'
310: ,p_argument_value => p_global_id
311: );
312: --
309: ,p_argument => 'global_id'
310: ,p_argument_value => p_global_id
311: );
312: --
313: hr_api.mandatory_arg_error(p_api_name => l_proc
314: ,p_argument => 'object_version_number'
315: ,p_argument_value => p_object_version_number
316: );
317: --
316: );
317: --
318: -- Check to ensure the datetrack mode is not INSERT.
319: --
320: If (p_datetrack_mode <> hr_api.g_insert) then
321: --
322: -- We must select and lock the current row.
323: --
324: Open C_Sel1;
373: --
374: -- We need to trap the ORA LOCK exception
375: --
376: Exception
377: When HR_Api.Object_Locked then
378: --
379: -- The object is locked therefore we need to supply a meaningful
380: -- error message.
381: --