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_API

Line 617: IF ( l_status <> FND_API.G_RET_STS_SUCCESS )

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:

Line 619: RAISE fnd_api.G_EXC_ERROR;

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

Line 642: IF ( l_status <> FND_API.G_RET_STS_SUCCESS )

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:

Line 644: RAISE fnd_api.G_EXC_ERROR;

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

Line 1642: -- RAISE fnd_api.g_exc_unexpected_error;

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

Line 1673: RAISE fnd_api.g_exc_unexpected_error;

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;

Line 1697: RAISE fnd_api.g_exc_unexpected_error;

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;

Line 1731: x_return_status := fnd_api.g_ret_sts_success;

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

Line 1738: RAISE fnd_api.g_exc_unexpected_error;

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

Line 1745: RAISE fnd_api.g_exc_unexpected_error;

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');

Line 1751: RAISE fnd_api.g_exc_unexpected_error;

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 )

Line 1760: RAISE fnd_api.g_exc_unexpected_error;

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');

Line 1766: RAISE fnd_api.g_exc_unexpected_error;

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');

Line 1772: RAISE fnd_api.g_exc_unexpected_error;

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')

Line 1781: RAISE fnd_api.g_exc_unexpected_error;

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');

Line 1787: RAISE fnd_api.g_exc_unexpected_error;

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

Line 1799: RAISE fnd_api.g_exc_unexpected_error;

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'

Line 1812: RAISE fnd_api.g_exc_unexpected_error;

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

Line 1819: RAISE fnd_api.g_exc_unexpected_error;

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

Line 1826: RAISE fnd_api.g_exc_unexpected_error;

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:

Line 1847: RAISE fnd_api.g_exc_unexpected_error;

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

Line 1857: RAISE fnd_api.g_exc_unexpected_error;

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

Line 1869: RAISE fnd_api.g_exc_unexpected_error;

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

Line 1877: RAISE fnd_api.g_exc_unexpected_error;

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

Line 1885: RAISE fnd_api.g_exc_unexpected_error;

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:

Line 1899: RAISE fnd_api.g_exc_unexpected_error;

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

Line 1906: RAISE fnd_api.g_exc_unexpected_error;

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'

Line 1922: RAISE fnd_api.g_exc_unexpected_error;

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)

Line 1931: RAISE fnd_api.g_exc_unexpected_error;

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

Line 1939: RAISE fnd_api.g_exc_unexpected_error;

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

Line 1947: RAISE fnd_api.g_exc_unexpected_error;

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

Line 1955: RAISE fnd_api.g_exc_unexpected_error;

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

Line 1963: RAISE fnd_api.g_exc_unexpected_error;

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

Line 1971: RAISE fnd_api.g_exc_unexpected_error;

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:

Line 1989: RAISE fnd_api.g_exc_unexpected_error;

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

Line 1997: RAISE fnd_api.g_exc_unexpected_error;

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)

Line 2006: RAISE fnd_api.g_exc_unexpected_error;

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)

Line 2014: RAISE fnd_api.g_exc_unexpected_error;

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)

Line 2022: RAISE fnd_api.g_exc_unexpected_error;

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');

Line 2028: RAISE fnd_api.g_exc_unexpected_error;

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');

Line 2034: RAISE fnd_api.g_exc_unexpected_error;

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

Line 2041: RAISE fnd_api.g_exc_unexpected_error;

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');

Line 2047: RAISE fnd_api.g_exc_unexpected_error;

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)

Line 2055: RAISE fnd_api.g_exc_unexpected_error;

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)

Line 2068: RAISE fnd_api.g_exc_unexpected_error;

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)

Line 2077: RAISE fnd_api.g_exc_unexpected_error;

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'

Line 2088: RAISE fnd_api.g_exc_unexpected_error;

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

Line 2096: RAISE fnd_api.g_exc_unexpected_error;

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))

Line 2105: RAISE fnd_api.g_exc_unexpected_error;

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)

Line 2113: RAISE fnd_api.g_exc_unexpected_error;

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)

Line 2121: RAISE fnd_api.g_exc_unexpected_error;

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');

Line 2127: RAISE fnd_api.g_exc_unexpected_error;

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');

Line 2133: RAISE fnd_api.g_exc_unexpected_error;

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');

Line 2139: RAISE fnd_api.g_exc_unexpected_error;

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)

Line 2147: RAISE fnd_api.g_exc_unexpected_error;

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)

Line 2160: RAISE fnd_api.g_exc_unexpected_error;

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)

Line 2169: RAISE fnd_api.g_exc_unexpected_error;

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:

Line 2175: WHEN fnd_api.g_exc_unexpected_error

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

Line 2177: x_return_status := fnd_api.g_ret_sts_unexp_error;

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');

Line 2183: x_return_status := fnd_api.g_ret_sts_unexp_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: -----------------------------------------------------------------------------------------------------------

Line 2193: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

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,

Line 2194: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

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,

Line 2323: x_return_status := fnd_api.g_ret_sts_success;

2319:
2320: jtf_task_recurrences_pub.creating_recurrences := TRUE;
2321:
2322: SAVEPOINT create_task_recur_pvt;
2323: x_return_status := fnd_api.g_ret_sts_success;
2324:
2325: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2326: THEN
2327: RAISE fnd_api.g_exc_unexpected_error;

Line 2325: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

2321:
2322: SAVEPOINT create_task_recur_pvt;
2323: x_return_status := fnd_api.g_ret_sts_success;
2324:
2325: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2326: THEN
2327: RAISE fnd_api.g_exc_unexpected_error;
2328: END IF;
2329:

Line 2327: RAISE fnd_api.g_exc_unexpected_error;

2323: x_return_status := fnd_api.g_ret_sts_success;
2324:
2325: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2326: THEN
2327: RAISE fnd_api.g_exc_unexpected_error;
2328: END IF;
2329:
2330: IF fnd_api.to_boolean (p_init_msg_list)
2331: THEN

Line 2330: IF fnd_api.to_boolean (p_init_msg_list)

2326: THEN
2327: RAISE fnd_api.g_exc_unexpected_error;
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:

Line 2349: x_return_status := fnd_api.g_ret_sts_error;

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

Line 2352: RAISE fnd_api.g_exc_unexpected_error;

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
2356: INTO l_recur_id

Line 2361: x_return_status := fnd_api.g_ret_sts_error;

2357: FROM jtf_tasks_b
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;

Line 2364: RAISE fnd_api.g_exc_unexpected_error;

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:
2368: jtf_task_recurrences_pvt.validate_task_recurrence (

Line 2390: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

2386: p_friday => p_friday,
2387: p_saturday => p_saturday
2388: );
2389:
2390: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2391: THEN
2392:
2393: x_return_status := fnd_api.g_ret_sts_unexp_error;
2394: RAISE fnd_api.g_exc_unexpected_error;

Line 2393: x_return_status := fnd_api.g_ret_sts_unexp_error;

2389:
2390: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2391: THEN
2392:
2393: x_return_status := fnd_api.g_ret_sts_unexp_error;
2394: RAISE fnd_api.g_exc_unexpected_error;
2395: END IF;
2396: --- Call the procedure to generate the dates
2397: IF not jtf_task_utl.to_boolean (p_template_flag)

Line 2394: RAISE fnd_api.g_exc_unexpected_error;

2390: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2391: THEN
2392:
2393: x_return_status := fnd_api.g_ret_sts_unexp_error;
2394: RAISE fnd_api.g_exc_unexpected_error;
2395: END IF;
2396: --- Call the procedure to generate the dates
2397: IF not jtf_task_utl.to_boolean (p_template_flag)
2398: THEN

Line 2491: x_return_status := fnd_api.g_ret_sts_unexp_error;

2487:
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

Line 2494: RAISE fnd_api.g_exc_unexpected_error;

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:
2498: IF jtf_task_utl.to_boolean(p_template_flag)

Line 2511: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 2514: RAISE fnd_api.g_exc_unexpected_error;

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:
2518:

Line 2527: RAISE fnd_api.g_exc_unexpected_error;

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
2531: --- else call copy tasks to create the tasks.

Line 3009: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

3005: , x_calendar_start_date => l_calendar_start_date
3006: , x_calendar_end_date => l_calendar_end_date
3007: , x_return_status => x_return_status);
3008:
3009: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
3010: THEN
3011: RAISE fnd_api.g_exc_unexpected_error;
3012: END IF;
3013: l_valid := TRUE;

Line 3011: RAISE fnd_api.g_exc_unexpected_error;

3007: , x_return_status => x_return_status);
3008:
3009: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
3010: THEN
3011: RAISE fnd_api.g_exc_unexpected_error;
3012: END IF;
3013: l_valid := TRUE;
3014: END IF;
3015:

Line 3027: p_init_msg_list => fnd_api.g_false,

3023: IF i <> 1
3024: THEN
3025: jtf_tasks_pub.copy_task (
3026: p_api_version => 1.0,
3027: p_init_msg_list => fnd_api.g_false,
3028: p_commit => fnd_api.g_true,
3029: p_source_task_id => l_task_id,
3030: p_copy_task_assignments => fnd_api.g_true,
3031: p_copy_task_rsc_reqs => fnd_api.g_true,

Line 3028: p_commit => fnd_api.g_true,

3024: THEN
3025: jtf_tasks_pub.copy_task (
3026: p_api_version => 1.0,
3027: p_init_msg_list => fnd_api.g_false,
3028: p_commit => fnd_api.g_true,
3029: p_source_task_id => l_task_id,
3030: p_copy_task_assignments => fnd_api.g_true,
3031: p_copy_task_rsc_reqs => fnd_api.g_true,
3032: p_copy_task_depends => fnd_api.g_true,

Line 3030: p_copy_task_assignments => fnd_api.g_true,

3026: p_api_version => 1.0,
3027: p_init_msg_list => fnd_api.g_false,
3028: p_commit => fnd_api.g_true,
3029: p_source_task_id => l_task_id,
3030: p_copy_task_assignments => fnd_api.g_true,
3031: p_copy_task_rsc_reqs => fnd_api.g_true,
3032: p_copy_task_depends => fnd_api.g_true,
3033: p_create_recurrences => fnd_api.g_false,
3034: p_copy_task_references => fnd_api.g_true,

Line 3031: p_copy_task_rsc_reqs => fnd_api.g_true,

3027: p_init_msg_list => fnd_api.g_false,
3028: p_commit => fnd_api.g_true,
3029: p_source_task_id => l_task_id,
3030: p_copy_task_assignments => fnd_api.g_true,
3031: p_copy_task_rsc_reqs => fnd_api.g_true,
3032: p_copy_task_depends => fnd_api.g_true,
3033: p_create_recurrences => fnd_api.g_false,
3034: p_copy_task_references => fnd_api.g_true,
3035: p_copy_task_dates => fnd_api.g_true,

Line 3032: p_copy_task_depends => fnd_api.g_true,

3028: p_commit => fnd_api.g_true,
3029: p_source_task_id => l_task_id,
3030: p_copy_task_assignments => fnd_api.g_true,
3031: p_copy_task_rsc_reqs => fnd_api.g_true,
3032: p_copy_task_depends => fnd_api.g_true,
3033: p_create_recurrences => fnd_api.g_false,
3034: p_copy_task_references => fnd_api.g_true,
3035: p_copy_task_dates => fnd_api.g_true,
3036: p_copy_task_contacts => fnd_api.g_true,

Line 3033: p_create_recurrences => fnd_api.g_false,

3029: p_source_task_id => l_task_id,
3030: p_copy_task_assignments => fnd_api.g_true,
3031: p_copy_task_rsc_reqs => fnd_api.g_true,
3032: p_copy_task_depends => fnd_api.g_true,
3033: p_create_recurrences => fnd_api.g_false,
3034: p_copy_task_references => fnd_api.g_true,
3035: p_copy_task_dates => fnd_api.g_true,
3036: p_copy_task_contacts => fnd_api.g_true,
3037: p_copy_task_contact_points => fnd_api.g_true,

Line 3034: p_copy_task_references => fnd_api.g_true,

3030: p_copy_task_assignments => fnd_api.g_true,
3031: p_copy_task_rsc_reqs => fnd_api.g_true,
3032: p_copy_task_depends => fnd_api.g_true,
3033: p_create_recurrences => fnd_api.g_false,
3034: p_copy_task_references => fnd_api.g_true,
3035: p_copy_task_dates => fnd_api.g_true,
3036: p_copy_task_contacts => fnd_api.g_true,
3037: p_copy_task_contact_points => fnd_api.g_true,
3038: x_return_status => x_return_status,

Line 3035: p_copy_task_dates => fnd_api.g_true,

3031: p_copy_task_rsc_reqs => fnd_api.g_true,
3032: p_copy_task_depends => fnd_api.g_true,
3033: p_create_recurrences => fnd_api.g_false,
3034: p_copy_task_references => fnd_api.g_true,
3035: p_copy_task_dates => fnd_api.g_true,
3036: p_copy_task_contacts => fnd_api.g_true,
3037: p_copy_task_contact_points => fnd_api.g_true,
3038: x_return_status => x_return_status,
3039: x_msg_count => x_msg_count,

Line 3036: p_copy_task_contacts => fnd_api.g_true,

3032: p_copy_task_depends => fnd_api.g_true,
3033: p_create_recurrences => fnd_api.g_false,
3034: p_copy_task_references => fnd_api.g_true,
3035: p_copy_task_dates => fnd_api.g_true,
3036: p_copy_task_contacts => fnd_api.g_true,
3037: p_copy_task_contact_points => fnd_api.g_true,
3038: x_return_status => x_return_status,
3039: x_msg_count => x_msg_count,
3040: x_msg_data => x_msg_data,

Line 3037: p_copy_task_contact_points => fnd_api.g_true,

3033: p_create_recurrences => fnd_api.g_false,
3034: p_copy_task_references => fnd_api.g_true,
3035: p_copy_task_dates => fnd_api.g_true,
3036: p_copy_task_contacts => fnd_api.g_true,
3037: p_copy_task_contact_points => fnd_api.g_true,
3038: x_return_status => x_return_status,
3039: x_msg_count => x_msg_count,
3040: x_msg_data => x_msg_data,
3041: x_task_id => l_recur_task_id

Line 3126: -- p_init_msg_list => fnd_api.g_true,

3122: -- Fix bug 2376554
3123: --l_ovn := get_ovn (p_task_id => p_task_id);
3124: --jtf_tasks_pvt.delete_task (
3125: -- p_api_version => 1.0,
3126: -- p_init_msg_list => fnd_api.g_true,
3127: -- p_commit => fnd_api.g_false,
3128: -- p_task_id => p_task_id,
3129: -- p_object_version_number => l_ovn,
3130: -- x_return_status => x_return_status,

Line 3127: -- p_commit => fnd_api.g_false,

3123: --l_ovn := get_ovn (p_task_id => p_task_id);
3124: --jtf_tasks_pvt.delete_task (
3125: -- p_api_version => 1.0,
3126: -- p_init_msg_list => fnd_api.g_true,
3127: -- p_commit => fnd_api.g_false,
3128: -- p_task_id => p_task_id,
3129: -- p_object_version_number => l_ovn,
3130: -- x_return_status => x_return_status,
3131: -- x_msg_count => x_msg_count,

Line 3166: WHEN fnd_api.g_exc_unexpected_error

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
3168: jtf_task_recurrences_pub.creating_recurrences := FALSE;
3169:
3170:

Line 3172: x_return_status := fnd_api.g_ret_sts_unexp_error;

3168: jtf_task_recurrences_pub.creating_recurrences := FALSE;
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;

Line 3181: x_return_status := fnd_api.g_ret_sts_unexp_error;

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:
3185: -- To fix bug 2721278

Line 3212: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

3208: END is_repeat_start_date_changed;
3209:
3210: PROCEDURE update_task_recurrence (
3211: p_api_version IN NUMBER,
3212: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
3213: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
3214: p_task_id IN NUMBER,
3215: p_recurrence_rule_id IN NUMBER,
3216: p_occurs_which IN INTEGER DEFAULT NULL,

Line 3213: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

3209:
3210: PROCEDURE update_task_recurrence (
3211: p_api_version IN NUMBER,
3212: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
3213: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
3214: p_task_id IN NUMBER,
3215: p_recurrence_rule_id IN NUMBER,
3216: p_occurs_which IN INTEGER DEFAULT NULL,
3217: p_day_of_week IN INTEGER DEFAULT NULL,

Line 3285: x_return_status := fnd_api.g_ret_sts_success;

3281: l_repeat_start_date DATE;
3282: BEGIN
3283: SAVEPOINT update_task_recurrence_pvt;
3284:
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;

Line 3287: IF fnd_api.to_boolean (p_init_msg_list)

3283: SAVEPOINT update_task_recurrence_pvt;
3284:
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:

Line 3301: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 3302: RAISE fnd_api.g_exc_unexpected_error;

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;
3305:
3306: -- To fix bug 2721278

Line 3325: p_init_msg_list => fnd_api.g_true,

3321: -- Store the new task_id into l_new_task_id
3322: ---------------------------------------------
3323: jtf_tasks_pub.copy_task (
3324: p_api_version => 1.0,
3325: p_init_msg_list => fnd_api.g_true,
3326: p_commit => fnd_api.g_false,
3327: p_source_task_id => p_task_id,
3328: p_copy_task_assignments => fnd_api.g_true,
3329: p_copy_task_rsc_reqs => fnd_api.g_true,

Line 3326: p_commit => fnd_api.g_false,

3322: ---------------------------------------------
3323: jtf_tasks_pub.copy_task (
3324: p_api_version => 1.0,
3325: p_init_msg_list => fnd_api.g_true,
3326: p_commit => fnd_api.g_false,
3327: p_source_task_id => p_task_id,
3328: p_copy_task_assignments => fnd_api.g_true,
3329: p_copy_task_rsc_reqs => fnd_api.g_true,
3330: p_copy_task_depends => fnd_api.g_true,

Line 3328: p_copy_task_assignments => fnd_api.g_true,

3324: p_api_version => 1.0,
3325: p_init_msg_list => fnd_api.g_true,
3326: p_commit => fnd_api.g_false,
3327: p_source_task_id => p_task_id,
3328: p_copy_task_assignments => fnd_api.g_true,
3329: p_copy_task_rsc_reqs => fnd_api.g_true,
3330: p_copy_task_depends => fnd_api.g_true,
3331: p_create_recurrences => fnd_api.g_false,
3332: p_copy_task_references => fnd_api.g_true,

Line 3329: p_copy_task_rsc_reqs => fnd_api.g_true,

3325: p_init_msg_list => fnd_api.g_true,
3326: p_commit => fnd_api.g_false,
3327: p_source_task_id => p_task_id,
3328: p_copy_task_assignments => fnd_api.g_true,
3329: p_copy_task_rsc_reqs => fnd_api.g_true,
3330: p_copy_task_depends => fnd_api.g_true,
3331: p_create_recurrences => fnd_api.g_false,
3332: p_copy_task_references => fnd_api.g_true,
3333: p_copy_task_dates => fnd_api.g_true,

Line 3330: p_copy_task_depends => fnd_api.g_true,

3326: p_commit => fnd_api.g_false,
3327: p_source_task_id => p_task_id,
3328: p_copy_task_assignments => fnd_api.g_true,
3329: p_copy_task_rsc_reqs => fnd_api.g_true,
3330: p_copy_task_depends => fnd_api.g_true,
3331: p_create_recurrences => fnd_api.g_false,
3332: p_copy_task_references => fnd_api.g_true,
3333: p_copy_task_dates => fnd_api.g_true,
3334: p_copy_task_contacts => fnd_api.g_true,

Line 3331: p_create_recurrences => fnd_api.g_false,

3327: p_source_task_id => p_task_id,
3328: p_copy_task_assignments => fnd_api.g_true,
3329: p_copy_task_rsc_reqs => fnd_api.g_true,
3330: p_copy_task_depends => fnd_api.g_true,
3331: p_create_recurrences => fnd_api.g_false,
3332: p_copy_task_references => fnd_api.g_true,
3333: p_copy_task_dates => fnd_api.g_true,
3334: p_copy_task_contacts => fnd_api.g_true,
3335: p_copy_task_contact_points => fnd_api.g_true,

Line 3332: p_copy_task_references => fnd_api.g_true,

3328: p_copy_task_assignments => fnd_api.g_true,
3329: p_copy_task_rsc_reqs => fnd_api.g_true,
3330: p_copy_task_depends => fnd_api.g_true,
3331: p_create_recurrences => fnd_api.g_false,
3332: p_copy_task_references => fnd_api.g_true,
3333: p_copy_task_dates => fnd_api.g_true,
3334: p_copy_task_contacts => fnd_api.g_true,
3335: p_copy_task_contact_points => fnd_api.g_true,
3336: x_return_status => x_return_status,

Line 3333: p_copy_task_dates => fnd_api.g_true,

3329: p_copy_task_rsc_reqs => fnd_api.g_true,
3330: p_copy_task_depends => fnd_api.g_true,
3331: p_create_recurrences => fnd_api.g_false,
3332: p_copy_task_references => fnd_api.g_true,
3333: p_copy_task_dates => fnd_api.g_true,
3334: p_copy_task_contacts => fnd_api.g_true,
3335: p_copy_task_contact_points => fnd_api.g_true,
3336: x_return_status => x_return_status,
3337: x_msg_count => x_msg_count,

Line 3334: p_copy_task_contacts => fnd_api.g_true,

3330: p_copy_task_depends => fnd_api.g_true,
3331: p_create_recurrences => fnd_api.g_false,
3332: p_copy_task_references => fnd_api.g_true,
3333: p_copy_task_dates => fnd_api.g_true,
3334: p_copy_task_contacts => fnd_api.g_true,
3335: p_copy_task_contact_points => fnd_api.g_true,
3336: x_return_status => x_return_status,
3337: x_msg_count => x_msg_count,
3338: x_msg_data => x_msg_data,

Line 3335: p_copy_task_contact_points => fnd_api.g_true,

3331: p_create_recurrences => fnd_api.g_false,
3332: p_copy_task_references => fnd_api.g_true,
3333: p_copy_task_dates => fnd_api.g_true,
3334: p_copy_task_contacts => fnd_api.g_true,
3335: p_copy_task_contact_points => fnd_api.g_true,
3336: x_return_status => x_return_status,
3337: x_msg_count => x_msg_count,
3338: x_msg_data => x_msg_data,
3339: x_task_id => l_new_task_id

Line 3341: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

3337: x_msg_count => x_msg_count,
3338: x_msg_data => x_msg_data,
3339: x_task_id => l_new_task_id
3340: );
3341: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
3342: THEN
3343: x_return_status := fnd_api.g_ret_sts_unexp_error;
3344: RAISE fnd_api.g_exc_unexpected_error;
3345: END IF;

Line 3343: x_return_status := fnd_api.g_ret_sts_unexp_error;

3339: x_task_id => l_new_task_id
3340: );
3341: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
3342: THEN
3343: x_return_status := fnd_api.g_ret_sts_unexp_error;
3344: RAISE fnd_api.g_exc_unexpected_error;
3345: END IF;
3346:
3347: ---------------------------------------------

Line 3344: RAISE fnd_api.g_exc_unexpected_error;

3340: );
3341: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
3342: THEN
3343: x_return_status := fnd_api.g_ret_sts_unexp_error;
3344: RAISE fnd_api.g_exc_unexpected_error;
3345: END IF;
3346:
3347: ---------------------------------------------
3348: -- Change the status of all assignees to 18

Line 3367: l_delete_future_recurrences := fnd_api.g_true; -- Delete the future occrrences

3363: IF l_first_task
3364: THEN
3365: l_delete_future_recurrences := 'A'; -- Delete all the occurrences
3366: ELSE
3367: l_delete_future_recurrences := fnd_api.g_true; -- Delete the future occrrences
3368: END IF;
3369:
3370: --------------------------------------------------
3371: -- Delete all the appointments

Line 3378: p_init_msg_list => fnd_api.g_false,

3374: l_object_version_number := jta_sync_task_common.get_ovn(p_task_id => p_task_id);
3375:
3376: jtf_tasks_pvt.delete_task (
3377: p_api_version => 1.0,
3378: p_init_msg_list => fnd_api.g_false,
3379: p_commit => fnd_api.g_false,
3380: p_object_version_number => l_object_version_number,
3381: p_task_id => p_task_id,
3382: p_delete_future_recurrences => l_delete_future_recurrences,

Line 3379: p_commit => fnd_api.g_false,

3375:
3376: jtf_tasks_pvt.delete_task (
3377: p_api_version => 1.0,
3378: p_init_msg_list => fnd_api.g_false,
3379: p_commit => fnd_api.g_false,
3380: p_object_version_number => l_object_version_number,
3381: p_task_id => p_task_id,
3382: p_delete_future_recurrences => l_delete_future_recurrences,
3383: x_return_status => x_return_status,

Line 3387: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

3383: x_return_status => x_return_status,
3384: x_msg_count => x_msg_count,
3385: x_msg_data => x_msg_data
3386: );
3387: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
3388: THEN
3389: x_return_status := fnd_api.g_ret_sts_unexp_error;
3390: RAISE fnd_api.g_exc_unexpected_error;
3391: END IF;

Line 3389: x_return_status := fnd_api.g_ret_sts_unexp_error;

3385: x_msg_data => x_msg_data
3386: );
3387: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
3388: THEN
3389: x_return_status := fnd_api.g_ret_sts_unexp_error;
3390: RAISE fnd_api.g_exc_unexpected_error;
3391: END IF;
3392:
3393: ---------------------------------------------------------------------

Line 3390: RAISE fnd_api.g_exc_unexpected_error;

3386: );
3387: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
3388: THEN
3389: x_return_status := fnd_api.g_ret_sts_unexp_error;
3390: RAISE fnd_api.g_exc_unexpected_error;
3391: END IF;
3392:
3393: ---------------------------------------------------------------------
3394: -- Update end_date_active and occurs_number for the current

Line 3408: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 3409: RAISE fnd_api.g_exc_unexpected_error;

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;
3412:
3413: UPDATE jtf_task_recur_rules

Line 3424: p_init_msg_list => fnd_api.g_false,

3420: -- Create a new recurrence with l_new_task_id
3421: --------------------------------------------------
3422: create_task_recurrence (
3423: p_api_version => 1.0,
3424: p_init_msg_list => fnd_api.g_false,
3425: p_commit => fnd_api.g_false,
3426: p_task_id => l_new_task_id,
3427: p_occurs_which => p_occurs_which,
3428: p_day_of_week => p_day_of_week,

Line 3425: p_commit => fnd_api.g_false,

3421: --------------------------------------------------
3422: create_task_recurrence (
3423: p_api_version => 1.0,
3424: p_init_msg_list => fnd_api.g_false,
3425: p_commit => fnd_api.g_false,
3426: p_task_id => l_new_task_id,
3427: p_occurs_which => p_occurs_which,
3428: p_day_of_week => p_day_of_week,
3429: p_date_of_month => p_date_of_month,

Line 3467: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

3463: p_thursday => p_thursday,
3464: p_friday => p_friday,
3465: p_saturday => p_saturday
3466: );
3467: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
3468: THEN
3469: x_return_status := fnd_api.g_ret_sts_unexp_error;
3470: RAISE fnd_api.g_exc_unexpected_error;
3471: END IF;

Line 3469: x_return_status := fnd_api.g_ret_sts_unexp_error;

3465: p_saturday => p_saturday
3466: );
3467: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
3468: THEN
3469: x_return_status := fnd_api.g_ret_sts_unexp_error;
3470: RAISE fnd_api.g_exc_unexpected_error;
3471: END IF;
3472:
3473: ------------------------------------------------------------

Line 3470: RAISE fnd_api.g_exc_unexpected_error;

3466: );
3467: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
3468: THEN
3469: x_return_status := fnd_api.g_ret_sts_unexp_error;
3470: RAISE fnd_api.g_exc_unexpected_error;
3471: END IF;
3472:
3473: ------------------------------------------------------------
3474: -- Update sync mapping table if this task is the first one

Line 3483: IF fnd_api.to_boolean (p_commit)

3479: SET task_id = l_new_task_id
3480: WHERE task_id = p_task_id;
3481: END IF;
3482:
3483: IF fnd_api.to_boolean (p_commit)
3484: THEN
3485: COMMIT WORK;
3486: END IF;
3487:

Line 3490: WHEN fnd_api.g_exc_unexpected_error

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;
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);

Line 3493: x_return_status := fnd_api.g_ret_sts_unexp_error;

3489: EXCEPTION
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;

Line 3501: x_return_status := fnd_api.g_ret_sts_unexp_error;

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