2898: --
2899: -- Debug Statements
2900: --
2901: IF l_debug_on THEN
2902: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CREDIT_HOLDS',WSH_DEBUG_SV.C_PROC_LEVEL);
2903: END IF;
2904: --
2905: wsh_details_validations.check_credit_holds(
2906: p_detail_id => p_detail_id,
2901: IF l_debug_on THEN
2902: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CREDIT_HOLDS',WSH_DEBUG_SV.C_PROC_LEVEL);
2903: END IF;
2904: --
2905: wsh_details_validations.check_credit_holds(
2906: p_detail_id => p_detail_id,
2907: p_activity_type => 'SHIP',
2908: p_source_line_id => l_line_inv_rec.source_line_id,
2909: p_source_header_id => l_line_inv_rec.source_header_id,
2914: --
2915: -- Debug Statements
2916: --
2917: IF l_debug_on THEN
2918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CREDIT_HOLDS',WSH_DEBUG_SV.C_PROC_LEVEL);
2919: END IF;
2920: --
2921: wsh_details_validations.check_credit_holds(
2922: p_detail_id => p_detail_id,
2917: IF l_debug_on THEN
2918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.CHECK_CREDIT_HOLDS',WSH_DEBUG_SV.C_PROC_LEVEL);
2919: END IF;
2920: --
2921: wsh_details_validations.check_credit_holds(
2922: p_detail_id => p_detail_id,
2923: p_activity_type => 'SHIP',
2924: p_source_line_id => l_line_inv_rec.source_line_id,
2925: p_source_header_id => l_line_inv_rec.source_header_id,
5860: l_source_system VARCHAR2(80);
5861: l_return_status VARCHAR2(1);
5862:
5863: -- 2181132
5864: l_minmaxinrectype WSH_DETAILS_VALIDATIONS.MinMaxInRecType;
5865: l_minmaxinoutrectype WSH_DETAILS_VALIDATIONS.MinMaxInOutRecType;
5866: l_minmaxoutrectype WSH_DETAILS_VALIDATIONS.MinMaxOutRecType;
5867: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
5868: l_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE;
5861: l_return_status VARCHAR2(1);
5862:
5863: -- 2181132
5864: l_minmaxinrectype WSH_DETAILS_VALIDATIONS.MinMaxInRecType;
5865: l_minmaxinoutrectype WSH_DETAILS_VALIDATIONS.MinMaxInOutRecType;
5866: l_minmaxoutrectype WSH_DETAILS_VALIDATIONS.MinMaxOutRecType;
5867: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
5868: l_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE;
5869:
5862:
5863: -- 2181132
5864: l_minmaxinrectype WSH_DETAILS_VALIDATIONS.MinMaxInRecType;
5865: l_minmaxinoutrectype WSH_DETAILS_VALIDATIONS.MinMaxInOutRecType;
5866: l_minmaxoutrectype WSH_DETAILS_VALIDATIONS.MinMaxOutRecType;
5867: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
5868: l_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE;
5869:
5870: others EXCEPTION;
5915:
5916: -- Debug Statements
5917: --
5918: IF l_debug_on THEN
5919: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.GET_MIN_MAX_TOLERANCE_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
5920: END IF;
5921:
5922: WSH_DETAILS_VALIDATIONS.get_min_max_tolerance_quantity
5923: (p_in_attributes => l_minmaxinrectype,
5918: IF l_debug_on THEN
5919: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DETAILS_VALIDATIONS.GET_MIN_MAX_TOLERANCE_QUANTITY',WSH_DEBUG_SV.C_PROC_LEVEL);
5920: END IF;
5921:
5922: WSH_DETAILS_VALIDATIONS.get_min_max_tolerance_quantity
5923: (p_in_attributes => l_minmaxinrectype,
5924: x_out_attributes => l_minmaxoutrectype,
5925: p_inout_attributes => l_minmaxinoutrectype,
5926: x_return_status => l_return_status,