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.

[Home] [Help]

APPS.HZ_MATCH_RULE_36 dependencies on FND_API

Line 102: RAISE FND_API.G_EXC_ERROR;

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;
106: RAISE FND_API.G_EXC_ERROR;

Line 106: RAISE FND_API.G_EXC_ERROR;

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;
110: END;

Line 108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
110: END;
111:
112:

Line 849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
853: /************************************************

Line 874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
878: /************************************************

Line 894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
898: /************************************************

Line 914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
918: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 981: RAISE FND_API.G_EXC_ERROR;

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);
985: END IF;

Line 1216: RAISE FND_API.G_EXC_ERROR;

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
1220: hz_utility_v2pub.debug(p_message=>'party contains string returned by init_search is an AND between these strings ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 1335: RAISE FND_API.G_EXC_ERROR;

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;
1339: END;

Line 1642: RAISE FND_API.G_EXC_ERROR;

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;
1646: RAISE FND_API.G_EXC_ERROR;

Line 1646: RAISE FND_API.G_EXC_ERROR;

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;
1650: RAISE FND_API.G_EXC_ERROR;

Line 1650: RAISE FND_API.G_EXC_ERROR;

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

Line 1655: RAISE FND_API.G_EXC_UNEXPECTED_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:
1659: PROCEDURE open_party_site_cursor(

Line 1887: RAISE FND_API.G_EXC_ERROR;

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;
1891: RAISE FND_API.G_EXC_ERROR;

Line 1891: RAISE FND_API.G_EXC_ERROR;

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;
1895: RAISE FND_API.G_EXC_ERROR;

Line 1895: RAISE FND_API.G_EXC_ERROR;

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

Line 1900: RAISE FND_API.G_EXC_UNEXPECTED_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:
1904: PROCEDURE open_contact_cursor(

Line 2034: RAISE FND_API.G_EXC_ERROR;

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;
2038: RAISE FND_API.G_EXC_ERROR;

Line 2038: RAISE FND_API.G_EXC_ERROR;

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;
2042: RAISE FND_API.G_EXC_ERROR;

Line 2042: RAISE FND_API.G_EXC_ERROR;

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

Line 2047: RAISE FND_API.G_EXC_UNEXPECTED_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:
2051: PROCEDURE open_contact_pt_cursor(

Line 2307: RAISE FND_API.G_EXC_ERROR;

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;
2311: RAISE FND_API.G_EXC_ERROR;

Line 2311: RAISE FND_API.G_EXC_ERROR;

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;
2315: RAISE FND_API.G_EXC_ERROR;

Line 2315: RAISE FND_API.G_EXC_ERROR;

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

Line 2320: RAISE FND_API.G_EXC_UNEXPECTED_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:
2324:

Line 2579: RAISE FND_API.G_EXC_ERROR;

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;
2583: END IF;

Line 2627: RAISE FND_API.G_EXC_ERROR;

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;
2631: END IF;

Line 2700: RAISE FND_API.G_EXC_ERROR;

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;
2704: END IF;

Line 2812: RAISE FND_API.G_EXC_ERROR;

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;
2816: END IF;

Line 2923: RAISE FND_API.G_EXC_ERROR;

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;
2927: END IF;

Line 3148: RAISE FND_API.G_EXC_ERROR;

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
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);

Line 3156: RAISE FND_API.G_EXC_ERROR;

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
3160: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3355: WHEN FND_API.G_EXC_ERROR THEN

3351: END IF;
3352: EXCEPTION
3353: WHEN L_RETURN_IMM_EXC THEN
3354: RETURN;
3355: WHEN FND_API.G_EXC_ERROR THEN
3356: RAISE FND_API.G_EXC_ERROR;
3357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3359: WHEN OTHERS THEN

Line 3356: RAISE FND_API.G_EXC_ERROR;

3352: EXCEPTION
3353: WHEN L_RETURN_IMM_EXC THEN
3354: RETURN;
3355: WHEN FND_API.G_EXC_ERROR THEN
3356: RAISE FND_API.G_EXC_ERROR;
3357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3359: WHEN OTHERS THEN
3360: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3353: WHEN L_RETURN_IMM_EXC THEN
3354: RETURN;
3355: WHEN FND_API.G_EXC_ERROR THEN
3356: RAISE FND_API.G_EXC_ERROR;
3357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 3358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3354: RETURN;
3355: WHEN FND_API.G_EXC_ERROR THEN
3356: RAISE FND_API.G_EXC_ERROR;
3357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 3364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
3368: p_rule_id IN NUMBER,

Line 3563: RAISE FND_API.G_EXC_ERROR;

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;
3567: END IF;

Line 3611: RAISE FND_API.G_EXC_ERROR;

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;
3615: END IF;

Line 3647: RAISE FND_API.G_EXC_ERROR;

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;
3651: RAISE FND_API.G_EXC_ERROR;

Line 3651: RAISE FND_API.G_EXC_ERROR;

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;
3655: END;

Line 3653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
3655: END;
3656:
3657: /** Private procedure to acquire and score at party site level ***/

Line 3723: RAISE FND_API.G_EXC_ERROR;

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;
3727: END IF;

Line 3982: RAISE FND_API.G_EXC_ERROR;

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;
3986: END IF;

Line 4095: RAISE FND_API.G_EXC_ERROR;

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
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);

Line 4103: RAISE FND_API.G_EXC_ERROR;

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
4107: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4217: WHEN FND_API.G_EXC_ERROR THEN

4213: END IF;
4214: EXCEPTION
4215: WHEN L_RETURN_IMM_EXC THEN
4216: RETURN;
4217: WHEN FND_API.G_EXC_ERROR THEN
4218: RAISE FND_API.G_EXC_ERROR;
4219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4221: WHEN OTHERS THEN

Line 4218: RAISE FND_API.G_EXC_ERROR;

4214: EXCEPTION
4215: WHEN L_RETURN_IMM_EXC THEN
4216: RETURN;
4217: WHEN FND_API.G_EXC_ERROR THEN
4218: RAISE FND_API.G_EXC_ERROR;
4219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4221: WHEN OTHERS THEN
4222: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4215: WHEN L_RETURN_IMM_EXC THEN
4216: RETURN;
4217: WHEN FND_API.G_EXC_ERROR THEN
4218: RAISE FND_API.G_EXC_ERROR;
4219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 4220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4216: RETURN;
4217: WHEN FND_API.G_EXC_ERROR THEN
4218: RAISE FND_API.G_EXC_ERROR;
4219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 4226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
4230: p_rule_id IN NUMBER,

Line 4285: WHEN FND_API.G_EXC_ERROR THEN

4281: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4282: hz_utility_v2pub.debug(p_message=>'find_party_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4283: END IF;
4284: EXCEPTION
4285: WHEN FND_API.G_EXC_ERROR THEN
4286: RAISE FND_API.G_EXC_ERROR;
4287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4289: WHEN OTHERS THEN

Line 4286: RAISE FND_API.G_EXC_ERROR;

4282: hz_utility_v2pub.debug(p_message=>'find_party_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4283: END IF;
4284: EXCEPTION
4285: WHEN FND_API.G_EXC_ERROR THEN
4286: RAISE FND_API.G_EXC_ERROR;
4287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4289: WHEN OTHERS THEN
4290: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4283: END IF;
4284: EXCEPTION
4285: WHEN FND_API.G_EXC_ERROR THEN
4286: RAISE FND_API.G_EXC_ERROR;
4287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 4288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4284: EXCEPTION
4285: WHEN FND_API.G_EXC_ERROR THEN
4286: RAISE FND_API.G_EXC_ERROR;
4287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 4294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
4298: p_rule_id IN NUMBER,

Line 4402: WHEN FND_API.G_EXC_ERROR THEN

4398: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4399: hz_utility_v2pub.debug(p_message=>'find_duplicate_parties(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4400: END IF;
4401: EXCEPTION
4402: WHEN FND_API.G_EXC_ERROR THEN
4403: RAISE FND_API.G_EXC_ERROR;
4404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4406: WHEN OTHERS THEN

Line 4403: RAISE FND_API.G_EXC_ERROR;

4399: hz_utility_v2pub.debug(p_message=>'find_duplicate_parties(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4400: END IF;
4401: EXCEPTION
4402: WHEN FND_API.G_EXC_ERROR THEN
4403: RAISE FND_API.G_EXC_ERROR;
4404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4406: WHEN OTHERS THEN
4407: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4400: END IF;
4401: EXCEPTION
4402: WHEN FND_API.G_EXC_ERROR THEN
4403: RAISE FND_API.G_EXC_ERROR;
4404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 4405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4401: EXCEPTION
4402: WHEN FND_API.G_EXC_ERROR THEN
4403: RAISE FND_API.G_EXC_ERROR;
4404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 4411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
4415: p_rule_id IN NUMBER,

Line 4487: WHEN FND_API.G_EXC_ERROR THEN

4483: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4484: hz_utility_v2pub.debug(p_message=>'find_duplicate_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4485: END IF;
4486: EXCEPTION
4487: WHEN FND_API.G_EXC_ERROR THEN
4488: RAISE FND_API.G_EXC_ERROR;
4489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4491: WHEN OTHERS THEN

Line 4488: RAISE FND_API.G_EXC_ERROR;

4484: hz_utility_v2pub.debug(p_message=>'find_duplicate_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4485: END IF;
4486: EXCEPTION
4487: WHEN FND_API.G_EXC_ERROR THEN
4488: RAISE FND_API.G_EXC_ERROR;
4489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4491: WHEN OTHERS THEN
4492: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4485: END IF;
4486: EXCEPTION
4487: WHEN FND_API.G_EXC_ERROR THEN
4488: RAISE FND_API.G_EXC_ERROR;
4489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 4490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4486: EXCEPTION
4487: WHEN FND_API.G_EXC_ERROR THEN
4488: RAISE FND_API.G_EXC_ERROR;
4489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 4496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
4500: p_rule_id IN NUMBER,

Line 4576: WHEN FND_API.G_EXC_ERROR THEN

4572: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4573: hz_utility_v2pub.debug(p_message=>'find_duplicate_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4574: END IF;
4575: EXCEPTION
4576: WHEN FND_API.G_EXC_ERROR THEN
4577: RAISE FND_API.G_EXC_ERROR;
4578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4580: WHEN OTHERS THEN

Line 4577: RAISE FND_API.G_EXC_ERROR;

4573: hz_utility_v2pub.debug(p_message=>'find_duplicate_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4574: END IF;
4575: EXCEPTION
4576: WHEN FND_API.G_EXC_ERROR THEN
4577: RAISE FND_API.G_EXC_ERROR;
4578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4580: WHEN OTHERS THEN
4581: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4574: END IF;
4575: EXCEPTION
4576: WHEN FND_API.G_EXC_ERROR THEN
4577: RAISE FND_API.G_EXC_ERROR;
4578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 4579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4575: EXCEPTION
4576: WHEN FND_API.G_EXC_ERROR THEN
4577: RAISE FND_API.G_EXC_ERROR;
4578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 4585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
4589: p_rule_id IN NUMBER,

Line 4649: WHEN FND_API.G_EXC_ERROR THEN

4645: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4646: hz_utility_v2pub.debug(p_message=>'find_duplicate_contact_points(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4647: END IF;
4648: EXCEPTION
4649: WHEN FND_API.G_EXC_ERROR THEN
4650: RAISE FND_API.G_EXC_ERROR;
4651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4653: WHEN OTHERS THEN

Line 4650: RAISE FND_API.G_EXC_ERROR;

4646: hz_utility_v2pub.debug(p_message=>'find_duplicate_contact_points(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4647: END IF;
4648: EXCEPTION
4649: WHEN FND_API.G_EXC_ERROR THEN
4650: RAISE FND_API.G_EXC_ERROR;
4651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4653: WHEN OTHERS THEN
4654: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4647: END IF;
4648: EXCEPTION
4649: WHEN FND_API.G_EXC_ERROR THEN
4650: RAISE FND_API.G_EXC_ERROR;
4651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 4652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4648: EXCEPTION
4649: WHEN FND_API.G_EXC_ERROR THEN
4650: RAISE FND_API.G_EXC_ERROR;
4651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 4658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
4662: p_rule_id IN NUMBER,

Line 4951: WHEN FND_API.G_EXC_ERROR THEN

4947: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4948: hz_utility_v2pub.debug(p_message=>'call_api_dynamic(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4949: END IF;
4950: EXCEPTION
4951: WHEN FND_API.G_EXC_ERROR THEN
4952: RAISE FND_API.G_EXC_ERROR;
4953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4955: WHEN OTHERS THEN

Line 4952: RAISE FND_API.G_EXC_ERROR;

4948: hz_utility_v2pub.debug(p_message=>'call_api_dynamic(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
4949: END IF;
4950: EXCEPTION
4951: WHEN FND_API.G_EXC_ERROR THEN
4952: RAISE FND_API.G_EXC_ERROR;
4953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4955: WHEN OTHERS THEN
4956: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4949: END IF;
4950: EXCEPTION
4951: WHEN FND_API.G_EXC_ERROR THEN
4952: RAISE FND_API.G_EXC_ERROR;
4953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 4954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4950: EXCEPTION
4951: WHEN FND_API.G_EXC_ERROR THEN
4952: RAISE FND_API.G_EXC_ERROR;
4953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 4960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
4964: PROCEDURE get_matching_party_sites (

Line 5195: WHEN FND_API.G_EXC_ERROR THEN

5191: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5192: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5193: END IF;
5194: EXCEPTION
5195: WHEN FND_API.G_EXC_ERROR THEN
5196: RAISE FND_API.G_EXC_ERROR;
5197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5199: WHEN OTHERS THEN

Line 5196: RAISE FND_API.G_EXC_ERROR;

5192: hz_utility_v2pub.debug(p_message=>'get_matching_party_sites(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5193: END IF;
5194: EXCEPTION
5195: WHEN FND_API.G_EXC_ERROR THEN
5196: RAISE FND_API.G_EXC_ERROR;
5197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5199: WHEN OTHERS THEN
5200: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5193: END IF;
5194: EXCEPTION
5195: WHEN FND_API.G_EXC_ERROR THEN
5196: RAISE FND_API.G_EXC_ERROR;
5197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 5198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5194: EXCEPTION
5195: WHEN FND_API.G_EXC_ERROR THEN
5196: RAISE FND_API.G_EXC_ERROR;
5197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 5204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
5208: PROCEDURE get_matching_contacts (

Line 5420: WHEN FND_API.G_EXC_ERROR THEN

5416: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5417: hz_utility_v2pub.debug(p_message=>'get_matching_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5418: END IF;
5419: EXCEPTION
5420: WHEN FND_API.G_EXC_ERROR THEN
5421: RAISE FND_API.G_EXC_ERROR;
5422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5424: WHEN OTHERS THEN

Line 5421: RAISE FND_API.G_EXC_ERROR;

5417: hz_utility_v2pub.debug(p_message=>'get_matching_contacts(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5418: END IF;
5419: EXCEPTION
5420: WHEN FND_API.G_EXC_ERROR THEN
5421: RAISE FND_API.G_EXC_ERROR;
5422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5424: WHEN OTHERS THEN
5425: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5418: END IF;
5419: EXCEPTION
5420: WHEN FND_API.G_EXC_ERROR THEN
5421: RAISE FND_API.G_EXC_ERROR;
5422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 5423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5419: EXCEPTION
5420: WHEN FND_API.G_EXC_ERROR THEN
5421: RAISE FND_API.G_EXC_ERROR;
5422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 5429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
5433: PROCEDURE get_matching_contact_points (

Line 5559: WHEN FND_API.G_EXC_ERROR THEN

5555: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5556: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5557: END IF;
5558: EXCEPTION
5559: WHEN FND_API.G_EXC_ERROR THEN
5560: RAISE FND_API.G_EXC_ERROR;
5561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5563: WHEN OTHERS THEN

Line 5560: RAISE FND_API.G_EXC_ERROR;

5556: hz_utility_v2pub.debug(p_message=>'get_matching_contact_points(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5557: END IF;
5558: EXCEPTION
5559: WHEN FND_API.G_EXC_ERROR THEN
5560: RAISE FND_API.G_EXC_ERROR;
5561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5563: WHEN OTHERS THEN
5564: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5557: END IF;
5558: EXCEPTION
5559: WHEN FND_API.G_EXC_ERROR THEN
5560: RAISE FND_API.G_EXC_ERROR;
5561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 5562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5558: EXCEPTION
5559: WHEN FND_API.G_EXC_ERROR THEN
5560: RAISE FND_API.G_EXC_ERROR;
5561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 5568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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: /**********************************************************
5572: This procedure finds the score details for a specific party that

Line 5790: WHEN FND_API.G_EXC_ERROR THEN

5786: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5787: hz_utility_v2pub.debug(p_message=>'get_score_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5788: END IF;
5789: EXCEPTION
5790: WHEN FND_API.G_EXC_ERROR THEN
5791: RAISE FND_API.G_EXC_ERROR;
5792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5794: WHEN OTHERS THEN

Line 5791: RAISE FND_API.G_EXC_ERROR;

5787: hz_utility_v2pub.debug(p_message=>'get_score_details(-) ',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_procedure);
5788: END IF;
5789: EXCEPTION
5790: WHEN FND_API.G_EXC_ERROR THEN
5791: RAISE FND_API.G_EXC_ERROR;
5792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5794: WHEN OTHERS THEN
5795: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5788: END IF;
5789: EXCEPTION
5790: WHEN FND_API.G_EXC_ERROR THEN
5791: RAISE FND_API.G_EXC_ERROR;
5792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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');

Line 5793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5789: EXCEPTION
5790: WHEN FND_API.G_EXC_ERROR THEN
5791: RAISE FND_API.G_EXC_ERROR;
5792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 5799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
5803: /************************************************

Line 5868: WHEN FND_API.G_EXC_ERROR THEN

5864: END LOOP;
5865: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5866: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5867: EXCEPTION
5868: WHEN FND_API.G_EXC_ERROR THEN
5869: RAISE FND_API.G_EXC_ERROR;
5870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5872: WHEN OTHERS THEN

Line 5869: RAISE FND_API.G_EXC_ERROR;

5865: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5866: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5867: EXCEPTION
5868: WHEN FND_API.G_EXC_ERROR THEN
5869: RAISE FND_API.G_EXC_ERROR;
5870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5872: WHEN OTHERS THEN
5873: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5866: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5867: EXCEPTION
5868: WHEN FND_API.G_EXC_ERROR THEN
5869: RAISE FND_API.G_EXC_ERROR;
5870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5872: WHEN OTHERS THEN
5873: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5874: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5867: EXCEPTION
5868: WHEN FND_API.G_EXC_ERROR THEN
5869: RAISE FND_API.G_EXC_ERROR;
5870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 5877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 (
5881: p_party_id IN NUMBER,

Line 5908: WHEN FND_API.G_EXC_ERROR THEN

5904: END IF;
5905: get_party_site_rec(p_party_site_ids, x_party_site_list);
5906: END IF;
5907: EXCEPTION
5908: WHEN FND_API.G_EXC_ERROR THEN
5909: RAISE FND_API.G_EXC_ERROR;
5910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5912: WHEN OTHERS THEN

Line 5909: RAISE FND_API.G_EXC_ERROR;

5905: get_party_site_rec(p_party_site_ids, x_party_site_list);
5906: END IF;
5907: EXCEPTION
5908: WHEN FND_API.G_EXC_ERROR THEN
5909: RAISE FND_API.G_EXC_ERROR;
5910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5912: WHEN OTHERS THEN
5913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5906: END IF;
5907: EXCEPTION
5908: WHEN FND_API.G_EXC_ERROR THEN
5909: RAISE FND_API.G_EXC_ERROR;
5910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5912: WHEN OTHERS THEN
5913: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5914: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5907: EXCEPTION
5908: WHEN FND_API.G_EXC_ERROR THEN
5909: RAISE FND_API.G_EXC_ERROR;
5910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 );

Line 5917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
5921: /************************************************

Line 5980: RAISE FND_API.G_EXC_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: /************************************************
5984: This procedure retrieves the match rule party site attributes into

Line 6046: RAISE FND_API.G_EXC_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: /************************************************
6050: This procedure retrieves the match rule contact attributes into

Line 6102: RAISE FND_API.G_EXC_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: /************************************************
6106: This procedure retrieves the match rule contact point attributes into

Line 6154: RAISE FND_API.G_EXC_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: /************************************************
6158: This procedure maps a search record from the logical

Line 6276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
6280: /************************************************

Line 6546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
6550: /************************************************

Line 6588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
6592: /************************************************

Line 6655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
6659: /************************************************

Line 6716: WHEN FND_API.G_EXC_ERROR THEN

6712: END IF;
6713: END LOOP;
6714: RETURN FALSE;
6715: EXCEPTION
6716: WHEN FND_API.G_EXC_ERROR THEN
6717: RAISE FND_API.G_EXC_ERROR;
6718: WHEN OTHERS THEN
6719: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6720: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6717: RAISE FND_API.G_EXC_ERROR;

6713: END LOOP;
6714: RETURN FALSE;
6715: EXCEPTION
6716: WHEN FND_API.G_EXC_ERROR THEN
6717: RAISE FND_API.G_EXC_ERROR;
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 );

Line 6723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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: /************************************************
6727: This procedure checks if the input search condition

Line 6779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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: /************************************************
6783: This procedure checks if the input search condition

Line 6817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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: /************************************************
6821: This procedure checks if the input search condition

Line 6838: RAISE FND_API.G_EXC_ERROR;

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:
6842: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
6858: