62: exception
63: when app_exception.application_exception then
64: if hr_multi_message.exception_add
65: (p_associated_column1 => 'ACION_ID') then
66: hr_utility.set_location(' Leaving:'|| l_proc, 50);
67: raise;
68: end if;
69: hr_utility.set_location(' Leaving:'|| l_proc, 60);
70: end chk_action_id;
65: (p_associated_column1 => 'ACION_ID') then
66: hr_utility.set_location(' Leaving:'|| l_proc, 50);
67: raise;
68: end if;
69: hr_utility.set_location(' Leaving:'|| l_proc, 60);
70: end chk_action_id;
71: -- ---------------------------------------------------------------------------
72: -- |----------------------
73: -- ---------------------------------------------------------------------------
125: exception
126: when app_exception.application_exception then
127: if hr_multi_message.exception_add
128: (p_associated_column1 => 'RULE_ID') then
129: hr_utility.set_location(' Leaving:'|| l_proc, 50);
130: raise;
131: end if;
132: hr_utility.set_location(' Leaving:'|| l_proc, 60);
133: end chk_rule_id;
128: (p_associated_column1 => 'RULE_ID') then
129: hr_utility.set_location(' Leaving:'|| l_proc, 50);
130: raise;
131: end if;
132: hr_utility.set_location(' Leaving:'|| l_proc, 60);
133: end chk_rule_id;
134: --
135: --
136: -- ----------------------------------------------------------------------------
377: --
378: l_proc varchar2(72) := g_package||'insert_validate';
379: --
380: Begin
381: hr_utility.set_location('Entering:'||l_proc, 5);
382: --
383: --
384: --
385: chk_action_id(p_action_id => p_rec.action_id
388: --
389: chk_rule_id(p_rule_id => p_rec.rule_id
390: ,p_effective_date => p_effective_date);
391: --
392: hr_utility.set_location(' Leaving:'||l_proc, 10);
393: End insert_validate;
394: --
395: -- ----------------------------------------------------------------------------
396: -- |---------------------------< update_validate >----------------------------|
405: --
406: l_proc varchar2(72) := g_package||'update_validate';
407: --
408: Begin
409: hr_utility.set_location('Entering:'||l_proc, 5);
410: --
411: --
412: -- Call the datetrack update integrity operation
413: --
423: ,p_rec => p_rec
424: );
425: --
426: --
427: hr_utility.set_location(' Leaving:'||l_proc, 10);
428: End update_validate;
429: --
430: -- ----------------------------------------------------------------------------
431: -- |---------------------------< delete_validate >----------------------------|
440: --
441: l_proc varchar2(72) := g_package||'delete_validate';
442: --
443: Begin
444: hr_utility.set_location('Entering:'||l_proc, 5);
445: --
446: -- Call all supporting business operations
447: --
448: dt_delete_validate
452: ,p_action_id => p_rec.action_id
453: ,p_rule_id => p_rec.rule_id
454: );
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 10);
457: End delete_validate;
458: --
459: end ame_acu_bus;