DBA Data[Home] [Help]

APPS.OKL_PROCESS_ACC_GROUP_PUB dependencies on FND_MSG_PUB

Line 83: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 90: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 95: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','create_acc_group');

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);

Line 97: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 181: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 188: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 193: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','create_acc_ccid');

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);

Line 195: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 301: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 308: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 313: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','create_acc_ccid');

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);

Line 315: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 407: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 414: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 419: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','update_acc_ccid');

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);

Line 421: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 500: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 507: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 512: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','update_acc_ccid');

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);

Line 514: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 629: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 636: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 641: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','update_acc_ccid');

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);

Line 643: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 750: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 757: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 762: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','delete_acc_ccid');

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);

Line 764: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 886: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 893: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 898: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','delete_acc_ccid');

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);

Line 900: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1008: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 1015: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 1020: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','create_acc_bal');

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);

Line 1022: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1149: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 1156: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 1161: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','create_acc_bal');

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);

Line 1163: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1267: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 1274: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 1279: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','update_acc_bal');

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);

Line 1281: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1407: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 1414: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 1419: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','update_acc_bal');

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);

Line 1421: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1524: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 1531: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 1536: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','delete_acc_bal');

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);

Line 1538: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;

Line 1660: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 1667: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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

Line 1672: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_ACC_GROUP_PUB','delete_acc_bal');

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);

Line 1674: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

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;