DBA Data[Home] [Help]

APPS.WMS_CONSOLIDATION_PUB dependencies on INV_CACHE

Line 2810: -- to set the current subinventory in INV_CACHE

2806: END;
2807:
2808: /* Added for bug# 12687532, start here */
2809:
2810: -- to set the current subinventory in INV_CACHE
2811: IF INV_CACHE.set_fromsub_rec(p_org_id,l_orig_sub)
2812: THEN
2813: IF (l_debug = 1) THEN
2814: mydebug('Setting Subinv info = '||INV_CACHE.fromsub_rec.secondary_inventory_name);

Line 2811: IF INV_CACHE.set_fromsub_rec(p_org_id,l_orig_sub)

2807:
2808: /* Added for bug# 12687532, start here */
2809:
2810: -- to set the current subinventory in INV_CACHE
2811: IF INV_CACHE.set_fromsub_rec(p_org_id,l_orig_sub)
2812: THEN
2813: IF (l_debug = 1) THEN
2814: mydebug('Setting Subinv info = '||INV_CACHE.fromsub_rec.secondary_inventory_name);
2815: END IF;

Line 2814: mydebug('Setting Subinv info = '||INV_CACHE.fromsub_rec.secondary_inventory_name);

2810: -- to set the current subinventory in INV_CACHE
2811: IF INV_CACHE.set_fromsub_rec(p_org_id,l_orig_sub)
2812: THEN
2813: IF (l_debug = 1) THEN
2814: mydebug('Setting Subinv info = '||INV_CACHE.fromsub_rec.secondary_inventory_name);
2815: END IF;
2816: ELSE
2817: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SUB');
2818: fnd_msg_pub.ADD;

Line 2823: IF INV_CACHE.fromsub_rec.RESERVABLE_TYPE= 1 THEN

2819: RAISE fnd_api.g_exc_error;
2820: END IF;
2821:
2822: -- to check if the current subinventory is reservable
2823: IF INV_CACHE.fromsub_rec.RESERVABLE_TYPE= 1 THEN
2824: l_posting_flag := 'N';
2825: ELSE
2826: l_posting_flag := 'Y';
2827: END IF;