79: WHEN FND_API.G_EXC_ERROR THEN
80: ROLLBACK TO create_acc_group;
81: x_return_status := FND_API.G_RET_STS_ERROR;
82:
83: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
84: ,p_count => x_msg_count
85: ,p_data => x_msg_data);
86:
87: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
86:
87: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
88: ROLLBACK TO create_acc_group;
89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
90: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
91: ,p_count => x_msg_count
92: ,p_data => x_msg_data);
93:
94: WHEN OTHERS THEN
91: ,p_count => x_msg_count
92: ,p_data => x_msg_data);
93:
94: WHEN OTHERS THEN
95: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','create_acc_group');
96: -- store SQL error message on message stack for caller
97: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
98: ,p_count => x_msg_count
99: ,p_data => x_msg_data);
93:
94: WHEN OTHERS THEN
95: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','create_acc_group');
96: -- store SQL error message on message stack for caller
97: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
98: ,p_count => x_msg_count
99: ,p_data => x_msg_data);
100: -- notify caller of an UNEXPECTED error
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
177: WHEN FND_API.G_EXC_ERROR THEN
178: ROLLBACK TO create_acc_ccid;
179: x_return_status := FND_API.G_RET_STS_ERROR;
180:
181: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
182: ,p_count => x_msg_count
183: ,p_data => x_msg_data);
184:
185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
184:
185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
186: ROLLBACK TO create_acc_ccid;
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
189: ,p_count => x_msg_count
190: ,p_data => x_msg_data);
191:
192: WHEN OTHERS THEN
189: ,p_count => x_msg_count
190: ,p_data => x_msg_data);
191:
192: WHEN OTHERS THEN
193: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','create_acc_ccid');
194: -- store SQL error message on message stack for caller
195: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
196: ,p_count => x_msg_count
197: ,p_data => x_msg_data);
191:
192: WHEN OTHERS THEN
193: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','create_acc_ccid');
194: -- store SQL error message on message stack for caller
195: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
196: ,p_count => x_msg_count
197: ,p_data => x_msg_data);
198: -- notify caller of an UNEXPECTED error
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
297: WHEN FND_API.G_EXC_ERROR THEN
298: ROLLBACK TO create_acc_ccid;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300:
301: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
302: ,p_count => x_msg_count
303: ,p_data => x_msg_data);
304:
305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
304:
305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
306: ROLLBACK TO create_acc_ccid;
307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
308: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
309: ,p_count => x_msg_count
310: ,p_data => x_msg_data);
311:
312: WHEN OTHERS THEN
309: ,p_count => x_msg_count
310: ,p_data => x_msg_data);
311:
312: WHEN OTHERS THEN
313: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','create_acc_ccid');
314: -- store SQL error message on message stack for caller
315: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
316: ,p_count => x_msg_count
317: ,p_data => x_msg_data);
311:
312: WHEN OTHERS THEN
313: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','create_acc_ccid');
314: -- store SQL error message on message stack for caller
315: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
316: ,p_count => x_msg_count
317: ,p_data => x_msg_data);
318: -- notify caller of an UNEXPECTED error
319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
403: WHEN FND_API.G_EXC_ERROR THEN
404: ROLLBACK TO update_acc_group;
405: x_return_status := FND_API.G_RET_STS_ERROR;
406:
407: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
408: ,p_count => x_msg_count
409: ,p_data => x_msg_data);
410:
411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
410:
411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
412: ROLLBACK TO update_acc_group;
413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
414: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
415: ,p_count => x_msg_count
416: ,p_data => x_msg_data);
417:
418: WHEN OTHERS THEN
415: ,p_count => x_msg_count
416: ,p_data => x_msg_data);
417:
418: WHEN OTHERS THEN
419: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','update_acc_ccid');
420: -- store SQL error message on message stack for caller
421: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
422: ,p_count => x_msg_count
423: ,p_data => x_msg_data);
417:
418: WHEN OTHERS THEN
419: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','update_acc_ccid');
420: -- store SQL error message on message stack for caller
421: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
422: ,p_count => x_msg_count
423: ,p_data => x_msg_data);
424: -- notify caller of an UNEXPECTED error
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496: WHEN FND_API.G_EXC_ERROR THEN
497: ROLLBACK TO update_acc_ccid;
498: x_return_status := FND_API.G_RET_STS_ERROR;
499:
500: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
501: ,p_count => x_msg_count
502: ,p_data => x_msg_data);
503:
504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
503:
504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
505: ROLLBACK TO update_acc_ccid;
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
508: ,p_count => x_msg_count
509: ,p_data => x_msg_data);
510:
511: WHEN OTHERS THEN
508: ,p_count => x_msg_count
509: ,p_data => x_msg_data);
510:
511: WHEN OTHERS THEN
512: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','update_acc_ccid');
513: -- store SQL error message on message stack for caller
514: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
515: ,p_count => x_msg_count
516: ,p_data => x_msg_data);
510:
511: WHEN OTHERS THEN
512: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','update_acc_ccid');
513: -- store SQL error message on message stack for caller
514: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
515: ,p_count => x_msg_count
516: ,p_data => x_msg_data);
517: -- notify caller of an UNEXPECTED error
518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
625: WHEN FND_API.G_EXC_ERROR THEN
626: ROLLBACK TO update_acc_ccid;
627: x_return_status := FND_API.G_RET_STS_ERROR;
628:
629: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
630: ,p_count => x_msg_count
631: ,p_data => x_msg_data);
632:
633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
632:
633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
634: ROLLBACK TO update_acc_ccid;
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
637: ,p_count => x_msg_count
638: ,p_data => x_msg_data);
639:
640: WHEN OTHERS THEN
637: ,p_count => x_msg_count
638: ,p_data => x_msg_data);
639:
640: WHEN OTHERS THEN
641: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','update_acc_ccid');
642: -- store SQL error message on message stack for caller
643: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
644: ,p_count => x_msg_count
645: ,p_data => x_msg_data);
639:
640: WHEN OTHERS THEN
641: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','update_acc_ccid');
642: -- store SQL error message on message stack for caller
643: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
644: ,p_count => x_msg_count
645: ,p_data => x_msg_data);
646: -- notify caller of an UNEXPECTED error
647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746: WHEN FND_API.G_EXC_ERROR THEN
747: ROLLBACK TO delete_acc_ccid;
748: x_return_status := FND_API.G_RET_STS_ERROR;
749:
750: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
751: ,p_count => x_msg_count
752: ,p_data => x_msg_data);
753:
754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
753:
754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
755: ROLLBACK TO delete_acc_ccid;
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
758: ,p_count => x_msg_count
759: ,p_data => x_msg_data);
760:
761: WHEN OTHERS THEN
758: ,p_count => x_msg_count
759: ,p_data => x_msg_data);
760:
761: WHEN OTHERS THEN
762: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','delete_acc_ccid');
763: -- store SQL error message on message stack for caller
764: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
765: ,p_count => x_msg_count
766: ,p_data => x_msg_data);
760:
761: WHEN OTHERS THEN
762: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','delete_acc_ccid');
763: -- store SQL error message on message stack for caller
764: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
765: ,p_count => x_msg_count
766: ,p_data => x_msg_data);
767: -- notify caller of an UNEXPECTED error
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
882: WHEN FND_API.G_EXC_ERROR THEN
883: ROLLBACK TO delete_acc_ccid;
884: x_return_status := FND_API.G_RET_STS_ERROR;
885:
886: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
887: ,p_count => x_msg_count
888: ,p_data => x_msg_data);
889:
890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
889:
890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
891: ROLLBACK TO delete_acc_ccid;
892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
893: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
894: ,p_count => x_msg_count
895: ,p_data => x_msg_data);
896:
897: WHEN OTHERS THEN
894: ,p_count => x_msg_count
895: ,p_data => x_msg_data);
896:
897: WHEN OTHERS THEN
898: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','delete_acc_ccid');
899: -- store SQL error message on message stack for caller
900: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
901: ,p_count => x_msg_count
902: ,p_data => x_msg_data);
896:
897: WHEN OTHERS THEN
898: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','delete_acc_ccid');
899: -- store SQL error message on message stack for caller
900: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
901: ,p_count => x_msg_count
902: ,p_data => x_msg_data);
903: -- notify caller of an UNEXPECTED error
904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1004: WHEN FND_API.G_EXC_ERROR THEN
1005: ROLLBACK TO create_acc_bal;
1006: x_return_status := FND_API.G_RET_STS_ERROR;
1007:
1008: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1009: ,p_count => x_msg_count
1010: ,p_data => x_msg_data);
1011:
1012: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1011:
1012: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1013: ROLLBACK TO create_acc_bal;
1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1015: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1016: ,p_count => x_msg_count
1017: ,p_data => x_msg_data);
1018:
1019: WHEN OTHERS THEN
1016: ,p_count => x_msg_count
1017: ,p_data => x_msg_data);
1018:
1019: WHEN OTHERS THEN
1020: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','create_acc_bal');
1021: -- store SQL error message on message stack for caller
1022: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1023: ,p_count => x_msg_count
1024: ,p_data => x_msg_data);
1018:
1019: WHEN OTHERS THEN
1020: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','create_acc_bal');
1021: -- store SQL error message on message stack for caller
1022: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1023: ,p_count => x_msg_count
1024: ,p_data => x_msg_data);
1025: -- notify caller of an UNEXPECTED error
1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1145: WHEN FND_API.G_EXC_ERROR THEN
1146: ROLLBACK TO create_acc_bal;
1147: x_return_status := FND_API.G_RET_STS_ERROR;
1148:
1149: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1150: ,p_count => x_msg_count
1151: ,p_data => x_msg_data);
1152:
1153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1152:
1153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1154: ROLLBACK TO create_acc_bal;
1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1156: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1157: ,p_count => x_msg_count
1158: ,p_data => x_msg_data);
1159:
1160: WHEN OTHERS THEN
1157: ,p_count => x_msg_count
1158: ,p_data => x_msg_data);
1159:
1160: WHEN OTHERS THEN
1161: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','create_acc_bal');
1162: -- store SQL error message on message stack for caller
1163: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1164: ,p_count => x_msg_count
1165: ,p_data => x_msg_data);
1159:
1160: WHEN OTHERS THEN
1161: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','create_acc_bal');
1162: -- store SQL error message on message stack for caller
1163: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1164: ,p_count => x_msg_count
1165: ,p_data => x_msg_data);
1166: -- notify caller of an UNEXPECTED error
1167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1263: WHEN FND_API.G_EXC_ERROR THEN
1264: ROLLBACK TO update_acc_bal;
1265: x_return_status := FND_API.G_RET_STS_ERROR;
1266:
1267: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1268: ,p_count => x_msg_count
1269: ,p_data => x_msg_data);
1270:
1271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1270:
1271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1272: ROLLBACK TO update_acc_bal;
1273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1274: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1275: ,p_count => x_msg_count
1276: ,p_data => x_msg_data);
1277:
1278: WHEN OTHERS THEN
1275: ,p_count => x_msg_count
1276: ,p_data => x_msg_data);
1277:
1278: WHEN OTHERS THEN
1279: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','update_acc_bal');
1280: -- store SQL error message on message stack for caller
1281: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1282: ,p_count => x_msg_count
1283: ,p_data => x_msg_data);
1277:
1278: WHEN OTHERS THEN
1279: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','update_acc_bal');
1280: -- store SQL error message on message stack for caller
1281: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1282: ,p_count => x_msg_count
1283: ,p_data => x_msg_data);
1284: -- notify caller of an UNEXPECTED error
1285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1403: WHEN FND_API.G_EXC_ERROR THEN
1404: ROLLBACK TO update_acc_bal;
1405: x_return_status := FND_API.G_RET_STS_ERROR;
1406:
1407: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1408: ,p_count => x_msg_count
1409: ,p_data => x_msg_data);
1410:
1411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1410:
1411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1412: ROLLBACK TO update_acc_bal;
1413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1414: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1415: ,p_count => x_msg_count
1416: ,p_data => x_msg_data);
1417:
1418: WHEN OTHERS THEN
1415: ,p_count => x_msg_count
1416: ,p_data => x_msg_data);
1417:
1418: WHEN OTHERS THEN
1419: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','update_acc_bal');
1420: -- store SQL error message on message stack for caller
1421: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1422: ,p_count => x_msg_count
1423: ,p_data => x_msg_data);
1417:
1418: WHEN OTHERS THEN
1419: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','update_acc_bal');
1420: -- store SQL error message on message stack for caller
1421: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1422: ,p_count => x_msg_count
1423: ,p_data => x_msg_data);
1424: -- notify caller of an UNEXPECTED error
1425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1520: WHEN FND_API.G_EXC_ERROR THEN
1521: ROLLBACK TO delete_acc_bal;
1522: x_return_status := FND_API.G_RET_STS_ERROR;
1523:
1524: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1525: ,p_count => x_msg_count
1526: ,p_data => x_msg_data);
1527:
1528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1527:
1528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1529: ROLLBACK TO delete_acc_bal;
1530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1531: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1532: ,p_count => x_msg_count
1533: ,p_data => x_msg_data);
1534:
1535: WHEN OTHERS THEN
1532: ,p_count => x_msg_count
1533: ,p_data => x_msg_data);
1534:
1535: WHEN OTHERS THEN
1536: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','delete_acc_bal');
1537: -- store SQL error message on message stack for caller
1538: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1539: ,p_count => x_msg_count
1540: ,p_data => x_msg_data);
1534:
1535: WHEN OTHERS THEN
1536: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','delete_acc_bal');
1537: -- store SQL error message on message stack for caller
1538: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1539: ,p_count => x_msg_count
1540: ,p_data => x_msg_data);
1541: -- notify caller of an UNEXPECTED error
1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1656: WHEN FND_API.G_EXC_ERROR THEN
1657: ROLLBACK TO delete_acc_bal;
1658: x_return_status := FND_API.G_RET_STS_ERROR;
1659:
1660: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1661: ,p_count => x_msg_count
1662: ,p_data => x_msg_data);
1663:
1664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1663:
1664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1665: ROLLBACK TO delete_acc_bal;
1666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1667: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1668: ,p_count => x_msg_count
1669: ,p_data => x_msg_data);
1670:
1671: WHEN OTHERS THEN
1668: ,p_count => x_msg_count
1669: ,p_data => x_msg_data);
1670:
1671: WHEN OTHERS THEN
1672: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','delete_acc_bal');
1673: -- store SQL error message on message stack for caller
1674: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1675: ,p_count => x_msg_count
1676: ,p_data => x_msg_data);
1670:
1671: WHEN OTHERS THEN
1672: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','delete_acc_bal');
1673: -- store SQL error message on message stack for caller
1674: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1675: ,p_count => x_msg_count
1676: ,p_data => x_msg_data);
1677: -- notify caller of an UNEXPECTED error
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;