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 879: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');

875: fetch c_prtt_result into l_prtt_result;
876: if c_prtt_result%notfound then
877: --
878: close c_prtt_result;
879: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
880: fnd_message.set_token('PROC',l_proc);
881: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
882: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
883: fnd_message.set_token('LER_ID',to_char(p_ler_id));

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

876: if c_prtt_result%notfound then
877: --
878: close c_prtt_result;
879: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
880: fnd_message.set_token('PROC',l_proc);
881: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
882: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
883: fnd_message.set_token('LER_ID',to_char(p_ler_id));
884: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

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

877: --
878: close c_prtt_result;
879: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
880: fnd_message.set_token('PROC',l_proc);
881: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
882: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
883: fnd_message.set_token('LER_ID',to_char(p_ler_id));
884: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
885: fnd_message.raise_error;

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

878: close c_prtt_result;
879: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
880: fnd_message.set_token('PROC',l_proc);
881: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
882: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
883: fnd_message.set_token('LER_ID',to_char(p_ler_id));
884: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
885: fnd_message.raise_error;
886: --

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

879: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
880: fnd_message.set_token('PROC',l_proc);
881: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
882: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
883: fnd_message.set_token('LER_ID',to_char(p_ler_id));
884: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
885: fnd_message.raise_error;
886: --
887: end if;

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

880: fnd_message.set_token('PROC',l_proc);
881: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
882: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
883: fnd_message.set_token('LER_ID',to_char(p_ler_id));
884: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
885: fnd_message.raise_error;
886: --
887: end if;
888: --

Line 885: fnd_message.raise_error;

881: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
882: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
883: fnd_message.set_token('LER_ID',to_char(p_ler_id));
884: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
885: fnd_message.raise_error;
886: --
887: end if;
888: --
889: close c_prtt_result;

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

1098: fetch c_prtt_result into l_prtt_result;
1099: if c_prtt_result%notfound then
1100: --
1101: close c_prtt_result;
1102: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1103: fnd_message.set_token('PROC',l_proc);
1104: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1105: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1106: fnd_message.set_token('LER_ID',to_char(p_ler_id));

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

1099: if c_prtt_result%notfound then
1100: --
1101: close c_prtt_result;
1102: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1103: fnd_message.set_token('PROC',l_proc);
1104: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1105: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1106: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1107: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

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

1100: --
1101: close c_prtt_result;
1102: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1103: fnd_message.set_token('PROC',l_proc);
1104: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1105: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1106: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1107: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1108: fnd_message.raise_error;

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

1101: close c_prtt_result;
1102: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1103: fnd_message.set_token('PROC',l_proc);
1104: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1105: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1106: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1107: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1108: fnd_message.raise_error;
1109: --

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

1102: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FOUND');
1103: fnd_message.set_token('PROC',l_proc);
1104: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1105: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1106: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1107: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1108: fnd_message.raise_error;
1109: --
1110: else

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

1103: fnd_message.set_token('PROC',l_proc);
1104: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1105: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1106: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1107: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1108: fnd_message.raise_error;
1109: --
1110: else
1111: --

Line 1108: fnd_message.raise_error;

1104: fnd_message.set_token('ID',l_choice_info.prtt_enrt_rslt_id);
1105: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1106: fnd_message.set_token('LER_ID',to_char(p_ler_id));
1107: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
1108: fnd_message.raise_error;
1109: --
1110: else
1111: --
1112: l_choice_info.enrt_cvg_strt_dt := l_prtt_result.enrt_cvg_strt_dt;