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 121: mtl_inv_validate_grp.get_offset_date(

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,

Line 3584: MTL_INV_VALIDATE_GRP.Validate_CountHeader(

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,

Line 3625: MTL_INV_VALIDATE_GRP.Get_StockLocatorControlCode(

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;

Line 3769: MTL_INV_VALIDATE_GRP.Validate_CountListSequence(

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,

Line 3798: MTL_INV_VALIDATE_GRP.Get_Item_SKU(

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

Line 3816: MTL_INV_VALIDATE_GRP.Get_Item_SKU(

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

Line 3945: L_lot INV_Validate.LOT;

3941: L_P_inventory_item_id NUMBER ;
3942: L_P_locator_id NUMBER ;
3943: L_is_Unscheduled_Request boolean;
3944: --
3945: L_lot INV_Validate.LOT;
3946: L_org INV_Validate.ORG;
3947: L_item INV_Validate.ITEM;
3948: L_sub INV_Validate.SUB;
3949: L_serial INV_Validate.SERIAL;

Line 3946: L_org INV_Validate.ORG;

3942: L_P_locator_id NUMBER ;
3943: L_is_Unscheduled_Request boolean;
3944: --
3945: L_lot INV_Validate.LOT;
3946: L_org INV_Validate.ORG;
3947: L_item INV_Validate.ITEM;
3948: L_sub INV_Validate.SUB;
3949: L_serial INV_Validate.SERIAL;
3950: L_loc INV_Validate.LOCATOR;

Line 3947: L_item INV_Validate.ITEM;

3943: L_is_Unscheduled_Request boolean;
3944: --
3945: L_lot INV_Validate.LOT;
3946: L_org INV_Validate.ORG;
3947: L_item INV_Validate.ITEM;
3948: L_sub INV_Validate.SUB;
3949: L_serial INV_Validate.SERIAL;
3950: L_loc INV_Validate.LOCATOR;
3951: --

Line 3948: L_sub INV_Validate.SUB;

3944: --
3945: L_lot INV_Validate.LOT;
3946: L_org INV_Validate.ORG;
3947: L_item INV_Validate.ITEM;
3948: L_sub INV_Validate.SUB;
3949: L_serial INV_Validate.SERIAL;
3950: L_loc INV_Validate.LOCATOR;
3951: --
3952: --Begin changes 3904722

Line 3949: L_serial INV_Validate.SERIAL;

3945: L_lot INV_Validate.LOT;
3946: L_org INV_Validate.ORG;
3947: L_item INV_Validate.ITEM;
3948: L_sub INV_Validate.SUB;
3949: L_serial INV_Validate.SERIAL;
3950: L_loc INV_Validate.LOCATOR;
3951: --
3952: --Begin changes 3904722
3953: l_ret_value NUMBER;

Line 3950: L_loc INV_Validate.LOCATOR;

3946: L_org INV_Validate.ORG;
3947: L_item INV_Validate.ITEM;
3948: L_sub INV_Validate.SUB;
3949: L_serial INV_Validate.SERIAL;
3950: L_loc INV_Validate.LOCATOR;
3951: --
3952: --Begin changes 3904722
3953: l_ret_value NUMBER;
3954: l_to_serial VARCHAR2(30);

Line 4013: MTL_INV_VALIDATE_GRP.Validate_Item(

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,

Line 4068: MTL_INV_VALIDATE_GRP.Validate_Subinv(

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,

Line 4126: MTL_INV_VALIDATE_GRP.Locator_Control(

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,

Line 4148: MTL_INV_VALIDATE_GRP.Validate_Ctrol(

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,

Line 4220: MTL_INV_VALIDATE_GRP.Validate_Locator(

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,

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

4285: l_item.inventory_item_id := MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID;
4286: --
4287: IF p_sku_rec.revision is null then
4288: x_errorcode := 12 ;
4289: ELSIF INV_Validate.Revision(p_sku_rec.revision,
4290: L_org,
4291: L_item
4292: ) = INV_Validate.T then
4293: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION := p_sku_rec.revision;

Line 4292: ) = INV_Validate.T then

4288: x_errorcode := 12 ;
4289: ELSIF INV_Validate.Revision(p_sku_rec.revision,
4290: L_org,
4291: L_item
4292: ) = INV_Validate.T then
4293: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION := p_sku_rec.revision;
4294: x_errorcode := 0;
4295: ELSE
4296: x_errorcode := 12;

Line 4350: ELSIF INV_Validate.Lot_Number(L_lot,

4346: IF p_sku_rec.lot_number is null then
4347: x_errorcode := 13 ;
4348: /* Bug 4735473-Calling the Lot_Number api passing only lot, org and item to
4349: make the behaviour in sync with that on the desktop.
4350: ELSIF INV_Validate.Lot_Number(L_lot,
4351: L_org,
4352: L_item,
4353: L_sub,
4354: L_loc,

Line 4356: ) = INV_Validate.T then */

4352: L_item,
4353: L_sub,
4354: L_loc,
4355: p_sku_rec.revision
4356: ) = INV_Validate.T then */
4357:
4358: ELSIF INV_Validate.Lot_Number(L_lot,
4359: L_org,
4360: L_item

Line 4358: ELSIF INV_Validate.Lot_Number(L_lot,

4354: L_loc,
4355: p_sku_rec.revision
4356: ) = INV_Validate.T then */
4357:
4358: ELSIF INV_Validate.Lot_Number(L_lot,
4359: L_org,
4360: L_item
4361: ) = INV_Validate.T THEN
4362: /* End of fix for Bug 4735473 */

Line 4361: ) = INV_Validate.T THEN

4357:
4358: ELSIF INV_Validate.Lot_Number(L_lot,
4359: L_org,
4360: L_item
4361: ) = INV_Validate.T THEN
4362: /* End of fix for Bug 4735473 */
4363:
4364: MTL_CCEOI_VAR_PVT.G_SKU_REC.Lot_Number := l_lot.lot_number;
4365: MTL_CCEOI_VAR_PVT.G_SKU_REC.expiration_date := l_lot.expiration_date;

Line 4445: ELSIF INV_Validate.validate_serial(l_serial,

4441: ELSIF (MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.SERIAL_COUNT_OPTION = 1) THEN
4442: x_errorcode := 103;
4443: ELSIF p_sku_rec.serial_number is null then
4444: x_errorcode := 15 ;
4445: ELSIF INV_Validate.validate_serial(l_serial,
4446: L_org,
4447: L_item,
4448: L_sub,
4449: L_lot,

Line 4452: ) = INV_Validate.T then

4448: L_sub,
4449: L_lot,
4450: L_loc,
4451: p_sku_rec.revision
4452: ) = INV_Validate.T then
4453: -- needs to be checked whether we should store or not
4454: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER := l_serial.serial_number;
4455: x_errorcode := 0;
4456: --Begin changes 3904722

Line 4835: MTL_INV_VALIDATE_GRP.Validate_PrimaryUomQuantity

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,

Line 4893: MTL_INV_VALIDATE_GRP.Validate_CountUOM(p_api_version => 0.9

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

Line 4944: MTL_INV_VALIDATE_GRP.Validate_CountQuantity(p_api_version => 0.9

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

Line 5170: L_org INV_Validate.ORG;

5166: DECLARE
5167: --
5168: L_message_name VARCHAR2(100);
5169: --
5170: L_org INV_Validate.ORG;
5171: L_api_version CONSTANT NUMBER := 0.9;
5172: L_api_name CONSTANT VARCHAR2(30) := 'Validate_CDate_Counter';
5173: L_emp_id NUMBER := p_employee_id;
5174: L_emp_name VARCHAR2(60) := p_employee_name;

Line 5201: MTL_INV_VALIDATE_GRP.Validate_CountDate

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

Line 5267: ELSIF INV_Validate.Employee(l_emp_id,

5263: IF (l_debug = 1) THEN
5264: mdebug('all null');
5265: END IF;
5266: x_errorcode := 25 ;
5267: ELSIF INV_Validate.Employee(l_emp_id,
5268: l_emp_name,
5269: l_emp_name,
5270: l_org
5271: ) = INV_Validate.T then

Line 5271: ) = INV_Validate.T then

5267: ELSIF INV_Validate.Employee(l_emp_id,
5268: l_emp_name,
5269: l_emp_name,
5270: l_org
5271: ) = INV_Validate.T then
5272: MTL_CCEOI_VAR_PVT.G_EMPLOYEE_ID := l_emp_id;
5273: x_errorcode := 0;
5274: ELSE
5275: x_errorcode := 26;

Line 6448: mtl_inv_validate_grp.validate_secondarycountuom

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

Line 6482: mtl_inv_validate_grp.validate_secondarycountqty

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