DBA Data[Home] [Help]

APPS.BEN_HWF_BUS dependencies on FND_MESSAGE

Line 133: fnd_message.set_name('BEN','BEN_91060_INVLD_ONCE_R_CNTG_CD');

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

Line 134: fnd_message.raise_error;

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;

Line 202: fnd_message.set_name('BEN','BEN_91052_INVALID_MAX_FLAG');

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

Line 203: fnd_message.raise_error;

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;

Line 269: fnd_message.set_name('PAY','91051_INVALID_MIN_FLAG');

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

Line 270: fnd_message.raise_error;

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;

Line 360: fnd_message.set_name('BEN','BEN_91062_INVLD_HRS_WKD_DET_RL');

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

Line 361: fnd_message.raise_error;

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;

Line 372: fnd_message.set_name('BEN', 'BEN_91070_HRS_WKD_RL_NOT_NULL');

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

Line 373: fnd_message.raise_error;

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

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

Line 378: 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: --
382: hr_utility.set_location('Leaving:'||l_proc,10);

Line 443: fnd_message.set_name('BEN','BEN_91061_INVLD_HRS_WKD_DET_CD');

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

Line 444: fnd_message.raise_error;

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;

Line 534: fnd_message.set_name('BEN','BEN_91042_INVALID_RNDG_RL');

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

Line 535: fnd_message.raise_error;

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;

Line 546: fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');

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

Line 547: fnd_message.raise_error;

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

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

Line 552: 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: --
556: --

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

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

Line 619: fnd_message.raise_error;

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;

Line 686: fnd_message.set_name('BEN','BEN_91053_INVALID_SRC_CD');

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

Line 687: fnd_message.raise_error;

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;

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

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

Line 755: fnd_message.set_token('FIELD', 'p_hrs_alt_val_to_use_cd');

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;

Line 756: fnd_message.set_token('TYPE', 'BEN_HRS_ALT_VAL_TO_USE');

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

Line 757: fnd_message.raise_error;

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;

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

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

Line 824: fnd_message.set_token('FIELD', 'p_pyrl_freq_cd');

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;

Line 825: fnd_message.set_token('TYPE', 'BEN_FREQ');

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

Line 826: fnd_message.raise_error;

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;

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

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

Line 915: fnd_message.set_token('ID',p_hrs_wkd_calc_rl);

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;

Line 916: fnd_message.set_token('TYPE_ID',-516);

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

Line 917: fnd_message.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: --
921: close c1;

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

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

Line 1004: fnd_message.raise_error;

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;

Line 1073: fnd_message.set_name('BEN','BEN_91069_INVALID_MIN_MAX');

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

Line 1074: fnd_message.raise_error;

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;

Line 1086: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');

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

Line 1087: fnd_message.raise_error;

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

Line 1092: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');

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

Line 1093: fnd_message.raise_error;

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

Line 1103: fnd_message.set_name('BEN','BEN_91056_MAX_VAL_NOT_NULL');

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

Line 1104: fnd_message.raise_error;

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

Line 1109: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');

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:

Line 1110: fnd_message.raise_error;

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

Line 1161: fnd_message.set_name('BEN','BEN_91975_DEFINED_BALANCE');

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

Line 1162: fnd_message.raise_error;

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

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

Line 1167: 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: --
1171: hr_utility.set_location('Leaving:'||l_proc,10);

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

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

Line 1522: fnd_message.raise_error;

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;