DBA Data[Home] [Help]

APPS.OE_VALIDATE_LOT_SERIAL dependencies on OE_MSG_PUB

Line 138: OE_MSG_PUB.Add;

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:
142: --

Line 152: OE_MSG_PUB.Add;

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:
156: -- Return Error if a required attribute is missing.

Line 177: OE_MSG_PUB.Add;

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
181:

Line 190: OE_MSG_PUB.Add;

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:
194: IF l_debug_level > 0 THEN

Line 248: OE_MSG_PUB.Add;

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;
252: */

Line 285: OE_MSG_PUB.Add;

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;
289: ELSE

Line 293: OE_MSG_PUB.Add;

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;
297: END IF;

Line 418: OE_MSG_PUB.Add;

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:
422: /* IF l_sublot_ctl <> 1 and INVCONV

Line 429: OE_MSG_PUB.Add;

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:
433: /* IF l_sublot_ctl = 1 and

Line 444: OE_MSG_PUB.Add;

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:
448:

Line 469: OE_MSG_PUB.Add;

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;
473:

Line 490: OE_MSG_PUB.Add;

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;
494:

Line 521: OE_MSG_PUB.Add;

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;
525:

Line 546: OE_MSG_PUB.Add;

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:
550: IF l_debug_level > 0 THEN

Line 558: OE_MSG_PUB.Add;

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....');
562: END IF;

Line 579: OE_MSG_PUB.Add;

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..');
583: END IF;

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

681: END IF;
682:
683: l_buffer := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
684: p_encoded => 'F');
685: oe_msg_pub.add_text(p_message_text => l_buffer);
686: IF l_debug_level > 0 THEN
687: oe_debug_pub.add(l_buffer,1);
688: END IF;
689: RAISE TOLERANCE_ERROR ;

Line 714: OE_MSG_PUB.Add;

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');
718: OE_MSG_PUB.Add;

Line 718: OE_MSG_PUB.Add;

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
722: l_return_status := FND_API.G_RET_STS_ERROR;

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

759: WHEN OTHERS THEN
760:
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
762:
763: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
764: THEN
765: OE_MSG_PUB.Add_Exc_Msg
766: ( G_PKG_NAME
767: , 'Entity'

Line 765: OE_MSG_PUB.Add_Exc_Msg

761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
762:
763: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
764: THEN
765: OE_MSG_PUB.Add_Exc_Msg
766: ( G_PKG_NAME
767: , 'Entity'
768: );
769: END IF;

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

1106: WHEN OTHERS THEN
1107:
1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1109:
1110: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1111: THEN
1112: OE_MSG_PUB.Add_Exc_Msg
1113: ( G_PKG_NAME
1114: , 'Attributes'

Line 1112: OE_MSG_PUB.Add_Exc_Msg

1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1109:
1110: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1111: THEN
1112: OE_MSG_PUB.Add_Exc_Msg
1113: ( G_PKG_NAME
1114: , 'Attributes'
1115: );
1116: END IF;

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

1152: WHEN OTHERS THEN
1153:
1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1155:
1156: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1157: THEN
1158: OE_MSG_PUB.Add_Exc_Msg
1159: ( G_PKG_NAME
1160: , 'Entity_Delete'

Line 1158: OE_MSG_PUB.Add_Exc_Msg

1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1155:
1156: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1157: THEN
1158: OE_MSG_PUB.Add_Exc_Msg
1159: ( G_PKG_NAME
1160: , 'Entity_Delete'
1161: );
1162: END IF;

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

1187: WHEN OTHERS THEN
1188:
1189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1190:
1191: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1192: THEN
1193: OE_MSG_PUB.Add_Exc_Msg
1194: ( G_PKG_NAME
1195: , 'Entity_Delete'

Line 1193: OE_MSG_PUB.Add_Exc_Msg

1189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1190:
1191: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1192: THEN
1193: OE_MSG_PUB.Add_Exc_Msg
1194: ( G_PKG_NAME
1195: , 'Entity_Delete'
1196: );
1197: END IF;