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

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

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

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

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

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;

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

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

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

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;

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

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

Line 1225: fnd_message.raise_error;

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;

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

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

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

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

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

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;

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

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

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

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

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

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

Line 1520: fnd_message.raise_error;

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;