DBA Data[Home] [Help]

APPS.WSH_DELIVERY_VALIDATIONS dependencies on WSH_DELIVERY_DETAILS_INV

Line 2783: x_line_inv_flag_rec OUT NOCOPY wsh_delivery_details_inv.inv_control_flag_rec,

2779: --
2780: -----------------------------------------------------------------------------
2781: PROCEDURE Check_Detail_for_Confirm ( p_detail_id IN NUMBER,
2782: p_check_credit_init_flag IN BOOLEAN, -- 2343058
2783: x_line_inv_flag_rec OUT NOCOPY wsh_delivery_details_inv.inv_control_flag_rec,
2784: x_return_status OUT NOCOPY VARCHAR2) IS
2785:
2786: CURSOR detail_info IS
2787: SELECT delivery_detail_id,

Line 2834: l_line_inv_rec wsh_delivery_details_inv.line_inv_info;

2830: x_errored_serials INV_VALIDATE.SERIAL_NUMBER_TBL;
2831:
2832: /************************MATERIAL STATUS CONTROL ********/
2833:
2834: l_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2835: g_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2836: l_line_inv_flag_rec wsh_delivery_details_inv.inv_control_flag_rec;
2837: l_details_flag BOOLEAN;
2838:

Line 2835: g_line_inv_rec wsh_delivery_details_inv.line_inv_info;

2831:
2832: /************************MATERIAL STATUS CONTROL ********/
2833:
2834: l_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2835: g_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2836: l_line_inv_flag_rec wsh_delivery_details_inv.inv_control_flag_rec;
2837: l_details_flag BOOLEAN;
2838:
2839: l_source_line_id NUMBER;

Line 2836: l_line_inv_flag_rec wsh_delivery_details_inv.inv_control_flag_rec;

2832: /************************MATERIAL STATUS CONTROL ********/
2833:
2834: l_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2835: g_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2836: l_line_inv_flag_rec wsh_delivery_details_inv.inv_control_flag_rec;
2837: l_details_flag BOOLEAN;
2838:
2839: l_source_line_id NUMBER;
2840: l_source_header_id NUMBER;

Line 2954: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights',WSH_DEBUG_SV.C_PROC_LEVEL);

2950: AND (NVL(l_line_inv_rec.picked_quantity2,0) = 0) THEN
2951:
2952:
2953: IF l_debug_on THEN
2954: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights',WSH_DEBUG_SV.C_PROC_LEVEL);
2955: END IF;
2956:
2957: WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights
2958: (p_line_inv_rec => l_line_inv_rec,

Line 2957: WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights

2953: IF l_debug_on THEN
2954: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights',WSH_DEBUG_SV.C_PROC_LEVEL);
2955: END IF;
2956:
2957: WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights
2958: (p_line_inv_rec => l_line_inv_rec,
2959: x_return_status => x_return_status);
2960:
2961: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

Line 2984: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);

2980: --
2981: -- Debug Statements
2982: --
2983: IF l_debug_on THEN
2984: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);
2985: END IF;
2986: --
2987: wsh_delivery_details_inv.fetch_inv_controls(
2988: p_delivery_detail_id => l_line_inv_rec.delivery_detail_id,

Line 2987: wsh_delivery_details_inv.fetch_inv_controls(

2983: IF l_debug_on THEN
2984: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);
2985: END IF;
2986: --
2987: wsh_delivery_details_inv.fetch_inv_controls(
2988: p_delivery_detail_id => l_line_inv_rec.delivery_detail_id,
2989: p_inventory_item_id => l_line_inv_rec.inventory_item_id,
2990: p_organization_id => l_line_inv_rec.organization_id,
2991: p_subinventory => l_line_inv_rec.subinventory,

Line 3013: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DETAILS_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

3009: --
3010: -- Debug Statements
3011: --
3012: IF l_debug_on THEN
3013: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DETAILS_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
3014: END IF;
3015: --
3016: wsh_delivery_details_inv.Details_Required (
3017: p_line_inv_rec => l_line_inv_rec,

Line 3016: wsh_delivery_details_inv.Details_Required (

3012: IF l_debug_on THEN
3013: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DETAILS_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
3014: END IF;
3015: --
3016: wsh_delivery_details_inv.Details_Required (
3017: p_line_inv_rec => l_line_inv_rec,
3018: p_set_default => FALSE,
3019: x_line_inv_rec => g_line_inv_rec,
3020: x_details_required => l_details_flag,

Line 3070: WSH_DELIVERY_DETAILS_INV.get_trx_type_id(

3066: select DECODE(wsh_util_validate.Check_Wms_Org(l_line_inv_rec.organization_id),'Y','TRUE','FALSE')
3067: into l_wms_enabled
3068: from dual;
3069:
3070: WSH_DELIVERY_DETAILS_INV.get_trx_type_id(
3071: p_source_line_id => l_line_inv_rec.source_line_id,
3072: p_source_code => l_line_inv_rec.source_code,
3073: x_transaction_type_id => L_TRANSACTION_TYPE_ID ,
3074: x_return_status => x_return_status);

Line 3148: WSH_DELIVERY_DETAILS_INV.Validate_Serial( p_serial_number => l_line_inv_rec.serial_number,

3144: return;
3145: END IF;
3146:
3147: ELSE
3148: WSH_DELIVERY_DETAILS_INV.Validate_Serial( p_serial_number => l_line_inv_rec.serial_number,
3149: p_lot_number => l_line_inv_rec.lot_number,
3150: p_organization_id => l_line_inv_rec.organization_id ,
3151: p_inventory_item_id => l_line_inv_rec.inventory_item_id ,
3152: p_subinventory => l_line_inv_rec.subinventory ,