32: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
33: END IF;
34: -- Initialize message list if p_init_msg_list is set to TRUE.
35: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
36: FND_MSG_PUB.initialize;
37: END IF;
38: l_sidv_rec := p_sidv_rec;
39: g_sidv_rec := l_sidv_rec;
40: -- Customer pre processing section
62: EXCEPTION
63: When FND_API.G_EXC_ERROR then
64: ROLLBACK TO create_sup_inv_pub;
65: x_return_status := FND_API.G_RET_STS_ERROR;
66: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
67: p_data => x_msg_data);
68: When FND_API.G_EXC_UNEXPECTED_ERROR then
69: ROLLBACK TO create_sup_inv_pub;
70: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
67: p_data => x_msg_data);
68: When FND_API.G_EXC_UNEXPECTED_ERROR then
69: ROLLBACK TO create_sup_inv_pub;
70: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
71: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
72: p_data => x_msg_data);
73: When OTHERS then
74: ROLLBACK TO create_sup_inv_pub;
75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
72: p_data => x_msg_data);
73: When OTHERS then
74: ROLLBACK TO create_sup_inv_pub;
75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
76: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'create_sup_inv_dtls_pub');
77: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
78: p_count => x_msg_count,
79: p_data => x_msg_data);
80: END create_sup_inv_dtls;
73: When OTHERS then
74: ROLLBACK TO create_sup_inv_pub;
75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
76: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'create_sup_inv_dtls_pub');
77: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
78: p_count => x_msg_count,
79: p_data => x_msg_data);
80: END create_sup_inv_dtls;
81:
129: EXCEPTION
130: WHEN FND_API.G_EXC_ERROR THEN
131: ROLLBACK TO create_sup_inv_pub;
132: x_return_status := FND_API.G_RET_STS_ERROR;
133: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
134: p_data => x_msg_data);
135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
136: ROLLBACK TO create_sup_inv_pub;
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: p_data => x_msg_data);
135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
136: ROLLBACK TO create_sup_inv_pub;
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
139: p_data => x_msg_data);
140: WHEN OTHERS then
141: ROLLBACK TO create_sup_inv_pub;
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
139: p_data => x_msg_data);
140: WHEN OTHERS then
141: ROLLBACK TO create_sup_inv_pub;
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'create_sup_inv_dtls_pub');
144: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
145: p_count => x_msg_count,
146: p_data => x_msg_data);
147: END create_sup_inv_dtls;
140: WHEN OTHERS then
141: ROLLBACK TO create_sup_inv_pub;
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'create_sup_inv_dtls_pub');
144: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
145: p_count => x_msg_count,
146: p_data => x_msg_data);
147: END create_sup_inv_dtls;
148:
176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
177: END IF;
178: -- Initialize message list if p_init_msg_list is set to TRUE.
179: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
180: FND_MSG_PUB.initialize;
181: END IF;
182: l_sidv_rec := p_sidv_rec;
183: g_sidv_rec := l_sidv_rec;
184: -- Customer pre processing section
206: EXCEPTION
207: When FND_API.G_EXC_ERROR then
208: ROLLBACK TO update_sup_inv_pub;
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
211: p_data => x_msg_data);
212: When FND_API.G_EXC_UNEXPECTED_ERROR then
213: ROLLBACK TO update_sup_inv_pub;
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
211: p_data => x_msg_data);
212: When FND_API.G_EXC_UNEXPECTED_ERROR then
213: ROLLBACK TO update_sup_inv_pub;
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
215: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
216: p_data => x_msg_data);
217: When OTHERS then
218: ROLLBACK TO update_sup_inv_pub;
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
216: p_data => x_msg_data);
217: When OTHERS then
218: ROLLBACK TO update_sup_inv_pub;
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'update_sup_inv_dtls_pub');
221: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
222: p_count => x_msg_count,
223: p_data => x_msg_data);
224: END update_sup_inv_dtls;
217: When OTHERS then
218: ROLLBACK TO update_sup_inv_pub;
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'update_sup_inv_dtls_pub');
221: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
222: p_count => x_msg_count,
223: p_data => x_msg_data);
224: END update_sup_inv_dtls;
225:
273: EXCEPTION
274: WHEN FND_API.G_EXC_ERROR THEN
275: ROLLBACK TO update_sup_inv_pub;
276: x_return_status := FND_API.G_RET_STS_ERROR;
277: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
278: p_data => x_msg_data);
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: ROLLBACK TO update_sup_inv_pub;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278: p_data => x_msg_data);
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: ROLLBACK TO update_sup_inv_pub;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
283: p_data => x_msg_data);
284: WHEN OTHERS then
285: ROLLBACK TO update_sup_inv_pub;
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: p_data => x_msg_data);
284: WHEN OTHERS then
285: ROLLBACK TO update_sup_inv_pub;
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
287: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'update_sup_inv_dtls_pub');
288: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
289: p_count => x_msg_count,
290: p_data => x_msg_data);
291: END update_sup_inv_dtls;
284: WHEN OTHERS then
285: ROLLBACK TO update_sup_inv_pub;
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
287: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'update_sup_inv_dtls_pub');
288: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
289: p_count => x_msg_count,
290: p_data => x_msg_data);
291: END update_sup_inv_dtls;
292:
319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
320: END IF;
321: -- Initialize message list if p_init_msg_list is set to TRUE.
322: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
323: FND_MSG_PUB.initialize;
324: END IF;
325: l_sidv_rec := p_sidv_rec;
326: g_sidv_rec := l_sidv_rec;
327: -- Customer pre processing section
347: EXCEPTION
348: When FND_API.G_EXC_ERROR then
349: ROLLBACK TO delete_sup_inv_pub;
350: x_return_status := FND_API.G_RET_STS_ERROR;
351: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
352: p_data => x_msg_data);
353: When FND_API.G_EXC_UNEXPECTED_ERROR then
354: ROLLBACK TO delete_sup_inv_pub;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: p_data => x_msg_data);
353: When FND_API.G_EXC_UNEXPECTED_ERROR then
354: ROLLBACK TO delete_sup_inv_pub;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
357: p_data => x_msg_data);
358: When OTHERS then
359: ROLLBACK TO delete_sup_inv_pub;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: p_data => x_msg_data);
358: When OTHERS then
359: ROLLBACK TO delete_sup_inv_pub;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'delete_sup_inv_pub');
362: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
363: p_count => x_msg_count,
364: p_data => x_msg_data);
365: END delete_sup_inv_dtls;
358: When OTHERS then
359: ROLLBACK TO delete_sup_inv_pub;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'delete_sup_inv_pub');
362: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
363: p_count => x_msg_count,
364: p_data => x_msg_data);
365: END delete_sup_inv_dtls;
366:
412: EXCEPTION
413: WHEN FND_API.G_EXC_ERROR THEN
414: ROLLBACK TO delete_sup_inv_pub;
415: x_return_status := FND_API.G_RET_STS_ERROR;
416: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
417: p_data => x_msg_data);
418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
419: ROLLBACK TO delete_sup_inv_pub;
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
417: p_data => x_msg_data);
418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
419: ROLLBACK TO delete_sup_inv_pub;
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
422: p_data => x_msg_data);
423: WHEN OTHERS then
424: ROLLBACK TO delete_sup_inv_pub;
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: p_data => x_msg_data);
423: WHEN OTHERS then
424: ROLLBACK TO delete_sup_inv_pub;
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
426: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'delete_sup_inv_pub');
427: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
428: p_count => x_msg_count,
429: p_data => x_msg_data);
430: END delete_sup_inv_dtls;
423: WHEN OTHERS then
424: ROLLBACK TO delete_sup_inv_pub;
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
426: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'delete_sup_inv_pub');
427: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
428: p_count => x_msg_count,
429: p_data => x_msg_data);
430: END delete_sup_inv_dtls;
431:
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: END IF;
461: -- Initialize message list if p_init_msg_list is set to TRUE.
462: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
463: FND_MSG_PUB.initialize;
464: END IF;
465: l_sidv_rec := p_sidv_rec;
466: g_sidv_rec := l_sidv_rec;
467: -- Customer pre processing section
487: EXCEPTION
488: When FND_API.G_EXC_ERROR then
489: ROLLBACK TO validate_sup_inv_pub;
490: x_return_status := FND_API.G_RET_STS_ERROR;
491: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
492: p_data => x_msg_data);
493: When FND_API.G_EXC_UNEXPECTED_ERROR then
494: ROLLBACK TO validate_sup_inv_pub;
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
492: p_data => x_msg_data);
493: When FND_API.G_EXC_UNEXPECTED_ERROR then
494: ROLLBACK TO validate_sup_inv_pub;
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
497: p_data => x_msg_data);
498: When OTHERS then
499: ROLLBACK TO validate_sup_inv_pub;
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: p_data => x_msg_data);
498: When OTHERS then
499: ROLLBACK TO validate_sup_inv_pub;
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
501: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'validate_sup_inv_pub');
502: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
503: p_count => x_msg_count,
504: p_data => x_msg_data);
505: END validate_sup_inv_dtls;
498: When OTHERS then
499: ROLLBACK TO validate_sup_inv_pub;
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
501: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'validate_sup_inv_pub');
502: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
503: p_count => x_msg_count,
504: p_data => x_msg_data);
505: END validate_sup_inv_dtls;
506:
552: EXCEPTION
553: WHEN FND_API.G_EXC_ERROR THEN
554: ROLLBACK TO validate_sup_inv_pub;
555: x_return_status := FND_API.G_RET_STS_ERROR;
556: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
557: p_data => x_msg_data);
558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
559: ROLLBACK TO validate_sup_inv_pub;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
557: p_data => x_msg_data);
558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
559: ROLLBACK TO validate_sup_inv_pub;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
562: p_data => x_msg_data);
563: WHEN OTHERS then
564: ROLLBACK TO validate_sup_inv_pub;
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562: p_data => x_msg_data);
563: WHEN OTHERS then
564: ROLLBACK TO validate_sup_inv_pub;
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
566: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'validate_sup_inv_pub');
567: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
568: p_count => x_msg_count,
569: p_data => x_msg_data);
570: END validate_sup_inv_dtls;
563: WHEN OTHERS then
564: ROLLBACK TO validate_sup_inv_pub;
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
566: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'validate_sup_inv_pub');
567: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
568: p_count => x_msg_count,
569: p_data => x_msg_data);
570: END validate_sup_inv_dtls;
571:
599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
600: END IF;
601: -- Initialize message list if p_init_msg_list is set to TRUE.
602: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
603: FND_MSG_PUB.initialize;
604: END IF;
605: l_sidv_rec := p_sidv_rec;
606: -- Business API call section
607: l_sidv_rec.id := p_sidv_rec.id;
622: EXCEPTION
623: When FND_API.G_EXC_ERROR then
624: ROLLBACK TO lock_sup_inv_pub;
625: x_return_status := FND_API.G_RET_STS_ERROR;
626: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
627: p_data => x_msg_data);
628: When FND_API.G_EXC_UNEXPECTED_ERROR then
629: ROLLBACK TO lock_sup_inv_pub;
630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: p_data => x_msg_data);
628: When FND_API.G_EXC_UNEXPECTED_ERROR then
629: ROLLBACK TO lock_sup_inv_pub;
630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
632: p_data => x_msg_data);
633: When OTHERS then
634: ROLLBACK TO lock_sup_inv_pub;
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
632: p_data => x_msg_data);
633: When OTHERS then
634: ROLLBACK TO lock_sup_inv_pub;
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'lock_sup_inv_pub');
637: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
638: p_count => x_msg_count,
639: p_data => x_msg_data);
640: END lock_sup_inv_dtls;
633: When OTHERS then
634: ROLLBACK TO lock_sup_inv_pub;
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'lock_sup_inv_pub');
637: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
638: p_count => x_msg_count,
639: p_data => x_msg_data);
640: END lock_sup_inv_dtls;
641:
687: EXCEPTION
688: WHEN FND_API.G_EXC_ERROR THEN
689: ROLLBACK TO lock_sup_inv_pub;
690: x_return_status := FND_API.G_RET_STS_ERROR;
691: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
692: p_data => x_msg_data);
693: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
694: ROLLBACK TO lock_sup_inv_pub;
695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
692: p_data => x_msg_data);
693: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
694: ROLLBACK TO lock_sup_inv_pub;
695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
696: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
697: p_data => x_msg_data);
698: WHEN OTHERS then
699: ROLLBACK TO lock_sup_inv_pub;
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
697: p_data => x_msg_data);
698: WHEN OTHERS then
699: ROLLBACK TO lock_sup_inv_pub;
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
701: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'lock_sup_inv_pub');
702: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
703: p_count => x_msg_count,
704: p_data => x_msg_data);
705: END lock_sup_inv_dtls;
698: WHEN OTHERS then
699: ROLLBACK TO lock_sup_inv_pub;
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
701: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'lock_sup_inv_pub');
702: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
703: p_count => x_msg_count,
704: p_data => x_msg_data);
705: END lock_sup_inv_dtls;
706: