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 129: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

125: -------------------------------------------------------------------------------
126: g_pkg_name CONSTANT VARCHAR2 (30) := 'OZF_ACCRUAL_ENGINE';
127: g_recal_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('OZF_BUDGET_ADJ_ALLOW_RECAL'),'N');
128: g_debug_flag VARCHAR2 (1) := 'N';
129: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
130: g_universal_currency CONSTANT VARCHAR2 (15) := fnd_profile.VALUE ('OZF_UNIV_CURR_CODE');
131: g_order_gl_phase CONSTANT VARCHAR2 (15) := NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
132: g_bulk_limit CONSTANT NUMBER := 5000; -- yzhao: Sep 8,2005 bulk fetch limit. It should get from profile.
133: g_message_count NUMBER := -1; --nirprasa, added for bug 8435487 to restrict thenumber of ASO messages to be processed

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

478: WHEN OTHERS THEN
479: IF c_budget%ISOPEN THEN
480: CLOSE c_budget;
481: END IF;
482: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
483: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Calculate Accrual');
484: END IF;
485: x_return_status := fnd_api.g_ret_sts_unexp_error;
486: END calculate_accrual_amount;

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

479: IF c_budget%ISOPEN THEN
480: CLOSE c_budget;
481: END IF;
482: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
483: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Calculate Accrual');
484: END IF;
485: x_return_status := fnd_api.g_ret_sts_unexp_error;
486: END calculate_accrual_amount;
487:

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

688:
689: IF (SQL%NOTFOUND) THEN
690: -- Error, check the msg level and added an error message to the
691: -- API message list
692: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
693: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
694: fnd_msg_pub.ADD;
695: END IF;
696: RAISE fnd_api.g_exc_unexpected_error;

Line 694: fnd_msg_pub.ADD;

690: -- Error, check the msg level and added an error message to the
691: -- API message list
692: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
693: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
694: fnd_msg_pub.ADD;
695: END IF;
696: RAISE fnd_api.g_exc_unexpected_error;
697: END IF;
698:

Line 788: fnd_msg_pub.count_and_get (

784: || ': insert complete' || l_act_budgets_rec.activity_budget_id);
785: END IF;
786:
787: -- Standard call to get message count AND IF count is 1, get message info.
788: fnd_msg_pub.count_and_get (
789: p_count=> x_msg_count,
790: p_data=> x_msg_data,
791: p_encoded=> fnd_api.g_false
792: );

Line 798: fnd_msg_pub.count_and_get (

794: EXCEPTION
795: WHEN fnd_api.g_exc_error THEN
796: ROLLBACK TO create_actbudgets_rec;
797: x_return_status := fnd_api.g_ret_sts_error;
798: fnd_msg_pub.count_and_get (
799: p_count=> x_msg_count,
800: p_data=> x_msg_data,
801: p_encoded=> fnd_api.g_false
802: );

Line 807: fnd_msg_pub.count_and_get (

803:
804: WHEN fnd_api.g_exc_unexpected_error THEN
805: ROLLBACK TO create_actbudgets_rec;
806: x_return_status := fnd_api.g_ret_sts_unexp_error;
807: fnd_msg_pub.count_and_get (
808: p_count=> x_msg_count,
809: p_data=> x_msg_data,
810: p_encoded=>fnd_api.g_false
811: );

Line 817: fnd_msg_pub.count_and_get (

813: WHEN OTHERS THEN
814: ROLLBACK TO create_actbudgets_rec;
815: x_return_status := fnd_api.g_ret_sts_unexp_error;
816:
817: fnd_msg_pub.count_and_get (
818: p_count=> x_msg_count,
819: p_data=> x_msg_data,
820: p_encoded=> fnd_api.g_false
821: );

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

1229: ,l_utilized_amt
1230: ,l_rollup_utilized_amt;
1231: IF (c_fund_b%NOTFOUND) THEN
1232: CLOSE c_fund_b;
1233: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1234: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1235: fnd_msg_pub.ADD;
1236: END IF;
1237: RAISE fnd_api.g_exc_error;

Line 1235: fnd_msg_pub.ADD;

1231: IF (c_fund_b%NOTFOUND) THEN
1232: CLOSE c_fund_b;
1233: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1234: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1235: fnd_msg_pub.ADD;
1236: END IF;
1237: RAISE fnd_api.g_exc_error;
1238: END IF;
1239: CLOSE c_fund_b;

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

1579: END IF;
1580:
1581: --get amount for universal currency and used to update rollup amount.
1582: IF g_universal_currency IS NULL THEN
1583: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1584: fnd_message.set_name('OZF', 'OZF_UNIV_CURR_NOT_FOUND');
1585: fnd_msg_pub.add;
1586: END IF;
1587: RAISE fnd_api.g_exc_error;

Line 1585: fnd_msg_pub.add;

1581: --get amount for universal currency and used to update rollup amount.
1582: IF g_universal_currency IS NULL THEN
1583: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1584: fnd_message.set_name('OZF', 'OZF_UNIV_CURR_NOT_FOUND');
1585: fnd_msg_pub.add;
1586: END IF;
1587: RAISE fnd_api.g_exc_error;
1588: END IF;
1589:

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

1863: ,l_mc_col_8
1864: ,l_mc_col_9;
1865: IF (c_mc_trans%NOTFOUND) THEN
1866: CLOSE c_mc_trans;
1867: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1868: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1869: fnd_msg_pub.ADD;
1870: END IF;
1871: RAISE fnd_api.g_exc_error;

Line 1869: fnd_msg_pub.ADD;

1865: IF (c_mc_trans%NOTFOUND) THEN
1866: CLOSE c_mc_trans;
1867: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1868: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1869: fnd_msg_pub.ADD;
1870: END IF;
1871: RAISE fnd_api.g_exc_error;
1872: END IF;
1873: CLOSE c_mc_trans;

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

1947: IF (c_accrual_budget_reqeust%NOTFOUND) THEN
1948: ozf_utility_pvt.write_conc_log (' D: create_utilized_rec() ERROR customer fully accrual budget. can not find approved budget request record between fund '
1949: || l_utilization_rec.fund_id || ' and offer ' || l_plan_id);
1950: CLOSE c_accrual_budget_reqeust;
1951: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1952: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1953: fnd_msg_pub.ADD;
1954: END IF;
1955: RAISE fnd_api.g_exc_error;

Line 1953: fnd_msg_pub.ADD;

1949: || l_utilization_rec.fund_id || ' and offer ' || l_plan_id);
1950: CLOSE c_accrual_budget_reqeust;
1951: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1952: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1953: fnd_msg_pub.ADD;
1954: END IF;
1955: RAISE fnd_api.g_exc_error;
1956: END IF;
1957: CLOSE c_accrual_budget_reqeust;

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

1975: IF (c_budget_request_utilrec%NOTFOUND) THEN
1976: write_conc_log (' D: create_utilized_rec() ERROR customer fully accrual budget. can not find approved budget request record in utilization table between fund '
1977: || l_utilization_rec.fund_id || ' and offer ' || l_plan_id);
1978: CLOSE c_budget_request_utilrec;
1979: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1980: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1981: fnd_msg_pub.ADD;
1982: END IF;
1983: RAISE fnd_api.g_exc_error;

Line 1981: fnd_msg_pub.ADD;

1977: || l_utilization_rec.fund_id || ' and offer ' || l_plan_id);
1978: CLOSE c_budget_request_utilrec;
1979: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1980: fnd_message.set_name ('OZF', 'OZF_API_RECORD_NOT_FOUND');
1981: fnd_msg_pub.ADD;
1982: END IF;
1983: RAISE fnd_api.g_exc_error;
1984: END IF;
1985: CLOSE c_budget_request_utilrec;

Line 2153: fnd_msg_pub.count_and_get (

2149: ozf_utility_pvt.write_conc_log( l_full_name
2150: || ': end' || l_event_id);
2151: END IF;
2152:
2153: fnd_msg_pub.count_and_get (
2154: p_count=> x_msg_count,
2155: p_data=> x_msg_data,
2156: p_encoded=> fnd_api.g_false
2157: );

Line 2163: fnd_msg_pub.count_and_get (

2159: EXCEPTION
2160: WHEN fnd_api.g_exc_error THEN
2161: ROLLBACK TO create_utilized_rec;
2162: x_return_status := fnd_api.g_ret_sts_error;
2163: fnd_msg_pub.count_and_get (
2164: p_count=> x_msg_count,
2165: p_data=> x_msg_data,
2166: p_encoded=> fnd_api.g_false
2167: );

Line 2172: fnd_msg_pub.count_and_get (

2168:
2169: WHEN fnd_api.g_exc_unexpected_error THEN
2170: ROLLBACK TO create_utilized_rec;
2171: x_return_status := fnd_api.g_ret_sts_unexp_error;
2172: fnd_msg_pub.count_and_get (
2173: p_count=> x_msg_count,
2174: p_data=> x_msg_data,
2175: p_encoded=> fnd_api.g_false
2176: );

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

2177:
2178: WHEN OTHERS THEN
2179: ROLLBACK TO create_utilized_rec;
2180: x_return_status := fnd_api.g_ret_sts_unexp_error;
2181: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2182: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2183: END IF;
2184: fnd_msg_pub.count_and_get (
2185: p_count=> x_msg_count,

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

2178: WHEN OTHERS THEN
2179: ROLLBACK TO create_utilized_rec;
2180: x_return_status := fnd_api.g_ret_sts_unexp_error;
2181: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2182: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2183: END IF;
2184: fnd_msg_pub.count_and_get (
2185: p_count=> x_msg_count,
2186: p_data=> x_msg_data,

Line 2184: fnd_msg_pub.count_and_get (

2180: x_return_status := fnd_api.g_ret_sts_unexp_error;
2181: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2182: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2183: END IF;
2184: fnd_msg_pub.count_and_get (
2185: p_count=> x_msg_count,
2186: p_data=> x_msg_data,
2187: p_encoded=> fnd_api.g_false
2188: );

Line 2344: fnd_msg_pub.count_and_get (

2340: RAISE fnd_api.g_exc_unexpected_error;
2341: END IF;
2342: END IF;
2343:
2344: fnd_msg_pub.count_and_get (
2345: p_count=> x_msg_count,
2346: p_data=>x_msg_data,
2347: p_encoded=> fnd_api.g_false
2348: );

Line 2353: fnd_msg_pub.count_and_get (

2349: EXCEPTION
2350: WHEN fnd_api.g_exc_error THEN
2351: ROLLBACK TO create_fund_utilization_acr;
2352: x_return_status := fnd_api.g_ret_sts_error;
2353: fnd_msg_pub.count_and_get (
2354: p_count=> x_msg_count
2355: ,p_data=> x_msg_data
2356: ,p_encoded=> fnd_api.g_false
2357: );

Line 2361: fnd_msg_pub.count_and_get (

2357: );
2358: WHEN fnd_api.g_exc_unexpected_error THEN
2359: ROLLBACK TO create_fund_utilization_acr;
2360: x_return_status := fnd_api.g_ret_sts_unexp_error;
2361: fnd_msg_pub.count_and_get (
2362: p_count=> x_msg_count
2363: ,p_data=> x_msg_data
2364: ,p_encoded=> fnd_api.g_false
2365: );

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

2366: WHEN OTHERS THEN
2367: ROLLBACK TO create_fund_utilization_acr;
2368: x_return_status := fnd_api.g_ret_sts_unexp_error;
2369:
2370: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2371: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2372: END IF;
2373:
2374: fnd_msg_pub.count_and_get (

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

2367: ROLLBACK TO create_fund_utilization_acr;
2368: x_return_status := fnd_api.g_ret_sts_unexp_error;
2369:
2370: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2371: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2372: END IF;
2373:
2374: fnd_msg_pub.count_and_get (
2375: p_count=> x_msg_count

Line 2374: fnd_msg_pub.count_and_get (

2370: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2371: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2372: END IF;
2373:
2374: fnd_msg_pub.count_and_get (
2375: p_count=> x_msg_count
2376: ,p_data=> x_msg_data
2377: ,p_encoded=> fnd_api.g_false
2378: );

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

2504: END IF;
2505:
2506: --- if this is not funded by a parent campaign or any budget the error OUT NOCOPY saying no budgte found
2507: IF l_fund_amt_tbl.COUNT = 0 THEN
2508: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2509: fnd_message.set_name ('OZF', 'OZF_FUND_NO_BUDGET_FOUND');
2510: fnd_message.set_token ('OFFER_ID', p_adj_amt_tbl(i).qp_list_header_id);
2511: fnd_msg_pub.ADD;
2512: END IF;

Line 2511: fnd_msg_pub.ADD;

2507: IF l_fund_amt_tbl.COUNT = 0 THEN
2508: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2509: fnd_message.set_name ('OZF', 'OZF_FUND_NO_BUDGET_FOUND');
2510: fnd_message.set_token ('OFFER_ID', p_adj_amt_tbl(i).qp_list_header_id);
2511: fnd_msg_pub.ADD;
2512: END IF;
2513: IF g_debug_flag = 'Y' THEN
2514: ozf_utility_pvt.write_conc_log(' D: post_adjust_to_budget() calculation for posting to budget failed. No posting to budget. RETURN');
2515: END IF;

Line 2727: fnd_msg_pub.count_and_get (

2723: END IF;
2724:
2725: x_return_status := fnd_api.g_ret_sts_success;
2726:
2727: fnd_msg_pub.count_and_get (
2728: p_count=> x_msg_count,
2729: p_data=> x_msg_data,
2730: p_encoded=> fnd_api.g_false
2731: );

Line 2738: fnd_msg_pub.count_and_get (

2734: --nepanda : Added exception block for normal errors and unexpected errors, before checking for OTHERS
2735: WHEN fnd_api.g_exc_error THEN
2736: x_return_status := fnd_api.g_ret_sts_error;
2737: ozf_utility_pvt.write_conc_log (' /**************EXCEPTION in ozf_accrual_engine.post_accrual_to_budget');
2738: fnd_msg_pub.count_and_get (
2739: p_count=> x_msg_count,
2740: p_data=> x_msg_data,
2741: p_encoded=> fnd_api.g_false
2742: );

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

2741: p_encoded=> fnd_api.g_false
2742: );
2743: WHEN fnd_api.g_exc_unexpected_error THEN
2744: x_return_status := fnd_api.g_ret_sts_unexp_error;
2745: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2746: fnd_msg_pub.add_exc_msg ('ozf_accrual_engine', 'post_accrual_to_budget');
2747: END IF;
2748: ozf_utility_pvt.write_conc_log (' /**************UNEXPECTED EXCEPTION in ozf_accrual_engine.post_accrual_to_budget');
2749: fnd_msg_pub.count_and_get (

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

2742: );
2743: WHEN fnd_api.g_exc_unexpected_error THEN
2744: x_return_status := fnd_api.g_ret_sts_unexp_error;
2745: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2746: fnd_msg_pub.add_exc_msg ('ozf_accrual_engine', 'post_accrual_to_budget');
2747: END IF;
2748: ozf_utility_pvt.write_conc_log (' /**************UNEXPECTED EXCEPTION in ozf_accrual_engine.post_accrual_to_budget');
2749: fnd_msg_pub.count_and_get (
2750: p_count=> x_msg_count,

Line 2749: fnd_msg_pub.count_and_get (

2745: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2746: fnd_msg_pub.add_exc_msg ('ozf_accrual_engine', 'post_accrual_to_budget');
2747: END IF;
2748: ozf_utility_pvt.write_conc_log (' /**************UNEXPECTED EXCEPTION in ozf_accrual_engine.post_accrual_to_budget');
2749: fnd_msg_pub.count_and_get (
2750: p_count=> x_msg_count,
2751: p_data=> x_msg_data,
2752: p_encoded=> fnd_api.g_false
2753: );

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

2752: p_encoded=> fnd_api.g_false
2753: );
2754: WHEN OTHERS THEN
2755: x_return_status := fnd_api.g_ret_sts_unexp_error;
2756: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2757: fnd_msg_pub.add_exc_msg ('ozf_accrual_engine', 'post_accrual_to_budget');
2758: END IF;
2759: ozf_utility_pvt.write_conc_log (' /**************UNEXPECTED EXCEPTION in ozf_accrual_engine.post_accrual_to_budget');
2760: fnd_msg_pub.count_and_get (

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

2753: );
2754: WHEN OTHERS THEN
2755: x_return_status := fnd_api.g_ret_sts_unexp_error;
2756: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2757: fnd_msg_pub.add_exc_msg ('ozf_accrual_engine', 'post_accrual_to_budget');
2758: END IF;
2759: ozf_utility_pvt.write_conc_log (' /**************UNEXPECTED EXCEPTION in ozf_accrual_engine.post_accrual_to_budget');
2760: fnd_msg_pub.count_and_get (
2761: p_count=> x_msg_count,

Line 2760: fnd_msg_pub.count_and_get (

2756: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2757: fnd_msg_pub.add_exc_msg ('ozf_accrual_engine', 'post_accrual_to_budget');
2758: END IF;
2759: ozf_utility_pvt.write_conc_log (' /**************UNEXPECTED EXCEPTION in ozf_accrual_engine.post_accrual_to_budget');
2760: fnd_msg_pub.count_and_get (
2761: p_count=> x_msg_count,
2762: p_data=> x_msg_data,
2763: p_encoded=> fnd_api.g_false
2764: );

Line 2975: fnd_msg_pub.initialize;

2971: RAISE fnd_api.g_exc_unexpected_error;
2972: END IF;
2973: -- Initialize message list IF p_init_msg_list is set to TRUE.
2974: IF fnd_api.to_boolean (p_init_msg_list) THEN
2975: fnd_msg_pub.initialize;
2976: END IF;
2977: -- Initialize API return status to success
2978: x_return_status := fnd_api.g_ret_sts_success;
2979:

Line 3142: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_low) THEN

3138: END IF;
3139: -- Catch Weight ER - end
3140:
3141: IF (l_cost_price = -1) THEN
3142: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_low) THEN
3143: fnd_message.set_name('OZF', 'OZF_COST_PRICE_NOT_FOUND');
3144: FND_MESSAGE.Set_Token('OFFR',l_offer_name); --OR LIST_HEADER_ID?
3145: FND_MESSAGE.Set_Token('ORDER',p_line_adj_tbl(i).header_id);
3146: FND_MESSAGE.Set_Token('ITEM',l_product_id);

Line 3148: fnd_msg_pub.add;

3144: FND_MESSAGE.Set_Token('OFFR',l_offer_name); --OR LIST_HEADER_ID?
3145: FND_MESSAGE.Set_Token('ORDER',p_line_adj_tbl(i).header_id);
3146: FND_MESSAGE.Set_Token('ITEM',l_product_id);
3147: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
3148: fnd_msg_pub.add;
3149: END IF;
3150: GOTO l_endoflineadjloop;
3151: END IF;
3152:

Line 3341: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_low) THEN

3337: ozf_utility_pvt.write_conc_log(' l_cost_price' || l_cost_price );
3338: END IF;
3339:
3340: IF (l_cost_price = -1) THEN
3341: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_debug_low) THEN
3342: fnd_message.set_name('OZF', 'OZF_COST_PRICE_NOT_FOUND');
3343: FND_MESSAGE.Set_Token('OFFR',l_offer_name);
3344: FND_MESSAGE.Set_Token('ORDER',p_line_adj_tbl(i).header_id);
3345: FND_MESSAGE.Set_Token('ITEM',l_product_id);

Line 3347: fnd_msg_pub.add;

3343: FND_MESSAGE.Set_Token('OFFR',l_offer_name);
3344: FND_MESSAGE.Set_Token('ORDER',p_line_adj_tbl(i).header_id);
3345: FND_MESSAGE.Set_Token('ITEM',l_product_id);
3346: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
3347: fnd_msg_pub.add;
3348: END IF;
3349: GOTO l_endoflineadjloop;
3350: END IF;
3351:

Line 3673: fnd_msg_pub.count_and_get (

3669: IF g_debug_flag = 'Y' THEN
3670: ozf_utility_pvt.write_conc_log(' D: post_accrual_to_budget returns ' || l_return_status);
3671: END IF;
3672: x_return_status := l_return_status;
3673: fnd_msg_pub.count_and_get (
3674: p_count=> x_msg_count,
3675: p_data=> x_msg_data,
3676: p_encoded=> fnd_api.g_false
3677: );

Line 3683: fnd_msg_pub.count_and_get (

3679: EXCEPTION
3680: --nepanda : Added exception block for normal errors and unexpected errors, before checking for OTHERS
3681: WHEN fnd_api.g_exc_error THEN
3682: x_return_status := fnd_api.g_ret_sts_error;
3683: fnd_msg_pub.count_and_get (
3684: p_count=> x_msg_count,
3685: p_data=> x_msg_data,
3686: p_encoded=> fnd_api.g_false
3687: );

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

3687: );
3688: WHEN fnd_api.g_exc_unexpected_error THEN
3689: x_return_status := fnd_api.g_ret_sts_unexp_error;
3690:
3691: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3692: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3693: END IF;
3694: ozf_utility_pvt.write_conc_log(' /**************UNEXPECTED EXCEPTION in adjust_accrual *************/');
3695: fnd_msg_pub.count_and_get (

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

3688: WHEN fnd_api.g_exc_unexpected_error THEN
3689: x_return_status := fnd_api.g_ret_sts_unexp_error;
3690:
3691: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3692: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3693: END IF;
3694: ozf_utility_pvt.write_conc_log(' /**************UNEXPECTED EXCEPTION in adjust_accrual *************/');
3695: fnd_msg_pub.count_and_get (
3696: p_count=> x_msg_count,

Line 3695: fnd_msg_pub.count_and_get (

3691: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3692: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3693: END IF;
3694: ozf_utility_pvt.write_conc_log(' /**************UNEXPECTED EXCEPTION in adjust_accrual *************/');
3695: fnd_msg_pub.count_and_get (
3696: p_count=> x_msg_count,
3697: p_data=> x_msg_data,
3698: p_encoded=> fnd_api.g_false
3699: );

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

3700: WHEN OTHERS THEN
3701: x_return_status := fnd_api.g_ret_sts_unexp_error;
3702:
3703: ozf_utility_pvt.write_conc_log(' /**************UNEXPECTED EXCEPTION in adjust_accrual *************/');
3704: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3705: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3706: END IF;
3707:
3708: fnd_msg_pub.count_and_get (

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

3701: x_return_status := fnd_api.g_ret_sts_unexp_error;
3702:
3703: ozf_utility_pvt.write_conc_log(' /**************UNEXPECTED EXCEPTION in adjust_accrual *************/');
3704: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3705: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3706: END IF;
3707:
3708: fnd_msg_pub.count_and_get (
3709: p_count=> x_msg_count,

Line 3708: fnd_msg_pub.count_and_get (

3704: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3705: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3706: END IF;
3707:
3708: fnd_msg_pub.count_and_get (
3709: p_count=> x_msg_count,
3710: p_data=> x_msg_data,
3711: p_encoded=> fnd_api.g_false
3712: );

Line 4147: fnd_msg_pub.initialize;

4143: RAISE fnd_api.g_exc_unexpected_error;
4144: END IF;
4145: -- Initialize message list IF p_init_msg_list is set to TRUE.
4146: IF fnd_api.to_boolean (p_init_msg_list) THEN
4147: fnd_msg_pub.initialize;
4148: END IF;
4149: -- Initialize API return status to success
4150: x_return_status := fnd_api.g_ret_sts_success;
4151: <>

Line 4938: fnd_msg_pub.initialize;

4934:
4935: -- Dump All the MEssages from the Message list
4936: ozf_utility_pvt.write_conc_log;
4937: -- Initialize the Message list for NExt Processing
4938: fnd_msg_pub.initialize;
4939: ROLLBACK TO line_adjustment;
4940: -- return a status error
4941: x_return_status := fnd_api.g_ret_sts_error ;
4942: --5/30/2002 Added to exit the loop because we want to perform handle exception to put the me

Line 4960: fnd_msg_pub.count_and_get (

4956:
4957: END LOOP new_line_tbl_loop;
4958:
4959: -- Standard call to get message count and IF count is 1, get message info.
4960: fnd_msg_pub.count_and_get (
4961: p_count=> x_msg_count,
4962: p_data=> x_msg_data,
4963: p_encoded=> fnd_api.g_false
4964: );

Line 4970: fnd_msg_pub.count_and_get (

4966: --nepanda : Added exception block for normal errors and unexpected errors, before checking for OTHERS
4967: WHEN fnd_api.g_exc_error THEN
4968: x_return_status := fnd_api.g_ret_sts_error;
4969: ozf_utility_pvt.write_conc_log (' /**************EXCEPTION in ozf_accrual_engine.adjust_changed_order');
4970: fnd_msg_pub.count_and_get (
4971: p_count=> x_msg_count,
4972: p_data=> x_msg_data,
4973: p_encoded=> fnd_api.g_false
4974: );

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

4977:
4978: ozf_utility_pvt.write_conc_log (' /**************UNEXPECTED EXCEPTION in ozf_accrual_engine.adjust_changed_order');
4979: ozf_utility_pvt.write_conc_log(' D: adjust_changed_order: exception. errcode=' || sqlcode || ' msg: ' || substr(sqlerrm, 1, 3000));
4980:
4981: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4982: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4983: END IF;
4984:
4985: fnd_msg_pub.count_and_get (

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

4978: ozf_utility_pvt.write_conc_log (' /**************UNEXPECTED EXCEPTION in ozf_accrual_engine.adjust_changed_order');
4979: ozf_utility_pvt.write_conc_log(' D: adjust_changed_order: exception. errcode=' || sqlcode || ' msg: ' || substr(sqlerrm, 1, 3000));
4980:
4981: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4982: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4983: END IF;
4984:
4985: fnd_msg_pub.count_and_get (
4986: p_count=> x_msg_count,

Line 4985: fnd_msg_pub.count_and_get (

4981: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4982: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4983: END IF;
4984:
4985: fnd_msg_pub.count_and_get (
4986: p_count=> x_msg_count,
4987: p_data=> x_msg_data,
4988: p_encoded=> fnd_api.g_false
4989: );

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

4992:
4993: ozf_utility_pvt.write_conc_log (' /**************UNEXPECTED EXCEPTION in ozf_accrual_engine.adjust_changed_order');
4994: ozf_utility_pvt.write_conc_log(' D: adjust_changed_order: exception. errcode=' || sqlcode || ' msg: ' || substr(sqlerrm, 1, 3000));
4995:
4996: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4997: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4998: END IF;
4999:
5000: fnd_msg_pub.count_and_get (

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

4993: ozf_utility_pvt.write_conc_log (' /**************UNEXPECTED EXCEPTION in ozf_accrual_engine.adjust_changed_order');
4994: ozf_utility_pvt.write_conc_log(' D: adjust_changed_order: exception. errcode=' || sqlcode || ' msg: ' || substr(sqlerrm, 1, 3000));
4995:
4996: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4997: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4998: END IF;
4999:
5000: fnd_msg_pub.count_and_get (
5001: p_count=> x_msg_count,

Line 5000: fnd_msg_pub.count_and_get (

4996: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4997: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4998: END IF;
4999:
5000: fnd_msg_pub.count_and_get (
5001: p_count=> x_msg_count,
5002: p_data=> x_msg_data,
5003: p_encoded=> fnd_api.g_false
5004: );

Line 5077: fnd_msg_pub.initialize;

5073: l_que_msg_count NUMBER := 0 ;
5074: BEGIN
5075: -- Standard Start of process savepoint
5076: -- Start looping to check for messages in the queue
5077: fnd_msg_pub.initialize;
5078: g_debug_flag := p_debug ;
5079:
5080: SAVEPOINT get_message_savepoint;
5081:

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

5132: --if not sucess add a error message to th emessage listx
5133: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
5134: ozf_utility_pvt.write_conc_log ('Queue Return Error ');
5135:
5136: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
5137: fnd_message.set_name ('OZF', 'OZF_FUND_ASO_ORD_FEEDBACK_FAIL');
5138: fnd_msg_pub.ADD;
5139: END IF;
5140: ozf_utility_pvt.write_conc_log;

Line 5138: fnd_msg_pub.ADD;

5134: ozf_utility_pvt.write_conc_log ('Queue Return Error ');
5135:
5136: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
5137: fnd_message.set_name ('OZF', 'OZF_FUND_ASO_ORD_FEEDBACK_FAIL');
5138: fnd_msg_pub.ADD;
5139: END IF;
5140: ozf_utility_pvt.write_conc_log;
5141: RETURN;
5142: END IF;

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

5273:
5274: WHEN OTHERS THEN
5275: ROLLBACK TO get_message_loop_savepoint;
5276: ozf_utility_pvt.write_conc_log('FAILED');
5277: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5278: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
5279: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
5280: FND_MSG_PUB.Add;
5281: END IF;

Line 5280: FND_MSG_PUB.Add;

5276: ozf_utility_pvt.write_conc_log('FAILED');
5277: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5278: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
5279: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
5280: FND_MSG_PUB.Add;
5281: END IF;
5282: ozf_utility_pvt.write_conc_log;
5283:
5284: END;

Line 5372: fnd_msg_pub.initialize;

5368:
5369: BEGIN
5370: -- Standard Start of process savepoint
5371: -- Start looping to check for messages in the queue
5372: fnd_msg_pub.initialize;
5373: SAVEPOINT get_message_savepoint;
5374: -- dequeue the exception queue
5375: <>
5376: LOOP

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

5423: --ozf_utility_pvt.debug_message('l_return_status ='||l_return_status );
5424: --///added by mpande to write a error message to the list
5425: --if not sucess add a error message to th emessage list
5426: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
5427: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
5428: fnd_message.set_name ('OZF', 'OZF_FUND_ASO_ORD_FEEDBACK_FAIL');
5429: fnd_msg_pub.ADD;
5430: END IF;
5431: ozf_utility_pvt.write_conc_log;

Line 5429: fnd_msg_pub.ADD;

5425: --if not sucess add a error message to th emessage list
5426: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
5427: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
5428: fnd_message.set_name ('OZF', 'OZF_FUND_ASO_ORD_FEEDBACK_FAIL');
5429: fnd_msg_pub.ADD;
5430: END IF;
5431: ozf_utility_pvt.write_conc_log;
5432: RETURN;
5433: END IF;

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

5533: );
5534:
5535: --added for bug 8435487
5536: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
5537: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
5538: fnd_message.set_name ('OZF', 'OZF_FUND_ASO_ORD_FEEDBACK_FAIL');
5539: fnd_msg_pub.ADD;
5540: END IF;
5541: ozf_utility_pvt.write_conc_log('again exception happened');

Line 5539: fnd_msg_pub.ADD;

5535: --added for bug 8435487
5536: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
5537: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
5538: fnd_message.set_name ('OZF', 'OZF_FUND_ASO_ORD_FEEDBACK_FAIL');
5539: fnd_msg_pub.ADD;
5540: END IF;
5541: ozf_utility_pvt.write_conc_log('again exception happened');
5542: RETURN;
5543: ELSE

Line 5550: FND_MSG_PUB.INITIALIZE;

5546: x_retcode := 0;
5547: END IF;
5548: ELSE
5549: ozf_utility_pvt.write_conc_log;
5550: FND_MSG_PUB.INITIALIZE;
5551: END IF;
5552: EXCEPTION
5553: WHEN FND_API.G_EXC_ERROR THEN
5554: ROLLBACK TO get_excep_loop_savepoint;

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

5562:
5563: WHEN OTHERS THEN
5564: ROLLBACK TO get_excep_loop_savepoint;
5565: ozf_utility_pvt.write_conc_log('FAILED');
5566: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5567: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
5568: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
5569: FND_MSG_PUB.Add;
5570: END IF;

Line 5569: FND_MSG_PUB.Add;

5565: ozf_utility_pvt.write_conc_log('FAILED');
5566: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5567: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
5568: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
5569: FND_MSG_PUB.Add;
5570: END IF;
5571: ozf_utility_pvt.write_conc_log;
5572: END;
5573: END LOOP exception_loop;

Line 5975: fnd_msg_pub.count_and_get (

5971: ELSE
5972: -- do not raise exception for gl posting error. Just mark it as failed and deal with it later
5973: l_gl_posted_flag := G_GL_FLAG_FAIL; -- 'F';
5974: -- 07/17/2003 yzhao: log error message
5975: fnd_msg_pub.count_and_get (
5976: p_count => x_msg_count,
5977: p_data => x_msg_data,
5978: p_encoded => fnd_api.g_false
5979: );

Line 5983: fnd_msg_pub.initialize;

5979: );
5980: ozf_utility_pvt.write_conc_log(' /****** Failed to post to GL ******/ for utilization id ' || p_util_utilization_id);
5981:
5982: ozf_utility_pvt.write_conc_log;
5983: fnd_msg_pub.initialize;
5984: END IF;
5985:
5986: END IF; --l_gl_posted_flag = G_GL_FLAG_NO
5987:

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

6000:
6001: IF l_gl_posted_flag IN(G_GL_FLAG_YES,G_GL_FLAG_NULL,G_GL_FLAG_NOLIAB) THEN
6002:
6003: IF g_universal_currency IS NULL THEN
6004: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
6005: fnd_message.set_name('OZF', 'OZF_UNIV_CURR_NOT_FOUND');
6006: fnd_msg_pub.add;
6007: END IF;
6008: RAISE fnd_api.g_exc_error;

Line 6006: fnd_msg_pub.add;

6002:
6003: IF g_universal_currency IS NULL THEN
6004: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
6005: fnd_message.set_name('OZF', 'OZF_UNIV_CURR_NOT_FOUND');
6006: fnd_msg_pub.add;
6007: END IF;
6008: RAISE fnd_api.g_exc_error;
6009: END IF;
6010:

Line 6167: fnd_msg_pub.count_and_get (

6163: WHEN OTHERS THEN
6164: ROLLBACK TO post_accrual_to_gl_sp;
6165: ozf_utility_pvt.write_conc_log(' D: post_accrual_to_gl(): exception ');
6166: x_return_status := fnd_api.g_ret_sts_unexp_error;
6167: fnd_msg_pub.count_and_get (
6168: p_count => x_msg_count,
6169: p_data => x_msg_data,
6170: p_encoded => fnd_api.g_false
6171: );

Line 6572: fnd_msg_pub.count_and_get (

6568: WHEN OTHERS THEN
6569: ROLLBACK TO post_offinvoice_to_gl_sp;
6570: x_retcode := 1;
6571: ozf_utility_pvt.write_conc_log(' D: post_offinvoice_to_gl(): exception ');
6572: fnd_msg_pub.count_and_get (
6573: p_count => l_msg_count,
6574: p_data => l_msg_data,
6575: p_encoded => fnd_api.g_false
6576: );

Line 6687: fnd_msg_pub.count_and_get (

6683: WHEN OTHERS THEN
6684: ROLLBACK TO post_related_accrual_to_gl_sp;
6685: ozf_utility_pvt.write_conc_log(' D: post_related_accrual_to_gl(): exception ');
6686: x_return_status := fnd_api.g_ret_sts_unexp_error;
6687: fnd_msg_pub.count_and_get (
6688: p_count => x_msg_count,
6689: p_data => x_msg_data,
6690: p_encoded => fnd_api.g_false
6691: );

Line 7062: fnd_msg_pub.count_and_get (

7058: EXCEPTION
7059: WHEN OTHERS THEN
7060: ROLLBACK TO recalculate_earnings_sp;
7061: ozf_utility_pvt.write_conc_log('recalculate_earnings(): exception ');
7062: fnd_msg_pub.count_and_get (
7063: p_count => l_msg_count,
7064: p_data => l_msg_data,
7065: p_encoded => fnd_api.g_false
7066: );