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_CUSTOM_PUB dependencies on WSH_UTIL_CORE

Line 147: WSH_UTIL_CORE.printmsg('In the Others Exception of WSH_CUSTOM_PUB.ui_location_code');

143: EXCEPTION
144: WHEN others THEN
145: l_sqlcode := SQLCODE;
146: l_sqlerr := SQLERRM;
147: WSH_UTIL_CORE.printmsg('In the Others Exception of WSH_CUSTOM_PUB.ui_location_code');
148: WSH_UTIL_CORE.printmsg(l_sqlcode);
149: WSH_UTIL_CORE.printmsg(l_sqlerr);
150: ---Sample code end --
151: */

Line 148: WSH_UTIL_CORE.printmsg(l_sqlcode);

144: WHEN others THEN
145: l_sqlcode := SQLCODE;
146: l_sqlerr := SQLERRM;
147: WSH_UTIL_CORE.printmsg('In the Others Exception of WSH_CUSTOM_PUB.ui_location_code');
148: WSH_UTIL_CORE.printmsg(l_sqlcode);
149: WSH_UTIL_CORE.printmsg(l_sqlerr);
150: ---Sample code end --
151: */
152: END ui_location_code;

Line 149: WSH_UTIL_CORE.printmsg(l_sqlerr);

145: l_sqlcode := SQLCODE;
146: l_sqlerr := SQLERRM;
147: WSH_UTIL_CORE.printmsg('In the Others Exception of WSH_CUSTOM_PUB.ui_location_code');
148: WSH_UTIL_CORE.printmsg(l_sqlcode);
149: WSH_UTIL_CORE.printmsg(l_sqlerr);
150: ---Sample code end --
151: */
152: END ui_location_code;
153:

Line 412: p_line_id_tab IN WSH_UTIL_CORE.Id_Tab_Type,

408: -- with the order line_id and all the attributes can be overridden.
409: -- For Item Dimensions values to be sent as part of RIQ XML, the OTM Item Dimension UOM must be defined
410: -- and the Item Dimensions (Length, Width and Height) should all have valid values.
411: PROCEDURE Override_RIQ_XML_Attributes(
412: p_line_id_tab IN WSH_UTIL_CORE.Id_Tab_Type,
413: x_weight IN OUT NOCOPY NUMBER,
414: x_volume IN OUT NOCOPY NUMBER,
415: x_length IN OUT NOCOPY NUMBER,
416: x_height IN OUT NOCOPY NUMBER,

Line 448: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

444: */
445:
446: EXCEPTION
447: WHEN others THEN
448: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
449: END Override_RIQ_XML_Attributes;
450:
451: -- Bug 7131800
452: FUNCTION Cancel_Unpicked_Details_At_ITS(

Line 456: p_remain_details_id IN WSH_UTIL_CORE.Id_Tab_Type

452: FUNCTION Cancel_Unpicked_Details_At_ITS(
453: p_source_header_id IN NUMBER,
454: p_source_line_id IN NUMBER,
455: p_source_line_set_id IN NUMBER,
456: p_remain_details_id IN WSH_UTIL_CORE.Id_Tab_Type
457: ) RETURN VARCHAR2 IS
458: l_debug_on BOOLEAN;
459: l_cancel_flag VARCHAR2(1):= 'Y'; -- default Value is to Cancel (old Behaviour)
460: --

Line 591: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

587: WSH_DEBUG_SV.log(l_module_name, 'p_transaction_id', p_transaction_id);
588: END IF;
589: --
590:
591: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
592: SAVEPOINT Post_Process_Shipment_Request;
593:
594: -- { Section to be Modified by Customers
595:

Line 606: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

602: END IF;
603: --
604: EXCEPTION
605: WHEN OTHERS THEN
606: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
607: ROLLBACK TO Post_Process_Shipment_Request;
608: --
609: IF l_debug_on THEN
610: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1160: WSH_UTIL_CORE.Add_Message(FND_API.G_RET_STS_ERROR);

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

Line 1175: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
1179: x_msg_data := l_msg_summary || l_msg_details;

Line 1177: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
1179: x_msg_data := l_msg_summary || l_msg_details;
1180: ELSE
1181: x_msg_data := l_msg_summary;

Line 1189: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
1193: x_msg_data := l_msg_summary || l_msg_details;

Line 1191: wsh_util_core.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
1193: x_msg_data := l_msg_summary || l_msg_details;
1194: ELSE
1195: x_msg_data := l_msg_summary;

Line 1203: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
1207: x_msg_data := l_msg_summary || l_msg_details;

Line 1205: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
1207: x_msg_data := l_msg_summary || l_msg_details;
1208: ELSE
1209: x_msg_data := l_msg_summary;

Line 1223: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
1227: x_msg_data := l_msg_summary || l_msg_details;

Line 1225: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, l_msg_count);

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
1227: x_msg_data := l_msg_summary || l_msg_details;
1228: ELSE
1229: x_msg_data := l_msg_summary;

Line 1242: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
1246: x_msg_data := l_msg_summary || l_msg_details;

Line 1244: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
1246: x_msg_data := l_msg_summary || l_msg_details;
1247: ELSE
1248: x_msg_data := l_msg_summary;

Line 1258: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
1262: x_msg_data := l_msg_summary || l_msg_details;

Line 1260: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
1262: x_msg_data := l_msg_summary || l_msg_details;
1263: ELSE
1264: x_msg_data := l_msg_summary;

Line 1274: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
1278: x_msg_data := l_msg_summary || l_msg_details;

Line 1276: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
1278: x_msg_data := l_msg_summary || l_msg_details;
1279: ELSE
1280: x_msg_data := l_msg_summary;

Line 1942: WSH_UTIL_CORE.Add_Message(FND_API.G_RET_STS_ERROR);

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;
1946: x_output(l_index).AccessorySurcharge := NULL;

Line 1963: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
1967: x_msg_data := l_msg_summary || l_msg_details;

Line 1965: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
1967: x_msg_data := l_msg_summary || l_msg_details;
1968: ELSE
1969: x_msg_data := l_msg_summary;

Line 1977: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
1981: x_msg_data := l_msg_summary || l_msg_details;

Line 1979: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
1981: x_msg_data := l_msg_summary || l_msg_details;
1982: ELSE
1983: x_msg_data := l_msg_summary;

Line 1993: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
1997: x_msg_data := l_msg_summary || l_msg_details;

Line 1995: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
1997: x_msg_data := l_msg_summary || l_msg_details;
1998: ELSE
1999: x_msg_data := l_msg_summary;

Line 2009: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
2013: x_msg_data := l_msg_summary || l_msg_details;

Line 2011: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
2013: x_msg_data := l_msg_summary || l_msg_details;
2014: ELSE
2015: x_msg_data := l_msg_summary;

Line 2026: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
2030: x_msg_data := l_msg_summary || l_msg_details;

Line 2028: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
2030: x_msg_data := l_msg_summary || l_msg_details;
2031: ELSE
2032: x_msg_data := l_msg_summary;

Line 2043: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
2047: x_msg_data := l_msg_summary || l_msg_details;

Line 2045: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
2047: x_msg_data := l_msg_summary || l_msg_details;
2048: ELSE
2049: x_msg_data := l_msg_summary;

Line 2060: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
2064: x_msg_data := l_msg_summary || l_msg_details;

Line 2062: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
2064: x_msg_data := l_msg_summary || l_msg_details;
2065: else
2066: x_msg_data := l_msg_summary;

Line 2076: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
2080: x_msg_data := l_msg_summary || l_msg_details;

Line 2078: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
2080: x_msg_data := l_msg_summary || l_msg_details;
2081: ELSE
2082: x_msg_data := l_msg_summary;

Line 2099: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
2103: x_msg_data := l_msg_summary || l_msg_details;

Line 2101: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
2103: x_msg_data := l_msg_summary || l_msg_details;
2104: ELSE
2105: x_msg_data := l_msg_summary;

Line 2115: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
2119: x_msg_data := l_msg_summary || l_msg_details;

Line 2117: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
2119: x_msg_data := l_msg_summary || l_msg_details;
2120: ELSE
2121: x_msg_data := l_msg_summary;

Line 2131: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
2135: x_msg_data := l_msg_summary || l_msg_details;

Line 2133: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
2135: x_msg_data := l_msg_summary || l_msg_details;
2136: ELSE
2137: x_msg_data := l_msg_summary;

Line 2535: WSH_UTIL_CORE.Add_Message(FND_API.G_RET_STS_ERROR);

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
2539: WSH_DEBUG_SV.log(l_module_name,'Count x_activity_detail:'||x_activity_detail.count);

Line 2553: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
2557: x_msg_data := l_msg_summary || l_msg_details;

Line 2555: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
2557: x_msg_data := l_msg_summary || l_msg_details;
2558: ELSE
2559: x_msg_data := l_msg_summary;

Line 2567: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
2571: x_msg_data := l_msg_summary || l_msg_details;

Line 2569: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
2571: x_msg_data := l_msg_summary || l_msg_details;
2572: ELSE
2573: x_msg_data := l_msg_summary;

Line 2587: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
2591: x_msg_data := l_msg_summary || l_msg_details;

Line 2589: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
2591: x_msg_data := l_msg_summary || l_msg_details;
2592: ELSE
2593: x_msg_data := l_msg_summary;

Line 2609: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
2613: x_msg_data := l_msg_summary || l_msg_details;

Line 2611: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
2613: x_msg_data := l_msg_summary || l_msg_details;
2614: ELSE
2615: x_msg_data := l_msg_summary;

Line 2625: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
2629: x_msg_data := l_msg_summary || l_msg_details;

Line 2627: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
2629: x_msg_data := l_msg_summary || l_msg_details;
2630: ELSE
2631: x_msg_data := l_msg_summary;

Line 2641: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
2645: x_msg_data := l_msg_summary || l_msg_details;

Line 2643: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
2645: x_msg_data := l_msg_summary || l_msg_details;
2646: ELSE
2647: x_msg_data := l_msg_summary;

Line 2660: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
2663: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'trk_shipment_services');
2664: END IF;

Line 3012: WSH_UTIL_CORE.Add_Message(FND_API.G_RET_STS_ERROR);

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:
3016: IF l_debug_on THEN

Line 3035: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
3039: x_msg_data := l_msg_summary || l_msg_details;

Line 3037: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
3039: x_msg_data := l_msg_summary || l_msg_details;
3040: ELSE
3041: x_msg_data := l_msg_summary;

Line 3049: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
3053: x_msg_data := l_msg_summary || l_msg_details;

Line 3051: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
3053: x_msg_data := l_msg_summary || l_msg_details;
3054: ELSE
3055: x_msg_data := l_msg_summary;

Line 3071: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
3075: x_msg_data := l_msg_summary || l_msg_details;

Line 3073: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
3075: x_msg_data := l_msg_summary || l_msg_details;
3076: ELSE
3077: x_msg_data := l_msg_summary;

Line 3087: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
3091: x_msg_data := l_msg_summary || l_msg_details;

Line 3089: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
3091: x_msg_data := l_msg_summary || l_msg_details;
3092: ELSE
3093: x_msg_data := l_msg_summary;

Line 3103: WSH_UTIL_CORE.ADD_MESSAGE(FND_API.G_RET_STS_ERROR,l_module_name);

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
3107: x_msg_data := l_msg_summary || l_msg_details;

Line 3105: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);

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
3107: x_msg_data := l_msg_summary || l_msg_details;
3108: ELSE
3109: x_msg_data := l_msg_summary;