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;
579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;
579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
580: END sync_org;
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;
579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
580: END sync_org;
581:
627: END IF ;
628: END IF;
629: EXCEPTION
630: WHEN OTHERS THEN
631: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
632: FND_MESSAGE.SET_TOKEN('PROC','sync_person');
633: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
634: FND_MSG_PUB.ADD;
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
628: END IF;
629: EXCEPTION
630: WHEN OTHERS THEN
631: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
632: FND_MESSAGE.SET_TOKEN('PROC','sync_person');
633: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
634: FND_MSG_PUB.ADD;
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
636: END sync_person;
629: EXCEPTION
630: WHEN OTHERS THEN
631: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
632: FND_MESSAGE.SET_TOKEN('PROC','sync_person');
633: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
634: FND_MSG_PUB.ADD;
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
636: END sync_person;
637:
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;
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702: END sync_party_site;
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;
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702: END sync_party_site;
703:
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;
760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;
760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
761: END sync_contact;
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;
760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
761: END sync_contact;
762:
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;
857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;
857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
858: END sync_contact_point;
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;
857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
858: END sync_contact_point;
859:
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;
897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;
897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
898: END;
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;
897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
898: END;
899:
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;
938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;
938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
939: END;
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;
938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
939: END;
940:
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;
986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;
986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
987: END;
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;
986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
987: END;
988:
1414: END IF;
1415:
1416: EXCEPTION
1417: WHEN OTHERS THEN
1418: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1419: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1420: FND_MSG_PUB.ADD;
1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1422: END stage_party_merge;
1415:
1416: EXCEPTION
1417: WHEN OTHERS THEN
1418: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1419: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1420: FND_MSG_PUB.ADD;
1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1422: END stage_party_merge;
1423:
1474: END IF;
1475:
1476: EXCEPTION
1477: WHEN OTHERS THEN
1478: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1479: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1480: FND_MSG_PUB.ADD;
1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1482: END stage_party_site_merge;
1475:
1476: EXCEPTION
1477: WHEN OTHERS THEN
1478: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1479: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1480: FND_MSG_PUB.ADD;
1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1482: END stage_party_site_merge;
1483:
1615:
1616: EXCEPTION
1617: WHEN OTHERS THEN
1618: fnd_file.put_line(fnd_file.log,'Error here1 '||SQLERRM);
1619: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1620: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1621: FND_MSG_PUB.ADD;
1622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1623: END stage_contact_point_merge;
1616: EXCEPTION
1617: WHEN OTHERS THEN
1618: fnd_file.put_line(fnd_file.log,'Error here1 '||SQLERRM);
1619: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1620: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1621: FND_MSG_PUB.ADD;
1622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1623: END stage_contact_point_merge;
1624:
1728: END IF;
1729:
1730: EXCEPTION
1731: WHEN OTHERS THEN
1732: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1733: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1734: FND_MSG_PUB.ADD;
1735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1736:
1729:
1730: EXCEPTION
1731: WHEN OTHERS THEN
1732: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1733: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1734: FND_MSG_PUB.ADD;
1735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1736:
1737: END stage_contact_merge;
2288: -- Boolean used to track the submission of the parallel sync concurrent program
2289:
2290: IF l_sub_requests(i) = 0 THEN
2291: log('Error submitting worker ' || i);
2292: log(fnd_message.get);
2293: ELSE
2294: log('Submitted request for Worker ' || TO_CHAR(I) );
2295: log('Request ID : ' || l_sub_requests(i));
2296:
2929: p_request_id,
2930: idx_name);
2931: IF l_sub_requests(i) = 0 THEN
2932: log('Error submitting index worker for ' || idx_name);
2933: log(fnd_message.get);
2934: ELSE
2935: log('Submitted request for index worker ' || idx_name );
2936: log('Request ID : ' || l_sub_requests(i));
2937: END IF;