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_API

Line 579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
583: PROCEDURE sync_person (

Line 635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
639: PROCEDURE sync_party_site (

Line 701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
705: PROCEDURE sync_contact (

Line 760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
764: PROCEDURE sync_contact_point (

Line 857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
861: PROCEDURE sync_relationship (

Line 888: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

884: CLOSE org_contacts;
885: END IF;
886:
887: EXCEPTION
888: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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;

Line 890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

886:
887: EXCEPTION
888: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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');

Line 897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
901: -- party_sites CURSOR (Bug 3139325)

Line 929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

925: CLOSE party_sites;
926: END IF;
927:
928: EXCEPTION
929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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;

Line 931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

927:
928: EXCEPTION
929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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');

Line 938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
942: p_cust_acct_id IN NUMBER,

Line 977: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

973: END IF;
974: CLOSE c_cust_party;
975: END IF;
976: EXCEPTION
977: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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;

Line 979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

975: END IF;
976: EXCEPTION
977: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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');

Line 986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1271: RAISE FND_API.G_EXC_ERROR;

1267:
1268: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_index_owner);
1269: OPTIMIZE_INDEX(l_index_owner || '.hz_stage_parties_t1', 'FULL', l_prof_val, idx_retcode , idx_err);
1270: IF idx_retcode = 1 THEN
1271: RAISE FND_API.G_EXC_ERROR;
1272: END IF;
1273: log('Done');
1274:
1275: log('Optimizing party site index .. ', TRUE);

Line 1278: RAISE FND_API.G_EXC_ERROR;

1274:
1275: log('Optimizing party site index .. ', TRUE);
1276: OPTIMIZE_INDEX(l_index_owner || '.hz_stage_party_sites_t1', 'FULL', l_prof_val, idx_retcode , idx_err);
1277: IF idx_retcode = 1 THEN
1278: RAISE FND_API.G_EXC_ERROR;
1279: END IF;
1280: log('Done');
1281:
1282: log('Optimizing contact index .. ', TRUE);

Line 1285: RAISE FND_API.G_EXC_ERROR;

1281:
1282: log('Optimizing contact index .. ', TRUE);
1283: OPTIMIZE_INDEX(l_index_owner || '.hz_stage_contact_t1', 'FULL', l_prof_val, idx_retcode , idx_err);
1284: IF idx_retcode = 1 THEN
1285: RAISE FND_API.G_EXC_ERROR;
1286: END IF;
1287: log('Done');
1288:
1289: log('Optimizing contact point index .. ', TRUE);

Line 1292: RAISE FND_API.G_EXC_ERROR;

1288:
1289: log('Optimizing contact point index .. ', TRUE);
1290: OPTIMIZE_INDEX(l_index_owner || '.hz_stage_cpt_t1', 'FULL', l_prof_val, idx_retcode , idx_err);
1291: IF idx_retcode = 1 THEN
1292: RAISE FND_API.G_EXC_ERROR;
1293: END IF;
1294: log('Done');
1295:
1296: outandlog('Concurrent Program Execution completed ');

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 1368: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

1364: RETURN l_msg_data;
1365: END logerror;
1366:
1367: PROCEDURE stage_party_merge(
1368: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1369: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
1370: x_to_id IN OUT NOCOPY NUMBER,
1371: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1372: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

Line 1369: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

1365: END logerror;
1366:
1367: PROCEDURE stage_party_merge(
1368: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1369: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
1370: x_to_id IN OUT NOCOPY NUMBER,
1371: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1372: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1373: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

Line 1371: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

1367: PROCEDURE stage_party_merge(
1368: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1369: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
1370: x_to_id IN OUT NOCOPY NUMBER,
1371: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1372: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1373: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1374: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
1375: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

Line 1372: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

1368: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1369: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
1370: x_to_id IN OUT NOCOPY NUMBER,
1371: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1372: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1373: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1374: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
1375: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
1376: x_return_status OUT NOCOPY VARCHAR2

Line 1373: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

1369: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
1370: x_to_id IN OUT NOCOPY NUMBER,
1371: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1372: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1373: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1374: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
1375: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
1376: x_return_status OUT NOCOPY VARCHAR2
1377: ) IS

Line 1374: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,

1370: x_to_id IN OUT NOCOPY NUMBER,
1371: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1372: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1373: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1374: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
1375: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
1376: x_return_status OUT NOCOPY VARCHAR2
1377: ) IS
1378:

Line 1375: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

1371: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1372: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1373: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1374: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
1375: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
1376: x_return_status OUT NOCOPY VARCHAR2
1377: ) IS
1378:
1379: l_party_type VARCHAR2(30);

Line 1383: x_return_status := FND_API.G_RET_STS_SUCCESS;

1379: l_party_type VARCHAR2(30);
1380:
1381: BEGIN
1382:
1383: x_return_status := FND_API.G_RET_STS_SUCCESS;
1384: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
1385:
1386: SELECT party_type INTO l_party_type
1387: FROM HZ_PARTIES

Line 1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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(
1425: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

Line 1425: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1422: END stage_party_merge;
1423:
1424: PROCEDURE stage_party_site_merge(
1425: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1426: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
1427: x_to_id IN OUT NOCOPY NUMBER,
1428: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1429: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

Line 1426: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

1422: END stage_party_merge;
1423:
1424: PROCEDURE stage_party_site_merge(
1425: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1426: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
1427: x_to_id IN OUT NOCOPY NUMBER,
1428: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1429: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1430: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

Line 1428: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

1424: PROCEDURE stage_party_site_merge(
1425: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1426: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
1427: x_to_id IN OUT NOCOPY NUMBER,
1428: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1429: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1430: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1431: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
1432: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

Line 1429: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

1425: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1426: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
1427: x_to_id IN OUT NOCOPY NUMBER,
1428: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1429: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1430: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1431: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
1432: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
1433: x_return_status OUT NOCOPY VARCHAR2

Line 1430: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

1426: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
1427: x_to_id IN OUT NOCOPY NUMBER,
1428: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1429: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1430: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1431: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
1432: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
1433: x_return_status OUT NOCOPY VARCHAR2
1434: ) IS

Line 1431: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,

1427: x_to_id IN OUT NOCOPY NUMBER,
1428: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1429: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1430: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1431: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
1432: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
1433: x_return_status OUT NOCOPY VARCHAR2
1434: ) IS
1435:

Line 1432: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

1428: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1429: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1430: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1431: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
1432: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
1433: x_return_status OUT NOCOPY VARCHAR2
1434: ) IS
1435:
1436: l_party_id NUMBER;

Line 1442: x_return_status := FND_API.G_RET_STS_SUCCESS;

1438: l_party_site_search_rec HZ_PARTY_SEARCH.party_site_search_rec_type;
1439: l_party_site_stage_rec HZ_PARTY_STAGE.PARTY_SITE_STAGE_REC_TYPE;
1440:
1441: BEGIN
1442: x_return_status := FND_API.G_RET_STS_SUCCESS;
1443: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
1444:
1445: IF ( L_REALTIME_SYNC_VALUE = 'Y') THEN
1446: BEGIN

Line 1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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(
1485: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

Line 1485: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1482: END stage_party_site_merge;
1483:
1484: PROCEDURE stage_contact_point_merge(
1485: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1486: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
1487: x_to_id IN OUT NOCOPY NUMBER,
1488: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1489: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

Line 1486: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

1482: END stage_party_site_merge;
1483:
1484: PROCEDURE stage_contact_point_merge(
1485: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1486: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
1487: x_to_id IN OUT NOCOPY NUMBER,
1488: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1489: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1490: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

Line 1488: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

1484: PROCEDURE stage_contact_point_merge(
1485: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1486: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
1487: x_to_id IN OUT NOCOPY NUMBER,
1488: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1489: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1490: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1491: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
1492: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

Line 1489: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

1485: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1486: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
1487: x_to_id IN OUT NOCOPY NUMBER,
1488: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1489: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1490: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1491: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
1492: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
1493: x_return_status OUT NOCOPY VARCHAR2

Line 1490: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

1486: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
1487: x_to_id IN OUT NOCOPY NUMBER,
1488: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1489: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1490: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1491: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
1492: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
1493: x_return_status OUT NOCOPY VARCHAR2
1494: ) IS

Line 1491: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,

1487: x_to_id IN OUT NOCOPY NUMBER,
1488: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1489: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1490: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1491: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
1492: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
1493: x_return_status OUT NOCOPY VARCHAR2
1494: ) IS
1495:

Line 1492: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

1488: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1489: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1490: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1491: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
1492: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
1493: x_return_status OUT NOCOPY VARCHAR2
1494: ) IS
1495:
1496: l_contact_point_id NUMBER;

Line 1538: x_return_status := FND_API.G_RET_STS_SUCCESS;

1534: l_cp_org_contact_id NUMBER;
1535:
1536: BEGIN
1537:
1538: x_return_status := FND_API.G_RET_STS_SUCCESS;
1539:
1540: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
1541:
1542: IF ( L_REALTIME_SYNC_VALUE = 'Y') THEN

Line 1622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
1626: PROCEDURE stage_contact_merge(

Line 1627: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

1623: END stage_contact_point_merge;
1624:
1625:
1626: PROCEDURE stage_contact_merge(
1627: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1628: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
1629: x_to_id IN OUT NOCOPY NUMBER,
1630: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1631: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

Line 1628: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

1624:
1625:
1626: PROCEDURE stage_contact_merge(
1627: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1628: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
1629: x_to_id IN OUT NOCOPY NUMBER,
1630: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1631: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1632: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

Line 1630: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

1626: PROCEDURE stage_contact_merge(
1627: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1628: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
1629: x_to_id IN OUT NOCOPY NUMBER,
1630: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1631: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1632: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1633: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
1634: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

Line 1631: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

1627: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1628: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
1629: x_to_id IN OUT NOCOPY NUMBER,
1630: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1631: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1632: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1633: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
1634: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
1635: x_return_status OUT NOCOPY VARCHAR2

Line 1632: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

1628: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
1629: x_to_id IN OUT NOCOPY NUMBER,
1630: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1631: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1632: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1633: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
1634: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
1635: x_return_status OUT NOCOPY VARCHAR2
1636: ) IS

Line 1633: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,

1629: x_to_id IN OUT NOCOPY NUMBER,
1630: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1631: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1632: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1633: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
1634: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
1635: x_return_status OUT NOCOPY VARCHAR2
1636: ) IS
1637:

Line 1634: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

1630: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1631: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
1632: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
1633: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
1634: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
1635: x_return_status OUT NOCOPY VARCHAR2
1636: ) IS
1637:
1638: l_org_contact_id NUMBER;

Line 1645: x_return_status := FND_API.G_RET_STS_SUCCESS;

1641: l_contact_stage_rec HZ_PARTY_STAGE.CONTACT_STAGE_REC_TYPE;
1642: l_rel_party_id NUMBER;
1643: BEGIN
1644:
1645: x_return_status := FND_API.G_RET_STS_SUCCESS;
1646: L_REALTIME_SYNC_VALUE := nvl(FND_PROFILE.VALUE('HZ_DQM_ENABLE_REALTIME_SYNC'), 'Y');
1647:
1648: IF ( L_REALTIME_SYNC_VALUE = 'Y') THEN
1649: BEGIN

Line 1735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1866: RAISE FND_API.G_EXC_ERROR;

1862: IF (i_party) THEN
1863: SYNC_INDEX_REALTIME(l_index_owner || '.hz_stage_parties_t1',
1864: idx_retcode , idx_err);
1865: IF idx_retcode = 1 THEN
1866: RAISE FND_API.G_EXC_ERROR;
1867: END IF;
1868:
1869: END IF;
1870: IF (i_party_sites) THEN

Line 1874: RAISE FND_API.G_EXC_ERROR;

1870: IF (i_party_sites) THEN
1871: SYNC_INDEX_REALTIME(l_index_owner || '.hz_stage_party_sites_t1',
1872: idx_retcode , idx_err);
1873: IF idx_retcode = 1 THEN
1874: RAISE FND_API.G_EXC_ERROR;
1875: END IF;
1876:
1877: END IF;
1878: IF (i_contacts) THEN

Line 1882: RAISE FND_API.G_EXC_ERROR;

1878: IF (i_contacts) THEN
1879: SYNC_INDEX_REALTIME(l_index_owner || '.hz_stage_contact_t1',
1880: idx_retcode , idx_err);
1881: IF idx_retcode = 1 THEN
1882: RAISE FND_API.G_EXC_ERROR;
1883: END IF;
1884:
1885: END IF;
1886: IF (i_contact_points) THEN

Line 1890: RAISE FND_API.G_EXC_ERROR;

1886: IF (i_contact_points) THEN
1887: SYNC_INDEX_REALTIME(l_index_owner || '.hz_stage_cpt_t1',
1888: idx_retcode , idx_err);
1889: IF idx_retcode = 1 THEN
1890: RAISE FND_API.G_EXC_ERROR;
1891: END IF;
1892: END IF;
1893: END IF;
1894: EXCEPTION

Line 1895: WHEN FND_API.G_EXC_ERROR THEN

1891: END IF;
1892: END IF;
1893: END IF;
1894: EXCEPTION
1895: WHEN FND_API.G_EXC_ERROR THEN
1896: outandlog('Error : Aborting Program');
1897: outandlog(idx_err);
1898: WHEN OTHERS THEN
1899: outandlog('Error : Aborting Program');

Line 2353: RAISE FND_API.G_EXC_ERROR;

2349: outandlog('Worker with request id ' || l_sub_requests(I) );
2350: outandlog('Did not complete normally.');
2351: retcode := 2;
2352: log(' retcode = ' || retcode);
2353: RAISE FND_API.G_EXC_ERROR;
2354: END LOOP;
2355: END IF;
2356: --Start of Bug No : 4915282
2357: --Set the index transactional, if the search on non indexed records is enabled.

Line 2371: WHEN FND_API.G_EXC_ERROR THEN

2367: --End of Bug No : 4915282
2368: END IF;
2369:
2370: EXCEPTION
2371: WHEN FND_API.G_EXC_ERROR THEN
2372: log('DQM Synchronization Program Aborted');
2373: retcode := 2;
2374: err := err || logerror || SQLERRM;
2375: RAISE;

Line 2392: RAISE FND_API.G_EXC_ERROR;

2388: BEGIN
2389: log('Index being synched ... ' || p_index_name);
2390: sync_index( p_index_name, retcode, err);
2391: if (retcode=2) then
2392: RAISE FND_API.G_EXC_ERROR;
2393: end if;
2394: EXCEPTION
2395: WHEN OTHERS THEN
2396: retcode := 2;

Line 2398: RAISE FND_API.G_EXC_ERROR;--

2394: EXCEPTION
2395: WHEN OTHERS THEN
2396: retcode := 2;
2397: err := SQLERRM;
2398: RAISE FND_API.G_EXC_ERROR;--
2399: END sync_index_conc;
2400:
2401: ----------------------------------------
2402: -- VJN Changes for SYNC in R12