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

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

28: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;
29: l_price_flag VARCHAR2(1);
30:
31: --
32: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
33: --
34: BEGIN
35:
36: IF l_debug_level > 0 THEN

Line 37: oe_debug_pub.add( 'ENTERING OE_LINE_REPRICE.REPRICE_LINE '|| TO_CHAR ( P_LINE_REC.LINE_ID ) , 1 ) ;

33: --
34: BEGIN
35:
36: IF l_debug_level > 0 THEN
37: oe_debug_pub.add( 'ENTERING OE_LINE_REPRICE.REPRICE_LINE '|| TO_CHAR ( P_LINE_REC.LINE_ID ) , 1 ) ;
38: END IF;
39:
40: x_return_status := FND_API.G_RET_STS_SUCCESS;
41: -- check if repricing event is LINE level event

Line 44: oe_debug_pub.add( 'EVENT LEVEL CODE IS: '||L_EVENT_REC.MODIFIER_LEVEL_CODE , 1 ) ;

40: x_return_status := FND_API.G_RET_STS_SUCCESS;
41: -- check if repricing event is LINE level event
42: FOR l_event_rec IN check_event_cur(p_repricing_event) LOOP
43: IF l_debug_level > 0 THEN
44: oe_debug_pub.add( 'EVENT LEVEL CODE IS: '||L_EVENT_REC.MODIFIER_LEVEL_CODE , 1 ) ;
45: END IF;
46: IF NVL(l_event_rec.modifier_level_code, 'ORDER') <> 'LINE' THEN
47: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
48: FND_MESSAGE.SET_NAME('ONT','ONT_REPRICE_INVALID_EVENT');

Line 74: oe_debug_pub.add( 'REPRICING DATE IS: '||P_REPRICING_DATE , 1 ) ;

70: NULL;
71: End If;
72:
73: IF l_debug_level > 0 THEN
74: oe_debug_pub.add( 'REPRICING DATE IS: '||P_REPRICING_DATE , 1 ) ;
75: END IF;
76:
77: IF l_line_rec.Pricing_Date IS NULL THEN
78: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 95: oe_debug_pub.add( 'REPRICING EVENT '||P_REPRICING_EVENT , 2 ) ;

91:
92: l_x_line_tbl(1) := l_line_rec;
93:
94: IF l_debug_level > 0 THEN
95: oe_debug_pub.add( 'REPRICING EVENT '||P_REPRICING_EVENT , 2 ) ;
96: oe_debug_pub.add( 'REPRICING DATE '||L_X_LINE_TBL ( 1 ) .PRICING_DATE , 2 ) ;
97: END IF;
98:
99: oe_order_adj_pvt.Price_line(

Line 96: oe_debug_pub.add( 'REPRICING DATE '||L_X_LINE_TBL ( 1 ) .PRICING_DATE , 2 ) ;

92: l_x_line_tbl(1) := l_line_rec;
93:
94: IF l_debug_level > 0 THEN
95: oe_debug_pub.add( 'REPRICING EVENT '||P_REPRICING_EVENT , 2 ) ;
96: oe_debug_pub.add( 'REPRICING DATE '||L_X_LINE_TBL ( 1 ) .PRICING_DATE , 2 ) ;
97: END IF;
98:
99: oe_order_adj_pvt.Price_line(
100: X_Return_Status => l_Return_Status

Line 153: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;

149: ,p_source_document_id => l_line_rec.source_document_id
150: ,p_source_document_line_id => l_line_rec.source_document_line_id );
151:
152: IF l_debug_level > 0 THEN
153: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
154: oe_debug_pub.add('In others of Reprice line');
155: END IF;
156:
157: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 154: oe_debug_pub.add('In others of Reprice line');

150: ,p_source_document_line_id => l_line_rec.source_document_line_id );
151:
152: IF l_debug_level > 0 THEN
153: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
154: oe_debug_pub.add('In others of Reprice line');
155: END IF;
156:
157: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
158: THEN

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

183: l_errname VARCHAR2(30);
184: l_errmsg VARCHAR2(2000);
185: l_errstack VARCHAR2(2000);
186: --
187: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
188: --
189: l_header_id NUMBER;
190: l_orig_sys_line_ref VARCHAR2(50);
191: l_orig_sys_shipment_ref VARCHAR2(50);

Line 229: oe_debug_pub.add( 'WORK FLOW ERROR HAS OCCURED ' , 1 ) ;

225: ,p_source_document_id => l_source_document_id
226: ,p_source_document_line_id => l_source_document_line_id );
227:
228: IF l_debug_level > 0 THEN
229: oe_debug_pub.add( 'WORK FLOW ERROR HAS OCCURED ' , 1 ) ;
230: END IF;
231: WF_CORE.Get_Error(l_errname, l_errmsg, l_errstack);
232: IF l_errname = 'WFENG_ACTIVITY_ATTR' THEN
233: IF l_debug_level > 0 THEN

Line 234: oe_debug_pub.add( 'ERROR MESSAGE '||L_ERRMSG , 1 ) ;

230: END IF;
231: WF_CORE.Get_Error(l_errname, l_errmsg, l_errstack);
232: IF l_errname = 'WFENG_ACTIVITY_ATTR' THEN
233: IF l_debug_level > 0 THEN
234: oe_debug_pub.add( 'ERROR MESSAGE '||L_ERRMSG , 1 ) ;
235: END IF;
236: x_attribute_value := 'NONE';
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238: ELSE

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

276: l_Honor_Price_Flag_attr VARCHAR2(30):='HONOR_PRICE_FLAG';
277: l_Honor_Price_Flag VARCHAR2(30);
278: l_item_type VARCHAR2(8) := OE_GLOBALS.G_WFI_LIN;
279: --
280: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
281: --
282: BEGIN
283:
284: IF l_debug_level > 0 THEN

Line 285: oe_debug_pub.add( 'ENTERING OE_LINE_REPRICE.PROCESS_REPRICING '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;

281: --
282: BEGIN
283:
284: IF l_debug_level > 0 THEN
285: oe_debug_pub.add( 'ENTERING OE_LINE_REPRICE.PROCESS_REPRICING '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;
286: END IF;
287:
288: x_result_out := 'COMPLETE';
289:

Line 323: oe_debug_pub.add( 'ACTIVTITY ID : '||TO_CHAR ( P_ACTIVITY_ID ) , 3 ) ;

319: END IF;
320: Commented for bug 7592279 end*/
321:
322: IF l_debug_level > 0 THEN
323: oe_debug_pub.add( 'ACTIVTITY ID : '||TO_CHAR ( P_ACTIVITY_ID ) , 3 ) ;
324: END IF;
325: l_item_key := to_char(p_line_id);
326:
327: IF l_debug_level > 0 THEN

Line 328: oe_debug_pub.add( 'CALLING GET REPRICING ACTIVITY ' , 3 ) ;

324: END IF;
325: l_item_key := to_char(p_line_id);
326:
327: IF l_debug_level > 0 THEN
328: oe_debug_pub.add( 'CALLING GET REPRICING ACTIVITY ' , 3 ) ;
329: END IF;
330:
331: Get_Activity_Attribute
332: (

Line 348: oe_debug_pub.add( 'REPRICING DATE : '|| L_REPRICING_DATE , 3 ) ;

344: RAISE FND_API.G_EXC_ERROR;
345: END IF;
346:
347: IF l_debug_level > 0 THEN
348: oe_debug_pub.add( 'REPRICING DATE : '|| L_REPRICING_DATE , 3 ) ;
349: oe_debug_pub.add( 'CALLING GET ATTRIBUTE - REPRICING EVENT ' , 3 ) ;
350: END IF;
351:
352: Get_Activity_Attribute

Line 349: oe_debug_pub.add( 'CALLING GET ATTRIBUTE - REPRICING EVENT ' , 3 ) ;

345: END IF;
346:
347: IF l_debug_level > 0 THEN
348: oe_debug_pub.add( 'REPRICING DATE : '|| L_REPRICING_DATE , 3 ) ;
349: oe_debug_pub.add( 'CALLING GET ATTRIBUTE - REPRICING EVENT ' , 3 ) ;
350: END IF;
351:
352: Get_Activity_Attribute
353: (

Line 373: oe_debug_pub.add( 'REPRICING EVENT : '|| L_REPRICING_EVENT , 3 ) ;

369: l_Repricing_Event := 'REPRICE_LINE';
370: End If;
371:
372: IF l_debug_level > 0 THEN
373: oe_debug_pub.add( 'REPRICING EVENT : '|| L_REPRICING_EVENT , 3 ) ;
374: END IF;
375:
376: Get_Activity_Attribute
377: (

Line 397: oe_debug_pub.add( 'HONOR PRICE FLAG : '|| L_HONOR_PRICE_FLAG , 3 ) ;

393: l_Honor_Price_Flag := 'Y';
394: End If;
395:
396: IF l_debug_level > 0 THEN
397: oe_debug_pub.add( 'HONOR PRICE FLAG : '|| L_HONOR_PRICE_FLAG , 3 ) ;
398: END IF;
399:
400: Reprice_Line
401: (

Line 410: oe_debug_pub.add( 'RETURN STATUS FROM REPRICE LINE : '||L_RETURN_STATUS , 3 ) ;

406: x_return_status => l_return_status
407: );
408:
409: IF l_debug_level > 0 THEN
410: oe_debug_pub.add( 'RETURN STATUS FROM REPRICE LINE : '||L_RETURN_STATUS , 3 ) ;
411: END IF;
412:
413: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 421: oe_debug_pub.add( 'EXITING FROM OE_LINE_REPRICE.PROCESS_REPRICING : '||X_RETURN_STATUS , 1 ) ;

417: END IF;
418:
419:
420: IF l_debug_level > 0 THEN
421: oe_debug_pub.add( 'EXITING FROM OE_LINE_REPRICE.PROCESS_REPRICING : '||X_RETURN_STATUS , 1 ) ;
422: END IF;
423:
424: EXCEPTION
425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 427: oe_debug_pub.add( 'PROCESS_REPRICING : EXITING WITH UNEXPECTED ERROR'||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;

423:
424: EXCEPTION
425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
426: IF l_debug_level > 0 THEN
427: oe_debug_pub.add( 'PROCESS_REPRICING : EXITING WITH UNEXPECTED ERROR'||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
428: END IF;
429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
430: x_result_out := 'INCOMPLETE';
431: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 444: oe_debug_pub.add('In others of Process_Reprice ');

440: x_return_status := FND_API.G_RET_STS_ERROR;
441: x_result_out := 'INCOMPLETE';
442: WHEN OTHERS THEN
443: IF l_debug_level > 0 THEN
444: oe_debug_pub.add('In others of Process_Reprice ');
445: oe_debug_pub.add( 'PROCESS_REPRICING : EXITING WITH OTHERS ERROR' , 1 ) ;
446: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
447: END IF;
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 445: oe_debug_pub.add( 'PROCESS_REPRICING : EXITING WITH OTHERS ERROR' , 1 ) ;

441: x_result_out := 'INCOMPLETE';
442: WHEN OTHERS THEN
443: IF l_debug_level > 0 THEN
444: oe_debug_pub.add('In others of Process_Reprice ');
445: oe_debug_pub.add( 'PROCESS_REPRICING : EXITING WITH OTHERS ERROR' , 1 ) ;
446: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
447: END IF;
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
449: x_result_out := 'INCOMPLETE';

Line 446: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;

442: WHEN OTHERS THEN
443: IF l_debug_level > 0 THEN
444: oe_debug_pub.add('In others of Process_Reprice ');
445: oe_debug_pub.add( 'PROCESS_REPRICING : EXITING WITH OTHERS ERROR' , 1 ) ;
446: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
447: END IF;
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
449: x_result_out := 'INCOMPLETE';
450: oe_line_reprice.set_reprice_status('REPRICE_UNEXPECTED_ERROR', p_line_id);

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

468: Procedure set_reprice_status (p_flow_status IN VARCHAR2,
469: p_line_id IN NUMBER)
470: IS
471:
472: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
473:
474: BEGIN
475:
476: IF l_debug_level > 0 THEN

Line 477: oe_debug_pub.add('Setting Flow Stauts code to '||p_flow_status || 'for line id ' ||p_line_id);

473:
474: BEGIN
475:
476: IF l_debug_level > 0 THEN
477: oe_debug_pub.add('Setting Flow Stauts code to '||p_flow_status || 'for line id ' ||p_line_id);
478: END IF;
479:
480: IF oe_code_control.code_release_level>='110510' THEN
481: Update oe_order_lines_all