72: ROLLBACK TO late_policies_insert;
73: x_return_status := Fnd_Api.G_RET_STS_ERROR;
74: x_msg_count := l_msg_count ;
75: x_msg_data := l_msg_data ;
76: Fnd_Msg_Pub.count_and_get(
77: p_count => x_msg_count
78: ,p_data => x_msg_data);
79: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
80: ROLLBACK TO late_policies_insert;
80: ROLLBACK TO late_policies_insert;
81: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
82: x_msg_count := l_msg_count ;
83: x_msg_data := l_msg_data ;
84: Fnd_Msg_Pub.count_and_get(
85: p_count => x_msg_count
86: ,p_data => x_msg_data);
87: WHEN OTHERS THEN
88: ROLLBACK TO late_policies_insert;
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;
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;
97:
165: ROLLBACK TO late_policies_insert;
166: x_return_status := Fnd_Api.G_RET_STS_ERROR;
167: x_msg_count := l_msg_count ;
168: x_msg_data := l_msg_data ;
169: Fnd_Msg_Pub.count_and_get(
170: p_count => x_msg_count
171: ,p_data => x_msg_data);
172: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
173: ROLLBACK TO late_policies_insert;
173: ROLLBACK TO late_policies_insert;
174: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
175: x_msg_count := l_msg_count ;
176: x_msg_data := l_msg_data ;
177: Fnd_Msg_Pub.count_and_get(
178: p_count => x_msg_count
179: ,p_data => x_msg_data);
180: WHEN OTHERS THEN
181: ROLLBACK TO late_policies_insert;
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;
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;
190:
214:
215: EXCEPTION
216:
217: WHEN Fnd_Api.G_EXC_ERROR THEN
218: Fnd_Msg_Pub.count_and_get(
219: p_count => x_msg_count
220: ,p_data => x_msg_data);
221: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
222: Fnd_Msg_Pub.count_and_get(
218: Fnd_Msg_Pub.count_and_get(
219: p_count => x_msg_count
220: ,p_data => x_msg_data);
221: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
222: Fnd_Msg_Pub.count_and_get(
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;
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;
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;
232:
256:
257: EXCEPTION
258:
259: WHEN Fnd_Api.G_EXC_ERROR THEN
260: Fnd_Msg_Pub.count_and_get(
261: p_count => x_msg_count
262: ,p_data => x_msg_data);
263: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
264: Fnd_Msg_Pub.count_and_get(
260: Fnd_Msg_Pub.count_and_get(
261: p_count => x_msg_count
262: ,p_data => x_msg_data);
263: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
264: Fnd_Msg_Pub.count_and_get(
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;
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;
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;
274:
340: ROLLBACK TO late_policies_update;
341: x_return_status := Fnd_Api.G_RET_STS_ERROR;
342: x_msg_count := l_msg_count ;
343: x_msg_data := l_msg_data ;
344: Fnd_Msg_Pub.count_and_get(
345: p_count => x_msg_count
346: ,p_data => x_msg_data);
347: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
348: ROLLBACK TO late_policies_update;
348: ROLLBACK TO late_policies_update;
349: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
350: x_msg_count := l_msg_count ;
351: x_msg_data := l_msg_data ;
352: Fnd_Msg_Pub.count_and_get(
353: p_count => x_msg_count
354: ,p_data => x_msg_data);
355: WHEN OTHERS THEN
356: ROLLBACK TO late_policies_update;
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;
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;
365:
429: ROLLBACK TO late_policies_update;
430: x_return_status := Fnd_Api.G_RET_STS_ERROR;
431: x_msg_count := l_msg_count ;
432: x_msg_data := l_msg_data ;
433: Fnd_Msg_Pub.count_and_get(
434: p_count => x_msg_count
435: ,p_data => x_msg_data);
436: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
437: ROLLBACK TO late_policies_update;
437: ROLLBACK TO late_policies_update;
438: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
439: x_msg_count := l_msg_count ;
440: x_msg_data := l_msg_data ;
441: Fnd_Msg_Pub.count_and_get(
442: p_count => x_msg_count
443: ,p_data => x_msg_data);
444: WHEN OTHERS THEN
445: ROLLBACK TO late_policies_update;
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;
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;
454:
515: ROLLBACK TO late_policies_delete_rec;
516: x_return_status := Fnd_Api.G_RET_STS_ERROR;
517: x_msg_count := l_msg_count ;
518: x_msg_data := l_msg_data ;
519: Fnd_Msg_Pub.count_and_get(
520: p_count => x_msg_count
521: ,p_data => x_msg_data);
522: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
523: ROLLBACK TO late_policies_delete_rec;
523: ROLLBACK TO late_policies_delete_rec;
524: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
525: x_msg_count := l_msg_count ;
526: x_msg_data := l_msg_data ;
527: Fnd_Msg_Pub.count_and_get(
528: p_count => x_msg_count
529: ,p_data => x_msg_data);
530: WHEN OTHERS THEN
531: ROLLBACK TO late_policies_delete_rec;
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;
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;
540:
612: ROLLBACK TO late_policies_delete_tbl;
613: x_return_status := Fnd_Api.G_RET_STS_ERROR;
614: x_msg_count := l_msg_count ;
615: x_msg_data := l_msg_data ;
616: Fnd_Msg_Pub.count_and_get(
617: p_count => x_msg_count
618: ,p_data => x_msg_data);
619: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
620: ROLLBACK TO late_policies_delete_tbl;
620: ROLLBACK TO late_policies_delete_tbl;
621: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
622: x_msg_count := l_msg_count ;
623: x_msg_data := l_msg_data ;
624: Fnd_Msg_Pub.count_and_get(
625: p_count => x_msg_count
626: ,p_data => x_msg_data);
627: WHEN OTHERS THEN
628: ROLLBACK TO late_policies_delete_tbl;
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;
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;
637:
702: ROLLBACK TO late_policies_validate;
703: x_return_status := Fnd_Api.G_RET_STS_ERROR;
704: x_msg_count := l_msg_count ;
705: x_msg_data := l_msg_data ;
706: Fnd_Msg_Pub.count_and_get(
707: p_count => x_msg_count
708: ,p_data => x_msg_data);
709: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
710: ROLLBACK TO late_policies_validate;
710: ROLLBACK TO late_policies_validate;
711: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
712: x_msg_count := l_msg_count ;
713: x_msg_data := l_msg_data ;
714: Fnd_Msg_Pub.count_and_get(
715: p_count => x_msg_count
716: ,p_data => x_msg_data);
717: WHEN OTHERS THEN
718: ROLLBACK TO late_policies_validate;
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;
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;
727:
787: ROLLBACK TO late_policies_validate;
788: x_return_status := Fnd_Api.G_RET_STS_ERROR;
789: x_msg_count := l_msg_count ;
790: x_msg_data := l_msg_data ;
791: Fnd_Msg_Pub.count_and_get(
792: p_count => x_msg_count
793: ,p_data => x_msg_data);
794: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
795: ROLLBACK TO late_policies_validate;
795: ROLLBACK TO late_policies_validate;
796: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
797: x_msg_count := l_msg_count ;
798: x_msg_data := l_msg_data ;
799: Fnd_Msg_Pub.count_and_get(
800: p_count => x_msg_count
801: ,p_data => x_msg_data);
802: WHEN OTHERS THEN
803: ROLLBACK TO late_policies_validate;
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;
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;
812: