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.9.12010000.3 2008/11/22 02:41:56 lagrawal ship $ */
3:
4: -- Global constant holding the package name
5:

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

227: x_index => l_index,
228: x_return_status => l_return_status);
229:
230: IF l_debug_level > 0 THEN
231: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_ADV_PRICE_PVT.DELETE_ATTRIBS_FOR_IUE IS: ' || L_RETURN_STATUS ) ;
232: END IF;
233:
234: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
235:

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

234: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
235:
236: IF l_debug_level > 0 THEN
237: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
238: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.DELETE_ATTRIBS_FOR_IUE' , 1 ) ;
239: END IF;
240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
241: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
242: IF l_debug_level > 0 THEN

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

239: END IF;
240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
241: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
242: IF l_debug_level > 0 THEN
243: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_ADV_PRICE_PVT.DELETE_ATTRIBS_FOR_IUE' ) ;
244: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS' , 1 ) ;
245: END IF;
246: RAISE FND_API.G_EXC_ERROR;
247: END IF;

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

1184: x_return_status => l_return_status);
1185: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1186: IF l_debug_level > 0 THEN
1187: oe_debug_pub.add( 'unexp error logging batch event for updated free goods line', 3) ;
1188: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.set_prg', 3);
1189: END IF;
1190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1191: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1192: IF l_debug_level > 0 THEN

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

1190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1191: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1192: IF l_debug_level > 0 THEN
1193: oe_debug_pub.add( 'error logging batch event for update free goods line',3);
1194: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.set_prg' , 1 ) ;
1195: END IF;
1196: RAISE FND_API.G_EXC_ERROR;
1197: END IF;
1198: END IF;

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

1791: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1792: begin
1793:
1794: IF l_debug_level > 0 THEN
1795: oe_debug_pub.add(' In OE_ADV_PRICE_PVT.CHECK_NOTIFY');
1796: END IF;
1797: begin
1798: select 1 into l_source_system_code from
1799: oe_order_headers_all oh,

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

2048: x_index => l_index,
2049: x_return_status => l_return_status);*/
2050:
2051: IF l_debug_level > 0 THEN
2052: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY IS: ' || L_RETURN_STATUS ) ;
2053: END IF;
2054: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2055: IF l_debug_level > 0 THEN
2056: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

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

2053: END IF;
2054: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2055: IF l_debug_level > 0 THEN
2056: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2057: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY');
2058: END IF;
2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2061: IF l_debug_level > 0 THEN

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

2058: END IF;
2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2061: IF l_debug_level > 0 THEN
2062: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY' ) ;
2063: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY' , 1 ) ;
2064: END IF;
2065: RAISE FND_API.G_EXC_ERROR;
2066: END IF;

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

2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2061: IF l_debug_level > 0 THEN
2062: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY' ) ;
2063: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY' , 1 ) ;
2064: END IF;
2065: RAISE FND_API.G_EXC_ERROR;
2066: END IF;
2067:

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

2204: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2205: --
2206: BEGIN
2207: IF l_debug_level > 0 THEN
2208: oe_debug_pub.add( 'INSIDE OE_ADV_PRICE_PVT.INSERT_ADJ' ) ;
2209: END IF;
2210: INSERT INTO OE_PRICE_ADJUSTMENTS
2211: ( PRICE_ADJUSTMENT_ID
2212: , CREATION_DATE

Line 2514: end OE_ADV_PRICE_PVT;

2510: END IF;
2511: Raise FND_API.G_EXC_ERROR;
2512: END Insert_Adj;
2513:
2514: end OE_ADV_PRICE_PVT;