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

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

56: g_pkg_name CONSTANT VARCHAR2 (30) := 'OZF_Adjustment_Ext_PVT';
57: g_recal_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('OZF_BUDGET_ADJ_ALLOW_RECAL'),'N');
58: g_order_gl_phase CONSTANT VARCHAR2 (15) :=NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
59: g_debug_flag VARCHAR2 (1) := 'N';
60: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
61: g_bulk_limit CONSTANT NUMBER := 5000;
62:
63: TYPE amountTbl IS TABLE OF ozf_funds_utilized_all_b.amount%TYPE;
64: TYPE glDateTbl IS TABLE OF ozf_funds_utilized_all_b.gl_date%TYPE;

Line 278: Fnd_Msg_Pub.initialize;

274:
275: BEGIN
276:
277: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
278: Fnd_Msg_Pub.initialize;
279: END IF;
280:
281: x_return_status := Fnd_Api.g_ret_sts_success;
282:

Line 1774: fnd_msg_pub.initialize;

1770:
1771: BEGIN
1772: g_debug_flag := p_debug ;
1773: write_conc_log (' /*************************** ADJUST BD START *************************/');
1774: fnd_msg_pub.initialize;
1775: SAVEPOINT adjust_backdated_offer;
1776: --Get All Active Backdated Offer where budget adjusted flag = 'N'
1777: g_offer_id_tbl.delete;
1778:

Line 1834: fnd_msg_pub.initialize;

1830: || l_offerAdjustmentIdTbl(i)
1831: || ' with the following Errors *******/'
1832: );
1833: ozf_utility_pvt.write_conc_log;
1834: fnd_msg_pub.initialize;
1835: ROLLBACK TO new_adjustment;
1836: GOTO l_endofloop;
1837: END IF;
1838: END IF;

Line 1909: fnd_msg_pub.initialize;

1905: || l_offerAdjustmentIdTbl(i)
1906: || ' with the following Errors *******/'
1907: );
1908: ozf_utility_pvt.write_conc_log;
1909: fnd_msg_pub.initialize;
1910: ROLLBACK TO new_adjustment;
1911: --kdass 21-JUN-2006 bug 5337761 - closed cursor on error
1912: CLOSE c_adjusted_line_cur;
1913: GOTO l_endofloop;

Line 1950: fnd_msg_pub.initialize;

1946: || l_offerAdjustmentIdTbl(i)
1947: || ' with the following Errors *******/'
1948: );
1949: ozf_utility_pvt.write_conc_log;
1950: fnd_msg_pub.initialize;
1951: ROLLBACK TO new_adjustment;
1952: GOTO l_endofloop;
1953: END IF;
1954:

Line 1972: fnd_msg_pub.initialize;

1968: || l_offerAdjustmentIdTbl(i)
1969: || ' with the following Errors /'
1970: );
1971: ozf_utility_pvt.write_conc_log;
1972: fnd_msg_pub.initialize;
1973: ROLLBACK TO new_adjustment;
1974: GOTO l_endofloop;
1975: END IF;
1976:

Line 1995: fnd_msg_pub.initialize;

1991: || l_offerAdjustmentIdTbl(i)
1992: || ' with the following Errors /'
1993: );
1994: ozf_utility_pvt.write_conc_log;
1995: fnd_msg_pub.initialize;
1996: ROLLBACK TO new_adjustment;
1997: GOTO l_endofloop;
1998: END IF;
1999: ------------

Line 2554: fnd_msg_pub.initialize;

2550: IF G_DEBUG THEN
2551: ozf_utility_pvt.debug_message (': begin ');
2552: END IF;
2553: IF fnd_api.to_boolean (p_init_msg_list) THEN
2554: fnd_msg_pub.initialize;
2555: END IF;
2556: OPEN c_offer_info;
2557: FETCH c_offer_info INTO l_offer_info;
2558: CLOSE c_offer_info;

Line 2721: fnd_msg_pub.GET

2717: /* FOR_DEBUGGING
2718: -- IF l_return_status <> 'S' THEN
2719: IF(x_msg_count > 0)THEN
2720: FOR I IN 1 .. x_msg_count LOOP
2721: fnd_msg_pub.GET
2722: (p_msg_index => FND_MSG_PUB.G_NEXT,
2723: p_encoded => FND_API.G_FALSE,
2724: p_data => x_msg_data,
2725: p_msg_index_out => l_index);

Line 2722: (p_msg_index => FND_MSG_PUB.G_NEXT,

2718: -- IF l_return_status <> 'S' THEN
2719: IF(x_msg_count > 0)THEN
2720: FOR I IN 1 .. x_msg_count LOOP
2721: fnd_msg_pub.GET
2722: (p_msg_index => FND_MSG_PUB.G_NEXT,
2723: p_encoded => FND_API.G_FALSE,
2724: p_data => x_msg_data,
2725: p_msg_index_out => l_index);
2726: --ozf_utility_pvt.write_conc_log(l_full_name||' : '||i||x_msg_data);

Line 2729: fnd_msg_pub.initialize;

2725: p_msg_index_out => l_index);
2726: --ozf_utility_pvt.write_conc_log(l_full_name||' : '||i||x_msg_data);
2727: DBMS_OUTPUT.put_line('****(PA):'||x_msg_data);
2728: END LOOP;
2729: fnd_msg_pub.initialize;
2730: END IF;
2731: -- END IF;
2732: END FOR_DEBUGGING */
2733: --DBMS_OUTPUT.put_line ( 'MESSAGE 11.5.9 (perform_adjustment) - END 2 :' || x_msg_data || 'msg count'|| x_msg_count || l_return_status);

Line 2769: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2765: EXCEPTION
2766: WHEN fnd_api.g_exc_error THEN
2767: ROLLBACK TO perform_adjustment;
2768: x_return_status := fnd_api.g_ret_sts_error;
2769: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2770: WHEN fnd_api.g_exc_unexpected_error THEN
2771: ROLLBACK TO perform_adjustment;
2772: x_return_status := fnd_api.g_ret_sts_unexp_error;
2773: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 2773: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2769: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2770: WHEN fnd_api.g_exc_unexpected_error THEN
2771: ROLLBACK TO perform_adjustment;
2772: x_return_status := fnd_api.g_ret_sts_unexp_error;
2773: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2774: WHEN OTHERS THEN
2775: ROLLBACK TO perform_adjustment;
2776: x_return_status := fnd_api.g_ret_sts_unexp_error;
2777: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

2773: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2774: WHEN OTHERS THEN
2775: ROLLBACK TO perform_adjustment;
2776: x_return_status := fnd_api.g_ret_sts_unexp_error;
2777: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2778: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2779: END IF;
2780: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2781: END perform_adjustment;

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

2774: WHEN OTHERS THEN
2775: ROLLBACK TO perform_adjustment;
2776: x_return_status := fnd_api.g_ret_sts_unexp_error;
2777: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2778: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2779: END IF;
2780: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2781: END perform_adjustment;
2782:

Line 2780: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2776: x_return_status := fnd_api.g_ret_sts_unexp_error;
2777: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2778: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2779: END IF;
2780: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2781: END perform_adjustment;
2782:
2783: -------------------------------------------------------------------
2784: -- NAME

Line 2966: FND_MSG_PUB.initialize;

2962: LIMIT g_bulk_limit;
2963:
2964: FOR i IN NVL(l_qpListHeaderIdTbl.FIRST, 1) .. NVL(l_qpListHeaderIdTbl.LAST, 0) LOOP
2965:
2966: FND_MSG_PUB.initialize;
2967: l_msg_count:= 0;
2968: l_msg_data := NULL;
2969: l_return_status := FND_API.g_ret_sts_success;
2970:

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

3021:
3022: WHEN OTHERS THEN
3023: ROLLBACK TO VOLUME_OFFER;
3024: OZF_UTILITY_PVT.write_conc_log(l_full_name ||' Volume Offer Adjustment Failed OT ==>'||'VOLUME OFFER '|| l_qpListHeaderIdTbl(i));
3025: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3026: OZF_UTILITY_PVT.write_conc_log;
3027: OZF_UTILITY_PVT.write_conc_log(' ');
3028: END;
3029:

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

3049:
3050: WHEN OTHERS THEN
3051: ROLLBACK TO adjust_volume_offer;
3052: OZF_UTILITY_PVT.write_conc_log;
3053: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3054: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3055: END IF;
3056: x_ERRBUF := l_msg_data;
3057: x_RETCODE := 1;

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

3050: WHEN OTHERS THEN
3051: ROLLBACK TO adjust_volume_offer;
3052: OZF_UTILITY_PVT.write_conc_log;
3053: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3054: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3055: END IF;
3056: x_ERRBUF := l_msg_data;
3057: x_RETCODE := 1;
3058:

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

3179: CLOSE c_offer_info;
3180:
3181: --- if this is not funded by a parent campaign or any budget the error out saying no budgte found
3182: IF l_fund_amt_tbl.COUNT = 0 OR x_return_status <> 'S' THEN
3183: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3184: fnd_message.set_name ('OZF', 'OZF_FUND_NO_BUDGET_FOUND');
3185: fnd_message.set_token ('OFFER_NAME', l_off_name);
3186: fnd_msg_pub.ADD;
3187: END IF;

Line 3186: fnd_msg_pub.ADD;

3182: IF l_fund_amt_tbl.COUNT = 0 OR x_return_status <> 'S' THEN
3183: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3184: fnd_message.set_name ('OZF', 'OZF_FUND_NO_BUDGET_FOUND');
3185: fnd_message.set_token ('OFFER_NAME', l_off_name);
3186: fnd_msg_pub.ADD;
3187: END IF;
3188: --dbms_output.put_line(' In error ');
3189: IF x_return_status = fnd_api.g_ret_sts_error THEN
3190: RAISE fnd_api.g_exc_error;

Line 3351: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3347: EXCEPTION
3348: WHEN fnd_api.g_exc_error THEN
3349: ROLLBACK TO process_accrual;
3350: x_return_status := fnd_api.g_ret_sts_error;
3351: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3352: WHEN fnd_api.g_exc_unexpected_error THEN
3353: ROLLBACK TO process_accrual;
3354: x_return_status := fnd_api.g_ret_sts_unexp_error;
3355: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 3355: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3351: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3352: WHEN fnd_api.g_exc_unexpected_error THEN
3353: ROLLBACK TO process_accrual;
3354: x_return_status := fnd_api.g_ret_sts_unexp_error;
3355: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3356: WHEN OTHERS THEN
3357: ROLLBACK TO process_accrual;
3358: x_return_status := fnd_api.g_ret_sts_unexp_error;
3359: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

3355: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3356: WHEN OTHERS THEN
3357: ROLLBACK TO process_accrual;
3358: x_return_status := fnd_api.g_ret_sts_unexp_error;
3359: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3360: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3361: END IF;
3362: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3363:

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

3356: WHEN OTHERS THEN
3357: ROLLBACK TO process_accrual;
3358: x_return_status := fnd_api.g_ret_sts_unexp_error;
3359: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3360: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3361: END IF;
3362: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3363:
3364: END process_accrual;

Line 3362: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3358: x_return_status := fnd_api.g_ret_sts_unexp_error;
3359: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3360: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3361: END IF;
3362: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3363:
3364: END process_accrual;
3365:
3366: ---------------------------------------------------------------------

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

3651: EXCEPTION
3652: WHEN OTHERS THEN
3653: x_return_status := fnd_api.g_ret_sts_error;
3654: RETURN NULL;
3655: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3656: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3657: END IF;
3658: END ;
3659:

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

3652: WHEN OTHERS THEN
3653: x_return_status := fnd_api.g_ret_sts_error;
3654: RETURN NULL;
3655: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3656: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3657: END IF;
3658: END ;
3659:
3660:

Line 4513: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4509: ozf_utility_pvt.debug_message(' /*************************** DEBUG MESSAGE END *************************/' || l_api_name );
4510: END IF;
4511: write_conc_log(' /*************************** DEBUG MESSAGE END *************************/' || l_api_name );
4512:
4513: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4514:
4515: x_return_status := l_return_status;
4516:
4517: EXCEPTION

Line 4521: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4517: EXCEPTION
4518: WHEN fnd_api.g_exc_error THEN
4519: ROLLBACK TO volume_offer_adjustment;
4520: x_return_status := fnd_api.g_ret_sts_error;
4521: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4522: WHEN fnd_api.g_exc_unexpected_error THEN
4523: ROLLBACK TO volume_offer_adjustment;
4524: x_return_status := fnd_api.g_ret_sts_unexp_error;
4525: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 4525: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4521: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4522: WHEN fnd_api.g_exc_unexpected_error THEN
4523: ROLLBACK TO volume_offer_adjustment;
4524: x_return_status := fnd_api.g_ret_sts_unexp_error;
4525: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4526: WHEN OTHERS THEN
4527: ROLLBACK TO volume_offer_adjustment;
4528: x_return_status := fnd_api.g_ret_sts_unexp_error;
4529: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

4525: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4526: WHEN OTHERS THEN
4527: ROLLBACK TO volume_offer_adjustment;
4528: x_return_status := fnd_api.g_ret_sts_unexp_error;
4529: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4530: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4531: END IF;
4532: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4533:

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

4526: WHEN OTHERS THEN
4527: ROLLBACK TO volume_offer_adjustment;
4528: x_return_status := fnd_api.g_ret_sts_unexp_error;
4529: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4530: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4531: END IF;
4532: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4533:
4534: END volume_offer_adjustment;

Line 4532: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4528: x_return_status := fnd_api.g_ret_sts_unexp_error;
4529: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4530: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4531: END IF;
4532: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4533:
4534: END volume_offer_adjustment;
4535:
4536: