1482: p_effective_date => p_effective_date) then
1483: --
1484: -- raise error as does not exist as lookup
1485: --
1486: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1487: fnd_message.set_token('FIELD', p_cd);
1488: fnd_message.set_token('TYPE',p_lookup_type);
1489: fnd_message.raise_error;
1490: end if;
1483: --
1484: -- raise error as does not exist as lookup
1485: --
1486: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1487: fnd_message.set_token('FIELD', p_cd);
1488: fnd_message.set_token('TYPE',p_lookup_type);
1489: fnd_message.raise_error;
1490: end if;
1491: /*
1484: -- raise error as does not exist as lookup
1485: --
1486: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1487: fnd_message.set_token('FIELD', p_cd);
1488: fnd_message.set_token('TYPE',p_lookup_type);
1489: fnd_message.raise_error;
1490: end if;
1491: /*
1492: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);
1485: --
1486: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1487: fnd_message.set_token('FIELD', p_cd);
1488: fnd_message.set_token('TYPE',p_lookup_type);
1489: fnd_message.raise_error;
1490: end if;
1491: /*
1492: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);
1493: */
1572: --
1573: /*
1574: hr_utility.set_location(l_proc, 40);
1575: */
1576: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1577: fnd_message.set_token('FIELD', p_flag);
1578: fnd_message.set_token('TYPE','YES_NO');
1579: fnd_message.raise_error;
1580: --
1573: /*
1574: hr_utility.set_location(l_proc, 40);
1575: */
1576: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1577: fnd_message.set_token('FIELD', p_flag);
1578: fnd_message.set_token('TYPE','YES_NO');
1579: fnd_message.raise_error;
1580: --
1581: end if;
1574: hr_utility.set_location(l_proc, 40);
1575: */
1576: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1577: fnd_message.set_token('FIELD', p_flag);
1578: fnd_message.set_token('TYPE','YES_NO');
1579: fnd_message.raise_error;
1580: --
1581: end if;
1582: /*
1575: */
1576: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1577: fnd_message.set_token('FIELD', p_flag);
1578: fnd_message.set_token('TYPE','YES_NO');
1579: fnd_message.raise_error;
1580: --
1581: end if;
1582: /*
1583: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);
1670: close c1;
1671: --
1672: -- raise error
1673: --
1674: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1675: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
1676: fnd_message.set_token('TYPE_ID',-29);
1677: fnd_message.raise_error;
1678: --
1671: --
1672: -- raise error
1673: --
1674: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1675: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
1676: fnd_message.set_token('TYPE_ID',-29);
1677: fnd_message.raise_error;
1678: --
1679: end if;
1672: -- raise error
1673: --
1674: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1675: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
1676: fnd_message.set_token('TYPE_ID',-29);
1677: fnd_message.raise_error;
1678: --
1679: end if;
1680: --
1673: --
1674: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1675: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
1676: fnd_message.set_token('TYPE_ID',-29);
1677: fnd_message.raise_error;
1678: --
1679: end if;
1680: --
1681: close c1;
1765: close c1;
1766: --
1767: -- raise error
1768: --
1769: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1770: fnd_message.set_token('ID',p_dpnt_cvg_strt_dt_rl);
1771: fnd_message.set_token('TYPE_ID',-27);
1772: fnd_message.raise_error;
1773: --
1766: --
1767: -- raise error
1768: --
1769: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1770: fnd_message.set_token('ID',p_dpnt_cvg_strt_dt_rl);
1771: fnd_message.set_token('TYPE_ID',-27);
1772: fnd_message.raise_error;
1773: --
1774: end if;
1767: -- raise error
1768: --
1769: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1770: fnd_message.set_token('ID',p_dpnt_cvg_strt_dt_rl);
1771: fnd_message.set_token('TYPE_ID',-27);
1772: fnd_message.raise_error;
1773: --
1774: end if;
1775: --
1768: --
1769: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1770: fnd_message.set_token('ID',p_dpnt_cvg_strt_dt_rl);
1771: fnd_message.set_token('TYPE_ID',-27);
1772: fnd_message.raise_error;
1773: --
1774: end if;
1775: --
1776: close c1;
1840: close csr_leg_code;
1841: --
1842: -- The primary key is invalid therefore we must error
1843: --
1844: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1845: fnd_message.raise_error;
1846: --
1847: end if;
1848: --
1841: --
1842: -- The primary key is invalid therefore we must error
1843: --
1844: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1845: fnd_message.raise_error;
1846: --
1847: end if;
1848: --
1849: close csr_leg_code;