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 126: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

122: -- OPM 3494420
123: l_primary_uom_code varchar2(3) := NULL; --Bug 10021098
124:
125: --
126: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
127: --
128: BEGIN
129:
130: IF l_debug_level > 0 THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

370: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_serial_number_control_code = ' || l_serial_number_control_code, 1 ) ;
371: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_secondary_default_ind = ' || l_secondary_default_ind, 1 ) ;
372: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_lot_ctl = ' || l_lot_ctl, 1 ) ;
373: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_ship_from_org_id = ' || l_ship_from_org_id, 1 ) ;
374: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - l_inventory_item_id = ' || l_inventory_item_id, 1 ) ;
375: oe_debug_pub.add( 'IN OE_VALIDATE_LOT_SERIAL.ENTITY - p_Lot_Serial_rec.lot_number, = ' || p_Lot_Serial_rec.lot_number, 1 ) ;
376: END IF;
377:
378:

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

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

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

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

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

415: IF l_lot_ctl <> 2 and -- INVCONV
416: ( p_Lot_Serial_rec.lot_number <> FND_API.G_MISS_CHAR
417: and p_Lot_Serial_rec.lot_number IS NOT NULL ) then
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;

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

426: /* IF l_sublot_ctl <> 1 and INVCONV
427: ( p_Lot_Serial_rec.sublot_number <> FND_API.G_MISS_CHAR
428: and p_Lot_Serial_rec.sublot_number IS NOT NULL ) then
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;

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

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

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

466: FETCH c_lot1 into l_lot_number; -- l_sublot_number INVCONV ;
467:
468: IF c_lot1%NOTFOUND THEN
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;

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

486: FETCH c_opm_lot1 into l_lot_id;
487:
488: IF c_opm_lot1%NOTFOUND THEN
489: IF l_debug_level > 0 THEN
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;

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

517: FETCH c_opm_lot2 into l_lot_id;
518:
519: IF c_opm_lot2%NOTFOUND THEN
520: IF l_debug_level > 0 THEN
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;

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

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

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

542: and p_lot_serial_rec.quantity2 IS NOT NULL
543: and p_lot_serial_rec.quantity2 <> 0) then -- Bug 9408981
544:
545: IF l_debug_level > 0 THEN
546: oe_debug_pub.add( 'INVALID LINE LOT SERIALS QUANTITY2...' ) ; -- INVCONV
547: END IF;
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

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

553: l_return_status := FND_API.G_RET_STS_ERROR;
554: END IF;
555:
556: IF l_debug_level > 0 THEN
557: oe_debug_pub.add( 'OE_VALIDATE_LOT_SERIAL.ENTITY - validating QUANTITY2 negative ...' ) ;
558: END IF;
559: /* If quantity2 is present and negative, then error */
560:
561: IF nvl(p_lot_serial_rec.quantity2, 0) < 0 then

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

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;
569: END IF;
570: -- added from pre process end
571:

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

576: IF l_secondary_default_ind = 'N' then
577: --IF l_dualum_ind = 3 then
578:
579: IF l_debug_level > 0 THEN
580: oe_debug_pub.add( 'OE_Validate_Lot_Serial.entity - validating No default dual QUANTITYs...' ) ;
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');

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

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;
590: END IF;
591: END IF; -- IF l_secondary_default_ind = 'N' then
592:

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

605: l_lot_number := p_Lot_Serial_rec.LOT_NUMBER; -- 4260166 INVCONV
606:
607:
608: IF l_debug_level > 0 THEN
609: oe_debug_pub.add( 'OE_Validate_Lot_Serial.entity - tolerance check for type Default and No Default ..' ) ;
610: END IF;
611:
612: /* IF l_lot_ctl = 2 -- INVCONV PAL bug fix for lot number -- 4260166
613: and ( p_Lot_Serial_rec.lot_number <> FND_API.G_MISS_CHAR

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

624:
625: IF c_lot1%NOTFOUND THEN
626:
627: IF l_debug_level > 0 THEN
628: oe_debug_pub.add( 'NO_DATA_FOUND for type Default and No default checking lot number' ) ;
629: END IF;
630: END IF;
631: Close c_lot1;
632: end;

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

648: FETCH c_opm_lot2 into l_lot_id;
649:
650: IF c_opm_lot2%NOTFOUND THEN
651: IF l_debug_level > 0 THEN
652: oe_debug_pub.add( 'OPM NO_DATA_FOUND for type 2,3 tolerance check checking sublot number' ) ;
653: END IF;
654: l_lot_id := 0;
655: END IF;
656:

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

682:
683: IF l_return = 0
684: then
685: IF l_debug_level > 0 THEN
686: oe_debug_pub.add('OE_Validate_Lot_Serial.entity - tolerance error 1' ,1);
687: END IF;
688:
689: l_buffer := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
690: p_encoded => 'F');

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

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 ;
696:
697: else

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

695: RAISE TOLERANCE_ERROR ;
696:
697: else
698: IF l_debug_level > 0 THEN
699: oe_debug_pub.add('OE_Validate_Lot_Serial.entity - No tolerance error so return ',1);
700: END IF;
701: x_return_status := 0;
702: -- RETURN; INVCONV bug 4099604
703: END IF; -- IF l_return = 0

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

729:
730: END IF; */
731:
732: IF l_debug_level > 0 THEN
733: oe_debug_pub.add( 'OE_Validate_Lot_Serial.entity - after tolerance check for type Default and No default. l_return = ' || l_return ) ;
734: END IF;
735:
736:
737: END IF; -- IF l_secondary_default_ind in ('N','D') invconv IF l_dualum_ind in (2,3) then

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

744: -- Done validating entity
745:
746: x_return_status := l_return_status;
747: IF l_debug_level > 0 THEN
748: oe_debug_pub.add( 'EXITING OE_VALIDATE_LOT_SERIAL.ENTITY return status = ' || x_return_status , 1 ) ;
749: END IF;
750:
751: EXCEPTION
752:

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

758:
759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
760:
761: WHEN TOLERANCE_ERROR THEN -- INVCONV
762: oe_debug_pub.add('Exception handling: TOLERANCE_ERROR in OE_VALIDATE_LOT_SERIAL.ENTITY', 1);
763: x_return_status := -1;
764:
765: WHEN OTHERS THEN
766:

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

773: , 'Entity'
774: );
775: END IF;
776: IF l_debug_level > 0 THEN
777: oe_debug_pub.add( 'EXITING OE_VALIDATE_LOT_SERIAL.ENTITY return status = ' || x_return_status , 1 ) ;
778: END IF;
779: END Entity;
780:
781: -- Procedure Attributes

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

788: OE_Order_PUB.G_MISS_LOT_SERIAL_REC
789: )
790: IS
791: --
792: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
793: --
794: BEGIN
795:
796: IF l_debug_level > 0 THEN

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

793: --
794: BEGIN
795:
796: IF l_debug_level > 0 THEN
797: oe_debug_pub.add( 'ENTERING OE_VALIDATE_LOT_SERIAL.ATTRIBUTES' , 1 ) ;
798: END IF;
799: x_return_status := FND_API.G_RET_STS_SUCCESS;
800:
801: -- Validate Lot_Serial attributes

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

1095: END IF;
1096:
1097: -- Done validating attributes
1098: IF l_debug_level > 0 THEN
1099: oe_debug_pub.add( 'EXITING OE_VALIDATE_LOT_SERIAL.ATTRIBUTES' , 1 ) ;
1100: END IF;
1101:
1102: EXCEPTION
1103:

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

1132: )
1133: IS
1134: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1135: --
1136: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1137: --
1138: BEGIN
1139:
1140: -- Validate entity delete.

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

1175: , p_x_Lot_Serial_rec IN OE_Order_PUB.Lot_Serial_Rec_Type
1176: ) IS
1177: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1178: --
1179: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1180: --
1181: BEGIN
1182: NULL;
1183: EXCEPTION