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_MERGE_PKG dependencies on FND_MESSAGE

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

423:
424: x_to_id := l_to_id;
425: EXCEPTION
426: WHEN OTHERS THEN
427: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
428: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
429: FND_MSG_PUB.ADD;
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
431: END party_merge;

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

424: x_to_id := l_to_id;
425: EXCEPTION
426: WHEN OTHERS THEN
427: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
428: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
429: FND_MSG_PUB.ADD;
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
431: END party_merge;
432:

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

465:
466: x_to_id := l_to_id;
467: EXCEPTION
468: WHEN OTHERS THEN
469: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
470: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
471: FND_MSG_PUB.ADD;
472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
473: END org_profile_merge;

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

466: x_to_id := l_to_id;
467: EXCEPTION
468: WHEN OTHERS THEN
469: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
470: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
471: FND_MSG_PUB.ADD;
472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
473: END org_profile_merge;
474:

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

507:
508: x_to_id := l_to_id;
509: EXCEPTION
510: WHEN OTHERS THEN
511: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
512: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
513: FND_MSG_PUB.ADD;
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: END party_relationship_merge;

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

508: x_to_id := l_to_id;
509: EXCEPTION
510: WHEN OTHERS THEN
511: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
512: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
513: FND_MSG_PUB.ADD;
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: END party_relationship_merge;
516:

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

549:
550: x_to_id := l_to_id;
551: EXCEPTION
552: WHEN OTHERS THEN
553: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
554: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
555: FND_MSG_PUB.ADD;
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
557: END per_profile_merge;

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

550: x_to_id := l_to_id;
551: EXCEPTION
552: WHEN OTHERS THEN
553: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
554: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
555: FND_MSG_PUB.ADD;
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
557: END per_profile_merge;
558:

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

593:
594: x_to_id := l_to_id;
595: EXCEPTION
596: WHEN OTHERS THEN
597: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
598: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
599: FND_MSG_PUB.ADD;
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601: END party_usage_merge;

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

594: x_to_id := l_to_id;
595: EXCEPTION
596: WHEN OTHERS THEN
597: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
598: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
599: FND_MSG_PUB.ADD;
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601: END party_usage_merge;
602:

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

652:
653: x_to_id := l_to_id;
654: EXCEPTION
655: WHEN OTHERS THEN
656: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
657: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
658: FND_MSG_PUB.ADD;
659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
660: END party_reln_subject_merge;

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

653: x_to_id := l_to_id;
654: EXCEPTION
655: WHEN OTHERS THEN
656: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
657: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
658: FND_MSG_PUB.ADD;
659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
660: END party_reln_subject_merge;
661:

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

711:
712: x_to_id := l_to_id;
713: EXCEPTION
714: WHEN OTHERS THEN
715: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
716: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
717: FND_MSG_PUB.ADD;
718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
719: END party_reln_object_merge;

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

712: x_to_id := l_to_id;
713: EXCEPTION
714: WHEN OTHERS THEN
715: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
716: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
717: FND_MSG_PUB.ADD;
718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
719: END party_reln_object_merge;
720:

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

752:
753: x_to_id := l_to_id;
754: EXCEPTION
755: WHEN OTHERS THEN
756: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
757: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
758: FND_MSG_PUB.ADD;
759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
760: END org_contact_merge;

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

753: x_to_id := l_to_id;
754: EXCEPTION
755: WHEN OTHERS THEN
756: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
757: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
758: FND_MSG_PUB.ADD;
759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
760: END org_contact_merge;
761:

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

809:
810: x_to_id := l_to_id;
811: EXCEPTION
812: WHEN OTHERS THEN
813: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
814: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
815: FND_MSG_PUB.ADD;
816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
817: END org_contact_merge2;

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

810: x_to_id := l_to_id;
811: EXCEPTION
812: WHEN OTHERS THEN
813: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
814: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
815: FND_MSG_PUB.ADD;
816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
817: END org_contact_merge2;
818:

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

892:
893: x_to_id := l_to_id;
894: EXCEPTION
895: WHEN OTHERS THEN
896: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
897: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
898: FND_MSG_PUB.ADD;
899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
900: END party_site_merge;

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

893: x_to_id := l_to_id;
894: EXCEPTION
895: WHEN OTHERS THEN
896: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
897: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
898: FND_MSG_PUB.ADD;
899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
900: END party_site_merge;
901:

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

969:
970: x_to_id := l_to_id;
971: EXCEPTION
972: WHEN OTHERS THEN
973: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
975: FND_MSG_PUB.ADD;
976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
977: END cust_account_merge;

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

970: x_to_id := l_to_id;
971: EXCEPTION
972: WHEN OTHERS THEN
973: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
975: FND_MSG_PUB.ADD;
976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
977: END cust_account_merge;
978:

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

1021:
1022: x_to_id := l_to_id;
1023: EXCEPTION
1024: WHEN OTHERS THEN
1025: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1026: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1027: FND_MSG_PUB.ADD;
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1029: END cust_account_selling_merge;

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

1022: x_to_id := l_to_id;
1023: EXCEPTION
1024: WHEN OTHERS THEN
1025: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1026: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1027: FND_MSG_PUB.ADD;
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1029: END cust_account_selling_merge;
1030:

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

1068:
1069: x_to_id := l_to_id;
1070: EXCEPTION
1071: WHEN OTHERS THEN
1072: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1073: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1074: FND_MSG_PUB.ADD;
1075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1076: END cust_account_role_merge;

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

1069: x_to_id := l_to_id;
1070: EXCEPTION
1071: WHEN OTHERS THEN
1072: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1073: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1074: FND_MSG_PUB.ADD;
1075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1076: END cust_account_role_merge;
1077:

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

1117:
1118: x_to_id := l_to_id;
1119: EXCEPTION
1120: WHEN OTHERS THEN
1121: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1122: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1123: FND_MSG_PUB.ADD;
1124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1125: END cust_account_site_merge;

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

1118: x_to_id := l_to_id;
1119: EXCEPTION
1120: WHEN OTHERS THEN
1121: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1122: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1123: FND_MSG_PUB.ADD;
1124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1125: END cust_account_site_merge;
1126:

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

1195:
1196: x_to_id := l_to_id;
1197: EXCEPTION
1198: WHEN OTHERS THEN
1199: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1200: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1201: FND_MSG_PUB.ADD;
1202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1203: END financial_profile_merge;

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

1196: x_to_id := l_to_id;
1197: EXCEPTION
1198: WHEN OTHERS THEN
1199: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1200: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1201: FND_MSG_PUB.ADD;
1202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1203: END financial_profile_merge;
1204:

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

1288:
1289: x_to_id := l_to_id;
1290: EXCEPTION
1291: WHEN OTHERS THEN
1292: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1294: FND_MSG_PUB.ADD;
1295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1296: END contact_point_merge;

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

1289: x_to_id := l_to_id;
1290: EXCEPTION
1291: WHEN OTHERS THEN
1292: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1294: FND_MSG_PUB.ADD;
1295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1296: END contact_point_merge;
1297:

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

1367:
1368: x_to_id := l_to_id;
1369: EXCEPTION
1370: WHEN OTHERS THEN
1371: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1372: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1373: FND_MSG_PUB.ADD;
1374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1375: END references_merge;

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

1368: x_to_id := l_to_id;
1369: EXCEPTION
1370: WHEN OTHERS THEN
1371: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1372: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1373: FND_MSG_PUB.ADD;
1374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1375: END references_merge;
1376:

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

1447:
1448: x_to_id := l_to_id;
1449: EXCEPTION
1450: WHEN OTHERS THEN
1451: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1452: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1453: FND_MSG_PUB.ADD;
1454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1455: END certification_merge;

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

1448: x_to_id := l_to_id;
1449: EXCEPTION
1450: WHEN OTHERS THEN
1451: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1452: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1453: FND_MSG_PUB.ADD;
1454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1455: END certification_merge;
1456:

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

1496:
1497: x_to_id := l_to_id;
1498: EXCEPTION
1499: WHEN OTHERS THEN
1500: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1501: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1502: FND_MSG_PUB.ADD;
1503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1504: END credit_ratings_merge;

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

1497: x_to_id := l_to_id;
1498: EXCEPTION
1499: WHEN OTHERS THEN
1500: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1501: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1502: FND_MSG_PUB.ADD;
1503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1504: END credit_ratings_merge;
1505:

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

1547:
1548: x_to_id := l_to_id;
1549: EXCEPTION
1550: WHEN OTHERS THEN
1551: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1552: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1553: FND_MSG_PUB.ADD;
1554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1555: END security_issued_merge;

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

1548: x_to_id := l_to_id;
1549: EXCEPTION
1550: WHEN OTHERS THEN
1551: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1552: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1553: FND_MSG_PUB.ADD;
1554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1555: END security_issued_merge;
1556:

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

1596:
1597: x_to_id := l_to_id;
1598: EXCEPTION
1599: WHEN OTHERS THEN
1600: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1601: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1602: FND_MSG_PUB.ADD;
1603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1604: END financial_reports_merge;

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

1597: x_to_id := l_to_id;
1598: EXCEPTION
1599: WHEN OTHERS THEN
1600: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1601: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1602: FND_MSG_PUB.ADD;
1603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1604: END financial_reports_merge;
1605:

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

1646:
1647: x_to_id := l_to_id;
1648: EXCEPTION
1649: WHEN OTHERS THEN
1650: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1652: FND_MSG_PUB.ADD;
1653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1654: END org_indicators_merge;

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

1647: x_to_id := l_to_id;
1648: EXCEPTION
1649: WHEN OTHERS THEN
1650: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1652: FND_MSG_PUB.ADD;
1653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1654: END org_indicators_merge;
1655:

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

1695:
1696: x_to_id := l_to_id;
1697: EXCEPTION
1698: WHEN OTHERS THEN
1699: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1700: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1701: FND_MSG_PUB.ADD;
1702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1703: END org_ind_reference_merge;

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

1696: x_to_id := l_to_id;
1697: EXCEPTION
1698: WHEN OTHERS THEN
1699: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1700: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1701: FND_MSG_PUB.ADD;
1702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1703: END org_ind_reference_merge;
1704:

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

1745:
1746: x_to_id := l_to_id;
1747: EXCEPTION
1748: WHEN OTHERS THEN
1749: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1750: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1751: FND_MSG_PUB.ADD;
1752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1753: END per_interest_merge;

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

1746: x_to_id := l_to_id;
1747: EXCEPTION
1748: WHEN OTHERS THEN
1749: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1750: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1751: FND_MSG_PUB.ADD;
1752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1753: END per_interest_merge;
1754:

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

1794:
1795: x_to_id := l_to_id;
1796: EXCEPTION
1797: WHEN OTHERS THEN
1798: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1800: FND_MSG_PUB.ADD;
1801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1802: END citizenship_merge;

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

1795: x_to_id := l_to_id;
1796: EXCEPTION
1797: WHEN OTHERS THEN
1798: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1800: FND_MSG_PUB.ADD;
1801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1802: END citizenship_merge;
1803:

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

1843:
1844: x_to_id := l_to_id;
1845: EXCEPTION
1846: WHEN OTHERS THEN
1847: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1848: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1849: FND_MSG_PUB.ADD;
1850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1851: END education_merge;

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

1844: x_to_id := l_to_id;
1845: EXCEPTION
1846: WHEN OTHERS THEN
1847: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1848: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1849: FND_MSG_PUB.ADD;
1850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1851: END education_merge;
1852:

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

1892:
1893: x_to_id := l_to_id;
1894: EXCEPTION
1895: WHEN OTHERS THEN
1896: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1897: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1898: FND_MSG_PUB.ADD;
1899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1900: END education_school_merge;

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

1893: x_to_id := l_to_id;
1894: EXCEPTION
1895: WHEN OTHERS THEN
1896: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1897: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1898: FND_MSG_PUB.ADD;
1899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1900: END education_school_merge;
1901:

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

1941:
1942: x_to_id := l_to_id;
1943: EXCEPTION
1944: WHEN OTHERS THEN
1945: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1946: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1947: FND_MSG_PUB.ADD;
1948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1949: END emp_history_merge;

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

1942: x_to_id := l_to_id;
1943: EXCEPTION
1944: WHEN OTHERS THEN
1945: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1946: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1947: FND_MSG_PUB.ADD;
1948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1949: END emp_history_merge;
1950:

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

1990:
1991: x_to_id := l_to_id;
1992: EXCEPTION
1993: WHEN OTHERS THEN
1994: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1995: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1996: FND_MSG_PUB.ADD;
1997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1998: END emp_history_employed_merge;

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

1991: x_to_id := l_to_id;
1992: EXCEPTION
1993: WHEN OTHERS THEN
1994: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1995: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1996: FND_MSG_PUB.ADD;
1997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1998: END emp_history_employed_merge;
1999:

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

2039:
2040: x_to_id := l_to_id;
2041: EXCEPTION
2042: WHEN OTHERS THEN
2043: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2045: FND_MSG_PUB.ADD;
2046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2047: END work_class_merge;

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

2040: x_to_id := l_to_id;
2041: EXCEPTION
2042: WHEN OTHERS THEN
2043: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2045: FND_MSG_PUB.ADD;
2046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2047: END work_class_merge;
2048:

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

2088:
2089: x_to_id := l_to_id;
2090: EXCEPTION
2091: WHEN OTHERS THEN
2092: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2093: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2094: FND_MSG_PUB.ADD;
2095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2096: END code_assignment_merge;

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

2089: x_to_id := l_to_id;
2090: EXCEPTION
2091: WHEN OTHERS THEN
2092: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2093: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2094: FND_MSG_PUB.ADD;
2095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2096: END code_assignment_merge;
2097:

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

2137:
2138: x_to_id := l_to_id;
2139: EXCEPTION
2140: WHEN OTHERS THEN
2141: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2142: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2143: FND_MSG_PUB.ADD;
2144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2145: END code_assignment_merge2;

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

2138: x_to_id := l_to_id;
2139: EXCEPTION
2140: WHEN OTHERS THEN
2141: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2142: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2143: FND_MSG_PUB.ADD;
2144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2145: END code_assignment_merge2;
2146:

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

2186:
2187: x_to_id := l_to_id;
2188: EXCEPTION
2189: WHEN OTHERS THEN
2190: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2191: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2192: FND_MSG_PUB.ADD;
2193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2194: END org_contact_role_merge;

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

2187: x_to_id := l_to_id;
2188: EXCEPTION
2189: WHEN OTHERS THEN
2190: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2191: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2192: FND_MSG_PUB.ADD;
2193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2194: END org_contact_role_merge;
2195:

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

2235:
2236: x_to_id := l_to_id;
2237: EXCEPTION
2238: WHEN OTHERS THEN
2239: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2240: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2241: FND_MSG_PUB.ADD;
2242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2243: END financial_number_merge;

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

2236: x_to_id := l_to_id;
2237: EXCEPTION
2238: WHEN OTHERS THEN
2239: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2240: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2241: FND_MSG_PUB.ADD;
2242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2243: END financial_number_merge;
2244:

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

2284:
2285: x_to_id := l_to_id;
2286: EXCEPTION
2287: WHEN OTHERS THEN
2288: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2289: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2290: FND_MSG_PUB.ADD;
2291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2292: END per_languages_merge;

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

2285: x_to_id := l_to_id;
2286: EXCEPTION
2287: WHEN OTHERS THEN
2288: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2289: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2290: FND_MSG_PUB.ADD;
2291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2292: END per_languages_merge;
2293:

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

2333:
2334: x_to_id := l_to_id;
2335: EXCEPTION
2336: WHEN OTHERS THEN
2337: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2338: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2339: FND_MSG_PUB.ADD;
2340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2341: END party_site_use_merge;

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

2334: x_to_id := l_to_id;
2335: EXCEPTION
2336: WHEN OTHERS THEN
2337: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2338: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2339: FND_MSG_PUB.ADD;
2340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2341: END party_site_use_merge;
2342:

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

2398:
2399: x_to_id := l_to_id;
2400: EXCEPTION
2401: WHEN OTHERS THEN
2402: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2403: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2404: FND_MSG_PUB.ADD;
2405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2406: END contact_point_merge2;

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

2399: x_to_id := l_to_id;
2400: EXCEPTION
2401: WHEN OTHERS THEN
2402: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2403: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2404: FND_MSG_PUB.ADD;
2405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2406: END contact_point_merge2;
2407:

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

2476:
2477: x_to_id := l_to_id;
2478: EXCEPTION
2479: WHEN OTHERS THEN
2480: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2481: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2482: FND_MSG_PUB.ADD;
2483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2484: END contact_preference_merge;

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

2477: x_to_id := l_to_id;
2478: EXCEPTION
2479: WHEN OTHERS THEN
2480: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2481: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2482: FND_MSG_PUB.ADD;
2483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2484: END contact_preference_merge;
2485:

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

2554:
2555: x_to_id := l_to_id;
2556: EXCEPTION
2557: WHEN OTHERS THEN
2558: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2559: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2560: FND_MSG_PUB.ADD;
2561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2562: END contact_preference_merge2;

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

2555: x_to_id := l_to_id;
2556: EXCEPTION
2557: WHEN OTHERS THEN
2558: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2559: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2560: FND_MSG_PUB.ADD;
2561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2562: END contact_preference_merge2;
2563:

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

2633:
2634: x_to_id := l_to_id;
2635: EXCEPTION
2636: WHEN OTHERS THEN
2637: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2638: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2639: FND_MSG_PUB.ADD;
2640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2641: END contact_preference_merge3;

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

2634: x_to_id := l_to_id;
2635: EXCEPTION
2636: WHEN OTHERS THEN
2637: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2638: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2639: FND_MSG_PUB.ADD;
2640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2641: END contact_preference_merge3;
2642:

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

2673: do_displayed_duns_merge(p_from_id, l_to_id, p_from_fk_id, p_to_fk_id,
2674: x_return_status);
2675: EXCEPTION
2676: WHEN OTHERS THEN
2677: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2678: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2679: FND_MSG_PUB.ADD;
2680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2681: END displayed_duns_merge;

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

2674: x_return_status);
2675: EXCEPTION
2676: WHEN OTHERS THEN
2677: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2678: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2679: FND_MSG_PUB.ADD;
2680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2681: END displayed_duns_merge;
2682:

Line 2702: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_ENTITIES');

2698:
2699: BEGIN
2700: IF (p_entity_name <> p_exp_ent_name OR
2701: p_par_entity_name <> p_exp_par_ent_name) THEN
2702: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_ENTITIES');
2703: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
2704: FND_MESSAGE.SET_TOKEN('PENTITY' ,p_par_entity_name);
2705: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
2706: FND_MSG_PUB.ADD;

Line 2703: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);

2699: BEGIN
2700: IF (p_entity_name <> p_exp_ent_name OR
2701: p_par_entity_name <> p_exp_par_ent_name) THEN
2702: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_ENTITIES');
2703: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
2704: FND_MESSAGE.SET_TOKEN('PENTITY' ,p_par_entity_name);
2705: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
2706: FND_MSG_PUB.ADD;
2707: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2704: FND_MESSAGE.SET_TOKEN('PENTITY' ,p_par_entity_name);

2700: IF (p_entity_name <> p_exp_ent_name OR
2701: p_par_entity_name <> p_exp_par_ent_name) THEN
2702: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_ENTITIES');
2703: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
2704: FND_MESSAGE.SET_TOKEN('PENTITY' ,p_par_entity_name);
2705: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
2706: FND_MSG_PUB.ADD;
2707: x_return_status := FND_API.G_RET_STS_ERROR;
2708: END IF;

Line 2705: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);

2701: p_par_entity_name <> p_exp_par_ent_name) THEN
2702: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_ENTITIES');
2703: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
2704: FND_MESSAGE.SET_TOKEN('PENTITY' ,p_par_entity_name);
2705: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
2706: FND_MSG_PUB.ADD;
2707: x_return_status := FND_API.G_RET_STS_ERROR;
2708: END IF;
2709:

Line 2711: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_REC');

2707: x_return_status := FND_API.G_RET_STS_ERROR;
2708: END IF;
2709:
2710: IF (p_from_id = FND_API.G_MISS_NUM) THEN
2711: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_REC');
2712: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
2713: FND_MESSAGE.SET_TOKEN('ENTITY',p_entity_name);
2714: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);
2715: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);

Line 2712: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);

2708: END IF;
2709:
2710: IF (p_from_id = FND_API.G_MISS_NUM) THEN
2711: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_REC');
2712: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
2713: FND_MESSAGE.SET_TOKEN('ENTITY',p_entity_name);
2714: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);
2715: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);
2716: FND_MSG_PUB.ADD;

Line 2713: FND_MESSAGE.SET_TOKEN('ENTITY',p_entity_name);

2709:
2710: IF (p_from_id = FND_API.G_MISS_NUM) THEN
2711: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_REC');
2712: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
2713: FND_MESSAGE.SET_TOKEN('ENTITY',p_entity_name);
2714: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);
2715: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);
2716: FND_MSG_PUB.ADD;
2717: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2714: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);

2710: IF (p_from_id = FND_API.G_MISS_NUM) THEN
2711: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_REC');
2712: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
2713: FND_MESSAGE.SET_TOKEN('ENTITY',p_entity_name);
2714: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);
2715: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);
2716: FND_MSG_PUB.ADD;
2717: x_return_status := FND_API.G_RET_STS_ERROR;
2718: END IF;

Line 2715: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);

2711: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_REC');
2712: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
2713: FND_MESSAGE.SET_TOKEN('ENTITY',p_entity_name);
2714: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);
2715: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);
2716: FND_MSG_PUB.ADD;
2717: x_return_status := FND_API.G_RET_STS_ERROR;
2718: END IF;
2719:

Line 2722: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_PAR_REC');

2718: END IF;
2719:
2720: IF (p_exp_par_ent_name <> FND_API.G_MISS_CHAR AND
2721: p_to_fk_id = FND_API.G_MISS_NUM ) THEN
2722: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_PAR_REC');
2723: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
2724: FND_MESSAGE.SET_TOKEN('ENTITY',p_par_entity_name);
2725: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);
2726: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);

Line 2723: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);

2719:
2720: IF (p_exp_par_ent_name <> FND_API.G_MISS_CHAR AND
2721: p_to_fk_id = FND_API.G_MISS_NUM ) THEN
2722: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_PAR_REC');
2723: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
2724: FND_MESSAGE.SET_TOKEN('ENTITY',p_par_entity_name);
2725: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);
2726: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);
2727: FND_MSG_PUB.ADD;

Line 2724: FND_MESSAGE.SET_TOKEN('ENTITY',p_par_entity_name);

2720: IF (p_exp_par_ent_name <> FND_API.G_MISS_CHAR AND
2721: p_to_fk_id = FND_API.G_MISS_NUM ) THEN
2722: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_PAR_REC');
2723: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
2724: FND_MESSAGE.SET_TOKEN('ENTITY',p_par_entity_name);
2725: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);
2726: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);
2727: FND_MSG_PUB.ADD;
2728: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2725: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);

2721: p_to_fk_id = FND_API.G_MISS_NUM ) THEN
2722: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_PAR_REC');
2723: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
2724: FND_MESSAGE.SET_TOKEN('ENTITY',p_par_entity_name);
2725: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);
2726: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);
2727: FND_MSG_PUB.ADD;
2728: x_return_status := FND_API.G_RET_STS_ERROR;
2729: END IF;

Line 2726: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);

2722: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_PAR_REC');
2723: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
2724: FND_MESSAGE.SET_TOKEN('ENTITY',p_par_entity_name);
2725: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);
2726: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);
2727: FND_MSG_PUB.ADD;
2728: x_return_status := FND_API.G_RET_STS_ERROR;
2729: END IF;
2730: EXCEPTION

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

2728: x_return_status := FND_API.G_RET_STS_ERROR;
2729: END IF;
2730: EXCEPTION
2731: WHEN OTHERS THEN
2732: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2733: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2734: FND_MSG_PUB.ADD;
2735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2736: END check_params;

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

2729: END IF;
2730: EXCEPTION
2731: WHEN OTHERS THEN
2732: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2733: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2734: FND_MSG_PUB.ADD;
2735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2736: END check_params;
2737:

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

2773: x_return_status => x_return_status,
2774: x_msg_count =>l_msg_count,
2775: x_msg_data =>l_msg_data);
2776: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2777: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2778: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
2779: FND_MSG_PUB.ADD;
2780: x_return_status := FND_API.G_RET_STS_ERROR;
2781: RETURN;

Line 2778: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');

2774: x_msg_count =>l_msg_count,
2775: x_msg_data =>l_msg_data);
2776: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2777: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2778: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
2779: FND_MSG_PUB.ADD;
2780: x_return_status := FND_API.G_RET_STS_ERROR;
2781: RETURN;
2782: END IF;

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

2796: END IF;
2797:
2798: EXCEPTION
2799: WHEN OTHERS THEN
2800: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2801: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2802: FND_MSG_PUB.ADD;
2803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2804: END do_cust_account_transfer;

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

2797:
2798: EXCEPTION
2799: WHEN OTHERS THEN
2800: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2801: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2802: FND_MSG_PUB.ADD;
2803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2804: END do_cust_account_transfer;
2805:

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

2865: x_return_status => x_return_status,
2866: x_msg_count =>l_msg_count,
2867: x_msg_data =>l_msg_data);
2868: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2869: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2870: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
2871: FND_MSG_PUB.ADD;
2872: x_return_status := FND_API.G_RET_STS_ERROR;
2873: RETURN;

Line 2870: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');

2866: x_msg_count =>l_msg_count,
2867: x_msg_data =>l_msg_data);
2868: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2869: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2870: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
2871: FND_MSG_PUB.ADD;
2872: x_return_status := FND_API.G_RET_STS_ERROR;
2873: RETURN;
2874: END IF;

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

2909: END IF;
2910:
2911: EXCEPTION
2912: WHEN OTHERS THEN
2913: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2914: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2915: FND_MSG_PUB.ADD;
2916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2917: END do_cust_account_role_transfer;

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

2910:
2911: EXCEPTION
2912: WHEN OTHERS THEN
2913: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2914: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2915: FND_MSG_PUB.ADD;
2916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2917: END do_cust_account_role_transfer;
2918:

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

2956: END IF;
2957:
2958: EXCEPTION
2959: WHEN OTHERS THEN
2960: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2961: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2962: FND_MSG_PUB.ADD;
2963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2964: END do_fin_profile_transfer;

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

2957:
2958: EXCEPTION
2959: WHEN OTHERS THEN
2960: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2961: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2962: FND_MSG_PUB.ADD;
2963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2964: END do_fin_profile_transfer;
2965:

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

3034: x_return_status => x_return_status,
3035: x_msg_count =>l_msg_count,
3036: x_msg_data =>l_msg_data);
3037: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3038: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3039: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
3040: FND_MSG_PUB.ADD;
3041: x_return_status := FND_API.G_RET_STS_ERROR;
3042: RETURN;

Line 3039: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');

3035: x_msg_count =>l_msg_count,
3036: x_msg_data =>l_msg_data);
3037: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3038: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3039: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
3040: FND_MSG_PUB.ADD;
3041: x_return_status := FND_API.G_RET_STS_ERROR;
3042: RETURN;
3043: END IF;

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

3126: END IF;
3127:
3128: EXCEPTION
3129: WHEN OTHERS THEN
3130: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3131: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3132: FND_MSG_PUB.ADD;
3133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3134: END do_contact_point_transfer;

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

3127:
3128: EXCEPTION
3129: WHEN OTHERS THEN
3130: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3131: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3132: FND_MSG_PUB.ADD;
3133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3134: END do_contact_point_transfer;
3135:

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

3191: x_return_status => x_return_status,
3192: x_msg_count =>l_msg_count,
3193: x_msg_data =>l_msg_data);
3194: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3195: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3196: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
3197: FND_MSG_PUB.ADD;
3198: x_return_status := FND_API.G_RET_STS_ERROR;
3199: RETURN;

Line 3196: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');

3192: x_msg_count =>l_msg_count,
3193: x_msg_data =>l_msg_data);
3194: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3195: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3196: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
3197: FND_MSG_PUB.ADD;
3198: x_return_status := FND_API.G_RET_STS_ERROR;
3199: RETURN;
3200: END IF;

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

3257: END IF;
3258:
3259: EXCEPTION
3260: WHEN OTHERS THEN
3261: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3262: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3263: FND_MSG_PUB.ADD;
3264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3265: END do_contact_point_transfer2;

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

3258:
3259: EXCEPTION
3260: WHEN OTHERS THEN
3261: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3262: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3263: FND_MSG_PUB.ADD;
3264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3265: END do_contact_point_transfer2;
3266:

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

3303: END IF;
3304:
3305: EXCEPTION
3306: WHEN OTHERS THEN
3307: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3308: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3309: FND_MSG_PUB.ADD;
3310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3311: END do_contact_pref_transfer;

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

3304:
3305: EXCEPTION
3306: WHEN OTHERS THEN
3307: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3308: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3309: FND_MSG_PUB.ADD;
3310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3311: END do_contact_pref_transfer;
3312:

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

3350: END IF;
3351:
3352: EXCEPTION
3353: WHEN OTHERS THEN
3354: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3355: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3356: FND_MSG_PUB.ADD;
3357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3358: END do_references_transfer;

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

3351:
3352: EXCEPTION
3353: WHEN OTHERS THEN
3354: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3355: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3356: FND_MSG_PUB.ADD;
3357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3358: END do_references_transfer;
3359:

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

3397: END IF;
3398:
3399: EXCEPTION
3400: WHEN OTHERS THEN
3401: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3402: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3403: FND_MSG_PUB.ADD;
3404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3405: END do_certification_transfer;

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

3398:
3399: EXCEPTION
3400: WHEN OTHERS THEN
3401: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3402: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3403: FND_MSG_PUB.ADD;
3404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3405: END do_certification_transfer;
3406:

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

3444: END IF;
3445:
3446: EXCEPTION
3447: WHEN OTHERS THEN
3448: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3449: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3450: FND_MSG_PUB.ADD;
3451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3452: END do_credit_ratings_transfer;

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

3445:
3446: EXCEPTION
3447: WHEN OTHERS THEN
3448: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3449: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3450: FND_MSG_PUB.ADD;
3451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3452: END do_credit_ratings_transfer;
3453:

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

3491: END IF;
3492:
3493: EXCEPTION
3494: WHEN OTHERS THEN
3495: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3496: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3497: FND_MSG_PUB.ADD;
3498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3499: END do_security_issued_transfer;

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

3492:
3493: EXCEPTION
3494: WHEN OTHERS THEN
3495: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3496: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3497: FND_MSG_PUB.ADD;
3498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3499: END do_security_issued_transfer;
3500:

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

3538: END IF;
3539:
3540: EXCEPTION
3541: WHEN OTHERS THEN
3542: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3544: FND_MSG_PUB.ADD;
3545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3546: END do_financial_reports_transfer;

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

3539:
3540: EXCEPTION
3541: WHEN OTHERS THEN
3542: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3544: FND_MSG_PUB.ADD;
3545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3546: END do_financial_reports_transfer;
3547:

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

3585: END IF;
3586:
3587: EXCEPTION
3588: WHEN OTHERS THEN
3589: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3590: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3591: FND_MSG_PUB.ADD;
3592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3593: END do_org_indicators_transfer;

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

3586:
3587: EXCEPTION
3588: WHEN OTHERS THEN
3589: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3590: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3591: FND_MSG_PUB.ADD;
3592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3593: END do_org_indicators_transfer;
3594:

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

3632: END IF;
3633:
3634: EXCEPTION
3635: WHEN OTHERS THEN
3636: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3637: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3638: FND_MSG_PUB.ADD;
3639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3640: END do_ind_reference_transfer;

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

3633:
3634: EXCEPTION
3635: WHEN OTHERS THEN
3636: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3637: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3638: FND_MSG_PUB.ADD;
3639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3640: END do_ind_reference_transfer;
3641:

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

3679: END IF;
3680:
3681: EXCEPTION
3682: WHEN OTHERS THEN
3683: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3684: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3685: FND_MSG_PUB.ADD;
3686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3687: END do_per_interest_transfer;

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

3680:
3681: EXCEPTION
3682: WHEN OTHERS THEN
3683: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3684: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3685: FND_MSG_PUB.ADD;
3686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3687: END do_per_interest_transfer;
3688:

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

3726: END IF;
3727:
3728: EXCEPTION
3729: WHEN OTHERS THEN
3730: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3731: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3732: FND_MSG_PUB.ADD;
3733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3734: END do_citizenship_transfer;

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

3727:
3728: EXCEPTION
3729: WHEN OTHERS THEN
3730: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3731: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3732: FND_MSG_PUB.ADD;
3733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3734: END do_citizenship_transfer;
3735:

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

3773: END IF;
3774:
3775: EXCEPTION
3776: WHEN OTHERS THEN
3777: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3778: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3779: FND_MSG_PUB.ADD;
3780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3781: END do_education_transfer;

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

3774:
3775: EXCEPTION
3776: WHEN OTHERS THEN
3777: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3778: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3779: FND_MSG_PUB.ADD;
3780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3781: END do_education_transfer;
3782:

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

3820: END IF;
3821:
3822: EXCEPTION
3823: WHEN OTHERS THEN
3824: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3825: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3826: FND_MSG_PUB.ADD;
3827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3828: END do_education_school_transfer;

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

3821:
3822: EXCEPTION
3823: WHEN OTHERS THEN
3824: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3825: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3826: FND_MSG_PUB.ADD;
3827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3828: END do_education_school_transfer;
3829:

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

3868: END IF;
3869:
3870: EXCEPTION
3871: WHEN OTHERS THEN
3872: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3873: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3874: FND_MSG_PUB.ADD;
3875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3876: END do_emp_history_transfer;

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

3869:
3870: EXCEPTION
3871: WHEN OTHERS THEN
3872: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3873: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3874: FND_MSG_PUB.ADD;
3875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3876: END do_emp_history_transfer;
3877:

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

3915: END IF;
3916:
3917: EXCEPTION
3918: WHEN OTHERS THEN
3919: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3920: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3921: FND_MSG_PUB.ADD;
3922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3923: END do_employed_transfer;

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

3916:
3917: EXCEPTION
3918: WHEN OTHERS THEN
3919: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3920: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3921: FND_MSG_PUB.ADD;
3922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3923: END do_employed_transfer;
3924:

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

3963: END IF;
3964:
3965: EXCEPTION
3966: WHEN OTHERS THEN
3967: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3968: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3969: FND_MSG_PUB.ADD;
3970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3971: END do_work_class_transfer;

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

3964:
3965: EXCEPTION
3966: WHEN OTHERS THEN
3967: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3968: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3969: FND_MSG_PUB.ADD;
3970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3971: END do_work_class_transfer;
3972:

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

4017: x_return_status => x_return_status,
4018: x_msg_count =>l_msg_count,
4019: x_msg_data =>l_msg_data);
4020: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4021: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4022: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
4023: FND_MSG_PUB.ADD;
4024: x_return_status := FND_API.G_RET_STS_ERROR;
4025: RETURN;

Line 4022: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');

4018: x_msg_count =>l_msg_count,
4019: x_msg_data =>l_msg_data);
4020: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4021: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4022: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
4023: FND_MSG_PUB.ADD;
4024: x_return_status := FND_API.G_RET_STS_ERROR;
4025: RETURN;
4026: END IF;

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

4092: END IF;
4093:
4094: EXCEPTION
4095: WHEN OTHERS THEN
4096: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4097: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4098: FND_MSG_PUB.ADD;
4099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4100: END do_org_contact_role_transfer;

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

4093:
4094: EXCEPTION
4095: WHEN OTHERS THEN
4096: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4097: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4098: FND_MSG_PUB.ADD;
4099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4100: END do_org_contact_role_transfer;
4101:

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

4138: END IF;
4139:
4140: EXCEPTION
4141: WHEN OTHERS THEN
4142: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4144: FND_MSG_PUB.ADD;
4145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4146: END do_financial_number_transfer;

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

4139:
4140: EXCEPTION
4141: WHEN OTHERS THEN
4142: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4144: FND_MSG_PUB.ADD;
4145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4146: END do_financial_number_transfer;
4147:

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

4251: END IF;
4252:
4253: EXCEPTION
4254: WHEN OTHERS THEN
4255: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4256: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4257: FND_MSG_PUB.ADD;
4258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4259: END do_code_assignment_transfer;

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

4252:
4253: EXCEPTION
4254: WHEN OTHERS THEN
4255: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4256: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4257: FND_MSG_PUB.ADD;
4258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4259: END do_code_assignment_transfer;
4260:

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

4349: END IF;
4350:
4351: EXCEPTION
4352: WHEN OTHERS THEN
4353: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4354: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4355: FND_MSG_PUB.ADD;
4356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4357: END do_code_assignment_transfer2;

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

4350:
4351: EXCEPTION
4352: WHEN OTHERS THEN
4353: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4354: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4355: FND_MSG_PUB.ADD;
4356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4357: END do_code_assignment_transfer2;
4358:

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

4455: END IF;
4456:
4457: EXCEPTION
4458: WHEN OTHERS THEN
4459: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4460: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4461: FND_MSG_PUB.ADD;
4462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4463: END do_per_languages_transfer;

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

4456:
4457: EXCEPTION
4458: WHEN OTHERS THEN
4459: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4460: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4461: FND_MSG_PUB.ADD;
4462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4463: END do_per_languages_transfer;
4464:

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

4522: x_msg_count => l_msg_count,
4523: x_msg_data => l_msg_data );
4524:
4525: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4526: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4527: FND_MESSAGE.SET_TOKEN('ERROR','Cannot get party site use ID : ' || p_from_id);
4528: FND_MSG_PUB.ADD;
4529: x_return_status := FND_API.G_RET_STS_ERROR;
4530:

Line 4527: FND_MESSAGE.SET_TOKEN('ERROR','Cannot get party site use ID : ' || p_from_id);

4523: x_msg_data => l_msg_data );
4524:
4525: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4526: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4527: FND_MESSAGE.SET_TOKEN('ERROR','Cannot get party site use ID : ' || p_from_id);
4528: FND_MSG_PUB.ADD;
4529: x_return_status := FND_API.G_RET_STS_ERROR;
4530:
4531: RETURN;

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

4558: x_msg_count => l_msg_count,
4559: x_msg_data => l_msg_data );
4560:
4561: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4562: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4563: FND_MESSAGE.SET_TOKEN('ERROR','Cannot copy party site use for ID : ' || p_from_id);
4564: FND_MSG_PUB.ADD;
4565: x_return_status := FND_API.G_RET_STS_ERROR;
4566: RETURN;

Line 4563: FND_MESSAGE.SET_TOKEN('ERROR','Cannot copy party site use for ID : ' || p_from_id);

4559: x_msg_data => l_msg_data );
4560:
4561: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4562: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4563: FND_MESSAGE.SET_TOKEN('ERROR','Cannot copy party site use for ID : ' || p_from_id);
4564: FND_MSG_PUB.ADD;
4565: x_return_status := FND_API.G_RET_STS_ERROR;
4566: RETURN;
4567: END IF;

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

4584: END IF;
4585:
4586: EXCEPTION
4587: WHEN OTHERS THEN
4588: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4589: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4590: FND_MSG_PUB.ADD;
4591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4592: END do_party_site_use_transfer;

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

4585:
4586: EXCEPTION
4587: WHEN OTHERS THEN
4588: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4589: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4590: FND_MSG_PUB.ADD;
4591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4592: END do_party_site_use_transfer;
4593:

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

4628: x_return_status => x_return_status,
4629: x_msg_count =>l_msg_count,
4630: x_msg_data =>l_msg_data);
4631: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4632: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4633: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
4634: FND_MSG_PUB.ADD;
4635: x_return_status := FND_API.G_RET_STS_ERROR;
4636: RETURN;

Line 4633: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');

4629: x_msg_count =>l_msg_count,
4630: x_msg_data =>l_msg_data);
4631: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4632: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4633: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
4634: FND_MSG_PUB.ADD;
4635: x_return_status := FND_API.G_RET_STS_ERROR;
4636: RETURN;
4637: END IF;

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

4652: END IF;
4653:
4654: EXCEPTION
4655: WHEN OTHERS THEN
4656: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4657: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4658: FND_MSG_PUB.ADD;
4659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4660: END do_cust_account_site_transfer;

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

4653:
4654: EXCEPTION
4655: WHEN OTHERS THEN
4656: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4657: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4658: FND_MSG_PUB.ADD;
4659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4660: END do_cust_account_site_transfer;
4661:

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

4699: x_return_status => x_return_status,
4700: x_msg_count =>l_msg_count,
4701: x_msg_data =>l_msg_data);
4702: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4703: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4704: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
4705: FND_MSG_PUB.ADD;
4706: x_return_status := FND_API.G_RET_STS_ERROR;
4707: RETURN;

Line 4704: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');

4700: x_msg_count =>l_msg_count,
4701: x_msg_data =>l_msg_data);
4702: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4703: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4704: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
4705: FND_MSG_PUB.ADD;
4706: x_return_status := FND_API.G_RET_STS_ERROR;
4707: RETURN;
4708: END IF;

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

4723: END IF;
4724:
4725: EXCEPTION
4726: WHEN OTHERS THEN
4727: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4728: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4729: FND_MSG_PUB.ADD;
4730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4731: END do_org_contact_transfer;

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

4724:
4725: EXCEPTION
4726: WHEN OTHERS THEN
4727: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4728: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4729: FND_MSG_PUB.ADD;
4730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4731: END do_org_contact_transfer;
4732:

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

4872: x_return_status => x_return_status,
4873: x_msg_count =>l_msg_count,
4874: x_msg_data =>l_msg_data);
4875: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4876: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4877: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
4878: FND_MSG_PUB.ADD;
4879: x_return_status := FND_API.G_RET_STS_ERROR;
4880: RETURN;

Line 4877: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');

4873: x_msg_count =>l_msg_count,
4874: x_msg_data =>l_msg_data);
4875: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4876: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4877: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
4878: FND_MSG_PUB.ADD;
4879: x_return_status := FND_API.G_RET_STS_ERROR;
4880: RETURN;
4881: END IF;

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

4885: END IF;
4886:
4887: EXCEPTION
4888: WHEN OTHERS THEN
4889: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4890: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4891: FND_MSG_PUB.ADD;
4892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4893: END do_org_contact_transfer2;

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

4886:
4887: EXCEPTION
4888: WHEN OTHERS THEN
4889: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4890: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4891: FND_MSG_PUB.ADD;
4892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4893: END do_org_contact_transfer2;
4894:

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

5021: -- END IF; --l_from_usage_code
5022:
5023: EXCEPTION
5024: WHEN OTHERS THEN
5025: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
5026: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5027: FND_MSG_PUB.ADD;
5028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5029: END do_party_usage_merge;

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

5022:
5023: EXCEPTION
5024: WHEN OTHERS THEN
5025: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
5026: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5027: FND_MSG_PUB.ADD;
5028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5029: END do_party_usage_merge;
5030:

Line 5138: FND_MESSAGE.SET_NAME('AR', 'HZ_RELN_MERGE_NOT_ALLOWED');

5134: CLOSE c_party;
5135:
5136: IF l_to_party_id IS NOT NULL AND l_from_party_id IS NOT NULL
5137: AND l_from_party_id <> l_to_party_id THEN
5138: FND_MESSAGE.SET_NAME('AR', 'HZ_RELN_MERGE_NOT_ALLOWED');
5139: FND_MESSAGE.SET_TOKEN('FROMID',p_from_id);
5140: FND_MESSAGE.SET_TOKEN('TOID',x_to_id);
5141: FND_MSG_PUB.ADD;
5142: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5139: FND_MESSAGE.SET_TOKEN('FROMID',p_from_id);

5135:
5136: IF l_to_party_id IS NOT NULL AND l_from_party_id IS NOT NULL
5137: AND l_from_party_id <> l_to_party_id THEN
5138: FND_MESSAGE.SET_NAME('AR', 'HZ_RELN_MERGE_NOT_ALLOWED');
5139: FND_MESSAGE.SET_TOKEN('FROMID',p_from_id);
5140: FND_MESSAGE.SET_TOKEN('TOID',x_to_id);
5141: FND_MSG_PUB.ADD;
5142: x_return_status := FND_API.G_RET_STS_ERROR;
5143: RETURN;

Line 5140: FND_MESSAGE.SET_TOKEN('TOID',x_to_id);

5136: IF l_to_party_id IS NOT NULL AND l_from_party_id IS NOT NULL
5137: AND l_from_party_id <> l_to_party_id THEN
5138: FND_MESSAGE.SET_NAME('AR', 'HZ_RELN_MERGE_NOT_ALLOWED');
5139: FND_MESSAGE.SET_TOKEN('FROMID',p_from_id);
5140: FND_MESSAGE.SET_TOKEN('TOID',x_to_id);
5141: FND_MSG_PUB.ADD;
5142: x_return_status := FND_API.G_RET_STS_ERROR;
5143: RETURN;
5144: END IF;

Line 5205: FND_MESSAGE.SET_NAME('AR', 'HZ_RELN_TRANSFER_NOT_ALLOWED');

5201: FETCH c_check_valid_merge INTO l_dup_reln_id, l_request_id;
5202: IF c_check_valid_merge%FOUND AND
5203: l_request_id <> hz_utility_pub.request_id THEN
5204: CLOSE c_check_valid_merge;
5205: FND_MESSAGE.SET_NAME('AR', 'HZ_RELN_TRANSFER_NOT_ALLOWED');
5206: FND_MESSAGE.SET_TOKEN('FROMID',p_from_id);
5207: FND_MSG_PUB.ADD;
5208: x_return_status := FND_API.G_RET_STS_ERROR;
5209: RETURN;

Line 5206: FND_MESSAGE.SET_TOKEN('FROMID',p_from_id);

5202: IF c_check_valid_merge%FOUND AND
5203: l_request_id <> hz_utility_pub.request_id THEN
5204: CLOSE c_check_valid_merge;
5205: FND_MESSAGE.SET_NAME('AR', 'HZ_RELN_TRANSFER_NOT_ALLOWED');
5206: FND_MESSAGE.SET_TOKEN('FROMID',p_from_id);
5207: FND_MSG_PUB.ADD;
5208: x_return_status := FND_API.G_RET_STS_ERROR;
5209: RETURN;
5210: END IF;

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

5401: END IF; --l_self_rel_flag
5402:
5403: EXCEPTION
5404: WHEN OTHERS THEN
5405: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
5406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5407: FND_MSG_PUB.ADD;
5408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5409:

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

5402:
5403: EXCEPTION
5404: WHEN OTHERS THEN
5405: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
5406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5407: FND_MSG_PUB.ADD;
5408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5409:
5410: END;

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

5415: END IF;
5416:
5417: EXCEPTION
5418: WHEN OTHERS THEN
5419: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
5420: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5421: FND_MSG_PUB.ADD;
5422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5423: END do_party_reln_obj_merge;

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

5416:
5417: EXCEPTION
5418: WHEN OTHERS THEN
5419: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
5420: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5421: FND_MSG_PUB.ADD;
5422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5423: END do_party_reln_obj_merge;
5424:

Line 5532: FND_MESSAGE.SET_NAME('AR', 'HZ_RELN_MERGE_NOT_ALLOWED');

5528:
5529:
5530: IF l_to_party_id IS NOT NULL AND l_from_party_id IS NOT NULL
5531: AND l_from_party_id <> l_to_party_id THEN
5532: FND_MESSAGE.SET_NAME('AR', 'HZ_RELN_MERGE_NOT_ALLOWED');
5533: FND_MESSAGE.SET_TOKEN('FROMID',p_from_id);
5534: FND_MESSAGE.SET_TOKEN('TOID',x_to_id);
5535: FND_MSG_PUB.ADD;
5536: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5533: FND_MESSAGE.SET_TOKEN('FROMID',p_from_id);

5529:
5530: IF l_to_party_id IS NOT NULL AND l_from_party_id IS NOT NULL
5531: AND l_from_party_id <> l_to_party_id THEN
5532: FND_MESSAGE.SET_NAME('AR', 'HZ_RELN_MERGE_NOT_ALLOWED');
5533: FND_MESSAGE.SET_TOKEN('FROMID',p_from_id);
5534: FND_MESSAGE.SET_TOKEN('TOID',x_to_id);
5535: FND_MSG_PUB.ADD;
5536: x_return_status := FND_API.G_RET_STS_ERROR;
5537: RETURN;

Line 5534: FND_MESSAGE.SET_TOKEN('TOID',x_to_id);

5530: IF l_to_party_id IS NOT NULL AND l_from_party_id IS NOT NULL
5531: AND l_from_party_id <> l_to_party_id THEN
5532: FND_MESSAGE.SET_NAME('AR', 'HZ_RELN_MERGE_NOT_ALLOWED');
5533: FND_MESSAGE.SET_TOKEN('FROMID',p_from_id);
5534: FND_MESSAGE.SET_TOKEN('TOID',x_to_id);
5535: FND_MSG_PUB.ADD;
5536: x_return_status := FND_API.G_RET_STS_ERROR;
5537: RETURN;
5538: END IF;

Line 5604: FND_MESSAGE.SET_NAME('AR', 'HZ_RELN_TRANSFER_NOT_ALLOWED');

5600: IF c_check_valid_merge%FOUND AND
5601: l_request_id <> hz_utility_pub.request_id THEN
5602: CLOSE c_check_valid_merge;
5603:
5604: FND_MESSAGE.SET_NAME('AR', 'HZ_RELN_TRANSFER_NOT_ALLOWED');
5605: FND_MESSAGE.SET_TOKEN('FROMID',p_from_id);
5606: FND_MSG_PUB.ADD;
5607: x_return_status := FND_API.G_RET_STS_ERROR;
5608: RETURN;

Line 5605: FND_MESSAGE.SET_TOKEN('FROMID',p_from_id);

5601: l_request_id <> hz_utility_pub.request_id THEN
5602: CLOSE c_check_valid_merge;
5603:
5604: FND_MESSAGE.SET_NAME('AR', 'HZ_RELN_TRANSFER_NOT_ALLOWED');
5605: FND_MESSAGE.SET_TOKEN('FROMID',p_from_id);
5606: FND_MSG_PUB.ADD;
5607: x_return_status := FND_API.G_RET_STS_ERROR;
5608: RETURN;
5609: END IF;

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

5799: END IF; --l_self_rel_flag
5800:
5801: EXCEPTION
5802: WHEN OTHERS THEN
5803: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
5804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5805: FND_MSG_PUB.ADD;
5806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5807:

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

5800:
5801: EXCEPTION
5802: WHEN OTHERS THEN
5803: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
5804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5805: FND_MSG_PUB.ADD;
5806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5807:
5808: END;

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

5814: END IF;
5815:
5816: EXCEPTION
5817: WHEN OTHERS THEN
5818: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
5819: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5820: FND_MSG_PUB.ADD;
5821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5822: END do_party_reln_subj_merge;

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

5815:
5816: EXCEPTION
5817: WHEN OTHERS THEN
5818: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
5819: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5820: FND_MSG_PUB.ADD;
5821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5822: END do_party_reln_subj_merge;
5823:

Line 5849: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_MERGE_TO_PRELN');

5845: OPEN c_merge_to_party_reln;
5846: FETCH c_merge_to_party_reln INTO l_to_preln_id;
5847: IF c_merge_to_party_reln%NOTFOUND THEN
5848: CLOSE c_merge_to_party_reln;
5849: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_MERGE_TO_PRELN');
5850: FND_MESSAGE.SET_TOKEN('TOPARTYID',p_to_fk_id);
5851: FND_MSG_PUB.ADD;
5852: x_return_status := FND_API.G_RET_STS_ERROR;
5853: ELSE

Line 5850: FND_MESSAGE.SET_TOKEN('TOPARTYID',p_to_fk_id);

5846: FETCH c_merge_to_party_reln INTO l_to_preln_id;
5847: IF c_merge_to_party_reln%NOTFOUND THEN
5848: CLOSE c_merge_to_party_reln;
5849: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_MERGE_TO_PRELN');
5850: FND_MESSAGE.SET_TOKEN('TOPARTYID',p_to_fk_id);
5851: FND_MSG_PUB.ADD;
5852: x_return_status := FND_API.G_RET_STS_ERROR;
5853: ELSE
5854: CLOSE c_merge_to_party_reln;

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

5878: x_to_id := l_to_preln_id;
5879: END IF;
5880: EXCEPTION
5881: WHEN OTHERS THEN
5882: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
5883: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5884: FND_MSG_PUB.ADD;
5885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5886: END do_party_relationship_merge;

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

5879: END IF;
5880: EXCEPTION
5881: WHEN OTHERS THEN
5882: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
5883: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5884: FND_MSG_PUB.ADD;
5885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5886: END do_party_relationship_merge;
5887:

Line 5943: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_MERGE_TO_ORGPRO');

5939: OPEN c_merge_to_org_prof('SST');
5940: FETCH c_merge_to_org_prof INTO x_to_id, l_to_last_upd_date, l_to_duns_number;
5941: IF c_merge_to_org_prof%NOTFOUND THEN
5942: CLOSE c_merge_to_org_prof;
5943: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_MERGE_TO_ORGPRO');
5944: FND_MESSAGE.SET_TOKEN('ToId',p_to_fk_id);
5945: FND_MSG_PUB.ADD;
5946: x_return_status := FND_API.G_RET_STS_ERROR;
5947: RETURN;

Line 5944: FND_MESSAGE.SET_TOKEN('ToId',p_to_fk_id);

5940: FETCH c_merge_to_org_prof INTO x_to_id, l_to_last_upd_date, l_to_duns_number;
5941: IF c_merge_to_org_prof%NOTFOUND THEN
5942: CLOSE c_merge_to_org_prof;
5943: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_MERGE_TO_ORGPRO');
5944: FND_MESSAGE.SET_TOKEN('ToId',p_to_fk_id);
5945: FND_MSG_PUB.ADD;
5946: x_return_status := FND_API.G_RET_STS_ERROR;
5947: RETURN;
5948: END IF;

Line 5963: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_MERGE_TO_ORGPRO');

5959: OPEN c_merge_to_org_prof('USER_ENTERED');
5960: FETCH c_merge_to_org_prof INTO x_to_id, l_to_last_upd_date, l_to_duns_number;
5961: IF c_merge_to_org_prof%NOTFOUND THEN
5962: CLOSE c_merge_to_org_prof;
5963: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_MERGE_TO_ORGPRO');
5964: FND_MESSAGE.SET_TOKEN('ToId',p_to_fk_id);
5965: FND_MSG_PUB.ADD;
5966: x_return_status := FND_API.G_RET_STS_ERROR;
5967: RETURN;

Line 5964: FND_MESSAGE.SET_TOKEN('ToId',p_to_fk_id);

5960: FETCH c_merge_to_org_prof INTO x_to_id, l_to_last_upd_date, l_to_duns_number;
5961: IF c_merge_to_org_prof%NOTFOUND THEN
5962: CLOSE c_merge_to_org_prof;
5963: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_MERGE_TO_ORGPRO');
5964: FND_MESSAGE.SET_TOKEN('ToId',p_to_fk_id);
5965: FND_MSG_PUB.ADD;
5966: x_return_status := FND_API.G_RET_STS_ERROR;
5967: RETURN;
5968: END IF;

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

6017: WHERE organization_profile_id = p_from_id;
6018:
6019: EXCEPTION
6020: WHEN OTHERS THEN
6021: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6022: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6023: FND_MSG_PUB.ADD;
6024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6025: END do_org_profile_merge;

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

6018:
6019: EXCEPTION
6020: WHEN OTHERS THEN
6021: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6022: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6023: FND_MSG_PUB.ADD;
6024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6025: END do_org_profile_merge;
6026:

Line 6061: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_MERGE_TO_PERPRO');

6057: FETCH c_merge_to_per_prof INTO l_to_perpro_id;
6058: IF c_merge_to_per_prof%NOTFOUND THEN
6059: CLOSE c_merge_to_per_prof;
6060: IF l_cont_source = 'USER_ENTERED' THEN
6061: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_MERGE_TO_PERPRO');
6062: FND_MESSAGE.SET_TOKEN('ToId',p_to_fk_id);
6063: FND_MSG_PUB.ADD;
6064: x_return_status := FND_API.G_RET_STS_ERROR;
6065: ELSE

Line 6062: FND_MESSAGE.SET_TOKEN('ToId',p_to_fk_id);

6058: IF c_merge_to_per_prof%NOTFOUND THEN
6059: CLOSE c_merge_to_per_prof;
6060: IF l_cont_source = 'USER_ENTERED' THEN
6061: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_MERGE_TO_PERPRO');
6062: FND_MESSAGE.SET_TOKEN('ToId',p_to_fk_id);
6063: FND_MSG_PUB.ADD;
6064: x_return_status := FND_API.G_RET_STS_ERROR;
6065: ELSE
6066: UPDATE HZ_PERSON_PROFILES

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

6095: x_to_id := l_to_perpro_id;
6096: END IF;
6097: EXCEPTION
6098: WHEN OTHERS THEN
6099: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6100: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6101: FND_MSG_PUB.ADD;
6102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6103: END do_per_profile_merge;

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

6096: END IF;
6097: EXCEPTION
6098: WHEN OTHERS THEN
6099: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6100: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6101: FND_MSG_PUB.ADD;
6102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6103: END do_per_profile_merge;
6104:

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

6266: x_to_id := l_to_id;
6267: END IF;
6268:
6269: WHEN OTHERS THEN
6270: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6271: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6272: FND_MSG_PUB.ADD;
6273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6274:

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

6267: END IF;
6268:
6269: WHEN OTHERS THEN
6270: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6271: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6272: FND_MSG_PUB.ADD;
6273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6274:
6275: -- End changes for Bug 4577535

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

6413: x_return_status => x_return_status,
6414: x_msg_count =>l_msg_count,
6415: x_msg_data =>l_msg_data);
6416: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6417: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6418: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
6419: FND_MSG_PUB.ADD;
6420: x_return_status := FND_API.G_RET_STS_ERROR;
6421: RETURN;

Line 6418: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');

6414: x_msg_count =>l_msg_count,
6415: x_msg_data =>l_msg_data);
6416: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6417: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6418: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
6419: FND_MSG_PUB.ADD;
6420: x_return_status := FND_API.G_RET_STS_ERROR;
6421: RETURN;
6422: END IF;

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

6439: x_msg_count => l_msg_count,
6440: x_msg_data => l_msg_data );
6441:
6442: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6443: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6444: FND_MESSAGE.SET_TOKEN('ERROR','Cannot get party site ID : ' || p_from_id);
6445: FND_MSG_PUB.ADD;
6446: x_return_status := FND_API.G_RET_STS_ERROR;
6447:

Line 6444: FND_MESSAGE.SET_TOKEN('ERROR','Cannot get party site ID : ' || p_from_id);

6440: x_msg_data => l_msg_data );
6441:
6442: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6443: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6444: FND_MESSAGE.SET_TOKEN('ERROR','Cannot get party site ID : ' || p_from_id);
6445: FND_MSG_PUB.ADD;
6446: x_return_status := FND_API.G_RET_STS_ERROR;
6447:
6448: RETURN;

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

6495: x_return_status => x_return_status,
6496: x_msg_count =>l_msg_count,
6497: x_msg_data =>l_msg_data);
6498: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6499: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6500: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
6501: FND_MSG_PUB.ADD;
6502: x_return_status := FND_API.G_RET_STS_ERROR;
6503: RETURN;

Line 6500: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');

6496: x_msg_count =>l_msg_count,
6497: x_msg_data =>l_msg_data);
6498: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6499: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6500: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
6501: FND_MSG_PUB.ADD;
6502: x_return_status := FND_API.G_RET_STS_ERROR;
6503: RETURN;
6504: END IF;*/

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

6523: x_msg_data => l_msg_data );
6524:
6525:
6526: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6527: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6528: FND_MESSAGE.SET_TOKEN('ERROR','Cannot copy party site for ID : ' || p_from_id);
6529: FND_MSG_PUB.ADD;
6530: x_return_status := FND_API.G_RET_STS_ERROR;
6531: RETURN;

Line 6528: FND_MESSAGE.SET_TOKEN('ERROR','Cannot copy party site for ID : ' || p_from_id);

6524:
6525:
6526: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6527: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6528: FND_MESSAGE.SET_TOKEN('ERROR','Cannot copy party site for ID : ' || p_from_id);
6529: FND_MSG_PUB.ADD;
6530: x_return_status := FND_API.G_RET_STS_ERROR;
6531: RETURN;
6532: END IF;

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

6543: x_return_status => x_return_status,
6544: x_msg_count =>l_msg_count,
6545: x_msg_data =>l_msg_data);
6546: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6547: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6548: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
6549: FND_MSG_PUB.ADD;
6550: x_return_status := FND_API.G_RET_STS_ERROR;
6551: RETURN;

Line 6548: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');

6544: x_msg_count =>l_msg_count,
6545: x_msg_data =>l_msg_data);
6546: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6547: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6548: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
6549: FND_MSG_PUB.ADD;
6550: x_return_status := FND_API.G_RET_STS_ERROR;
6551: RETURN;
6552: END IF;

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

6576: AND ENTITY = 'PARTY_SITES' AND STAGED_FLAG='N';
6577:
6578: EXCEPTION
6579: WHEN OTHERS THEN
6580: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6581: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6582: FND_MSG_PUB.ADD;
6583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6584: END do_party_site_merge;

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

6577:
6578: EXCEPTION
6579: WHEN OTHERS THEN
6580: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6581: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6582: FND_MSG_PUB.ADD;
6583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6584: END do_party_site_merge;
6585:

Line 6670: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_PARTIES');

6666: CLOSE c_party_type;
6667:
6668: IF l_from_party_type IS NULL OR l_to_party_type IS NULL OR
6669: l_to_party_type <> l_from_party_type THEN
6670: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_PARTIES');
6671: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6672: FND_MSG_PUB.ADD;
6673: x_return_status := FND_API.G_RET_STS_ERROR;
6674: RETURN;

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

6667:
6668: IF l_from_party_type IS NULL OR l_to_party_type IS NULL OR
6669: l_to_party_type <> l_from_party_type THEN
6670: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_PARTIES');
6671: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6672: FND_MSG_PUB.ADD;
6673: x_return_status := FND_API.G_RET_STS_ERROR;
6674: RETURN;
6675: END IF;

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

6703: x_return_status => x_return_status,
6704: x_msg_count =>l_msg_count,
6705: x_msg_data =>l_msg_data);
6706: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6707: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6708: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
6709: FND_MSG_PUB.ADD;
6710: x_return_status := FND_API.G_RET_STS_ERROR;
6711: RETURN;

Line 6708: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');

6704: x_msg_count =>l_msg_count,
6705: x_msg_data =>l_msg_data);
6706: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6707: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6708: FND_MESSAGE.SET_TOKEN('ERROR','MOSR: cannot remap internal ID');
6709: FND_MSG_PUB.ADD;
6710: x_return_status := FND_API.G_RET_STS_ERROR;
6711: RETURN;
6712: END IF;

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

6712: END IF;
6713:
6714: EXCEPTION
6715: WHEN OTHERS THEN
6716: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6717: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6718: FND_MSG_PUB.ADD;
6719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6720:

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

6713:
6714: EXCEPTION
6715: WHEN OTHERS THEN
6716: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6717: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6718: FND_MSG_PUB.ADD;
6719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6720:
6721: END do_party_merge;

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

6744:
6745:
6746: EXCEPTION
6747: WHEN OTHERS THEN
6748: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6749: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6750: FND_MSG_PUB.ADD;
6751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6752: END do_displayed_duns_merge;

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

6745:
6746: EXCEPTION
6747: WHEN OTHERS THEN
6748: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
6749: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6750: FND_MSG_PUB.ADD;
6751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6752: END do_displayed_duns_merge;
6753:

Line 6973: FND_MESSAGE.SET_NAME('AR', 'HZ_HIER_MERGE_ERROR');

6969: FETCH check_parent_exists INTO l_to_par_id;
6970: CLOSE check_parent_exists;
6971:
6972: IF l_from_par_id IS NOT NULL AND l_to_par_id IS NOT NULL AND l_from_par_id <> l_to_par_id THEN
6973: FND_MESSAGE.SET_NAME('AR', 'HZ_HIER_MERGE_ERROR');
6974: FND_MESSAGE.SET_TOKEN('PARTIES',p_from_fk_id||', '||p_to_fk_id);
6975: FND_MSG_PUB.ADD;
6976: x_return_status := FND_API.G_RET_STS_ERROR;
6977: return;

Line 6974: FND_MESSAGE.SET_TOKEN('PARTIES',p_from_fk_id||', '||p_to_fk_id);

6970: CLOSE check_parent_exists;
6971:
6972: IF l_from_par_id IS NOT NULL AND l_to_par_id IS NOT NULL AND l_from_par_id <> l_to_par_id THEN
6973: FND_MESSAGE.SET_NAME('AR', 'HZ_HIER_MERGE_ERROR');
6974: FND_MESSAGE.SET_TOKEN('PARTIES',p_from_fk_id||', '||p_to_fk_id);
6975: FND_MSG_PUB.ADD;
6976: x_return_status := FND_API.G_RET_STS_ERROR;
6977: return;
6978: END IF;

Line 6991: FND_MESSAGE.SET_NAME('AR', 'HZ_HIER_MERGE_ERROR');

6987: FETCH check_parent_exists INTO l_to_par_id;
6988: CLOSE check_parent_exists;
6989:
6990: IF l_from_par_id IS NOT NULL AND l_to_par_id IS NOT NULL AND l_from_par_id <> l_to_par_id THEN
6991: FND_MESSAGE.SET_NAME('AR', 'HZ_HIER_MERGE_ERROR');
6992: FND_MESSAGE.SET_TOKEN('PARTIES',p_from_fk_id||', '||p_to_fk_id);
6993: FND_MSG_PUB.ADD;
6994: x_return_status := FND_API.G_RET_STS_ERROR;
6995: return;

Line 6992: FND_MESSAGE.SET_TOKEN('PARTIES',p_from_fk_id||', '||p_to_fk_id);

6988: CLOSE check_parent_exists;
6989:
6990: IF l_from_par_id IS NOT NULL AND l_to_par_id IS NOT NULL AND l_from_par_id <> l_to_par_id THEN
6991: FND_MESSAGE.SET_NAME('AR', 'HZ_HIER_MERGE_ERROR');
6992: FND_MESSAGE.SET_TOKEN('PARTIES',p_from_fk_id||', '||p_to_fk_id);
6993: FND_MSG_PUB.ADD;
6994: x_return_status := FND_API.G_RET_STS_ERROR;
6995: return;
6996: END IF;