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_37 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 737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

733: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
734: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
736: FND_MSG_PUB.ADD;
737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
738: END;
739:
740:
741: /************************************************

Line 762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

758: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
759: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
760: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
761: FND_MSG_PUB.ADD;
762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
763: END;
764:
765:
766: /************************************************

Line 782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

778: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
779: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
780: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
781: FND_MSG_PUB.ADD;
782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
783: END;
784:
785:
786: /************************************************

Line 802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

798: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
799: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
800: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
801: FND_MSG_PUB.ADD;
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
803: END;
804:
805: PROCEDURE init_score_context (
806: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 869: RAISE FND_API.G_EXC_ERROR;

865: p_contact_list,
866: p_contact_point_list) THEN
867: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
868: FND_MSG_PUB.ADD;
869: RAISE FND_API.G_EXC_ERROR;
870: END IF;
871: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
872: 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);
873: END IF;

Line 1070: RAISE FND_API.G_EXC_ERROR;

1066: IF lengthb(l_party_contains_str) > 4000 THEN
1067: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1068: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1069: FND_MSG_PUB.ADD;
1070: RAISE FND_API.G_EXC_ERROR;
1071: END IF;
1072: IF (p_match_str = ' AND ' OR p_party_max_score 1073: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1074: 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 1189: RAISE FND_API.G_EXC_ERROR;

1185: IF lengthb(l_contains_str) > 4000 THEN
1186: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1187: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1188: FND_MSG_PUB.ADD;
1189: RAISE FND_API.G_EXC_ERROR;
1190: END IF;
1191: x_denorm_str := l_den_contains_str;
1192: RETURN l_contains_str;
1193: END;

Line 1467: RAISE FND_API.G_EXC_ERROR;

1463: when others then
1464: if (instrb(SQLERRM,'DRG-51030')>0) then
1465: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1466: FND_MSG_PUB.ADD;
1467: RAISE FND_API.G_EXC_ERROR;
1468: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1469: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1470: FND_MSG_PUB.ADD;
1471: RAISE FND_API.G_EXC_ERROR;

Line 1471: RAISE FND_API.G_EXC_ERROR;

1467: RAISE FND_API.G_EXC_ERROR;
1468: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1469: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1470: FND_MSG_PUB.ADD;
1471: RAISE FND_API.G_EXC_ERROR;
1472: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1473: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1474: FND_MSG_PUB.ADD;
1475: RAISE FND_API.G_EXC_ERROR;

Line 1475: RAISE FND_API.G_EXC_ERROR;

1471: RAISE FND_API.G_EXC_ERROR;
1472: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1473: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1474: FND_MSG_PUB.ADD;
1475: RAISE FND_API.G_EXC_ERROR;
1476: else
1477: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1478: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1479: FND_MSG_PUB.ADD;

Line 1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1476: else
1477: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1478: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1479: FND_MSG_PUB.ADD;
1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1481: end if;
1482: END;
1483:
1484: PROCEDURE open_party_site_cursor(

Line 1712: RAISE FND_API.G_EXC_ERROR;

1708: when others then
1709: if (instrb(SQLERRM,'DRG-51030')>0) then
1710: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1711: FND_MSG_PUB.ADD;
1712: RAISE FND_API.G_EXC_ERROR;
1713: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1715: FND_MSG_PUB.ADD;
1716: RAISE FND_API.G_EXC_ERROR;

Line 1716: RAISE FND_API.G_EXC_ERROR;

1712: RAISE FND_API.G_EXC_ERROR;
1713: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1714: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1715: FND_MSG_PUB.ADD;
1716: RAISE FND_API.G_EXC_ERROR;
1717: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1718: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1719: FND_MSG_PUB.ADD;
1720: RAISE FND_API.G_EXC_ERROR;

Line 1720: RAISE FND_API.G_EXC_ERROR;

1716: RAISE FND_API.G_EXC_ERROR;
1717: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1718: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1719: FND_MSG_PUB.ADD;
1720: RAISE FND_API.G_EXC_ERROR;
1721: else
1722: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1723: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1724: FND_MSG_PUB.ADD;

Line 1725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1721: else
1722: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1723: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1724: FND_MSG_PUB.ADD;
1725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1726: end if;
1727: END;
1728:
1729: PROCEDURE open_contact_cursor(

Line 1859: RAISE FND_API.G_EXC_ERROR;

1855: when others then
1856: if (instrb(SQLERRM,'DRG-51030')>0) then
1857: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1858: FND_MSG_PUB.ADD;
1859: RAISE FND_API.G_EXC_ERROR;
1860: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1861: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1862: FND_MSG_PUB.ADD;
1863: RAISE FND_API.G_EXC_ERROR;

Line 1863: RAISE FND_API.G_EXC_ERROR;

1859: RAISE FND_API.G_EXC_ERROR;
1860: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1861: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1862: FND_MSG_PUB.ADD;
1863: RAISE FND_API.G_EXC_ERROR;
1864: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1865: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1866: FND_MSG_PUB.ADD;
1867: RAISE FND_API.G_EXC_ERROR;

Line 1867: RAISE FND_API.G_EXC_ERROR;

1863: RAISE FND_API.G_EXC_ERROR;
1864: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1865: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1866: FND_MSG_PUB.ADD;
1867: RAISE FND_API.G_EXC_ERROR;
1868: else
1869: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1870: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1871: FND_MSG_PUB.ADD;

Line 1872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1868: else
1869: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1870: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1871: FND_MSG_PUB.ADD;
1872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1873: end if;
1874: END;
1875:
1876: PROCEDURE open_contact_pt_cursor(

Line 2132: RAISE FND_API.G_EXC_ERROR;

2128: when others then
2129: if (instrb(SQLERRM,'DRG-51030')>0) then
2130: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2131: FND_MSG_PUB.ADD;
2132: RAISE FND_API.G_EXC_ERROR;
2133: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2134: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2135: FND_MSG_PUB.ADD;
2136: RAISE FND_API.G_EXC_ERROR;

Line 2136: RAISE FND_API.G_EXC_ERROR;

2132: RAISE FND_API.G_EXC_ERROR;
2133: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2134: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2135: FND_MSG_PUB.ADD;
2136: RAISE FND_API.G_EXC_ERROR;
2137: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2139: FND_MSG_PUB.ADD;
2140: RAISE FND_API.G_EXC_ERROR;

Line 2140: RAISE FND_API.G_EXC_ERROR;

2136: RAISE FND_API.G_EXC_ERROR;
2137: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2138: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2139: FND_MSG_PUB.ADD;
2140: RAISE FND_API.G_EXC_ERROR;
2141: else
2142: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2144: FND_MSG_PUB.ADD;

Line 2145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2141: else
2142: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2143: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2144: FND_MSG_PUB.ADD;
2145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2146: end if;
2147: END;
2148:
2149:

Line 2400: RAISE FND_API.G_EXC_ERROR;

2396: 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);
2397: END IF;
2398: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2399: FND_MSG_PUB.ADD;
2400: RAISE FND_API.G_EXC_ERROR;
2401: ELSE
2402: push_eval;
2403: RETURN;
2404: END IF;

Line 2448: RAISE FND_API.G_EXC_ERROR;

2444: 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);
2445: END IF;
2446: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2447: FND_MSG_PUB.ADD;
2448: RAISE FND_API.G_EXC_ERROR;
2449: ELSE
2450: push_eval;
2451: RETURN;
2452: END IF;

Line 2521: RAISE FND_API.G_EXC_ERROR;

2517: 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);
2518: END IF;
2519: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2520: FND_MSG_PUB.ADD;
2521: RAISE FND_API.G_EXC_ERROR;
2522: ELSE
2523: push_eval;
2524: RETURN;
2525: END IF;

Line 2633: RAISE FND_API.G_EXC_ERROR;

2629: 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);
2630: END IF;
2631: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2632: FND_MSG_PUB.ADD;
2633: RAISE FND_API.G_EXC_ERROR;
2634: ELSE
2635: push_eval;
2636: RETURN;
2637: END IF;

Line 2744: RAISE FND_API.G_EXC_ERROR;

2740: 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);
2741: END IF;
2742: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2743: FND_MSG_PUB.ADD;
2744: RAISE FND_API.G_EXC_ERROR;
2745: ELSE
2746: push_eval;
2747: RETURN;
2748: END IF;

Line 2888: RAISE FND_API.G_EXC_ERROR;

2884: 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);
2885: END IF;
2886: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2887: FND_MSG_PUB.ADD;
2888: RAISE FND_API.G_EXC_ERROR;
2889: END IF;
2890: ELSE
2891: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2892: 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 2896: RAISE FND_API.G_EXC_ERROR;

2892: 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);
2893: END IF;
2894: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2895: FND_MSG_PUB.ADD;
2896: RAISE FND_API.G_EXC_ERROR;
2897: END IF;
2898: END IF;
2899: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2900: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3138: WHEN FND_API.G_EXC_ERROR THEN

3134: END IF;
3135: EXCEPTION
3136: WHEN L_RETURN_IMM_EXC THEN
3137: RETURN;
3138: WHEN FND_API.G_EXC_ERROR THEN
3139: RAISE FND_API.G_EXC_ERROR;
3140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3142: WHEN OTHERS THEN

Line 3139: RAISE FND_API.G_EXC_ERROR;

3135: EXCEPTION
3136: WHEN L_RETURN_IMM_EXC THEN
3137: RETURN;
3138: WHEN FND_API.G_EXC_ERROR THEN
3139: RAISE FND_API.G_EXC_ERROR;
3140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3142: WHEN OTHERS THEN
3143: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3136: WHEN L_RETURN_IMM_EXC THEN
3137: RETURN;
3138: WHEN FND_API.G_EXC_ERROR THEN
3139: RAISE FND_API.G_EXC_ERROR;
3140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3142: WHEN OTHERS THEN
3143: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3144: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_parties');

Line 3141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3137: RETURN;
3138: WHEN FND_API.G_EXC_ERROR THEN
3139: RAISE FND_API.G_EXC_ERROR;
3140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3142: WHEN OTHERS THEN
3143: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3144: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_parties');
3145: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3143: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3144: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_parties');
3145: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3146: FND_MSG_PUB.ADD;
3147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3148: END find_parties;
3149:
3150: PROCEDURE find_persons (
3151: p_rule_id IN NUMBER,

Line 3342: RAISE FND_API.G_EXC_ERROR;

3338: 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);
3339: END IF;
3340: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3341: FND_MSG_PUB.ADD;
3342: RAISE FND_API.G_EXC_ERROR;
3343: ELSE
3344: push_eval;
3345: RETURN;
3346: END IF;

Line 3390: RAISE FND_API.G_EXC_ERROR;

3386: 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);
3387: END IF;
3388: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3389: FND_MSG_PUB.ADD;
3390: RAISE FND_API.G_EXC_ERROR;
3391: ELSE
3392: push_eval;
3393: RETURN;
3394: END IF;

Line 3426: RAISE FND_API.G_EXC_ERROR;

3422: when others then
3423: if (instrb(SQLERRM,'DRG-51030')>0) then
3424: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3425: FND_MSG_PUB.ADD;
3426: RAISE FND_API.G_EXC_ERROR;
3427: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3428: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3429: FND_MSG_PUB.ADD;
3430: RAISE FND_API.G_EXC_ERROR;

Line 3430: RAISE FND_API.G_EXC_ERROR;

3426: RAISE FND_API.G_EXC_ERROR;
3427: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3428: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3429: FND_MSG_PUB.ADD;
3430: RAISE FND_API.G_EXC_ERROR;
3431: else
3432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3433: end if;
3434: END;

Line 3432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3428: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3429: FND_MSG_PUB.ADD;
3430: RAISE FND_API.G_EXC_ERROR;
3431: else
3432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3433: end if;
3434: END;
3435:
3436: /** Private procedure to acquire and score at party site level ***/

Line 3502: RAISE FND_API.G_EXC_ERROR;

3498: 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);
3499: END IF;
3500: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3501: FND_MSG_PUB.ADD;
3502: RAISE FND_API.G_EXC_ERROR;
3503: ELSE
3504: push_eval;
3505: RETURN;
3506: END IF;

Line 3691: RAISE FND_API.G_EXC_ERROR;

3687: 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);
3688: END IF;
3689: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3690: FND_MSG_PUB.ADD;
3691: RAISE FND_API.G_EXC_ERROR;
3692: ELSE
3693: push_eval;
3694: RETURN;
3695: END IF;

Line 3779: RAISE FND_API.G_EXC_ERROR;

3775: 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);
3776: END IF;
3777: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3778: FND_MSG_PUB.ADD;
3779: RAISE FND_API.G_EXC_ERROR;
3780: END IF;
3781: ELSE
3782: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3783: 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 3787: RAISE FND_API.G_EXC_ERROR;

3783: 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);
3784: END IF;
3785: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3786: FND_MSG_PUB.ADD;
3787: RAISE FND_API.G_EXC_ERROR;
3788: END IF;
3789: END IF;
3790: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3791: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3927: WHEN FND_API.G_EXC_ERROR THEN

3923: END IF;
3924: EXCEPTION
3925: WHEN L_RETURN_IMM_EXC THEN
3926: RETURN;
3927: WHEN FND_API.G_EXC_ERROR THEN
3928: RAISE FND_API.G_EXC_ERROR;
3929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3931: WHEN OTHERS THEN

Line 3928: RAISE FND_API.G_EXC_ERROR;

3924: EXCEPTION
3925: WHEN L_RETURN_IMM_EXC THEN
3926: RETURN;
3927: WHEN FND_API.G_EXC_ERROR THEN
3928: RAISE FND_API.G_EXC_ERROR;
3929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3931: WHEN OTHERS THEN
3932: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3925: WHEN L_RETURN_IMM_EXC THEN
3926: RETURN;
3927: WHEN FND_API.G_EXC_ERROR THEN
3928: RAISE FND_API.G_EXC_ERROR;
3929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3931: WHEN OTHERS THEN
3932: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3933: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_persons');

Line 3930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3926: RETURN;
3927: WHEN FND_API.G_EXC_ERROR THEN
3928: RAISE FND_API.G_EXC_ERROR;
3929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3931: WHEN OTHERS THEN
3932: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3933: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_persons');
3934: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3932: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3933: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_persons');
3934: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3935: FND_MSG_PUB.ADD;
3936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3937: END find_persons;
3938:
3939: PROCEDURE find_persons (
3940: p_rule_id IN NUMBER,

Line 3995: WHEN FND_API.G_EXC_ERROR THEN

3991: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3992: 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);
3993: END IF;
3994: EXCEPTION
3995: WHEN FND_API.G_EXC_ERROR THEN
3996: RAISE FND_API.G_EXC_ERROR;
3997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3999: WHEN OTHERS THEN

Line 3996: RAISE FND_API.G_EXC_ERROR;

3992: 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);
3993: END IF;
3994: EXCEPTION
3995: WHEN FND_API.G_EXC_ERROR THEN
3996: RAISE FND_API.G_EXC_ERROR;
3997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3999: WHEN OTHERS THEN
4000: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3993: END IF;
3994: EXCEPTION
3995: WHEN FND_API.G_EXC_ERROR THEN
3996: RAISE FND_API.G_EXC_ERROR;
3997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3999: WHEN OTHERS THEN
4000: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4001: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_party_details');

Line 3998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3994: EXCEPTION
3995: WHEN FND_API.G_EXC_ERROR THEN
3996: RAISE FND_API.G_EXC_ERROR;
3997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3999: WHEN OTHERS THEN
4000: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4001: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_party_details');
4002: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4000: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4001: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_party_details');
4002: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4003: FND_MSG_PUB.ADD;
4004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4005: END find_party_details;
4006:
4007: PROCEDURE find_duplicate_parties (
4008: p_rule_id IN NUMBER,

Line 4112: WHEN FND_API.G_EXC_ERROR THEN

4108: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4109: 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);
4110: END IF;
4111: EXCEPTION
4112: WHEN FND_API.G_EXC_ERROR THEN
4113: RAISE FND_API.G_EXC_ERROR;
4114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4116: WHEN OTHERS THEN

Line 4113: RAISE FND_API.G_EXC_ERROR;

4109: 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);
4110: END IF;
4111: EXCEPTION
4112: WHEN FND_API.G_EXC_ERROR THEN
4113: RAISE FND_API.G_EXC_ERROR;
4114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4116: WHEN OTHERS THEN
4117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4110: END IF;
4111: EXCEPTION
4112: WHEN FND_API.G_EXC_ERROR THEN
4113: RAISE FND_API.G_EXC_ERROR;
4114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4116: WHEN OTHERS THEN
4117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4118: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_parties');

Line 4115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4111: EXCEPTION
4112: WHEN FND_API.G_EXC_ERROR THEN
4113: RAISE FND_API.G_EXC_ERROR;
4114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4116: WHEN OTHERS THEN
4117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4118: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_parties');
4119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4118: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_parties');
4119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4120: FND_MSG_PUB.ADD;
4121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4122: END find_duplicate_parties;
4123:
4124: PROCEDURE find_duplicate_party_sites (
4125: p_rule_id IN NUMBER,

Line 4197: WHEN FND_API.G_EXC_ERROR THEN

4193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4194: 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);
4195: END IF;
4196: EXCEPTION
4197: WHEN FND_API.G_EXC_ERROR THEN
4198: RAISE FND_API.G_EXC_ERROR;
4199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4201: WHEN OTHERS THEN

Line 4198: RAISE FND_API.G_EXC_ERROR;

4194: 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);
4195: END IF;
4196: EXCEPTION
4197: WHEN FND_API.G_EXC_ERROR THEN
4198: RAISE FND_API.G_EXC_ERROR;
4199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4201: WHEN OTHERS THEN
4202: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4195: END IF;
4196: EXCEPTION
4197: WHEN FND_API.G_EXC_ERROR THEN
4198: RAISE FND_API.G_EXC_ERROR;
4199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4201: WHEN OTHERS THEN
4202: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4203: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_party_sites');

Line 4200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4196: EXCEPTION
4197: WHEN FND_API.G_EXC_ERROR THEN
4198: RAISE FND_API.G_EXC_ERROR;
4199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4201: WHEN OTHERS THEN
4202: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4203: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_party_sites');
4204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4202: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4203: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_party_sites');
4204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4205: FND_MSG_PUB.ADD;
4206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4207: END find_duplicate_party_sites;
4208:
4209: PROCEDURE find_duplicate_contacts (
4210: p_rule_id IN NUMBER,

Line 4286: WHEN FND_API.G_EXC_ERROR THEN

4282: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4283: 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);
4284: END IF;
4285: EXCEPTION
4286: WHEN FND_API.G_EXC_ERROR THEN
4287: RAISE FND_API.G_EXC_ERROR;
4288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4290: WHEN OTHERS THEN

Line 4287: RAISE FND_API.G_EXC_ERROR;

4283: 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);
4284: END IF;
4285: EXCEPTION
4286: WHEN FND_API.G_EXC_ERROR THEN
4287: RAISE FND_API.G_EXC_ERROR;
4288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4290: WHEN OTHERS THEN
4291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4284: END IF;
4285: EXCEPTION
4286: WHEN FND_API.G_EXC_ERROR THEN
4287: RAISE FND_API.G_EXC_ERROR;
4288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4290: WHEN OTHERS THEN
4291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4292: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_contacts');

Line 4289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4285: EXCEPTION
4286: WHEN FND_API.G_EXC_ERROR THEN
4287: RAISE FND_API.G_EXC_ERROR;
4288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4290: WHEN OTHERS THEN
4291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4292: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_contacts');
4293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4292: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_contacts');
4293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4294: FND_MSG_PUB.ADD;
4295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4296: END find_duplicate_contacts;
4297:
4298: PROCEDURE find_duplicate_contact_points (
4299: p_rule_id IN NUMBER,

Line 4359: WHEN FND_API.G_EXC_ERROR THEN

4355: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4356: 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);
4357: END IF;
4358: EXCEPTION
4359: WHEN FND_API.G_EXC_ERROR THEN
4360: RAISE FND_API.G_EXC_ERROR;
4361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4363: WHEN OTHERS THEN

Line 4360: RAISE FND_API.G_EXC_ERROR;

4356: 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);
4357: END IF;
4358: EXCEPTION
4359: WHEN FND_API.G_EXC_ERROR THEN
4360: RAISE FND_API.G_EXC_ERROR;
4361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4363: WHEN OTHERS THEN
4364: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4357: END IF;
4358: EXCEPTION
4359: WHEN FND_API.G_EXC_ERROR THEN
4360: RAISE FND_API.G_EXC_ERROR;
4361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4363: WHEN OTHERS THEN
4364: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4365: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_contact_points');

Line 4362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4358: EXCEPTION
4359: WHEN FND_API.G_EXC_ERROR THEN
4360: RAISE FND_API.G_EXC_ERROR;
4361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4363: WHEN OTHERS THEN
4364: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4365: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_contact_points');
4366: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4364: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4365: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.find_duplicate_contact_points');
4366: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4367: FND_MSG_PUB.ADD;
4368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4369: END find_duplicate_contact_points;
4370:
4371: PROCEDURE find_parties_dynamic (
4372: p_rule_id IN NUMBER,

Line 4640: WHEN FND_API.G_EXC_ERROR THEN

4636: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4637: 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);
4638: END IF;
4639: EXCEPTION
4640: WHEN FND_API.G_EXC_ERROR THEN
4641: RAISE FND_API.G_EXC_ERROR;
4642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4644: WHEN OTHERS THEN

Line 4641: RAISE FND_API.G_EXC_ERROR;

4637: 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);
4638: END IF;
4639: EXCEPTION
4640: WHEN FND_API.G_EXC_ERROR THEN
4641: RAISE FND_API.G_EXC_ERROR;
4642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4644: WHEN OTHERS THEN
4645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4638: END IF;
4639: EXCEPTION
4640: WHEN FND_API.G_EXC_ERROR THEN
4641: RAISE FND_API.G_EXC_ERROR;
4642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4644: WHEN OTHERS THEN
4645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4646: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.call_api_dynamic');

Line 4643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4639: EXCEPTION
4640: WHEN FND_API.G_EXC_ERROR THEN
4641: RAISE FND_API.G_EXC_ERROR;
4642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4644: WHEN OTHERS THEN
4645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4646: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.call_api_dynamic');
4647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4646: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.call_api_dynamic');
4647: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4648: FND_MSG_PUB.ADD;
4649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4650: END call_api_dynamic;
4651:
4652:
4653: PROCEDURE get_matching_party_sites (

Line 4884: WHEN FND_API.G_EXC_ERROR THEN

4880: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4881: 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);
4882: END IF;
4883: EXCEPTION
4884: WHEN FND_API.G_EXC_ERROR THEN
4885: RAISE FND_API.G_EXC_ERROR;
4886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4888: WHEN OTHERS THEN

Line 4885: RAISE FND_API.G_EXC_ERROR;

4881: 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);
4882: END IF;
4883: EXCEPTION
4884: WHEN FND_API.G_EXC_ERROR THEN
4885: RAISE FND_API.G_EXC_ERROR;
4886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4888: WHEN OTHERS THEN
4889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4882: END IF;
4883: EXCEPTION
4884: WHEN FND_API.G_EXC_ERROR THEN
4885: RAISE FND_API.G_EXC_ERROR;
4886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4888: WHEN OTHERS THEN
4889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4890: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_party_sites');

Line 4887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4883: EXCEPTION
4884: WHEN FND_API.G_EXC_ERROR THEN
4885: RAISE FND_API.G_EXC_ERROR;
4886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4888: WHEN OTHERS THEN
4889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4890: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_party_sites');
4891: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4890: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_party_sites');
4891: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4892: FND_MSG_PUB.ADD;
4893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4894: END get_matching_party_sites;
4895:
4896:
4897: PROCEDURE get_matching_contacts (

Line 5109: WHEN FND_API.G_EXC_ERROR THEN

5105: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5106: 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);
5107: END IF;
5108: EXCEPTION
5109: WHEN FND_API.G_EXC_ERROR THEN
5110: RAISE FND_API.G_EXC_ERROR;
5111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5113: WHEN OTHERS THEN

Line 5110: RAISE FND_API.G_EXC_ERROR;

5106: 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);
5107: END IF;
5108: EXCEPTION
5109: WHEN FND_API.G_EXC_ERROR THEN
5110: RAISE FND_API.G_EXC_ERROR;
5111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5113: WHEN OTHERS THEN
5114: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5107: END IF;
5108: EXCEPTION
5109: WHEN FND_API.G_EXC_ERROR THEN
5110: RAISE FND_API.G_EXC_ERROR;
5111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5113: WHEN OTHERS THEN
5114: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5115: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_contacts');

Line 5112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5108: EXCEPTION
5109: WHEN FND_API.G_EXC_ERROR THEN
5110: RAISE FND_API.G_EXC_ERROR;
5111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5113: WHEN OTHERS THEN
5114: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5115: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_contacts');
5116: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5114: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5115: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_contacts');
5116: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5117: FND_MSG_PUB.ADD;
5118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5119: END get_matching_contacts;
5120:
5121:
5122: PROCEDURE get_matching_contact_points (

Line 5248: WHEN FND_API.G_EXC_ERROR THEN

5244: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5245: 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);
5246: END IF;
5247: EXCEPTION
5248: WHEN FND_API.G_EXC_ERROR THEN
5249: RAISE FND_API.G_EXC_ERROR;
5250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5252: WHEN OTHERS THEN

Line 5249: RAISE FND_API.G_EXC_ERROR;

5245: 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);
5246: END IF;
5247: EXCEPTION
5248: WHEN FND_API.G_EXC_ERROR THEN
5249: RAISE FND_API.G_EXC_ERROR;
5250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5252: WHEN OTHERS THEN
5253: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 5251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5253: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5254: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_matching_contact_points');
5255: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5256: FND_MSG_PUB.ADD;
5257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5258: END get_matching_contact_points;
5259:
5260: /**********************************************************
5261: This procedure finds the score details for a specific party that

Line 5471: WHEN FND_API.G_EXC_ERROR THEN

5467: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5468: 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);
5469: END IF;
5470: EXCEPTION
5471: WHEN FND_API.G_EXC_ERROR THEN
5472: RAISE FND_API.G_EXC_ERROR;
5473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5475: WHEN OTHERS THEN

Line 5472: RAISE FND_API.G_EXC_ERROR;

5468: 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);
5469: END IF;
5470: EXCEPTION
5471: WHEN FND_API.G_EXC_ERROR THEN
5472: RAISE FND_API.G_EXC_ERROR;
5473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5475: WHEN OTHERS THEN
5476: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5469: END IF;
5470: EXCEPTION
5471: WHEN FND_API.G_EXC_ERROR THEN
5472: RAISE FND_API.G_EXC_ERROR;
5473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5475: WHEN OTHERS THEN
5476: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5477: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_score_details');

Line 5474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5470: EXCEPTION
5471: WHEN FND_API.G_EXC_ERROR THEN
5472: RAISE FND_API.G_EXC_ERROR;
5473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5475: WHEN OTHERS THEN
5476: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5477: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_score_details');
5478: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5476: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5477: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_37.get_score_details');
5478: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5479: FND_MSG_PUB.ADD;
5480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5481: END get_score_details;
5482:
5483:
5484: /************************************************

Line 5549: WHEN FND_API.G_EXC_ERROR THEN

5545: END LOOP;
5546: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5547: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5548: EXCEPTION
5549: WHEN FND_API.G_EXC_ERROR THEN
5550: RAISE FND_API.G_EXC_ERROR;
5551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5553: WHEN OTHERS THEN

Line 5550: RAISE FND_API.G_EXC_ERROR;

5546: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5547: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5548: EXCEPTION
5549: WHEN FND_API.G_EXC_ERROR THEN
5550: RAISE FND_API.G_EXC_ERROR;
5551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5553: WHEN OTHERS THEN
5554: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5547: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5548: EXCEPTION
5549: WHEN FND_API.G_EXC_ERROR THEN
5550: RAISE FND_API.G_EXC_ERROR;
5551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5553: WHEN OTHERS THEN
5554: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5555: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5548: EXCEPTION
5549: WHEN FND_API.G_EXC_ERROR THEN
5550: RAISE FND_API.G_EXC_ERROR;
5551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5553: WHEN OTHERS THEN
5554: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5555: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5556: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5554: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5555: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5556: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5557: FND_MSG_PUB.ADD;
5558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5559: END get_party_for_search;
5560:
5561: PROCEDURE get_search_criteria (
5562: p_party_id IN NUMBER,

Line 5583: WHEN FND_API.G_EXC_ERROR THEN

5579: END IF;
5580: get_party_site_rec(p_party_site_ids, x_party_site_list);
5581: END IF;
5582: EXCEPTION
5583: WHEN FND_API.G_EXC_ERROR THEN
5584: RAISE FND_API.G_EXC_ERROR;
5585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5587: WHEN OTHERS THEN

Line 5584: RAISE FND_API.G_EXC_ERROR;

5580: get_party_site_rec(p_party_site_ids, x_party_site_list);
5581: END IF;
5582: EXCEPTION
5583: WHEN FND_API.G_EXC_ERROR THEN
5584: RAISE FND_API.G_EXC_ERROR;
5585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5587: WHEN OTHERS THEN
5588: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5581: END IF;
5582: EXCEPTION
5583: WHEN FND_API.G_EXC_ERROR THEN
5584: RAISE FND_API.G_EXC_ERROR;
5585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5587: WHEN OTHERS THEN
5588: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5589: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5582: EXCEPTION
5583: WHEN FND_API.G_EXC_ERROR THEN
5584: RAISE FND_API.G_EXC_ERROR;
5585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5587: WHEN OTHERS THEN
5588: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5589: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5590: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5588: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5589: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5590: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5591: FND_MSG_PUB.ADD;
5592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5593: END get_search_criteria;
5594:
5595:
5596: /************************************************

Line 5635: RAISE FND_API.G_EXC_ERROR;

5631: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5632: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5633: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5634: FND_MSG_PUB.ADD;
5635: RAISE FND_API.G_EXC_ERROR;
5636: END get_party_rec;
5637:
5638: /************************************************
5639: This procedure retrieves the match rule party site attributes into

Line 5701: RAISE FND_API.G_EXC_ERROR;

5697: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5698: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5699: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5700: FND_MSG_PUB.ADD;
5701: RAISE FND_API.G_EXC_ERROR;
5702: END get_party_site_rec;
5703:
5704: /************************************************
5705: This procedure retrieves the match rule contact attributes into

Line 5757: RAISE FND_API.G_EXC_ERROR;

5753: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5754: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5755: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5756: FND_MSG_PUB.ADD;
5757: RAISE FND_API.G_EXC_ERROR;
5758: END get_contact_rec;
5759:
5760: /************************************************
5761: This procedure retrieves the match rule contact point attributes into

Line 5809: RAISE FND_API.G_EXC_ERROR;

5805: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5806: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5807: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5808: FND_MSG_PUB.ADD;
5809: RAISE FND_API.G_EXC_ERROR;
5810: END get_contact_point_rec;
5811:
5812: /************************************************
5813: This procedure maps a search record from the logical

Line 5860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5856: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
5857: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
5858: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
5859: FND_MSG_PUB.ADD;
5860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5861: END;
5862:
5863:
5864: /************************************************

Line 6130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6126: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6127: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6128: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6129: FND_MSG_PUB.ADD;
6130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6131: END;
6132:
6133:
6134: /************************************************

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_CONTACT_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_CONTACT_POINT_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 6270: WHEN FND_API.G_EXC_ERROR THEN

6266: END IF;
6267: END LOOP;
6268: RETURN FALSE;
6269: EXCEPTION
6270: WHEN FND_API.G_EXC_ERROR THEN
6271: RAISE FND_API.G_EXC_ERROR;
6272: WHEN OTHERS THEN
6273: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6274: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6271: RAISE FND_API.G_EXC_ERROR;

6267: END LOOP;
6268: RETURN FALSE;
6269: EXCEPTION
6270: WHEN FND_API.G_EXC_ERROR THEN
6271: RAISE FND_API.G_EXC_ERROR;
6272: WHEN OTHERS THEN
6273: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6274: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6275: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6273: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6274: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6275: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6276: FND_MSG_PUB.ADD;
6277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6278: END check_prim_cond;
6279:
6280: /************************************************
6281: This procedure checks if the input search condition

Line 6333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6329: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6330: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6331: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6332: FND_MSG_PUB.ADD;
6333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6334: END check_party_site_cond;
6335:
6336: /************************************************
6337: This procedure checks if the input search condition

Line 6371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6367: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6368: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6370: FND_MSG_PUB.ADD;
6371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6372: END check_contact_cond;
6373:
6374: /************************************************
6375: This procedure checks if the input search condition

Line 6392: RAISE FND_API.G_EXC_ERROR;

6388: FOR I IN 1..p_contact_point_list.COUNT LOOP
6389: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6390: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6391: FND_MSG_PUB.ADD;
6392: RAISE FND_API.G_EXC_ERROR;
6393: END IF;
6394: END LOOP;
6395:
6396: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6404: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6405: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6407: FND_MSG_PUB.ADD;
6408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6409: END check_contact_point_cond;
6410:
6411: FUNCTION check_staged RETURN BOOLEAN IS
6412: