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_PROCESS_ACC_GROUP_PUB dependencies on OKC_API

Line 6: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2: /* $Header: OKLPAGGB.pls 115.4 2002/12/18 12:09:38 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_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 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_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 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_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 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_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 434: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

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

521:
522:
523:
524: PROCEDURE update_acc_ccid(p_api_version IN NUMBER
525: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
526: ,x_return_status OUT NOCOPY VARCHAR2
527: ,x_msg_count OUT NOCOPY NUMBER
528: ,x_msg_data OUT NOCOPY VARCHAR2
529: ,p_agcv_tbl IN agcv_tbl_type

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

657: PROCEDURE delete_acc_ccid(
658:
659: p_api_version IN NUMBER
660:
661: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
662:
663: ,x_return_status OUT NOCOPY VARCHAR2
664:
665: ,x_msg_count OUT NOCOPY NUMBER

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

774: PROCEDURE delete_acc_ccid(
775:
776: p_api_version IN NUMBER
777:
778: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
779:
780: ,x_return_status OUT NOCOPY VARCHAR2
781:
782: ,x_msg_count OUT NOCOPY NUMBER

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

913: PROCEDURE create_acc_bal(
914:
915: p_api_version IN NUMBER
916:
917: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
918:
919: ,x_return_status OUT NOCOPY VARCHAR2
920:
921: ,x_msg_count OUT NOCOPY NUMBER

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

1032: PROCEDURE create_acc_bal(
1033:
1034: p_api_version IN NUMBER
1035:
1036: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1037:
1038: ,x_return_status OUT NOCOPY VARCHAR2
1039:
1040: ,x_msg_count OUT NOCOPY NUMBER

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

1176: PROCEDURE update_acc_bal(
1177:
1178: p_api_version IN NUMBER
1179:
1180: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1181:
1182: ,x_return_status OUT NOCOPY VARCHAR2
1183:
1184: ,x_msg_count OUT NOCOPY NUMBER

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

1291: PROCEDURE update_acc_bal(
1292:
1293: p_api_version IN NUMBER
1294:
1295: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1296:
1297: ,x_return_status OUT NOCOPY VARCHAR2
1298:
1299: ,x_msg_count OUT NOCOPY NUMBER

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

1435: PROCEDURE delete_acc_bal(
1436:
1437: p_api_version IN NUMBER
1438:
1439: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1440:
1441: ,x_return_status OUT NOCOPY VARCHAR2
1442:
1443: ,x_msg_count OUT NOCOPY NUMBER

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

1548: PROCEDURE delete_acc_bal(
1549:
1550: p_api_version IN NUMBER
1551:
1552: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1553:
1554: ,x_return_status OUT NOCOPY VARCHAR2
1555:
1556: ,x_msg_count OUT NOCOPY NUMBER

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