eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MATCH_RULE_3 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 497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

493: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
494: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
495: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
496: FND_MSG_PUB.ADD;
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END;
499:
500:
501: /************************************************

Line 517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

513: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
514: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
516: FND_MSG_PUB.ADD;
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END;
519:
520:
521: /************************************************

Line 537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

533: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
534: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
535: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
536: FND_MSG_PUB.ADD;
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
538: END;
539:
540:
541: /************************************************

Line 557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

553: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
554: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
555: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
556: FND_MSG_PUB.ADD;
557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
558: END;
559:
560: PROCEDURE init_score_context (
561: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 624: RAISE FND_API.G_EXC_ERROR;

620: p_contact_list,
621: p_contact_point_list) THEN
622: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
623: FND_MSG_PUB.ADD;
624: RAISE FND_API.G_EXC_ERROR;
625: END IF;
626: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
627: 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);
628: END IF;

Line 842: RAISE FND_API.G_EXC_ERROR;

838: IF lengthb(l_party_contains_str) > 4000 THEN
839: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
840: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
841: FND_MSG_PUB.ADD;
842: RAISE FND_API.G_EXC_ERROR;
843: END IF;
844: IF (p_match_str = ' AND ' OR p_party_max_score 845: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
846: 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 941: RAISE FND_API.G_EXC_ERROR;

937: IF lengthb(l_contains_str) > 4000 THEN
938: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
939: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
940: FND_MSG_PUB.ADD;
941: RAISE FND_API.G_EXC_ERROR;
942: END IF;
943: x_denorm_str := l_den_contains_str;
944: RETURN l_contains_str;
945: END;

Line 1160: RAISE FND_API.G_EXC_ERROR;

1156: when others then
1157: if (instrb(SQLERRM,'DRG-51030')>0) then
1158: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1159: FND_MSG_PUB.ADD;
1160: RAISE FND_API.G_EXC_ERROR;
1161: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1163: FND_MSG_PUB.ADD;
1164: RAISE FND_API.G_EXC_ERROR;

Line 1164: RAISE FND_API.G_EXC_ERROR;

1160: RAISE FND_API.G_EXC_ERROR;
1161: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1162: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1163: FND_MSG_PUB.ADD;
1164: RAISE FND_API.G_EXC_ERROR;
1165: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1166: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1167: FND_MSG_PUB.ADD;
1168: RAISE FND_API.G_EXC_ERROR;

Line 1168: RAISE FND_API.G_EXC_ERROR;

1164: RAISE FND_API.G_EXC_ERROR;
1165: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1166: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1167: FND_MSG_PUB.ADD;
1168: RAISE FND_API.G_EXC_ERROR;
1169: else
1170: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1171: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1172: FND_MSG_PUB.ADD;

Line 1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1169: else
1170: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1171: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1172: FND_MSG_PUB.ADD;
1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1174: end if;
1175: END;
1176:
1177: PROCEDURE open_party_site_cursor(

Line 1405: RAISE FND_API.G_EXC_ERROR;

1401: when others then
1402: if (instrb(SQLERRM,'DRG-51030')>0) then
1403: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1404: FND_MSG_PUB.ADD;
1405: RAISE FND_API.G_EXC_ERROR;
1406: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1407: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1408: FND_MSG_PUB.ADD;
1409: RAISE FND_API.G_EXC_ERROR;

Line 1409: RAISE FND_API.G_EXC_ERROR;

1405: RAISE FND_API.G_EXC_ERROR;
1406: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1407: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1408: FND_MSG_PUB.ADD;
1409: RAISE FND_API.G_EXC_ERROR;
1410: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1411: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1412: FND_MSG_PUB.ADD;
1413: RAISE FND_API.G_EXC_ERROR;

Line 1413: RAISE FND_API.G_EXC_ERROR;

1409: RAISE FND_API.G_EXC_ERROR;
1410: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1411: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1412: FND_MSG_PUB.ADD;
1413: RAISE FND_API.G_EXC_ERROR;
1414: else
1415: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1416: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1417: FND_MSG_PUB.ADD;

Line 1418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1414: else
1415: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1416: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1417: FND_MSG_PUB.ADD;
1418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1419: end if;
1420: END;
1421:
1422: PROCEDURE open_contact_cursor(

Line 1552: RAISE FND_API.G_EXC_ERROR;

1548: when others then
1549: if (instrb(SQLERRM,'DRG-51030')>0) then
1550: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1551: FND_MSG_PUB.ADD;
1552: RAISE FND_API.G_EXC_ERROR;
1553: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1554: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1555: FND_MSG_PUB.ADD;
1556: RAISE FND_API.G_EXC_ERROR;

Line 1556: RAISE FND_API.G_EXC_ERROR;

1552: RAISE FND_API.G_EXC_ERROR;
1553: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1554: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1555: FND_MSG_PUB.ADD;
1556: RAISE FND_API.G_EXC_ERROR;
1557: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1558: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1559: FND_MSG_PUB.ADD;
1560: RAISE FND_API.G_EXC_ERROR;

Line 1560: RAISE FND_API.G_EXC_ERROR;

1556: RAISE FND_API.G_EXC_ERROR;
1557: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1558: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1559: FND_MSG_PUB.ADD;
1560: RAISE FND_API.G_EXC_ERROR;
1561: else
1562: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1563: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1564: FND_MSG_PUB.ADD;

Line 1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1561: else
1562: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1563: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1564: FND_MSG_PUB.ADD;
1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1566: end if;
1567: END;
1568:
1569: PROCEDURE open_contact_pt_cursor(

Line 1825: RAISE FND_API.G_EXC_ERROR;

1821: when others then
1822: if (instrb(SQLERRM,'DRG-51030')>0) then
1823: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1824: FND_MSG_PUB.ADD;
1825: RAISE FND_API.G_EXC_ERROR;
1826: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1827: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1828: FND_MSG_PUB.ADD;
1829: RAISE FND_API.G_EXC_ERROR;

Line 1829: RAISE FND_API.G_EXC_ERROR;

1825: RAISE FND_API.G_EXC_ERROR;
1826: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1827: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1828: FND_MSG_PUB.ADD;
1829: RAISE FND_API.G_EXC_ERROR;
1830: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1831: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1832: FND_MSG_PUB.ADD;
1833: RAISE FND_API.G_EXC_ERROR;

Line 1833: RAISE FND_API.G_EXC_ERROR;

1829: RAISE FND_API.G_EXC_ERROR;
1830: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1831: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1832: FND_MSG_PUB.ADD;
1833: RAISE FND_API.G_EXC_ERROR;
1834: else
1835: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1836: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1837: FND_MSG_PUB.ADD;

Line 1838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1834: else
1835: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1836: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1837: FND_MSG_PUB.ADD;
1838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1839: end if;
1840: END;
1841:
1842:

Line 2085: RAISE FND_API.G_EXC_ERROR;

2081: 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);
2082: END IF;
2083: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2084: FND_MSG_PUB.ADD;
2085: RAISE FND_API.G_EXC_ERROR;
2086: ELSE
2087: push_eval;
2088: RETURN;
2089: END IF;

Line 2133: RAISE FND_API.G_EXC_ERROR;

2129: 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);
2130: END IF;
2131: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2132: FND_MSG_PUB.ADD;
2133: RAISE FND_API.G_EXC_ERROR;
2134: ELSE
2135: push_eval;
2136: RETURN;
2137: END IF;

Line 2206: RAISE FND_API.G_EXC_ERROR;

2202: 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);
2203: END IF;
2204: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2205: FND_MSG_PUB.ADD;
2206: RAISE FND_API.G_EXC_ERROR;
2207: ELSE
2208: push_eval;
2209: RETURN;
2210: END IF;

Line 2318: RAISE FND_API.G_EXC_ERROR;

2314: 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);
2315: END IF;
2316: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2317: FND_MSG_PUB.ADD;
2318: RAISE FND_API.G_EXC_ERROR;
2319: ELSE
2320: push_eval;
2321: RETURN;
2322: END IF;

Line 2429: RAISE FND_API.G_EXC_ERROR;

2425: 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);
2426: END IF;
2427: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2428: FND_MSG_PUB.ADD;
2429: RAISE FND_API.G_EXC_ERROR;
2430: ELSE
2431: push_eval;
2432: RETURN;
2433: END IF;

Line 2573: RAISE FND_API.G_EXC_ERROR;

2569: 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);
2570: END IF;
2571: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2572: FND_MSG_PUB.ADD;
2573: RAISE FND_API.G_EXC_ERROR;
2574: END IF;
2575: ELSE
2576: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2577: 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 2581: RAISE FND_API.G_EXC_ERROR;

2577: 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);
2578: END IF;
2579: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2580: FND_MSG_PUB.ADD;
2581: RAISE FND_API.G_EXC_ERROR;
2582: END IF;
2583: END IF;
2584: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2585: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 2823: WHEN FND_API.G_EXC_ERROR THEN

2819: END IF;
2820: EXCEPTION
2821: WHEN L_RETURN_IMM_EXC THEN
2822: RETURN;
2823: WHEN FND_API.G_EXC_ERROR THEN
2824: RAISE FND_API.G_EXC_ERROR;
2825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2827: WHEN OTHERS THEN

Line 2824: RAISE FND_API.G_EXC_ERROR;

2820: EXCEPTION
2821: WHEN L_RETURN_IMM_EXC THEN
2822: RETURN;
2823: WHEN FND_API.G_EXC_ERROR THEN
2824: RAISE FND_API.G_EXC_ERROR;
2825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2827: WHEN OTHERS THEN
2828: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 2825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2821: WHEN L_RETURN_IMM_EXC THEN
2822: RETURN;
2823: WHEN FND_API.G_EXC_ERROR THEN
2824: RAISE FND_API.G_EXC_ERROR;
2825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2827: WHEN OTHERS THEN
2828: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2829: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_parties');

Line 2826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2822: RETURN;
2823: WHEN FND_API.G_EXC_ERROR THEN
2824: RAISE FND_API.G_EXC_ERROR;
2825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2827: WHEN OTHERS THEN
2828: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2829: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_parties');
2830: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 2832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2828: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
2829: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_parties');
2830: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
2831: FND_MSG_PUB.ADD;
2832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2833: END find_parties;
2834:
2835: PROCEDURE find_persons (
2836: p_rule_id IN NUMBER,

Line 3019: RAISE FND_API.G_EXC_ERROR;

3015: 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);
3016: END IF;
3017: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3018: FND_MSG_PUB.ADD;
3019: RAISE FND_API.G_EXC_ERROR;
3020: ELSE
3021: push_eval;
3022: RETURN;
3023: END IF;

Line 3067: RAISE FND_API.G_EXC_ERROR;

3063: 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);
3064: END IF;
3065: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3066: FND_MSG_PUB.ADD;
3067: RAISE FND_API.G_EXC_ERROR;
3068: ELSE
3069: push_eval;
3070: RETURN;
3071: END IF;

Line 3103: RAISE FND_API.G_EXC_ERROR;

3099: when others then
3100: if (instrb(SQLERRM,'DRG-51030')>0) then
3101: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3102: FND_MSG_PUB.ADD;
3103: RAISE FND_API.G_EXC_ERROR;
3104: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3105: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3106: FND_MSG_PUB.ADD;
3107: RAISE FND_API.G_EXC_ERROR;

Line 3107: RAISE FND_API.G_EXC_ERROR;

3103: RAISE FND_API.G_EXC_ERROR;
3104: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3105: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3106: FND_MSG_PUB.ADD;
3107: RAISE FND_API.G_EXC_ERROR;
3108: else
3109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3110: end if;
3111: END;

Line 3109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3105: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3106: FND_MSG_PUB.ADD;
3107: RAISE FND_API.G_EXC_ERROR;
3108: else
3109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3110: end if;
3111: END;
3112:
3113: /** Private procedure to acquire and score at party site level ***/

Line 3179: RAISE FND_API.G_EXC_ERROR;

3175: 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);
3176: END IF;
3177: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3178: FND_MSG_PUB.ADD;
3179: RAISE FND_API.G_EXC_ERROR;
3180: ELSE
3181: push_eval;
3182: RETURN;
3183: END IF;

Line 3368: RAISE FND_API.G_EXC_ERROR;

3364: 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);
3365: END IF;
3366: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3367: FND_MSG_PUB.ADD;
3368: RAISE FND_API.G_EXC_ERROR;
3369: ELSE
3370: push_eval;
3371: RETURN;
3372: END IF;

Line 3456: RAISE FND_API.G_EXC_ERROR;

3452: 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);
3453: END IF;
3454: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3455: FND_MSG_PUB.ADD;
3456: RAISE FND_API.G_EXC_ERROR;
3457: END IF;
3458: ELSE
3459: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3460: 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 3464: RAISE FND_API.G_EXC_ERROR;

3460: 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);
3461: END IF;
3462: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3463: FND_MSG_PUB.ADD;
3464: RAISE FND_API.G_EXC_ERROR;
3465: END IF;
3466: END IF;
3467: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3468: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3604: WHEN FND_API.G_EXC_ERROR THEN

3600: END IF;
3601: EXCEPTION
3602: WHEN L_RETURN_IMM_EXC THEN
3603: RETURN;
3604: WHEN FND_API.G_EXC_ERROR THEN
3605: RAISE FND_API.G_EXC_ERROR;
3606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3608: WHEN OTHERS THEN

Line 3605: RAISE FND_API.G_EXC_ERROR;

3601: EXCEPTION
3602: WHEN L_RETURN_IMM_EXC THEN
3603: RETURN;
3604: WHEN FND_API.G_EXC_ERROR THEN
3605: RAISE FND_API.G_EXC_ERROR;
3606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3608: WHEN OTHERS THEN
3609: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3602: WHEN L_RETURN_IMM_EXC THEN
3603: RETURN;
3604: WHEN FND_API.G_EXC_ERROR THEN
3605: RAISE FND_API.G_EXC_ERROR;
3606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3608: WHEN OTHERS THEN
3609: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3610: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_persons');

Line 3607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3603: RETURN;
3604: WHEN FND_API.G_EXC_ERROR THEN
3605: RAISE FND_API.G_EXC_ERROR;
3606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3608: WHEN OTHERS THEN
3609: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3610: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_persons');
3611: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3609: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3610: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_persons');
3611: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3612: FND_MSG_PUB.ADD;
3613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3614: END find_persons;
3615:
3616: PROCEDURE find_persons (
3617: p_rule_id IN NUMBER,

Line 3672: WHEN FND_API.G_EXC_ERROR THEN

3668: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3669: 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);
3670: END IF;
3671: EXCEPTION
3672: WHEN FND_API.G_EXC_ERROR THEN
3673: RAISE FND_API.G_EXC_ERROR;
3674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3676: WHEN OTHERS THEN

Line 3673: RAISE FND_API.G_EXC_ERROR;

3669: 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);
3670: END IF;
3671: EXCEPTION
3672: WHEN FND_API.G_EXC_ERROR THEN
3673: RAISE FND_API.G_EXC_ERROR;
3674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3676: WHEN OTHERS THEN
3677: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3670: END IF;
3671: EXCEPTION
3672: WHEN FND_API.G_EXC_ERROR THEN
3673: RAISE FND_API.G_EXC_ERROR;
3674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3676: WHEN OTHERS THEN
3677: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3678: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_party_details');

Line 3675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3671: EXCEPTION
3672: WHEN FND_API.G_EXC_ERROR THEN
3673: RAISE FND_API.G_EXC_ERROR;
3674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3676: WHEN OTHERS THEN
3677: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3678: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_party_details');
3679: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3677: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3678: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_party_details');
3679: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3680: FND_MSG_PUB.ADD;
3681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3682: END find_party_details;
3683:
3684: PROCEDURE find_duplicate_parties (
3685: p_rule_id IN NUMBER,

Line 3789: WHEN FND_API.G_EXC_ERROR THEN

3785: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3786: 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);
3787: END IF;
3788: EXCEPTION
3789: WHEN FND_API.G_EXC_ERROR THEN
3790: RAISE FND_API.G_EXC_ERROR;
3791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3793: WHEN OTHERS THEN

Line 3790: RAISE FND_API.G_EXC_ERROR;

3786: 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);
3787: END IF;
3788: EXCEPTION
3789: WHEN FND_API.G_EXC_ERROR THEN
3790: RAISE FND_API.G_EXC_ERROR;
3791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3793: WHEN OTHERS THEN
3794: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3787: END IF;
3788: EXCEPTION
3789: WHEN FND_API.G_EXC_ERROR THEN
3790: RAISE FND_API.G_EXC_ERROR;
3791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3793: WHEN OTHERS THEN
3794: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3795: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_parties');

Line 3792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3788: EXCEPTION
3789: WHEN FND_API.G_EXC_ERROR THEN
3790: RAISE FND_API.G_EXC_ERROR;
3791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3793: WHEN OTHERS THEN
3794: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3795: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_parties');
3796: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3794: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3795: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_parties');
3796: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3797: FND_MSG_PUB.ADD;
3798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3799: END find_duplicate_parties;
3800:
3801: PROCEDURE find_duplicate_party_sites (
3802: p_rule_id IN NUMBER,

Line 3874: WHEN FND_API.G_EXC_ERROR THEN

3870: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3871: 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);
3872: END IF;
3873: EXCEPTION
3874: WHEN FND_API.G_EXC_ERROR THEN
3875: RAISE FND_API.G_EXC_ERROR;
3876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3878: WHEN OTHERS THEN

Line 3875: RAISE FND_API.G_EXC_ERROR;

3871: 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);
3872: END IF;
3873: EXCEPTION
3874: WHEN FND_API.G_EXC_ERROR THEN
3875: RAISE FND_API.G_EXC_ERROR;
3876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3878: WHEN OTHERS THEN
3879: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3872: END IF;
3873: EXCEPTION
3874: WHEN FND_API.G_EXC_ERROR THEN
3875: RAISE FND_API.G_EXC_ERROR;
3876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3878: WHEN OTHERS THEN
3879: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3880: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_party_sites');

Line 3877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3873: EXCEPTION
3874: WHEN FND_API.G_EXC_ERROR THEN
3875: RAISE FND_API.G_EXC_ERROR;
3876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3878: WHEN OTHERS THEN
3879: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3880: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_party_sites');
3881: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3879: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3880: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_party_sites');
3881: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3882: FND_MSG_PUB.ADD;
3883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3884: END find_duplicate_party_sites;
3885:
3886: PROCEDURE find_duplicate_contacts (
3887: p_rule_id IN NUMBER,

Line 3963: WHEN FND_API.G_EXC_ERROR THEN

3959: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3960: 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);
3961: END IF;
3962: EXCEPTION
3963: WHEN FND_API.G_EXC_ERROR THEN
3964: RAISE FND_API.G_EXC_ERROR;
3965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3967: WHEN OTHERS THEN

Line 3964: RAISE FND_API.G_EXC_ERROR;

3960: 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);
3961: END IF;
3962: EXCEPTION
3963: WHEN FND_API.G_EXC_ERROR THEN
3964: RAISE FND_API.G_EXC_ERROR;
3965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3967: WHEN OTHERS THEN
3968: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3961: END IF;
3962: EXCEPTION
3963: WHEN FND_API.G_EXC_ERROR THEN
3964: RAISE FND_API.G_EXC_ERROR;
3965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3967: WHEN OTHERS THEN
3968: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3969: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contacts');

Line 3966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3962: EXCEPTION
3963: WHEN FND_API.G_EXC_ERROR THEN
3964: RAISE FND_API.G_EXC_ERROR;
3965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3967: WHEN OTHERS THEN
3968: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3969: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contacts');
3970: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3968: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3969: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contacts');
3970: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3971: FND_MSG_PUB.ADD;
3972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3973: END find_duplicate_contacts;
3974:
3975: PROCEDURE find_duplicate_contact_points (
3976: p_rule_id IN NUMBER,

Line 4036: WHEN FND_API.G_EXC_ERROR THEN

4032: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4033: 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);
4034: END IF;
4035: EXCEPTION
4036: WHEN FND_API.G_EXC_ERROR THEN
4037: RAISE FND_API.G_EXC_ERROR;
4038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4040: WHEN OTHERS THEN

Line 4037: RAISE FND_API.G_EXC_ERROR;

4033: 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);
4034: END IF;
4035: EXCEPTION
4036: WHEN FND_API.G_EXC_ERROR THEN
4037: RAISE FND_API.G_EXC_ERROR;
4038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4040: WHEN OTHERS THEN
4041: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4034: END IF;
4035: EXCEPTION
4036: WHEN FND_API.G_EXC_ERROR THEN
4037: RAISE FND_API.G_EXC_ERROR;
4038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4040: WHEN OTHERS THEN
4041: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4042: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contact_points');

Line 4039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4035: EXCEPTION
4036: WHEN FND_API.G_EXC_ERROR THEN
4037: RAISE FND_API.G_EXC_ERROR;
4038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4040: WHEN OTHERS THEN
4041: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4042: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contact_points');
4043: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4041: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4042: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.find_duplicate_contact_points');
4043: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4044: FND_MSG_PUB.ADD;
4045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4046: END find_duplicate_contact_points;
4047:
4048: PROCEDURE find_parties_dynamic (
4049: p_rule_id IN NUMBER,

Line 4330: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4331: RAISE FND_API.G_EXC_ERROR;

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

Line 4332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4328: END IF;
4329: EXCEPTION
4330: WHEN FND_API.G_EXC_ERROR THEN
4331: RAISE FND_API.G_EXC_ERROR;
4332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4334: WHEN OTHERS THEN
4335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.call_api_dynamic');

Line 4333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4329: EXCEPTION
4330: WHEN FND_API.G_EXC_ERROR THEN
4331: RAISE FND_API.G_EXC_ERROR;
4332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4334: WHEN OTHERS THEN
4335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.call_api_dynamic');
4337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.call_api_dynamic');
4337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4338: FND_MSG_PUB.ADD;
4339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4340: END call_api_dynamic;
4341:
4342:
4343: PROCEDURE get_matching_party_sites (

Line 4565: WHEN FND_API.G_EXC_ERROR THEN

4561: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4562: 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);
4563: END IF;
4564: EXCEPTION
4565: WHEN FND_API.G_EXC_ERROR THEN
4566: RAISE FND_API.G_EXC_ERROR;
4567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4569: WHEN OTHERS THEN

Line 4566: RAISE FND_API.G_EXC_ERROR;

4562: 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);
4563: END IF;
4564: EXCEPTION
4565: WHEN FND_API.G_EXC_ERROR THEN
4566: RAISE FND_API.G_EXC_ERROR;
4567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4569: WHEN OTHERS THEN
4570: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4563: END IF;
4564: EXCEPTION
4565: WHEN FND_API.G_EXC_ERROR THEN
4566: RAISE FND_API.G_EXC_ERROR;
4567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4569: WHEN OTHERS THEN
4570: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4571: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_party_sites');

Line 4568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4564: EXCEPTION
4565: WHEN FND_API.G_EXC_ERROR THEN
4566: RAISE FND_API.G_EXC_ERROR;
4567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4569: WHEN OTHERS THEN
4570: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4571: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_party_sites');
4572: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4570: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4571: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_party_sites');
4572: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4573: FND_MSG_PUB.ADD;
4574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4575: END get_matching_party_sites;
4576:
4577:
4578: PROCEDURE get_matching_contacts (

Line 4793: WHEN FND_API.G_EXC_ERROR THEN

4789: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4790: 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);
4791: END IF;
4792: EXCEPTION
4793: WHEN FND_API.G_EXC_ERROR THEN
4794: RAISE FND_API.G_EXC_ERROR;
4795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4797: WHEN OTHERS THEN

Line 4794: RAISE FND_API.G_EXC_ERROR;

4790: 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);
4791: END IF;
4792: EXCEPTION
4793: WHEN FND_API.G_EXC_ERROR THEN
4794: RAISE FND_API.G_EXC_ERROR;
4795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4797: WHEN OTHERS THEN
4798: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4791: END IF;
4792: EXCEPTION
4793: WHEN FND_API.G_EXC_ERROR THEN
4794: RAISE FND_API.G_EXC_ERROR;
4795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4797: WHEN OTHERS THEN
4798: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4799: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contacts');

Line 4796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4792: EXCEPTION
4793: WHEN FND_API.G_EXC_ERROR THEN
4794: RAISE FND_API.G_EXC_ERROR;
4795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4797: WHEN OTHERS THEN
4798: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4799: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contacts');
4800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4798: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4799: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contacts');
4800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4801: FND_MSG_PUB.ADD;
4802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4803: END get_matching_contacts;
4804:
4805:
4806: PROCEDURE get_matching_contact_points (

Line 4935: WHEN FND_API.G_EXC_ERROR THEN

4931: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4932: 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);
4933: END IF;
4934: EXCEPTION
4935: WHEN FND_API.G_EXC_ERROR THEN
4936: RAISE FND_API.G_EXC_ERROR;
4937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4939: WHEN OTHERS THEN

Line 4936: RAISE FND_API.G_EXC_ERROR;

4932: 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);
4933: END IF;
4934: EXCEPTION
4935: WHEN FND_API.G_EXC_ERROR THEN
4936: RAISE FND_API.G_EXC_ERROR;
4937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4939: WHEN OTHERS THEN
4940: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4933: END IF;
4934: EXCEPTION
4935: WHEN FND_API.G_EXC_ERROR THEN
4936: RAISE FND_API.G_EXC_ERROR;
4937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4939: WHEN OTHERS THEN
4940: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4941: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contact_points');

Line 4938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4934: EXCEPTION
4935: WHEN FND_API.G_EXC_ERROR THEN
4936: RAISE FND_API.G_EXC_ERROR;
4937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4939: WHEN OTHERS THEN
4940: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4941: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contact_points');
4942: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4940: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4941: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_matching_contact_points');
4942: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4943: FND_MSG_PUB.ADD;
4944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4945: END get_matching_contact_points;
4946:
4947: /**********************************************************
4948: This procedure finds the score details for a specific party that

Line 5134: WHEN FND_API.G_EXC_ERROR THEN

5130: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5131: 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);
5132: END IF;
5133: EXCEPTION
5134: WHEN FND_API.G_EXC_ERROR THEN
5135: RAISE FND_API.G_EXC_ERROR;
5136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5138: WHEN OTHERS THEN

Line 5135: RAISE FND_API.G_EXC_ERROR;

5131: 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);
5132: END IF;
5133: EXCEPTION
5134: WHEN FND_API.G_EXC_ERROR THEN
5135: RAISE FND_API.G_EXC_ERROR;
5136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5138: WHEN OTHERS THEN
5139: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5132: END IF;
5133: EXCEPTION
5134: WHEN FND_API.G_EXC_ERROR THEN
5135: RAISE FND_API.G_EXC_ERROR;
5136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5138: WHEN OTHERS THEN
5139: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5140: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_score_details');

Line 5137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5133: EXCEPTION
5134: WHEN FND_API.G_EXC_ERROR THEN
5135: RAISE FND_API.G_EXC_ERROR;
5136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5138: WHEN OTHERS THEN
5139: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5140: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_score_details');
5141: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5139: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5140: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_3.get_score_details');
5141: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5142: FND_MSG_PUB.ADD;
5143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5144: END get_score_details;
5145:
5146:
5147: /************************************************

Line 5209: WHEN FND_API.G_EXC_ERROR THEN

5205: END LOOP;
5206: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5207: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5208: EXCEPTION
5209: WHEN FND_API.G_EXC_ERROR THEN
5210: RAISE FND_API.G_EXC_ERROR;
5211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5213: WHEN OTHERS THEN

Line 5210: RAISE FND_API.G_EXC_ERROR;

5206: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5207: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5208: EXCEPTION
5209: WHEN FND_API.G_EXC_ERROR THEN
5210: RAISE FND_API.G_EXC_ERROR;
5211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5213: WHEN OTHERS THEN
5214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5207: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5208: EXCEPTION
5209: WHEN FND_API.G_EXC_ERROR THEN
5210: RAISE FND_API.G_EXC_ERROR;
5211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5213: WHEN OTHERS THEN
5214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5215: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5208: EXCEPTION
5209: WHEN FND_API.G_EXC_ERROR THEN
5210: RAISE FND_API.G_EXC_ERROR;
5211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5213: WHEN OTHERS THEN
5214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5215: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5216: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5215: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5216: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5217: FND_MSG_PUB.ADD;
5218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5219: END get_party_for_search;
5220:
5221: PROCEDURE get_search_criteria (
5222: p_party_id IN NUMBER,

Line 5249: WHEN FND_API.G_EXC_ERROR THEN

5245: END IF;
5246: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5247: END IF;
5248: EXCEPTION
5249: WHEN FND_API.G_EXC_ERROR THEN
5250: RAISE FND_API.G_EXC_ERROR;
5251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5253: WHEN OTHERS THEN

Line 5250: RAISE FND_API.G_EXC_ERROR;

5246: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5247: END IF;
5248: EXCEPTION
5249: WHEN FND_API.G_EXC_ERROR THEN
5250: RAISE FND_API.G_EXC_ERROR;
5251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5253: WHEN OTHERS THEN
5254: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5247: END IF;
5248: EXCEPTION
5249: WHEN FND_API.G_EXC_ERROR THEN
5250: RAISE FND_API.G_EXC_ERROR;
5251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5253: WHEN OTHERS THEN
5254: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5255: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5248: EXCEPTION
5249: WHEN FND_API.G_EXC_ERROR THEN
5250: RAISE FND_API.G_EXC_ERROR;
5251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5253: WHEN OTHERS THEN
5254: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5255: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5256: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5254: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5255: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5256: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5257: FND_MSG_PUB.ADD;
5258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5259: END get_search_criteria;
5260:
5261:
5262: /************************************************

Line 5319: RAISE FND_API.G_EXC_ERROR;

5315: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5316: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5318: FND_MSG_PUB.ADD;
5319: RAISE FND_API.G_EXC_ERROR;
5320: END get_party_rec;
5321:
5322: /************************************************
5323: This procedure retrieves the match rule party site attributes into

Line 5371: RAISE FND_API.G_EXC_ERROR;

5367: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5368: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5370: FND_MSG_PUB.ADD;
5371: RAISE FND_API.G_EXC_ERROR;
5372: END get_party_site_rec;
5373:
5374: /************************************************
5375: This procedure retrieves the match rule contact attributes into

Line 5427: RAISE FND_API.G_EXC_ERROR;

5423: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5424: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5425: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5426: FND_MSG_PUB.ADD;
5427: RAISE FND_API.G_EXC_ERROR;
5428: END get_contact_rec;
5429:
5430: /************************************************
5431: This procedure retrieves the match rule contact point attributes into

Line 5483: RAISE FND_API.G_EXC_ERROR;

5479: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5480: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5481: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5482: FND_MSG_PUB.ADD;
5483: RAISE FND_API.G_EXC_ERROR;
5484: END get_contact_point_rec;
5485:
5486: /************************************************
5487: This procedure maps a search record from the logical

Line 5560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5556: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5557: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5558: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5559: FND_MSG_PUB.ADD;
5560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5561: END;
5562:
5563:
5564: /************************************************

Line 5603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5599: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5600: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
5601: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5602: FND_MSG_PUB.ADD;
5603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5604: END;
5605:
5606:
5607: /************************************************

Line 5645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5641: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5642: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
5643: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5644: FND_MSG_PUB.ADD;
5645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5646: END;
5647:
5648:
5649: /************************************************

Line 5752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5748: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5749: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
5750: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5751: FND_MSG_PUB.ADD;
5752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5753: END;
5754:
5755:
5756: /************************************************

Line 5777: RAISE FND_API.G_EXC_ERROR;

5773: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
5774: ) THEN
5775: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5776: FND_MSG_PUB.ADD;
5777: RAISE FND_API.G_EXC_ERROR;
5778: END IF;
5779: END LOOP;
5780:
5781: IF p_party_search_rec.TAX_REFERENCE IS NOT NULL THEN

Line 5796: WHEN FND_API.G_EXC_ERROR THEN

5792: END IF;
5793: END LOOP;
5794: RETURN FALSE;
5795: EXCEPTION
5796: WHEN FND_API.G_EXC_ERROR THEN
5797: RAISE FND_API.G_EXC_ERROR;
5798: WHEN OTHERS THEN
5799: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5800: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 5797: RAISE FND_API.G_EXC_ERROR;

5793: END LOOP;
5794: RETURN FALSE;
5795: EXCEPTION
5796: WHEN FND_API.G_EXC_ERROR THEN
5797: RAISE FND_API.G_EXC_ERROR;
5798: WHEN OTHERS THEN
5799: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5800: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5801: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5799: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5800: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
5801: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5802: FND_MSG_PUB.ADD;
5803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5804: END check_prim_cond;
5805:
5806: /************************************************
5807: This procedure checks if the input search condition

Line 5849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5845: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5846: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
5847: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5848: FND_MSG_PUB.ADD;
5849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5850: END check_party_site_cond;
5851:
5852: /************************************************
5853: This procedure checks if the input search condition

Line 5897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5893: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5894: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
5895: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5896: FND_MSG_PUB.ADD;
5897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5898: END check_contact_cond;
5899:
5900: /************************************************
5901: This procedure checks if the input search condition

Line 5918: RAISE FND_API.G_EXC_ERROR;

5914: FOR I IN 1..p_contact_point_list.COUNT LOOP
5915: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
5916: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
5917: FND_MSG_PUB.ADD;
5918: RAISE FND_API.G_EXC_ERROR;
5919: END IF;
5920: END LOOP;
5921:
5922: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 5944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5940: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5941: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
5942: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5943: FND_MSG_PUB.ADD;
5944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5945: END check_contact_point_cond;
5946:
5947: FUNCTION check_staged RETURN BOOLEAN IS
5948: