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

878: WHEN OTHERS THEN
879: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
880: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
881: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
882: FND_MSG_PUB.ADD;
883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
884: END;
885:
886:

Line 907: FND_MSG_PUB.ADD;

903: WHEN OTHERS THEN
904: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
905: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
906: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
907: FND_MSG_PUB.ADD;
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END;
910:
911:

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

Line 1014: FND_MSG_PUB.ADD;

1010: p_party_site_list,
1011: p_contact_list,
1012: p_contact_point_list) THEN
1013: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1014: FND_MSG_PUB.ADD;
1015: RAISE FND_API.G_EXC_ERROR;
1016: END IF;
1017: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1018: 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 1232: FND_MSG_PUB.ADD;

1228: END IF;
1229: IF lengthb(l_party_contains_str) > 4000 THEN
1230: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1231: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1232: FND_MSG_PUB.ADD;
1233: RAISE FND_API.G_EXC_ERROR;
1234: END IF;
1235: IF (p_match_str = ' AND ' OR p_party_max_score 1236: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1341: FND_MSG_PUB.ADD;

1337: -- Add the search criteria to query string
1338: IF lengthb(l_contains_str) > 4000 THEN
1339: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1340: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1341: FND_MSG_PUB.ADD;
1342: RAISE FND_API.G_EXC_ERROR;
1343: END IF;
1344: x_denorm_str := l_den_contains_str;
1345: RETURN l_contains_str;

Line 1388: FND_MSG_PUB.ADD;

1384: -- Add the search criteria to query string
1385: IF lengthb(l_contains_str) > 4000 THEN
1386: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1387: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1388: FND_MSG_PUB.ADD;
1389: RAISE FND_API.G_EXC_ERROR;
1390: END IF;
1391: x_denorm_str := l_den_contains_str;
1392: RETURN l_contains_str;

Line 1469: FND_MSG_PUB.ADD;

1465: -- Add the search criteria to query string
1466: IF lengthb(l_contains_str) > 4000 THEN
1467: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1468: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1469: FND_MSG_PUB.ADD;
1470: RAISE FND_API.G_EXC_ERROR;
1471: END IF;
1472: x_denorm_str := l_den_contains_str;
1473: RETURN l_contains_str;

Line 1715: FND_MSG_PUB.ADD;

1711: exception
1712: when others then
1713: if (instrb(SQLERRM,'DRG-51030')>0) then
1714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1715: FND_MSG_PUB.ADD;
1716: RAISE FND_API.G_EXC_ERROR;
1717: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1718: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1719: FND_MSG_PUB.ADD;

Line 1719: FND_MSG_PUB.ADD;

1715: FND_MSG_PUB.ADD;
1716: RAISE FND_API.G_EXC_ERROR;
1717: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1718: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1719: FND_MSG_PUB.ADD;
1720: RAISE FND_API.G_EXC_ERROR;
1721: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1722: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1723: FND_MSG_PUB.ADD;

Line 1723: FND_MSG_PUB.ADD;

1719: FND_MSG_PUB.ADD;
1720: RAISE FND_API.G_EXC_ERROR;
1721: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1722: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1723: FND_MSG_PUB.ADD;
1724: RAISE FND_API.G_EXC_ERROR;
1725: else
1726: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1727: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1728: FND_MSG_PUB.ADD;

1724: RAISE FND_API.G_EXC_ERROR;
1725: else
1726: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1727: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1728: FND_MSG_PUB.ADD;
1729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1730: end if;
1731: END;
1732:

Line 1960: FND_MSG_PUB.ADD;

1956: exception
1957: when others then
1958: if (instrb(SQLERRM,'DRG-51030')>0) then
1959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1960: FND_MSG_PUB.ADD;
1961: RAISE FND_API.G_EXC_ERROR;
1962: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1964: FND_MSG_PUB.ADD;

Line 1964: FND_MSG_PUB.ADD;

1960: FND_MSG_PUB.ADD;
1961: RAISE FND_API.G_EXC_ERROR;
1962: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1964: FND_MSG_PUB.ADD;
1965: RAISE FND_API.G_EXC_ERROR;
1966: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1968: FND_MSG_PUB.ADD;

Line 1968: FND_MSG_PUB.ADD;

1964: FND_MSG_PUB.ADD;
1965: RAISE FND_API.G_EXC_ERROR;
1966: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1968: FND_MSG_PUB.ADD;
1969: RAISE FND_API.G_EXC_ERROR;
1970: else
1971: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1972: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1973: FND_MSG_PUB.ADD;

1969: RAISE FND_API.G_EXC_ERROR;
1970: else
1971: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1972: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1973: FND_MSG_PUB.ADD;
1974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1975: end if;
1976: END;
1977:

Line 2107: FND_MSG_PUB.ADD;

2103: exception
2104: when others then
2105: if (instrb(SQLERRM,'DRG-51030')>0) then
2106: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2107: FND_MSG_PUB.ADD;
2108: RAISE FND_API.G_EXC_ERROR;
2109: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2110: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2111: FND_MSG_PUB.ADD;

Line 2111: FND_MSG_PUB.ADD;

2107: FND_MSG_PUB.ADD;
2108: RAISE FND_API.G_EXC_ERROR;
2109: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2110: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2111: FND_MSG_PUB.ADD;
2112: RAISE FND_API.G_EXC_ERROR;
2113: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2114: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2115: FND_MSG_PUB.ADD;

Line 2115: FND_MSG_PUB.ADD;

2111: FND_MSG_PUB.ADD;
2112: RAISE FND_API.G_EXC_ERROR;
2113: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2114: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2115: FND_MSG_PUB.ADD;
2116: RAISE FND_API.G_EXC_ERROR;
2117: else
2118: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2120: FND_MSG_PUB.ADD;

2116: RAISE FND_API.G_EXC_ERROR;
2117: else
2118: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2120: FND_MSG_PUB.ADD;
2121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2122: end if;
2123: END;
2124:

Line 2380: FND_MSG_PUB.ADD;

2376: exception
2377: when others then
2378: if (instrb(SQLERRM,'DRG-51030')>0) then
2379: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2380: FND_MSG_PUB.ADD;
2381: RAISE FND_API.G_EXC_ERROR;
2382: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2383: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2384: FND_MSG_PUB.ADD;

Line 2384: FND_MSG_PUB.ADD;

2380: FND_MSG_PUB.ADD;
2381: RAISE FND_API.G_EXC_ERROR;
2382: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2383: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2384: FND_MSG_PUB.ADD;
2385: RAISE FND_API.G_EXC_ERROR;
2386: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2387: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2388: FND_MSG_PUB.ADD;

Line 2388: FND_MSG_PUB.ADD;

2384: FND_MSG_PUB.ADD;
2385: RAISE FND_API.G_EXC_ERROR;
2386: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2387: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2388: FND_MSG_PUB.ADD;
2389: RAISE FND_API.G_EXC_ERROR;
2390: else
2391: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2392: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2393: FND_MSG_PUB.ADD;

2389: RAISE FND_API.G_EXC_ERROR;
2390: else
2391: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2392: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2393: FND_MSG_PUB.ADD;
2394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2395: end if;
2396: END;
2397:

Line 2651: FND_MSG_PUB.ADD;

2647: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2648: 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);
2649: END IF;
2650: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2651: FND_MSG_PUB.ADD;
2652: RAISE FND_API.G_EXC_ERROR;
2653: ELSE
2654: push_eval;
2655: RETURN;

Line 2699: FND_MSG_PUB.ADD;

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

Line 2772: FND_MSG_PUB.ADD;

2768: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2769: 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);
2770: END IF;
2771: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2772: FND_MSG_PUB.ADD;
2773: RAISE FND_API.G_EXC_ERROR;
2774: ELSE
2775: push_eval;
2776: RETURN;

Line 2884: FND_MSG_PUB.ADD;

2880: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2881: 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);
2882: END IF;
2883: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2884: FND_MSG_PUB.ADD;
2885: RAISE FND_API.G_EXC_ERROR;
2886: ELSE
2887: push_eval;
2888: RETURN;

Line 2995: FND_MSG_PUB.ADD;

2991: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2992: 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);
2993: END IF;
2994: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2995: FND_MSG_PUB.ADD;
2996: RAISE FND_API.G_EXC_ERROR;
2997: ELSE
2998: push_eval;
2999: RETURN;

Line 3220: FND_MSG_PUB.ADD;

3216: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3217: 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);
3218: END IF;
3219: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3220: FND_MSG_PUB.ADD;
3221: RAISE FND_API.G_EXC_ERROR;
3222: END IF;
3223: ELSE
3224: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3228: FND_MSG_PUB.ADD;

3224: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3225: 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);
3226: END IF;
3227: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3228: FND_MSG_PUB.ADD;
3229: RAISE FND_API.G_EXC_ERROR;
3230: END IF;
3231: END IF;
3232: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3436: FND_MSG_PUB.ADD;

3432: WHEN OTHERS THEN
3433: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3434: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_parties');
3435: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3436: FND_MSG_PUB.ADD;
3437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3438: END find_parties;
3439:
3440: PROCEDURE find_persons (

Line 3634: FND_MSG_PUB.ADD;

3630: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3631: 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);
3632: END IF;
3633: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3634: FND_MSG_PUB.ADD;
3635: RAISE FND_API.G_EXC_ERROR;
3636: ELSE
3637: push_eval;
3638: RETURN;

Line 3682: FND_MSG_PUB.ADD;

3678: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3679: 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);
3680: END IF;
3681: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3682: FND_MSG_PUB.ADD;
3683: RAISE FND_API.G_EXC_ERROR;
3684: ELSE
3685: push_eval;
3686: RETURN;

Line 3718: FND_MSG_PUB.ADD;

3714: exception
3715: when others then
3716: if (instrb(SQLERRM,'DRG-51030')>0) then
3717: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3718: FND_MSG_PUB.ADD;
3719: RAISE FND_API.G_EXC_ERROR;
3720: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3721: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3722: FND_MSG_PUB.ADD;

Line 3722: FND_MSG_PUB.ADD;

3718: FND_MSG_PUB.ADD;
3719: RAISE FND_API.G_EXC_ERROR;
3720: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3721: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3722: FND_MSG_PUB.ADD;
3723: RAISE FND_API.G_EXC_ERROR;
3724: else
3725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3726: end if;

Line 3794: FND_MSG_PUB.ADD;

3790: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3791: 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);
3792: END IF;
3793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3794: FND_MSG_PUB.ADD;
3795: RAISE FND_API.G_EXC_ERROR;
3796: ELSE
3797: push_eval;
3798: RETURN;

Line 4053: FND_MSG_PUB.ADD;

4049: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4050: 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);
4051: END IF;
4052: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4053: FND_MSG_PUB.ADD;
4054: RAISE FND_API.G_EXC_ERROR;
4055: ELSE
4056: push_eval;
4057: RETURN;

Line 4166: FND_MSG_PUB.ADD;

4162: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4163: 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);
4164: END IF;
4165: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4166: FND_MSG_PUB.ADD;
4167: RAISE FND_API.G_EXC_ERROR;
4168: END IF;
4169: ELSE
4170: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 4174: FND_MSG_PUB.ADD;

4170: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4171: 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);
4172: END IF;
4173: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4174: FND_MSG_PUB.ADD;
4175: RAISE FND_API.G_EXC_ERROR;
4176: END IF;
4177: END IF;
4178: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 4297: FND_MSG_PUB.ADD;

4293: WHEN OTHERS THEN
4294: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4295: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_persons');
4296: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4297: FND_MSG_PUB.ADD;
4298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4299: END find_persons;
4300:
4301: PROCEDURE find_persons (

Line 4365: FND_MSG_PUB.ADD;

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

Line 4482: FND_MSG_PUB.ADD;

4478: WHEN OTHERS THEN
4479: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4480: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_parties');
4481: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4482: FND_MSG_PUB.ADD;
4483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4484: END find_duplicate_parties;
4485:
4486: PROCEDURE find_duplicate_party_sites (

Line 4567: FND_MSG_PUB.ADD;

4563: WHEN OTHERS THEN
4564: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4565: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_party_sites');
4566: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4567: FND_MSG_PUB.ADD;
4568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4569: END find_duplicate_party_sites;
4570:
4571: PROCEDURE find_duplicate_contacts (

Line 4656: FND_MSG_PUB.ADD;

4652: WHEN OTHERS THEN
4653: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4654: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_contacts');
4655: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4656: FND_MSG_PUB.ADD;
4657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4658: END find_duplicate_contacts;
4659:
4660: PROCEDURE find_duplicate_contact_points (

Line 4729: FND_MSG_PUB.ADD;

4725: WHEN OTHERS THEN
4726: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4727: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.find_duplicate_contact_points');
4728: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4729: FND_MSG_PUB.ADD;
4730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4731: END find_duplicate_contact_points;
4732:
4733: PROCEDURE find_parties_dynamic (

Line 5065: FND_MSG_PUB.ADD;

5061: WHEN OTHERS THEN
5062: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5063: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.call_api_dynamic');
5064: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5065: FND_MSG_PUB.ADD;
5066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5067: END call_api_dynamic;
5068:
5069:

Line 5310: FND_MSG_PUB.ADD;

5306: WHEN OTHERS THEN
5307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5308: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_party_sites');
5309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5310: FND_MSG_PUB.ADD;
5311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5312: END get_matching_party_sites;
5313:
5314:

Line 5539: FND_MSG_PUB.ADD;

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

Line 5681: FND_MSG_PUB.ADD;

5677: WHEN OTHERS THEN
5678: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5679: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_contact_points');
5680: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5681: FND_MSG_PUB.ADD;
5682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5683: END get_matching_contact_points;
5684:
5685: /**********************************************************

Line 5913: FND_MSG_PUB.ADD;

5909: WHEN OTHERS THEN
5910: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5911: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_score_details');
5912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5913: FND_MSG_PUB.ADD;
5914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5915: END get_score_details;
5916:
5917:

Line 6036: FND_MSG_PUB.ADD;

6032: WHEN OTHERS THEN
6033: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6034: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6035: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6036: FND_MSG_PUB.ADD;
6037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6038: END get_party_for_search;
6039:
6040: PROCEDURE get_search_criteria (

Line 6088: FND_MSG_PUB.ADD;

6084: WHEN OTHERS THEN
6085: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6086: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6087: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6088: FND_MSG_PUB.ADD;
6089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6090: END get_search_criteria;
6091:
6092:

Line 6133: FND_MSG_PUB.ADD;

6129: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6130: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6131: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6132: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6133: FND_MSG_PUB.ADD;
6134: RAISE FND_API.G_EXC_ERROR;
6135: END get_party_rec;
6136:
6137: /************************************************

Line 6197: FND_MSG_PUB.ADD;

6193: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6194: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6195: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6196: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6197: FND_MSG_PUB.ADD;
6198: RAISE FND_API.G_EXC_ERROR;
6199: END get_party_site_rec;
6200:
6201: /************************************************

Line 6255: FND_MSG_PUB.ADD;

6251: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6252: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6253: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6254: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6255: FND_MSG_PUB.ADD;
6256: RAISE FND_API.G_EXC_ERROR;
6257: END get_contact_rec;
6258:
6259: /************************************************

Line 6311: FND_MSG_PUB.ADD;

6307: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6308: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6309: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6310: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6311: FND_MSG_PUB.ADD;
6312: RAISE FND_API.G_EXC_ERROR;
6313: END get_contact_point_rec;
6314:
6315: /************************************************

Line 6407: FND_MSG_PUB.ADD;

6403: WHEN OTHERS THEN
6404: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6405: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6407: FND_MSG_PUB.ADD;
6408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6409: END;
6410:
6411:

Line 6648: FND_MSG_PUB.ADD;

6644: WHEN OTHERS THEN
6645: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6646: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6648: FND_MSG_PUB.ADD;
6649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6650: END;
6651:
6652:

Line 6705: FND_MSG_PUB.ADD;

6701: WHEN OTHERS THEN
6702: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6703: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6705: FND_MSG_PUB.ADD;
6706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6707: END;
6708:
6709:

Line 6836: FND_MSG_PUB.ADD;

6832: WHEN OTHERS THEN
6833: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6834: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6835: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6836: FND_MSG_PUB.ADD;
6837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6838: END;
6839:
6840:

Line 6861: FND_MSG_PUB.ADD;

6857: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
6858: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6859: ) THEN
6860: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6861: FND_MSG_PUB.ADD;
6862: RAISE FND_API.G_EXC_ERROR;
6863: END IF;
6864: END LOOP;
6865:

Line 6922: FND_MSG_PUB.ADD;

6918: WHEN OTHERS THEN
6919: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6920: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6921: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6922: FND_MSG_PUB.ADD;
6923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6924: END check_prim_cond;
6925:
6926: /************************************************

Line 6986: FND_MSG_PUB.ADD;

6982: WHEN OTHERS THEN
6983: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6984: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6986: FND_MSG_PUB.ADD;
6987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6988: END check_party_site_cond;
6989:
6990: /************************************************

Line 7042: FND_MSG_PUB.ADD;

7038: WHEN OTHERS THEN
7039: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7040: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7041: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7042: FND_MSG_PUB.ADD;
7043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7044: END check_contact_cond;
7045:
7046: /************************************************

Line 7063: FND_MSG_PUB.ADD;

7059:
7060: FOR I IN 1..p_contact_point_list.COUNT LOOP
7061: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7062: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7063: FND_MSG_PUB.ADD;
7064: RAISE FND_API.G_EXC_ERROR;
7065: END IF;
7066: END LOOP;
7067:

Line 7089: FND_MSG_PUB.ADD;

7085: WHEN OTHERS THEN
7086: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7087: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7088: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7089: FND_MSG_PUB.ADD;
7090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7091: END check_contact_point_cond;
7092:
7093: FUNCTION check_staged RETURN BOOLEAN IS