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

661: WHEN OTHERS THEN
662: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
663: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
664: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
665: FND_MSG_PUB.ADD;
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: END;
668:
669:

Line 685: FND_MSG_PUB.ADD;

681: WHEN OTHERS THEN
682: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
683: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
684: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
685: FND_MSG_PUB.ADD;
686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
687: END;
688:
689:

Line 705: FND_MSG_PUB.ADD;

701: WHEN OTHERS THEN
702: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
703: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
705: FND_MSG_PUB.ADD;
706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
707: END;
708:
709:

Line 725: FND_MSG_PUB.ADD;

721: WHEN OTHERS THEN
722: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
723: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
724: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
725: FND_MSG_PUB.ADD;
726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
727: END;
728:
729: PROCEDURE init_score_context (

Line 792: FND_MSG_PUB.ADD;

788: p_party_site_list,
789: p_contact_list,
790: p_contact_point_list) THEN
791: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
792: FND_MSG_PUB.ADD;
793: RAISE FND_API.G_EXC_ERROR;
794: END IF;
795: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
796: 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 1084: FND_MSG_PUB.ADD;

1080: END IF;
1081: IF lengthb(l_party_contains_str) > 4000 THEN
1082: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1083: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1084: FND_MSG_PUB.ADD;
1085: RAISE FND_API.G_EXC_ERROR;
1086: END IF;
1087: IF (p_match_str = ' AND ' OR p_party_max_score 1088: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1205: FND_MSG_PUB.ADD;

1201: -- Add the search criteria to query string
1202: IF lengthb(l_contains_str) > 4000 THEN
1203: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1204: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1205: FND_MSG_PUB.ADD;
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208: x_denorm_str := l_den_contains_str;
1209: RETURN l_contains_str;

Line 1447: FND_MSG_PUB.ADD;

1443: exception
1444: when others then
1445: if (instrb(SQLERRM,'DRG-51030')>0) then
1446: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1447: FND_MSG_PUB.ADD;
1448: RAISE FND_API.G_EXC_ERROR;
1449: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1451: FND_MSG_PUB.ADD;

Line 1451: FND_MSG_PUB.ADD;

1447: FND_MSG_PUB.ADD;
1448: RAISE FND_API.G_EXC_ERROR;
1449: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1451: FND_MSG_PUB.ADD;
1452: RAISE FND_API.G_EXC_ERROR;
1453: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1454: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1455: FND_MSG_PUB.ADD;

Line 1455: FND_MSG_PUB.ADD;

1451: FND_MSG_PUB.ADD;
1452: RAISE FND_API.G_EXC_ERROR;
1453: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1454: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1455: FND_MSG_PUB.ADD;
1456: RAISE FND_API.G_EXC_ERROR;
1457: else
1458: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1459: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1460: FND_MSG_PUB.ADD;

1456: RAISE FND_API.G_EXC_ERROR;
1457: else
1458: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1459: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1460: FND_MSG_PUB.ADD;
1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1462: end if;
1463: END;
1464:

Line 1692: FND_MSG_PUB.ADD;

1688: exception
1689: when others then
1690: if (instrb(SQLERRM,'DRG-51030')>0) then
1691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1692: FND_MSG_PUB.ADD;
1693: RAISE FND_API.G_EXC_ERROR;
1694: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1695: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1696: FND_MSG_PUB.ADD;

Line 1696: FND_MSG_PUB.ADD;

1692: FND_MSG_PUB.ADD;
1693: RAISE FND_API.G_EXC_ERROR;
1694: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1695: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1696: FND_MSG_PUB.ADD;
1697: RAISE FND_API.G_EXC_ERROR;
1698: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1699: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1700: FND_MSG_PUB.ADD;

Line 1700: FND_MSG_PUB.ADD;

1696: FND_MSG_PUB.ADD;
1697: RAISE FND_API.G_EXC_ERROR;
1698: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1699: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1700: FND_MSG_PUB.ADD;
1701: RAISE FND_API.G_EXC_ERROR;
1702: else
1703: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1705: FND_MSG_PUB.ADD;

1701: RAISE FND_API.G_EXC_ERROR;
1702: else
1703: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1705: FND_MSG_PUB.ADD;
1706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1707: end if;
1708: END;
1709:

Line 1839: FND_MSG_PUB.ADD;

1835: exception
1836: when others then
1837: if (instrb(SQLERRM,'DRG-51030')>0) then
1838: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1839: FND_MSG_PUB.ADD;
1840: RAISE FND_API.G_EXC_ERROR;
1841: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1842: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1843: FND_MSG_PUB.ADD;

Line 1843: FND_MSG_PUB.ADD;

1839: FND_MSG_PUB.ADD;
1840: RAISE FND_API.G_EXC_ERROR;
1841: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1842: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1843: FND_MSG_PUB.ADD;
1844: RAISE FND_API.G_EXC_ERROR;
1845: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1846: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1847: FND_MSG_PUB.ADD;

Line 1847: FND_MSG_PUB.ADD;

1843: FND_MSG_PUB.ADD;
1844: RAISE FND_API.G_EXC_ERROR;
1845: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1846: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1847: FND_MSG_PUB.ADD;
1848: RAISE FND_API.G_EXC_ERROR;
1849: else
1850: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1851: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1852: FND_MSG_PUB.ADD;

1848: RAISE FND_API.G_EXC_ERROR;
1849: else
1850: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1851: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1852: FND_MSG_PUB.ADD;
1853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1854: end if;
1855: END;
1856:

Line 2112: FND_MSG_PUB.ADD;

2108: exception
2109: when others then
2110: if (instrb(SQLERRM,'DRG-51030')>0) then
2111: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2112: FND_MSG_PUB.ADD;
2113: RAISE FND_API.G_EXC_ERROR;
2114: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2115: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2116: FND_MSG_PUB.ADD;

Line 2116: FND_MSG_PUB.ADD;

2112: FND_MSG_PUB.ADD;
2113: RAISE FND_API.G_EXC_ERROR;
2114: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2115: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2116: FND_MSG_PUB.ADD;
2117: RAISE FND_API.G_EXC_ERROR;
2118: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2119: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2120: FND_MSG_PUB.ADD;

Line 2120: FND_MSG_PUB.ADD;

2116: FND_MSG_PUB.ADD;
2117: RAISE FND_API.G_EXC_ERROR;
2118: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2119: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2120: FND_MSG_PUB.ADD;
2121: RAISE FND_API.G_EXC_ERROR;
2122: else
2123: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2124: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2125: FND_MSG_PUB.ADD;

2121: RAISE FND_API.G_EXC_ERROR;
2122: else
2123: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2124: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2125: FND_MSG_PUB.ADD;
2126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2127: end if;
2128: END;
2129:

Line 2377: FND_MSG_PUB.ADD;

2373: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2374: 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);
2375: END IF;
2376: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2377: FND_MSG_PUB.ADD;
2378: RAISE FND_API.G_EXC_ERROR;
2379: ELSE
2380: push_eval;
2381: RETURN;

Line 2427: FND_MSG_PUB.ADD;

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

Line 2500: FND_MSG_PUB.ADD;

2496: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2497: 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);
2498: END IF;
2499: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2500: FND_MSG_PUB.ADD;
2501: RAISE FND_API.G_EXC_ERROR;
2502: ELSE
2503: push_eval;
2504: RETURN;

Line 2612: FND_MSG_PUB.ADD;

2608: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2609: 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);
2610: END IF;
2611: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2612: FND_MSG_PUB.ADD;
2613: RAISE FND_API.G_EXC_ERROR;
2614: ELSE
2615: push_eval;
2616: RETURN;

Line 2723: FND_MSG_PUB.ADD;

2719: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2720: 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);
2721: END IF;
2722: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2723: FND_MSG_PUB.ADD;
2724: RAISE FND_API.G_EXC_ERROR;
2725: ELSE
2726: push_eval;
2727: RETURN;

Line 2948: FND_MSG_PUB.ADD;

2944: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2945: 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);
2946: END IF;
2947: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2948: FND_MSG_PUB.ADD;
2949: RAISE FND_API.G_EXC_ERROR;
2950: END IF;
2951: ELSE
2952: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2956: FND_MSG_PUB.ADD;

2952: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2953: 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);
2954: END IF;
2955: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2956: FND_MSG_PUB.ADD;
2957: RAISE FND_API.G_EXC_ERROR;
2958: END IF;
2959: END IF;
2960: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3164: FND_MSG_PUB.ADD;

3160: WHEN OTHERS THEN
3161: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3162: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_parties');
3163: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3164: FND_MSG_PUB.ADD;
3165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3166: END find_parties;
3167:
3168: PROCEDURE find_persons (

Line 3356: FND_MSG_PUB.ADD;

3352: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3353: 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);
3354: END IF;
3355: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3356: FND_MSG_PUB.ADD;
3357: RAISE FND_API.G_EXC_ERROR;
3358: ELSE
3359: push_eval;
3360: RETURN;

Line 3406: FND_MSG_PUB.ADD;

3402: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3403: 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);
3404: END IF;
3405: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3406: FND_MSG_PUB.ADD;
3407: RAISE FND_API.G_EXC_ERROR;
3408: ELSE
3409: push_eval;
3410: RETURN;

Line 3442: FND_MSG_PUB.ADD;

3438: exception
3439: when others then
3440: if (instrb(SQLERRM,'DRG-51030')>0) then
3441: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3442: FND_MSG_PUB.ADD;
3443: RAISE FND_API.G_EXC_ERROR;
3444: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3445: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3446: FND_MSG_PUB.ADD;

Line 3446: FND_MSG_PUB.ADD;

3442: FND_MSG_PUB.ADD;
3443: RAISE FND_API.G_EXC_ERROR;
3444: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3445: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3446: FND_MSG_PUB.ADD;
3447: RAISE FND_API.G_EXC_ERROR;
3448: else
3449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3450: end if;

Line 3518: FND_MSG_PUB.ADD;

3514: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3515: 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);
3516: END IF;
3517: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3518: FND_MSG_PUB.ADD;
3519: RAISE FND_API.G_EXC_ERROR;
3520: ELSE
3521: push_eval;
3522: RETURN;

Line 3777: FND_MSG_PUB.ADD;

3773: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3774: 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);
3775: END IF;
3776: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3777: FND_MSG_PUB.ADD;
3778: RAISE FND_API.G_EXC_ERROR;
3779: ELSE
3780: push_eval;
3781: RETURN;

Line 3890: FND_MSG_PUB.ADD;

3886: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3887: 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);
3888: END IF;
3889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3890: FND_MSG_PUB.ADD;
3891: RAISE FND_API.G_EXC_ERROR;
3892: END IF;
3893: ELSE
3894: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3898: FND_MSG_PUB.ADD;

3894: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3895: 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);
3896: END IF;
3897: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3898: FND_MSG_PUB.ADD;
3899: RAISE FND_API.G_EXC_ERROR;
3900: END IF;
3901: END IF;
3902: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 4021: FND_MSG_PUB.ADD;

4017: WHEN OTHERS THEN
4018: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4019: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_persons');
4020: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4021: FND_MSG_PUB.ADD;
4022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4023: END find_persons;
4024:
4025: PROCEDURE find_persons (

Line 4089: FND_MSG_PUB.ADD;

4085: WHEN OTHERS THEN
4086: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4087: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_party_details');
4088: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4089: FND_MSG_PUB.ADD;
4090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4091: END find_party_details;
4092:
4093: PROCEDURE find_duplicate_parties (

Line 4206: FND_MSG_PUB.ADD;

4202: WHEN OTHERS THEN
4203: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4204: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_parties');
4205: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4206: FND_MSG_PUB.ADD;
4207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4208: END find_duplicate_parties;
4209:
4210: PROCEDURE find_duplicate_party_sites (

Line 4291: FND_MSG_PUB.ADD;

4287: WHEN OTHERS THEN
4288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_party_sites');
4290: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4291: FND_MSG_PUB.ADD;
4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4293: END find_duplicate_party_sites;
4294:
4295: PROCEDURE find_duplicate_contacts (

Line 4380: FND_MSG_PUB.ADD;

4376: WHEN OTHERS THEN
4377: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4378: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contacts');
4379: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4380: FND_MSG_PUB.ADD;
4381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4382: END find_duplicate_contacts;
4383:
4384: PROCEDURE find_duplicate_contact_points (

Line 4453: FND_MSG_PUB.ADD;

4449: WHEN OTHERS THEN
4450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4451: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contact_points');
4452: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4453: FND_MSG_PUB.ADD;
4454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4455: END find_duplicate_contact_points;
4456:
4457: PROCEDURE find_parties_dynamic (

Line 4744: FND_MSG_PUB.ADD;

4740: WHEN OTHERS THEN
4741: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4742: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.call_api_dynamic');
4743: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4744: FND_MSG_PUB.ADD;
4745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4746: END call_api_dynamic;
4747:
4748:

Line 4978: FND_MSG_PUB.ADD;

4974: WHEN OTHERS THEN
4975: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4976: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_party_sites');
4977: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4978: FND_MSG_PUB.ADD;
4979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4980: END get_matching_party_sites;
4981:
4982:

Line 5205: FND_MSG_PUB.ADD;

5201: WHEN OTHERS THEN
5202: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5203: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contacts');
5204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5205: FND_MSG_PUB.ADD;
5206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5207: END get_matching_contacts;
5208:
5209:

Line 5346: FND_MSG_PUB.ADD;

5342: WHEN OTHERS THEN
5343: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5344: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contact_points');
5345: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5346: FND_MSG_PUB.ADD;
5347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5348: END get_matching_contact_points;
5349:
5350: /**********************************************************

Line 5555: FND_MSG_PUB.ADD;

5551: WHEN OTHERS THEN
5552: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5553: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_score_details');
5554: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5555: FND_MSG_PUB.ADD;
5556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5557: END get_score_details;
5558:
5559:

Line 5630: FND_MSG_PUB.ADD;

5626: WHEN OTHERS THEN
5627: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5628: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5629: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5630: FND_MSG_PUB.ADD;
5631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5632: END get_party_for_search;
5633:
5634: PROCEDURE get_search_criteria (

Line 5670: FND_MSG_PUB.ADD;

5666: WHEN OTHERS THEN
5667: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5668: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5669: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5670: FND_MSG_PUB.ADD;
5671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5672: END get_search_criteria;
5673:
5674:

Line 5737: FND_MSG_PUB.ADD;

5733: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5734: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5735: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5736: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5737: FND_MSG_PUB.ADD;
5738: RAISE FND_API.G_EXC_ERROR;
5739: END get_party_rec;
5740:
5741: /************************************************

Line 5789: FND_MSG_PUB.ADD;

5785: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5786: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5787: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5788: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5789: FND_MSG_PUB.ADD;
5790: RAISE FND_API.G_EXC_ERROR;
5791: END get_party_site_rec;
5792:
5793: /************************************************

Line 5845: FND_MSG_PUB.ADD;

5841: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5842: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5843: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5844: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5845: FND_MSG_PUB.ADD;
5846: RAISE FND_API.G_EXC_ERROR;
5847: END get_contact_rec;
5848:
5849: /************************************************

Line 5899: FND_MSG_PUB.ADD;

5895: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5896: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5897: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5898: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5899: FND_MSG_PUB.ADD;
5900: RAISE FND_API.G_EXC_ERROR;
5901: END get_contact_point_rec;
5902:
5903: /************************************************

Line 6092: FND_MSG_PUB.ADD;

6088: WHEN OTHERS THEN
6089: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6090: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6091: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6092: FND_MSG_PUB.ADD;
6093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6094: END;
6095:
6096:

Line 6135: FND_MSG_PUB.ADD;

6131: WHEN OTHERS THEN
6132: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6133: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6134: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6135: FND_MSG_PUB.ADD;
6136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6137: END;
6138:
6139:

Line 6177: FND_MSG_PUB.ADD;

6173: WHEN OTHERS THEN
6174: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6175: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6176: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6177: FND_MSG_PUB.ADD;
6178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6179: END;
6180:
6181:

Line 6282: FND_MSG_PUB.ADD;

6278: WHEN OTHERS THEN
6279: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6280: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6281: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6282: FND_MSG_PUB.ADD;
6283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6284: END;
6285:
6286:

Line 6306: FND_MSG_PUB.ADD;

6302: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
6303: p_contact_point_list(I).URL IS NOT NULL
6304: ) THEN
6305: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6306: FND_MSG_PUB.ADD;
6307: RAISE FND_API.G_EXC_ERROR;
6308: END IF;
6309: END LOOP;
6310:

Line 6339: FND_MSG_PUB.ADD;

6335: WHEN OTHERS THEN
6336: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6337: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6338: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6339: FND_MSG_PUB.ADD;
6340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6341: END check_prim_cond;
6342:
6343: /************************************************

Line 6383: FND_MSG_PUB.ADD;

6379: WHEN OTHERS THEN
6380: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6381: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6382: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6383: FND_MSG_PUB.ADD;
6384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6385: END check_party_site_cond;
6386:
6387: /************************************************

Line 6429: FND_MSG_PUB.ADD;

6425: WHEN OTHERS THEN
6426: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6427: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6428: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6429: FND_MSG_PUB.ADD;
6430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6431: END check_contact_cond;
6432:
6433: /************************************************

Line 6450: FND_MSG_PUB.ADD;

6446:
6447: FOR I IN 1..p_contact_point_list.COUNT LOOP
6448: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6449: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6450: FND_MSG_PUB.ADD;
6451: RAISE FND_API.G_EXC_ERROR;
6452: END IF;
6453: END LOOP;
6454:

Line 6474: FND_MSG_PUB.ADD;

6470: WHEN OTHERS THEN
6471: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6472: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6473: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6474: FND_MSG_PUB.ADD;
6475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6476: END check_contact_point_cond;
6477:
6478: FUNCTION check_staged RETURN BOOLEAN IS