DBA Data[Home] [Help]

APPS.OE_RMA_RECEIVING dependencies on OE_RMA_RECEIVING

Line 1: Package body OE_RMA_RECEIVING As

1: Package body OE_RMA_RECEIVING As
2: /* $Header: OEXRMARB.pls 120.10.12020000.4 2013/04/01 15:52:22 srpasuma ship $ */
3:
4: -- Push_Receiving_Info is an OM procedure that is called by Oracle Purchasing
5: -- to push receiving information to Oracle Order Management.

Line 118: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_RMA_RECEIVING';

114: END IF;
115:
116: */
117:
118: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_RMA_RECEIVING';
119:
120: Procedure Push_Receiving_Info(
121: p_RMA_Line_ID IN NUMBER,
122: p_Quantity IN NUMBER,

Line 199: p_parent_transaction_type = OE_RMA_RECEIVING.G_RMA_NO_PARENT) AND

195: END IF;
196:
197: -- Return success if there is no parent and unordered receipt
198: IF (p_parent_transaction_type is NULL OR
199: p_parent_transaction_type = OE_RMA_RECEIVING.G_RMA_NO_PARENT) AND
200: (p_transaction_type = OE_RMA_RECEIVING.G_RMA_UNMATCHED_ORDER) THEN
201: IF l_debug_level > 0 THEN
202: oe_debug_pub.add( 'PARENT IS NULL OR NO PARENT , TRX TYPE IS UNORDERED' ) ;
203: END IF;

Line 200: (p_transaction_type = OE_RMA_RECEIVING.G_RMA_UNMATCHED_ORDER) THEN

196:
197: -- Return success if there is no parent and unordered receipt
198: IF (p_parent_transaction_type is NULL OR
199: p_parent_transaction_type = OE_RMA_RECEIVING.G_RMA_NO_PARENT) AND
200: (p_transaction_type = OE_RMA_RECEIVING.G_RMA_UNMATCHED_ORDER) THEN
201: IF l_debug_level > 0 THEN
202: oe_debug_pub.add( 'PARENT IS NULL OR NO PARENT , TRX TYPE IS UNORDERED' ) ;
203: END IF;
204: return;

Line 213: oe_debug_pub.add( 'ENTERING OE_RMA_RECEIVING.PUSH_RECEIVING_INFO' , 1 ) ;

209:
210: -- This if statement is to allow debug generation by setting the profile option
211:
212: IF l_debug_level > 0 THEN
213: oe_debug_pub.add( 'ENTERING OE_RMA_RECEIVING.PUSH_RECEIVING_INFO' , 1 ) ;
214: END IF;
215: IF l_debug_level > 0 THEN
216: oe_debug_pub.add( 'RMA_LINE_ID: ' || P_RMA_LINE_ID , 1 ) ;
217: END IF;

Line 319: p_parent_transaction_type = OE_RMA_RECEIVING.G_RMA_NO_PARENT) THEN

315: --Ending of changes in bug 12798879
316: -- Fix for Bug #1140815. Receiving module passes us the string 'NO PARENT'
317: -- when receiving goods for the first time
318: IF (p_parent_transaction_type is NULL OR
319: p_parent_transaction_type = OE_RMA_RECEIVING.G_RMA_NO_PARENT) THEN
320: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_RECEIVE) THEN
321: IF l_debug_level > 0 THEN
322: oe_debug_pub.add( 'PARENT IS NULL , TRX TYPE IS RECEIVE' ) ;
323: END IF;

Line 320: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_RECEIVE) THEN

316: -- Fix for Bug #1140815. Receiving module passes us the string 'NO PARENT'
317: -- when receiving goods for the first time
318: IF (p_parent_transaction_type is NULL OR
319: p_parent_transaction_type = OE_RMA_RECEIVING.G_RMA_NO_PARENT) THEN
320: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_RECEIVE) THEN
321: IF l_debug_level > 0 THEN
322: oe_debug_pub.add( 'PARENT IS NULL , TRX TYPE IS RECEIVE' ) ;
323: END IF;
324:

Line 425: ELSIF (p_parent_transaction_type = OE_RMA_RECEIVING.G_RMA_RECEIVE OR

421: END IF;
422:
423: END IF;
424:
425: ELSIF (p_parent_transaction_type = OE_RMA_RECEIVING.G_RMA_RECEIVE OR
426: p_parent_transaction_type = OE_RMA_RECEIVING.G_RMA_MATCH) THEN
427: IF (p_transaction_type = G_RMA_DELIVER) THEN
428:
429: IF l_debug_level > 0 THEN

Line 426: p_parent_transaction_type = OE_RMA_RECEIVING.G_RMA_MATCH) THEN

422:
423: END IF;
424:
425: ELSIF (p_parent_transaction_type = OE_RMA_RECEIVING.G_RMA_RECEIVE OR
426: p_parent_transaction_type = OE_RMA_RECEIVING.G_RMA_MATCH) THEN
427: IF (p_transaction_type = G_RMA_DELIVER) THEN
428:
429: IF l_debug_level > 0 THEN
430: oe_debug_pub.add( 'PARENT IS RECEIVE , TRX TYPE IS ACCEPT/REJECT/DELIVER' ) ;

Line 468: ELSIF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_RETURN_TO_CUSTOMER) THEN

464: IF (l_line_tbl(1).shipped_quantity = l_updated_quantity) THEN
465: b_complete_inspection := TRUE;
466: END IF;
467:
468: ELSIF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_RETURN_TO_CUSTOMER) THEN
469: IF l_debug_level > 0 THEN
470: oe_debug_pub.add( 'PARENT IS RECEIVE , TRX TYPE IS RETURN TO CUSTOMER' ) ;
471: END IF;
472:

Line 498: ELSIF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_CORRECT) THEN

494: b_complete_inspection := TRUE;
495: END IF;
496:
497:
498: ELSIF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_CORRECT) THEN
499: IF l_debug_level > 0 THEN
500: oe_debug_pub.add( 'PARENT IS RECEIVE , TRX TYPE IS CORRECT' ) ;
501: END IF;
502:

Line 832: ELSIF (p_parent_transaction_type = OE_RMA_RECEIVING.G_RMA_DELIVER) THEN

828: END IF;
829: --Changes ended for fix 13872015
830: END IF;
831: END IF;
832: ELSIF (p_parent_transaction_type = OE_RMA_RECEIVING.G_RMA_DELIVER) THEN
833:
834: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_RETURN_TO_CUSTOMER) THEN
835: IF l_debug_level > 0 THEN
836: oe_debug_pub.add( 'PARENT IS DELIVER , TRX TYPE IS RETURN TO CUSTOMER' ) ;

Line 834: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_RETURN_TO_CUSTOMER) THEN

830: END IF;
831: END IF;
832: ELSIF (p_parent_transaction_type = OE_RMA_RECEIVING.G_RMA_DELIVER) THEN
833:
834: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_RETURN_TO_CUSTOMER) THEN
835: IF l_debug_level > 0 THEN
836: oe_debug_pub.add( 'PARENT IS DELIVER , TRX TYPE IS RETURN TO CUSTOMER' ) ;
837: END IF;
838:

Line 856: ELSIF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_RETURN_TO_RECEIVING) THEN

852: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
853: l_control_rec.check_security := FALSE;
854:
855:
856: ELSIF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_RETURN_TO_RECEIVING) THEN
857: IF l_debug_level > 0 THEN
858: oe_debug_pub.add( 'PARENT IS DELIVER , TRX TYPE IS RETURN TO CUSTOMER' ) ;
859: END IF;
860:

Line 874: ELSIF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_CORRECT) THEN

870: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
871: l_control_rec.check_security := FALSE;
872:
873:
874: ELSIF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_CORRECT) THEN
875: IF l_debug_level > 0 THEN
876: oe_debug_pub.add( 'PARENT IS DELIVER , TRX TYPE IS RETURN TO CUSTOMER' ) ;
877: END IF;
878:

Line 896: OE_RMA_RECEIVING.G_RMA_RETURN_TO_CUSTOMER) THEN

892:
893: END IF;
894:
895: ELSIF (p_parent_transaction_type =
896: OE_RMA_RECEIVING.G_RMA_RETURN_TO_CUSTOMER) THEN
897:
898: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_CORRECT) THEN
899: IF l_debug_level > 0 THEN
900: oe_debug_pub.add( 'PARENT IS RETURN TO CUST , TRX TYPE IS CORRECT' ) ;

Line 898: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_CORRECT) THEN

894:
895: ELSIF (p_parent_transaction_type =
896: OE_RMA_RECEIVING.G_RMA_RETURN_TO_CUSTOMER) THEN
897:
898: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_CORRECT) THEN
899: IF l_debug_level > 0 THEN
900: oe_debug_pub.add( 'PARENT IS RETURN TO CUST , TRX TYPE IS CORRECT' ) ;
901: END IF;
902:

Line 948: OE_RMA_RECEIVING.G_RMA_RETURN_TO_RECEIVING) THEN

944:
945: END IF;
946:
947: ELSIF (p_parent_transaction_type =
948: OE_RMA_RECEIVING.G_RMA_RETURN_TO_RECEIVING) THEN
949:
950: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_CORRECT) THEN
951: IF l_debug_level > 0 THEN
952: oe_debug_pub.add( 'PARENT IS RETURN TO RECEIVING , TRX TYPE IS CORRECT' ) ;

Line 950: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_CORRECT) THEN

946:
947: ELSIF (p_parent_transaction_type =
948: OE_RMA_RECEIVING.G_RMA_RETURN_TO_RECEIVING) THEN
949:
950: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_CORRECT) THEN
951: IF l_debug_level > 0 THEN
952: oe_debug_pub.add( 'PARENT IS RETURN TO RECEIVING , TRX TYPE IS CORRECT' ) ;
953: END IF;
954:

Line 969: OE_RMA_RECEIVING.G_RMA_UNMATCHED_ORDER) THEN

965:
966: END IF;
967:
968: ELSIF (p_parent_transaction_type =
969: OE_RMA_RECEIVING.G_RMA_UNMATCHED_ORDER) THEN
970:
971: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_MATCH) THEN
972: IF l_debug_level > 0 THEN
973: oe_debug_pub.add( 'PARENT IS UNMATCHED ORDER , TRX TYPE IS MATCH ' ) ;

Line 971: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_MATCH) THEN

967:
968: ELSIF (p_parent_transaction_type =
969: OE_RMA_RECEIVING.G_RMA_UNMATCHED_ORDER) THEN
970:
971: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_MATCH) THEN
972: IF l_debug_level > 0 THEN
973: oe_debug_pub.add( 'PARENT IS UNMATCHED ORDER , TRX TYPE IS MATCH ' ) ;
974: END IF;
975:

Line 1489: END OE_RMA_RECEIVING;

1485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1486:
1487: END Get_RMA_Tolerances;
1488:
1489: END OE_RMA_RECEIVING;