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
1215: fetch c_prtt_result into l_prtt_result;
1216: if c_prtt_result%notfound then
1217: --
1218: close c_prtt_result;
1219: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1220: fnd_message.set_token('PROC',l_proc);
1221: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1222: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1223: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1216: if c_prtt_result%notfound then
1217: --
1218: close c_prtt_result;
1219: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1220: fnd_message.set_token('PROC',l_proc);
1221: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1222: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1223: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1224: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1217: --
1218: close c_prtt_result;
1219: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1220: fnd_message.set_token('PROC',l_proc);
1221: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1222: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1223: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1224: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1225: fnd_message.raise_error;
1218: close c_prtt_result;
1219: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1220: fnd_message.set_token('PROC',l_proc);
1221: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1222: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1223: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1224: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1225: fnd_message.raise_error;
1226: --
1219: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1220: fnd_message.set_token('PROC',l_proc);
1221: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1222: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1223: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1224: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1225: fnd_message.raise_error;
1226: --
1227: end if;
1220: fnd_message.set_token('PROC',l_proc);
1221: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1222: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1223: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1224: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1225: fnd_message.raise_error;
1226: --
1227: end if;
1228: --
1221: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1222: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1223: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1224: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1225: fnd_message.raise_error;
1226: --
1227: end if;
1228: --
1229: close c_prtt_result;
1510: fetch c_prtt_result into l_prtt_result;
1511: if c_prtt_result%notfound then
1512: --
1513: close c_prtt_result;
1514: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1515: fnd_message.set_token('PROC',l_proc);
1516: fnd_message.set_token('ID',l_prtt_enrt_rslt_id); -- l_choice_info.prtt_enrt_rslt_id);
1517: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1518: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1511: if c_prtt_result%notfound then
1512: --
1513: close c_prtt_result;
1514: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1515: fnd_message.set_token('PROC',l_proc);
1516: fnd_message.set_token('ID',l_prtt_enrt_rslt_id); -- l_choice_info.prtt_enrt_rslt_id);
1517: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1518: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1519: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1512: --
1513: close c_prtt_result;
1514: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1515: fnd_message.set_token('PROC',l_proc);
1516: fnd_message.set_token('ID',l_prtt_enrt_rslt_id); -- l_choice_info.prtt_enrt_rslt_id);
1517: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1518: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1519: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1520: fnd_message.raise_error;
1513: close c_prtt_result;
1514: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1515: fnd_message.set_token('PROC',l_proc);
1516: fnd_message.set_token('ID',l_prtt_enrt_rslt_id); -- l_choice_info.prtt_enrt_rslt_id);
1517: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1518: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1519: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1520: fnd_message.raise_error;
1521: --
1514: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1515: fnd_message.set_token('PROC',l_proc);
1516: fnd_message.set_token('ID',l_prtt_enrt_rslt_id); -- l_choice_info.prtt_enrt_rslt_id);
1517: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1518: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1519: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1520: fnd_message.raise_error;
1521: --
1522: else
1515: fnd_message.set_token('PROC',l_proc);
1516: fnd_message.set_token('ID',l_prtt_enrt_rslt_id); -- l_choice_info.prtt_enrt_rslt_id);
1517: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1518: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1519: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1520: fnd_message.raise_error;
1521: --
1522: else
1523: --
1516: fnd_message.set_token('ID',l_prtt_enrt_rslt_id); -- l_choice_info.prtt_enrt_rslt_id);
1517: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1518: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1519: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1520: fnd_message.raise_error;
1521: --
1522: else
1523: --
1524: l_choice_info.enrt_cvg_strt_dt := l_prtt_result.enrt_cvg_strt_dt;