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

492: WHEN OTHERS THEN
493: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
494: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
495: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
496: FND_MSG_PUB.ADD;
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END;
499:
500:

Line 516: FND_MSG_PUB.ADD;

512: WHEN OTHERS THEN
513: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
514: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
516: FND_MSG_PUB.ADD;
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END;
519:
520:

Line 536: FND_MSG_PUB.ADD;

532: WHEN OTHERS THEN
533: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
534: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
535: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
536: FND_MSG_PUB.ADD;
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
538: END;
539:
540:

Line 556: FND_MSG_PUB.ADD;

552: WHEN OTHERS THEN
553: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
554: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
555: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
556: FND_MSG_PUB.ADD;
557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
558: END;
559:
560: PROCEDURE init_score_context (

Line 623: FND_MSG_PUB.ADD;

619: p_party_site_list,
620: p_contact_list,
621: p_contact_point_list) THEN
622: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
623: FND_MSG_PUB.ADD;
624: RAISE FND_API.G_EXC_ERROR;
625: END IF;
626: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
627: 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 841: FND_MSG_PUB.ADD;

837: END IF;
838: IF lengthb(l_party_contains_str) > 4000 THEN
839: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
840: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
841: FND_MSG_PUB.ADD;
842: RAISE FND_API.G_EXC_ERROR;
843: END IF;
844: IF (p_match_str = ' AND ' OR p_party_max_score 845: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 940: FND_MSG_PUB.ADD;

936: -- Add the search criteria to query string
937: IF lengthb(l_contains_str) > 4000 THEN
938: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
939: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
940: FND_MSG_PUB.ADD;
941: RAISE FND_API.G_EXC_ERROR;
942: END IF;
943: x_denorm_str := l_den_contains_str;
944: RETURN l_contains_str;

Line 1159: FND_MSG_PUB.ADD;

1155: exception
1156: when others then
1157: if (instrb(SQLERRM,'DRG-51030')>0) then
1158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1159: FND_MSG_PUB.ADD;
1160: RAISE FND_API.G_EXC_ERROR;
1161: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1163: FND_MSG_PUB.ADD;

Line 1163: FND_MSG_PUB.ADD;

1159: FND_MSG_PUB.ADD;
1160: RAISE FND_API.G_EXC_ERROR;
1161: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1163: FND_MSG_PUB.ADD;
1164: RAISE FND_API.G_EXC_ERROR;
1165: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1166: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1167: FND_MSG_PUB.ADD;

Line 1167: FND_MSG_PUB.ADD;

1163: FND_MSG_PUB.ADD;
1164: RAISE FND_API.G_EXC_ERROR;
1165: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1166: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1167: FND_MSG_PUB.ADD;
1168: RAISE FND_API.G_EXC_ERROR;
1169: else
1170: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1171: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1172: FND_MSG_PUB.ADD;

1168: RAISE FND_API.G_EXC_ERROR;
1169: else
1170: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1171: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1172: FND_MSG_PUB.ADD;
1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1174: end if;
1175: END;
1176:

Line 1404: FND_MSG_PUB.ADD;

1400: exception
1401: when others then
1402: if (instrb(SQLERRM,'DRG-51030')>0) then
1403: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1404: FND_MSG_PUB.ADD;
1405: RAISE FND_API.G_EXC_ERROR;
1406: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1407: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1408: FND_MSG_PUB.ADD;

Line 1408: FND_MSG_PUB.ADD;

1404: FND_MSG_PUB.ADD;
1405: RAISE FND_API.G_EXC_ERROR;
1406: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1407: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1408: FND_MSG_PUB.ADD;
1409: RAISE FND_API.G_EXC_ERROR;
1410: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1411: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1412: FND_MSG_PUB.ADD;

Line 1412: FND_MSG_PUB.ADD;

1408: FND_MSG_PUB.ADD;
1409: RAISE FND_API.G_EXC_ERROR;
1410: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1411: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1412: FND_MSG_PUB.ADD;
1413: RAISE FND_API.G_EXC_ERROR;
1414: else
1415: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1416: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1417: FND_MSG_PUB.ADD;

1413: RAISE FND_API.G_EXC_ERROR;
1414: else
1415: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1416: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1417: FND_MSG_PUB.ADD;
1418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1419: end if;
1420: END;
1421:

Line 1551: FND_MSG_PUB.ADD;

1547: exception
1548: when others then
1549: if (instrb(SQLERRM,'DRG-51030')>0) then
1550: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1551: FND_MSG_PUB.ADD;
1552: RAISE FND_API.G_EXC_ERROR;
1553: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1554: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1555: FND_MSG_PUB.ADD;

Line 1555: FND_MSG_PUB.ADD;

1551: FND_MSG_PUB.ADD;
1552: RAISE FND_API.G_EXC_ERROR;
1553: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1554: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1555: FND_MSG_PUB.ADD;
1556: RAISE FND_API.G_EXC_ERROR;
1557: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1558: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1559: FND_MSG_PUB.ADD;

Line 1559: FND_MSG_PUB.ADD;

1555: FND_MSG_PUB.ADD;
1556: RAISE FND_API.G_EXC_ERROR;
1557: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1558: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1559: FND_MSG_PUB.ADD;
1560: RAISE FND_API.G_EXC_ERROR;
1561: else
1562: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1563: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1564: FND_MSG_PUB.ADD;

1560: RAISE FND_API.G_EXC_ERROR;
1561: else
1562: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1563: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1564: FND_MSG_PUB.ADD;
1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1566: end if;
1567: END;
1568:

Line 1824: FND_MSG_PUB.ADD;

1820: exception
1821: when others then
1822: if (instrb(SQLERRM,'DRG-51030')>0) then
1823: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1824: FND_MSG_PUB.ADD;
1825: RAISE FND_API.G_EXC_ERROR;
1826: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1827: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1828: FND_MSG_PUB.ADD;

Line 1828: FND_MSG_PUB.ADD;

1824: FND_MSG_PUB.ADD;
1825: RAISE FND_API.G_EXC_ERROR;
1826: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1827: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1828: FND_MSG_PUB.ADD;
1829: RAISE FND_API.G_EXC_ERROR;
1830: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1831: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1832: FND_MSG_PUB.ADD;

Line 1832: FND_MSG_PUB.ADD;

1828: FND_MSG_PUB.ADD;
1829: RAISE FND_API.G_EXC_ERROR;
1830: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1831: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1832: FND_MSG_PUB.ADD;
1833: RAISE FND_API.G_EXC_ERROR;
1834: else
1835: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1836: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1837: FND_MSG_PUB.ADD;

1833: RAISE FND_API.G_EXC_ERROR;
1834: else
1835: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1836: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1837: FND_MSG_PUB.ADD;
1838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1839: end if;
1840: END;
1841:

Line 2084: FND_MSG_PUB.ADD;

2080: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2081: 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);
2082: END IF;
2083: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2084: FND_MSG_PUB.ADD;
2085: RAISE FND_API.G_EXC_ERROR;
2086: ELSE
2087: push_eval;
2088: RETURN;

Line 2132: FND_MSG_PUB.ADD;

2128: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2129: 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);
2130: END IF;
2131: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2132: FND_MSG_PUB.ADD;
2133: RAISE FND_API.G_EXC_ERROR;
2134: ELSE
2135: push_eval;
2136: RETURN;

Line 2205: FND_MSG_PUB.ADD;

2201: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2202: 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);
2203: END IF;
2204: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2205: FND_MSG_PUB.ADD;
2206: RAISE FND_API.G_EXC_ERROR;
2207: ELSE
2208: push_eval;
2209: RETURN;

Line 2317: FND_MSG_PUB.ADD;

2313: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2314: 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);
2315: END IF;
2316: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2317: FND_MSG_PUB.ADD;
2318: RAISE FND_API.G_EXC_ERROR;
2319: ELSE
2320: push_eval;
2321: RETURN;

Line 2428: FND_MSG_PUB.ADD;

2424: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2425: 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);
2426: END IF;
2427: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2428: FND_MSG_PUB.ADD;
2429: RAISE FND_API.G_EXC_ERROR;
2430: ELSE
2431: push_eval;
2432: RETURN;

Line 2572: FND_MSG_PUB.ADD;

2568: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2569: 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);
2570: END IF;
2571: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2572: FND_MSG_PUB.ADD;
2573: RAISE FND_API.G_EXC_ERROR;
2574: END IF;
2575: ELSE
2576: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2580: FND_MSG_PUB.ADD;

2576: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2577: 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);
2578: END IF;
2579: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2580: FND_MSG_PUB.ADD;
2581: RAISE FND_API.G_EXC_ERROR;
2582: END IF;
2583: END IF;
2584: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 2831: FND_MSG_PUB.ADD;

2827: WHEN OTHERS THEN
2828: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2829: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_parties');
2830: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2831: FND_MSG_PUB.ADD;
2832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2833: END find_parties;
2834:
2835: PROCEDURE find_persons (

Line 3018: FND_MSG_PUB.ADD;

3014: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3015: 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);
3016: END IF;
3017: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3018: FND_MSG_PUB.ADD;
3019: RAISE FND_API.G_EXC_ERROR;
3020: ELSE
3021: push_eval;
3022: RETURN;

Line 3066: FND_MSG_PUB.ADD;

3062: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3063: 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);
3064: END IF;
3065: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3066: FND_MSG_PUB.ADD;
3067: RAISE FND_API.G_EXC_ERROR;
3068: ELSE
3069: push_eval;
3070: RETURN;

Line 3102: FND_MSG_PUB.ADD;

3098: exception
3099: when others then
3100: if (instrb(SQLERRM,'DRG-51030')>0) then
3101: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3102: FND_MSG_PUB.ADD;
3103: RAISE FND_API.G_EXC_ERROR;
3104: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3105: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3106: FND_MSG_PUB.ADD;

Line 3106: FND_MSG_PUB.ADD;

3102: FND_MSG_PUB.ADD;
3103: RAISE FND_API.G_EXC_ERROR;
3104: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3105: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3106: FND_MSG_PUB.ADD;
3107: RAISE FND_API.G_EXC_ERROR;
3108: else
3109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3110: end if;

Line 3178: FND_MSG_PUB.ADD;

3174: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3175: 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);
3176: END IF;
3177: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3178: FND_MSG_PUB.ADD;
3179: RAISE FND_API.G_EXC_ERROR;
3180: ELSE
3181: push_eval;
3182: RETURN;

Line 3367: FND_MSG_PUB.ADD;

3363: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3364: 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);
3365: END IF;
3366: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3367: FND_MSG_PUB.ADD;
3368: RAISE FND_API.G_EXC_ERROR;
3369: ELSE
3370: push_eval;
3371: RETURN;

Line 3455: FND_MSG_PUB.ADD;

3451: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3452: 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);
3453: END IF;
3454: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3455: FND_MSG_PUB.ADD;
3456: RAISE FND_API.G_EXC_ERROR;
3457: END IF;
3458: ELSE
3459: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3463: FND_MSG_PUB.ADD;

3459: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3460: 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);
3461: END IF;
3462: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3463: FND_MSG_PUB.ADD;
3464: RAISE FND_API.G_EXC_ERROR;
3465: END IF;
3466: END IF;
3467: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3612: FND_MSG_PUB.ADD;

3608: WHEN OTHERS THEN
3609: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3610: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_persons');
3611: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3612: FND_MSG_PUB.ADD;
3613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3614: END find_persons;
3615:
3616: PROCEDURE find_persons (

Line 3680: FND_MSG_PUB.ADD;

3676: WHEN OTHERS THEN
3677: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3678: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_party_details');
3679: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3680: FND_MSG_PUB.ADD;
3681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3682: END find_party_details;
3683:
3684: PROCEDURE find_duplicate_parties (

Line 3797: FND_MSG_PUB.ADD;

3793: WHEN OTHERS THEN
3794: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3795: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_parties');
3796: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3797: FND_MSG_PUB.ADD;
3798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3799: END find_duplicate_parties;
3800:
3801: PROCEDURE find_duplicate_party_sites (

Line 3882: FND_MSG_PUB.ADD;

3878: WHEN OTHERS THEN
3879: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3880: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_party_sites');
3881: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3882: FND_MSG_PUB.ADD;
3883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3884: END find_duplicate_party_sites;
3885:
3886: PROCEDURE find_duplicate_contacts (

Line 3971: FND_MSG_PUB.ADD;

3967: WHEN OTHERS THEN
3968: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3969: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contacts');
3970: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3971: FND_MSG_PUB.ADD;
3972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3973: END find_duplicate_contacts;
3974:
3975: PROCEDURE find_duplicate_contact_points (

Line 4044: FND_MSG_PUB.ADD;

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

Line 4338: FND_MSG_PUB.ADD;

4334: WHEN OTHERS THEN
4335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.call_api_dynamic');
4337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4338: FND_MSG_PUB.ADD;
4339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4340: END call_api_dynamic;
4341:
4342:

Line 4573: FND_MSG_PUB.ADD;

4569: WHEN OTHERS THEN
4570: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4571: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_party_sites');
4572: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4573: FND_MSG_PUB.ADD;
4574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4575: END get_matching_party_sites;
4576:
4577:

Line 4801: FND_MSG_PUB.ADD;

4797: WHEN OTHERS THEN
4798: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4799: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contacts');
4800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4801: FND_MSG_PUB.ADD;
4802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4803: END get_matching_contacts;
4804:
4805:

Line 4943: FND_MSG_PUB.ADD;

4939: WHEN OTHERS THEN
4940: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4941: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contact_points');
4942: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4943: FND_MSG_PUB.ADD;
4944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4945: END get_matching_contact_points;
4946:
4947: /**********************************************************

Line 5142: FND_MSG_PUB.ADD;

5138: WHEN OTHERS THEN
5139: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5140: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_score_details');
5141: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5142: FND_MSG_PUB.ADD;
5143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5144: END get_score_details;
5145:
5146:

Line 5217: FND_MSG_PUB.ADD;

5213: WHEN OTHERS THEN
5214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5215: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5216: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5217: FND_MSG_PUB.ADD;
5218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5219: END get_party_for_search;
5220:
5221: PROCEDURE get_search_criteria (

Line 5257: FND_MSG_PUB.ADD;

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

Line 5318: FND_MSG_PUB.ADD;

5314: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5315: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5316: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5318: FND_MSG_PUB.ADD;
5319: RAISE FND_API.G_EXC_ERROR;
5320: END get_party_rec;
5321:
5322: /************************************************

Line 5370: FND_MSG_PUB.ADD;

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

Line 5426: FND_MSG_PUB.ADD;

5422: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5423: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5424: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5425: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5426: FND_MSG_PUB.ADD;
5427: RAISE FND_API.G_EXC_ERROR;
5428: END get_contact_rec;
5429:
5430: /************************************************

Line 5482: FND_MSG_PUB.ADD;

5478: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5479: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5480: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5481: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5482: FND_MSG_PUB.ADD;
5483: RAISE FND_API.G_EXC_ERROR;
5484: END get_contact_point_rec;
5485:
5486: /************************************************

Line 5559: FND_MSG_PUB.ADD;

5555: WHEN OTHERS THEN
5556: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5557: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5558: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5559: FND_MSG_PUB.ADD;
5560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5561: END;
5562:
5563:

Line 5602: FND_MSG_PUB.ADD;

5598: WHEN OTHERS THEN
5599: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5600: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5601: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5602: FND_MSG_PUB.ADD;
5603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5604: END;
5605:
5606:

Line 5644: FND_MSG_PUB.ADD;

5640: WHEN OTHERS THEN
5641: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5642: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5643: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5644: FND_MSG_PUB.ADD;
5645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5646: END;
5647:
5648:

Line 5751: FND_MSG_PUB.ADD;

5747: WHEN OTHERS THEN
5748: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5749: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5750: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5751: FND_MSG_PUB.ADD;
5752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5753: END;
5754:
5755:

Line 5776: FND_MSG_PUB.ADD;

5772: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
5773: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
5774: ) THEN
5775: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5776: FND_MSG_PUB.ADD;
5777: RAISE FND_API.G_EXC_ERROR;
5778: END IF;
5779: END LOOP;
5780:

Line 5802: FND_MSG_PUB.ADD;

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

Line 5848: FND_MSG_PUB.ADD;

5844: WHEN OTHERS THEN
5845: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5846: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5847: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5848: FND_MSG_PUB.ADD;
5849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5850: END check_party_site_cond;
5851:
5852: /************************************************

Line 5896: FND_MSG_PUB.ADD;

5892: WHEN OTHERS THEN
5893: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5894: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5895: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5896: FND_MSG_PUB.ADD;
5897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5898: END check_contact_cond;
5899:
5900: /************************************************

Line 5917: FND_MSG_PUB.ADD;

5913:
5914: FOR I IN 1..p_contact_point_list.COUNT LOOP
5915: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5916: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5917: FND_MSG_PUB.ADD;
5918: RAISE FND_API.G_EXC_ERROR;
5919: END IF;
5920: END LOOP;
5921:

Line 5943: FND_MSG_PUB.ADD;

5939: WHEN OTHERS THEN
5940: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5941: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5942: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5943: FND_MSG_PUB.ADD;
5944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5945: END check_contact_point_cond;
5946:
5947: FUNCTION check_staged RETURN BOOLEAN IS