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

Line 10: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

6: PROCEDURE create_options(
7:
8: p_api_version IN NUMBER
9:
10: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
11:
12: ,x_return_status OUT NOCOPY VARCHAR2
13:
14: ,x_msg_count OUT NOCOPY NUMBER

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

110: WHEN FND_API.G_EXC_ERROR THEN
111: ROLLBACK TO create_options;
112: x_return_status := FND_API.G_RET_STS_ERROR;
113:
114: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
115: ,p_count => x_msg_count
116: ,p_data => x_msg_data);
117:
118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

117:
118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
119: ROLLBACK TO create_options;
120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
121: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
122: ,p_count => x_msg_count
123: ,p_data => x_msg_data);
124:
125: WHEN OTHERS THEN

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

124:
125: WHEN OTHERS THEN
126: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','create_options');
127: -- store SQL error message on message stack for caller
128: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
129: ,p_count => x_msg_count
130: ,p_data => x_msg_data);
131: -- notify caller of an UNEXPECTED error
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 143: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

139: PROCEDURE create_options(
140:
141: p_api_version IN NUMBER
142:
143: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
144:
145: ,x_return_status OUT NOCOPY VARCHAR2
146:
147: ,x_msg_count OUT NOCOPY NUMBER

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

230: WHEN FND_API.G_EXC_ERROR THEN
231: ROLLBACK TO create_options;
232: x_return_status := FND_API.G_RET_STS_ERROR;
233:
234: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
235: ,p_count => x_msg_count
236: ,p_data => x_msg_data);
237:
238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

237:
238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
239: ROLLBACK TO create_options;
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
242: ,p_count => x_msg_count
243: ,p_data => x_msg_data);
244:
245: WHEN OTHERS THEN

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

244:
245: WHEN OTHERS THEN
246: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','create_options');
247: -- store SQL error message on message stack for caller
248: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
249: ,p_count => x_msg_count
250: ,p_data => x_msg_data);
251: -- notify caller of an UNEXPECTED error
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 262: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

258: PROCEDURE create_options(
259:
260: p_api_version IN NUMBER
261:
262: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
263:
264: ,x_return_status OUT NOCOPY VARCHAR2
265:
266: ,x_msg_count OUT NOCOPY NUMBER

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

371: WHEN FND_API.G_EXC_ERROR THEN
372: ROLLBACK TO create_options;
373: x_return_status := FND_API.G_RET_STS_ERROR;
374:
375: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
376: ,p_count => x_msg_count
377: ,p_data => x_msg_data);
378:
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

378:
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: ROLLBACK TO create_options;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
383: ,p_count => x_msg_count
384: ,p_data => x_msg_data);
385:
386: WHEN OTHERS THEN

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

385:
386: WHEN OTHERS THEN
387: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','create_options');
388: -- store SQL error message on message stack for caller
389: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
390: ,p_count => x_msg_count
391: ,p_data => x_msg_data);
392: -- notify caller of an UNEXPECTED error
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 406: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

402: PROCEDURE update_options(
403:
404: p_api_version IN NUMBER,
405:
406: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
407:
408: x_return_status OUT NOCOPY VARCHAR2,
409:
410: x_msg_count OUT NOCOPY NUMBER,

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

504: WHEN FND_API.G_EXC_ERROR THEN
505: ROLLBACK TO update_options;
506: x_return_status := FND_API.G_RET_STS_ERROR;
507:
508: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
509: ,p_count => x_msg_count
510: ,p_data => x_msg_data);
511:
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

511:
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: ROLLBACK TO update_options;
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
516: ,p_count => x_msg_count
517: ,p_data => x_msg_data);
518:
519: WHEN OTHERS THEN

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

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

Line 536: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

532: PROCEDURE validate_options(
533:
534: p_api_version IN NUMBER
535:
536: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
537:
538: ,x_return_status OUT NOCOPY VARCHAR2
539:
540: ,x_msg_count OUT NOCOPY NUMBER

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

627: WHEN FND_API.G_EXC_ERROR THEN
628: ROLLBACK TO validate_options;
629: x_return_status := FND_API.G_RET_STS_ERROR;
630:
631: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
632: ,p_count => x_msg_count
633: ,p_data => x_msg_data);
634:
635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

634:
635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
636: ROLLBACK TO validate_options;
637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
638: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
639: ,p_count => x_msg_count
640: ,p_data => x_msg_data);
641:
642: WHEN OTHERS THEN

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

641:
642: WHEN OTHERS THEN
643: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','validate_options');
644: -- store SQL error message on message stack for caller
645: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
646: ,p_count => x_msg_count
647: ,p_data => x_msg_data);
648: -- notify caller of an UNEXPECTED error
649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 659: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

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

706: WHEN FND_API.G_EXC_ERROR THEN
707: ROLLBACK TO lock_options;
708: x_return_status := FND_API.G_RET_STS_ERROR;
709:
710: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
711: ,p_count => x_msg_count
712: ,p_data => x_msg_data);
713:
714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

713:
714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
715: ROLLBACK TO lock_options;
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
718: ,p_count => x_msg_count
719: ,p_data => x_msg_data);
720:
721: WHEN OTHERS THEN

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

720:
721: WHEN OTHERS THEN
722: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','lock_options');
723: -- store SQL error message on message stack for caller
724: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
725: ,p_count => x_msg_count
726: ,p_data => x_msg_data);
727: -- notify caller of an UNEXPECTED error
728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 738: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

734: PROCEDURE lock_options(
735:
736: p_api_version IN NUMBER
737:
738: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
739:
740: ,x_return_status OUT NOCOPY VARCHAR2
741:
742: ,x_msg_count OUT NOCOPY NUMBER

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

812: WHEN FND_API.G_EXC_ERROR THEN
813: ROLLBACK TO lock_options;
814: x_return_status := FND_API.G_RET_STS_ERROR;
815:
816: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
817: ,p_count => x_msg_count
818: ,p_data => x_msg_data);
819:
820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

819:
820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
821: ROLLBACK TO lock_options;
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
823: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
824: ,p_count => x_msg_count
825: ,p_data => x_msg_data);
826:
827: WHEN OTHERS THEN

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

826:
827: WHEN OTHERS THEN
828: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAM_TYPE_PUB','lock_options');
829: -- store SQL error message on message stack for caller
830: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
831: ,p_count => x_msg_count
832: ,p_data => x_msg_data);
833: -- notify caller of an UNEXPECTED error
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 844: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

840: PROCEDURE update_options(
841:
842: p_api_version IN NUMBER
843:
844: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
845:
846: ,x_return_status OUT NOCOPY VARCHAR2
847:
848: ,x_msg_count OUT NOCOPY NUMBER

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

927: WHEN FND_API.G_EXC_ERROR THEN
928: ROLLBACK TO update_options;
929: x_return_status := FND_API.G_RET_STS_ERROR;
930:
931: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
932: ,p_count => x_msg_count
933: ,p_data => x_msg_data);
934:
935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

934:
935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
936: ROLLBACK TO update_options;
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
939: ,p_count => x_msg_count
940: ,p_data => x_msg_data);
941:
942: WHEN OTHERS THEN

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

941:
942: WHEN OTHERS THEN
943: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','update_options');
944: -- store SQL error message on message stack for caller
945: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
946: ,p_count => x_msg_count
947: ,p_data => x_msg_data);
948: -- notify caller of an UNEXPECTED error
949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 959: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

955: PROCEDURE update_options(
956:
957: p_api_version IN NUMBER
958:
959: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
960:
961: ,x_return_status OUT NOCOPY VARCHAR2
962:
963: ,x_msg_count OUT NOCOPY NUMBER

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

1067: WHEN FND_API.G_EXC_ERROR THEN
1068: ROLLBACK TO update_options;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070:
1071: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1072: ,p_count => x_msg_count
1073: ,p_data => x_msg_data);
1074:
1075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1074:
1075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1076: ROLLBACK TO update_options;
1077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1078: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1079: ,p_count => x_msg_count
1080: ,p_data => x_msg_data);
1081:
1082: WHEN OTHERS THEN

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

1081:
1082: WHEN OTHERS THEN
1083: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','update_options');
1084: -- store SQL error message on message stack for caller
1085: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1086: ,p_count => x_msg_count
1087: ,p_data => x_msg_data);
1088: -- notify caller of an UNEXPECTED error
1089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1103: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1099: PROCEDURE delete_options(
1100:
1101: p_api_version IN NUMBER
1102:
1103: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1104:
1105: ,x_return_status OUT NOCOPY VARCHAR2
1106:
1107: ,x_msg_count OUT NOCOPY NUMBER

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

1188: WHEN FND_API.G_EXC_ERROR THEN
1189: ROLLBACK TO delete_options;
1190: x_return_status := FND_API.G_RET_STS_ERROR;
1191:
1192: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1193: ,p_count => x_msg_count
1194: ,p_data => x_msg_data);
1195:
1196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1195:
1196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1197: ROLLBACK TO delete_options;
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1199: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1200: ,p_count => x_msg_count
1201: ,p_data => x_msg_data);
1202:
1203: WHEN OTHERS THEN

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

1202:
1203: WHEN OTHERS THEN
1204: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','delete_options');
1205: -- store SQL error message on message stack for caller
1206: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1207: ,p_count => x_msg_count
1208: ,p_data => x_msg_data);
1209: -- notify caller of an UNEXPECTED error
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1220: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1216: PROCEDURE delete_options(
1217:
1218: p_api_version IN NUMBER
1219:
1220: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1221:
1222: ,x_return_status OUT NOCOPY VARCHAR2
1223:
1224: ,x_msg_count OUT NOCOPY NUMBER

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

1324: WHEN FND_API.G_EXC_ERROR THEN
1325: ROLLBACK TO delete_options;
1326: x_return_status := FND_API.G_RET_STS_ERROR;
1327:
1328: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1329: ,p_count => x_msg_count
1330: ,p_data => x_msg_data);
1331:
1332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1331:
1332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1333: ROLLBACK TO delete_options;
1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1335: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1336: ,p_count => x_msg_count
1337: ,p_data => x_msg_data);
1338:
1339: WHEN OTHERS THEN

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

1338:
1339: WHEN OTHERS THEN
1340: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','delete_options');
1341: -- store SQL error message on message stack for caller
1342: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1343: ,p_count => x_msg_count
1344: ,p_data => x_msg_data);
1345: -- notify caller of an UNEXPECTED error
1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1358: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1354: PROCEDURE validate_options(
1355:
1356: p_api_version IN NUMBER
1357:
1358: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1359:
1360: ,x_return_status OUT NOCOPY VARCHAR2
1361:
1362: ,x_msg_count OUT NOCOPY NUMBER

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

1441: WHEN FND_API.G_EXC_ERROR THEN
1442: ROLLBACK TO validate_options;
1443: x_return_status := FND_API.G_RET_STS_ERROR;
1444:
1445: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1446: ,p_count => x_msg_count
1447: ,p_data => x_msg_data);
1448:
1449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1448:
1449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1450: ROLLBACK TO validate_options;
1451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1452: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1453: ,p_count => x_msg_count
1454: ,p_data => x_msg_data);
1455:
1456: WHEN OTHERS THEN

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

1455:
1456: WHEN OTHERS THEN
1457: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','validate_options');
1458: -- store SQL error message on message stack for caller
1459: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1460: ,p_count => x_msg_count
1461: ,p_data => x_msg_data);
1462: -- notify caller of an UNEXPECTED error
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1473: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1469: PROCEDURE validate_options(
1470:
1471: p_api_version IN NUMBER,
1472:
1473: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1474:
1475: x_return_status OUT NOCOPY VARCHAR2,
1476:
1477: x_msg_count OUT NOCOPY NUMBER,

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

1575: WHEN FND_API.G_EXC_ERROR THEN
1576: ROLLBACK TO validate_options;
1577: x_return_status := FND_API.G_RET_STS_ERROR;
1578:
1579: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1580: ,p_count => x_msg_count
1581: ,p_data => x_msg_data);
1582:
1583: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1582:
1583: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1584: ROLLBACK TO validate_options;
1585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1586: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1587: ,p_count => x_msg_count
1588: ,p_data => x_msg_data);
1589:
1590: WHEN OTHERS THEN

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

1589:
1590: WHEN OTHERS THEN
1591: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','validate_options');
1592: -- store SQL error message on message stack for caller
1593: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1594: ,p_count => x_msg_count
1595: ,p_data => x_msg_data);
1596: -- notify caller of an UNEXPECTED error
1597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1608: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1604: PROCEDURE create_option_values(
1605:
1606: p_api_version IN NUMBER
1607:
1608: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1609:
1610: ,x_return_status OUT NOCOPY VARCHAR2
1611:
1612: ,x_msg_count OUT NOCOPY NUMBER

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

1695: WHEN FND_API.G_EXC_ERROR THEN
1696: ROLLBACK TO create_option_values;
1697: x_return_status := FND_API.G_RET_STS_ERROR;
1698:
1699: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1700: ,p_count => x_msg_count
1701: ,p_data => x_msg_data);
1702:
1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1702:
1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1704: ROLLBACK TO create_option_values;
1705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1706: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1707: ,p_count => x_msg_count
1708: ,p_data => x_msg_data);
1709:
1710: WHEN OTHERS THEN

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

1709:
1710: WHEN OTHERS THEN
1711: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','create_option_values');
1712: -- store SQL error message on message stack for caller
1713: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1714: ,p_count => x_msg_count
1715: ,p_data => x_msg_data);
1716: -- notify caller of an UNEXPECTED error
1717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1727: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1723: PROCEDURE create_option_values(
1724:
1725: p_api_version IN NUMBER
1726:
1727: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1728:
1729: ,x_return_status OUT NOCOPY VARCHAR2
1730:
1731: ,x_msg_count OUT NOCOPY NUMBER

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

1836: WHEN FND_API.G_EXC_ERROR THEN
1837: ROLLBACK TO create_option_values;
1838: x_return_status := FND_API.G_RET_STS_ERROR;
1839:
1840: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1841: ,p_count => x_msg_count
1842: ,p_data => x_msg_data);
1843:
1844: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1843:
1844: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1845: ROLLBACK TO create_option_values;
1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1847: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1848: ,p_count => x_msg_count
1849: ,p_data => x_msg_data);
1850:
1851: WHEN OTHERS THEN

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

1850:
1851: WHEN OTHERS THEN
1852: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','create_option_values');
1853: -- store SQL error message on message stack for caller
1854: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1855: ,p_count => x_msg_count
1856: ,p_data => x_msg_data);
1857: -- notify caller of an UNEXPECTED error
1858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1870: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1866: PROCEDURE lock_option_values(
1867:
1868: p_api_version IN NUMBER
1869:
1870: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1871:
1872: ,x_return_status OUT NOCOPY VARCHAR2
1873:
1874: ,x_msg_count OUT NOCOPY NUMBER

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

1912: WHEN FND_API.G_EXC_ERROR THEN
1913: ROLLBACK TO lock_option_values;
1914: x_return_status := FND_API.G_RET_STS_ERROR;
1915:
1916: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1917: ,p_count => x_msg_count
1918: ,p_data => x_msg_data);
1919:
1920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1919:
1920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1921: ROLLBACK TO lock_option_values;
1922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1923: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1924: ,p_count => x_msg_count
1925: ,p_data => x_msg_data);
1926:
1927: WHEN OTHERS THEN

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

1926:
1927: WHEN OTHERS THEN
1928: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','lock_option_values');
1929: -- store SQL error message on message stack for caller
1930: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1931: ,p_count => x_msg_count
1932: ,p_data => x_msg_data);
1933: -- notify caller of an UNEXPECTED error
1934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1944: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1940: PROCEDURE lock_option_values(
1941:
1942: p_api_version IN NUMBER
1943:
1944: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1945:
1946: ,x_return_status OUT NOCOPY VARCHAR2
1947:
1948: ,x_msg_count OUT NOCOPY NUMBER

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

2016: WHEN FND_API.G_EXC_ERROR THEN
2017: ROLLBACK TO lock_option_values;
2018: x_return_status := FND_API.G_RET_STS_ERROR;
2019:
2020: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2021: ,p_count => x_msg_count
2022: ,p_data => x_msg_data);
2023:
2024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2023:
2024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2025: ROLLBACK TO lock_option_values;
2026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2027: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2028: ,p_count => x_msg_count
2029: ,p_data => x_msg_data);
2030:
2031: WHEN OTHERS THEN

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

2030:
2031: WHEN OTHERS THEN
2032: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','lock_option_values');
2033: -- store SQL error message on message stack for caller
2034: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2035: ,p_count => x_msg_count
2036: ,p_data => x_msg_data);
2037: -- notify caller of an UNEXPECTED error
2038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2048: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2044: PROCEDURE update_option_values(
2045:
2046: p_api_version IN NUMBER
2047:
2048: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2049:
2050: ,x_return_status OUT NOCOPY VARCHAR2
2051:
2052: ,x_msg_count OUT NOCOPY NUMBER

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

2131: WHEN FND_API.G_EXC_ERROR THEN
2132: ROLLBACK TO update_option_values;
2133: x_return_status := FND_API.G_RET_STS_ERROR;
2134:
2135: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2136: ,p_count => x_msg_count
2137: ,p_data => x_msg_data);
2138:
2139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2138:
2139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2140: ROLLBACK TO update_option_values;
2141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2142: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2143: ,p_count => x_msg_count
2144: ,p_data => x_msg_data);
2145:
2146: WHEN OTHERS THEN

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

2145:
2146: WHEN OTHERS THEN
2147: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','update_option_values');
2148: -- store SQL error message on message stack for caller
2149: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2150: ,p_count => x_msg_count
2151: ,p_data => x_msg_data);
2152: -- notify caller of an UNEXPECTED error
2153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2163: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2159: PROCEDURE update_option_values(
2160:
2161: p_api_version IN NUMBER
2162:
2163: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2164:
2165: ,x_return_status OUT NOCOPY VARCHAR2
2166:
2167: ,x_msg_count OUT NOCOPY NUMBER

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

2271: WHEN FND_API.G_EXC_ERROR THEN
2272: ROLLBACK TO update_option_values;
2273: x_return_status := FND_API.G_RET_STS_ERROR;
2274:
2275: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2276: ,p_count => x_msg_count
2277: ,p_data => x_msg_data);
2278:
2279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2278:
2279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2280: ROLLBACK TO update_option_values;
2281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2282: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2283: ,p_count => x_msg_count
2284: ,p_data => x_msg_data);
2285:
2286: WHEN OTHERS THEN

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

2285:
2286: WHEN OTHERS THEN
2287: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','update_option_values');
2288: -- store SQL error message on message stack for caller
2289: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2290: ,p_count => x_msg_count
2291: ,p_data => x_msg_data);
2292: -- notify caller of an UNEXPECTED error
2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2307: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2303: PROCEDURE delete_option_values(
2304:
2305: p_api_version IN NUMBER
2306:
2307: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2308:
2309: ,x_return_status OUT NOCOPY VARCHAR2
2310:
2311: ,x_msg_count OUT NOCOPY NUMBER

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

2388: WHEN FND_API.G_EXC_ERROR THEN
2389: ROLLBACK TO delete_option_values;
2390: x_return_status := FND_API.G_RET_STS_ERROR;
2391:
2392: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2393: ,p_count => x_msg_count
2394: ,p_data => x_msg_data);
2395:
2396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2395:
2396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2397: ROLLBACK TO delete_option_values;
2398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2399: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2400: ,p_count => x_msg_count
2401: ,p_data => x_msg_data);
2402:
2403: WHEN OTHERS THEN

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

2402:
2403: WHEN OTHERS THEN
2404: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','delete_option_values');
2405: -- store SQL error message on message stack for caller
2406: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2407: ,p_count => x_msg_count
2408: ,p_data => x_msg_data);
2409: -- notify caller of an UNEXPECTED error
2410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2420: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2416: PROCEDURE delete_option_values(
2417:
2418: p_api_version IN NUMBER
2419:
2420: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2421:
2422: ,x_return_status OUT NOCOPY VARCHAR2
2423:
2424: ,x_msg_count OUT NOCOPY NUMBER

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

2524: WHEN FND_API.G_EXC_ERROR THEN
2525: ROLLBACK TO delete_option_values;
2526: x_return_status := FND_API.G_RET_STS_ERROR;
2527:
2528: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2529: ,p_count => x_msg_count
2530: ,p_data => x_msg_data);
2531:
2532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2531:
2532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2533: ROLLBACK TO delete_option_values;
2534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2535: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2536: ,p_count => x_msg_count
2537: ,p_data => x_msg_data);
2538:
2539: WHEN OTHERS THEN

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

2538:
2539: WHEN OTHERS THEN
2540: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','delete_option_values');
2541: -- store SQL error message on message stack for caller
2542: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2543: ,p_count => x_msg_count
2544: ,p_data => x_msg_data);
2545: -- notify caller of an UNEXPECTED error
2546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2556: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2552: PROCEDURE validate_option_values(
2553:
2554: p_api_version IN NUMBER
2555:
2556: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2557:
2558: ,x_return_status OUT NOCOPY VARCHAR2
2559:
2560: ,x_msg_count OUT NOCOPY NUMBER

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

2637: WHEN FND_API.G_EXC_ERROR THEN
2638: ROLLBACK TO validate_option_values;
2639: x_return_status := FND_API.G_RET_STS_ERROR;
2640:
2641: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2642: ,p_count => x_msg_count
2643: ,p_data => x_msg_data);
2644:
2645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2644:
2645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2646: ROLLBACK TO validate_option_values;
2647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2648: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2649: ,p_count => x_msg_count
2650: ,p_data => x_msg_data);
2651:
2652: WHEN OTHERS THEN

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

2651:
2652: WHEN OTHERS THEN
2653: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','validate_option_values');
2654: -- store SQL error message on message stack for caller
2655: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2656: ,p_count => x_msg_count
2657: ,p_data => x_msg_data);
2658: -- notify caller of an UNEXPECTED error
2659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2669: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2665: PROCEDURE validate_option_values(
2666:
2667: p_api_version IN NUMBER
2668:
2669: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2670:
2671: ,x_return_status OUT NOCOPY VARCHAR2
2672:
2673: ,x_msg_count OUT NOCOPY NUMBER

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

2772: WHEN FND_API.G_EXC_ERROR THEN
2773: ROLLBACK TO validate_option_values;
2774: x_return_status := FND_API.G_RET_STS_ERROR;
2775:
2776: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2777: ,p_count => x_msg_count
2778: ,p_data => x_msg_data);
2779:
2780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2779:
2780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2781: ROLLBACK TO validate_option_values;
2782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2783: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2784: ,p_count => x_msg_count
2785: ,p_data => x_msg_data);
2786:
2787: WHEN OTHERS THEN

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

2786:
2787: WHEN OTHERS THEN
2788: FND_MSG_PUB.ADD_EXC_MSG('OKL_OPTIONS_PUB','validate_option_values');
2789: -- store SQL error message on message stack for caller
2790: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2791: ,p_count => x_msg_count
2792: ,p_data => x_msg_data);
2793: -- notify caller of an UNEXPECTED error
2794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;