[Home] [Help]
1: PACKAGE BODY okl_ins_policies_pub AS
2: /* $Header: OKLPIPYB.pls 120.3 2006/11/22 18:28:40 asahoo noship $ */
3: PROCEDURE insert_ins_policies(
4: p_api_version IN NUMBER
5: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
71: ROLLBACK TO ins_policies_insert;
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
73: x_msg_count := l_msg_count ;
74: x_msg_data := l_msg_data ;
75: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','insert_ins_policies');
76: FND_MSG_PUB.count_and_get(
77: p_count => x_msg_count
78: ,p_data => x_msg_data);
79: END insert_ins_policies;
145: ROLLBACK TO ins_policies_insert;
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
147: x_msg_count := l_msg_count ;
148: x_msg_data := l_msg_data ;
149: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','insert_ins_policies');
150: FND_MSG_PUB.count_and_get(
151: p_count => x_msg_count
152: ,p_data => x_msg_data);
153: END insert_ins_policies;
181: p_count => x_msg_count
182: ,p_data => x_msg_data);
183: WHEN OTHERS THEN
184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
185: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','lock_ins_policies');
186: FND_MSG_PUB.count_and_get(
187: p_count => x_msg_count
188: ,p_data => x_msg_data);
189: END lock_ins_policies;
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_POLICIES_PUB','lock_ins_policies');
222: FND_MSG_PUB.count_and_get(
223: p_count => x_msg_count
224: ,p_data => x_msg_data);
225: END lock_ins_policies;
288: ROLLBACK TO ins_policies_update;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: x_msg_count := l_msg_count ;
291: x_msg_data := l_msg_data ;
292: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','update_ins_policies');
293: FND_MSG_PUB.count_and_get(
294: p_count => x_msg_count
295: ,p_data => x_msg_data);
296: END update_ins_policies;
358: ROLLBACK TO ins_policies_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_INS_POLICIES_PUB','update_ins_policies');
363: FND_MSG_PUB.count_and_get(
364: p_count => x_msg_count
365: ,p_data => x_msg_data);
366: END update_ins_policies;
426: ROLLBACK TO ins_policies_delete_rec;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: x_msg_count := l_msg_count ;
429: x_msg_data := l_msg_data ;
430: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','delete_ins_policies');
431: FND_MSG_PUB.count_and_get(
432: p_count => x_msg_count
433: ,p_data => x_msg_data);
434: END delete_ins_policies;
503: ROLLBACK TO ins_policies_delete_tbl;
504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505: x_msg_count := l_msg_count ;
506: x_msg_data := l_msg_data ;
507: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','delete_ins_policies');
508: FND_MSG_PUB.count_and_get(
509: p_count => x_msg_count
510: ,p_data => x_msg_data);
511: END delete_ins_policies;
570: ROLLBACK TO ins_policies_validate;
571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
572: x_msg_count := l_msg_count ;
573: x_msg_data := l_msg_data ;
574: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','validate_ins_policies');
575: FND_MSG_PUB.count_and_get(
576: p_count => x_msg_count
577: ,p_data => x_msg_data);
578: END validate_ins_policies;
637: ROLLBACK TO ins_policies_validate;
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: x_msg_count := l_msg_count ;
640: x_msg_data := l_msg_data ;
641: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','validate_ins_policies');
642: FND_MSG_PUB.count_and_get(
643: p_count => x_msg_count
644: ,p_data => x_msg_data);
645: END validate_ins_policies;
642: FND_MSG_PUB.count_and_get(
643: p_count => x_msg_count
644: ,p_data => x_msg_data);
645: END validate_ins_policies;
646: END OKL_INS_POLICIES_PUB;