DBA Data[Home] [Help]

APPS.WSH_BULK_PROCESS_PVT dependencies on WSH_UTIL_VALIDATE

Line 482: v_item_info_rec wsh_util_validate.item_info_rec_type;

478: l_debug_on BOOLEAN;
479: --
480: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME ||
481: '.' || 'CALC_WT_VOL_QTY';
482: v_item_info_rec wsh_util_validate.item_info_rec_type;
483: l_return_status VARCHAR2(1);
484: l_item_type VARCHAR2(30);
485: l_token VARCHAR2(100);
486: l_num_warnings NUMBER := 0;

Line 546: wsh_util_validate.get_item_info(

542: p_line_rec.requested_quantity_uom(p_index) IS NULL OR
543: p_line_rec.volume_uom_code(p_index) IS NULL
544: THEN --{
545:
546: wsh_util_validate.get_item_info(
547: p_organization_id => p_line_rec.organization_id(p_index),
548: p_inventory_item_id => p_line_rec.inventory_item_id(p_index),
549: x_Item_info_rec => v_item_info_rec,
550: x_return_status => l_return_status);

Line 604: WSH_UTIL_VALIDATE.Find_Item_Type(

600: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_validate_OM_QTY_WT_VOL_LVL) = 1
601: OR WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PO_CALC_WT_VOL_LVL) = 1 THEN --{
602: p_line_rec.gross_weight(p_index) := p_line_rec.net_weight(p_index);
603: ELSE --}{
604: WSH_UTIL_VALIDATE.Find_Item_Type(
605: p_inventory_item_id => p_line_rec.inventory_item_id(p_index),
606: p_organization_id => p_line_rec.organization_id(p_index) ,
607: x_item_type => l_item_type,
608: x_return_status => l_return_status );

Line 796: --wsh_util_validate.G_ITEM_INFO_TAB.DELETE;

792: x_num_errors => l_num_errors);
793:
794:
795:
796: --wsh_util_validate.G_ITEM_INFO_TAB.DELETE;
797: --wsh_util_validate.G_ITEM_CATEGORY_INFO_TAB.DELETE;
798: --wsh_util_validate.G_SHIPPING_PARAMS_INFO_EXP_TAB.DELETE;
799: --wsh_util_validate.G_SHIPPING_PARAMS_INFO_TAB.DELETE;
800:

Line 797: --wsh_util_validate.G_ITEM_CATEGORY_INFO_TAB.DELETE;

793:
794:
795:
796: --wsh_util_validate.G_ITEM_INFO_TAB.DELETE;
797: --wsh_util_validate.G_ITEM_CATEGORY_INFO_TAB.DELETE;
798: --wsh_util_validate.G_SHIPPING_PARAMS_INFO_EXP_TAB.DELETE;
799: --wsh_util_validate.G_SHIPPING_PARAMS_INFO_TAB.DELETE;
800:
801: --Added for Inbound Logistics.

Line 798: --wsh_util_validate.G_SHIPPING_PARAMS_INFO_EXP_TAB.DELETE;

794:
795:
796: --wsh_util_validate.G_ITEM_INFO_TAB.DELETE;
797: --wsh_util_validate.G_ITEM_CATEGORY_INFO_TAB.DELETE;
798: --wsh_util_validate.G_SHIPPING_PARAMS_INFO_EXP_TAB.DELETE;
799: --wsh_util_validate.G_SHIPPING_PARAMS_INFO_TAB.DELETE;
800:
801: --Added for Inbound Logistics.
802: /*PO will pass the action code as APPROVE_PO even for reapproval case.

Line 799: --wsh_util_validate.G_SHIPPING_PARAMS_INFO_TAB.DELETE;

795:
796: --wsh_util_validate.G_ITEM_INFO_TAB.DELETE;
797: --wsh_util_validate.G_ITEM_CATEGORY_INFO_TAB.DELETE;
798: --wsh_util_validate.G_SHIPPING_PARAMS_INFO_EXP_TAB.DELETE;
799: --wsh_util_validate.G_SHIPPING_PARAMS_INFO_TAB.DELETE;
800:
801: --Added for Inbound Logistics.
802: /*PO will pass the action code as APPROVE_PO even for reapproval case.
803: Depending on the cursor c_po_exists, we now need to set the action

Line 3271: wsh_util_validate.validate_location(

3267: IF (p_action_prms.caller = 'PO') THEN
3268: l_caller:='PO';
3269: END IF;
3270:
3271: wsh_util_validate.validate_location(
3272: p_location_id => p_line_rec.ship_from_location_id(i),
3273: p_caller => l_caller,
3274: x_return_status => l_return_status,
3275: p_isWshLocation => FALSE);

Line 3293: wsh_util_validate.validate_location(

3289: IF (p_action_prms.caller = 'PO') THEN
3290: l_caller:='PO';
3291: END IF;
3292:
3293: wsh_util_validate.validate_location(
3294: p_location_id => p_line_rec.ship_to_location_id(i),
3295: p_caller => l_caller,
3296: x_return_status => l_return_status,
3297: p_isWshLocation => FALSE);

Line 3324: wsh_util_validate.Calc_ignore_for_planning(

3320: END IF;
3321:
3322:
3323:
3324: wsh_util_validate.Calc_ignore_for_planning(
3325: p_organization_id => p_line_rec.organization_id(i),
3326: p_carrier_id => p_line_rec.carrier_id(i),
3327: p_ship_method_code=>
3328: p_line_rec.shipping_method_code(i),

Line 3506: wsh_util_validate.validate_location(

3502: IF (p_action_prms.caller = 'PO') THEN
3503: l_caller:='PO';
3504: END IF;
3505:
3506: wsh_util_validate.validate_location(
3507: p_location_id => p_line_rec.ship_to_location_id(i),
3508: p_caller => l_caller,
3509: x_return_status => l_return_status,
3510: p_isWshLocation => FALSE);

Line 3522: WSH_UTIL_VALIDATE.validate_fob(

3518:
3519: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PO_VALIDATE_FOB_LVL)= 1 )
3520: AND ( p_line_rec.fob_point_code(i) IS NOT NULL ) --condition added for bugfix 3679513
3521: THEN
3522: WSH_UTIL_VALIDATE.validate_fob(
3523: p_fob => p_line_rec.fob_point_code(i),
3524: x_return_status => l_return_status);
3525:
3526: wsh_util_core.api_post_call(

Line 3535: WSH_UTIL_VALIDATE.validate_freight_terms(

3531:
3532: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PO_VALIDATE_FR_TERMS_LVL) = 1)
3533: AND (p_line_rec.freight_terms_code(i) IS NOT NULL) --condition added for bugfix 3679513
3534: THEN
3535: WSH_UTIL_VALIDATE.validate_freight_terms(
3536: p_freight_terms_code => p_line_rec.freight_terms_code(i),
3537: x_return_status => l_return_status);
3538:
3539: wsh_util_core.api_post_call(

Line 3673: wsh_util_validate.default_container(

3669: WSH_DEBUG_SV.log(l_module_name,'ordered_item_id ',
3670: p_line_rec.ordered_item_id(i));
3671: END IF;
3672: IF (p_line_rec.ordered_item_id(i) IS NOT NULL) AND (p_line_rec.item_identifier_type(i) = 'CUST') THEN
3673: wsh_util_validate.default_container(
3674: p_item_id => p_line_rec.ordered_item_id(i) ,
3675: x_master_container_item_id =>
3676: p_additional_line_info_rec.master_container_item_id(i),
3677: x_detail_container_item_id =>