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_MSG_PUB

Line 429: FND_MSG_PUB.ADD;

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:
433: PROCEDURE org_profile_merge(

Line 471: FND_MSG_PUB.ADD;

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:
475: PROCEDURE party_relationship_merge(

Line 513: FND_MSG_PUB.ADD;

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:
517: PROCEDURE per_profile_merge(

Line 555: FND_MSG_PUB.ADD;

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:
559: --4307667

Line 599: FND_MSG_PUB.ADD;

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

Line 658: FND_MSG_PUB.ADD;

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:
662: PROCEDURE party_reln_object_merge(

Line 717: FND_MSG_PUB.ADD;

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:
721: PROCEDURE org_contact_merge(

Line 758: FND_MSG_PUB.ADD;

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:
762: PROCEDURE org_contact_merge2(

Line 815: FND_MSG_PUB.ADD;

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:
819: /*===========================================================================+

Line 898: FND_MSG_PUB.ADD;

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:
902: /*===========================================================================+

Line 975: FND_MSG_PUB.ADD;

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:
979: PROCEDURE cust_account_selling_merge(

Line 1027: FND_MSG_PUB.ADD;

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:
1031: PROCEDURE cust_account_role_merge(

Line 1074: FND_MSG_PUB.ADD;

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:
1078: PROCEDURE cust_account_site_merge(

Line 1123: FND_MSG_PUB.ADD;

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:
1127: /*===========================================================================+

Line 1201: FND_MSG_PUB.ADD;

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:
1205: /*===========================================================================+

Line 1294: FND_MSG_PUB.ADD;

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:
1298: /*===========================================================================+

Line 1373: FND_MSG_PUB.ADD;

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

Line 1453: FND_MSG_PUB.ADD;

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:
1457: PROCEDURE credit_ratings_merge(

Line 1502: FND_MSG_PUB.ADD;

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

Line 1553: FND_MSG_PUB.ADD;

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:
1557: PROCEDURE financial_reports_merge(

Line 1602: FND_MSG_PUB.ADD;

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

Line 1652: FND_MSG_PUB.ADD;

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:
1656: PROCEDURE org_ind_reference_merge(

Line 1701: FND_MSG_PUB.ADD;

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

Line 1751: FND_MSG_PUB.ADD;

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:
1755: PROCEDURE citizenship_merge(

Line 1800: FND_MSG_PUB.ADD;

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:
1804: PROCEDURE education_merge(

Line 1849: FND_MSG_PUB.ADD;

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:
1853: PROCEDURE education_school_merge(

Line 1898: FND_MSG_PUB.ADD;

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:
1902: PROCEDURE emp_history_merge(

Line 1947: FND_MSG_PUB.ADD;

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:
1951: PROCEDURE emp_history_employed_merge(

Line 1996: FND_MSG_PUB.ADD;

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:
2000: PROCEDURE work_class_merge(

Line 2045: FND_MSG_PUB.ADD;

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:
2049: PROCEDURE code_assignment_merge(

Line 2094: FND_MSG_PUB.ADD;

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:
2098: PROCEDURE code_assignment_merge2(

Line 2143: FND_MSG_PUB.ADD;

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:
2147: PROCEDURE org_contact_role_merge(

Line 2192: FND_MSG_PUB.ADD;

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:
2196: PROCEDURE financial_number_merge(

Line 2241: FND_MSG_PUB.ADD;

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:
2245: PROCEDURE per_languages_merge(

Line 2290: FND_MSG_PUB.ADD;

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:
2294: PROCEDURE party_site_use_merge(

Line 2339: FND_MSG_PUB.ADD;

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:
2343: PROCEDURE contact_point_merge2(

Line 2404: FND_MSG_PUB.ADD;

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:
2408: /*===========================================================================+

Line 2482: FND_MSG_PUB.ADD;

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:
2486: /*===========================================================================+

Line 2560: FND_MSG_PUB.ADD;

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

Line 2639: FND_MSG_PUB.ADD;

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

Line 2679: FND_MSG_PUB.ADD;

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

Line 2706: FND_MSG_PUB.ADD;

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:
2710: IF (p_from_id = FND_API.G_MISS_NUM) THEN

Line 2716: FND_MSG_PUB.ADD;

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:
2720: IF (p_exp_par_ent_name <> FND_API.G_MISS_CHAR AND

Line 2727: FND_MSG_PUB.ADD;

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
2731: WHEN OTHERS THEN

Line 2734: FND_MSG_PUB.ADD;

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:
2738: /***** Private Procedure *****/

Line 2779: FND_MSG_PUB.ADD;

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;
2783: ELSE

Line 2802: FND_MSG_PUB.ADD;

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:
2806: PROCEDURE do_cust_account_role_transfer(

Line 2871: FND_MSG_PUB.ADD;

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;
2875: ELSE

Line 2915: FND_MSG_PUB.ADD;

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:
2919: PROCEDURE do_fin_profile_transfer(

Line 2962: FND_MSG_PUB.ADD;

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:
2966: PROCEDURE do_contact_point_transfer(

Line 3040: FND_MSG_PUB.ADD;

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

Line 3132: FND_MSG_PUB.ADD;

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:
3136: PROCEDURE do_contact_point_transfer2(

Line 3197: FND_MSG_PUB.ADD;

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;
3201: ELSE

Line 3263: FND_MSG_PUB.ADD;

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:
3267: PROCEDURE do_contact_pref_transfer(

Line 3309: FND_MSG_PUB.ADD;

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:
3313: PROCEDURE do_references_transfer(

Line 3356: FND_MSG_PUB.ADD;

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:
3360: PROCEDURE do_certification_transfer(

Line 3403: FND_MSG_PUB.ADD;

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:
3407: PROCEDURE do_credit_ratings_transfer(

Line 3450: FND_MSG_PUB.ADD;

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:
3454: PROCEDURE do_security_issued_transfer(

Line 3497: FND_MSG_PUB.ADD;

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:
3501: PROCEDURE do_financial_reports_transfer(

Line 3544: FND_MSG_PUB.ADD;

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:
3548: PROCEDURE do_org_indicators_transfer(

Line 3591: FND_MSG_PUB.ADD;

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:
3595: PROCEDURE do_ind_reference_transfer(

Line 3638: FND_MSG_PUB.ADD;

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:
3642: PROCEDURE do_per_interest_transfer(

Line 3685: FND_MSG_PUB.ADD;

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:
3689: PROCEDURE do_citizenship_transfer(

Line 3732: FND_MSG_PUB.ADD;

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:
3736: PROCEDURE do_education_transfer(

Line 3779: FND_MSG_PUB.ADD;

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:
3783: PROCEDURE do_education_school_transfer(

Line 3826: FND_MSG_PUB.ADD;

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

Line 3874: FND_MSG_PUB.ADD;

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:
3878: PROCEDURE do_employed_transfer(

Line 3921: FND_MSG_PUB.ADD;

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

Line 3969: FND_MSG_PUB.ADD;

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:
3973: PROCEDURE do_org_contact_role_transfer(

Line 4023: FND_MSG_PUB.ADD;

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

Line 4098: FND_MSG_PUB.ADD;

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:
4102: PROCEDURE do_financial_number_transfer(

Line 4144: FND_MSG_PUB.ADD;

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:
4148: PROCEDURE do_code_assignment_transfer(

Line 4257: FND_MSG_PUB.ADD;

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:
4261: PROCEDURE do_code_assignment_transfer2(

Line 4355: FND_MSG_PUB.ADD;

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:
4359: PROCEDURE do_per_languages_transfer(

Line 4461: FND_MSG_PUB.ADD;

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:
4465: PROCEDURE do_party_site_use_transfer(

Line 4528: FND_MSG_PUB.ADD;

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;
4532: END IF;

Line 4564: FND_MSG_PUB.ADD;

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

Line 4590: FND_MSG_PUB.ADD;

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:
4594: PROCEDURE do_cust_account_site_transfer(

Line 4634: FND_MSG_PUB.ADD;

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

Line 4658: FND_MSG_PUB.ADD;

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:
4662: PROCEDURE do_org_contact_transfer(

Line 4705: FND_MSG_PUB.ADD;

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

Line 4729: FND_MSG_PUB.ADD;

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:
4733: PROCEDURE do_org_contact_transfer2(

Line 4878: FND_MSG_PUB.ADD;

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

Line 4891: FND_MSG_PUB.ADD;

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

Line 5027: FND_MSG_PUB.ADD;

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

Line 5141: FND_MSG_PUB.ADD;

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

Line 5207: FND_MSG_PUB.ADD;

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;
5211: CLOSE c_check_valid_merge;

Line 5407: FND_MSG_PUB.ADD;

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;
5411: END IF; --l_subject_id = p_to_fk_id

Line 5421: FND_MSG_PUB.ADD;

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:
5425: PROCEDURE do_party_reln_subj_merge(

Line 5535: FND_MSG_PUB.ADD;

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

Line 5606: FND_MSG_PUB.ADD;

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

Line 5805: FND_MSG_PUB.ADD;

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;
5809: END IF; --l_object_id = p_to_fk_id

Line 5820: FND_MSG_PUB.ADD;

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:
5824: PROCEDURE do_party_relationship_merge(

Line 5851: FND_MSG_PUB.ADD;

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

Line 5884: FND_MSG_PUB.ADD;

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:
5888: PROCEDURE do_org_profile_merge(

Line 5945: FND_MSG_PUB.ADD;

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;
5949: CLOSE c_merge_to_org_prof;

Line 5965: FND_MSG_PUB.ADD;

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;
5969: CLOSE c_merge_to_org_prof;

Line 6023: FND_MSG_PUB.ADD;

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:
6027: PROCEDURE do_per_profile_merge(

Line 6063: FND_MSG_PUB.ADD;

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
6067: SET

Line 6101: FND_MSG_PUB.ADD;

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:
6105: PROCEDURE do_party_site_merge(

Line 6272: FND_MSG_PUB.ADD;

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
6276: END;

Line 6419: FND_MSG_PUB.ADD;

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

Line 6445: FND_MSG_PUB.ADD;

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;
6449: END IF;

Line 6501: FND_MSG_PUB.ADD;

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;*/
6505:

Line 6529: FND_MSG_PUB.ADD;

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

Line 6549: FND_MSG_PUB.ADD;

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

Line 6582: FND_MSG_PUB.ADD;

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

Line 6672: FND_MSG_PUB.ADD;

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

Line 6709: FND_MSG_PUB.ADD;

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

Line 6718: FND_MSG_PUB.ADD;

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

Line 6750: FND_MSG_PUB.ADD;

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

Line 6975: FND_MSG_PUB.ADD;

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

Line 6993: FND_MSG_PUB.ADD;

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