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

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

13: l_item_type VARCHAR2(80);
14: l_ato_line_id NUMBER;
15: l_explosion_date DATE;
16: --
17: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18: --
19:
20: BEGIN
21: IF itemtype = OE_GLOBALS.G_WFI_LIN THEN

Line 24: OE_DEBUG_PUB.Add('G_FREEZE_II:'||G_FREEZE_II);

20: BEGIN
21: IF itemtype = OE_GLOBALS.G_WFI_LIN THEN
22:
23: IF l_debug_level > 0 THEN
24: OE_DEBUG_PUB.Add('G_FREEZE_II:'||G_FREEZE_II);
25: END IF;
26:
27: IF G_FREEZE_II = 'PICK RELEASE' THEN
28:

Line 35: OE_DEBUG_PUB.Add('Item Type:'||l_item_type);

31: FROM oe_order_lines_all
32: WHERE line_id = to_number(itemkey);
33:
34: IF l_debug_level > 0 THEN
35: OE_DEBUG_PUB.Add('Item Type:'||l_item_type);
36: OE_DEBUG_PUB.Add('Exp Date:'||l_explosion_date);
37: END IF;
38:
39: IF l_item_type in ('MODEL','CLASS','KIT') AND

Line 36: OE_DEBUG_PUB.Add('Exp Date:'||l_explosion_date);

32: WHERE line_id = to_number(itemkey);
33:
34: IF l_debug_level > 0 THEN
35: OE_DEBUG_PUB.Add('Item Type:'||l_item_type);
36: OE_DEBUG_PUB.Add('Exp Date:'||l_explosion_date);
37: END IF;
38:
39: IF l_item_type in ('MODEL','CLASS','KIT') AND
40: l_ato_line_id is NULL AND

Line 45: OE_DEBUG_PUB.Add('Result set to YES!!');

41: l_explosion_date is NULL THEN
42:
43: resultout := 'COMPLETE:Y';
44: IF l_debug_level > 0 THEN
45: OE_DEBUG_PUB.Add('Result set to YES!!');
46: END IF;
47: ELSE
48: resultout := 'COMPLETE:N';
49: IF l_debug_level > 0 THEN

Line 50: OE_DEBUG_PUB.Add('Result set to No!!');

46: END IF;
47: ELSE
48: resultout := 'COMPLETE:N';
49: IF l_debug_level > 0 THEN
50: OE_DEBUG_PUB.Add('Result set to No!!');
51: END IF;
52: END IF;
53:
54: ELSE

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

107: l_result_out VARCHAR2(240);
108: l_msg_count NUMBER;
109: l_msg_data VARCHAR2(2000);
110: --
111: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
112: --
113: l_orig_sys_document_ref VARCHAR2(50);
114: l_orig_sys_line_ref VARCHAR2(50);
115: l_orig_sys_shipment_ref VARCHAR2(50);

Line 132: oe_debug_pub.add( 'ENTERING OE_SHIPPING_WF.START_SHIPPING '||ITEMTYPE||'/'||ITEMKEY , 1 ) ;

128: --
129: -- RUN mode - normal process execution
130: --
131: IF l_debug_level > 0 THEN
132: oe_debug_pub.add( 'ENTERING OE_SHIPPING_WF.START_SHIPPING '||ITEMTYPE||'/'||ITEMKEY , 1 ) ;
133: END IF;
134: oe_msg_pub.set_process_activity(actid);
135: if (funcmode = 'RUN') then
136:

Line 161: oe_debug_pub.add( 'ERROR: INVALID CONTEXT ATTRIBUTES' , 5 ) ;

157: WHERE line_id= to_number(itemkey);
158: EXCEPTION
159: WHEN NO_DATA_FOUND THEN
160: IF l_debug_level > 0 THEN
161: oe_debug_pub.add( 'ERROR: INVALID CONTEXT ATTRIBUTES' , 5 ) ;
162: END IF;
163: resultout := 'NOTIFIED';
164: RETURN;
165: END;

Line 186: oe_debug_pub.add('SHP BULK MODE' , 5 ) ;

182: -- If it is BULK Mode then no need to query these values from Database
183:
184: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NOT NULL THEN
185: IF l_debug_level > 0 THEN
186: oe_debug_pub.add('SHP BULK MODE' , 5 ) ;
187: END IF;
188: -- bug 4070931 starts
189: IF OE_SHIPPING_INTEGRATION_PVT.G_BULK_WSH_INTERFACE_CALLED = TRUE THEN
190: app_exception.raise_exception;

Line 261: oe_debug_pub.add( 'TOP MODEL LINE ID : '||L_TOP_MODEL_LINE_ID , 3 ) ;

257: OE_SHIPPING_INTEGRATION_PVT.G_DEBUG_MSG := NULL;
258: OE_SHIPPING_INTEGRATION_PVT.G_DEBUG_CALL := 1;
259:
260: IF l_debug_level > 0 THEN
261: oe_debug_pub.add( 'TOP MODEL LINE ID : '||L_TOP_MODEL_LINE_ID , 3 ) ;
262: END IF;
263:
264: IF OE_BULK_WF_UTIL.G_LINE_INDEX IS NULL THEN
265:

Line 269: oe_debug_pub.add( 'BEFORE LOCKING THE TOP LINE '||TO_CHAR ( SYSDATE , 'DD-MM-YYYY HH24:MI:SS' ) , 3 ) ;

265:
266: IF nvl(l_top_model_line_id,0) <> 0 THEN
267:
268: IF l_debug_level > 0 THEN
269: oe_debug_pub.add( 'BEFORE LOCKING THE TOP LINE '||TO_CHAR ( SYSDATE , 'DD-MM-YYYY HH24:MI:SS' ) , 3 ) ;
270: END IF;
271: SELECT line_id, top_model_line_id
272: INTO l_line_id, l_top_model_line_id
273: FROM oe_order_lines_all

Line 277: oe_debug_pub.add( 'TOP LINE LOCKED AT '||TO_CHAR ( SYSDATE , 'DD-MM-YYYY HH24:MI:SS' ) , 3 ) ;

273: FROM oe_order_lines_all
274: WHERE line_id = l_top_model_line_id
275: FOR UPDATE NOWAIT;
276: IF l_debug_level > 0 THEN
277: oe_debug_pub.add( 'TOP LINE LOCKED AT '||TO_CHAR ( SYSDATE , 'DD-MM-YYYY HH24:MI:SS' ) , 3 ) ;
278: END IF;
279:
280: ELSE
281: --bug 3814076

Line 295: oe_debug_pub.add( 'CALLING OE_SHIPPING_INTEGRATION_PVT.PROCESS_SHIPPING_ACTIVITY '||TO_CHAR ( L_LINE_ID ) , 2 ) ;

291:
292: l_line_id := to_number(itemkey);
293:
294: IF l_debug_level > 0 THEN
295: oe_debug_pub.add( 'CALLING OE_SHIPPING_INTEGRATION_PVT.PROCESS_SHIPPING_ACTIVITY '||TO_CHAR ( L_LINE_ID ) , 2 ) ;
296: END IF;
297: OE_Shipping_Integration_PVT.Process_Shipping_Activity
298: ( p_api_version_number => 1.0
299: , p_line_id => l_line_id

Line 308: oe_debug_pub.add( 'RETURNED FROM OE_SHIPPING_INTEGRATION_PVT.PROCESS_SHIPPING_ACTIVITY '||L_RETURN_STATUS , 2 ) ;

304: );
305: OE_SHIPPING_INTEGRATION_PVT.G_DEBUG_CALL := 0;
306:
307: IF l_debug_level > 0 THEN
308: oe_debug_pub.add( 'RETURNED FROM OE_SHIPPING_INTEGRATION_PVT.PROCESS_SHIPPING_ACTIVITY '||L_RETURN_STATUS , 2 ) ;
309: END IF;
310:
311:
312: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 454: oe_debug_pub.add('OEXWSHPB.pls: unable to lock the lines',1);

450: exception
451: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
452: -- some one else is currently working on the line
453: IF l_debug_level > 0 THEN
454: oe_debug_pub.add('OEXWSHPB.pls: unable to lock the lines',1);
455: END IF;
456: resultout := 'DEFERRED';
457:
458: when others then