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.13.12020000.4 2013/04/09 08:02:50 spothula 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.13.12020000.4 2013/04/09 08:02:50 spothula 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 679: 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 ) ;

675: , x_index => l_notify_index
676: , x_return_status => l_return_status);
677:
678: IF l_debug_level > 0 THEN
679: 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 ) ;
680: END IF;
681: IF l_debug_level > 0 THEN
682: 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 ) ;
683: END IF;

Line 682: 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 ) ;

678: IF l_debug_level > 0 THEN
679: 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 ) ;
680: END IF;
681: IF l_debug_level > 0 THEN
682: 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 ) ;
683: END IF;
684:
685: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
686: RAISE FND_API.G_EXC_ERROR;

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

905: FROM oe_order_lines_all
906: WHERE header_id = p_header_id;
907: BEGIN
908: IF l_debug_level > 0 THEN
909: oe_debug_pub.add('Entering Oe_Order_Book_Util.Validate_sales_Credits' ) ;
910: END IF;
911:
912: h_return_status := FND_API.G_RET_STS_SUCCESS;
913: -- Validate Header Sales Credits

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

987: x_return_status := FND_API.G_RET_STS_SUCCESS;
988: END IF;
989:
990: IF l_debug_level > 0 THEN
991: oe_debug_pub.add('Exiting Oe_Order_Book_Util.Validate_sales_Credits: '||x_return_status ) ;
992: END IF;
993:
994: EXCEPTION
995: WHEN OTHERS THEN

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

1025: --
1026: BEGIN
1027:
1028: IF l_debug_level > 0 THEN
1029: oe_debug_pub.add( 'ENTER OE_ORDER_BOOK_UTIL.CHECK_BOOKING_HOLDS' , 1 ) ;
1030: END IF;
1031:
1032: -- Check if there are any generic or Booking holds
1033:

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

1099: END IF;
1100: END IF;
1101: /* Changes for bug#2673236:End */
1102: IF l_debug_level > 0 THEN
1103: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK_UTIL.CHECK_BOOKING_HOLDS' , 1 ) ;
1104: END IF;
1105:
1106: EXCEPTION
1107: WHEN OTHERS THEN

Line 1887: OE_Order_Book_Util.Complete_Book_Eligible (

1883: , x_return_status => l_return_status
1884: , x_msg_count => l_msg_count
1885: , x_msg_data => l_msg_data );
1886: ELSE
1887: OE_Order_Book_Util.Complete_Book_Eligible (
1888: p_api_version_number => 1.0
1889: , p_init_msg_list => FND_API.G_FALSE
1890: , p_header_id => l_header_id
1891: , x_return_status => l_return_status

Line 2188: END OE_ORDER_BOOK_UTIL;

2184: --ABH
2185: ******************************************************************************/
2186:
2187:
2188: END OE_ORDER_BOOK_UTIL;