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 136: ozf_utility_pvt.debug_message (

132: WHERE fund_id = p_fund_id;
133: */
134: BEGIN
135: IF G_DEBUG THEN
136: ozf_utility_pvt.debug_message (
137: l_api_name
138: || 'Entering'
139: || 'document id '
140: || document_id

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

188: l_requester,
189: l_fund_type;
190: CLOSE c_fund_rec;
191: IF l_fund_type = 'QUOTA' THEN
192: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
193: p_lookup_code => 'QUOTA',
194: x_return_status => l_return_status,
195: x_meaning => l_fund_meaning);
196: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN

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

193: p_lookup_code => 'QUOTA',
194: x_return_status => l_return_status,
195: x_meaning => l_fund_meaning);
196: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN
197: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
198: p_lookup_code => 'BUDGET',
199: x_return_status => l_return_status,
200: x_meaning => l_fund_meaning);
201: END IF;

Line 347: ozf_utility_pvt.debug_message (

343: WHERE fund_id = p_fund_id;
344: */
345: BEGIN
346: IF G_DEBUG THEN
347: ozf_utility_pvt.debug_message (
348: l_api_name
349: || 'Entering'
350: || 'document id '
351: || document_id

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

407: l_fund_type;
408: -- l_requested_amt; 01/28/2003 yzhao: requested amount is not original_budget
409: CLOSE c_fund_rec;
410: IF l_fund_type = 'QUOTA' THEN
411: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
412: p_lookup_code => 'QUOTA',
413: x_return_status => l_return_status,
414: x_meaning => l_fund_meaning);
415: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN

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

412: p_lookup_code => 'QUOTA',
413: x_return_status => l_return_status,
414: x_meaning => l_fund_meaning);
415: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN
416: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
417: p_lookup_code => 'BUDGET',
418: x_return_status => l_return_status,
419: x_meaning => l_fund_meaning);
420: END IF;

Line 554: ozf_utility_pvt.debug_message (

550: FROM ozf_funds_all_vl
551: WHERE fund_id = p_fund_id;
552: BEGIN
553: IF G_DEBUG THEN
554: ozf_utility_pvt.debug_message (
555: l_api_name
556: || 'Entering'
557: || 'document id '
558: || document_id

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

611: l_curr_code,
612: l_start_date,
613: l_fund_type;
614: IF l_fund_type = 'QUOTA' THEN
615: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
616: p_lookup_code => 'QUOTA',
617: x_return_status => l_return_status,
618: x_meaning => l_fund_meaning);
619: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN

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

616: p_lookup_code => 'QUOTA',
617: x_return_status => l_return_status,
618: x_meaning => l_fund_meaning);
619: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN
620: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
621: p_lookup_code => 'BUDGET',
622: x_return_status => l_return_status,
623: x_meaning => l_fund_meaning);
624: END IF;

Line 770: ozf_utility_pvt.debug_message (

766: WHERE fund_id = p_fund_id;
767: */
768: BEGIN
769: IF G_DEBUG THEN
770: ozf_utility_pvt.debug_message (
771: l_api_name
772: || 'Entering'
773: || 'document id '
774: || document_id

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

828: l_requester,
829: l_fund_type;
830: CLOSE c_fund_rec;
831: IF l_fund_type = 'QUOTA' THEN
832: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
833: p_lookup_code => 'QUOTA',
834: x_return_status => l_return_status,
835: x_meaning => l_fund_meaning);
836: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN

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

833: p_lookup_code => 'QUOTA',
834: x_return_status => l_return_status,
835: x_meaning => l_fund_meaning);
836: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN
837: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
838: p_lookup_code => 'BUDGET',
839: x_return_status => l_return_status,
840: x_meaning => l_fund_meaning);
841: END IF;

Line 985: ozf_utility_pvt.debug_message (

981: FROM ozf_funds_all_vl
982: WHERE fund_id = p_fund_id;
983: BEGIN
984: IF G_DEBUG THEN
985: ozf_utility_pvt.debug_message (
986: l_api_name
987: || 'Entering'
988: || 'document id '
989: || document_id

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

1042: l_start_date,
1043: l_fund_type;
1044: CLOSE c_fund_rec;
1045: IF l_fund_type = 'QUOTA' THEN
1046: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
1047: p_lookup_code => 'QUOTA',
1048: x_return_status => l_return_status,
1049: x_meaning => l_fund_meaning);
1050: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN

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

1047: p_lookup_code => 'QUOTA',
1048: x_return_status => l_return_status,
1049: x_meaning => l_fund_meaning);
1050: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN
1051: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
1052: p_lookup_code => 'BUDGET',
1053: x_return_status => l_return_status,
1054: x_meaning => l_fund_meaning);
1055: END IF;

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

1236: l_fund_type;
1237: CLOSE c_fund_rec;
1238:
1239: IF l_fund_type = 'QUOTA' THEN
1240: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
1241: p_lookup_code => 'QUOTA',
1242: x_return_status => l_return_status,
1243: x_meaning => l_fund_meaning);
1244: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN

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

1241: p_lookup_code => 'QUOTA',
1242: x_return_status => l_return_status,
1243: x_meaning => l_fund_meaning);
1244: ELSIF l_fund_type IN ('FIXED', 'FULLY_ACCRUED') THEN
1245: ozf_utility_pvt.get_lookup_meaning (p_lookup_type => 'OZF_FUND_NTF_TYPE',
1246: p_lookup_code => 'BUDGET',
1247: x_return_status => l_return_status,
1248: x_meaning => l_fund_meaning);
1249: END IF;

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

1374: aname => 'APP_SUBJECT',
1375: avalue=> l_string
1376: );
1377: /* mpande added for implementation of BUG#2352621*/
1378: l_lookup_meaning := ozf_utility_pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER','RFRQ');
1379: wf_engine.setitemattrtext (
1380: itemtype=> itemtype,
1381: itemkey=> itemkey,
1382: aname => 'AMS_APPROVAL_OBJECT_MEANING',

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

1499: CLOSE c_get_rule;
1500: EXCEPTION
1501: WHEN OTHERS THEN
1502: IF G_DEBUG THEN
1503: ozf_utility_pvt.debug_message ('ozf_fund_approval_pvt.get_ntf_rule_values() exception.' || SQLERRM);
1504: END IF;
1505: RAISE;
1506: END Get_Ntf_Rule_Values;
1507: ---------------------------------------------------------------------

Line 1702: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','OZF_Fund_Approval_PVT update_parbudget_status l_fund_id : '||l_fund_id);

1698:
1699: ozf_funds_pvt.init_fund_rec (x_fund_rec => l_fund_rec);
1700:
1701: --Bug 14725235
1702: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','OZF_Fund_Approval_PVT update_parbudget_status l_fund_id : '||l_fund_id);
1703: l_org_id := find_org_id (l_fund_id);
1704: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','OZF_Fund_Approval_PVT update_parbudget_status l_org_id : '||l_org_id);
1705: IF l_org_id IS NOT NULL THEN
1706: set_org_ctx (l_org_id);

Line 1704: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','OZF_Fund_Approval_PVT update_parbudget_status l_org_id : '||l_org_id);

1700:
1701: --Bug 14725235
1702: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','OZF_Fund_Approval_PVT update_parbudget_status l_fund_id : '||l_fund_id);
1703: l_org_id := find_org_id (l_fund_id);
1704: OZF_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF','OZF_Fund_Approval_PVT update_parbudget_status l_org_id : '||l_org_id);
1705: IF l_org_id IS NOT NULL THEN
1706: set_org_ctx (l_org_id);
1707: END IF;
1708: OZF_DEBUG_PVT.DEBUG_MO('OZF_Fund_Approval_PVT update_parbudget_status after setting context : fund_id '||l_fund_id);

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

1764: aname => 'AMS_AMOUNT',
1765: avalue=> l_fund_rec.original_budget
1766: );
1767: IF G_DEBUG THEN
1768: ozf_utility_pvt.debug_message ( l_full_name || l_update_status);
1769: END IF;
1770: -- mpande 6/11/2002 bug#2352621
1771: ELSIF l_update_status = 'REJECTED' THEN
1772: l_next_status_id :=

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

1778: -- mpande 6/11/2002 bug#2352621
1779: -- Status is 'ERROR' during error in wf so the status of the fund should change back to 'DRAFT'
1780: ELSE
1781: --l_next_status_id :=
1782: -- ozf_utility_pvt.get_default_user_status ( 'OZF_FUND_STATUS' ,'DRAFT');
1783: -- 06/28/2002 yzhao: no valiation for update so status always revert to 'DRAFT' when error occurs
1784: l_next_status_id := wf_engine.GetItemAttrNumber(
1785: itemtype => itemtype,
1786: itemkey => itemkey,

Line 1792: ozf_utility_pvt.get_system_status_code (l_next_status_id);

1788: l_validation_level := fnd_api.g_valid_level_none;
1789: END IF;
1790: -- x_return_status := fnd_api.g_ret_sts_success;
1791: l_status_code :=
1792: ozf_utility_pvt.get_system_status_code (l_next_status_id);
1793: l_fund_rec.fund_id := l_fund_id;
1794: l_fund_rec.user_status_id := l_next_status_id;
1795: l_fund_rec.status_code := l_status_code;
1796: l_fund_rec.object_version_number := l_object_version_number

Line 1799: ozf_utility_pvt.debug_message (

1795: l_fund_rec.status_code := l_status_code;
1796: l_fund_rec.object_version_number := l_object_version_number
1797: + 1;
1798: IF G_DEBUG THEN
1799: ozf_utility_pvt.debug_message (
1800: l_full_name
1801: || l_status_code || ' '
1802: || l_approved_amount || ' '
1803: || l_update_status

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

1814: p_mode=> g_fund_mode
1815: );
1816: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1817: IF G_DEBUG THEN
1818: ozf_utility_pvt.debug_message(l_full_name || ' failed to update fund to status ' || l_status_code);
1819: END IF;
1820: ams_gen_approval_pvt.handle_err (
1821: p_itemtype=> itemtype,
1822: p_itemkey=> itemkey,

Line 1853: ozf_utility_pvt.debug_message (

1849: p_count=> l_msg_count,
1850: p_data=> l_msg_data
1851: );
1852: IF G_DEBUG THEN
1853: ozf_utility_pvt.debug_message (
1854: l_full_name
1855: || ': l_return_status'
1856: || l_return_status
1857: );

Line 1920: ozf_utility_pvt.get_system_status_code (2100);

1916: aname => 'AMS_ACTIVITY_ID'
1917: );
1918: -- x_return_status := fnd_api.g_ret_sts_success;
1919: l_status_code :=
1920: ozf_utility_pvt.get_system_status_code (2100);
1921: ozf_funds_pvt.init_fund_rec (x_fund_rec => l_fund_rec);
1922: l_fund_rec.fund_id := l_fund_id;
1923: l_fund_rec.user_status_id := 2100;
1924: l_fund_rec.status_code := l_status_code;

Line 1928: ozf_utility_pvt.debug_message (

1924: l_fund_rec.status_code := l_status_code;
1925: l_fund_rec.object_version_number := l_object_version_number
1926: + 1;
1927: IF G_DEBUG THEN
1928: ozf_utility_pvt.debug_message (
1929: l_full_name
1930: || l_status_code
1931: || l_approved_amount
1932: || l_update_status

Line 1974: ozf_utility_pvt.debug_message (

1970: p_count=> l_msg_count,
1971: p_data=> l_msg_data
1972: );
1973: IF G_DEBUG THEN
1974: ozf_utility_pvt.debug_message (
1975: l_full_name
1976: || ': l_return_status'
1977: || l_return_status
1978: );