eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_FUNDS_PVT dependencies on JTF_PLSQL_API

Line 1435: ,p_mode IN VARCHAR2 := jtf_plsql_api.g_update)

1431: ,x_return_status OUT NOCOPY VARCHAR2
1432: ,x_msg_count OUT NOCOPY NUMBER
1433: ,x_msg_data OUT NOCOPY VARCHAR2
1434: ,p_fund_rec IN fund_rec_type
1435: ,p_mode IN VARCHAR2 := jtf_plsql_api.g_update)
1436: IS
1437: l_api_version CONSTANT NUMBER := 1.0;
1438: l_api_name CONSTANT VARCHAR2(30)
1439: := 'Update_Fund';

Line 2014: IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN

2010: RAISE fnd_api.g_exc_unexpected_error;
2011: END IF;
2012: END IF;
2013:
2014: IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN
2015: ----dbms_output.put_line ('Calling Check_Fund_Items');
2016: check_fund_items(
2017: /* yzhao: 06/03/2003 fix bug 2984497 - TST1159.14 MASTER: BUDGET APPROVAL VALIDATION FAILS UPON APPROVAL IN WORKFLOW
2018: p_fund_rec => p_fund_rec

Line 2021: ,p_validation_mode => jtf_plsql_api.g_update

2017: /* yzhao: 06/03/2003 fix bug 2984497 - TST1159.14 MASTER: BUDGET APPROVAL VALIDATION FAILS UPON APPROVAL IN WORKFLOW
2018: p_fund_rec => p_fund_rec
2019: */
2020: p_fund_rec => l_fund_rec
2021: ,p_validation_mode => jtf_plsql_api.g_update
2022: ,x_return_status => l_return_status);
2023:
2024: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2025: RAISE fnd_api.g_exc_unexpected_error;

Line 2032: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN

2028: END IF;
2029: END IF;
2030:
2031: -- record level
2032: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN
2033: check_fund_record(
2034: p_fund_rec => p_fund_rec
2035: ,p_complete_rec => l_fund_rec
2036: ,p_mode => p_mode

Line 2051: IF p_validation_level >= jtf_plsql_api.g_valid_level_inter_entity THEN

2047: IF G_DEBUG THEN
2048: ozf_utility_pvt.debug_message(l_full_name || ': check inter-entity');
2049: END IF;
2050:
2051: IF p_validation_level >= jtf_plsql_api.g_valid_level_inter_entity THEN
2052: check_fund_inter_entity(
2053: p_fund_rec => p_fund_rec
2054: ,p_complete_rec => l_fund_rec
2055: ,p_validation_mode => jtf_plsql_api.g_update

Line 2055: ,p_validation_mode => jtf_plsql_api.g_update

2051: IF p_validation_level >= jtf_plsql_api.g_valid_level_inter_entity THEN
2052: check_fund_inter_entity(
2053: p_fund_rec => p_fund_rec
2054: ,p_complete_rec => l_fund_rec
2055: ,p_validation_mode => jtf_plsql_api.g_update
2056: ,x_return_status => l_return_status);
2057:
2058: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2059: RAISE fnd_api.g_exc_unexpected_error;

Line 2099: IF p_mode IN (jtf_PLSQL_API.G_UPDATE, 'WORKFLOW') THEN

2095: -- perform all status related updation and if it is successful then only update the fund record
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

Line 2965: IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN

2961: IF G_DEBUG THEN
2962: ozf_utility_pvt.debug_message(l_full_name || ': check items');
2963: END IF;
2964:
2965: IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN
2966: ----dbms_output.put_line ('Calling Check_Fund_Items from validate');
2967: check_fund_items(
2968: p_fund_rec => p_fund_rec
2969: ,p_validation_mode => jtf_plsql_api.g_create

Line 2969: ,p_validation_mode => jtf_plsql_api.g_create

2965: IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN
2966: ----dbms_output.put_line ('Calling Check_Fund_Items from validate');
2967: check_fund_items(
2968: p_fund_rec => p_fund_rec
2969: ,p_validation_mode => jtf_plsql_api.g_create
2970: ,x_return_status => l_return_status);
2971:
2972: ----dbms_output.put_line ('Called Check_Fund_Items from validate');
2973: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 2984: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN

2980: IF G_DEBUG THEN
2981: ozf_utility_pvt.debug_message(l_full_name || ': check record');
2982: END IF;
2983:
2984: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN
2985: check_fund_record(
2986: p_fund_rec => p_fund_rec
2987: ,p_complete_rec => p_fund_rec
2988: ,p_mode => jtf_plsql_api.g_create

Line 2988: ,p_mode => jtf_plsql_api.g_create

2984: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN
2985: check_fund_record(
2986: p_fund_rec => p_fund_rec
2987: ,p_complete_rec => p_fund_rec
2988: ,p_mode => jtf_plsql_api.g_create
2989: ,x_return_status => l_return_status);
2990:
2991: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2992: RAISE fnd_api.g_exc_unexpected_error;

Line 3003: IF p_validation_level >= jtf_plsql_api.g_valid_level_inter_entity THEN

2999: IF G_DEBUG THEN
3000: ozf_utility_pvt.debug_message(l_full_name || ': check inter-entity');
3001: END IF;
3002:
3003: IF p_validation_level >= jtf_plsql_api.g_valid_level_inter_entity THEN
3004: check_fund_inter_entity(
3005: p_fund_rec => p_fund_rec
3006: ,p_complete_rec => p_fund_rec
3007: ,p_validation_mode => jtf_plsql_api.g_create

Line 3007: ,p_validation_mode => jtf_plsql_api.g_create

3003: IF p_validation_level >= jtf_plsql_api.g_valid_level_inter_entity THEN
3004: check_fund_inter_entity(
3005: p_fund_rec => p_fund_rec
3006: ,p_complete_rec => p_fund_rec
3007: ,p_validation_mode => jtf_plsql_api.g_create
3008: ,x_return_status => l_return_status);
3009:
3010: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3011: RAISE fnd_api.g_exc_unexpected_error;

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

3194: -- 2nd August200 MPAnde Updated
3195: ---------------------------------------------------------------------
3196: PROCEDURE check_fund_uk_items(
3197: p_fund_rec IN fund_rec_type
3198: ,p_validation_mode IN VARCHAR2 := jtf_plsql_api.g_create
3199: ,x_return_status OUT NOCOPY VARCHAR2)
3200: IS
3201: l_valid_flag VARCHAR2(1);
3202:

Line 3221: IF p_validation_mode = jtf_plsql_api.g_create

3217: x_return_status := fnd_api.g_ret_sts_success;
3218:
3219: -- For Create_Fund, when fund_id is passed in, we need to
3220: -- check if this fund_id is unique.
3221: IF p_validation_mode = jtf_plsql_api.g_create
3222: AND p_fund_rec.fund_id IS NOT NULL THEN
3223: IF ozf_utility_pvt.check_uniqueness(
3224: 'ozf_funds_all_vl'
3225: ,'fund_id = ' || p_fund_rec.fund_id) =

Line 3243: IF p_validation_mode = jtf_plsql_api.g_create THEN

3239: END IF;
3240:
3241: -- Check if fund_number is unique. Need to handle create and
3242: -- update differently.
3243: IF p_validation_mode = jtf_plsql_api.g_create THEN
3244: /*l_valid_flag :=
3245: ozf_utility_pvt.check_uniqueness(
3246: 'ozf_funds_all_vl'
3247: ,'fund_number = ''' || p_fund_rec.fund_number || '''');*/

Line 3282: IF p_validation_mode = jtf_plsql_api.g_create THEN

3278: -- update differently.
3279: -- Commented for Bug Fix #3498826
3280: /*
3281: IF p_fund_rec.fund_type = 'FULLY_ACCRUED' THEN
3282: IF p_validation_mode = jtf_plsql_api.g_create THEN
3283: l_valid_flag :=
3284: ozf_utility_pvt.check_uniqueness(
3285: 'ozf_funds_all_vl'
3286: ,'short_name = ''' || p_fund_rec.short_name || '''');

Line 3507: p_validation_mode IN VARCHAR2 := jtf_plsql_api.g_create

3503: -- HISTORY
3504: -- 02/02/2000 Shitij Vatsa Create.
3505: ---------------------------------------------------------------------
3506: PROCEDURE check_fund_items(
3507: p_validation_mode IN VARCHAR2 := jtf_plsql_api.g_create
3508: ,x_return_status OUT NOCOPY VARCHAR2
3509: ,p_fund_rec IN fund_rec_type)
3510: IS
3511: BEGIN

Line 3688: IF p_mode = jtf_plsql_api.g_update THEN

3684:
3685: x_return_status := fnd_api.g_ret_sts_error;
3686: END IF;
3687:
3688: IF p_mode = jtf_plsql_api.g_update THEN
3689: IF p_fund_rec.parent_fund_id <> fnd_api.g_miss_num
3690: AND p_fund_rec.parent_fund_id IS NOT NULL THEN
3691: IF p_complete_rec.fund_id = p_complete_rec.parent_fund_id THEN
3692: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 3832: p_mode <> jtf_plsql_api.g_create THEN

3828:
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:

Line 3844: IF p_mode = jtf_plsql_api.g_update THEN

3840: END IF; */
3841: END IF;
3842:
3843: -- Check for update validations
3844: IF p_mode = jtf_plsql_api.g_update THEN
3845: -- mpande added on Sep 11 for giving update access to owner and persons who have access with edit metric flag = 'Y'
3846: l_resource_id := ozf_utility_pvt.get_resource_id(p_user_id => fnd_global.user_id);
3847:
3848: IF G_DEBUG THEN

Line 3956: IF p_validation_mode = jtf_plsql_api.g_update THEN

3952: IF l_return_status <> fnd_api.g_ret_sts_success THEN
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

Line 3986: IF p_validation_mode = jtf_plsql_api.g_update THEN

3982: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3983: x_return_status := 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

Line 4018: IF p_validation_mode = jtf_plsql_api.g_update

4014: END IF;
4015:
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

Line 4048: IF p_validation_mode = jtf_plsql_api.g_update

4044: END IF;
4045:
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

Line 5472: ,p_mode IN VARCHAR2 := JTF_PLSQL_API.G_CREATE

5468: ,x_return_status OUT NOCOPY VARCHAR2
5469: ,x_msg_count OUT NOCOPY NUMBER
5470: ,x_msg_data OUT NOCOPY VARCHAR2
5471: ,p_fund_rec IN fund_rec_type
5472: ,p_mode IN VARCHAR2 := JTF_PLSQL_API.G_CREATE
5473: ) IS
5474:
5475: l_api_version CONSTANT NUMBER := 1.0;
5476: l_api_name CONSTANT VARCHAR2(30)