[Home] [Help]
1115: IF G_DEBUG THEN
1116: OZF_UTILITY_PVT.DEBUG_MESSAGE('ACCRUAL BASIS ='||L_FUND_REC.accrual_basis);
1117: END IF;
1118: IF p_fund_rec.fund_type = 'FULLY_ACCRUED' AND p_fund_rec.plan_id is null THEN
1119: ozf_fundrules_pvt.process_accrual (
1120: p_fund_rec => l_fund_rec
1121: ,p_api_version => l_api_version
1122: ,p_mode => 'CREATE'
1123: ,x_return_status => l_return_status
2293: -- Update fund could be called by other APIS in active status to update earned amt or committed amt .
2294: -- We do allow them to update the record then
2295: IF l_return_status = fnd_api.g_ret_sts_success THEN
2296: IF p_mode IN (jtf_PLSQL_API.G_UPDATE, 'WORKFLOW') THEN
2297: Ozf_fundrules_pvt.update_fund_status(
2298: p_fund_rec => l_fund_rec
2299: /* yzhao: 11/26/2002 how weird to pass IN parameter l_fund_rec, and use member as OUT parameter
2300: most importantly, it breaks with NOCOPY hint
2301: ,x_new_status_code => l_fund_rec.status_code
3011: l_mode := 'ACTIVE' ; -- when creating act budgets for active funds
3012: END IF;
3013: -- call when it is active after submitting for approval
3014: IF l_mode IN ('ACTIVE' , 'UPDATE' ) THEN
3015: ozf_fundrules_pvt.process_approval(
3016: p_fund_rec => l_fund_rec
3017: ,p_mode => l_mode
3018: ,p_old_fund_status => l_old_status
3019: ,x_return_status => l_return_status
4231: --- for a active accrual fund product eligibiilty should exist 01/20/2001 mpande
4232: -- not when a active fund is created automatically
4233: IF p_complete_rec.status_code = 'ACTIVE' AND
4234: p_mode <> jtf_plsql_api.g_create THEN
4235: Ozf_fundrules_pvt.check_product_elig_exists(
4236: p_complete_rec.fund_id
4237: ,l_return_status);
4238:
4239: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4327: OR p_fund_rec.start_period_name <> fnd_api.g_miss_char
4328: OR p_fund_rec.end_period_name <> fnd_api.g_miss_char
4329: OR p_fund_rec.start_date_active <> fnd_api.g_miss_date
4330: OR p_fund_rec.end_date_active <> fnd_api.g_miss_date THEN
4331: Ozf_fundrules_pvt.check_fund_calendar(
4332: p_complete_rec.fund_calendar
4333: ,p_complete_rec.start_period_name
4334: ,p_complete_rec.end_period_name
4335: ,p_complete_rec.start_date_active
4344:
4345: ------------------- check dates ------------------------------
4346: IF p_fund_rec.start_date_active <> fnd_api.g_miss_date
4347: OR p_fund_rec.end_date_active <> fnd_api.g_miss_date THEN
4348: Ozf_fundrules_pvt.check_fund_dates_vs_parent(
4349: p_complete_rec.parent_fund_id
4350: ,p_complete_rec.start_date_active
4351: ,p_complete_rec.end_date_active
4352: ,l_return_status);
4355: x_return_status := l_return_status;
4356: END IF;
4357:
4358: IF p_validation_mode = jtf_plsql_api.g_update THEN
4359: Ozf_fundrules_pvt.check_fund_dates_vs_child(
4360: p_complete_rec.fund_id
4361: ,p_complete_rec.start_date_active
4362: ,p_complete_rec.end_date_active
4363: ,l_return_status);
4374: IF p_fund_rec.original_budget <> fnd_api.g_miss_num
4375: OR p_fund_rec.transfered_in_amt <> fnd_api.g_miss_num
4376: OR p_fund_rec.transfered_out_amt <> fnd_api.g_miss_num THEN
4377: -- updated 09/04/2001 mpande for Multi Currency Child
4378: Ozf_fundrules_pvt.check_fund_amount_vs_parent(
4379: p_complete_rec.parent_fund_id
4380: ,p_complete_rec.currency_code_tc
4381: ,p_complete_rec.original_budget
4382: ,l_return_status);
4386: END IF;
4387:
4388: IF p_validation_mode = jtf_plsql_api.g_update THEN
4389: -- updated 09/04/2001 mpande for Multi Currency Child
4390: Ozf_fundrules_pvt.check_fund_amount_vs_child(
4391: p_complete_rec.fund_id
4392: ,p_complete_rec.original_budget
4393: ,p_complete_rec.transfered_in_amt
4394: ,p_complete_rec.transfered_out_amt
4405: ------------------- check fund type ------------------------------
4406: IF p_fund_rec.fund_type <> fnd_api.g_miss_char
4407: OR p_fund_rec.parent_fund_id <> fnd_api.g_miss_num THEN
4408: --- the chikd parent validation is done always
4409: Ozf_fundrules_pvt.check_fund_type_vs_parent(
4410: p_complete_rec.parent_fund_id
4411: ,p_complete_rec.fund_type
4412: ,l_return_status);
4413:
4418: -- check for change of fund type only when the status is going active
4419: -- cause in a draft mode the user can change the fund type
4420: IF p_validation_mode = jtf_plsql_api.g_update
4421: AND p_complete_rec.status_code = 'ACTIVE' THEN
4422: Ozf_fundrules_pvt.check_fund_type_vs_child(
4423: p_complete_rec.fund_id
4424: ,p_complete_rec.fund_type
4425: ,l_return_status);
4426:
4435: /*
4436: IF p_fund_rec.currency_code_tc <> fnd_api.g_miss_char
4437: OR p_fund_rec.parent_fund_id <> fnd_api.g_miss_num THEN
4438: --- the child parent validation is done always
4439: Ozf_fundrules_pvt.check_fund_curr_vs_parent(
4440: p_complete_rec.parent_fund_id
4441: ,p_complete_rec.currency_code_tc
4442: ,l_return_status);
4443:
4448: -- check for change of fund currency only when the status is going active
4449: -- cause in a draft mode the user can change the fund currency
4450: IF p_validation_mode = jtf_plsql_api.g_update
4451: AND p_complete_rec.status_code = 'ACTIVE' THEN
4452: Ozf_fundrules_pvt.check_fund_curr_vs_child(
4453: p_complete_rec.fund_id
4454: ,p_complete_rec.currency_code_tc
4455: ,l_return_status);
4456:
4463:
4464: ------------------- check fund_status ------------------------------
4465: IF p_fund_rec.status_code <> fnd_api.g_miss_char
4466: OR p_fund_rec.parent_fund_id <> fnd_api.g_miss_num THEN
4467: Ozf_fundrules_pvt.check_fund_status_vs_parent(
4468: p_complete_rec.parent_fund_id
4469: ,p_complete_rec.status_code
4470: ,l_return_status);
4471: