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 1703: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2635: IF p_index>1 THEN
2636: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2637: 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);
2638: END IF;
2639: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2640: FND_MSG_PUB.ADD;
2641: RAISE FND_API.G_EXC_ERROR;
2642: ELSE
2643: push_eval;

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

2683: IF p_index>1 THEN
2684: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2685: 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);
2686: END IF;
2687: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2688: FND_MSG_PUB.ADD;
2689: RAISE FND_API.G_EXC_ERROR;
2690: ELSE
2691: push_eval;

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

2756: IF p_index>1 THEN
2757: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2758: 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);
2759: END IF;
2760: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2761: FND_MSG_PUB.ADD;
2762: RAISE FND_API.G_EXC_ERROR;
2763: ELSE
2764: push_eval;

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

2868: IF p_index>1 THEN
2869: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2870: 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);
2871: END IF;
2872: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2873: FND_MSG_PUB.ADD;
2874: RAISE FND_API.G_EXC_ERROR;
2875: ELSE
2876: push_eval;

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

2979: IF p_index>1 THEN
2980: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2981: 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);
2982: END IF;
2983: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2984: FND_MSG_PUB.ADD;
2985: RAISE FND_API.G_EXC_ERROR;
2986: ELSE
2987: push_eval;

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

3204: ELSE
3205: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3206: 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);
3207: END IF;
3208: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3209: FND_MSG_PUB.ADD;
3210: RAISE FND_API.G_EXC_ERROR;
3211: END IF;
3212: ELSE

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

3212: ELSE
3213: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3214: 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);
3215: END IF;
3216: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3217: FND_MSG_PUB.ADD;
3218: RAISE FND_API.G_EXC_ERROR;
3219: END IF;
3220: END IF;

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

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

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

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

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

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

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

3618: IF p_index>1 THEN
3619: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3620: 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);
3621: END IF;
3622: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3623: FND_MSG_PUB.ADD;
3624: RAISE FND_API.G_EXC_ERROR;
3625: ELSE
3626: push_eval;

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

3666: IF p_index>1 THEN
3667: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3668: 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);
3669: END IF;
3670: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3671: FND_MSG_PUB.ADD;
3672: RAISE FND_API.G_EXC_ERROR;
3673: ELSE
3674: push_eval;

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

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

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

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

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

3778: IF p_index>1 THEN
3779: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3780: 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);
3781: END IF;
3782: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3783: FND_MSG_PUB.ADD;
3784: RAISE FND_API.G_EXC_ERROR;
3785: ELSE
3786: push_eval;

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

4037: IF p_index>1 THEN
4038: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4039: 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);
4040: END IF;
4041: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4042: FND_MSG_PUB.ADD;
4043: RAISE FND_API.G_EXC_ERROR;
4044: ELSE
4045: push_eval;

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

4150: ELSE
4151: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4152: 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);
4153: END IF;
4154: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4155: FND_MSG_PUB.ADD;
4156: RAISE FND_API.G_EXC_ERROR;
4157: END IF;
4158: ELSE

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

4158: ELSE
4159: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4160: 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);
4161: END IF;
4162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4163: FND_MSG_PUB.ADD;
4164: RAISE FND_API.G_EXC_ERROR;
4165: END IF;
4166: END IF;

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

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

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

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

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

4281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4282: WHEN OTHERS THEN
4283: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4284: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_persons');
4285: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4286: FND_MSG_PUB.ADD;
4287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4288: END find_persons;
4289:

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

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

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

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

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

4349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4350: WHEN OTHERS THEN
4351: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4352: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_party_details');
4353: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4354: FND_MSG_PUB.ADD;
4355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4356: END find_party_details;
4357:

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

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

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

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

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

4466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4467: WHEN OTHERS THEN
4468: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4469: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_parties');
4470: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4471: FND_MSG_PUB.ADD;
4472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4473: END find_duplicate_parties;
4474:

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

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

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

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

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

4551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4552: WHEN OTHERS THEN
4553: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4554: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_party_sites');
4555: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4556: FND_MSG_PUB.ADD;
4557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4558: END find_duplicate_party_sites;
4559:

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

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

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

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

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

4640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4641: WHEN OTHERS THEN
4642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4643: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_contacts');
4644: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4645: FND_MSG_PUB.ADD;
4646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4647: END find_duplicate_contacts;
4648:

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

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

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

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

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

4713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4714: WHEN OTHERS THEN
4715: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4716: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.find_duplicate_contact_points');
4717: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4718: FND_MSG_PUB.ADD;
4719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4720: END find_duplicate_contact_points;
4721:

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

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

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

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

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

5066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5067: WHEN OTHERS THEN
5068: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5069: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.call_api_dynamic');
5070: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5071: FND_MSG_PUB.ADD;
5072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5073: END call_api_dynamic;
5074:

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

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

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

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

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

5309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5310: WHEN OTHERS THEN
5311: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5312: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_matching_party_sites');
5313: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5314: FND_MSG_PUB.ADD;
5315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5316: END get_matching_party_sites;
5317:

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

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

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

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

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

5538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5539: WHEN OTHERS THEN
5540: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5541: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_matching_contacts');
5542: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5543: FND_MSG_PUB.ADD;
5544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5545: END get_matching_contacts;
5546:

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

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

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

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

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

5681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5682: WHEN OTHERS THEN
5683: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5684: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_matching_contact_points');
5685: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5686: FND_MSG_PUB.ADD;
5687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5688: END get_matching_contact_points;
5689:

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

5909: RAISE FND_API.G_EXC_ERROR;
5910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5912: WHEN OTHERS THEN
5913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5914: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_score_details');
5915: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5916: FND_MSG_PUB.ADD;
5917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5912: WHEN OTHERS THEN
5913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5914: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_score_details');
5915: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5916: FND_MSG_PUB.ADD;
5917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5918: END get_score_details;

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

5911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5912: WHEN OTHERS THEN
5913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5914: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_8.get_score_details');
5915: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5916: FND_MSG_PUB.ADD;
5917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5918: END get_score_details;
5919:

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

6032: RAISE FND_API.G_EXC_ERROR;
6033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6035: WHEN OTHERS THEN
6036: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6037: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6038: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6039: FND_MSG_PUB.ADD;
6040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6035: WHEN OTHERS THEN
6036: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6037: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6038: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6039: FND_MSG_PUB.ADD;
6040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6041: END get_party_for_search;

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

6034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6035: WHEN OTHERS THEN
6036: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6037: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6038: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6039: FND_MSG_PUB.ADD;
6040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6041: END get_party_for_search;
6042:

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

6084: RAISE FND_API.G_EXC_ERROR;
6085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6087: WHEN OTHERS THEN
6088: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6089: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6090: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6091: FND_MSG_PUB.ADD;
6092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6087: WHEN OTHERS THEN
6088: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6089: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6090: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6091: FND_MSG_PUB.ADD;
6092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6093: END get_search_criteria;

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

6086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6087: WHEN OTHERS THEN
6088: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6089: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6090: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6091: FND_MSG_PUB.ADD;
6092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6093: END get_search_criteria;
6094:

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

6135: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
6136:
6137: EXCEPTION
6138: WHEN OTHERS THEN
6139: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6140: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6141: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6142: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6143: FND_MSG_PUB.ADD;

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

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

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

6137: EXCEPTION
6138: WHEN OTHERS THEN
6139: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6140: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6141: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6142: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6143: FND_MSG_PUB.ADD;
6144: RAISE FND_API.G_EXC_ERROR;
6145: END get_party_rec;

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

6138: WHEN OTHERS THEN
6139: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6140: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6141: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6142: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6143: FND_MSG_PUB.ADD;
6144: RAISE FND_API.G_EXC_ERROR;
6145: END get_party_rec;
6146:

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

6195: END LOOP;
6196:
6197: EXCEPTION
6198: WHEN OTHERS THEN
6199: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6200: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6201: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6203: FND_MSG_PUB.ADD;

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

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

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

6197: EXCEPTION
6198: WHEN OTHERS THEN
6199: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6200: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6201: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6203: FND_MSG_PUB.ADD;
6204: RAISE FND_API.G_EXC_ERROR;
6205: END get_party_site_rec;

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

6198: WHEN OTHERS THEN
6199: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6200: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6201: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6203: FND_MSG_PUB.ADD;
6204: RAISE FND_API.G_EXC_ERROR;
6205: END get_party_site_rec;
6206:

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

6253: END LOOP;
6254:
6255: EXCEPTION
6256: WHEN OTHERS THEN
6257: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6258: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6259: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6260: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6261: FND_MSG_PUB.ADD;

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

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

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

6255: EXCEPTION
6256: WHEN OTHERS THEN
6257: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6258: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6259: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6260: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6261: FND_MSG_PUB.ADD;
6262: RAISE FND_API.G_EXC_ERROR;
6263: END get_contact_rec;

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

6256: WHEN OTHERS THEN
6257: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6258: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6259: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6260: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6261: FND_MSG_PUB.ADD;
6262: RAISE FND_API.G_EXC_ERROR;
6263: END get_contact_rec;
6264:

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

6311: END LOOP;
6312:
6313: EXCEPTION
6314: WHEN OTHERS THEN
6315: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6316: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6317: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6318: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6319: FND_MSG_PUB.ADD;

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

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

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

6313: EXCEPTION
6314: WHEN OTHERS THEN
6315: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6316: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6317: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6318: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6319: FND_MSG_PUB.ADD;
6320: RAISE FND_API.G_EXC_ERROR;
6321: END get_contact_point_rec;

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

6314: WHEN OTHERS THEN
6315: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6316: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6317: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6318: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6319: FND_MSG_PUB.ADD;
6320: RAISE FND_API.G_EXC_ERROR;
6321: END get_contact_point_rec;
6322:

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

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

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

6431: END IF;
6432: EXCEPTION
6433: WHEN OTHERS THEN
6434: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6435: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6436: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6437: FND_MSG_PUB.ADD;
6438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6439: END;

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

6432: EXCEPTION
6433: WHEN OTHERS THEN
6434: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6435: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6436: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6437: FND_MSG_PUB.ADD;
6438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6439: END;
6440:

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

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

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

6627: END LOOP;
6628: EXCEPTION
6629: WHEN OTHERS THEN
6630: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6631: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6632: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6633: FND_MSG_PUB.ADD;
6634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6635: END;

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

6628: EXCEPTION
6629: WHEN OTHERS THEN
6630: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6631: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6632: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6633: FND_MSG_PUB.ADD;
6634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6635: END;
6636:

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

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

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

6717: END LOOP;
6718: EXCEPTION
6719: WHEN OTHERS THEN
6720: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6721: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6723: FND_MSG_PUB.ADD;
6724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6725: END;

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

6718: EXCEPTION
6719: WHEN OTHERS THEN
6720: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6721: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6723: FND_MSG_PUB.ADD;
6724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6725: END;
6726:

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

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

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

6874: END LOOP;
6875: EXCEPTION
6876: WHEN OTHERS THEN
6877: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6878: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6879: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6880: FND_MSG_PUB.ADD;
6881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6882: END;

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

6875: EXCEPTION
6876: WHEN OTHERS THEN
6877: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6878: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6879: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6880: FND_MSG_PUB.ADD;
6881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6882: END;
6883:

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

6901: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
6902: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6903: OR p_contact_point_list(I).URL IS NOT NULL
6904: ) THEN
6905: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6906: FND_MSG_PUB.ADD;
6907: RAISE FND_API.G_EXC_ERROR;
6908: END IF;
6909: END LOOP;

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

6958: EXCEPTION
6959: WHEN FND_API.G_EXC_ERROR THEN
6960: RAISE FND_API.G_EXC_ERROR;
6961: WHEN OTHERS THEN
6962: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6963: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6964: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6965: FND_MSG_PUB.ADD;
6966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6959: WHEN FND_API.G_EXC_ERROR THEN
6960: RAISE FND_API.G_EXC_ERROR;
6961: WHEN OTHERS THEN
6962: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6963: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6964: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6965: FND_MSG_PUB.ADD;
6966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6967: END check_prim_cond;

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

6960: RAISE FND_API.G_EXC_ERROR;
6961: WHEN OTHERS THEN
6962: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6963: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6964: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6965: FND_MSG_PUB.ADD;
6966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6967: END check_prim_cond;
6968:

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

7020: EXIT WHEN x_secondary;
7021: END LOOP;
7022: EXCEPTION
7023: WHEN OTHERS THEN
7024: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7025: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7026: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7027: FND_MSG_PUB.ADD;
7028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7021: END LOOP;
7022: EXCEPTION
7023: WHEN OTHERS THEN
7024: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7025: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7026: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7027: FND_MSG_PUB.ADD;
7028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7029: END check_party_site_cond;

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

7022: EXCEPTION
7023: WHEN OTHERS THEN
7024: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7025: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7026: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7027: FND_MSG_PUB.ADD;
7028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7029: END check_party_site_cond;
7030:

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

7078: EXIT WHEN x_secondary;
7079: END LOOP;
7080: EXCEPTION
7081: WHEN OTHERS THEN
7082: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7083: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7084: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7085: FND_MSG_PUB.ADD;
7086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7079: END LOOP;
7080: EXCEPTION
7081: WHEN OTHERS THEN
7082: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7083: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7084: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7085: FND_MSG_PUB.ADD;
7086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7087: END check_contact_cond;

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

7080: EXCEPTION
7081: WHEN OTHERS THEN
7082: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7083: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7084: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7085: FND_MSG_PUB.ADD;
7086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7087: END check_contact_cond;
7088:

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

7101: x_secondary:= FALSE;
7102:
7103: FOR I IN 1..p_contact_point_list.COUNT LOOP
7104: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7105: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7106: FND_MSG_PUB.ADD;
7107: RAISE FND_API.G_EXC_ERROR;
7108: END IF;
7109: END LOOP;

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

7127: EXIT WHEN x_secondary;
7128: END LOOP;
7129: EXCEPTION
7130: WHEN OTHERS THEN
7131: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7132: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7133: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7134: FND_MSG_PUB.ADD;
7135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7128: END LOOP;
7129: EXCEPTION
7130: WHEN OTHERS THEN
7131: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7132: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7133: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7134: FND_MSG_PUB.ADD;
7135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7136: END check_contact_point_cond;

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

7129: EXCEPTION
7130: WHEN OTHERS THEN
7131: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7132: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7133: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7134: FND_MSG_PUB.ADD;
7135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7136: END check_contact_point_cond;
7137: