DBA Data[Home] [Help]

APPS.BEN_AUTOMATIC_ENROLLMENTS dependencies on FND_MESSAGE

Line 408: fnd_message.set_name('BEN','BEN_92558_DPNT_CVG_CD');

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: --

Line 409: fnd_message.raise_error;

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

Line 886: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');

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));

Line 887: fnd_message.set_token('PROC',l_proc);

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));

Line 888: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);

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;

Line 889: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

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: --

Line 890: fnd_message.set_token('LER_ID',to_char(p_ler_id));

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;

Line 891: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

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: --

Line 892: fnd_message.raise_error;

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;

Line 1109: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');

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));

Line 1110: fnd_message.set_token('PROC',l_proc);

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));

Line 1111: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);

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;

Line 1112: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

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: --

Line 1113: fnd_message.set_token('LER_ID',to_char(p_ler_id));

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

Line 1114: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

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: --

Line 1115: fnd_message.raise_error;

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;