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

678: WHEN OTHERS THEN
679: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
680: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
681: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
682: FND_MSG_PUB.ADD;
683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
684: END;
685:
686:

Line 702: FND_MSG_PUB.ADD;

698: WHEN OTHERS THEN
699: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
700: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
701: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
702: FND_MSG_PUB.ADD;
703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
704: END;
705:
706:

Line 722: FND_MSG_PUB.ADD;

718: WHEN OTHERS THEN
719: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
720: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
722: FND_MSG_PUB.ADD;
723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
724: END;
725:
726:

Line 742: FND_MSG_PUB.ADD;

738: WHEN OTHERS THEN
739: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
740: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
741: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
742: FND_MSG_PUB.ADD;
743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
744: END;
745:
746: PROCEDURE init_score_context (

Line 809: FND_MSG_PUB.ADD;

805: p_party_site_list,
806: p_contact_list,
807: p_contact_point_list) THEN
808: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
809: FND_MSG_PUB.ADD;
810: RAISE FND_API.G_EXC_ERROR;
811: END IF;
812: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
813: 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 1044: FND_MSG_PUB.ADD;

1040: END IF;
1041: IF lengthb(l_party_contains_str) > 4000 THEN
1042: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1043: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1044: FND_MSG_PUB.ADD;
1045: RAISE FND_API.G_EXC_ERROR;
1046: END IF;
1047: IF (p_match_str = ' AND ' OR p_party_max_score 1048: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1113: FND_MSG_PUB.ADD;

1109: -- Add the search criteria to query string
1110: IF lengthb(l_contains_str) > 4000 THEN
1111: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1112: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1113: FND_MSG_PUB.ADD;
1114: RAISE FND_API.G_EXC_ERROR;
1115: END IF;
1116: x_denorm_str := l_den_contains_str;
1117: RETURN l_contains_str;

Line 1174: FND_MSG_PUB.ADD;

1170: -- Add the search criteria to query string
1171: IF lengthb(l_contains_str) > 4000 THEN
1172: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1173: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1174: FND_MSG_PUB.ADD;
1175: RAISE FND_API.G_EXC_ERROR;
1176: END IF;
1177: x_denorm_str := l_den_contains_str;
1178: RETURN l_contains_str;

Line 1394: FND_MSG_PUB.ADD;

1390: exception
1391: when others then
1392: if (instrb(SQLERRM,'DRG-51030')>0) then
1393: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1394: FND_MSG_PUB.ADD;
1395: RAISE FND_API.G_EXC_ERROR;
1396: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1397: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1398: FND_MSG_PUB.ADD;

Line 1398: FND_MSG_PUB.ADD;

1394: FND_MSG_PUB.ADD;
1395: RAISE FND_API.G_EXC_ERROR;
1396: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1397: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1398: FND_MSG_PUB.ADD;
1399: RAISE FND_API.G_EXC_ERROR;
1400: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1401: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1402: FND_MSG_PUB.ADD;

Line 1402: FND_MSG_PUB.ADD;

1398: FND_MSG_PUB.ADD;
1399: RAISE FND_API.G_EXC_ERROR;
1400: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1401: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1402: FND_MSG_PUB.ADD;
1403: RAISE FND_API.G_EXC_ERROR;
1404: else
1405: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1407: FND_MSG_PUB.ADD;

1403: RAISE FND_API.G_EXC_ERROR;
1404: else
1405: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1407: FND_MSG_PUB.ADD;
1408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1409: end if;
1410: END;
1411:

Line 1639: FND_MSG_PUB.ADD;

1635: exception
1636: when others then
1637: if (instrb(SQLERRM,'DRG-51030')>0) then
1638: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1639: FND_MSG_PUB.ADD;
1640: RAISE FND_API.G_EXC_ERROR;
1641: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1643: FND_MSG_PUB.ADD;

Line 1643: FND_MSG_PUB.ADD;

1639: FND_MSG_PUB.ADD;
1640: RAISE FND_API.G_EXC_ERROR;
1641: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1643: FND_MSG_PUB.ADD;
1644: RAISE FND_API.G_EXC_ERROR;
1645: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1646: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1647: FND_MSG_PUB.ADD;

Line 1647: FND_MSG_PUB.ADD;

1643: FND_MSG_PUB.ADD;
1644: RAISE FND_API.G_EXC_ERROR;
1645: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1646: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1647: FND_MSG_PUB.ADD;
1648: RAISE FND_API.G_EXC_ERROR;
1649: else
1650: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1652: FND_MSG_PUB.ADD;

1648: RAISE FND_API.G_EXC_ERROR;
1649: else
1650: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1652: FND_MSG_PUB.ADD;
1653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1654: end if;
1655: END;
1656:

Line 1786: FND_MSG_PUB.ADD;

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

Line 1790: FND_MSG_PUB.ADD;

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

Line 1794: FND_MSG_PUB.ADD;

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

Line 1799: FND_MSG_PUB.ADD;

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

Line 2059: FND_MSG_PUB.ADD;

2055: exception
2056: when others then
2057: if (instrb(SQLERRM,'DRG-51030')>0) then
2058: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2059: FND_MSG_PUB.ADD;
2060: RAISE FND_API.G_EXC_ERROR;
2061: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2062: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2063: FND_MSG_PUB.ADD;

Line 2063: FND_MSG_PUB.ADD;

2059: FND_MSG_PUB.ADD;
2060: RAISE FND_API.G_EXC_ERROR;
2061: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2062: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2063: FND_MSG_PUB.ADD;
2064: RAISE FND_API.G_EXC_ERROR;
2065: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2066: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2067: FND_MSG_PUB.ADD;

Line 2067: FND_MSG_PUB.ADD;

2063: FND_MSG_PUB.ADD;
2064: RAISE FND_API.G_EXC_ERROR;
2065: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2066: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2067: FND_MSG_PUB.ADD;
2068: RAISE FND_API.G_EXC_ERROR;
2069: else
2070: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2071: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2072: FND_MSG_PUB.ADD;

2068: RAISE FND_API.G_EXC_ERROR;
2069: else
2070: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2071: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2072: FND_MSG_PUB.ADD;
2073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2074: end if;
2075: END;
2076:

Line 2325: FND_MSG_PUB.ADD;

2321: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2322: 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);
2323: END IF;
2324: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2325: FND_MSG_PUB.ADD;
2326: RAISE FND_API.G_EXC_ERROR;
2327: ELSE
2328: push_eval;
2329: RETURN;

Line 2373: FND_MSG_PUB.ADD;

2369: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2370: 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);
2371: END IF;
2372: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2373: FND_MSG_PUB.ADD;
2374: RAISE FND_API.G_EXC_ERROR;
2375: ELSE
2376: push_eval;
2377: RETURN;

Line 2446: FND_MSG_PUB.ADD;

2442: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2443: 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);
2444: END IF;
2445: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2446: FND_MSG_PUB.ADD;
2447: RAISE FND_API.G_EXC_ERROR;
2448: ELSE
2449: push_eval;
2450: RETURN;

Line 2558: FND_MSG_PUB.ADD;

2554: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2555: 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);
2556: END IF;
2557: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2558: FND_MSG_PUB.ADD;
2559: RAISE FND_API.G_EXC_ERROR;
2560: ELSE
2561: push_eval;
2562: RETURN;

Line 2669: FND_MSG_PUB.ADD;

2665: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2666: 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);
2667: END IF;
2668: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2669: FND_MSG_PUB.ADD;
2670: RAISE FND_API.G_EXC_ERROR;
2671: ELSE
2672: push_eval;
2673: RETURN;

Line 2813: FND_MSG_PUB.ADD;

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

Line 2821: FND_MSG_PUB.ADD;

2817: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2818: 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);
2819: END IF;
2820: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2821: FND_MSG_PUB.ADD;
2822: RAISE FND_API.G_EXC_ERROR;
2823: END IF;
2824: END IF;
2825: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3072: FND_MSG_PUB.ADD;

3068: WHEN OTHERS THEN
3069: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3070: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_parties');
3071: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3072: FND_MSG_PUB.ADD;
3073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3074: END find_parties;
3075:
3076: PROCEDURE find_persons (

Line 3265: FND_MSG_PUB.ADD;

3261: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3262: 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);
3263: END IF;
3264: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3265: FND_MSG_PUB.ADD;
3266: RAISE FND_API.G_EXC_ERROR;
3267: ELSE
3268: push_eval;
3269: RETURN;

Line 3313: FND_MSG_PUB.ADD;

3309: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3310: 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);
3311: END IF;
3312: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3313: FND_MSG_PUB.ADD;
3314: RAISE FND_API.G_EXC_ERROR;
3315: ELSE
3316: push_eval;
3317: RETURN;

Line 3349: FND_MSG_PUB.ADD;

3345: exception
3346: when others then
3347: if (instrb(SQLERRM,'DRG-51030')>0) then
3348: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3349: FND_MSG_PUB.ADD;
3350: RAISE FND_API.G_EXC_ERROR;
3351: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3352: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3353: FND_MSG_PUB.ADD;

Line 3353: FND_MSG_PUB.ADD;

3349: FND_MSG_PUB.ADD;
3350: RAISE FND_API.G_EXC_ERROR;
3351: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3352: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3353: FND_MSG_PUB.ADD;
3354: RAISE FND_API.G_EXC_ERROR;
3355: else
3356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3357: end if;

Line 3425: FND_MSG_PUB.ADD;

3421: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3422: 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);
3423: END IF;
3424: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3425: FND_MSG_PUB.ADD;
3426: RAISE FND_API.G_EXC_ERROR;
3427: ELSE
3428: push_eval;
3429: RETURN;

Line 3614: FND_MSG_PUB.ADD;

3610: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3611: 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);
3612: END IF;
3613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3614: FND_MSG_PUB.ADD;
3615: RAISE FND_API.G_EXC_ERROR;
3616: ELSE
3617: push_eval;
3618: RETURN;

Line 3702: FND_MSG_PUB.ADD;

3698: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3699: 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);
3700: END IF;
3701: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3702: FND_MSG_PUB.ADD;
3703: RAISE FND_API.G_EXC_ERROR;
3704: END IF;
3705: ELSE
3706: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3710: FND_MSG_PUB.ADD;

3706: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3707: 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);
3708: END IF;
3709: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3710: FND_MSG_PUB.ADD;
3711: RAISE FND_API.G_EXC_ERROR;
3712: END IF;
3713: END IF;
3714: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3859: FND_MSG_PUB.ADD;

3855: WHEN OTHERS THEN
3856: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3857: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_persons');
3858: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3859: FND_MSG_PUB.ADD;
3860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3861: END find_persons;
3862:
3863: PROCEDURE find_persons (

Line 3927: FND_MSG_PUB.ADD;

3923: WHEN OTHERS THEN
3924: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3925: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_party_details');
3926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3927: FND_MSG_PUB.ADD;
3928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3929: END find_party_details;
3930:
3931: PROCEDURE find_duplicate_parties (

Line 4044: FND_MSG_PUB.ADD;

4040: WHEN OTHERS THEN
4041: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4042: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_parties');
4043: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4044: FND_MSG_PUB.ADD;
4045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4046: END find_duplicate_parties;
4047:
4048: PROCEDURE find_duplicate_party_sites (

Line 4129: FND_MSG_PUB.ADD;

4125: WHEN OTHERS THEN
4126: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4127: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_party_sites');
4128: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4129: FND_MSG_PUB.ADD;
4130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4131: END find_duplicate_party_sites;
4132:
4133: PROCEDURE find_duplicate_contacts (

Line 4218: FND_MSG_PUB.ADD;

4214: WHEN OTHERS THEN
4215: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4216: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contacts');
4217: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4218: FND_MSG_PUB.ADD;
4219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4220: END find_duplicate_contacts;
4221:
4222: PROCEDURE find_duplicate_contact_points (

Line 4291: FND_MSG_PUB.ADD;

4287: WHEN OTHERS THEN
4288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.find_duplicate_contact_points');
4290: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4291: FND_MSG_PUB.ADD;
4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4293: END find_duplicate_contact_points;
4294:
4295: PROCEDURE find_parties_dynamic (

Line 4599: FND_MSG_PUB.ADD;

4595: WHEN OTHERS THEN
4596: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4597: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.call_api_dynamic');
4598: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4599: FND_MSG_PUB.ADD;
4600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4601: END call_api_dynamic;
4602:
4603:

Line 4837: FND_MSG_PUB.ADD;

4833: WHEN OTHERS THEN
4834: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4835: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_party_sites');
4836: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4837: FND_MSG_PUB.ADD;
4838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4839: END get_matching_party_sites;
4840:
4841:

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_7.get_matching_contacts');
5064: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5065: FND_MSG_PUB.ADD;
5066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5067: END get_matching_contacts;
5068:
5069:

Line 5207: FND_MSG_PUB.ADD;

5203: WHEN OTHERS THEN
5204: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5205: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contact_points');
5206: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5207: FND_MSG_PUB.ADD;
5208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5209: END get_matching_contact_points;
5210:
5211: /**********************************************************

Line 5420: FND_MSG_PUB.ADD;

5416: WHEN OTHERS THEN
5417: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5418: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_score_details');
5419: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5420: FND_MSG_PUB.ADD;
5421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5422: END get_score_details;
5423:
5424:

Line 5530: FND_MSG_PUB.ADD;

5526: WHEN OTHERS THEN
5527: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5528: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5529: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5530: FND_MSG_PUB.ADD;
5531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5532: END get_party_for_search;
5533:
5534: PROCEDURE get_search_criteria (

Line 5576: FND_MSG_PUB.ADD;

5572: WHEN OTHERS THEN
5573: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5574: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5575: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5576: FND_MSG_PUB.ADD;
5577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5578: END get_search_criteria;
5579:
5580:

Line 5637: FND_MSG_PUB.ADD;

5633: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5634: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5635: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5636: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5637: FND_MSG_PUB.ADD;
5638: RAISE FND_API.G_EXC_ERROR;
5639: END get_party_rec;
5640:
5641: /************************************************

Line 5693: FND_MSG_PUB.ADD;

5689: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5690: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5691: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5692: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5693: FND_MSG_PUB.ADD;
5694: RAISE FND_API.G_EXC_ERROR;
5695: END get_party_site_rec;
5696:
5697: /************************************************

Line 5749: FND_MSG_PUB.ADD;

5745: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5746: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5747: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5748: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5749: FND_MSG_PUB.ADD;
5750: RAISE FND_API.G_EXC_ERROR;
5751: END get_contact_rec;
5752:
5753: /************************************************

Line 5805: FND_MSG_PUB.ADD;

5801: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5802: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5803: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5805: FND_MSG_PUB.ADD;
5806: RAISE FND_API.G_EXC_ERROR;
5807: END get_contact_point_rec;
5808:
5809: /************************************************

Line 5940: FND_MSG_PUB.ADD;

5936: WHEN OTHERS THEN
5937: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5938: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5939: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5940: FND_MSG_PUB.ADD;
5941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5942: END;
5943:
5944:

Line 6058: FND_MSG_PUB.ADD;

6054: WHEN OTHERS THEN
6055: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6056: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6057: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6058: FND_MSG_PUB.ADD;
6059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6060: END;
6061:
6062:

Line 6100: FND_MSG_PUB.ADD;

6096: WHEN OTHERS THEN
6097: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6098: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6099: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6100: FND_MSG_PUB.ADD;
6101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6102: END;
6103:
6104:

Line 6207: FND_MSG_PUB.ADD;

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

Line 6231: FND_MSG_PUB.ADD;

6227: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6228: p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6229: ) THEN
6230: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6231: FND_MSG_PUB.ADD;
6232: RAISE FND_API.G_EXC_ERROR;
6233: END IF;
6234: END LOOP;
6235:

Line 6265: FND_MSG_PUB.ADD;

6261: WHEN OTHERS THEN
6262: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6263: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6264: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6265: FND_MSG_PUB.ADD;
6266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6267: END check_prim_cond;
6268:
6269: /************************************************

Line 6320: FND_MSG_PUB.ADD;

6316: WHEN OTHERS THEN
6317: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6318: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6319: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6320: FND_MSG_PUB.ADD;
6321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6322: END check_party_site_cond;
6323:
6324: /************************************************

Line 6367: FND_MSG_PUB.ADD;

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

Line 6388: FND_MSG_PUB.ADD;

6384:
6385: FOR I IN 1..p_contact_point_list.COUNT LOOP
6386: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6387: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6388: FND_MSG_PUB.ADD;
6389: RAISE FND_API.G_EXC_ERROR;
6390: END IF;
6391: END LOOP;
6392:

Line 6413: FND_MSG_PUB.ADD;

6409: WHEN OTHERS THEN
6410: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6411: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6412: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6413: FND_MSG_PUB.ADD;
6414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6415: END check_contact_point_cond;
6416:
6417: FUNCTION check_staged RETURN BOOLEAN IS