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_MSG_PUB

Line 68: FND_MSG_PUB.ADD;

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

Line 98: FND_MSG_PUB.ADD;

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

Line 123: FND_MSG_PUB.ADD;

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

Line 153: FND_MSG_PUB.ADD;

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

Line 738: FND_MSG_PUB.ADD;

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

Line 763: FND_MSG_PUB.ADD;

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

Line 783: FND_MSG_PUB.ADD;

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

Line 803: FND_MSG_PUB.ADD;

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

Line 859: FND_MSG_PUB.ADD;

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

Line 1039: FND_MSG_PUB.ADD;

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

Line 1135: FND_MSG_PUB.ADD;

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

Line 1267: FND_MSG_PUB.ADD;

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

Line 1479: FND_MSG_PUB.ADD;

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

Line 1548: FND_MSG_PUB.ADD;

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

Line 1624: FND_MSG_PUB.ADD;

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

Line 1700: FND_MSG_PUB.ADD;

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

Line 1744: FND_MSG_PUB.ADD;

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

Line 1934: FND_MSG_PUB.ADD;

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

Line 2140: FND_MSG_PUB.ADD;

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

Line 2176: FND_MSG_PUB.ADD;

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

Line 2180: FND_MSG_PUB.ADD;

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

Line 2256: FND_MSG_PUB.ADD;

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

Line 2393: FND_MSG_PUB.ADD;

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

Line 2442: FND_MSG_PUB.ADD;

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

Line 2586: FND_MSG_PUB.ADD;

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

Line 2656: FND_MSG_PUB.ADD;

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

Line 2744: FND_MSG_PUB.ADD;

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

Line 2832: FND_MSG_PUB.ADD;

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

Line 2924: FND_MSG_PUB.ADD;

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

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_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:
3004: -------------------------------------------------------------------------------------

Line 3339: FND_MSG_PUB.ADD;

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

Line 3566: FND_MSG_PUB.ADD;

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

Line 3785: FND_MSG_PUB.ADD;

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

Line 3932: FND_MSG_PUB.ADD;

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

Line 4153: FND_MSG_PUB.ADD;

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

Line 4260: FND_MSG_PUB.ADD;

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

Line 4306: FND_MSG_PUB.ADD;

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

Line 4371: FND_MSG_PUB.ADD;

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

Line 4433: FND_MSG_PUB.ADD;

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

Line 4489: FND_MSG_PUB.ADD;

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

Line 4545: FND_MSG_PUB.ADD;

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

Line 4648: FND_MSG_PUB.ADD;

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

Line 4801: FND_MSG_PUB.ADD;

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

Line 4843: FND_MSG_PUB.ADD;

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

Line 4945: FND_MSG_PUB.ADD;

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

Line 4970: FND_MSG_PUB.ADD;

4966: p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
4967: OR p_contact_point_list(I).RAW_PHONE_NUMBER 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;
4974:

Line 5004: FND_MSG_PUB.ADD;

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

Line 5062: FND_MSG_PUB.ADD;

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

Line 5110: FND_MSG_PUB.ADD;

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

Line 5131: FND_MSG_PUB.ADD;

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

Line 5157: FND_MSG_PUB.ADD;

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