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 201: IF p_line_rec.service_start_date IS NULL OR p_line_rec.service_start_date = FND_API.G_MISS_DATE THEN

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

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

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

Line 264: p_line_rec.return_attribute2 <> FND_API.G_MISS_CHAR AND

260: oe_debug_pub.add('Entering Update_Credit_Invoice');
261: END IF;
262:
263: IF p_line_rec.return_attribute2 is NOT NULL AND
264: p_line_rec.return_attribute2 <> FND_API.G_MISS_CHAR AND
265: p_line_rec.Credit_Invoice_Line_Id IS NULL AND
266: p_line_rec.line_category_code = 'RETURN'
267: THEN
268: l_defaulting_invoice_line_id :=

Line 693: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

689: , p_reference_line_id => p_line_rec.service_reference_line_id
690: , p_customer_id => p_line_rec.sold_to_org_id
691: , x_cust_product_line_id => l_order_line_id
692: );
693: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
694: IF l_debug_level > 0 THEN
695: oe_debug_pub.add( 'SERVICE LINE ID IS ' || L_ORDER_LINE_ID ) ;
696: END IF;
697: l_service_reference_line_id := l_order_line_id;

Line 810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

806: RETURN TRUE;
807:
808: EXCEPTION
809: WHEN NO_DATA_FOUND THEN
810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
811: --RAISE FND_API.G_EXC_ERROR;
812: WHEN OTHERS THEN
813: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
814: THEN

Line 811: --RAISE FND_API.G_EXC_ERROR;

807:
808: EXCEPTION
809: WHEN NO_DATA_FOUND THEN
810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
811: --RAISE FND_API.G_EXC_ERROR;
812: WHEN OTHERS THEN
813: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
814: THEN
815: IF l_debug_level > 0 THEN

Line 852: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND

848: x_result_out => l_hold_result_out,
849: x_return_status => l_hold_return_status,
850: x_msg_count => l_hold_msg_count,
851: x_msg_data => l_hold_msg_data);
852: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND
853: l_hold_result_out = FND_API.G_TRUE )
854: THEN
855: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');
856: OE_MSG_PUB.ADD;

Line 853: l_hold_result_out = FND_API.G_TRUE )

849: x_return_status => l_hold_return_status,
850: x_msg_count => l_hold_msg_count,
851: x_msg_data => l_hold_msg_data);
852: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND
853: l_hold_result_out = FND_API.G_TRUE )
854: THEN
855: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');
856: OE_MSG_PUB.ADD;
857: x_return_status := FND_API.G_RET_STS_ERROR;

Line 857: x_return_status := FND_API.G_RET_STS_ERROR;

853: l_hold_result_out = FND_API.G_TRUE )
854: THEN
855: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');
856: OE_MSG_PUB.ADD;
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: IF l_debug_level > 0 THEN
859: oe_debug_pub.add( 'A Line level Invoicing hold or generic hold found ( 1 ) , Return status : '||X_RETURN_STATUS , 1 ) ;
860: END IF;
861: RETURN;

Line 863: x_return_status := FND_API.G_RET_STS_SUCCESS;

859: oe_debug_pub.add( 'A Line level Invoicing hold or generic hold found ( 1 ) , Return status : '||X_RETURN_STATUS , 1 ) ;
860: END IF;
861: RETURN;
862: ELSE
863: x_return_status := FND_API.G_RET_STS_SUCCESS;
864: END IF;
865: -- ELSIF p_itemtype = 'OEOH' THEN
866: OE_HOLDS_PUB.CHECK_HOLDS(p_api_version => 1.0,
867: p_line_id => p_line_rec.line_id,

Line 875: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND

871: x_return_status => l_hold_return_status,
872: x_msg_count => l_hold_msg_count,
873: x_msg_data => l_hold_msg_data);
874:
875: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND
876: l_hold_result_out = FND_API.G_TRUE )
877: THEN
878: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');
879: OE_MSG_PUB.ADD;

Line 876: l_hold_result_out = FND_API.G_TRUE )

872: x_msg_count => l_hold_msg_count,
873: x_msg_data => l_hold_msg_data);
874:
875: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND
876: l_hold_result_out = FND_API.G_TRUE )
877: THEN
878: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');
879: OE_MSG_PUB.ADD;
880: x_return_status := FND_API.G_RET_STS_ERROR;

Line 880: x_return_status := FND_API.G_RET_STS_ERROR;

876: l_hold_result_out = FND_API.G_TRUE )
877: THEN
878: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');
879: OE_MSG_PUB.ADD;
880: x_return_status := FND_API.G_RET_STS_ERROR;
881: IF l_debug_level > 0 THEN
882: oe_debug_pub.add( 'A Header level Invoicing hold or generic hold found ( 2 ) , Return status '||X_RETURN_STATUS , 1 ) ;
883: END IF;
884: RETURN;

Line 886: x_return_status := FND_API.G_RET_STS_SUCCESS;

882: oe_debug_pub.add( 'A Header level Invoicing hold or generic hold found ( 2 ) , Return status '||X_RETURN_STATUS , 1 ) ;
883: END IF;
884: RETURN;
885: ELSE
886: x_return_status := FND_API.G_RET_STS_SUCCESS;
887: END IF;
888: -- END IF;
889: IF l_debug_level > 0 THEN
890: oe_debug_pub.add( 'NO HOLDS FOUND FOR THIS LINE ( 3 ) , RETURN STATUS '||X_RETURN_STATUS , 1 ) ;

Line 894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

890: oe_debug_pub.add( 'NO HOLDS FOUND FOR THIS LINE ( 3 ) , RETURN STATUS '||X_RETURN_STATUS , 1 ) ;
891: END IF;
892: EXCEPTION
893: WHEN OTHERS THEN
894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
895: IF FND_MSG_PUB.Check_Msg_Level
896: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
897: THEN
898: IF l_debug_level > 0 THEN

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

1105: END IF;
1106: IF (l_inv_cust_trx_type_id = 0 or x_credit_memo_type_id = 0)THEN
1107: --use cache instead of SQL for bug 4200055
1108: IF ( p_line_rec.line_type_id is not null
1109: AND p_line_rec.line_type_id <> FND_API.G_MISS_NUM ) THEN
1110: if (OE_Order_Cache.g_line_type_rec.line_type_id <> p_line_rec.Line_Type_id) THEN
1111: OE_Order_Cache.Load_Line_type(p_line_rec.Line_Type_id) ;
1112: end if ;
1113: if (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_rec.Line_Type_id )

Line 1426: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1422: , p_reference_line_id => p_line_rec.service_reference_line_id
1423: , p_customer_id => p_line_rec.sold_to_org_id
1424: , x_cust_product_line_id => l_order_line_id
1425: );
1426: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1427: IF l_debug_level > 0 THEN
1428: oe_debug_pub.add( 'SERVICE LINE ID IS : ' || L_ORDER_LINE_ID , 5 ) ;
1429: END IF;
1430: l_service_reference_line_id := l_order_line_id;

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

1726: END IF;
1727:
1728: --use cache instead of SQL for bug 4200055
1729: IF ( p_line_rec.line_type_id is not null
1730: AND p_line_rec.line_type_id <> FND_API.G_MISS_NUM
1731: AND OE_Order_Cache.g_line_type_rec.line_type_id <> p_line_rec.Line_Type_id) THEN
1732: OE_Order_Cache.Load_Line_type(p_line_rec.Line_Type_id) ;
1733: END IF ; -- end
1734:

Line 2851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2847: IF l_debug_level > 0 THEN
2848: oe_debug_pub.add( 'EXITING QUERY_LINE_SCREDITS' , 5 ) ;
2849: END IF;
2850: EXCEPTION
2851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2853: WHEN OTHERS THEN
2854: IF l_debug_level > 0 THEN
2855: oe_debug_pub.add( 'EXCEPTION , QUERY LINE SALES CREDITS '||SQLERRM , 1 ) ;

Line 2852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2848: oe_debug_pub.add( 'EXITING QUERY_LINE_SCREDITS' , 5 ) ;
2849: END IF;
2850: EXCEPTION
2851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2853: WHEN OTHERS THEN
2854: IF l_debug_level > 0 THEN
2855: oe_debug_pub.add( 'EXCEPTION , QUERY LINE SALES CREDITS '||SQLERRM , 1 ) ;
2856: END IF;

Line 2864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2860: ( G_PKG_NAME
2861: , 'Query_Line_Scredits'
2862: );
2863: END IF;
2864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2865: END Query_Line_Scredits;
2866:
2867: PROCEDURE Query_Header_Scredits
2868: ( p_header_id IN NUMBER

Line 2969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2965: IF l_debug_level > 0 THEN
2966: oe_debug_pub.add( 'EXITING QUERY_HEADER_SCREDITS ( ) ' , 5 ) ;
2967: END IF;
2968: EXCEPTION
2969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2971: WHEN OTHERS THEN
2972: IF l_debug_level > 0 THEN
2973: oe_debug_pub.add( 'EXCEPTION , QUERY HEADER SALES CREDITS ( ) ' , 5 ) ;

Line 2970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2966: oe_debug_pub.add( 'EXITING QUERY_HEADER_SCREDITS ( ) ' , 5 ) ;
2967: END IF;
2968: EXCEPTION
2969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2971: WHEN OTHERS THEN
2972: IF l_debug_level > 0 THEN
2973: oe_debug_pub.add( 'EXCEPTION , QUERY HEADER SALES CREDITS ( ) ' , 5 ) ;
2974: END IF;

Line 2982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2978: ( G_PKG_NAME
2979: , 'Query_Header_Scredits'
2980: );
2981: END IF;
2982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2983: END Query_Header_Scredits;
2984:
2985: PROCEDURE Insert_Line
2986: ( p_interface_line_rec IN RA_interface_Lines_Rec_Type

Line 3605: x_return_status := FND_API.G_RET_STS_SUCCESS;

3601: ,l_rowid;
3602: END IF;
3603: /* END PREPAYMENT */
3604: -- Fix for the bug 2187074
3605: x_return_status := FND_API.G_RET_STS_SUCCESS;
3606: IF l_debug_level > 0 THEN
3607: oe_debug_pub.add( 'EXIT INSERT_LINE ( ) PROCEDURE' , 1 ) ;
3608: END IF;
3609: EXCEPTION

Line 3624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3620: END IF;
3621: /* fix for 2140223, do not raise hard error, but capture error in debug log */
3622: -- raise_application_error(-20101, 'Failing while inserting into ra_interface_lines');
3623: -- Fix for the bug 2187074
3624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3625: END Insert_Line;
3626:
3627: PROCEDURE Prepare_Salescredit_rec
3628: ( p_line_scredit_rec IN OE_Order_Pub.Line_Scredit_Rec_Type

Line 4140: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

4136: ,p_reference_line_id => p_line_rec.service_reference_line_id
4137: ,p_customer_id => p_line_rec.sold_to_org_id
4138: ,x_cust_product_line_id=> l_order_line_id
4139: );
4140: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4141: IF l_debug_level > 0 THEN
4142: oe_debug_pub.add( 'CUSTOMER PRODUCT LINE ID -> ' || L_ORDER_LINE_ID , 5 ) ;
4143: END IF;
4144: l_service_reference_line_id := l_order_line_id;

Line 4274: x_return_status := FND_API.G_RET_STS_SUCCESS;

4270: Insert_Header_Scredits_Flag := 'N';
4271: END IF;
4272: END IF;
4273: END LOOP;
4274: x_return_status := FND_API.G_RET_STS_SUCCESS;
4275: IF l_debug_level > 0 THEN
4276: oe_debug_pub.add( 'INTERFACE_SALES_CREDITS ( ) PROCDURE SUCCESS : '||X_RETURN_STATUS , 1 ) ;
4277: END IF;
4278: EXCEPTION

Line 4283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4279: WHEN OTHERS THEN
4280: IF l_debug_level > 0 THEN
4281: oe_debug_pub.add( 'EXCEPTION INTERFACE_SALES_CREDITS ( ) '||SQLERRM , 1 ) ;
4282: END IF;
4283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4284: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4285: THEN
4286: OE_MSG_PUB.Add_Exc_Msg
4287: ( G_PKG_NAME

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

4548: , x_return_status OUT NOCOPY VARCHAR2
4549: )
4550: IS
4551: l_interface_conts_rec RA_Interface_Conts_Rec_Type;
4552: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4553: --
4554: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4555: --
4556: BEGIN

Line 4595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4591: WHEN OTHERS THEN
4592: IF l_debug_level > 0 THEN
4593: oe_debug_pub.add( 'EXCEPTION INTERFACE_CONTINGENCIES ( ) '||SQLERRM , 1 ) ;
4594: END IF;
4595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4596: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4597: THEN
4598: OE_MSG_PUB.Add_Exc_Msg
4599: ( G_PKG_NAME

Line 4901: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4897:
4898: Insert_Line(l_discounts_rec
4899: ,x_return_status=>l_return_status);
4900: -- Fix for the bug 2187074
4901: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4903: END IF;
4904:
4905: -- Populate salescredits for discount lines

Line 4902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4898: Insert_Line(l_discounts_rec
4899: ,x_return_status=>l_return_status);
4900: -- Fix for the bug 2187074
4901: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4903: END IF;
4904:
4905: -- Populate salescredits for discount lines
4906: Interface_Salescredits(p_line_rec

Line 4909: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4905: -- Populate salescredits for discount lines
4906: Interface_Salescredits(p_line_rec
4907: ,l_discounts_rec
4908: ,l_return_status);
4909: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4911: END IF;
4912:
4913: --Customer Acceptance

Line 4910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4906: Interface_Salescredits(p_line_rec
4907: ,l_discounts_rec
4908: ,l_return_status);
4909: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4911: END IF;
4912:
4913: --Customer Acceptance
4914: Interface_Contingencies

Line 4920: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4916: , p_interface_line_rec => l_discounts_rec
4917: , x_return_status => l_return_status
4918: );
4919:
4920: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4922: END IF;
4923: --Customer Acceptance
4924: END LOOP;

Line 4921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4917: , x_return_status => l_return_status
4918: );
4919:
4920: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4922: END IF;
4923: --Customer Acceptance
4924: END LOOP;
4925: END IF;

Line 4927: x_return_status := FND_API.G_RET_STS_SUCCESS;

4923: --Customer Acceptance
4924: END LOOP;
4925: END IF;
4926: -- Fix for the bug 2187074
4927: x_return_status := FND_API.G_RET_STS_SUCCESS;
4928: IF l_debug_level > 0 THEN
4929: oe_debug_pub.add( 'EXITING INTERFACE_DETAIL_DISCOUNTS ( ) PROCEDURE ' , 5 ) ;
4930: END IF;
4931:

Line 4938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4934: IF l_debug_level > 0 THEN
4935: oe_debug_pub.add( 'EXCEPTION IN INTERFACE_DETAIL_DISCOUNTS '||SQLERRM , 1 ) ;
4936: END IF;
4937: -- Fix for the bug 2187074
4938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4939: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4940: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Interface_Detail_Discounts');
4941: END IF;
4942:

Line 4967: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

4963: OE_Header_Adj_Util.Lock_Rows
4964: (P_PRICE_ADJUSTMENT_ID=>p_price_adjustment_id,
4965: X_HEADER_ADJ_TBL=>l_old_header_adj_tbl,
4966: X_RETURN_STATUS => l_return_status);
4967: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4968: RAISE FND_API.G_EXC_ERROR;
4969: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4971: END IF;

Line 4968: RAISE FND_API.G_EXC_ERROR;

4964: (P_PRICE_ADJUSTMENT_ID=>p_price_adjustment_id,
4965: X_HEADER_ADJ_TBL=>l_old_header_adj_tbl,
4966: X_RETURN_STATUS => l_return_status);
4967: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4968: RAISE FND_API.G_EXC_ERROR;
4969: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4971: END IF;
4972: l_Header_Adj_tbl := l_old_Header_Adj_Tbl;

Line 4969: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4965: X_HEADER_ADJ_TBL=>l_old_header_adj_tbl,
4966: X_RETURN_STATUS => l_return_status);
4967: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4968: RAISE FND_API.G_EXC_ERROR;
4969: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4971: END IF;
4972: l_Header_Adj_tbl := l_old_Header_Adj_Tbl;
4973:

Line 4970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4966: X_RETURN_STATUS => l_return_status);
4967: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4968: RAISE FND_API.G_EXC_ERROR;
4969: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4971: END IF;
4972: l_Header_Adj_tbl := l_old_Header_Adj_Tbl;
4973:
4974: oe_debug_pub.add('Charges Amount '||p_adjusted_amount);

Line 4999: x_return_status := FND_API.G_RET_STS_SUCCESS;

4995: , LOCK_CONTROL = LOCK_CONTROL + 1
4996: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id;
4997: End If;
4998:
4999: x_return_status := FND_API.G_RET_STS_SUCCESS;
5000: l_Header_Adj_tbl(1).Invoiced_Flag := 'Y';
5001: l_Header_Adj_tbl(1).lock_control := l_Header_Adj_tbl(1).lock_control + 1;
5002:
5003: -- jolin start

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

5039: oe_debug_pub.add( 'GLOBAL HDR ADJ LOCK_CONTROL IS: ' || OE_ORDER_UTIL.G_HEADER_ADJ_TBL ( L_NOTIFY_INDEX ) .LOCK_CONTROL , 1 ) ;
5040:
5041: END IF;
5042:
5043: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5045: END IF;
5046:
5047: -- Process requests is TRUE so still need to call it, but don't need to notify

Line 5044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5040:
5041: END IF;
5042:
5043: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5045: END IF;
5046:
5047: -- Process requests is TRUE so still need to call it, but don't need to notify
5048: IF l_debug_level > 0 THEN

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

5054: P_PROCESS_REQUESTS => TRUE,
5055: P_NOTIFY => FALSE,
5056: X_RETURN_STATUS => l_return_status);
5057:
5058: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5060: END IF;
5061:
5062: END IF ; /* global entity index null check */

Line 5059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5055: P_NOTIFY => FALSE,
5056: X_RETURN_STATUS => l_return_status);
5057:
5058: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5060: END IF;
5061:
5062: END IF ; /* global entity index null check */
5063:

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

5072: P_PROCESS_REQUESTS => TRUE,
5073: P_NOTIFY => TRUE,
5074: X_RETURN_STATUS => l_return_status);
5075:
5076: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5078: END IF;
5079:
5080: END IF; /* code set is pack H or higher */

Line 5077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5073: P_NOTIFY => TRUE,
5074: X_RETURN_STATUS => l_return_status);
5075:
5076: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5078: END IF;
5079:
5080: END IF; /* code set is pack H or higher */
5081: /* jolin end*/

Line 5089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5085: END IF;
5086:
5087: EXCEPTION
5088: WHEN OTHERS THEN
5089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5090: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5091: THEN
5092: OE_MSG_PUB.Add_Exc_Msg
5093: ( G_PKG_NAME

Line 5202: RAISE FND_API.G_EXC_ERROR;

5198: FND_MESSAGE.SET_NAME('ONT','ONT_FREIGHT_ITEM_REQUIRED');
5199: OE_MSG_PUB.ADD;
5200: END IF;
5201:
5202: RAISE FND_API.G_EXC_ERROR;
5203: END;
5204:
5205: IF l_freight_as_line = 'Y' THEN
5206: IF l_freight_item IS NULL THEN

Line 5517: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5513: ELSE
5514: Insert_Line(l_charges_rec
5515: ,x_return_status=>l_return_status);
5516: -- Fix for the bug 2187074
5517: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5519: END IF;
5520:
5521: IF l_charges_rec.line_type = 'LINE' THEN

Line 5518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5514: Insert_Line(l_charges_rec
5515: ,x_return_status=>l_return_status);
5516: -- Fix for the bug 2187074
5517: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5519: END IF;
5520:
5521: IF l_charges_rec.line_type = 'LINE' THEN
5522: Interface_scredits_for_freight

Line 5546: x_return_status := FND_API.G_RET_STS_SUCCESS;

5542: IF l_debug_level > 0 THEN
5543: oe_debug_pub.add( 'FOUND CONFIG LINE : '||CONFIG_LINE_ID , 1 ) ;
5544: END IF;
5545: -- Initialize API return status to success
5546: x_return_status := FND_API.G_RET_STS_SUCCESS;
5547: OE_Line_Util.Lock_Row(p_line_id=>config_line_id
5548: , p_x_line_rec => l_line_rec
5549: , x_return_status => l_return_status
5550: );

Line 5551: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

5547: OE_Line_Util.Lock_Row(p_line_id=>config_line_id
5548: , p_x_line_rec => l_line_rec
5549: , x_return_status => l_return_status
5550: );
5551: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5552: IF l_debug_level > 0 THEN
5553: oe_debug_pub.add( 'UNABLE TO LOCK LINE ID '||CONFIG_LINE_ID||' '||SQLERRM , 1 ) ;
5554: END IF;
5555: RAISE FND_API.G_EXC_ERROR;

Line 5555: RAISE FND_API.G_EXC_ERROR;

5551: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5552: IF l_debug_level > 0 THEN
5553: oe_debug_pub.add( 'UNABLE TO LOCK LINE ID '||CONFIG_LINE_ID||' '||SQLERRM , 1 ) ;
5554: END IF;
5555: RAISE FND_API.G_EXC_ERROR;
5556: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5557: IF l_debug_level > 0 THEN
5558: oe_debug_pub.add( 'UNABLE TO LOCK LINE ID '||CONFIG_LINE_ID||' '||SQLERRM , 1 ) ;
5559: END IF;

Line 5556: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5552: IF l_debug_level > 0 THEN
5553: oe_debug_pub.add( 'UNABLE TO LOCK LINE ID '||CONFIG_LINE_ID||' '||SQLERRM , 1 ) ;
5554: END IF;
5555: RAISE FND_API.G_EXC_ERROR;
5556: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5557: IF l_debug_level > 0 THEN
5558: oe_debug_pub.add( 'UNABLE TO LOCK LINE ID '||CONFIG_LINE_ID||' '||SQLERRM , 1 ) ;
5559: END IF;
5560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5556: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5557: IF l_debug_level > 0 THEN
5558: oe_debug_pub.add( 'UNABLE TO LOCK LINE ID '||CONFIG_LINE_ID||' '||SQLERRM , 1 ) ;
5559: END IF;
5560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5561: END IF;
5562: IF l_debug_level > 0 THEN
5563: oe_debug_pub.add( 'INTERFACING OTHER CHARGES ASSOCIATED WITH THIS MODEL..' , 1 ) ;
5564: END IF;

Line 5613: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5609: ELSE
5610: Insert_Line(l_charges_rec
5611: ,x_return_status=>l_return_status);
5612: -- Fix for the bug 2187074
5613: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5615: END IF;
5616:
5617: /* Added for the bug 3019754 */

Line 5614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5610: Insert_Line(l_charges_rec
5611: ,x_return_status=>l_return_status);
5612: -- Fix for the bug 2187074
5613: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5615: END IF;
5616:
5617: /* Added for the bug 3019754 */
5618: IF l_charges_rec.line_type = 'LINE' THEN

Line 5706: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5702: ELSE
5703: Insert_Line(l_charges_rec
5704: ,x_return_status=>l_return_status);
5705: -- Fix for the bug 2187074
5706: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5708: END IF;
5709:
5710: IF l_charges_rec.line_type = 'LINE' THEN

Line 5707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5703: Insert_Line(l_charges_rec
5704: ,x_return_status=>l_return_status);
5705: -- Fix for the bug 2187074
5706: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5708: END IF;
5709:
5710: IF l_charges_rec.line_type = 'LINE' THEN
5711: Interface_scredits_for_freight

Line 5724: x_return_status := FND_API.G_RET_STS_SUCCESS;

5720: ,l_return_status);
5721: END IF;
5722: END LOOP;
5723: CLOSE Header_Charges_Cursor;
5724: x_return_status := FND_API.G_RET_STS_SUCCESS;
5725:
5726: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
5727: IF l_debug_level > 0 THEN
5728: oe_debug_pub.add( 'INTERFACING Modified HEADER CHARGES...' , 1 ) ;

Line 5812: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5808: ELSE
5809: Insert_Line(l_charges_rec
5810: ,x_return_status=>l_return_status);
5811: -- Fix for the bug 2187074
5812: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5814: END IF;
5815:
5816: IF l_charges_rec.line_type = 'LINE' THEN

Line 5813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5809: Insert_Line(l_charges_rec
5810: ,x_return_status=>l_return_status);
5811: -- Fix for the bug 2187074
5812: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5814: END IF;
5815:
5816: IF l_charges_rec.line_type = 'LINE' THEN
5817: Interface_scredits_for_freight

Line 5830: x_return_status := FND_API.G_RET_STS_SUCCESS;

5826: ,l_return_status);
5827: END IF;
5828: END LOOP;
5829: CLOSE Modified_Header_Charges_Cursor;
5830: x_return_status := FND_API.G_RET_STS_SUCCESS;
5831: END IF;
5832: IF l_debug_level > 0 THEN
5833: oe_debug_pub.add( 'EXITING INTERFACE_FREIGHT_CHARGES' , 5 ) ;
5834: END IF;

Line 5836: WHEN FND_API.G_EXC_ERROR THEN

5832: IF l_debug_level > 0 THEN
5833: oe_debug_pub.add( 'EXITING INTERFACE_FREIGHT_CHARGES' , 5 ) ;
5834: END IF;
5835: EXCEPTION
5836: WHEN FND_API.G_EXC_ERROR THEN
5837: IF l_debug_level > 0 THEN
5838: oe_debug_pub.add( 'EXPECTED ERROR. EXITING INTERFACE_FREIGHT_CHARGES : '||SQLERRM , 1 ) ;
5839: END IF;
5840: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5840: x_return_status := FND_API.G_RET_STS_ERROR;

5836: WHEN FND_API.G_EXC_ERROR THEN
5837: IF l_debug_level > 0 THEN
5838: oe_debug_pub.add( 'EXPECTED ERROR. EXITING INTERFACE_FREIGHT_CHARGES : '||SQLERRM , 1 ) ;
5839: END IF;
5840: x_return_status := FND_API.G_RET_STS_ERROR;
5841: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN -- Bug #3686558
5842: IF l_debug_level > 0 THEN
5843: OE_DEBUG_PUB.Add('Unable to lock the line',3);
5844: END IF;

Line 5845: x_return_status := FND_API.G_RET_STS_SUCCESS;

5841: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN -- Bug #3686558
5842: IF l_debug_level > 0 THEN
5843: OE_DEBUG_PUB.Add('Unable to lock the line',3);
5844: END IF;
5845: x_return_status := FND_API.G_RET_STS_SUCCESS;
5846: WHEN OTHERS THEN
5847: IF l_debug_level > 0 THEN
5848: oe_debug_pub.add( 'EXCEPTION , INTERFACE_FREIGHT_CHARGES ( ) '||SQLERRM , 1 ) ;
5849: END IF;

Line 5850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5846: WHEN OTHERS THEN
5847: IF l_debug_level > 0 THEN
5848: oe_debug_pub.add( 'EXCEPTION , INTERFACE_FREIGHT_CHARGES ( ) '||SQLERRM , 1 ) ;
5849: END IF;
5850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5851: IF FND_MSG_PUB.Check_Msg_Level
5852: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5853: THEN
5854: OE_MSG_PUB.Add_Exc_Msg

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

5919: l_credit_card_approval_code VARCHAR2(80);
5920: --serla end
5921: l_trx_date DATE;
5922: l_max_actual_shipment_date DATE;
5923: l_fulfillment_set_flag VARCHAR2(1) := FND_API.G_FALSE;
5924: -- 3757279
5925: l_concat_segment VARCHAR2(240) := NULL;
5926: l_prof_value VARCHAR2(240) := NULL;
5927: l_table_index BINARY_INTEGER;

Line 6225: IF l_fulfillment_set_flag = FND_API.G_TRUE THEN

6221: -- for non-shippable line in a fulfillment set
6222: l_fulfillment_set_flag
6223: := OE_Line_Fullfill.Is_Part_Of_Fulfillment_Set
6224: (p_line_rec.line_id);
6225: IF l_fulfillment_set_flag = FND_API.G_TRUE THEN
6226: IF l_debug_level > 0 THEN
6227: oe_debug_pub.add( 'SETTING TRANSACTION DATE AS THE ACTUAL_SHIPMENT_DATE OF THE LAST SHIPPED ITEM IN THE SET. ' , 5 ) ;
6228: END IF;
6229:

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

6460:
6461: -- bug 2509121.
6462: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509'
6463: AND p_line_rec.user_item_description IS NOT NULL
6464: AND p_line_rec.user_item_description <> FND_API.G_MISS_CHAR THEN
6465: p_x_interface_line_rec.translated_description := p_line_rec.user_item_description;
6466: END IF;
6467:
6468: -- Commenting if condition for bug# 4063920

Line 7178: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

7174: EXCEPTION
7175: WHEN OTHERS THEN
7176: l_parent_line_id := NULL;
7177: END;
7178: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
7179: l_parent_line_id := l_order_line_id;
7180: ELSE
7181: FND_MESSAGE.SET_NAME('ONT','ONT_NO_CUST_PROD_LINE');
7182: OE_MSG_PUB.ADD;

Line 7933: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

7929: oe_debug_pub.add( 'UPDATE_GLOBAL RET_STATUS FOR LINE_ID '||L_LINE_TBL ( 1 ) .LINE_ID ||' IS: ' || L_RETURN_STATUS , 1 ) ;
7930: oe_debug_pub.add( 'UPDATE_GLOBAL INDEX FOR LINE_ID '||L_LINE_TBL ( 1 ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
7931: END IF;
7932:
7933: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
7934: RAISE FND_API.G_EXC_ERROR;
7935: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7937: END IF;

Line 7934: RAISE FND_API.G_EXC_ERROR;

7930: oe_debug_pub.add( 'UPDATE_GLOBAL INDEX FOR LINE_ID '||L_LINE_TBL ( 1 ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
7931: END IF;
7932:
7933: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
7934: RAISE FND_API.G_EXC_ERROR;
7935: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7937: END IF;
7938:

Line 7935: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

7931: END IF;
7932:
7933: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
7934: RAISE FND_API.G_EXC_ERROR;
7935: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7937: END IF;
7938:
7939: IF l_notify_index is not null then

Line 7936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7932:
7933: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
7934: RAISE FND_API.G_EXC_ERROR;
7935: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7937: END IF;
7938:
7939: IF l_notify_index is not null then
7940: -- modify Global Picture

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

7975: P_NOTIFY => FALSE,
7976: P_PROCESS_ACK => FALSE,
7977: X_RETURN_STATUS => l_return_status);
7978:
7979: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7981: END IF;
7982:
7983: END IF ; /* global entity index null check */

Line 7980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7976: P_PROCESS_ACK => FALSE,
7977: X_RETURN_STATUS => l_return_status);
7978:
7979: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7981: END IF;
7982:
7983: END IF ; /* global entity index null check */
7984:

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

7994: P_NOTIFY => TRUE,
7995: P_PROCESS_ACK => FALSE,
7996: X_RETURN_STATUS => l_return_status);
7997:
7998: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7999: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8000: END IF;
8001:
8002: END IF; /* code set is pack H or higher */

Line 7999: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7995: P_PROCESS_ACK => FALSE,
7996: X_RETURN_STATUS => l_return_status);
7997:
7998: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7999: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8000: END IF;
8001:
8002: END IF; /* code set is pack H or higher */
8003: /* jolin end*/

Line 8007: x_return_status := FND_API.G_RET_STS_SUCCESS;

8003: /* jolin end*/
8004:
8005: END IF;
8006:
8007: x_return_status := FND_API.G_RET_STS_SUCCESS;
8008:
8009: IF l_debug_level > 0 THEN
8010: oe_debug_pub.add( 'RETURN STATUS : ' ||X_RETURN_STATUS ) ;
8011: END IF;

Line 8052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8048: err_msg := 'Error in Update_Invoice_Attributes:\n '||SQLERRM;
8049: IF l_debug_level > 0 THEN
8050: oe_debug_pub.add( ERR_MSG ) ;
8051: END IF;
8052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8053: IF FND_MSG_PUB.Check_Msg_Level
8054: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8055: THEN
8056: OE_MSG_PUB.Add_Exc_Msg

Line 8216: x_return_status := FND_API.G_RET_STS_SUCCESS;

8212: IF l_count = 0 THEN
8213: IF l_debug_level > 0 THEN
8214: oe_debug_pub.add( 'NO LINES NEED MANUAL NUMBERING' , 5 ) ;
8215: END IF;
8216: x_return_status := FND_API.G_RET_STS_SUCCESS;
8217: RETURN;
8218: END IF;
8219: -- Get all the group by columns from ra_group_by_columns table
8220: -- and build up the select and group by column clauses.

Line 8286: x_return_status := FND_API.G_RET_STS_SUCCESS;

8282: IF l_debug_level > 0 THEN
8283: oe_debug_pub.add( 'CONCAT COLS CHANGED , CALLING UPDATE_INVOICE' ) ;
8284: END IF;
8285: IF ( Update_Invoice_Numbers ( this_del_id, this_del_name) < 0 ) THEN
8286: x_return_status := FND_API.G_RET_STS_SUCCESS;
8287: RETURN;
8288: END IF;
8289: last_del_name := this_del_name;
8290: last_concat_cols := this_concat_cols;

Line 8297: x_return_status := FND_API.G_RET_STS_SUCCESS;

8293: IF l_debug_level > 0 THEN
8294: oe_debug_pub.add( 'DEL NAME CHANGED , CALLING UPDATE_INVOICE' ) ;
8295: END IF;
8296: IF ( update_invoice_numbers ( this_del_id, this_del_name) < 0 ) THEN
8297: x_return_status := FND_API.G_RET_STS_SUCCESS;
8298: RETURN;
8299: END IF;
8300: last_del_name := this_del_name;
8301: END IF;

Line 8317: x_return_status := FND_API.G_RET_STS_SUCCESS;

8313: END IF;
8314: update ra_interface_lines_all
8315: set request_id=null
8316: where request_id = -1 * p_id;
8317: x_return_status := FND_API.G_RET_STS_SUCCESS;
8318: IF l_debug_level > 0 THEN
8319: oe_debug_pub.add( 'EXITING UPDATE_NUMBERS ( ) PROCEDURE' , 5 ) ;
8320: END IF;
8321: RETURN;

Line 8331: x_return_status := FND_API.G_RET_STS_ERROR;

8327: err_msg := 'Error in update_numbers:\n '|| SQLERRM;
8328: IF l_debug_level > 0 THEN
8329: oe_debug_pub.add( ERR_MSG ) ;
8330: END IF;
8331: x_return_status := FND_API.G_RET_STS_ERROR;
8332: IF (cur_get_cols%ISOPEN) THEN
8333: CLOSE cur_get_cols;
8334: END IF;
8335: IF (cur_get_del_id%ISOPEN) THEN

Line 8387: x_return_status := FND_API.G_RET_STS_SUCCESS;

8383: IF l_debug_level > 0 THEN
8384: oe_debug_pub.add( 'ENTERING INTERFACE_SINGLE_LINE ( ) PROCEDURE' , 5 ) ;
8385: oe_debug_pub.add( 'INTERFACING LINE ID '||TO_CHAR ( P_LINE_REC.LINE_ID ) , 1 ) ;
8386: END IF;
8387: x_return_status := FND_API.G_RET_STS_SUCCESS;
8388: --Customer Acceptance
8389: l_line_invoiceable := Line_Invoiceable(p_line_rec);
8390: l_line_rejected := Line_Rejected(p_line_rec);
8391:

Line 8440: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 8442: RAISE FND_API.G_EXC_ERROR;

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

Line 8443: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

8439: Check_Invoicing_Holds(p_line_rec, g_itemtype, x_return_status);
8440: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8441: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
8442: RAISE FND_API.G_EXC_ERROR;
8443: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8444: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8446: END IF;
8447: END IF; */

Line 8445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 8463: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 8465: RAISE FND_API.G_EXC_ERROR;

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

Line 8466: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

8462: ,x_return_status);
8463: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8464: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8465: RAISE FND_API.G_EXC_ERROR;
8466: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8467: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8469: END IF;
8470: --- Eventhough line is not eligible for invoicing, there might be some other

Line 8468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 8500: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 8502: RAISE FND_API.G_EXC_ERROR;

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

Line 8503: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 8505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 8506: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

Line 8587: RAISE FND_API.G_EXC_ERROR;

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

Line 8600: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 8602: RAISE FND_API.G_EXC_ERROR;

8598: END IF; -- for Non-rejected_lines Customer Acceptance
8599:
8600: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8601: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8602: RAISE FND_API.G_EXC_ERROR;
8603: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8604: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8606: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 8603: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 8605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 8606: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

Line 8656: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 8658: RAISE FND_API.G_EXC_ERROR;

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

Line 8659: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 8661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 8662: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

Line 8684: RAISE FND_API.G_EXC_ERROR;

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

Line 8692: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 8694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8690: ,x_return_status=>l_return_status);
8691: -- Fix for the bug 2187074
8692: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8693: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8695: END IF;
8696:
8697: -- 3685479 Replacing show detail dis by the following IF
8698: -- Adjustments need not be queried here as it is anyway going to be queried in interface_detail_discounts

Line 8707: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 8709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8705: ,x_return_status);
8706: -- Fix for the bug 2187074
8707: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8708: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8710: END IF;
8711: END IF;
8712: IF l_debug_level > 0 THEN
8713: oe_debug_pub.add( 'INTERFACING FREIGHT CHARGES' , 5 ) ;

Line 8720: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

8716: If (NVL(p_line_rec.service_bill_option_code,'FBOM') = 'FBOM') THEN -- sol_ord_er #16014165
8717: Interface_Freight_Charges(p_line_rec
8718: , p_x_interface_line_rec
8719: , x_return_status);
8720: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8721: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8722: RAISE FND_API.G_EXC_ERROR;
8723: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8724: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

Line 8722: RAISE FND_API.G_EXC_ERROR;

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

Line 8723: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 8725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 8740: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 8742: RAISE FND_API.G_EXC_ERROR;

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

Line 8743: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

8739: ,x_return_status);
8740: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
8741: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8742: RAISE FND_API.G_EXC_ERROR;
8743: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8744: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
8745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8746: END IF;
8747:

Line 8745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 8758: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

8754: , p_interface_line_rec => p_x_interface_line_rec
8755: , x_return_status => x_return_status
8756: );
8757:
8758: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8760: END IF;
8761: --Customer Acceptance
8762:

Line 8759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8755: , x_return_status => x_return_status
8756: );
8757:
8758: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8760: END IF;
8761: --Customer Acceptance
8762:
8763: IF l_debug_level > 0 THEN

Line 8784: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 8786: RAISE FND_API.G_EXC_ERROR;

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

Line 8787: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 8789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 8790: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

Line 8808: WHEN FND_API.G_EXC_ERROR THEN

8804: IF l_debug_level > 0 THEN
8805: oe_debug_pub.add( 'EXIT INTERFACE_SINGLE_LINE ( ) PROCEDURE SUCCESSFULLY' , 1 ) ;
8806: END IF;
8807: EXCEPTION
8808: WHEN FND_API.G_EXC_ERROR THEN
8809: IF l_debug_level > 0 THEN
8810: oe_debug_pub.add( 'EXPECTED ERROR. EXITING INTERFACE_SINGLE_LINE : '||SQLERRM , 1 ) ;
8811: END IF;
8812: x_return_status := FND_API.G_RET_STS_ERROR;

Line 8812: x_return_status := FND_API.G_RET_STS_ERROR;

8808: WHEN FND_API.G_EXC_ERROR THEN
8809: IF l_debug_level > 0 THEN
8810: oe_debug_pub.add( 'EXPECTED ERROR. EXITING INTERFACE_SINGLE_LINE : '||SQLERRM , 1 ) ;
8811: END IF;
8812: x_return_status := FND_API.G_RET_STS_ERROR;
8813: IF l_debug_level > 0 THEN
8814: oe_debug_pub.add( 'RETURN STATUS :'||X_RETURN_STATUS||' OUT RESULT : '||X_RESULT_OUT , 5 ) ;
8815: END IF;
8816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 8816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8812: x_return_status := FND_API.G_RET_STS_ERROR;
8813: IF l_debug_level > 0 THEN
8814: oe_debug_pub.add( 'RETURN STATUS :'||X_RETURN_STATUS||' OUT RESULT : '||X_RESULT_OUT , 5 ) ;
8815: END IF;
8816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8817: IF l_debug_level > 0 THEN
8818: oe_debug_pub.add( 'UNEXPECTED ERROR. EXITING INTERFACE_SINGLE_LINE '||SQLERRM , 1 ) ;
8819: oe_debug_pub.add( 'RETURN STATUS :'||X_RETURN_STATUS||' OUT RESULT : '||X_RESULT_OUT , 5 ) ;
8820: END IF;

Line 8821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8817: IF l_debug_level > 0 THEN
8818: oe_debug_pub.add( 'UNEXPECTED ERROR. EXITING INTERFACE_SINGLE_LINE '||SQLERRM , 1 ) ;
8819: oe_debug_pub.add( 'RETURN STATUS :'||X_RETURN_STATUS||' OUT RESULT : '||X_RESULT_OUT , 5 ) ;
8820: END IF;
8821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8822: WHEN OTHERS THEN
8823: IF l_debug_level > 0 THEN
8824: oe_debug_pub.add( 'OTHER EXCEPTION. EXITING INTERFACE_SINGLE_LINE : '||SQLERRM , 1 ) ;
8825: oe_debug_pub.add( 'RETURN STATUS :'||X_RETURN_STATUS||' OUT RESULT : '||X_RESULT_OUT , 5 ) ;

Line 8833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8829: ( G_PKG_NAME
8830: , 'Interface_Single_line'
8831: );
8832: END IF;
8833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8834: END Interface_Single_line;
8835:
8836: PROCEDURE Interface_Line
8837: ( p_line_id IN NUMBER

Line 8948: x_return_status := FND_API.G_RET_STS_SUCCESS;

8944: ,p_line_id => p_line_id ); */
8945: --Exception management end
8946:
8947: -- Initialize API return status to success
8948: x_return_status := FND_API.G_RET_STS_SUCCESS;
8949: G_ITEMTYPE := p_itemtype;
8950:
8951: --bug 5336623
8952: oe_line_util.Query_Row

Line 8963: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

8959: /* OE_Line_Util.Lock_Row(p_line_id=>p_line_id
8960: , p_x_line_rec => l_line_rec
8961: , x_return_status => l_return_status
8962: );
8963: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8964: RAISE FND_API.G_EXC_ERROR;
8965: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8967: END IF; */

Line 8964: RAISE FND_API.G_EXC_ERROR;

8960: , p_x_line_rec => l_line_rec
8961: , x_return_status => l_return_status
8962: );
8963: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8964: RAISE FND_API.G_EXC_ERROR;
8965: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8967: END IF; */
8968:

Line 8965: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

8961: , x_return_status => l_return_status
8962: );
8963: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8964: RAISE FND_API.G_EXC_ERROR;
8965: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8967: END IF; */
8968:
8969: --bug 5336623 Moved the following call to OE_Header_Util.Query_row after the line is locked

Line 8966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8962: );
8963: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8964: RAISE FND_API.G_EXC_ERROR;
8965: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8967: END IF; */
8968:
8969: --bug 5336623 Moved the following call to OE_Header_Util.Query_row after the line is locked
8970: --OE_Header_Util.Query_row(p_header_id=>l_line_rec.header_id,x_header_rec=>l_header_rec);

Line 9007: x_return_status := FND_API.G_RET_STS_ERROR;

9003: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
9004: IF l_debug_level > 0 THEN
9005: oe_debug_pub.add('in lock record exception, someone else working on the row');
9006: END IF;
9007: x_return_status := FND_API.G_RET_STS_ERROR;
9008: l_line_rec.return_status := FND_API.G_RET_STS_ERROR;
9009: l_line_rec.line_id := null;
9010: FND_MESSAGE.Set_Name('ONT', 'OE_LINE_LOCKED');
9011: OE_MSG_PUB.Add;

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

9004: IF l_debug_level > 0 THEN
9005: oe_debug_pub.add('in lock record exception, someone else working on the row');
9006: END IF;
9007: x_return_status := FND_API.G_RET_STS_ERROR;
9008: l_line_rec.return_status := FND_API.G_RET_STS_ERROR;
9009: l_line_rec.line_id := null;
9010: FND_MESSAGE.Set_Name('ONT', 'OE_LINE_LOCKED');
9011: OE_MSG_PUB.Add;
9012: RAISE FND_API.G_EXC_ERROR;

Line 9012: RAISE FND_API.G_EXC_ERROR;

9008: l_line_rec.return_status := FND_API.G_RET_STS_ERROR;
9009: l_line_rec.line_id := null;
9010: FND_MESSAGE.Set_Name('ONT', 'OE_LINE_LOCKED');
9011: OE_MSG_PUB.Add;
9012: RAISE FND_API.G_EXC_ERROR;
9013: */
9014:
9015: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
9016: IF l_debug_level > 0 THEN

Line 9036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9032: WHEN NO_DATA_FOUND THEN
9033: IF l_debug_level > 0 THEN
9034: oe_debug_pub.add('no_data_found, record lock exception');
9035: END IF;
9036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9037:
9038: WHEN OTHERS THEN
9039: IF l_debug_level > 0 THEN
9040: oe_debug_pub.add('record lock exception, others');

Line 9043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9039: IF l_debug_level > 0 THEN
9040: oe_debug_pub.add('record lock exception, others');
9041: oe_debug_pub.add('line id '|| v_line_id , 1);
9042: END IF;
9043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9044: END;
9045:
9046: OE_Header_Util.Query_row(p_header_id=>l_line_rec.header_id,x_header_rec=>l_header_rec);
9047: --bug 5336623

Line 9053: x_return_status := FND_API.G_RET_STS_SUCCESS ;

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

Line 9066: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 9068: RAISE FND_API.G_EXC_ERROR;

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

Line 9069: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

9065:
9066: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9067: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9068: RAISE FND_API.G_EXC_ERROR;
9069: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9070: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9072: END IF;
9073: END;

Line 9071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 9122: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

9118: || l_return_status, 1 ) ;
9119: oe_debug_pub.add('OEXPINVB 2: global picture index: ' || l_global_index , 1 ) ;
9120: END IF;
9121:
9122: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
9123: RAISE Fnd_Api.G_EXC_ERROR;
9124: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9125: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
9126: END IF;

Line 9123: RAISE Fnd_Api.G_EXC_ERROR;

9119: oe_debug_pub.add('OEXPINVB 2: global picture index: ' || l_global_index , 1 ) ;
9120: END IF;
9121:
9122: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
9123: RAISE Fnd_Api.G_EXC_ERROR;
9124: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9125: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
9126: END IF;
9127:

Line 9124: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

9120: END IF;
9121:
9122: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
9123: RAISE Fnd_Api.G_EXC_ERROR;
9124: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9125: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
9126: END IF;
9127:
9128: IF l_global_index IS NOT NULL THEN

Line 9125: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

9121:
9122: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
9123: RAISE Fnd_Api.G_EXC_ERROR;
9124: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9125: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
9126: END IF;
9127:
9128: IF l_global_index IS NOT NULL THEN
9129: Oe_Order_Util.g_line_tbl(l_global_index).SERVICE_START_DATE := l_line_tbl(1).SERVICE_START_DATE;

Line 9154: x_return_status := FND_API.G_RET_STS_ERROR;

9150: WHEN NO_DATA_FOUND THEN
9151: IF l_debug_level > 0 THEN
9152: oe_Debug_pub.add(' ..101.. No Data Found in OEXPINVB for line_id '||l_line_rec.line_id);
9153: End If;
9154: x_return_status := FND_API.G_RET_STS_ERROR;
9155: WHEN OTHERS THEN
9156: IF l_debug_level > 0 THEN
9157: oe_Debug_pub.add(' ..101.. UnExpected Error in OEXPINVB for line_id '||l_line_rec.line_id);
9158: End If;

Line 9159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9155: WHEN OTHERS THEN
9156: IF l_debug_level > 0 THEN
9157: oe_Debug_pub.add(' ..101.. UnExpected Error in OEXPINVB for line_id '||l_line_rec.line_id);
9158: End If;
9159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9160: END;
9161: End If;
9162: -- sol_ord_er #16014165 end
9163:

Line 9164: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 9166: RAISE FND_API.G_EXC_ERROR;

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

Line 9167: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 9169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 9204: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

9200: oe_debug_pub.add('acceptance not required. item_type:'||l_line_rec.item_type_code);
9201: END IF;
9202: ELSE
9203: Update_Invoice_Attributes(l_line_rec ,l_interface_line_rec ,'ACCEPTANCE-PENDING' ,x_return_status);
9204: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9205: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9206: RAISE FND_API.G_EXC_ERROR;
9207: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9208: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

Line 9206: RAISE FND_API.G_EXC_ERROR;

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

Line 9207: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

9203: Update_Invoice_Attributes(l_line_rec ,l_interface_line_rec ,'ACCEPTANCE-PENDING' ,x_return_status);
9204: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9205: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9206: RAISE FND_API.G_EXC_ERROR;
9207: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9208: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9210: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9211: x_result_out := OE_GLOBALS.G_WFR_PENDING_ACCEPTANCE; -- this is pending for Acceptance

Line 9209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 9210: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

Line 9271: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 9273: RAISE FND_API.G_EXC_ERROR;

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

Line 9274: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 9276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9272: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
9273: RAISE FND_API.G_EXC_ERROR;
9274: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9275: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9277: END IF;
9278: END IF;
9279: END IF; -- noninvoiceable line
9280: /* Bug#2666125 end-check freight records and holds for non invoiceable items*/

Line 9297: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 9299: RAISE FND_API.G_EXC_ERROR;

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

Line 9300: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

9296: ,x_return_status);
9297: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9298: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9299: RAISE FND_API.G_EXC_ERROR;
9300: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9301: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9303: END IF;
9304: --- Eventhough line is not eligible for invoicing, there might be some other

Line 9302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 9334: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 9336: RAISE FND_API.G_EXC_ERROR;

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

Line 9337: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 9339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 9340: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

Line 9418: RAISE FND_API.G_EXC_ERROR;

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

Line 9430: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 9432: RAISE FND_API.G_EXC_ERROR;

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

Line 9433: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

9429: END IF; -- for Non-rejected_lines Customer Acceptance
9430: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9431: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9432: RAISE FND_API.G_EXC_ERROR;
9433: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9434: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9436: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9437: -- sol_ord_er #16014165

Line 9435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 9436: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

Line 9459: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 9461: RAISE FND_API.G_EXC_ERROR;

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

Line 9462: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

9458: Check_Invoicing_Holds(l_line_rec, p_itemtype, x_return_status);
9459: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9460: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
9461: RAISE FND_API.G_EXC_ERROR;
9462: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9463: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9465: END IF;
9466: IF FND_PROFILE.VALUE('WSH_INVOICE_NUMBERING_METHOD') = 'D' THEN

Line 9464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9460: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
9461: RAISE FND_API.G_EXC_ERROR;
9462: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9463: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
9464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9465: END IF;
9466: IF FND_PROFILE.VALUE('WSH_INVOICE_NUMBERING_METHOD') = 'D' THEN
9467: IF l_debug_level > 0 THEN
9468: oe_debug_pub.add( 'INVOICE NUMBERING SET TO MANUAL' , 5 ) ;

Line 9643: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 9645: RAISE FND_API.G_EXC_ERROR;

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

Line 9646: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 9648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 9649: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

Line 9768: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

9764: -- if this line can only invoice partial, it will become RFR-PENDING while interfacing whatever it can
9765: -- x_result_out should have set appropriately
9766: oe_debug_pub.add( 'AFTER INTERFACE SINGLE LINE , RESULT_OUT IS ' || X_RESULT_OUT ||': And x_return_status:'||x_return_status, 5 ) ;
9767: END IF;
9768: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9769: RAISE FND_API.G_EXC_ERROR;
9770: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9772: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 9769: RAISE FND_API.G_EXC_ERROR;

9765: -- x_result_out should have set appropriately
9766: oe_debug_pub.add( 'AFTER INTERFACE SINGLE LINE , RESULT_OUT IS ' || X_RESULT_OUT ||': And x_return_status:'||x_return_status, 5 ) ;
9767: END IF;
9768: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9769: RAISE FND_API.G_EXC_ERROR;
9770: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9772: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9773: -- bug# 4094835, if RFR line is fully is fully invoiced or not eligible

Line 9770: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

9766: oe_debug_pub.add( 'AFTER INTERFACE SINGLE LINE , RESULT_OUT IS ' || X_RESULT_OUT ||': And x_return_status:'||x_return_status, 5 ) ;
9767: END IF;
9768: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9769: RAISE FND_API.G_EXC_ERROR;
9770: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9772: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9773: -- bug# 4094835, if RFR line is fully is fully invoiced or not eligible
9774: IF (x_result_out = OE_GLOBALS.G_WFR_COMPLETE OR x_result_out=OE_GLOBALS.G_WFR_NOT_ELIGIBLE) THEN

Line 9771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9767: END IF;
9768: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9769: RAISE FND_API.G_EXC_ERROR;
9770: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9772: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9773: -- bug# 4094835, if RFR line is fully is fully invoiced or not eligible
9774: IF (x_result_out = OE_GLOBALS.G_WFR_COMPLETE OR x_result_out=OE_GLOBALS.G_WFR_NOT_ELIGIBLE) THEN
9775: IF l_old_interface_status_code = 'MANUAL-PENDING' OR l_old_interface_status_code = 'RFR-PENDING' THEN

Line 9772: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

9768: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9769: RAISE FND_API.G_EXC_ERROR;
9770: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9772: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9773: -- bug# 4094835, if RFR line is fully is fully invoiced or not eligible
9774: IF (x_result_out = OE_GLOBALS.G_WFR_COMPLETE OR x_result_out=OE_GLOBALS.G_WFR_NOT_ELIGIBLE) THEN
9775: IF l_old_interface_status_code = 'MANUAL-PENDING' OR l_old_interface_status_code = 'RFR-PENDING' THEN
9776: IF l_debug_level > 0 THEN

Line 9812: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 9814: RAISE FND_API.G_EXC_ERROR;

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

Line 9815: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 9817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 9819: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

Line 9835: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

9831: ,x_result_out => x_result_out);
9832: IF l_debug_level > 0 THEN
9833: oe_debug_pub.add( 'INTERFACED W/REQUEST_ID : '||L_INTERFACE_LINE_REC.REQUEST_ID , 5 ) ;
9834: END IF;
9835: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9836: RAISE FND_API.G_EXC_ERROR;
9837: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9839: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 9836: RAISE FND_API.G_EXC_ERROR;

9832: IF l_debug_level > 0 THEN
9833: oe_debug_pub.add( 'INTERFACED W/REQUEST_ID : '||L_INTERFACE_LINE_REC.REQUEST_ID , 5 ) ;
9834: END IF;
9835: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9836: RAISE FND_API.G_EXC_ERROR;
9837: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9839: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9840: IF l_debug_level > 0 THEN

Line 9837: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

9833: oe_debug_pub.add( 'INTERFACED W/REQUEST_ID : '||L_INTERFACE_LINE_REC.REQUEST_ID , 5 ) ;
9834: END IF;
9835: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9836: RAISE FND_API.G_EXC_ERROR;
9837: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9839: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9840: IF l_debug_level > 0 THEN
9841: 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 9838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9834: END IF;
9835: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9836: RAISE FND_API.G_EXC_ERROR;
9837: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9839: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9840: IF l_debug_level > 0 THEN
9841: 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 ) ;
9842: END IF;

Line 9839: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

9835: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9836: RAISE FND_API.G_EXC_ERROR;
9837: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9839: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
9840: IF l_debug_level > 0 THEN
9841: 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 ) ;
9842: END IF;
9843: IF l_old_interface_status_code = 'MANUAL-PENDING' THEN

Line 9930: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

9926: END IF;
9927: IF l_debug_level > 0 THEN
9928: oe_debug_pub.add( 'INTERFACED W/REQUEST_ID : '||L_INTERFACE_LINE_REC.REQUEST_ID || ' X_RETURN_STATUS: '|| X_RETURN_STATUS , 5 ) ;
9929: END IF;
9930: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9931: RAISE FND_API.G_EXC_ERROR;
9932: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9934: END IF;

Line 9931: RAISE FND_API.G_EXC_ERROR;

9927: IF l_debug_level > 0 THEN
9928: oe_debug_pub.add( 'INTERFACED W/REQUEST_ID : '||L_INTERFACE_LINE_REC.REQUEST_ID || ' X_RETURN_STATUS: '|| X_RETURN_STATUS , 5 ) ;
9929: END IF;
9930: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9931: RAISE FND_API.G_EXC_ERROR;
9932: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9934: END IF;
9935: -- if this line is RFR and there are lines waiting for it, interface those lines

Line 9932: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

9928: oe_debug_pub.add( 'INTERFACED W/REQUEST_ID : '||L_INTERFACE_LINE_REC.REQUEST_ID || ' X_RETURN_STATUS: '|| X_RETURN_STATUS , 5 ) ;
9929: END IF;
9930: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9931: RAISE FND_API.G_EXC_ERROR;
9932: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9934: END IF;
9935: -- if this line is RFR and there are lines waiting for it, interface those lines
9936: IF Is_PTO(l_line_rec) THEN

Line 9933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9929: END IF;
9930: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
9931: RAISE FND_API.G_EXC_ERROR;
9932: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9933: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9934: END IF;
9935: -- if this line is RFR and there are lines waiting for it, interface those lines
9936: IF Is_PTO(l_line_rec) THEN
9937: IF Is_RFR(l_line_rec.line_id) THEN

Line 9963: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 9965: RAISE FND_API.G_EXC_ERROR;

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

Line 9966: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 9968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 9969: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

Line 9984: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

Line 9999: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 10001: RAISE FND_API.G_EXC_ERROR;

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

Line 10002: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 10004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 10023: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

10019: close Pending_Lines;
10020: END IF; -- itself is a RFR line
10021: END IF; -- PTO line
10022: END IF; -- if interface_this_line is Y
10023: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
10024: IF x_result_out = OE_GLOBALS.G_WFR_COMPLETE OR x_result_out = OE_GLOBALS.G_WFR_NOT_ELIGIBLE THEN
10025: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN
10026: IF generate_invoice_number = 'Y' THEN
10027: IF l_debug_level > 0 THEN

Line 10039: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 10041: RAISE FND_API.G_EXC_ERROR;

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

Line 10042: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 10044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 10063: WHEN FND_API.G_EXC_ERROR THEN

10059: END IF;
10060: END IF;
10061: END IF;
10062: EXCEPTION
10063: WHEN FND_API.G_EXC_ERROR THEN
10064: IF l_debug_level > 0 THEN
10065: oe_debug_pub.add( 'EXPECTED ERROR. EXIT LINE INVOICING : '||SQLERRM , 1 ) ;
10066: END IF;
10067: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

Line 10086: x_return_status := FND_API.G_RET_STS_ERROR;

10082: OE_MSG_PUB.Count_And_Get
10083: ( p_count => x_msg_count
10084: , p_data => x_msg_data
10085: );
10086: x_return_status := FND_API.G_RET_STS_ERROR;
10087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10088: IF l_debug_level > 0 THEN
10089: oe_debug_pub.add( 'UNEXPECTED ERROR. EXITING FROM LINE INVOICING : '||SQLERRM , 1 ) ;
10090: END IF;

Line 10087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

10083: ( p_count => x_msg_count
10084: , p_data => x_msg_data
10085: );
10086: x_return_status := FND_API.G_RET_STS_ERROR;
10087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10088: IF l_debug_level > 0 THEN
10089: oe_debug_pub.add( 'UNEXPECTED ERROR. EXITING FROM LINE INVOICING : '||SQLERRM , 1 ) ;
10090: END IF;
10091: IF p_itemtype = OE_GLOBALS.G_WFI_LIN THEN

Line 10098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10094: OE_MSG_PUB.Count_And_Get
10095: ( p_count => x_msg_count
10096: , p_data => x_msg_data
10097: );
10098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10099: WHEN OTHERS THEN
10100: IF l_debug_level > 0 THEN
10101: oe_debug_pub.add( 'EXCEPTION , OTHERS. EXITING FROM LINE INVOICING : '||SQLERRM , 1 ) ;
10102: END IF;

Line 10124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10120: OE_MSG_PUB.Count_And_Get
10121: ( p_count => x_msg_count
10122: , p_data => x_msg_data
10123: );
10124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10125: END Interface_Line;
10126:
10127: PROCEDURE Interface_Header
10128: ( p_header_id IN NUMBER

Line 10155: x_return_status := FND_API.G_RET_STS_SUCCESS;

10151: oe_debug_pub.add( 'ENTER INTERFACE_HEADER ( ) PROCEDURE' , 5 ) ;
10152: END IF;
10153: SAVEPOINT HEADER_INVOICE_INTERFACE;
10154: -- Initialize API return status to success
10155: x_return_status := FND_API.G_RET_STS_SUCCESS;
10156:
10157: /* ------------ Bug# 9370369 : Start : Moving this code of bug# 8993414 little below -----
10158: ---Bug 8683948 : Start
10159: select source_document_type_id into l_source_document_type_id

Line 10164: x_return_status := FND_API.G_RET_STS_SUCCESS ;

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

Line 10182: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 10188: RAISE FND_API.G_EXC_ERROR;

10184: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
10185: ELSIF l_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN
10186: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
10187: END IF;
10188: RAISE FND_API.G_EXC_ERROR;
10189: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10191: ELSE
10192: IF l_debug_level > 0 THEN

Line 10189: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

10185: ELSIF l_result_out = OE_GLOBALS.G_WFR_INCOMPLETE THEN
10186: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
10187: END IF;
10188: RAISE FND_API.G_EXC_ERROR;
10189: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10191: ELSE
10192: IF l_debug_level > 0 THEN
10193: oe_debug_pub.add( 'CONTINUE WITH NEXT LINE IF THIS IS NOT LAST ONE' , 5 ) ;

Line 10190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10186: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
10187: END IF;
10188: RAISE FND_API.G_EXC_ERROR;
10189: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10191: ELSE
10192: IF l_debug_level > 0 THEN
10193: oe_debug_pub.add( 'CONTINUE WITH NEXT LINE IF THIS IS NOT LAST ONE' , 5 ) ;
10194: END IF;

Line 10206: x_return_status := FND_API.G_RET_STS_SUCCESS ;

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

Line 10229: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 10231: RAISE FND_API.G_EXC_ERROR;

10227: END IF;
10228:
10229: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
10230: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
10231: RAISE FND_API.G_EXC_ERROR;
10232: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10234: ELSE
10235: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 10232: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

10228:
10229: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
10230: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
10231: RAISE FND_API.G_EXC_ERROR;
10232: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10234: ELSE
10235: x_return_status := FND_API.G_RET_STS_SUCCESS;
10236: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;

Line 10233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10229: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
10230: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
10231: RAISE FND_API.G_EXC_ERROR;
10232: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10234: ELSE
10235: x_return_status := FND_API.G_RET_STS_SUCCESS;
10236: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;
10237: IF l_debug_level > 0 THEN

Line 10235: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 10252: WHEN FND_API.G_EXC_ERROR THEN

10248: oe_debug_pub.add( 'EXITING INTERFACE_HEADER ( ) PROCEDURE' , 5 ) ;
10249: END IF;
10250:
10251: EXCEPTION
10252: WHEN FND_API.G_EXC_ERROR THEN
10253: IF l_debug_level > 0 THEN
10254: oe_debug_pub.add( 'EXPECTED ERROR. EXIT FROM HEADER INVOICING' , 5 ) ;
10255: END IF;
10256: IF (order_line_cursor%ISOPEN) THEN

Line 10274: x_return_status := FND_API.G_RET_STS_ERROR;

10270: OE_MSG_PUB.Count_And_Get
10271: ( p_count => x_msg_count
10272: , p_data => x_msg_data
10273: );
10274: x_return_status := FND_API.G_RET_STS_ERROR;
10275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10276: IF l_debug_level > 0 THEN
10277: oe_debug_pub.add( 'UNEXPECTED ERROR. EXITING FROM HEADER INVOICING' , 5 ) ;
10278: END IF;

Line 10275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

10271: ( p_count => x_msg_count
10272: , p_data => x_msg_data
10273: );
10274: x_return_status := FND_API.G_RET_STS_ERROR;
10275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10276: IF l_debug_level > 0 THEN
10277: oe_debug_pub.add( 'UNEXPECTED ERROR. EXITING FROM HEADER INVOICING' , 5 ) ;
10278: END IF;
10279: IF (order_line_cursor%ISOPEN) THEN

Line 10287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 10309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 10340: l_header_id = FND_API.G_MISS_NUM

10336: l_header_id := oe_header_payment_security.g_record.header_id;
10337: END IF;
10338:
10339: IF l_header_id IS NULL OR
10340: l_header_id = FND_API.G_MISS_NUM
10341: THEN
10342: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
10343: p_result := 0;
10344: END IF;

Line 10426: l_header_id = FND_API.G_MISS_NUM

10422: -- 3740077
10423: END IF;
10424:
10425: IF l_header_id IS NULL OR
10426: l_header_id = FND_API.G_MISS_NUM
10427: THEN
10428: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
10429: p_result := 0;
10430: END IF;

Line 10433: l_header_id <> FND_API.G_MISS_NUM THEN

10429: p_result := 0;
10430: END IF;
10431:
10432: IF l_header_id is not null and
10433: l_header_id <> FND_API.G_MISS_NUM THEN
10434:
10435: BEGIN
10436: select 1 into l_lines_exist
10437: from oe_order_lines

Line 10502: l_line_id = FND_API.G_MISS_NUM

10498:
10499: oe_debug_pub.add(' Line Id :'||l_line_id);
10500:
10501: IF l_line_id IS NULL OR
10502: l_line_id = FND_API.G_MISS_NUM
10503: THEN
10504: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
10505: p_result := 0;
10506: END IF;