APPS.OE_ORDER_BOOK_UTIL dependencies on OE_ORDER_BOOK_UTIL

Line 1: PACKAGE BODY OE_ORDER_BOOK_UTIL AS

1: PACKAGE BODY OE_ORDER_BOOK_UTIL AS
2: /* $Header: OEXUBOKB.pls 120.9.12010000.2 2008/09/25 12:17:33 msundara ship $ */
3:
4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_ORDER_BOOK_UTIL';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_ORDER_BOOK_UTIL';

1: PACKAGE BODY OE_ORDER_BOOK_UTIL AS
2: /* $Header: OEXUBOKB.pls 120.9.12010000.2 2008/09/25 12:17:33 msundara ship $ */
3:
4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_ORDER_BOOK_UTIL';
6:
7:
8: /* LOCAL PROCEDURES */
9:

Line 625: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS IN OE_ORDER_BOOK_UTIL FOR LINE_ID '||L_LINE_TBL ( L_LOOP_INDEX ) .LINE_ID ||' IS: ' || L_RETURN_STATUS , 1 ) ;

621: , x_index => l_notify_index
622: , x_return_status => l_return_status);
623:
624: IF l_debug_level > 0 THEN
625: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS IN OE_ORDER_BOOK_UTIL FOR LINE_ID '||L_LINE_TBL ( L_LOOP_INDEX ) .LINE_ID ||' IS: ' || L_RETURN_STATUS , 1 ) ;
626: END IF;
627: IF l_debug_level > 0 THEN
628: oe_debug_pub.add( 'UPDATE_GLOBAL INDEX IN OE_ORDER_BOOK_UTIL FOR LINE_ID '||L_LINE_TBL ( L_LOOP_INDEX ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
629: END IF;

Line 628: oe_debug_pub.add( 'UPDATE_GLOBAL INDEX IN OE_ORDER_BOOK_UTIL FOR LINE_ID '||L_LINE_TBL ( L_LOOP_INDEX ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;

624: IF l_debug_level > 0 THEN
625: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS IN OE_ORDER_BOOK_UTIL FOR LINE_ID '||L_LINE_TBL ( L_LOOP_INDEX ) .LINE_ID ||' IS: ' || L_RETURN_STATUS , 1 ) ;
626: END IF;
627: IF l_debug_level > 0 THEN
628: oe_debug_pub.add( 'UPDATE_GLOBAL INDEX IN OE_ORDER_BOOK_UTIL FOR LINE_ID '||L_LINE_TBL ( L_LOOP_INDEX ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
629: END IF;
630:
631: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
632: RAISE FND_API.G_EXC_ERROR;

Line 843: oe_debug_pub.add('Entering Oe_Order_Book_Util.Validate_sales_Credits' ) ;

839: FROM oe_order_lines_all
840: WHERE header_id = p_header_id;
841: BEGIN
842: IF l_debug_level > 0 THEN
843: oe_debug_pub.add('Entering Oe_Order_Book_Util.Validate_sales_Credits' ) ;
844: END IF;
845:
846: h_return_status := FND_API.G_RET_STS_SUCCESS;
847: -- Validate Header Sales Credits

Line 925: oe_debug_pub.add('Exiting Oe_Order_Book_Util.Validate_sales_Credits: '||x_return_status ) ;

921: x_return_status := FND_API.G_RET_STS_SUCCESS;
922: END IF;
923:
924: IF l_debug_level > 0 THEN
925: oe_debug_pub.add('Exiting Oe_Order_Book_Util.Validate_sales_Credits: '||x_return_status ) ;
926: END IF;
927:
928: EXCEPTION
929: WHEN OTHERS THEN

Line 963: oe_debug_pub.add( 'ENTER OE_ORDER_BOOK_UTIL.CHECK_BOOKING_HOLDS' , 1 ) ;

959: --
960: BEGIN
961:
962: IF l_debug_level > 0 THEN
963: oe_debug_pub.add( 'ENTER OE_ORDER_BOOK_UTIL.CHECK_BOOKING_HOLDS' , 1 ) ;
964: END IF;
965:
966: -- Check if there are any generic or Booking holds
967:

Line 1037: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK_UTIL.CHECK_BOOKING_HOLDS' , 1 ) ;

1033: END IF;
1034: END IF;
1035: /* Changes for bug#2673236:End */
1036: IF l_debug_level > 0 THEN
1037: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK_UTIL.CHECK_BOOKING_HOLDS' , 1 ) ;
1038: END IF;
1039:
1040: EXCEPTION
1041: WHEN OTHERS THEN

Line 1776: OE_Order_Book_Util.Complete_Book_Eligible (

1772: , x_return_status => l_return_status
1773: , x_msg_count => l_msg_count
1774: , x_msg_data => l_msg_data );
1775: ELSE
1776: OE_Order_Book_Util.Complete_Book_Eligible (
1777: p_api_version_number => 1.0
1778: , p_init_msg_list => FND_API.G_FALSE
1779: , p_header_id => l_header_id
1780: , x_return_status => l_return_status

Line 2077: END OE_ORDER_BOOK_UTIL;

2073: --ABH
2074: ******************************************************************************/
2075:
2076:
2077: END OE_ORDER_BOOK_UTIL;