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

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

11:
12: l_Header_Adj_Assoc_Tbl OE_ORDER_PUB.Header_Adj_Assoc_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_Assoc_id => p_price_adj_Assoc_id

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

56: ( PRICE_ADJ_assoc_ID = p_price_adj_Assoc_id
57: or price_adjustment_id = p_price_adjustment_id);
58:
59: --
60: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
61: --
62: BEGIN
63:
64: l_count := 1;

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

126: IS
127: l_lock_control NUMBER := 1;
128:
129: --
130: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
131: --
132: BEGIN
133:
134: INSERT INTO OE_PRICE_ADJ_ASSOCS

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

187: IS
188: l_lock_control NUMBER;
189:
190: --
191: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
192: --
193: BEGIN
194:
195: SELECT lock_control

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

240: , p_price_adjustment_id NUMBER := FND_API.G_MISS_NUM
241: )
242: IS
243: --
244: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
245: --
246: BEGIN
247: IF p_price_adjustment_id <> FND_API.G_MISS_NUM then
248: -- SQL ID: 16486572

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

274: IS
275:
276: l_Header_Adj_Assoc_Rec OE_Order_PUB.Header_Adj_Assoc_Rec_Type := p_x_Header_Adj_Assoc_Rec;
277: --
278: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
279: --
280: BEGIN
281:
282: IF l_Header_Adj_Assoc_Rec.RLTD_PRICE_ADJ_ID = FND_API.G_MISS_NUM THEN

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

343: )
344: IS
345: l_Header_Adj_Assoc_Rec OE_Order_PUB.Header_Adj_Assoc_Rec_Type := p_x_Header_Adj_Assoc_Rec;
346: --
347: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
348: --
349: BEGIN
350: IF l_Header_Adj_Assoc_Rec.RLTD_PRICE_ADJ_ID = FND_API.G_MISS_NUM THEN
351: l_Header_Adj_Assoc_Rec.RLTD_PRICE_ADJ_ID := Null;

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

411: )
412: IS
413:
414: --
415: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
416: --
417: BEGIN
418:
419: p_x_Header_Adj_Assoc_Rec := p_x_Header_Adj_Assoc_Rec;

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

432: l_lock_control NUMBER;
433: l_price_adj_assoc_id NUMBER;
434:
435: --
436: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
437: --
438: BEGIN
439:
440: IF l_debug_level > 0 THEN

Line 441: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_ASSOCS_UTIL.LOCK_ROW.' , 1 ) ;

437: --
438: BEGIN
439:
440: IF l_debug_level > 0 THEN
441: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_ASSOCS_UTIL.LOCK_ROW.' , 1 ) ;
442: END IF;
443: SAVEPOINT Lock_Row;
444:
445: l_lock_control := NULL;

Line 467: oe_debug_pub.add( 'QUERIED LOCK_CONTROL: '|| P_X_HEADER_ADJ_ASSOC_REC.LOCK_CONTROL , 1 ) ;

463: );
464:
465:
466: IF l_debug_level > 0 THEN
467: oe_debug_pub.add( 'QUERIED LOCK_CONTROL: '|| P_X_HEADER_ADJ_ASSOC_REC.LOCK_CONTROL , 1 ) ;
468: END IF;
469:
470: -- If lock_control is not passed(is null or missing), then return the locked record.
471:

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

485: -- Row locked. If the whole record is passed, then
486: -- Compare lock_control.
487:
488: IF l_debug_level > 0 THEN
489: oe_debug_pub.add( 'COMPARE ' , 1 ) ;
490: END IF;
491:
492: IF OE_GLOBALS.Equal(p_x_Header_Adj_Assoc_rec.lock_control,
493: l_lock_control)

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

495:
496: -- Row has not changed. Set out parameter.
497:
498: IF l_debug_level > 0 THEN
499: oe_debug_pub.add( 'LOCKED ROW' , 1 ) ;
500: END IF;
501:
502: -- Set return status
503:

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

507: ELSE
508:
509: -- Row has changed by another user.
510: IF l_debug_level > 0 THEN
511: oe_debug_pub.add( 'ROW CHANGED BY OTHER USER' , 1 ) ;
512: END IF;
513:
514: x_return_status := FND_API.G_RET_STS_ERROR;
515: p_x_Header_Adj_Assoc_rec.return_status := FND_API.G_RET_STS_ERROR;

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

583: l_price_adj_assoc_id NUMBER;
584: l_lock_control NUMBER;
585:
586: --
587: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
588: --
589: BEGIN
590:
591: IF l_debug_level > 0 THEN

Line 592: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_ASSOCS_UTIL.LOCK_ROWS.' , 1 ) ;

588: --
589: BEGIN
590:
591: IF l_debug_level > 0 THEN
592: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_ASSOCS_UTIL.LOCK_ROWS.' , 1 ) ;
593: END IF;
594:
595: IF (p_price_adj_assoc_id IS NOT NULL AND
596: p_price_adj_assoc_id <> FND_API.G_MISS_NUM) AND

Line 681: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_ASSOCS_UTIL.LOCK_ROWS.' , 1 ) ;

677: );
678: END IF;
679:
680: IF l_debug_level > 0 THEN
681: oe_debug_pub.add( 'EXITING OE_HEADER_ADJ_ASSOCS_UTIL.LOCK_ROWS.' , 1 ) ;
682: END IF;
683:
684:
685: END lock_rows;