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_MANAGE_LIFE_EVENTS dependencies on FND_MESSAGE

Line 1252: fnd_message.set_name('BEN','BEN_94094_PERSON_GRADE_NOT_FND');

1248: --
1249: if p_gsp_plip_id is null or p_gsp_pgm_id is null
1250: then
1251: --
1252: fnd_message.set_name('BEN','BEN_94094_PERSON_GRADE_NOT_FND');
1253: --
1254: elsif p_gsp_emp_step_id is null or p_gsp_oipl_id is null
1255: then
1256: --

Line 1257: fnd_message.set_name('BEN','BEN_94095_PERSON_STEP_NOT_FND');

1253: --
1254: elsif p_gsp_emp_step_id is null or p_gsp_oipl_id is null
1255: then
1256: --
1257: fnd_message.set_name('BEN','BEN_94095_PERSON_STEP_NOT_FND');
1258: --
1259: end if;
1260: --
1261: raise g_record_error;

Line 1602: fnd_message.set_name('BEN','BEN_91391_NO_PLAN_PROG');

1598: --
1599: if p_no_plans = 'Y' and
1600: p_no_programs = 'Y' then
1601: --
1602: fnd_message.set_name('BEN','BEN_91391_NO_PLAN_PROG');
1603: fnd_message.raise_error;
1604: --
1605: end if;
1606: --

Line 1603: fnd_message.raise_error;

1599: if p_no_plans = 'Y' and
1600: p_no_programs = 'Y' then
1601: --
1602: fnd_message.set_name('BEN','BEN_91391_NO_PLAN_PROG');
1603: fnd_message.raise_error;
1604: --
1605: end if;
1606: --
1607: -- p_person_selection_rule_id and p_person_id are mutually exclusive

Line 1612: fnd_message.set_name('BEN','BEN_91745_RULE_AND_PERSON');

1608: --
1609: if p_person_id is not null and
1610: p_person_selection_rule_id is not null then
1611: --
1612: fnd_message.set_name('BEN','BEN_91745_RULE_AND_PERSON');
1613: fnd_message.raise_error;
1614: --
1615: end if;
1616: --

Line 1613: fnd_message.raise_error;

1609: if p_person_id is not null and
1610: p_person_selection_rule_id is not null then
1611: --
1612: fnd_message.set_name('BEN','BEN_91745_RULE_AND_PERSON');
1613: fnd_message.raise_error;
1614: --
1615: end if;
1616: --
1617: -- p_no_plans = 'Y' then p_pl_id and p_opt_id must be null

Line 1623: fnd_message.set_name('BEN','BEN_91746_PROGRAMS_ONLY');

1619: if p_no_plans = 'Y' and
1620: (p_pl_id is not null or
1621: p_opt_id is not null) then
1622: --
1623: fnd_message.set_name('BEN','BEN_91746_PROGRAMS_ONLY');
1624: fnd_message.raise_error;
1625: --
1626: end if;
1627: --

Line 1624: fnd_message.raise_error;

1620: (p_pl_id is not null or
1621: p_opt_id is not null) then
1622: --
1623: fnd_message.set_name('BEN','BEN_91746_PROGRAMS_ONLY');
1624: fnd_message.raise_error;
1625: --
1626: end if;
1627: --
1628: -- p_no_programs = 'Y' then p_pgm_id must be null

Line 1633: fnd_message.set_name('BEN','BEN_91747_PLANS_ONLY');

1629: --
1630: if p_no_programs = 'Y' and
1631: p_pgm_id is not null then
1632: --
1633: fnd_message.set_name('BEN','BEN_91747_PLANS_ONLY');
1634: fnd_message.raise_error;
1635: --
1636: end if;
1637: --

Line 1634: fnd_message.raise_error;

1630: if p_no_programs = 'Y' and
1631: p_pgm_id is not null then
1632: --
1633: fnd_message.set_name('BEN','BEN_91747_PLANS_ONLY');
1634: fnd_message.raise_error;
1635: --
1636: end if;
1637: --
1638: -- p_person_id must be of p_person_type_id

Line 1651: fnd_message.set_name('BEN','BEN_91748_PERSON_TYPE');

1647: fetch c1 into l_dummy;
1648: if c1%notfound then
1649: --
1650: close c1;
1651: fnd_message.set_name('BEN','BEN_91748_PERSON_TYPE');
1652: fnd_message.raise_error;
1653: --
1654: end if;
1655: --

Line 1652: fnd_message.raise_error;

1648: if c1%notfound then
1649: --
1650: close c1;
1651: fnd_message.set_name('BEN','BEN_91748_PERSON_TYPE');
1652: fnd_message.raise_error;
1653: --
1654: end if;
1655: --
1656: close c1;

Line 1670: fnd_message.set_name('BEN','BEN_91749_PLAN_TYPE');

1666: (p_no_plans = 'Y' or
1667: p_opt_id is not null or
1668: p_pl_id is not null) then
1669: --
1670: fnd_message.set_name('BEN','BEN_91749_PLAN_TYPE');
1671: fnd_message.raise_error;
1672: --
1673: end if;
1674: --

Line 1671: fnd_message.raise_error;

1667: p_opt_id is not null or
1668: p_pl_id is not null) then
1669: --
1670: fnd_message.set_name('BEN','BEN_91749_PLAN_TYPE');
1671: fnd_message.raise_error;
1672: --
1673: end if;
1674: --
1675: -- p_mode = 'C' and p_popl_enrt_typ_cycl_id is null

Line 1686: fnd_message.set_name('BEN','BEN_91667_SCHED_NO_POPL_ENRT');

1682: --
1683: -- p_popl_enrt_typ_cycl_id is null then
1684: p_lf_evt_ocrd_dt is null then
1685: --
1686: fnd_message.set_name('BEN','BEN_91667_SCHED_NO_POPL_ENRT');
1687: fnd_message.raise_error;
1688: --
1689: end if;
1690: --

Line 1687: fnd_message.raise_error;

1683: -- p_popl_enrt_typ_cycl_id is null then
1684: p_lf_evt_ocrd_dt is null then
1685: --
1686: fnd_message.set_name('BEN','BEN_91667_SCHED_NO_POPL_ENRT');
1687: fnd_message.raise_error;
1688: --
1689: end if;
1690: --
1691: -- CWB Changes

Line 1695: fnd_message.set_name('BEN','BEN_91667_SCHED_NO_POPL_ENRT');

1691: -- CWB Changes
1692: --
1693: if p_mode = 'W' and p_pl_id is null then
1694: --
1695: fnd_message.set_name('BEN','BEN_91667_SCHED_NO_POPL_ENRT');
1696: fnd_message.raise_error;
1697: --
1698: end if;
1699:

Line 1696: fnd_message.raise_error;

1692: --
1693: if p_mode = 'W' and p_pl_id is null then
1694: --
1695: fnd_message.set_name('BEN','BEN_91667_SCHED_NO_POPL_ENRT');
1696: fnd_message.raise_error;
1697: --
1698: end if;
1699:
1700: --

Line 1706: fnd_message.set_name('BEN','BEN_93017_INVALID_EFF_DATE');

1702: -- Effective date must be greater than or equal to Life Event Occurred Date
1703: --
1704: if p_mode = 'W' and p_effective_date < p_lf_evt_ocrd_dt then
1705: --
1706: fnd_message.set_name('BEN','BEN_93017_INVALID_EFF_DATE');
1707: fnd_message.raise_error;
1708: --
1709: end if;
1710:

Line 1707: fnd_message.raise_error;

1703: --
1704: if p_mode = 'W' and p_effective_date < p_lf_evt_ocrd_dt then
1705: --
1706: fnd_message.set_name('BEN','BEN_93017_INVALID_EFF_DATE');
1707: fnd_message.raise_error;
1708: --
1709: end if;
1710:
1711: --

Line 1729: fnd_message.set_name('BEN','BEN_93015_CWB_NO_WS_RATE');

1725: fetch c2 into l_dummy;
1726: if c2%found then -- Bug 3975857 Changed "notfound" to "found"
1727: --
1728: close c2;
1729: fnd_message.set_name('BEN','BEN_93015_CWB_NO_WS_RATE');
1730: fnd_message.raise_error;
1731: --
1732: end if;
1733: --

Line 1730: fnd_message.raise_error;

1726: if c2%found then -- Bug 3975857 Changed "notfound" to "found"
1727: --
1728: close c2;
1729: fnd_message.set_name('BEN','BEN_93015_CWB_NO_WS_RATE');
1730: fnd_message.raise_error;
1731: --
1732: end if;
1733: --
1734: close c2;

Line 1744: fnd_message.set_name('BEN','BEN_93968_CWB_BDGT_RT_AMT_CB');

1740: fetch c5 into l_dummy;
1741: if c5%found then
1742: --
1743: close c5;
1744: fnd_message.set_name('BEN','BEN_93968_CWB_BDGT_RT_AMT_CB');
1745: fnd_message.raise_error;
1746: --
1747: end if;
1748: close c5;

Line 1745: fnd_message.raise_error;

1741: if c5%found then
1742: --
1743: close c5;
1744: fnd_message.set_name('BEN','BEN_93968_CWB_BDGT_RT_AMT_CB');
1745: fnd_message.raise_error;
1746: --
1747: end if;
1748: close c5;
1749: --

Line 1776: * fnd_message.set_name('BEN','BEN_93742_CWB_RATE_TO_CHILD');

1772: * fetch c11 into l_dummy ;
1773: * if c11%found then
1774: * close c11 ;
1775: * close c10 ;
1776: * fnd_message.set_name('BEN','BEN_93742_CWB_RATE_TO_CHILD');
1777: * fnd_message.raise_error;
1778: * end if ;
1779: * close c11 ;
1780: * end if ;

Line 1777: * fnd_message.raise_error;

1773: * if c11%found then
1774: * close c11 ;
1775: * close c10 ;
1776: * fnd_message.set_name('BEN','BEN_93742_CWB_RATE_TO_CHILD');
1777: * fnd_message.raise_error;
1778: * end if ;
1779: * close c11 ;
1780: * end if ;
1781: * close c10 ;

Line 1790: fnd_message.set_name('BEN','BEN_93967_CWB_BDGT_RT_PLAN_CB');

1786: if c3_rec.uses_bdgt_flag = 'Y' then
1787: if l_cwbdb_count < 1 or
1788: l_cwbwb_count < 1 then
1789: --
1790: fnd_message.set_name('BEN','BEN_93967_CWB_BDGT_RT_PLAN_CB');
1791: fnd_message.raise_error;
1792: --
1793: end if;
1794: end if ;

Line 1791: fnd_message.raise_error;

1787: if l_cwbdb_count < 1 or
1788: l_cwbwb_count < 1 then
1789: --
1790: fnd_message.set_name('BEN','BEN_93967_CWB_BDGT_RT_PLAN_CB');
1791: fnd_message.raise_error;
1792: --
1793: end if;
1794: end if ;
1795: /* -- bug 5090149

Line 1801: fnd_message.set_name('BEN','BEN_93740_CWB_BDGT_TASK_NOT');

1797: open c9 ;
1798: fetch c9 into l_dummy ;
1799: if c9%notfound then
1800: close c9 ;
1801: fnd_message.set_name('BEN','BEN_93740_CWB_BDGT_TASK_NOT');
1802: fnd_message.raise_error;
1803: end if ;
1804: close c9 ;
1805: */

Line 1802: fnd_message.raise_error;

1798: fetch c9 into l_dummy ;
1799: if c9%notfound then
1800: close c9 ;
1801: fnd_message.set_name('BEN','BEN_93740_CWB_BDGT_TASK_NOT');
1802: fnd_message.raise_error;
1803: end if ;
1804: close c9 ;
1805: */
1806:

Line 1816: fnd_message.set_name('BEN','BEN_93743_CWB_RATE_TO_GROUP');

1812: -- if the plan is not group and date DB/WB/reserve attached then error
1813: if l_cwbdb_count > 0 or
1814: l_cwbwb_count > 0 or
1815: l_cwbr_count > 0 then
1816: fnd_message.set_name('BEN','BEN_93743_CWB_RATE_TO_GROUP');
1817: fnd_message.raise_error;
1818: end if ;
1819: */
1820: end if ;

Line 1817: fnd_message.raise_error;

1813: if l_cwbdb_count > 0 or
1814: l_cwbwb_count > 0 or
1815: l_cwbr_count > 0 then
1816: fnd_message.set_name('BEN','BEN_93743_CWB_RATE_TO_GROUP');
1817: fnd_message.raise_error;
1818: end if ;
1819: */
1820: end if ;
1821: --

Line 1831: fnd_message.set_name('BEN','BEN_93319_CWB_BDGT_RT_SAL');

1827: fetch c6 into l_dummy;
1828: if c6%found then
1829: --
1830: close c6;
1831: fnd_message.set_name('BEN','BEN_93319_CWB_BDGT_RT_SAL');
1832: fnd_message.raise_error;
1833: --
1834: end if;
1835: --

Line 1832: fnd_message.raise_error;

1828: if c6%found then
1829: --
1830: close c6;
1831: fnd_message.set_name('BEN','BEN_93319_CWB_BDGT_RT_SAL');
1832: fnd_message.raise_error;
1833: --
1834: end if;
1835: --
1836: close c6;

Line 1852: fnd_message.set_name('BEN','BEN_93320_CWB_OPT_COMP_RSN');

1848: fetch c7 into l_opt_count;
1849: close c7;
1850:
1851: if l_opt_count = 1 then
1852: fnd_message.set_name('BEN','BEN_93320_CWB_OPT_COMP_RSN');
1853: fnd_message.raise_error;
1854: end if;
1855: */
1856:

Line 1853: fnd_message.raise_error;

1849: close c7;
1850:
1851: if l_opt_count = 1 then
1852: fnd_message.set_name('BEN','BEN_93320_CWB_OPT_COMP_RSN');
1853: fnd_message.raise_error;
1854: end if;
1855: */
1856:
1857: --

Line 1866: fnd_message.set_name('BEN','BEN_93356_CWB_NO_CVG');

1862: fetch c8 into l_dummy;
1863: if c8%found then
1864: --
1865: close c8;
1866: fnd_message.set_name('BEN','BEN_93356_CWB_NO_CVG');
1867: fnd_message.raise_error;
1868: --
1869: end if;
1870: --

Line 1867: fnd_message.raise_error;

1863: if c8%found then
1864: --
1865: close c8;
1866: fnd_message.set_name('BEN','BEN_93356_CWB_NO_CVG');
1867: fnd_message.raise_error;
1868: --
1869: end if;
1870: --
1871: close c8;

Line 1889: fnd_message.set_name('BEN','BEN_94026_NO_RPTG_GRP_DFND');

1885: fetch c_irec_rptg_grp into l_dummy;
1886: if c_irec_rptg_grp%notfound then
1887: --
1888: close c_irec_rptg_grp;
1889: fnd_message.set_name('BEN','BEN_94026_NO_RPTG_GRP_DFND');
1890: fnd_message.raise_error;
1891: --
1892: end if;
1893: --

Line 1890: fnd_message.raise_error;

1886: if c_irec_rptg_grp%notfound then
1887: --
1888: close c_irec_rptg_grp;
1889: fnd_message.set_name('BEN','BEN_94026_NO_RPTG_GRP_DFND');
1890: fnd_message.raise_error;
1891: --
1892: end if;
1893: --
1894: close c_irec_rptg_grp;

Line 1912: fnd_message.set_name('BEN','BEN_94090_NO_GSP_RS_LER_DFND');

1908: if c_gsp_rate_sync_ler%notfound
1909: then
1910: --
1911: close c_gsp_rate_sync_ler;
1912: fnd_message.set_name('BEN','BEN_94090_NO_GSP_RS_LER_DFND');
1913: fnd_message.raise_error;
1914: --
1915: end if;
1916: --

Line 1913: fnd_message.raise_error;

1909: then
1910: --
1911: close c_gsp_rate_sync_ler;
1912: fnd_message.set_name('BEN','BEN_94090_NO_GSP_RS_LER_DFND');
1913: fnd_message.raise_error;
1914: --
1915: end if;
1916: --
1917: close c_gsp_rate_sync_ler;

Line 1938: fnd_message.set_name('BEN','BEN_91326_MODE_INVALID');

1934: (p_lookup_type => 'BEN_BENMNGLE_MD',
1935: p_lookup_code => p_mode,
1936: p_effective_date => p_effective_date) then
1937: --
1938: fnd_message.set_name('BEN','BEN_91326_MODE_INVALID');
1939: fnd_message.raise_error;
1940: --
1941: end if;
1942: --

Line 1939: fnd_message.raise_error;

1935: p_lookup_code => p_mode,
1936: p_effective_date => p_effective_date) then
1937: --
1938: fnd_message.set_name('BEN','BEN_91326_MODE_INVALID');
1939: fnd_message.raise_error;
1940: --
1941: end if;
1942: --
1943: -- 2940151 grade/step

Line 1950: fnd_message.set_name('PER','HR_289506_SPP_BR_NULL');

1946: if p_per_sel_dt_cd is null and
1947: ( p_per_sel_dt_from is not null or
1948: p_per_sel_dt_to is not null) then
1949:
1950: fnd_message.set_name('PER','HR_289506_SPP_BR_NULL');
1951: fnd_message.raise_error;
1952: end if;
1953:
1954: -- 2. If business rule param is not null and business rule strt or end dts

Line 1951: fnd_message.raise_error;

1947: ( p_per_sel_dt_from is not null or
1948: p_per_sel_dt_to is not null) then
1949:
1950: fnd_message.set_name('PER','HR_289506_SPP_BR_NULL');
1951: fnd_message.raise_error;
1952: end if;
1953:
1954: -- 2. If business rule param is not null and business rule strt or end dts
1955: -- are null, raise error

Line 1960: fnd_message.set_name('PER','HR_289510_SPP_BR_DATE_NULL');

1956: if p_per_sel_dt_cd is not null and
1957: ( p_per_sel_dt_from is null or
1958: p_per_sel_dt_to is null) then
1959:
1960: fnd_message.set_name('PER','HR_289510_SPP_BR_DATE_NULL');
1961: fnd_message.raise_error;
1962: end if;
1963: --
1964: -- 3. If business rule param is neither of the four values, raise error

Line 1961: fnd_message.raise_error;

1957: ( p_per_sel_dt_from is null or
1958: p_per_sel_dt_to is null) then
1959:
1960: fnd_message.set_name('PER','HR_289510_SPP_BR_DATE_NULL');
1961: fnd_message.raise_error;
1962: end if;
1963: --
1964: -- 3. If business rule param is neither of the four values, raise error
1965:

Line 1967: fnd_message.set_name('PER','HR_289507_SPP_BR_INVALID');

1963: --
1964: -- 3. If business rule param is neither of the four values, raise error
1965:
1966: if p_per_sel_dt_cd not in ('AOJ', 'DOB', 'ASD', 'LHD') then
1967: fnd_message.set_name('PER','HR_289507_SPP_BR_INVALID');
1968: fnd_message.raise_error;
1969: end if;
1970: --
1971: -- 4. If date from is greater than date to, raise error

Line 1968: fnd_message.raise_error;

1964: -- 3. If business rule param is neither of the four values, raise error
1965:
1966: if p_per_sel_dt_cd not in ('AOJ', 'DOB', 'ASD', 'LHD') then
1967: fnd_message.set_name('PER','HR_289507_SPP_BR_INVALID');
1968: fnd_message.raise_error;
1969: end if;
1970: --
1971: -- 4. If date from is greater than date to, raise error
1972:

Line 1974: fnd_message.set_name('PER','HR_289500_SPP_BR_DATE');

1970: --
1971: -- 4. If date from is greater than date to, raise error
1972:
1973: if p_per_sel_dt_from > p_per_sel_dt_to then
1974: fnd_message.set_name('PER','HR_289500_SPP_BR_DATE');
1975: fnd_message.raise_error;
1976: end if;
1977: --
1978: -- 5. If the dates are more than 12 months apart, raise error

Line 1975: fnd_message.raise_error;

1971: -- 4. If date from is greater than date to, raise error
1972:
1973: if p_per_sel_dt_from > p_per_sel_dt_to then
1974: fnd_message.set_name('PER','HR_289500_SPP_BR_DATE');
1975: fnd_message.raise_error;
1976: end if;
1977: --
1978: -- 5. If the dates are more than 12 months apart, raise error
1979:

Line 1981: fnd_message.set_name('PER','HR_289501_SPP_BR_YEAR_GREATER');

1977: --
1978: -- 5. If the dates are more than 12 months apart, raise error
1979:
1980: if ( months_between( p_per_sel_dt_to, p_per_sel_dt_from) > 12 ) then
1981: fnd_message.set_name('PER','HR_289501_SPP_BR_YEAR_GREATER');
1982: fnd_message.raise_error;
1983: end if;
1984: --
1985: -- 6. If effective date does not fall between the from and to dates, raise error

Line 1982: fnd_message.raise_error;

1978: -- 5. If the dates are more than 12 months apart, raise error
1979:
1980: if ( months_between( p_per_sel_dt_to, p_per_sel_dt_from) > 12 ) then
1981: fnd_message.set_name('PER','HR_289501_SPP_BR_YEAR_GREATER');
1982: fnd_message.raise_error;
1983: end if;
1984: --
1985: -- 6. If effective date does not fall between the from and to dates, raise error
1986:

Line 1988: fnd_message.set_name('PER','HR_289503_SPP_EFF_BR_DATE');

1984: --
1985: -- 6. If effective date does not fall between the from and to dates, raise error
1986:
1987: if not ( p_effective_date between p_per_sel_dt_from and p_per_sel_dt_to ) then
1988: fnd_message.set_name('PER','HR_289503_SPP_EFF_BR_DATE');
1989: fnd_message.raise_error;
1990: end if;
1991: --
1992: -- 7. If year from is greater than year to, raise error

Line 1989: fnd_message.raise_error;

1985: -- 6. If effective date does not fall between the from and to dates, raise error
1986:
1987: if not ( p_effective_date between p_per_sel_dt_from and p_per_sel_dt_to ) then
1988: fnd_message.set_name('PER','HR_289503_SPP_EFF_BR_DATE');
1989: fnd_message.raise_error;
1990: end if;
1991: --
1992: -- 7. If year from is greater than year to, raise error
1993:

Line 1995: fnd_message.set_name('PER','HR_289504_SPP_BR_YEAR_FROM_TO');

1991: --
1992: -- 7. If year from is greater than year to, raise error
1993:
1994: if p_year_from > p_year_to then
1995: fnd_message.set_name('PER','HR_289504_SPP_BR_YEAR_FROM_TO');
1996: fnd_message.raise_error;
1997: end if;
1998: --
1999: -- end 2940151

Line 1996: fnd_message.raise_error;

1992: -- 7. If year from is greater than year to, raise error
1993:
1994: if p_year_from > p_year_to then
1995: fnd_message.set_name('PER','HR_289504_SPP_BR_YEAR_FROM_TO');
1996: fnd_message.raise_error;
1997: end if;
1998: --
1999: -- end 2940151
2000:

Line 2756: benutils.write(fnd_message.get);

2752: exception
2753: --
2754: --
2755: when table_full then
2756: benutils.write(fnd_message.get);
2757: fnd_message.raise_error;
2758: when index_full then
2759: benutils.write(fnd_message.get);
2760: fnd_message.raise_error;

Line 2757: fnd_message.raise_error;

2753: --
2754: --
2755: when table_full then
2756: benutils.write(fnd_message.get);
2757: fnd_message.raise_error;
2758: when index_full then
2759: benutils.write(fnd_message.get);
2760: fnd_message.raise_error;
2761: --

Line 2759: benutils.write(fnd_message.get);

2755: when table_full then
2756: benutils.write(fnd_message.get);
2757: fnd_message.raise_error;
2758: when index_full then
2759: benutils.write(fnd_message.get);
2760: fnd_message.raise_error;
2761: --
2762: when others then
2763: --

Line 2760: fnd_message.raise_error;

2756: benutils.write(fnd_message.get);
2757: fnd_message.raise_error;
2758: when index_full then
2759: benutils.write(fnd_message.get);
2760: fnd_message.raise_error;
2761: --
2762: when others then
2763: --
2764: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');

Line 2764: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');

2760: fnd_message.raise_error;
2761: --
2762: when others then
2763: --
2764: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
2765: benutils.write(fnd_message.get);
2766: fnd_message.raise_error;
2767: --
2768: end write_logfile;

Line 2765: benutils.write(fnd_message.get);

2761: --
2762: when others then
2763: --
2764: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
2765: benutils.write(fnd_message.get);
2766: fnd_message.raise_error;
2767: --
2768: end write_logfile;
2769: --

Line 2766: fnd_message.raise_error;

2762: when others then
2763: --
2764: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
2765: benutils.write(fnd_message.get);
2766: fnd_message.raise_error;
2767: --
2768: end write_logfile;
2769: --
2770: procedure flush_global_structures is

Line 5969: fnd_message.raise_error;

5965: );
5966: --
5967: if l_slave_errored then
5968: --
5969: fnd_message.raise_error;
5970: --
5971: end if;
5972: --
5973: if g_debug then

Line 5983: benutils.write(p_text => fnd_message.get);

5979: when g_record_error then
5980: if g_debug then
5981: hr_utility.set_location (l_package||' Exception g_record_error ',50);
5982: end if;
5983: benutils.write(p_text => fnd_message.get);
5984: --
5985: -- Write the last bit of information for the thread
5986: --
5987: benutils.write_table_and_file(p_table => true,

Line 6017: g_rec.text := nvl(fnd_message.get,sqlerrm);

6013: if g_debug then
6014: hr_utility.set_location ('BENMNGLE Super Error '||l_package,10);
6015: end if;
6016: g_rec.rep_typ_cd := 'FATAL';
6017: g_rec.text := nvl(fnd_message.get,sqlerrm);
6018: if g_debug then
6019: hr_utility.set_location(substr(g_rec.text,1,100),10);
6020: end if;
6021: benutils.write(p_rec => g_rec);

Line 6041: fnd_message.set_name('BEN','BEN_91665_BENMNGLE_ERRORED');

6037: end if;
6038: --
6039: -- Set generic system error with oracle SQLCODE as the token
6040: --
6041: fnd_message.set_name('BEN','BEN_91665_BENMNGLE_ERRORED');
6042: fnd_message.set_token('ORA_ERRCODE',SQLCODE);
6043: --
6044: benutils.write(p_text => fnd_message.get);
6045: benutils.write_table_and_file(p_table => true,

Line 6042: fnd_message.set_token('ORA_ERRCODE',SQLCODE);

6038: --
6039: -- Set generic system error with oracle SQLCODE as the token
6040: --
6041: fnd_message.set_name('BEN','BEN_91665_BENMNGLE_ERRORED');
6042: fnd_message.set_token('ORA_ERRCODE',SQLCODE);
6043: --
6044: benutils.write(p_text => fnd_message.get);
6045: benutils.write_table_and_file(p_table => true,
6046: p_file => true);

Line 6044: benutils.write(p_text => fnd_message.get);

6040: --
6041: fnd_message.set_name('BEN','BEN_91665_BENMNGLE_ERRORED');
6042: fnd_message.set_token('ORA_ERRCODE',SQLCODE);
6043: --
6044: benutils.write(p_text => fnd_message.get);
6045: benutils.write_table_and_file(p_table => true,
6046: p_file => true);
6047: commit;
6048: if g_debug then

Line 6051: fnd_message.raise_error;

6047: commit;
6048: if g_debug then
6049: hr_utility.set_location ('Others error '||l_package,100);
6050: end if;
6051: fnd_message.raise_error;
6052: --
6053: end do_multithread;
6054: --
6055: procedure restart

Line 6121: fnd_message.set_name('BEN','BEN_91666_BENMNGLE_NO_RESTART');

6117: --
6118: fetch c_parameters into l_parameters;
6119: if c_parameters%notfound then
6120: --
6121: fnd_message.set_name('BEN','BEN_91666_BENMNGLE_NO_RESTART');
6122: fnd_message.raise_error;
6123: --
6124: end if;
6125: --

Line 6122: fnd_message.raise_error;

6118: fetch c_parameters into l_parameters;
6119: if c_parameters%notfound then
6120: --
6121: fnd_message.set_name('BEN','BEN_91666_BENMNGLE_NO_RESTART');
6122: fnd_message.raise_error;
6123: --
6124: end if;
6125: --
6126: close c_parameters;

Line 6288: fnd_message.set_name('BEN','BEN_94272_COMOD_NO_SRS_SUBMIT');

6284: --
6285: Exception
6286: when l_exc_no_parent_req then
6287: -- 4394545
6288: fnd_message.set_name('BEN','BEN_94272_COMOD_NO_SRS_SUBMIT');
6289: l_text := fnd_message.get ;
6290: FND_FILE.PUT_LINE(FND_FILE.LOG, l_text);
6291: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_text) ;
6292: --

Line 6289: l_text := fnd_message.get ;

6285: Exception
6286: when l_exc_no_parent_req then
6287: -- 4394545
6288: fnd_message.set_name('BEN','BEN_94272_COMOD_NO_SRS_SUBMIT');
6289: l_text := fnd_message.get ;
6290: FND_FILE.PUT_LINE(FND_FILE.LOG, l_text);
6291: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_text) ;
6292: --
6293: end cwb_process;

Line 6815: fnd_message.set_name('BEN','BEN_94027_NO_ACT_APL_ASS_FOUND');

6811: fetch c_irec_ass_rec into ben_manage_life_events.g_irec_old_ass_rec; -- irec2
6812: if c_irec_ass_rec%notfound then
6813: --
6814: close c_irec_ass_rec;
6815: fnd_message.set_name('BEN','BEN_94027_NO_ACT_APL_ASS_FOUND');
6816: fnd_message.raise_error;
6817: --
6818: else -- begin irec2
6819: begin

Line 6816: fnd_message.raise_error;

6812: if c_irec_ass_rec%notfound then
6813: --
6814: close c_irec_ass_rec;
6815: fnd_message.set_name('BEN','BEN_94027_NO_ACT_APL_ASS_FOUND');
6816: fnd_message.raise_error;
6817: --
6818: else -- begin irec2
6819: begin
6820: l_old_data_migrator_mode := hr_general.g_data_migrator_mode ;

Line 7660: fnd_message.set_name('BEN','BEN_91668_NO_FIND_POPL_ENRT');

7656: fetch c_popl_enrt_typ_cycl into l_ler_override_id, l_popl_enrt_typ_cycl_id;
7657: if c_popl_enrt_typ_cycl%notfound then
7658: --
7659: close c_popl_enrt_typ_cycl;
7660: fnd_message.set_name('BEN','BEN_91668_NO_FIND_POPL_ENRT');
7661: fnd_message.raise_error;
7662: --
7663: end if;
7664: --

Line 7661: fnd_message.raise_error;

7657: if c_popl_enrt_typ_cycl%notfound then
7658: --
7659: close c_popl_enrt_typ_cycl;
7660: fnd_message.set_name('BEN','BEN_91668_NO_FIND_POPL_ENRT');
7661: fnd_message.raise_error;
7662: --
7663: end if;
7664: --
7665: close c_popl_enrt_typ_cycl;

Line 8019: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');

8015: --
8016: if l_num_ranges = 0 then
8017: --
8018: if nvl(p_mode, 'X') <> 'W' then
8019: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
8020: -- Bug 3870204 : If no persons are selected then, dont error out, but just write the message
8021: -- in Audit Log and finish the process with Status = Normal
8022: -- fnd_message.raise_error;
8023: fnd_message.set_token('PROC' , l_package);

Line 8022: -- fnd_message.raise_error;

8018: if nvl(p_mode, 'X') <> 'W' then
8019: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
8020: -- Bug 3870204 : If no persons are selected then, dont error out, but just write the message
8021: -- in Audit Log and finish the process with Status = Normal
8022: -- fnd_message.raise_error;
8023: fnd_message.set_token('PROC' , l_package);
8024: raise l_no_one_to_process;
8025: end if;
8026: --

Line 8023: fnd_message.set_token('PROC' , l_package);

8019: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
8020: -- Bug 3870204 : If no persons are selected then, dont error out, but just write the message
8021: -- in Audit Log and finish the process with Status = Normal
8022: -- fnd_message.raise_error;
8023: fnd_message.set_token('PROC' , l_package);
8024: raise l_no_one_to_process;
8025: end if;
8026: --
8027: end if;

Line 8192: benutils.write(p_text => fnd_message.get);

8188: --
8189: exception
8190: -- Bug 3870204
8191: when l_no_one_to_process then
8192: benutils.write(p_text => fnd_message.get);
8193: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
8194: rollback;
8195: end internal_process;
8196: --

Line 9113: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

9109: close c_ler_exists;
9110: --
9111: end if;
9112: --
9113: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
9114: --
9115: -- CWB Changes : Added mode
9116: --
9117: if p_mode in ('C', 'L') then

Line 9122: fnd_message.set_token('PROC','ben_evaluate_ptnl_lf_evt');

9118: --
9119: if g_debug then
9120: hr_utility.set_location('Evaluate potential',10);
9121: end if;
9122: fnd_message.set_token('PROC','ben_evaluate_ptnl_lf_evt');
9123: --
9124: if p_validate = 'Y'
9125: then
9126: l_validate := TRUE;

Line 9148: fnd_message.set_token('PROC','ben_evaluate_ptnl_lf_evt');

9144: if g_debug then
9145: hr_utility.set_location('Evaluate iRec Potential LER',10);
9146: end if;
9147: --
9148: fnd_message.set_token('PROC','ben_evaluate_ptnl_lf_evt');
9149: --
9150: ben_evaluate_ptnl_lf_evt.irec_eval_ptnl_per_for_ler
9151: (p_validate => false,
9152: p_person_id => p_person_id,

Line 9170: fnd_message.set_token('PROC','cwb_eval_ptnl_per_for_ler');

9166: --
9167: if g_debug then
9168: hr_utility.set_location('CWB Evaluate potential',10);
9169: end if;
9170: fnd_message.set_token('PROC','cwb_eval_ptnl_per_for_ler');
9171: --
9172: ben_evaluate_ptnl_lf_evt.cwb_eval_ptnl_per_for_ler
9173: (p_validate => false,
9174: p_person_id => p_person_id,

Line 9346: fnd_message.set_name('BEN','BEN_92145_MODE_LE_DIFFER');

9342: l_use_mode := 'Scheduled mode';
9343: else
9344: l_use_mode := 'Life event mode';
9345: end if;
9346: fnd_message.set_name('BEN','BEN_92145_MODE_LE_DIFFER');
9347: fnd_message.set_token('MODE',l_use_mode);
9348: --
9349: -- Bug 2836770
9350: -- Set proper values to global variables before raising error

Line 9347: fnd_message.set_token('MODE',l_use_mode);

9343: else
9344: l_use_mode := 'Life event mode';
9345: end if;
9346: fnd_message.set_name('BEN','BEN_92145_MODE_LE_DIFFER');
9347: fnd_message.set_token('MODE',l_use_mode);
9348: --
9349: -- Bug 2836770
9350: -- Set proper values to global variables before raising error
9351: -- Once value is retrieved from fnd_message.get, the next call

Line 9351: -- Once value is retrieved from fnd_message.get, the next call

9347: fnd_message.set_token('MODE',l_use_mode);
9348: --
9349: -- Bug 2836770
9350: -- Set proper values to global variables before raising error
9351: -- Once value is retrieved from fnd_message.get, the next call
9352: -- return null value. Hence set the values.
9353: --
9354: g_rec.text := fnd_message.get;
9355: g_rec.error_message_code := 'BEN_92145_MODE_LE_DIFFER';

Line 9354: g_rec.text := fnd_message.get;

9350: -- Set proper values to global variables before raising error
9351: -- Once value is retrieved from fnd_message.get, the next call
9352: -- return null value. Hence set the values.
9353: --
9354: g_rec.text := fnd_message.get;
9355: g_rec.error_message_code := 'BEN_92145_MODE_LE_DIFFER';
9356: benutils.write(p_text => g_rec.text );
9357: --
9358: -- Bug 2836770

Line 9364: fnd_message.set_name('BEN','BEN_92145_MODE_LE_DIFFER');

9360: -- Bug : 3658807
9361: -- Set the message name so that correct message is displayed in
9362: -- BENAUTHE.pld (Life Events Evaluation Processing Summary) - Messages
9363: --
9364: fnd_message.set_name('BEN','BEN_92145_MODE_LE_DIFFER');
9365: fnd_message.set_token('MODE',l_use_mode);
9366: raise g_record_error;
9367: --
9368: end if;

Line 9365: fnd_message.set_token('MODE',l_use_mode);

9361: -- Set the message name so that correct message is displayed in
9362: -- BENAUTHE.pld (Life Events Evaluation Processing Summary) - Messages
9363: --
9364: fnd_message.set_name('BEN','BEN_92145_MODE_LE_DIFFER');
9365: fnd_message.set_token('MODE',l_use_mode);
9366: raise g_record_error;
9367: --
9368: end if;
9369: --

Line 9387: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

9383: ben_env_object.setenv(p_lf_evt_ocrd_dt => l_rec.lf_evt_ocrd_dt);
9384: dt_fndate.change_ses_date
9385: (p_ses_date => l_rec.lf_evt_ocrd_dt,
9386: p_commit => l_commit);
9387: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
9388: fnd_message.set_token('PROC','ben_related_person_ler_api');
9389: if g_debug then
9390: hr_utility.set_location (l_package||' create_rel_per_ler ' ,20);
9391: end if;

Line 9388: fnd_message.set_token('PROC','ben_related_person_ler_api');

9384: dt_fndate.change_ses_date
9385: (p_ses_date => l_rec.lf_evt_ocrd_dt,
9386: p_commit => l_commit);
9387: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
9388: fnd_message.set_token('PROC','ben_related_person_ler_api');
9389: if g_debug then
9390: hr_utility.set_location (l_package||' create_rel_per_ler ' ,20);
9391: end if;
9392: --

Line 9625: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

9621: end if;
9622: --
9623: end if;
9624: --
9625: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
9626: fnd_message.set_token('PROC','benutils.get_batch_parameters');
9627: ben_enrolment_requirements.g_electable_choice_created := false;
9628: ben_enrolment_requirements.g_any_choice_created := false;
9629: ben_enrolment_requirements.g_auto_choice_created := false;

Line 9626: fnd_message.set_token('PROC','benutils.get_batch_parameters');

9622: --
9623: end if;
9624: --
9625: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
9626: fnd_message.set_token('PROC','benutils.get_batch_parameters');
9627: ben_enrolment_requirements.g_electable_choice_created := false;
9628: ben_enrolment_requirements.g_any_choice_created := false;
9629: ben_enrolment_requirements.g_auto_choice_created := false;
9630: ben_determine_dpnt_eligibility.g_dpnt_ineligible := false;

Line 10431: fnd_message.set_name('BEN','BEN_94094_PERSON_GRADE_NOT_FND');

10427: if l_gsp_pgm_id is null or
10428: l_gsp_plip_id is null
10429: then
10430: hr_utility.set_location('Current GSP Grade Ladder / Grade / PLIP for person not found', 15);
10431: fnd_message.set_name('BEN','BEN_94094_PERSON_GRADE_NOT_FND');
10432: raise g_record_error;
10433: elsif l_prgr_style not in ('PQH_GSP_GP') and l_gsp_oipl_id is null /* Bug 3964719 */
10434: then
10435: hr_utility.set_location('Current GSP OIPL for person not found', 15);

Line 10436: fnd_message.set_name('BEN','BEN_94095_PERSON_STEP_NOT_FND');

10432: raise g_record_error;
10433: elsif l_prgr_style not in ('PQH_GSP_GP') and l_gsp_oipl_id is null /* Bug 3964719 */
10434: then
10435: hr_utility.set_location('Current GSP OIPL for person not found', 15);
10436: fnd_message.set_name('BEN','BEN_94095_PERSON_STEP_NOT_FND');
10437: raise g_record_error;
10438: end if;
10439: --
10440: open c_ptip_pl_id(l_gsp_pgm_id,l_gsp_plip_id);

Line 10482: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

10478: end if;
10479: --
10480: end if;
10481: --
10482: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
10483: fnd_message.set_token('PROC','BEN_CARRY_FORWARD_ITEMS');
10484: --
10485: -- If the event is staying open, then delete the suspended enrollments
10486: -- and action items

Line 10483: fnd_message.set_token('PROC','BEN_CARRY_FORWARD_ITEMS');

10479: --
10480: end if;
10481: --
10482: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
10483: fnd_message.set_token('PROC','BEN_CARRY_FORWARD_ITEMS');
10484: --
10485: -- If the event is staying open, then delete the suspended enrollments
10486: -- and action items
10487: --

Line 10952: hr_utility.set_location (l_package||' fnd_message_call ',30);

10948: --
10949: if p_derivable_factors <> 'NONE' then
10950: --
10951: if g_debug then
10952: hr_utility.set_location (l_package||' fnd_message_call ',30);
10953: end if;
10954: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
10955: fnd_message.set_token('PROC','ben_derive_part_and_rate_facts');
10956: if g_debug then

Line 10954: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

10950: --
10951: if g_debug then
10952: hr_utility.set_location (l_package||' fnd_message_call ',30);
10953: end if;
10954: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
10955: fnd_message.set_token('PROC','ben_derive_part_and_rate_facts');
10956: if g_debug then
10957: hr_utility.set_location (l_package||' done fnd_message_call ',30);
10958: hr_utility.set_location (l_package||' DRAF ',15);

Line 10955: fnd_message.set_token('PROC','ben_derive_part_and_rate_facts');

10951: if g_debug then
10952: hr_utility.set_location (l_package||' fnd_message_call ',30);
10953: end if;
10954: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
10955: fnd_message.set_token('PROC','ben_derive_part_and_rate_facts');
10956: if g_debug then
10957: hr_utility.set_location (l_package||' done fnd_message_call ',30);
10958: hr_utility.set_location (l_package||' DRAF ',15);
10959: end if;

Line 10957: hr_utility.set_location (l_package||' done fnd_message_call ',30);

10953: end if;
10954: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
10955: fnd_message.set_token('PROC','ben_derive_part_and_rate_facts');
10956: if g_debug then
10957: hr_utility.set_location (l_package||' done fnd_message_call ',30);
10958: hr_utility.set_location (l_package||' DRAF ',15);
10959: end if;
10960: ben_derive_part_and_rate_facts.derive_rates_and_factors
10961: (p_comp_obj_tree_row => l_comp_obj_tree_row

Line 11021: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

11017: --
11018: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071
11019: if l_mode not in ('R','T') then
11020: --
11021: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11022: fnd_message.set_token('PROC','ben_determine_eligibility');
11023: if g_debug then
11024: hr_utility.set_location (l_package||' Dn FND Mess ',80);
11025: end if;

Line 11022: fnd_message.set_token('PROC','ben_determine_eligibility');

11018: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071
11019: if l_mode not in ('R','T') then
11020: --
11021: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11022: fnd_message.set_token('PROC','ben_determine_eligibility');
11023: if g_debug then
11024: hr_utility.set_location (l_package||' Dn FND Mess ',80);
11025: end if;
11026: --

Line 11335: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

11331: --
11332: if g_debug then
11333: hr_utility.set_location (l_package||' FND Bf BENDENRR ',85);
11334: end if;
11335: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11336: fnd_message.set_token('PROC','ben_enrolment_requirements');
11337: --
11338: -- p_mode changed to l_mode in following line by Gopal Venkataraman
11339: -- 3/27/01 bug 1636071

Line 11336: fnd_message.set_token('PROC','ben_enrolment_requirements');

11332: if g_debug then
11333: hr_utility.set_location (l_package||' FND Bf BENDENRR ',85);
11334: end if;
11335: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11336: fnd_message.set_token('PROC','ben_enrolment_requirements');
11337: --
11338: -- p_mode changed to l_mode in following line by Gopal Venkataraman
11339: -- 3/27/01 bug 1636071
11340: --

Line 11391: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

11387: --
11388: ben_epe_cache.g_currcobjepe_row.ler_id := p_ler_id;
11389: ben_epe_cache.g_currcobjepe_row.opt_id := l_comp_obj_tree(l_treeele_num).par_opt_id;
11390: --
11391: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11392: fnd_message.set_token('PROC','ben_determine_dpnt_eligibility');
11393: --
11394: if g_debug then
11395: hr_utility.set_location (l_package||' BDDE_PUEWEID ',110);

Line 11392: fnd_message.set_token('PROC','ben_determine_dpnt_eligibility');

11388: ben_epe_cache.g_currcobjepe_row.ler_id := p_ler_id;
11389: ben_epe_cache.g_currcobjepe_row.opt_id := l_comp_obj_tree(l_treeele_num).par_opt_id;
11390: --
11391: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11392: fnd_message.set_token('PROC','ben_determine_dpnt_eligibility');
11393: --
11394: if g_debug then
11395: hr_utility.set_location (l_package||' BDDE_PUEWEID ',110);
11396: end if;

Line 11415: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

11411: );
11412: --
11413: end if;
11414: --
11415: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11416: fnd_message.set_token('PROC','BEN_DETERMINE_CHC_CTFN');
11417: --
11418: if g_debug then
11419: hr_utility.set_location ('BDCC_MN '||l_package,10);

Line 11416: fnd_message.set_token('PROC','BEN_DETERMINE_CHC_CTFN');

11412: --
11413: end if;
11414: --
11415: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11416: fnd_message.set_token('PROC','BEN_DETERMINE_CHC_CTFN');
11417: --
11418: if g_debug then
11419: hr_utility.set_location ('BDCC_MN '||l_package,10);
11420: end if;

Line 11432: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

11428: if g_debug then
11429: hr_utility.set_location ('Dn BDCC_MN '||l_package,10);
11430: end if;
11431: --
11432: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11433: fnd_message.set_token('PROC','ben_determine_coverage');
11434: --
11435: if g_debug then
11436: hr_utility.set_location (l_package||' ben_determine_coverage.main ',110);

Line 11433: fnd_message.set_token('PROC','ben_determine_coverage');

11429: hr_utility.set_location ('Dn BDCC_MN '||l_package,10);
11430: end if;
11431: --
11432: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11433: fnd_message.set_token('PROC','ben_determine_coverage');
11434: --
11435: if g_debug then
11436: hr_utility.set_location (l_package||' ben_determine_coverage.main ',110);
11437: end if;

Line 11491: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

11487: if g_debug then
11488: hr_utility.set_location (l_package||' FND Bf BENDENRR ',86);
11489: hr_utility.set_location ('l_oipl_id' ||l_oipl_id,87);
11490: end if;
11491: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11492: fnd_message.set_token('PROC','ben_enrolment_requirements');
11493: --
11494: ben_enrolment_requirements.enrolment_requirements
11495: (p_comp_obj_tree_row => l_comp_obj_tree_row

Line 11492: fnd_message.set_token('PROC','ben_enrolment_requirements');

11488: hr_utility.set_location (l_package||' FND Bf BENDENRR ',86);
11489: hr_utility.set_location ('l_oipl_id' ||l_oipl_id,87);
11490: end if;
11491: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11492: fnd_message.set_token('PROC','ben_enrolment_requirements');
11493: --
11494: ben_enrolment_requirements.enrolment_requirements
11495: (p_comp_obj_tree_row => l_comp_obj_tree_row
11496: ,p_run_mode => 'U' --l_mode

Line 11771: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

11767: );
11768: -- 1895846 call
11769: -- to delete the egd records create for the suspended pen or in pending wkflow epe records
11770: --
11771: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11772: fnd_message.set_token('PROC','delete_in_pndg_elig_dpnt');
11773: --
11774: delete_in_pndg_elig_dpnt( l_rec.per_in_ler_id,p_effective_date ) ;
11775: --

Line 11772: fnd_message.set_token('PROC','delete_in_pndg_elig_dpnt');

11768: -- 1895846 call
11769: -- to delete the egd records create for the suspended pen or in pending wkflow epe records
11770: --
11771: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11772: fnd_message.set_token('PROC','delete_in_pndg_elig_dpnt');
11773: --
11774: delete_in_pndg_elig_dpnt( l_rec.per_in_ler_id,p_effective_date ) ;
11775: --
11776: end if;

Line 11777: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

11773: --
11774: delete_in_pndg_elig_dpnt( l_rec.per_in_ler_id,p_effective_date ) ;
11775: --
11776: end if;
11777: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11778: fnd_message.set_token('PROC','ben_determine_elct_chc_flx_imp');
11779: if g_debug then
11780: hr_utility.set_location('lf evt ocrd dt'||l_rec.lf_evt_ocrd_dt,11);
11781: end if;

Line 11778: fnd_message.set_token('PROC','ben_determine_elct_chc_flx_imp');

11774: delete_in_pndg_elig_dpnt( l_rec.per_in_ler_id,p_effective_date ) ;
11775: --
11776: end if;
11777: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11778: fnd_message.set_token('PROC','ben_determine_elct_chc_flx_imp');
11779: if g_debug then
11780: hr_utility.set_location('lf evt ocrd dt'||l_rec.lf_evt_ocrd_dt,11);
11781: end if;
11782: --

Line 11827: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

11823: then
11824: if g_debug then
11825: hr_utility.set_location (l_package||'.ben_determine_actual_premium ',10);
11826: end if;
11827: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11828: fnd_message.set_token('PROC','ben_determine_actual_premium');
11829: --
11830: ben_determine_actual_premium.main
11831: (p_person_id => p_person_id,

Line 11828: fnd_message.set_token('PROC','ben_determine_actual_premium');

11824: if g_debug then
11825: hr_utility.set_location (l_package||'.ben_determine_actual_premium ',10);
11826: end if;
11827: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11828: fnd_message.set_token('PROC','ben_determine_actual_premium');
11829: --
11830: ben_determine_actual_premium.main
11831: (p_person_id => p_person_id,
11832: p_effective_date => p_effective_date,

Line 11846: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

11842: --
11843: if g_debug then
11844: hr_utility.set_location ('FND mess '||l_package,10);
11845: end if;
11846: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11847: fnd_message.set_token('PROC','ben_determine_rates');
11848: --
11849: if g_debug then
11850: hr_utility.set_location ('ben_determine_rates '||l_package,10);

Line 11847: fnd_message.set_token('PROC','ben_determine_rates');

11843: if g_debug then
11844: hr_utility.set_location ('FND mess '||l_package,10);
11845: end if;
11846: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11847: fnd_message.set_token('PROC','ben_determine_rates');
11848: --
11849: if g_debug then
11850: hr_utility.set_location ('ben_determine_rates '||l_package,10);
11851: end if;

Line 11904: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

11900: end if;
11901: if g_debug then
11902: hr_utility.set_location ('ben_determine_rate_chg '||l_package,10);
11903: end if;
11904: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11905: fnd_message.set_token('PROC','ben_determine_rate_chg');
11906: --
11907: -- Turn off distribute rates function caching because cached information
11908: -- is updated in later RCOs. Any further RCOs will hit the DB rather the

Line 11905: fnd_message.set_token('PROC','ben_determine_rate_chg');

11901: if g_debug then
11902: hr_utility.set_location ('ben_determine_rate_chg '||l_package,10);
11903: end if;
11904: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11905: fnd_message.set_token('PROC','ben_determine_rate_chg');
11906: --
11907: -- Turn off distribute rates function caching because cached information
11908: -- is updated in later RCOs. Any further RCOs will hit the DB rather the
11909: -- function cache.

Line 11931: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

11927: end if;
11928: --
11929: end if;
11930: --
11931: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11932: fnd_message.set_token('PROC','reset_elctbl_chc_inpng_flag');
11933: --
11934: -- Reset the in_pndg_wkflow_flag to 'N' for the suspended enrollment cases
11935: --

Line 11932: fnd_message.set_token('PROC','reset_elctbl_chc_inpng_flag');

11928: --
11929: end if;
11930: --
11931: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11932: fnd_message.set_token('PROC','reset_elctbl_chc_inpng_flag');
11933: --
11934: -- Reset the in_pndg_wkflow_flag to 'N' for the suspended enrollment cases
11935: --
11936: reset_elctbl_chc_inpng_flag(l_rec.per_in_ler_id,p_effective_date );

Line 11952: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

11948: p_effective_date => l_rec.lf_evt_ocrd_dt);
11949: --
11950: end if;
11951: --
11952: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11953: fnd_message.set_token('PROC','ben_automatic_enrollments');
11954: --
11955: -- Do the automatic enrollments
11956: --

Line 11953: fnd_message.set_token('PROC','ben_automatic_enrollments');

11949: --
11950: end if;
11951: --
11952: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11953: fnd_message.set_token('PROC','ben_automatic_enrollments');
11954: --
11955: -- Do the automatic enrollments
11956: --
11957: -- CWB Changes.

Line 11981: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

11977: --
11978: --
11979: -- Check for reqired communications
11980: --
11981: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11982: fnd_message.set_token('PROC','ben_generate_communications');
11983: --
11984: if g_debug then
11985: hr_utility.set_location ('Comms '||l_package,10);

Line 11982: fnd_message.set_token('PROC','ben_generate_communications');

11978: --
11979: -- Check for reqired communications
11980: --
11981: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11982: fnd_message.set_token('PROC','ben_generate_communications');
11983: --
11984: if g_debug then
11985: hr_utility.set_location ('Comms '||l_package,10);
11986: end if;

Line 12194: fnd_message.set_name('BEN','BEN_91462_PTIP_MISSING');

12190: open c_get_ptip(l_rslt_rec.ptip_id);
12191: fetch c_get_ptip into l_ptip_rec;
12192: if c_get_ptip%notfound then
12193: close c_get_ptip;
12194: fnd_message.set_name('BEN','BEN_91462_PTIP_MISSING');
12195: fnd_message.set_token('ID', to_char(l_rslt_rec.ptip_id) );
12196: fnd_message.raise_error;
12197: end if;
12198: --

Line 12195: fnd_message.set_token('ID', to_char(l_rslt_rec.ptip_id) );

12191: fetch c_get_ptip into l_ptip_rec;
12192: if c_get_ptip%notfound then
12193: close c_get_ptip;
12194: fnd_message.set_name('BEN','BEN_91462_PTIP_MISSING');
12195: fnd_message.set_token('ID', to_char(l_rslt_rec.ptip_id) );
12196: fnd_message.raise_error;
12197: end if;
12198: --
12199: close c_get_ptip;

Line 12196: fnd_message.raise_error;

12192: if c_get_ptip%notfound then
12193: close c_get_ptip;
12194: fnd_message.set_name('BEN','BEN_91462_PTIP_MISSING');
12195: fnd_message.set_token('ID', to_char(l_rslt_rec.ptip_id) );
12196: fnd_message.raise_error;
12197: end if;
12198: --
12199: close c_get_ptip;
12200: --

Line 12217: fnd_message.set_name('BEN','BEN_91588_PL_ENRD_LT_MN_RQD');

12213: close c_get_ptip_tot_enrd;
12214: hr_utility.set_location (' MN_ENRD_RQD_OVRID_NUM '||l_ptip_rec.MN_ENRD_RQD_OVRID_NUM,10);
12215: if (l_count < l_MN_ENRD_RQD_OVRID_NUM ) then
12216: hr_utility.set_location (' error '||l_count,10);
12217: fnd_message.set_name('BEN','BEN_91588_PL_ENRD_LT_MN_RQD');
12218: fnd_message.set_token('MN_ENRL', to_char(l_MN_ENRD_RQD_OVRID_NUM));
12219: fnd_message.set_token('PL_TYP_NAME', l_ptip_rec.name);
12220: fnd_message.raise_error;
12221: end if;

Line 12218: fnd_message.set_token('MN_ENRL', to_char(l_MN_ENRD_RQD_OVRID_NUM));

12214: hr_utility.set_location (' MN_ENRD_RQD_OVRID_NUM '||l_ptip_rec.MN_ENRD_RQD_OVRID_NUM,10);
12215: if (l_count < l_MN_ENRD_RQD_OVRID_NUM ) then
12216: hr_utility.set_location (' error '||l_count,10);
12217: fnd_message.set_name('BEN','BEN_91588_PL_ENRD_LT_MN_RQD');
12218: fnd_message.set_token('MN_ENRL', to_char(l_MN_ENRD_RQD_OVRID_NUM));
12219: fnd_message.set_token('PL_TYP_NAME', l_ptip_rec.name);
12220: fnd_message.raise_error;
12221: end if;
12222: end if;

Line 12219: fnd_message.set_token('PL_TYP_NAME', l_ptip_rec.name);

12215: if (l_count < l_MN_ENRD_RQD_OVRID_NUM ) then
12216: hr_utility.set_location (' error '||l_count,10);
12217: fnd_message.set_name('BEN','BEN_91588_PL_ENRD_LT_MN_RQD');
12218: fnd_message.set_token('MN_ENRL', to_char(l_MN_ENRD_RQD_OVRID_NUM));
12219: fnd_message.set_token('PL_TYP_NAME', l_ptip_rec.name);
12220: fnd_message.raise_error;
12221: end if;
12222: end if;
12223: end loop;

Line 12220: fnd_message.raise_error;

12216: hr_utility.set_location (' error '||l_count,10);
12217: fnd_message.set_name('BEN','BEN_91588_PL_ENRD_LT_MN_RQD');
12218: fnd_message.set_token('MN_ENRL', to_char(l_MN_ENRD_RQD_OVRID_NUM));
12219: fnd_message.set_token('PL_TYP_NAME', l_ptip_rec.name);
12220: fnd_message.raise_error;
12221: end if;
12222: end if;
12223: end loop;
12224: end if;

Line 12764: l_encoded_message := fnd_message.get_encoded;

12760: g_rec.person_id := p_person_id;
12761: g_rec.pgm_id := l_env.pgm_id;
12762: g_rec.pl_id := l_env.pl_id;
12763: g_rec.oipl_id := l_env.oipl_id;
12764: l_encoded_message := fnd_message.get_encoded;
12765: fnd_message.parse_encoded(encoded_message => l_encoded_message,
12766: app_short_name => l_app_short_name,
12767: message_name => l_message_name);
12768: fnd_message.set_encoded(encoded_message => l_encoded_message);

Line 12765: fnd_message.parse_encoded(encoded_message => l_encoded_message,

12761: g_rec.pgm_id := l_env.pgm_id;
12762: g_rec.pl_id := l_env.pl_id;
12763: g_rec.oipl_id := l_env.oipl_id;
12764: l_encoded_message := fnd_message.get_encoded;
12765: fnd_message.parse_encoded(encoded_message => l_encoded_message,
12766: app_short_name => l_app_short_name,
12767: message_name => l_message_name);
12768: fnd_message.set_encoded(encoded_message => l_encoded_message);
12769:

Line 12768: fnd_message.set_encoded(encoded_message => l_encoded_message);

12764: l_encoded_message := fnd_message.get_encoded;
12765: fnd_message.parse_encoded(encoded_message => l_encoded_message,
12766: app_short_name => l_app_short_name,
12767: message_name => l_message_name);
12768: fnd_message.set_encoded(encoded_message => l_encoded_message);
12769:
12770: g_rec.rep_typ_cd := 'ERROR';
12771: g_rec.national_identifier := l_per_rec.national_identifier;
12772:

Line 12774: -- Added nvl's for l_message_name and fnd_message.get

12770: g_rec.rep_typ_cd := 'ERROR';
12771: g_rec.national_identifier := l_per_rec.national_identifier;
12772:
12773: -- Bug 2836770
12774: -- Added nvl's for l_message_name and fnd_message.get
12775: -- made call to write_table_and_file
12776: --
12777: g_rec.error_message_code := nvl(l_message_name , g_rec.error_message_code);
12778: g_rec.text := nvl(fnd_message.get , g_rec.text );

Line 12778: g_rec.text := nvl(fnd_message.get , g_rec.text );

12774: -- Added nvl's for l_message_name and fnd_message.get
12775: -- made call to write_table_and_file
12776: --
12777: g_rec.error_message_code := nvl(l_message_name , g_rec.error_message_code);
12778: g_rec.text := nvl(fnd_message.get , g_rec.text );
12779: --
12780: --benutils.write(p_text => g_rec.text); /* GSP Rate Sync */
12781: benutils.write(p_rec => g_rec);
12782: --

Line 12799: fnd_message.set_name('BEN','BEN_91662_BENMNGLE_ERROR_LIMIT');

12795: p_error_person_count := p_error_person_count +1;
12796: --
12797: if p_error_person_count = g_max_errors_allowed then
12798: --
12799: fnd_message.set_name('BEN','BEN_91662_BENMNGLE_ERROR_LIMIT');
12800: benutils.write(p_text => fnd_message.get);
12801: if g_debug then
12802: hr_utility.set_location ('PLE g_record_error Err Lim '||l_package,10);
12803: end if;

Line 12800: benutils.write(p_text => fnd_message.get);

12796: --
12797: if p_error_person_count = g_max_errors_allowed then
12798: --
12799: fnd_message.set_name('BEN','BEN_91662_BENMNGLE_ERROR_LIMIT');
12800: benutils.write(p_text => fnd_message.get);
12801: if g_debug then
12802: hr_utility.set_location ('PLE g_record_error Err Lim '||l_package,10);
12803: end if;
12804: --

Line 12878: l_encoded_message := fnd_message.get_encoded;

12874: g_rec.person_id := p_person_id;
12875: g_rec.pgm_id := l_env.pgm_id;
12876: g_rec.pl_id := l_env.pl_id;
12877: g_rec.oipl_id := l_env.oipl_id;
12878: l_encoded_message := fnd_message.get_encoded;
12879: fnd_message.parse_encoded(encoded_message => l_encoded_message,
12880: app_short_name => l_app_short_name,
12881: message_name => l_message_name);
12882: fnd_message.set_encoded(encoded_message => l_encoded_message);

Line 12879: fnd_message.parse_encoded(encoded_message => l_encoded_message,

12875: g_rec.pgm_id := l_env.pgm_id;
12876: g_rec.pl_id := l_env.pl_id;
12877: g_rec.oipl_id := l_env.oipl_id;
12878: l_encoded_message := fnd_message.get_encoded;
12879: fnd_message.parse_encoded(encoded_message => l_encoded_message,
12880: app_short_name => l_app_short_name,
12881: message_name => l_message_name);
12882: fnd_message.set_encoded(encoded_message => l_encoded_message);
12883: g_rec.rep_typ_cd := 'ERROR';

Line 12882: fnd_message.set_encoded(encoded_message => l_encoded_message);

12878: l_encoded_message := fnd_message.get_encoded;
12879: fnd_message.parse_encoded(encoded_message => l_encoded_message,
12880: app_short_name => l_app_short_name,
12881: message_name => l_message_name);
12882: fnd_message.set_encoded(encoded_message => l_encoded_message);
12883: g_rec.rep_typ_cd := 'ERROR';
12884: g_rec.error_message_code := l_message_name;
12885: g_rec.national_identifier := l_per_rec.national_identifier;
12886: g_rec.text := fnd_message.get;

Line 12886: g_rec.text := fnd_message.get;

12882: fnd_message.set_encoded(encoded_message => l_encoded_message);
12883: g_rec.rep_typ_cd := 'ERROR';
12884: g_rec.error_message_code := l_message_name;
12885: g_rec.national_identifier := l_per_rec.national_identifier;
12886: g_rec.text := fnd_message.get;
12887: benutils.write(p_text => g_rec.text);
12888: benutils.write(p_rec => g_rec);
12889: --
12890: g_action_rec.person_action_id := p_person_action_id;

Line 12902: fnd_message.set_name('BEN','BEN_91662_BENMNGLE_ERROR_LIMIT');

12898: p_error_person_count := p_error_person_count +1;
12899: --
12900: if p_error_person_count = g_max_errors_allowed then
12901: --
12902: fnd_message.set_name('BEN','BEN_91662_BENMNGLE_ERROR_LIMIT');
12903: benutils.write(p_text => fnd_message.get);
12904: --
12905: -- Write the last bit of information for the thread before
12906: -- the rollback fires when we raise the error.

Line 12903: benutils.write(p_text => fnd_message.get);

12899: --
12900: if p_error_person_count = g_max_errors_allowed then
12901: --
12902: fnd_message.set_name('BEN','BEN_91662_BENMNGLE_ERROR_LIMIT');
12903: benutils.write(p_text => fnd_message.get);
12904: --
12905: -- Write the last bit of information for the thread before
12906: -- the rollback fires when we raise the error.
12907: --