APPS.MTL_LOT_UOM_CONV_PUB dependencies on INV_VALIDATE

Line 114: l_org INV_VALIDATE.org;

110: l_api_version CONSTANT NUMBER := 1.0 ;
111: l_conv_seq MTL_LOT_UOM_CLASS_CONVERSIONS.CONVERSION_ID%TYPE;
112: l_aud_seq MTL_LOT_CONV_AUDIT.CONV_AUDIT_ID%TYPE;
113:
114: l_org INV_VALIDATE.org;
115: l_item INV_VALIDATE.item;
116: l_locator INV_VALIDATE.locator;
117: l_lot INV_VALIDATE.lot;
118: l_sub INV_VALIDATE.sub;

Line 115: l_item INV_VALIDATE.item;

111: l_conv_seq MTL_LOT_UOM_CLASS_CONVERSIONS.CONVERSION_ID%TYPE;
112: l_aud_seq MTL_LOT_CONV_AUDIT.CONV_AUDIT_ID%TYPE;
113:
114: l_org INV_VALIDATE.org;
115: l_item INV_VALIDATE.item;
116: l_locator INV_VALIDATE.locator;
117: l_lot INV_VALIDATE.lot;
118: l_sub INV_VALIDATE.sub;
119: l_revision varchar2(10);

Line 116: l_locator INV_VALIDATE.locator;

112: l_aud_seq MTL_LOT_CONV_AUDIT.CONV_AUDIT_ID%TYPE;
113:
114: l_org INV_VALIDATE.org;
115: l_item INV_VALIDATE.item;
116: l_locator INV_VALIDATE.locator;
117: l_lot INV_VALIDATE.lot;
118: l_sub INV_VALIDATE.sub;
119: l_revision varchar2(10);
120: l_ret NUMBER;

Line 117: l_lot INV_VALIDATE.lot;

113:
114: l_org INV_VALIDATE.org;
115: l_item INV_VALIDATE.item;
116: l_locator INV_VALIDATE.locator;
117: l_lot INV_VALIDATE.lot;
118: l_sub INV_VALIDATE.sub;
119: l_revision varchar2(10);
120: l_ret NUMBER;
121: l_err_msg VARCHAR2(2000);

Line 118: l_sub INV_VALIDATE.sub;

114: l_org INV_VALIDATE.org;
115: l_item INV_VALIDATE.item;
116: l_locator INV_VALIDATE.locator;
117: l_lot INV_VALIDATE.lot;
118: l_sub INV_VALIDATE.sub;
119: l_revision varchar2(10);
120: l_ret NUMBER;
121: l_err_msg VARCHAR2(2000);
122: l_reason_id NUMBER;

Line 261: l_ret := INV_VALIDATE.organization(l_org);

257: /*===============================
258: Validate Organization
259: ==============================*/
260: l_org.organization_id := p_lot_uom_conv_rec.organization_id;
261: l_ret := INV_VALIDATE.organization(l_org);
262: IF (l_ret = INV_VALIDATE.F) THEN
263: FND_MESSAGE.SET_NAME('INV','INV_LOTC_ORG_INVALID');
264: FND_MSG_PUB.Add;
265: RAISE FND_API.G_EXC_ERROR;

Line 262: IF (l_ret = INV_VALIDATE.F) THEN

258: Validate Organization
259: ==============================*/
260: l_org.organization_id := p_lot_uom_conv_rec.organization_id;
261: l_ret := INV_VALIDATE.organization(l_org);
262: IF (l_ret = INV_VALIDATE.F) THEN
263: FND_MESSAGE.SET_NAME('INV','INV_LOTC_ORG_INVALID');
264: FND_MSG_PUB.Add;
265: RAISE FND_API.G_EXC_ERROR;
266: END IF;

Line 274: l_ret := INV_VALIDATE.inventory_item(l_item, l_org);

270: ==============================*/
271: l_item.inventory_item_id := p_lot_uom_conv_rec.inventory_item_id;
272: l_item.organization_id := p_lot_uom_conv_rec.organization_id;
273:
274: l_ret := INV_VALIDATE.inventory_item(l_item, l_org);
275: IF (l_ret = INV_VALIDATE.F) THEN
276: FND_MESSAGE.SET_NAME('INV','INV_LOTC_ITEM_INVALID');
277: FND_MSG_PUB.Add;
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 275: IF (l_ret = INV_VALIDATE.F) THEN

271: l_item.inventory_item_id := p_lot_uom_conv_rec.inventory_item_id;
272: l_item.organization_id := p_lot_uom_conv_rec.organization_id;
273:
274: l_ret := INV_VALIDATE.inventory_item(l_item, l_org);
275: IF (l_ret = INV_VALIDATE.F) THEN
276: FND_MESSAGE.SET_NAME('INV','INV_LOTC_ITEM_INVALID');
277: FND_MSG_PUB.Add;
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: END IF;

Line 287: l_ret := INV_VALIDATE.lot_number(l_lot, l_org, l_item);

283: ==============================*/
284: l_lot.inventory_item_id := p_lot_uom_conv_rec.inventory_item_id;
285: l_lot.organization_id := p_lot_uom_conv_rec.organization_id;
286: l_lot.lot_number := p_lot_uom_conv_rec.lot_number;
287: l_ret := INV_VALIDATE.lot_number(l_lot, l_org, l_item);
288: IF (l_ret = INV_VALIDATE.F) THEN
289: FND_MESSAGE.SET_NAME('INV','INV_LOTC_LOT_INVALID');
290: FND_MSG_PUB.Add;
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 288: IF (l_ret = INV_VALIDATE.F) THEN

284: l_lot.inventory_item_id := p_lot_uom_conv_rec.inventory_item_id;
285: l_lot.organization_id := p_lot_uom_conv_rec.organization_id;
286: l_lot.lot_number := p_lot_uom_conv_rec.lot_number;
287: l_ret := INV_VALIDATE.lot_number(l_lot, l_org, l_item);
288: IF (l_ret = INV_VALIDATE.F) THEN
289: FND_MESSAGE.SET_NAME('INV','INV_LOTC_LOT_INVALID');
290: FND_MSG_PUB.Add;
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292: END IF;

Line 600: l_ret := INV_VALIDATE.reason(l_reason_id);

596:
597: l_ret := G_TRUE;
598: IF (p_reason_id IS NOT NULL) THEN
599: l_reason_id := p_reason_id;
600: l_ret := INV_VALIDATE.reason(l_reason_id);
601: IF (l_ret = INV_VALIDATE.F) THEN
602: FND_MSG_PUB.Add;
603: RAISE FND_API.G_EXC_ERROR;
604: END IF;

Line 601: IF (l_ret = INV_VALIDATE.F) THEN

597: l_ret := G_TRUE;
598: IF (p_reason_id IS NOT NULL) THEN
599: l_reason_id := p_reason_id;
600: l_ret := INV_VALIDATE.reason(l_reason_id);
601: IF (l_ret = INV_VALIDATE.F) THEN
602: FND_MSG_PUB.Add;
603: RAISE FND_API.G_EXC_ERROR;
604: END IF;
605: END IF;