270: hr_utility.set_location('Entering:'||l_proc, 5);
271: --
272: -- Ensure that all the mandatory arguments are not null
273: --
274: hr_api.mandatory_arg_error(p_api_name => l_proc
275: ,p_argument => 'effective_date'
276: ,p_argument_value => p_effective_date
277: );
278: --
275: ,p_argument => 'effective_date'
276: ,p_argument_value => p_effective_date
277: );
278: --
279: hr_api.mandatory_arg_error(p_api_name => l_proc
280: ,p_argument => 'datetrack_mode'
281: ,p_argument_value => p_datetrack_mode
282: );
283: --
280: ,p_argument => 'datetrack_mode'
281: ,p_argument_value => p_datetrack_mode
282: );
283: --
284: hr_api.mandatory_arg_error(p_api_name => l_proc
285: ,p_argument => 'pay_gl_account_id'
286: ,p_argument_value => p_pay_gl_account_id
287: );
288: --
285: ,p_argument => 'pay_gl_account_id'
286: ,p_argument_value => p_pay_gl_account_id
287: );
288: --
289: hr_api.mandatory_arg_error(p_api_name => l_proc
290: ,p_argument => 'object_version_number'
291: ,p_argument_value => p_object_version_number
292: );
293: --
292: );
293: --
294: -- Check to ensure the datetrack mode is not INSERT.
295: --
296: If (p_datetrack_mode <> hr_api.g_insert) then
297: --
298: -- We must select and lock the current row.
299: --
300: Open C_Sel1;
369: --
370: -- We need to trap the ORA LOCK exception
371: --
372: Exception
373: When HR_Api.Object_Locked then
374: --
375: -- The object is locked therefore we need to supply a meaningful
376: -- error message.
377: --