APPS.AHL_UC_INSTANCE_PVT dependencies on MTL_LOT_NUMBERS

Line 116: CURSOR mtl_lot_numbers_csr(c_inventory_id IN NUMBER,

112: p_organization_id IN NUMBER,
113: p_lot_control_code IN NUMBER,
114: p_lot_number IN VARCHAR2,
115: p_concatenated_segments IN VARCHAR2) IS
116: CURSOR mtl_lot_numbers_csr(c_inventory_id IN NUMBER,
117: c_organization_id IN NUMBER,
118: c_lot_number IN VARCHAR2) IS
119: SELECT 'X'
120: FROM mtl_lot_numbers

Line 120: FROM mtl_lot_numbers

116: CURSOR mtl_lot_numbers_csr(c_inventory_id IN NUMBER,
117: c_organization_id IN NUMBER,
118: c_lot_number IN VARCHAR2) IS
119: SELECT 'X'
120: FROM mtl_lot_numbers
121: WHERE inventory_item_id = c_inventory_id
122: AND organization_id = c_organization_id
123: AND lot_number = c_lot_number
124: AND nvl(disable_flag,2) = 2;

Line 135: OPEN mtl_lot_numbers_csr(p_inventory_id,p_organization_id, p_lot_number);

131: FND_MESSAGE.set_token('INV_ITEM',p_concatenated_segments);
132: FND_MSG_PUB.add;
133: --dbms_output.put_line('Lot Number is null');
134: ELSE
135: OPEN mtl_lot_numbers_csr(p_inventory_id,p_organization_id, p_lot_number);
136: FETCH mtl_lot_numbers_csr INTO l_junk;
137: IF (mtl_lot_numbers_csr%NOTFOUND) THEN
138: FND_MESSAGE.set_name('AHL','AHL_UC_LOT_INVALID');
139: FND_MESSAGE.set_token('LOT',p_Lot_number);

Line 136: FETCH mtl_lot_numbers_csr INTO l_junk;

132: FND_MSG_PUB.add;
133: --dbms_output.put_line('Lot Number is null');
134: ELSE
135: OPEN mtl_lot_numbers_csr(p_inventory_id,p_organization_id, p_lot_number);
136: FETCH mtl_lot_numbers_csr INTO l_junk;
137: IF (mtl_lot_numbers_csr%NOTFOUND) THEN
138: FND_MESSAGE.set_name('AHL','AHL_UC_LOT_INVALID');
139: FND_MESSAGE.set_token('LOT',p_Lot_number);
140: FND_MESSAGE.set_token('INV_ITEM',p_concatenated_segments);

Line 137: IF (mtl_lot_numbers_csr%NOTFOUND) THEN

133: --dbms_output.put_line('Lot Number is null');
134: ELSE
135: OPEN mtl_lot_numbers_csr(p_inventory_id,p_organization_id, p_lot_number);
136: FETCH mtl_lot_numbers_csr INTO l_junk;
137: IF (mtl_lot_numbers_csr%NOTFOUND) THEN
138: FND_MESSAGE.set_name('AHL','AHL_UC_LOT_INVALID');
139: FND_MESSAGE.set_token('LOT',p_Lot_number);
140: FND_MESSAGE.set_token('INV_ITEM',p_concatenated_segments);
141: FND_MSG_PUB.add;

Line 144: CLOSE mtl_lot_numbers_csr;

140: FND_MESSAGE.set_token('INV_ITEM',p_concatenated_segments);
141: FND_MSG_PUB.add;
142: --dbms_output.put_line('Lot number does not exist in master');
143: END IF;
144: CLOSE mtl_lot_numbers_csr;
145: END IF;
146: ELSIF (p_Lot_number <> FND_API.G_MISS_CHAR) AND (p_lot_Number IS NOT NULL) THEN
147:
148: -- If lot number not controlled; then lot num must be null.