9:
10:
11: PROCEDURE insert_sif_ret_levels(
12: p_api_version IN NUMBER
13: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
14: ,x_return_status OUT NOCOPY VARCHAR2
15: ,x_msg_count OUT NOCOPY NUMBER
16: ,x_msg_data OUT NOCOPY VARCHAR2
17: ,p_srlv_rec IN srlv_rec_type
52: WHEN FND_API.G_EXC_ERROR THEN
53: ROLLBACK TO insert_sif_ret_levels;
54: x_return_status := FND_API.G_RET_STS_ERROR;
55:
56: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
57: ,p_count => x_msg_count
58: ,p_data => x_msg_data);
59:
60: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
59:
60: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
61: ROLLBACK TO insert_sif_ret_levels;
62: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
63: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
64: ,p_count => x_msg_count
65: ,p_data => x_msg_data);
66:
67: WHEN OTHERS THEN
66:
67: WHEN OTHERS THEN
68: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_LEVELS_PUB','insert_sif_ret_levels');
69: -- store SQL error message on message stack for caller
70: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
71: ,p_count => x_msg_count
72: ,p_data => x_msg_data);
73: -- notify caller of an UNEXPECTED error
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
76:
77:
78: PROCEDURE insert_sif_ret_levels(
79: p_api_version IN NUMBER
80: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
81: ,x_return_status OUT NOCOPY VARCHAR2
82: ,x_msg_count OUT NOCOPY NUMBER
83: ,x_msg_data OUT NOCOPY VARCHAR2
84: ,p_srlv_tbl IN srlv_tbl_type
143: WHEN FND_API.G_EXC_ERROR THEN
144: ROLLBACK TO insert_sif_ret_levels;
145: x_return_status := FND_API.G_RET_STS_ERROR;
146:
147: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
148: ,p_count => x_msg_count
149: ,p_data => x_msg_data);
150:
151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
150:
151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
152: ROLLBACK TO insert_sif_ret_levels;
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
155: ,p_count => x_msg_count
156: ,p_data => x_msg_data);
157:
158: WHEN OTHERS THEN
157:
158: WHEN OTHERS THEN
159: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_LEVELS_PUB','insert_sif_ret_levels');
160: -- store SQL error message on message stack for caller
161: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
162: ,p_count => x_msg_count
163: ,p_data => x_msg_data);
164: -- notify caller of an UNEXPECTED error
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166: END insert_sif_ret_levels;
167:
168: PROCEDURE lock_sif_ret_levels(
169: p_api_version IN NUMBER
170: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
171: ,x_return_status OUT NOCOPY VARCHAR2
172: ,x_msg_count OUT NOCOPY NUMBER
173: ,x_msg_data OUT NOCOPY VARCHAR2
174: ,p_srlv_rec IN srlv_rec_type
201: WHEN FND_API.G_EXC_ERROR THEN
202: ROLLBACK TO lock_sif_ret_levels;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204:
205: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
206: ,p_count => x_msg_count
207: ,p_data => x_msg_data);
208:
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
208:
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
210: ROLLBACK TO lock_sif_ret_levels;
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
213: ,p_count => x_msg_count
214: ,p_data => x_msg_data);
215:
216: WHEN OTHERS THEN
215:
216: WHEN OTHERS THEN
217: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_LEVELS_PUB','lock_sif_ret_levels');
218: -- store SQL error message on message stack for caller
219: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
220: ,p_count => x_msg_count
221: ,p_data => x_msg_data);
222: -- notify caller of an UNEXPECTED error
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: END lock_sif_ret_levels;
225:
226: PROCEDURE lock_sif_ret_levels(
227: p_api_version IN NUMBER
228: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
229: ,x_return_status OUT NOCOPY VARCHAR2
230: ,x_msg_count OUT NOCOPY NUMBER
231: ,x_msg_data OUT NOCOPY VARCHAR2
232: ,p_srlv_tbl IN srlv_tbl_type
281: WHEN FND_API.G_EXC_ERROR THEN
282: ROLLBACK TO lock_sif_ret_levels;
283: x_return_status := FND_API.G_RET_STS_ERROR;
284:
285: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
286: ,p_count => x_msg_count
287: ,p_data => x_msg_data);
288:
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
288:
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
290: ROLLBACK TO lock_sif_ret_levels;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
293: ,p_count => x_msg_count
294: ,p_data => x_msg_data);
295:
296: WHEN OTHERS THEN
295:
296: WHEN OTHERS THEN
297: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_LEVELS_PUB','lock_sif_ret_levels');
298: -- store SQL error message on message stack for caller
299: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
300: ,p_count => x_msg_count
301: ,p_data => x_msg_data);
302: -- notify caller of an UNEXPECTED error
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: END lock_sif_ret_levels;
305:
306: PROCEDURE update_sif_ret_levels(
307: p_api_version IN NUMBER
308: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
309: ,x_return_status OUT NOCOPY VARCHAR2
310: ,x_msg_count OUT NOCOPY NUMBER
311: ,x_msg_data OUT NOCOPY VARCHAR2
312: ,p_srlv_rec IN srlv_rec_type
346: WHEN FND_API.G_EXC_ERROR THEN
347: ROLLBACK TO update_sif_ret_levels;
348: x_return_status := FND_API.G_RET_STS_ERROR;
349:
350: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
351: ,p_count => x_msg_count
352: ,p_data => x_msg_data);
353:
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
353:
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: ROLLBACK TO update_sif_ret_levels;
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
358: ,p_count => x_msg_count
359: ,p_data => x_msg_data);
360:
361: WHEN OTHERS THEN
360:
361: WHEN OTHERS THEN
362: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_LEVELS_PUB','update_sif_ret_levels');
363: -- store SQL error message on message stack for caller
364: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
365: ,p_count => x_msg_count
366: ,p_data => x_msg_data);
367: -- notify caller of an UNEXPECTED error
368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
370:
371:
372: PROCEDURE update_sif_ret_levels(
373: p_api_version IN NUMBER
374: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
375: ,x_return_status OUT NOCOPY VARCHAR2
376: ,x_msg_count OUT NOCOPY NUMBER
377: ,x_msg_data OUT NOCOPY VARCHAR2
378: ,p_srlv_tbl IN srlv_tbl_type
437: WHEN FND_API.G_EXC_ERROR THEN
438: ROLLBACK TO update_sif_ret_levels;
439: x_return_status := FND_API.G_RET_STS_ERROR;
440:
441: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
442: ,p_count => x_msg_count
443: ,p_data => x_msg_data);
444:
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
444:
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446: ROLLBACK TO update_sif_ret_levels;
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
449: ,p_count => x_msg_count
450: ,p_data => x_msg_data);
451:
452: WHEN OTHERS THEN
451:
452: WHEN OTHERS THEN
453: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_LEVELS_PUB','update_sif_ret_levels');
454: -- store SQL error message on message stack for caller
455: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
456: ,p_count => x_msg_count
457: ,p_data => x_msg_data);
458: -- notify caller of an UNEXPECTED error
459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
460: END update_sif_ret_levels;
461:
462: PROCEDURE delete_sif_ret_levels(
463: p_api_version IN NUMBER
464: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
465: ,x_return_status OUT NOCOPY VARCHAR2
466: ,x_msg_count OUT NOCOPY NUMBER
467: ,x_msg_data OUT NOCOPY VARCHAR2
468: ,p_srlv_rec IN srlv_rec_type
501: WHEN FND_API.G_EXC_ERROR THEN
502: ROLLBACK TO delete_sif_ret_levels;
503: x_return_status := FND_API.G_RET_STS_ERROR;
504:
505: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
506: ,p_count => x_msg_count
507: ,p_data => x_msg_data);
508:
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
508:
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
510: ROLLBACK TO delete_sif_ret_levels;
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
512: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
513: ,p_count => x_msg_count
514: ,p_data => x_msg_data);
515:
516: WHEN OTHERS THEN
515:
516: WHEN OTHERS THEN
517: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_LEVELS_PUB','delete_sif_ret_levels');
518: -- store SQL error message on message stack for caller
519: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
520: ,p_count => x_msg_count
521: ,p_data => x_msg_data);
522: -- notify caller of an UNEXPECTED error
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525:
526:
527: PROCEDURE delete_sif_ret_levels(
528: p_api_version IN NUMBER
529: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
530: ,x_return_status OUT NOCOPY VARCHAR2
531: ,x_msg_count OUT NOCOPY NUMBER
532: ,x_msg_data OUT NOCOPY VARCHAR2
533: ,p_srlv_tbl IN srlv_tbl_type
592: WHEN FND_API.G_EXC_ERROR THEN
593: ROLLBACK TO delete_sif_ret_levels;
594: x_return_status := FND_API.G_RET_STS_ERROR;
595:
596: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
597: ,p_count => x_msg_count
598: ,p_data => x_msg_data);
599:
600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
599:
600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
601: ROLLBACK TO delete_sif_ret_levels;
602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
603: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
604: ,p_count => x_msg_count
605: ,p_data => x_msg_data);
606:
607: WHEN OTHERS THEN
606:
607: WHEN OTHERS THEN
608: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_LEVELS_PUB','delete_sif_ret_levels');
609: -- store SQL error message on message stack for caller
610: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
611: ,p_count => x_msg_count
612: ,p_data => x_msg_data);
613: -- notify caller of an UNEXPECTED error
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615: END delete_sif_ret_levels;
616:
617: PROCEDURE validate_sif_ret_levels(
618: p_api_version IN NUMBER
619: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
620: ,x_return_status OUT NOCOPY VARCHAR2
621: ,x_msg_count OUT NOCOPY NUMBER
622: ,x_msg_data OUT NOCOPY VARCHAR2
623: ,p_srlv_rec IN srlv_rec_type
656: WHEN FND_API.G_EXC_ERROR THEN
657: ROLLBACK TO validate_sif_ret_levels;
658: x_return_status := FND_API.G_RET_STS_ERROR;
659:
660: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
661: ,p_count => x_msg_count
662: ,p_data => x_msg_data);
663:
664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
663:
664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
665: ROLLBACK TO validate_sif_ret_levels;
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
667: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
668: ,p_count => x_msg_count
669: ,p_data => x_msg_data);
670:
671: WHEN OTHERS THEN
670:
671: WHEN OTHERS THEN
672: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_LEVELS_PUB','validate_sif_ret_levels');
673: -- store SQL error message on message stack for caller
674: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
675: ,p_count => x_msg_count
676: ,p_data => x_msg_data);
677: -- notify caller of an UNEXPECTED error
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680:
681:
682: PROCEDURE validate_sif_ret_levels(
683: p_api_version IN NUMBER
684: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
685: ,x_return_status OUT NOCOPY VARCHAR2
686: ,x_msg_count OUT NOCOPY NUMBER
687: ,x_msg_data OUT NOCOPY VARCHAR2
688: ,p_srlv_tbl IN srlv_tbl_type
748: WHEN FND_API.G_EXC_ERROR THEN
749: ROLLBACK TO validate_sif_ret_levels;
750: x_return_status := FND_API.G_RET_STS_ERROR;
751:
752: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
753: ,p_count => x_msg_count
754: ,p_data => x_msg_data);
755:
756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
755:
756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
757: ROLLBACK TO validate_sif_ret_levels;
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
759: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
760: ,p_count => x_msg_count
761: ,p_data => x_msg_data);
762:
763: WHEN OTHERS THEN
762:
763: WHEN OTHERS THEN
764: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_LEVELS_PUB','validate_sif_ret_levels');
765: -- store SQL error message on message stack for caller
766: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
767: ,p_count => x_msg_count
768: ,p_data => x_msg_data);
769: -- notify caller of an UNEXPECTED error
770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;