60: ROLLBACK TO trx_create_pool;
61: x_return_status := OKL_API.G_RET_STS_ERROR;
62: x_msg_count := l_msg_count ;
63: x_msg_data := l_msg_data ;
64: FND_MSG_PUB.count_and_get(
65: p_count => x_msg_count
66: ,p_data => x_msg_data);
67: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
68: ROLLBACK TO trx_create_pool;
68: ROLLBACK TO trx_create_pool;
69: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
70: x_msg_count := l_msg_count ;
71: x_msg_data := l_msg_data ;
72: FND_MSG_PUB.count_and_get(
73: p_count => x_msg_count
74: ,p_data => x_msg_data);
75: WHEN OTHERS THEN
76: ROLLBACK TO trx_create_pool;
76: ROLLBACK TO trx_create_pool;
77: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
78: x_msg_count := l_msg_count ;
79: x_msg_data := l_msg_data ;
80: FND_MSG_PUB.ADD_EXC_MSG('OKL_POOL_PUB','create_pool');
81: FND_MSG_PUB.count_and_get(
82: p_count => x_msg_count
83: ,p_data => x_msg_data);
84:
77: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
78: x_msg_count := l_msg_count ;
79: x_msg_data := l_msg_data ;
80: FND_MSG_PUB.ADD_EXC_MSG('OKL_POOL_PUB','create_pool');
81: FND_MSG_PUB.count_and_get(
82: p_count => x_msg_count
83: ,p_data => x_msg_data);
84:
85:
165: ROLLBACK TO trx_update_pool;
166: x_return_status := OKL_API.G_RET_STS_ERROR;
167: x_msg_count := l_msg_count ;
168: x_msg_data := l_msg_data ;
169: FND_MSG_PUB.count_and_get(
170: p_count => x_msg_count
171: ,p_data => x_msg_data);
172: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
173: ROLLBACK TO trx_update_pool;
173: ROLLBACK TO trx_update_pool;
174: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
175: x_msg_count := l_msg_count ;
176: x_msg_data := l_msg_data ;
177: FND_MSG_PUB.count_and_get(
178: p_count => x_msg_count
179: ,p_data => x_msg_data);
180: WHEN OTHERS THEN
181: ROLLBACK TO trx_update_pool;
181: ROLLBACK TO trx_update_pool;
182: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
183: x_msg_count := l_msg_count ;
184: x_msg_data := l_msg_data ;
185: FND_MSG_PUB.ADD_EXC_MSG('OKL_POOL_PUB','update_pool');
186: FND_MSG_PUB.count_and_get(
187: p_count => x_msg_count
188: ,p_data => x_msg_data);
189:
182: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
183: x_msg_count := l_msg_count ;
184: x_msg_data := l_msg_data ;
185: FND_MSG_PUB.ADD_EXC_MSG('OKL_POOL_PUB','update_pool');
186: FND_MSG_PUB.count_and_get(
187: p_count => x_msg_count
188: ,p_data => x_msg_data);
189:
190: END update_pool;
311: ROLLBACK TO trx_cleanup_pool_contents;
312: x_return_status := OKL_API.G_RET_STS_ERROR;
313: x_msg_count := l_msg_count ;
314: x_msg_data := l_msg_data ;
315: FND_MSG_PUB.count_and_get(
316: p_count => x_msg_count
317: ,p_data => x_msg_data);
318: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
319: ROLLBACK TO trx_cleanup_pool_contents;
319: ROLLBACK TO trx_cleanup_pool_contents;
320: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
321: x_msg_count := l_msg_count ;
322: x_msg_data := l_msg_data ;
323: FND_MSG_PUB.count_and_get(
324: p_count => x_msg_count
325: ,p_data => x_msg_data);
326: WHEN OTHERS THEN
327: ROLLBACK TO trx_cleanup_pool_contents;
327: ROLLBACK TO trx_cleanup_pool_contents;
328: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
329: x_msg_count := l_msg_count ;
330: x_msg_data := l_msg_data ;
331: FND_MSG_PUB.ADD_EXC_MSG('OKL_POOL_PUB','cleanup_pool_contents');
332: FND_MSG_PUB.count_and_get(
333: p_count => x_msg_count
334: ,p_data => x_msg_data);
335:
328: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
329: x_msg_count := l_msg_count ;
330: x_msg_data := l_msg_data ;
331: FND_MSG_PUB.ADD_EXC_MSG('OKL_POOL_PUB','cleanup_pool_contents');
332: FND_MSG_PUB.count_and_get(
333: p_count => x_msg_count
334: ,p_data => x_msg_data);
335:
336: END cleanup_pool_contents;
465: ROLLBACK TO trx_add_pool_contents;
466: x_return_status := OKL_API.G_RET_STS_ERROR;
467: x_msg_count := l_msg_count ;
468: x_msg_data := l_msg_data ;
469: FND_MSG_PUB.count_and_get(
470: p_count => x_msg_count
471: ,p_data => x_msg_data);
472: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
473: ROLLBACK TO trx_add_pool_contents;
473: ROLLBACK TO trx_add_pool_contents;
474: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
475: x_msg_count := l_msg_count ;
476: x_msg_data := l_msg_data ;
477: FND_MSG_PUB.count_and_get(
478: p_count => x_msg_count
479: ,p_data => x_msg_data);
480: WHEN OTHERS THEN
481: ROLLBACK TO trx_add_pool_contents;
481: ROLLBACK TO trx_add_pool_contents;
482: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
483: x_msg_count := l_msg_count ;
484: x_msg_data := l_msg_data ;
485: FND_MSG_PUB.ADD_EXC_MSG('OKL_POOL_PUB','add_pool_contents');
486: FND_MSG_PUB.count_and_get(
487: p_count => x_msg_count
488: ,p_data => x_msg_data);
489:
482: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
483: x_msg_count := l_msg_count ;
484: x_msg_data := l_msg_data ;
485: FND_MSG_PUB.ADD_EXC_MSG('OKL_POOL_PUB','add_pool_contents');
486: FND_MSG_PUB.count_and_get(
487: p_count => x_msg_count
488: ,p_data => x_msg_data);
489:
490: END add_pool_contents;