DBA Data[Home] [Help]

APPS.OE_VALIDATE_LOT_SERIAL dependencies on OE_MSG_PUB

Line 141: OE_MSG_PUB.Add;

137:
138: l_return_status := FND_API.G_RET_STS_ERROR;
139: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Lot Serial ID');
141: OE_MSG_PUB.Add;
142:
143: END IF;
144:
145: --

Line 155: OE_MSG_PUB.Add;

151:
152: l_return_status := FND_API.G_RET_STS_ERROR;
153: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
154: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Quantity');
155: OE_MSG_PUB.Add;
156:
157: END IF;
158:
159: -- Return Error if a required attribute is missing.

Line 180: OE_MSG_PUB.Add;

176: THEN
177: l_return_status := FND_API.G_RET_STS_ERROR;
178: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
179: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Lot Number/From Serial Number');
180: OE_MSG_PUB.Add;
181:
182: END IF;
183: END IF; -- OPM new
184:

Line 193: OE_MSG_PUB.Add;

189:
190: l_return_status := FND_API.G_RET_STS_ERROR;
191: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
192: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','To Serial Number');
193: OE_MSG_PUB.Add;
194:
195: END IF;
196:
197: IF l_debug_level > 0 THEN

Line 251: OE_MSG_PUB.Add;

247: IF p_Lot_Serial_rec.quantity > (l_ordered_qty - l_total_qty)
248: THEN
249: l_return_status := FND_API.G_RET_STS_ERROR;
250: FND_MESSAGE.SET_NAME('ONT','OE_TOO_MANY_LOT_SERIAL');
251: OE_MSG_PUB.Add;
252:
253: END IF;
254: END IF;
255: */

Line 288: OE_MSG_PUB.Add;

284: x_error_code)
285: THEN
286: l_return_status := FND_API.G_RET_STS_ERROR;
287: FND_MESSAGE.Set_Name('ONT','OE_NOT_KNOW_QUANTITY');
288: OE_MSG_PUB.Add;
289: IF l_debug_level > 0 THEN
290: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY 2' , 1 ) ;
291: END IF;
292: ELSE

Line 296: OE_MSG_PUB.Add;

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

Line 422: OE_MSG_PUB.Add;

418: IF l_debug_level > 0 THEN
419: oe_debug_pub.add( 'INVALID LINE LOT SERIALS LOT NUMBER...' ) ;
420: END IF;
421: FND_MESSAGE.SET_NAME('INV','INV_NO_LOT_CONTROL');
422: OE_MSG_PUB.Add;
423: l_return_status := FND_API.G_RET_STS_ERROR;
424: END IF;
425:
426: /* IF l_sublot_ctl <> 1 and INVCONV

Line 433: OE_MSG_PUB.Add;

429: IF l_debug_level > 0 THEN
430: oe_debug_pub.add( 'OPM INVALID LINE LOT SERIALS SUBLOT NUMBER...' ) ;
431: END IF;
432: FND_MESSAGE.SET_NAME('GMI','IC_SUBLOTNO');
433: OE_MSG_PUB.Add;
434: l_return_status := FND_API.G_RET_STS_ERROR;
435: END IF; */
436:
437: /* IF l_sublot_ctl = 1 and

Line 448: OE_MSG_PUB.Add;

444: IF l_debug_level > 0 THEN
445: oe_debug_pub.add( 'OPM INVALID LINE LOT SERIALS NO LOT NUMBER...' ) ;
446: END IF;
447: FND_MESSAGE.SET_NAME('INV','INV_MISSING_LOT');
448: OE_MSG_PUB.Add;
449: l_return_status := FND_API.G_RET_STS_ERROR;
450: END IF; */
451:
452:

Line 473: OE_MSG_PUB.Add;

469: IF l_debug_level > 0 THEN
470: oe_debug_pub.add( 'NO_DATA_FOUND WHEN checking RMA attribute lot number' ) ;
471: END IF;
472: FND_MESSAGE.SET_NAME('INV','INV_CHECK_LOT_ENTRY'); -- INVCONV PLSE ENTER A VALID LOT NUMBER
473: OE_MSG_PUB.Add;
474: l_return_status := FND_API.G_RET_STS_ERROR;
475:
476: END IF;
477:

Line 494: OE_MSG_PUB.Add;

490: oe_debug_pub.add( 'NO_DATA_FOUND WHEN checking RMA attribute lot number' ) ;
491: END IF;
492: l_lot_id := 0;
493: FND_MESSAGE.SET_NAME('INV','INV_CHECK_LOT_ENTRY'); -- INVCONV PLSE ENTER A VALID LOT NUMBER
494: OE_MSG_PUB.Add;
495: l_return_status := FND_API.G_RET_STS_ERROR;
496:
497: END IF;
498:

Line 525: OE_MSG_PUB.Add;

521: oe_debug_pub.add( 'OPM NO_DATA_FOUND WHEN checking OPM RMA attribute sublot number' ) ;
522: END IF;
523: l_lot_id := 0;
524: FND_MESSAGE.SET_NAME('GMI','IC_SUBLOTNO');
525: OE_MSG_PUB.Add;
526: l_return_status := FND_API.G_RET_STS_ERROR;
527:
528: END IF;
529:

Line 552: OE_MSG_PUB.Add;

548: FND_MESSAGE.SET_NAME('INV','INV_SECONDARY_QTY_NOT_REQUIRED'); --INVCONV
549: --FND_MESSAGE.SET_TOKEN('ITEM_NO',L_ITEM_NO); INVCONV
550: --FND_MESSAGE.SET_TOKEN('LOT_NO',p_lot_serial_rec.lot_number); INVCONV
551: --FND_MESSAGE.SET_TOKEN('SUBLOT_NO',p_lot_serial_rec.sublot_number); INVCONV
552: OE_MSG_PUB.Add;
553: l_return_status := FND_API.G_RET_STS_ERROR;
554: END IF;
555:
556: IF l_debug_level > 0 THEN

Line 564: OE_MSG_PUB.Add;

560:
561: IF nvl(p_lot_serial_rec.quantity2, 0) < 0 then
562:
563: FND_MESSAGE.SET_NAME('ONT','SO_PR_NEGATIVE_AMOUNT');
564: OE_MSG_PUB.Add;
565: l_return_status := FND_API.G_RET_STS_ERROR;
566: IF l_debug_level > 0 THEN
567: oe_debug_pub.add ('INVALID LINE LOT SERIALS QUANTITY2 - negative....');
568: END IF;

Line 585: OE_MSG_PUB.Add;

581: END IF;
582: IF (NVL(p_Lot_Serial_rec.quantity2,0) = 0 )
583: OR (NVL(p_Lot_Serial_rec.quantity,0 ) = 0 ) THEN
584: FND_MESSAGE.SET_NAME('ONT','OE_BULK_OPM_NULL_QTY');
585: OE_MSG_PUB.Add;
586: l_return_status := FND_API.G_RET_STS_ERROR;
587: IF l_debug_level > 0 THEN
588: oe_debug_pub.add ('INVALID LINE LOT SERIALS - one qty is blank for type No Default..');
589: END IF;

Line 691: oe_msg_pub.add_text(p_message_text => l_buffer);

687: END IF;
688:
689: l_buffer := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
690: p_encoded => 'F');
691: oe_msg_pub.add_text(p_message_text => l_buffer);
692: IF l_debug_level > 0 THEN
693: oe_debug_pub.add(l_buffer,1);
694: END IF;
695: RAISE TOLERANCE_ERROR ;

Line 720: OE_MSG_PUB.Add;

716:
717: IF (l_return = -68 ) THEN
718: l_return_status := FND_API.G_RET_STS_ERROR;
719: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');
720: OE_MSG_PUB.Add;
721: ELSIF(l_return = -69 ) THEN
722: l_return_status := FND_API.G_RET_STS_ERROR;
723: FND_MESSAGE.set_name('GMI','IC_DEVIATION_LO_ERR');
724: OE_MSG_PUB.Add;

Line 724: OE_MSG_PUB.Add;

720: OE_MSG_PUB.Add;
721: ELSIF(l_return = -69 ) THEN
722: l_return_status := FND_API.G_RET_STS_ERROR;
723: FND_MESSAGE.set_name('GMI','IC_DEVIATION_LO_ERR');
724: OE_MSG_PUB.Add;
725: END IF;
726: IF l_return <> 0
727: THEN
728: l_return_status := FND_API.G_RET_STS_ERROR;

Line 769: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

765: WHEN OTHERS THEN
766:
767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
768:
769: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
770: THEN
771: OE_MSG_PUB.Add_Exc_Msg
772: ( G_PKG_NAME
773: , 'Entity'

Line 771: OE_MSG_PUB.Add_Exc_Msg

767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
768:
769: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
770: THEN
771: OE_MSG_PUB.Add_Exc_Msg
772: ( G_PKG_NAME
773: , 'Entity'
774: );
775: END IF;

Line 1116: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1112: WHEN OTHERS THEN
1113:
1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1115:
1116: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1117: THEN
1118: OE_MSG_PUB.Add_Exc_Msg
1119: ( G_PKG_NAME
1120: , 'Attributes'

Line 1118: OE_MSG_PUB.Add_Exc_Msg

1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1115:
1116: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1117: THEN
1118: OE_MSG_PUB.Add_Exc_Msg
1119: ( G_PKG_NAME
1120: , 'Attributes'
1121: );
1122: END IF;

Line 1162: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1158: WHEN OTHERS THEN
1159:
1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1161:
1162: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1163: THEN
1164: OE_MSG_PUB.Add_Exc_Msg
1165: ( G_PKG_NAME
1166: , 'Entity_Delete'

Line 1164: OE_MSG_PUB.Add_Exc_Msg

1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1161:
1162: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1163: THEN
1164: OE_MSG_PUB.Add_Exc_Msg
1165: ( G_PKG_NAME
1166: , 'Entity_Delete'
1167: );
1168: END IF;

Line 1197: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1193: WHEN OTHERS THEN
1194:
1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1196:
1197: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1198: THEN
1199: OE_MSG_PUB.Add_Exc_Msg
1200: ( G_PKG_NAME
1201: , 'Entity_Delete'

Line 1199: OE_MSG_PUB.Add_Exc_Msg

1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1196:
1197: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1198: THEN
1199: OE_MSG_PUB.Add_Exc_Msg
1200: ( G_PKG_NAME
1201: , 'Entity_Delete'
1202: );
1203: END IF;