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

Line 425: Ozf_utility_pvt.convert_currency

421: --x_self_amount := l_total_terr_self_amount;
422: --x_rollup_amount := l_total_terr_rollup_amount ;
423: -- Convert the self amount
424:
425: Ozf_utility_pvt.convert_currency
426: (x_return_status => l_return_status
427: ,p_from_currency => l_common_currency_code
428: ,p_to_currency => l_curr_code
429: ,p_from_amount => l_total_terr_self_amount

Line 443: Ozf_utility_pvt.convert_currency

439: END IF;
440:
441: -- Convert the rollup amount
442:
443: Ozf_utility_pvt.convert_currency
444: (x_return_status => l_return_status
445: ,p_from_currency => l_common_currency_code
446: ,p_to_currency => l_curr_code
447: ,p_from_amount => l_total_terr_rollup_amount

Line 761: Ozf_Utility_Pvt.Debug_Message('create_alloc_hierarchy() start ');

757: RAISE fnd_api.g_exc_unexpected_error;
758: END IF;
759:
760: IF G_DEBUG THEN
761: Ozf_Utility_Pvt.Debug_Message('create_alloc_hierarchy() start ');
762: END IF;
763:
764: OPEN c_get_alloc_details;
765: FETCH c_get_alloc_details

Line 1229: ozf_utility_pvt.get_default_user_status('OZF_BUDGETSOURCE_STATUS', l_act_budget_rec.status_code);

1225:
1226: -- first create a NEW actbudget transfer record
1227: l_act_budget_rec.status_code := 'NEW';
1228: l_act_budget_rec.user_status_id :=
1229: ozf_utility_pvt.get_default_user_status('OZF_BUDGETSOURCE_STATUS', l_act_budget_rec.status_code);
1230: l_act_budget_rec.arc_act_budget_used_by := 'FUND';
1231: l_act_budget_rec.act_budget_used_by_id := p_child_fund_id;
1232: l_act_budget_rec.requester_id := l_requestor_id;
1233: l_act_budget_rec.request_amount := p_approved_total; --- in transferring to fund currency

Line 1258: ozf_utility_pvt.get_default_user_status('OZF_BUDGETSOURCE_STATUS', l_act_budget_rec.status_code);

1254: l_act_budget_rec.object_version_number := 1;
1255: l_act_budget_rec.status_code := 'APPROVED';
1256: l_act_budget_rec.approved_amount := p_approved_total;
1257: l_act_budget_rec.user_status_id :=
1258: ozf_utility_pvt.get_default_user_status('OZF_BUDGETSOURCE_STATUS', l_act_budget_rec.status_code);
1259: ozf_actbudgets_pvt.update_act_budgets(
1260: p_api_version => p_api_version
1261: , p_init_msg_list => fnd_api.g_true
1262: , p_commit => fnd_api.g_false

Line 1397: ozf_utility_pvt.debug_message(l_full_name || ': start');

1393: BEGIN
1394:
1395: SAVEPOINT publish_allocation_sp;
1396: IF G_DEBUG THEN
1397: ozf_utility_pvt.debug_message(l_full_name || ': start');
1398: END IF;
1399: x_return_status := fnd_api.g_ret_sts_success;
1400:
1401: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1607: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',

1603: END IF;
1604:
1605: /* send notification to child budget owner */
1606: IF l_fund_type = 'QUOTA' THEN
1607: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
1608: p_lookup_code => 'QUOTA',
1609: x_return_status => l_temp_status,
1610: x_meaning => l_fund_meaning);
1611: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN

Line 1612: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',

1608: p_lookup_code => 'QUOTA',
1609: x_return_status => l_temp_status,
1610: x_meaning => l_fund_meaning);
1611: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN
1612: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
1613: p_lookup_code => 'BUDGET',
1614: x_return_status => l_temp_status,
1615: x_meaning => l_fund_meaning);
1616: END IF;

Line 1629: ozf_utility_pvt.send_wf_standalone_message(

1625: fnd_message.set_token ('ALLOC_STATUS', l_alloc_status);
1626: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1627: l_notif_body := substrb(fnd_message.get, 1, 4000);
1628:
1629: ozf_utility_pvt.send_wf_standalone_message(
1630: p_subject => l_notif_subject
1631: , p_body => l_notif_body
1632: , p_send_to_res_id => l_child_fund_owner
1633: , x_notif_id => l_return_id

Line 2173: OZF_Utility_PVT.debug_message('Validate_worksheet: start');

2169: AND previous_fact_id = p_parent_fact_id;
2170:
2171: BEGIN
2172: IF G_DEBUG THEN
2173: OZF_Utility_PVT.debug_message('Validate_worksheet: start');
2174: END IF;
2175:
2176: IF FND_API.To_Boolean (p_init_msg_list) THEN
2177: FND_MSG_PUB.Initialize;

Line 2315: ozf_utility_pvt.debug_message(l_full_name || ': start');

2311: BEGIN
2312: SAVEPOINT update_worksheet_amount_sp;
2313:
2314: IF G_DEBUG THEN
2315: ozf_utility_pvt.debug_message(l_full_name || ': start');
2316: END IF;
2317: x_return_status := fnd_api.g_ret_sts_success;
2318:
2319: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 2646: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',

2642: END IF;
2643:
2644: /* send notification to child budget owner */
2645: IF l_fund_type = 'QUOTA' THEN
2646: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
2647: p_lookup_code => 'QUOTA',
2648: x_return_status => l_temp_status,
2649: x_meaning => l_fund_meaning);
2650: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN

Line 2651: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',

2647: p_lookup_code => 'QUOTA',
2648: x_return_status => l_temp_status,
2649: x_meaning => l_fund_meaning);
2650: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN
2651: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
2652: p_lookup_code => 'BUDGET',
2653: x_return_status => l_temp_status,
2654: x_meaning => l_fund_meaning);
2655: END IF;

Line 2671: ozf_utility_pvt.send_wf_standalone_message(

2667: fnd_message.set_token ('APPROVED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(nvl(p_approved_total,0),l_child_fund_currency));
2668: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
2669: l_notif_body := substrb(fnd_message.get, 1, 4000);
2670:
2671: ozf_utility_pvt.send_wf_standalone_message(
2672: p_subject => l_notif_subject
2673: , p_body => l_notif_body
2674: , p_send_to_res_id => l_child_fund_owner
2675: , x_notif_id => l_return_id

Line 2762: ozf_utility_pvt.debug_message(l_full_name || ': start');

2758: AND previous_fact_id = p_previous_fact_id;
2759:
2760: BEGIN
2761: IF G_DEBUG THEN
2762: ozf_utility_pvt.debug_message(l_full_name || ': start');
2763: END IF;
2764: x_return_status := fnd_api.g_ret_sts_success;
2765:
2766: OPEN c_get_metric_info;

Line 2950: ozf_utility_pvt.debug_message(l_full_name || ': start');

2946: WHERE fund_id = p_fund_id;
2947:
2948: BEGIN
2949: IF G_DEBUG THEN
2950: ozf_utility_pvt.debug_message(l_full_name || ': start');
2951: END IF;
2952: x_return_status := fnd_api.g_ret_sts_success;
2953:
2954: OPEN c_get_metric_info;

Line 3057: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',

3053: END IF;
3054:
3055: /* send notification to child budget owner */
3056: IF l_fund_type = 'QUOTA' THEN
3057: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
3058: p_lookup_code => 'QUOTA',
3059: x_return_status => l_temp_status,
3060: x_meaning => l_fund_meaning);
3061: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN

Line 3062: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',

3058: p_lookup_code => 'QUOTA',
3059: x_return_status => l_temp_status,
3060: x_meaning => l_fund_meaning);
3061: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN
3062: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
3063: p_lookup_code => 'BUDGET',
3064: x_return_status => l_temp_status,
3065: x_meaning => l_fund_meaning);
3066: END IF;

Line 3079: ozf_utility_pvt.send_wf_standalone_message(

3075: fnd_message.set_token ('ALLOC_STATUS', 'CANCELLED');
3076: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3077: l_notif_body := substrb(fnd_message.get, 1, 4000);
3078:
3079: ozf_utility_pvt.send_wf_standalone_message(
3080: p_subject => l_notif_subject
3081: , p_body => l_notif_body
3082: , p_send_to_res_id => l_fund_owner
3083: , x_notif_id => l_return_id

Line 3289: ozf_utility_pvt.debug_message('approve_levels(): start');

3285:
3286: BEGIN
3287: SAVEPOINT approve_levels_sp;
3288: IF G_DEBUG THEN
3289: ozf_utility_pvt.debug_message('approve_levels(): start');
3290: END IF;
3291: x_return_status := fnd_api.g_ret_sts_success;
3292:
3293: IF p_factid_table.COUNT = 0 THEN

Line 3465: ozf_utility_pvt.debug_message('submit_request(): start');

3461:
3462: BEGIN
3463: SAVEPOINT submit_request_sp;
3464: IF G_DEBUG THEN
3465: ozf_utility_pvt.debug_message('submit_request(): start');
3466: END IF;
3467: x_return_status := fnd_api.g_ret_sts_success;
3468:
3469: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 3481: ozf_utility_pvt.debug_message('submit_request(): only planned or rejected can submit. status=' || l_alloc_status);

3477: -- only allocation in 'PLANNED' or 'REJECTED' status can user submit request
3478: -- not returning error message here since submit is not exposted to user from UI for this case
3479: IF (l_alloc_status <> 'PLANNED' AND l_alloc_status <> 'REJECTED') THEN
3480: IF G_DEBUG THEN
3481: ozf_utility_pvt.debug_message('submit_request(): only planned or rejected can submit. status=' || l_alloc_status);
3482: END IF;
3483: RAISE FND_API.G_EXC_ERROR;
3484: END IF;
3485:

Line 3545: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',

3541: END IF;
3542:
3543: /* send request notice to parent budget owner */
3544: IF l_fund_type = 'QUOTA' THEN
3545: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
3546: p_lookup_code => 'QUOTA',
3547: x_return_status => l_temp_status,
3548: x_meaning => l_fund_meaning);
3549: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN

Line 3550: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',

3546: p_lookup_code => 'QUOTA',
3547: x_return_status => l_temp_status,
3548: x_meaning => l_fund_meaning);
3549: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN
3550: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
3551: p_lookup_code => 'BUDGET',
3552: x_return_status => l_temp_status,
3553: x_meaning => l_fund_meaning);
3554: END IF;

Line 3570: ozf_utility_pvt.send_wf_standalone_message(

3566: fnd_message.set_token ('REQUESTOR_NOTE', p_note);
3567: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3568: l_notif_body := substrb(fnd_message.get, 1, 4000);
3569:
3570: ozf_utility_pvt.send_wf_standalone_message(
3571: p_subject => l_notif_subject
3572: , p_body => l_notif_body
3573: , p_send_to_res_id => l_parent_budget_owner
3574: , x_notif_id => l_return_id

Line 3643: ozf_utility_pvt.debug_message('reject_request(): start');

3639:
3640: BEGIN
3641: SAVEPOINT reject_request_sp;
3642: IF G_DEBUG THEN
3643: ozf_utility_pvt.debug_message('reject_request(): start');
3644: END IF;
3645: x_return_status := fnd_api.g_ret_sts_success;
3646:
3647: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 3689: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',

3685: END IF;
3686:
3687: -- send notification to child budget owner of rejection
3688: IF l_fund_type = 'QUOTA' THEN
3689: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
3690: p_lookup_code => 'QUOTA',
3691: x_return_status => l_temp_status,
3692: x_meaning => l_fund_meaning);
3693: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN

Line 3694: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',

3690: p_lookup_code => 'QUOTA',
3691: x_return_status => l_temp_status,
3692: x_meaning => l_fund_meaning);
3693: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN
3694: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
3695: p_lookup_code => 'BUDGET',
3696: x_return_status => l_temp_status,
3697: x_meaning => l_fund_meaning);
3698: END IF;

Line 3713: ozf_utility_pvt.send_wf_standalone_message(

3709: fnd_message.set_token ('REQUESTED_TOTAL_AMOUNT', ams_utility_pvt.CurrRound(l_request_total,l_budget_currency));
3710: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
3711: l_notif_body := substrb(fnd_message.get, 1, 4000);
3712:
3713: ozf_utility_pvt.send_wf_standalone_message(
3714: p_subject => l_notif_subject
3715: , p_body => l_notif_body
3716: , p_send_to_res_id => l_budget_owner
3717: , x_notif_id => l_return_id