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.7.12020000.2 2013/02/22 13:49:35 bchaturv 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 1278: fnd_msg_pub.count_and_get(

1274: EXCEPTION
1275: WHEN fnd_api.g_exc_error THEN
1276: ROLLBACK TO process_offers;
1277: x_return_status := fnd_api.g_ret_sts_error;
1278: fnd_msg_pub.count_and_get(
1279: p_encoded=> fnd_api.g_false,
1280: p_count=> x_msg_count,
1281: p_data=> x_msg_data);
1282: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1285: fnd_msg_pub.count_and_get(

1281: p_data=> x_msg_data);
1282: WHEN fnd_api.g_exc_unexpected_error THEN
1283: ROLLBACK TO process_offers;
1284: x_return_status := fnd_api.g_ret_sts_unexp_error;
1285: fnd_msg_pub.count_and_get(
1286: p_encoded=> fnd_api.g_false,
1287: p_count=> x_msg_count,
1288: p_data=> x_msg_data);
1289: WHEN OTHERS THEN

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

1289: WHEN OTHERS THEN
1290: ROLLBACK TO process_offers;
1291: x_return_status := fnd_api.g_ret_sts_unexp_error;
1292:
1293: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1294: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1295: END IF;
1296:
1297: fnd_msg_pub.count_and_get(

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

1290: ROLLBACK TO process_offers;
1291: x_return_status := fnd_api.g_ret_sts_unexp_error;
1292:
1293: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1294: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1295: END IF;
1296:
1297: fnd_msg_pub.count_and_get(
1298: p_encoded=> fnd_api.g_false,

Line 1297: fnd_msg_pub.count_and_get(

1293: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1294: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1295: END IF;
1296:
1297: fnd_msg_pub.count_and_get(
1298: p_encoded=> fnd_api.g_false,
1299: p_count=> x_msg_count,
1300: p_data=> x_msg_data);
1301: END process_offers;

Line 1404: fnd_msg_pub.count_and_get(

1400: EXCEPTION
1401: WHEN fnd_api.g_exc_error THEN
1402: ROLLBACK TO process_approval;
1403: x_return_status := fnd_api.g_ret_sts_error;
1404: fnd_msg_pub.count_and_get(
1405: p_encoded=> fnd_api.g_false,
1406: p_count=> x_msg_count,
1407: p_data=> x_msg_data);
1408: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1411: fnd_msg_pub.count_and_get(

1407: p_data=> x_msg_data);
1408: WHEN fnd_api.g_exc_unexpected_error THEN
1409: ROLLBACK TO process_approval;
1410: x_return_status := fnd_api.g_ret_sts_unexp_error;
1411: fnd_msg_pub.count_and_get(
1412: p_encoded=> fnd_api.g_false,
1413: p_count=> x_msg_count,
1414: p_data=> x_msg_data);
1415: WHEN OTHERS THEN

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

1415: WHEN OTHERS THEN
1416: ROLLBACK TO process_approval;
1417: x_return_status := fnd_api.g_ret_sts_unexp_error;
1418:
1419: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1420: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1421: END IF;
1422:
1423: fnd_msg_pub.count_and_get(

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

1416: ROLLBACK TO process_approval;
1417: x_return_status := fnd_api.g_ret_sts_unexp_error;
1418:
1419: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1420: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1421: END IF;
1422:
1423: fnd_msg_pub.count_and_get(
1424: p_encoded=> fnd_api.g_false,

Line 1423: fnd_msg_pub.count_and_get(

1419: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1420: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1421: END IF;
1422:
1423: fnd_msg_pub.count_and_get(
1424: p_encoded=> fnd_api.g_false,
1425: p_count=> x_msg_count,
1426: p_data=> x_msg_data);
1427: END process_approval;

Line 1535: fnd_msg_pub.count_and_get(

1531: END IF;
1532: EXCEPTION
1533: WHEN OTHERS THEN
1534: x_return_status := fnd_api.g_ret_sts_unexp_error;
1535: fnd_msg_pub.count_and_get(
1536: p_encoded => fnd_api.g_false
1537: ,p_count => x_msg_count
1538: ,p_data => x_msg_data);
1539: END check_fund_before_close;

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

1707: */
1708: IF (l_fund_type = 'FULLY_ACCRUED') THEN
1709: l_list_line := ozf_offer_pvt.discount_lines_exist(p_list_header_id => l_plan_id);
1710: IF l_list_line <> 0 THEN
1711: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1712: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_NO_DISC_LINES');
1713: FND_MSG_PUB.add;
1714: END IF;
1715: RAISE FND_API.g_exc_error;

Line 1713: FND_MSG_PUB.add;

1709: l_list_line := ozf_offer_pvt.discount_lines_exist(p_list_header_id => l_plan_id);
1710: IF l_list_line <> 0 THEN
1711: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1712: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_NO_DISC_LINES');
1713: FND_MSG_PUB.add;
1714: END IF;
1715: RAISE FND_API.g_exc_error;
1716: END IF;
1717: END IF;

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

1732:
1733: IF (c_parent_fund_owner%NOTFOUND) THEN
1734: CLOSE c_parent_fund_owner;
1735:
1736: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1737: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1738: fnd_msg_pub.ADD;
1739: END IF;
1740:

Line 1738: fnd_msg_pub.ADD;

1734: CLOSE c_parent_fund_owner;
1735:
1736: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1737: fnd_message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1738: fnd_msg_pub.ADD;
1739: END IF;
1740:
1741: RAISE fnd_api.g_exc_error;
1742: END IF;

Line 1884: fnd_msg_pub.count_and_get(

1880: EXCEPTION
1881: WHEN fnd_api.g_exc_error THEN
1882: ROLLBACK TO update_fund_status;
1883: x_return_status := fnd_api.g_ret_sts_error;
1884: fnd_msg_pub.count_and_get(
1885: p_encoded=> fnd_api.g_false,
1886: p_count=> x_msg_count,
1887: p_data=> x_msg_data);
1888: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1891: fnd_msg_pub.count_and_get(

1887: p_data=> x_msg_data);
1888: WHEN fnd_api.g_exc_unexpected_error THEN
1889: ROLLBACK TO update_fund_status;
1890: x_return_status := fnd_api.g_ret_sts_unexp_error;
1891: fnd_msg_pub.count_and_get(
1892: p_encoded=> fnd_api.g_false,
1893: p_count=> x_msg_count,
1894: p_data=> x_msg_data);
1895: WHEN OTHERS THEN

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

1895: WHEN OTHERS THEN
1896: ROLLBACK TO update_fund_status;
1897: x_return_status := fnd_api.g_ret_sts_unexp_error;
1898:
1899: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1900: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1901: END IF;
1902:
1903: fnd_msg_pub.count_and_get(

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

1896: ROLLBACK TO update_fund_status;
1897: x_return_status := fnd_api.g_ret_sts_unexp_error;
1898:
1899: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1900: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1901: END IF;
1902:
1903: fnd_msg_pub.count_and_get(
1904: p_encoded=> fnd_api.g_false,

Line 1903: fnd_msg_pub.count_and_get(

1899: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1900: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1901: END IF;
1902:
1903: fnd_msg_pub.count_and_get(
1904: p_encoded=> fnd_api.g_false,
1905: p_count=> x_msg_count,
1906: p_data=> x_msg_data);
1907: END update_fund_status;

Line 1990: fnd_msg_pub.count_and_get(

1986: EXCEPTION
1987: WHEN fnd_api.g_exc_error THEN
1988: ROLLBACK TO process_accrual;
1989: x_return_status := fnd_api.g_ret_sts_error;
1990: fnd_msg_pub.count_and_get(
1991: p_encoded=> fnd_api.g_false,
1992: p_count=> x_msg_count,
1993: p_data=> x_msg_data);
1994: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1997: fnd_msg_pub.count_and_get(

1993: p_data=> x_msg_data);
1994: WHEN fnd_api.g_exc_unexpected_error THEN
1995: ROLLBACK TO process_accrual;
1996: x_return_status := fnd_api.g_ret_sts_unexp_error;
1997: fnd_msg_pub.count_and_get(
1998: p_encoded=> fnd_api.g_false,
1999: p_count=> x_msg_count,
2000: p_data=> x_msg_data);
2001: WHEN OTHERS THEN

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

2001: WHEN OTHERS THEN
2002: ROLLBACK TO process_accrual;
2003: x_return_status := fnd_api.g_ret_sts_unexp_error;
2004:
2005: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2006: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2007: END IF;
2008:
2009: fnd_msg_pub.count_and_get(

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

2002: ROLLBACK TO process_accrual;
2003: x_return_status := fnd_api.g_ret_sts_unexp_error;
2004:
2005: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2006: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2007: END IF;
2008:
2009: fnd_msg_pub.count_and_get(
2010: p_encoded=> fnd_api.g_false,

Line 2009: fnd_msg_pub.count_and_get(

2005: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2006: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2007: END IF;
2008:
2009: fnd_msg_pub.count_and_get(
2010: p_encoded=> fnd_api.g_false,
2011: p_count=> x_msg_count,
2012: p_data=> x_msg_data);
2013: END process_accrual;