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

Line 100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

96:
97: exception
98: when others then
99: if (instrb(SQLERRM,'DRG-51030')>0) then
100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_ERROR;
103: elsif (instrb(SQLERRM,'DRG-50943')>0) then
104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_ERROR;
103: elsif (instrb(SQLERRM,'DRG-50943')>0) then
104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
105: FND_MSG_PUB.ADD;
106: RAISE FND_API.G_EXC_ERROR;
107: else
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 871: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

867: BEGIN
868: NULL ;
869: EXCEPTION
870: WHEN OTHERS THEN
871: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
872: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
873: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
874: FND_MSG_PUB.ADD;
875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 872: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');

868: NULL ;
869: EXCEPTION
870: WHEN OTHERS THEN
871: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
872: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
873: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
874: FND_MSG_PUB.ADD;
875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
876: END;

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

869: EXCEPTION
870: WHEN OTHERS THEN
871: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
872: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
873: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
874: FND_MSG_PUB.ADD;
875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
876: END;
877:

Line 891: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

887: BEGIN
888: NULL ;
889: EXCEPTION
890: WHEN OTHERS THEN
891: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
892: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
893: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
894: FND_MSG_PUB.ADD;
895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 892: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');

888: NULL ;
889: EXCEPTION
890: WHEN OTHERS THEN
891: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
892: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
893: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
894: FND_MSG_PUB.ADD;
895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
896: END;

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

889: EXCEPTION
890: WHEN OTHERS THEN
891: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
892: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
893: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
894: FND_MSG_PUB.ADD;
895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
896: END;
897:

Line 911: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

907: BEGIN
908: NULL ;
909: EXCEPTION
910: WHEN OTHERS THEN
911: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
912: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
913: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
914: FND_MSG_PUB.ADD;
915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 912: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');

908: NULL ;
909: EXCEPTION
910: WHEN OTHERS THEN
911: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
912: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
913: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
914: FND_MSG_PUB.ADD;
915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
916: END;

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

909: EXCEPTION
910: WHEN OTHERS THEN
911: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
912: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
913: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
914: FND_MSG_PUB.ADD;
915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
916: END;
917:

Line 931: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

927: BEGIN
928: NULL ;
929: EXCEPTION
930: WHEN OTHERS THEN
931: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
932: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
934: FND_MSG_PUB.ADD;
935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 932: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');

928: NULL ;
929: EXCEPTION
930: WHEN OTHERS THEN
931: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
932: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
934: FND_MSG_PUB.ADD;
935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
936: END;

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

929: EXCEPTION
930: WHEN OTHERS THEN
931: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
932: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
934: FND_MSG_PUB.ADD;
935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
936: END;
937:

Line 1000: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');

996: IF NOT check_prim_cond (p_party_search_rec,
997: p_party_site_list,
998: p_contact_list,
999: p_contact_point_list) THEN
1000: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1001: FND_MSG_PUB.ADD;
1002: RAISE FND_API.G_EXC_ERROR;
1003: END IF;
1004: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1240: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

1236: ELSE
1237: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1238: END IF;
1239: IF lengthb(l_party_contains_str) > 4000 THEN
1240: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1241: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1242: FND_MSG_PUB.ADD;
1243: RAISE FND_API.G_EXC_ERROR;
1244: END IF;

Line 1241: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

1237: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1238: END IF;
1239: IF lengthb(l_party_contains_str) > 4000 THEN
1240: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1241: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1242: FND_MSG_PUB.ADD;
1243: RAISE FND_API.G_EXC_ERROR;
1244: END IF;
1245: IF (p_match_str = ' AND ' OR p_party_max_score

Line 1329: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

1325: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1326: END LOOP;
1327: -- Add the search criteria to query string
1328: IF lengthb(l_contains_str) > 4000 THEN
1329: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1330: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1331: FND_MSG_PUB.ADD;
1332: RAISE FND_API.G_EXC_ERROR;
1333: END IF;

Line 1330: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');

1326: END LOOP;
1327: -- Add the search criteria to query string
1328: IF lengthb(l_contains_str) > 4000 THEN
1329: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1330: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1331: FND_MSG_PUB.ADD;
1332: RAISE FND_API.G_EXC_ERROR;
1333: END IF;
1334: x_denorm_str := l_den_contains_str;

Line 1373: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

1369: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1370: END LOOP;
1371: -- Add the search criteria to query string
1372: IF lengthb(l_contains_str) > 4000 THEN
1373: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1374: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1375: FND_MSG_PUB.ADD;
1376: RAISE FND_API.G_EXC_ERROR;
1377: END IF;

Line 1374: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');

1370: END LOOP;
1371: -- Add the search criteria to query string
1372: IF lengthb(l_contains_str) > 4000 THEN
1373: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1374: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1375: FND_MSG_PUB.ADD;
1376: RAISE FND_API.G_EXC_ERROR;
1377: END IF;
1378: x_denorm_str := l_den_contains_str;

Line 1461: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

1457: END IF;
1458: END LOOP;
1459: -- Add the search criteria to query string
1460: IF lengthb(l_contains_str) > 4000 THEN
1461: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1462: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1463: FND_MSG_PUB.ADD;
1464: RAISE FND_API.G_EXC_ERROR;
1465: END IF;

Line 1462: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');

1458: END LOOP;
1459: -- Add the search criteria to query string
1460: IF lengthb(l_contains_str) > 4000 THEN
1461: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1462: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1463: FND_MSG_PUB.ADD;
1464: RAISE FND_API.G_EXC_ERROR;
1465: END IF;
1466: x_denorm_str := l_den_contains_str;

Line 1701: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

1697: END IF;
1698: exception
1699: when others then
1700: if (instrb(SQLERRM,'DRG-51030')>0) then
1701: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1702: FND_MSG_PUB.ADD;
1703: RAISE FND_API.G_EXC_ERROR;
1704: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1705: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1705: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1701: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1702: FND_MSG_PUB.ADD;
1703: RAISE FND_API.G_EXC_ERROR;
1704: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1705: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1706: FND_MSG_PUB.ADD;
1707: RAISE FND_API.G_EXC_ERROR;
1708: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1709: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1709: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1705: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1706: FND_MSG_PUB.ADD;
1707: RAISE FND_API.G_EXC_ERROR;
1708: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1709: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1710: FND_MSG_PUB.ADD;
1711: RAISE FND_API.G_EXC_ERROR;
1712: else
1713: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 1713: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1709: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1710: FND_MSG_PUB.ADD;
1711: RAISE FND_API.G_EXC_ERROR;
1712: else
1713: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1714: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1715: FND_MSG_PUB.ADD;
1716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1717: end if;

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

1710: FND_MSG_PUB.ADD;
1711: RAISE FND_API.G_EXC_ERROR;
1712: else
1713: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1714: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1715: FND_MSG_PUB.ADD;
1716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1717: end if;
1718: END;

Line 1946: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

1942: output_long_strings('Restrict Sql = '||p_restrict_sql);
1943: exception
1944: when others then
1945: if (instrb(SQLERRM,'DRG-51030')>0) then
1946: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1947: FND_MSG_PUB.ADD;
1948: RAISE FND_API.G_EXC_ERROR;
1949: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1946: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1947: FND_MSG_PUB.ADD;
1948: RAISE FND_API.G_EXC_ERROR;
1949: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1951: FND_MSG_PUB.ADD;
1952: RAISE FND_API.G_EXC_ERROR;
1953: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1954: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1954: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1951: FND_MSG_PUB.ADD;
1952: RAISE FND_API.G_EXC_ERROR;
1953: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1954: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1955: FND_MSG_PUB.ADD;
1956: RAISE FND_API.G_EXC_ERROR;
1957: else
1958: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 1958: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1954: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1955: FND_MSG_PUB.ADD;
1956: RAISE FND_API.G_EXC_ERROR;
1957: else
1958: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1959: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1960: FND_MSG_PUB.ADD;
1961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1962: end if;

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

1955: FND_MSG_PUB.ADD;
1956: RAISE FND_API.G_EXC_ERROR;
1957: else
1958: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1959: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1960: FND_MSG_PUB.ADD;
1961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1962: end if;
1963: END;

Line 2093: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

2089: output_long_strings('Restrict Sql = '||p_restrict_sql);
2090: exception
2091: when others then
2092: if (instrb(SQLERRM,'DRG-51030')>0) then
2093: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2094: FND_MSG_PUB.ADD;
2095: RAISE FND_API.G_EXC_ERROR;
2096: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2097: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 2097: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

2093: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2094: FND_MSG_PUB.ADD;
2095: RAISE FND_API.G_EXC_ERROR;
2096: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2097: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2098: FND_MSG_PUB.ADD;
2099: RAISE FND_API.G_EXC_ERROR;
2100: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2101: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 2101: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

2097: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2098: FND_MSG_PUB.ADD;
2099: RAISE FND_API.G_EXC_ERROR;
2100: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2101: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2102: FND_MSG_PUB.ADD;
2103: RAISE FND_API.G_EXC_ERROR;
2104: else
2105: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 2105: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

2101: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2102: FND_MSG_PUB.ADD;
2103: RAISE FND_API.G_EXC_ERROR;
2104: else
2105: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2107: FND_MSG_PUB.ADD;
2108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2109: end if;

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

2102: FND_MSG_PUB.ADD;
2103: RAISE FND_API.G_EXC_ERROR;
2104: else
2105: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2107: FND_MSG_PUB.ADD;
2108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2109: end if;
2110: END;

Line 2366: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

2362: output_long_strings('Restrict Sql = '||p_restrict_sql);
2363: exception
2364: when others then
2365: if (instrb(SQLERRM,'DRG-51030')>0) then
2366: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2367: FND_MSG_PUB.ADD;
2368: RAISE FND_API.G_EXC_ERROR;
2369: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2370: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 2370: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

2366: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2367: FND_MSG_PUB.ADD;
2368: RAISE FND_API.G_EXC_ERROR;
2369: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2370: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2371: FND_MSG_PUB.ADD;
2372: RAISE FND_API.G_EXC_ERROR;
2373: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2374: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 2374: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

2370: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2371: FND_MSG_PUB.ADD;
2372: RAISE FND_API.G_EXC_ERROR;
2373: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2374: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2375: FND_MSG_PUB.ADD;
2376: RAISE FND_API.G_EXC_ERROR;
2377: else
2378: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 2378: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

2374: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2375: FND_MSG_PUB.ADD;
2376: RAISE FND_API.G_EXC_ERROR;
2377: else
2378: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2379: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2380: FND_MSG_PUB.ADD;
2381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2382: end if;

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

2375: FND_MSG_PUB.ADD;
2376: RAISE FND_API.G_EXC_ERROR;
2377: else
2378: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2379: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2380: FND_MSG_PUB.ADD;
2381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2382: end if;
2383: END;

Line 2636: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2632: IF p_index>1 THEN
2633: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2634: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2635: END IF;
2636: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2637: FND_MSG_PUB.ADD;
2638: RAISE FND_API.G_EXC_ERROR;
2639: ELSE
2640: push_eval;

Line 2684: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2680: IF p_index>1 THEN
2681: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2682: hz_utility_v2pub.debug(p_message=>'In eval party level estimated hits exceed threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2683: END IF;
2684: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2685: FND_MSG_PUB.ADD;
2686: RAISE FND_API.G_EXC_ERROR;
2687: ELSE
2688: push_eval;

Line 2757: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2753: IF p_index>1 THEN
2754: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2755: hz_utility_v2pub.debug(p_message=>'In eval party site level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2756: END IF;
2757: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2758: FND_MSG_PUB.ADD;
2759: RAISE FND_API.G_EXC_ERROR;
2760: ELSE
2761: push_eval;

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

2865: IF p_index>1 THEN
2866: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2867: hz_utility_v2pub.debug(p_message=>'In eval contact level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2868: END IF;
2869: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2870: FND_MSG_PUB.ADD;
2871: RAISE FND_API.G_EXC_ERROR;
2872: ELSE
2873: push_eval;

Line 2980: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2976: IF p_index>1 THEN
2977: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2978: hz_utility_v2pub.debug(p_message=>'In eval contact point level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2979: END IF;
2980: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2981: FND_MSG_PUB.ADD;
2982: RAISE FND_API.G_EXC_ERROR;
2983: ELSE
2984: push_eval;

Line 3205: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3201: ELSE
3202: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3203: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3204: END IF;
3205: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3206: FND_MSG_PUB.ADD;
3207: RAISE FND_API.G_EXC_ERROR;
3208: END IF;
3209: ELSE

Line 3213: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3209: ELSE
3210: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3211: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3212: END IF;
3213: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3214: FND_MSG_PUB.ADD;
3215: RAISE FND_API.G_EXC_ERROR;
3216: END IF;
3217: END IF;

Line 3419: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

3415: RAISE FND_API.G_EXC_ERROR;
3416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3418: WHEN OTHERS THEN
3419: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3420: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_parties');
3421: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3422: FND_MSG_PUB.ADD;
3423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3420: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_parties');

3416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3418: WHEN OTHERS THEN
3419: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3420: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_parties');
3421: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3422: FND_MSG_PUB.ADD;
3423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3424: END find_parties;

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

3417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3418: WHEN OTHERS THEN
3419: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3420: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_parties');
3421: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3422: FND_MSG_PUB.ADD;
3423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3424: END find_parties;
3425:

Line 3618: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3614: IF p_index>1 THEN
3615: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3616: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3617: END IF;
3618: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3619: FND_MSG_PUB.ADD;
3620: RAISE FND_API.G_EXC_ERROR;
3621: ELSE
3622: push_eval;

Line 3666: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3662: IF p_index>1 THEN
3663: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3664: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3665: END IF;
3666: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3667: FND_MSG_PUB.ADD;
3668: RAISE FND_API.G_EXC_ERROR;
3669: ELSE
3670: push_eval;

Line 3702: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

3698: and d.search_context_id = p_search_ctx_id);
3699: exception
3700: when others then
3701: if (instrb(SQLERRM,'DRG-51030')>0) then
3702: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3703: FND_MSG_PUB.ADD;
3704: RAISE FND_API.G_EXC_ERROR;
3705: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3706: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 3706: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

3702: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3703: FND_MSG_PUB.ADD;
3704: RAISE FND_API.G_EXC_ERROR;
3705: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3706: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3707: FND_MSG_PUB.ADD;
3708: RAISE FND_API.G_EXC_ERROR;
3709: else
3710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3778: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3774: IF p_index>1 THEN
3775: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3776: hz_utility_v2pub.debug(p_message=>'In eval party site level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3777: END IF;
3778: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3779: FND_MSG_PUB.ADD;
3780: RAISE FND_API.G_EXC_ERROR;
3781: ELSE
3782: push_eval;

Line 4037: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

4033: IF p_index>1 THEN
4034: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4035: hz_utility_v2pub.debug(p_message=>'In eval contact point level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4036: END IF;
4037: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4038: FND_MSG_PUB.ADD;
4039: RAISE FND_API.G_EXC_ERROR;
4040: ELSE
4041: push_eval;

Line 4150: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

4146: ELSE
4147: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4148: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4149: END IF;
4150: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4151: FND_MSG_PUB.ADD;
4152: RAISE FND_API.G_EXC_ERROR;
4153: END IF;
4154: ELSE

Line 4158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

4154: ELSE
4155: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4156: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
4157: END IF;
4158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4159: FND_MSG_PUB.ADD;
4160: RAISE FND_API.G_EXC_ERROR;
4161: END IF;
4162: END IF;

Line 4279: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

4275: RAISE FND_API.G_EXC_ERROR;
4276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4278: WHEN OTHERS THEN
4279: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4280: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_persons');
4281: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4282: FND_MSG_PUB.ADD;
4283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4280: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_persons');

4276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4278: WHEN OTHERS THEN
4279: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4280: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_persons');
4281: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4282: FND_MSG_PUB.ADD;
4283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4284: END find_persons;

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

4277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4278: WHEN OTHERS THEN
4279: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4280: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_persons');
4281: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4282: FND_MSG_PUB.ADD;
4283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4284: END find_persons;
4285:

Line 4347: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

4343: RAISE FND_API.G_EXC_ERROR;
4344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4346: WHEN OTHERS THEN
4347: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4348: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_party_details');
4349: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4350: FND_MSG_PUB.ADD;
4351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4348: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_party_details');

4344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4346: WHEN OTHERS THEN
4347: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4348: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_party_details');
4349: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4350: FND_MSG_PUB.ADD;
4351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4352: END find_party_details;

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

4345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4346: WHEN OTHERS THEN
4347: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4348: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_party_details');
4349: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4350: FND_MSG_PUB.ADD;
4351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4352: END find_party_details;
4353:

Line 4464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

4460: RAISE FND_API.G_EXC_ERROR;
4461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4463: WHEN OTHERS THEN
4464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4465: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_parties');
4466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4467: FND_MSG_PUB.ADD;
4468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4465: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_parties');

4461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4463: WHEN OTHERS THEN
4464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4465: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_parties');
4466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4467: FND_MSG_PUB.ADD;
4468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4469: END find_duplicate_parties;

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

4462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4463: WHEN OTHERS THEN
4464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4465: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_parties');
4466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4467: FND_MSG_PUB.ADD;
4468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4469: END find_duplicate_parties;
4470:

Line 4549: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

4545: RAISE FND_API.G_EXC_ERROR;
4546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4548: WHEN OTHERS THEN
4549: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4550: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_party_sites');
4551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4552: FND_MSG_PUB.ADD;
4553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4550: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_party_sites');

4546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4548: WHEN OTHERS THEN
4549: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4550: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_party_sites');
4551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4552: FND_MSG_PUB.ADD;
4553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4554: END find_duplicate_party_sites;

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

4547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4548: WHEN OTHERS THEN
4549: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4550: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_party_sites');
4551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4552: FND_MSG_PUB.ADD;
4553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4554: END find_duplicate_party_sites;
4555:

Line 4638: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

4634: RAISE FND_API.G_EXC_ERROR;
4635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4637: WHEN OTHERS THEN
4638: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4639: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_contacts');
4640: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4641: FND_MSG_PUB.ADD;
4642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4639: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_contacts');

4635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4637: WHEN OTHERS THEN
4638: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4639: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_contacts');
4640: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4641: FND_MSG_PUB.ADD;
4642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4643: END find_duplicate_contacts;

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

4636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4637: WHEN OTHERS THEN
4638: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4639: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_contacts');
4640: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4641: FND_MSG_PUB.ADD;
4642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4643: END find_duplicate_contacts;
4644:

Line 4711: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

4707: RAISE FND_API.G_EXC_ERROR;
4708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4710: WHEN OTHERS THEN
4711: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4712: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_contact_points');
4713: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4714: FND_MSG_PUB.ADD;
4715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4712: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_contact_points');

4708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4710: WHEN OTHERS THEN
4711: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4712: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_contact_points');
4713: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4714: FND_MSG_PUB.ADD;
4715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4716: END find_duplicate_contact_points;

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

4709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4710: WHEN OTHERS THEN
4711: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4712: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_contact_points');
4713: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4714: FND_MSG_PUB.ADD;
4715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4716: END find_duplicate_contact_points;
4717:

Line 5064: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5060: RAISE FND_API.G_EXC_ERROR;
5061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5063: WHEN OTHERS THEN
5064: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5065: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.call_api_dynamic');
5066: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5067: FND_MSG_PUB.ADD;
5068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5065: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.call_api_dynamic');

5061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5063: WHEN OTHERS THEN
5064: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5065: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.call_api_dynamic');
5066: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5067: FND_MSG_PUB.ADD;
5068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5069: END call_api_dynamic;

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

5062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5063: WHEN OTHERS THEN
5064: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5065: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.call_api_dynamic');
5066: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5067: FND_MSG_PUB.ADD;
5068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5069: END call_api_dynamic;
5070:

Line 5307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5303: RAISE FND_API.G_EXC_ERROR;
5304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5306: WHEN OTHERS THEN
5307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5308: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_matching_party_sites');
5309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5310: FND_MSG_PUB.ADD;
5311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5308: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_matching_party_sites');

5304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5306: WHEN OTHERS THEN
5307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5308: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_matching_party_sites');
5309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5310: FND_MSG_PUB.ADD;
5311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5312: END get_matching_party_sites;

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

5305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5306: WHEN OTHERS THEN
5307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5308: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_matching_party_sites');
5309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5310: FND_MSG_PUB.ADD;
5311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5312: END get_matching_party_sites;
5313:

Line 5536: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5532: RAISE FND_API.G_EXC_ERROR;
5533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5535: WHEN OTHERS THEN
5536: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5537: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_matching_contacts');
5538: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5539: FND_MSG_PUB.ADD;
5540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5537: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_matching_contacts');

5533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5535: WHEN OTHERS THEN
5536: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5537: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_matching_contacts');
5538: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5539: FND_MSG_PUB.ADD;
5540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5541: END get_matching_contacts;

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

5534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5535: WHEN OTHERS THEN
5536: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5537: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_matching_contacts');
5538: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5539: FND_MSG_PUB.ADD;
5540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5541: END get_matching_contacts;
5542:

Line 5679: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5675: RAISE FND_API.G_EXC_ERROR;
5676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5678: WHEN OTHERS THEN
5679: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5680: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_matching_contact_points');
5681: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5682: FND_MSG_PUB.ADD;
5683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5680: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_matching_contact_points');

5676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5678: WHEN OTHERS THEN
5679: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5680: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_matching_contact_points');
5681: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5682: FND_MSG_PUB.ADD;
5683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5684: END get_matching_contact_points;

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

5677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5678: WHEN OTHERS THEN
5679: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5680: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_matching_contact_points');
5681: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5682: FND_MSG_PUB.ADD;
5683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5684: END get_matching_contact_points;
5685:

Line 5908: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5904: RAISE FND_API.G_EXC_ERROR;
5905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5907: WHEN OTHERS THEN
5908: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5909: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_score_details');
5910: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5911: FND_MSG_PUB.ADD;
5912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5909: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_score_details');

5905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5907: WHEN OTHERS THEN
5908: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5909: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_score_details');
5910: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5911: FND_MSG_PUB.ADD;
5912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5913: END get_score_details;

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

5906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5907: WHEN OTHERS THEN
5908: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5909: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_score_details');
5910: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5911: FND_MSG_PUB.ADD;
5912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5913: END get_score_details;
5914:

Line 6031: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

6027: RAISE FND_API.G_EXC_ERROR;
6028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6030: WHEN OTHERS THEN
6031: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6032: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6033: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6034: FND_MSG_PUB.ADD;
6035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6032: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

6028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6030: WHEN OTHERS THEN
6031: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6032: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6033: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6034: FND_MSG_PUB.ADD;
6035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6036: END get_party_for_search;

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

6029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6030: WHEN OTHERS THEN
6031: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6032: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6033: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6034: FND_MSG_PUB.ADD;
6035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6036: END get_party_for_search;
6037:

Line 6083: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

6079: RAISE FND_API.G_EXC_ERROR;
6080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6082: WHEN OTHERS THEN
6083: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6084: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6085: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6086: FND_MSG_PUB.ADD;
6087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6084: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

6080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6082: WHEN OTHERS THEN
6083: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6084: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6085: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6086: FND_MSG_PUB.ADD;
6087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6088: END get_search_criteria;

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

6081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6082: WHEN OTHERS THEN
6083: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6084: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6085: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6086: FND_MSG_PUB.ADD;
6087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6088: END get_search_criteria;
6089:

Line 6134: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

6130: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
6131:
6132: EXCEPTION
6133: WHEN OTHERS THEN
6134: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6135: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6136: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6137: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6138: FND_MSG_PUB.ADD;

Line 6135: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');

6131:
6132: EXCEPTION
6133: WHEN OTHERS THEN
6134: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6135: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6136: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6137: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6138: FND_MSG_PUB.ADD;
6139: RAISE FND_API.G_EXC_ERROR;

Line 6136: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);

6132: EXCEPTION
6133: WHEN OTHERS THEN
6134: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6135: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6136: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6137: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6138: FND_MSG_PUB.ADD;
6139: RAISE FND_API.G_EXC_ERROR;
6140: END get_party_rec;

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

6133: WHEN OTHERS THEN
6134: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6135: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6136: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6137: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6138: FND_MSG_PUB.ADD;
6139: RAISE FND_API.G_EXC_ERROR;
6140: END get_party_rec;
6141:

Line 6194: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

6190: END LOOP;
6191:
6192: EXCEPTION
6193: WHEN OTHERS THEN
6194: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6195: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6196: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6197: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6198: FND_MSG_PUB.ADD;

Line 6195: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');

6191:
6192: EXCEPTION
6193: WHEN OTHERS THEN
6194: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6195: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6196: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6197: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6198: FND_MSG_PUB.ADD;
6199: RAISE FND_API.G_EXC_ERROR;

Line 6196: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);

6192: EXCEPTION
6193: WHEN OTHERS THEN
6194: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6195: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6196: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6197: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6198: FND_MSG_PUB.ADD;
6199: RAISE FND_API.G_EXC_ERROR;
6200: END get_party_site_rec;

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

6193: WHEN OTHERS THEN
6194: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6195: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6196: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6197: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6198: FND_MSG_PUB.ADD;
6199: RAISE FND_API.G_EXC_ERROR;
6200: END get_party_site_rec;
6201:

Line 6252: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

6248: END LOOP;
6249:
6250: EXCEPTION
6251: WHEN OTHERS THEN
6252: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6253: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6254: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6255: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6256: FND_MSG_PUB.ADD;

Line 6253: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');

6249:
6250: EXCEPTION
6251: WHEN OTHERS THEN
6252: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6253: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6254: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6255: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6256: FND_MSG_PUB.ADD;
6257: RAISE FND_API.G_EXC_ERROR;

Line 6254: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);

6250: EXCEPTION
6251: WHEN OTHERS THEN
6252: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6253: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6254: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6255: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6256: FND_MSG_PUB.ADD;
6257: RAISE FND_API.G_EXC_ERROR;
6258: END get_contact_rec;

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

6251: WHEN OTHERS THEN
6252: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6253: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6254: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6255: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6256: FND_MSG_PUB.ADD;
6257: RAISE FND_API.G_EXC_ERROR;
6258: END get_contact_rec;
6259:

Line 6310: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

6306: END LOOP;
6307:
6308: EXCEPTION
6309: WHEN OTHERS THEN
6310: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6311: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6312: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6313: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6314: FND_MSG_PUB.ADD;

Line 6311: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');

6307:
6308: EXCEPTION
6309: WHEN OTHERS THEN
6310: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6311: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6312: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6313: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6314: FND_MSG_PUB.ADD;
6315: RAISE FND_API.G_EXC_ERROR;

Line 6312: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);

6308: EXCEPTION
6309: WHEN OTHERS THEN
6310: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6311: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6312: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6313: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6314: FND_MSG_PUB.ADD;
6315: RAISE FND_API.G_EXC_ERROR;
6316: END get_contact_point_rec;

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

6309: WHEN OTHERS THEN
6310: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6311: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6312: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6313: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6314: FND_MSG_PUB.ADD;
6315: RAISE FND_API.G_EXC_ERROR;
6316: END get_contact_point_rec;
6317:

Line 6429: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

6425: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6426: END IF;
6427: EXCEPTION
6428: WHEN OTHERS THEN
6429: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6430: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6431: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6432: FND_MSG_PUB.ADD;
6433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6430: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');

6426: END IF;
6427: EXCEPTION
6428: WHEN OTHERS THEN
6429: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6430: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6431: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6432: FND_MSG_PUB.ADD;
6433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6434: END;

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

6427: EXCEPTION
6428: WHEN OTHERS THEN
6429: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6430: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6431: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6432: FND_MSG_PUB.ADD;
6433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6434: END;
6435:

Line 6625: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

6621: END IF;
6622: END LOOP;
6623: EXCEPTION
6624: WHEN OTHERS THEN
6625: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6626: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6627: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6628: FND_MSG_PUB.ADD;
6629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6626: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');

6622: END LOOP;
6623: EXCEPTION
6624: WHEN OTHERS THEN
6625: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6626: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6627: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6628: FND_MSG_PUB.ADD;
6629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6630: END;

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

6623: EXCEPTION
6624: WHEN OTHERS THEN
6625: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6626: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6627: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6628: FND_MSG_PUB.ADD;
6629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6630: END;
6631:

Line 6715: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

6711: END IF;
6712: END LOOP;
6713: EXCEPTION
6714: WHEN OTHERS THEN
6715: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6716: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6717: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6718: FND_MSG_PUB.ADD;
6719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6716: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');

6712: END LOOP;
6713: EXCEPTION
6714: WHEN OTHERS THEN
6715: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6716: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6717: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6718: FND_MSG_PUB.ADD;
6719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6720: END;

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

6713: EXCEPTION
6714: WHEN OTHERS THEN
6715: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6716: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6717: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6718: FND_MSG_PUB.ADD;
6719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6720: END;
6721:

Line 6872: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

6868: END IF;
6869: END LOOP;
6870: EXCEPTION
6871: WHEN OTHERS THEN
6872: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6873: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6874: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6875: FND_MSG_PUB.ADD;
6876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6873: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');

6869: END LOOP;
6870: EXCEPTION
6871: WHEN OTHERS THEN
6872: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6873: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6874: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6875: FND_MSG_PUB.ADD;
6876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6877: END;

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

6870: EXCEPTION
6871: WHEN OTHERS THEN
6872: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6873: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6874: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6875: FND_MSG_PUB.ADD;
6876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6877: END;
6878:

Line 6900: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');

6896: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
6897: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6898: OR p_contact_point_list(I).URL IS NOT NULL
6899: ) THEN
6900: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6901: FND_MSG_PUB.ADD;
6902: RAISE FND_API.G_EXC_ERROR;
6903: END IF;
6904: END LOOP;

Line 6957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

6953: EXCEPTION
6954: WHEN FND_API.G_EXC_ERROR THEN
6955: RAISE FND_API.G_EXC_ERROR;
6956: WHEN OTHERS THEN
6957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6958: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6959: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6960: FND_MSG_PUB.ADD;
6961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6958: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

6954: WHEN FND_API.G_EXC_ERROR THEN
6955: RAISE FND_API.G_EXC_ERROR;
6956: WHEN OTHERS THEN
6957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6958: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6959: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6960: FND_MSG_PUB.ADD;
6961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6962: END check_prim_cond;

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

6955: RAISE FND_API.G_EXC_ERROR;
6956: WHEN OTHERS THEN
6957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6958: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6959: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6960: FND_MSG_PUB.ADD;
6961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6962: END check_prim_cond;
6963:

Line 7019: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

7015: EXIT WHEN x_secondary;
7016: END LOOP;
7017: EXCEPTION
7018: WHEN OTHERS THEN
7019: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7020: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7021: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7022: FND_MSG_PUB.ADD;
7023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7020: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');

7016: END LOOP;
7017: EXCEPTION
7018: WHEN OTHERS THEN
7019: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7020: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7021: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7022: FND_MSG_PUB.ADD;
7023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7024: END check_party_site_cond;

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

7017: EXCEPTION
7018: WHEN OTHERS THEN
7019: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7020: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7021: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7022: FND_MSG_PUB.ADD;
7023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7024: END check_party_site_cond;
7025:

Line 7077: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

7073: EXIT WHEN x_secondary;
7074: END LOOP;
7075: EXCEPTION
7076: WHEN OTHERS THEN
7077: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7078: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7079: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7080: FND_MSG_PUB.ADD;
7081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7078: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');

7074: END LOOP;
7075: EXCEPTION
7076: WHEN OTHERS THEN
7077: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7078: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7079: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7080: FND_MSG_PUB.ADD;
7081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7082: END check_contact_cond;

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

7075: EXCEPTION
7076: WHEN OTHERS THEN
7077: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7078: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7079: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7080: FND_MSG_PUB.ADD;
7081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7082: END check_contact_cond;
7083:

Line 7100: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');

7096: x_secondary:= FALSE;
7097:
7098: FOR I IN 1..p_contact_point_list.COUNT LOOP
7099: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7100: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7101: FND_MSG_PUB.ADD;
7102: RAISE FND_API.G_EXC_ERROR;
7103: END IF;
7104: END LOOP;

Line 7126: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

7122: EXIT WHEN x_secondary;
7123: END LOOP;
7124: EXCEPTION
7125: WHEN OTHERS THEN
7126: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7127: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7128: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7129: FND_MSG_PUB.ADD;
7130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7127: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');

7123: END LOOP;
7124: EXCEPTION
7125: WHEN OTHERS THEN
7126: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7127: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7128: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7129: FND_MSG_PUB.ADD;
7130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7131: END check_contact_point_cond;

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

7124: EXCEPTION
7125: WHEN OTHERS THEN
7126: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7127: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7128: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7129: FND_MSG_PUB.ADD;
7130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7131: END check_contact_point_cond;
7132: