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: -- ---------------------------------------------------------------------------
184: exception
185: when app_exception.application_exception then
186: if hr_multi_message.exception_add
187: (p_associated_column1 => 'ATTRIBUTE_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_attribute_id;
187: (p_associated_column1 => 'ATTRIBUTE_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_attribute_id;
193: --
194:
195: --------------------------------------------------------------------------
221: exception
222: when app_exception.application_exception then
223: if hr_multi_message.exception_add
224: (p_associated_column1 => 'ATTRIBUTE_ID') then
225: hr_utility.set_location(' Leaving:'|| l_proc, 50);
226: raise;
227: end if;
228: hr_utility.set_location(' Leaving:'|| l_proc, 60);
229:
224: (p_associated_column1 => 'ATTRIBUTE_ID') then
225: hr_utility.set_location(' Leaving:'|| l_proc, 50);
226: raise;
227: end if;
228: hr_utility.set_location(' Leaving:'|| l_proc, 60);
229:
230: end chk_man_attribute;
231: --------------------------------------------------------------------------
232: --------------------------------------------------------------------------
257: exception
258: when app_exception.application_exception then
259: if hr_multi_message.exception_add
260: (p_associated_column1 => 'ACTION_TYPE_ID') then
261: hr_utility.set_location(' Leaving:'|| l_proc, 50);
262: raise;
263: end if;
264: hr_utility.set_location(' Leaving:'|| l_proc, 60);
265:
260: (p_associated_column1 => 'ACTION_TYPE_ID') then
261: hr_utility.set_location(' Leaving:'|| l_proc, 50);
262: raise;
263: end if;
264: hr_utility.set_location(' Leaving:'|| l_proc, 60);
265:
266: end chk_seeded_action_type;
267: -------------------------------------------------------------------------
268: -- ---------------------------------------------------------------------------
319: exception
320: when app_exception.application_exception then
321: if hr_multi_message.exception_add
322: (p_associated_column1 => 'ACTION_TYPE_ID') then
323: hr_utility.set_location(' Leaving:'|| l_proc, 50);
324: raise;
325: end if;
326: hr_utility.set_location(' Leaving:'|| l_proc, 60);
327: end chk_delete;
322: (p_associated_column1 => 'ACTION_TYPE_ID') then
323: hr_utility.set_location(' Leaving:'|| l_proc, 50);
324: raise;
325: end if;
326: hr_utility.set_location(' Leaving:'|| l_proc, 60);
327: end chk_delete;
328: -- ----------------------------------------------------------------------------
329: -- |--------------------------< dt_update_validate >--------------------------|
330: -- ----------------------------------------------------------------------------
512: --
513: l_proc varchar2(72) := g_package||'insert_validate';
514: --
515: Begin
516: hr_utility.set_location('Entering:'||l_proc, 5);
517: --
518: -- Validate Dependent Attributes
519: -- Action Type Id
520: chk_action_type_id(p_effective_date => p_effective_date,
534: --But we should allow for the Ame developer responsibility
535: chk_seeded_action_type(p_effective_date => p_effective_date,
536: p_action_type_id => p_rec.action_type_id);
537: --
538: hr_utility.set_location(' Leaving:'||l_proc, 10);
539: End insert_validate;
540: --
541: -- ----------------------------------------------------------------------------
542: -- |---------------------------< update_validate >----------------------------|
551: --
552: l_proc varchar2(72) := g_package||'update_validate';
553: --
554: Begin
555: hr_utility.set_location('Entering:'||l_proc, 5);
556: --
557: -- Validate Dependent Attributes
558: --
559: -- Call the datetrack update integrity operation
569: ,p_rec => p_rec
570: );
571: --
572: --
573: hr_utility.set_location(' Leaving:'||l_proc, 10);
574: End update_validate;
575: --
576: -- ----------------------------------------------------------------------------
577: -- |---------------------------< delete_validate >----------------------------|
586: --
587: l_proc varchar2(72) := g_package||'delete_validate';
588: --
589: Begin
590: hr_utility.set_location('Entering:'||l_proc, 5);
591: --
592: -- Call all supporting business operations
593: chk_delete(p_action_type_id => p_rec.action_type_id);
594: --
599: ,p_attribute_id => p_rec.attribute_id
600: ,p_action_type_id => p_rec.action_type_id
601: );
602: --
603: hr_utility.set_location(' Leaving:'||l_proc, 10);
604: End delete_validate;
605: --
606: end ame_man_bus;