DBA Data[Home] [Help]

APPS.OZF_ACTBUDGETS_PVT dependencies on JTF_PLSQL_API

Line 2078: IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN

2074: END IF;
2075: END IF;
2076:
2077:
2078: IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN
2079: validate_act_budgets_items (
2080: p_act_budgets_rec=> l_act_budgets_rec
2081: ,p_validation_mode=> jtf_plsql_api.g_update
2082: ,x_return_status=> l_return_status

Line 2081: ,p_validation_mode=> jtf_plsql_api.g_update

2077:
2078: IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN
2079: validate_act_budgets_items (
2080: p_act_budgets_rec=> l_act_budgets_rec
2081: ,p_validation_mode=> jtf_plsql_api.g_update
2082: ,x_return_status=> l_return_status
2083: );
2084:
2085: -- If any errors happen abort API.

Line 2098: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN

2094: ozf_utility_pvt.debug_message ( l_api_name
2095: || ': check records');
2096: END IF;
2097:
2098: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN
2099: validate_act_budgets_record (
2100: p_act_budgets_rec=> l_act_budgets_rec
2101: ,p_validation_mode=> jtf_plsql_api.g_update
2102: ,x_return_status=> l_return_status

Line 2101: ,p_validation_mode=> jtf_plsql_api.g_update

2097:
2098: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN
2099: validate_act_budgets_record (
2100: p_act_budgets_rec=> l_act_budgets_rec
2101: ,p_validation_mode=> jtf_plsql_api.g_update
2102: ,x_return_status=> l_return_status
2103: );
2104:
2105: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 2871: IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN

2867: ozf_utility_pvt.debug_message ( l_full_name
2868: || ': check items');
2869: END IF;
2870:
2871: IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN
2872: validate_act_budgets_items (
2873: p_act_budgets_rec=> l_act_budgets_rec
2874: ,p_validation_mode=> jtf_plsql_api.g_create
2875: ,x_return_status=> l_return_status

Line 2874: ,p_validation_mode=> jtf_plsql_api.g_create

2870:
2871: IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN
2872: validate_act_budgets_items (
2873: p_act_budgets_rec=> l_act_budgets_rec
2874: ,p_validation_mode=> jtf_plsql_api.g_create
2875: ,x_return_status=> l_return_status
2876: );
2877:
2878: -- If any errors happen abort API.

Line 2893: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN

2889: ozf_utility_pvt.debug_message ( l_full_name
2890: || ': check record level');
2891: END IF;
2892:
2893: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN
2894: validate_act_budgets_record (
2895: p_act_budgets_rec=> l_act_budgets_rec
2896: ,p_validation_mode=> jtf_plsql_api.g_create
2897: ,x_return_status=> l_return_status

Line 2896: ,p_validation_mode=> jtf_plsql_api.g_create

2892:
2893: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN
2894: validate_act_budgets_record (
2895: p_act_budgets_rec=> l_act_budgets_rec
2896: ,p_validation_mode=> jtf_plsql_api.g_create
2897: ,x_return_status=> l_return_status
2898: );
2899:
2900: -- If any errors happen abort API.

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

2959: -- End of Comments
2960: /*****************************************************************************************/
2961: PROCEDURE validate_act_budgets_items (
2962: p_act_budgets_rec IN act_budgets_rec_type
2963: ,p_validation_mode IN VARCHAR2 := jtf_plsql_api.g_create
2964: ,x_return_status OUT NOCOPY VARCHAR2
2965: ) IS
2966: l_table_name VARCHAR2 (30);
2967: l_pk_name VARCHAR2 (30);

Line 3061: IF p_validation_mode = jtf_plsql_api.g_create

3057: x_return_status := fnd_api.g_ret_sts_error;
3058: RETURN;
3059: END IF;
3060: -- Validate uniqueness
3061: IF p_validation_mode = jtf_plsql_api.g_create
3062: AND p_act_budgets_rec.activity_budget_id IS NOT NULL THEN
3063: IF ozf_utility_pvt.check_uniqueness (
3064: 'ozf_Act_budgets'
3065: , 'ACTIVITY_BUDGET_ID = '

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

3321: -- End of Comments
3322: /*****************************************************************************************/
3323: PROCEDURE validate_act_budgets_record (
3324: p_act_budgets_rec IN act_budgets_rec_type
3325: ,p_validation_mode IN VARCHAR2 := jtf_plsql_api.g_create
3326: ,x_return_status OUT NOCOPY VARCHAR2
3327: ) IS
3328: l_api_name CONSTANT VARCHAR2 (30) := 'Validate_Act_Budgets_Record';
3329: l_api_version CONSTANT NUMBER := 1.0;

Line 3434: IF p_validation_mode = jtf_plsql_api.g_update THEN

3430: END IF;
3431:
3432: IF l_fund_transfer_flag = fnd_api.g_false THEN
3433: -- only utilized records could be updated. transfer, request cannot be updated
3434: IF p_validation_mode = jtf_plsql_api.g_update THEN
3435: OPEN c_current_amount;
3436: FETCH c_current_amount INTO l_old_approved_amount;
3437:
3438: IF c_current_amount%NOTFOUND THEN

Line 6061: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

6057: l_objfundsum_rec.plan_curr_paid_amt := l_amount_1;
6058: l_objfundsum_rec.paid_amt := l_amount_2;
6059: l_objfundsum_rec.univ_curr_paid_amt := l_amount_3;
6060:
6061: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
6062: OZF_OBJFUNDSUM_PVT.Validate_objfundsum (
6063: p_api_version => l_api_version,
6064: p_init_msg_list => p_init_msg_list,
6065: p_validation_level => p_validation_level,