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_APR_BUS dependencies on FND_MESSAGE

Line 181: fnd_message.set_name('BEN','BEN_92549_NO_ORG_EXIST_PLN');

177: --
178: -- raise error as FK does not relate to PK in
179: -- hr_all_organization_units table.
180: --
181: fnd_message.set_name('BEN','BEN_92549_NO_ORG_EXIST_PLN');
182: fnd_message.set_token('PL_ID',to_char(p_pl_id));
183: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
184: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
185: fnd_message.raise_error;

Line 182: fnd_message.set_token('PL_ID',to_char(p_pl_id));

178: -- raise error as FK does not relate to PK in
179: -- hr_all_organization_units table.
180: --
181: fnd_message.set_name('BEN','BEN_92549_NO_ORG_EXIST_PLN');
182: fnd_message.set_token('PL_ID',to_char(p_pl_id));
183: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
184: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
185: fnd_message.raise_error;
186: --

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

179: -- hr_all_organization_units table.
180: --
181: fnd_message.set_name('BEN','BEN_92549_NO_ORG_EXIST_PLN');
182: fnd_message.set_token('PL_ID',to_char(p_pl_id));
183: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
184: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
185: fnd_message.raise_error;
186: --
187: end if;

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

180: --
181: fnd_message.set_name('BEN','BEN_92549_NO_ORG_EXIST_PLN');
182: fnd_message.set_token('PL_ID',to_char(p_pl_id));
183: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
184: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
185: fnd_message.raise_error;
186: --
187: end if;
188: --

Line 185: fnd_message.raise_error;

181: fnd_message.set_name('BEN','BEN_92549_NO_ORG_EXIST_PLN');
182: fnd_message.set_token('PL_ID',to_char(p_pl_id));
183: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
184: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
185: fnd_message.raise_error;
186: --
187: end if;
188: --
189: close c1;

Line 203: fnd_message.set_name('BEN','BEN_92550_NO_ORG_EXIST_OIPL');

199: --
200: -- raise error as FK does not relate to PK in
201: -- hr_all_organization_units table.
202: --
203: fnd_message.set_name('BEN','BEN_92550_NO_ORG_EXIST_OIPL');
204: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
205: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
206: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
207: fnd_message.raise_error;

Line 204: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));

200: -- raise error as FK does not relate to PK in
201: -- hr_all_organization_units table.
202: --
203: fnd_message.set_name('BEN','BEN_92550_NO_ORG_EXIST_OIPL');
204: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
205: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
206: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
207: fnd_message.raise_error;
208: --

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

201: -- hr_all_organization_units table.
202: --
203: fnd_message.set_name('BEN','BEN_92550_NO_ORG_EXIST_OIPL');
204: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
205: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
206: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
207: fnd_message.raise_error;
208: --
209: end if;

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

202: --
203: fnd_message.set_name('BEN','BEN_92550_NO_ORG_EXIST_OIPL');
204: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
205: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
206: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
207: fnd_message.raise_error;
208: --
209: end if;
210: --

Line 207: fnd_message.raise_error;

203: fnd_message.set_name('BEN','BEN_92550_NO_ORG_EXIST_OIPL');
204: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
205: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
206: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
207: fnd_message.raise_error;
208: --
209: end if;
210: --
211: close c2;

Line 302: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

298: close c1;
299: --
300: -- raise error
301: --
302: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
303: fnd_message.set_token('ID',p_rndg_rl);
304: fnd_message.set_token('TYPE_ID',-169);
305: fnd_message.raise_error;
306: --

Line 303: fnd_message.set_token('ID',p_rndg_rl);

299: --
300: -- raise error
301: --
302: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
303: fnd_message.set_token('ID',p_rndg_rl);
304: fnd_message.set_token('TYPE_ID',-169);
305: fnd_message.raise_error;
306: --
307: end if;

Line 304: fnd_message.set_token('TYPE_ID',-169);

300: -- raise error
301: --
302: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
303: fnd_message.set_token('ID',p_rndg_rl);
304: fnd_message.set_token('TYPE_ID',-169);
305: fnd_message.raise_error;
306: --
307: end if;
308: --

Line 305: fnd_message.raise_error;

301: --
302: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
303: fnd_message.set_token('ID',p_rndg_rl);
304: fnd_message.set_token('TYPE_ID',-169);
305: fnd_message.raise_error;
306: --
307: end if;
308: --
309: close c1;

Line 397: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

393: close c1;
394: --
395: -- raise error
396: --
397: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
398: fnd_message.set_token('ID',p_val_calc_rl);
399: fnd_message.set_token('TYPE_ID',-507);
400: fnd_message.raise_error;
401: --

Line 398: fnd_message.set_token('ID',p_val_calc_rl);

394: --
395: -- raise error
396: --
397: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
398: fnd_message.set_token('ID',p_val_calc_rl);
399: fnd_message.set_token('TYPE_ID',-507);
400: fnd_message.raise_error;
401: --
402: end if;

Line 399: fnd_message.set_token('TYPE_ID',-507);

395: -- raise error
396: --
397: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
398: fnd_message.set_token('ID',p_val_calc_rl);
399: fnd_message.set_token('TYPE_ID',-507);
400: fnd_message.raise_error;
401: --
402: end if;
403: --

Line 400: fnd_message.raise_error;

396: --
397: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
398: fnd_message.set_token('ID',p_val_calc_rl);
399: fnd_message.set_token('TYPE_ID',-507);
400: fnd_message.raise_error;
401: --
402: end if;
403: --
404: close c1;

Line 492: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

488: close c1;
489: --
490: -- raise error
491: --
492: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
493: fnd_message.set_token('ID',p_vrbl_rt_add_on_calc_rl);
494: fnd_message.set_token('TYPE_ID',-529);
495: fnd_message.raise_error;
496: --

Line 493: fnd_message.set_token('ID',p_vrbl_rt_add_on_calc_rl);

489: --
490: -- raise error
491: --
492: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
493: fnd_message.set_token('ID',p_vrbl_rt_add_on_calc_rl);
494: fnd_message.set_token('TYPE_ID',-529);
495: fnd_message.raise_error;
496: --
497: end if;

Line 494: fnd_message.set_token('TYPE_ID',-529);

490: -- raise error
491: --
492: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
493: fnd_message.set_token('ID',p_vrbl_rt_add_on_calc_rl);
494: fnd_message.set_token('TYPE_ID',-529);
495: fnd_message.raise_error;
496: --
497: end if;
498: --

Line 495: fnd_message.raise_error;

491: --
492: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
493: fnd_message.set_token('ID',p_vrbl_rt_add_on_calc_rl);
494: fnd_message.set_token('TYPE_ID',-529);
495: fnd_message.raise_error;
496: --
497: end if;
498: --
499: close c1;

Line 565: fnd_message.set_name('BEN','BEN_91041_INVALID_RNDG_CD');

561: p_effective_date => p_effective_date) then
562: --
563: -- raise error as does not exist as lookup
564: --
565: fnd_message.set_name('BEN','BEN_91041_INVALID_RNDG_CD');
566: fnd_message.raise_error;
567: --
568: end if;
569: --

Line 566: fnd_message.raise_error;

562: --
563: -- raise error as does not exist as lookup
564: --
565: fnd_message.set_name('BEN','BEN_91041_INVALID_RNDG_CD');
566: fnd_message.raise_error;
567: --
568: end if;
569: --
570: end if;

Line 634: fnd_message.set_name('BEN','BEN_91606_INVALID_PRODUCT_CD');

630: p_effective_date => p_effective_date) then
631: --
632: -- raise error as does not exist as lookup
633: --
634: fnd_message.set_name('BEN','BEN_91606_INVALID_PRODUCT_CD');
635: fnd_message.raise_error;
636: --
637: end if;
638: --

Line 635: fnd_message.raise_error;

631: --
632: -- raise error as does not exist as lookup
633: --
634: fnd_message.set_name('BEN','BEN_91606_INVALID_PRODUCT_CD');
635: fnd_message.raise_error;
636: --
637: end if;
638: --
639: end if;

Line 703: fnd_message.set_name('BEN','BEN_91607_INVALID_MLT_CD');

699: p_effective_date => p_effective_date) then
700: --
701: -- raise error as does not exist as lookup
702: --
703: fnd_message.set_name('BEN','BEN_91607_INVALID_MLT_CD');
704: fnd_message.raise_error;
705: --
706: end if;
707: --

Line 704: fnd_message.raise_error;

700: --
701: -- raise error as does not exist as lookup
702: --
703: fnd_message.set_name('BEN','BEN_91607_INVALID_MLT_CD');
704: fnd_message.raise_error;
705: --
706: end if;
707: --
708: -- if mlt_cd is 'TPLPC' then defer the action.

Line 710: fnd_message.set_name('BEN','BEN_92504_PREM_CALC_MTHD_DFRD');

706: end if;
707: --
708: -- if mlt_cd is 'TPLPC' then defer the action.
709: if (p_mlt_cd = 'TPLPC') then
710: fnd_message.set_name('BEN','BEN_92504_PREM_CALC_MTHD_DFRD');
711: fnd_message.raise_error;
712: end if;
713: --
714: end if;

Line 711: fnd_message.raise_error;

707: --
708: -- if mlt_cd is 'TPLPC' then defer the action.
709: if (p_mlt_cd = 'TPLPC') then
710: fnd_message.set_name('BEN','BEN_92504_PREM_CALC_MTHD_DFRD');
711: fnd_message.raise_error;
712: end if;
713: --
714: end if;
715: --

Line 778: fnd_message.set_name('BEN','BEN_92239_INVLD_PRTL_MO_CD');

774: p_effective_date => p_effective_date) then
775: --
776: -- raise error as does not exist as lookup
777: --
778: fnd_message.set_name('BEN','BEN_92239_INVLD_PRTL_MO_CD');
779: fnd_message.raise_error;
780: --
781: end if;
782: --

Line 779: fnd_message.raise_error;

775: --
776: -- raise error as does not exist as lookup
777: --
778: fnd_message.set_name('BEN','BEN_92239_INVLD_PRTL_MO_CD');
779: fnd_message.raise_error;
780: --
781: end if;
782: --
783: end if;

Line 848: fnd_message.set_name('BEN','BEN_91192_RT_TYP_CD');

844: p_effective_date => p_effective_date) then
845: --
846: -- raise error as does not exist as lookup
847: --
848: fnd_message.set_name('BEN','BEN_91192_RT_TYP_CD');
849: fnd_message.raise_error;
850: --
851: end if;
852: --

Line 849: fnd_message.raise_error;

845: --
846: -- raise error as does not exist as lookup
847: --
848: fnd_message.set_name('BEN','BEN_91192_RT_TYP_CD');
849: fnd_message.raise_error;
850: --
851: end if;
852: --
853: end if;

Line 918: fnd_message.set_name('BEN','BEN_91608_INVALID_BNFT_RT_TYP');

914: p_effective_date => p_effective_date) then
915: --
916: -- raise error as does not exist as lookup
917: --
918: fnd_message.set_name('BEN','BEN_91608_INVALID_BNFT_RT_TYP');
919: fnd_message.raise_error;
920: --
921: end if;
922: --

Line 919: fnd_message.raise_error;

915: --
916: -- raise error as does not exist as lookup
917: --
918: fnd_message.set_name('BEN','BEN_91608_INVALID_BNFT_RT_TYP');
919: fnd_message.raise_error;
920: --
921: end if;
922: --
923: end if;

Line 988: fnd_message.set_name('BEN','BEN_91299_INV_ACTY_REF_PERD_CD');

984: p_effective_date => p_effective_date) then
985: --
986: -- raise error as does not exist as lookup
987: --
988: fnd_message.set_name('BEN','BEN_91299_INV_ACTY_REF_PERD_CD');
989: fnd_message.raise_error;
990: --
991: end if;
992: --

Line 989: fnd_message.raise_error;

985: --
986: -- raise error as does not exist as lookup
987: --
988: fnd_message.set_name('BEN','BEN_91299_INV_ACTY_REF_PERD_CD');
989: fnd_message.raise_error;
990: --
991: end if;
992: --
993: end if;

Line 1076: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');

1072: --
1073: -- raise error as UK1 is violated
1074: --
1075: hr_utility.set_location('before message'||p_name,10);
1076: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
1077: fnd_message.raise_error;
1078: --
1079: end if;
1080: --

Line 1077: fnd_message.raise_error;

1073: -- raise error as UK1 is violated
1074: --
1075: hr_utility.set_location('before message'||p_name,10);
1076: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
1077: fnd_message.raise_error;
1078: --
1079: end if;
1080: --
1081: end if;

Line 1137: -- fnd_message.set_name('BEN','BEN_91602_APR_MLT_CD');

1133: -- p_object_version_number => p_object_version_number);
1134: --
1135: -- Multiple Code must be equal to CVG or null.
1136: -- If P_MLT_CD <> 'CVG' and P_MLT_CD is not null then
1137: -- fnd_message.set_name('BEN','BEN_91602_APR_MLT_CD');
1138: -- fnd_message.raise_error;
1139: -- end if;
1140: -- If rate type code is flat then multiple code must be null.
1141: -- If P_RT_TYP_CD = 'FLAT' and P_MLT_CD is not null then

Line 1138: -- fnd_message.raise_error;

1134: --
1135: -- Multiple Code must be equal to CVG or null.
1136: -- If P_MLT_CD <> 'CVG' and P_MLT_CD is not null then
1137: -- fnd_message.set_name('BEN','BEN_91602_APR_MLT_CD');
1138: -- fnd_message.raise_error;
1139: -- end if;
1140: -- If rate type code is flat then multiple code must be null.
1141: -- If P_RT_TYP_CD = 'FLAT' and P_MLT_CD is not null then
1142: -- fnd_message.set_name('BEN','BEN_91603_APR_RT_TYP_MLT_CD');

Line 1142: -- fnd_message.set_name('BEN','BEN_91603_APR_RT_TYP_MLT_CD');

1138: -- fnd_message.raise_error;
1139: -- end if;
1140: -- If rate type code is flat then multiple code must be null.
1141: -- If P_RT_TYP_CD = 'FLAT' and P_MLT_CD is not null then
1142: -- fnd_message.set_name('BEN','BEN_91603_APR_RT_TYP_MLT_CD');
1143: -- fnd_message.raise_error;
1144: -- end if;
1145: --
1146: -- end if;

Line 1143: -- fnd_message.raise_error;

1139: -- end if;
1140: -- If rate type code is flat then multiple code must be null.
1141: -- If P_RT_TYP_CD = 'FLAT' and P_MLT_CD is not null then
1142: -- fnd_message.set_name('BEN','BEN_91603_APR_RT_TYP_MLT_CD');
1143: -- fnd_message.raise_error;
1144: -- end if;
1145: --
1146: -- end if;
1147: --

Line 1192: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');

1188: hr_utility.set_location('Entering:'||l_proc, 5);
1189: --
1190: if p_code <> 'RL' and p_rule is not null then
1191: --
1192: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
1193: fnd_message.raise_error;
1194: --
1195: elsif p_code = 'RL' and p_rule is null then
1196: --

Line 1193: fnd_message.raise_error;

1189: --
1190: if p_code <> 'RL' and p_rule is not null then
1191: --
1192: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
1193: fnd_message.raise_error;
1194: --
1195: elsif p_code = 'RL' and p_rule is null then
1196: --
1197: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');

Line 1197: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');

1193: fnd_message.raise_error;
1194: --
1195: elsif p_code = 'RL' and p_rule is null then
1196: --
1197: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
1198: fnd_message.raise_error;
1199: --
1200: end if;
1201: --

Line 1198: fnd_message.raise_error;

1194: --
1195: elsif p_code = 'RL' and p_rule is null then
1196: --
1197: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
1198: fnd_message.raise_error;
1199: --
1200: end if;
1201: --
1202: if p_code <> 'WASHRULE' and p_num is not null then

Line 1204: fnd_message.set_name('BEN','BEN_92270_NTWSHRL_NUM_NTNULL');

1200: end if;
1201: --
1202: if p_code <> 'WASHRULE' and p_num is not null then
1203: --
1204: fnd_message.set_name('BEN','BEN_92270_NTWSHRL_NUM_NTNULL');
1205: fnd_message.raise_error;
1206: --
1207: elsif p_code = 'WASHRULE' and p_num is null then
1208: --

Line 1205: fnd_message.raise_error;

1201: --
1202: if p_code <> 'WASHRULE' and p_num is not null then
1203: --
1204: fnd_message.set_name('BEN','BEN_92270_NTWSHRL_NUM_NTNULL');
1205: fnd_message.raise_error;
1206: --
1207: elsif p_code = 'WASHRULE' and p_num is null then
1208: --
1209: fnd_message.set_name('BEN','BEN_92271_NTWSHRL_NUM_NULL');

Line 1209: fnd_message.set_name('BEN','BEN_92271_NTWSHRL_NUM_NULL');

1205: fnd_message.raise_error;
1206: --
1207: elsif p_code = 'WASHRULE' and p_num is null then
1208: --
1209: fnd_message.set_name('BEN','BEN_92271_NTWSHRL_NUM_NULL');
1210: fnd_message.raise_error;
1211: --
1212: end if;
1213: --

Line 1210: fnd_message.raise_error;

1206: --
1207: elsif p_code = 'WASHRULE' and p_num is null then
1208: --
1209: fnd_message.set_name('BEN','BEN_92271_NTWSHRL_NUM_NULL');
1210: fnd_message.raise_error;
1211: --
1212: end if;
1213: --
1214: hr_utility.set_location('Leaving:'||l_proc,10);

Line 1265: fnd_message.set_name('BEN', 'BEN_92272_ASGN_ENRT_LVL_NPRTT');

1261: hr_utility.set_location('Entering:'||l_proc, 5);
1262: --
1263: if (p_prem_asnmt_cd = 'ENRT' and p_prem_asnmt_lvl_cd <> 'PRTT')
1264: then
1265: fnd_message.set_name('BEN', 'BEN_92272_ASGN_ENRT_LVL_NPRTT');
1266: fnd_message.raise_error;
1267: end if;
1268: if (p_prem_asnmt_cd = 'ENRT'
1269: and p_mlt_cd not in ('NSVU', 'RL', 'FLFX','CVG')) then

Line 1266: fnd_message.raise_error;

1262: --
1263: if (p_prem_asnmt_cd = 'ENRT' and p_prem_asnmt_lvl_cd <> 'PRTT')
1264: then
1265: fnd_message.set_name('BEN', 'BEN_92272_ASGN_ENRT_LVL_NPRTT');
1266: fnd_message.raise_error;
1267: end if;
1268: if (p_prem_asnmt_cd = 'ENRT'
1269: and p_mlt_cd not in ('NSVU', 'RL', 'FLFX','CVG')) then
1270: fnd_message.set_name('BEN', 'BEN_92274_ASGN_PROC_MLT_BAD');

Line 1270: fnd_message.set_name('BEN', 'BEN_92274_ASGN_PROC_MLT_BAD');

1266: fnd_message.raise_error;
1267: end if;
1268: if (p_prem_asnmt_cd = 'ENRT'
1269: and p_mlt_cd not in ('NSVU', 'RL', 'FLFX','CVG')) then
1270: fnd_message.set_name('BEN', 'BEN_92274_ASGN_PROC_MLT_BAD');
1271: fnd_message.raise_error;
1272: end if;
1273:
1274: if (p_prem_asnmt_cd = 'PROC' and p_prem_asnmt_lvl_cd = 'PRTT') then

Line 1271: fnd_message.raise_error;

1267: end if;
1268: if (p_prem_asnmt_cd = 'ENRT'
1269: and p_mlt_cd not in ('NSVU', 'RL', 'FLFX','CVG')) then
1270: fnd_message.set_name('BEN', 'BEN_92274_ASGN_PROC_MLT_BAD');
1271: fnd_message.raise_error;
1272: end if;
1273:
1274: if (p_prem_asnmt_cd = 'PROC' and p_prem_asnmt_lvl_cd = 'PRTT') then
1275: fnd_message.set_name('BEN', 'BEN_92273_ASGN_PROC_LVL_PRTT');

Line 1275: fnd_message.set_name('BEN', 'BEN_92273_ASGN_PROC_LVL_PRTT');

1271: fnd_message.raise_error;
1272: end if;
1273:
1274: if (p_prem_asnmt_cd = 'PROC' and p_prem_asnmt_lvl_cd = 'PRTT') then
1275: fnd_message.set_name('BEN', 'BEN_92273_ASGN_PROC_LVL_PRTT');
1276: fnd_message.raise_error;
1277: end if;
1278:
1279: if (p_prem_asnmt_cd = 'PROC'

Line 1276: fnd_message.raise_error;

1272: end if;
1273:
1274: if (p_prem_asnmt_cd = 'PROC' and p_prem_asnmt_lvl_cd = 'PRTT') then
1275: fnd_message.set_name('BEN', 'BEN_92273_ASGN_PROC_LVL_PRTT');
1276: fnd_message.raise_error;
1277: end if;
1278:
1279: if (p_prem_asnmt_cd = 'PROC'
1280: and p_mlt_cd not in ('NSVU', 'TPLPC', 'TTLPRTT','TTLCVG')) then

Line 1281: fnd_message.set_name('BEN', 'BEN_92274_ASGN_PROC_MLT_BAD');

1277: end if;
1278:
1279: if (p_prem_asnmt_cd = 'PROC'
1280: and p_mlt_cd not in ('NSVU', 'TPLPC', 'TTLPRTT','TTLCVG')) then
1281: fnd_message.set_name('BEN', 'BEN_92274_ASGN_PROC_MLT_BAD');
1282: fnd_message.raise_error;
1283: end if;
1284:
1285: if (p_mlt_cd = 'TPLC' and p_prem_pyr_cd <> 'ER')

Line 1282: fnd_message.raise_error;

1278:
1279: if (p_prem_asnmt_cd = 'PROC'
1280: and p_mlt_cd not in ('NSVU', 'TPLPC', 'TTLPRTT','TTLCVG')) then
1281: fnd_message.set_name('BEN', 'BEN_92274_ASGN_PROC_MLT_BAD');
1282: fnd_message.raise_error;
1283: end if;
1284:
1285: if (p_mlt_cd = 'TPLC' and p_prem_pyr_cd <> 'ER')
1286: then

Line 1287: fnd_message.set_name('BEN', 'BEN_92275_MLT_TPLC_PYR_NOTER');

1283: end if;
1284:
1285: if (p_mlt_cd = 'TPLC' and p_prem_pyr_cd <> 'ER')
1286: then
1287: fnd_message.set_name('BEN', 'BEN_92275_MLT_TPLC_PYR_NOTER');
1288: fnd_message.raise_error;
1289: end if;
1290:
1291: if (p_prem_asnmt_cd <> 'ENRT' and p_cr_lkbk_val is not null)

Line 1288: fnd_message.raise_error;

1284:
1285: if (p_mlt_cd = 'TPLC' and p_prem_pyr_cd <> 'ER')
1286: then
1287: fnd_message.set_name('BEN', 'BEN_92275_MLT_TPLC_PYR_NOTER');
1288: fnd_message.raise_error;
1289: end if;
1290:
1291: if (p_prem_asnmt_cd <> 'ENRT' and p_cr_lkbk_val is not null)
1292: then

Line 1293: fnd_message.set_name('BEN', 'BEN_92276_ASGN_ENRT_LKBK_VAL');

1289: end if;
1290:
1291: if (p_prem_asnmt_cd <> 'ENRT' and p_cr_lkbk_val is not null)
1292: then
1293: fnd_message.set_name('BEN', 'BEN_92276_ASGN_ENRT_LKBK_VAL');
1294: fnd_message.raise_error;
1295: end if;
1296: --
1297: -- Leaving Procedure.

Line 1294: fnd_message.raise_error;

1290:
1291: if (p_prem_asnmt_cd <> 'ENRT' and p_cr_lkbk_val is not null)
1292: then
1293: fnd_message.set_name('BEN', 'BEN_92276_ASGN_ENRT_LKBK_VAL');
1294: fnd_message.raise_error;
1295: end if;
1296: --
1297: -- Leaving Procedure.
1298: --

Line 1346: fnd_message.set_name('BEN', 'BEN_92277_UPR_LMT_RL_VAL');

1342: hr_utility.set_location('Entering:'||l_proc, 5);
1343: --
1344: if (p_upr_lmt_calc_rl is not null and p_upr_lmt_val is not null)
1345: then
1346: fnd_message.set_name('BEN', 'BEN_92277_UPR_LMT_RL_VAL');
1347: fnd_message.raise_error;
1348: end if;
1349:
1350: if (p_lwr_lmt_calc_rl is not null and p_lwr_lmt_val is not null)

Line 1347: fnd_message.raise_error;

1343: --
1344: if (p_upr_lmt_calc_rl is not null and p_upr_lmt_val is not null)
1345: then
1346: fnd_message.set_name('BEN', 'BEN_92277_UPR_LMT_RL_VAL');
1347: fnd_message.raise_error;
1348: end if;
1349:
1350: if (p_lwr_lmt_calc_rl is not null and p_lwr_lmt_val is not null)
1351: then

Line 1352: fnd_message.set_name('BEN', 'BEN_92278_LWR_LMT_RL_VAL');

1348: end if;
1349:
1350: if (p_lwr_lmt_calc_rl is not null and p_lwr_lmt_val is not null)
1351: then
1352: fnd_message.set_name('BEN', 'BEN_92278_LWR_LMT_RL_VAL');
1353: fnd_message.raise_error;
1354: end if;
1355: --
1356: -- Leaving Procedure.

Line 1353: fnd_message.raise_error;

1349:
1350: if (p_lwr_lmt_calc_rl is not null and p_lwr_lmt_val is not null)
1351: then
1352: fnd_message.set_name('BEN', 'BEN_92278_LWR_LMT_RL_VAL');
1353: fnd_message.raise_error;
1354: end if;
1355: --
1356: -- Leaving Procedure.
1357: --

Line 1403: fnd_message.set_name('BEN','BEN_92279_LWR_LESS_NOT_EQ_UPR');

1399: (p_lwr_lmt_val >= p_upr_lmt_val) then
1400: --
1401: -- raise error as is not a valid combination
1402: --
1403: fnd_message.set_name('BEN','BEN_92279_LWR_LESS_NOT_EQ_UPR');
1404: fnd_message.raise_error;
1405: --
1406: end if;
1407: --

Line 1404: fnd_message.raise_error;

1400: --
1401: -- raise error as is not a valid combination
1402: --
1403: fnd_message.set_name('BEN','BEN_92279_LWR_LESS_NOT_EQ_UPR');
1404: fnd_message.raise_error;
1405: --
1406: end if;
1407: --
1408: hr_utility.set_location('Leaving:'||l_proc, 5);

Line 1482: fnd_message.set_name('BEN','BEN_92280_ASGNCD_VRBL_PRFL_TMT');

1478: if l_vrbl_rt_trtmt_cd <> 'RPLC' then
1479: --
1480: -- raise an error as invalid values.
1481: --
1482: fnd_message.set_name('BEN','BEN_92280_ASGNCD_VRBL_PRFL_TMT');
1483: fnd_message.raise_error;
1484: end if;
1485: if l_mlt_cd <> 'TTLPRTT' then
1486: --

Line 1483: fnd_message.raise_error;

1479: --
1480: -- raise an error as invalid values.
1481: --
1482: fnd_message.set_name('BEN','BEN_92280_ASGNCD_VRBL_PRFL_TMT');
1483: fnd_message.raise_error;
1484: end if;
1485: if l_mlt_cd <> 'TTLPRTT' then
1486: --
1487: -- raise an error as invalid values.

Line 1489: fnd_message.set_name('BEN','BEN_92281_ASGNCD_VRBL_PRFL_ML1');

1485: if l_mlt_cd <> 'TTLPRTT' then
1486: --
1487: -- raise an error as invalid values.
1488: --
1489: fnd_message.set_name('BEN','BEN_92281_ASGNCD_VRBL_PRFL_ML1');
1490: fnd_message.raise_error;
1491: end if;
1492: elsif (p_prem_asnmt_cd = 'ENRT' and
1493: l_mlt_cd not in ('FLFX', 'CVG', 'NSVU', 'TPLPC', 'RL')) then

Line 1490: fnd_message.raise_error;

1486: --
1487: -- raise an error as invalid values.
1488: --
1489: fnd_message.set_name('BEN','BEN_92281_ASGNCD_VRBL_PRFL_ML1');
1490: fnd_message.raise_error;
1491: end if;
1492: elsif (p_prem_asnmt_cd = 'ENRT' and
1493: l_mlt_cd not in ('FLFX', 'CVG', 'NSVU', 'TPLPC', 'RL')) then
1494: --

Line 1497: fnd_message.set_name('BEN','BEN_92282_ASGNCD_VRBL_PRFL_ML2');

1493: l_mlt_cd not in ('FLFX', 'CVG', 'NSVU', 'TPLPC', 'RL')) then
1494: --
1495: -- raise an error as invalid values.
1496: --
1497: fnd_message.set_name('BEN','BEN_92282_ASGNCD_VRBL_PRFL_ML2');
1498: fnd_message.raise_error;
1499:
1500: end if;
1501: --

Line 1498: fnd_message.raise_error;

1494: --
1495: -- raise an error as invalid values.
1496: --
1497: fnd_message.set_name('BEN','BEN_92282_ASGNCD_VRBL_PRFL_ML2');
1498: fnd_message.raise_error;
1499:
1500: end if;
1501: --
1502: end if;

Line 1578: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

1574: p_effective_date => p_effective_date) then
1575: --
1576: -- raise error as does not exist as lookup
1577: --
1578: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1579: fnd_message.set_token('FIELD', 'p_prem_asnmt_cd');
1580: fnd_message.set_token('TYPE', 'BEN_PREM_ASNMT');
1581: fnd_message.raise_error;
1582: --

Line 1579: fnd_message.set_token('FIELD', 'p_prem_asnmt_cd');

1575: --
1576: -- raise error as does not exist as lookup
1577: --
1578: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1579: fnd_message.set_token('FIELD', 'p_prem_asnmt_cd');
1580: fnd_message.set_token('TYPE', 'BEN_PREM_ASNMT');
1581: fnd_message.raise_error;
1582: --
1583: --

Line 1580: fnd_message.set_token('TYPE', 'BEN_PREM_ASNMT');

1576: -- raise error as does not exist as lookup
1577: --
1578: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1579: fnd_message.set_token('FIELD', 'p_prem_asnmt_cd');
1580: fnd_message.set_token('TYPE', 'BEN_PREM_ASNMT');
1581: fnd_message.raise_error;
1582: --
1583: --
1584: end if;

Line 1581: fnd_message.raise_error;

1577: --
1578: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1579: fnd_message.set_token('FIELD', 'p_prem_asnmt_cd');
1580: fnd_message.set_token('TYPE', 'BEN_PREM_ASNMT');
1581: fnd_message.raise_error;
1582: --
1583: --
1584: end if;
1585: --

Line 1603: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

1599: p_effective_date => p_effective_date) then
1600: --
1601: -- raise error as does not exist as lookup
1602: --
1603: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1604: fnd_message.set_token('FIELD', 'p_prem_asnmt_lvl_cd');
1605: fnd_message.set_token('TYPE', 'BEN_PREM_ASNMT_LVL');
1606: fnd_message.raise_error;
1607: --

Line 1604: fnd_message.set_token('FIELD', 'p_prem_asnmt_lvl_cd');

1600: --
1601: -- raise error as does not exist as lookup
1602: --
1603: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1604: fnd_message.set_token('FIELD', 'p_prem_asnmt_lvl_cd');
1605: fnd_message.set_token('TYPE', 'BEN_PREM_ASNMT_LVL');
1606: fnd_message.raise_error;
1607: --
1608: --

Line 1605: fnd_message.set_token('TYPE', 'BEN_PREM_ASNMT_LVL');

1601: -- raise error as does not exist as lookup
1602: --
1603: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1604: fnd_message.set_token('FIELD', 'p_prem_asnmt_lvl_cd');
1605: fnd_message.set_token('TYPE', 'BEN_PREM_ASNMT_LVL');
1606: fnd_message.raise_error;
1607: --
1608: --
1609: end if;

Line 1606: fnd_message.raise_error;

1602: --
1603: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1604: fnd_message.set_token('FIELD', 'p_prem_asnmt_lvl_cd');
1605: fnd_message.set_token('TYPE', 'BEN_PREM_ASNMT_LVL');
1606: fnd_message.raise_error;
1607: --
1608: --
1609: end if;
1610: --

Line 1628: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

1624: p_effective_date => p_effective_date) then
1625: --
1626: -- raise error as does not exist as lookup
1627: --
1628: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1629: fnd_message.set_token('FIELD', 'p_actl_prem_typ_cd');
1630: fnd_message.set_token('TYPE', 'BEN_PREM_TYP');
1631: fnd_message.raise_error;
1632: --

Line 1629: fnd_message.set_token('FIELD', 'p_actl_prem_typ_cd');

1625: --
1626: -- raise error as does not exist as lookup
1627: --
1628: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1629: fnd_message.set_token('FIELD', 'p_actl_prem_typ_cd');
1630: fnd_message.set_token('TYPE', 'BEN_PREM_TYP');
1631: fnd_message.raise_error;
1632: --
1633: --

Line 1630: fnd_message.set_token('TYPE', 'BEN_PREM_TYP');

1626: -- raise error as does not exist as lookup
1627: --
1628: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1629: fnd_message.set_token('FIELD', 'p_actl_prem_typ_cd');
1630: fnd_message.set_token('TYPE', 'BEN_PREM_TYP');
1631: fnd_message.raise_error;
1632: --
1633: --
1634: end if;

Line 1631: fnd_message.raise_error;

1627: --
1628: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1629: fnd_message.set_token('FIELD', 'p_actl_prem_typ_cd');
1630: fnd_message.set_token('TYPE', 'BEN_PREM_TYP');
1631: fnd_message.raise_error;
1632: --
1633: --
1634: end if;
1635: --

Line 1653: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

1649: p_effective_date => p_effective_date) then
1650: --
1651: -- raise error as does not exist as lookup
1652: --
1653: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1654: fnd_message.set_token('FIELD', 'p_prem_pyr_cd');
1655: fnd_message.set_token('TYPE', 'BEN_PREM_PYR');
1656: fnd_message.raise_error;
1657: --

Line 1654: fnd_message.set_token('FIELD', 'p_prem_pyr_cd');

1650: --
1651: -- raise error as does not exist as lookup
1652: --
1653: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1654: fnd_message.set_token('FIELD', 'p_prem_pyr_cd');
1655: fnd_message.set_token('TYPE', 'BEN_PREM_PYR');
1656: fnd_message.raise_error;
1657: --
1658: --

Line 1655: fnd_message.set_token('TYPE', 'BEN_PREM_PYR');

1651: -- raise error as does not exist as lookup
1652: --
1653: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1654: fnd_message.set_token('FIELD', 'p_prem_pyr_cd');
1655: fnd_message.set_token('TYPE', 'BEN_PREM_PYR');
1656: fnd_message.raise_error;
1657: --
1658: --
1659: end if;

Line 1656: fnd_message.raise_error;

1652: --
1653: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1654: fnd_message.set_token('FIELD', 'p_prem_pyr_cd');
1655: fnd_message.set_token('TYPE', 'BEN_PREM_PYR');
1656: fnd_message.raise_error;
1657: --
1658: --
1659: end if;
1660: --

Line 1678: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

1674: p_effective_date => p_effective_date) then
1675: --
1676: -- raise error as does not exist as lookup
1677: --
1678: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1679: fnd_message.set_token('FIELD', 'p_prsptv_r_rtsptv_cd');
1680: fnd_message.set_token('TYPE', 'BEN_PRSPCTV_R_RTSPCTV');
1681: fnd_message.raise_error;
1682: --

Line 1679: fnd_message.set_token('FIELD', 'p_prsptv_r_rtsptv_cd');

1675: --
1676: -- raise error as does not exist as lookup
1677: --
1678: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1679: fnd_message.set_token('FIELD', 'p_prsptv_r_rtsptv_cd');
1680: fnd_message.set_token('TYPE', 'BEN_PRSPCTV_R_RTSPCTV');
1681: fnd_message.raise_error;
1682: --
1683: --

Line 1680: fnd_message.set_token('TYPE', 'BEN_PRSPCTV_R_RTSPCTV');

1676: -- raise error as does not exist as lookup
1677: --
1678: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1679: fnd_message.set_token('FIELD', 'p_prsptv_r_rtsptv_cd');
1680: fnd_message.set_token('TYPE', 'BEN_PRSPCTV_R_RTSPCTV');
1681: fnd_message.raise_error;
1682: --
1683: --
1684: end if;

Line 1681: fnd_message.raise_error;

1677: --
1678: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1679: fnd_message.set_token('FIELD', 'p_prsptv_r_rtsptv_cd');
1680: fnd_message.set_token('TYPE', 'BEN_PRSPCTV_R_RTSPCTV');
1681: fnd_message.raise_error;
1682: --
1683: --
1684: end if;
1685: --

Line 1778: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

1774: close c1;
1775: --
1776: -- raise error
1777: --
1778: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1779: fnd_message.set_token('ID',p_lwr_lmt_calc_rl);
1780: fnd_message.set_token('TYPE_ID',-515);
1781: fnd_message.raise_error;
1782: --

Line 1779: fnd_message.set_token('ID',p_lwr_lmt_calc_rl);

1775: --
1776: -- raise error
1777: --
1778: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1779: fnd_message.set_token('ID',p_lwr_lmt_calc_rl);
1780: fnd_message.set_token('TYPE_ID',-515);
1781: fnd_message.raise_error;
1782: --
1783: end if;

Line 1780: fnd_message.set_token('TYPE_ID',-515);

1776: -- raise error
1777: --
1778: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1779: fnd_message.set_token('ID',p_lwr_lmt_calc_rl);
1780: fnd_message.set_token('TYPE_ID',-515);
1781: fnd_message.raise_error;
1782: --
1783: end if;
1784: --

Line 1781: fnd_message.raise_error;

1777: --
1778: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1779: fnd_message.set_token('ID',p_lwr_lmt_calc_rl);
1780: fnd_message.set_token('TYPE_ID',-515);
1781: fnd_message.raise_error;
1782: --
1783: end if;
1784: --
1785: close c1;

Line 1809: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

1805: close c1;
1806: --
1807: -- raise error
1808: --
1809: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1810: fnd_message.set_token('ID',p_upr_lmt_calc_rl);
1811: fnd_message.set_token('TYPE_ID',-512);
1812: fnd_message.raise_error;
1813: --

Line 1810: fnd_message.set_token('ID',p_upr_lmt_calc_rl);

1806: --
1807: -- raise error
1808: --
1809: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1810: fnd_message.set_token('ID',p_upr_lmt_calc_rl);
1811: fnd_message.set_token('TYPE_ID',-512);
1812: fnd_message.raise_error;
1813: --
1814: end if;

Line 1811: fnd_message.set_token('TYPE_ID',-512);

1807: -- raise error
1808: --
1809: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1810: fnd_message.set_token('ID',p_upr_lmt_calc_rl);
1811: fnd_message.set_token('TYPE_ID',-512);
1812: fnd_message.raise_error;
1813: --
1814: end if;
1815: --

Line 1812: fnd_message.raise_error;

1808: --
1809: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1810: fnd_message.set_token('ID',p_upr_lmt_calc_rl);
1811: fnd_message.set_token('TYPE_ID',-512);
1812: fnd_message.raise_error;
1813: --
1814: end if;
1815: --
1816: close c1;

Line 1841: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

1837: close c1;
1838: --
1839: -- raise error
1840: --
1841: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1842: fnd_message.set_token('ID',p_prtl_mo_det_mthd_rl);
1843: fnd_message.set_token('TYPE_ID',-165);
1844: fnd_message.raise_error;
1845: --

Line 1842: fnd_message.set_token('ID',p_prtl_mo_det_mthd_rl);

1838: --
1839: -- raise error
1840: --
1841: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1842: fnd_message.set_token('ID',p_prtl_mo_det_mthd_rl);
1843: fnd_message.set_token('TYPE_ID',-165);
1844: fnd_message.raise_error;
1845: --
1846: end if;

Line 1843: fnd_message.set_token('TYPE_ID',-165);

1839: -- raise error
1840: --
1841: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1842: fnd_message.set_token('ID',p_prtl_mo_det_mthd_rl);
1843: fnd_message.set_token('TYPE_ID',-165);
1844: fnd_message.raise_error;
1845: --
1846: end if;
1847: --

Line 1844: fnd_message.raise_error;

1840: --
1841: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1842: fnd_message.set_token('ID',p_prtl_mo_det_mthd_rl);
1843: fnd_message.set_token('TYPE_ID',-165);
1844: fnd_message.raise_error;
1845: --
1846: end if;
1847: --
1848: close c1;

Line 1918: fnd_message.set_name('BEN','BEN_92529_NO_COST');

1914: --
1915: -- raise an error
1916: --
1917: if p_prem_asnmt_cd = 'PROC' then
1918: fnd_message.set_name('BEN','BEN_92529_NO_COST');
1919: fnd_message.raise_error;
1920: else
1921: fnd_message.set_name('BEN','BEN_92530_DFLT_RQD');
1922: fnd_message.raise_error;

Line 1919: fnd_message.raise_error;

1915: -- raise an error
1916: --
1917: if p_prem_asnmt_cd = 'PROC' then
1918: fnd_message.set_name('BEN','BEN_92529_NO_COST');
1919: fnd_message.raise_error;
1920: else
1921: fnd_message.set_name('BEN','BEN_92530_DFLT_RQD');
1922: fnd_message.raise_error;
1923: end if;

Line 1921: fnd_message.set_name('BEN','BEN_92530_DFLT_RQD');

1917: if p_prem_asnmt_cd = 'PROC' then
1918: fnd_message.set_name('BEN','BEN_92529_NO_COST');
1919: fnd_message.raise_error;
1920: else
1921: fnd_message.set_name('BEN','BEN_92530_DFLT_RQD');
1922: fnd_message.raise_error;
1923: end if;
1924: --
1925: end if;

Line 1922: fnd_message.raise_error;

1918: fnd_message.set_name('BEN','BEN_92529_NO_COST');
1919: fnd_message.raise_error;
1920: else
1921: fnd_message.set_name('BEN','BEN_92530_DFLT_RQD');
1922: fnd_message.raise_error;
1923: end if;
1924: --
1925: end if;
1926: --

Line 2029: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

2025: --
2026: -- An unhandled or unexpected error has occurred which
2027: -- we must report
2028: --
2029: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2030: fnd_message.set_token('PROCEDURE', l_proc);
2031: fnd_message.set_token('STEP','15');
2032: fnd_message.raise_error;
2033: End dt_update_validate;

Line 2030: fnd_message.set_token('PROCEDURE', l_proc);

2026: -- An unhandled or unexpected error has occurred which
2027: -- we must report
2028: --
2029: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2030: fnd_message.set_token('PROCEDURE', l_proc);
2031: fnd_message.set_token('STEP','15');
2032: fnd_message.raise_error;
2033: End dt_update_validate;
2034: --

Line 2031: fnd_message.set_token('STEP','15');

2027: -- we must report
2028: --
2029: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2030: fnd_message.set_token('PROCEDURE', l_proc);
2031: fnd_message.set_token('STEP','15');
2032: fnd_message.raise_error;
2033: End dt_update_validate;
2034: --
2035: -- ----------------------------------------------------------------------------

Line 2032: fnd_message.raise_error;

2028: --
2029: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2030: fnd_message.set_token('PROCEDURE', l_proc);
2031: fnd_message.set_token('STEP','15');
2032: fnd_message.raise_error;
2033: End dt_update_validate;
2034: --
2035: -- ----------------------------------------------------------------------------
2036: -- |--------------------------< dt_delete_validate >--------------------------|

Line 2168: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

2164: --
2165: -- An unhandled or unexpected error has occurred which
2166: -- we must report
2167: --
2168: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2169: fnd_message.set_token('PROCEDURE', l_proc);
2170: fnd_message.set_token('STEP','15');
2171: fnd_message.raise_error;
2172: end dt_delete_validate;

Line 2169: fnd_message.set_token('PROCEDURE', l_proc);

2165: -- An unhandled or unexpected error has occurred which
2166: -- we must report
2167: --
2168: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2169: fnd_message.set_token('PROCEDURE', l_proc);
2170: fnd_message.set_token('STEP','15');
2171: fnd_message.raise_error;
2172: end dt_delete_validate;
2173: --

Line 2170: fnd_message.set_token('STEP','15');

2166: -- we must report
2167: --
2168: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2169: fnd_message.set_token('PROCEDURE', l_proc);
2170: fnd_message.set_token('STEP','15');
2171: fnd_message.raise_error;
2172: end dt_delete_validate;
2173: --
2174: --

Line 2171: fnd_message.raise_error;

2167: --
2168: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2169: fnd_message.set_token('PROCEDURE', l_proc);
2170: fnd_message.set_token('STEP','15');
2171: fnd_message.raise_error;
2172: end dt_delete_validate;
2173: --
2174: --
2175: -- ----------------------------------------------------------------------------

Line 2251: fnd_message.set_name('BEN','BEN_91535_MLT_CD_RQD');

2247: <> nvl(ben_apr_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2)
2248: ) or not l_api_updating)
2249: then
2250: if p_mlt_cd is NULL then
2251: fnd_message.set_name('BEN','BEN_91535_MLT_CD_RQD');
2252: fnd_message.raise_error;
2253: end if;
2254: if p_val is NULL then
2255: if p_mlt_cd in ('FLFX','CVG','TTLCVG','TTLPRTT') then

Line 2252: fnd_message.raise_error;

2248: ) or not l_api_updating)
2249: then
2250: if p_mlt_cd is NULL then
2251: fnd_message.set_name('BEN','BEN_91535_MLT_CD_RQD');
2252: fnd_message.raise_error;
2253: end if;
2254: if p_val is NULL then
2255: if p_mlt_cd in ('FLFX','CVG','TTLCVG','TTLPRTT') then
2256: fnd_message.set_name('BEN','BEN_91536_VAL_RQD');

Line 2256: fnd_message.set_name('BEN','BEN_91536_VAL_RQD');

2252: fnd_message.raise_error;
2253: end if;
2254: if p_val is NULL then
2255: if p_mlt_cd in ('FLFX','CVG','TTLCVG','TTLPRTT') then
2256: fnd_message.set_name('BEN','BEN_91536_VAL_RQD');
2257: fnd_message.raise_error;
2258: end if;
2259: end if;
2260: if p_rt_typ_cd is not NULL then

Line 2257: fnd_message.raise_error;

2253: end if;
2254: if p_val is NULL then
2255: if p_mlt_cd in ('FLFX','CVG','TTLCVG','TTLPRTT') then
2256: fnd_message.set_name('BEN','BEN_91536_VAL_RQD');
2257: fnd_message.raise_error;
2258: end if;
2259: end if;
2260: if p_rt_typ_cd is not NULL then
2261: if p_mlt_cd in ('FLFX','CVG','RL') then

Line 2262: fnd_message.set_name('BEN','BEN_91545_RT_TYP_CD_SPEC');

2258: end if;
2259: end if;
2260: if p_rt_typ_cd is not NULL then
2261: if p_mlt_cd in ('FLFX','CVG','RL') then
2262: fnd_message.set_name('BEN','BEN_91545_RT_TYP_CD_SPEC');
2263: fnd_message.raise_error;
2264: end if;
2265: end if;
2266: if p_bnft_rt_typ_cd is NULL then

Line 2263: fnd_message.raise_error;

2259: end if;
2260: if p_rt_typ_cd is not NULL then
2261: if p_mlt_cd in ('FLFX','CVG','RL') then
2262: fnd_message.set_name('BEN','BEN_91545_RT_TYP_CD_SPEC');
2263: fnd_message.raise_error;
2264: end if;
2265: end if;
2266: if p_bnft_rt_typ_cd is NULL then
2267: if p_mlt_cd in ('CVG','TTLCVG','TTLPRTT') then

Line 2268: fnd_message.set_name('BEN','BEN_91546_BNFTS_TYP_CD_RQD');

2264: end if;
2265: end if;
2266: if p_bnft_rt_typ_cd is NULL then
2267: if p_mlt_cd in ('CVG','TTLCVG','TTLPRTT') then
2268: fnd_message.set_name('BEN','BEN_91546_BNFTS_TYP_CD_RQD');
2269: fnd_message.raise_error;
2270: end if;
2271: else
2272: if p_mlt_cd in ('FLFX','RL') then

Line 2269: fnd_message.raise_error;

2265: end if;
2266: if p_bnft_rt_typ_cd is NULL then
2267: if p_mlt_cd in ('CVG','TTLCVG','TTLPRTT') then
2268: fnd_message.set_name('BEN','BEN_91546_BNFTS_TYP_CD_RQD');
2269: fnd_message.raise_error;
2270: end if;
2271: else
2272: if p_mlt_cd in ('FLFX','RL') then
2273: fnd_message.set_name('BEN','BEN_91547_BNFTS_TYP_CD_SPEC');

Line 2273: fnd_message.set_name('BEN','BEN_91547_BNFTS_TYP_CD_SPEC');

2269: fnd_message.raise_error;
2270: end if;
2271: else
2272: if p_mlt_cd in ('FLFX','RL') then
2273: fnd_message.set_name('BEN','BEN_91547_BNFTS_TYP_CD_SPEC');
2274: fnd_message.raise_error;
2275: end if;
2276: end if;
2277: if p_mlt_cd = 'CVG' then

Line 2274: fnd_message.raise_error;

2270: end if;
2271: else
2272: if p_mlt_cd in ('FLFX','RL') then
2273: fnd_message.set_name('BEN','BEN_91547_BNFTS_TYP_CD_SPEC');
2274: fnd_message.raise_error;
2275: end if;
2276: end if;
2277: if p_mlt_cd = 'CVG' then
2278: open c1;

Line 2281: fnd_message.set_name('BEN','BEN_92473_COVERAGE_REQUIRED');

2277: if p_mlt_cd = 'CVG' then
2278: open c1;
2279: fetch c1 into l_dummy;
2280: if l_dummy is null then
2281: fnd_message.set_name('BEN','BEN_92473_COVERAGE_REQUIRED');
2282: fnd_message.raise_error;
2283: end if;
2284: close c1;
2285: end if;

Line 2282: fnd_message.raise_error;

2278: open c1;
2279: fetch c1 into l_dummy;
2280: if l_dummy is null then
2281: fnd_message.set_name('BEN','BEN_92473_COVERAGE_REQUIRED');
2282: fnd_message.raise_error;
2283: end if;
2284: close c1;
2285: end if;
2286: if p_mlt_cd = 'RL' and p_val_calc_rl is null then

Line 2287: fnd_message.set_name('BEN','BEN_91548_VAL_CALC_RL_RQD');

2283: end if;
2284: close c1;
2285: end if;
2286: if p_mlt_cd = 'RL' and p_val_calc_rl is null then
2287: fnd_message.set_name('BEN','BEN_91548_VAL_CALC_RL_RQD');
2288: fnd_message.raise_error;
2289: end if;
2290: end if;
2291: hr_utility.set_location('Leaving:'||l_proc,10);

Line 2288: fnd_message.raise_error;

2284: close c1;
2285: end if;
2286: if p_mlt_cd = 'RL' and p_val_calc_rl is null then
2287: fnd_message.set_name('BEN','BEN_91548_VAL_CALC_RL_RQD');
2288: fnd_message.raise_error;
2289: end if;
2290: end if;
2291: hr_utility.set_location('Leaving:'||l_proc,10);
2292: end chk_mlt_cd_dependencies;

Line 2730: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

2726: close csr_leg_code;
2727: --
2728: -- The primary key is invalid therefore we must error
2729: --
2730: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
2731: fnd_message.raise_error;
2732: --
2733: end if;
2734: --

Line 2731: fnd_message.raise_error;

2727: --
2728: -- The primary key is invalid therefore we must error
2729: --
2730: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
2731: fnd_message.raise_error;
2732: --
2733: end if;
2734: --
2735: close csr_leg_code;