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_UTILIZED_PVT dependencies on FND_MESSAGE

Line 410: l_fund_reconc_msg := fnd_message.get_string ('OZF', 'OZF_FUND_RECONCILE');

406: );
407: END IF;
408:
409: --Added for bug 7425189
410: l_fund_reconc_msg := fnd_message.get_string ('OZF', 'OZF_FUND_RECONCILE');
411: l_act_bud_cst_msg := fnd_message.get_string ('OZF', 'OZF_ACT_BUDG_CST_UTIL');
412:
413: -- if the utlization type is adjustment then the adjustment type is mandatory
414: IF l_utilization_rec.utilization_type IN ('ADJUSTMENT', 'CHARGEBACK', 'LEAD_ADJUSTMENT') THEN -- yzhao: 11.5.10 added CHARGEBACK, LEAD_ADJUSTMENT

Line 411: l_act_bud_cst_msg := fnd_message.get_string ('OZF', 'OZF_ACT_BUDG_CST_UTIL');

407: END IF;
408:
409: --Added for bug 7425189
410: l_fund_reconc_msg := fnd_message.get_string ('OZF', 'OZF_FUND_RECONCILE');
411: l_act_bud_cst_msg := fnd_message.get_string ('OZF', 'OZF_ACT_BUDG_CST_UTIL');
412:
413: -- if the utlization type is adjustment then the adjustment type is mandatory
414: IF l_utilization_rec.utilization_type IN ('ADJUSTMENT', 'CHARGEBACK', 'LEAD_ADJUSTMENT') THEN -- yzhao: 11.5.10 added CHARGEBACK, LEAD_ADJUSTMENT
415: OPEN c_adj_type (l_utilization_rec.adjustment_type_id);

Line 615: fnd_message.set_name ('OZF', 'OZF_NO_LEDGER_FOUND');

611: || ' id('
612: || l_utilization_rec.plan_id);
613: END IF;
614: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
615: fnd_message.set_name ('OZF', 'OZF_NO_LEDGER_FOUND');
616: fnd_message.set_token('OBJECT_TYPE', l_utilization_rec.plan_type);
617: fnd_message.set_token('OBJECT_ID', l_utilization_rec.plan_id);
618: fnd_msg_pub.ADD;
619: END IF;

Line 616: fnd_message.set_token('OBJECT_TYPE', l_utilization_rec.plan_type);

612: || l_utilization_rec.plan_id);
613: END IF;
614: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
615: fnd_message.set_name ('OZF', 'OZF_NO_LEDGER_FOUND');
616: fnd_message.set_token('OBJECT_TYPE', l_utilization_rec.plan_type);
617: fnd_message.set_token('OBJECT_ID', l_utilization_rec.plan_id);
618: fnd_msg_pub.ADD;
619: END IF;
620: x_return_status := fnd_api.g_ret_sts_error;

Line 617: fnd_message.set_token('OBJECT_ID', l_utilization_rec.plan_id);

613: END IF;
614: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
615: fnd_message.set_name ('OZF', 'OZF_NO_LEDGER_FOUND');
616: fnd_message.set_token('OBJECT_TYPE', l_utilization_rec.plan_type);
617: fnd_message.set_token('OBJECT_ID', l_utilization_rec.plan_id);
618: fnd_msg_pub.ADD;
619: END IF;
620: x_return_status := fnd_api.g_ret_sts_error;
621: RAISE fnd_api.g_exc_error;

Line 843: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');

839: IF (c_fund_b%NOTFOUND) THEN
840: CLOSE c_fund_b;
841:
842: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
843: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
844: fnd_msg_pub.ADD;
845: END IF;
846:
847: RAISE fnd_api.g_exc_error;

Line 956: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');

952: FETCH c_accrual_budget_reqeust INTO l_act_budget_id, l_act_budget_objver;
953: IF (c_accrual_budget_reqeust%NOTFOUND) THEN
954: CLOSE c_accrual_budget_reqeust;
955: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
956: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
957: fnd_msg_pub.ADD;
958: END IF;
959: RAISE fnd_api.g_exc_error;
960: END IF;

Line 982: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');

978: FETCH c_budget_request_utilrec INTO l_act_budget_id, l_act_budget_objver;
979: IF (c_budget_request_utilrec%NOTFOUND) THEN
980: CLOSE c_budget_request_utilrec;
981: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
982: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
983: fnd_msg_pub.ADD;
984: END IF;
985: RAISE fnd_api.g_exc_error;
986: END IF;

Line 1671: fnd_message.set_name ('OZF', 'OZF_GL_POST_FAILURE');

1667: l_gl_posted_flag := ozf_accrual_engine.G_GL_FLAG_FAIL; -- 'F';
1668: -- yzhao: 11/20 raise exception if gl posting failed for manual adjust earned amount
1669: IF l_utilization_rec.utilization_type IN ('ADJUSTMENT', 'CHARGEBACK', 'LEAD_ADJUSTMENT') AND
1670: l_utilization_rec.adjustment_type IN ('STANDARD', 'DECREASE_EARNED', 'DECREASE_COMM_EARNED') THEN
1671: fnd_message.set_name ('OZF', 'OZF_GL_POST_FAILURE');
1672: fnd_msg_pub.ADD;
1673: RAISE fnd_api.g_exc_error;
1674: ELSE
1675: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

Line 1676: fnd_message.set_name ('OZF', 'OZF_API_DEBUG_MESSAGE');

1672: fnd_msg_pub.ADD;
1673: RAISE fnd_api.g_exc_error;
1674: ELSE
1675: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1676: fnd_message.set_name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1677: fnd_message.set_token ('TEXT', 'Failed to post to GL for utilization id ' || l_utilization_rec.utilization_id);
1678: fnd_msg_pub.ADD;
1679: END IF;
1680: END IF;

Line 1677: fnd_message.set_token ('TEXT', 'Failed to post to GL for utilization id ' || l_utilization_rec.utilization_id);

1673: RAISE fnd_api.g_exc_error;
1674: ELSE
1675: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1676: fnd_message.set_name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1677: fnd_message.set_token ('TEXT', 'Failed to post to GL for utilization id ' || l_utilization_rec.utilization_id);
1678: fnd_msg_pub.ADD;
1679: END IF;
1680: END IF;
1681: END IF;

Line 1888: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');

1884: AND object_version_number = p_object_version;
1885:
1886: IF (SQL%NOTFOUND) THEN
1887: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1888: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1889: fnd_msg_pub.ADD;
1890: END IF;
1891:
1892: RAISE fnd_api.g_exc_error;

Line 1900: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');

1896: WHERE utilization_id = p_utilization_id;
1897:
1898: IF (SQL%NOTFOUND) THEN
1899: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1900: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1901: fnd_msg_pub.ADD;
1902: END IF;
1903:
1904: RAISE fnd_api.g_exc_error;

Line 2022: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');

2018: IF (c_utilization_b%NOTFOUND) THEN
2019: CLOSE c_utilization_b;
2020:
2021: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2022: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2023: fnd_msg_pub.ADD;
2024: END IF;
2025:
2026: RAISE fnd_api.g_exc_error;

Line 2048: fnd_message.set_name ('OZF', 'OZF_API_RESOURCE_LOCKED');

2044: WHEN ozf_utility_pvt.resource_locked THEN
2045: x_return_status := fnd_api.g_ret_sts_error;
2046:
2047: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2048: fnd_message.set_name ('OZF', 'OZF_API_RESOURCE_LOCKED');
2049: fnd_msg_pub.ADD;
2050: END IF;
2051:
2052: fnd_msg_pub.count_and_get (

Line 2365: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');

2361: AND object_version_number = l_utilization_rec.object_version_number;
2362:
2363: IF (SQL%NOTFOUND) THEN
2364: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2365: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2366: fnd_msg_pub.ADD;
2367: END IF;
2368:
2369: RAISE fnd_api.g_exc_error;

Line 2388: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');

2384: AND USERENV ('LANG') IN (language, source_lang);
2385:
2386: IF (SQL%NOTFOUND) THEN
2387: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2388: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2389: fnd_msg_pub.ADD;
2390: END IF;
2391:
2392: RAISE fnd_api.g_exc_error;

Line 2402: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');

2398: IF (c_fund_b%NOTFOUND) THEN
2399: CLOSE c_fund_b;
2400:
2401: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2402: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
2403: fnd_msg_pub.ADD;
2404: END IF;
2405:
2406: RAISE fnd_api.g_exc_error;

Line 2630: fnd_message.set_name ('OZF', 'OZF_NO_FUND_ID');

2626:
2627: ------------------------ fund_id --------------------------
2628: IF p_utilization_rec.fund_id IS NULL THEN -- check for fund id
2629: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2630: fnd_message.set_name ('OZF', 'OZF_NO_FUND_ID');
2631: fnd_msg_pub.ADD;
2632: END IF;
2633:
2634: x_return_status := fnd_api.g_ret_sts_error;

Line 2640: fnd_message.set_name ('OZF', 'OZF_NO_UTILIZED_AMOUNT');

2636:
2637: ------------------------ AMOUNT -------------------------------
2638: ELSIF p_utilization_rec.amount IS NULL THEN -- check for amount
2639: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2640: fnd_message.set_name ('OZF', 'OZF_NO_UTILIZED_AMOUNT');
2641: fnd_msg_pub.ADD;
2642: END IF;
2643:
2644: x_return_status := fnd_api.g_ret_sts_error;

Line 2649: fnd_message.set_name ('OZF', 'OZF_FUND_NO_ADJUSTMENT_TYPE');

2645: RETURN;
2646: ELSIF p_utilization_rec.utilization_type IN ('ADJUSTMENT', 'CHARGEBACK', 'LEAD_ADJUSTMENT') THEN
2647: IF p_utilization_rec.adjustment_type IS NULL THEN -- check for utilization
2648: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2649: fnd_message.set_name ('OZF', 'OZF_FUND_NO_ADJUSTMENT_TYPE');
2650: fnd_msg_pub.ADD;
2651: END IF;
2652:
2653: x_return_status := fnd_api.g_ret_sts_error;

Line 2660: fnd_message.set_name ('OZF', 'OZF_FUND_NO_CUST_ID');

2656: -- added for customer id for offers 8/14/2002 mpande
2657: IF p_utilization_rec.adjustment_type IN ('DECREASE_EARNED' ,'DECREASE_COMM_EARNED','STANDARD')
2658: AND p_utilization_rec.plan_type = 'OFFR' AND p_utilization_rec.cust_account_id IS NULL THEN -- check for utilization type
2659: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2660: fnd_message.set_name ('OZF', 'OZF_FUND_NO_CUST_ID');
2661: fnd_msg_pub.ADD;
2662: END IF;
2663: x_return_status := fnd_api.g_ret_sts_error;
2664: RETURN;

Line 2668: fnd_message.set_name ('OZF', 'OZF_FUND_NO_UTILIZATION_TYPE');

2664: RETURN;
2665: END IF;
2666: ELSIF p_utilization_rec.utilization_type IS NULL THEN -- check for utilization type
2667: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2668: fnd_message.set_name ('OZF', 'OZF_FUND_NO_UTILIZATION_TYPE');
2669: fnd_msg_pub.ADD;
2670: END IF;
2671:
2672: x_return_status := fnd_api.g_ret_sts_error;

Line 2707: fnd_message.set_name ('OZF', 'OZF_UTILIZED_DUPLICATE_ID');

2703: , 'utilization_id = '
2704: || p_utilization_rec.utilization_id
2705: ) = fnd_api.g_false THEN
2706: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2707: fnd_message.set_name ('OZF', 'OZF_UTILIZED_DUPLICATE_ID');
2708: fnd_msg_pub.ADD;
2709: END IF;
2710:
2711: x_return_status := fnd_api.g_ret_sts_error;

Line 2748: fnd_message.set_name ('OZF', 'OZF_BAD_FUND_ID');

2744: , -- Column name in the parent object that maps to the fk value
2745: p_utilization_rec.fund_id -- Value of fk to be validated against the parent object's pk column
2746: ) = fnd_api.g_false THEN
2747: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2748: fnd_message.set_name ('OZF', 'OZF_BAD_FUND_ID');
2749: fnd_msg_pub.ADD;
2750: END IF;
2751:
2752: x_return_status := fnd_api.g_ret_sts_error;

Line 2767: fnd_message.set_name ('OZF', 'OZFBAD_ADJUSTMENT_ID');

2763: , -- Column name in the parent object that maps to the fk value
2764: p_utilization_rec.adjustment_type_id -- Value of fk to be validated against the parent object's pk column
2765: ) = fnd_api.g_false THEN
2766: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2767: fnd_message.set_name ('OZF', 'OZFBAD_ADJUSTMENT_ID');
2768: fnd_msg_pub.ADD;
2769: END IF;
2770:
2771: x_return_status := fnd_api.g_ret_sts_error;

Line 2808: fnd_message.set_name ('OZF', 'OZF_BAD_UTILIZED_CODE');

2804: ,p_lookup_type=> 'OZF_UTILIZATION_TYPE'
2805: ,p_lookup_code=> p_utilization_rec.utilization_type
2806: ) = fnd_api.g_false THEN
2807: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2808: fnd_message.set_name ('OZF', 'OZF_BAD_UTILIZED_CODE');
2809: fnd_msg_pub.ADD;
2810: END IF;
2811:
2812: x_return_status := fnd_api.g_ret_sts_error;

Line 2825: fnd_message.set_name ('OZF', 'OZF_BAD_ADJUSTMENT_CODE');

2821: ,p_lookup_type=> 'OZF_ADJUSTMENT_TYPE'
2822: ,p_lookup_code=> p_utilization_rec.adjustment_type
2823: ) = fnd_api.g_false THEN
2824: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2825: fnd_message.set_name ('OZF', 'OZF_BAD_ADJUSTMENT_CODE');
2826: fnd_msg_pub.ADD;
2827: END IF;
2828:
2829: x_return_status := fnd_api.g_ret_sts_error;

Line 3217: fnd_message.set_name ('OZF', 'OZF_FUND_NO_COMMITTMENT');

3213: ,p_complete_rec.fund_id
3214: ,p_complete_rec.component_id
3215: ) = fnd_api.g_false THEN
3216: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3217: fnd_message.set_name ('OZF', 'OZF_FUND_NO_COMMITTMENT');
3218: fnd_msg_pub.ADD;
3219: END IF;
3220:
3221: x_return_status := fnd_api.g_ret_sts_error;

Line 3229: fnd_message.set_name ('OZF', 'OZF_FUND_NO_ADJUST');

3225:
3226:
3227: IF check_fund_active (p_complete_rec.fund_id) = fnd_api.g_false THEN
3228: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3229: fnd_message.set_name ('OZF', 'OZF_FUND_NO_ADJUST');
3230: fnd_msg_pub.ADD;
3231: END IF;
3232: x_return_status := fnd_api.g_ret_sts_error;
3233: RETURN;

Line 3243: fnd_message.set_name ('OZF', 'OZF_UTIL_NO_AMOUNT');

3239: IF p_complete_rec.adjustment_type = ('DECREASE_EARNED') THEN
3240: -- amount should be positive always
3241: IF NVL (p_complete_rec.amount, 0) <= 0 THEN
3242: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3243: fnd_message.set_name ('OZF', 'OZF_UTIL_NO_AMOUNT');
3244: fnd_msg_pub.ADD;
3245: END IF;
3246:
3247: x_return_status := fnd_api.g_ret_sts_error;

Line 3253: fnd_message.set_name ('OZF', 'OZF_UTIL_NO_AMOUNT');

3249: END IF;
3250: ELSE
3251: IF NVL (p_complete_rec.amount, 0) = 0 THEN
3252: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3253: fnd_message.set_name ('OZF', 'OZF_UTIL_NO_AMOUNT');
3254: fnd_msg_pub.ADD;
3255: END IF;
3256:
3257: x_return_status := fnd_api.g_ret_sts_error;

Line 3309: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');

3305: IF c_utilization%NOTFOUND THEN
3306: CLOSE c_utilization;
3307:
3308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3309: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
3310: fnd_msg_pub.ADD;
3311: END IF;
3312:
3313: RAISE fnd_api.g_exc_error;