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_61 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 666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

662: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
663: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
664: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
665: FND_MSG_PUB.ADD;
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: END;
668:
669:
670: /************************************************

Line 686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

682: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
683: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
684: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
685: FND_MSG_PUB.ADD;
686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
687: END;
688:
689:
690: /************************************************

Line 706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

702: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
703: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
705: FND_MSG_PUB.ADD;
706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
707: END;
708:
709:
710: /************************************************

Line 726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

722: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
723: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
724: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
725: FND_MSG_PUB.ADD;
726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
727: END;
728:
729: PROCEDURE init_score_context (
730: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 793: RAISE FND_API.G_EXC_ERROR;

789: p_contact_list,
790: p_contact_point_list) THEN
791: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
792: FND_MSG_PUB.ADD;
793: RAISE FND_API.G_EXC_ERROR;
794: END IF;
795: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
796: 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);
797: END IF;

Line 1085: RAISE FND_API.G_EXC_ERROR;

1081: IF lengthb(l_party_contains_str) > 4000 THEN
1082: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1083: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1084: FND_MSG_PUB.ADD;
1085: RAISE FND_API.G_EXC_ERROR;
1086: END IF;
1087: IF (p_match_str = ' AND ' OR p_party_max_score 1088: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1089: 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 1206: RAISE FND_API.G_EXC_ERROR;

1202: IF lengthb(l_contains_str) > 4000 THEN
1203: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1204: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1205: FND_MSG_PUB.ADD;
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208: x_denorm_str := l_den_contains_str;
1209: RETURN l_contains_str;
1210: END;

Line 1448: RAISE FND_API.G_EXC_ERROR;

1444: when others then
1445: if (instrb(SQLERRM,'DRG-51030')>0) then
1446: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1447: FND_MSG_PUB.ADD;
1448: RAISE FND_API.G_EXC_ERROR;
1449: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1451: FND_MSG_PUB.ADD;
1452: RAISE FND_API.G_EXC_ERROR;

Line 1452: RAISE FND_API.G_EXC_ERROR;

1448: RAISE FND_API.G_EXC_ERROR;
1449: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1451: FND_MSG_PUB.ADD;
1452: RAISE FND_API.G_EXC_ERROR;
1453: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1454: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1455: FND_MSG_PUB.ADD;
1456: RAISE FND_API.G_EXC_ERROR;

Line 1456: RAISE FND_API.G_EXC_ERROR;

1452: RAISE FND_API.G_EXC_ERROR;
1453: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1454: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1455: FND_MSG_PUB.ADD;
1456: RAISE FND_API.G_EXC_ERROR;
1457: else
1458: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1459: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1460: FND_MSG_PUB.ADD;

Line 1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1457: else
1458: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1459: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1460: FND_MSG_PUB.ADD;
1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1462: end if;
1463: END;
1464:
1465: PROCEDURE open_party_site_cursor(

Line 1693: RAISE FND_API.G_EXC_ERROR;

1689: when others then
1690: if (instrb(SQLERRM,'DRG-51030')>0) then
1691: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1692: FND_MSG_PUB.ADD;
1693: RAISE FND_API.G_EXC_ERROR;
1694: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1695: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1696: FND_MSG_PUB.ADD;
1697: RAISE FND_API.G_EXC_ERROR;

Line 1697: RAISE FND_API.G_EXC_ERROR;

1693: RAISE FND_API.G_EXC_ERROR;
1694: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1695: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1696: FND_MSG_PUB.ADD;
1697: RAISE FND_API.G_EXC_ERROR;
1698: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1699: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1700: FND_MSG_PUB.ADD;
1701: RAISE FND_API.G_EXC_ERROR;

Line 1701: RAISE FND_API.G_EXC_ERROR;

1697: RAISE FND_API.G_EXC_ERROR;
1698: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1699: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1700: FND_MSG_PUB.ADD;
1701: RAISE FND_API.G_EXC_ERROR;
1702: else
1703: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1705: FND_MSG_PUB.ADD;

Line 1706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1702: else
1703: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1704: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1705: FND_MSG_PUB.ADD;
1706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1707: end if;
1708: END;
1709:
1710: PROCEDURE open_contact_cursor(

Line 1840: RAISE FND_API.G_EXC_ERROR;

1836: when others then
1837: if (instrb(SQLERRM,'DRG-51030')>0) then
1838: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1839: FND_MSG_PUB.ADD;
1840: RAISE FND_API.G_EXC_ERROR;
1841: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1842: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1843: FND_MSG_PUB.ADD;
1844: RAISE FND_API.G_EXC_ERROR;

Line 1844: RAISE FND_API.G_EXC_ERROR;

1840: RAISE FND_API.G_EXC_ERROR;
1841: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1842: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1843: FND_MSG_PUB.ADD;
1844: RAISE FND_API.G_EXC_ERROR;
1845: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1846: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1847: FND_MSG_PUB.ADD;
1848: RAISE FND_API.G_EXC_ERROR;

Line 1848: RAISE FND_API.G_EXC_ERROR;

1844: RAISE FND_API.G_EXC_ERROR;
1845: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1846: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1847: FND_MSG_PUB.ADD;
1848: RAISE FND_API.G_EXC_ERROR;
1849: else
1850: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1851: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1852: FND_MSG_PUB.ADD;

Line 1853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1849: else
1850: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1851: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1852: FND_MSG_PUB.ADD;
1853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1854: end if;
1855: END;
1856:
1857: PROCEDURE open_contact_pt_cursor(

Line 2113: RAISE FND_API.G_EXC_ERROR;

2109: when others then
2110: if (instrb(SQLERRM,'DRG-51030')>0) then
2111: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2112: FND_MSG_PUB.ADD;
2113: RAISE FND_API.G_EXC_ERROR;
2114: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2115: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2116: FND_MSG_PUB.ADD;
2117: RAISE FND_API.G_EXC_ERROR;

Line 2117: RAISE FND_API.G_EXC_ERROR;

2113: RAISE FND_API.G_EXC_ERROR;
2114: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2115: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2116: FND_MSG_PUB.ADD;
2117: RAISE FND_API.G_EXC_ERROR;
2118: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2119: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2120: FND_MSG_PUB.ADD;
2121: RAISE FND_API.G_EXC_ERROR;

Line 2121: RAISE FND_API.G_EXC_ERROR;

2117: RAISE FND_API.G_EXC_ERROR;
2118: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2119: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2120: FND_MSG_PUB.ADD;
2121: RAISE FND_API.G_EXC_ERROR;
2122: else
2123: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2124: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2125: FND_MSG_PUB.ADD;

Line 2126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2122: else
2123: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2124: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2125: FND_MSG_PUB.ADD;
2126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2127: end if;
2128: END;
2129:
2130:

Line 2378: RAISE FND_API.G_EXC_ERROR;

2374: 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);
2375: END IF;
2376: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2377: FND_MSG_PUB.ADD;
2378: RAISE FND_API.G_EXC_ERROR;
2379: ELSE
2380: push_eval;
2381: RETURN;
2382: END IF;

Line 2428: RAISE FND_API.G_EXC_ERROR;

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

Line 2501: RAISE FND_API.G_EXC_ERROR;

2497: 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);
2498: END IF;
2499: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2500: FND_MSG_PUB.ADD;
2501: RAISE FND_API.G_EXC_ERROR;
2502: ELSE
2503: push_eval;
2504: RETURN;
2505: END IF;

Line 2613: RAISE FND_API.G_EXC_ERROR;

2609: 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);
2610: END IF;
2611: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2612: FND_MSG_PUB.ADD;
2613: RAISE FND_API.G_EXC_ERROR;
2614: ELSE
2615: push_eval;
2616: RETURN;
2617: END IF;

Line 2724: RAISE FND_API.G_EXC_ERROR;

2720: 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);
2721: END IF;
2722: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2723: FND_MSG_PUB.ADD;
2724: RAISE FND_API.G_EXC_ERROR;
2725: ELSE
2726: push_eval;
2727: RETURN;
2728: END IF;

Line 2949: RAISE FND_API.G_EXC_ERROR;

2945: 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);
2946: END IF;
2947: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2948: FND_MSG_PUB.ADD;
2949: RAISE FND_API.G_EXC_ERROR;
2950: END IF;
2951: ELSE
2952: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2953: 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 2957: RAISE FND_API.G_EXC_ERROR;

2953: 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);
2954: END IF;
2955: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2956: FND_MSG_PUB.ADD;
2957: RAISE FND_API.G_EXC_ERROR;
2958: END IF;
2959: END IF;
2960: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
2961: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 3156: WHEN FND_API.G_EXC_ERROR THEN

3152: END IF;
3153: EXCEPTION
3154: WHEN L_RETURN_IMM_EXC THEN
3155: RETURN;
3156: WHEN FND_API.G_EXC_ERROR THEN
3157: RAISE FND_API.G_EXC_ERROR;
3158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3160: WHEN OTHERS THEN

Line 3157: RAISE FND_API.G_EXC_ERROR;

3153: EXCEPTION
3154: WHEN L_RETURN_IMM_EXC THEN
3155: RETURN;
3156: WHEN FND_API.G_EXC_ERROR THEN
3157: RAISE FND_API.G_EXC_ERROR;
3158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3160: WHEN OTHERS THEN
3161: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 3158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3154: WHEN L_RETURN_IMM_EXC THEN
3155: RETURN;
3156: WHEN FND_API.G_EXC_ERROR THEN
3157: RAISE FND_API.G_EXC_ERROR;
3158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3160: WHEN OTHERS THEN
3161: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3162: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_parties');

Line 3159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3155: RETURN;
3156: WHEN FND_API.G_EXC_ERROR THEN
3157: RAISE FND_API.G_EXC_ERROR;
3158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3160: WHEN OTHERS THEN
3161: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3162: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_parties');
3163: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 3165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3161: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3162: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_parties');
3163: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3164: FND_MSG_PUB.ADD;
3165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3166: END find_parties;
3167:
3168: PROCEDURE find_persons (
3169: p_rule_id IN NUMBER,

Line 3357: RAISE FND_API.G_EXC_ERROR;

3353: 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);
3354: END IF;
3355: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3356: FND_MSG_PUB.ADD;
3357: RAISE FND_API.G_EXC_ERROR;
3358: ELSE
3359: push_eval;
3360: RETURN;
3361: END IF;

Line 3407: RAISE FND_API.G_EXC_ERROR;

3403: 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);
3404: END IF;
3405: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3406: FND_MSG_PUB.ADD;
3407: RAISE FND_API.G_EXC_ERROR;
3408: ELSE
3409: push_eval;
3410: RETURN;
3411: END IF;

Line 3443: RAISE FND_API.G_EXC_ERROR;

3439: when others then
3440: if (instrb(SQLERRM,'DRG-51030')>0) then
3441: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3442: FND_MSG_PUB.ADD;
3443: RAISE FND_API.G_EXC_ERROR;
3444: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3445: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3446: FND_MSG_PUB.ADD;
3447: RAISE FND_API.G_EXC_ERROR;

Line 3447: RAISE FND_API.G_EXC_ERROR;

3443: RAISE FND_API.G_EXC_ERROR;
3444: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3445: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3446: FND_MSG_PUB.ADD;
3447: RAISE FND_API.G_EXC_ERROR;
3448: else
3449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3450: end if;
3451: END;

Line 3449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3445: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3446: FND_MSG_PUB.ADD;
3447: RAISE FND_API.G_EXC_ERROR;
3448: else
3449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3450: end if;
3451: END;
3452:
3453: /** Private procedure to acquire and score at party site level ***/

Line 3519: RAISE FND_API.G_EXC_ERROR;

3515: 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);
3516: END IF;
3517: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3518: FND_MSG_PUB.ADD;
3519: RAISE FND_API.G_EXC_ERROR;
3520: ELSE
3521: push_eval;
3522: RETURN;
3523: END IF;

Line 3778: RAISE FND_API.G_EXC_ERROR;

3774: 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);
3775: END IF;
3776: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3777: FND_MSG_PUB.ADD;
3778: RAISE FND_API.G_EXC_ERROR;
3779: ELSE
3780: push_eval;
3781: RETURN;
3782: END IF;

Line 3891: RAISE FND_API.G_EXC_ERROR;

3887: 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);
3888: END IF;
3889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3890: FND_MSG_PUB.ADD;
3891: RAISE FND_API.G_EXC_ERROR;
3892: END IF;
3893: ELSE
3894: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3895: 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 3899: RAISE FND_API.G_EXC_ERROR;

3895: 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);
3896: END IF;
3897: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3898: FND_MSG_PUB.ADD;
3899: RAISE FND_API.G_EXC_ERROR;
3900: END IF;
3901: END IF;
3902: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3903: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4013: WHEN FND_API.G_EXC_ERROR THEN

4009: END IF;
4010: EXCEPTION
4011: WHEN L_RETURN_IMM_EXC THEN
4012: RETURN;
4013: WHEN FND_API.G_EXC_ERROR THEN
4014: RAISE FND_API.G_EXC_ERROR;
4015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4017: WHEN OTHERS THEN

Line 4014: RAISE FND_API.G_EXC_ERROR;

4010: EXCEPTION
4011: WHEN L_RETURN_IMM_EXC THEN
4012: RETURN;
4013: WHEN FND_API.G_EXC_ERROR THEN
4014: RAISE FND_API.G_EXC_ERROR;
4015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4017: WHEN OTHERS THEN
4018: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4011: WHEN L_RETURN_IMM_EXC THEN
4012: RETURN;
4013: WHEN FND_API.G_EXC_ERROR THEN
4014: RAISE FND_API.G_EXC_ERROR;
4015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4017: WHEN OTHERS THEN
4018: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4019: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_persons');

Line 4016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4012: RETURN;
4013: WHEN FND_API.G_EXC_ERROR THEN
4014: RAISE FND_API.G_EXC_ERROR;
4015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4017: WHEN OTHERS THEN
4018: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4019: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_persons');
4020: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4018: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4019: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_persons');
4020: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4021: FND_MSG_PUB.ADD;
4022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4023: END find_persons;
4024:
4025: PROCEDURE find_persons (
4026: p_rule_id IN NUMBER,

Line 4081: WHEN FND_API.G_EXC_ERROR THEN

4077: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4078: 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);
4079: END IF;
4080: EXCEPTION
4081: WHEN FND_API.G_EXC_ERROR THEN
4082: RAISE FND_API.G_EXC_ERROR;
4083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4085: WHEN OTHERS THEN

Line 4082: RAISE FND_API.G_EXC_ERROR;

4078: 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);
4079: END IF;
4080: EXCEPTION
4081: WHEN FND_API.G_EXC_ERROR THEN
4082: RAISE FND_API.G_EXC_ERROR;
4083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4085: WHEN OTHERS THEN
4086: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4079: END IF;
4080: EXCEPTION
4081: WHEN FND_API.G_EXC_ERROR THEN
4082: RAISE FND_API.G_EXC_ERROR;
4083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4085: WHEN OTHERS THEN
4086: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4087: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_party_details');

Line 4084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4080: EXCEPTION
4081: WHEN FND_API.G_EXC_ERROR THEN
4082: RAISE FND_API.G_EXC_ERROR;
4083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4085: WHEN OTHERS THEN
4086: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4087: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_party_details');
4088: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4086: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4087: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_party_details');
4088: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4089: FND_MSG_PUB.ADD;
4090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4091: END find_party_details;
4092:
4093: PROCEDURE find_duplicate_parties (
4094: p_rule_id IN NUMBER,

Line 4198: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4199: RAISE FND_API.G_EXC_ERROR;

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

Line 4200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 4201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4283: WHEN FND_API.G_EXC_ERROR THEN

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

Line 4284: RAISE FND_API.G_EXC_ERROR;

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

Line 4285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4281: END IF;
4282: EXCEPTION
4283: WHEN FND_API.G_EXC_ERROR THEN
4284: RAISE FND_API.G_EXC_ERROR;
4285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4287: WHEN OTHERS THEN
4288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_party_sites');

Line 4286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4282: EXCEPTION
4283: WHEN FND_API.G_EXC_ERROR THEN
4284: RAISE FND_API.G_EXC_ERROR;
4285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4287: WHEN OTHERS THEN
4288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_party_sites');
4290: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4288: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4289: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_party_sites');
4290: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4291: FND_MSG_PUB.ADD;
4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4293: END find_duplicate_party_sites;
4294:
4295: PROCEDURE find_duplicate_contacts (
4296: p_rule_id IN NUMBER,

Line 4372: WHEN FND_API.G_EXC_ERROR THEN

4368: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4369: 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);
4370: END IF;
4371: EXCEPTION
4372: WHEN FND_API.G_EXC_ERROR THEN
4373: RAISE FND_API.G_EXC_ERROR;
4374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4376: WHEN OTHERS THEN

Line 4373: RAISE FND_API.G_EXC_ERROR;

4369: 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);
4370: END IF;
4371: EXCEPTION
4372: WHEN FND_API.G_EXC_ERROR THEN
4373: RAISE FND_API.G_EXC_ERROR;
4374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4376: WHEN OTHERS THEN
4377: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4370: END IF;
4371: EXCEPTION
4372: WHEN FND_API.G_EXC_ERROR THEN
4373: RAISE FND_API.G_EXC_ERROR;
4374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4376: WHEN OTHERS THEN
4377: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4378: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contacts');

Line 4375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4371: EXCEPTION
4372: WHEN FND_API.G_EXC_ERROR THEN
4373: RAISE FND_API.G_EXC_ERROR;
4374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4376: WHEN OTHERS THEN
4377: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4378: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contacts');
4379: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4377: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4378: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contacts');
4379: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4380: FND_MSG_PUB.ADD;
4381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4382: END find_duplicate_contacts;
4383:
4384: PROCEDURE find_duplicate_contact_points (
4385: p_rule_id IN NUMBER,

Line 4445: WHEN FND_API.G_EXC_ERROR THEN

4441: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4442: 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);
4443: END IF;
4444: EXCEPTION
4445: WHEN FND_API.G_EXC_ERROR THEN
4446: RAISE FND_API.G_EXC_ERROR;
4447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4449: WHEN OTHERS THEN

Line 4446: RAISE FND_API.G_EXC_ERROR;

4442: 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);
4443: END IF;
4444: EXCEPTION
4445: WHEN FND_API.G_EXC_ERROR THEN
4446: RAISE FND_API.G_EXC_ERROR;
4447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4449: WHEN OTHERS THEN
4450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4443: END IF;
4444: EXCEPTION
4445: WHEN FND_API.G_EXC_ERROR THEN
4446: RAISE FND_API.G_EXC_ERROR;
4447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4449: WHEN OTHERS THEN
4450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4451: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contact_points');

Line 4448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4444: EXCEPTION
4445: WHEN FND_API.G_EXC_ERROR THEN
4446: RAISE FND_API.G_EXC_ERROR;
4447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4449: WHEN OTHERS THEN
4450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4451: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contact_points');
4452: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4450: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4451: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.find_duplicate_contact_points');
4452: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4453: FND_MSG_PUB.ADD;
4454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4455: END find_duplicate_contact_points;
4456:
4457: PROCEDURE find_parties_dynamic (
4458: p_rule_id IN NUMBER,

Line 4736: WHEN FND_API.G_EXC_ERROR THEN

4732: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4733: 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);
4734: END IF;
4735: EXCEPTION
4736: WHEN FND_API.G_EXC_ERROR THEN
4737: RAISE FND_API.G_EXC_ERROR;
4738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4740: WHEN OTHERS THEN

Line 4737: RAISE FND_API.G_EXC_ERROR;

4733: 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);
4734: END IF;
4735: EXCEPTION
4736: WHEN FND_API.G_EXC_ERROR THEN
4737: RAISE FND_API.G_EXC_ERROR;
4738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4740: WHEN OTHERS THEN
4741: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4734: END IF;
4735: EXCEPTION
4736: WHEN FND_API.G_EXC_ERROR THEN
4737: RAISE FND_API.G_EXC_ERROR;
4738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4740: WHEN OTHERS THEN
4741: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4742: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.call_api_dynamic');

Line 4739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4735: EXCEPTION
4736: WHEN FND_API.G_EXC_ERROR THEN
4737: RAISE FND_API.G_EXC_ERROR;
4738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4740: WHEN OTHERS THEN
4741: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4742: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.call_api_dynamic');
4743: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4741: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4742: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.call_api_dynamic');
4743: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4744: FND_MSG_PUB.ADD;
4745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4746: END call_api_dynamic;
4747:
4748:
4749: PROCEDURE get_matching_party_sites (

Line 4970: WHEN FND_API.G_EXC_ERROR THEN

4966: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4967: 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);
4968: END IF;
4969: EXCEPTION
4970: WHEN FND_API.G_EXC_ERROR THEN
4971: RAISE FND_API.G_EXC_ERROR;
4972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4974: WHEN OTHERS THEN

Line 4971: RAISE FND_API.G_EXC_ERROR;

4967: 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);
4968: END IF;
4969: EXCEPTION
4970: WHEN FND_API.G_EXC_ERROR THEN
4971: RAISE FND_API.G_EXC_ERROR;
4972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4974: WHEN OTHERS THEN
4975: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4968: END IF;
4969: EXCEPTION
4970: WHEN FND_API.G_EXC_ERROR THEN
4971: RAISE FND_API.G_EXC_ERROR;
4972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4974: WHEN OTHERS THEN
4975: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4976: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_party_sites');

Line 4973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4969: EXCEPTION
4970: WHEN FND_API.G_EXC_ERROR THEN
4971: RAISE FND_API.G_EXC_ERROR;
4972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4974: WHEN OTHERS THEN
4975: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4976: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_party_sites');
4977: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4975: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4976: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_party_sites');
4977: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4978: FND_MSG_PUB.ADD;
4979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4980: END get_matching_party_sites;
4981:
4982:
4983: PROCEDURE get_matching_contacts (

Line 5197: WHEN FND_API.G_EXC_ERROR THEN

5193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5194: 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);
5195: END IF;
5196: EXCEPTION
5197: WHEN FND_API.G_EXC_ERROR THEN
5198: RAISE FND_API.G_EXC_ERROR;
5199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5201: WHEN OTHERS THEN

Line 5198: RAISE FND_API.G_EXC_ERROR;

5194: 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);
5195: END IF;
5196: EXCEPTION
5197: WHEN FND_API.G_EXC_ERROR THEN
5198: RAISE FND_API.G_EXC_ERROR;
5199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5201: WHEN OTHERS THEN
5202: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5195: END IF;
5196: EXCEPTION
5197: WHEN FND_API.G_EXC_ERROR THEN
5198: RAISE FND_API.G_EXC_ERROR;
5199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5201: WHEN OTHERS THEN
5202: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5203: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contacts');

Line 5200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5196: EXCEPTION
5197: WHEN FND_API.G_EXC_ERROR THEN
5198: RAISE FND_API.G_EXC_ERROR;
5199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5201: WHEN OTHERS THEN
5202: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5203: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contacts');
5204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5202: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5203: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contacts');
5204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5205: FND_MSG_PUB.ADD;
5206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5207: END get_matching_contacts;
5208:
5209:
5210: PROCEDURE get_matching_contact_points (

Line 5338: WHEN FND_API.G_EXC_ERROR THEN

5334: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5335: 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);
5336: END IF;
5337: EXCEPTION
5338: WHEN FND_API.G_EXC_ERROR THEN
5339: RAISE FND_API.G_EXC_ERROR;
5340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5342: WHEN OTHERS THEN

Line 5339: RAISE FND_API.G_EXC_ERROR;

5335: 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);
5336: END IF;
5337: EXCEPTION
5338: WHEN FND_API.G_EXC_ERROR THEN
5339: RAISE FND_API.G_EXC_ERROR;
5340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5342: WHEN OTHERS THEN
5343: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5336: END IF;
5337: EXCEPTION
5338: WHEN FND_API.G_EXC_ERROR THEN
5339: RAISE FND_API.G_EXC_ERROR;
5340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5342: WHEN OTHERS THEN
5343: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5344: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contact_points');

Line 5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5337: EXCEPTION
5338: WHEN FND_API.G_EXC_ERROR THEN
5339: RAISE FND_API.G_EXC_ERROR;
5340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5342: WHEN OTHERS THEN
5343: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5344: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contact_points');
5345: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5343: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5344: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_matching_contact_points');
5345: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5346: FND_MSG_PUB.ADD;
5347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5348: END get_matching_contact_points;
5349:
5350: /**********************************************************
5351: This procedure finds the score details for a specific party that

Line 5547: WHEN FND_API.G_EXC_ERROR THEN

5543: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5544: 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);
5545: END IF;
5546: EXCEPTION
5547: WHEN FND_API.G_EXC_ERROR THEN
5548: RAISE FND_API.G_EXC_ERROR;
5549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5551: WHEN OTHERS THEN

Line 5548: RAISE FND_API.G_EXC_ERROR;

5544: 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);
5545: END IF;
5546: EXCEPTION
5547: WHEN FND_API.G_EXC_ERROR THEN
5548: RAISE FND_API.G_EXC_ERROR;
5549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5551: WHEN OTHERS THEN
5552: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5545: END IF;
5546: EXCEPTION
5547: WHEN FND_API.G_EXC_ERROR THEN
5548: RAISE FND_API.G_EXC_ERROR;
5549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5551: WHEN OTHERS THEN
5552: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5553: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_score_details');

Line 5550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5552: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5553: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_61.get_score_details');
5554: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5555: FND_MSG_PUB.ADD;
5556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5557: END get_score_details;
5558:
5559:
5560: /************************************************

Line 5622: WHEN FND_API.G_EXC_ERROR THEN

5618: END LOOP;
5619: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5620: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5621: EXCEPTION
5622: WHEN FND_API.G_EXC_ERROR THEN
5623: RAISE FND_API.G_EXC_ERROR;
5624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5626: WHEN OTHERS THEN

Line 5623: RAISE FND_API.G_EXC_ERROR;

5619: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
5620: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5621: EXCEPTION
5622: WHEN FND_API.G_EXC_ERROR THEN
5623: RAISE FND_API.G_EXC_ERROR;
5624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5626: WHEN OTHERS THEN
5627: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5620: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
5621: EXCEPTION
5622: WHEN FND_API.G_EXC_ERROR THEN
5623: RAISE FND_API.G_EXC_ERROR;
5624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5626: WHEN OTHERS THEN
5627: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5628: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 5625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 5631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5627: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5628: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
5629: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5630: FND_MSG_PUB.ADD;
5631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5632: END get_party_for_search;
5633:
5634: PROCEDURE get_search_criteria (
5635: p_party_id IN NUMBER,

Line 5662: WHEN FND_API.G_EXC_ERROR THEN

5658: END IF;
5659: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5660: END IF;
5661: EXCEPTION
5662: WHEN FND_API.G_EXC_ERROR THEN
5663: RAISE FND_API.G_EXC_ERROR;
5664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5666: WHEN OTHERS THEN

Line 5663: RAISE FND_API.G_EXC_ERROR;

5659: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
5660: END IF;
5661: EXCEPTION
5662: WHEN FND_API.G_EXC_ERROR THEN
5663: RAISE FND_API.G_EXC_ERROR;
5664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5666: WHEN OTHERS THEN
5667: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5660: END IF;
5661: EXCEPTION
5662: WHEN FND_API.G_EXC_ERROR THEN
5663: RAISE FND_API.G_EXC_ERROR;
5664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5666: WHEN OTHERS THEN
5667: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5668: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 5665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5661: EXCEPTION
5662: WHEN FND_API.G_EXC_ERROR THEN
5663: RAISE FND_API.G_EXC_ERROR;
5664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5666: WHEN OTHERS THEN
5667: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5668: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5669: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5667: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5668: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
5669: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5670: FND_MSG_PUB.ADD;
5671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5672: END get_search_criteria;
5673:
5674:
5675: /************************************************

Line 5738: RAISE FND_API.G_EXC_ERROR;

5734: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
5735: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
5736: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5737: FND_MSG_PUB.ADD;
5738: RAISE FND_API.G_EXC_ERROR;
5739: END get_party_rec;
5740:
5741: /************************************************
5742: This procedure retrieves the match rule party site attributes into

Line 5790: RAISE FND_API.G_EXC_ERROR;

5786: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
5787: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
5788: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5789: FND_MSG_PUB.ADD;
5790: RAISE FND_API.G_EXC_ERROR;
5791: END get_party_site_rec;
5792:
5793: /************************************************
5794: This procedure retrieves the match rule contact attributes into

Line 5846: RAISE FND_API.G_EXC_ERROR;

5842: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
5843: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
5844: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5845: FND_MSG_PUB.ADD;
5846: RAISE FND_API.G_EXC_ERROR;
5847: END get_contact_rec;
5848:
5849: /************************************************
5850: This procedure retrieves the match rule contact point attributes into

Line 5900: RAISE FND_API.G_EXC_ERROR;

5896: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
5897: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
5898: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5899: FND_MSG_PUB.ADD;
5900: RAISE FND_API.G_EXC_ERROR;
5901: END get_contact_point_rec;
5902:
5903: /************************************************
5904: This procedure maps a search record from the logical

Line 6093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6089: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6090: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6091: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6092: FND_MSG_PUB.ADD;
6093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6094: END;
6095:
6096:
6097: /************************************************

Line 6136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6132: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6133: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
6134: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6135: FND_MSG_PUB.ADD;
6136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6137: END;
6138:
6139:
6140: /************************************************

Line 6178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6174: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6175: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
6176: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6177: FND_MSG_PUB.ADD;
6178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6179: END;
6180:
6181:
6182: /************************************************

Line 6283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6279: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6280: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
6281: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6282: FND_MSG_PUB.ADD;
6283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6284: END;
6285:
6286:
6287: /************************************************

Line 6307: RAISE FND_API.G_EXC_ERROR;

6303: p_contact_point_list(I).URL IS NOT NULL
6304: ) THEN
6305: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6306: FND_MSG_PUB.ADD;
6307: RAISE FND_API.G_EXC_ERROR;
6308: END IF;
6309: END LOOP;
6310:
6311: IF p_party_search_rec.PARTY_NUMBER IS NOT NULL THEN

Line 6333: WHEN FND_API.G_EXC_ERROR THEN

6329: END IF;
6330: END LOOP;
6331: RETURN FALSE;
6332: EXCEPTION
6333: WHEN FND_API.G_EXC_ERROR THEN
6334: RAISE FND_API.G_EXC_ERROR;
6335: WHEN OTHERS THEN
6336: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6337: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 6334: RAISE FND_API.G_EXC_ERROR;

6330: END LOOP;
6331: RETURN FALSE;
6332: EXCEPTION
6333: WHEN FND_API.G_EXC_ERROR THEN
6334: RAISE FND_API.G_EXC_ERROR;
6335: WHEN OTHERS THEN
6336: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6337: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6338: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6336: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6337: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
6338: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6339: FND_MSG_PUB.ADD;
6340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6341: END check_prim_cond;
6342:
6343: /************************************************
6344: This procedure checks if the input search condition

Line 6384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6380: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6381: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
6382: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6383: FND_MSG_PUB.ADD;
6384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6385: END check_party_site_cond;
6386:
6387: /************************************************
6388: This procedure checks if the input search condition

Line 6430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6426: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6427: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
6428: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6429: FND_MSG_PUB.ADD;
6430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6431: END check_contact_cond;
6432:
6433: /************************************************
6434: This procedure checks if the input search condition

Line 6451: RAISE FND_API.G_EXC_ERROR;

6447: FOR I IN 1..p_contact_point_list.COUNT LOOP
6448: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
6449: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
6450: FND_MSG_PUB.ADD;
6451: RAISE FND_API.G_EXC_ERROR;
6452: END IF;
6453: END LOOP;
6454:
6455: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 6475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6471: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6472: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
6473: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6474: FND_MSG_PUB.ADD;
6475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6476: END check_contact_point_cond;
6477:
6478: FUNCTION check_staged RETURN BOOLEAN IS
6479: