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_34 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 1408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1404: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1405: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1407: FND_MSG_PUB.ADD;
1408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1409: END;
1410:
1411:
1412: /************************************************

Line 1433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1429: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1430: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1431: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1432: FND_MSG_PUB.ADD;
1433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1434: END;
1435:
1436:
1437: /************************************************

Line 1453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1449: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1450: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1451: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1452: FND_MSG_PUB.ADD;
1453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1454: END;
1455:
1456:
1457: /************************************************

Line 1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1469: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1470: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1471: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1472: FND_MSG_PUB.ADD;
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: END;
1475:
1476: PROCEDURE init_score_context (
1477: p_party_search_rec IN HZ_PARTY_SEARCH.party_search_rec_type:=

Line 1540: RAISE FND_API.G_EXC_ERROR;

1536: p_contact_list,
1537: p_contact_point_list) THEN
1538: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1539: FND_MSG_PUB.ADD;
1540: RAISE FND_API.G_EXC_ERROR;
1541: END IF;
1542: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1543: 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);
1544: END IF;

Line 1930: RAISE FND_API.G_EXC_ERROR;

1926: IF lengthb(l_party_contains_str) > 4000 THEN
1927: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1928: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1929: FND_MSG_PUB.ADD;
1930: RAISE FND_API.G_EXC_ERROR;
1931: END IF;
1932: IF (p_match_str = ' AND ' OR p_party_max_score 1933: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1934: 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 2042: RAISE FND_API.G_EXC_ERROR;

2038: IF lengthb(l_contains_str) > 4000 THEN
2039: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2040: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
2041: FND_MSG_PUB.ADD;
2042: RAISE FND_API.G_EXC_ERROR;
2043: END IF;
2044: x_denorm_str := l_den_contains_str;
2045: RETURN l_contains_str;
2046: END;

Line 2132: RAISE FND_API.G_EXC_ERROR;

2128: IF lengthb(l_contains_str) > 4000 THEN
2129: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
2130: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
2131: FND_MSG_PUB.ADD;
2132: RAISE FND_API.G_EXC_ERROR;
2133: END IF;
2134: x_denorm_str := l_den_contains_str;
2135: RETURN l_contains_str;
2136: END;

Line 2465: RAISE FND_API.G_EXC_ERROR;

2461: when others then
2462: if (instrb(SQLERRM,'DRG-51030')>0) then
2463: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2464: FND_MSG_PUB.ADD;
2465: RAISE FND_API.G_EXC_ERROR;
2466: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2467: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2468: FND_MSG_PUB.ADD;
2469: RAISE FND_API.G_EXC_ERROR;

Line 2469: RAISE FND_API.G_EXC_ERROR;

2465: RAISE FND_API.G_EXC_ERROR;
2466: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2467: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2468: FND_MSG_PUB.ADD;
2469: RAISE FND_API.G_EXC_ERROR;
2470: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2471: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2472: FND_MSG_PUB.ADD;
2473: RAISE FND_API.G_EXC_ERROR;

Line 2473: RAISE FND_API.G_EXC_ERROR;

2469: RAISE FND_API.G_EXC_ERROR;
2470: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2471: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2472: FND_MSG_PUB.ADD;
2473: RAISE FND_API.G_EXC_ERROR;
2474: else
2475: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2476: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2477: FND_MSG_PUB.ADD;

Line 2478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2474: else
2475: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2476: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2477: FND_MSG_PUB.ADD;
2478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2479: end if;
2480: END;
2481:
2482: PROCEDURE open_party_site_cursor(

Line 2710: RAISE FND_API.G_EXC_ERROR;

2706: when others then
2707: if (instrb(SQLERRM,'DRG-51030')>0) then
2708: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2709: FND_MSG_PUB.ADD;
2710: RAISE FND_API.G_EXC_ERROR;
2711: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2712: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2713: FND_MSG_PUB.ADD;
2714: RAISE FND_API.G_EXC_ERROR;

Line 2714: RAISE FND_API.G_EXC_ERROR;

2710: RAISE FND_API.G_EXC_ERROR;
2711: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2712: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2713: FND_MSG_PUB.ADD;
2714: RAISE FND_API.G_EXC_ERROR;
2715: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2716: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2717: FND_MSG_PUB.ADD;
2718: RAISE FND_API.G_EXC_ERROR;

Line 2718: RAISE FND_API.G_EXC_ERROR;

2714: RAISE FND_API.G_EXC_ERROR;
2715: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2716: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2717: FND_MSG_PUB.ADD;
2718: RAISE FND_API.G_EXC_ERROR;
2719: else
2720: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2722: FND_MSG_PUB.ADD;

Line 2723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2719: else
2720: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2722: FND_MSG_PUB.ADD;
2723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2724: end if;
2725: END;
2726:
2727: PROCEDURE open_contact_cursor(

Line 2857: RAISE FND_API.G_EXC_ERROR;

2853: when others then
2854: if (instrb(SQLERRM,'DRG-51030')>0) then
2855: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2856: FND_MSG_PUB.ADD;
2857: RAISE FND_API.G_EXC_ERROR;
2858: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2859: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2860: FND_MSG_PUB.ADD;
2861: RAISE FND_API.G_EXC_ERROR;

Line 2861: RAISE FND_API.G_EXC_ERROR;

2857: RAISE FND_API.G_EXC_ERROR;
2858: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2859: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2860: FND_MSG_PUB.ADD;
2861: RAISE FND_API.G_EXC_ERROR;
2862: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2863: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2864: FND_MSG_PUB.ADD;
2865: RAISE FND_API.G_EXC_ERROR;

Line 2865: RAISE FND_API.G_EXC_ERROR;

2861: RAISE FND_API.G_EXC_ERROR;
2862: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2863: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2864: FND_MSG_PUB.ADD;
2865: RAISE FND_API.G_EXC_ERROR;
2866: else
2867: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2869: FND_MSG_PUB.ADD;

Line 2870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2866: else
2867: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2869: FND_MSG_PUB.ADD;
2870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2871: end if;
2872: END;
2873:
2874: PROCEDURE open_contact_pt_cursor(

Line 3130: RAISE FND_API.G_EXC_ERROR;

3126: when others then
3127: if (instrb(SQLERRM,'DRG-51030')>0) then
3128: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3129: FND_MSG_PUB.ADD;
3130: RAISE FND_API.G_EXC_ERROR;
3131: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3132: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3133: FND_MSG_PUB.ADD;
3134: RAISE FND_API.G_EXC_ERROR;

Line 3134: RAISE FND_API.G_EXC_ERROR;

3130: RAISE FND_API.G_EXC_ERROR;
3131: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3132: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3133: FND_MSG_PUB.ADD;
3134: RAISE FND_API.G_EXC_ERROR;
3135: elsif (instrb(SQLERRM,'ORA-20000')>0) then
3136: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3137: FND_MSG_PUB.ADD;
3138: RAISE FND_API.G_EXC_ERROR;

Line 3138: RAISE FND_API.G_EXC_ERROR;

3134: RAISE FND_API.G_EXC_ERROR;
3135: elsif (instrb(SQLERRM,'ORA-20000')>0) then
3136: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3137: FND_MSG_PUB.ADD;
3138: RAISE FND_API.G_EXC_ERROR;
3139: else
3140: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3141: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3142: FND_MSG_PUB.ADD;

Line 3143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3139: else
3140: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3141: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3142: FND_MSG_PUB.ADD;
3143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3144: end if;
3145: END;
3146:
3147:

Line 3412: RAISE FND_API.G_EXC_ERROR;

3408: 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);
3409: END IF;
3410: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3411: FND_MSG_PUB.ADD;
3412: RAISE FND_API.G_EXC_ERROR;
3413: ELSE
3414: push_eval;
3415: RETURN;
3416: END IF;

Line 3460: RAISE FND_API.G_EXC_ERROR;

3456: 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);
3457: END IF;
3458: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3459: FND_MSG_PUB.ADD;
3460: RAISE FND_API.G_EXC_ERROR;
3461: ELSE
3462: push_eval;
3463: RETURN;
3464: END IF;

Line 3533: RAISE FND_API.G_EXC_ERROR;

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

Line 3645: RAISE FND_API.G_EXC_ERROR;

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

Line 3756: RAISE FND_API.G_EXC_ERROR;

3752: 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);
3753: END IF;
3754: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3755: FND_MSG_PUB.ADD;
3756: RAISE FND_API.G_EXC_ERROR;
3757: ELSE
3758: push_eval;
3759: RETURN;
3760: END IF;

Line 3981: RAISE FND_API.G_EXC_ERROR;

3977: 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);
3978: END IF;
3979: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3980: FND_MSG_PUB.ADD;
3981: RAISE FND_API.G_EXC_ERROR;
3982: END IF;
3983: ELSE
3984: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3985: 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 3989: RAISE FND_API.G_EXC_ERROR;

3985: 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);
3986: END IF;
3987: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3988: FND_MSG_PUB.ADD;
3989: RAISE FND_API.G_EXC_ERROR;
3990: END IF;
3991: END IF;
3992: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
3993: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 4188: WHEN FND_API.G_EXC_ERROR THEN

4184: END IF;
4185: EXCEPTION
4186: WHEN L_RETURN_IMM_EXC THEN
4187: RETURN;
4188: WHEN FND_API.G_EXC_ERROR THEN
4189: RAISE FND_API.G_EXC_ERROR;
4190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4192: WHEN OTHERS THEN

Line 4189: RAISE FND_API.G_EXC_ERROR;

4185: EXCEPTION
4186: WHEN L_RETURN_IMM_EXC THEN
4187: RETURN;
4188: WHEN FND_API.G_EXC_ERROR THEN
4189: RAISE FND_API.G_EXC_ERROR;
4190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4192: WHEN OTHERS THEN
4193: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4186: WHEN L_RETURN_IMM_EXC THEN
4187: RETURN;
4188: WHEN FND_API.G_EXC_ERROR THEN
4189: RAISE FND_API.G_EXC_ERROR;
4190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4192: WHEN OTHERS THEN
4193: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4194: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_parties');

Line 4191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4187: RETURN;
4188: WHEN FND_API.G_EXC_ERROR THEN
4189: RAISE FND_API.G_EXC_ERROR;
4190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4192: WHEN OTHERS THEN
4193: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4194: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_parties');
4195: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 4197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4193: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4194: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_parties');
4195: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4196: FND_MSG_PUB.ADD;
4197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4198: END find_parties;
4199:
4200: PROCEDURE find_persons (
4201: p_rule_id IN NUMBER,

Line 4406: RAISE FND_API.G_EXC_ERROR;

4402: 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);
4403: END IF;
4404: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4405: FND_MSG_PUB.ADD;
4406: RAISE FND_API.G_EXC_ERROR;
4407: ELSE
4408: push_eval;
4409: RETURN;
4410: END IF;

Line 4454: RAISE FND_API.G_EXC_ERROR;

4450: 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);
4451: END IF;
4452: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4453: FND_MSG_PUB.ADD;
4454: RAISE FND_API.G_EXC_ERROR;
4455: ELSE
4456: push_eval;
4457: RETURN;
4458: END IF;

Line 4490: RAISE FND_API.G_EXC_ERROR;

4486: when others then
4487: if (instrb(SQLERRM,'DRG-51030')>0) then
4488: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
4489: FND_MSG_PUB.ADD;
4490: RAISE FND_API.G_EXC_ERROR;
4491: elsif (instrb(SQLERRM,'DRG-50943')>0) then
4492: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
4493: FND_MSG_PUB.ADD;
4494: RAISE FND_API.G_EXC_ERROR;

Line 4494: RAISE FND_API.G_EXC_ERROR;

4490: RAISE FND_API.G_EXC_ERROR;
4491: elsif (instrb(SQLERRM,'DRG-50943')>0) then
4492: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
4493: FND_MSG_PUB.ADD;
4494: RAISE FND_API.G_EXC_ERROR;
4495: else
4496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4497: end if;
4498: END;

Line 4496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4492: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
4493: FND_MSG_PUB.ADD;
4494: RAISE FND_API.G_EXC_ERROR;
4495: else
4496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4497: end if;
4498: END;
4499:
4500: /** Private procedure to acquire and score at party site level ***/

Line 4566: RAISE FND_API.G_EXC_ERROR;

4562: 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);
4563: END IF;
4564: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4565: FND_MSG_PUB.ADD;
4566: RAISE FND_API.G_EXC_ERROR;
4567: ELSE
4568: push_eval;
4569: RETURN;
4570: END IF;

Line 4825: RAISE FND_API.G_EXC_ERROR;

4821: 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);
4822: END IF;
4823: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4824: FND_MSG_PUB.ADD;
4825: RAISE FND_API.G_EXC_ERROR;
4826: ELSE
4827: push_eval;
4828: RETURN;
4829: END IF;

Line 4938: RAISE FND_API.G_EXC_ERROR;

4934: 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);
4935: END IF;
4936: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4937: FND_MSG_PUB.ADD;
4938: RAISE FND_API.G_EXC_ERROR;
4939: END IF;
4940: ELSE
4941: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4942: 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 4946: RAISE FND_API.G_EXC_ERROR;

4942: 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);
4943: END IF;
4944: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4945: FND_MSG_PUB.ADD;
4946: RAISE FND_API.G_EXC_ERROR;
4947: END IF;
4948: END IF;
4949: IF call_order(p_index) = 'PARTY' AND l_party_contains_str IS NOT NULL THEN
4950: eval_party_level(l_party_contains_str,call_type(p_index), p_index);

Line 5060: WHEN FND_API.G_EXC_ERROR THEN

5056: END IF;
5057: EXCEPTION
5058: WHEN L_RETURN_IMM_EXC THEN
5059: RETURN;
5060: WHEN FND_API.G_EXC_ERROR THEN
5061: RAISE FND_API.G_EXC_ERROR;
5062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5064: WHEN OTHERS THEN

Line 5061: RAISE FND_API.G_EXC_ERROR;

5057: EXCEPTION
5058: WHEN L_RETURN_IMM_EXC THEN
5059: RETURN;
5060: WHEN FND_API.G_EXC_ERROR THEN
5061: RAISE FND_API.G_EXC_ERROR;
5062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5064: WHEN OTHERS THEN
5065: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5058: WHEN L_RETURN_IMM_EXC THEN
5059: RETURN;
5060: WHEN FND_API.G_EXC_ERROR THEN
5061: RAISE FND_API.G_EXC_ERROR;
5062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5064: WHEN OTHERS THEN
5065: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5066: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_persons');

Line 5063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5059: RETURN;
5060: WHEN FND_API.G_EXC_ERROR THEN
5061: RAISE FND_API.G_EXC_ERROR;
5062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5064: WHEN OTHERS THEN
5065: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5066: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_persons');
5067: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5065: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5066: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_persons');
5067: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5068: FND_MSG_PUB.ADD;
5069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5070: END find_persons;
5071:
5072: PROCEDURE find_persons (
5073: p_rule_id IN NUMBER,

Line 5128: WHEN FND_API.G_EXC_ERROR THEN

5124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5125: 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);
5126: END IF;
5127: EXCEPTION
5128: WHEN FND_API.G_EXC_ERROR THEN
5129: RAISE FND_API.G_EXC_ERROR;
5130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5132: WHEN OTHERS THEN

Line 5129: RAISE FND_API.G_EXC_ERROR;

5125: 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);
5126: END IF;
5127: EXCEPTION
5128: WHEN FND_API.G_EXC_ERROR THEN
5129: RAISE FND_API.G_EXC_ERROR;
5130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5132: WHEN OTHERS THEN
5133: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5126: END IF;
5127: EXCEPTION
5128: WHEN FND_API.G_EXC_ERROR THEN
5129: RAISE FND_API.G_EXC_ERROR;
5130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5132: WHEN OTHERS THEN
5133: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5134: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_party_details');

Line 5131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5127: EXCEPTION
5128: WHEN FND_API.G_EXC_ERROR THEN
5129: RAISE FND_API.G_EXC_ERROR;
5130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5132: WHEN OTHERS THEN
5133: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5134: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_party_details');
5135: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5133: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5134: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_party_details');
5135: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5136: FND_MSG_PUB.ADD;
5137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5138: END find_party_details;
5139:
5140: PROCEDURE find_duplicate_parties (
5141: p_rule_id IN NUMBER,

Line 5245: WHEN FND_API.G_EXC_ERROR THEN

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

Line 5246: RAISE FND_API.G_EXC_ERROR;

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

Line 5247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5243: END IF;
5244: EXCEPTION
5245: WHEN FND_API.G_EXC_ERROR THEN
5246: RAISE FND_API.G_EXC_ERROR;
5247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5249: WHEN OTHERS THEN
5250: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5251: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_parties');

Line 5248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5244: EXCEPTION
5245: WHEN FND_API.G_EXC_ERROR THEN
5246: RAISE FND_API.G_EXC_ERROR;
5247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5249: WHEN OTHERS THEN
5250: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5251: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_parties');
5252: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5250: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5251: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_parties');
5252: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5253: FND_MSG_PUB.ADD;
5254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5255: END find_duplicate_parties;
5256:
5257: PROCEDURE find_duplicate_party_sites (
5258: p_rule_id IN NUMBER,

Line 5330: WHEN FND_API.G_EXC_ERROR THEN

5326: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5327: 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);
5328: END IF;
5329: EXCEPTION
5330: WHEN FND_API.G_EXC_ERROR THEN
5331: RAISE FND_API.G_EXC_ERROR;
5332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5334: WHEN OTHERS THEN

Line 5331: RAISE FND_API.G_EXC_ERROR;

5327: 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);
5328: END IF;
5329: EXCEPTION
5330: WHEN FND_API.G_EXC_ERROR THEN
5331: RAISE FND_API.G_EXC_ERROR;
5332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5334: WHEN OTHERS THEN
5335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5328: END IF;
5329: EXCEPTION
5330: WHEN FND_API.G_EXC_ERROR THEN
5331: RAISE FND_API.G_EXC_ERROR;
5332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5334: WHEN OTHERS THEN
5335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_party_sites');

Line 5333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5329: EXCEPTION
5330: WHEN FND_API.G_EXC_ERROR THEN
5331: RAISE FND_API.G_EXC_ERROR;
5332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5334: WHEN OTHERS THEN
5335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_party_sites');
5337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5335: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5336: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_party_sites');
5337: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5338: FND_MSG_PUB.ADD;
5339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5340: END find_duplicate_party_sites;
5341:
5342: PROCEDURE find_duplicate_contacts (
5343: p_rule_id IN NUMBER,

Line 5419: WHEN FND_API.G_EXC_ERROR THEN

5415: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5416: 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);
5417: END IF;
5418: EXCEPTION
5419: WHEN FND_API.G_EXC_ERROR THEN
5420: RAISE FND_API.G_EXC_ERROR;
5421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5423: WHEN OTHERS THEN

Line 5420: RAISE FND_API.G_EXC_ERROR;

5416: 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);
5417: END IF;
5418: EXCEPTION
5419: WHEN FND_API.G_EXC_ERROR THEN
5420: RAISE FND_API.G_EXC_ERROR;
5421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5423: WHEN OTHERS THEN
5424: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5417: END IF;
5418: EXCEPTION
5419: WHEN FND_API.G_EXC_ERROR THEN
5420: RAISE FND_API.G_EXC_ERROR;
5421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5423: WHEN OTHERS THEN
5424: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5425: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contacts');

Line 5422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5418: EXCEPTION
5419: WHEN FND_API.G_EXC_ERROR THEN
5420: RAISE FND_API.G_EXC_ERROR;
5421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5423: WHEN OTHERS THEN
5424: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5425: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contacts');
5426: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5424: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5425: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contacts');
5426: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5427: FND_MSG_PUB.ADD;
5428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5429: END find_duplicate_contacts;
5430:
5431: PROCEDURE find_duplicate_contact_points (
5432: p_rule_id IN NUMBER,

Line 5492: WHEN FND_API.G_EXC_ERROR THEN

5488: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5489: 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);
5490: END IF;
5491: EXCEPTION
5492: WHEN FND_API.G_EXC_ERROR THEN
5493: RAISE FND_API.G_EXC_ERROR;
5494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5496: WHEN OTHERS THEN

Line 5493: RAISE FND_API.G_EXC_ERROR;

5489: 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);
5490: END IF;
5491: EXCEPTION
5492: WHEN FND_API.G_EXC_ERROR THEN
5493: RAISE FND_API.G_EXC_ERROR;
5494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5496: WHEN OTHERS THEN
5497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5490: END IF;
5491: EXCEPTION
5492: WHEN FND_API.G_EXC_ERROR THEN
5493: RAISE FND_API.G_EXC_ERROR;
5494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5496: WHEN OTHERS THEN
5497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5498: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contact_points');

Line 5495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5491: EXCEPTION
5492: WHEN FND_API.G_EXC_ERROR THEN
5493: RAISE FND_API.G_EXC_ERROR;
5494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5496: WHEN OTHERS THEN
5497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5498: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contact_points');
5499: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5497: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5498: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.find_duplicate_contact_points');
5499: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5500: FND_MSG_PUB.ADD;
5501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5502: END find_duplicate_contact_points;
5503:
5504: PROCEDURE find_parties_dynamic (
5505: p_rule_id IN NUMBER,

Line 5922: WHEN FND_API.G_EXC_ERROR THEN

5918: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5919: 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);
5920: END IF;
5921: EXCEPTION
5922: WHEN FND_API.G_EXC_ERROR THEN
5923: RAISE FND_API.G_EXC_ERROR;
5924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5926: WHEN OTHERS THEN

Line 5923: RAISE FND_API.G_EXC_ERROR;

5919: 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);
5920: END IF;
5921: EXCEPTION
5922: WHEN FND_API.G_EXC_ERROR THEN
5923: RAISE FND_API.G_EXC_ERROR;
5924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5926: WHEN OTHERS THEN
5927: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 5924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5920: END IF;
5921: EXCEPTION
5922: WHEN FND_API.G_EXC_ERROR THEN
5923: RAISE FND_API.G_EXC_ERROR;
5924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5926: WHEN OTHERS THEN
5927: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5928: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.call_api_dynamic');

Line 5925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5921: EXCEPTION
5922: WHEN FND_API.G_EXC_ERROR THEN
5923: RAISE FND_API.G_EXC_ERROR;
5924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5926: WHEN OTHERS THEN
5927: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5928: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.call_api_dynamic');
5929: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 5931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5927: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5928: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.call_api_dynamic');
5929: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5930: FND_MSG_PUB.ADD;
5931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5932: END call_api_dynamic;
5933:
5934:
5935: PROCEDURE get_matching_party_sites (

Line 6166: WHEN FND_API.G_EXC_ERROR THEN

6162: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6163: 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);
6164: END IF;
6165: EXCEPTION
6166: WHEN FND_API.G_EXC_ERROR THEN
6167: RAISE FND_API.G_EXC_ERROR;
6168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6170: WHEN OTHERS THEN

Line 6167: RAISE FND_API.G_EXC_ERROR;

6163: 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);
6164: END IF;
6165: EXCEPTION
6166: WHEN FND_API.G_EXC_ERROR THEN
6167: RAISE FND_API.G_EXC_ERROR;
6168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6170: WHEN OTHERS THEN
6171: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6164: END IF;
6165: EXCEPTION
6166: WHEN FND_API.G_EXC_ERROR THEN
6167: RAISE FND_API.G_EXC_ERROR;
6168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6170: WHEN OTHERS THEN
6171: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6172: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_party_sites');

Line 6169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6165: EXCEPTION
6166: WHEN FND_API.G_EXC_ERROR THEN
6167: RAISE FND_API.G_EXC_ERROR;
6168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6170: WHEN OTHERS THEN
6171: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6172: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_party_sites');
6173: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6171: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6172: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_party_sites');
6173: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6174: FND_MSG_PUB.ADD;
6175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6176: END get_matching_party_sites;
6177:
6178:
6179: PROCEDURE get_matching_contacts (

Line 6394: WHEN FND_API.G_EXC_ERROR THEN

6390: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6391: 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);
6392: END IF;
6393: EXCEPTION
6394: WHEN FND_API.G_EXC_ERROR THEN
6395: RAISE FND_API.G_EXC_ERROR;
6396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6398: WHEN OTHERS THEN

Line 6395: RAISE FND_API.G_EXC_ERROR;

6391: 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);
6392: END IF;
6393: EXCEPTION
6394: WHEN FND_API.G_EXC_ERROR THEN
6395: RAISE FND_API.G_EXC_ERROR;
6396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6398: WHEN OTHERS THEN
6399: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6392: END IF;
6393: EXCEPTION
6394: WHEN FND_API.G_EXC_ERROR THEN
6395: RAISE FND_API.G_EXC_ERROR;
6396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6398: WHEN OTHERS THEN
6399: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6400: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_contacts');

Line 6397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6393: EXCEPTION
6394: WHEN FND_API.G_EXC_ERROR THEN
6395: RAISE FND_API.G_EXC_ERROR;
6396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6398: WHEN OTHERS THEN
6399: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6400: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_contacts');
6401: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6399: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6400: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_contacts');
6401: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6402: FND_MSG_PUB.ADD;
6403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6404: END get_matching_contacts;
6405:
6406:
6407: PROCEDURE get_matching_contact_points (

Line 6536: WHEN FND_API.G_EXC_ERROR THEN

6532: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6533: 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);
6534: END IF;
6535: EXCEPTION
6536: WHEN FND_API.G_EXC_ERROR THEN
6537: RAISE FND_API.G_EXC_ERROR;
6538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6540: WHEN OTHERS THEN

Line 6537: RAISE FND_API.G_EXC_ERROR;

6533: 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);
6534: END IF;
6535: EXCEPTION
6536: WHEN FND_API.G_EXC_ERROR THEN
6537: RAISE FND_API.G_EXC_ERROR;
6538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6540: WHEN OTHERS THEN
6541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6534: END IF;
6535: EXCEPTION
6536: WHEN FND_API.G_EXC_ERROR THEN
6537: RAISE FND_API.G_EXC_ERROR;
6538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6540: WHEN OTHERS THEN
6541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6542: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_contact_points');

Line 6539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6535: EXCEPTION
6536: WHEN FND_API.G_EXC_ERROR THEN
6537: RAISE FND_API.G_EXC_ERROR;
6538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6540: WHEN OTHERS THEN
6541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6542: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_contact_points');
6543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6541: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6542: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_matching_contact_points');
6543: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6544: FND_MSG_PUB.ADD;
6545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6546: END get_matching_contact_points;
6547:
6548: /**********************************************************
6549: This procedure finds the score details for a specific party that

Line 6788: WHEN FND_API.G_EXC_ERROR THEN

6784: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6785: 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);
6786: END IF;
6787: EXCEPTION
6788: WHEN FND_API.G_EXC_ERROR THEN
6789: RAISE FND_API.G_EXC_ERROR;
6790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6792: WHEN OTHERS THEN

Line 6789: RAISE FND_API.G_EXC_ERROR;

6785: 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);
6786: END IF;
6787: EXCEPTION
6788: WHEN FND_API.G_EXC_ERROR THEN
6789: RAISE FND_API.G_EXC_ERROR;
6790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6792: WHEN OTHERS THEN
6793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6786: END IF;
6787: EXCEPTION
6788: WHEN FND_API.G_EXC_ERROR THEN
6789: RAISE FND_API.G_EXC_ERROR;
6790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6792: WHEN OTHERS THEN
6793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6794: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_score_details');

Line 6791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6787: EXCEPTION
6788: WHEN FND_API.G_EXC_ERROR THEN
6789: RAISE FND_API.G_EXC_ERROR;
6790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6792: WHEN OTHERS THEN
6793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6794: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_score_details');
6795: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6794: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_34.get_score_details');
6795: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6796: FND_MSG_PUB.ADD;
6797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6798: END get_score_details;
6799:
6800:
6801: /************************************************

Line 6898: WHEN FND_API.G_EXC_ERROR THEN

6894: END LOOP;
6895: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6896: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6897: EXCEPTION
6898: WHEN FND_API.G_EXC_ERROR THEN
6899: RAISE FND_API.G_EXC_ERROR;
6900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6902: WHEN OTHERS THEN

Line 6899: RAISE FND_API.G_EXC_ERROR;

6895: get_search_criteria(l_party_id,l_party_site_ids,l_contact_ids,l_contact_pt_ids,
6896: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6897: EXCEPTION
6898: WHEN FND_API.G_EXC_ERROR THEN
6899: RAISE FND_API.G_EXC_ERROR;
6900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6902: WHEN OTHERS THEN
6903: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6896: x_party_search_rec,x_party_site_list,x_contact_list,x_contact_point_list);
6897: EXCEPTION
6898: WHEN FND_API.G_EXC_ERROR THEN
6899: RAISE FND_API.G_EXC_ERROR;
6900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6902: WHEN OTHERS THEN
6903: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6904: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

Line 6901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6897: EXCEPTION
6898: WHEN FND_API.G_EXC_ERROR THEN
6899: RAISE FND_API.G_EXC_ERROR;
6900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6902: WHEN OTHERS THEN
6903: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6904: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6905: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6903: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6904: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6905: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6906: FND_MSG_PUB.ADD;
6907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6908: END get_party_for_search;
6909:
6910: PROCEDURE get_search_criteria (
6911: p_party_id IN NUMBER,

Line 6944: WHEN FND_API.G_EXC_ERROR THEN

6940: END IF;
6941: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6942: END IF;
6943: EXCEPTION
6944: WHEN FND_API.G_EXC_ERROR THEN
6945: RAISE FND_API.G_EXC_ERROR;
6946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6948: WHEN OTHERS THEN

Line 6945: RAISE FND_API.G_EXC_ERROR;

6941: get_contact_point_rec(p_contact_pt_ids, x_contact_point_list);
6942: END IF;
6943: EXCEPTION
6944: WHEN FND_API.G_EXC_ERROR THEN
6945: RAISE FND_API.G_EXC_ERROR;
6946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6948: WHEN OTHERS THEN
6949: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 6946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6942: END IF;
6943: EXCEPTION
6944: WHEN FND_API.G_EXC_ERROR THEN
6945: RAISE FND_API.G_EXC_ERROR;
6946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6948: WHEN OTHERS THEN
6949: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6950: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

Line 6947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6943: EXCEPTION
6944: WHEN FND_API.G_EXC_ERROR THEN
6945: RAISE FND_API.G_EXC_ERROR;
6946: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6948: WHEN OTHERS THEN
6949: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6950: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6951: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 6953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6949: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6950: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6951: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6952: FND_MSG_PUB.ADD;
6953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6954: END get_search_criteria;
6955:
6956:
6957: /************************************************

Line 7042: RAISE FND_API.G_EXC_ERROR;

7038: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
7039: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
7040: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7041: FND_MSG_PUB.ADD;
7042: RAISE FND_API.G_EXC_ERROR;
7043: END get_party_rec;
7044:
7045: /************************************************
7046: This procedure retrieves the match rule party site attributes into

Line 7106: RAISE FND_API.G_EXC_ERROR;

7102: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
7103: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
7104: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7105: FND_MSG_PUB.ADD;
7106: RAISE FND_API.G_EXC_ERROR;
7107: END get_party_site_rec;
7108:
7109: /************************************************
7110: This procedure retrieves the match rule contact attributes into

Line 7162: RAISE FND_API.G_EXC_ERROR;

7158: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
7159: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
7160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7161: FND_MSG_PUB.ADD;
7162: RAISE FND_API.G_EXC_ERROR;
7163: END get_contact_rec;
7164:
7165: /************************************************
7166: This procedure retrieves the match rule contact point attributes into

Line 7220: RAISE FND_API.G_EXC_ERROR;

7216: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
7217: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
7218: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7219: FND_MSG_PUB.ADD;
7220: RAISE FND_API.G_EXC_ERROR;
7221: END get_contact_point_rec;
7222:
7223: /************************************************
7224: This procedure maps a search record from the logical

Line 7550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7546: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7547: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
7548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7549: FND_MSG_PUB.ADD;
7550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7551: END;
7552:
7553:
7554: /************************************************

Line 7757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7753: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7754: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7755: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7756: FND_MSG_PUB.ADD;
7757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7758: END;
7759:
7760:
7761: /************************************************

Line 7799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7795: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7796: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7797: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7798: FND_MSG_PUB.ADD;
7799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7800: END;
7801:
7802:
7803: /************************************************

Line 7943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7939: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7940: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7942: FND_MSG_PUB.ADD;
7943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7944: END;
7945:
7946:
7947: /************************************************

Line 7967: RAISE FND_API.G_EXC_ERROR;

7963: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
7964: ) THEN
7965: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7966: FND_MSG_PUB.ADD;
7967: RAISE FND_API.G_EXC_ERROR;
7968: END IF;
7969: END LOOP;
7970:
7971: IF p_party_search_rec.ALL_ACCOUNT_NAMES IS NOT NULL THEN

Line 8041: WHEN FND_API.G_EXC_ERROR THEN

8037: END IF;
8038: END LOOP;
8039: RETURN FALSE;
8040: EXCEPTION
8041: WHEN FND_API.G_EXC_ERROR THEN
8042: RAISE FND_API.G_EXC_ERROR;
8043: WHEN OTHERS THEN
8044: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8045: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

Line 8042: RAISE FND_API.G_EXC_ERROR;

8038: END LOOP;
8039: RETURN FALSE;
8040: EXCEPTION
8041: WHEN FND_API.G_EXC_ERROR THEN
8042: RAISE FND_API.G_EXC_ERROR;
8043: WHEN OTHERS THEN
8044: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8045: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
8046: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

Line 8048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8044: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8045: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
8046: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8047: FND_MSG_PUB.ADD;
8048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8049: END check_prim_cond;
8050:
8051: /************************************************
8052: This procedure checks if the input search condition

Line 8112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8108: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8109: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
8110: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8111: FND_MSG_PUB.ADD;
8112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8113: END check_party_site_cond;
8114:
8115: /************************************************
8116: This procedure checks if the input search condition

Line 8160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8156: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8157: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
8158: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8159: FND_MSG_PUB.ADD;
8160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8161: END check_contact_cond;
8162:
8163: /************************************************
8164: This procedure checks if the input search condition

Line 8181: RAISE FND_API.G_EXC_ERROR;

8177: FOR I IN 1..p_contact_point_list.COUNT LOOP
8178: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
8179: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
8180: FND_MSG_PUB.ADD;
8181: RAISE FND_API.G_EXC_ERROR;
8182: END IF;
8183: END LOOP;
8184:
8185: FOR I IN 1..p_contact_point_list.COUNT LOOP

Line 8207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8203: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
8204: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
8205: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
8206: FND_MSG_PUB.ADD;
8207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8208: END check_contact_point_cond;
8209:
8210: FUNCTION check_staged RETURN BOOLEAN IS
8211: