404: hr_utility.set_location('Reinstating dependent in loop ',99);
405: hr_utility.set_location('p_dpnt_cvg_strt_dt_cd '|| p_dpnt_cvg_strt_dt_cd,99);
406: if p_dpnt_cvg_strt_dt_cd is null then
407: --
408: fnd_message.set_name('BEN','BEN_92558_DPNT_CVG_CD');
409: fnd_message.raise_error;
410: --
411: end if;
412: --
405: hr_utility.set_location('p_dpnt_cvg_strt_dt_cd '|| p_dpnt_cvg_strt_dt_cd,99);
406: if p_dpnt_cvg_strt_dt_cd is null then
407: --
408: fnd_message.set_name('BEN','BEN_92558_DPNT_CVG_CD');
409: fnd_message.raise_error;
410: --
411: end if;
412: --
413: -- Calculate Dependents Coverage Start Date
882: fetch c_prtt_result into l_prtt_result;
883: if c_prtt_result%notfound then
884: --
885: close c_prtt_result;
886: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
887: fnd_message.set_token('PROC',l_proc);
888: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
889: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
890: fnd_message.set_token('LER_ID',to_char(p_ler_id));
883: if c_prtt_result%notfound then
884: --
885: close c_prtt_result;
886: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
887: fnd_message.set_token('PROC',l_proc);
888: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
889: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
890: fnd_message.set_token('LER_ID',to_char(p_ler_id));
891: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
884: --
885: close c_prtt_result;
886: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
887: fnd_message.set_token('PROC',l_proc);
888: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
889: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
890: fnd_message.set_token('LER_ID',to_char(p_ler_id));
891: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
892: fnd_message.raise_error;
885: close c_prtt_result;
886: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
887: fnd_message.set_token('PROC',l_proc);
888: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
889: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
890: fnd_message.set_token('LER_ID',to_char(p_ler_id));
891: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
892: fnd_message.raise_error;
893: --
886: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
887: fnd_message.set_token('PROC',l_proc);
888: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
889: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
890: fnd_message.set_token('LER_ID',to_char(p_ler_id));
891: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
892: fnd_message.raise_error;
893: --
894: end if;
887: fnd_message.set_token('PROC',l_proc);
888: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
889: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
890: fnd_message.set_token('LER_ID',to_char(p_ler_id));
891: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
892: fnd_message.raise_error;
893: --
894: end if;
895: --
888: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
889: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
890: fnd_message.set_token('LER_ID',to_char(p_ler_id));
891: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
892: fnd_message.raise_error;
893: --
894: end if;
895: --
896: close c_prtt_result;
1105: fetch c_prtt_result into l_prtt_result;
1106: if c_prtt_result%notfound then
1107: --
1108: close c_prtt_result;
1109: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1110: fnd_message.set_token('PROC',l_proc);
1111: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1112: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1113: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1106: if c_prtt_result%notfound then
1107: --
1108: close c_prtt_result;
1109: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1110: fnd_message.set_token('PROC',l_proc);
1111: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1112: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1113: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1114: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1107: --
1108: close c_prtt_result;
1109: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1110: fnd_message.set_token('PROC',l_proc);
1111: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1112: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1113: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1114: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1115: fnd_message.raise_error;
1108: close c_prtt_result;
1109: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1110: fnd_message.set_token('PROC',l_proc);
1111: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1112: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1113: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1114: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1115: fnd_message.raise_error;
1116: --
1109: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1110: fnd_message.set_token('PROC',l_proc);
1111: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1112: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1113: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1114: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1115: fnd_message.raise_error;
1116: --
1117: else
1110: fnd_message.set_token('PROC',l_proc);
1111: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1112: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1113: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1114: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1115: fnd_message.raise_error;
1116: --
1117: else
1118: --
1111: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1112: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1113: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1114: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1115: fnd_message.raise_error;
1116: --
1117: else
1118: --
1119: l_choice_info.enrt_cvg_strt_dt := l_prtt_result.enrt_cvg_strt_dt;