210: hr_utility.set_location('Entering:'||l_proc, 5);
211: --
212: -- Ensure that all the mandatory arguments are not null
213: --
214: hr_api.mandatory_arg_error(p_api_name => l_proc
215: ,p_argument => 'effective_date'
216: ,p_argument_value => p_effective_date
217: );
218: --
215: ,p_argument => 'effective_date'
216: ,p_argument_value => p_effective_date
217: );
218: --
219: hr_api.mandatory_arg_error(p_api_name => l_proc
220: ,p_argument => 'datetrack_mode'
221: ,p_argument_value => p_datetrack_mode
222: );
223: --
220: ,p_argument => 'datetrack_mode'
221: ,p_argument_value => p_datetrack_mode
222: );
223: --
224: hr_api.mandatory_arg_error(p_api_name => l_proc
225: ,p_argument => 'condition_id'
226: ,p_argument_value => p_condition_id
227: );
228: --
225: ,p_argument => 'condition_id'
226: ,p_argument_value => p_condition_id
227: );
228: --
229: hr_api.mandatory_arg_error(p_api_name => l_proc
230: ,p_argument => 'object_version_number'
231: ,p_argument_value => p_object_version_number
232: );
233: --
232: );
233: --
234: -- Check to ensure the datetrack mode is not INSERT.
235: --
236: If (p_datetrack_mode <> hr_api.g_insert) then
237: --
238: -- We must select and lock the current row.
239: --
240: Open C_Sel1;
269: End If;
270: --
271: -- Set the validation start and end date OUT arguments
272: --
273: if (p_datetrack_mode = hr_api.g_update) then
274: p_validation_start_date := p_effective_date;
275: p_validation_end_date := ame_con_shd.g_old_rec.end_date;
276: elsif (p_datetrack_mode = hr_api.g_delete) then
277: p_validation_start_date := p_effective_date;
272: --
273: if (p_datetrack_mode = hr_api.g_update) then
274: p_validation_start_date := p_effective_date;
275: p_validation_end_date := ame_con_shd.g_old_rec.end_date;
276: elsif (p_datetrack_mode = hr_api.g_delete) then
277: p_validation_start_date := p_effective_date;
278: p_validation_end_date := p_effective_date;
279: end if;
280: --
282: --
283: -- We need to trap the ORA LOCK exception
284: --
285: Exception
286: When HR_Api.Object_Locked then
287: --
288: -- The object is locked therefore we need to supply a meaningful
289: -- error message.
290: --