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_50 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 157: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

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

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

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

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

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

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

895: BEGIN
896: NULL ;
897: EXCEPTION
898: WHEN OTHERS THEN
899: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
900: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_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_COND_REC');

896: NULL ;
897: EXCEPTION
898: WHEN OTHERS THEN
899: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
900: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_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_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 924: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

920: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,p_search_list(1).COUNTRY);
921: END IF ;
922: EXCEPTION
923: WHEN OTHERS THEN
924: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
925: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
927: FND_MSG_PUB.ADD;
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

921: END IF ;
922: EXCEPTION
923: WHEN OTHERS THEN
924: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
925: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
927: FND_MSG_PUB.ADD;
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
929: END;

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

922: EXCEPTION
923: WHEN OTHERS THEN
924: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
925: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
927: FND_MSG_PUB.ADD;
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
929: END;
930:

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

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

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

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

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

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

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

960: BEGIN
961: NULL ;
962: EXCEPTION
963: WHEN OTHERS THEN
964: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
965: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
966: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
967: FND_MSG_PUB.ADD;
968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

961: NULL ;
962: EXCEPTION
963: WHEN OTHERS THEN
964: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
965: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
966: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
967: FND_MSG_PUB.ADD;
968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
969: END;

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

962: EXCEPTION
963: WHEN OTHERS THEN
964: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
965: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
966: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
967: FND_MSG_PUB.ADD;
968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
969: END;
970:

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

1018: IF NOT check_prim_cond (p_party_search_rec,
1019: p_party_site_list,
1020: p_contact_list,
1021: p_contact_point_list) THEN
1022: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1023: FND_MSG_PUB.ADD;
1024: RAISE FND_API.G_EXC_ERROR;
1025: END IF;
1026: HZ_DQM_SEARCH_UTIL.set_score;

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

1215: END IF;
1216: exception
1217: when others then
1218: if (instrb(SQLERRM,'DRG-51030')>0) then
1219: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1220: FND_MSG_PUB.ADD;
1221: RAISE FND_API.G_EXC_ERROR;
1222: else
1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1312: END IF;
1313: exception
1314: when others then
1315: if (instrb(SQLERRM,'DRG-51030')>0) then
1316: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1317: FND_MSG_PUB.ADD;
1318: RAISE FND_API.G_EXC_ERROR;
1319: else
1320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1413: END IF;
1414: exception
1415: when others then
1416: if (instrb(SQLERRM,'DRG-51030')>0) then
1417: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1418: FND_MSG_PUB.ADD;
1419: RAISE FND_API.G_EXC_ERROR;
1420: else
1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1534: END IF;
1535: exception
1536: when others then
1537: if (instrb(SQLERRM,'DRG-51030')>0) then
1538: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1539: FND_MSG_PUB.ADD;
1540: RAISE FND_API.G_EXC_ERROR;
1541: else
1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1748: IF p_index>1 THEN
1749: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1750: 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);
1751: END IF;
1752: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1753: FND_MSG_PUB.ADD;
1754: RAISE FND_API.G_EXC_ERROR;
1755: ELSE
1756: push_eval;

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

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

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

1893: IF p_index>1 THEN
1894: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1895: 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);
1896: END IF;
1897: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1898: FND_MSG_PUB.ADD;
1899: RAISE FND_API.G_EXC_ERROR;
1900: ELSE
1901: push_eval;

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

1969: IF p_index>1 THEN
1970: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1971: 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);
1972: END IF;
1973: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1974: FND_MSG_PUB.ADD;
1975: RAISE FND_API.G_EXC_ERROR;
1976: ELSE
1977: push_eval;

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

2013: ELSE
2014: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2015: 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);
2016: END IF;
2017: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2018: FND_MSG_PUB.ADD;
2019: RAISE FND_API.G_EXC_ERROR;
2020: END IF;
2021: END IF;

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

2201: ROLLBACK to find_parties;
2202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2203: WHEN OTHERS THEN
2204: ROLLBACK to find_parties;
2205: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2206: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_parties');
2207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2208: FND_MSG_PUB.ADD;
2209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2206: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_parties');

2202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2203: WHEN OTHERS THEN
2204: ROLLBACK to find_parties;
2205: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2206: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_parties');
2207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2208: FND_MSG_PUB.ADD;
2209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2210: END find_parties;

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

2203: WHEN OTHERS THEN
2204: ROLLBACK to find_parties;
2205: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2206: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_parties');
2207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2208: FND_MSG_PUB.ADD;
2209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2210: END find_parties;
2211:

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

2411: IF p_index>1 THEN
2412: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2413: 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);
2414: END IF;
2415: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2416: FND_MSG_PUB.ADD;
2417: RAISE FND_API.G_EXC_ERROR;
2418: ELSE
2419: push_eval;

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

2447: and d.search_context_id = p_search_ctx_id);
2448: exception
2449: when others then
2450: if (instrb(SQLERRM,'DRG-51030')>0) then
2451: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2452: FND_MSG_PUB.ADD;
2453: RAISE FND_API.G_EXC_ERROR;
2454: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2455: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2451: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2452: FND_MSG_PUB.ADD;
2453: RAISE FND_API.G_EXC_ERROR;
2454: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2455: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2456: FND_MSG_PUB.ADD;
2457: RAISE FND_API.G_EXC_ERROR;
2458: else
2459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2527: IF p_index>1 THEN
2528: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2529: 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);
2530: END IF;
2531: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2532: FND_MSG_PUB.ADD;
2533: RAISE FND_API.G_EXC_ERROR;
2534: ELSE
2535: push_eval;

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

2664: IF p_index>1 THEN
2665: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2666: 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);
2667: END IF;
2668: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2669: FND_MSG_PUB.ADD;
2670: RAISE FND_API.G_EXC_ERROR;
2671: ELSE
2672: push_eval;

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

2713: ELSE
2714: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2715: 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);
2716: END IF;
2717: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2718: FND_MSG_PUB.ADD;
2719: RAISE FND_API.G_EXC_ERROR;
2720: END IF;
2721: END IF;

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

2855: ROLLBACK to find_persons;
2856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2857: WHEN OTHERS THEN
2858: ROLLBACK to find_persons;
2859: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2860: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_persons');
2861: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2862: FND_MSG_PUB.ADD;
2863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2860: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_persons');

2856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2857: WHEN OTHERS THEN
2858: ROLLBACK to find_persons;
2859: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2860: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_persons');
2861: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2862: FND_MSG_PUB.ADD;
2863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2864: END find_persons;

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

2857: WHEN OTHERS THEN
2858: ROLLBACK to find_persons;
2859: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2860: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_persons');
2861: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2862: FND_MSG_PUB.ADD;
2863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2864: END find_persons;
2865: PROCEDURE find_persons (

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

2925: RAISE FND_API.G_EXC_ERROR;
2926: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2928: WHEN OTHERS THEN
2929: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2930: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_party_details');
2931: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2932: FND_MSG_PUB.ADD;
2933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2930: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_party_details');

2926: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2928: WHEN OTHERS THEN
2929: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2930: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_party_details');
2931: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2932: FND_MSG_PUB.ADD;
2933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2934: END find_party_details;

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

2927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2928: WHEN OTHERS THEN
2929: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2930: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_party_details');
2931: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2932: FND_MSG_PUB.ADD;
2933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2934: END find_party_details;
2935:

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

3013: RAISE FND_API.G_EXC_ERROR;
3014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3016: WHEN OTHERS THEN
3017: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3018: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_parties');
3019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3020: FND_MSG_PUB.ADD;
3021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3018: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_parties');

3014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3016: WHEN OTHERS THEN
3017: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3018: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_parties');
3019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3020: FND_MSG_PUB.ADD;
3021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3022: END find_duplicate_parties;

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

3015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3016: WHEN OTHERS THEN
3017: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3018: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_parties');
3019: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3020: FND_MSG_PUB.ADD;
3021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3022: END find_duplicate_parties;
3023:

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

3101: RAISE FND_API.G_EXC_ERROR;
3102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3104: WHEN OTHERS THEN
3105: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3106: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_party_sites');
3107: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3108: FND_MSG_PUB.ADD;
3109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3106: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_party_sites');

3102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3104: WHEN OTHERS THEN
3105: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3106: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_party_sites');
3107: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3108: FND_MSG_PUB.ADD;
3109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3110: END find_duplicate_party_sites;

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

3103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3104: WHEN OTHERS THEN
3105: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3106: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_party_sites');
3107: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3108: FND_MSG_PUB.ADD;
3109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3110: END find_duplicate_party_sites;
3111:

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

3193: RAISE FND_API.G_EXC_ERROR;
3194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3196: WHEN OTHERS THEN
3197: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3198: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_contacts');
3199: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3200: FND_MSG_PUB.ADD;
3201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3198: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_contacts');

3194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3196: WHEN OTHERS THEN
3197: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3198: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_contacts');
3199: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3200: FND_MSG_PUB.ADD;
3201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3202: END find_duplicate_contacts;

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

3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3196: WHEN OTHERS THEN
3197: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3198: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_contacts');
3199: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3200: FND_MSG_PUB.ADD;
3201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3202: END find_duplicate_contacts;
3203:

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

3269: RAISE FND_API.G_EXC_ERROR;
3270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3272: WHEN OTHERS THEN
3273: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3274: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_contact_points');
3275: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3276: FND_MSG_PUB.ADD;
3277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3274: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_contact_points');

3270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3272: WHEN OTHERS THEN
3273: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3274: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_contact_points');
3275: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3276: FND_MSG_PUB.ADD;
3277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3278: END find_duplicate_contact_points;

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

3271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3272: WHEN OTHERS THEN
3273: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3274: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.find_duplicate_contact_points');
3275: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3276: FND_MSG_PUB.ADD;
3277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3278: END find_duplicate_contact_points;
3279:

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

3636: RAISE FND_API.G_EXC_ERROR;
3637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3639: WHEN OTHERS THEN
3640: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3641: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.call_api_dynamic');
3642: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3643: FND_MSG_PUB.ADD;
3644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3641: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.call_api_dynamic');

3637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3639: WHEN OTHERS THEN
3640: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3641: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.call_api_dynamic');
3642: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3643: FND_MSG_PUB.ADD;
3644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3645: END call_api_dynamic;

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

3638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3639: WHEN OTHERS THEN
3640: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3641: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.call_api_dynamic');
3642: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3643: FND_MSG_PUB.ADD;
3644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3645: END call_api_dynamic;
3646:

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

3863: ROLLBACK to get_matching_party_sites ;
3864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3865: WHEN OTHERS THEN
3866: ROLLBACK to get_matching_party_sites ;
3867: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3868: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_party_sites');
3869: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3870: FND_MSG_PUB.ADD;
3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3868: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_party_sites');

3864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3865: WHEN OTHERS THEN
3866: ROLLBACK to get_matching_party_sites ;
3867: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3868: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_party_sites');
3869: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3870: FND_MSG_PUB.ADD;
3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3872: END get_matching_party_sites;

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

3865: WHEN OTHERS THEN
3866: ROLLBACK to get_matching_party_sites ;
3867: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3868: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_party_sites');
3869: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3870: FND_MSG_PUB.ADD;
3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3872: END get_matching_party_sites;
3873:

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

4085: ROLLBACK to get_matching_contacts ;
4086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4087: WHEN OTHERS THEN
4088: ROLLBACK to get_matching_contacts ;
4089: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4090: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_contacts');
4091: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4092: FND_MSG_PUB.ADD;
4093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4090: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_contacts');

4086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4087: WHEN OTHERS THEN
4088: ROLLBACK to get_matching_contacts ;
4089: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4090: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_contacts');
4091: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4092: FND_MSG_PUB.ADD;
4093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4094: END get_matching_contacts;

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

4087: WHEN OTHERS THEN
4088: ROLLBACK to get_matching_contacts ;
4089: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4090: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_contacts');
4091: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4092: FND_MSG_PUB.ADD;
4093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4094: END get_matching_contacts;
4095:

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

4232: ROLLBACK to get_matching_contact_points ;
4233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4234: WHEN OTHERS THEN
4235: ROLLBACK to get_matching_contact_points ;
4236: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4237: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_contact_points');
4238: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4239: FND_MSG_PUB.ADD;
4240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4237: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_contact_points');

4233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4234: WHEN OTHERS THEN
4235: ROLLBACK to get_matching_contact_points ;
4236: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4237: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_contact_points');
4238: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4239: FND_MSG_PUB.ADD;
4240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4241: END get_matching_contact_points;

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

4234: WHEN OTHERS THEN
4235: ROLLBACK to get_matching_contact_points ;
4236: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4237: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_matching_contact_points');
4238: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4239: FND_MSG_PUB.ADD;
4240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4241: END get_matching_contact_points;
4242:

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

4460: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4461: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4462: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4463: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4465: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_score_details');
4466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4467: FND_MSG_PUB.ADD;
4468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4465: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_score_details');

4461: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4462: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4463: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4465: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_score_details');
4466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4467: FND_MSG_PUB.ADD;
4468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4469: END get_score_details;

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

4462: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4463: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4465: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_50.get_score_details');
4466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4467: FND_MSG_PUB.ADD;
4468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4469: END get_score_details;
4470:

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

4579: RAISE FND_API.G_EXC_ERROR;
4580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4582: WHEN OTHERS THEN
4583: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4584: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
4585: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4586: FND_MSG_PUB.ADD;
4587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4582: WHEN OTHERS THEN
4583: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4584: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
4585: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4586: FND_MSG_PUB.ADD;
4587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4588: END get_party_for_search;

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

4581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4582: WHEN OTHERS THEN
4583: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4584: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
4585: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4586: FND_MSG_PUB.ADD;
4587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4588: END get_party_for_search;
4589:

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

4631: RAISE FND_API.G_EXC_ERROR;
4632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4634: WHEN OTHERS THEN
4635: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4636: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
4637: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4638: FND_MSG_PUB.ADD;
4639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4634: WHEN OTHERS THEN
4635: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4636: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
4637: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4638: FND_MSG_PUB.ADD;
4639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4640: END get_search_criteria;

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

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

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

4699: END IF;
4700:
4701: EXCEPTION
4702: WHEN OTHERS THEN
4703: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4704: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
4705: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
4706: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4707: FND_MSG_PUB.ADD;

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

4700:
4701: EXCEPTION
4702: WHEN OTHERS THEN
4703: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4704: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
4705: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
4706: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4707: FND_MSG_PUB.ADD;
4708: RAISE FND_API.G_EXC_ERROR;

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

4701: EXCEPTION
4702: WHEN OTHERS THEN
4703: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4704: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
4705: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
4706: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4707: FND_MSG_PUB.ADD;
4708: RAISE FND_API.G_EXC_ERROR;
4709: END get_party_rec;

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

4702: WHEN OTHERS THEN
4703: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4704: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
4705: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
4706: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4707: FND_MSG_PUB.ADD;
4708: RAISE FND_API.G_EXC_ERROR;
4709: END get_party_rec;
4710:

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

4761: END LOOP;
4762:
4763: EXCEPTION
4764: WHEN OTHERS THEN
4765: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4766: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
4767: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
4768: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4769: FND_MSG_PUB.ADD;

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

4762:
4763: EXCEPTION
4764: WHEN OTHERS THEN
4765: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4766: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
4767: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
4768: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4769: FND_MSG_PUB.ADD;
4770: RAISE FND_API.G_EXC_ERROR;

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

4763: EXCEPTION
4764: WHEN OTHERS THEN
4765: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4766: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
4767: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
4768: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4769: FND_MSG_PUB.ADD;
4770: RAISE FND_API.G_EXC_ERROR;
4771: END get_party_site_rec;

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

4764: WHEN OTHERS THEN
4765: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4766: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
4767: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
4768: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4769: FND_MSG_PUB.ADD;
4770: RAISE FND_API.G_EXC_ERROR;
4771: END get_party_site_rec;
4772:

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

4821: END LOOP;
4822:
4823: EXCEPTION
4824: WHEN OTHERS THEN
4825: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4826: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
4827: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
4828: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4829: FND_MSG_PUB.ADD;

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

4822:
4823: EXCEPTION
4824: WHEN OTHERS THEN
4825: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4826: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
4827: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
4828: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4829: FND_MSG_PUB.ADD;
4830: RAISE FND_API.G_EXC_ERROR;

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

4823: EXCEPTION
4824: WHEN OTHERS THEN
4825: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4826: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
4827: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
4828: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4829: FND_MSG_PUB.ADD;
4830: RAISE FND_API.G_EXC_ERROR;
4831: END get_contact_rec;

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

4824: WHEN OTHERS THEN
4825: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4826: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
4827: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
4828: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4829: FND_MSG_PUB.ADD;
4830: RAISE FND_API.G_EXC_ERROR;
4831: END get_contact_rec;
4832:

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

4877: END LOOP;
4878:
4879: EXCEPTION
4880: WHEN OTHERS THEN
4881: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4882: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
4883: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
4884: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4885: FND_MSG_PUB.ADD;

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

4878:
4879: EXCEPTION
4880: WHEN OTHERS THEN
4881: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4882: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
4883: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
4884: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4885: FND_MSG_PUB.ADD;
4886: RAISE FND_API.G_EXC_ERROR;

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

4879: EXCEPTION
4880: WHEN OTHERS THEN
4881: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4882: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
4883: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
4884: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4885: FND_MSG_PUB.ADD;
4886: RAISE FND_API.G_EXC_ERROR;
4887: END get_contact_point_rec;

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

4880: WHEN OTHERS THEN
4881: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4882: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
4883: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
4884: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4885: FND_MSG_PUB.ADD;
4886: RAISE FND_API.G_EXC_ERROR;
4887: END get_contact_point_rec;
4888:

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

5006: 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);
5007: END IF;
5008: EXCEPTION
5009: WHEN OTHERS THEN
5010: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5011: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5012: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5013: FND_MSG_PUB.ADD;
5014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5007: END IF;
5008: EXCEPTION
5009: WHEN OTHERS THEN
5010: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5011: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5012: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5013: FND_MSG_PUB.ADD;
5014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5015: END;

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

5008: EXCEPTION
5009: WHEN OTHERS THEN
5010: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5011: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5012: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5013: FND_MSG_PUB.ADD;
5014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5015: END;
5016:

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

5159: END LOOP;
5160: END IF;
5161: EXCEPTION
5162: WHEN OTHERS THEN
5163: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5164: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5165: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5166: FND_MSG_PUB.ADD;
5167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5160: END IF;
5161: EXCEPTION
5162: WHEN OTHERS THEN
5163: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5164: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5165: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5166: FND_MSG_PUB.ADD;
5167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5168: END;

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

5161: EXCEPTION
5162: WHEN OTHERS THEN
5163: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5164: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5165: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5166: FND_MSG_PUB.ADD;
5167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5168: END;
5169:

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

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

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

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

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

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

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

5385: END LOOP;
5386: END IF;
5387: EXCEPTION
5388: WHEN OTHERS THEN
5389: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5390: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5391: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5392: FND_MSG_PUB.ADD;
5393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5386: END IF;
5387: EXCEPTION
5388: WHEN OTHERS THEN
5389: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5390: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5391: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5392: FND_MSG_PUB.ADD;
5393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5394: END;

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

5387: EXCEPTION
5388: WHEN OTHERS THEN
5389: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5390: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5391: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5392: FND_MSG_PUB.ADD;
5393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5394: END;
5395:

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

5412: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
5413: p_contact_point_list(I).RAW_PHONE_NUMBER IS NOT NULL
5414: OR p_contact_point_list(I).URL IS NOT NULL
5415: ) THEN
5416: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5417: FND_MSG_PUB.ADD;
5418: RAISE FND_API.G_EXC_ERROR;
5419: END IF;
5420: END LOOP;

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

5452: EXCEPTION
5453: WHEN FND_API.G_EXC_ERROR THEN
5454: RAISE FND_API.G_EXC_ERROR;
5455: WHEN OTHERS THEN
5456: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5457: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5458: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5459: FND_MSG_PUB.ADD;
5460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5453: WHEN FND_API.G_EXC_ERROR THEN
5454: RAISE FND_API.G_EXC_ERROR;
5455: WHEN OTHERS THEN
5456: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5457: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5458: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5459: FND_MSG_PUB.ADD;
5460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5461: END check_prim_cond;

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

5454: RAISE FND_API.G_EXC_ERROR;
5455: WHEN OTHERS THEN
5456: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5457: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5458: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5459: FND_MSG_PUB.ADD;
5460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5461: END check_prim_cond;
5462:

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

5510: EXIT WHEN x_secondary;
5511: END LOOP;
5512: EXCEPTION
5513: WHEN OTHERS THEN
5514: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5515: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5516: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5517: FND_MSG_PUB.ADD;
5518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5511: END LOOP;
5512: EXCEPTION
5513: WHEN OTHERS THEN
5514: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5515: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5516: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5517: FND_MSG_PUB.ADD;
5518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5519: END check_party_site_cond;

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

5512: EXCEPTION
5513: WHEN OTHERS THEN
5514: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5515: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5516: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5517: FND_MSG_PUB.ADD;
5518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5519: END check_party_site_cond;
5520:

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

5567: EXIT WHEN x_secondary;
5568: END LOOP;
5569: EXCEPTION
5570: WHEN OTHERS THEN
5571: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5572: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5573: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5574: FND_MSG_PUB.ADD;
5575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5568: END LOOP;
5569: EXCEPTION
5570: WHEN OTHERS THEN
5571: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5572: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5573: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5574: FND_MSG_PUB.ADD;
5575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5576: END check_contact_cond;

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

5569: EXCEPTION
5570: WHEN OTHERS THEN
5571: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5572: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5573: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5574: FND_MSG_PUB.ADD;
5575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5576: END check_contact_cond;
5577:

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

5590: x_secondary:= FALSE;
5591:
5592: FOR I IN 1..p_contact_point_list.COUNT LOOP
5593: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5594: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5595: FND_MSG_PUB.ADD;
5596: RAISE FND_API.G_EXC_ERROR;
5597: END IF;
5598: END LOOP;

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

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

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

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

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

5616: EXCEPTION
5617: WHEN OTHERS THEN
5618: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5619: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5620: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5621: FND_MSG_PUB.ADD;
5622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5623: END check_contact_point_cond;
5624: