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

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

Line 1470: FND_MSG_PUB.ADD;

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

Line 1474: FND_MSG_PUB.ADD;

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

Line 1479: FND_MSG_PUB.ADD;

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

Line 1711: FND_MSG_PUB.ADD;

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

Line 1715: FND_MSG_PUB.ADD;

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

Line 1719: FND_MSG_PUB.ADD;

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

Line 1724: FND_MSG_PUB.ADD;

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

Line 1858: FND_MSG_PUB.ADD;

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

Line 1862: FND_MSG_PUB.ADD;

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

Line 1866: FND_MSG_PUB.ADD;

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

Line 1871: FND_MSG_PUB.ADD;

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

Line 2131: FND_MSG_PUB.ADD;

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

Line 2135: FND_MSG_PUB.ADD;

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

Line 2139: FND_MSG_PUB.ADD;

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

Line 2144: FND_MSG_PUB.ADD;

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

Line 2399: FND_MSG_PUB.ADD;

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

Line 2447: FND_MSG_PUB.ADD;

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

Line 2520: FND_MSG_PUB.ADD;

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

Line 2632: FND_MSG_PUB.ADD;

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

Line 2743: FND_MSG_PUB.ADD;

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

Line 2895: FND_MSG_PUB.ADD;

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

Line 3146: FND_MSG_PUB.ADD;

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

Line 3341: FND_MSG_PUB.ADD;

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

Line 3389: FND_MSG_PUB.ADD;

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

Line 3425: FND_MSG_PUB.ADD;

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

Line 3429: FND_MSG_PUB.ADD;

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

Line 3501: FND_MSG_PUB.ADD;

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

Line 3690: FND_MSG_PUB.ADD;

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

Line 3778: FND_MSG_PUB.ADD;

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

Line 3786: FND_MSG_PUB.ADD;

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

Line 3935: FND_MSG_PUB.ADD;

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

Line 4003: FND_MSG_PUB.ADD;

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

Line 4120: FND_MSG_PUB.ADD;

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

Line 4205: FND_MSG_PUB.ADD;

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

Line 4294: FND_MSG_PUB.ADD;

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

Line 4367: FND_MSG_PUB.ADD;

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

Line 4648: FND_MSG_PUB.ADD;

4644: WHEN OTHERS THEN
4645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4646: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.call_api_dynamic');
4647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4648: FND_MSG_PUB.ADD;
4649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4650: END call_api_dynamic;
4651:
4652:

Line 4892: FND_MSG_PUB.ADD;

4888: WHEN OTHERS THEN
4889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4890: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_party_sites');
4891: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4892: FND_MSG_PUB.ADD;
4893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4894: END get_matching_party_sites;
4895:
4896:

Line 5117: FND_MSG_PUB.ADD;

5113: WHEN OTHERS THEN
5114: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5115: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_contacts');
5116: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5117: FND_MSG_PUB.ADD;
5118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5119: END get_matching_contacts;
5120:
5121:

Line 5256: FND_MSG_PUB.ADD;

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

Line 5479: FND_MSG_PUB.ADD;

5475: WHEN OTHERS THEN
5476: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5477: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_score_details');
5478: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5479: FND_MSG_PUB.ADD;
5480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5481: END get_score_details;
5482:
5483:

Line 5557: FND_MSG_PUB.ADD;

5553: WHEN OTHERS THEN
5554: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5555: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5556: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5557: FND_MSG_PUB.ADD;
5558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5559: END get_party_for_search;
5560:
5561: PROCEDURE get_search_criteria (

Line 5591: FND_MSG_PUB.ADD;

5587: WHEN OTHERS THEN
5588: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5589: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5590: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5591: FND_MSG_PUB.ADD;
5592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5593: END get_search_criteria;
5594:
5595:

Line 5634: FND_MSG_PUB.ADD;

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

Line 5700: FND_MSG_PUB.ADD;

5696: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5697: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5698: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5699: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5700: FND_MSG_PUB.ADD;
5701: RAISE FND_API.G_EXC_ERROR;
5702: END get_party_site_rec;
5703:
5704: /************************************************

Line 5756: FND_MSG_PUB.ADD;

5752: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5753: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5754: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5755: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5756: FND_MSG_PUB.ADD;
5757: RAISE FND_API.G_EXC_ERROR;
5758: END get_contact_rec;
5759:
5760: /************************************************

Line 5808: FND_MSG_PUB.ADD;

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

Line 5859: FND_MSG_PUB.ADD;

5855: WHEN OTHERS THEN
5856: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5857: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5858: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5859: FND_MSG_PUB.ADD;
5860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5861: END;
5862:
5863:

Line 6129: FND_MSG_PUB.ADD;

6125: WHEN OTHERS THEN
6126: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6127: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6128: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6129: FND_MSG_PUB.ADD;
6130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6131: END;
6132:
6133:

Line 6171: FND_MSG_PUB.ADD;

6167: WHEN OTHERS THEN
6168: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6169: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6170: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6171: FND_MSG_PUB.ADD;
6172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6173: END;
6174:
6175:

Line 6214: FND_MSG_PUB.ADD;

6210: WHEN OTHERS THEN
6211: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6212: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6213: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6214: FND_MSG_PUB.ADD;
6215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6216: END;
6217:
6218:

Line 6276: FND_MSG_PUB.ADD;

6272: WHEN OTHERS THEN
6273: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6274: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6275: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6276: FND_MSG_PUB.ADD;
6277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6278: END check_prim_cond;
6279:
6280: /************************************************

Line 6332: FND_MSG_PUB.ADD;

6328: WHEN OTHERS THEN
6329: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6330: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6331: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6332: FND_MSG_PUB.ADD;
6333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6334: END check_party_site_cond;
6335:
6336: /************************************************

Line 6370: FND_MSG_PUB.ADD;

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

Line 6391: FND_MSG_PUB.ADD;

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

Line 6407: FND_MSG_PUB.ADD;

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