127: p_mn_rlovr_val is not null) then
128: --
129: -- OK fields are not mutaully exclusive so raise an error
130: --
131: fnd_message.set_name('BEN','BEN_91714_MUT_EXLSV_MN_VAL_FLG');
132: fnd_message.raise_error;
133: --
134: end if;
135: --
128: --
129: -- OK fields are not mutaully exclusive so raise an error
130: --
131: fnd_message.set_name('BEN','BEN_91714_MUT_EXLSV_MN_VAL_FLG');
132: fnd_message.raise_error;
133: --
134: end if;
135: --
136: hr_utility.set_location('Leaving:'||l_proc, 10);
188: p_mx_rlovr_val is not null) then
189: --
190: -- OK fields are not mutaully exclusive so raise an error
191: --
192: fnd_message.set_name('BEN','BEN_91715_MUT_EXLSV_MX_VAL_FLG');
193: fnd_message.raise_error;
194: --
195: end if;
196: --
189: --
190: -- OK fields are not mutaully exclusive so raise an error
191: --
192: fnd_message.set_name('BEN','BEN_91715_MUT_EXLSV_MX_VAL_FLG');
193: fnd_message.raise_error;
194: --
195: end if;
196: --
197: hr_utility.set_location('Leaving:'||l_proc, 10);
249: p_mn_rlovr_pct_num is not null) then
250: --
251: -- OK fields are not mutaully exclusive so raise an error
252: --
253: fnd_message.set_name('BEN','BEN_91716_MUT_EXLSV_MN_PCT_FLG');
254: fnd_message.raise_error;
255: --
256: end if;
257: --
250: --
251: -- OK fields are not mutaully exclusive so raise an error
252: --
253: fnd_message.set_name('BEN','BEN_91716_MUT_EXLSV_MN_PCT_FLG');
254: fnd_message.raise_error;
255: --
256: end if;
257: --
258: hr_utility.set_location('Leaving:'||l_proc, 10);
310: p_mx_rlovr_pct_num is not null) then
311: --
312: -- OK fields are not mutaully exclusive so raise an error
313: --
314: fnd_message.set_name('BEN','BEN_91717_MUT_EXLSV_MX_PCT_FLG');
315: fnd_message.raise_error;
316: --
317: end if;
318: --
311: --
312: -- OK fields are not mutaully exclusive so raise an error
313: --
314: fnd_message.set_name('BEN','BEN_91717_MUT_EXLSV_MX_PCT_FLG');
315: fnd_message.raise_error;
316: --
317: end if;
318: --
319: hr_utility.set_location('Leaving:'||l_proc, 10);
377: or not l_api_updating) then
378: --
379: if (p_pct_rndg_cd = 'RL' and p_pct_rndg_rl is null) then
380: --
381: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');
382: fnd_message.raise_error;
383: --
384: end if;
385: --
378: --
379: if (p_pct_rndg_cd = 'RL' and p_pct_rndg_rl is null) then
380: --
381: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');
382: fnd_message.raise_error;
383: --
384: end if;
385: --
386: if nvl(p_pct_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_pct_rndg_rl is not null then
384: end if;
385: --
386: if nvl(p_pct_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_pct_rndg_rl is not null then
387: --
388: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
389: fnd_message.raise_error;
390: --
391: end if;
392: --
385: --
386: if nvl(p_pct_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_pct_rndg_rl is not null then
387: --
388: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
389: fnd_message.raise_error;
390: --
391: end if;
392: --
393: end if;
453: or not l_api_updating) then
454: --
455: if (p_val_rndg_cd = 'RL' and p_val_rndg_rl is null) then
456: --
457: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');
458: fnd_message.raise_error;
459: --
460: end if;
461: --
454: --
455: if (p_val_rndg_cd = 'RL' and p_val_rndg_rl is null) then
456: --
457: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');
458: fnd_message.raise_error;
459: --
460: end if;
461: --
462: if nvl(p_val_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_val_rndg_rl is not null then
460: end if;
461: --
462: if nvl(p_val_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_val_rndg_rl is not null then
463: --
464: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
465: fnd_message.raise_error;
466: --
467: end if;
468: --
461: --
462: if nvl(p_val_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_val_rndg_rl is not null then
463: --
464: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
465: fnd_message.raise_error;
466: --
467: end if;
468: --
469: end if;
529: p_effective_date => p_effective_date) then
530: --
531: -- raise error as does not exist as lookup
532: --
533: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
534: fnd_message.set_token('FIELD','p_pct_rndg_cd');
535: fnd_message.set_token('TYPE','BEN_RNDG');
536: fnd_message.raise_error;
537: --
530: --
531: -- raise error as does not exist as lookup
532: --
533: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
534: fnd_message.set_token('FIELD','p_pct_rndg_cd');
535: fnd_message.set_token('TYPE','BEN_RNDG');
536: fnd_message.raise_error;
537: --
538: end if;
531: -- raise error as does not exist as lookup
532: --
533: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
534: fnd_message.set_token('FIELD','p_pct_rndg_cd');
535: fnd_message.set_token('TYPE','BEN_RNDG');
536: fnd_message.raise_error;
537: --
538: end if;
539: --
532: --
533: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
534: fnd_message.set_token('FIELD','p_pct_rndg_cd');
535: fnd_message.set_token('TYPE','BEN_RNDG');
536: fnd_message.raise_error;
537: --
538: end if;
539: --
540: end if;
622: close c1;
623: --
624: -- raise error
625: --
626: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
627: fnd_message.set_token('ID',p_val_rndg_rl);
628: fnd_message.set_token('TYPE_ID',-169);
629: fnd_message.raise_error;
630: --
623: --
624: -- raise error
625: --
626: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
627: fnd_message.set_token('ID',p_val_rndg_rl);
628: fnd_message.set_token('TYPE_ID',-169);
629: fnd_message.raise_error;
630: --
631: end if;
624: -- raise error
625: --
626: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
627: fnd_message.set_token('ID',p_val_rndg_rl);
628: fnd_message.set_token('TYPE_ID',-169);
629: fnd_message.raise_error;
630: --
631: end if;
632: --
625: --
626: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
627: fnd_message.set_token('ID',p_val_rndg_rl);
628: fnd_message.set_token('TYPE_ID',-169);
629: fnd_message.raise_error;
630: --
631: end if;
632: --
633: close c1;
695: p_effective_date => p_effective_date) then
696: --
697: -- raise error as does not exist as lookup
698: --
699: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
700: fnd_message.set_token('FIELD','p_val_rndg_cd');
701: fnd_message.set_token('TYPE','BEN_RNDG');
702: fnd_message.raise_error;
703: --
696: --
697: -- raise error as does not exist as lookup
698: --
699: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
700: fnd_message.set_token('FIELD','p_val_rndg_cd');
701: fnd_message.set_token('TYPE','BEN_RNDG');
702: fnd_message.raise_error;
703: --
704: end if;
697: -- raise error as does not exist as lookup
698: --
699: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
700: fnd_message.set_token('FIELD','p_val_rndg_cd');
701: fnd_message.set_token('TYPE','BEN_RNDG');
702: fnd_message.raise_error;
703: --
704: end if;
705: --
698: --
699: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
700: fnd_message.set_token('FIELD','p_val_rndg_cd');
701: fnd_message.set_token('TYPE','BEN_RNDG');
702: fnd_message.raise_error;
703: --
704: end if;
705: --
706: end if;
766: p_effective_date => p_effective_date) then
767: --
768: -- raise error as does not exist as lookup
769: --
770: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
771: fnd_message.raise_error;
772: --
773: end if;
774: --
767: --
768: -- raise error as does not exist as lookup
769: --
770: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
771: fnd_message.raise_error;
772: --
773: end if;
774: --
775: end if;
857: close c1;
858: --
859: -- raise error
860: --
861: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
862: fnd_message.set_token('ID',p_rlovr_val_rl);
863: fnd_message.set_token('TYPE_ID',-532);
864: fnd_message.raise_error;
865: --
858: --
859: -- raise error
860: --
861: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
862: fnd_message.set_token('ID',p_rlovr_val_rl);
863: fnd_message.set_token('TYPE_ID',-532);
864: fnd_message.raise_error;
865: --
866: end if;
859: -- raise error
860: --
861: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
862: fnd_message.set_token('ID',p_rlovr_val_rl);
863: fnd_message.set_token('TYPE_ID',-532);
864: fnd_message.raise_error;
865: --
866: end if;
867: --
860: --
861: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
862: fnd_message.set_token('ID',p_rlovr_val_rl);
863: fnd_message.set_token('TYPE_ID',-532);
864: fnd_message.raise_error;
865: --
866: end if;
867: --
868: close c1;
931: p_effective_date => p_effective_date) then
932: --
933: -- raise error as does not exist as lookup
934: --
935: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
936: fnd_message.raise_error;
937: --
938: end if;
939: --
932: --
933: -- raise error as does not exist as lookup
934: --
935: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
936: fnd_message.raise_error;
937: --
938: end if;
939: --
940: end if;
1000: p_effective_date => p_effective_date) then
1001: --
1002: -- raise error as does not exist as lookup
1003: --
1004: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1005: fnd_message.raise_error;
1006: --
1007: end if;
1008: --
1001: --
1002: -- raise error as does not exist as lookup
1003: --
1004: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1005: fnd_message.raise_error;
1006: --
1007: end if;
1008: --
1009: end if;
1069: p_effective_date => p_effective_date) then
1070: --
1071: -- raise error as does not exist as lookup
1072: --
1073: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1074: fnd_message.raise_error;
1075: --
1076: end if;
1077: --
1070: --
1071: -- raise error as does not exist as lookup
1072: --
1073: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1074: fnd_message.raise_error;
1075: --
1076: end if;
1077: --
1078: end if;
1141: p_effective_date => p_effective_date) then
1142: --
1143: -- raise error as does not exist as lookup
1144: --
1145: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1146: fnd_message.set_token('FIELD', 'p_crs_rlovr_procg_cd');
1147: fnd_message.set_token('TYPE','BEN_CRS_RLOVR_PROCG');
1148: fnd_message.raise_error;
1149: --
1142: --
1143: -- raise error as does not exist as lookup
1144: --
1145: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1146: fnd_message.set_token('FIELD', 'p_crs_rlovr_procg_cd');
1147: fnd_message.set_token('TYPE','BEN_CRS_RLOVR_PROCG');
1148: fnd_message.raise_error;
1149: --
1150: end if;
1143: -- raise error as does not exist as lookup
1144: --
1145: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1146: fnd_message.set_token('FIELD', 'p_crs_rlovr_procg_cd');
1147: fnd_message.set_token('TYPE','BEN_CRS_RLOVR_PROCG');
1148: fnd_message.raise_error;
1149: --
1150: end if;
1151: --
1144: --
1145: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1146: fnd_message.set_token('FIELD', 'p_crs_rlovr_procg_cd');
1147: fnd_message.set_token('TYPE','BEN_CRS_RLOVR_PROCG');
1148: fnd_message.raise_error;
1149: --
1150: end if;
1151: --
1152: end if;
1234: close c1;
1235: --
1236: -- raise error
1237: --
1238: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1239: fnd_message.set_token('ID',p_pct_rndg_rl);
1240: fnd_message.set_token('TYPE_ID',-169);
1241: fnd_message.raise_error;
1242: --
1235: --
1236: -- raise error
1237: --
1238: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1239: fnd_message.set_token('ID',p_pct_rndg_rl);
1240: fnd_message.set_token('TYPE_ID',-169);
1241: fnd_message.raise_error;
1242: --
1243: end if;
1236: -- raise error
1237: --
1238: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1239: fnd_message.set_token('ID',p_pct_rndg_rl);
1240: fnd_message.set_token('TYPE_ID',-169);
1241: fnd_message.raise_error;
1242: --
1243: end if;
1244: --
1237: --
1238: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1239: fnd_message.set_token('ID',p_pct_rndg_rl);
1240: fnd_message.set_token('TYPE_ID',-169);
1241: fnd_message.raise_error;
1242: --
1243: end if;
1244: --
1245: close c1;
1329: close c1;
1330: --
1331: -- raise error
1332: --
1333: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1334: fnd_message.set_token('ID',p_prtt_elig_rlovr_rl);
1335: fnd_message.set_token('TYPE_ID',-294);
1336: fnd_message.raise_error;
1337: --
1330: --
1331: -- raise error
1332: --
1333: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1334: fnd_message.set_token('ID',p_prtt_elig_rlovr_rl);
1335: fnd_message.set_token('TYPE_ID',-294);
1336: fnd_message.raise_error;
1337: --
1338: end if;
1331: -- raise error
1332: --
1333: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1334: fnd_message.set_token('ID',p_prtt_elig_rlovr_rl);
1335: fnd_message.set_token('TYPE_ID',-294);
1336: fnd_message.raise_error;
1337: --
1338: end if;
1339: --
1332: --
1333: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1334: fnd_message.set_token('ID',p_prtt_elig_rlovr_rl);
1335: fnd_message.set_token('TYPE_ID',-294);
1336: fnd_message.raise_error;
1337: --
1338: end if;
1339: --
1340: close c1;
1379: fetch c_abp into l_dummy_var ;
1380: if c_abp%found then
1381: hr_utility.set_location('dupes:'||l_proc, 5);
1382: close c_abp ;
1383: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
1384: fnd_message.set_token('VAR1', 'Rollover Requirements');
1385: fnd_message.set_token('VAR2','Benefit Pool');
1386: fnd_message.raise_error;
1387: end if ;
1380: if c_abp%found then
1381: hr_utility.set_location('dupes:'||l_proc, 5);
1382: close c_abp ;
1383: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
1384: fnd_message.set_token('VAR1', 'Rollover Requirements');
1385: fnd_message.set_token('VAR2','Benefit Pool');
1386: fnd_message.raise_error;
1387: end if ;
1388: close c_abp ;
1381: hr_utility.set_location('dupes:'||l_proc, 5);
1382: close c_abp ;
1383: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
1384: fnd_message.set_token('VAR1', 'Rollover Requirements');
1385: fnd_message.set_token('VAR2','Benefit Pool');
1386: fnd_message.raise_error;
1387: end if ;
1388: close c_abp ;
1389:
1382: close c_abp ;
1383: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
1384: fnd_message.set_token('VAR1', 'Rollover Requirements');
1385: fnd_message.set_token('VAR2','Benefit Pool');
1386: fnd_message.raise_error;
1387: end if ;
1388: close c_abp ;
1389:
1390: hr_utility.set_location('Leaving:'||l_proc, 10);
1494: --
1495: -- An unhandled or unexpected error has occurred which
1496: -- we must report
1497: --
1498: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1499: fnd_message.set_token('PROCEDURE', l_proc);
1500: fnd_message.set_token('STEP','15');
1501: fnd_message.raise_error;
1502: End dt_update_validate;
1495: -- An unhandled or unexpected error has occurred which
1496: -- we must report
1497: --
1498: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1499: fnd_message.set_token('PROCEDURE', l_proc);
1500: fnd_message.set_token('STEP','15');
1501: fnd_message.raise_error;
1502: End dt_update_validate;
1503: --
1496: -- we must report
1497: --
1498: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1499: fnd_message.set_token('PROCEDURE', l_proc);
1500: fnd_message.set_token('STEP','15');
1501: fnd_message.raise_error;
1502: End dt_update_validate;
1503: --
1504: -- ----------------------------------------------------------------------------
1497: --
1498: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1499: fnd_message.set_token('PROCEDURE', l_proc);
1500: fnd_message.set_token('STEP','15');
1501: fnd_message.raise_error;
1502: End dt_update_validate;
1503: --
1504: -- ----------------------------------------------------------------------------
1505: -- |--------------------------< dt_delete_validate >--------------------------|
1597: --
1598: -- An unhandled or unexpected error has occurred which
1599: -- we must report
1600: --
1601: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1602: fnd_message.set_token('PROCEDURE', l_proc);
1603: fnd_message.set_token('STEP','15');
1604: fnd_message.raise_error;
1605: End dt_delete_validate;
1598: -- An unhandled or unexpected error has occurred which
1599: -- we must report
1600: --
1601: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1602: fnd_message.set_token('PROCEDURE', l_proc);
1603: fnd_message.set_token('STEP','15');
1604: fnd_message.raise_error;
1605: End dt_delete_validate;
1606: --
1599: -- we must report
1600: --
1601: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1602: fnd_message.set_token('PROCEDURE', l_proc);
1603: fnd_message.set_token('STEP','15');
1604: fnd_message.raise_error;
1605: End dt_delete_validate;
1606: --
1607: -- ----------------------------------------------------------------------------
1600: --
1601: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1602: fnd_message.set_token('PROCEDURE', l_proc);
1603: fnd_message.set_token('STEP','15');
1604: fnd_message.raise_error;
1605: End dt_delete_validate;
1606: --
1607: -- ----------------------------------------------------------------------------
1608: -- |---------------------------< insert_validate >----------------------------|
1961: close csr_leg_code;
1962: --
1963: -- The primary key is invalid therefore we must error
1964: --
1965: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1966: fnd_message.raise_error;
1967: --
1968: end if;
1969: --
1962: --
1963: -- The primary key is invalid therefore we must error
1964: --
1965: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1966: fnd_message.raise_error;
1967: --
1968: end if;
1969: --
1970: close csr_leg_code;