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

Line 10: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

6: PROCEDURE create_streams(
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_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 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 141: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

137:
138: --Object type procedure for insert(master-table,detail-table)
139: PROCEDURE create_streams(
140: p_api_version IN NUMBER
141: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
142: ,x_return_status OUT NOCOPY VARCHAR2
143: ,x_msg_count OUT NOCOPY NUMBER
144: ,x_msg_data OUT NOCOPY VARCHAR2
145: ,p_stmv_tbl IN stmv_tbl_type

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

265: PROCEDURE create_streams(
266:
267: p_api_version IN NUMBER
268:
269: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
270:
271: ,x_return_status OUT NOCOPY VARCHAR2
272:
273: ,x_msg_count OUT NOCOPY NUMBER

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

384: PROCEDURE create_streams(
385:
386: p_api_version IN NUMBER
387:
388: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
389:
390: ,x_return_status OUT NOCOPY VARCHAR2
391:
392: ,x_msg_count OUT NOCOPY NUMBER

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

526: --Bug 4346646-Start of Changes
527:
528: PROCEDURE create_streams_perf(
529: p_api_version IN NUMBER
530: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
531: ,x_return_status OUT NOCOPY VARCHAR2
532: ,x_msg_count OUT NOCOPY NUMBER
533: ,x_msg_data OUT NOCOPY VARCHAR2
534: ,p_stmv_tbl IN stmv_tbl_type

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

608: PROCEDURE update_streams(
609:
610: p_api_version IN NUMBER,
611:
612: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
613:
614: x_return_status OUT NOCOPY VARCHAR2,
615:
616: x_msg_count OUT NOCOPY NUMBER,

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

738: PROCEDURE validate_streams(
739:
740: p_api_version IN NUMBER
741:
742: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
743:
744: ,x_return_status OUT NOCOPY VARCHAR2
745:
746: ,x_msg_count OUT NOCOPY NUMBER

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

861: PROCEDURE lock_streams(
862:
863: p_api_version IN NUMBER
864:
865: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
866:
867: ,x_return_status OUT NOCOPY VARCHAR2
868:
869: ,x_msg_count OUT NOCOPY NUMBER

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

940: PROCEDURE lock_streams(
941:
942: p_api_version IN NUMBER
943:
944: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
945:
946: ,x_return_status OUT NOCOPY VARCHAR2
947:
948: ,x_msg_count OUT NOCOPY NUMBER

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

1046: PROCEDURE update_streams(
1047:
1048: p_api_version IN NUMBER
1049:
1050: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1051:
1052: ,x_return_status OUT NOCOPY VARCHAR2
1053:
1054: ,x_msg_count OUT NOCOPY NUMBER

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

1161: PROCEDURE update_streams(
1162:
1163: p_api_version IN NUMBER
1164:
1165: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1166:
1167: ,x_return_status OUT NOCOPY VARCHAR2
1168:
1169: ,x_msg_count OUT NOCOPY NUMBER

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

1305: PROCEDURE delete_streams(
1306:
1307: p_api_version IN NUMBER
1308:
1309: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1310:
1311: ,x_return_status OUT NOCOPY VARCHAR2
1312:
1313: ,x_msg_count OUT NOCOPY NUMBER

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

1422: PROCEDURE delete_streams(
1423:
1424: p_api_version IN NUMBER
1425:
1426: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1427:
1428: ,x_return_status OUT NOCOPY VARCHAR2
1429:
1430: ,x_msg_count OUT NOCOPY NUMBER

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

1560: PROCEDURE validate_streams(
1561:
1562: p_api_version IN NUMBER
1563:
1564: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1565:
1566: ,x_return_status OUT NOCOPY VARCHAR2
1567:
1568: ,x_msg_count OUT NOCOPY NUMBER

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

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

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

1810: PROCEDURE create_stream_elements(
1811:
1812: p_api_version IN NUMBER
1813:
1814: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1815:
1816: ,x_return_status OUT NOCOPY VARCHAR2
1817:
1818: ,x_msg_count OUT NOCOPY NUMBER

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

1929: PROCEDURE create_stream_elements(
1930:
1931: p_api_version IN NUMBER
1932:
1933: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1934:
1935: ,x_return_status OUT NOCOPY VARCHAR2
1936:
1937: ,x_msg_count OUT NOCOPY NUMBER

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

2072: PROCEDURE lock_stream_elements(
2073:
2074: p_api_version IN NUMBER
2075:
2076: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2077:
2078: ,x_return_status OUT NOCOPY VARCHAR2
2079:
2080: ,x_msg_count OUT NOCOPY NUMBER

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

2146: PROCEDURE lock_stream_elements(
2147:
2148: p_api_version IN NUMBER
2149:
2150: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2151:
2152: ,x_return_status OUT NOCOPY VARCHAR2
2153:
2154: ,x_msg_count OUT NOCOPY NUMBER

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

2250: PROCEDURE update_stream_elements(
2251:
2252: p_api_version IN NUMBER
2253:
2254: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2255:
2256: ,x_return_status OUT NOCOPY VARCHAR2
2257:
2258: ,x_msg_count OUT NOCOPY NUMBER

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

2365: PROCEDURE update_stream_elements(
2366:
2367: p_api_version IN NUMBER
2368:
2369: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2370:
2371: ,x_return_status OUT NOCOPY VARCHAR2
2372:
2373: ,x_msg_count OUT NOCOPY NUMBER

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

2509: PROCEDURE delete_stream_elements(
2510:
2511: p_api_version IN NUMBER
2512:
2513: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2514:
2515: ,x_return_status OUT NOCOPY VARCHAR2
2516:
2517: ,x_msg_count OUT NOCOPY NUMBER

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

2622: PROCEDURE delete_stream_elements(
2623:
2624: p_api_version IN NUMBER
2625:
2626: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2627:
2628: ,x_return_status OUT NOCOPY VARCHAR2
2629:
2630: ,x_msg_count OUT NOCOPY NUMBER

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

2758: PROCEDURE validate_stream_elements(
2759:
2760: p_api_version IN NUMBER
2761:
2762: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2763:
2764: ,x_return_status OUT NOCOPY VARCHAR2
2765:
2766: ,x_msg_count OUT NOCOPY NUMBER

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

2871: PROCEDURE validate_stream_elements(
2872:
2873: p_api_version IN NUMBER
2874:
2875: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2876:
2877: ,x_return_status OUT NOCOPY VARCHAR2
2878:
2879: ,x_msg_count OUT NOCOPY NUMBER

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