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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3667: RAISE FND_API.G_EXC_ERROR;
3668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3670: WHEN OTHERS THEN
3671: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3672: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_parties');
3673: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3674: FND_MSG_PUB.ADD;
3675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3670: WHEN OTHERS THEN
3671: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3672: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_parties');
3673: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3674: FND_MSG_PUB.ADD;
3675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3676: END find_parties;

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

3669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3670: WHEN OTHERS THEN
3671: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3672: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_parties');
3673: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3674: FND_MSG_PUB.ADD;
3675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3676: END find_parties;
3677:

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

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

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

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

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

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

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

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

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

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

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

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

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: ELSE

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

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

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

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

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

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

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

4536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4537: WHEN OTHERS THEN
4538: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4539: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_persons');
4540: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4541: FND_MSG_PUB.ADD;
4542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4543: END find_persons;
4544:

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

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

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

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

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

4604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4605: WHEN OTHERS THEN
4606: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4607: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_party_details');
4608: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4609: FND_MSG_PUB.ADD;
4610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4611: END find_party_details;
4612:

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

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

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

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

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

4721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4722: WHEN OTHERS THEN
4723: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4724: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_parties');
4725: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4726: FND_MSG_PUB.ADD;
4727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4728: END find_duplicate_parties;
4729:

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

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

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

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

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

4806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4807: WHEN OTHERS THEN
4808: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4809: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_party_sites');
4810: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4811: FND_MSG_PUB.ADD;
4812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4813: END find_duplicate_party_sites;
4814:

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

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

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

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

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

4895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4896: WHEN OTHERS THEN
4897: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4898: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_contacts');
4899: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4900: FND_MSG_PUB.ADD;
4901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4902: END find_duplicate_contacts;
4903:

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

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

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

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

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

4968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4969: WHEN OTHERS THEN
4970: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4971: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.find_duplicate_contact_points');
4972: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4973: FND_MSG_PUB.ADD;
4974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4975: END find_duplicate_contact_points;
4976:

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

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

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

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

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

5325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5326: WHEN OTHERS THEN
5327: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5328: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.call_api_dynamic');
5329: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5330: FND_MSG_PUB.ADD;
5331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5332: END call_api_dynamic;
5333:

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

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

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

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

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

5570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5571: WHEN OTHERS THEN
5572: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5573: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_party_sites');
5574: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5575: FND_MSG_PUB.ADD;
5576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5577: END get_matching_party_sites;
5578:

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

5797: RAISE FND_API.G_EXC_ERROR;
5798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5800: WHEN OTHERS THEN
5801: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5802: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contacts');
5803: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5804: FND_MSG_PUB.ADD;
5805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5800: WHEN OTHERS THEN
5801: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5802: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contacts');
5803: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5804: FND_MSG_PUB.ADD;
5805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5806: END get_matching_contacts;

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

5799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5800: WHEN OTHERS THEN
5801: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5802: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contacts');
5803: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5804: FND_MSG_PUB.ADD;
5805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5806: END get_matching_contacts;
5807:

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

5939: RAISE FND_API.G_EXC_ERROR;
5940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5942: WHEN OTHERS THEN
5943: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5944: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contact_points');
5945: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5946: FND_MSG_PUB.ADD;
5947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5942: WHEN OTHERS THEN
5943: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5944: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contact_points');
5945: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5946: FND_MSG_PUB.ADD;
5947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5948: END get_matching_contact_points;

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

5941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5942: WHEN OTHERS THEN
5943: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5944: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_matching_contact_points');
5945: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5946: FND_MSG_PUB.ADD;
5947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5948: END get_matching_contact_points;
5949:

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

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

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

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

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

6182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6183: WHEN OTHERS THEN
6184: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6185: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_60.get_score_details');
6186: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6187: FND_MSG_PUB.ADD;
6188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6189: END get_score_details;
6190:

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

6303: RAISE FND_API.G_EXC_ERROR;
6304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6306: WHEN OTHERS THEN
6307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6308: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6310: FND_MSG_PUB.ADD;
6311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6306: WHEN OTHERS THEN
6307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6308: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6310: FND_MSG_PUB.ADD;
6311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6312: END get_party_for_search;

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

6305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6306: WHEN OTHERS THEN
6307: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6308: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6310: FND_MSG_PUB.ADD;
6311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6312: END get_party_for_search;
6313:

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

6355: RAISE FND_API.G_EXC_ERROR;
6356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6358: WHEN OTHERS THEN
6359: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6360: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6361: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6362: FND_MSG_PUB.ADD;
6363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6358: WHEN OTHERS THEN
6359: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6360: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6361: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6362: FND_MSG_PUB.ADD;
6363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6364: END get_search_criteria;

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

6357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6358: WHEN OTHERS THEN
6359: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6360: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6361: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6362: FND_MSG_PUB.ADD;
6363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6364: END get_search_criteria;
6365:

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

6419: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
6420:
6421: EXCEPTION
6422: WHEN OTHERS THEN
6423: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6424: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6425: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6426: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6427: FND_MSG_PUB.ADD;

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

6420:
6421: EXCEPTION
6422: WHEN OTHERS THEN
6423: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6424: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6425: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6426: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6427: FND_MSG_PUB.ADD;
6428: RAISE FND_API.G_EXC_ERROR;

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

6421: EXCEPTION
6422: WHEN OTHERS THEN
6423: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6424: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6425: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6426: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6427: FND_MSG_PUB.ADD;
6428: RAISE FND_API.G_EXC_ERROR;
6429: END get_party_rec;

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

6422: WHEN OTHERS THEN
6423: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6424: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6425: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6426: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6427: FND_MSG_PUB.ADD;
6428: RAISE FND_API.G_EXC_ERROR;
6429: END get_party_rec;
6430:

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

6483: END LOOP;
6484:
6485: EXCEPTION
6486: WHEN OTHERS THEN
6487: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6488: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6489: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6490: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6491: FND_MSG_PUB.ADD;

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

6484:
6485: EXCEPTION
6486: WHEN OTHERS THEN
6487: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6488: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6489: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6490: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6491: FND_MSG_PUB.ADD;
6492: RAISE FND_API.G_EXC_ERROR;

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

6485: EXCEPTION
6486: WHEN OTHERS THEN
6487: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6488: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6489: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6490: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6491: FND_MSG_PUB.ADD;
6492: RAISE FND_API.G_EXC_ERROR;
6493: END get_party_site_rec;

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

6486: WHEN OTHERS THEN
6487: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6488: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6489: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6490: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6491: FND_MSG_PUB.ADD;
6492: RAISE FND_API.G_EXC_ERROR;
6493: END get_party_site_rec;
6494:

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

6541: END LOOP;
6542:
6543: EXCEPTION
6544: WHEN OTHERS THEN
6545: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6546: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6547: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6549: FND_MSG_PUB.ADD;

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

6542:
6543: EXCEPTION
6544: WHEN OTHERS THEN
6545: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6546: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6547: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6549: FND_MSG_PUB.ADD;
6550: RAISE FND_API.G_EXC_ERROR;

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

6543: EXCEPTION
6544: WHEN OTHERS THEN
6545: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6546: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6547: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6549: FND_MSG_PUB.ADD;
6550: RAISE FND_API.G_EXC_ERROR;
6551: END get_contact_rec;

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

6544: WHEN OTHERS THEN
6545: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6546: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6547: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6549: FND_MSG_PUB.ADD;
6550: RAISE FND_API.G_EXC_ERROR;
6551: END get_contact_rec;
6552:

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

6597: END LOOP;
6598:
6599: EXCEPTION
6600: WHEN OTHERS THEN
6601: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6602: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6603: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6604: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6605: FND_MSG_PUB.ADD;

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

6598:
6599: EXCEPTION
6600: WHEN OTHERS THEN
6601: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6602: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6603: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6604: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6605: FND_MSG_PUB.ADD;
6606: RAISE FND_API.G_EXC_ERROR;

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

6599: EXCEPTION
6600: WHEN OTHERS THEN
6601: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6602: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6603: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6604: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6605: FND_MSG_PUB.ADD;
6606: RAISE FND_API.G_EXC_ERROR;
6607: END get_contact_point_rec;

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

6600: WHEN OTHERS THEN
6601: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6602: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6603: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6604: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6605: FND_MSG_PUB.ADD;
6606: RAISE FND_API.G_EXC_ERROR;
6607: END get_contact_point_rec;
6608:

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

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

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

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

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

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

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

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

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

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

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

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

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

7070: END IF;
7071: END LOOP;
7072: EXCEPTION
7073: WHEN OTHERS THEN
7074: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7075: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7076: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7077: FND_MSG_PUB.ADD;
7078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7071: END LOOP;
7072: EXCEPTION
7073: WHEN OTHERS THEN
7074: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7075: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7076: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7077: FND_MSG_PUB.ADD;
7078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7079: END;

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

7072: EXCEPTION
7073: WHEN OTHERS THEN
7074: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7075: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7076: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7077: FND_MSG_PUB.ADD;
7078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7079: END;
7080:

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

7201: END IF;
7202: END LOOP;
7203: EXCEPTION
7204: WHEN OTHERS THEN
7205: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7206: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7208: FND_MSG_PUB.ADD;
7209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7202: END LOOP;
7203: EXCEPTION
7204: WHEN OTHERS THEN
7205: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7206: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7208: FND_MSG_PUB.ADD;
7209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7210: END;

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

7203: EXCEPTION
7204: WHEN OTHERS THEN
7205: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7206: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7208: FND_MSG_PUB.ADD;
7209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7210: END;
7211:

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

7228: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
7229: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
7230: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
7231: ) THEN
7232: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7233: FND_MSG_PUB.ADD;
7234: RAISE FND_API.G_EXC_ERROR;
7235: END IF;
7236: END LOOP;

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

7296: EXCEPTION
7297: WHEN FND_API.G_EXC_ERROR THEN
7298: RAISE FND_API.G_EXC_ERROR;
7299: WHEN OTHERS THEN
7300: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7301: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7302: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7303: FND_MSG_PUB.ADD;
7304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7297: WHEN FND_API.G_EXC_ERROR THEN
7298: RAISE FND_API.G_EXC_ERROR;
7299: WHEN OTHERS THEN
7300: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7301: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7302: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7303: FND_MSG_PUB.ADD;
7304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7305: END check_prim_cond;

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

7298: RAISE FND_API.G_EXC_ERROR;
7299: WHEN OTHERS THEN
7300: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7301: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7302: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7303: FND_MSG_PUB.ADD;
7304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7305: END check_prim_cond;
7306:

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

7360: EXIT WHEN x_secondary;
7361: END LOOP;
7362: EXCEPTION
7363: WHEN OTHERS THEN
7364: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7365: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7366: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7367: FND_MSG_PUB.ADD;
7368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7361: END LOOP;
7362: EXCEPTION
7363: WHEN OTHERS THEN
7364: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7365: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7366: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7367: FND_MSG_PUB.ADD;
7368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7369: END check_party_site_cond;

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

7362: EXCEPTION
7363: WHEN OTHERS THEN
7364: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7365: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7366: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7367: FND_MSG_PUB.ADD;
7368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7369: END check_party_site_cond;
7370:

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

7416: EXIT WHEN x_secondary;
7417: END LOOP;
7418: EXCEPTION
7419: WHEN OTHERS THEN
7420: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7421: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7422: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7423: FND_MSG_PUB.ADD;
7424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7417: END LOOP;
7418: EXCEPTION
7419: WHEN OTHERS THEN
7420: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7421: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7422: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7423: FND_MSG_PUB.ADD;
7424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7425: END check_contact_cond;

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

7418: EXCEPTION
7419: WHEN OTHERS THEN
7420: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7421: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7422: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7423: FND_MSG_PUB.ADD;
7424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7425: END check_contact_cond;
7426:

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

7439: x_secondary:= FALSE;
7440:
7441: FOR I IN 1..p_contact_point_list.COUNT LOOP
7442: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7443: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7444: FND_MSG_PUB.ADD;
7445: RAISE FND_API.G_EXC_ERROR;
7446: END IF;
7447: END LOOP;

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

7463: EXIT WHEN x_secondary;
7464: END LOOP;
7465: EXCEPTION
7466: WHEN OTHERS THEN
7467: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7468: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7469: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7470: FND_MSG_PUB.ADD;
7471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7464: END LOOP;
7465: EXCEPTION
7466: WHEN OTHERS THEN
7467: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7468: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7469: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7470: FND_MSG_PUB.ADD;
7471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7472: END check_contact_point_cond;

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

7465: EXCEPTION
7466: WHEN OTHERS THEN
7467: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7468: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7469: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7470: FND_MSG_PUB.ADD;
7471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7472: END check_contact_point_cond;
7473: