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

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

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

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

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

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

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

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

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

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

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

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

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

2334: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_WILDCARD_ERR');
2335: FND_MSG_PUB.ADD;
2336: RAISE FND_API.G_EXC_ERROR;
2337: elsif (instrb(SQLERRM,'DRG-50943')>0) then
2338: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_SEARCH_ERROR');
2339: FND_MSG_PUB.ADD;
2340: RAISE FND_API.G_EXC_ERROR;
2341: elsif (instrb(SQLERRM,'ORA-20000')>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_SEARCH_ERROR');
2339: FND_MSG_PUB.ADD;
2340: RAISE FND_API.G_EXC_ERROR;
2341: elsif (instrb(SQLERRM,'ORA-20000')>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: else
2346: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4677: RAISE FND_API.G_EXC_ERROR;
4678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4680: WHEN OTHERS THEN
4681: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4682: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_persons');
4683: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4684: FND_MSG_PUB.ADD;
4685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4680: WHEN OTHERS THEN
4681: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4682: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_persons');
4683: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4684: FND_MSG_PUB.ADD;
4685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4686: END find_persons;

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

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

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

4745: RAISE FND_API.G_EXC_ERROR;
4746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4748: WHEN OTHERS THEN
4749: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4750: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_party_details');
4751: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4752: FND_MSG_PUB.ADD;
4753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4748: WHEN OTHERS THEN
4749: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4750: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_party_details');
4751: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4752: FND_MSG_PUB.ADD;
4753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4754: END find_party_details;

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

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

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

4862: RAISE FND_API.G_EXC_ERROR;
4863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4865: WHEN OTHERS THEN
4866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_parties');
4868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4869: FND_MSG_PUB.ADD;
4870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4865: WHEN OTHERS THEN
4866: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4867: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_parties');
4868: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4869: FND_MSG_PUB.ADD;
4870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4871: END find_duplicate_parties;

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

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

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

4947: RAISE FND_API.G_EXC_ERROR;
4948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4950: WHEN OTHERS THEN
4951: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4952: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_party_sites');
4953: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4954: FND_MSG_PUB.ADD;
4955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4950: WHEN OTHERS THEN
4951: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
4952: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_party_sites');
4953: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
4954: FND_MSG_PUB.ADD;
4955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4956: END find_duplicate_party_sites;

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

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

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

5036: RAISE FND_API.G_EXC_ERROR;
5037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5039: WHEN OTHERS THEN
5040: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5041: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_contacts');
5042: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5043: FND_MSG_PUB.ADD;
5044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5039: WHEN OTHERS THEN
5040: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5041: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_contacts');
5042: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5043: FND_MSG_PUB.ADD;
5044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5045: END find_duplicate_contacts;

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

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

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

5109: RAISE FND_API.G_EXC_ERROR;
5110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5112: WHEN OTHERS THEN
5113: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5114: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_contact_points');
5115: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5116: FND_MSG_PUB.ADD;
5117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5112: WHEN OTHERS THEN
5113: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5114: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.find_duplicate_contact_points');
5115: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5116: FND_MSG_PUB.ADD;
5117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5118: END find_duplicate_contact_points;

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

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

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

5480: RAISE FND_API.G_EXC_ERROR;
5481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5483: WHEN OTHERS THEN
5484: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5485: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.call_api_dynamic');
5486: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5487: FND_MSG_PUB.ADD;
5488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5483: WHEN OTHERS THEN
5484: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5485: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.call_api_dynamic');
5486: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5487: FND_MSG_PUB.ADD;
5488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5489: END call_api_dynamic;

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

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

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

5723: RAISE FND_API.G_EXC_ERROR;
5724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5726: WHEN OTHERS THEN
5727: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5728: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_party_sites');
5729: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5730: FND_MSG_PUB.ADD;
5731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5726: WHEN OTHERS THEN
5727: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5728: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_party_sites');
5729: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5730: FND_MSG_PUB.ADD;
5731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5732: END get_matching_party_sites;

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

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

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

5953: RAISE FND_API.G_EXC_ERROR;
5954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5956: WHEN OTHERS THEN
5957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5958: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_contacts');
5959: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5960: FND_MSG_PUB.ADD;
5961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5956: WHEN OTHERS THEN
5957: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
5958: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_contacts');
5959: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
5960: FND_MSG_PUB.ADD;
5961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5962: END get_matching_contacts;

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

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

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

6095: RAISE FND_API.G_EXC_ERROR;
6096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6098: WHEN OTHERS THEN
6099: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6100: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_contact_points');
6101: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6102: FND_MSG_PUB.ADD;
6103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6098: WHEN OTHERS THEN
6099: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6100: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_matching_contact_points');
6101: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6102: FND_MSG_PUB.ADD;
6103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6104: END get_matching_contact_points;

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

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

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

6340: RAISE FND_API.G_EXC_ERROR;
6341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6343: WHEN OTHERS THEN
6344: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6345: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_score_details');
6346: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6347: FND_MSG_PUB.ADD;
6348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6343: WHEN OTHERS THEN
6344: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6345: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_score_details');
6346: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6347: FND_MSG_PUB.ADD;
6348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6349: END get_score_details;

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

6342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6343: WHEN OTHERS THEN
6344: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6345: FND_MESSAGE.SET_TOKEN('PROC','HZ_MATCH_RULE_32.get_score_details');
6346: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6347: FND_MSG_PUB.ADD;
6348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6349: END get_score_details;
6350:

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

6463: RAISE FND_API.G_EXC_ERROR;
6464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6466: WHEN OTHERS THEN
6467: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6468: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6469: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6470: FND_MSG_PUB.ADD;
6471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6466: WHEN OTHERS THEN
6467: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6468: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6469: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6470: FND_MSG_PUB.ADD;
6471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6472: END get_party_for_search;

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

6465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6466: WHEN OTHERS THEN
6467: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6468: FND_MESSAGE.SET_TOKEN('PROC','get_party_for_search');
6469: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6470: FND_MSG_PUB.ADD;
6471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6472: END get_party_for_search;
6473:

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

6515: RAISE FND_API.G_EXC_ERROR;
6516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6518: WHEN OTHERS THEN
6519: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6520: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6521: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6522: FND_MSG_PUB.ADD;
6523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6518: WHEN OTHERS THEN
6519: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6520: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6521: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6522: FND_MSG_PUB.ADD;
6523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6524: END get_search_criteria;

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

6517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6518: WHEN OTHERS THEN
6519: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
6520: FND_MESSAGE.SET_TOKEN('PROC','get_search_criteria');
6521: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6522: FND_MSG_PUB.ADD;
6523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6524: END get_search_criteria;
6525:

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

6589: HZ_PARTY_ACQUIRE.get_known_as(p_party_id , 'PARTY','PARTY_ALL_NAMES');
6590:
6591: EXCEPTION
6592: WHEN OTHERS THEN
6593: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6594: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6595: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6596: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6597: FND_MSG_PUB.ADD;

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

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

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

6591: EXCEPTION
6592: WHEN OTHERS THEN
6593: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6594: FND_MESSAGE.SET_TOKEN('PROC','get_party_rec');
6595: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
6596: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6597: FND_MSG_PUB.ADD;
6598: RAISE FND_API.G_EXC_ERROR;
6599: END get_party_rec;

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

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

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

6651: END LOOP;
6652:
6653: EXCEPTION
6654: WHEN OTHERS THEN
6655: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6656: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6657: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6659: FND_MSG_PUB.ADD;

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

6652:
6653: EXCEPTION
6654: WHEN OTHERS THEN
6655: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6656: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6657: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6659: FND_MSG_PUB.ADD;
6660: RAISE FND_API.G_EXC_ERROR;

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

6653: EXCEPTION
6654: WHEN OTHERS THEN
6655: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6656: FND_MESSAGE.SET_TOKEN('PROC','get_party_site_rec');
6657: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_party_site_id);
6658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6659: FND_MSG_PUB.ADD;
6660: RAISE FND_API.G_EXC_ERROR;
6661: END get_party_site_rec;

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

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

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

6709: END LOOP;
6710:
6711: EXCEPTION
6712: WHEN OTHERS THEN
6713: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6714: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6715: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6716: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6717: FND_MSG_PUB.ADD;

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

6710:
6711: EXCEPTION
6712: WHEN OTHERS THEN
6713: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6714: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6715: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6716: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6717: FND_MSG_PUB.ADD;
6718: RAISE FND_API.G_EXC_ERROR;

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

6711: EXCEPTION
6712: WHEN OTHERS THEN
6713: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6714: FND_MESSAGE.SET_TOKEN('PROC','get_contact_rec');
6715: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_org_contact_id);
6716: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6717: FND_MSG_PUB.ADD;
6718: RAISE FND_API.G_EXC_ERROR;
6719: END get_contact_rec;

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

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

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

6765: END LOOP;
6766:
6767: EXCEPTION
6768: WHEN OTHERS THEN
6769: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6770: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6771: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6772: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6773: FND_MSG_PUB.ADD;

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

6766:
6767: EXCEPTION
6768: WHEN OTHERS THEN
6769: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6770: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6771: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6772: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6773: FND_MSG_PUB.ADD;
6774: RAISE FND_API.G_EXC_ERROR;

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

6767: EXCEPTION
6768: WHEN OTHERS THEN
6769: FND_MESSAGE.SET_NAME('AR', 'HZ_PARTY_QUERY_ERROR');
6770: FND_MESSAGE.SET_TOKEN('PROC','get_contact_point_rec');
6771: FND_MESSAGE.SET_TOKEN('PARTY_ID',l_contact_point_id);
6772: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
6773: FND_MSG_PUB.ADD;
6774: RAISE FND_API.G_EXC_ERROR;
6775: END get_contact_point_rec;

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

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

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

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

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

6980: END IF;
6981: EXCEPTION
6982: WHEN OTHERS THEN
6983: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6984: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6986: FND_MSG_PUB.ADD;
6987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6988: END;

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

6981: EXCEPTION
6982: WHEN OTHERS THEN
6983: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
6984: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_PARTY_REC');
6985: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6986: FND_MSG_PUB.ADD;
6987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6988: END;
6989:

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

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

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

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

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

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

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

7307: END IF;
7308: END LOOP;
7309: EXCEPTION
7310: WHEN OTHERS THEN
7311: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7312: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7313: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7314: FND_MSG_PUB.ADD;
7315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7308: END LOOP;
7309: EXCEPTION
7310: WHEN OTHERS THEN
7311: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7312: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_REC');
7313: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7314: FND_MSG_PUB.ADD;
7315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7316: END;

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

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

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

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

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

7439: END LOOP;
7440: EXCEPTION
7441: WHEN OTHERS THEN
7442: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');
7443: FND_MESSAGE.SET_TOKEN('PROC' , 'MAP_CONTACT_POINT_REC');
7444: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
7445: FND_MSG_PUB.ADD;
7446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7447: END;

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

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

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

7465: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL AND (
7466: p_contact_point_list(I).FLEX_FORMAT_PHONE_NUMBER IS NOT NULL
7467: OR p_contact_point_list(I).EMAIL_ADDRESS IS NOT NULL
7468: ) THEN
7469: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7470: FND_MSG_PUB.ADD;
7471: RAISE FND_API.G_EXC_ERROR;
7472: END IF;
7473: END LOOP;

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

7534: EXCEPTION
7535: WHEN FND_API.G_EXC_ERROR THEN
7536: RAISE FND_API.G_EXC_ERROR;
7537: WHEN OTHERS THEN
7538: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7539: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7540: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7541: FND_MSG_PUB.ADD;
7542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7535: WHEN FND_API.G_EXC_ERROR THEN
7536: RAISE FND_API.G_EXC_ERROR;
7537: WHEN OTHERS THEN
7538: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7539: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7540: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7541: FND_MSG_PUB.ADD;
7542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7543: END check_prim_cond;

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

7536: RAISE FND_API.G_EXC_ERROR;
7537: WHEN OTHERS THEN
7538: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7539: FND_MESSAGE.SET_TOKEN('PROC','check_prim_cond');
7540: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7541: FND_MSG_PUB.ADD;
7542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7543: END check_prim_cond;
7544:

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

7596: EXIT WHEN x_secondary;
7597: END LOOP;
7598: EXCEPTION
7599: WHEN OTHERS THEN
7600: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7601: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7603: FND_MSG_PUB.ADD;
7604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7597: END LOOP;
7598: EXCEPTION
7599: WHEN OTHERS THEN
7600: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7601: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7603: FND_MSG_PUB.ADD;
7604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7605: END check_party_site_cond;

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

7598: EXCEPTION
7599: WHEN OTHERS THEN
7600: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7601: FND_MESSAGE.SET_TOKEN('PROC','check_party_site_cond');
7602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7603: FND_MSG_PUB.ADD;
7604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7605: END check_party_site_cond;
7606:

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

7652: EXIT WHEN x_secondary;
7653: END LOOP;
7654: EXCEPTION
7655: WHEN OTHERS THEN
7656: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7657: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7659: FND_MSG_PUB.ADD;
7660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7653: END LOOP;
7654: EXCEPTION
7655: WHEN OTHERS THEN
7656: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7657: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7659: FND_MSG_PUB.ADD;
7660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7661: END check_contact_cond;

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

7654: EXCEPTION
7655: WHEN OTHERS THEN
7656: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7657: FND_MESSAGE.SET_TOKEN('PROC','check_contact_cond');
7658: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7659: FND_MSG_PUB.ADD;
7660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7661: END check_contact_cond;
7662:

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

7675: x_secondary:= FALSE;
7676:
7677: FOR I IN 1..p_contact_point_list.COUNT LOOP
7678: IF p_contact_point_list(I).CONTACT_POINT_TYPE IS NULL THEN
7679: FND_MESSAGE.SET_NAME('AR', 'HZ_NO_CONTACT_POINT_TYPE');
7680: FND_MSG_PUB.ADD;
7681: RAISE FND_API.G_EXC_ERROR;
7682: END IF;
7683: END LOOP;

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

7699: EXIT WHEN x_secondary;
7700: END LOOP;
7701: EXCEPTION
7702: WHEN OTHERS THEN
7703: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7704: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7705: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7706: FND_MSG_PUB.ADD;
7707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7700: END LOOP;
7701: EXCEPTION
7702: WHEN OTHERS THEN
7703: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7704: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7705: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7706: FND_MSG_PUB.ADD;
7707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7708: END check_contact_point_cond;

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

7701: EXCEPTION
7702: WHEN OTHERS THEN
7703: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');
7704: FND_MESSAGE.SET_TOKEN('PROC','check_contact_point_cond');
7705: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM );
7706: FND_MSG_PUB.ADD;
7707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7708: END check_contact_point_cond;
7709: