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

Line 97: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

93: WSH_DEBUG_SV.log(l_module_name,'Attribute15',
94: p_Carrier_Ship_Method_Info.attribute15);
95: END IF;
96: --
97: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
98: IF (X_Carrier_ship_method_id is NULL) THEN
99: OPEN C_Next_id;
100: FETCH C_Next_id INTO X_Carrier_Ship_Method_Id;
101: IF l_debug_on THEN

Line 192: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

188: END IF;
189: --
190: EXCEPTION
191: WHEN others THEN
192: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
193: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Update_Carrier_Ship_Method', l_module_name);
194: --
195: IF l_debug_on THEN
196: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 193: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Update_Carrier_Ship_Method', l_module_name);

189: --
190: EXCEPTION
191: WHEN others THEN
192: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
193: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Update_Carrier_Ship_Method', l_module_name);
194: --
195: IF l_debug_on THEN
196: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
197: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 284: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

280: WSH_DEBUG_SV.log(l_module_name,'Attribute15',
281: p_Carrier_Ship_Method_Info.attribute15);
282: END IF;
283: --
284: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
285:
286: OPEN C_lock_row;
287: FETCH C_lock_row INTO Recinfo;
288:

Line 292: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

288:
289: IF (C_lock_row%NOTFOUND) THEN
290: CLOSE C_lock_row;
291: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
292: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
293: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
294: --
295: IF l_debug_on THEN
296: WSH_DEBUG_SV.log(l_module_name,'C_lock_row%NOTFOUND');

Line 293: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

289: IF (C_lock_row%NOTFOUND) THEN
290: CLOSE C_lock_row;
291: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
292: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
293: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
294: --
295: IF l_debug_on THEN
296: WSH_DEBUG_SV.log(l_module_name,'C_lock_row%NOTFOUND');
297: WSH_DEBUG_SV.pop(l_module_name);

Line 417: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

413: END IF;
414: --
415: EXCEPTION
416: WHEN others THEN
417: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
418: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Lock_Carrier_Ship_Method',l_module_name);
419: --
420: IF l_debug_on THEN
421: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 418: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Lock_Carrier_Ship_Method',l_module_name);

414: --
415: EXCEPTION
416: WHEN others THEN
417: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
418: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Lock_Carrier_Ship_Method',l_module_name);
419: --
420: IF l_debug_on THEN
421: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
422: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 501: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

497: WSH_DEBUG_SV.log(l_module_name,'Attribute15',
498: p_Carrier_Ship_Method_Info.attribute15);
499: END IF;
500: --
501: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
502: UPDATE wsh_carrier_ship_methods
503: SET
504: carrier_id = p_Carrier_Ship_Method_Info.Carrier_id,
505: ship_method_code = p_Carrier_Ship_Method_Info.Ship_Method_Code,

Line 539: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

535: WSH_DEBUG_SV.log(l_module_name,'SQL%NOTFOUND');
536: END IF;
537: --
538: RAISE NO_DATA_FOUND;
539: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
540: END IF;
541: --
542: IF l_debug_on THEN
543: WSH_DEBUG_SV.pop(l_module_name);

Line 549: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

545: --
546: EXCEPTION
547: WHEN NO_DATA_FOUND THEN
548: FND_MESSAGE.Set_Name('WSH', 'WSH_CSM_NOT_FOUND');
549: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
550: WSH_UTIL_CORE.Add_Message(x_return_status,
551: l_module_name);
552: --
553: IF l_debug_on THEN

Line 550: WSH_UTIL_CORE.Add_Message(x_return_status,

546: EXCEPTION
547: WHEN NO_DATA_FOUND THEN
548: FND_MESSAGE.Set_Name('WSH', 'WSH_CSM_NOT_FOUND');
549: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
550: WSH_UTIL_CORE.Add_Message(x_return_status,
551: l_module_name);
552: --
553: IF l_debug_on THEN
554: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 559: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Update_Carrier_Ship_Method', l_module_name);

555: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
556: END IF;
557: --
558: WHEN others THEN
559: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Update_Carrier_Ship_Method', l_module_name);
560: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
561: --
562: IF l_debug_on THEN
563: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 560: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

556: END IF;
557: --
558: WHEN others THEN
559: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Update_Carrier_Ship_Method', l_module_name);
560: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
561: --
562: IF l_debug_on THEN
563: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
564: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 607: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

603: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
604: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_SHIP_METHOD_ID',P_CARRIER_SHIP_METHOD_ID);
605: END IF;
606: --
607: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
608: IF (p_rowid IS NOT NULL) THEN
609: OPEN C_CSM_id;
610: FETCH C_CSM_id INTO l_csm_id;
611: CLOSE C_CSM_ID;

Line 623: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

619:
620: IF (p_Carrier_Ship_Method_id IS NOT NULL) THEN
621: DELETE FROM wsh_carrier_ship_methods
622: WHERE carrier_ship_method_id = l_csm_id;
623: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
624: ELSE
625: RAISE others;
626: END IF;
627:

Line 634: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Delete_Carrier_Ship_Method',l_module_name);

630: END IF;
631: --
632: EXCEPTION
633: WHEN others THEN
634: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Delete_Carrier_Ship_Method',l_module_name);
635: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
636: --
637: IF l_debug_on THEN
638: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 635: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

631: --
632: EXCEPTION
633: WHEN others THEN
634: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Delete_Carrier_Ship_Method',l_module_name);
635: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
636: --
637: IF l_debug_on THEN
638: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
639: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');