52: WHEN FND_API.G_EXC_ERROR THEN
53: ROLLBACK TO insert_sif_trx_parms;
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_trx_parms;
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
64: ,p_count => x_msg_count
65: ,p_data => x_msg_data);
66:
67: WHEN OTHERS THEN
68: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','insert_sif_trx_parms');
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);
66:
67: WHEN OTHERS THEN
68: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','insert_sif_trx_parms');
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;
143: WHEN FND_API.G_EXC_ERROR THEN
144: ROLLBACK TO insert_sif_trx_parms;
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_trx_parms;
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
155: ,p_count => x_msg_count
156: ,p_data => x_msg_data);
157:
158: WHEN OTHERS THEN
159: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','insert_sif_trx_parms');
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);
157:
158: WHEN OTHERS THEN
159: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','insert_sif_trx_parms');
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;
201: WHEN FND_API.G_EXC_ERROR THEN
202: ROLLBACK TO lock_sif_trx_parms;
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_trx_parms;
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
213: ,p_count => x_msg_count
214: ,p_data => x_msg_data);
215:
216: WHEN OTHERS THEN
217: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','lock_sif_trx_parms');
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);
215:
216: WHEN OTHERS THEN
217: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','lock_sif_trx_parms');
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;
281: WHEN FND_API.G_EXC_ERROR THEN
282: ROLLBACK TO lock_sif_trx_parms;
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_trx_parms;
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
293: ,p_count => x_msg_count
294: ,p_data => x_msg_data);
295:
296: WHEN OTHERS THEN
297: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','lock_sif_trx_parms');
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);
295:
296: WHEN OTHERS THEN
297: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','lock_sif_trx_parms');
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;
347: WHEN FND_API.G_EXC_ERROR THEN
348: ROLLBACK TO update_sif_trx_parms;
349: x_return_status := FND_API.G_RET_STS_ERROR;
350:
351: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
352: ,p_count => x_msg_count
353: ,p_data => x_msg_data);
354:
355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
354:
355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
356: ROLLBACK TO update_sif_trx_parms;
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
359: ,p_count => x_msg_count
360: ,p_data => x_msg_data);
361:
362: WHEN OTHERS THEN
359: ,p_count => x_msg_count
360: ,p_data => x_msg_data);
361:
362: WHEN OTHERS THEN
363: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','update_sif_trx_parms');
364: -- store SQL error message on message stack for caller
365: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
366: ,p_count => x_msg_count
367: ,p_data => x_msg_data);
361:
362: WHEN OTHERS THEN
363: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','update_sif_trx_parms');
364: -- store SQL error message on message stack for caller
365: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
366: ,p_count => x_msg_count
367: ,p_data => x_msg_data);
368: -- notify caller of an UNEXPECTED error
369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
438: WHEN FND_API.G_EXC_ERROR THEN
439: ROLLBACK TO update_sif_trx_parms;
440: x_return_status := FND_API.G_RET_STS_ERROR;
441:
442: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
443: ,p_count => x_msg_count
444: ,p_data => x_msg_data);
445:
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
445:
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
447: ROLLBACK TO update_sif_trx_parms;
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
450: ,p_count => x_msg_count
451: ,p_data => x_msg_data);
452:
453: WHEN OTHERS THEN
450: ,p_count => x_msg_count
451: ,p_data => x_msg_data);
452:
453: WHEN OTHERS THEN
454: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','update_sif_trx_parms');
455: -- store SQL error message on message stack for caller
456: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
457: ,p_count => x_msg_count
458: ,p_data => x_msg_data);
452:
453: WHEN OTHERS THEN
454: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','update_sif_trx_parms');
455: -- store SQL error message on message stack for caller
456: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
457: ,p_count => x_msg_count
458: ,p_data => x_msg_data);
459: -- notify caller of an UNEXPECTED error
460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
502: WHEN FND_API.G_EXC_ERROR THEN
503: ROLLBACK TO delete_sif_trx_parms;
504: x_return_status := FND_API.G_RET_STS_ERROR;
505:
506: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
507: ,p_count => x_msg_count
508: ,p_data => x_msg_data);
509:
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
509:
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
511: ROLLBACK TO delete_sif_trx_parms;
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
513: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
514: ,p_count => x_msg_count
515: ,p_data => x_msg_data);
516:
517: WHEN OTHERS THEN
514: ,p_count => x_msg_count
515: ,p_data => x_msg_data);
516:
517: WHEN OTHERS THEN
518: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','delete_sif_trx_parms');
519: -- store SQL error message on message stack for caller
520: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
521: ,p_count => x_msg_count
522: ,p_data => x_msg_data);
516:
517: WHEN OTHERS THEN
518: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','delete_sif_trx_parms');
519: -- store SQL error message on message stack for caller
520: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
521: ,p_count => x_msg_count
522: ,p_data => x_msg_data);
523: -- notify caller of an UNEXPECTED error
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
593: WHEN FND_API.G_EXC_ERROR THEN
594: ROLLBACK TO delete_sif_trx_parms;
595: x_return_status := FND_API.G_RET_STS_ERROR;
596:
597: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
598: ,p_count => x_msg_count
599: ,p_data => x_msg_data);
600:
601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
600:
601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
602: ROLLBACK TO delete_sif_trx_parms;
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
604: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
605: ,p_count => x_msg_count
606: ,p_data => x_msg_data);
607:
608: WHEN OTHERS THEN
605: ,p_count => x_msg_count
606: ,p_data => x_msg_data);
607:
608: WHEN OTHERS THEN
609: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','delete_sif_trx_parms');
610: -- store SQL error message on message stack for caller
611: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
612: ,p_count => x_msg_count
613: ,p_data => x_msg_data);
607:
608: WHEN OTHERS THEN
609: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','delete_sif_trx_parms');
610: -- store SQL error message on message stack for caller
611: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
612: ,p_count => x_msg_count
613: ,p_data => x_msg_data);
614: -- notify caller of an UNEXPECTED error
615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
657: WHEN FND_API.G_EXC_ERROR THEN
658: ROLLBACK TO validate_sif_trx_parms;
659: x_return_status := FND_API.G_RET_STS_ERROR;
660:
661: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
662: ,p_count => x_msg_count
663: ,p_data => x_msg_data);
664:
665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
664:
665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
666: ROLLBACK TO validate_sif_trx_parms;
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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 OTHERS THEN
669: ,p_count => x_msg_count
670: ,p_data => x_msg_data);
671:
672: WHEN OTHERS THEN
673: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','validate_sif_trx_parms');
674: -- store SQL error message on message stack for caller
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);
671:
672: WHEN OTHERS THEN
673: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','validate_sif_trx_parms');
674: -- store SQL error message on message stack for caller
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: -- notify caller of an UNEXPECTED error
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
749: WHEN FND_API.G_EXC_ERROR THEN
750: ROLLBACK TO validate_sif_trx_parms;
751: x_return_status := FND_API.G_RET_STS_ERROR;
752:
753: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
754: ,p_count => x_msg_count
755: ,p_data => x_msg_data);
756:
757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
756:
757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
758: ROLLBACK TO validate_sif_trx_parms;
759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
760: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
761: ,p_count => x_msg_count
762: ,p_data => x_msg_data);
763:
764: WHEN OTHERS THEN
761: ,p_count => x_msg_count
762: ,p_data => x_msg_data);
763:
764: WHEN OTHERS THEN
765: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','validate_sif_trx_parms');
766: -- store SQL error message on message stack for caller
767: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
768: ,p_count => x_msg_count
769: ,p_data => x_msg_data);
763:
764: WHEN OTHERS THEN
765: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','validate_sif_trx_parms');
766: -- store SQL error message on message stack for caller
767: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
768: ,p_count => x_msg_count
769: ,p_data => x_msg_data);
770: -- notify caller of an UNEXPECTED error
771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;