DBA Data[Home] [Help]

APPS.BEN_ESC_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_esc_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_stdnt_stat_cvg_id => p_elig_stdnt_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_stdnt_stat_cvg_id;
78: --
79: -- ----------------------------------------------------------------------------

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_esc_shd.api_updating
118: (p_elig_stdnt_stat_cvg_id => p_elig_stdnt_stat_cvg_id,
119: p_effective_date => p_effective_date,

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_stdnt_stat_cd;
147: --
148: -- ----------------------------------------------------------------------------

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

189: and ff.effective_end_date;
190: --
191: Begin
192: --
193: hr_utility.set_location('Entering:'||l_proc, 5);
194: --
195: l_api_updating := ben_esc_shd.api_updating
196: (p_elig_stdnt_stat_cvg_id => p_elig_stdnt_stat_cvg_id,
197: p_effective_date => p_effective_date,

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

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

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

265: l_api_updating boolean;
266: --
267: Begin
268: --
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: --
271: l_api_updating := ben_esc_shd.api_updating
272: (p_elig_stdnt_stat_cvg_id => p_elig_stdnt_stat_cvg_id,
273: p_effective_date => p_effective_date,

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

294: end if;
295: --
296: end if;
297: --
298: hr_utility.set_location('Leaving:'||l_proc,10);
299: --
300: end chk_cvg_thru_cd;
301: --
302: -- ----------------------------------------------------------------------------

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

343: and ff.effective_end_date;
344: --
345: Begin
346: --
347: hr_utility.set_location('Entering:'||l_proc, 5);
348: --
349: l_api_updating := ben_esc_shd.api_updating
350: (p_elig_stdnt_stat_cvg_id => p_elig_stdnt_stat_cvg_id,
351: p_effective_date => p_effective_date,

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

379: close c1;
380: --
381: end if;
382: --
383: hr_utility.set_location('Leaving:'||l_proc,10);
384: --
385: end chk_cvg_strt_rl;
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_esc_shd.api_updating
426: (p_elig_stdnt_stat_cvg_id => p_elig_stdnt_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_cvg_strt_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_esc_shd.api_updating
500: (p_elig_stdnt_stat_cvg_id => p_elig_stdnt_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_esc_shd.api_updating
576: (p_elig_stdnt_stat_cvg_id => p_elig_stdnt_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 658: hr_utility.set_location('Entering:'||l_proc, 6);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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