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

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

Line 1165: FND_MSG_PUB.ADD;

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

Line 1169: FND_MSG_PUB.ADD;

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

Line 1174: FND_MSG_PUB.ADD;

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

Line 1406: FND_MSG_PUB.ADD;

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

Line 1410: FND_MSG_PUB.ADD;

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

Line 1414: FND_MSG_PUB.ADD;

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

Line 1419: FND_MSG_PUB.ADD;

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

Line 1553: FND_MSG_PUB.ADD;

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

Line 1557: FND_MSG_PUB.ADD;

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

Line 1561: FND_MSG_PUB.ADD;

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

Line 1566: FND_MSG_PUB.ADD;

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

Line 1826: FND_MSG_PUB.ADD;

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

Line 1830: FND_MSG_PUB.ADD;

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

Line 1834: FND_MSG_PUB.ADD;

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

Line 1839: FND_MSG_PUB.ADD;

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

Line 2087: FND_MSG_PUB.ADD;

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

Line 2135: FND_MSG_PUB.ADD;

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

Line 2208: FND_MSG_PUB.ADD;

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

Line 2320: FND_MSG_PUB.ADD;

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

Line 2431: FND_MSG_PUB.ADD;

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

Line 2575: FND_MSG_PUB.ADD;

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

Line 2583: FND_MSG_PUB.ADD;

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

Line 2834: FND_MSG_PUB.ADD;

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

Line 3022: FND_MSG_PUB.ADD;

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

Line 3070: FND_MSG_PUB.ADD;

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

Line 3106: FND_MSG_PUB.ADD;

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

Line 3110: FND_MSG_PUB.ADD;

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

Line 3182: FND_MSG_PUB.ADD;

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

Line 3371: FND_MSG_PUB.ADD;

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

Line 3459: FND_MSG_PUB.ADD;

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

Line 3467: FND_MSG_PUB.ADD;

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

Line 3616: FND_MSG_PUB.ADD;

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

Line 3684: FND_MSG_PUB.ADD;

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

Line 3801: FND_MSG_PUB.ADD;

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

Line 3886: FND_MSG_PUB.ADD;

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

Line 3975: FND_MSG_PUB.ADD;

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

Line 4048: FND_MSG_PUB.ADD;

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

Line 4342: FND_MSG_PUB.ADD;

4338: WHEN OTHERS THEN
4339: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4340: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.call_api_dynamic');
4341: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4342: FND_MSG_PUB.ADD;
4343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4344: END call_api_dynamic;
4345:
4346:

Line 4577: FND_MSG_PUB.ADD;

4573: WHEN OTHERS THEN
4574: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4575: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_party_sites');
4576: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4577: FND_MSG_PUB.ADD;
4578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4579: END get_matching_party_sites;
4580:
4581:

Line 4805: FND_MSG_PUB.ADD;

4801: WHEN OTHERS THEN
4802: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4803: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contacts');
4804: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4805: FND_MSG_PUB.ADD;
4806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4807: END get_matching_contacts;
4808:
4809:

Line 4947: FND_MSG_PUB.ADD;

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

Line 5147: FND_MSG_PUB.ADD;

5143: WHEN OTHERS THEN
5144: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5145: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_score_details');
5146: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5147: FND_MSG_PUB.ADD;
5148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5149: END get_score_details;
5150:
5151:

Line 5222: FND_MSG_PUB.ADD;

5218: WHEN OTHERS THEN
5219: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5220: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5221: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5222: FND_MSG_PUB.ADD;
5223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5224: END get_party_for_search;
5225:
5226: PROCEDURE get_search_criteria (

Line 5262: FND_MSG_PUB.ADD;

5258: WHEN OTHERS THEN
5259: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5260: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5261: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5262: FND_MSG_PUB.ADD;
5263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5264: END get_search_criteria;
5265:
5266:

Line 5323: FND_MSG_PUB.ADD;

5319: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5320: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5321: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5323: FND_MSG_PUB.ADD;
5324: RAISE FND_API.G_EXC_ERROR;
5325: END get_party_rec;
5326:
5327: /************************************************

Line 5375: FND_MSG_PUB.ADD;

5371: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5372: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5373: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5374: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5375: FND_MSG_PUB.ADD;
5376: RAISE FND_API.G_EXC_ERROR;
5377: END get_party_site_rec;
5378:
5379: /************************************************

Line 5431: FND_MSG_PUB.ADD;

5427: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5428: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5429: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5430: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5431: FND_MSG_PUB.ADD;
5432: RAISE FND_API.G_EXC_ERROR;
5433: END get_contact_rec;
5434:
5435: /************************************************

Line 5487: FND_MSG_PUB.ADD;

5483: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5484: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5485: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5486: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5487: FND_MSG_PUB.ADD;
5488: RAISE FND_API.G_EXC_ERROR;
5489: END get_contact_point_rec;
5490:
5491: /************************************************

Line 5564: FND_MSG_PUB.ADD;

5560: WHEN OTHERS THEN
5561: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5562: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5563: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5564: FND_MSG_PUB.ADD;
5565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5566: END;
5567:
5568:

Line 5607: FND_MSG_PUB.ADD;

5603: WHEN OTHERS THEN
5604: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5605: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5606: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5607: FND_MSG_PUB.ADD;
5608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5609: END;
5610:
5611:

Line 5649: FND_MSG_PUB.ADD;

5645: WHEN OTHERS THEN
5646: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5647: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5648: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5649: FND_MSG_PUB.ADD;
5650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5651: END;
5652:
5653:

Line 5756: FND_MSG_PUB.ADD;

5752: WHEN OTHERS THEN
5753: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5754: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5755: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5756: FND_MSG_PUB.ADD;
5757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5758: END;
5759:
5760:

Line 5781: FND_MSG_PUB.ADD;

5777: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
5778: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
5779: ) THEN
5780: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5781: FND_MSG_PUB.ADD;
5782: RAISE FND_API.G_EXC_ERROR;
5783: END IF;
5784: END LOOP;
5785:

Line 5807: FND_MSG_PUB.ADD;

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

Line 5853: FND_MSG_PUB.ADD;

5849: WHEN OTHERS THEN
5850: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5851: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5852: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5853: FND_MSG_PUB.ADD;
5854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5855: END check_party_site_cond;
5856:
5857: /************************************************

Line 5901: FND_MSG_PUB.ADD;

5897: WHEN OTHERS THEN
5898: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5899: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5900: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5901: FND_MSG_PUB.ADD;
5902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5903: END check_contact_cond;
5904:
5905: /************************************************

Line 5922: FND_MSG_PUB.ADD;

5918:
5919: FOR I IN 1..p_contact_point_list.COUNT LOOP
5920: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5921: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5922: FND_MSG_PUB.ADD;
5923: RAISE FND_API.G_EXC_ERROR;
5924: END IF;
5925: END LOOP;
5926:

Line 5948: FND_MSG_PUB.ADD;

5944: WHEN OTHERS THEN
5945: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5946: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5948: FND_MSG_PUB.ADD;
5949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5950: END check_contact_point_cond;
5951:
5952: FUNCTION check_staged RETURN BOOLEAN IS