DBA Data[Home] [Help]

APPS.BEN_EST_BUS dependencies on HR_UTILITY

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

43: l_api_updating boolean;
44: --
45: Begin
46: --
47: hr_utility.set_location('Entering:'||l_proc, 5);
48: --
49: l_api_updating := ben_est_shd.api_updating
50: (p_effective_date => p_effective_date,
51: p_elig_suppl_role_prte_id => p_elig_suppl_role_prte_id,

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

72: end if;
73: --
74: end if;
75: --
76: hr_utility.set_location('Leaving:'||l_proc, 10);
77: --
78: End chk_elig_suppl_role_prte_id;
79: --
80: -- ----------------------------------------------------------------------------

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

112: l_api_updating boolean;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc, 5);
117: --
118: l_api_updating := ben_est_shd.api_updating
119: (p_elig_suppl_role_prte_id => p_elig_suppl_role_prte_id,
120: p_effective_date => p_effective_date,

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

144: end if;
145: --
146: end if;
147: --
148: hr_utility.set_location('Leaving:'||l_proc,10);
149: --
150: end chk_excld_flag;
151: --
152: -- ----------------------------------------------------------------------------

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

190: where grp.job_group_id = p_job_group_id;
191: --
192: Begin
193: --
194: hr_utility.set_location('Entering:'||l_proc,5);
195: --
196: l_api_updating := ben_est_shd.api_updating
197: (p_elig_suppl_role_prte_id => p_elig_suppl_role_prte_id,
198: p_effective_date => p_effective_date,

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

224: close c1;
225: --
226: end if;
227: --
228: hr_utility.set_location('Leaving:'||l_proc,10);
229: --
230: End chk_job_group_id;
231: --
232: -- ----------------------------------------------------------------------------

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

273: between date_from and nvl(date_to,hr_api.g_eot);
274: --
275: Begin
276: --
277: hr_utility.set_location('Entering:'||l_proc,5);
278: --
279: l_api_updating := ben_est_shd.api_updating
280: (p_elig_suppl_role_prte_id => p_elig_suppl_role_prte_id,
281: p_effective_date => p_effective_date,

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

307: close c1;
308: --
309: end if;
310: --
311: hr_utility.set_location('Leaving:'||l_proc,10);
312: --
313: End chk_job_id;
314: --
315: -- ----------------------------------------------------------------------------

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

366:
367: --
368: Begin
369: --
370: hr_utility.set_location('Entering:'||l_proc,5);
371: --
372: open c1;
373: --
374: fetch c1 into l_dummy;

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

383: --
384: end if;
385: close c1;
386: --
387: hr_utility.set_location('Leaving:'||l_proc,10);
388: --
389: End chk_dup_role_criteria;
390: --
391: -- ----------------------------------------------------------------------------

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

427: l_integrity_error Exception;
428: l_table_name all_tables.table_name%TYPE;
429: --
430: Begin
431: hr_utility.set_location('Entering:'||l_proc, 5);
432: --
433: -- Ensure that the p_datetrack_mode argument is not null
434: --
435: hr_api.mandatory_arg_error

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

466: End If;
467: --
468: End If;
469: --
470: hr_utility.set_location(' Leaving:'||l_proc, 10);
471: Exception
472: When l_integrity_error Then
473: --
474: -- A referential integrity check was violated therefore

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

532: l_rows_exist Exception;
533: l_table_name all_tables.table_name%TYPE;
534: --
535: Begin
536: hr_utility.set_location('Entering:'||l_proc, 5);
537: --
538: -- Ensure that the p_datetrack_mode argument is not null
539: --
540: hr_api.mandatory_arg_error

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

569: --
570: --
571: End If;
572: --
573: hr_utility.set_location(' Leaving:'||l_proc, 10);
574: Exception
575: When l_rows_exist Then
576: --
577: -- A referential integrity check was violated therefore

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

603: --
604: l_proc varchar2(72) := g_package||'insert_validate';
605: --
606: Begin
607: hr_utility.set_location('Entering:'||l_proc, 5);
608: --
609: -- Call all supporting business operations
610: --
611: --

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

645: p_validation_end_date => p_validation_end_date,
646: p_business_group_id => p_rec.business_group_id);
647:
648: --
649: hr_utility.set_location(' Leaving:'||l_proc, 10);
650: End insert_validate;
651: --
652: -- ----------------------------------------------------------------------------
653: -- |---------------------------< update_validate >----------------------------|

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

661: --
662: l_proc varchar2(72) := g_package||'update_validate';
663: --
664: Begin
665: hr_utility.set_location('Entering:'||l_proc, 5);
666: --
667: -- Call all supporting business operations
668: --
669: --

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

710: p_datetrack_mode => p_datetrack_mode,
711: p_validation_start_date => p_validation_start_date,
712: p_validation_end_date => p_validation_end_date);
713: --
714: hr_utility.set_location(' Leaving:'||l_proc, 10);
715: End update_validate;
716: --
717: -- ----------------------------------------------------------------------------
718: -- |---------------------------< delete_validate >----------------------------|

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

726: --
727: l_proc varchar2(72) := g_package||'delete_validate';
728: --
729: Begin
730: hr_utility.set_location('Entering:'||l_proc, 5);
731: --
732: -- Call all supporting business operations
733: --
734: dt_delete_validate

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

736: p_validation_start_date => p_validation_start_date,
737: p_validation_end_date => p_validation_end_date,
738: p_elig_suppl_role_prte_id => p_rec.elig_suppl_role_prte_id);
739: --
740: hr_utility.set_location(' Leaving:'||l_proc, 10);
741: End delete_validate;
742: --
743: --
744: -- ---------------------------------------------------------------------------

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

763: l_proc varchar2(72) := g_package||'return_legislation_code';
764: --
765: begin
766: --
767: hr_utility.set_location('Entering:'|| l_proc, 10);
768: --
769: -- Ensure that all the mandatory parameter are not null
770: --
771: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 792: hr_utility.set_location(' Leaving:'|| l_proc, 20);

788: end if;
789: --
790: close csr_leg_code;
791: --
792: hr_utility.set_location(' Leaving:'|| l_proc, 20);
793: --
794: return l_legislation_code;
795: --
796: end return_legislation_code;