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_UTILITY_PVT dependencies on OZF_UTILITY_PVT

Line 1: PACKAGE BODY OZF_Utility_PVT AS

1: PACKAGE BODY OZF_Utility_PVT AS
2: /* $Header: ozfvutlb.pls 120.27.12020000.6 2013/02/14 10:00:45 nepanda ship $ */
3:
4: -- HISTORY
5: --

Line 107: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_UTILITY_PVT';

103: OZF_DEBUG_MEDIUM_ON CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
104: OZF_UNEXP_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.g_msg_lvl_unexp_error);
105: OZF_ERROR CONSTANT BOOLEAN := FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.g_msg_lvl_error);
106:
107: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_UTILITY_PVT';
108: G_FILE_NAME CONSTANT VARCHAR2(30) := 'ozfvutlb.pls';
109:
110: G_OZF_APP_ID CONSTANT NUMBER := 682;
111:

Line 794: OZF_Utility_PVT.error_message ('OZF_INVALID_SYS_QUAL', 'SYS_QUALIFIER', p_sys_qual);

790: ('OZF_COMP_START', 'OZF_COMP_SHOW_WEB_PAGE', 'OZF_COMP_END') THEN
791: x_table_name := 'OZF_DLG_FLOW_COMPS_B';
792: x_pk_name := 'FLOW_COMPONENT_ID';
793: ELSE
794: OZF_Utility_PVT.error_message ('OZF_INVALID_SYS_QUAL', 'SYS_QUALIFIER', p_sys_qual);
795: x_return_status := FND_API.g_ret_sts_unexp_error;
796: x_table_name := NULL;
797: x_pk_name := NULL;
798: END IF;

Line 1356: -- SELECT OZF_Utility_PVT.get_lookup_meaning ('AMS_CAMPAIGN_STATUS', status_code)

1352: -- FUNCTION
1353: -- get_lookup_meaning
1354: -- USAGE
1355: -- Example:
1356: -- SELECT OZF_Utility_PVT.get_lookup_meaning ('AMS_CAMPAIGN_STATUS', status_code)
1357: -- FROM ams_campaigns_vl;
1358: -- HISTORY
1359: -- 28-Apr-2000 choang Created.
1360: ---------------------------------------------------------------------

Line 1388: -- SELECT OZF_Utility_PVT.get_resource_name (owner_user_id)

1384: -- FUNCTION
1385: -- get_resource_name
1386: -- USAGE
1387: -- Example:
1388: -- SELECT OZF_Utility_PVT.get_resource_name (owner_user_id)
1389: -- FROM ams_campaigns_vl
1390: -- HISTORY
1391: -- 28-Apr-2000 choang Created.
1392: ---------------------------------------------------------------------

Line 1846: OZF_Utility_PVT.error_message('OZF_CAMP_BAD_STATUS_CHANGE');

1842: OPEN c_approval_flag;
1843: FETCH c_approval_flag INTO l_theme_flag, l_budget_flag;
1844: IF c_approval_flag%NOTFOUND THEN
1845: x_return_status := FND_API.g_ret_sts_error;
1846: OZF_Utility_PVT.error_message('OZF_CAMP_BAD_STATUS_CHANGE');
1847: END IF;
1848: CLOSE c_approval_flag;
1849:
1850: IF l_budget_flag = 'Y' THEN

Line 1953: OZF_Utility_PVT.error_message('OZF_CAMP_BAD_STATUS_CHANGE');

1949: OPEN c_approval_flag;
1950: FETCH c_approval_flag INTO l_theme_flag, l_budget_flag;
1951: IF c_approval_flag%NOTFOUND THEN
1952: x_return_status := FND_API.g_ret_sts_error;
1953: OZF_Utility_PVT.error_message('OZF_CAMP_BAD_STATUS_CHANGE');
1954: END IF;
1955: CLOSE c_approval_flag;
1956:
1957: IF l_budget_flag = 'Y' THEN

Line 2241: IF ozf_utility_pvt.check_fk_exists('GL_DAILY_CONVERSION_TYPES',

2237:
2238: x_return_status := fnd_api.g_ret_sts_error;
2239: RETURN;
2240: ELSE
2241: IF ozf_utility_pvt.check_fk_exists('GL_DAILY_CONVERSION_TYPES',
2242: 'CONVERSION_TYPE'
2243: ,l_conversion_type) = fnd_api.g_false
2244: THEN
2245: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 2276: ozf_utility_pvt.debug_message('debug: start ' || l_org_id);

2272:
2273: END IF;
2274:
2275: IF (OZF_DEBUG_HIGH_ON) THEN
2276: ozf_utility_pvt.debug_message('debug: start ' || l_org_id);
2277: END IF;
2278:
2279: x_mrc_sob_type_code := 'P';
2280: OPEN c_get_gl_info(l_org_id);

Line 2446: ozf_utility_pvt.write_conc_log ('get_object_org_ledger() p_object_id: ' || p_object_id);

2442: BEGIN
2443: x_org_id := NULL;
2444: x_ledger_id := NULL;
2445:
2446: ozf_utility_pvt.write_conc_log ('get_object_org_ledger() p_object_id: ' || p_object_id);
2447: ozf_utility_pvt.write_conc_log ('get_object_org_ledger() p_object_type: ' || p_object_type);
2448: IF p_object_type = 'OFFR' THEN
2449: OPEN c_offer_org_id( p_object_id) ;
2450: FETCH c_offer_org_id INTO x_org_id ;

Line 2447: ozf_utility_pvt.write_conc_log ('get_object_org_ledger() p_object_type: ' || p_object_type);

2443: x_org_id := NULL;
2444: x_ledger_id := NULL;
2445:
2446: ozf_utility_pvt.write_conc_log ('get_object_org_ledger() p_object_id: ' || p_object_id);
2447: ozf_utility_pvt.write_conc_log ('get_object_org_ledger() p_object_type: ' || p_object_type);
2448: IF p_object_type = 'OFFR' THEN
2449: OPEN c_offer_org_id( p_object_id) ;
2450: FETCH c_offer_org_id INTO x_org_id ;
2451: CLOSE c_offer_org_id ;

Line 2453: ozf_utility_pvt.debug_message ('get_object_org_ledger() org_id for offer =' || x_org_id);

2449: OPEN c_offer_org_id( p_object_id) ;
2450: FETCH c_offer_org_id INTO x_org_id ;
2451: CLOSE c_offer_org_id ;
2452: IF OZF_DEBUG_HIGH_ON THEN
2453: ozf_utility_pvt.debug_message ('get_object_org_ledger() org_id for offer =' || x_org_id);
2454: END IF;
2455: ozf_utility_pvt.write_conc_log ('get_object_org_ledger() org_id for offer: ' || x_org_id);
2456: ELSIF p_object_type = 'PRIC' THEN
2457: OPEN c_pric_org_id( p_object_id) ;

Line 2455: ozf_utility_pvt.write_conc_log ('get_object_org_ledger() org_id for offer: ' || x_org_id);

2451: CLOSE c_offer_org_id ;
2452: IF OZF_DEBUG_HIGH_ON THEN
2453: ozf_utility_pvt.debug_message ('get_object_org_ledger() org_id for offer =' || x_org_id);
2454: END IF;
2455: ozf_utility_pvt.write_conc_log ('get_object_org_ledger() org_id for offer: ' || x_org_id);
2456: ELSIF p_object_type = 'PRIC' THEN
2457: OPEN c_pric_org_id( p_object_id) ;
2458: FETCH c_pric_org_id INTO x_org_id ;
2459: CLOSE c_pric_org_id ;

Line 2461: ozf_utility_pvt.debug_message ('get_object_org_ledger() org_id for pric =' || x_org_id);

2457: OPEN c_pric_org_id( p_object_id) ;
2458: FETCH c_pric_org_id INTO x_org_id ;
2459: CLOSE c_pric_org_id ;
2460: IF OZF_DEBUG_HIGH_ON THEN
2461: ozf_utility_pvt.debug_message ('get_object_org_ledger() org_id for pric =' || x_org_id);
2462: END IF;
2463: ELSIF p_object_type = 'FUND' THEN
2464: get_fund_ledger(p_fund_id => p_object_id
2465: , x_org_id => x_org_id

Line 2469: ozf_utility_pvt.debug_message ('get_object_org_ledger() org_id for fund =' || x_org_id

2465: , x_org_id => x_org_id
2466: , x_ledger_id => x_ledger_id
2467: , x_return_status => x_return_status);
2468: IF OZF_DEBUG_HIGH_ON THEN
2469: ozf_utility_pvt.debug_message ('get_object_org_ledger() org_id for fund =' || x_org_id
2470: || ' ledger_id=' || x_ledger_id);
2471: END IF;
2472: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2473: RAISE FND_API.g_exc_unexpected_error;

Line 2477: ozf_utility_pvt.write_conc_log ('get_object_org_ledger() x_org_id: ' || x_org_id);

2473: RAISE FND_API.g_exc_unexpected_error;
2474: END IF;
2475: END IF;
2476:
2477: ozf_utility_pvt.write_conc_log ('get_object_org_ledger() x_org_id: ' || x_org_id);
2478: --Bugfix - 7555174 : Modified x_org_id check
2479: --Start (Bug-7555174)
2480: /*
2481: IF x_org_id IS NULL THEN

Line 2490: ozf_utility_pvt.write_conc_log ('get_object_org_ledger() l_budget_source_id: '|| l_budget_source_id);

2486: IF x_org_id IS NULL AND p_object_type = 'OFFR' THEN
2487: OPEN C_GET_OFFERS_BUDGET_ID(p_object_id);
2488: FETCH C_GET_OFFERS_BUDGET_ID INTO l_budget_source_id,l_budget_source_type;
2489: CLOSE C_GET_OFFERS_BUDGET_ID;
2490: ozf_utility_pvt.write_conc_log ('get_object_org_ledger() l_budget_source_id: '|| l_budget_source_id);
2491:
2492: IF l_budget_source_type = 'CAMP' THEN
2493: OPEN c_camp_budget_id(l_budget_source_id);
2494: FETCH c_camp_budget_id INTO l_budget_source_id;

Line 2498: ozf_utility_pvt.debug_message ('NP get_object_org_ledger() l_budget_source_id '|| l_budget_source_id);

2494: FETCH c_camp_budget_id INTO l_budget_source_id;
2495: CLOSE c_camp_budget_id;
2496: END IF;
2497:
2498: ozf_utility_pvt.debug_message ('NP get_object_org_ledger() l_budget_source_id '|| l_budget_source_id);
2499: get_fund_ledger(p_fund_id => l_budget_source_id
2500: , x_org_id => x_org_id
2501: , x_ledger_id => x_ledger_id
2502: , x_return_status => x_return_status);

Line 2520: ozf_utility_pvt.debug_message ('get_object_org_ledger() final org_id =' || x_org_id

2516: );
2517: END IF;
2518:
2519: IF OZF_DEBUG_HIGH_ON THEN
2520: ozf_utility_pvt.debug_message ('get_object_org_ledger() final org_id =' || x_org_id
2521: || ' ledger_id=' || x_ledger_id);
2522: END IF;
2523: ozf_utility_pvt.write_conc_log ('get_object_org_ledger() final org_id: ' || x_org_id || ' ledger_id: ' || x_ledger_id);
2524: x_return_status := fnd_api.g_ret_sts_success;

Line 2523: ozf_utility_pvt.write_conc_log ('get_object_org_ledger() final org_id: ' || x_org_id || ' ledger_id: ' || x_ledger_id);

2519: IF OZF_DEBUG_HIGH_ON THEN
2520: ozf_utility_pvt.debug_message ('get_object_org_ledger() final org_id =' || x_org_id
2521: || ' ledger_id=' || x_ledger_id);
2522: END IF;
2523: ozf_utility_pvt.write_conc_log ('get_object_org_ledger() final org_id: ' || x_org_id || ' ledger_id: ' || x_ledger_id);
2524: x_return_status := fnd_api.g_ret_sts_success;
2525:
2526: EXCEPTION
2527: WHEN OTHERS THEN

Line 2606: IF ozf_utility_pvt.check_fk_exists('GL_DAILY_CONVERSION_TYPES',

2602:
2603: x_return_status := fnd_api.g_ret_sts_error;
2604: RETURN;
2605: ELSE
2606: IF ozf_utility_pvt.check_fk_exists('GL_DAILY_CONVERSION_TYPES',
2607: 'CONVERSION_TYPE'
2608: ,l_conversion_type) = fnd_api.g_false
2609: THEN
2610: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 2815: OZF_Utility_PVT.error_message ('OZF_APPR_INVALID_RESOURCE_ID');

2811: FETCH c_resource INTO l_person_id , l_user_id, l_category;
2812: IF c_resource%NOTFOUND THEN
2813: CLOSE c_resource ;
2814: x_return_status := FND_API.G_RET_STS_ERROR;
2815: OZF_Utility_PVT.error_message ('OZF_APPR_INVALID_RESOURCE_ID');
2816: return;
2817: END IF;
2818: CLOSE c_resource ;
2819: -- Pass the Employee ID to get the Role

Line 2829: OZF_Utility_PVT.error_message ('OZF_APPR_INVALID_ROLE');

2825: p_display_name => x_role_display_name
2826: );
2827: IF x_role_name is null then
2828: x_return_status := FND_API.G_RET_STS_ERROR;
2829: OZF_Utility_PVT.error_message ('OZF_APPR_INVALID_ROLE');
2830: return;
2831: END IF;
2832: ELSE
2833: WF_DIRECTORY.getrolename

Line 2841: OZF_Utility_PVT.error_message ('OZF_APPR_INVALID_ROLE');

2837: p_display_name => x_role_display_name
2838: );
2839: IF x_role_name is null then
2840: x_return_status := FND_API.G_RET_STS_ERROR;
2841: OZF_Utility_PVT.error_message ('OZF_APPR_INVALID_ROLE');
2842: return;
2843: END IF;
2844: END IF;
2845: EXCEPTION

Line 2905: OZF_UTILITY_PVT.get_resource_role

2901:
2902: BEGIN
2903: x_return_status := FND_API.G_RET_STS_SUCCESS;
2904: IF p_send_to_role_name IS NULL THEN
2905: OZF_UTILITY_PVT.get_resource_role
2906: ( p_resource_id => p_send_to_res_id,
2907: x_role_name => l_role_name,
2908: x_role_display_name => l_display_role_name,
2909: x_return_status => x_return_status

Line 3061: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_UTILITY_PVT';

3057: WHERE deliverable_id = p_delv_id;
3058:
3059:
3060: l_api_name CONSTANT VARCHAR2(30) := 'GET_OBJECT_NAME';
3061: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_UTILITY_PVT';
3062:
3063: BEGIN
3064:
3065: If p_association_type_code = 'OZF_DELV' then

Line 3704: px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table,

3700: PROCEDURE UPDATE_OZF_ACT_BUDGETS (
3701: p_batch_id IN NUMBER,
3702: x_return_status OUT NOCOPY VARCHAR2,
3703: x_budget_update_status OUT NOCOPY VARCHAR2,
3704: px_ozf_act_budgets_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_act_budgets_table,
3705: p_batch_type IN VARCHAR2)
3706: IS
3707: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_OZF_ACT_BUDGETS';
3708: l_api_version_number CONSTANT NUMBER := 1.0;

Line 3731: OZF_UTILITY_PVT.debug_message(l_api_name||': Start');

3727:
3728: SAVEPOINT UPDATE_OZF_ACT_BUDGETS;
3729:
3730: IF G_DEBUG THEN
3731: OZF_UTILITY_PVT.debug_message(l_api_name||': Start');
3732: OZF_UTILITY_PVT.debug_message('px_ozf_act_budgets_tbl.COUNT: ' || px_ozf_act_budgets_tbl.COUNT);
3733: END IF;
3734:
3735: IF px_ozf_act_budgets_tbl.COUNT > 0 THEN

Line 3732: OZF_UTILITY_PVT.debug_message('px_ozf_act_budgets_tbl.COUNT: ' || px_ozf_act_budgets_tbl.COUNT);

3728: SAVEPOINT UPDATE_OZF_ACT_BUDGETS;
3729:
3730: IF G_DEBUG THEN
3731: OZF_UTILITY_PVT.debug_message(l_api_name||': Start');
3732: OZF_UTILITY_PVT.debug_message('px_ozf_act_budgets_tbl.COUNT: ' || px_ozf_act_budgets_tbl.COUNT);
3733: END IF;
3734:
3735: IF px_ozf_act_budgets_tbl.COUNT > 0 THEN
3736:

Line 3745: OZF_UTILITY_PVT.debug_message('l_act_budget_id: ' || l_act_budget_id);

3741:
3742: l_act_budget_id := px_ozf_act_budgets_tbl(i).ACTIVITY_BUDGET_ID;
3743:
3744: IF G_DEBUG THEN
3745: OZF_UTILITY_PVT.debug_message('l_act_budget_id: ' || l_act_budget_id);
3746: OZF_UTILITY_PVT.debug_message('approved_amount: ' || px_ozf_act_budgets_tbl(i).APPROVED_AMOUNT);
3747: END IF;
3748:
3749: /*Bug 9614703, insert all records in staging table and remove update of ozf_act_budgets table to avoid locking.

Line 3746: OZF_UTILITY_PVT.debug_message('approved_amount: ' || px_ozf_act_budgets_tbl(i).APPROVED_AMOUNT);

3742: l_act_budget_id := px_ozf_act_budgets_tbl(i).ACTIVITY_BUDGET_ID;
3743:
3744: IF G_DEBUG THEN
3745: OZF_UTILITY_PVT.debug_message('l_act_budget_id: ' || l_act_budget_id);
3746: OZF_UTILITY_PVT.debug_message('approved_amount: ' || px_ozf_act_budgets_tbl(i).APPROVED_AMOUNT);
3747: END IF;
3748:
3749: /*Bug 9614703, insert all records in staging table and remove update of ozf_act_budgets table to avoid locking.
3750: The update is moved to the concurrent program 'OZF: Update Budgets from Interface Tables'.*/

Line 3821: ozf_utility_pvt.write_conc_log('insrt_count of OZF_ACT_BUDGETS_INT: ' || insrt_count);

3817: -- END IF;
3818: END LOOP;
3819:
3820: IF G_DEBUG THEN
3821: ozf_utility_pvt.write_conc_log('insrt_count of OZF_ACT_BUDGETS_INT: ' || insrt_count);
3822: END IF;
3823:
3824: -- IF insrt_count > 0 THEN
3825: IF p_batch_type = 'CHARGEBACK' THEN

Line 3839: OZF_UTILITY_PVT.debug_message(l_api_name||': End');

3835:
3836: END IF; --IF px_ozf_act_budgets_tbl.COUNT > 0 THEN
3837:
3838: IF G_DEBUG THEN
3839: OZF_UTILITY_PVT.debug_message(l_api_name||': End');
3840: END IF;
3841:
3842: EXCEPTION
3843: WHEN error_no_rollback THEN

Line 3899: px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table,

3895: PROCEDURE UPDATE_OZF_FUNDS_ALL_B (
3896: p_batch_id IN NUMBER,
3897: x_return_status OUT NOCOPY VARCHAR2,
3898: x_fund_update_status OUT NOCOPY VARCHAR2,
3899: px_ozf_funds_new_tbl IN OUT NOCOPY OZF_UTILITY_PVT.ozf_funds_table,
3900: p_batch_type IN VARCHAR2 -- For JMS ER
3901: )
3902: IS
3903: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_OZF_FUNDS_ALL_B';

Line 3989: OZF_UTILITY_PVT.debug_message(l_api_name||': Start');

3985:
3986: SAVEPOINT UPDATE_OZF_FUNDS_ALL_B;
3987:
3988: IF G_DEBUG THEN
3989: OZF_UTILITY_PVT.debug_message(l_api_name||': Start');
3990: OZF_UTILITY_PVT.debug_message('px_ozf_funds_new_tbl.COUNT: ' || px_ozf_funds_new_tbl.COUNT);
3991: END IF;
3992:
3993: -- For TPA Parallel Execution ER - 9614703 (+)

Line 3990: OZF_UTILITY_PVT.debug_message('px_ozf_funds_new_tbl.COUNT: ' || px_ozf_funds_new_tbl.COUNT);

3986: SAVEPOINT UPDATE_OZF_FUNDS_ALL_B;
3987:
3988: IF G_DEBUG THEN
3989: OZF_UTILITY_PVT.debug_message(l_api_name||': Start');
3990: OZF_UTILITY_PVT.debug_message('px_ozf_funds_new_tbl.COUNT: ' || px_ozf_funds_new_tbl.COUNT);
3991: END IF;
3992:
3993: -- For TPA Parallel Execution ER - 9614703 (+)
3994:

Line 4007: OZF_UTILITY_PVT.debug_message('Fund ID: ' || px_ozf_funds_new_tbl(i).FUND_ID);

4003: LOOP
4004: l_fund_id := px_ozf_funds_new_tbl(i).FUND_ID;
4005:
4006: IF G_DEBUG THEN
4007: OZF_UTILITY_PVT.debug_message('Fund ID: ' || px_ozf_funds_new_tbl(i).FUND_ID);
4008: OZF_UTILITY_PVT.debug_message('Earned Amount: ' || px_ozf_funds_new_tbl(i).EARNED_AMT);
4009: END IF;
4010:
4011: /*Bug#9614703

Line 4008: OZF_UTILITY_PVT.debug_message('Earned Amount: ' || px_ozf_funds_new_tbl(i).EARNED_AMT);

4004: l_fund_id := px_ozf_funds_new_tbl(i).FUND_ID;
4005:
4006: IF G_DEBUG THEN
4007: OZF_UTILITY_PVT.debug_message('Fund ID: ' || px_ozf_funds_new_tbl(i).FUND_ID);
4008: OZF_UTILITY_PVT.debug_message('Earned Amount: ' || px_ozf_funds_new_tbl(i).EARNED_AMT);
4009: END IF;
4010:
4011: /*Bug#9614703
4012: All fund records will get inserted into OZF_FUNDS_ALL_B_INT table and processed to

Line 4034: OZF_UTILITY_PVT.debug_message('updating OZF_FUNDS_ALL_B');

4030:
4031: -- Updating the main table OZF_FUNDS_ALL_B using the new record type for chargeback flow only
4032:
4033: IF G_DEBUG THEN
4034: OZF_UTILITY_PVT.debug_message('updating OZF_FUNDS_ALL_B');
4035: END IF;
4036:
4037: UPDATE OZF_FUNDS_ALL_B
4038: SET

Line 4112: OZF_UTILITY_PVT.debug_message('Updating update_rollup_amount from UPDATE_OZF_FUNDS_ALL_B for batch_id='||p_batch_id);

4108: l_fund_rec.rollup_paid_amt := NVL(l_rollup_paid_amt,0) + NVL(px_ozf_funds_new_tbl(i).ROLLUP_PAID_AMT,0);
4109: l_fund_rec.rollup_utilized_amt := NVL(l_rollup_utilized_amt,0) + NVL(px_ozf_funds_new_tbl(i).ROLLUP_UTILIZED_AMT,0);
4110:
4111: IF G_DEBUG THEN
4112: OZF_UTILITY_PVT.debug_message('Updating update_rollup_amount from UPDATE_OZF_FUNDS_ALL_B for batch_id='||p_batch_id);
4113: END IF;
4114:
4115: ozf_funds_pvt.update_rollup_amount(
4116: p_api_version => l_api_version

Line 4151: OZF_UTILITY_PVT.debug_message('Updating update_mc_transactions from UPDATE_OZF_FUNDS_ALL_B for batch_id'||p_batch_id);

4147: l_mc_transaction_rec.amount_column9 := NVL(l_utilized_amt,0) + NVL(px_ozf_funds_new_tbl(i).UTILIZED_AMT,0);
4148:
4149:
4150: IF G_DEBUG THEN
4151: OZF_UTILITY_PVT.debug_message('Updating update_mc_transactions from UPDATE_OZF_FUNDS_ALL_B for batch_id'||p_batch_id);
4152: END IF;
4153:
4154: ozf_mc_transactions_pvt.update_mc_transactions(
4155: p_api_version => l_api_version

Line 4245: ozf_utility_pvt.write_conc_log('insrt_count of OZF_FUNDS_ALL_B_INT: ' || insrt_count);

4241: -- END IF;
4242: END LOOP; -- End of (px_ozf_funds_new_tbl loop)
4243:
4244: IF G_DEBUG THEN
4245: ozf_utility_pvt.write_conc_log('insrt_count of OZF_FUNDS_ALL_B_INT: ' || insrt_count);
4246: END IF;
4247:
4248:
4249: --IF insrt_count > 0 THEN

Line 4266: OZF_UTILITY_PVT.debug_message(l_api_name||': End');

4262:
4263: -- For TPA Parallel Execution ER - 9614703 (-)
4264:
4265: IF G_DEBUG THEN
4266: OZF_UTILITY_PVT.debug_message(l_api_name||': End');
4267: END IF;
4268:
4269: EXCEPTION
4270: WHEN error_no_rollback THEN

Line 4367: END OZF_Utility_PVT;

4363: RETURN l_conv_amt;
4364:
4365: END convert_currency;
4366:
4367: END OZF_Utility_PVT;