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

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

Line 1239: FND_MSG_PUB.ADD;

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

Line 1243: FND_MSG_PUB.ADD;

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

Line 1248: FND_MSG_PUB.ADD;

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

Line 1480: FND_MSG_PUB.ADD;

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

Line 1484: FND_MSG_PUB.ADD;

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

Line 1488: FND_MSG_PUB.ADD;

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

Line 1493: FND_MSG_PUB.ADD;

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

Line 1627: FND_MSG_PUB.ADD;

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

Line 1631: FND_MSG_PUB.ADD;

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

Line 1635: FND_MSG_PUB.ADD;

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

Line 1640: FND_MSG_PUB.ADD;

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

Line 1900: FND_MSG_PUB.ADD;

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

Line 1904: FND_MSG_PUB.ADD;

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

Line 1908: FND_MSG_PUB.ADD;

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

Line 1913: FND_MSG_PUB.ADD;

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

Line 2163: FND_MSG_PUB.ADD;

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

Line 2211: FND_MSG_PUB.ADD;

2207: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2208: 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);
2209: END IF;
2210: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2211: FND_MSG_PUB.ADD;
2212: RAISE FND_API.G_EXC_ERROR;
2213: ELSE
2214: push_eval;
2215: RETURN;

Line 2284: FND_MSG_PUB.ADD;

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

Line 2396: FND_MSG_PUB.ADD;

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

Line 2507: FND_MSG_PUB.ADD;

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

Line 2732: FND_MSG_PUB.ADD;

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

Line 2740: FND_MSG_PUB.ADD;

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

Line 2948: FND_MSG_PUB.ADD;

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

Line 3138: FND_MSG_PUB.ADD;

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

Line 3186: FND_MSG_PUB.ADD;

3182: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3183: 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);
3184: END IF;
3185: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3186: FND_MSG_PUB.ADD;
3187: RAISE FND_API.G_EXC_ERROR;
3188: ELSE
3189: push_eval;
3190: RETURN;

Line 3222: FND_MSG_PUB.ADD;

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

Line 3226: FND_MSG_PUB.ADD;

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

Line 3298: FND_MSG_PUB.ADD;

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

Line 3557: FND_MSG_PUB.ADD;

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

Line 3670: FND_MSG_PUB.ADD;

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

Line 3678: FND_MSG_PUB.ADD;

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

Line 3801: FND_MSG_PUB.ADD;

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

Line 3869: FND_MSG_PUB.ADD;

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

Line 3986: FND_MSG_PUB.ADD;

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

Line 4071: FND_MSG_PUB.ADD;

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

Line 4160: FND_MSG_PUB.ADD;

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

Line 4233: FND_MSG_PUB.ADD;

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

Line 4507: FND_MSG_PUB.ADD;

4503: WHEN OTHERS THEN
4504: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4505: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.call_api_dynamic');
4506: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4507: FND_MSG_PUB.ADD;
4508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4509: END call_api_dynamic;
4510:
4511:

Line 4741: FND_MSG_PUB.ADD;

4737: WHEN OTHERS THEN
4738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4739: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_party_sites');
4740: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4741: FND_MSG_PUB.ADD;
4742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4743: END get_matching_party_sites;
4744:
4745:

Line 4966: FND_MSG_PUB.ADD;

4962: WHEN OTHERS THEN
4963: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4964: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_39.get_matching_contacts');
4965: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4966: FND_MSG_PUB.ADD;
4967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4968: END get_matching_contacts;
4969:
4970:

Line 5105: FND_MSG_PUB.ADD;

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

Line 5308: FND_MSG_PUB.ADD;

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

Line 5386: FND_MSG_PUB.ADD;

5382: WHEN OTHERS THEN
5383: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5384: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5385: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5386: FND_MSG_PUB.ADD;
5387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5388: END get_party_for_search;
5389:
5390: PROCEDURE get_search_criteria (

Line 5426: FND_MSG_PUB.ADD;

5422: WHEN OTHERS THEN
5423: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5424: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5425: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5426: FND_MSG_PUB.ADD;
5427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5428: END get_search_criteria;
5429:
5430:

Line 5491: FND_MSG_PUB.ADD;

5487: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5488: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5489: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5490: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5491: FND_MSG_PUB.ADD;
5492: RAISE FND_API.G_EXC_ERROR;
5493: END get_party_rec;
5494:
5495: /************************************************

Line 5547: FND_MSG_PUB.ADD;

5543: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5544: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5545: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5546: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5547: FND_MSG_PUB.ADD;
5548: RAISE FND_API.G_EXC_ERROR;
5549: END get_party_site_rec;
5550:
5551: /************************************************

Line 5603: FND_MSG_PUB.ADD;

5599: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5600: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5601: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5603: FND_MSG_PUB.ADD;
5604: RAISE FND_API.G_EXC_ERROR;
5605: END get_contact_rec;
5606:
5607: /************************************************

Line 5655: FND_MSG_PUB.ADD;

5651: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5652: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5653: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5654: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5655: FND_MSG_PUB.ADD;
5656: RAISE FND_API.G_EXC_ERROR;
5657: END get_contact_point_rec;
5658:
5659: /************************************************

Line 5791: FND_MSG_PUB.ADD;

5787: WHEN OTHERS THEN
5788: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5789: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5790: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5791: FND_MSG_PUB.ADD;
5792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5793: END;
5794:
5795:

Line 5906: FND_MSG_PUB.ADD;

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

Line 5948: FND_MSG_PUB.ADD;

5944: WHEN OTHERS THEN
5945: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5946: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5947: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5948: FND_MSG_PUB.ADD;
5949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5950: END;
5951:
5952:

Line 6015: FND_MSG_PUB.ADD;

6011: WHEN OTHERS THEN
6012: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6013: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6014: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6015: FND_MSG_PUB.ADD;
6016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6017: END;
6018:
6019:

Line 6050: FND_MSG_PUB.ADD;

6046: WHEN OTHERS THEN
6047: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6048: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6049: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6050: FND_MSG_PUB.ADD;
6051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6052: END check_prim_cond;
6053:
6054: /************************************************

Line 6094: FND_MSG_PUB.ADD;

6090: WHEN OTHERS THEN
6091: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6092: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6093: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6094: FND_MSG_PUB.ADD;
6095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6096: END check_party_site_cond;
6097:
6098: /************************************************

Line 6132: FND_MSG_PUB.ADD;

6128: WHEN OTHERS THEN
6129: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6130: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6131: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6132: FND_MSG_PUB.ADD;
6133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6134: END check_contact_cond;
6135:
6136: /************************************************

Line 6153: FND_MSG_PUB.ADD;

6149:
6150: FOR I IN 1..p_contact_point_list.COUNT LOOP
6151: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6152: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6153: FND_MSG_PUB.ADD;
6154: RAISE FND_API.G_EXC_ERROR;
6155: END IF;
6156: END LOOP;
6157:

Line 6169: FND_MSG_PUB.ADD;

6165: WHEN OTHERS THEN
6166: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6167: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6168: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6169: FND_MSG_PUB.ADD;
6170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6171: END check_contact_point_cond;
6172:
6173: FUNCTION check_staged RETURN BOOLEAN IS