570: END IF;
571: END IF;
572: EXCEPTION
573: WHEN OTHERS THEN
574: hz_common_pub.enable_cont_source_security;
575: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
576: FND_MESSAGE.SET_TOKEN('PROC','sync_org');
577: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
578: FND_MSG_PUB.ADD;
692: END IF;
693: END IF;
694: EXCEPTION
695: WHEN OTHERS THEN
696: hz_common_pub.enable_cont_source_security;
697: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
698: FND_MESSAGE.SET_TOKEN('PROC','sync_party_site');
699: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
700: FND_MSG_PUB.ADD;
740: EXCEPTION
741: WHEN NO_DATA_FOUND THEN
742: NULL;
743: WHEN OTHERS THEN
744: hz_common_pub.enable_cont_source_security;
745: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
746: FND_MESSAGE.SET_TOKEN('PROC','sync_contact');
747: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
748: FND_MSG_PUB.ADD;
837: END IF;
838: END IF;
839: EXCEPTION
840: WHEN OTHERS THEN
841: hz_common_pub.enable_cont_source_security;
842: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
843: FND_MESSAGE.SET_TOKEN('PROC','sync_contact_point');
844: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
845: FND_MSG_PUB.ADD;
874: END IF;
875:
876: EXCEPTION
877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
878: hz_common_pub.enable_cont_source_security;
879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
880: WHEN OTHERS THEN
881: hz_common_pub.enable_cont_source_security;
882: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
878: hz_common_pub.enable_cont_source_security;
879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
880: WHEN OTHERS THEN
881: hz_common_pub.enable_cont_source_security;
882: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
883: FND_MESSAGE.SET_TOKEN('PROC','sync_relationship');
884: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
885: FND_MSG_PUB.ADD;
915: END IF;
916:
917: EXCEPTION
918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
919: hz_common_pub.enable_cont_source_security;
920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
921: WHEN OTHERS THEN
922: hz_common_pub.enable_cont_source_security;
923: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
919: hz_common_pub.enable_cont_source_security;
920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
921: WHEN OTHERS THEN
922: hz_common_pub.enable_cont_source_security;
923: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
924: FND_MESSAGE.SET_TOKEN('PROC','sync_location');
925: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
926: FND_MSG_PUB.ADD;
963: CLOSE c_cust_party;
964: END IF;
965: EXCEPTION
966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
967: hz_common_pub.enable_cont_source_security;
968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
969: WHEN OTHERS THEN
970: hz_common_pub.enable_cont_source_security;
971: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
967: hz_common_pub.enable_cont_source_security;
968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
969: WHEN OTHERS THEN
970: hz_common_pub.enable_cont_source_security;
971: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
972: FND_MESSAGE.SET_TOKEN('PROC','sync_cust_account');
973: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
974: FND_MSG_PUB.ADD;