DBA Data[Home] [Help]

APPS.OKL_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_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_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_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_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_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_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_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_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_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_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_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_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 507: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

503: WHEN FND_API.G_EXC_ERROR THEN
504: ROLLBACK TO validate_acc_group;
505: x_return_status := FND_API.G_RET_STS_ERROR;
506:
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 FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

510:
511: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
512: ROLLBACK TO validate_acc_group;
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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:
518: WHEN OTHERS THEN

Line 519: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','validate_acc_group');

515: ,p_count => x_msg_count
516: ,p_data => x_msg_data);
517:
518: WHEN OTHERS THEN
519: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','validate_acc_group');
520: -- store SQL error message on message stack for caller
521: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
522: ,p_count => x_msg_count
523: ,p_data => x_msg_data);

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

517:
518: WHEN OTHERS THEN
519: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','validate_acc_group');
520: -- store SQL error message on message stack for caller
521: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
522: ,p_count => x_msg_count
523: ,p_data => x_msg_data);
524: -- notify caller of an UNEXPECTED error
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

569: WHEN FND_API.G_EXC_ERROR THEN
570: ROLLBACK TO lock_acc_ccid;
571: x_return_status := FND_API.G_RET_STS_ERROR;
572:
573: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
574: ,p_count => x_msg_count
575: ,p_data => x_msg_data);
576:
577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

576:
577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
578: ROLLBACK TO lock_acc_ccid;
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
580: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
581: ,p_count => x_msg_count
582: ,p_data => x_msg_data);
583:
584: WHEN OTHERS THEN

Line 585: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','lock_acc_ccid');

581: ,p_count => x_msg_count
582: ,p_data => x_msg_data);
583:
584: WHEN OTHERS THEN
585: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','lock_acc_ccid');
586: -- store SQL error message on message stack for caller
587: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
588: ,p_count => x_msg_count
589: ,p_data => x_msg_data);

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

583:
584: WHEN OTHERS THEN
585: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','lock_acc_ccid');
586: -- store SQL error message on message stack for caller
587: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
588: ,p_count => x_msg_count
589: ,p_data => x_msg_data);
590: -- notify caller of an UNEXPECTED error
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

657: WHEN FND_API.G_EXC_ERROR THEN
658: ROLLBACK TO lock_acc_ccid;
659: x_return_status := FND_API.G_RET_STS_ERROR;
660:
661: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
662: ,p_count => x_msg_count
663: ,p_data => x_msg_data);
664:
665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

664:
665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
666: ROLLBACK TO lock_acc_ccid;
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
668: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
669: ,p_count => x_msg_count
670: ,p_data => x_msg_data);
671:
672: WHEN OTHERS THEN

Line 673: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAM_TYPE_PUB','lock_acc_ccid');

669: ,p_count => x_msg_count
670: ,p_data => x_msg_data);
671:
672: WHEN OTHERS THEN
673: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAM_TYPE_PUB','lock_acc_ccid');
674: -- store SQL error message on message stack for caller
675: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
676: ,p_count => x_msg_count
677: ,p_data => x_msg_data);

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

671:
672: WHEN OTHERS THEN
673: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAM_TYPE_PUB','lock_acc_ccid');
674: -- store SQL error message on message stack for caller
675: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
676: ,p_count => x_msg_count
677: ,p_data => x_msg_data);
678: -- notify caller of an UNEXPECTED error
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

748: WHEN FND_API.G_EXC_ERROR THEN
749: ROLLBACK TO update_acc_ccid;
750: x_return_status := FND_API.G_RET_STS_ERROR;
751:
752: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
753: ,p_count => x_msg_count
754: ,p_data => x_msg_data);
755:
756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

755:
756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
757: ROLLBACK TO update_acc_ccid;
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
759: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
760: ,p_count => x_msg_count
761: ,p_data => x_msg_data);
762:
763: WHEN OTHERS THEN

Line 764: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','update_acc_ccid');

760: ,p_count => x_msg_count
761: ,p_data => x_msg_data);
762:
763: WHEN OTHERS THEN
764: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','update_acc_ccid');
765: -- store SQL error message on message stack for caller
766: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
767: ,p_count => x_msg_count
768: ,p_data => x_msg_data);

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

762:
763: WHEN OTHERS THEN
764: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','update_acc_ccid');
765: -- store SQL error message on message stack for caller
766: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
767: ,p_count => x_msg_count
768: ,p_data => x_msg_data);
769: -- notify caller of an UNEXPECTED error
770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

877: WHEN FND_API.G_EXC_ERROR THEN
878: ROLLBACK TO update_acc_ccid;
879: x_return_status := FND_API.G_RET_STS_ERROR;
880:
881: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
882: ,p_count => x_msg_count
883: ,p_data => x_msg_data);
884:
885: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

884:
885: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
886: ROLLBACK TO update_acc_ccid;
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
888: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
889: ,p_count => x_msg_count
890: ,p_data => x_msg_data);
891:
892: WHEN OTHERS THEN

Line 893: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','update_acc_ccid');

889: ,p_count => x_msg_count
890: ,p_data => x_msg_data);
891:
892: WHEN OTHERS THEN
893: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','update_acc_ccid');
894: -- store SQL error message on message stack for caller
895: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
896: ,p_count => x_msg_count
897: ,p_data => x_msg_data);

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

891:
892: WHEN OTHERS THEN
893: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','update_acc_ccid');
894: -- store SQL error message on message stack for caller
895: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
896: ,p_count => x_msg_count
897: ,p_data => x_msg_data);
898: -- notify caller of an UNEXPECTED error
899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

998: WHEN FND_API.G_EXC_ERROR THEN
999: ROLLBACK TO delete_acc_ccid;
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001:
1002: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1003: ,p_count => x_msg_count
1004: ,p_data => x_msg_data);
1005:
1006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1005:
1006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1007: ROLLBACK TO delete_acc_ccid;
1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1009: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1010: ,p_count => x_msg_count
1011: ,p_data => x_msg_data);
1012:
1013: WHEN OTHERS THEN

Line 1014: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','delete_acc_ccid');

1010: ,p_count => x_msg_count
1011: ,p_data => x_msg_data);
1012:
1013: WHEN OTHERS THEN
1014: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','delete_acc_ccid');
1015: -- store SQL error message on message stack for caller
1016: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1017: ,p_count => x_msg_count
1018: ,p_data => x_msg_data);

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

1012:
1013: WHEN OTHERS THEN
1014: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','delete_acc_ccid');
1015: -- store SQL error message on message stack for caller
1016: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1017: ,p_count => x_msg_count
1018: ,p_data => x_msg_data);
1019: -- notify caller of an UNEXPECTED error
1020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1134: WHEN FND_API.G_EXC_ERROR THEN
1135: ROLLBACK TO delete_acc_ccid;
1136: x_return_status := FND_API.G_RET_STS_ERROR;
1137:
1138: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1139: ,p_count => x_msg_count
1140: ,p_data => x_msg_data);
1141:
1142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1141:
1142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1143: ROLLBACK TO delete_acc_ccid;
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1145: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1146: ,p_count => x_msg_count
1147: ,p_data => x_msg_data);
1148:
1149: WHEN OTHERS THEN

Line 1150: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','delete_acc_ccid');

1146: ,p_count => x_msg_count
1147: ,p_data => x_msg_data);
1148:
1149: WHEN OTHERS THEN
1150: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','delete_acc_ccid');
1151: -- store SQL error message on message stack for caller
1152: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1153: ,p_count => x_msg_count
1154: ,p_data => x_msg_data);

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

1148:
1149: WHEN OTHERS THEN
1150: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','delete_acc_ccid');
1151: -- store SQL error message on message stack for caller
1152: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1153: ,p_count => x_msg_count
1154: ,p_data => x_msg_data);
1155: -- notify caller of an UNEXPECTED error
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1251: WHEN FND_API.G_EXC_ERROR THEN
1252: ROLLBACK TO validate_acc_ccid;
1253: x_return_status := FND_API.G_RET_STS_ERROR;
1254:
1255: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1256: ,p_count => x_msg_count
1257: ,p_data => x_msg_data);
1258:
1259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1258:
1259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1260: ROLLBACK TO validate_acc_ccid;
1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1262: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1263: ,p_count => x_msg_count
1264: ,p_data => x_msg_data);
1265:
1266: WHEN OTHERS THEN

Line 1267: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','validate_acc_ccid');

1263: ,p_count => x_msg_count
1264: ,p_data => x_msg_data);
1265:
1266: WHEN OTHERS THEN
1267: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','validate_acc_ccid');
1268: -- store SQL error message on message stack for caller
1269: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1270: ,p_count => x_msg_count
1271: ,p_data => x_msg_data);

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

1265:
1266: WHEN OTHERS THEN
1267: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','validate_acc_ccid');
1268: -- store SQL error message on message stack for caller
1269: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1270: ,p_count => x_msg_count
1271: ,p_data => x_msg_data);
1272: -- notify caller of an UNEXPECTED error
1273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1385: WHEN FND_API.G_EXC_ERROR THEN
1386: ROLLBACK TO validate_acc_ccid;
1387: x_return_status := FND_API.G_RET_STS_ERROR;
1388:
1389: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1390: ,p_count => x_msg_count
1391: ,p_data => x_msg_data);
1392:
1393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1392:
1393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1394: ROLLBACK TO validate_acc_ccid;
1395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1396: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1397: ,p_count => x_msg_count
1398: ,p_data => x_msg_data);
1399:
1400: WHEN OTHERS THEN

Line 1401: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','validate_acc_ccid');

1397: ,p_count => x_msg_count
1398: ,p_data => x_msg_data);
1399:
1400: WHEN OTHERS THEN
1401: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','validate_acc_ccid');
1402: -- store SQL error message on message stack for caller
1403: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1404: ,p_count => x_msg_count
1405: ,p_data => x_msg_data);

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

1399:
1400: WHEN OTHERS THEN
1401: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','validate_acc_ccid');
1402: -- store SQL error message on message stack for caller
1403: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1404: ,p_count => x_msg_count
1405: ,p_data => x_msg_data);
1406: -- notify caller of an UNEXPECTED error
1407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1505: WHEN FND_API.G_EXC_ERROR THEN
1506: ROLLBACK TO create_acc_bal;
1507: x_return_status := FND_API.G_RET_STS_ERROR;
1508:
1509: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1510: ,p_count => x_msg_count
1511: ,p_data => x_msg_data);
1512:
1513: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1512:
1513: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1514: ROLLBACK TO create_acc_bal;
1515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1516: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1517: ,p_count => x_msg_count
1518: ,p_data => x_msg_data);
1519:
1520: WHEN OTHERS THEN

Line 1521: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','create_acc_bal');

1517: ,p_count => x_msg_count
1518: ,p_data => x_msg_data);
1519:
1520: WHEN OTHERS THEN
1521: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','create_acc_bal');
1522: -- store SQL error message on message stack for caller
1523: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1524: ,p_count => x_msg_count
1525: ,p_data => x_msg_data);

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

1519:
1520: WHEN OTHERS THEN
1521: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','create_acc_bal');
1522: -- store SQL error message on message stack for caller
1523: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1524: ,p_count => x_msg_count
1525: ,p_data => x_msg_data);
1526: -- notify caller of an UNEXPECTED error
1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1646: WHEN FND_API.G_EXC_ERROR THEN
1647: ROLLBACK TO create_acc_bal;
1648: x_return_status := FND_API.G_RET_STS_ERROR;
1649:
1650: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1651: ,p_count => x_msg_count
1652: ,p_data => x_msg_data);
1653:
1654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1653:
1654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1655: ROLLBACK TO create_acc_bal;
1656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1657: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1658: ,p_count => x_msg_count
1659: ,p_data => x_msg_data);
1660:
1661: WHEN OTHERS THEN

Line 1662: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','create_acc_bal');

1658: ,p_count => x_msg_count
1659: ,p_data => x_msg_data);
1660:
1661: WHEN OTHERS THEN
1662: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','create_acc_bal');
1663: -- store SQL error message on message stack for caller
1664: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1665: ,p_count => x_msg_count
1666: ,p_data => x_msg_data);

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

1660:
1661: WHEN OTHERS THEN
1662: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','create_acc_bal');
1663: -- store SQL error message on message stack for caller
1664: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1665: ,p_count => x_msg_count
1666: ,p_data => x_msg_data);
1667: -- notify caller of an UNEXPECTED error
1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1722: WHEN FND_API.G_EXC_ERROR THEN
1723: ROLLBACK TO lock_acc_bal;
1724: x_return_status := FND_API.G_RET_STS_ERROR;
1725:
1726: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1727: ,p_count => x_msg_count
1728: ,p_data => x_msg_data);
1729:
1730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1729:
1730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1731: ROLLBACK TO lock_acc_bal;
1732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1733: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1734: ,p_count => x_msg_count
1735: ,p_data => x_msg_data);
1736:
1737: WHEN OTHERS THEN

Line 1738: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','lock_acc_bal');

1734: ,p_count => x_msg_count
1735: ,p_data => x_msg_data);
1736:
1737: WHEN OTHERS THEN
1738: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','lock_acc_bal');
1739: -- store SQL error message on message stack for caller
1740: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1741: ,p_count => x_msg_count
1742: ,p_data => x_msg_data);

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

1736:
1737: WHEN OTHERS THEN
1738: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','lock_acc_bal');
1739: -- store SQL error message on message stack for caller
1740: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1741: ,p_count => x_msg_count
1742: ,p_data => x_msg_data);
1743: -- notify caller of an UNEXPECTED error
1744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1826: WHEN FND_API.G_EXC_ERROR THEN
1827: ROLLBACK TO lock_acc_bal;
1828: x_return_status := FND_API.G_RET_STS_ERROR;
1829:
1830: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1831: ,p_count => x_msg_count
1832: ,p_data => x_msg_data);
1833:
1834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1833:
1834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1835: ROLLBACK TO lock_acc_bal;
1836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1837: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1838: ,p_count => x_msg_count
1839: ,p_data => x_msg_data);
1840:
1841: WHEN OTHERS THEN

Line 1842: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','lock_acc_bal');

1838: ,p_count => x_msg_count
1839: ,p_data => x_msg_data);
1840:
1841: WHEN OTHERS THEN
1842: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','lock_acc_bal');
1843: -- store SQL error message on message stack for caller
1844: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1845: ,p_count => x_msg_count
1846: ,p_data => x_msg_data);

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

1840:
1841: WHEN OTHERS THEN
1842: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','lock_acc_bal');
1843: -- store SQL error message on message stack for caller
1844: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1845: ,p_count => x_msg_count
1846: ,p_data => x_msg_data);
1847: -- notify caller of an UNEXPECTED error
1848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1941: WHEN FND_API.G_EXC_ERROR THEN
1942: ROLLBACK TO update_acc_bal;
1943: x_return_status := FND_API.G_RET_STS_ERROR;
1944:
1945: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1946: ,p_count => x_msg_count
1947: ,p_data => x_msg_data);
1948:
1949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1948:
1949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1950: ROLLBACK TO update_acc_bal;
1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1952: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1953: ,p_count => x_msg_count
1954: ,p_data => x_msg_data);
1955:
1956: WHEN OTHERS THEN

Line 1957: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','update_acc_bal');

1953: ,p_count => x_msg_count
1954: ,p_data => x_msg_data);
1955:
1956: WHEN OTHERS THEN
1957: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','update_acc_bal');
1958: -- store SQL error message on message stack for caller
1959: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1960: ,p_count => x_msg_count
1961: ,p_data => x_msg_data);

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

1955:
1956: WHEN OTHERS THEN
1957: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','update_acc_bal');
1958: -- store SQL error message on message stack for caller
1959: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1960: ,p_count => x_msg_count
1961: ,p_data => x_msg_data);
1962: -- notify caller of an UNEXPECTED error
1963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2081: WHEN FND_API.G_EXC_ERROR THEN
2082: ROLLBACK TO update_acc_bal;
2083: x_return_status := FND_API.G_RET_STS_ERROR;
2084:
2085: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2086: ,p_count => x_msg_count
2087: ,p_data => x_msg_data);
2088:
2089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2088:
2089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2090: ROLLBACK TO update_acc_bal;
2091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2092: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2093: ,p_count => x_msg_count
2094: ,p_data => x_msg_data);
2095:
2096: WHEN OTHERS THEN

Line 2097: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','update_acc_bal');

2093: ,p_count => x_msg_count
2094: ,p_data => x_msg_data);
2095:
2096: WHEN OTHERS THEN
2097: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','update_acc_bal');
2098: -- store SQL error message on message stack for caller
2099: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2100: ,p_count => x_msg_count
2101: ,p_data => x_msg_data);

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

2095:
2096: WHEN OTHERS THEN
2097: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','update_acc_bal');
2098: -- store SQL error message on message stack for caller
2099: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2100: ,p_count => x_msg_count
2101: ,p_data => x_msg_data);
2102: -- notify caller of an UNEXPECTED error
2103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2198: WHEN FND_API.G_EXC_ERROR THEN
2199: ROLLBACK TO delete_acc_bal;
2200: x_return_status := FND_API.G_RET_STS_ERROR;
2201:
2202: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2203: ,p_count => x_msg_count
2204: ,p_data => x_msg_data);
2205:
2206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2205:
2206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2207: ROLLBACK TO delete_acc_bal;
2208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2209: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2210: ,p_count => x_msg_count
2211: ,p_data => x_msg_data);
2212:
2213: WHEN OTHERS THEN

Line 2214: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','delete_acc_bal');

2210: ,p_count => x_msg_count
2211: ,p_data => x_msg_data);
2212:
2213: WHEN OTHERS THEN
2214: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','delete_acc_bal');
2215: -- store SQL error message on message stack for caller
2216: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2217: ,p_count => x_msg_count
2218: ,p_data => x_msg_data);

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

2212:
2213: WHEN OTHERS THEN
2214: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','delete_acc_bal');
2215: -- store SQL error message on message stack for caller
2216: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2217: ,p_count => x_msg_count
2218: ,p_data => x_msg_data);
2219: -- notify caller of an UNEXPECTED error
2220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2334: WHEN FND_API.G_EXC_ERROR THEN
2335: ROLLBACK TO delete_acc_bal;
2336: x_return_status := FND_API.G_RET_STS_ERROR;
2337:
2338: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2339: ,p_count => x_msg_count
2340: ,p_data => x_msg_data);
2341:
2342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2341:
2342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2343: ROLLBACK TO delete_acc_bal;
2344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2345: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2346: ,p_count => x_msg_count
2347: ,p_data => x_msg_data);
2348:
2349: WHEN OTHERS THEN

Line 2350: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','delete_acc_bal');

2346: ,p_count => x_msg_count
2347: ,p_data => x_msg_data);
2348:
2349: WHEN OTHERS THEN
2350: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','delete_acc_bal');
2351: -- store SQL error message on message stack for caller
2352: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2353: ,p_count => x_msg_count
2354: ,p_data => x_msg_data);

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

2348:
2349: WHEN OTHERS THEN
2350: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','delete_acc_bal');
2351: -- store SQL error message on message stack for caller
2352: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2353: ,p_count => x_msg_count
2354: ,p_data => x_msg_data);
2355: -- notify caller of an UNEXPECTED error
2356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2447: WHEN FND_API.G_EXC_ERROR THEN
2448: ROLLBACK TO validate_acc_bal;
2449: x_return_status := FND_API.G_RET_STS_ERROR;
2450:
2451: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2452: ,p_count => x_msg_count
2453: ,p_data => x_msg_data);
2454:
2455: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2454:
2455: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2456: ROLLBACK TO validate_acc_bal;
2457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2458: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2459: ,p_count => x_msg_count
2460: ,p_data => x_msg_data);
2461:
2462: WHEN OTHERS THEN

Line 2463: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','validate_acc_bal');

2459: ,p_count => x_msg_count
2460: ,p_data => x_msg_data);
2461:
2462: WHEN OTHERS THEN
2463: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','validate_acc_bal');
2464: -- store SQL error message on message stack for caller
2465: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2466: ,p_count => x_msg_count
2467: ,p_data => x_msg_data);

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

2461:
2462: WHEN OTHERS THEN
2463: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','validate_acc_bal');
2464: -- store SQL error message on message stack for caller
2465: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2466: ,p_count => x_msg_count
2467: ,p_data => x_msg_data);
2468: -- notify caller of an UNEXPECTED error
2469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2582: WHEN FND_API.G_EXC_ERROR THEN
2583: ROLLBACK TO validate_acc_bal;
2584: x_return_status := FND_API.G_RET_STS_ERROR;
2585:
2586: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2587: ,p_count => x_msg_count
2588: ,p_data => x_msg_data);
2589:
2590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2589:
2590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2591: ROLLBACK TO validate_acc_bal;
2592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2593: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2594: ,p_count => x_msg_count
2595: ,p_data => x_msg_data);
2596:
2597: WHEN OTHERS THEN

Line 2598: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','validate_acc_bal');

2594: ,p_count => x_msg_count
2595: ,p_data => x_msg_data);
2596:
2597: WHEN OTHERS THEN
2598: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','validate_acc_bal');
2599: -- store SQL error message on message stack for caller
2600: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2601: ,p_count => x_msg_count
2602: ,p_data => x_msg_data);

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

2596:
2597: WHEN OTHERS THEN
2598: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','validate_acc_bal');
2599: -- store SQL error message on message stack for caller
2600: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2601: ,p_count => x_msg_count
2602: ,p_data => x_msg_data);
2603: -- notify caller of an UNEXPECTED error
2604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;