359: hr_utility.set_location('Entering:'||l_proc, 5);
360: --
361: -- Ensure that all the mandatory arguments are not null
362: --
363: hr_api.mandatory_arg_error(p_api_name => l_proc
364: ,p_argument => 'effective_date'
365: ,p_argument_value => p_effective_date
366: );
367: --
364: ,p_argument => 'effective_date'
365: ,p_argument_value => p_effective_date
366: );
367: --
368: hr_api.mandatory_arg_error(p_api_name => l_proc
369: ,p_argument => 'datetrack_mode'
370: ,p_argument_value => p_datetrack_mode
371: );
372: --
369: ,p_argument => 'datetrack_mode'
370: ,p_argument_value => p_datetrack_mode
371: );
372: --
373: hr_api.mandatory_arg_error(p_api_name => l_proc
374: ,p_argument => 'input_value_id'
375: ,p_argument_value => p_input_value_id
376: );
377: --
374: ,p_argument => 'input_value_id'
375: ,p_argument_value => p_input_value_id
376: );
377: --
378: hr_api.mandatory_arg_error(p_api_name => l_proc
379: ,p_argument => 'object_version_number'
380: ,p_argument_value => p_object_version_number
381: );
382: --
381: );
382: --
383: -- Check to ensure the datetrack mode is not INSERT.
384: --
385: If (p_datetrack_mode <> hr_api.g_insert) then
386: --
387: -- We must select and lock the current row.
388: --
389: Open C_Sel1;
447: --
448: -- We need to trap the ORA LOCK exception
449: --
450: Exception
451: When HR_Api.Object_Locked then
452: --
453: -- The object is locked therefore we need to supply a meaningful
454: -- error message.
455: --