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_62 dependencies on FND_MESSAGE

Line 100: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

96:
97: exception
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');

Line 104: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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;
107: else
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1033: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

1029: BEGIN
1030: NULL ;
1031: EXCEPTION
1032: WHEN OTHERS THEN
1033: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1034: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1035: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1036: FND_MSG_PUB.ADD;
1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1034: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');

1030: NULL ;
1031: EXCEPTION
1032: WHEN OTHERS THEN
1033: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1034: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1035: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1036: FND_MSG_PUB.ADD;
1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1038: END;

Line 1035: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1031: EXCEPTION
1032: WHEN OTHERS THEN
1033: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1034: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1035: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1036: FND_MSG_PUB.ADD;
1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1038: END;
1039:

Line 1058: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

1054: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,p_search_list(1).COUNTRY);
1055: END IF ;
1056: EXCEPTION
1057: WHEN OTHERS THEN
1058: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1059: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1060: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1061: FND_MSG_PUB.ADD;
1062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1059: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');

1055: END IF ;
1056: EXCEPTION
1057: WHEN OTHERS THEN
1058: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1059: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1060: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1061: FND_MSG_PUB.ADD;
1062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1063: END;

Line 1060: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1056: EXCEPTION
1057: WHEN OTHERS THEN
1058: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1059: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1060: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1061: FND_MSG_PUB.ADD;
1062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1063: END;
1064:

Line 1078: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

1074: BEGIN
1075: NULL ;
1076: EXCEPTION
1077: WHEN OTHERS THEN
1078: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1079: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1080: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1081: FND_MSG_PUB.ADD;
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1079: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');

1075: NULL ;
1076: EXCEPTION
1077: WHEN OTHERS THEN
1078: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1079: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1080: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1081: FND_MSG_PUB.ADD;
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: END;

Line 1080: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1076: EXCEPTION
1077: WHEN OTHERS THEN
1078: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1079: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1080: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1081: FND_MSG_PUB.ADD;
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: END;
1084:

Line 1098: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

1094: BEGIN
1095: NULL ;
1096: EXCEPTION
1097: WHEN OTHERS THEN
1098: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1099: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1100: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1101: FND_MSG_PUB.ADD;
1102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1099: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');

1095: NULL ;
1096: EXCEPTION
1097: WHEN OTHERS THEN
1098: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1099: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1100: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1101: FND_MSG_PUB.ADD;
1102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1103: END;

Line 1100: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1096: EXCEPTION
1097: WHEN OTHERS THEN
1098: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1099: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1100: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1101: FND_MSG_PUB.ADD;
1102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1103: END;
1104:

Line 1167: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');

1163: IF NOT check_prim_cond (p_party_search_rec,
1164: p_party_site_list,
1165: p_contact_list,
1166: p_contact_point_list) THEN
1167: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1168: FND_MSG_PUB.ADD;
1169: RAISE FND_API.G_EXC_ERROR;
1170: END IF;
1171: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1458: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

1454: ELSE
1455: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1456: END IF;
1457: IF lengthb(l_party_contains_str) > 4000 THEN
1458: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1459: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1460: FND_MSG_PUB.ADD;
1461: RAISE FND_API.G_EXC_ERROR;
1462: END IF;

Line 1459: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');

1455: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1456: END IF;
1457: IF lengthb(l_party_contains_str) > 4000 THEN
1458: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1459: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1460: FND_MSG_PUB.ADD;
1461: RAISE FND_API.G_EXC_ERROR;
1462: END IF;
1463: IF (p_match_str = ' AND ' OR p_party_max_score

Line 1567: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

1563: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1564: END LOOP;
1565: -- Add the search criteria to query string
1566: IF lengthb(l_contains_str) > 4000 THEN
1567: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1568: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1569: FND_MSG_PUB.ADD;
1570: RAISE FND_API.G_EXC_ERROR;
1571: END IF;

Line 1568: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');

1564: END LOOP;
1565: -- Add the search criteria to query string
1566: IF lengthb(l_contains_str) > 4000 THEN
1567: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1568: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1569: FND_MSG_PUB.ADD;
1570: RAISE FND_API.G_EXC_ERROR;
1571: END IF;
1572: x_denorm_str := l_den_contains_str;

Line 1664: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');

1660: END IF;
1661: END LOOP;
1662: -- Add the search criteria to query string
1663: IF lengthb(l_contains_str) > 4000 THEN
1664: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1665: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1666: FND_MSG_PUB.ADD;
1667: RAISE FND_API.G_EXC_ERROR;
1668: END IF;

Line 1665: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');

1661: END LOOP;
1662: -- Add the search criteria to query string
1663: IF lengthb(l_contains_str) > 4000 THEN
1664: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1665: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1666: FND_MSG_PUB.ADD;
1667: RAISE FND_API.G_EXC_ERROR;
1668: END IF;
1669: x_denorm_str := l_den_contains_str;

Line 1941: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

1937: END IF;
1938: exception
1939: when others then
1940: if (instrb(SQLERRM,'DRG-51030')>0) then
1941: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1942: FND_MSG_PUB.ADD;
1943: RAISE FND_API.G_EXC_ERROR;
1944: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1945: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1945: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1941: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
1942: FND_MSG_PUB.ADD;
1943: RAISE FND_API.G_EXC_ERROR;
1944: elsif (instrb(SQLERRM,'DRG-50943')>0) then
1945: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1946: FND_MSG_PUB.ADD;
1947: RAISE FND_API.G_EXC_ERROR;
1948: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1949: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 1949: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

1945: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1946: FND_MSG_PUB.ADD;
1947: RAISE FND_API.G_EXC_ERROR;
1948: elsif (instrb(SQLERRM,'ORA-20000')>0) then
1949: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1950: FND_MSG_PUB.ADD;
1951: RAISE FND_API.G_EXC_ERROR;
1952: else
1953: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 1953: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1949: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
1950: FND_MSG_PUB.ADD;
1951: RAISE FND_API.G_EXC_ERROR;
1952: else
1953: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1954: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1955: FND_MSG_PUB.ADD;
1956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1957: end if;

Line 1954: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1950: FND_MSG_PUB.ADD;
1951: RAISE FND_API.G_EXC_ERROR;
1952: else
1953: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1954: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1955: FND_MSG_PUB.ADD;
1956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1957: end if;
1958: END;

Line 2186: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

2182: output_long_strings('Restrict Sql = '||p_restrict_sql);
2183: exception
2184: when others then
2185: if (instrb(SQLERRM,'DRG-51030')>0) then
2186: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2187: FND_MSG_PUB.ADD;
2188: RAISE FND_API.G_EXC_ERROR;
2189: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2190: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 2190: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

2186: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2187: FND_MSG_PUB.ADD;
2188: RAISE FND_API.G_EXC_ERROR;
2189: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2190: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2191: FND_MSG_PUB.ADD;
2192: RAISE FND_API.G_EXC_ERROR;
2193: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2194: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 2194: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

2190: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2191: FND_MSG_PUB.ADD;
2192: RAISE FND_API.G_EXC_ERROR;
2193: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2194: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2195: FND_MSG_PUB.ADD;
2196: RAISE FND_API.G_EXC_ERROR;
2197: else
2198: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 2198: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

2194: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2195: FND_MSG_PUB.ADD;
2196: RAISE FND_API.G_EXC_ERROR;
2197: else
2198: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2199: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2200: FND_MSG_PUB.ADD;
2201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2202: end if;

Line 2199: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

2195: FND_MSG_PUB.ADD;
2196: RAISE FND_API.G_EXC_ERROR;
2197: else
2198: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2199: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2200: FND_MSG_PUB.ADD;
2201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2202: end if;
2203: END;

Line 2333: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

2329: output_long_strings('Restrict Sql = '||p_restrict_sql);
2330: exception
2331: when others then
2332: if (instrb(SQLERRM,'DRG-51030')>0) then
2333: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2334: FND_MSG_PUB.ADD;
2335: RAISE FND_API.G_EXC_ERROR;
2336: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2337: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 2337: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

2333: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2334: FND_MSG_PUB.ADD;
2335: RAISE FND_API.G_EXC_ERROR;
2336: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2337: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2338: FND_MSG_PUB.ADD;
2339: RAISE FND_API.G_EXC_ERROR;
2340: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2341: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 2341: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

2337: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2338: FND_MSG_PUB.ADD;
2339: RAISE FND_API.G_EXC_ERROR;
2340: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2341: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2342: FND_MSG_PUB.ADD;
2343: RAISE FND_API.G_EXC_ERROR;
2344: else
2345: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 2345: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

2341: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2342: FND_MSG_PUB.ADD;
2343: RAISE FND_API.G_EXC_ERROR;
2344: else
2345: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2346: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2347: FND_MSG_PUB.ADD;
2348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2349: end if;

Line 2346: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

2342: FND_MSG_PUB.ADD;
2343: RAISE FND_API.G_EXC_ERROR;
2344: else
2345: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2346: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2347: FND_MSG_PUB.ADD;
2348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2349: end if;
2350: END;

Line 2606: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

2602: output_long_strings('Restrict Sql = '||p_restrict_sql);
2603: exception
2604: when others then
2605: if (instrb(SQLERRM,'DRG-51030')>0) then
2606: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2607: FND_MSG_PUB.ADD;
2608: RAISE FND_API.G_EXC_ERROR;
2609: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2610: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 2610: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

2606: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2607: FND_MSG_PUB.ADD;
2608: RAISE FND_API.G_EXC_ERROR;
2609: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2610: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2611: FND_MSG_PUB.ADD;
2612: RAISE FND_API.G_EXC_ERROR;
2613: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2614: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 2614: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

2610: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2611: FND_MSG_PUB.ADD;
2612: RAISE FND_API.G_EXC_ERROR;
2613: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2614: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2615: FND_MSG_PUB.ADD;
2616: RAISE FND_API.G_EXC_ERROR;
2617: else
2618: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 2618: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

2614: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2615: FND_MSG_PUB.ADD;
2616: RAISE FND_API.G_EXC_ERROR;
2617: else
2618: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2619: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2620: FND_MSG_PUB.ADD;
2621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2622: end if;

Line 2619: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

2615: FND_MSG_PUB.ADD;
2616: RAISE FND_API.G_EXC_ERROR;
2617: else
2618: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2619: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2620: FND_MSG_PUB.ADD;
2621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2622: end if;
2623: END;

Line 2882: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2878: IF p_index>1 THEN
2879: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2880: 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);
2881: END IF;
2882: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2883: FND_MSG_PUB.ADD;
2884: RAISE FND_API.G_EXC_ERROR;
2885: ELSE
2886: push_eval;

Line 2932: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

2928: IF p_index>1 THEN
2929: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2930: 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);
2931: END IF;
2932: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2933: FND_MSG_PUB.ADD;
2934: RAISE FND_API.G_EXC_ERROR;
2935: ELSE
2936: push_eval;

Line 3005: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3001: IF p_index>1 THEN
3002: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3003: 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);
3004: END IF;
3005: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3006: FND_MSG_PUB.ADD;
3007: RAISE FND_API.G_EXC_ERROR;
3008: ELSE
3009: push_eval;

Line 3117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3113: IF p_index>1 THEN
3114: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3115: 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);
3116: END IF;
3117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3118: FND_MSG_PUB.ADD;
3119: RAISE FND_API.G_EXC_ERROR;
3120: ELSE
3121: push_eval;

Line 3228: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3224: IF p_index>1 THEN
3225: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3226: 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);
3227: END IF;
3228: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3229: FND_MSG_PUB.ADD;
3230: RAISE FND_API.G_EXC_ERROR;
3231: ELSE
3232: push_eval;

Line 3453: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

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

Line 3461: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

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

Line 3667: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

3663: RAISE FND_API.G_EXC_ERROR;
3664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3666: WHEN OTHERS THEN
3667: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3668: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_parties');
3669: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3670: FND_MSG_PUB.ADD;
3671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3668: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_parties');

3664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3666: WHEN OTHERS THEN
3667: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3668: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_parties');
3669: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3670: FND_MSG_PUB.ADD;
3671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3672: END find_parties;

Line 3669: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

3665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3666: WHEN OTHERS THEN
3667: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3668: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_parties');
3669: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3670: FND_MSG_PUB.ADD;
3671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3672: END find_parties;
3673:

Line 3872: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3868: IF p_index>1 THEN
3869: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3870: 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);
3871: END IF;
3872: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3873: FND_MSG_PUB.ADD;
3874: RAISE FND_API.G_EXC_ERROR;
3875: ELSE
3876: push_eval;

Line 3922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

3918: IF p_index>1 THEN
3919: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3920: 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);
3921: END IF;
3922: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3923: FND_MSG_PUB.ADD;
3924: RAISE FND_API.G_EXC_ERROR;
3925: ELSE
3926: push_eval;

Line 3958: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

3954: and d.search_context_id = p_search_ctx_id);
3955: exception
3956: when others then
3957: if (instrb(SQLERRM,'DRG-51030')>0) then
3958: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3959: FND_MSG_PUB.ADD;
3960: RAISE FND_API.G_EXC_ERROR;
3961: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3962: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

Line 3962: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

3958: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3959: FND_MSG_PUB.ADD;
3960: RAISE FND_API.G_EXC_ERROR;
3961: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3962: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3963: FND_MSG_PUB.ADD;
3964: RAISE FND_API.G_EXC_ERROR;
3965: else
3966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4034: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

4030: IF p_index>1 THEN
4031: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4032: 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);
4033: END IF;
4034: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4035: FND_MSG_PUB.ADD;
4036: RAISE FND_API.G_EXC_ERROR;
4037: ELSE
4038: push_eval;

Line 4293: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

4289: IF p_index>1 THEN
4290: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4291: 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);
4292: END IF;
4293: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4294: FND_MSG_PUB.ADD;
4295: RAISE FND_API.G_EXC_ERROR;
4296: ELSE
4297: push_eval;

Line 4406: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

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

Line 4414: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');

4410: ELSE
4411: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4412: 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);
4413: END IF;
4414: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4415: FND_MSG_PUB.ADD;
4416: RAISE FND_API.G_EXC_ERROR;
4417: END IF;
4418: END IF;

Line 4535: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

4531: RAISE FND_API.G_EXC_ERROR;
4532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4534: WHEN OTHERS THEN
4535: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4536: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_persons');
4537: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4538: FND_MSG_PUB.ADD;
4539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4536: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_persons');

4532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4534: WHEN OTHERS THEN
4535: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4536: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_persons');
4537: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4538: FND_MSG_PUB.ADD;
4539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4540: END find_persons;

Line 4537: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

4533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4534: WHEN OTHERS THEN
4535: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4536: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_persons');
4537: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4538: FND_MSG_PUB.ADD;
4539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4540: END find_persons;
4541:

Line 4603: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

4599: RAISE FND_API.G_EXC_ERROR;
4600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4602: WHEN OTHERS THEN
4603: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4604: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_party_details');
4605: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4606: FND_MSG_PUB.ADD;
4607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4604: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_party_details');

4600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4602: WHEN OTHERS THEN
4603: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4604: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_party_details');
4605: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4606: FND_MSG_PUB.ADD;
4607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4608: END find_party_details;

Line 4605: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

4601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4602: WHEN OTHERS THEN
4603: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4604: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_party_details');
4605: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4606: FND_MSG_PUB.ADD;
4607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4608: END find_party_details;
4609:

Line 4720: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

4716: RAISE FND_API.G_EXC_ERROR;
4717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4719: WHEN OTHERS THEN
4720: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4721: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_parties');
4722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4723: FND_MSG_PUB.ADD;
4724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4721: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_parties');

4717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4719: WHEN OTHERS THEN
4720: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4721: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_parties');
4722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4723: FND_MSG_PUB.ADD;
4724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4725: END find_duplicate_parties;

Line 4722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

4718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4719: WHEN OTHERS THEN
4720: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4721: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_parties');
4722: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4723: FND_MSG_PUB.ADD;
4724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4725: END find_duplicate_parties;
4726:

Line 4805: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

4801: RAISE FND_API.G_EXC_ERROR;
4802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4804: WHEN OTHERS THEN
4805: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4806: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_party_sites');
4807: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4808: FND_MSG_PUB.ADD;
4809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4806: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_party_sites');

4802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4804: WHEN OTHERS THEN
4805: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4806: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_party_sites');
4807: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4808: FND_MSG_PUB.ADD;
4809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4810: END find_duplicate_party_sites;

Line 4807: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

4803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4804: WHEN OTHERS THEN
4805: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4806: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_party_sites');
4807: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4808: FND_MSG_PUB.ADD;
4809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4810: END find_duplicate_party_sites;
4811:

Line 4894: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

4890: RAISE FND_API.G_EXC_ERROR;
4891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4893: WHEN OTHERS THEN
4894: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4895: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contacts');
4896: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4897: FND_MSG_PUB.ADD;
4898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4895: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contacts');

4891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4893: WHEN OTHERS THEN
4894: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4895: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contacts');
4896: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4897: FND_MSG_PUB.ADD;
4898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4899: END find_duplicate_contacts;

Line 4896: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

4892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4893: WHEN OTHERS THEN
4894: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4895: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contacts');
4896: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4897: FND_MSG_PUB.ADD;
4898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4899: END find_duplicate_contacts;
4900:

Line 4967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

4963: RAISE FND_API.G_EXC_ERROR;
4964: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4966: WHEN OTHERS THEN
4967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4968: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contact_points');
4969: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4970: FND_MSG_PUB.ADD;
4971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4968: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contact_points');

4964: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4966: WHEN OTHERS THEN
4967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4968: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contact_points');
4969: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4970: FND_MSG_PUB.ADD;
4971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4972: END find_duplicate_contact_points;

Line 4969: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

4965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4966: WHEN OTHERS THEN
4967: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4968: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contact_points');
4969: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4970: FND_MSG_PUB.ADD;
4971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4972: END find_duplicate_contact_points;
4973:

Line 5324: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5320: RAISE FND_API.G_EXC_ERROR;
5321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5323: WHEN OTHERS THEN
5324: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5325: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.call_api_dynamic');
5326: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5327: FND_MSG_PUB.ADD;
5328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5325: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.call_api_dynamic');

5321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5323: WHEN OTHERS THEN
5324: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5325: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.call_api_dynamic');
5326: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5327: FND_MSG_PUB.ADD;
5328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5329: END call_api_dynamic;

Line 5326: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5323: WHEN OTHERS THEN
5324: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5325: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.call_api_dynamic');
5326: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5327: FND_MSG_PUB.ADD;
5328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5329: END call_api_dynamic;
5330:

Line 5569: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5565: RAISE FND_API.G_EXC_ERROR;
5566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5568: WHEN OTHERS THEN
5569: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5570: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_party_sites');
5571: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5572: FND_MSG_PUB.ADD;
5573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5570: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_party_sites');

5566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5568: WHEN OTHERS THEN
5569: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5570: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_party_sites');
5571: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5572: FND_MSG_PUB.ADD;
5573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5574: END get_matching_party_sites;

Line 5571: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5568: WHEN OTHERS THEN
5569: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5570: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_party_sites');
5571: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5572: FND_MSG_PUB.ADD;
5573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5574: END get_matching_party_sites;
5575:

Line 5797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5793: RAISE FND_API.G_EXC_ERROR;
5794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5796: WHEN OTHERS THEN
5797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5798: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contacts');
5799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5800: FND_MSG_PUB.ADD;
5801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5798: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contacts');

5794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5796: WHEN OTHERS THEN
5797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5798: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contacts');
5799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5800: FND_MSG_PUB.ADD;
5801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5802: END get_matching_contacts;

Line 5799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5796: WHEN OTHERS THEN
5797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5798: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contacts');
5799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5800: FND_MSG_PUB.ADD;
5801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5802: END get_matching_contacts;
5803:

Line 5939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

5935: RAISE FND_API.G_EXC_ERROR;
5936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5938: WHEN OTHERS THEN
5939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5940: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contact_points');
5941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5942: FND_MSG_PUB.ADD;
5943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5940: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contact_points');

5936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5938: WHEN OTHERS THEN
5939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5940: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contact_points');
5941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5942: FND_MSG_PUB.ADD;
5943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5944: END get_matching_contact_points;

Line 5941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

5937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5938: WHEN OTHERS THEN
5939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5940: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contact_points');
5941: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5942: FND_MSG_PUB.ADD;
5943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5944: END get_matching_contact_points;
5945:

Line 6181: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

6177: RAISE FND_API.G_EXC_ERROR;
6178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6180: WHEN OTHERS THEN
6181: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6182: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_score_details');
6183: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6184: FND_MSG_PUB.ADD;
6185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6182: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_score_details');

6178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6180: WHEN OTHERS THEN
6181: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6182: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_score_details');
6183: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6184: FND_MSG_PUB.ADD;
6185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6186: END get_score_details;

Line 6183: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

6179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6180: WHEN OTHERS THEN
6181: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6182: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_score_details');
6183: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6184: FND_MSG_PUB.ADD;
6185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6186: END get_score_details;
6187:

Line 6291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

6287: RAISE FND_API.G_EXC_ERROR;
6288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6290: WHEN OTHERS THEN
6291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6292: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6294: FND_MSG_PUB.ADD;
6295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6292: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');

6288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6290: WHEN OTHERS THEN
6291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6292: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6294: FND_MSG_PUB.ADD;
6295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6296: END get_party_for_search;

Line 6293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

6289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6290: WHEN OTHERS THEN
6291: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6292: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6293: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6294: FND_MSG_PUB.ADD;
6295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6296: END get_party_for_search;
6297:

Line 6337: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

6333: RAISE FND_API.G_EXC_ERROR;
6334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6336: WHEN OTHERS THEN
6337: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6338: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6339: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6340: FND_MSG_PUB.ADD;
6341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6338: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');

6334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6336: WHEN OTHERS THEN
6337: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6338: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6339: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6340: FND_MSG_PUB.ADD;
6341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6342: END get_search_criteria;

Line 6339: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

6335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6336: WHEN OTHERS THEN
6337: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6338: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6339: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6340: FND_MSG_PUB.ADD;
6341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6342: END get_search_criteria;
6343:

Line 6403: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

6399: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
6400:
6401: EXCEPTION
6402: WHEN OTHERS THEN
6403: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6404: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6405: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6407: FND_MSG_PUB.ADD;

Line 6404: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');

6400:
6401: EXCEPTION
6402: WHEN OTHERS THEN
6403: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6404: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6405: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6407: FND_MSG_PUB.ADD;
6408: RAISE FND_API.G_EXC_ERROR;

Line 6405: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);

6401: EXCEPTION
6402: WHEN OTHERS THEN
6403: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6404: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6405: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6407: FND_MSG_PUB.ADD;
6408: RAISE FND_API.G_EXC_ERROR;
6409: END get_party_rec;

Line 6406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

6402: WHEN OTHERS THEN
6403: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6404: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6405: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6406: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6407: FND_MSG_PUB.ADD;
6408: RAISE FND_API.G_EXC_ERROR;
6409: END get_party_rec;
6410:

Line 6467: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

6463: END LOOP;
6464:
6465: EXCEPTION
6466: WHEN OTHERS THEN
6467: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6468: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6469: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6470: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6471: FND_MSG_PUB.ADD;

Line 6468: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');

6464:
6465: EXCEPTION
6466: WHEN OTHERS THEN
6467: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6468: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6469: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6470: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6471: FND_MSG_PUB.ADD;
6472: RAISE FND_API.G_EXC_ERROR;

Line 6469: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);

6465: EXCEPTION
6466: WHEN OTHERS THEN
6467: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6468: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6469: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6470: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6471: FND_MSG_PUB.ADD;
6472: RAISE FND_API.G_EXC_ERROR;
6473: END get_party_site_rec;

Line 6470: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

6466: WHEN OTHERS THEN
6467: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6468: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6469: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6470: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6471: FND_MSG_PUB.ADD;
6472: RAISE FND_API.G_EXC_ERROR;
6473: END get_party_site_rec;
6474:

Line 6523: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

6519: END LOOP;
6520:
6521: EXCEPTION
6522: WHEN OTHERS THEN
6523: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6524: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6525: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6526: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6527: FND_MSG_PUB.ADD;

Line 6524: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');

6520:
6521: EXCEPTION
6522: WHEN OTHERS THEN
6523: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6524: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6525: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6526: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6527: FND_MSG_PUB.ADD;
6528: RAISE FND_API.G_EXC_ERROR;

Line 6525: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);

6521: EXCEPTION
6522: WHEN OTHERS THEN
6523: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6524: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6525: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6526: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6527: FND_MSG_PUB.ADD;
6528: RAISE FND_API.G_EXC_ERROR;
6529: END get_contact_rec;

Line 6526: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

6522: WHEN OTHERS THEN
6523: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6524: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6525: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6526: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6527: FND_MSG_PUB.ADD;
6528: RAISE FND_API.G_EXC_ERROR;
6529: END get_contact_rec;
6530:

Line 6579: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');

6575: END LOOP;
6576:
6577: EXCEPTION
6578: WHEN OTHERS THEN
6579: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6580: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6581: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6582: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6583: FND_MSG_PUB.ADD;

Line 6580: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');

6576:
6577: EXCEPTION
6578: WHEN OTHERS THEN
6579: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6580: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6581: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6582: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6583: FND_MSG_PUB.ADD;
6584: RAISE FND_API.G_EXC_ERROR;

Line 6581: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);

6577: EXCEPTION
6578: WHEN OTHERS THEN
6579: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6580: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6581: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6582: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6583: FND_MSG_PUB.ADD;
6584: RAISE FND_API.G_EXC_ERROR;
6585: END get_contact_point_rec;

Line 6582: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

6578: WHEN OTHERS THEN
6579: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6580: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6581: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6582: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6583: FND_MSG_PUB.ADD;
6584: RAISE FND_API.G_EXC_ERROR;
6585: END get_contact_point_rec;
6586:

Line 6773: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

6769: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6770: END IF;
6771: EXCEPTION
6772: WHEN OTHERS THEN
6773: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6774: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6775: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6776: FND_MSG_PUB.ADD;
6777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6774: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');

6770: END IF;
6771: EXCEPTION
6772: WHEN OTHERS THEN
6773: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6774: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6775: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6776: FND_MSG_PUB.ADD;
6777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6778: END;

Line 6775: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

6771: EXCEPTION
6772: WHEN OTHERS THEN
6773: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6774: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6775: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6776: FND_MSG_PUB.ADD;
6777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6778: END;
6779:

Line 7014: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

7010: END IF;
7011: END LOOP;
7012: EXCEPTION
7013: WHEN OTHERS THEN
7014: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7015: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7016: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7017: FND_MSG_PUB.ADD;
7018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7015: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');

7011: END LOOP;
7012: EXCEPTION
7013: WHEN OTHERS THEN
7014: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7015: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7016: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7017: FND_MSG_PUB.ADD;
7018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7019: END;

Line 7016: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

7012: EXCEPTION
7013: WHEN OTHERS THEN
7014: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7015: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7016: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7017: FND_MSG_PUB.ADD;
7018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7019: END;
7020:

Line 7056: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

7052: END IF;
7053: NULL;
7054: EXCEPTION
7055: WHEN OTHERS THEN
7056: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7057: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7058: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7059: FND_MSG_PUB.ADD;
7060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7057: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');

7053: NULL;
7054: EXCEPTION
7055: WHEN OTHERS THEN
7056: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7057: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7058: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7059: FND_MSG_PUB.ADD;
7060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7061: END;

Line 7058: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

7054: EXCEPTION
7055: WHEN OTHERS THEN
7056: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7057: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7058: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7059: FND_MSG_PUB.ADD;
7060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7061: END;
7062:

Line 7187: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

7183: END IF;
7184: END LOOP;
7185: EXCEPTION
7186: WHEN OTHERS THEN
7187: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7188: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7189: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7190: FND_MSG_PUB.ADD;
7191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7188: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');

7184: END LOOP;
7185: EXCEPTION
7186: WHEN OTHERS THEN
7187: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7188: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7189: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7190: FND_MSG_PUB.ADD;
7191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7192: END;

Line 7189: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

7185: EXCEPTION
7186: WHEN OTHERS THEN
7187: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7188: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7189: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7190: FND_MSG_PUB.ADD;
7191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7192: END;
7193:

Line 7214: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');

7210: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
7211: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
7212: OR p_contact_point_list(I).URL IS NOT NULL
7213: ) THEN
7214: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7215: FND_MSG_PUB.ADD;
7216: RAISE FND_API.G_EXC_ERROR;
7217: END IF;
7218: END LOOP;

Line 7280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

7276: EXCEPTION
7277: WHEN FND_API.G_EXC_ERROR THEN
7278: RAISE FND_API.G_EXC_ERROR;
7279: WHEN OTHERS THEN
7280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7281: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7282: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7283: FND_MSG_PUB.ADD;
7284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7281: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');

7277: WHEN FND_API.G_EXC_ERROR THEN
7278: RAISE FND_API.G_EXC_ERROR;
7279: WHEN OTHERS THEN
7280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7281: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7282: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7283: FND_MSG_PUB.ADD;
7284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7285: END check_prim_cond;

Line 7282: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

7278: RAISE FND_API.G_EXC_ERROR;
7279: WHEN OTHERS THEN
7280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7281: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7282: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7283: FND_MSG_PUB.ADD;
7284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7285: END check_prim_cond;
7286:

Line 7344: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

7340: EXIT WHEN x_secondary;
7341: END LOOP;
7342: EXCEPTION
7343: WHEN OTHERS THEN
7344: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7345: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7346: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7347: FND_MSG_PUB.ADD;
7348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7345: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');

7341: END LOOP;
7342: EXCEPTION
7343: WHEN OTHERS THEN
7344: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7345: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7346: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7347: FND_MSG_PUB.ADD;
7348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7349: END check_party_site_cond;

Line 7346: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

7342: EXCEPTION
7343: WHEN OTHERS THEN
7344: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7345: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7346: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7347: FND_MSG_PUB.ADD;
7348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7349: END check_party_site_cond;
7350:

Line 7392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

7388: EXIT WHEN x_secondary;
7389: END LOOP;
7390: EXCEPTION
7391: WHEN OTHERS THEN
7392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7393: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7394: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7395: FND_MSG_PUB.ADD;
7396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7393: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');

7389: END LOOP;
7390: EXCEPTION
7391: WHEN OTHERS THEN
7392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7393: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7394: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7395: FND_MSG_PUB.ADD;
7396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7397: END check_contact_cond;

Line 7394: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

7390: EXCEPTION
7391: WHEN OTHERS THEN
7392: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7393: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7394: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7395: FND_MSG_PUB.ADD;
7396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7397: END check_contact_cond;
7398:

Line 7415: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');

7411: x_secondary:= FALSE;
7412:
7413: FOR I IN 1..p_contact_point_list.COUNT LOOP
7414: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7415: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7416: FND_MSG_PUB.ADD;
7417: RAISE FND_API.G_EXC_ERROR;
7418: END IF;
7419: END LOOP;

Line 7439: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

7435: EXIT WHEN x_secondary;
7436: END LOOP;
7437: EXCEPTION
7438: WHEN OTHERS THEN
7439: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7440: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7441: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7442: FND_MSG_PUB.ADD;
7443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7440: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');

7436: END LOOP;
7437: EXCEPTION
7438: WHEN OTHERS THEN
7439: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7440: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7441: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7442: FND_MSG_PUB.ADD;
7443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7444: END check_contact_point_cond;

Line 7441: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );

7437: EXCEPTION
7438: WHEN OTHERS THEN
7439: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7440: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7441: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7442: FND_MSG_PUB.ADD;
7443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7444: END check_contact_point_cond;
7445: