1: PACKAGE BODY okl_trx_ar_adjsts_pub AS
2: /* $Header: OKLPADJB.pls 120.3 2006/07/07 09:53:19 adagur noship $ */
3:
4: PROCEDURE insert_trx_ar_adjsts(
5: p_api_version IN NUMBER
87: ROLLBACK TO trx_ar_adjsts_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_TRX_AR_ADJSTS_PUB','insert_trx_ar_adjsts');
92: FND_MSG_PUB.count_and_get(
93: p_count => x_msg_count
94: ,p_data => x_msg_data);
95: END insert_trx_ar_adjsts;
180: ROLLBACK TO trx_ar_adjsts_insert;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: x_msg_count := l_msg_count ;
183: x_msg_data := l_msg_data ;
184: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_AR_ADJSTS_PUB','insert_trx_ar_adjsts');
185: FND_MSG_PUB.count_and_get(
186: p_count => x_msg_count
187: ,p_data => x_msg_data);
188: END insert_trx_ar_adjsts;
222: p_count => x_msg_count
223: ,p_data => x_msg_data);
224: WHEN OTHERS THEN
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_AR_ADJSTS_PUB','lock_trx_ar_adjsts');
227: FND_MSG_PUB.count_and_get(
228: p_count => x_msg_count
229: ,p_data => x_msg_data);
230: END lock_trx_ar_adjsts;
264: p_count => x_msg_count
265: ,p_data => x_msg_data);
266: WHEN OTHERS THEN
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_AR_ADJSTS_PUB','lock_trx_ar_adjsts');
269: FND_MSG_PUB.count_and_get(
270: p_count => x_msg_count
271: ,p_data => x_msg_data);
272: END lock_trx_ar_adjsts;
355: ROLLBACK TO trx_ar_adjsts_update;
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: x_msg_count := l_msg_count ;
358: x_msg_data := l_msg_data ;
359: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_AR_ADJSTS_PUB','update_trx_ar_adjsts');
360: FND_MSG_PUB.count_and_get(
361: p_count => x_msg_count
362: ,p_data => x_msg_data);
363: END update_trx_ar_adjsts;
444: ROLLBACK TO trx_ar_adjsts_update;
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
446: x_msg_count := l_msg_count ;
447: x_msg_data := l_msg_data ;
448: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_AR_ADJSTS_PUB','update_trx_ar_adjsts');
449: FND_MSG_PUB.count_and_get(
450: p_count => x_msg_count
451: ,p_data => x_msg_data);
452: END update_trx_ar_adjsts;
530: ROLLBACK TO trx_ar_adjsts_delete_rec;
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: x_msg_count := l_msg_count ;
533: x_msg_data := l_msg_data ;
534: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_AR_ADJSTS_PUB','delete_trx_ar_adjsts');
535: FND_MSG_PUB.count_and_get(
536: p_count => x_msg_count
537: ,p_data => x_msg_data);
538: END delete_trx_ar_adjsts;
627: ROLLBACK TO trx_ar_adjsts_delete_tbl;
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: x_msg_count := l_msg_count ;
630: x_msg_data := l_msg_data ;
631: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_AR_ADJSTS_PUB','delete_trx_ar_adjsts');
632: FND_MSG_PUB.count_and_get(
633: p_count => x_msg_count
634: ,p_data => x_msg_data);
635: END delete_trx_ar_adjsts;
717: ROLLBACK TO trx_ar_adjsts_validate;
718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
719: x_msg_count := l_msg_count ;
720: x_msg_data := l_msg_data ;
721: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_AR_ADJSTS_PUB','validate_trx_ar_adjsts');
722: FND_MSG_PUB.count_and_get(
723: p_count => x_msg_count
724: ,p_data => x_msg_data);
725: END validate_trx_ar_adjsts;
802: ROLLBACK TO trx_ar_adjsts_validate;
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
804: x_msg_count := l_msg_count ;
805: x_msg_data := l_msg_data ;
806: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_AR_ADJSTS_PUB','validate_trx_ar_adjsts');
807: FND_MSG_PUB.count_and_get(
808: p_count => x_msg_count
809: ,p_data => x_msg_data);
810: END validate_trx_ar_adjsts;
808: p_count => x_msg_count
809: ,p_data => x_msg_data);
810: END validate_trx_ar_adjsts;
811:
812: END OKL_TRX_AR_ADJSTS_PUB;