APPS.OKL_TMPT_SET_PUB dependencies on FND_API

Line 48: x_return_status := FND_API.G_RET_STS_SUCCESS;

44:
45: BEGIN
46:
47: SAVEPOINT create_tmpt_set;
48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49:
50:
51:
52: -- customer pre-processing

Line 94: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

90: ,x_avlv_tbl => x_avlv_tbl
91:
92: ,x_atlv_tbl => x_atlv_tbl);
93:
94: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
95: RAISE FND_API.G_EXC_ERROR;
96: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: END IF;

Line 95: RAISE FND_API.G_EXC_ERROR;

91:
92: ,x_atlv_tbl => x_atlv_tbl);
93:
94: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
95: RAISE FND_API.G_EXC_ERROR;
96: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: END IF;
99:

Line 96: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

92: ,x_atlv_tbl => x_atlv_tbl);
93:
94: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
95: RAISE FND_API.G_EXC_ERROR;
96: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: END IF;
99:
100: l_aesv_rec := x_aesv_rec;

Line 97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

93:
94: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
95: RAISE FND_API.G_EXC_ERROR;
96: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: END IF;
99:
100: l_aesv_rec := x_aesv_rec;
101: l_avlv_tbl := x_avlv_tbl;

Line 120: WHEN FND_API.G_EXC_ERROR THEN

116:
117:
118: EXCEPTION
119:
120: WHEN FND_API.G_EXC_ERROR THEN
121: ROLLBACK TO create_tmpt_set;
122: x_return_status := FND_API.G_RET_STS_ERROR;
123:
124: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 122: x_return_status := FND_API.G_RET_STS_ERROR;

118: EXCEPTION
119:
120: WHEN FND_API.G_EXC_ERROR THEN
121: ROLLBACK TO create_tmpt_set;
122: x_return_status := FND_API.G_RET_STS_ERROR;
123:
124: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
125: ,p_count => x_msg_count
126: ,p_data => x_msg_data);

Line 128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

124: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
125: ,p_count => x_msg_count
126: ,p_data => x_msg_data);
127:
128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
129: ROLLBACK TO create_tmpt_set;
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
132: ,p_count => x_msg_count

Line 130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

126: ,p_data => x_msg_data);
127:
128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
129: ROLLBACK TO create_tmpt_set;
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
132: ,p_count => x_msg_count
133: ,p_data => x_msg_data);
134:

Line 142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

138: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
139: ,p_count => x_msg_count
140: ,p_data => x_msg_data);
141: -- notify caller of an UNEXPECTED error
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143:
144:
145: END create_tmpt_set;
146:

Line 176: x_return_status := FND_API.G_RET_STS_SUCCESS;

172:
173: BEGIN
174:
175: SAVEPOINT create_tmpt_set;
176: x_return_status := FND_API.G_RET_STS_SUCCESS;
177:
178:
179:
180: -- customer pre-processing

Line 216: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

212: );
213:
214:
215:
216: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
217: RAISE FND_API.G_EXC_ERROR;
218: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
220: END IF;

Line 217: RAISE FND_API.G_EXC_ERROR;

213:
214:
215:
216: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
217: RAISE FND_API.G_EXC_ERROR;
218: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
220: END IF;
221:

Line 218: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

214:
215:
216: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
217: RAISE FND_API.G_EXC_ERROR;
218: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
220: END IF;
221:
222:

Line 219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

215:
216: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
217: RAISE FND_API.G_EXC_ERROR;
218: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
220: END IF;
221:
222:
223: l_aesv_rec := x_aesv_rec;

Line 241: WHEN FND_API.G_EXC_ERROR THEN

237:
238:
239: EXCEPTION
240:
241: WHEN FND_API.G_EXC_ERROR THEN
242: ROLLBACK TO create_tmpt_set;
243: x_return_status := FND_API.G_RET_STS_ERROR;
244:
245: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 243: x_return_status := FND_API.G_RET_STS_ERROR;

239: EXCEPTION
240:
241: WHEN FND_API.G_EXC_ERROR THEN
242: ROLLBACK TO create_tmpt_set;
243: x_return_status := FND_API.G_RET_STS_ERROR;
244:
245: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
246: ,p_count => x_msg_count
247: ,p_data => x_msg_data);

Line 249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

245: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
246: ,p_count => x_msg_count
247: ,p_data => x_msg_data);
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250: ROLLBACK TO create_tmpt_set;
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
253: ,p_count => x_msg_count

Line 251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

247: ,p_data => x_msg_data);
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250: ROLLBACK TO create_tmpt_set;
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
253: ,p_count => x_msg_count
254: ,p_data => x_msg_data);
255:

Line 263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

259: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
260: ,p_count => x_msg_count
261: ,p_data => x_msg_data);
262: -- notify caller of an UNEXPECTED error
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264:
265: END create_tmpt_set;
266:
267:

Line 301: x_return_status := FND_API.G_RET_STS_SUCCESS;

297:
298: --Initialize the return status
299:
300: SAVEPOINT create_tmpt_set;
301: x_return_status := FND_API.G_RET_STS_SUCCESS;
302:
303:
304:
305: -- customer pre-processing

Line 358: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

354: END IF;
355:
356: x_return_status := l_overall_status;
357:
358: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
359: RAISE FND_API.G_EXC_ERROR;
360: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
362: END IF;

Line 359: RAISE FND_API.G_EXC_ERROR;

355:
356: x_return_status := l_overall_status;
357:
358: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
359: RAISE FND_API.G_EXC_ERROR;
360: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
362: END IF;
363:

Line 360: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

356: x_return_status := l_overall_status;
357:
358: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
359: RAISE FND_API.G_EXC_ERROR;
360: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
362: END IF;
363:
364:

Line 361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

357:
358: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
359: RAISE FND_API.G_EXC_ERROR;
360: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
362: END IF;
363:
364:
365:

Line 382: WHEN FND_API.G_EXC_ERROR THEN

378:
379:
380: EXCEPTION
381:
382: WHEN FND_API.G_EXC_ERROR THEN
383: ROLLBACK TO create_tmpt_set;
384: x_return_status := FND_API.G_RET_STS_ERROR;
385:
386: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 384: x_return_status := FND_API.G_RET_STS_ERROR;

380: EXCEPTION
381:
382: WHEN FND_API.G_EXC_ERROR THEN
383: ROLLBACK TO create_tmpt_set;
384: x_return_status := FND_API.G_RET_STS_ERROR;
385:
386: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
387: ,p_count => x_msg_count
388: ,p_data => x_msg_data);

Line 390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

386: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
387: ,p_count => x_msg_count
388: ,p_data => x_msg_data);
389:
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
391: ROLLBACK TO create_tmpt_set;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
394: ,p_count => x_msg_count

Line 392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

388: ,p_data => x_msg_data);
389:
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
391: ROLLBACK TO create_tmpt_set;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
394: ,p_count => x_msg_count
395: ,p_data => x_msg_data);
396:

Line 404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

400: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
401: ,p_count => x_msg_count
402: ,p_data => x_msg_data);
403: -- notify caller of an UNEXPECTED error
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405:
406: END create_tmpt_set;
407:
408:

Line 451: x_return_status := FND_API.G_RET_STS_SUCCESS;

447:
448: BEGIN
449:
450: SAVEPOINT update_tmpt_set;
451: x_return_status := FND_API.G_RET_STS_SUCCESS;
452:
453:
454: -- customer pre-processing
455:

Line 498: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

494: ,x_atlv_tbl => x_atlv_tbl
495:
496: );
497:
498: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
499: RAISE FND_API.G_EXC_ERROR;
500: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502: END IF;

Line 499: RAISE FND_API.G_EXC_ERROR;

495:
496: );
497:
498: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
499: RAISE FND_API.G_EXC_ERROR;
500: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502: END IF;
503:

Line 500: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

496: );
497:
498: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
499: RAISE FND_API.G_EXC_ERROR;
500: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502: END IF;
503:
504: l_aesv_rec := x_aesv_rec;

Line 501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

497:
498: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
499: RAISE FND_API.G_EXC_ERROR;
500: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502: END IF;
503:
504: l_aesv_rec := x_aesv_rec;
505: l_avlv_tbl := x_avlv_tbl;

Line 524: WHEN FND_API.G_EXC_ERROR THEN

520:
521:
522: EXCEPTION
523:
524: WHEN FND_API.G_EXC_ERROR THEN
525: ROLLBACK TO update_tmpt_set;
526: x_return_status := FND_API.G_RET_STS_ERROR;
527:
528: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 526: x_return_status := FND_API.G_RET_STS_ERROR;

522: EXCEPTION
523:
524: WHEN FND_API.G_EXC_ERROR THEN
525: ROLLBACK TO update_tmpt_set;
526: x_return_status := FND_API.G_RET_STS_ERROR;
527:
528: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
529: ,p_count => x_msg_count
530: ,p_data => x_msg_data);

Line 532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

528: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
529: ,p_count => x_msg_count
530: ,p_data => x_msg_data);
531:
532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
533: ROLLBACK TO update_tmpt_set;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
536: ,p_count => x_msg_count

Line 534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

530: ,p_data => x_msg_data);
531:
532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
533: ROLLBACK TO update_tmpt_set;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
536: ,p_count => x_msg_count
537: ,p_data => x_msg_data);
538:

Line 546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

542: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
543: ,p_count => x_msg_count
544: ,p_data => x_msg_data);
545: -- notify caller of an UNEXPECTED error
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
547:
548: END update_tmpt_set;
549:
550:

Line 587: x_return_status := FND_API.G_RET_STS_SUCCESS;

583:
584: BEGIN
585:
586: SAVEPOINT validate_tmpt_set;
587: x_return_status := FND_API.G_RET_STS_SUCCESS;
588:
589:
590:
591: -- customer pre-processing

Line 629: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

625: );
626:
627:
628:
629: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
630: RAISE FND_API.G_EXC_ERROR;
631: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
633: END IF;

Line 630: RAISE FND_API.G_EXC_ERROR;

626:
627:
628:
629: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
630: RAISE FND_API.G_EXC_ERROR;
631: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
633: END IF;
634:

Line 631: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

627:
628:
629: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
630: RAISE FND_API.G_EXC_ERROR;
631: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
633: END IF;
634:
635:

Line 632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

628:
629: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
630: RAISE FND_API.G_EXC_ERROR;
631: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
633: END IF;
634:
635:
636:

Line 653: WHEN FND_API.G_EXC_ERROR THEN

649:
650:
651: EXCEPTION
652:
653: WHEN FND_API.G_EXC_ERROR THEN
654: ROLLBACK TO validate_tmpt_set;
655: x_return_status := FND_API.G_RET_STS_ERROR;
656:
657: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 655: x_return_status := FND_API.G_RET_STS_ERROR;

651: EXCEPTION
652:
653: WHEN FND_API.G_EXC_ERROR THEN
654: ROLLBACK TO validate_tmpt_set;
655: x_return_status := FND_API.G_RET_STS_ERROR;
656:
657: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
658: ,p_count => x_msg_count
659: ,p_data => x_msg_data);

Line 661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

657: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
658: ,p_count => x_msg_count
659: ,p_data => x_msg_data);
660:
661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
662: ROLLBACK TO validate_tmpt_set;
663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
664: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
665: ,p_count => x_msg_count

Line 663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

659: ,p_data => x_msg_data);
660:
661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
662: ROLLBACK TO validate_tmpt_set;
663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
664: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
665: ,p_count => x_msg_count
666: ,p_data => x_msg_data);
667:

Line 675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

671: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
672: ,p_count => x_msg_count
673: ,p_data => x_msg_data);
674: -- notify caller of an UNEXPECTED error
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676:
677: END validate_tmpt_set;
678:
679:

Line 705: x_return_status := FND_API.G_RET_STS_SUCCESS;

701:
702:
703: BEGIN
704:
705: x_return_status := FND_API.G_RET_STS_SUCCESS;
706: SAVEPOINT lock_tmpt_set;
707:
708:
709:

Line 726: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

722: ,p_aesv_rec => p_aesv_rec
723:
724: );
725:
726: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
727: RAISE FND_API.G_EXC_ERROR;
728: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
730: END IF;

Line 727: RAISE FND_API.G_EXC_ERROR;

723:
724: );
725:
726: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
727: RAISE FND_API.G_EXC_ERROR;
728: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
730: END IF;
731:

Line 728: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

724: );
725:
726: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
727: RAISE FND_API.G_EXC_ERROR;
728: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
730: END IF;
731:
732: EXCEPTION

Line 729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

725:
726: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
727: RAISE FND_API.G_EXC_ERROR;
728: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
730: END IF;
731:
732: EXCEPTION
733: WHEN FND_API.G_EXC_ERROR THEN

Line 733: WHEN FND_API.G_EXC_ERROR THEN

729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
730: END IF;
731:
732: EXCEPTION
733: WHEN FND_API.G_EXC_ERROR THEN
734: ROLLBACK TO lock_tmpt_set;
735: x_return_status := FND_API.G_RET_STS_ERROR;
736:
737: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 735: x_return_status := FND_API.G_RET_STS_ERROR;

731:
732: EXCEPTION
733: WHEN FND_API.G_EXC_ERROR THEN
734: ROLLBACK TO lock_tmpt_set;
735: x_return_status := FND_API.G_RET_STS_ERROR;
736:
737: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
738: ,p_count => x_msg_count
739: ,p_data => x_msg_data);

Line 741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

737: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
738: ,p_count => x_msg_count
739: ,p_data => x_msg_data);
740:
741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
742: ROLLBACK TO lock_tmpt_set;
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
744: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
745: ,p_count => x_msg_count

Line 743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

739: ,p_data => x_msg_data);
740:
741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
742: ROLLBACK TO lock_tmpt_set;
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
744: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
745: ,p_count => x_msg_count
746: ,p_data => x_msg_data);
747:

Line 755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

751: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
752: ,p_count => x_msg_count
753: ,p_data => x_msg_data);
754: -- notify caller of an UNEXPECTED error
755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
756:
757: END lock_tmpt_set;
758:
759:

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

777: l_api_name CONSTANT VARCHAR2(30) := 'lock_tmpt_set';
778:
779: i NUMBER;
780:
781: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
782:
783:
784:
785: BEGIN

Line 789: x_return_status := FND_API.G_RET_STS_SUCCESS;

785: BEGIN
786:
787: --Initialize the return status
788:
789: x_return_status := FND_API.G_RET_STS_SUCCESS;
790: SAVEPOINT lock_tmpt_set;
791:
792:
793: IF (p_aesv_tbl.COUNT > 0) THEN

Line 816: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

812:
813: );
814:
815: -- store the highest degree of error
816: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
817: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
818: l_overall_status := x_return_status;
819: END IF;
820: END IF;

Line 817: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

813: );
814:
815: -- store the highest degree of error
816: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
817: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
818: l_overall_status := x_return_status;
819: END IF;
820: END IF;
821: EXIT WHEN (i = p_aesv_tbl.LAST);

Line 831: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

827: l_return_status := l_overall_status;
828:
829: END IF;
830:
831: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
832: RAISE FND_API.G_EXC_ERROR;
833: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
835: END IF;

Line 832: RAISE FND_API.G_EXC_ERROR;

828:
829: END IF;
830:
831: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
832: RAISE FND_API.G_EXC_ERROR;
833: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
835: END IF;
836:

Line 833: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

829: END IF;
830:
831: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
832: RAISE FND_API.G_EXC_ERROR;
833: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
835: END IF;
836:
837: EXCEPTION

Line 834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

830:
831: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
832: RAISE FND_API.G_EXC_ERROR;
833: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
835: END IF;
836:
837: EXCEPTION
838: WHEN FND_API.G_EXC_ERROR THEN

Line 838: WHEN FND_API.G_EXC_ERROR THEN

834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
835: END IF;
836:
837: EXCEPTION
838: WHEN FND_API.G_EXC_ERROR THEN
839: ROLLBACK TO lock_tmpt_set;
840: x_return_status := FND_API.G_RET_STS_ERROR;
841:
842: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 840: x_return_status := FND_API.G_RET_STS_ERROR;

836:
837: EXCEPTION
838: WHEN FND_API.G_EXC_ERROR THEN
839: ROLLBACK TO lock_tmpt_set;
840: x_return_status := FND_API.G_RET_STS_ERROR;
841:
842: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
843: ,p_count => x_msg_count
844: ,p_data => x_msg_data);

Line 846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

844: ,p_data => x_msg_data);
845:
846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
847: ROLLBACK TO lock_tmpt_set;
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
849: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
850: ,p_count => x_msg_count
851: ,p_data => x_msg_data);
852:

Line 860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

856: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
857: ,p_count => x_msg_count
858: ,p_data => x_msg_data);
859: -- notify caller of an UNEXPECTED error
860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
861:
862: END lock_tmpt_set;
863:
864:

Line 893: x_return_status := FND_API.G_RET_STS_SUCCESS;

889:
890: BEGIN
891:
892: SAVEPOINT update_tmpt_set;
893: x_return_status := FND_API.G_RET_STS_SUCCESS;
894:
895:
896:
897: -- customer pre-processing

Line 931: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

927: ,x_aesv_rec => x_aesv_rec
928:
929: );
930:
931: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
932: RAISE FND_API.G_EXC_ERROR;
933: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
935: END IF;

Line 932: RAISE FND_API.G_EXC_ERROR;

928:
929: );
930:
931: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
932: RAISE FND_API.G_EXC_ERROR;
933: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
935: END IF;
936:

Line 933: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

929: );
930:
931: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
932: RAISE FND_API.G_EXC_ERROR;
933: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
935: END IF;
936:
937:

Line 934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

930:
931: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
932: RAISE FND_API.G_EXC_ERROR;
933: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
935: END IF;
936:
937:
938: l_aesv_rec := x_aesv_rec;

Line 957: WHEN FND_API.G_EXC_ERROR THEN

953:
954:
955: EXCEPTION
956:
957: WHEN FND_API.G_EXC_ERROR THEN
958: ROLLBACK TO update_tmpt_set;
959: x_return_status := FND_API.G_RET_STS_ERROR;
960:
961: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 959: x_return_status := FND_API.G_RET_STS_ERROR;

955: EXCEPTION
956:
957: WHEN FND_API.G_EXC_ERROR THEN
958: ROLLBACK TO update_tmpt_set;
959: x_return_status := FND_API.G_RET_STS_ERROR;
960:
961: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
962: ,p_count => x_msg_count
963: ,p_data => x_msg_data);

Line 965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

961: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
962: ,p_count => x_msg_count
963: ,p_data => x_msg_data);
964:
965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
966: ROLLBACK TO update_tmpt_set;
967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
968: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
969: ,p_count => x_msg_count

Line 967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

963: ,p_data => x_msg_data);
964:
965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
966: ROLLBACK TO update_tmpt_set;
967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
968: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
969: ,p_count => x_msg_count
970: ,p_data => x_msg_data);
971:

Line 979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

975: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
976: ,p_count => x_msg_count
977: ,p_data => x_msg_data);
978: -- notify caller of an UNEXPECTED error
979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
980:
981: END update_tmpt_set;
982:
983:

Line 1015: x_return_status := FND_API.G_RET_STS_SUCCESS;

1011:
1012: --Initialize the return status
1013:
1014: SAVEPOINT update_tmpt_set;
1015: x_return_status := FND_API.G_RET_STS_SUCCESS;
1016:
1017:
1018:
1019: -- customer pre-processing

Line 1072: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1068: END IF;
1069:
1070: x_return_status := l_overall_Status;
1071:
1072: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1073: RAISE FND_API.G_EXC_ERROR;
1074: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1076: END IF;

Line 1073: RAISE FND_API.G_EXC_ERROR;

1069:
1070: x_return_status := l_overall_Status;
1071:
1072: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1073: RAISE FND_API.G_EXC_ERROR;
1074: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1076: END IF;
1077:

Line 1074: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1070: x_return_status := l_overall_Status;
1071:
1072: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1073: RAISE FND_API.G_EXC_ERROR;
1074: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1076: END IF;
1077:
1078:

Line 1075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1071:
1072: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1073: RAISE FND_API.G_EXC_ERROR;
1074: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1076: END IF;
1077:
1078:
1079: l_aesv_tbl := x_aesv_tbl;

Line 1096: WHEN FND_API.G_EXC_ERROR THEN

1092:
1093:
1094: EXCEPTION
1095:
1096: WHEN FND_API.G_EXC_ERROR THEN
1097: ROLLBACK TO update_tmpt_set;
1098: x_return_status := FND_API.G_RET_STS_ERROR;
1099:
1100: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1098: x_return_status := FND_API.G_RET_STS_ERROR;

1094: EXCEPTION
1095:
1096: WHEN FND_API.G_EXC_ERROR THEN
1097: ROLLBACK TO update_tmpt_set;
1098: x_return_status := FND_API.G_RET_STS_ERROR;
1099:
1100: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1101: ,p_count => x_msg_count
1102: ,p_data => x_msg_data);

Line 1104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1100: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1101: ,p_count => x_msg_count
1102: ,p_data => x_msg_data);
1103:
1104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1105: ROLLBACK TO update_tmpt_set;
1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1107: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1108: ,p_count => x_msg_count

Line 1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1102: ,p_data => x_msg_data);
1103:
1104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1105: ROLLBACK TO update_tmpt_set;
1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1107: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1108: ,p_count => x_msg_count
1109: ,p_data => x_msg_data);
1110:

Line 1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1114: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1115: ,p_count => x_msg_count
1116: ,p_data => x_msg_data);
1117: -- notify caller of an UNEXPECTED error
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1119:
1120: END update_tmpt_set;
1121:
1122:

Line 1155: x_return_status := FND_API.G_RET_STS_SUCCESS;

1151:
1152: BEGIN
1153:
1154: SAVEPOINT delete_tmpt_set;
1155: x_return_status := FND_API.G_RET_STS_SUCCESS;
1156:
1157:
1158:
1159: -- customer pre-processing

Line 1193: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1189: );
1190:
1191:
1192:
1193: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1194: RAISE FND_API.G_EXC_ERROR;
1195: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1197: END IF;

Line 1194: RAISE FND_API.G_EXC_ERROR;

1190:
1191:
1192:
1193: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1194: RAISE FND_API.G_EXC_ERROR;
1195: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1197: END IF;
1198:

Line 1195: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1191:
1192:
1193: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1194: RAISE FND_API.G_EXC_ERROR;
1195: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1197: END IF;
1198:
1199:

Line 1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1192:
1193: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1194: RAISE FND_API.G_EXC_ERROR;
1195: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1197: END IF;
1198:
1199:
1200:

Line 1218: WHEN FND_API.G_EXC_ERROR THEN

1214:
1215:
1216: EXCEPTION
1217:
1218: WHEN FND_API.G_EXC_ERROR THEN
1219: ROLLBACK TO delete_tmpt_set;
1220: x_return_status := FND_API.G_RET_STS_ERROR;
1221:
1222: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1220: x_return_status := FND_API.G_RET_STS_ERROR;

1216: EXCEPTION
1217:
1218: WHEN FND_API.G_EXC_ERROR THEN
1219: ROLLBACK TO delete_tmpt_set;
1220: x_return_status := FND_API.G_RET_STS_ERROR;
1221:
1222: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1223: ,p_count => x_msg_count
1224: ,p_data => x_msg_data);

Line 1226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1222: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1223: ,p_count => x_msg_count
1224: ,p_data => x_msg_data);
1225:
1226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1227: ROLLBACK TO delete_tmpt_set;
1228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1229: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1230: ,p_count => x_msg_count

Line 1228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1224: ,p_data => x_msg_data);
1225:
1226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1227: ROLLBACK TO delete_tmpt_set;
1228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1229: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1230: ,p_count => x_msg_count
1231: ,p_data => x_msg_data);
1232:

Line 1240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1236: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1237: ,p_count => x_msg_count
1238: ,p_data => x_msg_data);
1239: -- notify caller of an UNEXPECTED error
1240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1241:
1242: END delete_tmpt_set;
1243:
1244:

Line 1274: x_return_status := FND_API.G_RET_STS_SUCCESS;

1270:
1271: --Initialize the return status
1272:
1273: SAVEPOINT delete_tmpt_set;
1274: x_return_status := FND_API.G_RET_STS_SUCCESS;
1275:
1276:
1277:
1278: -- customer pre-processing

Line 1330: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1326: END IF;
1327:
1328: x_return_status := l_overall_status;
1329:
1330: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1331: RAISE FND_API.G_EXC_ERROR;
1332: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: END IF;

Line 1331: RAISE FND_API.G_EXC_ERROR;

1327:
1328: x_return_status := l_overall_status;
1329:
1330: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1331: RAISE FND_API.G_EXC_ERROR;
1332: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: END IF;
1335:

Line 1332: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1328: x_return_status := l_overall_status;
1329:
1330: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1331: RAISE FND_API.G_EXC_ERROR;
1332: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: END IF;
1335:
1336:

Line 1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1329:
1330: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1331: RAISE FND_API.G_EXC_ERROR;
1332: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: END IF;
1335:
1336:
1337:

Line 1353: WHEN FND_API.G_EXC_ERROR THEN

1349:
1350:
1351: EXCEPTION
1352:
1353: WHEN FND_API.G_EXC_ERROR THEN
1354: ROLLBACK TO delete_tmpt_set;
1355: x_return_status := FND_API.G_RET_STS_ERROR;
1356:
1357: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1355: x_return_status := FND_API.G_RET_STS_ERROR;

1351: EXCEPTION
1352:
1353: WHEN FND_API.G_EXC_ERROR THEN
1354: ROLLBACK TO delete_tmpt_set;
1355: x_return_status := FND_API.G_RET_STS_ERROR;
1356:
1357: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1358: ,p_count => x_msg_count
1359: ,p_data => x_msg_data);

Line 1361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1357: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1358: ,p_count => x_msg_count
1359: ,p_data => x_msg_data);
1360:
1361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1362: ROLLBACK TO delete_tmpt_set;
1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1364: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1365: ,p_count => x_msg_count

Line 1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1359: ,p_data => x_msg_data);
1360:
1361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1362: ROLLBACK TO delete_tmpt_set;
1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1364: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1365: ,p_count => x_msg_count
1366: ,p_data => x_msg_data);
1367:

Line 1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1371: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1372: ,p_count => x_msg_count
1373: ,p_data => x_msg_data);
1374: -- notify caller of an UNEXPECTED error
1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1376:
1377: END delete_tmpt_set;
1378:
1379:

Line 1406: x_return_status := FND_API.G_RET_STS_SUCCESS;

1402:
1403: BEGIN
1404:
1405: SAVEPOINT validate_tmpt_set;
1406: x_return_status := FND_API.G_RET_STS_SUCCESS;
1407:
1408:
1409:
1410: -- customer pre-processing

Line 1444: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1440: ,p_aesv_rec => l_aesv_rec
1441:
1442: );
1443:
1444: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1445: RAISE FND_API.G_EXC_ERROR;
1446: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1448: END IF;

Line 1445: RAISE FND_API.G_EXC_ERROR;

1441:
1442: );
1443:
1444: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1445: RAISE FND_API.G_EXC_ERROR;
1446: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1448: END IF;
1449:

Line 1446: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1442: );
1443:
1444: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1445: RAISE FND_API.G_EXC_ERROR;
1446: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1448: END IF;
1449:
1450:

Line 1447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1443:
1444: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1445: RAISE FND_API.G_EXC_ERROR;
1446: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1448: END IF;
1449:
1450:
1451:

Line 1468: WHEN FND_API.G_EXC_ERROR THEN

1464:
1465:
1466: EXCEPTION
1467:
1468: WHEN FND_API.G_EXC_ERROR THEN
1469: ROLLBACK TO validate_tmpt_set;
1470: x_return_status := FND_API.G_RET_STS_ERROR;
1471:
1472: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1470: x_return_status := FND_API.G_RET_STS_ERROR;

1466: EXCEPTION
1467:
1468: WHEN FND_API.G_EXC_ERROR THEN
1469: ROLLBACK TO validate_tmpt_set;
1470: x_return_status := FND_API.G_RET_STS_ERROR;
1471:
1472: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1473: ,p_count => x_msg_count
1474: ,p_data => x_msg_data);

Line 1476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1472: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1473: ,p_count => x_msg_count
1474: ,p_data => x_msg_data);
1475:
1476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1477: ROLLBACK TO validate_tmpt_set;
1478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1479: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1480: ,p_count => x_msg_count

Line 1478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1474: ,p_data => x_msg_data);
1475:
1476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1477: ROLLBACK TO validate_tmpt_set;
1478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1479: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1480: ,p_count => x_msg_count
1481: ,p_data => x_msg_data);
1482:

Line 1490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1486: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1487: ,p_count => x_msg_count
1488: ,p_data => x_msg_data);
1489: -- notify caller of an UNEXPECTED error
1490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1491:
1492: END validate_tmpt_set;
1493:
1494:

Line 1524: x_return_status := FND_API.G_RET_STS_SUCCESS;

1520:
1521: --Initialize the return status
1522:
1523: SAVEPOINT validate_tmpt_set;
1524: x_return_status := FND_API.G_RET_STS_SUCCESS;
1525:
1526:
1527:
1528: -- customer pre-processing

Line 1578: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1574: END IF;
1575:
1576: x_return_status := l_overall_status;
1577:
1578: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1579: RAISE FND_API.G_EXC_ERROR;
1580: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1582: END IF;

Line 1579: RAISE FND_API.G_EXC_ERROR;

1575:
1576: x_return_status := l_overall_status;
1577:
1578: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1579: RAISE FND_API.G_EXC_ERROR;
1580: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1582: END IF;
1583:

Line 1580: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1576: x_return_status := l_overall_status;
1577:
1578: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1579: RAISE FND_API.G_EXC_ERROR;
1580: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1582: END IF;
1583:
1584:

Line 1581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1577:
1578: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1579: RAISE FND_API.G_EXC_ERROR;
1580: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1582: END IF;
1583:
1584:
1585: -- vertical industry-post-processing

Line 1601: WHEN FND_API.G_EXC_ERROR THEN

1597:
1598:
1599: EXCEPTION
1600:
1601: WHEN FND_API.G_EXC_ERROR THEN
1602: ROLLBACK TO validate_tmpt_set;
1603: x_return_status := FND_API.G_RET_STS_ERROR;
1604:
1605: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1603: x_return_status := FND_API.G_RET_STS_ERROR;

1599: EXCEPTION
1600:
1601: WHEN FND_API.G_EXC_ERROR THEN
1602: ROLLBACK TO validate_tmpt_set;
1603: x_return_status := FND_API.G_RET_STS_ERROR;
1604:
1605: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1606: ,p_count => x_msg_count
1607: ,p_data => x_msg_data);

Line 1609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1605: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1606: ,p_count => x_msg_count
1607: ,p_data => x_msg_data);
1608:
1609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1610: ROLLBACK TO validate_tmpt_set;
1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1612: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1613: ,p_count => x_msg_count

Line 1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1607: ,p_data => x_msg_data);
1608:
1609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1610: ROLLBACK TO validate_tmpt_set;
1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1612: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1613: ,p_count => x_msg_count
1614: ,p_data => x_msg_data);
1615:

Line 1623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1619: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1620: ,p_count => x_msg_count
1621: ,p_data => x_msg_data);
1622: -- notify caller of an UNEXPECTED error
1623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1624:
1625: END validate_tmpt_set;
1626:
1627:

Line 1658: x_return_status := FND_API.G_RET_STS_SUCCESS;

1654:
1655: BEGIN
1656:
1657: SAVEPOINT create_template;
1658: x_return_status := FND_API.G_RET_STS_SUCCESS;
1659:
1660:
1661:
1662: -- customer pre-processing

Line 1700: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1696: ,x_avlv_rec => x_avlv_rec
1697:
1698: );
1699:
1700: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1701: RAISE FND_API.G_EXC_ERROR;
1702: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1704: END IF;

Line 1701: RAISE FND_API.G_EXC_ERROR;

1697:
1698: );
1699:
1700: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1701: RAISE FND_API.G_EXC_ERROR;
1702: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1704: END IF;
1705:

Line 1702: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1698: );
1699:
1700: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1701: RAISE FND_API.G_EXC_ERROR;
1702: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1704: END IF;
1705:
1706: l_avlv_rec := x_avlv_rec;

Line 1703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1699:
1700: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1701: RAISE FND_API.G_EXC_ERROR;
1702: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1704: END IF;
1705:
1706: l_avlv_rec := x_avlv_rec;
1707:

Line 1724: WHEN FND_API.G_EXC_ERROR THEN

1720:
1721:
1722: EXCEPTION
1723:
1724: WHEN FND_API.G_EXC_ERROR THEN
1725: ROLLBACK TO create_template;
1726: x_return_status := FND_API.G_RET_STS_ERROR;
1727:
1728: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1726: x_return_status := FND_API.G_RET_STS_ERROR;

1722: EXCEPTION
1723:
1724: WHEN FND_API.G_EXC_ERROR THEN
1725: ROLLBACK TO create_template;
1726: x_return_status := FND_API.G_RET_STS_ERROR;
1727:
1728: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1729: ,p_count => x_msg_count
1730: ,p_data => x_msg_data);

Line 1732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1728: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1729: ,p_count => x_msg_count
1730: ,p_data => x_msg_data);
1731:
1732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1733: ROLLBACK TO create_template;
1734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1735: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1736: ,p_count => x_msg_count

Line 1734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1730: ,p_data => x_msg_data);
1731:
1732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1733: ROLLBACK TO create_template;
1734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1735: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1736: ,p_count => x_msg_count
1737: ,p_data => x_msg_data);
1738:

Line 1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1742: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1743: ,p_count => x_msg_count
1744: ,p_data => x_msg_data);
1745: -- notify caller of an UNEXPECTED error
1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1747:
1748: END create_template;
1749:
1750:

Line 1785: x_return_status := FND_API.G_RET_STS_SUCCESS;

1781:
1782: --Initialize the return status
1783:
1784: SAVEPOINT create_template;
1785: x_return_status := FND_API.G_RET_STS_SUCCESS;
1786:
1787:
1788:
1789: -- customer pre-processing

Line 1845: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1841: END IF;
1842:
1843: x_return_status := l_overall_status ;
1844:
1845: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1846: RAISE FND_API.G_EXC_ERROR;
1847: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1849: END IF;

Line 1846: RAISE FND_API.G_EXC_ERROR;

1842:
1843: x_return_status := l_overall_status ;
1844:
1845: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1846: RAISE FND_API.G_EXC_ERROR;
1847: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1849: END IF;
1850:

Line 1847: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1843: x_return_status := l_overall_status ;
1844:
1845: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1846: RAISE FND_API.G_EXC_ERROR;
1847: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1849: END IF;
1850:
1851: l_avlv_tbl := x_avlv_tbl;

Line 1848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1844:
1845: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1846: RAISE FND_API.G_EXC_ERROR;
1847: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1849: END IF;
1850:
1851: l_avlv_tbl := x_avlv_tbl;
1852:

Line 1869: WHEN FND_API.G_EXC_ERROR THEN

1865:
1866:
1867: EXCEPTION
1868:
1869: WHEN FND_API.G_EXC_ERROR THEN
1870: ROLLBACK TO create_template;
1871: x_return_status := FND_API.G_RET_STS_ERROR;
1872:
1873: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1871: x_return_status := FND_API.G_RET_STS_ERROR;

1867: EXCEPTION
1868:
1869: WHEN FND_API.G_EXC_ERROR THEN
1870: ROLLBACK TO create_template;
1871: x_return_status := FND_API.G_RET_STS_ERROR;
1872:
1873: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1874: ,p_count => x_msg_count
1875: ,p_data => x_msg_data);

Line 1877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1873: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1874: ,p_count => x_msg_count
1875: ,p_data => x_msg_data);
1876:
1877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1878: ROLLBACK TO create_template;
1879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1880: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1881: ,p_count => x_msg_count

Line 1879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1875: ,p_data => x_msg_data);
1876:
1877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1878: ROLLBACK TO create_template;
1879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1880: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1881: ,p_count => x_msg_count
1882: ,p_data => x_msg_data);
1883:

Line 1891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1887: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1888: ,p_count => x_msg_count
1889: ,p_data => x_msg_data);
1890: -- notify caller of an UNEXPECTED error
1891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1892:
1893: END create_template;
1894:
1895:

Line 1917: x_return_status := FND_API.G_RET_STS_SUCCESS;

1913: l_api_name CONSTANT VARCHAR2(30) := 'lock_template';
1914:
1915: BEGIN
1916:
1917: x_return_status := FND_API.G_RET_STS_SUCCESS;
1918: SAVEPOINT lock_template;
1919:
1920:
1921: okl_tmpt_set_pvt.lock_template(

Line 1937: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1933: ,p_avlv_rec => p_avlv_rec
1934:
1935: );
1936:
1937: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1938: RAISE FND_API.G_EXC_ERROR;
1939: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1941: END IF;

Line 1938: RAISE FND_API.G_EXC_ERROR;

1934:
1935: );
1936:
1937: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1938: RAISE FND_API.G_EXC_ERROR;
1939: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1941: END IF;
1942:

Line 1939: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1935: );
1936:
1937: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1938: RAISE FND_API.G_EXC_ERROR;
1939: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1941: END IF;
1942:
1943: EXCEPTION

Line 1940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1936:
1937: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1938: RAISE FND_API.G_EXC_ERROR;
1939: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1941: END IF;
1942:
1943: EXCEPTION
1944: WHEN FND_API.G_EXC_ERROR THEN

Line 1944: WHEN FND_API.G_EXC_ERROR THEN

1940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1941: END IF;
1942:
1943: EXCEPTION
1944: WHEN FND_API.G_EXC_ERROR THEN
1945: ROLLBACK TO lock_template;
1946: x_return_status := FND_API.G_RET_STS_ERROR;
1947:
1948: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 1946: x_return_status := FND_API.G_RET_STS_ERROR;

1942:
1943: EXCEPTION
1944: WHEN FND_API.G_EXC_ERROR THEN
1945: ROLLBACK TO lock_template;
1946: x_return_status := FND_API.G_RET_STS_ERROR;
1947:
1948: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1949: ,p_count => x_msg_count
1950: ,p_data => x_msg_data);

Line 1952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1948: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1949: ,p_count => x_msg_count
1950: ,p_data => x_msg_data);
1951:
1952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1953: ROLLBACK TO lock_template;
1954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1955: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1956: ,p_count => x_msg_count

Line 1954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1950: ,p_data => x_msg_data);
1951:
1952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1953: ROLLBACK TO lock_template;
1954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1955: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1956: ,p_count => x_msg_count
1957: ,p_data => x_msg_data);
1958:

Line 1966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1962: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1963: ,p_count => x_msg_count
1964: ,p_data => x_msg_data);
1965: -- notify caller of an UNEXPECTED error
1966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1967:
1968: END lock_template;
1969:
1970:

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

1988: l_api_name CONSTANT VARCHAR2(30) := 'lock_template';
1989:
1990: i NUMBER;
1991:
1992: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1993:
1994:
1995:
1996: BEGIN

Line 2000: x_return_status := FND_API.G_RET_STS_SUCCESS;

1996: BEGIN
1997:
1998: --Initialize the return status
1999:
2000: x_return_status := FND_API.G_RET_STS_SUCCESS;
2001: SAVEPOINT lock_template;
2002:
2003:
2004: IF (p_avlv_tbl.COUNT > 0) THEN

Line 2027: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2023:
2024: );
2025:
2026: -- store the highest degree of error
2027: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2028: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2029: l_overall_status := x_return_status;
2030: END IF;
2031: END IF;

Line 2028: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

2024: );
2025:
2026: -- store the highest degree of error
2027: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2028: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2029: l_overall_status := x_return_status;
2030: END IF;
2031: END IF;
2032: EXIT WHEN (i = p_avlv_tbl.LAST);

Line 2042: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2038: l_return_status := l_overall_status;
2039:
2040: END IF;
2041:
2042: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2043: RAISE FND_API.G_EXC_ERROR;
2044: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2046: END IF;

Line 2043: RAISE FND_API.G_EXC_ERROR;

2039:
2040: END IF;
2041:
2042: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2043: RAISE FND_API.G_EXC_ERROR;
2044: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2046: END IF;
2047:

Line 2044: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2040: END IF;
2041:
2042: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2043: RAISE FND_API.G_EXC_ERROR;
2044: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2046: END IF;
2047:
2048: EXCEPTION

Line 2045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2041:
2042: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2043: RAISE FND_API.G_EXC_ERROR;
2044: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2046: END IF;
2047:
2048: EXCEPTION
2049: WHEN FND_API.G_EXC_ERROR THEN

Line 2049: WHEN FND_API.G_EXC_ERROR THEN

2045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2046: END IF;
2047:
2048: EXCEPTION
2049: WHEN FND_API.G_EXC_ERROR THEN
2050: ROLLBACK TO lock_template;
2051: x_return_status := FND_API.G_RET_STS_ERROR;
2052:
2053: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 2051: x_return_status := FND_API.G_RET_STS_ERROR;

2047:
2048: EXCEPTION
2049: WHEN FND_API.G_EXC_ERROR THEN
2050: ROLLBACK TO lock_template;
2051: x_return_status := FND_API.G_RET_STS_ERROR;
2052:
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);

Line 2057: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2053: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2054: ,p_count => x_msg_count
2055: ,p_data => x_msg_data);
2056:
2057: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2058: ROLLBACK TO lock_template;
2059: 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

Line 2059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2055: ,p_data => x_msg_data);
2056:
2057: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2058: ROLLBACK TO lock_template;
2059: 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:

Line 2071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2067: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2068: ,p_count => x_msg_count
2069: ,p_data => x_msg_data);
2070: -- notify caller of an UNEXPECTED error
2071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2072:
2073: END lock_template;
2074:
2075:

Line 2102: x_return_status := FND_API.G_RET_STS_SUCCESS;

2098:
2099: BEGIN
2100:
2101: SAVEPOINT update_template;
2102: x_return_status := FND_API.G_RET_STS_SUCCESS;
2103:
2104:
2105:
2106:

Line 2141: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2137: ,x_avlv_rec => x_avlv_rec
2138:
2139: );
2140:
2141: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2142: RAISE FND_API.G_EXC_ERROR;
2143: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2145: END IF;

Line 2142: RAISE FND_API.G_EXC_ERROR;

2138:
2139: );
2140:
2141: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2142: RAISE FND_API.G_EXC_ERROR;
2143: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2145: END IF;
2146:

Line 2143: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2139: );
2140:
2141: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2142: RAISE FND_API.G_EXC_ERROR;
2143: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2145: END IF;
2146:
2147:

Line 2144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2140:
2141: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2142: RAISE FND_API.G_EXC_ERROR;
2143: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2145: END IF;
2146:
2147:
2148: l_avlv_rec := x_avlv_rec;

Line 2166: WHEN FND_API.G_EXC_ERROR THEN

2162:
2163:
2164: EXCEPTION
2165:
2166: WHEN FND_API.G_EXC_ERROR THEN
2167: ROLLBACK TO update_template;
2168: x_return_status := FND_API.G_RET_STS_ERROR;
2169:
2170: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 2168: x_return_status := FND_API.G_RET_STS_ERROR;

2164: EXCEPTION
2165:
2166: WHEN FND_API.G_EXC_ERROR THEN
2167: ROLLBACK TO update_template;
2168: x_return_status := FND_API.G_RET_STS_ERROR;
2169:
2170: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2171: ,p_count => x_msg_count
2172: ,p_data => x_msg_data);

Line 2174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2170: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2171: ,p_count => x_msg_count
2172: ,p_data => x_msg_data);
2173:
2174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2175: ROLLBACK TO update_template;
2176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2177: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2178: ,p_count => x_msg_count

Line 2176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2172: ,p_data => x_msg_data);
2173:
2174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2175: ROLLBACK TO update_template;
2176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2177: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2178: ,p_count => x_msg_count
2179: ,p_data => x_msg_data);
2180:

Line 2188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2184: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2185: ,p_count => x_msg_count
2186: ,p_data => x_msg_data);
2187: -- notify caller of an UNEXPECTED error
2188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2189:
2190: END update_template;
2191:
2192:

Line 2224: x_return_status := FND_API.G_RET_STS_SUCCESS;

2220:
2221: --Initialize the return status
2222:
2223: SAVEPOINT update_template;
2224: x_return_status := FND_API.G_RET_STS_SUCCESS;
2225:
2226:
2227:
2228:

Line 2280: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2276: END IF;
2277:
2278: x_return_status := l_overall_status;
2279:
2280: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2281: RAISE FND_API.G_EXC_ERROR;
2282: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2284: END IF;

Line 2281: RAISE FND_API.G_EXC_ERROR;

2277:
2278: x_return_status := l_overall_status;
2279:
2280: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2281: RAISE FND_API.G_EXC_ERROR;
2282: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2284: END IF;
2285:

Line 2282: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2278: x_return_status := l_overall_status;
2279:
2280: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2281: RAISE FND_API.G_EXC_ERROR;
2282: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2284: END IF;
2285:
2286:

Line 2283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2279:
2280: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2281: RAISE FND_API.G_EXC_ERROR;
2282: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2284: END IF;
2285:
2286:
2287: l_avlv_tbl := x_avlv_tbl;

Line 2306: WHEN FND_API.G_EXC_ERROR THEN

2302:
2303:
2304: EXCEPTION
2305:
2306: WHEN FND_API.G_EXC_ERROR THEN
2307: ROLLBACK TO update_template;
2308: x_return_status := FND_API.G_RET_STS_ERROR;
2309:
2310: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 2308: x_return_status := FND_API.G_RET_STS_ERROR;

2304: EXCEPTION
2305:
2306: WHEN FND_API.G_EXC_ERROR THEN
2307: ROLLBACK TO update_template;
2308: x_return_status := FND_API.G_RET_STS_ERROR;
2309:
2310: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2311: ,p_count => x_msg_count
2312: ,p_data => x_msg_data);

Line 2314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2310: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2311: ,p_count => x_msg_count
2312: ,p_data => x_msg_data);
2313:
2314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2315: ROLLBACK TO update_template;
2316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2317: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2318: ,p_count => x_msg_count

Line 2316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2312: ,p_data => x_msg_data);
2313:
2314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2315: ROLLBACK TO update_template;
2316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2317: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2318: ,p_count => x_msg_count
2319: ,p_data => x_msg_data);
2320:

Line 2328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2324: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2325: ,p_count => x_msg_count
2326: ,p_data => x_msg_data);
2327: -- notify caller of an UNEXPECTED error
2328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2329:
2330: END update_template;
2331:
2332:

Line 2361: x_return_status := FND_API.G_RET_STS_SUCCESS;

2357:
2358: BEGIN
2359:
2360: SAVEPOINT delete_template;
2361: x_return_status := FND_API.G_RET_STS_SUCCESS;
2362:
2363:
2364:
2365: -- customer pre-processing

Line 2397: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2393: ,x_msg_data => x_msg_data
2394:
2395: ,p_avlv_rec => l_avlv_rec);
2396:
2397: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2398: RAISE FND_API.G_EXC_ERROR;
2399: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2401: END IF;

Line 2398: RAISE FND_API.G_EXC_ERROR;

2394:
2395: ,p_avlv_rec => l_avlv_rec);
2396:
2397: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2398: RAISE FND_API.G_EXC_ERROR;
2399: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2401: END IF;
2402:

Line 2399: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2395: ,p_avlv_rec => l_avlv_rec);
2396:
2397: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2398: RAISE FND_API.G_EXC_ERROR;
2399: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2401: END IF;
2402:
2403:

Line 2400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2396:
2397: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2398: RAISE FND_API.G_EXC_ERROR;
2399: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2401: END IF;
2402:
2403:
2404:

Line 2422: WHEN FND_API.G_EXC_ERROR THEN

2418:
2419:
2420: EXCEPTION
2421:
2422: WHEN FND_API.G_EXC_ERROR THEN
2423: ROLLBACK TO delete_template;
2424: x_return_status := FND_API.G_RET_STS_ERROR;
2425:
2426: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 2424: x_return_status := FND_API.G_RET_STS_ERROR;

2420: EXCEPTION
2421:
2422: WHEN FND_API.G_EXC_ERROR THEN
2423: ROLLBACK TO delete_template;
2424: x_return_status := FND_API.G_RET_STS_ERROR;
2425:
2426: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2427: ,p_count => x_msg_count
2428: ,p_data => x_msg_data);

Line 2430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2426: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2427: ,p_count => x_msg_count
2428: ,p_data => x_msg_data);
2429:
2430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2431: ROLLBACK TO delete_template;
2432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2433: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2434: ,p_count => x_msg_count

Line 2432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2428: ,p_data => x_msg_data);
2429:
2430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2431: ROLLBACK TO delete_template;
2432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2433: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2434: ,p_count => x_msg_count
2435: ,p_data => x_msg_data);
2436:

Line 2444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2440: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2441: ,p_count => x_msg_count
2442: ,p_data => x_msg_data);
2443: -- notify caller of an UNEXPECTED error
2444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2445:
2446: END delete_template;
2447:
2448:

Line 2481: x_return_status := FND_API.G_RET_STS_SUCCESS;

2477:
2478: --Initialize the return status
2479:
2480: SAVEPOINT delete_template;
2481: x_return_status := FND_API.G_RET_STS_SUCCESS;
2482:
2483:
2484:
2485: -- customer pre-processing

Line 2534: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2530: END IF;
2531:
2532: x_return_status := l_overall_status;
2533:
2534: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2535: RAISE FND_API.G_EXC_ERROR;
2536: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2538: END IF;

Line 2535: RAISE FND_API.G_EXC_ERROR;

2531:
2532: x_return_status := l_overall_status;
2533:
2534: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2535: RAISE FND_API.G_EXC_ERROR;
2536: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2538: END IF;
2539:

Line 2536: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2532: x_return_status := l_overall_status;
2533:
2534: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2535: RAISE FND_API.G_EXC_ERROR;
2536: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2538: END IF;
2539:
2540:

Line 2537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2533:
2534: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2535: RAISE FND_API.G_EXC_ERROR;
2536: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2538: END IF;
2539:
2540:
2541:

Line 2560: WHEN FND_API.G_EXC_ERROR THEN

2556:
2557:
2558: EXCEPTION
2559:
2560: WHEN FND_API.G_EXC_ERROR THEN
2561: ROLLBACK TO delete_template;
2562: x_return_status := FND_API.G_RET_STS_ERROR;
2563:
2564: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 2562: x_return_status := FND_API.G_RET_STS_ERROR;

2558: EXCEPTION
2559:
2560: WHEN FND_API.G_EXC_ERROR THEN
2561: ROLLBACK TO delete_template;
2562: x_return_status := FND_API.G_RET_STS_ERROR;
2563:
2564: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2565: ,p_count => x_msg_count
2566: ,p_data => x_msg_data);

Line 2568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2564: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2565: ,p_count => x_msg_count
2566: ,p_data => x_msg_data);
2567:
2568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2569: ROLLBACK TO delete_template;
2570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2571: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2572: ,p_count => x_msg_count

Line 2570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2566: ,p_data => x_msg_data);
2567:
2568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2569: ROLLBACK TO delete_template;
2570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2571: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2572: ,p_count => x_msg_count
2573: ,p_data => x_msg_data);
2574:

Line 2582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2578: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2579: ,p_count => x_msg_count
2580: ,p_data => x_msg_data);
2581: -- notify caller of an UNEXPECTED error
2582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2583:
2584:
2585: END delete_template;
2586:

Line 2612: x_return_status := FND_API.G_RET_STS_SUCCESS;

2608:
2609: BEGIN
2610:
2611: SAVEPOINT validate_template;
2612: x_return_status := FND_API.G_RET_STS_SUCCESS;
2613:
2614:
2615:
2616: -- customer pre-processing

Line 2650: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2646: ,p_avlv_rec => l_avlv_rec
2647:
2648: );
2649:
2650: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2651: RAISE FND_API.G_EXC_ERROR;
2652: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2654: END IF;

Line 2651: RAISE FND_API.G_EXC_ERROR;

2647:
2648: );
2649:
2650: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2651: RAISE FND_API.G_EXC_ERROR;
2652: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2654: END IF;
2655:

Line 2652: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2648: );
2649:
2650: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2651: RAISE FND_API.G_EXC_ERROR;
2652: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2654: END IF;
2655:
2656:

Line 2653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2649:
2650: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2651: RAISE FND_API.G_EXC_ERROR;
2652: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2654: END IF;
2655:
2656:
2657:

Line 2674: WHEN FND_API.G_EXC_ERROR THEN

2670:
2671:
2672: EXCEPTION
2673:
2674: WHEN FND_API.G_EXC_ERROR THEN
2675: ROLLBACK TO validate_template;
2676: x_return_status := FND_API.G_RET_STS_ERROR;
2677:
2678: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 2676: x_return_status := FND_API.G_RET_STS_ERROR;

2672: EXCEPTION
2673:
2674: WHEN FND_API.G_EXC_ERROR THEN
2675: ROLLBACK TO validate_template;
2676: x_return_status := FND_API.G_RET_STS_ERROR;
2677:
2678: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2679: ,p_count => x_msg_count
2680: ,p_data => x_msg_data);

Line 2682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2678: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2679: ,p_count => x_msg_count
2680: ,p_data => x_msg_data);
2681:
2682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2683: ROLLBACK TO validate_template;
2684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2685: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2686: ,p_count => x_msg_count

Line 2684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2680: ,p_data => x_msg_data);
2681:
2682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2683: ROLLBACK TO validate_template;
2684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2685: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2686: ,p_count => x_msg_count
2687: ,p_data => x_msg_data);
2688:

Line 2696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2692: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2693: ,p_count => x_msg_count
2694: ,p_data => x_msg_data);
2695: -- notify caller of an UNEXPECTED error
2696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2697:
2698: END validate_template;
2699:
2700:

Line 2731: x_return_status := FND_API.G_RET_STS_SUCCESS;

2727:
2728: --Initialize the return status
2729:
2730: SAVEPOINT validate_template;
2731: x_return_status := FND_API.G_RET_STS_SUCCESS;
2732:
2733:
2734:
2735: -- customer pre-processing

Line 2785: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2781: END IF;
2782:
2783: x_return_status := l_overall_status;
2784:
2785: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2786: RAISE FND_API.G_EXC_ERROR;
2787: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2789: END IF;

Line 2786: RAISE FND_API.G_EXC_ERROR;

2782:
2783: x_return_status := l_overall_status;
2784:
2785: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2786: RAISE FND_API.G_EXC_ERROR;
2787: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2789: END IF;
2790:

Line 2787: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2783: x_return_status := l_overall_status;
2784:
2785: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2786: RAISE FND_API.G_EXC_ERROR;
2787: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2789: END IF;
2790:
2791:

Line 2788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2784:
2785: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2786: RAISE FND_API.G_EXC_ERROR;
2787: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2789: END IF;
2790:
2791:
2792:

Line 2809: WHEN FND_API.G_EXC_ERROR THEN

2805:
2806:
2807: EXCEPTION
2808:
2809: WHEN FND_API.G_EXC_ERROR THEN
2810: ROLLBACK TO validate_template;
2811: x_return_status := FND_API.G_RET_STS_ERROR;
2812:
2813: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 2811: x_return_status := FND_API.G_RET_STS_ERROR;

2807: EXCEPTION
2808:
2809: WHEN FND_API.G_EXC_ERROR THEN
2810: ROLLBACK TO validate_template;
2811: x_return_status := FND_API.G_RET_STS_ERROR;
2812:
2813: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2814: ,p_count => x_msg_count
2815: ,p_data => x_msg_data);

Line 2817: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2813: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2814: ,p_count => x_msg_count
2815: ,p_data => x_msg_data);
2816:
2817: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2818: ROLLBACK TO validate_template;
2819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2820: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2821: ,p_count => x_msg_count

Line 2819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2815: ,p_data => x_msg_data);
2816:
2817: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2818: ROLLBACK TO validate_template;
2819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2820: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2821: ,p_count => x_msg_count
2822: ,p_data => x_msg_data);
2823:

Line 2831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2827: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2828: ,p_count => x_msg_count
2829: ,p_data => x_msg_data);
2830: -- notify caller of an UNEXPECTED error
2831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2832:
2833: END validate_template;
2834:
2835:

Line 2865: x_return_status := FND_API.G_RET_STS_SUCCESS;

2861:
2862: BEGIN
2863:
2864: SAVEPOINT create_tmpt_lines;
2865: x_return_status := FND_API.G_RET_STS_SUCCESS;
2866:
2867:
2868:
2869: -- customer pre-processing

Line 2907: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2903: ,x_atlv_rec => x_atlv_rec
2904:
2905: );
2906:
2907: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2908: RAISE FND_API.G_EXC_ERROR;
2909: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2911: END IF;

Line 2908: RAISE FND_API.G_EXC_ERROR;

2904:
2905: );
2906:
2907: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2908: RAISE FND_API.G_EXC_ERROR;
2909: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2911: END IF;
2912:

Line 2909: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2905: );
2906:
2907: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2908: RAISE FND_API.G_EXC_ERROR;
2909: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2911: END IF;
2912:
2913:

Line 2910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2906:
2907: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2908: RAISE FND_API.G_EXC_ERROR;
2909: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2911: END IF;
2912:
2913:
2914: l_atlv_rec := x_atlv_rec;

Line 2931: WHEN FND_API.G_EXC_ERROR THEN

2927:
2928:
2929: EXCEPTION
2930:
2931: WHEN FND_API.G_EXC_ERROR THEN
2932: ROLLBACK TO create_tmpt_lines;
2933: x_return_status := FND_API.G_RET_STS_ERROR;
2934:
2935: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 2933: x_return_status := FND_API.G_RET_STS_ERROR;

2929: EXCEPTION
2930:
2931: WHEN FND_API.G_EXC_ERROR THEN
2932: ROLLBACK TO create_tmpt_lines;
2933: x_return_status := FND_API.G_RET_STS_ERROR;
2934:
2935: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2936: ,p_count => x_msg_count
2937: ,p_data => x_msg_data);

Line 2939: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2935: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2936: ,p_count => x_msg_count
2937: ,p_data => x_msg_data);
2938:
2939: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2940: ROLLBACK TO create_tmpt_lines;
2941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2942: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2943: ,p_count => x_msg_count

Line 2941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2937: ,p_data => x_msg_data);
2938:
2939: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2940: ROLLBACK TO create_tmpt_lines;
2941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2942: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2943: ,p_count => x_msg_count
2944: ,p_data => x_msg_data);
2945:

Line 2953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2949: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2950: ,p_count => x_msg_count
2951: ,p_data => x_msg_data);
2952: -- notify caller of an UNEXPECTED error
2953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2954:
2955: END create_tmpt_lines;
2956:
2957:

Line 2991: x_return_status := FND_API.G_RET_STS_SUCCESS;

2987:
2988: --Initialize the return status
2989:
2990: SAVEPOINT create_tmpt_lines;
2991: x_return_status := FND_API.G_RET_STS_SUCCESS;
2992:
2993:
2994:
2995: -- customer pre-processing

Line 3051: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3047:
3048: x_return_status := l_overall_Status;
3049:
3050:
3051: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3052: RAISE FND_API.G_EXC_ERROR;
3053: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3055: END IF;

Line 3052: RAISE FND_API.G_EXC_ERROR;

3048: x_return_status := l_overall_Status;
3049:
3050:
3051: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3052: RAISE FND_API.G_EXC_ERROR;
3053: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3055: END IF;
3056:

Line 3053: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3049:
3050:
3051: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3052: RAISE FND_API.G_EXC_ERROR;
3053: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3055: END IF;
3056:
3057:

Line 3054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3050:
3051: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3052: RAISE FND_API.G_EXC_ERROR;
3053: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3055: END IF;
3056:
3057:
3058: l_atlv_tbl := x_atlv_tbl;

Line 3075: WHEN FND_API.G_EXC_ERROR THEN

3071:
3072:
3073: EXCEPTION
3074:
3075: WHEN FND_API.G_EXC_ERROR THEN
3076: ROLLBACK TO create_tmpt_lines;
3077: x_return_status := FND_API.G_RET_STS_ERROR;
3078:
3079: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 3077: x_return_status := FND_API.G_RET_STS_ERROR;

3073: EXCEPTION
3074:
3075: WHEN FND_API.G_EXC_ERROR THEN
3076: ROLLBACK TO create_tmpt_lines;
3077: x_return_status := FND_API.G_RET_STS_ERROR;
3078:
3079: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3080: ,p_count => x_msg_count
3081: ,p_data => x_msg_data);

Line 3083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3079: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3080: ,p_count => x_msg_count
3081: ,p_data => x_msg_data);
3082:
3083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3084: ROLLBACK TO create_tmpt_lines;
3085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3086: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3087: ,p_count => x_msg_count

Line 3085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3081: ,p_data => x_msg_data);
3082:
3083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3084: ROLLBACK TO create_tmpt_lines;
3085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3086: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3087: ,p_count => x_msg_count
3088: ,p_data => x_msg_data);
3089:

Line 3097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3093: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3094: ,p_count => x_msg_count
3095: ,p_data => x_msg_data);
3096: -- notify caller of an UNEXPECTED error
3097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3098:
3099: END create_tmpt_lines;
3100:
3101:

Line 3123: x_return_status := FND_API.G_RET_STS_SUCCESS;

3119: l_api_name CONSTANT VARCHAR2(30) := 'lock_tmpt_lines';
3120:
3121: BEGIN
3122:
3123: x_return_status := FND_API.G_RET_STS_SUCCESS;
3124: SAVEPOINT lock_tmpt_lines;
3125:
3126: okl_tmpt_set_pvt.lock_tmpt_lines(
3127:

Line 3143: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3139:
3140: );
3141:
3142:
3143: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3144: RAISE FND_API.G_EXC_ERROR;
3145: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3147: END IF;

Line 3144: RAISE FND_API.G_EXC_ERROR;

3140: );
3141:
3142:
3143: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3144: RAISE FND_API.G_EXC_ERROR;
3145: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3147: END IF;
3148:

Line 3145: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3141:
3142:
3143: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3144: RAISE FND_API.G_EXC_ERROR;
3145: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3147: END IF;
3148:
3149: EXCEPTION

Line 3146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3142:
3143: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3144: RAISE FND_API.G_EXC_ERROR;
3145: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3147: END IF;
3148:
3149: EXCEPTION
3150: WHEN FND_API.G_EXC_ERROR THEN

Line 3150: WHEN FND_API.G_EXC_ERROR THEN

3146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3147: END IF;
3148:
3149: EXCEPTION
3150: WHEN FND_API.G_EXC_ERROR THEN
3151: ROLLBACK TO lock_tmpt_lines;
3152: x_return_status := FND_API.G_RET_STS_ERROR;
3153:
3154: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 3152: x_return_status := FND_API.G_RET_STS_ERROR;

3148:
3149: EXCEPTION
3150: WHEN FND_API.G_EXC_ERROR THEN
3151: ROLLBACK TO lock_tmpt_lines;
3152: x_return_status := FND_API.G_RET_STS_ERROR;
3153:
3154: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3155: ,p_count => x_msg_count
3156: ,p_data => x_msg_data);

Line 3158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3154: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3155: ,p_count => x_msg_count
3156: ,p_data => x_msg_data);
3157:
3158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3159: ROLLBACK TO lock_tmpt_lines;
3160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3161: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3162: ,p_count => x_msg_count

Line 3160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3156: ,p_data => x_msg_data);
3157:
3158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3159: ROLLBACK TO lock_tmpt_lines;
3160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3161: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3162: ,p_count => x_msg_count
3163: ,p_data => x_msg_data);
3164:

Line 3172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3168: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3169: ,p_count => x_msg_count
3170: ,p_data => x_msg_data);
3171: -- notify caller of an UNEXPECTED error
3172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3173:
3174: END lock_tmpt_lines;
3175:
3176:

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

3194: l_api_name CONSTANT VARCHAR2(30) := 'lock_tmpt_lines';
3195:
3196: i NUMBER;
3197:
3198: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3199:
3200:
3201:
3202: BEGIN

Line 3206: x_return_status := FND_API.G_RET_STS_SUCCESS;

3202: BEGIN
3203:
3204: --Initialize the return status
3205:
3206: x_return_status := FND_API.G_RET_STS_SUCCESS;
3207: SAVEPOINT lock_tmpt_lines;
3208:
3209:
3210: IF (p_atlv_tbl.COUNT > 0) THEN

Line 3249: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3245: END IF;
3246:
3247: x_return_status := l_overall_status;
3248:
3249: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3250: RAISE FND_API.G_EXC_ERROR;
3251: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3253: END IF;

Line 3250: RAISE FND_API.G_EXC_ERROR;

3246:
3247: x_return_status := l_overall_status;
3248:
3249: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3250: RAISE FND_API.G_EXC_ERROR;
3251: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3253: END IF;
3254:

Line 3251: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3247: x_return_status := l_overall_status;
3248:
3249: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3250: RAISE FND_API.G_EXC_ERROR;
3251: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3253: END IF;
3254:
3255: EXCEPTION

Line 3252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3248:
3249: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3250: RAISE FND_API.G_EXC_ERROR;
3251: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3253: END IF;
3254:
3255: EXCEPTION
3256: WHEN FND_API.G_EXC_ERROR THEN

Line 3256: WHEN FND_API.G_EXC_ERROR THEN

3252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3253: END IF;
3254:
3255: EXCEPTION
3256: WHEN FND_API.G_EXC_ERROR THEN
3257: ROLLBACK TO lock_tmpt_lines;
3258: x_return_status := FND_API.G_RET_STS_ERROR;
3259:
3260: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 3258: x_return_status := FND_API.G_RET_STS_ERROR;

3254:
3255: EXCEPTION
3256: WHEN FND_API.G_EXC_ERROR THEN
3257: ROLLBACK TO lock_tmpt_lines;
3258: x_return_status := FND_API.G_RET_STS_ERROR;
3259:
3260: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3261: ,p_count => x_msg_count
3262: ,p_data => x_msg_data);

Line 3264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3260: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3261: ,p_count => x_msg_count
3262: ,p_data => x_msg_data);
3263:
3264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3265: ROLLBACK TO lock_tmpt_lines;
3266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3267: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3268: ,p_count => x_msg_count

Line 3266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3262: ,p_data => x_msg_data);
3263:
3264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3265: ROLLBACK TO lock_tmpt_lines;
3266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3267: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3268: ,p_count => x_msg_count
3269: ,p_data => x_msg_data);
3270:

Line 3278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3274: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3275: ,p_count => x_msg_count
3276: ,p_data => x_msg_data);
3277: -- notify caller of an UNEXPECTED error
3278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3279:
3280: END lock_tmpt_lines;
3281:
3282:

Line 3309: x_return_status := FND_API.G_RET_STS_SUCCESS;

3305:
3306: BEGIN
3307:
3308: SAVEPOINT update_tmpt_lines;
3309: x_return_status := FND_API.G_RET_STS_SUCCESS;
3310:
3311:
3312:
3313: -- customer pre-processing

Line 3347: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3343: ,x_atlv_rec => x_atlv_rec
3344:
3345: );
3346:
3347: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3348: RAISE FND_API.G_EXC_ERROR;
3349: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3351: END IF;

Line 3348: RAISE FND_API.G_EXC_ERROR;

3344:
3345: );
3346:
3347: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3348: RAISE FND_API.G_EXC_ERROR;
3349: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3351: END IF;
3352:

Line 3349: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3345: );
3346:
3347: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3348: RAISE FND_API.G_EXC_ERROR;
3349: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3351: END IF;
3352:
3353:

Line 3350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3346:
3347: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3348: RAISE FND_API.G_EXC_ERROR;
3349: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3351: END IF;
3352:
3353:
3354: l_atlv_rec := x_atlv_rec;

Line 3372: WHEN FND_API.G_EXC_ERROR THEN

3368:
3369:
3370: EXCEPTION
3371:
3372: WHEN FND_API.G_EXC_ERROR THEN
3373: ROLLBACK TO update_tmpt_lines;
3374: x_return_status := FND_API.G_RET_STS_ERROR;
3375:
3376: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 3374: x_return_status := FND_API.G_RET_STS_ERROR;

3370: EXCEPTION
3371:
3372: WHEN FND_API.G_EXC_ERROR THEN
3373: ROLLBACK TO update_tmpt_lines;
3374: x_return_status := FND_API.G_RET_STS_ERROR;
3375:
3376: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3377: ,p_count => x_msg_count
3378: ,p_data => x_msg_data);

Line 3380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3376: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3377: ,p_count => x_msg_count
3378: ,p_data => x_msg_data);
3379:
3380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3381: ROLLBACK TO update_tmpt_lines;
3382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3383: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3384: ,p_count => x_msg_count

Line 3382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3378: ,p_data => x_msg_data);
3379:
3380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3381: ROLLBACK TO update_tmpt_lines;
3382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3383: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3384: ,p_count => x_msg_count
3385: ,p_data => x_msg_data);
3386:

Line 3394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3390: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3391: ,p_count => x_msg_count
3392: ,p_data => x_msg_data);
3393: -- notify caller of an UNEXPECTED error
3394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3395: END update_tmpt_lines;
3396:
3397:
3398:

Line 3429: x_return_status := FND_API.G_RET_STS_SUCCESS;

3425:
3426: --Initialize the return status
3427:
3428: SAVEPOINT update_tmpt_lines;
3429: x_return_status := FND_API.G_RET_STS_SUCCESS;
3430:
3431:
3432:
3433: -- customer pre-processing

Line 3485: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3481: END IF;
3482:
3483: x_return_status := l_overall_status;
3484:
3485: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3486: RAISE FND_API.G_EXC_ERROR;
3487: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3489: END IF;

Line 3486: RAISE FND_API.G_EXC_ERROR;

3482:
3483: x_return_status := l_overall_status;
3484:
3485: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3486: RAISE FND_API.G_EXC_ERROR;
3487: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3489: END IF;
3490:

Line 3487: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3483: x_return_status := l_overall_status;
3484:
3485: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3486: RAISE FND_API.G_EXC_ERROR;
3487: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3489: END IF;
3490:
3491:

Line 3488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3484:
3485: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3486: RAISE FND_API.G_EXC_ERROR;
3487: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3489: END IF;
3490:
3491:
3492: l_atlv_tbl := x_atlv_tbl;

Line 3512: WHEN FND_API.G_EXC_ERROR THEN

3508:
3509:
3510: EXCEPTION
3511:
3512: WHEN FND_API.G_EXC_ERROR THEN
3513: ROLLBACK TO update_tmpt_lines;
3514: x_return_status := FND_API.G_RET_STS_ERROR;
3515:
3516: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 3514: x_return_status := FND_API.G_RET_STS_ERROR;

3510: EXCEPTION
3511:
3512: WHEN FND_API.G_EXC_ERROR THEN
3513: ROLLBACK TO update_tmpt_lines;
3514: x_return_status := FND_API.G_RET_STS_ERROR;
3515:
3516: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3517: ,p_count => x_msg_count
3518: ,p_data => x_msg_data);

Line 3520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3516: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3517: ,p_count => x_msg_count
3518: ,p_data => x_msg_data);
3519:
3520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3521: ROLLBACK TO update_tmpt_lines;
3522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3523: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3524: ,p_count => x_msg_count

Line 3522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3518: ,p_data => x_msg_data);
3519:
3520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3521: ROLLBACK TO update_tmpt_lines;
3522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3523: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3524: ,p_count => x_msg_count
3525: ,p_data => x_msg_data);
3526:

Line 3534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3530: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3531: ,p_count => x_msg_count
3532: ,p_data => x_msg_data);
3533: -- notify caller of an UNEXPECTED error
3534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3535:
3536: END update_tmpt_lines;
3537:
3538:

Line 3567: x_return_status := FND_API.G_RET_STS_SUCCESS;

3563:
3564: BEGIN
3565:
3566: SAVEPOINT delete_tmpt_lines;
3567: x_return_status := FND_API.G_RET_STS_SUCCESS;
3568:
3569:
3570:
3571: -- customer pre-processing

Line 3603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3599: ,x_msg_data => x_msg_data
3600:
3601: ,p_atlv_rec => l_atlv_rec);
3602:
3603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3604: RAISE FND_API.G_EXC_ERROR;
3605: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3607: END IF;

Line 3604: RAISE FND_API.G_EXC_ERROR;

3600:
3601: ,p_atlv_rec => l_atlv_rec);
3602:
3603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3604: RAISE FND_API.G_EXC_ERROR;
3605: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3607: END IF;
3608:

Line 3605: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3601: ,p_atlv_rec => l_atlv_rec);
3602:
3603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3604: RAISE FND_API.G_EXC_ERROR;
3605: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3607: END IF;
3608:
3609:

Line 3606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3602:
3603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3604: RAISE FND_API.G_EXC_ERROR;
3605: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3607: END IF;
3608:
3609:
3610:

Line 3627: WHEN FND_API.G_EXC_ERROR THEN

3623:
3624:
3625: EXCEPTION
3626:
3627: WHEN FND_API.G_EXC_ERROR THEN
3628: ROLLBACK TO delete_tmpt_lines;
3629: x_return_status := FND_API.G_RET_STS_ERROR;
3630:
3631: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 3629: x_return_status := FND_API.G_RET_STS_ERROR;

3625: EXCEPTION
3626:
3627: WHEN FND_API.G_EXC_ERROR THEN
3628: ROLLBACK TO delete_tmpt_lines;
3629: x_return_status := FND_API.G_RET_STS_ERROR;
3630:
3631: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3632: ,p_count => x_msg_count
3633: ,p_data => x_msg_data);

Line 3635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3631: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3632: ,p_count => x_msg_count
3633: ,p_data => x_msg_data);
3634:
3635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3636: ROLLBACK TO delete_tmpt_lines;
3637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3638: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3639: ,p_count => x_msg_count

Line 3637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3633: ,p_data => x_msg_data);
3634:
3635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3636: ROLLBACK TO delete_tmpt_lines;
3637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3638: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3639: ,p_count => x_msg_count
3640: ,p_data => x_msg_data);
3641:

Line 3649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3645: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3646: ,p_count => x_msg_count
3647: ,p_data => x_msg_data);
3648: -- notify caller of an UNEXPECTED error
3649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3650:
3651: END delete_tmpt_lines;
3652:
3653:

Line 3685: x_return_status := FND_API.G_RET_STS_SUCCESS;

3681:
3682: --Initialize the return status
3683:
3684: SAVEPOINT delete_tmpt_lines;
3685: x_return_status := FND_API.G_RET_STS_SUCCESS;
3686:
3687:
3688:
3689: -- customer pre-processing

Line 3740: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3736: END IF;
3737:
3738: x_return_status := l_overall_status;
3739:
3740: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3741: RAISE FND_API.G_EXC_ERROR;
3742: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3744: END IF;

Line 3741: RAISE FND_API.G_EXC_ERROR;

3737:
3738: x_return_status := l_overall_status;
3739:
3740: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3741: RAISE FND_API.G_EXC_ERROR;
3742: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3744: END IF;
3745:

Line 3742: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3738: x_return_status := l_overall_status;
3739:
3740: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3741: RAISE FND_API.G_EXC_ERROR;
3742: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3744: END IF;
3745:
3746:

Line 3743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3739:
3740: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3741: RAISE FND_API.G_EXC_ERROR;
3742: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3744: END IF;
3745:
3746:
3747:

Line 3765: WHEN FND_API.G_EXC_ERROR THEN

3761:
3762:
3763: EXCEPTION
3764:
3765: WHEN FND_API.G_EXC_ERROR THEN
3766: ROLLBACK TO delete_tmpt_lines;
3767: x_return_status := FND_API.G_RET_STS_ERROR;
3768:
3769: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 3767: x_return_status := FND_API.G_RET_STS_ERROR;

3763: EXCEPTION
3764:
3765: WHEN FND_API.G_EXC_ERROR THEN
3766: ROLLBACK TO delete_tmpt_lines;
3767: x_return_status := FND_API.G_RET_STS_ERROR;
3768:
3769: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3770: ,p_count => x_msg_count
3771: ,p_data => x_msg_data);

Line 3773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3769: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3770: ,p_count => x_msg_count
3771: ,p_data => x_msg_data);
3772:
3773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3774: ROLLBACK TO delete_tmpt_lines;
3775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3776: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3777: ,p_count => x_msg_count

Line 3775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3771: ,p_data => x_msg_data);
3772:
3773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3774: ROLLBACK TO delete_tmpt_lines;
3775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3776: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3777: ,p_count => x_msg_count
3778: ,p_data => x_msg_data);
3779:

Line 3787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3783: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3784: ,p_count => x_msg_count
3785: ,p_data => x_msg_data);
3786: -- notify caller of an UNEXPECTED error
3787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3788:
3789: END delete_tmpt_lines;
3790:
3791:

Line 3816: x_return_status := FND_API.G_RET_STS_SUCCESS;

3812:
3813: BEGIN
3814:
3815: SAVEPOINT validate_tmpt_lines;
3816: x_return_status := FND_API.G_RET_STS_SUCCESS;
3817:
3818:
3819:
3820: -- customer pre-processing

Line 3854: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3850: ,p_atlv_rec => l_atlv_rec
3851:
3852: );
3853:
3854: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3855: RAISE FND_API.G_EXC_ERROR;
3856: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3858: END IF;

Line 3855: RAISE FND_API.G_EXC_ERROR;

3851:
3852: );
3853:
3854: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3855: RAISE FND_API.G_EXC_ERROR;
3856: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3858: END IF;
3859:

Line 3856: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3852: );
3853:
3854: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3855: RAISE FND_API.G_EXC_ERROR;
3856: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3858: END IF;
3859:
3860:

Line 3857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3853:
3854: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3855: RAISE FND_API.G_EXC_ERROR;
3856: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3858: END IF;
3859:
3860:
3861:

Line 3878: WHEN FND_API.G_EXC_ERROR THEN

3874:
3875:
3876: EXCEPTION
3877:
3878: WHEN FND_API.G_EXC_ERROR THEN
3879: ROLLBACK TO validate_tmpt_lines;
3880: x_return_status := FND_API.G_RET_STS_ERROR;
3881:
3882: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 3880: x_return_status := FND_API.G_RET_STS_ERROR;

3876: EXCEPTION
3877:
3878: WHEN FND_API.G_EXC_ERROR THEN
3879: ROLLBACK TO validate_tmpt_lines;
3880: x_return_status := FND_API.G_RET_STS_ERROR;
3881:
3882: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3883: ,p_count => x_msg_count
3884: ,p_data => x_msg_data);

Line 3886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3882: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3883: ,p_count => x_msg_count
3884: ,p_data => x_msg_data);
3885:
3886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3887: ROLLBACK TO validate_tmpt_lines;
3888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3889: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3890: ,p_count => x_msg_count

Line 3888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3884: ,p_data => x_msg_data);
3885:
3886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3887: ROLLBACK TO validate_tmpt_lines;
3888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3889: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3890: ,p_count => x_msg_count
3891: ,p_data => x_msg_data);
3892:

Line 3900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3896: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3897: ,p_count => x_msg_count
3898: ,p_data => x_msg_data);
3899: -- notify caller of an UNEXPECTED error
3900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3901:
3902: END validate_tmpt_lines;
3903:
3904:

Line 3934: x_return_status := FND_API.G_RET_STS_SUCCESS;

3930:
3931: --Initialize the return status
3932:
3933: SAVEPOINT validate_tmpt_lines;
3934: x_return_status := FND_API.G_RET_STS_SUCCESS;
3935:
3936:
3937:
3938: -- customer pre-processing

Line 3989: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3985: END IF;
3986:
3987: x_return_status := l_overall_status;
3988:
3989: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3990: RAISE FND_API.G_EXC_ERROR;
3991: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3993: END IF;

Line 3990: RAISE FND_API.G_EXC_ERROR;

3986:
3987: x_return_status := l_overall_status;
3988:
3989: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3990: RAISE FND_API.G_EXC_ERROR;
3991: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3993: END IF;
3994:

Line 3991: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3987: x_return_status := l_overall_status;
3988:
3989: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3990: RAISE FND_API.G_EXC_ERROR;
3991: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3993: END IF;
3994:
3995:

Line 3992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3988:
3989: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3990: RAISE FND_API.G_EXC_ERROR;
3991: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3993: END IF;
3994:
3995:
3996:

Line 4014: WHEN FND_API.G_EXC_ERROR THEN

4010:
4011:
4012: EXCEPTION
4013:
4014: WHEN FND_API.G_EXC_ERROR THEN
4015: ROLLBACK TO validate_tmpt_lines;
4016: x_return_status := FND_API.G_RET_STS_ERROR;
4017:
4018: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 4016: x_return_status := FND_API.G_RET_STS_ERROR;

4012: EXCEPTION
4013:
4014: WHEN FND_API.G_EXC_ERROR THEN
4015: ROLLBACK TO validate_tmpt_lines;
4016: x_return_status := FND_API.G_RET_STS_ERROR;
4017:
4018: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
4019: ,p_count => x_msg_count
4020: ,p_data => x_msg_data);

Line 4022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4018: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
4019: ,p_count => x_msg_count
4020: ,p_data => x_msg_data);
4021:
4022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4023: ROLLBACK TO validate_tmpt_lines;
4024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4025: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
4026: ,p_count => x_msg_count

Line 4024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4020: ,p_data => x_msg_data);
4021:
4022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4023: ROLLBACK TO validate_tmpt_lines;
4024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4025: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
4026: ,p_count => x_msg_count
4027: ,p_data => x_msg_data);
4028:

Line 4036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4032: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
4033: ,p_count => x_msg_count
4034: ,p_data => x_msg_data);
4035: -- notify caller of an UNEXPECTED error
4036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4037:
4038: END validate_tmpt_lines;
4039:
4040: END OKL_TMPT_SET_PUB;