APPS.AME_APT_BUS dependencies on HR_UTILITY

Line 130: hr_utility.set_location(' Leaving:'|| l_proc, 60);

126: if hr_multi_message.exception_add
127: (p_associated_column1 => 'ame_approver_types.orig_system') then
128: raise;
129: end if;
130: hr_utility.set_location(' Leaving:'|| l_proc, 60);
131: end chk_orig_system ;
132: --
133: -- ----------------------------------------------------------------------------
134: -- |------------------------< chk_unique >------------------------------------|

Line 176: hr_utility.set_location('Entering:'||l_proc,10);

172: l_proc varchar2(72) := g_package || 'CHK_UNIQUE';
173: l_dummy varchar2(1);
174: --
175: Begin
176: hr_utility.set_location('Entering:'||l_proc,10);
177: --
178: open csr_name;
179: fetch csr_name into l_dummy;
180: if csr_name%found then

Line 187: hr_utility.set_location(' Leaving:'||l_proc,30);

183: fnd_message.raise_error;
184: end if;
185: close csr_name;
186: --
187: hr_utility.set_location(' Leaving:'||l_proc,30);
188: exception
189: when app_exception.application_exception then
190: if hr_multi_message.exception_add
191: (p_associated_column1 => 'ame_approver_types.UNIQUE'

Line 193: hr_utility.set_location(' Leaving:'||l_proc, 40);

189: when app_exception.application_exception then
190: if hr_multi_message.exception_add
191: (p_associated_column1 => 'ame_approver_types.UNIQUE'
192: ) then
193: hr_utility.set_location(' Leaving:'||l_proc, 40);
194: raise;
195: end if;
196: hr_utility.set_location(' Leaving:'||l_proc,50);
197: End chk_unique;

Line 196: hr_utility.set_location(' Leaving:'||l_proc,50);

192: ) then
193: hr_utility.set_location(' Leaving:'||l_proc, 40);
194: raise;
195: end if;
196: hr_utility.set_location(' Leaving:'||l_proc,50);
197: End chk_unique;
198: --
199: -- ----------------------------------------------------------------------------
200: -- |-----------------------------< CHK_DELETE >-------------------------------|

Line 372: hr_utility.set_location(' Leaving:'||l_proc,30);

368: hr_multi_message.add;
369: -- fnd_message.raise_error;
370: end if;
371: close c_sel5;
372: hr_utility.set_location(' Leaving:'||l_proc,30);
373: exception
374: when app_exception.application_exception then
375: if hr_multi_message.exception_add
376: (p_associated_column1 => 'AME_APPROVER_TYPE.DELETE'

Line 378: hr_utility.set_location(' Leaving:'||l_proc, 40);

374: when app_exception.application_exception then
375: if hr_multi_message.exception_add
376: (p_associated_column1 => 'AME_APPROVER_TYPE.DELETE'
377: ) then
378: hr_utility.set_location(' Leaving:'||l_proc, 40);
379: raise;
380: end if;
381: hr_utility.set_location(' Leaving:'||l_proc,50);
382: End chk_delete;

Line 381: hr_utility.set_location(' Leaving:'||l_proc,50);

377: ) then
378: hr_utility.set_location(' Leaving:'||l_proc, 40);
379: raise;
380: end if;
381: hr_utility.set_location(' Leaving:'||l_proc,50);
382: End chk_delete;
383: --
384: -- ----------------------------------------------------------------------------
385: -- |--------------------------< dt_update_validate >--------------------------|

Line 579: hr_utility.set_location('Entering:'||l_proc, 5);

575: --
576: l_proc varchar2(72) := g_package||'insert_validate';
577: --
578: Begin
579: hr_utility.set_location('Entering:'||l_proc, 5);
580: --
581: -- Validate Dependent Attributes
582: --
583: chk_orig_system(p_orig_system => p_rec.orig_system);

Line 588: hr_utility.set_location(' Leaving:'||l_proc, 10);

584:
585: chk_unique(p_orig_system => p_rec.orig_system
586: ,p_effective_date => p_effective_date
587: );
588: hr_utility.set_location(' Leaving:'||l_proc, 10);
589: End insert_validate;
590: --
591: -- ----------------------------------------------------------------------------
592: -- |---------------------------< update_validate >----------------------------|

Line 605: hr_utility.set_location('Entering:'||l_proc, 5);

601: --
602: l_proc varchar2(72) := g_package||'update_validate';
603: --
604: Begin
605: hr_utility.set_location('Entering:'||l_proc, 5);
606: --
607: -- Validate Dependent Attributes
608: --
609: -- Call the datetrack update integrity operation

Line 623: hr_utility.set_location(' Leaving:'||l_proc, 10);

619: ,p_rec => p_rec
620: );
621: --
622: --
623: hr_utility.set_location(' Leaving:'||l_proc, 10);
624: End update_validate;
625: --
626: -- ----------------------------------------------------------------------------
627: -- |---------------------------< delete_validate >----------------------------|

Line 647: hr_utility.set_location('Entering:'||l_proc, 5);

643: where approver_type_id = p_rec.approver_type_id
644: and p_effective_date between start_date
645: and nvl(end_date - ame_util.oneSecond, p_effective_date);
646: Begin
647: hr_utility.set_location('Entering:'||l_proc, 5);
648: --
649: -- Call all supporting business operations
650: --
651: -- Check for seeded data

Line 668: hr_utility.set_location(' Leaving:'||l_proc, 10);

664: ,p_validation_end_date => p_validation_end_date
665: ,p_approver_type_id => p_rec.approver_type_id
666: );
667: --
668: hr_utility.set_location(' Leaving:'||l_proc, 10);
669: End delete_validate;
670: --
671: end ame_apt_bus;