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

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

96: -------------------------------------------------------------------------------
97: g_pkg_name CONSTANT VARCHAR2 (30) := 'OZF_ACCRUAL_ENGINE';
98: g_recal_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('OZF_BUDGET_ADJ_ALLOW_RECAL'),'N');
99: g_debug_flag VARCHAR2 (1) := 'N';
100: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
101: g_universal_currency CONSTANT VARCHAR2 (15) := fnd_profile.VALUE ('OZF_UNIV_CURR_CODE');
102: g_order_gl_phase CONSTANT VARCHAR2 (15) := NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
103: g_bulk_limit CONSTANT NUMBER := 5000; -- yzhao: Sep 8,2005 bulk fetch limit. It should get from profile.
104:

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

393: WHEN OTHERS THEN
394: IF c_budget%ISOPEN THEN
395: CLOSE c_budget;
396: END IF;
397: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
398: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Calculate Accrual');
399: END IF;
400: x_return_status := fnd_api.g_ret_sts_unexp_error;
401: END calculate_accrual_amount;

Line 398: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Calculate Accrual');

394: IF c_budget%ISOPEN THEN
395: CLOSE c_budget;
396: END IF;
397: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
398: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Calculate Accrual');
399: END IF;
400: x_return_status := fnd_api.g_ret_sts_unexp_error;
401: END calculate_accrual_amount;
402:

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

498:
499: IF (SQL%NOTFOUND) THEN
500: -- Error, check the msg level and added an error message to the
501: -- API message list
502: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
503: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
504: fnd_msg_pub.ADD;
505: END IF;
506: RAISE fnd_api.g_exc_unexpected_error;

Line 504: fnd_msg_pub.ADD;

500: -- Error, check the msg level and added an error message to the
501: -- API message list
502: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
503: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
504: fnd_msg_pub.ADD;
505: END IF;
506: RAISE fnd_api.g_exc_unexpected_error;
507: END IF;
508:

Line 637: fnd_msg_pub.count_and_get (

633: || ': insert complete' || l_act_budgets_rec.activity_budget_id);
634: END IF;
635:
636: -- Standard call to get message count AND IF count is 1, get message info.
637: fnd_msg_pub.count_and_get (
638: p_count=> x_msg_count,
639: p_data=> x_msg_data,
640: p_encoded=> fnd_api.g_false
641: );

Line 647: fnd_msg_pub.count_and_get (

643: EXCEPTION
644: WHEN fnd_api.g_exc_error THEN
645: ROLLBACK TO create_actbudgets_rec;
646: x_return_status := fnd_api.g_ret_sts_error;
647: fnd_msg_pub.count_and_get (
648: p_count=> x_msg_count,
649: p_data=> x_msg_data,
650: p_encoded=> fnd_api.g_false
651: );

Line 656: fnd_msg_pub.count_and_get (

652:
653: WHEN fnd_api.g_exc_unexpected_error THEN
654: ROLLBACK TO create_actbudgets_rec;
655: x_return_status := fnd_api.g_ret_sts_unexp_error;
656: fnd_msg_pub.count_and_get (
657: p_count=> x_msg_count,
658: p_data=> x_msg_data,
659: p_encoded=>fnd_api.g_false
660: );

Line 666: fnd_msg_pub.count_and_get (

662: WHEN OTHERS THEN
663: ROLLBACK TO create_actbudgets_rec;
664: x_return_status := fnd_api.g_ret_sts_unexp_error;
665:
666: fnd_msg_pub.count_and_get (
667: p_count=> x_msg_count,
668: p_data=> x_msg_data,
669: p_encoded=> fnd_api.g_false
670: );

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

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

Line 984: fnd_msg_pub.ADD;

980: IF (c_fund_b%NOTFOUND) THEN
981: CLOSE c_fund_b;
982: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
983: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
984: fnd_msg_pub.ADD;
985: END IF;
986: RAISE fnd_api.g_exc_error;
987: END IF;
988: CLOSE c_fund_b;

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

1243: END IF;
1244:
1245: --get amount for universal currency and used to update rollup amount.
1246: IF g_universal_currency IS NULL THEN
1247: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1248: fnd_message.set_name('OZF', 'OZF_UNIV_CURR_NOT_FOUND');
1249: fnd_msg_pub.add;
1250: END IF;
1251: RAISE fnd_api.g_exc_error;

Line 1249: fnd_msg_pub.add;

1245: --get amount for universal currency and used to update rollup amount.
1246: IF g_universal_currency IS NULL THEN
1247: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1248: fnd_message.set_name('OZF', 'OZF_UNIV_CURR_NOT_FOUND');
1249: fnd_msg_pub.add;
1250: END IF;
1251: RAISE fnd_api.g_exc_error;
1252: END IF;
1253:

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

1457: ,l_mc_col_8
1458: ,l_mc_col_9;
1459: IF (c_mc_trans%NOTFOUND) THEN
1460: CLOSE c_mc_trans;
1461: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1462: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1463: fnd_msg_pub.ADD;
1464: END IF;
1465: RAISE fnd_api.g_exc_error;

Line 1463: fnd_msg_pub.ADD;

1459: IF (c_mc_trans%NOTFOUND) THEN
1460: CLOSE c_mc_trans;
1461: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1462: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1463: fnd_msg_pub.ADD;
1464: END IF;
1465: RAISE fnd_api.g_exc_error;
1466: END IF;
1467: CLOSE c_mc_trans;

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

1539: IF (c_accrual_budget_reqeust%NOTFOUND) THEN
1540: ozf_utility_pvt.write_conc_log (' D: create_utilized_rec() ERROR customer fully accrual budget. can not find approved budget request record between fund '
1541: || l_utilization_rec.fund_id || ' and offer ' || l_plan_id);
1542: CLOSE c_accrual_budget_reqeust;
1543: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1544: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1545: fnd_msg_pub.ADD;
1546: END IF;
1547: RAISE fnd_api.g_exc_error;

Line 1545: fnd_msg_pub.ADD;

1541: || l_utilization_rec.fund_id || ' and offer ' || l_plan_id);
1542: CLOSE c_accrual_budget_reqeust;
1543: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1544: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1545: fnd_msg_pub.ADD;
1546: END IF;
1547: RAISE fnd_api.g_exc_error;
1548: END IF;
1549: CLOSE c_accrual_budget_reqeust;

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

1567: IF (c_budget_request_utilrec%NOTFOUND) THEN
1568: write_conc_log (' D: create_utilized_rec() ERROR customer fully accrual budget. can not find approved budget request record in utilization table between fund '
1569: || l_utilization_rec.fund_id || ' and offer ' || l_plan_id);
1570: CLOSE c_budget_request_utilrec;
1571: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1572: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1573: fnd_msg_pub.ADD;
1574: END IF;
1575: RAISE fnd_api.g_exc_error;

Line 1573: fnd_msg_pub.ADD;

1569: || l_utilization_rec.fund_id || ' and offer ' || l_plan_id);
1570: CLOSE c_budget_request_utilrec;
1571: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1572: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1573: fnd_msg_pub.ADD;
1574: END IF;
1575: RAISE fnd_api.g_exc_error;
1576: END IF;
1577: CLOSE c_budget_request_utilrec;

Line 1744: fnd_msg_pub.count_and_get (

1740: ozf_utility_pvt.write_conc_log( l_full_name
1741: || ': end' || l_event_id);
1742: END IF;
1743:
1744: fnd_msg_pub.count_and_get (
1745: p_count=> x_msg_count,
1746: p_data=> x_msg_data,
1747: p_encoded=> fnd_api.g_false
1748: );

Line 1754: fnd_msg_pub.count_and_get (

1750: EXCEPTION
1751: WHEN fnd_api.g_exc_error THEN
1752: ROLLBACK TO create_utilized_rec;
1753: x_return_status := fnd_api.g_ret_sts_error;
1754: fnd_msg_pub.count_and_get (
1755: p_count=> x_msg_count,
1756: p_data=> x_msg_data,
1757: p_encoded=> fnd_api.g_false
1758: );

Line 1763: fnd_msg_pub.count_and_get (

1759:
1760: WHEN fnd_api.g_exc_unexpected_error THEN
1761: ROLLBACK TO create_utilized_rec;
1762: x_return_status := fnd_api.g_ret_sts_unexp_error;
1763: fnd_msg_pub.count_and_get (
1764: p_count=> x_msg_count,
1765: p_data=> x_msg_data,
1766: p_encoded=> fnd_api.g_false
1767: );

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

1768:
1769: WHEN OTHERS THEN
1770: ROLLBACK TO create_utilized_rec;
1771: x_return_status := fnd_api.g_ret_sts_unexp_error;
1772: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1773: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1774: END IF;
1775: fnd_msg_pub.count_and_get (
1776: p_count=> x_msg_count,

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

1769: WHEN OTHERS THEN
1770: ROLLBACK TO create_utilized_rec;
1771: x_return_status := fnd_api.g_ret_sts_unexp_error;
1772: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1773: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1774: END IF;
1775: fnd_msg_pub.count_and_get (
1776: p_count=> x_msg_count,
1777: p_data=> x_msg_data,

Line 1775: fnd_msg_pub.count_and_get (

1771: x_return_status := fnd_api.g_ret_sts_unexp_error;
1772: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1773: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1774: END IF;
1775: fnd_msg_pub.count_and_get (
1776: p_count=> x_msg_count,
1777: p_data=> x_msg_data,
1778: p_encoded=> fnd_api.g_false
1779: );

Line 1915: fnd_msg_pub.count_and_get (

1911: RAISE fnd_api.g_exc_unexpected_error;
1912: END IF;
1913: END IF;
1914:
1915: fnd_msg_pub.count_and_get (
1916: p_count=> x_msg_count,
1917: p_data=>x_msg_data,
1918: p_encoded=> fnd_api.g_false
1919: );

Line 1924: fnd_msg_pub.count_and_get (

1920: EXCEPTION
1921: WHEN fnd_api.g_exc_error THEN
1922: ROLLBACK TO create_fund_utilization_acr;
1923: x_return_status := fnd_api.g_ret_sts_error;
1924: fnd_msg_pub.count_and_get (
1925: p_count=> x_msg_count
1926: ,p_data=> x_msg_data
1927: ,p_encoded=> fnd_api.g_false
1928: );

Line 1932: fnd_msg_pub.count_and_get (

1928: );
1929: WHEN fnd_api.g_exc_unexpected_error THEN
1930: ROLLBACK TO create_fund_utilization_acr;
1931: x_return_status := fnd_api.g_ret_sts_unexp_error;
1932: fnd_msg_pub.count_and_get (
1933: p_count=> x_msg_count
1934: ,p_data=> x_msg_data
1935: ,p_encoded=> fnd_api.g_false
1936: );

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

1937: WHEN OTHERS THEN
1938: ROLLBACK TO create_fund_utilization_acr;
1939: x_return_status := fnd_api.g_ret_sts_unexp_error;
1940:
1941: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1942: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1943: END IF;
1944:
1945: fnd_msg_pub.count_and_get (

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

1938: ROLLBACK TO create_fund_utilization_acr;
1939: x_return_status := fnd_api.g_ret_sts_unexp_error;
1940:
1941: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1942: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1943: END IF;
1944:
1945: fnd_msg_pub.count_and_get (
1946: p_count=> x_msg_count

Line 1945: fnd_msg_pub.count_and_get (

1941: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1942: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1943: END IF;
1944:
1945: fnd_msg_pub.count_and_get (
1946: p_count=> x_msg_count
1947: ,p_data=> x_msg_data
1948: ,p_encoded=> fnd_api.g_false
1949: );

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

2075: END IF;
2076:
2077: --- if this is not funded by a parent campaign or any budget the error OUT NOCOPY saying no budgte found
2078: IF l_fund_amt_tbl.COUNT = 0 THEN
2079: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2080: fnd_message.set_name ('OZF', 'OZF_FUND_NO_BUDGET_FOUND');
2081: fnd_message.set_token ('OFFER_ID', p_adj_amt_tbl(i).qp_list_header_id);
2082: fnd_msg_pub.ADD;
2083: END IF;

Line 2082: fnd_msg_pub.ADD;

2078: IF l_fund_amt_tbl.COUNT = 0 THEN
2079: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2080: fnd_message.set_name ('OZF', 'OZF_FUND_NO_BUDGET_FOUND');
2081: fnd_message.set_token ('OFFER_ID', p_adj_amt_tbl(i).qp_list_header_id);
2082: fnd_msg_pub.ADD;
2083: END IF;
2084: IF g_debug_flag = 'Y' THEN
2085: ozf_utility_pvt.write_conc_log(' D: post_adjust_to_budget() calculation for posting to budget failed. No posting to budget. RETURN');
2086: END IF;

Line 2262: fnd_msg_pub.count_and_get (

2258: END IF;
2259:
2260: x_return_status := fnd_api.g_ret_sts_success;
2261:
2262: fnd_msg_pub.count_and_get (
2263: p_count=> x_msg_count,
2264: p_data=> x_msg_data,
2265: p_encoded=> fnd_api.g_false
2266: );

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

2268: EXCEPTION
2269: WHEN OTHERS THEN
2270: x_return_status := fnd_api.g_ret_sts_unexp_error;
2271: ozf_utility_pvt.write_conc_log (' /**************UNEXPECTED EXCEPTION in ozf_accrual_engine.post_accrual_to_budget');
2272: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2273: fnd_msg_pub.add_exc_msg ('ozf_accrual_engine', 'post_accrual_to_budget');
2274: END IF;
2275: fnd_msg_pub.count_and_get (
2276: p_count=> x_msg_count,

Line 2273: fnd_msg_pub.add_exc_msg ('ozf_accrual_engine', 'post_accrual_to_budget');

2269: WHEN OTHERS THEN
2270: x_return_status := fnd_api.g_ret_sts_unexp_error;
2271: ozf_utility_pvt.write_conc_log (' /**************UNEXPECTED EXCEPTION in ozf_accrual_engine.post_accrual_to_budget');
2272: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2273: fnd_msg_pub.add_exc_msg ('ozf_accrual_engine', 'post_accrual_to_budget');
2274: END IF;
2275: fnd_msg_pub.count_and_get (
2276: p_count=> x_msg_count,
2277: p_data=> x_msg_data,

Line 2275: fnd_msg_pub.count_and_get (

2271: ozf_utility_pvt.write_conc_log (' /**************UNEXPECTED EXCEPTION in ozf_accrual_engine.post_accrual_to_budget');
2272: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2273: fnd_msg_pub.add_exc_msg ('ozf_accrual_engine', 'post_accrual_to_budget');
2274: END IF;
2275: fnd_msg_pub.count_and_get (
2276: p_count=> x_msg_count,
2277: p_data=> x_msg_data,
2278: p_encoded=> fnd_api.g_false
2279: );

Line 2437: fnd_msg_pub.initialize;

2433: RAISE fnd_api.g_exc_unexpected_error;
2434: END IF;
2435: -- Initialize message list IF p_init_msg_list is set to TRUE.
2436: IF fnd_api.to_boolean (p_init_msg_list) THEN
2437: fnd_msg_pub.initialize;
2438: END IF;
2439: -- Initialize API return status to success
2440: x_return_status := fnd_api.g_ret_sts_success;
2441:

Line 2868: fnd_msg_pub.count_and_get (

2864: IF g_debug_flag = 'Y' THEN
2865: ozf_utility_pvt.write_conc_log(' D: post_accrual_to_budget returns ' || l_return_status);
2866: END IF;
2867: x_return_status := l_return_status;
2868: fnd_msg_pub.count_and_get (
2869: p_count=> x_msg_count,
2870: p_data=> x_msg_data,
2871: p_encoded=> fnd_api.g_false
2872: );

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

2875: WHEN OTHERS THEN
2876: --ROLLBACK TO adjust_accrual;
2877: x_return_status := fnd_api.g_ret_sts_unexp_error;
2878: ozf_utility_pvt.write_conc_log(' /**************UNEXPECTED EXCEPTION in adjust_accrual *************/');
2879: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2880: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2881: END IF;
2882: fnd_msg_pub.count_and_get (
2883: p_count=> x_msg_count,

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

2876: --ROLLBACK TO adjust_accrual;
2877: x_return_status := fnd_api.g_ret_sts_unexp_error;
2878: ozf_utility_pvt.write_conc_log(' /**************UNEXPECTED EXCEPTION in adjust_accrual *************/');
2879: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2880: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2881: END IF;
2882: fnd_msg_pub.count_and_get (
2883: p_count=> x_msg_count,
2884: p_data=> x_msg_data,

Line 2882: fnd_msg_pub.count_and_get (

2878: ozf_utility_pvt.write_conc_log(' /**************UNEXPECTED EXCEPTION in adjust_accrual *************/');
2879: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2880: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2881: END IF;
2882: fnd_msg_pub.count_and_get (
2883: p_count=> x_msg_count,
2884: p_data=> x_msg_data,
2885: p_encoded=> fnd_api.g_false
2886: );

Line 3229: fnd_msg_pub.initialize;

3225: RAISE fnd_api.g_exc_unexpected_error;
3226: END IF;
3227: -- Initialize message list IF p_init_msg_list is set to TRUE.
3228: IF fnd_api.to_boolean (p_init_msg_list) THEN
3229: fnd_msg_pub.initialize;
3230: END IF;
3231: -- Initialize API return status to success
3232: x_return_status := fnd_api.g_ret_sts_success;
3233: <>

Line 3836: fnd_msg_pub.initialize;

3832:
3833: -- Dump All the MEssages from the Message list
3834: ozf_utility_pvt.write_conc_log;
3835: -- Initialize the Message list for NExt Processing
3836: fnd_msg_pub.initialize;
3837: ROLLBACK TO line_adjustment;
3838: -- return a status error
3839: x_return_status := fnd_api.g_ret_sts_error ;
3840: --5/30/2002 Added to exit the loop because we want to perform handle exception to put the me

Line 3858: fnd_msg_pub.count_and_get (

3854:
3855: END LOOP new_line_tbl_loop;
3856:
3857: -- Standard call to get message count and IF count is 1, get message info.
3858: fnd_msg_pub.count_and_get (
3859: p_count=> x_msg_count,
3860: p_data=> x_msg_data,
3861: p_encoded=> fnd_api.g_false
3862: );

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

3866: x_return_status := fnd_api.g_ret_sts_unexp_error;
3867: ozf_utility_pvt.write_conc_log (' /**************UNEXPECTED EXCEPTION*************/');
3868: ozf_utility_pvt.write_conc_log(' D: adjust_changed_order: exception. errcode=' || sqlcode || ' msg: ' || substr(sqlerrm, 1, 3000));
3869:
3870: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3871: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3872: END IF;
3873: fnd_msg_pub.count_and_get (
3874: p_count=> x_msg_count,

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

3867: ozf_utility_pvt.write_conc_log (' /**************UNEXPECTED EXCEPTION*************/');
3868: ozf_utility_pvt.write_conc_log(' D: adjust_changed_order: exception. errcode=' || sqlcode || ' msg: ' || substr(sqlerrm, 1, 3000));
3869:
3870: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3871: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3872: END IF;
3873: fnd_msg_pub.count_and_get (
3874: p_count=> x_msg_count,
3875: p_data=> x_msg_data,

Line 3873: fnd_msg_pub.count_and_get (

3869:
3870: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3871: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3872: END IF;
3873: fnd_msg_pub.count_and_get (
3874: p_count=> x_msg_count,
3875: p_data=> x_msg_data,
3876: p_encoded=> fnd_api.g_false
3877: );

Line 3950: fnd_msg_pub.initialize;

3946: l_que_msg_count NUMBER := 0 ;
3947: BEGIN
3948: -- Standard Start of process savepoint
3949: -- Start looping to check for messages in the queue
3950: fnd_msg_pub.initialize;
3951: g_debug_flag := p_debug ;
3952:
3953: SAVEPOINT get_message_savepoint;
3954:

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

4005: --if not sucess add a error message to th emessage listx
4006: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
4007: ozf_utility_pvt.write_conc_log ('Queue Return Error ');
4008:
4009: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
4010: fnd_message.set_name ('OZF', 'OZF_FUND_ASO_ORD_FEEDBACK_FAIL');
4011: fnd_msg_pub.ADD;
4012: END IF;
4013: ozf_utility_pvt.write_conc_log;

Line 4011: fnd_msg_pub.ADD;

4007: ozf_utility_pvt.write_conc_log ('Queue Return Error ');
4008:
4009: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
4010: fnd_message.set_name ('OZF', 'OZF_FUND_ASO_ORD_FEEDBACK_FAIL');
4011: fnd_msg_pub.ADD;
4012: END IF;
4013: ozf_utility_pvt.write_conc_log;
4014: RETURN;
4015: END IF;

Line 4149: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

4145:
4146: WHEN OTHERS THEN
4147: ROLLBACK TO get_message_loop_savepoint;
4148: ozf_utility_pvt.write_conc_log('FAILED');
4149: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4150: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
4151: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
4152: FND_MSG_PUB.Add;
4153: END IF;

Line 4152: FND_MSG_PUB.Add;

4148: ozf_utility_pvt.write_conc_log('FAILED');
4149: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4150: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
4151: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
4152: FND_MSG_PUB.Add;
4153: END IF;
4154: ozf_utility_pvt.write_conc_log;
4155:
4156: END;

Line 4244: fnd_msg_pub.initialize;

4240:
4241: BEGIN
4242: -- Standard Start of process savepoint
4243: -- Start looping to check for messages in the queue
4244: fnd_msg_pub.initialize;
4245: SAVEPOINT get_message_savepoint;
4246: -- dequeue the exception queue
4247: <>
4248: LOOP

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

4295: --ozf_utility_pvt.debug_message('l_return_status ='||l_return_status );
4296: --///added by mpande to write a error message to the list
4297: --if not sucess add a error message to th emessage list
4298: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
4299: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
4300: fnd_message.set_name ('OZF', 'OZF_FUND_ASO_ORD_FEEDBACK_FAIL');
4301: fnd_msg_pub.ADD;
4302: END IF;
4303: ozf_utility_pvt.write_conc_log;

Line 4301: fnd_msg_pub.ADD;

4297: --if not sucess add a error message to th emessage list
4298: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
4299: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
4300: fnd_message.set_name ('OZF', 'OZF_FUND_ASO_ORD_FEEDBACK_FAIL');
4301: fnd_msg_pub.ADD;
4302: END IF;
4303: ozf_utility_pvt.write_conc_log;
4304: RETURN;
4305: END IF;

Line 4412: FND_MSG_PUB.INITIALIZE;

4408: COMMIT;
4409: x_retcode := 0;
4410: ELSE
4411: ozf_utility_pvt.write_conc_log;
4412: FND_MSG_PUB.INITIALIZE;
4413: END IF;
4414: EXCEPTION
4415: WHEN FND_API.G_EXC_ERROR THEN
4416: ROLLBACK TO get_excep_loop_savepoint;

Line 4428: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

4424:
4425: WHEN OTHERS THEN
4426: ROLLBACK TO get_excep_loop_savepoint;
4427: ozf_utility_pvt.write_conc_log('FAILED');
4428: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4429: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
4430: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
4431: FND_MSG_PUB.Add;
4432: END IF;

Line 4431: FND_MSG_PUB.Add;

4427: ozf_utility_pvt.write_conc_log('FAILED');
4428: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4429: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
4430: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
4431: FND_MSG_PUB.Add;
4432: END IF;
4433: ozf_utility_pvt.write_conc_log;
4434: END;
4435: END LOOP exception_loop;

Line 4727: fnd_msg_pub.count_and_get (

4723: ELSE
4724: -- do not raise exception for gl posting error. Just mark it as failed and deal with it later
4725: l_gl_posted_flag := G_GL_FLAG_FAIL; -- 'F';
4726: -- 07/17/2003 yzhao: log error message
4727: fnd_msg_pub.count_and_get (
4728: p_count => x_msg_count,
4729: p_data => x_msg_data,
4730: p_encoded => fnd_api.g_false
4731: );

Line 4735: fnd_msg_pub.initialize;

4731: );
4732: ozf_utility_pvt.write_conc_log(' /****** Failed to post to GL ******/ for utilization id ' || p_util_utilization_id);
4733:
4734: ozf_utility_pvt.write_conc_log;
4735: fnd_msg_pub.initialize;
4736: END IF;
4737:
4738: END IF; --l_gl_posted_flag = G_GL_FLAG_NO
4739:

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

4750:
4751: IF l_gl_posted_flag IN(G_GL_FLAG_YES,G_GL_FLAG_NULL,G_GL_FLAG_NOLIAB) THEN
4752:
4753: IF g_universal_currency IS NULL THEN
4754: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4755: fnd_message.set_name('OZF', 'OZF_UNIV_CURR_NOT_FOUND');
4756: fnd_msg_pub.add;
4757: END IF;
4758: RAISE fnd_api.g_exc_error;

Line 4756: fnd_msg_pub.add;

4752:
4753: IF g_universal_currency IS NULL THEN
4754: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4755: fnd_message.set_name('OZF', 'OZF_UNIV_CURR_NOT_FOUND');
4756: fnd_msg_pub.add;
4757: END IF;
4758: RAISE fnd_api.g_exc_error;
4759: END IF;
4760:

Line 4911: fnd_msg_pub.count_and_get (

4907: WHEN OTHERS THEN
4908: ROLLBACK TO post_accrual_to_gl_sp;
4909: ozf_utility_pvt.write_conc_log(' D: post_accrual_to_gl(): exception ');
4910: x_return_status := fnd_api.g_ret_sts_unexp_error;
4911: fnd_msg_pub.count_and_get (
4912: p_count => x_msg_count,
4913: p_data => x_msg_data,
4914: p_encoded => fnd_api.g_false
4915: );

Line 5187: fnd_msg_pub.count_and_get (

5183: WHEN OTHERS THEN
5184: ROLLBACK TO post_offinvoice_to_gl_sp;
5185: x_retcode := 1;
5186: ozf_utility_pvt.write_conc_log(' D: post_offinvoice_to_gl(): exception ');
5187: fnd_msg_pub.count_and_get (
5188: p_count => l_msg_count,
5189: p_data => l_msg_data,
5190: p_encoded => fnd_api.g_false
5191: );

Line 5299: fnd_msg_pub.count_and_get (

5295: WHEN OTHERS THEN
5296: ROLLBACK TO post_related_accrual_to_gl_sp;
5297: ozf_utility_pvt.write_conc_log(' D: post_related_accrual_to_gl(): exception ');
5298: x_return_status := fnd_api.g_ret_sts_unexp_error;
5299: fnd_msg_pub.count_and_get (
5300: p_count => x_msg_count,
5301: p_data => x_msg_data,
5302: p_encoded => fnd_api.g_false
5303: );