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_53 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 874: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

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

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

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

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

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

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

895: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,p_search_list(1).COUNTRY);
896: END IF ;
897: EXCEPTION
898: WHEN OTHERS THEN
899: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
900: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
901: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
902: FND_MSG_PUB.ADD;
903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

896: END IF ;
897: EXCEPTION
898: WHEN OTHERS THEN
899: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
900: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
901: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
902: FND_MSG_PUB.ADD;
903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
904: END;

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

897: EXCEPTION
898: WHEN OTHERS THEN
899: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
900: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
901: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
902: FND_MSG_PUB.ADD;
903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
904: END;
905:

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

915: BEGIN
916: NULL ;
917: EXCEPTION
918: WHEN OTHERS THEN
919: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
920: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
921: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
922: FND_MSG_PUB.ADD;
923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

916: NULL ;
917: EXCEPTION
918: WHEN OTHERS THEN
919: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
920: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
921: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
922: FND_MSG_PUB.ADD;
923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
924: END;

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

917: EXCEPTION
918: WHEN OTHERS THEN
919: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
920: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
921: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
922: FND_MSG_PUB.ADD;
923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
924: END;
925:

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

935: BEGIN
936: NULL ;
937: EXCEPTION
938: WHEN OTHERS THEN
939: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
940: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
942: FND_MSG_PUB.ADD;
943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

936: NULL ;
937: EXCEPTION
938: WHEN OTHERS THEN
939: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
940: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
942: FND_MSG_PUB.ADD;
943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
944: END;

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

937: EXCEPTION
938: WHEN OTHERS THEN
939: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
940: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
942: FND_MSG_PUB.ADD;
943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
944: END;
945:

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

1004: IF NOT check_prim_cond (p_party_search_rec,
1005: p_party_site_list,
1006: p_contact_list,
1007: p_contact_point_list) THEN
1008: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1009: FND_MSG_PUB.ADD;
1010: RAISE FND_API.G_EXC_ERROR;
1011: END IF;
1012: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1295: ELSE
1296: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1297: END IF;
1298: IF lengthb(l_party_contains_str) > 4000 THEN
1299: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1300: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1301: FND_MSG_PUB.ADD;
1302: RAISE FND_API.G_EXC_ERROR;
1303: END IF;

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

1296: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1297: END IF;
1298: IF lengthb(l_party_contains_str) > 4000 THEN
1299: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1300: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1301: FND_MSG_PUB.ADD;
1302: RAISE FND_API.G_EXC_ERROR;
1303: END IF;
1304: IF (p_match_str = ' AND ' OR p_party_max_score

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

1394: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1395: END LOOP;
1396: -- Add the search criteria to query string
1397: IF lengthb(l_contains_str) > 4000 THEN
1398: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1399: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1400: FND_MSG_PUB.ADD;
1401: RAISE FND_API.G_EXC_ERROR;
1402: END IF;

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

1395: END LOOP;
1396: -- Add the search criteria to query string
1397: IF lengthb(l_contains_str) > 4000 THEN
1398: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1399: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1400: FND_MSG_PUB.ADD;
1401: RAISE FND_API.G_EXC_ERROR;
1402: END IF;
1403: x_denorm_str := l_den_contains_str;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3424: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_parties');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4285: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_persons');

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

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

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

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

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

Line 4353: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_party_details');

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

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

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

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

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

Line 4470: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_parties');

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

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

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

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

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

Line 4555: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_party_sites');

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

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

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

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

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

Line 4644: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_contacts');

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

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

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

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

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

Line 4717: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_contact_points');

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

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

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

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

5014: RAISE FND_API.G_EXC_ERROR;
5015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5017: WHEN OTHERS THEN
5018: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5019: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.call_api_dynamic');
5020: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5021: FND_MSG_PUB.ADD;
5022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5019: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.call_api_dynamic');

5015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5017: WHEN OTHERS THEN
5018: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5019: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.call_api_dynamic');
5020: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5021: FND_MSG_PUB.ADD;
5022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5023: END call_api_dynamic;

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

5016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5017: WHEN OTHERS THEN
5018: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5019: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.call_api_dynamic');
5020: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5021: FND_MSG_PUB.ADD;
5022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5023: END call_api_dynamic;
5024:

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

5254: RAISE FND_API.G_EXC_ERROR;
5255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5257: WHEN OTHERS THEN
5258: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5259: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_party_sites');
5260: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5261: FND_MSG_PUB.ADD;
5262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5259: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_party_sites');

5255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5257: WHEN OTHERS THEN
5258: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5259: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_party_sites');
5260: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5261: FND_MSG_PUB.ADD;
5262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5263: END get_matching_party_sites;

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

5256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5257: WHEN OTHERS THEN
5258: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5259: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_party_sites');
5260: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5261: FND_MSG_PUB.ADD;
5262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5263: END get_matching_party_sites;
5264:

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

5479: RAISE FND_API.G_EXC_ERROR;
5480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5482: WHEN OTHERS THEN
5483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5484: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contacts');
5485: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5486: FND_MSG_PUB.ADD;
5487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5484: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contacts');

5480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5482: WHEN OTHERS THEN
5483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5484: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contacts');
5485: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5486: FND_MSG_PUB.ADD;
5487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5488: END get_matching_contacts;

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

5481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5482: WHEN OTHERS THEN
5483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5484: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contacts');
5485: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5486: FND_MSG_PUB.ADD;
5487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5488: END get_matching_contacts;
5489:

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

5618: RAISE FND_API.G_EXC_ERROR;
5619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5621: WHEN OTHERS THEN
5622: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5623: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contact_points');
5624: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5625: FND_MSG_PUB.ADD;
5626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5623: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contact_points');

5619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5621: WHEN OTHERS THEN
5622: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5623: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contact_points');
5624: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5625: FND_MSG_PUB.ADD;
5626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5627: END get_matching_contact_points;

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

5620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5621: WHEN OTHERS THEN
5622: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5623: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contact_points');
5624: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5625: FND_MSG_PUB.ADD;
5626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5627: END get_matching_contact_points;
5628:

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

5844: RAISE FND_API.G_EXC_ERROR;
5845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5847: WHEN OTHERS THEN
5848: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5849: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_score_details');
5850: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5851: FND_MSG_PUB.ADD;
5852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5849: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_score_details');

5845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5847: WHEN OTHERS THEN
5848: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5849: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_score_details');
5850: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5851: FND_MSG_PUB.ADD;
5852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5853: END get_score_details;

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

5846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5847: WHEN OTHERS THEN
5848: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5849: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_score_details');
5850: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5851: FND_MSG_PUB.ADD;
5852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5853: END get_score_details;
5854:

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

5922: RAISE FND_API.G_EXC_ERROR;
5923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5925: WHEN OTHERS THEN
5926: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5927: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5928: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5929: FND_MSG_PUB.ADD;
5930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5925: WHEN OTHERS THEN
5926: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5927: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5928: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5929: FND_MSG_PUB.ADD;
5930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5931: END get_party_for_search;

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

5924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5925: WHEN OTHERS THEN
5926: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5927: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5928: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5929: FND_MSG_PUB.ADD;
5930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5931: END get_party_for_search;
5932:

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

5962: RAISE FND_API.G_EXC_ERROR;
5963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5965: WHEN OTHERS THEN
5966: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5967: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5968: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5969: FND_MSG_PUB.ADD;
5970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5965: WHEN OTHERS THEN
5966: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5967: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5968: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5969: FND_MSG_PUB.ADD;
5970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5971: END get_search_criteria;

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

5964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5965: WHEN OTHERS THEN
5966: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5967: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5968: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5969: FND_MSG_PUB.ADD;
5970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5971: END get_search_criteria;
5972:

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

6026: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
6027:
6028: EXCEPTION
6029: WHEN OTHERS THEN
6030: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6031: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6032: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6033: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6034: FND_MSG_PUB.ADD;

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

6027:
6028: EXCEPTION
6029: WHEN OTHERS THEN
6030: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6031: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6032: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6033: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6034: FND_MSG_PUB.ADD;
6035: RAISE FND_API.G_EXC_ERROR;

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

6028: EXCEPTION
6029: WHEN OTHERS THEN
6030: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6031: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6032: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6033: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6034: FND_MSG_PUB.ADD;
6035: RAISE FND_API.G_EXC_ERROR;
6036: END get_party_rec;

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

6029: WHEN OTHERS THEN
6030: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6031: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6032: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6033: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6034: FND_MSG_PUB.ADD;
6035: RAISE FND_API.G_EXC_ERROR;
6036: END get_party_rec;
6037:

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

6088: END LOOP;
6089:
6090: EXCEPTION
6091: WHEN OTHERS THEN
6092: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6093: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6094: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6095: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6096: FND_MSG_PUB.ADD;

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

6089:
6090: EXCEPTION
6091: WHEN OTHERS THEN
6092: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6093: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6094: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6095: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6096: FND_MSG_PUB.ADD;
6097: RAISE FND_API.G_EXC_ERROR;

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

6090: EXCEPTION
6091: WHEN OTHERS THEN
6092: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6093: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6094: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6095: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6096: FND_MSG_PUB.ADD;
6097: RAISE FND_API.G_EXC_ERROR;
6098: END get_party_site_rec;

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

6091: WHEN OTHERS THEN
6092: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6093: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6094: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6095: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6096: FND_MSG_PUB.ADD;
6097: RAISE FND_API.G_EXC_ERROR;
6098: END get_party_site_rec;
6099:

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

6144: END LOOP;
6145:
6146: EXCEPTION
6147: WHEN OTHERS THEN
6148: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6149: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6150: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6151: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6152: FND_MSG_PUB.ADD;

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

6145:
6146: EXCEPTION
6147: WHEN OTHERS THEN
6148: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6149: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6150: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6151: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6152: FND_MSG_PUB.ADD;
6153: RAISE FND_API.G_EXC_ERROR;

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

6146: EXCEPTION
6147: WHEN OTHERS THEN
6148: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6149: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6150: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6151: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6152: FND_MSG_PUB.ADD;
6153: RAISE FND_API.G_EXC_ERROR;
6154: END get_contact_rec;

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

6147: WHEN OTHERS THEN
6148: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6149: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6150: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6151: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6152: FND_MSG_PUB.ADD;
6153: RAISE FND_API.G_EXC_ERROR;
6154: END get_contact_rec;
6155:

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

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

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

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

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

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

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

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

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

6411: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6412: END IF;
6413: EXCEPTION
6414: WHEN OTHERS THEN
6415: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6416: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6417: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6418: FND_MSG_PUB.ADD;
6419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6412: END IF;
6413: EXCEPTION
6414: WHEN OTHERS THEN
6415: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6416: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6417: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6418: FND_MSG_PUB.ADD;
6419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6420: END;

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

6413: EXCEPTION
6414: WHEN OTHERS THEN
6415: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6416: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6417: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6418: FND_MSG_PUB.ADD;
6419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6420: END;
6421:

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

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

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

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

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

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

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

6665: END IF;
6666: NULL;
6667: EXCEPTION
6668: WHEN OTHERS THEN
6669: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6670: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6671: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6672: FND_MSG_PUB.ADD;
6673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6666: NULL;
6667: EXCEPTION
6668: WHEN OTHERS THEN
6669: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6670: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6671: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6672: FND_MSG_PUB.ADD;
6673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6674: END;

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

6667: EXCEPTION
6668: WHEN OTHERS THEN
6669: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6670: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6671: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6672: FND_MSG_PUB.ADD;
6673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6674: END;
6675:

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

6732: END IF;
6733: NULL;
6734: EXCEPTION
6735: WHEN OTHERS THEN
6736: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6737: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6738: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6739: FND_MSG_PUB.ADD;
6740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6733: NULL;
6734: EXCEPTION
6735: WHEN OTHERS THEN
6736: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6737: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6738: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6739: FND_MSG_PUB.ADD;
6740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6741: END;

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

6734: EXCEPTION
6735: WHEN OTHERS THEN
6736: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6737: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6738: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6739: FND_MSG_PUB.ADD;
6740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6741: END;
6742:

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

6799: EXCEPTION
6800: WHEN FND_API.G_EXC_ERROR THEN
6801: RAISE FND_API.G_EXC_ERROR;
6802: WHEN OTHERS THEN
6803: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6804: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6805: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6806: FND_MSG_PUB.ADD;
6807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6800: WHEN FND_API.G_EXC_ERROR THEN
6801: RAISE FND_API.G_EXC_ERROR;
6802: WHEN OTHERS THEN
6803: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6804: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6805: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6806: FND_MSG_PUB.ADD;
6807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6808: END check_prim_cond;

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

6801: RAISE FND_API.G_EXC_ERROR;
6802: WHEN OTHERS THEN
6803: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6804: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6805: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6806: FND_MSG_PUB.ADD;
6807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6808: END check_prim_cond;
6809:

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

6851: NULL;
6852: END LOOP;
6853: EXCEPTION
6854: WHEN OTHERS THEN
6855: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6856: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6857: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6858: FND_MSG_PUB.ADD;
6859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6852: END LOOP;
6853: EXCEPTION
6854: WHEN OTHERS THEN
6855: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6856: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6857: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6858: FND_MSG_PUB.ADD;
6859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6860: END check_party_site_cond;

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

6853: EXCEPTION
6854: WHEN OTHERS THEN
6855: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6856: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6857: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6858: FND_MSG_PUB.ADD;
6859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6860: END check_party_site_cond;
6861:

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

6889: NULL;
6890: END LOOP;
6891: EXCEPTION
6892: WHEN OTHERS THEN
6893: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6894: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6895: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6896: FND_MSG_PUB.ADD;
6897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6890: END LOOP;
6891: EXCEPTION
6892: WHEN OTHERS THEN
6893: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6894: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6895: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6896: FND_MSG_PUB.ADD;
6897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6898: END check_contact_cond;

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

6891: EXCEPTION
6892: WHEN OTHERS THEN
6893: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6894: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6895: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6896: FND_MSG_PUB.ADD;
6897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6898: END check_contact_cond;
6899:

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

6912: x_secondary:= FALSE;
6913:
6914: FOR I IN 1..p_contact_point_list.COUNT LOOP
6915: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6916: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6917: FND_MSG_PUB.ADD;
6918: RAISE FND_API.G_EXC_ERROR;
6919: END IF;
6920: END LOOP;

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

6926: NULL;
6927: END LOOP;
6928: EXCEPTION
6929: WHEN OTHERS THEN
6930: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6931: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6932: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6933: FND_MSG_PUB.ADD;
6934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6927: END LOOP;
6928: EXCEPTION
6929: WHEN OTHERS THEN
6930: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6931: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6932: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6933: FND_MSG_PUB.ADD;
6934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6935: END check_contact_point_cond;

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

6928: EXCEPTION
6929: WHEN OTHERS THEN
6930: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6931: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6932: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6933: FND_MSG_PUB.ADD;
6934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6935: END check_contact_point_cond;
6936: