eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PGM_BUS dependencies on FND_MESSAGE

Line 159: fnd_message.set_name('BEN','BEN_91953_NVLD_AUTO_ENR_MTH_RL');

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

Line 160: fnd_message.raise_error;

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;

Line 206: fnd_message.set_name('BEN','BEN_91730_NO_RULE');

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)

Line 207: fnd_message.raise_error;

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

Line 212: fnd_message.set_name('BEN','BEN_91731_RULE');

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.

Line 213: fnd_message.raise_error;

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

Line 304: fnd_message.set_name('BEN','BEN_91952_INVLD_ENRT_RL');

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

Line 305: fnd_message.raise_error;

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;

Line 397: fnd_message.set_name('BEN','BEN_91251_INV_ENRT_START_DT_RL');

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

Line 398: fnd_message.raise_error;

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;

Line 490: fnd_message.set_name('BEN','BEN_91250_INV_ENRT_END_DT_RL');

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

Line 491: fnd_message.raise_error;

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;

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

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

Line 540: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');

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;

Line 541: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');

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:

Line 542: fnd_message.raise_error;

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

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

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

Line 595: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);

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;

Line 596: fnd_message.set_token('TYPE_ID',-21);

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

Line 597: fnd_message.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: --
601: end if;

Line 690: fnd_message.set_name('BEN','BEN_91252_INV_DPT_CV_ST_DT_RL');

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

Line 691: fnd_message.raise_error;

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;

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

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

Line 783: fnd_message.set_token('ID',p_rt_end_dt_rl);

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;

Line 784: fnd_message.set_token('TYPE_ID',-67);

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

Line 785: fnd_message.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: --
789: close c1;

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

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

Line 877: fnd_message.set_token('ID',p_rt_strt_dt_rl);

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;

Line 878: fnd_message.set_token('TYPE_ID',-66);

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

Line 879: fnd_message.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: --
883: close c1;

Line 971: fnd_message.set_name('BEN','BEN_91253_INV_DPT_CV_EN_DT_RL');

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

Line 972: fnd_message.raise_error;

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;

Line 1063: fnd_message.set_name('BEN','BEN_91254_INV_PRTN_END_DT_RL');

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

Line 1064: fnd_message.raise_error;

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;

Line 1157: fnd_message.set_name('BEN','BEN_91255_INV_PRTN_STA_DT_RL');

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

Line 1158: fnd_message.raise_error;

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;

Line 1231: fnd_message.set_name('BEN','BEN_91256_INV_DPT_ADRS_RQD_FLG');

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

Line 1232: fnd_message.raise_error;

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;

Line 1302: fnd_message.set_name('BEN','BEN_91257_INV_ELG_APLS_ALL_FLG');

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

Line 1303: fnd_message.raise_error;

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;

Line 1373: fnd_message.set_name('BEN','BEN_91528_INV_DPT_DOB_RQD_FLG');

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

Line 1374: fnd_message.raise_error;

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;

Line 1443: fnd_message.set_name('BEN','BEN_91259_INV_PGM_NO_AUTO_FLG');

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

Line 1444: fnd_message.raise_error;

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;

Line 1513: fnd_message.set_name('BEN','BEN_91260_INV_PGM_NO_DFLT_FLG');

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

Line 1514: fnd_message.raise_error;

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;

Line 1583: fnd_message.set_name('BEN','BEN_91261_INV_DPT_LID_RQD_FLG');

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

Line 1584: fnd_message.raise_error;

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;

Line 1653: fnd_message.set_name('BEN','BEN_91262_INV_ELIG_APLS_FLG');

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

Line 1654: fnd_message.raise_error;

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;

Line 1723: fnd_message.set_name('BEN','BEN_91263_INV_PRTT_UNCRS_FLG');

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

Line 1724: fnd_message.raise_error;

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;

Line 1793: fnd_message.set_name('BEN','BEN_91265_INV_PRTN_ELG_OVR_FLG');

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

Line 1794: fnd_message.raise_error;

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;

Line 1865: fnd_message.set_name('BEN','BEN_91266_INV_TMP_FCTR_RTS_FLG');

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

Line 1866: fnd_message.raise_error;

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;

Line 1936: fnd_message.set_name('BEN','BEN_91267_INV_PGM_AST_ELG_FLG');

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

Line 1937: fnd_message.raise_error;

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;

Line 2007: fnd_message.set_name('BEN','BEN_91237_INV_COORD_CVG_FLAG');

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

Line 2008: fnd_message.raise_error;

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;

Line 2078: fnd_message.set_name('BEN','BEN_91288_INV_DRV_FCT_DPT_FLAG');

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

Line 2079: fnd_message.raise_error;

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;

Line 2150: fnd_message.set_name('BEN','BEN_91289_INV_MT_ONE_ELG_FLAG');

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

Line 2151: fnd_message.raise_error;

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;

Line 2221: fnd_message.set_name('BEN','BEN_91290_INV_DRV_FCT_PRTN_FLG');

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

Line 2222: fnd_message.raise_error;

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;

Line 2294: fnd_message.set_name('BEN','BEN_91949_ALWS_UNRSTR_ENRT_FLG');

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

Line 2295: fnd_message.raise_error;

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;

Line 2364: fnd_message.set_name('BEN','BEN_91291_INV_DRV_FCT_RTS_FLAG');

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

Line 2365: fnd_message.raise_error;

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;

Line 2436: fnd_message.set_name('BEN','BEN_91292_INV_TMP_FCT_DPT_FLAG');

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

Line 2437: fnd_message.raise_error;

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;

Line 2507: fnd_message.set_name('BEN','BEN_91293_INV_TMP_FCT_PRTN_FLG');

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

Line 2508: fnd_message.raise_error;

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;

Line 2578: fnd_message.set_name('BEN','BEN_91294_INV_NO_CTFN_RQD_FLAG');

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

Line 2579: fnd_message.raise_error;

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;

Line 2649: fnd_message.set_name('BEN','BEN_91295_INV_TRK_INELG_FLAG');

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

Line 2650: fnd_message.raise_error;

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;

Line 2710: fnd_message.set_name('BEN','BEN_91350_PGM_STATUS_RQD');

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

Line 2711: fnd_message.raise_error;

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;

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

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

Line 2769: fnd_message.raise_error;

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;

Line 2863: fnd_message.set_name('BEN','BEN_91351_PGM_ELIG_APLS');

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

Line 2864: fnd_message.raise_error;

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

Line 2933: fnd_message.set_name('BEN','BEN_91951_INVLD_ENRT_MTHD_CD');

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

Line 2934: fnd_message.raise_error;

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;

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

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

Line 3006: fnd_message.set_token('FIELD','p_poe_lvl_cd');

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;

Line 3007: fnd_message.set_token('TYPE','BEN_POE_LVL');

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

Line 3008: fnd_message.raise_error;

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;

Line 3078: fnd_message.set_name('BEN','BEN_91950_INVALID_ENRT_CD');

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

Line 3079: fnd_message.raise_error;

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;

Line 3148: fnd_message.set_name('BEN','BEN_91217_INVLD_STAT_CD');

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

Line 3149: fnd_message.raise_error;

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;

Line 3218: fnd_message.set_name('BEN','BEN_91296_INV_DPNT_DSGN_LVL_CD');

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;

Line 3219: fnd_message.raise_error;

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

Line 3287: fnd_message.set_name('BEN','BEN_91297_INV_PGM_TYP_CD');

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

Line 3288: fnd_message.raise_error;

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;

Line 3365: fnd_message.set_name('BEN','BEN_91236_INV_DPNT_DSGN_CD');

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;

Line 3366: fnd_message.raise_error;

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

Line 3378: fnd_message.set_name('BEN','BEN_92512_DPNDNT_CVRG_DT_RQD');

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:

Line 3379: fnd_message.raise_error;

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

Line 3388: --fnd_message.set_name('BEN','BEN_92512_DPNDNT_CVRG_DT_RQD');

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:

Line 3389: --fnd_message.raise_error;

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

Line 3456: fnd_message.set_name('BEN','BEN_91298_INV_PGM_GRP_CD');

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;

Line 3457: fnd_message.raise_error;

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

Line 3527: fnd_message.set_name('BEN','BEN_91299_INV_ACTY_REF_PERD_CD');

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;

Line 3528: fnd_message.raise_error;

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

Line 3598: fnd_message.set_name('BEN','BEN_91300_INV_ENRT_STRT_DT_CD');

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;

Line 3599: fnd_message.raise_error;

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

Line 3669: fnd_message.set_name('BEN','BEN_91301_INV_ENRT_END_DT_CD');

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;

Line 3670: fnd_message.raise_error;

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

Line 3741: fnd_message.set_name('BEN','BEN_91304_INV_PRTN_STRT_DT_CD');

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;

Line 3742: fnd_message.raise_error;

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

Line 3812: fnd_message.set_name('BEN','BEN_91305_INV_PRTN_END_DT_CD');

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;

Line 3813: fnd_message.raise_error;

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

Line 3889: fnd_message.set_name('BEN','BEN_91306_INV_PGM_UOM');

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

Line 3890: fnd_message.raise_error;

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;

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

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

Line 3983: fnd_message.set_token('ID',p_Dflt_step_rl);

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;

Line 3984: fnd_message.set_token('TYPE_ID',-449);

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

Line 3985: fnd_message.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: --
3989: close c1;

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

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

Line 4014: fnd_message.set_token('ID',p_Scores_calc_rl);

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;

Line 4015: fnd_message.set_token('TYPE_ID',-550);

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

Line 4016: fnd_message.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: --
4020: close c1;

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

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;

Line 4089: fnd_message.set_token('VALUE', p_dflt_step_cd);

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

Line 4090: fnd_message.set_token('FIELD', 'bnf_dflt_bnf_cd');

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;

Line 4091: fnd_message.set_token('TYPE', 'BEN_GL_PROG_STYLE');

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;

Line 4092: fnd_message.raise_error;

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

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

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;

Line 4117: fnd_message.set_token('VALUE', p_Update_salary_cd);

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

Line 4118: fnd_message.set_token('FIELD', 'Update_salary_cd');

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;

Line 4119: fnd_message.set_token('TYPE', 'PQH_GSP_SAL_UPD_MTHD');

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;

Line 4120: fnd_message.raise_error;

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

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

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;

Line 4144: fnd_message.set_token('VALUE', p_Scores_calc_mthd_cd);

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

Line 4145: fnd_message.set_token('FIELD', 'Scores_calc_mthd_cd');

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;

Line 4146: fnd_message.set_token('TYPE', 'BEN_SCORES_CALC_MTHD');

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;

Line 4147: fnd_message.raise_error;

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

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

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;

Line 4172: fnd_message.set_token('VALUE', p_salary_calc_mthd_cd);

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

Line 4173: fnd_message.set_token('FIELD', 'salary_calc_mthd_cd');

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;

Line 4174: fnd_message.set_token('TYPE', 'PQH_GSP_SAL_CALC_METH');

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;

Line 4175: fnd_message.raise_error;

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

Line 4247: fnd_message.set_name('BEN','BEN_91307_INV_ENRT_RT_FREQ_CD');

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;

Line 4248: fnd_message.raise_error;

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

Line 4318: fnd_message.set_name('BEN','BEN_91308_INV_DPT_CV_ST_DT_CD');

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;

Line 4319: fnd_message.raise_error;

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

Line 4389: fnd_message.set_name('BEN','BEN_91309_INV_DPT_CV_EN_DT_CD');

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;

Line 4390: fnd_message.raise_error;

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

Line 4458: fnd_message.set_name('BEN','BEN_91310_ENRT_STRT_CWOR');

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

Line 4459: fnd_message.raise_error;

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'

Line 4466: fnd_message.set_name('BEN','BEN_91311_ENRT_STRT_RWOC');

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

Line 4467: fnd_message.raise_error;

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;

Line 4535: fnd_message.set_name('BEN','BEN_91378_DFLT_DENRL_END_DT1');

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

Line 4536: fnd_message.raise_error;

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'

Line 4543: fnd_message.set_name('BEN','BEN_91379_DFLT_DENRL_END_DT2');

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

Line 4544: fnd_message.raise_error;

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;

Line 4611: fnd_message.set_name('BEN','BEN_91380_DPNT_CVG_ST_DT_1');

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

Line 4612: fnd_message.raise_error;

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

Line 4618: fnd_message.set_name('BEN','BEN_91381_DPNT_CVG_ST_DT_2');

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

Line 4619: fnd_message.raise_error;

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;

Line 4686: fnd_message.set_name('BEN','BEN_91352_DPNT_CVG_END_CD_NO_R');

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

Line 4687: fnd_message.raise_error;

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

Line 4693: fnd_message.set_name('BEN','BEN_91353_DPNT_CVG_END_R_NO_CD');

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

Line 4694: fnd_message.raise_error;

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;

Line 4803: fnd_message.set_name('BEN','BEN_91375_PGM_DPNT_DSGN_RQD');

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

Line 4804: fnd_message.raise_error;

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;

Line 4887: fnd_message.set_name('BEN','BEN_91372_PGM_PRVD_NO_AUTOENRL');

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

Line 4888: fnd_message.raise_error;

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;

Line 4976: fnd_message.set_name('BEN','BEN_91373_PRVD_NO_DFLT_ENRL_2');

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

Line 4977: fnd_message.raise_error;

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;

Line 5067: fnd_message.set_name('BEN','BEN_91374_PRVD_NO_DFLT_ENRL_1');

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

Line 5068: fnd_message.raise_error;

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;

Line 5186: fnd_message.set_name('BEN','BEN_91400_PGM_DSGN_LVL_RQD');

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;

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

Line 5189: fnd_message.set_name('BEN','BEN_91401_INV_DSGN_LVL_PGM');

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;

Line 5190: fnd_message.raise_error;

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

Line 5286: fnd_message.set_name('BEN','BEN_92519_DELETE_LDC1');

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;

Line 5287: fnd_message.raise_error;

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;

Line 5304: fnd_message.set_name('BEN','BEN_92520_DELETE_ADE1');

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;

Line 5305: fnd_message.raise_error;

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;

Line 5322: fnd_message.set_name('BEN','BEN_92521_DELETE_PGC');

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;

Line 5323: fnd_message.raise_error;

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;

Line 5424: fnd_message.set_name('BEN','BEN_91376_DSGN_LVL_PGM_LDC');

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

Line 5425: fnd_message.raise_error;

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;

Line 5440: fnd_message.set_name('BEN','BEN_91395_DSGN_LVL_PGM_ADE');

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

Line 5441: fnd_message.raise_error;

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;

Line 5458: fnd_message.set_name('BEN','BEN_91396_DSGN_LVL_PGM_PGC');

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

Line 5459: fnd_message.raise_error;

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;

Line 5548: fnd_message.set_name('BEN','BEN_91402_INV_DSGN_LVL_PT2');

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;

Line 5549: fnd_message.raise_error;

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;

Line 5661: fnd_message.set_name('BEN','BEN_91397_DSGN_LVL_PTIP_LDC');

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

Line 5662: fnd_message.raise_error;

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;

Line 5677: fnd_message.set_name('BEN','BEN_91398_DSGN_LVL_PTIP_ADE');

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

Line 5678: fnd_message.raise_error;

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;

Line 5693: fnd_message.set_name('BEN','BEN_91399_DSGN_LVL_PTIP_PYD');

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

Line 5694: fnd_message.raise_error;

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;

Line 5772: --fnd_message.set_name('BEN','BEN_91950_INVALID_ENRT_CD');

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;

Line 5773: fnd_message.set_name('BEN','BEN_93529_GSP_ENRT_CD');

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

Line 5774: fnd_message.raise_error;

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;

Line 5933: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 5934: fnd_message.set_token('PROCEDURE', l_proc);

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

Line 5935: fnd_message.set_token('STEP','15');

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

Line 5936: fnd_message.raise_error;

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

Line 6208: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 6209: fnd_message.set_token('PROCEDURE', l_proc);

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

Line 6210: fnd_message.set_token('STEP','15');

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

Line 6211: fnd_message.raise_error;

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

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

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

Line 7307: fnd_message.raise_error;

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;