71: ROLLBACK TO cash_flow_obj_ins;
72: x_return_status := FND_API.G_RET_STS_ERROR;
73: x_msg_count := l_msg_count ;
74: x_msg_data := l_msg_data ;
75: FND_MSG_PUB.count_and_get(
76: p_count => x_msg_count
77: ,p_data => x_msg_data);
78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
79: ROLLBACK TO cash_flow_obj_ins;
79: ROLLBACK TO cash_flow_obj_ins;
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
81: x_msg_count := l_msg_count ;
82: x_msg_data := l_msg_data ;
83: FND_MSG_PUB.count_and_get(
84: p_count => x_msg_count
85: ,p_data => x_msg_data);
86: WHEN OTHERS THEN
87: ROLLBACK TO cash_flow_obj_ins;
87: ROLLBACK TO cash_flow_obj_ins;
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89: x_msg_count := l_msg_count ;
90: x_msg_data := l_msg_data ;
91: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_OBJECTS_PUB','insert_cash_flow_object');
92: FND_MSG_PUB.count_and_get(
93: p_count => x_msg_count
94: ,p_data => x_msg_data);
95: END insert_cash_flow_object;
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89: x_msg_count := l_msg_count ;
90: x_msg_data := l_msg_data ;
91: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_OBJECTS_PUB','insert_cash_flow_object');
92: FND_MSG_PUB.count_and_get(
93: p_count => x_msg_count
94: ,p_data => x_msg_data);
95: END insert_cash_flow_object;
96:
159: ROLLBACK TO cash_flow_obj_ins;
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: x_msg_count := l_msg_count ;
162: x_msg_data := l_msg_data ;
163: FND_MSG_PUB.count_and_get(
164: p_count => x_msg_count
165: ,p_data => x_msg_data);
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167: ROLLBACK TO cash_flow_obj_ins;
167: ROLLBACK TO cash_flow_obj_ins;
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
169: x_msg_count := l_msg_count ;
170: x_msg_data := l_msg_data ;
171: FND_MSG_PUB.count_and_get(
172: p_count => x_msg_count
173: ,p_data => x_msg_data);
174: WHEN OTHERS THEN
175: ROLLBACK TO cash_flow_obj_ins;
175: ROLLBACK TO cash_flow_obj_ins;
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
177: x_msg_count := l_msg_count ;
178: x_msg_data := l_msg_data ;
179: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_OBJECTS_PUB','insert_cash_flow_object');
180: FND_MSG_PUB.count_and_get(
181: p_count => x_msg_count
182: ,p_data => x_msg_data);
183: END insert_cash_flow_object;
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
177: x_msg_count := l_msg_count ;
178: x_msg_data := l_msg_data ;
179: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_OBJECTS_PUB','insert_cash_flow_object');
180: FND_MSG_PUB.count_and_get(
181: p_count => x_msg_count
182: ,p_data => x_msg_data);
183: END insert_cash_flow_object;
184:
208:
209: EXCEPTION
210:
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_CASH_FLOW_OBJECTS_PUB','lock_cash_flow_object');
222: FND_MSG_PUB.count_and_get(
223: p_count => x_msg_count
224: ,p_data => x_msg_data);
225: END lock_cash_flow_object;
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_CASH_FLOW_OBJECTS_PUB','lock_cash_flow_object');
222: FND_MSG_PUB.count_and_get(
223: p_count => x_msg_count
224: ,p_data => x_msg_data);
225: END lock_cash_flow_object;
226:
250:
251: EXCEPTION
252:
253: WHEN FND_API.G_EXC_ERROR THEN
254: FND_MSG_PUB.count_and_get(
255: p_count => x_msg_count
256: ,p_data => x_msg_data);
257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
258: FND_MSG_PUB.count_and_get(
254: FND_MSG_PUB.count_and_get(
255: p_count => x_msg_count
256: ,p_data => x_msg_data);
257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
258: FND_MSG_PUB.count_and_get(
259: p_count => x_msg_count
260: ,p_data => x_msg_data);
261: WHEN OTHERS THEN
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259: p_count => x_msg_count
260: ,p_data => x_msg_data);
261: WHEN OTHERS THEN
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
263: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_OBJECTS_PUB','lock_cash_flow_object');
264: FND_MSG_PUB.count_and_get(
265: p_count => x_msg_count
266: ,p_data => x_msg_data);
267: END lock_cash_flow_object;
260: ,p_data => x_msg_data);
261: WHEN OTHERS THEN
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
263: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_OBJECTS_PUB','lock_cash_flow_object');
264: FND_MSG_PUB.count_and_get(
265: p_count => x_msg_count
266: ,p_data => x_msg_data);
267: END lock_cash_flow_object;
268:
335: ROLLBACK TO cash_flow_obj_upd;
336: x_return_status := FND_API.G_RET_STS_ERROR;
337: x_msg_count := l_msg_count ;
338: x_msg_data := l_msg_data ;
339: FND_MSG_PUB.count_and_get(
340: p_count => x_msg_count
341: ,p_data => x_msg_data);
342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
343: ROLLBACK TO cash_flow_obj_upd;
343: ROLLBACK TO cash_flow_obj_upd;
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
345: x_msg_count := l_msg_count ;
346: x_msg_data := l_msg_data ;
347: FND_MSG_PUB.count_and_get(
348: p_count => x_msg_count
349: ,p_data => x_msg_data);
350: WHEN OTHERS THEN
351: ROLLBACK TO cash_flow_obj_upd;
351: ROLLBACK TO cash_flow_obj_upd;
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
353: x_msg_count := l_msg_count ;
354: x_msg_data := l_msg_data ;
355: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_OBJECTS_PUB','update_cash_flow_object');
356: FND_MSG_PUB.count_and_get(
357: p_count => x_msg_count
358: ,p_data => x_msg_data);
359: END update_cash_flow_object;
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
353: x_msg_count := l_msg_count ;
354: x_msg_data := l_msg_data ;
355: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_OBJECTS_PUB','update_cash_flow_object');
356: FND_MSG_PUB.count_and_get(
357: p_count => x_msg_count
358: ,p_data => x_msg_data);
359: END update_cash_flow_object;
360:
424: ROLLBACK TO cash_flow_obj_upd;
425: x_return_status := FND_API.G_RET_STS_ERROR;
426: x_msg_count := l_msg_count ;
427: x_msg_data := l_msg_data ;
428: FND_MSG_PUB.count_and_get(
429: p_count => x_msg_count
430: ,p_data => x_msg_data);
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432: ROLLBACK TO cash_flow_obj_upd;
432: ROLLBACK TO cash_flow_obj_upd;
433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
434: x_msg_count := l_msg_count ;
435: x_msg_data := l_msg_data ;
436: FND_MSG_PUB.count_and_get(
437: p_count => x_msg_count
438: ,p_data => x_msg_data);
439: WHEN OTHERS THEN
440: ROLLBACK TO cash_flow_obj_upd;
440: ROLLBACK TO cash_flow_obj_upd;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
442: x_msg_count := l_msg_count ;
443: x_msg_data := l_msg_data ;
444: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_OBJECTS_PUB','update_cash_flow_object');
445: FND_MSG_PUB.count_and_get(
446: p_count => x_msg_count
447: ,p_data => x_msg_data);
448: END update_cash_flow_object;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
442: x_msg_count := l_msg_count ;
443: x_msg_data := l_msg_data ;
444: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_OBJECTS_PUB','update_cash_flow_object');
445: FND_MSG_PUB.count_and_get(
446: p_count => x_msg_count
447: ,p_data => x_msg_data);
448: END update_cash_flow_object;
449:
510: ROLLBACK TO cash_flow_obj_del;
511: x_return_status := FND_API.G_RET_STS_ERROR;
512: x_msg_count := l_msg_count ;
513: x_msg_data := l_msg_data ;
514: FND_MSG_PUB.count_and_get(
515: p_count => x_msg_count
516: ,p_data => x_msg_data);
517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
518: ROLLBACK TO cash_flow_obj_del;
518: ROLLBACK TO cash_flow_obj_del;
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520: x_msg_count := l_msg_count ;
521: x_msg_data := l_msg_data ;
522: FND_MSG_PUB.count_and_get(
523: p_count => x_msg_count
524: ,p_data => x_msg_data);
525: WHEN OTHERS THEN
526: ROLLBACK TO cash_flow_obj_del;
526: ROLLBACK TO cash_flow_obj_del;
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
528: x_msg_count := l_msg_count ;
529: x_msg_data := l_msg_data ;
530: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_OBJECTS_PUB','delete_cash_flow_object');
531: FND_MSG_PUB.count_and_get(
532: p_count => x_msg_count
533: ,p_data => x_msg_data);
534: END delete_cash_flow_object;
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
528: x_msg_count := l_msg_count ;
529: x_msg_data := l_msg_data ;
530: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_OBJECTS_PUB','delete_cash_flow_object');
531: FND_MSG_PUB.count_and_get(
532: p_count => x_msg_count
533: ,p_data => x_msg_data);
534: END delete_cash_flow_object;
535:
595: ROLLBACK TO cash_flow_obj_del;
596: x_return_status := FND_API.G_RET_STS_ERROR;
597: x_msg_count := l_msg_count ;
598: x_msg_data := l_msg_data ;
599: FND_MSG_PUB.count_and_get(
600: p_count => x_msg_count
601: ,p_data => x_msg_data);
602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
603: ROLLBACK TO cash_flow_obj_del;
603: ROLLBACK TO cash_flow_obj_del;
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
605: x_msg_count := l_msg_count ;
606: x_msg_data := l_msg_data ;
607: FND_MSG_PUB.count_and_get(
608: p_count => x_msg_count
609: ,p_data => x_msg_data);
610: WHEN OTHERS THEN
611: ROLLBACK TO cash_flow_obj_del;
611: ROLLBACK TO cash_flow_obj_del;
612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
613: x_msg_count := l_msg_count ;
614: x_msg_data := l_msg_data ;
615: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_OBJECTS_PUB','delete_cash_flow_object');
616: FND_MSG_PUB.count_and_get(
617: p_count => x_msg_count
618: ,p_data => x_msg_data);
619: END delete_cash_flow_object;
612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
613: x_msg_count := l_msg_count ;
614: x_msg_data := l_msg_data ;
615: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_OBJECTS_PUB','delete_cash_flow_object');
616: FND_MSG_PUB.count_and_get(
617: p_count => x_msg_count
618: ,p_data => x_msg_data);
619: END delete_cash_flow_object;
620:
687: ROLLBACK TO cash_flow_obj_val;
688: x_return_status := FND_API.G_RET_STS_ERROR;
689: x_msg_count := l_msg_count ;
690: x_msg_data := l_msg_data ;
691: FND_MSG_PUB.count_and_get(
692: p_count => x_msg_count
693: ,p_data => x_msg_data);
694: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
695: ROLLBACK TO cash_flow_obj_val;
695: ROLLBACK TO cash_flow_obj_val;
696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
697: x_msg_count := l_msg_count ;
698: x_msg_data := l_msg_data ;
699: FND_MSG_PUB.count_and_get(
700: p_count => x_msg_count
701: ,p_data => x_msg_data);
702: WHEN OTHERS THEN
703: ROLLBACK TO cash_flow_obj_val;
703: ROLLBACK TO cash_flow_obj_val;
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: x_msg_count := l_msg_count ;
706: x_msg_data := l_msg_data ;
707: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_OBJECTS_PUB','validate_cash_flow_object');
708: FND_MSG_PUB.count_and_get(
709: p_count => x_msg_count
710: ,p_data => x_msg_data);
711: END validate_cash_flow_object;
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: x_msg_count := l_msg_count ;
706: x_msg_data := l_msg_data ;
707: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_OBJECTS_PUB','validate_cash_flow_object');
708: FND_MSG_PUB.count_and_get(
709: p_count => x_msg_count
710: ,p_data => x_msg_data);
711: END validate_cash_flow_object;
712:
773: ROLLBACK TO cash_flow_obj_val;
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 cash_flow_obj_val;
781: ROLLBACK TO cash_flow_obj_val;
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 cash_flow_obj_val;
789: ROLLBACK TO cash_flow_obj_val;
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_CASH_FLOW_OBJECTS_PUB','validate_cash_flow_object');
794: FND_MSG_PUB.count_and_get(
795: p_count => x_msg_count
796: ,p_data => x_msg_data);
797: END validate_cash_flow_object;
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_CASH_FLOW_OBJECTS_PUB','validate_cash_flow_object');
794: FND_MSG_PUB.count_and_get(
795: p_count => x_msg_count
796: ,p_data => x_msg_data);
797: END validate_cash_flow_object;
798: