eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTL_CCEOI_PROCESS_PVT dependencies on INV_VALIDATE

Line 180: mtl_inv_validate_grp.get_offset_date(

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,

Line 3725: MTL_INV_VALIDATE_GRP.Validate_CountHeader(

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,

Line 3766: MTL_INV_VALIDATE_GRP.Get_StockLocatorControlCode(

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;

Line 3910: MTL_INV_VALIDATE_GRP.Validate_CountListSequence(

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,

Line 3939: MTL_INV_VALIDATE_GRP.Get_Item_SKU(

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

Line 3957: MTL_INV_VALIDATE_GRP.Get_Item_SKU(

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: --

Line 4086: L_lot INV_Validate.LOT;

4082: L_P_inventory_item_id NUMBER ;
4083: L_P_locator_id NUMBER ;
4084: L_is_Unscheduled_Request boolean;
4085: --
4086: L_lot INV_Validate.LOT;
4087: L_org INV_Validate.ORG;
4088: L_item INV_Validate.ITEM;
4089: L_sub INV_Validate.SUB;
4090: L_serial INV_Validate.SERIAL;

Line 4087: L_org INV_Validate.ORG;

4083: L_P_locator_id NUMBER ;
4084: L_is_Unscheduled_Request boolean;
4085: --
4086: L_lot INV_Validate.LOT;
4087: L_org INV_Validate.ORG;
4088: L_item INV_Validate.ITEM;
4089: L_sub INV_Validate.SUB;
4090: L_serial INV_Validate.SERIAL;
4091: L_loc INV_Validate.LOCATOR;

Line 4088: L_item INV_Validate.ITEM;

4084: L_is_Unscheduled_Request boolean;
4085: --
4086: L_lot INV_Validate.LOT;
4087: L_org INV_Validate.ORG;
4088: L_item INV_Validate.ITEM;
4089: L_sub INV_Validate.SUB;
4090: L_serial INV_Validate.SERIAL;
4091: L_loc INV_Validate.LOCATOR;
4092: --

Line 4089: L_sub INV_Validate.SUB;

4085: --
4086: L_lot INV_Validate.LOT;
4087: L_org INV_Validate.ORG;
4088: L_item INV_Validate.ITEM;
4089: L_sub INV_Validate.SUB;
4090: L_serial INV_Validate.SERIAL;
4091: L_loc INV_Validate.LOCATOR;
4092: --
4093: --Begin changes 3904722

Line 4090: L_serial INV_Validate.SERIAL;

4086: L_lot INV_Validate.LOT;
4087: L_org INV_Validate.ORG;
4088: L_item INV_Validate.ITEM;
4089: L_sub INV_Validate.SUB;
4090: L_serial INV_Validate.SERIAL;
4091: L_loc INV_Validate.LOCATOR;
4092: --
4093: --Begin changes 3904722
4094: l_ret_value NUMBER;

Line 4091: L_loc INV_Validate.LOCATOR;

4087: L_org INV_Validate.ORG;
4088: L_item INV_Validate.ITEM;
4089: L_sub INV_Validate.SUB;
4090: L_serial INV_Validate.SERIAL;
4091: L_loc INV_Validate.LOCATOR;
4092: --
4093: --Begin changes 3904722
4094: l_ret_value NUMBER;
4095: l_to_serial VARCHAR2(30);

Line 4155: MTL_INV_VALIDATE_GRP.Validate_Item(

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,

Line 4210: MTL_INV_VALIDATE_GRP.Validate_Subinv(

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,

Line 4268: MTL_INV_VALIDATE_GRP.Locator_Control(

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,

Line 4290: MTL_INV_VALIDATE_GRP.Validate_Ctrol(

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,

Line 4362: MTL_INV_VALIDATE_GRP.Validate_Locator(

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,

Line 4431: ELSIF INV_Validate.Revision(p_sku_rec.revision,

4427: l_item.inventory_item_id := MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID;
4428: --
4429: IF p_sku_rec.revision is null then
4430: x_errorcode := 12 ;
4431: ELSIF INV_Validate.Revision(p_sku_rec.revision,
4432: L_org,
4433: L_item
4434: ) = INV_Validate.T then
4435: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION := p_sku_rec.revision;

Line 4434: ) = INV_Validate.T then

4430: x_errorcode := 12 ;
4431: ELSIF INV_Validate.Revision(p_sku_rec.revision,
4432: L_org,
4433: L_item
4434: ) = INV_Validate.T then
4435: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION := p_sku_rec.revision;
4436: x_errorcode := 0;
4437: ELSE
4438: x_errorcode := 12;

Line 4492: ELSIF INV_Validate.Lot_Number(L_lot,

4488: IF p_sku_rec.lot_number is null then
4489: x_errorcode := 13 ;
4490: /* Bug 4735473-Calling the Lot_Number api passing only lot, org and item to
4491: make the behaviour in sync with that on the desktop.
4492: ELSIF INV_Validate.Lot_Number(L_lot,
4493: L_org,
4494: L_item,
4495: L_sub,
4496: L_loc,

Line 4498: ) = INV_Validate.T then */

4494: L_item,
4495: L_sub,
4496: L_loc,
4497: p_sku_rec.revision
4498: ) = INV_Validate.T then */
4499:
4500: ELSIF INV_Validate.Lot_Number(L_lot,
4501: L_org,
4502: L_item

Line 4500: ELSIF INV_Validate.Lot_Number(L_lot,

4496: L_loc,
4497: p_sku_rec.revision
4498: ) = INV_Validate.T then */
4499:
4500: ELSIF INV_Validate.Lot_Number(L_lot,
4501: L_org,
4502: L_item
4503: ) = INV_Validate.T THEN
4504: /* End of fix for Bug 4735473 */

Line 4503: ) = INV_Validate.T THEN

4499:
4500: ELSIF INV_Validate.Lot_Number(L_lot,
4501: L_org,
4502: L_item
4503: ) = INV_Validate.T THEN
4504: /* End of fix for Bug 4735473 */
4505:
4506: MTL_CCEOI_VAR_PVT.G_SKU_REC.Lot_Number := l_lot.lot_number;
4507: MTL_CCEOI_VAR_PVT.G_SKU_REC.expiration_date := l_lot.expiration_date;

Line 4588: ELSIF INV_Validate.validate_serial(l_serial,

4584: ELSIF (MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.SERIAL_COUNT_OPTION = 1) THEN
4585: x_errorcode := 103;
4586: ELSIF p_sku_rec.serial_number is null then
4587: x_errorcode := 15 ;
4588: ELSIF INV_Validate.validate_serial(l_serial,
4589: L_org,
4590: L_item,
4591: L_sub,
4592: L_lot,

Line 4595: ) = INV_Validate.T then

4591: L_sub,
4592: L_lot,
4593: L_loc,
4594: p_sku_rec.revision
4595: ) = INV_Validate.T then
4596: -- needs to be checked whether we should store or not
4597: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER := l_serial.serial_number;
4598: x_errorcode := 0;
4599: --Begin changes 3904722

Line 5006: MTL_INV_VALIDATE_GRP.Validate_PrimaryUomQuantity

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,

Line 5064: MTL_INV_VALIDATE_GRP.Validate_CountUOM(p_api_version => 0.9

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

Line 5115: MTL_INV_VALIDATE_GRP.Validate_CountQuantity(p_api_version => 0.9

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

Line 5341: L_org INV_Validate.ORG;

5337: DECLARE
5338: --
5339: L_message_name VARCHAR2(100);
5340: --
5341: L_org INV_Validate.ORG;
5342: L_api_version CONSTANT NUMBER := 0.9;
5343: L_api_name CONSTANT VARCHAR2(30) := 'Validate_CDate_Counter';
5344: L_emp_id NUMBER := p_employee_id;
5345: L_emp_name VARCHAR2(60) := p_employee_name;

Line 5373: MTL_INV_VALIDATE_GRP.Validate_CountDate

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

Line 6623: mtl_inv_validate_grp.validate_secondarycountuom

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

Line 6657: mtl_inv_validate_grp.validate_secondarycountqty

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