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_ORDER_WF_UTIL dependencies on FND_API

Line 30: , p_wfasgn_item_type IN VARCHAR2 := FND_API.G_MISS_CHAR

26: -- be created.
27: FUNCTION Get_ProcessName
28: ( p_itemtype IN VARCHAR2
29: , p_itemkey IN VARCHAR2
30: , p_wfasgn_item_type IN VARCHAR2 := FND_API.G_MISS_CHAR
31: , p_SalesDocumentTypeCode IN VARCHAR2 Default null
32: , p_line_rec IN OE_Order_PUB.Line_Rec_Type := OE_Order_Pub.G_MISS_LINE_REC
33: ) RETURN VARCHAR2
34: IS

Line 139: RAISE FND_API.G_EXC_ERROR;

135:
136: CLOSE find_BktNgoHdrProcessname;
137: ELSE
138: -- error
139: RAISE FND_API.G_EXC_ERROR;
140: END IF;
141:
142: ELSIF (p_itemtype = OE_GLOBALS.G_WFI_BKT) THEN
143: OPEN find_BlanketHdrProcessname(p_itemkey);

Line 169: RAISE FND_API.G_EXC_ERROR;

165:
166: WHEN NO_DATA_FOUND THEN
167: fnd_message.set_name('ONT','OE_MISS_FLOW');
168: OE_MSG_PUB.Add;
169: RAISE FND_API.G_EXC_ERROR;
170:
171: WHEN OTHERS THEN
172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
173: THEN

Line 178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

174: OE_MSG_PUB.Add_Exc_Msg
175: ( G_PKG_NAME
176: , 'GET_ProcessName'
177: );
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: END IF;
180: END Get_ProcessName;
181:
182:

Line 249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

245: OE_MSG_PUB.Add_Exc_Msg
246: (G_PKG_NAME
247: , 'Set_Header_Descriptor'
248: );
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: END IF;
251:
252: END Set_Header_Descriptor;
253:

Line 338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

334: OE_MSG_PUB.Add_Exc_Msg
335: (G_PKG_NAME
336: , 'Set_Line_Descriptor'
337: );
338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
339: END IF;
340:
341: END Set_Line_Descriptor;
342:

Line 367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

363: OE_MSG_PUB.Add_Exc_Msg
364: ( G_PKG_NAME
365: , 'Set_Header_User_Key'
366: );
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: END IF;
369: END Set_Header_User_Key;
370:
371: PROCEDURE Set_Line_User_Key(p_line_rec IN OE_Order_PUB.Line_Rec_Type)

Line 409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

405: OE_MSG_PUB.Add_Exc_Msg
406: ( G_PKG_NAME
407: , 'Set_Line_User_Key'
408: );
409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
410: END IF;
411: END Set_Line_User_Key;
412:
413:

Line 444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

440: OE_MSG_PUB.Add_Exc_Msg
441: ( G_PKG_NAME
442: , 'Start_Flow'
443: );
444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
445: END IF;
446:
447: END Start_flow;
448:

Line 484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

480: OE_MSG_PUB.Add_Exc_Msg
481: ( G_PKG_NAME
482: , 'Start_LineFork'
483: );
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: END IF;
486:
487: END Start_LineFork;
488:

Line 537: WHEN FND_API.G_EXC_ERROR THEN -- 2590433

533: oe_debug_pub.add( 'EXITING CREATESTART_HDRPROCESS' ) ;
534: END IF;
535:
536: EXCEPTION
537: WHEN FND_API.G_EXC_ERROR THEN -- 2590433
538: RAISE;
539: WHEN OTHERS THEN
540: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
541: THEN

Line 546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

542: OE_MSG_PUB.Add_Exc_Msg
543: ( G_PKG_NAME
544: , 'Start_HdrProcess'
545: );
546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
547: END IF;
548:
549: END CreateStart_HdrProcess;
550:

Line 658: WHEN FND_API.G_EXC_ERROR THEN -- 2590433

654: oe_debug_pub.add( 'EXITING CREATE_HDRWORKITEM' ) ;
655: END IF;
656:
657: EXCEPTION
658: WHEN FND_API.G_EXC_ERROR THEN -- 2590433
659: RAISE;
660: WHEN OTHERS THEN
661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
662: THEN

Line 667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

663: OE_MSG_PUB.Add_Exc_Msg
664: ( G_PKG_NAME
665: , 'Create_HdrWorkItem'
666: );
667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
668: END IF;
669:
670: END Create_HdrWorkItem;
671:

Line 726: WHEN FND_API.G_EXC_ERROR THEN -- 2590433

722: END IF;
723: END IF;
724:
725: EXCEPTION
726: WHEN FND_API.G_EXC_ERROR THEN -- 2590433
727: RAISE;
728: WHEN OTHERS THEN
729: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
730: THEN

Line 735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

731: OE_MSG_PUB.Add_Exc_Msg
732: ( G_PKG_NAME
733: , 'CreateStart_LineProcess'
734: );
735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
736: END IF;
737:
738: END CreateStart_LineProcess;
739:

Line 770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

766: OE_MSG_PUB.Add_Exc_Msg
767: ( G_PKG_NAME
768: , 'CreateStart_LineFork'
769: );
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771: END IF;
772:
773: END CreateStart_LineFork;
774:

Line 869: WHEN FND_API.G_EXC_ERROR THEN -- 2590433

865: oe_debug_pub.add( 'EXITING CREATE_LINEWORKITEM' ) ;
866: END IF;
867:
868: EXCEPTION
869: WHEN FND_API.G_EXC_ERROR THEN -- 2590433
870: RAISE;
871: WHEN OTHERS THEN
872: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
873: THEN

Line 878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

874: OE_MSG_PUB.Add_Exc_Msg
875: ( G_PKG_NAME
876: , 'Create_LineWorkItem'
877: );
878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
879: END IF;
880:
881: END Create_LineWorkItem;
882:

Line 930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

926: OE_MSG_PUB.Add_Exc_Msg
927: ( G_PKG_NAME
928: , 'Create_LineFork'
929: );
930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
931: END IF;
932:
933: END Create_LineFork;
934:

Line 1029: RAISE FND_API.G_EXC_ERROR;

1025: ELSE
1026:
1027: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_WF_ITEM_TYPE');
1028: OE_MSG_PUB.ADD;
1029: RAISE FND_API.G_EXC_ERROR;
1030: END IF;
1031:
1032: EXCEPTION
1033:

Line 1042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1038: ( G_PKG_NAME ,
1039: 'Get_Wf_Item_Type'
1040: );
1041: END IF;
1042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1043:
1044: END Get_Wf_Item_type;
1045:
1046:

Line 1283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1279: ROLLBACK TO Start_All_Flows;
1280: -- Clear Globals
1281: Clear_FlowStart_Globals;
1282:
1283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1284: END IF;
1285:
1286: END start_all_flows;
1287:

Line 1435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1431: OE_MSG_PUB.Add_Exc_Msg
1432: ( G_PKG_NAME
1433: , 'Delete_Row'
1434: );
1435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1436: END IF;
1437: END IF;
1438: IF l_debug_level > 0 THEN
1439: oe_debug_pub.add( 'EXITING OE_ORDER_WF_UTIL.DELETE_ROW' ) ;

Line 1509: x_return_status := FND_API.G_RET_STS_SUCCESS;

1505: END IF;
1506:
1507: SAVEPOINT UPDATE_FLOW_STATUS_CODE;
1508:
1509: x_return_status := FND_API.G_RET_STS_SUCCESS;
1510:
1511: -- Check if the ASO is installed to call the NOTIFY_OC.
1512: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
1513: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);

Line 1533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1529: IF p_item_type = OE_GLOBALS.G_WFI_NGO THEN
1530:
1531: IF p_sales_document_type_code is null THEN
1532: -- for Negotiation, you must pass the document type code
1533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1534: END IF;
1535:
1536: IF p_sales_document_type_code = 'O' THEN
1537: IF l_debug_level > 0 THEN

Line 1543: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1539: END IF;
1540: OE_Header_Util.Lock_Row(p_header_id=>p_header_id
1541: , p_x_header_rec=>l_header_rec
1542: , x_return_status => l_return_status);
1543: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1544: RAISE FND_API.G_EXC_ERROR;
1545: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1547: END IF;

Line 1544: RAISE FND_API.G_EXC_ERROR;

1540: OE_Header_Util.Lock_Row(p_header_id=>p_header_id
1541: , p_x_header_rec=>l_header_rec
1542: , x_return_status => l_return_status);
1543: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1544: RAISE FND_API.G_EXC_ERROR;
1545: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1547: END IF;
1548:

Line 1545: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1541: , p_x_header_rec=>l_header_rec
1542: , x_return_status => l_return_status);
1543: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1544: RAISE FND_API.G_EXC_ERROR;
1545: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1547: END IF;
1548:
1549: -- is entity HEADER correct?

Line 1546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1542: , x_return_status => l_return_status);
1543: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1544: RAISE FND_API.G_EXC_ERROR;
1545: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1547: END IF;
1548:
1549: -- is entity HEADER correct?
1550: OE_MSG_PUB.set_msg_context

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

1608: oe_debug_pub.add( 'INDEX IS: ' || L_INDEX , 1 ) ;
1609: oe_debug_pub.add( 'HEADER FLOW STATUS IS: ' || P_FLOW_STATUS_CODE , 1 ) ;
1610: END IF;
1611:
1612: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1614: END IF;
1615:
1616: IF l_index is not NULL THEN

Line 1613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1609: oe_debug_pub.add( 'HEADER FLOW STATUS IS: ' || P_FLOW_STATUS_CODE , 1 ) ;
1610: END IF;
1611:
1612: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1614: END IF;
1615:
1616: IF l_index is not NULL THEN
1617: -- update global picture directly

Line 1637: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1633: ( p_header_rec => l_header_rec
1634: ,p_old_header_rec => l_old_header_rec
1635: ,x_return_status => l_return_status);
1636:
1637: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1638: IF l_debug_level > 0 THEN
1639: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_ERROR exception',2);
1640: END IF;
1641: RAISE FND_API.G_EXC_ERROR;

Line 1639: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_ERROR exception',2);

1635: ,x_return_status => l_return_status);
1636:
1637: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1638: IF l_debug_level > 0 THEN
1639: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_ERROR exception',2);
1640: END IF;
1641: RAISE FND_API.G_EXC_ERROR;
1642: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1643: IF l_debug_level > 0 THEN

Line 1641: RAISE FND_API.G_EXC_ERROR;

1637: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1638: IF l_debug_level > 0 THEN
1639: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_ERROR exception',2);
1640: END IF;
1641: RAISE FND_API.G_EXC_ERROR;
1642: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1643: IF l_debug_level > 0 THEN
1644: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',2);
1645: END IF;

Line 1642: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1638: IF l_debug_level > 0 THEN
1639: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_ERROR exception',2);
1640: END IF;
1641: RAISE FND_API.G_EXC_ERROR;
1642: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1643: IF l_debug_level > 0 THEN
1644: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',2);
1645: END IF;
1646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1644: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',2);

1640: END IF;
1641: RAISE FND_API.G_EXC_ERROR;
1642: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1643: IF l_debug_level > 0 THEN
1644: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',2);
1645: END IF;
1646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1647: END IF; -- bug 4732614 ends
1648: ELSIF p_sales_document_type_code = 'B' THEN -- Blanket Negotitation

Line 1646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1642: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1643: IF l_debug_level > 0 THEN
1644: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',2);
1645: END IF;
1646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1647: END IF; -- bug 4732614 ends
1648: ELSIF p_sales_document_type_code = 'B' THEN -- Blanket Negotitation
1649: IF l_debug_level > 0 THEN
1650: oe_debug_pub.add('Update_Flow_Status_Code for Blanket Negotiation:' || p_flow_status_code, 5 ) ;

Line 1667: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1663: , p_x_lock_control=>l_blanket_lock_control
1664: , x_return_status => l_return_status
1665: , x_msg_count => l_msg_count
1666: , x_msg_data => l_msg_data);
1667: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1668: RAISE FND_API.G_EXC_ERROR;
1669: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1671: END IF;

Line 1668: RAISE FND_API.G_EXC_ERROR;

1664: , x_return_status => l_return_status
1665: , x_msg_count => l_msg_count
1666: , x_msg_data => l_msg_data);
1667: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1668: RAISE FND_API.G_EXC_ERROR;
1669: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1671: END IF;
1672:

Line 1669: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1665: , x_msg_count => l_msg_count
1666: , x_msg_data => l_msg_data);
1667: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1668: RAISE FND_API.G_EXC_ERROR;
1669: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1671: END IF;
1672:
1673: OE_MSG_PUB.set_msg_context

Line 1670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1666: , x_msg_data => l_msg_data);
1667: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1668: RAISE FND_API.G_EXC_ERROR;
1669: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1671: END IF;
1672:
1673: OE_MSG_PUB.set_msg_context
1674: ( p_entity_code => 'BLANKET'

Line 1706: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1702: , p_x_lock_control=>l_blanket_lock_control
1703: , x_return_status => l_return_status
1704: , x_msg_count => l_msg_count
1705: , x_msg_data => l_msg_data);
1706: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1707: RAISE FND_API.G_EXC_ERROR;
1708: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1710: END IF;

Line 1707: RAISE FND_API.G_EXC_ERROR;

1703: , x_return_status => l_return_status
1704: , x_msg_count => l_msg_count
1705: , x_msg_data => l_msg_data);
1706: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1707: RAISE FND_API.G_EXC_ERROR;
1708: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1710: END IF;
1711: */

Line 1708: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1704: , x_msg_count => l_msg_count
1705: , x_msg_data => l_msg_data);
1706: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1707: RAISE FND_API.G_EXC_ERROR;
1708: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1710: END IF;
1711: */
1712: -- set msg context follows

Line 1709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1705: , x_msg_data => l_msg_data);
1706: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1707: RAISE FND_API.G_EXC_ERROR;
1708: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1710: END IF;
1711: */
1712: -- set msg context follows
1713:

Line 1754: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1750: (p_line_id=>p_line_id
1751: , x_line_tbl=>l_old_line_tbl
1752: , x_return_status => l_return_status);
1753:
1754: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1755: RAISE FND_API.G_EXC_ERROR;
1756: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1758: END IF;

Line 1755: RAISE FND_API.G_EXC_ERROR;

1751: , x_line_tbl=>l_old_line_tbl
1752: , x_return_status => l_return_status);
1753:
1754: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1755: RAISE FND_API.G_EXC_ERROR;
1756: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1758: END IF;
1759:

Line 1756: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1752: , x_return_status => l_return_status);
1753:
1754: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1755: RAISE FND_API.G_EXC_ERROR;
1756: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1758: END IF;
1759:
1760: OE_MSG_PUB.set_msg_context

Line 1757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1753:
1754: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1755: RAISE FND_API.G_EXC_ERROR;
1756: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1758: END IF;
1759:
1760: OE_MSG_PUB.set_msg_context
1761: ( p_entity_code => 'LINE'

Line 1836: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1832: (p_header_id=>p_header_id
1833: , p_x_header_rec=>l_header_rec
1834: , x_return_status => l_return_status);
1835:
1836: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1837: RAISE FND_API.G_EXC_ERROR;
1838: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1840: END IF;

Line 1837: RAISE FND_API.G_EXC_ERROR;

1833: , p_x_header_rec=>l_header_rec
1834: , x_return_status => l_return_status);
1835:
1836: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1837: RAISE FND_API.G_EXC_ERROR;
1838: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1840: END IF;
1841:

Line 1838: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1834: , x_return_status => l_return_status);
1835:
1836: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1837: RAISE FND_API.G_EXC_ERROR;
1838: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1840: END IF;
1841:
1842: OE_MSG_PUB.set_msg_context

Line 1839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1835:
1836: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1837: RAISE FND_API.G_EXC_ERROR;
1838: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1840: END IF;
1841:
1842: OE_MSG_PUB.set_msg_context
1843: ( p_entity_code => 'HEADER'

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

1886: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_WF_ORDER_UTIL.UPDATE LINE FLOW STATUS CODE IS: ' || L_RETURN_STATUS ) ;
1887: oe_debug_pub.add( 'INDEX IS: ' || L_INDEX , 1 ) ;
1888: END IF;
1889: --OE_DEBUG_PUB.ADD('Line Flow Status is: ' || p_flow_status_code ,1);
1890: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1892: END IF;
1893:
1894: IF l_index is not NULL THEN

Line 1891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1887: oe_debug_pub.add( 'INDEX IS: ' || L_INDEX , 1 ) ;
1888: END IF;
1889: --OE_DEBUG_PUB.ADD('Line Flow Status is: ' || p_flow_status_code ,1);
1890: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1892: END IF;
1893:
1894: IF l_index is not NULL THEN
1895:

Line 1922: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1918: ( p_line_tbl => l_line_tbl
1919: ,p_old_line_tbl => l_old_line_tbl
1920: ,x_return_status => l_return_status);
1921:
1922: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1923: IF l_debug_level > 0 THEN
1924: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_ERROR exception',2);
1925: END IF;
1926: RAISE FND_API.G_EXC_ERROR;

Line 1924: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_ERROR exception',2);

1920: ,x_return_status => l_return_status);
1921:
1922: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1923: IF l_debug_level > 0 THEN
1924: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_ERROR exception',2);
1925: END IF;
1926: RAISE FND_API.G_EXC_ERROR;
1927: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1928: IF l_debug_level > 0 THEN

Line 1926: RAISE FND_API.G_EXC_ERROR;

1922: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1923: IF l_debug_level > 0 THEN
1924: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_ERROR exception',2);
1925: END IF;
1926: RAISE FND_API.G_EXC_ERROR;
1927: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1928: IF l_debug_level > 0 THEN
1929: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',2);
1930: END IF;

Line 1927: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1923: IF l_debug_level > 0 THEN
1924: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_ERROR exception',2);
1925: END IF;
1926: RAISE FND_API.G_EXC_ERROR;
1927: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1928: IF l_debug_level > 0 THEN
1929: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',2);
1930: END IF;
1931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1929: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',2);

1925: END IF;
1926: RAISE FND_API.G_EXC_ERROR;
1927: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1928: IF l_debug_level > 0 THEN
1929: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',2);
1930: END IF;
1931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1932: END IF; -- bug 4732614 ends
1933: END IF; /*ASO installed */

Line 1931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1927: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1928: IF l_debug_level > 0 THEN
1929: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',2);
1930: END IF;
1931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1932: END IF; -- bug 4732614 ends
1933: END IF; /*ASO installed */
1934:
1935: OE_MSG_PUB.Reset_Msg_Context('LINE');

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

2034: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_WF_ORDER_UTIL.UPDATE HEADER FLOW STATUS CODE IS: ' || L_RETURN_STATUS ) ;
2035: oe_debug_pub.add( 'INDEX IS: ' || L_INDEX , 1 ) ;
2036: oe_debug_pub.add( 'HEADER FLOW STATUS IS: ' || P_FLOW_STATUS_CODE , 1 ) ;
2037: END IF;
2038: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2040: END IF;
2041:
2042: IF l_index is not NULL THEN

Line 2039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2035: oe_debug_pub.add( 'INDEX IS: ' || L_INDEX , 1 ) ;
2036: oe_debug_pub.add( 'HEADER FLOW STATUS IS: ' || P_FLOW_STATUS_CODE , 1 ) ;
2037: END IF;
2038: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2040: END IF;
2041:
2042: IF l_index is not NULL THEN
2043: -- update global picture directly

Line 2063: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2059: ( p_header_rec => l_header_rec
2060: ,p_old_header_rec => l_old_header_rec
2061: ,x_return_status => l_return_status);
2062:
2063: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2064: IF l_debug_level > 0 THEN
2065: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_ERROR exception',2);
2066: END IF;
2067: RAISE FND_API.G_EXC_ERROR;

Line 2065: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_ERROR exception',2);

2061: ,x_return_status => l_return_status);
2062:
2063: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2064: IF l_debug_level > 0 THEN
2065: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_ERROR exception',2);
2066: END IF;
2067: RAISE FND_API.G_EXC_ERROR;
2068: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2069: IF l_debug_level > 0 THEN

Line 2067: RAISE FND_API.G_EXC_ERROR;

2063: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2064: IF l_debug_level > 0 THEN
2065: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_ERROR exception',2);
2066: END IF;
2067: RAISE FND_API.G_EXC_ERROR;
2068: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2069: IF l_debug_level > 0 THEN
2070: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',2);
2071: END IF;

Line 2068: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2064: IF l_debug_level > 0 THEN
2065: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_ERROR exception',2);
2066: END IF;
2067: RAISE FND_API.G_EXC_ERROR;
2068: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2069: IF l_debug_level > 0 THEN
2070: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',2);
2071: END IF;
2072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2070: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',2);

2066: END IF;
2067: RAISE FND_API.G_EXC_ERROR;
2068: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2069: IF l_debug_level > 0 THEN
2070: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',2);
2071: END IF;
2072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2073: END IF; -- bug 4732614 ends
2074: ELSE

Line 2072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2068: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2069: IF l_debug_level > 0 THEN
2070: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',2);
2071: END IF;
2072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2073: END IF; -- bug 4732614 ends
2074: ELSE
2075: IF l_debug_level > 0 THEN
2076: oe_debug_pub.add( 'UPDATE_FLOW_STATUS_CODE: HEADER_ID AND LINE_ID ARE NULL' ) ;

Line 2078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2074: ELSE
2075: IF l_debug_level > 0 THEN
2076: oe_debug_pub.add( 'UPDATE_FLOW_STATUS_CODE: HEADER_ID AND LINE_ID ARE NULL' ) ;
2077: END IF;
2078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2079: END IF;
2080:
2081: END IF; -- End of OENH/OEBH vs OEOH/OEOL processing
2082:

Line 2118: WHEN FND_API.G_EXC_ERROR THEN

2114: OE_MSG_PUB.Reset_Msg_Context('LINE');
2115: ELSIF p_header_id IS NOT NULL THEN
2116: OE_MSG_PUB.Reset_Msg_Context('HEADER');
2117: END IF;
2118: WHEN FND_API.G_EXC_ERROR THEN
2119: ROLLBACK TO UPDATE_FLOW_STATUS_CODE;
2120: IF l_debug_level > 0 THEN
2121: oe_debug_pub.add( 'UPDATE_FLOW_STATUS_CODE: ERROR' , 5 ) ;
2122: END IF;

Line 2123: x_return_status := FND_API.G_RET_STS_ERROR;

2119: ROLLBACK TO UPDATE_FLOW_STATUS_CODE;
2120: IF l_debug_level > 0 THEN
2121: oe_debug_pub.add( 'UPDATE_FLOW_STATUS_CODE: ERROR' , 5 ) ;
2122: END IF;
2123: x_return_status := FND_API.G_RET_STS_ERROR;
2124: IF p_line_id IS NOT NULL THEN
2125: OE_MSG_PUB.Reset_Msg_Context('LINE');
2126: ELSIF p_header_id IS NOT NULL THEN
2127: OE_MSG_PUB.Reset_Msg_Context('HEADER');

Line 2134: x_return_status := FND_API.G_RET_STS_ERROR;

2130: ROLLBACK TO UPDATE_FLOW_STATUS_CODE;
2131: IF l_debug_level > 0 THEN
2132: oe_debug_pub.add( 'UPDATE_FLOW_STATUS_CODE: LOCK EXC' , 5 ) ;
2133: END IF;
2134: x_return_status := FND_API.G_RET_STS_ERROR;
2135: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2136: THEN
2137: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
2138: OE_MSG_PUB.Add;

Line 2150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2146: ROLLBACK TO UPDATE_FLOW_STATUS_CODE;
2147: IF l_debug_level > 0 THEN
2148: oe_debug_pub.add( 'UPDATE_FLOW_STATUS_CODE: UNEXP ERROR' , 5 ) ;
2149: END IF;
2150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2151: IF FND_MSG_PUB.Check_Msg_Level
2152: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2153: THEN
2154: OE_MSG_PUB.Add_Exc_Msg

Line 2324: x_return_status := FND_API.G_RET_STS_SUCCESS;

2320: END IF;
2321:
2322: SAVEPOINT UPDATE_QUOTE_BLANKET;
2323:
2324: x_return_status := FND_API.G_RET_STS_SUCCESS;
2325:
2326: -- Check if the ASO is installed to call the NOTIFY_OC.
2327: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
2328: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);

Line 2356: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2352: IF l_sales_document_type_code = 'O' THEN
2353: OE_Header_Util.Lock_Row(p_header_id=>l_header_id
2354: , p_x_header_rec=>l_header_rec
2355: , x_return_status => l_return_status);
2356: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2357: RAISE FND_API.G_EXC_ERROR;
2358: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2360: END IF;

Line 2357: RAISE FND_API.G_EXC_ERROR;

2353: OE_Header_Util.Lock_Row(p_header_id=>l_header_id
2354: , p_x_header_rec=>l_header_rec
2355: , x_return_status => l_return_status);
2356: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2357: RAISE FND_API.G_EXC_ERROR;
2358: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2360: END IF;
2361:

Line 2358: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2354: , p_x_header_rec=>l_header_rec
2355: , x_return_status => l_return_status);
2356: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2357: RAISE FND_API.G_EXC_ERROR;
2358: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2360: END IF;
2361:
2362: -- is entity HEADER correct?

Line 2359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2355: , x_return_status => l_return_status);
2356: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2357: RAISE FND_API.G_EXC_ERROR;
2358: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2360: END IF;
2361:
2362: -- is entity HEADER correct?
2363: OE_MSG_PUB.set_msg_context

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

2455: oe_debug_pub.add( 'INDEX IS: ' || L_INDEX , 1 ) ;
2456: oe_debug_pub.add( 'HEADER FLOW STATUS IS: ' || P_FLOW_STATUS_CODE , 1 ) ;
2457: END IF;
2458:
2459: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2461: END IF;
2462:
2463: IF l_index is not NULL THEN

Line 2460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2456: oe_debug_pub.add( 'HEADER FLOW STATUS IS: ' || P_FLOW_STATUS_CODE , 1 ) ;
2457: END IF;
2458:
2459: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2461: END IF;
2462:
2463: IF l_index is not NULL THEN
2464: -- update global picture directly

Line 2494: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2490: ( p_header_rec => l_header_rec
2491: ,p_old_header_rec => l_old_header_rec
2492: ,x_return_status => l_return_status);
2493:
2494: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2495: IF l_debug_level > 0 THEN
2496: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_ERROR exception',2);
2497: END IF;
2498: RAISE FND_API.G_EXC_ERROR;

Line 2496: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_ERROR exception',2);

2492: ,x_return_status => l_return_status);
2493:
2494: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2495: IF l_debug_level > 0 THEN
2496: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_ERROR exception',2);
2497: END IF;
2498: RAISE FND_API.G_EXC_ERROR;
2499: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2500: IF l_debug_level > 0 THEN

Line 2498: RAISE FND_API.G_EXC_ERROR;

2494: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2495: IF l_debug_level > 0 THEN
2496: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_ERROR exception',2);
2497: END IF;
2498: RAISE FND_API.G_EXC_ERROR;
2499: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2500: IF l_debug_level > 0 THEN
2501: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',2);
2502: END IF;

Line 2499: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2495: IF l_debug_level > 0 THEN
2496: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_ERROR exception',2);
2497: END IF;
2498: RAISE FND_API.G_EXC_ERROR;
2499: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2500: IF l_debug_level > 0 THEN
2501: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',2);
2502: END IF;
2503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2501: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',2);

2497: END IF;
2498: RAISE FND_API.G_EXC_ERROR;
2499: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2500: IF l_debug_level > 0 THEN
2501: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',2);
2502: END IF;
2503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2504: END IF; -- bug 4732614 ends
2505: ELSIF l_sales_document_type_code = 'B' THEN -- Blanket Negotitation/Fulfillment

Line 2503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2499: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2500: IF l_debug_level > 0 THEN
2501: Oe_Debug_pub.Add('Process_Requests_And_Notify,return_status='||l_return_status||',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',2);
2502: END IF;
2503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2504: END IF; -- bug 4732614 ends
2505: ELSIF l_sales_document_type_code = 'B' THEN -- Blanket Negotitation/Fulfillment
2506: SELECT lock_control
2507: INTO l_blanket_lock_control

Line 2519: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2515: , p_x_lock_control=>l_blanket_lock_control
2516: , x_return_status => l_return_status
2517: , x_msg_count => l_msg_count
2518: , x_msg_data => l_msg_data);
2519: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2520: RAISE FND_API.G_EXC_ERROR;
2521: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2523: END IF;

Line 2520: RAISE FND_API.G_EXC_ERROR;

2516: , x_return_status => l_return_status
2517: , x_msg_count => l_msg_count
2518: , x_msg_data => l_msg_data);
2519: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2520: RAISE FND_API.G_EXC_ERROR;
2521: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2523: END IF;
2524:

Line 2521: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2517: , x_msg_count => l_msg_count
2518: , x_msg_data => l_msg_data);
2519: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2520: RAISE FND_API.G_EXC_ERROR;
2521: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2523: END IF;
2524:
2525: OE_MSG_PUB.set_msg_context

Line 2522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2518: , x_msg_data => l_msg_data);
2519: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2520: RAISE FND_API.G_EXC_ERROR;
2521: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2523: END IF;
2524:
2525: OE_MSG_PUB.set_msg_context
2526: ( p_entity_code => 'BLANKET'

Line 2591: x_return_status := FND_API.G_RET_STS_ERROR;

2587: ROLLBACK TO UPDATE_QUOTE_BLANKET;
2588: IF l_debug_level > 0 THEN
2589: oe_debug_pub.add( 'UPDATE_QUOTE_BLANKET: NO_DATA_FOUND' ) ;
2590: END IF;
2591: x_return_status := FND_API.G_RET_STS_ERROR;
2592: IF l_header_id IS NOT NULL THEN
2593: OE_MSG_PUB.Reset_Msg_Context('HEADER');
2594: END IF;
2595: WHEN FND_API.G_EXC_ERROR THEN

Line 2595: WHEN FND_API.G_EXC_ERROR THEN

2591: x_return_status := FND_API.G_RET_STS_ERROR;
2592: IF l_header_id IS NOT NULL THEN
2593: OE_MSG_PUB.Reset_Msg_Context('HEADER');
2594: END IF;
2595: WHEN FND_API.G_EXC_ERROR THEN
2596: ROLLBACK TO UPDATE_QUOTE_BLANKET;
2597: IF l_debug_level > 0 THEN
2598: oe_debug_pub.add( 'UPDATE_QUOTE_BLANKET: ERROR' , 5 ) ;
2599: END IF;

Line 2600: x_return_status := FND_API.G_RET_STS_ERROR;

2596: ROLLBACK TO UPDATE_QUOTE_BLANKET;
2597: IF l_debug_level > 0 THEN
2598: oe_debug_pub.add( 'UPDATE_QUOTE_BLANKET: ERROR' , 5 ) ;
2599: END IF;
2600: x_return_status := FND_API.G_RET_STS_ERROR;
2601: IF l_header_id IS NOT NULL THEN
2602: OE_MSG_PUB.Reset_Msg_Context('HEADER');
2603: END IF;
2604: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

Line 2609: x_return_status := FND_API.G_RET_STS_ERROR;

2605: ROLLBACK TO UPDATE_QUOTE_BLANKET;
2606: IF l_debug_level > 0 THEN
2607: oe_debug_pub.add( 'UPDATE_QUOTE_BLANKET: LOCK EXC' , 5 ) ;
2608: END IF;
2609: x_return_status := FND_API.G_RET_STS_ERROR;
2610: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2611: THEN
2612: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
2613: OE_MSG_PUB.Add;

Line 2623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2619: ROLLBACK TO UPDATE_QUOTE_BLANKET;
2620: IF l_debug_level > 0 THEN
2621: oe_debug_pub.add( 'UPDATE_QUOTE_BLANKET: UNEXP ERROR' , 5 ) ;
2622: END IF;
2623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2624: IF FND_MSG_PUB.Check_Msg_Level
2625: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2626: THEN
2627: OE_MSG_PUB.Add_Exc_Msg

Line 2746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2742: OE_MSG_PUB.Add_Exc_Msg
2743: ( G_PKG_NAME
2744: , 'Create_WorkItem_Upgrade'
2745: );
2746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2747: END IF;
2748:
2749: END Create_WorkItem_Upgrade;
2750:

Line 2798: WHEN FND_API.G_EXC_ERROR THEN

2794: oe_debug_pub.add( 'EXITING CREATESTART_HDRPROCESSINTERNAL' ) ;
2795: END IF;
2796:
2797: EXCEPTION
2798: WHEN FND_API.G_EXC_ERROR THEN
2799: RAISE;
2800: WHEN OTHERS THEN
2801: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2802: THEN

Line 2807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2803: OE_MSG_PUB.Add_Exc_Msg
2804: ( G_PKG_NAME
2805: , 'CreateStart_HdrInternal'
2806: );
2807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2808: END IF;
2809:
2810: END CreateStart_HdrInternal;
2811:

Line 2947: WHEN FND_API.G_EXC_ERROR THEN

2943: oe_debug_pub.add( 'EXITING CREATE_HDRWORKITEMINTERNAL' ) ;
2944: END IF;
2945:
2946: EXCEPTION
2947: WHEN FND_API.G_EXC_ERROR THEN
2948: RAISE;
2949: WHEN OTHERS THEN
2950: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2951: THEN

Line 2956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2952: OE_MSG_PUB.Add_Exc_Msg
2953: ( G_PKG_NAME
2954: , 'Create_HdrWorkItemInternal'
2955: );
2956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2957: END IF;
2958:
2959: END Create_HdrWorkItemInternal;
2960:

Line 2989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2985: OE_MSG_PUB.Add_Exc_Msg
2986: ( G_PKG_NAME
2987: , 'Set_Negotiate_Hdr_User_Key'
2988: );
2989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2990: END IF;
2991: END Set_Negotiate_Hdr_User_Key;
2992:
2993:

Line 3016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3012: OE_MSG_PUB.Add_Exc_Msg
3013: ( G_PKG_NAME
3014: , 'Set_Blanket_Hdr_User_Key'
3015: );
3016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3017: END IF;
3018: END Set_Blanket_Hdr_User_Key;
3019:
3020:

Line 3802: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

3798: END check_credit_hold;
3799:
3800: PROCEDURE Complete_eligible_and_Book
3801: ( p_api_version_number IN NUMBER
3802: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3803: , p_header_id IN NUMBER
3804: , x_return_status OUT NOCOPY VARCHAR2
3805: , x_msg_count OUT NOCOPY NUMBER
3806: , x_msg_data OUT NOCOPY VARCHAR2

Line 3949: WHEN FND_API.G_EXC_ERROR THEN

3945: END IF; -- l_activity_Cur%NOTFOUND
3946:
3947:
3948: EXCEPTION
3949: WHEN FND_API.G_EXC_ERROR THEN
3950: x_return_status := FND_API.G_RET_STS_ERROR;
3951: IF (book_eligible%ISOPEN) THEN
3952: CLOSE book_eligible;
3953: END IF;

Line 3950: x_return_status := FND_API.G_RET_STS_ERROR;

3946:
3947:
3948: EXCEPTION
3949: WHEN FND_API.G_EXC_ERROR THEN
3950: x_return_status := FND_API.G_RET_STS_ERROR;
3951: IF (book_eligible%ISOPEN) THEN
3952: CLOSE book_eligible;
3953: END IF;
3954: OE_MSG_PUB.Count_And_Get

Line 3959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3955: ( p_count => x_msg_count
3956: , p_data => x_msg_data
3957: );
3958: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');
3959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3961: IF (book_eligible%ISOPEN) THEN
3962: CLOSE book_eligible;
3963: END IF;

Line 3960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3956: , p_data => x_msg_data
3957: );
3958: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');
3959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3961: IF (book_eligible%ISOPEN) THEN
3962: CLOSE book_eligible;
3963: END IF;
3964: OE_MSG_PUB.Count_And_Get

Line 3970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3966: , p_data => x_msg_data
3967: );
3968: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');
3969: WHEN OTHERS THEN
3970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3971: IF (book_eligible%ISOPEN) THEN
3972: CLOSE book_eligible;
3973: END IF;
3974: IF OE_MSG_PUB.Check_Msg_Level