eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_DQM_SYNC dependencies on FND_MSG_PUB

Line 578: FND_MSG_PUB.ADD;

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:
582:

Line 634: FND_MSG_PUB.ADD;

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:
638:

Line 700: FND_MSG_PUB.ADD;

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:
704:

Line 759: FND_MSG_PUB.ADD;

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:
763:

Line 856: FND_MSG_PUB.ADD;

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:
860:

Line 896: FND_MSG_PUB.ADD;

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:
900: --- VJN CHANGED THIS PROCEDURE TO INCLUDE THE CHECK OF 'I' FOR THE

Line 937: FND_MSG_PUB.ADD;

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:
941: PROCEDURE sync_cust_account (

Line 985: FND_MSG_PUB.ADD;

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:
989: -- VJN added for Reporting errored records into HZ_DQM_SYNC_INTERFACE

Line 1263: FND_MSG_PUB.initialize;

1259: l_prof_val := null;
1260: END;
1261:
1262: -- Initialize return status and message stack
1263: FND_MSG_PUB.initialize;
1264:
1265: log('Optimizing Intermedia indexes');
1266: log('Optimizing party index .. ', TRUE);
1267:

Line 1355: FND_MSG_PUB.Reset;

1351: RETURN VARCHAR2 IS
1352:
1353: l_msg_data VARCHAR2(2000);
1354: BEGIN
1355: FND_MSG_PUB.Reset;
1356:
1357: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1358: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1359: END LOOP;

Line 1357: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

1353: l_msg_data VARCHAR2(2000);
1354: BEGIN
1355: FND_MSG_PUB.Reset;
1356:
1357: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1358: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1359: END LOOP;
1360: IF (SQLERRM IS NOT NULL) THEN
1361: l_msg_data := l_msg_data || SQLERRM;

Line 1358: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );

1354: BEGIN
1355: FND_MSG_PUB.Reset;
1356:
1357: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1358: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1359: END LOOP;
1360: IF (SQLERRM IS NOT NULL) THEN
1361: l_msg_data := l_msg_data || SQLERRM;
1362: END IF;

Line 1420: FND_MSG_PUB.ADD;

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:
1424: PROCEDURE stage_party_site_merge(

Line 1480: FND_MSG_PUB.ADD;

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:
1484: PROCEDURE stage_contact_point_merge(

Line 1621: FND_MSG_PUB.ADD;

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:
1625:

Line 1734: FND_MSG_PUB.ADD;

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;
1738:

Line 2902: FND_MSG_PUB.initialize;

2898:
2899: log('------------------------------');
2900: log('Starting DQM Parallel Sync Index Parent Program ');
2901:
2902: FND_MSG_PUB.initialize;
2903:
2904:
2905: IF ( fnd_installation.GET_APP_INFO('AR', l_status, l_tmp, l_index_owner ))
2906: THEN