351: hr_utility.set_location('Entering:'||l_proc, 5);
352: --
353: -- Ensure that all the mandatory arguments are not null
354: --
355: hr_api.mandatory_arg_error(p_api_name => l_proc
356: ,p_argument => 'effective_date'
357: ,p_argument_value => p_effective_date
358: );
359: --
356: ,p_argument => 'effective_date'
357: ,p_argument_value => p_effective_date
358: );
359: --
360: hr_api.mandatory_arg_error(p_api_name => l_proc
361: ,p_argument => 'datetrack_mode'
362: ,p_argument_value => p_datetrack_mode
363: );
364: --
361: ,p_argument => 'datetrack_mode'
362: ,p_argument_value => p_datetrack_mode
363: );
364: --
365: hr_api.mandatory_arg_error(p_api_name => l_proc
366: ,p_argument => 'job_rt_id'
367: ,p_argument_value => p_job_rt_id
368: );
369: --
366: ,p_argument => 'job_rt_id'
367: ,p_argument_value => p_job_rt_id
368: );
369: --
370: hr_api.mandatory_arg_error(p_api_name => l_proc
371: ,p_argument => 'object_version_number'
372: ,p_argument_value => p_object_version_number
373: );
374: --
373: );
374: --
375: -- Check to ensure the datetrack mode is not INSERT.
376: --
377: If (p_datetrack_mode <> hr_api.g_insert) then
378: --
379: -- We must select and lock the current row.
380: --
381: Open C_Sel1;
433: --
434: -- We need to trap the ORA LOCK exception
435: --
436: Exception
437: When HR_Api.Object_Locked then
438: --
439: -- The object is locked therefore we need to supply a meaningful
440: -- error message.
441: --