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

Line 40: ozf_utility_pvt.error_message('OZF_ACCRUAL_NO_PROD');

36: FETCH c_product_elig INTO l_dummy;
37: CLOSE c_product_elig;
38:
39: IF l_dummy IS NULL THEN
40: ozf_utility_pvt.error_message('OZF_ACCRUAL_NO_PROD');
41: x_return_status := fnd_api.g_ret_sts_error;
42: END IF;
43: END check_product_elig_exists;
44:

Line 105: ozf_utility_pvt.convert_currency(

101:
102: IF l_par_curr_code = p_child_curr THEN
103: l_coverted_orig_budget := p_original_budget;
104: ELSE
105: ozf_utility_pvt.convert_currency(
106: x_return_status=> x_return_status,
107: p_from_currency=> p_child_curr,
108: p_to_currency=> l_par_curr_code,
109: p_from_amount=> p_original_budget,

Line 402: ozf_utility_pvt.convert_currency(

398: LOOP
399: IF l_sub_rec.currency_code = p_parent_currency THEN
400: l_coverted_orig_budget := l_sub_rec.original_budget;
401: ELSE
402: ozf_utility_pvt.convert_currency(
403: x_return_status=> x_return_status,
404: p_from_currency=> l_sub_rec.currency_code,
405: p_to_currency=> p_parent_currency,
406: p_from_amount=> l_sub_rec.original_budget,

Line 417: ozf_utility_pvt.error_message(

413: NVL(l_org_budget, 0);
414:
415: IF (l_par_total_budget < NVL(l_org_budget, 0)) THEN
416: IF l_parent_fund_type = 'QUOTA' THEN
417: ozf_utility_pvt.error_message(
418: 'OZF_PAR_QUOTA_LESS_THAN_CHILD',
419: 'FUND_NAME',
420: l_sub_rec.short_name);
421: ELSE

Line 422: ozf_utility_pvt.error_message(

418: 'OZF_PAR_QUOTA_LESS_THAN_CHILD',
419: 'FUND_NAME',
420: l_sub_rec.short_name);
421: ELSE
422: ozf_utility_pvt.error_message(
423: 'OZF_PAR_BUDGET_LESS_THAN_CHILD',
424: 'FUND_NAME',
425: l_sub_rec.short_name);
426: END IF;

Line 469: ozf_utility_pvt.error_message('OZF_TP_START_AFT_SUB_START', 'FUND_NAME', l_sub_rec.short_name);

465: LOOP
466: IF p_start_date > l_sub_rec.start_date THEN
467: x_return_status := fnd_api.g_ret_sts_error;
468: IF l_sub_rec.fund_type = 'QUOTA' THEN
469: ozf_utility_pvt.error_message('OZF_TP_START_AFT_SUB_START', 'FUND_NAME', l_sub_rec.short_name);
470: ELSE
471: ozf_utility_pvt.error_message('OZF_FUND_START_AFT_SUB_START', 'FUND_NAME', l_sub_rec.short_name);
472: END IF;
473: ELSIF p_start_date > l_sub_rec.end_date THEN

Line 471: ozf_utility_pvt.error_message('OZF_FUND_START_AFT_SUB_START', 'FUND_NAME', l_sub_rec.short_name);

467: x_return_status := fnd_api.g_ret_sts_error;
468: IF l_sub_rec.fund_type = 'QUOTA' THEN
469: ozf_utility_pvt.error_message('OZF_TP_START_AFT_SUB_START', 'FUND_NAME', l_sub_rec.short_name);
470: ELSE
471: ozf_utility_pvt.error_message('OZF_FUND_START_AFT_SUB_START', 'FUND_NAME', l_sub_rec.short_name);
472: END IF;
473: ELSIF p_start_date > l_sub_rec.end_date THEN
474: x_return_status := fnd_api.g_ret_sts_error;
475: IF l_sub_rec.fund_type = 'QUOTA' THEN

Line 476: ozf_utility_pvt.error_message('OZF_TP_START_AFT_SUB_END', 'FUND_NAME', l_sub_rec.short_name);

472: END IF;
473: ELSIF p_start_date > l_sub_rec.end_date THEN
474: x_return_status := fnd_api.g_ret_sts_error;
475: IF l_sub_rec.fund_type = 'QUOTA' THEN
476: ozf_utility_pvt.error_message('OZF_TP_START_AFT_SUB_END', 'FUND_NAME', l_sub_rec.short_name);
477: ELSE
478: ozf_utility_pvt.error_message('OZF_FUND_START_AFT_SUB_END', 'FUND_NAME', l_sub_rec.short_name);
479: END IF;
480: END IF;

Line 478: ozf_utility_pvt.error_message('OZF_FUND_START_AFT_SUB_END', 'FUND_NAME', l_sub_rec.short_name);

474: x_return_status := fnd_api.g_ret_sts_error;
475: IF l_sub_rec.fund_type = 'QUOTA' THEN
476: ozf_utility_pvt.error_message('OZF_TP_START_AFT_SUB_END', 'FUND_NAME', l_sub_rec.short_name);
477: ELSE
478: ozf_utility_pvt.error_message('OZF_FUND_START_AFT_SUB_END', 'FUND_NAME', l_sub_rec.short_name);
479: END IF;
480: END IF;
481:
482: IF p_end_date < l_sub_rec.end_date THEN

Line 485: ozf_utility_pvt.error_message('OZF_TP_QUOTA_END_BEF_SUB_END', 'FUND_NAME', l_sub_rec.short_name);

481:
482: IF p_end_date < l_sub_rec.end_date THEN
483: x_return_status := fnd_api.g_ret_sts_error;
484: IF l_sub_rec.fund_type = 'QUOTA' THEN
485: ozf_utility_pvt.error_message('OZF_TP_QUOTA_END_BEF_SUB_END', 'FUND_NAME', l_sub_rec.short_name);
486: ELSE
487: ozf_utility_pvt.error_message('OZF_FUND_END_BEF_SUB_END', 'FUND_NAME', l_sub_rec.short_name);
488: END IF;
489: ELSIF p_end_date < l_sub_rec.start_date THEN

Line 487: ozf_utility_pvt.error_message('OZF_FUND_END_BEF_SUB_END', 'FUND_NAME', l_sub_rec.short_name);

483: x_return_status := fnd_api.g_ret_sts_error;
484: IF l_sub_rec.fund_type = 'QUOTA' THEN
485: ozf_utility_pvt.error_message('OZF_TP_QUOTA_END_BEF_SUB_END', 'FUND_NAME', l_sub_rec.short_name);
486: ELSE
487: ozf_utility_pvt.error_message('OZF_FUND_END_BEF_SUB_END', 'FUND_NAME', l_sub_rec.short_name);
488: END IF;
489: ELSIF p_end_date < l_sub_rec.start_date THEN
490: x_return_status := fnd_api.g_ret_sts_error;
491: IF l_sub_rec.fund_type = 'QUOTA' THEN

Line 492: ozf_utility_pvt.error_message('OZF_TP_END_BEF_SUB_START', 'FUND_NAME', l_sub_rec.short_name);

488: END IF;
489: ELSIF p_end_date < l_sub_rec.start_date THEN
490: x_return_status := fnd_api.g_ret_sts_error;
491: IF l_sub_rec.fund_type = 'QUOTA' THEN
492: ozf_utility_pvt.error_message('OZF_TP_END_BEF_SUB_START', 'FUND_NAME', l_sub_rec.short_name);
493: ELSE
494: ozf_utility_pvt.error_message('OZF_FUND_END_BEF_SUB_START', 'FUND_NAME', l_sub_rec.short_name);
495: END IF;
496: END IF;

Line 494: ozf_utility_pvt.error_message('OZF_FUND_END_BEF_SUB_START', 'FUND_NAME', l_sub_rec.short_name);

490: x_return_status := fnd_api.g_ret_sts_error;
491: IF l_sub_rec.fund_type = 'QUOTA' THEN
492: ozf_utility_pvt.error_message('OZF_TP_END_BEF_SUB_START', 'FUND_NAME', l_sub_rec.short_name);
493: ELSE
494: ozf_utility_pvt.error_message('OZF_FUND_END_BEF_SUB_START', 'FUND_NAME', l_sub_rec.short_name);
495: END IF;
496: END IF;
497: END LOOP;
498: END check_fund_dates_vs_child;

Line 534: ozf_utility_pvt.error_message('OZF_TP_PAR_MISMATCH_CHILD_TYPE', 'FUND_NAME', l_sub_rec.short_name);

530: LOOP
531: --- fund type of the parent and child fund should be the same
532: IF p_fund_type <> l_sub_rec.fund_type THEN
533: IF l_sub_rec.fund_type = 'QUOTA' THEN
534: ozf_utility_pvt.error_message('OZF_TP_PAR_MISMATCH_CHILD_TYPE', 'FUND_NAME', l_sub_rec.short_name);
535: ELSE
536: ozf_utility_pvt.error_message('OZF_PAR_MISMATCH_CHILD_TYPE', 'FUND_NAME', l_sub_rec.short_name);
537: END IF;
538: x_return_status := fnd_api.g_ret_sts_error;

Line 536: ozf_utility_pvt.error_message('OZF_PAR_MISMATCH_CHILD_TYPE', 'FUND_NAME', l_sub_rec.short_name);

532: IF p_fund_type <> l_sub_rec.fund_type THEN
533: IF l_sub_rec.fund_type = 'QUOTA' THEN
534: ozf_utility_pvt.error_message('OZF_TP_PAR_MISMATCH_CHILD_TYPE', 'FUND_NAME', l_sub_rec.short_name);
535: ELSE
536: ozf_utility_pvt.error_message('OZF_PAR_MISMATCH_CHILD_TYPE', 'FUND_NAME', l_sub_rec.short_name);
537: END IF;
538: x_return_status := fnd_api.g_ret_sts_error;
539: END IF;
540: END LOOP;

Line 578: ozf_utility_pvt.error_message('OZF_TP_PAR_MISMATCH_CHILD_CURR', 'FUND_NAME', l_sub_rec.short_name);

574: LOOP
575: --- fund curr of the parent and child fund should be the same
576: IF p_fund_curr <> l_sub_rec.fund_curr THEN
577: IF l_sub_rec.fund_type = 'QUOTA' THEN
578: ozf_utility_pvt.error_message('OZF_TP_PAR_MISMATCH_CHILD_CURR', 'FUND_NAME', l_sub_rec.short_name);
579: ELSE
580: ozf_utility_pvt.error_message('OZF_PAR_MISMATCH_CHILD_CURR', 'FUND_NAME', l_sub_rec.short_name);
581: END IF;
582: x_return_status := fnd_api.g_ret_sts_error;

Line 580: ozf_utility_pvt.error_message('OZF_PAR_MISMATCH_CHILD_CURR', 'FUND_NAME', l_sub_rec.short_name);

576: IF p_fund_curr <> l_sub_rec.fund_curr THEN
577: IF l_sub_rec.fund_type = 'QUOTA' THEN
578: ozf_utility_pvt.error_message('OZF_TP_PAR_MISMATCH_CHILD_CURR', 'FUND_NAME', l_sub_rec.short_name);
579: ELSE
580: ozf_utility_pvt.error_message('OZF_PAR_MISMATCH_CHILD_CURR', 'FUND_NAME', l_sub_rec.short_name);
581: END IF;
582: x_return_status := fnd_api.g_ret_sts_error;
583: END IF;
584: END LOOP;

Line 681: ozf_utility_pvt.error_message('OZF_FUND_NO_CALENDAR');

677: IF p_fund_calendar IS NULL AND p_start_period_name IS NULL AND p_end_period_name IS NULL THEN
678: RETURN;
679: ELSIF p_fund_calendar IS NULL THEN
680: x_return_status := fnd_api.g_ret_sts_error;
681: ozf_utility_pvt.error_message('OZF_FUND_NO_CALENDAR');
682: RETURN;
683: END IF;
684:
685: -- check if p_fund_calendar is valid

Line 692: ozf_utility_pvt.error_message('OZF_FUND_BAD_CALENDAR');

688: CLOSE c_fund_calendar;
689:
690: IF l_local IS NULL THEN
691: x_return_status := fnd_api.g_ret_sts_error;
692: ozf_utility_pvt.error_message('OZF_FUND_BAD_CALENDAR');
693: RETURN;
694: END IF;
695:
696: -- check p_start_period_name

Line 711: ozf_utility_pvt.error_message('OZF_FUND_BAD_START_PERIOD');

707: END IF;
708:
709: IF l_start_start IS NULL THEN
710: x_return_status := fnd_api.g_ret_sts_error;
711: ozf_utility_pvt.error_message('OZF_FUND_BAD_START_PERIOD');
712: RETURN;
713: ELSIF p_start_date < l_start_start
714: OR p_start_date > l_start_end THEN
715: x_return_status := fnd_api.g_ret_sts_error;

Line 717: ozf_utility_pvt.error_message('OZF_TP_QUOTA_OUT_START_PERIOD');

713: ELSIF p_start_date < l_start_start
714: OR p_start_date > l_start_end THEN
715: x_return_status := fnd_api.g_ret_sts_error;
716: IF p_fund_type = 'QUOTA' THEN
717: ozf_utility_pvt.error_message('OZF_TP_QUOTA_OUT_START_PERIOD');
718: ELSE
719: ozf_utility_pvt.error_message('OZF_FUND_OUT_START_PERIOD');
720: END IF;
721: RETURN;

Line 719: ozf_utility_pvt.error_message('OZF_FUND_OUT_START_PERIOD');

715: x_return_status := fnd_api.g_ret_sts_error;
716: IF p_fund_type = 'QUOTA' THEN
717: ozf_utility_pvt.error_message('OZF_TP_QUOTA_OUT_START_PERIOD');
718: ELSE
719: ozf_utility_pvt.error_message('OZF_FUND_OUT_START_PERIOD');
720: END IF;
721: RETURN;
722: END IF;
723: END IF;

Line 739: ozf_utility_pvt.error_message('OZF_FUND_BAD_END_PERIOD');

735: END IF;
736:
737: IF l_end_end IS NULL THEN
738: x_return_status := fnd_api.g_ret_sts_error;
739: ozf_utility_pvt.error_message('OZF_FUND_BAD_END_PERIOD');
740: RETURN;
741: ELSIF TRUNC(p_end_date) < TRUNC(l_end_start)
742: OR TRUNC(p_end_date) > TRUNC(l_end_end) THEN
743: x_return_status := fnd_api.g_ret_sts_error;

Line 745: ozf_utility_pvt.error_message('OZF_TP_QUOTA_OUT_END_PERIOD');

741: ELSIF TRUNC(p_end_date) < TRUNC(l_end_start)
742: OR TRUNC(p_end_date) > TRUNC(l_end_end) THEN
743: x_return_status := fnd_api.g_ret_sts_error;
744: IF p_fund_type = 'QUOTA' THEN
745: ozf_utility_pvt.error_message('OZF_TP_QUOTA_OUT_END_PERIOD');
746: ELSE
747: ozf_utility_pvt.error_message('OZF_FUND_OUT_END_PERIOD');
748: END IF;
749: RETURN;

Line 747: ozf_utility_pvt.error_message('OZF_FUND_OUT_END_PERIOD');

743: x_return_status := fnd_api.g_ret_sts_error;
744: IF p_fund_type = 'QUOTA' THEN
745: ozf_utility_pvt.error_message('OZF_TP_QUOTA_OUT_END_PERIOD');
746: ELSE
747: ozf_utility_pvt.error_message('OZF_FUND_OUT_END_PERIOD');
748: END IF;
749: RETURN;
750: END IF;
751: END IF;

Line 756: ozf_utility_pvt.error_message('OZF_FUND_BAD_PERIODS');

752:
753: -- compare the start date and the end date
754: IF TRUNC(l_start_start) > TRUNC(l_end_end) THEN
755: x_return_status := fnd_api.g_ret_sts_error;
756: ozf_utility_pvt.error_message('OZF_FUND_BAD_PERIODS');
757: END IF;
758: END check_fund_calendar;
759:
760:

Line 847: ozf_utility_pvt.debug_message(l_full_name ||

843:
844: BEGIN
845: SAVEPOINT process_offers;
846: IF G_DEBUG THEN
847: ozf_utility_pvt.debug_message(l_full_name ||
848: ': create offers');
849: END IF;
850: x_return_status := fnd_api.g_ret_sts_success;
851:

Line 864: ozf_utility_pvt.debug_message('Create');

860: END IF;
861:
862: IF p_mode = 'CREATE' THEN
863: IF G_DEBUG THEN
864: ozf_utility_pvt.debug_message('Create');
865: END IF;
866: -- first process_offerss in QP
867: l_offer_hdr_rec.qp_list_header_id := fnd_api.g_miss_num;
868: l_offer_hdr_rec.activity_media_id := p_fund_rec.task_id;

Line 892: ozf_utility_pvt.debug_message(l_full_name ||

888: IF p_fund_rec.status_code = 'ACTIVE' THEN
889: */
890: IF p_fund_rec.status_code in ('ACTIVE','ON_HOLD') AND p_mode ='ACTIVE' THEN
891: IF G_DEBUG THEN
892: ozf_utility_pvt.debug_message(l_full_name ||
893: ': begin create act budgets ');
894: END IF;
895: -- Create_act_budgets for the created offers
896: l_act_budgets_rec_type.act_budget_used_by_id := p_fund_rec.plan_id;

Line 910: l_act_budgets_rec_type.user_status_id := ozf_utility_pvt.get_default_user_status(

906: l_act_budgets_rec_type.request_currency := p_fund_rec.currency_code_tc;
907: l_act_budgets_rec_type.request_date := SYSDATE;
908: l_act_budgets_rec_type.user_status_id := 5001;
909: l_act_budgets_rec_type.status_code := 'APPROVED';
910: l_act_budgets_rec_type.user_status_id := ozf_utility_pvt.get_default_user_status(
911: 'OZF_BUDGETSOURCE_STATUS',
912: 'APPROVED');
913: l_act_budgets_rec_type.approved_amount := NVL(p_fund_rec.accrual_cap, 0);
914: l_act_budgets_rec_type.approved_original_amount := NVL(p_fund_rec.accrual_cap, 0);

Line 938: ozf_utility_pvt.debug_message(l_full_name ||

934: RAISE fnd_api.g_exc_unexpected_error;
935: END IF;
936:
937: IF G_DEBUG THEN
938: ozf_utility_pvt.debug_message(l_full_name ||
939: ': end create budgets ');
940: END IF;
941: END IF; -- end if for active
942: /* -- 10/11/2002

Line 959: ozf_utility_pvt.debug_message('debug6');

955:
956: -- dbms_OUTPUT.put_line('fund_status ' ||
957: -- p_fund_rec.status_code);
958: IF G_DEBUG THEN
959: ozf_utility_pvt.debug_message('debug6');
960: END IF;
961: l_qp_list_header_id := p_fund_rec.plan_id;
962: IF G_DEBUG THEN
963: ozf_utility_pvt.debug_message('l_qp_list_header_id =>' ||

Line 963: ozf_utility_pvt.debug_message('l_qp_list_header_id =>' ||

959: ozf_utility_pvt.debug_message('debug6');
960: END IF;
961: l_qp_list_header_id := p_fund_rec.plan_id;
962: IF G_DEBUG THEN
963: ozf_utility_pvt.debug_message('l_qp_list_header_id =>' ||
964: l_qp_list_header_id);
965: END IF;
966: OPEN c_offer_id(l_qp_list_header_id);
967: FETCH c_offer_id INTO l_ozf_offer_id, l_offer_obj_ver_num;

Line 985: l_offer_hdr_rec.user_status_id := ozf_utility_pvt.get_default_user_status(

981: l_offer_hdr_rec.modifier_operation := 'UPDATE';
982: END IF; -- end if for p_mode
983:
984: IF p_fund_rec.status_code = 'CLOSED' THEN
985: l_offer_hdr_rec.user_status_id := ozf_utility_pvt.get_default_user_status(
986: l_status_type,
987: 'COMPLETED');
988: l_offer_hdr_rec.status_code := 'COMPLETED';
989: ELSIF p_fund_rec.status_code = 'CANCELLED' THEN

Line 990: l_offer_hdr_rec.user_status_id := ozf_utility_pvt.get_default_user_status(

986: l_status_type,
987: 'COMPLETED');
988: l_offer_hdr_rec.status_code := 'COMPLETED';
989: ELSIF p_fund_rec.status_code = 'CANCELLED' THEN
990: l_offer_hdr_rec.user_status_id := ozf_utility_pvt.get_default_user_status(
991: l_status_type,
992: 'TERMINATED');
993: l_offer_hdr_rec.status_code := 'TERMINATED';
994: ELSIF p_fund_rec.status_code = 'DRAFT' THEN

Line 996: l_offer_hdr_rec.user_status_id := ozf_utility_pvt.get_default_user_status(

992: 'TERMINATED');
993: l_offer_hdr_rec.status_code := 'TERMINATED';
994: ELSIF p_fund_rec.status_code = 'DRAFT' THEN
995: l_offer_hdr_rec.status_code := 'DRAFT';
996: l_offer_hdr_rec.user_status_id := ozf_utility_pvt.get_default_user_status(
997: l_status_type,
998: 'DRAFT');
999: ELSIF p_fund_rec.status_code = 'PENDING' THEN
1000: IF l_old_fund_status = 'REJECTED' THEN

Line 1002: l_offer_hdr_rec.user_status_id := ozf_utility_pvt.get_default_user_status(

998: 'DRAFT');
999: ELSIF p_fund_rec.status_code = 'PENDING' THEN
1000: IF l_old_fund_status = 'REJECTED' THEN
1001: l_offer_hdr_rec.status_code := 'REJECTED';
1002: l_offer_hdr_rec.user_status_id := ozf_utility_pvt.get_default_user_status(
1003: l_status_type,
1004: 'REJECTED');
1005: ELSE
1006: l_offer_hdr_rec.status_code := 'DRAFT';

Line 1007: l_offer_hdr_rec.user_status_id := ozf_utility_pvt.get_default_user_status(

1003: l_status_type,
1004: 'REJECTED');
1005: ELSE
1006: l_offer_hdr_rec.status_code := 'DRAFT';
1007: l_offer_hdr_rec.user_status_id := ozf_utility_pvt.get_default_user_status(
1008: l_status_type,
1009: 'DRAFT');
1010: END IF;
1011: l_offer_pending_flag := 'T';

Line 1013: ozf_utility_pvt.debug_message('debug5');

1009: 'DRAFT');
1010: END IF;
1011: l_offer_pending_flag := 'T';
1012: IF G_DEBUG THEN
1013: ozf_utility_pvt.debug_message('debug5');
1014: END IF;
1015: ELSIF p_fund_rec.status_code = 'ON_HOLD' THEN
1016: l_offer_hdr_rec.status_code := 'ONHOLD';
1017: l_offer_hdr_rec.user_status_id := ams_utility_pvt.get_default_user_status(

Line 1026: l_offer_hdr_rec.user_status_id := ozf_utility_pvt.get_default_user_status(

1022: l_offer_hdr_rec.user_status_id := ams_utility_pvt.get_default_user_status(
1023: l_status_type,
1024: 'REJECTED');
1025: ELSIF p_fund_rec.status_code = 'ACTIVE' THEN
1026: l_offer_hdr_rec.user_status_id := ozf_utility_pvt.get_default_user_status(
1027: l_status_type,
1028: 'ACTIVE');
1029: l_offer_hdr_rec.status_code := 'ACTIVE';
1030: END IF;

Line 1095: ozf_utility_pvt.debug_message('OZF_OFFR_UPDATE_SATAUS FAIL');

1091: );
1092:
1093: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1094: IF G_DEBUG THEN
1095: ozf_utility_pvt.debug_message('OZF_OFFR_UPDATE_SATAUS FAIL');
1096: END IF;
1097:
1098: IF l_return_status = fnd_api.g_ret_sts_error THEN
1099: RAISE fnd_api.g_exc_error;

Line 1107: ozf_utility_pvt.debug_message('process modifiers');

1103: END IF;
1104:
1105: ELSE
1106: IF G_DEBUG THEN
1107: ozf_utility_pvt.debug_message('process modifiers');
1108: END IF;
1109: ozf_offer_pvt.process_modifiers(
1110: p_init_msg_list=> fnd_api.g_false,
1111: p_api_version=> 1.0,

Line 1122: ozf_utility_pvt.debug_message(

1118: p_offer_type=> l_offer_hdr_rec.offer_type,
1119: x_qp_list_header_id=> l_qp_list_header_id,
1120: x_error_location=> l_error_location);
1121: IF G_DEBUG THEN
1122: ozf_utility_pvt.debug_message(
1123: 'l_return_status' ||
1124: l_return_status ||
1125: '-' ||
1126: l_error_location ||

Line 1133: ozf_utility_pvt.debug_message('OZF_OFFR_QP_FAILURE' ||

1129: END IF;
1130:
1131: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1132: IF G_DEBUG THEN
1133: ozf_utility_pvt.debug_message('OZF_OFFR_QP_FAILURE' ||
1134: l_error_location ||
1135: x_msg_data);
1136: END IF;
1137:

Line 1138: -- ozf_utility_pvt.error_message('OZF_OFFR_QP_FAILURE'||l_error_location||x_msg_data);

1134: l_error_location ||
1135: x_msg_data);
1136: END IF;
1137:
1138: -- ozf_utility_pvt.error_message('OZF_OFFR_QP_FAILURE'||l_error_location||x_msg_data);
1139: IF l_return_status = fnd_api.g_ret_sts_error THEN
1140: RAISE fnd_api.g_exc_error;
1141: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1142: RAISE fnd_api.g_exc_unexpected_error;

Line 1148: l_offer_hdr_rec.user_status_id := ozf_utility_pvt.get_default_user_status(l_status_type, 'PENDING');

1144: END IF;
1145:
1146: -- Update ozf_offers with status code 'PENDING' by incrementing object_version_number.
1147: IF l_offer_pending_flag = 'T' THEN
1148: l_offer_hdr_rec.user_status_id := ozf_utility_pvt.get_default_user_status(l_status_type, 'PENDING');
1149:
1150: -- 10/11/2002 mpande pass the default user status and check what is the default status code
1151: UPDATE ozf_offers
1152: SET status_code = 'PENDING',

Line 1158: ozf_utility_pvt.debug_message('In update 1');

1154: object_version_number = object_version_number + 1
1155: WHERE offer_id = l_ozf_offer_id;
1156:
1157: IF G_DEBUG THEN
1158: ozf_utility_pvt.debug_message('In update 1');
1159: END IF;
1160: END IF;
1161:
1162: IF p_mode = 'CREATE' THEN

Line 1170: ozf_utility_pvt.debug_message('qp_list_header_id =>' ||

1166: WHERE fund_id = p_fund_rec.fund_id;
1167: ELSIF p_mode = 'UPDATE' THEN
1168: l_qp_list_header_id := p_fund_rec.plan_id;
1169: IF G_DEBUG THEN
1170: ozf_utility_pvt.debug_message('qp_list_header_id =>' ||
1171: l_qp_list_header_id);
1172: END IF;
1173: END IF; -- end of p_mode = CREATE/UPDATE
1174:

Line 1176: ozf_utility_pvt.debug_message(l_full_name ||

1172: END IF;
1173: END IF; -- end of p_mode = CREATE/UPDATE
1174:
1175: IF G_DEBUG THEN
1176: ozf_utility_pvt.debug_message(l_full_name ||
1177: ': end update offer advanced option ');
1178: END IF;
1179: -- dbms_output.put_line('fundrules: process_modifiers to UPDATE returns ' || l_return_status || ' x_qp_list_header_id=' || l_qp_list_header_id);
1180: IF G_DEBUG THEN

Line 1181: ozf_utility_pvt.debug_message(l_full_name ||

1177: ': end update offer advanced option ');
1178: END IF;
1179: -- dbms_output.put_line('fundrules: process_modifiers to UPDATE returns ' || l_return_status || ' x_qp_list_header_id=' || l_qp_list_header_id);
1180: IF G_DEBUG THEN
1181: ozf_utility_pvt.debug_message(l_full_name ||
1182: ': begin exclusion ');
1183: END IF;
1184:
1185: --kdass 11-MAR-2004 fixed bug 3465281 - advanced options is handled by offers, budgets need to handle this

Line 1191: ozf_utility_pvt.debug_message(l_full_name ||

1187: -- for Fund_status = 'DRAFT' or p_mode = 'CREATE'.
1188: IF ( p_mode = 'CREATE'
1189: OR p_fund_rec.status_code = 'DRAFT') THEN
1190: IF G_DEBUG THEN
1191: ozf_utility_pvt.debug_message(l_full_name ||
1192: ': begin update offer advanced option ');
1193: END IF;
1194: --- 08/20/2001 mpande addded for discount level and bucket to process advanced options
1195: l_offer_advd_opt_rec.list_header_id := l_qp_list_header_id;

Line 1214: ozf_utility_pvt.debug_message('ret status for process adv options =>' ||

1210: x_msg_count=> l_msg_count,
1211: x_msg_data=> l_msg_data,
1212: p_advanced_options_rec=> l_offer_advd_opt_rec);
1213: IF G_DEBUG THEN
1214: ozf_utility_pvt.debug_message('ret status for process adv options =>' ||
1215: l_return_status);
1216: END IF;
1217:
1218: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 1348: ozf_utility_pvt.debug_message(l_full_name ||

1344: END IF;
1345: END IF;
1346:
1347: IF G_DEBUG THEN
1348: ozf_utility_pvt.debug_message(l_full_name ||
1349: ': end');
1350: END IF;
1351: EXCEPTION
1352: WHEN fnd_api.g_exc_error THEN

Line 1427: ozf_utility_pvt.error_message('OZF_TP_QUOTA_BAN_CLOSE');

1423: IF l_total_budget > l_committed_amt THEN
1424: -- total > committed >= utilized >= earned >= paid
1425: -- don't close budget because there's available money
1426: IF l_fund_type = 'QUOTA' THEN
1427: ozf_utility_pvt.error_message('OZF_TP_QUOTA_BAN_CLOSE');
1428: ELSE
1429: ozf_utility_pvt.error_message('OZF_FUND_BAN_CLOSE');
1430: END IF;
1431: x_return_status := fnd_api.g_ret_sts_error;

Line 1429: ozf_utility_pvt.error_message('OZF_FUND_BAN_CLOSE');

1425: -- don't close budget because there's available money
1426: IF l_fund_type = 'QUOTA' THEN
1427: ozf_utility_pvt.error_message('OZF_TP_QUOTA_BAN_CLOSE');
1428: ELSE
1429: ozf_utility_pvt.error_message('OZF_FUND_BAN_CLOSE');
1430: END IF;
1431: x_return_status := fnd_api.g_ret_sts_error;
1432: ELSIF l_total_budget < l_committed_amt THEN
1433: -- total < re-calculated committed This only happens when profile 'OZF_BUDGET_ADJ_ALLOW_RECAL' is 'Y'

Line 1437: ozf_utility_pvt.error_message('OZF_TP_QUOTA_BAN_CLOSE');

1433: -- total < re-calculated committed This only happens when profile 'OZF_BUDGET_ADJ_ALLOW_RECAL' is 'Y'
1434: -- don't close budget because re-calculated committed has committed funds for over the pool of money originally available,
1435: -- need a budget transfer into the budget
1436: IF l_fund_type = 'QUOTA' THEN
1437: ozf_utility_pvt.error_message('OZF_TP_QUOTA_BAN_CLOSE');
1438: ELSE
1439: ozf_utility_pvt.error_message('OZF_FUND_BAN_CLOSE_COMM_MORE');
1440: END IF;
1441: x_return_status := fnd_api.g_ret_sts_error;

Line 1439: ozf_utility_pvt.error_message('OZF_FUND_BAN_CLOSE_COMM_MORE');

1435: -- need a budget transfer into the budget
1436: IF l_fund_type = 'QUOTA' THEN
1437: ozf_utility_pvt.error_message('OZF_TP_QUOTA_BAN_CLOSE');
1438: ELSE
1439: ozf_utility_pvt.error_message('OZF_FUND_BAN_CLOSE_COMM_MORE');
1440: END IF;
1441: x_return_status := fnd_api.g_ret_sts_error;
1442: ELSE
1443: -- total = committed

Line 1448: ozf_utility_pvt.error_message('OZF_TP_QUOTA_BAN_CLOSE');

1444: IF l_committed_amt > l_utilized_amt THEN
1445: -- total = calculated committed > utilized
1446: -- don't close budget because there is committed fund but not yet utilized
1447: IF l_fund_type = 'QUOTA' THEN
1448: ozf_utility_pvt.error_message('OZF_TP_QUOTA_BAN_CLOSE');
1449: ELSE
1450: ozf_utility_pvt.error_message('OZF_FUND_BAN_CLOSE_UTIL_LESS');
1451: END IF;
1452: x_return_status := fnd_api.g_ret_sts_error;

Line 1450: ozf_utility_pvt.error_message('OZF_FUND_BAN_CLOSE_UTIL_LESS');

1446: -- don't close budget because there is committed fund but not yet utilized
1447: IF l_fund_type = 'QUOTA' THEN
1448: ozf_utility_pvt.error_message('OZF_TP_QUOTA_BAN_CLOSE');
1449: ELSE
1450: ozf_utility_pvt.error_message('OZF_FUND_BAN_CLOSE_UTIL_LESS');
1451: END IF;
1452: x_return_status := fnd_api.g_ret_sts_error;
1453: ELSIF l_committed_amt = l_utilized_amt THEN
1454: -- total = committed = utilized

Line 1459: ozf_utility_pvt.error_message('OZF_TP_QUOTA_BAN_CLOSE');

1455: IF l_utilized_amt > l_earned_amt THEN
1456: -- total = calculated committed = utilized > earned
1457: -- don't close budget because there is utilized fund but not yet posted to GL
1458: IF l_fund_type = 'QUOTA' THEN
1459: ozf_utility_pvt.error_message('OZF_TP_QUOTA_BAN_CLOSE');
1460: ELSE
1461: ozf_utility_pvt.error_message('OZF_FUND_BAN_CLOSE_EARN_LESS');
1462: END IF;
1463: x_return_status := fnd_api.g_ret_sts_error;

Line 1461: ozf_utility_pvt.error_message('OZF_FUND_BAN_CLOSE_EARN_LESS');

1457: -- don't close budget because there is utilized fund but not yet posted to GL
1458: IF l_fund_type = 'QUOTA' THEN
1459: ozf_utility_pvt.error_message('OZF_TP_QUOTA_BAN_CLOSE');
1460: ELSE
1461: ozf_utility_pvt.error_message('OZF_FUND_BAN_CLOSE_EARN_LESS');
1462: END IF;
1463: x_return_status := fnd_api.g_ret_sts_error;
1464: ELSIF l_utilized_amt = l_earned_amt THEN
1465: -- total = calculated committed = utilized = earned

Line 1471: ozf_utility_pvt.error_message('OZF_TP_QUOTA_BAN_CLOSE');

1467: -- total = re-calculated committed = utilized = earned > paid
1468: -- don't close budget because there's un-paid fund (trade management is implemented,
1469: -- accrual earnings not paid out by claim or deduction yet).
1470: IF l_fund_type = 'QUOTA' THEN
1471: ozf_utility_pvt.error_message('OZF_TP_QUOTA_BAN_CLOSE');
1472: ELSE
1473: ozf_utility_pvt.error_message('OZF_FUND_BAN_CLOSE_PAID_LESS');
1474: END IF;
1475: x_return_status := fnd_api.g_ret_sts_error;

Line 1473: ozf_utility_pvt.error_message('OZF_FUND_BAN_CLOSE_PAID_LESS');

1469: -- accrual earnings not paid out by claim or deduction yet).
1470: IF l_fund_type = 'QUOTA' THEN
1471: ozf_utility_pvt.error_message('OZF_TP_QUOTA_BAN_CLOSE');
1472: ELSE
1473: ozf_utility_pvt.error_message('OZF_FUND_BAN_CLOSE_PAID_LESS');
1474: END IF;
1475: x_return_status := fnd_api.g_ret_sts_error;
1476: ELSIF l_earned_amt = l_paid_amt THEN
1477: -- total = re-calculated committed = utilized = earned = paid

Line 1560: ozf_utility_pvt.debug_message(l_full_name ||

1556:
1557: BEGIN
1558: SAVEPOINT update_fund_status;
1559: IF G_DEBUG THEN
1560: ozf_utility_pvt.debug_message(l_full_name ||
1561: '- enter');
1562: END IF;
1563: x_return_status := fnd_api.g_ret_sts_success;
1564: -- initiallize the out params 08/14/2001 mpande added

Line 1571: l_reject_status_id := ozf_utility_pvt.get_default_user_status(l_status_type, 'REJECTED');

1567: --Get old_status
1568: OPEN l_old_status;
1569: FETCH l_old_status INTO l_old_status_code, l_old_user_status_id, l_old_owner_id, l_fund_type, l_plan_id;
1570: CLOSE l_old_status;
1571: l_reject_status_id := ozf_utility_pvt.get_default_user_status(l_status_type, 'REJECTED');
1572: l_new_status_code := p_fund_rec.status_code;
1573:
1574: IF l_old_status_code <> l_new_status_code THEN
1575: IF l_old_status_code IN ('CLOSED', 'ARCHIVED', 'CANCELLED') THEN

Line 1578: ozf_utility_pvt.debug_message(l_full_name ||

1574: IF l_old_status_code <> l_new_status_code THEN
1575: IF l_old_status_code IN ('CLOSED', 'ARCHIVED', 'CANCELLED') THEN
1576: IF l_new_status_code NOT IN ('ARCHIVED') THEN
1577: IF G_DEBUG THEN
1578: ozf_utility_pvt.debug_message(l_full_name ||
1579: 'fund closed');
1580: END IF;
1581: IF l_fund_type = 'QUOTA' THEN
1582: ozf_utility_pvt.error_message('OZF_TP_QUOTA_BAN_UPDATE');

Line 1582: ozf_utility_pvt.error_message('OZF_TP_QUOTA_BAN_UPDATE');

1578: ozf_utility_pvt.debug_message(l_full_name ||
1579: 'fund closed');
1580: END IF;
1581: IF l_fund_type = 'QUOTA' THEN
1582: ozf_utility_pvt.error_message('OZF_TP_QUOTA_BAN_UPDATE');
1583: ELSE
1584: ozf_utility_pvt.error_message('OZF_FUND_BAN_UPDATE');
1585: END IF;
1586: --return the old status

Line 1584: ozf_utility_pvt.error_message('OZF_FUND_BAN_UPDATE');

1580: END IF;
1581: IF l_fund_type = 'QUOTA' THEN
1582: ozf_utility_pvt.error_message('OZF_TP_QUOTA_BAN_UPDATE');
1583: ELSE
1584: ozf_utility_pvt.error_message('OZF_FUND_BAN_UPDATE');
1585: END IF;
1586: --return the old status
1587: x_new_status_id := l_old_user_status_id;
1588: x_new_status_code := l_old_status_code;

Line 1604: ozf_utility_pvt.debug_message(l_full_name ||

1600: ELSIF l_old_status_code = 'PENDING' THEN
1601: IF l_new_status_code IN ('ACTIVE', 'ON_HOLD') THEN
1602: --The following subroutine will take care of all the processing that take place for a active fund.
1603: IF G_DEBUG THEN
1604: ozf_utility_pvt.debug_message(l_full_name ||
1605: 'fund aproved');
1606: END IF;
1607: x_new_status_id := ozf_utility_pvt.get_default_user_status(l_status_type, l_new_status_code);
1608: x_new_status_code := l_new_status_code;

Line 1607: x_new_status_id := ozf_utility_pvt.get_default_user_status(l_status_type, l_new_status_code);

1603: IF G_DEBUG THEN
1604: ozf_utility_pvt.debug_message(l_full_name ||
1605: 'fund aproved');
1606: END IF;
1607: x_new_status_id := ozf_utility_pvt.get_default_user_status(l_status_type, l_new_status_code);
1608: x_new_status_code := l_new_status_code;
1609: --END IF;
1610: ELSIF l_new_status_code = 'REJECTED' THEN
1611: -- Update the fund with status REJECTED

Line 1613: ozf_utility_pvt.debug_message(l_full_name ||

1609: --END IF;
1610: ELSIF l_new_status_code = 'REJECTED' THEN
1611: -- Update the fund with status REJECTED
1612: IF G_DEBUG THEN
1613: ozf_utility_pvt.debug_message(l_full_name ||
1614: 'fund rejected');
1615: END IF;
1616: x_new_status_id := ozf_utility_pvt.get_default_user_status(l_status_type, 'REJECTED');
1617: x_new_status_code := 'REJECTED';

Line 1616: x_new_status_id := ozf_utility_pvt.get_default_user_status(l_status_type, 'REJECTED');

1612: IF G_DEBUG THEN
1613: ozf_utility_pvt.debug_message(l_full_name ||
1614: 'fund rejected');
1615: END IF;
1616: x_new_status_id := ozf_utility_pvt.get_default_user_status(l_status_type, 'REJECTED');
1617: x_new_status_code := 'REJECTED';
1618: ELSIF l_new_status_code = 'DRAFT' THEN
1619: --An error occurred during the approval process, revert back to 'DRAFT
1620: --Update the fund with status 'DRAFT'

Line 1622: ozf_utility_pvt.debug_message(l_full_name ||

1618: ELSIF l_new_status_code = 'DRAFT' THEN
1619: --An error occurred during the approval process, revert back to 'DRAFT
1620: --Update the fund with status 'DRAFT'
1621: IF G_DEBUG THEN
1622: ozf_utility_pvt.debug_message(l_full_name ||
1623: 'error in aproval');
1624: END IF;
1625: x_new_status_id := ozf_utility_pvt.get_default_user_status(l_status_type, 'DRAFT');
1626: x_new_status_code := 'DRAFT';

Line 1625: x_new_status_id := ozf_utility_pvt.get_default_user_status(l_status_type, 'DRAFT');

1621: IF G_DEBUG THEN
1622: ozf_utility_pvt.debug_message(l_full_name ||
1623: 'error in aproval');
1624: END IF;
1625: x_new_status_id := ozf_utility_pvt.get_default_user_status(l_status_type, 'DRAFT');
1626: x_new_status_code := 'DRAFT';
1627: END IF; -- end pending
1628: ELSIF l_old_status_code IN ('DRAFT', 'REJECTED') THEN
1629: IF l_new_status_code IN ('ACTIVE', 'ON_HOLD') THEN

Line 1632: ozf_utility_pvt.write_conc_log(' The fund_usage is Mass Transfer');

1628: ELSIF l_old_status_code IN ('DRAFT', 'REJECTED') THEN
1629: IF l_new_status_code IN ('ACTIVE', 'ON_HOLD') THEN
1630: -- niprakas added
1631: IF (p_fund_rec.fund_usage = 'MTRAN') THEN
1632: ozf_utility_pvt.write_conc_log(' The fund_usage is Mass Transfer');
1633: x_new_status_id := ozf_utility_pvt.get_default_user_status(
1634: l_status_type,
1635: l_new_status_code);
1636: x_new_status_code := l_new_status_code;

Line 1633: x_new_status_id := ozf_utility_pvt.get_default_user_status(

1629: IF l_new_status_code IN ('ACTIVE', 'ON_HOLD') THEN
1630: -- niprakas added
1631: IF (p_fund_rec.fund_usage = 'MTRAN') THEN
1632: ozf_utility_pvt.write_conc_log(' The fund_usage is Mass Transfer');
1633: x_new_status_id := ozf_utility_pvt.get_default_user_status(
1634: l_status_type,
1635: l_new_status_code);
1636: x_new_status_code := l_new_status_code;
1637: IF p_fund_rec.parent_fund_id IS NOT NULL THEN

Line 1645: x_new_status_id := ozf_utility_pvt.get_default_user_status(

1641: -- niprakas ends
1642:
1643: IF (p_fund_rec.fund_usage = 'ALLOC') THEN
1644: -- yzhao: 02/26/2003 fix bug bug 2823606 - when called from budget allocation activation, approval is not needed
1645: x_new_status_id := ozf_utility_pvt.get_default_user_status(
1646: l_status_type,
1647: l_new_status_code);
1648: x_new_status_code := l_new_status_code;
1649: IF p_fund_rec.parent_fund_id IS NOT NULL THEN

Line 1676: ozf_utility_pvt.debug_message(l_full_name ||

1672: -- changing status from 'DRAFT or 'REJECTED' to 'ACTIVE or ON_HOLD is
1673: -- equivalent to submitting for approval.
1674: -- Approval submission child fund
1675: IF G_DEBUG THEN
1676: ozf_utility_pvt.debug_message(l_full_name ||
1677: 'owner' ||
1678: p_fund_rec.owner);
1679: END IF;
1680: x_submit_child_approval := fnd_api.g_true;

Line 1705: x_new_status_id := ozf_utility_pvt.get_default_user_status(l_status_type, 'PENDING');

1701: l_is_requestor_owner := 'N';
1702: END IF;
1703:
1704: IF l_is_requestor_owner = 'N' THEN
1705: x_new_status_id := ozf_utility_pvt.get_default_user_status(l_status_type, 'PENDING');
1706: x_new_status_code := 'PENDING';
1707: ELSE
1708: x_new_status_id := ozf_utility_pvt.get_default_user_status(
1709: l_status_type,

Line 1708: x_new_status_id := ozf_utility_pvt.get_default_user_status(

1704: IF l_is_requestor_owner = 'N' THEN
1705: x_new_status_id := ozf_utility_pvt.get_default_user_status(l_status_type, 'PENDING');
1706: x_new_status_code := 'PENDING';
1707: ELSE
1708: x_new_status_id := ozf_utility_pvt.get_default_user_status(
1709: l_status_type,
1710: l_new_status_code);
1711: x_new_status_code := l_new_status_code;
1712: END IF;

Line 1718: ozf_utility_pvt.debug_message('Approval');

1714: -- Here Approval submission would be done for parent less fund
1715: -- call the approval API**********************************
1716: -- the approval API would updatethe fund status to pending
1717: IF G_DEBUG THEN
1718: ozf_utility_pvt.debug_message('Approval');
1719: END IF;
1720: x_submit_budget_approval := fnd_api.g_true;
1721: x_new_status_id := ozf_utility_pvt.get_default_user_status(l_status_type, 'PENDING');
1722: x_new_status_code := 'PENDING';

Line 1721: x_new_status_id := ozf_utility_pvt.get_default_user_status(l_status_type, 'PENDING');

1717: IF G_DEBUG THEN
1718: ozf_utility_pvt.debug_message('Approval');
1719: END IF;
1720: x_submit_budget_approval := fnd_api.g_true;
1721: x_new_status_id := ozf_utility_pvt.get_default_user_status(l_status_type, 'PENDING');
1722: x_new_status_code := 'PENDING';
1723: END IF; -- end of parent fund id check
1724: END IF; -- IF (p_fund_rec.fund_usage == 'ALLOC')
1725: -- 07/03/2001 bUG#1540719 -- Cancelled spellingwas incorrect

Line 1727: ozf_utility_pvt.error_message('OZF_FUND_WRONG_STATUS');

1723: END IF; -- end of parent fund id check
1724: END IF; -- IF (p_fund_rec.fund_usage == 'ALLOC')
1725: -- 07/03/2001 bUG#1540719 -- Cancelled spellingwas incorrect
1726: ELSIF l_new_status_code NOT IN ('CANCELLED') THEN
1727: ozf_utility_pvt.error_message('OZF_FUND_WRONG_STATUS');
1728: --return the old status
1729: x_new_status_id := l_old_user_status_id;
1730: x_new_status_code := l_old_status_code;
1731: x_return_status := fnd_api.g_ret_sts_error;

Line 1766: ozf_utility_pvt.error_message('OZF_FUND_WRONG_STATUS');

1762: -- 05/11/2003 niprakas else loop ends here for the bug#2950428
1763:
1764: ELSE
1765: -- Invalid status change, should not get here.
1766: ozf_utility_pvt.error_message('OZF_FUND_WRONG_STATUS');
1767: -- return the old status
1768: x_new_status_id := l_old_user_status_id;
1769: x_new_status_code := l_old_status_code;
1770: x_return_status := fnd_api.g_ret_sts_error;

Line 1783: ozf_utility_pvt.debug_message(l_full_name ||

1779: ELSIF l_old_status_code IN ('ACTIVE','CANCELLED','CLOSED','ARCHIVED','ON_HOLD') THEN
1780: */
1781: ELSIF l_old_status_code IN ('ACTIVE', 'ON_HOLD') THEN
1782: IF G_DEBUG THEN
1783: ozf_utility_pvt.debug_message(l_full_name ||
1784: 'fund no update except owner');
1785: END IF;
1786: --06/04/2001 added validations for accrual type fund
1787: -- all locking rules are to be implemented by locking rules so I am not raising a error here

Line 1789: l_resource_id := ozf_utility_pvt.get_resource_id(p_user_id => fnd_global.user_id);

1785: END IF;
1786: --06/04/2001 added validations for accrual type fund
1787: -- all locking rules are to be implemented by locking rules so I am not raising a error here
1788: -- Accrual Type Offer could be modified
1789: l_resource_id := ozf_utility_pvt.get_resource_id(p_user_id => fnd_global.user_id);
1790:
1791: -- the owner could be changed in a active status by the current owner
1792: -- 12/18/2001 yzhao: owner could be changed by super admin too
1793: IF p_fund_rec.owner <> l_old_owner_id THEN

Line 1800: --ozf_utility_pvt.error_message('OZF_FUND_BAN_UPDATE');

1796: x_new_status_id := l_old_user_status_id;
1797: x_new_status_code := l_old_status_code;
1798: x_return_status := fnd_api.g_ret_sts_success;
1799: ELSE
1800: --ozf_utility_pvt.error_message('OZF_FUND_BAN_UPDATE');
1801: IF l_fund_type = 'QUOTA' THEN
1802: ozf_utility_pvt.error_message('OZF_TP_QUOTA_UPDT_OWNER_PERM');
1803: ELSE
1804: ozf_utility_pvt.error_message('OZF_FUND_UPDT_OWNER_PERM');

Line 1802: ozf_utility_pvt.error_message('OZF_TP_QUOTA_UPDT_OWNER_PERM');

1798: x_return_status := fnd_api.g_ret_sts_success;
1799: ELSE
1800: --ozf_utility_pvt.error_message('OZF_FUND_BAN_UPDATE');
1801: IF l_fund_type = 'QUOTA' THEN
1802: ozf_utility_pvt.error_message('OZF_TP_QUOTA_UPDT_OWNER_PERM');
1803: ELSE
1804: ozf_utility_pvt.error_message('OZF_FUND_UPDT_OWNER_PERM');
1805: END IF;
1806: --return the old status

Line 1804: ozf_utility_pvt.error_message('OZF_FUND_UPDT_OWNER_PERM');

1800: --ozf_utility_pvt.error_message('OZF_FUND_BAN_UPDATE');
1801: IF l_fund_type = 'QUOTA' THEN
1802: ozf_utility_pvt.error_message('OZF_TP_QUOTA_UPDT_OWNER_PERM');
1803: ELSE
1804: ozf_utility_pvt.error_message('OZF_FUND_UPDT_OWNER_PERM');
1805: END IF;
1806: --return the old status
1807: x_new_status_id := l_old_user_status_id;
1808: x_new_status_code := l_old_status_code;

Line 1828: ozf_utility_pvt.debug_message(l_full_name ||

1824: x_new_status_id := p_fund_rec.user_status_id;
1825: END IF; --check for old and new diff
1826:
1827: IF G_DEBUG THEN
1828: ozf_utility_pvt.debug_message(l_full_name ||
1829: ': end');
1830: END IF;
1831: EXCEPTION
1832: WHEN fnd_api.g_exc_error THEN

Line 1902: ozf_utility_pvt.debug_message(l_full_name ||

1898: l_fund_status VARCHAR2(30);
1899: l_accrual_basis VARCHAR2(30);
1900: BEGIN
1901: IF G_DEBUG THEN
1902: ozf_utility_pvt.debug_message(l_full_name ||
1903: ': begin');
1904: END IF;
1905: SAVEPOINT process_accrual;
1906: x_return_status := fnd_api.g_ret_sts_success;