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

528: WHEN OTHERS THEN
529: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
530: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
531: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
532: FND_MSG_PUB.ADD;
533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
534: END;
535:
536:

Line 552: FND_MSG_PUB.ADD;

548: WHEN OTHERS THEN
549: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
550: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
552: FND_MSG_PUB.ADD;
553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
554: END;
555:
556:

Line 572: FND_MSG_PUB.ADD;

568: WHEN OTHERS THEN
569: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
570: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
571: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
572: FND_MSG_PUB.ADD;
573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
574: END;
575:
576:

Line 592: FND_MSG_PUB.ADD;

588: WHEN OTHERS THEN
589: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
590: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
591: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
592: FND_MSG_PUB.ADD;
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END;
595:
596: PROCEDURE init_score_context (

Line 659: FND_MSG_PUB.ADD;

655: p_party_site_list,
656: p_contact_list,
657: p_contact_point_list) THEN
658: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
659: FND_MSG_PUB.ADD;
660: RAISE FND_API.G_EXC_ERROR;
661: END IF;
662: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
663: 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 917: FND_MSG_PUB.ADD;

913: END IF;
914: IF lengthb(l_party_contains_str) > 4000 THEN
915: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
916: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
917: FND_MSG_PUB.ADD;
918: RAISE FND_API.G_EXC_ERROR;
919: END IF;
920: IF (p_match_str = ' AND ' OR p_party_max_score 921: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 976: FND_MSG_PUB.ADD;

972: -- Add the search criteria to query string
973: IF lengthb(l_contains_str) > 4000 THEN
974: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
975: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
976: FND_MSG_PUB.ADD;
977: RAISE FND_API.G_EXC_ERROR;
978: END IF;
979: x_denorm_str := l_den_contains_str;
980: RETURN l_contains_str;

Line 1243: FND_MSG_PUB.ADD;

1239: exception
1240: when others then
1241: if (instrb(SQLERRM,'DRG-51030')>0) then
1242: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1243: FND_MSG_PUB.ADD;
1244: RAISE FND_API.G_EXC_ERROR;
1245: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1246: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1247: FND_MSG_PUB.ADD;

Line 1247: FND_MSG_PUB.ADD;

1243: FND_MSG_PUB.ADD;
1244: RAISE FND_API.G_EXC_ERROR;
1245: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1246: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1247: FND_MSG_PUB.ADD;
1248: RAISE FND_API.G_EXC_ERROR;
1249: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1250: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1251: FND_MSG_PUB.ADD;

Line 1251: FND_MSG_PUB.ADD;

1247: FND_MSG_PUB.ADD;
1248: RAISE FND_API.G_EXC_ERROR;
1249: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1250: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1251: FND_MSG_PUB.ADD;
1252: RAISE FND_API.G_EXC_ERROR;
1253: else
1254: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1255: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1256: FND_MSG_PUB.ADD;

1252: RAISE FND_API.G_EXC_ERROR;
1253: else
1254: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1255: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1256: FND_MSG_PUB.ADD;
1257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1258: end if;
1259: END;
1260:

Line 1488: FND_MSG_PUB.ADD;

1484: exception
1485: when others then
1486: if (instrb(SQLERRM,'DRG-51030')>0) then
1487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1488: FND_MSG_PUB.ADD;
1489: RAISE FND_API.G_EXC_ERROR;
1490: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1491: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1492: FND_MSG_PUB.ADD;

Line 1492: FND_MSG_PUB.ADD;

1488: FND_MSG_PUB.ADD;
1489: RAISE FND_API.G_EXC_ERROR;
1490: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1491: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1492: FND_MSG_PUB.ADD;
1493: RAISE FND_API.G_EXC_ERROR;
1494: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1495: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1496: FND_MSG_PUB.ADD;

Line 1496: FND_MSG_PUB.ADD;

1492: FND_MSG_PUB.ADD;
1493: RAISE FND_API.G_EXC_ERROR;
1494: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1495: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1496: FND_MSG_PUB.ADD;
1497: RAISE FND_API.G_EXC_ERROR;
1498: else
1499: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1500: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1501: FND_MSG_PUB.ADD;

1497: RAISE FND_API.G_EXC_ERROR;
1498: else
1499: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1500: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1501: FND_MSG_PUB.ADD;
1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1503: end if;
1504: END;
1505:

Line 1635: FND_MSG_PUB.ADD;

1631: exception
1632: when others then
1633: if (instrb(SQLERRM,'DRG-51030')>0) then
1634: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1635: FND_MSG_PUB.ADD;
1636: RAISE FND_API.G_EXC_ERROR;
1637: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1638: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1639: FND_MSG_PUB.ADD;

Line 1639: FND_MSG_PUB.ADD;

1635: FND_MSG_PUB.ADD;
1636: RAISE FND_API.G_EXC_ERROR;
1637: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1638: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1639: FND_MSG_PUB.ADD;
1640: RAISE FND_API.G_EXC_ERROR;
1641: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1643: FND_MSG_PUB.ADD;

Line 1643: FND_MSG_PUB.ADD;

1639: FND_MSG_PUB.ADD;
1640: RAISE FND_API.G_EXC_ERROR;
1641: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1643: FND_MSG_PUB.ADD;
1644: RAISE FND_API.G_EXC_ERROR;
1645: else
1646: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1648: FND_MSG_PUB.ADD;

1644: RAISE FND_API.G_EXC_ERROR;
1645: else
1646: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1648: FND_MSG_PUB.ADD;
1649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1650: end if;
1651: END;
1652:

Line 1908: FND_MSG_PUB.ADD;

1904: exception
1905: when others then
1906: if (instrb(SQLERRM,'DRG-51030')>0) then
1907: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1908: FND_MSG_PUB.ADD;
1909: RAISE FND_API.G_EXC_ERROR;
1910: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1911: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1912: FND_MSG_PUB.ADD;

Line 1912: FND_MSG_PUB.ADD;

1908: FND_MSG_PUB.ADD;
1909: RAISE FND_API.G_EXC_ERROR;
1910: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1911: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1912: FND_MSG_PUB.ADD;
1913: RAISE FND_API.G_EXC_ERROR;
1914: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1915: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1916: FND_MSG_PUB.ADD;

Line 1916: FND_MSG_PUB.ADD;

1912: FND_MSG_PUB.ADD;
1913: RAISE FND_API.G_EXC_ERROR;
1914: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1915: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1916: FND_MSG_PUB.ADD;
1917: RAISE FND_API.G_EXC_ERROR;
1918: else
1919: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1920: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1921: FND_MSG_PUB.ADD;

1917: RAISE FND_API.G_EXC_ERROR;
1918: else
1919: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1920: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1921: FND_MSG_PUB.ADD;
1922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1923: end if;
1924: END;
1925:

Line 2169: FND_MSG_PUB.ADD;

2165: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2166: 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);
2167: END IF;
2168: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2169: FND_MSG_PUB.ADD;
2170: RAISE FND_API.G_EXC_ERROR;
2171: ELSE
2172: push_eval;
2173: RETURN;

Line 2217: FND_MSG_PUB.ADD;

2213: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2214: 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);
2215: END IF;
2216: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2217: FND_MSG_PUB.ADD;
2218: RAISE FND_API.G_EXC_ERROR;
2219: ELSE
2220: push_eval;
2221: RETURN;

Line 2290: FND_MSG_PUB.ADD;

2286: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2287: 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);
2288: END IF;
2289: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2290: FND_MSG_PUB.ADD;
2291: RAISE FND_API.G_EXC_ERROR;
2292: ELSE
2293: push_eval;
2294: RETURN;

Line 2402: FND_MSG_PUB.ADD;

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

Line 2513: FND_MSG_PUB.ADD;

2509: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2510: 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);
2511: END IF;
2512: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2513: FND_MSG_PUB.ADD;
2514: RAISE FND_API.G_EXC_ERROR;
2515: ELSE
2516: push_eval;
2517: RETURN;

Line 2657: FND_MSG_PUB.ADD;

2653: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2654: 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);
2655: END IF;
2656: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2657: FND_MSG_PUB.ADD;
2658: RAISE FND_API.G_EXC_ERROR;
2659: END IF;
2660: ELSE
2661: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2665: FND_MSG_PUB.ADD;

2661: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2662: 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);
2663: END IF;
2664: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2665: FND_MSG_PUB.ADD;
2666: RAISE FND_API.G_EXC_ERROR;
2667: END IF;
2668: END IF;
2669: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 2916: FND_MSG_PUB.ADD;

2912: WHEN OTHERS THEN
2913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2914: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_parties');
2915: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2916: FND_MSG_PUB.ADD;
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: END find_parties;
2919:
2920: PROCEDURE find_persons (

Line 3104: FND_MSG_PUB.ADD;

3100: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3101: 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);
3102: END IF;
3103: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3104: FND_MSG_PUB.ADD;
3105: RAISE FND_API.G_EXC_ERROR;
3106: ELSE
3107: push_eval;
3108: RETURN;

Line 3152: FND_MSG_PUB.ADD;

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

Line 3188: FND_MSG_PUB.ADD;

3184: exception
3185: when others then
3186: if (instrb(SQLERRM,'DRG-51030')>0) then
3187: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3188: FND_MSG_PUB.ADD;
3189: RAISE FND_API.G_EXC_ERROR;
3190: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3191: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3192: FND_MSG_PUB.ADD;

Line 3192: FND_MSG_PUB.ADD;

3188: FND_MSG_PUB.ADD;
3189: RAISE FND_API.G_EXC_ERROR;
3190: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3191: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3192: FND_MSG_PUB.ADD;
3193: RAISE FND_API.G_EXC_ERROR;
3194: else
3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3196: end if;

Line 3264: FND_MSG_PUB.ADD;

3260: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3261: 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);
3262: END IF;
3263: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3264: FND_MSG_PUB.ADD;
3265: RAISE FND_API.G_EXC_ERROR;
3266: ELSE
3267: push_eval;
3268: RETURN;

Line 3453: FND_MSG_PUB.ADD;

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

Line 3541: FND_MSG_PUB.ADD;

3537: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3538: 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);
3539: END IF;
3540: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3541: FND_MSG_PUB.ADD;
3542: RAISE FND_API.G_EXC_ERROR;
3543: END IF;
3544: ELSE
3545: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3549: FND_MSG_PUB.ADD;

3545: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3546: 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);
3547: END IF;
3548: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3549: FND_MSG_PUB.ADD;
3550: RAISE FND_API.G_EXC_ERROR;
3551: END IF;
3552: END IF;
3553: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3698: FND_MSG_PUB.ADD;

3694: WHEN OTHERS THEN
3695: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3696: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_persons');
3697: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3698: FND_MSG_PUB.ADD;
3699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3700: END find_persons;
3701:
3702: PROCEDURE find_persons (

Line 3766: FND_MSG_PUB.ADD;

3762: WHEN OTHERS THEN
3763: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3764: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_party_details');
3765: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3766: FND_MSG_PUB.ADD;
3767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3768: END find_party_details;
3769:
3770: PROCEDURE find_duplicate_parties (

Line 3883: FND_MSG_PUB.ADD;

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

Line 3968: FND_MSG_PUB.ADD;

3964: WHEN OTHERS THEN
3965: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3966: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_party_sites');
3967: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3968: FND_MSG_PUB.ADD;
3969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3970: END find_duplicate_party_sites;
3971:
3972: PROCEDURE find_duplicate_contacts (

Line 4057: FND_MSG_PUB.ADD;

4053: WHEN OTHERS THEN
4054: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4055: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contacts');
4056: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4057: FND_MSG_PUB.ADD;
4058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4059: END find_duplicate_contacts;
4060:
4061: PROCEDURE find_duplicate_contact_points (

Line 4130: FND_MSG_PUB.ADD;

4126: WHEN OTHERS THEN
4127: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4128: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.find_duplicate_contact_points');
4129: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4130: FND_MSG_PUB.ADD;
4131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4132: END find_duplicate_contact_points;
4133:
4134: PROCEDURE find_parties_dynamic (

Line 4397: FND_MSG_PUB.ADD;

4393: WHEN OTHERS THEN
4394: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4395: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.call_api_dynamic');
4396: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4397: FND_MSG_PUB.ADD;
4398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4399: END call_api_dynamic;
4400:
4401:

Line 4630: FND_MSG_PUB.ADD;

4626: WHEN OTHERS THEN
4627: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4628: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_party_sites');
4629: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4630: FND_MSG_PUB.ADD;
4631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4632: END get_matching_party_sites;
4633:
4634:

Line 4855: FND_MSG_PUB.ADD;

4851: WHEN OTHERS THEN
4852: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4853: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contacts');
4854: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4855: FND_MSG_PUB.ADD;
4856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4857: END get_matching_contacts;
4858:
4859:

Line 4994: FND_MSG_PUB.ADD;

4990: WHEN OTHERS THEN
4991: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4992: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_matching_contact_points');
4993: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4994: FND_MSG_PUB.ADD;
4995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4996: END get_matching_contact_points;
4997:
4998: /**********************************************************

Line 5192: FND_MSG_PUB.ADD;

5188: WHEN OTHERS THEN
5189: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5190: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_2.get_score_details');
5191: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5192: FND_MSG_PUB.ADD;
5193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5194: END get_score_details;
5195:
5196:

Line 5270: FND_MSG_PUB.ADD;

5266: WHEN OTHERS THEN
5267: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5268: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5269: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5270: FND_MSG_PUB.ADD;
5271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5272: END get_party_for_search;
5273:
5274: PROCEDURE get_search_criteria (

Line 5310: FND_MSG_PUB.ADD;

5306: WHEN OTHERS THEN
5307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5308: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5310: FND_MSG_PUB.ADD;
5311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5312: END get_search_criteria;
5313:
5314:

Line 5375: FND_MSG_PUB.ADD;

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

Line 5429: FND_MSG_PUB.ADD;

5425: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5426: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5427: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5428: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5429: FND_MSG_PUB.ADD;
5430: RAISE FND_API.G_EXC_ERROR;
5431: END get_party_site_rec;
5432:
5433: /************************************************

Line 5485: FND_MSG_PUB.ADD;

5481: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5482: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5483: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5484: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5485: FND_MSG_PUB.ADD;
5486: RAISE FND_API.G_EXC_ERROR;
5487: END get_contact_rec;
5488:
5489: /************************************************

Line 5537: FND_MSG_PUB.ADD;

5533: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5534: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5535: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5536: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5537: FND_MSG_PUB.ADD;
5538: RAISE FND_API.G_EXC_ERROR;
5539: END get_contact_point_rec;
5540:
5541: /************************************************

Line 5657: FND_MSG_PUB.ADD;

5653: WHEN OTHERS THEN
5654: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5655: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5656: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5657: FND_MSG_PUB.ADD;
5658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5659: END;
5660:
5661:

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

5764: WHEN OTHERS THEN
5765: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5766: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5767: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5768: FND_MSG_PUB.ADD;
5769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5770: END;
5771:
5772:

Line 5811: FND_MSG_PUB.ADD;

5807: WHEN OTHERS THEN
5808: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5809: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5810: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5811: FND_MSG_PUB.ADD;
5812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5813: END;
5814:
5815:

Line 5852: FND_MSG_PUB.ADD;

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

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_party_site_cond');
5895: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5896: FND_MSG_PUB.ADD;
5897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5898: END check_party_site_cond;
5899:
5900: /************************************************

Line 5934: FND_MSG_PUB.ADD;

5930: WHEN OTHERS THEN
5931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5932: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5934: FND_MSG_PUB.ADD;
5935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5936: END check_contact_cond;
5937:
5938: /************************************************

Line 5955: FND_MSG_PUB.ADD;

5951:
5952: FOR I IN 1..p_contact_point_list.COUNT LOOP
5953: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5954: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5955: FND_MSG_PUB.ADD;
5956: RAISE FND_API.G_EXC_ERROR;
5957: END IF;
5958: END LOOP;
5959:

Line 5971: FND_MSG_PUB.ADD;

5967: WHEN OTHERS THEN
5968: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5969: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5970: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5971: FND_MSG_PUB.ADD;
5972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5973: END check_contact_point_cond;
5974:
5975: FUNCTION check_staged RETURN BOOLEAN IS