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

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

Line 1396: FND_MSG_PUB.ADD;

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

Line 1400: FND_MSG_PUB.ADD;

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

Line 1405: FND_MSG_PUB.ADD;

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

Line 1637: FND_MSG_PUB.ADD;

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

Line 1641: FND_MSG_PUB.ADD;

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

Line 1645: FND_MSG_PUB.ADD;

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

Line 1650: FND_MSG_PUB.ADD;

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

Line 1784: FND_MSG_PUB.ADD;

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

Line 1788: FND_MSG_PUB.ADD;

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

Line 1792: FND_MSG_PUB.ADD;

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

Line 1797: FND_MSG_PUB.ADD;

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

Line 2057: FND_MSG_PUB.ADD;

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

Line 2061: FND_MSG_PUB.ADD;

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

Line 2065: FND_MSG_PUB.ADD;

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

Line 2070: FND_MSG_PUB.ADD;

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

Line 2322: FND_MSG_PUB.ADD;

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

Line 2370: FND_MSG_PUB.ADD;

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

Line 2443: FND_MSG_PUB.ADD;

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

Line 2555: FND_MSG_PUB.ADD;

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

Line 2666: FND_MSG_PUB.ADD;

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

Line 2810: FND_MSG_PUB.ADD;

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

Line 2818: FND_MSG_PUB.ADD;

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

Line 3069: FND_MSG_PUB.ADD;

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

Line 3261: FND_MSG_PUB.ADD;

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

Line 3309: FND_MSG_PUB.ADD;

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

Line 3345: FND_MSG_PUB.ADD;

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

Line 3349: FND_MSG_PUB.ADD;

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

Line 3421: FND_MSG_PUB.ADD;

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

Line 3610: FND_MSG_PUB.ADD;

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

Line 3698: FND_MSG_PUB.ADD;

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

Line 3706: FND_MSG_PUB.ADD;

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

Line 3855: FND_MSG_PUB.ADD;

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

Line 3923: FND_MSG_PUB.ADD;

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

Line 4040: FND_MSG_PUB.ADD;

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

Line 4125: FND_MSG_PUB.ADD;

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

Line 4214: FND_MSG_PUB.ADD;

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

Line 4287: FND_MSG_PUB.ADD;

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

Line 4595: FND_MSG_PUB.ADD;

4591: WHEN OTHERS THEN
4592: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4593: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.call_api_dynamic');
4594: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4595: FND_MSG_PUB.ADD;
4596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4597: END call_api_dynamic;
4598:
4599:

Line 4833: FND_MSG_PUB.ADD;

4829: WHEN OTHERS THEN
4830: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4831: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_party_sites');
4832: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4833: FND_MSG_PUB.ADD;
4834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4835: END get_matching_party_sites;
4836:
4837:

Line 5061: FND_MSG_PUB.ADD;

5057: WHEN OTHERS THEN
5058: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5059: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_matching_contacts');
5060: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5061: FND_MSG_PUB.ADD;
5062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5063: END get_matching_contacts;
5064:
5065:

Line 5203: FND_MSG_PUB.ADD;

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

Line 5415: FND_MSG_PUB.ADD;

5411: WHEN OTHERS THEN
5412: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5413: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_7.get_score_details');
5414: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5415: FND_MSG_PUB.ADD;
5416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5417: END get_score_details;
5418:
5419:

Line 5525: FND_MSG_PUB.ADD;

5521: WHEN OTHERS THEN
5522: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5523: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5524: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5525: FND_MSG_PUB.ADD;
5526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5527: END get_party_for_search;
5528:
5529: PROCEDURE get_search_criteria (

Line 5571: FND_MSG_PUB.ADD;

5567: WHEN OTHERS THEN
5568: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5569: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5570: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5571: FND_MSG_PUB.ADD;
5572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5573: END get_search_criteria;
5574:
5575:

Line 5632: FND_MSG_PUB.ADD;

5628: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5629: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5630: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5631: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5632: FND_MSG_PUB.ADD;
5633: RAISE FND_API.G_EXC_ERROR;
5634: END get_party_rec;
5635:
5636: /************************************************

Line 5688: FND_MSG_PUB.ADD;

5684: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5685: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5686: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5687: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5688: FND_MSG_PUB.ADD;
5689: RAISE FND_API.G_EXC_ERROR;
5690: END get_party_site_rec;
5691:
5692: /************************************************

Line 5744: FND_MSG_PUB.ADD;

5740: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5741: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5742: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5743: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5744: FND_MSG_PUB.ADD;
5745: RAISE FND_API.G_EXC_ERROR;
5746: END get_contact_rec;
5747:
5748: /************************************************

Line 5800: FND_MSG_PUB.ADD;

5796: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5797: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5798: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5800: FND_MSG_PUB.ADD;
5801: RAISE FND_API.G_EXC_ERROR;
5802: END get_contact_point_rec;
5803:
5804: /************************************************

Line 5935: FND_MSG_PUB.ADD;

5931: WHEN OTHERS THEN
5932: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5933: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5934: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5935: FND_MSG_PUB.ADD;
5936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5937: END;
5938:
5939:

Line 6053: FND_MSG_PUB.ADD;

6049: WHEN OTHERS THEN
6050: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6051: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6052: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6053: FND_MSG_PUB.ADD;
6054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6055: END;
6056:
6057:

Line 6095: FND_MSG_PUB.ADD;

6091: WHEN OTHERS THEN
6092: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6093: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6094: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6095: FND_MSG_PUB.ADD;
6096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6097: END;
6098:
6099:

Line 6202: FND_MSG_PUB.ADD;

6198: WHEN OTHERS THEN
6199: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6200: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6201: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6202: FND_MSG_PUB.ADD;
6203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6204: END;
6205:
6206:

Line 6226: FND_MSG_PUB.ADD;

6222: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6223: p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6224: ) THEN
6225: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6226: FND_MSG_PUB.ADD;
6227: RAISE FND_API.G_EXC_ERROR;
6228: END IF;
6229: END LOOP;
6230:

Line 6260: FND_MSG_PUB.ADD;

6256: WHEN OTHERS THEN
6257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6258: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6259: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6260: FND_MSG_PUB.ADD;
6261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6262: END check_prim_cond;
6263:
6264: /************************************************

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_party_site_cond');
6314: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6315: FND_MSG_PUB.ADD;
6316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6317: END check_party_site_cond;
6318:
6319: /************************************************

Line 6362: FND_MSG_PUB.ADD;

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

Line 6383: FND_MSG_PUB.ADD;

6379:
6380: FOR I IN 1..p_contact_point_list.COUNT LOOP
6381: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6382: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6383: FND_MSG_PUB.ADD;
6384: RAISE FND_API.G_EXC_ERROR;
6385: END IF;
6386: END LOOP;
6387:

Line 6408: FND_MSG_PUB.ADD;

6404: WHEN OTHERS THEN
6405: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6406: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6407: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6408: FND_MSG_PUB.ADD;
6409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6410: END check_contact_point_cond;
6411:
6412: FUNCTION check_staged RETURN BOOLEAN IS