DBA Data[Home] [Help]

APPS.WSH_CUSTOM_PUB dependencies on FND_MESSAGE

Line 1158: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_E');

1154: END IF;
1155: l_errmsg_txt := 'Exception while fetching the Address Validation error message';
1156: END;
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_E');
1159: FND_MESSAGE.SET_TOKEN('MSG_TEXT',l_errmsg_txt);
1160: WSH_UTIL_CORE.Add_Message(FND_API.G_RET_STS_ERROR);
1161: END IF;
1162:

Line 1159: FND_MESSAGE.SET_TOKEN('MSG_TEXT',l_errmsg_txt);

1155: l_errmsg_txt := 'Exception while fetching the Address Validation error message';
1156: END;
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_E');
1159: FND_MESSAGE.SET_TOKEN('MSG_TEXT',l_errmsg_txt);
1160: WSH_UTIL_CORE.Add_Message(FND_API.G_RET_STS_ERROR);
1161: END IF;
1162:
1163:

Line 1174: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_PROXY');

1170: x_return_status := l_return_status ;
1171: */--Commenting the comment UPS WS Integeration code End
1172: EXCEPTION
1173: WHEN WSH_U_PROXY THEN
1174: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_PROXY');
1175: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
1176: x_return_status := FND_API.G_RET_STS_ERROR;
1177: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1178: IF x_msg_count > 1 THEN

Line 1188: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_CSP');

1184: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_u_proxy exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1185: WSH_DEBUG_SV.pop(l_module_name,'exception:wsh_u_proxy');
1186: END IF;
1187: WHEN WSH_U_CSP THEN
1188: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_CSP');
1189: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
1190: x_return_status := FND_API.G_RET_STS_ERROR;
1191: wsh_util_core.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1192: IF x_msg_count > 1 THEN

Line 1202: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_HOST_FAILED');

1198: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_CSP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1199: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_CSP');
1200: END IF;
1201: WHEN WSH_U_HOST_FAILED THEN
1202: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_HOST_FAILED');
1203: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
1204: x_return_status := FND_API.G_RET_STS_ERROR;
1205: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1206: IF x_msg_count > 1 then

Line 1222: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_CITYORZIP');

1218: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_HOST_FAILED');
1219: END IF;
1220:
1221: WHEN WSH_U_CITYORZIP THEN
1222: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_CITYORZIP');
1223: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
1224: x_return_status := FND_API.G_RET_STS_ERROR;
1225: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, l_msg_count);
1226: IF l_msg_count > 1 THEN

Line 1240: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_TNS');

1236: --
1237: WHEN OTHERS THEN
1238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1239: IF sqlcode ='-12543' THEN
1240: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_TNS');
1241: FND_MESSAGE.SET_TOKEN('MSG_TEXT','TNS:destination host unreachable');
1242: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
1243: x_return_status := FND_API.G_RET_STS_ERROR;
1244: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

Line 1241: FND_MESSAGE.SET_TOKEN('MSG_TEXT','TNS:destination host unreachable');

1237: WHEN OTHERS THEN
1238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1239: IF sqlcode ='-12543' THEN
1240: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_TNS');
1241: FND_MESSAGE.SET_TOKEN('MSG_TEXT','TNS:destination host unreachable');
1242: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
1243: x_return_status := FND_API.G_RET_STS_ERROR;
1244: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1245: IF x_msg_count > 1 THEN

Line 1256: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PASSWD');

1252: END IF;
1253: RETURN;
1254: ELSIF sqlcode ='-29106'
1255: THEN
1256: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PASSWD');
1257: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet password');
1258: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
1259: x_return_status := FND_API.G_RET_STS_ERROR;
1260: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

Line 1257: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet password');

1253: RETURN;
1254: ELSIF sqlcode ='-29106'
1255: THEN
1256: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PASSWD');
1257: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet password');
1258: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
1259: x_return_status := FND_API.G_RET_STS_ERROR;
1260: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1261: IF x_msg_count > 1 THEN

Line 1272: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PATH');

1268: END IF;
1269: RETURN;
1270: ELSIF sqlcode ='-28759'
1271: THEN
1272: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PATH');
1273: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet path or its privileges');
1274: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
1275: x_return_status := FND_API.G_RET_STS_ERROR;
1276: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

Line 1273: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet path or its privileges');

1269: RETURN;
1270: ELSIF sqlcode ='-28759'
1271: THEN
1272: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PATH');
1273: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet path or its privileges');
1274: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
1275: x_return_status := FND_API.G_RET_STS_ERROR;
1276: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1277: IF x_msg_count > 1 THEN

Line 1940: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_E');

1936: END IF;
1937: l_errmsg_txt := 'Exception while fetching the Rate and Services error message';
1938: END;
1939: x_return_status := FND_API.G_RET_STS_ERROR;
1940: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_E');
1941: FND_MESSAGE.SET_TOKEN('MSG_TEXT',l_errmsg_txt);
1942: WSH_UTIL_CORE.Add_Message(FND_API.G_RET_STS_ERROR);
1943:
1944: x_output(l_index).PackageActualWeight := NULL;

Line 1941: FND_MESSAGE.SET_TOKEN('MSG_TEXT',l_errmsg_txt);

1937: l_errmsg_txt := 'Exception while fetching the Rate and Services error message';
1938: END;
1939: x_return_status := FND_API.G_RET_STS_ERROR;
1940: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_E');
1941: FND_MESSAGE.SET_TOKEN('MSG_TEXT',l_errmsg_txt);
1942: WSH_UTIL_CORE.Add_Message(FND_API.G_RET_STS_ERROR);
1943:
1944: x_output(l_index).PackageActualWeight := NULL;
1945: x_output(l_index).ProductCharge := NULL;

Line 1962: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_PROXY');

1958: */
1959: -- End of the comment UPS WS Integeration code
1960: EXCEPTION
1961: WHEN WSH_U_PROXY THEN
1962: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_PROXY');
1963: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
1964: x_return_status := FND_API.G_RET_STS_ERROR;
1965: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1966: IF x_msg_count > 1 THEN

Line 1976: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_SRVLEVCODE');

1972: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_u_proxy exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1973: WSH_DEBUG_SV.pop(l_module_name,'exception:wsh_u_proxy');
1974: END IF;
1975: WHEN WSH_U_SRVLEVCODE THEN
1976: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_SRVLEVCODE');
1977: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
1978: x_return_status := FND_API.G_RET_STS_ERROR;
1979: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1980: IF x_msg_count > 1 THEN

Line 1992: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_PKGACTWT');

1988: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_SRVLEVCODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1989: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_SRVLEVCODE');
1990: END IF;
1991: WHEN WSH_U_PKGACTWT THEN
1992: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_PKGACTWT');
1993: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
1994: x_return_status := FND_API.G_RET_STS_ERROR;
1995: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1996: IF x_msg_count > 1 then

Line 2008: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_SPOSTALCODE');

2004: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_PKGACTWT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2005: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_PKGACTWT');
2006: END IF;
2007: WHEN WSH_U_SPOSTALCODE THEN
2008: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_SPOSTALCODE');
2009: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2010: x_return_status := FND_API.G_RET_STS_ERROR;
2011: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
2012: IF x_msg_count > 1 THEN

Line 2025: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_CPOSTALCODE');

2021: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_SPOSTALCODE');
2022: END IF;
2023: --
2024: WHEN WSH_U_CPOSTALCODE THEN
2025: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_CPOSTALCODE');
2026: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2027: x_return_status := FND_API.G_RET_STS_ERROR;
2028: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
2029: IF x_msg_count > 1 THEN

Line 2042: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_CCOUNTRY');

2038: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_CPOSTALCODE');
2039: END IF;
2040: --
2041: WHEN WSH_U_CCOUNTRY THEN
2042: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_CCOUNTRY');
2043: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2044: x_return_status := FND_API.G_RET_STS_ERROR;
2045: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
2046: IF x_msg_count > 1 THEN

Line 2059: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_RATECHART');

2055: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_CCOUNTRY');
2056: END IF;
2057:
2058: WHEN WSH_U_RATECHART THEN
2059: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_RATECHART');
2060: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2061: x_return_status := FND_API.G_RET_STS_ERROR;
2062: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
2063: if x_msg_count > 1 then

Line 2075: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_HOST_FAILED');

2071: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_RATECHART exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2072: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_RATECHART');
2073: END IF;
2074: WHEN WSH_U_HOST_FAILED THEN
2075: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_HOST_FAILED');
2076: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2077: x_return_status := FND_API.G_RET_STS_ERROR;
2078: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
2079: IF x_msg_count > 1 then

Line 2097: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_TNS');

2093:
2094: WHEN OTHERS THEN
2095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2096: IF sqlcode ='-12543' THEN
2097: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_TNS');
2098: FND_MESSAGE.SET_TOKEN('MSG_TEXT','TNS:destination host unreachable');
2099: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2100: x_return_status := FND_API.G_RET_STS_ERROR;
2101: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

Line 2098: FND_MESSAGE.SET_TOKEN('MSG_TEXT','TNS:destination host unreachable');

2094: WHEN OTHERS THEN
2095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2096: IF sqlcode ='-12543' THEN
2097: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_TNS');
2098: FND_MESSAGE.SET_TOKEN('MSG_TEXT','TNS:destination host unreachable');
2099: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2100: x_return_status := FND_API.G_RET_STS_ERROR;
2101: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
2102: IF x_msg_count > 1 THEN

Line 2113: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PASSWD');

2109: END IF;
2110: RETURN;
2111: ELSIF sqlcode ='-29106'
2112: THEN
2113: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PASSWD');
2114: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet password');
2115: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2116: x_return_status := FND_API.G_RET_STS_ERROR;
2117: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

Line 2114: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet password');

2110: RETURN;
2111: ELSIF sqlcode ='-29106'
2112: THEN
2113: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PASSWD');
2114: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet password');
2115: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2116: x_return_status := FND_API.G_RET_STS_ERROR;
2117: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
2118: IF x_msg_count > 1 THEN

Line 2129: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PATH');

2125: END IF;
2126: RETURN;
2127: ELSIF sqlcode ='-28759'
2128: THEN
2129: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PATH');
2130: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet path or its privileges');
2131: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2132: x_return_status := FND_API.G_RET_STS_ERROR;
2133: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

Line 2130: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet path or its privileges');

2126: RETURN;
2127: ELSIF sqlcode ='-28759'
2128: THEN
2129: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PATH');
2130: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet path or its privileges');
2131: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2132: x_return_status := FND_API.G_RET_STS_ERROR;
2133: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
2134: IF x_msg_count > 1 THEN

Line 2533: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_E');

2529: l_errmsg_txt := 'Exception while fetching the tracking error message';
2530: END;
2531:
2532: x_return_status := FND_API.G_RET_STS_ERROR;
2533: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_E');
2534: FND_MESSAGE.SET_TOKEN('MSG_TEXT',l_errmsg_txt);
2535: WSH_UTIL_CORE.Add_Message(FND_API.G_RET_STS_ERROR);
2536:
2537: END IF;

Line 2534: FND_MESSAGE.SET_TOKEN('MSG_TEXT',l_errmsg_txt);

2530: END;
2531:
2532: x_return_status := FND_API.G_RET_STS_ERROR;
2533: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_E');
2534: FND_MESSAGE.SET_TOKEN('MSG_TEXT',l_errmsg_txt);
2535: WSH_UTIL_CORE.Add_Message(FND_API.G_RET_STS_ERROR);
2536:
2537: END IF;
2538: IF l_debug_on THEN

Line 2551: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_PROXY');

2547: END IF;
2548: x_return_status := l_return_status ;
2549: EXCEPTION
2550: WHEN WSH_U_PROXY THEN
2551: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_PROXY');
2552: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Could not find proxy settings');
2553: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2554: x_return_status := FND_API.G_RET_STS_ERROR;
2555: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

Line 2552: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Could not find proxy settings');

2548: x_return_status := l_return_status ;
2549: EXCEPTION
2550: WHEN WSH_U_PROXY THEN
2551: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_PROXY');
2552: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Could not find proxy settings');
2553: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2554: x_return_status := FND_API.G_RET_STS_ERROR;
2555: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
2556: IF x_msg_count > 1 THEN

Line 2566: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_HOST_FAILED');

2562: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_u_proxy exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2563: WSH_DEBUG_SV.pop(l_module_name,'exception:wsh_u_proxy');
2564: END IF;
2565: WHEN WSH_U_HOST_FAILED THEN
2566: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_HOST_FAILED');
2567: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2568: x_return_status := FND_API.G_RET_STS_ERROR;
2569: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
2570: IF x_msg_count > 1 then

Line 2585: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_NO_TRK');

2581: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_HOST_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2582: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_HOST_FAILED');
2583: END IF;
2584: WHEN WSH_U_NO_TRK THEN
2585: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_NO_TRK');
2586: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Invalid Tracking Number');
2587: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2588: x_return_status := FND_API.G_RET_STS_ERROR;
2589: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

Line 2586: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Invalid Tracking Number');

2582: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_HOST_FAILED');
2583: END IF;
2584: WHEN WSH_U_NO_TRK THEN
2585: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_NO_TRK');
2586: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Invalid Tracking Number');
2587: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2588: x_return_status := FND_API.G_RET_STS_ERROR;
2589: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
2590: IF x_msg_count > 1 then

Line 2607: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_TNS');

2603: END IF; --
2604: WHEN OTHERS THEN
2605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2606: IF sqlcode ='-12543' THEN
2607: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_TNS');
2608: FND_MESSAGE.SET_TOKEN('MSG_TEXT','TNS:destination host unreachable');
2609: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2610: x_return_status := FND_API.G_RET_STS_ERROR;
2611: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

Line 2608: FND_MESSAGE.SET_TOKEN('MSG_TEXT','TNS:destination host unreachable');

2604: WHEN OTHERS THEN
2605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2606: IF sqlcode ='-12543' THEN
2607: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_TNS');
2608: FND_MESSAGE.SET_TOKEN('MSG_TEXT','TNS:destination host unreachable');
2609: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2610: x_return_status := FND_API.G_RET_STS_ERROR;
2611: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
2612: IF x_msg_count > 1 THEN

Line 2623: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PASSWD');

2619: END IF;
2620: RETURN;
2621: ELSIF sqlcode ='-29106'
2622: THEN
2623: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PASSWD');
2624: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet password');
2625: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2626: x_return_status := FND_API.G_RET_STS_ERROR;
2627: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

Line 2624: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet password');

2620: RETURN;
2621: ELSIF sqlcode ='-29106'
2622: THEN
2623: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PASSWD');
2624: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet password');
2625: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2626: x_return_status := FND_API.G_RET_STS_ERROR;
2627: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
2628: IF x_msg_count > 1 THEN

Line 2639: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PATH');

2635: END IF;
2636: RETURN;
2637: ELSIF sqlcode ='-28759'
2638: THEN
2639: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PATH');
2640: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet path or its privileges');
2641: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2642: x_return_status := FND_API.G_RET_STS_ERROR;
2643: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

Line 2640: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet path or its privileges');

2636: RETURN;
2637: ELSIF sqlcode ='-28759'
2638: THEN
2639: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PATH');
2640: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet path or its privileges');
2641: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2642: x_return_status := FND_API.G_RET_STS_ERROR;
2643: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
2644: IF x_msg_count > 1 THEN

Line 2657: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_UNEXPECTED ERROR');

2653:
2654:
2655: END IF;
2656:
2657: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_UNEXPECTED ERROR');
2658: FND_MESSAGE.SET_TOKEN('MSG_TEXT',substr(sqlerrm,1,50));
2659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2660: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2661: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2658: FND_MESSAGE.SET_TOKEN('MSG_TEXT',substr(sqlerrm,1,50));

2654:
2655: END IF;
2656:
2657: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_UNEXPECTED ERROR');
2658: FND_MESSAGE.SET_TOKEN('MSG_TEXT',substr(sqlerrm,1,50));
2659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2660: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
2661: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2662: THEN

Line 3010: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_E');

3006: END IF;
3007: l_errmsg_txt := 'Exception while fetching the Time In Transit error message';
3008: END;
3009: x_return_status := FND_API.G_RET_STS_ERROR;
3010: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_E');
3011: FND_MESSAGE.SET_TOKEN('MSG_TEXT',l_errmsg_txt);
3012: WSH_UTIL_CORE.Add_Message(FND_API.G_RET_STS_ERROR);
3013:
3014: END IF;

Line 3011: FND_MESSAGE.SET_TOKEN('MSG_TEXT',l_errmsg_txt);

3007: l_errmsg_txt := 'Exception while fetching the Time In Transit error message';
3008: END;
3009: x_return_status := FND_API.G_RET_STS_ERROR;
3010: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_E');
3011: FND_MESSAGE.SET_TOKEN('MSG_TEXT',l_errmsg_txt);
3012: WSH_UTIL_CORE.Add_Message(FND_API.G_RET_STS_ERROR);
3013:
3014: END IF;
3015:

Line 3033: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_PROXY');

3029: */ -- End of Comment the UPS WS Integeration code
3030:
3031: EXCEPTION
3032: WHEN WSH_U_PROXY THEN
3033: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_PROXY');
3034: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Could not find proxy settings');
3035: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
3036: x_return_status := FND_API.G_RET_STS_ERROR;
3037: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

Line 3034: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Could not find proxy settings');

3030:
3031: EXCEPTION
3032: WHEN WSH_U_PROXY THEN
3033: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_PROXY');
3034: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Could not find proxy settings');
3035: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
3036: x_return_status := FND_API.G_RET_STS_ERROR;
3037: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
3038: IF x_msg_count > 1 THEN

Line 3048: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_HOST_FAILED');

3044: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_u_proxy exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3045: WSH_DEBUG_SV.pop(l_module_name,'exception:wsh_u_proxy');
3046: END IF;
3047: WHEN WSH_U_HOST_FAILED THEN
3048: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_HOST_FAILED');
3049: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
3050: x_return_status := FND_API.G_RET_STS_ERROR;
3051: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
3052: IF x_msg_count > 1 then

Line 3069: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_TNS');

3065: END IF;
3066: WHEN OTHERS THEN
3067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3068: IF sqlcode ='-12543' THEN
3069: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_TNS');
3070: FND_MESSAGE.SET_TOKEN('MSG_TEXT','TNS:destination host unreachable');
3071: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
3072: x_return_status := FND_API.G_RET_STS_ERROR;
3073: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

Line 3070: FND_MESSAGE.SET_TOKEN('MSG_TEXT','TNS:destination host unreachable');

3066: WHEN OTHERS THEN
3067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3068: IF sqlcode ='-12543' THEN
3069: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_TNS');
3070: FND_MESSAGE.SET_TOKEN('MSG_TEXT','TNS:destination host unreachable');
3071: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
3072: x_return_status := FND_API.G_RET_STS_ERROR;
3073: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
3074: IF x_msg_count > 1 THEN

Line 3085: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PASSWD');

3081: END IF;
3082: RETURN;
3083: ELSIF sqlcode ='-29106'
3084: THEN
3085: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PASSWD');
3086: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet password');
3087: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
3088: x_return_status := FND_API.G_RET_STS_ERROR;
3089: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

Line 3086: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet password');

3082: RETURN;
3083: ELSIF sqlcode ='-29106'
3084: THEN
3085: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PASSWD');
3086: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet password');
3087: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
3088: x_return_status := FND_API.G_RET_STS_ERROR;
3089: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
3090: IF x_msg_count > 1 THEN

Line 3101: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PATH');

3097: END IF;
3098: RETURN;
3099: ELSIF sqlcode ='-28759'
3100: THEN
3101: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PATH');
3102: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet path or its privileges');
3103: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
3104: x_return_status := FND_API.G_RET_STS_ERROR;
3105: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

Line 3102: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet path or its privileges');

3098: RETURN;
3099: ELSIF sqlcode ='-28759'
3100: THEN
3101: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_WALLET_PATH');
3102: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Please check oracle wallet path or its privileges');
3103: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);
3104: x_return_status := FND_API.G_RET_STS_ERROR;
3105: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
3106: IF x_msg_count > 1 THEN