[Home] [Help]
613: , x_msg_count => l_msg_count
614: , x_msg_data => l_msg_data
615: );
616:
617: IF ( l_status <> FND_API.G_RET_STS_SUCCESS )
618: THEN
619: RAISE fnd_api.G_EXC_ERROR;
620: END IF;
621:
615: );
616:
617: IF ( l_status <> FND_API.G_RET_STS_SUCCESS )
618: THEN
619: RAISE fnd_api.G_EXC_ERROR;
620: END IF;
621:
622: IF ( l_gmt_deviation <> l_server_offset)
623: THEN
638: , x_msg_count => l_msg_count
639: , x_msg_data => l_msg_data
640: );
641:
642: IF ( l_status <> FND_API.G_RET_STS_SUCCESS )
643: THEN
644: RAISE fnd_api.G_EXC_ERROR;
645: END IF;
646:
640: );
641:
642: IF ( l_status <> FND_API.G_RET_STS_SUCCESS )
643: THEN
644: RAISE fnd_api.G_EXC_ERROR;
645: END IF;
646:
647: IF ( l_gmt_deviation <> l_server_offset)
648: THEN
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
1646: -- SET last_update_date = NVL(l_date, SYSDATE) -- Fix bug 2376554
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;
1677: END IF;
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;
1701: END IF;
1727: p_saturday IN VARCHAR2 DEFAULT jtf_task_utl.g_no_char
1728: )
1729: IS
1730: BEGIN
1731: x_return_status := fnd_api.g_ret_sts_success;
1732:
1733: --- the uom should be right.
1734: IF p_occurs_uom IS NULL
1735: THEN
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')
1742: THEN
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
1749: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_START_DATE');
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
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
1764: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_OCCURS_EVERY');
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
1770: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OCCURS_EVERY');
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
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
1785: fnd_message.set_name ('JTF', 'JTF_TASK_OCCURS_EVERY_<_THAN_1');
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'
1791: THEN
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:
1803: IF p_occurs_uom = 'WK'
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
1816: THEN
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)
1823: THEN
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:
1830:
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:
1851: IF p_occurs_which 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)
1861: THEN
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
1873: THEN
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
1881: THEN
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;
1889:
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)
1903: THEN
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:
1910: IF p_occurs_uom = 'MON'
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
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
1935: THEN
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
1943: THEN
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
1951: THEN
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
1959: THEN
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))
1967: THEN
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;
1975:
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
1993: THEN
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
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
2010: OR p_day_of_week 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
2018: IF (p_occurs_which IS NULL)
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
2026: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
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
2032: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
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)
2038: THEN
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
2045: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
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
2051: OR p_date_of_month > 31)
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
2059: AND p_date_of_month > 29)
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)
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;
2081: IF p_occurs_uom = 'YER'
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
2092: THEN
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
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
2109: OR p_day_of_week 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
2117: IF (p_occurs_which IS NULL)
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
2125: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
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
2131: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
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
2137: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_RECUR_RULE');
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
2143: OR p_date_of_month > 31)
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
2151: AND p_date_of_month > 29)
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)
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;
2173:
2171: END IF;
2172: END IF;
2173:
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
2173:
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');
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:
2187: -----------------------------------------------------------------------------------------------------------
2189: -----------------------------------------------------------------------------------------------------------
2190: -----------------------------------------------------------------------------------------------------------
2191: PROCEDURE create_task_recurrence (
2192: p_api_version IN NUMBER,
2193: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2194: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2195: p_task_id IN NUMBER,
2196: p_occurs_which IN INTEGER DEFAULT NULL,
2197: p_day_of_week IN INTEGER DEFAULT NULL,
2190: -----------------------------------------------------------------------------------------------------------
2191: PROCEDURE create_task_recurrence (
2192: p_api_version IN NUMBER,
2193: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2194: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2195: p_task_id IN NUMBER,
2196: p_occurs_which IN INTEGER DEFAULT NULL,
2197: p_day_of_week IN INTEGER DEFAULT NULL,
2198: p_date_of_month IN INTEGER DEFAULT NULL,
2325:
2326: jtf_task_recurrences_pub.creating_recurrences := TRUE;
2327:
2328: SAVEPOINT create_task_recur_pvt;
2329: x_return_status := fnd_api.g_ret_sts_success;
2330:
2331: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2332: THEN
2333: RAISE fnd_api.g_exc_unexpected_error;
2327:
2328: SAVEPOINT create_task_recur_pvt;
2329: x_return_status := fnd_api.g_ret_sts_success;
2330:
2331: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2332: THEN
2333: RAISE fnd_api.g_exc_unexpected_error;
2334: END IF;
2335:
2329: x_return_status := fnd_api.g_ret_sts_success;
2330:
2331: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2332: THEN
2333: RAISE fnd_api.g_exc_unexpected_error;
2334: END IF;
2335:
2336: IF fnd_api.to_boolean (p_init_msg_list)
2337: THEN
2332: THEN
2333: RAISE fnd_api.g_exc_unexpected_error;
2334: END IF;
2335:
2336: IF fnd_api.to_boolean (p_init_msg_list)
2337: THEN
2338: fnd_msg_pub.initialize;
2339: END IF;
2340:
2351:
2352: IF l_recur_id IS NOT NULL
2353: THEN
2354:
2355: x_return_status := fnd_api.g_ret_sts_error;
2356: fnd_message.set_name ('JTF', 'JTF_TASK_RECURS_TEMP_ALREADY');
2357: fnd_msg_pub.add;
2358: RAISE fnd_api.g_exc_unexpected_error;
2359: END IF;
2354:
2355: x_return_status := fnd_api.g_ret_sts_error;
2356: fnd_message.set_name ('JTF', 'JTF_TASK_RECURS_TEMP_ALREADY');
2357: fnd_msg_pub.add;
2358: RAISE fnd_api.g_exc_unexpected_error;
2359: END IF;
2360: ELSE
2361: SELECT recurrence_rule_id
2362: INTO l_recur_id
2363: FROM jtf_tasks_b
2364: WHERE task_id = l_task_id;
2365: IF l_recur_id IS NOT NULL
2366: THEN
2367: x_return_status := fnd_api.g_ret_sts_error;
2368: fnd_message.set_name ('JTF', 'JTF_TASK_RECURS_TASK_ALREADY');
2369: fnd_msg_pub.add;
2370: RAISE fnd_api.g_exc_unexpected_error;
2371: END IF;
2366: THEN
2367: x_return_status := fnd_api.g_ret_sts_error;
2368: fnd_message.set_name ('JTF', 'JTF_TASK_RECURS_TASK_ALREADY');
2369: fnd_msg_pub.add;
2370: RAISE fnd_api.g_exc_unexpected_error;
2371: END IF;
2372: END IF;
2373:
2374: jtf_task_recurrences_pvt.validate_task_recurrence (
2392: p_friday => p_friday,
2393: p_saturday => p_saturday
2394: );
2395:
2396: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2397: THEN
2398:
2399: x_return_status := fnd_api.g_ret_sts_unexp_error;
2400: RAISE fnd_api.g_exc_unexpected_error;
2395:
2396: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2397: THEN
2398:
2399: x_return_status := fnd_api.g_ret_sts_unexp_error;
2400: RAISE fnd_api.g_exc_unexpected_error;
2401: END IF;
2402: --- Call the procedure to generate the dates
2403: IF not jtf_task_utl.to_boolean (p_template_flag)
2396: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2397: THEN
2398:
2399: x_return_status := fnd_api.g_ret_sts_unexp_error;
2400: RAISE fnd_api.g_exc_unexpected_error;
2401: END IF;
2402: --- Call the procedure to generate the dates
2403: IF not jtf_task_utl.to_boolean (p_template_flag)
2404: THEN
2493:
2494: IF c_jtf_task_recur%NOTFOUND
2495: THEN
2496:
2497: x_return_status := fnd_api.g_ret_sts_unexp_error;
2498: fnd_message.set_name ('JTF', 'ERROR_INSERTING_RECURRENCE');
2499: fnd_msg_pub.add;
2500: RAISE fnd_api.g_exc_unexpected_error;
2501: ELSE
2496:
2497: x_return_status := fnd_api.g_ret_sts_unexp_error;
2498: fnd_message.set_name ('JTF', 'ERROR_INSERTING_RECURRENCE');
2499: fnd_msg_pub.add;
2500: RAISE fnd_api.g_exc_unexpected_error;
2501: ELSE
2502: x_recurrence_rule_id := l_recur_id;
2503:
2504: IF jtf_task_utl.to_boolean(p_template_flag)
2513:
2514: END IF;
2515: IF SQL%NOTFOUND
2516: THEN
2517: x_return_status := fnd_api.g_ret_sts_unexp_error;
2518: fnd_message.set_name ('JTF', 'ERROR_UPDATING_TASK');
2519: fnd_msg_pub.add;
2520: RAISE fnd_api.g_exc_unexpected_error;
2521: END IF;
2516: THEN
2517: x_return_status := fnd_api.g_ret_sts_unexp_error;
2518: fnd_message.set_name ('JTF', 'ERROR_UPDATING_TASK');
2519: fnd_msg_pub.add;
2520: RAISE fnd_api.g_exc_unexpected_error;
2521: END IF;
2522: END IF;
2523:
2524:
2529: CLOSE c_task_details;
2530: fnd_message.set_name('JTF','JTF_TASK_INVALID_TASK_ID');
2531: fnd_message.set_token('P_TASK_ID', p_task_id);
2532: fnd_msg_pub.add;
2533: RAISE fnd_api.g_exc_unexpected_error;
2534: END IF;
2535:
2536: --- if it a template do nothing
2537: --- else call copy tasks to create the tasks.
3011: , x_calendar_start_date => l_calendar_start_date
3012: , x_calendar_end_date => l_calendar_end_date
3013: , x_return_status => x_return_status);
3014:
3015: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
3016: THEN
3017: RAISE fnd_api.g_exc_unexpected_error;
3018: END IF;
3019: l_valid := TRUE;
3013: , x_return_status => x_return_status);
3014:
3015: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
3016: THEN
3017: RAISE fnd_api.g_exc_unexpected_error;
3018: END IF;
3019: l_valid := TRUE;
3020: END IF;
3021:
3029: IF i <> 1
3030: THEN
3031: jtf_tasks_pub.copy_task (
3032: p_api_version => 1.0,
3033: p_init_msg_list => fnd_api.g_false,
3034: p_commit => p_commit,
3035: p_source_task_id => l_task_id,
3036: p_copy_task_assignments => fnd_api.g_true,
3037: p_copy_task_rsc_reqs => fnd_api.g_true,
3032: p_api_version => 1.0,
3033: p_init_msg_list => fnd_api.g_false,
3034: p_commit => p_commit,
3035: p_source_task_id => l_task_id,
3036: p_copy_task_assignments => fnd_api.g_true,
3037: p_copy_task_rsc_reqs => fnd_api.g_true,
3038: p_copy_task_depends => fnd_api.g_true,
3039: p_create_recurrences => fnd_api.g_false,
3040: p_copy_task_references => fnd_api.g_true,
3033: p_init_msg_list => fnd_api.g_false,
3034: p_commit => p_commit,
3035: p_source_task_id => l_task_id,
3036: p_copy_task_assignments => fnd_api.g_true,
3037: p_copy_task_rsc_reqs => fnd_api.g_true,
3038: p_copy_task_depends => fnd_api.g_true,
3039: p_create_recurrences => fnd_api.g_false,
3040: p_copy_task_references => fnd_api.g_true,
3041: p_copy_task_dates => fnd_api.g_true,
3034: p_commit => p_commit,
3035: p_source_task_id => l_task_id,
3036: p_copy_task_assignments => fnd_api.g_true,
3037: p_copy_task_rsc_reqs => fnd_api.g_true,
3038: p_copy_task_depends => fnd_api.g_true,
3039: p_create_recurrences => fnd_api.g_false,
3040: p_copy_task_references => fnd_api.g_true,
3041: p_copy_task_dates => fnd_api.g_true,
3042: p_copy_task_contacts => fnd_api.g_true,
3035: p_source_task_id => l_task_id,
3036: p_copy_task_assignments => fnd_api.g_true,
3037: p_copy_task_rsc_reqs => fnd_api.g_true,
3038: p_copy_task_depends => fnd_api.g_true,
3039: p_create_recurrences => fnd_api.g_false,
3040: p_copy_task_references => fnd_api.g_true,
3041: p_copy_task_dates => fnd_api.g_true,
3042: p_copy_task_contacts => fnd_api.g_true,
3043: p_copy_task_contact_points => fnd_api.g_true,
3036: p_copy_task_assignments => fnd_api.g_true,
3037: p_copy_task_rsc_reqs => fnd_api.g_true,
3038: p_copy_task_depends => fnd_api.g_true,
3039: p_create_recurrences => fnd_api.g_false,
3040: p_copy_task_references => fnd_api.g_true,
3041: p_copy_task_dates => fnd_api.g_true,
3042: p_copy_task_contacts => fnd_api.g_true,
3043: p_copy_task_contact_points => fnd_api.g_true,
3044: x_return_status => x_return_status,
3037: p_copy_task_rsc_reqs => fnd_api.g_true,
3038: p_copy_task_depends => fnd_api.g_true,
3039: p_create_recurrences => fnd_api.g_false,
3040: p_copy_task_references => fnd_api.g_true,
3041: p_copy_task_dates => fnd_api.g_true,
3042: p_copy_task_contacts => fnd_api.g_true,
3043: p_copy_task_contact_points => fnd_api.g_true,
3044: x_return_status => x_return_status,
3045: x_msg_count => x_msg_count,
3038: p_copy_task_depends => fnd_api.g_true,
3039: p_create_recurrences => fnd_api.g_false,
3040: p_copy_task_references => fnd_api.g_true,
3041: p_copy_task_dates => fnd_api.g_true,
3042: p_copy_task_contacts => fnd_api.g_true,
3043: p_copy_task_contact_points => fnd_api.g_true,
3044: x_return_status => x_return_status,
3045: x_msg_count => x_msg_count,
3046: x_msg_data => x_msg_data,
3039: p_create_recurrences => fnd_api.g_false,
3040: p_copy_task_references => fnd_api.g_true,
3041: p_copy_task_dates => fnd_api.g_true,
3042: p_copy_task_contacts => fnd_api.g_true,
3043: p_copy_task_contact_points => fnd_api.g_true,
3044: x_return_status => x_return_status,
3045: x_msg_count => x_msg_count,
3046: x_msg_data => x_msg_data,
3047: x_task_id => l_recur_task_id
3146: fnd_message.set_token ('RES', l_name );
3147: fnd_message.set_token ('DATE', l_date);
3148:
3149: fnd_msg_pub.add;
3150: x_return_status := fnd_api.g_ret_sts_unexp_error;
3151:
3152: RAISE fnd_api.g_exc_unexpected_error;
3153:
3154: end if;
3148:
3149: fnd_msg_pub.add;
3150: x_return_status := fnd_api.g_ret_sts_unexp_error;
3151:
3152: RAISE fnd_api.g_exc_unexpected_error;
3153:
3154: end if;
3155: end if;
3156:
3176: -- Fix bug 2376554
3177: --l_ovn := get_ovn (p_task_id => p_task_id);
3178: --jtf_tasks_pvt.delete_task (
3179: -- p_api_version => 1.0,
3180: -- p_init_msg_list => fnd_api.g_true,
3181: -- p_commit => fnd_api.g_false,
3182: -- p_task_id => p_task_id,
3183: -- p_object_version_number => l_ovn,
3184: -- x_return_status => x_return_status,
3177: --l_ovn := get_ovn (p_task_id => p_task_id);
3178: --jtf_tasks_pvt.delete_task (
3179: -- p_api_version => 1.0,
3180: -- p_init_msg_list => fnd_api.g_true,
3181: -- p_commit => fnd_api.g_false,
3182: -- p_task_id => p_task_id,
3183: -- p_object_version_number => l_ovn,
3184: -- x_return_status => x_return_status,
3185: -- x_msg_count => x_msg_count,
3216:
3217: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3218:
3219: EXCEPTION
3220: WHEN fnd_api.g_exc_unexpected_error
3221: THEN
3222: jtf_task_recurrences_pub.creating_recurrences := FALSE;
3223:
3224:
3222: jtf_task_recurrences_pub.creating_recurrences := FALSE;
3223:
3224:
3225: ROLLBACK TO create_task_recur_pvt;
3226: x_return_status := fnd_api.g_ret_sts_unexp_error;
3227: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3228: WHEN OTHERS
3229: THEN
3230: jtf_task_recurrences_pub.creating_recurrences := FALSE;
3231: ROLLBACK TO create_task_recur_pvt;
3232: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
3233: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
3234: fnd_msg_pub.add;
3235: x_return_status := fnd_api.g_ret_sts_unexp_error;
3236: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3237: END;
3238:
3239: -- To fix bug 2721278
3262: END is_repeat_start_date_changed;
3263:
3264: PROCEDURE update_task_recurrence (
3265: p_api_version IN NUMBER,
3266: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
3267: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
3268: p_task_id IN NUMBER,
3269: p_recurrence_rule_id IN NUMBER,
3270: p_occurs_which IN INTEGER DEFAULT NULL,
3263:
3264: PROCEDURE update_task_recurrence (
3265: p_api_version IN NUMBER,
3266: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
3267: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
3268: p_task_id IN NUMBER,
3269: p_recurrence_rule_id IN NUMBER,
3270: p_occurs_which IN INTEGER DEFAULT NULL,
3271: p_day_of_week IN INTEGER DEFAULT NULL,
3335: l_repeat_start_date DATE;
3336: BEGIN
3337: SAVEPOINT update_task_recurrence_pvt;
3338:
3339: x_return_status := fnd_api.g_ret_sts_success;
3340:
3341: IF fnd_api.to_boolean (p_init_msg_list)
3342: THEN
3343: fnd_msg_pub.initialize;
3337: SAVEPOINT update_task_recurrence_pvt;
3338:
3339: x_return_status := fnd_api.g_ret_sts_success;
3340:
3341: IF fnd_api.to_boolean (p_init_msg_list)
3342: THEN
3343: fnd_msg_pub.initialize;
3344: END IF;
3345:
3351: CLOSE c_new_start_date;
3352: fnd_message.set_name('JTF','JTF_TASK_INVALID_TASK_ID');
3353: fnd_message.set_token('P_TASK_ID', p_task_id);
3354: fnd_msg_pub.add;
3355: x_return_status := fnd_api.g_ret_sts_unexp_error;
3356: RAISE fnd_api.g_exc_unexpected_error;
3357: END IF;
3358: CLOSE c_new_start_date;
3359:
3352: fnd_message.set_name('JTF','JTF_TASK_INVALID_TASK_ID');
3353: fnd_message.set_token('P_TASK_ID', p_task_id);
3354: fnd_msg_pub.add;
3355: x_return_status := fnd_api.g_ret_sts_unexp_error;
3356: RAISE fnd_api.g_exc_unexpected_error;
3357: END IF;
3358: CLOSE c_new_start_date;
3359:
3360: -- To fix bug 2721278
3375: -- Store the new task_id into l_new_task_id
3376: ---------------------------------------------
3377: jtf_tasks_pub.copy_task (
3378: p_api_version => 1.0,
3379: p_init_msg_list => fnd_api.g_true,
3380: p_commit => fnd_api.g_false,
3381: p_source_task_id => p_task_id,
3382: p_copy_task_assignments => fnd_api.g_true,
3383: p_copy_task_rsc_reqs => fnd_api.g_true,
3376: ---------------------------------------------
3377: jtf_tasks_pub.copy_task (
3378: p_api_version => 1.0,
3379: p_init_msg_list => fnd_api.g_true,
3380: p_commit => fnd_api.g_false,
3381: p_source_task_id => p_task_id,
3382: p_copy_task_assignments => fnd_api.g_true,
3383: p_copy_task_rsc_reqs => fnd_api.g_true,
3384: p_copy_task_depends => fnd_api.g_true,
3378: p_api_version => 1.0,
3379: p_init_msg_list => fnd_api.g_true,
3380: p_commit => fnd_api.g_false,
3381: p_source_task_id => p_task_id,
3382: p_copy_task_assignments => fnd_api.g_true,
3383: p_copy_task_rsc_reqs => fnd_api.g_true,
3384: p_copy_task_depends => fnd_api.g_true,
3385: p_create_recurrences => fnd_api.g_false,
3386: p_copy_task_references => fnd_api.g_true,
3379: p_init_msg_list => fnd_api.g_true,
3380: p_commit => fnd_api.g_false,
3381: p_source_task_id => p_task_id,
3382: p_copy_task_assignments => fnd_api.g_true,
3383: p_copy_task_rsc_reqs => fnd_api.g_true,
3384: p_copy_task_depends => fnd_api.g_true,
3385: p_create_recurrences => fnd_api.g_false,
3386: p_copy_task_references => fnd_api.g_true,
3387: p_copy_task_dates => fnd_api.g_true,
3380: p_commit => fnd_api.g_false,
3381: p_source_task_id => p_task_id,
3382: p_copy_task_assignments => fnd_api.g_true,
3383: p_copy_task_rsc_reqs => fnd_api.g_true,
3384: p_copy_task_depends => fnd_api.g_true,
3385: p_create_recurrences => fnd_api.g_false,
3386: p_copy_task_references => fnd_api.g_true,
3387: p_copy_task_dates => fnd_api.g_true,
3388: p_copy_task_contacts => fnd_api.g_true,
3381: p_source_task_id => p_task_id,
3382: p_copy_task_assignments => fnd_api.g_true,
3383: p_copy_task_rsc_reqs => fnd_api.g_true,
3384: p_copy_task_depends => fnd_api.g_true,
3385: p_create_recurrences => fnd_api.g_false,
3386: p_copy_task_references => fnd_api.g_true,
3387: p_copy_task_dates => fnd_api.g_true,
3388: p_copy_task_contacts => fnd_api.g_true,
3389: p_copy_task_contact_points => fnd_api.g_true,
3382: p_copy_task_assignments => fnd_api.g_true,
3383: p_copy_task_rsc_reqs => fnd_api.g_true,
3384: p_copy_task_depends => fnd_api.g_true,
3385: p_create_recurrences => fnd_api.g_false,
3386: p_copy_task_references => fnd_api.g_true,
3387: p_copy_task_dates => fnd_api.g_true,
3388: p_copy_task_contacts => fnd_api.g_true,
3389: p_copy_task_contact_points => fnd_api.g_true,
3390: x_return_status => x_return_status,
3383: p_copy_task_rsc_reqs => fnd_api.g_true,
3384: p_copy_task_depends => fnd_api.g_true,
3385: p_create_recurrences => fnd_api.g_false,
3386: p_copy_task_references => fnd_api.g_true,
3387: p_copy_task_dates => fnd_api.g_true,
3388: p_copy_task_contacts => fnd_api.g_true,
3389: p_copy_task_contact_points => fnd_api.g_true,
3390: x_return_status => x_return_status,
3391: x_msg_count => x_msg_count,
3384: p_copy_task_depends => fnd_api.g_true,
3385: p_create_recurrences => fnd_api.g_false,
3386: p_copy_task_references => fnd_api.g_true,
3387: p_copy_task_dates => fnd_api.g_true,
3388: p_copy_task_contacts => fnd_api.g_true,
3389: p_copy_task_contact_points => fnd_api.g_true,
3390: x_return_status => x_return_status,
3391: x_msg_count => x_msg_count,
3392: x_msg_data => x_msg_data,
3385: p_create_recurrences => fnd_api.g_false,
3386: p_copy_task_references => fnd_api.g_true,
3387: p_copy_task_dates => fnd_api.g_true,
3388: p_copy_task_contacts => fnd_api.g_true,
3389: p_copy_task_contact_points => fnd_api.g_true,
3390: x_return_status => x_return_status,
3391: x_msg_count => x_msg_count,
3392: x_msg_data => x_msg_data,
3393: x_task_id => l_new_task_id
3391: x_msg_count => x_msg_count,
3392: x_msg_data => x_msg_data,
3393: x_task_id => l_new_task_id
3394: );
3395: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
3396: THEN
3397: x_return_status := fnd_api.g_ret_sts_unexp_error;
3398: RAISE fnd_api.g_exc_unexpected_error;
3399: END IF;
3393: x_task_id => l_new_task_id
3394: );
3395: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
3396: THEN
3397: x_return_status := fnd_api.g_ret_sts_unexp_error;
3398: RAISE fnd_api.g_exc_unexpected_error;
3399: END IF;
3400:
3401: ---------------------------------------------
3394: );
3395: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
3396: THEN
3397: x_return_status := fnd_api.g_ret_sts_unexp_error;
3398: RAISE fnd_api.g_exc_unexpected_error;
3399: END IF;
3400:
3401: ---------------------------------------------
3402: -- Change the status of all assignees to 18
3417: IF l_first_task
3418: THEN
3419: l_delete_future_recurrences := 'A'; -- Delete all the occurrences
3420: ELSE
3421: l_delete_future_recurrences := fnd_api.g_true; -- Delete the future occrrences
3422: END IF;
3423:
3424: --------------------------------------------------
3425: -- Delete all the appointments
3428: l_object_version_number := jta_sync_task_common.get_ovn(p_task_id => p_task_id);
3429:
3430: jtf_tasks_pvt.delete_task (
3431: p_api_version => 1.0,
3432: p_init_msg_list => fnd_api.g_false,
3433: p_commit => fnd_api.g_false,
3434: p_object_version_number => l_object_version_number,
3435: p_task_id => p_task_id,
3436: p_delete_future_recurrences => l_delete_future_recurrences,
3429:
3430: jtf_tasks_pvt.delete_task (
3431: p_api_version => 1.0,
3432: p_init_msg_list => fnd_api.g_false,
3433: p_commit => fnd_api.g_false,
3434: p_object_version_number => l_object_version_number,
3435: p_task_id => p_task_id,
3436: p_delete_future_recurrences => l_delete_future_recurrences,
3437: x_return_status => x_return_status,
3437: x_return_status => x_return_status,
3438: x_msg_count => x_msg_count,
3439: x_msg_data => x_msg_data
3440: );
3441: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
3442: THEN
3443: x_return_status := fnd_api.g_ret_sts_unexp_error;
3444: RAISE fnd_api.g_exc_unexpected_error;
3445: END IF;
3439: x_msg_data => x_msg_data
3440: );
3441: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
3442: THEN
3443: x_return_status := fnd_api.g_ret_sts_unexp_error;
3444: RAISE fnd_api.g_exc_unexpected_error;
3445: END IF;
3446:
3447: ---------------------------------------------------------------------
3440: );
3441: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
3442: THEN
3443: x_return_status := fnd_api.g_ret_sts_unexp_error;
3444: RAISE fnd_api.g_exc_unexpected_error;
3445: END IF;
3446:
3447: ---------------------------------------------------------------------
3448: -- Update end_date_active and occurs_number for the current
3458: CLOSE c_task;
3459: fnd_message.set_name('JTF','JTF_TASK_INVALID_TASK_ID');
3460: fnd_message.set_token('P_TASK_ID', p_task_id);
3461: fnd_msg_pub.add;
3462: x_return_status := fnd_api.g_ret_sts_unexp_error;
3463: RAISE fnd_api.g_exc_unexpected_error;
3464: END IF;
3465: CLOSE c_task;
3466:
3459: fnd_message.set_name('JTF','JTF_TASK_INVALID_TASK_ID');
3460: fnd_message.set_token('P_TASK_ID', p_task_id);
3461: fnd_msg_pub.add;
3462: x_return_status := fnd_api.g_ret_sts_unexp_error;
3463: RAISE fnd_api.g_exc_unexpected_error;
3464: END IF;
3465: CLOSE c_task;
3466:
3467: UPDATE jtf_task_recur_rules
3474: -- Create a new recurrence with l_new_task_id
3475: --------------------------------------------------
3476: create_task_recurrence (
3477: p_api_version => 1.0,
3478: p_init_msg_list => fnd_api.g_false,
3479: p_commit => fnd_api.g_false,
3480: p_task_id => l_new_task_id,
3481: p_occurs_which => p_occurs_which,
3482: p_day_of_week => p_day_of_week,
3475: --------------------------------------------------
3476: create_task_recurrence (
3477: p_api_version => 1.0,
3478: p_init_msg_list => fnd_api.g_false,
3479: p_commit => fnd_api.g_false,
3480: p_task_id => l_new_task_id,
3481: p_occurs_which => p_occurs_which,
3482: p_day_of_week => p_day_of_week,
3483: p_date_of_month => p_date_of_month,
3517: p_thursday => p_thursday,
3518: p_friday => p_friday,
3519: p_saturday => p_saturday
3520: );
3521: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
3522: THEN
3523: x_return_status := fnd_api.g_ret_sts_unexp_error;
3524: RAISE fnd_api.g_exc_unexpected_error;
3525: END IF;
3519: p_saturday => p_saturday
3520: );
3521: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
3522: THEN
3523: x_return_status := fnd_api.g_ret_sts_unexp_error;
3524: RAISE fnd_api.g_exc_unexpected_error;
3525: END IF;
3526:
3527: ------------------------------------------------------------
3520: );
3521: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
3522: THEN
3523: x_return_status := fnd_api.g_ret_sts_unexp_error;
3524: RAISE fnd_api.g_exc_unexpected_error;
3525: END IF;
3526:
3527: ------------------------------------------------------------
3528: -- Update sync mapping table if this task is the first one
3533: SET task_id = l_new_task_id
3534: WHERE task_id = p_task_id;
3535: END IF;
3536:
3537: IF fnd_api.to_boolean (p_commit)
3538: THEN
3539: COMMIT WORK;
3540: END IF;
3541:
3540: END IF;
3541:
3542: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3543: EXCEPTION
3544: WHEN fnd_api.g_exc_unexpected_error
3545: THEN
3546: ROLLBACK TO update_task_recurrence_pvt;
3547: x_return_status := fnd_api.g_ret_sts_unexp_error;
3548: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3543: EXCEPTION
3544: WHEN fnd_api.g_exc_unexpected_error
3545: THEN
3546: ROLLBACK TO update_task_recurrence_pvt;
3547: x_return_status := fnd_api.g_ret_sts_unexp_error;
3548: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3549: WHEN OTHERS
3550: THEN
3551: ROLLBACK TO update_task_recurrence_pvt;
3551: ROLLBACK TO update_task_recurrence_pvt;
3552: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
3553: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
3554: fnd_msg_pub.add;
3555: x_return_status := fnd_api.g_ret_sts_unexp_error;
3556: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3557: END update_task_recurrence;
3558:
3559: END; --CREATE OR REPLACE PACKAGE