184: exception
185: when app_exception.application_exception then
186: if hr_multi_message.exception_add
187: (p_associated_column1 => 'ACTION_TYPE_ID') then
188: hr_utility.set_location(' Leaving:'|| l_proc, 50);
189: raise;
190: end if;
191: hr_utility.set_location(' Leaving:'|| l_proc, 60);
192: end chk_action_type_id;
187: (p_associated_column1 => 'ACTION_TYPE_ID') then
188: hr_utility.set_location(' Leaving:'|| l_proc, 50);
189: raise;
190: end if;
191: hr_utility.set_location(' Leaving:'|| l_proc, 60);
192: end chk_action_type_id;
193: --
194: -- ---------------------------------------------------------------------------
195: -- |----------------------< chk_positive_integer >----------------------|
388: exception
389: when app_exception.application_exception then
390: if hr_multi_message.exception_add
391: (p_associated_column1 => 'PARAMETER') then
392: hr_utility.set_location(' Leaving:'|| l_proc, 50);
393: raise;
394: end if;
395: hr_utility.set_location(' Leaving:'|| l_proc, 60);
396: end chk_parameter;
391: (p_associated_column1 => 'PARAMETER') then
392: hr_utility.set_location(' Leaving:'|| l_proc, 50);
393: raise;
394: end if;
395: hr_utility.set_location(' Leaving:'|| l_proc, 60);
396: end chk_parameter;
397: --
398: -- ---------------------------------------------------------------------------
399: -- |----------------------< chk_at_dyn_desc_act_desc_comb >--|
456: exception
457: when app_exception.application_exception then
458: if hr_multi_message.exception_add
459: (p_associated_column1 => 'DESCRIPTION') then
460: hr_utility.set_location(' Leaving:'|| l_proc, 50);
461: raise;
462: end if;
463: hr_utility.set_location(' Leaving:'|| l_proc, 60);
464: end chk_at_dyn_desc_act_desc_comb;
459: (p_associated_column1 => 'DESCRIPTION') then
460: hr_utility.set_location(' Leaving:'|| l_proc, 50);
461: raise;
462: end if;
463: hr_utility.set_location(' Leaving:'|| l_proc, 60);
464: end chk_at_dyn_desc_act_desc_comb;
465: --
466: --
467: -- ---------------------------------------------------------------------------
525: exception
526: when app_exception.application_exception then
527: if hr_multi_message.exception_add
528: (p_associated_column1 => 'ACTION_ID') then
529: hr_utility.set_location(' Leaving:'|| l_proc, 50);
530: raise;
531: end if;
532: hr_utility.set_location(' Leaving:'|| l_proc, 60);
533: end chk_delete;
528: (p_associated_column1 => 'ACTION_ID') then
529: hr_utility.set_location(' Leaving:'|| l_proc, 50);
530: raise;
531: end if;
532: hr_utility.set_location(' Leaving:'|| l_proc, 60);
533: end chk_delete;
534: -- ----------------------------------------------------------------------------
535: -- |--------------------------< dt_update_validate >--------------------------|
536: -- ----------------------------------------------------------------------------
723: --
724: l_proc varchar2(72) := g_package||'insert_validate';
725: --
726: Begin
727: hr_utility.set_location('Entering:'||l_proc, 5);
728: --
729: -- Validate Dependent Attributes
730: chk_at_dyn_desc_act_desc_comb(p_effective_date => p_effective_date,
731: p_action_type_id => p_rec.action_type_id,
737: chk_parameter(p_effective_date => p_effective_date,
738: p_parameter => p_rec.parameter,
739: p_parameter_two => p_rec.parameter_two,
740: p_action_type_id => p_rec.action_type_id);
741: hr_utility.set_location(' Leaving:'||l_proc, 10);
742: End insert_validate;
743: --
744: -- ----------------------------------------------------------------------------
745: -- |---------------------------< update_validate >----------------------------|
754: --
755: l_proc varchar2(72) := g_package||'update_validate';
756: --
757: Begin
758: hr_utility.set_location('Entering:'||l_proc, 5);
759: --
760: -- Validate Dependent Attributes
761: --
762: -- Call the datetrack update integrity operation
782: -- chk_at_dyn_desc_act_desc_comb
783: chk_at_dyn_desc_act_desc_comb(p_action_type_id => p_rec.action_type_id,
784: p_effective_date => p_effective_date,
785: p_description => p_rec.description);
786: hr_utility.set_location(' Leaving:'||l_proc, 10);
787: End update_validate;
788: --
789: -- ----------------------------------------------------------------------------
790: -- |---------------------------< delete_validate >----------------------------|
799: --
800: l_proc varchar2(72) := g_package||'delete_validate';
801: --
802: Begin
803: hr_utility.set_location('Entering:'||l_proc, 5);
804: --
805: -- Call all supporting business operations
806: chk_delete(p_action_id => p_rec.action_id,
807: p_object_version_number => p_rec.object_version_number,
814: ,p_action_id => p_rec.action_id
815: ,p_action_type_id => p_rec.action_type_id
816: );
817: --
818: hr_utility.set_location(' Leaving:'||l_proc, 10);
819: End delete_validate;
820: --
821: end ame_act_bus;