54: l_proc varchar2(72) := g_package || 'CHK_CONDITION_ID';
55: --
56: Begin
57: hr_utility.set_location('Entering:'||l_proc,10);
58: hr_api.mandatory_arg_error(p_api_name => l_proc
59: ,p_argument => 'CONDITION_ID'
60: ,p_argument_value => p_condition_id
61: );
62: -- Check for the existence of condition_id in parent table(AME_CONDITIONS)
137: fnd_message.raise_error;
138: end if;
139: -- Check if String Value is NULL
140:
141: hr_api.mandatory_arg_error(p_api_name => l_proc
142: ,p_argument => 'STRING_VALUE'
143: ,p_argument_value => p_condition_id
144: );
145: -- Check for the existence of condition_id in parent table(AME_CONDITIONS)
218: -- not been updated.
219: --
220: -- CONDITION_ID is non-updateable
221: --
222: if nvl(p_rec.condition_id, hr_api.g_number) <>
223: nvl(ame_stv_shd.g_old_rec.condition_id,hr_api.g_number) then
224: hr_api.argument_changed_error
225: (p_api_name => l_proc
226: ,p_argument => 'CONDITION_ID'
219: --
220: -- CONDITION_ID is non-updateable
221: --
222: if nvl(p_rec.condition_id, hr_api.g_number) <>
223: nvl(ame_stv_shd.g_old_rec.condition_id,hr_api.g_number) then
224: hr_api.argument_changed_error
225: (p_api_name => l_proc
226: ,p_argument => 'CONDITION_ID'
227: ,p_base_table => ame_stv_shd.g_tab_nam
220: -- CONDITION_ID is non-updateable
221: --
222: if nvl(p_rec.condition_id, hr_api.g_number) <>
223: nvl(ame_stv_shd.g_old_rec.condition_id,hr_api.g_number) then
224: hr_api.argument_changed_error
225: (p_api_name => l_proc
226: ,p_argument => 'CONDITION_ID'
227: ,p_base_table => ame_stv_shd.g_tab_nam
228: );
229: end if;
230: --
231: -- STRING_VALUE is non-updateable
232: --
233: if nvl(p_rec.string_value, hr_api.g_varchar2) <>
234: nvl(ame_stv_shd.g_old_rec.string_value,hr_api.g_varchar2) then
235: hr_api.argument_changed_error
236: (p_api_name => l_proc
237: ,p_argument => 'STRING_VALUE'
230: --
231: -- STRING_VALUE is non-updateable
232: --
233: if nvl(p_rec.string_value, hr_api.g_varchar2) <>
234: nvl(ame_stv_shd.g_old_rec.string_value,hr_api.g_varchar2) then
235: hr_api.argument_changed_error
236: (p_api_name => l_proc
237: ,p_argument => 'STRING_VALUE'
238: ,p_base_table => ame_stv_shd.g_tab_nam
231: -- STRING_VALUE is non-updateable
232: --
233: if nvl(p_rec.string_value, hr_api.g_varchar2) <>
234: nvl(ame_stv_shd.g_old_rec.string_value,hr_api.g_varchar2) then
235: hr_api.argument_changed_error
236: (p_api_name => l_proc
237: ,p_argument => 'STRING_VALUE'
238: ,p_base_table => ame_stv_shd.g_tab_nam
239: );
281: Begin
282: --
283: -- Ensure that the p_datetrack_mode argument is not null
284: --
285: hr_api.mandatory_arg_error
286: (p_api_name => l_proc
287: ,p_argument => 'datetrack_mode'
288: ,p_argument_value => p_datetrack_mode
289: );
291: -- Mode will be valid, as this is checked at the start of the upd.
292: --
293: -- Ensure the arguments are not null
294: --
295: hr_api.mandatory_arg_error
296: (p_api_name => l_proc
297: ,p_argument => 'validation_start_date'
298: ,p_argument_value => p_validation_start_date
299: );
297: ,p_argument => 'validation_start_date'
298: ,p_argument_value => p_validation_start_date
299: );
300: --
301: /*hr_api.mandatory_arg_error
302: (p_api_name => l_proc
303: ,p_argument => 'validation_end_date'
304: ,p_argument_value => p_validation_end_date
305: );*/
364: Begin
365: --
366: -- Ensure that the p_datetrack_mode argument is not null
367: --
368: hr_api.mandatory_arg_error
369: (p_api_name => l_proc
370: ,p_argument => 'datetrack_mode'
371: ,p_argument_value => p_datetrack_mode
372: );
373: --
374: -- Only perform the validation if the datetrack mode is either
375: -- DELETE or ZAP
376: --
377: If (p_datetrack_mode = hr_api.g_delete or
378: p_datetrack_mode = hr_api.g_zap) then
379: --
380: --
381: -- Ensure the arguments are not null
374: -- Only perform the validation if the datetrack mode is either
375: -- DELETE or ZAP
376: --
377: If (p_datetrack_mode = hr_api.g_delete or
378: p_datetrack_mode = hr_api.g_zap) then
379: --
380: --
381: -- Ensure the arguments are not null
382: --
379: --
380: --
381: -- Ensure the arguments are not null
382: --
383: hr_api.mandatory_arg_error
384: (p_api_name => l_proc
385: ,p_argument => 'validation_start_date'
386: ,p_argument_value => p_validation_start_date
387: );
385: ,p_argument => 'validation_start_date'
386: ,p_argument_value => p_validation_start_date
387: );
388: --
389: /*hr_api.mandatory_arg_error
390: (p_api_name => l_proc
391: ,p_argument => 'validation_end_date'
392: ,p_argument_value => p_validation_end_date
393: );*/
391: ,p_argument => 'validation_end_date'
392: ,p_argument_value => p_validation_end_date
393: );*/
394: --
395: hr_api.mandatory_arg_error
396: (p_api_name => l_proc
397: ,p_argument => 'condition_id'
398: ,p_argument_value => p_condition_id
399: );