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.OKE_PARTY_PVT dependencies on OKE_PARTY_PVT

Line 1: PACKAGE BODY OKE_PARTY_PVT AS

1: PACKAGE BODY OKE_PARTY_PVT AS
2: /* $Header: OKEVFPPB.pls 115.12 2003/10/07 00:48:44 alaw ship $ */
3:
4:
5: PROCEDURE validate_currency_code(x_return_status OUT NOCOPY VARCHAR2,

Line 1009: --oke_debug.debug('start call oke_party_pvt.insert_row');

1005: END Set_Attributes;
1006:
1007:
1008: BEGIN -- insert
1009: --oke_debug.debug('start call oke_party_pvt.insert_row');
1010:
1011: l_return_status := OKE_API.START_ACTIVITY(l_api_name,
1012: G_PKG_NAME,
1013: p_init_msg_list,

Line 1156: --oke_debug.debug('end call oke_party_pvt.insert_row');

1152: --oke_debug.debug('record inserted');
1153: -- Set OUT values
1154: x_party_rec := l_def_party_rec;
1155: x_party_rec.POOL_PARTY_ID:=l_seq;
1156: --oke_debug.debug('end call oke_party_pvt.insert_row');
1157: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
1158:
1159: EXCEPTION
1160: WHEN OKE_API.G_EXCEPTION_ERROR THEN

Line 1212: --oke_debug.debug('start call oke_party_pvt.insert_row');

1208: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1209: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1210: i NUMBER := 0;
1211: BEGIN
1212: --oke_debug.debug('start call oke_party_pvt.insert_row');
1213:
1214: l_return_status := OKE_API.START_ACTIVITY(l_api_name,
1215: G_PKG_NAME,
1216: p_init_msg_list,

Line 1250: --oke_debug.debug('end call oke_party_pvt.insert_row');

1246: END LOOP;
1247: -- return overall status
1248: x_return_status := l_overall_status;
1249: END IF;
1250: --oke_debug.debug('end call oke_party_pvt.insert_row');
1251: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
1252:
1253: EXCEPTION
1254: WHEN OKE_API.G_EXCEPTION_ERROR THEN

Line 1544: --oke_debug.debug('start call oke_party_pvt.update_row');

1540:
1541:
1542: BEGIN -- update row
1543:
1544: --oke_debug.debug('start call oke_party_pvt.update_row');
1545:
1546: l_return_status := OKE_API.START_ACTIVITY(l_api_name,
1547: G_PKG_NAME,
1548: p_init_msg_list,

Line 1807: --oke_debug.debug('end call oke_party_pvt.update_row');

1803: l_def_party_rec.ATTRIBUTE14,
1804: l_def_party_rec.ATTRIBUTE15);
1805:
1806: x_party_rec := l_def_party_rec;
1807: --oke_debug.debug('end call oke_party_pvt.update_row');
1808: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
1809:
1810: EXCEPTION
1811: WHEN OKE_API.G_EXCEPTION_ERROR THEN

Line 1863: --oke_debug.debug('start call oke_party_pvt.update_row');

1859: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1860: i NUMBER := 0;
1861: BEGIN
1862:
1863: --oke_debug.debug('start call oke_party_pvt.update_row');
1864:
1865: l_return_status := OKE_API.START_ACTIVITY(l_api_name,
1866: G_PKG_NAME,
1867: p_init_msg_list,

Line 1907: --oke_debug.debug('end call oke_party_pvt.update_row');

1903: END LOOP;
1904: -- return overall status
1905: x_return_status := l_overall_status;
1906: END IF;
1907: --oke_debug.debug('end call oke_party_pvt.update_row');
1908: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
1909:
1910: EXCEPTION
1911: WHEN OKE_API.G_EXCEPTION_ERROR THEN

Line 1967: --oke_debug.debug('start call oke_party_pvt.delete_row');

1963: from oke_pool_parties
1964: where pool_party_id=p_party_rec.pool_party_id;
1965:
1966: BEGIN
1967: --oke_debug.debug('start call oke_party_pvt.delete_row');
1968:
1969: l_return_status := OKE_API.START_ACTIVITY(l_api_name,
1970: G_PKG_NAME,
1971: p_init_msg_list,

Line 2010: --oke_debug.debug('end call oke_party_pvt.delete_row');

2006:
2007: DELETE FROM OKE_POOL_PARTIES
2008: WHERE POOL_PARTY_ID = p_party_rec.POOL_PARTY_ID;
2009:
2010: --oke_debug.debug('end call oke_party_pvt.delete_row');
2011: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
2012:
2013:
2014: EXCEPTION

Line 2064: --oke_debug.debug('start call oke_party_pvt.delete_row');

2060: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
2061: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
2062: i NUMBER := 0;
2063: BEGIN
2064: --oke_debug.debug('start call oke_party_pvt.delete_row');
2065:
2066: l_return_status := OKE_API.START_ACTIVITY(l_api_name,
2067: G_PKG_NAME,
2068: p_init_msg_list,

Line 2107: --oke_debug.debug('end call oke_party_pvt.delete_row');

2103:
2104: -- return overall status
2105: x_return_status := l_overall_status;
2106: END IF;
2107: --oke_debug.debug('end call oke_party_pvt.delete_row');
2108: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
2109:
2110:
2111: EXCEPTION

Line 2174: --oke_debug.debug('start call oke_party_pvt.lock_row');

2170:
2171:
2172: BEGIN
2173:
2174: --oke_debug.debug('start call oke_party_pvt.lock_row');
2175:
2176: l_return_status := OKE_API.START_ACTIVITY(l_api_name,
2177: G_PKG_NAME,
2178: p_init_msg_list,

Line 2214: --oke_debug.debug('end call oke_party_pvt.lock_row');

2210: OKE_API.set_message(G_APP_NAME,G_FORM_RECORD_DELETED);
2211: RAISE OKE_API.G_EXCEPTION_ERROR;
2212: END IF;
2213:
2214: --oke_debug.debug('end call oke_party_pvt.lock_row');
2215: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
2216:
2217: EXCEPTION
2218: WHEN OKE_API.G_EXCEPTION_ERROR THEN

Line 2251: END OKE_PARTY_PVT;

2247: );
2248: END lock_row;
2249:
2250:
2251: END OKE_PARTY_PVT;
2252: