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.

[Home] [Help]

APPS.INV_MATERIAL_STATUS_GRP dependencies on INV_CACHE

Line 448: IF inv_cache.set_item_rec(p_organization_id, l_cur_wlc.inventory_item_id) THEN

444: FOR l_cur_wlc IN c_lpn_item LOOP
445: l_serial_controlled := 0;
446: l_serial_status_enabled := 0;
447:
448: IF inv_cache.set_item_rec(p_organization_id, l_cur_wlc.inventory_item_id) THEN
449: inv_trx_util_pub.TRACE('txn allowed or not: .. 120.0','Material Status', 9);
450: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
451: inv_trx_util_pub.TRACE('txn allowed or not: .. 120.1 serial controlled','Material Status', 9);
452: l_serial_controlled := 1; -- Item is serial controlled

Line 450: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN

446: l_serial_status_enabled := 0;
447:
448: IF inv_cache.set_item_rec(p_organization_id, l_cur_wlc.inventory_item_id) THEN
449: inv_trx_util_pub.TRACE('txn allowed or not: .. 120.0','Material Status', 9);
450: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
451: inv_trx_util_pub.TRACE('txn allowed or not: .. 120.1 serial controlled','Material Status', 9);
452: l_serial_controlled := 1; -- Item is serial controlled
453: END IF;
454:

Line 455: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN

451: inv_trx_util_pub.TRACE('txn allowed or not: .. 120.1 serial controlled','Material Status', 9);
452: l_serial_controlled := 1; -- Item is serial controlled
453: END IF;
454:
455: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
456: inv_trx_util_pub.TRACE('txn allowed or not: .. 120.2 serial status enabled-true','Material Status', 9);
457: l_serial_status_enabled := 1;
458: END IF;
459: END IF;

Line 827: if (inv_cache.set_org_rec(p_organization_id)) then

823: END IF;
824: --END INCONV kkillams
825:
826: -- Onhand Material Status Support
827: if (inv_cache.set_org_rec(p_organization_id)) then
828: l_default_status_id := inv_cache.org_rec.default_status_id;
829: end if;
830:
831:

Line 828: l_default_status_id := inv_cache.org_rec.default_status_id;

824: --END INCONV kkillams
825:
826: -- Onhand Material Status Support
827: if (inv_cache.set_org_rec(p_organization_id)) then
828: l_default_status_id := inv_cache.org_rec.default_status_id;
829: end if;
830:
831:
832: -- Call the new CSI Function at the start and disregard if

Line 987: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then

983: return 'Y';
984: end if;
985:
986: -- Onhand Material Status Support
987: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
988: l_default_item_status_id := inv_cache.item_rec.default_material_status_id;
989: end if;
990:
991: /* Bug 6918409 */

Line 988: l_default_item_status_id := inv_cache.item_rec.default_material_status_id;

984: end if;
985:
986: -- Onhand Material Status Support
987: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
988: l_default_item_status_id := inv_cache.item_rec.default_material_status_id;
989: end if;
990:
991: /* Bug 6918409 */
992: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then

Line 992: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then

988: l_default_item_status_id := inv_cache.item_rec.default_material_status_id;
989: end if;
990:
991: /* Bug 6918409 */
992: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
993: if (inv_cache.item_rec.serial_number_control_code not in (1,6)) then
994: l_serial_controlled := 1;
995: end if;
996: end if;

Line 993: if (inv_cache.item_rec.serial_number_control_code not in (1,6)) then

989: end if;
990:
991: /* Bug 6918409 */
992: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
993: if (inv_cache.item_rec.serial_number_control_code not in (1,6)) then
994: l_serial_controlled := 1;
995: end if;
996: end if;
997: /* Bug 6918409 */

Line 1105: elsif inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then

1101:
1102: if (l_count <> 1 ) then
1103: if (l_default_item_status_id is not null) then
1104: g_isa_sub_status_id := l_default_item_status_id;
1105: elsif inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1106: g_isa_sub_status_id := inv_cache.tosub_rec.status_id;
1107: end if;
1108: if (g_debug = 1) then
1109: inv_trx_util_pub.TRACE('sub, l_count is 0, sub_status_id: '||g_isa_sub_status_id, 'INV_MATERIAL_STATUS_GRP', 14);

Line 1106: g_isa_sub_status_id := inv_cache.tosub_rec.status_id;

1102: if (l_count <> 1 ) then
1103: if (l_default_item_status_id is not null) then
1104: g_isa_sub_status_id := l_default_item_status_id;
1105: elsif inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1106: g_isa_sub_status_id := inv_cache.tosub_rec.status_id;
1107: end if;
1108: if (g_debug = 1) then
1109: inv_trx_util_pub.TRACE('sub, l_count is 0, sub_status_id: '||g_isa_sub_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
1110: end if;

Line 1119: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then

1115:
1116: if (g_isa_sub_status_id is null or g_isa_sub_status_id = 0 or g_isa_sub_status_id = -1)
1117: and p_object_type <> 'A' then
1118:
1119: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
1120: if (inv_cache.item_rec.serial_number_control_code in (1,6)) then
1121:
1122: if (g_debug = 1) then
1123: inv_trx_util_pub.TRACE('sub, status is null in MOQD for non-serial controlled item', 'INV_MATERIAL_STATUS_GRP', 14);

Line 1120: if (inv_cache.item_rec.serial_number_control_code in (1,6)) then

1116: if (g_isa_sub_status_id is null or g_isa_sub_status_id = 0 or g_isa_sub_status_id = -1)
1117: and p_object_type <> 'A' then
1118:
1119: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
1120: if (inv_cache.item_rec.serial_number_control_code in (1,6)) then
1121:
1122: if (g_debug = 1) then
1123: inv_trx_util_pub.TRACE('sub, status is null in MOQD for non-serial controlled item', 'INV_MATERIAL_STATUS_GRP', 14);
1124: end if;

Line 1137: elsif ((inv_cache.item_rec.serial_number_control_code not in (1,6)) and g_isa_sub_status_id = -1) then

1133: FND_MSG_PUB.ADD;
1134:
1135: return 'N';
1136:
1137: elsif ((inv_cache.item_rec.serial_number_control_code not in (1,6)) and g_isa_sub_status_id = -1) then
1138: return 'Y';
1139: end if;
1140: end if;
1141: end if;

Line 1307: elsif inv_cache.set_loc_rec(p_organization_id, p_locator_id) then

1303:
1304: if (l_count <> 1 ) then
1305: if (l_default_item_status_id is not null) then
1306: g_isa_loc_status_id := l_default_item_status_id;
1307: elsif inv_cache.set_loc_rec(p_organization_id, p_locator_id) then
1308: if (inv_cache.loc_rec.status_id is not null) then
1309: g_isa_loc_status_id := inv_cache.loc_rec.status_id;
1310: else -- Locator is dynamic
1311: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then

Line 1308: if (inv_cache.loc_rec.status_id is not null) then

1304: if (l_count <> 1 ) then
1305: if (l_default_item_status_id is not null) then
1306: g_isa_loc_status_id := l_default_item_status_id;
1307: elsif inv_cache.set_loc_rec(p_organization_id, p_locator_id) then
1308: if (inv_cache.loc_rec.status_id is not null) then
1309: g_isa_loc_status_id := inv_cache.loc_rec.status_id;
1310: else -- Locator is dynamic
1311: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1312: if (inv_cache.tosub_rec.default_loc_status_id is not null) then

Line 1309: g_isa_loc_status_id := inv_cache.loc_rec.status_id;

1305: if (l_default_item_status_id is not null) then
1306: g_isa_loc_status_id := l_default_item_status_id;
1307: elsif inv_cache.set_loc_rec(p_organization_id, p_locator_id) then
1308: if (inv_cache.loc_rec.status_id is not null) then
1309: g_isa_loc_status_id := inv_cache.loc_rec.status_id;
1310: else -- Locator is dynamic
1311: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1312: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1313: g_isa_loc_status_id := inv_cache.tosub_rec.default_loc_status_id;

Line 1311: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then

1307: elsif inv_cache.set_loc_rec(p_organization_id, p_locator_id) then
1308: if (inv_cache.loc_rec.status_id is not null) then
1309: g_isa_loc_status_id := inv_cache.loc_rec.status_id;
1310: else -- Locator is dynamic
1311: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1312: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1313: g_isa_loc_status_id := inv_cache.tosub_rec.default_loc_status_id;
1314: else
1315: g_isa_loc_status_id := inv_cache.tosub_rec.status_id;

Line 1312: if (inv_cache.tosub_rec.default_loc_status_id is not null) then

1308: if (inv_cache.loc_rec.status_id is not null) then
1309: g_isa_loc_status_id := inv_cache.loc_rec.status_id;
1310: else -- Locator is dynamic
1311: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1312: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1313: g_isa_loc_status_id := inv_cache.tosub_rec.default_loc_status_id;
1314: else
1315: g_isa_loc_status_id := inv_cache.tosub_rec.status_id;
1316: end if;

Line 1313: g_isa_loc_status_id := inv_cache.tosub_rec.default_loc_status_id;

1309: g_isa_loc_status_id := inv_cache.loc_rec.status_id;
1310: else -- Locator is dynamic
1311: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1312: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1313: g_isa_loc_status_id := inv_cache.tosub_rec.default_loc_status_id;
1314: else
1315: g_isa_loc_status_id := inv_cache.tosub_rec.status_id;
1316: end if;
1317: elsif p_sub_code is null and p_object_type <> 'A' then -- Bug 6918409

Line 1315: g_isa_loc_status_id := inv_cache.tosub_rec.status_id;

1311: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1312: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1313: g_isa_loc_status_id := inv_cache.tosub_rec.default_loc_status_id;
1314: else
1315: g_isa_loc_status_id := inv_cache.tosub_rec.status_id;
1316: end if;
1317: elsif p_sub_code is null and p_object_type <> 'A' then -- Bug 6918409
1318: return 'Y';
1319: end if;

Line 1324: elsif inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then

1320: end if;
1321: else
1322: if p_sub_code is null and p_object_type <> 'A' then -- Bug 6787033
1323: return 'Y';
1324: elsif inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1325: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1326: g_isa_loc_status_id := inv_cache.tosub_rec.default_loc_status_id;
1327: else
1328: g_isa_loc_status_id := inv_cache.tosub_rec.status_id;

Line 1325: if (inv_cache.tosub_rec.default_loc_status_id is not null) then

1321: else
1322: if p_sub_code is null and p_object_type <> 'A' then -- Bug 6787033
1323: return 'Y';
1324: elsif inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1325: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1326: g_isa_loc_status_id := inv_cache.tosub_rec.default_loc_status_id;
1327: else
1328: g_isa_loc_status_id := inv_cache.tosub_rec.status_id;
1329: end if;

Line 1326: g_isa_loc_status_id := inv_cache.tosub_rec.default_loc_status_id;

1322: if p_sub_code is null and p_object_type <> 'A' then -- Bug 6787033
1323: return 'Y';
1324: elsif inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1325: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1326: g_isa_loc_status_id := inv_cache.tosub_rec.default_loc_status_id;
1327: else
1328: g_isa_loc_status_id := inv_cache.tosub_rec.status_id;
1329: end if;
1330: end if;

Line 1328: g_isa_loc_status_id := inv_cache.tosub_rec.status_id;

1324: elsif inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1325: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1326: g_isa_loc_status_id := inv_cache.tosub_rec.default_loc_status_id;
1327: else
1328: g_isa_loc_status_id := inv_cache.tosub_rec.status_id;
1329: end if;
1330: end if;
1331: end if;
1332: end if;

Line 1340: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then

1336: end;
1337:
1338: if (g_isa_loc_status_id is null or g_isa_loc_status_id = 0 or g_isa_loc_status_id = -1)
1339: and p_object_type <> 'A' then
1340: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
1341: if (inv_cache.item_rec.serial_number_control_code in (1,6)) then
1342:
1343: if (g_debug = 1) then
1344: inv_trx_util_pub.TRACE('Loc, status is null in MOQD for non-serial controlled item', 'INV_MATERIAL_STATUS_GRP', 14);

Line 1341: if (inv_cache.item_rec.serial_number_control_code in (1,6)) then

1337:
1338: if (g_isa_loc_status_id is null or g_isa_loc_status_id = 0 or g_isa_loc_status_id = -1)
1339: and p_object_type <> 'A' then
1340: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
1341: if (inv_cache.item_rec.serial_number_control_code in (1,6)) then
1342:
1343: if (g_debug = 1) then
1344: inv_trx_util_pub.TRACE('Loc, status is null in MOQD for non-serial controlled item', 'INV_MATERIAL_STATUS_GRP', 14);
1345: end if;

Line 1356: elsif ((inv_cache.item_rec.serial_number_control_code not in (1,6)) and g_isa_loc_status_id = -1) then

1352: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1353: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1354: FND_MSG_PUB.ADD;
1355: return 'N';
1356: elsif ((inv_cache.item_rec.serial_number_control_code not in (1,6)) and g_isa_loc_status_id = -1) then
1357: return 'Y';
1358: end if;
1359: end if;
1360: end if;

Line 1442: (NOT(inv_cache.is_pickrelease) OR (inv_cache.is_pickrelease IS NULL)) OR

1438: ) and (p_object_type = 'O' or p_object_type = 'A') then
1439: if( p_organization_id <> nvl(g_organization_id, -9999) OR
1440: p_inventory_item_id <> nvl(g_inventory_item_id, -9999) OR
1441: p_lot_number <> nvl(g_isa_lot_number, '@@@') OR
1442: (NOT(inv_cache.is_pickrelease) OR (inv_cache.is_pickrelease IS NULL)) OR
1443: ( l_default_status_id is not null) -- Onhand Material Status Support: No caching if status is at onhand level
1444: ) THEN --Bug 5457445
1445:
1446: -- Onhand Material Status Support : If status is tracked at the onhand level,

Line 1506: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then

1502: if (get_action_id(p_trx_type_id) in (2,3,21,28)) then -- Need to put action IDs.
1503: return 'Y';
1504: else
1505: if (l_lot_status_enabled = 'Y') then
1506: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
1507: g_isa_lot_number_status_id := inv_cache.item_rec.default_lot_status_id;
1508: end if;
1509: else
1510: /* Bug 6918409 */

Line 1507: g_isa_lot_number_status_id := inv_cache.item_rec.default_lot_status_id;

1503: return 'Y';
1504: else
1505: if (l_lot_status_enabled = 'Y') then
1506: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
1507: g_isa_lot_number_status_id := inv_cache.item_rec.default_lot_status_id;
1508: end if;
1509: else
1510: /* Bug 6918409 */
1511: if (l_default_item_status_id is not null) then

Line 1514: if inv_cache.set_loc_rec(p_organization_id, l_locator_id) then

1510: /* Bug 6918409 */
1511: if (l_default_item_status_id is not null) then
1512: g_isa_lot_number_status_id := l_default_item_status_id;
1513: elsif (get_locator_control(p_organization_id, p_inventory_item_id, p_sub_code) <> 1) then
1514: if inv_cache.set_loc_rec(p_organization_id, l_locator_id) then
1515: if (inv_cache.loc_rec.status_id is not null) then
1516: g_isa_lot_number_status_id := inv_cache.loc_rec.status_id;
1517: else -- Locator is dynamic
1518: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then

Line 1515: if (inv_cache.loc_rec.status_id is not null) then

1511: if (l_default_item_status_id is not null) then
1512: g_isa_lot_number_status_id := l_default_item_status_id;
1513: elsif (get_locator_control(p_organization_id, p_inventory_item_id, p_sub_code) <> 1) then
1514: if inv_cache.set_loc_rec(p_organization_id, l_locator_id) then
1515: if (inv_cache.loc_rec.status_id is not null) then
1516: g_isa_lot_number_status_id := inv_cache.loc_rec.status_id;
1517: else -- Locator is dynamic
1518: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1519: if (inv_cache.tosub_rec.default_loc_status_id is not null) then

Line 1516: g_isa_lot_number_status_id := inv_cache.loc_rec.status_id;

1512: g_isa_lot_number_status_id := l_default_item_status_id;
1513: elsif (get_locator_control(p_organization_id, p_inventory_item_id, p_sub_code) <> 1) then
1514: if inv_cache.set_loc_rec(p_organization_id, l_locator_id) then
1515: if (inv_cache.loc_rec.status_id is not null) then
1516: g_isa_lot_number_status_id := inv_cache.loc_rec.status_id;
1517: else -- Locator is dynamic
1518: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1519: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1520: g_isa_lot_number_status_id := inv_cache.tosub_rec.default_loc_status_id;

Line 1518: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then

1514: if inv_cache.set_loc_rec(p_organization_id, l_locator_id) then
1515: if (inv_cache.loc_rec.status_id is not null) then
1516: g_isa_lot_number_status_id := inv_cache.loc_rec.status_id;
1517: else -- Locator is dynamic
1518: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1519: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1520: g_isa_lot_number_status_id := inv_cache.tosub_rec.default_loc_status_id;
1521: else
1522: g_isa_lot_number_status_id := inv_cache.tosub_rec.status_id;

Line 1519: if (inv_cache.tosub_rec.default_loc_status_id is not null) then

1515: if (inv_cache.loc_rec.status_id is not null) then
1516: g_isa_lot_number_status_id := inv_cache.loc_rec.status_id;
1517: else -- Locator is dynamic
1518: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1519: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1520: g_isa_lot_number_status_id := inv_cache.tosub_rec.default_loc_status_id;
1521: else
1522: g_isa_lot_number_status_id := inv_cache.tosub_rec.status_id;
1523: end if;

Line 1520: g_isa_lot_number_status_id := inv_cache.tosub_rec.default_loc_status_id;

1516: g_isa_lot_number_status_id := inv_cache.loc_rec.status_id;
1517: else -- Locator is dynamic
1518: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1519: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1520: g_isa_lot_number_status_id := inv_cache.tosub_rec.default_loc_status_id;
1521: else
1522: g_isa_lot_number_status_id := inv_cache.tosub_rec.status_id;
1523: end if;
1524: elsif p_sub_code is null and p_object_type <> 'A' then

Line 1522: g_isa_lot_number_status_id := inv_cache.tosub_rec.status_id;

1518: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1519: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1520: g_isa_lot_number_status_id := inv_cache.tosub_rec.default_loc_status_id;
1521: else
1522: g_isa_lot_number_status_id := inv_cache.tosub_rec.status_id;
1523: end if;
1524: elsif p_sub_code is null and p_object_type <> 'A' then
1525: return 'Y';
1526: end if;

Line 1531: elsif inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then

1527: end if;
1528: else
1529: if p_sub_code is null and p_object_type <> 'A' then -- Bug 6787033
1530: return 'Y';
1531: elsif inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1532: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1533: g_isa_lot_number_status_id := inv_cache.tosub_rec.default_loc_status_id;
1534: else
1535: g_isa_lot_number_status_id := inv_cache.tosub_rec.status_id;

Line 1532: if (inv_cache.tosub_rec.default_loc_status_id is not null) then

1528: else
1529: if p_sub_code is null and p_object_type <> 'A' then -- Bug 6787033
1530: return 'Y';
1531: elsif inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1532: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1533: g_isa_lot_number_status_id := inv_cache.tosub_rec.default_loc_status_id;
1534: else
1535: g_isa_lot_number_status_id := inv_cache.tosub_rec.status_id;
1536: end if;

Line 1533: g_isa_lot_number_status_id := inv_cache.tosub_rec.default_loc_status_id;

1529: if p_sub_code is null and p_object_type <> 'A' then -- Bug 6787033
1530: return 'Y';
1531: elsif inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1532: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1533: g_isa_lot_number_status_id := inv_cache.tosub_rec.default_loc_status_id;
1534: else
1535: g_isa_lot_number_status_id := inv_cache.tosub_rec.status_id;
1536: end if;
1537: end if;

Line 1535: g_isa_lot_number_status_id := inv_cache.tosub_rec.status_id;

1531: elsif inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1532: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1533: g_isa_lot_number_status_id := inv_cache.tosub_rec.default_loc_status_id;
1534: else
1535: g_isa_lot_number_status_id := inv_cache.tosub_rec.status_id;
1536: end if;
1537: end if;
1538: end if;
1539: elsif ( p_sub_code is not null) then

Line 1540: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then

1536: end if;
1537: end if;
1538: end if;
1539: elsif ( p_sub_code is not null) then
1540: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1541: g_isa_lot_number_status_id := inv_cache.tosub_rec.status_id;
1542: end if;
1543: else
1544: return 'Y';

Line 1541: g_isa_lot_number_status_id := inv_cache.tosub_rec.status_id;

1537: end if;
1538: end if;
1539: elsif ( p_sub_code is not null) then
1540: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1541: g_isa_lot_number_status_id := inv_cache.tosub_rec.status_id;
1542: end if;
1543: else
1544: return 'Y';
1545: end if;

Line 1554: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then

1550: end;
1551:
1552: if (g_isa_lot_number_status_id is null or g_isa_lot_number_status_id = 0 or g_isa_lot_number_status_id = -1)
1553: and p_object_type <> 'A' then
1554: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
1555: if (inv_cache.item_rec.serial_number_control_code in (1,6)) then
1556:
1557: if (g_debug = 1) then
1558: inv_trx_util_pub.TRACE('lot, status is null in MOQD for non-serial controlled item', 'INV_MATERIAL_STATUS_GRP', 14);

Line 1555: if (inv_cache.item_rec.serial_number_control_code in (1,6)) then

1551:
1552: if (g_isa_lot_number_status_id is null or g_isa_lot_number_status_id = 0 or g_isa_lot_number_status_id = -1)
1553: and p_object_type <> 'A' then
1554: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
1555: if (inv_cache.item_rec.serial_number_control_code in (1,6)) then
1556:
1557: if (g_debug = 1) then
1558: inv_trx_util_pub.TRACE('lot, status is null in MOQD for non-serial controlled item', 'INV_MATERIAL_STATUS_GRP', 14);
1559: end if;

Line 1570: elsif ((inv_cache.item_rec.serial_number_control_code not in (1,6)) and g_isa_lot_number_status_id = -1) then

1566: FND_MESSAGE.SET_TOKEN('LOT', p_lot_number);
1567: FND_MESSAGE.SET_TOKEN('LPN_ID', p_lpn_id);
1568: FND_MSG_PUB.ADD;
1569: return 'N';
1570: elsif ((inv_cache.item_rec.serial_number_control_code not in (1,6)) and g_isa_lot_number_status_id = -1) then
1571: return 'Y';
1572: end if;
1573: end if;
1574: end if;

Line 1822: if inv_cache.set_org_rec(p_organization_id) then

1818: inv_trx_util_pub.TRACE('loc '|| p_loc_id || ' lot ' || p_lot_number || ' lpn ' || p_lpn_id || ' action ' || p_transaction_action_id || ' src ' || p_src_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
1819: inv_trx_util_pub.TRACE('lock id '|| p_lock_id || ' header id '||p_header_id, 'INV_MATERIAL_STATUS_GRP', 14);
1820: end if;
1821:
1822: if inv_cache.set_org_rec(p_organization_id) then
1823: l_default_org_status_id := inv_cache.org_rec.default_status_id;
1824: end if;
1825:
1826: if (g_debug = 1) then

Line 1823: l_default_org_status_id := inv_cache.org_rec.default_status_id;

1819: inv_trx_util_pub.TRACE('lock id '|| p_lock_id || ' header id '||p_header_id, 'INV_MATERIAL_STATUS_GRP', 14);
1820: end if;
1821:
1822: if inv_cache.set_org_rec(p_organization_id) then
1823: l_default_org_status_id := inv_cache.org_rec.default_status_id;
1824: end if;
1825:
1826: if (g_debug = 1) then
1827: inv_trx_util_pub.TRACE('default org status ' || l_default_org_status_id, 'INV_MATERIAL_STATUS_GRP', 14);

Line 1830: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then

1826: if (g_debug = 1) then
1827: inv_trx_util_pub.TRACE('default org status ' || l_default_org_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
1828: end if;
1829:
1830: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
1831: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
1832: l_serial_controlled := 1; -- Item is serial controlled
1833: end if;
1834: end if;

Line 1831: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then

1827: inv_trx_util_pub.TRACE('default org status ' || l_default_org_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
1828: end if;
1829:
1830: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
1831: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
1832: l_serial_controlled := 1; -- Item is serial controlled
1833: end if;
1834: end if;
1835:

Line 1933: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then

1929: return p_src_status_id;
1930: End if;
1931: end if;
1932:
1933: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
1934: if (l_serial_controlled <> 0) then
1935: return null;
1936: elsif (inv_cache.item_rec.lot_status_enabled = 'Y') then
1937: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into

Line 1936: elsif (inv_cache.item_rec.lot_status_enabled = 'Y') then

1932:
1933: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
1934: if (l_serial_controlled <> 0) then
1935: return null;
1936: elsif (inv_cache.item_rec.lot_status_enabled = 'Y') then
1937: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
1938: -- the table : mtl_material_status_history
1939: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
1940: ,p_lpn_id, inv_cache.item_rec.default_lot_status_id, p_lock_id);

Line 1940: ,p_lpn_id, inv_cache.item_rec.default_lot_status_id, p_lock_id);

1936: elsif (inv_cache.item_rec.lot_status_enabled = 'Y') then
1937: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
1938: -- the table : mtl_material_status_history
1939: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
1940: ,p_lpn_id, inv_cache.item_rec.default_lot_status_id, p_lock_id);
1941:
1942: return inv_cache.item_rec.default_lot_status_id;
1943: elsif (inv_cache.item_rec.default_material_status_id is not null) then
1944: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into

Line 1942: return inv_cache.item_rec.default_lot_status_id;

1938: -- the table : mtl_material_status_history
1939: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
1940: ,p_lpn_id, inv_cache.item_rec.default_lot_status_id, p_lock_id);
1941:
1942: return inv_cache.item_rec.default_lot_status_id;
1943: elsif (inv_cache.item_rec.default_material_status_id is not null) then
1944: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
1945: -- the table : mtl_material_status_history
1946: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number

Line 1943: elsif (inv_cache.item_rec.default_material_status_id is not null) then

1939: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
1940: ,p_lpn_id, inv_cache.item_rec.default_lot_status_id, p_lock_id);
1941:
1942: return inv_cache.item_rec.default_lot_status_id;
1943: elsif (inv_cache.item_rec.default_material_status_id is not null) then
1944: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
1945: -- the table : mtl_material_status_history
1946: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
1947: ,p_lpn_id, inv_cache.item_rec.default_material_status_id, p_lock_id);

Line 1947: ,p_lpn_id, inv_cache.item_rec.default_material_status_id, p_lock_id);

1943: elsif (inv_cache.item_rec.default_material_status_id is not null) then
1944: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
1945: -- the table : mtl_material_status_history
1946: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
1947: ,p_lpn_id, inv_cache.item_rec.default_material_status_id, p_lock_id);
1948:
1949: return inv_cache.item_rec.default_material_status_id;
1950: end if;
1951: end if;

Line 1949: return inv_cache.item_rec.default_material_status_id;

1945: -- the table : mtl_material_status_history
1946: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
1947: ,p_lpn_id, inv_cache.item_rec.default_material_status_id, p_lock_id);
1948:
1949: return inv_cache.item_rec.default_material_status_id;
1950: end if;
1951: end if;
1952:
1953: if p_loc_id is not null then

Line 1954: if inv_cache.set_loc_rec(p_organization_id, p_loc_id) then

1950: end if;
1951: end if;
1952:
1953: if p_loc_id is not null then
1954: if inv_cache.set_loc_rec(p_organization_id, p_loc_id) then
1955: if (inv_cache.loc_rec.status_id is not null) then
1956: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
1957: -- the table : mtl_material_status_history
1958: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number

Line 1955: if (inv_cache.loc_rec.status_id is not null) then

1951: end if;
1952:
1953: if p_loc_id is not null then
1954: if inv_cache.set_loc_rec(p_organization_id, p_loc_id) then
1955: if (inv_cache.loc_rec.status_id is not null) then
1956: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
1957: -- the table : mtl_material_status_history
1958: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
1959: ,p_lpn_id, inv_cache.loc_rec.status_id, p_lock_id);

Line 1959: ,p_lpn_id, inv_cache.loc_rec.status_id, p_lock_id);

1955: if (inv_cache.loc_rec.status_id is not null) then
1956: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
1957: -- the table : mtl_material_status_history
1958: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
1959: ,p_lpn_id, inv_cache.loc_rec.status_id, p_lock_id);
1960:
1961: return inv_cache.loc_rec.status_id;
1962: else -- Locator is dynamic
1963: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then

Line 1961: return inv_cache.loc_rec.status_id;

1957: -- the table : mtl_material_status_history
1958: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
1959: ,p_lpn_id, inv_cache.loc_rec.status_id, p_lock_id);
1960:
1961: return inv_cache.loc_rec.status_id;
1962: else -- Locator is dynamic
1963: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1964: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1965: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into

Line 1963: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then

1959: ,p_lpn_id, inv_cache.loc_rec.status_id, p_lock_id);
1960:
1961: return inv_cache.loc_rec.status_id;
1962: else -- Locator is dynamic
1963: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1964: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1965: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
1966: -- the table : mtl_material_status_history
1967: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number

Line 1964: if (inv_cache.tosub_rec.default_loc_status_id is not null) then

1960:
1961: return inv_cache.loc_rec.status_id;
1962: else -- Locator is dynamic
1963: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1964: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1965: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
1966: -- the table : mtl_material_status_history
1967: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
1968: ,p_lpn_id, inv_cache.tosub_rec.default_loc_status_id, p_lock_id);

Line 1968: ,p_lpn_id, inv_cache.tosub_rec.default_loc_status_id, p_lock_id);

1964: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1965: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
1966: -- the table : mtl_material_status_history
1967: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
1968: ,p_lpn_id, inv_cache.tosub_rec.default_loc_status_id, p_lock_id);
1969:
1970: return inv_cache.tosub_rec.default_loc_status_id;
1971: end if;
1972: end if;

Line 1970: return inv_cache.tosub_rec.default_loc_status_id;

1966: -- the table : mtl_material_status_history
1967: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
1968: ,p_lpn_id, inv_cache.tosub_rec.default_loc_status_id, p_lock_id);
1969:
1970: return inv_cache.tosub_rec.default_loc_status_id;
1971: end if;
1972: end if;
1973: end if;
1974: else -- Locator is dynamic

Line 1975: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then

1971: end if;
1972: end if;
1973: end if;
1974: else -- Locator is dynamic
1975: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1976: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1977: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
1978: -- the table : mtl_material_status_history
1979: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number

Line 1976: if (inv_cache.tosub_rec.default_loc_status_id is not null) then

1972: end if;
1973: end if;
1974: else -- Locator is dynamic
1975: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1976: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1977: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
1978: -- the table : mtl_material_status_history
1979: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
1980: ,p_lpn_id, inv_cache.tosub_rec.default_loc_status_id, p_lock_id);

Line 1980: ,p_lpn_id, inv_cache.tosub_rec.default_loc_status_id, p_lock_id);

1976: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
1977: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
1978: -- the table : mtl_material_status_history
1979: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
1980: ,p_lpn_id, inv_cache.tosub_rec.default_loc_status_id, p_lock_id);
1981:
1982: return inv_cache.tosub_rec.default_loc_status_id;
1983: else
1984: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into

Line 1982: return inv_cache.tosub_rec.default_loc_status_id;

1978: -- the table : mtl_material_status_history
1979: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
1980: ,p_lpn_id, inv_cache.tosub_rec.default_loc_status_id, p_lock_id);
1981:
1982: return inv_cache.tosub_rec.default_loc_status_id;
1983: else
1984: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
1985: -- the table : mtl_material_status_history
1986: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number

Line 1987: ,p_lpn_id, inv_cache.tosub_rec.status_id, p_lock_id);

1983: else
1984: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
1985: -- the table : mtl_material_status_history
1986: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
1987: ,p_lpn_id, inv_cache.tosub_rec.status_id, p_lock_id);
1988:
1989: return inv_cache.tosub_rec.status_id;
1990: end if;
1991: end if;

Line 1989: return inv_cache.tosub_rec.status_id;

1985: -- the table : mtl_material_status_history
1986: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
1987: ,p_lpn_id, inv_cache.tosub_rec.status_id, p_lock_id);
1988:
1989: return inv_cache.tosub_rec.status_id;
1990: end if;
1991: end if;
1992: end if;
1993: end if;

Line 1995: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then

1991: end if;
1992: end if;
1993: end if;
1994:
1995: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1996: if (inv_cache.tosub_rec.status_id is not null) then
1997: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
1998: -- the table : mtl_material_status_history
1999: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number

Line 1996: if (inv_cache.tosub_rec.status_id is not null) then

1992: end if;
1993: end if;
1994:
1995: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
1996: if (inv_cache.tosub_rec.status_id is not null) then
1997: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
1998: -- the table : mtl_material_status_history
1999: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
2000: ,p_lpn_id, inv_cache.tosub_rec.status_id, p_lock_id);

Line 2000: ,p_lpn_id, inv_cache.tosub_rec.status_id, p_lock_id);

1996: if (inv_cache.tosub_rec.status_id is not null) then
1997: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
1998: -- the table : mtl_material_status_history
1999: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
2000: ,p_lpn_id, inv_cache.tosub_rec.status_id, p_lock_id);
2001:
2002: return inv_cache.tosub_rec.status_id;
2003: end if;
2004: end if;

Line 2002: return inv_cache.tosub_rec.status_id;

1998: -- the table : mtl_material_status_history
1999: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
2000: ,p_lpn_id, inv_cache.tosub_rec.status_id, p_lock_id);
2001:
2002: return inv_cache.tosub_rec.status_id;
2003: end if;
2004: end if;
2005:
2006: if inv_cache.set_org_rec(p_organization_id) then

Line 2006: if inv_cache.set_org_rec(p_organization_id) then

2002: return inv_cache.tosub_rec.status_id;
2003: end if;
2004: end if;
2005:
2006: if inv_cache.set_org_rec(p_organization_id) then
2007: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
2008: -- the table : mtl_material_status_history
2009: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
2010: ,p_lpn_id, inv_cache.org_rec.default_status_id, p_lock_id);

Line 2010: ,p_lpn_id, inv_cache.org_rec.default_status_id, p_lock_id);

2006: if inv_cache.set_org_rec(p_organization_id) then
2007: -- Bug 6798024 : Calling the insert procedure to insert the status of the new onhand record into
2008: -- the table : mtl_material_status_history
2009: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
2010: ,p_lpn_id, inv_cache.org_rec.default_status_id, p_lock_id);
2011:
2012: return inv_cache.org_rec.default_status_id;
2013: end if;
2014:

Line 2012: return inv_cache.org_rec.default_status_id;

2008: -- the table : mtl_material_status_history
2009: insert_status_history(p_organization_id, p_inventory_item_id, p_sub_code, p_loc_id, p_lot_number
2010: ,p_lpn_id, inv_cache.org_rec.default_status_id, p_lock_id);
2011:
2012: return inv_cache.org_rec.default_status_id;
2013: end if;
2014:
2015: WHEN OTHERS THEN
2016:

Line 2101: if inv_cache.set_org_rec(p_organization_id) then

2097: inv_trx_util_pub.TRACE('org id ' ||p_organization_id || ' Item id ' || p_inventory_item_id || ' sub ' || p_sub_code, 'INV_MATERIAL_STATUS_GRP', 14);
2098: inv_trx_util_pub.TRACE('loc '|| p_loc_id || ' lot ' || p_lot_number || ' lpn ' || p_lpn_id, 'INV_MATERIAL_STATUS_GRP', 14);
2099: end if;
2100:
2101: if inv_cache.set_org_rec(p_organization_id) then
2102: l_default_org_status_id := inv_cache.org_rec.default_status_id;
2103: end if;
2104:
2105: l_default_status_id := l_default_org_status_id;

Line 2102: l_default_org_status_id := inv_cache.org_rec.default_status_id;

2098: inv_trx_util_pub.TRACE('loc '|| p_loc_id || ' lot ' || p_lot_number || ' lpn ' || p_lpn_id, 'INV_MATERIAL_STATUS_GRP', 14);
2099: end if;
2100:
2101: if inv_cache.set_org_rec(p_organization_id) then
2102: l_default_org_status_id := inv_cache.org_rec.default_status_id;
2103: end if;
2104:
2105: l_default_status_id := l_default_org_status_id;
2106:

Line 2111: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then

2107: if (g_debug = 1) then
2108: inv_trx_util_pub.TRACE('default org status ' || l_default_org_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
2109: end if;
2110:
2111: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
2112: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
2113: l_serial_controlled := 1; -- Item is serial controlled
2114: end if;
2115: end if;

Line 2112: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then

2108: inv_trx_util_pub.TRACE('default org status ' || l_default_org_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
2109: end if;
2110:
2111: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
2112: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
2113: l_serial_controlled := 1; -- Item is serial controlled
2114: end if;
2115: end if;
2116:

Line 2119: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then

2115: end if;
2116:
2117: if (l_default_org_status_id is null) then
2118:
2119: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
2120: if (l_serial_controlled <> 0) then -- serial
2121: return null;
2122: elsif (inv_cache.item_rec.lot_status_enabled = 'Y') then -- lot
2123: return inv_cache.item_rec.default_lot_status_id;

Line 2122: elsif (inv_cache.item_rec.lot_status_enabled = 'Y') then -- lot

2118:
2119: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
2120: if (l_serial_controlled <> 0) then -- serial
2121: return null;
2122: elsif (inv_cache.item_rec.lot_status_enabled = 'Y') then -- lot
2123: return inv_cache.item_rec.default_lot_status_id;
2124: elsif (inv_cache.item_rec.default_material_status_id is not null) then -- item
2125: return inv_cache.item_rec.default_material_status_id;
2126: end if;

Line 2123: return inv_cache.item_rec.default_lot_status_id;

2119: if inv_cache.set_item_rec(p_organization_id, p_inventory_item_id) then
2120: if (l_serial_controlled <> 0) then -- serial
2121: return null;
2122: elsif (inv_cache.item_rec.lot_status_enabled = 'Y') then -- lot
2123: return inv_cache.item_rec.default_lot_status_id;
2124: elsif (inv_cache.item_rec.default_material_status_id is not null) then -- item
2125: return inv_cache.item_rec.default_material_status_id;
2126: end if;
2127: end if;

Line 2124: elsif (inv_cache.item_rec.default_material_status_id is not null) then -- item

2120: if (l_serial_controlled <> 0) then -- serial
2121: return null;
2122: elsif (inv_cache.item_rec.lot_status_enabled = 'Y') then -- lot
2123: return inv_cache.item_rec.default_lot_status_id;
2124: elsif (inv_cache.item_rec.default_material_status_id is not null) then -- item
2125: return inv_cache.item_rec.default_material_status_id;
2126: end if;
2127: end if;
2128:

Line 2125: return inv_cache.item_rec.default_material_status_id;

2121: return null;
2122: elsif (inv_cache.item_rec.lot_status_enabled = 'Y') then -- lot
2123: return inv_cache.item_rec.default_lot_status_id;
2124: elsif (inv_cache.item_rec.default_material_status_id is not null) then -- item
2125: return inv_cache.item_rec.default_material_status_id;
2126: end if;
2127: end if;
2128:
2129: if p_loc_id is not null then

Line 2130: if inv_cache.set_loc_rec(p_organization_id, p_loc_id) then

2126: end if;
2127: end if;
2128:
2129: if p_loc_id is not null then
2130: if inv_cache.set_loc_rec(p_organization_id, p_loc_id) then
2131: if (inv_cache.loc_rec.status_id is not null) then
2132: return inv_cache.loc_rec.status_id;
2133: else -- Locator is dynamic
2134: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then

Line 2131: if (inv_cache.loc_rec.status_id is not null) then

2127: end if;
2128:
2129: if p_loc_id is not null then
2130: if inv_cache.set_loc_rec(p_organization_id, p_loc_id) then
2131: if (inv_cache.loc_rec.status_id is not null) then
2132: return inv_cache.loc_rec.status_id;
2133: else -- Locator is dynamic
2134: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
2135: if (inv_cache.tosub_rec.default_loc_status_id is not null) then

Line 2132: return inv_cache.loc_rec.status_id;

2128:
2129: if p_loc_id is not null then
2130: if inv_cache.set_loc_rec(p_organization_id, p_loc_id) then
2131: if (inv_cache.loc_rec.status_id is not null) then
2132: return inv_cache.loc_rec.status_id;
2133: else -- Locator is dynamic
2134: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
2135: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
2136: return inv_cache.tosub_rec.default_loc_status_id;

Line 2134: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then

2130: if inv_cache.set_loc_rec(p_organization_id, p_loc_id) then
2131: if (inv_cache.loc_rec.status_id is not null) then
2132: return inv_cache.loc_rec.status_id;
2133: else -- Locator is dynamic
2134: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
2135: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
2136: return inv_cache.tosub_rec.default_loc_status_id;
2137: end if;
2138: end if;

Line 2135: if (inv_cache.tosub_rec.default_loc_status_id is not null) then

2131: if (inv_cache.loc_rec.status_id is not null) then
2132: return inv_cache.loc_rec.status_id;
2133: else -- Locator is dynamic
2134: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
2135: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
2136: return inv_cache.tosub_rec.default_loc_status_id;
2137: end if;
2138: end if;
2139: end if;

Line 2136: return inv_cache.tosub_rec.default_loc_status_id;

2132: return inv_cache.loc_rec.status_id;
2133: else -- Locator is dynamic
2134: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
2135: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
2136: return inv_cache.tosub_rec.default_loc_status_id;
2137: end if;
2138: end if;
2139: end if;
2140: else -- Locator is dynamic

Line 2141: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then

2137: end if;
2138: end if;
2139: end if;
2140: else -- Locator is dynamic
2141: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
2142: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
2143: return inv_cache.tosub_rec.default_loc_status_id;
2144: else
2145: return inv_cache.tosub_rec.status_id;

Line 2142: if (inv_cache.tosub_rec.default_loc_status_id is not null) then

2138: end if;
2139: end if;
2140: else -- Locator is dynamic
2141: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
2142: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
2143: return inv_cache.tosub_rec.default_loc_status_id;
2144: else
2145: return inv_cache.tosub_rec.status_id;
2146: end if;

Line 2143: return inv_cache.tosub_rec.default_loc_status_id;

2139: end if;
2140: else -- Locator is dynamic
2141: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
2142: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
2143: return inv_cache.tosub_rec.default_loc_status_id;
2144: else
2145: return inv_cache.tosub_rec.status_id;
2146: end if;
2147: end if;

Line 2145: return inv_cache.tosub_rec.status_id;

2141: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
2142: if (inv_cache.tosub_rec.default_loc_status_id is not null) then
2143: return inv_cache.tosub_rec.default_loc_status_id;
2144: else
2145: return inv_cache.tosub_rec.status_id;
2146: end if;
2147: end if;
2148: end if;
2149: end if;

Line 2151: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then

2147: end if;
2148: end if;
2149: end if;
2150:
2151: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
2152: if (inv_cache.tosub_rec.status_id is not null) then
2153: return inv_cache.tosub_rec.status_id;
2154: end if;
2155: end if;

Line 2152: if (inv_cache.tosub_rec.status_id is not null) then

2148: end if;
2149: end if;
2150:
2151: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
2152: if (inv_cache.tosub_rec.status_id is not null) then
2153: return inv_cache.tosub_rec.status_id;
2154: end if;
2155: end if;
2156:

Line 2153: return inv_cache.tosub_rec.status_id;

2149: end if;
2150:
2151: if inv_cache.set_tosub_rec(p_organization_id, p_sub_code) then
2152: if (inv_cache.tosub_rec.status_id is not null) then
2153: return inv_cache.tosub_rec.status_id;
2154: end if;
2155: end if;
2156:
2157: if inv_cache.set_org_rec(p_organization_id) then

Line 2157: if inv_cache.set_org_rec(p_organization_id) then

2153: return inv_cache.tosub_rec.status_id;
2154: end if;
2155: end if;
2156:
2157: if inv_cache.set_org_rec(p_organization_id) then
2158: return inv_cache.org_rec.default_status_id;
2159: end if;
2160:
2161: end if;

Line 2158: return inv_cache.org_rec.default_status_id;

2154: end if;
2155: end if;
2156:
2157: if inv_cache.set_org_rec(p_organization_id) then
2158: return inv_cache.org_rec.default_status_id;
2159: end if;
2160:
2161: end if;
2162:

Line 2401: IF inv_cache.set_item_rec(l_org_id,p_inventory_item_id) THEN

2397: , p_transfer_subinventory);
2398:
2399: --Get lot and serial control for item from source and destination orgs:
2400:
2401: IF inv_cache.set_item_rec(l_org_id,p_inventory_item_id) THEN
2402: l_lot_source_status := NVL(inv_cache.item_rec.LOT_STATUS_ENABLED,'N');
2403: l_lot_control_code_source := NVL(inv_cache.item_rec.LOT_CONTROL_CODE,1);
2404: l_serial_control_code_source := NVL(inv_cache.item_rec.SERIAL_NUMBER_CONTROL_CODE,1);
2405: END IF;

Line 2402: l_lot_source_status := NVL(inv_cache.item_rec.LOT_STATUS_ENABLED,'N');

2398:
2399: --Get lot and serial control for item from source and destination orgs:
2400:
2401: IF inv_cache.set_item_rec(l_org_id,p_inventory_item_id) THEN
2402: l_lot_source_status := NVL(inv_cache.item_rec.LOT_STATUS_ENABLED,'N');
2403: l_lot_control_code_source := NVL(inv_cache.item_rec.LOT_CONTROL_CODE,1);
2404: l_serial_control_code_source := NVL(inv_cache.item_rec.SERIAL_NUMBER_CONTROL_CODE,1);
2405: END IF;
2406:

Line 2403: l_lot_control_code_source := NVL(inv_cache.item_rec.LOT_CONTROL_CODE,1);

2399: --Get lot and serial control for item from source and destination orgs:
2400:
2401: IF inv_cache.set_item_rec(l_org_id,p_inventory_item_id) THEN
2402: l_lot_source_status := NVL(inv_cache.item_rec.LOT_STATUS_ENABLED,'N');
2403: l_lot_control_code_source := NVL(inv_cache.item_rec.LOT_CONTROL_CODE,1);
2404: l_serial_control_code_source := NVL(inv_cache.item_rec.SERIAL_NUMBER_CONTROL_CODE,1);
2405: END IF;
2406:
2407: IF inv_cache.set_item_rec(l_transfer_org_id,p_inventory_item_id) THEN

Line 2404: l_serial_control_code_source := NVL(inv_cache.item_rec.SERIAL_NUMBER_CONTROL_CODE,1);

2400:
2401: IF inv_cache.set_item_rec(l_org_id,p_inventory_item_id) THEN
2402: l_lot_source_status := NVL(inv_cache.item_rec.LOT_STATUS_ENABLED,'N');
2403: l_lot_control_code_source := NVL(inv_cache.item_rec.LOT_CONTROL_CODE,1);
2404: l_serial_control_code_source := NVL(inv_cache.item_rec.SERIAL_NUMBER_CONTROL_CODE,1);
2405: END IF;
2406:
2407: IF inv_cache.set_item_rec(l_transfer_org_id,p_inventory_item_id) THEN
2408: l_revision_control_code_destin := NVL(inv_cache.item_rec.REVISION_QTY_CONTROL_CODE,1);

Line 2407: IF inv_cache.set_item_rec(l_transfer_org_id,p_inventory_item_id) THEN

2403: l_lot_control_code_source := NVL(inv_cache.item_rec.LOT_CONTROL_CODE,1);
2404: l_serial_control_code_source := NVL(inv_cache.item_rec.SERIAL_NUMBER_CONTROL_CODE,1);
2405: END IF;
2406:
2407: IF inv_cache.set_item_rec(l_transfer_org_id,p_inventory_item_id) THEN
2408: l_revision_control_code_destin := NVL(inv_cache.item_rec.REVISION_QTY_CONTROL_CODE,1);
2409: l_lot_destin_status := NVL(inv_cache.item_rec.LOT_STATUS_ENABLED,'N');
2410: l_lot_control_code_destin := NVL(inv_cache.item_rec.LOT_CONTROL_CODE,1);
2411: l_serial_control_code_destin := NVL(inv_cache.item_rec.SERIAL_NUMBER_CONTROL_CODE,1);

Line 2408: l_revision_control_code_destin := NVL(inv_cache.item_rec.REVISION_QTY_CONTROL_CODE,1);

2404: l_serial_control_code_source := NVL(inv_cache.item_rec.SERIAL_NUMBER_CONTROL_CODE,1);
2405: END IF;
2406:
2407: IF inv_cache.set_item_rec(l_transfer_org_id,p_inventory_item_id) THEN
2408: l_revision_control_code_destin := NVL(inv_cache.item_rec.REVISION_QTY_CONTROL_CODE,1);
2409: l_lot_destin_status := NVL(inv_cache.item_rec.LOT_STATUS_ENABLED,'N');
2410: l_lot_control_code_destin := NVL(inv_cache.item_rec.LOT_CONTROL_CODE,1);
2411: l_serial_control_code_destin := NVL(inv_cache.item_rec.SERIAL_NUMBER_CONTROL_CODE,1);
2412: END IF;

Line 2409: l_lot_destin_status := NVL(inv_cache.item_rec.LOT_STATUS_ENABLED,'N');

2405: END IF;
2406:
2407: IF inv_cache.set_item_rec(l_transfer_org_id,p_inventory_item_id) THEN
2408: l_revision_control_code_destin := NVL(inv_cache.item_rec.REVISION_QTY_CONTROL_CODE,1);
2409: l_lot_destin_status := NVL(inv_cache.item_rec.LOT_STATUS_ENABLED,'N');
2410: l_lot_control_code_destin := NVL(inv_cache.item_rec.LOT_CONTROL_CODE,1);
2411: l_serial_control_code_destin := NVL(inv_cache.item_rec.SERIAL_NUMBER_CONTROL_CODE,1);
2412: END IF;
2413:

Line 2410: l_lot_control_code_destin := NVL(inv_cache.item_rec.LOT_CONTROL_CODE,1);

2406:
2407: IF inv_cache.set_item_rec(l_transfer_org_id,p_inventory_item_id) THEN
2408: l_revision_control_code_destin := NVL(inv_cache.item_rec.REVISION_QTY_CONTROL_CODE,1);
2409: l_lot_destin_status := NVL(inv_cache.item_rec.LOT_STATUS_ENABLED,'N');
2410: l_lot_control_code_destin := NVL(inv_cache.item_rec.LOT_CONTROL_CODE,1);
2411: l_serial_control_code_destin := NVL(inv_cache.item_rec.SERIAL_NUMBER_CONTROL_CODE,1);
2412: END IF;
2413:
2414: if (g_debug = 1) then

Line 2411: l_serial_control_code_destin := NVL(inv_cache.item_rec.SERIAL_NUMBER_CONTROL_CODE,1);

2407: IF inv_cache.set_item_rec(l_transfer_org_id,p_inventory_item_id) THEN
2408: l_revision_control_code_destin := NVL(inv_cache.item_rec.REVISION_QTY_CONTROL_CODE,1);
2409: l_lot_destin_status := NVL(inv_cache.item_rec.LOT_STATUS_ENABLED,'N');
2410: l_lot_control_code_destin := NVL(inv_cache.item_rec.LOT_CONTROL_CODE,1);
2411: l_serial_control_code_destin := NVL(inv_cache.item_rec.SERIAL_NUMBER_CONTROL_CODE,1);
2412: END IF;
2413:
2414: if (g_debug = 1) then
2415:

Line 2441: IF inv_cache.set_org_rec(l_org_id) THEN

2437: )
2438: OR
2439: ( p_object_type = 'O' AND p_lot_number IS NOT NULL)
2440: THEN
2441: IF inv_cache.set_org_rec(l_org_id) THEN
2442: l_default_source_status_id := NVL(inv_cache.org_rec.default_status_id,0);
2443: IF l_default_source_status_id <> 0 THEN
2444: l_default_source_status := 'Y';
2445: ELSE

Line 2442: l_default_source_status_id := NVL(inv_cache.org_rec.default_status_id,0);

2438: OR
2439: ( p_object_type = 'O' AND p_lot_number IS NOT NULL)
2440: THEN
2441: IF inv_cache.set_org_rec(l_org_id) THEN
2442: l_default_source_status_id := NVL(inv_cache.org_rec.default_status_id,0);
2443: IF l_default_source_status_id <> 0 THEN
2444: l_default_source_status := 'Y';
2445: ELSE
2446: l_default_source_status := 'N';

Line 2450: IF inv_cache.set_org_rec(l_transfer_org_id) THEN

2446: l_default_source_status := 'N';
2447: END IF;
2448: END IF;
2449:
2450: IF inv_cache.set_org_rec(l_transfer_org_id) THEN
2451: l_default_destin_status_id := NVL(inv_cache.org_rec.default_status_id,0);
2452: IF l_default_destin_status_id <> 0 THEN
2453: l_default_destin_status := 'Y';
2454: ELSE

Line 2451: l_default_destin_status_id := NVL(inv_cache.org_rec.default_status_id,0);

2447: END IF;
2448: END IF;
2449:
2450: IF inv_cache.set_org_rec(l_transfer_org_id) THEN
2451: l_default_destin_status_id := NVL(inv_cache.org_rec.default_status_id,0);
2452: IF l_default_destin_status_id <> 0 THEN
2453: l_default_destin_status := 'Y';
2454: ELSE
2455: l_default_destin_status := 'N';

Line 2816: IF inv_cache.set_item_rec(l_lpn_org_id, l_mmtt_cur.inventory_item_id) THEN

2812: LOOP
2813: l_serial_status_enabled := 0;
2814: l_serial_controlled := 0;
2815: l_lot_controlled := 0;
2816: IF inv_cache.set_item_rec(l_lpn_org_id, l_mmtt_cur.inventory_item_id) THEN
2817: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
2818: l_serial_controlled := 1; -- Item is serial controlled
2819: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
2820: l_serial_status_enabled := 1;

Line 2817: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN

2813: l_serial_status_enabled := 0;
2814: l_serial_controlled := 0;
2815: l_lot_controlled := 0;
2816: IF inv_cache.set_item_rec(l_lpn_org_id, l_mmtt_cur.inventory_item_id) THEN
2817: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
2818: l_serial_controlled := 1; -- Item is serial controlled
2819: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
2820: l_serial_status_enabled := 1;
2821: END IF;

Line 2819: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN

2815: l_lot_controlled := 0;
2816: IF inv_cache.set_item_rec(l_lpn_org_id, l_mmtt_cur.inventory_item_id) THEN
2817: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
2818: l_serial_controlled := 1; -- Item is serial controlled
2819: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
2820: l_serial_status_enabled := 1;
2821: END IF;
2822: END IF;
2823: IF (inv_cache.item_rec.lot_control_code = 2) THEN

Line 2823: IF (inv_cache.item_rec.lot_control_code = 2) THEN

2819: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
2820: l_serial_status_enabled := 1;
2821: END IF;
2822: END IF;
2823: IF (inv_cache.item_rec.lot_control_code = 2) THEN
2824: l_lot_controlled := 1;
2825: END IF;
2826: END IF;
2827:

Line 2908: IF inv_cache.set_item_rec(p_organization_id, l_cur_wlc.inventory_item_id) THEN

2904: FOR l_cur_wlc IN c_lpn_item
2905: LOOP
2906: l_serial_controlled := 0;
2907: l_serial_status_enabled := 0;
2908: IF inv_cache.set_item_rec(p_organization_id, l_cur_wlc.inventory_item_id) THEN
2909: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
2910: l_serial_controlled := 1; -- Item is serial controlled
2911: END IF;
2912: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN

Line 2909: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN

2905: LOOP
2906: l_serial_controlled := 0;
2907: l_serial_status_enabled := 0;
2908: IF inv_cache.set_item_rec(p_organization_id, l_cur_wlc.inventory_item_id) THEN
2909: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
2910: l_serial_controlled := 1; -- Item is serial controlled
2911: END IF;
2912: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
2913: l_serial_status_enabled := 1;

Line 2912: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN

2908: IF inv_cache.set_item_rec(p_organization_id, l_cur_wlc.inventory_item_id) THEN
2909: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
2910: l_serial_controlled := 1; -- Item is serial controlled
2911: END IF;
2912: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
2913: l_serial_status_enabled := 1;
2914: END IF;
2915: END IF;
2916: IF (l_serial_controlled <> 1) then

Line 3393: IF inv_cache.set_item_rec(p_organization_id, l_cur_mtrl.inventory_item_id) THEN

3389: inv_trx_util_pub.TRACE('In loop, Checking the material status for the item: '||l_cur_mtrl.inventory_item_id);
3390: END IF;
3391: l_serial_controlled := 0;
3392: l_serial_status_enabled := 0;
3393: IF inv_cache.set_item_rec(p_organization_id, l_cur_mtrl.inventory_item_id) THEN
3394: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
3395: l_serial_controlled := 1; -- Item is serial controlled
3396: END IF;
3397: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN

Line 3394: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN

3390: END IF;
3391: l_serial_controlled := 0;
3392: l_serial_status_enabled := 0;
3393: IF inv_cache.set_item_rec(p_organization_id, l_cur_mtrl.inventory_item_id) THEN
3394: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
3395: l_serial_controlled := 1; -- Item is serial controlled
3396: END IF;
3397: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
3398: l_serial_status_enabled := 1;

Line 3397: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN

3393: IF inv_cache.set_item_rec(p_organization_id, l_cur_mtrl.inventory_item_id) THEN
3394: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
3395: l_serial_controlled := 1; -- Item is serial controlled
3396: END IF;
3397: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
3398: l_serial_status_enabled := 1;
3399: END IF;
3400: END IF;
3401: IF (l_serial_controlled <> 1) then

Line 3502: IF inv_cache.set_item_rec(l_lpn_org_id, l_mmtt_cur.inventory_item_id) THEN

3498: LOOP
3499: l_serial_status_enabled := 0;
3500: l_serial_controlled := 0;
3501: l_lot_controlled := 0;
3502: IF inv_cache.set_item_rec(l_lpn_org_id, l_mmtt_cur.inventory_item_id) THEN
3503: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
3504: l_serial_controlled := 1; -- Item is serial controlled
3505: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
3506: l_serial_status_enabled := 1;

Line 3503: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN

3499: l_serial_status_enabled := 0;
3500: l_serial_controlled := 0;
3501: l_lot_controlled := 0;
3502: IF inv_cache.set_item_rec(l_lpn_org_id, l_mmtt_cur.inventory_item_id) THEN
3503: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
3504: l_serial_controlled := 1; -- Item is serial controlled
3505: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
3506: l_serial_status_enabled := 1;
3507: END IF;

Line 3505: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN

3501: l_lot_controlled := 0;
3502: IF inv_cache.set_item_rec(l_lpn_org_id, l_mmtt_cur.inventory_item_id) THEN
3503: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
3504: l_serial_controlled := 1; -- Item is serial controlled
3505: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
3506: l_serial_status_enabled := 1;
3507: END IF;
3508: END IF;
3509: IF (inv_cache.item_rec.lot_control_code = 2) THEN

Line 3509: IF (inv_cache.item_rec.lot_control_code = 2) THEN

3505: IF (NVL(inv_cache.item_rec.serial_status_enabled,'Y') = 'Y') THEN
3506: l_serial_status_enabled := 1;
3507: END IF;
3508: END IF;
3509: IF (inv_cache.item_rec.lot_control_code = 2) THEN
3510: l_lot_controlled := 1; -- item is lot controlled
3511: END IF;
3512: END IF;
3513: inv_trx_util_pub.TRACE('L_SERIAL_CONTROLLED_FLAG IS '||l_serial_controlled||'l_serial_status_enabled flag is '||l_serial_status_enabled,9);