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 1424: ,p_mode IN VARCHAR2 := jtf_plsql_api.g_update

1420: ,x_return_status OUT NOCOPY VARCHAR2
1421: ,x_msg_count OUT NOCOPY NUMBER
1422: ,x_msg_data OUT NOCOPY VARCHAR2
1423: ,p_fund_rec IN fund_rec_type
1424: ,p_mode IN VARCHAR2 := jtf_plsql_api.g_update
1425: )
1426: IS
1427: l_resale_batch_id NUMBER;
1428: l_use_fund_staging_tables VARCHAR2(1) := 'F';

Line 1486: ,p_mode IN VARCHAR2 := jtf_plsql_api.g_update

1482: ,x_return_status OUT NOCOPY VARCHAR2
1483: ,x_msg_count OUT NOCOPY NUMBER
1484: ,x_msg_data OUT NOCOPY VARCHAR2
1485: ,p_fund_rec IN fund_rec_type
1486: ,p_mode IN VARCHAR2 := jtf_plsql_api.g_update
1487: ,p_resale_batch_id IN NUMBER
1488: ,p_batch_type IN VARCHAR2
1489: ,p_use_fund_staging_tables IN VARCHAR2
1490: ,px_ozf_funds_old_rectype IN OZF_UTILITY_PVT.ozf_funds_all_b_rectype

Line 2210: IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN

2206: RAISE fnd_api.g_exc_unexpected_error;
2207: END IF;
2208: END IF;
2209:
2210: IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN
2211: ----dbms_output.put_line ('Calling Check_Fund_Items');
2212: check_fund_items(
2213: /* yzhao: 06/03/2003 fix bug 2984497 - TST1159.14 MASTER: BUDGET APPROVAL VALIDATION FAILS UPON APPROVAL IN WORKFLOW
2214: p_fund_rec => p_fund_rec

Line 2217: ,p_validation_mode => jtf_plsql_api.g_update

2213: /* yzhao: 06/03/2003 fix bug 2984497 - TST1159.14 MASTER: BUDGET APPROVAL VALIDATION FAILS UPON APPROVAL IN WORKFLOW
2214: p_fund_rec => p_fund_rec
2215: */
2216: p_fund_rec => l_fund_rec
2217: ,p_validation_mode => jtf_plsql_api.g_update
2218: ,x_return_status => l_return_status
2219: ,p_mode => p_mode); -- For Bug 13529250, to pass p_mode to avoid budget amount validation while claim settlement
2220:
2221: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 2229: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN

2225: END IF;
2226: END IF;
2227:
2228: -- record level
2229: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN
2230: check_fund_record(
2231: p_fund_rec => p_fund_rec
2232: ,p_complete_rec => l_fund_rec
2233: ,p_mode => p_mode

Line 2248: IF p_validation_level >= jtf_plsql_api.g_valid_level_inter_entity THEN

2244: IF G_DEBUG THEN
2245: ozf_utility_pvt.debug_message(l_full_name || ': check inter-entity');
2246: END IF;
2247:
2248: IF p_validation_level >= jtf_plsql_api.g_valid_level_inter_entity THEN
2249: check_fund_inter_entity(
2250: p_fund_rec => p_fund_rec
2251: ,p_complete_rec => l_fund_rec
2252: ,p_validation_mode => jtf_plsql_api.g_update

Line 2252: ,p_validation_mode => jtf_plsql_api.g_update

2248: IF p_validation_level >= jtf_plsql_api.g_valid_level_inter_entity THEN
2249: check_fund_inter_entity(
2250: p_fund_rec => p_fund_rec
2251: ,p_complete_rec => l_fund_rec
2252: ,p_validation_mode => jtf_plsql_api.g_update
2253: ,x_return_status => l_return_status);
2254:
2255: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2256: RAISE fnd_api.g_exc_unexpected_error;

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

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

Line 3362: IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN

3358: IF G_DEBUG THEN
3359: ozf_utility_pvt.debug_message(l_full_name || ': check items');
3360: END IF;
3361:
3362: IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN
3363: ----dbms_output.put_line ('Calling Check_Fund_Items from validate');
3364: check_fund_items(
3365: p_fund_rec => p_fund_rec
3366: ,p_validation_mode => jtf_plsql_api.g_create

Line 3366: ,p_validation_mode => jtf_plsql_api.g_create

3362: IF p_validation_level >= jtf_plsql_api.g_valid_level_item THEN
3363: ----dbms_output.put_line ('Calling Check_Fund_Items from validate');
3364: check_fund_items(
3365: p_fund_rec => p_fund_rec
3366: ,p_validation_mode => jtf_plsql_api.g_create
3367: ,x_return_status => l_return_status);
3368:
3369: ----dbms_output.put_line ('Called Check_Fund_Items from validate');
3370: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 3381: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN

3377: IF G_DEBUG THEN
3378: ozf_utility_pvt.debug_message(l_full_name || ': check record');
3379: END IF;
3380:
3381: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN
3382: check_fund_record(
3383: p_fund_rec => p_fund_rec
3384: ,p_complete_rec => p_fund_rec
3385: ,p_mode => jtf_plsql_api.g_create

Line 3385: ,p_mode => jtf_plsql_api.g_create

3381: IF p_validation_level >= jtf_plsql_api.g_valid_level_record THEN
3382: check_fund_record(
3383: p_fund_rec => p_fund_rec
3384: ,p_complete_rec => p_fund_rec
3385: ,p_mode => jtf_plsql_api.g_create
3386: ,x_return_status => l_return_status);
3387:
3388: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3389: RAISE fnd_api.g_exc_unexpected_error;

Line 3400: IF p_validation_level >= jtf_plsql_api.g_valid_level_inter_entity THEN

3396: IF G_DEBUG THEN
3397: ozf_utility_pvt.debug_message(l_full_name || ': check inter-entity');
3398: END IF;
3399:
3400: IF p_validation_level >= jtf_plsql_api.g_valid_level_inter_entity THEN
3401: check_fund_inter_entity(
3402: p_fund_rec => p_fund_rec
3403: ,p_complete_rec => p_fund_rec
3404: ,p_validation_mode => jtf_plsql_api.g_create

Line 3404: ,p_validation_mode => jtf_plsql_api.g_create

3400: IF p_validation_level >= jtf_plsql_api.g_valid_level_inter_entity THEN
3401: check_fund_inter_entity(
3402: p_fund_rec => p_fund_rec
3403: ,p_complete_rec => p_fund_rec
3404: ,p_validation_mode => jtf_plsql_api.g_create
3405: ,x_return_status => l_return_status);
3406:
3407: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3408: RAISE fnd_api.g_exc_unexpected_error;

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

3593: -- 2nd August200 MPAnde Updated
3594: ---------------------------------------------------------------------
3595: PROCEDURE check_fund_uk_items(
3596: p_fund_rec IN fund_rec_type
3597: ,p_validation_mode IN VARCHAR2 := jtf_plsql_api.g_create
3598: ,x_return_status OUT NOCOPY VARCHAR2)
3599: IS
3600: l_valid_flag VARCHAR2(1);
3601:

Line 3620: IF p_validation_mode = jtf_plsql_api.g_create

3616: x_return_status := fnd_api.g_ret_sts_success;
3617:
3618: -- For Create_Fund, when fund_id is passed in, we need to
3619: -- check if this fund_id is unique.
3620: IF p_validation_mode = jtf_plsql_api.g_create
3621: AND p_fund_rec.fund_id IS NOT NULL THEN
3622: IF ozf_utility_pvt.check_uniqueness(
3623: 'ozf_funds_all_vl'
3624: ,'fund_id = ' || p_fund_rec.fund_id) =

Line 3642: IF p_validation_mode = jtf_plsql_api.g_create THEN

3638: END IF;
3639:
3640: -- Check if fund_number is unique. Need to handle create and
3641: -- update differently.
3642: IF p_validation_mode = jtf_plsql_api.g_create THEN
3643: /*l_valid_flag :=
3644: ozf_utility_pvt.check_uniqueness(
3645: 'ozf_funds_all_vl'
3646: ,'fund_number = ''' || p_fund_rec.fund_number || '''');*/

Line 3681: IF p_validation_mode = jtf_plsql_api.g_create THEN

3677: -- update differently.
3678: -- Commented for Bug Fix #3498826
3679: /*
3680: IF p_fund_rec.fund_type = 'FULLY_ACCRUED' THEN
3681: IF p_validation_mode = jtf_plsql_api.g_create THEN
3682: l_valid_flag :=
3683: ozf_utility_pvt.check_uniqueness(
3684: 'ozf_funds_all_vl'
3685: ,'short_name = ''' || p_fund_rec.short_name || '''');

Line 3907: p_validation_mode IN VARCHAR2 := jtf_plsql_api.g_create

3903: -- 02/02/2000 Shitij Vatsa Create.
3904: -- 29/DEC/2011 Added parameter p_mode default NULL Bug 13529250
3905: ---------------------------------------------------------------------
3906: PROCEDURE check_fund_items(
3907: p_validation_mode IN VARCHAR2 := jtf_plsql_api.g_create
3908: ,x_return_status OUT NOCOPY VARCHAR2
3909: ,p_fund_rec IN fund_rec_type
3910: ,p_mode IN VARCHAR2 DEFAULT NULL)
3911: IS

Line 4090: IF p_mode = jtf_plsql_api.g_update THEN

4086:
4087: x_return_status := fnd_api.g_ret_sts_error;
4088: END IF;
4089:
4090: IF p_mode = jtf_plsql_api.g_update THEN
4091: IF p_fund_rec.parent_fund_id <> fnd_api.g_miss_num
4092: AND p_fund_rec.parent_fund_id IS NOT NULL THEN
4093: IF p_complete_rec.fund_id = p_complete_rec.parent_fund_id THEN
4094: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 4234: p_mode <> jtf_plsql_api.g_create THEN

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

Line 4246: IF p_mode = jtf_plsql_api.g_update THEN

4242: END IF; */
4243: END IF;
4244:
4245: -- Check for update validations
4246: IF p_mode = jtf_plsql_api.g_update THEN
4247: -- mpande added on Sep 11 for giving update access to owner and persons who have access with edit metric flag = 'Y'
4248: l_resource_id := ozf_utility_pvt.get_resource_id(p_user_id => fnd_global.user_id);
4249:
4250: IF G_DEBUG THEN

Line 4358: IF p_validation_mode = jtf_plsql_api.g_update THEN

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

Line 4388: IF p_validation_mode = jtf_plsql_api.g_update THEN

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

Line 4420: IF p_validation_mode = jtf_plsql_api.g_update

4416: END IF;
4417:
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

Line 4450: IF p_validation_mode = jtf_plsql_api.g_update

4446: END IF;
4447:
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

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

5896: ,x_return_status OUT NOCOPY VARCHAR2
5897: ,x_msg_count OUT NOCOPY NUMBER
5898: ,x_msg_data OUT NOCOPY VARCHAR2
5899: ,p_fund_rec IN fund_rec_type
5900: ,p_mode IN VARCHAR2 := JTF_PLSQL_API.G_CREATE
5901: ) IS
5902:
5903: l_api_version CONSTANT NUMBER := 1.0;
5904: l_api_name CONSTANT VARCHAR2(30)