DBA Data[Home] [Help]

APPS.BEN_EPT_BUS dependencies on HR_UTILITY

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

40:
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc,5);
45: --
46: open c2;
47: fetch c2 into l_person_type_cd;
48: close c2;

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

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

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

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

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

140: end if;
141: --
142: end if;
143: --
144: hr_utility.set_location('Leaving:'||l_proc, 10);
145: --
146: End chk_elig_per_typ_prte_id;
147: --
148: --

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

252: select null from ben_elig_py_bss_prte_f a where a.eligy_prfl_id = p_eligy_prfl_id;
253: --
254: Begin
255: --
256: hr_utility.set_location('Entering:'||l_proc,5);
257: --
258: l_api_updating := ben_ept_shd.api_updating
259: (p_elig_per_typ_prte_id => p_elig_per_typ_prte_id,
260: p_effective_date => p_effective_date,

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

319: end if;
320: --
321: end if;
322: --
323: hr_utility.set_location('Leaving:'||l_proc,10);
324: --
325: End chk_person_type_id;
326: --*/
327: -- ----------------------------------------------------------------------------

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

383: and ppt.business_group_id+0 = p_business_group_id;
384: --
385: Begin
386: --
387: hr_utility.set_location('Entering:'||l_proc, 5);
388: --
389: l_api_updating := ben_ept_shd.api_updating
390: (p_effective_date =>p_effective_date,
391: p_elig_per_typ_prte_id => p_elig_per_typ_prte_id,

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

424: close c1;
425: --
426: end if;
427: --
428: hr_utility.set_location('Leaving:'||l_proc,10);
429: --
430: end chk_per_typ_cd;
431: --
432: -- ----------------------------------------------------------------------------

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

464: l_api_updating boolean;
465: --
466: Begin
467: --
468: hr_utility.set_location('Entering:'||l_proc, 5);
469: --
470: l_api_updating := ben_ept_shd.api_updating
471: (p_elig_per_typ_prte_id => p_elig_per_typ_prte_id,
472: p_effective_date => p_effective_date,

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

493: end if;
494: --
495: end if;
496: --
497: hr_utility.set_location('Leaving:'||l_proc,10);
498: --
499: end chk_excld_flag;
500: --
501: -- ---------------------------------------------------------------------------

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

541: and ordr_num = p_ordr_num
542: and business_group_id = p_business_group_id;
543: --
544: Begin
545: hr_utility.set_location('Entering:'||l_proc, 5);
546: --
547: open c1;
548: fetch c1 into l_dummy;
549: if c1%found then

Line 556: hr_utility.set_location('Leaving:'||l_proc, 15);

552: fnd_message.raise_error;
553: end if;
554: close c1;
555: --
556: hr_utility.set_location('Leaving:'||l_proc, 15);
557: End chk_duplicate_ordr_num;
558: --
559: -- ----------------------------------------------------------------------------
560: -- |--------------------------< dt_update_validate >--------------------------|

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

595: l_integrity_error Exception;
596: l_table_name all_tables.table_name%TYPE;
597: --
598: Begin
599: hr_utility.set_location('Entering:'||l_proc, 5);
600: --
601: -- Ensure that the p_datetrack_mode argument is not null
602: --
603: hr_api.mandatory_arg_error

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

634: End If;
635: --
636: End If;
637: --
638: hr_utility.set_location(' Leaving:'||l_proc, 10);
639: Exception
640: When l_integrity_error Then
641: --
642: -- A referential integrity check was violated therefore

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

701: l_rows_exist Exception;
702: l_table_name all_tables.table_name%TYPE;
703: --
704: Begin
705: hr_utility.set_location('Entering:'||l_proc, 5);
706: --
707: -- Ensure that the p_datetrack_mode argument is not null
708: --
709: hr_api.mandatory_arg_error

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

738: --
739: --
740: End If;
741: --
742: hr_utility.set_location(' Leaving:'||l_proc, 10);
743: Exception
744: When l_rows_exist Then
745: --
746: -- A referential integrity check was violated therefore

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

772: --
773: l_proc varchar2(72) := g_package||'insert_validate';
774: --
775: Begin
776: hr_utility.set_location('Entering:'||l_proc, 5);
777: --
778: -- Call all supporting business operations
779: --
780: --

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

819: p_eligy_prfl_id => p_rec.eligy_prfl_id,
820: p_ordr_num => p_rec.ordr_num,
821: p_business_group_id => p_rec.business_group_id);
822: --
823: hr_utility.set_location(' Leaving:'||l_proc, 10);
824: End insert_validate;
825: --
826: -- ----------------------------------------------------------------------------
827: -- |---------------------------< update_validate >----------------------------|

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

835: --
836: l_proc varchar2(72) := g_package||'update_validate';
837: --
838: Begin
839: hr_utility.set_location('Entering:'||l_proc, 5);
840: --
841: -- Call all supporting business operations
842: --
843: --

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

890: p_datetrack_mode => p_datetrack_mode,
891: p_validation_start_date => p_validation_start_date,
892: p_validation_end_date => p_validation_end_date);
893: --
894: hr_utility.set_location(' Leaving:'||l_proc, 10);
895: End update_validate;
896: --
897: -- ----------------------------------------------------------------------------
898: -- |---------------------------< delete_validate >----------------------------|

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

906: --
907: l_proc varchar2(72) := g_package||'delete_validate';
908: --
909: Begin
910: hr_utility.set_location('Entering:'||l_proc, 5);
911: --
912: -- Call all supporting business operations
913: --
914: dt_delete_validate

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

916: p_validation_start_date => p_validation_start_date,
917: p_validation_end_date => p_validation_end_date,
918: p_elig_per_typ_prte_id => p_rec.elig_per_typ_prte_id);
919: --
920: hr_utility.set_location(' Leaving:'||l_proc, 10);
921: End delete_validate;
922: --
923: --
924: -- ---------------------------------------------------------------------------

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

943: l_proc varchar2(72) := g_package||'return_legislation_code';
944: --
945: begin
946: --
947: hr_utility.set_location('Entering:'|| l_proc, 10);
948: --
949: -- Ensure that all the mandatory parameter are not null
950: --
951: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

968: end if;
969: --
970: close csr_leg_code;
971: --
972: hr_utility.set_location(' Leaving:'|| l_proc, 20);
973: --
974: return l_legislation_code;
975: --
976: end return_legislation_code;