APPS.OKL_PTL_QUALITYS_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_ptl_qualitys';
33:
34: l_ptqv_rec ptqv_rec_type := p_ptqv_rec;
35:
36: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
37:
38: l_ptvv_tbl ptvv_tbl_type := p_ptvv_tbl;
39:
40:

Line 45: x_return_status := FND_API.G_RET_STS_SUCCESS;

41:
42: BEGIN
43:
44: SAVEPOINT create_ptl_qualitys;
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_ptqv_rec => x_ptqv_rec
82:
83: ,x_ptvv_tbl => x_ptvv_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_ptvv_tbl => x_ptvv_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_ptvv_tbl => x_ptvv_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_ptqv_rec := x_ptqv_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_ptl_qualitys;
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_ptl_qualitys;
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_ptl_qualitys;
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_ptl_qualitys;
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_ptl_qualitys;
136:

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

151: ,p_ptqv_rec IN ptqv_rec_type
152:
153: ,x_ptqv_rec OUT NOCOPY ptqv_rec_type) IS
154:
155: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
156:
157: l_api_name CONSTANT VARCHAR2(30) := 'create_ptl_qualitys';
158:
159: l_ptqv_rec ptqv_rec_type := p_ptqv_rec;

Line 166: x_return_status := FND_API.G_RET_STS_SUCCESS;

162:
163: BEGIN
164:
165: SAVEPOINT create_ptl_qualitys;
166: x_return_status := FND_API.G_RET_STS_SUCCESS;
167:
168:
169:
170: -- customer pre-processing

Line 206: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

202: );
203:
204:
205:
206: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
207: RAISE FND_API.G_EXC_ERROR;
208: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;

Line 207: RAISE FND_API.G_EXC_ERROR;

203:
204:
205:
206: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
207: RAISE FND_API.G_EXC_ERROR;
208: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;
211:

Line 208: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

204:
205:
206: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
207: RAISE FND_API.G_EXC_ERROR;
208: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;
211:
212: l_ptqv_rec := x_ptqv_rec;

Line 209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

205:
206: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
207: RAISE FND_API.G_EXC_ERROR;
208: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;
211:
212: l_ptqv_rec := x_ptqv_rec;
213:

Line 230: WHEN FND_API.G_EXC_ERROR THEN

226:
227:
228: EXCEPTION
229:
230: WHEN FND_API.G_EXC_ERROR THEN
231: ROLLBACK TO create_ptl_qualitys;
232: x_return_status := FND_API.G_RET_STS_ERROR;
233:
234: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 232: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

234: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
235: ,p_count => x_msg_count
236: ,p_data => x_msg_data);
237:
238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
239: ROLLBACK TO create_ptl_qualitys;
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
242: ,p_count => x_msg_count

Line 240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

248: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
249: ,p_count => x_msg_count
250: ,p_data => x_msg_data);
251: -- notify caller of an UNEXPECTED error
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
253:
254: END create_ptl_qualitys;
255:
256:

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

270: ,p_ptqv_tbl IN ptqv_tbl_type
271:
272: ,x_ptqv_tbl OUT NOCOPY ptqv_tbl_type) IS
273:
274: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
275:
276: l_api_name CONSTANT VARCHAR2(30) := 'create_ptl_qualitys';
277:
278: i NUMBER;

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

276: l_api_name CONSTANT VARCHAR2(30) := 'create_ptl_qualitys';
277:
278: i NUMBER;
279:
280: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
281:
282: l_ptqv_tbl ptqv_tbl_type := p_ptqv_tbl;
283:
284: BEGIN

Line 288: x_return_status := FND_API.G_RET_STS_SUCCESS;

284: BEGIN
285:
286: --Initialize the return status
287: SAVEPOINT create_ptl_qualitys;
288: x_return_status := FND_API.G_RET_STS_SUCCESS;
289:
290:
291:
292: -- customer pre-processing

Line 331: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

327:
328: );
329:
330: -- store the highest degree of error
331: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
332: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
333: l_overall_status := x_return_status;
334: END IF;
335: END IF;

Line 332: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

328: );
329:
330: -- store the highest degree of error
331: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
332: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
333: l_overall_status := x_return_status;
334: END IF;
335: END IF;
336:

Line 346: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

342: -- return overall status
343: l_return_status := l_overall_status;
344: END IF;
345:
346: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
347: RAISE FND_API.G_EXC_ERROR;
348: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: END IF;

Line 347: RAISE FND_API.G_EXC_ERROR;

343: l_return_status := l_overall_status;
344: END IF;
345:
346: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
347: RAISE FND_API.G_EXC_ERROR;
348: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: END IF;
351:

Line 348: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

344: END IF;
345:
346: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
347: RAISE FND_API.G_EXC_ERROR;
348: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: END IF;
351:
352: l_ptqv_tbl := x_ptqv_tbl;

Line 349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

345:
346: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
347: RAISE FND_API.G_EXC_ERROR;
348: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: END IF;
351:
352: l_ptqv_tbl := x_ptqv_tbl;
353:

Line 371: WHEN FND_API.G_EXC_ERROR THEN

367:
368:
369: EXCEPTION
370:
371: WHEN FND_API.G_EXC_ERROR THEN
372: ROLLBACK TO create_ptl_qualitys;
373: x_return_status := FND_API.G_RET_STS_ERROR;
374:
375: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 373: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

375: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
376: ,p_count => x_msg_count
377: ,p_data => x_msg_data);
378:
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: ROLLBACK TO create_ptl_qualitys;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
383: ,p_count => x_msg_count

Line 381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

389: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
390: ,p_count => x_msg_count
391: ,p_data => x_msg_data);
392: -- notify caller of an UNEXPECTED error
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394:
395:
396: END create_ptl_qualitys;
397:

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

418: x_ptqv_rec OUT NOCOPY ptqv_rec_type,
419:
420: x_ptvv_tbl OUT NOCOPY ptvv_tbl_type) IS
421:
422: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
423:
424: l_api_name CONSTANT VARCHAR2(30) := 'update_ptl_qualitys';
425:
426: l_ptqv_rec ptqv_rec_type := p_ptqv_rec;

Line 435: x_return_status := FND_API.G_RET_STS_SUCCESS;

431:
432: BEGIN
433:
434: SAVEPOINT update_ptl_qualitys;
435: x_return_status := FND_API.G_RET_STS_SUCCESS;
436:
437:
438:
439: -- customer pre-processing

Line 479: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

475: ,x_ptvv_tbl => x_ptvv_tbl
476:
477: );
478:
479: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
480: RAISE FND_API.G_EXC_ERROR;
481: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
483: END IF;

Line 480: RAISE FND_API.G_EXC_ERROR;

476:
477: );
478:
479: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
480: RAISE FND_API.G_EXC_ERROR;
481: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
483: END IF;
484:

Line 481: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

477: );
478:
479: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
480: RAISE FND_API.G_EXC_ERROR;
481: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
483: END IF;
484:
485: l_ptqv_rec := x_ptqv_rec;

Line 482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

478:
479: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
480: RAISE FND_API.G_EXC_ERROR;
481: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
483: END IF;
484:
485: l_ptqv_rec := x_ptqv_rec;
486: l_ptvv_tbl := x_ptvv_tbl;

Line 504: WHEN FND_API.G_EXC_ERROR THEN

500:
501:
502: EXCEPTION
503:
504: WHEN FND_API.G_EXC_ERROR THEN
505: ROLLBACK TO update_ptl_qualitys;
506: x_return_status := FND_API.G_RET_STS_ERROR;
507:
508: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 506: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

508: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
509: ,p_count => x_msg_count
510: ,p_data => x_msg_data);
511:
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: ROLLBACK TO update_ptl_qualitys;
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
516: ,p_count => x_msg_count

Line 514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

522: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
523: ,p_count => x_msg_count
524: ,p_data => x_msg_data);
525: -- notify caller of an UNEXPECTED error
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527:
528: END update_ptl_qualitys;
529:
530:

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

546: ,p_ptvv_tbl IN ptvv_tbl_type) IS
547:
548:
549:
550: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
551:
552: l_api_name CONSTANT VARCHAR2(30) := 'validate_ptl_qualitys';
553:
554: l_ptqv_rec ptqv_rec_type := p_ptqv_rec;

Line 563: x_return_status := FND_API.G_RET_STS_SUCCESS;

559:
560: BEGIN
561:
562: SAVEPOINT validate_ptl_qualitys;
563: x_return_status := FND_API.G_RET_STS_SUCCESS;
564:
565:
566:
567: -- customer pre-processing

Line 603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

599: );
600:
601:
602:
603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
604: RAISE FND_API.G_EXC_ERROR;
605: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
607: END IF;

Line 604: RAISE FND_API.G_EXC_ERROR;

600:
601:
602:
603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
604: RAISE FND_API.G_EXC_ERROR;
605: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
607: END IF;
608:

Line 605: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

601:
602:
603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
604: RAISE FND_API.G_EXC_ERROR;
605: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
607: END IF;
608:
609:

Line 606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

602:
603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
604: RAISE FND_API.G_EXC_ERROR;
605: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
607: END IF;
608:
609:
610:

Line 627: WHEN FND_API.G_EXC_ERROR THEN

623:
624:
625: EXCEPTION
626:
627: WHEN FND_API.G_EXC_ERROR THEN
628: ROLLBACK TO validate_ptl_qualitys;
629: x_return_status := FND_API.G_RET_STS_ERROR;
630:
631: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 629: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

631: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
632: ,p_count => x_msg_count
633: ,p_data => x_msg_data);
634:
635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
636: ROLLBACK TO validate_ptl_qualitys;
637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
638: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
639: ,p_count => x_msg_count

Line 637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

645: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
646: ,p_count => x_msg_count
647: ,p_data => x_msg_data);
648: -- notify caller of an UNEXPECTED error
649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
650:
651: END validate_ptl_qualitys;
652:
653:

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

665: ,x_msg_data OUT NOCOPY VARCHAR2
666:
667: ,p_ptqv_rec IN ptqv_rec_type) IS
668:
669: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
670:
671: l_api_name CONSTANT VARCHAR2(30) := 'lock_ptl_qualitys';
672:
673:

Line 679: x_return_status := FND_API.G_RET_STS_SUCCESS;

675:
676:
677: BEGIN
678:
679: x_return_status := FND_API.G_RET_STS_SUCCESS;
680: SAVEPOINT lock_ptl_qualitys;
681:
682:
683: okl_ptl_qualitys_pvt.lock_ptl_qualitys(

Line 699: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

695: ,p_ptqv_rec => p_ptqv_rec
696:
697: );
698:
699: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
700: RAISE FND_API.G_EXC_ERROR;
701: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
703: END IF;

Line 700: RAISE FND_API.G_EXC_ERROR;

696:
697: );
698:
699: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
700: RAISE FND_API.G_EXC_ERROR;
701: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
703: END IF;
704:

Line 701: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

697: );
698:
699: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
700: RAISE FND_API.G_EXC_ERROR;
701: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
703: END IF;
704:
705: EXCEPTION

Line 702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

698:
699: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
700: RAISE FND_API.G_EXC_ERROR;
701: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
703: END IF;
704:
705: EXCEPTION
706: WHEN FND_API.G_EXC_ERROR THEN

Line 706: WHEN FND_API.G_EXC_ERROR THEN

702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
703: END IF;
704:
705: EXCEPTION
706: WHEN FND_API.G_EXC_ERROR THEN
707: ROLLBACK TO lock_ptl_qualitys;
708: x_return_status := FND_API.G_RET_STS_ERROR;
709:
710: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 708: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

724: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
725: ,p_count => x_msg_count
726: ,p_data => x_msg_data);
727: -- notify caller of an UNEXPECTED error
728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
729:
730: END lock_ptl_qualitys;
731:
732:

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

744: ,x_msg_data OUT NOCOPY VARCHAR2
745:
746: ,p_ptqv_tbl IN ptqv_tbl_type) IS
747:
748: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
749:
750: l_api_name CONSTANT VARCHAR2(30) := 'lock_ptl_qualitys';
751:
752: i NUMBER;

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

750: l_api_name CONSTANT VARCHAR2(30) := 'lock_ptl_qualitys';
751:
752: i NUMBER;
753:
754: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
755:
756:
757:
758: BEGIN

Line 762: x_return_status := FND_API.G_RET_STS_SUCCESS;

758: BEGIN
759:
760: --Initialize the return status
761:
762: x_return_status := FND_API.G_RET_STS_SUCCESS;
763: SAVEPOINT lock_ptl_qualitys;
764:
765: IF (p_ptqv_tbl.COUNT > 0) THEN
766:

Line 788: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

784:
785: );
786:
787: -- store the highest degree of error
788: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
789: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
790: l_overall_status := x_return_status;
791: END IF;
792: END IF;

Line 789: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

785: );
786:
787: -- store the highest degree of error
788: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
789: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
790: l_overall_status := x_return_status;
791: END IF;
792: END IF;
793:

Line 805: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

801: l_return_status := l_overall_status;
802:
803: END IF;
804:
805: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
806: RAISE FND_API.G_EXC_ERROR;
807: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: END IF;

Line 806: RAISE FND_API.G_EXC_ERROR;

802:
803: END IF;
804:
805: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
806: RAISE FND_API.G_EXC_ERROR;
807: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: END IF;
810:

Line 807: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

803: END IF;
804:
805: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
806: RAISE FND_API.G_EXC_ERROR;
807: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: END IF;
810:
811: EXCEPTION

Line 808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 812: WHEN FND_API.G_EXC_ERROR THEN

808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: END IF;
810:
811: EXCEPTION
812: WHEN FND_API.G_EXC_ERROR THEN
813: ROLLBACK TO lock_ptl_qualitys;
814: x_return_status := FND_API.G_RET_STS_ERROR;
815:
816: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 814: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

816: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
817: ,p_count => x_msg_count
818: ,p_data => x_msg_data);
819:
820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
821: ROLLBACK TO lock_ptl_qualitys;
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
823: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
824: ,p_count => x_msg_count

Line 822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

830: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
831: ,p_count => x_msg_count
832: ,p_data => x_msg_data);
833: -- notify caller of an UNEXPECTED error
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
835:
836: END lock_ptl_qualitys;
837:
838:

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

852: ,p_ptqv_rec IN ptqv_rec_type
853:
854: ,x_ptqv_rec OUT NOCOPY ptqv_rec_type) IS
855:
856: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
857:
858: l_api_name CONSTANT VARCHAR2(30) := 'update_ptl_qualitys';
859:
860: l_ptqv_rec ptqv_rec_type := p_ptqv_rec;

Line 865: x_return_status := FND_API.G_RET_STS_SUCCESS;

861:
862: BEGIN
863:
864: SAVEPOINT update_ptl_qualitys;
865: x_return_status := FND_API.G_RET_STS_SUCCESS;
866:
867:
868:
869: -- customer pre-processing

Line 903: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 904: RAISE FND_API.G_EXC_ERROR;

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

Line 905: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 927: WHEN FND_API.G_EXC_ERROR THEN

923:
924:
925: EXCEPTION
926:
927: WHEN FND_API.G_EXC_ERROR THEN
928: ROLLBACK TO update_ptl_qualitys;
929: x_return_status := FND_API.G_RET_STS_ERROR;
930:
931: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 929: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

931: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
932: ,p_count => x_msg_count
933: ,p_data => x_msg_data);
934:
935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
936: ROLLBACK TO update_ptl_qualitys;
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
939: ,p_count => x_msg_count

Line 937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

945: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
946: ,p_count => x_msg_count
947: ,p_data => x_msg_data);
948: -- notify caller of an UNEXPECTED error
949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
950:
951: END update_ptl_qualitys;
952:
953:

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

967: ,p_ptqv_tbl IN ptqv_tbl_type
968:
969: ,x_ptqv_tbl OUT NOCOPY ptqv_tbl_type) IS
970:
971: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
972:
973: l_api_name CONSTANT VARCHAR2(30) := 'update_ptl_qualitys';
974:
975: i NUMBER;

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

973: l_api_name CONSTANT VARCHAR2(30) := 'update_ptl_qualitys';
974:
975: i NUMBER;
976:
977: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
978:
979: l_ptqv_tbl ptqv_tbl_type := p_ptqv_tbl;
980:
981: BEGIN

Line 985: x_return_status := FND_API.G_RET_STS_SUCCESS;

981: BEGIN
982:
983: --Initialize the return status
984:
985: x_return_status := FND_API.G_RET_STS_SUCCESS;
986: SAVEPOINT update_ptl_qualitys;
987:
988: -- customer pre-processing
989:

Line 1026: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1022: ,x_ptqv_rec => x_ptqv_tbl(i)
1023:
1024: );
1025: -- store the highest degree of error
1026: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1027: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1028: l_overall_status := x_return_status;
1029: END IF;
1030: END IF;

Line 1027: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

1023:
1024: );
1025: -- store the highest degree of error
1026: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1027: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1028: l_overall_status := x_return_status;
1029: END IF;
1030: END IF;
1031:

Line 1042: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1038: -- return overall status
1039: l_return_status := l_overall_status;
1040: END IF;
1041:
1042: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1043: RAISE FND_API.G_EXC_ERROR;
1044: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1046: END IF;

Line 1043: RAISE FND_API.G_EXC_ERROR;

1039: l_return_status := l_overall_status;
1040: END IF;
1041:
1042: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1043: RAISE FND_API.G_EXC_ERROR;
1044: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1046: END IF;
1047:

Line 1044: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1040: END IF;
1041:
1042: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1043: RAISE FND_API.G_EXC_ERROR;
1044: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1046: END IF;
1047:
1048:

Line 1045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1041:
1042: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1043: RAISE FND_API.G_EXC_ERROR;
1044: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1046: END IF;
1047:
1048:
1049: l_ptqv_tbl := x_ptqv_tbl;

Line 1067: WHEN FND_API.G_EXC_ERROR THEN

1063:
1064:
1065: EXCEPTION
1066:
1067: WHEN FND_API.G_EXC_ERROR THEN
1068: ROLLBACK TO update_ptl_qualitys;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070:
1071: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1069: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1071: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1072: ,p_count => x_msg_count
1073: ,p_data => x_msg_data);
1074:
1075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1076: ROLLBACK TO update_ptl_qualitys;
1077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1078: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1079: ,p_count => x_msg_count

Line 1077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1085: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1086: ,p_count => x_msg_count
1087: ,p_data => x_msg_data);
1088: -- notify caller of an UNEXPECTED error
1089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1090:
1091:
1092:
1093: END update_ptl_qualitys;

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

1111: ,p_ptqv_rec IN ptqv_rec_type) IS
1112:
1113: i NUMBER :=0;
1114:
1115: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1116:
1117: l_api_name CONSTANT VARCHAR2(30) := 'delete_ptl_qualitys';
1118:
1119: l_ptqv_rec ptqv_rec_type := p_ptqv_rec;

Line 1126: x_return_status := FND_API.G_RET_STS_SUCCESS;

1122:
1123: BEGIN
1124:
1125: SAVEPOINT delete_ptl_qualitys;
1126: x_return_status := FND_API.G_RET_STS_SUCCESS;
1127:
1128:
1129:
1130: -- customer pre-processing

Line 1164: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1160: );
1161:
1162:
1163:
1164: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1165: RAISE FND_API.G_EXC_ERROR;
1166: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: END IF;

Line 1165: RAISE FND_API.G_EXC_ERROR;

1161:
1162:
1163:
1164: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1165: RAISE FND_API.G_EXC_ERROR;
1166: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: END IF;
1169:

Line 1166: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1162:
1163:
1164: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1165: RAISE FND_API.G_EXC_ERROR;
1166: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: END IF;
1169:
1170:

Line 1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1163:
1164: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1165: RAISE FND_API.G_EXC_ERROR;
1166: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: END IF;
1169:
1170:
1171:

Line 1188: WHEN FND_API.G_EXC_ERROR THEN

1184:
1185:
1186: EXCEPTION
1187:
1188: WHEN FND_API.G_EXC_ERROR THEN
1189: ROLLBACK TO delete_ptl_qualitys;
1190: x_return_status := FND_API.G_RET_STS_ERROR;
1191:
1192: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1190: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1192: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1193: ,p_count => x_msg_count
1194: ,p_data => x_msg_data);
1195:
1196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1197: ROLLBACK TO delete_ptl_qualitys;
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1199: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1200: ,p_count => x_msg_count

Line 1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1206: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1207: ,p_count => x_msg_count
1208: ,p_data => x_msg_data);
1209: -- notify caller of an UNEXPECTED error
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1211:
1212: END delete_ptl_qualitys;
1213:
1214:

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

1228: ,p_ptqv_tbl IN ptqv_tbl_type) IS
1229:
1230: i NUMBER :=0;
1231:
1232: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1233:
1234: l_api_name CONSTANT VARCHAR2(30) := 'delete_ptl_qualitys';
1235:
1236: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

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

1232: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1233:
1234: l_api_name CONSTANT VARCHAR2(30) := 'delete_ptl_qualitys';
1235:
1236: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1237:
1238: l_ptqv_tbl ptqv_tbl_type := p_ptqv_tbl;
1239:
1240: BEGIN

Line 1244: x_return_status := FND_API.G_RET_STS_SUCCESS;

1240: BEGIN
1241:
1242: --Initialize the return status
1243:
1244: x_return_status := FND_API.G_RET_STS_SUCCESS;
1245: SAVEPOINT delete_ptl_qualitys;
1246:
1247: -- customer pre-processing
1248:

Line 1284: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1280:
1281: );
1282:
1283: -- store the highest degree of error
1284: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1285: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1286: l_overall_status := x_return_status;
1287: END IF;
1288: END IF;

Line 1285: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

1281: );
1282:
1283: -- store the highest degree of error
1284: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1285: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1286: l_overall_status := x_return_status;
1287: END IF;
1288: END IF;
1289:

Line 1300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1296: l_return_status := l_overall_status;
1297:
1298: END IF;
1299:
1300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;

Line 1301: RAISE FND_API.G_EXC_ERROR;

1297:
1298: END IF;
1299:
1300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;
1305:

Line 1302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1298: END IF;
1299:
1300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;
1305:
1306:

Line 1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1299:
1300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;
1305:
1306:
1307:

Line 1324: WHEN FND_API.G_EXC_ERROR THEN

1320:
1321:
1322: EXCEPTION
1323:
1324: WHEN FND_API.G_EXC_ERROR THEN
1325: ROLLBACK TO delete_ptl_qualitys;
1326: x_return_status := FND_API.G_RET_STS_ERROR;
1327:
1328: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1326: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1328: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1329: ,p_count => x_msg_count
1330: ,p_data => x_msg_data);
1331:
1332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1333: ROLLBACK TO delete_ptl_qualitys;
1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1335: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1336: ,p_count => x_msg_count

Line 1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1342: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1343: ,p_count => x_msg_count
1344: ,p_data => x_msg_data);
1345: -- notify caller of an UNEXPECTED error
1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1347:
1348:
1349:
1350: END delete_ptl_qualitys;

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

1364: ,x_msg_data OUT NOCOPY VARCHAR2
1365:
1366: ,p_ptqv_rec IN ptqv_rec_type) IS
1367:
1368: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1369:
1370: l_api_name CONSTANT VARCHAR2(30) := 'validate_ptl_qualitys';
1371:
1372: l_ptqv_rec ptqv_rec_type := p_ptqv_rec;

Line 1379: x_return_status := FND_API.G_RET_STS_SUCCESS;

1375:
1376: BEGIN
1377:
1378: SAVEPOINT validate_ptl_qualitys;
1379: x_return_status := FND_API.G_RET_STS_SUCCESS;
1380:
1381:
1382:
1383: -- customer pre-processing

Line 1417: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1413: ,p_ptqv_rec => l_ptqv_rec
1414:
1415: );
1416:
1417: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1418: RAISE FND_API.G_EXC_ERROR;
1419: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1421: END IF;

Line 1418: RAISE FND_API.G_EXC_ERROR;

1414:
1415: );
1416:
1417: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1418: RAISE FND_API.G_EXC_ERROR;
1419: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1421: END IF;
1422:

Line 1419: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1415: );
1416:
1417: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1418: RAISE FND_API.G_EXC_ERROR;
1419: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1421: END IF;
1422:
1423:

Line 1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1416:
1417: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1418: RAISE FND_API.G_EXC_ERROR;
1419: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1421: END IF;
1422:
1423:
1424:

Line 1441: WHEN FND_API.G_EXC_ERROR THEN

1437:
1438:
1439: EXCEPTION
1440:
1441: WHEN FND_API.G_EXC_ERROR THEN
1442: ROLLBACK TO validate_ptl_qualitys;
1443: x_return_status := FND_API.G_RET_STS_ERROR;
1444:
1445: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1443: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1445: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1446: ,p_count => x_msg_count
1447: ,p_data => x_msg_data);
1448:
1449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1450: ROLLBACK TO validate_ptl_qualitys;
1451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1452: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1453: ,p_count => x_msg_count

Line 1451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1459: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1460: ,p_count => x_msg_count
1461: ,p_data => x_msg_data);
1462: -- notify caller of an UNEXPECTED error
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1464:
1465: END validate_ptl_qualitys;
1466:
1467:

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

1479: x_msg_data OUT NOCOPY VARCHAR2,
1480:
1481: p_ptqv_tbl IN ptqv_tbl_type) IS
1482:
1483: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1484:
1485: l_api_name CONSTANT VARCHAR2(30) := 'validate_ptl_qualitys';
1486:
1487: i NUMBER;

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

1485: l_api_name CONSTANT VARCHAR2(30) := 'validate_ptl_qualitys';
1486:
1487: i NUMBER;
1488:
1489: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1490:
1491: l_ptqv_tbl ptqv_tbl_type := p_ptqv_tbl;
1492:
1493: BEGIN

Line 1497: x_return_status := FND_API.G_RET_STS_SUCCESS;

1493: BEGIN
1494:
1495: --Initialize the return status
1496:
1497: x_return_status := FND_API.G_RET_STS_SUCCESS;
1498: SAVEPOINT validate_ptl_qualitys;
1499:
1500: -- customer pre-processing
1501:

Line 1535: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1531: ,p_ptqv_rec => l_ptqv_tbl(i)
1532:
1533: );
1534: -- store the highest degree of error
1535: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1536: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1537: l_overall_status := x_return_status;
1538: END IF;
1539: END IF;

Line 1536: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

1532:
1533: );
1534: -- store the highest degree of error
1535: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1536: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1537: l_overall_status := x_return_status;
1538: END IF;
1539: END IF;
1540:

Line 1551: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1547: l_return_status := l_overall_status;
1548:
1549: END IF;
1550:
1551: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1552: RAISE FND_API.G_EXC_ERROR;
1553: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1555: END IF;

Line 1552: RAISE FND_API.G_EXC_ERROR;

1548:
1549: END IF;
1550:
1551: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1552: RAISE FND_API.G_EXC_ERROR;
1553: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1555: END IF;
1556:

Line 1553: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1549: END IF;
1550:
1551: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1552: RAISE FND_API.G_EXC_ERROR;
1553: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1555: END IF;
1556:
1557:

Line 1554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1550:
1551: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1552: RAISE FND_API.G_EXC_ERROR;
1553: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1555: END IF;
1556:
1557:
1558:

Line 1575: WHEN FND_API.G_EXC_ERROR THEN

1571:
1572:
1573: EXCEPTION
1574:
1575: WHEN FND_API.G_EXC_ERROR THEN
1576: ROLLBACK TO validate_ptl_qualitys;
1577: x_return_status := FND_API.G_RET_STS_ERROR;
1578:
1579: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1577: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1583: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1579: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1580: ,p_count => x_msg_count
1581: ,p_data => x_msg_data);
1582:
1583: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1584: ROLLBACK TO validate_ptl_qualitys;
1585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1586: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1587: ,p_count => x_msg_count

Line 1585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1593: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1594: ,p_count => x_msg_count
1595: ,p_data => x_msg_data);
1596: -- notify caller of an UNEXPECTED error
1597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1598:
1599:
1600: END validate_ptl_qualitys;
1601:

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

1616: ,p_ptvv_rec IN ptvv_rec_type
1617:
1618: ,x_ptvv_rec OUT NOCOPY ptvv_rec_type) IS
1619:
1620: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1621:
1622: l_api_name CONSTANT VARCHAR2(30) := 'create_ptl_qlty_values';
1623:
1624: l_ptvv_rec ptvv_rec_type := p_ptvv_rec;

Line 1629: x_return_status := FND_API.G_RET_STS_SUCCESS;

1625:
1626: BEGIN
1627:
1628: SAVEPOINT create_ptl_qlty_values;
1629: x_return_status := FND_API.G_RET_STS_SUCCESS;
1630:
1631:
1632:
1633: -- customer pre-processing

Line 1671: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1667: ,x_ptvv_rec => x_ptvv_rec
1668:
1669: );
1670:
1671: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1672: RAISE FND_API.G_EXC_ERROR;
1673: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1675: END IF;

Line 1672: RAISE FND_API.G_EXC_ERROR;

1668:
1669: );
1670:
1671: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1672: RAISE FND_API.G_EXC_ERROR;
1673: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1675: END IF;
1676:

Line 1673: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1669: );
1670:
1671: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1672: RAISE FND_API.G_EXC_ERROR;
1673: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1675: END IF;
1676:
1677: l_ptvv_rec := x_ptvv_rec;

Line 1674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1670:
1671: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1672: RAISE FND_API.G_EXC_ERROR;
1673: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1675: END IF;
1676:
1677: l_ptvv_rec := x_ptvv_rec;
1678:

Line 1695: WHEN FND_API.G_EXC_ERROR THEN

1691:
1692:
1693: EXCEPTION
1694:
1695: WHEN FND_API.G_EXC_ERROR THEN
1696: ROLLBACK TO create_ptl_qlty_values;
1697: x_return_status := FND_API.G_RET_STS_ERROR;
1698:
1699: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1697: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1699: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1700: ,p_count => x_msg_count
1701: ,p_data => x_msg_data);
1702:
1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1704: ROLLBACK TO create_ptl_qlty_values;
1705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1706: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1707: ,p_count => x_msg_count

Line 1705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1713: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1714: ,p_count => x_msg_count
1715: ,p_data => x_msg_data);
1716: -- notify caller of an UNEXPECTED error
1717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1718:
1719: END create_ptl_qlty_values;
1720:
1721:

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

1735: ,p_ptvv_tbl IN ptvv_tbl_type
1736:
1737: ,x_ptvv_tbl OUT NOCOPY ptvv_tbl_type) IS
1738:
1739: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1740:
1741: l_api_name CONSTANT VARCHAR2(30) := 'create_ptl_qlty_values';
1742:
1743: i NUMBER;

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

1741: l_api_name CONSTANT VARCHAR2(30) := 'create_ptl_qlty_values';
1742:
1743: i NUMBER;
1744:
1745: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1746:
1747: l_ptvv_tbl ptvv_tbl_type := p_ptvv_tbl;
1748:
1749: BEGIN

Line 1753: x_return_status := FND_API.G_RET_STS_SUCCESS;

1749: BEGIN
1750:
1751: --Initialize the return status
1752: SAVEPOINT create_ptl_qlty_values;
1753: x_return_status := FND_API.G_RET_STS_SUCCESS;
1754:
1755:
1756:
1757: -- customer pre-processing

Line 1795: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1791: ,x_ptvv_rec => x_ptvv_tbl(i)
1792:
1793: );
1794: -- store the highest degree of error
1795: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1796: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1797: l_overall_status := x_return_status;
1798: END IF;
1799: END IF;

Line 1796: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

1792:
1793: );
1794: -- store the highest degree of error
1795: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1796: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1797: l_overall_status := x_return_status;
1798: END IF;
1799: END IF;
1800:

Line 1811: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1807: l_return_status := l_overall_status;
1808:
1809: END IF;
1810:
1811: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1812: RAISE FND_API.G_EXC_ERROR;
1813: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1815: END IF;

Line 1812: RAISE FND_API.G_EXC_ERROR;

1808:
1809: END IF;
1810:
1811: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1812: RAISE FND_API.G_EXC_ERROR;
1813: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1815: END IF;
1816:

Line 1813: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1809: END IF;
1810:
1811: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1812: RAISE FND_API.G_EXC_ERROR;
1813: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1815: END IF;
1816:
1817:

Line 1814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1810:
1811: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1812: RAISE FND_API.G_EXC_ERROR;
1813: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1815: END IF;
1816:
1817:
1818: l_ptvv_tbl := x_ptvv_tbl;

Line 1836: WHEN FND_API.G_EXC_ERROR THEN

1832:
1833:
1834: EXCEPTION
1835:
1836: WHEN FND_API.G_EXC_ERROR THEN
1837: ROLLBACK TO create_ptl_qlty_values;
1838: x_return_status := FND_API.G_RET_STS_ERROR;
1839:
1840: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1838: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1844: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1840: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1841: ,p_count => x_msg_count
1842: ,p_data => x_msg_data);
1843:
1844: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1845: ROLLBACK TO create_ptl_qlty_values;
1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1847: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1848: ,p_count => x_msg_count

Line 1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1854: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1855: ,p_count => x_msg_count
1856: ,p_data => x_msg_data);
1857: -- notify caller of an UNEXPECTED error
1858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1859:
1860:
1861:
1862: END create_ptl_qlty_values;

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

1876: ,x_msg_data OUT NOCOPY VARCHAR2
1877:
1878: ,p_ptvv_rec IN ptvv_rec_type) IS
1879:
1880: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1881:
1882: l_api_name CONSTANT VARCHAR2(30) := 'lock_ptl_qlty_values';
1883:
1884: BEGIN

Line 1886: x_return_status := FND_API.G_RET_STS_SUCCESS;

1882: l_api_name CONSTANT VARCHAR2(30) := 'lock_ptl_qlty_values';
1883:
1884: BEGIN
1885:
1886: x_return_status := FND_API.G_RET_STS_SUCCESS;
1887: SAVEPOINT lock_ptl_qlty_values;
1888:
1889: okl_ptl_qualitys_pvt.lock_ptl_qlty_values(
1890:

Line 1905: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1901: ,p_ptvv_rec => p_ptvv_rec
1902:
1903: );
1904:
1905: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1906: RAISE FND_API.G_EXC_ERROR;
1907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1909: END IF;

Line 1906: RAISE FND_API.G_EXC_ERROR;

1902:
1903: );
1904:
1905: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1906: RAISE FND_API.G_EXC_ERROR;
1907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1909: END IF;
1910:

Line 1907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1903: );
1904:
1905: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1906: RAISE FND_API.G_EXC_ERROR;
1907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1909: END IF;
1910:
1911: EXCEPTION

Line 1908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1904:
1905: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1906: RAISE FND_API.G_EXC_ERROR;
1907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1909: END IF;
1910:
1911: EXCEPTION
1912: WHEN FND_API.G_EXC_ERROR THEN

Line 1912: WHEN FND_API.G_EXC_ERROR THEN

1908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1909: END IF;
1910:
1911: EXCEPTION
1912: WHEN FND_API.G_EXC_ERROR THEN
1913: ROLLBACK TO lock_ptl_qlty_values;
1914: x_return_status := FND_API.G_RET_STS_ERROR;
1915:
1916: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1914: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1916: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1917: ,p_count => x_msg_count
1918: ,p_data => x_msg_data);
1919:
1920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1921: ROLLBACK TO lock_ptl_qlty_values;
1922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1923: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1924: ,p_count => x_msg_count

Line 1922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1930: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1931: ,p_count => x_msg_count
1932: ,p_data => x_msg_data);
1933: -- notify caller of an UNEXPECTED error
1934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1935:
1936: END lock_ptl_qlty_values;
1937:
1938:

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

1950: ,x_msg_data OUT NOCOPY VARCHAR2
1951:
1952: ,p_ptvv_tbl IN ptvv_tbl_type) IS
1953:
1954: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1955:
1956: l_api_name CONSTANT VARCHAR2(30) := 'lock_ptl_qlty_values';
1957:
1958: i NUMBER;

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

1956: l_api_name CONSTANT VARCHAR2(30) := 'lock_ptl_qlty_values';
1957:
1958: i NUMBER;
1959:
1960: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1961:
1962:
1963: BEGIN
1964:

Line 1967: x_return_status := FND_API.G_RET_STS_SUCCESS;

1963: BEGIN
1964:
1965: --Initialize the return status
1966:
1967: x_return_status := FND_API.G_RET_STS_SUCCESS;
1968: SAVEPOINT lock_ptl_qlty_values;
1969:
1970: IF (p_ptvv_tbl.COUNT > 0) THEN
1971:

Line 1992: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1988: ,p_ptvv_rec => p_ptvv_tbl(i)
1989:
1990: );
1991: -- store the highest degree of error
1992: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1993: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1994: l_overall_status := x_return_status;
1995: END IF;
1996: END IF;

Line 1993: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

1989:
1990: );
1991: -- store the highest degree of error
1992: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1993: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1994: l_overall_status := x_return_status;
1995: END IF;
1996: END IF;
1997:

Line 2009: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2005: l_return_status := l_overall_status;
2006:
2007: END IF;
2008:
2009: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2010: RAISE FND_API.G_EXC_ERROR;
2011: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2013: END IF;

Line 2010: RAISE FND_API.G_EXC_ERROR;

2006:
2007: END IF;
2008:
2009: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2010: RAISE FND_API.G_EXC_ERROR;
2011: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2013: END IF;
2014:

Line 2011: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2007: END IF;
2008:
2009: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2010: RAISE FND_API.G_EXC_ERROR;
2011: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2013: END IF;
2014:
2015: EXCEPTION

Line 2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2008:
2009: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2010: RAISE FND_API.G_EXC_ERROR;
2011: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2013: END IF;
2014:
2015: EXCEPTION
2016: WHEN FND_API.G_EXC_ERROR THEN

Line 2016: WHEN FND_API.G_EXC_ERROR THEN

2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2013: END IF;
2014:
2015: EXCEPTION
2016: WHEN FND_API.G_EXC_ERROR THEN
2017: ROLLBACK TO lock_ptl_qlty_values;
2018: x_return_status := FND_API.G_RET_STS_ERROR;
2019:
2020: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 2018: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2020: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2021: ,p_count => x_msg_count
2022: ,p_data => x_msg_data);
2023:
2024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2025: ROLLBACK TO lock_ptl_qlty_values;
2026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2027: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2028: ,p_count => x_msg_count

Line 2026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2034: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2035: ,p_count => x_msg_count
2036: ,p_data => x_msg_data);
2037: -- notify caller of an UNEXPECTED error
2038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2039:
2040: END lock_ptl_qlty_values;
2041:
2042:

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

2056: ,p_ptvv_rec IN ptvv_rec_type
2057:
2058: ,x_ptvv_rec OUT NOCOPY ptvv_rec_type) IS
2059:
2060: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2061:
2062: l_api_name CONSTANT VARCHAR2(30) := 'update_ptl_qlty_values';
2063:
2064: l_ptvv_rec ptvv_rec_type := p_ptvv_rec;

Line 2069: x_return_status := FND_API.G_RET_STS_SUCCESS;

2065:
2066: BEGIN
2067:
2068: SAVEPOINT update_ptl_qlty_values;
2069: x_return_status := FND_API.G_RET_STS_SUCCESS;
2070:
2071:
2072:
2073: -- customer pre-processing

Line 2107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2103: ,x_ptvv_rec => x_ptvv_rec
2104:
2105: );
2106:
2107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2108: RAISE FND_API.G_EXC_ERROR;
2109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2111: END IF;

Line 2108: RAISE FND_API.G_EXC_ERROR;

2104:
2105: );
2106:
2107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2108: RAISE FND_API.G_EXC_ERROR;
2109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2111: END IF;
2112:

Line 2109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2105: );
2106:
2107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2108: RAISE FND_API.G_EXC_ERROR;
2109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2111: END IF;
2112:
2113: l_ptvv_rec := x_ptvv_rec;

Line 2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2106:
2107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2108: RAISE FND_API.G_EXC_ERROR;
2109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2111: END IF;
2112:
2113: l_ptvv_rec := x_ptvv_rec;
2114:

Line 2131: WHEN FND_API.G_EXC_ERROR THEN

2127:
2128:
2129: EXCEPTION
2130:
2131: WHEN FND_API.G_EXC_ERROR THEN
2132: ROLLBACK TO update_ptl_qlty_values;
2133: x_return_status := FND_API.G_RET_STS_ERROR;
2134:
2135: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 2133: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2135: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2136: ,p_count => x_msg_count
2137: ,p_data => x_msg_data);
2138:
2139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2140: ROLLBACK TO update_ptl_qlty_values;
2141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2142: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2143: ,p_count => x_msg_count

Line 2141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2149: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2150: ,p_count => x_msg_count
2151: ,p_data => x_msg_data);
2152: -- notify caller of an UNEXPECTED error
2153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2154:
2155: END update_ptl_qlty_values;
2156:
2157:

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

2171: ,p_ptvv_tbl IN ptvv_tbl_type
2172:
2173: ,x_ptvv_tbl OUT NOCOPY ptvv_tbl_type) IS
2174:
2175: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2176:
2177: l_api_name CONSTANT VARCHAR2(30) := 'update_ptl_qlty_values';
2178:
2179: i NUMBER;

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

2177: l_api_name CONSTANT VARCHAR2(30) := 'update_ptl_qlty_values';
2178:
2179: i NUMBER;
2180:
2181: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2182:
2183: l_ptvv_tbl ptvv_tbl_type := p_ptvv_tbl;
2184:
2185: BEGIN

Line 2189: x_return_status := FND_API.G_RET_STS_SUCCESS;

2185: BEGIN
2186:
2187: --Initialize the return status
2188: SAVEPOINT update_ptl_qlty_values;
2189: x_return_status := FND_API.G_RET_STS_SUCCESS;
2190:
2191:
2192:
2193: -- customer pre-processing

Line 2231: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2227: ,x_ptvv_rec => x_ptvv_tbl(i)
2228:
2229: );
2230: -- store the highest degree of error
2231: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2232: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2233: l_overall_status := x_return_status;
2234: END IF;
2235: END IF;

Line 2232: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

2228:
2229: );
2230: -- store the highest degree of error
2231: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2232: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2233: l_overall_status := x_return_status;
2234: END IF;
2235: END IF;
2236:

Line 2247: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2243: l_return_status := l_overall_status;
2244:
2245: END IF;
2246:
2247: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2248: RAISE FND_API.G_EXC_ERROR;
2249: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2251: END IF;

Line 2248: RAISE FND_API.G_EXC_ERROR;

2244:
2245: END IF;
2246:
2247: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2248: RAISE FND_API.G_EXC_ERROR;
2249: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2251: END IF;
2252:

Line 2249: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2245: END IF;
2246:
2247: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2248: RAISE FND_API.G_EXC_ERROR;
2249: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2251: END IF;
2252:
2253: l_ptvv_tbl := x_ptvv_tbl;

Line 2250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2246:
2247: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2248: RAISE FND_API.G_EXC_ERROR;
2249: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2251: END IF;
2252:
2253: l_ptvv_tbl := x_ptvv_tbl;
2254:

Line 2271: WHEN FND_API.G_EXC_ERROR THEN

2267:
2268:
2269: EXCEPTION
2270:
2271: WHEN FND_API.G_EXC_ERROR THEN
2272: ROLLBACK TO update_ptl_qlty_values;
2273: x_return_status := FND_API.G_RET_STS_ERROR;
2274:
2275: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 2273: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2275: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2276: ,p_count => x_msg_count
2277: ,p_data => x_msg_data);
2278:
2279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2280: ROLLBACK TO update_ptl_qlty_values;
2281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2282: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2283: ,p_count => x_msg_count

Line 2281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2289: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2290: ,p_count => x_msg_count
2291: ,p_data => x_msg_data);
2292: -- notify caller of an UNEXPECTED error
2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2294:
2295:
2296:
2297: END update_ptl_qlty_values;

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

2315: ,p_ptvv_rec IN ptvv_rec_type) IS
2316:
2317: i NUMBER :=0;
2318:
2319: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2320:
2321: l_api_name CONSTANT VARCHAR2(30) := 'delete_ptl_qlty_values';
2322:
2323: l_ptvv_rec ptvv_rec_type := p_ptvv_rec;

Line 2328: x_return_status := FND_API.G_RET_STS_SUCCESS;

2324:
2325: BEGIN
2326:
2327: SAVEPOINT delete_ptl_qlty_values;
2328: x_return_status := FND_API.G_RET_STS_SUCCESS;
2329:
2330:
2331:
2332: -- customer pre-processing

Line 2364: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2360: ,x_msg_data => x_msg_data
2361:
2362: ,p_ptvv_rec => l_ptvv_rec);
2363:
2364: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2365: RAISE FND_API.G_EXC_ERROR;
2366: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2368: END IF;

Line 2365: RAISE FND_API.G_EXC_ERROR;

2361:
2362: ,p_ptvv_rec => l_ptvv_rec);
2363:
2364: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2365: RAISE FND_API.G_EXC_ERROR;
2366: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2368: END IF;
2369:

Line 2366: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2362: ,p_ptvv_rec => l_ptvv_rec);
2363:
2364: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2365: RAISE FND_API.G_EXC_ERROR;
2366: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2368: END IF;
2369:
2370:

Line 2367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2363:
2364: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2365: RAISE FND_API.G_EXC_ERROR;
2366: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2368: END IF;
2369:
2370:
2371:

Line 2388: WHEN FND_API.G_EXC_ERROR THEN

2384:
2385:
2386: EXCEPTION
2387:
2388: WHEN FND_API.G_EXC_ERROR THEN
2389: ROLLBACK TO delete_ptl_qlty_values;
2390: x_return_status := FND_API.G_RET_STS_ERROR;
2391:
2392: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 2390: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2392: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2393: ,p_count => x_msg_count
2394: ,p_data => x_msg_data);
2395:
2396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2397: ROLLBACK TO delete_ptl_qlty_values;
2398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2399: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2400: ,p_count => x_msg_count

Line 2398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2406: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2407: ,p_count => x_msg_count
2408: ,p_data => x_msg_data);
2409: -- notify caller of an UNEXPECTED error
2410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2411:
2412: END delete_ptl_qlty_values;
2413:
2414:

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

2430:
2431:
2432: i NUMBER :=0;
2433:
2434: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2435:
2436: l_api_name CONSTANT VARCHAR2(30) := 'delete_ptl_qlty_values';
2437:
2438: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

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

2434: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2435:
2436: l_api_name CONSTANT VARCHAR2(30) := 'delete_ptl_qlty_values';
2437:
2438: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2439:
2440: l_ptvv_tbl ptvv_tbl_type := p_ptvv_tbl;
2441:
2442: BEGIN

Line 2446: x_return_status := FND_API.G_RET_STS_SUCCESS;

2442: BEGIN
2443:
2444: --Initialize the return status
2445: SAVEPOINT delete_ptl_qlty_values;
2446: x_return_status := FND_API.G_RET_STS_SUCCESS;
2447:
2448:
2449:
2450: -- customer pre-processing

Line 2484: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2480: ,x_msg_data => x_msg_data
2481:
2482: ,p_ptvv_rec => l_ptvv_tbl(i));
2483: -- store the highest degree of error
2484: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2485: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2486: l_overall_status := x_return_status;
2487: END IF;
2488: END IF;

Line 2485: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

2481:
2482: ,p_ptvv_rec => l_ptvv_tbl(i));
2483: -- store the highest degree of error
2484: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2485: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2486: l_overall_status := x_return_status;
2487: END IF;
2488: END IF;
2489:

Line 2500: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2496: l_return_status := l_overall_status;
2497:
2498: END IF;
2499:
2500: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2501: RAISE FND_API.G_EXC_ERROR;
2502: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2504: END IF;

Line 2501: RAISE FND_API.G_EXC_ERROR;

2497:
2498: END IF;
2499:
2500: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2501: RAISE FND_API.G_EXC_ERROR;
2502: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2504: END IF;
2505:

Line 2502: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2498: END IF;
2499:
2500: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2501: RAISE FND_API.G_EXC_ERROR;
2502: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2504: END IF;
2505:
2506:

Line 2503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2499:
2500: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2501: RAISE FND_API.G_EXC_ERROR;
2502: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2504: END IF;
2505:
2506:
2507:

Line 2524: WHEN FND_API.G_EXC_ERROR THEN

2520:
2521:
2522: EXCEPTION
2523:
2524: WHEN FND_API.G_EXC_ERROR THEN
2525: ROLLBACK TO delete_ptl_qlty_values;
2526: x_return_status := FND_API.G_RET_STS_ERROR;
2527:
2528: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 2526: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2528: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2529: ,p_count => x_msg_count
2530: ,p_data => x_msg_data);
2531:
2532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2533: ROLLBACK TO delete_ptl_qlty_values;
2534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2535: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2536: ,p_count => x_msg_count

Line 2534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2542: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2543: ,p_count => x_msg_count
2544: ,p_data => x_msg_data);
2545: -- notify caller of an UNEXPECTED error
2546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2547:
2548: END delete_ptl_qlty_values;
2549:
2550:

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

2562: ,x_msg_data OUT NOCOPY VARCHAR2
2563:
2564: ,p_ptvv_rec IN ptvv_rec_type) IS
2565:
2566: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2567:
2568: l_api_name CONSTANT VARCHAR2(30) := 'validate_ptl_qlty_values';
2569:
2570: l_ptvv_rec ptvv_rec_type := p_ptvv_rec;

Line 2575: x_return_status := FND_API.G_RET_STS_SUCCESS;

2571:
2572: BEGIN
2573:
2574: SAVEPOINT validate_ptl_qlty_values;
2575: x_return_status := FND_API.G_RET_STS_SUCCESS;
2576:
2577:
2578:
2579: -- customer pre-processing

Line 2613: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2609: ,p_ptvv_rec => l_ptvv_rec
2610:
2611: );
2612:
2613: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2614: RAISE FND_API.G_EXC_ERROR;
2615: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2617: END IF;

Line 2614: RAISE FND_API.G_EXC_ERROR;

2610:
2611: );
2612:
2613: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2614: RAISE FND_API.G_EXC_ERROR;
2615: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2617: END IF;
2618:

Line 2615: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2611: );
2612:
2613: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2614: RAISE FND_API.G_EXC_ERROR;
2615: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2617: END IF;
2618:
2619:

Line 2616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2612:
2613: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2614: RAISE FND_API.G_EXC_ERROR;
2615: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2617: END IF;
2618:
2619:
2620:

Line 2637: WHEN FND_API.G_EXC_ERROR THEN

2633:
2634:
2635: EXCEPTION
2636:
2637: WHEN FND_API.G_EXC_ERROR THEN
2638: ROLLBACK TO validate_ptl_qlty_values;
2639: x_return_status := FND_API.G_RET_STS_ERROR;
2640:
2641: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 2639: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2641: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2642: ,p_count => x_msg_count
2643: ,p_data => x_msg_data);
2644:
2645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2646: ROLLBACK TO validate_ptl_qlty_values;
2647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2648: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2649: ,p_count => x_msg_count

Line 2647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2655: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2656: ,p_count => x_msg_count
2657: ,p_data => x_msg_data);
2658: -- notify caller of an UNEXPECTED error
2659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2660:
2661: END validate_ptl_qlty_values;
2662:
2663:

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

2675: ,x_msg_data OUT NOCOPY VARCHAR2
2676:
2677: ,p_ptvv_tbl IN ptvv_tbl_type) IS
2678:
2679: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2680:
2681: l_api_name CONSTANT VARCHAR2(30) := 'validate_ptl_qlty_values';
2682:
2683: i NUMBER;

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

2681: l_api_name CONSTANT VARCHAR2(30) := 'validate_ptl_qlty_values';
2682:
2683: i NUMBER;
2684:
2685: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2686:
2687: l_ptvv_tbl ptvv_tbl_type := p_ptvv_tbl;
2688:
2689: BEGIN

Line 2693: x_return_status := FND_API.G_RET_STS_SUCCESS;

2689: BEGIN
2690:
2691: --Initialize the return status
2692: SAVEPOINT validate_ptl_qlty_values;
2693: x_return_status := FND_API.G_RET_STS_SUCCESS;
2694:
2695:
2696:
2697: -- customer pre-processing

Line 2733: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2729: ,p_ptvv_rec => l_ptvv_tbl(i)
2730:
2731: );
2732: -- store the highest degree of error
2733: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2734: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2735: l_overall_status := x_return_status;
2736: END IF;
2737: END IF;

Line 2734: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

2730:
2731: );
2732: -- store the highest degree of error
2733: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2734: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2735: l_overall_status := x_return_status;
2736: END IF;
2737: END IF;
2738:

Line 2749: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2745: l_return_status := l_overall_status;
2746:
2747: END IF;
2748:
2749: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2750: RAISE FND_API.G_EXC_ERROR;
2751: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2753: END IF;

Line 2750: RAISE FND_API.G_EXC_ERROR;

2746:
2747: END IF;
2748:
2749: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2750: RAISE FND_API.G_EXC_ERROR;
2751: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2753: END IF;
2754:

Line 2751: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2747: END IF;
2748:
2749: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2750: RAISE FND_API.G_EXC_ERROR;
2751: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2753: END IF;
2754:
2755:

Line 2752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2748:
2749: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2750: RAISE FND_API.G_EXC_ERROR;
2751: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2753: END IF;
2754:
2755:
2756: -- vertical industry-post-processing

Line 2772: WHEN FND_API.G_EXC_ERROR THEN

2768:
2769:
2770: EXCEPTION
2771:
2772: WHEN FND_API.G_EXC_ERROR THEN
2773: ROLLBACK TO validate_ptl_qlty_values;
2774: x_return_status := FND_API.G_RET_STS_ERROR;
2775:
2776: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 2774: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2776: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2777: ,p_count => x_msg_count
2778: ,p_data => x_msg_data);
2779:
2780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2781: ROLLBACK TO validate_ptl_qlty_values;
2782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2783: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2784: ,p_count => x_msg_count

Line 2782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2790: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2791: ,p_count => x_msg_count
2792: ,p_data => x_msg_data);
2793: -- notify caller of an UNEXPECTED error
2794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2795:
2796: END validate_ptl_qlty_values;
2797:
2798: