66: ROLLBACK TO trx_csh_batch_insert;
67: x_return_status := FND_API.G_RET_STS_ERROR;
68: x_msg_count := l_msg_count ;
69: x_msg_data := l_msg_data ;
70: FND_MSG_PUB.count_and_get(
71: p_count => x_msg_count
72: ,p_data => x_msg_data);
73: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
74: ROLLBACK TO trx_csh_batch_insert;
74: ROLLBACK TO trx_csh_batch_insert;
75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
76: x_msg_count := l_msg_count ;
77: x_msg_data := l_msg_data ;
78: FND_MSG_PUB.count_and_get(
79: p_count => x_msg_count
80: ,p_data => x_msg_data);
81: WHEN OTHERS THEN
82: ROLLBACK TO trx_csh_batch_insert;
82: ROLLBACK TO trx_csh_batch_insert;
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
84: x_msg_count := l_msg_count ;
85: x_msg_data := l_msg_data ;
86: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','insert_trx_csh_batch');
87: FND_MSG_PUB.count_and_get(
88: p_count => x_msg_count
89: ,p_data => x_msg_data);
90: END insert_trx_csh_batch;
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
84: x_msg_count := l_msg_count ;
85: x_msg_data := l_msg_data ;
86: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','insert_trx_csh_batch');
87: FND_MSG_PUB.count_and_get(
88: p_count => x_msg_count
89: ,p_data => x_msg_data);
90: END insert_trx_csh_batch;
91:
158: ROLLBACK TO trx_csh_batch_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 trx_csh_batch_insert;
166: ROLLBACK TO trx_csh_batch_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 trx_csh_batch_insert;
174: ROLLBACK TO trx_csh_batch_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_TRX_CSH_BATCH_PUB','insert_trx_csh_batch');
179: FND_MSG_PUB.count_and_get(
180: p_count => x_msg_count
181: ,p_data => x_msg_data);
182: END insert_trx_csh_batch;
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_TRX_CSH_BATCH_PUB','insert_trx_csh_batch');
179: FND_MSG_PUB.count_and_get(
180: p_count => x_msg_count
181: ,p_data => x_msg_data);
182: END insert_trx_csh_batch;
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_TRX_CSH_BATCH_PUB','lock_trx_csh_batch');
221: FND_MSG_PUB.count_and_get(
222: p_count => x_msg_count
223: ,p_data => x_msg_data);
224: END lock_trx_csh_batch;
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_TRX_CSH_BATCH_PUB','lock_trx_csh_batch');
221: FND_MSG_PUB.count_and_get(
222: p_count => x_msg_count
223: ,p_data => x_msg_data);
224: END lock_trx_csh_batch;
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_TRX_CSH_BATCH_PUB','lock_trx_csh_batch');
263: FND_MSG_PUB.count_and_get(
264: p_count => x_msg_count
265: ,p_data => x_msg_data);
266: END lock_trx_csh_batch;
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_TRX_CSH_BATCH_PUB','lock_trx_csh_batch');
263: FND_MSG_PUB.count_and_get(
264: p_count => x_msg_count
265: ,p_data => x_msg_data);
266: END lock_trx_csh_batch;
267:
324: ROLLBACK TO trx_csh_batch_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 trx_csh_batch_update;
332: ROLLBACK TO trx_csh_batch_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 trx_csh_batch_update;
340: ROLLBACK TO trx_csh_batch_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_TRX_CSH_BATCH_PUB','update_trx_csh_batch');
345: FND_MSG_PUB.count_and_get(
346: p_count => x_msg_count
347: ,p_data => x_msg_data);
348: END update_trx_csh_batch;
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_TRX_CSH_BATCH_PUB','update_trx_csh_batch');
345: FND_MSG_PUB.count_and_get(
346: p_count => x_msg_count
347: ,p_data => x_msg_data);
348: END update_trx_csh_batch;
349:
406: ROLLBACK TO trx_csh_batch_update;
407: x_return_status := FND_API.G_RET_STS_ERROR;
408: x_msg_count := l_msg_count ;
409: x_msg_data := l_msg_data ;
410: FND_MSG_PUB.count_and_get(
411: p_count => x_msg_count
412: ,p_data => x_msg_data);
413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
414: ROLLBACK TO trx_csh_batch_update;
414: ROLLBACK TO trx_csh_batch_update;
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: x_msg_count := l_msg_count ;
417: x_msg_data := l_msg_data ;
418: FND_MSG_PUB.count_and_get(
419: p_count => x_msg_count
420: ,p_data => x_msg_data);
421: WHEN OTHERS THEN
422: ROLLBACK TO trx_csh_batch_update;
422: ROLLBACK TO trx_csh_batch_update;
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424: x_msg_count := l_msg_count ;
425: x_msg_data := l_msg_data ;
426: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','update_trx_csh_batch');
427: FND_MSG_PUB.count_and_get(
428: p_count => x_msg_count
429: ,p_data => x_msg_data);
430: END update_trx_csh_batch;
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424: x_msg_count := l_msg_count ;
425: x_msg_data := l_msg_data ;
426: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','update_trx_csh_batch');
427: FND_MSG_PUB.count_and_get(
428: p_count => x_msg_count
429: ,p_data => x_msg_data);
430: END update_trx_csh_batch;
431:
483: ROLLBACK TO trx_csh_batch_delete_rec;
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: x_msg_count := l_msg_count ;
486: x_msg_data := l_msg_data ;
487: FND_MSG_PUB.count_and_get(
488: p_count => x_msg_count
489: ,p_data => x_msg_data);
490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
491: ROLLBACK TO trx_csh_batch_delete_rec;
491: ROLLBACK TO trx_csh_batch_delete_rec;
492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
493: x_msg_count := l_msg_count ;
494: x_msg_data := l_msg_data ;
495: FND_MSG_PUB.count_and_get(
496: p_count => x_msg_count
497: ,p_data => x_msg_data);
498: WHEN OTHERS THEN
499: ROLLBACK TO trx_csh_batch_delete_rec;
499: ROLLBACK TO trx_csh_batch_delete_rec;
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
501: x_msg_count := l_msg_count ;
502: x_msg_data := l_msg_data ;
503: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','delete_trx_csh_batch');
504: FND_MSG_PUB.count_and_get(
505: p_count => x_msg_count
506: ,p_data => x_msg_data);
507: END delete_trx_csh_batch;
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
501: x_msg_count := l_msg_count ;
502: x_msg_data := l_msg_data ;
503: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','delete_trx_csh_batch');
504: FND_MSG_PUB.count_and_get(
505: p_count => x_msg_count
506: ,p_data => x_msg_data);
507: END delete_trx_csh_batch;
508:
571: ROLLBACK TO trx_csh_batch_delete_tbl;
572: x_return_status := FND_API.G_RET_STS_ERROR;
573: x_msg_count := l_msg_count ;
574: x_msg_data := l_msg_data ;
575: FND_MSG_PUB.count_and_get(
576: p_count => x_msg_count
577: ,p_data => x_msg_data);
578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
579: ROLLBACK TO trx_csh_batch_delete_tbl;
579: ROLLBACK TO trx_csh_batch_delete_tbl;
580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
581: x_msg_count := l_msg_count ;
582: x_msg_data := l_msg_data ;
583: FND_MSG_PUB.count_and_get(
584: p_count => x_msg_count
585: ,p_data => x_msg_data);
586: WHEN OTHERS THEN
587: ROLLBACK TO trx_csh_batch_delete_tbl;
587: ROLLBACK TO trx_csh_batch_delete_tbl;
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: x_msg_count := l_msg_count ;
590: x_msg_data := l_msg_data ;
591: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','delete_trx_csh_batch');
592: FND_MSG_PUB.count_and_get(
593: p_count => x_msg_count
594: ,p_data => x_msg_data);
595: END delete_trx_csh_batch;
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: x_msg_count := l_msg_count ;
590: x_msg_data := l_msg_data ;
591: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','delete_trx_csh_batch');
592: FND_MSG_PUB.count_and_get(
593: p_count => x_msg_count
594: ,p_data => x_msg_data);
595: END delete_trx_csh_batch;
596:
649: ROLLBACK TO trx_csh_batch_validate;
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: x_msg_count := l_msg_count ;
652: x_msg_data := l_msg_data ;
653: FND_MSG_PUB.count_and_get(
654: p_count => x_msg_count
655: ,p_data => x_msg_data);
656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
657: ROLLBACK TO trx_csh_batch_validate;
657: ROLLBACK TO trx_csh_batch_validate;
658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
659: x_msg_count := l_msg_count ;
660: x_msg_data := l_msg_data ;
661: FND_MSG_PUB.count_and_get(
662: p_count => x_msg_count
663: ,p_data => x_msg_data);
664: WHEN OTHERS THEN
665: ROLLBACK TO trx_csh_batch_validate;
665: ROLLBACK TO trx_csh_batch_validate;
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
667: x_msg_count := l_msg_count ;
668: x_msg_data := l_msg_data ;
669: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','validate_trx_csh_batch');
670: FND_MSG_PUB.count_and_get(
671: p_count => x_msg_count
672: ,p_data => x_msg_data);
673: END validate_trx_csh_batch;
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
667: x_msg_count := l_msg_count ;
668: x_msg_data := l_msg_data ;
669: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','validate_trx_csh_batch');
670: FND_MSG_PUB.count_and_get(
671: p_count => x_msg_count
672: ,p_data => x_msg_data);
673: END validate_trx_csh_batch;
674:
726: ROLLBACK TO trx_csh_batch_validate;
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: x_msg_count := l_msg_count ;
729: x_msg_data := l_msg_data ;
730: FND_MSG_PUB.count_and_get(
731: p_count => x_msg_count
732: ,p_data => x_msg_data);
733: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
734: ROLLBACK TO trx_csh_batch_validate;
734: ROLLBACK TO trx_csh_batch_validate;
735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
736: x_msg_count := l_msg_count ;
737: x_msg_data := l_msg_data ;
738: FND_MSG_PUB.count_and_get(
739: p_count => x_msg_count
740: ,p_data => x_msg_data);
741: WHEN OTHERS THEN
742: ROLLBACK TO trx_csh_batch_validate;
742: ROLLBACK TO trx_csh_batch_validate;
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
744: x_msg_count := l_msg_count ;
745: x_msg_data := l_msg_data ;
746: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','validate_trx_csh_batch');
747: FND_MSG_PUB.count_and_get(
748: p_count => x_msg_count
749: ,p_data => x_msg_data);
750: END validate_trx_csh_batch;
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
744: x_msg_count := l_msg_count ;
745: x_msg_data := l_msg_data ;
746: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','validate_trx_csh_batch');
747: FND_MSG_PUB.count_and_get(
748: p_count => x_msg_count
749: ,p_data => x_msg_data);
750: END validate_trx_csh_batch;
751:
831:
832: WHEN FND_API.G_EXC_ERROR THEN
833: ROLLBACK TO handle_batch_receipt;
834: x_return_status := FND_API.G_RET_STS_ERROR;
835: FND_MSG_PUB.count_and_get(
836: p_count => x_msg_count
837: ,p_data => x_msg_data);
838:
839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
838:
839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
840: ROLLBACK TO handle_batch_receipt;
841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
842: FND_MSG_PUB.count_and_get(
843: p_count => x_msg_count
844: ,p_data => x_msg_data);
845:
846: WHEN OTHERS THEN
845:
846: WHEN OTHERS THEN
847: ROLLBACK TO handle_batch_receipt;
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
849: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','handle_batch_receipt');
850: FND_MSG_PUB.count_and_get(
851: p_count => x_msg_count
852: ,p_data => x_msg_data);
853:
846: WHEN OTHERS THEN
847: ROLLBACK TO handle_batch_receipt;
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
849: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRX_CSH_BATCH_PUB','handle_batch_receipt');
850: FND_MSG_PUB.count_and_get(
851: p_count => x_msg_count
852: ,p_data => x_msg_data);
853:
854: END handle_batch_receipt;