696: hr_utility.set_location('Reinstating dependent in loop ',99);
697: hr_utility.set_location('p_dpnt_cvg_strt_dt_cd '|| p_dpnt_cvg_strt_dt_cd,99);
698: if p_dpnt_cvg_strt_dt_cd is null then
699: --
700: fnd_message.set_name('BEN','BEN_92558_DPNT_CVG_CD');
701: fnd_message.raise_error;
702: --
703: end if;
704: --
697: hr_utility.set_location('p_dpnt_cvg_strt_dt_cd '|| p_dpnt_cvg_strt_dt_cd,99);
698: if p_dpnt_cvg_strt_dt_cd is null then
699: --
700: fnd_message.set_name('BEN','BEN_92558_DPNT_CVG_CD');
701: fnd_message.raise_error;
702: --
703: end if;
704: --
705: -- Calculate Dependents Coverage Start Date
1211: fetch c_prtt_result into l_prtt_result;
1212: if c_prtt_result%notfound then
1213: --
1214: close c_prtt_result;
1215: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1216: fnd_message.set_token('PROC',l_proc);
1217: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1218: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1219: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1212: if c_prtt_result%notfound then
1213: --
1214: close c_prtt_result;
1215: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1216: fnd_message.set_token('PROC',l_proc);
1217: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1218: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1219: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1220: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1213: --
1214: close c_prtt_result;
1215: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1216: fnd_message.set_token('PROC',l_proc);
1217: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1218: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1219: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1220: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1221: fnd_message.raise_error;
1214: close c_prtt_result;
1215: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1216: fnd_message.set_token('PROC',l_proc);
1217: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1218: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1219: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1220: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1221: fnd_message.raise_error;
1222: --
1215: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1216: fnd_message.set_token('PROC',l_proc);
1217: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1218: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1219: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1220: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1221: fnd_message.raise_error;
1222: --
1223: end if;
1216: fnd_message.set_token('PROC',l_proc);
1217: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1218: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1219: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1220: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1221: fnd_message.raise_error;
1222: --
1223: end if;
1224: --
1217: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1218: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1219: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1220: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1221: fnd_message.raise_error;
1222: --
1223: end if;
1224: --
1225: close c_prtt_result;
1495: fetch c_prtt_result into l_prtt_result;
1496: if c_prtt_result%notfound then
1497: --
1498: close c_prtt_result;
1499: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1500: fnd_message.set_token('PROC',l_proc);
1501: fnd_message.set_token('ID',l_prtt_enrt_rslt_id); -- l_choice_info.prtt_enrt_rslt_id);
1502: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1503: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1496: if c_prtt_result%notfound then
1497: --
1498: close c_prtt_result;
1499: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1500: fnd_message.set_token('PROC',l_proc);
1501: fnd_message.set_token('ID',l_prtt_enrt_rslt_id); -- l_choice_info.prtt_enrt_rslt_id);
1502: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1503: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1504: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1497: --
1498: close c_prtt_result;
1499: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1500: fnd_message.set_token('PROC',l_proc);
1501: fnd_message.set_token('ID',l_prtt_enrt_rslt_id); -- l_choice_info.prtt_enrt_rslt_id);
1502: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1503: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1504: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1505: fnd_message.raise_error;
1498: close c_prtt_result;
1499: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1500: fnd_message.set_token('PROC',l_proc);
1501: fnd_message.set_token('ID',l_prtt_enrt_rslt_id); -- l_choice_info.prtt_enrt_rslt_id);
1502: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1503: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1504: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1505: fnd_message.raise_error;
1506: --
1499: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1500: fnd_message.set_token('PROC',l_proc);
1501: fnd_message.set_token('ID',l_prtt_enrt_rslt_id); -- l_choice_info.prtt_enrt_rslt_id);
1502: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1503: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1504: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1505: fnd_message.raise_error;
1506: --
1507: else
1500: fnd_message.set_token('PROC',l_proc);
1501: fnd_message.set_token('ID',l_prtt_enrt_rslt_id); -- l_choice_info.prtt_enrt_rslt_id);
1502: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1503: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1504: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1505: fnd_message.raise_error;
1506: --
1507: else
1508: --
1501: fnd_message.set_token('ID',l_prtt_enrt_rslt_id); -- l_choice_info.prtt_enrt_rslt_id);
1502: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1503: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1504: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1505: fnd_message.raise_error;
1506: --
1507: else
1508: --
1509: l_choice_info.enrt_cvg_strt_dt := l_prtt_result.enrt_cvg_strt_dt;