50: WHEN FND_API.G_EXC_ERROR THEN
51: ROLLBACK TO insert_sgn_translations;
52: x_return_status := FND_API.G_RET_STS_ERROR;
53:
54: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
55: ,p_count => x_msg_count
56: ,p_data => x_msg_data);
57:
58: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
57:
58: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
59: ROLLBACK TO insert_sgn_translations;
60: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
61: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
62: ,p_count => x_msg_count
63: ,p_data => x_msg_data);
64:
65: WHEN OTHERS THEN
62: ,p_count => x_msg_count
63: ,p_data => x_msg_data);
64:
65: WHEN OTHERS THEN
66: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','insert_sgn_translations');
67: -- store SQL error message on message stack for caller
68: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
69: ,p_count => x_msg_count
70: ,p_data => x_msg_data);
64:
65: WHEN OTHERS THEN
66: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','insert_sgn_translations');
67: -- store SQL error message on message stack for caller
68: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
69: ,p_count => x_msg_count
70: ,p_data => x_msg_data);
71: -- notify caller of an UNEXPECTED error
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
140: WHEN FND_API.G_EXC_ERROR THEN
141: ROLLBACK TO insert_sgn_translations;
142: x_return_status := FND_API.G_RET_STS_ERROR;
143:
144: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
145: ,p_count => x_msg_count
146: ,p_data => x_msg_data);
147:
148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
147:
148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
149: ROLLBACK TO insert_sgn_translations;
150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
151: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
152: ,p_count => x_msg_count
153: ,p_data => x_msg_data);
154:
155: WHEN OTHERS THEN
152: ,p_count => x_msg_count
153: ,p_data => x_msg_data);
154:
155: WHEN OTHERS THEN
156: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','insert_sgn_translations');
157: -- store SQL error message on message stack for caller
158: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
159: ,p_count => x_msg_count
160: ,p_data => x_msg_data);
154:
155: WHEN OTHERS THEN
156: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','insert_sgn_translations');
157: -- store SQL error message on message stack for caller
158: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
159: ,p_count => x_msg_count
160: ,p_data => x_msg_data);
161: -- notify caller of an UNEXPECTED error
162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
195: WHEN FND_API.G_EXC_ERROR THEN
196: ROLLBACK TO lock_sgn_translations;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198:
199: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
200: ,p_count => x_msg_count
201: ,p_data => x_msg_data);
202:
203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
202:
203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
204: ROLLBACK TO lock_sgn_translations;
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
206: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
207: ,p_count => x_msg_count
208: ,p_data => x_msg_data);
209:
210: WHEN OTHERS THEN
207: ,p_count => x_msg_count
208: ,p_data => x_msg_data);
209:
210: WHEN OTHERS THEN
211: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','lock_sgn_translations');
212: -- store SQL error message on message stack for caller
213: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
214: ,p_count => x_msg_count
215: ,p_data => x_msg_data);
209:
210: WHEN OTHERS THEN
211: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','lock_sgn_translations');
212: -- store SQL error message on message stack for caller
213: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
214: ,p_count => x_msg_count
215: ,p_data => x_msg_data);
216: -- notify caller of an UNEXPECTED error
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
272: WHEN FND_API.G_EXC_ERROR THEN
273: ROLLBACK TO lock_sgn_translations;
274: x_return_status := FND_API.G_RET_STS_ERROR;
275:
276: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
277: ,p_count => x_msg_count
278: ,p_data => x_msg_data);
279:
280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279:
280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
281: ROLLBACK TO lock_sgn_translations;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
284: ,p_count => x_msg_count
285: ,p_data => x_msg_data);
286:
287: WHEN OTHERS THEN
284: ,p_count => x_msg_count
285: ,p_data => x_msg_data);
286:
287: WHEN OTHERS THEN
288: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','lock_sgn_translations');
289: -- store SQL error message on message stack for caller
290: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
291: ,p_count => x_msg_count
292: ,p_data => x_msg_data);
286:
287: WHEN OTHERS THEN
288: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','lock_sgn_translations');
289: -- store SQL error message on message stack for caller
290: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
291: ,p_count => x_msg_count
292: ,p_data => x_msg_data);
293: -- notify caller of an UNEXPECTED error
294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
335: WHEN FND_API.G_EXC_ERROR THEN
336: ROLLBACK TO update_sgn_translations;
337: x_return_status := FND_API.G_RET_STS_ERROR;
338:
339: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
340: ,p_count => x_msg_count
341: ,p_data => x_msg_data);
342:
343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
342:
343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
344: ROLLBACK TO update_sgn_translations;
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
346: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
347: ,p_count => x_msg_count
348: ,p_data => x_msg_data);
349:
350: WHEN OTHERS THEN
347: ,p_count => x_msg_count
348: ,p_data => x_msg_data);
349:
350: WHEN OTHERS THEN
351: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','update_sgn_translations');
352: -- store SQL error message on message stack for caller
353: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
354: ,p_count => x_msg_count
355: ,p_data => x_msg_data);
349:
350: WHEN OTHERS THEN
351: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','update_sgn_translations');
352: -- store SQL error message on message stack for caller
353: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
354: ,p_count => x_msg_count
355: ,p_data => x_msg_data);
356: -- notify caller of an UNEXPECTED error
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423: WHEN FND_API.G_EXC_ERROR THEN
424: ROLLBACK TO update_sgn_translations;
425: x_return_status := FND_API.G_RET_STS_ERROR;
426:
427: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
428: ,p_count => x_msg_count
429: ,p_data => x_msg_data);
430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432: ROLLBACK TO update_sgn_translations;
433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
434: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
435: ,p_count => x_msg_count
436: ,p_data => x_msg_data);
437:
438: WHEN OTHERS THEN
435: ,p_count => x_msg_count
436: ,p_data => x_msg_data);
437:
438: WHEN OTHERS THEN
439: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','update_sgn_translations');
440: -- store SQL error message on message stack for caller
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);
437:
438: WHEN OTHERS THEN
439: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','update_sgn_translations');
440: -- store SQL error message on message stack for caller
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: -- notify caller of an UNEXPECTED error
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: WHEN FND_API.G_EXC_ERROR THEN
485: ROLLBACK TO delete_sgn_translations;
486: x_return_status := FND_API.G_RET_STS_ERROR;
487:
488: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
489: ,p_count => x_msg_count
490: ,p_data => x_msg_data);
491:
492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
491:
492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
493: ROLLBACK TO delete_sgn_translations;
494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
495: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
496: ,p_count => x_msg_count
497: ,p_data => x_msg_data);
498:
499: WHEN OTHERS THEN
496: ,p_count => x_msg_count
497: ,p_data => x_msg_data);
498:
499: WHEN OTHERS THEN
500: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','delete_sgn_translations');
501: -- store SQL error message on message stack for caller
502: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
503: ,p_count => x_msg_count
504: ,p_data => x_msg_data);
498:
499: WHEN OTHERS THEN
500: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','delete_sgn_translations');
501: -- store SQL error message on message stack for caller
502: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
503: ,p_count => x_msg_count
504: ,p_data => x_msg_data);
505: -- notify caller of an UNEXPECTED error
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570: WHEN FND_API.G_EXC_ERROR THEN
571: ROLLBACK TO delete_sgn_translations;
572: x_return_status := FND_API.G_RET_STS_ERROR;
573:
574: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
575: ,p_count => x_msg_count
576: ,p_data => x_msg_data);
577:
578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
577:
578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
579: ROLLBACK TO delete_sgn_translations;
580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
581: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
582: ,p_count => x_msg_count
583: ,p_data => x_msg_data);
584:
585: WHEN OTHERS THEN
582: ,p_count => x_msg_count
583: ,p_data => x_msg_data);
584:
585: WHEN OTHERS THEN
586: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','delete_sgn_translations');
587: -- store SQL error message on message stack for caller
588: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
589: ,p_count => x_msg_count
590: ,p_data => x_msg_data);
584:
585: WHEN OTHERS THEN
586: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','delete_sgn_translations');
587: -- store SQL error message on message stack for caller
588: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
589: ,p_count => x_msg_count
590: ,p_data => x_msg_data);
591: -- notify caller of an UNEXPECTED error
592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: WHEN FND_API.G_EXC_ERROR THEN
632: ROLLBACK TO validate_sgn_translations;
633: x_return_status := FND_API.G_RET_STS_ERROR;
634:
635: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
636: ,p_count => x_msg_count
637: ,p_data => x_msg_data);
638:
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
638:
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640: ROLLBACK TO validate_sgn_translations;
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
642: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
643: ,p_count => x_msg_count
644: ,p_data => x_msg_data);
645:
646: WHEN OTHERS THEN
643: ,p_count => x_msg_count
644: ,p_data => x_msg_data);
645:
646: WHEN OTHERS THEN
647: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','validate_sgn_translations');
648: -- store SQL error message on message stack for caller
649: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
650: ,p_count => x_msg_count
651: ,p_data => x_msg_data);
645:
646: WHEN OTHERS THEN
647: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','validate_sgn_translations');
648: -- store SQL error message on message stack for caller
649: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
650: ,p_count => x_msg_count
651: ,p_data => x_msg_data);
652: -- notify caller of an UNEXPECTED error
653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
719: WHEN FND_API.G_EXC_ERROR THEN
720: ROLLBACK TO validate_sgn_translations;
721: x_return_status := FND_API.G_RET_STS_ERROR;
722:
723: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
724: ,p_count => x_msg_count
725: ,p_data => x_msg_data);
726:
727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
726:
727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
728: ROLLBACK TO validate_sgn_translations;
729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
730: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
731: ,p_count => x_msg_count
732: ,p_data => x_msg_data);
733:
734: WHEN OTHERS THEN
731: ,p_count => x_msg_count
732: ,p_data => x_msg_data);
733:
734: WHEN OTHERS THEN
735: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','validate_sgn_translations');
736: -- store SQL error message on message stack for caller
737: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
738: ,p_count => x_msg_count
739: ,p_data => x_msg_data);
733:
734: WHEN OTHERS THEN
735: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','validate_sgn_translations');
736: -- store SQL error message on message stack for caller
737: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
738: ,p_count => x_msg_count
739: ,p_data => x_msg_data);
740: -- notify caller of an UNEXPECTED error
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;