DBA Data[Home] [Help]

APPS.OZF_ACCRUAL_ENGINE dependencies on OZF_ACCRUAL_ENGINE

Line 1: PACKAGE BODY OZF_ACCRUAL_ENGINE AS

1: PACKAGE BODY OZF_ACCRUAL_ENGINE AS
2: /* $Header: ozfacreb.pls 120.86.12020000.10 2013/03/05 07:57:22 nepanda ship $ */
3: ----------------------------------------------------------------------------------
4: -- Package Name
5: -- ozf_accrual_engine

Line 5: -- ozf_accrual_engine

1: PACKAGE BODY OZF_ACCRUAL_ENGINE AS
2: /* $Header: ozfacreb.pls 120.86.12020000.10 2013/03/05 07:57:22 nepanda ship $ */
3: ----------------------------------------------------------------------------------
4: -- Package Name
5: -- ozf_accrual_engine
6: -- PROCEDURES
7: -- calculate_accrual_amount
8: -- adjust_accrual
9: -- Get_Message

Line 126: g_pkg_name CONSTANT VARCHAR2 (30) := 'OZF_ACCRUAL_ENGINE';

122: -- 01/16/2013 ninarasi Bug 16029659 - OFFER IN TRADE PLANNING CREATING IMPROPER ADJUSTMENTS
123: -- 1/29/2013 nepanda Bug 16235187 - ER - MULTI UOM FULFILLMENT WITH CATCH WEIGHT
124: -- 3/5/2013 nepanda Bug 16434010 - chrm - catch weight : fae failure
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');

Line 2484: ozf_accrual_engine.calculate_accrual_amount (

2480: OPEN c_cust_number(p_adj_amt_tbl(i).order_header_id);
2481: FETCH c_cust_number INTO l_cust_account_id, l_bill_to_site_use_id, l_ship_to_site_use_id;
2482: CLOSE c_cust_number;
2483:
2484: ozf_accrual_engine.calculate_accrual_amount (
2485: x_return_status => l_return_status,
2486: p_src_id => p_adj_amt_tbl(i).qp_list_header_id,
2487: p_earned_amt => p_adj_amt_tbl(i).earned_amount,
2488: p_cust_account_type => 'BILL_TO',

Line 2737: ozf_utility_pvt.write_conc_log (' /**************EXCEPTION in ozf_accrual_engine.post_accrual_to_budget');

2733: EXCEPTION
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

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 2748: ozf_utility_pvt.write_conc_log (' /**************UNEXPECTED EXCEPTION in ozf_accrual_engine.post_accrual_to_budget');

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,
2751: p_data=> x_msg_data,
2752: p_encoded=> fnd_api.g_false

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 2759: ozf_utility_pvt.write_conc_log (' /**************UNEXPECTED EXCEPTION in ozf_accrual_engine.post_accrual_to_budget');

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,
2762: p_data=> x_msg_data,
2763: p_encoded=> fnd_api.g_false

Line 4969: ozf_utility_pvt.write_conc_log (' /**************EXCEPTION in ozf_accrual_engine.adjust_changed_order');

4965: EXCEPTION
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

Line 4978: ozf_utility_pvt.write_conc_log (' /**************UNEXPECTED EXCEPTION in ozf_accrual_engine.adjust_changed_order');

4974: );
4975: WHEN fnd_api.g_exc_unexpected_error THEN
4976: x_return_status := fnd_api.g_ret_sts_unexp_error;
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);

Line 4993: ozf_utility_pvt.write_conc_log (' /**************UNEXPECTED EXCEPTION in ozf_accrual_engine.adjust_changed_order');

4989: );
4990: WHEN OTHERS THEN
4991: x_return_status := fnd_api.g_ret_sts_unexp_error;
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);

Line 7074: END ozf_accrual_engine;

7070: IF g_debug_flag = 'Y' THEN
7071: ozf_utility_pvt.write_conc_log (' D: recalculate_earnings() ENDs for utilization id ' || p_util_utilization_id);
7072: END IF;
7073: END recalculate_earnings;
7074: END ozf_accrual_engine;