138: open c1;
139: fetch c1 into l_dummy;
140: if c1%found then
141: close c1;
142: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
143: fnd_message.raise_error;
144: end if;
145: end if;
146: --
139: fetch c1 into l_dummy;
140: if c1%found then
141: close c1;
142: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
143: fnd_message.raise_error;
144: end if;
145: end if;
146: --
147: hr_utility.set_location('Leaving:'||l_proc, 15);
198: p_mn_dstrbl_val is not null) then
199: --
200: -- OK fields are not mutaully exclusive so raise an error
201: --
202: fnd_message.set_name('BEN','BEN_91714_MUT_EXLSV_MN_VAL_FLG');
203: fnd_message.raise_error;
204: --
205: end if;
206: --
199: --
200: -- OK fields are not mutaully exclusive so raise an error
201: --
202: fnd_message.set_name('BEN','BEN_91714_MUT_EXLSV_MN_VAL_FLG');
203: fnd_message.raise_error;
204: --
205: end if;
206: --
207: hr_utility.set_location('Leaving:'||l_proc, 10);
259: p_mx_dstrbl_val is not null) then
260: --
261: -- OK fields are not mutaully exclusive so raise an error
262: --
263: fnd_message.set_name('BEN','BEN_91715_MUT_EXLSV_MX_VAL_FLG');
264: fnd_message.raise_error;
265: --
266: end if;
267: --
260: --
261: -- OK fields are not mutaully exclusive so raise an error
262: --
263: fnd_message.set_name('BEN','BEN_91715_MUT_EXLSV_MX_VAL_FLG');
264: fnd_message.raise_error;
265: --
266: end if;
267: --
268: hr_utility.set_location('Leaving:'||l_proc, 10);
320: p_mn_dstrbl_pct_num is not null) then
321: --
322: -- OK fields are not mutaully exclusive so raise an error
323: --
324: fnd_message.set_name('BEN','BEN_91716_MUT_EXLSV_MN_PCT_FLG');
325: fnd_message.raise_error;
326: --
327: end if;
328: --
321: --
322: -- OK fields are not mutaully exclusive so raise an error
323: --
324: fnd_message.set_name('BEN','BEN_91716_MUT_EXLSV_MN_PCT_FLG');
325: fnd_message.raise_error;
326: --
327: end if;
328: --
329: hr_utility.set_location('Leaving:'||l_proc, 10);
381: p_mx_dstrbl_pct_num is not null) then
382: --
383: -- OK fields are not mutaully exclusive so raise an error
384: --
385: fnd_message.set_name('BEN','BEN_91717_MUT_EXLSV_MX_PCT_FLG');
386: fnd_message.raise_error;
387: --
388: end if;
389: --
382: --
383: -- OK fields are not mutaully exclusive so raise an error
384: --
385: fnd_message.set_name('BEN','BEN_91717_MUT_EXLSV_MX_PCT_FLG');
386: fnd_message.raise_error;
387: --
388: end if;
389: --
390: hr_utility.set_location('Leaving:'||l_proc, 10);
448: or not l_api_updating) then
449: --
450: if (p_pct_rndg_cd = 'RL' and p_pct_rndg_rl is null) then
451: --
452: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');
453: fnd_message.raise_error;
454: --
455: end if;
456: --
449: --
450: if (p_pct_rndg_cd = 'RL' and p_pct_rndg_rl is null) then
451: --
452: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');
453: fnd_message.raise_error;
454: --
455: end if;
456: --
457: if nvl(p_pct_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_pct_rndg_rl is not null then
455: end if;
456: --
457: if nvl(p_pct_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_pct_rndg_rl is not null then
458: --
459: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
460: fnd_message.raise_error;
461: --
462: end if;
463: --
456: --
457: if nvl(p_pct_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_pct_rndg_rl is not null then
458: --
459: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
460: fnd_message.raise_error;
461: --
462: end if;
463: --
464: end if;
524: or not l_api_updating) then
525: --
526: if (p_val_rndg_cd = 'RL' and p_val_rndg_rl is null) then
527: --
528: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');
529: fnd_message.raise_error;
530: --
531: end if;
532: --
525: --
526: if (p_val_rndg_cd = 'RL' and p_val_rndg_rl is null) then
527: --
528: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');
529: fnd_message.raise_error;
530: --
531: end if;
532: --
533: if nvl(p_val_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_val_rndg_rl is not null then
531: end if;
532: --
533: if nvl(p_val_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_val_rndg_rl is not null then
534: --
535: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
536: fnd_message.raise_error;
537: --
538: end if;
539: --
532: --
533: if nvl(p_val_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_val_rndg_rl is not null then
534: --
535: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
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;
788: close c1;
789: --
790: -- raise error
791: --
792: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
793: fnd_message.set_token('ID',p_pct_rndg_rl);
794: fnd_message.set_token('TYPE_ID',-169);
795: fnd_message.raise_error;
796: --
789: --
790: -- raise error
791: --
792: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
793: fnd_message.set_token('ID',p_pct_rndg_rl);
794: fnd_message.set_token('TYPE_ID',-169);
795: fnd_message.raise_error;
796: --
797: end if;
790: -- raise error
791: --
792: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
793: fnd_message.set_token('ID',p_pct_rndg_rl);
794: fnd_message.set_token('TYPE_ID',-169);
795: fnd_message.raise_error;
796: --
797: end if;
798: --
791: --
792: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
793: fnd_message.set_token('ID',p_pct_rndg_rl);
794: fnd_message.set_token('TYPE_ID',-169);
795: fnd_message.raise_error;
796: --
797: end if;
798: --
799: close c1;
861: p_effective_date => p_effective_date) then
862: --
863: -- raise error as does not exist as lookup
864: --
865: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
866: fnd_message.set_token('FIELD','p_pct_rndg_cd');
867: fnd_message.set_token('TYPE','BEN_RNDG');
868: fnd_message.raise_error;
869: --
862: --
863: -- raise error as does not exist as lookup
864: --
865: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
866: fnd_message.set_token('FIELD','p_pct_rndg_cd');
867: fnd_message.set_token('TYPE','BEN_RNDG');
868: fnd_message.raise_error;
869: --
870: end if;
863: -- raise error as does not exist as lookup
864: --
865: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
866: fnd_message.set_token('FIELD','p_pct_rndg_cd');
867: fnd_message.set_token('TYPE','BEN_RNDG');
868: fnd_message.raise_error;
869: --
870: end if;
871: --
864: --
865: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
866: fnd_message.set_token('FIELD','p_pct_rndg_cd');
867: fnd_message.set_token('TYPE','BEN_RNDG');
868: fnd_message.raise_error;
869: --
870: end if;
871: --
872: end if;
932: p_effective_date => p_effective_date) then
933: --
934: -- raise error as does not exist as lookup
935: --
936: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
937: fnd_message.raise_error;
938: --
939: end if;
940: --
933: --
934: -- raise error as does not exist as lookup
935: --
936: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
937: fnd_message.raise_error;
938: --
939: end if;
940: --
941: end if;
1001: p_effective_date => p_effective_date) then
1002: --
1003: -- raise error as does not exist as lookup
1004: --
1005: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1006: fnd_message.raise_error;
1007: --
1008: end if;
1009: --
1002: --
1003: -- raise error as does not exist as lookup
1004: --
1005: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1006: fnd_message.raise_error;
1007: --
1008: end if;
1009: --
1010: end if;
1070: p_effective_date => p_effective_date) then
1071: --
1072: -- raise error as does not exist as lookup
1073: --
1074: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1075: fnd_message.raise_error;
1076: --
1077: end if;
1078: --
1071: --
1072: -- raise error as does not exist as lookup
1073: --
1074: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1075: fnd_message.raise_error;
1076: --
1077: end if;
1078: --
1079: end if;
1139: p_effective_date => p_effective_date) then
1140: --
1141: -- raise error as does not exist as lookup
1142: --
1143: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1144: fnd_message.raise_error;
1145: --
1146: end if;
1147: --
1140: --
1141: -- raise error as does not exist as lookup
1142: --
1143: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1144: fnd_message.raise_error;
1145: --
1146: end if;
1147: --
1148: end if;
1208: p_effective_date => p_effective_date) then
1209: --
1210: -- raise error as does not exist as lookup
1211: --
1212: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1213: fnd_message.raise_error;
1214: --
1215: end if;
1216: --
1209: --
1210: -- raise error as does not exist as lookup
1211: --
1212: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1213: fnd_message.raise_error;
1214: --
1215: end if;
1216: --
1217: end if;
1279: p_effective_date => p_effective_date) then
1280: --
1281: -- raise error as does not exist as lookup
1282: --
1283: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1284: fnd_message.raise_error;
1285: --
1286: end if;
1287: --
1280: --
1281: -- raise error as does not exist as lookup
1282: --
1283: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1284: fnd_message.raise_error;
1285: --
1286: end if;
1287: --
1288: end if;
1374: end if;
1375: --Validating for percent num is null and factor also null or percnt has value and factor als has value
1376: If (p_mx_dfcit_pct_comp_num is null and p_comp_lvl_fctr_id is not null ) or
1377: (p_mx_dfcit_pct_comp_num is not null and p_comp_lvl_fctr_id is null ) then
1378: fnd_message.set_name('BEN','BEN_92624_PCT_COMP_REQUIRED');
1379: fnd_message.raise_error;
1380: End if;
1381: hr_utility.set_location('Leaving:'||l_proc,10);
1382: --
1375: --Validating for percent num is null and factor also null or percnt has value and factor als has value
1376: If (p_mx_dfcit_pct_comp_num is null and p_comp_lvl_fctr_id is not null ) or
1377: (p_mx_dfcit_pct_comp_num is not null and p_comp_lvl_fctr_id is null ) then
1378: fnd_message.set_name('BEN','BEN_92624_PCT_COMP_REQUIRED');
1379: fnd_message.raise_error;
1380: End if;
1381: hr_utility.set_location('Leaving:'||l_proc,10);
1382: --
1383: End chk_comp_lvl_fctr_id;
1438: p_effective_date => p_effective_date) then
1439: --
1440: -- raise error as does not exist as lookup
1441: --
1442: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1443: fnd_message.raise_error;
1444: --
1445: end if;
1446: --
1439: --
1440: -- raise error as does not exist as lookup
1441: --
1442: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1443: fnd_message.raise_error;
1444: --
1445: end if;
1446: --
1447: end if;
1524: p_effective_date => p_effective_date) then
1525: --
1526: -- raise error as does not exist as lookup
1527: --
1528: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1529: fnd_message.raise_error;
1530: --
1531: end if;
1532:
1525: --
1526: -- raise error as does not exist as lookup
1527: --
1528: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1529: fnd_message.raise_error;
1530: --
1531: end if;
1532:
1533: -- when the value us 'Y' and theres is value on other region (cash and percent )
1542: or nvl(p_no_mx_dstrbl_pct_flag,'N') = 'Y'
1543: or nvl(p_mn_dstrbl_pct_num,0) <> 0
1544: or nvl(p_mx_dstrbl_pct_num,0) <> 0
1545: or p_pct_rndg_cd is not null) then
1546: fnd_message.set_name('BEN','BEN_92625_USES_NET_CRED_CHKD');
1547: fnd_message.raise_error;
1548:
1549: end if;
1550: --
1543: or nvl(p_mn_dstrbl_pct_num,0) <> 0
1544: or nvl(p_mx_dstrbl_pct_num,0) <> 0
1545: or p_pct_rndg_cd is not null) then
1546: fnd_message.set_name('BEN','BEN_92625_USES_NET_CRED_CHKD');
1547: fnd_message.raise_error;
1548:
1549: end if;
1550: --
1551: end if;
1612: p_effective_date => p_effective_date) then
1613: --
1614: -- raise error as does not exist as lookup
1615: --
1616: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1617: fnd_message.set_token('FIELD','p_excs_trtmt_cd');
1618: fnd_message.set_token('TYPE','BEN_EXCS_TRTMT');
1619: fnd_message.raise_error;
1620: --
1613: --
1614: -- raise error as does not exist as lookup
1615: --
1616: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1617: fnd_message.set_token('FIELD','p_excs_trtmt_cd');
1618: fnd_message.set_token('TYPE','BEN_EXCS_TRTMT');
1619: fnd_message.raise_error;
1620: --
1621: end if;
1614: -- raise error as does not exist as lookup
1615: --
1616: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1617: fnd_message.set_token('FIELD','p_excs_trtmt_cd');
1618: fnd_message.set_token('TYPE','BEN_EXCS_TRTMT');
1619: fnd_message.raise_error;
1620: --
1621: end if;
1622: --
1615: --
1616: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1617: fnd_message.set_token('FIELD','p_excs_trtmt_cd');
1618: fnd_message.set_token('TYPE','BEN_EXCS_TRTMT');
1619: fnd_message.raise_error;
1620: --
1621: end if;
1622: --
1623: end if;
1685: p_effective_date => p_effective_date) then
1686: --
1687: -- raise error as does not exist as lookup
1688: --
1689: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1690: fnd_message.set_token('FIELD','p_dflt_excs_trtmt_cd');
1691: fnd_message.set_token('TYPE','BEN_DFLT_EXCS_TRTMT');
1692: fnd_message.raise_error;
1693: --
1686: --
1687: -- raise error as does not exist as lookup
1688: --
1689: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1690: fnd_message.set_token('FIELD','p_dflt_excs_trtmt_cd');
1691: fnd_message.set_token('TYPE','BEN_DFLT_EXCS_TRTMT');
1692: fnd_message.raise_error;
1693: --
1694: end if;
1687: -- raise error as does not exist as lookup
1688: --
1689: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1690: fnd_message.set_token('FIELD','p_dflt_excs_trtmt_cd');
1691: fnd_message.set_token('TYPE','BEN_DFLT_EXCS_TRTMT');
1692: fnd_message.raise_error;
1693: --
1694: end if;
1695: --
1688: --
1689: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1690: fnd_message.set_token('FIELD','p_dflt_excs_trtmt_cd');
1691: fnd_message.set_token('TYPE','BEN_DFLT_EXCS_TRTMT');
1692: fnd_message.raise_error;
1693: --
1694: end if;
1695: --
1696: end if;
1781: close c1;
1782: --
1783: -- raise error
1784: --
1785: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1786: fnd_message.set_token('ID',p_dflt_excs_trtmt_rl);
1787: fnd_message.set_token('TYPE_ID',-533);
1788: fnd_message.raise_error;
1789: --
1782: --
1783: -- raise error
1784: --
1785: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1786: fnd_message.set_token('ID',p_dflt_excs_trtmt_rl);
1787: fnd_message.set_token('TYPE_ID',-533);
1788: fnd_message.raise_error;
1789: --
1790: end if;
1783: -- raise error
1784: --
1785: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1786: fnd_message.set_token('ID',p_dflt_excs_trtmt_rl);
1787: fnd_message.set_token('TYPE_ID',-533);
1788: fnd_message.raise_error;
1789: --
1790: end if;
1791: --
1784: --
1785: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1786: fnd_message.set_token('ID',p_dflt_excs_trtmt_rl);
1787: fnd_message.set_token('TYPE_ID',-533);
1788: fnd_message.raise_error;
1789: --
1790: end if;
1791: --
1792: close c1;
1853: or not l_api_updating) then
1854: --
1855: if (p_dflt_excs_trtmt_cd = 'RL' and p_dflt_excs_trtmt_rl is null) then
1856: --
1857: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');
1858: fnd_message.raise_error;
1859: --
1860: end if;
1861: --
1854: --
1855: if (p_dflt_excs_trtmt_cd = 'RL' and p_dflt_excs_trtmt_rl is null) then
1856: --
1857: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');
1858: fnd_message.raise_error;
1859: --
1860: end if;
1861: --
1862: if nvl(p_dflt_excs_trtmt_cd,hr_api.g_varchar2) <> 'RL'
1861: --
1862: if nvl(p_dflt_excs_trtmt_cd,hr_api.g_varchar2) <> 'RL'
1863: and p_dflt_excs_trtmt_rl is not null then
1864: --
1865: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
1866: fnd_message.raise_error;
1867: --
1868: end if;
1869: --
1862: if nvl(p_dflt_excs_trtmt_cd,hr_api.g_varchar2) <> 'RL'
1863: and p_dflt_excs_trtmt_rl is not null then
1864: --
1865: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
1866: fnd_message.raise_error;
1867: --
1868: end if;
1869: --
1870: end if;
2032: --
2033: -- An unhandled or unexpected error has occurred which
2034: -- we must report
2035: --
2036: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2037: fnd_message.set_token('PROCEDURE', l_proc);
2038: fnd_message.set_token('STEP','15');
2039: fnd_message.raise_error;
2040: End dt_update_validate;
2033: -- An unhandled or unexpected error has occurred which
2034: -- we must report
2035: --
2036: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2037: fnd_message.set_token('PROCEDURE', l_proc);
2038: fnd_message.set_token('STEP','15');
2039: fnd_message.raise_error;
2040: End dt_update_validate;
2041: --
2034: -- we must report
2035: --
2036: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2037: fnd_message.set_token('PROCEDURE', l_proc);
2038: fnd_message.set_token('STEP','15');
2039: fnd_message.raise_error;
2040: End dt_update_validate;
2041: --
2042: -- ----------------------------------------------------------------------------
2035: --
2036: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2037: fnd_message.set_token('PROCEDURE', l_proc);
2038: fnd_message.set_token('STEP','15');
2039: fnd_message.raise_error;
2040: End dt_update_validate;
2041: --
2042: -- ----------------------------------------------------------------------------
2043: -- |--------------------------< dt_delete_validate >--------------------------|
2161: --
2162: -- An unhandled or unexpected error has occurred which
2163: -- we must report
2164: --
2165: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2166: fnd_message.set_token('PROCEDURE', l_proc);
2167: fnd_message.set_token('STEP','15');
2168: fnd_message.raise_error;
2169: End dt_delete_validate;
2162: -- An unhandled or unexpected error has occurred which
2163: -- we must report
2164: --
2165: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2166: fnd_message.set_token('PROCEDURE', l_proc);
2167: fnd_message.set_token('STEP','15');
2168: fnd_message.raise_error;
2169: End dt_delete_validate;
2170: --
2163: -- we must report
2164: --
2165: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2166: fnd_message.set_token('PROCEDURE', l_proc);
2167: fnd_message.set_token('STEP','15');
2168: fnd_message.raise_error;
2169: End dt_delete_validate;
2170: --
2171: -- ----------------------------------------------------------------------------
2164: --
2165: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2166: fnd_message.set_token('PROCEDURE', l_proc);
2167: fnd_message.set_token('STEP','15');
2168: fnd_message.raise_error;
2169: End dt_delete_validate;
2170: --
2171: -- ----------------------------------------------------------------------------
2172: -- |---------------------------< insert_validate >----------------------------|
2648: close csr_leg_code;
2649: --
2650: -- The primary key is invalid therefore we must error
2651: --
2652: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
2653: fnd_message.raise_error;
2654: --
2655: end if;
2656: --
2649: --
2650: -- The primary key is invalid therefore we must error
2651: --
2652: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
2653: fnd_message.raise_error;
2654: --
2655: end if;
2656: --
2657: close csr_leg_code;