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_ADJUSTMENT_PVT dependencies on OZF_UTILITY_PVT

Line 197: ozf_utility_pvt.debug_message (': begin ');

193: BEGIN
194: SAVEPOINT create_budget_amt_utilized;
195: x_return_status := fnd_api.g_ret_sts_success;
196: IF G_DEBUG THEN
197: ozf_utility_pvt.debug_message (': begin ');
198: END IF;
199:
200: IF fnd_api.to_boolean (p_init_msg_list) THEN
201: fnd_msg_pub.initialize;

Line 219: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_UTIL_OVER');

215: FETCH c_parent_source INTO l_parent_source_rec;
216:
217: -- change later if a error has to be raised or not.
218: IF c_parent_source%NOTFOUND THEN
219: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_UTIL_OVER');
220: END IF;
221:
222: EXIT WHEN c_parent_source%NOTFOUND;
223: */

Line 229: ozf_utility_pvt.convert_currency (

225: IF p_currency = p_cost_tbl (k).cost_curr THEN
226: l_amount := p_cost_tbl (k).cost_amount; -- inrequest currency
227: ELSE
228: -- call the currency conversion wrapper
229: ozf_utility_pvt.convert_currency (
230: x_return_status=> x_return_status
231: ,p_from_currency=> p_cost_tbl (k).cost_curr
232: ,p_to_currency=> p_currency
233: ,p_from_amount=> p_cost_tbl (k).cost_amount

Line 249: ozf_utility_pvt.convert_currency (

245: IF l_parent_source_rec.parent_currency = p_currency THEN
246: l_converted_amt := l_amount;
247: ELSE
248: -- call the currency conversion wrapper
249: ozf_utility_pvt.convert_currency (
250: x_return_status=> x_return_status
251: ,p_from_currency=> p_currency
252: ,p_to_currency=> l_parent_source_rec.parent_currency
253: ,p_from_amount=> l_amount

Line 270: ozf_utility_pvt.convert_currency (

266: l_amount_remaining := l_amount
267: - l_util_amount; -- in request currency
268: ELSIF NVL (l_parent_source_rec.total_amount, 0) < NVL (l_converted_amt, 0) THEN
269: -- call the currency conversion wrapper
270: ozf_utility_pvt.convert_currency (
271: x_return_status=> x_return_status
272: ,p_from_currency=> l_parent_source_rec.parent_currency
273: ,p_to_currency=> p_currency
274: ,p_from_amount=> l_parent_source_rec.total_amount

Line 288: ozf_utility_pvt.debug_message ( l_full_name

284: IF l_util_amount <> 0 THEN
285: -- don't need to convert if currencies are equal
286: l_act_budgets_rec.request_amount := l_util_amount;
287: IF G_DEBUG THEN
288: ozf_utility_pvt.debug_message ( l_full_name
289: || ': begin create act budgets ');
290: END IF;
291: l_act_budgets_rec.act_budget_used_by_id := p_budget_used_by_id;
292: l_act_budgets_rec.arc_act_budget_used_by := p_budget_used_by_type;

Line 303: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);

299: l_act_budgets_rec.transfer_type := 'UTILIZED';
300: --l_act_budgets_rec.approved_original_amount := l_parent_source_rec.total_amount;
301: --l_act_budgets_rec.approved_in_currency := l_parent_source_rec.total_amount;
302: l_act_budgets_rec.approval_date := SYSDATE;
303: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
304: l_act_budgets_rec.justification :=
305: TO_CHAR (p_cost_tbl (k).cost_id)
306: || p_cost_tbl (k).cost_desc;
307: -- l_act_budgets_rec.parent_source_id := l_parent_source_rec.parent_src_id;

Line 378: ozf_utility_pvt.debug_message ( l_full_name

374:
375: /*
376: EXIT WHEN l_amount_remaining = 0;
377: IF G_DEBUG THEN
378: ozf_utility_pvt.debug_message ( l_full_name
379: || ': end create act budgets ');
380: END IF;
381: l_activity_id := NULL;
382: l_act_budgets_rec := NULL;

Line 540: l_amount := ozf_utility_pvt.currround(l_parent_source_rec.total_acctd_amount / l_acctd_amount * l_total_amount, l_old_currency);

536:
537: IF l_acctd_amount = 0 THEN -- no committed amount but g_recal_flag is 'Y', then only create utilization for first budget.
538: l_amount := l_total_amount;
539: ELSE -- propotional distribute amount based on remaining amount.
540: l_amount := ozf_utility_pvt.currround(l_parent_source_rec.total_acctd_amount / l_acctd_amount * l_total_amount, l_old_currency);
541: END IF;
542:
543: l_amount_remaining :=l_amount_remaining - l_amount;
544:

Line 550: ozf_utility_pvt.convert_currency (

546: --on utilization org, since the converted amount is used to populate the
547: --amount column of utilization table.
548:
549: IF l_parent_source_rec.parent_curr <> l_old_currency THEN
550: ozf_utility_pvt.convert_currency (
551: x_return_status=> x_return_status
552: ,p_from_currency=> l_old_currency
553: ,p_to_currency=> l_parent_source_rec.parent_curr
554: ,p_conv_type=> p_exchange_rate_type --Added for bug 7030415

Line 790: ozf_utility_pvt.write_conc_log('create_fund_utilization p_act_util_rec.org_id '||p_act_util_rec.org_id);

786: END IF;
787:
788: --Added for bug 7030415
789: -- IF g_debug_flag = 'Y' THEN
790: ozf_utility_pvt.write_conc_log('create_fund_utilization p_act_util_rec.org_id '||p_act_util_rec.org_id);
791: -- END IF;
792:
793: OPEN c_get_conversion_type(p_act_util_rec.org_id);
794: FETCH c_get_conversion_type INTO l_exchange_rate_type;

Line 816: ozf_utility_pvt.write_conc_log('p_act_util_rec.org_id '||p_act_util_rec.org_id);

812: --Added for bug 7030415, In case of accrual budget.
813: --Need to use the org_id since the converted amount is used to populate
814: --the amount column of utilization table. p_act_util_rec.org_id
815:
816: ozf_utility_pvt.write_conc_log('p_act_util_rec.org_id '||p_act_util_rec.org_id);
817: ozf_utility_pvt.write_conc_log('l_exchange_rate_type '||l_exchange_rate_type);
818:
819: IF p_act_budget_rec.request_currency <>l_fund_currency THEN
820: --Added for bug 7425189

Line 817: ozf_utility_pvt.write_conc_log('l_exchange_rate_type '||l_exchange_rate_type);

813: --Need to use the org_id since the converted amount is used to populate
814: --the amount column of utilization table. p_act_util_rec.org_id
815:
816: ozf_utility_pvt.write_conc_log('p_act_util_rec.org_id '||p_act_util_rec.org_id);
817: ozf_utility_pvt.write_conc_log('l_exchange_rate_type '||l_exchange_rate_type);
818:
819: IF p_act_budget_rec.request_currency <>l_fund_currency THEN
820: --Added for bug 7425189
821: IF p_act_budget_rec.justification IN (l_fund_reconc_msg,l_act_bud_cst_msg)

Line 823: ozf_utility_pvt.convert_currency (

819: IF p_act_budget_rec.request_currency <>l_fund_currency THEN
820: --Added for bug 7425189
821: IF p_act_budget_rec.justification IN (l_fund_reconc_msg,l_act_bud_cst_msg)
822: AND p_act_budget_rec.exchange_rate_date IS NOT NULL THEN
823: ozf_utility_pvt.convert_currency (
824: x_return_status=> l_return_status,
825: p_from_currency=> p_act_budget_rec.request_currency,
826: p_to_currency=> l_fund_currency,
827: p_conv_date=> p_act_budget_rec.exchange_rate_date,

Line 833: ozf_utility_pvt.convert_currency (

829: x_to_amount=> l_util_amount,
830: x_rate=>l_rate
831: );
832: ELSE
833: ozf_utility_pvt.convert_currency (
834: x_return_status=> l_return_status,
835: p_from_currency=> p_act_budget_rec.request_currency,
836: p_to_currency=> l_fund_currency,
837: p_conv_type=> l_exchange_rate_type,

Line 854: ozf_utility_pvt.debug_message (':for accrual budget ' || l_util_amount );

850: l_parent_src_tbl (1).fund_amount := l_util_amount;
851: l_parent_src_tbl (1).plan_amount :=p_act_budget_rec.request_amount;
852:
853: IF G_DEBUG THEN
854: ozf_utility_pvt.debug_message (':for accrual budget ' || l_util_amount );
855: END IF;
856: -- for SALES budget, should same as customer accrual.
857: --08/18/2005 feliu fix for third party accrual.
858: /* ELSE

Line 872: ozf_utility_pvt.debug_message('here>>>>');

868:
869: ELSIF p_act_budget_rec.parent_source_id IS NULL
870: OR p_act_budget_rec.parent_source_id = fnd_api.g_miss_num THEN
871: --Added for bug 7030415 , For fixed budget
872: ozf_utility_pvt.debug_message('here>>>>');
873: get_parent_src (
874: p_budget_source_type=> p_act_budget_rec.budget_source_type
875: ,p_budget_source_id=> p_act_budget_rec.budget_source_id
876: ,p_amount=> p_act_budget_rec.approved_amount

Line 896: ozf_utility_pvt.debug_message('here>>>>>');

892: l_parent_src_tbl (1).plan_amount := p_act_budget_rec.request_amount;
893: END IF;
894:
895: ELSE
896: ozf_utility_pvt.debug_message('here>>>>>');
897: get_parent_src (
898: p_budget_source_type=> p_act_budget_rec.budget_source_type
899: ,p_budget_source_id=> p_act_budget_rec.budget_source_id
900: ,p_amount=> p_act_budget_rec.approved_amount

Line 916: ozf_utility_pvt.debug_message(l_full_name||' : '||'g_recal_flag: '||g_recal_flag);

912: END IF;
913: END IF;
914:
915: IF G_DEBUG THEN
916: ozf_utility_pvt.debug_message(l_full_name||' : '||'g_recal_flag: '||g_recal_flag);
917: END IF;
918:
919: FOR i IN NVL (l_parent_src_tbl.FIRST, 1) .. NVL (l_parent_src_tbl.LAST, 0)
920: LOOP

Line 931: ozf_utility_pvt.write_conc_log('NP amount in ozf_funds util tbl '||l_parent_src_tbl (i).fund_amount);

927: ELSE
928: l_util_rec.utilization_type := p_act_util_rec.utilization_type;
929: END IF;
930:
931: ozf_utility_pvt.write_conc_log('NP amount in ozf_funds util tbl '||l_parent_src_tbl (i).fund_amount);
932:
933: l_util_rec.fund_id := l_parent_src_tbl (i).fund_id;
934: l_util_rec.plan_type := p_act_budget_rec.budget_source_type;
935: l_util_rec.plan_id := p_act_budget_rec.budget_source_id;

Line 978: ozf_utility_pvt.debug_message('p_act_util_rec.site_use_id '||p_act_util_rec.site_use_id);

974: /* added by kdass for R12 */
975: l_util_rec.gl_account_credit := p_act_util_rec.gl_account_credit;
976: l_util_rec.gl_account_debit := p_act_util_rec.gl_account_debit;
977:
978: ozf_utility_pvt.debug_message('p_act_util_rec.site_use_id '||p_act_util_rec.site_use_id);
979: ozf_utility_pvt.debug_message('l_util_rec.site_use_id '|| l_util_rec.site_use_id);
980:
981: --fix for bug 6657242
982: l_util_rec.site_use_id := p_act_util_rec.site_use_id;

Line 979: ozf_utility_pvt.debug_message('l_util_rec.site_use_id '|| l_util_rec.site_use_id);

975: l_util_rec.gl_account_credit := p_act_util_rec.gl_account_credit;
976: l_util_rec.gl_account_debit := p_act_util_rec.gl_account_debit;
977:
978: ozf_utility_pvt.debug_message('p_act_util_rec.site_use_id '||p_act_util_rec.site_use_id);
979: ozf_utility_pvt.debug_message('l_util_rec.site_use_id '|| l_util_rec.site_use_id);
980:
981: --fix for bug 6657242
982: l_util_rec.site_use_id := p_act_util_rec.site_use_id;
983:

Line 1124: ozf_utility_pvt.debug_message (':for charge back: ' || l_parent_src_tbl (i).fund_amount );

1120: IF l_util_rec.object_type = 'TP_ORDER' THEN
1121: l_util_rec.utilization_type := 'ACCRUAL';
1122: l_util_rec.amount_remaining := l_parent_src_tbl (i).fund_amount;
1123: IF G_DEBUG THEN
1124: ozf_utility_pvt.debug_message (':for charge back: ' || l_parent_src_tbl (i).fund_amount );
1125: END IF;
1126: END IF;
1127:
1128: END IF;

Line 1136: ozf_utility_pvt.debug_message(l_full_name||' : '||'l_util_rec.amount_remaining: '|| l_util_rec.amount_remaining);

1132: -- 12/02/2003 yzhao: 11.5.10 chargeback
1133: IF l_util_rec.utilization_type IN ('ADJUSTMENT', 'CHARGEBACK') THEN
1134: l_util_rec.amount_remaining := l_util_rec.amount;
1135: IF G_DEBUG THEN
1136: ozf_utility_pvt.debug_message(l_full_name||' : '||'l_util_rec.amount_remaining: '|| l_util_rec.amount_remaining);
1137: END IF;
1138: END IF;
1139:
1140: -- check that cust_account_id is populated correctly

Line 1175: ozf_utility_pvt.error_message('OZF_NO_FUND_REQUEST');

1171: -- rimehrot, bug fix 4030022
1172: OPEN c_check_budget_request(l_util_rec.plan_id, l_util_rec.fund_id);
1173: FETCH c_check_budget_request INTO l_check_request;
1174: IF c_check_budget_request%ROWCOUNT = 0 THEN
1175: ozf_utility_pvt.error_message('OZF_NO_FUND_REQUEST');
1176: RAISE fnd_api.g_exc_unexpected_error;
1177: END IF;
1178: CLOSE c_check_budget_request;
1179: END IF;

Line 1209: ozf_utility_pvt.debug_message(l_full_name||' : '||'x_utilized_amount: '|| x_utilized_amount);

1205:
1206: x_utilized_amount := l_total_amount;
1207:
1208: IF G_DEBUG THEN
1209: ozf_utility_pvt.debug_message(l_full_name||' : '||'x_utilized_amount: '|| x_utilized_amount);
1210: END IF;
1211:
1212: fnd_msg_pub.count_and_get (
1213: p_encoded=> fnd_api.g_false

Line 1218: ozf_utility_pvt.debug_message ( l_full_name

1214: ,p_count=> x_msg_count
1215: ,p_data=> x_msg_data
1216: );
1217: IF G_DEBUG THEN
1218: ozf_utility_pvt.debug_message ( l_full_name
1219: || ': end');
1220: END IF;
1221:
1222: EXCEPTION

Line 1408: ozf_utility_pvt.error_message (p_message_name => 'OZF_OFFER_AMNT_GT_APPR_AMNT');

1404: CLOSE c_approved_amount;
1405:
1406: IF l_lumpsum_offer.lumpsum_amount > l_approved_amount
1407: OR l_lumpsum_offer.lumpsum_amount < l_approved_amount THEN
1408: ozf_utility_pvt.error_message (p_message_name => 'OZF_OFFER_AMNT_GT_APPR_AMNT');
1409: RAISE fnd_api.g_exc_error;
1410: END IF;
1411:
1412: IF l_lumpsum_offer.distribution_type = 'AMT' THEN

Line 1548: ozf_utility_pvt.debug_message(l_full_name||' : '||'begin' || ' p_act_budgets_rec.transfer_type: ' || p_act_budgets_rec.transfer_type);

1544:
1545: BEGIN
1546: x_return_status := fnd_api.g_ret_sts_success;
1547: IF G_DEBUG THEN
1548: ozf_utility_pvt.debug_message(l_full_name||' : '||'begin' || ' p_act_budgets_rec.transfer_type: ' || p_act_budgets_rec.transfer_type);
1549: END IF;
1550: --dbms_output.put_line(l_full_name||' : '||'begin');
1551:
1552: -- yzhao: 10/21/2003 for third party accrual price list, create an approved budget request when accrual happens

Line 1569: l_budget_request_rec.user_status_id := ozf_Utility_Pvt.get_default_user_status (

1565: l_budget_request_rec.request_currency := p_act_budgets_rec.request_currency; -- price list currency
1566: l_budget_request_rec.request_amount := p_act_budgets_rec.request_amount; -- in price list currency
1567:
1568: l_budget_request_rec.status_code := 'APPROVED';
1569: l_budget_request_rec.user_status_id := ozf_Utility_Pvt.get_default_user_status (
1570: 'OZF_BUDGETSOURCE_STATUS', p_act_budgets_rec.status_code);
1571: l_budget_request_rec.object_version_number := 1;
1572: l_budget_request_rec.approval_date := sysdate;
1573: --l_budget_request_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);

Line 1573: --l_budget_request_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);

1569: l_budget_request_rec.user_status_id := ozf_Utility_Pvt.get_default_user_status (
1570: 'OZF_BUDGETSOURCE_STATUS', p_act_budgets_rec.status_code);
1571: l_budget_request_rec.object_version_number := 1;
1572: l_budget_request_rec.approval_date := sysdate;
1573: --l_budget_request_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
1574: --l_budget_request_rec.requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
1575: l_budget_request_rec.approver_id := p_act_budgets_rec.approver_id;
1576: l_budget_request_rec.requester_id := p_act_budgets_rec.requester_id;
1577: IF l_budget_request_rec.approver_id IS NULL THEN

Line 1574: --l_budget_request_rec.requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);

1570: 'OZF_BUDGETSOURCE_STATUS', p_act_budgets_rec.status_code);
1571: l_budget_request_rec.object_version_number := 1;
1572: l_budget_request_rec.approval_date := sysdate;
1573: --l_budget_request_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
1574: --l_budget_request_rec.requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
1575: l_budget_request_rec.approver_id := p_act_budgets_rec.approver_id;
1576: l_budget_request_rec.requester_id := p_act_budgets_rec.requester_id;
1577: IF l_budget_request_rec.approver_id IS NULL THEN
1578: l_budget_request_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);

Line 1578: l_budget_request_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);

1574: --l_budget_request_rec.requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
1575: l_budget_request_rec.approver_id := p_act_budgets_rec.approver_id;
1576: l_budget_request_rec.requester_id := p_act_budgets_rec.requester_id;
1577: IF l_budget_request_rec.approver_id IS NULL THEN
1578: l_budget_request_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
1579: END IF;
1580: IF l_budget_request_rec.requester_id IS NULL THEN
1581: l_budget_request_rec.requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
1582: END IF;

Line 1581: l_budget_request_rec.requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);

1577: IF l_budget_request_rec.approver_id IS NULL THEN
1578: l_budget_request_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
1579: END IF;
1580: IF l_budget_request_rec.requester_id IS NULL THEN
1581: l_budget_request_rec.requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
1582: END IF;
1583:
1584:
1585: ozf_actbudgets_pvt.create_Act_Budgets (

Line 1631: ozf_utility_pvt.debug_message(l_full_name||' : '||'x_utilized_amount: '|| x_utilized_amount);

1627: x_utilized_amount => x_utilized_amount -- yzhao: 06/21/2004 added for chargeback
1628: );
1629:
1630: IF G_DEBUG THEN
1631: ozf_utility_pvt.debug_message(l_full_name||' : '||'x_utilized_amount: '|| x_utilized_amount);
1632: END IF;
1633:
1634: IF G_DEBUG THEN
1635: ozf_utility_pvt.debug_message(l_full_name||' : '||'create act budget retrun status'||x_return_status);

Line 1635: ozf_utility_pvt.debug_message(l_full_name||' : '||'create act budget retrun status'||x_return_status);

1631: ozf_utility_pvt.debug_message(l_full_name||' : '||'x_utilized_amount: '|| x_utilized_amount);
1632: END IF;
1633:
1634: IF G_DEBUG THEN
1635: ozf_utility_pvt.debug_message(l_full_name||' : '||'create act budget retrun status'||x_return_status);
1636: END IF;
1637: --dbms_output.put_line(l_full_name||' : '||'create act budget retrun status'||l_return_status);
1638:
1639: IF x_return_status = fnd_api.g_ret_sts_error THEN

Line 1675: ozf_utility_pvt.debug_message(l_full_name||' : '||'update act budget retrun status'||x_return_status);

1671: x_utilized_amount => x_utilized_amount -- yzhao: 06/21/2004 added for chargeback
1672: );
1673:
1674: IF G_DEBUG THEN
1675: ozf_utility_pvt.debug_message(l_full_name||' : '||'update act budget retrun status'||x_return_status);
1676: END IF;
1677: --dbms_output.put_line(l_full_name||' : '||'update act budget retrun status'||l_return_status);
1678:
1679: END IF;

Line 1943: ozf_utility_pvt.debug_message ( l_full_name || ': start');

1939:
1940: BEGIN
1941: SAVEPOINT post_scan_data_amount;
1942: IF G_DEBUG THEN
1943: ozf_utility_pvt.debug_message ( l_full_name || ': start');
1944: END IF;
1945: x_return_status := fnd_api.g_ret_sts_success;
1946:
1947: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 2004: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_UTIL_OVER');

2000: FOR l_prod_budget_rec IN c_prod_budgets (p_offer_id)
2001: LOOP
2002: -- change later if a error has to be raised or not.
2003: /* IF c_prod_budgets%NOTFOUND THEN
2004: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_UTIL_OVER');
2005: END IF;
2006: */
2007: EXIT WHEN c_prod_budgets%NOTFOUND;
2008: --get request amount proportionaly for total committed amount.

Line 2016: ozf_utility_pvt.debug_message ( 'scan unit: ' || l_unit);

2012: --l_amount := l_unit * l_scan_value; -- in object currency.
2013: l_amount := l_unit * l_scan_value / l_quantity; -- in object currency.
2014:
2015: IF G_DEBUG THEN
2016: ozf_utility_pvt.debug_message ( 'scan unit: ' || l_unit);
2017:
2018: ozf_utility_pvt.debug_message ( 'scan amount : ' || l_amount);
2019: END IF;
2020:

Line 2018: ozf_utility_pvt.debug_message ( 'scan amount : ' || l_amount);

2014:
2015: IF G_DEBUG THEN
2016: ozf_utility_pvt.debug_message ( 'scan unit: ' || l_unit);
2017:
2018: ozf_utility_pvt.debug_message ( 'scan amount : ' || l_amount);
2019: END IF;
2020:
2021: IF l_amount <> 0 THEN
2022: -- convert the object currency amount into fund currency

Line 2033: ozf_utility_pvt.convert_currency (

2029: OPEN c_get_conversion_type(l_offer_org_id);
2030: FETCH c_get_conversion_type INTO l_exchange_rate_type;
2031: CLOSE c_get_conversion_type;
2032:
2033: ozf_utility_pvt.convert_currency (
2034: x_return_status=> x_return_status
2035: ,p_from_currency=> l_currency_code
2036: ,p_conv_type=> l_exchange_rate_type
2037: ,p_to_currency=> l_prod_budget_rec.currency_code

Line 2057: l_act_budgets_rec.user_status_id := ozf_utility_pvt.get_default_user_status (

2053: l_act_budgets_rec.budget_source_id := p_offer_id;
2054: l_act_budgets_rec.request_currency := l_currency_code;
2055: l_act_budgets_rec.request_date := SYSDATE;
2056: l_act_budgets_rec.status_code := 'APPROVED';
2057: l_act_budgets_rec.user_status_id := ozf_utility_pvt.get_default_user_status (
2058: 'OZF_BUDGETSOURCE_STATUS'
2059: ,l_act_budgets_rec.status_code
2060: );
2061: l_act_budgets_rec.transfer_type := 'UTILIZED';

Line 2066: ozf_utility_pvt.get_resource_id (fnd_global.user_id);

2062: l_act_budgets_rec.approval_date := SYSDATE;
2063: l_act_budgets_rec.requester_id := l_offer_owner;
2064:
2065: l_act_budgets_rec.approver_id :=
2066: ozf_utility_pvt.get_resource_id (fnd_global.user_id);
2067: -- when workflow goes through without approval, fnd_global.user_id is not passed.
2068: IF l_act_budgets_rec.approver_id = -1 THEN
2069: l_act_budgets_rec.approver_id := l_offer_owner;
2070: END IF;

Line 2120: ozf_utility_pvt.debug_message ( l_full_name

2116: END IF;
2117: END IF; -- for amount
2118:
2119: IF G_DEBUG THEN
2120: ozf_utility_pvt.debug_message ( l_full_name
2121: || ': end create act budgets ');
2122: END IF;
2123: l_act_budgets_rec := NULL;
2124: l_act_util_rec := NULL;

Line 2145: ozf_utility_pvt.debug_message ( l_full_name || ': end');

2141: ,p_count=> x_msg_count
2142: ,p_data=> x_msg_data
2143: );
2144: IF G_DEBUG THEN
2145: ozf_utility_pvt.debug_message ( l_full_name || ': end');
2146: END IF;
2147:
2148: EXCEPTION
2149: WHEN fnd_api.g_exc_error THEN

Line 2394: ozf_utility_pvt.debug_message ( l_full_name || ': start');

2390:
2391: BEGIN
2392: SAVEPOINT Posting_lumpsum_amount;
2393: IF G_DEBUG THEN
2394: ozf_utility_pvt.debug_message ( l_full_name || ': start');
2395: END IF;
2396: x_return_status := fnd_api.g_ret_sts_success;
2397:
2398: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 2492: ozf_utility_pvt.debug_message ( 'posting amount ' || l_amount || ' for product: ' || l_itemId_tbl(i));

2488: END IF;
2489: END IF;
2490:
2491: IF G_DEBUG THEN
2492: ozf_utility_pvt.debug_message ( 'posting amount ' || l_amount || ' for product: ' || l_itemId_tbl(i));
2493: END IF;
2494:
2495: -- get total utilized amount .
2496: OPEN c_utilized_budgets(p_offer_id,l_itemId_tbl(i),l_prod_budget_rec.fund_id);

Line 2501: --l_utilized_amt := ozf_utility_pvt.currround((l_prod_budget_rec.approved_amount / l_total_committed_amt) * l_amount,l_prod_budget_rec.currency_code) - NVL(l_prod_utilized_amt,0);

2497: FETCH c_utilized_budgets INTO l_prod_utilized_amt;
2498: CLOSE c_utilized_budgets;
2499:
2500: IF l_spread_flag = 'Y' THEN
2501: --l_utilized_amt := ozf_utility_pvt.currround((l_prod_budget_rec.approved_amount / l_total_committed_amt) * l_amount,l_prod_budget_rec.currency_code) - NVL(l_prod_utilized_amt,0);
2502: l_utilized_amt := (l_prod_budget_rec.approved_amount / l_total_committed_amt) * l_amount - NVL(l_prod_utilized_amt,0);
2503: ELSE
2504: --l_utilized_amt := ozf_utility_pvt.currround((l_prod_budget_rec.approved_amount / l_total_committed_amt) * l_amount,l_prod_budget_rec.currency_code);
2505: l_utilized_amt := (l_prod_budget_rec.approved_amount / l_total_committed_amt) * l_amount;

Line 2504: --l_utilized_amt := ozf_utility_pvt.currround((l_prod_budget_rec.approved_amount / l_total_committed_amt) * l_amount,l_prod_budget_rec.currency_code);

2500: IF l_spread_flag = 'Y' THEN
2501: --l_utilized_amt := ozf_utility_pvt.currround((l_prod_budget_rec.approved_amount / l_total_committed_amt) * l_amount,l_prod_budget_rec.currency_code) - NVL(l_prod_utilized_amt,0);
2502: l_utilized_amt := (l_prod_budget_rec.approved_amount / l_total_committed_amt) * l_amount - NVL(l_prod_utilized_amt,0);
2503: ELSE
2504: --l_utilized_amt := ozf_utility_pvt.currround((l_prod_budget_rec.approved_amount / l_total_committed_amt) * l_amount,l_prod_budget_rec.currency_code);
2505: l_utilized_amt := (l_prod_budget_rec.approved_amount / l_total_committed_amt) * l_amount;
2506: END IF;
2507:
2508: IF l_count = l_itemId_tbl.COUNT THEN

Line 2522: ozf_utility_pvt.debug_message ( ': lumpsum posting amount ' || l_utilized_amt);

2518:
2519: l_amount_remaining := l_amount_remaining - l_utilized_amt;
2520:
2521: IF G_DEBUG THEN
2522: ozf_utility_pvt.debug_message ( ': lumpsum posting amount ' || l_utilized_amt);
2523: END IF;
2524:
2525: -- convert the object currency amount in to fund currency
2526: IF l_prod_budget_rec.currency_code = l_currency_code THEN

Line 2535: ozf_utility_pvt.convert_currency (

2531: OPEN c_get_conversion_type(l_offer_org_id);
2532: FETCH c_get_conversion_type INTO l_exchange_rate_type;
2533: CLOSE c_get_conversion_type;
2534: -- call the currency conversion wrapper
2535: ozf_utility_pvt.convert_currency (
2536: x_return_status=> x_return_status
2537: ,p_from_currency=> l_currency_code
2538: ,p_to_currency=> l_prod_budget_rec.currency_code
2539: ,p_conv_type=> l_exchange_rate_type

Line 2560: l_act_budgets_rec.user_status_id := ozf_utility_pvt.get_default_user_status (

2556: l_act_budgets_rec.budget_source_id := p_offer_id;
2557: l_act_budgets_rec.request_currency := l_currency_code;
2558: l_act_budgets_rec.request_date := SYSDATE;
2559: l_act_budgets_rec.status_code := 'APPROVED';
2560: l_act_budgets_rec.user_status_id := ozf_utility_pvt.get_default_user_status (
2561: 'OZF_BUDGETSOURCE_STATUS'
2562: ,l_act_budgets_rec.status_code
2563: );
2564: l_act_budgets_rec.transfer_type := 'UTILIZED';

Line 2568: ozf_utility_pvt.get_resource_id (fnd_global.user_id);

2564: l_act_budgets_rec.transfer_type := 'UTILIZED';
2565: l_act_budgets_rec.approval_date := SYSDATE;
2566: l_act_budgets_rec.requester_id := l_offer_owner;
2567: l_act_budgets_rec.approver_id :=
2568: ozf_utility_pvt.get_resource_id (fnd_global.user_id);
2569: -- when workflow goes through without approval, fnd_global.user_id is not passed.
2570: IF l_act_budgets_rec.approver_id = -1 THEN
2571: l_act_budgets_rec.approver_id := l_offer_owner;
2572: END IF;

Line 2593: ozf_utility_pvt.debug_message ( l_full_name

2589: p_act_util_rec =>l_act_util_rec,
2590: x_act_budget_id => l_act_budget_id
2591: ) ;
2592: IF G_DEBUG THEN
2593: ozf_utility_pvt.debug_message ( l_full_name
2594: || ': end create act budgets ');
2595: END IF;
2596:
2597: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 2620: ozf_utility_pvt.debug_message ( l_full_name || ': end');

2616: ,p_count=> x_msg_count
2617: ,p_data=> x_msg_data
2618: );
2619: IF G_DEBUG THEN
2620: ozf_utility_pvt.debug_message ( l_full_name || ': end');
2621: END IF;
2622: EXCEPTION
2623: WHEN fnd_api.g_exc_error THEN
2624: ROLLBACK TO Posting_lumpsum_amount;

Line 2705: ozf_utility_pvt.debug_message (': begin ' || l_full_name);

2701:
2702: BEGIN
2703: SAVEPOINT post_utilized_budget;
2704: IF G_DEBUG THEN
2705: ozf_utility_pvt.debug_message (': begin ' || l_full_name);
2706: END IF;
2707: x_return_status := fnd_api.g_ret_sts_success;
2708:
2709: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 2774: ozf_utility_pvt.debug_message ( l_full_name || ': end');

2770: ,p_data=> x_msg_data
2771: );
2772:
2773: IF G_DEBUG THEN
2774: ozf_utility_pvt.debug_message ( l_full_name || ': end');
2775: END IF;
2776: EXCEPTION
2777: WHEN fnd_api.g_exc_error THEN
2778: ROLLBACK TO post_utilized_budget;

Line 2972: ozf_utility_pvt.debug_message ( l_full_name || ': start');

2968: */
2969: BEGIN
2970: SAVEPOINT adjust_utilized_budget;
2971: IF G_DEBUG THEN
2972: ozf_utility_pvt.debug_message ( l_full_name || ': start');
2973: END IF;
2974: x_return_status := fnd_api.g_ret_sts_success;
2975:
2976: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 2997: ozf_utility_pvt.debug_message ( l_full_name || 'l_amount: ' || l_amount);

2993:
2994: l_amount := p_amount * l_scan_value; -- in object currency.
2995:
2996: IF G_DEBUG THEN
2997: ozf_utility_pvt.debug_message ( l_full_name || 'l_amount: ' || l_amount);
2998: END IF;
2999: -- get committed remaining. Ribha: changed as performance fix.
3000: OPEN c_budget_committed(p_offer_id);
3001: FETCH c_budget_committed INTO l_committed_remaining;

Line 3003: -- l_committed_remaining := nvl(ozf_utility_pvt.get_commited_amount(p_offer_id),0) - nvl(ozf_utility_pvt.get_utilized_amount(p_offer_id),0);

2999: -- get committed remaining. Ribha: changed as performance fix.
3000: OPEN c_budget_committed(p_offer_id);
3001: FETCH c_budget_committed INTO l_committed_remaining;
3002: CLOSE c_budget_committed;
3003: -- l_committed_remaining := nvl(ozf_utility_pvt.get_commited_amount(p_offer_id),0) - nvl(ozf_utility_pvt.get_utilized_amount(p_offer_id),0);
3004:
3005: IF G_DEBUG THEN
3006: ozf_utility_pvt.debug_message (l_full_name ||'l_committed_remaining: ' || l_committed_remaining);
3007: END IF;

Line 3006: ozf_utility_pvt.debug_message (l_full_name ||'l_committed_remaining: ' || l_committed_remaining);

3002: CLOSE c_budget_committed;
3003: -- l_committed_remaining := nvl(ozf_utility_pvt.get_commited_amount(p_offer_id),0) - nvl(ozf_utility_pvt.get_utilized_amount(p_offer_id),0);
3004:
3005: IF G_DEBUG THEN
3006: ozf_utility_pvt.debug_message (l_full_name ||'l_committed_remaining: ' || l_committed_remaining);
3007: END IF;
3008:
3009: IF ROUND(l_committed_remaining/l_scan_value) < p_amount THEN -- committed remaining is not enough.
3010: IF l_source_from_parent ='Y' THEN -- offer is sourced from campaign.

Line 3018: ozf_utility_pvt.debug_message (l_full_name ||'create_act_budgets: ' || l_campaign_id);

3014: FETCH c_parent_camapign INTO l_campaign_id;
3015: CLOSE c_parent_camapign;
3016:
3017: IF G_DEBUG THEN
3018: ozf_utility_pvt.debug_message (l_full_name ||'create_act_budgets: ' || l_campaign_id);
3019: END IF;
3020:
3021: l_act_budgets_rec.budget_source_type := 'CAMP';
3022: l_act_budgets_rec.budget_source_id := l_campaign_id;

Line 3028: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_UTIL_OVER');

3024: --find first budget which has enough fund to source requirement.
3025: FOR l_budget_util_rec IN c_utilized_budget (p_product_activity_id) LOOP
3026: --change later if a error has to be raised or not.
3027: /* IF c_utilized_budget%NOTFOUND THEN
3028: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_UTIL_OVER');
3029: END IF;
3030: */
3031: EXIT WHEN c_utilized_budget%NOTFOUND;
3032:

Line 3043: ozf_utility_pvt.convert_currency (

3039: l_converted_amt := l_amount - l_committed_remaining;
3040: ELSE
3041:
3042: -- call the currency conversion wrapper
3043: ozf_utility_pvt.convert_currency (
3044: x_return_status=> x_return_status
3045: ,p_from_currency=> l_offer_currency_code
3046: ,p_to_currency=> l_budget_util_rec.currency_code
3047: ,p_from_amount=> l_amount - l_committed_remaining

Line 3066: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_MONEY');

3062: l_act_budgets_rec.budget_source_id := l_fund_id;
3063:
3064: --handle case for all budgets has not enough money.
3065: IF l_converted_amt > l_available_amt THEN
3066: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_MONEY');
3067: END IF;
3068:
3069: END IF; -- end of source from parent.
3070:

Line 3085: ozf_utility_pvt.get_default_user_status (

3081: l_act_budgets_rec.approved_in_currency := l_budget_currency_code;
3082: l_act_budgets_rec.status_code := 'APPROVED';
3083: l_act_budgets_rec.request_date := SYSDATE;
3084: l_act_budgets_rec.user_status_id :=
3085: ozf_utility_pvt.get_default_user_status (
3086: 'OZF_BUDGETSOURCE_STATUS'
3087: ,l_act_budgets_rec.status_code
3088: );
3089: l_act_budgets_rec.approval_date := SYSDATE;

Line 3090: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);

3086: 'OZF_BUDGETSOURCE_STATUS'
3087: ,l_act_budgets_rec.status_code
3088: );
3089: l_act_budgets_rec.approval_date := SYSDATE;
3090: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
3091: l_act_budgets_rec.requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
3092:
3093: ozf_actbudgets_pvt.create_act_budgets (
3094: p_api_version=> l_api_version

Line 3091: l_act_budgets_rec.requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);

3087: ,l_act_budgets_rec.status_code
3088: );
3089: l_act_budgets_rec.approval_date := SYSDATE;
3090: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
3091: l_act_budgets_rec.requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
3092:
3093: ozf_actbudgets_pvt.create_act_budgets (
3094: p_api_version=> l_api_version
3095: ,x_return_status=> l_return_status

Line 3128: ozf_utility_pvt.convert_currency (

3124: IF l_fund_rec.fund_currency = l_offer_currency_code THEN
3125: l_converted_amt := l_amount; -- in fund currency
3126: ELSE
3127: -- call the currency conversion wrapper
3128: ozf_utility_pvt.convert_currency (
3129: x_return_status=> x_return_status
3130: ,p_from_currency=> l_offer_currency_code
3131: ,p_to_currency=> l_fund_rec.fund_currency
3132: ,p_from_amount=> l_amount

Line 3150: ozf_utility_pvt.convert_currency (

3146: - l_util_amount; -- in request currency
3147: l_act_budgets_rec.parent_src_apprvd_amt := l_converted_amt;
3148: ELSIF NVL (l_fund_rec.committed_amt, 0) < NVL (l_converted_amt, 0) THEN
3149: -- call the currency conversion wrapper
3150: ozf_utility_pvt.convert_currency (
3151: x_return_status=> x_return_status
3152: ,p_from_currency=> l_fund_rec.fund_currency
3153: ,p_to_currency=> l_offer_currency_code
3154: ,p_from_amount=> l_fund_rec.committed_amt

Line 3172: l_act_budgets_rec.user_status_id := ozf_utility_pvt.get_default_user_status (

3168: l_act_budgets_rec.budget_source_id := p_offer_id;
3169: l_act_budgets_rec.request_currency := l_offer_currency_code;
3170: l_act_budgets_rec.request_date := SYSDATE;
3171: l_act_budgets_rec.status_code := 'APPROVED';
3172: l_act_budgets_rec.user_status_id := ozf_utility_pvt.get_default_user_status (
3173: 'OZF_BUDGETSOURCE_STATUS'
3174: ,l_act_budgets_rec.status_code
3175: );
3176: l_act_budgets_rec.transfer_type := 'UTILIZED';

Line 3178: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);

3174: ,l_act_budgets_rec.status_code
3175: );
3176: l_act_budgets_rec.transfer_type := 'UTILIZED';
3177: l_act_budgets_rec.approval_date := SYSDATE;
3178: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
3179: fnd_message.set_name ('OZF', 'OZF_ACT_BUDGET_INCR_UTIL');
3180: fnd_message.set_token ('CLAIM_ID', p_claim_id, FALSE);
3181: l_act_budgets_rec.justification := fnd_message.get;
3182: l_act_budgets_rec.parent_source_id := l_fund_rec.fund_id;

Line 3228: ozf_utility_pvt.debug_message ( l_full_name

3224: ,p_count=> x_msg_count
3225: ,p_data=> x_msg_data
3226: );
3227: IF G_DEBUG THEN
3228: ozf_utility_pvt.debug_message ( l_full_name
3229: || ': end');
3230: END IF;
3231: EXCEPTION
3232: WHEN fnd_api.g_exc_error THEN

Line 3300: ozf_utility_pvt.debug_message (': begin ' || l_full_name);

3296:
3297: BEGIN
3298: SAVEPOINT update_budget_source;
3299: IF G_DEBUG THEN
3300: ozf_utility_pvt.debug_message (': begin ' || l_full_name);
3301: END IF;
3302: x_return_status := fnd_api.g_ret_sts_success;
3303:
3304: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 3357: ozf_utility_pvt.debug_message ( l_full_name || ': end');

3353: ,p_data=> x_msg_data
3354: );
3355:
3356: IF G_DEBUG THEN
3357: ozf_utility_pvt.debug_message ( l_full_name || ': end');
3358: END IF;
3359: EXCEPTION
3360: WHEN fnd_api.g_exc_error THEN
3361: ROLLBACK TO update_budget_source;

Line 3527: ozf_utility_pvt.debug_message ( l_full_name || ': start');

3523:
3524: BEGIN
3525: SAVEPOINT Posting_lumpsum_amount;
3526: IF G_DEBUG THEN
3527: ozf_utility_pvt.debug_message ( l_full_name || ': start');
3528: END IF;
3529: x_return_status := fnd_api.g_ret_sts_success;
3530:
3531: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 3560: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_UTIL_OVER');

3556: FOR l_req_budgets IN c_req_budgets (l_offer_id)
3557: LOOP
3558: -- change later if a error has to be raised or not.
3559: /* IF c_req_budgets%NOTFOUND THEN
3560: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_UTIL_OVER');
3561: END IF;
3562: */
3563: EXIT WHEN c_req_budgets%NOTFOUND;
3564: l_utilized_amt := ozf_utility_pvt.currround((l_req_budgets.approved_amount / l_total_committed_amt) * l_amount ,l_currency_code);

Line 3564: l_utilized_amt := ozf_utility_pvt.currround((l_req_budgets.approved_amount / l_total_committed_amt) * l_amount ,l_currency_code);

3560: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_UTIL_OVER');
3561: END IF;
3562: */
3563: EXIT WHEN c_req_budgets%NOTFOUND;
3564: l_utilized_amt := ozf_utility_pvt.currround((l_req_budgets.approved_amount / l_total_committed_amt) * l_amount ,l_currency_code);
3565: --l_utilized_amt := ROUND((l_req_budgets.approved_amount / l_total_committed_amt) * l_amount,2);
3566:
3567: IF G_DEBUG THEN
3568: ozf_utility_pvt.debug_message ( ': lumpsum posting amount ' || l_utilized_amt);

Line 3568: ozf_utility_pvt.debug_message ( ': lumpsum posting amount ' || l_utilized_amt);

3564: l_utilized_amt := ozf_utility_pvt.currround((l_req_budgets.approved_amount / l_total_committed_amt) * l_amount ,l_currency_code);
3565: --l_utilized_amt := ROUND((l_req_budgets.approved_amount / l_total_committed_amt) * l_amount,2);
3566:
3567: IF G_DEBUG THEN
3568: ozf_utility_pvt.debug_message ( ': lumpsum posting amount ' || l_utilized_amt);
3569: END IF;
3570:
3571: -- convert the object currency amount in to fund currency
3572: IF l_req_budgets.currency_code = l_currency_code THEN

Line 3582: ozf_utility_pvt.convert_currency (

3578: OPEN c_get_conversion_type(l_offer_org_id);
3579: FETCH c_get_conversion_type INTO l_exchange_rate_type;
3580: CLOSE c_get_conversion_type;
3581:
3582: ozf_utility_pvt.convert_currency (
3583: x_return_status=> x_return_status
3584: ,p_from_currency=> l_currency_code
3585: ,p_to_currency=> l_req_budgets.currency_code
3586: ,p_conv_type=> l_exchange_rate_type

Line 3598: ozf_utility_pvt.debug_message ( ': l_converted_amt ' || l_converted_amt);

3594: RAISE fnd_api.g_exc_error;
3595: END IF;
3596: END IF;
3597: IF G_DEBUG THEN
3598: ozf_utility_pvt.debug_message ( ': l_converted_amt ' || l_converted_amt);
3599: END IF;
3600:
3601: IF l_converted_amt <> 0 THEN
3602: l_act_budgets_rec.request_amount := l_utilized_amt; --in object currency.

Line 3610: l_act_budgets_rec.user_status_id := ozf_utility_pvt.get_default_user_status (

3606: l_act_budgets_rec.budget_source_id := l_offer_id;
3607: l_act_budgets_rec.request_currency := l_currency_code;
3608: l_act_budgets_rec.request_date := SYSDATE;
3609: l_act_budgets_rec.status_code := 'APPROVED';
3610: l_act_budgets_rec.user_status_id := ozf_utility_pvt.get_default_user_status (
3611: 'OZF_BUDGETSOURCE_STATUS'
3612: ,l_act_budgets_rec.status_code
3613: );
3614: l_act_budgets_rec.transfer_type := 'UTILIZED';

Line 3617: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);

3613: );
3614: l_act_budgets_rec.transfer_type := 'UTILIZED';
3615: l_act_budgets_rec.approval_date := SYSDATE;
3616: l_act_budgets_rec.requester_id := l_req_owner;
3617: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
3618: -- when workflow goes through without approval, fnd_global.user_id is not passed.
3619: IF l_act_budgets_rec.approver_id = -1 THEN
3620: l_act_budgets_rec.approver_id := l_req_owner;
3621: END IF;

Line 3638: ozf_utility_pvt.debug_message ( ': l_req_owner ' || l_act_budgets_rec.approver_id);

3634: l_org_id := find_org_id (l_act_budgets_rec.parent_source_id);
3635: -- set org_context since workflow mailer does not set the context
3636: set_org_ctx (l_org_id);
3637: IF G_DEBUG THEN
3638: ozf_utility_pvt.debug_message ( ': l_req_owner ' || l_act_budgets_rec.approver_id);
3639: END IF;
3640: process_act_budgets (x_return_status => l_return_status,
3641: x_msg_count => x_msg_count,
3642: x_msg_data => x_msg_data,

Line 3656: ozf_utility_pvt.debug_message ( l_full_name

3652: END IF;
3653: END IF; -- for util amount
3654:
3655: IF G_DEBUG THEN
3656: ozf_utility_pvt.debug_message ( l_full_name
3657: || ': end create act budgets ');
3658: END IF;
3659: l_act_util_rec := NULL;
3660: l_act_budgets_rec := NULL;

Line 3674: ozf_utility_pvt.debug_message ( l_full_name || ': end');

3670: ,p_count=> x_msg_count
3671: ,p_data=> x_msg_data
3672: );
3673: IF G_DEBUG THEN
3674: ozf_utility_pvt.debug_message ( l_full_name || ': end');
3675: END IF;
3676: EXCEPTION
3677: WHEN fnd_api.g_exc_error THEN
3678: ROLLBACK TO Posting_lumpsum_amount;