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_ADV_PRICE_PVT dependencies on OE_ADV_PRICE_PVT

Line 1: PACKAGE BODY OE_ADV_PRICE_PVT AS

1: PACKAGE BODY OE_ADV_PRICE_PVT AS
2: /* $Header: OEXVAPRB.pls 120.16.12020000.9 2013/05/22 05:13:38 nilegupt ship $ */
3:
4: -- Global constant holding the package name
5:

Line 276: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_ADV_PRICE_PVT.DELETE_ATTRIBS_FOR_IUE IS: ' || L_RETURN_STATUS ) ;

272: x_return_status => l_return_status);
273: end if;
274: --End of Bug 13573144
275: IF l_debug_level > 0 THEN
276: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_ADV_PRICE_PVT.DELETE_ATTRIBS_FOR_IUE IS: ' || L_RETURN_STATUS ) ;
277: END IF;
278:
279: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
280:

Line 283: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.DELETE_ATTRIBS_FOR_IUE' , 1 ) ;

279: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
280:
281: IF l_debug_level > 0 THEN
282: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
283: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.DELETE_ATTRIBS_FOR_IUE' , 1 ) ;
284: END IF;
285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
286: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
287: IF l_debug_level > 0 THEN

Line 288: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_ADV_PRICE_PVT.DELETE_ATTRIBS_FOR_IUE' ) ;

284: END IF;
285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
286: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
287: IF l_debug_level > 0 THEN
288: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_ADV_PRICE_PVT.DELETE_ATTRIBS_FOR_IUE' ) ;
289: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS' , 1 ) ;
290: END IF;
291: RAISE FND_API.G_EXC_ERROR;
292: END IF;

Line 1488: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.set_prg', 3);

1484: x_return_status => l_return_status);
1485: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1486: IF l_debug_level > 0 THEN
1487: oe_debug_pub.add( 'unexp error logging batch event for updated free goods line', 3) ;
1488: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.set_prg', 3);
1489: END IF;
1490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1491: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1492: IF l_debug_level > 0 THEN

Line 1494: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.set_prg' , 1 ) ;

1490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1491: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1492: IF l_debug_level > 0 THEN
1493: oe_debug_pub.add( 'error logging batch event for update free goods line',3);
1494: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.set_prg' , 1 ) ;
1495: END IF;
1496: RAISE FND_API.G_EXC_ERROR;
1497: END IF;
1498: -- sol_ord_er #16014165

Line 1512: oe_debug_pub.add( '(1) EXITING OE_ADV_PRICE_PVT.set_prg', 3);

1508: x_return_status => l_return_status);
1509: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1510: IF l_debug_level > 0 THEN
1511: oe_debug_pub.add( 'unexp error logging G_SERVICE_FIRST_PERIOD_BILL', 3) ;
1512: oe_debug_pub.add( '(1) EXITING OE_ADV_PRICE_PVT.set_prg', 3);
1513: END IF;
1514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1515: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1516: IF l_debug_level > 0 THEN

Line 1518: oe_debug_pub.add( '(2) EXITING OE_ADV_PRICE_PVT.set_prg' , 1 ) ;

1514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1515: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1516: IF l_debug_level > 0 THEN
1517: oe_debug_pub.add( 'error logging G_SERVICE_FIRST_PERIOD_BILL',3);
1518: oe_debug_pub.add( '(2) EXITING OE_ADV_PRICE_PVT.set_prg' , 1 ) ;
1519: END IF;
1520: RAISE FND_API.G_EXC_ERROR;
1521: END IF;
1522: -- sol_ord_er #16014165 end

Line 2222: oe_debug_pub.add(' In OE_ADV_PRICE_PVT.CHECK_NOTIFY');

2218: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2219: begin
2220:
2221: IF l_debug_level > 0 THEN
2222: oe_debug_pub.add(' In OE_ADV_PRICE_PVT.CHECK_NOTIFY');
2223: END IF;
2224: begin
2225: select 1 into l_source_system_code from
2226: oe_order_headers_all oh,

Line 2517: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY IS: ' || L_RETURN_STATUS ) ;

2513: x_index => l_index,
2514: x_return_status => l_return_status);*/
2515:
2516: IF l_debug_level > 0 THEN
2517: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY IS: ' || L_RETURN_STATUS ) ;
2518: END IF;
2519: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2520: IF l_debug_level > 0 THEN
2521: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

Line 2522: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY');

2518: END IF;
2519: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2520: IF l_debug_level > 0 THEN
2521: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2522: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY');
2523: END IF;
2524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2525: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2526: IF l_debug_level > 0 THEN

Line 2527: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY' ) ;

2523: END IF;
2524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2525: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2526: IF l_debug_level > 0 THEN
2527: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY' ) ;
2528: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY' , 1 ) ;
2529: END IF;
2530: RAISE FND_API.G_EXC_ERROR;
2531: END IF;

Line 2528: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY' , 1 ) ;

2524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2525: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2526: IF l_debug_level > 0 THEN
2527: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY' ) ;
2528: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY' , 1 ) ;
2529: END IF;
2530: RAISE FND_API.G_EXC_ERROR;
2531: END IF;
2532:

Line 2676: oe_debug_pub.add( 'INSIDE OE_ADV_PRICE_PVT.INSERT_ADJ' ) ;

2672: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2673: --
2674: BEGIN
2675: IF l_debug_level > 0 THEN
2676: oe_debug_pub.add( 'INSIDE OE_ADV_PRICE_PVT.INSERT_ADJ' ) ;
2677: END IF;
2678: INSERT INTO OE_PRICE_ADJUSTMENTS
2679: ( PRICE_ADJUSTMENT_ID
2680: , CREATION_DATE

Line 2990: end OE_ADV_PRICE_PVT;

2986: END IF;
2987: Raise FND_API.G_EXC_ERROR;
2988: END Insert_Adj;
2989:
2990: end OE_ADV_PRICE_PVT;