316: hr_utility.set_location('Entering:'||l_proc, 5);
317: --
318: -- Ensure that all the mandatory arguments are not null
319: --
320: hr_api.mandatory_arg_error(p_api_name => l_proc
321: ,p_argument => 'effective_date'
322: ,p_argument_value => p_effective_date
323: );
324: --
321: ,p_argument => 'effective_date'
322: ,p_argument_value => p_effective_date
323: );
324: --
325: hr_api.mandatory_arg_error(p_api_name => l_proc
326: ,p_argument => 'datetrack_mode'
327: ,p_argument_value => p_datetrack_mode
328: );
329: --
326: ,p_argument => 'datetrack_mode'
327: ,p_argument_value => p_datetrack_mode
328: );
329: --
330: hr_api.mandatory_arg_error(p_api_name => l_proc
331: ,p_argument => 'sii_details_id'
332: ,p_argument_value => p_sii_details_id
333: );
334: --
331: ,p_argument => 'sii_details_id'
332: ,p_argument_value => p_sii_details_id
333: );
334: --
335: hr_api.mandatory_arg_error(p_api_name => l_proc
336: ,p_argument => 'object_version_number'
337: ,p_argument_value => p_object_version_number
338: );
339: --
338: );
339: --
340: -- Check to ensure the datetrack mode is not INSERT.
341: --
342: If (p_datetrack_mode <> hr_api.g_insert) then
343: --
344: -- We must select and lock the current row.
345: --
346: Open C_Sel1;
430: --
431: -- We need to trap the ORA LOCK exception
432: --
433: Exception
434: When HR_Api.Object_Locked then
435: --
436: -- The object is locked therefore we need to supply a meaningful
437: -- error message.
438: --