DBA Data[Home] [Help]

APPS.BEN_EMS_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_ems_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_mrtl_stat_cvg_id => p_elig_mrtl_stat_cvg_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_mrtl_stat_cvg_id;
78: --
79: -- ----------------------------------------------------------------------------

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

120: and ff.effective_end_date;
121: --
122: Begin
123: --
124: hr_utility.set_location('Entering:'||l_proc, 5);
125: --
126: l_api_updating := ben_ems_shd.api_updating
127: (p_elig_mrtl_stat_cvg_id => p_elig_mrtl_stat_cvg_id,
128: p_effective_date => p_effective_date,

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

156: close c1;
157: --
158: end if;
159: --
160: hr_utility.set_location('Leaving:'||l_proc,10);
161: --
162: end chk_cvg_thru_rl;
163: --
164: -- ----------------------------------------------------------------------------

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

196: l_api_updating boolean;
197: --
198: Begin
199: --
200: hr_utility.set_location('Entering:'||l_proc, 5);
201: --
202: l_api_updating := ben_ems_shd.api_updating
203: (p_elig_mrtl_stat_cvg_id => p_elig_mrtl_stat_cvg_id,
204: p_effective_date => p_effective_date,

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

225: end if;
226: --
227: end if;
228: --
229: hr_utility.set_location('Leaving:'||l_proc,10);
230: --
231: end chk_cvg_thru_cd;
232: --
233: -- ----------------------------------------------------------------------------

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

274: and ff.effective_end_date;
275: --
276: Begin
277: --
278: hr_utility.set_location('Entering:'||l_proc, 5);
279: --
280: l_api_updating := ben_ems_shd.api_updating
281: (p_elig_mrtl_stat_cvg_id => p_elig_mrtl_stat_cvg_id,
282: p_effective_date => p_effective_date,

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

310: close c1;
311: --
312: end if;
313: --
314: hr_utility.set_location('Leaving:'||l_proc,10);
315: --
316: end chk_cvg_strt_rl;
317: --
318: -- ----------------------------------------------------------------------------

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

350: l_api_updating boolean;
351: --
352: Begin
353: --
354: hr_utility.set_location('Entering:'||l_proc, 5);
355: --
356: l_api_updating := ben_ems_shd.api_updating
357: (p_elig_mrtl_stat_cvg_id => p_elig_mrtl_stat_cvg_id,
358: p_effective_date => p_effective_date,

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

379: end if;
380: --
381: end if;
382: --
383: hr_utility.set_location('Leaving:'||l_proc,10);
384: --
385: end chk_cvg_strt_cd;
386: --
387: -- ----------------------------------------------------------------------------

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

419: l_api_updating boolean;
420: --
421: Begin
422: --
423: hr_utility.set_location('Entering:'||l_proc, 5);
424: --
425: l_api_updating := ben_ems_shd.api_updating
426: (p_elig_mrtl_stat_cvg_id => p_elig_mrtl_stat_cvg_id,
427: p_effective_date => p_effective_date,

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

448: end if;
449: --
450: end if;
451: --
452: hr_utility.set_location('Leaving:'||l_proc,10);
453: --
454: end chk_mrtl_stat_cd;
455: --
456: -- ----------------------------------------------------------------------------

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

493: l_api_updating boolean;
494: --
495: Begin
496: --
497: hr_utility.set_location('Entering:'||l_proc, 5);
498: --
499: l_api_updating := ben_ems_shd.api_updating
500: (p_elig_mrtl_stat_cvg_id => p_elig_mrtl_stat_cvg_id,
501: p_effective_date => p_effective_date,

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

524:
525: --
526: -- Leaving Procedure.
527: --
528: hr_utility.set_location('Leaving:'||l_proc,10);
529: --
530: end chk_cvg_strt_dt_dependency;
531: --
532: -- ----------------------------------------------------------------------------

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

569: l_api_updating boolean;
570: --
571: Begin
572: --
573: hr_utility.set_location('Entering:'||l_proc, 5);
574: --
575: l_api_updating := ben_ems_shd.api_updating
576: (p_elig_mrtl_stat_cvg_id => p_elig_mrtl_stat_cvg_id,
577: p_effective_date => p_effective_date,

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

600: end if;
601: --
602: -- Leaving Procedure.
603: --
604: hr_utility.set_location('Leaving:'|| l_proc, 10);
605: --
606: end chk_cvg_thru_dt_dependency;
607: --
608: --

Line 657: hr_utility.set_location('Entering:'||l_proc, 6);

653:
654: --
655: Begin
656: --
657: hr_utility.set_location('Entering:'||l_proc, 6);
658: --
659: open c1;
660: fetch c1 into dummy;
661: if c1%found then

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

664: fnd_message.raise_error;
665: end if;
666: close c1;
667: --
668: hr_utility.set_location('Leaving:'||l_proc, 10);
669: --
670: End chk_duplicate_rows;
671:
672: -- ----------------------------------------------------------------------------

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

708: l_integrity_error Exception;
709: l_table_name all_tables.table_name%TYPE;
710: --
711: Begin
712: hr_utility.set_location('Entering:'||l_proc, 5);
713: --
714: -- Ensure that the p_datetrack_mode argument is not null
715: --
716: hr_api.mandatory_arg_error

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

747: End If;
748: --
749: End If;
750: --
751: hr_utility.set_location(' Leaving:'||l_proc, 10);
752: Exception
753: When l_integrity_error Then
754: --
755: -- A referential integrity check was violated therefore

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

813: l_rows_exist Exception;
814: l_table_name all_tables.table_name%TYPE;
815: --
816: Begin
817: hr_utility.set_location('Entering:'||l_proc, 5);
818: --
819: -- Ensure that the p_datetrack_mode argument is not null
820: --
821: hr_api.mandatory_arg_error

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

850: --
851: --
852: End If;
853: --
854: hr_utility.set_location(' Leaving:'||l_proc, 10);
855: Exception
856: When l_rows_exist Then
857: --
858: -- A referential integrity check was violated therefore

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

883: --
884: l_proc varchar2(72) := g_package||'insert_validate';
885: --
886: Begin
887: hr_utility.set_location('Entering:'||l_proc, 5);
888: --
889: -- Call all supporting business operations
890: --
891: --

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

947: p_cvg_thru_rl => p_rec.cvg_thru_rl,
948: p_effective_date => p_effective_date,
949: p_object_version_number => p_rec.object_version_number);
950: --
951: hr_utility.set_location(' Leaving:'||l_proc, 10);
952: End insert_validate;
953: --
954: -- ----------------------------------------------------------------------------
955: -- |---------------------------< update_validate >----------------------------|

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

963: --
964: l_proc varchar2(72) := g_package||'update_validate';
965: --
966: Begin
967: hr_utility.set_location('Entering:'||l_proc, 5);
968: --
969: -- Call all supporting business operations
970: --
971: --

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

1034: p_datetrack_mode => p_datetrack_mode,
1035: p_validation_start_date => p_validation_start_date,
1036: p_validation_end_date => p_validation_end_date);
1037: --
1038: hr_utility.set_location(' Leaving:'||l_proc, 10);
1039: End update_validate;
1040: --
1041: -- ----------------------------------------------------------------------------
1042: -- |---------------------------< delete_validate >----------------------------|

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

1050: --
1051: l_proc varchar2(72) := g_package||'delete_validate';
1052: --
1053: Begin
1054: hr_utility.set_location('Entering:'||l_proc, 5);
1055: --
1056: -- Call all supporting business operations
1057: --
1058: dt_delete_validate

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

1060: p_validation_start_date => p_validation_start_date,
1061: p_validation_end_date => p_validation_end_date,
1062: p_elig_mrtl_stat_cvg_id => p_rec.elig_mrtl_stat_cvg_id);
1063: --
1064: hr_utility.set_location(' Leaving:'||l_proc, 10);
1065: End delete_validate;
1066: --
1067: --
1068: -- ---------------------------------------------------------------------------

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

1087: l_proc varchar2(72) := g_package||'return_legislation_code';
1088: --
1089: begin
1090: --
1091: hr_utility.set_location('Entering:'|| l_proc, 10);
1092: --
1093: -- Ensure that all the mandatory parameter are not null
1094: --
1095: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1112: end if;
1113: --
1114: close csr_leg_code;
1115: --
1116: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1117: --
1118: return l_legislation_code;
1119: --
1120: end return_legislation_code;