411: rollback to cse_addition;
412: RETURN FALSE;
413: WHEN others THEN
414: rollback to cse_addition;
415: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
416: fnd_message.set_token('API_NAME','csi_fa_integration_grp.addition');
417: fnd_message.set_token('SQL_ERROR',sqlerrm);
418: fnd_msg_pub.add;
419: RETURN FALSE;
412: RETURN FALSE;
413: WHEN others THEN
414: rollback to cse_addition;
415: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
416: fnd_message.set_token('API_NAME','csi_fa_integration_grp.addition');
417: fnd_message.set_token('SQL_ERROR',sqlerrm);
418: fnd_msg_pub.add;
419: RETURN FALSE;
420: END addition;
413: WHEN others THEN
414: rollback to cse_addition;
415: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
416: fnd_message.set_token('API_NAME','csi_fa_integration_grp.addition');
417: fnd_message.set_token('SQL_ERROR',sqlerrm);
418: fnd_msg_pub.add;
419: RETURN FALSE;
420: END addition;
421:
434: EXCEPTION
435: WHEN fnd_api.g_exc_error THEN
436: RETURN FALSE;
437: WHEN others THEN
438: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
439: fnd_message.set_token('API_NAME','csi_fa_integration_grp.unit_adjustment');
440: fnd_message.set_token('SQL_ERROR',sqlerrm);
441: fnd_msg_pub.add;
442: RETURN FALSE;
435: WHEN fnd_api.g_exc_error THEN
436: RETURN FALSE;
437: WHEN others THEN
438: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
439: fnd_message.set_token('API_NAME','csi_fa_integration_grp.unit_adjustment');
440: fnd_message.set_token('SQL_ERROR',sqlerrm);
441: fnd_msg_pub.add;
442: RETURN FALSE;
443: END unit_adjustment;
436: RETURN FALSE;
437: WHEN others THEN
438: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
439: fnd_message.set_token('API_NAME','csi_fa_integration_grp.unit_adjustment');
440: fnd_message.set_token('SQL_ERROR',sqlerrm);
441: fnd_msg_pub.add;
442: RETURN FALSE;
443: END unit_adjustment;
444:
605: EXCEPTION
606: WHEN fnd_api.g_exc_error THEN
607: RETURN FALSE;
608: WHEN others THEN
609: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
610: fnd_message.set_token('API_NAME','csi_fa_integration_grp.adjustment');
611: fnd_message.set_token('SQL_ERROR',sqlerrm);
612: fnd_msg_pub.add;
613: RETURN FALSE;
606: WHEN fnd_api.g_exc_error THEN
607: RETURN FALSE;
608: WHEN others THEN
609: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
610: fnd_message.set_token('API_NAME','csi_fa_integration_grp.adjustment');
611: fnd_message.set_token('SQL_ERROR',sqlerrm);
612: fnd_msg_pub.add;
613: RETURN FALSE;
614: END adjustment;
607: RETURN FALSE;
608: WHEN others THEN
609: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
610: fnd_message.set_token('API_NAME','csi_fa_integration_grp.adjustment');
611: fnd_message.set_token('SQL_ERROR',sqlerrm);
612: fnd_msg_pub.add;
613: RETURN FALSE;
614: END adjustment;
615:
628: EXCEPTION
629: WHEN fnd_api.g_exc_error THEN
630: RETURN FALSE;
631: WHEN others THEN
632: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
633: fnd_message.set_token('API_NAME','csi_fa_integration_grp.transfer');
634: fnd_message.set_token('SQL_ERROR',sqlerrm);
635: fnd_msg_pub.add;
636: RETURN FALSE;
629: WHEN fnd_api.g_exc_error THEN
630: RETURN FALSE;
631: WHEN others THEN
632: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
633: fnd_message.set_token('API_NAME','csi_fa_integration_grp.transfer');
634: fnd_message.set_token('SQL_ERROR',sqlerrm);
635: fnd_msg_pub.add;
636: RETURN FALSE;
637: END transfer;
630: RETURN FALSE;
631: WHEN others THEN
632: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
633: fnd_message.set_token('API_NAME','csi_fa_integration_grp.transfer');
634: fnd_message.set_token('SQL_ERROR',sqlerrm);
635: fnd_msg_pub.add;
636: RETURN FALSE;
637: END transfer;
638:
654: EXCEPTION
655: WHEN fnd_api.g_exc_error THEN
656: RETURN FALSE;
657: WHEN others THEN
658: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
659: fnd_message.set_token('API_NAME','csi_fa_integration_grp.retire');
660: fnd_message.set_token('SQL_ERROR',sqlerrm);
661: fnd_msg_pub.add;
662: RETURN FALSE;
655: WHEN fnd_api.g_exc_error THEN
656: RETURN FALSE;
657: WHEN others THEN
658: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
659: fnd_message.set_token('API_NAME','csi_fa_integration_grp.retire');
660: fnd_message.set_token('SQL_ERROR',sqlerrm);
661: fnd_msg_pub.add;
662: RETURN FALSE;
663: END retire;
656: RETURN FALSE;
657: WHEN others THEN
658: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
659: fnd_message.set_token('API_NAME','csi_fa_integration_grp.retire');
660: fnd_message.set_token('SQL_ERROR',sqlerrm);
661: fnd_msg_pub.add;
662: RETURN FALSE;
663: END retire;
664:
694: EXCEPTION
695: WHEN fnd_api.g_exc_error THEN
696: RETURN FALSE;
697: WHEN others THEN
698: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
699: fnd_message.set_token('API_NAME','csi_fa_integration_grp.reinstate');
700: fnd_message.set_token('SQL_ERROR',sqlerrm);
701: fnd_msg_pub.add;
702: RETURN FALSE;
695: WHEN fnd_api.g_exc_error THEN
696: RETURN FALSE;
697: WHEN others THEN
698: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
699: fnd_message.set_token('API_NAME','csi_fa_integration_grp.reinstate');
700: fnd_message.set_token('SQL_ERROR',sqlerrm);
701: fnd_msg_pub.add;
702: RETURN FALSE;
703: END reinstate;
696: RETURN FALSE;
697: WHEN others THEN
698: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');
699: fnd_message.set_token('API_NAME','csi_fa_integration_grp.reinstate');
700: fnd_message.set_token('SQL_ERROR',sqlerrm);
701: fnd_msg_pub.add;
702: RETURN FALSE;
703: END reinstate;
704: