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

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

23: ,x_return_status OUT NOCOPY VARCHAR2)
24:
25: IS
26: --
27: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
28: --
29: BEGIN
30:
31: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 259: oe_debug_pub.add( 'OTHERS ERROR , INSERT_ADJUSTMENTS' ) ;

255:
256: EXCEPTION
257: WHEN OTHERS THEN
258: IF l_debug_level > 0 THEN
259: oe_debug_pub.add( 'OTHERS ERROR , INSERT_ADJUSTMENTS' ) ;
260: END IF;
261: IF l_debug_level > 0 THEN
262: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
263: END IF;

Line 262: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

258: IF l_debug_level > 0 THEN
259: oe_debug_pub.add( 'OTHERS ERROR , INSERT_ADJUSTMENTS' ) ;
260: END IF;
261: IF l_debug_level > 0 THEN
262: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
263: END IF;
264: OE_BULK_MSG_PUB.Add_Exc_Msg
265: (G_PKG_NAME
266: ,'Insert_Adjustments');

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

311: ,unit_selling_price
312: FROM OE_ORDER_LINES l
313: WHERE l.header_id = l_header_id;
314: --
315: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
316: --
317: BEGIN
318:
319: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 339: oe_debug_pub.add( 'HEADER ID:'||L_HEADER_ID ) ;

335: l_header_id := p_header_rec.header_id(i);
336: l_book_failed := 'N'; --bug 4558078
337:
338: IF l_debug_level > 0 THEN
339: oe_debug_pub.add( 'HEADER ID:'||L_HEADER_ID ) ;
340: END IF;
341:
342: IF nvl(p_header_rec.lock_control(i),0) <> -99 AND
343: nvl(p_header_rec.lock_control(i),0) <> -98 AND

Line 348: oe_debug_pub.add( 'PRICE ORDER , HEADER ID:'||L_HEADER_ID ) ;

344: nvl(p_header_rec.lock_control(i),0) <> -97
345: THEN
346:
347: IF l_debug_level > 0 THEN
348: oe_debug_pub.add( 'PRICE ORDER , HEADER ID:'||L_HEADER_ID ) ;
349: END IF;
350:
351: IF OE_BULK_ORDER_PVT.G_PRICING_NEEDED = 'Y' THEN --bug 455807
352:

Line 388: OE_DEBUG_PUB.Add('UnExpected Error in Pricing '|| l_header_id,2);

384: ,x_line_Tbl => l_Line_Tbl
385: );
386:
387: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
388: OE_DEBUG_PUB.Add('UnExpected Error in Pricing '|| l_header_id,2);
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
391: OE_DEBUG_PUB.Add('Expected Error in Pricing '|| l_header_id,2);
392: -- Mark the header for error

Line 391: OE_DEBUG_PUB.Add('Expected Error in Pricing '|| l_header_id,2);

387: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
388: OE_DEBUG_PUB.Add('UnExpected Error in Pricing '|| l_header_id,2);
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
391: OE_DEBUG_PUB.Add('Expected Error in Pricing '|| l_header_id,2);
392: -- Mark the header for error
393: mark_header_error(i, p_header_rec);
394: p_header_rec.lock_control(i) := -99;
395: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 401: OE_DEBUG_PUB.Add('Expected Error in Pricing '|| l_header_id,2);

397:
398: EXCEPTION
399: WHEN FND_API.G_EXC_ERROR THEN
400: IF l_debug_level > 0 then
401: OE_DEBUG_PUB.Add('Expected Error in Pricing '|| l_header_id,2);
402: End if;
403: mark_header_error(i,p_header_rec);
404: p_header_rec.lock_control(i) := -99;
405: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 409: OE_DEBUG_PUB.Add('Unexp Error in Pricing:'||l_header_id|| ' '||SqlErrm, 1);

405: x_return_status := FND_API.G_RET_STS_SUCCESS;
406:
407: WHEN OTHERS THEN
408: IF l_debug_level > 0 THEN
409: OE_DEBUG_PUB.Add('Unexp Error in Pricing:'||l_header_id|| ' '||SqlErrm, 1);
410: End if;
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: END;

Line 431: oe_debug_pub.add( 'DATA FOUND , BOOK FAILED' ) ;

427: OR l.unit_list_price IS NULL
428: OR l.unit_selling_price IS NULL)
429: AND rownum = 1;
430: IF l_debug_level > 0 THEN
431: oe_debug_pub.add( 'DATA FOUND , BOOK FAILED' ) ;
432: END IF;
433: EXCEPTION
434: WHEN NO_DATA_FOUND THEN
435: l_book_failed := 'N';

Line 511: oe_debug_pub.add('G_CC_REQUIRED IS: '||OE_BULK_ORDER_PVT.G_CC_REQUIRED ) ;

507: END IF; -- if book failed, populate errors else add message that
508: -- order is booked
509: --bug 455807
510: IF l_debug_level > 0 THEN
511: oe_debug_pub.add('G_CC_REQUIRED IS: '||OE_BULK_ORDER_PVT.G_CC_REQUIRED ) ;
512: oe_debug_pub.add('l_book_failed IS : '||l_book_failed ) ;
513: oe_debug_pub.add('G_REALTIME_CC_REQUIRED IS: '||OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED ) ;
514: END IF;
515:

Line 512: oe_debug_pub.add('l_book_failed IS : '||l_book_failed ) ;

508: -- order is booked
509: --bug 455807
510: IF l_debug_level > 0 THEN
511: oe_debug_pub.add('G_CC_REQUIRED IS: '||OE_BULK_ORDER_PVT.G_CC_REQUIRED ) ;
512: oe_debug_pub.add('l_book_failed IS : '||l_book_failed ) ;
513: oe_debug_pub.add('G_REALTIME_CC_REQUIRED IS: '||OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED ) ;
514: END IF;
515:
516: IF OE_BULK_ORDER_PVT.G_CC_REQUIRED = 'Y' AND l_book_failed = 'N' THEN

Line 513: oe_debug_pub.add('G_REALTIME_CC_REQUIRED IS: '||OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED ) ;

509: --bug 455807
510: IF l_debug_level > 0 THEN
511: oe_debug_pub.add('G_CC_REQUIRED IS: '||OE_BULK_ORDER_PVT.G_CC_REQUIRED ) ;
512: oe_debug_pub.add('l_book_failed IS : '||l_book_failed ) ;
513: oe_debug_pub.add('G_REALTIME_CC_REQUIRED IS: '||OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED ) ;
514: END IF;
515:
516: IF OE_BULK_ORDER_PVT.G_CC_REQUIRED = 'Y' AND l_book_failed = 'N' THEN
517:

Line 564: oe_debug_pub.add( 'HEADER ID:'||L_HEADER_ID ) ;

560: l_header_id := p_header_rec.header_id(i);
561: l_book_failed := 'N';
562:
563: IF l_debug_level > 0 THEN
564: oe_debug_pub.add( 'HEADER ID:'||L_HEADER_ID ) ;
565: END IF;
566:
567: IF nvl(p_header_rec.lock_control(i),0) <> -99 AND
568: nvl(p_header_rec.lock_control(i),0) <> -98 AND

Line 573: oe_debug_pub.add( 'PRICE ORDER , HEADER ID:'||L_HEADER_ID ) ;

569: nvl(p_header_rec.lock_control(i),0) <> -97
570: THEN
571:
572: IF l_debug_level > 0 THEN
573: oe_debug_pub.add( 'PRICE ORDER , HEADER ID:'||L_HEADER_ID ) ;
574: END IF;
575:
576: IF OE_BULK_ORDER_PVT.G_PRICING_NEEDED = 'Y' THEN
577:

Line 709: oe_debug_pub.add( 'CREDIT CHECK ORDER , HEADER ID:'||L_HEADER_ID )

705: nvl(p_header_rec.lock_control(i),0) <> -97
706: THEN
707:
708: IF l_debug_level > 0 THEN
709: oe_debug_pub.add( 'CREDIT CHECK ORDER , HEADER ID:'||L_HEADER_ID )
710: ;
711: oe_debug_pub.add('G_CC_REQUIRED IS: '||OE_BULK_ORDER_PVT.G_CC_REQUIRED ) ;
712: oe_debug_pub.add('l_book_failed IS : '||l_book_failed ) ;
713: oe_debug_pub.add('G_REALTIME_CC_REQUIRED IS: '||OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED ) ;

Line 711: oe_debug_pub.add('G_CC_REQUIRED IS: '||OE_BULK_ORDER_PVT.G_CC_REQUIRED ) ;

707:
708: IF l_debug_level > 0 THEN
709: oe_debug_pub.add( 'CREDIT CHECK ORDER , HEADER ID:'||L_HEADER_ID )
710: ;
711: oe_debug_pub.add('G_CC_REQUIRED IS: '||OE_BULK_ORDER_PVT.G_CC_REQUIRED ) ;
712: oe_debug_pub.add('l_book_failed IS : '||l_book_failed ) ;
713: oe_debug_pub.add('G_REALTIME_CC_REQUIRED IS: '||OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED ) ;
714: END IF;
715:

Line 712: oe_debug_pub.add('l_book_failed IS : '||l_book_failed ) ;

708: IF l_debug_level > 0 THEN
709: oe_debug_pub.add( 'CREDIT CHECK ORDER , HEADER ID:'||L_HEADER_ID )
710: ;
711: oe_debug_pub.add('G_CC_REQUIRED IS: '||OE_BULK_ORDER_PVT.G_CC_REQUIRED ) ;
712: oe_debug_pub.add('l_book_failed IS : '||l_book_failed ) ;
713: oe_debug_pub.add('G_REALTIME_CC_REQUIRED IS: '||OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED ) ;
714: END IF;
715:
716: IF p_header_rec.booked_flag(i) = 'Y' THEN

Line 713: oe_debug_pub.add('G_REALTIME_CC_REQUIRED IS: '||OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED ) ;

709: oe_debug_pub.add( 'CREDIT CHECK ORDER , HEADER ID:'||L_HEADER_ID )
710: ;
711: oe_debug_pub.add('G_CC_REQUIRED IS: '||OE_BULK_ORDER_PVT.G_CC_REQUIRED ) ;
712: oe_debug_pub.add('l_book_failed IS : '||l_book_failed ) ;
713: oe_debug_pub.add('G_REALTIME_CC_REQUIRED IS: '||OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED ) ;
714: END IF;
715:
716: IF p_header_rec.booked_flag(i) = 'Y' THEN
717:

Line 821: oe_debug_pub.add(' In Update_Pricing_Attributes', 1);

817: )
818: IS
819: l_last_index binary_integer;
820: BEGIN
821: oe_debug_pub.add(' In Update_Pricing_Attributes', 1);
822: oe_debug_pub.add(' table count :'|| p_line_tbl.count, 1 );
823:
824: IF OE_BULK_PRICE_PVT.G_HEADER_INDEX IS NULL THEN
825: RETURN;

Line 822: oe_debug_pub.add(' table count :'|| p_line_tbl.count, 1 );

818: IS
819: l_last_index binary_integer;
820: BEGIN
821: oe_debug_pub.add(' In Update_Pricing_Attributes', 1);
822: oe_debug_pub.add(' table count :'|| p_line_tbl.count, 1 );
823:
824: IF OE_BULK_PRICE_PVT.G_HEADER_INDEX IS NULL THEN
825: RETURN;
826: ELSE

Line 856: oe_debug_pub.add(' Exit Update_Pricing_Attributes' ,1);

852: END IF;
853: END LOOP;
854: END LOOP;
855: END IF;
856: oe_debug_pub.add(' Exit Update_Pricing_Attributes' ,1);
857:
858: END Update_Pricing_Attributes;
859:
860:

Line 866: OE_DEBUG_PUB.Add('The error count is '|| error_count,2);

862: p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE)
863: IS
864: error_count NUMBER := OE_Bulk_Order_Pvt.G_ERROR_REC.header_id.COUNT;
865: BEGIN
866: OE_DEBUG_PUB.Add('The error count is '|| error_count,2);
867: error_count := error_count + 1;
868:
869: OE_Bulk_Order_Pvt.G_ERROR_REC.order_source_id.EXTEND(1);
870: OE_Bulk_Order_Pvt.G_ERROR_REC.order_source_id(error_count)

Line 880: OE_DEBUG_PUB.Add(' Exiting mark_header_error ',2);

876:
877: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id.EXTEND(1);
878: OE_Bulk_Order_Pvt.G_ERROR_REC.header_id(error_count)
879: := p_header_rec.header_id(p_header_index);
880: OE_DEBUG_PUB.Add(' Exiting mark_header_error ',2);
881:
882: END mark_header_error;
883:
884: