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;
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: --
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;
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: --
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;
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;
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: --
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;
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: --
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;
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: --
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;
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: --
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;
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: --
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;
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: --
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;
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: --
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;
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: --
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;
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: --
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;
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: --
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;
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: --
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.
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;
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: --
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: --
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;
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: --
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;
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: --
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;
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: --
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;
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: --
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;
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
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');
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;
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: --
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: --
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');
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: --
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
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: --
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');
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: --
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);
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
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');
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
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');
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'
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
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')
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
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)
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
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.
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: --
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)
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
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.
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: --
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: --
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);
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: --
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.
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
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: --
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: --
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;
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: --
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: --
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;
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: --
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: --
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: --
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;
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: --
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: --
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: --
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;
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: --
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: --
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: --
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;
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: --
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: --
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: --
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;
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: --
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: --
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;
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: --
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;
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: --
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;
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: --
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;
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: --
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;
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: --
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;
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;
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;
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;
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: --
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;
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: --
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: -- ----------------------------------------------------------------------------
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 >--------------------------|
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;
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: --
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: --
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: -- ----------------------------------------------------------------------------
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
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');
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
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
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
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
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
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');
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
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;
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;
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
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);
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;
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: --
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;