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

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

94: g_file_name CONSTANT VARCHAR2 (12) := 'ozfvbdgb.pls';
95: g_cons_fund_mode CONSTANT VARCHAR2 (30) := 'ADJUST';
96: g_recal_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('OZF_BUDGET_ADJ_ALLOW_RECAL'),'N');
97: g_universal_currency CONSTANT VARCHAR2 (15) := fnd_profile.VALUE ('OZF_UNIV_CURR_CODE');
98: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
99: /*****************************************************************************************/
100: -- Start of Comments
101: --
102: --

Line 396: fnd_msg_pub.initialize;

392: END IF;
393:
394: -- Initialize message list IF p_init_msg_list is set to TRUE.
395: IF fnd_api.to_boolean (p_init_msg_list) THEN
396: fnd_msg_pub.initialize;
397: END IF;
398:
399: -- Initialize API return status to success
400: x_return_status := fnd_api.g_ret_sts_success;

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

762: || l_act_budgets_rec.arc_act_budget_used_by
763: || ' id('
764: || l_act_budgets_rec.act_budget_used_by_id);
765: END IF;
766: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
767: fnd_message.set_name ('OZF', 'OZF_NO_LEDGER_FOUND');
768: --Message OZF_NO_LEDGER_FOUND changed fix bug 5190932
769: --fnd_message.set_token('OBJECT_TYPE', l_act_budgets_rec.arc_act_budget_used_by);
770: --fnd_message.set_token('OBJECT_ID', l_act_budgets_rec.act_budget_used_by_id);

Line 771: fnd_msg_pub.ADD;

767: fnd_message.set_name ('OZF', 'OZF_NO_LEDGER_FOUND');
768: --Message OZF_NO_LEDGER_FOUND changed fix bug 5190932
769: --fnd_message.set_token('OBJECT_TYPE', l_act_budgets_rec.arc_act_budget_used_by);
770: --fnd_message.set_token('OBJECT_ID', l_act_budgets_rec.act_budget_used_by_id);
771: fnd_msg_pub.ADD;
772: END IF;
773: x_return_status := fnd_api.g_ret_sts_error;
774: RAISE fnd_api.g_exc_error;
775: END IF;

Line 1078: fnd_msg_pub.count_and_get (

1074: COMMIT WORK;
1075: END IF;
1076:
1077: -- Standard call to get message count AND IF count is 1, get message info.
1078: fnd_msg_pub.count_and_get (
1079: p_count=> x_msg_count
1080: ,p_data=> x_msg_data
1081: ,p_encoded=> fnd_api.g_false
1082: );

Line 1087: fnd_msg_pub.count_and_get (

1083: EXCEPTION
1084: WHEN fnd_api.g_exc_error THEN
1085: ROLLBACK TO create_act_budgets_pvt;
1086: x_return_status := fnd_api.g_ret_sts_error;
1087: fnd_msg_pub.count_and_get (
1088: p_count=> x_msg_count
1089: ,p_data=> x_msg_data
1090: ,p_encoded=> fnd_api.g_false
1091: );

Line 1095: fnd_msg_pub.count_and_get (

1091: );
1092: WHEN fnd_api.g_exc_unexpected_error THEN
1093: ROLLBACK TO create_act_budgets_pvt;
1094: x_return_status := fnd_api.g_ret_sts_unexp_error;
1095: fnd_msg_pub.count_and_get (
1096: p_count=> x_msg_count
1097: ,p_data=> x_msg_data
1098: ,p_encoded=> fnd_api.g_false
1099: );

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

1100: WHEN OTHERS THEN
1101: ROLLBACK TO create_act_budgets_pvt;
1102: x_return_status := fnd_api.g_ret_sts_unexp_error;
1103:
1104: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1105: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);
1106: END IF;
1107:
1108: fnd_msg_pub.count_and_get (

Line 1105: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);

1101: ROLLBACK TO create_act_budgets_pvt;
1102: x_return_status := fnd_api.g_ret_sts_unexp_error;
1103:
1104: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1105: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);
1106: END IF;
1107:
1108: fnd_msg_pub.count_and_get (
1109: p_count=> x_msg_count

Line 1108: fnd_msg_pub.count_and_get (

1104: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1105: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);
1106: END IF;
1107:
1108: fnd_msg_pub.count_and_get (
1109: p_count=> x_msg_count
1110: ,p_data=> x_msg_data
1111: ,p_encoded=> fnd_api.g_false
1112: );

Line 1455: fnd_msg_pub.initialize;

1451: END IF;
1452:
1453: -- Initialize message list IF p_init_msg_list is set to TRUE.
1454: IF fnd_api.to_boolean (p_init_msg_list) THEN
1455: fnd_msg_pub.initialize;
1456: END IF;
1457:
1458: -- Initialize API return status to success
1459: x_return_status := fnd_api.g_ret_sts_success;

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

1677: , l_objfundsum_rec.plan_curr_planned_amt
1678: , l_objfundsum_rec.univ_curr_planned_amt;
1679: IF c_get_objfundsum_rec%NOTFOUND THEN
1680: CLOSE c_get_objfundsum_rec;
1681: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1682: fnd_message.set_name('OZF', 'OZF_OBJFUNDSUM_RECORD_NOT_FOUND');
1683: fnd_msg_pub.add;
1684: END IF;
1685: RAISE fnd_api.g_exc_error;

Line 1683: fnd_msg_pub.add;

1679: IF c_get_objfundsum_rec%NOTFOUND THEN
1680: CLOSE c_get_objfundsum_rec;
1681: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1682: fnd_message.set_name('OZF', 'OZF_OBJFUNDSUM_RECORD_NOT_FOUND');
1683: fnd_msg_pub.add;
1684: END IF;
1685: RAISE fnd_api.g_exc_error;
1686: END IF;
1687: CLOSE c_get_objfundsum_rec;

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

2197: || l_act_budgets_rec.arc_act_budget_used_by
2198: || ' id('
2199: || l_act_budgets_rec.act_budget_used_by_id);
2200: END IF;
2201: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2202: fnd_message.set_name ('OZF', 'OZF_NO_LEDGER_FOUND');
2203: --Message OZF_NO_LEDGER_FOUND changed fix bug 5190932
2204: --fnd_message.set_token('OBJECT_TYPE', l_act_budgets_rec.arc_act_budget_used_by);
2205: --fnd_message.set_token('OBJECT_ID', l_act_budgets_rec.act_budget_used_by_id);

Line 2206: fnd_msg_pub.ADD;

2202: fnd_message.set_name ('OZF', 'OZF_NO_LEDGER_FOUND');
2203: --Message OZF_NO_LEDGER_FOUND changed fix bug 5190932
2204: --fnd_message.set_token('OBJECT_TYPE', l_act_budgets_rec.arc_act_budget_used_by);
2205: --fnd_message.set_token('OBJECT_ID', l_act_budgets_rec.act_budget_used_by_id);
2206: fnd_msg_pub.ADD;
2207: END IF;
2208: x_return_status := fnd_api.g_ret_sts_error;
2209: RAISE fnd_api.g_exc_error;
2210: END IF;

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

2326:
2327: IF (SQL%NOTFOUND) THEN
2328: -- Error, check the msg level and added an error message to the
2329: -- API message list
2330: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2331: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2332: fnd_msg_pub.ADD;
2333: END IF;
2334:

Line 2332: fnd_msg_pub.ADD;

2328: -- Error, check the msg level and added an error message to the
2329: -- API message list
2330: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2331: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2332: fnd_msg_pub.ADD;
2333: END IF;
2334:
2335: RAISE fnd_api.g_exc_unexpected_error;
2336: END IF;

Line 2525: fnd_msg_pub.count_and_get (

2521: COMMIT WORK;
2522: END IF;
2523:
2524: -- Standard call to get message count AND IF count is 1, get message info.
2525: fnd_msg_pub.count_and_get (
2526: p_count=> x_msg_count
2527: ,p_data=> x_msg_data
2528: ,p_encoded=> fnd_api.g_false
2529: );

Line 2534: fnd_msg_pub.count_and_get (

2530: EXCEPTION
2531: WHEN fnd_api.g_exc_error THEN
2532: ROLLBACK TO update_act_budgets_pvt;
2533: x_return_status := fnd_api.g_ret_sts_error;
2534: fnd_msg_pub.count_and_get (
2535: p_count=> x_msg_count
2536: ,p_data=> x_msg_data
2537: ,p_encoded=> fnd_api.g_false
2538: );

Line 2542: fnd_msg_pub.count_and_get (

2538: );
2539: WHEN fnd_api.g_exc_unexpected_error THEN
2540: ROLLBACK TO update_act_budgets_pvt;
2541: x_return_status := fnd_api.g_ret_sts_unexp_error;
2542: fnd_msg_pub.count_and_get (
2543: p_count=> x_msg_count
2544: ,p_data=> x_msg_data
2545: ,p_encoded=> fnd_api.g_false
2546: );

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

2547: WHEN OTHERS THEN
2548: ROLLBACK TO update_act_budgets_pvt;
2549: x_return_status := fnd_api.g_ret_sts_unexp_error;
2550:
2551: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2552: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);
2553: END IF;
2554:
2555: fnd_msg_pub.count_and_get (

Line 2552: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);

2548: ROLLBACK TO update_act_budgets_pvt;
2549: x_return_status := fnd_api.g_ret_sts_unexp_error;
2550:
2551: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2552: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);
2553: END IF;
2554:
2555: fnd_msg_pub.count_and_get (
2556: p_count=> x_msg_count

Line 2555: fnd_msg_pub.count_and_get (

2551: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2552: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);
2553: END IF;
2554:
2555: fnd_msg_pub.count_and_get (
2556: p_count=> x_msg_count
2557: ,p_data=> x_msg_data
2558: ,p_encoded=> fnd_api.g_false
2559: );

Line 2611: fnd_msg_pub.initialize;

2607: END IF;
2608:
2609: -- Initialize message list IF p_init_msg_list is set to TRUE.
2610: IF fnd_api.to_boolean (p_init_msg_list) THEN
2611: fnd_msg_pub.initialize;
2612: END IF;
2613:
2614: -- Initialize API return status to success
2615: x_return_status := fnd_api.g_ret_sts_success;

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

2621: FETCH c_status INTO l_status_code;
2622: CLOSE c_status;
2623:
2624: IF l_status_code NOT IN ('NEW') THEN
2625: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2626: fnd_message.set_name ('OZF', 'OZF_ACT_BUDGET_NO_DELETE');
2627: fnd_msg_pub.ADD;
2628: END IF;
2629:

Line 2627: fnd_msg_pub.ADD;

2623:
2624: IF l_status_code NOT IN ('NEW') THEN
2625: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2626: fnd_message.set_name ('OZF', 'OZF_ACT_BUDGET_NO_DELETE');
2627: fnd_msg_pub.ADD;
2628: END IF;
2629:
2630: RAISE fnd_api.g_exc_error;
2631: END IF;

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

2639: IF SQL%NOTFOUND THEN
2640: --
2641: -- Add error message to API message list.
2642: --
2643: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2644: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2645: fnd_msg_pub.ADD;
2646: END IF;
2647:

Line 2645: fnd_msg_pub.ADD;

2641: -- Add error message to API message list.
2642: --
2643: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2644: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2645: fnd_msg_pub.ADD;
2646: END IF;
2647:
2648: RAISE fnd_api.g_exc_error;
2649: END IF;

Line 2660: fnd_msg_pub.count_and_get (

2656: COMMIT WORK;
2657: END IF;
2658:
2659: -- Standard call to get message count AND IF count is 1, get message info.
2660: fnd_msg_pub.count_and_get (
2661: p_count=> x_msg_count
2662: ,p_data=> x_msg_data
2663: ,p_encoded=> fnd_api.g_false
2664: );

Line 2669: fnd_msg_pub.count_and_get (

2665: EXCEPTION
2666: WHEN fnd_api.g_exc_error THEN
2667: ROLLBACK TO delete_act_budgets_pvt;
2668: x_return_status := fnd_api.g_ret_sts_error;
2669: fnd_msg_pub.count_and_get (
2670: p_count=> x_msg_count
2671: ,p_data=> x_msg_data
2672: ,p_encoded=> fnd_api.g_false
2673: );

Line 2677: fnd_msg_pub.count_and_get (

2673: );
2674: WHEN fnd_api.g_exc_unexpected_error THEN
2675: ROLLBACK TO delete_act_budgets_pvt;
2676: x_return_status := fnd_api.g_ret_sts_unexp_error;
2677: fnd_msg_pub.count_and_get (
2678: p_count=> x_msg_count
2679: ,p_data=> x_msg_data
2680: ,p_encoded=> fnd_api.g_false
2681: );

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

2682: WHEN OTHERS THEN
2683: ROLLBACK TO delete_act_budgets_pvt;
2684: x_return_status := fnd_api.g_ret_sts_unexp_error;
2685:
2686: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2687: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);
2688: END IF;
2689:
2690: fnd_msg_pub.count_and_get (

Line 2687: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);

2683: ROLLBACK TO delete_act_budgets_pvt;
2684: x_return_status := fnd_api.g_ret_sts_unexp_error;
2685:
2686: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2687: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);
2688: END IF;
2689:
2690: fnd_msg_pub.count_and_get (
2691: p_count=> x_msg_count

Line 2690: fnd_msg_pub.count_and_get (

2686: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2687: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);
2688: END IF;
2689:
2690: fnd_msg_pub.count_and_get (
2691: p_count=> x_msg_count
2692: ,p_data=> x_msg_data
2693: ,p_encoded=> fnd_api.g_false
2694: );

Line 2741: fnd_msg_pub.initialize;

2737: END IF;
2738:
2739: -- Initialize message list if p_init_msg_list is set to TRUE.
2740: IF fnd_api.to_boolean (p_init_msg_list) THEN
2741: fnd_msg_pub.initialize;
2742: END IF;
2743:
2744: -- Initialize API return status to success
2745: x_return_status := fnd_api.g_ret_sts_success;

Line 2758: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN -- MMSG

2754: CLOSE c_act_budget;
2755:
2756: -- Error, check the msg level and added an error message to the
2757: -- API message list
2758: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN -- MMSG
2759: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2760: fnd_msg_pub.ADD;
2761: END IF;
2762:

Line 2760: fnd_msg_pub.ADD;

2756: -- Error, check the msg level and added an error message to the
2757: -- API message list
2758: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN -- MMSG
2759: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2760: fnd_msg_pub.ADD;
2761: END IF;
2762:
2763: RAISE fnd_api.g_exc_error;
2764: END IF;

Line 2771: fnd_msg_pub.count_and_get (

2767: --
2768: -- END of API body.
2769: --
2770: -- Standard call to get message count AND IF count is 1, get message info.
2771: fnd_msg_pub.count_and_get (
2772: p_count=> x_msg_count
2773: ,p_data=> x_msg_data
2774: ,p_encoded=> fnd_api.g_false
2775: );

Line 2779: fnd_msg_pub.count_and_get (

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

Line 2786: fnd_msg_pub.count_and_get (

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

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

2790: );
2791: WHEN ozf_utility_pvt.resource_locked THEN
2792: x_return_status := fnd_api.g_ret_sts_error;
2793:
2794: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2795: fnd_message.set_name ('OZF', 'OZF_API_RESOURCE_LOCKED');
2796: fnd_msg_pub.ADD;
2797: END IF;
2798:

Line 2796: fnd_msg_pub.ADD;

2792: x_return_status := fnd_api.g_ret_sts_error;
2793:
2794: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2795: fnd_message.set_name ('OZF', 'OZF_API_RESOURCE_LOCKED');
2796: fnd_msg_pub.ADD;
2797: END IF;
2798:
2799: fnd_msg_pub.count_and_get (
2800: p_count=> x_msg_count

Line 2799: fnd_msg_pub.count_and_get (

2795: fnd_message.set_name ('OZF', 'OZF_API_RESOURCE_LOCKED');
2796: fnd_msg_pub.ADD;
2797: END IF;
2798:
2799: fnd_msg_pub.count_and_get (
2800: p_count=> x_msg_count
2801: ,p_data=> x_msg_data
2802: ,p_encoded=> fnd_api.g_false
2803: );

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

2803: );
2804: WHEN OTHERS THEN
2805: x_return_status := fnd_api.g_ret_sts_unexp_error;
2806:
2807: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2808: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);
2809: END IF;
2810:
2811: fnd_msg_pub.count_and_get (

Line 2808: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);

2804: WHEN OTHERS THEN
2805: x_return_status := fnd_api.g_ret_sts_unexp_error;
2806:
2807: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2808: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);
2809: END IF;
2810:
2811: fnd_msg_pub.count_and_get (
2812: p_count=> x_msg_count

Line 2811: fnd_msg_pub.count_and_get (

2807: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2808: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);
2809: END IF;
2810:
2811: fnd_msg_pub.count_and_get (
2812: p_count=> x_msg_count
2813: ,p_data=> x_msg_data
2814: ,p_encoded=> fnd_api.g_false
2815: );

Line 2858: fnd_msg_pub.initialize;

2854: END IF;
2855:
2856: -- Initialize message list if p_init_msg_list is set to TRUE.
2857: IF fnd_api.to_boolean (p_init_msg_list) THEN
2858: fnd_msg_pub.initialize;
2859: END IF;
2860:
2861: -- Initialize API return status to success
2862: x_return_status := fnd_api.g_ret_sts_success;

Line 2913: fnd_msg_pub.count_and_get (

2909: --
2910: -- END of API body.
2911: --
2912: -------------------- finish --------------------------
2913: fnd_msg_pub.count_and_get (
2914: p_encoded=> fnd_api.g_false
2915: ,p_count=> x_msg_count
2916: ,p_data=> x_msg_data
2917: );

Line 2921: fnd_msg_pub.count_and_get (

2917: );
2918: EXCEPTION
2919: WHEN fnd_api.g_exc_error THEN
2920: x_return_status := fnd_api.g_ret_sts_error;
2921: fnd_msg_pub.count_and_get (
2922: p_count=> x_msg_count
2923: ,p_data=> x_msg_data
2924: ,p_encoded=> fnd_api.g_false
2925: );

Line 2928: fnd_msg_pub.count_and_get (

2924: ,p_encoded=> fnd_api.g_false
2925: );
2926: WHEN fnd_api.g_exc_unexpected_error THEN
2927: x_return_status := fnd_api.g_ret_sts_unexp_error;
2928: fnd_msg_pub.count_and_get (
2929: p_count=> x_msg_count
2930: ,p_data=> x_msg_data
2931: ,p_encoded=> fnd_api.g_false
2932: );

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

2932: );
2933: WHEN OTHERS THEN
2934: x_return_status := fnd_api.g_ret_sts_unexp_error;
2935:
2936: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2937: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);
2938: END IF;
2939:
2940: fnd_msg_pub.count_and_get (

Line 2937: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);

2933: WHEN OTHERS THEN
2934: x_return_status := fnd_api.g_ret_sts_unexp_error;
2935:
2936: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2937: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);
2938: END IF;
2939:
2940: fnd_msg_pub.count_and_get (
2941: p_count=> x_msg_count

Line 2940: fnd_msg_pub.count_and_get (

2936: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2937: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);
2938: END IF;
2939:
2940: fnd_msg_pub.count_and_get (
2941: p_count=> x_msg_count
2942: ,p_data=> x_msg_data
2943: ,p_encoded=> fnd_api.g_false
2944: );

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

2974: IF ( p_act_budgets_rec.act_budget_used_by_id = fnd_api.g_miss_num
2975: OR p_act_budgets_rec.act_budget_used_by_id IS NULL
2976: ) THEN
2977: -- missing required fields
2978: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2979: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_NO_USEDBYID');
2980: fnd_msg_pub.ADD;
2981: END IF;
2982:

Line 2980: fnd_msg_pub.ADD;

2976: ) THEN
2977: -- missing required fields
2978: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2979: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_NO_USEDBYID');
2980: fnd_msg_pub.ADD;
2981: END IF;
2982:
2983: x_return_status := fnd_api.g_ret_sts_error;
2984: -- If any error happens abort API.

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

2989: IF ( p_act_budgets_rec.budget_source_id = fnd_api.g_miss_num
2990: OR p_act_budgets_rec.budget_source_id IS NULL
2991: ) THEN
2992: -- missing required fields
2993: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2994: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_NO_SOURCEID');
2995: fnd_msg_pub.ADD;
2996: END IF;
2997:

Line 2995: fnd_msg_pub.ADD;

2991: ) THEN
2992: -- missing required fields
2993: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2994: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_NO_SOURCEID');
2995: fnd_msg_pub.ADD;
2996: END IF;
2997:
2998: x_return_status := fnd_api.g_ret_sts_error;
2999: -- If any error happens abort API.

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

3004: IF ( p_act_budgets_rec.budget_source_type = fnd_api.g_miss_char
3005: OR p_act_budgets_rec.budget_source_type IS NULL
3006: ) THEN
3007: -- missing required fields
3008: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3009: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_NO_SOURCETYPE');
3010: fnd_msg_pub.ADD;
3011: END IF;
3012:

Line 3010: fnd_msg_pub.ADD;

3006: ) THEN
3007: -- missing required fields
3008: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3009: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_NO_SOURCETYPE');
3010: fnd_msg_pub.ADD;
3011: END IF;
3012:
3013: x_return_status := fnd_api.g_ret_sts_error;
3014: -- If any error happens abort API.

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

3019: IF ( p_act_budgets_rec.transfer_type = fnd_api.g_miss_char
3020: OR p_act_budgets_rec.transfer_type IS NULL
3021: ) THEN
3022: -- missing required fields
3023: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3024: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_NO_TRANSYPE');
3025: fnd_msg_pub.ADD;
3026: END IF;
3027:

Line 3025: fnd_msg_pub.ADD;

3021: ) THEN
3022: -- missing required fields
3023: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3024: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_NO_TRANSYPE');
3025: fnd_msg_pub.ADD;
3026: END IF;
3027:
3028: x_return_status := fnd_api.g_ret_sts_error;
3029: -- If any error happens abort API.

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

3034: IF ( p_act_budgets_rec.arc_act_budget_used_by = fnd_api.g_miss_char
3035: OR p_act_budgets_rec.arc_act_budget_used_by IS NULL
3036: ) THEN
3037: -- missing required fields
3038: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3039: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_NO_USEDBY');
3040: fnd_msg_pub.ADD;
3041: END IF;
3042:

Line 3040: fnd_msg_pub.ADD;

3036: ) THEN
3037: -- missing required fields
3038: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3039: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_NO_USEDBY');
3040: fnd_msg_pub.ADD;
3041: END IF;
3042:
3043: x_return_status := fnd_api.g_ret_sts_error;
3044: -- If any error happens abort API.

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

3064: 'ozf_Act_budgets'
3065: , 'ACTIVITY_BUDGET_ID = '
3066: || p_act_budgets_rec.activity_budget_id
3067: ) = fnd_api.g_false THEN
3068: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3069: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_DUPLICATE_ID');
3070: fnd_msg_pub.ADD;
3071: END IF;
3072:

Line 3070: fnd_msg_pub.ADD;

3066: || p_act_budgets_rec.activity_budget_id
3067: ) = fnd_api.g_false THEN
3068: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3069: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_DUPLICATE_ID');
3070: fnd_msg_pub.ADD;
3071: END IF;
3072:
3073: x_return_status := fnd_api.g_ret_sts_error;
3074: RETURN;

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

3083: IF ams_utility_pvt.check_lookup_exists (
3084: p_lookup_type=> 'AMS_SYS_ARC_QUALIFIER'
3085: ,p_lookup_code=> p_act_budgets_rec.arc_act_budget_used_by
3086: ) = fnd_api.g_false THEN
3087: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3088: ozf_utility_pvt.debug_message ( 'Used By:'||p_act_budgets_rec.arc_act_budget_used_by);
3089: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_BAD_USEDBY');
3090: fnd_msg_pub.ADD;
3091: END IF;

Line 3090: fnd_msg_pub.ADD;

3086: ) = fnd_api.g_false THEN
3087: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3088: ozf_utility_pvt.debug_message ( 'Used By:'||p_act_budgets_rec.arc_act_budget_used_by);
3089: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_BAD_USEDBY');
3090: fnd_msg_pub.ADD;
3091: END IF;
3092:
3093: x_return_status := fnd_api.g_ret_sts_error;
3094: RETURN;

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

3102: IF ozf_utility_pvt.check_lookup_exists (
3103: p_lookup_type=> 'OZF_FUND_SOURCE'
3104: ,p_lookup_code=> p_act_budgets_rec.budget_source_type
3105: ) = fnd_api.g_false THEN
3106: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3107: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_BAD_SRCTYPE');
3108: fnd_msg_pub.ADD;
3109: END IF;
3110:

Line 3108: fnd_msg_pub.ADD;

3104: ,p_lookup_code=> p_act_budgets_rec.budget_source_type
3105: ) = fnd_api.g_false THEN
3106: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3107: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_BAD_SRCTYPE');
3108: fnd_msg_pub.ADD;
3109: END IF;
3110:
3111: x_return_status := fnd_api.g_ret_sts_error;
3112: RETURN;

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

3163: p_table_name=> l_table_name
3164: ,p_pk_name=> l_pk_name
3165: ,p_pk_value=> l_pk_value
3166: ) = fnd_api.g_false THEN
3167: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3168: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_BAD_USEDBYID');
3169: fnd_msg_pub.ADD;
3170: END IF;
3171:

Line 3169: fnd_msg_pub.ADD;

3165: ,p_pk_value=> l_pk_value
3166: ) = fnd_api.g_false THEN
3167: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3168: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_BAD_USEDBYID');
3169: fnd_msg_pub.ADD;
3170: END IF;
3171:
3172: x_return_status := fnd_api.g_ret_sts_error;
3173: -- If any errors happen abort API/Procedure.

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

3231: p_table_name=> l_table_name
3232: ,p_pk_name=> l_pk_name
3233: ,p_pk_value=> l_pk_value
3234: ) = fnd_api.g_false THEN
3235: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3236: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_BAD_SRCID');
3237: fnd_msg_pub.ADD;
3238: END IF;
3239:

Line 3237: fnd_msg_pub.ADD;

3233: ,p_pk_value=> l_pk_value
3234: ) = fnd_api.g_false THEN
3235: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3236: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_BAD_SRCID');
3237: fnd_msg_pub.ADD;
3238: END IF;
3239:
3240: x_return_status := fnd_api.g_ret_sts_error;
3241: -- If any errors happen abort API/Procedure.

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

3260: p_table_name=> l_table_name
3261: ,p_pk_name=> l_pk_name
3262: ,p_pk_value=> l_pk_value
3263: ) = fnd_api.g_false THEN
3264: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3265: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_BAD_APPRID');
3266: fnd_msg_pub.ADD;
3267: END IF;
3268:

Line 3266: fnd_msg_pub.ADD;

3262: ,p_pk_value=> l_pk_value
3263: ) = fnd_api.g_false THEN
3264: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3265: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_BAD_APPRID');
3266: fnd_msg_pub.ADD;
3267: END IF;
3268:
3269: x_return_status := fnd_api.g_ret_sts_error;
3270: -- If any errors happen abort API/Procedure.

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

3282: p_table_name=> l_table_name
3283: ,p_pk_name=> l_pk_name
3284: ,p_pk_value=> l_pk_value
3285: ) = fnd_api.g_false THEN
3286: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3287: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_BAD_APPRID');
3288: fnd_msg_pub.ADD;
3289: END IF;
3290:

Line 3288: fnd_msg_pub.ADD;

3284: ,p_pk_value=> l_pk_value
3285: ) = fnd_api.g_false THEN
3286: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3287: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_BAD_APPRID');
3288: fnd_msg_pub.ADD;
3289: END IF;
3290:
3291: x_return_status := fnd_api.g_ret_sts_error;
3292: -- If any errors happen abort API/Procedure.

Line 3624: Fnd_Msg_Pub.ADD;

3620: IF p_act_budgets_rec.date_required_by IS NOT NULL
3621: AND p_act_budgets_rec.date_required_by <> FND_API.G_MISS_DATE THEN
3622: IF p_act_budgets_rec.date_required_by < TRUNC(SYSDATE) THEN
3623: Fnd_Message.SET_NAME('OZF','OZF_ACT_REQDBYDATE_LT_SYSDATE');
3624: Fnd_Msg_Pub.ADD;
3625: RAISE FND_API.G_EXC_ERROR;
3626: END IF;
3627: END IF;
3628:

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

3661:
3662: IF c_budget%NOTFOUND THEN
3663: CLOSE c_budget;
3664:
3665: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3666: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
3667: fnd_msg_pub.ADD;
3668: END IF;
3669:

Line 3667: fnd_msg_pub.ADD;

3663: CLOSE c_budget;
3664:
3665: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3666: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
3667: fnd_msg_pub.ADD;
3668: END IF;
3669:
3670: RAISE fnd_api.g_exc_error;
3671: END IF;

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

4900:
4901: /*
4902: IF c_get_objfundsum_rec%NOTFOUND THEN
4903: CLOSE c_get_objfundsum_rec;
4904: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4905: fnd_message.set_name('OZF', 'OZF_OBJFUNDSUM_RECORD_NOT_FOUND');
4906: fnd_msg_pub.add;
4907: END IF;
4908: RAISE fnd_api.g_exc_error;

Line 4906: fnd_msg_pub.add;

4902: IF c_get_objfundsum_rec%NOTFOUND THEN
4903: CLOSE c_get_objfundsum_rec;
4904: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4905: fnd_message.set_name('OZF', 'OZF_OBJFUNDSUM_RECORD_NOT_FOUND');
4906: fnd_msg_pub.add;
4907: END IF;
4908: RAISE fnd_api.g_exc_error;
4909: END IF;
4910: */

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

5393: , l_objfundsum_rec.plan_curr_planned_amt
5394: , l_objfundsum_rec.univ_curr_planned_amt;
5395: IF c_get_objfundsum_rec%NOTFOUND THEN
5396: CLOSE c_get_objfundsum_rec;
5397: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
5398: fnd_message.set_name('OZF', 'OZF_OBJFUNDSUM_RECORD_NOT_FOUND');
5399: fnd_msg_pub.add;
5400: END IF;
5401: RAISE fnd_api.g_exc_error;

Line 5399: fnd_msg_pub.add;

5395: IF c_get_objfundsum_rec%NOTFOUND THEN
5396: CLOSE c_get_objfundsum_rec;
5397: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
5398: fnd_message.set_name('OZF', 'OZF_OBJFUNDSUM_RECORD_NOT_FOUND');
5399: fnd_msg_pub.add;
5400: END IF;
5401: RAISE fnd_api.g_exc_error;
5402: END IF;
5403: CLOSE c_get_objfundsum_rec;

Line 5547: fnd_msg_pub.initialize;

5543:
5544: x_return_status := fnd_api.g_ret_sts_success;
5545:
5546: /* IF fnd_api.to_boolean (p_init_msg_list) THEN
5547: fnd_msg_pub.initialize;
5548: END IF;
5549:
5550: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
5551: RAISE fnd_api.g_exc_unexpected_error;

Line 5652: fnd_msg_pub.count_and_get (

5648:
5649:
5650: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
5651: ROLLBACK TO create_child_act_budget;
5652: fnd_msg_pub.count_and_get (
5653: p_count=> x_msg_count
5654: ,p_data=> x_msg_data
5655: ,p_encoded=> fnd_api.g_false
5656: );

Line 5670: fnd_msg_pub.count_and_get (

5666:
5667:
5668: END LOOP;
5669:
5670: fnd_msg_pub.count_and_get (
5671: p_encoded=> fnd_api.g_false
5672: ,p_count=> x_msg_count
5673: ,p_data=> x_msg_data
5674: );

Line 5686: fnd_msg_pub.count_and_get (

5682: EXCEPTION
5683: WHEN fnd_api.g_exc_error THEN
5684: ROLLBACK TO create_child_act_budget;
5685: x_return_status := fnd_api.g_ret_sts_error;
5686: fnd_msg_pub.count_and_get (
5687: p_count=> x_msg_count
5688: ,p_data=> x_msg_data
5689: ,p_encoded=> fnd_api.g_false
5690: );

Line 5694: fnd_msg_pub.count_and_get (

5690: );
5691: WHEN fnd_api.g_exc_unexpected_error THEN
5692: ROLLBACK TO create_child_act_budget;
5693: x_return_status := fnd_api.g_ret_sts_unexp_error;
5694: fnd_msg_pub.count_and_get (
5695: p_count=> x_msg_count
5696: ,p_data=> x_msg_data
5697: ,p_encoded=> fnd_api.g_false
5698: );

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

5699: WHEN OTHERS THEN
5700: ROLLBACK TO create_child_act_budget;
5701: x_return_status := fnd_api.g_ret_sts_unexp_error;
5702:
5703: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5704: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);
5705: END IF;
5706:
5707: fnd_msg_pub.count_and_get (

Line 5704: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);

5700: ROLLBACK TO create_child_act_budget;
5701: x_return_status := fnd_api.g_ret_sts_unexp_error;
5702:
5703: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5704: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);
5705: END IF;
5706:
5707: fnd_msg_pub.count_and_get (
5708: p_count=> x_msg_count

Line 5707: fnd_msg_pub.count_and_get (

5703: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5704: fnd_msg_pub.add_exc_msg (g_package_name, l_api_name);
5705: END IF;
5706:
5707: fnd_msg_pub.count_and_get (
5708: p_count=> x_msg_count
5709: ,p_data=> x_msg_data
5710: ,p_encoded=> fnd_api.g_false
5711: );

Line 5887: Fnd_Msg_Pub.Initialize;

5883: ozf_utility_pvt.debug_message(l_full_name||': start');
5884: END IF;
5885:
5886: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
5887: Fnd_Msg_Pub.Initialize;
5888: END IF;
5889:
5890: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
5891: p_api_version,

Line 6134: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN

6130: WHERE objfundsum_id = l_objfundsum_rec.objfundsum_id
6131: AND object_version_number = l_objfundsum_rec.object_version_number;
6132:
6133: IF (SQL%NOTFOUND) THEN
6134: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
6135: Fnd_Message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
6136: Fnd_Msg_Pub.ADD;
6137: END IF;
6138: RAISE Fnd_Api.g_exc_error;

Line 6136: Fnd_Msg_Pub.ADD;

6132:
6133: IF (SQL%NOTFOUND) THEN
6134: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
6135: Fnd_Message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
6136: Fnd_Msg_Pub.ADD;
6137: END IF;
6138: RAISE Fnd_Api.g_exc_error;
6139: END IF;
6140:

Line 6141: Fnd_Msg_Pub.Count_And_Get (

6137: END IF;
6138: RAISE Fnd_Api.g_exc_error;
6139: END IF;
6140:
6141: Fnd_Msg_Pub.Count_And_Get (
6142: p_count => x_msg_count,
6143: p_data => x_msg_data,
6144: p_encoded => Fnd_Api.G_FALSE
6145: );

Line 6156: Fnd_Msg_Pub.Count_And_Get (

6152: EXCEPTION
6153: WHEN Fnd_Api.G_EXC_ERROR THEN
6154: ROLLBACK TO SP_update_reconcile_objfundsum;
6155: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6156: Fnd_Msg_Pub.Count_And_Get (
6157: p_count => x_msg_count,
6158: p_data => x_msg_data,
6159: p_encoded => FND_API.G_FALSE
6160: );

Line 6164: Fnd_Msg_Pub.Count_And_Get (

6160: );
6161: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
6162: ROLLBACK TO SP_update_reconcile_objfundsum;
6163: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6164: Fnd_Msg_Pub.Count_And_Get (
6165: p_count => x_msg_count,
6166: p_data => x_msg_data,
6167: p_encoded => FND_API.G_FALSE
6168: );

Line 6172: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

6168: );
6169: WHEN OTHERS THEN
6170: ROLLBACK TO SP_update_reconcile_objfundsum;
6171: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6172: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6173: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
6174: END IF;
6175: Fnd_Msg_Pub.Count_And_Get (
6176: p_count => x_msg_count,

Line 6173: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

6169: WHEN OTHERS THEN
6170: ROLLBACK TO SP_update_reconcile_objfundsum;
6171: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6172: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6173: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
6174: END IF;
6175: Fnd_Msg_Pub.Count_And_Get (
6176: p_count => x_msg_count,
6177: p_data => x_msg_data,

Line 6175: Fnd_Msg_Pub.Count_And_Get (

6171: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6172: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6173: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
6174: END IF;
6175: Fnd_Msg_Pub.Count_And_Get (
6176: p_count => x_msg_count,
6177: p_data => x_msg_data,
6178: p_encoded => FND_API.G_FALSE
6179: );