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

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

Line 1252: FND_MSG_PUB.ADD;

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

Line 1256: FND_MSG_PUB.ADD;

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

Line 1261: FND_MSG_PUB.ADD;

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

Line 1493: FND_MSG_PUB.ADD;

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

Line 1497: FND_MSG_PUB.ADD;

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

Line 1501: FND_MSG_PUB.ADD;

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

Line 1506: FND_MSG_PUB.ADD;

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

Line 1640: FND_MSG_PUB.ADD;

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

Line 1644: FND_MSG_PUB.ADD;

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

Line 1648: FND_MSG_PUB.ADD;

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

Line 1653: FND_MSG_PUB.ADD;

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

Line 1913: FND_MSG_PUB.ADD;

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

Line 1917: FND_MSG_PUB.ADD;

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

Line 1921: FND_MSG_PUB.ADD;

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

Line 1926: FND_MSG_PUB.ADD;

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

Line 2175: FND_MSG_PUB.ADD;

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

Line 2223: FND_MSG_PUB.ADD;

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

Line 2296: FND_MSG_PUB.ADD;

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

Line 2408: FND_MSG_PUB.ADD;

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

Line 2519: FND_MSG_PUB.ADD;

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

Line 2663: FND_MSG_PUB.ADD;

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

Line 2671: FND_MSG_PUB.ADD;

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

Line 2922: FND_MSG_PUB.ADD;

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

Line 3111: FND_MSG_PUB.ADD;

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

Line 3159: FND_MSG_PUB.ADD;

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

Line 3195: FND_MSG_PUB.ADD;

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

Line 3199: FND_MSG_PUB.ADD;

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

Line 3271: FND_MSG_PUB.ADD;

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

Line 3460: FND_MSG_PUB.ADD;

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

Line 3548: FND_MSG_PUB.ADD;

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

Line 3556: FND_MSG_PUB.ADD;

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

Line 3705: FND_MSG_PUB.ADD;

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

Line 3773: FND_MSG_PUB.ADD;

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

Line 3890: FND_MSG_PUB.ADD;

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

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_4.find_duplicate_party_sites');
3974: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3975: FND_MSG_PUB.ADD;
3976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3977: END find_duplicate_party_sites;
3978:
3979: PROCEDURE find_duplicate_contacts (

Line 4064: FND_MSG_PUB.ADD;

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

Line 4137: FND_MSG_PUB.ADD;

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

Line 4411: FND_MSG_PUB.ADD;

4407: WHEN OTHERS THEN
4408: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4409: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.call_api_dynamic');
4410: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4411: FND_MSG_PUB.ADD;
4412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4413: END call_api_dynamic;
4414:
4415:

Line 4645: FND_MSG_PUB.ADD;

4641: WHEN OTHERS THEN
4642: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4643: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_party_sites');
4644: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4645: FND_MSG_PUB.ADD;
4646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4647: END get_matching_party_sites;
4648:
4649:

Line 4870: FND_MSG_PUB.ADD;

4866: WHEN OTHERS THEN
4867: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4868: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_matching_contacts');
4869: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4870: FND_MSG_PUB.ADD;
4871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4872: END get_matching_contacts;
4873:
4874:

Line 5009: FND_MSG_PUB.ADD;

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

Line 5211: FND_MSG_PUB.ADD;

5207: WHEN OTHERS THEN
5208: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5209: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_4.get_score_details');
5210: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5211: FND_MSG_PUB.ADD;
5212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5213: END get_score_details;
5214:
5215:

Line 5289: FND_MSG_PUB.ADD;

5285: WHEN OTHERS THEN
5286: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5287: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5288: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5289: FND_MSG_PUB.ADD;
5290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5291: END get_party_for_search;
5292:
5293: PROCEDURE get_search_criteria (

Line 5329: FND_MSG_PUB.ADD;

5325: WHEN OTHERS THEN
5326: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5327: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5328: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5329: FND_MSG_PUB.ADD;
5330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5331: END get_search_criteria;
5332:
5333:

Line 5396: FND_MSG_PUB.ADD;

5392: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5393: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5394: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5395: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5396: FND_MSG_PUB.ADD;
5397: RAISE FND_API.G_EXC_ERROR;
5398: END get_party_rec;
5399:
5400: /************************************************

Line 5452: FND_MSG_PUB.ADD;

5448: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5449: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5450: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5451: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5452: FND_MSG_PUB.ADD;
5453: RAISE FND_API.G_EXC_ERROR;
5454: END get_party_site_rec;
5455:
5456: /************************************************

Line 5508: FND_MSG_PUB.ADD;

5504: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5505: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5506: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5507: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5508: FND_MSG_PUB.ADD;
5509: RAISE FND_API.G_EXC_ERROR;
5510: END get_contact_rec;
5511:
5512: /************************************************

Line 5560: FND_MSG_PUB.ADD;

5556: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5557: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5558: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5559: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5560: FND_MSG_PUB.ADD;
5561: RAISE FND_API.G_EXC_ERROR;
5562: END get_contact_point_rec;
5563:
5564: /************************************************

Line 5707: FND_MSG_PUB.ADD;

5703: WHEN OTHERS THEN
5704: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5705: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5706: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5707: FND_MSG_PUB.ADD;
5708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5709: END;
5710:
5711:

Line 5822: FND_MSG_PUB.ADD;

5818: WHEN OTHERS THEN
5819: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5820: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5821: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5822: FND_MSG_PUB.ADD;
5823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5824: END;
5825:
5826:

Line 5864: FND_MSG_PUB.ADD;

5860: WHEN OTHERS THEN
5861: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5862: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5863: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5864: FND_MSG_PUB.ADD;
5865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5866: END;
5867:
5868:

Line 5907: FND_MSG_PUB.ADD;

5903: WHEN OTHERS THEN
5904: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5905: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5906: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5907: FND_MSG_PUB.ADD;
5908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5909: END;
5910:
5911:

Line 5942: FND_MSG_PUB.ADD;

5938: WHEN OTHERS THEN
5939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5940: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5942: FND_MSG_PUB.ADD;
5943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5944: END check_prim_cond;
5945:
5946: /************************************************

Line 5986: FND_MSG_PUB.ADD;

5982: WHEN OTHERS THEN
5983: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5984: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5986: FND_MSG_PUB.ADD;
5987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5988: END check_party_site_cond;
5989:
5990: /************************************************

Line 6024: FND_MSG_PUB.ADD;

6020: WHEN OTHERS THEN
6021: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6022: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6023: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6024: FND_MSG_PUB.ADD;
6025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6026: END check_contact_cond;
6027:
6028: /************************************************

Line 6045: FND_MSG_PUB.ADD;

6041:
6042: FOR I IN 1..p_contact_point_list.COUNT LOOP
6043: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6044: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6045: FND_MSG_PUB.ADD;
6046: RAISE FND_API.G_EXC_ERROR;
6047: END IF;
6048: END LOOP;
6049:

Line 6061: FND_MSG_PUB.ADD;

6057: WHEN OTHERS THEN
6058: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6059: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6060: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6061: FND_MSG_PUB.ADD;
6062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6063: END check_contact_point_cond;
6064:
6065: FUNCTION check_staged RETURN BOOLEAN IS