DBA Data[Home] [Help]

APPS.OE_REJECTED_LINES_ACK dependencies on OE_DEBUG_PUB

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

460: AND request_id = p_request_id
461: ;
462:
463: --
464: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
465: --
466: BEGIN
467: IF l_debug_level > 0 THEN
468: oe_debug_pub.add( 'BEFORE INITIALIZATION' ) ;

Line 468: oe_debug_pub.add( 'BEFORE INITIALIZATION' ) ;

464: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
465: --
466: BEGIN
467: IF l_debug_level > 0 THEN
468: oe_debug_pub.add( 'BEFORE INITIALIZATION' ) ;
469: END IF;
470:
471: l_line_rec := OE_Order_Pub.G_MISS_LINE_REC;
472: l_line_tbl := OE_Order_Pub.G_MISS_LINE_TBL;

Line 483: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;

479: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
480: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
481: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
482: IF l_debug_level > 0 THEN
483: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
484: END IF;
485: End If;
486:
487:

Line 494: oe_debug_pub.add( 'BEFORE LINES LOOP' ) ;

490: Lines
491: -----------------------------------------------------------
492: */
493: IF l_debug_level > 0 THEN
494: oe_debug_pub.add( 'BEFORE LINES LOOP' ) ;
495: END IF;
496:
497: OPEN l_line_cursor;
498: LOOP

Line 870: oe_debug_pub.add('origsysline_ref ('||l_line_count||'):'|| l_line_tbl(l_line_count).orig_sys_line_ref ) ;

866: l_orig_sys_line_ref := l_line_rec.orig_sys_line_ref;
867: l_orig_sys_shipment_ref := l_line_rec.orig_sys_shipment_ref;
868:
869: IF l_debug_level > 0 THEN
870: oe_debug_pub.add('origsysline_ref ('||l_line_count||'):'|| l_line_tbl(l_line_count).orig_sys_line_ref ) ;
871: oe_debug_pub.add('origsysshipment_ref ('||l_line_count||'):'|| l_line_tbl(l_line_count).orig_sys_shipment_ref ) ;
872: oe_debug_pub.add('val table Sold_To_Org ('||l_line_count||'):'|| l_line_val_tbl(l_line_count).sold_to_org) ;
873: END IF;
874:

Line 871: oe_debug_pub.add('origsysshipment_ref ('||l_line_count||'):'|| l_line_tbl(l_line_count).orig_sys_shipment_ref ) ;

867: l_orig_sys_shipment_ref := l_line_rec.orig_sys_shipment_ref;
868:
869: IF l_debug_level > 0 THEN
870: oe_debug_pub.add('origsysline_ref ('||l_line_count||'):'|| l_line_tbl(l_line_count).orig_sys_line_ref ) ;
871: oe_debug_pub.add('origsysshipment_ref ('||l_line_count||'):'|| l_line_tbl(l_line_count).orig_sys_shipment_ref ) ;
872: oe_debug_pub.add('val table Sold_To_Org ('||l_line_count||'):'|| l_line_val_tbl(l_line_count).sold_to_org) ;
873: END IF;
874:
875:

Line 872: oe_debug_pub.add('val table Sold_To_Org ('||l_line_count||'):'|| l_line_val_tbl(l_line_count).sold_to_org) ;

868:
869: IF l_debug_level > 0 THEN
870: oe_debug_pub.add('origsysline_ref ('||l_line_count||'):'|| l_line_tbl(l_line_count).orig_sys_line_ref ) ;
871: oe_debug_pub.add('origsysshipment_ref ('||l_line_count||'):'|| l_line_tbl(l_line_count).orig_sys_shipment_ref ) ;
872: oe_debug_pub.add('val table Sold_To_Org ('||l_line_count||'):'|| l_line_val_tbl(l_line_count).sold_to_org) ;
873: END IF;
874:
875:
876: /* -----------------------------------------------------------

Line 881: oe_debug_pub.add( 'BEFORE LINE LOT SERIALS LOOP' ) ;

877: Line Lot Serials
878: -----------------------------------------------------------
879: */
880: IF l_debug_level > 0 THEN
881: oe_debug_pub.add( 'BEFORE LINE LOT SERIALS LOOP' ) ;
882: END IF;
883:
884: l_lot_serial_count := 0;
885: OPEN l_lot_serial_cursor;

Line 920: oe_debug_pub.add( 'LINE LOT SERIAL REF ( '||L_LOT_SERIAL_COUNT||' ) : '|| L_LOT_SERIAL_TBL ( L_LOT_SERIAL_COUNT ) .LOT_NUMBER ) ;

916: l_lot_serial_count := l_lot_serial_count + 1;
917: l_lot_serial_tbl (l_lot_serial_count) := l_lot_serial_rec;
918:
919: IF l_debug_level > 0 THEN
920: oe_debug_pub.add( 'LINE LOT SERIAL REF ( '||L_LOT_SERIAL_COUNT||' ) : '|| L_LOT_SERIAL_TBL ( L_LOT_SERIAL_COUNT ) .LOT_NUMBER ) ;
921: END IF;
922:
923: END LOOP;
924: CLOSE l_lot_serial_cursor;

Line 930: oe_debug_pub.add( 'AFTER GETTING REJECTED RECORDS' ) ;

926: END LOOP; /* Lines cursor */
927: CLOSE l_line_cursor;
928:
929: IF l_debug_level > 0 THEN
930: oe_debug_pub.add( 'AFTER GETTING REJECTED RECORDS' ) ;
931: END IF;
932:
933: /* -----------------------------------------------------------
934: Return line and lot serial tables

Line 953: oe_debug_pub.add( 'ENCOUNTERED OTHERS ERROR EXCEPTION IN OE_REJECTED_LINES_ACK.GET_REJECTED_LINES: '||SQLERRM ) ;

949:
950: EXCEPTION
951: WHEN OTHERS THEN
952: IF l_debug_level > 0 THEN
953: oe_debug_pub.add( 'ENCOUNTERED OTHERS ERROR EXCEPTION IN OE_REJECTED_LINES_ACK.GET_REJECTED_LINES: '||SQLERRM ) ;
954: END IF;
955:
956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
957: