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 263: l_ret := INV_VALIDATE.organization(l_org);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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