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;
751: EXCEPTION
752: WHEN NO_DATA_FOUND THEN
753: NULL;
754: WHEN OTHERS THEN
755: hz_common_pub.enable_cont_source_security;
756: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
757: FND_MESSAGE.SET_TOKEN('PROC','sync_contact');
758: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
759: FND_MSG_PUB.ADD;
848: END IF;
849: END IF;
850: EXCEPTION
851: WHEN OTHERS THEN
852: hz_common_pub.enable_cont_source_security;
853: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
854: FND_MESSAGE.SET_TOKEN('PROC','sync_contact_point');
855: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
856: FND_MSG_PUB.ADD;
885: END IF;
886:
887: EXCEPTION
888: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
889: hz_common_pub.enable_cont_source_security;
890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
891: WHEN OTHERS THEN
892: hz_common_pub.enable_cont_source_security;
893: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
888: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
889: hz_common_pub.enable_cont_source_security;
890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
891: WHEN OTHERS THEN
892: hz_common_pub.enable_cont_source_security;
893: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
894: FND_MESSAGE.SET_TOKEN('PROC','sync_relationship');
895: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
896: FND_MSG_PUB.ADD;
926: END IF;
927:
928: EXCEPTION
929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
930: hz_common_pub.enable_cont_source_security;
931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
932: WHEN OTHERS THEN
933: hz_common_pub.enable_cont_source_security;
934: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
930: hz_common_pub.enable_cont_source_security;
931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
932: WHEN OTHERS THEN
933: hz_common_pub.enable_cont_source_security;
934: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
935: FND_MESSAGE.SET_TOKEN('PROC','sync_location');
936: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
937: FND_MSG_PUB.ADD;
974: CLOSE c_cust_party;
975: END IF;
976: EXCEPTION
977: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
978: hz_common_pub.enable_cont_source_security;
979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: WHEN OTHERS THEN
981: hz_common_pub.enable_cont_source_security;
982: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
977: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
978: hz_common_pub.enable_cont_source_security;
979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: WHEN OTHERS THEN
981: hz_common_pub.enable_cont_source_security;
982: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
983: FND_MESSAGE.SET_TOKEN('PROC','sync_cust_account');
984: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
985: FND_MSG_PUB.ADD;