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

732: WHEN OTHERS THEN
733: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
734: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
736: FND_MSG_PUB.ADD;
737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
738: END;
739:
740:

Line 761: FND_MSG_PUB.ADD;

757: WHEN OTHERS THEN
758: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
759: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
760: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
761: FND_MSG_PUB.ADD;
762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
763: END;
764:
765:

Line 781: FND_MSG_PUB.ADD;

777: WHEN OTHERS THEN
778: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
779: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
780: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
781: FND_MSG_PUB.ADD;
782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
783: END;
784:
785:

Line 801: FND_MSG_PUB.ADD;

797: WHEN OTHERS THEN
798: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
799: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
801: FND_MSG_PUB.ADD;
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
803: END;
804:
805: PROCEDURE init_score_context (

Line 868: FND_MSG_PUB.ADD;

864: p_party_site_list,
865: p_contact_list,
866: p_contact_point_list) THEN
867: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
868: FND_MSG_PUB.ADD;
869: RAISE FND_API.G_EXC_ERROR;
870: END IF;
871: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
872: 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 1069: FND_MSG_PUB.ADD;

1065: END IF;
1066: IF lengthb(l_party_contains_str) > 4000 THEN
1067: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1068: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1069: FND_MSG_PUB.ADD;
1070: RAISE FND_API.G_EXC_ERROR;
1071: END IF;
1072: IF (p_match_str = ' AND ' OR p_party_max_score 1073: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1188: FND_MSG_PUB.ADD;

1184: -- Add the search criteria to query string
1185: IF lengthb(l_contains_str) > 4000 THEN
1186: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1187: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1188: FND_MSG_PUB.ADD;
1189: RAISE FND_API.G_EXC_ERROR;
1190: END IF;
1191: x_denorm_str := l_den_contains_str;
1192: RETURN l_contains_str;

Line 1468: FND_MSG_PUB.ADD;

1464: exception
1465: when others then
1466: if (instrb(SQLERRM,'DRG-51030')>0) then
1467: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1468: FND_MSG_PUB.ADD;
1469: RAISE FND_API.G_EXC_ERROR;
1470: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1471: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1472: FND_MSG_PUB.ADD;

Line 1472: FND_MSG_PUB.ADD;

1468: FND_MSG_PUB.ADD;
1469: RAISE FND_API.G_EXC_ERROR;
1470: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1471: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1472: FND_MSG_PUB.ADD;
1473: RAISE FND_API.G_EXC_ERROR;
1474: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1475: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1476: FND_MSG_PUB.ADD;

Line 1476: FND_MSG_PUB.ADD;

1472: FND_MSG_PUB.ADD;
1473: RAISE FND_API.G_EXC_ERROR;
1474: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1475: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1476: FND_MSG_PUB.ADD;
1477: RAISE FND_API.G_EXC_ERROR;
1478: else
1479: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1480: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1481: FND_MSG_PUB.ADD;

1477: RAISE FND_API.G_EXC_ERROR;
1478: else
1479: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1480: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1481: FND_MSG_PUB.ADD;
1482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1483: end if;
1484: END;
1485:

Line 1713: FND_MSG_PUB.ADD;

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

Line 1717: FND_MSG_PUB.ADD;

1713: FND_MSG_PUB.ADD;
1714: RAISE FND_API.G_EXC_ERROR;
1715: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1716: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1717: FND_MSG_PUB.ADD;
1718: RAISE FND_API.G_EXC_ERROR;
1719: elsif (instrb(SQLERRM,'ORA-20000')>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,'ORA-20000')>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: else
1724: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1726: FND_MSG_PUB.ADD;

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

Line 1860: FND_MSG_PUB.ADD;

1856: exception
1857: when others then
1858: if (instrb(SQLERRM,'DRG-51030')>0) then
1859: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1860: FND_MSG_PUB.ADD;
1861: RAISE FND_API.G_EXC_ERROR;
1862: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1863: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1864: FND_MSG_PUB.ADD;

Line 1864: FND_MSG_PUB.ADD;

1860: FND_MSG_PUB.ADD;
1861: RAISE FND_API.G_EXC_ERROR;
1862: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1863: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1864: FND_MSG_PUB.ADD;
1865: RAISE FND_API.G_EXC_ERROR;
1866: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1867: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1868: FND_MSG_PUB.ADD;

Line 1868: FND_MSG_PUB.ADD;

1864: FND_MSG_PUB.ADD;
1865: RAISE FND_API.G_EXC_ERROR;
1866: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1867: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1868: FND_MSG_PUB.ADD;
1869: RAISE FND_API.G_EXC_ERROR;
1870: else
1871: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1872: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1873: FND_MSG_PUB.ADD;

1869: RAISE FND_API.G_EXC_ERROR;
1870: else
1871: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1872: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1873: FND_MSG_PUB.ADD;
1874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1875: end if;
1876: END;
1877:

Line 2133: FND_MSG_PUB.ADD;

2129: exception
2130: when others then
2131: if (instrb(SQLERRM,'DRG-51030')>0) then
2132: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2133: FND_MSG_PUB.ADD;
2134: RAISE FND_API.G_EXC_ERROR;
2135: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2136: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2137: FND_MSG_PUB.ADD;

Line 2137: FND_MSG_PUB.ADD;

2133: FND_MSG_PUB.ADD;
2134: RAISE FND_API.G_EXC_ERROR;
2135: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2136: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2137: FND_MSG_PUB.ADD;
2138: RAISE FND_API.G_EXC_ERROR;
2139: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2140: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2141: FND_MSG_PUB.ADD;

Line 2141: FND_MSG_PUB.ADD;

2137: FND_MSG_PUB.ADD;
2138: RAISE FND_API.G_EXC_ERROR;
2139: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2140: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2141: FND_MSG_PUB.ADD;
2142: RAISE FND_API.G_EXC_ERROR;
2143: else
2144: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2145: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2146: FND_MSG_PUB.ADD;

2142: RAISE FND_API.G_EXC_ERROR;
2143: else
2144: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2145: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2146: FND_MSG_PUB.ADD;
2147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2148: end if;
2149: END;
2150:

Line 2402: FND_MSG_PUB.ADD;

2398: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2399: 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);
2400: END IF;
2401: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2402: FND_MSG_PUB.ADD;
2403: RAISE FND_API.G_EXC_ERROR;
2404: ELSE
2405: push_eval;
2406: RETURN;

Line 2450: FND_MSG_PUB.ADD;

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

Line 2523: FND_MSG_PUB.ADD;

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

Line 2635: FND_MSG_PUB.ADD;

2631: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2632: 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);
2633: END IF;
2634: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2635: FND_MSG_PUB.ADD;
2636: RAISE FND_API.G_EXC_ERROR;
2637: ELSE
2638: push_eval;
2639: RETURN;

Line 2746: FND_MSG_PUB.ADD;

2742: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2743: 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);
2744: END IF;
2745: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2746: FND_MSG_PUB.ADD;
2747: RAISE FND_API.G_EXC_ERROR;
2748: ELSE
2749: push_eval;
2750: RETURN;

Line 2890: FND_MSG_PUB.ADD;

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

Line 2898: FND_MSG_PUB.ADD;

2894: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2895: 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);
2896: END IF;
2897: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2898: FND_MSG_PUB.ADD;
2899: RAISE FND_API.G_EXC_ERROR;
2900: END IF;
2901: END IF;
2902: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3149: FND_MSG_PUB.ADD;

3145: WHEN OTHERS THEN
3146: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3147: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_parties');
3148: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3149: FND_MSG_PUB.ADD;
3150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3151: END find_parties;
3152:
3153: PROCEDURE find_persons (

Line 3345: FND_MSG_PUB.ADD;

3341: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3342: 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);
3343: END IF;
3344: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3345: FND_MSG_PUB.ADD;
3346: RAISE FND_API.G_EXC_ERROR;
3347: ELSE
3348: push_eval;
3349: RETURN;

Line 3393: FND_MSG_PUB.ADD;

3389: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3390: 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);
3391: END IF;
3392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3393: FND_MSG_PUB.ADD;
3394: RAISE FND_API.G_EXC_ERROR;
3395: ELSE
3396: push_eval;
3397: RETURN;

Line 3429: FND_MSG_PUB.ADD;

3425: exception
3426: when others then
3427: if (instrb(SQLERRM,'DRG-51030')>0) then
3428: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3429: FND_MSG_PUB.ADD;
3430: RAISE FND_API.G_EXC_ERROR;
3431: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3432: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3433: FND_MSG_PUB.ADD;

Line 3433: FND_MSG_PUB.ADD;

3429: FND_MSG_PUB.ADD;
3430: RAISE FND_API.G_EXC_ERROR;
3431: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3432: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3433: FND_MSG_PUB.ADD;
3434: RAISE FND_API.G_EXC_ERROR;
3435: else
3436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3437: end if;

Line 3505: FND_MSG_PUB.ADD;

3501: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3502: 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);
3503: END IF;
3504: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3505: FND_MSG_PUB.ADD;
3506: RAISE FND_API.G_EXC_ERROR;
3507: ELSE
3508: push_eval;
3509: RETURN;

Line 3694: FND_MSG_PUB.ADD;

3690: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3691: 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);
3692: END IF;
3693: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3694: FND_MSG_PUB.ADD;
3695: RAISE FND_API.G_EXC_ERROR;
3696: ELSE
3697: push_eval;
3698: RETURN;

Line 3782: FND_MSG_PUB.ADD;

3778: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3779: 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);
3780: END IF;
3781: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3782: FND_MSG_PUB.ADD;
3783: RAISE FND_API.G_EXC_ERROR;
3784: END IF;
3785: ELSE
3786: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3790: FND_MSG_PUB.ADD;

3786: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3787: 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);
3788: END IF;
3789: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3790: FND_MSG_PUB.ADD;
3791: RAISE FND_API.G_EXC_ERROR;
3792: END IF;
3793: END IF;
3794: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3939: FND_MSG_PUB.ADD;

3935: WHEN OTHERS THEN
3936: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3937: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_persons');
3938: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3939: FND_MSG_PUB.ADD;
3940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3941: END find_persons;
3942:
3943: PROCEDURE find_persons (

Line 4007: FND_MSG_PUB.ADD;

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

Line 4124: FND_MSG_PUB.ADD;

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

Line 4209: FND_MSG_PUB.ADD;

4205: WHEN OTHERS THEN
4206: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4207: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_party_sites');
4208: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4209: FND_MSG_PUB.ADD;
4210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4211: END find_duplicate_party_sites;
4212:
4213: PROCEDURE find_duplicate_contacts (

Line 4298: FND_MSG_PUB.ADD;

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

Line 4371: FND_MSG_PUB.ADD;

4367: WHEN OTHERS THEN
4368: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4369: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_contact_points');
4370: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4371: FND_MSG_PUB.ADD;
4372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4373: END find_duplicate_contact_points;
4374:
4375: PROCEDURE find_parties_dynamic (

Line 4652: FND_MSG_PUB.ADD;

4648: WHEN OTHERS THEN
4649: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4650: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.call_api_dynamic');
4651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4652: FND_MSG_PUB.ADD;
4653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4654: END call_api_dynamic;
4655:
4656:

Line 4896: FND_MSG_PUB.ADD;

4892: WHEN OTHERS THEN
4893: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4894: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_party_sites');
4895: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4896: FND_MSG_PUB.ADD;
4897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4898: END get_matching_party_sites;
4899:
4900:

Line 5121: FND_MSG_PUB.ADD;

5117: WHEN OTHERS THEN
5118: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5119: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_contacts');
5120: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5121: FND_MSG_PUB.ADD;
5122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5123: END get_matching_contacts;
5124:
5125:

Line 5260: FND_MSG_PUB.ADD;

5256: WHEN OTHERS THEN
5257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5258: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_contact_points');
5259: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5260: FND_MSG_PUB.ADD;
5261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5262: END get_matching_contact_points;
5263:
5264: /**********************************************************

Line 5484: FND_MSG_PUB.ADD;

5480: WHEN OTHERS THEN
5481: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5482: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_score_details');
5483: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5484: FND_MSG_PUB.ADD;
5485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5486: END get_score_details;
5487:
5488:

Line 5562: FND_MSG_PUB.ADD;

5558: WHEN OTHERS THEN
5559: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5560: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5561: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5562: FND_MSG_PUB.ADD;
5563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5564: END get_party_for_search;
5565:
5566: PROCEDURE get_search_criteria (

Line 5596: FND_MSG_PUB.ADD;

5592: WHEN OTHERS THEN
5593: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5594: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5595: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5596: FND_MSG_PUB.ADD;
5597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5598: END get_search_criteria;
5599:
5600:

Line 5639: FND_MSG_PUB.ADD;

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

Line 5705: FND_MSG_PUB.ADD;

5701: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5702: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5703: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5705: FND_MSG_PUB.ADD;
5706: RAISE FND_API.G_EXC_ERROR;
5707: END get_party_site_rec;
5708:
5709: /************************************************

Line 5761: FND_MSG_PUB.ADD;

5757: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5758: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5759: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5760: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5761: FND_MSG_PUB.ADD;
5762: RAISE FND_API.G_EXC_ERROR;
5763: END get_contact_rec;
5764:
5765: /************************************************

Line 5813: FND_MSG_PUB.ADD;

5809: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5810: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5811: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5812: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5813: FND_MSG_PUB.ADD;
5814: RAISE FND_API.G_EXC_ERROR;
5815: END get_contact_point_rec;
5816:
5817: /************************************************

Line 5864: FND_MSG_PUB.ADD;

5860: WHEN OTHERS THEN
5861: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5862: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5863: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5864: FND_MSG_PUB.ADD;
5865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5866: END;
5867:
5868:

Line 6134: FND_MSG_PUB.ADD;

6130: WHEN OTHERS THEN
6131: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6132: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6133: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6134: FND_MSG_PUB.ADD;
6135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6136: END;
6137:
6138:

Line 6176: FND_MSG_PUB.ADD;

6172: WHEN OTHERS THEN
6173: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6174: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6175: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6176: FND_MSG_PUB.ADD;
6177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6178: END;
6179:
6180:

Line 6219: FND_MSG_PUB.ADD;

6215: WHEN OTHERS THEN
6216: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6217: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6218: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6219: FND_MSG_PUB.ADD;
6220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6221: END;
6222:
6223:

Line 6281: FND_MSG_PUB.ADD;

6277: WHEN OTHERS THEN
6278: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6279: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6280: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6281: FND_MSG_PUB.ADD;
6282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6283: END check_prim_cond;
6284:
6285: /************************************************

Line 6337: FND_MSG_PUB.ADD;

6333: WHEN OTHERS THEN
6334: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6335: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6336: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6337: FND_MSG_PUB.ADD;
6338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6339: END check_party_site_cond;
6340:
6341: /************************************************

Line 6375: FND_MSG_PUB.ADD;

6371: WHEN OTHERS THEN
6372: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6373: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6374: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6375: FND_MSG_PUB.ADD;
6376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6377: END check_contact_cond;
6378:
6379: /************************************************

Line 6396: FND_MSG_PUB.ADD;

6392:
6393: FOR I IN 1..p_contact_point_list.COUNT LOOP
6394: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6395: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6396: FND_MSG_PUB.ADD;
6397: RAISE FND_API.G_EXC_ERROR;
6398: END IF;
6399: END LOOP;
6400:

Line 6412: FND_MSG_PUB.ADD;

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