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 637: -- IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

633: IF l_debug_level > 0 THEN
634: oe_debug_pub.add( 'ENTER CHECK_INVOICING_HOLDS ' , 5 ) ;
635: END IF;
636: -- Check for Generic and invoice activity specific holds
637: -- IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
638: OE_HOLDS_PUB.CHECK_HOLDS(p_api_version => 1.0,
639: p_line_id => p_line_rec.line_id,
640: p_wf_item => OE_GLOBALS.G_WFI_LIN,
641: p_wf_activity => 'INVOICE_INTERFACE',

Line 640: p_wf_item => OE_GLOBALS.G_WFI_LIN,

636: -- Check for Generic and invoice activity specific holds
637: -- IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
638: OE_HOLDS_PUB.CHECK_HOLDS(p_api_version => 1.0,
639: p_line_id => p_line_rec.line_id,
640: p_wf_item => OE_GLOBALS.G_WFI_LIN,
641: p_wf_activity => 'INVOICE_INTERFACE',
642: x_result_out => l_hold_result_out,
643: x_return_status => l_hold_return_status,
644: x_msg_count => l_hold_msg_count,

Line 662: p_wf_item => OE_GLOBALS.G_WFI_HDR,

658: END IF;
659: -- ELSIF p_itemtype = 'OEOH' THEN
660: OE_HOLDS_PUB.CHECK_HOLDS(p_api_version => 1.0,
661: p_line_id => p_line_rec.line_id,
662: p_wf_item => OE_GLOBALS.G_WFI_HDR,
663: p_wf_activity => 'HEADER_INVOICE_INTERFACE',
664: x_result_out => l_hold_result_out,
665: x_return_status => l_hold_return_status,
666: x_msg_count => l_hold_msg_count,

Line 7471: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN

7467: BEGIN
7468: IF l_debug_level > 0 THEN
7469: oe_debug_pub.add( 'UPDATING INVOICE ATTRIBUTES' , 5 ) ;
7470: END IF;
7471: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
7472: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
7473: END IF;
7474: l_invoiced_quantity := nvl(p_line_rec.invoiced_quantity, 0) + nvl(p_interface_line_rec.quantity, 0);
7475: --Bug2361642.Added a check for lines in "MANUAL-PENDING" status too.

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

7468: IF l_debug_level > 0 THEN
7469: oe_debug_pub.add( 'UPDATING INVOICE ATTRIBUTES' , 5 ) ;
7470: END IF;
7471: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
7472: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
7473: END IF;
7474: l_invoiced_quantity := nvl(p_line_rec.invoiced_quantity, 0) + nvl(p_interface_line_rec.quantity, 0);
7475: --Bug2361642.Added a check for lines in "MANUAL-PENDING" status too.
7476: IF (p_invoice_interface_status = 'RFR-PENDING' OR

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

7531: SERVICE_END_DATE = p_line_rec.SERVICE_END_DATE, --bug # 7231974
7532: CALCULATE_PRICE_FLAG = 'N',
7533: LOCK_CONTROL = LOCK_CONTROL + 1
7534: WHERE LINE_ID = p_line_rec.line_id;
7535: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
7536: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') ) THEN
7537:
7538: l_Line_tbl(1) := p_line_rec;
7539: l_Old_Line_tbl(1) := p_line_rec;

Line 7695: p_item_type => OE_GLOBALS.G_WFI_HDR

7691: INTO l_header_id
7692: FROM oe_order_lines
7693: WHERE line_id = p_line_id;
7694: RETURN( WF_ENGINE.Activity_Exist_In_Process(
7695: p_item_type => OE_GLOBALS.G_WFI_HDR
7696: ,p_item_key => to_char(l_header_id)
7697: ,p_activity_name => 'HEADER_INVOICE_INTERFACE'));
7698: END Header_Activity;
7699:

Line 7715: p_item_type => OE_GLOBALS.G_WFI_LIN

7711: -- WF team removed this function at one stage and now provided the same
7712: -- for backward compatibility purpose with bug# 1869241.
7713: -- Issue with invoice interface due the the missing wf function is reported in bug# 1868026.
7714: RETURN( WF_ENGINE.Activity_Exist_In_Process(
7715: p_item_type => OE_GLOBALS.G_WFI_LIN
7716: ,p_item_key => to_char(p_line_id)
7717: ,p_activity_name => 'INVOICE_INTERFACE'));
7718: END Line_Activity;
7719:

Line 8055: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;

8051: END IF;
8052: IF l_freight_count >0 then
8053: Check_Invoicing_Holds(p_line_rec, g_itemtype, x_return_status);
8054: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8055: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
8056: RAISE FND_API.G_EXC_ERROR;
8057: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8058: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8058: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8054: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8055: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
8056: RAISE FND_API.G_EXC_ERROR;
8057: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8058: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8060: END IF;
8061: END IF; */
8062: /* Bug#2666125 end-check freight records and holds for non invoiceable items*/

Line 8069: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8065: ,p_x_interface_line_rec
8066: ,'NOT_ELIGIBLE'
8067: ,x_return_status);
8068: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8069: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8070: RAISE FND_API.G_EXC_ERROR;
8071: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8072: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8072: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8068: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8069: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8070: RAISE FND_API.G_EXC_ERROR;
8071: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8072: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8074: END IF;
8075: --- Eventhough line is not eligible for invoicing, there might be some other
8076: --- lines that are waiting for this line to trigger their invoicing activity.

Line 8106: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8102: IF l_debug_level > 0 THEN
8103: oe_debug_pub.add( 'INTERFACING PENDING LINE ID ' || L_PENDING_LINE_REC.LINE_ID , 5 ) ;
8104: END IF;
8105: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8106: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8107: RAISE FND_API.G_EXC_ERROR;
8108: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8109: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8109: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8105: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8106: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8107: RAISE FND_API.G_EXC_ERROR;
8108: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8109: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8111: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8112: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN
8113: IF l_debug_level > 0 THEN

Line 8112: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN

8108: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8109: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8111: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8112: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN
8113: IF l_debug_level > 0 THEN
8114: oe_debug_pub.add( 'RFR PENDING LINE PARTIALLY INTERFACED' , 5 ) ;
8115: END IF;
8116: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN

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

8112: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN
8113: IF l_debug_level > 0 THEN
8114: oe_debug_pub.add( 'RFR PENDING LINE PARTIALLY INTERFACED' , 5 ) ;
8115: END IF;
8116: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN
8117: IF l_debug_level > 0 THEN
8118: oe_debug_pub.add( 'RFR-PENDING LINE INTERFACED SUCCESSFULLY' , 5 ) ;
8119: END IF;
8120: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');

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

8116: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN
8117: IF l_debug_level > 0 THEN
8118: oe_debug_pub.add( 'RFR-PENDING LINE INTERFACED SUCCESSFULLY' , 5 ) ;
8119: END IF;
8120: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');
8121: END IF;
8122: END IF;
8123: END IF;
8124: END LOOP;

Line 8188: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8184: IF l_debug_level > 0 THEN
8185: oe_debug_pub.add( 'VALIDATING REQUIRED ATTRIBUTES' , 5 ) ;
8186: END IF;
8187: IF NOT Validate_Required_Attributes(p_line_rec, p_x_interface_line_rec) THEN
8188: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8189: RAISE FND_API.G_EXC_ERROR;
8190: END IF;
8191: IF l_debug_level > 0 THEN
8192: oe_debug_pub.add( 'INTERFACING FREIGHT CHARGES' , 5 ) ;

Line 8203: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8199: /* END Enhancement Request# 1915736 */
8200: END IF; -- for Non-rejected_lines Customer Acceptance
8201:
8202: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8203: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8204: RAISE FND_API.G_EXC_ERROR;
8205: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8206: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8206: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8202: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8203: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8204: RAISE FND_API.G_EXC_ERROR;
8205: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8206: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8208: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8209: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;
8210: IF l_debug_level > 0 THEN

Line 8209: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;

8205: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8206: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8208: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8209: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;
8210: IF l_debug_level > 0 THEN
8211: oe_debug_pub.add( 'RETURN AFTER INVOICEABLE ELIGIBLE CHECK' , 1 ) ;
8212: END IF;
8213: --Customer Acceptance

Line 8253: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8249: IF l_debug_level > 0 THEN
8250: oe_debug_pub.add( 'REQUEST_ID AFTER INSERTING '||P_X_INTERFACE_LINE_REC.REQUEST_ID , 5 ) ;
8251: END IF;
8252: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8253: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8254: RAISE FND_API.G_EXC_ERROR;
8255: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8256: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8256: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8252: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8253: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8254: RAISE FND_API.G_EXC_ERROR;
8255: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8256: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8258: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8259: IF l_result_code = 'RFR-PENDING' THEN
8260: x_result_out := OE_GLOBALS.G_WFR_PRTL_COMPLETE;

Line 8260: x_result_out := OE_GLOBALS.G_WFR_PRTL_COMPLETE;

8256: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8258: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8259: IF l_result_code = 'RFR-PENDING' THEN
8260: x_result_out := OE_GLOBALS.G_WFR_PRTL_COMPLETE;
8261: IF l_debug_level > 0 THEN
8262: 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 ) ;
8263: END IF;
8264: IF l_debug_level > 0 THEN

Line 8279: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8275: IF l_debug_level > 0 THEN
8276: oe_debug_pub.add( 'VALIDATE REQUIRED ATTRIBUTES' , 5 ) ;
8277: END IF;
8278: IF NOT Validate_Required_Attributes(p_line_rec, p_x_interface_line_rec) THEN
8279: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8280: RAISE FND_API.G_EXC_ERROR;
8281: END IF;
8282: IF l_debug_level > 0 THEN
8283: oe_debug_pub.add( 'INSERTING LINE INTO RA_INTERFACE_LINES' , 5 ) ;

Line 8289: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8285: Insert_Line(p_x_interface_line_rec
8286: ,x_return_status=>l_return_status);
8287: -- Fix for the bug 2187074
8288: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8289: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8291: END IF;
8292:
8293: -- 3685479 Replacing show detail dis by the following IF

Line 8303: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8299: Interface_Detail_Discounts(p_line_rec, p_x_interface_line_rec
8300: ,x_return_status);
8301: -- Fix for the bug 2187074
8302: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8303: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8305: END IF;
8306: END IF;
8307: IF l_debug_level > 0 THEN

Line 8314: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8310: Interface_Freight_Charges(p_line_rec
8311: , p_x_interface_line_rec
8312: , x_return_status);
8313: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8314: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8315: RAISE FND_API.G_EXC_ERROR;
8316: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8317: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8317: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8313: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8314: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8315: RAISE FND_API.G_EXC_ERROR;
8316: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8317: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8319: END IF;
8320: IF l_debug_level > 0 THEN
8321: oe_debug_pub.add( 'INTERFACING SALES CREDITS' , 5 ) ;

Line 8327: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8323: Interface_Salescredits(p_line_rec
8324: ,p_x_interface_line_rec
8325: ,x_return_status);
8326: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8327: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8328: RAISE FND_API.G_EXC_ERROR;
8329: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8330: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8330: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8326: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8327: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8328: RAISE FND_API.G_EXC_ERROR;
8329: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8330: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8332: END IF;
8333:
8334: --Customer Acceptance

Line 8371: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8367: IF l_debug_level > 0 THEN
8368: oe_debug_pub.add( 'REQUEST_ID AFTER INSERTING '||P_X_INTERFACE_LINE_REC.REQUEST_ID ) ;
8369: END IF;
8370: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8371: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8372: RAISE FND_API.G_EXC_ERROR;
8373: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8374: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8374: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8370: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8371: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8372: RAISE FND_API.G_EXC_ERROR;
8373: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8374: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8376: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8377: IF l_result_code = 'RFR-PENDING' THEN
8378: x_result_out := OE_GLOBALS.G_WFR_PRTL_COMPLETE;

Line 8378: x_result_out := OE_GLOBALS.G_WFR_PRTL_COMPLETE;

8374: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8376: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8377: IF l_result_code = 'RFR-PENDING' THEN
8378: x_result_out := OE_GLOBALS.G_WFR_PRTL_COMPLETE;
8379: IF l_debug_level > 0 THEN
8380: oe_debug_pub.add( 'LINE ID '||TO_CHAR ( P_LINE_REC.LINE_ID ) ||' PARTIALLY INTERFACED SUCCESSFULLY' , 1 ) ;
8381: END IF;
8382: ELSE

Line 8383: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;

8379: IF l_debug_level > 0 THEN
8380: oe_debug_pub.add( 'LINE ID '||TO_CHAR ( P_LINE_REC.LINE_ID ) ||' PARTIALLY INTERFACED SUCCESSFULLY' , 1 ) ;
8381: END IF;
8382: ELSE
8383: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;
8384: IF l_debug_level > 0 THEN
8385: oe_debug_pub.add( 'LINE ID '||TO_CHAR ( P_LINE_REC.LINE_ID ) ||' INTERFACED SUCCESSFULLY' , 1 ) ;
8386: END IF;
8387: END IF;

Line 8515: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

8511: oe_debug_pub.add( 'ENTERING INTERFACE_LINE ( ) PROCEDURE' , 1 ) ;
8512: oe_debug_pub.add( 'LINE ID : '|| P_LINE_ID , 5 ) ;
8513: oe_debug_pub.add( 'ITEM TYPE : '||P_ITEMTYPE , 5 ) ;
8514: END IF;
8515: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
8516: SAVEPOINT INVOICE_INTERFACE;
8517: END IF;
8518:
8519: --bug 5336623 Commented the following call to OE_MSG_PUB.set_msg_context

Line 8551: IF p_itemtype = OE_GLOBALS.G_WFI_HDR THEN

8547: END IF; */
8548:
8549: --bug 5336623 Moved the following call to OE_Header_Util.Query_row after the line is locked
8550: --OE_Header_Util.Query_row(p_header_id=>l_line_rec.header_id,x_header_rec=>l_header_rec);
8551: IF p_itemtype = OE_GLOBALS.G_WFI_HDR THEN
8552: p_header_id := l_line_rec.header_id;
8553: END IF;
8554: -- Set message context
8555: OE_MSG_PUB.set_msg_context(

Line 8602: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

8598: oe_debug_pub.add(' SQLERRM = '|| SQLERRM );
8599: oe_debug_pub.add( ' Unable to LOCK this Line. Going to make it DEFERRED so that it can be picked by another WFBP ');
8600: END IF;
8601:
8602: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
8603: ROLLBACK TO INVOICE_INTERFACE;
8604: END IF;
8605: x_result_out := NULL;
8606: x_return_status := 'DEFERRED';

Line 8665: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8661: END IF;
8662: ELSE
8663: Update_Invoice_Attributes(l_line_rec ,l_interface_line_rec ,'ACCEPTANCE-PENDING' ,x_return_status);
8664: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8665: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8666: RAISE FND_API.G_EXC_ERROR;
8667: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8668: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8668: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8664: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8665: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8666: RAISE FND_API.G_EXC_ERROR;
8667: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8668: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8670: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8671: x_result_out := OE_GLOBALS.G_WFR_PENDING_ACCEPTANCE; -- this is pending for Acceptance
8672: RETURN;

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

8667: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8668: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8670: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8671: x_result_out := OE_GLOBALS.G_WFR_PENDING_ACCEPTANCE; -- this is pending for Acceptance
8672: RETURN;
8673: END IF;
8674: END IF;
8675: END IF;

Line 8729: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;

8725: END IF;
8726: IF l_freight_count >0 then
8727: Check_Invoicing_Holds(l_line_rec, p_itemtype, x_return_status);
8728: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8729: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
8730: RAISE FND_API.G_EXC_ERROR;
8731: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8732: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8732: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8728: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8729: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
8730: RAISE FND_API.G_EXC_ERROR;
8731: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8732: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8734: END IF;
8735: END IF;
8736: END IF; -- noninvoiceable line

Line 8747: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8743: ,l_interface_line_rec
8744: ,'NOT_ELIGIBLE'
8745: ,x_return_status);
8746: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8747: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8748: RAISE FND_API.G_EXC_ERROR;
8749: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8750: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8750: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8746: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8747: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8748: RAISE FND_API.G_EXC_ERROR;
8749: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8750: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8752: END IF;
8753: --- Eventhough line is not eligible for invoicing, there might be some other
8754: --- lines that are waiting for this line to trigger their invoicing activity.

Line 8784: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8780: IF l_debug_level > 0 THEN
8781: oe_debug_pub.add( 'INTERFACING PENDING LINE ID ' || L_PENDING_LINE_REC.LINE_ID , 5 ) ;
8782: END IF;
8783: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8784: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8785: RAISE FND_API.G_EXC_ERROR;
8786: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8787: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8787: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8783: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8784: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8785: RAISE FND_API.G_EXC_ERROR;
8786: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8787: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8789: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8790: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN
8791: IF l_debug_level > 0 THEN

Line 8790: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN

8786: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8787: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8789: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8790: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN
8791: IF l_debug_level > 0 THEN
8792: oe_debug_pub.add( 'RFR PENDING LINE PARTIALLY INTERFACED' , 5 ) ;
8793: END IF;
8794: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN

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

8790: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN
8791: IF l_debug_level > 0 THEN
8792: oe_debug_pub.add( 'RFR PENDING LINE PARTIALLY INTERFACED' , 5 ) ;
8793: END IF;
8794: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN
8795: IF l_debug_level > 0 THEN
8796: oe_debug_pub.add( 'RFR-PENDING LINE INTERFACED SUCCESSFULLY' , 5 ) ;
8797: END IF;
8798: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');

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

8794: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN
8795: IF l_debug_level > 0 THEN
8796: oe_debug_pub.add( 'RFR-PENDING LINE INTERFACED SUCCESSFULLY' , 5 ) ;
8797: END IF;
8798: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');
8799: END IF;
8800: END IF;
8801: END IF;
8802: END LOOP;

Line 8863: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8859: IF l_debug_level > 0 THEN
8860: oe_debug_pub.add( 'VALIDATING REQUIRED ATTRIBUTES' , 5 ) ;
8861: END IF;
8862: IF NOT Validate_Required_Attributes(l_line_rec, l_interface_line_rec) THEN
8863: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8864: RAISE FND_API.G_EXC_ERROR;
8865: END IF;
8866: IF l_debug_level > 0 THEN
8867: oe_debug_pub.add( 'INTERFACING FREIGHT CHARGES' , 5 ) ;

Line 8877: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8873: END IF; -- for freight
8874: /* END Enhancement Request# 1915736 */
8875: END IF; -- for Non-rejected_lines Customer Acceptance
8876: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8877: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8878: RAISE FND_API.G_EXC_ERROR;
8879: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8880: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8880: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8876: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8877: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8878: RAISE FND_API.G_EXC_ERROR;
8879: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8880: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8882: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8883: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;
8884: IF l_debug_level > 0 THEN

Line 8883: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;

8879: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8880: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8882: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8883: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;
8884: IF l_debug_level > 0 THEN
8885: oe_debug_pub.add( 'RETURN AFTER INVOICEABLE ELIGIBLE CHECK' , 1 ) ;
8886: END IF;
8887: --Customer Acceptance

Line 8900: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;

8896: END IF; -- non-invoiceable lines check
8897:
8898: Check_Invoicing_Holds(l_line_rec, p_itemtype, x_return_status);
8899: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8900: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
8901: RAISE FND_API.G_EXC_ERROR;
8902: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8903: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8903: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

8899: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8900: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
8901: RAISE FND_API.G_EXC_ERROR;
8902: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8903: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8905: END IF;
8906: IF FND_PROFILE.VALUE('WSH_INVOICE_NUMBERING_METHOD') = 'D' THEN
8907: IF l_debug_level > 0 THEN

Line 9060: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

9056: IF del_line_ready_flag = 'N' THEN -- atleast one line in delivery is not ready to interface
9057: IF l_debug_level > 0 THEN
9058: oe_debug_pub.add( 'SOME OF THE LINES IN THE DELIVERY ARE NOT READY' , 5 ) ;
9059: END IF;
9060: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
9061: IF l_debug_level > 0 THEN
9062: oe_debug_pub.add( 'LINE LEVEL INVOICING-SET STATUS TO PENDING' , 5 ) ;
9063: END IF;
9064: Update_Invoice_Attributes(l_line_rec

Line 9084: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9080: oe_debug_pub.add( 'INTERFACE STATUS : '||L_LINE_REC.INVOICE_INTERFACE_STATUS_CODE , 5 ) ;
9081: oe_debug_pub.add( 'X_RETURN_STATUS : '||X_RETURN_STATUS , 5 ) ;
9082: END IF;
9083: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9084: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9085: RAISE FND_API.G_EXC_ERROR;
9086: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9087: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9087: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9083: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9084: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9085: RAISE FND_API.G_EXC_ERROR;
9086: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9087: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9089: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9090: x_result_out := OE_GLOBALS.G_WFR_PRTL_COMPLETE; -- this actually is pending, we call it partial for WF
9091: RETURN;

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

9086: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9087: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9089: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9090: x_result_out := OE_GLOBALS.G_WFR_PRTL_COMPLETE; -- this actually is pending, we call it partial for WF
9091: RETURN;
9092: END IF;
9093: ELSE -- header level invoice, all delivery lines are not ready to invoice. do not honor delivery.
9094: IF l_debug_level > 0 THEN

Line 9182: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

9178: END IF;
9179: END IF;
9180: -- Bug2181628 Only now Process the line.
9181: IF ((l_line_id = p_line_id) OR (l_line_delivery_id = l_delivery_line_id)) THEN
9182: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
9183: l_interface_line_rec.request_id := -1 * p_line_id;
9184: ELSE
9185: l_interface_line_rec.request_id := -1 * p_header_id;
9186: END IF;

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

9210: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9212: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9213: -- bug# 4094835, if RFR line is fully is fully invoiced or not eligible
9214: IF (x_result_out = OE_GLOBALS.G_WFR_COMPLETE OR x_result_out=OE_GLOBALS.G_WFR_NOT_ELIGIBLE) THEN
9215: IF l_old_interface_status_code = 'MANUAL-PENDING' OR l_old_interface_status_code = 'RFR-PENDING' THEN
9216: IF l_debug_level > 0 THEN
9217: oe_debug_pub.add( 'RFR: MANUAL-PENDING + RFR LINE HAS BEEN FULLY INVOICED' , 5 ) ;
9218: oe_debug_pub.add( 'NOW COMPLETING THE WF BLOCK ACTIVITY' , 5 ) ;

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

9216: IF l_debug_level > 0 THEN
9217: oe_debug_pub.add( 'RFR: MANUAL-PENDING + RFR LINE HAS BEEN FULLY INVOICED' , 5 ) ;
9218: oe_debug_pub.add( 'NOW COMPLETING THE WF BLOCK ACTIVITY' , 5 ) ;
9219: END IF;
9220: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');
9221: END IF;
9222: END IF;
9223: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN -- RFR line is partially invoiced
9224: IF l_debug_level > 0 THEN

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

9219: END IF;
9220: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');
9221: END IF;
9222: END IF;
9223: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN -- RFR line is partially invoiced
9224: IF l_debug_level > 0 THEN
9225: oe_debug_pub.add( 'RFR: THIS LINE IS PARTIALLY INVOICED' , 5 ) ;
9226: END IF;
9227: END IF;

Line 9253: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9249: oe_debug_pub.add( 'RFR: L_LINE_REC.INTERFACE_STATUS '||L_LINE_REC.INVOICE_INTERFACE_STATUS_CODE , 5 ) ;
9250: oe_debug_pub.add( 'RFR: X_RETURN_STATUS :'||X_RETURN_STATUS , 5 ) ;
9251: END IF;
9252: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9253: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9254: RAISE FND_API.G_EXC_ERROR;
9255: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9256: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9256: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9252: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9253: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9254: RAISE FND_API.G_EXC_ERROR;
9255: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9256: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9258: --bug# 4094835
9259: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9260: x_result_out := OE_GLOBALS.G_WFR_PRTL_COMPLETE;

Line 9260: x_result_out := OE_GLOBALS.G_WFR_PRTL_COMPLETE;

9256: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9258: --bug# 4094835
9259: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9260: x_result_out := OE_GLOBALS.G_WFR_PRTL_COMPLETE;
9261: IF l_debug_level > 0 THEN
9262: oe_debug_pub.add( 'RFR: LINE ID '||TO_CHAR ( L_LINE_REC.LINE_ID ) ||' PARTIALLY INTERFACED SUCCESSFULLY ' || 'X_RESULT_OUT: '||X_RESULT_OUT) ;
9263: END IF;
9264: END IF; -- check for update_invoice_attribute results

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

9284: IF l_debug_level > 0 THEN
9285: oe_debug_pub.add( 'MANUAL-PENDING LINE HAS BEEN INVOICED' , 5 ) ;
9286: oe_debug_pub.add( 'NOW COMPLETING THE WF BLOCK ACTIVITY' , 5 ) ;
9287: END IF;
9288: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');
9289: END IF;
9290: END IF; -- check for interface_single_line result
9291: END IF; -- check for PTO
9292: END IF; -- Bug2181628.Process the line.

Line 9338: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

9334: IF l_debug_level > 0 THEN
9335: oe_debug_pub.add( 'INTERFACING LINE ID : '||L_LINE_REC.LINE_ID , 5 ) ;
9336: END IF;
9337: IF generate_invoice_number = 'Y' THEN
9338: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
9339: l_interface_line_rec.request_id := -1 * p_line_id;
9340: ELSE
9341: l_interface_line_rec.request_id := -1 * p_header_id;
9342: END IF;

Line 9404: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9400: IF l_debug_level > 0 THEN
9401: oe_debug_pub.add( 'RFR: INTERFACE RFR-PENDING LINE , ID: ' || L_PENDING_LINE_REC.LINE_ID , 5 ) ;
9402: END IF;
9403: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9404: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9405: RAISE FND_API.G_EXC_ERROR;
9406: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9407: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9407: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9403: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9404: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9405: RAISE FND_API.G_EXC_ERROR;
9406: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9407: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9409: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9410: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN
9411: IF l_debug_level > 0 THEN

Line 9410: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN

9406: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9407: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9409: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9410: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN
9411: IF l_debug_level > 0 THEN
9412: oe_debug_pub.add( 'RFR: RFR-PENDING LINE PARTIALLY INTERFACED' , 5 ) ;
9413: END IF;
9414: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN

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

9410: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN
9411: IF l_debug_level > 0 THEN
9412: oe_debug_pub.add( 'RFR: RFR-PENDING LINE PARTIALLY INTERFACED' , 5 ) ;
9413: END IF;
9414: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN
9415: IF l_debug_level > 0 THEN
9416: oe_debug_pub.add( 'RFR: RFR-PENDING LINE INTERFACED SUCCESSFULLY , COMPLETING BLOCK' , 5 ) ;
9417: END IF;
9418: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');

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

9414: ELSE --x_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN
9415: IF l_debug_level > 0 THEN
9416: oe_debug_pub.add( 'RFR: RFR-PENDING LINE INTERFACED SUCCESSFULLY , COMPLETING BLOCK' , 5 ) ;
9417: END IF;
9418: WF_ENGINE.CompleteActivityInternalName(OE_GLOBALS.G_WFI_LIN, l_pending_line_rec.line_id, 'INVOICING_WAIT_FOR_RFR', 'COMPLETE');
9419: END IF;
9420: END IF;
9421: END IF;
9422: END LOOP;

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

9421: END IF;
9422: END LOOP;
9423: -- run for the pending lines just interfaced
9424: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9425: IF x_result_out = OE_GLOBALS.G_WFR_COMPLETE OR x_result_out = OE_GLOBALS.G_WFR_NOT_ELIGIBLE THEN
9426: IF generate_invoice_number = 'Y' THEN
9427: IF l_debug_level > 0 THEN
9428: oe_debug_pub.add( 'RFR:LINE ID '||TO_CHAR ( L_LINE_REC.LINE_ID ) ||' INTERFACED SUCCESSFULLY' , 5 ) ;
9429: oe_debug_pub.add( 'RFR: CALLING UPDATE_NUMBERS' , 5 ) ;

Line 9431: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

9427: IF l_debug_level > 0 THEN
9428: oe_debug_pub.add( 'RFR:LINE ID '||TO_CHAR ( L_LINE_REC.LINE_ID ) ||' INTERFACED SUCCESSFULLY' , 5 ) ;
9429: oe_debug_pub.add( 'RFR: CALLING UPDATE_NUMBERS' , 5 ) ;
9430: END IF;
9431: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
9432: Update_Numbers(p_line_id, x_return_status);
9433: ELSE
9434: Update_Numbers(p_header_id, x_return_status);
9435: END IF;

Line 9440: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9436: IF l_debug_level > 0 THEN
9437: oe_debug_pub.add( 'RFR: RETURN STATUS : '||X_RETURN_STATUS , 5 ) ;
9438: END IF;
9439: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9440: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9441: RAISE FND_API.G_EXC_ERROR;
9442: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9443: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9443: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9439: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9440: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9441: RAISE FND_API.G_EXC_ERROR;
9442: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9443: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9445: ELSE
9446: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;
9447: IF l_debug_level > 0 THEN

Line 9446: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;

9442: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9443: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9445: ELSE
9446: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;
9447: IF l_debug_level > 0 THEN
9448: oe_debug_pub.add( 'RFR: UPDATE NUMBER DONE FOR RFR-PENDING LINE ( CURRENT LINE IS RFR ) ' , 5 ) ;
9449: END IF;
9450: END IF;

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

9460: END IF; -- itself is a RFR line
9461: END IF; -- PTO line
9462: END IF; -- if interface_this_line is Y
9463: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9464: IF x_result_out = OE_GLOBALS.G_WFR_COMPLETE OR x_result_out = OE_GLOBALS.G_WFR_NOT_ELIGIBLE THEN
9465: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
9466: IF generate_invoice_number = 'Y' THEN
9467: IF l_debug_level > 0 THEN
9468: oe_debug_pub.add( 'LINE ID '||TO_CHAR ( L_LINE_REC.LINE_ID ) ||' INTERFACED SUCCESSFULLY' , 2 ) ;

Line 9465: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

9461: END IF; -- PTO line
9462: END IF; -- if interface_this_line is Y
9463: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9464: IF x_result_out = OE_GLOBALS.G_WFR_COMPLETE OR x_result_out = OE_GLOBALS.G_WFR_NOT_ELIGIBLE THEN
9465: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
9466: IF generate_invoice_number = 'Y' THEN
9467: IF l_debug_level > 0 THEN
9468: oe_debug_pub.add( 'LINE ID '||TO_CHAR ( L_LINE_REC.LINE_ID ) ||' INTERFACED SUCCESSFULLY' , 2 ) ;
9469: oe_debug_pub.add( 'CALLING UPDATE_NUMBERS' ) ;

Line 9471: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

9467: IF l_debug_level > 0 THEN
9468: oe_debug_pub.add( 'LINE ID '||TO_CHAR ( L_LINE_REC.LINE_ID ) ||' INTERFACED SUCCESSFULLY' , 2 ) ;
9469: oe_debug_pub.add( 'CALLING UPDATE_NUMBERS' ) ;
9470: END IF;
9471: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
9472: Update_Numbers(p_line_id, x_return_status);
9473: ELSE
9474: Update_Numbers(p_header_id, x_return_status);
9475: END IF;

Line 9480: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9476: IF l_debug_level > 0 THEN
9477: oe_debug_pub.add( 'RETURN STATUS : '||X_RETURN_STATUS , 5 ) ;
9478: END IF;
9479: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9480: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9481: RAISE FND_API.G_EXC_ERROR;
9482: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9483: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9483: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9479: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9480: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9481: RAISE FND_API.G_EXC_ERROR;
9482: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9483: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9485: ELSE
9486: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;
9487: IF l_debug_level > 0 THEN

Line 9486: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;

9482: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9483: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9485: ELSE
9486: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;
9487: IF l_debug_level > 0 THEN
9488: oe_debug_pub.add( 'EXITING INTERFACE_LINE' , 5 ) ;
9489: END IF;
9490: RETURN;

Line 9507: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

9503: WHEN FND_API.G_EXC_ERROR THEN
9504: IF l_debug_level > 0 THEN
9505: oe_debug_pub.add( 'EXPECTED ERROR. EXIT LINE INVOICING : '||SQLERRM , 1 ) ;
9506: END IF;
9507: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
9508: ROLLBACK TO INVOICE_INTERFACE;
9509: END IF;
9510:
9511: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN

Line 9512: IF x_result_out = OE_GLOBALS.G_WFR_ON_HOLD Then

9508: ROLLBACK TO INVOICE_INTERFACE;
9509: END IF;
9510:
9511: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
9512: IF x_result_out = OE_GLOBALS.G_WFR_ON_HOLD Then
9513: l_flow_status_code := 'INVOICE_HOLD';
9514: ELSIF x_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN
9515: l_flow_status_code := 'INVOICE_INCOMPLETE';
9516: END IF;

Line 9514: ELSIF x_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN

9510:
9511: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
9512: IF x_result_out = OE_GLOBALS.G_WFR_ON_HOLD Then
9513: l_flow_status_code := 'INVOICE_HOLD';
9514: ELSIF x_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN
9515: l_flow_status_code := 'INVOICE_INCOMPLETE';
9516: END IF;
9517: Update_line_flow_status(l_line_rec.line_id,l_flow_status_code);
9518: END IF;

Line 9529: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

9525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9526: IF l_debug_level > 0 THEN
9527: oe_debug_pub.add( 'UNEXPECTED ERROR. EXITING FROM LINE INVOICING : '||SQLERRM , 1 ) ;
9528: END IF;
9529: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
9530: ROLLBACK TO INVOICE_INTERFACE;
9531: END IF;
9532: OE_MSG_PUB.Count_And_Get
9533: ( p_count => x_msg_count

Line 9547: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

9543: END IF;
9544: IF (Pending_Lines%ISOPEN) THEN
9545: CLOSE Pending_Lines;
9546: END IF;
9547: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
9548: ROLLBACK TO INVOICE_INTERFACE;
9549: END IF;
9550: IF FND_MSG_PUB.Check_Msg_Level
9551: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 9603: IF l_result_out = OE_GLOBALS.G_WFR_ON_HOLD THEN

9599: oe_debug_pub.add( 'PROCESSING LINE_ID: '||L_LINE_ID , 5 ) ;
9600: END IF;
9601: Interface_Line(l_line_id, p_itemtype, l_result_out, l_return_status);
9602: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
9603: IF l_result_out = OE_GLOBALS.G_WFR_ON_HOLD THEN
9604: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
9605: ELSIF l_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN
9606: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9607: END IF;

Line 9604: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;

9600: END IF;
9601: Interface_Line(l_line_id, p_itemtype, l_result_out, l_return_status);
9602: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
9603: IF l_result_out = OE_GLOBALS.G_WFR_ON_HOLD THEN
9604: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
9605: ELSIF l_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN
9606: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9607: END IF;
9608: RAISE FND_API.G_EXC_ERROR;

Line 9605: ELSIF l_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN

9601: Interface_Line(l_line_id, p_itemtype, l_result_out, l_return_status);
9602: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
9603: IF l_result_out = OE_GLOBALS.G_WFR_ON_HOLD THEN
9604: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
9605: ELSIF l_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN
9606: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9607: END IF;
9608: RAISE FND_API.G_EXC_ERROR;
9609: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 9606: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9602: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
9603: IF l_result_out = OE_GLOBALS.G_WFR_ON_HOLD THEN
9604: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
9605: ELSIF l_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN
9606: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9607: END IF;
9608: RAISE FND_API.G_EXC_ERROR;
9609: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 9626: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9622: IF l_debug_level > 0 THEN
9623: oe_debug_pub.add( 'RETURN STATUS : '||X_RETURN_STATUS , 5 ) ;
9624: END IF;
9625: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9626: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9627: RAISE FND_API.G_EXC_ERROR;
9628: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9630: ELSE

Line 9632: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;

9628: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9630: ELSE
9631: x_return_status := FND_API.G_RET_STS_SUCCESS;
9632: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;
9633: IF l_debug_level > 0 THEN
9634: oe_debug_pub.add( 'EXIT INTERFACE_LINE ( ) PROCEDURE' , 5 ) ;
9635: END IF;
9636: END IF;

Line 9658: IF x_result_out = OE_GLOBALS.G_WFR_ON_HOLD Then

9654: END IF;
9655: ROLLBACK TO HEADER_INVOICE_INTERFACE;
9656:
9657: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
9658: IF x_result_out = OE_GLOBALS.G_WFR_ON_HOLD Then
9659: l_flow_status_code := 'INVOICE_HOLD';
9660: ELSIF x_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN
9661: l_flow_status_code := 'INVOICE_INCOMPLETE';
9662: END IF;

Line 9660: ELSIF x_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN

9656:
9657: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
9658: IF x_result_out = OE_GLOBALS.G_WFR_ON_HOLD Then
9659: l_flow_status_code := 'INVOICE_HOLD';
9660: ELSIF x_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN
9661: l_flow_status_code := 'INVOICE_INCOMPLETE';
9662: END IF;
9663: Update_header_flow_status(p_header_id,l_flow_status_code);
9664: END IF;

Line 9684: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9680: ( p_count => x_msg_count
9681: , p_data => x_msg_data
9682: );
9683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9684: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9685: WHEN OTHERS THEN
9686: IF l_debug_level > 0 THEN
9687: oe_debug_pub.add( 'EXCEPTION OTHERS. EXIT FROM HEADER INVOICING' , 5 ) ;
9688: END IF;

Line 9706: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

9702: ( p_count => x_msg_count
9703: , p_data => x_msg_data
9704: );
9705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9706: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9707:
9708: END Interface_Header;
9709: Procedure Any_Line_ARInterfaced( p_application_id IN NUMBER,
9710: p_entity_short_name in VARCHAR2,