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.WMS_OPP_CYC_COUNT dependencies on INV_CACHE

Line 60: l_serial_number_control_code := inv_cache.item_rec.serial_number_control_code;

56: Mdebug ( l_api_name||' : p_inventory_item_id = ' || p_inventory_item_id , g_message);
57: END IF;
58:
59:
60: l_serial_number_control_code := inv_cache.item_rec.serial_number_control_code;
61:
62: IF ( l_serial_number_control_code IN ( 1, 6 ) ) THEN
63: IF ( l_debug = 1 ) THEN
64: Mdebug ( l_api_name||' : Non serial controlled item' , g_message);

Line 220: IF (inv_cache.set_fromsub_rec(p_organization_id,p_subinventory_code)) THEN

216: Mdebug ( l_api_name||' : p_loc_id = ' || p_loc_id , g_message);
217: Mdebug ( l_api_name||' : p_inventory_item_id = ' || p_inventory_item_id , g_message);
218: END IF;
219:
220: IF (inv_cache.set_fromsub_rec(p_organization_id,p_subinventory_code)) THEN
221: IF (inv_cache.fromsub_rec.enable_opp_cyc_count = 'Y') THEN
222: l_opp_cyc_count_days := inv_cache.fromsub_rec.opp_cyc_count_days;
223: END IF;
224: ELSE

Line 221: IF (inv_cache.fromsub_rec.enable_opp_cyc_count = 'Y') THEN

217: Mdebug ( l_api_name||' : p_inventory_item_id = ' || p_inventory_item_id , g_message);
218: END IF;
219:
220: IF (inv_cache.set_fromsub_rec(p_organization_id,p_subinventory_code)) THEN
221: IF (inv_cache.fromsub_rec.enable_opp_cyc_count = 'Y') THEN
222: l_opp_cyc_count_days := inv_cache.fromsub_rec.opp_cyc_count_days;
223: END IF;
224: ELSE
225: IF (l_debug = 1) THEN

Line 222: l_opp_cyc_count_days := inv_cache.fromsub_rec.opp_cyc_count_days;

218: END IF;
219:
220: IF (inv_cache.set_fromsub_rec(p_organization_id,p_subinventory_code)) THEN
221: IF (inv_cache.fromsub_rec.enable_opp_cyc_count = 'Y') THEN
222: l_opp_cyc_count_days := inv_cache.fromsub_rec.opp_cyc_count_days;
223: END IF;
224: ELSE
225: IF (l_debug = 1) THEN
226: Mdebug(l_api_name||' : '||p_subinventory_code||' is an invalid subinv',g_error);

Line 294: IF (NOT inv_cache.Set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id)) THEN

290: END IF;
291:
292: l_progress := 'Validate Item';
293:
294: IF (NOT inv_cache.Set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id)) THEN
295:
296: IF (l_debug = 1) THEN
297: mdebug(l_api_name||' : '||p_inventory_item_id||' is an invalid item',g_error);
298: END IF;

Line 309: IF (inv_cache.item_rec.cycle_count_enabled_flag<>'Y') THEN

305:
306: l_progress := 'After Validating Item';
307:
308: -- Added for bug 9676695
309: IF (inv_cache.item_rec.cycle_count_enabled_flag<>'Y') THEN
310: RETURN l_cyc_count_header_id;
311: END IF;
312:
313:

Line 316: IF (NOT inv_cache.Set_fromsub_rec(p_subinventory_code => p_subinventory_code,

312:
313:
314: l_progress := 'Validate Subinventory';
315:
316: IF (NOT inv_cache.Set_fromsub_rec(p_subinventory_code => p_subinventory_code,
317: p_organization_id => p_organization_id)) THEN
318:
319: IF (l_debug = 1) THEN
320: Mdebug(l_api_name||' : '||p_subinventory_code||' is an invalid subinv',g_error);

Line 336: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.enable_opp_cyc_count = ' || inv_cache.fromsub_rec.enable_opp_cyc_count , g_message);

332: Mdebug(l_api_name||' : Opp cyc count @ Subinv level ',g_message);
333: END IF;
334:
335: IF ( l_debug = 1 ) THEN
336: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.enable_opp_cyc_count = ' || inv_cache.fromsub_rec.enable_opp_cyc_count , g_message);
337: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.opp_cyc_count_header_id = ' || inv_cache.fromsub_rec.opp_cyc_count_header_id , g_message);
338: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.pick_uom_code = ' || inv_cache.fromsub_rec.pick_uom_code , g_message);
339: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.opp_cyc_count_quantity = ' || inv_cache.fromsub_rec.opp_cyc_count_quantity , g_message);
340: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.opp_cyc_count_days = ' || inv_cache.fromsub_rec.opp_cyc_count_days , g_message);

Line 337: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.opp_cyc_count_header_id = ' || inv_cache.fromsub_rec.opp_cyc_count_header_id , g_message);

333: END IF;
334:
335: IF ( l_debug = 1 ) THEN
336: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.enable_opp_cyc_count = ' || inv_cache.fromsub_rec.enable_opp_cyc_count , g_message);
337: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.opp_cyc_count_header_id = ' || inv_cache.fromsub_rec.opp_cyc_count_header_id , g_message);
338: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.pick_uom_code = ' || inv_cache.fromsub_rec.pick_uom_code , g_message);
339: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.opp_cyc_count_quantity = ' || inv_cache.fromsub_rec.opp_cyc_count_quantity , g_message);
340: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.opp_cyc_count_days = ' || inv_cache.fromsub_rec.opp_cyc_count_days , g_message);
341: Mdebug ( l_api_name||' : inv_cache.item_rec.primary_uom_code = ' || inv_cache.item_rec.primary_uom_code , g_message);

Line 338: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.pick_uom_code = ' || inv_cache.fromsub_rec.pick_uom_code , g_message);

334:
335: IF ( l_debug = 1 ) THEN
336: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.enable_opp_cyc_count = ' || inv_cache.fromsub_rec.enable_opp_cyc_count , g_message);
337: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.opp_cyc_count_header_id = ' || inv_cache.fromsub_rec.opp_cyc_count_header_id , g_message);
338: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.pick_uom_code = ' || inv_cache.fromsub_rec.pick_uom_code , g_message);
339: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.opp_cyc_count_quantity = ' || inv_cache.fromsub_rec.opp_cyc_count_quantity , g_message);
340: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.opp_cyc_count_days = ' || inv_cache.fromsub_rec.opp_cyc_count_days , g_message);
341: Mdebug ( l_api_name||' : inv_cache.item_rec.primary_uom_code = ' || inv_cache.item_rec.primary_uom_code , g_message);
342: END IF;

Line 339: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.opp_cyc_count_quantity = ' || inv_cache.fromsub_rec.opp_cyc_count_quantity , g_message);

335: IF ( l_debug = 1 ) THEN
336: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.enable_opp_cyc_count = ' || inv_cache.fromsub_rec.enable_opp_cyc_count , g_message);
337: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.opp_cyc_count_header_id = ' || inv_cache.fromsub_rec.opp_cyc_count_header_id , g_message);
338: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.pick_uom_code = ' || inv_cache.fromsub_rec.pick_uom_code , g_message);
339: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.opp_cyc_count_quantity = ' || inv_cache.fromsub_rec.opp_cyc_count_quantity , g_message);
340: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.opp_cyc_count_days = ' || inv_cache.fromsub_rec.opp_cyc_count_days , g_message);
341: Mdebug ( l_api_name||' : inv_cache.item_rec.primary_uom_code = ' || inv_cache.item_rec.primary_uom_code , g_message);
342: END IF;
343:

Line 340: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.opp_cyc_count_days = ' || inv_cache.fromsub_rec.opp_cyc_count_days , g_message);

336: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.enable_opp_cyc_count = ' || inv_cache.fromsub_rec.enable_opp_cyc_count , g_message);
337: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.opp_cyc_count_header_id = ' || inv_cache.fromsub_rec.opp_cyc_count_header_id , g_message);
338: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.pick_uom_code = ' || inv_cache.fromsub_rec.pick_uom_code , g_message);
339: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.opp_cyc_count_quantity = ' || inv_cache.fromsub_rec.opp_cyc_count_quantity , g_message);
340: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.opp_cyc_count_days = ' || inv_cache.fromsub_rec.opp_cyc_count_days , g_message);
341: Mdebug ( l_api_name||' : inv_cache.item_rec.primary_uom_code = ' || inv_cache.item_rec.primary_uom_code , g_message);
342: END IF;
343:
344:

Line 341: Mdebug ( l_api_name||' : inv_cache.item_rec.primary_uom_code = ' || inv_cache.item_rec.primary_uom_code , g_message);

337: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.opp_cyc_count_header_id = ' || inv_cache.fromsub_rec.opp_cyc_count_header_id , g_message);
338: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.pick_uom_code = ' || inv_cache.fromsub_rec.pick_uom_code , g_message);
339: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.opp_cyc_count_quantity = ' || inv_cache.fromsub_rec.opp_cyc_count_quantity , g_message);
340: Mdebug ( l_api_name||' : inv_cache.fromsub_rec.opp_cyc_count_days = ' || inv_cache.fromsub_rec.opp_cyc_count_days , g_message);
341: Mdebug ( l_api_name||' : inv_cache.item_rec.primary_uom_code = ' || inv_cache.item_rec.primary_uom_code , g_message);
342: END IF;
343:
344:
345:

Line 346: IF (inv_cache.fromsub_rec.enable_opp_cyc_count = 'Y'

342: END IF;
343:
344:
345:
346: IF (inv_cache.fromsub_rec.enable_opp_cyc_count = 'Y'
347: AND Nvl(inv_cache.fromsub_rec.opp_cyc_count_header_id,-1) > 0) THEN
348:
349: -- Added for bug 9676695
350:

Line 347: AND Nvl(inv_cache.fromsub_rec.opp_cyc_count_header_id,-1) > 0) THEN

343:
344:
345:
346: IF (inv_cache.fromsub_rec.enable_opp_cyc_count = 'Y'
347: AND Nvl(inv_cache.fromsub_rec.opp_cyc_count_header_id,-1) > 0) THEN
348:
349: -- Added for bug 9676695
350:
351: BEGIN

Line 356: WHERE cycle_count_header_id = inv_cache.fromsub_rec.opp_cyc_count_header_id

352:
353: SELECT 'Y'
354: INTO l_item_exists
355: FROM mtl_cycle_count_items
356: WHERE cycle_count_header_id = inv_cache.fromsub_rec.opp_cyc_count_header_id
357: AND inventory_item_id = p_inventory_item_id;
358:
359: EXCEPTION
360: WHEN NO_DATA_FOUND THEN

Line 389: IF (inv_cache.fromsub_rec.pick_uom_code IS NOT NULL) THEN

385: END IF;
386:
387: l_progress := 'Calling inv_convert.inv_um_convert';
388:
389: IF (inv_cache.fromsub_rec.pick_uom_code IS NOT NULL) THEN
390:
391: l_sub_tol_qty :=
392: inv_convert.inv_um_convert ( p_inventory_item_id,
393: 5,

Line 394: inv_cache.fromsub_rec.opp_cyc_count_quantity,

390:
391: l_sub_tol_qty :=
392: inv_convert.inv_um_convert ( p_inventory_item_id,
393: 5,
394: inv_cache.fromsub_rec.opp_cyc_count_quantity,
395: inv_cache.fromsub_rec.pick_uom_code,
396: inv_cache.item_rec.primary_uom_code,
397: NULL,
398: NULL

Line 395: inv_cache.fromsub_rec.pick_uom_code,

391: l_sub_tol_qty :=
392: inv_convert.inv_um_convert ( p_inventory_item_id,
393: 5,
394: inv_cache.fromsub_rec.opp_cyc_count_quantity,
395: inv_cache.fromsub_rec.pick_uom_code,
396: inv_cache.item_rec.primary_uom_code,
397: NULL,
398: NULL
399: );

Line 396: inv_cache.item_rec.primary_uom_code,

392: inv_convert.inv_um_convert ( p_inventory_item_id,
393: 5,
394: inv_cache.fromsub_rec.opp_cyc_count_quantity,
395: inv_cache.fromsub_rec.pick_uom_code,
396: inv_cache.item_rec.primary_uom_code,
397: NULL,
398: NULL
399: );
400: ELSE

Line 401: l_sub_tol_qty := inv_cache.fromsub_rec.opp_cyc_count_quantity;

397: NULL,
398: NULL
399: );
400: ELSE
401: l_sub_tol_qty := inv_cache.fromsub_rec.opp_cyc_count_quantity;
402: END IF;
403:
404: IF (l_debug = 1) THEN
405: Mdebug(l_api_name||' : l_sub_tol_qty = '||l_sub_tol_qty,g_message);

Line 409: AND l_no_of_days >= inv_cache.fromsub_rec.opp_cyc_count_days) THEN

405: Mdebug(l_api_name||' : l_sub_tol_qty = '||l_sub_tol_qty,g_message);
406: END IF;
407:
408: IF (l_tot_qty <= l_sub_tol_qty
409: AND l_no_of_days >= inv_cache.fromsub_rec.opp_cyc_count_days) THEN
410:
411: l_cyc_count_header_id := inv_cache.fromsub_rec.opp_cyc_count_header_id;
412:
413: END IF;

Line 411: l_cyc_count_header_id := inv_cache.fromsub_rec.opp_cyc_count_header_id;

407:
408: IF (l_tot_qty <= l_sub_tol_qty
409: AND l_no_of_days >= inv_cache.fromsub_rec.opp_cyc_count_days) THEN
410:
411: l_cyc_count_header_id := inv_cache.fromsub_rec.opp_cyc_count_header_id;
412:
413: END IF;
414:
415: IF (l_debug = 1) THEN

Line 538: l_serial_number_control_code := inv_cache.item_rec.serial_number_control_code;

534: Mdebug ( l_api_name||' : p_uom_code = ' || p_uom_code , g_message);
535: END IF;
536:
537:
538: l_serial_number_control_code := inv_cache.item_rec.serial_number_control_code;
539:
540: IF ( l_serial_number_control_code IN ( 1, 6 ) ) THEN
541: IF ( l_debug = 1 ) THEN
542: Mdebug ( l_api_name||' : Non serial controlled item' , g_message);

Line 695: inv_cache.item_rec.primary_uom_code,

691:
692: BEGIN
693:
694: SELECT Nvl(Sum(Decode(count_uom_current,
695: inv_cache.item_rec.primary_uom_code,
696: adj_cnt_qty,
697: (inv_convert.inv_um_convert(p_inventory_item_id,
698: 5,
699: adj_cnt_qty,

Line 701: inv_cache.item_rec.primary_uom_code,

697: (inv_convert.inv_um_convert(p_inventory_item_id,
698: 5,
699: adj_cnt_qty,
700: count_uom_current,
701: inv_cache.item_rec.primary_uom_code,
702: NULL,
703: NULL
704: )
705: )

Line 829: IF (NOT inv_cache.Set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id)) THEN

825: -- Initialize the output variable
826: x_system_quantity := 0;
827: l_progress := '10';
828:
829: IF (NOT inv_cache.Set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id)) THEN
830:
831: IF (l_debug = 1) THEN
832: mdebug(l_api_name||' : '||p_inventory_item_id||' is an invalid item',g_error);
833: END IF;

Line 841: l_serial_number_control_code := inv_cache.item_rec.serial_number_control_code;

837: RAISE fnd_api.g_exc_error;
838:
839: END IF;
840:
841: l_serial_number_control_code := inv_cache.item_rec.serial_number_control_code;
842:
843: l_progress := '20';
844:
845: IF ( l_serial_number_control_code IN ( 1, 6 ) ) THEN

Line 929: inv_cache.item_rec.primary_uom_code,

925:
926: BEGIN
927:
928: SELECT Nvl(Sum(Decode(count_uom_current,
929: inv_cache.item_rec.primary_uom_code,
930: adj_cnt_qty,
931: (inv_convert.inv_um_convert(p_inventory_item_id,
932: 5,
933: adj_cnt_qty,

Line 935: inv_cache.item_rec.primary_uom_code,

931: (inv_convert.inv_um_convert(p_inventory_item_id,
932: 5,
933: adj_cnt_qty,
934: count_uom_current,
935: inv_cache.item_rec.primary_uom_code,
936: NULL,
937: NULL
938: )
939: )

Line 1067: IF (NOT inv_cache.Set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id)) THEN

1063: -- Initialize the output variable
1064:
1065: l_progress := '10';
1066:
1067: IF (NOT inv_cache.Set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id)) THEN
1068:
1069: IF (l_debug = 1) THEN
1070: mdebug(l_api_name||' : '||p_inventory_item_id||' is an invalid item',g_error);
1071: END IF;

Line 1079: IF (NOT inv_cache.Set_org_rec(p_organization_id => p_organization_id)) THEN

1075: RAISE fnd_api.g_exc_error;
1076:
1077: END IF;
1078:
1079: IF (NOT inv_cache.Set_org_rec(p_organization_id => p_organization_id)) THEN
1080: IF (l_debug = 1) THEN
1081: mdebug(l_api_name||' : '||p_organization_id||' is an invalid organization id',g_error);
1082: END IF;
1083:

Line 1093: l_serial_number_control_code := inv_cache.item_rec.serial_number_control_code;

1089:
1090:
1091: l_progress := '20';
1092:
1093: l_serial_number_control_code := inv_cache.item_rec.serial_number_control_code;
1094:
1095: IF ( l_debug = 1 ) THEN
1096: Mdebug ( l_api_name||' : l_serial_number_control_code = ' || l_serial_number_control_code , g_message);
1097: END IF;

Line 1102: IF (( l_serial_number_control_code IN ( 1, 6 ) ) OR ( l_serial_number_control_code IN ( 2, 5 ) AND Nvl(inv_cache.org_rec.ALLOCATE_SERIAL_FLAG, 'N')='N')) THEN

1098:
1099:
1100: l_progress := '30';
1101:
1102: IF (( l_serial_number_control_code IN ( 1, 6 ) ) OR ( l_serial_number_control_code IN ( 2, 5 ) AND Nvl(inv_cache.org_rec.ALLOCATE_SERIAL_FLAG, 'N')='N')) THEN
1103:
1104: IF ( l_debug = 1 ) THEN
1105: Mdebug ( l_api_name||' : Non serial controlled item / serial item with no serial allocation' , g_message);
1106: END IF;

Line 1149: ELSIF ( l_serial_number_control_code IN ( 2, 5 ) AND Nvl(inv_cache.org_rec.ALLOCATE_SERIAL_FLAG, 'N')='Y') THEN

1145: END;
1146:
1147: l_progress := '50';
1148:
1149: ELSIF ( l_serial_number_control_code IN ( 2, 5 ) AND Nvl(inv_cache.org_rec.ALLOCATE_SERIAL_FLAG, 'N')='Y') THEN
1150:
1151: IF ( l_debug = 1 ) THEN
1152: Mdebug ( l_api_name||' : Serial controlled item with serial allocation' , g_message);
1153: END IF;

Line 1561: IF (NOT inv_cache.Set_org_rec(p_organization_id => p_organization_id)) THEN

1557: -- backorder pending tasks if needed.
1558:
1559: l_progress := '10';
1560:
1561: IF (NOT inv_cache.Set_org_rec(p_organization_id => p_organization_id)) THEN
1562:
1563: IF (l_debug = 1) THEN
1564: mdebug(l_api_name||' : '||p_organization_id||' is an invalid organization id',g_error);
1565: END IF;

Line 1578: l_serial_number_control_code := inv_cache.item_rec.serial_number_control_code;

1574: IF ( l_debug = 1 ) THEN
1575: Mdebug ( l_api_name||' : ***backorder_pending_tasks***' , g_message);
1576: END IF;
1577:
1578: l_serial_number_control_code := inv_cache.item_rec.serial_number_control_code;
1579:
1580: l_count_primary_qty :=
1581: inv_convert.inv_um_convert ( p_inventory_item_id,
1582: 5,

Line 1585: inv_cache.item_rec.primary_uom_code,

1581: inv_convert.inv_um_convert ( p_inventory_item_id,
1582: 5,
1583: p_count_quantity,
1584: p_count_uom,
1585: inv_cache.item_rec.primary_uom_code,
1586: NULL,
1587: NULL
1588: );
1589:

Line 1600: , p_uom_code => inv_cache.item_rec.primary_uom_code

1596: , p_parent_lpn_id => p_parent_lpn_id
1597: , p_inventory_item_id => p_inventory_item_id
1598: , p_revision => p_revision
1599: , p_lot_number => p_lot_number
1600: , p_uom_code => inv_cache.item_rec.primary_uom_code
1601: , x_system_quantity => l_sys_det_qty
1602: );
1603:
1604: IF ( l_debug = 1 ) THEN

Line 1622: , p_uom_code => inv_cache.item_rec.primary_uom_code

1618: , p_revision => p_revision
1619: , p_lot_number => p_lot_number
1620: , p_from_serial_number => p_from_serial_number
1621: , p_to_serial_number => p_to_serial_number
1622: , p_uom_code => inv_cache.item_rec.primary_uom_code
1623: , x_system_quantity => l_sys_ser_qty
1624: );
1625:
1626: IF ( l_debug = 1 ) THEN

Line 1763: OR (l_serial_number_control_code IN ( 2,5 ) AND l_sys_ser_qty>l_count_primary_qty AND Nvl(inv_cache.org_rec.ALLOCATE_SERIAL_FLAG, 'N')='N')) THEN

1759:
1760: l_progress := '40';
1761:
1762: IF ((l_serial_number_control_code IN ( 1, 6 ) AND l_sys_det_qty>l_count_primary_qty)
1763: OR (l_serial_number_control_code IN ( 2,5 ) AND l_sys_ser_qty>l_count_primary_qty AND Nvl(inv_cache.org_rec.ALLOCATE_SERIAL_FLAG, 'N')='N')) THEN
1764:
1765: get_allocated_qty
1766: ( p_organization_id => p_organization_id
1767: , p_subinventory => p_subinventory

Line 1831: IF (NOT inv_cache.Set_item_rec(p_organization_id => p_organization_id, p_item_id => lpn_contents_cur.inventory_item_id)) THEN

1827: OR (msn.current_organization_id = p_organization_id
1828: AND msn.lpn_id=wlc.parent_lpn_id)))
1829: LOOP
1830:
1831: IF (NOT inv_cache.Set_item_rec(p_organization_id => p_organization_id, p_item_id => lpn_contents_cur.inventory_item_id)) THEN
1832:
1833: IF (l_debug = 1) THEN
1834: mdebug(l_api_name||' : '||lpn_contents_cur.inventory_item_id||' is an invalid item',g_error);
1835: END IF;

Line 1888: IF ( Nvl(inv_cache.org_rec.ALLOCATE_SERIAL_FLAG, 'N')='Y' AND lpn_contents_cur.serial_number IS NOT NULL) THEN

1884: RAISE fnd_api.g_exc_error;
1885: END IF;
1886:
1887:
1888: IF ( Nvl(inv_cache.org_rec.ALLOCATE_SERIAL_FLAG, 'N')='Y' AND lpn_contents_cur.serial_number IS NOT NULL) THEN
1889:
1890: l_progress := '120';
1891:
1892: get_serial_allocated_qty

Line 1937: IF (NOT inv_cache.Set_item_rec(p_organization_id => p_organization_id, p_item_id => lpn_contents_cur.inventory_item_id)) THEN

1933: WHERE wlc.parent_lpn_id=p_parent_lpn_id
1934: GROUP BY wlc.inventory_item_id, wlc.lot_number, wlc.revision)
1935: LOOP
1936:
1937: IF (NOT inv_cache.Set_item_rec(p_organization_id => p_organization_id, p_item_id => lpn_contents_cur.inventory_item_id)) THEN
1938:
1939: IF (l_debug = 1) THEN
1940: mdebug(l_api_name||' : '||lpn_contents_cur.inventory_item_id||' is an invalid item',g_error);
1941: END IF;

Line 2011: IF (NOT inv_cache.Set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id)) THEN

2007: END LOOP;
2008:
2009: l_progress := '170';
2010:
2011: IF (NOT inv_cache.Set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id)) THEN
2012:
2013: IF (l_debug = 1) THEN
2014: mdebug(l_api_name||' : '||p_inventory_item_id||' is an invalid item',g_error);
2015: END IF;

Line 2030: inv_cache.item_rec.primary_uom_code,

2026: inv_convert.inv_um_convert ( p_inventory_item_id,
2027: 5,
2028: p_count_quantity,
2029: p_count_uom,
2030: inv_cache.item_rec.primary_uom_code,
2031: NULL,
2032: NULL
2033: );
2034:

Line 2120: OR (l_serial_number_control_code IN ( 2,5 ) AND l_sys_ser_qty>l_count_primary_qty AND Nvl(inv_cache.org_rec.ALLOCATE_SERIAL_FLAG, 'N')='N')) THEN

2116: Mdebug ( l_api_name||' : l_serial_number_control_code = ' || l_serial_number_control_code , g_message);
2117: END IF;
2118:
2119: IF ((l_serial_number_control_code IN ( 1, 6 ) AND l_sys_det_qty>l_count_primary_qty)
2120: OR (l_serial_number_control_code IN ( 2,5 ) AND l_sys_ser_qty>l_count_primary_qty AND Nvl(inv_cache.org_rec.ALLOCATE_SERIAL_FLAG, 'N')='N')) THEN
2121:
2122: l_progress := '210';
2123:
2124: get_locator_quantity

Line 2281: IF (NOT inv_cache.Set_org_rec(p_organization_id => p_organization_id)) THEN

2277: END IF;
2278:
2279: l_progress := 'Validate Organization';
2280:
2281: IF (NOT inv_cache.Set_org_rec(p_organization_id => p_organization_id)) THEN
2282:
2283: IF (l_debug = 1) THEN
2284: mdebug(l_api_name||' : '||p_organization_id||' is an invalid organization id',g_error);
2285: END IF;

Line 2297: IF (NOT inv_cache.Set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id)) THEN

2293: l_progress := 'After Validating Organization';
2294:
2295: l_progress := 'Validate Item';
2296:
2297: IF (NOT inv_cache.Set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id)) THEN
2298:
2299: IF (l_debug = 1) THEN
2300: mdebug(l_api_name||' : '||p_inventory_item_id||' is an invalid item',g_error);
2301: END IF;

Line 2440: IF (NOT inv_cache.Set_org_rec(p_organization_id => p_organization_id)) THEN

2436: END IF;
2437:
2438: l_progress := 'Validate Organization';
2439:
2440: IF (NOT inv_cache.Set_org_rec(p_organization_id => p_organization_id)) THEN
2441:
2442: IF (l_debug = 1) THEN
2443: mdebug(l_api_name||' : '||p_organization_id||' is an invalid organization id',g_error);
2444: END IF;

Line 2456: IF (NOT inv_cache.Set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id)) THEN

2452: l_progress := 'After Validating Organization';
2453:
2454: l_progress := 'Validate Item';
2455:
2456: IF (NOT inv_cache.Set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id)) THEN
2457:
2458: IF (l_debug = 1) THEN
2459: mdebug(l_api_name||' : '||p_inventory_item_id||' is an invalid item',g_error);
2460: END IF;

Line 2510: IF (NOT inv_cache.Set_item_rec(p_organization_id => p_organization_id, p_item_id => lpn_contents_cur.inventory_item_id)) THEN

2506: OR (msn.current_organization_id = p_organization_id
2507: AND msn.lpn_id=wlc.parent_lpn_id)))
2508: LOOP
2509:
2510: IF (NOT inv_cache.Set_item_rec(p_organization_id => p_organization_id, p_item_id => lpn_contents_cur.inventory_item_id)) THEN
2511:
2512: IF (l_debug = 1) THEN
2513: mdebug(l_api_name||' : '||lpn_contents_cur.inventory_item_id||' is an invalid item',g_error);
2514: END IF;

Line 2567: IF ( Nvl(inv_cache.org_rec.ALLOCATE_SERIAL_FLAG, 'N')='Y' AND lpn_contents_cur.serial_number IS NOT NULL) THEN

2563: RAISE fnd_api.g_exc_error;
2564: END IF;
2565:
2566:
2567: IF ( Nvl(inv_cache.org_rec.ALLOCATE_SERIAL_FLAG, 'N')='Y' AND lpn_contents_cur.serial_number IS NOT NULL) THEN
2568:
2569: l_progress := '120';
2570:
2571: get_serial_allocated_qty

Line 2616: IF (NOT inv_cache.Set_item_rec(p_organization_id => p_organization_id, p_item_id => lpn_contents_cur.inventory_item_id)) THEN

2612: WHERE wlc.parent_lpn_id=p_parent_lpn_id
2613: GROUP BY wlc.inventory_item_id, wlc.lot_number, wlc.revision)
2614: LOOP
2615:
2616: IF (NOT inv_cache.Set_item_rec(p_organization_id => p_organization_id, p_item_id => lpn_contents_cur.inventory_item_id)) THEN
2617:
2618: IF (l_debug = 1) THEN
2619: mdebug(l_api_name||' : '||lpn_contents_cur.inventory_item_id||' is an invalid item',g_error);
2620: END IF;

Line 2690: IF (NOT inv_cache.Set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id)) THEN

2686: END LOOP;
2687:
2688: l_progress := '170';
2689:
2690: IF (NOT inv_cache.Set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id)) THEN
2691:
2692: IF (l_debug = 1) THEN
2693: mdebug(l_api_name||' : '||p_inventory_item_id||' is an invalid item',g_error);
2694: END IF;