129: p_effective_date => p_effective_date) then
130: --
131: -- raise error as does not exist as lookup
132: --
133: fnd_message.set_name('BEN','BEN_91060_INVLD_ONCE_R_CNTG_CD');
134: fnd_message.raise_error;
135: --
136: end if;
137: --
130: --
131: -- raise error as does not exist as lookup
132: --
133: fnd_message.set_name('BEN','BEN_91060_INVLD_ONCE_R_CNTG_CD');
134: fnd_message.raise_error;
135: --
136: end if;
137: --
138: end if;
198: p_effective_date => p_effective_date) then
199: --
200: -- raise error as does not exist as lookup
201: --
202: fnd_message.set_name('BEN','BEN_91052_INVALID_MAX_FLAG');
203: fnd_message.raise_error;
204: --
205: end if;
206: --
199: --
200: -- raise error as does not exist as lookup
201: --
202: fnd_message.set_name('BEN','BEN_91052_INVALID_MAX_FLAG');
203: fnd_message.raise_error;
204: --
205: end if;
206: --
207: end if;
265: p_effective_date => p_effective_date) then
266: --
267: -- raise error as does not exist as lookup
268: --
269: fnd_message.set_name('PAY','91051_INVALID_MIN_FLAG');
270: fnd_message.raise_error;
271: --
272: end if;
273: --
266: --
267: -- raise error as does not exist as lookup
268: --
269: fnd_message.set_name('PAY','91051_INVALID_MIN_FLAG');
270: fnd_message.raise_error;
271: --
272: end if;
273: --
274: end if;
356: close c1;
357: --
358: -- raise error
359: --
360: fnd_message.set_name('BEN','BEN_91062_INVLD_HRS_WKD_DET_RL');
361: fnd_message.raise_error;
362: --
363: end if;
364: --
357: --
358: -- raise error
359: --
360: fnd_message.set_name('BEN','BEN_91062_INVLD_HRS_WKD_DET_RL');
361: fnd_message.raise_error;
362: --
363: end if;
364: --
365: close c1;
368: --
369: -- Unless Hours Worked Determination Code = Rule, Hours Worked Determination rule must be blank.
370: if nvl(p_hrs_wkd_det_cd,hr_api.g_varchar2) <> 'RL' and p_hrs_wkd_det_rl is not null then
371: --
372: fnd_message.set_name('BEN', 'BEN_91070_HRS_WKD_RL_NOT_NULL');
373: fnd_message.raise_error;
374: --
375: elsif nvl(p_hrs_wkd_det_cd,hr_api.g_varchar2) = 'RL' and p_hrs_wkd_det_rl is null then
376: --
369: -- Unless Hours Worked Determination Code = Rule, Hours Worked Determination rule must be blank.
370: if nvl(p_hrs_wkd_det_cd,hr_api.g_varchar2) <> 'RL' and p_hrs_wkd_det_rl is not null then
371: --
372: fnd_message.set_name('BEN', 'BEN_91070_HRS_WKD_RL_NOT_NULL');
373: fnd_message.raise_error;
374: --
375: elsif nvl(p_hrs_wkd_det_cd,hr_api.g_varchar2) = 'RL' and p_hrs_wkd_det_rl is null then
376: --
377: fnd_message.set_name('BEN', 'BEN_91097_HRS_WKD_RL_NULL');
373: fnd_message.raise_error;
374: --
375: elsif nvl(p_hrs_wkd_det_cd,hr_api.g_varchar2) = 'RL' and p_hrs_wkd_det_rl is null then
376: --
377: fnd_message.set_name('BEN', 'BEN_91097_HRS_WKD_RL_NULL');
378: fnd_message.raise_error;
379: --
380: end if;
381: --
374: --
375: elsif nvl(p_hrs_wkd_det_cd,hr_api.g_varchar2) = 'RL' and p_hrs_wkd_det_rl is null then
376: --
377: fnd_message.set_name('BEN', 'BEN_91097_HRS_WKD_RL_NULL');
378: fnd_message.raise_error;
379: --
380: end if;
381: --
382: hr_utility.set_location('Leaving:'||l_proc,10);
439: p_effective_date => p_effective_date) then
440: --
441: -- raise error as does not exist as lookup
442: --
443: fnd_message.set_name('BEN','BEN_91061_INVLD_HRS_WKD_DET_CD');
444: fnd_message.raise_error;
445: --
446: end if;
447: --
440: --
441: -- raise error as does not exist as lookup
442: --
443: fnd_message.set_name('BEN','BEN_91061_INVLD_HRS_WKD_DET_CD');
444: fnd_message.raise_error;
445: --
446: end if;
447: --
448: end if;
530: close c1;
531: --
532: -- raise error
533: --
534: fnd_message.set_name('BEN','BEN_91042_INVALID_RNDG_RL');
535: fnd_message.raise_error;
536: --
537: end if;
538: --
531: --
532: -- raise error
533: --
534: fnd_message.set_name('BEN','BEN_91042_INVALID_RNDG_RL');
535: fnd_message.raise_error;
536: --
537: end if;
538: --
539: close c1;
542: --
543: -- Unless Rounding Code = Rule, Rounding rule must be blank.
544: if nvl(p_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_rndg_rl is not null then
545: --
546: fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');
547: fnd_message.raise_error;
548: --
549: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then
550: --
543: -- Unless Rounding Code = Rule, Rounding rule must be blank.
544: if nvl(p_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_rndg_rl is not null then
545: --
546: fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');
547: fnd_message.raise_error;
548: --
549: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then
550: --
551: fnd_message.set_name('BEN', 'BEN_92340_RNDG_RL_NULL');
547: fnd_message.raise_error;
548: --
549: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then
550: --
551: fnd_message.set_name('BEN', 'BEN_92340_RNDG_RL_NULL');
552: fnd_message.raise_error;
553: --
554: end if;
555: --
548: --
549: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then
550: --
551: fnd_message.set_name('BEN', 'BEN_92340_RNDG_RL_NULL');
552: fnd_message.raise_error;
553: --
554: end if;
555: --
556: --
614: p_effective_date => p_effective_date) then
615: --
616: -- raise error as does not exist as lookup
617: --
618: fnd_message.set_name('BEN','BEN_91041_INVALID_RNDG_CD');
619: fnd_message.raise_error;
620: --
621: end if;
622: --
615: --
616: -- raise error as does not exist as lookup
617: --
618: fnd_message.set_name('BEN','BEN_91041_INVALID_RNDG_CD');
619: fnd_message.raise_error;
620: --
621: end if;
622: --
623: end if;
682: p_effective_date => p_effective_date) then
683: --
684: -- raise error as does not exist as lookup
685: --
686: fnd_message.set_name('BEN','BEN_91053_INVALID_SRC_CD');
687: fnd_message.raise_error;
688: --
689: end if;
690: --
683: --
684: -- raise error as does not exist as lookup
685: --
686: fnd_message.set_name('BEN','BEN_91053_INVALID_SRC_CD');
687: fnd_message.raise_error;
688: --
689: end if;
690: --
691: end if;
750: p_effective_date => p_effective_date) then
751: --
752: -- raise error as does not exist as lookup
753: --
754: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
755: fnd_message.set_token('FIELD', 'p_hrs_alt_val_to_use_cd');
756: fnd_message.set_token('TYPE', 'BEN_HRS_ALT_VAL_TO_USE');
757: fnd_message.raise_error;
758: --
751: --
752: -- raise error as does not exist as lookup
753: --
754: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
755: fnd_message.set_token('FIELD', 'p_hrs_alt_val_to_use_cd');
756: fnd_message.set_token('TYPE', 'BEN_HRS_ALT_VAL_TO_USE');
757: fnd_message.raise_error;
758: --
759: end if;
752: -- raise error as does not exist as lookup
753: --
754: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
755: fnd_message.set_token('FIELD', 'p_hrs_alt_val_to_use_cd');
756: fnd_message.set_token('TYPE', 'BEN_HRS_ALT_VAL_TO_USE');
757: fnd_message.raise_error;
758: --
759: end if;
760: --
753: --
754: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
755: fnd_message.set_token('FIELD', 'p_hrs_alt_val_to_use_cd');
756: fnd_message.set_token('TYPE', 'BEN_HRS_ALT_VAL_TO_USE');
757: fnd_message.raise_error;
758: --
759: end if;
760: --
761: end if;
819: p_effective_date => p_effective_date) then
820: --
821: -- raise error as does not exist as lookup
822: --
823: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
824: fnd_message.set_token('FIELD', 'p_pyrl_freq_cd');
825: fnd_message.set_token('TYPE', 'BEN_FREQ');
826: fnd_message.raise_error;
827: --
820: --
821: -- raise error as does not exist as lookup
822: --
823: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
824: fnd_message.set_token('FIELD', 'p_pyrl_freq_cd');
825: fnd_message.set_token('TYPE', 'BEN_FREQ');
826: fnd_message.raise_error;
827: --
828: end if;
821: -- raise error as does not exist as lookup
822: --
823: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
824: fnd_message.set_token('FIELD', 'p_pyrl_freq_cd');
825: fnd_message.set_token('TYPE', 'BEN_FREQ');
826: fnd_message.raise_error;
827: --
828: end if;
829: --
822: --
823: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
824: fnd_message.set_token('FIELD', 'p_pyrl_freq_cd');
825: fnd_message.set_token('TYPE', 'BEN_FREQ');
826: fnd_message.raise_error;
827: --
828: end if;
829: --
830: end if;
910: close c1;
911: --
912: -- raise error
913: --
914: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
915: fnd_message.set_token('ID',p_hrs_wkd_calc_rl);
916: fnd_message.set_token('TYPE_ID',-516);
917: fnd_message.raise_error;
918: --
911: --
912: -- raise error
913: --
914: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
915: fnd_message.set_token('ID',p_hrs_wkd_calc_rl);
916: fnd_message.set_token('TYPE_ID',-516);
917: fnd_message.raise_error;
918: --
919: end if;
912: -- raise error
913: --
914: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
915: fnd_message.set_token('ID',p_hrs_wkd_calc_rl);
916: fnd_message.set_token('TYPE_ID',-516);
917: fnd_message.raise_error;
918: --
919: end if;
920: --
913: --
914: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
915: fnd_message.set_token('ID',p_hrs_wkd_calc_rl);
916: fnd_message.set_token('TYPE_ID',-516);
917: fnd_message.raise_error;
918: --
919: end if;
920: --
921: close c1;
999: close c1;
1000: --
1001: -- raise error
1002: --
1003: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
1004: fnd_message.raise_error;
1005: --
1006: end if;
1007: --
1000: --
1001: -- raise error
1002: --
1003: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
1004: fnd_message.raise_error;
1005: --
1006: end if;
1007: --
1008: close c1;
1069: -- Bug fix 1873685
1070: if (p_mx_hrs_num < p_mn_hrs_num) then
1071: -- if (p_mx_hrs_num <= p_mn_hrs_num) then
1072: -- end fix 1873685
1073: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
1074: fnd_message.raise_error;
1075: end if;
1076: --
1077: --
1070: if (p_mx_hrs_num < p_mn_hrs_num) then
1071: -- if (p_mx_hrs_num <= p_mn_hrs_num) then
1072: -- end fix 1873685
1073: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');
1074: fnd_message.raise_error;
1075: end if;
1076: --
1077: --
1078: end if;
1082: --
1083: if p_no_mn_hrs_wkd_flag = 'Y'
1084: and (p_mn_hrs_num is not null) then
1085: --
1086: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
1087: fnd_message.raise_error;
1088: --
1089: elsif p_no_mn_hrs_wkd_flag = 'N' and
1090: p_mn_hrs_num is null then
1083: if p_no_mn_hrs_wkd_flag = 'Y'
1084: and (p_mn_hrs_num is not null) then
1085: --
1086: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
1087: fnd_message.raise_error;
1088: --
1089: elsif p_no_mn_hrs_wkd_flag = 'N' and
1090: p_mn_hrs_num is null then
1091: --
1088: --
1089: elsif p_no_mn_hrs_wkd_flag = 'N' and
1090: p_mn_hrs_num is null then
1091: --
1092: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');
1093: fnd_message.raise_error;
1094: --
1095: end if;
1096: --
1089: elsif p_no_mn_hrs_wkd_flag = 'N' and
1090: p_mn_hrs_num is null then
1091: --
1092: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');
1093: fnd_message.raise_error;
1094: --
1095: end if;
1096: --
1097: -- If No Maximum hrs_wkd flag set to "on" (Y),
1099: --
1100: if p_no_mx_hrs_wkd_flag = 'Y'
1101: and (p_mx_hrs_num is not null) then
1102: --
1103: fnd_message.set_name('BEN','BEN_91056_MAX_VAL_NOT_NULL');
1104: fnd_message.raise_error;
1105: --
1106: elsif p_no_mx_hrs_wkd_flag = 'N' and
1107: p_mx_hrs_num is null then
1100: if p_no_mx_hrs_wkd_flag = 'Y'
1101: and (p_mx_hrs_num is not null) then
1102: --
1103: fnd_message.set_name('BEN','BEN_91056_MAX_VAL_NOT_NULL');
1104: fnd_message.raise_error;
1105: --
1106: elsif p_no_mx_hrs_wkd_flag = 'N' and
1107: p_mx_hrs_num is null then
1108: --
1105: --
1106: elsif p_no_mx_hrs_wkd_flag = 'N' and
1107: p_mx_hrs_num is null then
1108: --
1109: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');
1110: fnd_message.raise_error;
1111: --
1112: end if;
1113:
1106: elsif p_no_mx_hrs_wkd_flag = 'N' and
1107: p_mx_hrs_num is null then
1108: --
1109: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');
1110: fnd_message.raise_error;
1111: --
1112: end if;
1113:
1114: --
1157: -- Source.
1158: --
1159: if p_hrs_src_cd = 'BALTYP' and p_defined_balance_id is null then
1160: --
1161: fnd_message.set_name('BEN','BEN_91975_DEFINED_BALANCE');
1162: fnd_message.raise_error;
1163: --
1164: elsif p_hrs_src_cd = 'BNFTBALTYP' and p_bnfts_bal_id is null then
1165: --
1158: --
1159: if p_hrs_src_cd = 'BALTYP' and p_defined_balance_id is null then
1160: --
1161: fnd_message.set_name('BEN','BEN_91975_DEFINED_BALANCE');
1162: fnd_message.raise_error;
1163: --
1164: elsif p_hrs_src_cd = 'BNFTBALTYP' and p_bnfts_bal_id is null then
1165: --
1166: fnd_message.set_name('BEN','BEN_91976_BNFTS_BALANCE_TYP');
1162: fnd_message.raise_error;
1163: --
1164: elsif p_hrs_src_cd = 'BNFTBALTYP' and p_bnfts_bal_id is null then
1165: --
1166: fnd_message.set_name('BEN','BEN_91976_BNFTS_BALANCE_TYP');
1167: fnd_message.raise_error;
1168: --
1169: end if;
1170: --
1163: --
1164: elsif p_hrs_src_cd = 'BNFTBALTYP' and p_bnfts_bal_id is null then
1165: --
1166: fnd_message.set_name('BEN','BEN_91976_BNFTS_BALANCE_TYP');
1167: fnd_message.raise_error;
1168: --
1169: end if;
1170: --
1171: hr_utility.set_location('Leaving:'||l_proc,10);
1517: close csr_leg_code;
1518: --
1519: -- The primary key is invalid therefore we must error
1520: --
1521: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1522: fnd_message.raise_error;
1523: --
1524: end if;
1525: --
1518: --
1519: -- The primary key is invalid therefore we must error
1520: --
1521: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1522: fnd_message.raise_error;
1523: --
1524: end if;
1525: --
1526: close csr_leg_code;