DBA Data[Home] [Help]

APPS.OKL_TRX_MSGS_PUB dependencies on OKL_TRX_MSGS_PUB

Line 1: PACKAGE BODY okl_trx_msgs_pub AS

1: PACKAGE BODY okl_trx_msgs_pub AS
2: /* $Header: OKLPTMGB.pls 115.6 2004/04/13 11:25:08 rnaik noship $ */
3:
4: PROCEDURE insert_trx_msgs(
5: p_api_version IN NUMBER

Line 91: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','insert_trx_msgs');

87: ROLLBACK TO trx_msgs_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_MSGS_PUB','insert_trx_msgs');
92: FND_MSG_PUB.count_and_get(
93: p_count => x_msg_count
94: ,p_data => x_msg_data);
95: END insert_trx_msgs;

Line 179: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','insert_trx_msgs');

175: ROLLBACK TO trx_msgs_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_TRX_MSGS_PUB','insert_trx_msgs');
180: FND_MSG_PUB.count_and_get(
181: p_count => x_msg_count
182: ,p_data => x_msg_data);
183: END insert_trx_msgs;

Line 221: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','lock_trx_msgs');

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_TRX_MSGS_PUB','lock_trx_msgs');
222: FND_MSG_PUB.count_and_get(
223: p_count => x_msg_count
224: ,p_data => x_msg_data);
225: END lock_trx_msgs;

Line 263: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','lock_trx_msgs');

259: p_count => x_msg_count
260: ,p_data => x_msg_data);
261: WHEN OTHERS THEN
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
263: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','lock_trx_msgs');
264: FND_MSG_PUB.count_and_get(
265: p_count => x_msg_count
266: ,p_data => x_msg_data);
267: END lock_trx_msgs;

Line 354: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','update_trx_msgs');

350: ROLLBACK TO trx_msgs_update;
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: x_msg_count := l_msg_count ;
353: x_msg_data := l_msg_data ;
354: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','update_trx_msgs');
355: FND_MSG_PUB.count_and_get(
356: p_count => x_msg_count
357: ,p_data => x_msg_data);
358: END update_trx_msgs;

Line 443: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','update_trx_msgs');

439: ROLLBACK TO trx_msgs_update;
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: x_msg_count := l_msg_count ;
442: x_msg_data := l_msg_data ;
443: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','update_trx_msgs');
444: FND_MSG_PUB.count_and_get(
445: p_count => x_msg_count
446: ,p_data => x_msg_data);
447: END update_trx_msgs;

Line 529: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','delete_trx_msgs');

525: ROLLBACK TO trx_msgs_delete_rec;
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527: x_msg_count := l_msg_count ;
528: x_msg_data := l_msg_data ;
529: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','delete_trx_msgs');
530: FND_MSG_PUB.count_and_get(
531: p_count => x_msg_count
532: ,p_data => x_msg_data);
533: END delete_trx_msgs;

Line 626: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','delete_trx_msgs');

622: ROLLBACK TO trx_msgs_delete_tbl;
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: x_msg_count := l_msg_count ;
625: x_msg_data := l_msg_data ;
626: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','delete_trx_msgs');
627: FND_MSG_PUB.count_and_get(
628: p_count => x_msg_count
629: ,p_data => x_msg_data);
630: END delete_trx_msgs;

Line 716: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','validate_trx_msgs');

712: ROLLBACK TO trx_msgs_validate;
713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
714: x_msg_count := l_msg_count ;
715: x_msg_data := l_msg_data ;
716: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','validate_trx_msgs');
717: FND_MSG_PUB.count_and_get(
718: p_count => x_msg_count
719: ,p_data => x_msg_data);
720: END validate_trx_msgs;

Line 801: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','validate_trx_msgs');

797: ROLLBACK TO trx_msgs_validate;
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
799: x_msg_count := l_msg_count ;
800: x_msg_data := l_msg_data ;
801: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_MSGS_PUB','validate_trx_msgs');
802: FND_MSG_PUB.count_and_get(
803: p_count => x_msg_count
804: ,p_data => x_msg_data);
805: END validate_trx_msgs;

Line 807: END OKL_TRX_MSGS_PUB;

803: p_count => x_msg_count
804: ,p_data => x_msg_data);
805: END validate_trx_msgs;
806:
807: END OKL_TRX_MSGS_PUB;