DBA Data[Home] [Help]

APPS.BEN_ELECTION_INFORMATION dependencies on FND_MESSAGE

Line 42: 24 Jul 98 jcarpent 115.7 Fixed message removed fnd_message.get

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

Line 1530: fnd_message.set_name('BEN','BEN_91825_ENRT_RT_NOT_FOUND');

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

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

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

Line 1532: fnd_message.set_token('ENRT_RT_ID',to_char(p_enrt_rt_id));

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;

Line 1533: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

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;

Line 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

Line 1586: fnd_message.set_name('BEN','BEN_92688_RT_STRT_DT_GT_END_DT');

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

Line 1587: fnd_message.set_token('START',p_rt_strt_dt);

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;

Line 1588: fnd_message.set_token('END',l_rt_end_dt);

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

Line 1589: fnd_message.raise_error;

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

Line 1634: fnd_message.set_name('BEN','BEN_92103_NO_PRTT_RT_VAL');

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;

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

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:

Line 1636: fnd_message.set_token('PRTT_RT_VAL_ID',to_char(l_enrt_rt.prtt_rt_val_id));

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

Line 1637: fnd_message.raise_error;

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

Line 1733: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');

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

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

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:

Line 1735: fnd_message.set_token('PLAN_ID', to_char(p_pl_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:
1739: if p_prtt_rt_val_id is null then

Line 1736: fnd_message.raise_error;

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:

Line 4958: fnd_message.set_name('BEN','BEN_91711_ENRT_RSLT_NOT_FND');

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

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

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

Line 4960: fnd_message.set_token('ID', to_char(p_prtt_enrt_rslt_id));

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;

Line 4961: fnd_message.set_token('PERSON_ID', to_char(l_global_pil_rec.person_id));

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

Line 4962: fnd_message.set_token('LER_ID', to_char(l_global_pil_rec.ler_id));

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

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

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;

Line 4964: fnd_message.raise_error;

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

Line 5999: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');

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

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

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

Line 6001: fnd_message.set_token('PERSON_ID',to_char(l_global_pil_rec.person_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;

Line 6002: fnd_message.set_token('PGM_ID',to_char(l_global_epe_rec.pgm_id));

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

Line 6003: fnd_message.set_token('PLAN_ID',to_char(l_global_epe_rec.pl_id));

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

Line 6004: fnd_message.set_token('OIPL_ID',to_char(l_global_epe_rec.oipl_id));

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

Line 6005: fnd_message.raise_error;

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;

Line 7189: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');

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

Line 7190: fnd_message.set_token('2',substr(sqlerrm,1,200));

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;

Line 7369: fnd_message.set_name('BEN','BEN_92394_OUT_OF_RANGE');

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;

Line 7370: fnd_message.set_token('MINIMUM', l_bnft.mn_val);

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

Line 7371: fnd_message.set_token('MAXIMUM', l_bnft.mx_val);

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;

Line 7372: fnd_message.set_token('PLAN', l_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;
7376: --

Line 7373: fnd_message.raise_error;

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

Line 7387: fnd_message.set_name('BEN','BEN_92395_NOT_IN_INCR');

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

Line 7388: fnd_message.set_token('INCREMENT', l_bnft.incrmt_val);

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;

Line 7389: fnd_message.set_token('PLAN', 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;
7393: --

Line 7390: fnd_message.raise_error;

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;