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 121: oe_debug_pub.add( 'Recalculating Service First Bill Amount' , 2 ) ;

117: END IF;
118: -- sol_ord_er #16014165
119: IF NVL(l_x_line_tbl(1).service_bill_option_code,'FBOM') = 'FPOM' THEN
120: IF l_debug_level > 0 THEN
121: oe_debug_pub.add( 'Recalculating Service First Bill Amount' , 2 ) ;
122: oe_debug_pub.add( 'First Bill Amount Value Before Reprice = '
123: ||l_x_line_tbl(1).service_first_period_amount , 2 ) ;
124: END IF;
125: oe_delayed_requests_util.First_period_bill_amt (

Line 122: oe_debug_pub.add( 'First Bill Amount Value Before Reprice = '

118: -- sol_ord_er #16014165
119: IF NVL(l_x_line_tbl(1).service_bill_option_code,'FBOM') = 'FPOM' THEN
120: IF l_debug_level > 0 THEN
121: oe_debug_pub.add( 'Recalculating Service First Bill Amount' , 2 ) ;
122: oe_debug_pub.add( 'First Bill Amount Value Before Reprice = '
123: ||l_x_line_tbl(1).service_first_period_amount , 2 ) ;
124: END IF;
125: oe_delayed_requests_util.First_period_bill_amt (
126: p_header_id => '',

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

167: ,p_source_document_id => l_line_rec.source_document_id
168: ,p_source_document_line_id => l_line_rec.source_document_line_id );
169:
170: IF l_debug_level > 0 THEN
171: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
172: oe_debug_pub.add('In others of Reprice line');
173: END IF;
174:
175: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

168: ,p_source_document_line_id => l_line_rec.source_document_line_id );
169:
170: IF l_debug_level > 0 THEN
171: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
172: oe_debug_pub.add('In others of Reprice line');
173: END IF;
174:
175: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
176: THEN

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

201: l_errname VARCHAR2(30);
202: l_errmsg VARCHAR2(2000);
203: l_errstack VARCHAR2(2000);
204: --
205: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
206: --
207: l_header_id NUMBER;
208: l_orig_sys_line_ref VARCHAR2(50);
209: l_orig_sys_shipment_ref VARCHAR2(50);

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

243: ,p_source_document_id => l_source_document_id
244: ,p_source_document_line_id => l_source_document_line_id );
245:
246: IF l_debug_level > 0 THEN
247: oe_debug_pub.add( 'WORK FLOW ERROR HAS OCCURED ' , 1 ) ;
248: END IF;
249: WF_CORE.Get_Error(l_errname, l_errmsg, l_errstack);
250: IF l_errname = 'WFENG_ACTIVITY_ATTR' THEN
251: IF l_debug_level > 0 THEN

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

248: END IF;
249: WF_CORE.Get_Error(l_errname, l_errmsg, l_errstack);
250: IF l_errname = 'WFENG_ACTIVITY_ATTR' THEN
251: IF l_debug_level > 0 THEN
252: oe_debug_pub.add( 'ERROR MESSAGE '||L_ERRMSG , 1 ) ;
253: END IF;
254: x_attribute_value := 'NONE';
255: x_return_status := FND_API.G_RET_STS_SUCCESS;
256: ELSE

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

294: l_Honor_Price_Flag_attr VARCHAR2(30):='HONOR_PRICE_FLAG';
295: l_Honor_Price_Flag VARCHAR2(30);
296: l_item_type VARCHAR2(8) := OE_GLOBALS.G_WFI_LIN;
297: --
298: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
299: --
300: --CC Reversal ER#16014135 Start
301: l_msg_count NUMBER := 0;
302: l_msg_data VARCHAR2(2000);

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

306: --CC Reversal ER#16014135 End
307: BEGIN
308:
309: IF l_debug_level > 0 THEN
310: oe_debug_pub.add( 'ENTERING OE_LINE_REPRICE.PROCESS_REPRICING '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;
311: END IF;
312:
313: x_result_out := 'COMPLETE';
314:

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

344: END IF;
345: Commented for bug 7592279 end*/
346:
347: IF l_debug_level > 0 THEN
348: oe_debug_pub.add( 'ACTIVTITY ID : '||TO_CHAR ( P_ACTIVITY_ID ) , 3 ) ;
349: END IF;
350: l_item_key := to_char(p_line_id);
351:
352: IF l_debug_level > 0 THEN

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

349: END IF;
350: l_item_key := to_char(p_line_id);
351:
352: IF l_debug_level > 0 THEN
353: oe_debug_pub.add( 'CALLING GET REPRICING ACTIVITY ' , 3 ) ;
354: END IF;
355:
356: Get_Activity_Attribute
357: (

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

369: RAISE FND_API.G_EXC_ERROR;
370: END IF;
371:
372: IF l_debug_level > 0 THEN
373: oe_debug_pub.add( 'REPRICING DATE : '|| L_REPRICING_DATE , 3 ) ;
374: oe_debug_pub.add( 'CALLING GET ATTRIBUTE - REPRICING EVENT ' , 3 ) ;
375: END IF;
376:
377: Get_Activity_Attribute

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

370: END IF;
371:
372: IF l_debug_level > 0 THEN
373: oe_debug_pub.add( 'REPRICING DATE : '|| L_REPRICING_DATE , 3 ) ;
374: oe_debug_pub.add( 'CALLING GET ATTRIBUTE - REPRICING EVENT ' , 3 ) ;
375: END IF;
376:
377: Get_Activity_Attribute
378: (

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

394: l_Repricing_Event := 'REPRICE_LINE';
395: End If;
396:
397: IF l_debug_level > 0 THEN
398: oe_debug_pub.add( 'REPRICING EVENT : '|| L_REPRICING_EVENT , 3 ) ;
399: END IF;
400:
401: Get_Activity_Attribute
402: (

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

418: l_Honor_Price_Flag := 'Y';
419: End If;
420:
421: IF l_debug_level > 0 THEN
422: oe_debug_pub.add( 'HONOR PRICE FLAG : '|| L_HONOR_PRICE_FLAG , 3 ) ;
423: END IF;
424:
425: Reprice_Line
426: (

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

431: x_return_status => l_return_status
432: );
433:
434: IF l_debug_level > 0 THEN
435: oe_debug_pub.add( 'RETURN STATUS FROM REPRICE LINE : '||L_RETURN_STATUS , 3 ) ;
436: END IF;
437:
438: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 446: OE_DEBUG_PUB.ADD('Checking credit card reversal/re-auth parameter',5);

442: END IF;
443:
444: --CC Reversal ER#16014135 Start
445: IF l_debug_level > 0 THEN
446: OE_DEBUG_PUB.ADD('Checking credit card reversal/re-auth parameter',5);
447: END IF;
448: l_cc_rev_reauth_code:= OE_VERIFY_PAYMENT_PUB.Get_CC_Rev_Reauth_Code(l_line_rec.header_id);
449: IF l_cc_rev_reauth_code is not null and l_cc_rev_reauth_code IN ('REV_REAUTH_AT_REPRICE_FULFILL','REV_REAUTH','CC_HOLD') THEN
450: BEGIN

Line 452: OE_DEBUG_PUB.ADD('Calling OE_Verify_Payment_PUB.Authorize_MultiPayments',5);

448: l_cc_rev_reauth_code:= OE_VERIFY_PAYMENT_PUB.Get_CC_Rev_Reauth_Code(l_line_rec.header_id);
449: IF l_cc_rev_reauth_code is not null and l_cc_rev_reauth_code IN ('REV_REAUTH_AT_REPRICE_FULFILL','REV_REAUTH','CC_HOLD') THEN
450: BEGIN
451: IF l_debug_level > 0 THEN
452: OE_DEBUG_PUB.ADD('Calling OE_Verify_Payment_PUB.Authorize_MultiPayments',5);
453: END IF;
454: OE_Header_UTIL.Query_Row
455: (p_header_id => l_line_rec.header_id
456: ,x_header_rec => l_header_rec

Line 468: oe_debug_pub.add('After call to Authorizat Payment return status : ' || l_return_status);

464: , p_return_status => l_return_status
465: );
466:
467: IF l_debug_level > 0 THEN
468: oe_debug_pub.add('After call to Authorizat Payment return status : ' || l_return_status);
469: END IF;
470:
471: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
472: RAISE FND_API.G_EXC_ERROR;

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

477: END IF;
478: --CC Reversal ER#16014135 End
479:
480: IF l_debug_level > 0 THEN
481: oe_debug_pub.add( 'EXITING FROM OE_LINE_REPRICE.PROCESS_REPRICING : '||X_RETURN_STATUS , 1 ) ;
482: END IF;
483:
484: EXCEPTION
485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

483:
484: EXCEPTION
485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
486: IF l_debug_level > 0 THEN
487: oe_debug_pub.add( 'PROCESS_REPRICING : EXITING WITH UNEXPECTED ERROR'||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
488: END IF;
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
490: x_result_out := 'INCOMPLETE';
491: /* IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

500: x_return_status := FND_API.G_RET_STS_ERROR;
501: x_result_out := 'INCOMPLETE';
502: WHEN OTHERS THEN
503: IF l_debug_level > 0 THEN
504: oe_debug_pub.add('In others of Process_Reprice ');
505: oe_debug_pub.add( 'PROCESS_REPRICING : EXITING WITH OTHERS ERROR' , 1 ) ;
506: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
507: END IF;
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

501: x_result_out := 'INCOMPLETE';
502: WHEN OTHERS THEN
503: IF l_debug_level > 0 THEN
504: oe_debug_pub.add('In others of Process_Reprice ');
505: oe_debug_pub.add( 'PROCESS_REPRICING : EXITING WITH OTHERS ERROR' , 1 ) ;
506: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
507: END IF;
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
509: x_result_out := 'INCOMPLETE';

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

502: WHEN OTHERS THEN
503: IF l_debug_level > 0 THEN
504: oe_debug_pub.add('In others of Process_Reprice ');
505: oe_debug_pub.add( 'PROCESS_REPRICING : EXITING WITH OTHERS ERROR' , 1 ) ;
506: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
507: END IF;
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
509: x_result_out := 'INCOMPLETE';
510: oe_line_reprice.set_reprice_status('REPRICE_UNEXPECTED_ERROR', p_line_id);

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

528: Procedure set_reprice_status (p_flow_status IN VARCHAR2,
529: p_line_id IN NUMBER)
530: IS
531:
532: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
533:
534: BEGIN
535:
536: IF l_debug_level > 0 THEN

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

533:
534: BEGIN
535:
536: IF l_debug_level > 0 THEN
537: oe_debug_pub.add('Setting Flow Stauts code to '||p_flow_status || 'for line id ' ||p_line_id);
538: END IF;
539:
540: IF oe_code_control.code_release_level>='110510' THEN
541: Update oe_order_lines_all