431: hr_utility.set_location('Entering:'||l_proc, 5);
432: --
433: -- Ensure that all the mandatory arguments are not null
434: --
435: hr_api.mandatory_arg_error(p_api_name => l_proc
436: ,p_argument => 'effective_date'
437: ,p_argument_value => p_effective_date
438: );
439: --
436: ,p_argument => 'effective_date'
437: ,p_argument_value => p_effective_date
438: );
439: --
440: hr_api.mandatory_arg_error(p_api_name => l_proc
441: ,p_argument => 'datetrack_mode'
442: ,p_argument_value => p_datetrack_mode
443: );
444: --
441: ,p_argument => 'datetrack_mode'
442: ,p_argument_value => p_datetrack_mode
443: );
444: --
445: hr_api.mandatory_arg_error(p_api_name => l_proc
446: ,p_argument => 'assignment_acco_id'
447: ,p_argument_value => p_assignment_acco_id
448: );
449: --
446: ,p_argument => 'assignment_acco_id'
447: ,p_argument_value => p_assignment_acco_id
448: );
449: --
450: hr_api.mandatory_arg_error(p_api_name => l_proc
451: ,p_argument => 'object_version_number'
452: ,p_argument_value => p_object_version_number
453: );
454: --
453: );
454: --
455: -- Check to ensure the datetrack mode is not INSERT.
456: --
457: If (p_datetrack_mode <> hr_api.g_insert) then
458: --
459: -- We must select and lock the current row.
460: --
461: Open C_Sel1;
513: --
514: -- We need to trap the ORA LOCK exception
515: --
516: Exception
517: When HR_Api.Object_Locked then
518: --
519: -- The object is locked therefore we need to supply a meaningful
520: -- error message.
521: --