DBA Data[Home] [Help]

APPS.BEN_ECT_BUS dependencies on HR_UTILITY

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

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

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

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

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

180: select null from ben_elig_py_bss_prte_f a where a.eligy_prfl_id = p_eligy_prfl_id;
181: --
182: Begin
183: --
184: hr_utility.set_location('Entering:'||l_proc,5);
185: --
186: l_api_updating := ben_ect_shd.api_updating
187: (p_elig_dsblty_ctg_prte_id => p_elig_dsblty_ctg_prte_id,
188: p_effective_date => p_effective_date,

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

247: end if;
248: --
249: end if;
250: --
251: hr_utility.set_location('Leaving:'||l_proc,10);
252: --
253: End chk_person_type_id;
254: --*/
255: -- ----------------------------------------------------------------------------

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

296: and ppt.business_group_id+0 = p_business_group_id;
297: --
298: Begin
299: --
300: hr_utility.set_location('Entering:'||l_proc, 5);
301: --
302: l_api_updating := ben_ect_shd.api_updating
303: (p_effective_date =>p_effective_date,
304: p_elig_dsblty_ctg_prte_id => p_elig_dsblty_ctg_prte_id,

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

326: close c1;
327: --
328: end if;
329: --
330: hr_utility.set_location('Leaving:'||l_proc,10);
331: --
332: end chk_category;
333: --
334: -- ----------------------------------------------------------------------------

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

366: l_api_updating boolean;
367: --
368: Begin
369: --
370: hr_utility.set_location('Entering:'||l_proc, 5);
371: --
372: l_api_updating := ben_ect_shd.api_updating
373: (p_elig_dsblty_ctg_prte_id => p_elig_dsblty_ctg_prte_id,
374: p_effective_date => p_effective_date,

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

395: end if;
396: --
397: end if;
398: --
399: hr_utility.set_location('Leaving:'||l_proc,10);
400: --
401: end chk_excld_flag;
402: --
403: -- ----------------------------------------------------------------------------

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

439: l_integrity_error Exception;
440: l_table_name all_tables.table_name%TYPE;
441: --
442: Begin
443: hr_utility.set_location('Entering:'||l_proc, 5);
444: --
445: -- Ensure that the p_datetrack_mode argument is not null
446: --
447: hr_api.mandatory_arg_error

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

478: End If;
479: --
480: End If;
481: --
482: hr_utility.set_location(' Leaving:'||l_proc, 10);
483: Exception
484: When l_integrity_error Then
485: --
486: -- A referential integrity check was violated therefore

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

545: l_rows_exist Exception;
546: l_table_name all_tables.table_name%TYPE;
547: --
548: Begin
549: hr_utility.set_location('Entering:'||l_proc, 5);
550: --
551: -- Ensure that the p_datetrack_mode argument is not null
552: --
553: hr_api.mandatory_arg_error

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

582: --
583: --
584: End If;
585: --
586: hr_utility.set_location(' Leaving:'||l_proc, 10);
587: Exception
588: When l_rows_exist Then
589: --
590: -- A referential integrity check was violated therefore

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

616: --
617: l_proc varchar2(72) := g_package||'insert_validate';
618: --
619: Begin
620: hr_utility.set_location('Entering:'||l_proc, 5);
621: --
622: -- Call all supporting business operations
623: --
624: --

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

652: p_excld_flag => p_rec.excld_flag,
653: p_effective_date => p_effective_date,
654: p_object_version_number => p_rec.object_version_number);
655: --
656: hr_utility.set_location(' Leaving:'||l_proc, 10);
657: End insert_validate;
658: --
659: -- ----------------------------------------------------------------------------
660: -- |---------------------------< update_validate >----------------------------|

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

668: --
669: l_proc varchar2(72) := g_package||'update_validate';
670: --
671: Begin
672: hr_utility.set_location('Entering:'||l_proc, 5);
673: --
674: -- Call all supporting business operations
675: --
676: --

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

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

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

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

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

738: p_validation_start_date => p_validation_start_date,
739: p_validation_end_date => p_validation_end_date,
740: p_elig_dsblty_ctg_prte_id => p_rec.elig_dsblty_ctg_prte_id);
741: --
742: hr_utility.set_location(' Leaving:'||l_proc, 10);
743: End delete_validate;
744: --
745: --
746: -- ---------------------------------------------------------------------------

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

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

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

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