38: 08 Jul 98 Jmohapat 115.6 added batch who columns to api
39: calls(ben_prtt_enrt_result_api.
40: create/update_enrollment,
41: ben_enrt_bnft_api. updateenrt_bnft
42: 24 Jul 98 jcarpent 115.7 Fixed message removed fnd_message.get
43: 28 Jul 98 jcarpent 115.8 Added flex fields.
44: 22 SEP 98 GPERRY 115.9 Corrected error messages
45: 25 SEP 98 bbulusu 115.10 Added out nocopy parameters (warnings) at
46: end of election_information and in
1874: open c_enrt_rt;
1875: fetch c_enrt_rt into l_enrt_rt;
1876: if c_enrt_rt%notfound then
1877: close c_enrt_rt;
1878: fnd_message.set_name('BEN','BEN_91825_ENRT_RT_NOT_FOUND');
1879: fnd_message.set_token('PROC',l_proc);
1880: fnd_message.set_token('ENRT_RT_ID',to_char(p_enrt_rt_id));
1881: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1882: if g_debug then
1875: fetch c_enrt_rt into l_enrt_rt;
1876: if c_enrt_rt%notfound then
1877: close c_enrt_rt;
1878: fnd_message.set_name('BEN','BEN_91825_ENRT_RT_NOT_FOUND');
1879: fnd_message.set_token('PROC',l_proc);
1880: fnd_message.set_token('ENRT_RT_ID',to_char(p_enrt_rt_id));
1881: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1882: if g_debug then
1883: hr_utility.set_location('BEN_91825_ENRT_RT_NOT_FOUND', 20);
1876: if c_enrt_rt%notfound then
1877: close c_enrt_rt;
1878: fnd_message.set_name('BEN','BEN_91825_ENRT_RT_NOT_FOUND');
1879: fnd_message.set_token('PROC',l_proc);
1880: fnd_message.set_token('ENRT_RT_ID',to_char(p_enrt_rt_id));
1881: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1882: if g_debug then
1883: hr_utility.set_location('BEN_91825_ENRT_RT_NOT_FOUND', 20);
1884: end if;
1877: close c_enrt_rt;
1878: fnd_message.set_name('BEN','BEN_91825_ENRT_RT_NOT_FOUND');
1879: fnd_message.set_token('PROC',l_proc);
1880: fnd_message.set_token('ENRT_RT_ID',to_char(p_enrt_rt_id));
1881: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1882: if g_debug then
1883: hr_utility.set_location('BEN_91825_ENRT_RT_NOT_FOUND', 20);
1884: end if;
1885: fnd_message.raise_error;
1881: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1882: if g_debug then
1883: hr_utility.set_location('BEN_91825_ENRT_RT_NOT_FOUND', 20);
1884: end if;
1885: fnd_message.raise_error;
1886: end if; -- notfound
1887: close c_enrt_rt;
1888:
1889: if ben_manage_life_events.fonm = 'Y' then
1939: if p_rt_strt_dt is not null and
1940: l_rt_end_dt is not null and
1941: p_rt_strt_dt > l_rt_end_dt then
1942: --
1943: fnd_message.set_name('BEN','BEN_92688_RT_STRT_DT_GT_END_DT');
1944: fnd_message.set_token('START',p_rt_strt_dt);
1945: fnd_message.set_token('END',l_rt_end_dt);
1946: fnd_message.raise_error;
1947: --
1940: l_rt_end_dt is not null and
1941: p_rt_strt_dt > l_rt_end_dt then
1942: --
1943: fnd_message.set_name('BEN','BEN_92688_RT_STRT_DT_GT_END_DT');
1944: fnd_message.set_token('START',p_rt_strt_dt);
1945: fnd_message.set_token('END',l_rt_end_dt);
1946: fnd_message.raise_error;
1947: --
1948: end if;
1941: p_rt_strt_dt > l_rt_end_dt then
1942: --
1943: fnd_message.set_name('BEN','BEN_92688_RT_STRT_DT_GT_END_DT');
1944: fnd_message.set_token('START',p_rt_strt_dt);
1945: fnd_message.set_token('END',l_rt_end_dt);
1946: fnd_message.raise_error;
1947: --
1948: end if;
1949: --
1942: --
1943: fnd_message.set_name('BEN','BEN_92688_RT_STRT_DT_GT_END_DT');
1944: fnd_message.set_token('START',p_rt_strt_dt);
1945: fnd_message.set_token('END',l_rt_end_dt);
1946: fnd_message.raise_error;
1947: --
1948: end if;
1949: --
1950: -- Get data from old rate
1987: close c_prtt_rt_val_1;
1988: if g_debug then
1989: hr_utility.set_location('BEN_92103_NO_PRTT_RT_VAL', 35);
1990: end if;
1991: fnd_message.set_name('BEN','BEN_92103_NO_PRTT_RT_VAL');
1992: fnd_message.set_token('PROC',l_proc);
1993: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(l_enrt_rt.prtt_rt_val_id));
1994: fnd_message.raise_error;
1995: end if;
1988: if g_debug then
1989: hr_utility.set_location('BEN_92103_NO_PRTT_RT_VAL', 35);
1990: end if;
1991: fnd_message.set_name('BEN','BEN_92103_NO_PRTT_RT_VAL');
1992: fnd_message.set_token('PROC',l_proc);
1993: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(l_enrt_rt.prtt_rt_val_id));
1994: fnd_message.raise_error;
1995: end if;
1996:
1989: hr_utility.set_location('BEN_92103_NO_PRTT_RT_VAL', 35);
1990: end if;
1991: fnd_message.set_name('BEN','BEN_92103_NO_PRTT_RT_VAL');
1992: fnd_message.set_token('PROC',l_proc);
1993: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(l_enrt_rt.prtt_rt_val_id));
1994: fnd_message.raise_error;
1995: end if;
1996:
1997: if g_debug then
1990: end if;
1991: fnd_message.set_name('BEN','BEN_92103_NO_PRTT_RT_VAL');
1992: fnd_message.set_token('PROC',l_proc);
1993: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(l_enrt_rt.prtt_rt_val_id));
1994: fnd_message.raise_error;
1995: end if;
1996:
1997: if g_debug then
1998: hr_utility.set_location('ll_old_rt_strt_dt'||l_old_rt_strt_dt,99);
2086: if g_debug then
2087: hr_utility.set_location('BEN_91455_RT_STRT_DT_NOT_FOUND id:'||
2088: to_char(p_pl_id), 50);
2089: end if;
2090: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
2091: fnd_message.set_token('PROC',l_proc);
2092: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
2093: fnd_message.raise_error;
2094: end if; -- date is null
2087: hr_utility.set_location('BEN_91455_RT_STRT_DT_NOT_FOUND id:'||
2088: to_char(p_pl_id), 50);
2089: end if;
2090: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
2091: fnd_message.set_token('PROC',l_proc);
2092: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
2093: fnd_message.raise_error;
2094: end if; -- date is null
2095:
2088: to_char(p_pl_id), 50);
2089: end if;
2090: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
2091: fnd_message.set_token('PROC',l_proc);
2092: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
2093: fnd_message.raise_error;
2094: end if; -- date is null
2095:
2096: if p_prtt_rt_val_id is null then
2089: end if;
2090: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
2091: fnd_message.set_token('PROC',l_proc);
2092: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
2093: fnd_message.raise_error;
2094: end if; -- date is null
2095:
2096: if p_prtt_rt_val_id is null then
2097:
5811: --
5812: if g_debug then
5813: hr_utility.set_location('BEN_91711_ENRT_RSLT_NOT_FND'|| to_char(p_prtt_enrt_rslt_id),54);
5814: end if;
5815: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
5816: fnd_message.set_token('PROC',l_proc);
5817: fnd_message.set_token('ID', to_char(p_prtt_enrt_rslt_id));
5818: fnd_message.set_token('PERSON_ID', to_char(l_global_pil_rec.person_id));
5819: fnd_message.set_token('LER_ID', to_char(l_global_pil_rec.ler_id));
5812: if g_debug then
5813: hr_utility.set_location('BEN_91711_ENRT_RSLT_NOT_FND'|| to_char(p_prtt_enrt_rslt_id),54);
5814: end if;
5815: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
5816: fnd_message.set_token('PROC',l_proc);
5817: fnd_message.set_token('ID', to_char(p_prtt_enrt_rslt_id));
5818: fnd_message.set_token('PERSON_ID', to_char(l_global_pil_rec.person_id));
5819: fnd_message.set_token('LER_ID', to_char(l_global_pil_rec.ler_id));
5820: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5813: hr_utility.set_location('BEN_91711_ENRT_RSLT_NOT_FND'|| to_char(p_prtt_enrt_rslt_id),54);
5814: end if;
5815: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
5816: fnd_message.set_token('PROC',l_proc);
5817: fnd_message.set_token('ID', to_char(p_prtt_enrt_rslt_id));
5818: fnd_message.set_token('PERSON_ID', to_char(l_global_pil_rec.person_id));
5819: fnd_message.set_token('LER_ID', to_char(l_global_pil_rec.ler_id));
5820: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5821: fnd_message.raise_error;
5814: end if;
5815: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
5816: fnd_message.set_token('PROC',l_proc);
5817: fnd_message.set_token('ID', to_char(p_prtt_enrt_rslt_id));
5818: fnd_message.set_token('PERSON_ID', to_char(l_global_pil_rec.person_id));
5819: fnd_message.set_token('LER_ID', to_char(l_global_pil_rec.ler_id));
5820: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5821: fnd_message.raise_error;
5822: else
5815: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
5816: fnd_message.set_token('PROC',l_proc);
5817: fnd_message.set_token('ID', to_char(p_prtt_enrt_rslt_id));
5818: fnd_message.set_token('PERSON_ID', to_char(l_global_pil_rec.person_id));
5819: fnd_message.set_token('LER_ID', to_char(l_global_pil_rec.ler_id));
5820: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5821: fnd_message.raise_error;
5822: else
5823: --
5816: fnd_message.set_token('PROC',l_proc);
5817: fnd_message.set_token('ID', to_char(p_prtt_enrt_rslt_id));
5818: fnd_message.set_token('PERSON_ID', to_char(l_global_pil_rec.person_id));
5819: fnd_message.set_token('LER_ID', to_char(l_global_pil_rec.ler_id));
5820: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5821: fnd_message.raise_error;
5822: else
5823: --
5824: close c_current_result_info;
5817: fnd_message.set_token('ID', to_char(p_prtt_enrt_rslt_id));
5818: fnd_message.set_token('PERSON_ID', to_char(l_global_pil_rec.person_id));
5819: fnd_message.set_token('LER_ID', to_char(l_global_pil_rec.ler_id));
5820: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5821: fnd_message.raise_error;
5822: else
5823: --
5824: close c_current_result_info;
5825: --
7013: --
7014: if g_debug then
7015: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN id:'|| to_char(l_global_epe_rec.pl_id), 169);
7016: end if;
7017: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
7018: fnd_message.set_token('PROC',l_proc);
7019: fnd_message.set_token('PERSON_ID',to_char(l_global_pil_rec.person_id));
7020: fnd_message.set_token('PGM_ID',to_char(l_global_epe_rec.pgm_id));
7021: fnd_message.set_token('PLAN_ID',to_char(l_global_epe_rec.pl_id));
7014: if g_debug then
7015: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN id:'|| to_char(l_global_epe_rec.pl_id), 169);
7016: end if;
7017: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
7018: fnd_message.set_token('PROC',l_proc);
7019: fnd_message.set_token('PERSON_ID',to_char(l_global_pil_rec.person_id));
7020: fnd_message.set_token('PGM_ID',to_char(l_global_epe_rec.pgm_id));
7021: fnd_message.set_token('PLAN_ID',to_char(l_global_epe_rec.pl_id));
7022: fnd_message.set_token('OIPL_ID',to_char(l_global_epe_rec.oipl_id));
7015: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN id:'|| to_char(l_global_epe_rec.pl_id), 169);
7016: end if;
7017: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
7018: fnd_message.set_token('PROC',l_proc);
7019: fnd_message.set_token('PERSON_ID',to_char(l_global_pil_rec.person_id));
7020: fnd_message.set_token('PGM_ID',to_char(l_global_epe_rec.pgm_id));
7021: fnd_message.set_token('PLAN_ID',to_char(l_global_epe_rec.pl_id));
7022: fnd_message.set_token('OIPL_ID',to_char(l_global_epe_rec.oipl_id));
7023: fnd_message.raise_error;
7016: end if;
7017: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
7018: fnd_message.set_token('PROC',l_proc);
7019: fnd_message.set_token('PERSON_ID',to_char(l_global_pil_rec.person_id));
7020: fnd_message.set_token('PGM_ID',to_char(l_global_epe_rec.pgm_id));
7021: fnd_message.set_token('PLAN_ID',to_char(l_global_epe_rec.pl_id));
7022: fnd_message.set_token('OIPL_ID',to_char(l_global_epe_rec.oipl_id));
7023: fnd_message.raise_error;
7024: end if; -- date is null
7017: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
7018: fnd_message.set_token('PROC',l_proc);
7019: fnd_message.set_token('PERSON_ID',to_char(l_global_pil_rec.person_id));
7020: fnd_message.set_token('PGM_ID',to_char(l_global_epe_rec.pgm_id));
7021: fnd_message.set_token('PLAN_ID',to_char(l_global_epe_rec.pl_id));
7022: fnd_message.set_token('OIPL_ID',to_char(l_global_epe_rec.oipl_id));
7023: fnd_message.raise_error;
7024: end if; -- date is null
7025: if g_debug then
7018: fnd_message.set_token('PROC',l_proc);
7019: fnd_message.set_token('PERSON_ID',to_char(l_global_pil_rec.person_id));
7020: fnd_message.set_token('PGM_ID',to_char(l_global_epe_rec.pgm_id));
7021: fnd_message.set_token('PLAN_ID',to_char(l_global_epe_rec.pl_id));
7022: fnd_message.set_token('OIPL_ID',to_char(l_global_epe_rec.oipl_id));
7023: fnd_message.raise_error;
7024: end if; -- date is null
7025: if g_debug then
7026: hr_utility.set_location(l_proc, 170);
7019: fnd_message.set_token('PERSON_ID',to_char(l_global_pil_rec.person_id));
7020: fnd_message.set_token('PGM_ID',to_char(l_global_epe_rec.pgm_id));
7021: fnd_message.set_token('PLAN_ID',to_char(l_global_epe_rec.pl_id));
7022: fnd_message.set_token('OIPL_ID',to_char(l_global_epe_rec.oipl_id));
7023: fnd_message.raise_error;
7024: end if; -- date is null
7025: if g_debug then
7026: hr_utility.set_location(l_proc, 170);
7027: end if;
8310: end if;
8311: when others then
8312: p_return_status := 'E';
8313: --Bug 4387247
8314: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
8315: fnd_message.set_token('2',substr(sqlerrm,1,200));
8316: fnd_msg_pub.add;
8317: ben_det_enrt_rates.clear_globals;
8318: if l_trace_on then
8311: when others then
8312: p_return_status := 'E';
8313: --Bug 4387247
8314: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
8315: fnd_message.set_token('2',substr(sqlerrm,1,200));
8316: fnd_msg_pub.add;
8317: ben_det_enrt_rates.clear_globals;
8318: if l_trace_on then
8319: hr_utility.trace_off;
8490: open c_pl_opt_name;
8491: fetch c_pl_opt_name into l_pl_opt_name;
8492: close c_pl_opt_name;
8493: --
8494: fnd_message.set_name('BEN','BEN_92394_OUT_OF_RANGE');
8495: fnd_message.set_token('MINIMUM', l_bnft.mn_val);
8496: fnd_message.set_token('MAXIMUM', l_bnft.mx_val);
8497: fnd_message.set_token('PLAN', l_pl_opt_name);
8498: fnd_message.raise_error;
8491: fetch c_pl_opt_name into l_pl_opt_name;
8492: close c_pl_opt_name;
8493: --
8494: fnd_message.set_name('BEN','BEN_92394_OUT_OF_RANGE');
8495: fnd_message.set_token('MINIMUM', l_bnft.mn_val);
8496: fnd_message.set_token('MAXIMUM', l_bnft.mx_val);
8497: fnd_message.set_token('PLAN', l_pl_opt_name);
8498: fnd_message.raise_error;
8499: --
8492: close c_pl_opt_name;
8493: --
8494: fnd_message.set_name('BEN','BEN_92394_OUT_OF_RANGE');
8495: fnd_message.set_token('MINIMUM', l_bnft.mn_val);
8496: fnd_message.set_token('MAXIMUM', l_bnft.mx_val);
8497: fnd_message.set_token('PLAN', l_pl_opt_name);
8498: fnd_message.raise_error;
8499: --
8500: end if;
8493: --
8494: fnd_message.set_name('BEN','BEN_92394_OUT_OF_RANGE');
8495: fnd_message.set_token('MINIMUM', l_bnft.mn_val);
8496: fnd_message.set_token('MAXIMUM', l_bnft.mx_val);
8497: fnd_message.set_token('PLAN', l_pl_opt_name);
8498: fnd_message.raise_error;
8499: --
8500: end if;
8501: --
8494: fnd_message.set_name('BEN','BEN_92394_OUT_OF_RANGE');
8495: fnd_message.set_token('MINIMUM', l_bnft.mn_val);
8496: fnd_message.set_token('MAXIMUM', l_bnft.mx_val);
8497: fnd_message.set_token('PLAN', l_pl_opt_name);
8498: fnd_message.raise_error;
8499: --
8500: end if;
8501: --
8502: if l_bnft.mn_val is not null and
8508: open c_pl_opt_name;
8509: fetch c_pl_opt_name into l_pl_opt_name;
8510: close c_pl_opt_name;
8511: --
8512: fnd_message.set_name('BEN','BEN_92395_NOT_IN_INCR');
8513: fnd_message.set_token('INCREMENT', l_bnft.incrmt_val);
8514: fnd_message.set_token('PLAN', l_pl_opt_name);
8515: fnd_message.raise_error;
8516: --
8509: fetch c_pl_opt_name into l_pl_opt_name;
8510: close c_pl_opt_name;
8511: --
8512: fnd_message.set_name('BEN','BEN_92395_NOT_IN_INCR');
8513: fnd_message.set_token('INCREMENT', l_bnft.incrmt_val);
8514: fnd_message.set_token('PLAN', l_pl_opt_name);
8515: fnd_message.raise_error;
8516: --
8517: end if;
8510: close c_pl_opt_name;
8511: --
8512: fnd_message.set_name('BEN','BEN_92395_NOT_IN_INCR');
8513: fnd_message.set_token('INCREMENT', l_bnft.incrmt_val);
8514: fnd_message.set_token('PLAN', l_pl_opt_name);
8515: fnd_message.raise_error;
8516: --
8517: end if;
8518: --
8511: --
8512: fnd_message.set_name('BEN','BEN_92395_NOT_IN_INCR');
8513: fnd_message.set_token('INCREMENT', l_bnft.incrmt_val);
8514: fnd_message.set_token('PLAN', l_pl_opt_name);
8515: fnd_message.raise_error;
8516: --
8517: end if;
8518: --
8519: end if;