173: ROLLBACK TO insert_pending;
174: x_return_status := FND_API.G_RET_STS_ERROR;
175: x_msg_count := l_msg_count ;
176: x_msg_data := l_msg_data ;
177: FND_MSG_PUB.count_and_get(
178: p_count => x_msg_count
179: ,p_data => x_msg_data);
180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
181: ROLLBACK TO insert_pending;
181: ROLLBACK TO insert_pending;
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
183: x_msg_count := l_msg_count ;
184: x_msg_data := l_msg_data ;
185: FND_MSG_PUB.count_and_get(
186: p_count => x_msg_count
187: ,p_data => x_msg_data);
188: WHEN OTHERS THEN
189: ROLLBACK TO insert_pending;
189: ROLLBACK TO insert_pending;
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
191: x_msg_count := l_msg_count ;
192: x_msg_data := l_msg_data ;
193: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INTERFACE_PUB','insert_pending_int');
194: FND_MSG_PUB.count_and_get(
195: p_count => x_msg_count
196: ,p_data => x_msg_data);
197: END insert_pending;
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
191: x_msg_count := l_msg_count ;
192: x_msg_data := l_msg_data ;
193: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INTERFACE_PUB','insert_pending_int');
194: FND_MSG_PUB.count_and_get(
195: p_count => x_msg_count
196: ,p_data => x_msg_data);
197: END insert_pending;
198:
292: ROLLBACK TO complete_report_cb;
293: x_return_status := FND_API.G_RET_STS_ERROR;
294: x_msg_count := l_msg_count ;
295: x_msg_data := l_msg_data ;
296: FND_MSG_PUB.count_and_get(
297: p_count => x_msg_count
298: ,p_data => x_msg_data);
299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
300: ROLLBACK TO complete_report_cb;
300: ROLLBACK TO complete_report_cb;
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: x_msg_count := l_msg_count ;
303: x_msg_data := l_msg_data ;
304: FND_MSG_PUB.count_and_get(
305: p_count => x_msg_count
306: ,p_data => x_msg_data);
307: WHEN OTHERS THEN
308: ROLLBACK TO complete_report_cb;
308: ROLLBACK TO complete_report_cb;
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
310: x_msg_count := l_msg_count ;
311: x_msg_data := l_msg_data ;
312: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INTERFACE_PUB','complete_report_cb');
313: FND_MSG_PUB.count_and_get(
314: p_count => x_msg_count
315: ,p_data => x_msg_data);
316:
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
310: x_msg_count := l_msg_count ;
311: x_msg_data := l_msg_data ;
312: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INTERFACE_PUB','complete_report_cb');
313: FND_MSG_PUB.count_and_get(
314: p_count => x_msg_count
315: ,p_data => x_msg_data);
316:
317: END complete_report_cb;
377: ROLLBACK TO complete_transfer;
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: x_msg_count := l_msg_count ;
380: x_msg_data := l_msg_data ;
381: FND_MSG_PUB.count_and_get(
382: p_count => x_msg_count
383: ,p_data => x_msg_data);
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: ROLLBACK TO complete_transfer;
385: ROLLBACK TO complete_transfer;
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: x_msg_count := l_msg_count ;
388: x_msg_data := l_msg_data ;
389: FND_MSG_PUB.count_and_get(
390: p_count => x_msg_count
391: ,p_data => x_msg_data);
392: WHEN OTHERS THEN
393: ROLLBACK TO complete_transfer;
393: ROLLBACK TO complete_transfer;
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395: x_msg_count := l_msg_count ;
396: x_msg_data := l_msg_data ;
397: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INTERFACE_PUB','complete_transfer');
398: FND_MSG_PUB.count_and_get(
399: p_count => x_msg_count
400: ,p_data => x_msg_data);
401:
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395: x_msg_count := l_msg_count ;
396: x_msg_data := l_msg_data ;
397: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INTERFACE_PUB','complete_transfer');
398: FND_MSG_PUB.count_and_get(
399: p_count => x_msg_count
400: ,p_data => x_msg_data);
401:
402: END complete_transfer;
465: ROLLBACK TO recall_transfer;
466: x_return_status := FND_API.G_RET_STS_ERROR;
467: x_msg_count := l_msg_count ;
468: x_msg_data := l_msg_data ;
469: FND_MSG_PUB.count_and_get(
470: p_count => x_msg_count
471: ,p_data => x_msg_data);
472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
473: ROLLBACK TO recall_transfer;
473: ROLLBACK TO recall_transfer;
474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
475: x_msg_count := l_msg_count ;
476: x_msg_data := l_msg_data ;
477: FND_MSG_PUB.count_and_get(
478: p_count => x_msg_count
479: ,p_data => x_msg_data);
480: WHEN OTHERS THEN
481: ROLLBACK TO recall_transfer;
481: ROLLBACK TO recall_transfer;
482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
483: x_msg_count := l_msg_count ;
484: x_msg_data := l_msg_data ;
485: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INTERFACE_PUB','recall_transfer');
486: FND_MSG_PUB.count_and_get(
487: p_count => x_msg_count
488: ,p_data => x_msg_data);
489:
482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
483: x_msg_count := l_msg_count ;
484: x_msg_data := l_msg_data ;
485: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INTERFACE_PUB','recall_transfer');
486: FND_MSG_PUB.count_and_get(
487: p_count => x_msg_count
488: ,p_data => x_msg_data);
489:
490: END recall_transfer;
553: ROLLBACK TO recall_transfer;
554: x_return_status := FND_API.G_RET_STS_ERROR;
555: x_msg_count := lx_msg_count ;
556: x_msg_data := lx_msg_data ;
557: FND_MSG_PUB.count_and_get(
558: p_count => x_msg_count
559: ,p_data => x_msg_data);
560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
561: ROLLBACK TO recall_transfer;
561: ROLLBACK TO recall_transfer;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: x_msg_count := lx_msg_count ;
564: x_msg_data := lx_msg_data ;
565: FND_MSG_PUB.count_and_get(
566: p_count => x_msg_count
567: ,p_data => x_msg_data);
568: WHEN OTHERS THEN
569: ROLLBACK TO recall_transfer;
569: ROLLBACK TO recall_transfer;
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571: x_msg_count := lx_msg_count ;
572: x_msg_data := lx_msg_data ;
573: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INTERFACE_PUB','review_transfer');
574: FND_MSG_PUB.count_and_get(
575: p_count => x_msg_count
576: ,p_data => x_msg_data);
577:
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571: x_msg_count := lx_msg_count ;
572: x_msg_data := lx_msg_data ;
573: FND_MSG_PUB.ADD_EXC_MSG('IEX_OPEN_INTERFACE_PUB','review_transfer');
574: FND_MSG_PUB.count_and_get(
575: p_count => x_msg_count
576: ,p_data => x_msg_data);
577:
578: END review_transfer;