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 748: FND_MSG_PUB.ADD;

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

Line 845: FND_MSG_PUB.ADD;

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

Line 885: FND_MSG_PUB.ADD;

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

Line 926: FND_MSG_PUB.ADD;

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

Line 974: FND_MSG_PUB.ADD;

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

Line 1213: FND_MSG_PUB.initialize;

1209: l_prof_val := null;
1210: END;
1211:
1212: -- Initialize return status and message stack
1213: FND_MSG_PUB.initialize;
1214:
1215: log('Optimizing Intermedia indexes');
1216: log('Optimizing party index .. ', TRUE);
1217:

Line 1305: FND_MSG_PUB.Reset;

1301: RETURN VARCHAR2 IS
1302:
1303: l_msg_data VARCHAR2(2000);
1304: BEGIN
1305: FND_MSG_PUB.Reset;
1306:
1307: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1308: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1309: END LOOP;

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

1303: l_msg_data VARCHAR2(2000);
1304: BEGIN
1305: FND_MSG_PUB.Reset;
1306:
1307: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1308: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1309: END LOOP;
1310: IF (SQLERRM IS NOT NULL) THEN
1311: l_msg_data := l_msg_data || SQLERRM;

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

1304: BEGIN
1305: FND_MSG_PUB.Reset;
1306:
1307: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1308: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1309: END LOOP;
1310: IF (SQLERRM IS NOT NULL) THEN
1311: l_msg_data := l_msg_data || SQLERRM;
1312: END IF;

Line 1354: FND_MSG_PUB.ADD;

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

Line 1409: FND_MSG_PUB.ADD;

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

Line 1537: FND_MSG_PUB.ADD;

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

Line 1615: FND_MSG_PUB.ADD;

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

Line 2723: FND_MSG_PUB.initialize;

2719:
2720: log('------------------------------');
2721: log('Starting DQM Parallel Sync Index Parent Program ');
2722:
2723: FND_MSG_PUB.initialize;
2724:
2725:
2726: IF ( fnd_installation.GET_APP_INFO('AR', l_status, l_tmp, l_index_owner ))
2727: THEN