[Home] [Help]
1: PACKAGE BODY okl_ins_class_cats_pub AS
2: /* $Header: OKLPICGB.pls 115.8 2004/04/13 10:47:16 rnaik noship $ */
3:
4: PROCEDURE insert_ins_class_cats(
5: p_api_version IN NUMBER
87: ROLLBACK TO ins_class_cats_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_INS_CLASS_CATS_PUB','insert_ins_class_cats');
92: FND_MSG_PUB.count_and_get(
93: p_count => x_msg_count
94: ,p_data => x_msg_data);
95: END insert_ins_class_cats;
175: ROLLBACK TO ins_class_cats_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_INS_CLASS_CATS_PUB','insert_ins_class_cats');
180: FND_MSG_PUB.count_and_get(
181: p_count => x_msg_count
182: ,p_data => x_msg_data);
183: END insert_ins_class_cats;
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_INS_CLASS_CATS_PUB','lock_ins_class_cats');
222: FND_MSG_PUB.count_and_get(
223: p_count => x_msg_count
224: ,p_data => x_msg_data);
225: END lock_ins_class_cats;
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_INS_CLASS_CATS_PUB','lock_ins_class_cats');
264: FND_MSG_PUB.count_and_get(
265: p_count => x_msg_count
266: ,p_data => x_msg_data);
267: END lock_ins_class_cats;
353: ROLLBACK TO ins_class_cats_update;
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
355: x_msg_count := l_msg_count ;
356: x_msg_data := l_msg_data ;
357: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','update_ins_class_cats');
358: FND_MSG_PUB.count_and_get(
359: p_count => x_msg_count
360: ,p_data => x_msg_data);
361:
445: ROLLBACK TO ins_class_cats_update;
446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
447: x_msg_count := l_msg_count ;
448: x_msg_data := l_msg_data ;
449: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','update_ins_class_cats');
450: FND_MSG_PUB.count_and_get(
451: p_count => x_msg_count
452: ,p_data => x_msg_data);
453: END update_ins_class_cats;
531: ROLLBACK TO ins_class_cats_delete_rec;
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
533: x_msg_count := l_msg_count ;
534: x_msg_data := l_msg_data ;
535: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','delete_ins_class_cats');
536: FND_MSG_PUB.count_and_get(
537: p_count => x_msg_count
538: ,p_data => x_msg_data);
539: END delete_ins_class_cats;
628: ROLLBACK TO ins_class_cats_delete_tbl;
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: x_msg_count := l_msg_count ;
631: x_msg_data := l_msg_data ;
632: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','delete_ins_class_cats');
633: FND_MSG_PUB.count_and_get(
634: p_count => x_msg_count
635: ,p_data => x_msg_data);
636: END delete_ins_class_cats;
718: ROLLBACK TO ins_class_cats_validate;
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720: x_msg_count := l_msg_count ;
721: x_msg_data := l_msg_data ;
722: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','validate_ins_class_cats');
723: FND_MSG_PUB.count_and_get(
724: p_count => x_msg_count
725: ,p_data => x_msg_data);
726: END validate_ins_class_cats;
803: ROLLBACK TO ins_class_cats_validate;
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805: x_msg_count := l_msg_count ;
806: x_msg_data := l_msg_data ;
807: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_CLASS_CATS_PUB','validate_ins_class_cats');
808: FND_MSG_PUB.count_and_get(
809: p_count => x_msg_count
810: ,p_data => x_msg_data);
811: END validate_ins_class_cats;
809: p_count => x_msg_count
810: ,p_data => x_msg_data);
811: END validate_ins_class_cats;
812:
813: END OKL_INS_CLASS_CATS_PUB;