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

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

Line 1721: FND_MSG_PUB.ADD;

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

Line 1725: FND_MSG_PUB.ADD;

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

Line 1730: FND_MSG_PUB.ADD;

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

Line 1962: FND_MSG_PUB.ADD;

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

Line 1966: FND_MSG_PUB.ADD;

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

Line 1970: FND_MSG_PUB.ADD;

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

Line 1975: FND_MSG_PUB.ADD;

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

Line 2109: FND_MSG_PUB.ADD;

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

Line 2113: FND_MSG_PUB.ADD;

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

Line 2117: FND_MSG_PUB.ADD;

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

Line 2122: FND_MSG_PUB.ADD;

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

Line 2382: FND_MSG_PUB.ADD;

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

Line 2386: FND_MSG_PUB.ADD;

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

Line 2390: FND_MSG_PUB.ADD;

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

Line 2395: FND_MSG_PUB.ADD;

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

Line 2654: FND_MSG_PUB.ADD;

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

Line 2702: FND_MSG_PUB.ADD;

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

Line 2775: FND_MSG_PUB.ADD;

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

Line 2887: FND_MSG_PUB.ADD;

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

Line 2998: FND_MSG_PUB.ADD;

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

Line 3223: FND_MSG_PUB.ADD;

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

Line 3231: FND_MSG_PUB.ADD;

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

Line 3439: FND_MSG_PUB.ADD;

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

Line 3638: FND_MSG_PUB.ADD;

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

Line 3686: FND_MSG_PUB.ADD;

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

Line 3722: FND_MSG_PUB.ADD;

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

Line 3726: FND_MSG_PUB.ADD;

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

Line 3798: FND_MSG_PUB.ADD;

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

Line 4057: FND_MSG_PUB.ADD;

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

Line 4170: FND_MSG_PUB.ADD;

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

Line 4178: FND_MSG_PUB.ADD;

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

Line 4301: FND_MSG_PUB.ADD;

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

Line 4369: FND_MSG_PUB.ADD;

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

Line 4486: FND_MSG_PUB.ADD;

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

Line 4571: FND_MSG_PUB.ADD;

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

Line 4660: FND_MSG_PUB.ADD;

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

Line 4733: FND_MSG_PUB.ADD;

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

Line 5069: FND_MSG_PUB.ADD;

5065: WHEN OTHERS THEN
5066: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5067: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.call_api_dynamic');
5068: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5069: FND_MSG_PUB.ADD;
5070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5071: END call_api_dynamic;
5072:
5073:

Line 5314: FND_MSG_PUB.ADD;

5310: WHEN OTHERS THEN
5311: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5312: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_party_sites');
5313: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5314: FND_MSG_PUB.ADD;
5315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5316: END get_matching_party_sites;
5317:
5318:

Line 5543: FND_MSG_PUB.ADD;

5539: WHEN OTHERS THEN
5540: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5541: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_matching_contacts');
5542: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5543: FND_MSG_PUB.ADD;
5544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5545: END get_matching_contacts;
5546:
5547:

Line 5685: FND_MSG_PUB.ADD;

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

Line 5918: FND_MSG_PUB.ADD;

5914: WHEN OTHERS THEN
5915: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5916: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_99.get_score_details');
5917: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5918: FND_MSG_PUB.ADD;
5919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5920: END get_score_details;
5921:
5922:

Line 6041: FND_MSG_PUB.ADD;

6037: WHEN OTHERS THEN
6038: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6039: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6040: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6041: FND_MSG_PUB.ADD;
6042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6043: END get_party_for_search;
6044:
6045: PROCEDURE get_search_criteria (

Line 6093: FND_MSG_PUB.ADD;

6089: WHEN OTHERS THEN
6090: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6091: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6092: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6093: FND_MSG_PUB.ADD;
6094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6095: END get_search_criteria;
6096:
6097:

Line 6138: FND_MSG_PUB.ADD;

6134: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6135: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6136: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6137: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6138: FND_MSG_PUB.ADD;
6139: RAISE FND_API.G_EXC_ERROR;
6140: END get_party_rec;
6141:
6142: /************************************************

Line 6202: FND_MSG_PUB.ADD;

6198: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6199: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6200: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6201: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6202: FND_MSG_PUB.ADD;
6203: RAISE FND_API.G_EXC_ERROR;
6204: END get_party_site_rec;
6205:
6206: /************************************************

Line 6260: FND_MSG_PUB.ADD;

6256: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6257: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6258: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6259: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6260: FND_MSG_PUB.ADD;
6261: RAISE FND_API.G_EXC_ERROR;
6262: END get_contact_rec;
6263:
6264: /************************************************

Line 6316: FND_MSG_PUB.ADD;

6312: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6313: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6314: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6315: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6316: FND_MSG_PUB.ADD;
6317: RAISE FND_API.G_EXC_ERROR;
6318: END get_contact_point_rec;
6319:
6320: /************************************************

Line 6412: FND_MSG_PUB.ADD;

6408: WHEN OTHERS THEN
6409: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6410: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6411: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6412: FND_MSG_PUB.ADD;
6413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6414: END;
6415:
6416:

Line 6653: FND_MSG_PUB.ADD;

6649: WHEN OTHERS THEN
6650: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6651: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6652: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6653: FND_MSG_PUB.ADD;
6654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6655: END;
6656:
6657:

Line 6710: FND_MSG_PUB.ADD;

6706: WHEN OTHERS THEN
6707: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6708: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6709: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6710: FND_MSG_PUB.ADD;
6711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6712: END;
6713:
6714:

Line 6841: FND_MSG_PUB.ADD;

6837: WHEN OTHERS THEN
6838: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6839: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6840: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6841: FND_MSG_PUB.ADD;
6842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6843: END;
6844:
6845:

Line 6866: FND_MSG_PUB.ADD;

6862: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
6863: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6864: ) THEN
6865: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6866: FND_MSG_PUB.ADD;
6867: RAISE FND_API.G_EXC_ERROR;
6868: END IF;
6869: END LOOP;
6870:

Line 6927: FND_MSG_PUB.ADD;

6923: WHEN OTHERS THEN
6924: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6925: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6927: FND_MSG_PUB.ADD;
6928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6929: END check_prim_cond;
6930:
6931: /************************************************

Line 6991: FND_MSG_PUB.ADD;

6987: WHEN OTHERS THEN
6988: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6989: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6990: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6991: FND_MSG_PUB.ADD;
6992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6993: END check_party_site_cond;
6994:
6995: /************************************************

Line 7047: FND_MSG_PUB.ADD;

7043: WHEN OTHERS THEN
7044: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7045: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7046: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7047: FND_MSG_PUB.ADD;
7048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7049: END check_contact_cond;
7050:
7051: /************************************************

Line 7068: FND_MSG_PUB.ADD;

7064:
7065: FOR I IN 1..p_contact_point_list.COUNT LOOP
7066: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7067: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7068: FND_MSG_PUB.ADD;
7069: RAISE FND_API.G_EXC_ERROR;
7070: END IF;
7071: END LOOP;
7072:

Line 7094: FND_MSG_PUB.ADD;

7090: WHEN OTHERS THEN
7091: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7092: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7093: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7094: FND_MSG_PUB.ADD;
7095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7096: END check_contact_point_cond;
7097:
7098: FUNCTION check_staged RETURN BOOLEAN IS