71: ROLLBACK TO cash_flow_level_insert;
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_level_insert;
79: ROLLBACK TO cash_flow_level_insert;
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_level_insert;
87: ROLLBACK TO cash_flow_level_insert;
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_LEVELS_PUB','insert_cash_flow_level');
92: FND_MSG_PUB.count_and_get(
93: p_count => x_msg_count
94: ,p_data => x_msg_data);
95: END insert_cash_flow_level;
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_LEVELS_PUB','insert_cash_flow_level');
92: FND_MSG_PUB.count_and_get(
93: p_count => x_msg_count
94: ,p_data => x_msg_data);
95: END insert_cash_flow_level;
96:
159: ROLLBACK TO cash_flow_level_insert;
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_level_insert;
167: ROLLBACK TO cash_flow_level_insert;
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_level_insert;
175: ROLLBACK TO cash_flow_level_insert;
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_LEVELS_PUB','insert_cash_flow_level');
180: FND_MSG_PUB.count_and_get(
181: p_count => x_msg_count
182: ,p_data => x_msg_data);
183: END insert_cash_flow_level;
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_LEVELS_PUB','insert_cash_flow_level');
180: FND_MSG_PUB.count_and_get(
181: p_count => x_msg_count
182: ,p_data => x_msg_data);
183: END insert_cash_flow_level;
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_LEVELS_PUB','lock_cash_flow_level');
222: FND_MSG_PUB.count_and_get(
223: p_count => x_msg_count
224: ,p_data => x_msg_data);
225: END lock_cash_flow_level;
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_LEVELS_PUB','lock_cash_flow_level');
222: FND_MSG_PUB.count_and_get(
223: p_count => x_msg_count
224: ,p_data => x_msg_data);
225: END lock_cash_flow_level;
226:
251:
252: EXCEPTION
253:
254: WHEN FND_API.G_EXC_ERROR THEN
255: FND_MSG_PUB.count_and_get(
256: p_count => x_msg_count
257: ,p_data => x_msg_data);
258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
259: FND_MSG_PUB.count_and_get(
255: FND_MSG_PUB.count_and_get(
256: p_count => x_msg_count
257: ,p_data => x_msg_data);
258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
259: FND_MSG_PUB.count_and_get(
260: p_count => x_msg_count
261: ,p_data => x_msg_data);
262: WHEN OTHERS THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260: p_count => x_msg_count
261: ,p_data => x_msg_data);
262: WHEN OTHERS THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','lock_cash_flow_level');
265: FND_MSG_PUB.count_and_get(
266: p_count => x_msg_count
267: ,p_data => x_msg_data);
268: END lock_cash_flow_level;
261: ,p_data => x_msg_data);
262: WHEN OTHERS THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','lock_cash_flow_level');
265: FND_MSG_PUB.count_and_get(
266: p_count => x_msg_count
267: ,p_data => x_msg_data);
268: END lock_cash_flow_level;
269:
336: ROLLBACK TO cash_flow_level_update;
337: x_return_status := FND_API.G_RET_STS_ERROR;
338: x_msg_count := l_msg_count ;
339: x_msg_data := l_msg_data ;
340: FND_MSG_PUB.count_and_get(
341: p_count => x_msg_count
342: ,p_data => x_msg_data);
343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
344: ROLLBACK TO cash_flow_level_update;
344: ROLLBACK TO cash_flow_level_update;
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
346: x_msg_count := l_msg_count ;
347: x_msg_data := l_msg_data ;
348: FND_MSG_PUB.count_and_get(
349: p_count => x_msg_count
350: ,p_data => x_msg_data);
351: WHEN OTHERS THEN
352: ROLLBACK TO cash_flow_level_update;
352: ROLLBACK TO cash_flow_level_update;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: x_msg_count := l_msg_count ;
355: x_msg_data := l_msg_data ;
356: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','update_cash_flow_level');
357: FND_MSG_PUB.count_and_get(
358: p_count => x_msg_count
359: ,p_data => x_msg_data);
360: END update_cash_flow_level;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: x_msg_count := l_msg_count ;
355: x_msg_data := l_msg_data ;
356: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','update_cash_flow_level');
357: FND_MSG_PUB.count_and_get(
358: p_count => x_msg_count
359: ,p_data => x_msg_data);
360: END update_cash_flow_level;
361:
425: ROLLBACK TO cash_flow_level_update;
426: x_return_status := FND_API.G_RET_STS_ERROR;
427: x_msg_count := l_msg_count ;
428: x_msg_data := l_msg_data ;
429: FND_MSG_PUB.count_and_get(
430: p_count => x_msg_count
431: ,p_data => x_msg_data);
432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
433: ROLLBACK TO cash_flow_level_update;
433: ROLLBACK TO cash_flow_level_update;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: x_msg_count := l_msg_count ;
436: x_msg_data := l_msg_data ;
437: FND_MSG_PUB.count_and_get(
438: p_count => x_msg_count
439: ,p_data => x_msg_data);
440: WHEN OTHERS THEN
441: ROLLBACK TO cash_flow_level_update;
441: ROLLBACK TO cash_flow_level_update;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: x_msg_count := l_msg_count ;
444: x_msg_data := l_msg_data ;
445: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','update_cash_flow_level');
446: FND_MSG_PUB.count_and_get(
447: p_count => x_msg_count
448: ,p_data => x_msg_data);
449: END update_cash_flow_level;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: x_msg_count := l_msg_count ;
444: x_msg_data := l_msg_data ;
445: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','update_cash_flow_level');
446: FND_MSG_PUB.count_and_get(
447: p_count => x_msg_count
448: ,p_data => x_msg_data);
449: END update_cash_flow_level;
450:
511: ROLLBACK TO cash_flow_level_delete;
512: x_return_status := FND_API.G_RET_STS_ERROR;
513: x_msg_count := l_msg_count ;
514: x_msg_data := l_msg_data ;
515: FND_MSG_PUB.count_and_get(
516: p_count => x_msg_count
517: ,p_data => x_msg_data);
518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
519: ROLLBACK TO cash_flow_level_delete;
519: ROLLBACK TO cash_flow_level_delete;
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521: x_msg_count := l_msg_count ;
522: x_msg_data := l_msg_data ;
523: FND_MSG_PUB.count_and_get(
524: p_count => x_msg_count
525: ,p_data => x_msg_data);
526: WHEN OTHERS THEN
527: ROLLBACK TO cash_flow_level_delete;
527: ROLLBACK TO cash_flow_level_delete;
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: x_msg_count := l_msg_count ;
530: x_msg_data := l_msg_data ;
531: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','delete_cash_flow_level');
532: FND_MSG_PUB.count_and_get(
533: p_count => x_msg_count
534: ,p_data => x_msg_data);
535: END delete_cash_flow_level;
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: x_msg_count := l_msg_count ;
530: x_msg_data := l_msg_data ;
531: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','delete_cash_flow_level');
532: FND_MSG_PUB.count_and_get(
533: p_count => x_msg_count
534: ,p_data => x_msg_data);
535: END delete_cash_flow_level;
536:
596: ROLLBACK TO cash_flow_level_delete;
597: x_return_status := FND_API.G_RET_STS_ERROR;
598: x_msg_count := l_msg_count ;
599: x_msg_data := l_msg_data ;
600: FND_MSG_PUB.count_and_get(
601: p_count => x_msg_count
602: ,p_data => x_msg_data);
603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
604: ROLLBACK TO cash_flow_level_delete;
604: ROLLBACK TO cash_flow_level_delete;
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
606: x_msg_count := l_msg_count ;
607: x_msg_data := l_msg_data ;
608: FND_MSG_PUB.count_and_get(
609: p_count => x_msg_count
610: ,p_data => x_msg_data);
611: WHEN OTHERS THEN
612: ROLLBACK TO cash_flow_level_delete;
612: ROLLBACK TO cash_flow_level_delete;
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
614: x_msg_count := l_msg_count ;
615: x_msg_data := l_msg_data ;
616: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','delete_cash_flow_level');
617: FND_MSG_PUB.count_and_get(
618: p_count => x_msg_count
619: ,p_data => x_msg_data);
620: END delete_cash_flow_level;
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
614: x_msg_count := l_msg_count ;
615: x_msg_data := l_msg_data ;
616: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','delete_cash_flow_level');
617: FND_MSG_PUB.count_and_get(
618: p_count => x_msg_count
619: ,p_data => x_msg_data);
620: END delete_cash_flow_level;
621:
688: ROLLBACK TO cash_flow_level_validate;
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: x_msg_count := l_msg_count ;
691: x_msg_data := l_msg_data ;
692: FND_MSG_PUB.count_and_get(
693: p_count => x_msg_count
694: ,p_data => x_msg_data);
695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
696: ROLLBACK TO cash_flow_level_validate;
696: ROLLBACK TO cash_flow_level_validate;
697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
698: x_msg_count := l_msg_count ;
699: x_msg_data := l_msg_data ;
700: FND_MSG_PUB.count_and_get(
701: p_count => x_msg_count
702: ,p_data => x_msg_data);
703: WHEN OTHERS THEN
704: ROLLBACK TO cash_flow_level_validate;
704: ROLLBACK TO cash_flow_level_validate;
705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
706: x_msg_count := l_msg_count ;
707: x_msg_data := l_msg_data ;
708: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','validate_cash_flow_level');
709: FND_MSG_PUB.count_and_get(
710: p_count => x_msg_count
711: ,p_data => x_msg_data);
712: END validate_cash_flow_level;
705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
706: x_msg_count := l_msg_count ;
707: x_msg_data := l_msg_data ;
708: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','validate_cash_flow_level');
709: FND_MSG_PUB.count_and_get(
710: p_count => x_msg_count
711: ,p_data => x_msg_data);
712: END validate_cash_flow_level;
713:
774: ROLLBACK TO cash_flow_level_validate;
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: x_msg_count := l_msg_count ;
777: x_msg_data := l_msg_data ;
778: FND_MSG_PUB.count_and_get(
779: p_count => x_msg_count
780: ,p_data => x_msg_data);
781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
782: ROLLBACK TO cash_flow_level_validate;
782: ROLLBACK TO cash_flow_level_validate;
783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
784: x_msg_count := l_msg_count ;
785: x_msg_data := l_msg_data ;
786: FND_MSG_PUB.count_and_get(
787: p_count => x_msg_count
788: ,p_data => x_msg_data);
789: WHEN OTHERS THEN
790: ROLLBACK TO cash_flow_level_validate;
790: ROLLBACK TO cash_flow_level_validate;
791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
792: x_msg_count := l_msg_count ;
793: x_msg_data := l_msg_data ;
794: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','validate_cash_flow_level');
795: FND_MSG_PUB.count_and_get(
796: p_count => x_msg_count
797: ,p_data => x_msg_data);
798: END validate_cash_flow_level;
791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
792: x_msg_count := l_msg_count ;
793: x_msg_data := l_msg_data ;
794: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','validate_cash_flow_level');
795: FND_MSG_PUB.count_and_get(
796: p_count => x_msg_count
797: ,p_data => x_msg_data);
798: END validate_cash_flow_level;
799: