70: ROLLBACK TO xtl_csh_apps_insert;
71: x_return_status := FND_API.G_RET_STS_ERROR;
72: x_msg_count := l_msg_count ;
73: x_msg_data := l_msg_data ;
74: FND_MSG_PUB.count_and_get(
75: p_count => x_msg_count
76: ,p_data => x_msg_data);
77: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
78: ROLLBACK TO xtl_csh_apps_insert;
78: ROLLBACK TO xtl_csh_apps_insert;
79: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
80: x_msg_count := l_msg_count ;
81: x_msg_data := l_msg_data ;
82: FND_MSG_PUB.count_and_get(
83: p_count => x_msg_count
84: ,p_data => x_msg_data);
85: WHEN OTHERS THEN
86: ROLLBACK TO xtl_csh_apps_insert;
86: ROLLBACK TO xtl_csh_apps_insert;
87: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
88: x_msg_count := l_msg_count ;
89: x_msg_data := l_msg_data ;
90: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','insert_xtl_csh_apps');
91: FND_MSG_PUB.count_and_get(
92: p_count => x_msg_count
93: ,p_data => x_msg_data);
94: END insert_xtl_csh_apps;
87: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
88: x_msg_count := l_msg_count ;
89: x_msg_data := l_msg_data ;
90: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','insert_xtl_csh_apps');
91: FND_MSG_PUB.count_and_get(
92: p_count => x_msg_count
93: ,p_data => x_msg_data);
94: END insert_xtl_csh_apps;
95:
158: ROLLBACK TO xtl_csh_apps_insert;
159: x_return_status := FND_API.G_RET_STS_ERROR;
160: x_msg_count := l_msg_count ;
161: x_msg_data := l_msg_data ;
162: FND_MSG_PUB.count_and_get(
163: p_count => x_msg_count
164: ,p_data => x_msg_data);
165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
166: ROLLBACK TO xtl_csh_apps_insert;
166: ROLLBACK TO xtl_csh_apps_insert;
167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
168: x_msg_count := l_msg_count ;
169: x_msg_data := l_msg_data ;
170: FND_MSG_PUB.count_and_get(
171: p_count => x_msg_count
172: ,p_data => x_msg_data);
173: WHEN OTHERS THEN
174: ROLLBACK TO xtl_csh_apps_insert;
174: ROLLBACK TO xtl_csh_apps_insert;
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: x_msg_count := l_msg_count ;
177: x_msg_data := l_msg_data ;
178: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','insert_xtl_csh_apps');
179: FND_MSG_PUB.count_and_get(
180: p_count => x_msg_count
181: ,p_data => x_msg_data);
182: END insert_xtl_csh_apps;
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: x_msg_count := l_msg_count ;
177: x_msg_data := l_msg_data ;
178: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','insert_xtl_csh_apps');
179: FND_MSG_PUB.count_and_get(
180: p_count => x_msg_count
181: ,p_data => x_msg_data);
182: END insert_xtl_csh_apps;
183:
207:
208: EXCEPTION
209:
210: WHEN FND_API.G_EXC_ERROR THEN
211: FND_MSG_PUB.count_and_get(
212: p_count => x_msg_count
213: ,p_data => x_msg_data);
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: FND_MSG_PUB.count_and_get(
211: FND_MSG_PUB.count_and_get(
212: p_count => x_msg_count
213: ,p_data => x_msg_data);
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: FND_MSG_PUB.count_and_get(
216: p_count => x_msg_count
217: ,p_data => x_msg_data);
218: WHEN OTHERS THEN
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
216: p_count => x_msg_count
217: ,p_data => x_msg_data);
218: WHEN OTHERS THEN
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','lock_xtl_csh_apps');
221: FND_MSG_PUB.count_and_get(
222: p_count => x_msg_count
223: ,p_data => x_msg_data);
224: END lock_xtl_csh_apps;
217: ,p_data => x_msg_data);
218: WHEN OTHERS THEN
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','lock_xtl_csh_apps');
221: FND_MSG_PUB.count_and_get(
222: p_count => x_msg_count
223: ,p_data => x_msg_data);
224: END lock_xtl_csh_apps;
225:
249:
250: EXCEPTION
251:
252: WHEN FND_API.G_EXC_ERROR THEN
253: FND_MSG_PUB.count_and_get(
254: p_count => x_msg_count
255: ,p_data => x_msg_data);
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: FND_MSG_PUB.count_and_get(
253: FND_MSG_PUB.count_and_get(
254: p_count => x_msg_count
255: ,p_data => x_msg_data);
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: FND_MSG_PUB.count_and_get(
258: p_count => x_msg_count
259: ,p_data => x_msg_data);
260: WHEN OTHERS THEN
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: p_count => x_msg_count
259: ,p_data => x_msg_data);
260: WHEN OTHERS THEN
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','lock_xtl_csh_apps');
263: FND_MSG_PUB.count_and_get(
264: p_count => x_msg_count
265: ,p_data => x_msg_data);
266: END lock_xtl_csh_apps;
259: ,p_data => x_msg_data);
260: WHEN OTHERS THEN
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','lock_xtl_csh_apps');
263: FND_MSG_PUB.count_and_get(
264: p_count => x_msg_count
265: ,p_data => x_msg_data);
266: END lock_xtl_csh_apps;
267:
333: ROLLBACK TO xtl_csh_apps_update;
334: x_return_status := FND_API.G_RET_STS_ERROR;
335: x_msg_count := l_msg_count ;
336: x_msg_data := l_msg_data ;
337: FND_MSG_PUB.count_and_get(
338: p_count => x_msg_count
339: ,p_data => x_msg_data);
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: ROLLBACK TO xtl_csh_apps_update;
341: ROLLBACK TO xtl_csh_apps_update;
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: x_msg_count := l_msg_count ;
344: x_msg_data := l_msg_data ;
345: FND_MSG_PUB.count_and_get(
346: p_count => x_msg_count
347: ,p_data => x_msg_data);
348: WHEN OTHERS THEN
349: ROLLBACK TO xtl_csh_apps_update;
349: ROLLBACK TO xtl_csh_apps_update;
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
351: x_msg_count := l_msg_count ;
352: x_msg_data := l_msg_data ;
353: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','update_xtl_csh_apps');
354: FND_MSG_PUB.count_and_get(
355: p_count => x_msg_count
356: ,p_data => x_msg_data);
357: END update_xtl_csh_apps;
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
351: x_msg_count := l_msg_count ;
352: x_msg_data := l_msg_data ;
353: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','update_xtl_csh_apps');
354: FND_MSG_PUB.count_and_get(
355: p_count => x_msg_count
356: ,p_data => x_msg_data);
357: END update_xtl_csh_apps;
358:
422: ROLLBACK TO xtl_csh_apps_update;
423: x_return_status := FND_API.G_RET_STS_ERROR;
424: x_msg_count := l_msg_count ;
425: x_msg_data := l_msg_data ;
426: FND_MSG_PUB.count_and_get(
427: p_count => x_msg_count
428: ,p_data => x_msg_data);
429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
430: ROLLBACK TO xtl_csh_apps_update;
430: ROLLBACK TO xtl_csh_apps_update;
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
432: x_msg_count := l_msg_count ;
433: x_msg_data := l_msg_data ;
434: FND_MSG_PUB.count_and_get(
435: p_count => x_msg_count
436: ,p_data => x_msg_data);
437: WHEN OTHERS THEN
438: ROLLBACK TO xtl_csh_apps_update;
438: ROLLBACK TO xtl_csh_apps_update;
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440: x_msg_count := l_msg_count ;
441: x_msg_data := l_msg_data ;
442: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','update_xtl_csh_apps');
443: FND_MSG_PUB.count_and_get(
444: p_count => x_msg_count
445: ,p_data => x_msg_data);
446: END update_xtl_csh_apps;
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440: x_msg_count := l_msg_count ;
441: x_msg_data := l_msg_data ;
442: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','update_xtl_csh_apps');
443: FND_MSG_PUB.count_and_get(
444: p_count => x_msg_count
445: ,p_data => x_msg_data);
446: END update_xtl_csh_apps;
447:
508: ROLLBACK TO xtl_csh_apps_delete_rec;
509: x_return_status := FND_API.G_RET_STS_ERROR;
510: x_msg_count := l_msg_count ;
511: x_msg_data := l_msg_data ;
512: FND_MSG_PUB.count_and_get(
513: p_count => x_msg_count
514: ,p_data => x_msg_data);
515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
516: ROLLBACK TO xtl_csh_apps_delete_rec;
516: ROLLBACK TO xtl_csh_apps_delete_rec;
517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
518: x_msg_count := l_msg_count ;
519: x_msg_data := l_msg_data ;
520: FND_MSG_PUB.count_and_get(
521: p_count => x_msg_count
522: ,p_data => x_msg_data);
523: WHEN OTHERS THEN
524: ROLLBACK TO xtl_csh_apps_delete_rec;
524: ROLLBACK TO xtl_csh_apps_delete_rec;
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: x_msg_count := l_msg_count ;
527: x_msg_data := l_msg_data ;
528: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','delete_xtl_csh_apps');
529: FND_MSG_PUB.count_and_get(
530: p_count => x_msg_count
531: ,p_data => x_msg_data);
532: END delete_xtl_csh_apps;
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: x_msg_count := l_msg_count ;
527: x_msg_data := l_msg_data ;
528: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','delete_xtl_csh_apps');
529: FND_MSG_PUB.count_and_get(
530: p_count => x_msg_count
531: ,p_data => x_msg_data);
532: END delete_xtl_csh_apps;
533:
605: ROLLBACK TO xtl_csh_apps_delete_tbl;
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: x_msg_count := l_msg_count ;
608: x_msg_data := l_msg_data ;
609: FND_MSG_PUB.count_and_get(
610: p_count => x_msg_count
611: ,p_data => x_msg_data);
612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
613: ROLLBACK TO xtl_csh_apps_delete_tbl;
613: ROLLBACK TO xtl_csh_apps_delete_tbl;
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615: x_msg_count := l_msg_count ;
616: x_msg_data := l_msg_data ;
617: FND_MSG_PUB.count_and_get(
618: p_count => x_msg_count
619: ,p_data => x_msg_data);
620: WHEN OTHERS THEN
621: ROLLBACK TO xtl_csh_apps_delete_tbl;
621: ROLLBACK TO xtl_csh_apps_delete_tbl;
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
623: x_msg_count := l_msg_count ;
624: x_msg_data := l_msg_data ;
625: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','delete_xtl_csh_apps');
626: FND_MSG_PUB.count_and_get(
627: p_count => x_msg_count
628: ,p_data => x_msg_data);
629: END delete_xtl_csh_apps;
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
623: x_msg_count := l_msg_count ;
624: x_msg_data := l_msg_data ;
625: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','delete_xtl_csh_apps');
626: FND_MSG_PUB.count_and_get(
627: p_count => x_msg_count
628: ,p_data => x_msg_data);
629: END delete_xtl_csh_apps;
630:
691: ROLLBACK TO xtl_csh_apps_validate;
692: x_return_status := FND_API.G_RET_STS_ERROR;
693: x_msg_count := l_msg_count ;
694: x_msg_data := l_msg_data ;
695: FND_MSG_PUB.count_and_get(
696: p_count => x_msg_count
697: ,p_data => x_msg_data);
698: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
699: ROLLBACK TO xtl_csh_apps_validate;
699: ROLLBACK TO xtl_csh_apps_validate;
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
701: x_msg_count := l_msg_count ;
702: x_msg_data := l_msg_data ;
703: FND_MSG_PUB.count_and_get(
704: p_count => x_msg_count
705: ,p_data => x_msg_data);
706: WHEN OTHERS THEN
707: ROLLBACK TO xtl_csh_apps_validate;
707: ROLLBACK TO xtl_csh_apps_validate;
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
709: x_msg_count := l_msg_count ;
710: x_msg_data := l_msg_data ;
711: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','validate_xtl_csh_apps');
712: FND_MSG_PUB.count_and_get(
713: p_count => x_msg_count
714: ,p_data => x_msg_data);
715: END validate_xtl_csh_apps;
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
709: x_msg_count := l_msg_count ;
710: x_msg_data := l_msg_data ;
711: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','validate_xtl_csh_apps');
712: FND_MSG_PUB.count_and_get(
713: p_count => x_msg_count
714: ,p_data => x_msg_data);
715: END validate_xtl_csh_apps;
716:
773: ROLLBACK TO xtl_csh_apps_validate;
774: x_return_status := FND_API.G_RET_STS_ERROR;
775: x_msg_count := l_msg_count ;
776: x_msg_data := l_msg_data ;
777: FND_MSG_PUB.count_and_get(
778: p_count => x_msg_count
779: ,p_data => x_msg_data);
780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
781: ROLLBACK TO xtl_csh_apps_validate;
781: ROLLBACK TO xtl_csh_apps_validate;
782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
783: x_msg_count := l_msg_count ;
784: x_msg_data := l_msg_data ;
785: FND_MSG_PUB.count_and_get(
786: p_count => x_msg_count
787: ,p_data => x_msg_data);
788: WHEN OTHERS THEN
789: ROLLBACK TO xtl_csh_apps_validate;
789: ROLLBACK TO xtl_csh_apps_validate;
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
791: x_msg_count := l_msg_count ;
792: x_msg_data := l_msg_data ;
793: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','validate_xtl_csh_apps');
794: FND_MSG_PUB.count_and_get(
795: p_count => x_msg_count
796: ,p_data => x_msg_data);
797: END validate_xtl_csh_apps;
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
791: x_msg_count := l_msg_count ;
792: x_msg_data := l_msg_data ;
793: FND_MSG_PUB.ADD_EXC_MSG('OKL_XTL_CSH_APPS_PUB','validate_xtl_csh_apps');
794: FND_MSG_PUB.count_and_get(
795: p_count => x_msg_count
796: ,p_data => x_msg_data);
797: END validate_xtl_csh_apps;
798: