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

559: WHEN OTHERS THEN
560: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
561: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
562: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
563: FND_MSG_PUB.ADD;
564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
565: END;
566:
567:

Line 583: FND_MSG_PUB.ADD;

579: WHEN OTHERS THEN
580: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
581: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
582: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
583: FND_MSG_PUB.ADD;
584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
585: END;
586:
587:

Line 603: FND_MSG_PUB.ADD;

599: WHEN OTHERS THEN
600: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
601: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
603: FND_MSG_PUB.ADD;
604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
605: END;
606:
607:

Line 623: FND_MSG_PUB.ADD;

619: WHEN OTHERS THEN
620: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
621: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
622: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
623: FND_MSG_PUB.ADD;
624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
625: END;
626:
627: PROCEDURE init_score_context (

Line 690: FND_MSG_PUB.ADD;

686: p_party_site_list,
687: p_contact_list,
688: p_contact_point_list) THEN
689: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
690: FND_MSG_PUB.ADD;
691: RAISE FND_API.G_EXC_ERROR;
692: END IF;
693: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
694: 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 908: FND_MSG_PUB.ADD;

904: END IF;
905: IF lengthb(l_party_contains_str) > 4000 THEN
906: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
907: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
908: FND_MSG_PUB.ADD;
909: RAISE FND_API.G_EXC_ERROR;
910: END IF;
911: IF (p_match_str = ' AND ' OR p_party_max_score 912: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 970: FND_MSG_PUB.ADD;

966: -- Add the search criteria to query string
967: IF lengthb(l_contains_str) > 4000 THEN
968: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
969: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
970: FND_MSG_PUB.ADD;
971: RAISE FND_API.G_EXC_ERROR;
972: END IF;
973: x_denorm_str := l_den_contains_str;
974: RETURN l_contains_str;

Line 1233: FND_MSG_PUB.ADD;

1229: exception
1230: when others then
1231: if (instrb(SQLERRM,'DRG-51030')>0) then
1232: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1233: FND_MSG_PUB.ADD;
1234: RAISE FND_API.G_EXC_ERROR;
1235: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1236: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1237: FND_MSG_PUB.ADD;

Line 1237: FND_MSG_PUB.ADD;

1233: FND_MSG_PUB.ADD;
1234: RAISE FND_API.G_EXC_ERROR;
1235: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1236: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1237: FND_MSG_PUB.ADD;
1238: RAISE FND_API.G_EXC_ERROR;
1239: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1240: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1241: FND_MSG_PUB.ADD;

Line 1241: FND_MSG_PUB.ADD;

1237: FND_MSG_PUB.ADD;
1238: RAISE FND_API.G_EXC_ERROR;
1239: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1240: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1241: FND_MSG_PUB.ADD;
1242: RAISE FND_API.G_EXC_ERROR;
1243: else
1244: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1245: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1246: FND_MSG_PUB.ADD;

1242: RAISE FND_API.G_EXC_ERROR;
1243: else
1244: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1245: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1246: FND_MSG_PUB.ADD;
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1248: end if;
1249: END;
1250:

Line 1478: FND_MSG_PUB.ADD;

1474: exception
1475: when others then
1476: if (instrb(SQLERRM,'DRG-51030')>0) then
1477: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1478: FND_MSG_PUB.ADD;
1479: RAISE FND_API.G_EXC_ERROR;
1480: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1481: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1482: FND_MSG_PUB.ADD;

Line 1482: FND_MSG_PUB.ADD;

1478: FND_MSG_PUB.ADD;
1479: RAISE FND_API.G_EXC_ERROR;
1480: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1481: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1482: FND_MSG_PUB.ADD;
1483: RAISE FND_API.G_EXC_ERROR;
1484: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1485: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1486: FND_MSG_PUB.ADD;

Line 1486: FND_MSG_PUB.ADD;

1482: FND_MSG_PUB.ADD;
1483: RAISE FND_API.G_EXC_ERROR;
1484: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1485: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1486: FND_MSG_PUB.ADD;
1487: RAISE FND_API.G_EXC_ERROR;
1488: else
1489: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1490: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1491: FND_MSG_PUB.ADD;

1487: RAISE FND_API.G_EXC_ERROR;
1488: else
1489: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1490: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1491: FND_MSG_PUB.ADD;
1492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1493: end if;
1494: END;
1495:

Line 1625: FND_MSG_PUB.ADD;

1621: exception
1622: when others then
1623: if (instrb(SQLERRM,'DRG-51030')>0) then
1624: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1625: FND_MSG_PUB.ADD;
1626: RAISE FND_API.G_EXC_ERROR;
1627: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1628: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1629: FND_MSG_PUB.ADD;

Line 1629: FND_MSG_PUB.ADD;

1625: FND_MSG_PUB.ADD;
1626: RAISE FND_API.G_EXC_ERROR;
1627: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1628: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1629: FND_MSG_PUB.ADD;
1630: RAISE FND_API.G_EXC_ERROR;
1631: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1632: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1633: FND_MSG_PUB.ADD;

Line 1633: FND_MSG_PUB.ADD;

1629: FND_MSG_PUB.ADD;
1630: RAISE FND_API.G_EXC_ERROR;
1631: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1632: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1633: FND_MSG_PUB.ADD;
1634: RAISE FND_API.G_EXC_ERROR;
1635: else
1636: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1637: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1638: FND_MSG_PUB.ADD;

1634: RAISE FND_API.G_EXC_ERROR;
1635: else
1636: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1637: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1638: FND_MSG_PUB.ADD;
1639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1640: end if;
1641: END;
1642:

Line 1898: FND_MSG_PUB.ADD;

1894: exception
1895: when others then
1896: if (instrb(SQLERRM,'DRG-51030')>0) then
1897: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1898: FND_MSG_PUB.ADD;
1899: RAISE FND_API.G_EXC_ERROR;
1900: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1901: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1902: FND_MSG_PUB.ADD;

Line 1902: FND_MSG_PUB.ADD;

1898: FND_MSG_PUB.ADD;
1899: RAISE FND_API.G_EXC_ERROR;
1900: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1901: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1902: FND_MSG_PUB.ADD;
1903: RAISE FND_API.G_EXC_ERROR;
1904: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1905: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1906: FND_MSG_PUB.ADD;

Line 1906: FND_MSG_PUB.ADD;

1902: FND_MSG_PUB.ADD;
1903: RAISE FND_API.G_EXC_ERROR;
1904: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1905: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1906: FND_MSG_PUB.ADD;
1907: RAISE FND_API.G_EXC_ERROR;
1908: else
1909: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1910: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1911: FND_MSG_PUB.ADD;

1907: RAISE FND_API.G_EXC_ERROR;
1908: else
1909: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1910: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1911: FND_MSG_PUB.ADD;
1912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1913: end if;
1914: END;
1915:

Line 2160: FND_MSG_PUB.ADD;

2156: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2157: 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);
2158: END IF;
2159: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2160: FND_MSG_PUB.ADD;
2161: RAISE FND_API.G_EXC_ERROR;
2162: ELSE
2163: push_eval;
2164: RETURN;

Line 2208: FND_MSG_PUB.ADD;

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

Line 2281: FND_MSG_PUB.ADD;

2277: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2278: 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);
2279: END IF;
2280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2281: FND_MSG_PUB.ADD;
2282: RAISE FND_API.G_EXC_ERROR;
2283: ELSE
2284: push_eval;
2285: RETURN;

Line 2393: FND_MSG_PUB.ADD;

2389: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2390: 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);
2391: END IF;
2392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2393: FND_MSG_PUB.ADD;
2394: RAISE FND_API.G_EXC_ERROR;
2395: ELSE
2396: push_eval;
2397: RETURN;

Line 2504: FND_MSG_PUB.ADD;

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

Line 2729: FND_MSG_PUB.ADD;

2725: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2726: 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);
2727: END IF;
2728: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2729: FND_MSG_PUB.ADD;
2730: RAISE FND_API.G_EXC_ERROR;
2731: END IF;
2732: ELSE
2733: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2737: FND_MSG_PUB.ADD;

2733: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2734: 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);
2735: END IF;
2736: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2737: FND_MSG_PUB.ADD;
2738: RAISE FND_API.G_EXC_ERROR;
2739: END IF;
2740: END IF;
2741: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 2945: FND_MSG_PUB.ADD;

2941: WHEN OTHERS THEN
2942: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2943: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_parties');
2944: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2945: FND_MSG_PUB.ADD;
2946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2947: END find_parties;
2948:
2949: PROCEDURE find_persons (

Line 3134: FND_MSG_PUB.ADD;

3130: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3131: 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);
3132: END IF;
3133: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3134: FND_MSG_PUB.ADD;
3135: RAISE FND_API.G_EXC_ERROR;
3136: ELSE
3137: push_eval;
3138: RETURN;

Line 3182: FND_MSG_PUB.ADD;

3178: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3179: hz_utility_v2pub.debug(p_message=>'In eval party level number of matches found exceeded threshold',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
3180: END IF;
3181: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3182: FND_MSG_PUB.ADD;
3183: RAISE FND_API.G_EXC_ERROR;
3184: ELSE
3185: push_eval;
3186: RETURN;

Line 3218: FND_MSG_PUB.ADD;

3214: exception
3215: when others then
3216: if (instrb(SQLERRM,'DRG-51030')>0) then
3217: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3218: FND_MSG_PUB.ADD;
3219: RAISE FND_API.G_EXC_ERROR;
3220: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3221: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3222: FND_MSG_PUB.ADD;

Line 3222: FND_MSG_PUB.ADD;

3218: FND_MSG_PUB.ADD;
3219: RAISE FND_API.G_EXC_ERROR;
3220: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3221: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3222: FND_MSG_PUB.ADD;
3223: RAISE FND_API.G_EXC_ERROR;
3224: else
3225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3226: end if;

Line 3294: FND_MSG_PUB.ADD;

3290: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3291: 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);
3292: END IF;
3293: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3294: FND_MSG_PUB.ADD;
3295: RAISE FND_API.G_EXC_ERROR;
3296: ELSE
3297: push_eval;
3298: RETURN;

Line 3553: FND_MSG_PUB.ADD;

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

Line 3666: FND_MSG_PUB.ADD;

3662: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3663: 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);
3664: END IF;
3665: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3666: FND_MSG_PUB.ADD;
3667: RAISE FND_API.G_EXC_ERROR;
3668: END IF;
3669: ELSE
3670: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3674: FND_MSG_PUB.ADD;

3670: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3671: 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);
3672: END IF;
3673: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3674: FND_MSG_PUB.ADD;
3675: RAISE FND_API.G_EXC_ERROR;
3676: END IF;
3677: END IF;
3678: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3797: FND_MSG_PUB.ADD;

3793: WHEN OTHERS THEN
3794: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3795: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_persons');
3796: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3797: FND_MSG_PUB.ADD;
3798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3799: END find_persons;
3800:
3801: PROCEDURE find_persons (

Line 3865: FND_MSG_PUB.ADD;

3861: WHEN OTHERS THEN
3862: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3863: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_party_details');
3864: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3865: FND_MSG_PUB.ADD;
3866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3867: END find_party_details;
3868:
3869: PROCEDURE find_duplicate_parties (

Line 3982: FND_MSG_PUB.ADD;

3978: WHEN OTHERS THEN
3979: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3980: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_parties');
3981: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3982: FND_MSG_PUB.ADD;
3983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3984: END find_duplicate_parties;
3985:
3986: PROCEDURE find_duplicate_party_sites (

Line 4067: FND_MSG_PUB.ADD;

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

Line 4156: FND_MSG_PUB.ADD;

4152: WHEN OTHERS THEN
4153: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4154: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contacts');
4155: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4156: FND_MSG_PUB.ADD;
4157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4158: END find_duplicate_contacts;
4159:
4160: PROCEDURE find_duplicate_contact_points (

Line 4229: FND_MSG_PUB.ADD;

4225: WHEN OTHERS THEN
4226: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4227: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.find_duplicate_contact_points');
4228: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4229: FND_MSG_PUB.ADD;
4230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4231: END find_duplicate_contact_points;
4232:
4233: PROCEDURE find_parties_dynamic (

Line 4503: FND_MSG_PUB.ADD;

4499: WHEN OTHERS THEN
4500: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4501: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.call_api_dynamic');
4502: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4503: FND_MSG_PUB.ADD;
4504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4505: END call_api_dynamic;
4506:
4507:

Line 4737: FND_MSG_PUB.ADD;

4733: WHEN OTHERS THEN
4734: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4735: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_party_sites');
4736: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4737: FND_MSG_PUB.ADD;
4738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4739: END get_matching_party_sites;
4740:
4741:

Line 4962: FND_MSG_PUB.ADD;

4958: WHEN OTHERS THEN
4959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4960: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_contacts');
4961: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4962: FND_MSG_PUB.ADD;
4963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4964: END get_matching_contacts;
4965:
4966:

Line 5101: FND_MSG_PUB.ADD;

5097: WHEN OTHERS THEN
5098: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5099: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_contact_points');
5100: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5101: FND_MSG_PUB.ADD;
5102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5103: END get_matching_contact_points;
5104:
5105: /**********************************************************

Line 5303: FND_MSG_PUB.ADD;

5299: WHEN OTHERS THEN
5300: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5301: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_score_details');
5302: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5303: FND_MSG_PUB.ADD;
5304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5305: END get_score_details;
5306:
5307:

Line 5381: FND_MSG_PUB.ADD;

5377: WHEN OTHERS THEN
5378: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5379: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5380: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5381: FND_MSG_PUB.ADD;
5382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5383: END get_party_for_search;
5384:
5385: PROCEDURE get_search_criteria (

Line 5421: FND_MSG_PUB.ADD;

5417: WHEN OTHERS THEN
5418: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5419: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5420: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5421: FND_MSG_PUB.ADD;
5422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5423: END get_search_criteria;
5424:
5425:

Line 5486: FND_MSG_PUB.ADD;

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

Line 5542: FND_MSG_PUB.ADD;

5538: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5539: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5540: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5541: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5542: FND_MSG_PUB.ADD;
5543: RAISE FND_API.G_EXC_ERROR;
5544: END get_party_site_rec;
5545:
5546: /************************************************

Line 5598: FND_MSG_PUB.ADD;

5594: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5595: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5596: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5597: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5598: FND_MSG_PUB.ADD;
5599: RAISE FND_API.G_EXC_ERROR;
5600: END get_contact_rec;
5601:
5602: /************************************************

Line 5650: FND_MSG_PUB.ADD;

5646: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5647: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5648: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5649: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5650: FND_MSG_PUB.ADD;
5651: RAISE FND_API.G_EXC_ERROR;
5652: END get_contact_point_rec;
5653:
5654: /************************************************

Line 5786: FND_MSG_PUB.ADD;

5782: WHEN OTHERS THEN
5783: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5784: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5785: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5786: FND_MSG_PUB.ADD;
5787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5788: END;
5789:
5790:

Line 5901: FND_MSG_PUB.ADD;

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

Line 5943: FND_MSG_PUB.ADD;

5939: WHEN OTHERS THEN
5940: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5941: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5942: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5943: FND_MSG_PUB.ADD;
5944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5945: END;
5946:
5947:

Line 6010: FND_MSG_PUB.ADD;

6006: WHEN OTHERS THEN
6007: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6008: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6009: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6010: FND_MSG_PUB.ADD;
6011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6012: END;
6013:
6014:

Line 6045: FND_MSG_PUB.ADD;

6041: WHEN OTHERS THEN
6042: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6043: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6045: FND_MSG_PUB.ADD;
6046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6047: END check_prim_cond;
6048:
6049: /************************************************

Line 6089: FND_MSG_PUB.ADD;

6085: WHEN OTHERS THEN
6086: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6087: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6088: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6089: FND_MSG_PUB.ADD;
6090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6091: END check_party_site_cond;
6092:
6093: /************************************************

Line 6127: FND_MSG_PUB.ADD;

6123: WHEN OTHERS THEN
6124: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6125: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6126: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6127: FND_MSG_PUB.ADD;
6128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6129: END check_contact_cond;
6130:
6131: /************************************************

Line 6148: FND_MSG_PUB.ADD;

6144:
6145: FOR I IN 1..p_contact_point_list.COUNT LOOP
6146: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6147: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6148: FND_MSG_PUB.ADD;
6149: RAISE FND_API.G_EXC_ERROR;
6150: END IF;
6151: END LOOP;
6152:

Line 6164: FND_MSG_PUB.ADD;

6160: WHEN OTHERS THEN
6161: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6162: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6163: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6164: FND_MSG_PUB.ADD;
6165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6166: END check_contact_point_cond;
6167:
6168: FUNCTION check_staged RETURN BOOLEAN IS