eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EVALUATE_DPNT_ELG_PROFILES dependencies on HR_UTILITY

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

177: l_proc varchar2(80) := g_package || '.set_elig_change_dt';
178: --
179: begin
180: --
181: hr_utility.set_location ('Entering '||l_proc,10);
182: hr_utility.set_location ('p_elig_change_dt '||p_elig_change_dt,10);
183: hr_utility.set_location ('g_elig_change_dt '||g_elig_change_dt,10);
184: hr_utility.set_location ('g_effective_date '||g_effective_date,10);
185: hr_utility.set_location ('** SUP p_effective_date '||p_effective_date,10);

Line 182: hr_utility.set_location ('p_elig_change_dt '||p_elig_change_dt,10);

178: --
179: begin
180: --
181: hr_utility.set_location ('Entering '||l_proc,10);
182: hr_utility.set_location ('p_elig_change_dt '||p_elig_change_dt,10);
183: hr_utility.set_location ('g_elig_change_dt '||g_elig_change_dt,10);
184: hr_utility.set_location ('g_effective_date '||g_effective_date,10);
185: hr_utility.set_location ('** SUP p_effective_date '||p_effective_date,10);
186: hr_utility.set_location ('g_dpnt_cvg_strt_dt '||g_dpnt_cvg_strt_dt,10);

Line 183: hr_utility.set_location ('g_elig_change_dt '||g_elig_change_dt,10);

179: begin
180: --
181: hr_utility.set_location ('Entering '||l_proc,10);
182: hr_utility.set_location ('p_elig_change_dt '||p_elig_change_dt,10);
183: hr_utility.set_location ('g_elig_change_dt '||g_elig_change_dt,10);
184: hr_utility.set_location ('g_effective_date '||g_effective_date,10);
185: hr_utility.set_location ('** SUP p_effective_date '||p_effective_date,10);
186: hr_utility.set_location ('g_dpnt_cvg_strt_dt '||g_dpnt_cvg_strt_dt,10);
187: --

Line 184: hr_utility.set_location ('g_effective_date '||g_effective_date,10);

180: --
181: hr_utility.set_location ('Entering '||l_proc,10);
182: hr_utility.set_location ('p_elig_change_dt '||p_elig_change_dt,10);
183: hr_utility.set_location ('g_elig_change_dt '||g_elig_change_dt,10);
184: hr_utility.set_location ('g_effective_date '||g_effective_date,10);
185: hr_utility.set_location ('** SUP p_effective_date '||p_effective_date,10);
186: hr_utility.set_location ('g_dpnt_cvg_strt_dt '||g_dpnt_cvg_strt_dt,10);
187: --
188: -- If dpnt. coverage start date is specified then, the elig change date

Line 185: hr_utility.set_location ('** SUP p_effective_date '||p_effective_date,10);

181: hr_utility.set_location ('Entering '||l_proc,10);
182: hr_utility.set_location ('p_elig_change_dt '||p_elig_change_dt,10);
183: hr_utility.set_location ('g_elig_change_dt '||g_elig_change_dt,10);
184: hr_utility.set_location ('g_effective_date '||g_effective_date,10);
185: hr_utility.set_location ('** SUP p_effective_date '||p_effective_date,10);
186: hr_utility.set_location ('g_dpnt_cvg_strt_dt '||g_dpnt_cvg_strt_dt,10);
187: --
188: -- If dpnt. coverage start date is specified then, the elig change date
189: -- cannot be before that.

Line 186: hr_utility.set_location ('g_dpnt_cvg_strt_dt '||g_dpnt_cvg_strt_dt,10);

182: hr_utility.set_location ('p_elig_change_dt '||p_elig_change_dt,10);
183: hr_utility.set_location ('g_elig_change_dt '||g_elig_change_dt,10);
184: hr_utility.set_location ('g_effective_date '||g_effective_date,10);
185: hr_utility.set_location ('** SUP p_effective_date '||p_effective_date,10);
186: hr_utility.set_location ('g_dpnt_cvg_strt_dt '||g_dpnt_cvg_strt_dt,10);
187: --
188: -- If dpnt. coverage start date is specified then, the elig change date
189: -- cannot be before that.
190: -- Additionally

Line 214: hr_utility.set_location ('fonm case: g_effective_date '||g_effective_date,11);

210: --
211: if (p_elig_change_dt <= p_effective_date) then
212: /* Bug 8856039: Even in FONM setup, the coverage end date should be based on life event occurred date */
213: if ben_manage_life_events.fonm = 'Y' then
214: hr_utility.set_location ('fonm case: g_effective_date '||g_effective_date,11);
215: g_elig_change_dt := g_effective_date - 1; -- life event occurred date - 1
216: else
217: g_elig_change_dt := p_elig_change_dt;
218: end if;

Line 225: hr_utility.set_location (' Setting g_elig_change_dt '||g_elig_change_dt,10);

221: end if;
222: --
223: -- End 6520270
224: --
225: hr_utility.set_location (' Setting g_elig_change_dt '||g_elig_change_dt,10);
226: end if;
227: --
228: hr_utility.set_location ('Leaving '||l_proc,10);
229: --

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

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

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

638:
639:
640: begin
641: --
642: hr_utility.set_location ('Entering '||l_proc,10);
643: --
644: -- Initialize the globals.
645: --
646: g_elig_change_dt := null;

Line 658: hr_utility.set_location ('Fonm Date '||g_effective_date ,10);

654: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
655: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
656:
657: --
658: hr_utility.set_location ('Fonm Date '||g_effective_date ,10);
659: end if;
660:
661: --
662: hr_utility.set_location ('p_contact_person_id '||to_char(p_contact_person_id),10);

Line 662: hr_utility.set_location ('p_contact_person_id '||to_char(p_contact_person_id),10);

658: hr_utility.set_location ('Fonm Date '||g_effective_date ,10);
659: end if;
660:
661: --
662: hr_utility.set_location ('p_contact_person_id '||to_char(p_contact_person_id),10);
663: hr_utility.set_location ('p_contact_relationship_id '||
664: to_char(p_contact_relationship_id),10);
665: hr_utility.set_location ('p_pgm_id:'||to_char(p_pgm_id)||
666: ' p_pl_id:'||to_char(p_pl_id)||' p_ptip_id:'||to_char(p_ptip_id)||

Line 663: hr_utility.set_location ('p_contact_relationship_id '||

659: end if;
660:
661: --
662: hr_utility.set_location ('p_contact_person_id '||to_char(p_contact_person_id),10);
663: hr_utility.set_location ('p_contact_relationship_id '||
664: to_char(p_contact_relationship_id),10);
665: hr_utility.set_location ('p_pgm_id:'||to_char(p_pgm_id)||
666: ' p_pl_id:'||to_char(p_pl_id)||' p_ptip_id:'||to_char(p_ptip_id)||
667: ' p_oipl_id:'||to_char(p_oipl_id),10);

Line 665: hr_utility.set_location ('p_pgm_id:'||to_char(p_pgm_id)||

661: --
662: hr_utility.set_location ('p_contact_person_id '||to_char(p_contact_person_id),10);
663: hr_utility.set_location ('p_contact_relationship_id '||
664: to_char(p_contact_relationship_id),10);
665: hr_utility.set_location ('p_pgm_id:'||to_char(p_pgm_id)||
666: ' p_pl_id:'||to_char(p_pl_id)||' p_ptip_id:'||to_char(p_ptip_id)||
667: ' p_oipl_id:'||to_char(p_oipl_id),10);
668:
669: --

Line 675: hr_utility.set_location ('Determining designation level ',20);

671: -- Not related to the particular person then use effective_date
672: --
673: -- g_elig_change_dt := nvl(p_lf_evt_ocrd_dt,p_effective_date)-1;
674: --
675: hr_utility.set_location ('Determining designation level ',20);
676:
677: if p_level is null then
678: if p_pgm_id is not null then
679: open c_pgm

Line 685: hr_utility.set_location ('BEN_91470_PGM_NOT_FOUND ',10);

681: );
682: fetch c_pgm into l_pgm;
683: if c_pgm%notfound then
684: close c_pgm;
685: hr_utility.set_location ('BEN_91470_PGM_NOT_FOUND ',10);
686: fnd_message.set_name('BEN','BEN_91470_PGM_NOT_FOUND');
687: fnd_message.set_token('PROC',l_proc);
688: fnd_message.set_token('PGM_ID',to_char(p_pgm_id));
689: fnd_message.raise_error;

Line 700: hr_utility.set_location ('l_level: '||l_level,20);

696: else
697: l_level := p_level;
698: end if;
699: --
700: hr_utility.set_location ('l_level: '||l_level,20);
701:
702: -- In order to find ptip eligibility profiles, this was added:
703: -- Bug 1167262
704: l_ptip.ptip_id := p_ptip_id;

Line 728: hr_utility.set_location ('BEN_91480_MISSING_CONTACT_REL ',10);

724: fetch c_contact into l_contact;
725: if c_contact%notfound then
726: --
727: close c_contact;
728: hr_utility.set_location ('BEN_91480_MISSING_CONTACT_REL ',10);
729: fnd_message.set_name('BEN','BEN_91480_MISSING_CONTACT_REL');
730: fnd_message.set_token('PROC',l_proc);
731: fnd_message.set_token('CONT_RLSHP_ID',to_char(p_contact_relationship_id));
732: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));

Line 763: hr_utility.set_location ('c_dsgn'||l_eligible_flag,20);

759: --
760: -- If there are no designation requirements for the comp object
761: -- then any number or type of dependents can be designated.
762: --
763: hr_utility.set_location ('c_dsgn'||l_eligible_flag,20);
764: --
765: open c_dsgn
766: (c_effective_date => l_effective_date
767: );

Line 780: hr_utility.set_location ('c_dsgn_rl_typ'||l_eligible_flag,20);

776: else
777: --
778: -- if there is a designation requirement for the contact_type.
779: --
780: hr_utility.set_location ('c_dsgn_rl_typ'||l_eligible_flag,20);
781: --
782: open c_dsgn_rl_typ
783: (c_effective_date => l_effective_date,
784: p_contact_type => l_contact.contact_type

Line 805: hr_utility.set_location ('c_dsgn_grp'||l_eligible_flag,20);

801: --
802: fetch c_dsgn_grp into l_exists;
803: if c_dsgn_grp%found then
804: --
805: hr_utility.set_location ('c_dsgn_grp'||l_eligible_flag,20);
806: l_eligible_flag := 'Y';
807: l_inelig_rsn_cd := null;
808: --
809: open c_dsgn_not_rl_typ

Line 816: hr_utility.set_location ('c_dsgn_not_rl_typ'||

812: --
813: fetch c_dsgn_not_rl_typ into l_exists;
814: if c_dsgn_not_rl_typ%found then
815: --
816: hr_utility.set_location ('c_dsgn_not_rl_typ'||
817: l_eligible_flag,20);
818: l_eligible_flag := 'N';
819: l_inelig_rsn_cd := 'REL';
820: --

Line 863: hr_utility.set_location ('eligible flag'||l_eligible_flag,30);

859: --
860: close c_contact2;
861: --
862: end if;
863: hr_utility.set_location ('eligible flag'||l_eligible_flag,30);
864: --
865: -- Loop through all profiles
866: --
867: if l_eligible_flag = 'Y' then

Line 868: hr_utility.set_location (l_proc||' l_eligible_flag=Y ',10);

864: --
865: -- Loop through all profiles
866: --
867: if l_eligible_flag = 'Y' then
868: hr_utility.set_location (l_proc||' l_eligible_flag=Y ',10);
869: --
870: -- Eventally call the cache
871: --
872: open c_per

Line 881: hr_utility.set_location ('BEN_91481_INVALID_PERSON ',10);

877: --
878: if c_per%notfound then
879: --
880: close c_per;
881: hr_utility.set_location ('BEN_91481_INVALID_PERSON ',10);
882: fnd_message.set_name('BEN','BEN_91481_INVALID_PERSON');
883: fnd_message.set_token('PROC',l_proc);
884: fnd_message.set_token('CONT_PER_ID',to_char(p_contact_person_id));
885: fnd_message.raise_error;

Line 903: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS ',10);

899: if c_add%notfound and
900: l_contact.rltd_per_rsds_w_dsgntr_flag='N' then
901: --
902: close c_add;
903: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS ',10);
904: fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
905: fnd_message.set_token('PROC',l_proc);
906: fnd_message.set_token('CONT_PER_ID',to_char(p_contact_person_id));
907: raise ben_manage_life_events.g_record_error;

Line 918: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS - c_add2 ',10);

914: );
915: --
916: fetch c_add2 into l_add;
917: if c_add2%notfound then
918: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS - c_add2 ',10);
919: fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
920: fnd_message.set_token('PROC',l_proc);
921: fnd_message.set_token('CONT_PER_ID',to_char(l_contact.person_id));
922: raise ben_manage_life_events.g_record_error;

Line 940: hr_utility.set_location (' g_elig_change_dt '||to_char(g_elig_change_dt),40);

936: -- overridden for postal elig for that case
937: --
938: -- g_elig_change_dt:=l_per.effective_start_date-1;
939: --
940: hr_utility.set_location (' g_elig_change_dt '||to_char(g_elig_change_dt),40);
941: open c_ade
942: (c_lvl => l_level
943: ,c_effective_date => l_effective_date
944: ,c_pgm_id => p_pgm_id

Line 977: hr_utility.set_location ('eligible flag'||l_eligible_flag,40);

973: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
974: p_eligible_flag => l_eligible_flag,
975: p_inelig_rsn_cd => l_inelig_rsn_cd);
976: --
977: hr_utility.set_location ('eligible flag'||l_eligible_flag,40);
978: exit when (l_ade.mndtry_flag = 'Y' and l_eligible_flag <> 'Y');
979: --
980: end if;
981: --

Line 1005: hr_utility.set_location ('eligible flag'||l_eligible_flag,80);

1001: set_elig_change_dt(p_elig_change_dt=>l_per.effective_start_date-1);
1002: end if;
1003: */
1004: --
1005: hr_utility.set_location ('eligible flag'||l_eligible_flag,80);
1006: exit when (l_ade.mndtry_flag = 'Y' and l_eligible_flag <> 'Y');
1007: --
1008: end if;
1009: --

Line 1099: --hr_utility.set_location('** SUP l_effective_date-1'||l_effective_date,900);

1095: --
1096: else
1097: --
1098: l_inelig_rsn_cd := 'AGE';
1099: --hr_utility.set_location('** SUP l_effective_date-1'||l_effective_date,900);
1100: set_elig_change_dt(p_elig_change_dt=>l_effective_date-1,p_effective_date => l_effective_date); -- bug 4546890
1101: --
1102: end if;
1103: --

Line 1134: --hr_utility.set_location('** SUP l_effective_date'||l_effective_date,901);

1130: --
1131: else
1132: --
1133: l_inelig_rsn_cd := 'AGE';
1134: --hr_utility.set_location('** SUP l_effective_date'||l_effective_date,901);
1135: set_elig_change_dt(p_elig_change_dt=>l_effective_date-1,p_effective_date => l_effective_date); -- bug 4546890
1136: --
1137: end if;
1138: --

Line 1147: hr_utility.set_location ('apld dep eligible flag'||l_apld_eligible_flag,50);

1143: exit when (l_ade.mndtry_flag = 'Y' and (l_eligible_flag <> 'Y' or l_apld_eligible_flag <> 'Y'));
1144: --
1145: end if;
1146: --
1147: hr_utility.set_location ('apld dep eligible flag'||l_apld_eligible_flag,50);
1148: --
1149: -- End 4271143
1150: --
1151: hr_utility.set_location ('eligible flag'||l_eligible_flag,50);

Line 1151: hr_utility.set_location ('eligible flag'||l_eligible_flag,50);

1147: hr_utility.set_location ('apld dep eligible flag'||l_apld_eligible_flag,50);
1148: --
1149: -- End 4271143
1150: --
1151: hr_utility.set_location ('eligible flag'||l_eligible_flag,50);
1152: --
1153: if l_ade.dpnt_mrtl_flag = 'Y' and
1154: l_eligible_flag = 'Y' then
1155: --

Line 1181: hr_utility.set_location ('eligible flag'||l_eligible_flag,50);

1177: exit when (l_ade.mndtry_flag = 'Y' and l_eligible_flag <> 'Y');
1178: --
1179: end if;
1180: --
1181: hr_utility.set_location ('eligible flag'||l_eligible_flag,50);
1182: --
1183: if l_ade.dpnt_mltry_flag = 'Y' and
1184: l_eligible_flag = 'Y' then
1185: --

Line 1211: hr_utility.set_location ('eligible flag'||l_eligible_flag,60);

1207: exit when (l_ade.mndtry_flag = 'Y' and l_eligible_flag <> 'Y');
1208: --
1209: end if;
1210: --
1211: hr_utility.set_location ('eligible flag'||l_eligible_flag,60);
1212: --
1213: if l_ade.dpnt_stud_flag = 'Y' and
1214: l_eligible_flag = 'Y' then
1215: --

Line 1237: hr_utility.set_location ('eligible flag'||l_eligible_flag,70);

1233: end if;
1234: close c_previous_per;
1235: end if;
1236: --
1237: hr_utility.set_location ('eligible flag'||l_eligible_flag,70);
1238: exit when (l_ade.mndtry_flag = 'Y' and l_eligible_flag <> 'Y');
1239: --
1240: end if;
1241: --

Line 1262: hr_utility.set_location ('eligible flag'||l_eligible_flag,80);

1258: if l_eligible_flag <> 'Y' then
1259: set_elig_change_dt(p_elig_change_dt=>l_per.effective_start_date-1);
1260: end if;
1261: --
1262: hr_utility.set_location ('eligible flag'||l_eligible_flag,80);
1263: exit when (l_ade.mndtry_flag = 'Y' and l_eligible_flag <> 'Y');
1264: --
1265: end if;
1266: */

Line 1292: hr_utility.set_location ('eligible flag'||l_eligible_flag,90);

1288: end if;
1289: close c_previous_per;
1290: end if;
1291: --
1292: hr_utility.set_location ('eligible flag'||l_eligible_flag,90);
1293: exit when (l_ade.mndtry_flag = 'Y' and l_eligible_flag <> 'Y');
1294: --
1295: end if;
1296: --

Line 1301: hr_utility.set_location('postal flag ', 219);

1297: if l_ade.dpnt_pstl_flag = 'Y' and
1298: l_eligible_flag = 'Y' then
1299: --- Beofre calling postal eligibility check whehter the address/share address is defined
1300: --
1301: hr_utility.set_location('postal flag ', 219);
1302: open c_add
1303: (c_effective_date => l_effective_date
1304: );
1305: --

Line 1310: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS ',10);

1306: fetch c_add into l_add;
1307: if c_add%notfound and l_contact.rltd_per_rsds_w_dsgntr_flag='N' then
1308: --
1309: --close c_add;
1310: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS ',10);
1311: hr_utility.set_location ('contact '|| l_contact.rltd_per_rsds_w_dsgntr_flag ,10);
1312: --fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
1313: --fnd_message.set_token('PROC',l_proc);
1314: --fnd_message.set_token('CONT_PER_ID',to_char(p_contact_person_id));

Line 1311: hr_utility.set_location ('contact '|| l_contact.rltd_per_rsds_w_dsgntr_flag ,10);

1307: if c_add%notfound and l_contact.rltd_per_rsds_w_dsgntr_flag='N' then
1308: --
1309: --close c_add;
1310: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS ',10);
1311: hr_utility.set_location ('contact '|| l_contact.rltd_per_rsds_w_dsgntr_flag ,10);
1312: --fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
1313: --fnd_message.set_token('PROC',l_proc);
1314: --fnd_message.set_token('CONT_PER_ID',to_char(p_contact_person_id));
1315: --raise ben_manage_life_events.g_record_error;

Line 1326: hr_utility.set_location ('contact '|| l_contact.rltd_per_rsds_w_dsgntr_flag ,10);

1322: --
1323: fetch c_add2 into l_add;
1324: if c_add2%notfound then
1325:
1326: hr_utility.set_location ('contact '|| l_contact.rltd_per_rsds_w_dsgntr_flag ,10);
1327: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS - c_add2 ',10);
1328: --fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
1329: --fnd_message.set_token('PROC',l_proc);
1330: --fnd_message.set_token('CONT_PER_ID',to_char(l_contact.person_id));

Line 1327: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS - c_add2 ',10);

1323: fetch c_add2 into l_add;
1324: if c_add2%notfound then
1325:
1326: hr_utility.set_location ('contact '|| l_contact.rltd_per_rsds_w_dsgntr_flag ,10);
1327: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS - c_add2 ',10);
1328: --fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
1329: --fnd_message.set_token('PROC',l_proc);
1330: --fnd_message.set_token('CONT_PER_ID',to_char(l_contact.person_id));
1331: --raise ben_manage_life_events.g_record_error;

Line 1341: hr_utility.set_location ('calling check_postal ' ,10);

1337: end if;
1338: --
1339: close c_add;
1340: --
1341: hr_utility.set_location ('calling check_postal ' ,10);
1342: check_postal_elig
1343: (p_eligy_prfl_id => l_ade.dpnt_cvg_eligy_prfl_id,
1344: p_person_id => p_contact_person_id,
1345: p_business_group_id => p_business_group_id,

Line 1361: hr_utility.set_location ('eligible flag'||l_eligible_flag,100);

1357: -- g_elig_change_dt:=l_add.date_from-1;
1358: --
1359: end if;
1360: --
1361: hr_utility.set_location ('eligible flag'||l_eligible_flag,100);
1362: exit when (l_ade.mndtry_flag = 'Y' and l_eligible_flag <> 'Y');
1363: --
1364: end if;
1365: --

Line 1384: hr_utility.set_location ('eligible flag'||l_eligible_flag,110);

1380: if l_eligible_flag <> 'Y' then
1381: set_elig_change_dt(p_elig_change_dt=>l_per.effective_start_date-1,p_effective_date => l_effective_date);-- bug 4546890
1382: end if;
1383: --
1384: hr_utility.set_location ('eligible flag'||l_eligible_flag,110);
1385: exit when (l_ade.mndtry_flag = 'Y' and l_eligible_flag <> 'Y');
1386: --
1387: end if;
1388:

Line 1408: hr_utility.set_location ('eligible flag'||l_eligible_flag,110);

1404: if l_eligible_flag <> 'Y' then
1405: set_elig_change_dt(p_elig_change_dt=>l_per.effective_start_date-1,p_effective_date => l_effective_date);-- bug 4546890
1406: end if;
1407: --
1408: hr_utility.set_location ('eligible flag'||l_eligible_flag,110);
1409: exit when (l_ade.mndtry_flag = 'Y' and l_eligible_flag <> 'Y');
1410: --
1411: end if;
1412: --

Line 1430: hr_utility.set_location ('eligible flag'||l_eligible_flag,40);

1426: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
1427: p_eligible_flag => l_eligible_flag,
1428: p_inelig_rsn_cd => l_inelig_rsn_cd);
1429: --
1430: hr_utility.set_location ('eligible flag'||l_eligible_flag,40);
1431: exit when (l_ade.mndtry_flag = 'Y' and l_eligible_flag <> 'Y');
1432: --
1433: end if;
1434: --

Line 1453: hr_utility.set_location ('eligible flag'||l_eligible_flag,110);

1449: if l_eligible_flag <> 'Y' then
1450: set_elig_change_dt(p_elig_change_dt=>l_per.effective_start_date-1,p_effective_date => l_effective_date); -- bug 4546890
1451: end if;
1452: --
1453: hr_utility.set_location ('eligible flag'||l_eligible_flag,110);
1454: exit when (l_ade.mndtry_flag = 'Y' and l_eligible_flag <> 'Y');
1455: --
1456: end if;
1457: --

Line 1467: hr_utility.set_location('eligible flag'||l_eligible_flag,115);

1463: --
1464: -- Bug 4271143 : Fetch from c_ade1 for records where no eligibility profile
1465: -- is attached, only dependent coverage eligibility rule is there
1466: --
1467: hr_utility.set_location('eligible flag'||l_eligible_flag,115);
1468: hr_utility.set_location ('apld dep eligible flag'||l_apld_eligible_flag,115);
1469: -- fetch only if till now all the profiles with mandatory flag on have been satisfied
1470: if (not(l_ade.mndtry_flag = 'Y' and (l_eligible_flag <> 'Y' or l_apld_eligible_flag <> 'Y'))) then
1471: open c_ade1

Line 1468: hr_utility.set_location ('apld dep eligible flag'||l_apld_eligible_flag,115);

1464: -- Bug 4271143 : Fetch from c_ade1 for records where no eligibility profile
1465: -- is attached, only dependent coverage eligibility rule is there
1466: --
1467: hr_utility.set_location('eligible flag'||l_eligible_flag,115);
1468: hr_utility.set_location ('apld dep eligible flag'||l_apld_eligible_flag,115);
1469: -- fetch only if till now all the profiles with mandatory flag on have been satisfied
1470: if (not(l_ade.mndtry_flag = 'Y' and (l_eligible_flag <> 'Y' or l_apld_eligible_flag <> 'Y'))) then
1471: open c_ade1
1472: (c_lvl => l_level

Line 1559: --hr_utility.set_location('** SUP l_effective_date-1'||l_effective_date,902);

1555: --
1556: else
1557: --
1558: l_inelig_rsn_cd := 'AGE';
1559: --hr_utility.set_location('** SUP l_effective_date-1'||l_effective_date,902);
1560: set_elig_change_dt(p_elig_change_dt=>l_effective_date-1,p_effective_date => l_effective_date); -- bug 4546890
1561: --
1562: end if;
1563: --

Line 1570: hr_utility.set_location ('apld dep eligible flag'||l_apld_eligible_flag,115);

1566: end if;
1567: --
1568: exit when (l_ade1.mndtry_flag = 'Y' and l_apld_eligible_flag <> 'Y');
1569: --
1570: hr_utility.set_location ('apld dep eligible flag'||l_apld_eligible_flag,115);
1571: end loop;
1572: close c_ade1;
1573: --
1574: end if;

Line 1590: hr_utility.set_location ('eligible flag'||l_eligible_flag,120);

1586: (p_elig_change_dt => l_effective_date-1,p_effective_date => l_effective_date); -- bug 4546890
1587: --
1588: end if;
1589: --
1590: hr_utility.set_location ('eligible flag'||l_eligible_flag,120);
1591: hr_utility.set_location ('apld eligible flag'||l_apld_eligible_flag,120);
1592: --
1593: if (l_apld_eligible_flag = 'N') then -- Bug 4271143
1594: l_eligible_flag := 'N';

Line 1591: hr_utility.set_location ('apld eligible flag'||l_apld_eligible_flag,120);

1587: --
1588: end if;
1589: --
1590: hr_utility.set_location ('eligible flag'||l_eligible_flag,120);
1591: hr_utility.set_location ('apld eligible flag'||l_apld_eligible_flag,120);
1592: --
1593: if (l_apld_eligible_flag = 'N') then -- Bug 4271143
1594: l_eligible_flag := 'N';
1595: end if;

Line 1600: hr_utility.set_location ('Leaving'||l_proc,130);

1596: --
1597: p_dependent_eligible_flag := l_eligible_flag;
1598: p_dpnt_inelig_rsn_cd := l_inelig_rsn_cd;
1599: --
1600: hr_utility.set_location ('Leaving'||l_proc,130);
1601: --
1602: end main;
1603: --
1604: procedure check_age_elig

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

1667: and eac.effective_end_date;
1668: --
1669: begin
1670: --
1671: hr_utility.set_location('Entering :'||l_proc, 10);
1672: hr_utility.set_location('PERSON ID :'||p_person_id, 10);
1673: hr_utility.set_location('BUSINESS_GROUP_ID :'||p_business_group_id, 10);
1674: hr_utility.set_location('EFFECTIVE_DATE :'||p_effective_date, 10);
1675: hr_utility.set_location('LIFE_EVENT_DATE :'||p_lf_evt_ocrd_dt, 10);

Line 1672: hr_utility.set_location('PERSON ID :'||p_person_id, 10);

1668: --
1669: begin
1670: --
1671: hr_utility.set_location('Entering :'||l_proc, 10);
1672: hr_utility.set_location('PERSON ID :'||p_person_id, 10);
1673: hr_utility.set_location('BUSINESS_GROUP_ID :'||p_business_group_id, 10);
1674: hr_utility.set_location('EFFECTIVE_DATE :'||p_effective_date, 10);
1675: hr_utility.set_location('LIFE_EVENT_DATE :'||p_lf_evt_ocrd_dt, 10);
1676: hr_utility.set_location('PROFILE_ID :'||p_eligy_prfl_id, 10);

Line 1673: hr_utility.set_location('BUSINESS_GROUP_ID :'||p_business_group_id, 10);

1669: begin
1670: --
1671: hr_utility.set_location('Entering :'||l_proc, 10);
1672: hr_utility.set_location('PERSON ID :'||p_person_id, 10);
1673: hr_utility.set_location('BUSINESS_GROUP_ID :'||p_business_group_id, 10);
1674: hr_utility.set_location('EFFECTIVE_DATE :'||p_effective_date, 10);
1675: hr_utility.set_location('LIFE_EVENT_DATE :'||p_lf_evt_ocrd_dt, 10);
1676: hr_utility.set_location('PROFILE_ID :'||p_eligy_prfl_id, 10);
1677: --

Line 1674: hr_utility.set_location('EFFECTIVE_DATE :'||p_effective_date, 10);

1670: --
1671: hr_utility.set_location('Entering :'||l_proc, 10);
1672: hr_utility.set_location('PERSON ID :'||p_person_id, 10);
1673: hr_utility.set_location('BUSINESS_GROUP_ID :'||p_business_group_id, 10);
1674: hr_utility.set_location('EFFECTIVE_DATE :'||p_effective_date, 10);
1675: hr_utility.set_location('LIFE_EVENT_DATE :'||p_lf_evt_ocrd_dt, 10);
1676: hr_utility.set_location('PROFILE_ID :'||p_eligy_prfl_id, 10);
1677: --
1678:

Line 1675: hr_utility.set_location('LIFE_EVENT_DATE :'||p_lf_evt_ocrd_dt, 10);

1671: hr_utility.set_location('Entering :'||l_proc, 10);
1672: hr_utility.set_location('PERSON ID :'||p_person_id, 10);
1673: hr_utility.set_location('BUSINESS_GROUP_ID :'||p_business_group_id, 10);
1674: hr_utility.set_location('EFFECTIVE_DATE :'||p_effective_date, 10);
1675: hr_utility.set_location('LIFE_EVENT_DATE :'||p_lf_evt_ocrd_dt, 10);
1676: hr_utility.set_location('PROFILE_ID :'||p_eligy_prfl_id, 10);
1677: --
1678:
1679: -- fonm

Line 1676: hr_utility.set_location('PROFILE_ID :'||p_eligy_prfl_id, 10);

1672: hr_utility.set_location('PERSON ID :'||p_person_id, 10);
1673: hr_utility.set_location('BUSINESS_GROUP_ID :'||p_business_group_id, 10);
1674: hr_utility.set_location('EFFECTIVE_DATE :'||p_effective_date, 10);
1675: hr_utility.set_location('LIFE_EVENT_DATE :'||p_lf_evt_ocrd_dt, 10);
1676: hr_utility.set_location('PROFILE_ID :'||p_eligy_prfl_id, 10);
1677: --
1678:
1679: -- fonm
1680: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;

Line 1688: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

1684: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
1685: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
1686:
1687: --
1688: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);
1689: end if;
1690:
1691:
1692:

Line 1701: hr_utility.set_location('HERE',10);

1697: -- If person does not have a date of birth then he/she
1698: -- is not eligible.
1699: --
1700: if l_check_dob = true then
1701: hr_utility.set_location('HERE',10);
1702: open c_per;
1703: fetch c_per into l_dob;
1704: close c_per;
1705: if l_dob is null then

Line 1722: hr_utility.set_location('XXXX AGE = '||l_age,10);

1718: elsif l_pl_id is not null then
1719: l_pgm_id := null;
1720: end if;
1721: --
1722: hr_utility.set_location('XXXX AGE = '||l_age,10);
1723: hr_utility.set_location('XXXX DOB = '||l_dob,10);
1724: hr_utility.set_location('XXXX MIN = '||age.mn_age_num,10);
1725: hr_utility.set_location('XXXX MAX = '||age.mx_age_num,10);
1726: hr_utility.set_location('XXXX EXCLD = '||age.excld_flag,10);

Line 1723: hr_utility.set_location('XXXX DOB = '||l_dob,10);

1719: l_pgm_id := null;
1720: end if;
1721: --
1722: hr_utility.set_location('XXXX AGE = '||l_age,10);
1723: hr_utility.set_location('XXXX DOB = '||l_dob,10);
1724: hr_utility.set_location('XXXX MIN = '||age.mn_age_num,10);
1725: hr_utility.set_location('XXXX MAX = '||age.mx_age_num,10);
1726: hr_utility.set_location('XXXX EXCLD = '||age.excld_flag,10);
1727: --

Line 1724: hr_utility.set_location('XXXX MIN = '||age.mn_age_num,10);

1720: end if;
1721: --
1722: hr_utility.set_location('XXXX AGE = '||l_age,10);
1723: hr_utility.set_location('XXXX DOB = '||l_dob,10);
1724: hr_utility.set_location('XXXX MIN = '||age.mn_age_num,10);
1725: hr_utility.set_location('XXXX MAX = '||age.mx_age_num,10);
1726: hr_utility.set_location('XXXX EXCLD = '||age.excld_flag,10);
1727: --
1728: ben_derive_factors.determine_age

Line 1725: hr_utility.set_location('XXXX MAX = '||age.mx_age_num,10);

1721: --
1722: hr_utility.set_location('XXXX AGE = '||l_age,10);
1723: hr_utility.set_location('XXXX DOB = '||l_dob,10);
1724: hr_utility.set_location('XXXX MIN = '||age.mn_age_num,10);
1725: hr_utility.set_location('XXXX MAX = '||age.mx_age_num,10);
1726: hr_utility.set_location('XXXX EXCLD = '||age.excld_flag,10);
1727: --
1728: ben_derive_factors.determine_age
1729: (p_person_id => p_person_id ,

Line 1726: hr_utility.set_location('XXXX EXCLD = '||age.excld_flag,10);

1722: hr_utility.set_location('XXXX AGE = '||l_age,10);
1723: hr_utility.set_location('XXXX DOB = '||l_dob,10);
1724: hr_utility.set_location('XXXX MIN = '||age.mn_age_num,10);
1725: hr_utility.set_location('XXXX MAX = '||age.mx_age_num,10);
1726: hr_utility.set_location('XXXX EXCLD = '||age.excld_flag,10);
1727: --
1728: ben_derive_factors.determine_age
1729: (p_person_id => p_person_id ,
1730: p_per_dob => l_dob,

Line 1745: hr_utility.set_location('XXXX AGE = '||l_age,10);

1741: p_change_date => l_change_date,
1742: p_parent_person_id => p_contact_person_id,
1743: p_fonm_cvg_strt_dt => l_fonm_cvg_strt_dt );
1744: --
1745: hr_utility.set_location('XXXX AGE = '||l_age,10);
1746: hr_utility.set_location('XXXX DOB = '||l_dob,10);
1747: hr_utility.set_location('XXXX DOB = '||l_change_date,1965);
1748: hr_utility.set_location('XXXX MIN = '||age.mn_age_num,10);
1749: hr_utility.set_location('XXXX MAX = '||age.mx_age_num,10);

Line 1746: hr_utility.set_location('XXXX DOB = '||l_dob,10);

1742: p_parent_person_id => p_contact_person_id,
1743: p_fonm_cvg_strt_dt => l_fonm_cvg_strt_dt );
1744: --
1745: hr_utility.set_location('XXXX AGE = '||l_age,10);
1746: hr_utility.set_location('XXXX DOB = '||l_dob,10);
1747: hr_utility.set_location('XXXX DOB = '||l_change_date,1965);
1748: hr_utility.set_location('XXXX MIN = '||age.mn_age_num,10);
1749: hr_utility.set_location('XXXX MAX = '||age.mx_age_num,10);
1750: hr_utility.set_location('XXXX EXCLD = '||age.excld_flag,10);

Line 1747: hr_utility.set_location('XXXX DOB = '||l_change_date,1965);

1743: p_fonm_cvg_strt_dt => l_fonm_cvg_strt_dt );
1744: --
1745: hr_utility.set_location('XXXX AGE = '||l_age,10);
1746: hr_utility.set_location('XXXX DOB = '||l_dob,10);
1747: hr_utility.set_location('XXXX DOB = '||l_change_date,1965);
1748: hr_utility.set_location('XXXX MIN = '||age.mn_age_num,10);
1749: hr_utility.set_location('XXXX MAX = '||age.mx_age_num,10);
1750: hr_utility.set_location('XXXX EXCLD = '||age.excld_flag,10);
1751: hr_utility.set_location (' age chek in dep elig ' , 610);

Line 1748: hr_utility.set_location('XXXX MIN = '||age.mn_age_num,10);

1744: --
1745: hr_utility.set_location('XXXX AGE = '||l_age,10);
1746: hr_utility.set_location('XXXX DOB = '||l_dob,10);
1747: hr_utility.set_location('XXXX DOB = '||l_change_date,1965);
1748: hr_utility.set_location('XXXX MIN = '||age.mn_age_num,10);
1749: hr_utility.set_location('XXXX MAX = '||age.mx_age_num,10);
1750: hr_utility.set_location('XXXX EXCLD = '||age.excld_flag,10);
1751: hr_utility.set_location (' age chek in dep elig ' , 610);
1752: --Bug 2101937 we need to test the max limit differently for

Line 1749: hr_utility.set_location('XXXX MAX = '||age.mx_age_num,10);

1745: hr_utility.set_location('XXXX AGE = '||l_age,10);
1746: hr_utility.set_location('XXXX DOB = '||l_dob,10);
1747: hr_utility.set_location('XXXX DOB = '||l_change_date,1965);
1748: hr_utility.set_location('XXXX MIN = '||age.mn_age_num,10);
1749: hr_utility.set_location('XXXX MAX = '||age.mx_age_num,10);
1750: hr_utility.set_location('XXXX EXCLD = '||age.excld_flag,10);
1751: hr_utility.set_location (' age chek in dep elig ' , 610);
1752: --Bug 2101937 we need to test the max limit differently for
1753: --whole numbers and decimal numbers.

Line 1750: hr_utility.set_location('XXXX EXCLD = '||age.excld_flag,10);

1746: hr_utility.set_location('XXXX DOB = '||l_dob,10);
1747: hr_utility.set_location('XXXX DOB = '||l_change_date,1965);
1748: hr_utility.set_location('XXXX MIN = '||age.mn_age_num,10);
1749: hr_utility.set_location('XXXX MAX = '||age.mx_age_num,10);
1750: hr_utility.set_location('XXXX EXCLD = '||age.excld_flag,10);
1751: hr_utility.set_location (' age chek in dep elig ' , 610);
1752: --Bug 2101937 we need to test the max limit differently for
1753: --whole numbers and decimal numbers.
1754: --if the age_max_num is a whole number we need to take age_max_num + 1

Line 1751: hr_utility.set_location (' age chek in dep elig ' , 610);

1747: hr_utility.set_location('XXXX DOB = '||l_change_date,1965);
1748: hr_utility.set_location('XXXX MIN = '||age.mn_age_num,10);
1749: hr_utility.set_location('XXXX MAX = '||age.mx_age_num,10);
1750: hr_utility.set_location('XXXX EXCLD = '||age.excld_flag,10);
1751: hr_utility.set_location (' age chek in dep elig ' , 610);
1752: --Bug 2101937 we need to test the max limit differently for
1753: --whole numbers and decimal numbers.
1754: --if the age_max_num is a whole number we need to take age_max_num + 1
1755: --else we need to take the age_max_num + 0.00000001

Line 1791: hr_utility.set_location (' passed age chekc in dep elig ' , 610);

1787: if ((l_age >= age.mn_age_num and l_age < l_max_age_number)
1788: or (age.no_mn_age_flag = 'Y' and l_age < l_max_age_number)
1789: or (age.no_mx_age_flag = 'Y' and l_age >= age.mn_age_num) ) then
1790:
1791: hr_utility.set_location (' passed age chekc in dep elig ' , 610);
1792: --
1793: if age.excld_flag = 'Y' then
1794: --
1795: -- exclude means if the criteria matches, the person is not eligible

Line 1816: hr_utility.set_location('l_elig_change_dt :'||l_elig_change_dt, 5);

1812: p_max => age.mx_age_num,
1813: p_value => 'GT_MIN') - 1;
1814: end if;
1815: --
1816: hr_utility.set_location('l_elig_change_dt :'||l_elig_change_dt, 5);
1817: --
1818: set_elig_change_dt(p_elig_change_dt => l_elig_change_dt,p_effective_date => l_effective_date); -- bug 4546890
1819: exit;
1820: --

Line 1854: hr_utility.set_location('l_elig_change_dt :'||l_elig_change_dt, 10);

1850: p_max => age.mx_age_num,
1851: p_value => 'GT_MAX') - 1;
1852: end if;
1853:
1854: hr_utility.set_location('l_elig_change_dt :'||l_elig_change_dt, 10);
1855:
1856: set_elig_change_dt(p_elig_change_dt => l_elig_change_dt,p_effective_date => l_effective_date); -- bug 4546890
1857: --
1858: end if;

Line 1872: hr_utility.set_location('l_elig :'||l_elig, 10);

1868: l_elig := 'Y';
1869: --
1870: end if;
1871: --
1872: hr_utility.set_location('l_elig :'||l_elig, 10);
1873: p_eligible_flag := l_elig;
1874: --
1875: if l_elig = 'Y' then
1876: p_inelig_rsn_cd := null;

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

1877: else
1878: p_inelig_rsn_cd := 'AGE';
1879: end if;
1880: --
1881: hr_utility.set_location('Leaving :'||l_proc, 20);
1882: --
1883: end check_age_elig;
1884: --
1885: procedure check_marital_elig

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

1916: l_ems c_ems%rowtype;
1917: --
1918: begin
1919: --
1920: hr_utility.set_location('Entering: '||l_proc,10);
1921: --
1922:
1923: -- fonm
1924: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;

Line 1932: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

1928: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
1929: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
1930:
1931: --
1932: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);
1933: end if;
1934:
1935:
1936: open c_ems;

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

1962: else
1963: p_inelig_rsn_cd := 'MRT';
1964: end if;
1965: --
1966: hr_utility.set_location('Leaving: '||l_proc,20);
1967: --
1968: end check_marital_elig;
1969: --
1970: procedure check_military_elig

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

2001: l_emc c_emc%rowtype;
2002: --
2003: begin
2004: --
2005: hr_utility.set_location('Entering: '||l_proc,10);
2006: --
2007: -- fonm
2008: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2009: if ben_manage_life_events.fonm = 'Y'

Line 2016: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

2012: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2013: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2014:
2015: --
2016: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);
2017: end if;
2018:
2019:
2020: open c_emc;

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

2046: else
2047: p_inelig_rsn_cd := 'MLT';
2048: end if;
2049: --
2050: hr_utility.set_location('Leaving: '||l_proc,20);
2051: --
2052: end check_military_elig;
2053: --
2054: procedure check_student_elig

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

2085: l_esc c_esc%rowtype;
2086: --
2087: begin
2088: --
2089: hr_utility.set_location('Entering: '||l_proc,10);
2090: --
2091: -- fonm
2092: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2093: if ben_manage_life_events.fonm = 'Y'

Line 2100: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

2096: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2097: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2098:
2099: --
2100: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);
2101: end if;
2102:
2103:
2104: open c_esc;

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

2130: else
2131: p_inelig_rsn_cd := 'STU';
2132: end if;
2133: --
2134: hr_utility.set_location('Leaving: '||l_proc,20);
2135: --
2136: end check_student_elig;
2137: --
2138: procedure check_contact_elig

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

2182: l_dcr c_dcr%rowtype;
2183: --
2184: begin
2185: --
2186: hr_utility.set_location('Entering: '||l_proc,10);
2187: --
2188: -- fonm
2189: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2190: if ben_manage_life_events.fonm = 'Y'

Line 2197: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

2193: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2194: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2195:
2196: --
2197: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);
2198: end if;
2199:
2200:
2201: open c_dcr;

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

2235: else
2236: p_inelig_rsn_cd := 'REL';
2237: end if;
2238: --
2239: hr_utility.set_location('Leaving: '||l_proc,20);
2240: --
2241: end check_contact_elig;
2242: --
2243: procedure check_disabled_elig

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

2273: l_edc c_edc%rowtype;
2274: --
2275: begin
2276: --
2277: hr_utility.set_location('Entering: '||l_proc,10);
2278: hr_utility.set_location('*** SUP in Check disability p_effective_date '|| p_effective_date,10);
2279:
2280: --
2281: -- fonm

Line 2278: hr_utility.set_location('*** SUP in Check disability p_effective_date '|| p_effective_date,10);

2274: --
2275: begin
2276: --
2277: hr_utility.set_location('Entering: '||l_proc,10);
2278: hr_utility.set_location('*** SUP in Check disability p_effective_date '|| p_effective_date,10);
2279:
2280: --
2281: -- fonm
2282: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;

Line 2290: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

2286: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2287: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2288:
2289: --
2290: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);
2291: end if;
2292:
2293:
2294: open c_edc;

Line 2324: hr_utility.set_location('** sup in disability check p_eligible_flag '||p_eligible_flag,200);

2320: else
2321: p_inelig_rsn_cd := 'DSB';
2322: end if;
2323: --
2324: hr_utility.set_location('** sup in disability check p_eligible_flag '||p_eligible_flag,200);
2325: hr_utility.set_location('Leaving: '||l_proc,20);
2326: --
2327: end check_disabled_elig;
2328: --

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

2321: p_inelig_rsn_cd := 'DSB';
2322: end if;
2323: --
2324: hr_utility.set_location('** sup in disability check p_eligible_flag '||p_eligible_flag,200);
2325: hr_utility.set_location('Leaving: '||l_proc,20);
2326: --
2327: end check_disabled_elig;
2328: --
2329: procedure check_postal_elig

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

2370: l_len number ;
2371: --
2372: begin
2373: --
2374: hr_utility.set_location('Entering : '||l_proc,10);
2375: --
2376: -- fonm
2377: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2378: if ben_manage_life_events.fonm = 'Y'

Line 2385: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

2381: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2382: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2383:
2384: --
2385: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);
2386: end if;
2387:
2388:
2389: open c_zip_code_rng;

Line 2397: hr_utility.set_location('Found zip criteria. from:'||

2393: fetch c_zip_code_rng into l_zip;
2394: exit when c_zip_code_rng%notfound;
2395: --
2396: l_found_one := 'Y';
2397: hr_utility.set_location('Found zip criteria. from:'||
2398: l_zip.from_value||' to:'||
2399: l_zip.to_value||' '||p_postal_code,2219.2);
2400:
2401: l_len := length(nvl(l_zip.from_value,'00000')) ;

Line 2403: hr_utility.set_location(' len ' || l_len , 2219.2);

2399: l_zip.to_value||' '||p_postal_code,2219.2);
2400:
2401: l_len := length(nvl(l_zip.from_value,'00000')) ;
2402: --
2403: hr_utility.set_location(' len ' || l_len , 2219.2);
2404: ---
2405: if nvl( length(p_postal_code) >= length(l_zip.from_value) and
2406: (substr(nvl(p_postal_code,'-1'),1,l_len )
2407: between nvl(l_zip.from_value,'00000') and

Line 2409: hr_utility.set_location('result true ' ,2219.2);

2405: if nvl( length(p_postal_code) >= length(l_zip.from_value) and
2406: (substr(nvl(p_postal_code,'-1'),1,l_len )
2407: between nvl(l_zip.from_value,'00000') and
2408: nvl(l_zip.to_value,nvl(p_postal_code,'-1'))),false) then
2409: hr_utility.set_location('result true ' ,2219.2);
2410: --
2411: if l_zip.excld_flag = 'Y' then
2412: -- exclude means if the criteria matches, the person is not eligible
2413: l_elig := 'N';

Line 2414: hr_utility.set_location(' l_elig := No ',99);

2410: --
2411: if l_zip.excld_flag = 'Y' then
2412: -- exclude means if the criteria matches, the person is not eligible
2413: l_elig := 'N';
2414: hr_utility.set_location(' l_elig := No ',99);
2415: exit;
2416: --
2417: else -- l_zip.excld_flag = 'N'
2418: -- one criteria instance passed, leave.

Line 2420: hr_utility.set_location(' l_elig := yes ',99);

2416: --
2417: else -- l_zip.excld_flag = 'N'
2418: -- one criteria instance passed, leave.
2419: l_elig := 'Y';
2420: hr_utility.set_location(' l_elig := yes ',99);
2421: exit;
2422: --
2423: end if;
2424: --

Line 2427: hr_utility.set_location('No Match and exclude is yes ' ,99);

2423: end if;
2424: --
2425: elsif l_zip.excld_flag = 'Y' then -- No Match and exclude is 'Y' case
2426: --
2427: hr_utility.set_location('No Match and exclude is yes ' ,99);
2428: l_elig := 'Y';
2429: -- exit;
2430: --
2431: end if;

Line 2435: hr_utility.set_location(' l_elig '||l_elig ,99);

2431: end if;
2432: -- one criteria instance failed. keep going to check others.
2433: end loop;
2434: --
2435: hr_utility.set_location(' l_elig '||l_elig ,99);
2436: if l_found_one = 'N' then
2437: --
2438: -- No criteria passes
2439: --

Line 2454: hr_utility.set_location(' l_elig '||l_elig ,100);

2450: else
2451: p_inelig_rsn_cd := 'ZIP';
2452: end if;
2453: --
2454: hr_utility.set_location(' l_elig '||l_elig ,100);
2455: hr_utility.set_location('Leaving: '||l_proc,20);
2456: --
2457: end check_postal_elig;
2458: --

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

2451: p_inelig_rsn_cd := 'ZIP';
2452: end if;
2453: --
2454: hr_utility.set_location(' l_elig '||l_elig ,100);
2455: hr_utility.set_location('Leaving: '||l_proc,20);
2456: --
2457: end check_postal_elig;
2458: --
2459: procedure check_cvrd_anthr_pl_elig

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

2511: l_dpc c_get_cvrd_anthr_pl%rowtype;
2512: --
2513: begin
2514: --
2515: hr_utility.set_location('Entering: '||l_proc,10);
2516: --
2517: -- fonm
2518: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2519: if ben_manage_life_events.fonm = 'Y'

Line 2526: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

2522: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2523: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2524:
2525: --
2526: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);
2527: end if;
2528:
2529:
2530: open c_get_cvrd_anthr_pl;

Line 2556: hr_utility.set_location ('Found c_get_elig_cvrd_dpnt '||l_dpc.excld_flag,34634611);

2552: -- If the dependent is covered under the plan
2553: -- and the exclude flag is set to 'Y' then he/she
2554: -- is not eligible.
2555: --
2556: hr_utility.set_location ('Found c_get_elig_cvrd_dpnt '||l_dpc.excld_flag,34634611);
2557: if l_dpc.excld_flag = 'Y' then
2558: l_elig := 'N';
2559: exit ;
2560: else

Line 2571: hr_utility.set_location ('Not Found c_get_elig_cvrd_dpnt '||l_dpc.excld_flag,34634611);

2567: --
2568: -- If the dependent is not covered under plan and the
2569: -- exclude flag is set to 'Y', then the he/she is eligible.
2570: --
2571: hr_utility.set_location ('Not Found c_get_elig_cvrd_dpnt '||l_dpc.excld_flag,34634611);
2572: if l_dpc.excld_flag = 'N' then
2573: l_elig := 'N';
2574: else
2575: l_elig := 'Y' ;

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

2588: else
2589: p_inelig_rsn_cd := 'CVP';
2590: end if;
2591: --
2592: hr_utility.set_location('Leaving: '||l_proc,20);
2593:
2594: --
2595: end check_cvrd_anthr_pl_elig;
2596: --

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

2638:
2639: --
2640: begin
2641: --
2642: hr_utility.set_location('Entering: '||l_proc,10);
2643: hr_utility.set_location('eligy_prfl: '||p_eligy_prfl_id,10);
2644: hr_utility.set_location('dsgntr_id: '||p_dsgntr_id,10);
2645: --
2646: -- fonm

Line 2643: hr_utility.set_location('eligy_prfl: '||p_eligy_prfl_id,10);

2639: --
2640: begin
2641: --
2642: hr_utility.set_location('Entering: '||l_proc,10);
2643: hr_utility.set_location('eligy_prfl: '||p_eligy_prfl_id,10);
2644: hr_utility.set_location('dsgntr_id: '||p_dsgntr_id,10);
2645: --
2646: -- fonm
2647: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;

Line 2644: hr_utility.set_location('dsgntr_id: '||p_dsgntr_id,10);

2640: begin
2641: --
2642: hr_utility.set_location('Entering: '||l_proc,10);
2643: hr_utility.set_location('eligy_prfl: '||p_eligy_prfl_id,10);
2644: hr_utility.set_location('dsgntr_id: '||p_dsgntr_id,10);
2645: --
2646: -- fonm
2647: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2648: if ben_manage_life_events.fonm = 'Y'

Line 2655: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

2651: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2652: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2653:
2654: --
2655: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);
2656: end if;
2657:
2658:
2659: open c_get_dsgntr_enrld_cvg;

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

2693: else
2694: p_inelig_rsn_cd := 'DEG';
2695: end if;
2696: --
2697: hr_utility.set_location('Leaving: '||l_proc,20);
2698: --
2699: end check_dsgntr_enrld_cvg_elig;
2700: --
2701: function get_elig_change_dt return date is