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

Line 100: ozf_utility_pvt.debug_message (

96: WHERE fund_id = p_fund_id;
97: */
98: BEGIN
99: IF G_DEBUG THEN
100: ozf_utility_pvt.debug_message (
101: l_api_name
102: || 'Entering'
103: || 'document id '
104: || document_id

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

152: l_requester,
153: l_fund_type;
154: CLOSE c_fund_rec;
155: IF l_fund_type = 'QUOTA' THEN
156: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
157: p_lookup_code => 'QUOTA',
158: x_return_status => l_return_status,
159: x_meaning => l_fund_meaning);
160: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN

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

157: p_lookup_code => 'QUOTA',
158: x_return_status => l_return_status,
159: x_meaning => l_fund_meaning);
160: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN
161: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
162: p_lookup_code => 'BUDGET',
163: x_return_status => l_return_status,
164: x_meaning => l_fund_meaning);
165: END IF;

Line 311: ozf_utility_pvt.debug_message (

307: WHERE fund_id = p_fund_id;
308: */
309: BEGIN
310: IF G_DEBUG THEN
311: ozf_utility_pvt.debug_message (
312: l_api_name
313: || 'Entering'
314: || 'document id '
315: || document_id

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

371: l_fund_type;
372: -- l_requested_amt; 01/28/2003 yzhao: requested amount is not original_budget
373: CLOSE c_fund_rec;
374: IF l_fund_type = 'QUOTA' THEN
375: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
376: p_lookup_code => 'QUOTA',
377: x_return_status => l_return_status,
378: x_meaning => l_fund_meaning);
379: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN

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

376: p_lookup_code => 'QUOTA',
377: x_return_status => l_return_status,
378: x_meaning => l_fund_meaning);
379: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN
380: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
381: p_lookup_code => 'BUDGET',
382: x_return_status => l_return_status,
383: x_meaning => l_fund_meaning);
384: END IF;

Line 518: ozf_utility_pvt.debug_message (

514: FROM ozf_funds_all_vl
515: WHERE fund_id = p_fund_id;
516: BEGIN
517: IF G_DEBUG THEN
518: ozf_utility_pvt.debug_message (
519: l_api_name
520: || 'Entering'
521: || 'document id '
522: || document_id

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

575: l_curr_code,
576: l_start_date,
577: l_fund_type;
578: IF l_fund_type = 'QUOTA' THEN
579: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
580: p_lookup_code => 'QUOTA',
581: x_return_status => l_return_status,
582: x_meaning => l_fund_meaning);
583: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN

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

580: p_lookup_code => 'QUOTA',
581: x_return_status => l_return_status,
582: x_meaning => l_fund_meaning);
583: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN
584: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
585: p_lookup_code => 'BUDGET',
586: x_return_status => l_return_status,
587: x_meaning => l_fund_meaning);
588: END IF;

Line 734: ozf_utility_pvt.debug_message (

730: WHERE fund_id = p_fund_id;
731: */
732: BEGIN
733: IF G_DEBUG THEN
734: ozf_utility_pvt.debug_message (
735: l_api_name
736: || 'Entering'
737: || 'document id '
738: || document_id

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

792: l_requester,
793: l_fund_type;
794: CLOSE c_fund_rec;
795: IF l_fund_type = 'QUOTA' THEN
796: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
797: p_lookup_code => 'QUOTA',
798: x_return_status => l_return_status,
799: x_meaning => l_fund_meaning);
800: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN

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

797: p_lookup_code => 'QUOTA',
798: x_return_status => l_return_status,
799: x_meaning => l_fund_meaning);
800: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN
801: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
802: p_lookup_code => 'BUDGET',
803: x_return_status => l_return_status,
804: x_meaning => l_fund_meaning);
805: END IF;

Line 949: ozf_utility_pvt.debug_message (

945: FROM ozf_funds_all_vl
946: WHERE fund_id = p_fund_id;
947: BEGIN
948: IF G_DEBUG THEN
949: ozf_utility_pvt.debug_message (
950: l_api_name
951: || 'Entering'
952: || 'document id '
953: || document_id

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

1006: l_start_date,
1007: l_fund_type;
1008: CLOSE c_fund_rec;
1009: IF l_fund_type = 'QUOTA' THEN
1010: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
1011: p_lookup_code => 'QUOTA',
1012: x_return_status => l_return_status,
1013: x_meaning => l_fund_meaning);
1014: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN

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

1011: p_lookup_code => 'QUOTA',
1012: x_return_status => l_return_status,
1013: x_meaning => l_fund_meaning);
1014: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN
1015: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
1016: p_lookup_code => 'BUDGET',
1017: x_return_status => l_return_status,
1018: x_meaning => l_fund_meaning);
1019: END IF;

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

1200: l_fund_type;
1201: CLOSE c_fund_rec;
1202:
1203: IF l_fund_type = 'QUOTA' THEN
1204: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
1205: p_lookup_code => 'QUOTA',
1206: x_return_status => l_return_status,
1207: x_meaning => l_fund_meaning);
1208: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN

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

1205: p_lookup_code => 'QUOTA',
1206: x_return_status => l_return_status,
1207: x_meaning => l_fund_meaning);
1208: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN
1209: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
1210: p_lookup_code => 'BUDGET',
1211: x_return_status => l_return_status,
1212: x_meaning => l_fund_meaning);
1213: END IF;

Line 1342: l_lookup_meaning := ozf_utility_pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER','RFRQ');

1338: aname => 'APP_SUBJECT',
1339: avalue=> l_string
1340: );
1341: /* mpande added for implementation of BUG#2352621*/
1342: l_lookup_meaning := ozf_utility_pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER','RFRQ');
1343: wf_engine.setitemattrtext (
1344: itemtype=> itemtype,
1345: itemkey=> itemkey,
1346: aname => 'AMS_APPROVAL_OBJECT_MEANING',

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

1463: CLOSE c_get_rule;
1464: EXCEPTION
1465: WHEN OTHERS THEN
1466: IF G_DEBUG THEN
1467: ozf_utility_pvt.debug_message ('ozf_fund_approval_pvt.get_ntf_rule_values() exception.' || SQLERRM);
1468: END IF;
1469: RAISE;
1470: END Get_Ntf_Rule_Values;
1471: ---------------------------------------------------------------------

Line 1662: ozf_utility_pvt.debug_message ( l_full_name || l_update_status);

1658: aname => 'AMS_AMOUNT',
1659: avalue=> l_fund_rec.original_budget
1660: );
1661: IF G_DEBUG THEN
1662: ozf_utility_pvt.debug_message ( l_full_name || l_update_status);
1663: END IF;
1664: -- mpande 6/11/2002 bug#2352621
1665: ELSIF l_update_status = 'REJECTED' THEN
1666: l_next_status_id :=

Line 1676: -- ozf_utility_pvt.get_default_user_status ( 'OZF_FUND_STATUS' ,'DRAFT');

1672: -- mpande 6/11/2002 bug#2352621
1673: -- Status is 'ERROR' during error in wf so the status of the fund should change back to 'DRAFT'
1674: ELSE
1675: --l_next_status_id :=
1676: -- ozf_utility_pvt.get_default_user_status ( 'OZF_FUND_STATUS' ,'DRAFT');
1677: -- 06/28/2002 yzhao: no valiation for update so status always revert to 'DRAFT' when error occurs
1678: l_next_status_id := wf_engine.GetItemAttrNumber(
1679: itemtype => itemtype,
1680: itemkey => itemkey,

Line 1686: ozf_utility_pvt.get_system_status_code (l_next_status_id);

1682: l_validation_level := fnd_api.g_valid_level_none;
1683: END IF;
1684: -- x_return_status := fnd_api.g_ret_sts_success;
1685: l_status_code :=
1686: ozf_utility_pvt.get_system_status_code (l_next_status_id);
1687: l_fund_rec.fund_id := l_fund_id;
1688: l_fund_rec.user_status_id := l_next_status_id;
1689: l_fund_rec.status_code := l_status_code;
1690: l_fund_rec.object_version_number := l_object_version_number

Line 1693: ozf_utility_pvt.debug_message (

1689: l_fund_rec.status_code := l_status_code;
1690: l_fund_rec.object_version_number := l_object_version_number
1691: + 1;
1692: IF G_DEBUG THEN
1693: ozf_utility_pvt.debug_message (
1694: l_full_name
1695: || l_status_code || ' '
1696: || l_approved_amount || ' '
1697: || l_update_status

Line 1712: ozf_utility_pvt.debug_message(l_full_name || ' failed to update fund to status ' || l_status_code);

1708: p_mode=> g_fund_mode
1709: );
1710: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1711: IF G_DEBUG THEN
1712: ozf_utility_pvt.debug_message(l_full_name || ' failed to update fund to status ' || l_status_code);
1713: END IF;
1714: ams_gen_approval_pvt.handle_err (
1715: p_itemtype=> itemtype,
1716: p_itemkey=> itemkey,

Line 1747: ozf_utility_pvt.debug_message (

1743: p_count=> l_msg_count,
1744: p_data=> l_msg_data
1745: );
1746: IF G_DEBUG THEN
1747: ozf_utility_pvt.debug_message (
1748: l_full_name
1749: || ': l_return_status'
1750: || l_return_status
1751: );

Line 1814: ozf_utility_pvt.get_system_status_code (2100);

1810: aname => 'AMS_ACTIVITY_ID'
1811: );
1812: -- x_return_status := fnd_api.g_ret_sts_success;
1813: l_status_code :=
1814: ozf_utility_pvt.get_system_status_code (2100);
1815: ozf_funds_pvt.init_fund_rec (x_fund_rec => l_fund_rec);
1816: l_fund_rec.fund_id := l_fund_id;
1817: l_fund_rec.user_status_id := 2100;
1818: l_fund_rec.status_code := l_status_code;

Line 1822: ozf_utility_pvt.debug_message (

1818: l_fund_rec.status_code := l_status_code;
1819: l_fund_rec.object_version_number := l_object_version_number
1820: + 1;
1821: IF G_DEBUG THEN
1822: ozf_utility_pvt.debug_message (
1823: l_full_name
1824: || l_status_code
1825: || l_approved_amount
1826: || l_update_status

Line 1868: ozf_utility_pvt.debug_message (

1864: p_count=> l_msg_count,
1865: p_data=> l_msg_data
1866: );
1867: IF G_DEBUG THEN
1868: ozf_utility_pvt.debug_message (
1869: l_full_name
1870: || ': l_return_status'
1871: || l_return_status
1872: );