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

844: WHEN OTHERS THEN
845: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
846: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
847: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
848: FND_MSG_PUB.ADD;
849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
850: END;
851:
852:

Line 873: FND_MSG_PUB.ADD;

869: WHEN OTHERS THEN
870: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
871: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
872: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
873: FND_MSG_PUB.ADD;
874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
875: END;
876:
877:

Line 893: FND_MSG_PUB.ADD;

889: WHEN OTHERS THEN
890: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
891: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
892: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
893: FND_MSG_PUB.ADD;
894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
895: END;
896:
897:

Line 913: FND_MSG_PUB.ADD;

909: WHEN OTHERS THEN
910: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
911: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
912: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
913: FND_MSG_PUB.ADD;
914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
915: END;
916:
917: PROCEDURE init_score_context (

Line 980: FND_MSG_PUB.ADD;

976: p_party_site_list,
977: p_contact_list,
978: p_contact_point_list) THEN
979: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
980: FND_MSG_PUB.ADD;
981: RAISE FND_API.G_EXC_ERROR;
982: END IF;
983: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
984: 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 1215: FND_MSG_PUB.ADD;

1211: END IF;
1212: IF lengthb(l_party_contains_str) > 4000 THEN
1213: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1214: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1215: FND_MSG_PUB.ADD;
1216: RAISE FND_API.G_EXC_ERROR;
1217: END IF;
1218: IF (p_match_str = ' AND ' OR p_party_max_score 1219: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1334: FND_MSG_PUB.ADD;

1330: -- Add the search criteria to query string
1331: IF lengthb(l_contains_str) > 4000 THEN
1332: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1333: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1334: FND_MSG_PUB.ADD;
1335: RAISE FND_API.G_EXC_ERROR;
1336: END IF;
1337: x_denorm_str := l_den_contains_str;
1338: RETURN l_contains_str;

Line 1641: FND_MSG_PUB.ADD;

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

Line 1645: FND_MSG_PUB.ADD;

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

Line 1649: FND_MSG_PUB.ADD;

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

Line 1654: FND_MSG_PUB.ADD;

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

Line 1886: FND_MSG_PUB.ADD;

1882: exception
1883: when others then
1884: if (instrb(SQLERRM,'DRG-51030')>0) then
1885: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1886: FND_MSG_PUB.ADD;
1887: RAISE FND_API.G_EXC_ERROR;
1888: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1890: FND_MSG_PUB.ADD;

Line 1890: FND_MSG_PUB.ADD;

1886: FND_MSG_PUB.ADD;
1887: RAISE FND_API.G_EXC_ERROR;
1888: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1890: FND_MSG_PUB.ADD;
1891: RAISE FND_API.G_EXC_ERROR;
1892: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1893: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1894: FND_MSG_PUB.ADD;

Line 1894: FND_MSG_PUB.ADD;

1890: FND_MSG_PUB.ADD;
1891: RAISE FND_API.G_EXC_ERROR;
1892: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1893: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1894: FND_MSG_PUB.ADD;
1895: RAISE FND_API.G_EXC_ERROR;
1896: else
1897: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1898: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 1899: FND_MSG_PUB.ADD;

1895: RAISE FND_API.G_EXC_ERROR;
1896: else
1897: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1898: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1899: FND_MSG_PUB.ADD;
1900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1901: end if;
1902: END;
1903:

Line 2033: FND_MSG_PUB.ADD;

2029: exception
2030: when others then
2031: if (instrb(SQLERRM,'DRG-51030')>0) then
2032: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2033: FND_MSG_PUB.ADD;
2034: RAISE FND_API.G_EXC_ERROR;
2035: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2036: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2037: FND_MSG_PUB.ADD;

Line 2037: FND_MSG_PUB.ADD;

2033: FND_MSG_PUB.ADD;
2034: RAISE FND_API.G_EXC_ERROR;
2035: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2036: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2037: FND_MSG_PUB.ADD;
2038: RAISE FND_API.G_EXC_ERROR;
2039: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2040: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2041: FND_MSG_PUB.ADD;

Line 2041: FND_MSG_PUB.ADD;

2037: FND_MSG_PUB.ADD;
2038: RAISE FND_API.G_EXC_ERROR;
2039: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2040: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2041: FND_MSG_PUB.ADD;
2042: RAISE FND_API.G_EXC_ERROR;
2043: else
2044: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2045: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2046: FND_MSG_PUB.ADD;

2042: RAISE FND_API.G_EXC_ERROR;
2043: else
2044: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2045: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2046: FND_MSG_PUB.ADD;
2047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2048: end if;
2049: END;
2050:

Line 2306: FND_MSG_PUB.ADD;

2302: exception
2303: when others then
2304: if (instrb(SQLERRM,'DRG-51030')>0) then
2305: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2306: FND_MSG_PUB.ADD;
2307: RAISE FND_API.G_EXC_ERROR;
2308: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2309: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2310: FND_MSG_PUB.ADD;

Line 2310: FND_MSG_PUB.ADD;

2306: FND_MSG_PUB.ADD;
2307: RAISE FND_API.G_EXC_ERROR;
2308: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2309: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2310: FND_MSG_PUB.ADD;
2311: RAISE FND_API.G_EXC_ERROR;
2312: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2313: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2314: FND_MSG_PUB.ADD;

Line 2314: FND_MSG_PUB.ADD;

2310: FND_MSG_PUB.ADD;
2311: RAISE FND_API.G_EXC_ERROR;
2312: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2313: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2314: FND_MSG_PUB.ADD;
2315: RAISE FND_API.G_EXC_ERROR;
2316: else
2317: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2318: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

Line 2319: FND_MSG_PUB.ADD;

2315: RAISE FND_API.G_EXC_ERROR;
2316: else
2317: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2318: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2319: FND_MSG_PUB.ADD;
2320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2321: end if;
2322: END;
2323:

Line 2578: FND_MSG_PUB.ADD;

2574: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2575: 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);
2576: END IF;
2577: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2578: FND_MSG_PUB.ADD;
2579: RAISE FND_API.G_EXC_ERROR;
2580: ELSE
2581: push_eval;
2582: RETURN;

Line 2626: FND_MSG_PUB.ADD;

2622: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2623: 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);
2624: END IF;
2625: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2626: FND_MSG_PUB.ADD;
2627: RAISE FND_API.G_EXC_ERROR;
2628: ELSE
2629: push_eval;
2630: RETURN;

Line 2699: FND_MSG_PUB.ADD;

2695: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2696: 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);
2697: END IF;
2698: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2699: FND_MSG_PUB.ADD;
2700: RAISE FND_API.G_EXC_ERROR;
2701: ELSE
2702: push_eval;
2703: RETURN;

Line 2811: FND_MSG_PUB.ADD;

2807: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2808: 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);
2809: END IF;
2810: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2811: FND_MSG_PUB.ADD;
2812: RAISE FND_API.G_EXC_ERROR;
2813: ELSE
2814: push_eval;
2815: RETURN;

Line 2922: FND_MSG_PUB.ADD;

2918: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2919: 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);
2920: END IF;
2921: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2922: FND_MSG_PUB.ADD;
2923: RAISE FND_API.G_EXC_ERROR;
2924: ELSE
2925: push_eval;
2926: RETURN;

Line 3147: FND_MSG_PUB.ADD;

3143: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3144: 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);
3145: END IF;
3146: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3147: FND_MSG_PUB.ADD;
3148: RAISE FND_API.G_EXC_ERROR;
3149: END IF;
3150: ELSE
3151: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3155: FND_MSG_PUB.ADD;

3151: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3152: 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);
3153: END IF;
3154: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3155: FND_MSG_PUB.ADD;
3156: RAISE FND_API.G_EXC_ERROR;
3157: END IF;
3158: END IF;
3159: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 3363: FND_MSG_PUB.ADD;

3359: WHEN OTHERS THEN
3360: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3361: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_parties');
3362: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3363: FND_MSG_PUB.ADD;
3364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3365: END find_parties;
3366:
3367: PROCEDURE find_persons (

Line 3562: FND_MSG_PUB.ADD;

3558: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3559: 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);
3560: END IF;
3561: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3562: FND_MSG_PUB.ADD;
3563: RAISE FND_API.G_EXC_ERROR;
3564: ELSE
3565: push_eval;
3566: RETURN;

Line 3610: FND_MSG_PUB.ADD;

3606: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3607: 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);
3608: END IF;
3609: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3610: FND_MSG_PUB.ADD;
3611: RAISE FND_API.G_EXC_ERROR;
3612: ELSE
3613: push_eval;
3614: RETURN;

Line 3646: FND_MSG_PUB.ADD;

3642: exception
3643: when others then
3644: if (instrb(SQLERRM,'DRG-51030')>0) then
3645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3646: FND_MSG_PUB.ADD;
3647: RAISE FND_API.G_EXC_ERROR;
3648: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3649: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3650: FND_MSG_PUB.ADD;

Line 3650: FND_MSG_PUB.ADD;

3646: FND_MSG_PUB.ADD;
3647: RAISE FND_API.G_EXC_ERROR;
3648: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3649: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3650: FND_MSG_PUB.ADD;
3651: RAISE FND_API.G_EXC_ERROR;
3652: else
3653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3654: end if;

Line 3722: FND_MSG_PUB.ADD;

3718: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3719: 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);
3720: END IF;
3721: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3722: FND_MSG_PUB.ADD;
3723: RAISE FND_API.G_EXC_ERROR;
3724: ELSE
3725: push_eval;
3726: RETURN;

Line 3981: FND_MSG_PUB.ADD;

3977: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3978: 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);
3979: END IF;
3980: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3981: FND_MSG_PUB.ADD;
3982: RAISE FND_API.G_EXC_ERROR;
3983: ELSE
3984: push_eval;
3985: RETURN;

Line 4094: FND_MSG_PUB.ADD;

4090: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4091: 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);
4092: END IF;
4093: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4094: FND_MSG_PUB.ADD;
4095: RAISE FND_API.G_EXC_ERROR;
4096: END IF;
4097: ELSE
4098: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 4102: FND_MSG_PUB.ADD;

4098: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4099: 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);
4100: END IF;
4101: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4102: FND_MSG_PUB.ADD;
4103: RAISE FND_API.G_EXC_ERROR;
4104: END IF;
4105: END IF;
4106: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN

Line 4225: FND_MSG_PUB.ADD;

4221: WHEN OTHERS THEN
4222: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4223: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_persons');
4224: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4225: FND_MSG_PUB.ADD;
4226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4227: END find_persons;
4228:
4229: PROCEDURE find_persons (

Line 4293: FND_MSG_PUB.ADD;

4289: WHEN OTHERS THEN
4290: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4291: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_party_details');
4292: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4293: FND_MSG_PUB.ADD;
4294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4295: END find_party_details;
4296:
4297: PROCEDURE find_duplicate_parties (

Line 4410: FND_MSG_PUB.ADD;

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

Line 4495: FND_MSG_PUB.ADD;

4491: WHEN OTHERS THEN
4492: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4493: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_party_sites');
4494: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4495: FND_MSG_PUB.ADD;
4496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4497: END find_duplicate_party_sites;
4498:
4499: PROCEDURE find_duplicate_contacts (

Line 4584: FND_MSG_PUB.ADD;

4580: WHEN OTHERS THEN
4581: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4582: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_contacts');
4583: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4584: FND_MSG_PUB.ADD;
4585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4586: END find_duplicate_contacts;
4587:
4588: PROCEDURE find_duplicate_contact_points (

Line 4657: FND_MSG_PUB.ADD;

4653: WHEN OTHERS THEN
4654: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4655: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.find_duplicate_contact_points');
4656: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4657: FND_MSG_PUB.ADD;
4658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4659: END find_duplicate_contact_points;
4660:
4661: PROCEDURE find_parties_dynamic (

Line 4959: FND_MSG_PUB.ADD;

4955: WHEN OTHERS THEN
4956: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4957: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.call_api_dynamic');
4958: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4959: FND_MSG_PUB.ADD;
4960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4961: END call_api_dynamic;
4962:
4963:

Line 5203: FND_MSG_PUB.ADD;

5199: WHEN OTHERS THEN
5200: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5201: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_party_sites');
5202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5203: FND_MSG_PUB.ADD;
5204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5205: END get_matching_party_sites;
5206:
5207:

Line 5428: FND_MSG_PUB.ADD;

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

Line 5567: FND_MSG_PUB.ADD;

5563: WHEN OTHERS THEN
5564: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5565: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_matching_contact_points');
5566: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5567: FND_MSG_PUB.ADD;
5568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5569: END get_matching_contact_points;
5570:
5571: /**********************************************************

Line 5798: FND_MSG_PUB.ADD;

5794: WHEN OTHERS THEN
5795: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5796: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_36.get_score_details');
5797: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5798: FND_MSG_PUB.ADD;
5799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5800: END get_score_details;
5801:
5802:

Line 5876: FND_MSG_PUB.ADD;

5872: WHEN OTHERS THEN
5873: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5874: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5875: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5876: FND_MSG_PUB.ADD;
5877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5878: END get_party_for_search;
5879:
5880: PROCEDURE get_search_criteria (

Line 5916: FND_MSG_PUB.ADD;

5912: WHEN OTHERS THEN
5913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5914: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5915: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5916: FND_MSG_PUB.ADD;
5917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5918: END get_search_criteria;
5919:
5920:

Line 5979: FND_MSG_PUB.ADD;

5975: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
5976: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5977: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5978: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5979: FND_MSG_PUB.ADD;
5980: RAISE FND_API.G_EXC_ERROR;
5981: END get_party_rec;
5982:
5983: /************************************************

Line 6045: FND_MSG_PUB.ADD;

6041: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6042: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6043: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6044: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6045: FND_MSG_PUB.ADD;
6046: RAISE FND_API.G_EXC_ERROR;
6047: END get_party_site_rec;
6048:
6049: /************************************************

Line 6101: FND_MSG_PUB.ADD;

6097: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6098: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6099: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6100: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6101: FND_MSG_PUB.ADD;
6102: RAISE FND_API.G_EXC_ERROR;
6103: END get_contact_rec;
6104:
6105: /************************************************

Line 6153: FND_MSG_PUB.ADD;

6149: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6150: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6151: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6152: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6153: FND_MSG_PUB.ADD;
6154: RAISE FND_API.G_EXC_ERROR;
6155: END get_contact_point_rec;
6156:
6157: /************************************************

Line 6275: FND_MSG_PUB.ADD;

6271: WHEN OTHERS THEN
6272: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6273: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6274: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6275: FND_MSG_PUB.ADD;
6276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6277: END;
6278:
6279:

Line 6545: FND_MSG_PUB.ADD;

6541: WHEN OTHERS THEN
6542: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6543: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6544: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6545: FND_MSG_PUB.ADD;
6546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6547: END;
6548:
6549:

Line 6587: FND_MSG_PUB.ADD;

6583: WHEN OTHERS THEN
6584: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6585: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6586: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6587: FND_MSG_PUB.ADD;
6588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6589: END;
6590:
6591:

Line 6654: FND_MSG_PUB.ADD;

6650: WHEN OTHERS THEN
6651: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6652: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6653: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6654: FND_MSG_PUB.ADD;
6655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6656: END;
6657:
6658:

Line 6722: FND_MSG_PUB.ADD;

6718: WHEN OTHERS THEN
6719: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6720: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6722: FND_MSG_PUB.ADD;
6723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6724: END check_prim_cond;
6725:
6726: /************************************************

Line 6778: FND_MSG_PUB.ADD;

6774: WHEN OTHERS THEN
6775: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6776: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6777: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6778: FND_MSG_PUB.ADD;
6779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6780: END check_party_site_cond;
6781:
6782: /************************************************

Line 6816: FND_MSG_PUB.ADD;

6812: WHEN OTHERS THEN
6813: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6814: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6815: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6816: FND_MSG_PUB.ADD;
6817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6818: END check_contact_cond;
6819:
6820: /************************************************

Line 6837: FND_MSG_PUB.ADD;

6833:
6834: FOR I IN 1..p_contact_point_list.COUNT LOOP
6835: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6836: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6837: FND_MSG_PUB.ADD;
6838: RAISE FND_API.G_EXC_ERROR;
6839: END IF;
6840: END LOOP;
6841:

Line 6853: FND_MSG_PUB.ADD;

6849: WHEN OTHERS THEN
6850: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6851: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6852: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6853: FND_MSG_PUB.ADD;
6854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6855: END check_contact_point_cond;
6856:
6857: FUNCTION check_staged RETURN BOOLEAN IS