[Home] [Help]
176: l_return_status VARCHAR2(1);
177: l_result_date DATE;
178: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
179: begin
180: mtl_inv_validate_grp.get_offset_date(
181: p_api_version => 0.9,
182: x_msg_count => l_msg_count,
183: x_msg_data => l_msg_data,
184: x_return_status => l_return_status,
3721: mdebug('Process: In Validate_CHeader ' || to_char(p_cycle_count_header_id));
3722: END IF;
3723:
3724: -- Validate the cycle COUNT header
3725: MTL_INV_VALIDATE_GRP.Validate_CountHeader(
3726: p_api_version => 0.9,
3727: x_return_status => x_return_status,
3728: x_msg_count => x_msg_count,
3729: x_msg_data => x_msg_data,
3762: , p_message_name => 'INV_CCEOI_MULT_HEADER'
3763: );
3764: ELSIF x_errorcode = 0 THEN
3765: -- Get stock_locator_control
3766: MTL_INV_VALIDATE_GRP.Get_StockLocatorControlCode(
3767: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.organization_id);
3768: IF (l_debug = 1) THEN
3769: mdebug('Process: In Validate_CHeader derive stock locator ='||to_char(MTL_CCEOI_VAR_PVT.G_STOCK_LOCATOR_CONTROL_CODE));
3770: END IF;
3906: --
3907: IF (l_debug = 1) THEN
3908: mdebug('Process: In Validate_CountListSequence ' || to_char(p_count_list_sequence));
3909: END IF;
3910: MTL_INV_VALIDATE_GRP.Validate_CountListSequence(
3911: p_api_version => 0.9,
3912: x_return_status => x_return_status,
3913: x_msg_count => x_msg_count,
3914: x_msg_data => x_msg_data,
3935: IF (l_debug = 1) THEN
3936: MDEBUG( 'Validate Seq for Unsch.'||to_char(x_errorcode));
3937: END IF;
3938: -- Get all the item information to store IN package var
3939: MTL_INV_VALIDATE_GRP.Get_Item_SKU(
3940: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC);
3941: ELSIF
3942: x_errorcode = 3 THEN
3943: -- Write INTO interface error TABLE
3953: IF (l_debug = 1) THEN
3954: mdebug('Process: In Validate_CountListSequence Derive ItemSKU');
3955: END IF;
3956: -- Get all the item information to store IN package var
3957: MTL_INV_VALIDATE_GRP.Get_Item_SKU(
3958: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC);
3959: END IF;
3960: --
3961: --
4151: END IF;
4152: --
4153: /* Validate API Implementation for Item validation
4154: This is implemented in called function */
4155: MTL_INV_VALIDATE_GRP.Validate_Item(
4156: p_api_version => 0.9,
4157: x_return_status => x_return_status,
4158: x_msg_count => x_msg_count,
4159: x_msg_data => x_msg_data,
4206: END IF;
4207: -- Validate Subinventory
4208: /* Validate API Implementation for Subinv validation
4209: This is introduced in called API */
4210: MTL_INV_VALIDATE_GRP.Validate_Subinv(
4211: p_api_version => 0.9,
4212: x_return_status => x_return_status,
4213: x_msg_count => x_msg_count,
4214: x_msg_data => x_msg_data,
4264: -- IS item under locator control
4265: IF (l_debug = 1) THEN
4266: mdebug('Process: In Validate_ItemSKU call Locator Control');
4267: END IF;
4268: MTL_INV_VALIDATE_GRP.Locator_Control(
4269: p_api_version => 0.9,
4270: x_return_status => x_return_status,
4271: x_msg_count => x_msg_count,
4272: x_msg_data => x_msg_data,
4286: IF (l_debug = 1) THEN
4287: mdebug('Process: In Validate_ItemSKU call Val_Ctrol ');
4288: END IF;
4289: -- Validate Control information
4290: MTL_INV_VALIDATE_GRP.Validate_Ctrol(
4291: p_api_version => 0.9,
4292: x_return_status => x_return_status,
4293: x_msg_count => x_msg_count,
4294: x_msg_data => x_msg_data,
4358: -- Validate Locator
4359: /* Validate API Implementation done in called procedure
4360: since it has multiple call for Locator validation */
4361:
4362: MTL_INV_VALIDATE_GRP.Validate_Locator(
4363: p_api_version => 0.9,
4364: x_return_status => x_return_status,
4365: x_msg_count => x_msg_count,
4366: x_msg_data => x_msg_data,
5002:
5003: IF (l_debug = 1) THEN
5004: mdebug('Process: In Validate_UOMQuantity call Validate_PrimaryUOMQty');
5005: END IF;
5006: MTL_INV_VALIDATE_GRP.Validate_PrimaryUomQuantity
5007: (p_api_version => 0.9,
5008: x_return_status => x_return_status,
5009: x_msg_count => x_msg_count,
5010: x_msg_data => x_msg_data,
5060: IF (l_debug = 1) THEN
5061: mdebug('Process: In Validate_UOMQuantity call Validate_CountUOM: ' || p_count_uom);
5062: END IF;
5063:
5064: MTL_INV_VALIDATE_GRP.Validate_CountUOM(p_api_version => 0.9
5065: , x_msg_count => x_msg_count
5066: , x_msg_data => x_msg_data
5067: , x_return_status => x_return_status
5068: , x_errorcode => x_errorcode
5111:
5112: END IF;
5113:
5114: --mdebug('Process: In Validate_UOMQuantity call Validate_CountQty ');
5115: MTL_INV_VALIDATE_GRP.Validate_CountQuantity(p_api_version => 0.9
5116: , x_return_status => x_return_status
5117: , x_msg_count => x_msg_count
5118: , x_msg_data => x_msg_data
5119: , x_errorcode => x_errorcode
5369: --
5370: IF (l_debug = 1) THEN
5371: mdebug('Process: In Validate_CDate_Counter call Validate Countdate');
5372: END IF;
5373: MTL_INV_VALIDATE_GRP.Validate_CountDate
5374: -- Prozedur
5375: (p_api_version => 0.9
5376: , x_return_status => x_return_status
5377: , x_msg_count => x_msg_count
6619: mdebug ( 'Process: In Validate_SecondaryUOMQty call Validate_SecondaryCountUOM: '
6620: || p_secondary_uom);
6621: END IF;
6622:
6623: mtl_inv_validate_grp.validate_secondarycountuom
6624: (p_api_version => 0.9
6625: , x_msg_count => x_msg_count
6626: , x_msg_data => x_msg_data
6627: , x_return_status => x_return_status
6653: END IF;
6654:
6655: -- Validate Secondary count quantity
6656: -- Need to handle conversions and defaulting
6657: mtl_inv_validate_grp.validate_secondarycountqty
6658: (p_api_version => 0.9
6659: , x_return_status => x_return_status
6660: , x_msg_count => x_msg_count
6661: , x_msg_data => x_msg_data