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

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

26:
27: l_organization_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',p_org_id);
28:
29: --
30: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
31: --
32: BEGIN
33: IF l_debug_level > 0 THEN
34: oe_debug_pub.add( 'ENTER GET_ITEM_INFO PROCEDURE' ) ;

Line 34: oe_debug_pub.add( 'ENTER GET_ITEM_INFO PROCEDURE' ) ;

30: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
31: --
32: BEGIN
33: IF l_debug_level > 0 THEN
34: oe_debug_pub.add( 'ENTER GET_ITEM_INFO PROCEDURE' ) ;
35: oe_debug_pub.add( 'ITEM_IDENTIFIER_TYPE : '||P_ITEM_IDENTIFIER_TYPE ) ;
36: oe_debug_pub.add( 'INVENTORY_ITEM_ID : '||P_INVENTORY_ITEM_ID ) ;
37: oe_debug_pub.add( 'ORDERED_ITEM_ID : '||P_ORDERED_ITEM_ID ) ;
38: oe_debug_pub.add( 'ORDERED_ITEM : '||P_ORDERED_ITEM ) ;

Line 35: oe_debug_pub.add( 'ITEM_IDENTIFIER_TYPE : '||P_ITEM_IDENTIFIER_TYPE ) ;

31: --
32: BEGIN
33: IF l_debug_level > 0 THEN
34: oe_debug_pub.add( 'ENTER GET_ITEM_INFO PROCEDURE' ) ;
35: oe_debug_pub.add( 'ITEM_IDENTIFIER_TYPE : '||P_ITEM_IDENTIFIER_TYPE ) ;
36: oe_debug_pub.add( 'INVENTORY_ITEM_ID : '||P_INVENTORY_ITEM_ID ) ;
37: oe_debug_pub.add( 'ORDERED_ITEM_ID : '||P_ORDERED_ITEM_ID ) ;
38: oe_debug_pub.add( 'ORDERED_ITEM : '||P_ORDERED_ITEM ) ;
39: oe_debug_pub.add( 'SOLD_TO_ORG_ID : '||P_SOLD_TO_ORG_ID ) ;

Line 36: oe_debug_pub.add( 'INVENTORY_ITEM_ID : '||P_INVENTORY_ITEM_ID ) ;

32: BEGIN
33: IF l_debug_level > 0 THEN
34: oe_debug_pub.add( 'ENTER GET_ITEM_INFO PROCEDURE' ) ;
35: oe_debug_pub.add( 'ITEM_IDENTIFIER_TYPE : '||P_ITEM_IDENTIFIER_TYPE ) ;
36: oe_debug_pub.add( 'INVENTORY_ITEM_ID : '||P_INVENTORY_ITEM_ID ) ;
37: oe_debug_pub.add( 'ORDERED_ITEM_ID : '||P_ORDERED_ITEM_ID ) ;
38: oe_debug_pub.add( 'ORDERED_ITEM : '||P_ORDERED_ITEM ) ;
39: oe_debug_pub.add( 'SOLD_TO_ORG_ID : '||P_SOLD_TO_ORG_ID ) ;
40: END IF;

Line 37: oe_debug_pub.add( 'ORDERED_ITEM_ID : '||P_ORDERED_ITEM_ID ) ;

33: IF l_debug_level > 0 THEN
34: oe_debug_pub.add( 'ENTER GET_ITEM_INFO PROCEDURE' ) ;
35: oe_debug_pub.add( 'ITEM_IDENTIFIER_TYPE : '||P_ITEM_IDENTIFIER_TYPE ) ;
36: oe_debug_pub.add( 'INVENTORY_ITEM_ID : '||P_INVENTORY_ITEM_ID ) ;
37: oe_debug_pub.add( 'ORDERED_ITEM_ID : '||P_ORDERED_ITEM_ID ) ;
38: oe_debug_pub.add( 'ORDERED_ITEM : '||P_ORDERED_ITEM ) ;
39: oe_debug_pub.add( 'SOLD_TO_ORG_ID : '||P_SOLD_TO_ORG_ID ) ;
40: END IF;
41:

Line 38: oe_debug_pub.add( 'ORDERED_ITEM : '||P_ORDERED_ITEM ) ;

34: oe_debug_pub.add( 'ENTER GET_ITEM_INFO PROCEDURE' ) ;
35: oe_debug_pub.add( 'ITEM_IDENTIFIER_TYPE : '||P_ITEM_IDENTIFIER_TYPE ) ;
36: oe_debug_pub.add( 'INVENTORY_ITEM_ID : '||P_INVENTORY_ITEM_ID ) ;
37: oe_debug_pub.add( 'ORDERED_ITEM_ID : '||P_ORDERED_ITEM_ID ) ;
38: oe_debug_pub.add( 'ORDERED_ITEM : '||P_ORDERED_ITEM ) ;
39: oe_debug_pub.add( 'SOLD_TO_ORG_ID : '||P_SOLD_TO_ORG_ID ) ;
40: END IF;
41:
42: x_return_status := FND_API.G_RET_STS_SUCCESS; --bug 5064901

Line 39: oe_debug_pub.add( 'SOLD_TO_ORG_ID : '||P_SOLD_TO_ORG_ID ) ;

35: oe_debug_pub.add( 'ITEM_IDENTIFIER_TYPE : '||P_ITEM_IDENTIFIER_TYPE ) ;
36: oe_debug_pub.add( 'INVENTORY_ITEM_ID : '||P_INVENTORY_ITEM_ID ) ;
37: oe_debug_pub.add( 'ORDERED_ITEM_ID : '||P_ORDERED_ITEM_ID ) ;
38: oe_debug_pub.add( 'ORDERED_ITEM : '||P_ORDERED_ITEM ) ;
39: oe_debug_pub.add( 'SOLD_TO_ORG_ID : '||P_SOLD_TO_ORG_ID ) ;
40: END IF;
41:
42: x_return_status := FND_API.G_RET_STS_SUCCESS; --bug 5064901
43:

Line 112: oe_debug_pub.add( 'EXIT GET_ITEM_INFO PROCEDURE' ) ;

108:
109: END IF;
110: END IF;
111: IF l_debug_level > 0 THEN
112: oe_debug_pub.add( 'EXIT GET_ITEM_INFO PROCEDURE' ) ;
113: END IF;
114:
115: EXCEPTION
116: WHEN NO_DATA_FOUND THEN

Line 119: oe_debug_pub.add( 'INT type : no_data_found' ) ;

115: EXCEPTION
116: WHEN NO_DATA_FOUND THEN
117: x_return_status := FND_API.G_RET_STS_ERROR; --bug 5064901
118: IF l_debug_level > 0 THEN
119: oe_debug_pub.add( 'INT type : no_data_found' ) ;
120: END IF;
121: When too_many_rows then
122: x_return_status := FND_API.G_RET_STS_ERROR; --bug 5064901
123: IF l_debug_level > 0 THEN

Line 124: oe_debug_pub.add( 'INT type : too_many_rows' ) ;

120: END IF;
121: When too_many_rows then
122: x_return_status := FND_API.G_RET_STS_ERROR; --bug 5064901
123: IF l_debug_level > 0 THEN
124: oe_debug_pub.add( 'INT type : too_many_rows' ) ;
125: END IF;
126:
127: WHEN OTHERS THEN
128:

Line 131: oe_debug_pub.add( 'INT type : others' ) ;

127: WHEN OTHERS THEN
128:
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; --bug 5064901
130: IF l_debug_level > 0 THEN
131: oe_debug_pub.add( 'INT type : others' ) ;
132: END IF;
133:
134: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
135: THEN

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

153: , p_organization_id IN NUMBER DEFAULT NULL -- 12794393
154: ) RETURN NUMBER
155: AS
156: l_new_qty NUMBER ;
157: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
158: BEGIN
159: IF p_from_qty IS NOT NULL THEN
160:
161: IF p_lot_number IS NOT NULL THEN

Line 185: oe_debug_pub.add('Convert from quantity is null value, not calling uom conversion api, return null for to_qty');

181: END IF;
182:
183: ELSE
184: IF l_debug_level > 0 THEN
185: oe_debug_pub.add('Convert from quantity is null value, not calling uom conversion api, return null for to_qty');
186: END IF;
187: l_new_qty:=null;
188: END IF;
189: