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