APPS.OKL_STREAMS_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_streams;
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_streams;
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_STREAMS_PUB','create_streams');

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_STREAMS_PUB','create_streams');
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_STREAMS_PUB','create_streams');
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 218: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

214: WHEN FND_API.G_EXC_ERROR THEN
215: ROLLBACK TO create_streams;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217:
218: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
219: ,p_count => x_msg_count
220: ,p_data => x_msg_data);
221:
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

221:
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223: ROLLBACK TO create_streams;
224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
225: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
226: ,p_count => x_msg_count
227: ,p_data => x_msg_data);
228:
229: WHEN OTHERS THEN

Line 230: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_streams');

226: ,p_count => x_msg_count
227: ,p_data => x_msg_data);
228:
229: WHEN OTHERS THEN
230: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_streams');
231: -- store SQL error message on message stack for caller
232: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
233: ,p_count => x_msg_count
234: ,p_data => x_msg_data);

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

228:
229: WHEN OTHERS THEN
230: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_streams');
231: -- store SQL error message on message stack for caller
232: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
233: ,p_count => x_msg_count
234: ,p_data => x_msg_data);
235: -- notify caller of an UNEXPECTED error
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

356: WHEN FND_API.G_EXC_ERROR THEN
357: ROLLBACK TO create_streams;
358: x_return_status := FND_API.G_RET_STS_ERROR;
359:
360: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
361: ,p_count => x_msg_count
362: ,p_data => x_msg_data);
363:
364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

363:
364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
365: ROLLBACK TO create_streams;
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
367: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
368: ,p_count => x_msg_count
369: ,p_data => x_msg_data);
370:
371: WHEN OTHERS THEN

Line 372: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_streams');

368: ,p_count => x_msg_count
369: ,p_data => x_msg_data);
370:
371: WHEN OTHERS THEN
372: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_streams');
373: -- store SQL error message on message stack for caller
374: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
375: ,p_count => x_msg_count
376: ,p_data => x_msg_data);

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

370:
371: WHEN OTHERS THEN
372: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_streams');
373: -- store SQL error message on message stack for caller
374: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
375: ,p_count => x_msg_count
376: ,p_data => x_msg_data);
377: -- notify caller of an UNEXPECTED error
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

497: WHEN FND_API.G_EXC_ERROR THEN
498: ROLLBACK TO create_streams;
499: x_return_status := FND_API.G_RET_STS_ERROR;
500:
501: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
502: ,p_count => x_msg_count
503: ,p_data => x_msg_data);
504:
505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

504:
505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
506: ROLLBACK TO create_streams;
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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 OTHERS THEN

Line 513: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_streams');

509: ,p_count => x_msg_count
510: ,p_data => x_msg_data);
511:
512: WHEN OTHERS THEN
513: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_streams');
514: -- store SQL error message on message stack for caller
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);

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

511:
512: WHEN OTHERS THEN
513: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_streams');
514: -- store SQL error message on message stack for caller
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: -- notify caller of an UNEXPECTED error
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

578: WHEN FND_API.G_EXC_ERROR THEN
579: ROLLBACK TO create_streams;
580: x_return_status := FND_API.G_RET_STS_ERROR;
581:
582: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
583: ,p_count => x_msg_count
584: ,p_data => x_msg_data);
585:
586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

585:
586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
587: ROLLBACK TO create_streams;
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
590: ,p_count => x_msg_count
591: ,p_data => x_msg_data);
592:
593: WHEN OTHERS THEN

Line 594: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_streams_perf');

590: ,p_count => x_msg_count
591: ,p_data => x_msg_data);
592:
593: WHEN OTHERS THEN
594: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_streams_perf');
595: -- store SQL error message on message stack for caller
596: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
597: ,p_count => x_msg_count
598: ,p_data => x_msg_data);

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

592:
593: WHEN OTHERS THEN
594: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_streams_perf');
595: -- store SQL error message on message stack for caller
596: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
597: ,p_count => x_msg_count
598: ,p_data => x_msg_data);
599: -- notify caller of an UNEXPECTED error
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

710: WHEN FND_API.G_EXC_ERROR THEN
711: ROLLBACK TO update_streams;
712: x_return_status := FND_API.G_RET_STS_ERROR;
713:
714: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
715: ,p_count => x_msg_count
716: ,p_data => x_msg_data);
717:
718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

717:
718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
719: ROLLBACK TO update_streams;
720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
721: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
722: ,p_count => x_msg_count
723: ,p_data => x_msg_data);
724:
725: WHEN OTHERS THEN

Line 726: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_streams');

722: ,p_count => x_msg_count
723: ,p_data => x_msg_data);
724:
725: WHEN OTHERS THEN
726: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_streams');
727: -- store SQL error message on message stack for caller
728: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
729: ,p_count => x_msg_count
730: ,p_data => x_msg_data);

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

724:
725: WHEN OTHERS THEN
726: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_streams');
727: -- store SQL error message on message stack for caller
728: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
729: ,p_count => x_msg_count
730: ,p_data => x_msg_data);
731: -- notify caller of an UNEXPECTED error
732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

833: WHEN FND_API.G_EXC_ERROR THEN
834: ROLLBACK TO validate_streams;
835: x_return_status := FND_API.G_RET_STS_ERROR;
836:
837: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
838: ,p_count => x_msg_count
839: ,p_data => x_msg_data);
840:
841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

840:
841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
842: ROLLBACK TO validate_streams;
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
844: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
845: ,p_count => x_msg_count
846: ,p_data => x_msg_data);
847:
848: WHEN OTHERS THEN

Line 849: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','validate_streams');

845: ,p_count => x_msg_count
846: ,p_data => x_msg_data);
847:
848: WHEN OTHERS THEN
849: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','validate_streams');
850: -- store SQL error message on message stack for caller
851: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
852: ,p_count => x_msg_count
853: ,p_data => x_msg_data);

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

847:
848: WHEN OTHERS THEN
849: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','validate_streams');
850: -- store SQL error message on message stack for caller
851: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
852: ,p_count => x_msg_count
853: ,p_data => x_msg_data);
854: -- notify caller of an UNEXPECTED error
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

912: WHEN FND_API.G_EXC_ERROR THEN
913: ROLLBACK TO lock_streams;
914: x_return_status := FND_API.G_RET_STS_ERROR;
915:
916: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
917: ,p_count => x_msg_count
918: ,p_data => x_msg_data);
919:
920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

919:
920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
921: ROLLBACK TO lock_streams;
922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
923: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
924: ,p_count => x_msg_count
925: ,p_data => x_msg_data);
926:
927: WHEN OTHERS THEN

Line 928: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','lock_streams');

924: ,p_count => x_msg_count
925: ,p_data => x_msg_data);
926:
927: WHEN OTHERS THEN
928: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','lock_streams');
929: -- store SQL error message on message stack for caller
930: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
931: ,p_count => x_msg_count
932: ,p_data => x_msg_data);

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

926:
927: WHEN OTHERS THEN
928: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','lock_streams');
929: -- store SQL error message on message stack for caller
930: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
931: ,p_count => x_msg_count
932: ,p_data => x_msg_data);
933: -- notify caller of an UNEXPECTED error
934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1018: WHEN FND_API.G_EXC_ERROR THEN
1019: ROLLBACK TO lock_streams;
1020: x_return_status := FND_API.G_RET_STS_ERROR;
1021:
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:
1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1025:
1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1027: ROLLBACK TO lock_streams;
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1029: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1030: ,p_count => x_msg_count
1031: ,p_data => x_msg_data);
1032:
1033: WHEN OTHERS THEN

Line 1034: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAM_TYPE_PUB','lock_streams');

1030: ,p_count => x_msg_count
1031: ,p_data => x_msg_data);
1032:
1033: WHEN OTHERS THEN
1034: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAM_TYPE_PUB','lock_streams');
1035: -- store SQL error message on message stack for caller
1036: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1037: ,p_count => x_msg_count
1038: ,p_data => x_msg_data);

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

1032:
1033: WHEN OTHERS THEN
1034: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAM_TYPE_PUB','lock_streams');
1035: -- store SQL error message on message stack for caller
1036: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1037: ,p_count => x_msg_count
1038: ,p_data => x_msg_data);
1039: -- notify caller of an UNEXPECTED error
1040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

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

Line 1149: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_streams');

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

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

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

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

1273: WHEN FND_API.G_EXC_ERROR THEN
1274: ROLLBACK TO update_streams;
1275: x_return_status := FND_API.G_RET_STS_ERROR;
1276:
1277: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1278: ,p_count => x_msg_count
1279: ,p_data => x_msg_data);
1280:
1281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1280:
1281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1282: ROLLBACK TO update_streams;
1283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1284: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1285: ,p_count => x_msg_count
1286: ,p_data => x_msg_data);
1287:
1288: WHEN OTHERS THEN

Line 1289: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_streams');

1285: ,p_count => x_msg_count
1286: ,p_data => x_msg_data);
1287:
1288: WHEN OTHERS THEN
1289: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_streams');
1290: -- store SQL error message on message stack for caller
1291: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1292: ,p_count => x_msg_count
1293: ,p_data => x_msg_data);

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

1287:
1288: WHEN OTHERS THEN
1289: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_streams');
1290: -- store SQL error message on message stack for caller
1291: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1292: ,p_count => x_msg_count
1293: ,p_data => x_msg_data);
1294: -- notify caller of an UNEXPECTED error
1295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1394: WHEN FND_API.G_EXC_ERROR THEN
1395: ROLLBACK TO delete_streams;
1396: x_return_status := FND_API.G_RET_STS_ERROR;
1397:
1398: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1399: ,p_count => x_msg_count
1400: ,p_data => x_msg_data);
1401:
1402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1401:
1402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1403: ROLLBACK TO delete_streams;
1404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1405: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1406: ,p_count => x_msg_count
1407: ,p_data => x_msg_data);
1408:
1409: WHEN OTHERS THEN

Line 1410: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_streams');

1406: ,p_count => x_msg_count
1407: ,p_data => x_msg_data);
1408:
1409: WHEN OTHERS THEN
1410: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_streams');
1411: -- store SQL error message on message stack for caller
1412: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1413: ,p_count => x_msg_count
1414: ,p_data => x_msg_data);

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

1408:
1409: WHEN OTHERS THEN
1410: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_streams');
1411: -- store SQL error message on message stack for caller
1412: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1413: ,p_count => x_msg_count
1414: ,p_data => x_msg_data);
1415: -- notify caller of an UNEXPECTED error
1416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1530: WHEN FND_API.G_EXC_ERROR THEN
1531: ROLLBACK TO delete_streams;
1532: x_return_status := FND_API.G_RET_STS_ERROR;
1533:
1534: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1535: ,p_count => x_msg_count
1536: ,p_data => x_msg_data);
1537:
1538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1537:
1538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1539: ROLLBACK TO delete_streams;
1540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1541: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1542: ,p_count => x_msg_count
1543: ,p_data => x_msg_data);
1544:
1545: WHEN OTHERS THEN

Line 1546: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_streams');

1542: ,p_count => x_msg_count
1543: ,p_data => x_msg_data);
1544:
1545: WHEN OTHERS THEN
1546: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_streams');
1547: -- store SQL error message on message stack for caller
1548: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1549: ,p_count => x_msg_count
1550: ,p_data => x_msg_data);

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

1544:
1545: WHEN OTHERS THEN
1546: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_streams');
1547: -- store SQL error message on message stack for caller
1548: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1549: ,p_count => x_msg_count
1550: ,p_data => x_msg_data);
1551: -- notify caller of an UNEXPECTED error
1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

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

Line 1663: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','validate_streams');

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

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

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

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

1781: WHEN FND_API.G_EXC_ERROR THEN
1782: ROLLBACK TO validate_streams;
1783: x_return_status := FND_API.G_RET_STS_ERROR;
1784:
1785: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1786: ,p_count => x_msg_count
1787: ,p_data => x_msg_data);
1788:
1789: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1788:
1789: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1790: ROLLBACK TO validate_streams;
1791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1792: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1793: ,p_count => x_msg_count
1794: ,p_data => x_msg_data);
1795:
1796: WHEN OTHERS THEN

Line 1797: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','validate_streams');

1793: ,p_count => x_msg_count
1794: ,p_data => x_msg_data);
1795:
1796: WHEN OTHERS THEN
1797: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','validate_streams');
1798: -- store SQL error message on message stack for caller
1799: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1800: ,p_count => x_msg_count
1801: ,p_data => x_msg_data);

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

1795:
1796: WHEN OTHERS THEN
1797: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','validate_streams');
1798: -- store SQL error message on message stack for caller
1799: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1800: ,p_count => x_msg_count
1801: ,p_data => x_msg_data);
1802: -- notify caller of an UNEXPECTED error
1803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1901: WHEN FND_API.G_EXC_ERROR THEN
1902: ROLLBACK TO create_stream_elements;
1903: x_return_status := FND_API.G_RET_STS_ERROR;
1904:
1905: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1906: ,p_count => x_msg_count
1907: ,p_data => x_msg_data);
1908:
1909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1908:
1909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1910: ROLLBACK TO create_stream_elements;
1911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1912: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1913: ,p_count => x_msg_count
1914: ,p_data => x_msg_data);
1915:
1916: WHEN OTHERS THEN

Line 1917: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_stream_elements');

1913: ,p_count => x_msg_count
1914: ,p_data => x_msg_data);
1915:
1916: WHEN OTHERS THEN
1917: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_stream_elements');
1918: -- store SQL error message on message stack for caller
1919: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1920: ,p_count => x_msg_count
1921: ,p_data => x_msg_data);

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

1915:
1916: WHEN OTHERS THEN
1917: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_stream_elements');
1918: -- store SQL error message on message stack for caller
1919: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1920: ,p_count => x_msg_count
1921: ,p_data => x_msg_data);
1922: -- notify caller of an UNEXPECTED error
1923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2042: WHEN FND_API.G_EXC_ERROR THEN
2043: ROLLBACK TO create_stream_elements;
2044: x_return_status := FND_API.G_RET_STS_ERROR;
2045:
2046: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2047: ,p_count => x_msg_count
2048: ,p_data => x_msg_data);
2049:
2050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2049:
2050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2051: ROLLBACK TO create_stream_elements;
2052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2053: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2054: ,p_count => x_msg_count
2055: ,p_data => x_msg_data);
2056:
2057: WHEN OTHERS THEN

Line 2058: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_stream_elements');

2054: ,p_count => x_msg_count
2055: ,p_data => x_msg_data);
2056:
2057: WHEN OTHERS THEN
2058: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_stream_elements');
2059: -- store SQL error message on message stack for caller
2060: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2061: ,p_count => x_msg_count
2062: ,p_data => x_msg_data);

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

2056:
2057: WHEN OTHERS THEN
2058: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','create_stream_elements');
2059: -- store SQL error message on message stack for caller
2060: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2061: ,p_count => x_msg_count
2062: ,p_data => x_msg_data);
2063: -- notify caller of an UNEXPECTED error
2064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2118: WHEN FND_API.G_EXC_ERROR THEN
2119: ROLLBACK TO lock_stream_elements;
2120: x_return_status := FND_API.G_RET_STS_ERROR;
2121:
2122: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2123: ,p_count => x_msg_count
2124: ,p_data => x_msg_data);
2125:
2126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2125:
2126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2127: ROLLBACK TO lock_stream_elements;
2128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2129: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2130: ,p_count => x_msg_count
2131: ,p_data => x_msg_data);
2132:
2133: WHEN OTHERS THEN

Line 2134: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','lock_stream_elements');

2130: ,p_count => x_msg_count
2131: ,p_data => x_msg_data);
2132:
2133: WHEN OTHERS THEN
2134: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','lock_stream_elements');
2135: -- store SQL error message on message stack for caller
2136: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2137: ,p_count => x_msg_count
2138: ,p_data => x_msg_data);

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

2132:
2133: WHEN OTHERS THEN
2134: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','lock_stream_elements');
2135: -- store SQL error message on message stack for caller
2136: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2137: ,p_count => x_msg_count
2138: ,p_data => x_msg_data);
2139: -- notify caller of an UNEXPECTED error
2140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2222: WHEN FND_API.G_EXC_ERROR THEN
2223: ROLLBACK TO lock_stream_elements;
2224: x_return_status := FND_API.G_RET_STS_ERROR;
2225:
2226: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2227: ,p_count => x_msg_count
2228: ,p_data => x_msg_data);
2229:
2230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2229:
2230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2231: ROLLBACK TO lock_stream_elements;
2232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2233: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2234: ,p_count => x_msg_count
2235: ,p_data => x_msg_data);
2236:
2237: WHEN OTHERS THEN

Line 2238: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','lock_stream_elements');

2234: ,p_count => x_msg_count
2235: ,p_data => x_msg_data);
2236:
2237: WHEN OTHERS THEN
2238: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','lock_stream_elements');
2239: -- store SQL error message on message stack for caller
2240: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2241: ,p_count => x_msg_count
2242: ,p_data => x_msg_data);

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

2236:
2237: WHEN OTHERS THEN
2238: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','lock_stream_elements');
2239: -- store SQL error message on message stack for caller
2240: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2241: ,p_count => x_msg_count
2242: ,p_data => x_msg_data);
2243: -- notify caller of an UNEXPECTED error
2244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

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

Line 2353: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_stream_elements');

2349: ,p_count => x_msg_count
2350: ,p_data => x_msg_data);
2351:
2352: WHEN OTHERS THEN
2353: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_stream_elements');
2354: -- store SQL error message on message stack for caller
2355: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2356: ,p_count => x_msg_count
2357: ,p_data => x_msg_data);

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

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

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

2477: WHEN FND_API.G_EXC_ERROR THEN
2478: ROLLBACK TO update_stream_elements;
2479: x_return_status := FND_API.G_RET_STS_ERROR;
2480:
2481: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2482: ,p_count => x_msg_count
2483: ,p_data => x_msg_data);
2484:
2485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2484:
2485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2486: ROLLBACK TO update_stream_elements;
2487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2488: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2489: ,p_count => x_msg_count
2490: ,p_data => x_msg_data);
2491:
2492: WHEN OTHERS THEN

Line 2493: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_stream_elements');

2489: ,p_count => x_msg_count
2490: ,p_data => x_msg_data);
2491:
2492: WHEN OTHERS THEN
2493: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_stream_elements');
2494: -- store SQL error message on message stack for caller
2495: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2496: ,p_count => x_msg_count
2497: ,p_data => x_msg_data);

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

2491:
2492: WHEN OTHERS THEN
2493: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_stream_elements');
2494: -- store SQL error message on message stack for caller
2495: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2496: ,p_count => x_msg_count
2497: ,p_data => x_msg_data);
2498: -- notify caller of an UNEXPECTED error
2499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2594: WHEN FND_API.G_EXC_ERROR THEN
2595: ROLLBACK TO delete_stream_elements;
2596: x_return_status := FND_API.G_RET_STS_ERROR;
2597:
2598: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2599: ,p_count => x_msg_count
2600: ,p_data => x_msg_data);
2601:
2602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2601:
2602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2603: ROLLBACK TO delete_stream_elements;
2604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2605: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2606: ,p_count => x_msg_count
2607: ,p_data => x_msg_data);
2608:
2609: WHEN OTHERS THEN

Line 2610: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_stream_elements');

2606: ,p_count => x_msg_count
2607: ,p_data => x_msg_data);
2608:
2609: WHEN OTHERS THEN
2610: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_stream_elements');
2611: -- store SQL error message on message stack for caller
2612: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2613: ,p_count => x_msg_count
2614: ,p_data => x_msg_data);

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

2608:
2609: WHEN OTHERS THEN
2610: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_stream_elements');
2611: -- store SQL error message on message stack for caller
2612: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2613: ,p_count => x_msg_count
2614: ,p_data => x_msg_data);
2615: -- notify caller of an UNEXPECTED error
2616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2730: WHEN FND_API.G_EXC_ERROR THEN
2731: ROLLBACK TO delete_stream_elements;
2732: x_return_status := FND_API.G_RET_STS_ERROR;
2733:
2734: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2735: ,p_count => x_msg_count
2736: ,p_data => x_msg_data);
2737:
2738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2737:
2738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2739: ROLLBACK TO delete_stream_elements;
2740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2741: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2742: ,p_count => x_msg_count
2743: ,p_data => x_msg_data);
2744:
2745: WHEN OTHERS THEN

Line 2746: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_stream_elements');

2742: ,p_count => x_msg_count
2743: ,p_data => x_msg_data);
2744:
2745: WHEN OTHERS THEN
2746: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_stream_elements');
2747: -- store SQL error message on message stack for caller
2748: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2749: ,p_count => x_msg_count
2750: ,p_data => x_msg_data);

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

2744:
2745: WHEN OTHERS THEN
2746: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_stream_elements');
2747: -- store SQL error message on message stack for caller
2748: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2749: ,p_count => x_msg_count
2750: ,p_data => x_msg_data);
2751: -- notify caller of an UNEXPECTED error
2752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2843: WHEN FND_API.G_EXC_ERROR THEN
2844: ROLLBACK TO validate_stream_elements;
2845: x_return_status := FND_API.G_RET_STS_ERROR;
2846:
2847: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2848: ,p_count => x_msg_count
2849: ,p_data => x_msg_data);
2850:
2851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2850:
2851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2852: ROLLBACK TO validate_stream_elements;
2853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2854: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2855: ,p_count => x_msg_count
2856: ,p_data => x_msg_data);
2857:
2858: WHEN OTHERS THEN

Line 2859: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','validate_stream_elements');

2855: ,p_count => x_msg_count
2856: ,p_data => x_msg_data);
2857:
2858: WHEN OTHERS THEN
2859: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','validate_stream_elements');
2860: -- store SQL error message on message stack for caller
2861: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2862: ,p_count => x_msg_count
2863: ,p_data => x_msg_data);

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

2857:
2858: WHEN OTHERS THEN
2859: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','validate_stream_elements');
2860: -- store SQL error message on message stack for caller
2861: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2862: ,p_count => x_msg_count
2863: ,p_data => x_msg_data);
2864: -- notify caller of an UNEXPECTED error
2865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2978: WHEN FND_API.G_EXC_ERROR THEN
2979: ROLLBACK TO validate_stream_elements;
2980: x_return_status := FND_API.G_RET_STS_ERROR;
2981:
2982: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2983: ,p_count => x_msg_count
2984: ,p_data => x_msg_data);
2985:
2986: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2985:
2986: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2987: ROLLBACK TO validate_stream_elements;
2988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2989: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2990: ,p_count => x_msg_count
2991: ,p_data => x_msg_data);
2992:
2993: WHEN OTHERS THEN

Line 2994: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','validate_stream_elements');

2990: ,p_count => x_msg_count
2991: ,p_data => x_msg_data);
2992:
2993: WHEN OTHERS THEN
2994: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','validate_stream_elements');
2995: -- store SQL error message on message stack for caller
2996: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2997: ,p_count => x_msg_count
2998: ,p_data => x_msg_data);

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

2992:
2993: WHEN OTHERS THEN
2994: FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','validate_stream_elements');
2995: -- store SQL error message on message stack for caller
2996: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2997: ,p_count => x_msg_count
2998: ,p_data => x_msg_data);
2999: -- notify caller of an UNEXPECTED error
3000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;