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_4 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 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_PARTY_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:

Line 612: FND_MSG_PUB.ADD;

608: WHEN OTHERS THEN
609: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
610: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
611: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
612: FND_MSG_PUB.ADD;
613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
614: END;
615:
616:

Line 632: FND_MSG_PUB.ADD;

628: WHEN OTHERS THEN
629: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
630: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
631: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
632: FND_MSG_PUB.ADD;
633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
634: END;
635:
636:

Line 652: FND_MSG_PUB.ADD;

648: WHEN OTHERS THEN
649: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
650: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
651: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
652: FND_MSG_PUB.ADD;
653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
654: END;
655:
656: PROCEDURE init_score_context (

Line 719: FND_MSG_PUB.ADD;

715: p_party_site_list,
716: p_contact_list,
717: p_contact_point_list) THEN
718: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
719: FND_MSG_PUB.ADD;
720: RAISE FND_API.G_EXC_ERROR;
721: END IF;
722: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
723: 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 937: FND_MSG_PUB.ADD;

933: END IF;
934: IF lengthb(l_party_contains_str) > 4000 THEN
935: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
936: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
937: FND_MSG_PUB.ADD;
938: RAISE FND_API.G_EXC_ERROR;
939: END IF;
940: IF (p_match_str = ' AND ' OR p_party_max_score 941: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 999: FND_MSG_PUB.ADD;

995: -- Add the search criteria to query string
996: IF lengthb(l_contains_str) > 4000 THEN
997: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
998: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
999: FND_MSG_PUB.ADD;
1000: RAISE FND_API.G_EXC_ERROR;
1001: END IF;
1002: x_denorm_str := l_den_contains_str;
1003: RETURN l_contains_str;

Line 1250: FND_MSG_PUB.ADD;

1246: exception
1247: when others then
1248: if (instrb(SQLERRM,'DRG-51030')>0) then
1249: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1250: FND_MSG_PUB.ADD;
1251: RAISE FND_API.G_EXC_ERROR;
1252: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1253: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1254: FND_MSG_PUB.ADD;

Line 1254: FND_MSG_PUB.ADD;

1250: FND_MSG_PUB.ADD;
1251: RAISE FND_API.G_EXC_ERROR;
1252: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1253: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1254: FND_MSG_PUB.ADD;
1255: RAISE FND_API.G_EXC_ERROR;
1256: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1258: FND_MSG_PUB.ADD;

Line 1258: FND_MSG_PUB.ADD;

1254: FND_MSG_PUB.ADD;
1255: RAISE FND_API.G_EXC_ERROR;
1256: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1257: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1258: FND_MSG_PUB.ADD;
1259: RAISE FND_API.G_EXC_ERROR;
1260: else
1261: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1262: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1263: FND_MSG_PUB.ADD;

1259: RAISE FND_API.G_EXC_ERROR;
1260: else
1261: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1262: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1263: FND_MSG_PUB.ADD;
1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1265: end if;
1266: END;
1267:

Line 1495: FND_MSG_PUB.ADD;

1491: exception
1492: when others then
1493: if (instrb(SQLERRM,'DRG-51030')>0) then
1494: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1495: FND_MSG_PUB.ADD;
1496: RAISE FND_API.G_EXC_ERROR;
1497: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1498: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1499: FND_MSG_PUB.ADD;

Line 1499: FND_MSG_PUB.ADD;

1495: FND_MSG_PUB.ADD;
1496: RAISE FND_API.G_EXC_ERROR;
1497: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1498: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1499: FND_MSG_PUB.ADD;
1500: RAISE FND_API.G_EXC_ERROR;
1501: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1502: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1503: FND_MSG_PUB.ADD;

Line 1503: FND_MSG_PUB.ADD;

1499: FND_MSG_PUB.ADD;
1500: RAISE FND_API.G_EXC_ERROR;
1501: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1502: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1503: FND_MSG_PUB.ADD;
1504: RAISE FND_API.G_EXC_ERROR;
1505: else
1506: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1507: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1508: FND_MSG_PUB.ADD;

1504: RAISE FND_API.G_EXC_ERROR;
1505: else
1506: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1507: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1508: FND_MSG_PUB.ADD;
1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1510: end if;
1511: END;
1512:

Line 1642: FND_MSG_PUB.ADD;

1638: exception
1639: when others then
1640: if (instrb(SQLERRM,'DRG-51030')>0) then
1641: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1642: FND_MSG_PUB.ADD;
1643: RAISE FND_API.G_EXC_ERROR;
1644: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1646: FND_MSG_PUB.ADD;

Line 1646: FND_MSG_PUB.ADD;

1642: FND_MSG_PUB.ADD;
1643: RAISE FND_API.G_EXC_ERROR;
1644: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1646: FND_MSG_PUB.ADD;
1647: RAISE FND_API.G_EXC_ERROR;
1648: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1649: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1650: FND_MSG_PUB.ADD;

Line 1650: FND_MSG_PUB.ADD;

1646: FND_MSG_PUB.ADD;
1647: RAISE FND_API.G_EXC_ERROR;
1648: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1649: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1650: FND_MSG_PUB.ADD;
1651: RAISE FND_API.G_EXC_ERROR;
1652: else
1653: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1654: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1655: FND_MSG_PUB.ADD;

1651: RAISE FND_API.G_EXC_ERROR;
1652: else
1653: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1654: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1655: FND_MSG_PUB.ADD;
1656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1657: end if;
1658: END;
1659:

Line 1915: FND_MSG_PUB.ADD;

1911: exception
1912: when others then
1913: if (instrb(SQLERRM,'DRG-51030')>0) then
1914: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1915: FND_MSG_PUB.ADD;
1916: RAISE FND_API.G_EXC_ERROR;
1917: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1918: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1919: FND_MSG_PUB.ADD;

Line 1919: FND_MSG_PUB.ADD;

1915: FND_MSG_PUB.ADD;
1916: RAISE FND_API.G_EXC_ERROR;
1917: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1918: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1919: FND_MSG_PUB.ADD;
1920: RAISE FND_API.G_EXC_ERROR;
1921: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1923: FND_MSG_PUB.ADD;

Line 1923: FND_MSG_PUB.ADD;

1919: FND_MSG_PUB.ADD;
1920: RAISE FND_API.G_EXC_ERROR;
1921: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1923: FND_MSG_PUB.ADD;
1924: RAISE FND_API.G_EXC_ERROR;
1925: else
1926: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1927: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1928: FND_MSG_PUB.ADD;

1924: RAISE FND_API.G_EXC_ERROR;
1925: else
1926: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1927: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1928: FND_MSG_PUB.ADD;
1929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1930: end if;
1931: END;
1932:

Line 2178: FND_MSG_PUB.ADD;

2174: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2175: 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);
2176: END IF;
2177: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2178: FND_MSG_PUB.ADD;
2179: RAISE FND_API.G_EXC_ERROR;
2180: ELSE
2181: push_eval;
2182: RETURN;

Line 2226: FND_MSG_PUB.ADD;

2222: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2223: 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);
2224: END IF;
2225: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2226: FND_MSG_PUB.ADD;
2227: RAISE FND_API.G_EXC_ERROR;
2228: ELSE
2229: push_eval;
2230: RETURN;

Line 2299: FND_MSG_PUB.ADD;

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

Line 2411: FND_MSG_PUB.ADD;

2407: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2408: 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);
2409: END IF;
2410: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2411: FND_MSG_PUB.ADD;
2412: RAISE FND_API.G_EXC_ERROR;
2413: ELSE
2414: push_eval;
2415: RETURN;

Line 2522: FND_MSG_PUB.ADD;

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

Line 2666: FND_MSG_PUB.ADD;

2662: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2663: 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);
2664: END IF;
2665: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2666: FND_MSG_PUB.ADD;
2667: RAISE FND_API.G_EXC_ERROR;
2668: END IF;
2669: ELSE
2670: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2674: FND_MSG_PUB.ADD;

2670: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2671: 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);
2672: END IF;
2673: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2674: FND_MSG_PUB.ADD;
2675: RAISE FND_API.G_EXC_ERROR;
2676: END IF;
2677: END IF;
2678: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 2925: FND_MSG_PUB.ADD;

2921: WHEN OTHERS THEN
2922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2923: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_parties');
2924: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2925: FND_MSG_PUB.ADD;
2926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2927: END find_parties;
2928:
2929: PROCEDURE find_persons (

Line 3115: FND_MSG_PUB.ADD;

3111: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3112: 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);
3113: END IF;
3114: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3115: FND_MSG_PUB.ADD;
3116: RAISE FND_API.G_EXC_ERROR;
3117: ELSE
3118: push_eval;
3119: RETURN;

Line 3163: FND_MSG_PUB.ADD;

3159: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3160: 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);
3161: END IF;
3162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3163: FND_MSG_PUB.ADD;
3164: RAISE FND_API.G_EXC_ERROR;
3165: ELSE
3166: push_eval;
3167: RETURN;

Line 3199: FND_MSG_PUB.ADD;

3195: exception
3196: when others then
3197: if (instrb(SQLERRM,'DRG-51030')>0) then
3198: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3199: FND_MSG_PUB.ADD;
3200: RAISE FND_API.G_EXC_ERROR;
3201: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3202: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3203: FND_MSG_PUB.ADD;

Line 3203: FND_MSG_PUB.ADD;

3199: FND_MSG_PUB.ADD;
3200: RAISE FND_API.G_EXC_ERROR;
3201: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3202: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3203: FND_MSG_PUB.ADD;
3204: RAISE FND_API.G_EXC_ERROR;
3205: else
3206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3207: end if;

Line 3275: FND_MSG_PUB.ADD;

3271: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3272: 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);
3273: END IF;
3274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3275: FND_MSG_PUB.ADD;
3276: RAISE FND_API.G_EXC_ERROR;
3277: ELSE
3278: push_eval;
3279: RETURN;

Line 3464: FND_MSG_PUB.ADD;

3460: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3461: 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);
3462: END IF;
3463: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3464: FND_MSG_PUB.ADD;
3465: RAISE FND_API.G_EXC_ERROR;
3466: ELSE
3467: push_eval;
3468: RETURN;

Line 3552: FND_MSG_PUB.ADD;

3548: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3549: 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);
3550: END IF;
3551: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3552: FND_MSG_PUB.ADD;
3553: RAISE FND_API.G_EXC_ERROR;
3554: END IF;
3555: ELSE
3556: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3560: FND_MSG_PUB.ADD;

3556: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3557: 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);
3558: END IF;
3559: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3560: FND_MSG_PUB.ADD;
3561: RAISE FND_API.G_EXC_ERROR;
3562: END IF;
3563: END IF;
3564: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3709: FND_MSG_PUB.ADD;

3705: WHEN OTHERS THEN
3706: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3707: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_persons');
3708: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3709: FND_MSG_PUB.ADD;
3710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3711: END find_persons;
3712:
3713: PROCEDURE find_persons (

Line 3777: FND_MSG_PUB.ADD;

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

Line 3894: FND_MSG_PUB.ADD;

3890: WHEN OTHERS THEN
3891: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3892: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_parties');
3893: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3894: FND_MSG_PUB.ADD;
3895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3896: END find_duplicate_parties;
3897:
3898: PROCEDURE find_duplicate_party_sites (

Line 3979: FND_MSG_PUB.ADD;

3975: WHEN OTHERS THEN
3976: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3977: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_party_sites');
3978: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3979: FND_MSG_PUB.ADD;
3980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3981: END find_duplicate_party_sites;
3982:
3983: PROCEDURE find_duplicate_contacts (

Line 4068: FND_MSG_PUB.ADD;

4064: WHEN OTHERS THEN
4065: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4066: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_contacts');
4067: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4068: FND_MSG_PUB.ADD;
4069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4070: END find_duplicate_contacts;
4071:
4072: PROCEDURE find_duplicate_contact_points (

Line 4141: FND_MSG_PUB.ADD;

4137: WHEN OTHERS THEN
4138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4139: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.find_duplicate_contact_points');
4140: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4141: FND_MSG_PUB.ADD;
4142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4143: END find_duplicate_contact_points;
4144:
4145: PROCEDURE find_parties_dynamic (

Line 4415: FND_MSG_PUB.ADD;

4411: WHEN OTHERS THEN
4412: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4413: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.call_api_dynamic');
4414: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4415: FND_MSG_PUB.ADD;
4416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4417: END call_api_dynamic;
4418:
4419:

Line 4649: FND_MSG_PUB.ADD;

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

Line 4874: FND_MSG_PUB.ADD;

4870: WHEN OTHERS THEN
4871: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4872: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_contacts');
4873: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4874: FND_MSG_PUB.ADD;
4875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4876: END get_matching_contacts;
4877:
4878:

Line 5013: FND_MSG_PUB.ADD;

5009: WHEN OTHERS THEN
5010: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5011: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_contact_points');
5012: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5013: FND_MSG_PUB.ADD;
5014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5015: END get_matching_contact_points;
5016:
5017: /**********************************************************

Line 5216: FND_MSG_PUB.ADD;

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

Line 5294: FND_MSG_PUB.ADD;

5290: WHEN OTHERS THEN
5291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5292: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5294: FND_MSG_PUB.ADD;
5295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5296: END get_party_for_search;
5297:
5298: PROCEDURE get_search_criteria (

Line 5334: FND_MSG_PUB.ADD;

5330: WHEN OTHERS THEN
5331: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5332: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5333: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5334: FND_MSG_PUB.ADD;
5335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5336: END get_search_criteria;
5337:
5338:

Line 5401: FND_MSG_PUB.ADD;

5397: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5398: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5399: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5400: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5401: FND_MSG_PUB.ADD;
5402: RAISE FND_API.G_EXC_ERROR;
5403: END get_party_rec;
5404:
5405: /************************************************

Line 5457: FND_MSG_PUB.ADD;

5453: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5454: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5455: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5456: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5457: FND_MSG_PUB.ADD;
5458: RAISE FND_API.G_EXC_ERROR;
5459: END get_party_site_rec;
5460:
5461: /************************************************

Line 5513: FND_MSG_PUB.ADD;

5509: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5510: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5511: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5512: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5513: FND_MSG_PUB.ADD;
5514: RAISE FND_API.G_EXC_ERROR;
5515: END get_contact_rec;
5516:
5517: /************************************************

Line 5565: FND_MSG_PUB.ADD;

5561: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5562: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5563: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5564: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5565: FND_MSG_PUB.ADD;
5566: RAISE FND_API.G_EXC_ERROR;
5567: END get_contact_point_rec;
5568:
5569: /************************************************

Line 5712: FND_MSG_PUB.ADD;

5708: WHEN OTHERS THEN
5709: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5710: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5711: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5712: FND_MSG_PUB.ADD;
5713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5714: END;
5715:
5716:

Line 5827: FND_MSG_PUB.ADD;

5823: WHEN OTHERS THEN
5824: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5825: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5826: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5827: FND_MSG_PUB.ADD;
5828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5829: END;
5830:
5831:

Line 5869: FND_MSG_PUB.ADD;

5865: WHEN OTHERS THEN
5866: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5867: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5869: FND_MSG_PUB.ADD;
5870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5871: END;
5872:
5873:

Line 5912: FND_MSG_PUB.ADD;

5908: WHEN OTHERS THEN
5909: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5910: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5911: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5912: FND_MSG_PUB.ADD;
5913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5914: END;
5915:
5916:

Line 5947: FND_MSG_PUB.ADD;

5943: WHEN OTHERS THEN
5944: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5945: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5946: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5947: FND_MSG_PUB.ADD;
5948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5949: END check_prim_cond;
5950:
5951: /************************************************

Line 5991: FND_MSG_PUB.ADD;

5987: WHEN OTHERS THEN
5988: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5989: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5990: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5991: FND_MSG_PUB.ADD;
5992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5993: END check_party_site_cond;
5994:
5995: /************************************************

Line 6029: FND_MSG_PUB.ADD;

6025: WHEN OTHERS THEN
6026: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6027: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6028: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6029: FND_MSG_PUB.ADD;
6030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6031: END check_contact_cond;
6032:
6033: /************************************************

Line 6050: FND_MSG_PUB.ADD;

6046:
6047: FOR I IN 1..p_contact_point_list.COUNT LOOP
6048: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6049: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6050: FND_MSG_PUB.ADD;
6051: RAISE FND_API.G_EXC_ERROR;
6052: END IF;
6053: END LOOP;
6054:

Line 6066: FND_MSG_PUB.ADD;

6062: WHEN OTHERS THEN
6063: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6064: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6065: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6066: FND_MSG_PUB.ADD;
6067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6068: END check_contact_point_cond;
6069:
6070: FUNCTION check_staged RETURN BOOLEAN IS