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.16 2011/01/27 00:56:25 rvarghes 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 273: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_ORG');

269: --
270: EXCEPTION
271: WHEN OTHERS THEN
272: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
273: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_ORG');
274: IF check_org_id%ISOPEN THEN
275: CLOSE check_org_id;
276: END IF;
277: IF check_org_code%ISOPEN THEN

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

502: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION G_EXC_UNEXPECTED_ERROR');
503: END IF;
504: WHEN OTHERS THEN
505: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
506: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_LOCATION');
507: --
508: IF l_debug_on THEN
509: WSH_DEBUG_SV.log(l_module_name,'ERROR:',SUBSTR(SQLERRM,1,200));
510: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

1087: IF currency_cursor%ISOPEN THEN
1088: CLOSE currency_cursor;
1089: END IF;
1090: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1091: WSH_UTIL_CORE.default_handler('WSH_UTIL_VALIDATE.Validate_Currency');
1092: IF l_debug_on THEN
1093: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1094: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1095: END IF;

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

1497: --
1498: EXCEPTION
1499: WHEN OTHERS THEN
1500: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1501: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Ship_Method');
1502: IF l_debug_on THEN
1503: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1504: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1505: END IF;

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

2310: --
2311: EXCEPTION
2312: WHEN OTHERS THEN
2313: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2314: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_LOADING_ORDER');
2315: --
2316: IF l_debug_on THEN
2317: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2318: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

2763:
2764: EXCEPTION
2765: WHEN OTHERS THEN
2766: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2767: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.validate_from_to_dates');
2768: IF l_debug_on THEN
2769: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2770: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2771: END IF;

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

2851:
2852: EXCEPTION
2853: WHEN OTHERS THEN
2854: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2855: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.validate_trip_status');
2856: IF l_debug_on THEN
2857: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2858: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2859: END IF;

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

2938: WHEN OTHERS THEN
2939: --
2940: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2941: --
2942: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_CARRIER');
2943: IF l_debug_on THEN
2944: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2945: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2946: END IF;

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

3607: --
3608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3609: --
3610: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3611: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_FREIGHT_CARRIER');
3612: IF l_debug_on THEN
3613: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3614: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3615: END IF;

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

3624: END IF;
3625: --
3626: WHEN OTHERS THEN
3627: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3628: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.VALIDATE_FREIGHT_CARRIER');
3629: --
3630: IF l_debug_on THEN
3631: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3632: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

3696: RAISE FND_API.G_EXC_ERROR;
3697: END IF;
3698: CLOSE veh_cont_item_cur;
3699:
3700: l_wms_org := wsh_util_validate.Check_Wms_Org(p_organization_id);
3701:
3702: IF l_debug_on THEN
3703: WSH_DEBUG_SV.log(l_module_name,'l_wms_org',l_wms_org);
3704: END IF;

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

3735: END IF;
3736:
3737: WHEN OTHERS THEN
3738: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3739: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.FIND_ITEM_TYPE');
3740: --
3741: IF l_debug_on THEN
3742: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3743: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

3792: ELSIF l_return_status = wsh_util_core.g_ret_sts_unexp_error THEN
3793: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3794: END IF;
3795:
3796: l_wms_installed := wsh_util_validate.Check_Wms_Org(p_organization_id);
3797:
3798: IF l_wms_installed = 'Y' THEN
3799: l_org_type_wms := 'WMS';
3800: END IF;

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

3846: RETURN l_org_type;
3847: --
3848: WHEN OTHERS THEN
3849: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3850: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.GET_ORG_TYPE');
3851: --
3852: IF l_debug_on THEN
3853: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3854: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

4455: --
4456: EXCEPTION
4457: WHEN OTHERS THEN
4458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4459: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.VALIDATE_FOB',l_module_name);
4460: --
4461: -- Debug Statements
4462: --
4463: IF l_debug_on THEN

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

4601: --
4602: EXCEPTION
4603: WHEN OTHERS THEN
4604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4605: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.VALIDATE_FREIGHT_TERMS',l_module_name);
4606: --
4607: -- Debug Statements
4608: --
4609: IF l_debug_on THEN

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

4747: --
4748: WHEN OTHERS THEN
4749:
4750: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4751: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.validate_supplier_location', l_module_name);
4752: IF l_debug_on THEN
4753: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4754: END IF;
4755: --

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

5152: --
5153: EXCEPTION
5154: WHEN OTHERS THEN
5155: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5156: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Active_SM');
5157: IF l_debug_on THEN
5158: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5159: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5160: END IF;

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

5302: --
5303: WHEN OTHERS THEN
5304: --
5305: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5306: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Lookup_Upper');
5307: --
5308: IF l_debug_on THEN
5309: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5310: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

5381: --
5382: WHEN OTHERS THEN
5383: --
5384: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5385: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.ValidateActualDepartureDate');
5386: --
5387: IF l_debug_on THEN
5388: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle
5389: error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 5453: WSH_UTIL_VALIDATE.Check_Wms_Org (

5449: IF l_index is not null THEN
5450: IF l_flag = 'U' THEN --Not Found in Cache, so use this index to add in Cache
5451: g_sr_org_tab(l_index).input_param1 := p_organization_id;
5452: g_sr_org_tab(l_index).output_param1 :=
5453: WSH_UTIL_VALIDATE.Check_Wms_Org (
5454: p_organization_id => p_organization_id );
5455:
5456: IF INV_GMI_RSV_BRANCH.PROCESS_BRANCH(p_organization_id) THEN
5457: g_sr_org_tab(l_index).output_param2 := 'Y' ;

Line 5505: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.Validate_SR_Organization');

5501: --
5502: EXCEPTION
5503: WHEN OTHERS THEN
5504: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5505: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.Validate_SR_Organization');
5506: --
5507: IF l_debug_on THEN
5508: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5621: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.Validate_Locator_Code');

5617: --
5618: EXCEPTION
5619: WHEN OTHERS THEN
5620: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5621: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.Validate_Locator_Code');
5622: --
5623: IF l_debug_on THEN
5624: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5625: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5745: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.Validate_Item');

5741: --
5742: EXCEPTION
5743: WHEN OTHERS THEN
5744: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5745: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.Validate_Item');
5746: --
5747: IF l_debug_on THEN
5748: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5749: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5886: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.Validate_Customer_Item');

5882: --
5883: EXCEPTION
5884: WHEN OTHERS THEN
5885: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5886: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.Validate_Customer_Item');
5887: --
5888: IF l_debug_on THEN
5889: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5890: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 6041: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.Validate_Ship_Method');

6037: --
6038: EXCEPTION
6039: WHEN OTHERS THEN
6040: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6041: WSH_UTIL_CORE.Default_Handler('WSH_UTIL_VALIDATE.Validate_Ship_Method');
6042: --
6043: IF l_debug_on THEN
6044: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6045: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 6132: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Freight_Code');

6128: CLOSE l_carrier_csr;
6129: END IF;
6130: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6131:
6132: wsh_util_core.default_handler('WSH_UTIL_VALIDATE.Validate_Freight_Code');
6133: IF l_debug_on THEN
6134: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6135: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
6136: END IF;

Line 6140: END WSH_UTIL_VALIDATE;

6136: END IF;
6137: --}
6138: END Validate_Freight_Code;
6139:
6140: END WSH_UTIL_VALIDATE;