69: ROLLBACK TO open_int_insert;
70: x_return_status := FND_API.G_RET_STS_ERROR;
71: x_msg_count := l_msg_count ;
72: x_msg_data := l_msg_data ;
73: FND_MSG_PUB.count_and_get(
74: p_count => x_msg_count
75: ,p_data => x_msg_data);
76: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
77: ROLLBACK TO open_int_insert;
77: ROLLBACK TO open_int_insert;
78: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
79: x_msg_count := l_msg_count ;
80: x_msg_data := l_msg_data ;
81: FND_MSG_PUB.count_and_get(
82: p_count => x_msg_count
83: ,p_data => x_msg_data);
84: WHEN OTHERS THEN
85: ROLLBACK TO open_int_insert;
85: ROLLBACK TO open_int_insert;
86: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
87: x_msg_count := l_msg_count ;
88: x_msg_data := l_msg_data ;
89: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','insert_open_int');
90: FND_MSG_PUB.count_and_get(
91: p_count => x_msg_count
92: ,p_data => x_msg_data);
93: END insert_open_int;
86: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
87: x_msg_count := l_msg_count ;
88: x_msg_data := l_msg_data ;
89: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','insert_open_int');
90: FND_MSG_PUB.count_and_get(
91: p_count => x_msg_count
92: ,p_data => x_msg_data);
93: END insert_open_int;
94:
154: ROLLBACK TO open_int_insert;
155: x_return_status := FND_API.G_RET_STS_ERROR;
156: x_msg_count := l_msg_count ;
157: x_msg_data := l_msg_data ;
158: FND_MSG_PUB.count_and_get(
159: p_count => x_msg_count
160: ,p_data => x_msg_data);
161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
162: ROLLBACK TO open_int_insert;
162: ROLLBACK TO open_int_insert;
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: x_msg_count := l_msg_count ;
165: x_msg_data := l_msg_data ;
166: FND_MSG_PUB.count_and_get(
167: p_count => x_msg_count
168: ,p_data => x_msg_data);
169: WHEN OTHERS THEN
170: ROLLBACK TO open_int_insert;
170: ROLLBACK TO open_int_insert;
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: x_msg_count := l_msg_count ;
173: x_msg_data := l_msg_data ;
174: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','insert_open_int');
175: FND_MSG_PUB.count_and_get(
176: p_count => x_msg_count
177: ,p_data => x_msg_data);
178: END insert_open_int;
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: x_msg_count := l_msg_count ;
173: x_msg_data := l_msg_data ;
174: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','insert_open_int');
175: FND_MSG_PUB.count_and_get(
176: p_count => x_msg_count
177: ,p_data => x_msg_data);
178: END insert_open_int;
179:
202:
203: EXCEPTION
204:
205: WHEN FND_API.G_EXC_ERROR THEN
206: FND_MSG_PUB.count_and_get(
207: p_count => x_msg_count
208: ,p_data => x_msg_data);
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
210: FND_MSG_PUB.count_and_get(
206: FND_MSG_PUB.count_and_get(
207: p_count => x_msg_count
208: ,p_data => x_msg_data);
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
210: FND_MSG_PUB.count_and_get(
211: p_count => x_msg_count
212: ,p_data => x_msg_data);
213: WHEN OTHERS THEN
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
211: p_count => x_msg_count
212: ,p_data => x_msg_data);
213: WHEN OTHERS THEN
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
215: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','lock_open_int');
216: FND_MSG_PUB.count_and_get(
217: p_count => x_msg_count
218: ,p_data => x_msg_data);
219: END lock_open_int;
212: ,p_data => x_msg_data);
213: WHEN OTHERS THEN
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
215: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','lock_open_int');
216: FND_MSG_PUB.count_and_get(
217: p_count => x_msg_count
218: ,p_data => x_msg_data);
219: END lock_open_int;
220:
242: END IF;
243: EXCEPTION
244:
245: WHEN FND_API.G_EXC_ERROR THEN
246: FND_MSG_PUB.count_and_get(
247: p_count => x_msg_count
248: ,p_data => x_msg_data);
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250: FND_MSG_PUB.count_and_get(
246: FND_MSG_PUB.count_and_get(
247: p_count => x_msg_count
248: ,p_data => x_msg_data);
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250: FND_MSG_PUB.count_and_get(
251: p_count => x_msg_count
252: ,p_data => x_msg_data);
253: WHEN OTHERS THEN
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
251: p_count => x_msg_count
252: ,p_data => x_msg_data);
253: WHEN OTHERS THEN
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','lock_open_int');
256: FND_MSG_PUB.count_and_get(
257: p_count => x_msg_count
258: ,p_data => x_msg_data);
259: END lock_open_int;
252: ,p_data => x_msg_data);
253: WHEN OTHERS THEN
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','lock_open_int');
256: FND_MSG_PUB.count_and_get(
257: p_count => x_msg_count
258: ,p_data => x_msg_data);
259: END lock_open_int;
260:
324: ROLLBACK TO open_int_update;
325: x_return_status := FND_API.G_RET_STS_ERROR;
326: x_msg_count := l_msg_count ;
327: x_msg_data := l_msg_data ;
328: FND_MSG_PUB.count_and_get(
329: p_count => x_msg_count
330: ,p_data => x_msg_data);
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: ROLLBACK TO open_int_update;
332: ROLLBACK TO open_int_update;
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: x_msg_count := l_msg_count ;
335: x_msg_data := l_msg_data ;
336: FND_MSG_PUB.count_and_get(
337: p_count => x_msg_count
338: ,p_data => x_msg_data);
339: WHEN OTHERS THEN
340: ROLLBACK TO open_int_update;
340: ROLLBACK TO open_int_update;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: x_msg_count := l_msg_count ;
343: x_msg_data := l_msg_data ;
344: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','update_open_int');
345: FND_MSG_PUB.count_and_get(
346: p_count => x_msg_count
347: ,p_data => x_msg_data);
348: END update_open_int;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: x_msg_count := l_msg_count ;
343: x_msg_data := l_msg_data ;
344: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','update_open_int');
345: FND_MSG_PUB.count_and_get(
346: p_count => x_msg_count
347: ,p_data => x_msg_data);
348: END update_open_int;
349:
411: ROLLBACK TO open_int_update;
412: x_return_status := FND_API.G_RET_STS_ERROR;
413: x_msg_count := l_msg_count ;
414: x_msg_data := l_msg_data ;
415: FND_MSG_PUB.count_and_get(
416: p_count => x_msg_count
417: ,p_data => x_msg_data);
418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
419: ROLLBACK TO open_int_update;
419: ROLLBACK TO open_int_update;
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: x_msg_count := l_msg_count ;
422: x_msg_data := l_msg_data ;
423: FND_MSG_PUB.count_and_get(
424: p_count => x_msg_count
425: ,p_data => x_msg_data);
426: WHEN OTHERS THEN
427: ROLLBACK TO open_int_update;
427: ROLLBACK TO open_int_update;
428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
429: x_msg_count := l_msg_count ;
430: x_msg_data := l_msg_data ;
431: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','update_open_int');
432: FND_MSG_PUB.count_and_get(
433: p_count => x_msg_count
434: ,p_data => x_msg_data);
435: END update_open_int;
428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
429: x_msg_count := l_msg_count ;
430: x_msg_data := l_msg_data ;
431: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','update_open_int');
432: FND_MSG_PUB.count_and_get(
433: p_count => x_msg_count
434: ,p_data => x_msg_data);
435: END update_open_int;
436:
495: ROLLBACK TO open_int_delete_rec;
496: x_return_status := FND_API.G_RET_STS_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 FND_API.G_EXC_UNEXPECTED_ERROR THEN
503: ROLLBACK TO open_int_delete_rec;
503: ROLLBACK TO open_int_delete_rec;
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.count_and_get(
508: p_count => x_msg_count
509: ,p_data => x_msg_data);
510: WHEN OTHERS THEN
511: ROLLBACK TO open_int_delete_rec;
511: ROLLBACK TO open_int_delete_rec;
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
513: x_msg_count := l_msg_count ;
514: x_msg_data := l_msg_data ;
515: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','delete_open_int');
516: FND_MSG_PUB.count_and_get(
517: p_count => x_msg_count
518: ,p_data => x_msg_data);
519: END delete_open_int;
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
513: x_msg_count := l_msg_count ;
514: x_msg_data := l_msg_data ;
515: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','delete_open_int');
516: FND_MSG_PUB.count_and_get(
517: p_count => x_msg_count
518: ,p_data => x_msg_data);
519: END delete_open_int;
520:
590: ROLLBACK TO open_int_delete_tbl;
591: x_return_status := FND_API.G_RET_STS_ERROR;
592: x_msg_count := l_msg_count ;
593: x_msg_data := l_msg_data ;
594: FND_MSG_PUB.count_and_get(
595: p_count => x_msg_count
596: ,p_data => x_msg_data);
597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
598: ROLLBACK TO open_int_delete_tbl;
598: ROLLBACK TO open_int_delete_tbl;
599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
600: x_msg_count := l_msg_count ;
601: x_msg_data := l_msg_data ;
602: FND_MSG_PUB.count_and_get(
603: p_count => x_msg_count
604: ,p_data => x_msg_data);
605: WHEN OTHERS THEN
606: ROLLBACK TO open_int_delete_tbl;
606: ROLLBACK TO open_int_delete_tbl;
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: x_msg_count := l_msg_count ;
609: x_msg_data := l_msg_data ;
610: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','delete_open_int');
611: FND_MSG_PUB.count_and_get(
612: p_count => x_msg_count
613: ,p_data => x_msg_data);
614: END delete_open_int;
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: x_msg_count := l_msg_count ;
609: x_msg_data := l_msg_data ;
610: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','delete_open_int');
611: FND_MSG_PUB.count_and_get(
612: p_count => x_msg_count
613: ,p_data => x_msg_data);
614: END delete_open_int;
615:
678: ROLLBACK TO open_int_validate;
679: x_return_status := FND_API.G_RET_STS_ERROR;
680: x_msg_count := l_msg_count ;
681: x_msg_data := l_msg_data ;
682: FND_MSG_PUB.count_and_get(
683: p_count => x_msg_count
684: ,p_data => x_msg_data);
685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
686: ROLLBACK TO open_int_validate;
686: ROLLBACK TO open_int_validate;
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
688: x_msg_count := l_msg_count ;
689: x_msg_data := l_msg_data ;
690: FND_MSG_PUB.count_and_get(
691: p_count => x_msg_count
692: ,p_data => x_msg_data);
693: WHEN OTHERS THEN
694: ROLLBACK TO open_int_validate;
694: ROLLBACK TO open_int_validate;
695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
696: x_msg_count := l_msg_count ;
697: x_msg_data := l_msg_data ;
698: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','validate_open_int');
699: FND_MSG_PUB.count_and_get(
700: p_count => x_msg_count
701: ,p_data => x_msg_data);
702: END validate_open_int;
695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
696: x_msg_count := l_msg_count ;
697: x_msg_data := l_msg_data ;
698: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','validate_open_int');
699: FND_MSG_PUB.count_and_get(
700: p_count => x_msg_count
701: ,p_data => x_msg_data);
702: END validate_open_int;
703:
762: ROLLBACK TO open_int_validate;
763: x_return_status := FND_API.G_RET_STS_ERROR;
764: x_msg_count := l_msg_count ;
765: x_msg_data := l_msg_data ;
766: FND_MSG_PUB.count_and_get(
767: p_count => x_msg_count
768: ,p_data => x_msg_data);
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: ROLLBACK TO open_int_validate;
770: ROLLBACK TO open_int_validate;
771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: x_msg_count := l_msg_count ;
773: x_msg_data := l_msg_data ;
774: FND_MSG_PUB.count_and_get(
775: p_count => x_msg_count
776: ,p_data => x_msg_data);
777: WHEN OTHERS THEN
778: ROLLBACK TO open_int_validate;
778: ROLLBACK TO open_int_validate;
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
780: x_msg_count := l_msg_count ;
781: x_msg_data := l_msg_data ;
782: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','validate_open_int');
783: FND_MSG_PUB.count_and_get(
784: p_count => x_msg_count
785: ,p_data => x_msg_data);
786: END validate_open_int;
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
780: x_msg_count := l_msg_count ;
781: x_msg_data := l_msg_data ;
782: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPEN_INT_PUB','validate_open_int');
783: FND_MSG_PUB.count_and_get(
784: p_count => x_msg_count
785: ,p_data => x_msg_data);
786: END validate_open_int;
787: