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

1136: BEGIN
1137: NULL ;
1138: EXCEPTION
1139: WHEN OTHERS THEN
1140: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1141: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1142: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1143: FND_MSG_PUB.ADD;
1144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1137: NULL ;
1138: EXCEPTION
1139: WHEN OTHERS THEN
1140: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1141: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1142: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1143: FND_MSG_PUB.ADD;
1144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1145: END;

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

1138: EXCEPTION
1139: WHEN OTHERS THEN
1140: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1141: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_COND_REC');
1142: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1143: FND_MSG_PUB.ADD;
1144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1145: END;
1146:

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

1161: HZ_WORD_CONDITIONS_PKG.set_gbl_condition_rec (36,p_search_list(1).COUNTRY);
1162: END IF ;
1163: EXCEPTION
1164: WHEN OTHERS THEN
1165: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1166: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1167: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1168: FND_MSG_PUB.ADD;
1169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1162: END IF ;
1163: EXCEPTION
1164: WHEN OTHERS THEN
1165: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1166: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1167: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1168: FND_MSG_PUB.ADD;
1169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1170: END;

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

1163: EXCEPTION
1164: WHEN OTHERS THEN
1165: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1166: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_PARTY_SITES_COND_REC');
1167: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1168: FND_MSG_PUB.ADD;
1169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1170: END;
1171:

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

1181: BEGIN
1182: NULL ;
1183: EXCEPTION
1184: WHEN OTHERS THEN
1185: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1186: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1187: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1188: FND_MSG_PUB.ADD;
1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1182: NULL ;
1183: EXCEPTION
1184: WHEN OTHERS THEN
1185: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1186: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1187: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1188: FND_MSG_PUB.ADD;
1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1190: END;

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

1183: EXCEPTION
1184: WHEN OTHERS THEN
1185: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1186: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACTS_COND_REC');
1187: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1188: FND_MSG_PUB.ADD;
1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1190: END;
1191:

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

1201: BEGIN
1202: NULL ;
1203: EXCEPTION
1204: WHEN OTHERS THEN
1205: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1206: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1208: FND_MSG_PUB.ADD;
1209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1202: NULL ;
1203: EXCEPTION
1204: WHEN OTHERS THEN
1205: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1206: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1208: FND_MSG_PUB.ADD;
1209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1210: END;

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

1203: EXCEPTION
1204: WHEN OTHERS THEN
1205: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
1206: FND_MESSAGE.SET_TOKEN('PROC' , 'POP_CONTACT_POINTS_COND_REC');
1207: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1208: FND_MSG_PUB.ADD;
1209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1210: END;
1211:

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

1270: IF NOT check_prim_cond (p_party_search_rec,
1271: p_party_site_list,
1272: p_contact_list,
1273: p_contact_point_list) THEN
1274: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_PRIMARY_COND');
1275: FND_MSG_PUB.ADD;
1276: RAISE FND_API.G_EXC_ERROR;
1277: END IF;
1278: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1574: ELSE
1575: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1576: END IF;
1577: IF lengthb(l_party_contains_str) > 4000 THEN
1578: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1579: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1580: FND_MSG_PUB.ADD;
1581: RAISE FND_API.G_EXC_ERROR;
1582: END IF;

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

1575: HZ_DQM_SEARCH_UTIL.add_attribute(l_prim_temp, p_match_str, l_party_contains_str);
1576: END IF;
1577: IF lengthb(l_party_contains_str) > 4000 THEN
1578: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1579: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY');
1580: FND_MSG_PUB.ADD;
1581: RAISE FND_API.G_EXC_ERROR;
1582: END IF;
1583: IF (p_match_str = ' AND ' OR p_party_max_score

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

1673: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1674: END LOOP;
1675: -- Add the search criteria to query string
1676: IF lengthb(l_contains_str) > 4000 THEN
1677: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1678: FND_MESSAGE.SET_TOKEN('ENTITY','PARTY_SITES');
1679: FND_MSG_PUB.ADD;
1680: RAISE FND_API.G_EXC_ERROR;
1681: END IF;

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

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

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

1719: HZ_DQM_SEARCH_UTIL.add_search_record(l_den_contains_str_temp, null, l_den_contains_str);
1720: END LOOP;
1721: -- Add the search criteria to query string
1722: IF lengthb(l_contains_str) > 4000 THEN
1723: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1724: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1725: FND_MSG_PUB.ADD;
1726: RAISE FND_API.G_EXC_ERROR;
1727: END IF;

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

1720: END LOOP;
1721: -- Add the search criteria to query string
1722: IF lengthb(l_contains_str) > 4000 THEN
1723: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1724: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACTS');
1725: FND_MSG_PUB.ADD;
1726: RAISE FND_API.G_EXC_ERROR;
1727: END IF;
1728: x_denorm_str := l_den_contains_str;

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

1800: END IF;
1801: END LOOP;
1802: -- Add the search criteria to query string
1803: IF lengthb(l_contains_str) > 4000 THEN
1804: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1805: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1806: FND_MSG_PUB.ADD;
1807: RAISE FND_API.G_EXC_ERROR;
1808: END IF;

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

1801: END LOOP;
1802: -- Add the search criteria to query string
1803: IF lengthb(l_contains_str) > 4000 THEN
1804: FND_MESSAGE.SET_NAME('AR', 'HZ_SEARCH_CRIT_LARGE_ERROR');
1805: FND_MESSAGE.SET_TOKEN('ENTITY','CONTACT_POINTS');
1806: FND_MSG_PUB.ADD;
1807: RAISE FND_API.G_EXC_ERROR;
1808: END IF;
1809: x_denorm_str := l_den_contains_str;

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

2087: END IF;
2088: exception
2089: when others then
2090: if (instrb(SQLERRM,'DRG-51030')>0) then
2091: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2092: FND_MSG_PUB.ADD;
2093: RAISE FND_API.G_EXC_ERROR;
2094: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2095: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2091: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2092: FND_MSG_PUB.ADD;
2093: RAISE FND_API.G_EXC_ERROR;
2094: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2095: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2096: FND_MSG_PUB.ADD;
2097: RAISE FND_API.G_EXC_ERROR;
2098: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2099: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2095: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2096: FND_MSG_PUB.ADD;
2097: RAISE FND_API.G_EXC_ERROR;
2098: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2099: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2100: FND_MSG_PUB.ADD;
2101: RAISE FND_API.G_EXC_ERROR;
2102: else
2103: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2099: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2100: FND_MSG_PUB.ADD;
2101: RAISE FND_API.G_EXC_ERROR;
2102: else
2103: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2104: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2105: FND_MSG_PUB.ADD;
2106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2107: end if;

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

2100: FND_MSG_PUB.ADD;
2101: RAISE FND_API.G_EXC_ERROR;
2102: else
2103: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2104: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2105: FND_MSG_PUB.ADD;
2106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2107: end if;
2108: 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 2483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');

2479: output_long_strings('Restrict Sql = '||p_restrict_sql);
2480: exception
2481: when others then
2482: if (instrb(SQLERRM,'DRG-51030')>0) then
2483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2484: FND_MSG_PUB.ADD;
2485: RAISE FND_API.G_EXC_ERROR;
2486: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2483: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2484: FND_MSG_PUB.ADD;
2485: RAISE FND_API.G_EXC_ERROR;
2486: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2488: FND_MSG_PUB.ADD;
2489: RAISE FND_API.G_EXC_ERROR;
2490: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2491: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2487: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2488: FND_MSG_PUB.ADD;
2489: RAISE FND_API.G_EXC_ERROR;
2490: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2491: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2492: FND_MSG_PUB.ADD;
2493: RAISE FND_API.G_EXC_ERROR;
2494: else
2495: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2491: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2492: FND_MSG_PUB.ADD;
2493: RAISE FND_API.G_EXC_ERROR;
2494: else
2495: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2496: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2497: FND_MSG_PUB.ADD;
2498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2499: end if;

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

2492: FND_MSG_PUB.ADD;
2493: RAISE FND_API.G_EXC_ERROR;
2494: else
2495: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2496: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2497: FND_MSG_PUB.ADD;
2498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2499: end if;
2500: END;

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

2752: output_long_strings('Restrict Sql = '||p_restrict_sql);
2753: exception
2754: when others then
2755: if (instrb(SQLERRM,'DRG-51030')>0) then
2756: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2757: FND_MSG_PUB.ADD;
2758: RAISE FND_API.G_EXC_ERROR;
2759: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2760: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2756: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2757: FND_MSG_PUB.ADD;
2758: RAISE FND_API.G_EXC_ERROR;
2759: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2760: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2761: FND_MSG_PUB.ADD;
2762: RAISE FND_API.G_EXC_ERROR;
2763: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2764: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

2760: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2761: FND_MSG_PUB.ADD;
2762: RAISE FND_API.G_EXC_ERROR;
2763: elsif (instrb(SQLERRM,'ORA-20000')>0) then
2764: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2765: FND_MSG_PUB.ADD;
2766: RAISE FND_API.G_EXC_ERROR;
2767: else
2768: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

2764: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2765: FND_MSG_PUB.ADD;
2766: RAISE FND_API.G_EXC_ERROR;
2767: else
2768: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2769: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2770: FND_MSG_PUB.ADD;
2771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2772: end if;

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

2765: FND_MSG_PUB.ADD;
2766: RAISE FND_API.G_EXC_ERROR;
2767: else
2768: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2769: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2770: FND_MSG_PUB.ADD;
2771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2772: end if;
2773: END;

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

3030: IF p_index>1 THEN
3031: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3032: 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);
3033: END IF;
3034: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3035: FND_MSG_PUB.ADD;
3036: RAISE FND_API.G_EXC_ERROR;
3037: ELSE
3038: push_eval;

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

3078: IF p_index>1 THEN
3079: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3080: 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);
3081: END IF;
3082: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3083: FND_MSG_PUB.ADD;
3084: RAISE FND_API.G_EXC_ERROR;
3085: ELSE
3086: push_eval;

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

3151: IF p_index>1 THEN
3152: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3153: 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);
3154: END IF;
3155: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3156: FND_MSG_PUB.ADD;
3157: RAISE FND_API.G_EXC_ERROR;
3158: ELSE
3159: push_eval;

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

3263: IF p_index>1 THEN
3264: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3265: 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);
3266: END IF;
3267: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3268: FND_MSG_PUB.ADD;
3269: RAISE FND_API.G_EXC_ERROR;
3270: ELSE
3271: push_eval;

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

3374: IF p_index>1 THEN
3375: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3376: 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);
3377: END IF;
3378: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3379: FND_MSG_PUB.ADD;
3380: RAISE FND_API.G_EXC_ERROR;
3381: ELSE
3382: push_eval;

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

3599: ELSE
3600: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3601: 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);
3602: END IF;
3603: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3604: FND_MSG_PUB.ADD;
3605: RAISE FND_API.G_EXC_ERROR;
3606: END IF;
3607: ELSE

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

3607: ELSE
3608: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3609: 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);
3610: END IF;
3611: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
3612: FND_MSG_PUB.ADD;
3613: RAISE FND_API.G_EXC_ERROR;
3614: END IF;
3615: END IF;

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

3813: RAISE FND_API.G_EXC_ERROR;
3814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3816: WHEN OTHERS THEN
3817: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3818: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_parties');
3819: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3820: FND_MSG_PUB.ADD;
3821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3818: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_parties');

3814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3816: WHEN OTHERS THEN
3817: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3818: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_parties');
3819: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3820: FND_MSG_PUB.ADD;
3821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3822: END find_parties;

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

3815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3816: WHEN OTHERS THEN
3817: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
3818: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_parties');
3819: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
3820: FND_MSG_PUB.ADD;
3821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3822: END find_parties;
3823:

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

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

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

4068: IF p_index>1 THEN
4069: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4070: 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);
4071: END IF;
4072: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4073: FND_MSG_PUB.ADD;
4074: RAISE FND_API.G_EXC_ERROR;
4075: ELSE
4076: push_eval;

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

4104: and d.search_context_id = p_search_ctx_id);
4105: exception
4106: when others then
4107: if (instrb(SQLERRM,'DRG-51030')>0) then
4108: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
4109: FND_MSG_PUB.ADD;
4110: RAISE FND_API.G_EXC_ERROR;
4111: elsif (instrb(SQLERRM,'DRG-50943')>0) then
4112: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');

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

4108: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
4109: FND_MSG_PUB.ADD;
4110: RAISE FND_API.G_EXC_ERROR;
4111: elsif (instrb(SQLERRM,'DRG-50943')>0) then
4112: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
4113: FND_MSG_PUB.ADD;
4114: RAISE FND_API.G_EXC_ERROR;
4115: else
4116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4180: IF p_index>1 THEN
4181: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4182: 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);
4183: END IF;
4184: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4185: FND_MSG_PUB.ADD;
4186: RAISE FND_API.G_EXC_ERROR;
4187: ELSE
4188: push_eval;

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

4439: IF p_index>1 THEN
4440: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4441: 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);
4442: END IF;
4443: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4444: FND_MSG_PUB.ADD;
4445: RAISE FND_API.G_EXC_ERROR;
4446: ELSE
4447: push_eval;

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

4552: ELSE
4553: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4554: 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);
4555: END IF;
4556: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4557: FND_MSG_PUB.ADD;
4558: RAISE FND_API.G_EXC_ERROR;
4559: END IF;
4560: ELSE

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

4560: ELSE
4561: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4562: 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);
4563: END IF;
4564: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_THRESH_EXCEEDED');
4565: FND_MSG_PUB.ADD;
4566: RAISE FND_API.G_EXC_ERROR;
4567: END IF;
4568: END IF;

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

4681: RAISE FND_API.G_EXC_ERROR;
4682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4684: WHEN OTHERS THEN
4685: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4686: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_persons');
4687: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4688: FND_MSG_PUB.ADD;
4689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4686: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_persons');

4682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4684: WHEN OTHERS THEN
4685: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4686: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_persons');
4687: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4688: FND_MSG_PUB.ADD;
4689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4690: END find_persons;

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

4683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4684: WHEN OTHERS THEN
4685: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4686: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_persons');
4687: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4688: FND_MSG_PUB.ADD;
4689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4690: END find_persons;
4691:

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

4749: RAISE FND_API.G_EXC_ERROR;
4750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4752: WHEN OTHERS THEN
4753: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4754: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_party_details');
4755: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4756: FND_MSG_PUB.ADD;
4757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4754: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_party_details');

4750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4752: WHEN OTHERS THEN
4753: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4754: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_party_details');
4755: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4756: FND_MSG_PUB.ADD;
4757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4758: END find_party_details;

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

4751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4752: WHEN OTHERS THEN
4753: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4754: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_party_details');
4755: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4756: FND_MSG_PUB.ADD;
4757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4758: END find_party_details;
4759:

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

4866: RAISE FND_API.G_EXC_ERROR;
4867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4869: WHEN OTHERS THEN
4870: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4871: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_parties');
4872: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4873: FND_MSG_PUB.ADD;
4874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4871: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_parties');

4867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4869: WHEN OTHERS THEN
4870: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4871: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_parties');
4872: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4873: FND_MSG_PUB.ADD;
4874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4875: END find_duplicate_parties;

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

4868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4869: WHEN OTHERS THEN
4870: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4871: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_parties');
4872: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4873: FND_MSG_PUB.ADD;
4874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4875: END find_duplicate_parties;
4876:

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

4951: RAISE FND_API.G_EXC_ERROR;
4952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4954: WHEN OTHERS THEN
4955: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4956: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_party_sites');
4957: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4958: FND_MSG_PUB.ADD;
4959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4956: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_party_sites');

4952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4954: WHEN OTHERS THEN
4955: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4956: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_party_sites');
4957: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4958: FND_MSG_PUB.ADD;
4959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4960: END find_duplicate_party_sites;

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

4953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4954: WHEN OTHERS THEN
4955: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4956: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_party_sites');
4957: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4958: FND_MSG_PUB.ADD;
4959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4960: END find_duplicate_party_sites;
4961:

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

5040: RAISE FND_API.G_EXC_ERROR;
5041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5043: WHEN OTHERS THEN
5044: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5045: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_contacts');
5046: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5047: FND_MSG_PUB.ADD;
5048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5045: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_contacts');

5041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5043: WHEN OTHERS THEN
5044: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5045: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_contacts');
5046: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5047: FND_MSG_PUB.ADD;
5048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5049: END find_duplicate_contacts;

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

5042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5043: WHEN OTHERS THEN
5044: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5045: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_contacts');
5046: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5047: FND_MSG_PUB.ADD;
5048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5049: END find_duplicate_contacts;
5050:

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

5113: RAISE FND_API.G_EXC_ERROR;
5114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5116: WHEN OTHERS THEN
5117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5118: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_contact_points');
5119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5120: FND_MSG_PUB.ADD;
5121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5118: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_contact_points');

5114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5116: WHEN OTHERS THEN
5117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5118: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_contact_points');
5119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5120: FND_MSG_PUB.ADD;
5121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5122: END find_duplicate_contact_points;

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

5115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5116: WHEN OTHERS THEN
5117: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5118: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_contact_points');
5119: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5120: FND_MSG_PUB.ADD;
5121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5122: END find_duplicate_contact_points;
5123:

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

5484: RAISE FND_API.G_EXC_ERROR;
5485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5487: WHEN OTHERS THEN
5488: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5489: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.call_api_dynamic');
5490: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5491: FND_MSG_PUB.ADD;
5492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5489: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.call_api_dynamic');

5485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5487: WHEN OTHERS THEN
5488: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5489: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.call_api_dynamic');
5490: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5491: FND_MSG_PUB.ADD;
5492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5493: END call_api_dynamic;

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

5486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5487: WHEN OTHERS THEN
5488: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5489: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.call_api_dynamic');
5490: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5491: FND_MSG_PUB.ADD;
5492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5493: END call_api_dynamic;
5494:

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

5727: RAISE FND_API.G_EXC_ERROR;
5728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5730: WHEN OTHERS THEN
5731: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5732: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_party_sites');
5733: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5734: FND_MSG_PUB.ADD;
5735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5732: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_party_sites');

5728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5730: WHEN OTHERS THEN
5731: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5732: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_party_sites');
5733: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5734: FND_MSG_PUB.ADD;
5735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5736: END get_matching_party_sites;

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

5729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5730: WHEN OTHERS THEN
5731: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5732: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_party_sites');
5733: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5734: FND_MSG_PUB.ADD;
5735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5736: END get_matching_party_sites;
5737:

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

5957: RAISE FND_API.G_EXC_ERROR;
5958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5960: WHEN OTHERS THEN
5961: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5962: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_contacts');
5963: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5964: FND_MSG_PUB.ADD;
5965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5962: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_contacts');

5958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5960: WHEN OTHERS THEN
5961: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5962: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_contacts');
5963: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5964: FND_MSG_PUB.ADD;
5965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5966: END get_matching_contacts;

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

5959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5960: WHEN OTHERS THEN
5961: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5962: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_contacts');
5963: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5964: FND_MSG_PUB.ADD;
5965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5966: END get_matching_contacts;
5967:

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

6099: RAISE FND_API.G_EXC_ERROR;
6100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6102: WHEN OTHERS THEN
6103: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6104: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_contact_points');
6105: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6106: FND_MSG_PUB.ADD;
6107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6104: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_contact_points');

6100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6102: WHEN OTHERS THEN
6103: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6104: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_contact_points');
6105: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6106: FND_MSG_PUB.ADD;
6107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6108: END get_matching_contact_points;

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

6101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6102: WHEN OTHERS THEN
6103: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6104: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_contact_points');
6105: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6106: FND_MSG_PUB.ADD;
6107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6108: END get_matching_contact_points;
6109:

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

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

Line 6350: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_score_details');

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

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

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

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

6468: RAISE FND_API.G_EXC_ERROR;
6469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6471: WHEN OTHERS THEN
6472: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6473: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6474: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6475: FND_MSG_PUB.ADD;
6476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6471: WHEN OTHERS THEN
6472: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6473: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6474: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6475: FND_MSG_PUB.ADD;
6476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6477: END get_party_for_search;

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

6470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6471: WHEN OTHERS THEN
6472: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6473: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6474: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6475: FND_MSG_PUB.ADD;
6476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6477: END get_party_for_search;
6478:

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

6520: RAISE FND_API.G_EXC_ERROR;
6521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6523: WHEN OTHERS THEN
6524: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6525: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6526: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6527: FND_MSG_PUB.ADD;
6528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6523: WHEN OTHERS THEN
6524: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6525: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6526: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6527: FND_MSG_PUB.ADD;
6528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6529: END get_search_criteria;

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

6522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6523: WHEN OTHERS THEN
6524: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6525: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6526: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6527: FND_MSG_PUB.ADD;
6528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6529: END get_search_criteria;
6530:

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

6594: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
6595:
6596: EXCEPTION
6597: WHEN OTHERS THEN
6598: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6599: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6600: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6601: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6602: FND_MSG_PUB.ADD;

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

6595:
6596: EXCEPTION
6597: WHEN OTHERS THEN
6598: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6599: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6600: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6601: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6602: FND_MSG_PUB.ADD;
6603: RAISE FND_API.G_EXC_ERROR;

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

6596: EXCEPTION
6597: WHEN OTHERS THEN
6598: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6599: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6600: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6601: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6602: FND_MSG_PUB.ADD;
6603: RAISE FND_API.G_EXC_ERROR;
6604: END get_party_rec;

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

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

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

6656: END LOOP;
6657:
6658: EXCEPTION
6659: WHEN OTHERS THEN
6660: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6661: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6662: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6663: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6664: FND_MSG_PUB.ADD;

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

6657:
6658: EXCEPTION
6659: WHEN OTHERS THEN
6660: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6661: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6662: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6663: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6664: FND_MSG_PUB.ADD;
6665: RAISE FND_API.G_EXC_ERROR;

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

6658: EXCEPTION
6659: WHEN OTHERS THEN
6660: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6661: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6662: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6663: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6664: FND_MSG_PUB.ADD;
6665: RAISE FND_API.G_EXC_ERROR;
6666: END get_party_site_rec;

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

6659: WHEN OTHERS THEN
6660: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6661: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6662: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6663: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6664: FND_MSG_PUB.ADD;
6665: RAISE FND_API.G_EXC_ERROR;
6666: END get_party_site_rec;
6667:

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

6714: END LOOP;
6715:
6716: EXCEPTION
6717: WHEN OTHERS THEN
6718: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6719: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6720: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6722: FND_MSG_PUB.ADD;

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

6715:
6716: EXCEPTION
6717: WHEN OTHERS THEN
6718: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6719: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6720: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6722: FND_MSG_PUB.ADD;
6723: RAISE FND_API.G_EXC_ERROR;

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

6716: EXCEPTION
6717: WHEN OTHERS THEN
6718: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6719: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6720: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6722: FND_MSG_PUB.ADD;
6723: RAISE FND_API.G_EXC_ERROR;
6724: END get_contact_rec;

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

6717: WHEN OTHERS THEN
6718: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6719: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6720: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6721: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6722: FND_MSG_PUB.ADD;
6723: RAISE FND_API.G_EXC_ERROR;
6724: END get_contact_rec;
6725:

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

6770: END LOOP;
6771:
6772: EXCEPTION
6773: WHEN OTHERS THEN
6774: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6775: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6776: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6777: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6778: FND_MSG_PUB.ADD;

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

6771:
6772: EXCEPTION
6773: WHEN OTHERS THEN
6774: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6775: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6776: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6777: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6778: FND_MSG_PUB.ADD;
6779: RAISE FND_API.G_EXC_ERROR;

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

6772: EXCEPTION
6773: WHEN OTHERS THEN
6774: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6775: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6776: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6777: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6778: FND_MSG_PUB.ADD;
6779: RAISE FND_API.G_EXC_ERROR;
6780: END get_contact_point_rec;

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

6773: WHEN OTHERS THEN
6774: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6775: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6776: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6777: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6778: FND_MSG_PUB.ADD;
6779: RAISE FND_API.G_EXC_ERROR;
6780: END get_contact_point_rec;
6781:

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

6984: x_stage_rec.TX8 := HZ_TRANS_PKG.WRNAMES_EXACT(l_party_name,null,'PARTY_NAME','PARTY','SEARCH');
6985: END IF;
6986: EXCEPTION
6987: WHEN OTHERS THEN
6988: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6989: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6990: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6991: FND_MSG_PUB.ADD;
6992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6985: END IF;
6986: EXCEPTION
6987: WHEN OTHERS THEN
6988: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6989: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6990: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6991: FND_MSG_PUB.ADD;
6992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6993: END;

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

6986: EXCEPTION
6987: WHEN OTHERS THEN
6988: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6989: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6990: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6991: FND_MSG_PUB.ADD;
6992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6993: END;
6994:

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

7196: END IF;
7197: END LOOP;
7198: EXCEPTION
7199: WHEN OTHERS THEN
7200: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7201: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7203: FND_MSG_PUB.ADD;
7204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7197: END LOOP;
7198: EXCEPTION
7199: WHEN OTHERS THEN
7200: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7201: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7203: FND_MSG_PUB.ADD;
7204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7205: END;

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

7198: EXCEPTION
7199: WHEN OTHERS THEN
7200: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7201: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_SITE_REC');
7202: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7203: FND_MSG_PUB.ADD;
7204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7205: END;
7206:

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

7312: END IF;
7313: END LOOP;
7314: EXCEPTION
7315: WHEN OTHERS THEN
7316: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7317: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7318: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7319: FND_MSG_PUB.ADD;
7320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7313: END LOOP;
7314: EXCEPTION
7315: WHEN OTHERS THEN
7316: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7317: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7318: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7319: FND_MSG_PUB.ADD;
7320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7321: END;

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

7314: EXCEPTION
7315: WHEN OTHERS THEN
7316: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7317: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7318: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7319: FND_MSG_PUB.ADD;
7320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7321: END;
7322:

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

7443: END IF;
7444: END LOOP;
7445: EXCEPTION
7446: WHEN OTHERS THEN
7447: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7448: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7449: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7450: FND_MSG_PUB.ADD;
7451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7444: END LOOP;
7445: EXCEPTION
7446: WHEN OTHERS THEN
7447: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7448: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7449: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7450: FND_MSG_PUB.ADD;
7451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7452: END;

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

7445: EXCEPTION
7446: WHEN OTHERS THEN
7447: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7448: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7449: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7450: FND_MSG_PUB.ADD;
7451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7452: END;
7453:

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

7470: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
7471: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
7472: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
7473: ) THEN
7474: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7475: FND_MSG_PUB.ADD;
7476: RAISE FND_API.G_EXC_ERROR;
7477: END IF;
7478: END LOOP;

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

7539: EXCEPTION
7540: WHEN FND_API.G_EXC_ERROR THEN
7541: RAISE FND_API.G_EXC_ERROR;
7542: WHEN OTHERS THEN
7543: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7544: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7545: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7546: FND_MSG_PUB.ADD;
7547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7540: WHEN FND_API.G_EXC_ERROR THEN
7541: RAISE FND_API.G_EXC_ERROR;
7542: WHEN OTHERS THEN
7543: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7544: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7545: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7546: FND_MSG_PUB.ADD;
7547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7548: END check_prim_cond;

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

7541: RAISE FND_API.G_EXC_ERROR;
7542: WHEN OTHERS THEN
7543: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7544: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7545: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7546: FND_MSG_PUB.ADD;
7547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7548: END check_prim_cond;
7549:

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

7601: EXIT WHEN x_secondary;
7602: END LOOP;
7603: EXCEPTION
7604: WHEN OTHERS THEN
7605: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7606: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7607: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7608: FND_MSG_PUB.ADD;
7609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7602: END LOOP;
7603: EXCEPTION
7604: WHEN OTHERS THEN
7605: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7606: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7607: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7608: FND_MSG_PUB.ADD;
7609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7610: END check_party_site_cond;

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

7603: EXCEPTION
7604: WHEN OTHERS THEN
7605: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7606: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7607: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7608: FND_MSG_PUB.ADD;
7609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7610: END check_party_site_cond;
7611:

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

7657: EXIT WHEN x_secondary;
7658: END LOOP;
7659: EXCEPTION
7660: WHEN OTHERS THEN
7661: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7662: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7663: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7664: FND_MSG_PUB.ADD;
7665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7658: END LOOP;
7659: EXCEPTION
7660: WHEN OTHERS THEN
7661: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7662: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7663: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7664: FND_MSG_PUB.ADD;
7665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7666: END check_contact_cond;

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

7659: EXCEPTION
7660: WHEN OTHERS THEN
7661: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7662: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7663: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7664: FND_MSG_PUB.ADD;
7665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7666: END check_contact_cond;
7667:

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

7680: x_secondary:= FALSE;
7681:
7682: FOR I IN 1..p_contact_point_list.COUNT LOOP
7683: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7684: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7685: FND_MSG_PUB.ADD;
7686: RAISE FND_API.G_EXC_ERROR;
7687: END IF;
7688: END LOOP;

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

7704: EXIT WHEN x_secondary;
7705: END LOOP;
7706: EXCEPTION
7707: WHEN OTHERS THEN
7708: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7709: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7710: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7711: FND_MSG_PUB.ADD;
7712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7705: END LOOP;
7706: EXCEPTION
7707: WHEN OTHERS THEN
7708: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7709: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7710: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7711: FND_MSG_PUB.ADD;
7712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7713: END check_contact_point_cond;

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

7706: EXCEPTION
7707: WHEN OTHERS THEN
7708: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7709: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7710: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7711: FND_MSG_PUB.ADD;
7712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7713: END check_contact_point_cond;
7714: