eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_INVOICE_PUB dependencies on OE_GLOBALS

Line 843: -- IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

839: IF l_debug_level > 0 THEN
840: oe_debug_pub.add( 'ENTER CHECK_INVOICING_HOLDS ' , 5 ) ;
841: END IF;
842: -- Check for Generic and invoice activity specific holds
843: -- IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
844: OE_HOLDS_PUB.CHECK_HOLDS(p_api_version => 1.0,
845: p_line_id => p_line_rec.line_id,
846: p_wf_item => OE_GLOBALS.G_WFI_LIN,
847: p_wf_activity => 'INVOICE_INTERFACE',

Line 846: p_wf_item => OE_GLOBALS.G_WFI_LIN,

842: -- Check for Generic and invoice activity specific holds
843: -- IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
844: OE_HOLDS_PUB.CHECK_HOLDS(p_api_version => 1.0,
845: p_line_id => p_line_rec.line_id,
846: p_wf_item => OE_GLOBALS.G_WFI_LIN,
847: p_wf_activity => 'INVOICE_INTERFACE',
848: x_result_out => l_hold_result_out,
849: x_return_status => l_hold_return_status,
850: x_msg_count => l_hold_msg_count,

Line 868: p_wf_item => OE_GLOBALS.G_WFI_HDR,

864: END IF;
865: -- ELSIF p_itemtype = 'OEOH' THEN
866: OE_HOLDS_PUB.CHECK_HOLDS(p_api_version => 1.0,
867: p_line_id => p_line_rec.line_id,
868: p_wf_item => OE_GLOBALS.G_WFI_HDR,
869: p_wf_activity => 'HEADER_INVOICE_INTERFACE',
870: x_result_out => l_hold_result_out,
871: x_return_status => l_hold_return_status,
872: x_msg_count => l_hold_msg_count,

Line 7766: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN

7762: IF l_debug_level > 0 THEN
7763: oe_debug_pub.add( 'UPDATING INVOICE ATTRIBUTES' , 5 ) ;
7764: oe_debug_pub.add( 'STATUS= '||p_invoice_interface_status);
7765: END IF;
7766: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
7767: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
7768: END IF;
7769: l_invoiced_quantity := nvl(p_line_rec.invoiced_quantity, 0) + nvl(p_interface_line_rec.quantity, 0);
7770: --Bug2361642.Added a check for lines in "MANUAL-PENDING" status too.

Line 7767: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);

7763: oe_debug_pub.add( 'UPDATING INVOICE ATTRIBUTES' , 5 ) ;
7764: oe_debug_pub.add( 'STATUS= '||p_invoice_interface_status);
7765: END IF;
7766: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
7767: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
7768: END IF;
7769: l_invoiced_quantity := nvl(p_line_rec.invoiced_quantity, 0) + nvl(p_interface_line_rec.quantity, 0);
7770: --Bug2361642.Added a check for lines in "MANUAL-PENDING" status too.
7771: IF (p_invoice_interface_status = 'RFR-PENDING' OR

Line 7905: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR

7901: END IF;
7902: END IF;--End if of line level l_trxn_extension_id check
7903: END IF;-- cc reversal ER flag check
7904: --CC Reversal ER#16014135 end
7905: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
7906: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') ) THEN
7907:
7908: l_Line_tbl(1) := p_line_rec;
7909: l_Old_Line_tbl(1) := p_line_rec;

Line 8079: p_item_type => OE_GLOBALS.G_WFI_HDR

8075: INTO l_header_id
8076: FROM oe_order_lines
8077: WHERE line_id = p_line_id;
8078: RETURN( WF_ENGINE.Activity_Exist_In_Process(
8079: p_item_type => OE_GLOBALS.G_WFI_HDR
8080: ,p_item_key => to_char(l_header_id)
8081: ,p_activity_name => 'HEADER_INVOICE_INTERFACE'));
8082: END Header_Activity;
8083:

Line 8099: p_item_type => OE_GLOBALS.G_WFI_LIN

8095: -- WF team removed this function at one stage and now provided the same
8096: -- for backward compatibility purpose with bug# 1869241.
8097: -- Issue with invoice interface due the the missing wf function is reported in bug# 1868026.
8098: RETURN( WF_ENGINE.Activity_Exist_In_Process(
8099: p_item_type => OE_GLOBALS.G_WFI_LIN
8100: ,p_item_key => to_char(p_line_id)
8101: ,p_activity_name => 'INVOICE_INTERFACE'));
8102: END Line_Activity;
8103:

Line 8441: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;

8437: END IF;
8438: IF l_freight_count >0 then
8439: Check_Invoicing_Holds(p_line_rec, g_itemtype, x_return_status);
8440: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8441: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
8442: RAISE FND_API.G_EXC_ERROR;
8443: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8444: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8444: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8440: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8441: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
8442: RAISE FND_API.G_EXC_ERROR;
8443: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8444: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8446: END IF;
8447: END IF; */
8448: /* Bug#2666125 end-check freight records and holds for non invoiceable items*/

Line 8464: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8460: --,'NOT_ELIGIBLE' --sol_ord_er #16014165
8461: ,l_inv_stat --sol_ord_er #16014165
8462: ,x_return_status);
8463: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8464: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8465: RAISE FND_API.G_EXC_ERROR;
8466: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8467: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8467: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8463: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8464: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8465: RAISE FND_API.G_EXC_ERROR;
8466: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8467: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8469: END IF;
8470: --- Eventhough line is not eligible for invoicing, there might be some other
8471: --- lines that are waiting for this line to trigger their invoicing activity.

Line 8501: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8497: IF l_debug_level > 0 THEN
8498: oe_debug_pub.add( 'INTERFACING PENDING LINE ID ' || L_PENDING_LINE_REC.LINE_ID , 5 ) ;
8499: END IF;
8500: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8501: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8502: RAISE FND_API.G_EXC_ERROR;
8503: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8504: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8504: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8500: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8501: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8502: RAISE FND_API.G_EXC_ERROR;
8503: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8504: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8506: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8507: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN
8508: IF l_debug_level > 0 THEN

Line 8507: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN

8503: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8504: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8506: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8507: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN
8508: IF l_debug_level > 0 THEN
8509: oe_debug_pub.add( 'RFR PENDING LINE PARTIALLY INTERFACED' , 5 ) ;
8510: END IF;
8511: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN

Line 8511: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN

8507: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN
8508: IF l_debug_level > 0 THEN
8509: oe_debug_pub.add( 'RFR PENDING LINE PARTIALLY INTERFACED' , 5 ) ;
8510: END IF;
8511: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN
8512: IF l_debug_level > 0 THEN
8513: oe_debug_pub.add( 'RFR-PENDING LINE INTERFACED SUCCESSFULLY' , 5 ) ;
8514: END IF;
8515: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');

Line 8515: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');

8511: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN
8512: IF l_debug_level > 0 THEN
8513: oe_debug_pub.add( 'RFR-PENDING LINE INTERFACED SUCCESSFULLY' , 5 ) ;
8514: END IF;
8515: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');
8516: END IF;
8517: END IF;
8518: END IF;
8519: END LOOP;

Line 8586: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8582: IF l_debug_level > 0 THEN
8583: oe_debug_pub.add( 'VALIDATING REQUIRED ATTRIBUTES' , 5 ) ;
8584: END IF;
8585: IF NOT Validate_Required_Attributes(p_line_rec, p_x_interface_line_rec) THEN
8586: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8587: RAISE FND_API.G_EXC_ERROR;
8588: END IF;
8589: IF l_debug_level > 0 THEN
8590: oe_debug_pub.add( 'INTERFACING FREIGHT CHARGES' , 5 ) ;

Line 8601: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8597: /* END Enhancement Request# 1915736 */
8598: END IF; -- for Non-rejected_lines Customer Acceptance
8599:
8600: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8601: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8602: RAISE FND_API.G_EXC_ERROR;
8603: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8604: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8604: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8600: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8601: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8602: RAISE FND_API.G_EXC_ERROR;
8603: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8604: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8606: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8607: -- sol_ord_er #16014165
8608: If l_inv_stat = OE_GLOBALS.G_CONTRACTS_BILLED then

Line 8608: If l_inv_stat = OE_GLOBALS.G_CONTRACTS_BILLED then

8604: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8606: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8607: -- sol_ord_er #16014165
8608: If l_inv_stat = OE_GLOBALS.G_CONTRACTS_BILLED then
8609: x_result_out := OE_GLOBALS.G_CONTRACTS_BILLED;
8610: else
8611: -- sol_ord_er #16014165 end
8612: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;

Line 8609: x_result_out := OE_GLOBALS.G_CONTRACTS_BILLED;

8605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8606: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8607: -- sol_ord_er #16014165
8608: If l_inv_stat = OE_GLOBALS.G_CONTRACTS_BILLED then
8609: x_result_out := OE_GLOBALS.G_CONTRACTS_BILLED;
8610: else
8611: -- sol_ord_er #16014165 end
8612: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;
8613: end if; --sol_ord_er #16014165

Line 8612: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;

8608: If l_inv_stat = OE_GLOBALS.G_CONTRACTS_BILLED then
8609: x_result_out := OE_GLOBALS.G_CONTRACTS_BILLED;
8610: else
8611: -- sol_ord_er #16014165 end
8612: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;
8613: end if; --sol_ord_er #16014165
8614: IF l_debug_level > 0 THEN
8615: oe_debug_pub.add( 'RETURN AFTER INVOICEABLE ELIGIBLE CHECK' , 1 ) ;
8616: END IF;

Line 8657: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8653: IF l_debug_level > 0 THEN
8654: oe_debug_pub.add( 'REQUEST_ID AFTER INSERTING '||P_X_INTERFACE_LINE_REC.REQUEST_ID , 5 ) ;
8655: END IF;
8656: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8657: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8658: RAISE FND_API.G_EXC_ERROR;
8659: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8660: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8660: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8656: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8657: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8658: RAISE FND_API.G_EXC_ERROR;
8659: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8660: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8662: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8663: IF l_result_code = 'RFR-PENDING' THEN
8664: x_result_out := OE_GLOBALS.G_WFR_PRTL_COMPLETE;

Line 8664: x_result_out := OE_GLOBALS.G_WFR_PRTL_COMPLETE;

8660: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8662: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8663: IF l_result_code = 'RFR-PENDING' THEN
8664: x_result_out := OE_GLOBALS.G_WFR_PRTL_COMPLETE;
8665: IF l_debug_level > 0 THEN
8666: oe_debug_pub.add( 'LINE ID '||TO_CHAR ( P_LINE_REC.LINE_ID ) ||' PARTIALLY INTERFACED SUCCESSFULLY ' || 'X_RESULT_OUT: '||X_RESULT_OUT ||' L_RESULT_CODE '||L_RESULT_CODE ) ;
8667: END IF;
8668: IF l_debug_level > 0 THEN

Line 8683: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8679: IF l_debug_level > 0 THEN
8680: oe_debug_pub.add( 'VALIDATE REQUIRED ATTRIBUTES' , 5 ) ;
8681: END IF;
8682: IF NOT Validate_Required_Attributes(p_line_rec, p_x_interface_line_rec) THEN
8683: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8684: RAISE FND_API.G_EXC_ERROR;
8685: END IF;
8686: IF l_debug_level > 0 THEN
8687: oe_debug_pub.add( 'INSERTING LINE INTO RA_INTERFACE_LINES' , 5 ) ;

Line 8693: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8689: Insert_Line(p_x_interface_line_rec
8690: ,x_return_status=>l_return_status);
8691: -- Fix for the bug 2187074
8692: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8693: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8695: END IF;
8696:
8697: -- 3685479 Replacing show detail dis by the following IF

Line 8708: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8704: Interface_Detail_Discounts(p_line_rec, p_x_interface_line_rec
8705: ,x_return_status);
8706: -- Fix for the bug 2187074
8707: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8708: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8710: END IF;
8711: END IF;
8712: IF l_debug_level > 0 THEN

Line 8721: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8717: Interface_Freight_Charges(p_line_rec
8718: , p_x_interface_line_rec
8719: , x_return_status);
8720: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8721: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8722: RAISE FND_API.G_EXC_ERROR;
8723: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8724: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8724: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8720: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8721: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8722: RAISE FND_API.G_EXC_ERROR;
8723: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8724: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8726: END IF;
8727: --sol_ord_er #16014165 start
8728: Else

Line 8741: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8737: Interface_Salescredits(p_line_rec
8738: ,p_x_interface_line_rec
8739: ,x_return_status);
8740: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8741: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8742: RAISE FND_API.G_EXC_ERROR;
8743: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8744: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8744: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8740: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8741: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8742: RAISE FND_API.G_EXC_ERROR;
8743: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8744: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8746: END IF;
8747:
8748: --Customer Acceptance

Line 8785: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8781: IF l_debug_level > 0 THEN
8782: oe_debug_pub.add( 'REQUEST_ID AFTER INSERTING '||P_X_INTERFACE_LINE_REC.REQUEST_ID ) ;
8783: END IF;
8784: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8785: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8786: RAISE FND_API.G_EXC_ERROR;
8787: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8788: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8788: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8784: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8785: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8786: RAISE FND_API.G_EXC_ERROR;
8787: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8788: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8790: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8791: IF l_result_code = 'RFR-PENDING' THEN
8792: x_result_out := OE_GLOBALS.G_WFR_PRTL_COMPLETE;

Line 8792: x_result_out := OE_GLOBALS.G_WFR_PRTL_COMPLETE;

8788: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8790: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8791: IF l_result_code = 'RFR-PENDING' THEN
8792: x_result_out := OE_GLOBALS.G_WFR_PRTL_COMPLETE;
8793: IF l_debug_level > 0 THEN
8794: oe_debug_pub.add( 'LINE ID '||TO_CHAR ( P_LINE_REC.LINE_ID ) ||' PARTIALLY INTERFACED SUCCESSFULLY' , 1 ) ;
8795: END IF;
8796: ELSE

Line 8797: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;

8793: IF l_debug_level > 0 THEN
8794: oe_debug_pub.add( 'LINE ID '||TO_CHAR ( P_LINE_REC.LINE_ID ) ||' PARTIALLY INTERFACED SUCCESSFULLY' , 1 ) ;
8795: END IF;
8796: ELSE
8797: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;
8798: IF l_debug_level > 0 THEN
8799: oe_debug_pub.add( 'LINE ID '||TO_CHAR ( P_LINE_REC.LINE_ID ) ||' INTERFACED SUCCESSFULLY' , 1 ) ;
8800: END IF;
8801: END IF;

Line 8935: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

8931: oe_debug_pub.add( 'ENTERING INTERFACE_LINE ( ) PROCEDURE' , 1 ) ;
8932: oe_debug_pub.add( 'LINE ID : '|| P_LINE_ID , 5 ) ;
8933: oe_debug_pub.add( 'ITEM TYPE : '||P_ITEMTYPE , 5 ) ;
8934: END IF;
8935: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
8936: SAVEPOINT INVOICE_INTERFACE;
8937: END IF;
8938:
8939: --bug 5336623 Commented the following call to OE_MSG_PUB.set_msg_context

Line 8971: IF p_itemtype = OE_GLOBALS.G_WFI_HDR THEN

8967: END IF; */
8968:
8969: --bug 5336623 Moved the following call to OE_Header_Util.Query_row after the line is locked
8970: --OE_Header_Util.Query_row(p_header_id=>l_line_rec.header_id,x_header_rec=>l_header_rec);
8971: IF p_itemtype = OE_GLOBALS.G_WFI_HDR THEN
8972: p_header_id := l_line_rec.header_id;
8973: END IF;
8974: -- Set message context
8975: OE_MSG_PUB.set_msg_context(

Line 9022: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

9018: oe_debug_pub.add(' SQLERRM = '|| SQLERRM );
9019: oe_debug_pub.add( ' Unable to LOCK this Line. Going to make it DEFERRED so that it can be picked by another WFBP ');
9020: END IF;
9021:
9022: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
9023: ROLLBACK TO INVOICE_INTERFACE;
9024: END IF;
9025: x_result_out := NULL;
9026: x_return_status := 'DEFERRED';

Line 9052: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;

9048:
9049:
9050: ---Bug 8683948 : Start
9051: if l_line_rec.source_document_type_id = 10 THEN
9052: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;
9053: x_return_status := FND_API.G_RET_STS_SUCCESS ;
9054: IF l_debug_level > 0 THEN
9055: oe_debug_pub.add( ' This is Internal Sales Order line... not doing anything for ISO flow.' , 1 ) ;
9056: END IF;

Line 9067: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9063:
9064: oe_debug_pub.add( ' x_return_status after Update_Invoice_Attributes() : '|| x_return_status , 5 ) ;
9065:
9066: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9067: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9068: RAISE FND_API.G_EXC_ERROR;
9069: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9070: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9070: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9066: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9067: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9068: RAISE FND_API.G_EXC_ERROR;
9069: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9070: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9072: END IF;
9073: END;
9074: oe_debug_pub.add( ' before returning ...',5);

Line 9165: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9161: End If;
9162: -- sol_ord_er #16014165 end
9163:
9164: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9165: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9166: RAISE FND_API.G_EXC_ERROR;
9167: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9168: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9168: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9164: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9165: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9166: RAISE FND_API.G_EXC_ERROR;
9167: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9168: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9170: END IF;
9171: --13724397 End
9172: END IF;

Line 9205: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9201: END IF;
9202: ELSE
9203: Update_Invoice_Attributes(l_line_rec ,l_interface_line_rec ,'ACCEPTANCE-PENDING' ,x_return_status);
9204: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9205: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9206: RAISE FND_API.G_EXC_ERROR;
9207: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9208: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9208: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9204: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9205: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9206: RAISE FND_API.G_EXC_ERROR;
9207: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9208: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9210: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9211: x_result_out := OE_GLOBALS.G_WFR_PENDING_ACCEPTANCE; -- this is pending for Acceptance
9212: RETURN;

Line 9211: x_result_out := OE_GLOBALS.G_WFR_PENDING_ACCEPTANCE; -- this is pending for Acceptance

9207: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9208: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9210: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9211: x_result_out := OE_GLOBALS.G_WFR_PENDING_ACCEPTANCE; -- this is pending for Acceptance
9212: RETURN;
9213: END IF;
9214: END IF;
9215: END IF;

Line 9272: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;

9268: END IF;
9269: IF l_freight_count >0 then
9270: Check_Invoicing_Holds(l_line_rec, p_itemtype, x_return_status);
9271: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9272: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
9273: RAISE FND_API.G_EXC_ERROR;
9274: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9275: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9275: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9271: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9272: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
9273: RAISE FND_API.G_EXC_ERROR;
9274: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9275: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9277: END IF;
9278: END IF;
9279: END IF; -- noninvoiceable line

Line 9298: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9294: --,'NOT_ELIGIBLE' --sol_ord_er #16014165
9295: ,l_inv_stat --sol_ord_er #16014165
9296: ,x_return_status);
9297: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9298: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9299: RAISE FND_API.G_EXC_ERROR;
9300: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9301: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9301: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9297: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9298: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9299: RAISE FND_API.G_EXC_ERROR;
9300: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9301: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9303: END IF;
9304: --- Eventhough line is not eligible for invoicing, there might be some other
9305: --- lines that are waiting for this line to trigger their invoicing activity.

Line 9335: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9331: IF l_debug_level > 0 THEN
9332: oe_debug_pub.add( 'INTERFACING PENDING LINE ID ' || L_PENDING_LINE_REC.LINE_ID , 5 ) ;
9333: END IF;
9334: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9335: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9336: RAISE FND_API.G_EXC_ERROR;
9337: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9338: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9338: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9334: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9335: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9336: RAISE FND_API.G_EXC_ERROR;
9337: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9338: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9340: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9341: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN
9342: IF l_debug_level > 0 THEN

Line 9341: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN

9337: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9338: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9340: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9341: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN
9342: IF l_debug_level > 0 THEN
9343: oe_debug_pub.add( 'RFR PENDING LINE PARTIALLY INTERFACED' , 5 ) ;
9344: END IF;
9345: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN

Line 9345: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN

9341: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN
9342: IF l_debug_level > 0 THEN
9343: oe_debug_pub.add( 'RFR PENDING LINE PARTIALLY INTERFACED' , 5 ) ;
9344: END IF;
9345: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN
9346: IF l_debug_level > 0 THEN
9347: oe_debug_pub.add( 'RFR-PENDING LINE INTERFACED SUCCESSFULLY' , 5 ) ;
9348: END IF;
9349: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');

Line 9349: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');

9345: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN
9346: IF l_debug_level > 0 THEN
9347: oe_debug_pub.add( 'RFR-PENDING LINE INTERFACED SUCCESSFULLY' , 5 ) ;
9348: END IF;
9349: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');
9350: END IF;
9351: END IF;
9352: END IF;
9353: END LOOP;

Line 9417: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9413: IF l_debug_level > 0 THEN
9414: oe_debug_pub.add( 'VALIDATING REQUIRED ATTRIBUTES' , 5 ) ;
9415: END IF;
9416: IF NOT Validate_Required_Attributes(l_line_rec, l_interface_line_rec) THEN
9417: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9418: RAISE FND_API.G_EXC_ERROR;
9419: END IF;
9420: IF l_debug_level > 0 THEN
9421: oe_debug_pub.add( 'INTERFACING FREIGHT CHARGES' , 5 ) ;

Line 9431: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9427: END IF; -- for freight
9428: /* END Enhancement Request# 1915736 */
9429: END IF; -- for Non-rejected_lines Customer Acceptance
9430: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9431: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9432: RAISE FND_API.G_EXC_ERROR;
9433: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9434: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9434: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9430: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9431: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9432: RAISE FND_API.G_EXC_ERROR;
9433: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9434: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9436: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9437: -- sol_ord_er #16014165
9438: If l_inv_stat = OE_GLOBALS.G_CONTRACTS_BILLED then

Line 9438: If l_inv_stat = OE_GLOBALS.G_CONTRACTS_BILLED then

9434: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9436: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9437: -- sol_ord_er #16014165
9438: If l_inv_stat = OE_GLOBALS.G_CONTRACTS_BILLED then
9439: x_result_out := OE_GLOBALS.G_CONTRACTS_BILLED;
9440: else
9441: -- sol_ord_er #16014165 end
9442: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;

Line 9439: x_result_out := OE_GLOBALS.G_CONTRACTS_BILLED;

9435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9436: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9437: -- sol_ord_er #16014165
9438: If l_inv_stat = OE_GLOBALS.G_CONTRACTS_BILLED then
9439: x_result_out := OE_GLOBALS.G_CONTRACTS_BILLED;
9440: else
9441: -- sol_ord_er #16014165 end
9442: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;
9443: end if; --sol_ord_er #16014165

Line 9442: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;

9438: If l_inv_stat = OE_GLOBALS.G_CONTRACTS_BILLED then
9439: x_result_out := OE_GLOBALS.G_CONTRACTS_BILLED;
9440: else
9441: -- sol_ord_er #16014165 end
9442: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;
9443: end if; --sol_ord_er #16014165
9444: IF l_debug_level > 0 THEN
9445: oe_debug_pub.add( 'RETURN AFTER INVOICEABLE ELIGIBLE CHECK' , 1 ) ;
9446: END IF;

Line 9460: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;

9456: END IF; -- non-invoiceable lines check
9457:
9458: Check_Invoicing_Holds(l_line_rec, p_itemtype, x_return_status);
9459: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9460: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
9461: RAISE FND_API.G_EXC_ERROR;
9462: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9463: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9463: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9459: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9460: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
9461: RAISE FND_API.G_EXC_ERROR;
9462: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9463: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9465: END IF;
9466: IF FND_PROFILE.VALUE('WSH_INVOICE_NUMBERING_METHOD') = 'D' THEN
9467: IF l_debug_level > 0 THEN

Line 9620: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

9616: IF del_line_ready_flag = 'N' THEN -- atleast one line in delivery is not ready to interface
9617: IF l_debug_level > 0 THEN
9618: oe_debug_pub.add( 'SOME OF THE LINES IN THE DELIVERY ARE NOT READY' , 5 ) ;
9619: END IF;
9620: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
9621: IF l_debug_level > 0 THEN
9622: oe_debug_pub.add( 'LINE LEVEL INVOICING-SET STATUS TO PENDING' , 5 ) ;
9623: END IF;
9624: Update_Invoice_Attributes(l_line_rec

Line 9644: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9640: oe_debug_pub.add( 'INTERFACE STATUS : '||L_LINE_REC.INVOICE_INTERFACE_STATUS_CODE , 5 ) ;
9641: oe_debug_pub.add( 'X_RETURN_STATUS : '||X_RETURN_STATUS , 5 ) ;
9642: END IF;
9643: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9644: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9645: RAISE FND_API.G_EXC_ERROR;
9646: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9647: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9647: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9643: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9644: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9645: RAISE FND_API.G_EXC_ERROR;
9646: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9647: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9649: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9650: x_result_out := OE_GLOBALS.G_WFR_PRTL_COMPLETE; -- this actually is pending, we call it partial for WF
9651: RETURN;

Line 9650: x_result_out := OE_GLOBALS.G_WFR_PRTL_COMPLETE; -- this actually is pending, we call it partial for WF

9646: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9647: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9649: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9650: x_result_out := OE_GLOBALS.G_WFR_PRTL_COMPLETE; -- this actually is pending, we call it partial for WF
9651: RETURN;
9652: END IF;
9653: ELSE -- header level invoice, all delivery lines are not ready to invoice. do not honor delivery.
9654: IF l_debug_level > 0 THEN

Line 9742: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

9738: END IF;
9739: END IF;
9740: -- Bug2181628 Only now Process the line.
9741: IF ((l_line_id = p_line_id) OR (l_line_delivery_id = l_delivery_line_id)) THEN
9742: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
9743: l_interface_line_rec.request_id := -1 * p_line_id;
9744: ELSE
9745: l_interface_line_rec.request_id := -1 * p_header_id;
9746: END IF;

Line 9774: IF (x_result_out = OE_GLOBALS.G_WFR_COMPLETE OR x_result_out=OE_GLOBALS.G_WFR_NOT_ELIGIBLE) THEN

9770: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9772: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9773: -- bug# 4094835, if RFR line is fully is fully invoiced or not eligible
9774: IF (x_result_out = OE_GLOBALS.G_WFR_COMPLETE OR x_result_out=OE_GLOBALS.G_WFR_NOT_ELIGIBLE) THEN
9775: IF l_old_interface_status_code = 'MANUAL-PENDING' OR l_old_interface_status_code = 'RFR-PENDING' THEN
9776: IF l_debug_level > 0 THEN
9777: oe_debug_pub.add( 'RFR: MANUAL-PENDING + RFR LINE HAS BEEN FULLY INVOICED' , 5 ) ;
9778: oe_debug_pub.add( 'NOW COMPLETING THE WF BLOCK ACTIVITY' , 5 ) ;

Line 9780: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');

9776: IF l_debug_level > 0 THEN
9777: oe_debug_pub.add( 'RFR: MANUAL-PENDING + RFR LINE HAS BEEN FULLY INVOICED' , 5 ) ;
9778: oe_debug_pub.add( 'NOW COMPLETING THE WF BLOCK ACTIVITY' , 5 ) ;
9779: END IF;
9780: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');
9781: END IF;
9782: END IF;
9783: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN -- RFR line is partially invoiced
9784: IF l_debug_level > 0 THEN

Line 9783: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN -- RFR line is partially invoiced

9779: END IF;
9780: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');
9781: END IF;
9782: END IF;
9783: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN -- RFR line is partially invoiced
9784: IF l_debug_level > 0 THEN
9785: oe_debug_pub.add( 'RFR: THIS LINE IS PARTIALLY INVOICED' , 5 ) ;
9786: END IF;
9787: END IF;

Line 9813: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9809: oe_debug_pub.add( 'RFR: L_LINE_REC.INTERFACE_STATUS '||L_LINE_REC.INVOICE_INTERFACE_STATUS_CODE , 5 ) ;
9810: oe_debug_pub.add( 'RFR: X_RETURN_STATUS :'||X_RETURN_STATUS , 5 ) ;
9811: END IF;
9812: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9813: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9814: RAISE FND_API.G_EXC_ERROR;
9815: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9816: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9816: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9812: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9813: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9814: RAISE FND_API.G_EXC_ERROR;
9815: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9816: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9818: --bug# 4094835
9819: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9820: x_result_out := OE_GLOBALS.G_WFR_PRTL_COMPLETE;

Line 9820: x_result_out := OE_GLOBALS.G_WFR_PRTL_COMPLETE;

9816: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9818: --bug# 4094835
9819: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9820: x_result_out := OE_GLOBALS.G_WFR_PRTL_COMPLETE;
9821: IF l_debug_level > 0 THEN
9822: oe_debug_pub.add( 'RFR: LINE ID '||TO_CHAR ( L_LINE_REC.LINE_ID ) ||' PARTIALLY INTERFACED SUCCESSFULLY ' || 'X_RESULT_OUT: '||X_RESULT_OUT) ;
9823: END IF;
9824: END IF; -- check for update_invoice_attribute results

Line 9848: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');

9844: IF l_debug_level > 0 THEN
9845: oe_debug_pub.add( 'MANUAL-PENDING LINE HAS BEEN INVOICED' , 5 ) ;
9846: oe_debug_pub.add( 'NOW COMPLETING THE WF BLOCK ACTIVITY' , 5 ) ;
9847: END IF;
9848: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');
9849: END IF;
9850: END IF; -- check for interface_single_line result
9851: END IF; -- check for PTO
9852: END IF; -- Bug2181628.Process the line.

Line 9898: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

9894: IF l_debug_level > 0 THEN
9895: oe_debug_pub.add( 'INTERFACING LINE ID : '||L_LINE_REC.LINE_ID , 5 ) ;
9896: END IF;
9897: IF generate_invoice_number = 'Y' THEN
9898: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
9899: l_interface_line_rec.request_id := -1 * p_line_id;
9900: ELSE
9901: l_interface_line_rec.request_id := -1 * p_header_id;
9902: END IF;

Line 9964: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9960: IF l_debug_level > 0 THEN
9961: oe_debug_pub.add( 'RFR: INTERFACE RFR-PENDING LINE , ID: ' || L_PENDING_LINE_REC.LINE_ID , 5 ) ;
9962: END IF;
9963: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9964: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9965: RAISE FND_API.G_EXC_ERROR;
9966: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9967: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9967: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9963: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9964: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9965: RAISE FND_API.G_EXC_ERROR;
9966: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9967: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9969: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9970: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN
9971: IF l_debug_level > 0 THEN

Line 9970: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN

9966: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9967: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9969: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9970: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN
9971: IF l_debug_level > 0 THEN
9972: oe_debug_pub.add( 'RFR: RFR-PENDING LINE PARTIALLY INTERFACED' , 5 ) ;
9973: END IF;
9974: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN

Line 9974: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN

9970: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN
9971: IF l_debug_level > 0 THEN
9972: oe_debug_pub.add( 'RFR: RFR-PENDING LINE PARTIALLY INTERFACED' , 5 ) ;
9973: END IF;
9974: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN
9975: IF l_debug_level > 0 THEN
9976: oe_debug_pub.add( 'RFR: RFR-PENDING LINE INTERFACED SUCCESSFULLY , COMPLETING BLOCK' , 5 ) ;
9977: END IF;
9978: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');

Line 9978: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');

9974: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN
9975: IF l_debug_level > 0 THEN
9976: oe_debug_pub.add( 'RFR: RFR-PENDING LINE INTERFACED SUCCESSFULLY , COMPLETING BLOCK' , 5 ) ;
9977: END IF;
9978: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');
9979: END IF;
9980: END IF;
9981: END IF;
9982: END LOOP;

Line 9985: IF x_result_out = OE_GLOBALS.G_WFR_COMPLETE OR x_result_out = OE_GLOBALS.G_WFR_NOT_ELIGIBLE THEN

9981: END IF;
9982: END LOOP;
9983: -- run for the pending lines just interfaced
9984: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9985: IF x_result_out = OE_GLOBALS.G_WFR_COMPLETE OR x_result_out = OE_GLOBALS.G_WFR_NOT_ELIGIBLE THEN
9986: IF generate_invoice_number = 'Y' THEN
9987: IF l_debug_level > 0 THEN
9988: oe_debug_pub.add( 'RFR:LINE ID '||TO_CHAR ( L_LINE_REC.LINE_ID ) ||' INTERFACED SUCCESSFULLY' , 5 ) ;
9989: oe_debug_pub.add( 'RFR: CALLING UPDATE_NUMBERS' , 5 ) ;

Line 9991: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

9987: IF l_debug_level > 0 THEN
9988: oe_debug_pub.add( 'RFR:LINE ID '||TO_CHAR ( L_LINE_REC.LINE_ID ) ||' INTERFACED SUCCESSFULLY' , 5 ) ;
9989: oe_debug_pub.add( 'RFR: CALLING UPDATE_NUMBERS' , 5 ) ;
9990: END IF;
9991: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
9992: Update_Numbers(p_line_id, x_return_status);
9993: ELSE
9994: Update_Numbers(p_header_id, x_return_status);
9995: END IF;

Line 10000: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9996: IF l_debug_level > 0 THEN
9997: oe_debug_pub.add( 'RFR: RETURN STATUS : '||X_RETURN_STATUS , 5 ) ;
9998: END IF;
9999: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
10000: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
10001: RAISE FND_API.G_EXC_ERROR;
10002: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10003: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
10004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 10003: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9999: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
10000: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
10001: RAISE FND_API.G_EXC_ERROR;
10002: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10003: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
10004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10005: ELSE
10006: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;
10007: IF l_debug_level > 0 THEN

Line 10006: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;

10002: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10003: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
10004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10005: ELSE
10006: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;
10007: IF l_debug_level > 0 THEN
10008: oe_debug_pub.add( 'RFR: UPDATE NUMBER DONE FOR RFR-PENDING LINE ( CURRENT LINE IS RFR ) ' , 5 ) ;
10009: END IF;
10010: END IF;

Line 10024: IF x_result_out = OE_GLOBALS.G_WFR_COMPLETE OR x_result_out = OE_GLOBALS.G_WFR_NOT_ELIGIBLE THEN

10020: END IF; -- itself is a RFR line
10021: END IF; -- PTO line
10022: END IF; -- if interface_this_line is Y
10023: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
10024: IF x_result_out = OE_GLOBALS.G_WFR_COMPLETE OR x_result_out = OE_GLOBALS.G_WFR_NOT_ELIGIBLE THEN
10025: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
10026: IF generate_invoice_number = 'Y' THEN
10027: IF l_debug_level > 0 THEN
10028: oe_debug_pub.add( 'LINE ID '||TO_CHAR ( L_LINE_REC.LINE_ID ) ||' INTERFACED SUCCESSFULLY' , 2 ) ;

Line 10025: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

10021: END IF; -- PTO line
10022: END IF; -- if interface_this_line is Y
10023: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
10024: IF x_result_out = OE_GLOBALS.G_WFR_COMPLETE OR x_result_out = OE_GLOBALS.G_WFR_NOT_ELIGIBLE THEN
10025: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
10026: IF generate_invoice_number = 'Y' THEN
10027: IF l_debug_level > 0 THEN
10028: oe_debug_pub.add( 'LINE ID '||TO_CHAR ( L_LINE_REC.LINE_ID ) ||' INTERFACED SUCCESSFULLY' , 2 ) ;
10029: oe_debug_pub.add( 'CALLING UPDATE_NUMBERS' ) ;

Line 10031: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

10027: IF l_debug_level > 0 THEN
10028: oe_debug_pub.add( 'LINE ID '||TO_CHAR ( L_LINE_REC.LINE_ID ) ||' INTERFACED SUCCESSFULLY' , 2 ) ;
10029: oe_debug_pub.add( 'CALLING UPDATE_NUMBERS' ) ;
10030: END IF;
10031: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
10032: Update_Numbers(p_line_id, x_return_status);
10033: ELSE
10034: Update_Numbers(p_header_id, x_return_status);
10035: END IF;

Line 10040: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

10036: IF l_debug_level > 0 THEN
10037: oe_debug_pub.add( 'RETURN STATUS : '||X_RETURN_STATUS , 5 ) ;
10038: END IF;
10039: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
10040: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
10041: RAISE FND_API.G_EXC_ERROR;
10042: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10043: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
10044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 10043: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

10039: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
10040: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
10041: RAISE FND_API.G_EXC_ERROR;
10042: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10043: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
10044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10045: ELSE
10046: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;
10047: IF l_debug_level > 0 THEN

Line 10046: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;

10042: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10043: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
10044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10045: ELSE
10046: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;
10047: IF l_debug_level > 0 THEN
10048: oe_debug_pub.add( 'EXITING INTERFACE_LINE' , 5 ) ;
10049: END IF;
10050: RETURN;

Line 10067: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

10063: WHEN FND_API.G_EXC_ERROR THEN
10064: IF l_debug_level > 0 THEN
10065: oe_debug_pub.add( 'EXPECTED ERROR. EXIT LINE INVOICING : '||SQLERRM , 1 ) ;
10066: END IF;
10067: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
10068: ROLLBACK TO INVOICE_INTERFACE;
10069: END IF;
10070:
10071: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN

Line 10072: IF x_result_out = OE_GLOBALS.G_WFR_ON_HOLD Then

10068: ROLLBACK TO INVOICE_INTERFACE;
10069: END IF;
10070:
10071: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
10072: IF x_result_out = OE_GLOBALS.G_WFR_ON_HOLD Then
10073: l_flow_status_code := 'INVOICE_HOLD';
10074: ELSIF x_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN
10075: l_flow_status_code := 'INVOICE_INCOMPLETE';
10076: END IF;

Line 10074: ELSIF x_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN

10070:
10071: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
10072: IF x_result_out = OE_GLOBALS.G_WFR_ON_HOLD Then
10073: l_flow_status_code := 'INVOICE_HOLD';
10074: ELSIF x_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN
10075: l_flow_status_code := 'INVOICE_INCOMPLETE';
10076: END IF;
10077:
10078: Update_line_flow_status(l_line_rec.line_id,l_flow_status_code,

Line 10091: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

10087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10088: IF l_debug_level > 0 THEN
10089: oe_debug_pub.add( 'UNEXPECTED ERROR. EXITING FROM LINE INVOICING : '||SQLERRM , 1 ) ;
10090: END IF;
10091: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
10092: ROLLBACK TO INVOICE_INTERFACE;
10093: END IF;
10094: OE_MSG_PUB.Count_And_Get
10095: ( p_count => x_msg_count

Line 10109: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

10105: END IF;
10106: IF (Pending_Lines%ISOPEN) THEN
10107: CLOSE Pending_Lines;
10108: END IF;
10109: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
10110: ROLLBACK TO INVOICE_INTERFACE;
10111: END IF;
10112: IF FND_MSG_PUB.Check_Msg_Level
10113: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 10163: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;

10159: select source_document_type_id into l_source_document_type_id
10160: from oe_order_headers_all where header_id = p_header_id;
10161:
10162: if l_source_document_type_id = 10 THEN
10163: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;
10164: x_return_status := FND_API.G_RET_STS_SUCCESS ;
10165: IF l_debug_level > 0 THEN
10166: oe_debug_pub.add( ' This is Internal Sales Order ... not doing anything for ISO....' ) ;
10167: END IF;

Line 10183: IF l_result_out = OE_GLOBALS.G_WFR_ON_HOLD THEN

10179: oe_debug_pub.add( 'PROCESSING LINE_ID: '||L_LINE_ID , 5 ) ;
10180: END IF;
10181: Interface_Line(l_line_id, p_itemtype, l_result_out, l_return_status);
10182: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
10183: IF l_result_out = OE_GLOBALS.G_WFR_ON_HOLD THEN
10184: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
10185: ELSIF l_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN
10186: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
10187: END IF;

Line 10184: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;

10180: END IF;
10181: Interface_Line(l_line_id, p_itemtype, l_result_out, l_return_status);
10182: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
10183: IF l_result_out = OE_GLOBALS.G_WFR_ON_HOLD THEN
10184: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
10185: ELSIF l_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN
10186: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
10187: END IF;
10188: RAISE FND_API.G_EXC_ERROR;

Line 10185: ELSIF l_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN

10181: Interface_Line(l_line_id, p_itemtype, l_result_out, l_return_status);
10182: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
10183: IF l_result_out = OE_GLOBALS.G_WFR_ON_HOLD THEN
10184: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
10185: ELSIF l_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN
10186: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
10187: END IF;
10188: RAISE FND_API.G_EXC_ERROR;
10189: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 10186: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

10182: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
10183: IF l_result_out = OE_GLOBALS.G_WFR_ON_HOLD THEN
10184: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
10185: ELSIF l_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN
10186: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
10187: END IF;
10188: RAISE FND_API.G_EXC_ERROR;
10189: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 10205: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;

10201: from oe_order_headers_all where header_id = p_header_id;
10202: oe_debug_pub.add( ' l_source_document_type_id = '|| l_source_document_type_id , 5) ;
10203:
10204: if l_source_document_type_id = 10 THEN
10205: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;
10206: x_return_status := FND_API.G_RET_STS_SUCCESS ;
10207: IF l_debug_level > 0 THEN
10208: oe_debug_pub.add( ' This is Internal Sales Order ... not doing anything for ISO....', 5 ) ;
10209: END IF;

Line 10230: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

10226: oe_debug_pub.add( 'RETURN STATUS : '||X_RETURN_STATUS , 5 ) ;
10227: END IF;
10228:
10229: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
10230: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
10231: RAISE FND_API.G_EXC_ERROR;
10232: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10234: ELSE

Line 10236: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;

10232: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10234: ELSE
10235: x_return_status := FND_API.G_RET_STS_SUCCESS;
10236: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;
10237: IF l_debug_level > 0 THEN
10238: oe_debug_pub.add( 'EXIT INTERFACE_LINE ( ) PROCEDURE' , 5 ) ;
10239: END IF;
10240: END IF;

Line 10262: IF x_result_out = OE_GLOBALS.G_WFR_ON_HOLD Then

10258: END IF;
10259: ROLLBACK TO HEADER_INVOICE_INTERFACE;
10260:
10261: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
10262: IF x_result_out = OE_GLOBALS.G_WFR_ON_HOLD Then
10263: l_flow_status_code := 'INVOICE_HOLD';
10264: ELSIF x_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN
10265: l_flow_status_code := 'INVOICE_INCOMPLETE';
10266: END IF;

Line 10264: ELSIF x_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN

10260:
10261: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
10262: IF x_result_out = OE_GLOBALS.G_WFR_ON_HOLD Then
10263: l_flow_status_code := 'INVOICE_HOLD';
10264: ELSIF x_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN
10265: l_flow_status_code := 'INVOICE_INCOMPLETE';
10266: END IF;
10267: Update_header_flow_status(p_header_id,l_flow_status_code);
10268: END IF;

Line 10288: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

10284: ( p_count => x_msg_count
10285: , p_data => x_msg_data
10286: );
10287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10288: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
10289: WHEN OTHERS THEN
10290: IF l_debug_level > 0 THEN
10291: oe_debug_pub.add( 'EXCEPTION OTHERS. EXIT FROM HEADER INVOICING' , 5 ) ;
10292: END IF;

Line 10310: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

10306: ( p_count => x_msg_count
10307: , p_data => x_msg_data
10308: );
10309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10310: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
10311:
10312: END Interface_Header;
10313:
10314: