eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PROVIDER_POOLS dependencies on FND_MESSAGE

Line 362: fnd_message.set_name('BEN','BEN_91724_NO_FLX_CR_RT_FOUND');

358: open c_pool_rule_info;
359: fetch c_pool_rule_info into l_pool_rule_info;
360: if c_pool_rule_info%NOTFOUND or c_pool_rule_info%NOTFOUND is null then
361: close c_pool_rule_info;
362: fnd_message.set_name('BEN','BEN_91724_NO_FLX_CR_RT_FOUND');
363: fnd_message.set_token('PROC',l_proc);
364: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
365: hr_utility.set_location(l_proc,82);
366: fnd_message.raise_error;

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

359: fetch c_pool_rule_info into l_pool_rule_info;
360: if c_pool_rule_info%NOTFOUND or c_pool_rule_info%NOTFOUND is null then
361: close c_pool_rule_info;
362: fnd_message.set_name('BEN','BEN_91724_NO_FLX_CR_RT_FOUND');
363: fnd_message.set_token('PROC',l_proc);
364: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
365: hr_utility.set_location(l_proc,82);
366: fnd_message.raise_error;
367: end if;

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

360: if c_pool_rule_info%NOTFOUND or c_pool_rule_info%NOTFOUND is null then
361: close c_pool_rule_info;
362: fnd_message.set_name('BEN','BEN_91724_NO_FLX_CR_RT_FOUND');
363: fnd_message.set_token('PROC',l_proc);
364: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
365: hr_utility.set_location(l_proc,82);
366: fnd_message.raise_error;
367: end if;
368: close c_pool_rule_info;

Line 366: fnd_message.raise_error;

362: fnd_message.set_name('BEN','BEN_91724_NO_FLX_CR_RT_FOUND');
363: fnd_message.set_token('PROC',l_proc);
364: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
365: hr_utility.set_location(l_proc,82);
366: fnd_message.raise_error;
367: end if;
368: close c_pool_rule_info;
369:
370: open c_person_rule_info;

Line 374: fnd_message.set_name('BEN','BEN_91708_PERSON_NOT_FOUND');

370: open c_person_rule_info;
371: fetch c_person_rule_info into l_person_rule_info;
372: if c_person_rule_info%NOTFOUND or c_person_rule_info%NOTFOUND is null then
373: close c_person_rule_info;
374: fnd_message.set_name('BEN','BEN_91708_PERSON_NOT_FOUND');
375: fnd_message.set_token('PROC',l_proc);
376: fnd_message.set_token('ID', p_person_id);
377: hr_utility.set_location(l_proc,82);
378: fnd_message.raise_error;

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

371: fetch c_person_rule_info into l_person_rule_info;
372: if c_person_rule_info%NOTFOUND or c_person_rule_info%NOTFOUND is null then
373: close c_person_rule_info;
374: fnd_message.set_name('BEN','BEN_91708_PERSON_NOT_FOUND');
375: fnd_message.set_token('PROC',l_proc);
376: fnd_message.set_token('ID', p_person_id);
377: hr_utility.set_location(l_proc,82);
378: fnd_message.raise_error;
379: end if;

Line 376: fnd_message.set_token('ID', p_person_id);

372: if c_person_rule_info%NOTFOUND or c_person_rule_info%NOTFOUND is null then
373: close c_person_rule_info;
374: fnd_message.set_name('BEN','BEN_91708_PERSON_NOT_FOUND');
375: fnd_message.set_token('PROC',l_proc);
376: fnd_message.set_token('ID', p_person_id);
377: hr_utility.set_location(l_proc,82);
378: fnd_message.raise_error;
379: end if;
380: close c_person_rule_info;

Line 378: fnd_message.raise_error;

374: fnd_message.set_name('BEN','BEN_91708_PERSON_NOT_FOUND');
375: fnd_message.set_token('PROC',l_proc);
376: fnd_message.set_token('ID', p_person_id);
377: hr_utility.set_location(l_proc,82);
378: fnd_message.raise_error;
379: end if;
380: close c_person_rule_info;
381:
382: -- if l_person_rule_info.region_2 is not null then

Line 1171: fnd_message.set_name('BEN','BEN_91724_NO_FLX_CR_RT_FOUND');

1167: if c_enrt_rt%notfound
1168: then
1169: -- error
1170: hr_utility.set_location('BEN_91724_NO_FLX_CR_RT_FOUND', 51);
1171: fnd_message.set_name('BEN','BEN_91724_NO_FLX_CR_RT_FOUND');
1172: fnd_message.set_token('PROC',l_proc);
1173: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1174: hr_utility.set_location(' choice_id='''||to_char(p_epe_rec.elig_per_elctbl_chc_id),51);
1175: hr_utility.set_location(' rslt_id='''||to_char(g_credit_pool_result_id),51);

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

1168: then
1169: -- error
1170: hr_utility.set_location('BEN_91724_NO_FLX_CR_RT_FOUND', 51);
1171: fnd_message.set_name('BEN','BEN_91724_NO_FLX_CR_RT_FOUND');
1172: fnd_message.set_token('PROC',l_proc);
1173: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1174: hr_utility.set_location(' choice_id='''||to_char(p_epe_rec.elig_per_elctbl_chc_id),51);
1175: hr_utility.set_location(' rslt_id='''||to_char(g_credit_pool_result_id),51);
1176: close c_enrt_rt;

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

1169: -- error
1170: hr_utility.set_location('BEN_91724_NO_FLX_CR_RT_FOUND', 51);
1171: fnd_message.set_name('BEN','BEN_91724_NO_FLX_CR_RT_FOUND');
1172: fnd_message.set_token('PROC',l_proc);
1173: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1174: hr_utility.set_location(' choice_id='''||to_char(p_epe_rec.elig_per_elctbl_chc_id),51);
1175: hr_utility.set_location(' rslt_id='''||to_char(g_credit_pool_result_id),51);
1176: close c_enrt_rt;
1177: fnd_message.raise_error;

Line 1177: fnd_message.raise_error;

1173: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1174: hr_utility.set_location(' choice_id='''||to_char(p_epe_rec.elig_per_elctbl_chc_id),51);
1175: hr_utility.set_location(' rslt_id='''||to_char(g_credit_pool_result_id),51);
1176: close c_enrt_rt;
1177: fnd_message.raise_error;
1178: elsif not p_calculate_only_mode
1179: then
1180: hr_utility.set_location(l_proc, 20);
1181: if l_acty_base_rt_id is null then

Line 1183: fnd_message.set_name('BEN','BEN_91725_NO_FLX_CR_ABR_FOUND');

1179: then
1180: hr_utility.set_location(l_proc, 20);
1181: if l_acty_base_rt_id is null then
1182: hr_utility.set_location('BEN_91725_NO_FLX_CR_ABR_FOUND', 52);
1183: fnd_message.set_name('BEN','BEN_91725_NO_FLX_CR_ABR_FOUND');
1184: fnd_message.set_token('PROC',l_proc);
1185: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1186: hr_utility.set_location(' enrt_rt_id='''||to_char(l_enrt_rt_id),52);
1187: close c_enrt_rt;

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

1180: hr_utility.set_location(l_proc, 20);
1181: if l_acty_base_rt_id is null then
1182: hr_utility.set_location('BEN_91725_NO_FLX_CR_ABR_FOUND', 52);
1183: fnd_message.set_name('BEN','BEN_91725_NO_FLX_CR_ABR_FOUND');
1184: fnd_message.set_token('PROC',l_proc);
1185: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1186: hr_utility.set_location(' enrt_rt_id='''||to_char(l_enrt_rt_id),52);
1187: close c_enrt_rt;
1188: fnd_message.raise_error;

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

1181: if l_acty_base_rt_id is null then
1182: hr_utility.set_location('BEN_91725_NO_FLX_CR_ABR_FOUND', 52);
1183: fnd_message.set_name('BEN','BEN_91725_NO_FLX_CR_ABR_FOUND');
1184: fnd_message.set_token('PROC',l_proc);
1185: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1186: hr_utility.set_location(' enrt_rt_id='''||to_char(l_enrt_rt_id),52);
1187: close c_enrt_rt;
1188: fnd_message.raise_error;
1189: end if;

Line 1188: fnd_message.raise_error;

1184: fnd_message.set_token('PROC',l_proc);
1185: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1186: hr_utility.set_location(' enrt_rt_id='''||to_char(l_enrt_rt_id),52);
1187: close c_enrt_rt;
1188: fnd_message.raise_error;
1189: end if;
1190:
1191: hr_utility.set_location(' choice_id='||to_char(p_epe_rec.elig_per_elctbl_chc_id),51);
1192: hr_utility.set_location('looking for POOL p_epe_rec.bnft_prvdr_pool_id'||

Line 2079: fnd_message.set_name('BEN','BEN_91724_NO_FLX_CR_RT_FOUND');

2075: if c_enrt_rt%notfound
2076: then
2077: -- error
2078: hr_utility.set_location('BEN_91724_NO_FLX_CR_RT_FOUND', 51);
2079: fnd_message.set_name('BEN','BEN_91724_NO_FLX_CR_RT_FOUND');
2080: fnd_message.set_token('PROC',l_proc);
2081: close c_enrt_rt;
2082: fnd_message.raise_error;
2083: end if;

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

2076: then
2077: -- error
2078: hr_utility.set_location('BEN_91724_NO_FLX_CR_RT_FOUND', 51);
2079: fnd_message.set_name('BEN','BEN_91724_NO_FLX_CR_RT_FOUND');
2080: fnd_message.set_token('PROC',l_proc);
2081: close c_enrt_rt;
2082: fnd_message.raise_error;
2083: end if;
2084: close c_enrt_rt;

Line 2082: fnd_message.raise_error;

2078: hr_utility.set_location('BEN_91724_NO_FLX_CR_RT_FOUND', 51);
2079: fnd_message.set_name('BEN','BEN_91724_NO_FLX_CR_RT_FOUND');
2080: fnd_message.set_token('PROC',l_proc);
2081: close c_enrt_rt;
2082: fnd_message.raise_error;
2083: end if;
2084: close c_enrt_rt;
2085: if l_enrt_rt.acty_base_rt_id is null then
2086: hr_utility.set_location('BEN_91725_NO_FLX_CR_ABR_FOUND', 52);

Line 2087: fnd_message.set_name('BEN','BEN_91725_NO_FLX_CR_ABR_FOUND');

2083: end if;
2084: close c_enrt_rt;
2085: if l_enrt_rt.acty_base_rt_id is null then
2086: hr_utility.set_location('BEN_91725_NO_FLX_CR_ABR_FOUND', 52);
2087: fnd_message.set_name('BEN','BEN_91725_NO_FLX_CR_ABR_FOUND');
2088: fnd_message.set_token('PROC',l_proc);
2089: fnd_message.raise_error;
2090: end if;
2091: --

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

2084: close c_enrt_rt;
2085: if l_enrt_rt.acty_base_rt_id is null then
2086: hr_utility.set_location('BEN_91725_NO_FLX_CR_ABR_FOUND', 52);
2087: fnd_message.set_name('BEN','BEN_91725_NO_FLX_CR_ABR_FOUND');
2088: fnd_message.set_token('PROC',l_proc);
2089: fnd_message.raise_error;
2090: end if;
2091: --
2092: */

Line 2089: fnd_message.raise_error;

2085: if l_enrt_rt.acty_base_rt_id is null then
2086: hr_utility.set_location('BEN_91725_NO_FLX_CR_ABR_FOUND', 52);
2087: fnd_message.set_name('BEN','BEN_91725_NO_FLX_CR_ABR_FOUND');
2088: fnd_message.set_token('PROC',l_proc);
2089: fnd_message.raise_error;
2090: end if;
2091: --
2092: */
2093: close c_enrt_rt;

Line 2415: fnd_message.set_name('BEN','BEN_91726_NO_FLX_CR_CHOICE');

2411: --
2412: if (c_flex_credit_choice%notfound and
2413: nvl(p_rt_val,hr_api.g_number) <> hr_api.g_number ) then --Bug 3864152
2414: hr_utility.set_location('BEN_91726_NO_FLX_CR_CHOICE', 20);
2415: fnd_message.set_name('BEN','BEN_91726_NO_FLX_CR_CHOICE');
2416: fnd_message.set_token('PROC',l_proc);
2417: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
2418: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
2419: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

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

2412: if (c_flex_credit_choice%notfound and
2413: nvl(p_rt_val,hr_api.g_number) <> hr_api.g_number ) then --Bug 3864152
2414: hr_utility.set_location('BEN_91726_NO_FLX_CR_CHOICE', 20);
2415: fnd_message.set_name('BEN','BEN_91726_NO_FLX_CR_CHOICE');
2416: fnd_message.set_token('PROC',l_proc);
2417: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
2418: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
2419: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2420: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

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

2413: nvl(p_rt_val,hr_api.g_number) <> hr_api.g_number ) then --Bug 3864152
2414: hr_utility.set_location('BEN_91726_NO_FLX_CR_CHOICE', 20);
2415: fnd_message.set_name('BEN','BEN_91726_NO_FLX_CR_CHOICE');
2416: fnd_message.set_token('PROC',l_proc);
2417: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
2418: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
2419: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2420: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
2421: close c_flex_credit_choice;

Line 2418: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));

2414: hr_utility.set_location('BEN_91726_NO_FLX_CR_CHOICE', 20);
2415: fnd_message.set_name('BEN','BEN_91726_NO_FLX_CR_CHOICE');
2416: fnd_message.set_token('PROC',l_proc);
2417: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
2418: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
2419: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2420: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
2421: close c_flex_credit_choice;
2422: fnd_message.raise_error;

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

2415: fnd_message.set_name('BEN','BEN_91726_NO_FLX_CR_CHOICE');
2416: fnd_message.set_token('PROC',l_proc);
2417: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
2418: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
2419: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2420: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
2421: close c_flex_credit_choice;
2422: fnd_message.raise_error;
2423: else

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

2416: fnd_message.set_token('PROC',l_proc);
2417: fnd_message.set_token('PERSON_ID', to_char(p_person_id));
2418: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
2419: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2420: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
2421: close c_flex_credit_choice;
2422: fnd_message.raise_error;
2423: else
2424: --

Line 2422: fnd_message.raise_error;

2418: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
2419: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
2420: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
2421: close c_flex_credit_choice;
2422: fnd_message.raise_error;
2423: else
2424: --
2425: if l_flex_credit_choice.enrt_cvg_strt_dt > p_effective_date
2426: and l_flex_credit_choice.chc_pen_id <> p_per_in_ler_id then

Line 2471: fnd_message.set_name('BEN','BEN_92622_NET_CRED_RT_NOT_FND');

2467: ,l_prnt_acty_base_rt_id;
2468: if c_net_credits_rate%notfound then
2469: hr_utility.set_location('not found:'|| l_acty_typ_cd, 10);
2470: close c_net_credits_rate;
2471: fnd_message.set_name('BEN','BEN_92622_NET_CRED_RT_NOT_FND');
2472: fnd_message.raise_error;
2473: else
2474: close c_net_credits_rate;
2475: end if;

Line 2472: fnd_message.raise_error;

2468: if c_net_credits_rate%notfound then
2469: hr_utility.set_location('not found:'|| l_acty_typ_cd, 10);
2470: close c_net_credits_rate;
2471: fnd_message.set_name('BEN','BEN_92622_NET_CRED_RT_NOT_FND');
2472: fnd_message.raise_error;
2473: else
2474: close c_net_credits_rate;
2475: end if;
2476: --

Line 2486: fnd_message.set_name('BEN','BEN_92623_NET_CRE_CHLD_NOT_FND');

2482: ,l_child_acty_base_rt_id;
2483: --
2484: if c_net_credits_child%notfound then
2485: close c_net_credits_child;
2486: fnd_message.set_name('BEN','BEN_92623_NET_CRE_CHLD_NOT_FND');
2487: fnd_message.raise_error;
2488: else
2489: close c_net_credits_child;
2490: end if;

Line 2487: fnd_message.raise_error;

2483: --
2484: if c_net_credits_child%notfound then
2485: close c_net_credits_child;
2486: fnd_message.set_name('BEN','BEN_92623_NET_CRE_CHLD_NOT_FND');
2487: fnd_message.raise_error;
2488: else
2489: close c_net_credits_child;
2490: end if;
2491: --

Line 3185: fnd_message.set_name('BEN','BEN_DFLT_TRTMT_NOT_HNDLD');

3181: hr_utility.set_location(l_proc,30 );
3182: l_balance:=p_prvdd_val+p_rlld_up_val-p_used_val-p_rollover_val;
3183: else
3184: hr_utility.set_location(l_proc,40 );
3185: fnd_message.set_name('BEN','BEN_DFLT_TRTMT_NOT_HNDLD');
3186: fnd_message.set_token('PROC',l_proc);
3187: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
3188: fnd_message.set_token('DFLT_EXCS_TRTMT_CD',p_dflt_excs_trtmt_cd);
3189: fnd_message.raise_error;

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

3182: l_balance:=p_prvdd_val+p_rlld_up_val-p_used_val-p_rollover_val;
3183: else
3184: hr_utility.set_location(l_proc,40 );
3185: fnd_message.set_name('BEN','BEN_DFLT_TRTMT_NOT_HNDLD');
3186: fnd_message.set_token('PROC',l_proc);
3187: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
3188: fnd_message.set_token('DFLT_EXCS_TRTMT_CD',p_dflt_excs_trtmt_cd);
3189: fnd_message.raise_error;
3190: end if;

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

3183: else
3184: hr_utility.set_location(l_proc,40 );
3185: fnd_message.set_name('BEN','BEN_DFLT_TRTMT_NOT_HNDLD');
3186: fnd_message.set_token('PROC',l_proc);
3187: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
3188: fnd_message.set_token('DFLT_EXCS_TRTMT_CD',p_dflt_excs_trtmt_cd);
3189: fnd_message.raise_error;
3190: end if;
3191: hr_utility.set_location(l_proc,50 );

Line 3188: fnd_message.set_token('DFLT_EXCS_TRTMT_CD',p_dflt_excs_trtmt_cd);

3184: hr_utility.set_location(l_proc,40 );
3185: fnd_message.set_name('BEN','BEN_DFLT_TRTMT_NOT_HNDLD');
3186: fnd_message.set_token('PROC',l_proc);
3187: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
3188: fnd_message.set_token('DFLT_EXCS_TRTMT_CD',p_dflt_excs_trtmt_cd);
3189: fnd_message.raise_error;
3190: end if;
3191: hr_utility.set_location(l_proc,50 );
3192: --

Line 3189: fnd_message.raise_error;

3185: fnd_message.set_name('BEN','BEN_DFLT_TRTMT_NOT_HNDLD');
3186: fnd_message.set_token('PROC',l_proc);
3187: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
3188: fnd_message.set_token('DFLT_EXCS_TRTMT_CD',p_dflt_excs_trtmt_cd);
3189: fnd_message.raise_error;
3190: end if;
3191: hr_utility.set_location(l_proc,50 );
3192: --
3193: -- balance is rounded

Line 3309: fnd_message.set_name('BEN','BEN_91724_NO_FLX_CR_RT_FOUND');

3305: close c_cash_abr_from_epe;
3306: -- Bug 5447507
3307: --
3308: hr_utility.set_location(l_proc,200 );
3309: fnd_message.set_name('BEN','BEN_91724_NO_FLX_CR_RT_FOUND');
3310: fnd_message.set_token('PROC',l_proc);
3311: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
3312: hr_utility.set_location('BEN_91724_NO_FLX_CR_RT_FOUND', 220);
3313: hr_utility.set_location('pool_id='||to_char(p_bnft_prvdr_pool_id), 230);

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

3306: -- Bug 5447507
3307: --
3308: hr_utility.set_location(l_proc,200 );
3309: fnd_message.set_name('BEN','BEN_91724_NO_FLX_CR_RT_FOUND');
3310: fnd_message.set_token('PROC',l_proc);
3311: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
3312: hr_utility.set_location('BEN_91724_NO_FLX_CR_RT_FOUND', 220);
3313: hr_utility.set_location('pool_id='||to_char(p_bnft_prvdr_pool_id), 230);
3314: fnd_message.raise_error;

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

3307: --
3308: hr_utility.set_location(l_proc,200 );
3309: fnd_message.set_name('BEN','BEN_91724_NO_FLX_CR_RT_FOUND');
3310: fnd_message.set_token('PROC',l_proc);
3311: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
3312: hr_utility.set_location('BEN_91724_NO_FLX_CR_RT_FOUND', 220);
3313: hr_utility.set_location('pool_id='||to_char(p_bnft_prvdr_pool_id), 230);
3314: fnd_message.raise_error;
3315: --

Line 3314: fnd_message.raise_error;

3310: fnd_message.set_token('PROC',l_proc);
3311: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
3312: hr_utility.set_location('BEN_91724_NO_FLX_CR_RT_FOUND', 220);
3313: hr_utility.set_location('pool_id='||to_char(p_bnft_prvdr_pool_id), 230);
3314: fnd_message.raise_error;
3315: --
3316: end if;
3317: --
3318: close c_cash_abr_from_epe;

Line 4116: fnd_message.set_name('BEN','BEN_92538_POOL_NOT_FOUND');

4112: --
4113: -- error
4114: --
4115: close c_pool_info;
4116: fnd_message.set_name('BEN','BEN_92538_POOL_NOT_FOUND');
4117: fnd_message.set_token('PROC',l_proc);
4118: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4119: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
4120: fnd_message.set_token('BNFT_PRVDR_POOL_ID',

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

4113: -- error
4114: --
4115: close c_pool_info;
4116: fnd_message.set_name('BEN','BEN_92538_POOL_NOT_FOUND');
4117: fnd_message.set_token('PROC',l_proc);
4118: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4119: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
4120: fnd_message.set_token('BNFT_PRVDR_POOL_ID',
4121: to_char(p_bnft_prvdr_pool_id));

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

4114: --
4115: close c_pool_info;
4116: fnd_message.set_name('BEN','BEN_92538_POOL_NOT_FOUND');
4117: fnd_message.set_token('PROC',l_proc);
4118: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4119: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
4120: fnd_message.set_token('BNFT_PRVDR_POOL_ID',
4121: to_char(p_bnft_prvdr_pool_id));
4122: hr_utility.set_location(l_proc,20);

Line 4119: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));

4115: close c_pool_info;
4116: fnd_message.set_name('BEN','BEN_92538_POOL_NOT_FOUND');
4117: fnd_message.set_token('PROC',l_proc);
4118: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4119: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
4120: fnd_message.set_token('BNFT_PRVDR_POOL_ID',
4121: to_char(p_bnft_prvdr_pool_id));
4122: hr_utility.set_location(l_proc,20);
4123: fnd_message.raise_error;

Line 4120: fnd_message.set_token('BNFT_PRVDR_POOL_ID',

4116: fnd_message.set_name('BEN','BEN_92538_POOL_NOT_FOUND');
4117: fnd_message.set_token('PROC',l_proc);
4118: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4119: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
4120: fnd_message.set_token('BNFT_PRVDR_POOL_ID',
4121: to_char(p_bnft_prvdr_pool_id));
4122: hr_utility.set_location(l_proc,20);
4123: fnd_message.raise_error;
4124: end if;

Line 4123: fnd_message.raise_error;

4119: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(p_acty_base_rt_id));
4120: fnd_message.set_token('BNFT_PRVDR_POOL_ID',
4121: to_char(p_bnft_prvdr_pool_id));
4122: hr_utility.set_location(l_proc,20);
4123: fnd_message.raise_error;
4124: end if;
4125: hr_utility.set_location(l_proc,30 );
4126: if l_pool_info.dflt_excs_trtmt_cd in ('DSTRBT_RLOVR_FRFT','RLOVR_DSTRBT_FRFT') then
4127: --

Line 4160: fnd_message.set_name('BEN','BEN_92960_RLOVR_VAL_GT_MXDPN');

4156: -- Raise errors if entered rollover value exceeds any limits set
4157: --
4158: if p_new_rollover_val /* g_balance */ > g_mx_dstrbl_pct_num then
4159: --
4160: fnd_message.set_name('BEN','BEN_92960_RLOVR_VAL_GT_MXDPN');
4161: hr_utility.set_location(l_proc,40);
4162: fnd_message.raise_error;
4163: --
4164: end if;

Line 4162: fnd_message.raise_error;

4158: if p_new_rollover_val /* g_balance */ > g_mx_dstrbl_pct_num then
4159: --
4160: fnd_message.set_name('BEN','BEN_92960_RLOVR_VAL_GT_MXDPN');
4161: hr_utility.set_location(l_proc,40);
4162: fnd_message.raise_error;
4163: --
4164: end if;
4165: --
4166: if p_new_rollover_val /* g_balance */ > g_mx_rlovr_val then

Line 4168: fnd_message.set_name('BEN','BEN_92961_RLOVR_VAL_GT_MXRV');

4164: end if;
4165: --
4166: if p_new_rollover_val /* g_balance */ > g_mx_rlovr_val then
4167: --
4168: fnd_message.set_name('BEN','BEN_92961_RLOVR_VAL_GT_MXRV');
4169: hr_utility.set_location(l_proc,41);
4170: fnd_message.raise_error;
4171: --
4172: end if;

Line 4170: fnd_message.raise_error;

4166: if p_new_rollover_val /* g_balance */ > g_mx_rlovr_val then
4167: --
4168: fnd_message.set_name('BEN','BEN_92961_RLOVR_VAL_GT_MXRV');
4169: hr_utility.set_location(l_proc,41);
4170: fnd_message.raise_error;
4171: --
4172: end if;
4173: if p_new_rollover_val /* g_balance */ > g_mx_elcn_val then
4174: --

Line 4175: fnd_message.set_name('BEN','BEN_92962_RLOVR_VAL_GT_MXEV');

4171: --
4172: end if;
4173: if p_new_rollover_val /* g_balance */ > g_mx_elcn_val then
4174: --
4175: fnd_message.set_name('BEN','BEN_92962_RLOVR_VAL_GT_MXEV');
4176: hr_utility.set_location(l_proc,42);
4177: fnd_message.raise_error;
4178: --
4179: end if;

Line 4177: fnd_message.raise_error;

4173: if p_new_rollover_val /* g_balance */ > g_mx_elcn_val then
4174: --
4175: fnd_message.set_name('BEN','BEN_92962_RLOVR_VAL_GT_MXEV');
4176: hr_utility.set_location(l_proc,42);
4177: fnd_message.raise_error;
4178: --
4179: end if;
4180: --
4181: if p_new_rollover_val /* g_balance */ > g_mx_rlovr_rl_val then

Line 4183: fnd_message.set_name('BEN','BEN_92963_RLOVR_VAL_GT_MXRRV');

4179: end if;
4180: --
4181: if p_new_rollover_val /* g_balance */ > g_mx_rlovr_rl_val then
4182: --
4183: fnd_message.set_name('BEN','BEN_92963_RLOVR_VAL_GT_MXRRV');
4184: hr_utility.set_location(l_proc,43);
4185: fnd_message.raise_error;
4186: --
4187: end if;

Line 4185: fnd_message.raise_error;

4181: if p_new_rollover_val /* g_balance */ > g_mx_rlovr_rl_val then
4182: --
4183: fnd_message.set_name('BEN','BEN_92963_RLOVR_VAL_GT_MXRRV');
4184: hr_utility.set_location(l_proc,43);
4185: fnd_message.raise_error;
4186: --
4187: end if;
4188: --
4189: --

Line 4192: fnd_message.set_name('BEN','BEN_92964_RLOVR_VAL_GT_MNDPN');

4188: --
4189: --
4190: if p_new_rollover_val /* g_balance */ < g_mn_dstrbl_pct_num then
4191: --
4192: fnd_message.set_name('BEN','BEN_92964_RLOVR_VAL_GT_MNDPN');
4193: hr_utility.set_location(l_proc,44);
4194: fnd_message.raise_error;
4195: --
4196: end if;

Line 4194: fnd_message.raise_error;

4190: if p_new_rollover_val /* g_balance */ < g_mn_dstrbl_pct_num then
4191: --
4192: fnd_message.set_name('BEN','BEN_92964_RLOVR_VAL_GT_MNDPN');
4193: hr_utility.set_location(l_proc,44);
4194: fnd_message.raise_error;
4195: --
4196: end if;
4197: --
4198: if p_new_rollover_val /* g_balance */ < g_mn_rlovr_val then

Line 4200: fnd_message.set_name('BEN','BEN_92965_RLOVR_VAL_GT_MNRV');

4196: end if;
4197: --
4198: if p_new_rollover_val /* g_balance */ < g_mn_rlovr_val then
4199: --
4200: fnd_message.set_name('BEN','BEN_92965_RLOVR_VAL_GT_MNRV');
4201: hr_utility.set_location(l_proc,45);
4202: fnd_message.raise_error;
4203: --
4204: end if;

Line 4202: fnd_message.raise_error;

4198: if p_new_rollover_val /* g_balance */ < g_mn_rlovr_val then
4199: --
4200: fnd_message.set_name('BEN','BEN_92965_RLOVR_VAL_GT_MNRV');
4201: hr_utility.set_location(l_proc,45);
4202: fnd_message.raise_error;
4203: --
4204: end if;
4205: if p_new_rollover_val /* g_balance */ < g_mn_elcn_val then
4206: --

Line 4207: fnd_message.set_name('BEN','BEN_92966_RLOVR_VAL_GT_MNEV');

4203: --
4204: end if;
4205: if p_new_rollover_val /* g_balance */ < g_mn_elcn_val then
4206: --
4207: fnd_message.set_name('BEN','BEN_92966_RLOVR_VAL_GT_MNEV');
4208: hr_utility.set_location(l_proc,46);
4209: fnd_message.raise_error;
4210: --
4211: end if;

Line 4209: fnd_message.raise_error;

4205: if p_new_rollover_val /* g_balance */ < g_mn_elcn_val then
4206: --
4207: fnd_message.set_name('BEN','BEN_92966_RLOVR_VAL_GT_MNEV');
4208: hr_utility.set_location(l_proc,46);
4209: fnd_message.raise_error;
4210: --
4211: end if;
4212: --
4213: -- Reset globals

Line 4351: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');

4347: hr_utility.set_location('BEN_91457_ELCTBL_CHC_NOT_FOUND ACTY_id:'||
4348: to_char(p_acty_base_rt_id), 20); hr_utility.set_location('p_person_id:'||to_char(p_person_id), 20);
4349: hr_utility.set_location('p_business_group_id:'||to_char(p_business_group_id), 20);
4350: close c_rlovr_chc;
4351: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4352: fnd_message.set_token('ID', 'NA');
4353: fnd_message.set_token('PROC',l_proc);
4354: fnd_message.raise_error;
4355: end if;

Line 4352: fnd_message.set_token('ID', 'NA');

4348: to_char(p_acty_base_rt_id), 20); hr_utility.set_location('p_person_id:'||to_char(p_person_id), 20);
4349: hr_utility.set_location('p_business_group_id:'||to_char(p_business_group_id), 20);
4350: close c_rlovr_chc;
4351: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4352: fnd_message.set_token('ID', 'NA');
4353: fnd_message.set_token('PROC',l_proc);
4354: fnd_message.raise_error;
4355: end if;
4356: close c_rlovr_chc;

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

4349: hr_utility.set_location('p_business_group_id:'||to_char(p_business_group_id), 20);
4350: close c_rlovr_chc;
4351: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4352: fnd_message.set_token('ID', 'NA');
4353: fnd_message.set_token('PROC',l_proc);
4354: fnd_message.raise_error;
4355: end if;
4356: close c_rlovr_chc;
4357:

Line 4354: fnd_message.raise_error;

4350: close c_rlovr_chc;
4351: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
4352: fnd_message.set_token('ID', 'NA');
4353: fnd_message.set_token('PROC',l_proc);
4354: fnd_message.raise_error;
4355: end if;
4356: close c_rlovr_chc;
4357:
4358: --

Line 4764: fnd_message.set_name('BEN','BEN_91725_NO_FLX_CR_ABR_FOUND');

4760: if c_get_pool_abr%notfound then
4761: close c_cash_abr;
4762: close c_get_pool_abr;
4763: hr_utility.set_location(l_proc,15);
4764: fnd_message.set_name('BEN','BEN_91725_NO_FLX_CR_ABR_FOUND');
4765: fnd_message.set_token('PROC',l_proc);
4766: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4767: fnd_message.raise_error;
4768: end if;

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

4761: close c_cash_abr;
4762: close c_get_pool_abr;
4763: hr_utility.set_location(l_proc,15);
4764: fnd_message.set_name('BEN','BEN_91725_NO_FLX_CR_ABR_FOUND');
4765: fnd_message.set_token('PROC',l_proc);
4766: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4767: fnd_message.raise_error;
4768: end if;
4769: close c_get_pool_abr;

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

4762: close c_get_pool_abr;
4763: hr_utility.set_location(l_proc,15);
4764: fnd_message.set_name('BEN','BEN_91725_NO_FLX_CR_ABR_FOUND');
4765: fnd_message.set_token('PROC',l_proc);
4766: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4767: fnd_message.raise_error;
4768: end if;
4769: close c_get_pool_abr;
4770: -- Bug : 1711831

Line 4767: fnd_message.raise_error;

4763: hr_utility.set_location(l_proc,15);
4764: fnd_message.set_name('BEN','BEN_91725_NO_FLX_CR_ABR_FOUND');
4765: fnd_message.set_token('PROC',l_proc);
4766: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4767: fnd_message.raise_error;
4768: end if;
4769: close c_get_pool_abr;
4770: -- Bug : 1711831
4771: end if;

Line 4793: fnd_message.set_name('BEN','BEN_92538_POOL_NOT_FOUND');

4789: --
4790: -- error
4791: --
4792: close c_pool_info;
4793: fnd_message.set_name('BEN','BEN_92538_POOL_NOT_FOUND');
4794: fnd_message.set_token('PROC',l_proc);
4795: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4796: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(l_acty_base_rt_id));
4797: fnd_message.set_token('BNFT_PRVDR_POOL_ID',

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

4790: -- error
4791: --
4792: close c_pool_info;
4793: fnd_message.set_name('BEN','BEN_92538_POOL_NOT_FOUND');
4794: fnd_message.set_token('PROC',l_proc);
4795: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4796: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(l_acty_base_rt_id));
4797: fnd_message.set_token('BNFT_PRVDR_POOL_ID',
4798: to_char(l_ledger_totals.bnft_prvdr_pool_id));

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

4791: --
4792: close c_pool_info;
4793: fnd_message.set_name('BEN','BEN_92538_POOL_NOT_FOUND');
4794: fnd_message.set_token('PROC',l_proc);
4795: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4796: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(l_acty_base_rt_id));
4797: fnd_message.set_token('BNFT_PRVDR_POOL_ID',
4798: to_char(l_ledger_totals.bnft_prvdr_pool_id));
4799: hr_utility.set_location(l_proc,70);

Line 4796: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(l_acty_base_rt_id));

4792: close c_pool_info;
4793: fnd_message.set_name('BEN','BEN_92538_POOL_NOT_FOUND');
4794: fnd_message.set_token('PROC',l_proc);
4795: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4796: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(l_acty_base_rt_id));
4797: fnd_message.set_token('BNFT_PRVDR_POOL_ID',
4798: to_char(l_ledger_totals.bnft_prvdr_pool_id));
4799: hr_utility.set_location(l_proc,70);
4800: fnd_message.raise_error;

Line 4797: fnd_message.set_token('BNFT_PRVDR_POOL_ID',

4793: fnd_message.set_name('BEN','BEN_92538_POOL_NOT_FOUND');
4794: fnd_message.set_token('PROC',l_proc);
4795: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4796: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(l_acty_base_rt_id));
4797: fnd_message.set_token('BNFT_PRVDR_POOL_ID',
4798: to_char(l_ledger_totals.bnft_prvdr_pool_id));
4799: hr_utility.set_location(l_proc,70);
4800: fnd_message.raise_error;
4801: end if;

Line 4800: fnd_message.raise_error;

4796: fnd_message.set_token('ACTY_BASE_RT_ID',to_char(l_acty_base_rt_id));
4797: fnd_message.set_token('BNFT_PRVDR_POOL_ID',
4798: to_char(l_ledger_totals.bnft_prvdr_pool_id));
4799: hr_utility.set_location(l_proc,70);
4800: fnd_message.raise_error;
4801: end if;
4802: close c_pool_info;
4803: --
4804: end if;

Line 4829: fnd_message.set_name('BEN', 'BEN_92620_EXCEED_TOT_DFCIT_PCT');

4825: l_deficit_limit :=
4826: l_pool_info.mx_dfcit_pct_pool_crs_num/100 * l_ledger_totals.prvdd_total;
4827: hr_utility.set_location('l_deficit_limit: '||l_deficit_limit,70);
4828: if abs(l_def_exc_amt) > l_deficit_limit then
4829: fnd_message.set_name('BEN', 'BEN_92620_EXCEED_TOT_DFCIT_PCT');
4830: fnd_message.raise_error;
4831: end if;
4832: end if;
4833: --

Line 4830: fnd_message.raise_error;

4826: l_pool_info.mx_dfcit_pct_pool_crs_num/100 * l_ledger_totals.prvdd_total;
4827: hr_utility.set_location('l_deficit_limit: '||l_deficit_limit,70);
4828: if abs(l_def_exc_amt) > l_deficit_limit then
4829: fnd_message.set_name('BEN', 'BEN_92620_EXCEED_TOT_DFCIT_PCT');
4830: fnd_message.raise_error;
4831: end if;
4832: end if;
4833: --
4834: -- Cannot exceed the maximum percent of compensation.

Line 4855: fnd_message.set_name('BEN', 'BEN_92621_DFCIT_EXC_COMP_PCT');

4851: l_deficit_limit :=
4852: l_pool_info.mx_dfcit_pct_comp_num/100 * l_compensation_value;
4853: hr_utility.set_location('l_deficit_limit_c: '||l_deficit_limit,70);
4854: if abs(l_def_exc_amt) > l_deficit_limit then
4855: fnd_message.set_name('BEN', 'BEN_92621_DFCIT_EXC_COMP_PCT');
4856: fnd_message.raise_error;
4857: end if;
4858: end if;
4859: end if;

Line 4856: fnd_message.raise_error;

4852: l_pool_info.mx_dfcit_pct_comp_num/100 * l_compensation_value;
4853: hr_utility.set_location('l_deficit_limit_c: '||l_deficit_limit,70);
4854: if abs(l_def_exc_amt) > l_deficit_limit then
4855: fnd_message.set_name('BEN', 'BEN_92621_DFCIT_EXC_COMP_PCT');
4856: fnd_message.raise_error;
4857: end if;
4858: end if;
4859: end if;
4860: end if;

Line 5039: fnd_message.set_name('BEN', 'BEN_92636_TOT_POOL_PCT_EXCD');

5035: for l_bpr_rec in c_get_mx_pct_roll_num loop
5036: for l_bpl_rec in c_get_ldgr(l_bpr_rec.acty_base_rt_id) loop
5037: if l_bpl_rec.used_val > ((l_bpr_rec.mx_pct_ttl_crs_cn_roll_num/100)
5038: * l_ledger_totals.prvdd_total) then
5039: fnd_message.set_name('BEN', 'BEN_92636_TOT_POOL_PCT_EXCD');
5040: fnd_message.raise_error;
5041: end if;
5042: end loop;
5043: end loop;

Line 5040: fnd_message.raise_error;

5036: for l_bpl_rec in c_get_ldgr(l_bpr_rec.acty_base_rt_id) loop
5037: if l_bpl_rec.used_val > ((l_bpr_rec.mx_pct_ttl_crs_cn_roll_num/100)
5038: * l_ledger_totals.prvdd_total) then
5039: fnd_message.set_name('BEN', 'BEN_92636_TOT_POOL_PCT_EXCD');
5040: fnd_message.raise_error;
5041: end if;
5042: end loop;
5043: end loop;
5044: --