55: WHEN FND_API.G_EXC_ERROR THEN
56: ROLLBACK TO insert_formulae;
57: x_return_status := FND_API.G_RET_STS_ERROR;
58:
59: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
60: ,p_count => x_msg_count
61: ,p_data => x_msg_data);
62:
63: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
62:
63: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
64: ROLLBACK TO insert_formulae;
65: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
66: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
67: ,p_count => x_msg_count
68: ,p_data => x_msg_data);
69:
70: WHEN OTHERS THEN
67: ,p_count => x_msg_count
68: ,p_data => x_msg_data);
69:
70: WHEN OTHERS THEN
71: FND_MSG_PUB.ADD_EXC_MSG('OKL_FORMULAE_PUB','insert_formulae');
72: -- store SQL error message on message stack for caller
73: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
74: ,p_count => x_msg_count
75: ,p_data => x_msg_data);
69:
70: WHEN OTHERS THEN
71: FND_MSG_PUB.ADD_EXC_MSG('OKL_FORMULAE_PUB','insert_formulae');
72: -- store SQL error message on message stack for caller
73: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
74: ,p_count => x_msg_count
75: ,p_data => x_msg_data);
76: -- notify caller of an UNEXPECTED error
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
149: WHEN FND_API.G_EXC_ERROR THEN
150: ROLLBACK TO insert_formulae;
151: x_return_status := FND_API.G_RET_STS_ERROR;
152:
153: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
154: ,p_count => x_msg_count
155: ,p_data => x_msg_data);
156:
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
156:
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
158: ROLLBACK TO insert_formulae;
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
161: ,p_count => x_msg_count
162: ,p_data => x_msg_data);
163:
164: WHEN OTHERS THEN
161: ,p_count => x_msg_count
162: ,p_data => x_msg_data);
163:
164: WHEN OTHERS THEN
165: FND_MSG_PUB.ADD_EXC_MSG('OKL_FORMULAE_PUB','insert_formulae');
166: -- store SQL error message on message stack for caller
167: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
168: ,p_count => x_msg_count
169: ,p_data => x_msg_data);
163:
164: WHEN OTHERS THEN
165: FND_MSG_PUB.ADD_EXC_MSG('OKL_FORMULAE_PUB','insert_formulae');
166: -- store SQL error message on message stack for caller
167: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
168: ,p_count => x_msg_count
169: ,p_data => x_msg_data);
170: -- notify caller of an UNEXPECTED error
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207: WHEN FND_API.G_EXC_ERROR THEN
208: ROLLBACK TO lock_formulae;
209: x_return_status := FND_API.G_RET_STS_ERROR;
210:
211: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
212: ,p_count => x_msg_count
213: ,p_data => x_msg_data);
214:
215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
214:
215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
216: ROLLBACK TO lock_formulae;
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
219: ,p_count => x_msg_count
220: ,p_data => x_msg_data);
221:
222: WHEN OTHERS THEN
219: ,p_count => x_msg_count
220: ,p_data => x_msg_data);
221:
222: WHEN OTHERS THEN
223: FND_MSG_PUB.ADD_EXC_MSG('OKL_FORMULAE_PUB','lock_formulae');
224: -- store SQL error message on message stack for caller
225: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
226: ,p_count => x_msg_count
227: ,p_data => x_msg_data);
221:
222: WHEN OTHERS THEN
223: FND_MSG_PUB.ADD_EXC_MSG('OKL_FORMULAE_PUB','lock_formulae');
224: -- store SQL error message on message stack for caller
225: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
226: ,p_count => x_msg_count
227: ,p_data => x_msg_data);
228: -- notify caller of an UNEXPECTED error
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
287: WHEN FND_API.G_EXC_ERROR THEN
288: ROLLBACK TO lock_formulae;
289: x_return_status := FND_API.G_RET_STS_ERROR;
290:
291: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
292: ,p_count => x_msg_count
293: ,p_data => x_msg_data);
294:
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294:
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
296: ROLLBACK TO lock_formulae;
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
299: ,p_count => x_msg_count
300: ,p_data => x_msg_data);
301:
302: WHEN OTHERS THEN
299: ,p_count => x_msg_count
300: ,p_data => x_msg_data);
301:
302: WHEN OTHERS THEN
303: FND_MSG_PUB.ADD_EXC_MSG('OKL_FORMULAE_PUB','lock_formulae');
304: -- store SQL error message on message stack for caller
305: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
306: ,p_count => x_msg_count
307: ,p_data => x_msg_data);
301:
302: WHEN OTHERS THEN
303: FND_MSG_PUB.ADD_EXC_MSG('OKL_FORMULAE_PUB','lock_formulae');
304: -- store SQL error message on message stack for caller
305: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
306: ,p_count => x_msg_count
307: ,p_data => x_msg_data);
308: -- notify caller of an UNEXPECTED error
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
355: WHEN FND_API.G_EXC_ERROR THEN
356: ROLLBACK TO update_formulae;
357: x_return_status := FND_API.G_RET_STS_ERROR;
358:
359: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
360: ,p_count => x_msg_count
361: ,p_data => x_msg_data);
362:
363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
362:
363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
364: ROLLBACK TO update_formulae;
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
367: ,p_count => x_msg_count
368: ,p_data => x_msg_data);
369:
370: WHEN OTHERS THEN
367: ,p_count => x_msg_count
368: ,p_data => x_msg_data);
369:
370: WHEN OTHERS THEN
371: FND_MSG_PUB.ADD_EXC_MSG('OKL_FORMULAE_PUB','update_formulae');
372: -- store SQL error message on message stack for caller
373: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
374: ,p_count => x_msg_count
375: ,p_data => x_msg_data);
369:
370: WHEN OTHERS THEN
371: FND_MSG_PUB.ADD_EXC_MSG('OKL_FORMULAE_PUB','update_formulae');
372: -- store SQL error message on message stack for caller
373: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
374: ,p_count => x_msg_count
375: ,p_data => x_msg_data);
376: -- notify caller of an UNEXPECTED error
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449: WHEN FND_API.G_EXC_ERROR THEN
450: ROLLBACK TO update_formulae;
451: x_return_status := FND_API.G_RET_STS_ERROR;
452:
453: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
454: ,p_count => x_msg_count
455: ,p_data => x_msg_data);
456:
457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
456:
457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
458: ROLLBACK TO update_formulae;
459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
460: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
461: ,p_count => x_msg_count
462: ,p_data => x_msg_data);
463:
464: WHEN OTHERS THEN
461: ,p_count => x_msg_count
462: ,p_data => x_msg_data);
463:
464: WHEN OTHERS THEN
465: FND_MSG_PUB.ADD_EXC_MSG('OKL_FORMULAE_PUB','update_formulae');
466: -- store SQL error message on message stack for caller
467: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
468: ,p_count => x_msg_count
469: ,p_data => x_msg_data);
463:
464: WHEN OTHERS THEN
465: FND_MSG_PUB.ADD_EXC_MSG('OKL_FORMULAE_PUB','update_formulae');
466: -- store SQL error message on message stack for caller
467: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
468: ,p_count => x_msg_count
469: ,p_data => x_msg_data);
470: -- notify caller of an UNEXPECTED error
471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
512: WHEN FND_API.G_EXC_ERROR THEN
513: ROLLBACK TO delete_formulae;
514: x_return_status := FND_API.G_RET_STS_ERROR;
515:
516: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
517: ,p_count => x_msg_count
518: ,p_data => x_msg_data);
519:
520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
519:
520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
521: ROLLBACK TO delete_formulae;
522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
523: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
524: ,p_count => x_msg_count
525: ,p_data => x_msg_data);
526:
527: WHEN OTHERS THEN
524: ,p_count => x_msg_count
525: ,p_data => x_msg_data);
526:
527: WHEN OTHERS THEN
528: FND_MSG_PUB.ADD_EXC_MSG('OKL_FORMULAE_PUB','delete_formulae');
529: -- store SQL error message on message stack for caller
530: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
531: ,p_count => x_msg_count
532: ,p_data => x_msg_data);
526:
527: WHEN OTHERS THEN
528: FND_MSG_PUB.ADD_EXC_MSG('OKL_FORMULAE_PUB','delete_formulae');
529: -- store SQL error message on message stack for caller
530: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
531: ,p_count => x_msg_count
532: ,p_data => x_msg_data);
533: -- notify caller of an UNEXPECTED error
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601: WHEN FND_API.G_EXC_ERROR THEN
602: ROLLBACK TO delete_formulae;
603: x_return_status := FND_API.G_RET_STS_ERROR;
604:
605: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
606: ,p_count => x_msg_count
607: ,p_data => x_msg_data);
608:
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
608:
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
610: ROLLBACK TO delete_formulae;
611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
612: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
613: ,p_count => x_msg_count
614: ,p_data => x_msg_data);
615:
616: WHEN OTHERS THEN
613: ,p_count => x_msg_count
614: ,p_data => x_msg_data);
615:
616: WHEN OTHERS THEN
617: FND_MSG_PUB.ADD_EXC_MSG('OKL_FORMULAE_PUB','delete_formulae');
618: -- store SQL error message on message stack for caller
619: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
620: ,p_count => x_msg_count
621: ,p_data => x_msg_data);
615:
616: WHEN OTHERS THEN
617: FND_MSG_PUB.ADD_EXC_MSG('OKL_FORMULAE_PUB','delete_formulae');
618: -- store SQL error message on message stack for caller
619: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
620: ,p_count => x_msg_count
621: ,p_data => x_msg_data);
622: -- notify caller of an UNEXPECTED error
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
664: WHEN FND_API.G_EXC_ERROR THEN
665: ROLLBACK TO validate_formulae;
666: x_return_status := FND_API.G_RET_STS_ERROR;
667:
668: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
669: ,p_count => x_msg_count
670: ,p_data => x_msg_data);
671:
672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
671:
672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
673: ROLLBACK TO validate_formulae;
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
676: ,p_count => x_msg_count
677: ,p_data => x_msg_data);
678:
679: WHEN OTHERS THEN
676: ,p_count => x_msg_count
677: ,p_data => x_msg_data);
678:
679: WHEN OTHERS THEN
680: FND_MSG_PUB.ADD_EXC_MSG('OKL_FORMULAE_PUB','validate_formulae');
681: -- store SQL error message on message stack for caller
682: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
683: ,p_count => x_msg_count
684: ,p_data => x_msg_data);
678:
679: WHEN OTHERS THEN
680: FND_MSG_PUB.ADD_EXC_MSG('OKL_FORMULAE_PUB','validate_formulae');
681: -- store SQL error message on message stack for caller
682: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
683: ,p_count => x_msg_count
684: ,p_data => x_msg_data);
685: -- notify caller of an UNEXPECTED error
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
754: WHEN FND_API.G_EXC_ERROR THEN
755: ROLLBACK TO validate_formulae;
756: x_return_status := FND_API.G_RET_STS_ERROR;
757:
758: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
759: ,p_count => x_msg_count
760: ,p_data => x_msg_data);
761:
762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
761:
762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
763: ROLLBACK TO validate_formulae;
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
765: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
766: ,p_count => x_msg_count
767: ,p_data => x_msg_data);
768:
769: WHEN OTHERS THEN
766: ,p_count => x_msg_count
767: ,p_data => x_msg_data);
768:
769: WHEN OTHERS THEN
770: FND_MSG_PUB.ADD_EXC_MSG('OKL_FORMULAE_PUB','validate_formulae');
771: -- store SQL error message on message stack for caller
772: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
773: ,p_count => x_msg_count
774: ,p_data => x_msg_data);
768:
769: WHEN OTHERS THEN
770: FND_MSG_PUB.ADD_EXC_MSG('OKL_FORMULAE_PUB','validate_formulae');
771: -- store SQL error message on message stack for caller
772: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
773: ,p_count => x_msg_count
774: ,p_data => x_msg_data);
775: -- notify caller of an UNEXPECTED error
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;