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

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

156: BEGIN
157: SAVEPOINT approve_request;
158: -- Initialize
159: IF G_DEBUG THEN
160: ozf_utility_pvt.debug_message(l_full_name || ': start');
161: END IF;
162: x_return_status := fnd_api.g_ret_sts_success;
163: OPEN c_fund_detail(p_source_fund_id);
164: FETCH c_fund_detail INTO l_source_rec.source_org_budget,

Line 220: ozf_utility_pvt.convert_currency(

216: CLOSE c_to_fund_currency;
217:
218: ---- if the two currncies are different then convert the approved amount into the Transfer to fund currency
219: IF l_to_currency <> l_source_rec.source_currency_code THEN
220: ozf_utility_pvt.convert_currency(
221: x_return_status => l_return_status
222: ,p_from_currency => l_source_rec.source_currency_code
223: ,p_to_currency => l_to_currency
224: ,p_from_amount => p_approved_amount

Line 245: ozf_utility_pvt.debug_message(

241: l_source_fund_rec.object_version_number := l_source_rec.source_obj_num;
242: l_source_fund_rec.transfered_out_amt :=
243: NVL(l_source_rec.source_trans_out_amt, 0) + p_approved_amount; -- TRANSFERED IN AMT
244: IF G_DEBUG THEN
245: ozf_utility_pvt.debug_message(
246: l_full_name || 'updating source_fund' || l_source_rec.source_obj_num);
247: END IF;
248: -- Update source fund
249: -- Source record

Line 303: ozf_utility_pvt.get_default_user_status(

299: l_target_fund_rec.transfered_in_amt := NVL(l_to_curr_approved_amt, 0);
300:
301: l_target_fund_rec.status_code := 'ACTIVE';
302: l_target_fund_rec.user_status_id :=
303: ozf_utility_pvt.get_default_user_status(
304: 'OZF_FUND_STATUS'
305: ,l_target_fund_rec.status_code);
306: ELSE
307: l_target_fund_rec.transfered_in_amt :=

Line 314: ozf_utility_pvt.debug_message(

310: --l_target_fund_rec.original_budget := fnd_api.g_miss_num; --bug fix 3579649:rimehrot
311: END IF;
312:
313: IF G_DEBUG THEN
314: ozf_utility_pvt.debug_message(
315: l_full_name ||
316: 'updating target_fund' ||
317: l_target_fund_rec.status_code ||
318: l_target_fund_rec.user_status_id);

Line 359: ozf_utility_pvt.get_default_user_status(

355: -- this will set the status to approved
356: l_act_budget_rec.status_code := 'APPROVED'; -- Approved amount
357: l_act_budget_rec.comment := p_note;
358: l_act_budget_rec.user_status_id :=
359: ozf_utility_pvt.get_default_user_status(
360: g_budget_source_status
361: ,l_act_budget_rec.status_code);
362: -- Fund request record
363: ozf_actbudgets_pvt.update_act_budgets(

Line 430: ozf_utility_pvt.get_default_user_status(

426: l_act_budget_rec.approved_original_amount := p_approved_amount;
427: l_act_budget_rec.status_code := 'APPROVED'; -- Approved amount
428: l_act_budget_rec.comment := p_note;
429: l_act_budget_rec.user_status_id :=
430: ozf_utility_pvt.get_default_user_status(
431: g_budget_source_status
432: ,l_act_budget_rec.status_code);
433: -- Fund request record
434: ozf_actbudgets_pvt.update_act_budgets(

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

589: BEGIN
590: SAVEPOINT negative_request;
591: -- Initialize
592: IF G_DEBUG THEN
593: ozf_utility_pvt.debug_message(l_full_name || ': start');
594: END IF;
595: OPEN c_target_fund_detail(p_target_fund_id);
596: FETCH c_target_fund_detail INTO l_target_rec.target_org_budget,
597: l_target_rec.target_trans_in_amt,

Line 628: l_target_fund_rec.user_status_id := ozf_utility_pvt.get_default_user_status(

624: l_target_fund_rec.status_code := 'REJECTED';
625: ELSE
626: l_target_fund_rec.status_code := 'DRAFT';
627: END IF;
628: l_target_fund_rec.user_status_id := ozf_utility_pvt.get_default_user_status(
629: 'OZF_FUND_STATUS'
630: ,l_target_fund_rec.status_code);
631: ELSE
632: l_target_fund_rec.transfered_in_amt :=

Line 639: ozf_utility_pvt.debug_message(

635: l_target_fund_rec.original_budget := fnd_api.g_miss_num;
636: END IF;
637: */
638: IF G_DEBUG THEN
639: ozf_utility_pvt.debug_message(
640: l_full_name ||
641: 'updating target_fund' ||
642: l_target_fund_rec.status_code ||
643: l_target_fund_rec.user_status_id);

Line 654: l_target_fund_rec.user_status_id := ozf_utility_pvt.get_default_user_status(

650: l_target_fund_rec.status_code := 'REJECTED';
651: ELSE
652: l_target_fund_rec.status_code := 'DRAFT';
653: END IF;
654: l_target_fund_rec.user_status_id := ozf_utility_pvt.get_default_user_status(
655: 'OZF_FUND_STATUS'
656: , l_target_fund_rec.status_code);
657: -- yzhao: 06/28/2002 end
658:

Line 693: ozf_utility_pvt.get_default_user_status(

689: l_act_budget_rec.object_version_number := l_act_budget_obj_num;
690: -- this will set the status to pending
691: l_act_budget_rec.status_code := 'APPROVED'; -- Approved amount
692: l_act_budget_rec.user_status_id :=
693: ozf_utility_pvt.get_default_user_status(
694: g_budget_source_status
695: ,l_act_budget_rec.status_code);
696: -- Fund request record
697: ozf_actbudgets_pvt.update_act_budgets(

Line 759: ozf_utility_pvt.get_default_user_status(

755: -- l_act_budget_rec.approver_id := p_approver_id; -- Approved amount
756: -- changed on 6/24/2002 for ENH#2352621
757: l_act_budget_rec.status_code := p_status_code;
758: l_act_budget_rec.user_status_id :=
759: ozf_utility_pvt.get_default_user_status(
760: g_budget_source_status
761: ,l_act_budget_rec.status_code);
762: l_act_budget_rec.comment := p_note;
763: -- Fund request record

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

952: SAVEPOINT create_fund_request;
953: x_return_status := fnd_api.g_ret_sts_success;
954: -- Initialize
955: IF G_DEBUG THEN
956: ozf_utility_pvt.debug_message(l_full_name || ': start');
957: END IF;
958:
959: IF p_child_flag = 'Y' THEN
960: -- Initialize the request variable prior to creating the request

Line 963: ozf_utility_pvt.get_default_user_status(

959: IF p_child_flag = 'Y' THEN
960: -- Initialize the request variable prior to creating the request
961: l_act_budget_rec.status_code := 'NEW';
962: l_act_budget_rec.user_status_id :=
963: ozf_utility_pvt.get_default_user_status(
964: g_budget_source_status
965: ,l_act_budget_rec.status_code);
966: l_act_budget_rec.arc_act_budget_used_by := 'FUND'; -- hardcoded to fund
967: l_act_budget_rec.act_budget_used_by_id := p_approval_for_id;

Line 993: ozf_utility_pvt.debug_message(l_full_name || ': end creating request');

989: RAISE fnd_api.g_exc_unexpected_error;
990: END IF;
991:
992: IF G_DEBUG THEN
993: ozf_utility_pvt.debug_message(l_full_name || ': end creating request');
994: END IF;
995: END IF;
996:
997: -- Get parent fund owner for the p_approval_fm_id

Line 1078: ozf_utility_pvt.convert_currency(

1074: CLOSE c_to_fund_currency;
1075:
1076: ---- if the two currncies are different then convert the requested amount into the Transfer from fund currency
1077: IF l_to_currency <> l_fm_currency THEN
1078: ozf_utility_pvt.convert_currency(
1079: x_return_status => l_return_status
1080: ,p_from_currency => l_to_currency
1081: ,p_to_currency => l_fm_currency
1082: ,p_from_amount => p_requested_amount

Line 1117: ozf_utility_pvt.debug_message(l_full_name || ': beforing updating child approval to pending');

1113: -- change the act_budget statuscdode = 'PENDING'
1114: ---update the request stauts to pending before submitting if requestor owner is same then the
1115: -- transfer would become approved directly
1116: IF G_DEBUG THEN
1117: ozf_utility_pvt.debug_message(l_full_name || ': beforing updating child approval to pending');
1118: END IF;
1119: ozf_actbudgets_pvt.init_act_budgets_rec(l_act_budget_rec);
1120: l_act_budget_rec.activity_budget_id := l_act_budget_id;
1121: l_act_budget_rec.object_version_number := l_act_budget_appr_rec.object_version_number;

Line 1124: ozf_utility_pvt.get_default_user_status(

1120: l_act_budget_rec.activity_budget_id := l_act_budget_id;
1121: l_act_budget_rec.object_version_number := l_act_budget_appr_rec.object_version_number;
1122: l_act_budget_rec.status_code := 'APPROVED'; -- Approved amount
1123: l_act_budget_rec.user_status_id :=
1124: ozf_utility_pvt.get_default_user_status(
1125: g_budget_source_status
1126: ,l_act_budget_rec.status_code);
1127: -- Fund request record
1128: ozf_actbudgets_pvt.update_act_budgets(

Line 1178: ozf_utility_pvt.get_default_user_status(g_budget_source_status, 'APPROVED');

1174: END IF;
1175: ELSIF x_is_requester_owner = 'N' THEN
1176:
1177: l_new_status_id :=
1178: ozf_utility_pvt.get_default_user_status(g_budget_source_status, 'APPROVED');
1179: l_reject_status_id :=
1180: ozf_utility_pvt.get_default_user_status(g_budget_source_status, 'REJECTED');
1181: -- 08/14/2001 mpande changed activity type
1182: --only for child budget creation.

Line 1180: ozf_utility_pvt.get_default_user_status(g_budget_source_status, 'REJECTED');

1176:
1177: l_new_status_id :=
1178: ozf_utility_pvt.get_default_user_status(g_budget_source_status, 'APPROVED');
1179: l_reject_status_id :=
1180: ozf_utility_pvt.get_default_user_status(g_budget_source_status, 'REJECTED');
1181: -- 08/14/2001 mpande changed activity type
1182: --only for child budget creation.
1183: IF p_child_flag = 'Y' THEN
1184:

Line 1310: ozf_utility_pvt.debug_message(l_api_name || 'Entering' || 'document id ' || document_id);

1306:
1307: l_request_rec c_act_budget_rec%ROWTYPE;
1308: BEGIN
1309: IF G_DEBUG THEN
1310: ozf_utility_pvt.debug_message(l_api_name || 'Entering' || 'document id ' || document_id);
1311: END IF;
1312: document_type := 'text/plain';
1313: -- parse document_id for the ':' dividing item type name from item key value
1314: -- document_id value will take the form : starting with

Line 1373: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);

1369: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1370: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1371: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1372: l_reason_meaning :=
1373: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1374: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1375: l_string1 := fnd_message.get;
1376:
1377: l_note := wf_engine.getitemattrtext(

Line 1487: ozf_utility_pvt.debug_message(l_api_name || 'Entering' || 'document id ' || document_id);

1483:
1484: l_request_rec c_act_budget_rec%ROWTYPE;
1485: BEGIN
1486: IF G_DEBUG THEN
1487: ozf_utility_pvt.debug_message(l_api_name || 'Entering' || 'document id ' || document_id);
1488: END IF;
1489: document_type := 'text/plain';
1490: -- parse document_id for the ':' dividing item type name from item key value
1491: -- document_id value will take the form : starting with

Line 1567: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);

1563: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1564: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1565: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1566: l_reason_meaning :=
1567: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1568: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1569: l_string1 := fnd_message.get;
1570: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_ADDENDUM');
1571: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);

Line 1689: ozf_utility_pvt.debug_message(l_api_name || 'Entering' || 'document id ' || document_id);

1685:
1686: l_request_rec c_act_budget_rec%ROWTYPE;
1687: BEGIN
1688: IF G_DEBUG THEN
1689: ozf_utility_pvt.debug_message(l_api_name || 'Entering' || 'document id ' || document_id);
1690: END IF;
1691: document_type := 'text/plain';
1692: -- parse document_id for the ':' dividing item type name from item key value
1693: -- document_id value will take the form : starting with

Line 1752: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);

1748: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1749: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1750: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1751: l_reason_meaning :=
1752: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1753: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1754: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1755: l_string1 := fnd_message.get;
1756: /*

Line 1879: ozf_utility_pvt.debug_message(l_api_name || 'Entering' || 'document id ' || document_id);

1875:
1876: l_request_rec c_act_budget_rec%ROWTYPE;
1877: BEGIN
1878: IF G_DEBUG THEN
1879: ozf_utility_pvt.debug_message(l_api_name || 'Entering' || 'document id ' || document_id);
1880: END IF;
1881: document_type := 'text/plain';
1882: -- parse document_id for the ':' dividing item type name from item key value
1883: -- document_id value will take the form : starting with

Line 1942: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);

1938: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1939: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1940: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1941: l_reason_meaning :=
1942: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1943: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1944: l_string1 := fnd_message.get;
1945: /*
1946: l_note := wf_engine.getitemattrtext(

Line 2055: ozf_utility_pvt.debug_message(l_api_name || 'Entering' || 'document id ' || document_id);

2051:
2052: l_request_rec c_act_budget_rec%ROWTYPE;
2053: BEGIN
2054: IF G_DEBUG THEN
2055: ozf_utility_pvt.debug_message(l_api_name || 'Entering' || 'document id ' || document_id);
2056: END IF;
2057: document_type := 'text/plain';
2058: -- parse document_id for the ':' dividing item type name from item key value
2059: -- document_id value will take the form : starting with

Line 2118: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);

2114: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2115: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
2116: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
2117: l_reason_meaning :=
2118: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
2119: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
2120: l_string1 := fnd_message.get;
2121: /*
2122: l_note := wf_engine.getitemattrtext(

Line 2488: l_lookup_meaning := ozf_utility_pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER','FREQ');

2484: ,itemkey => itemkey
2485: ,aname => 'APP_SUBJECT'
2486: ,avalue => l_string);
2487: /* mpande added for implementation of BUG#2352621*/
2488: l_lookup_meaning := ozf_utility_pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER','FREQ');
2489: wf_engine.setitemattrtext (
2490: itemtype=> itemtype,
2491: itemkey=> itemkey,
2492: aname => 'AMS_APPROVAL_OBJECT_MEANING',

Line 2627: ozf_utility_pvt.debug_message ('ozf_fund_approval_pvt.get_ntf_rule_values() exception.' || SQLERRM);

2623: CLOSE c_get_rule;
2624: EXCEPTION
2625: WHEN OTHERS THEN
2626: IF G_DEBUG THEN
2627: ozf_utility_pvt.debug_message ('ozf_fund_approval_pvt.get_ntf_rule_values() exception.' || SQLERRM);
2628: END IF;
2629: END Get_Ntf_Rule_Values;
2630:
2631:

Line 2829: ozf_utility_pvt.get_default_user_status(

2825: );
2826: -- yzhao 6/28/2002 bug#2352621 revert status
2827: ELSE
2828: l_next_status_id :=
2829: ozf_utility_pvt.get_default_user_status(
2830: g_budget_source_status
2831: , 'NEW');
2832: END IF;
2833:

Line 2879: ozf_utility_pvt.convert_currency (

2875: -- [END OF BUG 2750841(same as 2741039) FIXING by yzhao 01/10/2003]
2876:
2877: IF l_to_currency <> l_from_currency THEN
2878: -- 08/16/2001 yzhao: convert the request amount to source fund's(approver) currency.
2879: ozf_utility_pvt.convert_currency (
2880: x_return_status=> l_return_status
2881: ,p_from_currency=> l_to_currency
2882: ,p_to_currency=> l_from_currency
2883: ,p_from_amount=> l_approved_amount

Line 2898: l_status_code := ozf_utility_pvt.get_system_status_code(l_next_status_id);

2894: l_approved_amt_in_from_curr := l_approved_amount;
2895: END IF;
2896:
2897: -- x_return_status := fnd_api.g_ret_sts_success;
2898: l_status_code := ozf_utility_pvt.get_system_status_code(l_next_status_id);
2899:
2900: IF l_update_status = 'APPROVED' THEN
2901: approve_request(
2902: p_commit => fnd_api.g_false

Line 2976: ozf_utility_pvt.debug_message(l_full_name || ': l_return_status' || l_return_status);

2972: p_encoded => fnd_api.g_false
2973: ,p_count => l_msg_count
2974: ,p_data => l_msg_data);
2975: IF G_DEBUG THEN
2976: ozf_utility_pvt.debug_message(l_full_name || ': l_return_status' || l_return_status);
2977: END IF;
2978: EXCEPTION
2979: WHEN OTHERS THEN
2980: -- x_return_status := fnd_api.g_ret_sts_error;

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

3089: BEGIN
3090: x_return_status := fnd_api.g_ret_sts_success;
3091: -- Initialize
3092: IF G_DEBUG THEN
3093: ozf_utility_pvt.debug_message(l_full_name || ': start');
3094: END IF;
3095: -- Source Fund Details
3096: OPEN c_fund_detail(p_transac_fund_id);
3097: FETCH c_fund_detail INTO l_fund_id, l_available_amt, l_holdback_amt, l_obj_number;

Line 3140: ozf_utility_pvt.debug_message(l_full_name || l_fund_id || l_obj_number);

3136: l_fund_rec.holdback_amt := NVL(l_holdback_amt, 0) - NVL(p_requested_amount, 0); -- HOLDBACK AMT
3137: END IF;
3138:
3139: IF G_DEBUG THEN
3140: ozf_utility_pvt.debug_message(l_full_name || l_fund_id || l_obj_number);
3141: END IF;
3142: -- Transaction Fund record
3143: l_fund_rec.fund_id := l_fund_id;
3144: l_fund_rec.object_version_number := l_obj_number;