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

Line 179: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

175: IF l_debug_on THEN
176: WSH_DEBUG_SV.push(l_module_name);
177: WSH_DEBUG_SV.log(l_module_name,'DELIVERY ID',p_delivery_id);
178: END IF;
179: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
180:
181: OPEN cur_delivery;
182: FETCH cur_delivery BULK COLLECT INTO del_tab;
183: CLOSE cur_delivery;

Line 1020: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1016: IF l_debug_on THEN
1017: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1018: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');
1019: END IF;
1020: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1021: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA',l_module_name);
1022: l_msg_data := SQLERRM ||' at WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA';
1023: x_msg_data := l_msg_data;
1024: END;

Line 1021: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA',l_module_name);

1017: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1018: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');
1019: END IF;
1020: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1021: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA',l_module_name);
1022: l_msg_data := SQLERRM ||' at WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA';
1023: x_msg_data := l_msg_data;
1024: END;
1025: END LOOP;

Line 1072: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1068: IF l_debug_on THEN
1069: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1070: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');
1071: END IF;
1072: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1073: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA',l_module_name);
1074: l_msg_data := SQLERRM ||' at WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA';
1075: x_msg_data := l_msg_data;
1076: END get_asn_data;

Line 1073: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA',l_module_name);

1069: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1070: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');
1071: END IF;
1072: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1073: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA',l_module_name);
1074: l_msg_data := SQLERRM ||' at WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA';
1075: x_msg_data := l_msg_data;
1076: END get_asn_data;
1077:

Line 1246: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1242: IF l_debug_on THEN
1243: WSH_DEBUG_SV.push(l_module_name);
1244: WSH_DEBUG_SV.log(l_module_name,'DELIVERY ID',p_delivery_id);
1245: END IF;
1246: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1247:
1248: OPEN cur_delivery;
1249: FETCH cur_delivery BULK COLLECT INTO del_tab;
1250: CLOSE cur_delivery;

Line 2083: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2079: IF l_debug_on THEN
2080: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2081: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');
2082: END IF;
2083: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2084: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA',l_module_name);
2085: l_msg_data := SQLERRM ||' at WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA';
2086: x_msg_data := l_msg_data;
2087: END;

Line 2084: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA',l_module_name);

2080: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2081: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');
2082: END IF;
2083: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2084: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA',l_module_name);
2085: l_msg_data := SQLERRM ||' at WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA';
2086: x_msg_data := l_msg_data;
2087: END;
2088: END LOOP;

Line 2135: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2131: IF l_debug_on THEN
2132: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2133: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');
2134: END IF;
2135: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2136: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA',l_module_name);
2137: l_msg_data := SQLERRM ||' at WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA';
2138: x_msg_data := l_msg_data;
2139: END get_asn_data;

Line 2136: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA',l_module_name);

2132: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2133: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');
2134: END IF;
2135: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2136: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA',l_module_name);
2137: l_msg_data := SQLERRM ||' at WSH_OPSM_ASN_BE_PKG.GET_ASN_DATA';
2138: x_msg_data := l_msg_data;
2139: END get_asn_data;
2140:

Line 2180: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2176: IF l_debug_on THEN
2177: WSH_DEBUG_SV.push(l_module_name);
2178: WSH_DEBUG_SV.log(l_module_name,'DELIVERY ID',p_delivery_id);
2179: END IF;
2180: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2181: FOR v_opsm_items IN c_opsm_items LOOP
2182: --To check wheather Item is OPSM Integrated or not
2183: BEGIN
2184: SELECT 1

Line 2245: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2241: WSH_DEBUG_SV.log(l_module_name,'OPSM INTEGRATED EXIST',p_opsmexist);
2242: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2243: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');
2244: END IF;
2245: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2246: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.SUBMIT_REQUEST',l_module_name);
2247: l_msg_data := SQLERRM ||' at WSH_OPSM_ASN_BE_PKG.SUBMIT_REQUEST';
2248: x_msg_data := l_msg_data;
2249:

Line 2246: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.SUBMIT_REQUEST',l_module_name);

2242: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| substr(SQLERRM,1,200),WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2243: WSH_DEBUG_SV.pop(l_module_name,'WHEN OTHERS');
2244: END IF;
2245: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2246: wsh_util_core.default_handler('WSH_OPSM_ASN_BE_PKG.SUBMIT_REQUEST',l_module_name);
2247: l_msg_data := SQLERRM ||' at WSH_OPSM_ASN_BE_PKG.SUBMIT_REQUEST';
2248: x_msg_data := l_msg_data;
2249:
2250: END submit_request;