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

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

64: END IF;
65: RETURN null;
66: EXCEPTION
67: WHEN OTHERS THEN
68: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
69: FND_MESSAGE.SET_TOKEN('PROC','check_parties_bulk');
70: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
71: FND_MSG_PUB.ADD;
72: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 69: FND_MESSAGE.SET_TOKEN('PROC','check_parties_bulk');

65: RETURN null;
66: EXCEPTION
67: WHEN OTHERS THEN
68: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
69: FND_MESSAGE.SET_TOKEN('PROC','check_parties_bulk');
70: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
71: FND_MSG_PUB.ADD;
72: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
73: END check_parties_bulk ;

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

66: EXCEPTION
67: WHEN OTHERS THEN
68: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
69: FND_MESSAGE.SET_TOKEN('PROC','check_parties_bulk');
70: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
71: FND_MSG_PUB.ADD;
72: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
73: END check_parties_bulk ;
74:

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

94:
95: IF x_primary = TRUE THEN RETURN 'Y'; ELSE RETURN null; END IF;
96: EXCEPTION
97: WHEN OTHERS THEN
98: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
99: FND_MESSAGE.SET_TOKEN('PROC','check_party_sites_bulk');
100: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 99: FND_MESSAGE.SET_TOKEN('PROC','check_party_sites_bulk');

95: IF x_primary = TRUE THEN RETURN 'Y'; ELSE RETURN null; END IF;
96: EXCEPTION
97: WHEN OTHERS THEN
98: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
99: FND_MESSAGE.SET_TOKEN('PROC','check_party_sites_bulk');
100: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: END check_party_sites_bulk ;

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

96: EXCEPTION
97: WHEN OTHERS THEN
98: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
99: FND_MESSAGE.SET_TOKEN('PROC','check_party_sites_bulk');
100: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: END check_party_sites_bulk ;
104:

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

123:
124: IF x_primary = TRUE THEN RETURN 'Y'; ELSE RETURN null; END IF;
125: EXCEPTION
126: WHEN OTHERS THEN
127: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
128: FND_MESSAGE.SET_TOKEN('PROC','check_contacts_bulk');
129: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
130: FND_MSG_PUB.ADD;
131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 128: FND_MESSAGE.SET_TOKEN('PROC','check_contacts_bulk');

124: IF x_primary = TRUE THEN RETURN 'Y'; ELSE RETURN null; END IF;
125: EXCEPTION
126: WHEN OTHERS THEN
127: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
128: FND_MESSAGE.SET_TOKEN('PROC','check_contacts_bulk');
129: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
130: FND_MSG_PUB.ADD;
131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
132: END check_contacts_bulk ;

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

125: EXCEPTION
126: WHEN OTHERS THEN
127: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
128: FND_MESSAGE.SET_TOKEN('PROC','check_contacts_bulk');
129: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
130: FND_MSG_PUB.ADD;
131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
132: END check_contacts_bulk ;
133:

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

154:
155: IF x_primary = TRUE THEN RETURN 'Y'; ELSE RETURN null; END IF;
156: EXCEPTION
157: WHEN OTHERS THEN
158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
159: FND_MESSAGE.SET_TOKEN('PROC','check_cpts_bulk');
160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
161: FND_MSG_PUB.ADD;
162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 159: FND_MESSAGE.SET_TOKEN('PROC','check_cpts_bulk');

155: IF x_primary = TRUE THEN RETURN 'Y'; ELSE RETURN null; END IF;
156: EXCEPTION
157: WHEN OTHERS THEN
158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
159: FND_MESSAGE.SET_TOKEN('PROC','check_cpts_bulk');
160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
161: FND_MSG_PUB.ADD;
162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
163: END check_cpts_bulk ;

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

156: EXCEPTION
157: WHEN OTHERS THEN
158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
159: FND_MESSAGE.SET_TOKEN('PROC','check_cpts_bulk');
160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
161: FND_MSG_PUB.ADD;
162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
163: END check_cpts_bulk ;
164:

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

941: BEGIN
942: NULL ;
943: EXCEPTION
944: WHEN OTHERS THEN
945: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
946: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
948: FND_MSG_PUB.ADD;
949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

942: NULL ;
943: EXCEPTION
944: WHEN OTHERS THEN
945: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
946: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
948: FND_MSG_PUB.ADD;
949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
950: END;

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

943: EXCEPTION
944: WHEN OTHERS THEN
945: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
946: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
948: FND_MSG_PUB.ADD;
949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
950: END;
951:

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

966: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,p_search_list(1).COUNTRY);
967: END IF ;
968: EXCEPTION
969: WHEN OTHERS THEN
970: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
971: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
972: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
973: FND_MSG_PUB.ADD;
974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

967: END IF ;
968: EXCEPTION
969: WHEN OTHERS THEN
970: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
971: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
972: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
973: FND_MSG_PUB.ADD;
974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
975: END;

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

968: EXCEPTION
969: WHEN OTHERS THEN
970: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
971: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
972: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
973: FND_MSG_PUB.ADD;
974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
975: END;
976:

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

986: BEGIN
987: NULL ;
988: EXCEPTION
989: WHEN OTHERS THEN
990: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
991: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
992: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
993: FND_MSG_PUB.ADD;
994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

987: NULL ;
988: EXCEPTION
989: WHEN OTHERS THEN
990: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
991: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
992: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
993: FND_MSG_PUB.ADD;
994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
995: END;

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

988: EXCEPTION
989: WHEN OTHERS THEN
990: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
991: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
992: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
993: FND_MSG_PUB.ADD;
994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
995: END;
996:

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

1006: BEGIN
1007: NULL ;
1008: EXCEPTION
1009: WHEN OTHERS THEN
1010: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1011: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1012: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1013: FND_MSG_PUB.ADD;
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1007: NULL ;
1008: EXCEPTION
1009: WHEN OTHERS THEN
1010: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1011: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1012: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1013: FND_MSG_PUB.ADD;
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: END;

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

1008: EXCEPTION
1009: WHEN OTHERS THEN
1010: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1011: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1012: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1013: FND_MSG_PUB.ADD;
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: END;
1016:

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

1064: IF NOT check_prim_cond (p_party_search_rec,
1065: p_party_site_list,
1066: p_contact_list,
1067: p_contact_point_list) THEN
1068: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1069: FND_MSG_PUB.ADD;
1070: RAISE FND_API.G_EXC_ERROR;
1071: END IF;
1072: HZ_DQM_SEARCH_UTIL.set_score;

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

1261: END IF;
1262: exception
1263: when others then
1264: if (instrb(SQLERRM,'DRG-51030')>0) then
1265: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1266: FND_MSG_PUB.ADD;
1267: RAISE FND_API.G_EXC_ERROR;
1268: else
1269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1358: END IF;
1359: exception
1360: when others then
1361: if (instrb(SQLERRM,'DRG-51030')>0) then
1362: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1363: FND_MSG_PUB.ADD;
1364: RAISE FND_API.G_EXC_ERROR;
1365: else
1366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1459: END IF;
1460: exception
1461: when others then
1462: if (instrb(SQLERRM,'DRG-51030')>0) then
1463: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1464: FND_MSG_PUB.ADD;
1465: RAISE FND_API.G_EXC_ERROR;
1466: else
1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1600: END IF;
1601: exception
1602: when others then
1603: if (instrb(SQLERRM,'DRG-51030')>0) then
1604: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1605: FND_MSG_PUB.ADD;
1606: RAISE FND_API.G_EXC_ERROR;
1607: else
1608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1815: IF p_index>1 THEN
1816: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1817: 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);
1818: END IF;
1819: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1820: FND_MSG_PUB.ADD;
1821: RAISE FND_API.G_EXC_ERROR;
1822: ELSE
1823: push_eval;

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

1884: IF p_index>1 THEN
1885: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1886: 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);
1887: END IF;
1888: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1889: FND_MSG_PUB.ADD;
1890: RAISE FND_API.G_EXC_ERROR;
1891: ELSE
1892: push_eval;

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

1960: IF p_index>1 THEN
1961: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1962: 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);
1963: END IF;
1964: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1965: FND_MSG_PUB.ADD;
1966: RAISE FND_API.G_EXC_ERROR;
1967: ELSE
1968: push_eval;

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

2036: IF p_index>1 THEN
2037: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2038: 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);
2039: END IF;
2040: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2041: FND_MSG_PUB.ADD;
2042: RAISE FND_API.G_EXC_ERROR;
2043: ELSE
2044: push_eval;

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

2080: ELSE
2081: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2082: 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);
2083: END IF;
2084: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2085: FND_MSG_PUB.ADD;
2086: RAISE FND_API.G_EXC_ERROR;
2087: END IF;
2088: END IF;

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

2268: ROLLBACK to find_parties;
2269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2270: WHEN OTHERS THEN
2271: ROLLBACK to find_parties;
2272: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2273: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_parties');
2274: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2275: FND_MSG_PUB.ADD;
2276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2273: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_parties');

2269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2270: WHEN OTHERS THEN
2271: ROLLBACK to find_parties;
2272: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2273: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_parties');
2274: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2275: FND_MSG_PUB.ADD;
2276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2277: END find_parties;

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

2270: WHEN OTHERS THEN
2271: ROLLBACK to find_parties;
2272: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2273: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_parties');
2274: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2275: FND_MSG_PUB.ADD;
2276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2277: END find_parties;
2278:

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

2479: IF p_index>1 THEN
2480: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2481: 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);
2482: END IF;
2483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2484: FND_MSG_PUB.ADD;
2485: RAISE FND_API.G_EXC_ERROR;
2486: ELSE
2487: push_eval;

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

2515: and d.search_context_id = p_search_ctx_id);
2516: exception
2517: when others then
2518: if (instrb(SQLERRM,'DRG-51030')>0) then
2519: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2520: FND_MSG_PUB.ADD;
2521: RAISE FND_API.G_EXC_ERROR;
2522: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2523: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2519: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2520: FND_MSG_PUB.ADD;
2521: RAISE FND_API.G_EXC_ERROR;
2522: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2523: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2524: FND_MSG_PUB.ADD;
2525: RAISE FND_API.G_EXC_ERROR;
2526: else
2527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2595: IF p_index>1 THEN
2596: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2597: 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);
2598: END IF;
2599: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2600: FND_MSG_PUB.ADD;
2601: RAISE FND_API.G_EXC_ERROR;
2602: ELSE
2603: push_eval;

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

2732: IF p_index>1 THEN
2733: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2734: 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);
2735: END IF;
2736: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2737: FND_MSG_PUB.ADD;
2738: RAISE FND_API.G_EXC_ERROR;
2739: ELSE
2740: push_eval;

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

2781: ELSE
2782: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2783: 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);
2784: END IF;
2785: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2786: FND_MSG_PUB.ADD;
2787: RAISE FND_API.G_EXC_ERROR;
2788: END IF;
2789: END IF;

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

2923: ROLLBACK to find_persons;
2924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2925: WHEN OTHERS THEN
2926: ROLLBACK to find_persons;
2927: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2928: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_persons');
2929: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2930: FND_MSG_PUB.ADD;
2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2928: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_persons');

2924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2925: WHEN OTHERS THEN
2926: ROLLBACK to find_persons;
2927: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2928: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_persons');
2929: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2930: FND_MSG_PUB.ADD;
2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2932: END find_persons;

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

2925: WHEN OTHERS THEN
2926: ROLLBACK to find_persons;
2927: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2928: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_persons');
2929: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2930: FND_MSG_PUB.ADD;
2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2932: END find_persons;
2933: PROCEDURE find_persons (

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

2993: RAISE FND_API.G_EXC_ERROR;
2994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2996: WHEN OTHERS THEN
2997: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2998: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_party_details');
2999: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3000: FND_MSG_PUB.ADD;
3001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2998: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_party_details');

2994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2996: WHEN OTHERS THEN
2997: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2998: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_party_details');
2999: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3000: FND_MSG_PUB.ADD;
3001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3002: END find_party_details;

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

2995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2996: WHEN OTHERS THEN
2997: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2998: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_party_details');
2999: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3000: FND_MSG_PUB.ADD;
3001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3002: END find_party_details;
3003:

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

3081: RAISE FND_API.G_EXC_ERROR;
3082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3084: WHEN OTHERS THEN
3085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3086: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_parties');
3087: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3088: FND_MSG_PUB.ADD;
3089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3086: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_parties');

3082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3084: WHEN OTHERS THEN
3085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3086: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_parties');
3087: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3088: FND_MSG_PUB.ADD;
3089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3090: END find_duplicate_parties;

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

3083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3084: WHEN OTHERS THEN
3085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3086: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_parties');
3087: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3088: FND_MSG_PUB.ADD;
3089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3090: END find_duplicate_parties;
3091:

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

3169: RAISE FND_API.G_EXC_ERROR;
3170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3172: WHEN OTHERS THEN
3173: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3174: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_party_sites');
3175: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3176: FND_MSG_PUB.ADD;
3177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3174: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_party_sites');

3170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3172: WHEN OTHERS THEN
3173: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3174: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_party_sites');
3175: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3176: FND_MSG_PUB.ADD;
3177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3178: END find_duplicate_party_sites;

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

3171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3172: WHEN OTHERS THEN
3173: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3174: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_party_sites');
3175: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3176: FND_MSG_PUB.ADD;
3177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3178: END find_duplicate_party_sites;
3179:

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

3261: RAISE FND_API.G_EXC_ERROR;
3262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3264: WHEN OTHERS THEN
3265: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3266: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_contacts');
3267: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3268: FND_MSG_PUB.ADD;
3269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3266: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_contacts');

3262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3264: WHEN OTHERS THEN
3265: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3266: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_contacts');
3267: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3268: FND_MSG_PUB.ADD;
3269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3270: END find_duplicate_contacts;

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

3263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3264: WHEN OTHERS THEN
3265: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3266: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_contacts');
3267: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3268: FND_MSG_PUB.ADD;
3269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3270: END find_duplicate_contacts;
3271:

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

3337: RAISE FND_API.G_EXC_ERROR;
3338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3340: WHEN OTHERS THEN
3341: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3342: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_contact_points');
3343: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3344: FND_MSG_PUB.ADD;
3345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3342: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_contact_points');

3338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3340: WHEN OTHERS THEN
3341: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3342: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_contact_points');
3343: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3344: FND_MSG_PUB.ADD;
3345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3346: END find_duplicate_contact_points;

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

3339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3340: WHEN OTHERS THEN
3341: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3342: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.find_duplicate_contact_points');
3343: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3344: FND_MSG_PUB.ADD;
3345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3346: END find_duplicate_contact_points;
3347:

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

3728: RAISE FND_API.G_EXC_ERROR;
3729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3731: WHEN OTHERS THEN
3732: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3733: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.call_api_dynamic');
3734: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3735: FND_MSG_PUB.ADD;
3736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3733: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.call_api_dynamic');

3729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3731: WHEN OTHERS THEN
3732: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3733: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.call_api_dynamic');
3734: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3735: FND_MSG_PUB.ADD;
3736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3737: END call_api_dynamic;

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

3730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3731: WHEN OTHERS THEN
3732: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3733: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.call_api_dynamic');
3734: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3735: FND_MSG_PUB.ADD;
3736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3737: END call_api_dynamic;
3738:

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

3956: ROLLBACK to get_matching_party_sites ;
3957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3958: WHEN OTHERS THEN
3959: ROLLBACK to get_matching_party_sites ;
3960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3961: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_party_sites');
3962: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3963: FND_MSG_PUB.ADD;
3964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3961: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_party_sites');

3957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3958: WHEN OTHERS THEN
3959: ROLLBACK to get_matching_party_sites ;
3960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3961: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_party_sites');
3962: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3963: FND_MSG_PUB.ADD;
3964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3965: END get_matching_party_sites;

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

3958: WHEN OTHERS THEN
3959: ROLLBACK to get_matching_party_sites ;
3960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3961: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_party_sites');
3962: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3963: FND_MSG_PUB.ADD;
3964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3965: END get_matching_party_sites;
3966:

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

4179: ROLLBACK to get_matching_contacts ;
4180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4181: WHEN OTHERS THEN
4182: ROLLBACK to get_matching_contacts ;
4183: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4184: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_contacts');
4185: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4186: FND_MSG_PUB.ADD;
4187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4184: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_contacts');

4180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4181: WHEN OTHERS THEN
4182: ROLLBACK to get_matching_contacts ;
4183: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4184: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_contacts');
4185: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4186: FND_MSG_PUB.ADD;
4187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4188: END get_matching_contacts;

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

4181: WHEN OTHERS THEN
4182: ROLLBACK to get_matching_contacts ;
4183: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4184: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_contacts');
4185: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4186: FND_MSG_PUB.ADD;
4187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4188: END get_matching_contacts;
4189:

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

4327: ROLLBACK to get_matching_contact_points ;
4328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4329: WHEN OTHERS THEN
4330: ROLLBACK to get_matching_contact_points ;
4331: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4332: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_contact_points');
4333: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4334: FND_MSG_PUB.ADD;
4335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4332: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_contact_points');

4328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4329: WHEN OTHERS THEN
4330: ROLLBACK to get_matching_contact_points ;
4331: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4332: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_contact_points');
4333: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4334: FND_MSG_PUB.ADD;
4335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4336: END get_matching_contact_points;

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

4329: WHEN OTHERS THEN
4330: ROLLBACK to get_matching_contact_points ;
4331: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4332: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_matching_contact_points');
4333: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4334: FND_MSG_PUB.ADD;
4335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4336: END get_matching_contact_points;
4337:

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

4558: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4559: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4560: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4561: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4562: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4563: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_score_details');
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_52.get_score_details');

4559: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4560: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4561: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4562: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4563: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_score_details');
4564: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4565: FND_MSG_PUB.ADD;
4566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4567: END get_score_details;

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

4560: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4561: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4562: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4563: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_52.get_score_details');
4564: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4565: FND_MSG_PUB.ADD;
4566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4567: END get_score_details;
4568:

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

4677: RAISE FND_API.G_EXC_ERROR;
4678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4680: WHEN OTHERS THEN
4681: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4682: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
4683: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4684: FND_MSG_PUB.ADD;
4685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4680: WHEN OTHERS THEN
4681: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4682: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
4683: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4684: FND_MSG_PUB.ADD;
4685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4686: END get_party_for_search;

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

4679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4680: WHEN OTHERS THEN
4681: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4682: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
4683: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4684: FND_MSG_PUB.ADD;
4685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4686: END get_party_for_search;
4687:

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

4729: RAISE FND_API.G_EXC_ERROR;
4730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4732: WHEN OTHERS THEN
4733: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4734: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
4735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4736: FND_MSG_PUB.ADD;
4737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4732: WHEN OTHERS THEN
4733: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4734: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
4735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4736: FND_MSG_PUB.ADD;
4737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4738: END get_search_criteria;

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

4731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4732: WHEN OTHERS THEN
4733: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4734: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
4735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4736: FND_MSG_PUB.ADD;
4737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4738: END get_search_criteria;
4739:

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

4797: END IF;
4798:
4799: EXCEPTION
4800: WHEN OTHERS THEN
4801: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4802: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
4803: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
4804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4805: FND_MSG_PUB.ADD;

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

4798:
4799: EXCEPTION
4800: WHEN OTHERS THEN
4801: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4802: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
4803: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
4804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4805: FND_MSG_PUB.ADD;
4806: RAISE FND_API.G_EXC_ERROR;

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

4799: EXCEPTION
4800: WHEN OTHERS THEN
4801: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4802: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
4803: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
4804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4805: FND_MSG_PUB.ADD;
4806: RAISE FND_API.G_EXC_ERROR;
4807: END get_party_rec;

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

4800: WHEN OTHERS THEN
4801: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4802: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
4803: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
4804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4805: FND_MSG_PUB.ADD;
4806: RAISE FND_API.G_EXC_ERROR;
4807: END get_party_rec;
4808:

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

4859: END LOOP;
4860:
4861: EXCEPTION
4862: WHEN OTHERS THEN
4863: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4864: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
4865: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
4866: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4867: FND_MSG_PUB.ADD;

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

4860:
4861: EXCEPTION
4862: WHEN OTHERS THEN
4863: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4864: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
4865: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
4866: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4867: FND_MSG_PUB.ADD;
4868: RAISE FND_API.G_EXC_ERROR;

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

4861: EXCEPTION
4862: WHEN OTHERS THEN
4863: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4864: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
4865: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
4866: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4867: FND_MSG_PUB.ADD;
4868: RAISE FND_API.G_EXC_ERROR;
4869: END get_party_site_rec;

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

4862: WHEN OTHERS THEN
4863: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4864: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
4865: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
4866: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4867: FND_MSG_PUB.ADD;
4868: RAISE FND_API.G_EXC_ERROR;
4869: END get_party_site_rec;
4870:

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

4919: END LOOP;
4920:
4921: EXCEPTION
4922: WHEN OTHERS THEN
4923: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4924: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
4925: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
4926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4927: FND_MSG_PUB.ADD;

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

4920:
4921: EXCEPTION
4922: WHEN OTHERS THEN
4923: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4924: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
4925: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
4926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4927: FND_MSG_PUB.ADD;
4928: RAISE FND_API.G_EXC_ERROR;

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

4921: EXCEPTION
4922: WHEN OTHERS THEN
4923: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4924: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
4925: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
4926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4927: FND_MSG_PUB.ADD;
4928: RAISE FND_API.G_EXC_ERROR;
4929: END get_contact_rec;

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

4922: WHEN OTHERS THEN
4923: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4924: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
4925: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
4926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4927: FND_MSG_PUB.ADD;
4928: RAISE FND_API.G_EXC_ERROR;
4929: END get_contact_rec;
4930:

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

4977: END LOOP;
4978:
4979: EXCEPTION
4980: WHEN OTHERS THEN
4981: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4982: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
4983: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
4984: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4985: FND_MSG_PUB.ADD;

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

4978:
4979: EXCEPTION
4980: WHEN OTHERS THEN
4981: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4982: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
4983: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
4984: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4985: FND_MSG_PUB.ADD;
4986: RAISE FND_API.G_EXC_ERROR;

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

4979: EXCEPTION
4980: WHEN OTHERS THEN
4981: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4982: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
4983: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
4984: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4985: FND_MSG_PUB.ADD;
4986: RAISE FND_API.G_EXC_ERROR;
4987: END get_contact_point_rec;

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

4980: WHEN OTHERS THEN
4981: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4982: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
4983: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
4984: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4985: FND_MSG_PUB.ADD;
4986: RAISE FND_API.G_EXC_ERROR;
4987: END get_contact_point_rec;
4988:

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

5106: insert into HZ_SRCH_PARTIES(batch_id,party_id, party_osr,party_os,TX41,TX45,TX59,TX2,TX36,TX46) values(-1,-1,-1,-1,x_stage_rec.TX41,x_stage_rec.TX45,x_stage_rec.TX59,x_stage_rec.TX2,x_stage_rec.TX36,x_stage_rec.TX46);
5107: END IF;
5108: EXCEPTION
5109: WHEN OTHERS THEN
5110: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5111: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5112: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5113: FND_MSG_PUB.ADD;
5114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5107: END IF;
5108: EXCEPTION
5109: WHEN OTHERS THEN
5110: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5111: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5112: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5113: FND_MSG_PUB.ADD;
5114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5115: END;

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

5108: EXCEPTION
5109: WHEN OTHERS THEN
5110: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5111: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5112: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5113: FND_MSG_PUB.ADD;
5114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5115: END;
5116:

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

5259: END LOOP;
5260: END IF;
5261: EXCEPTION
5262: WHEN OTHERS THEN
5263: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5264: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5265: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5266: FND_MSG_PUB.ADD;
5267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5260: END IF;
5261: EXCEPTION
5262: WHEN OTHERS THEN
5263: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5264: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5265: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5266: FND_MSG_PUB.ADD;
5267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5268: END;

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

5261: EXCEPTION
5262: WHEN OTHERS THEN
5263: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5264: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5265: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5266: FND_MSG_PUB.ADD;
5267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5268: END;
5269:

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

5360: END LOOP;
5361: END IF;
5362: EXCEPTION
5363: WHEN OTHERS THEN
5364: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5365: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5366: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5367: FND_MSG_PUB.ADD;
5368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5361: END IF;
5362: EXCEPTION
5363: WHEN OTHERS THEN
5364: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5365: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5366: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5367: FND_MSG_PUB.ADD;
5368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5369: END;

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

5362: EXCEPTION
5363: WHEN OTHERS THEN
5364: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5365: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5366: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5367: FND_MSG_PUB.ADD;
5368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5369: END;
5370:

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

5478: END LOOP;
5479: END IF;
5480: EXCEPTION
5481: WHEN OTHERS THEN
5482: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5483: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5484: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5485: FND_MSG_PUB.ADD;
5486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5479: END IF;
5480: EXCEPTION
5481: WHEN OTHERS THEN
5482: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5483: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5484: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5485: FND_MSG_PUB.ADD;
5486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5487: END;

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

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

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

5506: p_contact_point_list(I).RAW_PHONE_NUMBER IS NOT NULL
5507: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
5508: OR p_contact_point_list(I).URL IS NOT NULL
5509: ) THEN
5510: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5511: FND_MSG_PUB.ADD;
5512: RAISE FND_API.G_EXC_ERROR;
5513: END IF;
5514: END LOOP;

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

5551: EXCEPTION
5552: WHEN FND_API.G_EXC_ERROR THEN
5553: RAISE FND_API.G_EXC_ERROR;
5554: WHEN OTHERS THEN
5555: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5556: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5557: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5558: FND_MSG_PUB.ADD;
5559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5552: WHEN FND_API.G_EXC_ERROR THEN
5553: RAISE FND_API.G_EXC_ERROR;
5554: WHEN OTHERS THEN
5555: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5556: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5557: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5558: FND_MSG_PUB.ADD;
5559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5560: END check_prim_cond;

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

5553: RAISE FND_API.G_EXC_ERROR;
5554: WHEN OTHERS THEN
5555: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5556: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5557: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5558: FND_MSG_PUB.ADD;
5559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5560: END check_prim_cond;
5561:

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

5611: EXIT WHEN x_secondary;
5612: END LOOP;
5613: EXCEPTION
5614: WHEN OTHERS THEN
5615: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5616: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5617: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5618: FND_MSG_PUB.ADD;
5619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5612: END LOOP;
5613: EXCEPTION
5614: WHEN OTHERS THEN
5615: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5616: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5617: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5618: FND_MSG_PUB.ADD;
5619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5620: END check_party_site_cond;

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

5613: EXCEPTION
5614: WHEN OTHERS THEN
5615: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5616: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5617: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5618: FND_MSG_PUB.ADD;
5619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5620: END check_party_site_cond;
5621:

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

5670: EXIT WHEN x_secondary;
5671: END LOOP;
5672: EXCEPTION
5673: WHEN OTHERS THEN
5674: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5675: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5676: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5677: FND_MSG_PUB.ADD;
5678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5671: END LOOP;
5672: EXCEPTION
5673: WHEN OTHERS THEN
5674: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5675: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5676: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5677: FND_MSG_PUB.ADD;
5678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5679: END check_contact_cond;

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

5672: EXCEPTION
5673: WHEN OTHERS THEN
5674: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5675: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5676: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5677: FND_MSG_PUB.ADD;
5678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5679: END check_contact_cond;
5680:

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

5693: x_secondary:= FALSE;
5694:
5695: FOR I IN 1..p_contact_point_list.COUNT LOOP
5696: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5697: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5698: FND_MSG_PUB.ADD;
5699: RAISE FND_API.G_EXC_ERROR;
5700: END IF;
5701: END LOOP;

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

5719: EXIT WHEN x_secondary;
5720: END LOOP;
5721: EXCEPTION
5722: WHEN OTHERS THEN
5723: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5724: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5726: FND_MSG_PUB.ADD;
5727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5720: END LOOP;
5721: EXCEPTION
5722: WHEN OTHERS THEN
5723: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5724: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5726: FND_MSG_PUB.ADD;
5727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5728: END check_contact_point_cond;

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

5721: EXCEPTION
5722: WHEN OTHERS THEN
5723: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5724: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5726: FND_MSG_PUB.ADD;
5727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5728: END check_contact_point_cond;
5729: