[Home] [Help]
1: Package BODY Okl_Late_Policies_Pub AS
2: /* $Header: OKLPLPOB.pls 115.7 2004/04/13 10:52:19 rnaik noship $ */
3:
4: PROCEDURE insert_late_policies(
5: p_api_version IN NUMBER
88: ROLLBACK TO late_policies_insert;
89: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
90: x_msg_count := l_msg_count ;
91: x_msg_data := l_msg_data ;
92: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_LATE_POLICIES_PUB','insert_late_policies');
93: Fnd_Msg_Pub.count_and_get(
94: p_count => x_msg_count
95: ,p_data => x_msg_data);
96: END insert_late_policies;
181: ROLLBACK TO late_policies_insert;
182: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
183: x_msg_count := l_msg_count ;
184: x_msg_data := l_msg_data ;
185: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_LATE_POLICIES_PUB','insert_late_policies');
186: Fnd_Msg_Pub.count_and_get(
187: p_count => x_msg_count
188: ,p_data => x_msg_data);
189: END insert_late_policies;
223: p_count => x_msg_count
224: ,p_data => x_msg_data);
225: WHEN OTHERS THEN
226: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
227: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_LATE_POLICIES_PUB','lock_late_policies');
228: Fnd_Msg_Pub.count_and_get(
229: p_count => x_msg_count
230: ,p_data => x_msg_data);
231: END lock_late_policies;
265: p_count => x_msg_count
266: ,p_data => x_msg_data);
267: WHEN OTHERS THEN
268: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
269: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_LATE_POLICIES_PUB','lock_late_policies');
270: Fnd_Msg_Pub.count_and_get(
271: p_count => x_msg_count
272: ,p_data => x_msg_data);
273: END lock_late_policies;
356: ROLLBACK TO late_policies_update;
357: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
358: x_msg_count := l_msg_count ;
359: x_msg_data := l_msg_data ;
360: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_LATE_POLICIES_PUB','update_late_policies');
361: Fnd_Msg_Pub.count_and_get(
362: p_count => x_msg_count
363: ,p_data => x_msg_data);
364: END update_late_policies;
445: ROLLBACK TO late_policies_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_LATE_POLICIES_PUB','update_late_policies');
450: Fnd_Msg_Pub.count_and_get(
451: p_count => x_msg_count
452: ,p_data => x_msg_data);
453: END update_late_policies;
531: ROLLBACK TO late_policies_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_LATE_POLICIES_PUB','delete_late_policies');
536: Fnd_Msg_Pub.count_and_get(
537: p_count => x_msg_count
538: ,p_data => x_msg_data);
539: END delete_late_policies;
628: ROLLBACK TO late_policies_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_LATE_POLICIES_PUB','delete_late_policies');
633: Fnd_Msg_Pub.count_and_get(
634: p_count => x_msg_count
635: ,p_data => x_msg_data);
636: END delete_late_policies;
718: ROLLBACK TO late_policies_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_LATE_POLICIES_PUB','validate_late_policies');
723: Fnd_Msg_Pub.count_and_get(
724: p_count => x_msg_count
725: ,p_data => x_msg_data);
726: END validate_late_policies;
803: ROLLBACK TO late_policies_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_LATE_POLICIES_PUB','validate_late_policies');
808: Fnd_Msg_Pub.count_and_get(
809: p_count => x_msg_count
810: ,p_data => x_msg_data);
811: END validate_late_policies;
809: p_count => x_msg_count
810: ,p_data => x_msg_data);
811: END validate_late_policies;
812:
813: END Okl_Late_Policies_Pub;