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' ) ;
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;
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:
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
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:
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:
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: /* -----------------------------------------------------------
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;
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;
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
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: