[Home] [Help]
117: l_return_status VARCHAR2(1);
118: l_result_date DATE;
119: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
120: begin
121: mtl_inv_validate_grp.get_offset_date(
122: p_api_version => 0.9,
123: x_msg_count => l_msg_count,
124: x_msg_data => l_msg_data,
125: x_return_status => l_return_status,
3580: mdebug('Process: In Validate_CHeader ' || to_char(p_cycle_count_header_id));
3581: END IF;
3582:
3583: -- Validate the cycle COUNT header
3584: MTL_INV_VALIDATE_GRP.Validate_CountHeader(
3585: p_api_version => 0.9,
3586: x_return_status => x_return_status,
3587: x_msg_count => x_msg_count,
3588: x_msg_data => x_msg_data,
3621: , p_message_name => 'INV_CCEOI_MULT_HEADER'
3622: );
3623: ELSIF x_errorcode = 0 THEN
3624: -- Get stock_locator_control
3625: MTL_INV_VALIDATE_GRP.Get_StockLocatorControlCode(
3626: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.organization_id);
3627: IF (l_debug = 1) THEN
3628: mdebug('Process: In Validate_CHeader derive stock locator ='||to_char(MTL_CCEOI_VAR_PVT.G_STOCK_LOCATOR_CONTROL_CODE));
3629: END IF;
3765: --
3766: IF (l_debug = 1) THEN
3767: mdebug('Process: In Validate_CountListSequence ' || to_char(p_count_list_sequence));
3768: END IF;
3769: MTL_INV_VALIDATE_GRP.Validate_CountListSequence(
3770: p_api_version => 0.9,
3771: x_return_status => x_return_status,
3772: x_msg_count => x_msg_count,
3773: x_msg_data => x_msg_data,
3794: IF (l_debug = 1) THEN
3795: MDEBUG( 'Validate Seq for Unsch.'||to_char(x_errorcode));
3796: END IF;
3797: -- Get all the item information to store IN package var
3798: MTL_INV_VALIDATE_GRP.Get_Item_SKU(
3799: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC);
3800: ELSIF
3801: x_errorcode = 3 THEN
3802: -- Write INTO interface error TABLE
3812: IF (l_debug = 1) THEN
3813: mdebug('Process: In Validate_CountListSequence Derive ItemSKU');
3814: END IF;
3815: -- Get all the item information to store IN package var
3816: MTL_INV_VALIDATE_GRP.Get_Item_SKU(
3817: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC);
3818: END IF;
3819: --
3820: --
4009: END IF;
4010: --
4011: /* Validate API Implementation for Item validation
4012: This is implemented in called function */
4013: MTL_INV_VALIDATE_GRP.Validate_Item(
4014: p_api_version => 0.9,
4015: x_return_status => x_return_status,
4016: x_msg_count => x_msg_count,
4017: x_msg_data => x_msg_data,
4064: END IF;
4065: -- Validate Subinventory
4066: /* Validate API Implementation for Subinv validation
4067: This is introduced in called API */
4068: MTL_INV_VALIDATE_GRP.Validate_Subinv(
4069: p_api_version => 0.9,
4070: x_return_status => x_return_status,
4071: x_msg_count => x_msg_count,
4072: x_msg_data => x_msg_data,
4122: -- IS item under locator control
4123: IF (l_debug = 1) THEN
4124: mdebug('Process: In Validate_ItemSKU call Locator Control');
4125: END IF;
4126: MTL_INV_VALIDATE_GRP.Locator_Control(
4127: p_api_version => 0.9,
4128: x_return_status => x_return_status,
4129: x_msg_count => x_msg_count,
4130: x_msg_data => x_msg_data,
4144: IF (l_debug = 1) THEN
4145: mdebug('Process: In Validate_ItemSKU call Val_Ctrol ');
4146: END IF;
4147: -- Validate Control information
4148: MTL_INV_VALIDATE_GRP.Validate_Ctrol(
4149: p_api_version => 0.9,
4150: x_return_status => x_return_status,
4151: x_msg_count => x_msg_count,
4152: x_msg_data => x_msg_data,
4216: -- Validate Locator
4217: /* Validate API Implementation done in called procedure
4218: since it has multiple call for Locator validation */
4219:
4220: MTL_INV_VALIDATE_GRP.Validate_Locator(
4221: p_api_version => 0.9,
4222: x_return_status => x_return_status,
4223: x_msg_count => x_msg_count,
4224: x_msg_data => x_msg_data,
4831:
4832: IF (l_debug = 1) THEN
4833: mdebug('Process: In Validate_UOMQuantity call Validate_PrimaryUOMQty');
4834: END IF;
4835: MTL_INV_VALIDATE_GRP.Validate_PrimaryUomQuantity
4836: (p_api_version => 0.9,
4837: x_return_status => x_return_status,
4838: x_msg_count => x_msg_count,
4839: x_msg_data => x_msg_data,
4889: IF (l_debug = 1) THEN
4890: mdebug('Process: In Validate_UOMQuantity call Validate_CountUOM: ' || p_count_uom);
4891: END IF;
4892:
4893: MTL_INV_VALIDATE_GRP.Validate_CountUOM(p_api_version => 0.9
4894: , x_msg_count => x_msg_count
4895: , x_msg_data => x_msg_data
4896: , x_return_status => x_return_status
4897: , x_errorcode => x_errorcode
4940:
4941: END IF;
4942:
4943: --mdebug('Process: In Validate_UOMQuantity call Validate_CountQty ');
4944: MTL_INV_VALIDATE_GRP.Validate_CountQuantity(p_api_version => 0.9
4945: , x_return_status => x_return_status
4946: , x_msg_count => x_msg_count
4947: , x_msg_data => x_msg_data
4948: , x_errorcode => x_errorcode
5197: --
5198: IF (l_debug = 1) THEN
5199: mdebug('Process: In Validate_CDate_Counter call Validate Countdate');
5200: END IF;
5201: MTL_INV_VALIDATE_GRP.Validate_CountDate
5202: -- Prozedur
5203: (p_api_version => 0.9
5204: , x_return_status => x_return_status
5205: , x_msg_count => x_msg_count
6444: mdebug ( 'Process: In Validate_SecondaryUOMQty call Validate_SecondaryCountUOM: '
6445: || p_secondary_uom);
6446: END IF;
6447:
6448: mtl_inv_validate_grp.validate_secondarycountuom
6449: (p_api_version => 0.9
6450: , x_msg_count => x_msg_count
6451: , x_msg_data => x_msg_data
6452: , x_return_status => x_return_status
6478: END IF;
6479:
6480: -- Validate Secondary count quantity
6481: -- Need to handle conversions and defaulting
6482: mtl_inv_validate_grp.validate_secondarycountqty
6483: (p_api_version => 0.9
6484: , x_return_status => x_return_status
6485: , x_msg_count => x_msg_count
6486: , x_msg_data => x_msg_data