303: hr_utility.set_location('Entering:'||l_proc, 5);
304: --
305: -- Ensure that all the mandatory arguments are not null
306: --
307: hr_api.mandatory_arg_error(p_api_name => l_proc
308: ,p_argument => 'effective_date'
309: ,p_argument_value => p_effective_date
310: );
311: --
308: ,p_argument => 'effective_date'
309: ,p_argument_value => p_effective_date
310: );
311: --
312: hr_api.mandatory_arg_error(p_api_name => l_proc
313: ,p_argument => 'datetrack_mode'
314: ,p_argument_value => p_datetrack_mode
315: );
316: --
313: ,p_argument => 'datetrack_mode'
314: ,p_argument_value => p_datetrack_mode
315: );
316: --
317: hr_api.mandatory_arg_error(p_api_name => l_proc
318: ,p_argument => 'run_type_org_method_id'
319: ,p_argument_value => p_run_type_org_method_id
320: );
321: --
318: ,p_argument => 'run_type_org_method_id'
319: ,p_argument_value => p_run_type_org_method_id
320: );
321: --
322: hr_api.mandatory_arg_error(p_api_name => l_proc
323: ,p_argument => 'object_version_number'
324: ,p_argument_value => p_object_version_number
325: );
326: --
325: );
326: --
327: -- Check to ensure the datetrack mode is not INSERT.
328: --
329: If (p_datetrack_mode <> hr_api.g_insert) then
330: --
331: -- We must select and lock the current row.
332: --
333: Open C_Sel1;
388: --
389: -- We need to trap the ORA LOCK exception
390: --
391: Exception
392: When HR_Api.Object_Locked then
393: --
394: -- The object is locked therefore we need to supply a meaningful
395: -- error message.
396: --