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
1526: open c_enrt_rt;
1527: fetch c_enrt_rt into l_enrt_rt;
1528: if c_enrt_rt%notfound then
1529: close c_enrt_rt;
1530: fnd_message.set_name('BEN','BEN_91825_ENRT_RT_NOT_FOUND');
1531: fnd_message.set_token('PROC',l_proc);
1532: fnd_message.set_token('ENRT_RT_ID',to_char(p_enrt_rt_id));
1533: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1534: if g_debug then
1527: fetch c_enrt_rt into l_enrt_rt;
1528: if c_enrt_rt%notfound then
1529: close c_enrt_rt;
1530: fnd_message.set_name('BEN','BEN_91825_ENRT_RT_NOT_FOUND');
1531: fnd_message.set_token('PROC',l_proc);
1532: fnd_message.set_token('ENRT_RT_ID',to_char(p_enrt_rt_id));
1533: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1534: if g_debug then
1535: hr_utility.set_location('BEN_91825_ENRT_RT_NOT_FOUND', 20);
1528: if c_enrt_rt%notfound then
1529: close c_enrt_rt;
1530: fnd_message.set_name('BEN','BEN_91825_ENRT_RT_NOT_FOUND');
1531: fnd_message.set_token('PROC',l_proc);
1532: fnd_message.set_token('ENRT_RT_ID',to_char(p_enrt_rt_id));
1533: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1534: if g_debug then
1535: hr_utility.set_location('BEN_91825_ENRT_RT_NOT_FOUND', 20);
1536: end if;
1529: close c_enrt_rt;
1530: fnd_message.set_name('BEN','BEN_91825_ENRT_RT_NOT_FOUND');
1531: fnd_message.set_token('PROC',l_proc);
1532: fnd_message.set_token('ENRT_RT_ID',to_char(p_enrt_rt_id));
1533: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1534: if g_debug then
1535: hr_utility.set_location('BEN_91825_ENRT_RT_NOT_FOUND', 20);
1536: end if;
1537: fnd_message.raise_error;
1533: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
1534: if g_debug then
1535: hr_utility.set_location('BEN_91825_ENRT_RT_NOT_FOUND', 20);
1536: end if;
1537: fnd_message.raise_error;
1538: end if; -- notfound
1539: close c_enrt_rt;
1540:
1541: if ben_manage_life_events.fonm = 'Y' then
1582: if p_rt_strt_dt is not null and
1583: l_rt_end_dt is not null and
1584: p_rt_strt_dt > l_rt_end_dt then
1585: --
1586: fnd_message.set_name('BEN','BEN_92688_RT_STRT_DT_GT_END_DT');
1587: fnd_message.set_token('START',p_rt_strt_dt);
1588: fnd_message.set_token('END',l_rt_end_dt);
1589: fnd_message.raise_error;
1590: --
1583: l_rt_end_dt is not null and
1584: p_rt_strt_dt > l_rt_end_dt then
1585: --
1586: fnd_message.set_name('BEN','BEN_92688_RT_STRT_DT_GT_END_DT');
1587: fnd_message.set_token('START',p_rt_strt_dt);
1588: fnd_message.set_token('END',l_rt_end_dt);
1589: fnd_message.raise_error;
1590: --
1591: end if;
1584: p_rt_strt_dt > l_rt_end_dt then
1585: --
1586: fnd_message.set_name('BEN','BEN_92688_RT_STRT_DT_GT_END_DT');
1587: fnd_message.set_token('START',p_rt_strt_dt);
1588: fnd_message.set_token('END',l_rt_end_dt);
1589: fnd_message.raise_error;
1590: --
1591: end if;
1592: --
1585: --
1586: fnd_message.set_name('BEN','BEN_92688_RT_STRT_DT_GT_END_DT');
1587: fnd_message.set_token('START',p_rt_strt_dt);
1588: fnd_message.set_token('END',l_rt_end_dt);
1589: fnd_message.raise_error;
1590: --
1591: end if;
1592: --
1593: -- Get data from old rate
1630: close c_prtt_rt_val_1;
1631: if g_debug then
1632: hr_utility.set_location('BEN_92103_NO_PRTT_RT_VAL', 35);
1633: end if;
1634: fnd_message.set_name('BEN','BEN_92103_NO_PRTT_RT_VAL');
1635: fnd_message.set_token('PROC',l_proc);
1636: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(l_enrt_rt.prtt_rt_val_id));
1637: fnd_message.raise_error;
1638: end if;
1631: if g_debug then
1632: hr_utility.set_location('BEN_92103_NO_PRTT_RT_VAL', 35);
1633: end if;
1634: fnd_message.set_name('BEN','BEN_92103_NO_PRTT_RT_VAL');
1635: fnd_message.set_token('PROC',l_proc);
1636: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(l_enrt_rt.prtt_rt_val_id));
1637: fnd_message.raise_error;
1638: end if;
1639:
1632: hr_utility.set_location('BEN_92103_NO_PRTT_RT_VAL', 35);
1633: end if;
1634: fnd_message.set_name('BEN','BEN_92103_NO_PRTT_RT_VAL');
1635: fnd_message.set_token('PROC',l_proc);
1636: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(l_enrt_rt.prtt_rt_val_id));
1637: fnd_message.raise_error;
1638: end if;
1639:
1640: if g_debug then
1633: end if;
1634: fnd_message.set_name('BEN','BEN_92103_NO_PRTT_RT_VAL');
1635: fnd_message.set_token('PROC',l_proc);
1636: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(l_enrt_rt.prtt_rt_val_id));
1637: fnd_message.raise_error;
1638: end if;
1639:
1640: if g_debug then
1641: hr_utility.set_location('ll_old_rt_strt_dt'||l_old_rt_strt_dt,99);
1729: if g_debug then
1730: hr_utility.set_location('BEN_91455_RT_STRT_DT_NOT_FOUND id:'||
1731: to_char(p_pl_id), 50);
1732: end if;
1733: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
1734: fnd_message.set_token('PROC',l_proc);
1735: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1736: fnd_message.raise_error;
1737: end if; -- date is null
1730: hr_utility.set_location('BEN_91455_RT_STRT_DT_NOT_FOUND id:'||
1731: to_char(p_pl_id), 50);
1732: end if;
1733: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
1734: fnd_message.set_token('PROC',l_proc);
1735: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1736: fnd_message.raise_error;
1737: end if; -- date is null
1738:
1731: to_char(p_pl_id), 50);
1732: end if;
1733: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
1734: fnd_message.set_token('PROC',l_proc);
1735: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1736: fnd_message.raise_error;
1737: end if; -- date is null
1738:
1739: if p_prtt_rt_val_id is null then
1732: end if;
1733: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
1734: fnd_message.set_token('PROC',l_proc);
1735: fnd_message.set_token('PLAN_ID', to_char(p_pl_id));
1736: fnd_message.raise_error;
1737: end if; -- date is null
1738:
1739: if p_prtt_rt_val_id is null then
1740:
4954: --
4955: if g_debug then
4956: hr_utility.set_location('BEN_91711_ENRT_RSLT_NOT_FND'|| to_char(p_prtt_enrt_rslt_id),54);
4957: end if;
4958: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
4959: fnd_message.set_token('PROC',l_proc);
4960: fnd_message.set_token('ID', to_char(p_prtt_enrt_rslt_id));
4961: fnd_message.set_token('PERSON_ID', to_char(l_global_pil_rec.person_id));
4962: fnd_message.set_token('LER_ID', to_char(l_global_pil_rec.ler_id));
4955: if g_debug then
4956: hr_utility.set_location('BEN_91711_ENRT_RSLT_NOT_FND'|| to_char(p_prtt_enrt_rslt_id),54);
4957: end if;
4958: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
4959: fnd_message.set_token('PROC',l_proc);
4960: fnd_message.set_token('ID', to_char(p_prtt_enrt_rslt_id));
4961: fnd_message.set_token('PERSON_ID', to_char(l_global_pil_rec.person_id));
4962: fnd_message.set_token('LER_ID', to_char(l_global_pil_rec.ler_id));
4963: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4956: hr_utility.set_location('BEN_91711_ENRT_RSLT_NOT_FND'|| to_char(p_prtt_enrt_rslt_id),54);
4957: end if;
4958: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
4959: fnd_message.set_token('PROC',l_proc);
4960: fnd_message.set_token('ID', to_char(p_prtt_enrt_rslt_id));
4961: fnd_message.set_token('PERSON_ID', to_char(l_global_pil_rec.person_id));
4962: fnd_message.set_token('LER_ID', to_char(l_global_pil_rec.ler_id));
4963: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4964: fnd_message.raise_error;
4957: end if;
4958: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
4959: fnd_message.set_token('PROC',l_proc);
4960: fnd_message.set_token('ID', to_char(p_prtt_enrt_rslt_id));
4961: fnd_message.set_token('PERSON_ID', to_char(l_global_pil_rec.person_id));
4962: fnd_message.set_token('LER_ID', to_char(l_global_pil_rec.ler_id));
4963: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4964: fnd_message.raise_error;
4965: else
4958: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');
4959: fnd_message.set_token('PROC',l_proc);
4960: fnd_message.set_token('ID', to_char(p_prtt_enrt_rslt_id));
4961: fnd_message.set_token('PERSON_ID', to_char(l_global_pil_rec.person_id));
4962: fnd_message.set_token('LER_ID', to_char(l_global_pil_rec.ler_id));
4963: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4964: fnd_message.raise_error;
4965: else
4966: --
4959: fnd_message.set_token('PROC',l_proc);
4960: fnd_message.set_token('ID', to_char(p_prtt_enrt_rslt_id));
4961: fnd_message.set_token('PERSON_ID', to_char(l_global_pil_rec.person_id));
4962: fnd_message.set_token('LER_ID', to_char(l_global_pil_rec.ler_id));
4963: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4964: fnd_message.raise_error;
4965: else
4966: --
4967: close c_current_result_info;
4960: fnd_message.set_token('ID', to_char(p_prtt_enrt_rslt_id));
4961: fnd_message.set_token('PERSON_ID', to_char(l_global_pil_rec.person_id));
4962: fnd_message.set_token('LER_ID', to_char(l_global_pil_rec.ler_id));
4963: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4964: fnd_message.raise_error;
4965: else
4966: --
4967: close c_current_result_info;
4968: --
5995: --
5996: if g_debug then
5997: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN id:'|| to_char(l_global_epe_rec.pl_id), 169);
5998: end if;
5999: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
6000: fnd_message.set_token('PROC',l_proc);
6001: fnd_message.set_token('PERSON_ID',to_char(l_global_pil_rec.person_id));
6002: fnd_message.set_token('PGM_ID',to_char(l_global_epe_rec.pgm_id));
6003: fnd_message.set_token('PLAN_ID',to_char(l_global_epe_rec.pl_id));
5996: if g_debug then
5997: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN id:'|| to_char(l_global_epe_rec.pl_id), 169);
5998: end if;
5999: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
6000: fnd_message.set_token('PROC',l_proc);
6001: fnd_message.set_token('PERSON_ID',to_char(l_global_pil_rec.person_id));
6002: fnd_message.set_token('PGM_ID',to_char(l_global_epe_rec.pgm_id));
6003: fnd_message.set_token('PLAN_ID',to_char(l_global_epe_rec.pl_id));
6004: fnd_message.set_token('OIPL_ID',to_char(l_global_epe_rec.oipl_id));
5997: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN id:'|| to_char(l_global_epe_rec.pl_id), 169);
5998: end if;
5999: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
6000: fnd_message.set_token('PROC',l_proc);
6001: fnd_message.set_token('PERSON_ID',to_char(l_global_pil_rec.person_id));
6002: fnd_message.set_token('PGM_ID',to_char(l_global_epe_rec.pgm_id));
6003: fnd_message.set_token('PLAN_ID',to_char(l_global_epe_rec.pl_id));
6004: fnd_message.set_token('OIPL_ID',to_char(l_global_epe_rec.oipl_id));
6005: fnd_message.raise_error;
5998: end if;
5999: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
6000: fnd_message.set_token('PROC',l_proc);
6001: fnd_message.set_token('PERSON_ID',to_char(l_global_pil_rec.person_id));
6002: fnd_message.set_token('PGM_ID',to_char(l_global_epe_rec.pgm_id));
6003: fnd_message.set_token('PLAN_ID',to_char(l_global_epe_rec.pl_id));
6004: fnd_message.set_token('OIPL_ID',to_char(l_global_epe_rec.oipl_id));
6005: fnd_message.raise_error;
6006: end if; -- date is null
5999: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
6000: fnd_message.set_token('PROC',l_proc);
6001: fnd_message.set_token('PERSON_ID',to_char(l_global_pil_rec.person_id));
6002: fnd_message.set_token('PGM_ID',to_char(l_global_epe_rec.pgm_id));
6003: fnd_message.set_token('PLAN_ID',to_char(l_global_epe_rec.pl_id));
6004: fnd_message.set_token('OIPL_ID',to_char(l_global_epe_rec.oipl_id));
6005: fnd_message.raise_error;
6006: end if; -- date is null
6007: if g_debug then
6000: fnd_message.set_token('PROC',l_proc);
6001: fnd_message.set_token('PERSON_ID',to_char(l_global_pil_rec.person_id));
6002: fnd_message.set_token('PGM_ID',to_char(l_global_epe_rec.pgm_id));
6003: fnd_message.set_token('PLAN_ID',to_char(l_global_epe_rec.pl_id));
6004: fnd_message.set_token('OIPL_ID',to_char(l_global_epe_rec.oipl_id));
6005: fnd_message.raise_error;
6006: end if; -- date is null
6007: if g_debug then
6008: hr_utility.set_location(l_proc, 170);
6001: fnd_message.set_token('PERSON_ID',to_char(l_global_pil_rec.person_id));
6002: fnd_message.set_token('PGM_ID',to_char(l_global_epe_rec.pgm_id));
6003: fnd_message.set_token('PLAN_ID',to_char(l_global_epe_rec.pl_id));
6004: fnd_message.set_token('OIPL_ID',to_char(l_global_epe_rec.oipl_id));
6005: fnd_message.raise_error;
6006: end if; -- date is null
6007: if g_debug then
6008: hr_utility.set_location(l_proc, 170);
6009: end if;
7185: end if;
7186: when others then
7187: p_return_status := 'E';
7188: --Bug 4387247
7189: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
7190: fnd_message.set_token('2',substr(sqlerrm,1,200));
7191: fnd_msg_pub.add;
7192: ben_det_enrt_rates.clear_globals;
7193: if l_trace_on then
7186: when others then
7187: p_return_status := 'E';
7188: --Bug 4387247
7189: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
7190: fnd_message.set_token('2',substr(sqlerrm,1,200));
7191: fnd_msg_pub.add;
7192: ben_det_enrt_rates.clear_globals;
7193: if l_trace_on then
7194: hr_utility.trace_off;
7365: open c_pl_opt_name;
7366: fetch c_pl_opt_name into l_pl_opt_name;
7367: close c_pl_opt_name;
7368: --
7369: fnd_message.set_name('BEN','BEN_92394_OUT_OF_RANGE');
7370: fnd_message.set_token('MINIMUM', l_bnft.mn_val);
7371: fnd_message.set_token('MAXIMUM', l_bnft.mx_val);
7372: fnd_message.set_token('PLAN', l_pl_opt_name);
7373: fnd_message.raise_error;
7366: fetch c_pl_opt_name into l_pl_opt_name;
7367: close c_pl_opt_name;
7368: --
7369: fnd_message.set_name('BEN','BEN_92394_OUT_OF_RANGE');
7370: fnd_message.set_token('MINIMUM', l_bnft.mn_val);
7371: fnd_message.set_token('MAXIMUM', l_bnft.mx_val);
7372: fnd_message.set_token('PLAN', l_pl_opt_name);
7373: fnd_message.raise_error;
7374: --
7367: close c_pl_opt_name;
7368: --
7369: fnd_message.set_name('BEN','BEN_92394_OUT_OF_RANGE');
7370: fnd_message.set_token('MINIMUM', l_bnft.mn_val);
7371: fnd_message.set_token('MAXIMUM', l_bnft.mx_val);
7372: fnd_message.set_token('PLAN', l_pl_opt_name);
7373: fnd_message.raise_error;
7374: --
7375: end if;
7368: --
7369: fnd_message.set_name('BEN','BEN_92394_OUT_OF_RANGE');
7370: fnd_message.set_token('MINIMUM', l_bnft.mn_val);
7371: fnd_message.set_token('MAXIMUM', l_bnft.mx_val);
7372: fnd_message.set_token('PLAN', l_pl_opt_name);
7373: fnd_message.raise_error;
7374: --
7375: end if;
7376: --
7369: fnd_message.set_name('BEN','BEN_92394_OUT_OF_RANGE');
7370: fnd_message.set_token('MINIMUM', l_bnft.mn_val);
7371: fnd_message.set_token('MAXIMUM', l_bnft.mx_val);
7372: fnd_message.set_token('PLAN', l_pl_opt_name);
7373: fnd_message.raise_error;
7374: --
7375: end if;
7376: --
7377: if l_bnft.mn_val is not null and
7383: open c_pl_opt_name;
7384: fetch c_pl_opt_name into l_pl_opt_name;
7385: close c_pl_opt_name;
7386: --
7387: fnd_message.set_name('BEN','BEN_92395_NOT_IN_INCR');
7388: fnd_message.set_token('INCREMENT', l_bnft.incrmt_val);
7389: fnd_message.set_token('PLAN', l_pl_opt_name);
7390: fnd_message.raise_error;
7391: --
7384: fetch c_pl_opt_name into l_pl_opt_name;
7385: close c_pl_opt_name;
7386: --
7387: fnd_message.set_name('BEN','BEN_92395_NOT_IN_INCR');
7388: fnd_message.set_token('INCREMENT', l_bnft.incrmt_val);
7389: fnd_message.set_token('PLAN', l_pl_opt_name);
7390: fnd_message.raise_error;
7391: --
7392: end if;
7385: close c_pl_opt_name;
7386: --
7387: fnd_message.set_name('BEN','BEN_92395_NOT_IN_INCR');
7388: fnd_message.set_token('INCREMENT', l_bnft.incrmt_val);
7389: fnd_message.set_token('PLAN', l_pl_opt_name);
7390: fnd_message.raise_error;
7391: --
7392: end if;
7393: --
7386: --
7387: fnd_message.set_name('BEN','BEN_92395_NOT_IN_INCR');
7388: fnd_message.set_token('INCREMENT', l_bnft.incrmt_val);
7389: fnd_message.set_token('PLAN', l_pl_opt_name);
7390: fnd_message.raise_error;
7391: --
7392: end if;
7393: --
7394: end if;