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

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

Line 1546: FND_MSG_PUB.ADD;

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

Line 1550: FND_MSG_PUB.ADD;

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

Line 1555: FND_MSG_PUB.ADD;

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

Line 1787: FND_MSG_PUB.ADD;

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

Line 1791: FND_MSG_PUB.ADD;

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

Line 1795: FND_MSG_PUB.ADD;

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

Line 1800: FND_MSG_PUB.ADD;

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

Line 1934: FND_MSG_PUB.ADD;

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

Line 1938: FND_MSG_PUB.ADD;

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

Line 1942: FND_MSG_PUB.ADD;

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

Line 1947: FND_MSG_PUB.ADD;

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

Line 2207: FND_MSG_PUB.ADD;

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

Line 2211: FND_MSG_PUB.ADD;

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

Line 2215: FND_MSG_PUB.ADD;

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

Line 2220: FND_MSG_PUB.ADD;

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

Line 2473: FND_MSG_PUB.ADD;

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

Line 2521: FND_MSG_PUB.ADD;

2517: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2518: 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);
2519: END IF;
2520: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2521: FND_MSG_PUB.ADD;
2522: RAISE FND_API.G_EXC_ERROR;
2523: ELSE
2524: push_eval;
2525: RETURN;

Line 2594: FND_MSG_PUB.ADD;

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

Line 2706: FND_MSG_PUB.ADD;

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

Line 2817: FND_MSG_PUB.ADD;

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

Line 2961: FND_MSG_PUB.ADD;

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

Line 2969: FND_MSG_PUB.ADD;

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

Line 3220: FND_MSG_PUB.ADD;

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

Line 3413: FND_MSG_PUB.ADD;

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

Line 3461: FND_MSG_PUB.ADD;

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

Line 3497: FND_MSG_PUB.ADD;

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

Line 3501: FND_MSG_PUB.ADD;

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

Line 3573: FND_MSG_PUB.ADD;

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

Line 3762: FND_MSG_PUB.ADD;

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

Line 3850: FND_MSG_PUB.ADD;

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

Line 3858: FND_MSG_PUB.ADD;

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

Line 4007: FND_MSG_PUB.ADD;

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

Line 4075: FND_MSG_PUB.ADD;

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

Line 4192: FND_MSG_PUB.ADD;

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

Line 4277: FND_MSG_PUB.ADD;

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

Line 4366: FND_MSG_PUB.ADD;

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

Line 4439: FND_MSG_PUB.ADD;

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

Line 4727: FND_MSG_PUB.ADD;

4723: WHEN OTHERS THEN
4724: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4725: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.call_api_dynamic');
4726: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4727: FND_MSG_PUB.ADD;
4728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4729: END call_api_dynamic;
4730:
4731:

Line 4963: FND_MSG_PUB.ADD;

4959: WHEN OTHERS THEN
4960: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4961: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_party_sites');
4962: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4963: FND_MSG_PUB.ADD;
4964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4965: END get_matching_party_sites;
4966:
4967:

Line 5188: FND_MSG_PUB.ADD;

5184: WHEN OTHERS THEN
5185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5186: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_matching_contacts');
5187: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5188: FND_MSG_PUB.ADD;
5189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5190: END get_matching_contacts;
5191:
5192:

Line 5327: FND_MSG_PUB.ADD;

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

Line 5538: FND_MSG_PUB.ADD;

5534: WHEN OTHERS THEN
5535: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5536: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_48.get_score_details');
5537: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5538: FND_MSG_PUB.ADD;
5539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5540: END get_score_details;
5541:
5542:

Line 5616: FND_MSG_PUB.ADD;

5612: WHEN OTHERS THEN
5613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5614: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5615: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5616: FND_MSG_PUB.ADD;
5617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5618: END get_party_for_search;
5619:
5620: PROCEDURE get_search_criteria (

Line 5656: FND_MSG_PUB.ADD;

5652: WHEN OTHERS THEN
5653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5654: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5655: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5656: FND_MSG_PUB.ADD;
5657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5658: END get_search_criteria;
5659:
5660:

Line 5723: FND_MSG_PUB.ADD;

5719: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5720: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5721: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5723: FND_MSG_PUB.ADD;
5724: RAISE FND_API.G_EXC_ERROR;
5725: END get_party_rec;
5726:
5727: /************************************************

Line 5783: FND_MSG_PUB.ADD;

5779: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5780: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5781: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5782: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5783: FND_MSG_PUB.ADD;
5784: RAISE FND_API.G_EXC_ERROR;
5785: END get_party_site_rec;
5786:
5787: /************************************************

Line 5839: FND_MSG_PUB.ADD;

5835: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5836: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5837: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5838: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5839: FND_MSG_PUB.ADD;
5840: RAISE FND_API.G_EXC_ERROR;
5841: END get_contact_rec;
5842:
5843: /************************************************

Line 5891: FND_MSG_PUB.ADD;

5887: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5888: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5889: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5890: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5891: FND_MSG_PUB.ADD;
5892: RAISE FND_API.G_EXC_ERROR;
5893: END get_contact_point_rec;
5894:
5895: /************************************************

Line 6044: FND_MSG_PUB.ADD;

6040: WHEN OTHERS THEN
6041: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6042: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6043: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6044: FND_MSG_PUB.ADD;
6045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6046: END;
6047:
6048:

Line 6171: FND_MSG_PUB.ADD;

6167: WHEN OTHERS THEN
6168: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6169: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6170: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6171: FND_MSG_PUB.ADD;
6172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6173: END;
6174:
6175:

Line 6213: FND_MSG_PUB.ADD;

6209: WHEN OTHERS THEN
6210: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6211: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6212: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6213: FND_MSG_PUB.ADD;
6214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6215: END;
6216:
6217:

Line 6256: FND_MSG_PUB.ADD;

6252: WHEN OTHERS THEN
6253: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6254: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6255: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6256: FND_MSG_PUB.ADD;
6257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6258: END;
6259:
6260:

Line 6315: FND_MSG_PUB.ADD;

6311: WHEN OTHERS THEN
6312: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6313: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6314: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6315: FND_MSG_PUB.ADD;
6316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6317: END check_prim_cond;
6318:
6319: /************************************************

Line 6365: FND_MSG_PUB.ADD;

6361: WHEN OTHERS THEN
6362: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6363: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6364: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6365: FND_MSG_PUB.ADD;
6366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6367: END check_party_site_cond;
6368:
6369: /************************************************

Line 6403: FND_MSG_PUB.ADD;

6399: WHEN OTHERS THEN
6400: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6401: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6402: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6403: FND_MSG_PUB.ADD;
6404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6405: END check_contact_cond;
6406:
6407: /************************************************

Line 6424: FND_MSG_PUB.ADD;

6420:
6421: FOR I IN 1..p_contact_point_list.COUNT LOOP
6422: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6423: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6424: FND_MSG_PUB.ADD;
6425: RAISE FND_API.G_EXC_ERROR;
6426: END IF;
6427: END LOOP;
6428:

Line 6440: FND_MSG_PUB.ADD;

6436: WHEN OTHERS THEN
6437: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6438: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6439: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6440: FND_MSG_PUB.ADD;
6441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6442: END check_contact_point_cond;
6443:
6444: FUNCTION check_staged RETURN BOOLEAN IS