119: exception
120: when app_exception.application_exception then
121: if hr_multi_message.exception_add
122: (p_associated_column1 => 'ACTION_TYPE_ID') then
123: hr_utility.set_location(' Leaving:'|| l_proc, 50);
124: raise;
125: end if;
126: hr_utility.set_location(' Leaving:'|| l_proc, 60);
127: end chk_action_type_id;
122: (p_associated_column1 => 'ACTION_TYPE_ID') then
123: hr_utility.set_location(' Leaving:'|| l_proc, 50);
124: raise;
125: end if;
126: hr_utility.set_location(' Leaving:'|| l_proc, 60);
127: end chk_action_type_id;
128: --
129: --
130: -- ---------------------------------------------------------------------------
203: exception
204: when app_exception.application_exception then
205: if hr_multi_message.exception_add
206: (p_associated_column1 => 'APPROVER_TYPE_ID') then
207: hr_utility.set_location(' Leaving:'|| l_proc, 50);
208: raise;
209: end if;
210: hr_utility.set_location(' Leaving:'|| l_proc, 60);
211: end chk_approver_type_id;
206: (p_associated_column1 => 'APPROVER_TYPE_ID') then
207: hr_utility.set_location(' Leaving:'|| l_proc, 50);
208: raise;
209: end if;
210: hr_utility.set_location(' Leaving:'|| l_proc, 60);
211: end chk_approver_type_id;
212: --
213: -- ---------------------------------------------------------------------------
214: -- |----------------------< chk_delete >--------------------------|
264: exception
265: when app_exception.application_exception then
266: if hr_multi_message.exception_add
267: (p_associated_column1 => 'ACTION_TYPE_ID') then
268: hr_utility.set_location(' Leaving:'|| l_proc, 50);
269: raise;
270: end if;
271: hr_utility.set_location(' Leaving:'|| l_proc, 60);
272: end chk_delete;
267: (p_associated_column1 => 'ACTION_TYPE_ID') then
268: hr_utility.set_location(' Leaving:'|| l_proc, 50);
269: raise;
270: end if;
271: hr_utility.set_location(' Leaving:'|| l_proc, 60);
272: end chk_delete;
273: -- ----------------------------------------------------------------------------
274: -- |--------------------------< dt_update_validate >--------------------------|
275: -- ----------------------------------------------------------------------------
457: --
458: l_proc varchar2(72) := g_package||'insert_validate';
459: --
460: Begin
461: hr_utility.set_location('Entering:'||l_proc, 5);
462: --
463: -- Validate Dependent Attributes
464: -- Action Type Id
465: chk_action_type_id(p_effective_date => p_effective_date,
469: chk_approver_type_id(p_effective_date => p_effective_date,
470: p_approver_type_id => p_rec.approver_type_id,
471: p_action_type_id => p_rec.action_type_id);
472: --
473: hr_utility.set_location(' Leaving:'||l_proc, 10);
474: End insert_validate;
475: --
476: -- ----------------------------------------------------------------------------
477: -- |---------------------------< update_validate >----------------------------|
486: --
487: l_proc varchar2(72) := g_package||'update_validate';
488: --
489: Begin
490: hr_utility.set_location('Entering:'||l_proc, 5);
491: --
492: -- Validate Dependent Attributes
493: --
494: -- Call the datetrack update integrity operation
504: ,p_rec => p_rec
505: );
506: --
507: --
508: hr_utility.set_location(' Leaving:'||l_proc, 10);
509: End update_validate;
510: --
511: -- ----------------------------------------------------------------------------
512: -- |---------------------------< delete_validate >----------------------------|
521: --
522: l_proc varchar2(72) := g_package||'delete_validate';
523: --
524: Begin
525: hr_utility.set_location('Entering:'||l_proc, 5);
526: --
527: chk_delete(p_action_type_id => p_rec.action_type_id);
528: -- Call all supporting business operations
529: --
534: ,p_approver_type_id => p_rec.approver_type_id
535: ,p_action_type_id => p_rec.action_type_id
536: );
537: --
538: hr_utility.set_location(' Leaving:'||l_proc, 10);
539: End delete_validate;
540: --
541: end ame_apu_bus;