eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MATCH_RULE_52 dependencies on FND_MSG_PUB

Line 71: FND_MSG_PUB.ADD;

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:
75: /************************************************

Line 101: FND_MSG_PUB.ADD;

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:
105: /************************************************

Line 130: FND_MSG_PUB.ADD;

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:
134: /************************************************

Line 161: FND_MSG_PUB.ADD;

157: WHEN OTHERS THEN
158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
159: FND_MESSAGE.SET_TOKEN('PROC','check_cpts_bulk');
160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
161: FND_MSG_PUB.ADD;
162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
163: END check_cpts_bulk ;
164:
165: FUNCTION map_id (in_id NUMBER) RETURN NUMBER IS

Line 948: FND_MSG_PUB.ADD;

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

Line 973: FND_MSG_PUB.ADD;

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

Line 993: FND_MSG_PUB.ADD;

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

Line 1013: FND_MSG_PUB.ADD;

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

Line 1069: FND_MSG_PUB.ADD;

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

Line 1266: FND_MSG_PUB.ADD;

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

Line 1363: FND_MSG_PUB.ADD;

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

Line 1464: FND_MSG_PUB.ADD;

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

Line 1605: FND_MSG_PUB.ADD;

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

Line 1820: FND_MSG_PUB.ADD;

1816: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1817: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1818: END IF;
1819: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1820: FND_MSG_PUB.ADD;
1821: RAISE FND_API.G_EXC_ERROR;
1822: ELSE
1823: push_eval;
1824: RETURN;

Line 1889: FND_MSG_PUB.ADD;

1885: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1886: hz_utility_v2pub.debug(p_message=>'In eval party site level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1887: END IF;
1888: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1889: FND_MSG_PUB.ADD;
1890: RAISE FND_API.G_EXC_ERROR;
1891: ELSE
1892: push_eval;
1893: RETURN;

Line 1965: FND_MSG_PUB.ADD;

1961: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1962: hz_utility_v2pub.debug(p_message=>'In eval contact level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1963: END IF;
1964: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
1965: FND_MSG_PUB.ADD;
1966: RAISE FND_API.G_EXC_ERROR;
1967: ELSE
1968: push_eval;
1969: RETURN;

Line 2041: FND_MSG_PUB.ADD;

2037: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2038: hz_utility_v2pub.debug(p_message=>'In eval contact point level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2039: END IF;
2040: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2041: FND_MSG_PUB.ADD;
2042: RAISE FND_API.G_EXC_ERROR;
2043: ELSE
2044: push_eval;
2045: RETURN;

Line 2085: FND_MSG_PUB.ADD;

2081: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2082: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2083: END IF;
2084: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2085: FND_MSG_PUB.ADD;
2086: RAISE FND_API.G_EXC_ERROR;
2087: END IF;
2088: END IF;
2089: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 2275: FND_MSG_PUB.ADD;

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

Line 2484: FND_MSG_PUB.ADD;

2480: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2481: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2482: END IF;
2483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2484: FND_MSG_PUB.ADD;
2485: RAISE FND_API.G_EXC_ERROR;
2486: ELSE
2487: push_eval;
2488: RETURN;

Line 2520: FND_MSG_PUB.ADD;

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

Line 2524: FND_MSG_PUB.ADD;

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

Line 2600: FND_MSG_PUB.ADD;

2596: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2597: hz_utility_v2pub.debug(p_message=>'In eval party site level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2598: END IF;
2599: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2600: FND_MSG_PUB.ADD;
2601: RAISE FND_API.G_EXC_ERROR;
2602: ELSE
2603: push_eval;
2604: RETURN;

Line 2737: FND_MSG_PUB.ADD;

2733: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2734: hz_utility_v2pub.debug(p_message=>'In eval contact point level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2735: END IF;
2736: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2737: FND_MSG_PUB.ADD;
2738: RAISE FND_API.G_EXC_ERROR;
2739: ELSE
2740: push_eval;
2741: RETURN;

Line 2786: FND_MSG_PUB.ADD;

2782: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2783: hz_utility_v2pub.debug(p_message=>'In do eval number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2784: END IF;
2785: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2786: FND_MSG_PUB.ADD;
2787: RAISE FND_API.G_EXC_ERROR;
2788: END IF;
2789: END IF;
2790: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 2930: FND_MSG_PUB.ADD;

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

Line 3000: FND_MSG_PUB.ADD;

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

Line 3088: FND_MSG_PUB.ADD;

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

Line 3176: FND_MSG_PUB.ADD;

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

Line 3268: FND_MSG_PUB.ADD;

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

Line 3344: FND_MSG_PUB.ADD;

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

Line 3735: FND_MSG_PUB.ADD;

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

Line 3963: FND_MSG_PUB.ADD;

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

Line 4186: FND_MSG_PUB.ADD;

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

Line 4334: FND_MSG_PUB.ADD;

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

Line 4565: FND_MSG_PUB.ADD;

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

Line 4684: FND_MSG_PUB.ADD;

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

Line 4736: FND_MSG_PUB.ADD;

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

Line 4805: FND_MSG_PUB.ADD;

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

Line 4867: FND_MSG_PUB.ADD;

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

Line 4927: FND_MSG_PUB.ADD;

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

Line 4985: FND_MSG_PUB.ADD;

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

Line 5113: FND_MSG_PUB.ADD;

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

Line 5266: FND_MSG_PUB.ADD;

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

Line 5367: FND_MSG_PUB.ADD;

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

Line 5485: FND_MSG_PUB.ADD;

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

Line 5511: FND_MSG_PUB.ADD;

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

Line 5558: FND_MSG_PUB.ADD;

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

Line 5618: FND_MSG_PUB.ADD;

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

Line 5677: FND_MSG_PUB.ADD;

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

Line 5698: FND_MSG_PUB.ADD;

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

Line 5726: FND_MSG_PUB.ADD;

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