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

Line 28: ozf_utility_pvt.debug_message(' utilization Id is :'||p_object_id );

24: l_parameter_list := WF_PARAMETER_LIST_T();
25:
26:
27: IF G_DEBUG THEN
28: ozf_utility_pvt.debug_message(' utilization Id is :'||p_object_id );
29: END IF;
30:
31: wf_event.AddParameterToList(p_name => 'P_UTIL_ID',
32: p_value => p_object_id,

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

32: p_value => p_object_id,
33: p_parameterlist => l_parameter_list);
34:
35: IF G_DEBUG THEN
36: ozf_utility_pvt.debug_message('Item Key is :'||l_item_key);
37: END IF;
38:
39: wf_event.raise( p_event_name =>'oracle.apps.ozf.fund.adjustment.approval',
40: p_event_key => l_item_key,

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

43:
44: EXCEPTION
45: WHEN OTHERS THEN
46: RAISE Fnd_Api.g_exc_error;
47: ozf_utility_pvt.debug_message('Exception in raising business event');
48: END;
49:
50:
51: ---------------------------------------------------------------------

Line 97: lx_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;

93: ,p_create_gl_entry IN VARCHAR2 := fnd_api.g_false
94: ,p_utilization_rec IN utilization_rec_type
95: ,x_utilization_id OUT NOCOPY NUMBER
96: ) IS
97: lx_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;
98: l_use_fund_staging_tables VARCHAR2(1):= 'F';
99: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;
100: lx_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
101: l_batch_type VARCHAR2(30);

Line 99: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;

95: ,x_utilization_id OUT NOCOPY NUMBER
96: ) IS
97: lx_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;
98: l_use_fund_staging_tables VARCHAR2(1):= 'F';
99: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;
100: lx_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
101: l_batch_type VARCHAR2(30);
102: BEGIN
103: create_utilization (

Line 100: lx_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;

96: ) IS
97: lx_ozf_act_budgets_tbl OZF_UTILITY_PVT.ozf_act_budgets_table;
98: l_use_fund_staging_tables VARCHAR2(1):= 'F';
99: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype;
100: lx_ozf_funds_new_tbl OZF_UTILITY_PVT.ozf_funds_table;
101: l_batch_type VARCHAR2(30);
102: BEGIN
103: create_utilization (
104: p_api_version => p_api_version

Line 169: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table

165: ,p_utilization_rec IN utilization_rec_type
166: ,x_utilization_id OUT NOCOPY NUMBER
167: ,p_batch_type IN VARCHAR2
168: ,p_use_fund_staging_tables IN VARCHAR2
169: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
170: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
171: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER - 9614703
172: ) IS
173: l_api_version CONSTANT NUMBER := 1.0;

Line 170: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype

166: ,x_utilization_id OUT NOCOPY NUMBER
167: ,p_batch_type IN VARCHAR2
168: ,p_use_fund_staging_tables IN VARCHAR2
169: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
170: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
171: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER - 9614703
172: ) IS
173: l_api_version CONSTANT NUMBER := 1.0;
174: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Utilization';

Line 171: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER - 9614703

167: ,p_batch_type IN VARCHAR2
168: ,p_use_fund_staging_tables IN VARCHAR2
169: ,px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table
170: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype
171: ,px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table -- For TPA Parallel Execution ER - 9614703
172: ) IS
173: l_api_version CONSTANT NUMBER := 1.0;
174: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Utilization';
175: l_full_name CONSTANT VARCHAR2 (60) := g_pkg_name

Line 494: l_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype := NULL;

490: l_qlf_id NUMBER;
491: l_fund_reconc_msg VARCHAR2(4000);
492: l_act_bud_cst_msg VARCHAR2(4000);
493:
494: l_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype := NULL;
495: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype := px_ozf_funds_old_rectype;
496:
497: l_use_fund_staging_tables VARCHAR2(1):= p_use_fund_staging_tables;
498: l_request_id NUMBER;

Line 495: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype := px_ozf_funds_old_rectype;

491: l_fund_reconc_msg VARCHAR2(4000);
492: l_act_bud_cst_msg VARCHAR2(4000);
493:
494: l_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype := NULL;
495: lx_ozf_funds_old_rectype OZF_UTILITY_PVT.ozf_funds_all_b_rectype := px_ozf_funds_old_rectype;
496:
497: l_use_fund_staging_tables VARCHAR2(1):= p_use_fund_staging_tables;
498: l_request_id NUMBER;
499: l_operation VARCHAR2(6);

Line 506: ozf_utility_pvt.debug_message ( l_full_name

502: BEGIN
503: --------------------- initialize -----------------------
504: SAVEPOINT create_utilization;
505: IF G_DEBUG THEN
506: ozf_utility_pvt.debug_message ( l_full_name
507: || ': start' || p_utilization_rec.utilization_type);
508: END IF;
509:
510: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 522: ozf_utility_pvt.debug_message (

518: x_return_status := fnd_api.g_ret_sts_success;
519:
520: ----------------------- validate -----------------------
521: IF G_DEBUG THEN
522: ozf_utility_pvt.debug_message (
523: l_full_name
524: || ': validate'
525: || l_utilization_rec.adjustment_type_id
526: );

Line 541: ozf_utility_pvt.debug_message (

537: CLOSE c_adj_type;
538: END IF;
539:
540: IF G_DEBUG THEN
541: ozf_utility_pvt.debug_message (
542: l_full_name
543: || ': adjustment_type: '
544: || l_utilization_rec.adjustment_type
545: );

Line 574: ozf_utility_pvt.debug_message ( l_full_name || ': insert');

570: THEN
571: */
572: -------------------------- insert --------------------------
573: IF G_DEBUG THEN
574: ozf_utility_pvt.debug_message ( l_full_name || ': insert');
575: ozf_utility_pvt.debug_message ('currency_code '||l_utilization_rec.currency_code);
576: ozf_utility_pvt.debug_message ('plan_currency_code '||l_utilization_rec.plan_currency_code);
577: END IF;
578:

Line 575: ozf_utility_pvt.debug_message ('currency_code '||l_utilization_rec.currency_code);

571: */
572: -------------------------- insert --------------------------
573: IF G_DEBUG THEN
574: ozf_utility_pvt.debug_message ( l_full_name || ': insert');
575: ozf_utility_pvt.debug_message ('currency_code '||l_utilization_rec.currency_code);
576: ozf_utility_pvt.debug_message ('plan_currency_code '||l_utilization_rec.plan_currency_code);
577: END IF;
578:
579: /* IF l_utilization_rec.adjustment_type IN ('DECREASE_EARNED', 'DECREASE_COMM_EARNED') THEN

Line 576: ozf_utility_pvt.debug_message ('plan_currency_code '||l_utilization_rec.plan_currency_code);

572: -------------------------- insert --------------------------
573: IF G_DEBUG THEN
574: ozf_utility_pvt.debug_message ( l_full_name || ': insert');
575: ozf_utility_pvt.debug_message ('currency_code '||l_utilization_rec.currency_code);
576: ozf_utility_pvt.debug_message ('plan_currency_code '||l_utilization_rec.plan_currency_code);
577: END IF;
578:
579: /* IF l_utilization_rec.adjustment_type IN ('DECREASE_EARNED', 'DECREASE_COMM_EARNED') THEN
580: l_utilization_rec.amount := -l_utilization_rec.amount;

Line 603: l_utilization_rec.amount := ozf_utility_pvt.currround(l_utilization_rec.amount , l_utilization_rec.currency_code); -- round amount to fix bug 3615680;

599: IF l_utilization_rec.amount = 0 THEN
600: l_utilization_rec.acctd_amount := 0;
601: ELSE
602:
603: l_utilization_rec.amount := ozf_utility_pvt.currround(l_utilization_rec.amount , l_utilization_rec.currency_code); -- round amount to fix bug 3615680;
604: l_utilization_rec.plan_curr_amount := ozf_utility_pvt.currround(l_utilization_rec.plan_curr_amount , l_utilization_rec.plan_currency_code);
605: END IF;
606:
607:

Line 604: l_utilization_rec.plan_curr_amount := ozf_utility_pvt.currround(l_utilization_rec.plan_curr_amount , l_utilization_rec.plan_currency_code);

600: l_utilization_rec.acctd_amount := 0;
601: ELSE
602:
603: l_utilization_rec.amount := ozf_utility_pvt.currround(l_utilization_rec.amount , l_utilization_rec.currency_code); -- round amount to fix bug 3615680;
604: l_utilization_rec.plan_curr_amount := ozf_utility_pvt.currround(l_utilization_rec.plan_curr_amount , l_utilization_rec.plan_currency_code);
605: END IF;
606:
607:
608: IF G_DEBUG THEN

Line 609: ozf_utility_pvt.debug_message ( l_api_name

605: END IF;
606:
607:
608: IF G_DEBUG THEN
609: ozf_utility_pvt.debug_message ( l_api_name
610: || ': ozf_funds_utilized_pvt create_utilization org_id passed in is'
611: || l_utilization_rec.org_id);
612: ozf_utility_pvt.debug_message ( l_api_name
613: || ': ozf_funds_utilized_pvt create_utilization plan amount is'

Line 612: ozf_utility_pvt.debug_message ( l_api_name

608: IF G_DEBUG THEN
609: ozf_utility_pvt.debug_message ( l_api_name
610: || ': ozf_funds_utilized_pvt create_utilization org_id passed in is'
611: || l_utilization_rec.org_id);
612: ozf_utility_pvt.debug_message ( l_api_name
613: || ': ozf_funds_utilized_pvt create_utilization plan amount is'
614: || l_utilization_rec.plan_curr_amount);
615: END IF;
616:

Line 632: ozf_utility_pvt.debug_message('l_utilization_rec.site_use_id '|| l_utilization_rec.site_use_id );

628:
629: IF l_utilization_rec.site_use_id IS NOT NULL THEN
630:
631: IF G_DEBUG THEN
632: ozf_utility_pvt.debug_message('l_utilization_rec.site_use_id '|| l_utilization_rec.site_use_id );
633: END IF;
634:
635: OPEN c_cust_acct_org_id(l_utilization_rec.site_use_id);
636: FETCH c_cust_acct_org_id INTO l_org_id ;

Line 641: ozf_utility_pvt.debug_message('l_utilization_rec.org_id '|| l_utilization_rec.org_id);

637: CLOSE c_cust_acct_org_id;
638: l_utilization_rec.org_id := l_org_id;
639:
640: IF G_DEBUG THEN
641: ozf_utility_pvt.debug_message('l_utilization_rec.org_id '|| l_utilization_rec.org_id);
642: END IF;
643: END IF;
644:
645: IF l_utilization_rec.org_id IS NULL THEN

Line 649: ozf_utility_pvt.debug_message('l_utilization_rec.plan_type '|| l_utilization_rec.plan_type );

645: IF l_utilization_rec.org_id IS NULL THEN
646: IF l_utilization_rec.plan_type IS NOT NULL AND l_utilization_rec.plan_type = 'OFFR' THEN
647:
648: IF G_DEBUG THEN
649: ozf_utility_pvt.debug_message('l_utilization_rec.plan_type '|| l_utilization_rec.plan_type );
650: ozf_utility_pvt.debug_message('l_utilization_rec.plan_id '|| l_utilization_rec.plan_id );
651: END IF;
652:
653: OPEN c_offer_org_id(l_utilization_rec.plan_id);

Line 650: ozf_utility_pvt.debug_message('l_utilization_rec.plan_id '|| l_utilization_rec.plan_id );

646: IF l_utilization_rec.plan_type IS NOT NULL AND l_utilization_rec.plan_type = 'OFFR' THEN
647:
648: IF G_DEBUG THEN
649: ozf_utility_pvt.debug_message('l_utilization_rec.plan_type '|| l_utilization_rec.plan_type );
650: ozf_utility_pvt.debug_message('l_utilization_rec.plan_id '|| l_utilization_rec.plan_id );
651: END IF;
652:
653: OPEN c_offer_org_id(l_utilization_rec.plan_id);
654: FETCH c_offer_org_id INTO l_org_id ;

Line 659: ozf_utility_pvt.debug_message('l_utilization_rec.org_id '|| l_utilization_rec.org_id);

655: CLOSE c_offer_org_id;
656: l_utilization_rec.org_id := l_org_id;
657:
658: IF G_DEBUG THEN
659: ozf_utility_pvt.debug_message('l_utilization_rec.org_id '|| l_utilization_rec.org_id);
660: END IF;
661: END IF;
662: END IF;
663:

Line 668: ozf_utility_pvt.debug_message('l_utilization_rec.adjustment_type_id '|| l_utilization_rec.adjustment_type_id);

664: IF l_utilization_rec.org_id IS NULL THEN
665: IF l_utilization_rec.adjustment_type_id IS NOT NULL THEN
666:
667: IF G_DEBUG THEN
668: ozf_utility_pvt.debug_message('l_utilization_rec.adjustment_type_id '|| l_utilization_rec.adjustment_type_id);
669: END IF;
670:
671: OPEN c_adj_org_id(l_utilization_rec.adjustment_type_id);
672: FETCH c_adj_org_id INTO l_org_id ;

Line 677: ozf_utility_pvt.debug_message('l_utilization_rec.org_id '|| l_utilization_rec.org_id);

673: CLOSE c_adj_org_id;
674: l_utilization_rec.org_id := l_org_id;
675:
676: IF G_DEBUG THEN
677: ozf_utility_pvt.debug_message('l_utilization_rec.org_id '|| l_utilization_rec.org_id);
678: END IF;
679: END IF;
680: END IF;
681: END IF;

Line 684: ozf_utility_pvt.get_object_org_ledger(p_object_type => l_utilization_rec.plan_type

680: END IF;
681: END IF;
682: IF l_utilization_rec.org_id IS NULL THEN
683: -- R12 yzhao: org_id is required for ozf_funds_utilized_all. get offer's org_id, otherwise user's default org
684: ozf_utility_pvt.get_object_org_ledger(p_object_type => l_utilization_rec.plan_type
685: ,p_object_id => l_utilization_rec.plan_id
686: ,x_org_id => l_utilization_rec.org_id
687: ,x_ledger_id => l_ledger_id
688: ,x_return_status => l_return_status);

Line 705: ozf_utility_pvt.debug_message ( l_api_name

701: p_ledger_name => l_ledger_name
702: );
703: END IF;
704: IF G_DEBUG THEN
705: ozf_utility_pvt.debug_message ( l_api_name
706: || ': create_utilization final org_id = '
707: || l_utilization_rec.org_id
708: || ' ledger_id='
709: || l_ledger_id);

Line 731: ozf_utility_pvt.debug_message ( l_api_name

727: l_utilization_rec.component_type IN ('CAMP', 'CSCH', 'EVEO', 'EVEH') THEN
728: l_utilization_rec.org_id := -3116; -- marketing object is not org aware
729: ELSE
730: IF G_DEBUG THEN
731: ozf_utility_pvt.debug_message ( l_api_name
732: || ': create_utilization ledger not found for '
733: || l_utilization_rec.plan_type
734: || ' id('
735: || l_utilization_rec.plan_id);

Line 749: ozf_utility_pvt.debug_message ( l_full_name

745: END IF;
746: ELSE
747:
748: IF G_DEBUG THEN
749: ozf_utility_pvt.debug_message ( l_full_name
750: || ' l_utilization_rec.exchange_rate_date1: ' || l_utilization_rec.exchange_rate_date);
751: END IF;
752:
753: --nirprasa for bug 7425189, adjustment_desc is populated with justification column

Line 758: ozf_utility_pvt.calculate_functional_currency (

754: --of act_budgets recocrd.
755: IF l_utilization_rec.adjustment_desc IN (l_fund_reconc_msg,l_act_bud_cst_msg)
756: AND l_utilization_rec.exchange_rate_date IS NOT NULL THEN
757: l_utilization_rec.exchange_rate_type := NULL;
758: ozf_utility_pvt.calculate_functional_currency (
759: p_from_amount => l_utilization_rec.plan_curr_amount --nirprasa,ER 8399134 (replace amount by plan_curr_amount)
760: ,p_conv_date => l_utilization_rec.exchange_rate_date
761: ,p_tc_currency_code => l_utilization_rec.plan_currency_code
762: ,p_ledger_id => l_ledger_id

Line 771: ozf_utility_pvt.calculate_functional_currency (

767: ,x_exchange_rate => l_utilization_rec.exchange_rate
768: ,x_return_status => l_return_status
769: );
770: ELSE
771: ozf_utility_pvt.calculate_functional_currency (
772: --nirprasa,ER 8399134 replaced amount by plan_curr_amount, currency_code
773: --by plan_currency_code. Pass exchange_rate_date, to be used for decrease earned adjustment flows
774: p_from_amount => l_utilization_rec.plan_curr_amount
775: ,p_conv_date => l_utilization_rec.exchange_rate_date

Line 813: ozf_utility_pvt.debug_message('l_utilization_rec.amount '|| l_utilization_rec.amount);

809: AND l_utilization_rec.exchange_rate_date IS NOT NULL
810: AND l_utilization_rec.orig_utilization_id IS NOT NULL THEN
811:
812: IF G_DEBUG THEN
813: ozf_utility_pvt.debug_message('l_utilization_rec.amount '|| l_utilization_rec.amount);
814: ozf_utility_pvt.debug_message('l_plan_curr_amount 1 '||l_plan_curr_amount);
815: END IF;
816:
817:

Line 814: ozf_utility_pvt.debug_message('l_plan_curr_amount 1 '||l_plan_curr_amount);

810: AND l_utilization_rec.orig_utilization_id IS NOT NULL THEN
811:
812: IF G_DEBUG THEN
813: ozf_utility_pvt.debug_message('l_utilization_rec.amount '|| l_utilization_rec.amount);
814: ozf_utility_pvt.debug_message('l_plan_curr_amount 1 '||l_plan_curr_amount);
815: END IF;
816:
817:
818:

Line 824: ozf_utility_pvt.debug_message('l_plan_curr_amount 2 '||l_plan_curr_amount);

820: FETCH c_plan_curr_amount INTO l_plan_curr_amount,l_plan_curr_amount_remaining;
821: CLOSE c_plan_curr_amount;
822:
823: IF G_DEBUG THEN
824: ozf_utility_pvt.debug_message('l_plan_curr_amount 2 '||l_plan_curr_amount);
825: END IF;
826:
827: IF l_plan_curr_amount_remaining < l_plan_curr_amount THEN
828: l_plan_curr_amount := nvl(l_plan_curr_amount_remaining,0);

Line 833: ozf_utility_pvt.debug_message('l_plan_curr_amount 3 '||l_plan_curr_amount);

829: END IF;
830:
831: l_plan_curr_amount := nvl(-l_plan_curr_amount,0);
832: IF G_DEBUG THEN
833: ozf_utility_pvt.debug_message('l_plan_curr_amount 3 '||l_plan_curr_amount);
834: END IF;
835:
836:
837: ELSE

Line 844: ozf_utility_pvt.debug_message(' plan_curr_amount '|| p_utilization_rec.plan_curr_amount);

840: IF p_utilization_rec.plan_curr_amount IS NULL
841: OR p_utilization_rec.plan_curr_amount = fnd_api.g_miss_num THEN
842:
843: IF G_DEBUG THEN
844: ozf_utility_pvt.debug_message(' plan_curr_amount '|| p_utilization_rec.plan_curr_amount);
845: ozf_utility_pvt.debug_message(' plan_currency_code '|| l_utilization_rec.plan_currency_code);
846: ozf_utility_pvt.debug_message(' currency_code '|| l_utilization_rec.currency_code);
847: END IF;
848: ozf_utility_pvt.convert_currency (

Line 845: ozf_utility_pvt.debug_message(' plan_currency_code '|| l_utilization_rec.plan_currency_code);

841: OR p_utilization_rec.plan_curr_amount = fnd_api.g_miss_num THEN
842:
843: IF G_DEBUG THEN
844: ozf_utility_pvt.debug_message(' plan_curr_amount '|| p_utilization_rec.plan_curr_amount);
845: ozf_utility_pvt.debug_message(' plan_currency_code '|| l_utilization_rec.plan_currency_code);
846: ozf_utility_pvt.debug_message(' currency_code '|| l_utilization_rec.currency_code);
847: END IF;
848: ozf_utility_pvt.convert_currency (
849: p_from_currency => l_utilization_rec.currency_code

Line 846: ozf_utility_pvt.debug_message(' currency_code '|| l_utilization_rec.currency_code);

842:
843: IF G_DEBUG THEN
844: ozf_utility_pvt.debug_message(' plan_curr_amount '|| p_utilization_rec.plan_curr_amount);
845: ozf_utility_pvt.debug_message(' plan_currency_code '|| l_utilization_rec.plan_currency_code);
846: ozf_utility_pvt.debug_message(' currency_code '|| l_utilization_rec.currency_code);
847: END IF;
848: ozf_utility_pvt.convert_currency (
849: p_from_currency => l_utilization_rec.currency_code
850: ,p_to_currency=> l_utilization_rec.plan_currency_code

Line 848: ozf_utility_pvt.convert_currency (

844: ozf_utility_pvt.debug_message(' plan_curr_amount '|| p_utilization_rec.plan_curr_amount);
845: ozf_utility_pvt.debug_message(' plan_currency_code '|| l_utilization_rec.plan_currency_code);
846: ozf_utility_pvt.debug_message(' currency_code '|| l_utilization_rec.currency_code);
847: END IF;
848: ozf_utility_pvt.convert_currency (
849: p_from_currency => l_utilization_rec.currency_code
850: ,p_to_currency=> l_utilization_rec.plan_currency_code
851: --nirprasa, ER 8399134 pass exchange date also. This has value for
852: -- decrease earned adjustment type for increase_earned it is NULL.

Line 881: ozf_utility_pvt.convert_currency (

877: ELSE
878: --Added for bug 7425189,
879: IF l_utilization_rec.adjustment_desc IN (l_fund_reconc_msg,l_act_bud_cst_msg)
880: AND l_utilization_rec.exchange_rate_date IS NOT NULL THEN
881: ozf_utility_pvt.convert_currency (
882: p_from_currency=> l_utilization_rec.plan_currency_code
883: ,p_to_currency=> g_universal_currency
884: ,p_conv_date=> l_utilization_rec.exchange_rate_date
885: ,p_from_amount=> l_plan_curr_amount

Line 892: ozf_utility_pvt.debug_message('convert_currency '|| l_utilization_rec.plan_currency_code);

888: ,x_rate=> l_rate
889: );
890: ELSE
891: IF G_DEBUG THEN
892: ozf_utility_pvt.debug_message('convert_currency '|| l_utilization_rec.plan_currency_code);
893: ozf_utility_pvt.debug_message('g_universal_currency '|| g_universal_currency);
894: ozf_utility_pvt.debug_message('exchange_rate_date '|| l_utilization_rec.exchange_rate_date);
895: ozf_utility_pvt.debug_message('exchange_rate_type '|| l_utilization_rec.exchange_rate_type);
896: END IF;

Line 893: ozf_utility_pvt.debug_message('g_universal_currency '|| g_universal_currency);

889: );
890: ELSE
891: IF G_DEBUG THEN
892: ozf_utility_pvt.debug_message('convert_currency '|| l_utilization_rec.plan_currency_code);
893: ozf_utility_pvt.debug_message('g_universal_currency '|| g_universal_currency);
894: ozf_utility_pvt.debug_message('exchange_rate_date '|| l_utilization_rec.exchange_rate_date);
895: ozf_utility_pvt.debug_message('exchange_rate_type '|| l_utilization_rec.exchange_rate_type);
896: END IF;
897: ozf_utility_pvt.convert_currency (

Line 894: ozf_utility_pvt.debug_message('exchange_rate_date '|| l_utilization_rec.exchange_rate_date);

890: ELSE
891: IF G_DEBUG THEN
892: ozf_utility_pvt.debug_message('convert_currency '|| l_utilization_rec.plan_currency_code);
893: ozf_utility_pvt.debug_message('g_universal_currency '|| g_universal_currency);
894: ozf_utility_pvt.debug_message('exchange_rate_date '|| l_utilization_rec.exchange_rate_date);
895: ozf_utility_pvt.debug_message('exchange_rate_type '|| l_utilization_rec.exchange_rate_type);
896: END IF;
897: ozf_utility_pvt.convert_currency (
898: p_from_currency=> l_utilization_rec.plan_currency_code

Line 895: ozf_utility_pvt.debug_message('exchange_rate_type '|| l_utilization_rec.exchange_rate_type);

891: IF G_DEBUG THEN
892: ozf_utility_pvt.debug_message('convert_currency '|| l_utilization_rec.plan_currency_code);
893: ozf_utility_pvt.debug_message('g_universal_currency '|| g_universal_currency);
894: ozf_utility_pvt.debug_message('exchange_rate_date '|| l_utilization_rec.exchange_rate_date);
895: ozf_utility_pvt.debug_message('exchange_rate_type '|| l_utilization_rec.exchange_rate_type);
896: END IF;
897: ozf_utility_pvt.convert_currency (
898: p_from_currency=> l_utilization_rec.plan_currency_code
899: ,p_to_currency => g_universal_currency

Line 897: ozf_utility_pvt.convert_currency (

893: ozf_utility_pvt.debug_message('g_universal_currency '|| g_universal_currency);
894: ozf_utility_pvt.debug_message('exchange_rate_date '|| l_utilization_rec.exchange_rate_date);
895: ozf_utility_pvt.debug_message('exchange_rate_type '|| l_utilization_rec.exchange_rate_type);
896: END IF;
897: ozf_utility_pvt.convert_currency (
898: p_from_currency=> l_utilization_rec.plan_currency_code
899: ,p_to_currency => g_universal_currency
900: --nirprasa, ER 8399134 pass exchange date also. This has value for
901: --decrease earned adjustment type for increase_earned it is NULL.

Line 1047: ozf_utility_pvt.debug_message(' fund_request_currency_code '|| l_utilization_rec.fund_request_currency_code);

1043: END IF;
1044:
1045: --nirprasa,ER 8399134. Added this conversion for null currency offers
1046: IF G_DEBUG THEN
1047: ozf_utility_pvt.debug_message(' fund_request_currency_code '|| l_utilization_rec.fund_request_currency_code);
1048: ozf_utility_pvt.debug_message(' plan_currency_code '|| l_utilization_rec.plan_currency_code);
1049: END IF;
1050:
1051: IF l_utilization_rec.plan_currency_code <> l_utilization_rec.fund_request_currency_code THEN

Line 1048: ozf_utility_pvt.debug_message(' plan_currency_code '|| l_utilization_rec.plan_currency_code);

1044:
1045: --nirprasa,ER 8399134. Added this conversion for null currency offers
1046: IF G_DEBUG THEN
1047: ozf_utility_pvt.debug_message(' fund_request_currency_code '|| l_utilization_rec.fund_request_currency_code);
1048: ozf_utility_pvt.debug_message(' plan_currency_code '|| l_utilization_rec.plan_currency_code);
1049: END IF;
1050:
1051: IF l_utilization_rec.plan_currency_code <> l_utilization_rec.fund_request_currency_code THEN
1052: ozf_utility_pvt.convert_currency (x_return_status => x_return_status

Line 1052: ozf_utility_pvt.convert_currency (x_return_status => x_return_status

1048: ozf_utility_pvt.debug_message(' plan_currency_code '|| l_utilization_rec.plan_currency_code);
1049: END IF;
1050:
1051: IF l_utilization_rec.plan_currency_code <> l_utilization_rec.fund_request_currency_code THEN
1052: ozf_utility_pvt.convert_currency (x_return_status => x_return_status
1053: ,p_from_currency => l_utilization_rec.plan_currency_code
1054: ,p_to_currency => l_utilization_rec.fund_request_currency_code
1055: ,p_conv_type => l_utilization_rec.exchange_rate_type -- Added for bug 7030415
1056: --nirprasa, ER 8399134 pass exchange date also. This has value for

Line 1067: l_utilization_rec.fund_request_amount := ozf_utility_pvt.currround(l_utilization_rec.fund_request_amount , l_utilization_rec.fund_request_currency_code);

1063: ELSE
1064: l_utilization_rec.fund_request_amount := l_utilization_rec.plan_curr_amount;
1065: END IF;
1066:
1067: l_utilization_rec.fund_request_amount := ozf_utility_pvt.currround(l_utilization_rec.fund_request_amount , l_utilization_rec.fund_request_currency_code);
1068:
1069:
1070: --l_utilization_rec.gl_posted_flag := NULL; --could have value for adjustment.
1071: /* yzhao: 09/29/2005 R12 no TRANSFER/REQUEST in utilization table

Line 1177: ozf_utility_pvt.debug_message('Going to update mode as l_use_fund_staging_tables is :'||l_use_fund_staging_tables );

1173: -- the main table.
1174: IF l_use_fund_staging_tables <> 'T' then
1175:
1176: IF G_DEBUG THEN
1177: ozf_utility_pvt.debug_message('Going to update mode as l_use_fund_staging_tables is :'||l_use_fund_staging_tables );
1178: END IF;
1179:
1180: UPDATE ozf_act_budgets
1181: SET request_amount = NVL(request_amount, 0) + l_plan_curr_amount

Line 1481: /*ozf_utility_pvt.write_conc_log('NP orig_utilization_id '|| p_utilization_rec.orig_utilization_id);

1477: -> if profile 'Post to Gl' is set to 'invoiced', post to GL after order is invoiced.
1478: -> for returned order, post to gl only after order is invoiced.
1479: */
1480:
1481: /*ozf_utility_pvt.write_conc_log('NP orig_utilization_id '|| p_utilization_rec.orig_utilization_id);
1482: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.object_type);
1483: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.object_id);
1484: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.order_line_id);
1485: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.component_type);*/

Line 1482: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.object_type);

1478: -> for returned order, post to gl only after order is invoiced.
1479: */
1480:
1481: /*ozf_utility_pvt.write_conc_log('NP orig_utilization_id '|| p_utilization_rec.orig_utilization_id);
1482: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.object_type);
1483: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.object_id);
1484: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.order_line_id);
1485: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.component_type);*/
1486:

Line 1483: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.object_id);

1479: */
1480:
1481: /*ozf_utility_pvt.write_conc_log('NP orig_utilization_id '|| p_utilization_rec.orig_utilization_id);
1482: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.object_type);
1483: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.object_id);
1484: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.order_line_id);
1485: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.component_type);*/
1486:
1487: --nirprasa,ER 8399134 comment this code since its not needed now.gl_date should be sysdate

Line 1484: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.order_line_id);

1480:
1481: /*ozf_utility_pvt.write_conc_log('NP orig_utilization_id '|| p_utilization_rec.orig_utilization_id);
1482: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.object_type);
1483: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.object_id);
1484: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.order_line_id);
1485: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.component_type);*/
1486:
1487: --nirprasa,ER 8399134 comment this code since its not needed now.gl_date should be sysdate
1488: --for all types of adjustments as per multi currency enhancement

Line 1485: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.component_type);*/

1481: /*ozf_utility_pvt.write_conc_log('NP orig_utilization_id '|| p_utilization_rec.orig_utilization_id);
1482: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.object_type);
1483: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.object_id);
1484: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.order_line_id);
1485: ozf_utility_pvt.write_conc_log('NP object_type '|| p_utilization_rec.component_type);*/
1486:
1487: --nirprasa,ER 8399134 comment this code since its not needed now.gl_date should be sysdate
1488: --for all types of adjustments as per multi currency enhancement
1489: /*IF l_gl_posted AND p_utilization_rec.utilization_type = 'ADJUSTMENT'

Line 1499: ozf_utility_pvt.write_conc_log('gl posting phase: ' || l_order_gl_phase);

1495:
1496: l_gl_date := NULL;
1497: l_order_gl_phase := NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
1498:
1499: ozf_utility_pvt.write_conc_log('gl posting phase: ' || l_order_gl_phase);
1500:
1501: OPEN c_order_line (l_utilization_rec.order_line_id);
1502: FETCH c_order_line INTO l_line_category_code, l_shipped_quantity, l_flow_status_code,
1503: l_invoice_status_code, l_invoiced_quantity, l_actual_shipment_date;

Line 1510: ozf_utility_pvt.write_conc_log('use actual shipment date for gl date');

1506: IF (l_order_gl_phase = 'SHIPPED' AND l_line_category_code <> 'RETURN' AND
1507: NVL(l_shipped_quantity,0) <> 0 AND l_flow_status_code = 'SHIPPED') THEN
1508:
1509: l_gl_date := l_actual_shipment_date;
1510: ozf_utility_pvt.write_conc_log('use actual shipment date for gl date');
1511: END IF;
1512:
1513: IF l_gl_date IS NULL THEN
1514: IF (l_invoice_status_code = 'YES' OR NVL(l_invoiced_quantity,0) <> 0) THEN

Line 1527: ozf_utility_pvt.write_conc_log('auto-invoice not complete. use sysdate for gl date');

1523: CLOSE c_invoice_date;
1524:
1525: IF l_gl_date IS NULL THEN
1526: l_gl_date := sysdate;
1527: ozf_utility_pvt.write_conc_log('auto-invoice not complete. use sysdate for gl date');
1528: END IF;
1529: END IF;
1530: END IF;
1531:

Line 1534: ozf_utility_pvt.write_conc_log('adjustment will not be posted to gl');

1530: END IF;
1531:
1532: IF l_gl_date IS NULL THEN
1533: l_gl_posted := FALSE;
1534: ozf_utility_pvt.write_conc_log('adjustment will not be posted to gl');
1535: ELSE
1536: l_utilization_rec.gl_date := l_gl_date;
1537: ozf_utility_pvt.write_conc_log('gl date: ' || l_gl_date);
1538: END IF;

Line 1537: ozf_utility_pvt.write_conc_log('gl date: ' || l_gl_date);

1533: l_gl_posted := FALSE;
1534: ozf_utility_pvt.write_conc_log('adjustment will not be posted to gl');
1535: ELSE
1536: l_utilization_rec.gl_date := l_gl_date;
1537: ozf_utility_pvt.write_conc_log('gl date: ' || l_gl_date);
1538: END IF;
1539:
1540: END IF; --IF l_gl_posted AND p_utilization_rec.utilization_type = 'ADJUSTMENT' .....
1541: */

Line 1564: ozf_utility_pvt.write_conc_log('GL Date is system date: ' || l_utilization_rec.gl_date);

1560: --kdass: bug 15877269 - gl date is passed from Process_VO_Result for volume offers
1561: IF l_offer_type <> 'VOLUME_OFFER' THEN
1562: l_utilization_rec.gl_date := sysdate;
1563: END IF;
1564: ozf_utility_pvt.write_conc_log('GL Date is system date: ' || l_utilization_rec.gl_date);
1565: ELSE
1566: l_gl_posted := FALSE;
1567: ozf_utility_pvt.write_conc_log('adjustment will not be posted to GL');
1568: END IF;

Line 1567: ozf_utility_pvt.write_conc_log('adjustment will not be posted to GL');

1563: END IF;
1564: ozf_utility_pvt.write_conc_log('GL Date is system date: ' || l_utilization_rec.gl_date);
1565: ELSE
1566: l_gl_posted := FALSE;
1567: ozf_utility_pvt.write_conc_log('adjustment will not be posted to GL');
1568: END IF;
1569:
1570: END IF; --IF l_gl_posted AND p_utilization_rec.utilization_type = 'ADJUSTMENT' .....
1571:

Line 1578: l_utilization_rec.amount_remaining := ozf_utility_pvt.currround(l_utilization_rec.amount_remaining

1574: l_utilization_rec.acctd_amount_remaining := l_utilization_rec.amount_remaining;
1575: l_utilization_rec.univ_curr_amount_remaining := l_utilization_rec.amount_remaining;
1576: l_utilization_rec.fund_request_amount_remaining := l_utilization_rec.amount_remaining;
1577: ELSE
1578: l_utilization_rec.amount_remaining := ozf_utility_pvt.currround(l_utilization_rec.amount_remaining
1579: , l_utilization_rec.currency_code);
1580: -- nirprasa,12.1.1 retreive acctd_amount_remaining from plan_curr_amount_remaining
1581: -- and round it.
1582: --nepanda : 9662148 : moving the calculation of acctd_amt_rem to below as plan_curr_amt_rem is not yet calculated here and is null

Line 1586: l_utilization_rec.acctd_amount_remaining := ozf_utility_pvt.currround(l_utilization_rec.acctd_amount_remaining

1582: --nepanda : 9662148 : moving the calculation of acctd_amt_rem to below as plan_curr_amt_rem is not yet calculated here and is null
1583: /*
1584: l_utilization_rec.acctd_amount_remaining :=
1585: l_utilization_rec.exchange_rate * l_utilization_rec.plan_curr_amount_remaining ;
1586: l_utilization_rec.acctd_amount_remaining := ozf_utility_pvt.currround(l_utilization_rec.acctd_amount_remaining
1587: , l_fc_code); */
1588:
1589: --Added for bug 7425189
1590: IF l_utilization_rec.adjustment_desc IN (l_fund_reconc_msg,l_act_bud_cst_msg)

Line 1603: ozf_utility_pvt.convert_currency (

1599: ELSE
1600:
1601: IF p_utilization_rec.plan_curr_amount_remaining IS NULL
1602: OR p_utilization_rec.plan_curr_amount_remaining = fnd_api.g_miss_num THEN
1603: ozf_utility_pvt.convert_currency (
1604: p_from_currency => l_utilization_rec.currency_code
1605: ,p_to_currency => l_plan_currency
1606: --nirprasa, ER 8399134 pass exchange date also. This has value for
1607: --decrease earned adjustment type. for increase_earned it is NULL

Line 1620: l_plan_curr_amount_remaining := ozf_utility_pvt.currround(l_plan_curr_amount_remaining

1616: l_plan_curr_amount_remaining := l_utilization_rec.plan_curr_amount_remaining;
1617: END IF;
1618: END IF;
1619:
1620: l_plan_curr_amount_remaining := ozf_utility_pvt.currround(l_plan_curr_amount_remaining
1621: , l_utilization_rec.plan_currency_code);
1622: IF l_return_status = fnd_api.g_ret_sts_error THEN
1623: RAISE fnd_api.g_exc_error;
1624: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1632: l_utilization_rec.acctd_amount_remaining := ozf_utility_pvt.currround(l_utilization_rec.acctd_amount_remaining

1628: --nepanda : 9662148 : moved the calculation of acctd_amt_rem here from above
1629: --calculating with l_plan_curr_amount_remaining instead of l_utilization_rec.plan_curr_amount_remaining
1630: l_utilization_rec.acctd_amount_remaining :=
1631: l_utilization_rec.exchange_rate * l_plan_curr_amount_remaining ;
1632: l_utilization_rec.acctd_amount_remaining := ozf_utility_pvt.currround(l_utilization_rec.acctd_amount_remaining
1633: , l_fc_code);
1634:
1635: --nirprasa,ER 8399134
1636: --fix for bug 8586014 added AND

Line 1646: ozf_utility_pvt.convert_currency (x_return_status => x_return_status

1642: l_utilization_rec.fund_request_amount_remaining := l_utilization_rec.amount_remaining;
1643: ELSIF l_utilization_rec.fund_request_currency_code = l_fc_code THEN
1644: l_utilization_rec.fund_request_amount_remaining := l_utilization_rec.acctd_amount_remaining;
1645: ELSE
1646: ozf_utility_pvt.convert_currency (x_return_status => x_return_status
1647: ,p_from_currency => l_utilization_rec.plan_currency_code
1648: --nirprasa, ER 8399134 pass exchange date also. This has value for
1649: --decrease earned adjustment type for increase_earned it is NULL.
1650: ,p_conv_date => l_utilization_rec.exchange_rate_date

Line 1669: ozf_utility_pvt.convert_currency (

1665: ELSE
1666: --Added for bug 7425189,
1667: IF l_utilization_rec.adjustment_desc IN (l_fund_reconc_msg,l_act_bud_cst_msg)
1668: AND l_utilization_rec.exchange_rate_date IS NOT NULL THEN
1669: ozf_utility_pvt.convert_currency (
1670: p_from_currency=> l_utilization_rec.plan_currency_code
1671: ,p_to_currency=> g_universal_currency
1672: ,p_conv_date=> l_utilization_rec.exchange_rate_date
1673: ,p_from_amount=> l_plan_curr_amount_remaining

Line 1679: ozf_utility_pvt.convert_currency (

1675: ,x_to_amount=> l_utilization_rec.univ_curr_amount_remaining
1676: ,x_rate=> l_rate
1677: );
1678: ELSE
1679: ozf_utility_pvt.convert_currency (
1680: p_from_currency=> l_utilization_rec.plan_currency_code
1681: ,p_to_currency => g_universal_currency
1682: --nirprasa, ER 8399134 pass exchange date also. This has value for
1683: --decrease earned adjustment type for increase_earned it is NULL.

Line 1716: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl amount '||l_utilization_rec.amount);

1712: l_utilization_rec.univ_curr_amount := 0;
1713: END IF;
1714: */
1715: IF G_DEBUG THEN
1716: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl amount '||l_utilization_rec.amount);
1717: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl acctd amount '||l_utilization_rec.acctd_amount);
1718: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl plan_curr_amount '|| l_plan_curr_amount);
1719: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl fund_request_amount '||l_utilization_rec.fund_request_amount);
1720: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl amount_remaining '||l_utilization_rec.amount_remaining);

Line 1717: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl acctd amount '||l_utilization_rec.acctd_amount);

1713: END IF;
1714: */
1715: IF G_DEBUG THEN
1716: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl amount '||l_utilization_rec.amount);
1717: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl acctd amount '||l_utilization_rec.acctd_amount);
1718: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl plan_curr_amount '|| l_plan_curr_amount);
1719: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl fund_request_amount '||l_utilization_rec.fund_request_amount);
1720: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl amount_remaining '||l_utilization_rec.amount_remaining);
1721: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl acctd_amount_remaining '||l_utilization_rec.acctd_amount_remaining);

Line 1718: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl plan_curr_amount '|| l_plan_curr_amount);

1714: */
1715: IF G_DEBUG THEN
1716: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl amount '||l_utilization_rec.amount);
1717: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl acctd amount '||l_utilization_rec.acctd_amount);
1718: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl plan_curr_amount '|| l_plan_curr_amount);
1719: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl fund_request_amount '||l_utilization_rec.fund_request_amount);
1720: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl amount_remaining '||l_utilization_rec.amount_remaining);
1721: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl acctd_amount_remaining '||l_utilization_rec.acctd_amount_remaining);
1722: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl plan_curr_amount_remaining '||l_plan_curr_amount_remaining);

Line 1719: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl fund_request_amount '||l_utilization_rec.fund_request_amount);

1715: IF G_DEBUG THEN
1716: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl amount '||l_utilization_rec.amount);
1717: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl acctd amount '||l_utilization_rec.acctd_amount);
1718: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl plan_curr_amount '|| l_plan_curr_amount);
1719: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl fund_request_amount '||l_utilization_rec.fund_request_amount);
1720: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl amount_remaining '||l_utilization_rec.amount_remaining);
1721: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl acctd_amount_remaining '||l_utilization_rec.acctd_amount_remaining);
1722: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl plan_curr_amount_remaining '||l_plan_curr_amount_remaining);
1723: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl fund_request_amount_remaining '||l_utilization_rec.fund_request_amount_remaining);

Line 1720: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl amount_remaining '||l_utilization_rec.amount_remaining);

1716: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl amount '||l_utilization_rec.amount);
1717: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl acctd amount '||l_utilization_rec.acctd_amount);
1718: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl plan_curr_amount '|| l_plan_curr_amount);
1719: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl fund_request_amount '||l_utilization_rec.fund_request_amount);
1720: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl amount_remaining '||l_utilization_rec.amount_remaining);
1721: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl acctd_amount_remaining '||l_utilization_rec.acctd_amount_remaining);
1722: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl plan_curr_amount_remaining '||l_plan_curr_amount_remaining);
1723: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl fund_request_amount_remaining '||l_utilization_rec.fund_request_amount_remaining);
1724: ozf_utility_pvt.debug_message ('exchange_rate l_converted_amt ' || l_utilization_rec.exchange_rate);

Line 1721: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl acctd_amount_remaining '||l_utilization_rec.acctd_amount_remaining);

1717: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl acctd amount '||l_utilization_rec.acctd_amount);
1718: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl plan_curr_amount '|| l_plan_curr_amount);
1719: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl fund_request_amount '||l_utilization_rec.fund_request_amount);
1720: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl amount_remaining '||l_utilization_rec.amount_remaining);
1721: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl acctd_amount_remaining '||l_utilization_rec.acctd_amount_remaining);
1722: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl plan_curr_amount_remaining '||l_plan_curr_amount_remaining);
1723: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl fund_request_amount_remaining '||l_utilization_rec.fund_request_amount_remaining);
1724: ozf_utility_pvt.debug_message ('exchange_rate l_converted_amt ' || l_utilization_rec.exchange_rate);
1725: ozf_utility_pvt.debug_message ('l_utilization_rec.org_id ' || l_utilization_rec.org_id);

Line 1722: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl plan_curr_amount_remaining '||l_plan_curr_amount_remaining);

1718: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl plan_curr_amount '|| l_plan_curr_amount);
1719: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl fund_request_amount '||l_utilization_rec.fund_request_amount);
1720: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl amount_remaining '||l_utilization_rec.amount_remaining);
1721: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl acctd_amount_remaining '||l_utilization_rec.acctd_amount_remaining);
1722: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl plan_curr_amount_remaining '||l_plan_curr_amount_remaining);
1723: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl fund_request_amount_remaining '||l_utilization_rec.fund_request_amount_remaining);
1724: ozf_utility_pvt.debug_message ('exchange_rate l_converted_amt ' || l_utilization_rec.exchange_rate);
1725: ozf_utility_pvt.debug_message ('l_utilization_rec.org_id ' || l_utilization_rec.org_id);
1726: END IF;

Line 1723: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl fund_request_amount_remaining '||l_utilization_rec.fund_request_amount_remaining);

1719: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl fund_request_amount '||l_utilization_rec.fund_request_amount);
1720: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl amount_remaining '||l_utilization_rec.amount_remaining);
1721: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl acctd_amount_remaining '||l_utilization_rec.acctd_amount_remaining);
1722: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl plan_curr_amount_remaining '||l_plan_curr_amount_remaining);
1723: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl fund_request_amount_remaining '||l_utilization_rec.fund_request_amount_remaining);
1724: ozf_utility_pvt.debug_message ('exchange_rate l_converted_amt ' || l_utilization_rec.exchange_rate);
1725: ozf_utility_pvt.debug_message ('l_utilization_rec.org_id ' || l_utilization_rec.org_id);
1726: END IF;
1727:

Line 1724: ozf_utility_pvt.debug_message ('exchange_rate l_converted_amt ' || l_utilization_rec.exchange_rate);

1720: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl amount_remaining '||l_utilization_rec.amount_remaining);
1721: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl acctd_amount_remaining '||l_utilization_rec.acctd_amount_remaining);
1722: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl plan_curr_amount_remaining '||l_plan_curr_amount_remaining);
1723: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl fund_request_amount_remaining '||l_utilization_rec.fund_request_amount_remaining);
1724: ozf_utility_pvt.debug_message ('exchange_rate l_converted_amt ' || l_utilization_rec.exchange_rate);
1725: ozf_utility_pvt.debug_message ('l_utilization_rec.org_id ' || l_utilization_rec.org_id);
1726: END IF;
1727:
1728: --kdass - added for Third Party Flow, since fnd_global.conc_request_id initialized to -1 from 2nd iteration

Line 1725: ozf_utility_pvt.debug_message ('l_utilization_rec.org_id ' || l_utilization_rec.org_id);

1721: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl acctd_amount_remaining '||l_utilization_rec.acctd_amount_remaining);
1722: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl plan_curr_amount_remaining '||l_plan_curr_amount_remaining);
1723: ozf_utility_pvt.debug_message('amount in ozf_funds util tbl fund_request_amount_remaining '||l_utilization_rec.fund_request_amount_remaining);
1724: ozf_utility_pvt.debug_message ('exchange_rate l_converted_amt ' || l_utilization_rec.exchange_rate);
1725: ozf_utility_pvt.debug_message ('l_utilization_rec.org_id ' || l_utilization_rec.org_id);
1726: END IF;
1727:
1728: --kdass - added for Third Party Flow, since fnd_global.conc_request_id initialized to -1 from 2nd iteration
1729: l_request_id := fnd_global.conc_request_id;

Line 1971: ozf_utility_pvt.debug_message ( l_full_name || ': inserted:' || ': Utilization_id: ' || l_utilization_rec.utilization_id || ': amount:' || l_utilization_rec.amount);

1967:
1968: x_utilization_id := l_utilization_rec.utilization_id;
1969:
1970: IF G_DEBUG THEN
1971: ozf_utility_pvt.debug_message ( l_full_name || ': inserted:' || ': Utilization_id: ' || l_utilization_rec.utilization_id || ': amount:' || l_utilization_rec.amount);
1972: END IF;
1973:
1974: /* yzhao: 09/29/2005 R12 no TRANSFER/REQUEST in utilization table
1975: IF p_utilization_rec.utilization_type NOT IN ('TRANSFER', 'REQUEST') THEN

Line 2019: --ozf_utility_pvt.debug_message(l_full_name || ': l_skip_acct_gen_flag: ' || l_skip_acct_gen_flag);

2015: l_skip_acct_gen_flag := NVL(ozf_fund_utilized_pub.g_skip_acct_gen_flag, 'F');
2016: */
2017:
2018: IF G_DEBUG THEN
2019: --ozf_utility_pvt.debug_message(l_full_name || ': l_skip_acct_gen_flag: ' || l_skip_acct_gen_flag);
2020: ozf_utility_pvt.debug_message(l_full_name || ': gl_account_credit: ' || l_utilization_rec.gl_account_credit);
2021: ozf_utility_pvt.debug_message(l_full_name || ': gl_account_debit: ' || l_utilization_rec.gl_account_debit);
2022: END IF;
2023:

Line 2020: ozf_utility_pvt.debug_message(l_full_name || ': gl_account_credit: ' || l_utilization_rec.gl_account_credit);

2016: */
2017:
2018: IF G_DEBUG THEN
2019: --ozf_utility_pvt.debug_message(l_full_name || ': l_skip_acct_gen_flag: ' || l_skip_acct_gen_flag);
2020: ozf_utility_pvt.debug_message(l_full_name || ': gl_account_credit: ' || l_utilization_rec.gl_account_credit);
2021: ozf_utility_pvt.debug_message(l_full_name || ': gl_account_debit: ' || l_utilization_rec.gl_account_debit);
2022: END IF;
2023:
2024: -- Fix For Bug 8466615

Line 2021: ozf_utility_pvt.debug_message(l_full_name || ': gl_account_debit: ' || l_utilization_rec.gl_account_debit);

2017:
2018: IF G_DEBUG THEN
2019: --ozf_utility_pvt.debug_message(l_full_name || ': l_skip_acct_gen_flag: ' || l_skip_acct_gen_flag);
2020: ozf_utility_pvt.debug_message(l_full_name || ': gl_account_credit: ' || l_utilization_rec.gl_account_credit);
2021: ozf_utility_pvt.debug_message(l_full_name || ': gl_account_debit: ' || l_utilization_rec.gl_account_debit);
2022: END IF;
2023:
2024: -- Fix For Bug 8466615
2025: ozf_gl_interface_pvt.Post_Accrual_To_GL(p_api_version => 1.0

Line 2042: ozf_utility_pvt.debug_message ( l_full_name || ': posted GL: ' || l_return_status);

2038: --,x_event_id => x_event_id
2039: );
2040:
2041: IF G_DEBUG THEN
2042: ozf_utility_pvt.debug_message ( l_full_name || ': posted GL: ' || l_return_status);
2043: END IF;
2044:
2045: -- yzhao: 03/27/2003 when gl posting succeeds, set the flag 'Y', otherwise 'F', ignore error and reprocess later
2046: IF l_return_status = fnd_api.g_ret_sts_success THEN

Line 2252: ozf_utility_pvt.debug_message ( l_full_name

2248: ,p_count=> x_msg_count
2249: ,p_data=> x_msg_data
2250: );
2251: IF G_DEBUG THEN
2252: ozf_utility_pvt.debug_message ( l_full_name
2253: || ': end');
2254: END IF;
2255: EXCEPTION
2256: WHEN fnd_api.g_exc_error THEN

Line 2314: ozf_utility_pvt.debug_message ( l_full_name

2310: BEGIN
2311: --------------------- initialize -----------------------
2312: SAVEPOINT delete_utilization;
2313: IF G_DEBUG THEN
2314: ozf_utility_pvt.debug_message ( l_full_name
2315: || ': start');
2316: END IF;
2317:
2318: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 2330: ozf_utility_pvt.debug_message ( l_full_name

2326: x_return_status := fnd_api.g_ret_sts_success;
2327:
2328: ------------------------ delete ------------------------
2329: IF G_DEBUG THEN
2330: ozf_utility_pvt.debug_message ( l_full_name
2331: || ': delete');
2332: END IF;
2333:
2334: DELETE FROM ozf_funds_utilized_all_b

Line 2371: ozf_utility_pvt.debug_message ( l_full_name

2367: ,p_count=> x_msg_count
2368: ,p_data=> x_msg_data
2369: );
2370: IF G_DEBUG THEN
2371: ozf_utility_pvt.debug_message ( l_full_name
2372: || ': end');
2373: END IF;
2374: EXCEPTION
2375: WHEN fnd_api.g_exc_error THEN

Line 2448: ozf_utility_pvt.debug_message ( l_full_name

2444: FOR UPDATE OF utilization_id NOWAIT;
2445: BEGIN
2446: -------------------- initialize ------------------------
2447: IF G_DEBUG THEN
2448: ozf_utility_pvt.debug_message ( l_full_name
2449: || ': start');
2450: END IF;
2451:
2452: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 2464: ozf_utility_pvt.debug_message ( l_full_name

2460: x_return_status := fnd_api.g_ret_sts_success;
2461:
2462: ------------------------ lock -------------------------
2463: IF G_DEBUG THEN
2464: ozf_utility_pvt.debug_message ( l_full_name
2465: || ': lock');
2466: END IF;
2467: OPEN c_utilization_b;
2468: FETCH c_utilization_b INTO l_utilization_id;

Line 2492: ozf_utility_pvt.debug_message ( l_full_name

2488: ,p_count=> x_msg_count
2489: ,p_data=> x_msg_data
2490: );
2491: IF G_DEBUG THEN
2492: ozf_utility_pvt.debug_message ( l_full_name
2493: || ': end');
2494: END IF;
2495: EXCEPTION
2496: WHEN ozf_utility_pvt.resource_locked THEN

Line 2496: WHEN ozf_utility_pvt.resource_locked THEN

2492: ozf_utility_pvt.debug_message ( l_full_name
2493: || ': end');
2494: END IF;
2495: EXCEPTION
2496: WHEN ozf_utility_pvt.resource_locked THEN
2497: x_return_status := fnd_api.g_ret_sts_error;
2498:
2499: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2500: fnd_message.set_name ('OZF', 'OZF_API_RESOURCE_LOCKED');

Line 2593: ozf_utility_pvt.debug_message ( l_full_name

2589: BEGIN
2590: -------------------- initialize -------------------------
2591: SAVEPOINT update_utilization;
2592: IF G_DEBUG THEN
2593: ozf_utility_pvt.debug_message ( l_full_name
2594: || ': start');
2595: END IF;
2596:
2597: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 2609: ozf_utility_pvt.debug_message ( l_full_name

2605: x_return_status := fnd_api.g_ret_sts_success;
2606:
2607: ----------------------- validate ----------------------
2608: IF G_DEBUG THEN
2609: ozf_utility_pvt.debug_message ( l_full_name
2610: || ': validate');
2611: END IF;
2612: -- replace g_miss_char/num/date with current column values
2613: complete_utilization_rec (p_utilization_rec, l_utilization_rec);

Line 2648: ozf_utility_pvt.debug_message ( l_full_name

2644:
2645:
2646: -------------------------- update --------------------
2647: IF G_DEBUG THEN
2648: ozf_utility_pvt.debug_message ( l_full_name
2649: || ': update');
2650: END IF;
2651: l_plan_currency :=
2652: ozf_actbudgets_pvt.get_object_currency (

Line 2659: ozf_utility_pvt.convert_currency (

2655: ,l_return_status
2656: );
2657:
2658: IF NVL (l_utilization_rec.amount, 0) <> 0 THEN
2659: ozf_utility_pvt.convert_currency (
2660: p_from_currency=> l_utilization_rec.currency_code
2661: ,p_to_currency=> l_plan_currency
2662: ,p_from_amount=> l_utilization_rec.amount
2663: ,x_return_status=> l_return_status

Line 2676: ozf_utility_pvt.convert_currency (

2672: END IF;
2673: END IF;
2674:
2675: IF NVL (l_utilization_rec.amount_remaining, 0) <> 0 THEN
2676: ozf_utility_pvt.convert_currency (
2677: p_from_currency=> l_utilization_rec.currency_code
2678: ,p_to_currency=> l_plan_currency
2679: ,p_from_amount=> l_utilization_rec.amount_remaining
2680: ,x_return_status=> l_return_status

Line 2704: ozf_utility_pvt.convert_currency (

2700: ELSE
2701: IF NVL (l_utilization_rec.amount, 0) = 0 THEN
2702: l_univ_curr_amount := 0;
2703: ELSE
2704: ozf_utility_pvt.convert_currency (
2705: p_from_currency=> l_utilization_rec.currency_code
2706: ,p_to_currency=> g_universal_currency
2707: ,p_from_amount=> l_utilization_rec.amount
2708: ,x_return_status=> l_return_status

Line 2722: ozf_utility_pvt.convert_currency (

2718:
2719: IF NVL (l_utilization_rec.amount_remaining, 0) = 0 THEN
2720: l_univ_curr_amount_remaining := 0;
2721: ELSE
2722: ozf_utility_pvt.convert_currency (
2723: p_from_currency=> l_utilization_rec.currency_code
2724: ,p_to_currency=> g_universal_currency
2725: ,p_from_amount=> l_utilization_rec.amount_remaining
2726: ,x_return_status=> l_return_status

Line 2915: ozf_utility_pvt.debug_message ( l_full_name

2911: ,p_count=> x_msg_count
2912: ,p_data=> x_msg_data
2913: );
2914: IF G_DEBUG THEN
2915: ozf_utility_pvt.debug_message ( l_full_name
2916: || ': end');
2917: END IF;
2918: EXCEPTION
2919: WHEN fnd_api.g_exc_error THEN

Line 2978: ozf_utility_pvt.debug_message ( l_full_name

2974: l_return_status VARCHAR2 (1);
2975: BEGIN
2976: ----------------------- initialize --------------------
2977: IF G_DEBUG THEN
2978: ozf_utility_pvt.debug_message ( l_full_name
2979: || ': start');
2980: END IF;
2981:
2982: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 2994: ozf_utility_pvt.debug_message ( l_full_name

2990: x_return_status := fnd_api.g_ret_sts_success;
2991:
2992: ---------------------- validate ------------------------
2993: IF G_DEBUG THEN
2994: ozf_utility_pvt.debug_message ( l_full_name
2995: || ': check items');
2996: END IF;
2997:
2998: IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN

Line 3013: ozf_utility_pvt.debug_message ( l_full_name

3009: END IF;
3010: END IF;
3011:
3012: IF G_DEBUG THEN
3013: ozf_utility_pvt.debug_message ( l_full_name
3014: || ': check record');
3015: END IF;
3016:
3017: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN

Line 3039: ozf_utility_pvt.debug_message ( l_full_name

3035: ,p_count=> x_msg_count
3036: ,p_data=> x_msg_data
3037: );
3038: IF G_DEBUG THEN
3039: ozf_utility_pvt.debug_message ( l_full_name
3040: || ': end');
3041: END IF;
3042: EXCEPTION
3043: WHEN fnd_api.g_exc_error THEN

Line 3163: IF ozf_utility_pvt.check_uniqueness (

3159: -- For Create_Utilization, when utilization_id is passed in, we need to
3160: -- check if this utilization_id is unique.
3161: IF p_validation_mode = jtf_plsql_api.g_create
3162: AND p_utilization_rec.utilization_id IS NOT NULL THEN
3163: IF ozf_utility_pvt.check_uniqueness (
3164: 'ozf_funds_UTILIZED_all_b'
3165: , 'utilization_id = '
3166: || p_utilization_rec.utilization_id
3167: ) = fnd_api.g_false THEN

Line 3202: IF ozf_utility_pvt.check_fk_exists (

3198:
3199:
3200: ----------------------- fund_id ------------------------
3201: IF p_utilization_rec.fund_id <> fnd_api.g_miss_num THEN
3202: IF ozf_utility_pvt.check_fk_exists (
3203: 'ozf_funds_all_b'
3204: , -- Parent schema object having the primary key
3205: 'fund_id'
3206: , -- Column name in the parent object that maps to the fk value

Line 3221: IF ozf_utility_pvt.check_fk_exists (

3217: END IF;
3218:
3219: ----------------------- adjustment_id ------------------------
3220: IF p_utilization_rec.adjustment_type_id <> fnd_api.g_miss_num THEN
3221: IF ozf_utility_pvt.check_fk_exists (
3222: 'ozf_claim_types_all_b'
3223: , -- Parent schema object having the primary key
3224: 'claim_type_id'
3225: , -- Column name in the parent object that maps to the fk value

Line 3264: IF ozf_utility_pvt.check_lookup_exists (

3260: IF p_utilization_rec.utilization_type <> fnd_api.g_miss_char THEN
3261: /* yzhao: 09/29/2005 R12 no TRANSFER/REQUEST in utilization table
3262: AND p_utilization_rec.utilization_type NOT IN ('TRANSFER', 'REQUEST') THEN
3263: */
3264: IF ozf_utility_pvt.check_lookup_exists (
3265: p_lookup_table_name=> 'OZF_LOOKUPS'
3266: ,p_lookup_type=> 'OZF_UTILIZATION_TYPE'
3267: ,p_lookup_code=> p_utilization_rec.utilization_type
3268: ) = fnd_api.g_false THEN

Line 3281: IF ozf_utility_pvt.check_lookup_exists (

3277: END IF;
3278:
3279: --------------------02/08/2001 mpande added----------------
3280: IF p_utilization_rec.adjustment_type <> fnd_api.g_miss_char THEN
3281: IF ozf_utility_pvt.check_lookup_exists (
3282: p_lookup_table_name=> 'OZF_LOOKUPS'
3283: ,p_lookup_type=> 'OZF_ADJUSTMENT_TYPE'
3284: ,p_lookup_code=> p_utilization_rec.adjustment_type
3285: ) = fnd_api.g_false THEN

Line 3443: ozf_utility_pvt.debug_message (

3439: BEGIN
3440: -- if no offer id then chekc against the activity
3441:
3442: IF G_DEBUG THEN
3443: ozf_utility_pvt.debug_message (
3444: ': check record'
3445: || p_cust_account_id
3446: || '-'
3447: || p_amount

Line 3455: -- ozf_utility_pvt.debug_message(': check record1' || p_component_id ||'-'|| p_amount||p_fund_id||p_activity_id||p_activity_type);

3451: );
3452: END IF;
3453:
3454: -- IF p_component_id IS NULL THEN
3455: -- ozf_utility_pvt.debug_message(': check record1' || p_component_id ||'-'|| p_amount||p_fund_id||p_activity_id||p_activity_type);
3456: IF p_activity_type <> 'OFFR' THEN
3457: l_recal_flag := 'N' ;
3458: ELSE
3459: l_recal_flag := NVL(fnd_profile.value('OZF_BUDGET_ADJ_ALLOW_RECAL'),'N');

Line 3474: ozf_utility_pvt.debug_message (

3470: END IF;
3471:
3472: CLOSE c_transfer_allowed;
3473: IF G_DEBUG THEN
3474: ozf_utility_pvt.debug_message (
3475: ': check record2'
3476: || p_cust_account_id
3477: || '-'
3478: || p_amount

Line 3486: ozf_utility_pvt.debug_message ( ': check record'

3482: );
3483: END IF;
3484: IF NVL (p_amount, 0) > NVL (l_amount, 0) THEN
3485: IF G_DEBUG THEN
3486: ozf_utility_pvt.debug_message ( ': check record'
3487: || l_amount
3488: || p_amount);
3489: END IF;
3490: RETURN fnd_api.g_false;

Line 3550: ozf_utility_pvt.debug_message ( ': check record'

3546: BEGIN
3547: -- if no offer id then chekc against the activity
3548:
3549: IF G_DEBUG THEN
3550: ozf_utility_pvt.debug_message ( ': check record'
3551: || p_cust_account_id
3552: || p_amount);
3553: END IF;
3554:

Line 3580: ozf_utility_pvt.debug_message ( ': check record'

3576: */
3577: -- if offer id present then check against the amount
3578: IF ABS(NVL (p_amount, 0)) > NVL (l_amount, 0) THEN
3579: IF G_DEBUG THEN
3580: ozf_utility_pvt.debug_message ( ': check record'
3581: || l_amount
3582: || p_amount);
3583: END IF;
3584: RETURN fnd_api.g_false;

Line 3620: ozf_utility_pvt.debug_message ( ': check record'

3616:
3617: -- check against the amount
3618: IF l_status <> 'ACTIVE' THEN
3619: IF G_DEBUG THEN
3620: ozf_utility_pvt.debug_message ( ': check record'
3621: || l_status);
3622: END IF;
3623: RETURN fnd_api.g_false;
3624: END IF;

Line 4383: ozf_utility_pvt.debug_message ( l_full_name

4379: BEGIN
4380: --------------------- initialize -----------------------
4381: SAVEPOINT create_act_utilization;
4382: IF G_DEBUG THEN
4383: ozf_utility_pvt.debug_message ( l_full_name
4384: || ': start');
4385: END IF;
4386:
4387: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 4404: ozf_utility_pvt.debug_message('l_act_budgets_rec.parent_src_curr'|| l_act_budgets_rec.parent_src_curr);

4400: -- Now the amount will be in transactional currency instead of budget currency.
4401: -- So, convert from transactional to
4402: --IF l_act_budgets_rec.parent_src_apprvd_amt IS NOT NULL THEN
4403: IF G_DEBUG THEN
4404: ozf_utility_pvt.debug_message('l_act_budgets_rec.parent_src_curr'|| l_act_budgets_rec.parent_src_curr);
4405: ozf_utility_pvt.debug_message('l_act_budgets_rec.arc_act_budget_used_by'|| l_act_budgets_rec.arc_act_budget_used_by);
4406: ozf_utility_pvt.debug_message('l_act_budgets_rec.arc_act_budget_used_id'|| l_act_budgets_rec.act_budget_used_by_id);
4407: ozf_utility_pvt.debug_message('l_act_budgets_rec.parent_src_curr'|| l_act_budgets_rec.parent_src_curr);
4408: ozf_utility_pvt.debug_message('l_act_budgets_rec.request_amount'|| l_act_budgets_rec.request_amount);

Line 4405: ozf_utility_pvt.debug_message('l_act_budgets_rec.arc_act_budget_used_by'|| l_act_budgets_rec.arc_act_budget_used_by);

4401: -- So, convert from transactional to
4402: --IF l_act_budgets_rec.parent_src_apprvd_amt IS NOT NULL THEN
4403: IF G_DEBUG THEN
4404: ozf_utility_pvt.debug_message('l_act_budgets_rec.parent_src_curr'|| l_act_budgets_rec.parent_src_curr);
4405: ozf_utility_pvt.debug_message('l_act_budgets_rec.arc_act_budget_used_by'|| l_act_budgets_rec.arc_act_budget_used_by);
4406: ozf_utility_pvt.debug_message('l_act_budgets_rec.arc_act_budget_used_id'|| l_act_budgets_rec.act_budget_used_by_id);
4407: ozf_utility_pvt.debug_message('l_act_budgets_rec.parent_src_curr'|| l_act_budgets_rec.parent_src_curr);
4408: ozf_utility_pvt.debug_message('l_act_budgets_rec.request_amount'|| l_act_budgets_rec.request_amount);
4409: ozf_utility_pvt.debug_message('l_act_budgets_rec.parent_src_apprvd_amt'|| l_act_budgets_rec.parent_src_apprvd_amt);

Line 4406: ozf_utility_pvt.debug_message('l_act_budgets_rec.arc_act_budget_used_id'|| l_act_budgets_rec.act_budget_used_by_id);

4402: --IF l_act_budgets_rec.parent_src_apprvd_amt IS NOT NULL THEN
4403: IF G_DEBUG THEN
4404: ozf_utility_pvt.debug_message('l_act_budgets_rec.parent_src_curr'|| l_act_budgets_rec.parent_src_curr);
4405: ozf_utility_pvt.debug_message('l_act_budgets_rec.arc_act_budget_used_by'|| l_act_budgets_rec.arc_act_budget_used_by);
4406: ozf_utility_pvt.debug_message('l_act_budgets_rec.arc_act_budget_used_id'|| l_act_budgets_rec.act_budget_used_by_id);
4407: ozf_utility_pvt.debug_message('l_act_budgets_rec.parent_src_curr'|| l_act_budgets_rec.parent_src_curr);
4408: ozf_utility_pvt.debug_message('l_act_budgets_rec.request_amount'|| l_act_budgets_rec.request_amount);
4409: ozf_utility_pvt.debug_message('l_act_budgets_rec.parent_src_apprvd_amt'|| l_act_budgets_rec.parent_src_apprvd_amt);
4410: END IF;

Line 4407: ozf_utility_pvt.debug_message('l_act_budgets_rec.parent_src_curr'|| l_act_budgets_rec.parent_src_curr);

4403: IF G_DEBUG THEN
4404: ozf_utility_pvt.debug_message('l_act_budgets_rec.parent_src_curr'|| l_act_budgets_rec.parent_src_curr);
4405: ozf_utility_pvt.debug_message('l_act_budgets_rec.arc_act_budget_used_by'|| l_act_budgets_rec.arc_act_budget_used_by);
4406: ozf_utility_pvt.debug_message('l_act_budgets_rec.arc_act_budget_used_id'|| l_act_budgets_rec.act_budget_used_by_id);
4407: ozf_utility_pvt.debug_message('l_act_budgets_rec.parent_src_curr'|| l_act_budgets_rec.parent_src_curr);
4408: ozf_utility_pvt.debug_message('l_act_budgets_rec.request_amount'|| l_act_budgets_rec.request_amount);
4409: ozf_utility_pvt.debug_message('l_act_budgets_rec.parent_src_apprvd_amt'|| l_act_budgets_rec.parent_src_apprvd_amt);
4410: END IF;
4411:

Line 4408: ozf_utility_pvt.debug_message('l_act_budgets_rec.request_amount'|| l_act_budgets_rec.request_amount);

4404: ozf_utility_pvt.debug_message('l_act_budgets_rec.parent_src_curr'|| l_act_budgets_rec.parent_src_curr);
4405: ozf_utility_pvt.debug_message('l_act_budgets_rec.arc_act_budget_used_by'|| l_act_budgets_rec.arc_act_budget_used_by);
4406: ozf_utility_pvt.debug_message('l_act_budgets_rec.arc_act_budget_used_id'|| l_act_budgets_rec.act_budget_used_by_id);
4407: ozf_utility_pvt.debug_message('l_act_budgets_rec.parent_src_curr'|| l_act_budgets_rec.parent_src_curr);
4408: ozf_utility_pvt.debug_message('l_act_budgets_rec.request_amount'|| l_act_budgets_rec.request_amount);
4409: ozf_utility_pvt.debug_message('l_act_budgets_rec.parent_src_apprvd_amt'|| l_act_budgets_rec.parent_src_apprvd_amt);
4410: END IF;
4411:
4412: --Added for bug 7030415

Line 4409: ozf_utility_pvt.debug_message('l_act_budgets_rec.parent_src_apprvd_amt'|| l_act_budgets_rec.parent_src_apprvd_amt);

4405: ozf_utility_pvt.debug_message('l_act_budgets_rec.arc_act_budget_used_by'|| l_act_budgets_rec.arc_act_budget_used_by);
4406: ozf_utility_pvt.debug_message('l_act_budgets_rec.arc_act_budget_used_id'|| l_act_budgets_rec.act_budget_used_by_id);
4407: ozf_utility_pvt.debug_message('l_act_budgets_rec.parent_src_curr'|| l_act_budgets_rec.parent_src_curr);
4408: ozf_utility_pvt.debug_message('l_act_budgets_rec.request_amount'|| l_act_budgets_rec.request_amount);
4409: ozf_utility_pvt.debug_message('l_act_budgets_rec.parent_src_apprvd_amt'|| l_act_budgets_rec.parent_src_apprvd_amt);
4410: END IF;
4411:
4412: --Added for bug 7030415
4413: OPEN c_get_conversion_type(l_act_util_rec.org_id);

Line 4424: ozf_utility_pvt.convert_currency (

4420: AND l_act_budgets_rec.request_currency <> l_act_budgets_rec.parent_src_curr) THEN
4421: --nirprasa,ER 8399134
4422: -- convert the src_curr_request amount to the act_used_by currency request amount.
4423:
4424: ozf_utility_pvt.convert_currency (
4425: x_return_status=> l_return_status
4426: ,p_from_currency=> l_act_budgets_rec.request_currency
4427: ,p_to_currency=> l_act_budgets_rec.parent_src_curr
4428: ,p_conv_type=>l_exchange_rate_type --Added for bug 7030415

Line 4448: ozf_utility_pvt.convert_currency (

4444: IF l_act_budgets_rec.request_currency <> l_act_budgets_rec.parent_src_curr
4445: AND (l_act_budgets_rec.request_amount IS NULL
4446: OR l_act_budgets_rec.request_amount = fnd_api.g_miss_num) THEN
4447: --nirprasa,ER 8399134
4448: ozf_utility_pvt.convert_currency (
4449: x_return_status=> l_return_status
4450: ,p_from_currency=> l_act_budgets_rec.parent_src_curr
4451: ,p_to_currency=> l_act_budgets_rec.request_currency
4452: ,p_conv_type=>l_exchange_rate_type --Added for bug 7030415

Line 4470: ozf_utility_pvt.debug_message('transfer_type '|| l_act_budgets_rec.transfer_type);

4466: END IF;
4467: END IF;
4468:
4469: IF G_DEBUG THEN
4470: ozf_utility_pvt.debug_message('transfer_type '|| l_act_budgets_rec.transfer_type);
4471: ozf_utility_pvt.debug_message('adjustment_type '|| l_act_util_rec.adjustment_type);
4472: ozf_utility_pvt.debug_message('budget_source_type '|| l_act_budgets_rec.budget_source_type);
4473: ozf_utility_pvt.debug_message('request_currency '|| l_act_budgets_rec.request_currency);
4474: ozf_utility_pvt.debug_message('request_amount '|| l_act_budgets_rec.request_amount);

Line 4471: ozf_utility_pvt.debug_message('adjustment_type '|| l_act_util_rec.adjustment_type);

4467: END IF;
4468:
4469: IF G_DEBUG THEN
4470: ozf_utility_pvt.debug_message('transfer_type '|| l_act_budgets_rec.transfer_type);
4471: ozf_utility_pvt.debug_message('adjustment_type '|| l_act_util_rec.adjustment_type);
4472: ozf_utility_pvt.debug_message('budget_source_type '|| l_act_budgets_rec.budget_source_type);
4473: ozf_utility_pvt.debug_message('request_currency '|| l_act_budgets_rec.request_currency);
4474: ozf_utility_pvt.debug_message('request_amount '|| l_act_budgets_rec.request_amount);
4475: ozf_utility_pvt.debug_message('approved_amount '|| l_act_budgets_rec.approved_amount);

Line 4472: ozf_utility_pvt.debug_message('budget_source_type '|| l_act_budgets_rec.budget_source_type);

4468:
4469: IF G_DEBUG THEN
4470: ozf_utility_pvt.debug_message('transfer_type '|| l_act_budgets_rec.transfer_type);
4471: ozf_utility_pvt.debug_message('adjustment_type '|| l_act_util_rec.adjustment_type);
4472: ozf_utility_pvt.debug_message('budget_source_type '|| l_act_budgets_rec.budget_source_type);
4473: ozf_utility_pvt.debug_message('request_currency '|| l_act_budgets_rec.request_currency);
4474: ozf_utility_pvt.debug_message('request_amount '|| l_act_budgets_rec.request_amount);
4475: ozf_utility_pvt.debug_message('approved_amount '|| l_act_budgets_rec.approved_amount);
4476: ozf_utility_pvt.debug_message('parent_src_curr '|| l_act_budgets_rec.parent_src_curr);

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

4469: IF G_DEBUG THEN
4470: ozf_utility_pvt.debug_message('transfer_type '|| l_act_budgets_rec.transfer_type);
4471: ozf_utility_pvt.debug_message('adjustment_type '|| l_act_util_rec.adjustment_type);
4472: ozf_utility_pvt.debug_message('budget_source_type '|| l_act_budgets_rec.budget_source_type);
4473: ozf_utility_pvt.debug_message('request_currency '|| l_act_budgets_rec.request_currency);
4474: ozf_utility_pvt.debug_message('request_amount '|| l_act_budgets_rec.request_amount);
4475: ozf_utility_pvt.debug_message('approved_amount '|| l_act_budgets_rec.approved_amount);
4476: ozf_utility_pvt.debug_message('parent_src_curr '|| l_act_budgets_rec.parent_src_curr);
4477: ozf_utility_pvt.debug_message('plan_currency_code '|| l_act_util_rec.plan_currency_code);

Line 4474: ozf_utility_pvt.debug_message('request_amount '|| l_act_budgets_rec.request_amount);

4470: ozf_utility_pvt.debug_message('transfer_type '|| l_act_budgets_rec.transfer_type);
4471: ozf_utility_pvt.debug_message('adjustment_type '|| l_act_util_rec.adjustment_type);
4472: ozf_utility_pvt.debug_message('budget_source_type '|| l_act_budgets_rec.budget_source_type);
4473: ozf_utility_pvt.debug_message('request_currency '|| l_act_budgets_rec.request_currency);
4474: ozf_utility_pvt.debug_message('request_amount '|| l_act_budgets_rec.request_amount);
4475: ozf_utility_pvt.debug_message('approved_amount '|| l_act_budgets_rec.approved_amount);
4476: ozf_utility_pvt.debug_message('parent_src_curr '|| l_act_budgets_rec.parent_src_curr);
4477: ozf_utility_pvt.debug_message('plan_currency_code '|| l_act_util_rec.plan_currency_code);
4478: ozf_utility_pvt.debug_message('parent_src_apprvd_amt '|| l_act_budgets_rec.parent_src_apprvd_amt);

Line 4475: ozf_utility_pvt.debug_message('approved_amount '|| l_act_budgets_rec.approved_amount);

4471: ozf_utility_pvt.debug_message('adjustment_type '|| l_act_util_rec.adjustment_type);
4472: ozf_utility_pvt.debug_message('budget_source_type '|| l_act_budgets_rec.budget_source_type);
4473: ozf_utility_pvt.debug_message('request_currency '|| l_act_budgets_rec.request_currency);
4474: ozf_utility_pvt.debug_message('request_amount '|| l_act_budgets_rec.request_amount);
4475: ozf_utility_pvt.debug_message('approved_amount '|| l_act_budgets_rec.approved_amount);
4476: ozf_utility_pvt.debug_message('parent_src_curr '|| l_act_budgets_rec.parent_src_curr);
4477: ozf_utility_pvt.debug_message('plan_currency_code '|| l_act_util_rec.plan_currency_code);
4478: ozf_utility_pvt.debug_message('parent_src_apprvd_amt '|| l_act_budgets_rec.parent_src_apprvd_amt);
4479: END IF;

Line 4476: ozf_utility_pvt.debug_message('parent_src_curr '|| l_act_budgets_rec.parent_src_curr);

4472: ozf_utility_pvt.debug_message('budget_source_type '|| l_act_budgets_rec.budget_source_type);
4473: ozf_utility_pvt.debug_message('request_currency '|| l_act_budgets_rec.request_currency);
4474: ozf_utility_pvt.debug_message('request_amount '|| l_act_budgets_rec.request_amount);
4475: ozf_utility_pvt.debug_message('approved_amount '|| l_act_budgets_rec.approved_amount);
4476: ozf_utility_pvt.debug_message('parent_src_curr '|| l_act_budgets_rec.parent_src_curr);
4477: ozf_utility_pvt.debug_message('plan_currency_code '|| l_act_util_rec.plan_currency_code);
4478: ozf_utility_pvt.debug_message('parent_src_apprvd_amt '|| l_act_budgets_rec.parent_src_apprvd_amt);
4479: END IF;
4480: IF l_act_budgets_rec.transfer_type = 'TRANSFER'

Line 4477: ozf_utility_pvt.debug_message('plan_currency_code '|| l_act_util_rec.plan_currency_code);

4473: ozf_utility_pvt.debug_message('request_currency '|| l_act_budgets_rec.request_currency);
4474: ozf_utility_pvt.debug_message('request_amount '|| l_act_budgets_rec.request_amount);
4475: ozf_utility_pvt.debug_message('approved_amount '|| l_act_budgets_rec.approved_amount);
4476: ozf_utility_pvt.debug_message('parent_src_curr '|| l_act_budgets_rec.parent_src_curr);
4477: ozf_utility_pvt.debug_message('plan_currency_code '|| l_act_util_rec.plan_currency_code);
4478: ozf_utility_pvt.debug_message('parent_src_apprvd_amt '|| l_act_budgets_rec.parent_src_apprvd_amt);
4479: END IF;
4480: IF l_act_budgets_rec.transfer_type = 'TRANSFER'
4481: AND l_act_util_rec.adjustment_type IN ('DECREASE_COMM_EARNED','DECREASE_COMMITTED' ) THEN

Line 4478: ozf_utility_pvt.debug_message('parent_src_apprvd_amt '|| l_act_budgets_rec.parent_src_apprvd_amt);

4474: ozf_utility_pvt.debug_message('request_amount '|| l_act_budgets_rec.request_amount);
4475: ozf_utility_pvt.debug_message('approved_amount '|| l_act_budgets_rec.approved_amount);
4476: ozf_utility_pvt.debug_message('parent_src_curr '|| l_act_budgets_rec.parent_src_curr);
4477: ozf_utility_pvt.debug_message('plan_currency_code '|| l_act_util_rec.plan_currency_code);
4478: ozf_utility_pvt.debug_message('parent_src_apprvd_amt '|| l_act_budgets_rec.parent_src_apprvd_amt);
4479: END IF;
4480: IF l_act_budgets_rec.transfer_type = 'TRANSFER'
4481: AND l_act_util_rec.adjustment_type IN ('DECREASE_COMM_EARNED','DECREASE_COMMITTED' ) THEN
4482: -- The condition given below differentiates b/w the UI and Public API flow.

Line 4492: ozf_utility_pvt.debug_message(' src_curr_req_amt '|| l_act_budgets_rec.src_curr_req_amt);

4488: l_act_budgets_rec.request_currency := l_act_budgets_rec.parent_src_curr;
4489: l_act_budgets_rec.src_curr_req_amt := l_act_budgets_rec.request_amount;
4490: l_act_budgets_rec.request_amount := null;
4491: IF G_DEBUG THEN
4492: ozf_utility_pvt.debug_message(' src_curr_req_amt '|| l_act_budgets_rec.src_curr_req_amt);
4493: ozf_utility_pvt.debug_message(' request_currency '|| l_act_budgets_rec.request_currency);
4494: END IF;
4495: END IF;
4496: END IF;

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

4489: l_act_budgets_rec.src_curr_req_amt := l_act_budgets_rec.request_amount;
4490: l_act_budgets_rec.request_amount := null;
4491: IF G_DEBUG THEN
4492: ozf_utility_pvt.debug_message(' src_curr_req_amt '|| l_act_budgets_rec.src_curr_req_amt);
4493: ozf_utility_pvt.debug_message(' request_currency '|| l_act_budgets_rec.request_currency);
4494: END IF;
4495: END IF;
4496: END IF;
4497:

Line 4517: ozf_utility_pvt.error_message('OZF_FUND_NO_SCAN_DATA_TYPE');

4513: --for scan data offer, activity_product_id, scan_unit,scan_unit_remaining are required.
4514: IF l_offer_type = 'SCAN_DATA' THEN
4515: --check if scan_type_id is null;
4516: IF l_act_util_rec.scan_type_id is null THEN
4517: ozf_utility_pvt.error_message('OZF_FUND_NO_SCAN_DATA_TYPE');
4518: END IF;
4519:
4520: IF l_act_util_rec.product_id is null THEN
4521: ozf_utility_pvt.error_message('OZF_FUND_NO_PROD_ID');

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

4517: ozf_utility_pvt.error_message('OZF_FUND_NO_SCAN_DATA_TYPE');
4518: END IF;
4519:
4520: IF l_act_util_rec.product_id is null THEN
4521: ozf_utility_pvt.error_message('OZF_FUND_NO_PROD_ID');
4522: END IF;
4523:
4524: OPEN c_off_products(l_act_budgets_rec.budget_source_id,l_act_util_rec.product_level_type,
4525: l_act_util_rec.product_id,l_act_util_rec.scan_type_id);

Line 4529: ozf_utility_pvt.error_message('OZF_FUND_ACT_PROD_ID_NOT_FOUND');

4525: l_act_util_rec.product_id,l_act_util_rec.scan_type_id);
4526:
4527: FETCH c_off_products INTO l_activity_product_id,l_scan_value;
4528: IF c_off_products%NOTFOUND THEN
4529: ozf_utility_pvt.error_message('OZF_FUND_ACT_PROD_ID_NOT_FOUND');
4530: END IF;
4531:
4532: CLOSE c_off_products;
4533:

Line 4536: l_act_util_rec.scan_unit := ozf_utility_pvt.currround(l_act_budgets_rec.request_amount/l_scan_value

4532: CLOSE c_off_products;
4533:
4534: l_act_util_rec.activity_product_id := l_activity_product_id;
4535: --nirprasa,12.1.1
4536: l_act_util_rec.scan_unit := ozf_utility_pvt.currround(l_act_budgets_rec.request_amount/l_scan_value
4537: ,l_act_budgets_rec.request_currency);
4538: l_act_util_rec.scan_unit_remaining := l_act_util_rec.scan_unit;
4539: END IF;
4540:

Line 4561: ozf_utility_pvt.debug_message('request_amount '|| l_act_budgets_rec.request_amount);

4557: ,l_return_status
4558: );
4559:
4560: IF G_DEBUG THEN
4561: ozf_utility_pvt.debug_message('request_amount '|| l_act_budgets_rec.request_amount);
4562: END IF;
4563:
4564: ozf_fund_adjustment_pvt.process_act_budgets (
4565: x_return_status=> l_return_status,

Line 4592: ozf_utility_pvt.debug_message ( l_full_name

4588: ,p_count=> x_msg_count
4589: ,p_data=> x_msg_data
4590: );
4591: IF G_DEBUG THEN
4592: ozf_utility_pvt.debug_message ( l_full_name
4593: || ': end');
4594: END IF;
4595:
4596: EXCEPTION