406: rollback to cse_addition;
407: RETURN FALSE;
408: WHEN others THEN
409: rollback to cse_addition;
410: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
411: fnd_message.set_token('API_NAME','csi_fa_integration_grp.addition');
412: fnd_message.set_token('SQL_ERROR',sqlerrm);
413: fnd_msg_pub.add;
414: RETURN FALSE;
407: RETURN FALSE;
408: WHEN others THEN
409: rollback to cse_addition;
410: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
411: fnd_message.set_token('API_NAME','csi_fa_integration_grp.addition');
412: fnd_message.set_token('SQL_ERROR',sqlerrm);
413: fnd_msg_pub.add;
414: RETURN FALSE;
415: END addition;
408: WHEN others THEN
409: rollback to cse_addition;
410: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
411: fnd_message.set_token('API_NAME','csi_fa_integration_grp.addition');
412: fnd_message.set_token('SQL_ERROR',sqlerrm);
413: fnd_msg_pub.add;
414: RETURN FALSE;
415: END addition;
416:
429: EXCEPTION
430: WHEN fnd_api.g_exc_error THEN
431: RETURN FALSE;
432: WHEN others THEN
433: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
434: fnd_message.set_token('API_NAME','csi_fa_integration_grp.unit_adjustment');
435: fnd_message.set_token('SQL_ERROR',sqlerrm);
436: fnd_msg_pub.add;
437: RETURN FALSE;
430: WHEN fnd_api.g_exc_error THEN
431: RETURN FALSE;
432: WHEN others THEN
433: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
434: fnd_message.set_token('API_NAME','csi_fa_integration_grp.unit_adjustment');
435: fnd_message.set_token('SQL_ERROR',sqlerrm);
436: fnd_msg_pub.add;
437: RETURN FALSE;
438: END unit_adjustment;
431: RETURN FALSE;
432: WHEN others THEN
433: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
434: fnd_message.set_token('API_NAME','csi_fa_integration_grp.unit_adjustment');
435: fnd_message.set_token('SQL_ERROR',sqlerrm);
436: fnd_msg_pub.add;
437: RETURN FALSE;
438: END unit_adjustment;
439:
600: EXCEPTION
601: WHEN fnd_api.g_exc_error THEN
602: RETURN FALSE;
603: WHEN others THEN
604: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
605: fnd_message.set_token('API_NAME','csi_fa_integration_grp.adjustment');
606: fnd_message.set_token('SQL_ERROR',sqlerrm);
607: fnd_msg_pub.add;
608: RETURN FALSE;
601: WHEN fnd_api.g_exc_error THEN
602: RETURN FALSE;
603: WHEN others THEN
604: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
605: fnd_message.set_token('API_NAME','csi_fa_integration_grp.adjustment');
606: fnd_message.set_token('SQL_ERROR',sqlerrm);
607: fnd_msg_pub.add;
608: RETURN FALSE;
609: END adjustment;
602: RETURN FALSE;
603: WHEN others THEN
604: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
605: fnd_message.set_token('API_NAME','csi_fa_integration_grp.adjustment');
606: fnd_message.set_token('SQL_ERROR',sqlerrm);
607: fnd_msg_pub.add;
608: RETURN FALSE;
609: END adjustment;
610:
623: EXCEPTION
624: WHEN fnd_api.g_exc_error THEN
625: RETURN FALSE;
626: WHEN others THEN
627: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
628: fnd_message.set_token('API_NAME','csi_fa_integration_grp.transfer');
629: fnd_message.set_token('SQL_ERROR',sqlerrm);
630: fnd_msg_pub.add;
631: RETURN FALSE;
624: WHEN fnd_api.g_exc_error THEN
625: RETURN FALSE;
626: WHEN others THEN
627: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
628: fnd_message.set_token('API_NAME','csi_fa_integration_grp.transfer');
629: fnd_message.set_token('SQL_ERROR',sqlerrm);
630: fnd_msg_pub.add;
631: RETURN FALSE;
632: END transfer;
625: RETURN FALSE;
626: WHEN others THEN
627: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
628: fnd_message.set_token('API_NAME','csi_fa_integration_grp.transfer');
629: fnd_message.set_token('SQL_ERROR',sqlerrm);
630: fnd_msg_pub.add;
631: RETURN FALSE;
632: END transfer;
633:
649: EXCEPTION
650: WHEN fnd_api.g_exc_error THEN
651: RETURN FALSE;
652: WHEN others THEN
653: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
654: fnd_message.set_token('API_NAME','csi_fa_integration_grp.retire');
655: fnd_message.set_token('SQL_ERROR',sqlerrm);
656: fnd_msg_pub.add;
657: RETURN FALSE;
650: WHEN fnd_api.g_exc_error THEN
651: RETURN FALSE;
652: WHEN others THEN
653: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
654: fnd_message.set_token('API_NAME','csi_fa_integration_grp.retire');
655: fnd_message.set_token('SQL_ERROR',sqlerrm);
656: fnd_msg_pub.add;
657: RETURN FALSE;
658: END retire;
651: RETURN FALSE;
652: WHEN others THEN
653: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
654: fnd_message.set_token('API_NAME','csi_fa_integration_grp.retire');
655: fnd_message.set_token('SQL_ERROR',sqlerrm);
656: fnd_msg_pub.add;
657: RETURN FALSE;
658: END retire;
659:
689: EXCEPTION
690: WHEN fnd_api.g_exc_error THEN
691: RETURN FALSE;
692: WHEN others THEN
693: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
694: fnd_message.set_token('API_NAME','csi_fa_integration_grp.reinstate');
695: fnd_message.set_token('SQL_ERROR',sqlerrm);
696: fnd_msg_pub.add;
697: RETURN FALSE;
690: WHEN fnd_api.g_exc_error THEN
691: RETURN FALSE;
692: WHEN others THEN
693: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
694: fnd_message.set_token('API_NAME','csi_fa_integration_grp.reinstate');
695: fnd_message.set_token('SQL_ERROR',sqlerrm);
696: fnd_msg_pub.add;
697: RETURN FALSE;
698: END reinstate;
691: RETURN FALSE;
692: WHEN others THEN
693: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
694: fnd_message.set_token('API_NAME','csi_fa_integration_grp.reinstate');
695: fnd_message.set_token('SQL_ERROR',sqlerrm);
696: fnd_msg_pub.add;
697: RETURN FALSE;
698: END reinstate;
699: