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_58 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 701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

697: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
698: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
699: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
700: FND_MSG_PUB.ADD;
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702: END;
703:
704:
705: /************************************************

Line 721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

717: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
718: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
719: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
720: FND_MSG_PUB.ADD;
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END;
723:
724:
725: /************************************************

Line 741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

737: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
738: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
739: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
740: FND_MSG_PUB.ADD;
741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
742: END;
743:
744:
745: /************************************************

Line 761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

757: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
758: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
759: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
760: FND_MSG_PUB.ADD;
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
762: END;
763:
764: PROCEDURE init_score_context (
765: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 828: RAISE FND_API.G_EXC_ERROR;

824: p_contact_list,
825: p_contact_point_list) THEN
826: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
827: FND_MSG_PUB.ADD;
828: RAISE FND_API.G_EXC_ERROR;
829: END IF;
830: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
831: 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);
832: END IF;

Line 1097: RAISE FND_API.G_EXC_ERROR;

1093: IF lengthb(l_party_contains_str) > 4000 THEN
1094: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1095: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1096: FND_MSG_PUB.ADD;
1097: RAISE FND_API.G_EXC_ERROR;
1098: END IF;
1099: IF (p_match_str = ' AND ' OR p_party_max_score 1100: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1101: 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 1175: RAISE FND_API.G_EXC_ERROR;

1171: IF lengthb(l_contains_str) > 4000 THEN
1172: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1173: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1174: FND_MSG_PUB.ADD;
1175: RAISE FND_API.G_EXC_ERROR;
1176: END IF;
1177: x_denorm_str := l_den_contains_str;
1178: RETURN l_contains_str;
1179: END;

Line 1256: RAISE FND_API.G_EXC_ERROR;

1252: IF lengthb(l_contains_str) > 4000 THEN
1253: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1254: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1255: FND_MSG_PUB.ADD;
1256: RAISE FND_API.G_EXC_ERROR;
1257: END IF;
1258: x_denorm_str := l_den_contains_str;
1259: RETURN l_contains_str;
1260: END;

Line 1491: RAISE FND_API.G_EXC_ERROR;

1487: when others then
1488: if (instrb(SQLERRM,'DRG-51030')>0) then
1489: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1490: FND_MSG_PUB.ADD;
1491: RAISE FND_API.G_EXC_ERROR;
1492: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1493: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1494: FND_MSG_PUB.ADD;
1495: RAISE FND_API.G_EXC_ERROR;

Line 1495: RAISE FND_API.G_EXC_ERROR;

1491: RAISE FND_API.G_EXC_ERROR;
1492: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1493: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1494: FND_MSG_PUB.ADD;
1495: RAISE FND_API.G_EXC_ERROR;
1496: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1498: FND_MSG_PUB.ADD;
1499: RAISE FND_API.G_EXC_ERROR;

Line 1499: RAISE FND_API.G_EXC_ERROR;

1495: RAISE FND_API.G_EXC_ERROR;
1496: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1498: FND_MSG_PUB.ADD;
1499: RAISE FND_API.G_EXC_ERROR;
1500: else
1501: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1502: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1503: FND_MSG_PUB.ADD;

Line 1504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1500: else
1501: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1502: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1503: FND_MSG_PUB.ADD;
1504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1505: end if;
1506: END;
1507:
1508: PROCEDURE open_party_site_cursor(

Line 1736: RAISE FND_API.G_EXC_ERROR;

1732: when others then
1733: if (instrb(SQLERRM,'DRG-51030')>0) then
1734: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1735: FND_MSG_PUB.ADD;
1736: RAISE FND_API.G_EXC_ERROR;
1737: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1739: FND_MSG_PUB.ADD;
1740: RAISE FND_API.G_EXC_ERROR;

Line 1740: RAISE FND_API.G_EXC_ERROR;

1736: RAISE FND_API.G_EXC_ERROR;
1737: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1738: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1739: FND_MSG_PUB.ADD;
1740: RAISE FND_API.G_EXC_ERROR;
1741: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1742: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1743: FND_MSG_PUB.ADD;
1744: RAISE FND_API.G_EXC_ERROR;

Line 1744: RAISE FND_API.G_EXC_ERROR;

1740: RAISE FND_API.G_EXC_ERROR;
1741: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1742: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1743: FND_MSG_PUB.ADD;
1744: RAISE FND_API.G_EXC_ERROR;
1745: else
1746: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1747: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1748: FND_MSG_PUB.ADD;

Line 1749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1745: else
1746: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1747: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1748: FND_MSG_PUB.ADD;
1749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1750: end if;
1751: END;
1752:
1753: PROCEDURE open_contact_cursor(

Line 1883: RAISE FND_API.G_EXC_ERROR;

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

Line 1887: RAISE FND_API.G_EXC_ERROR;

1883: RAISE FND_API.G_EXC_ERROR;
1884: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1885: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1886: FND_MSG_PUB.ADD;
1887: RAISE FND_API.G_EXC_ERROR;
1888: elsif (instrb(SQLERRM,'ORA-20000')>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,'ORA-20000')>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: else
1893: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1894: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1895: FND_MSG_PUB.ADD;

Line 1896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1892: else
1893: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1894: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1895: FND_MSG_PUB.ADD;
1896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1897: end if;
1898: END;
1899:
1900: PROCEDURE open_contact_pt_cursor(

Line 2156: RAISE FND_API.G_EXC_ERROR;

2152: when others then
2153: if (instrb(SQLERRM,'DRG-51030')>0) then
2154: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2155: FND_MSG_PUB.ADD;
2156: RAISE FND_API.G_EXC_ERROR;
2157: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2159: FND_MSG_PUB.ADD;
2160: RAISE FND_API.G_EXC_ERROR;

Line 2160: RAISE FND_API.G_EXC_ERROR;

2156: RAISE FND_API.G_EXC_ERROR;
2157: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2159: FND_MSG_PUB.ADD;
2160: RAISE FND_API.G_EXC_ERROR;
2161: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2163: FND_MSG_PUB.ADD;
2164: RAISE FND_API.G_EXC_ERROR;

Line 2164: RAISE FND_API.G_EXC_ERROR;

2160: RAISE FND_API.G_EXC_ERROR;
2161: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2163: FND_MSG_PUB.ADD;
2164: RAISE FND_API.G_EXC_ERROR;
2165: else
2166: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2167: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2168: FND_MSG_PUB.ADD;

Line 2169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2165: else
2166: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2167: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2168: FND_MSG_PUB.ADD;
2169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2170: end if;
2171: END;
2172:
2173:

Line 2422: RAISE FND_API.G_EXC_ERROR;

2418: 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);
2419: END IF;
2420: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2421: FND_MSG_PUB.ADD;
2422: RAISE FND_API.G_EXC_ERROR;
2423: ELSE
2424: push_eval;
2425: RETURN;
2426: END IF;

Line 2472: RAISE FND_API.G_EXC_ERROR;

2468: 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);
2469: END IF;
2470: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2471: FND_MSG_PUB.ADD;
2472: RAISE FND_API.G_EXC_ERROR;
2473: ELSE
2474: push_eval;
2475: RETURN;
2476: END IF;

Line 2545: RAISE FND_API.G_EXC_ERROR;

2541: 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);
2542: END IF;
2543: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2544: FND_MSG_PUB.ADD;
2545: RAISE FND_API.G_EXC_ERROR;
2546: ELSE
2547: push_eval;
2548: RETURN;
2549: END IF;

Line 2657: RAISE FND_API.G_EXC_ERROR;

2653: 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);
2654: END IF;
2655: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2656: FND_MSG_PUB.ADD;
2657: RAISE FND_API.G_EXC_ERROR;
2658: ELSE
2659: push_eval;
2660: RETURN;
2661: END IF;

Line 2768: RAISE FND_API.G_EXC_ERROR;

2764: 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);
2765: END IF;
2766: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2767: FND_MSG_PUB.ADD;
2768: RAISE FND_API.G_EXC_ERROR;
2769: ELSE
2770: push_eval;
2771: RETURN;
2772: END IF;

Line 2993: RAISE FND_API.G_EXC_ERROR;

2989: 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);
2990: END IF;
2991: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2992: FND_MSG_PUB.ADD;
2993: RAISE FND_API.G_EXC_ERROR;
2994: END IF;
2995: ELSE
2996: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2997: 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 3001: RAISE FND_API.G_EXC_ERROR;

2997: 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);
2998: END IF;
2999: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3000: FND_MSG_PUB.ADD;
3001: RAISE FND_API.G_EXC_ERROR;
3002: END IF;
3003: END IF;
3004: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3005: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3200: WHEN FND_API.G_EXC_ERROR THEN

3196: END IF;
3197: EXCEPTION
3198: WHEN L_RETURN_IMM_EXC THEN
3199: RETURN;
3200: WHEN FND_API.G_EXC_ERROR THEN
3201: RAISE FND_API.G_EXC_ERROR;
3202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3204: WHEN OTHERS THEN

Line 3201: RAISE FND_API.G_EXC_ERROR;

3197: EXCEPTION
3198: WHEN L_RETURN_IMM_EXC THEN
3199: RETURN;
3200: WHEN FND_API.G_EXC_ERROR THEN
3201: RAISE FND_API.G_EXC_ERROR;
3202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3204: WHEN OTHERS THEN
3205: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3198: WHEN L_RETURN_IMM_EXC THEN
3199: RETURN;
3200: WHEN FND_API.G_EXC_ERROR THEN
3201: RAISE FND_API.G_EXC_ERROR;
3202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3204: WHEN OTHERS THEN
3205: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3206: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_parties');

Line 3203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3199: RETURN;
3200: WHEN FND_API.G_EXC_ERROR THEN
3201: RAISE FND_API.G_EXC_ERROR;
3202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3204: WHEN OTHERS THEN
3205: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3206: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_parties');
3207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3205: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3206: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_parties');
3207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3208: FND_MSG_PUB.ADD;
3209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3210: END find_parties;
3211:
3212: PROCEDURE find_persons (
3213: p_rule_id IN NUMBER,

Line 3402: RAISE FND_API.G_EXC_ERROR;

3398: 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);
3399: END IF;
3400: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3401: FND_MSG_PUB.ADD;
3402: RAISE FND_API.G_EXC_ERROR;
3403: ELSE
3404: push_eval;
3405: RETURN;
3406: END IF;

Line 3452: RAISE FND_API.G_EXC_ERROR;

3448: 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);
3449: END IF;
3450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3451: FND_MSG_PUB.ADD;
3452: RAISE FND_API.G_EXC_ERROR;
3453: ELSE
3454: push_eval;
3455: RETURN;
3456: END IF;

Line 3488: RAISE FND_API.G_EXC_ERROR;

3484: when others then
3485: if (instrb(SQLERRM,'DRG-51030')>0) then
3486: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3487: FND_MSG_PUB.ADD;
3488: RAISE FND_API.G_EXC_ERROR;
3489: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3490: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3491: FND_MSG_PUB.ADD;
3492: RAISE FND_API.G_EXC_ERROR;

Line 3492: RAISE FND_API.G_EXC_ERROR;

3488: RAISE FND_API.G_EXC_ERROR;
3489: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3490: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3491: FND_MSG_PUB.ADD;
3492: RAISE FND_API.G_EXC_ERROR;
3493: else
3494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3495: end if;
3496: END;

Line 3494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3490: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3491: FND_MSG_PUB.ADD;
3492: RAISE FND_API.G_EXC_ERROR;
3493: else
3494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3495: end if;
3496: END;
3497:
3498: /** Private procedure to acquire and score at party site level ***/

Line 3564: RAISE FND_API.G_EXC_ERROR;

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

Line 3823: RAISE FND_API.G_EXC_ERROR;

3819: 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);
3820: END IF;
3821: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3822: FND_MSG_PUB.ADD;
3823: RAISE FND_API.G_EXC_ERROR;
3824: ELSE
3825: push_eval;
3826: RETURN;
3827: END IF;

Line 3936: RAISE FND_API.G_EXC_ERROR;

3932: 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);
3933: END IF;
3934: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3935: FND_MSG_PUB.ADD;
3936: RAISE FND_API.G_EXC_ERROR;
3937: END IF;
3938: ELSE
3939: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3940: 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 3944: RAISE FND_API.G_EXC_ERROR;

3940: 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);
3941: END IF;
3942: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3943: FND_MSG_PUB.ADD;
3944: RAISE FND_API.G_EXC_ERROR;
3945: END IF;
3946: END IF;
3947: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3948: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4058: WHEN FND_API.G_EXC_ERROR THEN

4054: END IF;
4055: EXCEPTION
4056: WHEN L_RETURN_IMM_EXC THEN
4057: RETURN;
4058: WHEN FND_API.G_EXC_ERROR THEN
4059: RAISE FND_API.G_EXC_ERROR;
4060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4062: WHEN OTHERS THEN

Line 4059: RAISE FND_API.G_EXC_ERROR;

4055: EXCEPTION
4056: WHEN L_RETURN_IMM_EXC THEN
4057: RETURN;
4058: WHEN FND_API.G_EXC_ERROR THEN
4059: RAISE FND_API.G_EXC_ERROR;
4060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4062: WHEN OTHERS THEN
4063: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4056: WHEN L_RETURN_IMM_EXC THEN
4057: RETURN;
4058: WHEN FND_API.G_EXC_ERROR THEN
4059: RAISE FND_API.G_EXC_ERROR;
4060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4062: WHEN OTHERS THEN
4063: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4064: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_persons');

Line 4061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4057: RETURN;
4058: WHEN FND_API.G_EXC_ERROR THEN
4059: RAISE FND_API.G_EXC_ERROR;
4060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4062: WHEN OTHERS THEN
4063: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4064: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_persons');
4065: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4063: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4064: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_persons');
4065: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4066: FND_MSG_PUB.ADD;
4067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4068: END find_persons;
4069:
4070: PROCEDURE find_persons (
4071: p_rule_id IN NUMBER,

Line 4126: WHEN FND_API.G_EXC_ERROR THEN

4122: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4123: 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);
4124: END IF;
4125: EXCEPTION
4126: WHEN FND_API.G_EXC_ERROR THEN
4127: RAISE FND_API.G_EXC_ERROR;
4128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4130: WHEN OTHERS THEN

Line 4127: RAISE FND_API.G_EXC_ERROR;

4123: 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);
4124: END IF;
4125: EXCEPTION
4126: WHEN FND_API.G_EXC_ERROR THEN
4127: RAISE FND_API.G_EXC_ERROR;
4128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4130: WHEN OTHERS THEN
4131: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4124: END IF;
4125: EXCEPTION
4126: WHEN FND_API.G_EXC_ERROR THEN
4127: RAISE FND_API.G_EXC_ERROR;
4128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4130: WHEN OTHERS THEN
4131: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4132: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_party_details');

Line 4129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4125: EXCEPTION
4126: WHEN FND_API.G_EXC_ERROR THEN
4127: RAISE FND_API.G_EXC_ERROR;
4128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4130: WHEN OTHERS THEN
4131: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4132: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_party_details');
4133: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4131: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4132: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_party_details');
4133: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4134: FND_MSG_PUB.ADD;
4135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4136: END find_party_details;
4137:
4138: PROCEDURE find_duplicate_parties (
4139: p_rule_id IN NUMBER,

Line 4243: WHEN FND_API.G_EXC_ERROR THEN

4239: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4240: 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);
4241: END IF;
4242: EXCEPTION
4243: WHEN FND_API.G_EXC_ERROR THEN
4244: RAISE FND_API.G_EXC_ERROR;
4245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4247: WHEN OTHERS THEN

Line 4244: RAISE FND_API.G_EXC_ERROR;

4240: 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);
4241: END IF;
4242: EXCEPTION
4243: WHEN FND_API.G_EXC_ERROR THEN
4244: RAISE FND_API.G_EXC_ERROR;
4245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4247: WHEN OTHERS THEN
4248: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4241: END IF;
4242: EXCEPTION
4243: WHEN FND_API.G_EXC_ERROR THEN
4244: RAISE FND_API.G_EXC_ERROR;
4245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4247: WHEN OTHERS THEN
4248: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4249: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_parties');

Line 4246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4242: EXCEPTION
4243: WHEN FND_API.G_EXC_ERROR THEN
4244: RAISE FND_API.G_EXC_ERROR;
4245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4247: WHEN OTHERS THEN
4248: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4249: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_parties');
4250: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4248: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4249: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_parties');
4250: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4251: FND_MSG_PUB.ADD;
4252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4253: END find_duplicate_parties;
4254:
4255: PROCEDURE find_duplicate_party_sites (
4256: p_rule_id IN NUMBER,

Line 4328: WHEN FND_API.G_EXC_ERROR THEN

4324: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4325: 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);
4326: END IF;
4327: EXCEPTION
4328: WHEN FND_API.G_EXC_ERROR THEN
4329: RAISE FND_API.G_EXC_ERROR;
4330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4332: WHEN OTHERS THEN

Line 4329: RAISE FND_API.G_EXC_ERROR;

4325: 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);
4326: END IF;
4327: EXCEPTION
4328: WHEN FND_API.G_EXC_ERROR THEN
4329: RAISE FND_API.G_EXC_ERROR;
4330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4332: WHEN OTHERS THEN
4333: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4326: END IF;
4327: EXCEPTION
4328: WHEN FND_API.G_EXC_ERROR THEN
4329: RAISE FND_API.G_EXC_ERROR;
4330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4332: WHEN OTHERS THEN
4333: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4334: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_party_sites');

Line 4331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4327: EXCEPTION
4328: WHEN FND_API.G_EXC_ERROR THEN
4329: RAISE FND_API.G_EXC_ERROR;
4330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4332: WHEN OTHERS THEN
4333: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4334: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_party_sites');
4335: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4333: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4334: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_party_sites');
4335: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4336: FND_MSG_PUB.ADD;
4337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4338: END find_duplicate_party_sites;
4339:
4340: PROCEDURE find_duplicate_contacts (
4341: p_rule_id IN NUMBER,

Line 4417: WHEN FND_API.G_EXC_ERROR THEN

4413: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4414: 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);
4415: END IF;
4416: EXCEPTION
4417: WHEN FND_API.G_EXC_ERROR THEN
4418: RAISE FND_API.G_EXC_ERROR;
4419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4421: WHEN OTHERS THEN

Line 4418: RAISE FND_API.G_EXC_ERROR;

4414: 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);
4415: END IF;
4416: EXCEPTION
4417: WHEN FND_API.G_EXC_ERROR THEN
4418: RAISE FND_API.G_EXC_ERROR;
4419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4421: WHEN OTHERS THEN
4422: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4415: END IF;
4416: EXCEPTION
4417: WHEN FND_API.G_EXC_ERROR THEN
4418: RAISE FND_API.G_EXC_ERROR;
4419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4421: WHEN OTHERS THEN
4422: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4423: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contacts');

Line 4420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4416: EXCEPTION
4417: WHEN FND_API.G_EXC_ERROR THEN
4418: RAISE FND_API.G_EXC_ERROR;
4419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4421: WHEN OTHERS THEN
4422: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4423: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contacts');
4424: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4422: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4423: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contacts');
4424: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4425: FND_MSG_PUB.ADD;
4426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4427: END find_duplicate_contacts;
4428:
4429: PROCEDURE find_duplicate_contact_points (
4430: p_rule_id IN NUMBER,

Line 4490: WHEN FND_API.G_EXC_ERROR THEN

4486: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4487: 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);
4488: END IF;
4489: EXCEPTION
4490: WHEN FND_API.G_EXC_ERROR THEN
4491: RAISE FND_API.G_EXC_ERROR;
4492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4494: WHEN OTHERS THEN

Line 4491: RAISE FND_API.G_EXC_ERROR;

4487: 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);
4488: END IF;
4489: EXCEPTION
4490: WHEN FND_API.G_EXC_ERROR THEN
4491: RAISE FND_API.G_EXC_ERROR;
4492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4494: WHEN OTHERS THEN
4495: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4488: END IF;
4489: EXCEPTION
4490: WHEN FND_API.G_EXC_ERROR THEN
4491: RAISE FND_API.G_EXC_ERROR;
4492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4494: WHEN OTHERS THEN
4495: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4496: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contact_points');

Line 4493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4489: EXCEPTION
4490: WHEN FND_API.G_EXC_ERROR THEN
4491: RAISE FND_API.G_EXC_ERROR;
4492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4494: WHEN OTHERS THEN
4495: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4496: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contact_points');
4497: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4495: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4496: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.find_duplicate_contact_points');
4497: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4498: FND_MSG_PUB.ADD;
4499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4500: END find_duplicate_contact_points;
4501:
4502: PROCEDURE find_parties_dynamic (
4503: p_rule_id IN NUMBER,

Line 4805: WHEN FND_API.G_EXC_ERROR THEN

4801: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4802: 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);
4803: END IF;
4804: EXCEPTION
4805: WHEN FND_API.G_EXC_ERROR THEN
4806: RAISE FND_API.G_EXC_ERROR;
4807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4809: WHEN OTHERS THEN

Line 4806: RAISE FND_API.G_EXC_ERROR;

4802: 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);
4803: END IF;
4804: EXCEPTION
4805: WHEN FND_API.G_EXC_ERROR THEN
4806: RAISE FND_API.G_EXC_ERROR;
4807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4809: WHEN OTHERS THEN
4810: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4803: END IF;
4804: EXCEPTION
4805: WHEN FND_API.G_EXC_ERROR THEN
4806: RAISE FND_API.G_EXC_ERROR;
4807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4809: WHEN OTHERS THEN
4810: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4811: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.call_api_dynamic');

Line 4808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4804: EXCEPTION
4805: WHEN FND_API.G_EXC_ERROR THEN
4806: RAISE FND_API.G_EXC_ERROR;
4807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4809: WHEN OTHERS THEN
4810: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4811: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.call_api_dynamic');
4812: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4810: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4811: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.call_api_dynamic');
4812: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4813: FND_MSG_PUB.ADD;
4814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4815: END call_api_dynamic;
4816:
4817:
4818: PROCEDURE get_matching_party_sites (

Line 5040: WHEN FND_API.G_EXC_ERROR THEN

5036: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5037: 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);
5038: END IF;
5039: EXCEPTION
5040: WHEN FND_API.G_EXC_ERROR THEN
5041: RAISE FND_API.G_EXC_ERROR;
5042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5044: WHEN OTHERS THEN

Line 5041: RAISE FND_API.G_EXC_ERROR;

5037: 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);
5038: END IF;
5039: EXCEPTION
5040: WHEN FND_API.G_EXC_ERROR THEN
5041: RAISE FND_API.G_EXC_ERROR;
5042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5044: WHEN OTHERS THEN
5045: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5038: END IF;
5039: EXCEPTION
5040: WHEN FND_API.G_EXC_ERROR THEN
5041: RAISE FND_API.G_EXC_ERROR;
5042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5044: WHEN OTHERS THEN
5045: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5046: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_party_sites');

Line 5043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5039: EXCEPTION
5040: WHEN FND_API.G_EXC_ERROR THEN
5041: RAISE FND_API.G_EXC_ERROR;
5042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5044: WHEN OTHERS THEN
5045: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5046: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_party_sites');
5047: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5045: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5046: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_party_sites');
5047: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5048: FND_MSG_PUB.ADD;
5049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5050: END get_matching_party_sites;
5051:
5052:
5053: PROCEDURE get_matching_contacts (

Line 5269: WHEN FND_API.G_EXC_ERROR THEN

5265: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5266: 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);
5267: END IF;
5268: EXCEPTION
5269: WHEN FND_API.G_EXC_ERROR THEN
5270: RAISE FND_API.G_EXC_ERROR;
5271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5273: WHEN OTHERS THEN

Line 5270: RAISE FND_API.G_EXC_ERROR;

5266: 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);
5267: END IF;
5268: EXCEPTION
5269: WHEN FND_API.G_EXC_ERROR THEN
5270: RAISE FND_API.G_EXC_ERROR;
5271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5273: WHEN OTHERS THEN
5274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5267: END IF;
5268: EXCEPTION
5269: WHEN FND_API.G_EXC_ERROR THEN
5270: RAISE FND_API.G_EXC_ERROR;
5271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5273: WHEN OTHERS THEN
5274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5275: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contacts');

Line 5272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5268: EXCEPTION
5269: WHEN FND_API.G_EXC_ERROR THEN
5270: RAISE FND_API.G_EXC_ERROR;
5271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5273: WHEN OTHERS THEN
5274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5275: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contacts');
5276: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5274: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5275: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contacts');
5276: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5277: FND_MSG_PUB.ADD;
5278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5279: END get_matching_contacts;
5280:
5281:
5282: PROCEDURE get_matching_contact_points (

Line 5411: WHEN FND_API.G_EXC_ERROR THEN

5407: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5408: 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);
5409: END IF;
5410: EXCEPTION
5411: WHEN FND_API.G_EXC_ERROR THEN
5412: RAISE FND_API.G_EXC_ERROR;
5413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5415: WHEN OTHERS THEN

Line 5412: RAISE FND_API.G_EXC_ERROR;

5408: 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);
5409: END IF;
5410: EXCEPTION
5411: WHEN FND_API.G_EXC_ERROR THEN
5412: RAISE FND_API.G_EXC_ERROR;
5413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5415: WHEN OTHERS THEN
5416: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5409: END IF;
5410: EXCEPTION
5411: WHEN FND_API.G_EXC_ERROR THEN
5412: RAISE FND_API.G_EXC_ERROR;
5413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5415: WHEN OTHERS THEN
5416: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5417: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contact_points');

Line 5414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5410: EXCEPTION
5411: WHEN FND_API.G_EXC_ERROR THEN
5412: RAISE FND_API.G_EXC_ERROR;
5413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5415: WHEN OTHERS THEN
5416: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5417: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contact_points');
5418: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5416: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5417: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_matching_contact_points');
5418: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5419: FND_MSG_PUB.ADD;
5420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5421: END get_matching_contact_points;
5422:
5423: /**********************************************************
5424: This procedure finds the score details for a specific party that

Line 5624: WHEN FND_API.G_EXC_ERROR THEN

5620: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5621: 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);
5622: END IF;
5623: EXCEPTION
5624: WHEN FND_API.G_EXC_ERROR THEN
5625: RAISE FND_API.G_EXC_ERROR;
5626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5628: WHEN OTHERS THEN

Line 5625: RAISE FND_API.G_EXC_ERROR;

5621: 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);
5622: END IF;
5623: EXCEPTION
5624: WHEN FND_API.G_EXC_ERROR THEN
5625: RAISE FND_API.G_EXC_ERROR;
5626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5628: WHEN OTHERS THEN
5629: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5622: END IF;
5623: EXCEPTION
5624: WHEN FND_API.G_EXC_ERROR THEN
5625: RAISE FND_API.G_EXC_ERROR;
5626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5628: WHEN OTHERS THEN
5629: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5630: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_score_details');

Line 5627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5623: EXCEPTION
5624: WHEN FND_API.G_EXC_ERROR THEN
5625: RAISE FND_API.G_EXC_ERROR;
5626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5628: WHEN OTHERS THEN
5629: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5630: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_score_details');
5631: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5629: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5630: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_58.get_score_details');
5631: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5632: FND_MSG_PUB.ADD;
5633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5634: END get_score_details;
5635:
5636:
5637: /************************************************

Line 5712: WHEN FND_API.G_EXC_ERROR THEN

5708: END LOOP;
5709: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5710: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5711: EXCEPTION
5712: WHEN FND_API.G_EXC_ERROR THEN
5713: RAISE FND_API.G_EXC_ERROR;
5714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5716: WHEN OTHERS THEN

Line 5713: RAISE FND_API.G_EXC_ERROR;

5709: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5710: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5711: EXCEPTION
5712: WHEN FND_API.G_EXC_ERROR THEN
5713: RAISE FND_API.G_EXC_ERROR;
5714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5716: WHEN OTHERS THEN
5717: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5710: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5711: EXCEPTION
5712: WHEN FND_API.G_EXC_ERROR THEN
5713: RAISE FND_API.G_EXC_ERROR;
5714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5716: WHEN OTHERS THEN
5717: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5718: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5711: EXCEPTION
5712: WHEN FND_API.G_EXC_ERROR THEN
5713: RAISE FND_API.G_EXC_ERROR;
5714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5716: WHEN OTHERS THEN
5717: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5718: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5719: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5717: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5718: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5719: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5720: FND_MSG_PUB.ADD;
5721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5722: END get_party_for_search;
5723:
5724: PROCEDURE get_search_criteria (
5725: p_party_id IN NUMBER,

Line 5758: WHEN FND_API.G_EXC_ERROR THEN

5754: END IF;
5755: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5756: END IF;
5757: EXCEPTION
5758: WHEN FND_API.G_EXC_ERROR THEN
5759: RAISE FND_API.G_EXC_ERROR;
5760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5762: WHEN OTHERS THEN

Line 5759: RAISE FND_API.G_EXC_ERROR;

5755: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5756: END IF;
5757: EXCEPTION
5758: WHEN FND_API.G_EXC_ERROR THEN
5759: RAISE FND_API.G_EXC_ERROR;
5760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5762: WHEN OTHERS THEN
5763: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5756: END IF;
5757: EXCEPTION
5758: WHEN FND_API.G_EXC_ERROR THEN
5759: RAISE FND_API.G_EXC_ERROR;
5760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5762: WHEN OTHERS THEN
5763: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5764: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5757: EXCEPTION
5758: WHEN FND_API.G_EXC_ERROR THEN
5759: RAISE FND_API.G_EXC_ERROR;
5760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5762: WHEN OTHERS THEN
5763: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5764: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5765: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5763: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5764: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5765: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5766: FND_MSG_PUB.ADD;
5767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5768: END get_search_criteria;
5769:
5770:
5771: /************************************************

Line 5832: RAISE FND_API.G_EXC_ERROR;

5828: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5829: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5830: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5831: FND_MSG_PUB.ADD;
5832: RAISE FND_API.G_EXC_ERROR;
5833: END get_party_rec;
5834:
5835: /************************************************
5836: This procedure retrieves the match rule party site attributes into

Line 5884: RAISE FND_API.G_EXC_ERROR;

5880: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5881: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5882: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5883: FND_MSG_PUB.ADD;
5884: RAISE FND_API.G_EXC_ERROR;
5885: END get_party_site_rec;
5886:
5887: /************************************************
5888: This procedure retrieves the match rule contact attributes into

Line 5942: RAISE FND_API.G_EXC_ERROR;

5938: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5939: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5940: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5941: FND_MSG_PUB.ADD;
5942: RAISE FND_API.G_EXC_ERROR;
5943: END get_contact_rec;
5944:
5945: /************************************************
5946: This procedure retrieves the match rule contact point attributes into

Line 5998: RAISE FND_API.G_EXC_ERROR;

5994: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5995: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5996: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5997: FND_MSG_PUB.ADD;
5998: RAISE FND_API.G_EXC_ERROR;
5999: END get_contact_point_rec;
6000:
6001: /************************************************
6002: This procedure maps a search record from the logical

Line 6172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6168: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6169: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6170: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6171: FND_MSG_PUB.ADD;
6172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6173: END;
6174:
6175:
6176: /************************************************

Line 6215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6211: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6212: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6213: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6214: FND_MSG_PUB.ADD;
6215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6216: END;
6217:
6218:
6219: /************************************************

Line 6272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6268: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6269: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6270: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6271: FND_MSG_PUB.ADD;
6272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6273: END;
6274:
6275:
6276: /************************************************

Line 6403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6399: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6400: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6401: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6402: FND_MSG_PUB.ADD;
6403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6404: END;
6405:
6406:
6407: /************************************************

Line 6428: RAISE FND_API.G_EXC_ERROR;

6424: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
6425: ) THEN
6426: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6427: FND_MSG_PUB.ADD;
6428: RAISE FND_API.G_EXC_ERROR;
6429: END IF;
6430: END LOOP;
6431:
6432: IF p_party_search_rec.PARTY_NUMBER IS NOT NULL THEN

Line 6461: WHEN FND_API.G_EXC_ERROR THEN

6457: END IF;
6458: END LOOP;
6459: RETURN FALSE;
6460: EXCEPTION
6461: WHEN FND_API.G_EXC_ERROR THEN
6462: RAISE FND_API.G_EXC_ERROR;
6463: WHEN OTHERS THEN
6464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6465: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6462: RAISE FND_API.G_EXC_ERROR;

6458: END LOOP;
6459: RETURN FALSE;
6460: EXCEPTION
6461: WHEN FND_API.G_EXC_ERROR THEN
6462: RAISE FND_API.G_EXC_ERROR;
6463: WHEN OTHERS THEN
6464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6465: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6464: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6465: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6466: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6467: FND_MSG_PUB.ADD;
6468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6469: END check_prim_cond;
6470:
6471: /************************************************
6472: This procedure checks if the input search condition

Line 6514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6510: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6511: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6512: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6513: FND_MSG_PUB.ADD;
6514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6515: END check_party_site_cond;
6516:
6517: /************************************************
6518: This procedure checks if the input search condition

Line 6570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6566: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6567: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6568: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6569: FND_MSG_PUB.ADD;
6570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6571: END check_contact_cond;
6572:
6573: /************************************************
6574: This procedure checks if the input search condition

Line 6591: RAISE FND_API.G_EXC_ERROR;

6587: FOR I IN 1..p_contact_point_list.COUNT LOOP
6588: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6589: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6590: FND_MSG_PUB.ADD;
6591: RAISE FND_API.G_EXC_ERROR;
6592: END IF;
6593: END LOOP;
6594:
6595: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6613: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6614: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6615: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6616: FND_MSG_PUB.ADD;
6617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6618: END check_contact_point_cond;
6619:
6620: FUNCTION check_staged RETURN BOOLEAN IS
6621: