2739: ozf_utility_pvt.debug_message ( l_api_name
2740: || ': l_act_budgets_rec.src_curr_req_amt'
2741: || l_act_budgets_rec.src_curr_req_amt);
2742: END IF;
2743: IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN
2744: validate_act_budgets_items (
2745: p_act_budgets_rec=> l_act_budgets_rec
2746: ,p_validation_mode=> jtf_plsql_api.g_update
2747: ,x_return_status=> l_return_status
2742: END IF;
2743: IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN
2744: validate_act_budgets_items (
2745: p_act_budgets_rec=> l_act_budgets_rec
2746: ,p_validation_mode=> jtf_plsql_api.g_update
2747: ,x_return_status=> l_return_status
2748: );
2749:
2750: -- If any errors happen abort API.
2759: ozf_utility_pvt.debug_message ( l_api_name
2760: || ': check records');
2761: END IF;
2762:
2763: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN
2764: validate_act_budgets_record (
2765: p_act_budgets_rec=> l_act_budgets_rec
2766: ,p_validation_mode=> jtf_plsql_api.g_update
2767: ,x_return_status=> l_return_status
2762:
2763: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN
2764: validate_act_budgets_record (
2765: p_act_budgets_rec=> l_act_budgets_rec
2766: ,p_validation_mode=> jtf_plsql_api.g_update
2767: ,x_return_status=> l_return_status
2768: );
2769:
2770: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3684: ozf_utility_pvt.debug_message ( l_full_name
3685: || ': check items');
3686: END IF;
3687:
3688: IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN
3689: validate_act_budgets_items (
3690: p_act_budgets_rec=> l_act_budgets_rec
3691: ,p_validation_mode=> jtf_plsql_api.g_create
3692: ,x_return_status=> l_return_status
3687:
3688: IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN
3689: validate_act_budgets_items (
3690: p_act_budgets_rec=> l_act_budgets_rec
3691: ,p_validation_mode=> jtf_plsql_api.g_create
3692: ,x_return_status=> l_return_status
3693: );
3694:
3695: -- If any errors happen abort API.
3706: ozf_utility_pvt.debug_message ( l_full_name
3707: || ': check record level');
3708: END IF;
3709:
3710: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN
3711: validate_act_budgets_record (
3712: p_act_budgets_rec=> l_act_budgets_rec
3713: ,p_validation_mode=> jtf_plsql_api.g_create
3714: ,x_return_status=> l_return_status
3709:
3710: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN
3711: validate_act_budgets_record (
3712: p_act_budgets_rec=> l_act_budgets_rec
3713: ,p_validation_mode=> jtf_plsql_api.g_create
3714: ,x_return_status=> l_return_status
3715: );
3716:
3717: -- If any errors happen abort API.
3776: -- End of Comments
3777: /*****************************************************************************************/
3778: PROCEDURE validate_act_budgets_items (
3779: p_act_budgets_rec IN act_budgets_rec_type
3780: ,p_validation_mode IN VARCHAR2 := jtf_plsql_api.g_create
3781: ,x_return_status OUT NOCOPY VARCHAR2
3782: ) IS
3783: l_table_name VARCHAR2 (30);
3784: l_pk_name VARCHAR2 (30);
3874: x_return_status := fnd_api.g_ret_sts_error;
3875: RETURN;
3876: END IF;
3877: -- Validate uniqueness
3878: IF p_validation_mode = jtf_plsql_api.g_create
3879: AND p_act_budgets_rec.activity_budget_id IS NOT NULL THEN
3880: IF ozf_utility_pvt.check_uniqueness (
3881: 'ozf_Act_budgets'
3882: , 'ACTIVITY_BUDGET_ID = '
4138: -- End of Comments
4139: /*****************************************************************************************/
4140: PROCEDURE validate_act_budgets_record (
4141: p_act_budgets_rec IN act_budgets_rec_type
4142: ,p_validation_mode IN VARCHAR2 := jtf_plsql_api.g_create
4143: ,x_return_status OUT NOCOPY VARCHAR2
4144: ) IS
4145: l_api_name CONSTANT VARCHAR2 (30) := 'Validate_Act_Budgets_Record';
4146: l_api_version CONSTANT NUMBER := 1.0;
4247: END IF;
4248:
4249: IF l_fund_transfer_flag = fnd_api.g_false THEN
4250: -- only utilized records could be updated. transfer, request cannot be updated
4251: IF p_validation_mode = jtf_plsql_api.g_update THEN
4252: OPEN c_current_amount;
4253: FETCH c_current_amount INTO l_old_approved_amount;
4254:
4255: IF c_current_amount%NOTFOUND THEN
7077: l_objfundsum_rec.plan_curr_paid_amt := l_amount_1;
7078: l_objfundsum_rec.paid_amt := l_amount_2;
7079: l_objfundsum_rec.univ_curr_paid_amt := l_amount_3;
7080:
7081: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
7082: OZF_OBJFUNDSUM_PVT.Validate_objfundsum (
7083: p_api_version => l_api_version,
7084: p_init_msg_list => p_init_msg_list,
7085: p_validation_level => p_validation_level,