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_UTIL_VALIDATE dependencies on WSH_UTIL_VALIDATE

Line 1: PACKAGE BODY WSH_UTIL_VALIDATE as

1: PACKAGE BODY WSH_UTIL_VALIDATE as
2: /* $Header: WSHUTVLB.pls 120.8.12000000.5 2007/02/22 20:04:10 somanaam ship $ */
3: --===================
4: -- PROCEDURES
5: --===================

Line 8: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_UTIL_VALIDATE';

4: -- PROCEDURES
5: --===================
6:
7: --
8: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_UTIL_VALIDATE';
9: G_ITEM_INFO_TAB Item_Info_Tab_Type;
10: G_DEF_CONT_INF_TAB cont_def_info_tab_type;
11: G_DEF_CONT_INFO_EXT_TAB cont_def_info_tab_type;
12: G_IGNORE_PLAN_TAB ignore_plan_tab_type;

Line 251: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_ORG');

247: --
248: EXCEPTION
249: WHEN OTHERS THEN
250: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
251: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_ORG');
252: IF check_org_id%ISOPEN THEN
253: CLOSE check_org_id;
254: END IF;
255: IF check_org_code%ISOPEN THEN

Line 484: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_LOCATION');

480: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION G_EXC_UNEXPECTED_ERROR');
481: END IF;
482: WHEN OTHERS THEN
483: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
484: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_LOCATION');
485: --
486: IF l_debug_on THEN
487: WSH_DEBUG_SV.log(l_module_name,'ERROR:',SUBSTR(SQLERRM,1,200));
488: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1069: WSH_UTIL_CORE.default_handler('WSH_UTIL_VALIDATE.Validate_Currency');

1065: IF currency_cursor%ISOPEN THEN
1066: CLOSE currency_cursor;
1067: END IF;
1068: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1069: WSH_UTIL_CORE.default_handler('WSH_UTIL_VALIDATE.Validate_Currency');
1070: IF l_debug_on THEN
1071: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1072: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1073: END IF;

Line 1479: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Ship_Method');

1475: --
1476: EXCEPTION
1477: WHEN OTHERS THEN
1478: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1479: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Ship_Method');
1480: IF l_debug_on THEN
1481: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1482: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1483: END IF;

Line 2292: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_LOADING_ORDER');

2288: --
2289: EXCEPTION
2290: WHEN OTHERS THEN
2291: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2292: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_LOADING_ORDER');
2293: --
2294: IF l_debug_on THEN
2295: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2296: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2745: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.validate_from_to_dates');

2741:
2742: EXCEPTION
2743: WHEN OTHERS THEN
2744: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2745: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.validate_from_to_dates');
2746: IF l_debug_on THEN
2747: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2748: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2749: END IF;

Line 2833: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.validate_trip_status');

2829:
2830: EXCEPTION
2831: WHEN OTHERS THEN
2832: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2833: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.validate_trip_status');
2834: IF l_debug_on THEN
2835: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2836: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2837: END IF;

Line 2920: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_CARRIER');

2916: WHEN OTHERS THEN
2917: --
2918: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2919: --
2920: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_CARRIER');
2921: IF l_debug_on THEN
2922: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2923: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2924: END IF;

Line 3573: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_FREIGHT_CARRIER');

3569: --
3570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3571: --
3572: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3573: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_FREIGHT_CARRIER');
3574: IF l_debug_on THEN
3575: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3576: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3577: END IF;

Line 3590: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_FREIGHT_CARRIER');

3586: END IF;
3587: --
3588: WHEN OTHERS THEN
3589: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3590: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_FREIGHT_CARRIER');
3591: --
3592: IF l_debug_on THEN
3593: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3594: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3662: l_wms_org := wsh_util_validate.Check_Wms_Org(p_organization_id);

3658: RAISE FND_API.G_EXC_ERROR;
3659: END IF;
3660: CLOSE veh_cont_item_cur;
3661:
3662: l_wms_org := wsh_util_validate.Check_Wms_Org(p_organization_id);
3663:
3664: IF l_debug_on THEN
3665: WSH_DEBUG_SV.log(l_module_name,'l_wms_org',l_wms_org);
3666: END IF;

Line 3701: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.FIND_ITEM_TYPE');

3697: END IF;
3698:
3699: WHEN OTHERS THEN
3700: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3701: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.FIND_ITEM_TYPE');
3702: --
3703: IF l_debug_on THEN
3704: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3705: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3758: l_wms_installed := wsh_util_validate.Check_Wms_Org(p_organization_id);

3754: ELSIF l_return_status = wsh_util_core.g_ret_sts_unexp_error THEN
3755: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3756: END IF;
3757:
3758: l_wms_installed := wsh_util_validate.Check_Wms_Org(p_organization_id);
3759:
3760: IF l_wms_installed = 'Y' THEN
3761: l_org_type_wms := 'WMS';
3762: END IF;

Line 3812: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.GET_ORG_TYPE');

3808: RETURN l_org_type;
3809: --
3810: WHEN OTHERS THEN
3811: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3812: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.GET_ORG_TYPE');
3813: --
3814: IF l_debug_on THEN
3815: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3816: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4415: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.VALIDATE_FOB',l_module_name);

4411: --
4412: EXCEPTION
4413: WHEN OTHERS THEN
4414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4415: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.VALIDATE_FOB',l_module_name);
4416: --
4417: -- Debug Statements
4418: --
4419: IF l_debug_on THEN

Line 4561: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.VALIDATE_FREIGHT_TERMS',l_module_name);

4557: --
4558: EXCEPTION
4559: WHEN OTHERS THEN
4560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4561: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.VALIDATE_FREIGHT_TERMS',l_module_name);
4562: --
4563: -- Debug Statements
4564: --
4565: IF l_debug_on THEN

Line 4707: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.validate_supplier_location', l_module_name);

4703: --
4704: WHEN OTHERS THEN
4705:
4706: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4707: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.validate_supplier_location', l_module_name);
4708: IF l_debug_on THEN
4709: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4710: END IF;
4711: --

Line 5112: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Active_SM');

5108: --
5109: EXCEPTION
5110: WHEN OTHERS THEN
5111: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5112: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Active_SM');
5113: IF l_debug_on THEN
5114: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5115: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5116: END IF;

Line 5262: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Lookup_Upper');

5258: --
5259: WHEN OTHERS THEN
5260: --
5261: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5262: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Lookup_Upper');
5263: --
5264: IF l_debug_on THEN
5265: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5266: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5341: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.ValidateActualDepartureDate');

5337: --
5338: WHEN OTHERS THEN
5339: --
5340: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5341: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.ValidateActualDepartureDate');
5342: --
5343: IF l_debug_on THEN
5344: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle
5345: error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 5352: END WSH_UTIL_VALIDATE;

5348: --
5349: END ValidateActualDepartureDate;
5350:
5351:
5352: END WSH_UTIL_VALIDATE;