1: PACKAGE BODY OKL_TAX_SOURCES_PUB AS
2: /* $Header: OKLPTXSB.pls 120.0 2005/08/26 19:51:24 sechawla noship $ */
3:
4: PROCEDURE insert_tax_sources(
5: p_api_version IN NUMBER,
87: ROLLBACK TO txs_insert;
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89: x_msg_count := l_msg_count ;
90: x_msg_data := l_msg_data ;
91: FND_MSG_PUB.ADD_EXC_MSG('OKL_TAX_SOURCES_PUB','insert_tax_sources');
92: FND_MSG_PUB.count_and_get(
93: p_count => x_msg_count
94: ,p_data => x_msg_data);
95: END insert_tax_sources;
175: ROLLBACK TO txs_insert;
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
177: x_msg_count := l_msg_count ;
178: x_msg_data := l_msg_data ;
179: FND_MSG_PUB.ADD_EXC_MSG('OKL_TAX_SOURCES_PUB','insert_tax_sources');
180: FND_MSG_PUB.count_and_get(
181: p_count => x_msg_count
182: ,p_data => x_msg_data);
183: END insert_tax_sources;
217: p_count => x_msg_count
218: ,p_data => x_msg_data);
219: WHEN OTHERS THEN
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
221: FND_MSG_PUB.ADD_EXC_MSG('OKL_TAX_SOURCES_PUB','lock_tax_sources');
222: FND_MSG_PUB.count_and_get(
223: p_count => x_msg_count
224: ,p_data => x_msg_data);
225: END lock_tax_sources;
260: p_count => x_msg_count
261: ,p_data => x_msg_data);
262: WHEN OTHERS THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: FND_MSG_PUB.ADD_EXC_MSG('OKL_TAX_SOURCES_PUB','lock_tax_sources');
265: FND_MSG_PUB.count_and_get(
266: p_count => x_msg_count
267: ,p_data => x_msg_data);
268: END lock_tax_sources;
352: ROLLBACK TO txs_update;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: x_msg_count := l_msg_count ;
355: x_msg_data := l_msg_data ;
356: FND_MSG_PUB.ADD_EXC_MSG('OKL_TAX_SOURCES_PUB','update_tax_sources');
357: FND_MSG_PUB.count_and_get(
358: p_count => x_msg_count
359: ,p_data => x_msg_data);
360: END update_tax_sources;
441: ROLLBACK TO txs_update;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: x_msg_count := l_msg_count ;
444: x_msg_data := l_msg_data ;
445: FND_MSG_PUB.ADD_EXC_MSG('OKL_TAX_SOURCES_PUB','update_tax_sources');
446: FND_MSG_PUB.count_and_get(
447: p_count => x_msg_count
448: ,p_data => x_msg_data);
449: END update_tax_sources;
527: ROLLBACK TO txs_delete;
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: x_msg_count := l_msg_count ;
530: x_msg_data := l_msg_data ;
531: FND_MSG_PUB.ADD_EXC_MSG('OKL_TAX_SOURCES_PUB','delete_tax_sources');
532: FND_MSG_PUB.count_and_get(
533: p_count => x_msg_count
534: ,p_data => x_msg_data);
535: END delete_tax_sources;
612: ROLLBACK TO txsdelete;
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
614: x_msg_count := l_msg_count ;
615: x_msg_data := l_msg_data ;
616: FND_MSG_PUB.ADD_EXC_MSG('OKL_TAX_SOURCES_PUB','delete_tax_sources');
617: FND_MSG_PUB.count_and_get(
618: p_count => x_msg_count
619: ,p_data => x_msg_data);
620: END delete_tax_sources;
704: ROLLBACK TO txs_validate;
705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
706: x_msg_count := l_msg_count ;
707: x_msg_data := l_msg_data ;
708: FND_MSG_PUB.ADD_EXC_MSG('OKL_TAX_SOURCES_PUB','validate_tax_sources');
709: FND_MSG_PUB.count_and_get(
710: p_count => x_msg_count
711: ,p_data => x_msg_data);
712: END validate_tax_sources;
790: ROLLBACK TO txs_validate;
791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
792: x_msg_count := l_msg_count ;
793: x_msg_data := l_msg_data ;
794: FND_MSG_PUB.ADD_EXC_MSG('OKL_TAX_SOURCES_PUB','validate_tax_sources');
795: FND_MSG_PUB.count_and_get(
796: p_count => x_msg_count
797: ,p_data => x_msg_data);
798: END validate_tax_sources;
796: p_count => x_msg_count
797: ,p_data => x_msg_data);
798: END validate_tax_sources;
799:
800: END OKL_TAX_SOURCES_PUB;