401: hr_utility.set_location('Entering:'||l_proc, 5);
402: --
403: -- Ensure that all the mandatory arguments are not null
404: --
405: hr_api.mandatory_arg_error(p_api_name => l_proc
406: ,p_argument => 'effective_date'
407: ,p_argument_value => p_effective_date
408: );
409: --
406: ,p_argument => 'effective_date'
407: ,p_argument_value => p_effective_date
408: );
409: --
410: hr_api.mandatory_arg_error(p_api_name => l_proc
411: ,p_argument => 'datetrack_mode'
412: ,p_argument_value => p_datetrack_mode
413: );
414: --
411: ,p_argument => 'datetrack_mode'
412: ,p_argument_value => p_datetrack_mode
413: );
414: --
415: hr_api.mandatory_arg_error(p_api_name => l_proc
416: ,p_argument => 'prtt_rmt_aprvd_fr_pymt_id'
417: ,p_argument_value => p_prtt_rmt_aprvd_fr_pymt_id
418: );
419: --
416: ,p_argument => 'prtt_rmt_aprvd_fr_pymt_id'
417: ,p_argument_value => p_prtt_rmt_aprvd_fr_pymt_id
418: );
419: --
420: hr_api.mandatory_arg_error(p_api_name => l_proc
421: ,p_argument => 'object_version_number'
422: ,p_argument_value => p_object_version_number
423: );
424: --
423: );
424: --
425: -- Check to ensure the datetrack mode is not INSERT.
426: --
427: If (p_datetrack_mode <> hr_api.g_insert) then
428: --
429: -- We must select and lock the current row.
430: --
431: Open C_Sel1;
483: --
484: -- We need to trap the ORA LOCK exception
485: --
486: Exception
487: When HR_Api.Object_Locked then
488: --
489: -- The object is locked therefore we need to supply a meaningful
490: -- error message.
491: --