DBA Data[Home] [Help]

APPS.BEN_EMC_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_emc_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_mltry_stat_cvg_id => p_elig_mltry_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_mltry_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_emc_shd.api_updating
127: (p_elig_mltry_stat_cvg_id => p_elig_mltry_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_emc_shd.api_updating
203: (p_elig_mltry_stat_cvg_id => p_elig_mltry_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_emc_shd.api_updating
281: (p_elig_mltry_stat_cvg_id => p_elig_mltry_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_emc_shd.api_updating
357: (p_elig_mltry_stat_cvg_id => p_elig_mltry_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_emc_shd.api_updating
426: (p_elig_mltry_stat_cvg_id => p_elig_mltry_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_mltry_stat_cd;
455:
456: --

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1030: p_datetrack_mode => p_datetrack_mode,
1031: p_validation_start_date => p_validation_start_date,
1032: p_validation_end_date => p_validation_end_date);
1033: --
1034: hr_utility.set_location(' Leaving:'||l_proc, 10);
1035: End update_validate;
1036: --
1037: -- ----------------------------------------------------------------------------
1038: -- |---------------------------< delete_validate >----------------------------|

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

1046: --
1047: l_proc varchar2(72) := g_package||'delete_validate';
1048: --
1049: Begin
1050: hr_utility.set_location('Entering:'||l_proc, 5);
1051: --
1052: -- Call all supporting business operations
1053: --
1054: dt_delete_validate

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

1056: p_validation_start_date => p_validation_start_date,
1057: p_validation_end_date => p_validation_end_date,
1058: p_elig_mltry_stat_cvg_id => p_rec.elig_mltry_stat_cvg_id);
1059: --
1060: hr_utility.set_location(' Leaving:'||l_proc, 10);
1061: End delete_validate;
1062: --
1063: --
1064: -- ---------------------------------------------------------------------------

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

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

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

1108: end if;
1109: --
1110: close csr_leg_code;
1111: --
1112: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1113: --
1114: return l_legislation_code;
1115: --
1116: end return_legislation_code;