DBA Data[Home] [Help]

APPS.BEN_CAGR_CHECK_ELIGIBILITY dependencies on HR_UTILITY

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

25: l_score_tab ben_evaluate_elig_profiles.scoreTab;
26: --
27: begin
28: --
29: hr_utility.set_location('Entering : '||l_proc,10);
30: --
31: ben_cagrelp_cache.elpegn_getdets
32: (p_effective_date => p_effective_date
33: ,p_eligy_prfl_id => p_eligy_prfl_id

Line 101: hr_utility.set_location('Criteria Failed: '||l_proc,20);

97: then
98: --
99: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EGN';
100: fnd_message.set_name('BEN','BEN_92814_GNDR_PRFL_FAIL');
101: hr_utility.set_location('Criteria Failed: '||l_proc,20);
102: raise ben_evaluate_elig_profiles.g_criteria_failed;
103: --
104: end if;
105: end if;

Line 109: hr_utility.set_location('count '||l_score_tab.count,20);

105: end if;
106: --
107: if p_score_compute_mode
108: then
109: hr_utility.set_location('count '||l_score_tab.count,20);
110: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
111: end if;
112: hr_utility.set_location('Leaving: '||l_proc,20);
113: --

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

108: then
109: hr_utility.set_location('count '||l_score_tab.count,20);
110: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
111: end if;
112: hr_utility.set_location('Leaving: '||l_proc,20);
113: --
114: end check_gndr_elig;
115: --
116: procedure check_mrtl_sts_elig

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

134: l_crit_passed boolean;
135: l_score_tab ben_evaluate_elig_profiles.scoreTab;
136: begin
137: --
138: hr_utility.set_location('Entering : '||l_proc,10);
139: --
140: ben_cagrelp_cache.elpemp_getdets
141: (p_effective_date => p_effective_date
142: ,p_eligy_prfl_id => p_eligy_prfl_id

Line 210: hr_utility.set_location('Criteria Failed: '||l_proc,20);

206: then
207: --
208: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EMP';
209: fnd_message.set_name('BEN','BEN_92815_MARSTAT_PRFL_FAIL');
210: hr_utility.set_location('Criteria Failed: '||l_proc,20);
211: raise ben_evaluate_elig_profiles.g_criteria_failed;
212: --
213: end if;
214: end if;

Line 218: hr_utility.set_location('count '||l_score_tab.count,20);

214: end if;
215: --
216: if p_score_compute_mode
217: then
218: hr_utility.set_location('count '||l_score_tab.count,20);
219: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
220: end if;
221: hr_utility.set_location('Leaving: '||l_proc,20);
222: --

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

217: then
218: hr_utility.set_location('count '||l_score_tab.count,20);
219: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
220: end if;
221: hr_utility.set_location('Leaving: '||l_proc,20);
222: --
223: end check_mrtl_sts_elig;
224: --
225: procedure check_dsblty_ctg_elig

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

243: l_crit_passed boolean;
244: l_score_tab ben_evaluate_elig_profiles.scoreTab;
245: begin
246: --
247: hr_utility.set_location('Entering : '||l_proc,10);
248: --
249: ben_cagrelp_cache.elpect_getdets
250: (p_effective_date => p_effective_date
251: ,p_eligy_prfl_id => p_eligy_prfl_id

Line 319: hr_utility.set_location('Criteria Failed: '||l_proc,20);

315: then
316: --
317: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'ECT';
318: fnd_message.set_name('BEN','BEN_92816_DSBLCAT_PRFL_FAIL');
319: hr_utility.set_location('Criteria Failed: '||l_proc,20);
320: raise ben_evaluate_elig_profiles.g_criteria_failed;
321: --
322: end if;
323: end if;

Line 327: hr_utility.set_location('count '||l_score_tab.count,20);

323: end if;
324: --
325: if p_score_compute_mode
326: then
327: hr_utility.set_location('count '||l_score_tab.count,20);
328: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
329: end if;
330: hr_utility.set_location('Leaving: '||l_proc,20);
331: --

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

326: then
327: hr_utility.set_location('count '||l_score_tab.count,20);
328: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
329: end if;
330: hr_utility.set_location('Leaving: '||l_proc,20);
331: --
332: end check_dsblty_ctg_elig;
333: --
334: procedure check_dsblty_rsn_elig

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

352: l_crit_passed boolean;
353: l_score_tab ben_evaluate_elig_profiles.scoreTab;
354: begin
355: --
356: hr_utility.set_location('Entering : '||l_proc,10);
357: --
358: ben_cagrelp_cache.elpedr_getdets
359: (p_effective_date => p_effective_date
360: ,p_eligy_prfl_id => p_eligy_prfl_id

Line 428: hr_utility.set_location('Criteria Failed: '||l_proc,20);

424: then
425: --
426: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EDR';
427: fnd_message.set_name('BEN','BEN_92817_DSBLRSN_PRFL_FAIL');
428: hr_utility.set_location('Criteria Failed: '||l_proc,20);
429: raise ben_evaluate_elig_profiles.g_criteria_failed;
430: --
431: end if;
432: end if;

Line 436: hr_utility.set_location('count '||l_score_tab.count,20);

432: end if;
433: --
434: if p_score_compute_mode
435: then
436: hr_utility.set_location('count '||l_score_tab.count,20);
437: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
438: end if;
439: hr_utility.set_location('Leaving: '||l_proc,20);
440: --

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

435: then
436: hr_utility.set_location('count '||l_score_tab.count,20);
437: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
438: end if;
439: hr_utility.set_location('Leaving: '||l_proc,20);
440: --
441: end check_dsblty_rsn_elig;
442: --
443: procedure check_dsblty_dgr_elig

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

461: l_crit_passed boolean;
462: l_score_tab ben_evaluate_elig_profiles.scoreTab;
463: begin
464: --
465: hr_utility.set_location('Entering : '||l_proc,10);
466: --
467: ben_cagrelp_cache.elpedd_getdets
468: (p_effective_date => p_effective_date
469: ,p_eligy_prfl_id => p_eligy_prfl_id

Line 537: hr_utility.set_location('Criteria Failed: '||l_proc,20);

533: then
534: --
535: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EDD';
536: fnd_message.set_name('BEN','BEN_92818_DSBDGR_PRFL_FAIL');
537: hr_utility.set_location('Criteria Failed: '||l_proc,20);
538: raise ben_evaluate_elig_profiles.g_criteria_failed;
539: --
540: end if;
541: end if;

Line 545: hr_utility.set_location('count '||l_score_tab.count,20);

541: end if;
542: --
543: if p_score_compute_mode
544: then
545: hr_utility.set_location('count '||l_score_tab.count,20);
546: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
547: end if;
548: hr_utility.set_location('Leaving: '||l_proc,20);
549: --

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

544: then
545: hr_utility.set_location('count '||l_score_tab.count,20);
546: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
547: end if;
548: hr_utility.set_location('Leaving: '||l_proc,20);
549: --
550: end check_dsblty_dgr_elig;
551: --
552: procedure check_suppl_role_elig

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

571: l_crit_passed boolean;
572: l_score_tab ben_evaluate_elig_profiles.scoreTab;
573: begin
574: --
575: hr_utility.set_location('Entering : '||l_proc,10);
576: --
577: ben_cagrelp_cache.elpest_getdets
578: (p_effective_date => p_effective_date
579: ,p_eligy_prfl_id => p_eligy_prfl_id

Line 648: hr_utility.set_location('Criteria Failed: '||l_proc,20);

644: then
645: --
646: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EST';
647: fnd_message.set_name('BEN','BEN_92819_SUPPLROLE_PRFL_FAIL');
648: hr_utility.set_location('Criteria Failed: '||l_proc,20);
649: raise ben_evaluate_elig_profiles.g_criteria_failed;
650: --
651: end if;
652: end if;

Line 656: hr_utility.set_location('count '||l_score_tab.count,20);

652: end if;
653: --
654: if p_score_compute_mode
655: then
656: hr_utility.set_location('count '||l_score_tab.count,20);
657: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
658: end if;
659: hr_utility.set_location('Leaving: '||l_proc,20);
660: --

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

655: then
656: hr_utility.set_location('count '||l_score_tab.count,20);
657: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
658: end if;
659: hr_utility.set_location('Leaving: '||l_proc,20);
660: --
661: end check_suppl_role_elig;
662: --
663: procedure check_qual_titl_elig

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

682: l_crit_passed boolean;
683: l_score_tab ben_evaluate_elig_profiles.scoreTab;
684: begin
685: --
686: hr_utility.set_location('Entering : '||l_proc,10);
687: --
688: ben_cagrelp_cache.elpeqt_getdets
689: (p_effective_date => p_effective_date
690: ,p_eligy_prfl_id => p_eligy_prfl_id

Line 764: hr_utility.set_location('Criteria Failed: '||l_proc,20);

760: then
761: --
762: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EQT';
763: fnd_message.set_name('BEN','BEN_92820_QUALTITL_PRFL_FAIL');
764: hr_utility.set_location('Criteria Failed: '||l_proc,20);
765: raise ben_evaluate_elig_profiles.g_criteria_failed;
766: --
767: end if;
768: end if;

Line 772: hr_utility.set_location('count '||l_score_tab.count,20);

768: end if;
769: --
770: if p_score_compute_mode
771: then
772: hr_utility.set_location('count '||l_score_tab.count,20);
773: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
774: end if;
775: hr_utility.set_location('Leaving: '||l_proc,20);
776: --

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

771: then
772: hr_utility.set_location('count '||l_score_tab.count,20);
773: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
774: end if;
775: hr_utility.set_location('Leaving: '||l_proc,20);
776: --
777: end check_qual_titl_elig;
778: --
779: procedure check_pstn_elig

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

797: l_crit_passed boolean;
798: l_score_tab ben_evaluate_elig_profiles.scoreTab;
799: begin
800: --
801: hr_utility.set_location('Entering : '||l_proc,10);
802: --
803: ben_cagrelp_cache.elpeps_getdets
804: (p_effective_date => p_effective_date
805: ,p_eligy_prfl_id => p_eligy_prfl_id

Line 873: hr_utility.set_location('Criteria Failed: '||l_proc,20);

869: then
870: --
871: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EPS';
872: fnd_message.set_name('BEN','BEN_92821_PSTN_PRFL_FAIL');
873: hr_utility.set_location('Criteria Failed: '||l_proc,20);
874: raise ben_evaluate_elig_profiles.g_criteria_failed;
875: --
876: end if;
877: end if;

Line 881: hr_utility.set_location('count '||l_score_tab.count,20);

877: end if;
878: --
879: if p_score_compute_mode
880: then
881: hr_utility.set_location('count '||l_score_tab.count,20);
882: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
883: end if;
884: hr_utility.set_location('Leaving: '||l_proc,20);
885: --

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

880: then
881: hr_utility.set_location('count '||l_score_tab.count,20);
882: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
883: end if;
884: hr_utility.set_location('Leaving: '||l_proc,20);
885: --
886: end check_pstn_elig;
887: --
888: procedure check_prbtn_perd_elig

Line 982: hr_utility.set_location('Criteria Failed: '||l_proc,20);

978: then
979: --
980: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EDD';
981: fnd_message.set_name('BEN','BEN_92822_PRBNPERD_PRFL_FAIL');
982: hr_utility.set_location('Criteria Failed: '||l_proc,20);
983: raise ben_evaluate_elig_profiles.g_criteria_failed;
984: --
985: end if;
986: end if;

Line 990: hr_utility.set_location('count '||l_score_tab.count,20);

986: end if;
987: --
988: if p_score_compute_mode
989: then
990: hr_utility.set_location('count '||l_score_tab.count,20);
991: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
992: end if;
993: hr_utility.set_location('Leaving: '||l_proc,20);
994: --

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

989: then
990: hr_utility.set_location('count '||l_score_tab.count,20);
991: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
992: end if;
993: hr_utility.set_location('Leaving: '||l_proc,20);
994: --
995: end check_prbtn_perd_elig;
996: --
997: procedure check_sp_clng_prg_elig

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

1015: l_crit_passed boolean;
1016: l_score_tab ben_evaluate_elig_profiles.scoreTab;
1017: begin
1018: --
1019: hr_utility.set_location('Entering : '||l_proc,10);
1020: --
1021: ben_cagrelp_cache.elpesp_getdets
1022: (p_effective_date => p_effective_date
1023: ,p_eligy_prfl_id => p_eligy_prfl_id

Line 1091: hr_utility.set_location('Criteria Failed: '||l_proc,20);

1087: then
1088: --
1089: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'ESP';
1090: fnd_message.set_name('BEN','BEN_92823_SPCLNGPRG_PRFL_FAIL');
1091: hr_utility.set_location('Criteria Failed: '||l_proc,20);
1092: raise ben_evaluate_elig_profiles.g_criteria_failed;
1093: --
1094: end if;
1095: end if;

Line 1099: hr_utility.set_location('count '||l_score_tab.count,20);

1095: end if;
1096: --
1097: if p_score_compute_mode
1098: then
1099: hr_utility.set_location('count '||l_score_tab.count,20);
1100: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
1101: end if;
1102: hr_utility.set_location('Leaving: '||l_proc,20);
1103: --

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

1098: then
1099: hr_utility.set_location('count '||l_score_tab.count,20);
1100: ben_evaluate_elig_profiles.write(p_profile_score_tab,l_score_tab);
1101: end if;
1102: hr_utility.set_location('Leaving: '||l_proc,20);
1103: --
1104: end check_sp_clng_prg_elig;
1105: --
1106: procedure check_cagr_elig_profiles

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

1168: l_jobgrp_dets c_jobgrp_dets%rowtype;
1169: --
1170: begin
1171: --
1172: hr_utility.set_location('Entering : '||l_proc,10);
1173: --
1174: -- Get disability details
1175: --
1176: if p_eligprof_dets.ELIG_DSBLTY_CTG_FLAG = 'Y'

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

1331: );
1332: --
1333: end if;
1334: --
1335: hr_utility.set_location('Leaving: '||l_proc,20);
1336: --
1337: end check_cagr_elig_profiles;
1338: --
1339: end ben_cagr_check_eligibility;