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_INDICES_PUB dependencies on FND_MSG_PUB

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_indices;
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_indices;
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 126: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','create_indices');

122: ,p_count => x_msg_count
123: ,p_data => x_msg_data);
124:
125: WHEN OTHERS THEN
126: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','create_indices');
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);

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_INDICES_PUB','create_indices');
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 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_indices;
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_indices;
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 246: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','create_indices');

242: ,p_count => x_msg_count
243: ,p_data => x_msg_data);
244:
245: WHEN OTHERS THEN
246: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','create_indices');
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);

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_INDICES_PUB','create_indices');
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 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_indices;
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_indices;
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 387: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','create_indices');

383: ,p_count => x_msg_count
384: ,p_data => x_msg_data);
385:
386: WHEN OTHERS THEN
387: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','create_indices');
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);

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_INDICES_PUB','create_indices');
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 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_indices;
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_indices;
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 520: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','update_indices');

516: ,p_count => x_msg_count
517: ,p_data => x_msg_data);
518:
519: WHEN OTHERS THEN
520: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','update_indices');
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);

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_INDICES_PUB','update_indices');
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 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_indices;
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_indices;
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 643: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','validate_indices');

639: ,p_count => x_msg_count
640: ,p_data => x_msg_data);
641:
642: WHEN OTHERS THEN
643: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','validate_indices');
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);

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_INDICES_PUB','validate_indices');
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 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_indices;
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_indices;
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 722: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','lock_indices');

718: ,p_count => x_msg_count
719: ,p_data => x_msg_data);
720:
721: WHEN OTHERS THEN
722: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','lock_indices');
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);

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_INDICES_PUB','lock_indices');
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 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_indices;
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_indices;
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 828: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAM_TYPE_PUB','lock_indices');

824: ,p_count => x_msg_count
825: ,p_data => x_msg_data);
826:
827: WHEN OTHERS THEN
828: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAM_TYPE_PUB','lock_indices');
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);

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_indices');
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 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_indices;
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_indices;
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 943: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','update_indices');

939: ,p_count => x_msg_count
940: ,p_data => x_msg_data);
941:
942: WHEN OTHERS THEN
943: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','update_indices');
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);

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_INDICES_PUB','update_indices');
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 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_indices;
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_indices;
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 1083: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','update_indices');

1079: ,p_count => x_msg_count
1080: ,p_data => x_msg_data);
1081:
1082: WHEN OTHERS THEN
1083: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','update_indices');
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);

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_INDICES_PUB','update_indices');
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 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_indices;
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_indices;
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 1204: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','delete_indices');

1200: ,p_count => x_msg_count
1201: ,p_data => x_msg_data);
1202:
1203: WHEN OTHERS THEN
1204: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','delete_indices');
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);

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_INDICES_PUB','delete_indices');
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 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_indices;
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_indices;
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 1340: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','delete_indices');

1336: ,p_count => x_msg_count
1337: ,p_data => x_msg_data);
1338:
1339: WHEN OTHERS THEN
1340: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','delete_indices');
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);

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_INDICES_PUB','delete_indices');
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 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_indices;
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_indices;
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 1457: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','validate_indices');

1453: ,p_count => x_msg_count
1454: ,p_data => x_msg_data);
1455:
1456: WHEN OTHERS THEN
1457: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','validate_indices');
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);

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_INDICES_PUB','validate_indices');
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 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_indices;
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_indices;
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 1591: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','validate_indices');

1587: ,p_count => x_msg_count
1588: ,p_data => x_msg_data);
1589:
1590: WHEN OTHERS THEN
1591: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','validate_indices');
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);

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_INDICES_PUB','validate_indices');
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 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_index_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_index_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 1711: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','create_index_values');

1707: ,p_count => x_msg_count
1708: ,p_data => x_msg_data);
1709:
1710: WHEN OTHERS THEN
1711: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','create_index_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);

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_INDICES_PUB','create_index_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 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_index_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_index_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 1852: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','create_index_values');

1848: ,p_count => x_msg_count
1849: ,p_data => x_msg_data);
1850:
1851: WHEN OTHERS THEN
1852: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','create_index_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);

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_INDICES_PUB','create_index_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 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_index_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_index_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 1928: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','lock_index_values');

1924: ,p_count => x_msg_count
1925: ,p_data => x_msg_data);
1926:
1927: WHEN OTHERS THEN
1928: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','lock_index_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);

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_INDICES_PUB','lock_index_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 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_index_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_index_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 2032: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','lock_index_values');

2028: ,p_count => x_msg_count
2029: ,p_data => x_msg_data);
2030:
2031: WHEN OTHERS THEN
2032: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','lock_index_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);

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_INDICES_PUB','lock_index_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 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_index_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_index_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 2147: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','update_index_values');

2143: ,p_count => x_msg_count
2144: ,p_data => x_msg_data);
2145:
2146: WHEN OTHERS THEN
2147: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','update_index_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);

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_INDICES_PUB','update_index_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 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_index_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_index_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 2287: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','update_index_values');

2283: ,p_count => x_msg_count
2284: ,p_data => x_msg_data);
2285:
2286: WHEN OTHERS THEN
2287: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','update_index_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);

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_INDICES_PUB','update_index_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 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_index_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_index_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 2404: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','delete_index_values');

2400: ,p_count => x_msg_count
2401: ,p_data => x_msg_data);
2402:
2403: WHEN OTHERS THEN
2404: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','delete_index_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);

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_INDICES_PUB','delete_index_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 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_index_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_index_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 2540: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','delete_index_values');

2536: ,p_count => x_msg_count
2537: ,p_data => x_msg_data);
2538:
2539: WHEN OTHERS THEN
2540: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','delete_index_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);

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_INDICES_PUB','delete_index_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 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_index_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_index_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 2653: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','validate_index_values');

2649: ,p_count => x_msg_count
2650: ,p_data => x_msg_data);
2651:
2652: WHEN OTHERS THEN
2653: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','validate_index_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);

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_INDICES_PUB','validate_index_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 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_index_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_index_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 2788: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','validate_index_values');

2784: ,p_count => x_msg_count
2785: ,p_data => x_msg_data);
2786:
2787: WHEN OTHERS THEN
2788: FND_MSG_PUB.ADD_EXC_MSG('OKL_INDICES_PUB','validate_index_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);

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_INDICES_PUB','validate_index_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;