214: hr_utility.set_location('Entering:'||l_proc, 5);
215: --
216: -- Ensure that all the mandatory arguments are not null
217: --
218: hr_api.mandatory_arg_error(p_api_name => l_proc
219: ,p_argument => 'effective_date'
220: ,p_argument_value => p_effective_date
221: );
222: --
219: ,p_argument => 'effective_date'
220: ,p_argument_value => p_effective_date
221: );
222: --
223: hr_api.mandatory_arg_error(p_api_name => l_proc
224: ,p_argument => 'datetrack_mode'
225: ,p_argument_value => p_datetrack_mode
226: );
227: --
224: ,p_argument => 'datetrack_mode'
225: ,p_argument_value => p_datetrack_mode
226: );
227: --
228: hr_api.mandatory_arg_error(p_api_name => l_proc
229: ,p_argument => 'condition_id'
230: ,p_argument_value => p_condition_id
231: );
232: --
229: ,p_argument => 'condition_id'
230: ,p_argument_value => p_condition_id
231: );
232: --
233: hr_api.mandatory_arg_error(p_api_name => l_proc
234: ,p_argument => 'object_version_number'
235: ,p_argument_value => p_object_version_number
236: );
237: --
236: );
237: --
238: -- Check to ensure the datetrack mode is not INSERT.
239: --
240: If (p_datetrack_mode <> hr_api.g_insert) then
241: --
242: -- We must select and lock the current row.
243: --
244: Open C_Sel1;
273: End If;
274: --
275: -- Set the validation start and end date OUT arguments
276: --
277: if (p_datetrack_mode = hr_api.g_update) then
278: p_validation_start_date := p_effective_date;
279: p_validation_end_date := ame_cnu_shd.g_old_rec.end_date;
280: elsif (p_datetrack_mode = hr_api.g_delete) then
281: p_validation_start_date := p_effective_date;
276: --
277: if (p_datetrack_mode = hr_api.g_update) then
278: p_validation_start_date := p_effective_date;
279: p_validation_end_date := ame_cnu_shd.g_old_rec.end_date;
280: elsif (p_datetrack_mode = hr_api.g_delete) then
281: p_validation_start_date := p_effective_date;
282: p_validation_end_date := p_effective_date;
283: end if;
284: --
311: fnd_message.set_token('STEP','40');
312: fnd_message.raise_error;
313: end;
314: Exception
315: When HR_Api.Object_Locked then
316: --
317: -- The object is locked therefore we need to supply a meaningful
318: -- error message.
319: --