44: l_key varchar2(1);
45: --
46: Begin
47: hr_utility.set_location('Entering:'||l_proc,10);
48: hr_api.mandatory_arg_error(p_api_name => l_proc
49: ,p_argument => 'FND_APPLICATION_ID'
50: ,p_argument_value => p_fnd_application_id
51: );
52: open csr_fnd_application_id;
113: l_key varchar2(1);
114: --
115: Begin
116: hr_utility.set_location('Entering:'||l_proc,10);
117: hr_api.mandatory_arg_error(p_api_name => l_proc
118: ,p_argument => 'APPLICATION_NAME'
119: ,p_argument_value => p_application_name
120: );
121: open csr_application_name;
362: -- not been updated.
363: --
364: -- FND_APPLICATION_ID is non-updateable
365: --
366: if nvl(p_rec.fnd_application_id, hr_api.g_number) <>
367: nvl(ame_aca_shd.g_old_rec.fnd_application_id,hr_api.g_number) then
368: hr_api.argument_changed_error
369: (p_api_name => l_proc
370: ,p_argument => 'FND_APPLICATION_ID'
363: --
364: -- FND_APPLICATION_ID is non-updateable
365: --
366: if nvl(p_rec.fnd_application_id, hr_api.g_number) <>
367: nvl(ame_aca_shd.g_old_rec.fnd_application_id,hr_api.g_number) then
368: hr_api.argument_changed_error
369: (p_api_name => l_proc
370: ,p_argument => 'FND_APPLICATION_ID'
371: ,p_base_table => ame_aca_shd.g_tab_nam
364: -- FND_APPLICATION_ID is non-updateable
365: --
366: if nvl(p_rec.fnd_application_id, hr_api.g_number) <>
367: nvl(ame_aca_shd.g_old_rec.fnd_application_id,hr_api.g_number) then
368: hr_api.argument_changed_error
369: (p_api_name => l_proc
370: ,p_argument => 'FND_APPLICATION_ID'
371: ,p_base_table => ame_aca_shd.g_tab_nam
372: );
373: end if;
374: --
375: -- APPLICATION_ID is non-updateable
376: --
377: if nvl(p_rec.application_id, hr_api.g_number) <>
378: nvl(ame_aca_shd.g_old_rec.application_id,hr_api.g_number) then
379: hr_api.argument_changed_error
380: (p_api_name => l_proc
381: ,p_argument => 'APPLICATION_ID'
374: --
375: -- APPLICATION_ID is non-updateable
376: --
377: if nvl(p_rec.application_id, hr_api.g_number) <>
378: nvl(ame_aca_shd.g_old_rec.application_id,hr_api.g_number) then
379: hr_api.argument_changed_error
380: (p_api_name => l_proc
381: ,p_argument => 'APPLICATION_ID'
382: ,p_base_table => ame_aca_shd.g_tab_nam
375: -- APPLICATION_ID is non-updateable
376: --
377: if nvl(p_rec.application_id, hr_api.g_number) <>
378: nvl(ame_aca_shd.g_old_rec.application_id,hr_api.g_number) then
379: hr_api.argument_changed_error
380: (p_api_name => l_proc
381: ,p_argument => 'APPLICATION_ID'
382: ,p_base_table => ame_aca_shd.g_tab_nam
383: );
385: --
386: --
387: -- TRANSACTION_TYPE_ID is non-updateable
388: --
389: if nvl(p_rec.transaction_type_id, hr_api.g_varchar2) <>
390: nvl(ame_aca_shd.g_old_rec.transaction_type_id,hr_api.g_varchar2) then
391: hr_api.argument_changed_error
392: (p_api_name => l_proc
393: ,p_argument => 'TRANSACTION_TYPE_ID'
386: --
387: -- TRANSACTION_TYPE_ID is non-updateable
388: --
389: if nvl(p_rec.transaction_type_id, hr_api.g_varchar2) <>
390: nvl(ame_aca_shd.g_old_rec.transaction_type_id,hr_api.g_varchar2) then
391: hr_api.argument_changed_error
392: (p_api_name => l_proc
393: ,p_argument => 'TRANSACTION_TYPE_ID'
394: ,p_base_table => ame_aca_shd.g_tab_nam
387: -- TRANSACTION_TYPE_ID is non-updateable
388: --
389: if nvl(p_rec.transaction_type_id, hr_api.g_varchar2) <>
390: nvl(ame_aca_shd.g_old_rec.transaction_type_id,hr_api.g_varchar2) then
391: hr_api.argument_changed_error
392: (p_api_name => l_proc
393: ,p_argument => 'TRANSACTION_TYPE_ID'
394: ,p_base_table => ame_aca_shd.g_tab_nam
395: );
436: Begin
437: --
438: -- Ensure that the p_datetrack_mode argument is not null
439: --
440: hr_api.mandatory_arg_error
441: (p_api_name => l_proc
442: ,p_argument => 'datetrack_mode'
443: ,p_argument_value => p_datetrack_mode
444: );
446: -- Mode will be valid, as this is checked at the start of the upd.
447: --
448: -- Ensure the arguments are not null
449: --
450: hr_api.mandatory_arg_error
451: (p_api_name => l_proc
452: ,p_argument => 'validation_start_date'
453: ,p_argument_value => p_validation_start_date
454: );
452: ,p_argument => 'validation_start_date'
453: ,p_argument_value => p_validation_start_date
454: );
455: --
456: /*hr_api.mandatory_arg_error
457: (p_api_name => l_proc
458: ,p_argument => 'validation_end_date'
459: ,p_argument_value => p_validation_end_date
460: );*/
518: Begin
519: --
520: -- Ensure that the p_datetrack_mode argument is not null
521: --
522: hr_api.mandatory_arg_error
523: (p_api_name => l_proc
524: ,p_argument => 'datetrack_mode'
525: ,p_argument_value => p_datetrack_mode
526: );
527: --
528: -- Only perform the validation if the datetrack mode is either
529: -- DELETE or ZAP
530: --
531: If (p_datetrack_mode = hr_api.g_delete or
532: p_datetrack_mode = hr_api.g_zap) then
533: --
534: --
535: -- Ensure the arguments are not null
528: -- Only perform the validation if the datetrack mode is either
529: -- DELETE or ZAP
530: --
531: If (p_datetrack_mode = hr_api.g_delete or
532: p_datetrack_mode = hr_api.g_zap) then
533: --
534: --
535: -- Ensure the arguments are not null
536: --
533: --
534: --
535: -- Ensure the arguments are not null
536: --
537: hr_api.mandatory_arg_error
538: (p_api_name => l_proc
539: ,p_argument => 'validation_start_date'
540: ,p_argument_value => p_validation_start_date
541: );
539: ,p_argument => 'validation_start_date'
540: ,p_argument_value => p_validation_start_date
541: );
542: --
543: /*hr_api.mandatory_arg_error
544: (p_api_name => l_proc
545: ,p_argument => 'validation_end_date'
546: ,p_argument_value => p_validation_end_date
547: );*/
545: ,p_argument => 'validation_end_date'
546: ,p_argument_value => p_validation_end_date
547: );*/
548: --
549: hr_api.mandatory_arg_error
550: (p_api_name => l_proc
551: ,p_argument => 'application_id'
552: ,p_argument_value => p_application_id
553: );
638: );
639: --
640: -- Check for application name when there has been a change in its value.
641: --
642: if nvl(p_rec.application_name, hr_api.g_varchar2) <>
643: nvl(ame_aca_shd.g_old_rec.application_name,hr_api.g_varchar2) then
644: chk_application_name(p_application_name => p_rec.application_name
645: ,p_effective_date => p_effective_date
646: );
639: --
640: -- Check for application name when there has been a change in its value.
641: --
642: if nvl(p_rec.application_name, hr_api.g_varchar2) <>
643: nvl(ame_aca_shd.g_old_rec.application_name,hr_api.g_varchar2) then
644: chk_application_name(p_application_name => p_rec.application_name
645: ,p_effective_date => p_effective_date
646: );
647: end if;