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_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 160: FND_MSG_PUB.ADD;

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:
164: FUNCTION map_id (in_id NUMBER) RETURN NUMBER IS

Line 902: FND_MSG_PUB.ADD;

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

Line 927: FND_MSG_PUB.ADD;

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

Line 947: FND_MSG_PUB.ADD;

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

Line 967: FND_MSG_PUB.ADD;

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:
971: PROCEDURE init_score_context (

Line 1023: FND_MSG_PUB.ADD;

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;
1027: g_mappings.DELETE;

Line 1220: FND_MSG_PUB.ADD;

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;
1224: end if;

Line 1317: FND_MSG_PUB.ADD;

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;
1321: end if;

Line 1418: FND_MSG_PUB.ADD;

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;
1422: end if;

Line 1539: FND_MSG_PUB.ADD;

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;
1543: end if;

Line 1753: FND_MSG_PUB.ADD;

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;
1757: RETURN;

Line 1822: FND_MSG_PUB.ADD;

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;
1826: RETURN;

Line 1898: FND_MSG_PUB.ADD;

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;
1902: RETURN;

Line 1974: FND_MSG_PUB.ADD;

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;
1978: RETURN;

Line 2018: FND_MSG_PUB.ADD;

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;
2022: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 2208: FND_MSG_PUB.ADD;

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

Line 2416: FND_MSG_PUB.ADD;

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;
2420: RETURN;

Line 2452: FND_MSG_PUB.ADD;

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');
2456: FND_MSG_PUB.ADD;

Line 2456: FND_MSG_PUB.ADD;

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;
2460: end if;

Line 2532: FND_MSG_PUB.ADD;

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;
2536: RETURN;

Line 2669: FND_MSG_PUB.ADD;

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;
2673: RETURN;

Line 2718: FND_MSG_PUB.ADD;

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;
2722: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 2862: FND_MSG_PUB.ADD;

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 (
2866: p_rule_id IN NUMBER,

Line 2932: FND_MSG_PUB.ADD;

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

Line 3020: FND_MSG_PUB.ADD;

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

Line 3108: FND_MSG_PUB.ADD;

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

Line 3200: FND_MSG_PUB.ADD;

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

Line 3276: FND_MSG_PUB.ADD;

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

Line 3643: FND_MSG_PUB.ADD;

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

Line 3870: FND_MSG_PUB.ADD;

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

Line 4092: FND_MSG_PUB.ADD;

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

Line 4239: FND_MSG_PUB.ADD;

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

Line 4467: FND_MSG_PUB.ADD;

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

Line 4586: FND_MSG_PUB.ADD;

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:
4590: PROCEDURE get_search_criteria (

Line 4638: FND_MSG_PUB.ADD;

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

Line 4707: FND_MSG_PUB.ADD;

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

Line 4769: FND_MSG_PUB.ADD;

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

Line 4829: FND_MSG_PUB.ADD;

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

Line 4885: FND_MSG_PUB.ADD;

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

Line 5013: FND_MSG_PUB.ADD;

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

Line 5166: FND_MSG_PUB.ADD;

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

Line 5267: FND_MSG_PUB.ADD;

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

Line 5392: FND_MSG_PUB.ADD;

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

Line 5417: FND_MSG_PUB.ADD;

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;
5421:

Line 5459: FND_MSG_PUB.ADD;

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

Line 5517: FND_MSG_PUB.ADD;

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

Line 5574: FND_MSG_PUB.ADD;

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

Line 5595: FND_MSG_PUB.ADD;

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;
5599:

Line 5621: FND_MSG_PUB.ADD;

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:
5625: FUNCTION check_staged RETURN BOOLEAN IS