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_60 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 1030: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1428: ELSE
1429: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1430: END IF;
1431: IF lengthb(l_party_contains_str) > 4000 THEN
1432: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1433: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1434: FND_MSG_PUB.ADD;
1435: RAISE FND_API.G_EXC_ERROR;
1436: END IF;

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

1429: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1430: END IF;
1431: IF lengthb(l_party_contains_str) > 4000 THEN
1432: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1433: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1434: FND_MSG_PUB.ADD;
1435: RAISE FND_API.G_EXC_ERROR;
1436: END IF;
1437: IF (p_match_str = ' AND ' OR p_party_max_score

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

1541: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1542: END LOOP;
1543: -- Add the search criteria to query string
1544: IF lengthb(l_contains_str) > 4000 THEN
1545: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1546: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1547: FND_MSG_PUB.ADD;
1548: RAISE FND_API.G_EXC_ERROR;
1549: END IF;

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

1542: END LOOP;
1543: -- Add the search criteria to query string
1544: IF lengthb(l_contains_str) > 4000 THEN
1545: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1546: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1547: FND_MSG_PUB.ADD;
1548: RAISE FND_API.G_EXC_ERROR;
1549: END IF;
1550: x_denorm_str := l_den_contains_str;

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

1588: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1589: END LOOP;
1590: -- Add the search criteria to query string
1591: IF lengthb(l_contains_str) > 4000 THEN
1592: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1593: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1594: FND_MSG_PUB.ADD;
1595: RAISE FND_API.G_EXC_ERROR;
1596: END IF;

Line 1593: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');

1589: END LOOP;
1590: -- Add the search criteria to query string
1591: IF lengthb(l_contains_str) > 4000 THEN
1592: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1593: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1594: FND_MSG_PUB.ADD;
1595: RAISE FND_API.G_EXC_ERROR;
1596: END IF;
1597: x_denorm_str := l_den_contains_str;

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

1669: END IF;
1670: END LOOP;
1671: -- Add the search criteria to query string
1672: IF lengthb(l_contains_str) > 4000 THEN
1673: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1674: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1675: FND_MSG_PUB.ADD;
1676: RAISE FND_API.G_EXC_ERROR;
1677: END IF;

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

1670: END LOOP;
1671: -- Add the search criteria to query string
1672: IF lengthb(l_contains_str) > 4000 THEN
1673: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1674: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1675: FND_MSG_PUB.ADD;
1676: RAISE FND_API.G_EXC_ERROR;
1677: END IF;
1678: x_denorm_str := l_den_contains_str;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3667: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_parties');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4531: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_persons');

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

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

4528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4529: WHEN OTHERS THEN
4530: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4531: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_persons');
4532: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4533: FND_MSG_PUB.ADD;
4534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4535: END find_persons;
4536:

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

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

Line 4599: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_party_details');

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

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

4596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4597: WHEN OTHERS THEN
4598: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4599: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_party_details');
4600: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4601: FND_MSG_PUB.ADD;
4602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4603: END find_party_details;
4604:

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

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

Line 4716: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_parties');

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

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

4713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4714: WHEN OTHERS THEN
4715: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4716: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_parties');
4717: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4718: FND_MSG_PUB.ADD;
4719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4720: END find_duplicate_parties;
4721:

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

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

Line 4801: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_party_sites');

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

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

4798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4799: WHEN OTHERS THEN
4800: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4801: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_party_sites');
4802: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4803: FND_MSG_PUB.ADD;
4804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4805: END find_duplicate_party_sites;
4806:

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

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

Line 4890: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_contacts');

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

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

4887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4888: WHEN OTHERS THEN
4889: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4890: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_contacts');
4891: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4892: FND_MSG_PUB.ADD;
4893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4894: END find_duplicate_contacts;
4895:

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

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

Line 4963: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_contact_points');

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

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

4960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4961: WHEN OTHERS THEN
4962: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4963: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_contact_points');
4964: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4965: FND_MSG_PUB.ADD;
4966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4967: END find_duplicate_contact_points;
4968:

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

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

Line 5320: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.call_api_dynamic');

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

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

5317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5318: WHEN OTHERS THEN
5319: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5320: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.call_api_dynamic');
5321: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5322: FND_MSG_PUB.ADD;
5323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5324: END call_api_dynamic;
5325:

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

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

Line 5565: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_party_sites');

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

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

5562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5563: WHEN OTHERS THEN
5564: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5565: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_party_sites');
5566: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5567: FND_MSG_PUB.ADD;
5568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5569: END get_matching_party_sites;
5570:

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

5789: RAISE FND_API.G_EXC_ERROR;
5790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5792: WHEN OTHERS THEN
5793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5794: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contacts');
5795: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5796: FND_MSG_PUB.ADD;
5797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5794: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contacts');

5790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5792: WHEN OTHERS THEN
5793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5794: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contacts');
5795: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5796: FND_MSG_PUB.ADD;
5797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5798: END get_matching_contacts;

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

5791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5792: WHEN OTHERS THEN
5793: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5794: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contacts');
5795: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5796: FND_MSG_PUB.ADD;
5797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5798: END get_matching_contacts;
5799:

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

5931: RAISE FND_API.G_EXC_ERROR;
5932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5934: WHEN OTHERS THEN
5935: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5936: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contact_points');
5937: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5938: FND_MSG_PUB.ADD;
5939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5936: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contact_points');

5932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5934: WHEN OTHERS THEN
5935: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5936: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contact_points');
5937: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5938: FND_MSG_PUB.ADD;
5939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5940: END get_matching_contact_points;

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

5933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5934: WHEN OTHERS THEN
5935: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5936: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contact_points');
5937: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5938: FND_MSG_PUB.ADD;
5939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5940: END get_matching_contact_points;
5941:

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

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

Line 6174: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_score_details');

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

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

6171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6172: WHEN OTHERS THEN
6173: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6174: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_score_details');
6175: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6176: FND_MSG_PUB.ADD;
6177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6178: END get_score_details;
6179:

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

6292: RAISE FND_API.G_EXC_ERROR;
6293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6295: WHEN OTHERS THEN
6296: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6297: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6298: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6299: FND_MSG_PUB.ADD;
6300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6295: WHEN OTHERS THEN
6296: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6297: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6298: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6299: FND_MSG_PUB.ADD;
6300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6301: END get_party_for_search;

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

6294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6295: WHEN OTHERS THEN
6296: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6297: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6298: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6299: FND_MSG_PUB.ADD;
6300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6301: END get_party_for_search;
6302:

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

6344: RAISE FND_API.G_EXC_ERROR;
6345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6347: WHEN OTHERS THEN
6348: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6349: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6350: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6351: FND_MSG_PUB.ADD;
6352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6347: WHEN OTHERS THEN
6348: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6349: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6350: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6351: FND_MSG_PUB.ADD;
6352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6353: END get_search_criteria;

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

6346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6347: WHEN OTHERS THEN
6348: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6349: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6350: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6351: FND_MSG_PUB.ADD;
6352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6353: END get_search_criteria;
6354:

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

6408: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
6409:
6410: EXCEPTION
6411: WHEN OTHERS THEN
6412: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6413: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6414: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6415: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6416: FND_MSG_PUB.ADD;

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

6409:
6410: EXCEPTION
6411: WHEN OTHERS THEN
6412: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6413: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6414: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6415: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6416: FND_MSG_PUB.ADD;
6417: RAISE FND_API.G_EXC_ERROR;

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

6410: EXCEPTION
6411: WHEN OTHERS THEN
6412: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6413: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6414: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6415: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6416: FND_MSG_PUB.ADD;
6417: RAISE FND_API.G_EXC_ERROR;
6418: END get_party_rec;

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

6411: WHEN OTHERS THEN
6412: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6413: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6414: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6415: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6416: FND_MSG_PUB.ADD;
6417: RAISE FND_API.G_EXC_ERROR;
6418: END get_party_rec;
6419:

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

6472: END LOOP;
6473:
6474: EXCEPTION
6475: WHEN OTHERS THEN
6476: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6477: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6478: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6479: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6480: FND_MSG_PUB.ADD;

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

6473:
6474: EXCEPTION
6475: WHEN OTHERS THEN
6476: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6477: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6478: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6479: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6480: FND_MSG_PUB.ADD;
6481: RAISE FND_API.G_EXC_ERROR;

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

6474: EXCEPTION
6475: WHEN OTHERS THEN
6476: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6477: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6478: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6479: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6480: FND_MSG_PUB.ADD;
6481: RAISE FND_API.G_EXC_ERROR;
6482: END get_party_site_rec;

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

6475: WHEN OTHERS THEN
6476: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6477: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6478: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6479: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6480: FND_MSG_PUB.ADD;
6481: RAISE FND_API.G_EXC_ERROR;
6482: END get_party_site_rec;
6483:

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

6530: END LOOP;
6531:
6532: EXCEPTION
6533: WHEN OTHERS THEN
6534: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6535: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6536: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6537: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6538: FND_MSG_PUB.ADD;

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

6531:
6532: EXCEPTION
6533: WHEN OTHERS THEN
6534: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6535: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6536: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6537: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6538: FND_MSG_PUB.ADD;
6539: RAISE FND_API.G_EXC_ERROR;

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

6532: EXCEPTION
6533: WHEN OTHERS THEN
6534: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6535: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6536: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6537: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6538: FND_MSG_PUB.ADD;
6539: RAISE FND_API.G_EXC_ERROR;
6540: END get_contact_rec;

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

6533: WHEN OTHERS THEN
6534: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6535: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6536: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6537: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6538: FND_MSG_PUB.ADD;
6539: RAISE FND_API.G_EXC_ERROR;
6540: END get_contact_rec;
6541:

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

6586: END LOOP;
6587:
6588: EXCEPTION
6589: WHEN OTHERS THEN
6590: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6591: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6592: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6594: FND_MSG_PUB.ADD;

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

6587:
6588: EXCEPTION
6589: WHEN OTHERS THEN
6590: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6591: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6592: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6594: FND_MSG_PUB.ADD;
6595: RAISE FND_API.G_EXC_ERROR;

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

6588: EXCEPTION
6589: WHEN OTHERS THEN
6590: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6591: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6592: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6594: FND_MSG_PUB.ADD;
6595: RAISE FND_API.G_EXC_ERROR;
6596: END get_contact_point_rec;

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

6589: WHEN OTHERS THEN
6590: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6591: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6592: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6593: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6594: FND_MSG_PUB.ADD;
6595: RAISE FND_API.G_EXC_ERROR;
6596: END get_contact_point_rec;
6597:

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

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

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

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

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

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

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

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

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

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

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

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

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

7059: END IF;
7060: END LOOP;
7061: EXCEPTION
7062: WHEN OTHERS THEN
7063: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7064: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7065: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7066: FND_MSG_PUB.ADD;
7067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7060: END LOOP;
7061: EXCEPTION
7062: WHEN OTHERS THEN
7063: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7064: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7065: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7066: FND_MSG_PUB.ADD;
7067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7068: END;

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

7061: EXCEPTION
7062: WHEN OTHERS THEN
7063: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7064: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7065: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7066: FND_MSG_PUB.ADD;
7067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7068: END;
7069:

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

7190: END IF;
7191: END LOOP;
7192: EXCEPTION
7193: WHEN OTHERS THEN
7194: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7195: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7196: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7197: FND_MSG_PUB.ADD;
7198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7191: END LOOP;
7192: EXCEPTION
7193: WHEN OTHERS THEN
7194: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7195: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7196: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7197: FND_MSG_PUB.ADD;
7198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7199: END;

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

7192: EXCEPTION
7193: WHEN OTHERS THEN
7194: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7195: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7196: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7197: FND_MSG_PUB.ADD;
7198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7199: END;
7200:

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

7217: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
7218: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
7219: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
7220: ) THEN
7221: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7222: FND_MSG_PUB.ADD;
7223: RAISE FND_API.G_EXC_ERROR;
7224: END IF;
7225: END LOOP;

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

7285: EXCEPTION
7286: WHEN FND_API.G_EXC_ERROR THEN
7287: RAISE FND_API.G_EXC_ERROR;
7288: WHEN OTHERS THEN
7289: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7290: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7291: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7292: FND_MSG_PUB.ADD;
7293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7286: WHEN FND_API.G_EXC_ERROR THEN
7287: RAISE FND_API.G_EXC_ERROR;
7288: WHEN OTHERS THEN
7289: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7290: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7291: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7292: FND_MSG_PUB.ADD;
7293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7294: END check_prim_cond;

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

7287: RAISE FND_API.G_EXC_ERROR;
7288: WHEN OTHERS THEN
7289: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7290: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7291: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7292: FND_MSG_PUB.ADD;
7293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7294: END check_prim_cond;
7295:

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

7349: EXIT WHEN x_secondary;
7350: END LOOP;
7351: EXCEPTION
7352: WHEN OTHERS THEN
7353: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7354: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7355: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7356: FND_MSG_PUB.ADD;
7357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7350: END LOOP;
7351: EXCEPTION
7352: WHEN OTHERS THEN
7353: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7354: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7355: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7356: FND_MSG_PUB.ADD;
7357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7358: END check_party_site_cond;

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

7351: EXCEPTION
7352: WHEN OTHERS THEN
7353: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7354: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7355: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7356: FND_MSG_PUB.ADD;
7357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7358: END check_party_site_cond;
7359:

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

7405: EXIT WHEN x_secondary;
7406: END LOOP;
7407: EXCEPTION
7408: WHEN OTHERS THEN
7409: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7410: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7411: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7412: FND_MSG_PUB.ADD;
7413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7406: END LOOP;
7407: EXCEPTION
7408: WHEN OTHERS THEN
7409: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7410: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7411: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7412: FND_MSG_PUB.ADD;
7413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7414: END check_contact_cond;

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

7407: EXCEPTION
7408: WHEN OTHERS THEN
7409: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7410: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7411: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7412: FND_MSG_PUB.ADD;
7413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7414: END check_contact_cond;
7415:

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

7428: x_secondary:= FALSE;
7429:
7430: FOR I IN 1..p_contact_point_list.COUNT LOOP
7431: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7432: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7433: FND_MSG_PUB.ADD;
7434: RAISE FND_API.G_EXC_ERROR;
7435: END IF;
7436: END LOOP;

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

7452: EXIT WHEN x_secondary;
7453: END LOOP;
7454: EXCEPTION
7455: WHEN OTHERS THEN
7456: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7457: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7458: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7459: FND_MSG_PUB.ADD;
7460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7453: END LOOP;
7454: EXCEPTION
7455: WHEN OTHERS THEN
7456: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7457: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7458: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7459: FND_MSG_PUB.ADD;
7460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7461: END check_contact_point_cond;

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

7454: EXCEPTION
7455: WHEN OTHERS THEN
7456: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7457: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7458: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7459: FND_MSG_PUB.ADD;
7460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7461: END check_contact_point_cond;
7462: