32: l_api_name CONSTANT VARCHAR2(30) := 'create_option_rules';
33:
34: l_orlv_rec orlv_rec_type := p_orlv_rec;
35:
36: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
37:
38: l_ovdv_tbl ovdv_tbl_type := p_ovdv_tbl;
39:
40:
41:
42: BEGIN
43:
44: SAVEPOINT create_option_rules;
45: x_return_status := FND_API.G_RET_STS_SUCCESS;
46:
47: -- customer pre-processing
48:
49:
81: ,x_orlv_rec => x_orlv_rec
82:
83: ,x_ovdv_tbl => x_ovdv_tbl);
84:
85: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
86: RAISE FND_API.G_EXC_ERROR;
87: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
82:
83: ,x_ovdv_tbl => x_ovdv_tbl);
84:
85: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
86: RAISE FND_API.G_EXC_ERROR;
87: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90:
83: ,x_ovdv_tbl => x_ovdv_tbl);
84:
85: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
86: RAISE FND_API.G_EXC_ERROR;
87: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90:
91:
84:
85: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
86: RAISE FND_API.G_EXC_ERROR;
87: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90:
91:
92: l_orlv_rec := x_orlv_rec;
106:
107:
108:
109: EXCEPTION
110: WHEN FND_API.G_EXC_ERROR THEN
111: ROLLBACK TO create_option_rules;
112: x_return_status := FND_API.G_RET_STS_ERROR;
113:
114: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
108:
109: EXCEPTION
110: WHEN FND_API.G_EXC_ERROR THEN
111: ROLLBACK TO create_option_rules;
112: x_return_status := FND_API.G_RET_STS_ERROR;
113:
114: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
115: ,p_count => x_msg_count
116: ,p_data => x_msg_data);
114: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
115: ,p_count => x_msg_count
116: ,p_data => x_msg_data);
117:
118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
119: ROLLBACK TO create_option_rules;
120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
121: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
122: ,p_count => x_msg_count
116: ,p_data => x_msg_data);
117:
118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
119: ROLLBACK TO create_option_rules;
120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
121: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
122: ,p_count => x_msg_count
123: ,p_data => x_msg_data);
124:
128: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
129: ,p_count => x_msg_count
130: ,p_data => x_msg_data);
131: -- notify caller of an UNEXPECTED error
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
133:
134:
135: END create_option_rules;
136:
151: ,p_orlv_rec IN orlv_rec_type
152:
153: ,x_orlv_rec OUT NOCOPY orlv_rec_type) IS
154:
155: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
156:
157: l_api_name CONSTANT VARCHAR2(30) := 'create_option_rules';
158:
159: l_orlv_rec orlv_rec_type := p_orlv_rec;
162:
163: BEGIN
164:
165: SAVEPOINT create_option_rules;
166: x_return_status := FND_API.G_RET_STS_SUCCESS;
167:
168:
169:
170: -- customer pre-processing
202: );
203:
204:
205:
206: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
207: RAISE FND_API.G_EXC_ERROR;
208: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;
203:
204:
205:
206: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
207: RAISE FND_API.G_EXC_ERROR;
208: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;
211:
204:
205:
206: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
207: RAISE FND_API.G_EXC_ERROR;
208: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;
211:
212: l_orlv_rec := x_orlv_rec;
205:
206: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
207: RAISE FND_API.G_EXC_ERROR;
208: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;
211:
212: l_orlv_rec := x_orlv_rec;
213:
226:
227:
228: EXCEPTION
229:
230: WHEN FND_API.G_EXC_ERROR THEN
231: ROLLBACK TO create_option_rules;
232: x_return_status := FND_API.G_RET_STS_ERROR;
233:
234: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
228: EXCEPTION
229:
230: WHEN FND_API.G_EXC_ERROR THEN
231: ROLLBACK TO create_option_rules;
232: x_return_status := FND_API.G_RET_STS_ERROR;
233:
234: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
235: ,p_count => x_msg_count
236: ,p_data => x_msg_data);
234: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
235: ,p_count => x_msg_count
236: ,p_data => x_msg_data);
237:
238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
239: ROLLBACK TO create_option_rules;
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
242: ,p_count => x_msg_count
236: ,p_data => x_msg_data);
237:
238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
239: ROLLBACK TO create_option_rules;
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
242: ,p_count => x_msg_count
243: ,p_data => x_msg_data);
244:
248: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
249: ,p_count => x_msg_count
250: ,p_data => x_msg_data);
251: -- notify caller of an UNEXPECTED error
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
253:
254: END create_option_rules;
255:
256:
270: ,p_orlv_tbl IN orlv_tbl_type
271:
272: ,x_orlv_tbl OUT NOCOPY orlv_tbl_type) IS
273:
274: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
275:
276: l_api_name CONSTANT VARCHAR2(30) := 'create_option_rules';
277:
278: i NUMBER;
276: l_api_name CONSTANT VARCHAR2(30) := 'create_option_rules';
277:
278: i NUMBER;
279:
280: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
281:
282: l_orlv_tbl orlv_tbl_type := p_orlv_tbl;
283:
284: BEGIN
284: BEGIN
285:
286: --Initialize the return status
287: SAVEPOINT create_option_rules;
288: x_return_status := FND_API.G_RET_STS_SUCCESS;
289:
290:
291:
292: -- customer pre-processing
327:
328: );
329:
330: -- store the highest degree of error
331: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
332: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
333: l_overall_status := x_return_status;
334: END IF;
335: END IF;
328: );
329:
330: -- store the highest degree of error
331: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
332: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
333: l_overall_status := x_return_status;
334: END IF;
335: END IF;
336:
342: -- return overall status
343: l_return_status := l_overall_status;
344: END IF;
345:
346: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
347: RAISE FND_API.G_EXC_ERROR;
348: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: END IF;
343: l_return_status := l_overall_status;
344: END IF;
345:
346: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
347: RAISE FND_API.G_EXC_ERROR;
348: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: END IF;
351:
344: END IF;
345:
346: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
347: RAISE FND_API.G_EXC_ERROR;
348: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: END IF;
351:
352: l_orlv_tbl := x_orlv_tbl;
345:
346: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
347: RAISE FND_API.G_EXC_ERROR;
348: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: END IF;
351:
352: l_orlv_tbl := x_orlv_tbl;
353:
367:
368:
369: EXCEPTION
370:
371: WHEN FND_API.G_EXC_ERROR THEN
372: ROLLBACK TO create_option_rules;
373: x_return_status := FND_API.G_RET_STS_ERROR;
374:
375: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
369: EXCEPTION
370:
371: WHEN FND_API.G_EXC_ERROR THEN
372: ROLLBACK TO create_option_rules;
373: x_return_status := FND_API.G_RET_STS_ERROR;
374:
375: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
376: ,p_count => x_msg_count
377: ,p_data => x_msg_data);
375: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
376: ,p_count => x_msg_count
377: ,p_data => x_msg_data);
378:
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: ROLLBACK TO create_option_rules;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
383: ,p_count => x_msg_count
377: ,p_data => x_msg_data);
378:
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: ROLLBACK TO create_option_rules;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
383: ,p_count => x_msg_count
384: ,p_data => x_msg_data);
385:
389: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
390: ,p_count => x_msg_count
391: ,p_data => x_msg_data);
392: -- notify caller of an UNEXPECTED error
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394:
395:
396: END create_option_rules;
397:
418: x_orlv_rec OUT NOCOPY orlv_rec_type,
419:
420: x_ovdv_tbl OUT NOCOPY ovdv_tbl_type) IS
421:
422: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
423:
424: l_api_name CONSTANT VARCHAR2(30) := 'update_option_rules';
425:
426: l_orlv_rec orlv_rec_type := p_orlv_rec;
431:
432: BEGIN
433:
434: SAVEPOINT update_option_rules;
435: x_return_status := FND_API.G_RET_STS_SUCCESS;
436:
437:
438:
439: -- customer pre-processing
475: ,x_ovdv_tbl => x_ovdv_tbl
476:
477: );
478:
479: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
480: RAISE FND_API.G_EXC_ERROR;
481: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
483: END IF;
476:
477: );
478:
479: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
480: RAISE FND_API.G_EXC_ERROR;
481: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
483: END IF;
484:
477: );
478:
479: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
480: RAISE FND_API.G_EXC_ERROR;
481: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
483: END IF;
484:
485: l_orlv_rec := x_orlv_rec;
478:
479: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
480: RAISE FND_API.G_EXC_ERROR;
481: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
483: END IF;
484:
485: l_orlv_rec := x_orlv_rec;
486: l_ovdv_tbl := x_ovdv_tbl;
500:
501:
502: EXCEPTION
503:
504: WHEN FND_API.G_EXC_ERROR THEN
505: ROLLBACK TO update_option_rules;
506: x_return_status := FND_API.G_RET_STS_ERROR;
507:
508: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
502: EXCEPTION
503:
504: WHEN FND_API.G_EXC_ERROR THEN
505: ROLLBACK TO update_option_rules;
506: x_return_status := FND_API.G_RET_STS_ERROR;
507:
508: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
509: ,p_count => x_msg_count
510: ,p_data => x_msg_data);
508: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
509: ,p_count => x_msg_count
510: ,p_data => x_msg_data);
511:
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: ROLLBACK TO update_option_rules;
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
516: ,p_count => x_msg_count
510: ,p_data => x_msg_data);
511:
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: ROLLBACK TO update_option_rules;
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
516: ,p_count => x_msg_count
517: ,p_data => x_msg_data);
518:
522: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
523: ,p_count => x_msg_count
524: ,p_data => x_msg_data);
525: -- notify caller of an UNEXPECTED error
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527:
528: END update_option_rules;
529:
530:
546: ,p_ovdv_tbl IN ovdv_tbl_type) IS
547:
548:
549:
550: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
551:
552: l_api_name CONSTANT VARCHAR2(30) := 'validate_option_rules';
553:
554: l_orlv_rec orlv_rec_type := p_orlv_rec;
559:
560: BEGIN
561:
562: SAVEPOINT validate_option_rules;
563: x_return_status := FND_API.G_RET_STS_SUCCESS;
564:
565:
566:
567: -- customer pre-processing
599: );
600:
601:
602:
603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
604: RAISE FND_API.G_EXC_ERROR;
605: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
607: END IF;
600:
601:
602:
603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
604: RAISE FND_API.G_EXC_ERROR;
605: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
607: END IF;
608:
601:
602:
603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
604: RAISE FND_API.G_EXC_ERROR;
605: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
607: END IF;
608:
609:
602:
603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
604: RAISE FND_API.G_EXC_ERROR;
605: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
607: END IF;
608:
609:
610:
623:
624:
625: EXCEPTION
626:
627: WHEN FND_API.G_EXC_ERROR THEN
628: ROLLBACK TO validate_option_rules;
629: x_return_status := FND_API.G_RET_STS_ERROR;
630:
631: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
625: EXCEPTION
626:
627: WHEN FND_API.G_EXC_ERROR THEN
628: ROLLBACK TO validate_option_rules;
629: x_return_status := FND_API.G_RET_STS_ERROR;
630:
631: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
632: ,p_count => x_msg_count
633: ,p_data => x_msg_data);
631: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
632: ,p_count => x_msg_count
633: ,p_data => x_msg_data);
634:
635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
636: ROLLBACK TO validate_option_rules;
637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
638: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
639: ,p_count => x_msg_count
633: ,p_data => x_msg_data);
634:
635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
636: ROLLBACK TO validate_option_rules;
637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
638: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
639: ,p_count => x_msg_count
640: ,p_data => x_msg_data);
641:
645: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
646: ,p_count => x_msg_count
647: ,p_data => x_msg_data);
648: -- notify caller of an UNEXPECTED error
649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
650:
651: END validate_option_rules;
652:
653:
665: ,x_msg_data OUT NOCOPY VARCHAR2
666:
667: ,p_orlv_rec IN orlv_rec_type) IS
668:
669: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
670:
671: l_api_name CONSTANT VARCHAR2(30) := 'lock_option_rules';
672:
673:
675:
676:
677: BEGIN
678:
679: x_return_status := FND_API.G_RET_STS_SUCCESS;
680: SAVEPOINT lock_option_rules;
681:
682:
683: okl_option_rules_pvt.lock_option_rules(
695: ,p_orlv_rec => p_orlv_rec
696:
697: );
698:
699: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
700: RAISE FND_API.G_EXC_ERROR;
701: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
703: END IF;
696:
697: );
698:
699: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
700: RAISE FND_API.G_EXC_ERROR;
701: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
703: END IF;
704:
697: );
698:
699: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
700: RAISE FND_API.G_EXC_ERROR;
701: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
703: END IF;
704:
705: EXCEPTION
698:
699: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
700: RAISE FND_API.G_EXC_ERROR;
701: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
703: END IF;
704:
705: EXCEPTION
706: WHEN FND_API.G_EXC_ERROR THEN
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
703: END IF;
704:
705: EXCEPTION
706: WHEN FND_API.G_EXC_ERROR THEN
707: ROLLBACK TO lock_option_rules;
708: x_return_status := FND_API.G_RET_STS_ERROR;
709:
710: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
704:
705: EXCEPTION
706: WHEN FND_API.G_EXC_ERROR THEN
707: ROLLBACK TO lock_option_rules;
708: x_return_status := FND_API.G_RET_STS_ERROR;
709:
710: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
711: ,p_count => x_msg_count
712: ,p_data => x_msg_data);
710: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
711: ,p_count => x_msg_count
712: ,p_data => x_msg_data);
713:
714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
715: ROLLBACK TO lock_option_rules;
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
718: ,p_count => x_msg_count
712: ,p_data => x_msg_data);
713:
714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
715: ROLLBACK TO lock_option_rules;
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
718: ,p_count => x_msg_count
719: ,p_data => x_msg_data);
720:
724: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
725: ,p_count => x_msg_count
726: ,p_data => x_msg_data);
727: -- notify caller of an UNEXPECTED error
728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
729:
730: END lock_option_rules;
731:
732:
744: ,x_msg_data OUT NOCOPY VARCHAR2
745:
746: ,p_orlv_tbl IN orlv_tbl_type) IS
747:
748: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
749:
750: l_api_name CONSTANT VARCHAR2(30) := 'lock_option_rules';
751:
752: i NUMBER;
750: l_api_name CONSTANT VARCHAR2(30) := 'lock_option_rules';
751:
752: i NUMBER;
753:
754: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
755:
756:
757:
758: BEGIN
758: BEGIN
759:
760: --Initialize the return status
761:
762: x_return_status := FND_API.G_RET_STS_SUCCESS;
763: SAVEPOINT lock_option_rules;
764:
765: IF (p_orlv_tbl.COUNT > 0) THEN
766:
784:
785: );
786:
787: -- store the highest degree of error
788: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
789: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
790: l_overall_status := x_return_status;
791: END IF;
792: END IF;
785: );
786:
787: -- store the highest degree of error
788: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
789: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
790: l_overall_status := x_return_status;
791: END IF;
792: END IF;
793:
801: l_return_status := l_overall_status;
802:
803: END IF;
804:
805: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
806: RAISE FND_API.G_EXC_ERROR;
807: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: END IF;
802:
803: END IF;
804:
805: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
806: RAISE FND_API.G_EXC_ERROR;
807: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: END IF;
810:
803: END IF;
804:
805: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
806: RAISE FND_API.G_EXC_ERROR;
807: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: END IF;
810:
811: EXCEPTION
804:
805: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
806: RAISE FND_API.G_EXC_ERROR;
807: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: END IF;
810:
811: EXCEPTION
812: WHEN FND_API.G_EXC_ERROR THEN
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: END IF;
810:
811: EXCEPTION
812: WHEN FND_API.G_EXC_ERROR THEN
813: ROLLBACK TO lock_option_rules;
814: x_return_status := FND_API.G_RET_STS_ERROR;
815:
816: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
810:
811: EXCEPTION
812: WHEN FND_API.G_EXC_ERROR THEN
813: ROLLBACK TO lock_option_rules;
814: x_return_status := FND_API.G_RET_STS_ERROR;
815:
816: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
817: ,p_count => x_msg_count
818: ,p_data => x_msg_data);
816: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
817: ,p_count => x_msg_count
818: ,p_data => x_msg_data);
819:
820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
821: ROLLBACK TO lock_option_rules;
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
823: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
824: ,p_count => x_msg_count
818: ,p_data => x_msg_data);
819:
820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
821: ROLLBACK TO lock_option_rules;
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
823: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
824: ,p_count => x_msg_count
825: ,p_data => x_msg_data);
826:
830: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
831: ,p_count => x_msg_count
832: ,p_data => x_msg_data);
833: -- notify caller of an UNEXPECTED error
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
835:
836: END lock_option_rules;
837:
838:
852: ,p_orlv_rec IN orlv_rec_type
853:
854: ,x_orlv_rec OUT NOCOPY orlv_rec_type) IS
855:
856: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
857:
858: l_api_name CONSTANT VARCHAR2(30) := 'update_option_rules';
859:
860: l_orlv_rec orlv_rec_type := p_orlv_rec;
861:
862: BEGIN
863:
864: SAVEPOINT update_option_rules;
865: x_return_status := FND_API.G_RET_STS_SUCCESS;
866:
867:
868:
869: -- customer pre-processing
899: ,x_orlv_rec => x_orlv_rec
900:
901: );
902:
903: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
904: RAISE FND_API.G_EXC_ERROR;
905: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
907: END IF;
900:
901: );
902:
903: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
904: RAISE FND_API.G_EXC_ERROR;
905: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
907: END IF;
908:
901: );
902:
903: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
904: RAISE FND_API.G_EXC_ERROR;
905: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
907: END IF;
908:
909: l_orlv_rec := x_orlv_rec;
902:
903: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
904: RAISE FND_API.G_EXC_ERROR;
905: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
907: END IF;
908:
909: l_orlv_rec := x_orlv_rec;
910:
923:
924:
925: EXCEPTION
926:
927: WHEN FND_API.G_EXC_ERROR THEN
928: ROLLBACK TO update_option_rules;
929: x_return_status := FND_API.G_RET_STS_ERROR;
930:
931: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
925: EXCEPTION
926:
927: WHEN FND_API.G_EXC_ERROR THEN
928: ROLLBACK TO update_option_rules;
929: x_return_status := FND_API.G_RET_STS_ERROR;
930:
931: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
932: ,p_count => x_msg_count
933: ,p_data => x_msg_data);
931: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
932: ,p_count => x_msg_count
933: ,p_data => x_msg_data);
934:
935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
936: ROLLBACK TO update_option_rules;
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
939: ,p_count => x_msg_count
933: ,p_data => x_msg_data);
934:
935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
936: ROLLBACK TO update_option_rules;
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
939: ,p_count => x_msg_count
940: ,p_data => x_msg_data);
941:
945: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
946: ,p_count => x_msg_count
947: ,p_data => x_msg_data);
948: -- notify caller of an UNEXPECTED error
949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
950:
951: END update_option_rules;
952:
953:
967: ,p_orlv_tbl IN orlv_tbl_type
968:
969: ,x_orlv_tbl OUT NOCOPY orlv_tbl_type) IS
970:
971: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
972:
973: l_api_name CONSTANT VARCHAR2(30) := 'update_option_rules';
974:
975: i NUMBER;
973: l_api_name CONSTANT VARCHAR2(30) := 'update_option_rules';
974:
975: i NUMBER;
976:
977: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
978:
979: l_orlv_tbl orlv_tbl_type := p_orlv_tbl;
980:
981: BEGIN
981: BEGIN
982:
983: --Initialize the return status
984:
985: x_return_status := FND_API.G_RET_STS_SUCCESS;
986: SAVEPOINT update_option_rules;
987:
988: -- customer pre-processing
989:
1022: ,x_orlv_rec => x_orlv_tbl(i)
1023:
1024: );
1025: -- store the highest degree of error
1026: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1027: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1028: l_overall_status := x_return_status;
1029: END IF;
1030: END IF;
1023:
1024: );
1025: -- store the highest degree of error
1026: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1027: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1028: l_overall_status := x_return_status;
1029: END IF;
1030: END IF;
1031:
1038: -- return overall status
1039: l_return_status := l_overall_status;
1040: END IF;
1041:
1042: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1043: RAISE FND_API.G_EXC_ERROR;
1044: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1046: END IF;
1039: l_return_status := l_overall_status;
1040: END IF;
1041:
1042: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1043: RAISE FND_API.G_EXC_ERROR;
1044: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1046: END IF;
1047:
1040: END IF;
1041:
1042: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1043: RAISE FND_API.G_EXC_ERROR;
1044: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1046: END IF;
1047:
1048:
1041:
1042: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1043: RAISE FND_API.G_EXC_ERROR;
1044: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1046: END IF;
1047:
1048:
1049: l_orlv_tbl := x_orlv_tbl;
1063:
1064:
1065: EXCEPTION
1066:
1067: WHEN FND_API.G_EXC_ERROR THEN
1068: ROLLBACK TO update_option_rules;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070:
1071: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1065: EXCEPTION
1066:
1067: WHEN FND_API.G_EXC_ERROR THEN
1068: ROLLBACK TO update_option_rules;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070:
1071: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1072: ,p_count => x_msg_count
1073: ,p_data => x_msg_data);
1071: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1072: ,p_count => x_msg_count
1073: ,p_data => x_msg_data);
1074:
1075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1076: ROLLBACK TO update_option_rules;
1077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1078: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1079: ,p_count => x_msg_count
1073: ,p_data => x_msg_data);
1074:
1075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1076: ROLLBACK TO update_option_rules;
1077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1078: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1079: ,p_count => x_msg_count
1080: ,p_data => x_msg_data);
1081:
1085: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1086: ,p_count => x_msg_count
1087: ,p_data => x_msg_data);
1088: -- notify caller of an UNEXPECTED error
1089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1090:
1091:
1092:
1093: END update_option_rules;
1111: ,p_orlv_rec IN orlv_rec_type) IS
1112:
1113: i NUMBER :=0;
1114:
1115: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1116:
1117: l_api_name CONSTANT VARCHAR2(30) := 'delete_option_rules';
1118:
1119: l_orlv_rec orlv_rec_type := p_orlv_rec;
1122:
1123: BEGIN
1124:
1125: SAVEPOINT delete_option_rules;
1126: x_return_status := FND_API.G_RET_STS_SUCCESS;
1127:
1128:
1129:
1130: -- customer pre-processing
1160: );
1161:
1162:
1163:
1164: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1165: RAISE FND_API.G_EXC_ERROR;
1166: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: END IF;
1161:
1162:
1163:
1164: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1165: RAISE FND_API.G_EXC_ERROR;
1166: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: END IF;
1169:
1162:
1163:
1164: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1165: RAISE FND_API.G_EXC_ERROR;
1166: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: END IF;
1169:
1170:
1163:
1164: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1165: RAISE FND_API.G_EXC_ERROR;
1166: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: END IF;
1169:
1170:
1171:
1184:
1185:
1186: EXCEPTION
1187:
1188: WHEN FND_API.G_EXC_ERROR THEN
1189: ROLLBACK TO delete_option_rules;
1190: x_return_status := FND_API.G_RET_STS_ERROR;
1191:
1192: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1186: EXCEPTION
1187:
1188: WHEN FND_API.G_EXC_ERROR THEN
1189: ROLLBACK TO delete_option_rules;
1190: x_return_status := FND_API.G_RET_STS_ERROR;
1191:
1192: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1193: ,p_count => x_msg_count
1194: ,p_data => x_msg_data);
1192: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1193: ,p_count => x_msg_count
1194: ,p_data => x_msg_data);
1195:
1196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1197: ROLLBACK TO delete_option_rules;
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1199: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1200: ,p_count => x_msg_count
1194: ,p_data => x_msg_data);
1195:
1196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1197: ROLLBACK TO delete_option_rules;
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1199: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1200: ,p_count => x_msg_count
1201: ,p_data => x_msg_data);
1202:
1206: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1207: ,p_count => x_msg_count
1208: ,p_data => x_msg_data);
1209: -- notify caller of an UNEXPECTED error
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1211:
1212: END delete_option_rules;
1213:
1214:
1228: ,p_orlv_tbl IN orlv_tbl_type) IS
1229:
1230: i NUMBER :=0;
1231:
1232: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1233:
1234: l_api_name CONSTANT VARCHAR2(30) := 'delete_option_rules';
1235:
1236: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1232: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1233:
1234: l_api_name CONSTANT VARCHAR2(30) := 'delete_option_rules';
1235:
1236: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1237:
1238: l_orlv_tbl orlv_tbl_type := p_orlv_tbl;
1239:
1240: BEGIN
1240: BEGIN
1241:
1242: --Initialize the return status
1243:
1244: x_return_status := FND_API.G_RET_STS_SUCCESS;
1245: SAVEPOINT delete_option_rules;
1246:
1247: -- customer pre-processing
1248:
1280:
1281: );
1282:
1283: -- store the highest degree of error
1284: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1285: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1286: l_overall_status := x_return_status;
1287: END IF;
1288: END IF;
1281: );
1282:
1283: -- store the highest degree of error
1284: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1285: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1286: l_overall_status := x_return_status;
1287: END IF;
1288: END IF;
1289:
1296: l_return_status := l_overall_status;
1297:
1298: END IF;
1299:
1300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;
1297:
1298: END IF;
1299:
1300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;
1305:
1298: END IF;
1299:
1300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;
1305:
1306:
1299:
1300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;
1305:
1306:
1307:
1320:
1321:
1322: EXCEPTION
1323:
1324: WHEN FND_API.G_EXC_ERROR THEN
1325: ROLLBACK TO delete_option_rules;
1326: x_return_status := FND_API.G_RET_STS_ERROR;
1327:
1328: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1322: EXCEPTION
1323:
1324: WHEN FND_API.G_EXC_ERROR THEN
1325: ROLLBACK TO delete_option_rules;
1326: x_return_status := FND_API.G_RET_STS_ERROR;
1327:
1328: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1329: ,p_count => x_msg_count
1330: ,p_data => x_msg_data);
1328: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1329: ,p_count => x_msg_count
1330: ,p_data => x_msg_data);
1331:
1332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1333: ROLLBACK TO delete_option_rules;
1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1335: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1336: ,p_count => x_msg_count
1330: ,p_data => x_msg_data);
1331:
1332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1333: ROLLBACK TO delete_option_rules;
1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1335: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1336: ,p_count => x_msg_count
1337: ,p_data => x_msg_data);
1338:
1342: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1343: ,p_count => x_msg_count
1344: ,p_data => x_msg_data);
1345: -- notify caller of an UNEXPECTED error
1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1347:
1348:
1349:
1350: END delete_option_rules;
1364: ,x_msg_data OUT NOCOPY VARCHAR2
1365:
1366: ,p_orlv_rec IN orlv_rec_type) IS
1367:
1368: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1369:
1370: l_api_name CONSTANT VARCHAR2(30) := 'validate_option_rules';
1371:
1372: l_orlv_rec orlv_rec_type := p_orlv_rec;
1375:
1376: BEGIN
1377:
1378: SAVEPOINT validate_option_rules;
1379: x_return_status := FND_API.G_RET_STS_SUCCESS;
1380:
1381:
1382:
1383: -- customer pre-processing
1413: ,p_orlv_rec => l_orlv_rec
1414:
1415: );
1416:
1417: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1418: RAISE FND_API.G_EXC_ERROR;
1419: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1421: END IF;
1414:
1415: );
1416:
1417: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1418: RAISE FND_API.G_EXC_ERROR;
1419: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1421: END IF;
1422:
1415: );
1416:
1417: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1418: RAISE FND_API.G_EXC_ERROR;
1419: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1421: END IF;
1422:
1423:
1416:
1417: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1418: RAISE FND_API.G_EXC_ERROR;
1419: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1421: END IF;
1422:
1423:
1424:
1437:
1438:
1439: EXCEPTION
1440:
1441: WHEN FND_API.G_EXC_ERROR THEN
1442: ROLLBACK TO validate_option_rules;
1443: x_return_status := FND_API.G_RET_STS_ERROR;
1444:
1445: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1439: EXCEPTION
1440:
1441: WHEN FND_API.G_EXC_ERROR THEN
1442: ROLLBACK TO validate_option_rules;
1443: x_return_status := FND_API.G_RET_STS_ERROR;
1444:
1445: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1446: ,p_count => x_msg_count
1447: ,p_data => x_msg_data);
1445: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1446: ,p_count => x_msg_count
1447: ,p_data => x_msg_data);
1448:
1449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1450: ROLLBACK TO validate_option_rules;
1451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1452: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1453: ,p_count => x_msg_count
1447: ,p_data => x_msg_data);
1448:
1449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1450: ROLLBACK TO validate_option_rules;
1451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1452: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1453: ,p_count => x_msg_count
1454: ,p_data => x_msg_data);
1455:
1459: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1460: ,p_count => x_msg_count
1461: ,p_data => x_msg_data);
1462: -- notify caller of an UNEXPECTED error
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1464:
1465: END validate_option_rules;
1466:
1467:
1479: x_msg_data OUT NOCOPY VARCHAR2,
1480:
1481: p_orlv_tbl IN orlv_tbl_type) IS
1482:
1483: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1484:
1485: l_api_name CONSTANT VARCHAR2(30) := 'validate_option_rules';
1486:
1487: i NUMBER;
1485: l_api_name CONSTANT VARCHAR2(30) := 'validate_option_rules';
1486:
1487: i NUMBER;
1488:
1489: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1490:
1491: l_orlv_tbl orlv_tbl_type := p_orlv_tbl;
1492:
1493: BEGIN
1493: BEGIN
1494:
1495: --Initialize the return status
1496:
1497: x_return_status := FND_API.G_RET_STS_SUCCESS;
1498: SAVEPOINT validate_option_rules;
1499:
1500: -- customer pre-processing
1501:
1531: ,p_orlv_rec => l_orlv_tbl(i)
1532:
1533: );
1534: -- store the highest degree of error
1535: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1536: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1537: l_overall_status := x_return_status;
1538: END IF;
1539: END IF;
1532:
1533: );
1534: -- store the highest degree of error
1535: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1536: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1537: l_overall_status := x_return_status;
1538: END IF;
1539: END IF;
1540:
1547: l_return_status := l_overall_status;
1548:
1549: END IF;
1550:
1551: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1552: RAISE FND_API.G_EXC_ERROR;
1553: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1555: END IF;
1548:
1549: END IF;
1550:
1551: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1552: RAISE FND_API.G_EXC_ERROR;
1553: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1555: END IF;
1556:
1549: END IF;
1550:
1551: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1552: RAISE FND_API.G_EXC_ERROR;
1553: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1555: END IF;
1556:
1557:
1550:
1551: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1552: RAISE FND_API.G_EXC_ERROR;
1553: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1555: END IF;
1556:
1557:
1558:
1571:
1572:
1573: EXCEPTION
1574:
1575: WHEN FND_API.G_EXC_ERROR THEN
1576: ROLLBACK TO validate_option_rules;
1577: x_return_status := FND_API.G_RET_STS_ERROR;
1578:
1579: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1573: EXCEPTION
1574:
1575: WHEN FND_API.G_EXC_ERROR THEN
1576: ROLLBACK TO validate_option_rules;
1577: x_return_status := FND_API.G_RET_STS_ERROR;
1578:
1579: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1580: ,p_count => x_msg_count
1581: ,p_data => x_msg_data);
1579: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1580: ,p_count => x_msg_count
1581: ,p_data => x_msg_data);
1582:
1583: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1584: ROLLBACK TO validate_option_rules;
1585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1586: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1587: ,p_count => x_msg_count
1581: ,p_data => x_msg_data);
1582:
1583: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1584: ROLLBACK TO validate_option_rules;
1585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1586: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1587: ,p_count => x_msg_count
1588: ,p_data => x_msg_data);
1589:
1593: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1594: ,p_count => x_msg_count
1595: ,p_data => x_msg_data);
1596: -- notify caller of an UNEXPECTED error
1597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1598:
1599:
1600: END validate_option_rules;
1601:
1616: ,p_ovdv_rec IN ovdv_rec_type
1617:
1618: ,x_ovdv_rec OUT NOCOPY ovdv_rec_type) IS
1619:
1620: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1621:
1622: l_api_name CONSTANT VARCHAR2(30) := 'create_option_val_rules';
1623:
1624: l_ovdv_rec ovdv_rec_type := p_ovdv_rec;
1625:
1626: BEGIN
1627:
1628: SAVEPOINT create_option_val_rules;
1629: x_return_status := FND_API.G_RET_STS_SUCCESS;
1630:
1631:
1632:
1633: -- customer pre-processing
1667: ,x_ovdv_rec => x_ovdv_rec
1668:
1669: );
1670:
1671: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1672: RAISE FND_API.G_EXC_ERROR;
1673: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1675: END IF;
1668:
1669: );
1670:
1671: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1672: RAISE FND_API.G_EXC_ERROR;
1673: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1675: END IF;
1676:
1669: );
1670:
1671: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1672: RAISE FND_API.G_EXC_ERROR;
1673: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1675: END IF;
1676:
1677: l_ovdv_rec := x_ovdv_rec;
1670:
1671: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1672: RAISE FND_API.G_EXC_ERROR;
1673: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1675: END IF;
1676:
1677: l_ovdv_rec := x_ovdv_rec;
1678:
1691:
1692:
1693: EXCEPTION
1694:
1695: WHEN FND_API.G_EXC_ERROR THEN
1696: ROLLBACK TO create_option_val_rules;
1697: x_return_status := FND_API.G_RET_STS_ERROR;
1698:
1699: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1693: EXCEPTION
1694:
1695: WHEN FND_API.G_EXC_ERROR THEN
1696: ROLLBACK TO create_option_val_rules;
1697: x_return_status := FND_API.G_RET_STS_ERROR;
1698:
1699: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1700: ,p_count => x_msg_count
1701: ,p_data => x_msg_data);
1699: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1700: ,p_count => x_msg_count
1701: ,p_data => x_msg_data);
1702:
1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1704: ROLLBACK TO create_option_val_rules;
1705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1706: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1707: ,p_count => x_msg_count
1701: ,p_data => x_msg_data);
1702:
1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1704: ROLLBACK TO create_option_val_rules;
1705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1706: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1707: ,p_count => x_msg_count
1708: ,p_data => x_msg_data);
1709:
1713: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1714: ,p_count => x_msg_count
1715: ,p_data => x_msg_data);
1716: -- notify caller of an UNEXPECTED error
1717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1718:
1719: END create_option_val_rules;
1720:
1721:
1735: ,p_ovdv_tbl IN ovdv_tbl_type
1736:
1737: ,x_ovdv_tbl OUT NOCOPY ovdv_tbl_type) IS
1738:
1739: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1740:
1741: l_api_name CONSTANT VARCHAR2(30) := 'create_option_val_rules';
1742:
1743: i NUMBER;
1741: l_api_name CONSTANT VARCHAR2(30) := 'create_option_val_rules';
1742:
1743: i NUMBER;
1744:
1745: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1746:
1747: l_ovdv_tbl ovdv_tbl_type := p_ovdv_tbl;
1748:
1749: BEGIN
1749: BEGIN
1750:
1751: --Initialize the return status
1752: SAVEPOINT create_option_val_rules;
1753: x_return_status := FND_API.G_RET_STS_SUCCESS;
1754:
1755:
1756:
1757: -- customer pre-processing
1791: ,x_ovdv_rec => x_ovdv_tbl(i)
1792:
1793: );
1794: -- store the highest degree of error
1795: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1796: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1797: l_overall_status := x_return_status;
1798: END IF;
1799: END IF;
1792:
1793: );
1794: -- store the highest degree of error
1795: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1796: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1797: l_overall_status := x_return_status;
1798: END IF;
1799: END IF;
1800:
1807: l_return_status := l_overall_status;
1808:
1809: END IF;
1810:
1811: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1812: RAISE FND_API.G_EXC_ERROR;
1813: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1815: END IF;
1808:
1809: END IF;
1810:
1811: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1812: RAISE FND_API.G_EXC_ERROR;
1813: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1815: END IF;
1816:
1809: END IF;
1810:
1811: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1812: RAISE FND_API.G_EXC_ERROR;
1813: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1815: END IF;
1816:
1817:
1810:
1811: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1812: RAISE FND_API.G_EXC_ERROR;
1813: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1815: END IF;
1816:
1817:
1818: l_ovdv_tbl := x_ovdv_tbl;
1832:
1833:
1834: EXCEPTION
1835:
1836: WHEN FND_API.G_EXC_ERROR THEN
1837: ROLLBACK TO create_option_val_rules;
1838: x_return_status := FND_API.G_RET_STS_ERROR;
1839:
1840: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1834: EXCEPTION
1835:
1836: WHEN FND_API.G_EXC_ERROR THEN
1837: ROLLBACK TO create_option_val_rules;
1838: x_return_status := FND_API.G_RET_STS_ERROR;
1839:
1840: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1841: ,p_count => x_msg_count
1842: ,p_data => x_msg_data);
1840: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1841: ,p_count => x_msg_count
1842: ,p_data => x_msg_data);
1843:
1844: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1845: ROLLBACK TO create_option_val_rules;
1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1847: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1848: ,p_count => x_msg_count
1842: ,p_data => x_msg_data);
1843:
1844: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1845: ROLLBACK TO create_option_val_rules;
1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1847: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1848: ,p_count => x_msg_count
1849: ,p_data => x_msg_data);
1850:
1854: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1855: ,p_count => x_msg_count
1856: ,p_data => x_msg_data);
1857: -- notify caller of an UNEXPECTED error
1858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1859:
1860:
1861:
1862: END create_option_val_rules;
1876: ,x_msg_data OUT NOCOPY VARCHAR2
1877:
1878: ,p_ovdv_rec IN ovdv_rec_type) IS
1879:
1880: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1881:
1882: l_api_name CONSTANT VARCHAR2(30) := 'lock_option_val_rules';
1883:
1884: BEGIN
1882: l_api_name CONSTANT VARCHAR2(30) := 'lock_option_val_rules';
1883:
1884: BEGIN
1885:
1886: x_return_status := FND_API.G_RET_STS_SUCCESS;
1887: SAVEPOINT lock_option_val_rules;
1888:
1889: okl_option_rules_pvt.lock_option_val_rules(
1890:
1901: ,p_ovdv_rec => p_ovdv_rec
1902:
1903: );
1904:
1905: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1906: RAISE FND_API.G_EXC_ERROR;
1907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1909: END IF;
1902:
1903: );
1904:
1905: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1906: RAISE FND_API.G_EXC_ERROR;
1907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1909: END IF;
1910:
1903: );
1904:
1905: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1906: RAISE FND_API.G_EXC_ERROR;
1907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1909: END IF;
1910:
1911: EXCEPTION
1904:
1905: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1906: RAISE FND_API.G_EXC_ERROR;
1907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1909: END IF;
1910:
1911: EXCEPTION
1912: WHEN FND_API.G_EXC_ERROR THEN
1908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1909: END IF;
1910:
1911: EXCEPTION
1912: WHEN FND_API.G_EXC_ERROR THEN
1913: ROLLBACK TO lock_option_val_rules;
1914: x_return_status := FND_API.G_RET_STS_ERROR;
1915:
1916: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1910:
1911: EXCEPTION
1912: WHEN FND_API.G_EXC_ERROR THEN
1913: ROLLBACK TO lock_option_val_rules;
1914: x_return_status := FND_API.G_RET_STS_ERROR;
1915:
1916: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1917: ,p_count => x_msg_count
1918: ,p_data => x_msg_data);
1916: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1917: ,p_count => x_msg_count
1918: ,p_data => x_msg_data);
1919:
1920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1921: ROLLBACK TO lock_option_val_rules;
1922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1923: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1924: ,p_count => x_msg_count
1918: ,p_data => x_msg_data);
1919:
1920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1921: ROLLBACK TO lock_option_val_rules;
1922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1923: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1924: ,p_count => x_msg_count
1925: ,p_data => x_msg_data);
1926:
1930: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1931: ,p_count => x_msg_count
1932: ,p_data => x_msg_data);
1933: -- notify caller of an UNEXPECTED error
1934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1935:
1936: END lock_option_val_rules;
1937:
1938:
1950: ,x_msg_data OUT NOCOPY VARCHAR2
1951:
1952: ,p_ovdv_tbl IN ovdv_tbl_type) IS
1953:
1954: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1955:
1956: l_api_name CONSTANT VARCHAR2(30) := 'lock_option_val_rules';
1957:
1958: i NUMBER;
1956: l_api_name CONSTANT VARCHAR2(30) := 'lock_option_val_rules';
1957:
1958: i NUMBER;
1959:
1960: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1961:
1962:
1963: BEGIN
1964:
1963: BEGIN
1964:
1965: --Initialize the return status
1966:
1967: x_return_status := FND_API.G_RET_STS_SUCCESS;
1968: SAVEPOINT lock_option_val_rules;
1969:
1970: IF (p_ovdv_tbl.COUNT > 0) THEN
1971:
1988: ,p_ovdv_rec => p_ovdv_tbl(i)
1989:
1990: );
1991: -- store the highest degree of error
1992: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1993: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1994: l_overall_status := x_return_status;
1995: END IF;
1996: END IF;
1989:
1990: );
1991: -- store the highest degree of error
1992: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1993: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
1994: l_overall_status := x_return_status;
1995: END IF;
1996: END IF;
1997:
2005: l_return_status := l_overall_status;
2006:
2007: END IF;
2008:
2009: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2010: RAISE FND_API.G_EXC_ERROR;
2011: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2013: END IF;
2006:
2007: END IF;
2008:
2009: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2010: RAISE FND_API.G_EXC_ERROR;
2011: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2013: END IF;
2014:
2007: END IF;
2008:
2009: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2010: RAISE FND_API.G_EXC_ERROR;
2011: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2013: END IF;
2014:
2015: EXCEPTION
2008:
2009: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2010: RAISE FND_API.G_EXC_ERROR;
2011: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2013: END IF;
2014:
2015: EXCEPTION
2016: WHEN FND_API.G_EXC_ERROR THEN
2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2013: END IF;
2014:
2015: EXCEPTION
2016: WHEN FND_API.G_EXC_ERROR THEN
2017: ROLLBACK TO lock_option_val_rules;
2018: x_return_status := FND_API.G_RET_STS_ERROR;
2019:
2020: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2014:
2015: EXCEPTION
2016: WHEN FND_API.G_EXC_ERROR THEN
2017: ROLLBACK TO lock_option_val_rules;
2018: x_return_status := FND_API.G_RET_STS_ERROR;
2019:
2020: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2021: ,p_count => x_msg_count
2022: ,p_data => x_msg_data);
2020: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2021: ,p_count => x_msg_count
2022: ,p_data => x_msg_data);
2023:
2024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2025: ROLLBACK TO lock_option_val_rules;
2026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2027: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2028: ,p_count => x_msg_count
2022: ,p_data => x_msg_data);
2023:
2024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2025: ROLLBACK TO lock_option_val_rules;
2026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2027: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2028: ,p_count => x_msg_count
2029: ,p_data => x_msg_data);
2030:
2034: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2035: ,p_count => x_msg_count
2036: ,p_data => x_msg_data);
2037: -- notify caller of an UNEXPECTED error
2038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2039:
2040: END lock_option_val_rules;
2041:
2042:
2056: ,p_ovdv_rec IN ovdv_rec_type
2057:
2058: ,x_ovdv_rec OUT NOCOPY ovdv_rec_type) IS
2059:
2060: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2061:
2062: l_api_name CONSTANT VARCHAR2(30) := 'update_option_val_rules';
2063:
2064: l_ovdv_rec ovdv_rec_type := p_ovdv_rec;
2065:
2066: BEGIN
2067:
2068: SAVEPOINT update_option_val_rules;
2069: x_return_status := FND_API.G_RET_STS_SUCCESS;
2070:
2071:
2072:
2073: -- customer pre-processing
2103: ,x_ovdv_rec => x_ovdv_rec
2104:
2105: );
2106:
2107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2108: RAISE FND_API.G_EXC_ERROR;
2109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2111: END IF;
2104:
2105: );
2106:
2107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2108: RAISE FND_API.G_EXC_ERROR;
2109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2111: END IF;
2112:
2105: );
2106:
2107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2108: RAISE FND_API.G_EXC_ERROR;
2109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2111: END IF;
2112:
2113: l_ovdv_rec := x_ovdv_rec;
2106:
2107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2108: RAISE FND_API.G_EXC_ERROR;
2109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2111: END IF;
2112:
2113: l_ovdv_rec := x_ovdv_rec;
2114:
2127:
2128:
2129: EXCEPTION
2130:
2131: WHEN FND_API.G_EXC_ERROR THEN
2132: ROLLBACK TO update_option_val_rules;
2133: x_return_status := FND_API.G_RET_STS_ERROR;
2134:
2135: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2129: EXCEPTION
2130:
2131: WHEN FND_API.G_EXC_ERROR THEN
2132: ROLLBACK TO update_option_val_rules;
2133: x_return_status := FND_API.G_RET_STS_ERROR;
2134:
2135: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2136: ,p_count => x_msg_count
2137: ,p_data => x_msg_data);
2135: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2136: ,p_count => x_msg_count
2137: ,p_data => x_msg_data);
2138:
2139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2140: ROLLBACK TO update_option_val_rules;
2141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2142: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2143: ,p_count => x_msg_count
2137: ,p_data => x_msg_data);
2138:
2139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2140: ROLLBACK TO update_option_val_rules;
2141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2142: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2143: ,p_count => x_msg_count
2144: ,p_data => x_msg_data);
2145:
2149: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2150: ,p_count => x_msg_count
2151: ,p_data => x_msg_data);
2152: -- notify caller of an UNEXPECTED error
2153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2154:
2155: END update_option_val_rules;
2156:
2157:
2171: ,p_ovdv_tbl IN ovdv_tbl_type
2172:
2173: ,x_ovdv_tbl OUT NOCOPY ovdv_tbl_type) IS
2174:
2175: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2176:
2177: l_api_name CONSTANT VARCHAR2(30) := 'update_option_val_rules';
2178:
2179: i NUMBER;
2177: l_api_name CONSTANT VARCHAR2(30) := 'update_option_val_rules';
2178:
2179: i NUMBER;
2180:
2181: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2182:
2183: l_ovdv_tbl ovdv_tbl_type := p_ovdv_tbl;
2184:
2185: BEGIN
2185: BEGIN
2186:
2187: --Initialize the return status
2188: SAVEPOINT update_option_val_rules;
2189: x_return_status := FND_API.G_RET_STS_SUCCESS;
2190:
2191:
2192:
2193: -- customer pre-processing
2227: ,x_ovdv_rec => x_ovdv_tbl(i)
2228:
2229: );
2230: -- store the highest degree of error
2231: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2232: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2233: l_overall_status := x_return_status;
2234: END IF;
2235: END IF;
2228:
2229: );
2230: -- store the highest degree of error
2231: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2232: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2233: l_overall_status := x_return_status;
2234: END IF;
2235: END IF;
2236:
2243: l_return_status := l_overall_status;
2244:
2245: END IF;
2246:
2247: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2248: RAISE FND_API.G_EXC_ERROR;
2249: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2251: END IF;
2244:
2245: END IF;
2246:
2247: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2248: RAISE FND_API.G_EXC_ERROR;
2249: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2251: END IF;
2252:
2245: END IF;
2246:
2247: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2248: RAISE FND_API.G_EXC_ERROR;
2249: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2251: END IF;
2252:
2253: l_ovdv_tbl := x_ovdv_tbl;
2246:
2247: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2248: RAISE FND_API.G_EXC_ERROR;
2249: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2251: END IF;
2252:
2253: l_ovdv_tbl := x_ovdv_tbl;
2254:
2267:
2268:
2269: EXCEPTION
2270:
2271: WHEN FND_API.G_EXC_ERROR THEN
2272: ROLLBACK TO update_option_val_rules;
2273: x_return_status := FND_API.G_RET_STS_ERROR;
2274:
2275: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2269: EXCEPTION
2270:
2271: WHEN FND_API.G_EXC_ERROR THEN
2272: ROLLBACK TO update_option_val_rules;
2273: x_return_status := FND_API.G_RET_STS_ERROR;
2274:
2275: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2276: ,p_count => x_msg_count
2277: ,p_data => x_msg_data);
2275: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2276: ,p_count => x_msg_count
2277: ,p_data => x_msg_data);
2278:
2279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2280: ROLLBACK TO update_option_val_rules;
2281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2282: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2283: ,p_count => x_msg_count
2277: ,p_data => x_msg_data);
2278:
2279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2280: ROLLBACK TO update_option_val_rules;
2281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2282: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2283: ,p_count => x_msg_count
2284: ,p_data => x_msg_data);
2285:
2289: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2290: ,p_count => x_msg_count
2291: ,p_data => x_msg_data);
2292: -- notify caller of an UNEXPECTED error
2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2294:
2295:
2296:
2297: END update_option_val_rules;
2315: ,p_ovdv_rec IN ovdv_rec_type) IS
2316:
2317: i NUMBER :=0;
2318:
2319: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2320:
2321: l_api_name CONSTANT VARCHAR2(30) := 'delete_option_val_rules';
2322:
2323: l_ovdv_rec ovdv_rec_type := p_ovdv_rec;
2324:
2325: BEGIN
2326:
2327: SAVEPOINT delete_option_val_rules;
2328: x_return_status := FND_API.G_RET_STS_SUCCESS;
2329:
2330:
2331:
2332: -- customer pre-processing
2360: ,x_msg_data => x_msg_data
2361:
2362: ,p_ovdv_rec => l_ovdv_rec);
2363:
2364: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2365: RAISE FND_API.G_EXC_ERROR;
2366: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2368: END IF;
2361:
2362: ,p_ovdv_rec => l_ovdv_rec);
2363:
2364: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2365: RAISE FND_API.G_EXC_ERROR;
2366: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2368: END IF;
2369:
2362: ,p_ovdv_rec => l_ovdv_rec);
2363:
2364: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2365: RAISE FND_API.G_EXC_ERROR;
2366: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2368: END IF;
2369:
2370:
2363:
2364: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2365: RAISE FND_API.G_EXC_ERROR;
2366: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2368: END IF;
2369:
2370:
2371:
2384:
2385:
2386: EXCEPTION
2387:
2388: WHEN FND_API.G_EXC_ERROR THEN
2389: ROLLBACK TO delete_option_val_rules;
2390: x_return_status := FND_API.G_RET_STS_ERROR;
2391:
2392: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2386: EXCEPTION
2387:
2388: WHEN FND_API.G_EXC_ERROR THEN
2389: ROLLBACK TO delete_option_val_rules;
2390: x_return_status := FND_API.G_RET_STS_ERROR;
2391:
2392: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2393: ,p_count => x_msg_count
2394: ,p_data => x_msg_data);
2392: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2393: ,p_count => x_msg_count
2394: ,p_data => x_msg_data);
2395:
2396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2397: ROLLBACK TO delete_option_val_rules;
2398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2399: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2400: ,p_count => x_msg_count
2394: ,p_data => x_msg_data);
2395:
2396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2397: ROLLBACK TO delete_option_val_rules;
2398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2399: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2400: ,p_count => x_msg_count
2401: ,p_data => x_msg_data);
2402:
2406: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2407: ,p_count => x_msg_count
2408: ,p_data => x_msg_data);
2409: -- notify caller of an UNEXPECTED error
2410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2411:
2412: END delete_option_val_rules;
2413:
2414:
2430:
2431:
2432: i NUMBER :=0;
2433:
2434: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2435:
2436: l_api_name CONSTANT VARCHAR2(30) := 'delete_option_val_rules';
2437:
2438: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2434: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2435:
2436: l_api_name CONSTANT VARCHAR2(30) := 'delete_option_val_rules';
2437:
2438: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2439:
2440: l_ovdv_tbl ovdv_tbl_type := p_ovdv_tbl;
2441:
2442: BEGIN
2442: BEGIN
2443:
2444: --Initialize the return status
2445: SAVEPOINT delete_option_val_rules;
2446: x_return_status := FND_API.G_RET_STS_SUCCESS;
2447:
2448:
2449:
2450: -- customer pre-processing
2480: ,x_msg_data => x_msg_data
2481:
2482: ,p_ovdv_rec => l_ovdv_tbl(i));
2483: -- store the highest degree of error
2484: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2485: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2486: l_overall_status := x_return_status;
2487: END IF;
2488: END IF;
2481:
2482: ,p_ovdv_rec => l_ovdv_tbl(i));
2483: -- store the highest degree of error
2484: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2485: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2486: l_overall_status := x_return_status;
2487: END IF;
2488: END IF;
2489:
2496: l_return_status := l_overall_status;
2497:
2498: END IF;
2499:
2500: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2501: RAISE FND_API.G_EXC_ERROR;
2502: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2504: END IF;
2497:
2498: END IF;
2499:
2500: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2501: RAISE FND_API.G_EXC_ERROR;
2502: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2504: END IF;
2505:
2498: END IF;
2499:
2500: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2501: RAISE FND_API.G_EXC_ERROR;
2502: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2504: END IF;
2505:
2506:
2499:
2500: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2501: RAISE FND_API.G_EXC_ERROR;
2502: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2504: END IF;
2505:
2506:
2507:
2520:
2521:
2522: EXCEPTION
2523:
2524: WHEN FND_API.G_EXC_ERROR THEN
2525: ROLLBACK TO delete_option_val_rules;
2526: x_return_status := FND_API.G_RET_STS_ERROR;
2527:
2528: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2522: EXCEPTION
2523:
2524: WHEN FND_API.G_EXC_ERROR THEN
2525: ROLLBACK TO delete_option_val_rules;
2526: x_return_status := FND_API.G_RET_STS_ERROR;
2527:
2528: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2529: ,p_count => x_msg_count
2530: ,p_data => x_msg_data);
2528: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2529: ,p_count => x_msg_count
2530: ,p_data => x_msg_data);
2531:
2532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2533: ROLLBACK TO delete_option_val_rules;
2534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2535: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2536: ,p_count => x_msg_count
2530: ,p_data => x_msg_data);
2531:
2532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2533: ROLLBACK TO delete_option_val_rules;
2534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2535: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2536: ,p_count => x_msg_count
2537: ,p_data => x_msg_data);
2538:
2542: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2543: ,p_count => x_msg_count
2544: ,p_data => x_msg_data);
2545: -- notify caller of an UNEXPECTED error
2546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2547:
2548: END delete_option_val_rules;
2549:
2550:
2562: ,x_msg_data OUT NOCOPY VARCHAR2
2563:
2564: ,p_ovdv_rec IN ovdv_rec_type) IS
2565:
2566: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2567:
2568: l_api_name CONSTANT VARCHAR2(30) := 'validate_option_val_rules';
2569:
2570: l_ovdv_rec ovdv_rec_type := p_ovdv_rec;
2571:
2572: BEGIN
2573:
2574: SAVEPOINT validate_option_val_rules;
2575: x_return_status := FND_API.G_RET_STS_SUCCESS;
2576:
2577:
2578:
2579: -- customer pre-processing
2609: ,p_ovdv_rec => l_ovdv_rec
2610:
2611: );
2612:
2613: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2614: RAISE FND_API.G_EXC_ERROR;
2615: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2617: END IF;
2610:
2611: );
2612:
2613: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2614: RAISE FND_API.G_EXC_ERROR;
2615: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2617: END IF;
2618:
2611: );
2612:
2613: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2614: RAISE FND_API.G_EXC_ERROR;
2615: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2617: END IF;
2618:
2619:
2612:
2613: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2614: RAISE FND_API.G_EXC_ERROR;
2615: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2617: END IF;
2618:
2619:
2620:
2633:
2634:
2635: EXCEPTION
2636:
2637: WHEN FND_API.G_EXC_ERROR THEN
2638: ROLLBACK TO validate_option_val_rules;
2639: x_return_status := FND_API.G_RET_STS_ERROR;
2640:
2641: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2635: EXCEPTION
2636:
2637: WHEN FND_API.G_EXC_ERROR THEN
2638: ROLLBACK TO validate_option_val_rules;
2639: x_return_status := FND_API.G_RET_STS_ERROR;
2640:
2641: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2642: ,p_count => x_msg_count
2643: ,p_data => x_msg_data);
2641: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2642: ,p_count => x_msg_count
2643: ,p_data => x_msg_data);
2644:
2645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2646: ROLLBACK TO validate_option_val_rules;
2647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2648: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2649: ,p_count => x_msg_count
2643: ,p_data => x_msg_data);
2644:
2645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2646: ROLLBACK TO validate_option_val_rules;
2647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2648: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2649: ,p_count => x_msg_count
2650: ,p_data => x_msg_data);
2651:
2655: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2656: ,p_count => x_msg_count
2657: ,p_data => x_msg_data);
2658: -- notify caller of an UNEXPECTED error
2659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2660:
2661: END validate_option_val_rules;
2662:
2663:
2675: ,x_msg_data OUT NOCOPY VARCHAR2
2676:
2677: ,p_ovdv_tbl IN ovdv_tbl_type) IS
2678:
2679: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2680:
2681: l_api_name CONSTANT VARCHAR2(30) := 'validate_option_val_rules';
2682:
2683: i NUMBER;
2681: l_api_name CONSTANT VARCHAR2(30) := 'validate_option_val_rules';
2682:
2683: i NUMBER;
2684:
2685: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2686:
2687: l_ovdv_tbl ovdv_tbl_type := p_ovdv_tbl;
2688:
2689: BEGIN
2689: BEGIN
2690:
2691: --Initialize the return status
2692: SAVEPOINT validate_option_val_rules;
2693: x_return_status := FND_API.G_RET_STS_SUCCESS;
2694:
2695:
2696:
2697: -- customer pre-processing
2729: ,p_ovdv_rec => l_ovdv_tbl(i)
2730:
2731: );
2732: -- store the highest degree of error
2733: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2734: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2735: l_overall_status := x_return_status;
2736: END IF;
2737: END IF;
2730:
2731: );
2732: -- store the highest degree of error
2733: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2734: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
2735: l_overall_status := x_return_status;
2736: END IF;
2737: END IF;
2738:
2745: l_return_status := l_overall_status;
2746:
2747: END IF;
2748:
2749: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2750: RAISE FND_API.G_EXC_ERROR;
2751: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2753: END IF;
2746:
2747: END IF;
2748:
2749: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2750: RAISE FND_API.G_EXC_ERROR;
2751: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2753: END IF;
2754:
2747: END IF;
2748:
2749: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2750: RAISE FND_API.G_EXC_ERROR;
2751: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2753: END IF;
2754:
2755:
2748:
2749: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2750: RAISE FND_API.G_EXC_ERROR;
2751: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2753: END IF;
2754:
2755:
2756: -- vertical industry-post-processing
2768:
2769:
2770: EXCEPTION
2771:
2772: WHEN FND_API.G_EXC_ERROR THEN
2773: ROLLBACK TO validate_option_val_rules;
2774: x_return_status := FND_API.G_RET_STS_ERROR;
2775:
2776: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2770: EXCEPTION
2771:
2772: WHEN FND_API.G_EXC_ERROR THEN
2773: ROLLBACK TO validate_option_val_rules;
2774: x_return_status := FND_API.G_RET_STS_ERROR;
2775:
2776: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2777: ,p_count => x_msg_count
2778: ,p_data => x_msg_data);
2776: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2777: ,p_count => x_msg_count
2778: ,p_data => x_msg_data);
2779:
2780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2781: ROLLBACK TO validate_option_val_rules;
2782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2783: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2784: ,p_count => x_msg_count
2778: ,p_data => x_msg_data);
2779:
2780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2781: ROLLBACK TO validate_option_val_rules;
2782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2783: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2784: ,p_count => x_msg_count
2785: ,p_data => x_msg_data);
2786:
2790: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2791: ,p_count => x_msg_count
2792: ,p_data => x_msg_data);
2793: -- notify caller of an UNEXPECTED error
2794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2795:
2796: END validate_option_val_rules;
2797:
2798: