APPS.WSH_INBOUND_SHIP_REQUEST_PKG dependencies on WSH_UTIL_CORE

Line 63: IF(X_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

59: IF l_debug_on THEN
60: wsh_debug_sv.log (l_module_name,'X_Delivery_ID,X_Return_Status', X_Delivery_ID||','||X_Return_Status);
61: END IF;
62:
63: IF(X_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
64: Raise Delivery_Int_Wrapper_Failed;
65: END IF;
66:
67: EXCEPTION

Line 88: IF(X_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

84: IF l_debug_on THEN
85: wsh_debug_sv.log (l_module_name,'X_Return_Status',X_Return_Status);
86: END IF;
87:
88: IF(X_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
89: raise Check_Cancel_Allowed_WF_Failed;
90: END IF;
91:
92: EXCEPTION

Line 113: X_Return_Status := WSH_UTIL_CORE.G_RET_STS_ERROR;

109: WHEN Check_Cancel_Allowed_WF_Failed THEN
110: -- Added the following statement to fix Bug # 2342710.
111: ROLLBACK TO SAVEPOINT Before_Check_Cancel_Allowed_WF;
112: -- End of Changes for Bug # 2342710.
113: X_Return_Status := WSH_UTIL_CORE.G_RET_STS_ERROR;
114:
115: IF l_debug_on THEN
116: WSH_DEBUG_SV.logmsg(l_module_name,'Check_Cancel_Allowed_WF_Failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
117: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:check_Cancel_Allowed_WF_Failed');

Line 124: X_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

120: WHEN before_Check_Cancel_WF_others THEN
121: -- Added the following statement to fix Bug # 2342710.
122: ROLLBACK TO SAVEPOINT Before_Check_Cancel_Allowed_WF;
123: -- End of Changes for Bug # 2342710.
124: X_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
125:
126: IF l_debug_on THEN
127: WSH_DEBUG_SV.logmsg(l_module_name,'before_Check_Cancel_WF_others exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
128: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:before_Check_Cancel_WF_others');

Line 135: X_Return_Status := WSH_UTIL_CORE.G_RET_STS_ERROR;

131: WHEN Delivery_Int_Wrapper_Failed THEN
132: -- Added the following statement to fix Bug # 2342710.
133: ROLLBACK TO SAVEPOINT Before_Populating_Base_Tables;
134: -- End of Changes for Bug # 2342710.
135: X_Return_Status := WSH_UTIL_CORE.G_RET_STS_ERROR;
136:
137: IF l_debug_on THEN
138: WSH_DEBUG_SV.logmsg(l_module_name,'Delivery_Int_Wrapper_Failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
139: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Delivery_Int_Wrapper_Failed');

Line 146: X_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

142: WHEN Before_Populating_BT_Others THEN
143: -- Added the following statement to fix Bug # 2342710.
144: ROLLBACK TO SAVEPOINT Before_Populating_Base_Tables;
145: -- End of Changes for Bug # 2342710.
146: X_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
147:
148: IF l_debug_on THEN
149: WSH_DEBUG_SV.logmsg(l_module_name,'Before_Populating_BT_Others exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
150: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Before_Populating_BT_Others');

Line 154: X_Return_Status := WSH_UTIL_CORE.G_RET_STS_ERROR;

150: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:Before_Populating_BT_Others');
151: END IF;
152:
153: WHEN INVALID_INTERFACE_ID THEN
154: X_Return_Status := WSH_UTIL_CORE.G_RET_STS_ERROR;
155: IF l_debug_on THEN
156: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_INTERFACE_ID exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
157: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_INTERFACE_ID');
158: END IF;

Line 161: X_Return_Status := WSH_UTIL_CORE.G_RET_STS_ERROR;

157: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_INTERFACE_ID');
158: END IF;
159:
160: WHEN INVALID_ACTION_TYPE THEN
161: X_Return_Status := WSH_UTIL_CORE.G_RET_STS_ERROR;
162: IF l_debug_on THEN
163: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_ACTION_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
164: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_ACTION_TYPE');
165: END IF;

Line 168: X_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

164: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_ACTION_TYPE');
165: END IF;
166:
167: WHEN OTHERS THEN
168: X_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
169: IF l_debug_on THEN
170: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
171: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
172: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');