155: close c1;
156: --
157: -- raise error
158: --
159: fnd_message.set_name('BEN','BEN_91953_NVLD_AUTO_ENR_MTH_RL');
160: fnd_message.raise_error;
161: --
162: end if;
163: --
156: --
157: -- raise error
158: --
159: fnd_message.set_name('BEN','BEN_91953_NVLD_AUTO_ENR_MTH_RL');
160: fnd_message.raise_error;
161: --
162: end if;
163: --
164: close c1;
202: hr_utility.set_location('Entering:'||l_proc, 5);
203: --
204: if ( p_vrfy_fmly_mmbr_cd <> 'RL' and p_vrfy_fmly_mmbr_rl is not null)
205: then
206: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
207: fnd_message.raise_error;
208: end if;
209:
210: if ( p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)
203: --
204: if ( p_vrfy_fmly_mmbr_cd <> 'RL' and p_vrfy_fmly_mmbr_rl is not null)
205: then
206: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
207: fnd_message.raise_error;
208: end if;
209:
210: if ( p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)
211: then
208: end if;
209:
210: if ( p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)
211: then
212: fnd_message.set_name('BEN','BEN_91731_RULE');
213: fnd_message.raise_error;
214: end if;
215: --
216: --leaving Procedure.
209:
210: if ( p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)
211: then
212: fnd_message.set_name('BEN','BEN_91731_RULE');
213: fnd_message.raise_error;
214: end if;
215: --
216: --leaving Procedure.
217: --
300: close c1;
301: --
302: -- raise error
303: --
304: fnd_message.set_name('BEN','BEN_91952_INVLD_ENRT_RL');
305: fnd_message.raise_error;
306: --
307: end if;
308: --
301: --
302: -- raise error
303: --
304: fnd_message.set_name('BEN','BEN_91952_INVLD_ENRT_RL');
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_91251_INV_ENRT_START_DT_RL');
398: fnd_message.raise_error;
399: --
400: end if;
401: --
394: --
395: -- raise error
396: --
397: fnd_message.set_name('BEN','BEN_91251_INV_ENRT_START_DT_RL');
398: fnd_message.raise_error;
399: --
400: end if;
401: --
402: close c1;
486: close c1;
487: --
488: -- raise error
489: --
490: fnd_message.set_name('BEN','BEN_91250_INV_ENRT_END_DT_RL');
491: fnd_message.raise_error;
492: --
493: end if;
494: --
487: --
488: -- raise error
489: --
490: fnd_message.set_name('BEN','BEN_91250_INV_ENRT_END_DT_RL');
491: fnd_message.raise_error;
492: --
493: end if;
494: --
495: close c1;
535: p_effective_date => p_effective_date) then
536: --
537: -- raise error as does not exist as lookup
538: --
539: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
540: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
541: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
542: fnd_message.raise_error;
543: --
536: --
537: -- raise error as does not exist as lookup
538: --
539: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
540: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
541: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
542: fnd_message.raise_error;
543: --
544: end if;
537: -- raise error as does not exist as lookup
538: --
539: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
540: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
541: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
542: fnd_message.raise_error;
543: --
544: end if;
545:
538: --
539: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
540: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
541: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
542: fnd_message.raise_error;
543: --
544: end if;
545:
546: --
590: p_effective_date => p_effective_date) then
591: --
592: -- raise error
593: --
594: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
595: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
596: fnd_message.set_token('TYPE_ID',-21);
597: fnd_message.raise_error;
598: --
591: --
592: -- raise error
593: --
594: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
595: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
596: fnd_message.set_token('TYPE_ID',-21);
597: fnd_message.raise_error;
598: --
599: end if;
592: -- raise error
593: --
594: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
595: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
596: fnd_message.set_token('TYPE_ID',-21);
597: fnd_message.raise_error;
598: --
599: end if;
600: --
593: --
594: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
595: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
596: fnd_message.set_token('TYPE_ID',-21);
597: fnd_message.raise_error;
598: --
599: end if;
600: --
601: end if;
686: close c1;
687: --
688: -- raise error
689: --
690: fnd_message.set_name('BEN','BEN_91252_INV_DPT_CV_ST_DT_RL');
691: fnd_message.raise_error;
692: --
693: end if;
694: --
687: --
688: -- raise error
689: --
690: fnd_message.set_name('BEN','BEN_91252_INV_DPT_CV_ST_DT_RL');
691: fnd_message.raise_error;
692: --
693: end if;
694: --
695: close c1;
778: close c1;
779: --
780: -- raise error
781: --
782: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
783: fnd_message.set_token('ID',p_rt_end_dt_rl);
784: fnd_message.set_token('TYPE_ID',-67);
785: fnd_message.raise_error;
786: --
779: --
780: -- raise error
781: --
782: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
783: fnd_message.set_token('ID',p_rt_end_dt_rl);
784: fnd_message.set_token('TYPE_ID',-67);
785: fnd_message.raise_error;
786: --
787: end if;
780: -- raise error
781: --
782: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
783: fnd_message.set_token('ID',p_rt_end_dt_rl);
784: fnd_message.set_token('TYPE_ID',-67);
785: fnd_message.raise_error;
786: --
787: end if;
788: --
781: --
782: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
783: fnd_message.set_token('ID',p_rt_end_dt_rl);
784: fnd_message.set_token('TYPE_ID',-67);
785: fnd_message.raise_error;
786: --
787: end if;
788: --
789: close c1;
872: close c1;
873: --
874: -- raise error
875: --
876: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
877: fnd_message.set_token('ID',p_rt_strt_dt_rl);
878: fnd_message.set_token('TYPE_ID',-66);
879: fnd_message.raise_error;
880: --
873: --
874: -- raise error
875: --
876: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
877: fnd_message.set_token('ID',p_rt_strt_dt_rl);
878: fnd_message.set_token('TYPE_ID',-66);
879: fnd_message.raise_error;
880: --
881: end if;
874: -- raise error
875: --
876: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
877: fnd_message.set_token('ID',p_rt_strt_dt_rl);
878: fnd_message.set_token('TYPE_ID',-66);
879: fnd_message.raise_error;
880: --
881: end if;
882: --
875: --
876: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
877: fnd_message.set_token('ID',p_rt_strt_dt_rl);
878: fnd_message.set_token('TYPE_ID',-66);
879: fnd_message.raise_error;
880: --
881: end if;
882: --
883: close c1;
967: close c1;
968: --
969: -- raise error
970: --
971: fnd_message.set_name('BEN','BEN_91253_INV_DPT_CV_EN_DT_RL');
972: fnd_message.raise_error;
973: --
974: end if;
975: --
968: --
969: -- raise error
970: --
971: fnd_message.set_name('BEN','BEN_91253_INV_DPT_CV_EN_DT_RL');
972: fnd_message.raise_error;
973: --
974: end if;
975: --
976: close c1;
1059: close c1;
1060: --
1061: -- raise error
1062: --
1063: fnd_message.set_name('BEN','BEN_91254_INV_PRTN_END_DT_RL');
1064: fnd_message.raise_error;
1065: --
1066: end if;
1067: --
1060: --
1061: -- raise error
1062: --
1063: fnd_message.set_name('BEN','BEN_91254_INV_PRTN_END_DT_RL');
1064: fnd_message.raise_error;
1065: --
1066: end if;
1067: --
1068: close c1;
1153: close c1;
1154: --
1155: -- raise error
1156: --
1157: fnd_message.set_name('BEN','BEN_91255_INV_PRTN_STA_DT_RL');
1158: fnd_message.raise_error;
1159: --
1160: end if;
1161: --
1154: --
1155: -- raise error
1156: --
1157: fnd_message.set_name('BEN','BEN_91255_INV_PRTN_STA_DT_RL');
1158: fnd_message.raise_error;
1159: --
1160: end if;
1161: --
1162: close c1;
1227: p_effective_date => p_effective_date) then
1228: --
1229: -- raise error as does not exist as lookup
1230: --
1231: fnd_message.set_name('BEN','BEN_91256_INV_DPT_ADRS_RQD_FLG');
1232: fnd_message.raise_error;
1233: --
1234: end if;
1235: --
1228: --
1229: -- raise error as does not exist as lookup
1230: --
1231: fnd_message.set_name('BEN','BEN_91256_INV_DPT_ADRS_RQD_FLG');
1232: fnd_message.raise_error;
1233: --
1234: end if;
1235: --
1236: end if;
1298: p_effective_date => p_effective_date) then
1299: --
1300: -- raise error as does not exist as lookup
1301: --
1302: fnd_message.set_name('BEN','BEN_91257_INV_ELG_APLS_ALL_FLG');
1303: fnd_message.raise_error;
1304: --
1305: end if;
1306: --
1299: --
1300: -- raise error as does not exist as lookup
1301: --
1302: fnd_message.set_name('BEN','BEN_91257_INV_ELG_APLS_ALL_FLG');
1303: fnd_message.raise_error;
1304: --
1305: end if;
1306: --
1307: end if;
1369: p_effective_date => p_effective_date) then
1370: --
1371: -- raise error as does not exist as lookup
1372: --
1373: fnd_message.set_name('BEN','BEN_91528_INV_DPT_DOB_RQD_FLG');
1374: fnd_message.raise_error;
1375: --
1376: end if;
1377: --
1370: --
1371: -- raise error as does not exist as lookup
1372: --
1373: fnd_message.set_name('BEN','BEN_91528_INV_DPT_DOB_RQD_FLG');
1374: fnd_message.raise_error;
1375: --
1376: end if;
1377: --
1378: end if;
1439: p_effective_date => p_effective_date) then
1440: --
1441: -- raise error as does not exist as lookup
1442: --
1443: fnd_message.set_name('BEN','BEN_91259_INV_PGM_NO_AUTO_FLG');
1444: fnd_message.raise_error;
1445: --
1446: end if;
1447: --
1440: --
1441: -- raise error as does not exist as lookup
1442: --
1443: fnd_message.set_name('BEN','BEN_91259_INV_PGM_NO_AUTO_FLG');
1444: fnd_message.raise_error;
1445: --
1446: end if;
1447: --
1448: end if;
1509: p_effective_date => p_effective_date) then
1510: --
1511: -- raise error as does not exist as lookup
1512: --
1513: fnd_message.set_name('BEN','BEN_91260_INV_PGM_NO_DFLT_FLG');
1514: fnd_message.raise_error;
1515: --
1516: end if;
1517: --
1510: --
1511: -- raise error as does not exist as lookup
1512: --
1513: fnd_message.set_name('BEN','BEN_91260_INV_PGM_NO_DFLT_FLG');
1514: fnd_message.raise_error;
1515: --
1516: end if;
1517: --
1518: end if;
1579: p_effective_date => p_effective_date) then
1580: --
1581: -- raise error as does not exist as lookup
1582: --
1583: fnd_message.set_name('BEN','BEN_91261_INV_DPT_LID_RQD_FLG');
1584: fnd_message.raise_error;
1585: --
1586: end if;
1587: --
1580: --
1581: -- raise error as does not exist as lookup
1582: --
1583: fnd_message.set_name('BEN','BEN_91261_INV_DPT_LID_RQD_FLG');
1584: fnd_message.raise_error;
1585: --
1586: end if;
1587: --
1588: end if;
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_91262_INV_ELIG_APLS_FLG');
1654: fnd_message.raise_error;
1655: --
1656: end if;
1657: --
1650: --
1651: -- raise error as does not exist as lookup
1652: --
1653: fnd_message.set_name('BEN','BEN_91262_INV_ELIG_APLS_FLG');
1654: fnd_message.raise_error;
1655: --
1656: end if;
1657: --
1658: end if;
1719: p_effective_date => p_effective_date) then
1720: --
1721: -- raise error as does not exist as lookup
1722: --
1723: fnd_message.set_name('BEN','BEN_91263_INV_PRTT_UNCRS_FLG');
1724: fnd_message.raise_error;
1725: --
1726: end if;
1727: --
1720: --
1721: -- raise error as does not exist as lookup
1722: --
1723: fnd_message.set_name('BEN','BEN_91263_INV_PRTT_UNCRS_FLG');
1724: fnd_message.raise_error;
1725: --
1726: end if;
1727: --
1728: end if;
1789: p_effective_date => p_effective_date) then
1790: --
1791: -- raise error as does not exist as lookup
1792: --
1793: fnd_message.set_name('BEN','BEN_91265_INV_PRTN_ELG_OVR_FLG');
1794: fnd_message.raise_error;
1795: --
1796: end if;
1797: --
1790: --
1791: -- raise error as does not exist as lookup
1792: --
1793: fnd_message.set_name('BEN','BEN_91265_INV_PRTN_ELG_OVR_FLG');
1794: fnd_message.raise_error;
1795: --
1796: end if;
1797: --
1798: end if;
1861: p_effective_date => p_effective_date) then
1862: --
1863: -- raise error as does not exist as lookup
1864: --
1865: fnd_message.set_name('BEN','BEN_91266_INV_TMP_FCTR_RTS_FLG');
1866: fnd_message.raise_error;
1867: --
1868: end if;
1869: --
1862: --
1863: -- raise error as does not exist as lookup
1864: --
1865: fnd_message.set_name('BEN','BEN_91266_INV_TMP_FCTR_RTS_FLG');
1866: fnd_message.raise_error;
1867: --
1868: end if;
1869: --
1870: end if;
1932: p_effective_date => p_effective_date) then
1933: --
1934: -- raise error as does not exist as lookup
1935: --
1936: fnd_message.set_name('BEN','BEN_91267_INV_PGM_AST_ELG_FLG');
1937: fnd_message.raise_error;
1938: --
1939: end if;
1940: --
1933: --
1934: -- raise error as does not exist as lookup
1935: --
1936: fnd_message.set_name('BEN','BEN_91267_INV_PGM_AST_ELG_FLG');
1937: fnd_message.raise_error;
1938: --
1939: end if;
1940: --
1941: end if;
2003: p_effective_date => p_effective_date) then
2004: --
2005: -- raise error as does not exist as lookup
2006: --
2007: fnd_message.set_name('BEN','BEN_91237_INV_COORD_CVG_FLAG');
2008: fnd_message.raise_error;
2009: --
2010: end if;
2011: --
2004: --
2005: -- raise error as does not exist as lookup
2006: --
2007: fnd_message.set_name('BEN','BEN_91237_INV_COORD_CVG_FLAG');
2008: fnd_message.raise_error;
2009: --
2010: end if;
2011: --
2012: end if;
2074: p_effective_date => p_effective_date) then
2075: --
2076: -- raise error as does not exist as lookup
2077: --
2078: fnd_message.set_name('BEN','BEN_91288_INV_DRV_FCT_DPT_FLAG');
2079: fnd_message.raise_error;
2080: --
2081: end if;
2082: --
2075: --
2076: -- raise error as does not exist as lookup
2077: --
2078: fnd_message.set_name('BEN','BEN_91288_INV_DRV_FCT_DPT_FLAG');
2079: fnd_message.raise_error;
2080: --
2081: end if;
2082: --
2083: end if;
2146: p_effective_date => p_effective_date) then
2147: --
2148: -- raise error as does not exist as lookup
2149: --
2150: fnd_message.set_name('BEN','BEN_91289_INV_MT_ONE_ELG_FLAG');
2151: fnd_message.raise_error;
2152: --
2153: end if;
2154: --
2147: --
2148: -- raise error as does not exist as lookup
2149: --
2150: fnd_message.set_name('BEN','BEN_91289_INV_MT_ONE_ELG_FLAG');
2151: fnd_message.raise_error;
2152: --
2153: end if;
2154: --
2155: end if;
2217: p_effective_date => p_effective_date) then
2218: --
2219: -- raise error as does not exist as lookup
2220: --
2221: fnd_message.set_name('BEN','BEN_91290_INV_DRV_FCT_PRTN_FLG');
2222: fnd_message.raise_error;
2223: --
2224: end if;
2225: --
2218: --
2219: -- raise error as does not exist as lookup
2220: --
2221: fnd_message.set_name('BEN','BEN_91290_INV_DRV_FCT_PRTN_FLG');
2222: fnd_message.raise_error;
2223: --
2224: end if;
2225: --
2226: end if;
2290: p_effective_date => p_effective_date) then
2291: --
2292: -- raise error as does not exist as lookup
2293: --
2294: fnd_message.set_name('BEN','BEN_91949_ALWS_UNRSTR_ENRT_FLG');
2295: fnd_message.raise_error;
2296: --
2297: end if;
2298: --
2291: --
2292: -- raise error as does not exist as lookup
2293: --
2294: fnd_message.set_name('BEN','BEN_91949_ALWS_UNRSTR_ENRT_FLG');
2295: fnd_message.raise_error;
2296: --
2297: end if;
2298: --
2299: end if;
2360: p_effective_date => p_effective_date) then
2361: --
2362: -- raise error as does not exist as lookup
2363: --
2364: fnd_message.set_name('BEN','BEN_91291_INV_DRV_FCT_RTS_FLAG');
2365: fnd_message.raise_error;
2366: --
2367: end if;
2368: --
2361: --
2362: -- raise error as does not exist as lookup
2363: --
2364: fnd_message.set_name('BEN','BEN_91291_INV_DRV_FCT_RTS_FLAG');
2365: fnd_message.raise_error;
2366: --
2367: end if;
2368: --
2369: end if;
2432: p_effective_date => p_effective_date) then
2433: --
2434: -- raise error as does not exist as lookup
2435: --
2436: fnd_message.set_name('BEN','BEN_91292_INV_TMP_FCT_DPT_FLAG');
2437: fnd_message.raise_error;
2438: --
2439: end if;
2440: --
2433: --
2434: -- raise error as does not exist as lookup
2435: --
2436: fnd_message.set_name('BEN','BEN_91292_INV_TMP_FCT_DPT_FLAG');
2437: fnd_message.raise_error;
2438: --
2439: end if;
2440: --
2441: end if;
2503: p_effective_date => p_effective_date) then
2504: --
2505: -- raise error as does not exist as lookup
2506: --
2507: fnd_message.set_name('BEN','BEN_91293_INV_TMP_FCT_PRTN_FLG');
2508: fnd_message.raise_error;
2509: --
2510: end if;
2511: --
2504: --
2505: -- raise error as does not exist as lookup
2506: --
2507: fnd_message.set_name('BEN','BEN_91293_INV_TMP_FCT_PRTN_FLG');
2508: fnd_message.raise_error;
2509: --
2510: end if;
2511: --
2512: end if;
2574: p_effective_date => p_effective_date) then
2575: --
2576: -- raise error as does not exist as lookup
2577: --
2578: fnd_message.set_name('BEN','BEN_91294_INV_NO_CTFN_RQD_FLAG');
2579: fnd_message.raise_error;
2580: --
2581: end if;
2582: --
2575: --
2576: -- raise error as does not exist as lookup
2577: --
2578: fnd_message.set_name('BEN','BEN_91294_INV_NO_CTFN_RQD_FLAG');
2579: fnd_message.raise_error;
2580: --
2581: end if;
2582: --
2583: end if;
2645: p_effective_date => p_effective_date) then
2646: --
2647: -- raise error as does not exist as lookup
2648: --
2649: fnd_message.set_name('BEN','BEN_91295_INV_TRK_INELG_FLAG');
2650: fnd_message.raise_error;
2651: --
2652: end if;
2653: --
2646: --
2647: -- raise error as does not exist as lookup
2648: --
2649: fnd_message.set_name('BEN','BEN_91295_INV_TRK_INELG_FLAG');
2650: fnd_message.raise_error;
2651: --
2652: end if;
2653: --
2654: end if;
2706: if c1%notfound then
2707: close c1;
2708: -- raise error as problem getting pgm_stat_cd
2709: --
2710: fnd_message.set_name('BEN','BEN_91350_PGM_STATUS_RQD');
2711: fnd_message.raise_error;
2712: end if;
2713: close c1;
2714: hr_utility.set_location('Leaving:'||l_proc, 10);
2707: close c1;
2708: -- raise error as problem getting pgm_stat_cd
2709: --
2710: fnd_message.set_name('BEN','BEN_91350_PGM_STATUS_RQD');
2711: fnd_message.raise_error;
2712: end if;
2713: close c1;
2714: hr_utility.set_location('Leaving:'||l_proc, 10);
2715: return l_pgm_stat;
2764: open c1;
2765: fetch c1 into l_dummy;
2766: if c1%found then
2767: close c1;
2768: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
2769: fnd_message.raise_error;
2770: end if;
2771: --
2772: hr_utility.set_location('Leaving:'||l_proc, 15);
2765: fetch c1 into l_dummy;
2766: if c1%found then
2767: close c1;
2768: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
2769: fnd_message.raise_error;
2770: end if;
2771: --
2772: hr_utility.set_location('Leaving:'||l_proc, 15);
2773: End chk_name_unique;
2859: close c2;
2860: --
2861: -- if have not returned out then raise error
2862: --
2863: fnd_message.set_name('BEN','BEN_91351_PGM_ELIG_APLS');
2864: fnd_message.raise_error;
2865: end if;
2866: --
2867: hr_utility.set_location('Leaving:'||l_proc, 15);
2860: --
2861: -- if have not returned out then raise error
2862: --
2863: fnd_message.set_name('BEN','BEN_91351_PGM_ELIG_APLS');
2864: fnd_message.raise_error;
2865: end if;
2866: --
2867: hr_utility.set_location('Leaving:'||l_proc, 15);
2868: --
2929: p_effective_date => p_effective_date) then
2930: --
2931: -- raise error as does not exist as lookup
2932: --
2933: fnd_message.set_name('BEN','BEN_91951_INVLD_ENRT_MTHD_CD');
2934: fnd_message.raise_error;
2935: --
2936: end if;
2937: --
2930: --
2931: -- raise error as does not exist as lookup
2932: --
2933: fnd_message.set_name('BEN','BEN_91951_INVLD_ENRT_MTHD_CD');
2934: fnd_message.raise_error;
2935: --
2936: end if;
2937: --
2938: end if;
3001: p_effective_date => p_effective_date) then
3002: --
3003: -- raise error as does not exist as lookup
3004: --
3005: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3006: fnd_message.set_token('FIELD','p_poe_lvl_cd');
3007: fnd_message.set_token('TYPE','BEN_POE_LVL');
3008: fnd_message.raise_error;
3009: --
3002: --
3003: -- raise error as does not exist as lookup
3004: --
3005: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3006: fnd_message.set_token('FIELD','p_poe_lvl_cd');
3007: fnd_message.set_token('TYPE','BEN_POE_LVL');
3008: fnd_message.raise_error;
3009: --
3010: end if;
3003: -- raise error as does not exist as lookup
3004: --
3005: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3006: fnd_message.set_token('FIELD','p_poe_lvl_cd');
3007: fnd_message.set_token('TYPE','BEN_POE_LVL');
3008: fnd_message.raise_error;
3009: --
3010: end if;
3011: --
3004: --
3005: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3006: fnd_message.set_token('FIELD','p_poe_lvl_cd');
3007: fnd_message.set_token('TYPE','BEN_POE_LVL');
3008: fnd_message.raise_error;
3009: --
3010: end if;
3011: --
3012: end if;
3074: p_effective_date => p_effective_date) then
3075: --
3076: -- raise error as does not exist as lookup
3077: --
3078: fnd_message.set_name('BEN','BEN_91950_INVALID_ENRT_CD');
3079: fnd_message.raise_error;
3080: --
3081: end if;
3082: --
3075: --
3076: -- raise error as does not exist as lookup
3077: --
3078: fnd_message.set_name('BEN','BEN_91950_INVALID_ENRT_CD');
3079: fnd_message.raise_error;
3080: --
3081: end if;
3082: --
3083: end if;
3144: p_effective_date => p_effective_date) then
3145: --
3146: -- raise error as does not exist as lookup
3147: --
3148: fnd_message.set_name('BEN','BEN_91217_INVLD_STAT_CD');
3149: fnd_message.raise_error;
3150: --
3151: end if;
3152: --
3145: --
3146: -- raise error as does not exist as lookup
3147: --
3148: fnd_message.set_name('BEN','BEN_91217_INVLD_STAT_CD');
3149: fnd_message.raise_error;
3150: --
3151: end if;
3152: --
3153: end if;
3214: p_effective_date => p_effective_date) then
3215: --
3216: -- raise error as does not exist as lookup
3217: --
3218: fnd_message.set_name('BEN','BEN_91296_INV_DPNT_DSGN_LVL_CD');
3219: fnd_message.raise_error;
3220: --
3221: end if;
3222: end if;
3215: --
3216: -- raise error as does not exist as lookup
3217: --
3218: fnd_message.set_name('BEN','BEN_91296_INV_DPNT_DSGN_LVL_CD');
3219: fnd_message.raise_error;
3220: --
3221: end if;
3222: end if;
3223: --
3283: p_effective_date => p_effective_date) then
3284: --
3285: -- raise error as does not exist as lookup
3286: --
3287: fnd_message.set_name('BEN','BEN_91297_INV_PGM_TYP_CD');
3288: fnd_message.raise_error;
3289: --
3290: end if;
3291: --
3284: --
3285: -- raise error as does not exist as lookup
3286: --
3287: fnd_message.set_name('BEN','BEN_91297_INV_PGM_TYP_CD');
3288: fnd_message.raise_error;
3289: --
3290: end if;
3291: --
3292: end if;
3361: p_effective_date => p_effective_date) then
3362: --
3363: -- raise error as does not exist as lookup
3364: --
3365: fnd_message.set_name('BEN','BEN_91236_INV_DPNT_DSGN_CD');
3366: fnd_message.raise_error;
3367: --
3368: end if;
3369: end if;
3362: --
3363: -- raise error as does not exist as lookup
3364: --
3365: fnd_message.set_name('BEN','BEN_91236_INV_DPNT_DSGN_CD');
3366: fnd_message.raise_error;
3367: --
3368: end if;
3369: end if;
3370: --
3374: /*
3375: if ( p_dpnt_dsgn_cd is not null) and
3376: (p_dpnt_cvg_strt_dt_cd is null or p_dpnt_cvg_end_dt_cd is null) then
3377:
3378: fnd_message.set_name('BEN','BEN_92512_DPNDNT_CVRG_DT_RQD');
3379: fnd_message.raise_error;
3380: end if;
3381: */
3382:
3375: if ( p_dpnt_dsgn_cd is not null) and
3376: (p_dpnt_cvg_strt_dt_cd is null or p_dpnt_cvg_end_dt_cd is null) then
3377:
3378: fnd_message.set_name('BEN','BEN_92512_DPNDNT_CVRG_DT_RQD');
3379: fnd_message.raise_error;
3380: end if;
3381: */
3382:
3383: --
3384:
3385: if (p_dpnt_dsgn_cd is null) and
3386: (p_dpnt_cvg_strt_dt_cd is not null or p_dpnt_cvg_end_dt_cd is not null) then
3387: null;
3388: --fnd_message.set_name('BEN','BEN_92512_DPNDNT_CVRG_DT_RQD');
3389: --fnd_message.raise_error;
3390: end if;
3391: --
3392:
3385: if (p_dpnt_dsgn_cd is null) and
3386: (p_dpnt_cvg_strt_dt_cd is not null or p_dpnt_cvg_end_dt_cd is not null) then
3387: null;
3388: --fnd_message.set_name('BEN','BEN_92512_DPNDNT_CVRG_DT_RQD');
3389: --fnd_message.raise_error;
3390: end if;
3391: --
3392:
3393: hr_utility.set_location('Leaving:'||l_proc,10);
3452: p_effective_date => p_effective_date) then
3453: --
3454: -- raise error as does not exist as lookup
3455: --
3456: fnd_message.set_name('BEN','BEN_91298_INV_PGM_GRP_CD');
3457: fnd_message.raise_error;
3458: --
3459: end if;
3460: end if;
3453: --
3454: -- raise error as does not exist as lookup
3455: --
3456: fnd_message.set_name('BEN','BEN_91298_INV_PGM_GRP_CD');
3457: fnd_message.raise_error;
3458: --
3459: end if;
3460: end if;
3461: --
3523: p_effective_date => p_effective_date) then
3524: --
3525: -- raise error as does not exist as lookup
3526: --
3527: fnd_message.set_name('BEN','BEN_91299_INV_ACTY_REF_PERD_CD');
3528: fnd_message.raise_error;
3529: --
3530: end if;
3531: end if;
3524: --
3525: -- raise error as does not exist as lookup
3526: --
3527: fnd_message.set_name('BEN','BEN_91299_INV_ACTY_REF_PERD_CD');
3528: fnd_message.raise_error;
3529: --
3530: end if;
3531: end if;
3532: --
3594: p_effective_date => p_effective_date) then
3595: --
3596: -- raise error as does not exist as lookup
3597: --
3598: fnd_message.set_name('BEN','BEN_91300_INV_ENRT_STRT_DT_CD');
3599: fnd_message.raise_error;
3600: --
3601: end if;
3602: end if;
3595: --
3596: -- raise error as does not exist as lookup
3597: --
3598: fnd_message.set_name('BEN','BEN_91300_INV_ENRT_STRT_DT_CD');
3599: fnd_message.raise_error;
3600: --
3601: end if;
3602: end if;
3603: --
3665: p_effective_date => p_effective_date) then
3666: --
3667: -- raise error as does not exist as lookup
3668: --
3669: fnd_message.set_name('BEN','BEN_91301_INV_ENRT_END_DT_CD');
3670: fnd_message.raise_error;
3671: --
3672: end if;
3673: end if;
3666: --
3667: -- raise error as does not exist as lookup
3668: --
3669: fnd_message.set_name('BEN','BEN_91301_INV_ENRT_END_DT_CD');
3670: fnd_message.raise_error;
3671: --
3672: end if;
3673: end if;
3674: --
3737: p_effective_date => p_effective_date) then
3738: --
3739: -- raise error as does not exist as lookup
3740: --
3741: fnd_message.set_name('BEN','BEN_91304_INV_PRTN_STRT_DT_CD');
3742: fnd_message.raise_error;
3743: --
3744: end if;
3745: end if;
3738: --
3739: -- raise error as does not exist as lookup
3740: --
3741: fnd_message.set_name('BEN','BEN_91304_INV_PRTN_STRT_DT_CD');
3742: fnd_message.raise_error;
3743: --
3744: end if;
3745: end if;
3746: --
3808: p_effective_date => p_effective_date) then
3809: --
3810: -- raise error as does not exist as lookup
3811: --
3812: fnd_message.set_name('BEN','BEN_91305_INV_PRTN_END_DT_CD');
3813: fnd_message.raise_error;
3814: --
3815: end if;
3816: end if;
3809: --
3810: -- raise error as does not exist as lookup
3811: --
3812: fnd_message.set_name('BEN','BEN_91305_INV_PRTN_END_DT_CD');
3813: fnd_message.raise_error;
3814: --
3815: end if;
3816: end if;
3817: --
3885: if c1%notfound then
3886: close c1;
3887: -- raise error as currency not found
3888: --
3889: fnd_message.set_name('BEN','BEN_91306_INV_PGM_UOM');
3890: fnd_message.raise_error;
3891: end if;
3892: close c1;
3893: --
3886: close c1;
3887: -- raise error as currency not found
3888: --
3889: fnd_message.set_name('BEN','BEN_91306_INV_PGM_UOM');
3890: fnd_message.raise_error;
3891: end if;
3892: close c1;
3893: --
3894: end if;
3978: close c1;
3979: --
3980: -- raise error
3981: --
3982: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3983: fnd_message.set_token('ID',p_Dflt_step_rl);
3984: fnd_message.set_token('TYPE_ID',-449);
3985: fnd_message.raise_error;
3986: --
3979: --
3980: -- raise error
3981: --
3982: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3983: fnd_message.set_token('ID',p_Dflt_step_rl);
3984: fnd_message.set_token('TYPE_ID',-449);
3985: fnd_message.raise_error;
3986: --
3987: end if;
3980: -- raise error
3981: --
3982: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3983: fnd_message.set_token('ID',p_Dflt_step_rl);
3984: fnd_message.set_token('TYPE_ID',-449);
3985: fnd_message.raise_error;
3986: --
3987: end if;
3988: --
3981: --
3982: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3983: fnd_message.set_token('ID',p_Dflt_step_rl);
3984: fnd_message.set_token('TYPE_ID',-449);
3985: fnd_message.raise_error;
3986: --
3987: end if;
3988: --
3989: close c1;
4009: close c1;
4010: --
4011: -- raise error
4012: --
4013: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4014: fnd_message.set_token('ID',p_Scores_calc_rl);
4015: fnd_message.set_token('TYPE_ID',-550);
4016: fnd_message.raise_error;
4017: --
4010: --
4011: -- raise error
4012: --
4013: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4014: fnd_message.set_token('ID',p_Scores_calc_rl);
4015: fnd_message.set_token('TYPE_ID',-550);
4016: fnd_message.raise_error;
4017: --
4018: end if;
4011: -- raise error
4012: --
4013: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4014: fnd_message.set_token('ID',p_Scores_calc_rl);
4015: fnd_message.set_token('TYPE_ID',-550);
4016: fnd_message.raise_error;
4017: --
4018: end if;
4019: --
4012: --
4013: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
4014: fnd_message.set_token('ID',p_Scores_calc_rl);
4015: fnd_message.set_token('TYPE_ID',-550);
4016: fnd_message.raise_error;
4017: --
4018: end if;
4019: --
4020: close c1;
4084: p_effective_date => p_effective_date) then
4085: --
4086: -- raise error as does not exist as lookup
4087: --
4088: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4089: fnd_message.set_token('VALUE', p_dflt_step_cd);
4090: fnd_message.set_token('FIELD', 'bnf_dflt_bnf_cd');
4091: fnd_message.set_token('TYPE', 'BEN_GL_PROG_STYLE');
4092: fnd_message.raise_error;
4085: --
4086: -- raise error as does not exist as lookup
4087: --
4088: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4089: fnd_message.set_token('VALUE', p_dflt_step_cd);
4090: fnd_message.set_token('FIELD', 'bnf_dflt_bnf_cd');
4091: fnd_message.set_token('TYPE', 'BEN_GL_PROG_STYLE');
4092: fnd_message.raise_error;
4093: --
4086: -- raise error as does not exist as lookup
4087: --
4088: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4089: fnd_message.set_token('VALUE', p_dflt_step_cd);
4090: fnd_message.set_token('FIELD', 'bnf_dflt_bnf_cd');
4091: fnd_message.set_token('TYPE', 'BEN_GL_PROG_STYLE');
4092: fnd_message.raise_error;
4093: --
4094: end if;
4087: --
4088: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4089: fnd_message.set_token('VALUE', p_dflt_step_cd);
4090: fnd_message.set_token('FIELD', 'bnf_dflt_bnf_cd');
4091: fnd_message.set_token('TYPE', 'BEN_GL_PROG_STYLE');
4092: fnd_message.raise_error;
4093: --
4094: end if;
4095: end if;
4088: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4089: fnd_message.set_token('VALUE', p_dflt_step_cd);
4090: fnd_message.set_token('FIELD', 'bnf_dflt_bnf_cd');
4091: fnd_message.set_token('TYPE', 'BEN_GL_PROG_STYLE');
4092: fnd_message.raise_error;
4093: --
4094: end if;
4095: end if;
4096: --
4112: p_effective_date => p_effective_date) then
4113: --
4114: -- raise error as does not exist as lookup
4115: --
4116: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4117: fnd_message.set_token('VALUE', p_Update_salary_cd);
4118: fnd_message.set_token('FIELD', 'Update_salary_cd');
4119: fnd_message.set_token('TYPE', 'PQH_GSP_SAL_UPD_MTHD');
4120: fnd_message.raise_error;
4113: --
4114: -- raise error as does not exist as lookup
4115: --
4116: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4117: fnd_message.set_token('VALUE', p_Update_salary_cd);
4118: fnd_message.set_token('FIELD', 'Update_salary_cd');
4119: fnd_message.set_token('TYPE', 'PQH_GSP_SAL_UPD_MTHD');
4120: fnd_message.raise_error;
4121: --
4114: -- raise error as does not exist as lookup
4115: --
4116: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4117: fnd_message.set_token('VALUE', p_Update_salary_cd);
4118: fnd_message.set_token('FIELD', 'Update_salary_cd');
4119: fnd_message.set_token('TYPE', 'PQH_GSP_SAL_UPD_MTHD');
4120: fnd_message.raise_error;
4121: --
4122: end if;
4115: --
4116: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4117: fnd_message.set_token('VALUE', p_Update_salary_cd);
4118: fnd_message.set_token('FIELD', 'Update_salary_cd');
4119: fnd_message.set_token('TYPE', 'PQH_GSP_SAL_UPD_MTHD');
4120: fnd_message.raise_error;
4121: --
4122: end if;
4123: end if;
4116: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4117: fnd_message.set_token('VALUE', p_Update_salary_cd);
4118: fnd_message.set_token('FIELD', 'Update_salary_cd');
4119: fnd_message.set_token('TYPE', 'PQH_GSP_SAL_UPD_MTHD');
4120: fnd_message.raise_error;
4121: --
4122: end if;
4123: end if;
4124: --
4139: p_effective_date => p_effective_date) then
4140: --
4141: -- raise error as does not exist as lookup
4142: --
4143: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4144: fnd_message.set_token('VALUE', p_Scores_calc_mthd_cd);
4145: fnd_message.set_token('FIELD', 'Scores_calc_mthd_cd');
4146: fnd_message.set_token('TYPE', 'BEN_SCORES_CALC_MTHD');
4147: fnd_message.raise_error;
4140: --
4141: -- raise error as does not exist as lookup
4142: --
4143: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4144: fnd_message.set_token('VALUE', p_Scores_calc_mthd_cd);
4145: fnd_message.set_token('FIELD', 'Scores_calc_mthd_cd');
4146: fnd_message.set_token('TYPE', 'BEN_SCORES_CALC_MTHD');
4147: fnd_message.raise_error;
4148: --
4141: -- raise error as does not exist as lookup
4142: --
4143: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4144: fnd_message.set_token('VALUE', p_Scores_calc_mthd_cd);
4145: fnd_message.set_token('FIELD', 'Scores_calc_mthd_cd');
4146: fnd_message.set_token('TYPE', 'BEN_SCORES_CALC_MTHD');
4147: fnd_message.raise_error;
4148: --
4149: end if;
4142: --
4143: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4144: fnd_message.set_token('VALUE', p_Scores_calc_mthd_cd);
4145: fnd_message.set_token('FIELD', 'Scores_calc_mthd_cd');
4146: fnd_message.set_token('TYPE', 'BEN_SCORES_CALC_MTHD');
4147: fnd_message.raise_error;
4148: --
4149: end if;
4150: end if;
4143: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4144: fnd_message.set_token('VALUE', p_Scores_calc_mthd_cd);
4145: fnd_message.set_token('FIELD', 'Scores_calc_mthd_cd');
4146: fnd_message.set_token('TYPE', 'BEN_SCORES_CALC_MTHD');
4147: fnd_message.raise_error;
4148: --
4149: end if;
4150: end if;
4151: --
4167: p_effective_date => p_effective_date) then
4168: --
4169: -- raise error as does not exist as lookup
4170: --
4171: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4172: fnd_message.set_token('VALUE', p_salary_calc_mthd_cd);
4173: fnd_message.set_token('FIELD', 'salary_calc_mthd_cd');
4174: fnd_message.set_token('TYPE', 'PQH_GSP_SAL_CALC_METH');
4175: fnd_message.raise_error;
4168: --
4169: -- raise error as does not exist as lookup
4170: --
4171: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4172: fnd_message.set_token('VALUE', p_salary_calc_mthd_cd);
4173: fnd_message.set_token('FIELD', 'salary_calc_mthd_cd');
4174: fnd_message.set_token('TYPE', 'PQH_GSP_SAL_CALC_METH');
4175: fnd_message.raise_error;
4176: --
4169: -- raise error as does not exist as lookup
4170: --
4171: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4172: fnd_message.set_token('VALUE', p_salary_calc_mthd_cd);
4173: fnd_message.set_token('FIELD', 'salary_calc_mthd_cd');
4174: fnd_message.set_token('TYPE', 'PQH_GSP_SAL_CALC_METH');
4175: fnd_message.raise_error;
4176: --
4177: end if;
4170: --
4171: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4172: fnd_message.set_token('VALUE', p_salary_calc_mthd_cd);
4173: fnd_message.set_token('FIELD', 'salary_calc_mthd_cd');
4174: fnd_message.set_token('TYPE', 'PQH_GSP_SAL_CALC_METH');
4175: fnd_message.raise_error;
4176: --
4177: end if;
4178: end if;
4171: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
4172: fnd_message.set_token('VALUE', p_salary_calc_mthd_cd);
4173: fnd_message.set_token('FIELD', 'salary_calc_mthd_cd');
4174: fnd_message.set_token('TYPE', 'PQH_GSP_SAL_CALC_METH');
4175: fnd_message.raise_error;
4176: --
4177: end if;
4178: end if;
4179: --
4243: p_effective_date => p_effective_date) then
4244: --
4245: -- raise error as does not exist as lookup
4246: --
4247: fnd_message.set_name('BEN','BEN_91307_INV_ENRT_RT_FREQ_CD');
4248: fnd_message.raise_error;
4249: --
4250: end if;
4251: end if;
4244: --
4245: -- raise error as does not exist as lookup
4246: --
4247: fnd_message.set_name('BEN','BEN_91307_INV_ENRT_RT_FREQ_CD');
4248: fnd_message.raise_error;
4249: --
4250: end if;
4251: end if;
4252: --
4314: p_effective_date => p_effective_date) then
4315: --
4316: -- raise error as does not exist as lookup
4317: --
4318: fnd_message.set_name('BEN','BEN_91308_INV_DPT_CV_ST_DT_CD');
4319: fnd_message.raise_error;
4320: --
4321: end if;
4322: end if;
4315: --
4316: -- raise error as does not exist as lookup
4317: --
4318: fnd_message.set_name('BEN','BEN_91308_INV_DPT_CV_ST_DT_CD');
4319: fnd_message.raise_error;
4320: --
4321: end if;
4322: end if;
4323: --
4385: p_effective_date => p_effective_date) then
4386: --
4387: -- raise error as does not exist as lookup
4388: --
4389: fnd_message.set_name('BEN','BEN_91309_INV_DPT_CV_EN_DT_CD');
4390: fnd_message.raise_error;
4391: --
4392: end if;
4393: end if;
4386: --
4387: -- raise error as does not exist as lookup
4388: --
4389: fnd_message.set_name('BEN','BEN_91309_INV_DPT_CV_EN_DT_CD');
4390: fnd_message.raise_error;
4391: --
4392: end if;
4393: end if;
4394: --
4454: or not l_api_updating) then
4455: --
4456: if (p_enrt_cvg_strt_dt_cd = 'RL' and p_enrt_cvg_strt_dt_rl is null) then
4457: --
4458: fnd_message.set_name('BEN','BEN_91310_ENRT_STRT_CWOR');
4459: fnd_message.raise_error;
4460: --
4461: end if;
4462: --
4455: --
4456: if (p_enrt_cvg_strt_dt_cd = 'RL' and p_enrt_cvg_strt_dt_rl is null) then
4457: --
4458: fnd_message.set_name('BEN','BEN_91310_ENRT_STRT_CWOR');
4459: fnd_message.raise_error;
4460: --
4461: end if;
4462: --
4463: if nvl(p_enrt_cvg_strt_dt_cd,hr_api.g_varchar2) <> 'RL'
4462: --
4463: if nvl(p_enrt_cvg_strt_dt_cd,hr_api.g_varchar2) <> 'RL'
4464: and p_enrt_cvg_strt_dt_rl is not null then
4465: --
4466: fnd_message.set_name('BEN','BEN_91311_ENRT_STRT_RWOC');
4467: fnd_message.raise_error;
4468: --
4469: end if;
4470: --
4463: if nvl(p_enrt_cvg_strt_dt_cd,hr_api.g_varchar2) <> 'RL'
4464: and p_enrt_cvg_strt_dt_rl is not null then
4465: --
4466: fnd_message.set_name('BEN','BEN_91311_ENRT_STRT_RWOC');
4467: fnd_message.raise_error;
4468: --
4469: end if;
4470: --
4471: end if;
4531: or not l_api_updating) then
4532: --
4533: if (p_enrt_cvg_end_dt_cd = 'RL' and p_enrt_cvg_end_dt_rl is null) then
4534: --
4535: fnd_message.set_name('BEN','BEN_91378_DFLT_DENRL_END_DT1');
4536: fnd_message.raise_error;
4537: --
4538: end if;
4539: --
4532: --
4533: if (p_enrt_cvg_end_dt_cd = 'RL' and p_enrt_cvg_end_dt_rl is null) then
4534: --
4535: fnd_message.set_name('BEN','BEN_91378_DFLT_DENRL_END_DT1');
4536: fnd_message.raise_error;
4537: --
4538: end if;
4539: --
4540: if nvl(p_enrt_cvg_end_dt_cd,hr_api.g_varchar2) <> 'RL'
4539: --
4540: if nvl(p_enrt_cvg_end_dt_cd,hr_api.g_varchar2) <> 'RL'
4541: and p_enrt_cvg_end_dt_rl is not null then
4542: --
4543: fnd_message.set_name('BEN','BEN_91379_DFLT_DENRL_END_DT2');
4544: fnd_message.raise_error;
4545: --
4546: end if;
4547: --
4540: if nvl(p_enrt_cvg_end_dt_cd,hr_api.g_varchar2) <> 'RL'
4541: and p_enrt_cvg_end_dt_rl is not null then
4542: --
4543: fnd_message.set_name('BEN','BEN_91379_DFLT_DENRL_END_DT2');
4544: fnd_message.raise_error;
4545: --
4546: end if;
4547: --
4548: end if;
4607: or not l_api_updating) then
4608: --
4609: if (p_dpnt_cvg_strt_dt_cd = 'RL' and p_dpnt_cvg_strt_dt_rl is null) then
4610: --
4611: fnd_message.set_name('BEN','BEN_91380_DPNT_CVG_ST_DT_1');
4612: fnd_message.raise_error;
4613: --
4614: end if;
4615: --
4608: --
4609: if (p_dpnt_cvg_strt_dt_cd = 'RL' and p_dpnt_cvg_strt_dt_rl is null) then
4610: --
4611: fnd_message.set_name('BEN','BEN_91380_DPNT_CVG_ST_DT_1');
4612: fnd_message.raise_error;
4613: --
4614: end if;
4615: --
4616: if nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) <> 'RL' and p_dpnt_cvg_strt_dt_rl is not null then
4614: end if;
4615: --
4616: if nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) <> 'RL' and p_dpnt_cvg_strt_dt_rl is not null then
4617: --
4618: fnd_message.set_name('BEN','BEN_91381_DPNT_CVG_ST_DT_2');
4619: fnd_message.raise_error;
4620: --
4621: end if;
4622: --
4615: --
4616: if nvl(p_dpnt_cvg_strt_dt_cd,hr_api.g_varchar2) <> 'RL' and p_dpnt_cvg_strt_dt_rl is not null then
4617: --
4618: fnd_message.set_name('BEN','BEN_91381_DPNT_CVG_ST_DT_2');
4619: fnd_message.raise_error;
4620: --
4621: end if;
4622: --
4623: end if;
4682: or not l_api_updating) then
4683: --
4684: if (p_dpnt_cvg_end_dt_cd = 'RL' and p_dpnt_cvg_end_dt_rl is null) then
4685: --
4686: fnd_message.set_name('BEN','BEN_91352_DPNT_CVG_END_CD_NO_R');
4687: fnd_message.raise_error;
4688: --
4689: end if;
4690: --
4683: --
4684: if (p_dpnt_cvg_end_dt_cd = 'RL' and p_dpnt_cvg_end_dt_rl is null) then
4685: --
4686: fnd_message.set_name('BEN','BEN_91352_DPNT_CVG_END_CD_NO_R');
4687: fnd_message.raise_error;
4688: --
4689: end if;
4690: --
4691: if nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2) <> 'RL' and p_dpnt_cvg_end_dt_rl is not null then
4689: end if;
4690: --
4691: if nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2) <> 'RL' and p_dpnt_cvg_end_dt_rl is not null then
4692: --
4693: fnd_message.set_name('BEN','BEN_91353_DPNT_CVG_END_R_NO_CD');
4694: fnd_message.raise_error;
4695: --
4696: end if;
4697: --
4690: --
4691: if nvl(p_dpnt_cvg_end_dt_cd,hr_api.g_varchar2) <> 'RL' and p_dpnt_cvg_end_dt_rl is not null then
4692: --
4693: fnd_message.set_name('BEN','BEN_91353_DPNT_CVG_END_R_NO_CD');
4694: fnd_message.raise_error;
4695: --
4696: end if;
4697: --
4698: end if;
4799: p_dpnt_legv_id_rqd_flag = 'Y' or
4800: p_dpnt_dsgn_no_ctfn_rqd_flag = 'Y' or
4801: p_drvbl_fctr_dpnt_elig_flag = 'Y') then
4802: --
4803: fnd_message.set_name('BEN','BEN_91375_PGM_DPNT_DSGN_RQD');
4804: fnd_message.raise_error;
4805: --
4806: end if;
4807: --
4800: p_dpnt_dsgn_no_ctfn_rqd_flag = 'Y' or
4801: p_drvbl_fctr_dpnt_elig_flag = 'Y') then
4802: --
4803: fnd_message.set_name('BEN','BEN_91375_PGM_DPNT_DSGN_RQD');
4804: fnd_message.raise_error;
4805: --
4806: end if;
4807: --
4808: end if;
4883: if c1%found then
4884: if p_pgm_prvds_no_auto_enrt_flag = 'Y' then
4885: --
4886: close c1;
4887: fnd_message.set_name('BEN','BEN_91372_PGM_PRVD_NO_AUTOENRL');
4888: fnd_message.raise_error;
4889: --
4890: end if;
4891: --
4884: if p_pgm_prvds_no_auto_enrt_flag = 'Y' then
4885: --
4886: close c1;
4887: fnd_message.set_name('BEN','BEN_91372_PGM_PRVD_NO_AUTOENRL');
4888: fnd_message.raise_error;
4889: --
4890: end if;
4891: --
4892: end if;
4972: --
4973: if p_pgm_prvds_no_dflt_enrt_flag = 'Y' then
4974: --
4975: close c1;
4976: fnd_message.set_name('BEN','BEN_91373_PRVD_NO_DFLT_ENRL_2');
4977: fnd_message.raise_error;
4978: --
4979: end if;
4980: --
4973: if p_pgm_prvds_no_dflt_enrt_flag = 'Y' then
4974: --
4975: close c1;
4976: fnd_message.set_name('BEN','BEN_91373_PRVD_NO_DFLT_ENRL_2');
4977: fnd_message.raise_error;
4978: --
4979: end if;
4980: --
4981: end if;
5063: if c1%found then
5064: if p_pgm_prvds_no_dflt_enrt_flag = 'Y' then
5065: --
5066: close c1;
5067: fnd_message.set_name('BEN','BEN_91374_PRVD_NO_DFLT_ENRL_1');
5068: fnd_message.raise_error;
5069: --
5070: end if;
5071: --
5064: if p_pgm_prvds_no_dflt_enrt_flag = 'Y' then
5065: --
5066: close c1;
5067: fnd_message.set_name('BEN','BEN_91374_PRVD_NO_DFLT_ENRL_1');
5068: fnd_message.raise_error;
5069: --
5070: end if;
5071: --
5072: end if;
5182: p_dpnt_dsgn_no_ctfn_rqd_flag = 'Y' or
5183: p_drvbl_fctr_dpnt_elig_flag = 'Y') then
5184: --
5185: if p_dpnt_dsgn_lvl_cd is null then
5186: fnd_message.set_name('BEN','BEN_91400_PGM_DSGN_LVL_RQD');
5187: fnd_message.raise_error;
5188: else
5189: fnd_message.set_name('BEN','BEN_91401_INV_DSGN_LVL_PGM');
5190: fnd_message.raise_error;
5183: p_drvbl_fctr_dpnt_elig_flag = 'Y') then
5184: --
5185: if p_dpnt_dsgn_lvl_cd is null then
5186: fnd_message.set_name('BEN','BEN_91400_PGM_DSGN_LVL_RQD');
5187: fnd_message.raise_error;
5188: else
5189: fnd_message.set_name('BEN','BEN_91401_INV_DSGN_LVL_PGM');
5190: fnd_message.raise_error;
5191: end if;
5185: if p_dpnt_dsgn_lvl_cd is null then
5186: fnd_message.set_name('BEN','BEN_91400_PGM_DSGN_LVL_RQD');
5187: fnd_message.raise_error;
5188: else
5189: fnd_message.set_name('BEN','BEN_91401_INV_DSGN_LVL_PGM');
5190: fnd_message.raise_error;
5191: end if;
5192: --
5193: end if;
5186: fnd_message.set_name('BEN','BEN_91400_PGM_DSGN_LVL_RQD');
5187: fnd_message.raise_error;
5188: else
5189: fnd_message.set_name('BEN','BEN_91401_INV_DSGN_LVL_PGM');
5190: fnd_message.raise_error;
5191: end if;
5192: --
5193: end if;
5194: --
5282: fetch c1 into l_dummy;
5283: if c1%found then
5284: --
5285: close c1;
5286: fnd_message.set_name('BEN','BEN_92519_DELETE_LDC1');
5287: fnd_message.raise_error;
5288: --
5289: else
5290: close c1;
5283: if c1%found then
5284: --
5285: close c1;
5286: fnd_message.set_name('BEN','BEN_92519_DELETE_LDC1');
5287: fnd_message.raise_error;
5288: --
5289: else
5290: close c1;
5291: end if;
5300: fetch c2 into l_dummy;
5301: if c2%found then
5302: --
5303: close c2;
5304: fnd_message.set_name('BEN','BEN_92520_DELETE_ADE1');
5305: fnd_message.raise_error;
5306: --
5307: else
5308: close c2;
5301: if c2%found then
5302: --
5303: close c2;
5304: fnd_message.set_name('BEN','BEN_92520_DELETE_ADE1');
5305: fnd_message.raise_error;
5306: --
5307: else
5308: close c2;
5309: end if;
5318: fetch c3 into l_dummy;
5319: if c3%found then
5320: --
5321: close c3;
5322: fnd_message.set_name('BEN','BEN_92521_DELETE_PGC');
5323: fnd_message.raise_error;
5324: --
5325: else
5326: close c3;
5319: if c3%found then
5320: --
5321: close c3;
5322: fnd_message.set_name('BEN','BEN_92521_DELETE_PGC');
5323: fnd_message.raise_error;
5324: --
5325: else
5326: close c3;
5327: end if;
5420: if c1%found then
5421: if nvl(p_dpnt_dsgn_lvl_cd,'X') not in ('PGM') then
5422: --
5423: close c1;
5424: fnd_message.set_name('BEN','BEN_91376_DSGN_LVL_PGM_LDC');
5425: fnd_message.raise_error;
5426: --
5427: end if;
5428: --
5421: if nvl(p_dpnt_dsgn_lvl_cd,'X') not in ('PGM') then
5422: --
5423: close c1;
5424: fnd_message.set_name('BEN','BEN_91376_DSGN_LVL_PGM_LDC');
5425: fnd_message.raise_error;
5426: --
5427: end if;
5428: --
5429: end if;
5436: if c2%found then
5437: if nvl(p_dpnt_dsgn_lvl_cd,'X') not in ('PGM') then
5438: --
5439: close c2;
5440: fnd_message.set_name('BEN','BEN_91395_DSGN_LVL_PGM_ADE');
5441: fnd_message.raise_error;
5442: --
5443: end if;
5444: --
5437: if nvl(p_dpnt_dsgn_lvl_cd,'X') not in ('PGM') then
5438: --
5439: close c2;
5440: fnd_message.set_name('BEN','BEN_91395_DSGN_LVL_PGM_ADE');
5441: fnd_message.raise_error;
5442: --
5443: end if;
5444: --
5445: end if;
5454: else
5455: if nvl(p_dpnt_dsgn_lvl_cd,'X') not in ('PGM') then
5456: --
5457: close c3;
5458: fnd_message.set_name('BEN','BEN_91396_DSGN_LVL_PGM_PGC');
5459: fnd_message.raise_error;
5460: --
5461: end if;
5462: --
5455: if nvl(p_dpnt_dsgn_lvl_cd,'X') not in ('PGM') then
5456: --
5457: close c3;
5458: fnd_message.set_name('BEN','BEN_91396_DSGN_LVL_PGM_PGC');
5459: fnd_message.raise_error;
5460: --
5461: end if;
5462: --
5463: end if;
5544: fetch c1 into l_dummy;
5545: if c1%found then
5546: close c1;
5547: --
5548: fnd_message.set_name('BEN','BEN_91402_INV_DSGN_LVL_PT2');
5549: fnd_message.raise_error;
5550: --
5551: end if;
5552: close c1;
5545: if c1%found then
5546: close c1;
5547: --
5548: fnd_message.set_name('BEN','BEN_91402_INV_DSGN_LVL_PT2');
5549: fnd_message.raise_error;
5550: --
5551: end if;
5552: close c1;
5553: end if;
5657: if c1%found then
5658: if nvl(p_dpnt_dsgn_lvl_cd,'X') not in ('PTIP') then
5659: --
5660: close c1;
5661: fnd_message.set_name('BEN','BEN_91397_DSGN_LVL_PTIP_LDC');
5662: fnd_message.raise_error;
5663: --
5664: end if;
5665: --
5658: if nvl(p_dpnt_dsgn_lvl_cd,'X') not in ('PTIP') then
5659: --
5660: close c1;
5661: fnd_message.set_name('BEN','BEN_91397_DSGN_LVL_PTIP_LDC');
5662: fnd_message.raise_error;
5663: --
5664: end if;
5665: --
5666: end if;
5673: if c2%found then
5674: if nvl(p_dpnt_dsgn_lvl_cd,'X') not in ('PTIP') then
5675: --
5676: close c2;
5677: fnd_message.set_name('BEN','BEN_91398_DSGN_LVL_PTIP_ADE');
5678: fnd_message.raise_error;
5679: --
5680: end if;
5681: --
5674: if nvl(p_dpnt_dsgn_lvl_cd,'X') not in ('PTIP') then
5675: --
5676: close c2;
5677: fnd_message.set_name('BEN','BEN_91398_DSGN_LVL_PTIP_ADE');
5678: fnd_message.raise_error;
5679: --
5680: end if;
5681: --
5682: end if;
5689: if c3%found then
5690: if nvl(p_dpnt_dsgn_lvl_cd,'X') not in ('PTIP') then
5691: --
5692: close c3;
5693: fnd_message.set_name('BEN','BEN_91399_DSGN_LVL_PTIP_PYD');
5694: fnd_message.raise_error;
5695: --
5696: end if;
5697: --
5690: if nvl(p_dpnt_dsgn_lvl_cd,'X') not in ('PTIP') then
5691: --
5692: close c3;
5693: fnd_message.set_name('BEN','BEN_91399_DSGN_LVL_PTIP_PYD');
5694: fnd_message.raise_error;
5695: --
5696: end if;
5697: --
5698: end if;
5768: ) then
5769: --
5770: -- raise error as does not exist as lookup
5771: --
5772: --fnd_message.set_name('BEN','BEN_91950_INVALID_ENRT_CD');
5773: fnd_message.set_name('BEN','BEN_93529_GSP_ENRT_CD');
5774: fnd_message.raise_error;
5775: --
5776: end if;
5769: --
5770: -- raise error as does not exist as lookup
5771: --
5772: --fnd_message.set_name('BEN','BEN_91950_INVALID_ENRT_CD');
5773: fnd_message.set_name('BEN','BEN_93529_GSP_ENRT_CD');
5774: fnd_message.raise_error;
5775: --
5776: end if;
5777: --
5770: -- raise error as does not exist as lookup
5771: --
5772: --fnd_message.set_name('BEN','BEN_91950_INVALID_ENRT_CD');
5773: fnd_message.set_name('BEN','BEN_93529_GSP_ENRT_CD');
5774: fnd_message.raise_error;
5775: --
5776: end if;
5777: --
5778: end if;
5929: --
5930: -- An unhandled or unexpected error has occurred which
5931: -- we must report
5932: --
5933: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5934: fnd_message.set_token('PROCEDURE', l_proc);
5935: fnd_message.set_token('STEP','15');
5936: fnd_message.raise_error;
5937: End dt_update_validate;
5930: -- An unhandled or unexpected error has occurred which
5931: -- we must report
5932: --
5933: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5934: fnd_message.set_token('PROCEDURE', l_proc);
5935: fnd_message.set_token('STEP','15');
5936: fnd_message.raise_error;
5937: End dt_update_validate;
5938: --
5931: -- we must report
5932: --
5933: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5934: fnd_message.set_token('PROCEDURE', l_proc);
5935: fnd_message.set_token('STEP','15');
5936: fnd_message.raise_error;
5937: End dt_update_validate;
5938: --
5939: -- ----------------------------------------------------------------------------
5932: --
5933: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5934: fnd_message.set_token('PROCEDURE', l_proc);
5935: fnd_message.set_token('STEP','15');
5936: fnd_message.raise_error;
5937: End dt_update_validate;
5938: --
5939: -- ----------------------------------------------------------------------------
5940: -- |--------------------------< dt_delete_validate >--------------------------|
6204: --
6205: -- An unhandled or unexpected error has occurred which
6206: -- we must report
6207: --
6208: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6209: fnd_message.set_token('PROCEDURE', l_proc);
6210: fnd_message.set_token('STEP','15');
6211: fnd_message.raise_error;
6212: End dt_delete_validate;
6205: -- An unhandled or unexpected error has occurred which
6206: -- we must report
6207: --
6208: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6209: fnd_message.set_token('PROCEDURE', l_proc);
6210: fnd_message.set_token('STEP','15');
6211: fnd_message.raise_error;
6212: End dt_delete_validate;
6213: --
6206: -- we must report
6207: --
6208: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6209: fnd_message.set_token('PROCEDURE', l_proc);
6210: fnd_message.set_token('STEP','15');
6211: fnd_message.raise_error;
6212: End dt_delete_validate;
6213: --
6214: -- ----------------------------------------------------------------------------
6207: --
6208: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
6209: fnd_message.set_token('PROCEDURE', l_proc);
6210: fnd_message.set_token('STEP','15');
6211: fnd_message.raise_error;
6212: End dt_delete_validate;
6213: --
6214: -- ----------------------------------------------------------------------------
6215: -- |---------------------------< insert_validate >----------------------------|
7302: close csr_leg_code;
7303: --
7304: -- The primary key is invalid therefore we must error
7305: --
7306: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
7307: fnd_message.raise_error;
7308: --
7309: end if;
7310: --
7303: --
7304: -- The primary key is invalid therefore we must error
7305: --
7306: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
7307: fnd_message.raise_error;
7308: --
7309: end if;
7310: --
7311: close csr_leg_code;