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_DETAILS_VALIDATIONS dependencies on WSH_DETAILS_VALIDATIONS

Line 1: PACKAGE BODY WSH_DETAILS_VALIDATIONS as

1: PACKAGE BODY WSH_DETAILS_VALIDATIONS as
2: /* $Header: WSHDDVLB.pls 120.48.12010000.3 2008/09/08 12:27:31 anvarshn ship $ */
3:
4:
5: --

Line 6: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DETAILS_VALIDATIONS';

2: /* $Header: WSHDDVLB.pls 120.48.12010000.3 2008/09/08 12:27:31 anvarshn ship $ */
3:
4:
5: --
6: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DETAILS_VALIDATIONS';
7: -- Global Variable added for bug 4399278, 4418754
8: G_SUBINVENTORY WSH_DELIVERY_DETAILS.Subinventory%TYPE;
9: --
10:

Line 485: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.Check_Shipped_Quantity');

481: --
482: exception
483: when others then
484: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
485: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.Check_Shipped_Quantity');
486: --
487: -- Debug Statements
488: --
489: IF l_debug_on THEN

Line 567: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.Check_Cycle_Count_Quantity');

563: --
564: EXCEPTION
565: WHEN OTHERS THEN
566: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
567: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.Check_Cycle_Count_Quantity');
568: --
569: -- Debug Statements
570: --
571: IF l_debug_on THEN

Line 753: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity');

749: --
750: exception
751: when others then
752: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
753: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity');
754: --
755: -- Debug Statements
756: --
757: IF l_debug_on THEN

Line 864: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.CHECK_UNASSIGN_FROM_DELIVERY');

860: WHEN others THEN
861: IF check_unassign%ISOPEN THEN
862: CLOSE check_unassign;
863: END IF;
864: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.CHECK_UNASSIGN_FROM_DELIVERY');
865: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
866:
867: --
868: -- Debug Statements

Line 1052: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.CHECK_ASSIGN_DEL_MULTI');

1048: WHEN others THEN
1049: IF check_assign%ISOPEN THEN
1050: CLOSE check_assign;
1051: END IF;
1052: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.CHECK_ASSIGN_DEL_MULTI');
1053: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1054:
1055: --
1056: -- Debug Statements

Line 1633: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.Check_Credit_Holds');

1629: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CREDIT_HOLD_ERROR');
1630: END IF;
1631: --
1632: WHEN others THEN
1633: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.Check_Credit_Holds');
1634: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1635:
1636: --
1637: -- Debug Statements

Line 1897: WSH_DETAILS_VALIDATIONS.get_min_max_tolerance_quantity

1893: l_minmaxinrectype.lock_flag := 'N';
1894: l_minmaxinrectype.quantity_uom := l_detail_info.requested_quantity_uom;
1895: l_minmaxinrectype.quantity_uom2 := l_detail_info.requested_quantity_uom2;
1896:
1897: WSH_DETAILS_VALIDATIONS.get_min_max_tolerance_quantity
1898: (p_in_attributes => l_minmaxinrectype,
1899: x_out_attributes => l_minmaxoutrectype,
1900: p_inout_attributes => l_minmaxinoutrectype,
1901: x_return_status => l_return_status,

Line 2008: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.check_quantity_to_pick');

2004: -- HW Added for OPM
2005: x_max_quantity2_allowed := NULL;
2006: x_avail_req_quantity2 := NULL;
2007: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2008: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.check_quantity_to_pick');
2009:
2010: --
2011: -- Debug Statements
2012: --

Line 2067: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_QUANTITY_TO_PICK',WSH_DEBUG_SV.C_PROC_LEVEL);

2063: --
2064: -- Debug Statements
2065: --
2066: IF l_debug_on THEN
2067: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_QUANTITY_TO_PICK',WSH_DEBUG_SV.C_PROC_LEVEL);
2068: END IF;
2069: --
2070: wsh_details_validations.check_quantity_to_pick(
2071: p_order_line_id => p_order_line_id,

Line 2070: wsh_details_validations.check_quantity_to_pick(

2066: IF l_debug_on THEN
2067: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_QUANTITY_TO_PICK',WSH_DEBUG_SV.C_PROC_LEVEL);
2068: END IF;
2069: --
2070: wsh_details_validations.check_quantity_to_pick(
2071: p_order_line_id => p_order_line_id,
2072: p_quantity_to_pick => p_quantity_to_pick,
2073: p_quantity2_to_pick => l_dummy_quantity2_to_pick,
2074: x_allowed_flag => x_allowed_flag,

Line 2091: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.check_quantity_to_pick');

2087: --
2088: EXCEPTION
2089: WHEN OTHERS THEN
2090: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2091: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.check_quantity_to_pick');
2092:
2093: --
2094: -- Debug Statements
2095: --

Line 2232: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.check_zero_req_confirm');

2228: IF c_check_qty_inside_del%ISOPEN THEN
2229: close c_check_qty_inside_del;
2230: END IF;
2231: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2232: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.check_zero_req_confirm');
2233:
2234: --
2235: -- Debug Statements
2236: --

Line 2852: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.get_disabled_list');

2848: WHEN others THEN
2849: IF (get_delivery_status%ISOPEN) THEN
2850: CLOSE get_delivery_status;
2851: END IF;
2852: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.get_disabled_list');
2853: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2854:
2855:
2856: --

Line 3355: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.get_min_max_tolerance_quantity',

3351:
3352: EXCEPTION
3353: WHEN OTHERS THEN
3354: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3355: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.get_min_max_tolerance_quantity',
3356: l_module_name);
3357:
3358: x_out_attributes.min_remaining_quantity := 0;
3359: x_out_attributes.max_remaining_quantity := 0;

Line 5873: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.get_disabled_list',

5869: END IF;
5870:
5871: WHEN OTHERS THEN
5872: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5873: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.get_disabled_list',
5874: l_module_name);
5875: IF l_debug_on THEN
5876: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));
5877: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 6210: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.Init_Detail_Actions_Tbl', l_module_name);

6206: END IF;
6207: EXCEPTION
6208: WHEN OTHERS THEN
6209: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6210: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.Init_Detail_Actions_Tbl', l_module_name);
6211: IF l_debug_on THEN
6212: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));
6213: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
6214: END IF;

Line 6340: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);

6336:
6337: -- HW OPMCONV - No need to branch
6338:
6339: IF l_debug_on THEN
6340: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
6341: END IF;
6342:
6343: wsh_details_validations.check_decimal_quantity(
6344: p_item_id => x_det_rec.inventory_item_id,

Line 6343: wsh_details_validations.check_decimal_quantity(

6339: IF l_debug_on THEN
6340: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
6341: END IF;
6342:
6343: wsh_details_validations.check_decimal_quantity(
6344: p_item_id => x_det_rec.inventory_item_id,
6345: p_organization_id => x_det_rec.organization_id,
6346: p_input_quantity => l_input_quantity,
6347: p_uom_code => x_det_rec.requested_quantity_uom,

Line 6375: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_SHIPPED_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);

6371: -- 4) If SQ, check shipped qty
6372: -- If CCQ, check cc qty
6373: IF (p_flag = 'SQ') THEN
6374: IF l_debug_on THEN
6375: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_SHIPPED_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
6376: END IF;
6377: wsh_details_validations.check_shipped_quantity(
6378: p_ship_above_tolerance => x_det_rec.ship_tolerance_above,
6379: p_requested_quantity => x_det_rec.requested_quantity,

Line 6377: wsh_details_validations.check_shipped_quantity(

6373: IF (p_flag = 'SQ') THEN
6374: IF l_debug_on THEN
6375: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_SHIPPED_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
6376: END IF;
6377: wsh_details_validations.check_shipped_quantity(
6378: p_ship_above_tolerance => x_det_rec.ship_tolerance_above,
6379: p_requested_quantity => x_det_rec.requested_quantity,
6380: p_picked_quantity => x_det_rec.picked_quantity,
6381: p_shipped_quantity => NVL(l_quantity, 0),

Line 6393: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CYCLE_COUNT_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);

6389:
6390: ELSIF(p_flag = 'CCQ') THEN
6391:
6392: IF l_debug_on THEN
6393: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CYCLE_COUNT_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
6394: END IF;
6395:
6396: wsh_details_validations.check_cycle_count_quantity(
6397: p_ship_above_tolerance => x_det_rec.ship_tolerance_above,

Line 6396: wsh_details_validations.check_cycle_count_quantity(

6392: IF l_debug_on THEN
6393: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CYCLE_COUNT_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
6394: END IF;
6395:
6396: wsh_details_validations.check_cycle_count_quantity(
6397: p_ship_above_tolerance => x_det_rec.ship_tolerance_above,
6398: p_requested_quantity => x_det_rec.requested_quantity,
6399: p_picked_quantity => x_det_rec.picked_quantity,
6400: p_shipped_quantity => NVL(x_det_rec.shipped_quantity, 0),

Line 6576: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY');

6572: END IF;
6573: --
6574: WHEN OTHERS THEN
6575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6576: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY');
6577: --
6578: IF l_debug_on THEN
6579: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6580: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 6711: --Bug 6668217. Uday Phadtare. Commented call wsh_details_validations.check_shipped_quantity

6707: END IF;
6708:
6709: -- 4) If SQ, check shipped qty
6710: -- If CCQ, check cc qty
6711: --Bug 6668217. Uday Phadtare. Commented call wsh_details_validations.check_shipped_quantity
6712: --and wsh_details_validations.check_cycle_count_quantity for quantity2 because for quantity2
6713: --validation is not to be done.
6714: /*
6715: IF (p_flag = 'SQ') THEN

Line 6712: --and wsh_details_validations.check_cycle_count_quantity for quantity2 because for quantity2

6708:
6709: -- 4) If SQ, check shipped qty
6710: -- If CCQ, check cc qty
6711: --Bug 6668217. Uday Phadtare. Commented call wsh_details_validations.check_shipped_quantity
6712: --and wsh_details_validations.check_cycle_count_quantity for quantity2 because for quantity2
6713: --validation is not to be done.
6714: /*
6715: IF (p_flag = 'SQ') THEN
6716:

Line 6718: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_SHIPPED_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);

6714: /*
6715: IF (p_flag = 'SQ') THEN
6716:
6717: IF l_debug_on THEN
6718: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_SHIPPED_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
6719: END IF;
6720: wsh_details_validations.check_shipped_quantity(
6721: p_ship_above_tolerance => x_det_rec.ship_tolerance_above,
6722: p_requested_quantity => x_det_rec.requested_quantity2,

Line 6720: wsh_details_validations.check_shipped_quantity(

6716:
6717: IF l_debug_on THEN
6718: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_SHIPPED_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
6719: END IF;
6720: wsh_details_validations.check_shipped_quantity(
6721: p_ship_above_tolerance => x_det_rec.ship_tolerance_above,
6722: p_requested_quantity => x_det_rec.requested_quantity2,
6723: p_picked_quantity => x_det_rec.picked_quantity2,
6724: p_shipped_quantity => NVL(l_quantity, 0),

Line 6734: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CYCLE_COUNT_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);

6730: END IF;
6731: ELSIF(p_flag = 'CCQ') THEN
6732:
6733: IF l_debug_on THEN
6734: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CYCLE_COUNT_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
6735: END IF;
6736: wsh_details_validations.check_cycle_count_quantity(
6737: p_ship_above_tolerance => x_det_rec.ship_tolerance_above,
6738: p_requested_quantity => x_det_rec.requested_quantity2,

Line 6736: wsh_details_validations.check_cycle_count_quantity(

6732:
6733: IF l_debug_on THEN
6734: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CYCLE_COUNT_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
6735: END IF;
6736: wsh_details_validations.check_cycle_count_quantity(
6737: p_ship_above_tolerance => x_det_rec.ship_tolerance_above,
6738: p_requested_quantity => x_det_rec.requested_quantity2,
6739: p_picked_quantity => x_det_rec.picked_quantity2,
6740: p_shipped_quantity => NVL(x_det_rec.shipped_quantity2, 0),

Line 6796: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY2');

6792: END IF;
6793: --
6794: WHEN OTHERS THEN
6795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6796: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY2');
6797: --
6798: IF l_debug_on THEN
6799: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6800: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 7370: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.validate_secondary_quantity',l_module_name);

7366: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
7367: END IF;
7368: WHEN OTHERS THEN
7369: x_return_status := fnd_api.g_ret_sts_unexp_error;
7370: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.validate_secondary_quantity',l_module_name);
7371: --
7372: fnd_msg_pub.count_and_get(
7373: p_count => x_msg_count,
7374: p_data => x_msg_data,

Line 8920: END WSH_DETAILS_VALIDATIONS;

8916: return(FALSE);
8917:
8918: END is_cycle_count_allowed;
8919:
8920: END WSH_DETAILS_VALIDATIONS;