DBA Data[Home] [Help]

APPS.BEN_CARRY_FORWARD_ITEMS dependencies on FND_MESSAGE

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

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

Line 701: fnd_message.raise_error;

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

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

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

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

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

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

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;

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

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

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

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;

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

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

Line 1221: fnd_message.raise_error;

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;

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

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

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

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

Line 1501: fnd_message.set_token('ID',l_prtt_enrt_rslt_id); -- l_choice_info.prtt_enrt_rslt_id);

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;

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

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

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

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

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

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

Line 1505: fnd_message.raise_error;

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;