DBA Data[Home] [Help]

APPS.OZF_ACTBUDGETS_PVT dependencies on JTF_PLSQL_API

Line 2743: IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN

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

Line 2746: ,p_validation_mode=> jtf_plsql_api.g_update

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.

Line 2763: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN

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

Line 2766: ,p_validation_mode=> jtf_plsql_api.g_update

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

Line 3688: IF p_validation_level >= jtf_plsql_api.g_valid_level_item 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

Line 3691: ,p_validation_mode=> jtf_plsql_api.g_create

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.

Line 3710: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN

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

Line 3713: ,p_validation_mode=> jtf_plsql_api.g_create

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.

Line 3780: ,p_validation_mode IN VARCHAR2 := jtf_plsql_api.g_create

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);

Line 3878: IF p_validation_mode = jtf_plsql_api.g_create

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 = '

Line 4142: ,p_validation_mode IN VARCHAR2 := jtf_plsql_api.g_create

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;

Line 4251: IF p_validation_mode = jtf_plsql_api.g_update THEN

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

Line 7081: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item 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,