[Home] [Help]
1: PACKAGE BODY OKL_INVOICE_MSSGS_PUB AS
2: /* $Header: OKLPIMSB.pls 120.4 2008/02/04 13:16:48 nikshah noship $ */
3:
4: PROCEDURE insert_invoice_mssgs(
5: p_api_version IN NUMBER
104: ROLLBACK TO invoice_mssgs_insert;
105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
106: x_msg_count := l_msg_count ;
107: x_msg_data := l_msg_data ;
108: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_MSSGS_PUB','insert_invoice_mssgs');
109: FND_MSG_PUB.count_and_get(
110: p_count => x_msg_count
111: ,p_data => x_msg_data);
112: END insert_invoice_mssgs;
213: ROLLBACK TO invoice_mssgs_insert;
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
215: x_msg_count := l_msg_count ;
216: x_msg_data := l_msg_data ;
217: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_MSSGS_PUB','insert_invoice_mssgs');
218: FND_MSG_PUB.count_and_get(
219: p_count => x_msg_count
220: ,p_data => x_msg_data);
221: END insert_invoice_mssgs;
255: p_count => x_msg_count
256: ,p_data => x_msg_data);
257: WHEN OTHERS THEN
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_MSSGS_PUB','lock_invoice_mssgs');
260: FND_MSG_PUB.count_and_get(
261: p_count => x_msg_count
262: ,p_data => x_msg_data);
263: END lock_invoice_mssgs;
297: p_count => x_msg_count
298: ,p_data => x_msg_data);
299: WHEN OTHERS THEN
300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
301: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_MSSGS_PUB','lock_invoice_mssgs');
302: FND_MSG_PUB.count_and_get(
303: p_count => x_msg_count
304: ,p_data => x_msg_data);
305: END lock_invoice_mssgs;
388: ROLLBACK TO invoice_mssgs_update;
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
390: x_msg_count := l_msg_count ;
391: x_msg_data := l_msg_data ;
392: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_MSSGS_PUB','update_invoice_mssgs');
393: FND_MSG_PUB.count_and_get(
394: p_count => x_msg_count
395: ,p_data => x_msg_data);
396: END update_invoice_mssgs;
477: ROLLBACK TO invoice_mssgs_update;
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: x_msg_count := l_msg_count ;
480: x_msg_data := l_msg_data ;
481: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_MSSGS_PUB','update_invoice_mssgs');
482: FND_MSG_PUB.count_and_get(
483: p_count => x_msg_count
484: ,p_data => x_msg_data);
485: END update_invoice_mssgs;
563: ROLLBACK TO invoice_mssgs_delete_rec;
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565: x_msg_count := l_msg_count ;
566: x_msg_data := l_msg_data ;
567: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_MSSGS_PUB','delete_invoice_mssgs');
568: FND_MSG_PUB.count_and_get(
569: p_count => x_msg_count
570: ,p_data => x_msg_data);
571: END delete_invoice_mssgs;
660: ROLLBACK TO invoice_mssgs_delete_tbl;
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662: x_msg_count := l_msg_count ;
663: x_msg_data := l_msg_data ;
664: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_MSSGS_PUB','delete_invoice_mssgs');
665: FND_MSG_PUB.count_and_get(
666: p_count => x_msg_count
667: ,p_data => x_msg_data);
668: END delete_invoice_mssgs;
750: ROLLBACK TO invoice_mssgs_validate;
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
752: x_msg_count := l_msg_count ;
753: x_msg_data := l_msg_data ;
754: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_MSSGS_PUB','validate_invoice_mssgs');
755: FND_MSG_PUB.count_and_get(
756: p_count => x_msg_count
757: ,p_data => x_msg_data);
758: END validate_invoice_mssgs;
835: ROLLBACK TO invoice_mssgs_validate;
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
837: x_msg_count := l_msg_count ;
838: x_msg_data := l_msg_data ;
839: FND_MSG_PUB.ADD_EXC_MSG('OKL_INVOICE_MSSGS_PUB','validate_invoice_mssgs');
840: FND_MSG_PUB.count_and_get(
841: p_count => x_msg_count
842: ,p_data => x_msg_data);
843: END validate_invoice_mssgs;
841: p_count => x_msg_count
842: ,p_data => x_msg_data);
843: END validate_invoice_mssgs;
844:
845: END OKL_INVOICE_MSSGS_PUB;