50: EXCEPTION
51:
52: WHEN FND_API.G_EXC_ERROR THEN
53: x_return_status := FND_API.g_ret_sts_error ;
54: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
55: p_count => x_msg_count,
56: p_data => x_msg_data);
57: ERRBUF := x_msg_data;
58: RETCODE := 2;
58: RETCODE := 2;
59:
60: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
61: x_return_status := FND_API.g_ret_sts_unexp_error ;
62: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
63: p_count => x_msg_count,
64: p_data => x_msg_data);
65: ERRBUF := x_msg_data;
66: RETCODE := 2;
66: RETCODE := 2;
67:
68: WHEN OTHERS THEN
69: x_return_status := FND_API.g_ret_sts_unexp_error ;
70: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
71: p_count => x_msg_count,
72: p_data => x_msg_data);
73: ERRBUF := sqlerrm(sqlcode);
74: RETCODE := sqlcode;
138: EXCEPTION
139:
140: WHEN FND_API.G_EXC_ERROR THEN
141: x_return_status := FND_API.g_ret_sts_error ;
142: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
143: p_count => x_msg_count,
144: p_data => x_msg_data);
145: ERRBUF := x_msg_data;
146: RETCODE := 2;
146: RETCODE := 2;
147:
148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
149: x_return_status := FND_API.g_ret_sts_unexp_error ;
150: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
151: p_count => x_msg_count,
152: p_data => x_msg_data);
153: ERRBUF := x_msg_data;
154: RETCODE := 2;
154: RETCODE := 2;
155:
156: WHEN OTHERS THEN
157: x_return_status := FND_API.g_ret_sts_unexp_error ;
158: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
159: p_count => x_msg_count,
160: p_data => x_msg_data);
161: ERRBUF := sqlerrm(sqlcode);
162: RETCODE := sqlcode;
222: EXCEPTION
223:
224: WHEN FND_API.G_EXC_ERROR THEN
225: x_return_status := FND_API.g_ret_sts_error ;
226: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
227: p_count => x_msg_count,
228: p_data => x_msg_data);
229: ERRBUF := x_msg_data;
230: RETCODE := 2;
230: RETCODE := 2;
231:
232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
233: x_return_status := FND_API.g_ret_sts_unexp_error ;
234: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
235: p_count => x_msg_count,
236: p_data => x_msg_data);
237: ERRBUF := x_msg_data;
238: RETCODE := 2;
238: RETCODE := 2;
239:
240: WHEN OTHERS THEN
241: x_return_status := FND_API.g_ret_sts_unexp_error ;
242: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
243: p_count => x_msg_count,
244: p_data => x_msg_data);
245: ERRBUF := sqlerrm(sqlcode);
246: RETCODE := sqlcode;
313: EXCEPTION
314:
315: WHEN FND_API.G_EXC_ERROR THEN
316: x_return_status := FND_API.g_ret_sts_error ;
317: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
318: p_count => x_msg_count,
319: p_data => x_msg_data);
320: ERRBUF := x_msg_data;
321: RETCODE := 2;
321: RETCODE := 2;
322:
323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
324: x_return_status := FND_API.g_ret_sts_unexp_error ;
325: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
326: p_count => x_msg_count,
327: p_data => x_msg_data);
328: ERRBUF := x_msg_data;
329: RETCODE := 2;
329: RETCODE := 2;
330:
331: WHEN OTHERS THEN
332: x_return_status := FND_API.g_ret_sts_unexp_error ;
333: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
334: p_count => x_msg_count,
335: p_data => x_msg_data);
336: ERRBUF := sqlerrm(sqlcode);
337: RETCODE := sqlcode;
570: EXCEPTION
571:
572: WHEN FND_API.G_EXC_ERROR THEN
573: x_return_status := FND_API.g_ret_sts_error ;
574: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
575: p_count => x_msg_count,
576: p_data => x_msg_data);
577: ERRBUF := x_msg_data;
578: RETCODE := 2;
578: RETCODE := 2;
579:
580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
581: x_return_status := FND_API.g_ret_sts_unexp_error ;
582: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
583: p_count => x_msg_count,
584: p_data => x_msg_data);
585: ERRBUF := x_msg_data;
586: RETCODE := 2;
586: RETCODE := 2;
587:
588: WHEN OTHERS THEN
589: x_return_status := FND_API.g_ret_sts_unexp_error ;
590: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
591: p_count => x_msg_count,
592: p_data => x_msg_data);
593: ERRBUF := sqlerrm(sqlcode);
594: RETCODE := sqlcode;
659:
660: WHEN FND_API.G_EXC_ERROR THEN
661:
662: x_return_status := FND_API.g_ret_sts_error ;
663: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
664: p_count => x_msg_count,
665: p_data => x_msg_data);
666: ERRBUF := x_msg_data;
667: RETCODE := 2;
668:
669: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
670:
671: x_return_status := FND_API.g_ret_sts_unexp_error ;
672: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
673: p_count => x_msg_count,
674: p_data => x_msg_data);
675: ERRBUF := x_msg_data;
676: RETCODE := 2;
679:
680:
681: x_return_status := FND_API.g_ret_sts_unexp_error ;
682:
683: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
684: p_count => x_msg_count,
685: p_data => x_msg_data);
686:
687: ERRBUF := sqlerrm(sqlcode);
754: EXCEPTION
755:
756: WHEN FND_API.G_EXC_ERROR THEN
757: x_return_status := FND_API.g_ret_sts_error ;
758: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
759: p_count => x_msg_count,
760: p_data => x_msg_data);
761: ERRBUF := x_msg_data;
762: RETCODE := 2;
762: RETCODE := 2;
763:
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: x_return_status := FND_API.g_ret_sts_unexp_error ;
766: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
767: p_count => x_msg_count,
768: p_data => x_msg_data);
769: ERRBUF := x_msg_data;
770: RETCODE := 2;
770: RETCODE := 2;
771:
772: WHEN OTHERS THEN
773: x_return_status := FND_API.g_ret_sts_unexp_error ;
774: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
775: p_count => x_msg_count,
776: p_data => x_msg_data);
777: ERRBUF := sqlerrm(sqlcode);
778: RETCODE := sqlcode;