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_DEFAULT_LOT_SERIAL dependencies on OE_DEBUG_PUB

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

14: FUNCTION Get_From_Serial_Number
15: RETURN VARCHAR2
16: IS
17: --
18: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
19: --
20: BEGIN
21:
22: RETURN NULL;

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

26: FUNCTION Get_Line
27: RETURN NUMBER
28: IS
29: --
30: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
31: --
32: BEGIN
33:
34: RETURN NULL;

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

39: RETURN NUMBER
40: IS
41: l_line_set_id NUMBER;
42: --
43: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
44: --
45: BEGIN
46: SELECT line_set_id
47: INTO l_line_set_id

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

55: FUNCTION Get_Lot_Number
56: RETURN VARCHAR2
57: IS
58: --
59: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
60: --
61: BEGIN
62:
63: RETURN NULL;

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

80: RETURN NUMBER
81: IS
82: l_lot_serial_id NUMBER:= NULL;
83: --
84: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
85: --
86: BEGIN
87:
88: SELECT OE_LOT_SERIAL_S.NEXTVAL INTO l_lot_serial_id FROM DUAL;

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

152: UOM_CONVERSION_FAILED EXCEPTION; -- INVCONV
153:
154:
155: --
156: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
157: --
158: BEGIN
159:
160:

Line 170: oe_debug_pub.add( 'Entering OE_Default_Lot_Serial.Get_Quantity' , 1 ) ;

166: Then
167: return null;
168: ELSE
169: IF l_debug_level > 0 THEN
170: oe_debug_pub.add( 'Entering OE_Default_Lot_Serial.Get_Quantity' , 1 ) ;
171: END IF;
172:
173: begin
174: OPEN c_lines( g_Lot_Serial_rec.line_id );

Line 192: oe_debug_pub.add( 'Dual control RMA - get_quantity defaulting ' , 1 ) ;

188: (l_inventory_item_id,l_ship_from_org_id,l_item_rec)
189: Then
190:
191: IF l_debug_level > 0 THEN
192: oe_debug_pub.add( 'Dual control RMA - get_quantity defaulting ' , 1 ) ;
193: END IF;
194: /* begin
195: OPEN c_opm_item( l_ship_from_org_id,
196: l_inventory_item_id

Line 244: oe_debug_pub.add( 'OPM NO_DATA_FOUND for type 3 tolerance check checking lot number' ) ;

240: FETCH c_opm_lot1 into l_lot_id;
241:
242: IF c_opm_lot1%NOTFOUND THEN
243: IF l_debug_level > 0 THEN
244: oe_debug_pub.add( 'OPM NO_DATA_FOUND for type 3 tolerance check checking lot number' ) ;
245: END IF;
246: l_lot_id := 0;
247: END IF;
248:

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

265: FETCH c_opm_lot2 into l_lot_id;
266:
267: IF c_opm_lot2%NOTFOUND THEN
268: IF l_debug_level > 0 THEN
269: oe_debug_pub.add( 'OPM NO_DATA_FOUND for type 1,2 tolerance check checking sublot number' ) ;
270: END IF;
271: l_lot_id := 0;
272: END IF;
273:

Line 296: oe_debug_pub.add ('LOT SERIALS - returning quantity ....');

292: raise UOM_CONVERSION_FAILED;
293: END IF; -- OPM B1478461 End
294: return l_quantity;
295: IF l_debug_level > 0 THEN
296: oe_debug_pub.add ('LOT SERIALS - returning quantity ....');
297: END IF;
298:
299:
300:

Line 311: oe_debug_pub.add ('LOT SERIALS - returning quantity ....');

307: p_lot_id => nvl(l_lot_id, 0) );
308:
309: return l_quantity;
310: IF l_debug_level > 0 THEN
311: oe_debug_pub.add ('LOT SERIALS - returning quantity ....');
312: END IF; */
313:
314: END IF; -- IF l_dualum_ind in(1,2) then
315:

Line 359: oe_debug_pub.add( 'RMA exiting OE_Default_Lot_Serial.Get_Quantity' , 1 ) ;

355:
356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
357:
358: IF l_debug_level > 0 THEN
359: oe_debug_pub.add( 'RMA exiting OE_Default_Lot_Serial.Get_Quantity' , 1 ) ;
360: END IF;
361:
362:
363: END Get_Quantity;

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

417: l_quantity2 NUMBER;
418: l_item_rec OE_ORDER_CACHE.item_rec_type;
419: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
420: -- OPM 3494420
421: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
422: UOM_CONVERSION_FAILED EXCEPTION; -- INVCONV
423:
424: BEGIN
425:

Line 434: oe_debug_pub.add( 'OPM RMA entering OE_Default_Lot_Serial.Get_Quantity2' , 1 ) ;

430: Then
431: return null;
432: ELSE
433: IF l_debug_level > 0 THEN
434: oe_debug_pub.add( 'OPM RMA entering OE_Default_Lot_Serial.Get_Quantity2' , 1 ) ;
435: END IF;
436: begin
437: OPEN c_lines( g_Lot_Serial_rec.line_id );
438: FETCH c_lines

Line 455: oe_debug_pub.add( 'RMA - get_quantity2 defaulting ' , 1 ) ;

451: (l_inventory_item_id,l_ship_from_org_id,l_item_rec)
452: Then
453:
454: IF l_debug_level > 0 THEN
455: oe_debug_pub.add( 'RMA - get_quantity2 defaulting ' , 1 ) ;
456: END IF;
457:
458: /* begin -- INVCONV
459: OPEN c_opm_item( l_ship_from_org_id,

Line 505: oe_debug_pub.add( 'OPM NO_DATA_FOUND for type 1,2 tolerance check checking lot number' ) ;

501: FETCH c_opm_lot1 into l_lot_id;
502:
503: IF c_opm_lot1%NOTFOUND THEN
504: IF l_debug_level > 0 THEN
505: oe_debug_pub.add( 'OPM NO_DATA_FOUND for type 1,2 tolerance check checking lot number' ) ;
506: END IF;
507: l_lot_id := 0;
508: END IF;
509:

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

526: FETCH c_opm_lot2 into l_lot_id;
527:
528: IF c_opm_lot2%NOTFOUND THEN
529: IF l_debug_level > 0 THEN
530: oe_debug_pub.add( 'OPM NO_DATA_FOUND for type 1,2 tolerance check checking sublot number' ) ;
531: END IF;
532: l_lot_id := 0;
533: END IF;
534:

Line 557: oe_debug_pub.add ('LOT SERIALS - returning quantity2 = ' || l_quantity2 );

553: raise UOM_CONVERSION_FAILED;
554: END IF; -- OPM B1478461 End
555: return l_quantity2;
556: IF l_debug_level > 0 THEN
557: oe_debug_pub.add ('LOT SERIALS - returning quantity2 = ' || l_quantity2 );
558: END IF;
559:
560:
561: /* l_quantity2 := GMI_Reservation_Util.get_opm_converted_qty( -- INVCONV

Line 570: oe_debug_pub.add ('OPM LOT SERIALS - returning quantity2 = ' || l_quantity2 );

566: p_original_qty => l_quantity,
567: p_lot_id => nvl(l_lot_id, 0) );
568:
569: IF l_debug_level > 0 THEN
570: oe_debug_pub.add ('OPM LOT SERIALS - returning quantity2 = ' || l_quantity2 );
571: END IF;
572:
573: return l_quantity2; */
574:

Line 617: oe_debug_pub.add( 'OPM RMA exiting OE_Default_Lot_Serial.Get_Quantity2' , 1 ) ;

613:
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615:
616: IF l_debug_level > 0 THEN
617: oe_debug_pub.add( 'OPM RMA exiting OE_Default_Lot_Serial.Get_Quantity2' , 1 ) ;
618: END IF;
619:
620:
621: END Get_Quantity2;

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

623: FUNCTION Get_To_Serial_Number
624: RETURN VARCHAR2
625: IS
626: --
627: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
628: --
629: BEGIN
630:
631: RETURN NULL;

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

634:
635: PROCEDURE Get_Flex_Lot_Serial
636: IS
637: --
638: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
639: --
640: BEGIN
641:
642: -- In the future call Flex APIs for defaults

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

714: , p_iteration IN NUMBER := 1
715: )
716: IS
717: --
718: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
719: --
720: BEGIN
721:
722: IF l_debug_level > 0 THEN

Line 723: oe_debug_pub.add( 'INSIDE DEFAULTING ATTRIBUTES'||TO_CHAR ( P_X_LOT_SERIAL_REC.QUANTITY ) , 1 ) ;

719: --
720: BEGIN
721:
722: IF l_debug_level > 0 THEN
723: oe_debug_pub.add( 'INSIDE DEFAULTING ATTRIBUTES'||TO_CHAR ( P_X_LOT_SERIAL_REC.QUANTITY ) , 1 ) ;
724: END IF;
725:
726: -- Check number of iterations.
727:

Line 796: oe_debug_pub.add( 'INSIDE OE_DEFAULT_LOT_SERIAL.ATTRIBUTES g_Lot_Serial_rec.line_set_id IS NOT NULL') ;

792: g_Lot_Serial_rec.line_set_id := Get_Line_Set;
793:
794: IF g_Lot_Serial_rec.line_set_id IS NOT NULL THEN
795: IF l_debug_level > 0 THEN
796: oe_debug_pub.add( 'INSIDE OE_DEFAULT_LOT_SERIAL.ATTRIBUTES g_Lot_Serial_rec.line_set_id IS NOT NULL') ;
797: end if;
798:
799: IF OE_Validate.Line_Set(g_Lot_Serial_rec.line_set_id)
800: THEN

Line 891: oe_debug_pub.add( 'OE_DEFAULT_LOT_SERIAL.ATTRIBUTES g_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM' ) ;

887:
888: THEN --OPM 2380194
889:
890: IF l_debug_level > 0 THEN
891: oe_debug_pub.add( 'OE_DEFAULT_LOT_SERIAL.ATTRIBUTES g_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM' ) ;
892: END IF;
893: g_Lot_Serial_rec.quantity2 := Get_Quantity2;
894:
895: IF g_Lot_Serial_rec.quantity2 IS NOT NULL THEN

Line 897: oe_debug_pub.add( 'OE_DEFAULT_LOT_SERIAL.ATTRIBUTES - _Lot_Serial_rec.quantity2 IS NOT NULL' ) ;

893: g_Lot_Serial_rec.quantity2 := Get_Quantity2;
894:
895: IF g_Lot_Serial_rec.quantity2 IS NOT NULL THEN
896: IF l_debug_level > 0 THEN
897: oe_debug_pub.add( 'OE_DEFAULT_LOT_SERIAL.ATTRIBUTES - _Lot_Serial_rec.quantity2 IS NOT NULL' ) ;
898: END IF;
899:
900: IF OE_Validate.Quantity2(g_Lot_Serial_rec.quantity2)
901: THEN

Line 1072: oe_debug_pub.add( 'INSIDE DEFAULTING ATTRIBUTES'||TO_CHAR ( P_X_LOT_SERIAL_REC.QUANTITY ) , 1 ) ;

1068: END IF;
1069:
1070: /* 1581620 end */
1071: /*IF l_debug_level > 0 THEN
1072: oe_debug_pub.add( 'INSIDE DEFAULTING ATTRIBUTES'||TO_CHAR ( P_X_LOT_SERIAL_REC.QUANTITY ) , 1 ) ;
1073: END IF; */
1074: IF l_debug_level > 0 THEN
1075: oe_debug_pub.add( 'EXIT OE_DEFAULT_LOT_SERIAL.ATTRIBUTES' ) ;
1076: END IF;

Line 1075: oe_debug_pub.add( 'EXIT OE_DEFAULT_LOT_SERIAL.ATTRIBUTES' ) ;

1071: /*IF l_debug_level > 0 THEN
1072: oe_debug_pub.add( 'INSIDE DEFAULTING ATTRIBUTES'||TO_CHAR ( P_X_LOT_SERIAL_REC.QUANTITY ) , 1 ) ;
1073: END IF; */
1074: IF l_debug_level > 0 THEN
1075: oe_debug_pub.add( 'EXIT OE_DEFAULT_LOT_SERIAL.ATTRIBUTES' ) ;
1076: END IF;
1077:
1078: END Attributes;
1079: