DBA Data[Home] [Help]

APPS.OKL_TRX_QUOTES_PUB dependencies on OKL_TRX_QUOTES_PUB

Line 1: PACKAGE BODY okl_trx_quotes_pub AS

1: PACKAGE BODY okl_trx_quotes_pub AS
2: /* $Header: OKLPQTEB.pls 120.3 2007/12/17 11:23:59 ansethur ship $ */
3:
4: -- GLOBAL VARIABLES
5: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 8: G_MODULE_NAME CONSTANT VARCHAR2(500) := 'okl.am.plsql.okl_trx_quotes_pub.';

4: -- GLOBAL VARIABLES
5: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
6: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_MODULE_NAME CONSTANT VARCHAR2(500) := 'okl.am.plsql.okl_trx_quotes_pub.';
9:
10: PROCEDURE insert_trx_quotes(
11: p_api_version IN NUMBER
12: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 126: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','insert_trx_quotes');

122: ROLLBACK TO trx_quotes_insert;
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124: x_msg_count := l_msg_count ;
125: x_msg_data := l_msg_data ;
126: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','insert_trx_quotes');
127: FND_MSG_PUB.count_and_get(
128: p_count => x_msg_count
129: ,p_data => x_msg_data);
130: END insert_trx_quotes;

Line 244: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','insert_trx_quotes');

240: ROLLBACK TO trx_quotes_insert;
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: x_msg_count := l_msg_count ;
243: x_msg_data := l_msg_data ;
244: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','insert_trx_quotes');
245: FND_MSG_PUB.count_and_get(
246: p_count => x_msg_count
247: ,p_data => x_msg_data);
248: END insert_trx_quotes;

Line 315: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','lock_trx_quotes');

311: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
312: || sqlcode || ' , SQLERRM : ' || sqlerrm);
313: END IF;
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','lock_trx_quotes');
316: FND_MSG_PUB.count_and_get(
317: p_count => x_msg_count
318: ,p_data => x_msg_data);
319: END lock_trx_quotes;

Line 392: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','lock_trx_quotes');

388: || sqlcode || ' , SQLERRM : ' || sqlerrm);
389: END IF;
390:
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','lock_trx_quotes');
393: FND_MSG_PUB.count_and_get(
394: p_count => x_msg_count
395: ,p_data => x_msg_data);
396: END lock_trx_quotes;

Line 518: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','update_trx_quotes');

514: ROLLBACK TO trx_quotes_update;
515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
516: x_msg_count := l_msg_count ;
517: x_msg_data := l_msg_data ;
518: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','update_trx_quotes');
519: FND_MSG_PUB.count_and_get(
520: p_count => x_msg_count
521: ,p_data => x_msg_data);
522: END update_trx_quotes;

Line 645: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','update_trx_quotes');

641: ROLLBACK TO trx_quotes_update;
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: x_msg_count := l_msg_count ;
644: x_msg_data := l_msg_data ;
645: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','update_trx_quotes');
646: FND_MSG_PUB.count_and_get(
647: p_count => x_msg_count
648: ,p_data => x_msg_data);
649: END update_trx_quotes;

Line 766: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','delete_trx_quotes');

762: ROLLBACK TO trx_quotes_delete_rec;
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: x_msg_count := l_msg_count ;
765: x_msg_data := l_msg_data ;
766: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','delete_trx_quotes');
767: FND_MSG_PUB.count_and_get(
768: p_count => x_msg_count
769: ,p_data => x_msg_data);
770: END delete_trx_quotes;

Line 897: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','delete_trx_quotes');

893: ROLLBACK TO trx_quotes_delete_tbl;
894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
895: x_msg_count := l_msg_count ;
896: x_msg_data := l_msg_data ;
897: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','delete_trx_quotes');
898: FND_MSG_PUB.count_and_get(
899: p_count => x_msg_count
900: ,p_data => x_msg_data);
901: END delete_trx_quotes;

Line 1016: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','validate_trx_quotes');

1012: ROLLBACK TO trx_quotes_validate;
1013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1014: x_msg_count := l_msg_count ;
1015: x_msg_data := l_msg_data ;
1016: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','validate_trx_quotes');
1017: FND_MSG_PUB.count_and_get(
1018: p_count => x_msg_count
1019: ,p_data => x_msg_data);
1020: END validate_trx_quotes;

Line 1133: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','validate_trx_quotes');

1129: ROLLBACK TO trx_quotes_validate;
1130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1131: x_msg_count := l_msg_count ;
1132: x_msg_data := l_msg_data ;
1133: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_QUOTES_PUB','validate_trx_quotes');
1134: FND_MSG_PUB.count_and_get(
1135: p_count => x_msg_count
1136: ,p_data => x_msg_data);
1137: END validate_trx_quotes;

Line 1139: END OKL_TRX_QUOTES_PUB;

1135: p_count => x_msg_count
1136: ,p_data => x_msg_data);
1137: END validate_trx_quotes;
1138:
1139: END OKL_TRX_QUOTES_PUB;