eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_ACC_GROUP_PUB dependencies on OKC_API

Line 6: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2: /* $Header: OKLPAGCB.pls 115.5 2002/12/18 12:09:28 kjinger noship $ */
3:
4:
5: PROCEDURE create_acc_group(p_api_version IN NUMBER
6: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
7: ,x_return_status OUT NOCOPY VARCHAR2
8: ,x_msg_count OUT NOCOPY NUMBER
9: ,x_msg_data OUT NOCOPY VARCHAR2
10: ,p_agcv_rec IN agcv_rec_type

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 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 109: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

105:
106:
107:
108: PROCEDURE create_acc_ccid(p_api_version IN NUMBER
109: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
110: ,x_return_status OUT NOCOPY VARCHAR2
111: ,x_msg_count OUT NOCOPY NUMBER
112: ,x_msg_data OUT NOCOPY VARCHAR2
113: ,p_agcv_rec IN agcv_rec_type

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 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 206: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

202:
203:
204:
205: PROCEDURE create_acc_ccid(p_api_version IN NUMBER
206: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
207: ,x_return_status OUT NOCOPY VARCHAR2
208: ,x_msg_count OUT NOCOPY NUMBER
209: ,x_msg_data OUT NOCOPY VARCHAR2
210: ,p_agcv_tbl IN agcv_tbl_type

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 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 329: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

325:
326: -- Object type procedure for update
327:
328: PROCEDURE update_acc_group(p_api_version IN NUMBER,
329: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
330: x_return_status OUT NOCOPY VARCHAR2,
331: x_msg_count OUT NOCOPY NUMBER,
332: x_msg_data OUT NOCOPY VARCHAR2,
333: p_agcv_rec IN agcv_rec_type,

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 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 432: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

428:
429:
430:
431: PROCEDURE validate_acc_group(p_api_version IN NUMBER
432: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
433: ,x_return_status OUT NOCOPY VARCHAR2
434: ,x_msg_count OUT NOCOPY NUMBER
435: ,x_msg_data OUT NOCOPY VARCHAR2
436: ,p_agcv_rec IN agcv_rec_type

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 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 533: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

529:
530:
531:
532: PROCEDURE lock_acc_ccid(p_api_version IN NUMBER
533: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
534: ,x_return_status OUT NOCOPY VARCHAR2
535: ,x_msg_count OUT NOCOPY NUMBER
536: ,x_msg_data OUT NOCOPY VARCHAR2
537: ,p_agcv_rec IN agcv_rec_type)

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 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 598: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

594:
595:
596:
597: PROCEDURE lock_acc_ccid(p_api_version IN NUMBER
598: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
599: ,x_return_status OUT NOCOPY VARCHAR2
600: ,x_msg_count OUT NOCOPY NUMBER
601: ,x_msg_data OUT NOCOPY VARCHAR2
602: ,p_agcv_tbl IN agcv_tbl_type) IS

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 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 686: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

682:
683:
684:
685: PROCEDURE update_acc_ccid(p_api_version IN NUMBER
686: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
687: ,x_return_status OUT NOCOPY VARCHAR2
688: ,x_msg_count OUT NOCOPY NUMBER
689: ,x_msg_data OUT NOCOPY VARCHAR2
690: ,p_agcv_rec IN agcv_rec_type

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 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 777: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

773:
774:
775:
776: PROCEDURE update_acc_ccid(p_api_version IN NUMBER
777: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
778: ,x_return_status OUT NOCOPY VARCHAR2
779: ,x_msg_count OUT NOCOPY NUMBER
780: ,x_msg_data OUT NOCOPY VARCHAR2
781: ,p_agcv_tbl IN agcv_tbl_type

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 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 913: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

909: PROCEDURE delete_acc_ccid(
910:
911: p_api_version IN NUMBER
912:
913: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
914:
915: ,x_return_status OUT NOCOPY VARCHAR2
916:
917: ,x_msg_count OUT NOCOPY NUMBER

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 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 1030: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1026: PROCEDURE delete_acc_ccid(
1027:
1028: p_api_version IN NUMBER
1029:
1030: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1031:
1032: ,x_return_status OUT NOCOPY VARCHAR2
1033:
1034: ,x_msg_count OUT NOCOPY NUMBER

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 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 1168: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1164: PROCEDURE validate_acc_ccid(
1165:
1166: p_api_version IN NUMBER
1167:
1168: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1169:
1170: ,x_return_status OUT NOCOPY VARCHAR2
1171:
1172: ,x_msg_count OUT NOCOPY NUMBER

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 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 1283: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1279: PROCEDURE validate_acc_ccid(
1280:
1281: p_api_version IN NUMBER,
1282:
1283: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1284:
1285: x_return_status OUT NOCOPY VARCHAR2,
1286:
1287: x_msg_count OUT NOCOPY NUMBER,

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 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 1418: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1414: PROCEDURE create_acc_bal(
1415:
1416: p_api_version IN NUMBER
1417:
1418: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1419:
1420: ,x_return_status OUT NOCOPY VARCHAR2
1421:
1422: ,x_msg_count OUT NOCOPY NUMBER

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 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 1537: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1533: PROCEDURE create_acc_bal(
1534:
1535: p_api_version IN NUMBER
1536:
1537: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1538:
1539: ,x_return_status OUT NOCOPY VARCHAR2
1540:
1541: ,x_msg_count OUT NOCOPY NUMBER

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 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 1680: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1676: PROCEDURE lock_acc_bal(
1677:
1678: p_api_version IN NUMBER
1679:
1680: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1681:
1682: ,x_return_status OUT NOCOPY VARCHAR2
1683:
1684: ,x_msg_count OUT NOCOPY NUMBER

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 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 1754: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1750: PROCEDURE lock_acc_bal(
1751:
1752: p_api_version IN NUMBER
1753:
1754: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1755:
1756: ,x_return_status OUT NOCOPY VARCHAR2
1757:
1758: ,x_msg_count OUT NOCOPY NUMBER

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 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 1858: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1854: PROCEDURE update_acc_bal(
1855:
1856: p_api_version IN NUMBER
1857:
1858: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1859:
1860: ,x_return_status OUT NOCOPY VARCHAR2
1861:
1862: ,x_msg_count OUT NOCOPY NUMBER

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 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 1973: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1969: PROCEDURE update_acc_bal(
1970:
1971: p_api_version IN NUMBER
1972:
1973: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1974:
1975: ,x_return_status OUT NOCOPY VARCHAR2
1976:
1977: ,x_msg_count OUT NOCOPY NUMBER

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 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 2117: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2113: PROCEDURE delete_acc_bal(
2114:
2115: p_api_version IN NUMBER
2116:
2117: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2118:
2119: ,x_return_status OUT NOCOPY VARCHAR2
2120:
2121: ,x_msg_count OUT NOCOPY NUMBER

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 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 2230: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2226: PROCEDURE delete_acc_bal(
2227:
2228: p_api_version IN NUMBER
2229:
2230: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2231:
2232: ,x_return_status OUT NOCOPY VARCHAR2
2233:
2234: ,x_msg_count OUT NOCOPY NUMBER

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 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 2366: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2362: PROCEDURE validate_acc_bal(
2363:
2364: p_api_version IN NUMBER
2365:
2366: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2367:
2368: ,x_return_status OUT NOCOPY VARCHAR2
2369:
2370: ,x_msg_count OUT NOCOPY NUMBER

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 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 2479: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2475: PROCEDURE validate_acc_bal(
2476:
2477: p_api_version IN NUMBER
2478:
2479: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2480:
2481: ,x_return_status OUT NOCOPY VARCHAR2
2482:
2483: ,x_msg_count OUT NOCOPY NUMBER

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