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.48.12020000.3 2013/01/31 07:00:26 ninarasi 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: G_TPM_PROCESS_ENABLED VARCHAR2 (1) := NVL(fnd_profile.VALUE ('OZF_TPM_PROCESS_ENABLED'),'N');
9:
10: /* =========================================================

Line 203: fnd_msg_pub.initialize;

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

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

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

Line 371: fnd_msg_pub.ADD;

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

Line 400: fnd_msg_pub.count_and_get (

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

Line 408: fnd_msg_pub.count_and_get (

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

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

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

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

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

Line 421: fnd_msg_pub.count_and_get (

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

Line 940: fnd_msg_pub.ADD;

936: --08/18/2005 feliu fix for third party accrual.
937: /* IF l_accrual_basis ='CUSTOMER' THEN
938: IF p_act_budget_rec.parent_source_id <> l_fund_id THEN
939: fnd_message.set_name ('OZF', 'OZF_FUND_OFFR_ADJ');
940: fnd_msg_pub.ADD;
941: RAISE fnd_api.g_exc_error;
942: END IF;
943: */
944: --Added for bug 7030415, In case of accrual budget.

Line 1429: fnd_msg_pub.count_and_get (

1425: IF G_DEBUG THEN
1426: ozf_utility_pvt.debug_message(l_full_name||' : '||'x_utilized_amount: '|| x_utilized_amount);
1427: END IF;
1428:
1429: fnd_msg_pub.count_and_get (
1430: p_encoded=> fnd_api.g_false
1431: ,p_count=> x_msg_count
1432: ,p_data=> x_msg_data
1433: );

Line 1443: fnd_msg_pub.count_and_get (

1439: EXCEPTION
1440: WHEN fnd_api.g_exc_error THEN
1441: ROLLBACK TO create_utilization;
1442: x_return_status := fnd_api.g_ret_sts_error;
1443: fnd_msg_pub.count_and_get (
1444: p_encoded=> fnd_api.g_false
1445: ,p_count=> x_msg_count
1446: ,p_data=> x_msg_data
1447: );

Line 1451: fnd_msg_pub.count_and_get (

1447: );
1448: WHEN fnd_api.g_exc_unexpected_error THEN
1449: ROLLBACK TO create_utilization;
1450: x_return_status := fnd_api.g_ret_sts_unexp_error;
1451: fnd_msg_pub.count_and_get (
1452: p_encoded=> fnd_api.g_false
1453: ,p_count=> x_msg_count
1454: ,p_data=> x_msg_data
1455: );

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

1456: WHEN OTHERS THEN
1457: ROLLBACK TO create_utilization;
1458: x_return_status := fnd_api.g_ret_sts_unexp_error;
1459:
1460: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1461: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1462: END IF;
1463:
1464: fnd_msg_pub.count_and_get (

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

1457: ROLLBACK TO create_utilization;
1458: x_return_status := fnd_api.g_ret_sts_unexp_error;
1459:
1460: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1461: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1462: END IF;
1463:
1464: fnd_msg_pub.count_and_get (
1465: p_encoded=> fnd_api.g_false

Line 1464: fnd_msg_pub.count_and_get (

1460: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1461: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1462: END IF;
1463:
1464: fnd_msg_pub.count_and_get (
1465: p_encoded=> fnd_api.g_false
1466: ,p_count=> x_msg_count
1467: ,p_data=> x_msg_data
1468: );

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

1525: );
1526: RETURN l_returned_amount;
1527: EXCEPTION
1528: WHEN gl_currency_api.no_rate THEN
1529: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1530: fnd_message.set_name ('OZF', 'OZF_NO_RATE');
1531: fnd_message.set_token ('CURRENCY_FROM', p_from_currency);
1532: fnd_message.set_token ('CURRENCY_TO', p_to_currency);
1533: fnd_msg_pub.ADD;

Line 1533: fnd_msg_pub.ADD;

1529: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1530: fnd_message.set_name ('OZF', 'OZF_NO_RATE');
1531: fnd_message.set_token ('CURRENCY_FROM', p_from_currency);
1532: fnd_message.set_token ('CURRENCY_TO', p_to_currency);
1533: fnd_msg_pub.ADD;
1534: RETURN 0;
1535: END IF;
1536: WHEN gl_currency_api.invalid_currency THEN
1537: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

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

1533: fnd_msg_pub.ADD;
1534: RETURN 0;
1535: END IF;
1536: WHEN gl_currency_api.invalid_currency THEN
1537: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1538: fnd_message.set_name ('OZF', 'OZF_INVALID_CURR');
1539: fnd_message.set_token ('CURRENCY_FROM', p_from_currency);
1540: fnd_message.set_token ('CURRENCY_TO', p_to_currency);
1541: fnd_msg_pub.ADD;

Line 1541: fnd_msg_pub.ADD;

1537: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1538: fnd_message.set_name ('OZF', 'OZF_INVALID_CURR');
1539: fnd_message.set_token ('CURRENCY_FROM', p_from_currency);
1540: fnd_message.set_token ('CURRENCY_TO', p_to_currency);
1541: fnd_msg_pub.ADD;
1542: RETURN 0;
1543: END IF;
1544: WHEN OTHERS THEN
1545: RETURN 0;

Line 1633: fnd_msg_pub.ADD;

1629:
1630: IF l_lumpsum_offer.distribution_type = 'AMT' THEN
1631: IF l_total_distribution <> l_lumpsum_offer.lumpsum_amount THEN
1632: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTR_ACTIVE');
1633: fnd_msg_pub.ADD;
1634: RAISE fnd_api.g_exc_error;
1635: ELSIF l_total_distribution > l_lumpsum_offer.lumpsum_amount THEN
1636: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTRIBUTION');
1637: fnd_msg_pub.ADD;

Line 1637: fnd_msg_pub.ADD;

1633: fnd_msg_pub.ADD;
1634: RAISE fnd_api.g_exc_error;
1635: ELSIF l_total_distribution > l_lumpsum_offer.lumpsum_amount THEN
1636: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTRIBUTION');
1637: fnd_msg_pub.ADD;
1638: RAISE fnd_api.g_exc_error;
1639: END IF;
1640: ELSIF l_lumpsum_offer.distribution_type = '%' THEN
1641: IF l_total_distribution <> 100 THEN

Line 1643: fnd_msg_pub.ADD;

1639: END IF;
1640: ELSIF l_lumpsum_offer.distribution_type = '%' THEN
1641: IF l_total_distribution <> 100 THEN
1642: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTR_ACTIVE');
1643: fnd_msg_pub.ADD;
1644: RAISE fnd_api.g_exc_error;
1645: ELSIF l_total_distribution > 100 THEN
1646: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTRIBUTION');
1647: fnd_msg_pub.ADD;

Line 1647: fnd_msg_pub.ADD;

1643: fnd_msg_pub.ADD;
1644: RAISE fnd_api.g_exc_error;
1645: ELSIF l_total_distribution > 100 THEN
1646: fnd_message.set_name ('OZF', 'OZF_INVALID_DISTRIBUTION');
1647: fnd_msg_pub.ADD;
1648: RAISE fnd_api.g_exc_error;
1649: END IF;
1650: END IF;
1651: EXCEPTION

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

1653: x_return_status := fnd_api.g_ret_sts_error;
1654: WHEN OTHERS THEN
1655: x_return_status := fnd_api.g_ret_sts_unexp_error;
1656:
1657: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1658: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1659: END IF;
1660: END validate_lumpsum_offer;
1661: ---------------------------------------------------------------------

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

1654: WHEN OTHERS THEN
1655: x_return_status := fnd_api.g_ret_sts_unexp_error;
1656:
1657: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1658: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1659: END IF;
1660: END validate_lumpsum_offer;
1661: ---------------------------------------------------------------------
1662: -- PROCEDURE

Line 2123: fnd_msg_pub.count_and_get (

2119: --dbms_output.put_line(l_full_name||' : '||'update act budget retrun status'||l_return_status);
2120:
2121: END IF;
2122:
2123: fnd_msg_pub.count_and_get (
2124: p_count=> x_msg_count,
2125: p_data=> x_msg_data,
2126: p_encoded=> fnd_api.g_false
2127: );

Line 2138: fnd_msg_pub.count_and_get (

2134:
2135: EXCEPTION
2136: WHEN fnd_api.g_exc_error THEN
2137: x_return_status := fnd_api.g_ret_sts_error;
2138: fnd_msg_pub.count_and_get (
2139: p_count=> x_msg_count,
2140: p_data=> x_msg_data,
2141: p_encoded=> fnd_api.g_false
2142: );

Line 2145: fnd_msg_pub.count_and_get (

2141: p_encoded=> fnd_api.g_false
2142: );
2143: WHEN fnd_api.g_exc_unexpected_error THEN
2144: x_return_status := fnd_api.g_ret_sts_unexp_error;
2145: fnd_msg_pub.count_and_get (
2146: p_count=> x_msg_count,
2147: p_data=> x_msg_data,
2148: p_encoded=> fnd_api.g_false
2149: );

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

2149: );
2150: WHEN OTHERS THEN
2151: x_return_status := fnd_api.g_ret_sts_unexp_error;
2152:
2153: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2154: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2155: END IF;
2156:
2157: fnd_msg_pub.count_and_get (

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

2150: WHEN OTHERS THEN
2151: x_return_status := fnd_api.g_ret_sts_unexp_error;
2152:
2153: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2154: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2155: END IF;
2156:
2157: fnd_msg_pub.count_and_get (
2158: p_count=> x_msg_count,

Line 2157: fnd_msg_pub.count_and_get (

2153: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2154: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2155: END IF;
2156:
2157: fnd_msg_pub.count_and_get (
2158: p_count=> x_msg_count,
2159: p_data=> x_msg_data,
2160: p_encoded=> fnd_api.g_false
2161: );

Line 2470: fnd_msg_pub.initialize;

2466: END IF;
2467: x_return_status := fnd_api.g_ret_sts_success;
2468:
2469: IF fnd_api.to_boolean (p_init_msg_list) THEN
2470: fnd_msg_pub.initialize;
2471: END IF;
2472:
2473: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2474: RAISE fnd_api.g_exc_unexpected_error;

Line 2666: fnd_msg_pub.count_and_get (

2662: COMMIT;
2663: END IF;
2664:
2665:
2666: fnd_msg_pub.count_and_get (
2667: p_encoded=> fnd_api.g_false
2668: ,p_count=> x_msg_count
2669: ,p_data=> x_msg_data
2670: );

Line 2679: fnd_msg_pub.count_and_get (

2675: EXCEPTION
2676: WHEN fnd_api.g_exc_error THEN
2677: ROLLBACK TO post_scan_data_amount;
2678: x_return_status := fnd_api.g_ret_sts_error;
2679: fnd_msg_pub.count_and_get (
2680: p_count=> x_msg_count
2681: ,p_data=> x_msg_data
2682: ,p_encoded=> fnd_api.g_false
2683: );

Line 2687: fnd_msg_pub.count_and_get (

2683: );
2684: WHEN fnd_api.g_exc_unexpected_error THEN
2685: ROLLBACK TO post_scan_data_amount;
2686: x_return_status := fnd_api.g_ret_sts_unexp_error;
2687: fnd_msg_pub.count_and_get (
2688: p_count=> x_msg_count
2689: ,p_data=> x_msg_data
2690: ,p_encoded=> fnd_api.g_false
2691: );

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

2692: WHEN OTHERS THEN
2693: ROLLBACK TO post_scan_data_amount;
2694: x_return_status := fnd_api.g_ret_sts_unexp_error;
2695:
2696: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2697: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2698: END IF;
2699:
2700: fnd_msg_pub.count_and_get (

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

2693: ROLLBACK TO post_scan_data_amount;
2694: x_return_status := fnd_api.g_ret_sts_unexp_error;
2695:
2696: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2697: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2698: END IF;
2699:
2700: fnd_msg_pub.count_and_get (
2701: p_count=> x_msg_count

Line 2700: fnd_msg_pub.count_and_get (

2696: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2697: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2698: END IF;
2699:
2700: fnd_msg_pub.count_and_get (
2701: p_count=> x_msg_count
2702: ,p_data=> x_msg_data
2703: ,p_encoded=> fnd_api.g_false
2704: );

Line 2937: fnd_msg_pub.initialize;

2933: END IF;
2934: x_return_status := fnd_api.g_ret_sts_success;
2935:
2936: IF fnd_api.to_boolean (p_init_msg_list) THEN
2937: fnd_msg_pub.initialize;
2938: END IF;
2939:
2940: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2941: RAISE fnd_api.g_exc_unexpected_error;

Line 3289: fnd_msg_pub.count_and_get (

3285: p_send_date => sysdate);
3286:
3287: END IF;
3288:
3289: fnd_msg_pub.count_and_get (
3290: p_encoded=> fnd_api.g_false
3291: ,p_count=> x_msg_count
3292: ,p_data=> x_msg_data
3293: );

Line 3301: fnd_msg_pub.count_and_get (

3297: EXCEPTION
3298: WHEN fnd_api.g_exc_error THEN
3299: ROLLBACK TO Posting_lumpsum_amount;
3300: x_return_status := fnd_api.g_ret_sts_error;
3301: fnd_msg_pub.count_and_get (
3302: p_count=> x_msg_count
3303: ,p_data=> x_msg_data
3304: ,p_encoded=> fnd_api.g_false
3305: );

Line 3309: fnd_msg_pub.count_and_get (

3305: );
3306: WHEN fnd_api.g_exc_unexpected_error THEN
3307: ROLLBACK TO Posting_lumpsum_amount;
3308: x_return_status := fnd_api.g_ret_sts_unexp_error;
3309: fnd_msg_pub.count_and_get (
3310: p_count=> x_msg_count
3311: ,p_data=> x_msg_data
3312: ,p_encoded=> fnd_api.g_false
3313: );

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

3314: WHEN OTHERS THEN
3315: ROLLBACK TO Posting_lumpsum_amount;
3316: x_return_status := fnd_api.g_ret_sts_unexp_error;
3317:
3318: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3319: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3320: END IF;
3321:
3322: fnd_msg_pub.count_and_get (

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

3315: ROLLBACK TO Posting_lumpsum_amount;
3316: x_return_status := fnd_api.g_ret_sts_unexp_error;
3317:
3318: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3319: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3320: END IF;
3321:
3322: fnd_msg_pub.count_and_get (
3323: p_count=> x_msg_count

Line 3322: fnd_msg_pub.count_and_get (

3318: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3319: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3320: END IF;
3321:
3322: fnd_msg_pub.count_and_get (
3323: p_count=> x_msg_count
3324: ,p_data=> x_msg_data
3325: ,p_encoded=> fnd_api.g_false
3326: );

Line 3385: fnd_msg_pub.initialize;

3381: END IF;
3382: x_return_status := fnd_api.g_ret_sts_success;
3383:
3384: IF fnd_api.to_boolean (p_init_msg_list) THEN
3385: fnd_msg_pub.initialize;
3386: END IF;
3387:
3388: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3389: RAISE fnd_api.g_exc_unexpected_error;

Line 3442: fnd_msg_pub.count_and_get (

3438: x_return_status := fnd_api.g_ret_sts_error;
3439: RAISE fnd_api.g_exc_error;
3440: END IF;
3441:
3442: fnd_msg_pub.count_and_get (
3443: p_encoded=> fnd_api.g_false
3444: ,p_count=> x_msg_count
3445: ,p_data=> x_msg_data
3446: );

Line 3455: fnd_msg_pub.count_and_get (

3451: EXCEPTION
3452: WHEN fnd_api.g_exc_error THEN
3453: ROLLBACK TO post_utilized_budget;
3454: x_return_status := fnd_api.g_ret_sts_error;
3455: fnd_msg_pub.count_and_get (
3456: p_count=> x_msg_count
3457: ,p_data=> x_msg_data
3458: ,p_encoded=> fnd_api.g_false
3459: );

Line 3463: fnd_msg_pub.count_and_get (

3459: );
3460: WHEN fnd_api.g_exc_unexpected_error THEN
3461: ROLLBACK TO post_utilized_budget;
3462: x_return_status := fnd_api.g_ret_sts_unexp_error;
3463: fnd_msg_pub.count_and_get (
3464: p_count=> x_msg_count
3465: ,p_data=> x_msg_data
3466: ,p_encoded=> fnd_api.g_false
3467: );

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

3468: WHEN OTHERS THEN
3469: ROLLBACK TO post_utilized_budget;
3470: x_return_status := fnd_api.g_ret_sts_unexp_error;
3471:
3472: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3473: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3474: END IF;
3475:
3476: fnd_msg_pub.count_and_get (

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

3469: ROLLBACK TO post_utilized_budget;
3470: x_return_status := fnd_api.g_ret_sts_unexp_error;
3471:
3472: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3473: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3474: END IF;
3475:
3476: fnd_msg_pub.count_and_get (
3477: p_count=> x_msg_count

Line 3476: fnd_msg_pub.count_and_get (

3472: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3473: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3474: END IF;
3475:
3476: fnd_msg_pub.count_and_get (
3477: p_count=> x_msg_count
3478: ,p_data=> x_msg_data
3479: ,p_encoded=> fnd_api.g_false
3480: );

Line 3652: fnd_msg_pub.initialize;

3648: END IF;
3649: x_return_status := fnd_api.g_ret_sts_success;
3650:
3651: IF fnd_api.to_boolean (p_init_msg_list) THEN
3652: fnd_msg_pub.initialize;
3653: END IF;
3654:
3655: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3656: RAISE fnd_api.g_exc_unexpected_error;

Line 3782: fnd_msg_pub.count_and_get (

3778: );
3779:
3780: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
3781: ROLLBACK TO recal_comm_fund_conc;
3782: fnd_msg_pub.count_and_get (
3783: p_count=> x_msg_count
3784: ,p_data=> x_msg_data
3785: ,p_encoded=> fnd_api.g_false
3786: );

Line 3900: fnd_msg_pub.count_and_get (

3896: EXIT WHEN l_amount_remaining = 0;
3897: END IF;
3898: END LOOP;
3899:
3900: fnd_msg_pub.count_and_get (
3901: p_encoded=> fnd_api.g_false
3902: ,p_count=> x_msg_count
3903: ,p_data=> x_msg_data
3904: );

Line 3913: fnd_msg_pub.count_and_get (

3909: EXCEPTION
3910: WHEN fnd_api.g_exc_error THEN
3911: ROLLBACK TO adjust_utilized_budget;
3912: x_return_status := fnd_api.g_ret_sts_error;
3913: fnd_msg_pub.count_and_get (
3914: p_count=> x_msg_count
3915: ,p_data=> x_msg_data
3916: ,p_encoded=> fnd_api.g_false
3917: );

Line 3921: fnd_msg_pub.count_and_get (

3917: );
3918: WHEN fnd_api.g_exc_unexpected_error THEN
3919: ROLLBACK TO adjust_utilized_budget;
3920: x_return_status := fnd_api.g_ret_sts_unexp_error;
3921: fnd_msg_pub.count_and_get (
3922: p_count=> x_msg_count
3923: ,p_data=> x_msg_data
3924: ,p_encoded=> fnd_api.g_false
3925: );

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

3926: WHEN OTHERS THEN
3927: ROLLBACK TO adjust_utilized_budget;
3928: x_return_status := fnd_api.g_ret_sts_unexp_error;
3929:
3930: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3931: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3932: END IF;
3933:
3934: fnd_msg_pub.count_and_get (

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

3927: ROLLBACK TO adjust_utilized_budget;
3928: x_return_status := fnd_api.g_ret_sts_unexp_error;
3929:
3930: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3931: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3932: END IF;
3933:
3934: fnd_msg_pub.count_and_get (
3935: p_count=> x_msg_count

Line 3934: fnd_msg_pub.count_and_get (

3930: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3931: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3932: END IF;
3933:
3934: fnd_msg_pub.count_and_get (
3935: p_count=> x_msg_count
3936: ,p_data=> x_msg_data
3937: ,p_encoded=> fnd_api.g_false
3938: );

Line 3983: fnd_msg_pub.initialize;

3979: END IF;
3980: x_return_status := fnd_api.g_ret_sts_success;
3981:
3982: IF fnd_api.to_boolean (p_init_msg_list) THEN
3983: fnd_msg_pub.initialize;
3984: END IF;
3985:
3986: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3987: RAISE fnd_api.g_exc_unexpected_error;

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

3997:
3998: IF (SQL%NOTFOUND) THEN
3999: -- Error, check the msg level and added an error message to the
4000: -- API message list
4001: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
4002: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
4003: fnd_msg_pub.ADD;
4004: END IF;
4005: RAISE fnd_api.g_exc_unexpected_error;

Line 4003: fnd_msg_pub.ADD;

3999: -- Error, check the msg level and added an error message to the
4000: -- API message list
4001: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
4002: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
4003: fnd_msg_pub.ADD;
4004: END IF;
4005: RAISE fnd_api.g_exc_unexpected_error;
4006: END IF;
4007: ELSE

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

4011:
4012: IF (SQL%NOTFOUND) THEN
4013: -- Error, check the msg level and added an error message to the
4014: -- API message list
4015: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
4016: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
4017: fnd_msg_pub.ADD;
4018: END IF;
4019: RAISE fnd_api.g_exc_unexpected_error;

Line 4017: fnd_msg_pub.ADD;

4013: -- Error, check the msg level and added an error message to the
4014: -- API message list
4015: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
4016: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
4017: fnd_msg_pub.ADD;
4018: END IF;
4019: RAISE fnd_api.g_exc_unexpected_error;
4020: END IF;
4021: END IF;

Line 4028: fnd_msg_pub.count_and_get (

4024: IF fnd_api.to_boolean (p_commit) THEN
4025: COMMIT WORK;
4026: END IF;
4027:
4028: fnd_msg_pub.count_and_get (
4029: p_encoded=> fnd_api.g_false
4030: ,p_count=> x_msg_count
4031: ,p_data=> x_msg_data
4032: );

Line 4041: fnd_msg_pub.count_and_get (

4037: EXCEPTION
4038: WHEN fnd_api.g_exc_error THEN
4039: ROLLBACK TO update_budget_source;
4040: x_return_status := fnd_api.g_ret_sts_error;
4041: fnd_msg_pub.count_and_get (
4042: p_count=> x_msg_count
4043: ,p_data=> x_msg_data
4044: ,p_encoded=> fnd_api.g_false
4045: );

Line 4049: fnd_msg_pub.count_and_get (

4045: );
4046: WHEN fnd_api.g_exc_unexpected_error THEN
4047: ROLLBACK TO update_budget_source;
4048: x_return_status := fnd_api.g_ret_sts_unexp_error;
4049: fnd_msg_pub.count_and_get (
4050: p_count=> x_msg_count
4051: ,p_data=> x_msg_data
4052: ,p_encoded=> fnd_api.g_false
4053: );

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

4054: WHEN OTHERS THEN
4055: ROLLBACK TO update_budget_source;
4056: x_return_status := fnd_api.g_ret_sts_unexp_error;
4057:
4058: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4059: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4060: END IF;
4061:
4062: fnd_msg_pub.count_and_get (

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

4055: ROLLBACK TO update_budget_source;
4056: x_return_status := fnd_api.g_ret_sts_unexp_error;
4057:
4058: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4059: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4060: END IF;
4061:
4062: fnd_msg_pub.count_and_get (
4063: p_count=> x_msg_count

Line 4062: fnd_msg_pub.count_and_get (

4058: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4059: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4060: END IF;
4061:
4062: fnd_msg_pub.count_and_get (
4063: p_count=> x_msg_count
4064: ,p_data=> x_msg_data
4065: ,p_encoded=> fnd_api.g_false
4066: );

Line 4210: fnd_msg_pub.initialize;

4206: END IF;
4207: x_return_status := fnd_api.g_ret_sts_success;
4208:
4209: IF fnd_api.to_boolean (p_init_msg_list) THEN
4210: fnd_msg_pub.initialize;
4211: END IF;
4212:
4213: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
4214: RAISE fnd_api.g_exc_unexpected_error;

Line 4350: fnd_msg_pub.count_and_get (

4346:
4347: CLOSE c_req_expense;
4348:
4349:
4350: fnd_msg_pub.count_and_get (
4351: p_encoded=> fnd_api.g_false
4352: ,p_count=> x_msg_count
4353: ,p_data=> x_msg_data
4354: );

Line 4362: fnd_msg_pub.count_and_get (

4358: EXCEPTION
4359: WHEN fnd_api.g_exc_error THEN
4360: ROLLBACK TO Posting_lumpsum_amount;
4361: x_return_status := fnd_api.g_ret_sts_error;
4362: fnd_msg_pub.count_and_get (
4363: p_count=> x_msg_count
4364: ,p_data=> x_msg_data
4365: ,p_encoded=> fnd_api.g_false
4366: );

Line 4370: fnd_msg_pub.count_and_get (

4366: );
4367: WHEN fnd_api.g_exc_unexpected_error THEN
4368: ROLLBACK TO Posting_lumpsum_amount;
4369: x_return_status := fnd_api.g_ret_sts_unexp_error;
4370: fnd_msg_pub.count_and_get (
4371: p_count=> x_msg_count
4372: ,p_data=> x_msg_data
4373: ,p_encoded=> fnd_api.g_false
4374: );

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

4375: WHEN OTHERS THEN
4376: ROLLBACK TO Posting_lumpsum_amount;
4377: x_return_status := fnd_api.g_ret_sts_unexp_error;
4378:
4379: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4380: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4381: END IF;
4382:
4383: fnd_msg_pub.count_and_get (

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

4376: ROLLBACK TO Posting_lumpsum_amount;
4377: x_return_status := fnd_api.g_ret_sts_unexp_error;
4378:
4379: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4380: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4381: END IF;
4382:
4383: fnd_msg_pub.count_and_get (
4384: p_count=> x_msg_count

Line 4383: fnd_msg_pub.count_and_get (

4379: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4380: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4381: END IF;
4382:
4383: fnd_msg_pub.count_and_get (
4384: p_count=> x_msg_count
4385: ,p_data=> x_msg_data
4386: ,p_encoded=> fnd_api.g_false
4387: );

Line 4431: fnd_msg_pub.count_and_get (

4427: object_version_number = l_obj_ver_num + 1
4428: WHERE request_header_id = l_req_header_id;
4429: END IF;
4430:
4431: fnd_msg_pub.count_and_get (
4432: p_count=> x_msg_count,
4433: p_data=> x_msg_data,
4434: p_encoded=> fnd_api.g_false
4435: );

Line 4440: fnd_msg_pub.count_and_get (

4436:
4437: EXCEPTION
4438: WHEN fnd_api.g_exc_error THEN
4439: x_return_status := fnd_api.g_ret_sts_error;
4440: fnd_msg_pub.count_and_get (
4441: p_count=> x_msg_count,
4442: p_data=> x_msg_data,
4443: p_encoded=> fnd_api.g_false
4444: );

Line 4447: fnd_msg_pub.count_and_get (

4443: p_encoded=> fnd_api.g_false
4444: );
4445: WHEN fnd_api.g_exc_unexpected_error THEN
4446: x_return_status := fnd_api.g_ret_sts_unexp_error;
4447: fnd_msg_pub.count_and_get (
4448: p_count=> x_msg_count,
4449: p_data=> x_msg_data,
4450: p_encoded=> fnd_api.g_false
4451: );

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

4451: );
4452: WHEN OTHERS THEN
4453: x_return_status := fnd_api.g_ret_sts_unexp_error;
4454:
4455: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4456: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4457: END IF;
4458:
4459: fnd_msg_pub.count_and_get (

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

4452: WHEN OTHERS THEN
4453: x_return_status := fnd_api.g_ret_sts_unexp_error;
4454:
4455: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4456: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4457: END IF;
4458:
4459: fnd_msg_pub.count_and_get (
4460: p_count=> x_msg_count,

Line 4459: fnd_msg_pub.count_and_get (

4455: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4456: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4457: END IF;
4458:
4459: fnd_msg_pub.count_and_get (
4460: p_count=> x_msg_count,
4461: p_data=> x_msg_data,
4462: p_encoded=> fnd_api.g_false
4463: );