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.OZF_FUND_UTILIZED_PVT dependencies on FND_MSG_PUB

Line 6: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

2: /* $Header: ozfvfutb.pls 120.17.12010000.10 2009/02/02 14:57:26 kdass ship $ */
3: g_pkg_name CONSTANT VARCHAR2 (30) := 'OZF_Fund_Utilized_PVT';
4: g_cons_fund_mode CONSTANT VARCHAR2 (30) := 'ADJUST'; --JTF_PLSQL_API.G_UPDATE
5: g_universal_currency CONSTANT VARCHAR2 (15) := fnd_profile.VALUE ('OZF_UNIV_CURR_CODE');
6: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
7:
8:
9: -----------------------------------------------------------------------
10: -- PROCEDURE

Line 391: fnd_msg_pub.initialize;

387: || ': start' || p_utilization_rec.utilization_type);
388: END IF;
389:
390: IF fnd_api.to_boolean (p_init_msg_list) THEN
391: fnd_msg_pub.initialize;
392: END IF;
393:
394: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
395: RAISE fnd_api.g_exc_unexpected_error;

Line 614: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

610: || l_utilization_rec.plan_type
611: || ' id('
612: || l_utilization_rec.plan_id);
613: END IF;
614: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
615: fnd_message.set_name ('OZF', 'OZF_NO_LEDGER_FOUND');
616: fnd_message.set_token('OBJECT_TYPE', l_utilization_rec.plan_type);
617: fnd_message.set_token('OBJECT_ID', l_utilization_rec.plan_id);
618: fnd_msg_pub.ADD;

Line 618: fnd_msg_pub.ADD;

614: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
615: fnd_message.set_name ('OZF', 'OZF_NO_LEDGER_FOUND');
616: fnd_message.set_token('OBJECT_TYPE', l_utilization_rec.plan_type);
617: fnd_message.set_token('OBJECT_ID', l_utilization_rec.plan_id);
618: fnd_msg_pub.ADD;
619: END IF;
620: x_return_status := fnd_api.g_ret_sts_error;
621: RAISE fnd_api.g_exc_error;
622: END IF;

Line 842: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

838: ,l_recal_comm_amt;
839: IF (c_fund_b%NOTFOUND) THEN
840: CLOSE c_fund_b;
841:
842: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
843: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
844: fnd_msg_pub.ADD;
845: END IF;
846:

Line 844: fnd_msg_pub.ADD;

840: CLOSE c_fund_b;
841:
842: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
843: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
844: fnd_msg_pub.ADD;
845: END IF;
846:
847: RAISE fnd_api.g_exc_error;
848: END IF;

Line 955: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

951: OPEN c_accrual_budget_reqeust(l_utilization_rec.fund_id, l_plan_id);
952: FETCH c_accrual_budget_reqeust INTO l_act_budget_id, l_act_budget_objver;
953: IF (c_accrual_budget_reqeust%NOTFOUND) THEN
954: CLOSE c_accrual_budget_reqeust;
955: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
956: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
957: fnd_msg_pub.ADD;
958: END IF;
959: RAISE fnd_api.g_exc_error;

Line 957: fnd_msg_pub.ADD;

953: IF (c_accrual_budget_reqeust%NOTFOUND) THEN
954: CLOSE c_accrual_budget_reqeust;
955: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
956: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
957: fnd_msg_pub.ADD;
958: END IF;
959: RAISE fnd_api.g_exc_error;
960: END IF;
961: CLOSE c_accrual_budget_reqeust;

Line 981: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

977: OPEN c_budget_request_utilrec(l_utilization_rec.fund_id, l_plan_id, l_act_budget_id);
978: FETCH c_budget_request_utilrec INTO l_act_budget_id, l_act_budget_objver;
979: IF (c_budget_request_utilrec%NOTFOUND) THEN
980: CLOSE c_budget_request_utilrec;
981: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
982: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
983: fnd_msg_pub.ADD;
984: END IF;
985: RAISE fnd_api.g_exc_error;

Line 983: fnd_msg_pub.ADD;

979: IF (c_budget_request_utilrec%NOTFOUND) THEN
980: CLOSE c_budget_request_utilrec;
981: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
982: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
983: fnd_msg_pub.ADD;
984: END IF;
985: RAISE fnd_api.g_exc_error;
986: END IF;
987: CLOSE c_budget_request_utilrec;

Line 1672: fnd_msg_pub.ADD;

1668: -- yzhao: 11/20 raise exception if gl posting failed for manual adjust earned amount
1669: IF l_utilization_rec.utilization_type IN ('ADJUSTMENT', 'CHARGEBACK', 'LEAD_ADJUSTMENT') AND
1670: l_utilization_rec.adjustment_type IN ('STANDARD', 'DECREASE_EARNED', 'DECREASE_COMM_EARNED') THEN
1671: fnd_message.set_name ('OZF', 'OZF_GL_POST_FAILURE');
1672: fnd_msg_pub.ADD;
1673: RAISE fnd_api.g_exc_error;
1674: ELSE
1675: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1676: fnd_message.set_name ('OZF', 'OZF_API_DEBUG_MESSAGE');

Line 1675: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

1671: fnd_message.set_name ('OZF', 'OZF_GL_POST_FAILURE');
1672: fnd_msg_pub.ADD;
1673: RAISE fnd_api.g_exc_error;
1674: ELSE
1675: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1676: fnd_message.set_name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1677: fnd_message.set_token ('TEXT', 'Failed to post to GL for utilization id ' || l_utilization_rec.utilization_id);
1678: fnd_msg_pub.ADD;
1679: END IF;

Line 1678: fnd_msg_pub.ADD;

1674: ELSE
1675: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1676: fnd_message.set_name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1677: fnd_message.set_token ('TEXT', 'Failed to post to GL for utilization id ' || l_utilization_rec.utilization_id);
1678: fnd_msg_pub.ADD;
1679: END IF;
1680: END IF;
1681: END IF;
1682: END IF; -- END IF

Line 1794: fnd_msg_pub.count_and_get (

1790: IF fnd_api.to_boolean (p_commit) THEN
1791: COMMIT;
1792: END IF;
1793:
1794: fnd_msg_pub.count_and_get (
1795: p_encoded=> fnd_api.g_false
1796: ,p_count=> x_msg_count
1797: ,p_data=> x_msg_data
1798: );

Line 1807: fnd_msg_pub.count_and_get (

1803: EXCEPTION
1804: WHEN fnd_api.g_exc_error THEN
1805: ROLLBACK TO create_utilization;
1806: x_return_status := fnd_api.g_ret_sts_error;
1807: fnd_msg_pub.count_and_get (
1808: p_encoded=> fnd_api.g_false
1809: ,p_count=> x_msg_count
1810: ,p_data=> x_msg_data
1811: );

Line 1815: fnd_msg_pub.count_and_get (

1811: );
1812: WHEN fnd_api.g_exc_unexpected_error THEN
1813: ROLLBACK TO create_utilization;
1814: x_return_status := fnd_api.g_ret_sts_unexp_error;
1815: fnd_msg_pub.count_and_get (
1816: p_encoded=> fnd_api.g_false
1817: ,p_count=> x_msg_count
1818: ,p_data=> x_msg_data
1819: );

Line 1824: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1820: WHEN OTHERS THEN
1821: ROLLBACK TO create_utilization;
1822: x_return_status := fnd_api.g_ret_sts_unexp_error;
1823:
1824: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1825: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1826: END IF;
1827:
1828: fnd_msg_pub.count_and_get (

Line 1825: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1821: ROLLBACK TO create_utilization;
1822: x_return_status := fnd_api.g_ret_sts_unexp_error;
1823:
1824: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1825: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1826: END IF;
1827:
1828: fnd_msg_pub.count_and_get (
1829: p_encoded=> fnd_api.g_false

Line 1828: fnd_msg_pub.count_and_get (

1824: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1825: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1826: END IF;
1827:
1828: fnd_msg_pub.count_and_get (
1829: p_encoded=> fnd_api.g_false
1830: ,p_count=> x_msg_count
1831: ,p_data=> x_msg_data
1832: );

Line 1867: fnd_msg_pub.initialize;

1863: || ': start');
1864: END IF;
1865:
1866: IF fnd_api.to_boolean (p_init_msg_list) THEN
1867: fnd_msg_pub.initialize;
1868: END IF;
1869:
1870: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1871: RAISE fnd_api.g_exc_unexpected_error;

Line 1887: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

1883: WHERE utilization_id = p_utilization_id
1884: AND object_version_number = p_object_version;
1885:
1886: IF (SQL%NOTFOUND) THEN
1887: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1888: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1889: fnd_msg_pub.ADD;
1890: END IF;
1891:

Line 1889: fnd_msg_pub.ADD;

1885:
1886: IF (SQL%NOTFOUND) THEN
1887: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1888: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1889: fnd_msg_pub.ADD;
1890: END IF;
1891:
1892: RAISE fnd_api.g_exc_error;
1893: END IF;

Line 1899: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

1895: DELETE FROM ozf_funds_utilized_all_tl
1896: WHERE utilization_id = p_utilization_id;
1897:
1898: IF (SQL%NOTFOUND) THEN
1899: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1900: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1901: fnd_msg_pub.ADD;
1902: END IF;
1903:

Line 1901: fnd_msg_pub.ADD;

1897:
1898: IF (SQL%NOTFOUND) THEN
1899: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1900: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1901: fnd_msg_pub.ADD;
1902: END IF;
1903:
1904: RAISE fnd_api.g_exc_error;
1905: END IF;

Line 1913: fnd_msg_pub.count_and_get (

1909: IF fnd_api.to_boolean (p_commit) THEN
1910: COMMIT;
1911: END IF;
1912:
1913: fnd_msg_pub.count_and_get (
1914: p_encoded=> fnd_api.g_false
1915: ,p_count=> x_msg_count
1916: ,p_data=> x_msg_data
1917: );

Line 1926: fnd_msg_pub.count_and_get (

1922: EXCEPTION
1923: WHEN fnd_api.g_exc_error THEN
1924: ROLLBACK TO delete_utilization;
1925: x_return_status := fnd_api.g_ret_sts_error;
1926: fnd_msg_pub.count_and_get (
1927: p_encoded=> fnd_api.g_false
1928: ,p_count=> x_msg_count
1929: ,p_data=> x_msg_data
1930: );

Line 1934: fnd_msg_pub.count_and_get (

1930: );
1931: WHEN fnd_api.g_exc_unexpected_error THEN
1932: ROLLBACK TO delete_utilization;
1933: x_return_status := fnd_api.g_ret_sts_unexp_error;
1934: fnd_msg_pub.count_and_get (
1935: p_encoded=> fnd_api.g_false
1936: ,p_count=> x_msg_count
1937: ,p_data=> x_msg_data
1938: );

Line 1943: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1939: WHEN OTHERS THEN
1940: ROLLBACK TO delete_utilization;
1941: x_return_status := fnd_api.g_ret_sts_unexp_error;
1942:
1943: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1944: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1945: END IF;
1946:
1947: fnd_msg_pub.count_and_get (

Line 1944: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1940: ROLLBACK TO delete_utilization;
1941: x_return_status := fnd_api.g_ret_sts_unexp_error;
1942:
1943: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1944: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1945: END IF;
1946:
1947: fnd_msg_pub.count_and_get (
1948: p_encoded=> fnd_api.g_false

Line 1947: fnd_msg_pub.count_and_get (

1943: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1944: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1945: END IF;
1946:
1947: fnd_msg_pub.count_and_get (
1948: p_encoded=> fnd_api.g_false
1949: ,p_count=> x_msg_count
1950: ,p_data=> x_msg_data
1951: );

Line 2001: fnd_msg_pub.initialize;

1997: || ': start');
1998: END IF;
1999:
2000: IF fnd_api.to_boolean (p_init_msg_list) THEN
2001: fnd_msg_pub.initialize;
2002: END IF;
2003:
2004: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2005: RAISE fnd_api.g_exc_unexpected_error;

Line 2021: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2017:
2018: IF (c_utilization_b%NOTFOUND) THEN
2019: CLOSE c_utilization_b;
2020:
2021: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2022: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2023: fnd_msg_pub.ADD;
2024: END IF;
2025:

Line 2023: fnd_msg_pub.ADD;

2019: CLOSE c_utilization_b;
2020:
2021: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2022: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2023: fnd_msg_pub.ADD;
2024: END IF;
2025:
2026: RAISE fnd_api.g_exc_error;
2027: END IF;

Line 2034: fnd_msg_pub.count_and_get (

2030: OPEN c_utilization_tl;
2031: CLOSE c_utilization_tl;
2032:
2033: -------------------- finish --------------------------
2034: fnd_msg_pub.count_and_get (
2035: p_encoded=> fnd_api.g_false
2036: ,p_count=> x_msg_count
2037: ,p_data=> x_msg_data
2038: );

Line 2047: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2043: EXCEPTION
2044: WHEN ozf_utility_pvt.resource_locked THEN
2045: x_return_status := fnd_api.g_ret_sts_error;
2046:
2047: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2048: fnd_message.set_name ('OZF', 'OZF_API_RESOURCE_LOCKED');
2049: fnd_msg_pub.ADD;
2050: END IF;
2051:

Line 2049: fnd_msg_pub.ADD;

2045: x_return_status := fnd_api.g_ret_sts_error;
2046:
2047: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2048: fnd_message.set_name ('OZF', 'OZF_API_RESOURCE_LOCKED');
2049: fnd_msg_pub.ADD;
2050: END IF;
2051:
2052: fnd_msg_pub.count_and_get (
2053: p_encoded=> fnd_api.g_false

Line 2052: fnd_msg_pub.count_and_get (

2048: fnd_message.set_name ('OZF', 'OZF_API_RESOURCE_LOCKED');
2049: fnd_msg_pub.ADD;
2050: END IF;
2051:
2052: fnd_msg_pub.count_and_get (
2053: p_encoded=> fnd_api.g_false
2054: ,p_count=> x_msg_count
2055: ,p_data=> x_msg_data
2056: );

Line 2059: fnd_msg_pub.count_and_get (

2055: ,p_data=> x_msg_data
2056: );
2057: WHEN fnd_api.g_exc_error THEN
2058: x_return_status := fnd_api.g_ret_sts_error;
2059: fnd_msg_pub.count_and_get (
2060: p_encoded=> fnd_api.g_false
2061: ,p_count=> x_msg_count
2062: ,p_data=> x_msg_data
2063: );

Line 2066: fnd_msg_pub.count_and_get (

2062: ,p_data=> x_msg_data
2063: );
2064: WHEN fnd_api.g_exc_unexpected_error THEN
2065: x_return_status := fnd_api.g_ret_sts_unexp_error;
2066: fnd_msg_pub.count_and_get (
2067: p_encoded=> fnd_api.g_false
2068: ,p_count=> x_msg_count
2069: ,p_data=> x_msg_data
2070: );

Line 2074: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2070: );
2071: WHEN OTHERS THEN
2072: x_return_status := fnd_api.g_ret_sts_unexp_error;
2073:
2074: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2075: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2076: END IF;
2077:
2078: fnd_msg_pub.count_and_get (

Line 2075: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2071: WHEN OTHERS THEN
2072: x_return_status := fnd_api.g_ret_sts_unexp_error;
2073:
2074: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2075: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2076: END IF;
2077:
2078: fnd_msg_pub.count_and_get (
2079: p_encoded=> fnd_api.g_false

Line 2078: fnd_msg_pub.count_and_get (

2074: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2075: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2076: END IF;
2077:
2078: fnd_msg_pub.count_and_get (
2079: p_encoded=> fnd_api.g_false
2080: ,p_count=> x_msg_count
2081: ,p_data=> x_msg_data
2082: );

Line 2144: fnd_msg_pub.initialize;

2140: || ': start');
2141: END IF;
2142:
2143: IF fnd_api.to_boolean (p_init_msg_list) THEN
2144: fnd_msg_pub.initialize;
2145: END IF;
2146:
2147: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2148: RAISE fnd_api.g_exc_unexpected_error;

Line 2364: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2360: WHERE utilization_id = l_utilization_rec.utilization_id
2361: AND object_version_number = l_utilization_rec.object_version_number;
2362:
2363: IF (SQL%NOTFOUND) THEN
2364: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2365: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2366: fnd_msg_pub.ADD;
2367: END IF;
2368:

Line 2366: fnd_msg_pub.ADD;

2362:
2363: IF (SQL%NOTFOUND) THEN
2364: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2365: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2366: fnd_msg_pub.ADD;
2367: END IF;
2368:
2369: RAISE fnd_api.g_exc_error;
2370: END IF;

Line 2387: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2383: WHERE utilization_id = l_utilization_rec.utilization_id
2384: AND USERENV ('LANG') IN (language, source_lang);
2385:
2386: IF (SQL%NOTFOUND) THEN
2387: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2388: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2389: fnd_msg_pub.ADD;
2390: END IF;
2391:

Line 2389: fnd_msg_pub.ADD;

2385:
2386: IF (SQL%NOTFOUND) THEN
2387: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2388: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2389: fnd_msg_pub.ADD;
2390: END IF;
2391:
2392: RAISE fnd_api.g_exc_error;
2393: END IF;

Line 2401: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2397:
2398: IF (c_fund_b%NOTFOUND) THEN
2399: CLOSE c_fund_b;
2400:
2401: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2402: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2403: fnd_msg_pub.ADD;
2404: END IF;
2405:

Line 2403: fnd_msg_pub.ADD;

2399: CLOSE c_fund_b;
2400:
2401: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2402: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2403: fnd_msg_pub.ADD;
2404: END IF;
2405:
2406: RAISE fnd_api.g_exc_error;
2407: END IF;

Line 2447: fnd_msg_pub.count_and_get (

2443: IF fnd_api.to_boolean (p_commit) THEN
2444: COMMIT;
2445: END IF;
2446:
2447: fnd_msg_pub.count_and_get (
2448: p_encoded=> fnd_api.g_false
2449: ,p_count=> x_msg_count
2450: ,p_data=> x_msg_data
2451: );

Line 2460: fnd_msg_pub.count_and_get (

2456: EXCEPTION
2457: WHEN fnd_api.g_exc_error THEN
2458: ROLLBACK TO update_utilization;
2459: x_return_status := fnd_api.g_ret_sts_error;
2460: fnd_msg_pub.count_and_get (
2461: p_encoded=> fnd_api.g_false
2462: ,p_count=> x_msg_count
2463: ,p_data=> x_msg_data
2464: );

Line 2468: fnd_msg_pub.count_and_get (

2464: );
2465: WHEN fnd_api.g_exc_unexpected_error THEN
2466: ROLLBACK TO update_utilization;
2467: x_return_status := fnd_api.g_ret_sts_unexp_error;
2468: fnd_msg_pub.count_and_get (
2469: p_encoded=> fnd_api.g_false
2470: ,p_count=> x_msg_count
2471: ,p_data=> x_msg_data
2472: );

Line 2477: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2473: WHEN OTHERS THEN
2474: ROLLBACK TO update_utilization;
2475: x_return_status := fnd_api.g_ret_sts_unexp_error;
2476:
2477: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2478: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2479: END IF;
2480:
2481: fnd_msg_pub.count_and_get (

Line 2478: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2474: ROLLBACK TO update_utilization;
2475: x_return_status := fnd_api.g_ret_sts_unexp_error;
2476:
2477: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2478: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2479: END IF;
2480:
2481: fnd_msg_pub.count_and_get (
2482: p_encoded=> fnd_api.g_false

Line 2481: fnd_msg_pub.count_and_get (

2477: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2478: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2479: END IF;
2480:
2481: fnd_msg_pub.count_and_get (
2482: p_encoded=> fnd_api.g_false
2483: ,p_count=> x_msg_count
2484: ,p_data=> x_msg_data
2485: );

Line 2521: fnd_msg_pub.initialize;

2517: || ': start');
2518: END IF;
2519:
2520: IF fnd_api.to_boolean (p_init_msg_list) THEN
2521: fnd_msg_pub.initialize;
2522: END IF;
2523:
2524: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2525: RAISE fnd_api.g_exc_unexpected_error;

Line 2571: fnd_msg_pub.count_and_get (

2567: END IF;
2568:
2569:
2570: -------------------- finish --------------------------
2571: fnd_msg_pub.count_and_get (
2572: p_encoded=> fnd_api.g_false
2573: ,p_count=> x_msg_count
2574: ,p_data=> x_msg_data
2575: );

Line 2583: fnd_msg_pub.count_and_get (

2579: END IF;
2580: EXCEPTION
2581: WHEN fnd_api.g_exc_error THEN
2582: x_return_status := fnd_api.g_ret_sts_error;
2583: fnd_msg_pub.count_and_get (
2584: p_encoded=> fnd_api.g_false
2585: ,p_count=> x_msg_count
2586: ,p_data=> x_msg_data
2587: );

Line 2590: fnd_msg_pub.count_and_get (

2586: ,p_data=> x_msg_data
2587: );
2588: WHEN fnd_api.g_exc_unexpected_error THEN
2589: x_return_status := fnd_api.g_ret_sts_unexp_error;
2590: fnd_msg_pub.count_and_get (
2591: p_encoded=> fnd_api.g_false
2592: ,p_count=> x_msg_count
2593: ,p_data=> x_msg_data
2594: );

Line 2598: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2594: );
2595: WHEN OTHERS THEN
2596: x_return_status := fnd_api.g_ret_sts_unexp_error;
2597:
2598: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2599: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2600: END IF;
2601:
2602: fnd_msg_pub.count_and_get (

Line 2599: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2595: WHEN OTHERS THEN
2596: x_return_status := fnd_api.g_ret_sts_unexp_error;
2597:
2598: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2599: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2600: END IF;
2601:
2602: fnd_msg_pub.count_and_get (
2603: p_encoded=> fnd_api.g_false

Line 2602: fnd_msg_pub.count_and_get (

2598: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2599: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2600: END IF;
2601:
2602: fnd_msg_pub.count_and_get (
2603: p_encoded=> fnd_api.g_false
2604: ,p_count=> x_msg_count
2605: ,p_data=> x_msg_data
2606: );

Line 2629: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2625:
2626:
2627: ------------------------ fund_id --------------------------
2628: IF p_utilization_rec.fund_id IS NULL THEN -- check for fund id
2629: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2630: fnd_message.set_name ('OZF', 'OZF_NO_FUND_ID');
2631: fnd_msg_pub.ADD;
2632: END IF;
2633:

Line 2631: fnd_msg_pub.ADD;

2627: ------------------------ fund_id --------------------------
2628: IF p_utilization_rec.fund_id IS NULL THEN -- check for fund id
2629: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2630: fnd_message.set_name ('OZF', 'OZF_NO_FUND_ID');
2631: fnd_msg_pub.ADD;
2632: END IF;
2633:
2634: x_return_status := fnd_api.g_ret_sts_error;
2635: RETURN;

Line 2639: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2635: RETURN;
2636:
2637: ------------------------ AMOUNT -------------------------------
2638: ELSIF p_utilization_rec.amount IS NULL THEN -- check for amount
2639: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2640: fnd_message.set_name ('OZF', 'OZF_NO_UTILIZED_AMOUNT');
2641: fnd_msg_pub.ADD;
2642: END IF;
2643:

Line 2641: fnd_msg_pub.ADD;

2637: ------------------------ AMOUNT -------------------------------
2638: ELSIF p_utilization_rec.amount IS NULL THEN -- check for amount
2639: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2640: fnd_message.set_name ('OZF', 'OZF_NO_UTILIZED_AMOUNT');
2641: fnd_msg_pub.ADD;
2642: END IF;
2643:
2644: x_return_status := fnd_api.g_ret_sts_error;
2645: RETURN;

Line 2648: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2644: x_return_status := fnd_api.g_ret_sts_error;
2645: RETURN;
2646: ELSIF p_utilization_rec.utilization_type IN ('ADJUSTMENT', 'CHARGEBACK', 'LEAD_ADJUSTMENT') THEN
2647: IF p_utilization_rec.adjustment_type IS NULL THEN -- check for utilization
2648: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2649: fnd_message.set_name ('OZF', 'OZF_FUND_NO_ADJUSTMENT_TYPE');
2650: fnd_msg_pub.ADD;
2651: END IF;
2652:

Line 2650: fnd_msg_pub.ADD;

2646: ELSIF p_utilization_rec.utilization_type IN ('ADJUSTMENT', 'CHARGEBACK', 'LEAD_ADJUSTMENT') THEN
2647: IF p_utilization_rec.adjustment_type IS NULL THEN -- check for utilization
2648: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2649: fnd_message.set_name ('OZF', 'OZF_FUND_NO_ADJUSTMENT_TYPE');
2650: fnd_msg_pub.ADD;
2651: END IF;
2652:
2653: x_return_status := fnd_api.g_ret_sts_error;
2654: RETURN;

Line 2659: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2655: END IF;
2656: -- added for customer id for offers 8/14/2002 mpande
2657: IF p_utilization_rec.adjustment_type IN ('DECREASE_EARNED' ,'DECREASE_COMM_EARNED','STANDARD')
2658: AND p_utilization_rec.plan_type = 'OFFR' AND p_utilization_rec.cust_account_id IS NULL THEN -- check for utilization type
2659: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2660: fnd_message.set_name ('OZF', 'OZF_FUND_NO_CUST_ID');
2661: fnd_msg_pub.ADD;
2662: END IF;
2663: x_return_status := fnd_api.g_ret_sts_error;

Line 2661: fnd_msg_pub.ADD;

2657: IF p_utilization_rec.adjustment_type IN ('DECREASE_EARNED' ,'DECREASE_COMM_EARNED','STANDARD')
2658: AND p_utilization_rec.plan_type = 'OFFR' AND p_utilization_rec.cust_account_id IS NULL THEN -- check for utilization type
2659: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2660: fnd_message.set_name ('OZF', 'OZF_FUND_NO_CUST_ID');
2661: fnd_msg_pub.ADD;
2662: END IF;
2663: x_return_status := fnd_api.g_ret_sts_error;
2664: RETURN;
2665: END IF;

Line 2667: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2663: x_return_status := fnd_api.g_ret_sts_error;
2664: RETURN;
2665: END IF;
2666: ELSIF p_utilization_rec.utilization_type IS NULL THEN -- check for utilization type
2667: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2668: fnd_message.set_name ('OZF', 'OZF_FUND_NO_UTILIZATION_TYPE');
2669: fnd_msg_pub.ADD;
2670: END IF;
2671:

Line 2669: fnd_msg_pub.ADD;

2665: END IF;
2666: ELSIF p_utilization_rec.utilization_type IS NULL THEN -- check for utilization type
2667: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2668: fnd_message.set_name ('OZF', 'OZF_FUND_NO_UTILIZATION_TYPE');
2669: fnd_msg_pub.ADD;
2670: END IF;
2671:
2672: x_return_status := fnd_api.g_ret_sts_error;
2673: RETURN;

Line 2706: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2702: 'ozf_funds_UTILIZED_all_b'
2703: , 'utilization_id = '
2704: || p_utilization_rec.utilization_id
2705: ) = fnd_api.g_false THEN
2706: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2707: fnd_message.set_name ('OZF', 'OZF_UTILIZED_DUPLICATE_ID');
2708: fnd_msg_pub.ADD;
2709: END IF;
2710:

Line 2708: fnd_msg_pub.ADD;

2704: || p_utilization_rec.utilization_id
2705: ) = fnd_api.g_false THEN
2706: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2707: fnd_message.set_name ('OZF', 'OZF_UTILIZED_DUPLICATE_ID');
2708: fnd_msg_pub.ADD;
2709: END IF;
2710:
2711: x_return_status := fnd_api.g_ret_sts_error;
2712: RETURN;

Line 2747: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2743: 'fund_id'
2744: , -- Column name in the parent object that maps to the fk value
2745: p_utilization_rec.fund_id -- Value of fk to be validated against the parent object's pk column
2746: ) = fnd_api.g_false THEN
2747: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2748: fnd_message.set_name ('OZF', 'OZF_BAD_FUND_ID');
2749: fnd_msg_pub.ADD;
2750: END IF;
2751:

Line 2749: fnd_msg_pub.ADD;

2745: p_utilization_rec.fund_id -- Value of fk to be validated against the parent object's pk column
2746: ) = fnd_api.g_false THEN
2747: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2748: fnd_message.set_name ('OZF', 'OZF_BAD_FUND_ID');
2749: fnd_msg_pub.ADD;
2750: END IF;
2751:
2752: x_return_status := fnd_api.g_ret_sts_error;
2753: RETURN;

Line 2766: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2762: 'claim_type_id'
2763: , -- Column name in the parent object that maps to the fk value
2764: p_utilization_rec.adjustment_type_id -- Value of fk to be validated against the parent object's pk column
2765: ) = fnd_api.g_false THEN
2766: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2767: fnd_message.set_name ('OZF', 'OZFBAD_ADJUSTMENT_ID');
2768: fnd_msg_pub.ADD;
2769: END IF;
2770:

Line 2768: fnd_msg_pub.ADD;

2764: p_utilization_rec.adjustment_type_id -- Value of fk to be validated against the parent object's pk column
2765: ) = fnd_api.g_false THEN
2766: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2767: fnd_message.set_name ('OZF', 'OZFBAD_ADJUSTMENT_ID');
2768: fnd_msg_pub.ADD;
2769: END IF;
2770:
2771: x_return_status := fnd_api.g_ret_sts_error;
2772: RETURN;

Line 2807: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2803: p_lookup_table_name=> 'OZF_LOOKUPS'
2804: ,p_lookup_type=> 'OZF_UTILIZATION_TYPE'
2805: ,p_lookup_code=> p_utilization_rec.utilization_type
2806: ) = fnd_api.g_false THEN
2807: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2808: fnd_message.set_name ('OZF', 'OZF_BAD_UTILIZED_CODE');
2809: fnd_msg_pub.ADD;
2810: END IF;
2811:

Line 2809: fnd_msg_pub.ADD;

2805: ,p_lookup_code=> p_utilization_rec.utilization_type
2806: ) = fnd_api.g_false THEN
2807: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2808: fnd_message.set_name ('OZF', 'OZF_BAD_UTILIZED_CODE');
2809: fnd_msg_pub.ADD;
2810: END IF;
2811:
2812: x_return_status := fnd_api.g_ret_sts_error;
2813: RETURN;

Line 2824: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2820: p_lookup_table_name=> 'OZF_LOOKUPS'
2821: ,p_lookup_type=> 'OZF_ADJUSTMENT_TYPE'
2822: ,p_lookup_code=> p_utilization_rec.adjustment_type
2823: ) = fnd_api.g_false THEN
2824: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2825: fnd_message.set_name ('OZF', 'OZF_BAD_ADJUSTMENT_CODE');
2826: fnd_msg_pub.ADD;
2827: END IF;
2828:

Line 2826: fnd_msg_pub.ADD;

2822: ,p_lookup_code=> p_utilization_rec.adjustment_type
2823: ) = fnd_api.g_false THEN
2824: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2825: fnd_message.set_name ('OZF', 'OZF_BAD_ADJUSTMENT_CODE');
2826: fnd_msg_pub.ADD;
2827: END IF;
2828:
2829: x_return_status := fnd_api.g_ret_sts_error;
2830: RETURN;

Line 3216: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3212: ,p_complete_rec.plan_type
3213: ,p_complete_rec.fund_id
3214: ,p_complete_rec.component_id
3215: ) = fnd_api.g_false THEN
3216: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3217: fnd_message.set_name ('OZF', 'OZF_FUND_NO_COMMITTMENT');
3218: fnd_msg_pub.ADD;
3219: END IF;
3220:

Line 3218: fnd_msg_pub.ADD;

3214: ,p_complete_rec.component_id
3215: ) = fnd_api.g_false THEN
3216: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3217: fnd_message.set_name ('OZF', 'OZF_FUND_NO_COMMITTMENT');
3218: fnd_msg_pub.ADD;
3219: END IF;
3220:
3221: x_return_status := fnd_api.g_ret_sts_error;
3222: RETURN;

Line 3228: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3224: END IF;
3225:
3226:
3227: IF check_fund_active (p_complete_rec.fund_id) = fnd_api.g_false THEN
3228: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3229: fnd_message.set_name ('OZF', 'OZF_FUND_NO_ADJUST');
3230: fnd_msg_pub.ADD;
3231: END IF;
3232: x_return_status := fnd_api.g_ret_sts_error;

Line 3230: fnd_msg_pub.ADD;

3226:
3227: IF check_fund_active (p_complete_rec.fund_id) = fnd_api.g_false THEN
3228: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3229: fnd_message.set_name ('OZF', 'OZF_FUND_NO_ADJUST');
3230: fnd_msg_pub.ADD;
3231: END IF;
3232: x_return_status := fnd_api.g_ret_sts_error;
3233: RETURN;
3234: END IF;

Line 3242: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3238: IF l_dummy IS NULL THEN
3239: IF p_complete_rec.adjustment_type = ('DECREASE_EARNED') THEN
3240: -- amount should be positive always
3241: IF NVL (p_complete_rec.amount, 0) <= 0 THEN
3242: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3243: fnd_message.set_name ('OZF', 'OZF_UTIL_NO_AMOUNT');
3244: fnd_msg_pub.ADD;
3245: END IF;
3246:

Line 3244: fnd_msg_pub.ADD;

3240: -- amount should be positive always
3241: IF NVL (p_complete_rec.amount, 0) <= 0 THEN
3242: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3243: fnd_message.set_name ('OZF', 'OZF_UTIL_NO_AMOUNT');
3244: fnd_msg_pub.ADD;
3245: END IF;
3246:
3247: x_return_status := fnd_api.g_ret_sts_error;
3248: RETURN;

Line 3252: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3248: RETURN;
3249: END IF;
3250: ELSE
3251: IF NVL (p_complete_rec.amount, 0) = 0 THEN
3252: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3253: fnd_message.set_name ('OZF', 'OZF_UTIL_NO_AMOUNT');
3254: fnd_msg_pub.ADD;
3255: END IF;
3256:

Line 3254: fnd_msg_pub.ADD;

3250: ELSE
3251: IF NVL (p_complete_rec.amount, 0) = 0 THEN
3252: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3253: fnd_message.set_name ('OZF', 'OZF_UTIL_NO_AMOUNT');
3254: fnd_msg_pub.ADD;
3255: END IF;
3256:
3257: x_return_status := fnd_api.g_ret_sts_error;
3258: RETURN;

Line 3308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3304:
3305: IF c_utilization%NOTFOUND THEN
3306: CLOSE c_utilization;
3307:
3308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3309: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
3310: fnd_msg_pub.ADD;
3311: END IF;
3312:

Line 3310: fnd_msg_pub.ADD;

3306: CLOSE c_utilization;
3307:
3308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3309: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
3310: fnd_msg_pub.ADD;
3311: END IF;
3312:
3313: RAISE fnd_api.g_exc_error;
3314: END IF;

Line 3886: fnd_msg_pub.initialize;

3882: || ': start');
3883: END IF;
3884:
3885: IF fnd_api.to_boolean (p_init_msg_list) THEN
3886: fnd_msg_pub.initialize;
3887: END IF;
3888:
3889: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3890: RAISE fnd_api.g_exc_unexpected_error;

Line 4001: fnd_msg_pub.count_and_get (

3997: IF fnd_api.to_boolean (p_commit) THEN
3998: COMMIT;
3999: END IF;
4000:
4001: fnd_msg_pub.count_and_get (
4002: p_encoded=> fnd_api.g_false
4003: ,p_count=> x_msg_count
4004: ,p_data=> x_msg_data
4005: );

Line 4015: fnd_msg_pub.count_and_get (

4011: EXCEPTION
4012: WHEN fnd_api.g_exc_error THEN
4013: ROLLBACK TO create_act_utilization;
4014: x_return_status := fnd_api.g_ret_sts_error;
4015: fnd_msg_pub.count_and_get (
4016: p_encoded=> fnd_api.g_false
4017: ,p_count=> x_msg_count
4018: ,p_data=> x_msg_data
4019: );

Line 4023: fnd_msg_pub.count_and_get (

4019: );
4020: WHEN fnd_api.g_exc_unexpected_error THEN
4021: ROLLBACK TO create_act_utilization;
4022: x_return_status := fnd_api.g_ret_sts_unexp_error;
4023: fnd_msg_pub.count_and_get (
4024: p_encoded=> fnd_api.g_false
4025: ,p_count=> x_msg_count
4026: ,p_data=> x_msg_data
4027: );

Line 4032: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

4028: WHEN OTHERS THEN
4029: ROLLBACK TO create_act_utilization;
4030: x_return_status := fnd_api.g_ret_sts_unexp_error;
4031:
4032: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4033: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4034: END IF;
4035:
4036: fnd_msg_pub.count_and_get (

Line 4033: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

4029: ROLLBACK TO create_act_utilization;
4030: x_return_status := fnd_api.g_ret_sts_unexp_error;
4031:
4032: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4033: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4034: END IF;
4035:
4036: fnd_msg_pub.count_and_get (
4037: p_encoded=> fnd_api.g_false

Line 4036: fnd_msg_pub.count_and_get (

4032: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4033: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4034: END IF;
4035:
4036: fnd_msg_pub.count_and_get (
4037: p_encoded=> fnd_api.g_false
4038: ,p_count=> x_msg_count
4039: ,p_data=> x_msg_data
4040: );