[Home] [Help]
1: PACKAGE BODY okl_txl_adjsts_lns_pub AS
2: /* $Header: OKLPAJLB.pls 120.4 2006/07/07 10:24:09 pagarg noship $ */
3:
4: PROCEDURE insert_txl_adjsts_lns(
5: p_api_version IN NUMBER
90: ROLLBACK TO txl_adjsts_lns_insert;
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92: x_msg_count := l_msg_count ;
93: x_msg_data := l_msg_data ;
94: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXL_ADJSTS_LNS_PUB','insert_txl_adjsts_lns');
95: FND_MSG_PUB.count_and_get(
96: p_count => x_msg_count
97: ,p_data => x_msg_data);
98: END insert_txl_adjsts_lns;
183: ROLLBACK TO txl_adjsts_lns_insert;
184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
185: x_msg_count := l_msg_count ;
186: x_msg_data := l_msg_data ;
187: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXL_ADJSTS_LNS_PUB','insert_txl_adjsts_lns');
188: FND_MSG_PUB.count_and_get(
189: p_count => x_msg_count
190: ,p_data => x_msg_data);
191: END insert_txl_adjsts_lns;
225: p_count => x_msg_count
226: ,p_data => x_msg_data);
227: WHEN OTHERS THEN
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXL_ADJSTS_LNS_PUB','lock_txl_adjsts_lns');
230: FND_MSG_PUB.count_and_get(
231: p_count => x_msg_count
232: ,p_data => x_msg_data);
233: END lock_txl_adjsts_lns;
267: p_count => x_msg_count
268: ,p_data => x_msg_data);
269: WHEN OTHERS THEN
270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
271: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXL_ADJSTS_LNS_PUB','lock_txl_adjsts_lns');
272: FND_MSG_PUB.count_and_get(
273: p_count => x_msg_count
274: ,p_data => x_msg_data);
275: END lock_txl_adjsts_lns;
358: ROLLBACK TO txl_adjsts_lns_update;
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
360: x_msg_count := l_msg_count ;
361: x_msg_data := l_msg_data ;
362: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXL_ADJSTS_LNS_PUB','update_txl_adjsts_lns');
363: FND_MSG_PUB.count_and_get(
364: p_count => x_msg_count
365: ,p_data => x_msg_data);
366: END update_txl_adjsts_lns;
447: ROLLBACK TO txl_adjsts_lns_update;
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449: x_msg_count := l_msg_count ;
450: x_msg_data := l_msg_data ;
451: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXL_ADJSTS_LNS_PUB','update_txl_adjsts_lns');
452: FND_MSG_PUB.count_and_get(
453: p_count => x_msg_count
454: ,p_data => x_msg_data);
455: END update_txl_adjsts_lns;
533: ROLLBACK TO txl_adjsts_lns_delete_rec;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: x_msg_count := l_msg_count ;
536: x_msg_data := l_msg_data ;
537: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXL_ADJSTS_LNS_PUB','delete_txl_adjsts_lns');
538: FND_MSG_PUB.count_and_get(
539: p_count => x_msg_count
540: ,p_data => x_msg_data);
541: END delete_txl_adjsts_lns;
630: ROLLBACK TO txl_adjsts_lns_delete_tbl;
631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
632: x_msg_count := l_msg_count ;
633: x_msg_data := l_msg_data ;
634: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXL_ADJSTS_LNS_PUB','delete_txl_adjsts_lns');
635: FND_MSG_PUB.count_and_get(
636: p_count => x_msg_count
637: ,p_data => x_msg_data);
638: END delete_txl_adjsts_lns;
720: ROLLBACK TO txl_adjsts_lns_validate;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722: x_msg_count := l_msg_count ;
723: x_msg_data := l_msg_data ;
724: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXL_ADJSTS_LNS_PUB','validate_txl_adjsts_lns');
725: FND_MSG_PUB.count_and_get(
726: p_count => x_msg_count
727: ,p_data => x_msg_data);
728: END validate_txl_adjsts_lns;
805: ROLLBACK TO txl_adjsts_lns_validate;
806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
807: x_msg_count := l_msg_count ;
808: x_msg_data := l_msg_data ;
809: FND_MSG_PUB.ADD_EXC_MSG('OKL_TXL_ADJSTS_LNS_PUB','validate_txl_adjsts_lns');
810: FND_MSG_PUB.count_and_get(
811: p_count => x_msg_count
812: ,p_data => x_msg_data);
813: END validate_txl_adjsts_lns;
811: p_count => x_msg_count
812: ,p_data => x_msg_data);
813: END validate_txl_adjsts_lns;
814:
815: END OKL_TXL_ADJSTS_LNS_PUB;