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_FUNDRULES_PVT dependencies on FND_MSG_PUB

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

1: PACKAGE BODY ozf_fundrules_pvt AS
2: /* $Header: ozfvfrub.pls 120.5 2006/05/11 22:11:29 asylvia ship $ */
3: g_pkg_name CONSTANT VARCHAR2(30) := 'Ozf_FundRules_PVT';
4: g_file_name CONSTANT VARCHAR2(30) := 'ozfvfrub.pls';
5: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
6:
7:
8: ---------------------------------------------------------------------
9: -- PROCEDURE

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

114: IF NVL(l_coverted_orig_budget, 0) >
115: (NVL(l_par_original_budget, 0) +
116: NVL(l_par_trans_in_budget, 0) -
117: NVL(l_par_trans_out_budget, 0)) THEN
118: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
119: IF l_parent_fund_type = 'QUOTA' THEN
120: fnd_message.set_name('OZF', 'OZF_CHILD_EXCESS_QUOTA');
121: ELSE
122: fnd_message.set_name('OZF', 'OZF_CHILD_EXCESS_BUDGET');

Line 124: fnd_msg_pub.ADD;

120: fnd_message.set_name('OZF', 'OZF_CHILD_EXCESS_QUOTA');
121: ELSE
122: fnd_message.set_name('OZF', 'OZF_CHILD_EXCESS_BUDGET');
123: END IF;
124: fnd_msg_pub.ADD;
125: END IF;
126:
127: x_return_status := fnd_api.g_ret_sts_error;
128: END IF;

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

164: FETCH c_parent_type INTO l_parent_fund_type;
165: CLOSE c_parent_type;
166:
167: IF p_fund_type <> l_parent_fund_type THEN
168: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
169: IF p_fund_type = 'QUOTA' THEN
170: fnd_message.set_name('OZF', 'OZF_TP_CHILD_WRONG_QUOTA_TYPE');
171: ELSE
172: fnd_message.set_name('OZF', 'OZF_CHILD_WRONG_FUND_TYPE');

Line 174: fnd_msg_pub.ADD;

170: fnd_message.set_name('OZF', 'OZF_TP_CHILD_WRONG_QUOTA_TYPE');
171: ELSE
172: fnd_message.set_name('OZF', 'OZF_CHILD_WRONG_FUND_TYPE');
173: END IF;
174: fnd_msg_pub.ADD;
175: END IF;
176: x_return_status := fnd_api.g_ret_sts_error;
177: END IF;
178: END check_fund_type_vs_parent;

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

217:
218: IF p_status_code = 'ACTIVE' THEN
219: -- Check parent fund status
220: IF l_parent_fund_status <> 'ACTIVE' THEN
221: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
222: IF l_parent_fund_type = 'QUOTA' THEN
223: fnd_message.set_name('OZF', 'OZF_TP_ACTIVATE_QUOTA_PARENT');
224: ELSE
225: fnd_message.set_name('OZF', 'OZF_ACTIVATE_FUND_PARENT');

Line 227: fnd_msg_pub.ADD;

223: fnd_message.set_name('OZF', 'OZF_TP_ACTIVATE_QUOTA_PARENT');
224: ELSE
225: fnd_message.set_name('OZF', 'OZF_ACTIVATE_FUND_PARENT');
226: END IF;
227: fnd_msg_pub.ADD;
228: END IF;
229:
230: x_return_status := fnd_api.g_ret_sts_error;
231: END IF;

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

231: END IF;
232: ELSIF p_status_code = 'ON_HOLD' THEN
233: -- Check parent fund status
234: IF l_parent_fund_status NOT IN ('ON_HOLD', 'ACTIVE') THEN
235: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
236: IF l_parent_fund_type = 'QUOTA' THEN
237: fnd_message.set_name('OZF', 'OZF_TP_ACTIVATE_QUOTA_PARENT');
238: ELSE
239: fnd_message.set_name('OZF', 'OZF_ACTIVATE_FUND_PARENT');

Line 241: fnd_msg_pub.ADD;

237: fnd_message.set_name('OZF', 'OZF_TP_ACTIVATE_QUOTA_PARENT');
238: ELSE
239: fnd_message.set_name('OZF', 'OZF_ACTIVATE_FUND_PARENT');
240: END IF;
241: fnd_msg_pub.ADD;
242: END IF;
243:
244: x_return_status := fnd_api.g_ret_sts_error;
245: END IF; --status_code

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

286:
287: --Check validity of child fund's effectivity dates w.r.t. the parent fund
288: IF p_start_date_active < l_parent_start_date
289: OR p_end_date_active > l_parent_end_date THEN
290: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
291: fnd_message.set_name('OZF', 'OZF_CHILD_ILLEGAL_DATE');
292: fnd_msg_pub.ADD;
293: END IF;
294:

Line 292: fnd_msg_pub.ADD;

288: IF p_start_date_active < l_parent_start_date
289: OR p_end_date_active > l_parent_end_date THEN
290: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
291: fnd_message.set_name('OZF', 'OZF_CHILD_ILLEGAL_DATE');
292: fnd_msg_pub.ADD;
293: END IF;
294:
295: x_return_status := fnd_api.g_ret_sts_error;
296: END IF;

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

331: FETCH c_parent_curr INTO l_parent_fund_curr;
332: CLOSE c_parent_curr;
333:
334: IF p_fund_curr <> l_parent_fund_curr THEN
335: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
336: fnd_message.set_name('OZF', 'OZF_CHILD_ILLEGAL_CURRENCY');
337: fnd_msg_pub.ADD;
338: END IF;
339:

Line 337: fnd_msg_pub.ADD;

333:
334: IF p_fund_curr <> l_parent_fund_curr THEN
335: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
336: fnd_message.set_name('OZF', 'OZF_CHILD_ILLEGAL_CURRENCY');
337: fnd_msg_pub.ADD;
338: END IF;
339:
340: x_return_status := fnd_api.g_ret_sts_error;
341: END IF;

Line 1229: fnd_msg_pub.count_and_get(

1225: EXCEPTION
1226: WHEN fnd_api.g_exc_error THEN
1227: ROLLBACK TO process_offers;
1228: x_return_status := fnd_api.g_ret_sts_error;
1229: fnd_msg_pub.count_and_get(
1230: p_encoded=> fnd_api.g_false,
1231: p_count=> x_msg_count,
1232: p_data=> x_msg_data);
1233: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1236: fnd_msg_pub.count_and_get(

1232: p_data=> x_msg_data);
1233: WHEN fnd_api.g_exc_unexpected_error THEN
1234: ROLLBACK TO process_offers;
1235: x_return_status := fnd_api.g_ret_sts_unexp_error;
1236: fnd_msg_pub.count_and_get(
1237: p_encoded=> fnd_api.g_false,
1238: p_count=> x_msg_count,
1239: p_data=> x_msg_data);
1240: WHEN OTHERS THEN

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

1240: WHEN OTHERS THEN
1241: ROLLBACK TO process_offers;
1242: x_return_status := fnd_api.g_ret_sts_unexp_error;
1243:
1244: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1245: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1246: END IF;
1247:
1248: fnd_msg_pub.count_and_get(

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

1241: ROLLBACK TO process_offers;
1242: x_return_status := fnd_api.g_ret_sts_unexp_error;
1243:
1244: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1245: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1246: END IF;
1247:
1248: fnd_msg_pub.count_and_get(
1249: p_encoded=> fnd_api.g_false,

Line 1248: fnd_msg_pub.count_and_get(

1244: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1245: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1246: END IF;
1247:
1248: fnd_msg_pub.count_and_get(
1249: p_encoded=> fnd_api.g_false,
1250: p_count=> x_msg_count,
1251: p_data=> x_msg_data);
1252: END process_offers;

Line 1355: fnd_msg_pub.count_and_get(

1351: EXCEPTION
1352: WHEN fnd_api.g_exc_error THEN
1353: ROLLBACK TO process_approval;
1354: x_return_status := fnd_api.g_ret_sts_error;
1355: fnd_msg_pub.count_and_get(
1356: p_encoded=> fnd_api.g_false,
1357: p_count=> x_msg_count,
1358: p_data=> x_msg_data);
1359: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1362: fnd_msg_pub.count_and_get(

1358: p_data=> x_msg_data);
1359: WHEN fnd_api.g_exc_unexpected_error THEN
1360: ROLLBACK TO process_approval;
1361: x_return_status := fnd_api.g_ret_sts_unexp_error;
1362: fnd_msg_pub.count_and_get(
1363: p_encoded=> fnd_api.g_false,
1364: p_count=> x_msg_count,
1365: p_data=> x_msg_data);
1366: WHEN OTHERS THEN

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

1366: WHEN OTHERS THEN
1367: ROLLBACK TO process_approval;
1368: x_return_status := fnd_api.g_ret_sts_unexp_error;
1369:
1370: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1371: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1372: END IF;
1373:
1374: fnd_msg_pub.count_and_get(

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

1367: ROLLBACK TO process_approval;
1368: x_return_status := fnd_api.g_ret_sts_unexp_error;
1369:
1370: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1371: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1372: END IF;
1373:
1374: fnd_msg_pub.count_and_get(
1375: p_encoded=> fnd_api.g_false,

Line 1374: fnd_msg_pub.count_and_get(

1370: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1371: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1372: END IF;
1373:
1374: fnd_msg_pub.count_and_get(
1375: p_encoded=> fnd_api.g_false,
1376: p_count=> x_msg_count,
1377: p_data=> x_msg_data);
1378: END process_approval;

Line 1486: fnd_msg_pub.count_and_get(

1482: END IF;
1483: EXCEPTION
1484: WHEN OTHERS THEN
1485: x_return_status := fnd_api.g_ret_sts_unexp_error;
1486: fnd_msg_pub.count_and_get(
1487: p_encoded => fnd_api.g_false
1488: ,p_count => x_msg_count
1489: ,p_data => x_msg_data);
1490: END check_fund_before_close;

Line 1662: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1658: */
1659: IF (l_fund_type = 'FULLY_ACCRUED') THEN
1660: l_list_line := ozf_offer_pvt.discount_lines_exist(p_list_header_id => l_plan_id);
1661: IF l_list_line <> 0 THEN
1662: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1663: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_NO_DISC_LINES');
1664: FND_MSG_PUB.add;
1665: END IF;
1666: RAISE FND_API.g_exc_error;

Line 1664: FND_MSG_PUB.add;

1660: l_list_line := ozf_offer_pvt.discount_lines_exist(p_list_header_id => l_plan_id);
1661: IF l_list_line <> 0 THEN
1662: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1663: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_NO_DISC_LINES');
1664: FND_MSG_PUB.add;
1665: END IF;
1666: RAISE FND_API.g_exc_error;
1667: END IF;
1668: END IF;

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

1683:
1684: IF (c_parent_fund_owner%NOTFOUND) THEN
1685: CLOSE c_parent_fund_owner;
1686:
1687: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1688: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1689: fnd_msg_pub.ADD;
1690: END IF;
1691:

Line 1689: fnd_msg_pub.ADD;

1685: CLOSE c_parent_fund_owner;
1686:
1687: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1688: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1689: fnd_msg_pub.ADD;
1690: END IF;
1691:
1692: RAISE fnd_api.g_exc_error;
1693: END IF;

Line 1835: fnd_msg_pub.count_and_get(

1831: EXCEPTION
1832: WHEN fnd_api.g_exc_error THEN
1833: ROLLBACK TO update_fund_status;
1834: x_return_status := fnd_api.g_ret_sts_error;
1835: fnd_msg_pub.count_and_get(
1836: p_encoded=> fnd_api.g_false,
1837: p_count=> x_msg_count,
1838: p_data=> x_msg_data);
1839: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1842: fnd_msg_pub.count_and_get(

1838: p_data=> x_msg_data);
1839: WHEN fnd_api.g_exc_unexpected_error THEN
1840: ROLLBACK TO update_fund_status;
1841: x_return_status := fnd_api.g_ret_sts_unexp_error;
1842: fnd_msg_pub.count_and_get(
1843: p_encoded=> fnd_api.g_false,
1844: p_count=> x_msg_count,
1845: p_data=> x_msg_data);
1846: WHEN OTHERS THEN

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

1846: WHEN OTHERS THEN
1847: ROLLBACK TO update_fund_status;
1848: x_return_status := fnd_api.g_ret_sts_unexp_error;
1849:
1850: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1851: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1852: END IF;
1853:
1854: fnd_msg_pub.count_and_get(

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

1847: ROLLBACK TO update_fund_status;
1848: x_return_status := fnd_api.g_ret_sts_unexp_error;
1849:
1850: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1851: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1852: END IF;
1853:
1854: fnd_msg_pub.count_and_get(
1855: p_encoded=> fnd_api.g_false,

Line 1854: fnd_msg_pub.count_and_get(

1850: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1851: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1852: END IF;
1853:
1854: fnd_msg_pub.count_and_get(
1855: p_encoded=> fnd_api.g_false,
1856: p_count=> x_msg_count,
1857: p_data=> x_msg_data);
1858: END update_fund_status;

Line 1941: fnd_msg_pub.count_and_get(

1937: EXCEPTION
1938: WHEN fnd_api.g_exc_error THEN
1939: ROLLBACK TO process_accrual;
1940: x_return_status := fnd_api.g_ret_sts_error;
1941: fnd_msg_pub.count_and_get(
1942: p_encoded=> fnd_api.g_false,
1943: p_count=> x_msg_count,
1944: p_data=> x_msg_data);
1945: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1948: fnd_msg_pub.count_and_get(

1944: p_data=> x_msg_data);
1945: WHEN fnd_api.g_exc_unexpected_error THEN
1946: ROLLBACK TO process_accrual;
1947: x_return_status := fnd_api.g_ret_sts_unexp_error;
1948: fnd_msg_pub.count_and_get(
1949: p_encoded=> fnd_api.g_false,
1950: p_count=> x_msg_count,
1951: p_data=> x_msg_data);
1952: WHEN OTHERS THEN

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

1952: WHEN OTHERS THEN
1953: ROLLBACK TO process_accrual;
1954: x_return_status := fnd_api.g_ret_sts_unexp_error;
1955:
1956: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1957: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1958: END IF;
1959:
1960: fnd_msg_pub.count_and_get(

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

1953: ROLLBACK TO process_accrual;
1954: x_return_status := fnd_api.g_ret_sts_unexp_error;
1955:
1956: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1957: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1958: END IF;
1959:
1960: fnd_msg_pub.count_and_get(
1961: p_encoded=> fnd_api.g_false,

Line 1960: fnd_msg_pub.count_and_get(

1956: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1957: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1958: END IF;
1959:
1960: fnd_msg_pub.count_and_get(
1961: p_encoded=> fnd_api.g_false,
1962: p_count=> x_msg_count,
1963: p_data=> x_msg_data);
1964: END process_accrual;