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 745: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');

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;
749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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;
749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
750: END sync_contact;

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

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;
749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
750: END sync_contact;
751:

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

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;
846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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;
846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
847: END sync_contact_point;

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

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;
846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
847: END sync_contact_point;
848:

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

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;
886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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;
886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
887: END;

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

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;
886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
887: END;
888:

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

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;
927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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;
927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
928: END;

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

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;
927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
928: END;
929:

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

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;
975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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;
975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
976: END;

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

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;
975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
976: END;
977:

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

1348: END IF;
1349:
1350: EXCEPTION
1351: WHEN OTHERS THEN
1352: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1353: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1354: FND_MSG_PUB.ADD;
1355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1356: END stage_party_merge;

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

1349:
1350: EXCEPTION
1351: WHEN OTHERS THEN
1352: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1353: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1354: FND_MSG_PUB.ADD;
1355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1356: END stage_party_merge;
1357:

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

1403: END IF;
1404:
1405: EXCEPTION
1406: WHEN OTHERS THEN
1407: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1408: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1409: FND_MSG_PUB.ADD;
1410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1411: END stage_party_site_merge;

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

1404:
1405: EXCEPTION
1406: WHEN OTHERS THEN
1407: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1408: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1409: FND_MSG_PUB.ADD;
1410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1411: END stage_party_site_merge;
1412:

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

1531:
1532: EXCEPTION
1533: WHEN OTHERS THEN
1534: fnd_file.put_line(fnd_file.log,'Error here1 '||SQLERRM);
1535: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1536: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1537: FND_MSG_PUB.ADD;
1538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1539: END stage_contact_point_merge;

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

1532: EXCEPTION
1533: WHEN OTHERS THEN
1534: fnd_file.put_line(fnd_file.log,'Error here1 '||SQLERRM);
1535: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1536: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1537: FND_MSG_PUB.ADD;
1538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1539: END stage_contact_point_merge;
1540:

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

1609: END IF;
1610:
1611: EXCEPTION
1612: WHEN OTHERS THEN
1613: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1614: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1615: FND_MSG_PUB.ADD;
1616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1617:

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

1610:
1611: EXCEPTION
1612: WHEN OTHERS THEN
1613: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1614: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1615: FND_MSG_PUB.ADD;
1616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1617:
1618: END stage_contact_merge;

Line 2113: log(fnd_message.get);

2109: -- Boolean used to track the submission of the parallel sync concurrent program
2110:
2111: IF l_sub_requests(i) = 0 THEN
2112: log('Error submitting worker ' || i);
2113: log(fnd_message.get);
2114: ELSE
2115: log('Submitted request for Worker ' || TO_CHAR(I) );
2116: log('Request ID : ' || l_sub_requests(i));
2117:

Line 2754: log(fnd_message.get);

2750: p_request_id,
2751: idx_name);
2752: IF l_sub_requests(i) = 0 THEN
2753: log('Error submitting index worker for ' || idx_name);
2754: log(fnd_message.get);
2755: ELSE
2756: log('Submitted request for index worker ' || idx_name );
2757: log('Request ID : ' || l_sub_requests(i));
2758: END IF;