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_MSG_PUB

Line 1641: -- fnd_msg_pub.add;

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;
1645: -- UPDATE jtf_tasks_b

Line 1672: fnd_msg_pub.add;

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;
1676: x_repeat_start_date := l_start_date;

Line 1696: fnd_msg_pub.add;

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;
1700: x_repeat_end_date := l_end_date;

Line 1737: fnd_msg_pub.add;

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:
1741: IF p_occurs_uom NOT IN ('DAY', 'WK', 'WEK', 'MTH', 'MON', 'YR', 'YER')

Line 1744: fnd_msg_pub.add;

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

Line 1750: fnd_msg_pub.add;

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:
1754: --- at least p_occurs_number or end date should be specified

Line 1759: fnd_msg_pub.add;

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

Line 1765: fnd_msg_pub.add;

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

Line 1771: fnd_msg_pub.add;

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:
1775: --- occurs_every should be 1 if uom is year else it should be atleast 1

Line 1780: fnd_msg_pub.add;

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

Line 1786: fnd_msg_pub.add;

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;
1790: IF p_occurs_uom = 'DAY'

Line 1798: fnd_msg_pub.add;

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

Line 1811: fnd_msg_pub.add;

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:
1815: IF p_day_of_week IS NULL

Line 1818: fnd_msg_pub.add;

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)
1822: OR (p_day_of_week > 7)

Line 1825: fnd_msg_pub.add;

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

Line 1846: fnd_msg_pub.add;

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

Line 1856: fnd_msg_pub.add;

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:
1860: IF (p_date_of_month IS NOT NULL)

Line 1868: fnd_msg_pub.add;

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:
1872: IF p_occurs_month IS NOT NULL

Line 1876: fnd_msg_pub.add;

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:
1880: IF p_occurs_which IS NOT NULL

Line 1884: fnd_msg_pub.add;

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;
1888: END IF;

Line 1898: fnd_msg_pub.add;

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:
1902: IF week_days_are_null(p_sunday, p_monday, p_tuesday, p_wednesday, p_thursday, p_friday, p_saturday)

Line 1905: fnd_msg_pub.add;

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

Line 1921: fnd_msg_pub.add;

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:
1925: IF ( p_date_of_month < 1

Line 1930: fnd_msg_pub.add;

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:
1934: IF p_occurs_month IS NOT NULL

Line 1938: fnd_msg_pub.add;

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:
1942: IF p_occurs_which IS NOT NULL

Line 1946: fnd_msg_pub.add;

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
1950: /* IF p_date_of_month IS NOT NULL

Line 1954: fnd_msg_pub.add;

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:
1958: IF p_occurs_month IS NOT NULL

Line 1962: fnd_msg_pub.add;

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: */
1966: IF (p_occurs_which NOT IN (1, 2, 3, 4, 99))

Line 1970: fnd_msg_pub.add;

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;
1974: END IF;

Line 1988: fnd_msg_pub.add;

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
1992: OR p_occurs_month > 12

Line 1996: fnd_msg_pub.add;

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
2000: AND ( p_occurs_which IS NULL

Line 2005: fnd_msg_pub.add;

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
2009: AND ( p_occurs_which IS NOT NULL

Line 2013: fnd_msg_pub.add;

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

Line 2021: fnd_msg_pub.add;

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))
2025: THEN

Line 2027: fnd_msg_pub.add;

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

Line 2033: fnd_msg_pub.add;

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
2037: OR p_day_of_week > 9)

Line 2040: fnd_msg_pub.add;

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

Line 2046: fnd_msg_pub.add;

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
2050: IF ( p_date_of_month < 1

Line 2054: fnd_msg_pub.add;

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:
2058: IF ( p_occurs_month = 2

Line 2067: fnd_msg_pub.add;

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:
2071: IF (p_occurs_which IS NOT NULL)

Line 2076: fnd_msg_pub.add;

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;
2080: END IF;

Line 2087: fnd_msg_pub.add;

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
2091: OR p_occurs_month > 12

Line 2095: fnd_msg_pub.add;

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
2099: AND (p_occurs_which IS NULL

Line 2104: fnd_msg_pub.add;

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
2108: AND ( p_occurs_which IS NOT NULL

Line 2112: fnd_msg_pub.add;

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

Line 2120: fnd_msg_pub.add;

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))
2124: THEN

Line 2126: fnd_msg_pub.add;

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)
2130: THEN

Line 2132: fnd_msg_pub.add;

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

Line 2138: fnd_msg_pub.add;

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
2142: IF ( p_date_of_month < 1

Line 2146: fnd_msg_pub.add;

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:
2150: IF (p_occurs_month = 2

Line 2159: fnd_msg_pub.add;

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:
2163: IF (p_occurs_which IS NOT NULL)

Line 2168: fnd_msg_pub.add;

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;
2172: END IF;

Line 2178: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2174: EXCEPTION
2175: WHEN fnd_api.g_exc_unexpected_error
2176: THEN
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);

Line 2184: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

Line 2332: fnd_msg_pub.initialize;

2328: END IF;
2329:
2330: IF fnd_api.to_boolean (p_init_msg_list)
2331: THEN
2332: fnd_msg_pub.initialize;
2333: END IF;
2334:
2335: --- check if the given task id has already the recur
2336: --- checking if the task already has a recurrence

Line 2351: fnd_msg_pub.add;

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
2355: SELECT recurrence_rule_id

Line 2363: fnd_msg_pub.add;

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

Line 2493: fnd_msg_pub.add;

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

Line 2513: fnd_msg_pub.add;

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

Line 2526: fnd_msg_pub.add;

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:
2530: --- if it a template do nothing

Line 3163: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

3159: END IF;
3160:
3161: set_last_update_date(l_recur_id);
3162:
3163: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3164:
3165: EXCEPTION
3166: WHEN fnd_api.g_exc_unexpected_error
3167: THEN

Line 3173: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

3169:
3170:
3171: ROLLBACK TO create_task_recur_pvt;
3172: x_return_status := fnd_api.g_ret_sts_unexp_error;
3173: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3174: WHEN OTHERS
3175: THEN
3176: jtf_task_recurrences_pub.creating_recurrences := FALSE;
3177: ROLLBACK TO create_task_recur_pvt;

Line 3180: fnd_msg_pub.add;

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

Line 3182: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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;
3184:
3185: -- To fix bug 2721278
3186: FUNCTION is_repeat_start_date_changed (p_recurrence_rule_id IN NUMBER

Line 3289: fnd_msg_pub.initialize;

3285: x_return_status := fnd_api.g_ret_sts_success;
3286:
3287: IF fnd_api.to_boolean (p_init_msg_list)
3288: THEN
3289: fnd_msg_pub.initialize;
3290: END IF;
3291:
3292: OPEN c_new_start_date (p_task_id);
3293: FETCH c_new_start_date INTO rec_new_start_date;

Line 3300: fnd_msg_pub.add;

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;
3304: CLOSE c_new_start_date;

Line 3407: fnd_msg_pub.add;

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;
3411: CLOSE c_task;

Line 3488: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

3484: THEN
3485: COMMIT WORK;
3486: END IF;
3487:
3488: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3489: EXCEPTION
3490: WHEN fnd_api.g_exc_unexpected_error
3491: THEN
3492: ROLLBACK TO update_task_recurrence_pvt;

Line 3494: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

3490: WHEN fnd_api.g_exc_unexpected_error
3491: THEN
3492: ROLLBACK TO update_task_recurrence_pvt;
3493: x_return_status := fnd_api.g_ret_sts_unexp_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');

Line 3500: fnd_msg_pub.add;

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

Line 3502: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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;
3504:
3505: END; --CREATE OR REPLACE PACKAGE