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.JTF_TASK_RECURRENCES_PVT dependencies on FND_MESSAGE

Line 1640: -- fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1636: --OPEN c_last_update_date;
1637: --FETCH c_last_update_date INTO l_date;
1638: --IF c_last_update_date%NOTFOUND THEN
1639: -- CLOSE c_last_update_date;
1640: -- fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1641: -- fnd_msg_pub.add;
1642: -- RAISE fnd_api.g_exc_unexpected_error;
1643: --ELSE
1644: -- CLOSE c_last_update_date;

Line 1671: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1667: OPEN c_start_date;
1668: FETCH c_start_date INTO l_start_date;
1669: IF c_start_date%NOTFOUND THEN
1670: CLOSE c_start_date;
1671: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1672: fnd_msg_pub.add;
1673: RAISE fnd_api.g_exc_unexpected_error;
1674: ELSE
1675: CLOSE c_start_date;

Line 1695: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1691: OPEN c_end_date;
1692: FETCH c_end_date INTO l_end_date;
1693: IF c_end_date%NOTFOUND THEN
1694: CLOSE c_end_date;
1695: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1696: fnd_msg_pub.add;
1697: RAISE fnd_api.g_exc_unexpected_error;
1698: ELSE
1699: CLOSE c_end_date;

Line 1736: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RECUR_UOM');

1732:
1733: --- the uom should be right.
1734: IF p_occurs_uom IS NULL
1735: THEN
1736: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RECUR_UOM');
1737: fnd_msg_pub.add;
1738: RAISE fnd_api.g_exc_unexpected_error;
1739: END IF;
1740:

Line 1743: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_UOM');

1739: END IF;
1740:
1741: IF p_occurs_uom NOT IN ('DAY', 'WK', 'WEK', 'MTH', 'MON', 'YR', 'YER')
1742: THEN
1743: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_UOM');
1744: fnd_msg_pub.add;
1745: RAISE fnd_api.g_exc_unexpected_error;
1746: END IF;
1747: IF p_start_date_active IS NULL

Line 1749: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_START_DATE');

1745: RAISE fnd_api.g_exc_unexpected_error;
1746: END IF;
1747: IF p_start_date_active IS NULL
1748: THEN
1749: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_START_DATE');
1750: fnd_msg_pub.add;
1751: RAISE fnd_api.g_exc_unexpected_error;
1752: END IF;
1753:

Line 1758: fnd_message.set_name ('JTF', 'JTF_TASK_RECUR_END_DATE_MSG');

1754: --- at least p_occurs_number or end date should be specified
1755: IF ( p_occurs_number <= 0 OR p_occurs_number IS NULL )
1756: AND p_end_date_active IS NULL
1757: THEN
1758: fnd_message.set_name ('JTF', 'JTF_TASK_RECUR_END_DATE_MSG');
1759: fnd_msg_pub.add;
1760: RAISE fnd_api.g_exc_unexpected_error;
1761: END IF;
1762: IF p_occurs_every IS NULL

Line 1764: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_OCCURS_EVERY');

1760: RAISE fnd_api.g_exc_unexpected_error;
1761: END IF;
1762: IF p_occurs_every IS NULL
1763: THEN
1764: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_OCCURS_EVERY');
1765: fnd_msg_pub.add;
1766: RAISE fnd_api.g_exc_unexpected_error;
1767: END IF;
1768: IF p_occurs_every < 0

Line 1770: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OCCURS_EVERY');

1766: RAISE fnd_api.g_exc_unexpected_error;
1767: END IF;
1768: IF p_occurs_every < 0
1769: THEN
1770: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OCCURS_EVERY');
1771: fnd_msg_pub.add;
1772: RAISE fnd_api.g_exc_unexpected_error;
1773: END IF;
1774:

Line 1779: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1775: --- occurs_every should be 1 if uom is year else it should be atleast 1
1776: IF p_occurs_uom IN ('YR')
1777: AND p_occurs_every <> 1
1778: THEN
1779: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1780: fnd_msg_pub.add;
1781: RAISE fnd_api.g_exc_unexpected_error;
1782: ELSE
1783: IF p_occurs_every < 1

Line 1785: fnd_message.set_name ('JTF', 'JTF_TASK_OCCURS_EVERY_<_THAN_1');

1781: RAISE fnd_api.g_exc_unexpected_error;
1782: ELSE
1783: IF p_occurs_every < 1
1784: THEN
1785: fnd_message.set_name ('JTF', 'JTF_TASK_OCCURS_EVERY_<_THAN_1');
1786: fnd_msg_pub.add;
1787: RAISE fnd_api.g_exc_unexpected_error;
1788: END IF;
1789: END IF;

Line 1797: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1793: OR (p_day_of_week IS NOT NULL)
1794: OR (p_date_of_month IS NOT NULL)
1795: OR (p_occurs_month IS NOT NULL)
1796: THEN
1797: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1798: fnd_msg_pub.add;
1799: RAISE fnd_api.g_exc_unexpected_error;
1800: END IF;
1801: END IF;

Line 1810: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1806: OR (p_date_of_month IS NOT NULL)
1807: OR (p_occurs_month IS NOT NULL)
1808: THEN
1809:
1810: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1811: fnd_msg_pub.add;
1812: RAISE fnd_api.g_exc_unexpected_error;
1813: END IF;
1814:

Line 1817: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1813: END IF;
1814:
1815: IF p_day_of_week IS NULL
1816: THEN
1817: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1818: fnd_msg_pub.add;
1819: RAISE fnd_api.g_exc_unexpected_error;
1820: ELSE
1821: IF (p_day_of_week < 1)

Line 1824: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1820: ELSE
1821: IF (p_day_of_week < 1)
1822: OR (p_day_of_week > 7)
1823: THEN
1824: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1825: fnd_msg_pub.add;
1826: RAISE fnd_api.g_exc_unexpected_error;
1827: END IF;
1828: END IF;

Line 1845: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1841: IF ( p_day_of_week < 0
1842: OR p_day_of_week > 9)
1843: THEN
1844:
1845: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1846: fnd_msg_pub.add;
1847: RAISE fnd_api.g_exc_unexpected_error;
1848: END IF;
1849: END IF;

Line 1855: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1851: IF p_occurs_which IS NULL
1852: AND p_date_of_month IS NULL
1853: THEN
1854:
1855: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1856: fnd_msg_pub.add;
1857: RAISE fnd_api.g_exc_unexpected_error;
1858: END IF;
1859:

Line 1867: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1863: IF ( p_date_of_month < 1
1864: OR p_date_of_month > 31)
1865: THEN
1866:
1867: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1868: fnd_msg_pub.add;
1869: RAISE fnd_api.g_exc_unexpected_error;
1870: END IF;
1871:

Line 1875: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1871:
1872: IF p_occurs_month IS NOT NULL
1873: THEN
1874:
1875: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1876: fnd_msg_pub.add;
1877: RAISE fnd_api.g_exc_unexpected_error;
1878: END IF;
1879:

Line 1883: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1879:
1880: IF p_occurs_which IS NOT NULL
1881: THEN
1882:
1883: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1884: fnd_msg_pub.add;
1885: RAISE fnd_api.g_exc_unexpected_error;
1886: END IF;
1887: END IF;

Line 1897: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1893: OR (p_date_of_month IS NOT NULL)
1894: OR (p_occurs_month IS NOT NULL)
1895: THEN
1896:
1897: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1898: fnd_msg_pub.add;
1899: RAISE fnd_api.g_exc_unexpected_error;
1900: END IF;
1901:

Line 1904: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1900: END IF;
1901:
1902: IF week_days_are_null(p_sunday, p_monday, p_tuesday, p_wednesday, p_thursday, p_friday, p_saturday)
1903: THEN
1904: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1905: fnd_msg_pub.add;
1906: RAISE fnd_api.g_exc_unexpected_error;
1907: END IF;
1908: END IF;

Line 1920: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1916: --- here the date of the month should be specified
1917: IF p_date_of_month IS NULL
1918: THEN
1919:
1920: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1921: fnd_msg_pub.add;
1922: RAISE fnd_api.g_exc_unexpected_error;
1923: END IF;
1924:

Line 1929: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1925: IF ( p_date_of_month < 1
1926: OR p_date_of_month > 31)
1927: THEN
1928:
1929: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1930: fnd_msg_pub.add;
1931: RAISE fnd_api.g_exc_unexpected_error;
1932: END IF;
1933:

Line 1937: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1933:
1934: IF p_occurs_month IS NOT NULL
1935: THEN
1936:
1937: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1938: fnd_msg_pub.add;
1939: RAISE fnd_api.g_exc_unexpected_error;
1940: END IF;
1941:

Line 1945: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1941:
1942: IF p_occurs_which IS NOT NULL
1943: THEN
1944:
1945: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1946: fnd_msg_pub.add;
1947: RAISE fnd_api.g_exc_unexpected_error;
1948: END IF;
1949: ELSE

Line 1953: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1949: ELSE
1950: /* IF p_date_of_month IS NOT NULL
1951: THEN
1952:
1953: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1954: fnd_msg_pub.add;
1955: RAISE fnd_api.g_exc_unexpected_error;
1956: END IF;
1957:

Line 1961: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1957:
1958: IF p_occurs_month IS NOT NULL
1959: THEN
1960:
1961: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1962: fnd_msg_pub.add;
1963: RAISE fnd_api.g_exc_unexpected_error;
1964: END IF;
1965: */

Line 1969: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1965: */
1966: IF (p_occurs_which NOT IN (1, 2, 3, 4, 99))
1967: THEN
1968:
1969: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1970: fnd_msg_pub.add;
1971: RAISE fnd_api.g_exc_unexpected_error;
1972: END IF;
1973: END IF;

Line 1987: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1983: THEN
1984: IF p_occurs_month IS NULL
1985: THEN
1986:
1987: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1988: fnd_msg_pub.add;
1989: RAISE fnd_api.g_exc_unexpected_error;
1990: END IF;
1991: IF p_occurs_month < 1

Line 1995: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

1991: IF p_occurs_month < 1
1992: OR p_occurs_month > 12
1993: THEN
1994:
1995: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
1996: fnd_msg_pub.add;
1997: RAISE fnd_api.g_exc_unexpected_error;
1998: END IF;
1999: IF p_date_of_month IS NULL

Line 2004: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

2000: AND ( p_occurs_which IS NULL
2001: OR p_day_of_week IS NULL)
2002: THEN
2003:
2004: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
2005: fnd_msg_pub.add;
2006: RAISE fnd_api.g_exc_unexpected_error;
2007: END IF;
2008: IF p_date_of_month IS NOT NULL

Line 2012: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

2008: IF p_date_of_month IS NOT NULL
2009: AND ( p_occurs_which IS NOT NULL
2010: OR p_day_of_week IS NOT NULL)
2011: THEN
2012: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
2013: fnd_msg_pub.add;
2014: RAISE fnd_api.g_exc_unexpected_error;
2015: END IF;
2016: IF p_date_of_month IS NULL

Line 2020: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

2016: IF p_date_of_month IS NULL
2017: THEN
2018: IF (p_occurs_which IS NULL)
2019: THEN
2020: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
2021: fnd_msg_pub.add;
2022: RAISE fnd_api.g_exc_unexpected_error;
2023: END IF;
2024: IF (p_occurs_which NOT IN (1, 2, 3, 4, 99))

Line 2026: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

2022: RAISE fnd_api.g_exc_unexpected_error;
2023: END IF;
2024: IF (p_occurs_which NOT IN (1, 2, 3, 4, 99))
2025: THEN
2026: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
2027: fnd_msg_pub.add;
2028: RAISE fnd_api.g_exc_unexpected_error;
2029: END IF;
2030: IF p_day_of_week IS NULL

Line 2032: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

2028: RAISE fnd_api.g_exc_unexpected_error;
2029: END IF;
2030: IF p_day_of_week IS NULL
2031: THEN
2032: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
2033: fnd_msg_pub.add;
2034: RAISE fnd_api.g_exc_unexpected_error;
2035: END IF;
2036: IF ( p_day_of_week < 0

Line 2039: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

2035: END IF;
2036: IF ( p_day_of_week < 0
2037: OR p_day_of_week > 9)
2038: THEN
2039: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
2040: fnd_msg_pub.add;
2041: RAISE fnd_api.g_exc_unexpected_error;
2042: END IF;
2043: IF p_date_of_month IS NOT NULL

Line 2045: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

2041: RAISE fnd_api.g_exc_unexpected_error;
2042: END IF;
2043: IF p_date_of_month IS NOT NULL
2044: THEN
2045: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
2046: fnd_msg_pub.add;
2047: RAISE fnd_api.g_exc_unexpected_error;
2048: END IF;
2049: ELSE

Line 2053: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

2049: ELSE
2050: IF ( p_date_of_month < 1
2051: OR p_date_of_month > 31)
2052: THEN
2053: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
2054: fnd_msg_pub.add;
2055: RAISE fnd_api.g_exc_unexpected_error;
2056: END IF;
2057:

Line 2066: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

2062: OR ( p_occurs_month IN (4, 6, 9, 11)
2063: AND p_date_of_month > 30)
2064: THEN
2065:
2066: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
2067: fnd_msg_pub.add;
2068: RAISE fnd_api.g_exc_unexpected_error;
2069: END IF;
2070:

Line 2075: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

2071: IF (p_occurs_which IS NOT NULL)
2072: OR (p_day_of_week IS NOT NULL)
2073: THEN
2074:
2075: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
2076: fnd_msg_pub.add;
2077: RAISE fnd_api.g_exc_unexpected_error;
2078: END IF;
2079: END IF;

Line 2086: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

2082: THEN
2083: IF p_occurs_month IS NULL
2084: THEN
2085:
2086: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
2087: fnd_msg_pub.add;
2088: RAISE fnd_api.g_exc_unexpected_error;
2089: END IF;
2090: IF p_occurs_month < 1

Line 2094: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

2090: IF p_occurs_month < 1
2091: OR p_occurs_month > 12
2092: THEN
2093:
2094: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
2095: fnd_msg_pub.add;
2096: RAISE fnd_api.g_exc_unexpected_error;
2097: END IF;
2098: IF p_date_of_month IS NULL

Line 2103: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

2099: AND (p_occurs_which IS NULL
2100: OR week_days_are_null(p_sunday, p_monday, p_tuesday, p_wednesday, p_thursday, p_friday, p_saturday))
2101: THEN
2102:
2103: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
2104: fnd_msg_pub.add;
2105: RAISE fnd_api.g_exc_unexpected_error;
2106: END IF;
2107: IF p_date_of_month IS NOT NULL

Line 2111: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

2107: IF p_date_of_month IS NOT NULL
2108: AND ( p_occurs_which IS NOT NULL
2109: OR p_day_of_week IS NOT NULL)
2110: THEN
2111: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
2112: fnd_msg_pub.add;
2113: RAISE fnd_api.g_exc_unexpected_error;
2114: END IF;
2115: IF p_date_of_month IS NULL

Line 2119: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

2115: IF p_date_of_month IS NULL
2116: THEN
2117: IF (p_occurs_which IS NULL)
2118: THEN
2119: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
2120: fnd_msg_pub.add;
2121: RAISE fnd_api.g_exc_unexpected_error;
2122: END IF;
2123: IF (p_occurs_which NOT IN (1, 2, 3, 4, 99))

Line 2125: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

2121: RAISE fnd_api.g_exc_unexpected_error;
2122: END IF;
2123: IF (p_occurs_which NOT IN (1, 2, 3, 4, 99))
2124: THEN
2125: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
2126: fnd_msg_pub.add;
2127: RAISE fnd_api.g_exc_unexpected_error;
2128: END IF;
2129: IF week_days_are_null(p_sunday, p_monday, p_tuesday, p_wednesday, p_thursday, p_friday, p_saturday)

Line 2131: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

2127: RAISE fnd_api.g_exc_unexpected_error;
2128: END IF;
2129: IF week_days_are_null(p_sunday, p_monday, p_tuesday, p_wednesday, p_thursday, p_friday, p_saturday)
2130: THEN
2131: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
2132: fnd_msg_pub.add;
2133: RAISE fnd_api.g_exc_unexpected_error;
2134: END IF;
2135: IF p_date_of_month IS NOT NULL

Line 2137: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

2133: RAISE fnd_api.g_exc_unexpected_error;
2134: END IF;
2135: IF p_date_of_month IS NOT NULL
2136: THEN
2137: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
2138: fnd_msg_pub.add;
2139: RAISE fnd_api.g_exc_unexpected_error;
2140: END IF;
2141: ELSE

Line 2145: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

2141: ELSE
2142: IF ( p_date_of_month < 1
2143: OR p_date_of_month > 31)
2144: THEN
2145: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
2146: fnd_msg_pub.add;
2147: RAISE fnd_api.g_exc_unexpected_error;
2148: END IF;
2149:

Line 2158: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

2154: OR ( p_occurs_month IN (4, 6, 9, 11)
2155: AND p_date_of_month > 30)
2156: THEN
2157:
2158: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
2159: fnd_msg_pub.add;
2160: RAISE fnd_api.g_exc_unexpected_error;
2161: END IF;
2162:

Line 2167: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');

2163: IF (p_occurs_which IS NOT NULL)
2164: OR (p_day_of_week IS NOT NULL)
2165: THEN
2166:
2167: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
2168: fnd_msg_pub.add;
2169: RAISE fnd_api.g_exc_unexpected_error;
2170: END IF;
2171: END IF;

Line 2181: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

2177: x_return_status := fnd_api.g_ret_sts_unexp_error;
2178: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2179: WHEN OTHERS
2180: THEN
2181: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2182: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
2183: x_return_status := fnd_api.g_ret_sts_unexp_error;
2184: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2185: END;

Line 2182: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

2178: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2179: WHEN OTHERS
2180: THEN
2181: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2182: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
2183: x_return_status := fnd_api.g_ret_sts_unexp_error;
2184: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2185: END;
2186:

Line 2350: fnd_message.set_name ('JTF', 'JTF_TASK_RECURS_TEMP_ALREADY');

2346: IF l_recur_id IS NOT NULL
2347: THEN
2348:
2349: x_return_status := fnd_api.g_ret_sts_error;
2350: fnd_message.set_name ('JTF', 'JTF_TASK_RECURS_TEMP_ALREADY');
2351: fnd_msg_pub.add;
2352: RAISE fnd_api.g_exc_unexpected_error;
2353: END IF;
2354: ELSE

Line 2362: fnd_message.set_name ('JTF', 'JTF_TASK_RECURS_TASK_ALREADY');

2358: WHERE task_id = l_task_id;
2359: IF l_recur_id IS NOT NULL
2360: THEN
2361: x_return_status := fnd_api.g_ret_sts_error;
2362: fnd_message.set_name ('JTF', 'JTF_TASK_RECURS_TASK_ALREADY');
2363: fnd_msg_pub.add;
2364: RAISE fnd_api.g_exc_unexpected_error;
2365: END IF;
2366: END IF;

Line 2492: fnd_message.set_name ('JTF', 'ERROR_INSERTING_RECURRENCE');

2488: IF c_jtf_task_recur%NOTFOUND
2489: THEN
2490:
2491: x_return_status := fnd_api.g_ret_sts_unexp_error;
2492: fnd_message.set_name ('JTF', 'ERROR_INSERTING_RECURRENCE');
2493: fnd_msg_pub.add;
2494: RAISE fnd_api.g_exc_unexpected_error;
2495: ELSE
2496: x_recurrence_rule_id := l_recur_id;

Line 2512: fnd_message.set_name ('JTF', 'ERROR_UPDATING_TASK');

2508: END IF;
2509: IF SQL%NOTFOUND
2510: THEN
2511: x_return_status := fnd_api.g_ret_sts_unexp_error;
2512: fnd_message.set_name ('JTF', 'ERROR_UPDATING_TASK');
2513: fnd_msg_pub.add;
2514: RAISE fnd_api.g_exc_unexpected_error;
2515: END IF;
2516: END IF;

Line 2524: fnd_message.set_name('JTF','JTF_TASK_INVALID_TASK_ID');

2520: FETCH c_task_details into l_task_details;
2521: IF c_task_details%NOTFOUND
2522: THEN
2523: CLOSE c_task_details;
2524: fnd_message.set_name('JTF','JTF_TASK_INVALID_TASK_ID');
2525: fnd_message.set_token('P_TASK_ID', p_task_id);
2526: fnd_msg_pub.add;
2527: RAISE fnd_api.g_exc_unexpected_error;
2528: END IF;

Line 2525: fnd_message.set_token('P_TASK_ID', p_task_id);

2521: IF c_task_details%NOTFOUND
2522: THEN
2523: CLOSE c_task_details;
2524: fnd_message.set_name('JTF','JTF_TASK_INVALID_TASK_ID');
2525: fnd_message.set_token('P_TASK_ID', p_task_id);
2526: fnd_msg_pub.add;
2527: RAISE fnd_api.g_exc_unexpected_error;
2528: END IF;
2529:

Line 3178: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

3174: WHEN OTHERS
3175: THEN
3176: jtf_task_recurrences_pub.creating_recurrences := FALSE;
3177: ROLLBACK TO create_task_recur_pvt;
3178: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
3179: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
3180: fnd_msg_pub.add;
3181: x_return_status := fnd_api.g_ret_sts_unexp_error;
3182: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 3179: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

3175: THEN
3176: jtf_task_recurrences_pub.creating_recurrences := FALSE;
3177: ROLLBACK TO create_task_recur_pvt;
3178: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
3179: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
3180: fnd_msg_pub.add;
3181: x_return_status := fnd_api.g_ret_sts_unexp_error;
3182: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3183: END;

Line 3298: fnd_message.set_name('JTF','JTF_TASK_INVALID_TASK_ID');

3294:
3295: IF c_new_start_date%NOTFOUND
3296: THEN
3297: CLOSE c_new_start_date;
3298: fnd_message.set_name('JTF','JTF_TASK_INVALID_TASK_ID');
3299: fnd_message.set_token('P_TASK_ID', p_task_id);
3300: fnd_msg_pub.add;
3301: x_return_status := fnd_api.g_ret_sts_unexp_error;
3302: RAISE fnd_api.g_exc_unexpected_error;

Line 3299: fnd_message.set_token('P_TASK_ID', p_task_id);

3295: IF c_new_start_date%NOTFOUND
3296: THEN
3297: CLOSE c_new_start_date;
3298: fnd_message.set_name('JTF','JTF_TASK_INVALID_TASK_ID');
3299: fnd_message.set_token('P_TASK_ID', p_task_id);
3300: fnd_msg_pub.add;
3301: x_return_status := fnd_api.g_ret_sts_unexp_error;
3302: RAISE fnd_api.g_exc_unexpected_error;
3303: END IF;

Line 3405: fnd_message.set_name('JTF','JTF_TASK_INVALID_TASK_ID');

3401: FETCH c_task INTO rec_task;
3402: IF c_task%NOTFOUND
3403: THEN
3404: CLOSE c_task;
3405: fnd_message.set_name('JTF','JTF_TASK_INVALID_TASK_ID');
3406: fnd_message.set_token('P_TASK_ID', p_task_id);
3407: fnd_msg_pub.add;
3408: x_return_status := fnd_api.g_ret_sts_unexp_error;
3409: RAISE fnd_api.g_exc_unexpected_error;

Line 3406: fnd_message.set_token('P_TASK_ID', p_task_id);

3402: IF c_task%NOTFOUND
3403: THEN
3404: CLOSE c_task;
3405: fnd_message.set_name('JTF','JTF_TASK_INVALID_TASK_ID');
3406: fnd_message.set_token('P_TASK_ID', p_task_id);
3407: fnd_msg_pub.add;
3408: x_return_status := fnd_api.g_ret_sts_unexp_error;
3409: RAISE fnd_api.g_exc_unexpected_error;
3410: END IF;

Line 3498: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

3494: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3495: WHEN OTHERS
3496: THEN
3497: ROLLBACK TO update_task_recurrence_pvt;
3498: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
3499: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
3500: fnd_msg_pub.add;
3501: x_return_status := fnd_api.g_ret_sts_unexp_error;
3502: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 3499: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

3495: WHEN OTHERS
3496: THEN
3497: ROLLBACK TO update_task_recurrence_pvt;
3498: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
3499: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
3500: fnd_msg_pub.add;
3501: x_return_status := fnd_api.g_ret_sts_unexp_error;
3502: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3503: END update_task_recurrence;