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.WSH_SUPPLIER_PARTY dependencies on FND_MESSAGE

Line 130: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');

126: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
127: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
128: END IF;
129:
130: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
131: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
132: fnd_msg_pub.add;
133: RETURN false;
134:

Line 131: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);

127: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
128: END IF;
129:
130: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
131: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
132: fnd_msg_pub.add;
133: RETURN false;
134:
135: END Check_Hz_Location;

Line 190: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

186: WSH_DEBUG_SV.log(l_module_name,'P_location_code',P_location_code);
187: END IF;
188:
189: IF (P_party_id IS NULL) THEN
190: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
191: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_party_id');
192: wsh_util_core.add_message(x_return_status,l_module_name);
193: raise fnd_api.g_exc_error;
194: END IF;

Line 191: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_party_id');

187: END IF;
188:
189: IF (P_party_id IS NULL) THEN
190: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
191: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_party_id');
192: wsh_util_core.add_message(x_return_status,l_module_name);
193: raise fnd_api.g_exc_error;
194: END IF;
195:

Line 197: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

193: raise fnd_api.g_exc_error;
194: END IF;
195:
196: IF (P_location_id IS NULL) THEN
197: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
198: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_location_id');
199: wsh_util_core.add_message(x_return_status,l_module_name);
200: raise fnd_api.g_exc_error;
201: END IF;

Line 198: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_location_id');

194: END IF;
195:
196: IF (P_location_id IS NULL) THEN
197: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
198: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_location_id');
199: wsh_util_core.add_message(x_return_status,l_module_name);
200: raise fnd_api.g_exc_error;
201: END IF;
202:

Line 204: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

200: raise fnd_api.g_exc_error;
201: END IF;
202:
203: IF (P_location_code IS NULL ) THEN
204: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
205: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_location_code');
206: wsh_util_core.add_message(x_return_status,l_module_name);
207: raise fnd_api.g_exc_error;
208: END IF;

Line 205: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_location_code');

201: END IF;
202:
203: IF (P_location_code IS NULL ) THEN
204: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
205: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_location_code');
206: wsh_util_core.add_message(x_return_status,l_module_name);
207: raise fnd_api.g_exc_error;
208: END IF;
209:

Line 288: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');

284: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
285: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
286: END IF;
287:
288: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
289: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
290: fnd_msg_pub.add;
291: END Create_HZ_Party_Site;
292:

Line 289: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);

285: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
286: END IF;
287:
288: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
289: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
290: fnd_msg_pub.add;
291: END Create_HZ_Party_Site;
292:
293:

Line 345: FND_MESSAGE.SET_NAME('WSH','WSH_SUPPLIER_NO_PARTY');

341: OPEN get_vendor_name;
342: FETCH get_vendor_name INTO l_vendor_name;
343: CLOSE get_vendor_name;
344:
345: FND_MESSAGE.SET_NAME('WSH','WSH_SUPPLIER_NO_PARTY');
346: FND_MESSAGE.SET_TOKEN('SUPPLIER_NAME',l_vendor_name);
347: fnd_msg_pub.add;
348: IF l_debug_on THEN
349: WSH_DEBUG_SV.pop(l_module_name);

Line 346: FND_MESSAGE.SET_TOKEN('SUPPLIER_NAME',l_vendor_name);

342: FETCH get_vendor_name INTO l_vendor_name;
343: CLOSE get_vendor_name;
344:
345: FND_MESSAGE.SET_NAME('WSH','WSH_SUPPLIER_NO_PARTY');
346: FND_MESSAGE.SET_TOKEN('SUPPLIER_NAME',l_vendor_name);
347: fnd_msg_pub.add;
348: IF l_debug_on THEN
349: WSH_DEBUG_SV.pop(l_module_name);
350: END IF;

Line 363: FND_MESSAGE.SET_NAME('WSH','WSH_SUPPLIER_NO_PARTY');

359:
360: EXCEPTION
361: WHEN NO_DATA_FOUND THEN
362: -- { IB-Phase-2
363: FND_MESSAGE.SET_NAME('WSH','WSH_SUPPLIER_NO_PARTY');
364: fnd_msg_pub.add;
365: -- } IB-Phase-2
366: IF l_debug_on THEN
367: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 380: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');

376: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
377: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
378: END IF;
379:
380: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
381: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
382: fnd_msg_pub.add;
383: RETURN 'N';
384:

Line 381: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);

377: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
378: END IF;
379:
380: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
381: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
382: fnd_msg_pub.add;
383: RETURN 'N';
384:
385: END vendor_party_exists;

Line 641: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');

637: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
638: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
639: END IF;
640:
641: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
642: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
643: fnd_msg_pub.add;
644:
645: RETURN null;

Line 642: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);

638: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
639: END IF;
640:
641: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
642: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
643: fnd_msg_pub.add;
644:
645: RETURN null;
646:

Line 797: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');

793: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
794: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
795: END IF;
796:
797: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
798: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
799: fnd_msg_pub.add;
800: END Update_Hz_Location;
801:

Line 798: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);

794: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
795: END IF;
796:
797: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
798: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
799: fnd_msg_pub.add;
800: END Update_Hz_Location;
801:
802:

Line 878: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

874: WSH_DEBUG_SV.log(l_module_name,'p_country',p_country);
875: END IF;
876:
877: IF (P_party_id IS NULL) THEN
878: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
879: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_party_id');
880: wsh_util_core.add_message(x_return_status,l_module_name);
881: raise fnd_api.g_exc_error;
882: END IF;

Line 879: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_party_id');

875: END IF;
876:
877: IF (P_party_id IS NULL) THEN
878: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
879: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_party_id');
880: wsh_util_core.add_message(x_return_status,l_module_name);
881: raise fnd_api.g_exc_error;
882: END IF;
883:

Line 885: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

881: raise fnd_api.g_exc_error;
882: END IF;
883:
884: IF (P_address1 IS NULL) THEN
885: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
886: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_address1');
887: wsh_util_core.add_message(x_return_status,l_module_name);
888: raise fnd_api.g_exc_error;
889: END IF;

Line 886: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_address1');

882: END IF;
883:
884: IF (P_address1 IS NULL) THEN
885: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
886: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_address1');
887: wsh_util_core.add_message(x_return_status,l_module_name);
888: raise fnd_api.g_exc_error;
889: END IF;
890:

Line 892: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

888: raise fnd_api.g_exc_error;
889: END IF;
890:
891: IF (p_country IS NULL ) THEN
892: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
893: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_country');
894: wsh_util_core.add_message(x_return_status,l_module_name);
895: raise fnd_api.g_exc_error;
896: END IF;

Line 893: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_country');

889: END IF;
890:
891: IF (p_country IS NULL ) THEN
892: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
893: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_country');
894: wsh_util_core.add_message(x_return_status,l_module_name);
895: raise fnd_api.g_exc_error;
896: END IF;
897:

Line 899: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

895: raise fnd_api.g_exc_error;
896: END IF;
897:
898: IF (p_location_code IS NULL ) THEN
899: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
900: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_location_code');
901: wsh_util_core.add_message(x_return_status,l_module_name);
902: raise fnd_api.g_exc_error;
903: END IF;

Line 900: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_location_code');

896: END IF;
897:
898: IF (p_location_code IS NULL ) THEN
899: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
900: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_location_code');
901: wsh_util_core.add_message(x_return_status,l_module_name);
902: raise fnd_api.g_exc_error;
903: END IF;
904:

Line 1003: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');

999: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1000: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1001: END IF;
1002:
1003: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
1004: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
1005: fnd_msg_pub.add;
1006: END Create_Hz_Location_Party_Site;
1007:

Line 1004: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);

1000: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1001: END IF;
1002:
1003: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
1004: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
1005: fnd_msg_pub.add;
1006: END Create_Hz_Location_Party_Site;
1007:
1008:

Line 1108: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');

1104: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1105: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1106: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1107: END IF;
1108: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
1109: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
1110: fnd_msg_pub.add;
1111: raise ;
1112: END Is_Valid_ISP_User;

Line 1109: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);

1105: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1106: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1107: END IF;
1108: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
1109: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
1110: fnd_msg_pub.add;
1111: raise ;
1112: END Is_Valid_ISP_User;
1113:

Line 1169: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_INVALID_ISP_USER');

1165:
1166: --Validate the ISP user.
1167: IF (p_in_param.caller= 'ISP' ) THEN
1168: IF ( NOT Is_Valid_ISP_User(p_in_param.user_id,P_supplier_name)) THEN
1169: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_INVALID_ISP_USER');
1170: fnd_msg_pub.add;
1171: raise fnd_api.g_exc_error;
1172: END IF;
1173: END IF;

Line 1186: FND_MESSAGE.SET_NAME('WSH','WSH_RR_INV_SUPPLIER');

1182:
1183: IF (validate_vendor_csr%NOTFOUND) THEN
1184: CLOSE validate_vendor_csr;
1185:
1186: FND_MESSAGE.SET_NAME('WSH','WSH_RR_INV_SUPPLIER');
1187: FND_MESSAGE.SET_TOKEN('SUP_NAME',P_supplier_name);
1188: fnd_msg_pub.add;
1189:
1190: raise fnd_api.g_exc_error;

Line 1187: FND_MESSAGE.SET_TOKEN('SUP_NAME',P_supplier_name);

1183: IF (validate_vendor_csr%NOTFOUND) THEN
1184: CLOSE validate_vendor_csr;
1185:
1186: FND_MESSAGE.SET_NAME('WSH','WSH_RR_INV_SUPPLIER');
1187: FND_MESSAGE.SET_TOKEN('SUP_NAME',P_supplier_name);
1188: fnd_msg_pub.add;
1189:
1190: raise fnd_api.g_exc_error;
1191: END IF;

Line 1227: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');

1223: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1224: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1225: END IF;
1226:
1227: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
1228: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
1229: fnd_msg_pub.add;
1230: END Validate_Supplier;
1231:

Line 1228: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);

1224: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1225: END IF;
1226:
1227: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
1228: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
1229: fnd_msg_pub.add;
1230: END Validate_Supplier;
1231:
1232:

Line 1302: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');

1298: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1299: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1300: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1301: END IF;
1302: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
1303: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
1304: fnd_msg_pub.add;
1305:
1306: RETURN false;

Line 1303: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);

1299: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1300: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1301: END IF;
1302: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
1303: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
1304: fnd_msg_pub.add;
1305:
1306: RETURN false;
1307:

Line 1356: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

1352: WSH_DEBUG_SV.log(l_module_name,'P_site_use_type',P_site_use_type);
1353: END IF;
1354:
1355: IF (P_party_site_id IS NULL) THEN
1356: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
1357: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_party_site_id');
1358: wsh_util_core.add_message(x_return_status,l_module_name);
1359: raise fnd_api.g_exc_error;
1360: END IF;

Line 1357: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_party_site_id');

1353: END IF;
1354:
1355: IF (P_party_site_id IS NULL) THEN
1356: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
1357: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_party_site_id');
1358: wsh_util_core.add_message(x_return_status,l_module_name);
1359: raise fnd_api.g_exc_error;
1360: END IF;
1361:

Line 1363: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

1359: raise fnd_api.g_exc_error;
1360: END IF;
1361:
1362: IF (P_site_use_type IS NULL ) THEN
1363: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
1364: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_site_use_type');
1365: wsh_util_core.add_message(x_return_status,l_module_name);
1366: raise fnd_api.g_exc_error;
1367: END IF;

Line 1364: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_site_use_type');

1360: END IF;
1361:
1362: IF (P_site_use_type IS NULL ) THEN
1363: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
1364: FND_MESSAGE.SET_TOKEN('FIELD_NAME','P_site_use_type');
1365: wsh_util_core.add_message(x_return_status,l_module_name);
1366: raise fnd_api.g_exc_error;
1367: END IF;
1368:

Line 1429: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');

1425: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1426: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1427: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1428: END IF;
1429: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
1430: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
1431: fnd_msg_pub.add;
1432:
1433: END Create_HZ_Party_Site_uses;

Line 1430: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);

1426: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1427: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1428: END IF;
1429: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
1430: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
1431: fnd_msg_pub.add;
1432:
1433: END Create_HZ_Party_Site_uses;
1434:

Line 1532: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_ERROR_CR_CONTACT');

1528: EXCEPTION
1529: WHEN FND_API.G_EXC_ERROR THEN
1530: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1531:
1532: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_ERROR_CR_CONTACT');
1533: fnd_msg_pub.add;
1534:
1535: IF l_debug_on THEN
1536: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1551: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');

1547: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1548: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1549: END IF;
1550:
1551: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
1552: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
1553: fnd_msg_pub.add;
1554: END Create_hz_phone_contact;
1555:

Line 1552: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);

1548: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1549: END IF;
1550:
1551: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
1552: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
1553: fnd_msg_pub.add;
1554: END Create_hz_phone_contact;
1555:
1556:

Line 1795: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_ERROR_UP_CONTACT');

1791: EXCEPTION
1792: WHEN FND_API.G_EXC_ERROR THEN
1793: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1794:
1795: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_ERROR_UP_CONTACT');
1796: fnd_msg_pub.add;
1797:
1798: IF l_debug_on THEN
1799: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1831: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');

1827: IF (Get_Cont_Point_Version%ISOPEN) THEN
1828: CLOSE Get_Cont_Point_Version;
1829: END IF;
1830:
1831: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
1832: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
1833: fnd_msg_pub.add;
1834:
1835: END Update_HZ_contact;

Line 1832: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);

1828: CLOSE Get_Cont_Point_Version;
1829: END IF;
1830:
1831: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
1832: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
1833: fnd_msg_pub.add;
1834:
1835: END Update_HZ_contact;
1836:

Line 2043: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_ERROR_CR_CONTACT');

2039: EXCEPTION
2040: WHEN FND_API.G_EXC_ERROR THEN
2041: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2042:
2043: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_ERROR_CR_CONTACT');
2044: fnd_msg_pub.add;
2045:
2046: IF l_debug_on THEN
2047: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2062: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');

2058: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2059: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2060: END IF;
2061:
2062: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
2063: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
2064: fnd_msg_pub.add;
2065: END Create_HZ_contact;
2066:

Line 2063: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);

2059: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2060: END IF;
2061:
2062: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
2063: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
2064: fnd_msg_pub.add;
2065: END Create_HZ_contact;
2066:
2067:

Line 2316: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');

2312: IF (Get_Contact_info%ISOPEN) THEN
2313: CLOSE Get_Contact_info;
2314: END IF;
2315:
2316: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
2317: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
2318: fnd_msg_pub.add;
2319: END Process_HZ_contact;
2320:

Line 2317: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);

2313: CLOSE Get_Contact_info;
2314: END IF;
2315:
2316: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
2317: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
2318: fnd_msg_pub.add;
2319: END Process_HZ_contact;
2320:
2321:

Line 2471: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_ERROR_UP_LOC');

2467: EXCEPTION
2468: WHEN FND_API.G_EXC_ERROR THEN
2469: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2470:
2471: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_ERROR_UP_LOC');
2472: fnd_msg_pub.add;
2473:
2474: IF l_debug_on THEN
2475: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2488: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');

2484: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2485: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2486: END IF;
2487:
2488: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
2489: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
2490: fnd_msg_pub.add;
2491: END Update_Address;
2492:

Line 2489: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);

2485: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2486: END IF;
2487:
2488: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
2489: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
2490: fnd_msg_pub.add;
2491: END Update_Address;
2492:
2493:

Line 2671: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_ERROR_CR_LOC');

2667: EXCEPTION
2668: WHEN FND_API.G_EXC_ERROR THEN
2669: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2670:
2671: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_ERROR_CR_LOC');
2672: fnd_msg_pub.add;
2673:
2674: IF l_debug_on THEN
2675: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2688: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');

2684: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2685: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2686: END IF;
2687:
2688: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
2689: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
2690: fnd_msg_pub.add;
2691: END CREATE_ADDRESS;
2692:

Line 2689: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);

2685: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2686: END IF;
2687:
2688: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
2689: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
2690: fnd_msg_pub.add;
2691: END CREATE_ADDRESS;
2692:
2693:

Line 2723: FND_MESSAGE.SET_NAME('WSH','WSH_SAB_ADDRESS_ERROR');

2719: IF l_debug_on THEN
2720: WSH_DEBUG_SV.push(l_module_name);
2721: END IF;
2722:
2723: FND_MESSAGE.SET_NAME('WSH','WSH_SAB_ADDRESS_ERROR');
2724: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',g_line_number);
2725: fnd_msg_pub.add;
2726:
2727: IF l_debug_on THEN

Line 2724: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',g_line_number);

2720: WSH_DEBUG_SV.push(l_module_name);
2721: END IF;
2722:
2723: FND_MESSAGE.SET_NAME('WSH','WSH_SAB_ADDRESS_ERROR');
2724: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',g_line_number);
2725: fnd_msg_pub.add;
2726:
2727: IF l_debug_on THEN
2728: WSH_DEBUG_SV.log(l_module_name,'Message Count:',FND_MSG_PUB.Count_Msg);

Line 2745: --Initialized the FND message to avoid duplicate message being

2741: IF l_debug_on THEN
2742: WSH_DEBUG_SV.log(l_module_name,'After Message Count:',FND_MSG_PUB.Count_Msg);
2743: END IF;
2744:
2745: --Initialized the FND message to avoid duplicate message being
2746: --inserted to local message table.
2747: FND_MSG_PUB.initialize;
2748:
2749: IF l_debug_on THEN

Line 2760: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');

2756: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2758: END IF;
2759:
2760: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
2761: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
2762: g_error_tbl(g_error_tbl.count + 1) := FND_MESSAGE.GET;
2763: END Get_message;
2764:

Line 2761: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);

2757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2758: END IF;
2759:
2760: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
2761: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
2762: g_error_tbl(g_error_tbl.count + 1) := FND_MESSAGE.GET;
2763: END Get_message;
2764:
2765:

Line 2762: g_error_tbl(g_error_tbl.count + 1) := FND_MESSAGE.GET;

2758: END IF;
2759:
2760: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
2761: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
2762: g_error_tbl(g_error_tbl.count + 1) := FND_MESSAGE.GET;
2763: END Get_message;
2764:
2765:
2766: -- Start of comments

Line 2854: FND_MESSAGE.SET_NAME('WSH','WSH_RR_INV_ACTION');

2850: g_line_number:= l_index;
2851:
2852: --Check for validate action code.
2853: IF (P_Address.action(l_index) NOT IN ('I','U') ) THEN
2854: FND_MESSAGE.SET_NAME('WSH','WSH_RR_INV_ACTION');
2855: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_index);
2856: fnd_msg_pub.add;
2857:
2858: wsh_util_core.api_post_call(p_return_status =>WSH_UTIL_CORE.G_RET_STS_ERROR,

Line 2855: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_index);

2851:
2852: --Check for validate action code.
2853: IF (P_Address.action(l_index) NOT IN ('I','U') ) THEN
2854: FND_MESSAGE.SET_NAME('WSH','WSH_RR_INV_ACTION');
2855: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_index);
2856: fnd_msg_pub.add;
2857:
2858: wsh_util_core.api_post_call(p_return_status =>WSH_UTIL_CORE.G_RET_STS_ERROR,
2859: x_num_warnings =>l_num_warning,

Line 2898: FND_MESSAGE.SET_NAME('WSH','WSH_RR_INV_ACTION');

2894: END IF;
2895:
2896: --For existing record action should not be Insert.
2897: IF (P_Address.action(l_index) = 'I' ) THEN
2898: FND_MESSAGE.SET_NAME('WSH','WSH_RR_INV_ACTION');
2899: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_index);
2900: fnd_msg_pub.add;
2901: wsh_util_core.api_post_call(p_return_status =>WSH_UTIL_CORE.G_RET_STS_ERROR,
2902: x_num_warnings =>l_num_warning,

Line 2899: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_index);

2895:
2896: --For existing record action should not be Insert.
2897: IF (P_Address.action(l_index) = 'I' ) THEN
2898: FND_MESSAGE.SET_NAME('WSH','WSH_RR_INV_ACTION');
2899: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_index);
2900: fnd_msg_pub.add;
2901: wsh_util_core.api_post_call(p_return_status =>WSH_UTIL_CORE.G_RET_STS_ERROR,
2902: x_num_warnings =>l_num_warning,
2903: x_num_errors =>l_num_errors);

Line 2911: FND_MESSAGE.SET_NAME('WSH','WSH_INACTIVE_PARTY_SITE');

2907: -- If Party Site is not Active then error out, with a suitable message.
2908: IF l_party_site_status <> 'A'
2909: THEN
2910: l_party_site_msg := p_Address.ship_from_code(l_index);
2911: FND_MESSAGE.SET_NAME('WSH','WSH_INACTIVE_PARTY_SITE');
2912: FND_MESSAGE.SET_TOKEN('PARTY_SITE',l_party_site_msg);
2913: fnd_msg_pub.add;
2914: l_num_errors := l_num_errors + 1;
2915: raise FND_API.G_EXC_ERROR;

Line 2912: FND_MESSAGE.SET_TOKEN('PARTY_SITE',l_party_site_msg);

2908: IF l_party_site_status <> 'A'
2909: THEN
2910: l_party_site_msg := p_Address.ship_from_code(l_index);
2911: FND_MESSAGE.SET_NAME('WSH','WSH_INACTIVE_PARTY_SITE');
2912: FND_MESSAGE.SET_TOKEN('PARTY_SITE',l_party_site_msg);
2913: fnd_msg_pub.add;
2914: l_num_errors := l_num_errors + 1;
2915: raise FND_API.G_EXC_ERROR;
2916: END IF;

Line 2953: FND_MESSAGE.SET_NAME('WSH','WSH_RR_INV_ACTION');

2949: END IF;
2950: IF (P_Address.action(l_index) = 'U' ) THEN
2951:
2952: --For new record action should not be Update.
2953: FND_MESSAGE.SET_NAME('WSH','WSH_RR_INV_ACTION');
2954: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_index);
2955: fnd_msg_pub.add;
2956:
2957: wsh_util_core.api_post_call(p_return_status =>WSH_UTIL_CORE.G_RET_STS_ERROR,

Line 2954: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_index);

2950: IF (P_Address.action(l_index) = 'U' ) THEN
2951:
2952: --For new record action should not be Update.
2953: FND_MESSAGE.SET_NAME('WSH','WSH_RR_INV_ACTION');
2954: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_index);
2955: fnd_msg_pub.add;
2956:
2957: wsh_util_core.api_post_call(p_return_status =>WSH_UTIL_CORE.G_RET_STS_ERROR,
2958: x_num_warnings =>l_num_warning,

Line 2997: FND_MESSAGE.SET_NAME('WSH','WSH_SAB_ADDRESS_SUCCESS');

2993: END IF; --}
2994:
2995: CLOSE check_location_csr;
2996:
2997: FND_MESSAGE.SET_NAME('WSH','WSH_SAB_ADDRESS_SUCCESS');
2998: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_index);
2999: l_msg_count := l_msg_count + 1;
3000: x_success_tbl.extend;
3001: x_success_tbl(l_msg_count):=FND_MESSAGE.Get;

Line 2998: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_index);

2994:
2995: CLOSE check_location_csr;
2996:
2997: FND_MESSAGE.SET_NAME('WSH','WSH_SAB_ADDRESS_SUCCESS');
2998: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_index);
2999: l_msg_count := l_msg_count + 1;
3000: x_success_tbl.extend;
3001: x_success_tbl(l_msg_count):=FND_MESSAGE.Get;
3002:

Line 3001: x_success_tbl(l_msg_count):=FND_MESSAGE.Get;

2997: FND_MESSAGE.SET_NAME('WSH','WSH_SAB_ADDRESS_SUCCESS');
2998: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_index);
2999: l_msg_count := l_msg_count + 1;
3000: x_success_tbl.extend;
3001: x_success_tbl(l_msg_count):=FND_MESSAGE.Get;
3002:
3003: EXCEPTION
3004: WHEN FND_API.G_EXC_ERROR THEN
3005: IF l_debug_on THEN

Line 3062: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');

3058: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3059: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3060: END IF;
3061:
3062: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
3063: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
3064: fnd_msg_pub.add;
3065: END Process_Address;
3066:

Line 3063: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);

3059: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3060: END IF;
3061:
3062: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
3063: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
3064: fnd_msg_pub.add;
3065: END Process_Address;
3066:
3067: