DBA Data[Home] [Help]

APPS.HZ_DQM_SYNC dependencies on FND_MESSAGE

Line 575: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');

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;

Line 576: FND_MESSAGE.SET_TOKEN('PROC','sync_org');

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;

Line 577: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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:

Line 631: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');

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;

Line 632: FND_MESSAGE.SET_TOKEN('PROC','sync_person');

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;

Line 633: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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:

Line 697: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');

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;

Line 698: FND_MESSAGE.SET_TOKEN('PROC','sync_party_site');

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;

Line 699: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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:

Line 756: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');

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;

Line 757: FND_MESSAGE.SET_TOKEN('PROC','sync_contact');

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;

Line 758: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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:

Line 853: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');

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;

Line 854: FND_MESSAGE.SET_TOKEN('PROC','sync_contact_point');

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;

Line 855: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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:

Line 893: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');

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;

Line 894: FND_MESSAGE.SET_TOKEN('PROC','sync_relationship');

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;

Line 895: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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:

Line 934: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');

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;

Line 935: FND_MESSAGE.SET_TOKEN('PROC','sync_location');

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;

Line 936: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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:

Line 982: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');

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;

Line 983: FND_MESSAGE.SET_TOKEN('PROC','sync_cust_account');

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;

Line 984: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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:

Line 1418: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

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;

Line 1419: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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:

Line 1478: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

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;

Line 1479: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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:

Line 1619: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

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;

Line 1620: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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:

Line 1732: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

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:

Line 1733: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;

Line 2292: log(fnd_message.get);

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:

Line 2933: log(fnd_message.get);

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;