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

477: WHEN OTHERS THEN
478: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
479: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
480: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
481: FND_MSG_PUB.ADD;
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
483: END;
484:
485:

Line 501: FND_MSG_PUB.ADD;

497: WHEN OTHERS THEN
498: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
499: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
500: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
501: FND_MSG_PUB.ADD;
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END;
504:
505:

Line 521: FND_MSG_PUB.ADD;

517: WHEN OTHERS THEN
518: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
519: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
520: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
521: FND_MSG_PUB.ADD;
522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
523: END;
524:
525:

Line 541: FND_MSG_PUB.ADD;

537: WHEN OTHERS THEN
538: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
539: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
540: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
541: FND_MSG_PUB.ADD;
542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
543: END;
544:
545: PROCEDURE init_score_context (

Line 608: FND_MSG_PUB.ADD;

604: p_party_site_list,
605: p_contact_list,
606: p_contact_point_list) THEN
607: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
608: FND_MSG_PUB.ADD;
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;
611: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
612: 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 826: FND_MSG_PUB.ADD;

822: END IF;
823: IF lengthb(l_party_contains_str) > 4000 THEN
824: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
825: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
826: FND_MSG_PUB.ADD;
827: RAISE FND_API.G_EXC_ERROR;
828: END IF;
829: IF (p_match_str = ' AND ' OR p_party_max_score 830: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 888: FND_MSG_PUB.ADD;

884: -- Add the search criteria to query string
885: IF lengthb(l_contains_str) > 4000 THEN
886: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
887: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
888: FND_MSG_PUB.ADD;
889: RAISE FND_API.G_EXC_ERROR;
890: END IF;
891: x_denorm_str := l_den_contains_str;
892: RETURN l_contains_str;

Line 1137: FND_MSG_PUB.ADD;

1133: exception
1134: when others then
1135: if (instrb(SQLERRM,'DRG-51030')>0) then
1136: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1137: FND_MSG_PUB.ADD;
1138: RAISE FND_API.G_EXC_ERROR;
1139: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1140: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1141: FND_MSG_PUB.ADD;

Line 1141: FND_MSG_PUB.ADD;

1137: FND_MSG_PUB.ADD;
1138: RAISE FND_API.G_EXC_ERROR;
1139: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1140: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1141: FND_MSG_PUB.ADD;
1142: RAISE FND_API.G_EXC_ERROR;
1143: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1144: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1145: FND_MSG_PUB.ADD;

Line 1145: FND_MSG_PUB.ADD;

1141: FND_MSG_PUB.ADD;
1142: RAISE FND_API.G_EXC_ERROR;
1143: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1144: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1145: FND_MSG_PUB.ADD;
1146: RAISE FND_API.G_EXC_ERROR;
1147: else
1148: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1149: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1150: FND_MSG_PUB.ADD;

1146: RAISE FND_API.G_EXC_ERROR;
1147: else
1148: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1149: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1150: FND_MSG_PUB.ADD;
1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1152: end if;
1153: END;
1154:

Line 1382: FND_MSG_PUB.ADD;

1378: exception
1379: when others then
1380: if (instrb(SQLERRM,'DRG-51030')>0) then
1381: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1382: FND_MSG_PUB.ADD;
1383: RAISE FND_API.G_EXC_ERROR;
1384: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1385: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1386: FND_MSG_PUB.ADD;

Line 1386: FND_MSG_PUB.ADD;

1382: FND_MSG_PUB.ADD;
1383: RAISE FND_API.G_EXC_ERROR;
1384: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1385: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1386: FND_MSG_PUB.ADD;
1387: RAISE FND_API.G_EXC_ERROR;
1388: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1389: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1390: FND_MSG_PUB.ADD;

Line 1390: FND_MSG_PUB.ADD;

1386: FND_MSG_PUB.ADD;
1387: RAISE FND_API.G_EXC_ERROR;
1388: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1389: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1390: FND_MSG_PUB.ADD;
1391: RAISE FND_API.G_EXC_ERROR;
1392: else
1393: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1394: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1395: FND_MSG_PUB.ADD;

1391: RAISE FND_API.G_EXC_ERROR;
1392: else
1393: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1394: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1395: FND_MSG_PUB.ADD;
1396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1397: end if;
1398: END;
1399:

Line 1529: FND_MSG_PUB.ADD;

1525: exception
1526: when others then
1527: if (instrb(SQLERRM,'DRG-51030')>0) then
1528: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1529: FND_MSG_PUB.ADD;
1530: RAISE FND_API.G_EXC_ERROR;
1531: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1532: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1533: FND_MSG_PUB.ADD;

Line 1533: FND_MSG_PUB.ADD;

1529: FND_MSG_PUB.ADD;
1530: RAISE FND_API.G_EXC_ERROR;
1531: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1532: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1533: FND_MSG_PUB.ADD;
1534: RAISE FND_API.G_EXC_ERROR;
1535: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1536: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1537: FND_MSG_PUB.ADD;

Line 1537: FND_MSG_PUB.ADD;

1533: FND_MSG_PUB.ADD;
1534: RAISE FND_API.G_EXC_ERROR;
1535: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1536: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1537: FND_MSG_PUB.ADD;
1538: RAISE FND_API.G_EXC_ERROR;
1539: else
1540: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1541: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1542: FND_MSG_PUB.ADD;

1538: RAISE FND_API.G_EXC_ERROR;
1539: else
1540: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1541: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1542: FND_MSG_PUB.ADD;
1543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1544: end if;
1545: END;
1546:

Line 1802: FND_MSG_PUB.ADD;

1798: exception
1799: when others then
1800: if (instrb(SQLERRM,'DRG-51030')>0) then
1801: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1802: FND_MSG_PUB.ADD;
1803: RAISE FND_API.G_EXC_ERROR;
1804: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1805: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1806: FND_MSG_PUB.ADD;

Line 1806: FND_MSG_PUB.ADD;

1802: FND_MSG_PUB.ADD;
1803: RAISE FND_API.G_EXC_ERROR;
1804: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1805: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1806: FND_MSG_PUB.ADD;
1807: RAISE FND_API.G_EXC_ERROR;
1808: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1809: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1810: FND_MSG_PUB.ADD;

Line 1810: FND_MSG_PUB.ADD;

1806: FND_MSG_PUB.ADD;
1807: RAISE FND_API.G_EXC_ERROR;
1808: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1809: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1810: FND_MSG_PUB.ADD;
1811: RAISE FND_API.G_EXC_ERROR;
1812: else
1813: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1814: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1815: FND_MSG_PUB.ADD;

1811: RAISE FND_API.G_EXC_ERROR;
1812: else
1813: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1814: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1815: FND_MSG_PUB.ADD;
1816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1817: end if;
1818: END;
1819:

Line 2062: FND_MSG_PUB.ADD;

2058: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2059: 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);
2060: END IF;
2061: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2062: FND_MSG_PUB.ADD;
2063: RAISE FND_API.G_EXC_ERROR;
2064: ELSE
2065: push_eval;
2066: RETURN;

Line 2110: FND_MSG_PUB.ADD;

2106: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2107: 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);
2108: END IF;
2109: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2110: FND_MSG_PUB.ADD;
2111: RAISE FND_API.G_EXC_ERROR;
2112: ELSE
2113: push_eval;
2114: RETURN;

Line 2183: FND_MSG_PUB.ADD;

2179: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2180: 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);
2181: END IF;
2182: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2183: FND_MSG_PUB.ADD;
2184: RAISE FND_API.G_EXC_ERROR;
2185: ELSE
2186: push_eval;
2187: RETURN;

Line 2295: FND_MSG_PUB.ADD;

2291: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2292: 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);
2293: END IF;
2294: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2295: FND_MSG_PUB.ADD;
2296: RAISE FND_API.G_EXC_ERROR;
2297: ELSE
2298: push_eval;
2299: RETURN;

Line 2406: FND_MSG_PUB.ADD;

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

Line 2550: FND_MSG_PUB.ADD;

2546: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2547: 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);
2548: END IF;
2549: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2550: FND_MSG_PUB.ADD;
2551: RAISE FND_API.G_EXC_ERROR;
2552: END IF;
2553: ELSE
2554: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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 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);
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: END IF;
2561: END IF;
2562: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 2809: FND_MSG_PUB.ADD;

2805: WHEN OTHERS THEN
2806: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2807: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_parties');
2808: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2809: FND_MSG_PUB.ADD;
2810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2811: END find_parties;
2812:
2813: PROCEDURE find_persons (

Line 2996: FND_MSG_PUB.ADD;

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

Line 3044: FND_MSG_PUB.ADD;

3040: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3041: 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);
3042: END IF;
3043: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3044: FND_MSG_PUB.ADD;
3045: RAISE FND_API.G_EXC_ERROR;
3046: ELSE
3047: push_eval;
3048: RETURN;

Line 3080: FND_MSG_PUB.ADD;

3076: exception
3077: when others then
3078: if (instrb(SQLERRM,'DRG-51030')>0) then
3079: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3080: FND_MSG_PUB.ADD;
3081: RAISE FND_API.G_EXC_ERROR;
3082: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3083: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3084: FND_MSG_PUB.ADD;

Line 3084: FND_MSG_PUB.ADD;

3080: FND_MSG_PUB.ADD;
3081: RAISE FND_API.G_EXC_ERROR;
3082: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3083: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3084: FND_MSG_PUB.ADD;
3085: RAISE FND_API.G_EXC_ERROR;
3086: else
3087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3088: end if;

Line 3156: FND_MSG_PUB.ADD;

3152: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3153: 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);
3154: END IF;
3155: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3156: FND_MSG_PUB.ADD;
3157: RAISE FND_API.G_EXC_ERROR;
3158: ELSE
3159: push_eval;
3160: RETURN;

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

3429: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3430: 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);
3431: END IF;
3432: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3433: FND_MSG_PUB.ADD;
3434: RAISE FND_API.G_EXC_ERROR;
3435: END IF;
3436: ELSE
3437: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3441: FND_MSG_PUB.ADD;

3437: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3438: 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);
3439: END IF;
3440: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3441: FND_MSG_PUB.ADD;
3442: RAISE FND_API.G_EXC_ERROR;
3443: END IF;
3444: END IF;
3445: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3590: FND_MSG_PUB.ADD;

3586: WHEN OTHERS THEN
3587: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3588: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_persons');
3589: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3590: FND_MSG_PUB.ADD;
3591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3592: END find_persons;
3593:
3594: PROCEDURE find_persons (

Line 3658: FND_MSG_PUB.ADD;

3654: WHEN OTHERS THEN
3655: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3656: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_party_details');
3657: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3658: FND_MSG_PUB.ADD;
3659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3660: END find_party_details;
3661:
3662: PROCEDURE find_duplicate_parties (

Line 3775: FND_MSG_PUB.ADD;

3771: WHEN OTHERS THEN
3772: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3773: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_parties');
3774: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3775: FND_MSG_PUB.ADD;
3776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3777: END find_duplicate_parties;
3778:
3779: PROCEDURE find_duplicate_party_sites (

Line 3860: FND_MSG_PUB.ADD;

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

Line 3949: FND_MSG_PUB.ADD;

3945: WHEN OTHERS THEN
3946: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3947: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contacts');
3948: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3949: FND_MSG_PUB.ADD;
3950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3951: END find_duplicate_contacts;
3952:
3953: PROCEDURE find_duplicate_contact_points (

Line 4022: FND_MSG_PUB.ADD;

4018: WHEN OTHERS THEN
4019: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4020: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.find_duplicate_contact_points');
4021: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4022: FND_MSG_PUB.ADD;
4023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4024: END find_duplicate_contact_points;
4025:
4026: PROCEDURE find_parties_dynamic (

Line 4282: FND_MSG_PUB.ADD;

4278: WHEN OTHERS THEN
4279: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4280: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.call_api_dynamic');
4281: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4282: FND_MSG_PUB.ADD;
4283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4284: END call_api_dynamic;
4285:
4286:

Line 4516: FND_MSG_PUB.ADD;

4512: WHEN OTHERS THEN
4513: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4514: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_party_sites');
4515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4516: FND_MSG_PUB.ADD;
4517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4518: END get_matching_party_sites;
4519:
4520:

Line 4741: FND_MSG_PUB.ADD;

4737: WHEN OTHERS THEN
4738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4739: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contacts');
4740: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4741: FND_MSG_PUB.ADD;
4742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4743: END get_matching_contacts;
4744:
4745:

Line 4880: FND_MSG_PUB.ADD;

4876: WHEN OTHERS THEN
4877: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4878: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_matching_contact_points');
4879: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4880: FND_MSG_PUB.ADD;
4881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4882: END get_matching_contact_points;
4883:
4884: /**********************************************************

Line 5078: FND_MSG_PUB.ADD;

5074: WHEN OTHERS THEN
5075: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5076: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_5.get_score_details');
5077: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5078: FND_MSG_PUB.ADD;
5079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5080: END get_score_details;
5081:
5082:

Line 5156: FND_MSG_PUB.ADD;

5152: WHEN OTHERS THEN
5153: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5154: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5155: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5156: FND_MSG_PUB.ADD;
5157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5158: END get_party_for_search;
5159:
5160: PROCEDURE get_search_criteria (

Line 5196: FND_MSG_PUB.ADD;

5192: WHEN OTHERS THEN
5193: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5194: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5195: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5196: FND_MSG_PUB.ADD;
5197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5198: END get_search_criteria;
5199:
5200:

Line 5257: FND_MSG_PUB.ADD;

5253: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5254: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5255: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5256: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5257: FND_MSG_PUB.ADD;
5258: RAISE FND_API.G_EXC_ERROR;
5259: END get_party_rec;
5260:
5261: /************************************************

Line 5313: FND_MSG_PUB.ADD;

5309: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5310: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5311: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5312: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5313: FND_MSG_PUB.ADD;
5314: RAISE FND_API.G_EXC_ERROR;
5315: END get_party_site_rec;
5316:
5317: /************************************************

Line 5369: FND_MSG_PUB.ADD;

5365: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5366: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5367: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5368: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5369: FND_MSG_PUB.ADD;
5370: RAISE FND_API.G_EXC_ERROR;
5371: END get_contact_rec;
5372:
5373: /************************************************

Line 5421: FND_MSG_PUB.ADD;

5417: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5418: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5419: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5420: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5421: FND_MSG_PUB.ADD;
5422: RAISE FND_API.G_EXC_ERROR;
5423: END get_contact_point_rec;
5424:
5425: /************************************************

Line 5526: FND_MSG_PUB.ADD;

5522: WHEN OTHERS THEN
5523: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5524: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5525: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5526: FND_MSG_PUB.ADD;
5527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5528: END;
5529:
5530:

Line 5641: FND_MSG_PUB.ADD;

5637: WHEN OTHERS THEN
5638: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5639: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5640: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5641: FND_MSG_PUB.ADD;
5642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5643: END;
5644:
5645:

Line 5683: FND_MSG_PUB.ADD;

5679: WHEN OTHERS THEN
5680: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5681: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5682: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5683: FND_MSG_PUB.ADD;
5684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5685: END;
5686:
5687:

Line 5726: FND_MSG_PUB.ADD;

5722: WHEN OTHERS THEN
5723: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5724: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5726: FND_MSG_PUB.ADD;
5727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5728: END;
5729:
5730:

Line 5761: FND_MSG_PUB.ADD;

5757: WHEN OTHERS THEN
5758: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5759: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5760: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5761: FND_MSG_PUB.ADD;
5762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5763: END check_prim_cond;
5764:
5765: /************************************************

Line 5805: FND_MSG_PUB.ADD;

5801: WHEN OTHERS THEN
5802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5803: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5805: FND_MSG_PUB.ADD;
5806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5807: END check_party_site_cond;
5808:
5809: /************************************************

Line 5843: FND_MSG_PUB.ADD;

5839: WHEN OTHERS THEN
5840: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5841: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5842: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5843: FND_MSG_PUB.ADD;
5844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5845: END check_contact_cond;
5846:
5847: /************************************************

Line 5864: FND_MSG_PUB.ADD;

5860:
5861: FOR I IN 1..p_contact_point_list.COUNT LOOP
5862: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5863: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5864: FND_MSG_PUB.ADD;
5865: RAISE FND_API.G_EXC_ERROR;
5866: END IF;
5867: END LOOP;
5868:

Line 5880: FND_MSG_PUB.ADD;

5876: WHEN OTHERS THEN
5877: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5878: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5879: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5880: FND_MSG_PUB.ADD;
5881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5882: END check_contact_point_cond;
5883:
5884: FUNCTION check_staged RETURN BOOLEAN IS