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_INV_VALIDATE_GRP dependencies on MTL_CCEOI_VAR_PVT

Line 201: MTL_CCEOI_VAR_PVT.G_UOM_CODE := p_uom_code;

197: --
198: IF (l_debug = 1) THEN
199: MDEBUG( 'Getting UOM');
200: END IF;
201: MTL_CCEOI_VAR_PVT.G_UOM_CODE := p_uom_code;
202: --
203: END;
204: END;
205: --

Line 244: MTL_CCEOI_VAR_PVT.G_SKU_REC.INVENTORY_ITEM_FLAG :=

240: MDEBUG( 'Getting Control Codes');
241: END IF;
242:
243: -- flag indicating inventory item
244: MTL_CCEOI_VAR_PVT.G_SKU_REC.INVENTORY_ITEM_FLAG :=
245: c_rec.INVENTORY_ITEM_FLAG;
246:
247: -- lot control code for this item (1 - none, 2 - full)
248: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE := c_rec.LOT_CONTROL_CODE;

Line 248: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE := c_rec.LOT_CONTROL_CODE;

244: MTL_CCEOI_VAR_PVT.G_SKU_REC.INVENTORY_ITEM_FLAG :=
245: c_rec.INVENTORY_ITEM_FLAG;
246:
247: -- lot control code for this item (1 - none, 2 - full)
248: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE := c_rec.LOT_CONTROL_CODE;
249: -- revision qty control code (1 - not under revision qty control,
250: -- 2 under revision qty control)
251: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION_QTY_CONTROL_CODE :=
252: c_rec.REVISION_QTY_CONTROL_CODE;

Line 251: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION_QTY_CONTROL_CODE :=

247: -- lot control code for this item (1 - none, 2 - full)
248: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE := c_rec.LOT_CONTROL_CODE;
249: -- revision qty control code (1 - not under revision qty control,
250: -- 2 under revision qty control)
251: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION_QTY_CONTROL_CODE :=
252: c_rec.REVISION_QTY_CONTROL_CODE;
253:
254: -- serial number control code
255: -- 1 - no serial control, 2 - predefined, 5 - dynamic at receipt

Line 257: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE :=

253:
254: -- serial number control code
255: -- 1 - no serial control, 2 - predefined, 5 - dynamic at receipt
256: -- 6 - dynamic at issue
257: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE :=
258: c_rec.SERIAL_NUMBER_CONTROL_CODE;
259:
260: -- allowed unit of measure conversion type
261: -- 1 - item specific, 2 - standard, 3 - both standard and item spec

Line 262: MTL_CCEOI_VAR_PVT.G_SKU_REC.ALLOWED_UNITS_LOOKUP_CODE :=

258: c_rec.SERIAL_NUMBER_CONTROL_CODE;
259:
260: -- allowed unit of measure conversion type
261: -- 1 - item specific, 2 - standard, 3 - both standard and item spec
262: MTL_CCEOI_VAR_PVT.G_SKU_REC.ALLOWED_UNITS_LOOKUP_CODE :=
263: c_rec.ALLOWED_UNITS_LOOKUP_CODE;
264: --
265: END LOOP;
266: --

Line 304: MTL_CCEOI_VAR_PVT.G_STOCK_LOCATOR_CONTROL_CODE :=

300: --
301: IF (l_debug = 1) THEN
302: MDEBUG( 'Getting Locator Control code');
303: END IF;
304: MTL_CCEOI_VAR_PVT.G_STOCK_LOCATOR_CONTROL_CODE :=
305: L_Stock_Locator_Control_code;
306: --
307: END;
308: END;

Line 321: p_adjustaccount_rec IN MTL_CCEOI_VAR_PVT.ADJUSTACCOUNT_REC_TYPE )

317: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
318: x_return_status OUT NOCOPY VARCHAR2 ,
319: x_msg_count OUT NOCOPY NUMBER ,
320: x_msg_data OUT NOCOPY VARCHAR2 ,
321: p_adjustaccount_rec IN MTL_CCEOI_VAR_PVT.ADJUSTACCOUNT_REC_TYPE )
322: IS
323: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
324: BEGIN
325: -- Start OF comments

Line 346: -- p_adjustaccount_rec IN MTL_CCEOI_VAR_PVT.ADJUSTACCOUNT_REC_TYPE (required)

342: --
343: -- p_validation_level IN NUMBER (optional)
344: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,
345: --
346: -- p_adjustaccount_rec IN MTL_CCEOI_VAR_PVT.ADJUSTACCOUNT_REC_TYPE (required)
347: -- the RECORD parameter includes the
348: -- adjustment account
349: -- segments
350: -- OUT :

Line 474: MTL_CCEOI_VAR_PVT.G_ADJUST_ACCOUNT_ID :=

470: --
471: IF (l_debug = 1) THEN
472: MDEBUG( 'Validating Adj Account ID');
473: END IF;
474: MTL_CCEOI_VAR_PVT.G_ADJUST_ACCOUNT_ID :=
475: c_rec. code_combination_id;
476: --
477: L_counter := L_counter + 1;
478: IF L_counter > 1 THEN

Line 517: MTL_CCEOI_VAR_PVT.G_ADJUST_ACCOUNT_ID :=

513: p_adjustaccount_rec.account_segment28,
514: p_adjustaccount_rec.account_segment29,
515: p_adjustaccount_rec.account_segment30) LOOP
516: --
517: MTL_CCEOI_VAR_PVT.G_ADJUST_ACCOUNT_ID :=
518: c_rec. code_combination_id;
519: --
520: L_counter := L_counter + 1;
521: IF L_counter > 1 THEN

Line 713: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID,

709: END IF;
710: END IF;
711:
712: INVTTMTX.TDATECHK(
713: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID,
714: p_count_date,
715: L_period_id,
716: L_open_past_period);
717: IF L_period_id = 0 THEN

Line 737: MTL_CCEOI_VAR_PVT.G_COUNT_DATE := p_count_date;

733: END IF;
734:
735:
736: -- if we're here then the validation went ok so we can store the date
737: MTL_CCEOI_VAR_PVT.G_COUNT_DATE := p_count_date;
738: --
739: -- END of API body
740: -- Standard check of p_commit
741: IF FND_API.to_Boolean(p_commit) THEN

Line 905: MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID := c_rec.cycle_count_header_id;

901: --
902: FOR c_rec IN L_CCHeader_Csr(L_Cycle_Count_Header_ID,
903: L_Cycle_Count_Header_Name) LOOP
904: --
905: MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID := c_rec.cycle_count_header_id;
906: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC := c_rec;
907: --
908: rec_counter := rec_counter + 1;
909: IF(rec_counter > 1) THEN

Line 906: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC := c_rec;

902: FOR c_rec IN L_CCHeader_Csr(L_Cycle_Count_Header_ID,
903: L_Cycle_Count_Header_Name) LOOP
904: --
905: MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID := c_rec.cycle_count_header_id;
906: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC := c_rec;
907: --
908: rec_counter := rec_counter + 1;
909: IF(rec_counter > 1) THEN
910: -- error Cycle COUNT must be unique

Line 917: IF(MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.DISABLE_DATE IS NOT NULL AND

913: END LOOP;
914: --
915: IF(rec_counter = 1) THEN
916: -- Cycle COUNT must be valid, IF NOT error OUT
917: IF(MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.DISABLE_DATE IS NOT NULL AND
918: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.DISABLE_DATE <= sysdate)
919: THEN
920: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_INVALID_HEADER');
921: FND_MSG_PUB.Add;

Line 918: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.DISABLE_DATE <= sysdate)

914: --
915: IF(rec_counter = 1) THEN
916: -- Cycle COUNT must be valid, IF NOT error OUT
917: IF(MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.DISABLE_DATE IS NOT NULL AND
918: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.DISABLE_DATE <= sysdate)
919: THEN
920: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_INVALID_HEADER');
921: FND_MSG_PUB.Add;
922: x_errorcode :=2;

Line 1113: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC := c_rec;

1109: END IF;
1110: FOR c_rec IN L_CCListSequence_Csr(P_Cycle_Count_Header_ID,
1111: P_Count_List_Sequence, p_organization_id) LOOP
1112: --
1113: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC := c_rec;
1114: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION := c_rec.revision;
1115: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER := c_rec.LOT_NUMBER;
1116: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE := c_rec.LOT_CONTROL;
1117: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER := c_rec.SERIAL_NUMBER;

Line 1114: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION := c_rec.revision;

1110: FOR c_rec IN L_CCListSequence_Csr(P_Cycle_Count_Header_ID,
1111: P_Count_List_Sequence, p_organization_id) LOOP
1112: --
1113: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC := c_rec;
1114: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION := c_rec.revision;
1115: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER := c_rec.LOT_NUMBER;
1116: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE := c_rec.LOT_CONTROL;
1117: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER := c_rec.SERIAL_NUMBER;
1118: MTL_CCEOI_VAR_PVT.G_OPEN_REQUEST := TRUE;

Line 1115: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER := c_rec.LOT_NUMBER;

1111: P_Count_List_Sequence, p_organization_id) LOOP
1112: --
1113: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC := c_rec;
1114: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION := c_rec.revision;
1115: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER := c_rec.LOT_NUMBER;
1116: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE := c_rec.LOT_CONTROL;
1117: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER := c_rec.SERIAL_NUMBER;
1118: MTL_CCEOI_VAR_PVT.G_OPEN_REQUEST := TRUE;
1119:

Line 1116: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE := c_rec.LOT_CONTROL;

1112: --
1113: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC := c_rec;
1114: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION := c_rec.revision;
1115: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER := c_rec.LOT_NUMBER;
1116: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE := c_rec.LOT_CONTROL;
1117: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER := c_rec.SERIAL_NUMBER;
1118: MTL_CCEOI_VAR_PVT.G_OPEN_REQUEST := TRUE;
1119:
1120: --

Line 1117: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER := c_rec.SERIAL_NUMBER;

1113: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC := c_rec;
1114: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION := c_rec.revision;
1115: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER := c_rec.LOT_NUMBER;
1116: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE := c_rec.LOT_CONTROL;
1117: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER := c_rec.SERIAL_NUMBER;
1118: MTL_CCEOI_VAR_PVT.G_OPEN_REQUEST := TRUE;
1119:
1120: --
1121: rec_counter := rec_counter + 1;

Line 1118: MTL_CCEOI_VAR_PVT.G_OPEN_REQUEST := TRUE;

1114: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION := c_rec.revision;
1115: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER := c_rec.LOT_NUMBER;
1116: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE := c_rec.LOT_CONTROL;
1117: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER := c_rec.SERIAL_NUMBER;
1118: MTL_CCEOI_VAR_PVT.G_OPEN_REQUEST := TRUE;
1119:
1120: --
1121: rec_counter := rec_counter + 1;
1122: IF(rec_counter > 1 or c_rec.entry_status_code = 2) THEN

Line 1226: -- MTL_CCEOI_VAR_PVT.G_COUNT_QUANTITY

1222: -- Pre-reqs : None
1223: -- FUNCTION :
1224: -- Validates IF the COUNT quanitity IS negative. IF NOT
1225: -- it will be stored INTO the package variable
1226: -- MTL_CCEOI_VAR_PVT.G_COUNT_QUANTITY
1227: -- Parameters:
1228: -- IN :
1229: -- p_api_version IN NUMBER (required)
1230: -- API Version of this procedure

Line 1289: MDEBUG('SRLNoCCD '||to_char(MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE ));

1285: --
1286: -- With Serialized items
1287: IF (l_debug = 1) THEN
1288: MDEBUG( 'Validating Count Qty');
1289: MDEBUG('SRLNoCCD '||to_char(MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE ));
1290: END IF;
1291: IF MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE in (2,5)
1292: THEN
1293: IF p_count_quantity > 1 or p_count_quantity IS NULL THEN

Line 1291: IF MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE in (2,5)

1287: IF (l_debug = 1) THEN
1288: MDEBUG( 'Validating Count Qty');
1289: MDEBUG('SRLNoCCD '||to_char(MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE ));
1290: END IF;
1291: IF MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE in (2,5)
1292: THEN
1293: IF p_count_quantity > 1 or p_count_quantity IS NULL THEN
1294: IF (l_debug = 1) THEN
1295: MDEBUG( 'Validating CQty > 1 or NULL');

Line 1323: MTL_CCEOI_VAR_PVT.G_COUNT_QUANTITY := p_count_quantity;

1319: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_NEG_QTY');
1320: FND_MSG_PUB.Add;
1321: RAISE FND_API.G_EXC_ERROR;
1322: ELSE
1323: MTL_CCEOI_VAR_PVT.G_COUNT_QUANTITY := p_count_quantity;
1324: END IF;
1325: --
1326: -- END of API body
1327: -- Standard check of p_commit

Line 1388: p_locator_rec IN MTL_CCEOI_VAR_PVT.INV_LOCATOR_REC_TYPE ,

1384: x_msg_data OUT NOCOPY VARCHAR2 ,
1385: x_errorcode OUT NOCOPY NUMBER ,
1386: p_inventory_item_id IN NUMBER ,
1387: p_organization_id IN NUMBER ,
1388: p_locator_rec IN MTL_CCEOI_VAR_PVT.INV_LOCATOR_REC_TYPE ,
1389: p_lot_number IN VARCHAR2 ,
1390: p_revision IN VARCHAR2 ,
1391: p_serial_number IN VARCHAR2 ,
1392: p_locator_control IN NUMBER ) -- XXX not used inside!

Line 1407: -- package MTL_CCEOI_VAR_PVT are populated, no selection

1403: -- E.g. IF the item IS under lot control, so the lot NUMBER
1404: -- must be populated.
1405: -- The control information will be selected FROM the TABLE
1406: -- MTL_SYSTEM_ITEMS, but IF the global variables OF the
1407: -- package MTL_CCEOI_VAR_PVT are populated, no selection
1408: -- IS neccessary.
1409: -- Parameters:
1410: -- IN :
1411: -- p_api_version IN NUMBER (required)

Line 1428: -- p_locator_rec MTL_CCEOI_VAR_PVT.INV_LOCATOR_REC (required)

1424: -- inventory item id
1425: --
1426: -- p_organization_id IN NUMBER (required)
1427: --
1428: -- p_locator_rec MTL_CCEOI_VAR_PVT.INV_LOCATOR_REC (required)
1429: -- Locator information with segments
1430: --
1431: -- p_lot_number IN VARCHAR2 (required)
1432: -- Lot NUMBER

Line 1511: MDEBUG( 'Loc Ctrl1'||to_char(MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE));

1507: -- SELECT information FROM MTL_SYSTEM_ITEMS
1508: FOR x IN L_ItemCtrlInfo_Csr(p_inventory_item_id,
1509: p_organization_id) LOOP
1510: IF (l_debug = 1) THEN
1511: MDEBUG( 'Loc Ctrl1'||to_char(MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE));
1512: END IF;
1513: if MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE
1514: is null then
1515: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE := x.LOCATION_CONTROL_CODE;

Line 1513: if MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE

1509: p_organization_id) LOOP
1510: IF (l_debug = 1) THEN
1511: MDEBUG( 'Loc Ctrl1'||to_char(MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE));
1512: END IF;
1513: if MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE
1514: is null then
1515: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE := x.LOCATION_CONTROL_CODE;
1516: IF (l_debug = 1) THEN
1517: MDEBUG( 'Loc Ctrl2'||to_char(MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE));

Line 1515: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE := x.LOCATION_CONTROL_CODE;

1511: MDEBUG( 'Loc Ctrl1'||to_char(MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE));
1512: END IF;
1513: if MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE
1514: is null then
1515: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE := x.LOCATION_CONTROL_CODE;
1516: IF (l_debug = 1) THEN
1517: MDEBUG( 'Loc Ctrl2'||to_char(MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE));
1518: END IF;
1519: END IF;

Line 1517: MDEBUG( 'Loc Ctrl2'||to_char(MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE));

1513: if MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE
1514: is null then
1515: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE := x.LOCATION_CONTROL_CODE;
1516: IF (l_debug = 1) THEN
1517: MDEBUG( 'Loc Ctrl2'||to_char(MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE));
1518: END IF;
1519: END IF;
1520: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE := x.LOCATION_CONTROL_CODE;
1521: IF (l_debug = 1) THEN

Line 1520: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE := x.LOCATION_CONTROL_CODE;

1516: IF (l_debug = 1) THEN
1517: MDEBUG( 'Loc Ctrl2'||to_char(MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE));
1518: END IF;
1519: END IF;
1520: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE := x.LOCATION_CONTROL_CODE;
1521: IF (l_debug = 1) THEN
1522: MDEBUG( 'Loc Ctrl X '||to_char(x.LOCATION_CONTROL_CODE));
1523: END IF;
1524: --

Line 1525: IF MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE

1521: IF (l_debug = 1) THEN
1522: MDEBUG( 'Loc Ctrl X '||to_char(x.LOCATION_CONTROL_CODE));
1523: END IF;
1524: --
1525: IF MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE
1526: IS NULL THEN
1527: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE :=
1528: x.SERIAL_NUMBER_CONTROL_CODE;
1529: END IF;

Line 1527: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE :=

1523: END IF;
1524: --
1525: IF MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE
1526: IS NULL THEN
1527: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE :=
1528: x.SERIAL_NUMBER_CONTROL_CODE;
1529: END IF;
1530: IF MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION_QTY_CONTROL_CODE
1531: IS NULL THEN

Line 1530: IF MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION_QTY_CONTROL_CODE

1526: IS NULL THEN
1527: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE :=
1528: x.SERIAL_NUMBER_CONTROL_CODE;
1529: END IF;
1530: IF MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION_QTY_CONTROL_CODE
1531: IS NULL THEN
1532: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION_QTY_CONTROL_CODE :=
1533: x.REVISION_QTY_CONTROL_CODE;
1534: END IF;

Line 1532: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION_QTY_CONTROL_CODE :=

1528: x.SERIAL_NUMBER_CONTROL_CODE;
1529: END IF;
1530: IF MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION_QTY_CONTROL_CODE
1531: IS NULL THEN
1532: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION_QTY_CONTROL_CODE :=
1533: x.REVISION_QTY_CONTROL_CODE;
1534: END IF;
1535: IF MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE IS NULL THEN
1536: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE :=

Line 1535: IF MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE IS NULL THEN

1531: IS NULL THEN
1532: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION_QTY_CONTROL_CODE :=
1533: x.REVISION_QTY_CONTROL_CODE;
1534: END IF;
1535: IF MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE IS NULL THEN
1536: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE :=
1537: x.LOT_CONTROL_CODE;
1538: END IF;
1539: IF (l_debug = 1) THEN

Line 1536: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE :=

1532: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION_QTY_CONTROL_CODE :=
1533: x.REVISION_QTY_CONTROL_CODE;
1534: END IF;
1535: IF MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE IS NULL THEN
1536: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE :=
1537: x.LOT_CONTROL_CODE;
1538: END IF;
1539: IF (l_debug = 1) THEN
1540: MDEBUG( 'Validating Ctrl Loop');

Line 1558: -- IF MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE IN(2, 3)

1554: MDEBUG( 'Validating Ctrl Loop'||to_char(p_locator_rec.locator_id));
1555: END IF;
1556: --
1557: -- Check IF all VALUES are populated
1558: -- IF MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE IN(2, 3)
1559: IF p_locator_control in (2, 3) then
1560: IF (p_locator_rec.locator_id IS NULL AND
1561: p_locator_rec.locator_segment1 IS NULL and
1562: p_locator_rec.locator_segment2 IS NULL and

Line 1602: IF MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE IN (2,5)

1598:
1599: -- SERIAL
1600:
1601:
1602: IF MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE IN (2,5)
1603: AND p_serial_number IS NULL THEN
1604:
1605: IF (l_debug = 1) THEN
1606: MDEBUG( 'Validating serial_control but no serial number');

Line 1614: ELSIF MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE = 0 THEN

1610: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_NO_SERIAL');
1611: FND_MSG_PUB.Add;
1612: RAISE FND_API.G_EXC_ERROR;
1613:
1614: ELSIF MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE = 0 THEN
1615: --XXX it should not ever be 0
1616: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER := NULL;
1617: END IF;
1618:

Line 1616: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER := NULL;

1612: RAISE FND_API.G_EXC_ERROR;
1613:
1614: ELSIF MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE = 0 THEN
1615: --XXX it should not ever be 0
1616: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER := NULL;
1617: END IF;
1618:
1619:
1620: -- REVISION

Line 1623: IF MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION_QTY_CONTROL_CODE = 2

1619:
1620: -- REVISION
1621:
1622:
1623: IF MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION_QTY_CONTROL_CODE = 2
1624: AND p_revision IS NULL THEN
1625:
1626: IF (l_debug = 1) THEN
1627: MDEBUG( 'Validating revision_control but no revision');

Line 1634: ELSIF MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION_QTY_CONTROL_CODE = 1 THEN

1630: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_NO_REV');
1631: FND_MSG_PUB.Add;
1632: RAISE FND_API.G_EXC_ERROR;
1633: --
1634: ELSIF MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION_QTY_CONTROL_CODE = 1 THEN
1635: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION := NULL;
1636: END IF;
1637:
1638:

Line 1635: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION := NULL;

1631: FND_MSG_PUB.Add;
1632: RAISE FND_API.G_EXC_ERROR;
1633: --
1634: ELSIF MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION_QTY_CONTROL_CODE = 1 THEN
1635: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION := NULL;
1636: END IF;
1637:
1638:
1639: -- LOT

Line 1642: IF MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE= 2

1638:
1639: -- LOT
1640:
1641:
1642: IF MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE= 2
1643: AND p_lot_number IS NULL THEN
1644: --
1645: IF (l_debug = 1) THEN
1646: MDEBUG( 'Validating lot_control but no lot');

Line 1653: ELSIF MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE= 1 THEN

1649: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_NO_LOT');
1650: FND_MSG_PUB.Add;
1651: RAISE FND_API.G_EXC_ERROR;
1652: --
1653: ELSIF MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE= 1 THEN
1654: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER := NULL;
1655: END IF;
1656: --
1657: -- END of API body

Line 1654: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER := NULL;

1650: FND_MSG_PUB.Add;
1651: RAISE FND_API.G_EXC_ERROR;
1652: --
1653: ELSIF MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE= 1 THEN
1654: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER := NULL;
1655: END IF;
1656: --
1657: -- END of API body
1658: -- Standard check of p_commit

Line 1843: MTL_CCEOI_VAR_PVT.G_UOM_CODE := c_rec.uom_code;

1839: --
1840: FOR c_rec IN L_ItemUom_Csr(L_uom, L_unit_of_measure, p_organization_id,
1841: p_inventory_item_id) LOOP
1842: --
1843: MTL_CCEOI_VAR_PVT.G_UOM_CODE := c_rec.uom_code;
1844: L_counter := L_counter + 1;
1845: --
1846: END LOOP;
1847: --

Line 1912: p_inventory_item_rec IN MTL_CCEOI_VAR_PVT.INV_ITEM_REC_TYPE ,

1908: x_return_status OUT NOCOPY VARCHAR2 ,
1909: x_msg_count OUT NOCOPY NUMBER ,
1910: x_msg_data OUT NOCOPY VARCHAR2 ,
1911: x_errorcode OUT NOCOPY NUMBER ,
1912: p_inventory_item_rec IN MTL_CCEOI_VAR_PVT.INV_ITEM_REC_TYPE ,
1913: p_organization_id IN NUMBER ,
1914: p_cycle_count_header_id IN NUMBER DEFAULT NULL)
1915: IS
1916: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 1943: -- p_inventory_item_rec IN MTL_CCEOI_VAR_PVT.INV_ITEM_REC_TYPE (required)

1939: --
1940: -- p_validation_level IN NUMBER (optional)
1941: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,
1942: --
1943: -- p_inventory_item_rec IN MTL_CCEOI_VAR_PVT.INV_ITEM_REC_TYPE (required)
1944: -- Item information with segments
1945: --
1946: -- p_organization_id IN NUMBER (required)
1947: -- organization ID

Line 2052: MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID :=

2048:
2049: IF (l_debug = 1) THEN
2050: MDEBUG( 'Validating Item-3');
2051: END IF;
2052: MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID :=
2053: l_item.inventory_item_id;
2054: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION_QTY_CONTROL_CODE :=
2055: l_item.REVISION_QTY_CONTROL_CODE;
2056: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE :=

Line 2054: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION_QTY_CONTROL_CODE :=

2050: MDEBUG( 'Validating Item-3');
2051: END IF;
2052: MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID :=
2053: l_item.inventory_item_id;
2054: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION_QTY_CONTROL_CODE :=
2055: l_item.REVISION_QTY_CONTROL_CODE;
2056: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE :=
2057: l_item.LOT_CONTROL_CODE;
2058: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE :=

Line 2056: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE :=

2052: MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID :=
2053: l_item.inventory_item_id;
2054: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION_QTY_CONTROL_CODE :=
2055: l_item.REVISION_QTY_CONTROL_CODE;
2056: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE :=
2057: l_item.LOT_CONTROL_CODE;
2058: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE :=
2059: l_item.SERIAL_NUMBER_CONTROL_CODE;
2060: MTL_CCEOI_VAR_PVT.G_SKU_REC.ALLOWED_UNITS_LOOKUP_CODE :=

Line 2058: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE :=

2054: MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION_QTY_CONTROL_CODE :=
2055: l_item.REVISION_QTY_CONTROL_CODE;
2056: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE :=
2057: l_item.LOT_CONTROL_CODE;
2058: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE :=
2059: l_item.SERIAL_NUMBER_CONTROL_CODE;
2060: MTL_CCEOI_VAR_PVT.G_SKU_REC.ALLOWED_UNITS_LOOKUP_CODE :=
2061: l_item.ALLOWED_UNITS_LOOKUP_CODE;
2062: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE :=

Line 2060: MTL_CCEOI_VAR_PVT.G_SKU_REC.ALLOWED_UNITS_LOOKUP_CODE :=

2056: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_CONTROL_CODE :=
2057: l_item.LOT_CONTROL_CODE;
2058: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE :=
2059: l_item.SERIAL_NUMBER_CONTROL_CODE;
2060: MTL_CCEOI_VAR_PVT.G_SKU_REC.ALLOWED_UNITS_LOOKUP_CODE :=
2061: l_item.ALLOWED_UNITS_LOOKUP_CODE;
2062: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE :=
2063: l_item.LOCATION_CONTROL_CODE;
2064: MTL_CCEOI_VAR_PVT.G_SKU_REC.RESTRICT_LOCATORS_CODE :=

Line 2062: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE :=

2058: MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER_CONTROL_CODE :=
2059: l_item.SERIAL_NUMBER_CONTROL_CODE;
2060: MTL_CCEOI_VAR_PVT.G_SKU_REC.ALLOWED_UNITS_LOOKUP_CODE :=
2061: l_item.ALLOWED_UNITS_LOOKUP_CODE;
2062: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE :=
2063: l_item.LOCATION_CONTROL_CODE;
2064: MTL_CCEOI_VAR_PVT.G_SKU_REC.RESTRICT_LOCATORS_CODE :=
2065: l_item.RESTRICT_LOCATORS_CODE;
2066: MTL_CCEOI_VAR_PVT.G_PRIMARY_UOM_CODE := l_item.primary_uom_code;

Line 2064: MTL_CCEOI_VAR_PVT.G_SKU_REC.RESTRICT_LOCATORS_CODE :=

2060: MTL_CCEOI_VAR_PVT.G_SKU_REC.ALLOWED_UNITS_LOOKUP_CODE :=
2061: l_item.ALLOWED_UNITS_LOOKUP_CODE;
2062: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE :=
2063: l_item.LOCATION_CONTROL_CODE;
2064: MTL_CCEOI_VAR_PVT.G_SKU_REC.RESTRICT_LOCATORS_CODE :=
2065: l_item.RESTRICT_LOCATORS_CODE;
2066: MTL_CCEOI_VAR_PVT.G_PRIMARY_UOM_CODE := l_item.primary_uom_code;
2067: L_counter := L_counter + 1;
2068: x_errorcode := 0;

Line 2066: MTL_CCEOI_VAR_PVT.G_PRIMARY_UOM_CODE := l_item.primary_uom_code;

2062: MTL_CCEOI_VAR_PVT.G_SKU_REC.LOCATION_CONTROL_CODE :=
2063: l_item.LOCATION_CONTROL_CODE;
2064: MTL_CCEOI_VAR_PVT.G_SKU_REC.RESTRICT_LOCATORS_CODE :=
2065: l_item.RESTRICT_LOCATORS_CODE;
2066: MTL_CCEOI_VAR_PVT.G_PRIMARY_UOM_CODE := l_item.primary_uom_code;
2067: L_counter := L_counter + 1;
2068: x_errorcode := 0;
2069: END IF;
2070: IF (l_debug = 1) THEN

Line 2084: FOR c_rec IN L_CCItemsID_Crs(MTL_CCEOI_VAR_PVT.G_inventory_item_id,

2080: L_counter := 0;
2081: --
2082: -- check IF the item IS present IN mtl_cycle_count_items
2083: if p_cycle_count_header_id is not null then
2084: FOR c_rec IN L_CCItemsID_Crs(MTL_CCEOI_VAR_PVT.G_inventory_item_id,
2085: p_cycle_count_header_id) LOOP
2086: --
2087: L_counter := L_counter +1;
2088: IF L_counter > 1 THEN

Line 2161: p_locator_rec IN MTL_CCEOI_VAR_PVT.INV_LOCATOR_REC_TYPE ,

2157: x_return_status OUT NOCOPY VARCHAR2 ,
2158: x_msg_count OUT NOCOPY NUMBER ,
2159: x_msg_data OUT NOCOPY VARCHAR2 ,
2160: x_errorcode OUT NOCOPY NUMBER ,
2161: p_locator_rec IN MTL_CCEOI_VAR_PVT.INV_LOCATOR_REC_TYPE ,
2162: p_organization_id IN NUMBER ,
2163: P_subinventory IN VARCHAR2 ,
2164: p_inventory_item_id IN NUMBER ,
2165: p_locator_control IN NUMBER ,

Line 2191: -- p_locator_rec MTL_CCEOI_VAR_PVT.INV_LOCATOR_REC_TYPE (required)

2187: --
2188: -- p_validation_level IN NUMBER (optional)
2189: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL,
2190: --
2191: -- p_locator_rec MTL_CCEOI_VAR_PVT.INV_LOCATOR_REC_TYPE (required)
2192: -- Locator information with segments
2193: --
2194: -- p_organization_id IN NUMBER (required)
2195: -- organization ID

Line 2266: l_item.inventory_item_id := MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID;

2262: --
2263: -- API body
2264: l_org.organization_id := p_organization_id;
2265: l_sub.secondary_inventory_name := p_subinventory;
2266: l_item.inventory_item_id := MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID;
2267: l_loc.inventory_location_id := p_locator_rec.locator_id;
2268: l_loc.segment1 := p_locator_rec.locator_segment1;
2269: l_loc.segment2 := p_locator_rec.locator_segment2;
2270: l_loc.segment3 := p_locator_rec.locator_segment3;

Line 2305: MTL_CCEOI_VAR_PVT.G_LOCATOR_ID := l_loc.inventory_location_id;

2301: MDEBUG( 'Validating Locator Id and Segments ');
2302: END IF;
2303: IF INV_Validate.validateLocator(l_loc,l_org,l_sub,L_dynamic_not_ok)
2304: = INV_Validate.T then
2305: MTL_CCEOI_VAR_PVT.G_LOCATOR_ID := l_loc.inventory_location_id;
2306: IF (l_debug = 1) THEN
2307: MDEBUG( 'Valid Locator Id and Segments ');
2308: END IF;
2309: L_counter := L_counter + 1;

Line 2314: MDEBUG( 'Validating Locator DynLoc2'||to_char(MTL_CCEOI_VAR_PVT.G_STOCK_LOCATOR_CONTROL_CODE));

2310: END IF;
2311: --
2312: IF (l_debug = 1) THEN
2313: MDEBUG( 'Validating Locator DynLoc1'||to_char(p_locator_control));
2314: MDEBUG( 'Validating Locator DynLoc2'||to_char(MTL_CCEOI_VAR_PVT.G_STOCK_LOCATOR_CONTROL_CODE));
2315: END IF;
2316: IF L_counter = 0 THEN
2317: IF (l_debug = 1) THEN
2318: MDEBUG( 'Validating Locator DynLocLvl '||to_char(p_restrict_control));

Line 2336: MTL_CCEOI_VAR_PVT.G_LOCATOR_ID := l_loc.inventory_location_id;

2332: MDEBUG( 'Validating Locator DynLoc - Yes' );
2333: END IF;
2334: IF INV_Validate.validateLocator(l_loc,l_org,l_sub,l_dynamic_ok)
2335: = INV_Validate.T then
2336: MTL_CCEOI_VAR_PVT.G_LOCATOR_ID := l_loc.inventory_location_id;
2337: ELSE
2338: IF (l_debug = 1) THEN
2339: mdebug('Error ');
2340: END IF;

Line 2522: MTL_CCEOI_VAR_PVT.G_UOM_CODE := MTL_CCEOI_VAR_PVT.G_PRIMARY_UOM_CODE;

2518: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_NO_UOM');
2519: FND_MSG_PUB.Add;
2520: RAISE FND_API.G_EXC_ERROR;
2521: ELSE
2522: MTL_CCEOI_VAR_PVT.G_UOM_CODE := MTL_CCEOI_VAR_PVT.G_PRIMARY_UOM_CODE;
2523: Validate_CountQuantity(
2524: p_api_version => 0.9,
2525: x_return_status => x_return_status,
2526: x_msg_count => x_msg_count,

Line 2592: p_orientation_code IN NUMBER DEFAULT MTL_CCEOI_VAR_PVT.G_ORIENTATION_CODE,

2588: x_msg_data OUT NOCOPY VARCHAR2 ,
2589: x_errorcode OUT NOCOPY NUMBER ,
2590: p_subinventory IN VARCHAR2 ,
2591: p_organization_id IN NUMBER,
2592: p_orientation_code IN NUMBER DEFAULT MTL_CCEOI_VAR_PVT.G_ORIENTATION_CODE,
2593: p_cycle_count_header_id IN NUMBER DEFAULT MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID)
2594: IS
2595: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2596: BEGIN

Line 2593: p_cycle_count_header_id IN NUMBER DEFAULT MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID)

2589: x_errorcode OUT NOCOPY NUMBER ,
2590: p_subinventory IN VARCHAR2 ,
2591: p_organization_id IN NUMBER,
2592: p_orientation_code IN NUMBER DEFAULT MTL_CCEOI_VAR_PVT.G_ORIENTATION_CODE,
2593: p_cycle_count_header_id IN NUMBER DEFAULT MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID)
2594: IS
2595: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2596: BEGIN
2597: -- Start OF comments

Line 2623: -- MTL_CCEOI_VAR_PVT.G_ORIENTATION_CODE,

2619: -- subinventory OF the item
2620: --
2621: -- p_orientation_code IN NUMBER (required - defaulted)
2622: -- defaulted =
2623: -- MTL_CCEOI_VAR_PVT.G_ORIENTATION_CODE,
2624: -- 1 = organization level
2625: -- 2 = subinventory level
2626: --
2627: -- p_cycle_count_header_id IN NUMBER (required - defaulted)

Line 2629: -- MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID

2625: -- 2 = subinventory level
2626: --
2627: -- p_cycle_count_header_id IN NUMBER (required - defaulted)
2628: -- default =
2629: -- MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID
2630: --
2631: --
2632: -- OUT :
2633: -- X_return_status OUT NUMBER

Line 2706: MTL_CCEOI_VAR_PVT.G_SUB_LOCATOR_TYPE := l_sub.LOCATOR_TYPE;

2702: l_org.organization_id := p_organization_id;
2703: l_sub.secondary_inventory_name := p_subinventory ;
2704: --
2705: IF INV_Validate.subinventory(L_sub,L_org) = INV_Validate.T then
2706: MTL_CCEOI_VAR_PVT.G_SUB_LOCATOR_TYPE := l_sub.LOCATOR_TYPE;
2707: IF l_sub.QUANTITY_TRACKED <> 1 THEN
2708: x_errorcode := 8;
2709: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_NON_QTY_TRKD_SUB');
2710: FND_MSG_PUB.Add;

Line 2744: mtl_cceoi_var_pvt.G_SUBINVENTORY := p_subinventory;

2740: END IF;
2741:
2742: -- if validation went ok set global subinventory variable to
2743: -- the current validated subinventory
2744: mtl_cceoi_var_pvt.G_SUBINVENTORY := p_subinventory;
2745: --
2746: --
2747: -- END of API body
2748: -- Standard check of p_commit

Line 3453: MTL_CCEOI_VAR_PVT.g_secondary_count_uom := MTL_CCEOI_VAR_PVT.g_secondary_uom_code;

3449: x_errorcode := 0;
3450:
3451: --
3452: IF p_secondary_uom IS NULL AND p_secondary_unit_of_measure IS NULL THEN
3453: MTL_CCEOI_VAR_PVT.g_secondary_count_uom := MTL_CCEOI_VAR_PVT.g_secondary_uom_code;
3454: ELSIF p_secondary_uom IS NOT NULL AND p_secondary_unit_of_measure IS NULL THEN
3455: l_secondary_uom := p_secondary_uom;
3456: l_secondary_unit_of_measure := NULL;
3457: ELSIF p_secondary_uom IS NULL AND p_secondary_unit_of_measure IS NOT NULL THEN

Line 3470: IF l_secondary_uom <> MTL_CCEOI_VAR_PVT.g_secondary_uom_code THEN

3466: FETCH l_itemuom_csr INTO l_secondary_uom;
3467: CLOSE l_itemuom_csr;
3468: END IF;
3469:
3470: IF l_secondary_uom <> MTL_CCEOI_VAR_PVT.g_secondary_uom_code THEN
3471: x_errorcode := 20;
3472: fnd_message.set_name ('INV', 'INV_INCORRECT_SECONDARY_UOM');
3473: fnd_msg_pub.ADD;
3474: RAISE fnd_api.g_exc_error;

Line 3478: MTL_CCEOI_VAR_PVT.g_secondary_count_uom := l_secondary_uom;

3474: RAISE fnd_api.g_exc_error;
3475: END IF;
3476:
3477: --
3478: MTL_CCEOI_VAR_PVT.g_secondary_count_uom := l_secondary_uom;
3479:
3480: IF fnd_api.to_boolean (p_commit) THEN
3481: COMMIT;
3482: END IF;

Line 3574: MTL_CCEOI_VAR_PVT.g_secondary_count_quantity := l_converted_qty;

3570: fnd_msg_pub.ADD;
3571: RAISE fnd_api.g_exc_error;
3572: END IF;
3573:
3574: MTL_CCEOI_VAR_PVT.g_secondary_count_quantity := l_converted_qty;
3575:
3576: ELSE -- p_secondary_quantity IS NOT NULL
3577: IF p_secondary_quantity < 0 THEN
3578: x_errorcode := 52;

Line 3603: MTL_CCEOI_VAR_PVT.g_secondary_count_quantity := p_secondary_quantity;

3599: fnd_msg_pub.ADD;
3600: RAISE fnd_api.g_exc_error;
3601: END IF;
3602:
3603: MTL_CCEOI_VAR_PVT.g_secondary_count_quantity := p_secondary_quantity;
3604: END IF;
3605:
3606: IF fnd_api.to_boolean (p_commit) THEN
3607: COMMIT;