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_ADJUSTMENT_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: ozfvadjb.pls 120.25.12010000.7 2008/10/31 08:45:10 nirprasa ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'OZF_Fund_Adjustment_PVT';
5: g_cons_fund_mode CONSTANT VARCHAR2 (30) := 'WORKFLOW';
6: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
7: g_recal_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('OZF_BUDGET_ADJ_ALLOW_RECAL'),'N');
8:
9: /* =========================================================
10: --tbl_type to hold the object

Line 201: fnd_msg_pub.initialize;

197: ozf_utility_pvt.debug_message (': begin ');
198: END IF;
199:
200: IF fnd_api.to_boolean (p_init_msg_list) THEN
201: fnd_msg_pub.initialize;
202: END IF;
203:
204: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
205: RAISE fnd_api.g_exc_unexpected_error;

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

363: RAISE fnd_api.g_exc_unexpected_error;
364: END IF;
365: --Raise error message if committed amount is less then
366: IF l_util_amount > l_utilized_amount AND l_utilized_amount = 0 THEN
367: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
368: fnd_message.set_name('OZF', 'OZF_COMMAMT_LESS_REQAMT');
369: fnd_msg_pub.ADD;
370: END IF;
371: END IF;

Line 369: fnd_msg_pub.ADD;

365: --Raise error message if committed amount is less then
366: IF l_util_amount > l_utilized_amount AND l_utilized_amount = 0 THEN
367: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
368: fnd_message.set_name('OZF', 'OZF_COMMAMT_LESS_REQAMT');
369: fnd_msg_pub.ADD;
370: END IF;
371: END IF;
372:
373: END IF;

Line 398: fnd_msg_pub.count_and_get (

394: EXCEPTION
395: WHEN fnd_api.g_exc_error THEN
396: ROLLBACK TO create_budget_amt_utilized;
397: x_return_status := fnd_api.g_ret_sts_error;
398: fnd_msg_pub.count_and_get (
399: p_count=> x_msg_count
400: ,p_data=> x_msg_data
401: ,p_encoded=> fnd_api.g_false
402: );

Line 406: fnd_msg_pub.count_and_get (

402: );
403: WHEN fnd_api.g_exc_unexpected_error THEN
404: ROLLBACK TO create_budget_amt_utilized;
405: x_return_status := fnd_api.g_ret_sts_unexp_error;
406: fnd_msg_pub.count_and_get (
407: p_count=> x_msg_count
408: ,p_data=> x_msg_data
409: ,p_encoded=> fnd_api.g_false
410: );

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

411: WHEN OTHERS THEN
412: ROLLBACK TO create_budget_amt_utilized;
413: x_return_status := fnd_api.g_ret_sts_unexp_error;
414:
415: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
416: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
417: END IF;
418:
419: fnd_msg_pub.count_and_get (

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

412: ROLLBACK TO create_budget_amt_utilized;
413: x_return_status := fnd_api.g_ret_sts_unexp_error;
414:
415: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
416: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
417: END IF;
418:
419: fnd_msg_pub.count_and_get (
420: p_count=> x_msg_count

Line 419: fnd_msg_pub.count_and_get (

415: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
416: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
417: END IF;
418:
419: fnd_msg_pub.count_and_get (
420: p_count=> x_msg_count
421: ,p_data=> x_msg_data
422: ,p_encoded=> fnd_api.g_false
423: );

Line 808: fnd_msg_pub.ADD;

804: --08/18/2005 feliu fix for third party accrual.
805: /* IF l_accrual_basis ='CUSTOMER' THEN
806: IF p_act_budget_rec.parent_source_id <> l_fund_id THEN
807: fnd_message.set_name ('OZF', 'OZF_FUND_OFFR_ADJ');
808: fnd_msg_pub.ADD;
809: RAISE fnd_api.g_exc_error;
810: END IF;
811: */
812: --Added for bug 7030415, In case of accrual budget.

Line 1212: fnd_msg_pub.count_and_get (

1208: IF G_DEBUG THEN
1209: ozf_utility_pvt.debug_message(l_full_name||' : '||'x_utilized_amount: '|| x_utilized_amount);
1210: END IF;
1211:
1212: fnd_msg_pub.count_and_get (
1213: p_encoded=> fnd_api.g_false
1214: ,p_count=> x_msg_count
1215: ,p_data=> x_msg_data
1216: );

Line 1226: fnd_msg_pub.count_and_get (

1222: EXCEPTION
1223: WHEN fnd_api.g_exc_error THEN
1224: ROLLBACK TO create_utilization;
1225: x_return_status := fnd_api.g_ret_sts_error;
1226: fnd_msg_pub.count_and_get (
1227: p_encoded=> fnd_api.g_false
1228: ,p_count=> x_msg_count
1229: ,p_data=> x_msg_data
1230: );

Line 1234: fnd_msg_pub.count_and_get (

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

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

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

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

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

Line 1247: fnd_msg_pub.count_and_get (

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

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

1308: );
1309: RETURN l_returned_amount;
1310: EXCEPTION
1311: WHEN gl_currency_api.no_rate THEN
1312: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1313: fnd_message.set_name ('OZF', 'OZF_NO_RATE');
1314: fnd_message.set_token ('CURRENCY_FROM', p_from_currency);
1315: fnd_message.set_token ('CURRENCY_TO', p_to_currency);
1316: fnd_msg_pub.ADD;

Line 1316: fnd_msg_pub.ADD;

1312: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1313: fnd_message.set_name ('OZF', 'OZF_NO_RATE');
1314: fnd_message.set_token ('CURRENCY_FROM', p_from_currency);
1315: fnd_message.set_token ('CURRENCY_TO', p_to_currency);
1316: fnd_msg_pub.ADD;
1317: RETURN 0;
1318: END IF;
1319: WHEN gl_currency_api.invalid_currency THEN
1320: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

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

1316: fnd_msg_pub.ADD;
1317: RETURN 0;
1318: END IF;
1319: WHEN gl_currency_api.invalid_currency THEN
1320: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1321: fnd_message.set_name ('OZF', 'OZF_INVALID_CURR');
1322: fnd_message.set_token ('CURRENCY_FROM', p_from_currency);
1323: fnd_message.set_token ('CURRENCY_TO', p_to_currency);
1324: fnd_msg_pub.ADD;

Line 1324: fnd_msg_pub.ADD;

1320: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1321: fnd_message.set_name ('OZF', 'OZF_INVALID_CURR');
1322: fnd_message.set_token ('CURRENCY_FROM', p_from_currency);
1323: fnd_message.set_token ('CURRENCY_TO', p_to_currency);
1324: fnd_msg_pub.ADD;
1325: RETURN 0;
1326: END IF;
1327: WHEN OTHERS THEN
1328: RETURN 0;

Line 1415: fnd_msg_pub.ADD;

1411:
1412: IF l_lumpsum_offer.distribution_type = 'AMT' THEN
1413: IF l_total_distribution <> l_lumpsum_offer.lumpsum_amount THEN
1414: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTR_ACTIVE');
1415: fnd_msg_pub.ADD;
1416: RAISE fnd_api.g_exc_error;
1417: ELSIF l_total_distribution > l_lumpsum_offer.lumpsum_amount THEN
1418: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTRIBUTION');
1419: fnd_msg_pub.ADD;

Line 1419: fnd_msg_pub.ADD;

1415: fnd_msg_pub.ADD;
1416: RAISE fnd_api.g_exc_error;
1417: ELSIF l_total_distribution > l_lumpsum_offer.lumpsum_amount THEN
1418: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTRIBUTION');
1419: fnd_msg_pub.ADD;
1420: RAISE fnd_api.g_exc_error;
1421: END IF;
1422: ELSIF l_lumpsum_offer.distribution_type = '%' THEN
1423: IF l_total_distribution <> 100 THEN

Line 1425: fnd_msg_pub.ADD;

1421: END IF;
1422: ELSIF l_lumpsum_offer.distribution_type = '%' THEN
1423: IF l_total_distribution <> 100 THEN
1424: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTR_ACTIVE');
1425: fnd_msg_pub.ADD;
1426: RAISE fnd_api.g_exc_error;
1427: ELSIF l_total_distribution > 100 THEN
1428: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTRIBUTION');
1429: fnd_msg_pub.ADD;

Line 1429: fnd_msg_pub.ADD;

1425: fnd_msg_pub.ADD;
1426: RAISE fnd_api.g_exc_error;
1427: ELSIF l_total_distribution > 100 THEN
1428: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTRIBUTION');
1429: fnd_msg_pub.ADD;
1430: RAISE fnd_api.g_exc_error;
1431: END IF;
1432: END IF;
1433: EXCEPTION

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

1435: x_return_status := fnd_api.g_ret_sts_error;
1436: WHEN OTHERS THEN
1437: x_return_status := fnd_api.g_ret_sts_unexp_error;
1438:
1439: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1440: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1441: END IF;
1442: END validate_lumpsum_offer;
1443: ---------------------------------------------------------------------

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

1436: WHEN OTHERS THEN
1437: x_return_status := fnd_api.g_ret_sts_unexp_error;
1438:
1439: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1440: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1441: END IF;
1442: END validate_lumpsum_offer;
1443: ---------------------------------------------------------------------
1444: -- PROCEDURE

Line 1681: fnd_msg_pub.count_and_get (

1677: --dbms_output.put_line(l_full_name||' : '||'update act budget retrun status'||l_return_status);
1678:
1679: END IF;
1680:
1681: fnd_msg_pub.count_and_get (
1682: p_count=> x_msg_count,
1683: p_data=> x_msg_data,
1684: p_encoded=> fnd_api.g_false
1685: );

Line 1696: fnd_msg_pub.count_and_get (

1692:
1693: EXCEPTION
1694: WHEN fnd_api.g_exc_error THEN
1695: x_return_status := fnd_api.g_ret_sts_error;
1696: fnd_msg_pub.count_and_get (
1697: p_count=> x_msg_count,
1698: p_data=> x_msg_data,
1699: p_encoded=> fnd_api.g_false
1700: );

Line 1703: fnd_msg_pub.count_and_get (

1699: p_encoded=> fnd_api.g_false
1700: );
1701: WHEN fnd_api.g_exc_unexpected_error THEN
1702: x_return_status := fnd_api.g_ret_sts_unexp_error;
1703: fnd_msg_pub.count_and_get (
1704: p_count=> x_msg_count,
1705: p_data=> x_msg_data,
1706: p_encoded=> fnd_api.g_false
1707: );

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

1707: );
1708: WHEN OTHERS THEN
1709: x_return_status := fnd_api.g_ret_sts_unexp_error;
1710:
1711: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1712: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1713: END IF;
1714:
1715: fnd_msg_pub.count_and_get (

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

1708: WHEN OTHERS THEN
1709: x_return_status := fnd_api.g_ret_sts_unexp_error;
1710:
1711: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1712: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1713: END IF;
1714:
1715: fnd_msg_pub.count_and_get (
1716: p_count=> x_msg_count,

Line 1715: fnd_msg_pub.count_and_get (

1711: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1712: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1713: END IF;
1714:
1715: fnd_msg_pub.count_and_get (
1716: p_count=> x_msg_count,
1717: p_data=> x_msg_data,
1718: p_encoded=> fnd_api.g_false
1719: );

Line 1948: fnd_msg_pub.initialize;

1944: END IF;
1945: x_return_status := fnd_api.g_ret_sts_success;
1946:
1947: IF fnd_api.to_boolean (p_init_msg_list) THEN
1948: fnd_msg_pub.initialize;
1949: END IF;
1950:
1951: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1952: RAISE fnd_api.g_exc_unexpected_error;

Line 2139: fnd_msg_pub.count_and_get (

2135: COMMIT;
2136: END IF;
2137:
2138:
2139: fnd_msg_pub.count_and_get (
2140: p_encoded=> fnd_api.g_false
2141: ,p_count=> x_msg_count
2142: ,p_data=> x_msg_data
2143: );

Line 2152: fnd_msg_pub.count_and_get (

2148: EXCEPTION
2149: WHEN fnd_api.g_exc_error THEN
2150: ROLLBACK TO post_scan_data_amount;
2151: x_return_status := fnd_api.g_ret_sts_error;
2152: fnd_msg_pub.count_and_get (
2153: p_count=> x_msg_count
2154: ,p_data=> x_msg_data
2155: ,p_encoded=> fnd_api.g_false
2156: );

Line 2160: fnd_msg_pub.count_and_get (

2156: );
2157: WHEN fnd_api.g_exc_unexpected_error THEN
2158: ROLLBACK TO post_scan_data_amount;
2159: x_return_status := fnd_api.g_ret_sts_unexp_error;
2160: fnd_msg_pub.count_and_get (
2161: p_count=> x_msg_count
2162: ,p_data=> x_msg_data
2163: ,p_encoded=> fnd_api.g_false
2164: );

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

2165: WHEN OTHERS THEN
2166: ROLLBACK TO post_scan_data_amount;
2167: x_return_status := fnd_api.g_ret_sts_unexp_error;
2168:
2169: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2170: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2171: END IF;
2172:
2173: fnd_msg_pub.count_and_get (

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

2166: ROLLBACK TO post_scan_data_amount;
2167: x_return_status := fnd_api.g_ret_sts_unexp_error;
2168:
2169: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2170: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2171: END IF;
2172:
2173: fnd_msg_pub.count_and_get (
2174: p_count=> x_msg_count

Line 2173: fnd_msg_pub.count_and_get (

2169: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2170: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2171: END IF;
2172:
2173: fnd_msg_pub.count_and_get (
2174: p_count=> x_msg_count
2175: ,p_data=> x_msg_data
2176: ,p_encoded=> fnd_api.g_false
2177: );

Line 2399: fnd_msg_pub.initialize;

2395: END IF;
2396: x_return_status := fnd_api.g_ret_sts_success;
2397:
2398: IF fnd_api.to_boolean (p_init_msg_list) THEN
2399: fnd_msg_pub.initialize;
2400: END IF;
2401:
2402: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2403: RAISE fnd_api.g_exc_unexpected_error;

Line 2614: fnd_msg_pub.count_and_get (

2610:
2611: CLOSE c_off_products;
2612: END IF;
2613:
2614: fnd_msg_pub.count_and_get (
2615: p_encoded=> fnd_api.g_false
2616: ,p_count=> x_msg_count
2617: ,p_data=> x_msg_data
2618: );

Line 2626: fnd_msg_pub.count_and_get (

2622: EXCEPTION
2623: WHEN fnd_api.g_exc_error THEN
2624: ROLLBACK TO Posting_lumpsum_amount;
2625: x_return_status := fnd_api.g_ret_sts_error;
2626: fnd_msg_pub.count_and_get (
2627: p_count=> x_msg_count
2628: ,p_data=> x_msg_data
2629: ,p_encoded=> fnd_api.g_false
2630: );

Line 2634: fnd_msg_pub.count_and_get (

2630: );
2631: WHEN fnd_api.g_exc_unexpected_error THEN
2632: ROLLBACK TO Posting_lumpsum_amount;
2633: x_return_status := fnd_api.g_ret_sts_unexp_error;
2634: fnd_msg_pub.count_and_get (
2635: p_count=> x_msg_count
2636: ,p_data=> x_msg_data
2637: ,p_encoded=> fnd_api.g_false
2638: );

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

2639: WHEN OTHERS THEN
2640: ROLLBACK TO Posting_lumpsum_amount;
2641: x_return_status := fnd_api.g_ret_sts_unexp_error;
2642:
2643: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2644: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2645: END IF;
2646:
2647: fnd_msg_pub.count_and_get (

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

2640: ROLLBACK TO Posting_lumpsum_amount;
2641: x_return_status := fnd_api.g_ret_sts_unexp_error;
2642:
2643: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2644: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2645: END IF;
2646:
2647: fnd_msg_pub.count_and_get (
2648: p_count=> x_msg_count

Line 2647: fnd_msg_pub.count_and_get (

2643: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2644: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2645: END IF;
2646:
2647: fnd_msg_pub.count_and_get (
2648: p_count=> x_msg_count
2649: ,p_data=> x_msg_data
2650: ,p_encoded=> fnd_api.g_false
2651: );

Line 2710: fnd_msg_pub.initialize;

2706: END IF;
2707: x_return_status := fnd_api.g_ret_sts_success;
2708:
2709: IF fnd_api.to_boolean (p_init_msg_list) THEN
2710: fnd_msg_pub.initialize;
2711: END IF;
2712:
2713: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2714: RAISE fnd_api.g_exc_unexpected_error;

Line 2767: fnd_msg_pub.count_and_get (

2763: x_return_status := fnd_api.g_ret_sts_error;
2764: RAISE fnd_api.g_exc_error;
2765: END IF;
2766:
2767: fnd_msg_pub.count_and_get (
2768: p_encoded=> fnd_api.g_false
2769: ,p_count=> x_msg_count
2770: ,p_data=> x_msg_data
2771: );

Line 2780: fnd_msg_pub.count_and_get (

2776: EXCEPTION
2777: WHEN fnd_api.g_exc_error THEN
2778: ROLLBACK TO post_utilized_budget;
2779: x_return_status := fnd_api.g_ret_sts_error;
2780: fnd_msg_pub.count_and_get (
2781: p_count=> x_msg_count
2782: ,p_data=> x_msg_data
2783: ,p_encoded=> fnd_api.g_false
2784: );

Line 2788: fnd_msg_pub.count_and_get (

2784: );
2785: WHEN fnd_api.g_exc_unexpected_error THEN
2786: ROLLBACK TO post_utilized_budget;
2787: x_return_status := fnd_api.g_ret_sts_unexp_error;
2788: fnd_msg_pub.count_and_get (
2789: p_count=> x_msg_count
2790: ,p_data=> x_msg_data
2791: ,p_encoded=> fnd_api.g_false
2792: );

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

2793: WHEN OTHERS THEN
2794: ROLLBACK TO post_utilized_budget;
2795: x_return_status := fnd_api.g_ret_sts_unexp_error;
2796:
2797: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2798: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2799: END IF;
2800:
2801: fnd_msg_pub.count_and_get (

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

2794: ROLLBACK TO post_utilized_budget;
2795: x_return_status := fnd_api.g_ret_sts_unexp_error;
2796:
2797: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2798: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2799: END IF;
2800:
2801: fnd_msg_pub.count_and_get (
2802: p_count=> x_msg_count

Line 2801: fnd_msg_pub.count_and_get (

2797: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2798: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2799: END IF;
2800:
2801: fnd_msg_pub.count_and_get (
2802: p_count=> x_msg_count
2803: ,p_data=> x_msg_data
2804: ,p_encoded=> fnd_api.g_false
2805: );

Line 2977: fnd_msg_pub.initialize;

2973: END IF;
2974: x_return_status := fnd_api.g_ret_sts_success;
2975:
2976: IF fnd_api.to_boolean (p_init_msg_list) THEN
2977: fnd_msg_pub.initialize;
2978: END IF;
2979:
2980: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2981: RAISE fnd_api.g_exc_unexpected_error;

Line 3106: fnd_msg_pub.count_and_get (

3102: );
3103:
3104: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
3105: ROLLBACK TO recal_comm_fund_conc;
3106: fnd_msg_pub.count_and_get (
3107: p_count=> x_msg_count
3108: ,p_data=> x_msg_data
3109: ,p_encoded=> fnd_api.g_false
3110: );

Line 3222: fnd_msg_pub.count_and_get (

3218: EXIT WHEN l_amount_remaining = 0;
3219: END IF;
3220: END LOOP;
3221:
3222: fnd_msg_pub.count_and_get (
3223: p_encoded=> fnd_api.g_false
3224: ,p_count=> x_msg_count
3225: ,p_data=> x_msg_data
3226: );

Line 3235: fnd_msg_pub.count_and_get (

3231: EXCEPTION
3232: WHEN fnd_api.g_exc_error THEN
3233: ROLLBACK TO adjust_utilized_budget;
3234: x_return_status := fnd_api.g_ret_sts_error;
3235: fnd_msg_pub.count_and_get (
3236: p_count=> x_msg_count
3237: ,p_data=> x_msg_data
3238: ,p_encoded=> fnd_api.g_false
3239: );

Line 3243: fnd_msg_pub.count_and_get (

3239: );
3240: WHEN fnd_api.g_exc_unexpected_error THEN
3241: ROLLBACK TO adjust_utilized_budget;
3242: x_return_status := fnd_api.g_ret_sts_unexp_error;
3243: fnd_msg_pub.count_and_get (
3244: p_count=> x_msg_count
3245: ,p_data=> x_msg_data
3246: ,p_encoded=> fnd_api.g_false
3247: );

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

3248: WHEN OTHERS THEN
3249: ROLLBACK TO adjust_utilized_budget;
3250: x_return_status := fnd_api.g_ret_sts_unexp_error;
3251:
3252: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3253: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3254: END IF;
3255:
3256: fnd_msg_pub.count_and_get (

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

3249: ROLLBACK TO adjust_utilized_budget;
3250: x_return_status := fnd_api.g_ret_sts_unexp_error;
3251:
3252: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3253: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3254: END IF;
3255:
3256: fnd_msg_pub.count_and_get (
3257: p_count=> x_msg_count

Line 3256: fnd_msg_pub.count_and_get (

3252: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3253: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3254: END IF;
3255:
3256: fnd_msg_pub.count_and_get (
3257: p_count=> x_msg_count
3258: ,p_data=> x_msg_data
3259: ,p_encoded=> fnd_api.g_false
3260: );

Line 3305: fnd_msg_pub.initialize;

3301: END IF;
3302: x_return_status := fnd_api.g_ret_sts_success;
3303:
3304: IF fnd_api.to_boolean (p_init_msg_list) THEN
3305: fnd_msg_pub.initialize;
3306: END IF;
3307:
3308: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3309: RAISE fnd_api.g_exc_unexpected_error;

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

3319:
3320: IF (SQL%NOTFOUND) THEN
3321: -- Error, check the msg level and added an error message to the
3322: -- API message list
3323: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3324: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
3325: fnd_msg_pub.ADD;
3326: END IF;
3327: RAISE fnd_api.g_exc_unexpected_error;

Line 3325: fnd_msg_pub.ADD;

3321: -- Error, check the msg level and added an error message to the
3322: -- API message list
3323: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3324: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
3325: fnd_msg_pub.ADD;
3326: END IF;
3327: RAISE fnd_api.g_exc_unexpected_error;
3328: END IF;
3329: ELSE

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

3333:
3334: IF (SQL%NOTFOUND) THEN
3335: -- Error, check the msg level and added an error message to the
3336: -- API message list
3337: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3338: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
3339: fnd_msg_pub.ADD;
3340: END IF;
3341: RAISE fnd_api.g_exc_unexpected_error;

Line 3339: fnd_msg_pub.ADD;

3335: -- Error, check the msg level and added an error message to the
3336: -- API message list
3337: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3338: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
3339: fnd_msg_pub.ADD;
3340: END IF;
3341: RAISE fnd_api.g_exc_unexpected_error;
3342: END IF;
3343: END IF;

Line 3350: fnd_msg_pub.count_and_get (

3346: IF fnd_api.to_boolean (p_commit) THEN
3347: COMMIT WORK;
3348: END IF;
3349:
3350: fnd_msg_pub.count_and_get (
3351: p_encoded=> fnd_api.g_false
3352: ,p_count=> x_msg_count
3353: ,p_data=> x_msg_data
3354: );

Line 3363: fnd_msg_pub.count_and_get (

3359: EXCEPTION
3360: WHEN fnd_api.g_exc_error THEN
3361: ROLLBACK TO update_budget_source;
3362: x_return_status := fnd_api.g_ret_sts_error;
3363: fnd_msg_pub.count_and_get (
3364: p_count=> x_msg_count
3365: ,p_data=> x_msg_data
3366: ,p_encoded=> fnd_api.g_false
3367: );

Line 3371: fnd_msg_pub.count_and_get (

3367: );
3368: WHEN fnd_api.g_exc_unexpected_error THEN
3369: ROLLBACK TO update_budget_source;
3370: x_return_status := fnd_api.g_ret_sts_unexp_error;
3371: fnd_msg_pub.count_and_get (
3372: p_count=> x_msg_count
3373: ,p_data=> x_msg_data
3374: ,p_encoded=> fnd_api.g_false
3375: );

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

3376: WHEN OTHERS THEN
3377: ROLLBACK TO update_budget_source;
3378: x_return_status := fnd_api.g_ret_sts_unexp_error;
3379:
3380: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3381: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3382: END IF;
3383:
3384: fnd_msg_pub.count_and_get (

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

3377: ROLLBACK TO update_budget_source;
3378: x_return_status := fnd_api.g_ret_sts_unexp_error;
3379:
3380: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3381: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3382: END IF;
3383:
3384: fnd_msg_pub.count_and_get (
3385: p_count=> x_msg_count

Line 3384: fnd_msg_pub.count_and_get (

3380: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3381: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3382: END IF;
3383:
3384: fnd_msg_pub.count_and_get (
3385: p_count=> x_msg_count
3386: ,p_data=> x_msg_data
3387: ,p_encoded=> fnd_api.g_false
3388: );

Line 3532: fnd_msg_pub.initialize;

3528: END IF;
3529: x_return_status := fnd_api.g_ret_sts_success;
3530:
3531: IF fnd_api.to_boolean (p_init_msg_list) THEN
3532: fnd_msg_pub.initialize;
3533: END IF;
3534:
3535: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3536: RAISE fnd_api.g_exc_unexpected_error;

Line 3668: fnd_msg_pub.count_and_get (

3664:
3665: CLOSE c_req_expense;
3666:
3667:
3668: fnd_msg_pub.count_and_get (
3669: p_encoded=> fnd_api.g_false
3670: ,p_count=> x_msg_count
3671: ,p_data=> x_msg_data
3672: );

Line 3680: fnd_msg_pub.count_and_get (

3676: EXCEPTION
3677: WHEN fnd_api.g_exc_error THEN
3678: ROLLBACK TO Posting_lumpsum_amount;
3679: x_return_status := fnd_api.g_ret_sts_error;
3680: fnd_msg_pub.count_and_get (
3681: p_count=> x_msg_count
3682: ,p_data=> x_msg_data
3683: ,p_encoded=> fnd_api.g_false
3684: );

Line 3688: fnd_msg_pub.count_and_get (

3684: );
3685: WHEN fnd_api.g_exc_unexpected_error THEN
3686: ROLLBACK TO Posting_lumpsum_amount;
3687: x_return_status := fnd_api.g_ret_sts_unexp_error;
3688: fnd_msg_pub.count_and_get (
3689: p_count=> x_msg_count
3690: ,p_data=> x_msg_data
3691: ,p_encoded=> fnd_api.g_false
3692: );

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

3693: WHEN OTHERS THEN
3694: ROLLBACK TO Posting_lumpsum_amount;
3695: x_return_status := fnd_api.g_ret_sts_unexp_error;
3696:
3697: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3698: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3699: END IF;
3700:
3701: fnd_msg_pub.count_and_get (

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

3694: ROLLBACK TO Posting_lumpsum_amount;
3695: x_return_status := fnd_api.g_ret_sts_unexp_error;
3696:
3697: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3698: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3699: END IF;
3700:
3701: fnd_msg_pub.count_and_get (
3702: p_count=> x_msg_count

Line 3701: fnd_msg_pub.count_and_get (

3697: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3698: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3699: END IF;
3700:
3701: fnd_msg_pub.count_and_get (
3702: p_count=> x_msg_count
3703: ,p_data=> x_msg_data
3704: ,p_encoded=> fnd_api.g_false
3705: );

Line 3749: fnd_msg_pub.count_and_get (

3745: object_version_number = l_obj_ver_num + 1
3746: WHERE request_header_id = l_req_header_id;
3747: END IF;
3748:
3749: fnd_msg_pub.count_and_get (
3750: p_count=> x_msg_count,
3751: p_data=> x_msg_data,
3752: p_encoded=> fnd_api.g_false
3753: );

Line 3758: fnd_msg_pub.count_and_get (

3754:
3755: EXCEPTION
3756: WHEN fnd_api.g_exc_error THEN
3757: x_return_status := fnd_api.g_ret_sts_error;
3758: fnd_msg_pub.count_and_get (
3759: p_count=> x_msg_count,
3760: p_data=> x_msg_data,
3761: p_encoded=> fnd_api.g_false
3762: );

Line 3765: fnd_msg_pub.count_and_get (

3761: p_encoded=> fnd_api.g_false
3762: );
3763: WHEN fnd_api.g_exc_unexpected_error THEN
3764: x_return_status := fnd_api.g_ret_sts_unexp_error;
3765: fnd_msg_pub.count_and_get (
3766: p_count=> x_msg_count,
3767: p_data=> x_msg_data,
3768: p_encoded=> fnd_api.g_false
3769: );

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

3769: );
3770: WHEN OTHERS THEN
3771: x_return_status := fnd_api.g_ret_sts_unexp_error;
3772:
3773: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3774: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3775: END IF;
3776:
3777: fnd_msg_pub.count_and_get (

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

3770: WHEN OTHERS THEN
3771: x_return_status := fnd_api.g_ret_sts_unexp_error;
3772:
3773: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3774: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3775: END IF;
3776:
3777: fnd_msg_pub.count_and_get (
3778: p_count=> x_msg_count,

Line 3777: fnd_msg_pub.count_and_get (

3773: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3774: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3775: END IF;
3776:
3777: fnd_msg_pub.count_and_get (
3778: p_count=> x_msg_count,
3779: p_data=> x_msg_data,
3780: p_encoded=> fnd_api.g_false
3781: );