55: ROLLBACK TO ins_policies_insert;
56: x_return_status := FND_API.G_RET_STS_ERROR;
57: x_msg_count := l_msg_count ;
58: x_msg_data := l_msg_data ;
59: FND_MSG_PUB.count_and_get(
60: p_count => x_msg_count
61: ,p_data => x_msg_data);
62: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
63: ROLLBACK TO ins_policies_insert;
63: ROLLBACK TO ins_policies_insert;
64: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
65: x_msg_count := l_msg_count ;
66: x_msg_data := l_msg_data ;
67: FND_MSG_PUB.count_and_get(
68: p_count => x_msg_count
69: ,p_data => x_msg_data);
70: WHEN OTHERS THEN
71: ROLLBACK TO ins_policies_insert;
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;
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;
80: PROCEDURE insert_ins_policies(
129: ROLLBACK TO ins_policies_insert;
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: x_msg_count := l_msg_count ;
132: x_msg_data := l_msg_data ;
133: FND_MSG_PUB.count_and_get(
134: p_count => x_msg_count
135: ,p_data => x_msg_data);
136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
137: ROLLBACK TO ins_policies_insert;
137: ROLLBACK TO ins_policies_insert;
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
139: x_msg_count := l_msg_count ;
140: x_msg_data := l_msg_data ;
141: FND_MSG_PUB.count_and_get(
142: p_count => x_msg_count
143: ,p_data => x_msg_data);
144: WHEN OTHERS THEN
145: ROLLBACK TO ins_policies_insert;
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;
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;
154: PROCEDURE lock_ins_policies(
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;
174: EXCEPTION
175: WHEN FND_API.G_EXC_ERROR THEN
176: FND_MSG_PUB.count_and_get(
177: p_count => x_msg_count
178: ,p_data => x_msg_data);
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: FND_MSG_PUB.count_and_get(
176: FND_MSG_PUB.count_and_get(
177: p_count => x_msg_count
178: ,p_data => x_msg_data);
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: FND_MSG_PUB.count_and_get(
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;
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;
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;
190: PROCEDURE lock_ins_policies(
208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
209: END IF;
210: EXCEPTION
211: WHEN FND_API.G_EXC_ERROR THEN
212: FND_MSG_PUB.count_and_get(
213: p_count => x_msg_count
214: ,p_data => x_msg_data);
215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
216: FND_MSG_PUB.count_and_get(
212: FND_MSG_PUB.count_and_get(
213: p_count => x_msg_count
214: ,p_data => x_msg_data);
215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
216: FND_MSG_PUB.count_and_get(
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;
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;
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;
226: PROCEDURE update_ins_policies(
272: ROLLBACK TO ins_policies_update;
273: x_return_status := FND_API.G_RET_STS_ERROR;
274: x_msg_count := l_msg_count ;
275: x_msg_data := l_msg_data ;
276: FND_MSG_PUB.count_and_get(
277: p_count => x_msg_count
278: ,p_data => x_msg_data);
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: ROLLBACK TO ins_policies_update;
280: ROLLBACK TO ins_policies_update;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: x_msg_count := l_msg_count ;
283: x_msg_data := l_msg_data ;
284: FND_MSG_PUB.count_and_get(
285: p_count => x_msg_count
286: ,p_data => x_msg_data);
287: WHEN OTHERS THEN
288: ROLLBACK TO ins_policies_update;
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;
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;
297: PROCEDURE update_ins_policies(
342: ROLLBACK TO ins_policies_update;
343: x_return_status := FND_API.G_RET_STS_ERROR;
344: x_msg_count := l_msg_count ;
345: x_msg_data := l_msg_data ;
346: FND_MSG_PUB.count_and_get(
347: p_count => x_msg_count
348: ,p_data => x_msg_data);
349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
350: ROLLBACK TO ins_policies_update;
350: ROLLBACK TO ins_policies_update;
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: x_msg_count := l_msg_count ;
353: x_msg_data := l_msg_data ;
354: FND_MSG_PUB.count_and_get(
355: p_count => x_msg_count
356: ,p_data => x_msg_data);
357: WHEN OTHERS THEN
358: ROLLBACK TO ins_policies_update;
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;
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;
367: --Put custom code for cascade delete by developer
410: ROLLBACK TO ins_policies_delete_rec;
411: x_return_status := FND_API.G_RET_STS_ERROR;
412: x_msg_count := l_msg_count ;
413: x_msg_data := l_msg_data ;
414: FND_MSG_PUB.count_and_get(
415: p_count => x_msg_count
416: ,p_data => x_msg_data);
417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
418: ROLLBACK TO ins_policies_delete_rec;
418: ROLLBACK TO ins_policies_delete_rec;
419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
420: x_msg_count := l_msg_count ;
421: x_msg_data := l_msg_data ;
422: FND_MSG_PUB.count_and_get(
423: p_count => x_msg_count
424: ,p_data => x_msg_data);
425: WHEN OTHERS THEN
426: ROLLBACK TO ins_policies_delete_rec;
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;
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;
435: PROCEDURE delete_ins_policies(
487: ROLLBACK TO ins_policies_delete_tbl;
488: x_return_status := FND_API.G_RET_STS_ERROR;
489: x_msg_count := l_msg_count ;
490: x_msg_data := l_msg_data ;
491: FND_MSG_PUB.count_and_get(
492: p_count => x_msg_count
493: ,p_data => x_msg_data);
494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
495: ROLLBACK TO ins_policies_delete_tbl;
495: ROLLBACK TO ins_policies_delete_tbl;
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: x_msg_count := l_msg_count ;
498: x_msg_data := l_msg_data ;
499: FND_MSG_PUB.count_and_get(
500: p_count => x_msg_count
501: ,p_data => x_msg_data);
502: WHEN OTHERS THEN
503: ROLLBACK TO ins_policies_delete_tbl;
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;
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;
512: PROCEDURE validate_ins_policies(
554: ROLLBACK TO ins_policies_validate;
555: x_return_status := FND_API.G_RET_STS_ERROR;
556: x_msg_count := l_msg_count ;
557: x_msg_data := l_msg_data ;
558: FND_MSG_PUB.count_and_get(
559: p_count => x_msg_count
560: ,p_data => x_msg_data);
561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
562: ROLLBACK TO ins_policies_validate;
562: ROLLBACK TO ins_policies_validate;
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: x_msg_count := l_msg_count ;
565: x_msg_data := l_msg_data ;
566: FND_MSG_PUB.count_and_get(
567: p_count => x_msg_count
568: ,p_data => x_msg_data);
569: WHEN OTHERS THEN
570: ROLLBACK TO ins_policies_validate;
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;
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;
579: PROCEDURE validate_ins_policies(
621: ROLLBACK TO ins_policies_validate;
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: x_msg_count := l_msg_count ;
624: x_msg_data := l_msg_data ;
625: FND_MSG_PUB.count_and_get(
626: p_count => x_msg_count
627: ,p_data => x_msg_data);
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
629: ROLLBACK TO ins_policies_validate;
629: ROLLBACK TO ins_policies_validate;
630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: x_msg_count := l_msg_count ;
632: x_msg_data := l_msg_data ;
633: FND_MSG_PUB.count_and_get(
634: p_count => x_msg_count
635: ,p_data => x_msg_data);
636: WHEN OTHERS THEN
637: ROLLBACK TO ins_policies_validate;
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;
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;
646: END OKL_INS_POLICIES_PUB;