APPS.OKE_POOLS_PARTIES_PUB dependencies on OKE_POOLS_PARTIES_PUB

Line 1: PACKAGE BODY OKE_POOLS_PARTIES_PUB AS

1: PACKAGE BODY OKE_POOLS_PARTIES_PUB AS
2: /* $Header: OKEPPPPB.pls 120.1 2005/05/27 15:58:52 appldev $ */
3: g_api_type CONSTANT VARCHAR2(4) := '_PUB';
4: g_module CONSTANT VARCHAR2(250) := 'oke.plsql.oke_pools_parties_pub.';
5:

Line 4: g_module CONSTANT VARCHAR2(250) := 'oke.plsql.oke_pools_parties_pub.';

1: PACKAGE BODY OKE_POOLS_PARTIES_PUB AS
2: /* $Header: OKEPPPPB.pls 120.1 2005/05/27 15:58:52 appldev $ */
3: g_api_type CONSTANT VARCHAR2(4) := '_PUB';
4: g_module CONSTANT VARCHAR2(250) := 'oke.plsql.oke_pools_parties_pub.';
5:
6:
7:
8: PROCEDURE create_pool(

Line 26: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call oke_pools_parties_pub.create_pool');

22: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
23: l_line_number VARCHAR2(120);
24:
25: BEGIN
26: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call oke_pools_parties_pub.create_pool');
27: -- call START_ACTIVITY to create savepoint, check compatibility
28: -- and initialize message list
29: l_return_status := OKE_API.START_ACTIVITY(
30: p_api_name => l_api_name,

Line 65: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'end call oke_pools_parties_pub.create_pool');

61: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
62: raise OKE_API.G_EXCEPTION_ERROR;
63: End If;
64:
65: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'end call oke_pools_parties_pub.create_pool');
66:
67: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
68: x_msg_data => x_msg_data);
69: EXCEPTION

Line 117: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call oke_pools_parties_pub.create_pool');

113: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
114: i NUMBER;
115: l_pool_tbl oke_pool_pvt.pool_tbl_type;
116: BEGIN
117: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call oke_pools_parties_pub.create_pool');
118: -- call START_ACTIVITY to create savepoint, check compatibility
119: -- and initialize message list
120: l_return_status := OKE_API.START_ACTIVITY(
121: p_api_name => l_api_name,

Line 152: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'end call oke_pools_parties_pub.create_pool');

148: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
149: raise OKE_API.G_EXCEPTION_ERROR;
150: End If;
151:
152: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'end call oke_pools_parties_pub.create_pool');
153: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
154: x_msg_data => x_msg_data);
155: EXCEPTION
156: when OKE_API.G_EXCEPTION_ERROR then

Line 200: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call oke_pools_parties_pub.update_pool');

196: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
197: BEGIN
198: -- call START_ACTIVITY to create savepoint, check compatibility
199: -- and initialize message list
200: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call oke_pools_parties_pub.update_pool');
201:
202: l_return_status := OKE_API.START_ACTIVITY(
203: p_api_name => l_api_name,
204: p_pkg_name => g_pkg_name,

Line 239: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'end call oke_pools_parties_pub.update_pool');

235: End If;
236:
237: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
238: x_msg_data => x_msg_data);
239: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'end call oke_pools_parties_pub.update_pool');
240:
241: EXCEPTION
242: when OKE_API.G_EXCEPTION_ERROR then
243: x_return_status := OKE_API.HANDLE_EXCEPTIONS(

Line 390: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call oke_pools_parties_pub.delete_pool');

386: where funding_pool_id=p_funding_pool_id;
387:
388:
389: BEGIN
390: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call oke_pools_parties_pub.delete_pool');
391: -- call START_ACTIVITY to create savepoint, check compatibility
392: -- and initialize message list
393: l_return_status := OKE_API.START_ACTIVITY(
394: p_api_name => l_api_name,

Line 465: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'end call oke_pools_parties_pub.delete_pool');

461: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
462: raise OKE_API.G_EXCEPTION_ERROR;
463: End If;
464:
465: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'end call oke_pools_parties_pub.delete_pool');
466: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
467: x_msg_data => x_msg_data);
468: EXCEPTION
469: when OKE_API.G_EXCEPTION_ERROR then

Line 1344: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call oke_pools_parties_pub.delete_party');

1340: from oke_pool_parties
1341: where pool_party_id=p_pool_party_id;
1342:
1343: BEGIN
1344: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call oke_pools_parties_pub.delete_party');
1345: -- call START_ACTIVITY to create savepoint, check compatibility
1346: -- and initialize message list
1347: l_return_status := OKE_API.START_ACTIVITY(
1348: p_api_name => l_api_name,

Line 1422: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'end call oke_pools_parties_pub.delete_party');

1418: Elsif x_return_status = OKE_API.G_RET_STS_ERROR Then
1419: raise OKE_API.G_EXCEPTION_ERROR;
1420: End If;
1421:
1422: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'end call oke_pools_parties_pub.delete_party');
1423: OKE_API.END_ACTIVITY( x_msg_count => x_msg_count,
1424: x_msg_data => x_msg_data);
1425: EXCEPTION
1426: when OKE_API.G_EXCEPTION_ERROR then

Line 1731: END OKE_POOLS_PARTIES_PUB;

1727: END lock_party;
1728:
1729:
1730:
1731: END OKE_POOLS_PARTIES_PUB;
1732: