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

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

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

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

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

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

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

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

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

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

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

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

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

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

116:
117: IF x_primary = TRUE THEN RETURN 'Y'; ELSE RETURN null; END IF;
118: EXCEPTION
119: WHEN OTHERS THEN
120: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
121: FND_MESSAGE.SET_TOKEN('PROC','check_contacts_bulk');
122: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
123: FND_MSG_PUB.ADD;
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

117: IF x_primary = TRUE THEN RETURN 'Y'; ELSE RETURN null; END IF;
118: EXCEPTION
119: WHEN OTHERS THEN
120: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
121: FND_MESSAGE.SET_TOKEN('PROC','check_contacts_bulk');
122: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
123: FND_MSG_PUB.ADD;
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: END check_contacts_bulk ;

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

118: EXCEPTION
119: WHEN OTHERS THEN
120: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
121: FND_MESSAGE.SET_TOKEN('PROC','check_contacts_bulk');
122: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
123: FND_MSG_PUB.ADD;
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: END check_contacts_bulk ;
126:

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

146:
147: IF x_primary = TRUE THEN RETURN 'Y'; ELSE RETURN null; END IF;
148: EXCEPTION
149: WHEN OTHERS THEN
150: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
151: FND_MESSAGE.SET_TOKEN('PROC','check_cpts_bulk');
152: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
153: FND_MSG_PUB.ADD;
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

147: IF x_primary = TRUE THEN RETURN 'Y'; ELSE RETURN null; END IF;
148: EXCEPTION
149: WHEN OTHERS THEN
150: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
151: FND_MESSAGE.SET_TOKEN('PROC','check_cpts_bulk');
152: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
153: FND_MSG_PUB.ADD;
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END check_cpts_bulk ;

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

148: EXCEPTION
149: WHEN OTHERS THEN
150: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
151: FND_MESSAGE.SET_TOKEN('PROC','check_cpts_bulk');
152: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
153: FND_MSG_PUB.ADD;
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END check_cpts_bulk ;
156:

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

731: BEGIN
732: NULL ;
733: EXCEPTION
734: WHEN OTHERS THEN
735: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
736: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
737: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
738: FND_MSG_PUB.ADD;
739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

732: NULL ;
733: EXCEPTION
734: WHEN OTHERS THEN
735: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
736: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
737: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
738: FND_MSG_PUB.ADD;
739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
740: END;

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

733: EXCEPTION
734: WHEN OTHERS THEN
735: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
736: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
737: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
738: FND_MSG_PUB.ADD;
739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
740: END;
741:

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

756: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,p_search_list(1).COUNTRY);
757: END IF ;
758: EXCEPTION
759: WHEN OTHERS THEN
760: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
761: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
762: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
763: FND_MSG_PUB.ADD;
764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

757: END IF ;
758: EXCEPTION
759: WHEN OTHERS THEN
760: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
761: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
762: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
763: FND_MSG_PUB.ADD;
764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
765: END;

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

758: EXCEPTION
759: WHEN OTHERS THEN
760: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
761: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
762: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
763: FND_MSG_PUB.ADD;
764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
765: END;
766:

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

776: BEGIN
777: NULL ;
778: EXCEPTION
779: WHEN OTHERS THEN
780: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
781: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
782: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
783: FND_MSG_PUB.ADD;
784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

777: NULL ;
778: EXCEPTION
779: WHEN OTHERS THEN
780: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
781: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
782: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
783: FND_MSG_PUB.ADD;
784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
785: END;

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

778: EXCEPTION
779: WHEN OTHERS THEN
780: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
781: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
782: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
783: FND_MSG_PUB.ADD;
784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
785: END;
786:

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

796: BEGIN
797: NULL ;
798: EXCEPTION
799: WHEN OTHERS THEN
800: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
801: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
802: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
803: FND_MSG_PUB.ADD;
804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

797: NULL ;
798: EXCEPTION
799: WHEN OTHERS THEN
800: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
801: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
802: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
803: FND_MSG_PUB.ADD;
804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805: END;

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

798: EXCEPTION
799: WHEN OTHERS THEN
800: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
801: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
802: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
803: FND_MSG_PUB.ADD;
804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805: END;
806:

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

854: IF NOT check_prim_cond (p_party_search_rec,
855: p_party_site_list,
856: p_contact_list,
857: p_contact_point_list) THEN
858: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
859: FND_MSG_PUB.ADD;
860: RAISE FND_API.G_EXC_ERROR;
861: END IF;
862: HZ_DQM_SEARCH_UTIL.set_score;

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

1034: END IF;
1035: exception
1036: when others then
1037: if (instrb(SQLERRM,'DRG-51030')>0) then
1038: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1039: FND_MSG_PUB.ADD;
1040: RAISE FND_API.G_EXC_ERROR;
1041: else
1042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1130: END IF;
1131: exception
1132: when others then
1133: if (instrb(SQLERRM,'DRG-51030')>0) then
1134: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1135: FND_MSG_PUB.ADD;
1136: RAISE FND_API.G_EXC_ERROR;
1137: else
1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

1474: IF p_index>1 THEN
1475: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1476: 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);
1477: END IF;
1478: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1479: FND_MSG_PUB.ADD;
1480: RAISE FND_API.G_EXC_ERROR;
1481: ELSE
1482: push_eval;

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

1543: IF p_index>1 THEN
1544: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1545: 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);
1546: END IF;
1547: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1548: FND_MSG_PUB.ADD;
1549: RAISE FND_API.G_EXC_ERROR;
1550: ELSE
1551: push_eval;

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

1619: IF p_index>1 THEN
1620: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1621: 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);
1622: END IF;
1623: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1624: FND_MSG_PUB.ADD;
1625: RAISE FND_API.G_EXC_ERROR;
1626: ELSE
1627: push_eval;

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

1695: IF p_index>1 THEN
1696: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1697: 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);
1698: END IF;
1699: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1700: FND_MSG_PUB.ADD;
1701: RAISE FND_API.G_EXC_ERROR;
1702: ELSE
1703: push_eval;

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

1739: ELSE
1740: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1741: 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);
1742: END IF;
1743: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1744: FND_MSG_PUB.ADD;
1745: RAISE FND_API.G_EXC_ERROR;
1746: END IF;
1747: END IF;

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

1927: ROLLBACK to find_parties;
1928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1929: WHEN OTHERS THEN
1930: ROLLBACK to find_parties;
1931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1932: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_parties');
1933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
1934: FND_MSG_PUB.ADD;
1935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1932: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_parties');

1928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1929: WHEN OTHERS THEN
1930: ROLLBACK to find_parties;
1931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1932: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_parties');
1933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
1934: FND_MSG_PUB.ADD;
1935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1936: END find_parties;

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

1929: WHEN OTHERS THEN
1930: ROLLBACK to find_parties;
1931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
1932: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_parties');
1933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
1934: FND_MSG_PUB.ADD;
1935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1936: END find_parties;
1937:

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

2135: IF p_index>1 THEN
2136: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2137: 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);
2138: END IF;
2139: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2140: FND_MSG_PUB.ADD;
2141: RAISE FND_API.G_EXC_ERROR;
2142: ELSE
2143: push_eval;

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

2171: and d.search_context_id = p_search_ctx_id);
2172: exception
2173: when others then
2174: if (instrb(SQLERRM,'DRG-51030')>0) then
2175: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2176: FND_MSG_PUB.ADD;
2177: RAISE FND_API.G_EXC_ERROR;
2178: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2179: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2175: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2176: FND_MSG_PUB.ADD;
2177: RAISE FND_API.G_EXC_ERROR;
2178: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2179: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2180: FND_MSG_PUB.ADD;
2181: RAISE FND_API.G_EXC_ERROR;
2182: else
2183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2251: IF p_index>1 THEN
2252: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2253: 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);
2254: END IF;
2255: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2256: FND_MSG_PUB.ADD;
2257: RAISE FND_API.G_EXC_ERROR;
2258: ELSE
2259: push_eval;

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

2388: IF p_index>1 THEN
2389: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2390: 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);
2391: END IF;
2392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2393: FND_MSG_PUB.ADD;
2394: RAISE FND_API.G_EXC_ERROR;
2395: ELSE
2396: push_eval;

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

2437: ELSE
2438: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2439: 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);
2440: END IF;
2441: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2442: FND_MSG_PUB.ADD;
2443: RAISE FND_API.G_EXC_ERROR;
2444: END IF;
2445: END IF;

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

2579: ROLLBACK to find_persons;
2580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2581: WHEN OTHERS THEN
2582: ROLLBACK to find_persons;
2583: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2584: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_persons');
2585: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2586: FND_MSG_PUB.ADD;
2587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2584: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_persons');

2580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2581: WHEN OTHERS THEN
2582: ROLLBACK to find_persons;
2583: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2584: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_persons');
2585: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2586: FND_MSG_PUB.ADD;
2587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2588: END find_persons;

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

2581: WHEN OTHERS THEN
2582: ROLLBACK to find_persons;
2583: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2584: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_persons');
2585: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2586: FND_MSG_PUB.ADD;
2587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2588: END find_persons;
2589: PROCEDURE find_persons (

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

2649: RAISE FND_API.G_EXC_ERROR;
2650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2652: WHEN OTHERS THEN
2653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2654: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_party_details');
2655: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2656: FND_MSG_PUB.ADD;
2657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2654: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_party_details');

2650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2652: WHEN OTHERS THEN
2653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2654: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_party_details');
2655: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2656: FND_MSG_PUB.ADD;
2657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2658: END find_party_details;

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

2651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2652: WHEN OTHERS THEN
2653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2654: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_party_details');
2655: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2656: FND_MSG_PUB.ADD;
2657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2658: END find_party_details;
2659:

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

2737: RAISE FND_API.G_EXC_ERROR;
2738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2740: WHEN OTHERS THEN
2741: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2742: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_parties');
2743: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2744: FND_MSG_PUB.ADD;
2745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2742: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_parties');

2738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2740: WHEN OTHERS THEN
2741: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2742: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_parties');
2743: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2744: FND_MSG_PUB.ADD;
2745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2746: END find_duplicate_parties;

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

2739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2740: WHEN OTHERS THEN
2741: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2742: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_parties');
2743: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2744: FND_MSG_PUB.ADD;
2745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2746: END find_duplicate_parties;
2747:

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

2825: RAISE FND_API.G_EXC_ERROR;
2826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2828: WHEN OTHERS THEN
2829: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2830: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_party_sites');
2831: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2832: FND_MSG_PUB.ADD;
2833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2830: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_party_sites');

2826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2828: WHEN OTHERS THEN
2829: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2830: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_party_sites');
2831: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2832: FND_MSG_PUB.ADD;
2833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2834: END find_duplicate_party_sites;

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

2827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2828: WHEN OTHERS THEN
2829: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2830: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_party_sites');
2831: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2832: FND_MSG_PUB.ADD;
2833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2834: END find_duplicate_party_sites;
2835:

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

2917: RAISE FND_API.G_EXC_ERROR;
2918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2920: WHEN OTHERS THEN
2921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2922: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_contacts');
2923: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2924: FND_MSG_PUB.ADD;
2925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2922: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_contacts');

2918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2920: WHEN OTHERS THEN
2921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2922: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_contacts');
2923: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2924: FND_MSG_PUB.ADD;
2925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2926: END find_duplicate_contacts;

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

2919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2920: WHEN OTHERS THEN
2921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2922: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.find_duplicate_contacts');
2923: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2924: FND_MSG_PUB.ADD;
2925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2926: END find_duplicate_contacts;
2927:

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_51.find_duplicate_contact_points');
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_51.find_duplicate_contact_points');

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_51.find_duplicate_contact_points');
2999: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3000: FND_MSG_PUB.ADD;
3001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3002: END find_duplicate_contact_points;

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_51.find_duplicate_contact_points');
2999: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3000: FND_MSG_PUB.ADD;
3001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3002: END find_duplicate_contact_points;
3003:

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

3332: RAISE FND_API.G_EXC_ERROR;
3333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3335: WHEN OTHERS THEN
3336: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3337: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.call_api_dynamic');
3338: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3339: FND_MSG_PUB.ADD;
3340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3337: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.call_api_dynamic');

3333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3335: WHEN OTHERS THEN
3336: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3337: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.call_api_dynamic');
3338: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3339: FND_MSG_PUB.ADD;
3340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3341: END call_api_dynamic;

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

3334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3335: WHEN OTHERS THEN
3336: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3337: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.call_api_dynamic');
3338: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3339: FND_MSG_PUB.ADD;
3340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3341: END call_api_dynamic;
3342:

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

3559: ROLLBACK to get_matching_party_sites ;
3560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3561: WHEN OTHERS THEN
3562: ROLLBACK to get_matching_party_sites ;
3563: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3564: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_party_sites');
3565: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3566: FND_MSG_PUB.ADD;
3567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3564: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_party_sites');

3560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3561: WHEN OTHERS THEN
3562: ROLLBACK to get_matching_party_sites ;
3563: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3564: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_party_sites');
3565: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3566: FND_MSG_PUB.ADD;
3567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3568: END get_matching_party_sites;

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

3561: WHEN OTHERS THEN
3562: ROLLBACK to get_matching_party_sites ;
3563: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3564: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_party_sites');
3565: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3566: FND_MSG_PUB.ADD;
3567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3568: END get_matching_party_sites;
3569:

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

3778: ROLLBACK to get_matching_contacts ;
3779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3780: WHEN OTHERS THEN
3781: ROLLBACK to get_matching_contacts ;
3782: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3783: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_contacts');
3784: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3785: FND_MSG_PUB.ADD;
3786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3783: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_contacts');

3779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3780: WHEN OTHERS THEN
3781: ROLLBACK to get_matching_contacts ;
3782: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3783: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_contacts');
3784: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3785: FND_MSG_PUB.ADD;
3786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3787: END get_matching_contacts;

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

3780: WHEN OTHERS THEN
3781: ROLLBACK to get_matching_contacts ;
3782: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3783: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_contacts');
3784: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3785: FND_MSG_PUB.ADD;
3786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3787: END get_matching_contacts;
3788:

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

3925: ROLLBACK to get_matching_contact_points ;
3926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3927: WHEN OTHERS THEN
3928: ROLLBACK to get_matching_contact_points ;
3929: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3930: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_contact_points');
3931: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3932: FND_MSG_PUB.ADD;
3933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3930: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_contact_points');

3926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3927: WHEN OTHERS THEN
3928: ROLLBACK to get_matching_contact_points ;
3929: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3930: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_contact_points');
3931: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3932: FND_MSG_PUB.ADD;
3933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3934: END get_matching_contact_points;

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

3927: WHEN OTHERS THEN
3928: ROLLBACK to get_matching_contact_points ;
3929: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3930: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_matching_contact_points');
3931: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3932: FND_MSG_PUB.ADD;
3933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3934: END get_matching_contact_points;
3935:

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

4146: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4147: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4148: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4149: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4150: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4151: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_score_details');
4152: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4153: FND_MSG_PUB.ADD;
4154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4151: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_score_details');

4147: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4148: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4149: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4150: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4151: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_score_details');
4152: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4153: FND_MSG_PUB.ADD;
4154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4155: END get_score_details;

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

4148: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4149: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4150: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4151: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_51.get_score_details');
4152: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4153: FND_MSG_PUB.ADD;
4154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4155: END get_score_details;
4156:

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

4253: RAISE FND_API.G_EXC_ERROR;
4254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4256: WHEN OTHERS THEN
4257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4258: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
4259: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4260: FND_MSG_PUB.ADD;
4261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4256: WHEN OTHERS THEN
4257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4258: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
4259: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4260: FND_MSG_PUB.ADD;
4261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4262: END get_party_for_search;

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

4255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4256: WHEN OTHERS THEN
4257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4258: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
4259: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4260: FND_MSG_PUB.ADD;
4261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4262: END get_party_for_search;
4263:

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

4299: RAISE FND_API.G_EXC_ERROR;
4300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4302: WHEN OTHERS THEN
4303: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4304: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
4305: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4306: FND_MSG_PUB.ADD;
4307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4302: WHEN OTHERS THEN
4303: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4304: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
4305: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4306: FND_MSG_PUB.ADD;
4307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4308: END get_search_criteria;

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

4301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4302: WHEN OTHERS THEN
4303: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4304: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
4305: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4306: FND_MSG_PUB.ADD;
4307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4308: END get_search_criteria;
4309:

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

4363: END IF;
4364:
4365: EXCEPTION
4366: WHEN OTHERS THEN
4367: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4368: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
4369: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
4370: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4371: FND_MSG_PUB.ADD;

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

4364:
4365: EXCEPTION
4366: WHEN OTHERS THEN
4367: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4368: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
4369: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
4370: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4371: FND_MSG_PUB.ADD;
4372: RAISE FND_API.G_EXC_ERROR;

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

4365: EXCEPTION
4366: WHEN OTHERS THEN
4367: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4368: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
4369: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
4370: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4371: FND_MSG_PUB.ADD;
4372: RAISE FND_API.G_EXC_ERROR;
4373: END get_party_rec;

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

4366: WHEN OTHERS THEN
4367: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4368: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
4369: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
4370: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4371: FND_MSG_PUB.ADD;
4372: RAISE FND_API.G_EXC_ERROR;
4373: END get_party_rec;
4374:

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

4425: END LOOP;
4426:
4427: EXCEPTION
4428: WHEN OTHERS THEN
4429: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4430: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
4431: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
4432: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4433: FND_MSG_PUB.ADD;

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

4426:
4427: EXCEPTION
4428: WHEN OTHERS THEN
4429: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4430: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
4431: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
4432: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4433: FND_MSG_PUB.ADD;
4434: RAISE FND_API.G_EXC_ERROR;

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

4427: EXCEPTION
4428: WHEN OTHERS THEN
4429: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4430: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
4431: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
4432: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4433: FND_MSG_PUB.ADD;
4434: RAISE FND_API.G_EXC_ERROR;
4435: END get_party_site_rec;

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

4428: WHEN OTHERS THEN
4429: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4430: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
4431: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
4432: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4433: FND_MSG_PUB.ADD;
4434: RAISE FND_API.G_EXC_ERROR;
4435: END get_party_site_rec;
4436:

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

4481: END LOOP;
4482:
4483: EXCEPTION
4484: WHEN OTHERS THEN
4485: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4486: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
4487: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
4488: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4489: FND_MSG_PUB.ADD;

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

4482:
4483: EXCEPTION
4484: WHEN OTHERS THEN
4485: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4486: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
4487: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
4488: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4489: FND_MSG_PUB.ADD;
4490: RAISE FND_API.G_EXC_ERROR;

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

4483: EXCEPTION
4484: WHEN OTHERS THEN
4485: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4486: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
4487: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
4488: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4489: FND_MSG_PUB.ADD;
4490: RAISE FND_API.G_EXC_ERROR;
4491: END get_contact_rec;

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

4484: WHEN OTHERS THEN
4485: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4486: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
4487: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
4488: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4489: FND_MSG_PUB.ADD;
4490: RAISE FND_API.G_EXC_ERROR;
4491: END get_contact_rec;
4492:

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

4537: END LOOP;
4538:
4539: EXCEPTION
4540: WHEN OTHERS THEN
4541: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4542: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
4543: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
4544: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4545: FND_MSG_PUB.ADD;

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

4538:
4539: EXCEPTION
4540: WHEN OTHERS THEN
4541: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4542: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
4543: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
4544: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4545: FND_MSG_PUB.ADD;
4546: RAISE FND_API.G_EXC_ERROR;

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

4539: EXCEPTION
4540: WHEN OTHERS THEN
4541: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4542: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
4543: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
4544: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4545: FND_MSG_PUB.ADD;
4546: RAISE FND_API.G_EXC_ERROR;
4547: END get_contact_point_rec;

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

4540: WHEN OTHERS THEN
4541: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
4542: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
4543: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
4544: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4545: FND_MSG_PUB.ADD;
4546: RAISE FND_API.G_EXC_ERROR;
4547: END get_contact_point_rec;
4548:

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

4641: insert into HZ_SRCH_PARTIES(batch_id,party_id, party_osr,party_os,TX45,TX59,TX2,TX36) values(-1,-1,-1,-1,x_stage_rec.TX45,x_stage_rec.TX59,x_stage_rec.TX2,x_stage_rec.TX36);
4642: END IF;
4643: EXCEPTION
4644: WHEN OTHERS THEN
4645: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
4646: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
4647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4648: FND_MSG_PUB.ADD;
4649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4642: END IF;
4643: EXCEPTION
4644: WHEN OTHERS THEN
4645: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
4646: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
4647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4648: FND_MSG_PUB.ADD;
4649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4650: END;

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

4643: EXCEPTION
4644: WHEN OTHERS THEN
4645: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
4646: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
4647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4648: FND_MSG_PUB.ADD;
4649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4650: END;
4651:

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

4794: END LOOP;
4795: END IF;
4796: EXCEPTION
4797: WHEN OTHERS THEN
4798: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
4799: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
4800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4801: FND_MSG_PUB.ADD;
4802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4795: END IF;
4796: EXCEPTION
4797: WHEN OTHERS THEN
4798: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
4799: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
4800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4801: FND_MSG_PUB.ADD;
4802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4803: END;

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

4796: EXCEPTION
4797: WHEN OTHERS THEN
4798: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
4799: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
4800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4801: FND_MSG_PUB.ADD;
4802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4803: END;
4804:

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

4836: END IF;
4837: NULL;
4838: EXCEPTION
4839: WHEN OTHERS THEN
4840: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
4841: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
4842: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4843: FND_MSG_PUB.ADD;
4844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4837: NULL;
4838: EXCEPTION
4839: WHEN OTHERS THEN
4840: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
4841: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
4842: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4843: FND_MSG_PUB.ADD;
4844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4845: END;

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

4838: EXCEPTION
4839: WHEN OTHERS THEN
4840: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
4841: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
4842: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4843: FND_MSG_PUB.ADD;
4844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4845: END;
4846:

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

4938: END LOOP;
4939: END IF;
4940: EXCEPTION
4941: WHEN OTHERS THEN
4942: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
4943: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
4944: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4945: FND_MSG_PUB.ADD;
4946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4939: END IF;
4940: EXCEPTION
4941: WHEN OTHERS THEN
4942: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
4943: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
4944: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4945: FND_MSG_PUB.ADD;
4946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4947: END;

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

4940: EXCEPTION
4941: WHEN OTHERS THEN
4942: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
4943: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
4944: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4945: FND_MSG_PUB.ADD;
4946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4947: END;
4948:

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

4965: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
4966: p_contact_point_list(I).RAW_PHONE_NUMBER IS NOT NULL
4967: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
4968: ) THEN
4969: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
4970: FND_MSG_PUB.ADD;
4971: RAISE FND_API.G_EXC_ERROR;
4972: END IF;
4973: END LOOP;

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

4997: EXCEPTION
4998: WHEN FND_API.G_EXC_ERROR THEN
4999: RAISE FND_API.G_EXC_ERROR;
5000: WHEN OTHERS THEN
5001: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5002: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5003: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5004: FND_MSG_PUB.ADD;
5005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4998: WHEN FND_API.G_EXC_ERROR THEN
4999: RAISE FND_API.G_EXC_ERROR;
5000: WHEN OTHERS THEN
5001: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5002: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5003: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5004: FND_MSG_PUB.ADD;
5005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5006: END check_prim_cond;

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

4999: RAISE FND_API.G_EXC_ERROR;
5000: WHEN OTHERS THEN
5001: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5002: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5003: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5004: FND_MSG_PUB.ADD;
5005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5006: END check_prim_cond;
5007:

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

5055: EXIT WHEN x_secondary;
5056: END LOOP;
5057: EXCEPTION
5058: WHEN OTHERS THEN
5059: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5060: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5061: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5062: FND_MSG_PUB.ADD;
5063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5056: END LOOP;
5057: EXCEPTION
5058: WHEN OTHERS THEN
5059: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5060: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5061: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5062: FND_MSG_PUB.ADD;
5063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5064: END check_party_site_cond;

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

5057: EXCEPTION
5058: WHEN OTHERS THEN
5059: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5060: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5061: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5062: FND_MSG_PUB.ADD;
5063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5064: END check_party_site_cond;
5065:

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

5103: EXIT WHEN x_secondary;
5104: END LOOP;
5105: EXCEPTION
5106: WHEN OTHERS THEN
5107: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5108: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5109: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5110: FND_MSG_PUB.ADD;
5111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5104: END LOOP;
5105: EXCEPTION
5106: WHEN OTHERS THEN
5107: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5108: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5109: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5110: FND_MSG_PUB.ADD;
5111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5112: END check_contact_cond;

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

5105: EXCEPTION
5106: WHEN OTHERS THEN
5107: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5108: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5109: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5110: FND_MSG_PUB.ADD;
5111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5112: END check_contact_cond;
5113:

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

5126: x_secondary:= FALSE;
5127:
5128: FOR I IN 1..p_contact_point_list.COUNT LOOP
5129: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5130: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5131: FND_MSG_PUB.ADD;
5132: RAISE FND_API.G_EXC_ERROR;
5133: END IF;
5134: END LOOP;

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

5150: EXIT WHEN x_secondary;
5151: END LOOP;
5152: EXCEPTION
5153: WHEN OTHERS THEN
5154: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5155: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5156: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5157: FND_MSG_PUB.ADD;
5158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5151: END LOOP;
5152: EXCEPTION
5153: WHEN OTHERS THEN
5154: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5155: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5156: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5157: FND_MSG_PUB.ADD;
5158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5159: END check_contact_point_cond;

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

5152: EXCEPTION
5153: WHEN OTHERS THEN
5154: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5155: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5156: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5157: FND_MSG_PUB.ADD;
5158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5159: END check_contact_point_cond;
5160: