120: exception
121: when app_exception.application_exception then
122: if hr_multi_message.exception_add
123: (p_associated_column1 => 'ACTION_TYPE_ID') then
124: hr_utility.set_location(' Leaving:'|| l_proc, 50);
125: raise;
126: end if;
127: hr_utility.set_location(' Leaving:'|| l_proc, 60);
128: end chk_action_type_id;
123: (p_associated_column1 => 'ACTION_TYPE_ID') then
124: hr_utility.set_location(' Leaving:'|| l_proc, 50);
125: raise;
126: end if;
127: hr_utility.set_location(' Leaving:'|| l_proc, 60);
128: end chk_action_type_id;
129: --
130: -- ---------------------------------------------------------------------------
131: -- |----------------------
186: exception
187: when app_exception.application_exception then
188: if hr_multi_message.exception_add
189: (p_associated_column1 => 'APPLICATION_ID') then
190: hr_utility.set_location(' Leaving:'|| l_proc, 50);
191: raise;
192: end if;
193: hr_utility.set_location(' Leaving:'|| l_proc, 60);
194: end chk_application_id;
189: (p_associated_column1 => 'APPLICATION_ID') then
190: hr_utility.set_location(' Leaving:'|| l_proc, 50);
191: raise;
192: end if;
193: hr_utility.set_location(' Leaving:'|| l_proc, 60);
194: end chk_application_id;
195: --
196: -- ---------------------------------------------------------------------------
197: -- |----------------------< chk_unique >-------------------------------|
246: exception
247: when app_exception.application_exception then
248: if hr_multi_message.exception_add
249: (p_associated_column1 => 'APPLICATION_ID') then
250: hr_utility.set_location(' Leaving:'|| l_proc, 50);
251: raise;
252: end if;
253: hr_utility.set_location(' Leaving:'|| l_proc, 60);
254: END chk_unique;
249: (p_associated_column1 => 'APPLICATION_ID') then
250: hr_utility.set_location(' Leaving:'|| l_proc, 50);
251: raise;
252: end if;
253: hr_utility.set_location(' Leaving:'|| l_proc, 60);
254: END chk_unique;
255: --
256: -- ---------------------------------------------------------------------------
257: -- |----------------------< chk_voting_regime>-------------------------------|
314: exception
315: when app_exception.application_exception then
316: if hr_multi_message.exception_add
317: (p_associated_column1 => 'VOTING_REGIME') then
318: hr_utility.set_location(' Leaving:'|| l_proc, 50);
319: raise;
320: end if;
321: hr_utility.set_location(' Leaving:'|| l_proc, 60);
322: end chk_voting_regime;
317: (p_associated_column1 => 'VOTING_REGIME') then
318: hr_utility.set_location(' Leaving:'|| l_proc, 50);
319: raise;
320: end if;
321: hr_utility.set_location(' Leaving:'|| l_proc, 60);
322: end chk_voting_regime;
323: --
324: -- ---------------------------------------------------------------------------
325: -- |----------------------< chk_chain_ordering_mode>--------------------------|
380: exception
381: when app_exception.application_exception then
382: if hr_multi_message.exception_add
383: (p_associated_column1 => 'CHAIN_ORDERING_MODE') then
384: hr_utility.set_location(' Leaving:'|| l_proc, 50);
385: raise;
386: end if;
387: hr_utility.set_location(' Leaving:'|| l_proc, 60);
388: end chk_chain_ordering_mode;
383: (p_associated_column1 => 'CHAIN_ORDERING_MODE') then
384: hr_utility.set_location(' Leaving:'|| l_proc, 50);
385: raise;
386: end if;
387: hr_utility.set_location(' Leaving:'|| l_proc, 60);
388: end chk_chain_ordering_mode;
389: --
390: -- ---------------------------------------------------------------------------
391: -- |----------------------< chk_order_number>-------------------------------|
450: exception
451: when app_exception.application_exception then
452: if hr_multi_message.exception_add
453: (p_associated_column1 => 'ORDER_NUMBER') then
454: hr_utility.set_location(' Leaving:'|| l_proc, 50);
455: raise;
456: end if;
457: hr_utility.set_location(' Leaving:'|| l_proc, 60);
458: end chk_order_number;
453: (p_associated_column1 => 'ORDER_NUMBER') then
454: hr_utility.set_location(' Leaving:'|| l_proc, 50);
455: raise;
456: end if;
457: hr_utility.set_location(' Leaving:'|| l_proc, 60);
458: end chk_order_number;
459:
460: --
461: --
541: exception
542: when app_exception.application_exception then
543: if hr_multi_message.exception_add
544: (p_associated_column1 => 'ACTION_TYPE_ID') then
545: hr_utility.set_location(' Leaving:'|| l_proc, 50);
546: raise;
547: end if;
548: hr_utility.set_location(' Leaving:'|| l_proc, 60);
549: end chk_delete;
544: (p_associated_column1 => 'ACTION_TYPE_ID') then
545: hr_utility.set_location(' Leaving:'|| l_proc, 50);
546: raise;
547: end if;
548: hr_utility.set_location(' Leaving:'|| l_proc, 60);
549: end chk_delete;
550: -- ----------------------------------------------------------------------------
551: -- |--------------------------< dt_update_validate >--------------------------|
552: -- ----------------------------------------------------------------------------
734: --
735: l_proc varchar2(72) := g_package||'insert_validate';
736: --
737: Begin
738: hr_utility.set_location('Entering:'||l_proc, 5);
739: --
740: -- Call all supporting business operations
741: -- Application Id
742: chk_application_id(p_effective_date => p_effective_date,
760: */
761: -- Validate Dependent Attributes
762: --
763: --
764: hr_utility.set_location(' Leaving:'||l_proc, 10);
765: End insert_validate;
766: --
767: -- ----------------------------------------------------------------------------
768: -- |---------------------------< update_validate >----------------------------|
777: --
778: l_proc varchar2(72) := g_package||'update_validate';
779: --
780: Begin
781: hr_utility.set_location('Entering:'||l_proc, 5);
782: --
783: -- Validate Dependent Attributes
784: --
785: -- Call the datetrack update integrity operation
805: chk_order_number(p_effective_date => p_effective_date,
806: p_application_id => p_rec.application_id,
807: p_order_number => p_rec.order_number);
808: --
809: hr_utility.set_location(' Leaving:'||l_proc, 10);
810: End update_validate;
811: --
812: -- ----------------------------------------------------------------------------
813: -- |---------------------------< delete_validate >----------------------------|
822: --
823: l_proc varchar2(72) := g_package||'delete_validate';
824: --
825: Begin
826: hr_utility.set_location('Entering:'||l_proc, 5);
827: --
828: chk_delete(p_action_type_id => p_rec.action_type_id
829: ,p_application_id => p_rec.application_id);
830: -- Call all supporting business operations
836: ,p_action_type_id => p_rec.action_type_id
837: ,p_application_id => p_rec.application_id
838: );
839: --
840: hr_utility.set_location(' Leaving:'||l_proc, 10);
841: End delete_validate;
842: --
843: end ame_acf_bus;