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.60.12020000.4 2013/04/08 10:50:49 suppal ship $ */
3:
4:
5: --

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

2: /* $Header: WSHDDVLB.pls 120.60.12020000.4 2013/04/08 10:50:49 suppal 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: -- muom

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

507: --
508: exception
509: when others then
510: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
511: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.Check_Shipped_Quantity');
512: --
513: -- Debug Statements
514: --
515: IF l_debug_on THEN

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

599: --
600: EXCEPTION
601: WHEN OTHERS THEN
602: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
603: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.Check_Cycle_Count_Quantity');
604: --
605: -- Debug Statements
606: --
607: IF l_debug_on THEN

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

789: --
790: exception
791: when others then
792: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
793: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.Check_Decimal_Quantity');
794: --
795: -- Debug Statements
796: --
797: IF l_debug_on THEN

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

900: WHEN others THEN
901: IF check_unassign%ISOPEN THEN
902: CLOSE check_unassign;
903: END IF;
904: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.CHECK_UNASSIGN_FROM_DELIVERY');
905: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
906:
907: --
908: -- Debug Statements

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

1088: WHEN others THEN
1089: IF check_assign%ISOPEN THEN
1090: CLOSE check_assign;
1091: END IF;
1092: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.CHECK_ASSIGN_DEL_MULTI');
1093: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1094:
1095: --
1096: -- Debug Statements

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

1698: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CREDIT_HOLD_ERROR');
1699: END IF;
1700: --
1701: WHEN others THEN
1702: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.Check_Credit_Holds');
1703: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1704:
1705: --
1706: -- Debug Statements

Line 1966: WSH_DETAILS_VALIDATIONS.get_min_max_tolerance_quantity

1962: l_minmaxinrectype.lock_flag := 'N';
1963: l_minmaxinrectype.quantity_uom := l_detail_info.requested_quantity_uom;
1964: l_minmaxinrectype.quantity_uom2 := l_detail_info.requested_quantity_uom2;
1965:
1966: WSH_DETAILS_VALIDATIONS.get_min_max_tolerance_quantity
1967: (p_in_attributes => l_minmaxinrectype,
1968: x_out_attributes => l_minmaxoutrectype,
1969: p_inout_attributes => l_minmaxinoutrectype,
1970: x_return_status => l_return_status,

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

2074: -- HW Added for OPM
2075: x_max_quantity2_allowed := NULL;
2076: x_avail_req_quantity2 := NULL;
2077: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2078: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.check_quantity_to_pick');
2079:
2080: --
2081: -- Debug Statements
2082: --

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

2133: --
2134: -- Debug Statements
2135: --
2136: IF l_debug_on THEN
2137: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_QUANTITY_TO_PICK',WSH_DEBUG_SV.C_PROC_LEVEL);
2138: END IF;
2139: --
2140: wsh_details_validations.check_quantity_to_pick(
2141: p_order_line_id => p_order_line_id,

Line 2140: wsh_details_validations.check_quantity_to_pick(

2136: IF l_debug_on THEN
2137: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_QUANTITY_TO_PICK',WSH_DEBUG_SV.C_PROC_LEVEL);
2138: END IF;
2139: --
2140: wsh_details_validations.check_quantity_to_pick(
2141: p_order_line_id => p_order_line_id,
2142: p_quantity_to_pick => p_quantity_to_pick,
2143: p_quantity2_to_pick => l_dummy_quantity2_to_pick,
2144: x_allowed_flag => x_allowed_flag,

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

2157: --
2158: EXCEPTION
2159: WHEN OTHERS THEN
2160: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2161: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.check_quantity_to_pick');
2162:
2163: --
2164: -- Debug Statements
2165: --

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

2338: IF c_check_qty_inside_del%ISOPEN THEN
2339: close c_check_qty_inside_del;
2340: END IF;
2341: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2342: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.check_zero_req_confirm');
2343:
2344: --
2345: -- Debug Statements
2346: --

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

2965: WHEN others THEN
2966: IF (get_delivery_status%ISOPEN) THEN
2967: CLOSE get_delivery_status;
2968: END IF;
2969: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.get_disabled_list');
2970: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2971:
2972:
2973: --

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

3474:
3475: EXCEPTION
3476: WHEN OTHERS THEN
3477: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3478: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.get_min_max_tolerance_quantity',
3479: l_module_name);
3480:
3481: x_out_attributes.min_remaining_quantity := 0;
3482: x_out_attributes.max_remaining_quantity := 0;

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

6119: END IF;
6120:
6121: WHEN OTHERS THEN
6122: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6123: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.get_disabled_list',
6124: l_module_name);
6125: IF l_debug_on THEN
6126: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));
6127: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

6456: END IF;
6457: EXCEPTION
6458: WHEN OTHERS THEN
6459: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6460: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.Init_Detail_Actions_Tbl', l_module_name);
6461: IF l_debug_on THEN
6462: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));
6463: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
6464: END IF;

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

6602:
6603: -- HW OPMCONV - No need to branch
6604:
6605: IF l_debug_on THEN
6606: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
6607: END IF;
6608: wsh_details_validations.check_decimal_quantity(
6609: p_item_id => x_det_rec.inventory_item_id,
6610: p_organization_id => x_det_rec.organization_id,

Line 6608: wsh_details_validations.check_decimal_quantity(

6604:
6605: IF l_debug_on THEN
6606: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_DECIMAL_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
6607: END IF;
6608: wsh_details_validations.check_decimal_quantity(
6609: p_item_id => x_det_rec.inventory_item_id,
6610: p_organization_id => x_det_rec.organization_id,
6611: p_input_quantity => l_input_quantity,
6612: p_uom_code => x_det_rec.requested_quantity_uom,

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

6638: -- 4) If SQ, check shipped qty
6639: -- If CCQ, check cc qty
6640: IF (p_flag = 'SQ') THEN
6641: IF l_debug_on THEN
6642: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_SHIPPED_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
6643: END IF;
6644: wsh_details_validations.check_shipped_quantity(
6645: p_ship_above_tolerance => x_det_rec.ship_tolerance_above,
6646: p_requested_quantity => x_det_rec.requested_quantity,

Line 6644: wsh_details_validations.check_shipped_quantity(

6640: IF (p_flag = 'SQ') THEN
6641: IF l_debug_on THEN
6642: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_SHIPPED_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
6643: END IF;
6644: wsh_details_validations.check_shipped_quantity(
6645: p_ship_above_tolerance => x_det_rec.ship_tolerance_above,
6646: p_requested_quantity => x_det_rec.requested_quantity,
6647: p_picked_quantity => x_det_rec.picked_quantity,
6648: p_shipped_quantity => NVL(l_quantity, 0),

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

6658:
6659: ELSIF(p_flag = 'CCQ') THEN
6660:
6661: IF l_debug_on THEN
6662: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CYCLE_COUNT_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
6663: END IF;
6664:
6665: wsh_details_validations.check_cycle_count_quantity(
6666: p_ship_above_tolerance => x_det_rec.ship_tolerance_above,

Line 6665: wsh_details_validations.check_cycle_count_quantity(

6661: IF l_debug_on THEN
6662: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CYCLE_COUNT_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
6663: END IF;
6664:
6665: wsh_details_validations.check_cycle_count_quantity(
6666: p_ship_above_tolerance => x_det_rec.ship_tolerance_above,
6667: p_requested_quantity => x_det_rec.requested_quantity,
6668: p_picked_quantity => x_det_rec.picked_quantity,
6669: p_shipped_quantity => NVL(x_det_rec.shipped_quantity, 0),

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

6844: END IF;
6845: --
6846: WHEN OTHERS THEN
6847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6848: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY');
6849: --
6850: IF l_debug_on THEN
6851: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6852: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

7000:
7001: IF (p_flag = 'SQ') THEN
7002:
7003: IF l_debug_on THEN
7004: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_SHIPPED_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
7005: END IF;
7006: wsh_details_validations.check_shipped_quantity(
7007: p_ship_above_tolerance => x_det_rec.ship_tolerance_above,
7008: p_requested_quantity => x_det_rec.requested_quantity2,

Line 7006: wsh_details_validations.check_shipped_quantity(

7002:
7003: IF l_debug_on THEN
7004: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_SHIPPED_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
7005: END IF;
7006: wsh_details_validations.check_shipped_quantity(
7007: p_ship_above_tolerance => x_det_rec.ship_tolerance_above,
7008: p_requested_quantity => x_det_rec.requested_quantity2,
7009: p_picked_quantity => x_det_rec.picked_quantity2,
7010: p_shipped_quantity => NVL(l_quantity, 0),

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

7018: END IF;
7019: ELSIF(p_flag = 'CCQ') THEN
7020:
7021: IF l_debug_on THEN
7022: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CYCLE_COUNT_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
7023: END IF;
7024: wsh_details_validations.check_cycle_count_quantity(
7025: p_ship_above_tolerance => x_det_rec.ship_tolerance_above,
7026: p_requested_quantity => x_det_rec.requested_quantity2,

Line 7024: wsh_details_validations.check_cycle_count_quantity(

7020:
7021: IF l_debug_on THEN
7022: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CYCLE_COUNT_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
7023: END IF;
7024: wsh_details_validations.check_cycle_count_quantity(
7025: p_ship_above_tolerance => x_det_rec.ship_tolerance_above,
7026: p_requested_quantity => x_det_rec.requested_quantity2,
7027: p_picked_quantity => x_det_rec.picked_quantity2,
7028: p_shipped_quantity => NVL(x_det_rec.shipped_quantity2, 0),

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

7082: END IF;
7083: --
7084: WHEN OTHERS THEN
7085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7086: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.VALIDATE_SHIPPED_CC_QUANTITY2');
7087: --
7088: IF l_debug_on THEN
7089: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
7090: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

7656: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
7657: END IF;
7658: WHEN OTHERS THEN
7659: x_return_status := fnd_api.g_ret_sts_unexp_error;
7660: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.validate_secondary_quantity',l_module_name);
7661: --
7662: fnd_msg_pub.count_and_get(
7663: p_count => x_msg_count,
7664: p_data => x_msg_data,

Line 9225: END WSH_DETAILS_VALIDATIONS;

9221: return(FALSE);
9222:
9223: END is_cycle_count_allowed;
9224:
9225: END WSH_DETAILS_VALIDATIONS;