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 1939: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2923: IF p_index>1 THEN
2924: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2925: 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);
2926: END IF;
2927: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
2928: FND_MSG_PUB.ADD;
2929: RAISE FND_API.G_EXC_ERROR;
2930: ELSE
2931: push_eval;

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

2996: IF p_index>1 THEN
2997: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2998: 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);
2999: END IF;
3000: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3001: FND_MSG_PUB.ADD;
3002: RAISE FND_API.G_EXC_ERROR;
3003: ELSE
3004: push_eval;

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

3108: IF p_index>1 THEN
3109: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3110: 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);
3111: END IF;
3112: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3113: FND_MSG_PUB.ADD;
3114: RAISE FND_API.G_EXC_ERROR;
3115: ELSE
3116: push_eval;

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

3219: IF p_index>1 THEN
3220: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3221: 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);
3222: END IF;
3223: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3224: FND_MSG_PUB.ADD;
3225: RAISE FND_API.G_EXC_ERROR;
3226: ELSE
3227: push_eval;

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

3444: ELSE
3445: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3446: 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);
3447: END IF;
3448: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3449: FND_MSG_PUB.ADD;
3450: RAISE FND_API.G_EXC_ERROR;
3451: END IF;
3452: ELSE

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

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

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

3658: RAISE FND_API.G_EXC_ERROR;
3659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3661: WHEN OTHERS THEN
3662: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3663: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_parties');
3664: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3665: FND_MSG_PUB.ADD;
3666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3661: WHEN OTHERS THEN
3662: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3663: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_parties');
3664: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3665: FND_MSG_PUB.ADD;
3666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3667: END find_parties;

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

3660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3661: WHEN OTHERS THEN
3662: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3663: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_parties');
3664: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3665: FND_MSG_PUB.ADD;
3666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3667: END find_parties;
3668:

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

3862: IF p_index>1 THEN
3863: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3864: 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);
3865: END IF;
3866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3867: FND_MSG_PUB.ADD;
3868: RAISE FND_API.G_EXC_ERROR;
3869: ELSE
3870: push_eval;

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

3910: IF p_index>1 THEN
3911: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3912: 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);
3913: END IF;
3914: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3915: FND_MSG_PUB.ADD;
3916: RAISE FND_API.G_EXC_ERROR;
3917: ELSE
3918: push_eval;

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

3946: and d.search_context_id = p_search_ctx_id);
3947: exception
3948: when others then
3949: if (instrb(SQLERRM,'DRG-51030')>0) then
3950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3951: FND_MSG_PUB.ADD;
3952: RAISE FND_API.G_EXC_ERROR;
3953: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3954: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

3950: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
3951: FND_MSG_PUB.ADD;
3952: RAISE FND_API.G_EXC_ERROR;
3953: elsif (instrb(SQLERRM,'DRG-50943')>0) then
3954: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
3955: FND_MSG_PUB.ADD;
3956: RAISE FND_API.G_EXC_ERROR;
3957: else
3958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4022: IF p_index>1 THEN
4023: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4024: 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);
4025: END IF;
4026: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4027: FND_MSG_PUB.ADD;
4028: RAISE FND_API.G_EXC_ERROR;
4029: ELSE
4030: push_eval;

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

4281: IF p_index>1 THEN
4282: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4283: 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);
4284: END IF;
4285: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4286: FND_MSG_PUB.ADD;
4287: RAISE FND_API.G_EXC_ERROR;
4288: ELSE
4289: push_eval;

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

4394: ELSE
4395: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4396: 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);
4397: END IF;
4398: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4399: FND_MSG_PUB.ADD;
4400: RAISE FND_API.G_EXC_ERROR;
4401: END IF;
4402: ELSE

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: END IF;

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

4523: RAISE FND_API.G_EXC_ERROR;
4524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4526: WHEN OTHERS THEN
4527: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4528: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_persons');
4529: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4530: FND_MSG_PUB.ADD;
4531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4526: WHEN OTHERS THEN
4527: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4528: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_persons');
4529: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4530: FND_MSG_PUB.ADD;
4531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4532: END find_persons;

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

4525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4526: WHEN OTHERS THEN
4527: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4528: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_persons');
4529: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4530: FND_MSG_PUB.ADD;
4531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4532: END find_persons;
4533:

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

4591: RAISE FND_API.G_EXC_ERROR;
4592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4594: WHEN OTHERS THEN
4595: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4596: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_party_details');
4597: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4598: FND_MSG_PUB.ADD;
4599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4594: WHEN OTHERS THEN
4595: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4596: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_party_details');
4597: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4598: FND_MSG_PUB.ADD;
4599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4600: END find_party_details;

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

4593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4594: WHEN OTHERS THEN
4595: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4596: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_party_details');
4597: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4598: FND_MSG_PUB.ADD;
4599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4600: END find_party_details;
4601:

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

4708: RAISE FND_API.G_EXC_ERROR;
4709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4711: WHEN OTHERS THEN
4712: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4713: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_parties');
4714: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4715: FND_MSG_PUB.ADD;
4716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4711: WHEN OTHERS THEN
4712: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4713: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_parties');
4714: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4715: FND_MSG_PUB.ADD;
4716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4717: END find_duplicate_parties;

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

4710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4711: WHEN OTHERS THEN
4712: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4713: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_parties');
4714: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4715: FND_MSG_PUB.ADD;
4716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4717: END find_duplicate_parties;
4718:

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

4793: RAISE FND_API.G_EXC_ERROR;
4794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4796: WHEN OTHERS THEN
4797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4798: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_party_sites');
4799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4800: FND_MSG_PUB.ADD;
4801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4796: WHEN OTHERS THEN
4797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4798: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_party_sites');
4799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4800: FND_MSG_PUB.ADD;
4801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4802: END find_duplicate_party_sites;

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

4795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4796: WHEN OTHERS THEN
4797: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4798: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_party_sites');
4799: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4800: FND_MSG_PUB.ADD;
4801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4802: END find_duplicate_party_sites;
4803:

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

4882: RAISE FND_API.G_EXC_ERROR;
4883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4885: WHEN OTHERS THEN
4886: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4887: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contacts');
4888: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4889: FND_MSG_PUB.ADD;
4890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4885: WHEN OTHERS THEN
4886: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4887: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contacts');
4888: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4889: FND_MSG_PUB.ADD;
4890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4891: END find_duplicate_contacts;

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

4884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4885: WHEN OTHERS THEN
4886: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4887: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contacts');
4888: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4889: FND_MSG_PUB.ADD;
4890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4891: END find_duplicate_contacts;
4892:

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

4955: RAISE FND_API.G_EXC_ERROR;
4956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4958: WHEN OTHERS THEN
4959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4960: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contact_points');
4961: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4962: FND_MSG_PUB.ADD;
4963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4958: WHEN OTHERS THEN
4959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4960: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contact_points');
4961: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4962: FND_MSG_PUB.ADD;
4963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4964: END find_duplicate_contact_points;

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

4957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4958: WHEN OTHERS THEN
4959: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4960: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.find_duplicate_contact_points');
4961: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4962: FND_MSG_PUB.ADD;
4963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4964: END find_duplicate_contact_points;
4965:

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

5312: RAISE FND_API.G_EXC_ERROR;
5313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5315: WHEN OTHERS THEN
5316: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5317: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.call_api_dynamic');
5318: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5319: FND_MSG_PUB.ADD;
5320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5315: WHEN OTHERS THEN
5316: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5317: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.call_api_dynamic');
5318: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5319: FND_MSG_PUB.ADD;
5320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5321: END call_api_dynamic;

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

5314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5315: WHEN OTHERS THEN
5316: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5317: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.call_api_dynamic');
5318: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5319: FND_MSG_PUB.ADD;
5320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5321: END call_api_dynamic;
5322:

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

5557: RAISE FND_API.G_EXC_ERROR;
5558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5560: WHEN OTHERS THEN
5561: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5562: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_party_sites');
5563: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5564: FND_MSG_PUB.ADD;
5565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5560: WHEN OTHERS THEN
5561: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5562: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_party_sites');
5563: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5564: FND_MSG_PUB.ADD;
5565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5566: END get_matching_party_sites;

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

5559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5560: WHEN OTHERS THEN
5561: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5562: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_party_sites');
5563: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5564: FND_MSG_PUB.ADD;
5565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5566: END get_matching_party_sites;
5567:

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

5785: RAISE FND_API.G_EXC_ERROR;
5786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5788: WHEN OTHERS THEN
5789: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5790: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contacts');
5791: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5792: FND_MSG_PUB.ADD;
5793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5788: WHEN OTHERS THEN
5789: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5790: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contacts');
5791: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5792: FND_MSG_PUB.ADD;
5793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5794: END get_matching_contacts;

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

5787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5788: WHEN OTHERS THEN
5789: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5790: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contacts');
5791: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5792: FND_MSG_PUB.ADD;
5793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5794: END get_matching_contacts;
5795:

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

5927: RAISE FND_API.G_EXC_ERROR;
5928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5930: WHEN OTHERS THEN
5931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5932: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contact_points');
5933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5934: FND_MSG_PUB.ADD;
5935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5930: WHEN OTHERS THEN
5931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5932: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contact_points');
5933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5934: FND_MSG_PUB.ADD;
5935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5936: END get_matching_contact_points;

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

5929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5930: WHEN OTHERS THEN
5931: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5932: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_matching_contact_points');
5933: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5934: FND_MSG_PUB.ADD;
5935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5936: END get_matching_contact_points;
5937:

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

6166: RAISE FND_API.G_EXC_ERROR;
6167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6169: WHEN OTHERS THEN
6170: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6171: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_score_details');
6172: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6173: FND_MSG_PUB.ADD;
6174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6169: WHEN OTHERS THEN
6170: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6171: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_score_details');
6172: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6173: FND_MSG_PUB.ADD;
6174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6175: END get_score_details;

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

6168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6169: WHEN OTHERS THEN
6170: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6171: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_62.get_score_details');
6172: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6173: FND_MSG_PUB.ADD;
6174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6175: END get_score_details;
6176:

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

6276: RAISE FND_API.G_EXC_ERROR;
6277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6279: WHEN OTHERS THEN
6280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6281: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6282: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6283: FND_MSG_PUB.ADD;
6284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6279: WHEN OTHERS THEN
6280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6281: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6282: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6283: FND_MSG_PUB.ADD;
6284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6285: END get_party_for_search;

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

6278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6279: WHEN OTHERS THEN
6280: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6281: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6282: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6283: FND_MSG_PUB.ADD;
6284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6285: END get_party_for_search;
6286:

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

6322: RAISE FND_API.G_EXC_ERROR;
6323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6325: WHEN OTHERS THEN
6326: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6327: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6328: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6329: FND_MSG_PUB.ADD;
6330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6325: WHEN OTHERS THEN
6326: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6327: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6328: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6329: FND_MSG_PUB.ADD;
6330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6331: END get_search_criteria;

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

6324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6325: WHEN OTHERS THEN
6326: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6327: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6328: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6329: FND_MSG_PUB.ADD;
6330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6331: END get_search_criteria;
6332:

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

6388: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
6389:
6390: EXCEPTION
6391: WHEN OTHERS THEN
6392: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6393: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6394: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6395: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6396: FND_MSG_PUB.ADD;

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

6389:
6390: EXCEPTION
6391: WHEN OTHERS THEN
6392: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6393: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6394: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6395: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6396: FND_MSG_PUB.ADD;
6397: RAISE FND_API.G_EXC_ERROR;

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

6390: EXCEPTION
6391: WHEN OTHERS THEN
6392: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6393: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6394: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6395: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6396: FND_MSG_PUB.ADD;
6397: RAISE FND_API.G_EXC_ERROR;
6398: END get_party_rec;

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

6391: WHEN OTHERS THEN
6392: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6393: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6394: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6395: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6396: FND_MSG_PUB.ADD;
6397: RAISE FND_API.G_EXC_ERROR;
6398: END get_party_rec;
6399:

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

6452: END LOOP;
6453:
6454: EXCEPTION
6455: WHEN OTHERS THEN
6456: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6457: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6458: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6459: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6460: FND_MSG_PUB.ADD;

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

6453:
6454: EXCEPTION
6455: WHEN OTHERS THEN
6456: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6457: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6458: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6459: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6460: FND_MSG_PUB.ADD;
6461: RAISE FND_API.G_EXC_ERROR;

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

6454: EXCEPTION
6455: WHEN OTHERS THEN
6456: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6457: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6458: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6459: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6460: FND_MSG_PUB.ADD;
6461: RAISE FND_API.G_EXC_ERROR;
6462: END get_party_site_rec;

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

6455: WHEN OTHERS THEN
6456: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6457: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6458: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6459: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6460: FND_MSG_PUB.ADD;
6461: RAISE FND_API.G_EXC_ERROR;
6462: END get_party_site_rec;
6463:

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

6508: END LOOP;
6509:
6510: EXCEPTION
6511: WHEN OTHERS THEN
6512: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6513: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6514: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6516: FND_MSG_PUB.ADD;

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

6509:
6510: EXCEPTION
6511: WHEN OTHERS THEN
6512: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6513: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6514: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6516: FND_MSG_PUB.ADD;
6517: RAISE FND_API.G_EXC_ERROR;

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

6510: EXCEPTION
6511: WHEN OTHERS THEN
6512: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6513: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6514: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6516: FND_MSG_PUB.ADD;
6517: RAISE FND_API.G_EXC_ERROR;
6518: END get_contact_rec;

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

6511: WHEN OTHERS THEN
6512: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6513: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6514: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6515: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6516: FND_MSG_PUB.ADD;
6517: RAISE FND_API.G_EXC_ERROR;
6518: END get_contact_rec;
6519:

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

6564: END LOOP;
6565:
6566: EXCEPTION
6567: WHEN OTHERS THEN
6568: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6569: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6570: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6571: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6572: FND_MSG_PUB.ADD;

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

6565:
6566: EXCEPTION
6567: WHEN OTHERS THEN
6568: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6569: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6570: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6571: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6572: FND_MSG_PUB.ADD;
6573: RAISE FND_API.G_EXC_ERROR;

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

6566: EXCEPTION
6567: WHEN OTHERS THEN
6568: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6569: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6570: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6571: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6572: FND_MSG_PUB.ADD;
6573: RAISE FND_API.G_EXC_ERROR;
6574: END get_contact_point_rec;

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

6567: WHEN OTHERS THEN
6568: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6569: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6570: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6571: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6572: FND_MSG_PUB.ADD;
6573: RAISE FND_API.G_EXC_ERROR;
6574: END get_contact_point_rec;
6575:

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

6758: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6759: END IF;
6760: EXCEPTION
6761: WHEN OTHERS THEN
6762: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6763: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6764: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6765: FND_MSG_PUB.ADD;
6766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6759: END IF;
6760: EXCEPTION
6761: WHEN OTHERS THEN
6762: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6763: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6764: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6765: FND_MSG_PUB.ADD;
6766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6767: END;

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

6760: EXCEPTION
6761: WHEN OTHERS THEN
6762: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6763: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6764: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6765: FND_MSG_PUB.ADD;
6766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6767: END;
6768:

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

6999: END IF;
7000: END LOOP;
7001: EXCEPTION
7002: WHEN OTHERS THEN
7003: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7004: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7005: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7006: FND_MSG_PUB.ADD;
7007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7000: END LOOP;
7001: EXCEPTION
7002: WHEN OTHERS THEN
7003: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7004: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7005: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7006: FND_MSG_PUB.ADD;
7007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7008: END;

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

7001: EXCEPTION
7002: WHEN OTHERS THEN
7003: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7004: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7005: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7006: FND_MSG_PUB.ADD;
7007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7008: END;
7009:

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

7041: END IF;
7042: NULL;
7043: EXCEPTION
7044: WHEN OTHERS THEN
7045: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7046: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7047: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7048: FND_MSG_PUB.ADD;
7049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7042: NULL;
7043: EXCEPTION
7044: WHEN OTHERS THEN
7045: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7046: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7047: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7048: FND_MSG_PUB.ADD;
7049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7050: END;

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

7043: EXCEPTION
7044: WHEN OTHERS THEN
7045: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7046: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7047: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7048: FND_MSG_PUB.ADD;
7049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7050: END;
7051:

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

7172: END IF;
7173: END LOOP;
7174: EXCEPTION
7175: WHEN OTHERS THEN
7176: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7177: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7178: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7179: FND_MSG_PUB.ADD;
7180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7173: END LOOP;
7174: EXCEPTION
7175: WHEN OTHERS THEN
7176: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7177: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7178: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7179: FND_MSG_PUB.ADD;
7180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7181: END;

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

7174: EXCEPTION
7175: WHEN OTHERS THEN
7176: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7177: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7178: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7179: FND_MSG_PUB.ADD;
7180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7181: END;
7182:

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

7199: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
7200: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
7201: OR p_contact_point_list(I).URL IS NOT NULL
7202: ) THEN
7203: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7204: FND_MSG_PUB.ADD;
7205: RAISE FND_API.G_EXC_ERROR;
7206: END IF;
7207: END LOOP;

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

7265: EXCEPTION
7266: WHEN FND_API.G_EXC_ERROR THEN
7267: RAISE FND_API.G_EXC_ERROR;
7268: WHEN OTHERS THEN
7269: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7270: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7271: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7272: FND_MSG_PUB.ADD;
7273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7266: WHEN FND_API.G_EXC_ERROR THEN
7267: RAISE FND_API.G_EXC_ERROR;
7268: WHEN OTHERS THEN
7269: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7270: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7271: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7272: FND_MSG_PUB.ADD;
7273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7274: END check_prim_cond;

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

7267: RAISE FND_API.G_EXC_ERROR;
7268: WHEN OTHERS THEN
7269: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7270: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7271: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7272: FND_MSG_PUB.ADD;
7273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7274: END check_prim_cond;
7275:

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

7329: EXIT WHEN x_secondary;
7330: END LOOP;
7331: EXCEPTION
7332: WHEN OTHERS THEN
7333: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7334: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7335: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7336: FND_MSG_PUB.ADD;
7337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7330: END LOOP;
7331: EXCEPTION
7332: WHEN OTHERS THEN
7333: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7334: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7335: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7336: FND_MSG_PUB.ADD;
7337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7338: END check_party_site_cond;

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

7331: EXCEPTION
7332: WHEN OTHERS THEN
7333: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7334: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7335: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7336: FND_MSG_PUB.ADD;
7337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7338: END check_party_site_cond;
7339:

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

7377: EXIT WHEN x_secondary;
7378: END LOOP;
7379: EXCEPTION
7380: WHEN OTHERS THEN
7381: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7382: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7383: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7384: FND_MSG_PUB.ADD;
7385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7378: END LOOP;
7379: EXCEPTION
7380: WHEN OTHERS THEN
7381: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7382: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7383: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7384: FND_MSG_PUB.ADD;
7385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7386: END check_contact_cond;

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

7379: EXCEPTION
7380: WHEN OTHERS THEN
7381: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7382: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7383: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7384: FND_MSG_PUB.ADD;
7385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7386: END check_contact_cond;
7387:

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

7400: x_secondary:= FALSE;
7401:
7402: FOR I IN 1..p_contact_point_list.COUNT LOOP
7403: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7404: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7405: FND_MSG_PUB.ADD;
7406: RAISE FND_API.G_EXC_ERROR;
7407: END IF;
7408: END LOOP;

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

7424: EXIT WHEN x_secondary;
7425: END LOOP;
7426: EXCEPTION
7427: WHEN OTHERS THEN
7428: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7429: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7430: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7431: FND_MSG_PUB.ADD;
7432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7425: END LOOP;
7426: EXCEPTION
7427: WHEN OTHERS THEN
7428: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7429: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7430: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7431: FND_MSG_PUB.ADD;
7432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7433: END check_contact_point_cond;

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

7426: EXCEPTION
7427: WHEN OTHERS THEN
7428: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7429: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7430: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7431: FND_MSG_PUB.ADD;
7432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7433: END check_contact_point_cond;
7434: