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_35 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 788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

784: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
785: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
786: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
787: FND_MSG_PUB.ADD;
788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
789: END;
790:
791:
792: /************************************************

Line 813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

809: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
810: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
811: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
812: FND_MSG_PUB.ADD;
813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
814: END;
815:
816:
817: /************************************************

Line 833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

829: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
830: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
831: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
832: FND_MSG_PUB.ADD;
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: END;
835:
836:
837: /************************************************

Line 853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

849: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
850: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
851: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
852: FND_MSG_PUB.ADD;
853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
854: END;
855:
856: PROCEDURE init_score_context (
857: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 920: RAISE FND_API.G_EXC_ERROR;

916: p_contact_list,
917: p_contact_point_list) THEN
918: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
919: FND_MSG_PUB.ADD;
920: RAISE FND_API.G_EXC_ERROR;
921: END IF;
922: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
923: 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);
924: END IF;

Line 1191: RAISE FND_API.G_EXC_ERROR;

1187: IF lengthb(l_party_contains_str) > 4000 THEN
1188: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1189: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1190: FND_MSG_PUB.ADD;
1191: RAISE FND_API.G_EXC_ERROR;
1192: END IF;
1193: IF (p_match_str = ' AND ' OR p_party_max_score 1194: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1195: 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 1280: RAISE FND_API.G_EXC_ERROR;

1276: IF lengthb(l_contains_str) > 4000 THEN
1277: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1278: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1279: FND_MSG_PUB.ADD;
1280: RAISE FND_API.G_EXC_ERROR;
1281: END IF;
1282: x_denorm_str := l_den_contains_str;
1283: RETURN l_contains_str;
1284: END;

Line 1574: RAISE FND_API.G_EXC_ERROR;

1570: when others then
1571: if (instrb(SQLERRM,'DRG-51030')>0) then
1572: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1573: FND_MSG_PUB.ADD;
1574: RAISE FND_API.G_EXC_ERROR;
1575: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1576: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1577: FND_MSG_PUB.ADD;
1578: RAISE FND_API.G_EXC_ERROR;

Line 1578: RAISE FND_API.G_EXC_ERROR;

1574: RAISE FND_API.G_EXC_ERROR;
1575: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1576: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1577: FND_MSG_PUB.ADD;
1578: RAISE FND_API.G_EXC_ERROR;
1579: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1580: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1581: FND_MSG_PUB.ADD;
1582: RAISE FND_API.G_EXC_ERROR;

Line 1582: RAISE FND_API.G_EXC_ERROR;

1578: RAISE FND_API.G_EXC_ERROR;
1579: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1580: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1581: FND_MSG_PUB.ADD;
1582: RAISE FND_API.G_EXC_ERROR;
1583: else
1584: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1585: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1586: FND_MSG_PUB.ADD;

Line 1587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1583: else
1584: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1585: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1586: FND_MSG_PUB.ADD;
1587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1588: end if;
1589: END;
1590:
1591: PROCEDURE open_party_site_cursor(

Line 1819: RAISE FND_API.G_EXC_ERROR;

1815: when others then
1816: if (instrb(SQLERRM,'DRG-51030')>0) then
1817: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1818: FND_MSG_PUB.ADD;
1819: RAISE FND_API.G_EXC_ERROR;
1820: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1821: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1822: FND_MSG_PUB.ADD;
1823: RAISE FND_API.G_EXC_ERROR;

Line 1823: RAISE FND_API.G_EXC_ERROR;

1819: RAISE FND_API.G_EXC_ERROR;
1820: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1821: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1822: FND_MSG_PUB.ADD;
1823: RAISE FND_API.G_EXC_ERROR;
1824: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1825: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1826: FND_MSG_PUB.ADD;
1827: RAISE FND_API.G_EXC_ERROR;

Line 1827: RAISE FND_API.G_EXC_ERROR;

1823: RAISE FND_API.G_EXC_ERROR;
1824: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1825: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1826: FND_MSG_PUB.ADD;
1827: RAISE FND_API.G_EXC_ERROR;
1828: else
1829: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1830: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1831: FND_MSG_PUB.ADD;

Line 1832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1828: else
1829: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1830: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1831: FND_MSG_PUB.ADD;
1832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1833: end if;
1834: END;
1835:
1836: PROCEDURE open_contact_cursor(

Line 1966: RAISE FND_API.G_EXC_ERROR;

1962: when others then
1963: if (instrb(SQLERRM,'DRG-51030')>0) then
1964: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1965: FND_MSG_PUB.ADD;
1966: RAISE FND_API.G_EXC_ERROR;
1967: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1968: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1969: FND_MSG_PUB.ADD;
1970: RAISE FND_API.G_EXC_ERROR;

Line 1970: RAISE FND_API.G_EXC_ERROR;

1966: RAISE FND_API.G_EXC_ERROR;
1967: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1968: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1969: FND_MSG_PUB.ADD;
1970: RAISE FND_API.G_EXC_ERROR;
1971: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1973: FND_MSG_PUB.ADD;
1974: RAISE FND_API.G_EXC_ERROR;

Line 1974: RAISE FND_API.G_EXC_ERROR;

1970: RAISE FND_API.G_EXC_ERROR;
1971: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1972: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1973: FND_MSG_PUB.ADD;
1974: RAISE FND_API.G_EXC_ERROR;
1975: else
1976: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1977: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1978: FND_MSG_PUB.ADD;

Line 1979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1975: else
1976: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1977: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1978: FND_MSG_PUB.ADD;
1979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1980: end if;
1981: END;
1982:
1983: PROCEDURE open_contact_pt_cursor(

Line 2239: RAISE FND_API.G_EXC_ERROR;

2235: when others then
2236: if (instrb(SQLERRM,'DRG-51030')>0) then
2237: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2238: FND_MSG_PUB.ADD;
2239: RAISE FND_API.G_EXC_ERROR;
2240: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2241: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2242: FND_MSG_PUB.ADD;
2243: RAISE FND_API.G_EXC_ERROR;

Line 2243: RAISE FND_API.G_EXC_ERROR;

2239: RAISE FND_API.G_EXC_ERROR;
2240: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2241: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2242: FND_MSG_PUB.ADD;
2243: RAISE FND_API.G_EXC_ERROR;
2244: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2245: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2246: FND_MSG_PUB.ADD;
2247: RAISE FND_API.G_EXC_ERROR;

Line 2247: RAISE FND_API.G_EXC_ERROR;

2243: RAISE FND_API.G_EXC_ERROR;
2244: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2245: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2246: FND_MSG_PUB.ADD;
2247: RAISE FND_API.G_EXC_ERROR;
2248: else
2249: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2250: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2251: FND_MSG_PUB.ADD;

Line 2252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2248: else
2249: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2250: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2251: FND_MSG_PUB.ADD;
2252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2253: end if;
2254: END;
2255:
2256:

Line 2507: RAISE FND_API.G_EXC_ERROR;

2503: 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);
2504: END IF;
2505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2506: FND_MSG_PUB.ADD;
2507: RAISE FND_API.G_EXC_ERROR;
2508: ELSE
2509: push_eval;
2510: RETURN;
2511: END IF;

Line 2555: RAISE FND_API.G_EXC_ERROR;

2551: 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);
2552: END IF;
2553: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2554: FND_MSG_PUB.ADD;
2555: RAISE FND_API.G_EXC_ERROR;
2556: ELSE
2557: push_eval;
2558: RETURN;
2559: END IF;

Line 2628: RAISE FND_API.G_EXC_ERROR;

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

Line 2740: RAISE FND_API.G_EXC_ERROR;

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

Line 2851: RAISE FND_API.G_EXC_ERROR;

2847: 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);
2848: END IF;
2849: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2850: FND_MSG_PUB.ADD;
2851: RAISE FND_API.G_EXC_ERROR;
2852: ELSE
2853: push_eval;
2854: RETURN;
2855: END IF;

Line 3076: RAISE FND_API.G_EXC_ERROR;

3072: 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);
3073: END IF;
3074: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3075: FND_MSG_PUB.ADD;
3076: RAISE FND_API.G_EXC_ERROR;
3077: END IF;
3078: ELSE
3079: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3080: 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 3084: RAISE FND_API.G_EXC_ERROR;

3080: 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);
3081: END IF;
3082: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3083: FND_MSG_PUB.ADD;
3084: RAISE FND_API.G_EXC_ERROR;
3085: END IF;
3086: END IF;
3087: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3088: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3283: WHEN FND_API.G_EXC_ERROR THEN

3279: END IF;
3280: EXCEPTION
3281: WHEN L_RETURN_IMM_EXC THEN
3282: RETURN;
3283: WHEN FND_API.G_EXC_ERROR THEN
3284: RAISE FND_API.G_EXC_ERROR;
3285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3287: WHEN OTHERS THEN

Line 3284: RAISE FND_API.G_EXC_ERROR;

3280: EXCEPTION
3281: WHEN L_RETURN_IMM_EXC THEN
3282: RETURN;
3283: WHEN FND_API.G_EXC_ERROR THEN
3284: RAISE FND_API.G_EXC_ERROR;
3285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3287: WHEN OTHERS THEN
3288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3281: WHEN L_RETURN_IMM_EXC THEN
3282: RETURN;
3283: WHEN FND_API.G_EXC_ERROR THEN
3284: RAISE FND_API.G_EXC_ERROR;
3285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3287: WHEN OTHERS THEN
3288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_parties');

Line 3286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3282: RETURN;
3283: WHEN FND_API.G_EXC_ERROR THEN
3284: RAISE FND_API.G_EXC_ERROR;
3285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3287: WHEN OTHERS THEN
3288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_parties');
3290: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_parties');
3290: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3291: FND_MSG_PUB.ADD;
3292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3293: END find_parties;
3294:
3295: PROCEDURE find_persons (
3296: p_rule_id IN NUMBER,

Line 3487: RAISE FND_API.G_EXC_ERROR;

3483: 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);
3484: END IF;
3485: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3486: FND_MSG_PUB.ADD;
3487: RAISE FND_API.G_EXC_ERROR;
3488: ELSE
3489: push_eval;
3490: RETURN;
3491: END IF;

Line 3535: RAISE FND_API.G_EXC_ERROR;

3531: 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);
3532: END IF;
3533: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3534: FND_MSG_PUB.ADD;
3535: RAISE FND_API.G_EXC_ERROR;
3536: ELSE
3537: push_eval;
3538: RETURN;
3539: END IF;

Line 3571: RAISE FND_API.G_EXC_ERROR;

3567: when others then
3568: if (instrb(SQLERRM,'DRG-51030')>0) then
3569: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3570: FND_MSG_PUB.ADD;
3571: RAISE FND_API.G_EXC_ERROR;
3572: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3573: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3574: FND_MSG_PUB.ADD;
3575: RAISE FND_API.G_EXC_ERROR;

Line 3575: RAISE FND_API.G_EXC_ERROR;

3571: RAISE FND_API.G_EXC_ERROR;
3572: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3573: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3574: FND_MSG_PUB.ADD;
3575: RAISE FND_API.G_EXC_ERROR;
3576: else
3577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3578: end if;
3579: END;

Line 3577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3573: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3574: FND_MSG_PUB.ADD;
3575: RAISE FND_API.G_EXC_ERROR;
3576: else
3577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3578: end if;
3579: END;
3580:
3581: /** Private procedure to acquire and score at party site level ***/

Line 3647: RAISE FND_API.G_EXC_ERROR;

3643: 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);
3644: END IF;
3645: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3646: FND_MSG_PUB.ADD;
3647: RAISE FND_API.G_EXC_ERROR;
3648: ELSE
3649: push_eval;
3650: RETURN;
3651: END IF;

Line 3906: RAISE FND_API.G_EXC_ERROR;

3902: 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);
3903: END IF;
3904: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3905: FND_MSG_PUB.ADD;
3906: RAISE FND_API.G_EXC_ERROR;
3907: ELSE
3908: push_eval;
3909: RETURN;
3910: END IF;

Line 4019: RAISE FND_API.G_EXC_ERROR;

4015: 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);
4016: END IF;
4017: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4018: FND_MSG_PUB.ADD;
4019: RAISE FND_API.G_EXC_ERROR;
4020: END IF;
4021: ELSE
4022: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4023: 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 4027: RAISE FND_API.G_EXC_ERROR;

4023: 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);
4024: END IF;
4025: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4026: FND_MSG_PUB.ADD;
4027: RAISE FND_API.G_EXC_ERROR;
4028: END IF;
4029: END IF;
4030: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
4031: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4141: WHEN FND_API.G_EXC_ERROR THEN

4137: END IF;
4138: EXCEPTION
4139: WHEN L_RETURN_IMM_EXC THEN
4140: RETURN;
4141: WHEN FND_API.G_EXC_ERROR THEN
4142: RAISE FND_API.G_EXC_ERROR;
4143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4145: WHEN OTHERS THEN

Line 4142: RAISE FND_API.G_EXC_ERROR;

4138: EXCEPTION
4139: WHEN L_RETURN_IMM_EXC THEN
4140: RETURN;
4141: WHEN FND_API.G_EXC_ERROR THEN
4142: RAISE FND_API.G_EXC_ERROR;
4143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4145: WHEN OTHERS THEN
4146: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4139: WHEN L_RETURN_IMM_EXC THEN
4140: RETURN;
4141: WHEN FND_API.G_EXC_ERROR THEN
4142: RAISE FND_API.G_EXC_ERROR;
4143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4145: WHEN OTHERS THEN
4146: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4147: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_persons');

Line 4144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4140: RETURN;
4141: WHEN FND_API.G_EXC_ERROR THEN
4142: RAISE FND_API.G_EXC_ERROR;
4143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4145: WHEN OTHERS THEN
4146: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4147: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_persons');
4148: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4146: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4147: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_persons');
4148: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4149: FND_MSG_PUB.ADD;
4150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4151: END find_persons;
4152:
4153: PROCEDURE find_persons (
4154: p_rule_id IN NUMBER,

Line 4209: WHEN FND_API.G_EXC_ERROR THEN

4205: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4206: 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);
4207: END IF;
4208: EXCEPTION
4209: WHEN FND_API.G_EXC_ERROR THEN
4210: RAISE FND_API.G_EXC_ERROR;
4211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4213: WHEN OTHERS THEN

Line 4210: RAISE FND_API.G_EXC_ERROR;

4206: 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);
4207: END IF;
4208: EXCEPTION
4209: WHEN FND_API.G_EXC_ERROR THEN
4210: RAISE FND_API.G_EXC_ERROR;
4211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4213: WHEN OTHERS THEN
4214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4207: END IF;
4208: EXCEPTION
4209: WHEN FND_API.G_EXC_ERROR THEN
4210: RAISE FND_API.G_EXC_ERROR;
4211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4213: WHEN OTHERS THEN
4214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4215: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_party_details');

Line 4212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4208: EXCEPTION
4209: WHEN FND_API.G_EXC_ERROR THEN
4210: RAISE FND_API.G_EXC_ERROR;
4211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4213: WHEN OTHERS THEN
4214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4215: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_party_details');
4216: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4214: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4215: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_party_details');
4216: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4217: FND_MSG_PUB.ADD;
4218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4219: END find_party_details;
4220:
4221: PROCEDURE find_duplicate_parties (
4222: p_rule_id IN NUMBER,

Line 4326: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4327: RAISE FND_API.G_EXC_ERROR;

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

Line 4328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4324: END IF;
4325: EXCEPTION
4326: WHEN FND_API.G_EXC_ERROR THEN
4327: RAISE FND_API.G_EXC_ERROR;
4328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4330: WHEN OTHERS THEN
4331: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4332: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_parties');

Line 4329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4325: EXCEPTION
4326: WHEN FND_API.G_EXC_ERROR THEN
4327: RAISE FND_API.G_EXC_ERROR;
4328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4330: WHEN OTHERS THEN
4331: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4332: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_parties');
4333: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4411: WHEN FND_API.G_EXC_ERROR THEN

4407: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4408: 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);
4409: END IF;
4410: EXCEPTION
4411: WHEN FND_API.G_EXC_ERROR THEN
4412: RAISE FND_API.G_EXC_ERROR;
4413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4415: WHEN OTHERS THEN

Line 4412: RAISE FND_API.G_EXC_ERROR;

4408: 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);
4409: END IF;
4410: EXCEPTION
4411: WHEN FND_API.G_EXC_ERROR THEN
4412: RAISE FND_API.G_EXC_ERROR;
4413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4415: WHEN OTHERS THEN
4416: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4409: END IF;
4410: EXCEPTION
4411: WHEN FND_API.G_EXC_ERROR THEN
4412: RAISE FND_API.G_EXC_ERROR;
4413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4415: WHEN OTHERS THEN
4416: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4417: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_party_sites');

Line 4414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4410: EXCEPTION
4411: WHEN FND_API.G_EXC_ERROR THEN
4412: RAISE FND_API.G_EXC_ERROR;
4413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4415: WHEN OTHERS THEN
4416: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4417: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_party_sites');
4418: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4416: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4417: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_party_sites');
4418: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4419: FND_MSG_PUB.ADD;
4420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4421: END find_duplicate_party_sites;
4422:
4423: PROCEDURE find_duplicate_contacts (
4424: p_rule_id IN NUMBER,

Line 4500: WHEN FND_API.G_EXC_ERROR THEN

4496: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4497: 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);
4498: END IF;
4499: EXCEPTION
4500: WHEN FND_API.G_EXC_ERROR THEN
4501: RAISE FND_API.G_EXC_ERROR;
4502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4504: WHEN OTHERS THEN

Line 4501: RAISE FND_API.G_EXC_ERROR;

4497: 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);
4498: END IF;
4499: EXCEPTION
4500: WHEN FND_API.G_EXC_ERROR THEN
4501: RAISE FND_API.G_EXC_ERROR;
4502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4504: WHEN OTHERS THEN
4505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4498: END IF;
4499: EXCEPTION
4500: WHEN FND_API.G_EXC_ERROR THEN
4501: RAISE FND_API.G_EXC_ERROR;
4502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4504: WHEN OTHERS THEN
4505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4506: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contacts');

Line 4503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4499: EXCEPTION
4500: WHEN FND_API.G_EXC_ERROR THEN
4501: RAISE FND_API.G_EXC_ERROR;
4502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4504: WHEN OTHERS THEN
4505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4506: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contacts');
4507: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4505: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4506: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contacts');
4507: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4508: FND_MSG_PUB.ADD;
4509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4510: END find_duplicate_contacts;
4511:
4512: PROCEDURE find_duplicate_contact_points (
4513: p_rule_id IN NUMBER,

Line 4573: WHEN FND_API.G_EXC_ERROR THEN

4569: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4570: 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);
4571: END IF;
4572: EXCEPTION
4573: WHEN FND_API.G_EXC_ERROR THEN
4574: RAISE FND_API.G_EXC_ERROR;
4575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4577: WHEN OTHERS THEN

Line 4574: RAISE FND_API.G_EXC_ERROR;

4570: 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);
4571: END IF;
4572: EXCEPTION
4573: WHEN FND_API.G_EXC_ERROR THEN
4574: RAISE FND_API.G_EXC_ERROR;
4575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4577: WHEN OTHERS THEN
4578: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4571: END IF;
4572: EXCEPTION
4573: WHEN FND_API.G_EXC_ERROR THEN
4574: RAISE FND_API.G_EXC_ERROR;
4575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4577: WHEN OTHERS THEN
4578: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4579: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contact_points');

Line 4576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4572: EXCEPTION
4573: WHEN FND_API.G_EXC_ERROR THEN
4574: RAISE FND_API.G_EXC_ERROR;
4575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4577: WHEN OTHERS THEN
4578: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4579: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contact_points');
4580: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4578: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4579: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.find_duplicate_contact_points');
4580: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4581: FND_MSG_PUB.ADD;
4582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4583: END find_duplicate_contact_points;
4584:
4585: PROCEDURE find_parties_dynamic (
4586: p_rule_id IN NUMBER,

Line 4861: WHEN FND_API.G_EXC_ERROR THEN

4857: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4858: 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);
4859: END IF;
4860: EXCEPTION
4861: WHEN FND_API.G_EXC_ERROR THEN
4862: RAISE FND_API.G_EXC_ERROR;
4863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4865: WHEN OTHERS THEN

Line 4862: RAISE FND_API.G_EXC_ERROR;

4858: 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);
4859: END IF;
4860: EXCEPTION
4861: WHEN FND_API.G_EXC_ERROR THEN
4862: RAISE FND_API.G_EXC_ERROR;
4863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4865: WHEN OTHERS THEN
4866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4859: END IF;
4860: EXCEPTION
4861: WHEN FND_API.G_EXC_ERROR THEN
4862: RAISE FND_API.G_EXC_ERROR;
4863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4865: WHEN OTHERS THEN
4866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.call_api_dynamic');

Line 4864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4860: EXCEPTION
4861: WHEN FND_API.G_EXC_ERROR THEN
4862: RAISE FND_API.G_EXC_ERROR;
4863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4865: WHEN OTHERS THEN
4866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.call_api_dynamic');
4868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.call_api_dynamic');
4868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4869: FND_MSG_PUB.ADD;
4870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4871: END call_api_dynamic;
4872:
4873:
4874: PROCEDURE get_matching_party_sites (

Line 5099: WHEN FND_API.G_EXC_ERROR THEN

5095: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5096: 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);
5097: END IF;
5098: EXCEPTION
5099: WHEN FND_API.G_EXC_ERROR THEN
5100: RAISE FND_API.G_EXC_ERROR;
5101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5103: WHEN OTHERS THEN

Line 5100: RAISE FND_API.G_EXC_ERROR;

5096: 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);
5097: END IF;
5098: EXCEPTION
5099: WHEN FND_API.G_EXC_ERROR THEN
5100: RAISE FND_API.G_EXC_ERROR;
5101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5103: WHEN OTHERS THEN
5104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5097: END IF;
5098: EXCEPTION
5099: WHEN FND_API.G_EXC_ERROR THEN
5100: RAISE FND_API.G_EXC_ERROR;
5101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5103: WHEN OTHERS THEN
5104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5105: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_party_sites');

Line 5102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5098: EXCEPTION
5099: WHEN FND_API.G_EXC_ERROR THEN
5100: RAISE FND_API.G_EXC_ERROR;
5101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5103: WHEN OTHERS THEN
5104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5105: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_party_sites');
5106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5105: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_party_sites');
5106: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5107: FND_MSG_PUB.ADD;
5108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5109: END get_matching_party_sites;
5110:
5111:
5112: PROCEDURE get_matching_contacts (

Line 5324: WHEN FND_API.G_EXC_ERROR THEN

5320: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5321: 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);
5322: END IF;
5323: EXCEPTION
5324: WHEN FND_API.G_EXC_ERROR THEN
5325: RAISE FND_API.G_EXC_ERROR;
5326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5328: WHEN OTHERS THEN

Line 5325: RAISE FND_API.G_EXC_ERROR;

5321: 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);
5322: END IF;
5323: EXCEPTION
5324: WHEN FND_API.G_EXC_ERROR THEN
5325: RAISE FND_API.G_EXC_ERROR;
5326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5328: WHEN OTHERS THEN
5329: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5322: END IF;
5323: EXCEPTION
5324: WHEN FND_API.G_EXC_ERROR THEN
5325: RAISE FND_API.G_EXC_ERROR;
5326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5328: WHEN OTHERS THEN
5329: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5330: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contacts');

Line 5327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5323: EXCEPTION
5324: WHEN FND_API.G_EXC_ERROR THEN
5325: RAISE FND_API.G_EXC_ERROR;
5326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5328: WHEN OTHERS THEN
5329: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5330: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contacts');
5331: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5329: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5330: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contacts');
5331: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5332: FND_MSG_PUB.ADD;
5333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5334: END get_matching_contacts;
5335:
5336:
5337: PROCEDURE get_matching_contact_points (

Line 5463: WHEN FND_API.G_EXC_ERROR THEN

5459: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5460: 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);
5461: END IF;
5462: EXCEPTION
5463: WHEN FND_API.G_EXC_ERROR THEN
5464: RAISE FND_API.G_EXC_ERROR;
5465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5467: WHEN OTHERS THEN

Line 5464: RAISE FND_API.G_EXC_ERROR;

5460: 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);
5461: END IF;
5462: EXCEPTION
5463: WHEN FND_API.G_EXC_ERROR THEN
5464: RAISE FND_API.G_EXC_ERROR;
5465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5467: WHEN OTHERS THEN
5468: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5461: END IF;
5462: EXCEPTION
5463: WHEN FND_API.G_EXC_ERROR THEN
5464: RAISE FND_API.G_EXC_ERROR;
5465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5467: WHEN OTHERS THEN
5468: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5469: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contact_points');

Line 5466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5462: EXCEPTION
5463: WHEN FND_API.G_EXC_ERROR THEN
5464: RAISE FND_API.G_EXC_ERROR;
5465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5467: WHEN OTHERS THEN
5468: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5469: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contact_points');
5470: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5468: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5469: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_matching_contact_points');
5470: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5471: FND_MSG_PUB.ADD;
5472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5473: END get_matching_contact_points;
5474:
5475: /**********************************************************
5476: This procedure finds the score details for a specific party that

Line 5681: WHEN FND_API.G_EXC_ERROR THEN

5677: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5678: 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);
5679: END IF;
5680: EXCEPTION
5681: WHEN FND_API.G_EXC_ERROR THEN
5682: RAISE FND_API.G_EXC_ERROR;
5683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5685: WHEN OTHERS THEN

Line 5682: RAISE FND_API.G_EXC_ERROR;

5678: 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);
5679: END IF;
5680: EXCEPTION
5681: WHEN FND_API.G_EXC_ERROR THEN
5682: RAISE FND_API.G_EXC_ERROR;
5683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5685: WHEN OTHERS THEN
5686: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5679: END IF;
5680: EXCEPTION
5681: WHEN FND_API.G_EXC_ERROR THEN
5682: RAISE FND_API.G_EXC_ERROR;
5683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5685: WHEN OTHERS THEN
5686: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5687: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_score_details');

Line 5684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5680: EXCEPTION
5681: WHEN FND_API.G_EXC_ERROR THEN
5682: RAISE FND_API.G_EXC_ERROR;
5683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5685: WHEN OTHERS THEN
5686: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5687: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_score_details');
5688: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5686: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5687: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_35.get_score_details');
5688: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5689: FND_MSG_PUB.ADD;
5690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5691: END get_score_details;
5692:
5693:
5694: /************************************************

Line 5759: WHEN FND_API.G_EXC_ERROR THEN

5755: END LOOP;
5756: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5757: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5758: EXCEPTION
5759: WHEN FND_API.G_EXC_ERROR THEN
5760: RAISE FND_API.G_EXC_ERROR;
5761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5763: WHEN OTHERS THEN

Line 5760: RAISE FND_API.G_EXC_ERROR;

5756: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5757: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5758: EXCEPTION
5759: WHEN FND_API.G_EXC_ERROR THEN
5760: RAISE FND_API.G_EXC_ERROR;
5761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5763: WHEN OTHERS THEN
5764: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5757: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5758: EXCEPTION
5759: WHEN FND_API.G_EXC_ERROR THEN
5760: RAISE FND_API.G_EXC_ERROR;
5761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5763: WHEN OTHERS THEN
5764: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5765: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5764: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5765: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5766: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5767: FND_MSG_PUB.ADD;
5768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5769: END get_party_for_search;
5770:
5771: PROCEDURE get_search_criteria (
5772: p_party_id IN NUMBER,

Line 5799: WHEN FND_API.G_EXC_ERROR THEN

5795: END IF;
5796: get_party_site_rec(p_party_site_ids, x_party_site_list);
5797: END IF;
5798: EXCEPTION
5799: WHEN FND_API.G_EXC_ERROR THEN
5800: RAISE FND_API.G_EXC_ERROR;
5801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5803: WHEN OTHERS THEN

Line 5800: RAISE FND_API.G_EXC_ERROR;

5796: get_party_site_rec(p_party_site_ids, x_party_site_list);
5797: END IF;
5798: EXCEPTION
5799: WHEN FND_API.G_EXC_ERROR THEN
5800: RAISE FND_API.G_EXC_ERROR;
5801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5803: WHEN OTHERS THEN
5804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5797: END IF;
5798: EXCEPTION
5799: WHEN FND_API.G_EXC_ERROR THEN
5800: RAISE FND_API.G_EXC_ERROR;
5801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5803: WHEN OTHERS THEN
5804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5805: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5798: EXCEPTION
5799: WHEN FND_API.G_EXC_ERROR THEN
5800: RAISE FND_API.G_EXC_ERROR;
5801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5803: WHEN OTHERS THEN
5804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5805: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5806: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5804: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5805: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5806: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5807: FND_MSG_PUB.ADD;
5808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5809: END get_search_criteria;
5810:
5811:
5812: /************************************************

Line 5873: RAISE FND_API.G_EXC_ERROR;

5869: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5870: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5871: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5872: FND_MSG_PUB.ADD;
5873: RAISE FND_API.G_EXC_ERROR;
5874: END get_party_rec;
5875:
5876: /************************************************
5877: This procedure retrieves the match rule party site attributes into

Line 5933: RAISE FND_API.G_EXC_ERROR;

5929: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5930: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5931: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5932: FND_MSG_PUB.ADD;
5933: RAISE FND_API.G_EXC_ERROR;
5934: END get_party_site_rec;
5935:
5936: /************************************************
5937: This procedure retrieves the match rule contact attributes into

Line 5989: RAISE FND_API.G_EXC_ERROR;

5985: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5986: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5987: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5988: FND_MSG_PUB.ADD;
5989: RAISE FND_API.G_EXC_ERROR;
5990: END get_contact_rec;
5991:
5992: /************************************************
5993: This procedure retrieves the match rule contact point attributes into

Line 6041: RAISE FND_API.G_EXC_ERROR;

6037: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6038: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6039: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6040: FND_MSG_PUB.ADD;
6041: RAISE FND_API.G_EXC_ERROR;
6042: END get_contact_point_rec;
6043:
6044: /************************************************
6045: This procedure maps a search record from the logical

Line 6194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6190: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6191: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6192: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6193: FND_MSG_PUB.ADD;
6194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6195: END;
6196:
6197:
6198: /************************************************

Line 6357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6353: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6354: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6355: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6356: FND_MSG_PUB.ADD;
6357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6358: END;
6359:
6360:
6361: /************************************************

Line 6399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6395: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6396: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6397: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6398: FND_MSG_PUB.ADD;
6399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6400: END;
6401:
6402:
6403: /************************************************

Line 6466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6462: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6463: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6464: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6465: FND_MSG_PUB.ADD;
6466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6467: END;
6468:
6469:
6470: /************************************************

Line 6518: WHEN FND_API.G_EXC_ERROR THEN

6514: END IF;
6515: END LOOP;
6516: RETURN FALSE;
6517: EXCEPTION
6518: WHEN FND_API.G_EXC_ERROR THEN
6519: RAISE FND_API.G_EXC_ERROR;
6520: WHEN OTHERS THEN
6521: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6522: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6519: RAISE FND_API.G_EXC_ERROR;

6515: END LOOP;
6516: RETURN FALSE;
6517: EXCEPTION
6518: WHEN FND_API.G_EXC_ERROR THEN
6519: RAISE FND_API.G_EXC_ERROR;
6520: WHEN OTHERS THEN
6521: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6522: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6523: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6521: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6522: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6523: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6524: FND_MSG_PUB.ADD;
6525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6526: END check_prim_cond;
6527:
6528: /************************************************
6529: This procedure checks if the input search condition

Line 6575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6571: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6572: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6573: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6574: FND_MSG_PUB.ADD;
6575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6576: END check_party_site_cond;
6577:
6578: /************************************************
6579: This procedure checks if the input search condition

Line 6613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6609: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6610: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6611: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6612: FND_MSG_PUB.ADD;
6613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6614: END check_contact_cond;
6615:
6616: /************************************************
6617: This procedure checks if the input search condition

Line 6634: RAISE FND_API.G_EXC_ERROR;

6630: FOR I IN 1..p_contact_point_list.COUNT LOOP
6631: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6632: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6633: FND_MSG_PUB.ADD;
6634: RAISE FND_API.G_EXC_ERROR;
6635: END IF;
6636: END LOOP;
6637:
6638: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6646: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6647: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6648: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6649: FND_MSG_PUB.ADD;
6650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6651: END check_contact_point_cond;
6652:
6653: FUNCTION check_staged RETURN BOOLEAN IS
6654: