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 HZ_MERGE_DUP_CHECK

Line 960: l_dup_exists := HZ_MERGE_DUP_CHECK.check_cust_account_dup(

956: 'HZ_MERGE_PKG.cust_account_merge',
957: 'HZ_CUST_ACCOUNTS','HZ_PARTIES',
958: 'CUST_ACCOUNT_ID', 'PARTY_ID',x_return_status);
959: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
960: l_dup_exists := HZ_MERGE_DUP_CHECK.check_cust_account_dup(
961: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
962: x_return_status);
963: END IF;
964:

Line 1060: l_dup_exists := HZ_MERGE_DUP_CHECK.check_cust_account_role_dup(

1056: 'HZ_MERGE_PKG.cust_account_role_merge',
1057: 'HZ_CUST_ACCOUNT_ROLES','HZ_PARTIES',
1058: 'CUST_ACCOUNT_ROLE_ID', 'PARTY_ID',x_return_status);
1059: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1060: l_dup_exists := HZ_MERGE_DUP_CHECK.check_cust_account_role_dup(
1061: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
1062: x_return_status);
1063: END IF;
1064: IF (x_return_status =FND_API.G_RET_STS_SUCCESS) THEN

Line 1108: l_dup_exists := HZ_MERGE_DUP_CHECK.check_cust_account_site_dup(

1104: 'HZ_CUST_ACCT_SITES_ALL','HZ_PARTY_SITES',
1105: 'CUST_ACCT_SITE_ID', 'PARTY_SITE_ID',x_return_status);
1106:
1107: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1108: l_dup_exists := HZ_MERGE_DUP_CHECK.check_cust_account_site_dup(
1109: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
1110: x_return_status);
1111: END IF;
1112:

Line 1186: l_dup_exists := HZ_MERGE_DUP_CHECK.check_financial_profile_dup(

1182: 'HZ_FINANCIAL_PROFILE','HZ_PARTIES',
1183: 'FINANCIAL_PROFILE_ID', 'PARTY_ID',x_return_status);
1184:
1185: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1186: l_dup_exists := HZ_MERGE_DUP_CHECK.check_financial_profile_dup(
1187: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
1188: x_return_status);
1189: END IF;
1190:

Line 1265: l_dup_exists := HZ_MERGE_DUP_CHECK.check_contact_point_dup(

1261: 'HZ_CONTACT_POINTS','HZ_PARTIES',
1262: 'CONTACT_POINT_ID', 'PARTY_ID',x_return_status);
1263:
1264: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1265: l_dup_exists := HZ_MERGE_DUP_CHECK.check_contact_point_dup(
1266: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
1267: 'HZ_PARTIES',x_return_status);
1268: END IF;
1269:

Line 1358: l_dup_exists := HZ_MERGE_DUP_CHECK.check_references_dup(

1354: 'HZ_REFERENCES','HZ_PARTIES',
1355: 'REFERENCE_ID', 'PARTY_ID',x_return_status);
1356:
1357: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1358: l_dup_exists := HZ_MERGE_DUP_CHECK.check_references_dup(
1359: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
1360: x_return_status);
1361: END IF;
1362:

Line 1438: l_dup_exists := HZ_MERGE_DUP_CHECK.check_certification_dup(

1434: 'HZ_CERTIFICATIONS','HZ_PARTIES',
1435: 'CERTIFICATION_ID', 'PARTY_ID',x_return_status);
1436:
1437: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1438: l_dup_exists := HZ_MERGE_DUP_CHECK.check_certification_dup(
1439: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
1440: x_return_status);
1441: END IF;
1442:

Line 1487: l_dup_exists := HZ_MERGE_DUP_CHECK.check_credit_ratings_dup(

1483: 'HZ_CREDIT_RATINGS','HZ_PARTIES',
1484: 'CREDIT_RATING_ID', 'PARTY_ID',x_return_status);
1485:
1486: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1487: l_dup_exists := HZ_MERGE_DUP_CHECK.check_credit_ratings_dup(
1488: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
1489: x_return_status);
1490: END IF;
1491:

Line 1538: l_dup_exists := HZ_MERGE_DUP_CHECK.check_security_issued_dup(

1534: 'SECURITY_ISSUED_ID', 'PARTY_ID',x_return_status);
1535:
1536: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1537:
1538: l_dup_exists := HZ_MERGE_DUP_CHECK.check_security_issued_dup(
1539: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
1540: x_return_status);
1541: END IF;
1542:

Line 1587: l_dup_exists := HZ_MERGE_DUP_CHECK.check_financial_reports_dup(

1583: 'HZ_FINANCIAL_REPORTS','HZ_PARTIES',
1584: 'FINANCIAL_REPORT_ID', 'PARTY_ID',x_return_status);
1585:
1586: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1587: l_dup_exists := HZ_MERGE_DUP_CHECK.check_financial_reports_dup(
1588: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
1589: x_return_status);
1590: END IF;
1591:

Line 1637: l_dup_exists := HZ_MERGE_DUP_CHECK.check_org_indicators_dup(

1633: 'HZ_ORGANIZATION_INDICATORS','HZ_PARTIES',
1634: 'ORGANIZATION_INDICATOR_ID', 'PARTY_ID',x_return_status);
1635:
1636: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1637: l_dup_exists := HZ_MERGE_DUP_CHECK.check_org_indicators_dup(
1638: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
1639: x_return_status);
1640: END IF;
1641:

Line 1686: l_dup_exists := HZ_MERGE_DUP_CHECK.check_ind_reference_dup(

1682: 'HZ_INDUSTRIAL_REFERENCE','HZ_PARTIES',
1683: 'INDUSTRY_REFERENCE_ID', 'PARTY_ID',x_return_status);
1684:
1685: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1686: l_dup_exists := HZ_MERGE_DUP_CHECK.check_ind_reference_dup(
1687: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
1688: x_return_status);
1689: END IF;
1690:

Line 1736: l_dup_exists := HZ_MERGE_DUP_CHECK.check_per_interest_dup(

1732: 'HZ_PERSON_INTEREST','HZ_PARTIES',
1733: 'PERSON_INTEREST_ID', 'PARTY_ID',x_return_status);
1734:
1735: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1736: l_dup_exists := HZ_MERGE_DUP_CHECK.check_per_interest_dup(
1737: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
1738: x_return_status);
1739: END IF;
1740:

Line 1785: l_dup_exists := HZ_MERGE_DUP_CHECK.check_citizenship_dup(

1781: 'HZ_CITIZENSHIP','HZ_PARTIES',
1782: 'CITIZENSHIP_ID', 'PARTY_ID',x_return_status);
1783:
1784: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1785: l_dup_exists := HZ_MERGE_DUP_CHECK.check_citizenship_dup(
1786: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
1787: x_return_status);
1788: END IF;
1789:

Line 1834: l_dup_exists := HZ_MERGE_DUP_CHECK.check_education_dup(

1830: 'HZ_EDUCATION','HZ_PARTIES',
1831: 'EDUCATION_ID', 'PARTY_ID',x_return_status);
1832:
1833: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1834: l_dup_exists := HZ_MERGE_DUP_CHECK.check_education_dup(
1835: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
1836: x_return_status);
1837: END IF;
1838:

Line 1883: l_dup_exists := HZ_MERGE_DUP_CHECK.check_education_dup(

1879: 'HZ_EDUCATION','HZ_PARTIES',
1880: 'EDUCATION_ID', 'SCHOOL_PARTY_ID',x_return_status);
1881:
1882: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1883: l_dup_exists := HZ_MERGE_DUP_CHECK.check_education_dup(
1884: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
1885: x_return_status);
1886: END IF;
1887:

Line 1932: l_dup_exists := HZ_MERGE_DUP_CHECK.check_emp_history_dup(

1928: 'HZ_EMPLOYMENT_HISTORY','HZ_PARTIES',
1929: 'EMPLOYMENT_HISTORY_ID', 'PARTY_ID',x_return_status);
1930:
1931: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1932: l_dup_exists := HZ_MERGE_DUP_CHECK.check_emp_history_dup(
1933: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
1934: x_return_status);
1935: END IF;
1936:

Line 1981: l_dup_exists := HZ_MERGE_DUP_CHECK.check_emp_history_dup(

1977: 'HZ_EMPLOYMENT_HISTORY','HZ_PARTIES',
1978: 'EMPLOYMENT_HISTORY_ID','EMPLOYED_BY_PARTY_ID',x_return_status);
1979:
1980: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1981: l_dup_exists := HZ_MERGE_DUP_CHECK.check_emp_history_dup(
1982: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
1983: x_return_status);
1984: END IF;
1985:

Line 2030: l_dup_exists := HZ_MERGE_DUP_CHECK.check_work_class_dup(

2026: 'HZ_WORK_CLASS', 'HZ_EMPLOYMENT_HISTORY',
2027: 'WORK_CLASS_ID', 'EMPLOYMENT_HISTORY_ID', x_return_status);
2028:
2029: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
2030: l_dup_exists := HZ_MERGE_DUP_CHECK.check_work_class_dup(
2031: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
2032: x_return_status);
2033: END IF;
2034:

Line 2079: l_dup_exists := HZ_MERGE_DUP_CHECK.check_code_assignment_dup(

2075: 'HZ_CODE_ASSIGNMENTS','HZ_PARTIES',
2076: 'CODE_ASSIGNMENT_ID', 'PARTY_ID',x_return_status);
2077:
2078: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
2079: l_dup_exists := HZ_MERGE_DUP_CHECK.check_code_assignment_dup(
2080: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
2081: 'HZ_PARTIES', x_return_status);
2082: END IF;
2083:

Line 2128: l_dup_exists := HZ_MERGE_DUP_CHECK.check_code_assignment_dup(

2124: 'HZ_CODE_ASSIGNMENTS','HZ_PARTY_SITES',
2125: 'CODE_ASSIGNMENT_ID', 'PARTY_SITE_ID',x_return_status);
2126:
2127: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
2128: l_dup_exists := HZ_MERGE_DUP_CHECK.check_code_assignment_dup(
2129: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
2130: 'HZ_PARTY_SITES', x_return_status);
2131: END IF;
2132:

Line 2177: l_dup_exists := HZ_MERGE_DUP_CHECK.check_org_contact_role_dup(

2173: 'HZ_ORG_CONTACT_ROLES','HZ_ORG_CONTACTS',
2174: 'ORG_CONTACT_ROLE_ID', 'ORG_CONTACT_ID',x_return_status);
2175:
2176: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
2177: l_dup_exists := HZ_MERGE_DUP_CHECK.check_org_contact_role_dup(
2178: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
2179: x_return_status);
2180: END IF;
2181:

Line 2226: l_dup_exists := HZ_MERGE_DUP_CHECK.check_financial_number_dup(

2222: 'HZ_FINANCIAL_NUMBERS','HZ_FINANCIAL_REPORTS',
2223: 'FINANCIAL_NUMBER_ID', 'FINANCIAL_REPORT_ID',x_return_status);
2224:
2225: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
2226: l_dup_exists := HZ_MERGE_DUP_CHECK.check_financial_number_dup(
2227: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
2228: x_return_status);
2229: END IF;
2230:

Line 2275: l_dup_exists := HZ_MERGE_DUP_CHECK.check_languages_dup(

2271: 'HZ_PERSON_LANGUAGE','HZ_PARTIES',
2272: 'LANGUAGE_USE_REFERENCE_ID', 'PARTY_ID',x_return_status);
2273:
2274: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
2275: l_dup_exists := HZ_MERGE_DUP_CHECK.check_languages_dup(
2276: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
2277: x_return_status);
2278: END IF;
2279:

Line 2324: l_dup_exists := HZ_MERGE_DUP_CHECK.check_party_site_use_dup(

2320: 'HZ_PARTY_SITE_USES','HZ_PARTY_SITES',
2321: 'PARTY_SITE_USE_ID', 'PARTY_SITE_ID',x_return_status);
2322:
2323: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
2324: l_dup_exists := HZ_MERGE_DUP_CHECK.check_party_site_use_dup(
2325: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
2326: x_return_status);
2327: END IF;
2328:

Line 2375: l_dup_exists := HZ_MERGE_DUP_CHECK.check_contact_point_dup(

2371: 'HZ_CONTACT_POINTS','HZ_PARTY_SITES',
2372: 'CONTACT_POINT_ID', 'PARTY_SITE_ID',x_return_status);
2373:
2374: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
2375: l_dup_exists := HZ_MERGE_DUP_CHECK.check_contact_point_dup(
2376: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
2377: 'HZ_PARTY_SITES', x_return_status);
2378: END IF;
2379:

Line 2467: l_dup_exists := HZ_MERGE_DUP_CHECK.check_contact_preference_dup(

2463: 'HZ_CONTACT_PREFERENCES','HZ_PARTIES',
2464: 'CONTACT_PREFERENCE_ID', 'PARTY_ID',x_return_status);
2465:
2466: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
2467: l_dup_exists := HZ_MERGE_DUP_CHECK.check_contact_preference_dup(
2468: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
2469: 'HZ_PARTIES',x_return_status);
2470: END IF;
2471:

Line 2545: l_dup_exists := HZ_MERGE_DUP_CHECK.check_contact_preference_dup(

2541: 'HZ_CONTACT_PREFERENCES','HZ_PARTY_SITES',
2542: 'CONTACT_PREFERENCE_ID', 'PARTY_SITE_ID',x_return_status);
2543:
2544: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
2545: l_dup_exists := HZ_MERGE_DUP_CHECK.check_contact_preference_dup(
2546: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
2547: 'HZ_PARTY_SITES',x_return_status);
2548: END IF;
2549:

Line 2624: l_dup_exists := HZ_MERGE_DUP_CHECK.check_contact_preference_dup(

2620: 'HZ_CONTACT_PREFERENCES','HZ_CONTACT_POINTS',
2621: 'CONTACT_PREFERENCE_ID', 'CONTACT_POINT_ID',x_return_status);
2622:
2623: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
2624: l_dup_exists := HZ_MERGE_DUP_CHECK.check_contact_preference_dup(
2625: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
2626: 'HZ_CONTACT_POINTS',x_return_status);
2627: END IF;
2628:

Line 6391: l_dup_exists := HZ_MERGE_DUP_CHECK.check_address_dup(

6387: WHEN NO_DATA_FOUND THEN
6388: --NULL;
6389: -- Start changes for Bug 4577535
6390:
6391: l_dup_exists := HZ_MERGE_DUP_CHECK.check_address_dup(
6392: l_from_location_id,l_to_id, p_from_fk_id, p_to_fk_id,
6393: x_return_status);
6394: /* Merge */
6395: IF l_dup_exists = FND_API.G_TRUE THEN