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 FND_API

Line 198: IF p_line_rec.service_start_date IS NULL OR p_line_rec.service_start_date = FND_API.G_MISS_DATE THEN

194: ||' p_line_rec.service_end_date = '|| TO_CHAR ( P_LINE_REC.SERVICE_END_DATE , 'YYYY/MM/DD' )
195: ) ;
196: END IF;
197:
198: IF p_line_rec.service_start_date IS NULL OR p_line_rec.service_start_date = FND_API.G_MISS_DATE THEN
199: l_line_rec := p_line_rec;
200: l_line_rec.service_start_date := NULL;
201: l_line_rec.service_reference_type_code := 'GET_SVC_START';
202: OE_SERVICE_UTIL.Get_Service_Duration(

Line 221: ELSIF p_line_rec.service_end_date IS NULL OR p_line_rec.service_end_date = FND_API.G_MISS_DATE THEN

217: );
218: oe_debug_pub.add(' l_return_status == '||l_return_status);
219: END IF;
220:
221: ELSIF p_line_rec.service_end_date IS NULL OR p_line_rec.service_end_date = FND_API.G_MISS_DATE THEN
222:
223: OE_SERVICE_UTIL.Get_Service_Duration(
224: p_x_line_rec => p_line_rec,
225: x_return_status => l_return_status

Line 487: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

483: , p_reference_line_id => p_line_rec.service_reference_line_id
484: , p_customer_id => p_line_rec.sold_to_org_id
485: , x_cust_product_line_id => l_order_line_id
486: );
487: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
488: IF l_debug_level > 0 THEN
489: oe_debug_pub.add( 'SERVICE LINE ID IS ' || L_ORDER_LINE_ID ) ;
490: END IF;
491: l_service_reference_line_id := l_order_line_id;

Line 604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

600: RETURN TRUE;
601:
602: EXCEPTION
603: WHEN NO_DATA_FOUND THEN
604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
605: --RAISE FND_API.G_EXC_ERROR;
606: WHEN OTHERS THEN
607: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
608: THEN

Line 605: --RAISE FND_API.G_EXC_ERROR;

601:
602: EXCEPTION
603: WHEN NO_DATA_FOUND THEN
604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
605: --RAISE FND_API.G_EXC_ERROR;
606: WHEN OTHERS THEN
607: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
608: THEN
609: IF l_debug_level > 0 THEN

Line 646: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND

642: x_result_out => l_hold_result_out,
643: x_return_status => l_hold_return_status,
644: x_msg_count => l_hold_msg_count,
645: x_msg_data => l_hold_msg_data);
646: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND
647: l_hold_result_out = FND_API.G_TRUE )
648: THEN
649: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');
650: OE_MSG_PUB.ADD;

Line 647: l_hold_result_out = FND_API.G_TRUE )

643: x_return_status => l_hold_return_status,
644: x_msg_count => l_hold_msg_count,
645: x_msg_data => l_hold_msg_data);
646: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND
647: l_hold_result_out = FND_API.G_TRUE )
648: THEN
649: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');
650: OE_MSG_PUB.ADD;
651: x_return_status := FND_API.G_RET_STS_ERROR;

Line 651: x_return_status := FND_API.G_RET_STS_ERROR;

647: l_hold_result_out = FND_API.G_TRUE )
648: THEN
649: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');
650: OE_MSG_PUB.ADD;
651: x_return_status := FND_API.G_RET_STS_ERROR;
652: IF l_debug_level > 0 THEN
653: oe_debug_pub.add( 'A Line level Invoicing hold or generic hold found ( 1 ) , Return status : '||X_RETURN_STATUS , 1 ) ;
654: END IF;
655: RETURN;

Line 657: x_return_status := FND_API.G_RET_STS_SUCCESS;

653: oe_debug_pub.add( 'A Line level Invoicing hold or generic hold found ( 1 ) , Return status : '||X_RETURN_STATUS , 1 ) ;
654: END IF;
655: RETURN;
656: ELSE
657: x_return_status := FND_API.G_RET_STS_SUCCESS;
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,

Line 669: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND

665: x_return_status => l_hold_return_status,
666: x_msg_count => l_hold_msg_count,
667: x_msg_data => l_hold_msg_data);
668:
669: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND
670: l_hold_result_out = FND_API.G_TRUE )
671: THEN
672: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');
673: OE_MSG_PUB.ADD;

Line 670: l_hold_result_out = FND_API.G_TRUE )

666: x_msg_count => l_hold_msg_count,
667: x_msg_data => l_hold_msg_data);
668:
669: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND
670: l_hold_result_out = FND_API.G_TRUE )
671: THEN
672: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');
673: OE_MSG_PUB.ADD;
674: x_return_status := FND_API.G_RET_STS_ERROR;

Line 674: x_return_status := FND_API.G_RET_STS_ERROR;

670: l_hold_result_out = FND_API.G_TRUE )
671: THEN
672: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');
673: OE_MSG_PUB.ADD;
674: x_return_status := FND_API.G_RET_STS_ERROR;
675: IF l_debug_level > 0 THEN
676: oe_debug_pub.add( 'A Header level Invoicing hold or generic hold found ( 2 ) , Return status '||X_RETURN_STATUS , 1 ) ;
677: END IF;
678: RETURN;

Line 680: x_return_status := FND_API.G_RET_STS_SUCCESS;

676: oe_debug_pub.add( 'A Header level Invoicing hold or generic hold found ( 2 ) , Return status '||X_RETURN_STATUS , 1 ) ;
677: END IF;
678: RETURN;
679: ELSE
680: x_return_status := FND_API.G_RET_STS_SUCCESS;
681: END IF;
682: -- END IF;
683: IF l_debug_level > 0 THEN
684: oe_debug_pub.add( 'NO HOLDS FOUND FOR THIS LINE ( 3 ) , RETURN STATUS '||X_RETURN_STATUS , 1 ) ;

Line 688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

684: oe_debug_pub.add( 'NO HOLDS FOUND FOR THIS LINE ( 3 ) , RETURN STATUS '||X_RETURN_STATUS , 1 ) ;
685: END IF;
686: EXCEPTION
687: WHEN OTHERS THEN
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: IF FND_MSG_PUB.Check_Msg_Level
690: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
691: THEN
692: IF l_debug_level > 0 THEN

Line 894: AND p_line_rec.line_type_id <> FND_API.G_MISS_NUM ) THEN

890: END IF;
891: IF (l_inv_cust_trx_type_id = 0 or x_credit_memo_type_id = 0)THEN
892: --use cache instead of SQL for bug 4200055
893: IF ( p_line_rec.line_type_id is not null
894: AND p_line_rec.line_type_id <> FND_API.G_MISS_NUM ) THEN
895: if (OE_Order_Cache.g_line_type_rec.line_type_id <> p_line_rec.Line_Type_id) THEN
896: OE_Order_Cache.Load_Line_type(p_line_rec.Line_Type_id) ;
897: end if ;
898: if (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_rec.Line_Type_id )

Line 1209: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1205: , p_reference_line_id => p_line_rec.service_reference_line_id
1206: , p_customer_id => p_line_rec.sold_to_org_id
1207: , x_cust_product_line_id => l_order_line_id
1208: );
1209: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1210: IF l_debug_level > 0 THEN
1211: oe_debug_pub.add( 'SERVICE LINE ID IS : ' || L_ORDER_LINE_ID , 5 ) ;
1212: END IF;
1213: l_service_reference_line_id := l_order_line_id;

Line 1513: AND p_line_rec.line_type_id <> FND_API.G_MISS_NUM

1509: END IF;
1510:
1511: --use cache instead of SQL for bug 4200055
1512: IF ( p_line_rec.line_type_id is not null
1513: AND p_line_rec.line_type_id <> FND_API.G_MISS_NUM
1514: AND OE_Order_Cache.g_line_type_rec.line_type_id <> p_line_rec.Line_Type_id) THEN
1515: OE_Order_Cache.Load_Line_type(p_line_rec.Line_Type_id) ;
1516: END IF ; -- end
1517:

Line 2624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2620: IF l_debug_level > 0 THEN
2621: oe_debug_pub.add( 'EXITING QUERY_LINE_SCREDITS' , 5 ) ;
2622: END IF;
2623: EXCEPTION
2624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2626: WHEN OTHERS THEN
2627: IF l_debug_level > 0 THEN
2628: oe_debug_pub.add( 'EXCEPTION , QUERY LINE SALES CREDITS '||SQLERRM , 1 ) ;

Line 2625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2621: oe_debug_pub.add( 'EXITING QUERY_LINE_SCREDITS' , 5 ) ;
2622: END IF;
2623: EXCEPTION
2624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2626: WHEN OTHERS THEN
2627: IF l_debug_level > 0 THEN
2628: oe_debug_pub.add( 'EXCEPTION , QUERY LINE SALES CREDITS '||SQLERRM , 1 ) ;
2629: END IF;

Line 2637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2633: ( G_PKG_NAME
2634: , 'Query_Line_Scredits'
2635: );
2636: END IF;
2637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2638: END Query_Line_Scredits;
2639:
2640: PROCEDURE Query_Header_Scredits
2641: ( p_header_id IN NUMBER

Line 2742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2738: IF l_debug_level > 0 THEN
2739: oe_debug_pub.add( 'EXITING QUERY_HEADER_SCREDITS ( ) ' , 5 ) ;
2740: END IF;
2741: EXCEPTION
2742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2744: WHEN OTHERS THEN
2745: IF l_debug_level > 0 THEN
2746: oe_debug_pub.add( 'EXCEPTION , QUERY HEADER SALES CREDITS ( ) ' , 5 ) ;

Line 2743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2739: oe_debug_pub.add( 'EXITING QUERY_HEADER_SCREDITS ( ) ' , 5 ) ;
2740: END IF;
2741: EXCEPTION
2742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2744: WHEN OTHERS THEN
2745: IF l_debug_level > 0 THEN
2746: oe_debug_pub.add( 'EXCEPTION , QUERY HEADER SALES CREDITS ( ) ' , 5 ) ;
2747: END IF;

Line 2755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2751: ( G_PKG_NAME
2752: , 'Query_Header_Scredits'
2753: );
2754: END IF;
2755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2756: END Query_Header_Scredits;
2757:
2758: PROCEDURE Insert_Line
2759: ( p_interface_line_rec IN RA_interface_Lines_Rec_Type

Line 3376: x_return_status := FND_API.G_RET_STS_SUCCESS;

3372: ,l_rowid;
3373: END IF;
3374: /* END PREPAYMENT */
3375: -- Fix for the bug 2187074
3376: x_return_status := FND_API.G_RET_STS_SUCCESS;
3377: IF l_debug_level > 0 THEN
3378: oe_debug_pub.add( 'EXIT INSERT_LINE ( ) PROCEDURE' , 1 ) ;
3379: END IF;
3380: EXCEPTION

Line 3395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3391: END IF;
3392: /* fix for 2140223, do not raise hard error, but capture error in debug log */
3393: -- raise_application_error(-20101, 'Failing while inserting into ra_interface_lines');
3394: -- Fix for the bug 2187074
3395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3396: END Insert_Line;
3397:
3398: PROCEDURE Prepare_Salescredit_rec
3399: ( p_line_scredit_rec IN OE_Order_Pub.Line_Scredit_Rec_Type

Line 3911: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

3907: ,p_reference_line_id => p_line_rec.service_reference_line_id
3908: ,p_customer_id => p_line_rec.sold_to_org_id
3909: ,x_cust_product_line_id=> l_order_line_id
3910: );
3911: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3912: IF l_debug_level > 0 THEN
3913: oe_debug_pub.add( 'CUSTOMER PRODUCT LINE ID -> ' || L_ORDER_LINE_ID , 5 ) ;
3914: END IF;
3915: l_service_reference_line_id := l_order_line_id;

Line 4045: x_return_status := FND_API.G_RET_STS_SUCCESS;

4041: Insert_Header_Scredits_Flag := 'N';
4042: END IF;
4043: END IF;
4044: END LOOP;
4045: x_return_status := FND_API.G_RET_STS_SUCCESS;
4046: IF l_debug_level > 0 THEN
4047: oe_debug_pub.add( 'INTERFACE_SALES_CREDITS ( ) PROCDURE SUCCESS : '||X_RETURN_STATUS , 1 ) ;
4048: END IF;
4049: EXCEPTION

Line 4054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4050: WHEN OTHERS THEN
4051: IF l_debug_level > 0 THEN
4052: oe_debug_pub.add( 'EXCEPTION INTERFACE_SALES_CREDITS ( ) '||SQLERRM , 1 ) ;
4053: END IF;
4054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4055: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4056: THEN
4057: OE_MSG_PUB.Add_Exc_Msg
4058: ( G_PKG_NAME

Line 4323: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

4319: , x_return_status OUT NOCOPY VARCHAR2
4320: )
4321: IS
4322: l_interface_conts_rec RA_Interface_Conts_Rec_Type;
4323: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4324: --
4325: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4326: --
4327: BEGIN

Line 4366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4362: WHEN OTHERS THEN
4363: IF l_debug_level > 0 THEN
4364: oe_debug_pub.add( 'EXCEPTION INTERFACE_CONTINGENCIES ( ) '||SQLERRM , 1 ) ;
4365: END IF;
4366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4367: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4368: THEN
4369: OE_MSG_PUB.Add_Exc_Msg
4370: ( G_PKG_NAME

Line 4670: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4666:
4667: Insert_Line(l_discounts_rec
4668: ,x_return_status=>l_return_status);
4669: -- Fix for the bug 2187074
4670: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4672: END IF;
4673:
4674: -- Populate salescredits for discount lines

Line 4671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4667: Insert_Line(l_discounts_rec
4668: ,x_return_status=>l_return_status);
4669: -- Fix for the bug 2187074
4670: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4672: END IF;
4673:
4674: -- Populate salescredits for discount lines
4675: Interface_Salescredits(p_line_rec

Line 4678: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4674: -- Populate salescredits for discount lines
4675: Interface_Salescredits(p_line_rec
4676: ,l_discounts_rec
4677: ,l_return_status);
4678: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4680: END IF;
4681:
4682: --Customer Acceptance

Line 4679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4675: Interface_Salescredits(p_line_rec
4676: ,l_discounts_rec
4677: ,l_return_status);
4678: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4680: END IF;
4681:
4682: --Customer Acceptance
4683: Interface_Contingencies

Line 4689: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4685: , p_interface_line_rec => l_discounts_rec
4686: , x_return_status => l_return_status
4687: );
4688:
4689: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4691: END IF;
4692: --Customer Acceptance
4693: END LOOP;

Line 4690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4686: , x_return_status => l_return_status
4687: );
4688:
4689: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4691: END IF;
4692: --Customer Acceptance
4693: END LOOP;
4694: END IF;

Line 4696: x_return_status := FND_API.G_RET_STS_SUCCESS;

4692: --Customer Acceptance
4693: END LOOP;
4694: END IF;
4695: -- Fix for the bug 2187074
4696: x_return_status := FND_API.G_RET_STS_SUCCESS;
4697: IF l_debug_level > 0 THEN
4698: oe_debug_pub.add( 'EXITING INTERFACE_DETAIL_DISCOUNTS ( ) PROCEDURE ' , 5 ) ;
4699: END IF;
4700:

Line 4707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4703: IF l_debug_level > 0 THEN
4704: oe_debug_pub.add( 'EXCEPTION IN INTERFACE_DETAIL_DISCOUNTS '||SQLERRM , 1 ) ;
4705: END IF;
4706: -- Fix for the bug 2187074
4707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4708: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4709: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Interface_Detail_Discounts');
4710: END IF;
4711:

Line 4736: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

4732: OE_Header_Adj_Util.Lock_Rows
4733: (P_PRICE_ADJUSTMENT_ID=>p_price_adjustment_id,
4734: X_HEADER_ADJ_TBL=>l_old_header_adj_tbl,
4735: X_RETURN_STATUS => l_return_status);
4736: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4737: RAISE FND_API.G_EXC_ERROR;
4738: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4740: END IF;

Line 4737: RAISE FND_API.G_EXC_ERROR;

4733: (P_PRICE_ADJUSTMENT_ID=>p_price_adjustment_id,
4734: X_HEADER_ADJ_TBL=>l_old_header_adj_tbl,
4735: X_RETURN_STATUS => l_return_status);
4736: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4737: RAISE FND_API.G_EXC_ERROR;
4738: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4740: END IF;
4741: l_Header_Adj_tbl := l_old_Header_Adj_Tbl;

Line 4738: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4734: X_HEADER_ADJ_TBL=>l_old_header_adj_tbl,
4735: X_RETURN_STATUS => l_return_status);
4736: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4737: RAISE FND_API.G_EXC_ERROR;
4738: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4740: END IF;
4741: l_Header_Adj_tbl := l_old_Header_Adj_Tbl;
4742:

Line 4739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4735: X_RETURN_STATUS => l_return_status);
4736: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4737: RAISE FND_API.G_EXC_ERROR;
4738: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4740: END IF;
4741: l_Header_Adj_tbl := l_old_Header_Adj_Tbl;
4742:
4743: oe_debug_pub.add('Charges Amount '||p_adjusted_amount);

Line 4768: x_return_status := FND_API.G_RET_STS_SUCCESS;

4764: , LOCK_CONTROL = LOCK_CONTROL + 1
4765: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id;
4766: End If;
4767:
4768: x_return_status := FND_API.G_RET_STS_SUCCESS;
4769: l_Header_Adj_tbl(1).Invoiced_Flag := 'Y';
4770: l_Header_Adj_tbl(1).lock_control := l_Header_Adj_tbl(1).lock_control + 1;
4771:
4772: -- jolin start

Line 4812: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

4808: oe_debug_pub.add( 'GLOBAL HDR ADJ LOCK_CONTROL IS: ' || OE_ORDER_UTIL.G_HEADER_ADJ_TBL ( L_NOTIFY_INDEX ) .LOCK_CONTROL , 1 ) ;
4809:
4810: END IF;
4811:
4812: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4814: END IF;
4815:
4816: -- Process requests is TRUE so still need to call it, but don't need to notify

Line 4813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4809:
4810: END IF;
4811:
4812: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4814: END IF;
4815:
4816: -- Process requests is TRUE so still need to call it, but don't need to notify
4817: IF l_debug_level > 0 THEN

Line 4827: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

4823: P_PROCESS_REQUESTS => TRUE,
4824: P_NOTIFY => FALSE,
4825: X_RETURN_STATUS => l_return_status);
4826:
4827: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4829: END IF;
4830:
4831: END IF ; /* global entity index null check */

Line 4828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4824: P_NOTIFY => FALSE,
4825: X_RETURN_STATUS => l_return_status);
4826:
4827: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4829: END IF;
4830:
4831: END IF ; /* global entity index null check */
4832:

Line 4845: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

4841: P_PROCESS_REQUESTS => TRUE,
4842: P_NOTIFY => TRUE,
4843: X_RETURN_STATUS => l_return_status);
4844:
4845: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4847: END IF;
4848:
4849: END IF; /* code set is pack H or higher */

Line 4846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4842: P_NOTIFY => TRUE,
4843: X_RETURN_STATUS => l_return_status);
4844:
4845: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4847: END IF;
4848:
4849: END IF; /* code set is pack H or higher */
4850: /* jolin end*/

Line 4858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4854: END IF;
4855:
4856: EXCEPTION
4857: WHEN OTHERS THEN
4858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4859: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4860: THEN
4861: OE_MSG_PUB.Add_Exc_Msg
4862: ( G_PKG_NAME

Line 4971: RAISE FND_API.G_EXC_ERROR;

4967: FND_MESSAGE.SET_NAME('ONT','ONT_FREIGHT_ITEM_REQUIRED');
4968: OE_MSG_PUB.ADD;
4969: END IF;
4970:
4971: RAISE FND_API.G_EXC_ERROR;
4972: END;
4973:
4974: IF l_freight_as_line = 'Y' THEN
4975: IF l_freight_item IS NULL THEN

Line 5273: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5269: ELSE
5270: Insert_Line(l_charges_rec
5271: ,x_return_status=>l_return_status);
5272: -- Fix for the bug 2187074
5273: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5275: END IF;
5276:
5277: IF l_charges_rec.line_type = 'LINE' THEN

Line 5274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5270: Insert_Line(l_charges_rec
5271: ,x_return_status=>l_return_status);
5272: -- Fix for the bug 2187074
5273: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5275: END IF;
5276:
5277: IF l_charges_rec.line_type = 'LINE' THEN
5278: Interface_scredits_for_freight

Line 5302: x_return_status := FND_API.G_RET_STS_SUCCESS;

5298: IF l_debug_level > 0 THEN
5299: oe_debug_pub.add( 'FOUND CONFIG LINE : '||CONFIG_LINE_ID , 1 ) ;
5300: END IF;
5301: -- Initialize API return status to success
5302: x_return_status := FND_API.G_RET_STS_SUCCESS;
5303: OE_Line_Util.Lock_Row(p_line_id=>config_line_id
5304: , p_x_line_rec => l_line_rec
5305: , x_return_status => l_return_status
5306: );

Line 5307: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5303: OE_Line_Util.Lock_Row(p_line_id=>config_line_id
5304: , p_x_line_rec => l_line_rec
5305: , x_return_status => l_return_status
5306: );
5307: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5308: IF l_debug_level > 0 THEN
5309: oe_debug_pub.add( 'UNABLE TO LOCK LINE ID '||CONFIG_LINE_ID||' '||SQLERRM , 1 ) ;
5310: END IF;
5311: RAISE FND_API.G_EXC_ERROR;

Line 5311: RAISE FND_API.G_EXC_ERROR;

5307: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5308: IF l_debug_level > 0 THEN
5309: oe_debug_pub.add( 'UNABLE TO LOCK LINE ID '||CONFIG_LINE_ID||' '||SQLERRM , 1 ) ;
5310: END IF;
5311: RAISE FND_API.G_EXC_ERROR;
5312: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5313: IF l_debug_level > 0 THEN
5314: oe_debug_pub.add( 'UNABLE TO LOCK LINE ID '||CONFIG_LINE_ID||' '||SQLERRM , 1 ) ;
5315: END IF;

Line 5312: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5308: IF l_debug_level > 0 THEN
5309: oe_debug_pub.add( 'UNABLE TO LOCK LINE ID '||CONFIG_LINE_ID||' '||SQLERRM , 1 ) ;
5310: END IF;
5311: RAISE FND_API.G_EXC_ERROR;
5312: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5313: IF l_debug_level > 0 THEN
5314: oe_debug_pub.add( 'UNABLE TO LOCK LINE ID '||CONFIG_LINE_ID||' '||SQLERRM , 1 ) ;
5315: END IF;
5316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5312: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5313: IF l_debug_level > 0 THEN
5314: oe_debug_pub.add( 'UNABLE TO LOCK LINE ID '||CONFIG_LINE_ID||' '||SQLERRM , 1 ) ;
5315: END IF;
5316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5317: END IF;
5318: IF l_debug_level > 0 THEN
5319: oe_debug_pub.add( 'INTERFACING OTHER CHARGES ASSOCIATED WITH THIS MODEL..' , 1 ) ;
5320: END IF;

Line 5369: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5365: ELSE
5366: Insert_Line(l_charges_rec
5367: ,x_return_status=>l_return_status);
5368: -- Fix for the bug 2187074
5369: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5371: END IF;
5372:
5373: /* Added for the bug 3019754 */

Line 5370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5366: Insert_Line(l_charges_rec
5367: ,x_return_status=>l_return_status);
5368: -- Fix for the bug 2187074
5369: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5371: END IF;
5372:
5373: /* Added for the bug 3019754 */
5374: IF l_charges_rec.line_type = 'LINE' THEN

Line 5462: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5458: ELSE
5459: Insert_Line(l_charges_rec
5460: ,x_return_status=>l_return_status);
5461: -- Fix for the bug 2187074
5462: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5464: END IF;
5465:
5466: IF l_charges_rec.line_type = 'LINE' THEN

Line 5463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5459: Insert_Line(l_charges_rec
5460: ,x_return_status=>l_return_status);
5461: -- Fix for the bug 2187074
5462: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5464: END IF;
5465:
5466: IF l_charges_rec.line_type = 'LINE' THEN
5467: Interface_scredits_for_freight

Line 5480: x_return_status := FND_API.G_RET_STS_SUCCESS;

5476: ,l_return_status);
5477: END IF;
5478: END LOOP;
5479: CLOSE Header_Charges_Cursor;
5480: x_return_status := FND_API.G_RET_STS_SUCCESS;
5481:
5482: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
5483: IF l_debug_level > 0 THEN
5484: oe_debug_pub.add( 'INTERFACING Modified HEADER CHARGES...' , 1 ) ;

Line 5568: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5564: ELSE
5565: Insert_Line(l_charges_rec
5566: ,x_return_status=>l_return_status);
5567: -- Fix for the bug 2187074
5568: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5570: END IF;
5571:
5572: IF l_charges_rec.line_type = 'LINE' THEN

Line 5569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5565: Insert_Line(l_charges_rec
5566: ,x_return_status=>l_return_status);
5567: -- Fix for the bug 2187074
5568: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5570: END IF;
5571:
5572: IF l_charges_rec.line_type = 'LINE' THEN
5573: Interface_scredits_for_freight

Line 5586: x_return_status := FND_API.G_RET_STS_SUCCESS;

5582: ,l_return_status);
5583: END IF;
5584: END LOOP;
5585: CLOSE Modified_Header_Charges_Cursor;
5586: x_return_status := FND_API.G_RET_STS_SUCCESS;
5587: END IF;
5588: IF l_debug_level > 0 THEN
5589: oe_debug_pub.add( 'EXITING INTERFACE_FREIGHT_CHARGES' , 5 ) ;
5590: END IF;

Line 5592: WHEN FND_API.G_EXC_ERROR THEN

5588: IF l_debug_level > 0 THEN
5589: oe_debug_pub.add( 'EXITING INTERFACE_FREIGHT_CHARGES' , 5 ) ;
5590: END IF;
5591: EXCEPTION
5592: WHEN FND_API.G_EXC_ERROR THEN
5593: IF l_debug_level > 0 THEN
5594: oe_debug_pub.add( 'EXPECTED ERROR. EXITING INTERFACE_FREIGHT_CHARGES : '||SQLERRM , 1 ) ;
5595: END IF;
5596: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5596: x_return_status := FND_API.G_RET_STS_ERROR;

5592: WHEN FND_API.G_EXC_ERROR THEN
5593: IF l_debug_level > 0 THEN
5594: oe_debug_pub.add( 'EXPECTED ERROR. EXITING INTERFACE_FREIGHT_CHARGES : '||SQLERRM , 1 ) ;
5595: END IF;
5596: x_return_status := FND_API.G_RET_STS_ERROR;
5597: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN -- Bug #3686558
5598: IF l_debug_level > 0 THEN
5599: OE_DEBUG_PUB.Add('Unable to lock the line',3);
5600: END IF;

Line 5601: x_return_status := FND_API.G_RET_STS_SUCCESS;

5597: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN -- Bug #3686558
5598: IF l_debug_level > 0 THEN
5599: OE_DEBUG_PUB.Add('Unable to lock the line',3);
5600: END IF;
5601: x_return_status := FND_API.G_RET_STS_SUCCESS;
5602: WHEN OTHERS THEN
5603: IF l_debug_level > 0 THEN
5604: oe_debug_pub.add( 'EXCEPTION , INTERFACE_FREIGHT_CHARGES ( ) '||SQLERRM , 1 ) ;
5605: END IF;

Line 5606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5602: WHEN OTHERS THEN
5603: IF l_debug_level > 0 THEN
5604: oe_debug_pub.add( 'EXCEPTION , INTERFACE_FREIGHT_CHARGES ( ) '||SQLERRM , 1 ) ;
5605: END IF;
5606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5607: IF FND_MSG_PUB.Check_Msg_Level
5608: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5609: THEN
5610: OE_MSG_PUB.Add_Exc_Msg

Line 5679: l_fulfillment_set_flag VARCHAR2(1) := FND_API.G_FALSE;

5675: l_credit_card_approval_code VARCHAR2(80);
5676: --serla end
5677: l_trx_date DATE;
5678: l_max_actual_shipment_date DATE;
5679: l_fulfillment_set_flag VARCHAR2(1) := FND_API.G_FALSE;
5680: -- 3757279
5681: l_concat_segment VARCHAR2(240) := NULL;
5682: l_prof_value VARCHAR2(240) := NULL;
5683: l_table_index BINARY_INTEGER;

Line 5980: IF l_fulfillment_set_flag = FND_API.G_TRUE THEN

5976: -- for non-shippable line in a fulfillment set
5977: l_fulfillment_set_flag
5978: := OE_Line_Fullfill.Is_Part_Of_Fulfillment_Set
5979: (p_line_rec.line_id);
5980: IF l_fulfillment_set_flag = FND_API.G_TRUE THEN
5981: IF l_debug_level > 0 THEN
5982: oe_debug_pub.add( 'SETTING TRANSACTION DATE AS THE ACTUAL_SHIPMENT_DATE OF THE LAST SHIPPED ITEM IN THE SET. ' , 5 ) ;
5983: END IF;
5984:

Line 6206: AND p_line_rec.user_item_description <> FND_API.G_MISS_CHAR THEN

6202:
6203: -- bug 2509121.
6204: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509'
6205: AND p_line_rec.user_item_description IS NOT NULL
6206: AND p_line_rec.user_item_description <> FND_API.G_MISS_CHAR THEN
6207: p_x_interface_line_rec.translated_description := p_line_rec.user_item_description;
6208: END IF;
6209:
6210: -- Commenting if condition for bug# 4063920

Line 6893: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

6889: EXCEPTION
6890: WHEN OTHERS THEN
6891: l_parent_line_id := NULL;
6892: END;
6893: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6894: l_parent_line_id := l_order_line_id;
6895: ELSE
6896: FND_MESSAGE.SET_NAME('ONT','ONT_NO_CUST_PROD_LINE');
6897: OE_MSG_PUB.ADD;

Line 7563: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

7559: oe_debug_pub.add( 'UPDATE_GLOBAL RET_STATUS FOR LINE_ID '||L_LINE_TBL ( 1 ) .LINE_ID ||' IS: ' || L_RETURN_STATUS , 1 ) ;
7560: oe_debug_pub.add( 'UPDATE_GLOBAL INDEX FOR LINE_ID '||L_LINE_TBL ( 1 ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
7561: END IF;
7562:
7563: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
7564: RAISE FND_API.G_EXC_ERROR;
7565: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7567: END IF;

Line 7564: RAISE FND_API.G_EXC_ERROR;

7560: oe_debug_pub.add( 'UPDATE_GLOBAL INDEX FOR LINE_ID '||L_LINE_TBL ( 1 ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
7561: END IF;
7562:
7563: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
7564: RAISE FND_API.G_EXC_ERROR;
7565: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7567: END IF;
7568:

Line 7565: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

7561: END IF;
7562:
7563: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
7564: RAISE FND_API.G_EXC_ERROR;
7565: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7567: END IF;
7568:
7569: IF l_notify_index is not null then

Line 7566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7562:
7563: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
7564: RAISE FND_API.G_EXC_ERROR;
7565: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7567: END IF;
7568:
7569: IF l_notify_index is not null then
7570: -- modify Global Picture

Line 7609: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

7605: P_NOTIFY => FALSE,
7606: P_PROCESS_ACK => FALSE,
7607: X_RETURN_STATUS => l_return_status);
7608:
7609: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7611: END IF;
7612:
7613: END IF ; /* global entity index null check */

Line 7610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7606: P_PROCESS_ACK => FALSE,
7607: X_RETURN_STATUS => l_return_status);
7608:
7609: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7611: END IF;
7612:
7613: END IF ; /* global entity index null check */
7614:

Line 7628: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

7624: P_NOTIFY => TRUE,
7625: P_PROCESS_ACK => FALSE,
7626: X_RETURN_STATUS => l_return_status);
7627:
7628: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7630: END IF;
7631:
7632: END IF; /* code set is pack H or higher */

Line 7629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7625: P_PROCESS_ACK => FALSE,
7626: X_RETURN_STATUS => l_return_status);
7627:
7628: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7630: END IF;
7631:
7632: END IF; /* code set is pack H or higher */
7633: /* jolin end*/

Line 7637: x_return_status := FND_API.G_RET_STS_SUCCESS;

7633: /* jolin end*/
7634:
7635: END IF;
7636:
7637: x_return_status := FND_API.G_RET_STS_SUCCESS;
7638:
7639: IF l_debug_level > 0 THEN
7640: oe_debug_pub.add( 'RETURN STATUS : ' ||X_RETURN_STATUS ) ;
7641: END IF;

Line 7669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7665: err_msg := 'Error in Update_Invoice_Attributes:\n '||SQLERRM;
7666: IF l_debug_level > 0 THEN
7667: oe_debug_pub.add( ERR_MSG ) ;
7668: END IF;
7669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7670: IF FND_MSG_PUB.Check_Msg_Level
7671: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7672: THEN
7673: OE_MSG_PUB.Add_Exc_Msg

Line 7832: x_return_status := FND_API.G_RET_STS_SUCCESS;

7828: IF l_count = 0 THEN
7829: IF l_debug_level > 0 THEN
7830: oe_debug_pub.add( 'NO LINES NEED MANUAL NUMBERING' , 5 ) ;
7831: END IF;
7832: x_return_status := FND_API.G_RET_STS_SUCCESS;
7833: RETURN;
7834: END IF;
7835: -- Get all the group by columns from ra_group_by_columns table
7836: -- and build up the select and group by column clauses.

Line 7902: x_return_status := FND_API.G_RET_STS_SUCCESS;

7898: IF l_debug_level > 0 THEN
7899: oe_debug_pub.add( 'CONCAT COLS CHANGED , CALLING UPDATE_INVOICE' ) ;
7900: END IF;
7901: IF ( Update_Invoice_Numbers ( this_del_id, this_del_name) < 0 ) THEN
7902: x_return_status := FND_API.G_RET_STS_SUCCESS;
7903: RETURN;
7904: END IF;
7905: last_del_name := this_del_name;
7906: last_concat_cols := this_concat_cols;

Line 7913: x_return_status := FND_API.G_RET_STS_SUCCESS;

7909: IF l_debug_level > 0 THEN
7910: oe_debug_pub.add( 'DEL NAME CHANGED , CALLING UPDATE_INVOICE' ) ;
7911: END IF;
7912: IF ( update_invoice_numbers ( this_del_id, this_del_name) < 0 ) THEN
7913: x_return_status := FND_API.G_RET_STS_SUCCESS;
7914: RETURN;
7915: END IF;
7916: last_del_name := this_del_name;
7917: END IF;

Line 7933: x_return_status := FND_API.G_RET_STS_SUCCESS;

7929: END IF;
7930: update ra_interface_lines_all
7931: set request_id=null
7932: where request_id = -1 * p_id;
7933: x_return_status := FND_API.G_RET_STS_SUCCESS;
7934: IF l_debug_level > 0 THEN
7935: oe_debug_pub.add( 'EXITING UPDATE_NUMBERS ( ) PROCEDURE' , 5 ) ;
7936: END IF;
7937: RETURN;

Line 7947: x_return_status := FND_API.G_RET_STS_ERROR;

7943: err_msg := 'Error in update_numbers:\n '|| SQLERRM;
7944: IF l_debug_level > 0 THEN
7945: oe_debug_pub.add( ERR_MSG ) ;
7946: END IF;
7947: x_return_status := FND_API.G_RET_STS_ERROR;
7948: IF (cur_get_cols%ISOPEN) THEN
7949: CLOSE cur_get_cols;
7950: END IF;
7951: IF (cur_get_del_id%ISOPEN) THEN

Line 8001: x_return_status := FND_API.G_RET_STS_SUCCESS;

7997: IF l_debug_level > 0 THEN
7998: oe_debug_pub.add( 'ENTERING INTERFACE_SINGLE_LINE ( ) PROCEDURE' , 5 ) ;
7999: oe_debug_pub.add( 'INTERFACING LINE ID '||TO_CHAR ( P_LINE_REC.LINE_ID ) , 1 ) ;
8000: END IF;
8001: x_return_status := FND_API.G_RET_STS_SUCCESS;
8002: --Customer Acceptance
8003: l_line_invoiceable := Line_Invoiceable(p_line_rec);
8004: l_line_rejected := Line_Rejected(p_line_rec);
8005:

Line 8054: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

8050: oe_debug_pub.add('l_freight_count: '||l_freight_count);
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;

Line 8056: RAISE FND_API.G_EXC_ERROR;

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;
8060: END IF;

Line 8057: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR 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;
8060: END IF;
8061: END IF; */

Line 8059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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*/
8063:

Line 8068: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

8064: Update_Invoice_Attributes(p_line_rec
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;

Line 8070: RAISE FND_API.G_EXC_ERROR;

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;
8074: END IF;

Line 8071: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
8074: END IF;
8075: --- Eventhough line is not eligible for invoicing, there might be some other

Line 8073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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.
8077: --- Ex: Included Items are not invoiceable but due to RFR, there might be

Line 8105: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

8101: ,x_result_out => x_result_out);
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;

Line 8107: RAISE FND_API.G_EXC_ERROR;

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;
8111: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 8108: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
8111: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8112: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN

Line 8110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
8114: oe_debug_pub.add( 'RFR PENDING LINE PARTIALLY INTERFACED' , 5 ) ;

Line 8111: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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
8114: oe_debug_pub.add( 'RFR PENDING LINE PARTIALLY INTERFACED' , 5 ) ;
8115: END IF;

Line 8189: RAISE FND_API.G_EXC_ERROR;

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 ) ;
8193: END IF;

Line 8202: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

8198: END IF; -- for freight
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;

Line 8204: RAISE FND_API.G_EXC_ERROR;

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;
8208: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 8205: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
8208: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8209: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;

Line 8207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
8211: oe_debug_pub.add( 'RETURN AFTER INVOICEABLE ELIGIBLE CHECK' , 1 ) ;

Line 8208: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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
8211: oe_debug_pub.add( 'RETURN AFTER INVOICEABLE ELIGIBLE CHECK' , 1 ) ;
8212: END IF;

Line 8252: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

8248: END IF;
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;

Line 8254: RAISE FND_API.G_EXC_ERROR;

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;
8258: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 8255: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
8258: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8259: IF l_result_code = 'RFR-PENDING' THEN

Line 8257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
8261: IF l_debug_level > 0 THEN

Line 8258: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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;
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 ) ;

Line 8280: RAISE FND_API.G_EXC_ERROR;

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 ) ;
8284: END IF;

Line 8288: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

8284: END IF;
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:

Line 8290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
8294: -- Adjustments need not be queried here as it is anyway going to be queried in interface_detail_discounts

Line 8302: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

8298: END IF;
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;

Line 8304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
8308: oe_debug_pub.add( 'INTERFACING FREIGHT CHARGES' , 5 ) ;

Line 8313: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

8309: END IF;
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;

Line 8315: RAISE FND_API.G_EXC_ERROR;

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;
8319: END IF;

Line 8316: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
8319: END IF;
8320: IF l_debug_level > 0 THEN

Line 8318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 ) ;
8322: END IF;

Line 8326: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

8322: END IF;
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;

Line 8328: RAISE FND_API.G_EXC_ERROR;

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;
8332: END IF;

Line 8329: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
8332: END IF;
8333:

Line 8331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
8335: IF l_debug_level > 0 THEN

Line 8344: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

8340: , p_interface_line_rec => p_x_interface_line_rec
8341: , x_return_status => x_return_status
8342: );
8343:
8344: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8346: END IF;
8347: --Customer Acceptance
8348:

Line 8345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8341: , x_return_status => x_return_status
8342: );
8343:
8344: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8346: END IF;
8347: --Customer Acceptance
8348:
8349: IF l_debug_level > 0 THEN

Line 8370: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

8366: END IF;
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;

Line 8372: RAISE FND_API.G_EXC_ERROR;

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;
8376: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 8373: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
8376: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8377: IF l_result_code = 'RFR-PENDING' THEN

Line 8375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
8379: IF l_debug_level > 0 THEN

Line 8376: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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;
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 ) ;

Line 8394: WHEN FND_API.G_EXC_ERROR THEN

8390: IF l_debug_level > 0 THEN
8391: oe_debug_pub.add( 'EXIT INTERFACE_SINGLE_LINE ( ) PROCEDURE SUCCESSFULLY' , 1 ) ;
8392: END IF;
8393: EXCEPTION
8394: WHEN FND_API.G_EXC_ERROR THEN
8395: IF l_debug_level > 0 THEN
8396: oe_debug_pub.add( 'EXPECTED ERROR. EXITING INTERFACE_SINGLE_LINE : '||SQLERRM , 1 ) ;
8397: END IF;
8398: x_return_status := FND_API.G_RET_STS_ERROR;

Line 8398: x_return_status := FND_API.G_RET_STS_ERROR;

8394: WHEN FND_API.G_EXC_ERROR THEN
8395: IF l_debug_level > 0 THEN
8396: oe_debug_pub.add( 'EXPECTED ERROR. EXITING INTERFACE_SINGLE_LINE : '||SQLERRM , 1 ) ;
8397: END IF;
8398: x_return_status := FND_API.G_RET_STS_ERROR;
8399: IF l_debug_level > 0 THEN
8400: oe_debug_pub.add( 'RETURN STATUS :'||X_RETURN_STATUS||' OUT RESULT : '||X_RESULT_OUT , 5 ) ;
8401: END IF;
8402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 8402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8398: x_return_status := FND_API.G_RET_STS_ERROR;
8399: IF l_debug_level > 0 THEN
8400: oe_debug_pub.add( 'RETURN STATUS :'||X_RETURN_STATUS||' OUT RESULT : '||X_RESULT_OUT , 5 ) ;
8401: END IF;
8402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8403: IF l_debug_level > 0 THEN
8404: oe_debug_pub.add( 'UNEXPECTED ERROR. EXITING INTERFACE_SINGLE_LINE '||SQLERRM , 1 ) ;
8405: oe_debug_pub.add( 'RETURN STATUS :'||X_RETURN_STATUS||' OUT RESULT : '||X_RESULT_OUT , 5 ) ;
8406: END IF;

Line 8407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8403: IF l_debug_level > 0 THEN
8404: oe_debug_pub.add( 'UNEXPECTED ERROR. EXITING INTERFACE_SINGLE_LINE '||SQLERRM , 1 ) ;
8405: oe_debug_pub.add( 'RETURN STATUS :'||X_RETURN_STATUS||' OUT RESULT : '||X_RESULT_OUT , 5 ) ;
8406: END IF;
8407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8408: WHEN OTHERS THEN
8409: IF l_debug_level > 0 THEN
8410: oe_debug_pub.add( 'OTHER EXCEPTION. EXITING INTERFACE_SINGLE_LINE : '||SQLERRM , 1 ) ;
8411: oe_debug_pub.add( 'RETURN STATUS :'||X_RETURN_STATUS||' OUT RESULT : '||X_RESULT_OUT , 5 ) ;

Line 8419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8415: ( G_PKG_NAME
8416: , 'Interface_Single_line'
8417: );
8418: END IF;
8419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8420: END Interface_Single_line;
8421:
8422: PROCEDURE Interface_Line
8423: ( p_line_id IN NUMBER

Line 8528: x_return_status := FND_API.G_RET_STS_SUCCESS;

8524: ,p_line_id => p_line_id ); */
8525: --Exception management end
8526:
8527: -- Initialize API return status to success
8528: x_return_status := FND_API.G_RET_STS_SUCCESS;
8529: G_ITEMTYPE := p_itemtype;
8530:
8531: --bug 5336623
8532: oe_line_util.Query_Row

Line 8543: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

8539: /* OE_Line_Util.Lock_Row(p_line_id=>p_line_id
8540: , p_x_line_rec => l_line_rec
8541: , x_return_status => l_return_status
8542: );
8543: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8544: RAISE FND_API.G_EXC_ERROR;
8545: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8547: END IF; */

Line 8544: RAISE FND_API.G_EXC_ERROR;

8540: , p_x_line_rec => l_line_rec
8541: , x_return_status => l_return_status
8542: );
8543: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8544: RAISE FND_API.G_EXC_ERROR;
8545: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8547: END IF; */
8548:

Line 8545: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

8541: , x_return_status => l_return_status
8542: );
8543: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8544: RAISE FND_API.G_EXC_ERROR;
8545: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8547: END IF; */
8548:
8549: --bug 5336623 Moved the following call to OE_Header_Util.Query_row after the line is locked

Line 8546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8542: );
8543: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8544: RAISE FND_API.G_EXC_ERROR;
8545: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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);

Line 8587: x_return_status := FND_API.G_RET_STS_ERROR;

8583: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
8584: IF l_debug_level > 0 THEN
8585: oe_debug_pub.add('in lock record exception, someone else working on the row');
8586: END IF;
8587: x_return_status := FND_API.G_RET_STS_ERROR;
8588: l_line_rec.return_status := FND_API.G_RET_STS_ERROR;
8589: l_line_rec.line_id := null;
8590: FND_MESSAGE.Set_Name('ONT', 'OE_LINE_LOCKED');
8591: OE_MSG_PUB.Add;

Line 8588: l_line_rec.return_status := FND_API.G_RET_STS_ERROR;

8584: IF l_debug_level > 0 THEN
8585: oe_debug_pub.add('in lock record exception, someone else working on the row');
8586: END IF;
8587: x_return_status := FND_API.G_RET_STS_ERROR;
8588: l_line_rec.return_status := FND_API.G_RET_STS_ERROR;
8589: l_line_rec.line_id := null;
8590: FND_MESSAGE.Set_Name('ONT', 'OE_LINE_LOCKED');
8591: OE_MSG_PUB.Add;
8592: RAISE FND_API.G_EXC_ERROR;

Line 8592: RAISE FND_API.G_EXC_ERROR;

8588: l_line_rec.return_status := FND_API.G_RET_STS_ERROR;
8589: l_line_rec.line_id := null;
8590: FND_MESSAGE.Set_Name('ONT', 'OE_LINE_LOCKED');
8591: OE_MSG_PUB.Add;
8592: RAISE FND_API.G_EXC_ERROR;
8593: */
8594:
8595: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
8596: IF l_debug_level > 0 THEN

Line 8617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8613: WHEN NO_DATA_FOUND THEN
8614: IF l_debug_level > 0 THEN
8615: oe_debug_pub.add('no_data_found, record lock exception');
8616: END IF;
8617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8618:
8619: WHEN OTHERS THEN
8620: IF l_debug_level > 0 THEN
8621: oe_debug_pub.add('record lock exception, others');

Line 8624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8620: IF l_debug_level > 0 THEN
8621: oe_debug_pub.add('record lock exception, others');
8622: oe_debug_pub.add('line id '|| v_line_id , 1);
8623: END IF;
8624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8625: END;
8626: OE_Header_Util.Query_row(p_header_id=>l_line_rec.header_id,x_header_rec=>l_header_rec);
8627: --bug 5336623
8628:

Line 8664: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

8660: oe_debug_pub.add('acceptance not required. item_type:'||l_line_rec.item_type_code);
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;

Line 8666: RAISE FND_API.G_EXC_ERROR;

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;
8670: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 8667: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
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

Line 8669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
8673: END IF;

Line 8670: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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;
8673: END IF;
8674: END IF;

Line 8728: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

8724: oe_debug_pub.add('l_freight_count: '||l_freight_count);
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;

Line 8730: RAISE FND_API.G_EXC_ERROR;

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;
8734: END IF;

Line 8731: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR 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;
8734: END IF;
8735: END IF;

Line 8733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
8737: /* Bug#2666125 end-check freight records and holds for non invoiceable items*/

Line 8746: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

8742: Update_Invoice_Attributes(l_line_rec
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;

Line 8748: RAISE FND_API.G_EXC_ERROR;

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;
8752: END IF;

Line 8749: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
8752: END IF;
8753: --- Eventhough line is not eligible for invoicing, there might be some other

Line 8751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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.
8755: --- Ex: Included Items are not invoiceable but due to RFR, there might be

Line 8783: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

8779: ,x_result_out => x_result_out);
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;

Line 8785: RAISE FND_API.G_EXC_ERROR;

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;
8789: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 8786: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
8789: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8790: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN

Line 8788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
8792: oe_debug_pub.add( 'RFR PENDING LINE PARTIALLY INTERFACED' , 5 ) ;

Line 8789: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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
8792: oe_debug_pub.add( 'RFR PENDING LINE PARTIALLY INTERFACED' , 5 ) ;
8793: END IF;

Line 8864: RAISE FND_API.G_EXC_ERROR;

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 ) ;
8868: END IF;

Line 8876: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

8872: /* START Enhancement Request# 1915736 */
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;

Line 8878: RAISE FND_API.G_EXC_ERROR;

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;
8882: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 8879: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
8882: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8883: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;

Line 8881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
8885: oe_debug_pub.add( 'RETURN AFTER INVOICEABLE ELIGIBLE CHECK' , 1 ) ;

Line 8882: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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
8885: oe_debug_pub.add( 'RETURN AFTER INVOICEABLE ELIGIBLE CHECK' , 1 ) ;
8886: END IF;

Line 8899: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

8895: END IF; --freight_count zero or automatic numbering
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;

Line 8901: RAISE FND_API.G_EXC_ERROR;

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;
8905: END IF;

Line 8902: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
8905: END IF;
8906: IF FND_PROFILE.VALUE('WSH_INVOICE_NUMBERING_METHOD') = 'D' THEN

Line 8904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
8908: oe_debug_pub.add( 'INVOICE NUMBERING SET TO MANUAL' , 5 ) ;

Line 9083: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

9079: IF l_debug_level > 0 THEN
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;

Line 9085: RAISE FND_API.G_EXC_ERROR;

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;
9089: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 9086: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
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

Line 9088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
9092: END IF;

Line 9089: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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;
9092: END IF;
9093: ELSE -- header level invoice, all delivery lines are not ready to invoice. do not honor delivery.

Line 9208: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

9204: -- if this line can only invoice partial, it will become RFR-PENDING while interfacing whatever it can
9205: -- x_result_out should have set appropriately
9206: oe_debug_pub.add( 'AFTER INTERFACE SINGLE LINE , RESULT_OUT IS ' || X_RESULT_OUT ||': And x_return_status:'||x_return_status, 5 ) ;
9207: END IF;
9208: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9209: RAISE FND_API.G_EXC_ERROR;
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

Line 9209: RAISE FND_API.G_EXC_ERROR;

9205: -- x_result_out should have set appropriately
9206: oe_debug_pub.add( 'AFTER INTERFACE SINGLE LINE , RESULT_OUT IS ' || X_RESULT_OUT ||': And x_return_status:'||x_return_status, 5 ) ;
9207: END IF;
9208: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9209: RAISE FND_API.G_EXC_ERROR;
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

Line 9210: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

9206: oe_debug_pub.add( 'AFTER INTERFACE SINGLE LINE , RESULT_OUT IS ' || X_RESULT_OUT ||': And x_return_status:'||x_return_status, 5 ) ;
9207: END IF;
9208: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9209: RAISE FND_API.G_EXC_ERROR;
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

Line 9211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9207: END IF;
9208: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9209: RAISE FND_API.G_EXC_ERROR;
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

Line 9212: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

9208: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9209: RAISE FND_API.G_EXC_ERROR;
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

Line 9252: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

9248: IF l_debug_level > 0 THEN
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;

Line 9254: RAISE FND_API.G_EXC_ERROR;

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;
9258: --bug# 4094835

Line 9255: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
9258: --bug# 4094835
9259: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 9257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
9261: IF l_debug_level > 0 THEN

Line 9259: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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;
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;

Line 9275: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

9271: ,x_result_out => x_result_out);
9272: IF l_debug_level > 0 THEN
9273: oe_debug_pub.add( 'INTERFACED W/REQUEST_ID : '||L_INTERFACE_LINE_REC.REQUEST_ID , 5 ) ;
9274: END IF;
9275: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9276: RAISE FND_API.G_EXC_ERROR;
9277: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9279: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 9276: RAISE FND_API.G_EXC_ERROR;

9272: IF l_debug_level > 0 THEN
9273: oe_debug_pub.add( 'INTERFACED W/REQUEST_ID : '||L_INTERFACE_LINE_REC.REQUEST_ID , 5 ) ;
9274: END IF;
9275: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9276: RAISE FND_API.G_EXC_ERROR;
9277: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9279: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9280: IF l_debug_level > 0 THEN

Line 9277: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

9273: oe_debug_pub.add( 'INTERFACED W/REQUEST_ID : '||L_INTERFACE_LINE_REC.REQUEST_ID , 5 ) ;
9274: END IF;
9275: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9276: RAISE FND_API.G_EXC_ERROR;
9277: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9279: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9280: IF l_debug_level > 0 THEN
9281: oe_debug_pub.add( 'L_LINE_ID: '||L_LINE_ID||' P_LINE_ID: '||P_LINE_ID|| ' INVOICE_INTERFACE_STATUS_CODE: '||L_LINE_REC.INVOICE_INTERFACE_STATUS_CODE , 5 ) ;

Line 9278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9274: END IF;
9275: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9276: RAISE FND_API.G_EXC_ERROR;
9277: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9279: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9280: IF l_debug_level > 0 THEN
9281: oe_debug_pub.add( 'L_LINE_ID: '||L_LINE_ID||' P_LINE_ID: '||P_LINE_ID|| ' INVOICE_INTERFACE_STATUS_CODE: '||L_LINE_REC.INVOICE_INTERFACE_STATUS_CODE , 5 ) ;
9282: END IF;

Line 9279: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

9275: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9276: RAISE FND_API.G_EXC_ERROR;
9277: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9279: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9280: IF l_debug_level > 0 THEN
9281: oe_debug_pub.add( 'L_LINE_ID: '||L_LINE_ID||' P_LINE_ID: '||P_LINE_ID|| ' INVOICE_INTERFACE_STATUS_CODE: '||L_LINE_REC.INVOICE_INTERFACE_STATUS_CODE , 5 ) ;
9282: END IF;
9283: IF l_old_interface_status_code = 'MANUAL-PENDING' THEN

Line 9370: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

9366: END IF;
9367: IF l_debug_level > 0 THEN
9368: oe_debug_pub.add( 'INTERFACED W/REQUEST_ID : '||L_INTERFACE_LINE_REC.REQUEST_ID || ' X_RETURN_STATUS: '|| X_RETURN_STATUS , 5 ) ;
9369: END IF;
9370: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9371: RAISE FND_API.G_EXC_ERROR;
9372: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9374: END IF;

Line 9371: RAISE FND_API.G_EXC_ERROR;

9367: IF l_debug_level > 0 THEN
9368: oe_debug_pub.add( 'INTERFACED W/REQUEST_ID : '||L_INTERFACE_LINE_REC.REQUEST_ID || ' X_RETURN_STATUS: '|| X_RETURN_STATUS , 5 ) ;
9369: END IF;
9370: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9371: RAISE FND_API.G_EXC_ERROR;
9372: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9374: END IF;
9375: -- if this line is RFR and there are lines waiting for it, interface those lines

Line 9372: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

9368: oe_debug_pub.add( 'INTERFACED W/REQUEST_ID : '||L_INTERFACE_LINE_REC.REQUEST_ID || ' X_RETURN_STATUS: '|| X_RETURN_STATUS , 5 ) ;
9369: END IF;
9370: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9371: RAISE FND_API.G_EXC_ERROR;
9372: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9374: END IF;
9375: -- if this line is RFR and there are lines waiting for it, interface those lines
9376: IF Is_PTO(l_line_rec) THEN

Line 9373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9369: END IF;
9370: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9371: RAISE FND_API.G_EXC_ERROR;
9372: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9374: END IF;
9375: -- if this line is RFR and there are lines waiting for it, interface those lines
9376: IF Is_PTO(l_line_rec) THEN
9377: IF Is_RFR(l_line_rec.line_id) THEN

Line 9403: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

9399: ,x_result_out => x_result_out);
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;

Line 9405: RAISE FND_API.G_EXC_ERROR;

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;
9409: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 9406: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
9409: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9410: IF x_result_out = OE_GLOBALS.G_WFR_PRTL_COMPLETE THEN

Line 9408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
9412: oe_debug_pub.add( 'RFR: RFR-PENDING LINE PARTIALLY INTERFACED' , 5 ) ;

Line 9409: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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
9412: oe_debug_pub.add( 'RFR: RFR-PENDING LINE PARTIALLY INTERFACED' , 5 ) ;
9413: END IF;

Line 9424: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

9420: END IF;
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 ) ;

Line 9439: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

9435: END IF;
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;

Line 9441: RAISE FND_API.G_EXC_ERROR;

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;
9445: ELSE

Line 9442: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
9445: ELSE
9446: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;

Line 9444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
9448: oe_debug_pub.add( 'RFR: UPDATE NUMBER DONE FOR RFR-PENDING LINE ( CURRENT LINE IS RFR ) ' , 5 ) ;

Line 9463: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

9459: close Pending_Lines;
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

Line 9479: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

9475: END IF;
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;

Line 9481: RAISE FND_API.G_EXC_ERROR;

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;
9485: ELSE

Line 9482: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
9485: ELSE
9486: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;

Line 9484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
9488: oe_debug_pub.add( 'EXITING INTERFACE_LINE' , 5 ) ;

Line 9503: WHEN FND_API.G_EXC_ERROR THEN

9499: END IF;
9500: END IF;
9501: END IF;
9502: EXCEPTION
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

Line 9524: x_return_status := FND_API.G_RET_STS_ERROR;

9520: OE_MSG_PUB.Count_And_Get
9521: ( p_count => x_msg_count
9522: , p_data => x_msg_data
9523: );
9524: x_return_status := FND_API.G_RET_STS_ERROR;
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;

Line 9525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9521: ( p_count => x_msg_count
9522: , p_data => x_msg_data
9523: );
9524: x_return_status := FND_API.G_RET_STS_ERROR;
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

Line 9536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9532: OE_MSG_PUB.Count_And_Get
9533: ( p_count => x_msg_count
9534: , p_data => x_msg_data
9535: );
9536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9537: WHEN OTHERS THEN
9538: IF l_debug_level > 0 THEN
9539: oe_debug_pub.add( 'EXCEPTION , OTHERS. EXITING FROM LINE INVOICING : '||SQLERRM , 1 ) ;
9540: END IF;

Line 9562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9558: OE_MSG_PUB.Count_And_Get
9559: ( p_count => x_msg_count
9560: , p_data => x_msg_data
9561: );
9562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9563: END Interface_Line;
9564:
9565: PROCEDURE Interface_Header
9566: ( p_header_id IN NUMBER

Line 9591: x_return_status := FND_API.G_RET_STS_SUCCESS;

9587: oe_debug_pub.add( 'ENTER INTERFACE_HEADER ( ) PROCEDURE' , 5 ) ;
9588: END IF;
9589: SAVEPOINT HEADER_INVOICE_INTERFACE;
9590: -- Initialize API return status to success
9591: x_return_status := FND_API.G_RET_STS_SUCCESS;
9592:
9593: -- Header_Invoicing_Validation
9594: OPEN order_line_cursor;
9595: LOOP

Line 9602: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

9598: IF l_debug_level > 0 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;

Line 9608: RAISE FND_API.G_EXC_ERROR;

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;
9611: ELSE
9612: IF l_debug_level > 0 THEN

Line 9609: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
9611: ELSE
9612: IF l_debug_level > 0 THEN
9613: oe_debug_pub.add( 'CONTINUE WITH NEXT LINE IF THIS IS NOT LAST ONE' , 5 ) ;

Line 9610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
9611: ELSE
9612: IF l_debug_level > 0 THEN
9613: oe_debug_pub.add( 'CONTINUE WITH NEXT LINE IF THIS IS NOT LAST ONE' , 5 ) ;
9614: END IF;

Line 9625: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

9621: Update_Numbers(p_header_id, x_return_status);
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;

Line 9627: RAISE FND_API.G_EXC_ERROR;

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
9631: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9628: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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
9631: x_return_status := FND_API.G_RET_STS_SUCCESS;
9632: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;

Line 9629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
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

Line 9631: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
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;

Line 9648: WHEN FND_API.G_EXC_ERROR THEN

9644: oe_debug_pub.add( 'EXITING INTERFACE_HEADER ( ) PROCEDURE' , 5 ) ;
9645: END IF;
9646:
9647: EXCEPTION
9648: WHEN FND_API.G_EXC_ERROR THEN
9649: IF l_debug_level > 0 THEN
9650: oe_debug_pub.add( 'EXPECTED ERROR. EXIT FROM HEADER INVOICING' , 5 ) ;
9651: END IF;
9652: IF (order_line_cursor%ISOPEN) THEN

Line 9670: x_return_status := FND_API.G_RET_STS_ERROR;

9666: OE_MSG_PUB.Count_And_Get
9667: ( p_count => x_msg_count
9668: , p_data => x_msg_data
9669: );
9670: x_return_status := FND_API.G_RET_STS_ERROR;
9671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9672: IF l_debug_level > 0 THEN
9673: oe_debug_pub.add( 'UNEXPECTED ERROR. EXITING FROM HEADER INVOICING' , 5 ) ;
9674: END IF;

Line 9671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9667: ( p_count => x_msg_count
9668: , p_data => x_msg_data
9669: );
9670: x_return_status := FND_API.G_RET_STS_ERROR;
9671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9672: IF l_debug_level > 0 THEN
9673: oe_debug_pub.add( 'UNEXPECTED ERROR. EXITING FROM HEADER INVOICING' , 5 ) ;
9674: END IF;
9675: IF (order_line_cursor%ISOPEN) THEN

Line 9683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9679: OE_MSG_PUB.Count_And_Get
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 ) ;

Line 9705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9701: OE_MSG_PUB.Count_And_Get
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,

Line 9734: l_header_id = FND_API.G_MISS_NUM

9730: l_header_id := oe_header_payment_security.g_record.header_id;
9731: END IF;
9732:
9733: IF l_header_id IS NULL OR
9734: l_header_id = FND_API.G_MISS_NUM
9735: THEN
9736: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
9737: p_result := 0;
9738: END IF;

Line 9818: l_header_id = FND_API.G_MISS_NUM

9814: -- 3740077
9815: END IF;
9816:
9817: IF l_header_id IS NULL OR
9818: l_header_id = FND_API.G_MISS_NUM
9819: THEN
9820: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
9821: p_result := 0;
9822: END IF;

Line 9825: l_header_id <> FND_API.G_MISS_NUM THEN

9821: p_result := 0;
9822: END IF;
9823:
9824: IF l_header_id is not null and
9825: l_header_id <> FND_API.G_MISS_NUM THEN
9826:
9827: BEGIN
9828: select 1 into l_lines_exist
9829: from oe_order_lines

Line 9894: l_line_id = FND_API.G_MISS_NUM

9890:
9891: oe_debug_pub.add(' Line Id :'||l_line_id);
9892:
9893: IF l_line_id IS NULL OR
9894: l_line_id = FND_API.G_MISS_NUM
9895: THEN
9896: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
9897: p_result := 0;
9898: END IF;