[Home] [Help]
1107: IF G_DEBUG THEN
1108: OZF_UTILITY_PVT.DEBUG_MESSAGE('ACCRUAL BASIS ='||L_FUND_REC.accrual_basis);
1109: END IF;
1110: IF p_fund_rec.fund_type = 'FULLY_ACCRUED' AND p_fund_rec.plan_id is null THEN
1111: ozf_fundrules_pvt.process_accrual (
1112: p_fund_rec => l_fund_rec
1113: ,p_api_version => l_api_version
1114: ,p_mode => 'CREATE'
1115: ,x_return_status => l_return_status
2096: -- Update fund could be called by other APIS in active status to update earned amt or committed amt .
2097: -- We do allow them to update the record then
2098: IF l_return_status = fnd_api.g_ret_sts_success THEN
2099: IF p_mode IN (jtf_PLSQL_API.G_UPDATE, 'WORKFLOW') THEN
2100: Ozf_fundrules_pvt.update_fund_status(
2101: p_fund_rec => l_fund_rec
2102: /* yzhao: 11/26/2002 how weird to pass IN parameter l_fund_rec, and use member as OUT parameter
2103: most importantly, it breaks with NOCOPY hint
2104: ,x_new_status_code => l_fund_rec.status_code
2614: l_mode := 'ACTIVE' ; -- when creating act budgets for active funds
2615: END IF;
2616: -- call when it is active after submitting for approval
2617: IF l_mode IN ('ACTIVE' , 'UPDATE' ) THEN
2618: ozf_fundrules_pvt.process_approval(
2619: p_fund_rec => l_fund_rec
2620: ,p_mode => l_mode
2621: ,p_old_fund_status => l_old_status
2622: ,x_return_status => l_return_status
3829: --- for a active accrual fund product eligibiilty should exist 01/20/2001 mpande
3830: -- not when a active fund is created automatically
3831: IF p_complete_rec.status_code = 'ACTIVE' AND
3832: p_mode <> jtf_plsql_api.g_create THEN
3833: Ozf_fundrules_pvt.check_product_elig_exists(
3834: p_complete_rec.fund_id
3835: ,l_return_status);
3836:
3837: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3925: OR p_fund_rec.start_period_name <> fnd_api.g_miss_char
3926: OR p_fund_rec.end_period_name <> fnd_api.g_miss_char
3927: OR p_fund_rec.start_date_active <> fnd_api.g_miss_date
3928: OR p_fund_rec.end_date_active <> fnd_api.g_miss_date THEN
3929: Ozf_fundrules_pvt.check_fund_calendar(
3930: p_complete_rec.fund_calendar
3931: ,p_complete_rec.start_period_name
3932: ,p_complete_rec.end_period_name
3933: ,p_complete_rec.start_date_active
3942:
3943: ------------------- check dates ------------------------------
3944: IF p_fund_rec.start_date_active <> fnd_api.g_miss_date
3945: OR p_fund_rec.end_date_active <> fnd_api.g_miss_date THEN
3946: Ozf_fundrules_pvt.check_fund_dates_vs_parent(
3947: p_complete_rec.parent_fund_id
3948: ,p_complete_rec.start_date_active
3949: ,p_complete_rec.end_date_active
3950: ,l_return_status);
3953: x_return_status := l_return_status;
3954: END IF;
3955:
3956: IF p_validation_mode = jtf_plsql_api.g_update THEN
3957: Ozf_fundrules_pvt.check_fund_dates_vs_child(
3958: p_complete_rec.fund_id
3959: ,p_complete_rec.start_date_active
3960: ,p_complete_rec.end_date_active
3961: ,l_return_status);
3972: IF p_fund_rec.original_budget <> fnd_api.g_miss_num
3973: OR p_fund_rec.transfered_in_amt <> fnd_api.g_miss_num
3974: OR p_fund_rec.transfered_out_amt <> fnd_api.g_miss_num THEN
3975: -- updated 09/04/2001 mpande for Multi Currency Child
3976: Ozf_fundrules_pvt.check_fund_amount_vs_parent(
3977: p_complete_rec.parent_fund_id
3978: ,p_complete_rec.currency_code_tc
3979: ,p_complete_rec.original_budget
3980: ,l_return_status);
3984: END IF;
3985:
3986: IF p_validation_mode = jtf_plsql_api.g_update THEN
3987: -- updated 09/04/2001 mpande for Multi Currency Child
3988: Ozf_fundrules_pvt.check_fund_amount_vs_child(
3989: p_complete_rec.fund_id
3990: ,p_complete_rec.original_budget
3991: ,p_complete_rec.transfered_in_amt
3992: ,p_complete_rec.transfered_out_amt
4003: ------------------- check fund type ------------------------------
4004: IF p_fund_rec.fund_type <> fnd_api.g_miss_char
4005: OR p_fund_rec.parent_fund_id <> fnd_api.g_miss_num THEN
4006: --- the chikd parent validation is done always
4007: Ozf_fundrules_pvt.check_fund_type_vs_parent(
4008: p_complete_rec.parent_fund_id
4009: ,p_complete_rec.fund_type
4010: ,l_return_status);
4011:
4016: -- check for change of fund type only when the status is going active
4017: -- cause in a draft mode the user can change the fund type
4018: IF p_validation_mode = jtf_plsql_api.g_update
4019: AND p_complete_rec.status_code = 'ACTIVE' THEN
4020: Ozf_fundrules_pvt.check_fund_type_vs_child(
4021: p_complete_rec.fund_id
4022: ,p_complete_rec.fund_type
4023: ,l_return_status);
4024:
4033: /*
4034: IF p_fund_rec.currency_code_tc <> fnd_api.g_miss_char
4035: OR p_fund_rec.parent_fund_id <> fnd_api.g_miss_num THEN
4036: --- the child parent validation is done always
4037: Ozf_fundrules_pvt.check_fund_curr_vs_parent(
4038: p_complete_rec.parent_fund_id
4039: ,p_complete_rec.currency_code_tc
4040: ,l_return_status);
4041:
4046: -- check for change of fund currency only when the status is going active
4047: -- cause in a draft mode the user can change the fund currency
4048: IF p_validation_mode = jtf_plsql_api.g_update
4049: AND p_complete_rec.status_code = 'ACTIVE' THEN
4050: Ozf_fundrules_pvt.check_fund_curr_vs_child(
4051: p_complete_rec.fund_id
4052: ,p_complete_rec.currency_code_tc
4053: ,l_return_status);
4054:
4061:
4062: ------------------- check fund_status ------------------------------
4063: IF p_fund_rec.status_code <> fnd_api.g_miss_char
4064: OR p_fund_rec.parent_fund_id <> fnd_api.g_miss_num THEN
4065: Ozf_fundrules_pvt.check_fund_status_vs_parent(
4066: p_complete_rec.parent_fund_id
4067: ,p_complete_rec.status_code
4068: ,l_return_status);
4069: