eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_VALIDATE_LOT_SERIAL dependencies on OE_DEBUG_PUB

Line 123: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

119: --l_item_rec OE_ORDER_CACHE.item_rec_type; INVCONV
120: -- OPM 3494420
121:
122: --
123: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
124: --
125: BEGIN
126:
127: IF l_debug_level > 0 THEN

Line 128: oe_debug_pub.add( 'ENTERING OE_VALIDATE_LOT_SERIAL.ENTITY' , 1 ) ;

124: --
125: BEGIN
126:
127: IF l_debug_level > 0 THEN
128: oe_debug_pub.add( 'ENTERING OE_VALIDATE_LOT_SERIAL.ENTITY' , 1 ) ;
129: END IF;
130: -- Check required attributes.
131:
132: IF p_Lot_Serial_rec.lot_serial_id IS NULL

Line 195: oe_debug_pub.add( 'THE QUANTITY IS '||TO_CHAR ( P_LOT_SERIAL_REC.QUANTITY ) , 1 ) ;

191:
192: END IF;
193:
194: IF l_debug_level > 0 THEN
195: oe_debug_pub.add( 'THE QUANTITY IS '||TO_CHAR ( P_LOT_SERIAL_REC.QUANTITY ) , 1 ) ;
196: END IF;
197: IF l_debug_level > 0 THEN
198: oe_debug_pub.add( 'THE OLD QUANTITY IS '||TO_CHAR ( P_OLD_LOT_SERIAL_REC.QUANTITY ) , 1 ) ;
199: END IF;

Line 198: oe_debug_pub.add( 'THE OLD QUANTITY IS '||TO_CHAR ( P_OLD_LOT_SERIAL_REC.QUANTITY ) , 1 ) ;

194: IF l_debug_level > 0 THEN
195: oe_debug_pub.add( 'THE QUANTITY IS '||TO_CHAR ( P_LOT_SERIAL_REC.QUANTITY ) , 1 ) ;
196: END IF;
197: IF l_debug_level > 0 THEN
198: oe_debug_pub.add( 'THE OLD QUANTITY IS '||TO_CHAR ( P_OLD_LOT_SERIAL_REC.QUANTITY ) , 1 ) ;
199: END IF;
200:
201:
202: -- We should not validate the quantity field on oe_lot_serial_numbers table as

Line 215: oe_debug_pub.add( 'QUERYING FOR LINE_SET_ID' , 1 ) ;

211: p_old_Lot_Serial_rec.quantity)
212: THEN
213: IF p_Lot_Serial_rec.line_set_id IS NOT NULL THEN
214: IF l_debug_level > 0 THEN
215: oe_debug_pub.add( 'QUERYING FOR LINE_SET_ID' , 1 ) ;
216: END IF;
217: SELECT NVL(SUM(ORDERED_QUANTITY),0)
218: INTO l_ordered_qty
219: FROM OE_ORDER_LINES

Line 229: oe_debug_pub.add( 'QUERYING FOR LINE_ID' , 1 ) ;

225: WHERE line_set_id = p_Lot_Serial_rec.line_set_id
226: AND lot_serial_id <> p_Lot_Serial_rec.lot_serial_id;
227: ELSE
228: IF l_debug_level > 0 THEN
229: oe_debug_pub.add( 'QUERYING FOR LINE_ID' , 1 ) ;
230: END IF;
231: SELECT NVL(ORDERED_QUANTITY,0)
232: INTO l_ordered_qty
233: FROM OE_ORDER_LINES

Line 257: oe_debug_pub.add( 'QUANTITY IS '||TO_CHAR ( P_LOT_SERIAL_REC.QUANTITY ) , 1 ) ;

253: --
254: -- Validate attribute dependencies here.
255: --
256: IF l_debug_level > 0 THEN
257: oe_debug_pub.add( 'QUANTITY IS '||TO_CHAR ( P_LOT_SERIAL_REC.QUANTITY ) , 1 ) ;
258: END IF;
259: IF l_debug_level > 0 THEN
260: oe_debug_pub.add( 'FROM IS '||P_LOT_SERIAL_REC.FROM_SERIAL_NUMBER , 1 ) ;
261: END IF;

Line 260: oe_debug_pub.add( 'FROM IS '||P_LOT_SERIAL_REC.FROM_SERIAL_NUMBER , 1 ) ;

256: IF l_debug_level > 0 THEN
257: oe_debug_pub.add( 'QUANTITY IS '||TO_CHAR ( P_LOT_SERIAL_REC.QUANTITY ) , 1 ) ;
258: END IF;
259: IF l_debug_level > 0 THEN
260: oe_debug_pub.add( 'FROM IS '||P_LOT_SERIAL_REC.FROM_SERIAL_NUMBER , 1 ) ;
261: END IF;
262: IF l_debug_level > 0 THEN
263: oe_debug_pub.add( 'TO IS '||P_LOT_SERIAL_REC.TO_SERIAL_NUMBER , 1 ) ;
264: END IF;

Line 263: oe_debug_pub.add( 'TO IS '||P_LOT_SERIAL_REC.TO_SERIAL_NUMBER , 1 ) ;

259: IF l_debug_level > 0 THEN
260: oe_debug_pub.add( 'FROM IS '||P_LOT_SERIAL_REC.FROM_SERIAL_NUMBER , 1 ) ;
261: END IF;
262: IF l_debug_level > 0 THEN
263: oe_debug_pub.add( 'TO IS '||P_LOT_SERIAL_REC.TO_SERIAL_NUMBER , 1 ) ;
264: END IF;
265: IF p_Lot_Serial_rec.quantity IS NOT NULL AND
266: p_Lot_Serial_rec.from_serial_number IS NOT NULL AND
267: (NOT OE_GLOBALS.Equal(p_Lot_Serial_rec.quantity,

Line 287: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY 2' , 1 ) ;

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
290: IF p_Lot_Serial_rec.quantity <> x_quantity THEN
291: l_return_status := FND_API.G_RET_STS_ERROR;

Line 295: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY 3' , 1 ) ;

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

Line 308: oe_debug_pub.add( 'RMA lot serial QUERYING FOR LINE_ID' , 1 ) ; -- INVCONV

304: and OE_GLOBALS.G_UI_FLAG = FALSE
305: Then
306:
307: IF l_debug_level > 0 THEN
308: oe_debug_pub.add( 'RMA lot serial QUERYING FOR LINE_ID' , 1 ) ; -- INVCONV
309: END IF;
310:
311: begin
312: OPEN c_lines( p_Lot_Serial_rec.line_id );

Line 363: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_uom_code = ' || l_secondary_uom_code, 1 ) ;

359:
360: Close c_item;
361:
362: IF l_debug_level > 0 THEN
363: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_uom_code = ' || l_secondary_uom_code, 1 ) ;
364: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_tracking_quantity_ind = ' || l_tracking_quantity_ind , 1 ) ;
365: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_RMA_LOT_RESTRICT = ' || l_RMA_LOT_RESTRICT, 1 ) ;
366: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_serial_number_control_code = ' || l_serial_number_control_code, 1 ) ;
367: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_default_ind = ' || l_secondary_default_ind, 1 ) ;

Line 364: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_tracking_quantity_ind = ' || l_tracking_quantity_ind , 1 ) ;

360: Close c_item;
361:
362: IF l_debug_level > 0 THEN
363: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_uom_code = ' || l_secondary_uom_code, 1 ) ;
364: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_tracking_quantity_ind = ' || l_tracking_quantity_ind , 1 ) ;
365: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_RMA_LOT_RESTRICT = ' || l_RMA_LOT_RESTRICT, 1 ) ;
366: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_serial_number_control_code = ' || l_serial_number_control_code, 1 ) ;
367: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_default_ind = ' || l_secondary_default_ind, 1 ) ;
368: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_lot_ctl = ' || l_lot_ctl, 1 ) ;

Line 365: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_RMA_LOT_RESTRICT = ' || l_RMA_LOT_RESTRICT, 1 ) ;

361:
362: IF l_debug_level > 0 THEN
363: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_uom_code = ' || l_secondary_uom_code, 1 ) ;
364: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_tracking_quantity_ind = ' || l_tracking_quantity_ind , 1 ) ;
365: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_RMA_LOT_RESTRICT = ' || l_RMA_LOT_RESTRICT, 1 ) ;
366: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_serial_number_control_code = ' || l_serial_number_control_code, 1 ) ;
367: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_default_ind = ' || l_secondary_default_ind, 1 ) ;
368: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_lot_ctl = ' || l_lot_ctl, 1 ) ;
369: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_ship_from_org_id = ' || l_ship_from_org_id, 1 ) ;

Line 366: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_serial_number_control_code = ' || l_serial_number_control_code, 1 ) ;

362: IF l_debug_level > 0 THEN
363: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_uom_code = ' || l_secondary_uom_code, 1 ) ;
364: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_tracking_quantity_ind = ' || l_tracking_quantity_ind , 1 ) ;
365: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_RMA_LOT_RESTRICT = ' || l_RMA_LOT_RESTRICT, 1 ) ;
366: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_serial_number_control_code = ' || l_serial_number_control_code, 1 ) ;
367: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_default_ind = ' || l_secondary_default_ind, 1 ) ;
368: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_lot_ctl = ' || l_lot_ctl, 1 ) ;
369: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_ship_from_org_id = ' || l_ship_from_org_id, 1 ) ;
370: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_inventory_item_id = ' || l_inventory_item_id, 1 ) ;

Line 367: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_default_ind = ' || l_secondary_default_ind, 1 ) ;

363: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_uom_code = ' || l_secondary_uom_code, 1 ) ;
364: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_tracking_quantity_ind = ' || l_tracking_quantity_ind , 1 ) ;
365: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_RMA_LOT_RESTRICT = ' || l_RMA_LOT_RESTRICT, 1 ) ;
366: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_serial_number_control_code = ' || l_serial_number_control_code, 1 ) ;
367: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_default_ind = ' || l_secondary_default_ind, 1 ) ;
368: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_lot_ctl = ' || l_lot_ctl, 1 ) ;
369: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_ship_from_org_id = ' || l_ship_from_org_id, 1 ) ;
370: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_inventory_item_id = ' || l_inventory_item_id, 1 ) ;
371: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - p_Lot_Serial_rec.lot_number, = ' || p_Lot_Serial_rec.lot_number, 1 ) ;

Line 368: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_lot_ctl = ' || l_lot_ctl, 1 ) ;

364: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_tracking_quantity_ind = ' || l_tracking_quantity_ind , 1 ) ;
365: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_RMA_LOT_RESTRICT = ' || l_RMA_LOT_RESTRICT, 1 ) ;
366: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_serial_number_control_code = ' || l_serial_number_control_code, 1 ) ;
367: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_default_ind = ' || l_secondary_default_ind, 1 ) ;
368: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_lot_ctl = ' || l_lot_ctl, 1 ) ;
369: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_ship_from_org_id = ' || l_ship_from_org_id, 1 ) ;
370: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_inventory_item_id = ' || l_inventory_item_id, 1 ) ;
371: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - p_Lot_Serial_rec.lot_number, = ' || p_Lot_Serial_rec.lot_number, 1 ) ;
372: END IF;

Line 369: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_ship_from_org_id = ' || l_ship_from_org_id, 1 ) ;

365: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_RMA_LOT_RESTRICT = ' || l_RMA_LOT_RESTRICT, 1 ) ;
366: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_serial_number_control_code = ' || l_serial_number_control_code, 1 ) ;
367: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_default_ind = ' || l_secondary_default_ind, 1 ) ;
368: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_lot_ctl = ' || l_lot_ctl, 1 ) ;
369: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_ship_from_org_id = ' || l_ship_from_org_id, 1 ) ;
370: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_inventory_item_id = ' || l_inventory_item_id, 1 ) ;
371: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - p_Lot_Serial_rec.lot_number, = ' || p_Lot_Serial_rec.lot_number, 1 ) ;
372: END IF;
373:

Line 370: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_inventory_item_id = ' || l_inventory_item_id, 1 ) ;

366: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_serial_number_control_code = ' || l_serial_number_control_code, 1 ) ;
367: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_default_ind = ' || l_secondary_default_ind, 1 ) ;
368: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_lot_ctl = ' || l_lot_ctl, 1 ) ;
369: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_ship_from_org_id = ' || l_ship_from_org_id, 1 ) ;
370: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_inventory_item_id = ' || l_inventory_item_id, 1 ) ;
371: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - p_Lot_Serial_rec.lot_number, = ' || p_Lot_Serial_rec.lot_number, 1 ) ;
372: END IF;
373:
374:

Line 371: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - p_Lot_Serial_rec.lot_number, = ' || p_Lot_Serial_rec.lot_number, 1 ) ;

367: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_default_ind = ' || l_secondary_default_ind, 1 ) ;
368: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_lot_ctl = ' || l_lot_ctl, 1 ) ;
369: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_ship_from_org_id = ' || l_ship_from_org_id, 1 ) ;
370: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_inventory_item_id = ' || l_inventory_item_id, 1 ) ;
371: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - p_Lot_Serial_rec.lot_number, = ' || p_Lot_Serial_rec.lot_number, 1 ) ;
372: END IF;
373:
374:
375: /*IF oe_line_util.Process_Characteristics INVCONV

Line 380: oe_debug_pub.add( 'OPM RMA - OPM item' , 1 ) ;

376: (l_inventory_item_id,l_ship_from_org_id,l_item_rec)
377: Then
378:
379: IF l_debug_level > 0 THEN
380: oe_debug_pub.add( 'OPM RMA - OPM item' , 1 ) ;
381: END IF;
382:
383: begin
384: OPEN c_opm_item( l_ship_from_org_id,

Line 415: oe_debug_pub.add( 'INVALID LINE LOT SERIALS LOT NUMBER...' ) ;

411: IF l_lot_ctl <> 2 and -- INVCONV
412: ( p_Lot_Serial_rec.lot_number <> FND_API.G_MISS_CHAR
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;

Line 426: oe_debug_pub.add( 'OPM INVALID LINE LOT SERIALS SUBLOT NUMBER...' ) ;

422: /* IF l_sublot_ctl <> 1 and INVCONV
423: ( p_Lot_Serial_rec.sublot_number <> FND_API.G_MISS_CHAR
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;

Line 441: oe_debug_pub.add( 'OPM INVALID LINE LOT SERIALS NO LOT NUMBER...' ) ;

437: ( p_Lot_Serial_rec.lot_number = FND_API.G_MISS_CHAR
438: or p_Lot_Serial_rec.lot_number IS NULL ) then
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;

Line 466: oe_debug_pub.add( 'NO_DATA_FOUND WHEN checking RMA attribute lot number' ) ;

462: FETCH c_lot1 into l_lot_number; -- l_sublot_number INVCONV ;
463:
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;

Line 486: oe_debug_pub.add( 'NO_DATA_FOUND WHEN checking RMA attribute lot number' ) ;

482: FETCH c_opm_lot1 into l_lot_id;
483:
484: IF c_opm_lot1%NOTFOUND THEN
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;

Line 517: oe_debug_pub.add( 'OPM NO_DATA_FOUND WHEN checking OPM RMA attribute sublot number' ) ;

513: FETCH c_opm_lot2 into l_lot_id;
514:
515: IF c_opm_lot2%NOTFOUND THEN
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;

Line 534: oe_debug_pub.add( 'OE_VALIDATE_LOT_SERIAL.ENTITY - validating QUANTITY2...' ) ;

530:
531: -- validate quantity2
532: -- added from pre process
533: IF l_debug_level > 0 THEN
534: oe_debug_pub.add( 'OE_VALIDATE_LOT_SERIAL.ENTITY - validating QUANTITY2...' ) ;
535: END IF;
536: IF l_tracking_quantity_ind = 'P' and -- INVCONV l_dualum_ind < 1 and
537: ( p_lot_serial_rec.quantity2 <> FND_API.G_MISS_NUM
538: and p_lot_serial_rec.quantity2 IS NOT NULL ) then

Line 540: oe_debug_pub.add( 'INVALID LINE LOT SERIALS QUANTITY2...' ) ; -- INVCONV

536: IF l_tracking_quantity_ind = 'P' and -- INVCONV l_dualum_ind < 1 and
537: ( p_lot_serial_rec.quantity2 <> FND_API.G_MISS_NUM
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

Line 551: oe_debug_pub.add( 'OE_VALIDATE_LOT_SERIAL.ENTITY - validating QUANTITY2 negative ...' ) ;

547: l_return_status := FND_API.G_RET_STS_ERROR;
548: END IF;
549:
550: IF l_debug_level > 0 THEN
551: oe_debug_pub.add( 'OE_VALIDATE_LOT_SERIAL.ENTITY - validating QUANTITY2 negative ...' ) ;
552: END IF;
553: /* If quantity2 is present and negative, then error */
554:
555: IF nvl(p_lot_serial_rec.quantity2, 0) < 0 then

Line 561: oe_debug_pub.add ('INVALID LINE LOT SERIALS QUANTITY2 - negative....');

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;
563: END IF;
564: -- added from pre process end
565:

Line 574: oe_debug_pub.add( 'OE_Validate_Lot_Serial.entity - validating No default dual QUANTITYs...' ) ;

570: IF l_secondary_default_ind = 'N' then
571: --IF l_dualum_ind = 3 then
572:
573: IF l_debug_level > 0 THEN
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');

Line 582: oe_debug_pub.add ('INVALID LINE LOT SERIALS - one qty is blank for type No Default..');

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;
584: END IF;
585: END IF; -- IF l_secondary_default_ind = 'N' then
586:

Line 603: oe_debug_pub.add( 'OE_Validate_Lot_Serial.entity - tolerance check for type Default and No Default ..' ) ;

599: l_lot_number := p_Lot_Serial_rec.LOT_NUMBER; -- 4260166 INVCONV
600:
601:
602: IF l_debug_level > 0 THEN
603: oe_debug_pub.add( 'OE_Validate_Lot_Serial.entity - tolerance check for type Default and No Default ..' ) ;
604: END IF;
605:
606: /* IF l_lot_ctl = 2 -- INVCONV PAL bug fix for lot number -- 4260166
607: and ( p_Lot_Serial_rec.lot_number <> FND_API.G_MISS_CHAR

Line 622: oe_debug_pub.add( 'NO_DATA_FOUND for type Default and No default checking lot number' ) ;

618:
619: IF c_lot1%NOTFOUND THEN
620:
621: IF l_debug_level > 0 THEN
622: oe_debug_pub.add( 'NO_DATA_FOUND for type Default and No default checking lot number' ) ;
623: END IF;
624: END IF;
625: Close c_lot1;
626: end;

Line 646: oe_debug_pub.add( 'OPM NO_DATA_FOUND for type 2,3 tolerance check checking sublot number' ) ;

642: FETCH c_opm_lot2 into l_lot_id;
643:
644: IF c_opm_lot2%NOTFOUND THEN
645: IF l_debug_level > 0 THEN
646: oe_debug_pub.add( 'OPM NO_DATA_FOUND for type 2,3 tolerance check checking sublot number' ) ;
647: END IF;
648: l_lot_id := 0;
649: END IF;
650:

Line 680: oe_debug_pub.add('OE_Validate_Lot_Serial.entity - tolerance error 1' ,1);

676:
677: IF l_return = 0
678: then
679: IF l_debug_level > 0 THEN
680: oe_debug_pub.add('OE_Validate_Lot_Serial.entity - tolerance error 1' ,1);
681: END IF;
682:
683: l_buffer := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
684: p_encoded => 'F');

Line 687: oe_debug_pub.add(l_buffer,1);

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 ;
690:
691: else

Line 693: oe_debug_pub.add('OE_Validate_Lot_Serial.entity - No tolerance error so return ',1);

689: RAISE TOLERANCE_ERROR ;
690:
691: else
692: IF l_debug_level > 0 THEN
693: oe_debug_pub.add('OE_Validate_Lot_Serial.entity - No tolerance error so return ',1);
694: END IF;
695: x_return_status := 0;
696: -- RETURN; INVCONV bug 4099604
697: END IF; -- IF l_return = 0

Line 727: oe_debug_pub.add( 'OE_Validate_Lot_Serial.entity - after tolerance check for type Default and No default. l_return = ' || l_return ) ;

723:
724: END IF; */
725:
726: IF l_debug_level > 0 THEN
727: oe_debug_pub.add( 'OE_Validate_Lot_Serial.entity - after tolerance check for type Default and No default. l_return = ' || l_return ) ;
728: END IF;
729:
730:
731: END IF; -- IF l_secondary_default_ind in ('N','D') invconv IF l_dualum_ind in (2,3) then

Line 742: oe_debug_pub.add( 'EXITING OE_VALIDATE_LOT_SERIAL.ENTITY return status = ' || x_return_status , 1 ) ;

738: -- Done validating entity
739:
740: x_return_status := l_return_status;
741: IF l_debug_level > 0 THEN
742: oe_debug_pub.add( 'EXITING OE_VALIDATE_LOT_SERIAL.ENTITY return status = ' || x_return_status , 1 ) ;
743: END IF;
744:
745: EXCEPTION
746:

Line 756: oe_debug_pub.add('Exception handling: TOLERANCE_ERROR in OE_VALIDATE_LOT_SERIAL.ENTITY', 1);

752:
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
754:
755: WHEN TOLERANCE_ERROR THEN -- INVCONV
756: oe_debug_pub.add('Exception handling: TOLERANCE_ERROR in OE_VALIDATE_LOT_SERIAL.ENTITY', 1);
757: x_return_status := -1;
758:
759: WHEN OTHERS THEN
760:

Line 771: oe_debug_pub.add( 'EXITING OE_VALIDATE_LOT_SERIAL.ENTITY return status = ' || x_return_status , 1 ) ;

767: , 'Entity'
768: );
769: END IF;
770: IF l_debug_level > 0 THEN
771: oe_debug_pub.add( 'EXITING OE_VALIDATE_LOT_SERIAL.ENTITY return status = ' || x_return_status , 1 ) ;
772: END IF;
773: END Entity;
774:
775: -- Procedure Attributes

Line 786: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

782: OE_Order_PUB.G_MISS_LOT_SERIAL_REC
783: )
784: IS
785: --
786: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
787: --
788: BEGIN
789:
790: IF l_debug_level > 0 THEN

Line 791: oe_debug_pub.add( 'ENTERING OE_VALIDATE_LOT_SERIAL.ATTRIBUTES' , 1 ) ;

787: --
788: BEGIN
789:
790: IF l_debug_level > 0 THEN
791: oe_debug_pub.add( 'ENTERING OE_VALIDATE_LOT_SERIAL.ATTRIBUTES' , 1 ) ;
792: END IF;
793: x_return_status := FND_API.G_RET_STS_SUCCESS;
794:
795: -- Validate Lot_Serial attributes

Line 1093: oe_debug_pub.add( 'EXITING OE_VALIDATE_LOT_SERIAL.ATTRIBUTES' , 1 ) ;

1089: END IF;
1090:
1091: -- Done validating attributes
1092: IF l_debug_level > 0 THEN
1093: oe_debug_pub.add( 'EXITING OE_VALIDATE_LOT_SERIAL.ATTRIBUTES' , 1 ) ;
1094: END IF;
1095:
1096: EXCEPTION
1097:

Line 1130: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1126: )
1127: IS
1128: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1129: --
1130: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1131: --
1132: BEGIN
1133:
1134: -- Validate entity delete.

Line 1173: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1169: , p_x_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type
1170: ) IS
1171: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1172: --
1173: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1174: --
1175: BEGIN
1176: NULL;
1177: EXCEPTION