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 158: ozf_utility_pvt.debug_message(l_full_name || ': start');

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

Line 218: ozf_utility_pvt.convert_currency(

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

Line 243: ozf_utility_pvt.debug_message(

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

Line 301: ozf_utility_pvt.get_default_user_status(

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

Line 312: ozf_utility_pvt.debug_message(

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

Line 357: ozf_utility_pvt.get_default_user_status(

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

Line 428: ozf_utility_pvt.get_default_user_status(

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

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

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

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

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

Line 637: ozf_utility_pvt.debug_message(

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

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

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

Line 691: ozf_utility_pvt.get_default_user_status(

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

Line 757: ozf_utility_pvt.get_default_user_status(

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

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

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

Line 960: ozf_utility_pvt.get_default_user_status(

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

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

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

Line 1057: ozf_utility_pvt.convert_currency(

1053: CLOSE c_to_fund_currency;
1054:
1055: ---- if the two currncies are different then convert the requested amount into the Transfer from fund currency
1056: IF l_to_currency <> l_fm_currency THEN
1057: ozf_utility_pvt.convert_currency(
1058: x_return_status => l_return_status
1059: ,p_from_currency => l_to_currency
1060: ,p_to_currency => l_fm_currency
1061: ,p_from_amount => p_requested_amount

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

1092: -- change the act_budget statuscdode = 'PENDING'
1093: ---update the request stauts to pending before submitting if requestor owner is same then the
1094: -- transfer would become approved directly
1095: IF G_DEBUG THEN
1096: ozf_utility_pvt.debug_message(l_full_name || ': beforing updating child approval to pending');
1097: END IF;
1098: ozf_actbudgets_pvt.init_act_budgets_rec(l_act_budget_rec);
1099: l_act_budget_rec.activity_budget_id := l_act_budget_id;
1100: l_act_budget_rec.object_version_number := l_act_budget_appr_rec.object_version_number;

Line 1103: ozf_utility_pvt.get_default_user_status(

1099: l_act_budget_rec.activity_budget_id := l_act_budget_id;
1100: l_act_budget_rec.object_version_number := l_act_budget_appr_rec.object_version_number;
1101: l_act_budget_rec.status_code := 'APPROVED'; -- Approved amount
1102: l_act_budget_rec.user_status_id :=
1103: ozf_utility_pvt.get_default_user_status(
1104: g_budget_source_status
1105: ,l_act_budget_rec.status_code);
1106: -- Fund request record
1107: ozf_actbudgets_pvt.update_act_budgets(

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

1153: END IF;
1154: ELSIF x_is_requester_owner = 'N' THEN
1155:
1156: l_new_status_id :=
1157: ozf_utility_pvt.get_default_user_status(g_budget_source_status, 'APPROVED');
1158: l_reject_status_id :=
1159: ozf_utility_pvt.get_default_user_status(g_budget_source_status, 'REJECTED');
1160: -- 08/14/2001 mpande changed activity type
1161: --only for child budget creation.

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

1155:
1156: l_new_status_id :=
1157: ozf_utility_pvt.get_default_user_status(g_budget_source_status, 'APPROVED');
1158: l_reject_status_id :=
1159: ozf_utility_pvt.get_default_user_status(g_budget_source_status, 'REJECTED');
1160: -- 08/14/2001 mpande changed activity type
1161: --only for child budget creation.
1162: IF p_child_flag = 'Y' THEN
1163:

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

1285:
1286: l_request_rec c_act_budget_rec%ROWTYPE;
1287: BEGIN
1288: IF G_DEBUG THEN
1289: ozf_utility_pvt.debug_message(l_api_name || 'Entering' || 'document id ' || document_id);
1290: END IF;
1291: document_type := 'text/plain';
1292: -- parse document_id for the ':' dividing item type name from item key value
1293: -- document_id value will take the form : starting with

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

1348: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1349: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1350: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1351: l_reason_meaning :=
1352: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1353: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1354: l_string1 := fnd_message.get;
1355:
1356: l_note := wf_engine.getitemattrtext(

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

1462:
1463: l_request_rec c_act_budget_rec%ROWTYPE;
1464: BEGIN
1465: IF G_DEBUG THEN
1466: ozf_utility_pvt.debug_message(l_api_name || 'Entering' || 'document id ' || document_id);
1467: END IF;
1468: document_type := 'text/plain';
1469: -- parse document_id for the ':' dividing item type name from item key value
1470: -- document_id value will take the form : starting with

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

1542: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1543: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1544: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1545: l_reason_meaning :=
1546: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1547: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1548: l_string1 := fnd_message.get;
1549: fnd_message.set_name('OZF', 'OZF_WF_NTF_REQUESTER_ADDENDUM');
1550: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);

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

1664:
1665: l_request_rec c_act_budget_rec%ROWTYPE;
1666: BEGIN
1667: IF G_DEBUG THEN
1668: ozf_utility_pvt.debug_message(l_api_name || 'Entering' || 'document id ' || document_id);
1669: END IF;
1670: document_type := 'text/plain';
1671: -- parse document_id for the ':' dividing item type name from item key value
1672: -- document_id value will take the form : starting with

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

1727: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1728: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1729: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1730: l_reason_meaning :=
1731: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1732: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1733: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1734: l_string1 := fnd_message.get;
1735: /*

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

1854:
1855: l_request_rec c_act_budget_rec%ROWTYPE;
1856: BEGIN
1857: IF G_DEBUG THEN
1858: ozf_utility_pvt.debug_message(l_api_name || 'Entering' || 'document id ' || document_id);
1859: END IF;
1860: document_type := 'text/plain';
1861: -- parse document_id for the ':' dividing item type name from item key value
1862: -- document_id value will take the form : starting with

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

1917: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
1918: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
1919: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
1920: l_reason_meaning :=
1921: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
1922: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
1923: l_string1 := fnd_message.get;
1924: /*
1925: l_note := wf_engine.getitemattrtext(

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

2030:
2031: l_request_rec c_act_budget_rec%ROWTYPE;
2032: BEGIN
2033: IF G_DEBUG THEN
2034: ozf_utility_pvt.debug_message(l_api_name || 'Entering' || 'document id ' || document_id);
2035: END IF;
2036: document_type := 'text/plain';
2037: -- parse document_id for the ':' dividing item type name from item key value
2038: -- document_id value will take the form : starting with

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

2093: fnd_message.set_token('CURRENCY_CODE', l_request_rec.to_budget_curr, FALSE);
2094: fnd_message.set_token('REQUEST_AMOUNT', l_requested_amt, FALSE);
2095: fnd_message.set_token('JUSTIFICATION', l_note, FALSE);
2096: l_reason_meaning :=
2097: ozf_utility_pvt.get_lookup_meaning('AMS_TRANSFER_REASON', l_request_rec.reason_code);
2098: fnd_message.set_token('REASON', l_reason_meaning, FALSE);
2099: l_string1 := fnd_message.get;
2100: /*
2101: l_note := wf_engine.getitemattrtext(

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

2456: ,itemkey => itemkey
2457: ,aname => 'APP_SUBJECT'
2458: ,avalue => l_string);
2459: /* mpande added for implementation of BUG#2352621*/
2460: l_lookup_meaning := ozf_utility_pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER','FREQ');
2461: wf_engine.setitemattrtext (
2462: itemtype=> itemtype,
2463: itemkey=> itemkey,
2464: aname => 'AMS_APPROVAL_OBJECT_MEANING',

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

2595: CLOSE c_get_rule;
2596: EXCEPTION
2597: WHEN OTHERS THEN
2598: IF G_DEBUG THEN
2599: ozf_utility_pvt.debug_message ('ozf_fund_approval_pvt.get_ntf_rule_values() exception.' || SQLERRM);
2600: END IF;
2601: END Get_Ntf_Rule_Values;
2602:
2603:

Line 2801: ozf_utility_pvt.get_default_user_status(

2797: );
2798: -- yzhao 6/28/2002 bug#2352621 revert status
2799: ELSE
2800: l_next_status_id :=
2801: ozf_utility_pvt.get_default_user_status(
2802: g_budget_source_status
2803: , 'NEW');
2804: END IF;
2805:

Line 2851: ozf_utility_pvt.convert_currency (

2847: -- [END OF BUG 2750841(same as 2741039) FIXING by yzhao 01/10/2003]
2848:
2849: IF l_to_currency <> l_from_currency THEN
2850: -- 08/16/2001 yzhao: convert the request amount to source fund's(approver) currency.
2851: ozf_utility_pvt.convert_currency (
2852: x_return_status=> l_return_status
2853: ,p_from_currency=> l_to_currency
2854: ,p_to_currency=> l_from_currency
2855: ,p_from_amount=> l_approved_amount

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

2866: l_approved_amt_in_from_curr := l_approved_amount;
2867: END IF;
2868:
2869: -- x_return_status := fnd_api.g_ret_sts_success;
2870: l_status_code := ozf_utility_pvt.get_system_status_code(l_next_status_id);
2871:
2872: IF l_update_status = 'APPROVED' THEN
2873: approve_request(
2874: p_commit => fnd_api.g_false

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

2944: p_encoded => fnd_api.g_false
2945: ,p_count => l_msg_count
2946: ,p_data => l_msg_data);
2947: IF G_DEBUG THEN
2948: ozf_utility_pvt.debug_message(l_full_name || ': l_return_status' || l_return_status);
2949: END IF;
2950: EXCEPTION
2951: WHEN OTHERS THEN
2952: -- x_return_status := fnd_api.g_ret_sts_error;

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

3061: BEGIN
3062: x_return_status := fnd_api.g_ret_sts_success;
3063: -- Initialize
3064: IF G_DEBUG THEN
3065: ozf_utility_pvt.debug_message(l_full_name || ': start');
3066: END IF;
3067: -- Source Fund Details
3068: OPEN c_fund_detail(p_transac_fund_id);
3069: FETCH c_fund_detail INTO l_fund_id, l_available_amt, l_holdback_amt, l_obj_number;

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

3108: l_fund_rec.holdback_amt := NVL(l_holdback_amt, 0) - NVL(p_requested_amount, 0); -- HOLDBACK AMT
3109: END IF;
3110:
3111: IF G_DEBUG THEN
3112: ozf_utility_pvt.debug_message(l_full_name || l_fund_id || l_obj_number);
3113: END IF;
3114: -- Transaction Fund record
3115: l_fund_rec.fund_id := l_fund_id;
3116: l_fund_rec.object_version_number := l_obj_number;