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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2689: IF p_index>1 THEN
2690: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2691: 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);
2692: END IF;
2693: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2694: FND_MSG_PUB.ADD;
2695: RAISE FND_API.G_EXC_ERROR;
2696: ELSE
2697: push_eval;

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

2762: IF p_index>1 THEN
2763: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2764: 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);
2765: END IF;
2766: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2767: FND_MSG_PUB.ADD;
2768: RAISE FND_API.G_EXC_ERROR;
2769: ELSE
2770: push_eval;

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

2874: IF p_index>1 THEN
2875: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2876: 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);
2877: END IF;
2878: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2879: FND_MSG_PUB.ADD;
2880: RAISE FND_API.G_EXC_ERROR;
2881: ELSE
2882: push_eval;

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

2985: IF p_index>1 THEN
2986: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2987: 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);
2988: END IF;
2989: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2990: FND_MSG_PUB.ADD;
2991: RAISE FND_API.G_EXC_ERROR;
2992: ELSE
2993: push_eval;

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

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

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

3218: ELSE
3219: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3220: 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);
3221: END IF;
3222: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3223: FND_MSG_PUB.ADD;
3224: RAISE FND_API.G_EXC_ERROR;
3225: END IF;
3226: END IF;

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

3424: RAISE FND_API.G_EXC_ERROR;
3425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3427: WHEN OTHERS THEN
3428: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3429: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_parties');
3430: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3431: FND_MSG_PUB.ADD;
3432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3427: WHEN OTHERS THEN
3428: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3429: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_parties');
3430: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3431: FND_MSG_PUB.ADD;
3432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3433: END find_parties;

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

3426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3427: WHEN OTHERS THEN
3428: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3429: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_parties');
3430: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3431: FND_MSG_PUB.ADD;
3432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3433: END find_parties;
3434:

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

3625: IF p_index>1 THEN
3626: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3627: 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);
3628: END IF;
3629: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3630: FND_MSG_PUB.ADD;
3631: RAISE FND_API.G_EXC_ERROR;
3632: ELSE
3633: push_eval;

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

3675: IF p_index>1 THEN
3676: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3677: 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);
3678: END IF;
3679: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3680: FND_MSG_PUB.ADD;
3681: RAISE FND_API.G_EXC_ERROR;
3682: ELSE
3683: push_eval;

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

3711: and d.search_context_id = p_search_ctx_id);
3712: exception
3713: when others then
3714: if (instrb(SQLERRM,'DRG-51030')>0) then
3715: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3716: FND_MSG_PUB.ADD;
3717: RAISE FND_API.G_EXC_ERROR;
3718: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3719: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3715: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3716: FND_MSG_PUB.ADD;
3717: RAISE FND_API.G_EXC_ERROR;
3718: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3719: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3720: FND_MSG_PUB.ADD;
3721: RAISE FND_API.G_EXC_ERROR;
3722: else
3723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3787: IF p_index>1 THEN
3788: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3789: 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);
3790: END IF;
3791: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3792: FND_MSG_PUB.ADD;
3793: RAISE FND_API.G_EXC_ERROR;
3794: ELSE
3795: push_eval;

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

4046: IF p_index>1 THEN
4047: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4048: 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);
4049: END IF;
4050: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4051: FND_MSG_PUB.ADD;
4052: RAISE FND_API.G_EXC_ERROR;
4053: ELSE
4054: push_eval;

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

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

4167: ELSE
4168: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4169: 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);
4170: END IF;
4171: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4172: FND_MSG_PUB.ADD;
4173: RAISE FND_API.G_EXC_ERROR;
4174: END IF;
4175: END IF;

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

4288: RAISE FND_API.G_EXC_ERROR;
4289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4291: WHEN OTHERS THEN
4292: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4293: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_persons');
4294: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4295: FND_MSG_PUB.ADD;
4296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4291: WHEN OTHERS THEN
4292: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4293: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_persons');
4294: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4295: FND_MSG_PUB.ADD;
4296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4297: END find_persons;

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

4290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4291: WHEN OTHERS THEN
4292: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4293: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_persons');
4294: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4295: FND_MSG_PUB.ADD;
4296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4297: END find_persons;
4298:

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

4356: RAISE FND_API.G_EXC_ERROR;
4357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4359: WHEN OTHERS THEN
4360: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4361: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_party_details');
4362: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4363: FND_MSG_PUB.ADD;
4364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4359: WHEN OTHERS THEN
4360: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4361: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_party_details');
4362: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4363: FND_MSG_PUB.ADD;
4364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4365: END find_party_details;

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

4358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4359: WHEN OTHERS THEN
4360: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4361: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_party_details');
4362: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4363: FND_MSG_PUB.ADD;
4364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4365: END find_party_details;
4366:

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

4473: RAISE FND_API.G_EXC_ERROR;
4474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4476: WHEN OTHERS THEN
4477: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4478: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_parties');
4479: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4480: FND_MSG_PUB.ADD;
4481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4476: WHEN OTHERS THEN
4477: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4478: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_parties');
4479: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4480: FND_MSG_PUB.ADD;
4481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4482: END find_duplicate_parties;

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

4475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4476: WHEN OTHERS THEN
4477: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4478: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_parties');
4479: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4480: FND_MSG_PUB.ADD;
4481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4482: END find_duplicate_parties;
4483:

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

4558: RAISE FND_API.G_EXC_ERROR;
4559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4561: WHEN OTHERS THEN
4562: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4563: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_party_sites');
4564: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4565: FND_MSG_PUB.ADD;
4566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4561: WHEN OTHERS THEN
4562: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4563: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_party_sites');
4564: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4565: FND_MSG_PUB.ADD;
4566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4567: END find_duplicate_party_sites;

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

4560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4561: WHEN OTHERS THEN
4562: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4563: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_party_sites');
4564: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4565: FND_MSG_PUB.ADD;
4566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4567: END find_duplicate_party_sites;
4568:

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

4647: RAISE FND_API.G_EXC_ERROR;
4648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4650: WHEN OTHERS THEN
4651: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4652: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_contacts');
4653: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4654: FND_MSG_PUB.ADD;
4655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4650: WHEN OTHERS THEN
4651: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4652: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_contacts');
4653: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4654: FND_MSG_PUB.ADD;
4655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4656: END find_duplicate_contacts;

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

4649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4650: WHEN OTHERS THEN
4651: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4652: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_contacts');
4653: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4654: FND_MSG_PUB.ADD;
4655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4656: END find_duplicate_contacts;
4657:

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

4720: RAISE FND_API.G_EXC_ERROR;
4721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4723: WHEN OTHERS THEN
4724: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4725: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_contact_points');
4726: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4727: FND_MSG_PUB.ADD;
4728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4723: WHEN OTHERS THEN
4724: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4725: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_contact_points');
4726: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4727: FND_MSG_PUB.ADD;
4728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4729: END find_duplicate_contact_points;

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

4722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4723: WHEN OTHERS THEN
4724: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4725: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.find_duplicate_contact_points');
4726: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4727: FND_MSG_PUB.ADD;
4728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4729: END find_duplicate_contact_points;
4730:

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

5022: RAISE FND_API.G_EXC_ERROR;
5023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5025: WHEN OTHERS THEN
5026: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5027: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.call_api_dynamic');
5028: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5029: FND_MSG_PUB.ADD;
5030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5025: WHEN OTHERS THEN
5026: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5027: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.call_api_dynamic');
5028: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5029: FND_MSG_PUB.ADD;
5030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5031: END call_api_dynamic;

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

5024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5025: WHEN OTHERS THEN
5026: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5027: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.call_api_dynamic');
5028: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5029: FND_MSG_PUB.ADD;
5030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5031: END call_api_dynamic;
5032:

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

5262: RAISE FND_API.G_EXC_ERROR;
5263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5265: WHEN OTHERS THEN
5266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5267: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_party_sites');
5268: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5269: FND_MSG_PUB.ADD;
5270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5265: WHEN OTHERS THEN
5266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5267: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_party_sites');
5268: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5269: FND_MSG_PUB.ADD;
5270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5271: END get_matching_party_sites;

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

5264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5265: WHEN OTHERS THEN
5266: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5267: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_party_sites');
5268: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5269: FND_MSG_PUB.ADD;
5270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5271: END get_matching_party_sites;
5272:

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

5487: RAISE FND_API.G_EXC_ERROR;
5488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5490: WHEN OTHERS THEN
5491: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5492: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contacts');
5493: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5494: FND_MSG_PUB.ADD;
5495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5490: WHEN OTHERS THEN
5491: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5492: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contacts');
5493: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5494: FND_MSG_PUB.ADD;
5495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5496: END get_matching_contacts;

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

5489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5490: WHEN OTHERS THEN
5491: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5492: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contacts');
5493: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5494: FND_MSG_PUB.ADD;
5495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5496: END get_matching_contacts;
5497:

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

5626: RAISE FND_API.G_EXC_ERROR;
5627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5629: WHEN OTHERS THEN
5630: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5631: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contact_points');
5632: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5633: FND_MSG_PUB.ADD;
5634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5629: WHEN OTHERS THEN
5630: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5631: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contact_points');
5632: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5633: FND_MSG_PUB.ADD;
5634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5635: END get_matching_contact_points;

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

5628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5629: WHEN OTHERS THEN
5630: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5631: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_matching_contact_points');
5632: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5633: FND_MSG_PUB.ADD;
5634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5635: END get_matching_contact_points;
5636:

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

5855: RAISE FND_API.G_EXC_ERROR;
5856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5858: WHEN OTHERS THEN
5859: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5860: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_score_details');
5861: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5862: FND_MSG_PUB.ADD;
5863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5858: WHEN OTHERS THEN
5859: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5860: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_score_details');
5861: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5862: FND_MSG_PUB.ADD;
5863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5864: END get_score_details;

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

5857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5858: WHEN OTHERS THEN
5859: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5860: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_53.get_score_details');
5861: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5862: FND_MSG_PUB.ADD;
5863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5864: END get_score_details;
5865:

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

5933: RAISE FND_API.G_EXC_ERROR;
5934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5936: WHEN OTHERS THEN
5937: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5938: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5939: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5940: FND_MSG_PUB.ADD;
5941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5936: WHEN OTHERS THEN
5937: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5938: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5939: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5940: FND_MSG_PUB.ADD;
5941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5942: END get_party_for_search;

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

5935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5936: WHEN OTHERS THEN
5937: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5938: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5939: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5940: FND_MSG_PUB.ADD;
5941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5942: END get_party_for_search;
5943:

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

5973: RAISE FND_API.G_EXC_ERROR;
5974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5976: WHEN OTHERS THEN
5977: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5978: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5979: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5980: FND_MSG_PUB.ADD;
5981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5976: WHEN OTHERS THEN
5977: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5978: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5979: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5980: FND_MSG_PUB.ADD;
5981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5982: END get_search_criteria;

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

5975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5976: WHEN OTHERS THEN
5977: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5978: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5979: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5980: FND_MSG_PUB.ADD;
5981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5982: END get_search_criteria;
5983:

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

6037: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
6038:
6039: EXCEPTION
6040: WHEN OTHERS THEN
6041: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6042: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6043: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6045: FND_MSG_PUB.ADD;

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

6038:
6039: EXCEPTION
6040: WHEN OTHERS THEN
6041: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6042: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6043: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6045: FND_MSG_PUB.ADD;
6046: RAISE FND_API.G_EXC_ERROR;

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

6039: EXCEPTION
6040: WHEN OTHERS THEN
6041: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6042: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6043: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6045: FND_MSG_PUB.ADD;
6046: RAISE FND_API.G_EXC_ERROR;
6047: END get_party_rec;

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

6040: WHEN OTHERS THEN
6041: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6042: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6043: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6045: FND_MSG_PUB.ADD;
6046: RAISE FND_API.G_EXC_ERROR;
6047: END get_party_rec;
6048:

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

6099: END LOOP;
6100:
6101: EXCEPTION
6102: WHEN OTHERS THEN
6103: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6104: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6105: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6107: FND_MSG_PUB.ADD;

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

6100:
6101: EXCEPTION
6102: WHEN OTHERS THEN
6103: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6104: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6105: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6107: FND_MSG_PUB.ADD;
6108: RAISE FND_API.G_EXC_ERROR;

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

6101: EXCEPTION
6102: WHEN OTHERS THEN
6103: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6104: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6105: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6107: FND_MSG_PUB.ADD;
6108: RAISE FND_API.G_EXC_ERROR;
6109: END get_party_site_rec;

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

6102: WHEN OTHERS THEN
6103: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6104: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6105: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6107: FND_MSG_PUB.ADD;
6108: RAISE FND_API.G_EXC_ERROR;
6109: END get_party_site_rec;
6110:

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

6155: END LOOP;
6156:
6157: EXCEPTION
6158: WHEN OTHERS THEN
6159: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6160: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6161: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6162: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6163: FND_MSG_PUB.ADD;

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

6156:
6157: EXCEPTION
6158: WHEN OTHERS THEN
6159: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6160: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6161: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6162: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6163: FND_MSG_PUB.ADD;
6164: RAISE FND_API.G_EXC_ERROR;

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

6157: EXCEPTION
6158: WHEN OTHERS THEN
6159: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6160: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6161: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6162: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6163: FND_MSG_PUB.ADD;
6164: RAISE FND_API.G_EXC_ERROR;
6165: END get_contact_rec;

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

6158: WHEN OTHERS THEN
6159: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6160: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6161: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6162: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6163: FND_MSG_PUB.ADD;
6164: RAISE FND_API.G_EXC_ERROR;
6165: END get_contact_rec;
6166:

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

6207: END LOOP;
6208:
6209: EXCEPTION
6210: WHEN OTHERS THEN
6211: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6212: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6213: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6214: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6215: FND_MSG_PUB.ADD;

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

6208:
6209: EXCEPTION
6210: WHEN OTHERS THEN
6211: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6212: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6213: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6214: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6215: FND_MSG_PUB.ADD;
6216: RAISE FND_API.G_EXC_ERROR;

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

6209: EXCEPTION
6210: WHEN OTHERS THEN
6211: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6212: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6213: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6214: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6215: FND_MSG_PUB.ADD;
6216: RAISE FND_API.G_EXC_ERROR;
6217: END get_contact_point_rec;

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

6210: WHEN OTHERS THEN
6211: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6212: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6213: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6214: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6215: FND_MSG_PUB.ADD;
6216: RAISE FND_API.G_EXC_ERROR;
6217: END get_contact_point_rec;
6218:

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

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

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

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

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

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

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

6634: END IF;
6635: END LOOP;
6636: EXCEPTION
6637: WHEN OTHERS THEN
6638: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6639: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6640: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6641: FND_MSG_PUB.ADD;
6642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6635: END LOOP;
6636: EXCEPTION
6637: WHEN OTHERS THEN
6638: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6639: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6640: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6641: FND_MSG_PUB.ADD;
6642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6643: END;

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

6636: EXCEPTION
6637: WHEN OTHERS THEN
6638: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6639: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6640: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6641: FND_MSG_PUB.ADD;
6642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6643: END;
6644:

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

6676: END IF;
6677: NULL;
6678: EXCEPTION
6679: WHEN OTHERS THEN
6680: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6681: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6682: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6683: FND_MSG_PUB.ADD;
6684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6677: NULL;
6678: EXCEPTION
6679: WHEN OTHERS THEN
6680: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6681: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6682: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6683: FND_MSG_PUB.ADD;
6684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6685: END;

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

6678: EXCEPTION
6679: WHEN OTHERS THEN
6680: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6681: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6682: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6683: FND_MSG_PUB.ADD;
6684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6685: END;
6686:

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

6743: END IF;
6744: NULL;
6745: EXCEPTION
6746: WHEN OTHERS THEN
6747: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6748: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6749: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6750: FND_MSG_PUB.ADD;
6751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6744: NULL;
6745: EXCEPTION
6746: WHEN OTHERS THEN
6747: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6748: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6749: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6750: FND_MSG_PUB.ADD;
6751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6752: END;

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

6745: EXCEPTION
6746: WHEN OTHERS THEN
6747: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6748: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6749: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6750: FND_MSG_PUB.ADD;
6751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6752: END;
6753:

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

6810: EXCEPTION
6811: WHEN FND_API.G_EXC_ERROR THEN
6812: RAISE FND_API.G_EXC_ERROR;
6813: WHEN OTHERS THEN
6814: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6815: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6816: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6817: FND_MSG_PUB.ADD;
6818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6811: WHEN FND_API.G_EXC_ERROR THEN
6812: RAISE FND_API.G_EXC_ERROR;
6813: WHEN OTHERS THEN
6814: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6815: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6816: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6817: FND_MSG_PUB.ADD;
6818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6819: END check_prim_cond;

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

6812: RAISE FND_API.G_EXC_ERROR;
6813: WHEN OTHERS THEN
6814: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6815: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6816: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6817: FND_MSG_PUB.ADD;
6818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6819: END check_prim_cond;
6820:

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

6862: NULL;
6863: END LOOP;
6864: EXCEPTION
6865: WHEN OTHERS THEN
6866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6867: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6869: FND_MSG_PUB.ADD;
6870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6863: END LOOP;
6864: EXCEPTION
6865: WHEN OTHERS THEN
6866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6867: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6869: FND_MSG_PUB.ADD;
6870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6871: END check_party_site_cond;

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

6864: EXCEPTION
6865: WHEN OTHERS THEN
6866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6867: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6869: FND_MSG_PUB.ADD;
6870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6871: END check_party_site_cond;
6872:

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

6900: NULL;
6901: END LOOP;
6902: EXCEPTION
6903: WHEN OTHERS THEN
6904: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6905: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6906: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6907: FND_MSG_PUB.ADD;
6908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6901: END LOOP;
6902: EXCEPTION
6903: WHEN OTHERS THEN
6904: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6905: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6906: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6907: FND_MSG_PUB.ADD;
6908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6909: END check_contact_cond;

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

6902: EXCEPTION
6903: WHEN OTHERS THEN
6904: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6905: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6906: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6907: FND_MSG_PUB.ADD;
6908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6909: END check_contact_cond;
6910:

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

6923: x_secondary:= FALSE;
6924:
6925: FOR I IN 1..p_contact_point_list.COUNT LOOP
6926: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6927: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6928: FND_MSG_PUB.ADD;
6929: RAISE FND_API.G_EXC_ERROR;
6930: END IF;
6931: END LOOP;

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

6937: NULL;
6938: END LOOP;
6939: EXCEPTION
6940: WHEN OTHERS THEN
6941: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6942: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6943: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6944: FND_MSG_PUB.ADD;
6945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6938: END LOOP;
6939: EXCEPTION
6940: WHEN OTHERS THEN
6941: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6942: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6943: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6944: FND_MSG_PUB.ADD;
6945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6946: END check_contact_point_cond;

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

6939: EXCEPTION
6940: WHEN OTHERS THEN
6941: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6942: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6943: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6944: FND_MSG_PUB.ADD;
6945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6946: END check_contact_point_cond;
6947: