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

Line 182: ozf_utility_pvt.debug_message(' activity budget Id is :'||p_object_id );

178: l_parameter_list := WF_PARAMETER_LIST_T();
179:
180:
181: IF G_DEBUG THEN
182: ozf_utility_pvt.debug_message(' activity budget Id is :'||p_object_id );
183: END IF;
184:
185: wf_event.AddParameterToList(p_name => 'P_ACTBUDGET_ID',
186: p_value => p_object_id,

Line 190: ozf_utility_pvt.debug_message('Item Key is :'||l_item_key);

186: p_value => p_object_id,
187: p_parameterlist => l_parameter_list);
188:
189: IF G_DEBUG THEN
190: ozf_utility_pvt.debug_message('Item Key is :'||l_item_key);
191: END IF;
192:
193: wf_event.raise( p_event_name =>'oracle.apps.ozf.fund.request.approval',
194: p_event_key => l_item_key,

Line 201: ozf_utility_pvt.debug_message('Exception in raising business event');

197:
198: EXCEPTION
199: WHEN OTHERS THEN
200: RAISE Fnd_Api.g_exc_error;
201: ozf_utility_pvt.debug_message('Exception in raising business event');
202: END;
203:
204:
205: -- Start of Comments

Line 383: ozf_utility_pvt.debug_message ( l_full_name

379: l_is_quota NUMBER := NULL;
380:
381: BEGIN
382: IF G_DEBUG THEN
383: ozf_utility_pvt.debug_message ( l_full_name
384: || ': start');
385: END IF;
386: -- Standard Start of API savepoint
387: SAVEPOINT create_act_budgets_pvt;

Line 450: ozf_utility_pvt.convert_currency (

446: --Added for bug 7425189, pass exchange_rate_date = approval date of REQUEST
447: IF l_act_budgets_rec.justification IN (l_fund_reconc_msg,l_act_bud_cst_msg)
448: AND l_act_budgets_rec.exchange_rate_date IS NOT NULL
449: AND l_act_budgets_rec.transfer_type = 'TRANSFER' THEN
450: ozf_utility_pvt.convert_currency (
451: x_return_status=> l_return_status
452: ,p_from_currency=> l_act_budgets_rec.approved_in_currency
453: ,p_to_currency=> l_act_budgets_rec.request_currency
454: ,p_conv_date=> l_act_budgets_rec.exchange_rate_date

Line 459: ozf_utility_pvt.convert_currency (

455: ,p_from_amount=> l_act_budgets_rec.src_curr_req_amt
456: ,x_to_amount=> l_act_budgets_rec.request_amount
457: );
458: ELSE
459: ozf_utility_pvt.convert_currency (
460: x_return_status=> l_return_status
461: ,p_from_currency=> l_act_budgets_rec.approved_in_currency
462: ,p_to_currency=> l_act_budgets_rec.request_currency
463: ,p_from_amount=> l_act_budgets_rec.src_curr_req_amt

Line 479: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');

475: END IF;
476: /* End OF Change mpande 12/19/2001 */
477:
478: IF l_act_budgets_rec.request_currency IS NULL THEN
479: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');
480: x_return_status := fnd_api.g_ret_sts_error;
481: END IF;
482:
483: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 611: ozf_utility_pvt.get_default_user_status (l_status_type, l_act_budgets_rec.status_code);

607: END IF;
608: END IF; -- IF l_act_budgets_rec.status_code = 'APPROVED' THEN
609:
610: l_act_budgets_rec.user_status_id :=
611: ozf_utility_pvt.get_default_user_status (l_status_type, l_act_budgets_rec.status_code);
612:
613: IF l_return_status = fnd_api.g_ret_sts_error THEN
614: RAISE fnd_api.g_exc_error;
615: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 622: ozf_utility_pvt.debug_message ( l_full_name

618:
619:
620: ----------------------- validate -----------------------
621: IF G_DEBUG THEN
622: ozf_utility_pvt.debug_message ( l_full_name
623: || ': validate');
624: END IF;
625:
626: -- mpande added to populate request amount in request currency 12/17/2001 src_curr_request_amt

Line 659: ozf_utility_pvt.convert_currency(

655: IF l_act_budgets_rec.justification IN (l_fund_reconc_msg,l_act_bud_cst_msg)
656: AND l_act_budgets_rec.exchange_rate_date IS NOT NULL
657: AND l_act_budgets_rec.transfer_type = 'TRANSFER' THEN
658: IF l_act_budgets_rec.src_curr_req_amt IS NULL THEN
659: ozf_utility_pvt.convert_currency(
660: p_from_currency => l_act_budgets_rec.request_currency
661: ,p_to_currency => l_src_currency
662: ,p_conv_date => l_act_budgets_rec.exchange_rate_date
663: ,p_from_amount => l_act_budgets_rec.request_amount

Line 669: ozf_utility_pvt.convert_currency(

665: ,x_to_amount => l_act_budgets_rec.src_curr_req_amt
666: ,x_rate => l_rate);
667: END IF;
668: ELSE
669: ozf_utility_pvt.convert_currency(
670: p_from_currency => l_act_budgets_rec.request_currency
671: ,p_to_currency => l_src_currency
672: ,p_conv_type => l_exchange_rate_type
673: ,p_from_amount => l_act_budgets_rec.request_amount

Line 710: ozf_utility_pvt.debug_message ( l_api_name

706:
707: IF NVL(l_act_budgets_rec.approved_amount,0) <> 0 THEN
708: -- R12: yzhao Oct. 10, 2005 get ledger when calculating functional currency
709: IF G_DEBUG THEN
710: ozf_utility_pvt.debug_message ( l_api_name
711: || ': create_act_budgets before getting ledger util.org_id='
712: || l_act_util_rec.org_id);
713: END IF;
714:

Line 722: ozf_utility_pvt.debug_message ( l_api_name

718: p_ledger_id => l_ledger_id,
719: p_ledger_name => l_ledger_name
720: );
721: IF G_DEBUG THEN
722: ozf_utility_pvt.debug_message ( l_api_name
723: || ': create_act_budgets ledger for util.org_id('
724: || l_act_util_rec.org_id || ')=' || l_ledger_id);
725: END IF;
726: ELSE

Line 727: ozf_utility_pvt.get_object_org_ledger(p_object_type => l_act_budgets_rec.arc_act_budget_used_by

723: || ': create_act_budgets ledger for util.org_id('
724: || l_act_util_rec.org_id || ')=' || l_ledger_id);
725: END IF;
726: ELSE
727: ozf_utility_pvt.get_object_org_ledger(p_object_type => l_act_budgets_rec.arc_act_budget_used_by
728: , p_object_id => l_act_budgets_rec.act_budget_used_by_id
729: , x_org_id => l_act_util_rec.org_id
730: , x_ledger_id => l_ledger_id
731: , x_return_status => l_return_status

Line 734: ozf_utility_pvt.debug_message ( l_api_name

730: , x_ledger_id => l_ledger_id
731: , x_return_status => l_return_status
732: );
733: IF G_DEBUG THEN
734: ozf_utility_pvt.debug_message ( l_api_name
735: || ': create_act_budgets ledger for '
736: || l_act_budgets_rec.arc_act_budget_used_by
737: || ' id('
738: || l_act_budgets_rec.act_budget_used_by_id

Line 760: ozf_utility_pvt.debug_message ( l_api_name

756: IF l_ledger_id IS NULL THEN
757: IF l_act_budgets_rec.budget_source_type NOT IN ('CAMP', 'CSCH', 'EVEO', 'EVEH', 'EONE') AND
758: l_act_budgets_rec.arc_act_budget_used_by NOT IN ('CAMP', 'CSCH', 'EVEO', 'EVEH', 'EONE') THEN
759: IF G_DEBUG THEN
760: ozf_utility_pvt.debug_message ( l_api_name
761: || ': create_act_budgets ledger not found for '
762: || l_act_budgets_rec.arc_act_budget_used_by
763: || ' id('
764: || l_act_budgets_rec.act_budget_used_by_id);

Line 792: ozf_utility_pvt.calculate_functional_currency(

788: IF l_act_budgets_rec.justification IN (l_fund_reconc_msg,l_act_bud_cst_msg)
789: AND l_act_budgets_rec.exchange_rate_date IS NOT NULL
790: AND l_act_budgets_rec.transfer_type = 'TRANSFER' THEN
791: l_exchange_rate_type := NULL;
792: ozf_utility_pvt.calculate_functional_currency(
793: p_from_amount => l_act_budgets_rec.approved_amount
794: ,p_conv_date => l_act_budgets_rec.exchange_rate_date
795: ,p_tc_currency_code => l_act_budgets_rec.request_currency
796: ,p_ledger_id => l_ledger_id

Line 805: ozf_utility_pvt.calculate_functional_currency(

801: ,x_exchange_rate => l_exchange_rate
802: ,x_return_status => l_return_status);
803:
804: ELSE
805: ozf_utility_pvt.calculate_functional_currency(
806: p_from_amount => l_act_budgets_rec.approved_amount
807: ,p_tc_currency_code => l_act_budgets_rec.request_currency
808: ,p_ledger_id => l_ledger_id
809: ,x_to_amount => l_fc_amount

Line 820: ozf_utility_pvt.calculate_functional_curr(

816: END IF;
817:
818:
819: /*
820: ozf_utility_pvt.calculate_functional_curr(
821: p_from_amount => l_act_budgets_rec.approved_amount
822: ,p_tc_currency_code => l_act_budgets_rec.request_currency
823: ,x_to_amount => l_fc_amount
824: ,x_set_of_books_id => l_set_of_books_id

Line 903: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)

899: ,l_act_budgets_rec.parent_act_budget_id, l_act_budgets_rec.contact_id
900: ,l_act_budgets_rec.reason_code, l_act_budgets_rec.transfer_type
901: ,NVL (
902: l_act_budgets_rec.requester_id
903: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)
904: ) --l_act_budgets_rec.requester_id
905: ,l_act_budgets_rec.date_required_by
906: ,null --l_act_budgets_rec.parent_source_id
907: ,l_act_budgets_rec.parent_src_curr

Line 937: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)

933: ,p_note=> l_act_budgets_rec.justification
934: ,p_note_type=> 'AMS_JUSTIFICATION'
935: ,p_user=> NVL (
936: l_act_budgets_rec.requester_id
937: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)
938: )
939: ,x_msg_count=> x_msg_count
940: ,x_msg_data=> x_msg_data
941: ,x_return_status=> l_return_status

Line 976: ozf_utility_pvt.debug_message ( l_api_name

972: -- 02/23/2001 mpande whenever user enters a amount as utlized
973: -- For this amount a utilized record is entered in fund_utilized table
974: --That means the budget is utilized . Budget Utlized for offers take place through orders
975: IF G_DEBUG THEN
976: ozf_utility_pvt.debug_message ( l_api_name
977: || ': check items');
978: END IF;
979:
980: -- 06/25/2001 mpande changed by mpande

Line 1503: ozf_utility_pvt.convert_currency (

1499: --Added for bug 7425189
1500: IF l_act_budgets_rec.justification IN (l_fund_reconc_msg,l_act_bud_cst_msg)
1501: AND l_act_budgets_rec.exchange_rate_date IS NOT NULL THEN
1502:
1503: ozf_utility_pvt.convert_currency (
1504: x_return_status=> l_return_status
1505: ,p_from_currency=> l_act_budgets_rec.approved_in_currency
1506: ,p_to_currency=> l_act_budgets_rec.request_currency
1507: ,p_conv_date=> l_act_budgets_rec.exchange_rate_date

Line 1512: ozf_utility_pvt.convert_currency (

1508: ,p_from_amount=> l_act_budgets_rec.src_curr_req_amt
1509: ,x_to_amount=> l_act_budgets_rec.request_amount
1510: );
1511: ELSE
1512: ozf_utility_pvt.convert_currency (
1513: x_return_status=> l_return_status
1514: ,p_from_currency=> l_act_budgets_rec.approved_in_currency
1515: ,p_to_currency=> l_act_budgets_rec.request_currency
1516: ,p_from_amount=> l_act_budgets_rec.src_curr_req_amt

Line 1532: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');

1528: END IF;
1529: /* End OF CHange mpande 12/19/2001 */
1530:
1531: IF l_act_budgets_rec.request_currency IS NULL THEN
1532: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');
1533: x_return_status := fnd_api.g_ret_sts_error;
1534: END IF;
1535:
1536: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 1544: ozf_utility_pvt.get_default_user_status (l_status_type, l_act_budgets_rec.status_code);

1540: END IF;
1541:
1542: IF l_act_budgets_rec.user_status_id IS NULL THEN
1543: l_act_budgets_rec.user_status_id :=
1544: ozf_utility_pvt.get_default_user_status (l_status_type, l_act_budgets_rec.status_code);
1545: ELSE
1546: l_act_budgets_rec.status_code :=
1547: ozf_utility_pvt.get_system_status_code (l_act_budgets_rec.user_status_id);
1548: END IF;

Line 1547: ozf_utility_pvt.get_system_status_code (l_act_budgets_rec.user_status_id);

1543: l_act_budgets_rec.user_status_id :=
1544: ozf_utility_pvt.get_default_user_status (l_status_type, l_act_budgets_rec.status_code);
1545: ELSE
1546: l_act_budgets_rec.status_code :=
1547: ozf_utility_pvt.get_system_status_code (l_act_budgets_rec.user_status_id);
1548: END IF;
1549:
1550: -- status rules for updating replace the record with one which
1551: -- only allows update of specific fields according to the status of the budget

Line 1558: ozf_utility_pvt.error_message ('OZF_API_RECORD_NOT_FOUND');

1554: FETCH c_current_status INTO l_old_status_code, l_old_approved_amount,l_old_parent_src_amt;
1555:
1556: IF c_current_status%NOTFOUND THEN
1557: CLOSE c_current_status;
1558: ozf_utility_pvt.error_message ('OZF_API_RECORD_NOT_FOUND');
1559: RAISE fnd_api.g_exc_unexpected_error;
1560: END IF;
1561:
1562: CLOSE c_current_status;

Line 1564: ozf_utility_pvt.debug_message(' l_old_status_code :'|| l_old_status_code );

1560: END IF;
1561:
1562: CLOSE c_current_status;
1563:
1564: ozf_utility_pvt.debug_message(' l_old_status_code :'|| l_old_status_code );
1565: ozf_utility_pvt.debug_message(' l_old_approved_amount :'|| l_old_approved_amount );
1566: ozf_utility_pvt.debug_message(' l_old_parent_src_amt :'|| l_old_parent_src_amt );
1567: ozf_utility_pvt.debug_message(' status_code :'|| l_act_budgets_rec.status_code );
1568:

Line 1565: ozf_utility_pvt.debug_message(' l_old_approved_amount :'|| l_old_approved_amount );

1561:
1562: CLOSE c_current_status;
1563:
1564: ozf_utility_pvt.debug_message(' l_old_status_code :'|| l_old_status_code );
1565: ozf_utility_pvt.debug_message(' l_old_approved_amount :'|| l_old_approved_amount );
1566: ozf_utility_pvt.debug_message(' l_old_parent_src_amt :'|| l_old_parent_src_amt );
1567: ozf_utility_pvt.debug_message(' status_code :'|| l_act_budgets_rec.status_code );
1568:
1569: IF l_old_status_code = 'CLOSED' THEN

Line 1566: ozf_utility_pvt.debug_message(' l_old_parent_src_amt :'|| l_old_parent_src_amt );

1562: CLOSE c_current_status;
1563:
1564: ozf_utility_pvt.debug_message(' l_old_status_code :'|| l_old_status_code );
1565: ozf_utility_pvt.debug_message(' l_old_approved_amount :'|| l_old_approved_amount );
1566: ozf_utility_pvt.debug_message(' l_old_parent_src_amt :'|| l_old_parent_src_amt );
1567: ozf_utility_pvt.debug_message(' status_code :'|| l_act_budgets_rec.status_code );
1568:
1569: IF l_old_status_code = 'CLOSED' THEN
1570: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_REJECTED');

Line 1567: ozf_utility_pvt.debug_message(' status_code :'|| l_act_budgets_rec.status_code );

1563:
1564: ozf_utility_pvt.debug_message(' l_old_status_code :'|| l_old_status_code );
1565: ozf_utility_pvt.debug_message(' l_old_approved_amount :'|| l_old_approved_amount );
1566: ozf_utility_pvt.debug_message(' l_old_parent_src_amt :'|| l_old_parent_src_amt );
1567: ozf_utility_pvt.debug_message(' status_code :'|| l_act_budgets_rec.status_code );
1568:
1569: IF l_old_status_code = 'CLOSED' THEN
1570: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_REJECTED');
1571: RAISE fnd_api.g_exc_error;

Line 1570: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_REJECTED');

1566: ozf_utility_pvt.debug_message(' l_old_parent_src_amt :'|| l_old_parent_src_amt );
1567: ozf_utility_pvt.debug_message(' status_code :'|| l_act_budgets_rec.status_code );
1568:
1569: IF l_old_status_code = 'CLOSED' THEN
1570: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_REJECTED');
1571: RAISE fnd_api.g_exc_error;
1572: ELSIF l_old_status_code = 'REJECTED' THEN
1573: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_REJECTED');
1574: RAISE fnd_api.g_exc_error;

Line 1573: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_REJECTED');

1569: IF l_old_status_code = 'CLOSED' THEN
1570: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_REJECTED');
1571: RAISE fnd_api.g_exc_error;
1572: ELSIF l_old_status_code = 'REJECTED' THEN
1573: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_REJECTED');
1574: RAISE fnd_api.g_exc_error;
1575: --
1576: -- Cases of valid approval:
1577: -- 1) WF approval process responds to request to APPROVE, in which case, old status

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

1581: ELSIF ( (l_old_status_code = 'PENDING' OR l_old_status_code = 'PENDING_VALIDATION')
1582: AND l_act_budgets_rec.status_code = 'APPROVED'
1583: ) THEN
1584: --for pending validation, need pass approved_in_currency.fixed bug 2853987 by feliu.
1585: ozf_utility_pvt.debug_message(' here>>');
1586: IF l_old_status_code = 'PENDING_VALIDATION' THEN
1587: --l_act_budgets_rec.approved_in_currency := l_act_budgets_rec.request_currency;
1588: --fix bug 3354280 by feliu on 02/07/04
1589: l_act_budgets_rec.approved_in_currency :=get_object_currency (

Line 1634: ozf_utility_pvt.convert_currency (

1630: ELSE
1631: -- convert the request amount to the fund's currency. the planned amount for a fund
1632: -- is stored in the table as a value based on the transactional currency, so the
1633: -- request amount must also be based on the same currency.
1634: ozf_utility_pvt.convert_currency (
1635: x_return_status=> l_return_status
1636: ,p_from_currency=> l_act_budgets_rec.request_currency
1637: ,p_to_currency=> l_fund_currency_tc
1638: ,p_from_amount=> l_act_budgets_rec.request_amount

Line 1655: ozf_utility_pvt.convert_currency (

1651: l_univ_amount := l_act_budgets_rec.request_amount;
1652: ELSIF g_universal_currency = l_fund_currency_tc THEN
1653: l_univ_amount := l_fund_rec.planned_amt;
1654: ELSE
1655: ozf_utility_pvt.convert_currency (
1656: x_return_status=> l_return_status
1657: ,p_from_currency=> l_act_budgets_rec.request_currency
1658: ,p_to_currency=> g_universal_currency
1659: ,p_from_amount=> l_act_budgets_rec.request_amount

Line 1793: ozf_utility_pvt.convert_currency (

1789: -- convert the request amount to the fund's currency. the planned amount for a fund
1790: -- is stored in the table as a value based on the transactional currency, so the
1791: -- request amount must also be based on the same currency.
1792:
1793: ozf_utility_pvt.convert_currency (
1794: x_return_status=> l_return_status
1795: ,p_from_currency=> l_act_budgets_rec.request_currency
1796: ,p_to_currency=> l_fund_currency_tc
1797: ,p_from_amount=> l_act_budgets_rec.request_amount

Line 1814: ozf_utility_pvt.convert_currency (

1810: l_univ_amount := l_act_budgets_rec.request_amount;
1811: ELSIF g_universal_currency = l_fund_currency_tc THEN
1812: l_univ_amount := l_fund_rec.planned_amt;
1813: ELSE
1814: ozf_utility_pvt.convert_currency (
1815: x_return_status=> l_return_status
1816: ,p_from_currency=> l_act_budgets_rec.request_currency
1817: ,p_to_currency=> g_universal_currency
1818: ,p_from_amount=> l_act_budgets_rec.request_amount

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

1886: IF OZF_ACTBUDGETRULES_PVT.budget_has_enough_money (
1887: p_source_id=> l_act_budgets_rec.budget_source_id
1888: ,p_approved_amount=> l_fund_rec.planned_amt
1889: ) = fnd_api.g_false THEN
1890: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_MONEY');
1891: RAISE fnd_api.g_exc_error;
1892: END IF;
1893: END IF;
1894:

Line 1975: ozf_utility_pvt.convert_currency (

1971:
1972: --Added for bug 7425189
1973: IF l_act_budgets_rec.justification IN (l_fund_reconc_msg,l_act_bud_cst_msg)
1974: AND l_act_budgets_rec.exchange_rate_date IS NOT NULL THEN
1975: ozf_utility_pvt.convert_currency (
1976: x_return_status=> l_return_status
1977: ,p_from_currency=> l_act_budgets_rec.request_currency
1978: ,p_to_currency=> l_act_budgets_rec.approved_in_currency
1979: ,p_conv_type=> l_exchange_rate_type

Line 1987: ozf_utility_pvt.convert_currency (

1983: ,x_rate=> l_rate
1984: );
1985:
1986: ELSE
1987: ozf_utility_pvt.convert_currency (
1988: x_return_status=> l_return_status
1989: ,p_from_currency=> l_act_budgets_rec.request_currency
1990: ,p_to_currency=> l_act_budgets_rec.approved_in_currency
1991: ,p_conv_type=> l_exchange_rate_type

Line 2013: ozf_utility_pvt.get_default_user_status (l_status_type, l_act_budgets_rec.status_code);

2009:
2010: -- get the corresponding user_status_id
2011: -- for the given status_code.
2012: l_act_budgets_rec.user_status_id :=
2013: ozf_utility_pvt.get_default_user_status (l_status_type, l_act_budgets_rec.status_code);
2014: IF G_DEBUG THEN
2015: ozf_utility_pvt.debug_message ( l_api_name
2016: || ': check items');
2017: END IF;

Line 2015: ozf_utility_pvt.debug_message ( l_api_name

2011: -- for the given status_code.
2012: l_act_budgets_rec.user_status_id :=
2013: ozf_utility_pvt.get_default_user_status (l_status_type, l_act_budgets_rec.status_code);
2014: IF G_DEBUG THEN
2015: ozf_utility_pvt.debug_message ( l_api_name
2016: || ': check items');
2017: END IF;
2018: l_act_budgets_rec.comment := p_act_budgets_rec.comment;
2019:

Line 2049: ozf_utility_pvt.convert_currency(

2045: IF l_act_budgets_rec.justification IN (l_fund_reconc_msg,l_act_bud_cst_msg)
2046: AND l_act_budgets_rec.exchange_rate_date IS NOT NULL THEN
2047:
2048: IF l_act_budgets_rec.src_curr_req_amt IS NULL THEN
2049: ozf_utility_pvt.convert_currency(
2050: p_from_currency => l_act_budgets_rec.request_currency
2051: ,p_to_currency => l_src_currency
2052: ,p_conv_type => l_exchange_rate_type
2053: ,p_conv_date => l_act_budgets_rec.exchange_rate_date

Line 2060: ozf_utility_pvt.convert_currency(

2056: ,x_to_amount => l_act_budgets_rec.src_curr_req_amt
2057: ,x_rate => l_rate);
2058: END IF;
2059: ELSE
2060: ozf_utility_pvt.convert_currency(
2061: p_from_currency => l_act_budgets_rec.request_currency
2062: ,p_to_currency => l_src_currency
2063: ,p_conv_type => l_exchange_rate_type
2064: ,p_from_amount => l_act_budgets_rec.request_amount

Line 2094: ozf_utility_pvt.debug_message ( l_api_name

2090: END IF;
2091: END IF;
2092:
2093: IF G_DEBUG THEN
2094: ozf_utility_pvt.debug_message ( l_api_name
2095: || ': check records');
2096: END IF;
2097:
2098: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN

Line 2128: ozf_utility_pvt.write_conc_log('NP '||l_api_name ||' l_act_util_rec.org_id '||l_act_util_rec.org_id);

2124: RAISE fnd_api.g_exc_unexpected_error;
2125: END IF;
2126:
2127:
2128: ozf_utility_pvt.write_conc_log('NP '||l_api_name ||' l_act_util_rec.org_id '||l_act_util_rec.org_id);
2129: ozf_utility_pvt.write_conc_log('NP '||l_api_name ||' arc_act_budget_used_by '|| l_act_budgets_rec.arc_act_budget_used_by);
2130:
2131: ozf_utility_pvt.write_conc_log('NP '||l_api_name ||' act_budget_used_by_id '|| l_act_budgets_rec.act_budget_used_by_id);
2132:

Line 2129: ozf_utility_pvt.write_conc_log('NP '||l_api_name ||' arc_act_budget_used_by '|| l_act_budgets_rec.arc_act_budget_used_by);

2125: END IF;
2126:
2127:
2128: ozf_utility_pvt.write_conc_log('NP '||l_api_name ||' l_act_util_rec.org_id '||l_act_util_rec.org_id);
2129: ozf_utility_pvt.write_conc_log('NP '||l_api_name ||' arc_act_budget_used_by '|| l_act_budgets_rec.arc_act_budget_used_by);
2130:
2131: ozf_utility_pvt.write_conc_log('NP '||l_api_name ||' act_budget_used_by_id '|| l_act_budgets_rec.act_budget_used_by_id);
2132:
2133:

Line 2131: ozf_utility_pvt.write_conc_log('NP '||l_api_name ||' act_budget_used_by_id '|| l_act_budgets_rec.act_budget_used_by_id);

2127:
2128: ozf_utility_pvt.write_conc_log('NP '||l_api_name ||' l_act_util_rec.org_id '||l_act_util_rec.org_id);
2129: ozf_utility_pvt.write_conc_log('NP '||l_api_name ||' arc_act_budget_used_by '|| l_act_budgets_rec.arc_act_budget_used_by);
2130:
2131: ozf_utility_pvt.write_conc_log('NP '||l_api_name ||' act_budget_used_by_id '|| l_act_budgets_rec.act_budget_used_by_id);
2132:
2133:
2134:
2135: IF NVL(l_act_budgets_rec.approved_amount,0) <> 0 THEN

Line 2144: ozf_utility_pvt.debug_message ( l_api_name

2140: p_ledger_id => l_ledger_id,
2141: p_ledger_name => l_ledger_name
2142: );
2143: IF G_DEBUG THEN
2144: ozf_utility_pvt.debug_message ( l_api_name
2145: || ': create_act_budgets ledger for util.org_id('
2146: || l_act_util_rec.org_id || ')=' || l_ledger_id);
2147: END IF;
2148: ozf_utility_pvt.write_conc_log ( l_api_name

Line 2148: ozf_utility_pvt.write_conc_log ( l_api_name

2144: ozf_utility_pvt.debug_message ( l_api_name
2145: || ': create_act_budgets ledger for util.org_id('
2146: || l_act_util_rec.org_id || ')=' || l_ledger_id);
2147: END IF;
2148: ozf_utility_pvt.write_conc_log ( l_api_name
2149: || ': create_act_budgets ledger for util.org_id('
2150: || l_act_util_rec.org_id || ')=' || l_ledger_id);
2151: ELSE
2152:

Line 2153: ozf_utility_pvt.get_object_org_ledger(p_object_type => l_act_budgets_rec.arc_act_budget_used_by

2149: || ': create_act_budgets ledger for util.org_id('
2150: || l_act_util_rec.org_id || ')=' || l_ledger_id);
2151: ELSE
2152:
2153: ozf_utility_pvt.get_object_org_ledger(p_object_type => l_act_budgets_rec.arc_act_budget_used_by
2154: , p_object_id => l_act_budgets_rec.act_budget_used_by_id
2155: , x_org_id => l_act_util_rec.org_id
2156: , x_ledger_id => l_ledger_id
2157: , x_return_status => l_return_status

Line 2160: ozf_utility_pvt.debug_message ( l_api_name

2156: , x_ledger_id => l_ledger_id
2157: , x_return_status => l_return_status
2158: );
2159: IF G_DEBUG THEN
2160: ozf_utility_pvt.debug_message ( l_api_name
2161: || ': create_act_budgets ledger for '
2162: || l_act_budgets_rec.arc_act_budget_used_by
2163: || ' id('
2164: || l_act_budgets_rec.act_budget_used_by_id

Line 2168: ozf_utility_pvt.write_conc_log ( l_api_name

2164: || l_act_budgets_rec.act_budget_used_by_id
2165: || ') returns ' || l_return_status
2166: || ' ledger_id=' || l_ledger_id);
2167: END IF;
2168: ozf_utility_pvt.write_conc_log ( l_api_name
2169: || ': create_act_budgets ledger for '
2170: || l_act_budgets_rec.arc_act_budget_used_by
2171: || ' id('
2172: || l_act_budgets_rec.act_budget_used_by_id

Line 2195: ozf_utility_pvt.debug_message ( l_api_name

2191: IF l_ledger_id IS NULL AND l_is_quota IS NULL THEN
2192: IF l_act_budgets_rec.budget_source_type NOT IN ('CAMP', 'CSCH', 'EVEO', 'EVEH', 'EONE') AND
2193: l_act_budgets_rec.arc_act_budget_used_by NOT IN ('CAMP', 'CSCH', 'EVEO', 'EVEH', 'EONE') THEN
2194: IF G_DEBUG THEN
2195: ozf_utility_pvt.debug_message ( l_api_name
2196: || ': create_act_budgets ledger not found for '
2197: || l_act_budgets_rec.arc_act_budget_used_by
2198: || ' id('
2199: || l_act_budgets_rec.act_budget_used_by_id);

Line 2217: ozf_utility_pvt.debug_message ('NP request_currency '||l_act_budgets_rec.request_currency);

2213: OPEN c_get_conversion_type(l_act_util_rec.org_id);
2214: FETCH c_get_conversion_type INTO l_exchange_rate_type;
2215: CLOSE c_get_conversion_type;
2216:
2217: ozf_utility_pvt.debug_message ('NP request_currency '||l_act_budgets_rec.request_currency);
2218:
2219:
2220: --Added for bug 7425189
2221: IF l_act_budgets_rec.justification IN (l_fund_reconc_msg,l_act_bud_cst_msg)

Line 2224: ozf_utility_pvt.calculate_functional_currency(

2220: --Added for bug 7425189
2221: IF l_act_budgets_rec.justification IN (l_fund_reconc_msg,l_act_bud_cst_msg)
2222: AND l_act_budgets_rec.exchange_rate_date IS NOT NULL THEN
2223: l_exchange_rate_type := NULL;
2224: ozf_utility_pvt.calculate_functional_currency(
2225: p_from_amount => l_act_budgets_rec.approved_amount
2226: ,p_conv_date => l_act_budgets_rec.exchange_rate_date
2227: ,p_tc_currency_code => l_act_budgets_rec.request_currency
2228: ,p_ledger_id => l_ledger_id

Line 2236: ozf_utility_pvt.calculate_functional_currency(

2232: ,x_exchange_rate_type => l_exchange_rate_type
2233: ,x_exchange_rate => l_exchange_rate
2234: ,x_return_status => l_return_status);
2235: ELSE
2236: ozf_utility_pvt.calculate_functional_currency(
2237: p_from_amount => l_act_budgets_rec.approved_amount
2238: ,p_tc_currency_code => l_act_budgets_rec.request_currency
2239: ,p_ledger_id => l_ledger_id
2240: ,x_to_amount => l_fc_amount

Line 2293: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)

2289: ,parent_act_budget_id = l_act_budgets_rec.parent_act_budget_id
2290: ,contact_id = l_act_budgets_rec.contact_id
2291: ,requester_id = NVL (
2292: l_act_budgets_rec.requester_id
2293: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)
2294: ) --l_act_budgets_rec.requester_id
2295: ,date_required_by = l_act_budgets_rec.date_required_by
2296: ,parent_source_id = l_act_budgets_rec.parent_source_id,
2297: parent_src_curr = l_act_budgets_rec.parent_src_curr,

Line 2342: ozf_utility_pvt.get_default_user_status('OZF_BUDGETSOURCE_STATUS', 'APPROVED');

2338:
2339: IF l_start_flow_flag = 'Y' THEN
2340:
2341: l_new_status_id :=
2342: ozf_utility_pvt.get_default_user_status('OZF_BUDGETSOURCE_STATUS', 'APPROVED');
2343: l_reject_status_id :=
2344: ozf_utility_pvt.get_default_user_status('OZF_BUDGETSOURCE_STATUS', 'REJECTED');
2345:
2346: ams_gen_approval_pvt.startprocess(

Line 2344: ozf_utility_pvt.get_default_user_status('OZF_BUDGETSOURCE_STATUS', 'REJECTED');

2340:
2341: l_new_status_id :=
2342: ozf_utility_pvt.get_default_user_status('OZF_BUDGETSOURCE_STATUS', 'APPROVED');
2343: l_reject_status_id :=
2344: ozf_utility_pvt.get_default_user_status('OZF_BUDGETSOURCE_STATUS', 'REJECTED');
2345:
2346: ams_gen_approval_pvt.startprocess(
2347: p_activity_type => 'FREQ'
2348: ,p_activity_id => l_act_budgets_rec.activity_budget_id

Line 2372: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)

2368: ,p_note=> l_act_budgets_rec.COMMENT
2369: ,p_note_type=> 'AMS_COMMENT'
2370: ,p_user=> NVL (
2371: l_act_budgets_rec.requester_id
2372: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)
2373: )
2374: ,x_msg_count=> x_msg_count
2375: ,x_msg_data=> x_msg_data
2376: ,x_return_status=> l_return_status

Line 2393: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)

2389: ,p_note=> l_act_budgets_rec.justification
2390: ,p_note_type=> 'AMS_JUSTIFICATION'
2391: ,p_user=> NVL (
2392: l_act_budgets_rec.requester_id
2393: ,ozf_utility_pvt.get_resource_id (fnd_global.user_id)
2394: )
2395: ,x_msg_count=> x_msg_count
2396: ,x_msg_data=> x_msg_data
2397: ,x_return_status=> l_return_status

Line 2791: WHEN ozf_utility_pvt.resource_locked THEN

2787: p_count=> x_msg_count
2788: ,p_data=> x_msg_data
2789: ,p_encoded=> fnd_api.g_false
2790: );
2791: WHEN ozf_utility_pvt.resource_locked THEN
2792: x_return_status := fnd_api.g_ret_sts_error;
2793:
2794: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2795: fnd_message.set_name ('OZF', 'OZF_API_RESOURCE_LOCKED');

Line 2867: ozf_utility_pvt.debug_message ( l_full_name

2863: --
2864: -- API body
2865: --
2866: IF G_DEBUG THEN
2867: ozf_utility_pvt.debug_message ( l_full_name
2868: || ': check items');
2869: END IF;
2870:
2871: IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN

Line 2889: ozf_utility_pvt.debug_message ( l_full_name

2885:
2886: -- Perform cross attribute validation and missing attribute checks. Record
2887: -- level validation.
2888: IF G_DEBUG THEN
2889: ozf_utility_pvt.debug_message ( l_full_name
2890: || ': check record level');
2891: END IF;
2892:
2893: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN

Line 3056: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');

3052:
3053: IF ( p_act_budgets_rec.request_currency IS NULL
3054: OR p_act_budgets_rec.request_currency = fnd_api.g_miss_char
3055: ) THEN
3056: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');
3057: x_return_status := fnd_api.g_ret_sts_error;
3058: RETURN;
3059: END IF;
3060: -- Validate uniqueness

Line 3063: IF ozf_utility_pvt.check_uniqueness (

3059: END IF;
3060: -- Validate uniqueness
3061: IF p_validation_mode = jtf_plsql_api.g_create
3062: AND p_act_budgets_rec.activity_budget_id IS NOT NULL THEN
3063: IF ozf_utility_pvt.check_uniqueness (
3064: 'ozf_Act_budgets'
3065: , 'ACTIVITY_BUDGET_ID = '
3066: || p_act_budgets_rec.activity_budget_id
3067: ) = fnd_api.g_false THEN

Line 3088: ozf_utility_pvt.debug_message ( 'Used By:'||p_act_budgets_rec.arc_act_budget_used_by);

3084: p_lookup_type=> 'AMS_SYS_ARC_QUALIFIER'
3085: ,p_lookup_code=> p_act_budgets_rec.arc_act_budget_used_by
3086: ) = fnd_api.g_false THEN
3087: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3088: ozf_utility_pvt.debug_message ( 'Used By:'||p_act_budgets_rec.arc_act_budget_used_by);
3089: fnd_message.set_name ('OZF', 'OZF_ACT_BUDG_BAD_USEDBY');
3090: fnd_msg_pub.ADD;
3091: END IF;
3092:

Line 3102: IF ozf_utility_pvt.check_lookup_exists (

3098: --
3099: -- check for lookups....BUDGET_SOURCE_TYPE
3100: --
3101: IF p_act_budgets_rec.budget_source_type <> fnd_api.g_miss_char THEN
3102: IF ozf_utility_pvt.check_lookup_exists (
3103: p_lookup_type=> 'OZF_FUND_SOURCE'
3104: ,p_lookup_code=> p_act_budgets_rec.budget_source_type
3105: ) = fnd_api.g_false THEN
3106: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

Line 3162: IF ozf_utility_pvt.check_fk_exists (

3158: END IF;
3159:
3160: l_pk_value := p_act_budgets_rec.act_budget_used_by_id;
3161:
3162: IF ozf_utility_pvt.check_fk_exists (
3163: p_table_name=> l_table_name
3164: ,p_pk_name=> l_pk_name
3165: ,p_pk_value=> l_pk_value
3166: ) = fnd_api.g_false THEN

Line 3230: IF ozf_utility_pvt.check_fk_exists (

3226: END IF;
3227:
3228: l_pk_value := p_act_budgets_rec.budget_source_id;
3229:
3230: IF ozf_utility_pvt.check_fk_exists (
3231: p_table_name=> l_table_name
3232: ,p_pk_name=> l_pk_name
3233: ,p_pk_value=> l_pk_value
3234: ) = fnd_api.g_false THEN

Line 3259: IF ozf_utility_pvt.check_fk_exists (

3255: l_table_name := 'ams_jtf_rs_emp_v';
3256: l_pk_name := 'RESOURCE_ID';
3257: l_pk_value := p_act_budgets_rec.approver_id;
3258:
3259: IF ozf_utility_pvt.check_fk_exists (
3260: p_table_name=> l_table_name
3261: ,p_pk_name=> l_pk_name
3262: ,p_pk_value=> l_pk_value
3263: ) = fnd_api.g_false THEN

Line 3281: IF ozf_utility_pvt.check_fk_exists (

3277: l_table_name := 'ams_jtf_rs_emp_v';
3278: l_pk_name := 'RESOURCE_ID';
3279: l_pk_value := p_act_budgets_rec.requester_id;
3280:
3281: IF ozf_utility_pvt.check_fk_exists (
3282: p_table_name=> l_table_name
3283: ,p_pk_name=> l_pk_name
3284: ,p_pk_value=> l_pk_value
3285: ) = fnd_api.g_false THEN

Line 3388: OZF_Utility_PVT.error_message ('OZF_ACT_BUDG_NEG_REQUEST');

3384: /****************** commented by mpande 02/10/2001 only for INternal rollout*************
3385: /****************** changed by mpande**********************
3386: ---budget requested amount should always be positive be it credit or debit transaction --
3387: IF NVL(p_act_budgets_rec.request_amount,0) <= 0 THEN
3388: OZF_Utility_PVT.error_message ('OZF_ACT_BUDG_NEG_REQUEST');
3389: x_return_status := FND_API.g_ret_sts_error;
3390: END IF;
3391: ********************************************************************************************/
3392:

Line 3411: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NEG_REQUEST');

3407: -- allow to create budget request with zero amount, not negative amount.
3408: -- fixed by feliu on 02/02/2006.
3409: IF p_act_budgets_rec.transfer_type <> 'UTILIZED' THEN
3410: IF NVL (p_act_budgets_rec.request_amount, 0) <0 THEN
3411: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NEG_REQUEST');
3412: x_return_status := fnd_api.g_ret_sts_error;
3413: END IF;
3414: END IF;
3415: -- END IF;

Line 3421: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_EXCESS_SPENT');

3417: -- 22-Feb-2001 mpande
3418: --budget spent amount cannot be greateer than the approved amount
3419: /* 03/01/2002 mpande commented this is not there any more
3420: IF NVL (p_act_budgets_rec.spent_amount, 0) > NVL (p_act_budgets_rec.approved_amount, 0) THEN
3421: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_EXCESS_SPENT');
3422: x_return_status := fnd_api.g_ret_sts_error;
3423: END IF;
3424: */
3425:

Line 3440: ozf_utility_pvt.error_message ('OZF_API_RECORD_NOT_FOUND');

3436: FETCH c_current_amount INTO l_old_approved_amount;
3437:
3438: IF c_current_amount%NOTFOUND THEN
3439: CLOSE c_current_amount;
3440: ozf_utility_pvt.error_message ('OZF_API_RECORD_NOT_FOUND');
3441: RAISE fnd_api.g_exc_unexpected_error;
3442: END IF;
3443:
3444: CLOSE c_current_amount;

Line 3476: ozf_utility_pvt.error_message ('OZF_BUDGET_OFFR_LEDG_MISMATCH');

3472: FETCH c_get_budget_ledger_id INTO l_budgetLedger;
3473: CLOSE c_get_budget_ledger_id;
3474:
3475: IF NVL(l_budgetLedger, 0) <> 0 AND NVL(l_budgetLedger, 0) <> l_offerLedger THEN
3476: ozf_utility_pvt.error_message ('OZF_BUDGET_OFFR_LEDG_MISMATCH');
3477: x_return_status := fnd_api.g_ret_sts_error;
3478: RAISE fnd_api.g_exc_error;
3479: END IF;
3480:

Line 3558: ozf_utility_pvt.error_message ( 'OZF_ACT_BUDG_EXC_OBJ_AMT');

3554: ,p_object_id=> p_act_budgets_rec.act_budget_used_by_id
3555: ,p_request_amount=> p_act_budgets_rec.request_amount
3556: ,p_act_budget_id=> p_act_budgets_rec.activity_budget_id
3557: ) = fnd_api.g_false THEN
3558: ozf_utility_pvt.error_message ( 'OZF_ACT_BUDG_EXC_OBJ_AMT');
3559: x_return_status := fnd_api.g_ret_sts_error;
3560: END IF;
3561: END IF ;
3562:

Line 3613: ozf_utility_pvt.error_message ('OZF_FROM_TO_TRANSFER_SAME');

3609: -- Check that transfer cannot be from and to the same source if it s not utlized record for the object
3610: IF p_act_budgets_rec.transfer_type NOT IN ('UTILIZED', 'RELEASE', 'RESERVE') THEN
3611: IF p_act_budgets_rec.arc_act_budget_used_by = p_act_budgets_rec.budget_source_type THEN
3612: IF p_act_budgets_rec.act_budget_used_by_id = p_act_budgets_rec.budget_source_id THEN
3613: ozf_utility_pvt.error_message ('OZF_FROM_TO_TRANSFER_SAME');
3614: x_return_status := fnd_api.g_ret_sts_error;
3615: END IF;
3616: END IF;
3617: END IF;

Line 4200: ozf_utility_pvt.convert_currency (

4196: RAISE fnd_api.g_exc_unexpected_error;
4197: END IF;
4198:
4199: IF l_approved_in_currency <> p_act_budget_rec.request_currency THEN
4200: ozf_utility_pvt.convert_currency (
4201: x_return_status=> l_return_status
4202: ,p_from_currency=> p_act_budget_rec.request_currency
4203: ,p_to_currency=> l_approved_in_currency
4204: ,p_from_amount=> p_act_budget_rec.request_amount

Line 4264: ,p_user_id=> ozf_utility_pvt.get_resource_id (fnd_global.user_id)

4260: ,p_validation_level=> fnd_api.g_valid_level_full
4261: ,x_return_status=> l_return_status
4262: ,x_msg_data=> x_msg_data
4263: ,x_msg_count=> x_msg_count
4264: ,p_user_id=> ozf_utility_pvt.get_resource_id (fnd_global.user_id)
4265: ,p_act_budget_id=> p_act_budget_rec.activity_budget_id
4266: ,p_orig_status_id=> l_orig_status
4267: ,p_new_status_id=> l_new_status
4268: ,p_rejected_status_id=> l_reject_status

Line 4296: ozf_utility_pvt.convert_currency (

4292: RAISE fnd_api.g_exc_unexpected_error;
4293: END IF;
4294:
4295: IF l_approved_in_currency <> p_act_budget_rec.request_currency THEN
4296: ozf_utility_pvt.convert_currency (
4297: x_return_status=> l_return_status
4298: ,p_from_currency=> p_act_budget_rec.request_currency
4299: ,p_to_currency=> l_approved_in_currency
4300: ,p_from_amount=> p_act_budget_rec.request_amount

Line 4444: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');

4440: FETCH c_campaign INTO l_currency_code;
4441:
4442: IF c_campaign%NOTFOUND THEN
4443: CLOSE c_campaign;
4444: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');
4445: x_return_status := fnd_api.g_ret_sts_error;
4446: RAISE fnd_api.g_exc_error;
4447: END IF;
4448:

Line 4457: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');

4453: FETCH c_campaign_schl INTO l_currency_code;
4454:
4455: IF c_campaign_schl%NOTFOUND THEN
4456: CLOSE c_campaign_schl;
4457: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');
4458: x_return_status := fnd_api.g_ret_sts_error;
4459: RAISE fnd_api.g_exc_error;
4460: END IF;
4461:

Line 4470: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');

4466: FETCH c_eheader INTO l_currency_code;
4467:
4468: IF c_eheader%NOTFOUND THEN
4469: CLOSE c_eheader;
4470: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');
4471: x_return_status := fnd_api.g_ret_sts_error;
4472: RAISE fnd_api.g_exc_error;
4473: END IF;
4474:

Line 4483: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');

4479: FETCH c_eoffer INTO l_currency_code;
4480:
4481: IF c_eoffer%NOTFOUND THEN
4482: CLOSE c_eoffer;
4483: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');
4484: x_return_status := fnd_api.g_ret_sts_error;
4485: RAISE fnd_api.g_exc_error;
4486: END IF;
4487:

Line 4496: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');

4492: FETCH c_deliverable INTO l_currency_code;
4493:
4494: IF c_deliverable%NOTFOUND THEN
4495: CLOSE c_deliverable;
4496: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');
4497: x_return_status := fnd_api.g_ret_sts_error;
4498: RAISE fnd_api.g_exc_error;
4499: END IF;
4500:

Line 4508: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');

4504: FETCH c_fund INTO l_currency_code;
4505:
4506: IF c_fund%NOTFOUND THEN
4507: CLOSE c_fund;
4508: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');
4509: x_return_status := fnd_api.g_ret_sts_error;
4510: RAISE fnd_api.g_exc_error;
4511: END IF;
4512:

Line 4521: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');

4517: FETCH c_offer INTO l_currency_code;
4518:
4519: IF c_offer%NOTFOUND THEN
4520: CLOSE c_offer;
4521: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');
4522: x_return_status := fnd_api.g_ret_sts_error;
4523: RAISE fnd_api.g_exc_error;
4524: END IF;
4525:

Line 4533: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');

4529: FETCH c_pricelist INTO l_currency_code;
4530:
4531: IF c_pricelist%NOTFOUND THEN
4532: CLOSE c_pricelist;
4533: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');
4534: x_return_status := fnd_api.g_ret_sts_error;
4535: RAISE fnd_api.g_exc_error;
4536: END IF;
4537:

Line 4545: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');

4541: FETCH c_worksheet INTO l_currency_code;
4542:
4543: IF c_worksheet%NOTFOUND THEN
4544: CLOSE c_worksheet;
4545: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');
4546: x_return_status := fnd_api.g_ret_sts_error;
4547: RAISE fnd_api.g_exc_error;
4548: END IF;
4549:

Line 4557: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');

4553: FETCH c_soft_fund INTO l_currency_code;
4554:
4555: IF c_soft_fund%NOTFOUND THEN
4556: CLOSE c_soft_fund;
4557: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');
4558: x_return_status := fnd_api.g_ret_sts_error;
4559: RAISE fnd_api.g_exc_error;
4560: END IF;
4561:

Line 4569: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');

4565: FETCH c_special_price INTO l_currency_code;
4566:
4567: IF c_special_price%NOTFOUND THEN
4568: CLOSE c_special_price;
4569: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');
4570: x_return_status := fnd_api.g_ret_sts_error;
4571: RAISE fnd_api.g_exc_error;
4572: END IF;
4573:

Line 4577: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');

4573:
4574: CLOSE c_special_price;
4575: ELSE
4576:
4577: ozf_utility_pvt.error_message ('OZF_ACT_BUDG_NO_CURRENCY');
4578: x_return_status := fnd_api.g_ret_sts_error;
4579: RAISE fnd_api.g_exc_error;
4580: END IF;
4581:

Line 4691: ozf_utility_pvt.debug_message ( g_package_name

4687: AND fund_id = p_fund_id;
4688:
4689: BEGIN
4690: IF G_DEBUG THEN
4691: ozf_utility_pvt.debug_message ( g_package_name
4692: || '.'
4693: || l_api_name
4694: || ': start');
4695: END IF;

Line 4701: ozf_utility_pvt.error_message ('OZF_ACT_BUDGET_NO_APPR_CURR');

4697: -- The from currency should be passed in before currency
4698: -- conversion can be performed.
4699: IF p_act_budget_rec.approved_in_currency IS NULL
4700: OR p_act_budget_rec.approved_in_currency = fnd_api.g_miss_char THEN
4701: ozf_utility_pvt.error_message ('OZF_ACT_BUDGET_NO_APPR_CURR');
4702: RAISE fnd_api.g_exc_error;
4703: END IF;
4704:
4705: --Added for bug 7425189

Line 4719: ozf_Utility_PVT.error_message ('OZF_ACT_BUDG_NO_MONEY');

4715: p_source_type => p_act_budget_rec.budget_source_type,
4716: p_source_id => p_act_budget_rec.budget_source_id,
4717: p_approved_amount => p_act_budget_rec.approved_original_amount
4718: ) = FND_API.g_false THEN
4719: ozf_Utility_PVT.error_message ('OZF_ACT_BUDG_NO_MONEY');
4720: RAISE FND_API.g_exc_error;
4721: END IF;
4722: END IF;
4723:

Line 4728: ozf_utility_pvt.debug_message(g_package_name||' transfer_type '||p_act_budget_rec.transfer_type);

4724: IF p_mode = 'UPDATE' THEN
4725: init_act_budgets_rec (l_temp_in_rec);
4726: END IF;
4727:
4728: ozf_utility_pvt.debug_message(g_package_name||' transfer_type '||p_act_budget_rec.transfer_type);
4729: ozf_utility_pvt.debug_message(g_package_name||' recal_flag '||p_act_budget_rec.recal_flag);
4730:
4731:
4732: l_temp_in_rec.activity_budget_id := p_act_budget_rec.activity_budget_id;

Line 4729: ozf_utility_pvt.debug_message(g_package_name||' recal_flag '||p_act_budget_rec.recal_flag);

4725: init_act_budgets_rec (l_temp_in_rec);
4726: END IF;
4727:
4728: ozf_utility_pvt.debug_message(g_package_name||' transfer_type '||p_act_budget_rec.transfer_type);
4729: ozf_utility_pvt.debug_message(g_package_name||' recal_flag '||p_act_budget_rec.recal_flag);
4730:
4731:
4732: l_temp_in_rec.activity_budget_id := p_act_budget_rec.activity_budget_id;
4733: l_temp_in_rec.object_version_number := p_act_budget_rec.object_version_number;

Line 4782: ozf_utility_pvt.convert_currency (

4778:
4779: --Added for bug 7425189
4780: IF p_act_budget_rec.justification IN (l_fund_reconc_msg,l_act_bud_cst_msg)
4781: AND p_act_budget_rec.exchange_rate_date IS NOT NULL THEN
4782: ozf_utility_pvt.convert_currency (
4783: x_return_status=> l_return_status
4784: ,p_from_currency=> l_temp_rec.request_currency
4785: ,p_to_currency=> l_temp_rec.approved_in_currency
4786: ,p_conv_date=> p_act_budget_rec.exchange_rate_date

Line 4791: ozf_utility_pvt.convert_currency (

4787: ,p_from_amount=> l_temp_rec.request_amount
4788: ,x_to_amount=> l_temp_rec.approved_original_amount
4789: );
4790: ELSE
4791: ozf_utility_pvt.convert_currency (
4792: x_return_status=> l_return_status
4793: ,p_from_currency=> l_temp_rec.request_currency
4794: ,p_to_currency=> l_temp_rec.approved_in_currency
4795: ,p_from_amount=> l_temp_rec.request_amount

Line 4821: ozf_utility_pvt.convert_currency (

4817: ELSE
4818: --Added for bug 7425189
4819: IF p_act_budget_rec.justification IN (l_fund_reconc_msg,l_act_bud_cst_msg)
4820: AND p_act_budget_rec.exchange_rate_date IS NOT NULL THEN
4821: ozf_utility_pvt.convert_currency (
4822: x_return_status=> l_return_status
4823: ,p_from_currency=> l_temp_rec.approved_in_currency
4824: ,p_to_currency=> l_temp_rec.request_currency
4825: ,p_conv_date=> p_act_budget_rec.exchange_rate_date

Line 4830: ozf_utility_pvt.convert_currency (

4826: ,p_from_amount=> l_temp_rec.approved_original_amount
4827: ,x_to_amount=> l_temp_rec.approved_amount
4828: );
4829: ELSE
4830: ozf_utility_pvt.convert_currency (
4831: x_return_status=> l_return_status
4832: ,p_from_currency=> l_temp_rec.approved_in_currency
4833: ,p_to_currency=> l_temp_rec.request_currency
4834: ,p_from_amount=> l_temp_rec.approved_original_amount

Line 4943: ozf_utility_pvt.debug_message('NP 3');

4939: --7030415,
4940: --Added for bug 7425189
4941: IF p_act_budget_rec.justification IN (l_fund_reconc_msg,l_act_bud_cst_msg)
4942: AND p_act_budget_rec.exchange_rate_date IS NOT NULL THEN
4943: ozf_utility_pvt.debug_message('NP 3');
4944: ozf_utility_pvt.convert_currency (
4945: x_return_status=> l_return_status
4946: ,p_from_currency=> l_temp_rec.request_currency
4947: ,p_to_currency=> l_fund_currency_tc

Line 4944: ozf_utility_pvt.convert_currency (

4940: --Added for bug 7425189
4941: IF p_act_budget_rec.justification IN (l_fund_reconc_msg,l_act_bud_cst_msg)
4942: AND p_act_budget_rec.exchange_rate_date IS NOT NULL THEN
4943: ozf_utility_pvt.debug_message('NP 3');
4944: ozf_utility_pvt.convert_currency (
4945: x_return_status=> l_return_status
4946: ,p_from_currency=> l_temp_rec.request_currency
4947: ,p_to_currency=> l_fund_currency_tc
4948: ,p_conv_date=> p_act_budget_rec.exchange_rate_date

Line 4953: ozf_utility_pvt.convert_currency (

4949: ,p_from_amount=> l_temp_rec.request_amount
4950: ,x_to_amount=> l_fund_rec.planned_amt
4951: );
4952: ELSE
4953: ozf_utility_pvt.convert_currency (
4954: x_return_status=> l_return_status
4955: ,p_from_currency=> l_temp_rec.request_currency
4956: ,p_to_currency=> l_fund_currency_tc
4957: ,p_from_amount=> l_temp_rec.request_amount

Line 4985: ozf_utility_pvt.convert_currency (

4981: --Since this conversion is for updating planned/committed amounts.
4982: --In case of utilization the transfer_type is 'UTILIZED'.
4983: --So this part will not be executed.
4984:
4985: ozf_utility_pvt.convert_currency (
4986: x_return_status=> l_return_status
4987: ,p_from_currency=> l_temp_rec.approved_in_currency
4988: ,p_to_currency=> l_fund_currency_tc
4989: ,p_from_amount=> l_temp_rec.approved_original_amount

Line 5019: ozf_utility_pvt.convert_currency (

5015: ELSE
5016: --Added for bug 7425189
5017: IF p_act_budget_rec.justification IN (l_fund_reconc_msg,l_act_bud_cst_msg)
5018: AND p_act_budget_rec.exchange_rate_date IS NOT NULL THEN
5019: ozf_utility_pvt.convert_currency (
5020: x_return_status=> l_return_status
5021: ,p_from_currency=> l_temp_rec.request_currency
5022: ,p_to_currency=> g_universal_currency
5023: ,p_conv_date=> p_act_budget_rec.exchange_rate_date

Line 5028: ozf_utility_pvt.convert_currency (

5024: ,p_from_amount=> l_temp_rec.request_amount
5025: ,x_to_amount=> l_univ_planned_amount
5026: );
5027: ELSE
5028: ozf_utility_pvt.convert_currency (
5029: x_return_status=> l_return_status
5030: ,p_from_currency=> l_temp_rec.request_currency
5031: ,p_to_currency=> g_universal_currency
5032: ,p_from_amount=> l_temp_rec.request_amount

Line 5048: ozf_utility_pvt.convert_currency (

5044: ELSE
5045: --Added for bug 7425189
5046: IF p_act_budget_rec.justification IN (l_fund_reconc_msg,l_act_bud_cst_msg)
5047: AND p_act_budget_rec.exchange_rate_date IS NOT NULL THEN
5048: ozf_utility_pvt.convert_currency (
5049: x_return_status=> l_return_status
5050: ,p_from_currency=> l_temp_rec.request_currency
5051: ,p_to_currency=> g_universal_currency
5052: ,p_conv_date=> p_act_budget_rec.exchange_rate_date

Line 5056: ozf_utility_pvt.debug_message('l_univ_committed_amount '||l_univ_committed_amount);

5052: ,p_conv_date=> p_act_budget_rec.exchange_rate_date
5053: ,p_from_amount=> l_temp_rec.approved_amount
5054: ,x_to_amount=> l_univ_committed_amount
5055: );
5056: ozf_utility_pvt.debug_message('l_univ_committed_amount '||l_univ_committed_amount);
5057: ELSE
5058: ozf_utility_pvt.convert_currency (
5059: x_return_status=> l_return_status
5060: ,p_from_currency=> l_temp_rec.request_currency

Line 5058: ozf_utility_pvt.convert_currency (

5054: ,x_to_amount=> l_univ_committed_amount
5055: );
5056: ozf_utility_pvt.debug_message('l_univ_committed_amount '||l_univ_committed_amount);
5057: ELSE
5058: ozf_utility_pvt.convert_currency (
5059: x_return_status=> l_return_status
5060: ,p_from_currency=> l_temp_rec.request_currency
5061: ,p_to_currency=> g_universal_currency
5062: ,p_from_amount=> l_temp_rec.approved_amount

Line 5075: ozf_utility_pvt.debug_message (

5071: END IF;
5072: END IF;
5073:
5074: IF G_DEBUG THEN
5075: ozf_utility_pvt.debug_message (
5076: ' process_approval(): fund_currency=' || l_fund_currency_tc
5077: || ' request_curr=' || l_temp_rec.request_currency
5078: || ' approved_in_curr=' || l_temp_rec.approved_in_currency
5079: || ' univ_curr=' || g_universal_currency

Line 5081: ozf_utility_pvt.debug_message (

5077: || ' request_curr=' || l_temp_rec.request_currency
5078: || ' approved_in_curr=' || l_temp_rec.approved_in_currency
5079: || ' univ_curr=' || g_universal_currency
5080: );
5081: ozf_utility_pvt.debug_message (
5082: ' in fund currency: planned_amt=' || l_fund_rec.planned_amt
5083: || ' committed_amt=' || l_fund_rec.committed_amt
5084: || ' l_univ_planned_amount=' || l_univ_planned_amount
5085: || ' l_univ_committed_amount=' || l_univ_committed_amount

Line 5149: ozf_utility_pvt.debug_message('******************************************************************');

5145: NVL (l_fund_committed_amount, 0)
5146: - NVL (l_fund_rec.committed_amt, 0);
5147: -- R12: yzhao ozf_object_fund_summary decrease committed amount
5148: IF G_DEBUG THEN
5149: ozf_utility_pvt.debug_message('******************************************************************');
5150: ozf_utility_pvt.debug_message('committed_amt '||l_objfundsum_rec.committed_amt);
5151: ozf_utility_pvt.debug_message('approved_amount '||l_temp_rec.approved_amount);
5152: ozf_utility_pvt.debug_message('plan_curr_committed_amt '||l_objfundsum_rec.plan_curr_committed_amt);
5153: ozf_utility_pvt.debug_message('approved_original_amount '||l_temp_rec.approved_original_amount);

Line 5150: ozf_utility_pvt.debug_message('committed_amt '||l_objfundsum_rec.committed_amt);

5146: - NVL (l_fund_rec.committed_amt, 0);
5147: -- R12: yzhao ozf_object_fund_summary decrease committed amount
5148: IF G_DEBUG THEN
5149: ozf_utility_pvt.debug_message('******************************************************************');
5150: ozf_utility_pvt.debug_message('committed_amt '||l_objfundsum_rec.committed_amt);
5151: ozf_utility_pvt.debug_message('approved_amount '||l_temp_rec.approved_amount);
5152: ozf_utility_pvt.debug_message('plan_curr_committed_amt '||l_objfundsum_rec.plan_curr_committed_amt);
5153: ozf_utility_pvt.debug_message('approved_original_amount '||l_temp_rec.approved_original_amount);
5154: ozf_utility_pvt.debug_message('univ_curr_committed_amt '||l_objfundsum_rec.univ_curr_committed_amt);

Line 5151: ozf_utility_pvt.debug_message('approved_amount '||l_temp_rec.approved_amount);

5147: -- R12: yzhao ozf_object_fund_summary decrease committed amount
5148: IF G_DEBUG THEN
5149: ozf_utility_pvt.debug_message('******************************************************************');
5150: ozf_utility_pvt.debug_message('committed_amt '||l_objfundsum_rec.committed_amt);
5151: ozf_utility_pvt.debug_message('approved_amount '||l_temp_rec.approved_amount);
5152: ozf_utility_pvt.debug_message('plan_curr_committed_amt '||l_objfundsum_rec.plan_curr_committed_amt);
5153: ozf_utility_pvt.debug_message('approved_original_amount '||l_temp_rec.approved_original_amount);
5154: ozf_utility_pvt.debug_message('univ_curr_committed_amt '||l_objfundsum_rec.univ_curr_committed_amt);
5155: ozf_utility_pvt.debug_message('l_univ_committed_amount '||l_univ_committed_amount);

Line 5152: ozf_utility_pvt.debug_message('plan_curr_committed_amt '||l_objfundsum_rec.plan_curr_committed_amt);

5148: IF G_DEBUG THEN
5149: ozf_utility_pvt.debug_message('******************************************************************');
5150: ozf_utility_pvt.debug_message('committed_amt '||l_objfundsum_rec.committed_amt);
5151: ozf_utility_pvt.debug_message('approved_amount '||l_temp_rec.approved_amount);
5152: ozf_utility_pvt.debug_message('plan_curr_committed_amt '||l_objfundsum_rec.plan_curr_committed_amt);
5153: ozf_utility_pvt.debug_message('approved_original_amount '||l_temp_rec.approved_original_amount);
5154: ozf_utility_pvt.debug_message('univ_curr_committed_amt '||l_objfundsum_rec.univ_curr_committed_amt);
5155: ozf_utility_pvt.debug_message('l_univ_committed_amount '||l_univ_committed_amount);
5156: END IF;

Line 5153: ozf_utility_pvt.debug_message('approved_original_amount '||l_temp_rec.approved_original_amount);

5149: ozf_utility_pvt.debug_message('******************************************************************');
5150: ozf_utility_pvt.debug_message('committed_amt '||l_objfundsum_rec.committed_amt);
5151: ozf_utility_pvt.debug_message('approved_amount '||l_temp_rec.approved_amount);
5152: ozf_utility_pvt.debug_message('plan_curr_committed_amt '||l_objfundsum_rec.plan_curr_committed_amt);
5153: ozf_utility_pvt.debug_message('approved_original_amount '||l_temp_rec.approved_original_amount);
5154: ozf_utility_pvt.debug_message('univ_curr_committed_amt '||l_objfundsum_rec.univ_curr_committed_amt);
5155: ozf_utility_pvt.debug_message('l_univ_committed_amount '||l_univ_committed_amount);
5156: END IF;
5157: l_objfundsum_rec.committed_amt := NVL(l_objfundsum_rec.committed_amt, 0)

Line 5154: ozf_utility_pvt.debug_message('univ_curr_committed_amt '||l_objfundsum_rec.univ_curr_committed_amt);

5150: ozf_utility_pvt.debug_message('committed_amt '||l_objfundsum_rec.committed_amt);
5151: ozf_utility_pvt.debug_message('approved_amount '||l_temp_rec.approved_amount);
5152: ozf_utility_pvt.debug_message('plan_curr_committed_amt '||l_objfundsum_rec.plan_curr_committed_amt);
5153: ozf_utility_pvt.debug_message('approved_original_amount '||l_temp_rec.approved_original_amount);
5154: ozf_utility_pvt.debug_message('univ_curr_committed_amt '||l_objfundsum_rec.univ_curr_committed_amt);
5155: ozf_utility_pvt.debug_message('l_univ_committed_amount '||l_univ_committed_amount);
5156: END IF;
5157: l_objfundsum_rec.committed_amt := NVL(l_objfundsum_rec.committed_amt, 0)
5158: - NVL (l_temp_rec.approved_amount, 0);

Line 5155: ozf_utility_pvt.debug_message('l_univ_committed_amount '||l_univ_committed_amount);

5151: ozf_utility_pvt.debug_message('approved_amount '||l_temp_rec.approved_amount);
5152: ozf_utility_pvt.debug_message('plan_curr_committed_amt '||l_objfundsum_rec.plan_curr_committed_amt);
5153: ozf_utility_pvt.debug_message('approved_original_amount '||l_temp_rec.approved_original_amount);
5154: ozf_utility_pvt.debug_message('univ_curr_committed_amt '||l_objfundsum_rec.univ_curr_committed_amt);
5155: ozf_utility_pvt.debug_message('l_univ_committed_amount '||l_univ_committed_amount);
5156: END IF;
5157: l_objfundsum_rec.committed_amt := NVL(l_objfundsum_rec.committed_amt, 0)
5158: - NVL (l_temp_rec.approved_amount, 0);
5159: l_objfundsum_rec.plan_curr_committed_amt := NVL(l_objfundsum_rec.plan_curr_committed_amt, 0)

Line 5182: ozf_utility_pvt.debug_message ('bef update fund ');

5178: -- R12: yzhao END ozf_object_fund_summary decrease committed amount
5179: END IF;
5180:
5181: IF G_DEBUG THEN
5182: ozf_utility_pvt.debug_message ('bef update fund ');
5183: END IF;
5184:
5185: --Added for bug 7425189, use these 3 columns in fund API to disttinguish the
5186: --call from reconcile API.

Line 5249: ozf_utility_pvt.debug_message('committed_amt '||l_objfundsum_rec.committed_amt);

5245: --Added for bug 7425189, call this private API, only meant for budget reconcile.
5246: IF p_act_budget_rec.justification IN (l_fund_reconc_msg,l_act_bud_cst_msg)
5247: AND p_act_budget_rec.exchange_rate_date IS NOT NULL THEN
5248: IF G_DEBUG THEN
5249: ozf_utility_pvt.debug_message('committed_amt '||l_objfundsum_rec.committed_amt);
5250: ozf_utility_pvt.debug_message('plan_curr_committed_amt '||l_objfundsum_rec.plan_curr_committed_amt);
5251: ozf_utility_pvt.debug_message('univ_curr_committed_amt '||l_objfundsum_rec.univ_curr_committed_amt);
5252: ozf_utility_pvt.debug_message('******************************************************************');
5253: END IF;

Line 5250: ozf_utility_pvt.debug_message('plan_curr_committed_amt '||l_objfundsum_rec.plan_curr_committed_amt);

5246: IF p_act_budget_rec.justification IN (l_fund_reconc_msg,l_act_bud_cst_msg)
5247: AND p_act_budget_rec.exchange_rate_date IS NOT NULL THEN
5248: IF G_DEBUG THEN
5249: ozf_utility_pvt.debug_message('committed_amt '||l_objfundsum_rec.committed_amt);
5250: ozf_utility_pvt.debug_message('plan_curr_committed_amt '||l_objfundsum_rec.plan_curr_committed_amt);
5251: ozf_utility_pvt.debug_message('univ_curr_committed_amt '||l_objfundsum_rec.univ_curr_committed_amt);
5252: ozf_utility_pvt.debug_message('******************************************************************');
5253: END IF;
5254: update_reconcile_objfundsum(

Line 5251: ozf_utility_pvt.debug_message('univ_curr_committed_amt '||l_objfundsum_rec.univ_curr_committed_amt);

5247: AND p_act_budget_rec.exchange_rate_date IS NOT NULL THEN
5248: IF G_DEBUG THEN
5249: ozf_utility_pvt.debug_message('committed_amt '||l_objfundsum_rec.committed_amt);
5250: ozf_utility_pvt.debug_message('plan_curr_committed_amt '||l_objfundsum_rec.plan_curr_committed_amt);
5251: ozf_utility_pvt.debug_message('univ_curr_committed_amt '||l_objfundsum_rec.univ_curr_committed_amt);
5252: ozf_utility_pvt.debug_message('******************************************************************');
5253: END IF;
5254: update_reconcile_objfundsum(
5255: p_api_version => 1.0,

Line 5252: ozf_utility_pvt.debug_message('******************************************************************');

5248: IF G_DEBUG THEN
5249: ozf_utility_pvt.debug_message('committed_amt '||l_objfundsum_rec.committed_amt);
5250: ozf_utility_pvt.debug_message('plan_curr_committed_amt '||l_objfundsum_rec.plan_curr_committed_amt);
5251: ozf_utility_pvt.debug_message('univ_curr_committed_amt '||l_objfundsum_rec.univ_curr_committed_amt);
5252: ozf_utility_pvt.debug_message('******************************************************************');
5253: END IF;
5254: update_reconcile_objfundsum(
5255: p_api_version => 1.0,
5256: p_init_msg_list => Fnd_Api.G_FALSE,

Line 5292: ozf_utility_pvt.debug_message ( g_package_name

5288: END IF; -- for fund transfer flag check
5289:
5290: x_act_budget_rec := l_temp_rec;
5291: IF G_DEBUG THEN
5292: ozf_utility_pvt.debug_message ( g_package_name
5293: || '.'
5294: || l_api_name
5295: || ': end');
5296: END IF;

Line 5371: ozf_utility_pvt.convert_currency (

5367: -- is stored in the table as a value based
5368: -- on the transactional currency, so the
5369: -- request amount must also be based on the
5370: -- same currency.
5371: ozf_utility_pvt.convert_currency (
5372: x_return_status=> l_return_status
5373: ,p_from_currency=> l_temp_rec.request_currency
5374: ,p_to_currency=> l_fund_currency_tc
5375: ,p_from_amount=> l_temp_rec.request_amount

Line 5409: ozf_utility_pvt.convert_currency (

5405: l_univ_planned_amount := l_temp_rec.request_amount;
5406: ELSIF g_universal_currency = l_fund_currency_tc THEN
5407: l_univ_planned_amount := l_fund_rec.planned_amt;
5408: ELSE
5409: ozf_utility_pvt.convert_currency (
5410: x_return_status=> l_return_status
5411: ,p_from_currency=> l_temp_rec.request_currency
5412: ,p_to_currency=> g_universal_currency
5413: ,p_from_amount=> l_temp_rec.request_amount

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

5537:
5538: SAVEPOINT create_child_act_budget;
5539:
5540: IF G_DEBUG THEN
5541: ozf_utility_pvt.debug_message ( l_full_name || ': start');
5542: END IF;
5543:
5544: x_return_status := fnd_api.g_ret_sts_success;
5545:

Line 5571: ozf_utility_pvt.debug_message ( ': l_total_amount: ' || l_total_amount );

5567: l_act_budgets_rec.parent_source_id := l_obj_id;
5568: l_act_budgets_rec.parent_act_budget_id := p_act_budgets_rec.activity_budget_id;
5569:
5570: IF G_DEBUG THEN
5571: ozf_utility_pvt.debug_message ( ': l_total_amount: ' || l_total_amount );
5572: END IF;
5573:
5574: OPEN c_total_acct_amt(l_obj_id);
5575: FETCH c_total_acct_amt INTO l_acctd_amount;

Line 5582: l_amount := ozf_utility_pvt.currround(l_budget_util_rec.total_acctd_amount / l_acctd_amount * l_total_amount, l_obj_currency);

5578: FOR l_budget_util_rec IN c_parent_source(l_obj_id) LOOP
5579:
5580: EXIT WHEN c_parent_source%NOTFOUND;
5581:
5582: l_amount := ozf_utility_pvt.currround(l_budget_util_rec.total_acctd_amount / l_acctd_amount * l_total_amount, l_obj_currency);
5583:
5584: l_amount_remaining :=l_amount_remaining - l_amount;
5585:
5586: IF l_budget_util_rec.fund_currency <> l_obj_currency THEN

Line 5589: ozf_utility_pvt.convert_currency (

5585:
5586: IF l_budget_util_rec.fund_currency <> l_obj_currency THEN
5587: --Added for bug 7030415, This code gets executed when offer sources from Campaign.
5588:
5589: ozf_utility_pvt.convert_currency (
5590: x_return_status=> x_return_status
5591: ,p_from_currency=> l_obj_currency
5592: ,p_to_currency=> l_budget_util_rec.fund_currency
5593: ,p_conv_type=> p_exchange_rate_type

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

5599: l_converted_amt := l_amount;
5600: END IF;
5601:
5602: IF G_DEBUG THEN
5603: ozf_utility_pvt.debug_message ( l_full_name || ': l_amount: ' || l_amount);
5604: ozf_utility_pvt.debug_message ( l_full_name || ': l_converted_amt' || l_converted_amt);
5605: END IF;
5606:
5607: IF l_act_budgets_rec.transfer_type = 'REQUEST' THEN

Line 5604: ozf_utility_pvt.debug_message ( l_full_name || ': l_converted_amt' || l_converted_amt);

5600: END IF;
5601:
5602: IF G_DEBUG THEN
5603: ozf_utility_pvt.debug_message ( l_full_name || ': l_amount: ' || l_amount);
5604: ozf_utility_pvt.debug_message ( l_full_name || ': l_converted_amt' || l_converted_amt);
5605: END IF;
5606:
5607: IF l_act_budgets_rec.transfer_type = 'REQUEST' THEN
5608: l_act_budgets_rec.budget_source_type := 'FUND';

Line 5630: ozf_utility_pvt.get_default_user_status (

5626:
5627: l_act_budgets_rec.status_code := 'APPROVED';
5628: l_act_budgets_rec.request_date := SYSDATE;
5629: l_act_budgets_rec.user_status_id :=
5630: ozf_utility_pvt.get_default_user_status (
5631: 'OZF_BUDGETSOURCE_STATUS'
5632: ,l_act_budgets_rec.status_code
5633: );
5634: l_act_budgets_rec.approval_date := SYSDATE;

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

5631: 'OZF_BUDGETSOURCE_STATUS'
5632: ,l_act_budgets_rec.status_code
5633: );
5634: l_act_budgets_rec.approval_date := SYSDATE;
5635: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
5636: l_act_budgets_rec.requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
5637:
5638: ozf_actbudgets_pvt.create_act_budgets (
5639: p_api_version=> l_api_version

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

5632: ,l_act_budgets_rec.status_code
5633: );
5634: l_act_budgets_rec.approval_date := SYSDATE;
5635: l_act_budgets_rec.approver_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
5636: l_act_budgets_rec.requester_id := ozf_utility_pvt.get_resource_id (fnd_global.user_id);
5637:
5638: ozf_actbudgets_pvt.create_act_budgets (
5639: p_api_version=> l_api_version
5640: ,x_return_status=> l_return_status

Line 5678: ozf_utility_pvt.debug_message ( l_full_name

5674: );
5675:
5676:
5677: IF G_DEBUG THEN
5678: ozf_utility_pvt.debug_message ( l_full_name
5679: || ': end');
5680: END IF;
5681:
5682: EXCEPTION

Line 5759: ozf_utility_pvt.convert_currency (

5755: -- fill in amount 2 from amount 1
5756: IF p_currency_1 = p_currency_2 THEN
5757: x_amount_2 := p_amount_1;
5758: ELSE
5759: ozf_utility_pvt.convert_currency (
5760: x_return_status=> l_return_status
5761: ,p_from_currency=> p_currency_1
5762: ,p_to_currency=> p_currency_2
5763: ,p_conv_date=> p_conv_date

Line 5780: ozf_utility_pvt.convert_currency (

5776: -- fill in amount in universal currency from amount 1
5777: IF g_universal_currency = p_currency_1 THEN
5778: x_amount_3 := p_amount_1;
5779: ELSE
5780: ozf_utility_pvt.convert_currency (
5781: x_return_status=> l_return_status
5782: ,p_from_currency=> p_currency_1
5783: ,p_to_currency=> g_universal_currency
5784: ,p_conv_date=> p_conv_date

Line 5801: ozf_utility_pvt.convert_currency (

5797: -- fill in amount 1 from amount 2
5798: IF p_currency_1 = p_currency_2 THEN
5799: x_amount_1 := p_amount_2;
5800: ELSE
5801: ozf_utility_pvt.convert_currency (
5802: x_return_status=> l_return_status
5803: ,p_from_currency=> p_currency_2
5804: ,p_to_currency=> p_currency_1
5805: ,p_conv_date=> p_conv_date

Line 5821: ozf_utility_pvt.convert_currency (

5817: -- fill in amount in universal currency from amount 2
5818: IF g_universal_currency = p_currency_2 THEN
5819: x_amount_3 := p_amount_2;
5820: ELSE
5821: ozf_utility_pvt.convert_currency (
5822: x_return_status=> l_return_status
5823: ,p_from_currency=> p_currency_2
5824: ,p_to_currency=> g_universal_currency
5825: ,p_conv_date=> p_conv_date

Line 5877: ozf_utility_pvt.debug_message('Now updating objfundsum_id: '||p_objfundsum_rec.objfundsum_id);

5873:
5874: BEGIN
5875:
5876: IF (G_DEBUG) THEN
5877: ozf_utility_pvt.debug_message('Now updating objfundsum_id: '||p_objfundsum_rec.objfundsum_id);
5878: END IF;
5879:
5880: SAVEPOINT sp_update_reconcile_objfundsum;
5881:

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

5879:
5880: SAVEPOINT sp_update_reconcile_objfundsum;
5881:
5882: IF (G_DEBUG) THEN
5883: ozf_utility_pvt.debug_message(l_full_name||': start');
5884: END IF;
5885:
5886: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
5887: Fnd_Msg_Pub.Initialize;

Line 5901: ozf_utility_pvt.debug_message(l_full_name ||': validate');

5897:
5898: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5899:
5900: IF (G_DEBUG) THEN
5901: ozf_utility_pvt.debug_message(l_full_name ||': validate');
5902: END IF;
5903:
5904: -- replace g_miss_char/num/date with current column values
5905: OZF_OBJFUNDSUM_PVT.Complete_objfundsum_Rec(p_objfundsum_rec, l_objfundsum_rec);

Line 6080: ozf_utility_pvt.debug_message(l_full_name ||': update object fund summary Table');

6076: END IF;
6077:
6078:
6079: IF (G_DEBUG) THEN
6080: ozf_utility_pvt.debug_message(l_full_name ||': update object fund summary Table');
6081: END IF;
6082:
6083: UPDATE ozf_object_fund_summary
6084: SET object_version_number= object_version_number + 1,

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

6144: p_encoded => Fnd_Api.G_FALSE
6145: );
6146:
6147: IF (G_DEBUG) THEN
6148: ozf_utility_pvt.debug_message(l_full_name ||': end');
6149: END IF;
6150:
6151:
6152: EXCEPTION