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

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

11:
12: l_Line_Adj_Att_Tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
13:
14: --
15: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
16: --
17: BEGIN
18: Query_Rows
19: ( p_price_adj_attrib_id => p_price_adj_attrib_id

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

81: from oe_price_adj_attribs where
82: price_adjustment_id = p_price_adjustment_id;
83:
84: --
85: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
86: --
87: BEGIN
88:
89: l_count := 1;

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

152: IS
153: l_lock_control NUMBER := 1;
154:
155: --
156: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
157: --
158: BEGIN
159: IF l_debug_level > 0 THEN
160: oe_debug_pub.add('Entering Oe_Line_Price_Aattr_util.insert_row');

Line 160: oe_debug_pub.add('Entering Oe_Line_Price_Aattr_util.insert_row');

156: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
157: --
158: BEGIN
159: IF l_debug_level > 0 THEN
160: oe_debug_pub.add('Entering Oe_Line_Price_Aattr_util.insert_row');
161: END IF;
162:
163: INSERT INTO OE_PRICE_ADJ_ATTRIBS
164: ( PRICE_ADJUSTMENT_ID

Line 207: oe_debug_pub.add('Leaving Oe_Line_Price_Aattr_util.insert_row');

203:
204: p_Line_Adj_Att_Rec.lock_control := l_lock_control;
205:
206: IF l_debug_level > 0 THEN
207: oe_debug_pub.add('Leaving Oe_Line_Price_Aattr_util.insert_row');
208: END IF;
209:
210: EXCEPTION
211:

Line 223: oe_debug_pub.add('Exceptions in Oe_Line_Price_Aattr_util.insert_row:'||SQLERRM);

219: );
220: END IF;
221:
222: IF l_debug_level > 0 THEN
223: oe_debug_pub.add('Exceptions in Oe_Line_Price_Aattr_util.insert_row:'||SQLERRM);
224: END IF;
225:
226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
227:

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

233: IS
234: l_lock_control NUMBER;
235:
236: --
237: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
238: --
239: BEGIN
240: SELECT lock_control
241: INTO l_lock_control

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

291: , p_price_adjustment_id NUMBER := FND_API.G_MISS_NUM
292: )
293: IS
294: --
295: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
296: --
297: BEGIN
298:
299: IF p_price_adjustment_id <> FND_API.G_MISS_NUM then

Line 310: oe_debug_pub.add('pviprana: Deleted '||SQL%ROWCOUNT||' pricing attributes of child lines');

306: WHERE ASSOCS.PRICE_ADJUSTMENT_ID=PARENT.PRICE_ADJUSTMENT_ID
307: AND PARENT.PRICE_ADJUSTMENT_ID=p_price_adjustment_id
308: AND PARENT.LIST_LINE_TYPE_CODE='PBH');
309: IF l_debug_level > 0 THEN
310: oe_debug_pub.add('pviprana: Deleted '||SQL%ROWCOUNT||' pricing attributes of child lines');
311: END IF;
312:
313:
314:

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

341: IS
342:
343: l_Line_Adj_Att_rec OE_Order_PUB.Line_Adj_Att_Rec_Type := p_x_Line_Adj_Att_rec;
344: --
345: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
346: --
347: BEGIN
348:
349: IF l_Line_Adj_Att_rec.PRICE_ADJUSTMENT_ID = FND_API.G_MISS_NUM THEN

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

424: )
425: IS
426: l_Line_Adj_Att_rec OE_Order_PUB.Line_Adj_Att_Rec_Type := p_x_Line_Adj_Att_rec;
427: --
428: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
429: --
430: BEGIN
431:
432: IF l_Line_Adj_Att_rec.PRICE_ADJUSTMENT_ID = FND_API.G_MISS_NUM THEN

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

509: )
510: IS
511:
512: --
513: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
514: --
515: BEGIN
516:
517: -- x_Line_Adj_Att_rec := p_Line_Adj_Att_rec;

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

530: l_lock_control NUMBER;
531: l_price_adj_attrib_id NUMBER;
532:
533: --
534: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
535: --
536: BEGIN
537:
538: IF l_debug_level > 0 THEN

Line 539: oe_debug_pub.add( 'ENTERING OE_LINE_PRICE_PATTR_UTIL.LOCK_ROW.' , 1 ) ;

535: --
536: BEGIN
537:
538: IF l_debug_level > 0 THEN
539: oe_debug_pub.add( 'ENTERING OE_LINE_PRICE_PATTR_UTIL.LOCK_ROW.' , 1 ) ;
540: END IF;
541: SAVEPOINT Lock_Row;
542:
543: l_lock_control := NULL;

Line 565: oe_debug_pub.add( 'QUERIED LOCK_CONTROL: '|| P_X_LINE_ADJ_ATT_REC.LOCK_CONTROL , 1 ) ;

561: );
562:
563:
564: IF l_debug_level > 0 THEN
565: oe_debug_pub.add( 'QUERIED LOCK_CONTROL: '|| P_X_LINE_ADJ_ATT_REC.LOCK_CONTROL , 1 ) ;
566: END IF;
567:
568: -- If lock_control is not passed(is null or missing), then return the locked record.
569:

Line 587: oe_debug_pub.add( 'COMPARE ' , 1 ) ;

583: -- Row locked. If the whole record is passed, then
584: -- Compare lock_control.
585:
586: IF l_debug_level > 0 THEN
587: oe_debug_pub.add( 'COMPARE ' , 1 ) ;
588: END IF;
589:
590: IF OE_GLOBALS.Equal(p_x_Line_Adj_Att_rec.lock_control,
591: l_lock_control)

Line 597: oe_debug_pub.add( 'LOCKED ROW' , 1 ) ;

593:
594: -- Row has not changed. Set out parameter.
595:
596: IF l_debug_level > 0 THEN
597: oe_debug_pub.add( 'LOCKED ROW' , 1 ) ;
598: END IF;
599:
600: -- Set return status
601:

Line 609: oe_debug_pub.add( 'ROW CHANGED BY OTHER USER' , 1 ) ;

605: ELSE
606:
607: -- Row has changed by another user.
608: IF l_debug_level > 0 THEN
609: oe_debug_pub.add( 'ROW CHANGED BY OTHER USER' , 1 ) ;
610: END IF;
611:
612: x_return_status := FND_API.G_RET_STS_ERROR;
613: p_x_Line_Adj_Att_rec.return_status := FND_API.G_RET_STS_ERROR;

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

680: l_price_adj_attrib_id NUMBER;
681: l_lock_control NUMBER;
682:
683: --
684: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
685: --
686: BEGIN
687:
688: IF l_debug_level > 0 THEN

Line 689: oe_debug_pub.add( 'ENTERING OE_LINE_PRICE_AATTR_UTIL.LOCK_ROWS.' , 1 ) ;

685: --
686: BEGIN
687:
688: IF l_debug_level > 0 THEN
689: oe_debug_pub.add( 'ENTERING OE_LINE_PRICE_AATTR_UTIL.LOCK_ROWS.' , 1 ) ;
690: END IF;
691:
692: IF (p_price_adj_attrib_id IS NOT NULL AND
693: p_price_adj_attrib_id <> FND_API.G_MISS_NUM) AND

Line 778: oe_debug_pub.add( 'EXITING OE_LINE_PRICE_AATTR_UTIL.LOCK_ROWS.' , 1 ) ;

774: );
775: END IF;
776:
777: IF l_debug_level > 0 THEN
778: oe_debug_pub.add( 'EXITING OE_LINE_PRICE_AATTR_UTIL.LOCK_ROWS.' , 1 ) ;
779: END IF;
780:
781:
782: END lock_rows;