APPS.OKL_STREAMS_PUB dependencies on FND_API

Line 36: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

32: l_api_name CONSTANT VARCHAR2(30) := 'create_streams';
33:
34: l_stmv_rec stmv_rec_type := p_stmv_rec;
35:
36: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
37:
38: l_selv_tbl selv_tbl_type := p_selv_tbl;
39:
40:

Line 45: x_return_status := FND_API.G_RET_STS_SUCCESS;

41:
42: BEGIN
43:
44: SAVEPOINT create_streams;
45: x_return_status := FND_API.G_RET_STS_SUCCESS;
46:
47: -- customer pre-processing
48:
49:

Line 85: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

81: ,x_stmv_rec => x_stmv_rec
82:
83: ,x_selv_tbl => x_selv_tbl);
84:
85: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
86: RAISE FND_API.G_EXC_ERROR;
87: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;

Line 86: RAISE FND_API.G_EXC_ERROR;

82:
83: ,x_selv_tbl => x_selv_tbl);
84:
85: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
86: RAISE FND_API.G_EXC_ERROR;
87: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90:

Line 87: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

83: ,x_selv_tbl => x_selv_tbl);
84:
85: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
86: RAISE FND_API.G_EXC_ERROR;
87: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90:
91:

Line 88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

84:
85: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
86: RAISE FND_API.G_EXC_ERROR;
87: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90:
91:
92: l_stmv_rec := x_stmv_rec;

Line 110: WHEN FND_API.G_EXC_ERROR THEN

106:
107:
108:
109: EXCEPTION
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

Line 112: x_return_status := FND_API.G_RET_STS_ERROR;

108:
109: EXCEPTION
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);

Line 118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

116: ,p_data => x_msg_data);
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:

Line 132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
133:
134:
135: END create_streams;
136:

Line 155: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

151: i NUMBER;
152:
153: l_api_name CONSTANT VARCHAR2(30) := 'create_streams';
154: l_stmv_tbl stmv_tbl_type := p_stmv_tbl;
155: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
156: l_selv_tbl selv_tbl_type := p_selv_tbl;
157:
158:
159: BEGIN

Line 162: x_return_status := FND_API.G_RET_STS_SUCCESS;

158:
159: BEGIN
160:
161: SAVEPOINT create_streams;
162: x_return_status := FND_API.G_RET_STS_SUCCESS;
163:
164: -- customer pre-processing
165:
166:

Line 190: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

186: ,p_selv_tbl => l_selv_tbl
187: ,x_stmv_tbl => x_stmv_tbl
188: ,x_selv_tbl => x_selv_tbl);
189:
190: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
191: RAISE FND_API.G_EXC_ERROR;
192: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;

Line 191: RAISE FND_API.G_EXC_ERROR;

187: ,x_stmv_tbl => x_stmv_tbl
188: ,x_selv_tbl => x_selv_tbl);
189:
190: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
191: RAISE FND_API.G_EXC_ERROR;
192: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;
195:

Line 192: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

188: ,x_selv_tbl => x_selv_tbl);
189:
190: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
191: RAISE FND_API.G_EXC_ERROR;
192: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;
195:
196:

Line 193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

189:
190: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
191: RAISE FND_API.G_EXC_ERROR;
192: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;
195:
196:
197: l_stmv_tbl := x_stmv_tbl;

Line 214: WHEN FND_API.G_EXC_ERROR THEN

210:
211:
212:
213: EXCEPTION
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

Line 216: x_return_status := FND_API.G_RET_STS_ERROR;

212:
213: EXCEPTION
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);

Line 222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

220: ,p_data => x_msg_data);
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:

Line 236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
237:
238:
239: END create_streams;
240:

Line 281: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

277: ,p_stmv_rec IN stmv_rec_type
278:
279: ,x_stmv_rec OUT NOCOPY stmv_rec_type) IS
280:
281: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
282:
283: l_api_name CONSTANT VARCHAR2(30) := 'create_streams';
284:
285: l_stmv_rec stmv_rec_type := p_stmv_rec;

Line 292: x_return_status := FND_API.G_RET_STS_SUCCESS;

288:
289: BEGIN
290:
291: SAVEPOINT create_streams;
292: x_return_status := FND_API.G_RET_STS_SUCCESS;
293:
294:
295:
296: -- customer pre-processing

Line 332: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

328: );
329:
330:
331:
332: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
333: RAISE FND_API.G_EXC_ERROR;
334: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
336: END IF;

Line 333: RAISE FND_API.G_EXC_ERROR;

329:
330:
331:
332: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
333: RAISE FND_API.G_EXC_ERROR;
334: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
336: END IF;
337:

Line 334: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

330:
331:
332: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
333: RAISE FND_API.G_EXC_ERROR;
334: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
336: END IF;
337:
338: l_stmv_rec := x_stmv_rec;

Line 335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

331:
332: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
333: RAISE FND_API.G_EXC_ERROR;
334: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
336: END IF;
337:
338: l_stmv_rec := x_stmv_rec;
339:

Line 356: WHEN FND_API.G_EXC_ERROR THEN

352:
353:
354: EXCEPTION
355:
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

Line 358: x_return_status := FND_API.G_RET_STS_ERROR;

354: EXCEPTION
355:
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);

Line 364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

362: ,p_data => x_msg_data);
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:

Line 378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
379:
380: END create_streams;
381:
382:

Line 400: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

396: ,p_stmv_tbl IN stmv_tbl_type
397:
398: ,x_stmv_tbl OUT NOCOPY stmv_tbl_type) IS
399:
400: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
401:
402: l_api_name CONSTANT VARCHAR2(30) := 'create_streams';
403:
404: i NUMBER;

Line 406: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

402: l_api_name CONSTANT VARCHAR2(30) := 'create_streams';
403:
404: i NUMBER;
405:
406: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
407:
408: l_stmv_tbl stmv_tbl_type := p_stmv_tbl;
409:
410: BEGIN

Line 414: x_return_status := FND_API.G_RET_STS_SUCCESS;

410: BEGIN
411:
412: --Initialize the return status
413: SAVEPOINT create_streams;
414: x_return_status := FND_API.G_RET_STS_SUCCESS;
415:
416:
417:
418: -- customer pre-processing

Line 457: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

453:
454: );
455:
456: -- store the highest degree of error
457: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
458: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
459: l_overall_status := x_return_status;
460: END IF;
461: END IF;

Line 458: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

454: );
455:
456: -- store the highest degree of error
457: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
458: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
459: l_overall_status := x_return_status;
460: END IF;
461: END IF;
462:

Line 472: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

468: -- return overall status
469: l_return_status := l_overall_status;
470: END IF;
471:
472: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
473: RAISE FND_API.G_EXC_ERROR;
474: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
476: END IF;

Line 473: RAISE FND_API.G_EXC_ERROR;

469: l_return_status := l_overall_status;
470: END IF;
471:
472: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
473: RAISE FND_API.G_EXC_ERROR;
474: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
476: END IF;
477:

Line 474: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

470: END IF;
471:
472: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
473: RAISE FND_API.G_EXC_ERROR;
474: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
476: END IF;
477:
478: l_stmv_tbl := x_stmv_tbl;

Line 475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

471:
472: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
473: RAISE FND_API.G_EXC_ERROR;
474: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
476: END IF;
477:
478: l_stmv_tbl := x_stmv_tbl;
479:

Line 497: WHEN FND_API.G_EXC_ERROR THEN

493:
494:
495: EXCEPTION
496:
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

Line 499: x_return_status := FND_API.G_RET_STS_ERROR;

495: EXCEPTION
496:
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);

Line 505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

503: ,p_data => x_msg_data);
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:

Line 519: 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: -- notify caller of an UNEXPECTED error
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520:
521:
522: END create_streams;
523:

Line 544: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

540: i NUMBER;
541:
542: l_api_name CONSTANT VARCHAR2(30) := 'create_streams_perf';
543: l_stmv_tbl stmv_tbl_type := p_stmv_tbl;
544: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
545: l_selv_tbl selv_tbl_type := p_selv_tbl;
546:
547:
548: BEGIN

Line 551: x_return_status := FND_API.G_RET_STS_SUCCESS;

547:
548: BEGIN
549:
550: SAVEPOINT create_streams;
551: x_return_status := FND_API.G_RET_STS_SUCCESS;
552:
553: -- call complex entity API
554:
555: Okl_Streams_Pvt.create_streams_perf(

Line 567: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

563: ,p_selv_tbl => l_selv_tbl
564: ,x_stmv_tbl => x_stmv_tbl
565: ,x_selv_tbl => x_selv_tbl);
566:
567: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
568: RAISE FND_API.G_EXC_ERROR;
569: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571: END IF;

Line 568: RAISE FND_API.G_EXC_ERROR;

564: ,x_stmv_tbl => x_stmv_tbl
565: ,x_selv_tbl => x_selv_tbl);
566:
567: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
568: RAISE FND_API.G_EXC_ERROR;
569: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571: END IF;
572:

Line 569: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

565: ,x_selv_tbl => x_selv_tbl);
566:
567: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
568: RAISE FND_API.G_EXC_ERROR;
569: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571: END IF;
572:
573:

Line 570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

566:
567: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
568: RAISE FND_API.G_EXC_ERROR;
569: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571: END IF;
572:
573:
574: l_stmv_tbl := x_stmv_tbl;

Line 578: WHEN FND_API.G_EXC_ERROR THEN

574: l_stmv_tbl := x_stmv_tbl;
575: l_selv_tbl := x_selv_tbl;
576:
577: EXCEPTION
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

Line 580: x_return_status := FND_API.G_RET_STS_ERROR;

576:
577: EXCEPTION
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);

Line 586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

584: ,p_data => x_msg_data);
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:

Line 600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
601:
602:
603: END create_streams_perf;
604: --Bug 4346646-End of Changes

Line 628: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

624: x_stmv_rec OUT NOCOPY stmv_rec_type,
625:
626: x_selv_tbl OUT NOCOPY selv_tbl_type) IS
627:
628: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
629:
630: l_api_name CONSTANT VARCHAR2(30) := 'update_streams';
631:
632: l_stmv_rec stmv_rec_type := p_stmv_rec;

Line 641: x_return_status := FND_API.G_RET_STS_SUCCESS;

637:
638: BEGIN
639:
640: SAVEPOINT update_streams;
641: x_return_status := FND_API.G_RET_STS_SUCCESS;
642:
643:
644:
645: -- customer pre-processing

Line 685: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

681: ,x_selv_tbl => x_selv_tbl
682:
683: );
684:
685: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
686: RAISE FND_API.G_EXC_ERROR;
687: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
689: END IF;

Line 686: RAISE FND_API.G_EXC_ERROR;

682:
683: );
684:
685: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
686: RAISE FND_API.G_EXC_ERROR;
687: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
689: END IF;
690:

Line 687: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

683: );
684:
685: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
686: RAISE FND_API.G_EXC_ERROR;
687: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
689: END IF;
690:
691: l_stmv_rec := x_stmv_rec;

Line 688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

684:
685: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
686: RAISE FND_API.G_EXC_ERROR;
687: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
689: END IF;
690:
691: l_stmv_rec := x_stmv_rec;
692: l_selv_tbl := x_selv_tbl;

Line 710: WHEN FND_API.G_EXC_ERROR THEN

706:
707:
708: EXCEPTION
709:
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

Line 712: x_return_status := FND_API.G_RET_STS_ERROR;

708: EXCEPTION
709:
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);

Line 718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

716: ,p_data => x_msg_data);
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:

Line 732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
733:
734: END update_streams;
735:
736:

Line 756: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

752: ,p_selv_tbl IN selv_tbl_type) IS
753:
754:
755:
756: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
757:
758: l_api_name CONSTANT VARCHAR2(30) := 'validate_streams';
759:
760: l_stmv_rec stmv_rec_type := p_stmv_rec;

Line 769: x_return_status := FND_API.G_RET_STS_SUCCESS;

765:
766: BEGIN
767:
768: SAVEPOINT validate_streams;
769: x_return_status := FND_API.G_RET_STS_SUCCESS;
770:
771:
772:
773: -- customer pre-processing

Line 809: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

805: );
806:
807:
808:
809: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
810: RAISE FND_API.G_EXC_ERROR;
811: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
813: END IF;

Line 810: RAISE FND_API.G_EXC_ERROR;

806:
807:
808:
809: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
810: RAISE FND_API.G_EXC_ERROR;
811: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
813: END IF;
814:

Line 811: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

807:
808:
809: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
810: RAISE FND_API.G_EXC_ERROR;
811: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
813: END IF;
814:
815:

Line 812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

808:
809: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
810: RAISE FND_API.G_EXC_ERROR;
811: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
813: END IF;
814:
815:
816:

Line 833: WHEN FND_API.G_EXC_ERROR THEN

829:
830:
831: EXCEPTION
832:
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

Line 835: x_return_status := FND_API.G_RET_STS_ERROR;

831: EXCEPTION
832:
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);

Line 841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

839: ,p_data => x_msg_data);
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:

Line 855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
856:
857: END validate_streams;
858:
859:

Line 875: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

871: ,x_msg_data OUT NOCOPY VARCHAR2
872:
873: ,p_stmv_rec IN stmv_rec_type) IS
874:
875: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
876:
877: l_api_name CONSTANT VARCHAR2(30) := 'lock_streams';
878:
879:

Line 885: x_return_status := FND_API.G_RET_STS_SUCCESS;

881:
882:
883: BEGIN
884:
885: x_return_status := FND_API.G_RET_STS_SUCCESS;
886: SAVEPOINT lock_streams;
887:
888:
889: Okl_Streams_Pvt.lock_streams(

Line 905: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

901: ,p_stmv_rec => p_stmv_rec
902:
903: );
904:
905: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
906: RAISE FND_API.G_EXC_ERROR;
907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;

Line 906: RAISE FND_API.G_EXC_ERROR;

902:
903: );
904:
905: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
906: RAISE FND_API.G_EXC_ERROR;
907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;
910:

Line 907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

903: );
904:
905: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
906: RAISE FND_API.G_EXC_ERROR;
907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;
910:
911: EXCEPTION

Line 908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

904:
905: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
906: RAISE FND_API.G_EXC_ERROR;
907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;
910:
911: EXCEPTION
912: WHEN FND_API.G_EXC_ERROR THEN

Line 912: WHEN FND_API.G_EXC_ERROR THEN

908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;
910:
911: EXCEPTION
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

Line 914: x_return_status := FND_API.G_RET_STS_ERROR;

910:
911: EXCEPTION
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);

Line 920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

918: ,p_data => x_msg_data);
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:

Line 934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
935:
936: END lock_streams;
937:
938:

Line 954: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

950: ,x_msg_data OUT NOCOPY VARCHAR2
951:
952: ,p_stmv_tbl IN stmv_tbl_type) IS
953:
954: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
955:
956: l_api_name CONSTANT VARCHAR2(30) := 'lock_streams';
957:
958: i NUMBER;

Line 960: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

956: l_api_name CONSTANT VARCHAR2(30) := 'lock_streams';
957:
958: i NUMBER;
959:
960: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
961:
962:
963:
964: BEGIN

Line 968: x_return_status := FND_API.G_RET_STS_SUCCESS;

964: BEGIN
965:
966: --Initialize the return status
967:
968: x_return_status := FND_API.G_RET_STS_SUCCESS;
969: SAVEPOINT lock_streams;
970:
971: IF (p_stmv_tbl.COUNT > 0) THEN
972:

Line 994: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

990:
991: );
992:
993: -- store the highest degree of error
994: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
995: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
996: l_overall_status := x_return_status;
997: END IF;
998: END IF;

Line 995: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

991: );
992:
993: -- store the highest degree of error
994: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
995: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
996: l_overall_status := x_return_status;
997: END IF;
998: END IF;
999:

Line 1011: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1007: l_return_status := l_overall_status;
1008:
1009: END IF;
1010:
1011: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1012: RAISE FND_API.G_EXC_ERROR;
1013: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: END IF;

Line 1012: RAISE FND_API.G_EXC_ERROR;

1008:
1009: END IF;
1010:
1011: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1012: RAISE FND_API.G_EXC_ERROR;
1013: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: END IF;
1016:

Line 1013: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1009: END IF;
1010:
1011: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1012: RAISE FND_API.G_EXC_ERROR;
1013: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: END IF;
1016:
1017: EXCEPTION

Line 1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1010:
1011: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1012: RAISE FND_API.G_EXC_ERROR;
1013: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: END IF;
1016:
1017: EXCEPTION
1018: WHEN FND_API.G_EXC_ERROR THEN

Line 1018: WHEN FND_API.G_EXC_ERROR THEN

1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: END IF;
1016:
1017: EXCEPTION
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

Line 1020: x_return_status := FND_API.G_RET_STS_ERROR;

1016:
1017: EXCEPTION
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);

Line 1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1024: ,p_data => x_msg_data);
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:

Line 1040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1041:
1042: END lock_streams;
1043:
1044:

Line 1062: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1058: ,p_stmv_rec IN stmv_rec_type
1059:
1060: ,x_stmv_rec OUT NOCOPY stmv_rec_type) IS
1061:
1062: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1063:
1064: l_api_name CONSTANT VARCHAR2(30) := 'update_streams';
1065:
1066: l_stmv_rec stmv_rec_type := p_stmv_rec;

Line 1071: x_return_status := FND_API.G_RET_STS_SUCCESS;

1067:
1068: BEGIN
1069:
1070: SAVEPOINT update_streams;
1071: x_return_status := FND_API.G_RET_STS_SUCCESS;
1072:
1073:
1074:
1075: -- customer pre-processing

Line 1109: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1105: ,x_stmv_rec => x_stmv_rec
1106:
1107: );
1108:
1109: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1110: RAISE FND_API.G_EXC_ERROR;
1111: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1113: END IF;

Line 1110: RAISE FND_API.G_EXC_ERROR;

1106:
1107: );
1108:
1109: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1110: RAISE FND_API.G_EXC_ERROR;
1111: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1113: END IF;
1114:

Line 1111: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1107: );
1108:
1109: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1110: RAISE FND_API.G_EXC_ERROR;
1111: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1113: END IF;
1114:
1115: l_stmv_rec := x_stmv_rec;

Line 1112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1108:
1109: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1110: RAISE FND_API.G_EXC_ERROR;
1111: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1113: END IF;
1114:
1115: l_stmv_rec := x_stmv_rec;
1116:

Line 1133: WHEN FND_API.G_EXC_ERROR THEN

1129:
1130:
1131: EXCEPTION
1132:
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

Line 1135: x_return_status := FND_API.G_RET_STS_ERROR;

1131: EXCEPTION
1132:
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);

Line 1141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1139: ,p_data => x_msg_data);
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:

Line 1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1156:
1157: END update_streams;
1158:
1159:

Line 1177: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1173: ,p_stmv_tbl IN stmv_tbl_type
1174:
1175: ,x_stmv_tbl OUT NOCOPY stmv_tbl_type) IS
1176:
1177: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1178:
1179: l_api_name CONSTANT VARCHAR2(30) := 'update_streams';
1180:
1181: i NUMBER;

Line 1183: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1179: l_api_name CONSTANT VARCHAR2(30) := 'update_streams';
1180:
1181: i NUMBER;
1182:
1183: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1184:
1185: l_stmv_tbl stmv_tbl_type := p_stmv_tbl;
1186:
1187: BEGIN

Line 1191: x_return_status := FND_API.G_RET_STS_SUCCESS;

1187: BEGIN
1188:
1189: --Initialize the return status
1190:
1191: x_return_status := FND_API.G_RET_STS_SUCCESS;
1192: SAVEPOINT update_streams;
1193:
1194: -- customer pre-processing
1195:

Line 1232: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1228: ,x_stmv_rec => x_stmv_tbl(i)
1229:
1230: );
1231: -- store the highest degree of error
1232: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1233: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1234: l_overall_status := x_return_status;
1235: END IF;
1236: END IF;

Line 1233: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

1229:
1230: );
1231: -- store the highest degree of error
1232: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1233: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1234: l_overall_status := x_return_status;
1235: END IF;
1236: END IF;
1237:

Line 1248: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1244: -- return overall status
1245: l_return_status := l_overall_status;
1246: END IF;
1247:
1248: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1249: RAISE FND_API.G_EXC_ERROR;
1250: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252: END IF;

Line 1249: RAISE FND_API.G_EXC_ERROR;

1245: l_return_status := l_overall_status;
1246: END IF;
1247:
1248: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1249: RAISE FND_API.G_EXC_ERROR;
1250: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252: END IF;
1253:

Line 1250: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1246: END IF;
1247:
1248: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1249: RAISE FND_API.G_EXC_ERROR;
1250: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252: END IF;
1253:
1254:

Line 1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1247:
1248: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1249: RAISE FND_API.G_EXC_ERROR;
1250: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252: END IF;
1253:
1254:
1255: l_stmv_tbl := x_stmv_tbl;

Line 1273: WHEN FND_API.G_EXC_ERROR THEN

1269:
1270:
1271: EXCEPTION
1272:
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

Line 1275: x_return_status := FND_API.G_RET_STS_ERROR;

1271: EXCEPTION
1272:
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);

Line 1281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1279: ,p_data => x_msg_data);
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:

Line 1295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1296:
1297:
1298:
1299: END update_streams;

Line 1321: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1317: ,p_stmv_rec IN stmv_rec_type) IS
1318:
1319: i NUMBER :=0;
1320:
1321: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1322:
1323: l_api_name CONSTANT VARCHAR2(30) := 'delete_streams';
1324:
1325: l_stmv_rec stmv_rec_type := p_stmv_rec;

Line 1332: x_return_status := FND_API.G_RET_STS_SUCCESS;

1328:
1329: BEGIN
1330:
1331: SAVEPOINT delete_streams;
1332: x_return_status := FND_API.G_RET_STS_SUCCESS;
1333:
1334:
1335:
1336: -- customer pre-processing

Line 1370: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1366: );
1367:
1368:
1369:
1370: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1371: RAISE FND_API.G_EXC_ERROR;
1372: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1374: END IF;

Line 1371: RAISE FND_API.G_EXC_ERROR;

1367:
1368:
1369:
1370: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1371: RAISE FND_API.G_EXC_ERROR;
1372: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1374: END IF;
1375:

Line 1372: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1368:
1369:
1370: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1371: RAISE FND_API.G_EXC_ERROR;
1372: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1374: END IF;
1375:
1376:

Line 1373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1369:
1370: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1371: RAISE FND_API.G_EXC_ERROR;
1372: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1374: END IF;
1375:
1376:
1377:

Line 1394: WHEN FND_API.G_EXC_ERROR THEN

1390:
1391:
1392: EXCEPTION
1393:
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

Line 1396: x_return_status := FND_API.G_RET_STS_ERROR;

1392: EXCEPTION
1393:
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);

Line 1402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1400: ,p_data => x_msg_data);
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:

Line 1416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1417:
1418: END delete_streams;
1419:
1420:

Line 1438: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1434: ,p_stmv_tbl IN stmv_tbl_type) IS
1435:
1436: i NUMBER :=0;
1437:
1438: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1439:
1440: l_api_name CONSTANT VARCHAR2(30) := 'delete_streams';
1441:
1442: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1442: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1438: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1439:
1440: l_api_name CONSTANT VARCHAR2(30) := 'delete_streams';
1441:
1442: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1443:
1444: l_stmv_tbl stmv_tbl_type := p_stmv_tbl;
1445:
1446: BEGIN

Line 1450: x_return_status := FND_API.G_RET_STS_SUCCESS;

1446: BEGIN
1447:
1448: --Initialize the return status
1449:
1450: x_return_status := FND_API.G_RET_STS_SUCCESS;
1451: SAVEPOINT delete_streams;
1452:
1453: -- customer pre-processing
1454:

Line 1490: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1486:
1487: );
1488:
1489: -- store the highest degree of error
1490: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1491: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1492: l_overall_status := x_return_status;
1493: END IF;
1494: END IF;

Line 1491: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

1487: );
1488:
1489: -- store the highest degree of error
1490: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1491: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1492: l_overall_status := x_return_status;
1493: END IF;
1494: END IF;
1495:

Line 1506: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1502: l_return_status := l_overall_status;
1503:
1504: END IF;
1505:
1506: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1507: RAISE FND_API.G_EXC_ERROR;
1508: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1510: END IF;

Line 1507: RAISE FND_API.G_EXC_ERROR;

1503:
1504: END IF;
1505:
1506: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1507: RAISE FND_API.G_EXC_ERROR;
1508: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1510: END IF;
1511:

Line 1508: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1504: END IF;
1505:
1506: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1507: RAISE FND_API.G_EXC_ERROR;
1508: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1510: END IF;
1511:
1512:

Line 1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1505:
1506: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1507: RAISE FND_API.G_EXC_ERROR;
1508: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1510: END IF;
1511:
1512:
1513:

Line 1530: WHEN FND_API.G_EXC_ERROR THEN

1526:
1527:
1528: EXCEPTION
1529:
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

Line 1532: x_return_status := FND_API.G_RET_STS_ERROR;

1528: EXCEPTION
1529:
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);

Line 1538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1536: ,p_data => x_msg_data);
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:

Line 1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1553:
1554:
1555:
1556: END delete_streams;

Line 1574: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1570: ,x_msg_data OUT NOCOPY VARCHAR2
1571:
1572: ,p_stmv_rec IN stmv_rec_type) IS
1573:
1574: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1575:
1576: l_api_name CONSTANT VARCHAR2(30) := 'validate_streams';
1577:
1578: l_stmv_rec stmv_rec_type := p_stmv_rec;

Line 1585: x_return_status := FND_API.G_RET_STS_SUCCESS;

1581:
1582: BEGIN
1583:
1584: SAVEPOINT validate_streams;
1585: x_return_status := FND_API.G_RET_STS_SUCCESS;
1586:
1587:
1588:
1589: -- customer pre-processing

Line 1623: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1619: ,p_stmv_rec => l_stmv_rec
1620:
1621: );
1622:
1623: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1624: RAISE FND_API.G_EXC_ERROR;
1625: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1627: END IF;

Line 1624: RAISE FND_API.G_EXC_ERROR;

1620:
1621: );
1622:
1623: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1624: RAISE FND_API.G_EXC_ERROR;
1625: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1627: END IF;
1628:

Line 1625: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1621: );
1622:
1623: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1624: RAISE FND_API.G_EXC_ERROR;
1625: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1627: END IF;
1628:
1629:

Line 1626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1622:
1623: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1624: RAISE FND_API.G_EXC_ERROR;
1625: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1627: END IF;
1628:
1629:
1630:

Line 1647: WHEN FND_API.G_EXC_ERROR THEN

1643:
1644:
1645: EXCEPTION
1646:
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

Line 1649: x_return_status := FND_API.G_RET_STS_ERROR;

1645: EXCEPTION
1646:
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);

Line 1655: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1653: ,p_data => x_msg_data);
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:

Line 1669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1670:
1671: END validate_streams;
1672:
1673:

Line 1689: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1685: x_msg_data OUT NOCOPY VARCHAR2,
1686:
1687: p_stmv_tbl IN stmv_tbl_type) IS
1688:
1689: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1690:
1691: l_api_name CONSTANT VARCHAR2(30) := 'validate_streams';
1692:
1693: i NUMBER;

Line 1695: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1691: l_api_name CONSTANT VARCHAR2(30) := 'validate_streams';
1692:
1693: i NUMBER;
1694:
1695: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1696:
1697: l_stmv_tbl stmv_tbl_type := p_stmv_tbl;
1698:
1699: BEGIN

Line 1703: x_return_status := FND_API.G_RET_STS_SUCCESS;

1699: BEGIN
1700:
1701: --Initialize the return status
1702:
1703: x_return_status := FND_API.G_RET_STS_SUCCESS;
1704: SAVEPOINT validate_streams;
1705:
1706: -- customer pre-processing
1707:

Line 1741: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1737: ,p_stmv_rec => l_stmv_tbl(i)
1738:
1739: );
1740: -- store the highest degree of error
1741: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1742: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1743: l_overall_status := x_return_status;
1744: END IF;
1745: END IF;

Line 1742: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

1738:
1739: );
1740: -- store the highest degree of error
1741: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1742: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1743: l_overall_status := x_return_status;
1744: END IF;
1745: END IF;
1746:

Line 1757: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1753: l_return_status := l_overall_status;
1754:
1755: END IF;
1756:
1757: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1758: RAISE FND_API.G_EXC_ERROR;
1759: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1761: END IF;

Line 1758: RAISE FND_API.G_EXC_ERROR;

1754:
1755: END IF;
1756:
1757: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1758: RAISE FND_API.G_EXC_ERROR;
1759: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1761: END IF;
1762:

Line 1759: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1755: END IF;
1756:
1757: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1758: RAISE FND_API.G_EXC_ERROR;
1759: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1761: END IF;
1762:
1763:

Line 1760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1756:
1757: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1758: RAISE FND_API.G_EXC_ERROR;
1759: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1761: END IF;
1762:
1763:
1764:

Line 1781: WHEN FND_API.G_EXC_ERROR THEN

1777:
1778:
1779: EXCEPTION
1780:
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

Line 1783: x_return_status := FND_API.G_RET_STS_ERROR;

1779: EXCEPTION
1780:
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);

Line 1789: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1787: ,p_data => x_msg_data);
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:

Line 1803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1804:
1805:
1806: END validate_streams;
1807:

Line 1826: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1822: ,p_selv_rec IN selv_rec_type
1823:
1824: ,x_selv_rec OUT NOCOPY selv_rec_type) IS
1825:
1826: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1827:
1828: l_api_name CONSTANT VARCHAR2(30) := 'create_stream_elements';
1829:
1830: l_selv_rec selv_rec_type := p_selv_rec;

Line 1835: x_return_status := FND_API.G_RET_STS_SUCCESS;

1831:
1832: BEGIN
1833:
1834: SAVEPOINT create_stream_elements;
1835: x_return_status := FND_API.G_RET_STS_SUCCESS;
1836:
1837:
1838:
1839: -- customer pre-processing

Line 1877: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1873: ,x_selv_rec => x_selv_rec
1874:
1875: );
1876:
1877: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1878: RAISE FND_API.G_EXC_ERROR;
1879: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1881: END IF;

Line 1878: RAISE FND_API.G_EXC_ERROR;

1874:
1875: );
1876:
1877: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1878: RAISE FND_API.G_EXC_ERROR;
1879: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1881: END IF;
1882:

Line 1879: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1875: );
1876:
1877: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1878: RAISE FND_API.G_EXC_ERROR;
1879: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1881: END IF;
1882:
1883: l_selv_rec := x_selv_rec;

Line 1880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1876:
1877: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1878: RAISE FND_API.G_EXC_ERROR;
1879: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1881: END IF;
1882:
1883: l_selv_rec := x_selv_rec;
1884:

Line 1901: WHEN FND_API.G_EXC_ERROR THEN

1897:
1898:
1899: EXCEPTION
1900:
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

Line 1903: x_return_status := FND_API.G_RET_STS_ERROR;

1899: EXCEPTION
1900:
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);

Line 1909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1907: ,p_data => x_msg_data);
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:

Line 1923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1924:
1925: END create_stream_elements;
1926:
1927:

Line 1945: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1941: ,p_selv_tbl IN selv_tbl_type
1942:
1943: ,x_selv_tbl OUT NOCOPY selv_tbl_type) IS
1944:
1945: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1946:
1947: l_api_name CONSTANT VARCHAR2(30) := 'create_stream_elements';
1948:
1949: i NUMBER;

Line 1951: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1947: l_api_name CONSTANT VARCHAR2(30) := 'create_stream_elements';
1948:
1949: i NUMBER;
1950:
1951: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1952:
1953: l_selv_tbl selv_tbl_type := p_selv_tbl;
1954:
1955: BEGIN

Line 1959: x_return_status := FND_API.G_RET_STS_SUCCESS;

1955: BEGIN
1956:
1957: --Initialize the return status
1958: SAVEPOINT create_stream_elements;
1959: x_return_status := FND_API.G_RET_STS_SUCCESS;
1960:
1961:
1962:
1963: -- customer pre-processing

Line 2001: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1997: ,x_selv_rec => x_selv_tbl(i)
1998:
1999: );
2000: -- store the highest degree of error
2001: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2002: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2003: l_overall_status := x_return_status;
2004: END IF;
2005: END IF;

Line 2002: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

1998:
1999: );
2000: -- store the highest degree of error
2001: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2002: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2003: l_overall_status := x_return_status;
2004: END IF;
2005: END IF;
2006:

Line 2017: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2013: l_return_status := l_overall_status;
2014:
2015: END IF;
2016:
2017: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2018: RAISE FND_API.G_EXC_ERROR;
2019: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2021: END IF;

Line 2018: RAISE FND_API.G_EXC_ERROR;

2014:
2015: END IF;
2016:
2017: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2018: RAISE FND_API.G_EXC_ERROR;
2019: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2021: END IF;
2022:

Line 2019: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2015: END IF;
2016:
2017: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2018: RAISE FND_API.G_EXC_ERROR;
2019: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2021: END IF;
2022:
2023:

Line 2020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2016:
2017: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2018: RAISE FND_API.G_EXC_ERROR;
2019: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2021: END IF;
2022:
2023:
2024: l_selv_tbl := x_selv_tbl;

Line 2042: WHEN FND_API.G_EXC_ERROR THEN

2038:
2039:
2040: EXCEPTION
2041:
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

Line 2044: x_return_status := FND_API.G_RET_STS_ERROR;

2040: EXCEPTION
2041:
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);

Line 2050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2048: ,p_data => x_msg_data);
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:

Line 2064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
2065:
2066:
2067:
2068: END create_stream_elements;

Line 2086: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2082: ,x_msg_data OUT NOCOPY VARCHAR2
2083:
2084: ,p_selv_rec IN selv_rec_type) IS
2085:
2086: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2087:
2088: l_api_name CONSTANT VARCHAR2(30) := 'lock_stream_elements';
2089:
2090: BEGIN

Line 2092: x_return_status := FND_API.G_RET_STS_SUCCESS;

2088: l_api_name CONSTANT VARCHAR2(30) := 'lock_stream_elements';
2089:
2090: BEGIN
2091:
2092: x_return_status := FND_API.G_RET_STS_SUCCESS;
2093: SAVEPOINT lock_stream_elements;
2094:
2095: Okl_Streams_Pvt.lock_stream_elements(
2096:

Line 2111: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2107: ,p_selv_rec => p_selv_rec
2108:
2109: );
2110:
2111: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2112: RAISE FND_API.G_EXC_ERROR;
2113: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2115: END IF;

Line 2112: RAISE FND_API.G_EXC_ERROR;

2108:
2109: );
2110:
2111: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2112: RAISE FND_API.G_EXC_ERROR;
2113: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2115: END IF;
2116:

Line 2113: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2109: );
2110:
2111: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2112: RAISE FND_API.G_EXC_ERROR;
2113: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2115: END IF;
2116:
2117: EXCEPTION

Line 2114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2110:
2111: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2112: RAISE FND_API.G_EXC_ERROR;
2113: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2115: END IF;
2116:
2117: EXCEPTION
2118: WHEN FND_API.G_EXC_ERROR THEN

Line 2118: WHEN FND_API.G_EXC_ERROR THEN

2114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2115: END IF;
2116:
2117: EXCEPTION
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

Line 2120: x_return_status := FND_API.G_RET_STS_ERROR;

2116:
2117: EXCEPTION
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);

Line 2126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2124: ,p_data => x_msg_data);
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:

Line 2140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
2141:
2142: END lock_stream_elements;
2143:
2144:

Line 2160: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2156: ,x_msg_data OUT NOCOPY VARCHAR2
2157:
2158: ,p_selv_tbl IN selv_tbl_type) IS
2159:
2160: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2161:
2162: l_api_name CONSTANT VARCHAR2(30) := 'lock_stream_elements';
2163:
2164: i NUMBER;

Line 2166: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2162: l_api_name CONSTANT VARCHAR2(30) := 'lock_stream_elements';
2163:
2164: i NUMBER;
2165:
2166: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2167:
2168:
2169: BEGIN
2170:

Line 2173: x_return_status := FND_API.G_RET_STS_SUCCESS;

2169: BEGIN
2170:
2171: --Initialize the return status
2172:
2173: x_return_status := FND_API.G_RET_STS_SUCCESS;
2174: SAVEPOINT lock_stream_elements;
2175:
2176: IF (p_selv_tbl.COUNT > 0) THEN
2177:

Line 2198: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2194: ,p_selv_rec => p_selv_tbl(i)
2195:
2196: );
2197: -- store the highest degree of error
2198: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2199: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2200: l_overall_status := x_return_status;
2201: END IF;
2202: END IF;

Line 2199: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

2195:
2196: );
2197: -- store the highest degree of error
2198: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2199: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2200: l_overall_status := x_return_status;
2201: END IF;
2202: END IF;
2203:

Line 2215: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2211: l_return_status := l_overall_status;
2212:
2213: END IF;
2214:
2215: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2216: RAISE FND_API.G_EXC_ERROR;
2217: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2219: END IF;

Line 2216: RAISE FND_API.G_EXC_ERROR;

2212:
2213: END IF;
2214:
2215: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2216: RAISE FND_API.G_EXC_ERROR;
2217: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2219: END IF;
2220:

Line 2217: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2213: END IF;
2214:
2215: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2216: RAISE FND_API.G_EXC_ERROR;
2217: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2219: END IF;
2220:
2221: EXCEPTION

Line 2218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2214:
2215: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2216: RAISE FND_API.G_EXC_ERROR;
2217: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2219: END IF;
2220:
2221: EXCEPTION
2222: WHEN FND_API.G_EXC_ERROR THEN

Line 2222: WHEN FND_API.G_EXC_ERROR THEN

2218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2219: END IF;
2220:
2221: EXCEPTION
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

Line 2224: x_return_status := FND_API.G_RET_STS_ERROR;

2220:
2221: EXCEPTION
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);

Line 2230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2228: ,p_data => x_msg_data);
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:

Line 2244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
2245:
2246: END lock_stream_elements;
2247:
2248:

Line 2266: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2262: ,p_selv_rec IN selv_rec_type
2263:
2264: ,x_selv_rec OUT NOCOPY selv_rec_type) IS
2265:
2266: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2267:
2268: l_api_name CONSTANT VARCHAR2(30) := 'update_stream_elements';
2269:
2270: l_selv_rec selv_rec_type := p_selv_rec;

Line 2275: x_return_status := FND_API.G_RET_STS_SUCCESS;

2271:
2272: BEGIN
2273:
2274: SAVEPOINT update_stream_elements;
2275: x_return_status := FND_API.G_RET_STS_SUCCESS;
2276:
2277:
2278:
2279: -- customer pre-processing

Line 2313: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2309: ,x_selv_rec => x_selv_rec
2310:
2311: );
2312:
2313: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2314: RAISE FND_API.G_EXC_ERROR;
2315: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2317: END IF;

Line 2314: RAISE FND_API.G_EXC_ERROR;

2310:
2311: );
2312:
2313: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2314: RAISE FND_API.G_EXC_ERROR;
2315: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2317: END IF;
2318:

Line 2315: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2311: );
2312:
2313: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2314: RAISE FND_API.G_EXC_ERROR;
2315: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2317: END IF;
2318:
2319: l_selv_rec := x_selv_rec;

Line 2316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2312:
2313: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2314: RAISE FND_API.G_EXC_ERROR;
2315: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2317: END IF;
2318:
2319: l_selv_rec := x_selv_rec;
2320:

Line 2337: WHEN FND_API.G_EXC_ERROR THEN

2333:
2334:
2335: EXCEPTION
2336:
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

Line 2339: x_return_status := FND_API.G_RET_STS_ERROR;

2335: EXCEPTION
2336:
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);

Line 2345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2343: ,p_data => x_msg_data);
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:

Line 2359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
2360:
2361: END update_stream_elements;
2362:
2363:

Line 2381: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2377: ,p_selv_tbl IN selv_tbl_type
2378:
2379: ,x_selv_tbl OUT NOCOPY selv_tbl_type) IS
2380:
2381: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2382:
2383: l_api_name CONSTANT VARCHAR2(30) := 'update_stream_elements';
2384:
2385: i NUMBER;

Line 2387: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2383: l_api_name CONSTANT VARCHAR2(30) := 'update_stream_elements';
2384:
2385: i NUMBER;
2386:
2387: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2388:
2389: l_selv_tbl selv_tbl_type := p_selv_tbl;
2390:
2391: BEGIN

Line 2395: x_return_status := FND_API.G_RET_STS_SUCCESS;

2391: BEGIN
2392:
2393: --Initialize the return status
2394: SAVEPOINT update_stream_elements;
2395: x_return_status := FND_API.G_RET_STS_SUCCESS;
2396:
2397:
2398:
2399: -- customer pre-processing

Line 2437: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2433: ,x_selv_rec => x_selv_tbl(i)
2434:
2435: );
2436: -- store the highest degree of error
2437: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2438: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2439: l_overall_status := x_return_status;
2440: END IF;
2441: END IF;

Line 2438: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

2434:
2435: );
2436: -- store the highest degree of error
2437: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2438: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2439: l_overall_status := x_return_status;
2440: END IF;
2441: END IF;
2442:

Line 2453: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2449: l_return_status := l_overall_status;
2450:
2451: END IF;
2452:
2453: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2454: RAISE FND_API.G_EXC_ERROR;
2455: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2457: END IF;

Line 2454: RAISE FND_API.G_EXC_ERROR;

2450:
2451: END IF;
2452:
2453: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2454: RAISE FND_API.G_EXC_ERROR;
2455: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2457: END IF;
2458:

Line 2455: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2451: END IF;
2452:
2453: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2454: RAISE FND_API.G_EXC_ERROR;
2455: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2457: END IF;
2458:
2459: l_selv_tbl := x_selv_tbl;

Line 2456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2452:
2453: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2454: RAISE FND_API.G_EXC_ERROR;
2455: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2457: END IF;
2458:
2459: l_selv_tbl := x_selv_tbl;
2460:

Line 2477: WHEN FND_API.G_EXC_ERROR THEN

2473:
2474:
2475: EXCEPTION
2476:
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

Line 2479: x_return_status := FND_API.G_RET_STS_ERROR;

2475: EXCEPTION
2476:
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);

Line 2485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2483: ,p_data => x_msg_data);
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:

Line 2499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
2500:
2501:
2502:
2503: END update_stream_elements;

Line 2525: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2521: ,p_selv_rec IN selv_rec_type) IS
2522:
2523: i NUMBER :=0;
2524:
2525: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2526:
2527: l_api_name CONSTANT VARCHAR2(30) := 'delete_stream_elements';
2528:
2529: l_selv_rec selv_rec_type := p_selv_rec;

Line 2534: x_return_status := FND_API.G_RET_STS_SUCCESS;

2530:
2531: BEGIN
2532:
2533: SAVEPOINT delete_stream_elements;
2534: x_return_status := FND_API.G_RET_STS_SUCCESS;
2535:
2536:
2537:
2538: -- customer pre-processing

Line 2570: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2566: ,x_msg_data => x_msg_data
2567:
2568: ,p_selv_rec => l_selv_rec);
2569:
2570: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2571: RAISE FND_API.G_EXC_ERROR;
2572: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2574: END IF;

Line 2571: RAISE FND_API.G_EXC_ERROR;

2567:
2568: ,p_selv_rec => l_selv_rec);
2569:
2570: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2571: RAISE FND_API.G_EXC_ERROR;
2572: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2574: END IF;
2575:

Line 2572: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2568: ,p_selv_rec => l_selv_rec);
2569:
2570: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2571: RAISE FND_API.G_EXC_ERROR;
2572: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2574: END IF;
2575:
2576:

Line 2573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2569:
2570: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2571: RAISE FND_API.G_EXC_ERROR;
2572: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2574: END IF;
2575:
2576:
2577:

Line 2594: WHEN FND_API.G_EXC_ERROR THEN

2590:
2591:
2592: EXCEPTION
2593:
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

Line 2596: x_return_status := FND_API.G_RET_STS_ERROR;

2592: EXCEPTION
2593:
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);

Line 2602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2600: ,p_data => x_msg_data);
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:

Line 2616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
2617:
2618: END delete_stream_elements;
2619:
2620:

Line 2640: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2636:
2637:
2638: i NUMBER :=0;
2639:
2640: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2641:
2642: l_api_name CONSTANT VARCHAR2(30) := 'delete_stream_elements';
2643:
2644: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 2644: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2640: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2641:
2642: l_api_name CONSTANT VARCHAR2(30) := 'delete_stream_elements';
2643:
2644: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2645:
2646: l_selv_tbl selv_tbl_type := p_selv_tbl;
2647:
2648: BEGIN

Line 2652: x_return_status := FND_API.G_RET_STS_SUCCESS;

2648: BEGIN
2649:
2650: --Initialize the return status
2651: SAVEPOINT delete_stream_elements;
2652: x_return_status := FND_API.G_RET_STS_SUCCESS;
2653:
2654:
2655:
2656: -- customer pre-processing

Line 2690: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2686: ,x_msg_data => x_msg_data
2687:
2688: ,p_selv_rec => l_selv_tbl(i));
2689: -- store the highest degree of error
2690: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2691: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2692: l_overall_status := x_return_status;
2693: END IF;
2694: END IF;

Line 2691: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

2687:
2688: ,p_selv_rec => l_selv_tbl(i));
2689: -- store the highest degree of error
2690: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2691: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2692: l_overall_status := x_return_status;
2693: END IF;
2694: END IF;
2695:

Line 2706: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2702: l_return_status := l_overall_status;
2703:
2704: END IF;
2705:
2706: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2707: RAISE FND_API.G_EXC_ERROR;
2708: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2710: END IF;

Line 2707: RAISE FND_API.G_EXC_ERROR;

2703:
2704: END IF;
2705:
2706: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2707: RAISE FND_API.G_EXC_ERROR;
2708: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2710: END IF;
2711:

Line 2708: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2704: END IF;
2705:
2706: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2707: RAISE FND_API.G_EXC_ERROR;
2708: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2710: END IF;
2711:
2712:

Line 2709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2705:
2706: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2707: RAISE FND_API.G_EXC_ERROR;
2708: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2710: END IF;
2711:
2712:
2713:

Line 2730: WHEN FND_API.G_EXC_ERROR THEN

2726:
2727:
2728: EXCEPTION
2729:
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

Line 2732: x_return_status := FND_API.G_RET_STS_ERROR;

2728: EXCEPTION
2729:
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);

Line 2738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2736: ,p_data => x_msg_data);
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:

Line 2752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
2753:
2754: END delete_stream_elements;
2755:
2756:

Line 2772: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2768: ,x_msg_data OUT NOCOPY VARCHAR2
2769:
2770: ,p_selv_rec IN selv_rec_type) IS
2771:
2772: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2773:
2774: l_api_name CONSTANT VARCHAR2(30) := 'validate_stream_elements';
2775:
2776: l_selv_rec selv_rec_type := p_selv_rec;

Line 2781: x_return_status := FND_API.G_RET_STS_SUCCESS;

2777:
2778: BEGIN
2779:
2780: SAVEPOINT validate_stream_elements;
2781: x_return_status := FND_API.G_RET_STS_SUCCESS;
2782:
2783:
2784:
2785: -- customer pre-processing

Line 2819: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2815: ,p_selv_rec => l_selv_rec
2816:
2817: );
2818:
2819: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2820: RAISE FND_API.G_EXC_ERROR;
2821: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2823: END IF;

Line 2820: RAISE FND_API.G_EXC_ERROR;

2816:
2817: );
2818:
2819: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2820: RAISE FND_API.G_EXC_ERROR;
2821: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2823: END IF;
2824:

Line 2821: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2817: );
2818:
2819: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2820: RAISE FND_API.G_EXC_ERROR;
2821: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2823: END IF;
2824:
2825:

Line 2822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2818:
2819: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2820: RAISE FND_API.G_EXC_ERROR;
2821: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2823: END IF;
2824:
2825:
2826:

Line 2843: WHEN FND_API.G_EXC_ERROR THEN

2839:
2840:
2841: EXCEPTION
2842:
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

Line 2845: x_return_status := FND_API.G_RET_STS_ERROR;

2841: EXCEPTION
2842:
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);

Line 2851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2849: ,p_data => x_msg_data);
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:

Line 2865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
2866:
2867: END validate_stream_elements;
2868:
2869:

Line 2885: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2881: ,x_msg_data OUT NOCOPY VARCHAR2
2882:
2883: ,p_selv_tbl IN selv_tbl_type) IS
2884:
2885: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2886:
2887: l_api_name CONSTANT VARCHAR2(30) := 'validate_stream_elements';
2888:
2889: i NUMBER;

Line 2891: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2887: l_api_name CONSTANT VARCHAR2(30) := 'validate_stream_elements';
2888:
2889: i NUMBER;
2890:
2891: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2892:
2893: l_selv_tbl selv_tbl_type := p_selv_tbl;
2894:
2895: BEGIN

Line 2899: x_return_status := FND_API.G_RET_STS_SUCCESS;

2895: BEGIN
2896:
2897: --Initialize the return status
2898: SAVEPOINT validate_stream_elements;
2899: x_return_status := FND_API.G_RET_STS_SUCCESS;
2900:
2901:
2902:
2903: -- customer pre-processing

Line 2939: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2935: ,p_selv_rec => l_selv_tbl(i)
2936:
2937: );
2938: -- store the highest degree of error
2939: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2940: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2941: l_overall_status := x_return_status;
2942: END IF;
2943: END IF;

Line 2940: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

2936:
2937: );
2938: -- store the highest degree of error
2939: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2940: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2941: l_overall_status := x_return_status;
2942: END IF;
2943: END IF;
2944:

Line 2955: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2951: l_return_status := l_overall_status;
2952:
2953: END IF;
2954:
2955: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2956: RAISE FND_API.G_EXC_ERROR;
2957: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2959: END IF;

Line 2956: RAISE FND_API.G_EXC_ERROR;

2952:
2953: END IF;
2954:
2955: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2956: RAISE FND_API.G_EXC_ERROR;
2957: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2959: END IF;
2960:

Line 2957: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2953: END IF;
2954:
2955: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2956: RAISE FND_API.G_EXC_ERROR;
2957: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2959: END IF;
2960:
2961:

Line 2958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2954:
2955: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2956: RAISE FND_API.G_EXC_ERROR;
2957: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2959: END IF;
2960:
2961:
2962: -- vertical industry-post-processing

Line 2978: WHEN FND_API.G_EXC_ERROR THEN

2974:
2975:
2976: EXCEPTION
2977:
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

Line 2980: x_return_status := FND_API.G_RET_STS_ERROR;

2976: EXCEPTION
2977:
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);

Line 2986: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2984: ,p_data => x_msg_data);
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:

Line 3000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
3001:
3002: END validate_stream_elements;
3003:
3004: