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_48 dependencies on FND_MSG_PUB

Line 101: FND_MSG_PUB.ADD;

97: exception
98: when others then
99: if (instrb(SQLERRM,'DRG-51030')>0) then
100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_ERROR;
103: elsif (instrb(SQLERRM,'DRG-50943')>0) then
104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
105: FND_MSG_PUB.ADD;

Line 105: FND_MSG_PUB.ADD;

101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_ERROR;
103: elsif (instrb(SQLERRM,'DRG-50943')>0) then
104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
105: FND_MSG_PUB.ADD;
106: RAISE FND_API.G_EXC_ERROR;
107: else
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: end if;

Line 770: FND_MSG_PUB.ADD;

766: WHEN OTHERS THEN
767: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
768: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
769: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
770: FND_MSG_PUB.ADD;
771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
772: END;
773:
774:

Line 795: FND_MSG_PUB.ADD;

791: WHEN OTHERS THEN
792: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
793: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
794: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
795: FND_MSG_PUB.ADD;
796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
797: END;
798:
799:

Line 815: FND_MSG_PUB.ADD;

811: WHEN OTHERS THEN
812: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
813: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
814: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
815: FND_MSG_PUB.ADD;
816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
817: END;
818:
819:

Line 835: FND_MSG_PUB.ADD;

831: WHEN OTHERS THEN
832: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
833: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
834: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
835: FND_MSG_PUB.ADD;
836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
837: END;
838:
839: PROCEDURE init_score_context (

Line 902: FND_MSG_PUB.ADD;

898: p_party_site_list,
899: p_contact_list,
900: p_contact_point_list) THEN
901: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
902: FND_MSG_PUB.ADD;
903: RAISE FND_API.G_EXC_ERROR;
904: END IF;
905: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
906: hz_utility_v2pub.debug(p_message=>'In init_search calling util package set_score',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 1173: FND_MSG_PUB.ADD;

1169: END IF;
1170: IF lengthb(l_party_contains_str) > 4000 THEN
1171: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1172: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1173: FND_MSG_PUB.ADD;
1174: RAISE FND_API.G_EXC_ERROR;
1175: END IF;
1176: IF (p_match_str = ' AND ' OR p_party_max_score 1177: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1262: FND_MSG_PUB.ADD;

1258: -- Add the search criteria to query string
1259: IF lengthb(l_contains_str) > 4000 THEN
1260: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1261: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1262: FND_MSG_PUB.ADD;
1263: RAISE FND_API.G_EXC_ERROR;
1264: END IF;
1265: x_denorm_str := l_den_contains_str;
1266: RETURN l_contains_str;

Line 1540: FND_MSG_PUB.ADD;

1536: exception
1537: when others then
1538: if (instrb(SQLERRM,'DRG-51030')>0) then
1539: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1540: FND_MSG_PUB.ADD;
1541: RAISE FND_API.G_EXC_ERROR;
1542: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1543: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1544: FND_MSG_PUB.ADD;

Line 1544: FND_MSG_PUB.ADD;

1540: FND_MSG_PUB.ADD;
1541: RAISE FND_API.G_EXC_ERROR;
1542: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1543: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1544: FND_MSG_PUB.ADD;
1545: RAISE FND_API.G_EXC_ERROR;
1546: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1547: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1548: FND_MSG_PUB.ADD;

Line 1548: FND_MSG_PUB.ADD;

1544: FND_MSG_PUB.ADD;
1545: RAISE FND_API.G_EXC_ERROR;
1546: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1547: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1548: FND_MSG_PUB.ADD;
1549: RAISE FND_API.G_EXC_ERROR;
1550: else
1551: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1552: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1553: FND_MSG_PUB.ADD;

1549: RAISE FND_API.G_EXC_ERROR;
1550: else
1551: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1552: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1553: FND_MSG_PUB.ADD;
1554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1555: end if;
1556: END;
1557:

Line 1785: FND_MSG_PUB.ADD;

1781: exception
1782: when others then
1783: if (instrb(SQLERRM,'DRG-51030')>0) then
1784: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1785: FND_MSG_PUB.ADD;
1786: RAISE FND_API.G_EXC_ERROR;
1787: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1788: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1789: FND_MSG_PUB.ADD;

Line 1789: FND_MSG_PUB.ADD;

1785: FND_MSG_PUB.ADD;
1786: RAISE FND_API.G_EXC_ERROR;
1787: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1788: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1789: FND_MSG_PUB.ADD;
1790: RAISE FND_API.G_EXC_ERROR;
1791: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1792: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1793: FND_MSG_PUB.ADD;

Line 1793: FND_MSG_PUB.ADD;

1789: FND_MSG_PUB.ADD;
1790: RAISE FND_API.G_EXC_ERROR;
1791: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1792: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1793: FND_MSG_PUB.ADD;
1794: RAISE FND_API.G_EXC_ERROR;
1795: else
1796: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1797: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1798: FND_MSG_PUB.ADD;

1794: RAISE FND_API.G_EXC_ERROR;
1795: else
1796: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1797: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1798: FND_MSG_PUB.ADD;
1799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1800: end if;
1801: END;
1802:

Line 1932: FND_MSG_PUB.ADD;

1928: exception
1929: when others then
1930: if (instrb(SQLERRM,'DRG-51030')>0) then
1931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1932: FND_MSG_PUB.ADD;
1933: RAISE FND_API.G_EXC_ERROR;
1934: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1935: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1936: FND_MSG_PUB.ADD;

Line 1936: FND_MSG_PUB.ADD;

1932: FND_MSG_PUB.ADD;
1933: RAISE FND_API.G_EXC_ERROR;
1934: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1935: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1936: FND_MSG_PUB.ADD;
1937: RAISE FND_API.G_EXC_ERROR;
1938: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1940: FND_MSG_PUB.ADD;

Line 1940: FND_MSG_PUB.ADD;

1936: FND_MSG_PUB.ADD;
1937: RAISE FND_API.G_EXC_ERROR;
1938: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1940: FND_MSG_PUB.ADD;
1941: RAISE FND_API.G_EXC_ERROR;
1942: else
1943: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1944: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1945: FND_MSG_PUB.ADD;

1941: RAISE FND_API.G_EXC_ERROR;
1942: else
1943: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1944: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1945: FND_MSG_PUB.ADD;
1946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1947: end if;
1948: END;
1949:

Line 2205: FND_MSG_PUB.ADD;

2201: exception
2202: when others then
2203: if (instrb(SQLERRM,'DRG-51030')>0) then
2204: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2205: FND_MSG_PUB.ADD;
2206: RAISE FND_API.G_EXC_ERROR;
2207: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2208: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2209: FND_MSG_PUB.ADD;

Line 2209: FND_MSG_PUB.ADD;

2205: FND_MSG_PUB.ADD;
2206: RAISE FND_API.G_EXC_ERROR;
2207: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2208: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2209: FND_MSG_PUB.ADD;
2210: RAISE FND_API.G_EXC_ERROR;
2211: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2212: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2213: FND_MSG_PUB.ADD;

Line 2213: FND_MSG_PUB.ADD;

2209: FND_MSG_PUB.ADD;
2210: RAISE FND_API.G_EXC_ERROR;
2211: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2212: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2213: FND_MSG_PUB.ADD;
2214: RAISE FND_API.G_EXC_ERROR;
2215: else
2216: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2217: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2218: FND_MSG_PUB.ADD;

2214: RAISE FND_API.G_EXC_ERROR;
2215: else
2216: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2217: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2218: FND_MSG_PUB.ADD;
2219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2220: end if;
2221: END;
2222:

Line 2470: FND_MSG_PUB.ADD;

2466: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2467: 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);
2468: END IF;
2469: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2470: FND_MSG_PUB.ADD;
2471: RAISE FND_API.G_EXC_ERROR;
2472: ELSE
2473: push_eval;
2474: RETURN;

Line 2518: FND_MSG_PUB.ADD;

2514: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2515: hz_utility_v2pub.debug(p_message=>'In eval party level estimated hits exceed threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2516: END IF;
2517: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2518: FND_MSG_PUB.ADD;
2519: RAISE FND_API.G_EXC_ERROR;
2520: ELSE
2521: push_eval;
2522: RETURN;

Line 2591: FND_MSG_PUB.ADD;

2587: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2588: 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);
2589: END IF;
2590: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2591: FND_MSG_PUB.ADD;
2592: RAISE FND_API.G_EXC_ERROR;
2593: ELSE
2594: push_eval;
2595: RETURN;

Line 2703: FND_MSG_PUB.ADD;

2699: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2700: 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);
2701: END IF;
2702: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2703: FND_MSG_PUB.ADD;
2704: RAISE FND_API.G_EXC_ERROR;
2705: ELSE
2706: push_eval;
2707: RETURN;

Line 2814: FND_MSG_PUB.ADD;

2810: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2811: 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);
2812: END IF;
2813: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2814: FND_MSG_PUB.ADD;
2815: RAISE FND_API.G_EXC_ERROR;
2816: ELSE
2817: push_eval;
2818: RETURN;

Line 2958: FND_MSG_PUB.ADD;

2954: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2955: 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);
2956: END IF;
2957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2958: FND_MSG_PUB.ADD;
2959: RAISE FND_API.G_EXC_ERROR;
2960: END IF;
2961: ELSE
2962: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2966: FND_MSG_PUB.ADD;

2962: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2963: 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);
2964: END IF;
2965: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2966: FND_MSG_PUB.ADD;
2967: RAISE FND_API.G_EXC_ERROR;
2968: END IF;
2969: END IF;
2970: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3217: FND_MSG_PUB.ADD;

3213: WHEN OTHERS THEN
3214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3215: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_parties');
3216: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3217: FND_MSG_PUB.ADD;
3218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3219: END find_parties;
3220:
3221: PROCEDURE find_persons (

Line 3409: FND_MSG_PUB.ADD;

3405: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3406: 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);
3407: END IF;
3408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3409: FND_MSG_PUB.ADD;
3410: RAISE FND_API.G_EXC_ERROR;
3411: ELSE
3412: push_eval;
3413: RETURN;

Line 3457: FND_MSG_PUB.ADD;

3453: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3454: 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);
3455: END IF;
3456: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3457: FND_MSG_PUB.ADD;
3458: RAISE FND_API.G_EXC_ERROR;
3459: ELSE
3460: push_eval;
3461: RETURN;

Line 3493: FND_MSG_PUB.ADD;

3489: exception
3490: when others then
3491: if (instrb(SQLERRM,'DRG-51030')>0) then
3492: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3493: FND_MSG_PUB.ADD;
3494: RAISE FND_API.G_EXC_ERROR;
3495: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3496: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3497: FND_MSG_PUB.ADD;

Line 3497: FND_MSG_PUB.ADD;

3493: FND_MSG_PUB.ADD;
3494: RAISE FND_API.G_EXC_ERROR;
3495: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3496: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3497: FND_MSG_PUB.ADD;
3498: RAISE FND_API.G_EXC_ERROR;
3499: else
3500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3501: end if;

Line 3569: FND_MSG_PUB.ADD;

3565: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3566: 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);
3567: END IF;
3568: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3569: FND_MSG_PUB.ADD;
3570: RAISE FND_API.G_EXC_ERROR;
3571: ELSE
3572: push_eval;
3573: RETURN;

Line 3758: FND_MSG_PUB.ADD;

3754: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3755: 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);
3756: END IF;
3757: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3758: FND_MSG_PUB.ADD;
3759: RAISE FND_API.G_EXC_ERROR;
3760: ELSE
3761: push_eval;
3762: RETURN;

Line 3846: FND_MSG_PUB.ADD;

3842: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3843: 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);
3844: END IF;
3845: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3846: FND_MSG_PUB.ADD;
3847: RAISE FND_API.G_EXC_ERROR;
3848: END IF;
3849: ELSE
3850: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3854: FND_MSG_PUB.ADD;

3850: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3851: 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);
3852: END IF;
3853: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3854: FND_MSG_PUB.ADD;
3855: RAISE FND_API.G_EXC_ERROR;
3856: END IF;
3857: END IF;
3858: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 4003: FND_MSG_PUB.ADD;

3999: WHEN OTHERS THEN
4000: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4001: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_persons');
4002: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4003: FND_MSG_PUB.ADD;
4004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4005: END find_persons;
4006:
4007: PROCEDURE find_persons (

Line 4071: FND_MSG_PUB.ADD;

4067: WHEN OTHERS THEN
4068: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4069: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_party_details');
4070: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4071: FND_MSG_PUB.ADD;
4072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4073: END find_party_details;
4074:
4075: PROCEDURE find_duplicate_parties (

Line 4188: FND_MSG_PUB.ADD;

4184: WHEN OTHERS THEN
4185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4186: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_parties');
4187: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4188: FND_MSG_PUB.ADD;
4189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4190: END find_duplicate_parties;
4191:
4192: PROCEDURE find_duplicate_party_sites (

Line 4273: FND_MSG_PUB.ADD;

4269: WHEN OTHERS THEN
4270: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4271: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_party_sites');
4272: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4273: FND_MSG_PUB.ADD;
4274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4275: END find_duplicate_party_sites;
4276:
4277: PROCEDURE find_duplicate_contacts (

Line 4362: FND_MSG_PUB.ADD;

4358: WHEN OTHERS THEN
4359: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4360: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contacts');
4361: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4362: FND_MSG_PUB.ADD;
4363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4364: END find_duplicate_contacts;
4365:
4366: PROCEDURE find_duplicate_contact_points (

Line 4435: FND_MSG_PUB.ADD;

4431: WHEN OTHERS THEN
4432: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4433: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.find_duplicate_contact_points');
4434: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4435: FND_MSG_PUB.ADD;
4436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4437: END find_duplicate_contact_points;
4438:
4439: PROCEDURE find_parties_dynamic (

Line 4723: FND_MSG_PUB.ADD;

4719: WHEN OTHERS THEN
4720: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4721: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.call_api_dynamic');
4722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4723: FND_MSG_PUB.ADD;
4724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4725: END call_api_dynamic;
4726:
4727:

Line 4959: FND_MSG_PUB.ADD;

4955: WHEN OTHERS THEN
4956: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4957: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_party_sites');
4958: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4959: FND_MSG_PUB.ADD;
4960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4961: END get_matching_party_sites;
4962:
4963:

Line 5184: FND_MSG_PUB.ADD;

5180: WHEN OTHERS THEN
5181: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5182: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_contacts');
5183: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5184: FND_MSG_PUB.ADD;
5185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5186: END get_matching_contacts;
5187:
5188:

Line 5323: FND_MSG_PUB.ADD;

5319: WHEN OTHERS THEN
5320: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5321: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_contact_points');
5322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5323: FND_MSG_PUB.ADD;
5324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5325: END get_matching_contact_points;
5326:
5327: /**********************************************************

Line 5533: FND_MSG_PUB.ADD;

5529: WHEN OTHERS THEN
5530: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5531: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_score_details');
5532: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5533: FND_MSG_PUB.ADD;
5534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5535: END get_score_details;
5536:
5537:

Line 5611: FND_MSG_PUB.ADD;

5607: WHEN OTHERS THEN
5608: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5609: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5610: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5611: FND_MSG_PUB.ADD;
5612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5613: END get_party_for_search;
5614:
5615: PROCEDURE get_search_criteria (

Line 5651: FND_MSG_PUB.ADD;

5647: WHEN OTHERS THEN
5648: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5649: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5650: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5651: FND_MSG_PUB.ADD;
5652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5653: END get_search_criteria;
5654:
5655:

Line 5718: FND_MSG_PUB.ADD;

5714: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5715: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5716: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5717: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5718: FND_MSG_PUB.ADD;
5719: RAISE FND_API.G_EXC_ERROR;
5720: END get_party_rec;
5721:
5722: /************************************************

Line 5778: FND_MSG_PUB.ADD;

5774: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5775: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5776: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5777: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5778: FND_MSG_PUB.ADD;
5779: RAISE FND_API.G_EXC_ERROR;
5780: END get_party_site_rec;
5781:
5782: /************************************************

Line 5834: FND_MSG_PUB.ADD;

5830: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5831: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5832: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5833: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5834: FND_MSG_PUB.ADD;
5835: RAISE FND_API.G_EXC_ERROR;
5836: END get_contact_rec;
5837:
5838: /************************************************

Line 5886: FND_MSG_PUB.ADD;

5882: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5883: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5884: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5885: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5886: FND_MSG_PUB.ADD;
5887: RAISE FND_API.G_EXC_ERROR;
5888: END get_contact_point_rec;
5889:
5890: /************************************************

Line 6039: FND_MSG_PUB.ADD;

6035: WHEN OTHERS THEN
6036: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6037: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6038: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6039: FND_MSG_PUB.ADD;
6040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6041: END;
6042:
6043:

Line 6166: FND_MSG_PUB.ADD;

6162: WHEN OTHERS THEN
6163: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6164: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6165: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6166: FND_MSG_PUB.ADD;
6167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6168: END;
6169:
6170:

Line 6208: FND_MSG_PUB.ADD;

6204: WHEN OTHERS THEN
6205: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6206: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6208: FND_MSG_PUB.ADD;
6209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6210: END;
6211:
6212:

Line 6251: FND_MSG_PUB.ADD;

6247: WHEN OTHERS THEN
6248: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6249: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6250: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6251: FND_MSG_PUB.ADD;
6252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6253: END;
6254:
6255:

Line 6310: FND_MSG_PUB.ADD;

6306: WHEN OTHERS THEN
6307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6308: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6310: FND_MSG_PUB.ADD;
6311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6312: END check_prim_cond;
6313:
6314: /************************************************

Line 6360: FND_MSG_PUB.ADD;

6356: WHEN OTHERS THEN
6357: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6358: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6359: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6360: FND_MSG_PUB.ADD;
6361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6362: END check_party_site_cond;
6363:
6364: /************************************************

Line 6398: FND_MSG_PUB.ADD;

6394: WHEN OTHERS THEN
6395: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6396: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6397: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6398: FND_MSG_PUB.ADD;
6399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6400: END check_contact_cond;
6401:
6402: /************************************************

Line 6419: FND_MSG_PUB.ADD;

6415:
6416: FOR I IN 1..p_contact_point_list.COUNT LOOP
6417: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6418: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6419: FND_MSG_PUB.ADD;
6420: RAISE FND_API.G_EXC_ERROR;
6421: END IF;
6422: END LOOP;
6423:

Line 6435: FND_MSG_PUB.ADD;

6431: WHEN OTHERS THEN
6432: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6433: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6434: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6435: FND_MSG_PUB.ADD;
6436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6437: END check_contact_point_cond;
6438:
6439: FUNCTION check_staged RETURN BOOLEAN IS