DBA Data[Home] [Help]

APPS.OE_VALIDATE_LOT_SERIAL dependencies on FND_MESSAGE

Line 136: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');

132: IF p_Lot_Serial_rec.lot_serial_id IS NULL
133: THEN
134:
135: l_return_status := FND_API.G_RET_STS_ERROR;
136: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
137: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Lot Serial ID');
138: OE_MSG_PUB.Add;
139:
140: END IF;

Line 137: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Lot Serial ID');

133: THEN
134:
135: l_return_status := FND_API.G_RET_STS_ERROR;
136: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
137: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Lot Serial ID');
138: OE_MSG_PUB.Add;
139:
140: END IF;
141:

Line 150: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');

146: IF p_Lot_Serial_rec.quantity IS NULL
147: THEN
148:
149: l_return_status := FND_API.G_RET_STS_ERROR;
150: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
151: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Quantity');
152: OE_MSG_PUB.Add;
153:
154: END IF;

Line 151: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Quantity');

147: THEN
148:
149: l_return_status := FND_API.G_RET_STS_ERROR;
150: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
151: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Quantity');
152: OE_MSG_PUB.Add;
153:
154: END IF;
155:

Line 175: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');

171: IF p_Lot_Serial_rec.lot_number IS NULL AND
172: p_Lot_Serial_rec.from_serial_number IS NULL
173: THEN
174: l_return_status := FND_API.G_RET_STS_ERROR;
175: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
176: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Lot Number/From Serial Number');
177: OE_MSG_PUB.Add;
178:
179: END IF;

Line 176: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Lot Number/From Serial Number');

172: p_Lot_Serial_rec.from_serial_number IS NULL
173: THEN
174: l_return_status := FND_API.G_RET_STS_ERROR;
175: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
176: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Lot Number/From Serial Number');
177: OE_MSG_PUB.Add;
178:
179: END IF;
180: END IF; -- OPM new

Line 188: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');

184: p_Lot_Serial_rec.to_serial_number IS NULL
185: THEN
186:
187: l_return_status := FND_API.G_RET_STS_ERROR;
188: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
189: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','To Serial Number');
190: OE_MSG_PUB.Add;
191:
192: END IF;

Line 189: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','To Serial Number');

185: THEN
186:
187: l_return_status := FND_API.G_RET_STS_ERROR;
188: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
189: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','To Serial Number');
190: OE_MSG_PUB.Add;
191:
192: END IF;
193:

Line 247: FND_MESSAGE.SET_NAME('ONT','OE_TOO_MANY_LOT_SERIAL');

243:
244: IF p_Lot_Serial_rec.quantity > (l_ordered_qty - l_total_qty)
245: THEN
246: l_return_status := FND_API.G_RET_STS_ERROR;
247: FND_MESSAGE.SET_NAME('ONT','OE_TOO_MANY_LOT_SERIAL');
248: OE_MSG_PUB.Add;
249:
250: END IF;
251: END IF;

Line 284: FND_MESSAGE.Set_Name('ONT','OE_NOT_KNOW_QUANTITY');

280: x_to_number,
281: x_error_code)
282: THEN
283: l_return_status := FND_API.G_RET_STS_ERROR;
284: FND_MESSAGE.Set_Name('ONT','OE_NOT_KNOW_QUANTITY');
285: OE_MSG_PUB.Add;
286: IF l_debug_level > 0 THEN
287: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY 2' , 1 ) ;
288: END IF;

Line 292: FND_MESSAGE.Set_Name('ONT','OE_QUANTITY_MISMATCH');

288: END IF;
289: ELSE
290: IF p_Lot_Serial_rec.quantity <> x_quantity THEN
291: l_return_status := FND_API.G_RET_STS_ERROR;
292: FND_MESSAGE.Set_Name('ONT','OE_QUANTITY_MISMATCH');
293: OE_MSG_PUB.Add;
294: IF l_debug_level > 0 THEN
295: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY 3' , 1 ) ;
296: END IF;

Line 417: FND_MESSAGE.SET_NAME('INV','INV_NO_LOT_CONTROL');

413: and p_Lot_Serial_rec.lot_number IS NOT NULL ) then
414: IF l_debug_level > 0 THEN
415: oe_debug_pub.add( 'INVALID LINE LOT SERIALS LOT NUMBER...' ) ;
416: END IF;
417: FND_MESSAGE.SET_NAME('INV','INV_NO_LOT_CONTROL');
418: OE_MSG_PUB.Add;
419: l_return_status := FND_API.G_RET_STS_ERROR;
420: END IF;
421:

Line 428: FND_MESSAGE.SET_NAME('GMI','IC_SUBLOTNO');

424: and p_Lot_Serial_rec.sublot_number IS NOT NULL ) then
425: IF l_debug_level > 0 THEN
426: oe_debug_pub.add( 'OPM INVALID LINE LOT SERIALS SUBLOT NUMBER...' ) ;
427: END IF;
428: FND_MESSAGE.SET_NAME('GMI','IC_SUBLOTNO');
429: OE_MSG_PUB.Add;
430: l_return_status := FND_API.G_RET_STS_ERROR;
431: END IF; */
432:

Line 443: FND_MESSAGE.SET_NAME('INV','INV_MISSING_LOT');

439:
440: IF l_debug_level > 0 THEN
441: oe_debug_pub.add( 'OPM INVALID LINE LOT SERIALS NO LOT NUMBER...' ) ;
442: END IF;
443: FND_MESSAGE.SET_NAME('INV','INV_MISSING_LOT');
444: OE_MSG_PUB.Add;
445: l_return_status := FND_API.G_RET_STS_ERROR;
446: END IF; */
447:

Line 468: FND_MESSAGE.SET_NAME('INV','INV_CHECK_LOT_ENTRY'); -- INVCONV PLSE ENTER A VALID LOT NUMBER

464: IF c_lot1%NOTFOUND THEN
465: IF l_debug_level > 0 THEN
466: oe_debug_pub.add( 'NO_DATA_FOUND WHEN checking RMA attribute lot number' ) ;
467: END IF;
468: FND_MESSAGE.SET_NAME('INV','INV_CHECK_LOT_ENTRY'); -- INVCONV PLSE ENTER A VALID LOT NUMBER
469: OE_MSG_PUB.Add;
470: l_return_status := FND_API.G_RET_STS_ERROR;
471:
472: END IF;

Line 489: FND_MESSAGE.SET_NAME('INV','INV_CHECK_LOT_ENTRY'); -- INVCONV PLSE ENTER A VALID LOT NUMBER

485: IF l_debug_level > 0 THEN
486: oe_debug_pub.add( 'NO_DATA_FOUND WHEN checking RMA attribute lot number' ) ;
487: END IF;
488: l_lot_id := 0;
489: FND_MESSAGE.SET_NAME('INV','INV_CHECK_LOT_ENTRY'); -- INVCONV PLSE ENTER A VALID LOT NUMBER
490: OE_MSG_PUB.Add;
491: l_return_status := FND_API.G_RET_STS_ERROR;
492:
493: END IF;

Line 520: FND_MESSAGE.SET_NAME('GMI','IC_SUBLOTNO');

516: IF l_debug_level > 0 THEN
517: oe_debug_pub.add( 'OPM NO_DATA_FOUND WHEN checking OPM RMA attribute sublot number' ) ;
518: END IF;
519: l_lot_id := 0;
520: FND_MESSAGE.SET_NAME('GMI','IC_SUBLOTNO');
521: OE_MSG_PUB.Add;
522: l_return_status := FND_API.G_RET_STS_ERROR;
523:
524: END IF;

Line 542: FND_MESSAGE.SET_NAME('INV','INV_SECONDARY_QTY_NOT_REQUIRED'); --INVCONV

538: and p_lot_serial_rec.quantity2 IS NOT NULL ) then
539: IF l_debug_level > 0 THEN
540: oe_debug_pub.add( 'INVALID LINE LOT SERIALS QUANTITY2...' ) ; -- INVCONV
541: END IF;
542: FND_MESSAGE.SET_NAME('INV','INV_SECONDARY_QTY_NOT_REQUIRED'); --INVCONV
543: --FND_MESSAGE.SET_TOKEN('ITEM_NO',L_ITEM_NO); INVCONV
544: --FND_MESSAGE.SET_TOKEN('LOT_NO',p_lot_serial_rec.lot_number); INVCONV
545: --FND_MESSAGE.SET_TOKEN('SUBLOT_NO',p_lot_serial_rec.sublot_number); INVCONV
546: OE_MSG_PUB.Add;

Line 543: --FND_MESSAGE.SET_TOKEN('ITEM_NO',L_ITEM_NO); INVCONV

539: IF l_debug_level > 0 THEN
540: oe_debug_pub.add( 'INVALID LINE LOT SERIALS QUANTITY2...' ) ; -- INVCONV
541: END IF;
542: FND_MESSAGE.SET_NAME('INV','INV_SECONDARY_QTY_NOT_REQUIRED'); --INVCONV
543: --FND_MESSAGE.SET_TOKEN('ITEM_NO',L_ITEM_NO); INVCONV
544: --FND_MESSAGE.SET_TOKEN('LOT_NO',p_lot_serial_rec.lot_number); INVCONV
545: --FND_MESSAGE.SET_TOKEN('SUBLOT_NO',p_lot_serial_rec.sublot_number); INVCONV
546: OE_MSG_PUB.Add;
547: l_return_status := FND_API.G_RET_STS_ERROR;

Line 544: --FND_MESSAGE.SET_TOKEN('LOT_NO',p_lot_serial_rec.lot_number); INVCONV

540: oe_debug_pub.add( 'INVALID LINE LOT SERIALS QUANTITY2...' ) ; -- INVCONV
541: END IF;
542: FND_MESSAGE.SET_NAME('INV','INV_SECONDARY_QTY_NOT_REQUIRED'); --INVCONV
543: --FND_MESSAGE.SET_TOKEN('ITEM_NO',L_ITEM_NO); INVCONV
544: --FND_MESSAGE.SET_TOKEN('LOT_NO',p_lot_serial_rec.lot_number); INVCONV
545: --FND_MESSAGE.SET_TOKEN('SUBLOT_NO',p_lot_serial_rec.sublot_number); INVCONV
546: OE_MSG_PUB.Add;
547: l_return_status := FND_API.G_RET_STS_ERROR;
548: END IF;

Line 545: --FND_MESSAGE.SET_TOKEN('SUBLOT_NO',p_lot_serial_rec.sublot_number); INVCONV

541: END IF;
542: FND_MESSAGE.SET_NAME('INV','INV_SECONDARY_QTY_NOT_REQUIRED'); --INVCONV
543: --FND_MESSAGE.SET_TOKEN('ITEM_NO',L_ITEM_NO); INVCONV
544: --FND_MESSAGE.SET_TOKEN('LOT_NO',p_lot_serial_rec.lot_number); INVCONV
545: --FND_MESSAGE.SET_TOKEN('SUBLOT_NO',p_lot_serial_rec.sublot_number); INVCONV
546: OE_MSG_PUB.Add;
547: l_return_status := FND_API.G_RET_STS_ERROR;
548: END IF;
549:

Line 557: FND_MESSAGE.SET_NAME('ONT','SO_PR_NEGATIVE_AMOUNT');

553: /* If quantity2 is present and negative, then error */
554:
555: IF nvl(p_lot_serial_rec.quantity2, 0) < 0 then
556:
557: FND_MESSAGE.SET_NAME('ONT','SO_PR_NEGATIVE_AMOUNT');
558: OE_MSG_PUB.Add;
559: l_return_status := FND_API.G_RET_STS_ERROR;
560: IF l_debug_level > 0 THEN
561: oe_debug_pub.add ('INVALID LINE LOT SERIALS QUANTITY2 - negative....');

Line 578: FND_MESSAGE.SET_NAME('ONT','OE_BULK_OPM_NULL_QTY');

574: oe_debug_pub.add( 'OE_Validate_Lot_Serial.entity - validating No default dual QUANTITYs...' ) ;
575: END IF;
576: IF (NVL(p_Lot_Serial_rec.quantity2,0) = 0 )
577: OR (NVL(p_Lot_Serial_rec.quantity,0 ) = 0 ) THEN
578: FND_MESSAGE.SET_NAME('ONT','OE_BULK_OPM_NULL_QTY');
579: OE_MSG_PUB.Add;
580: l_return_status := FND_API.G_RET_STS_ERROR;
581: IF l_debug_level > 0 THEN
582: oe_debug_pub.add ('INVALID LINE LOT SERIALS - one qty is blank for type No Default..');

Line 713: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');

709: ,0);
710:
711: IF (l_return = -68 ) THEN
712: l_return_status := FND_API.G_RET_STS_ERROR;
713: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');
714: OE_MSG_PUB.Add;
715: ELSIF(l_return = -69 ) THEN
716: l_return_status := FND_API.G_RET_STS_ERROR;
717: FND_MESSAGE.set_name('GMI','IC_DEVIATION_LO_ERR');

Line 717: FND_MESSAGE.set_name('GMI','IC_DEVIATION_LO_ERR');

713: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');
714: OE_MSG_PUB.Add;
715: ELSIF(l_return = -69 ) THEN
716: l_return_status := FND_API.G_RET_STS_ERROR;
717: FND_MESSAGE.set_name('GMI','IC_DEVIATION_LO_ERR');
718: OE_MSG_PUB.Add;
719: END IF;
720: IF l_return <> 0
721: THEN