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

Line 595: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

591: WSH_DEBUG_SV.log(l_module_name,'P_Carrier_info.DIM_MIN_PACK_VOL',P_Carrier_info.DIM_MIN_PACK_VOL);
592: -- R12 Code changes
593: END IF;
594: --
595: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
596: x_return_status := l_return_status;
597: -- Initialize Messages.
598: fnd_msg_pub.initialize();
599:

Line 636: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

632: x_msg_count => l_msg_count,
633: x_msg_data => l_msg_data
634: );
635:
636: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
637: x_return_status := l_return_status;
638: RAISE HZ_FAIL_EXCEPTION;
639: END IF;
640: -- Party Usage

Line 675: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

671: x_msg_count => l_msg_count,
672: x_msg_data=>l_msg_data);
673:
674: END IF;
675: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
676: x_return_status := l_return_status;
677: RAISE HZ_FAIL_EXCEPTION;
678: END IF;
679: END IF;

Line 751: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

747: ORIGIN_DSTN_SURCHARGE_LEVEL = P_Carrier_info.ORIGIN_DSTN_SURCHARGE_LEVEL
748: WHERE carrier_id = P_Carrier_info.CARRIER_ID;
749:
750: IF SQL%NOTFOUND THEN
751: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
752: RAISE OTHERS;
753: END IF;
754:
755: --Inserted hint for performance bug 3639958

Line 798: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

794: EXCEPTION
795:
796: WHEN NO_DATA_FOUND THEN
797: x_exception_msg := 'Exception: No Data Found';
798: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
799: x_procedure := l_call_procedure;
800: x_position := l_position;
801: x_sqlerr := sqlerrm;
802: x_sql_code := sqlcode;

Line 835: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

831: x_procedure := l_call_procedure;
832: x_position := l_position;
833: x_sqlerr := sqlerrm;
834: x_sql_code := sqlcode;
835: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
836:
837: --
838: -- Debug Statements
839: --

Line 953: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

949: -- R12 Code changes
950: END IF;
951: --
952:
953: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
954:
955: OPEN C_lock_row;
956: FETCH C_lock_row INTO Recinfo;
957:

Line 961: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

957:
958: IF (C_lock_row%NOTFOUND) THEN
959: CLOSE C_lock_row;
960: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
961: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
962: WSH_UTIL_CORE.Add_Message(x_return_status);
963: RETURN;
964: END IF;
965:

Line 962: WSH_UTIL_CORE.Add_Message(x_return_status);

958: IF (C_lock_row%NOTFOUND) THEN
959: CLOSE C_lock_row;
960: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
961: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
962: WSH_UTIL_CORE.Add_Message(x_return_status);
963: RETURN;
964: END IF;
965:
966: CLOSE C_lock_row;

Line 1187: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1183: END IF;
1184: IF (get_carrier_details%ISOPEN) then
1185: CLOSE get_carrier_details;
1186: END IF;
1187: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1188: WSH_UTIL_CORE.Default_Handler('WSH_CREATE_CARRIERS_PKG.Lock_Carrier');
1189:
1190: --
1191: -- Debug Statements

Line 1188: WSH_UTIL_CORE.Default_Handler('WSH_CREATE_CARRIERS_PKG.Lock_Carrier');

1184: IF (get_carrier_details%ISOPEN) then
1185: CLOSE get_carrier_details;
1186: END IF;
1187: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1188: WSH_UTIL_CORE.Default_Handler('WSH_CREATE_CARRIERS_PKG.Lock_Carrier');
1189:
1190: --
1191: -- Debug Statements
1192: --

Line 1428: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1424:
1425: END IF;
1426: --
1427:
1428: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1429:
1430: OPEN Get_Site_Details;
1431: FETCH Get_Site_Details INTO
1432: x_site_trans_rec.carrier_id,

Line 1447: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1443: x_site_trans_rec.TENDER_TRANSMISSION_METHOD;
1444: CLOSE Get_Site_Details;
1445:
1446: IF x_site_trans_rec.carrier_id IS NULL THEN
1447: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1448: END IF;
1449:
1450: --
1451: -- Debug Statements

Line 1462: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1458: EXCEPTION
1459:
1460: WHEN OTHERS THEN
1461:
1462: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1463:
1464: --
1465: -- Debug Statements
1466: --

Line 1575: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1571: IF l_debug_on THEN
1572: WSH_DEBUG_SV.push(l_module_name);
1573: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_ID',p_carrier_id);
1574: END IF;
1575: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1576:
1577: -- Deactivation of Carrier Services
1578:
1579: OPEN C_get_freight_code(p_carrier_id);

Line 1618: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1614: x_sqlerr => l_sqlerr,
1615: x_sql_code => l_sql_code
1616: );
1617:
1618: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1619: x_return_status := l_return_status;
1620: RAISE UNASSIGNALL_FAIL_EXCEPTION;
1621: END IF;
1622:

Line 1632: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1628:
1629: IF (C_lookup_row%NOTFOUND) THEN
1630: CLOSE C_lookup_row;
1631: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
1632: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1633: IF l_debug_on THEN
1634: WSH_DEBUG_SV.log(l_module_name,'C_lookup_row%NOTFOUND');
1635: END IF;
1636: RAISE NO_DATA_FOUND;

Line 1728: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1724: x_msg_count => l_msg_count,
1725: x_msg_data => l_msg_data
1726: );
1727:
1728: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1729: x_return_status := l_return_status;
1730: RAISE HZ_FAIL_EXCEPTION;
1731: END IF;
1732: FETCH C_get_carrier_sites INTO l_carrier_site_id;

Line 1757: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1753: x_position := l_position;
1754: x_procedure := l_procedure;
1755: x_sqlerr := sqlerrm;
1756: x_sql_code := sqlcode;
1757: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1758: IF l_debug_on THEN
1759: WSH_DEBUG_SV.logmsg(l_module_name,'UNASSIGNALL_FAIL_EXCEPTION error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1760: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UNASSIGNALL_FAIL_EXCEPTION');
1761: END IF;

Line 1769: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1765: x_position := l_position;
1766: x_procedure := l_procedure;
1767: x_sqlerr := sqlerrm;
1768: x_sql_code := sqlcode;
1769: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1770: IF l_debug_on THEN
1771: WSH_DEBUG_SV.logmsg(l_module_name,'HZ_FAIL_EXCEPTION error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1772: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:HZ_FAIL_EXCEPTION');
1773: END IF;

Line 1781: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1777: x_position := l_position;
1778: x_procedure := l_procedure;
1779: x_sqlerr := sqlerrm;
1780: x_sql_code := sqlcode;
1781: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1782: --
1783: IF l_debug_on THEN
1784: WSH_DEBUG_SV.logmsg(l_module_name,' No Data Found Exception occurred. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1785: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');

Line 1794: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1790: x_position := l_position;
1791: x_procedure := l_procedure;
1792: x_sqlerr := sqlerrm;
1793: x_sql_code := sqlcode;
1794: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1795: --
1796: IF l_debug_on THEN
1797: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1798: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');