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.2 2010/04/09 05:30:55 aveeraba ship $ */
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.2 2010/04/09 05:30:55 aveeraba ship $ */
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 27: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call oke_pools_parties_pub.create_pool');

23: --bug 9354391 modified line_number length to 150 as per table
24: l_line_number VARCHAR2(150);
25:
26: BEGIN
27: --FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call oke_pools_parties_pub.create_pool');
28: -- call START_ACTIVITY to create savepoint, check compatibility
29: -- and initialize message list
30: l_return_status := OKE_API.START_ACTIVITY(
31: p_api_name => l_api_name,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1733: END OKE_POOLS_PARTIES_PUB;

1729: END lock_party;
1730:
1731:
1732:
1733: END OKE_POOLS_PARTIES_PUB;
1734: