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.

[Home] [Help]

APPS.OE_ORDER_WF_UTIL dependencies on FND_API

Line 31: p_wfasgn_item_type IN VARCHAR2 := fnd_api.g_miss_char,

27: -- be created.
28: FUNCTION get_processname (
29: p_itemtype IN VARCHAR2,
30: p_itemkey IN VARCHAR2,
31: p_wfasgn_item_type IN VARCHAR2 := fnd_api.g_miss_char,
32: p_salesdocumenttypecode IN VARCHAR2 DEFAULT NULL,
33: p_line_rec IN oe_order_pub.line_rec_type
34: := oe_order_pub.g_miss_line_rec
35: )

Line 171: RAISE fnd_api.g_exc_error;

167:
168: CLOSE find_bktngohdrprocessname;
169: ELSE
170: -- error
171: RAISE fnd_api.g_exc_error;
172: END IF;
173: ELSIF (p_itemtype = oe_globals.g_wfi_bkt)
174: THEN
175: OPEN find_blankethdrprocessname (p_itemkey);

Line 204: RAISE fnd_api.g_exc_error;

200: WHEN NO_DATA_FOUND
201: THEN
202: fnd_message.set_name ('ONT', 'OE_MISS_FLOW');
203: oe_msg_pub.ADD;
204: RAISE fnd_api.g_exc_error;
205: WHEN OTHERS
206: THEN
207: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
208: THEN

Line 210: RAISE fnd_api.g_exc_unexpected_error;

206: THEN
207: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
208: THEN
209: oe_msg_pub.add_exc_msg (g_pkg_name, 'GET_ProcessName');
210: RAISE fnd_api.g_exc_unexpected_error;
211: END IF;
212: END get_processname;
213:
214: PROCEDURE set_header_descriptor (

Line 342: RAISE fnd_api.g_exc_unexpected_error;

338: THEN
339: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
340: THEN
341: oe_msg_pub.add_exc_msg (g_pkg_name, 'Set_Header_Descriptor');
342: RAISE fnd_api.g_exc_unexpected_error;
343: END IF;
344: END set_header_descriptor;
345:
346: PROCEDURE set_line_descriptor (

Line 450: RAISE fnd_api.g_exc_unexpected_error;

446: THEN
447: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
448: THEN
449: oe_msg_pub.add_exc_msg (g_pkg_name, 'Set_Line_Descriptor');
450: RAISE fnd_api.g_exc_unexpected_error;
451: END IF;
452: END set_line_descriptor;
453:
454: PROCEDURE set_header_user_key (p_header_rec IN oe_order_pub.header_rec_type)

Line 477: RAISE fnd_api.g_exc_unexpected_error;

473: THEN
474: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
475: THEN
476: oe_msg_pub.add_exc_msg (g_pkg_name, 'Set_Header_User_Key');
477: RAISE fnd_api.g_exc_unexpected_error;
478: END IF;
479: END set_header_user_key;
480:
481: PROCEDURE set_line_user_key (p_line_rec IN oe_order_pub.line_rec_type)

Line 520: RAISE fnd_api.g_exc_unexpected_error;

516: THEN
517: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
518: THEN
519: oe_msg_pub.add_exc_msg (g_pkg_name, 'Set_Line_User_Key');
520: RAISE fnd_api.g_exc_unexpected_error;
521: END IF;
522: END set_line_user_key;
523:
524: -- This procedure starts the flow, by calling WF_ENGINE utilities.

Line 549: RAISE fnd_api.g_exc_unexpected_error;

545: THEN
546: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
547: THEN
548: oe_msg_pub.add_exc_msg (g_pkg_name, 'Start_Flow');
549: RAISE fnd_api.g_exc_unexpected_error;
550: END IF;
551: END start_flow;
552:
553: PROCEDURE start_linefork (p_itemkey IN VARCHAR2)

Line 583: RAISE fnd_api.g_exc_unexpected_error;

579:
580: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
581: THEN
582: oe_msg_pub.add_exc_msg (g_pkg_name, 'Start_LineFork');
583: RAISE fnd_api.g_exc_unexpected_error;
584: END IF;
585: END start_linefork;
586:
587: -- This process is called from OE_ORDER_PVT.HEader to create the

Line 633: WHEN fnd_api.g_exc_error

629: THEN
630: oe_debug_pub.ADD ('EXITING CREATESTART_HDRPROCESS');
631: END IF;
632: EXCEPTION
633: WHEN fnd_api.g_exc_error
634: THEN -- 2590433
635: RAISE;
636: WHEN OTHERS
637: THEN

Line 641: RAISE fnd_api.g_exc_unexpected_error;

637: THEN
638: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
639: THEN
640: oe_msg_pub.add_exc_msg (g_pkg_name, 'Start_HdrProcess');
641: RAISE fnd_api.g_exc_unexpected_error;
642: END IF;
643: END createstart_hdrprocess;
644:
645: -- This procedure creates the Header WorkItem

Line 759: WHEN fnd_api.g_exc_error

755: THEN
756: oe_debug_pub.ADD ('EXITING CREATE_HDRWORKITEM');
757: END IF;
758: EXCEPTION
759: WHEN fnd_api.g_exc_error
760: THEN -- 2590433
761: RAISE;
762: WHEN OTHERS
763: THEN

Line 767: RAISE fnd_api.g_exc_unexpected_error;

763: THEN
764: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
765: THEN
766: oe_msg_pub.add_exc_msg (g_pkg_name, 'Create_HdrWorkItem');
767: RAISE fnd_api.g_exc_unexpected_error;
768: END IF;
769: END create_hdrworkitem;
770:
771: -- THis is called from OE_ORDER_PVT.LINES to create the Line

Line 849: WHEN fnd_api.g_exc_error

845: oe_debug_pub.ADD ('EXITING CREATESTART_LINEPROCESS');
846: END IF;
847: END IF;
848: EXCEPTION
849: WHEN fnd_api.g_exc_error
850: THEN -- 2590433
851: RAISE;
852: WHEN OTHERS
853: THEN

Line 857: RAISE fnd_api.g_exc_unexpected_error;

853: THEN
854: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
855: THEN
856: oe_msg_pub.add_exc_msg (g_pkg_name, 'CreateStart_LineProcess');
857: RAISE fnd_api.g_exc_unexpected_error;
858: END IF;
859: END createstart_lineprocess;
860:
861: PROCEDURE createstart_linefork (p_line_rec IN oe_order_pub.line_rec_type)

Line 885: RAISE fnd_api.g_exc_unexpected_error;

881: THEN
882: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
883: THEN
884: oe_msg_pub.add_exc_msg (g_pkg_name, 'CreateStart_LineFork');
885: RAISE fnd_api.g_exc_unexpected_error;
886: END IF;
887: END createstart_linefork;
888:
889: -- This procedure creates the Line WorkItem.

Line 985: WHEN fnd_api.g_exc_error

981: THEN
982: oe_debug_pub.ADD ('EXITING CREATE_LINEWORKITEM');
983: END IF;
984: EXCEPTION
985: WHEN fnd_api.g_exc_error
986: THEN -- 2590433
987: RAISE;
988: WHEN OTHERS
989: THEN

Line 993: RAISE fnd_api.g_exc_unexpected_error;

989: THEN
990: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
991: THEN
992: oe_msg_pub.add_exc_msg (g_pkg_name, 'Create_LineWorkItem');
993: RAISE fnd_api.g_exc_unexpected_error;
994: END IF;
995: END create_lineworkitem;
996:
997: PROCEDURE create_linefork (p_line_rec IN oe_order_pub.line_rec_type)

Line 1038: RAISE fnd_api.g_exc_unexpected_error;

1034:
1035: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
1036: THEN
1037: oe_msg_pub.add_exc_msg (g_pkg_name, 'Create_LineFork');
1038: RAISE fnd_api.g_exc_unexpected_error;
1039: END IF;
1040: END create_linefork;
1041:
1042: FUNCTION get_wf_item_type (p_line_rec IN oe_order_pub.line_rec_type)

Line 1137: RAISE fnd_api.g_exc_error;

1133: RETURN 'SERVICE';
1134: ELSE
1135: fnd_message.set_name ('ONT', 'OE_INVALID_WF_ITEM_TYPE');
1136: oe_msg_pub.ADD;
1137: RAISE fnd_api.g_exc_error;
1138: END IF;
1139: EXCEPTION
1140: WHEN OTHERS
1141: THEN

Line 1147: RAISE fnd_api.g_exc_unexpected_error;

1143: THEN
1144: oe_msg_pub.add_exc_msg (g_pkg_name, 'Get_Wf_Item_Type');
1145: END IF;
1146:
1147: RAISE fnd_api.g_exc_unexpected_error;
1148: END get_wf_item_type;
1149:
1150: -- This procedure starts flows for all the Header and Line records created in a Process Order
1151: -- Transaction. The WF item has been created when the record is written to the db - post_write

Line 1436: RAISE fnd_api.g_exc_unexpected_error;

1432: -- Rollback to savepoint
1433: ROLLBACK TO start_all_flows;
1434: -- Clear Globals
1435: clear_flowstart_globals;
1436: RAISE fnd_api.g_exc_unexpected_error;
1437: END IF;
1438: END start_all_flows;
1439:
1440: PROCEDURE clear_flowstart_globals

Line 1662: RAISE fnd_api.g_exc_unexpected_error;

1658:
1659: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
1660: THEN
1661: oe_msg_pub.add_exc_msg (g_pkg_name, 'Delete_Row');
1662: RAISE fnd_api.g_exc_unexpected_error;
1663: END IF;
1664: END IF;
1665:
1666: IF l_debug_level > 0

Line 1767: x_return_status := fnd_api.g_ret_sts_success;

1763: );
1764: END IF;
1765:
1766: SAVEPOINT update_flow_status_code;
1767: x_return_status := fnd_api.g_ret_sts_success;
1768:
1769: -- Check if the ASO is installed to call the NOTIFY_OC.
1770: IF oe_globals.g_aso_installed IS NULL
1771: THEN

Line 1796: RAISE fnd_api.g_exc_unexpected_error;

1792: THEN
1793: IF p_sales_document_type_code IS NULL
1794: THEN
1795: -- for Negotiation, you must pass the document type code
1796: RAISE fnd_api.g_exc_unexpected_error;
1797: END IF;
1798:
1799: IF p_sales_document_type_code = 'O'
1800: THEN

Line 1815: IF l_return_status = fnd_api.g_ret_sts_error

1811: p_x_header_rec => l_header_rec,
1812: x_return_status => l_return_status
1813: );
1814:
1815: IF l_return_status = fnd_api.g_ret_sts_error
1816: THEN
1817: RAISE fnd_api.g_exc_error;
1818: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
1819: THEN

Line 1817: RAISE fnd_api.g_exc_error;

1813: );
1814:
1815: IF l_return_status = fnd_api.g_ret_sts_error
1816: THEN
1817: RAISE fnd_api.g_exc_error;
1818: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
1819: THEN
1820: RAISE fnd_api.g_exc_unexpected_error;
1821: END IF;

Line 1818: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error

1814:
1815: IF l_return_status = fnd_api.g_ret_sts_error
1816: THEN
1817: RAISE fnd_api.g_exc_error;
1818: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
1819: THEN
1820: RAISE fnd_api.g_exc_unexpected_error;
1821: END IF;
1822:

Line 1820: RAISE fnd_api.g_exc_unexpected_error;

1816: THEN
1817: RAISE fnd_api.g_exc_error;
1818: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
1819: THEN
1820: RAISE fnd_api.g_exc_unexpected_error;
1821: END IF;
1822:
1823: -- is entity HEADER correct?
1824: oe_msg_pub.set_msg_context

Line 1905: IF (l_return_status <> fnd_api.g_ret_sts_success)

1901: 1
1902: );
1903: END IF;
1904:
1905: IF (l_return_status <> fnd_api.g_ret_sts_success)
1906: THEN
1907: RAISE fnd_api.g_exc_unexpected_error;
1908: END IF;
1909:

Line 1907: RAISE fnd_api.g_exc_unexpected_error;

1903: END IF;
1904:
1905: IF (l_return_status <> fnd_api.g_ret_sts_success)
1906: THEN
1907: RAISE fnd_api.g_exc_unexpected_error;
1908: END IF;
1909:
1910: IF l_index IS NOT NULL
1911: THEN

Line 1952: IF l_return_status = fnd_api.g_ret_sts_error

1948: p_old_header_rec => l_old_header_rec,
1949: x_return_status => l_return_status
1950: );
1951:
1952: IF l_return_status = fnd_api.g_ret_sts_error
1953: THEN
1954: IF l_debug_level > 0
1955: THEN
1956: oe_debug_pub.ADD

Line 1959: || ',Raising FND_API.G_EXC_ERROR exception',

1955: THEN
1956: oe_debug_pub.ADD
1957: ( 'Process_Requests_And_Notify,return_status='
1958: || l_return_status
1959: || ',Raising FND_API.G_EXC_ERROR exception',
1960: 2
1961: );
1962: END IF;
1963:

Line 1964: RAISE fnd_api.g_exc_error;

1960: 2
1961: );
1962: END IF;
1963:
1964: RAISE fnd_api.g_exc_error;
1965: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
1966: THEN
1967: IF l_debug_level > 0
1968: THEN

Line 1965: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error

1961: );
1962: END IF;
1963:
1964: RAISE fnd_api.g_exc_error;
1965: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
1966: THEN
1967: IF l_debug_level > 0
1968: THEN
1969: oe_debug_pub.ADD

Line 1972: || ',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',

1968: THEN
1969: oe_debug_pub.ADD
1970: ( 'Process_Requests_And_Notify,return_status='
1971: || l_return_status
1972: || ',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',
1973: 2
1974: );
1975: END IF;
1976:

Line 1977: RAISE fnd_api.g_exc_unexpected_error;

1973: 2
1974: );
1975: END IF;
1976:
1977: RAISE fnd_api.g_exc_unexpected_error;
1978: END IF; -- bug 4732614 ends
1979: ELSIF p_sales_document_type_code = 'B'
1980: THEN -- Blanket Negotitation
1981: IF l_debug_level > 0

Line 2004: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2000: , p_x_lock_control=>l_blanket_lock_control
2001: , x_return_status => l_return_status
2002: , x_msg_count => l_msg_count
2003: , x_msg_data => l_msg_data);
2004: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2005: RAISE FND_API.G_EXC_ERROR;
2006: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2008: END IF;

Line 2005: RAISE FND_API.G_EXC_ERROR;

2001: , x_return_status => l_return_status
2002: , x_msg_count => l_msg_count
2003: , x_msg_data => l_msg_data);
2004: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2005: RAISE FND_API.G_EXC_ERROR;
2006: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2008: END IF;
2009:

Line 2006: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2002: , x_msg_count => l_msg_count
2003: , x_msg_data => l_msg_data);
2004: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2005: RAISE FND_API.G_EXC_ERROR;
2006: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2008: END IF;
2009:
2010: OE_MSG_PUB.set_msg_context

Line 2007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2003: , x_msg_data => l_msg_data);
2004: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2005: RAISE FND_API.G_EXC_ERROR;
2006: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2008: END IF;
2009:
2010: OE_MSG_PUB.set_msg_context
2011: ( p_entity_code => 'BLANKET'

Line 2051: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2047: , p_x_lock_control=>l_blanket_lock_control
2048: , x_return_status => l_return_status
2049: , x_msg_count => l_msg_count
2050: , x_msg_data => l_msg_data);
2051: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2052: RAISE FND_API.G_EXC_ERROR;
2053: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2055: END IF;

Line 2052: RAISE FND_API.G_EXC_ERROR;

2048: , x_return_status => l_return_status
2049: , x_msg_count => l_msg_count
2050: , x_msg_data => l_msg_data);
2051: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2052: RAISE FND_API.G_EXC_ERROR;
2053: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2055: END IF;
2056: */-- set msg context follows

Line 2053: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2049: , x_msg_count => l_msg_count
2050: , x_msg_data => l_msg_data);
2051: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2052: RAISE FND_API.G_EXC_ERROR;
2053: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2055: END IF;
2056: */-- set msg context follows
2057: UPDATE oe_blanket_headers_all

Line 2054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2050: , x_msg_data => l_msg_data);
2051: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2052: RAISE FND_API.G_EXC_ERROR;
2053: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2055: END IF;
2056: */-- set msg context follows
2057: UPDATE oe_blanket_headers_all
2058: SET flow_status_code = p_flow_status_code

Line 2095: IF l_return_status = fnd_api.g_ret_sts_error

2091: x_line_tbl => l_old_line_tbl,
2092: x_return_status => l_return_status
2093: );
2094:
2095: IF l_return_status = fnd_api.g_ret_sts_error
2096: THEN
2097: RAISE fnd_api.g_exc_error;
2098: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2099: THEN

Line 2097: RAISE fnd_api.g_exc_error;

2093: );
2094:
2095: IF l_return_status = fnd_api.g_ret_sts_error
2096: THEN
2097: RAISE fnd_api.g_exc_error;
2098: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2099: THEN
2100: RAISE fnd_api.g_exc_unexpected_error;
2101: END IF;

Line 2098: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error

2094:
2095: IF l_return_status = fnd_api.g_ret_sts_error
2096: THEN
2097: RAISE fnd_api.g_exc_error;
2098: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2099: THEN
2100: RAISE fnd_api.g_exc_unexpected_error;
2101: END IF;
2102:

Line 2100: RAISE fnd_api.g_exc_unexpected_error;

2096: THEN
2097: RAISE fnd_api.g_exc_error;
2098: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2099: THEN
2100: RAISE fnd_api.g_exc_unexpected_error;
2101: END IF;
2102:
2103: oe_msg_pub.set_msg_context
2104: (p_entity_code => 'LINE',

Line 2168: IF l_return_status = fnd_api.g_ret_sts_error

2164: p_x_header_rec => l_header_rec,
2165: x_return_status => l_return_status
2166: );
2167:
2168: IF l_return_status = fnd_api.g_ret_sts_error
2169: THEN
2170: RAISE fnd_api.g_exc_error;
2171: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2172: THEN

Line 2170: RAISE fnd_api.g_exc_error;

2166: );
2167:
2168: IF l_return_status = fnd_api.g_ret_sts_error
2169: THEN
2170: RAISE fnd_api.g_exc_error;
2171: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2172: THEN
2173: RAISE fnd_api.g_exc_unexpected_error;
2174: END IF;

Line 2171: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error

2167:
2168: IF l_return_status = fnd_api.g_ret_sts_error
2169: THEN
2170: RAISE fnd_api.g_exc_error;
2171: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2172: THEN
2173: RAISE fnd_api.g_exc_unexpected_error;
2174: END IF;
2175:

Line 2173: RAISE fnd_api.g_exc_unexpected_error;

2169: THEN
2170: RAISE fnd_api.g_exc_error;
2171: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2172: THEN
2173: RAISE fnd_api.g_exc_unexpected_error;
2174: END IF;
2175:
2176: oe_msg_pub.set_msg_context
2177: (p_entity_code => 'HEADER',

Line 2260: IF (l_return_status <> fnd_api.g_ret_sts_success)

2256: oe_debug_pub.ADD ('INDEX IS: ' || l_index, 1);
2257: END IF;
2258:
2259: --OE_DEBUG_PUB.ADD('Line Flow Status is: ' || p_flow_status_code ,1);
2260: IF (l_return_status <> fnd_api.g_ret_sts_success)
2261: THEN
2262: RAISE fnd_api.g_exc_unexpected_error;
2263: END IF;
2264:

Line 2262: RAISE fnd_api.g_exc_unexpected_error;

2258:
2259: --OE_DEBUG_PUB.ADD('Line Flow Status is: ' || p_flow_status_code ,1);
2260: IF (l_return_status <> fnd_api.g_ret_sts_success)
2261: THEN
2262: RAISE fnd_api.g_exc_unexpected_error;
2263: END IF;
2264:
2265: IF l_index IS NOT NULL
2266: THEN

Line 2324: IF l_return_status = fnd_api.g_ret_sts_error

2320: p_old_line_tbl => l_old_line_tbl,
2321: x_return_status => l_return_status
2322: );
2323:
2324: IF l_return_status = fnd_api.g_ret_sts_error
2325: THEN
2326: IF l_debug_level > 0
2327: THEN
2328: oe_debug_pub.ADD

Line 2331: || ',Raising FND_API.G_EXC_ERROR exception',

2327: THEN
2328: oe_debug_pub.ADD
2329: ( 'Process_Requests_And_Notify,return_status='
2330: || l_return_status
2331: || ',Raising FND_API.G_EXC_ERROR exception',
2332: 2
2333: );
2334: END IF;
2335:

Line 2336: RAISE fnd_api.g_exc_error;

2332: 2
2333: );
2334: END IF;
2335:
2336: RAISE fnd_api.g_exc_error;
2337: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2338: THEN
2339: IF l_debug_level > 0
2340: THEN

Line 2337: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error

2333: );
2334: END IF;
2335:
2336: RAISE fnd_api.g_exc_error;
2337: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2338: THEN
2339: IF l_debug_level > 0
2340: THEN
2341: oe_debug_pub.ADD

Line 2344: || ',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',

2340: THEN
2341: oe_debug_pub.ADD
2342: ( 'Process_Requests_And_Notify,return_status='
2343: || l_return_status
2344: || ',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',
2345: 2
2346: );
2347: END IF;
2348:

Line 2349: RAISE fnd_api.g_exc_unexpected_error;

2345: 2
2346: );
2347: END IF;
2348:
2349: RAISE fnd_api.g_exc_unexpected_error;
2350: END IF; -- bug 4732614 ends
2351: END IF; /*ASO installed */
2352:
2353: oe_msg_pub.reset_msg_context ('LINE');

Line 2520: IF (l_return_status <> fnd_api.g_ret_sts_success)

2516: 1
2517: );
2518: END IF;
2519:
2520: IF (l_return_status <> fnd_api.g_ret_sts_success)
2521: THEN
2522: RAISE fnd_api.g_exc_unexpected_error;
2523: END IF;
2524:

Line 2522: RAISE fnd_api.g_exc_unexpected_error;

2518: END IF;
2519:
2520: IF (l_return_status <> fnd_api.g_ret_sts_success)
2521: THEN
2522: RAISE fnd_api.g_exc_unexpected_error;
2523: END IF;
2524:
2525: IF l_index IS NOT NULL
2526: THEN

Line 2565: IF l_return_status = fnd_api.g_ret_sts_error

2561: p_old_header_rec => l_old_header_rec,
2562: x_return_status => l_return_status
2563: );
2564:
2565: IF l_return_status = fnd_api.g_ret_sts_error
2566: THEN
2567: IF l_debug_level > 0
2568: THEN
2569: oe_debug_pub.ADD

Line 2572: || ',Raising FND_API.G_EXC_ERROR exception',

2568: THEN
2569: oe_debug_pub.ADD
2570: ( 'Process_Requests_And_Notify,return_status='
2571: || l_return_status
2572: || ',Raising FND_API.G_EXC_ERROR exception',
2573: 2
2574: );
2575: END IF;
2576:

Line 2577: RAISE fnd_api.g_exc_error;

2573: 2
2574: );
2575: END IF;
2576:
2577: RAISE fnd_api.g_exc_error;
2578: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2579: THEN
2580: IF l_debug_level > 0
2581: THEN

Line 2578: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error

2574: );
2575: END IF;
2576:
2577: RAISE fnd_api.g_exc_error;
2578: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2579: THEN
2580: IF l_debug_level > 0
2581: THEN
2582: oe_debug_pub.ADD

Line 2585: || ',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',

2581: THEN
2582: oe_debug_pub.ADD
2583: ( 'Process_Requests_And_Notify,return_status='
2584: || l_return_status
2585: || ',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',
2586: 2
2587: );
2588: END IF;
2589:

Line 2590: RAISE fnd_api.g_exc_unexpected_error;

2586: 2
2587: );
2588: END IF;
2589:
2590: RAISE fnd_api.g_exc_unexpected_error;
2591: END IF; -- bug 4732614 ends
2592: ELSE
2593: IF l_debug_level > 0
2594: THEN

Line 2599: x_return_status := fnd_api.g_ret_sts_unexp_error;

2595: oe_debug_pub.ADD
2596: ('UPDATE_FLOW_STATUS_CODE: HEADER_ID AND LINE_ID ARE NULL');
2597: END IF;
2598:
2599: x_return_status := fnd_api.g_ret_sts_unexp_error;
2600: END IF;
2601: END IF; -- End of OENH/OEBH vs OEOH/OEOL processing
2602:
2603: --Bug 3356542

Line 2673: WHEN fnd_api.g_exc_error

2669: ELSIF p_header_id IS NOT NULL
2670: THEN
2671: oe_msg_pub.reset_msg_context ('HEADER');
2672: END IF;
2673: WHEN fnd_api.g_exc_error
2674: THEN
2675: ROLLBACK TO update_flow_status_code;
2676:
2677: IF l_debug_level > 0

Line 2682: x_return_status := fnd_api.g_ret_sts_error;

2678: THEN
2679: oe_debug_pub.ADD ('UPDATE_FLOW_STATUS_CODE: ERROR', 5);
2680: END IF;
2681:
2682: x_return_status := fnd_api.g_ret_sts_error;
2683:
2684: IF p_line_id IS NOT NULL
2685: THEN
2686: oe_msg_pub.reset_msg_context ('LINE');

Line 2700: x_return_status := fnd_api.g_ret_sts_error;

2696: THEN
2697: oe_debug_pub.ADD ('UPDATE_FLOW_STATUS_CODE: LOCK EXC', 5);
2698: END IF;
2699:
2700: x_return_status := fnd_api.g_ret_sts_error;
2701:
2702: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_error)
2703: THEN
2704: fnd_message.set_name ('ONT', 'OE_LOCK_ROW_ALREADY_LOCKED');

Line 2724: x_return_status := fnd_api.g_ret_sts_unexp_error;

2720: THEN
2721: oe_debug_pub.ADD ('UPDATE_FLOW_STATUS_CODE: UNEXP ERROR', 5);
2722: END IF;
2723:
2724: x_return_status := fnd_api.g_ret_sts_unexp_error;
2725:
2726: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2727: THEN
2728: oe_msg_pub.add_exc_msg (g_pkg_name, 'Update_Flow_Status_Code');

Line 2930: x_return_status := fnd_api.g_ret_sts_success;

2926: oe_debug_pub.ADD ('ENTERING UPDATE_QUOTE_BLANKET', 5);
2927: END IF;
2928:
2929: SAVEPOINT update_quote_blanket;
2930: x_return_status := fnd_api.g_ret_sts_success;
2931:
2932: -- Check if the ASO is installed to call the NOTIFY_OC.
2933: IF oe_globals.g_aso_installed IS NULL
2934: THEN

Line 2972: IF l_return_status = fnd_api.g_ret_sts_error

2968: p_x_header_rec => l_header_rec,
2969: x_return_status => l_return_status
2970: );
2971:
2972: IF l_return_status = fnd_api.g_ret_sts_error
2973: THEN
2974: RAISE fnd_api.g_exc_error;
2975: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2976: THEN

Line 2974: RAISE fnd_api.g_exc_error;

2970: );
2971:
2972: IF l_return_status = fnd_api.g_ret_sts_error
2973: THEN
2974: RAISE fnd_api.g_exc_error;
2975: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2976: THEN
2977: RAISE fnd_api.g_exc_unexpected_error;
2978: END IF;

Line 2975: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error

2971:
2972: IF l_return_status = fnd_api.g_ret_sts_error
2973: THEN
2974: RAISE fnd_api.g_exc_error;
2975: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2976: THEN
2977: RAISE fnd_api.g_exc_unexpected_error;
2978: END IF;
2979:

Line 2977: RAISE fnd_api.g_exc_unexpected_error;

2973: THEN
2974: RAISE fnd_api.g_exc_error;
2975: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
2976: THEN
2977: RAISE fnd_api.g_exc_unexpected_error;
2978: END IF;
2979:
2980: -- is entity HEADER correct?
2981: oe_msg_pub.set_msg_context

Line 3111: IF (l_return_status <> fnd_api.g_ret_sts_success)

3107: 1
3108: );
3109: END IF;
3110:
3111: IF (l_return_status <> fnd_api.g_ret_sts_success)
3112: THEN
3113: RAISE fnd_api.g_exc_unexpected_error;
3114: END IF;
3115:

Line 3113: RAISE fnd_api.g_exc_unexpected_error;

3109: END IF;
3110:
3111: IF (l_return_status <> fnd_api.g_ret_sts_success)
3112: THEN
3113: RAISE fnd_api.g_exc_unexpected_error;
3114: END IF;
3115:
3116: IF l_index IS NOT NULL
3117: THEN

Line 3179: IF l_return_status = fnd_api.g_ret_sts_error

3175: p_old_header_rec => l_old_header_rec,
3176: x_return_status => l_return_status
3177: );
3178:
3179: IF l_return_status = fnd_api.g_ret_sts_error
3180: THEN
3181: IF l_debug_level > 0
3182: THEN
3183: oe_debug_pub.ADD

Line 3186: || ',Raising FND_API.G_EXC_ERROR exception',

3182: THEN
3183: oe_debug_pub.ADD
3184: ( 'Process_Requests_And_Notify,return_status='
3185: || l_return_status
3186: || ',Raising FND_API.G_EXC_ERROR exception',
3187: 2
3188: );
3189: END IF;
3190:

Line 3191: RAISE fnd_api.g_exc_error;

3187: 2
3188: );
3189: END IF;
3190:
3191: RAISE fnd_api.g_exc_error;
3192: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
3193: THEN
3194: IF l_debug_level > 0
3195: THEN

Line 3192: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error

3188: );
3189: END IF;
3190:
3191: RAISE fnd_api.g_exc_error;
3192: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
3193: THEN
3194: IF l_debug_level > 0
3195: THEN
3196: oe_debug_pub.ADD

Line 3199: || ',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',

3195: THEN
3196: oe_debug_pub.ADD
3197: ( 'Process_Requests_And_Notify,return_status='
3198: || l_return_status
3199: || ',Raising FND_API.G_EXC_UNEXPECTED_ERROR exception',
3200: 2
3201: );
3202: END IF;
3203:

Line 3204: RAISE fnd_api.g_exc_unexpected_error;

3200: 2
3201: );
3202: END IF;
3203:
3204: RAISE fnd_api.g_exc_unexpected_error;
3205: END IF; -- bug 4732614 ends
3206: ELSIF l_sales_document_type_code = 'B'
3207: THEN -- Blanket Negotitation/Fulfillment
3208: SELECT lock_control

Line 3221: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3217: , p_x_lock_control=>l_blanket_lock_control
3218: , x_return_status => l_return_status
3219: , x_msg_count => l_msg_count
3220: , x_msg_data => l_msg_data);
3221: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3222: RAISE FND_API.G_EXC_ERROR;
3223: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3225: END IF;

Line 3222: RAISE FND_API.G_EXC_ERROR;

3218: , x_return_status => l_return_status
3219: , x_msg_count => l_msg_count
3220: , x_msg_data => l_msg_data);
3221: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3222: RAISE FND_API.G_EXC_ERROR;
3223: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3225: END IF;
3226:

Line 3223: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3219: , x_msg_count => l_msg_count
3220: , x_msg_data => l_msg_data);
3221: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3222: RAISE FND_API.G_EXC_ERROR;
3223: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3225: END IF;
3226:
3227: OE_MSG_PUB.set_msg_context

Line 3224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3220: , x_msg_data => l_msg_data);
3221: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3222: RAISE FND_API.G_EXC_ERROR;
3223: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3225: END IF;
3226:
3227: OE_MSG_PUB.set_msg_context
3228: ( p_entity_code => 'BLANKET'

Line 3324: x_return_status := fnd_api.g_ret_sts_error;

3320: THEN
3321: oe_debug_pub.ADD ('UPDATE_QUOTE_BLANKET: NO_DATA_FOUND');
3322: END IF;
3323:
3324: x_return_status := fnd_api.g_ret_sts_error;
3325:
3326: IF l_header_id IS NOT NULL
3327: THEN
3328: oe_msg_pub.reset_msg_context ('HEADER');

Line 3330: WHEN fnd_api.g_exc_error

3326: IF l_header_id IS NOT NULL
3327: THEN
3328: oe_msg_pub.reset_msg_context ('HEADER');
3329: END IF;
3330: WHEN fnd_api.g_exc_error
3331: THEN
3332: ROLLBACK TO update_quote_blanket;
3333:
3334: IF l_debug_level > 0

Line 3339: x_return_status := fnd_api.g_ret_sts_error;

3335: THEN
3336: oe_debug_pub.ADD ('UPDATE_QUOTE_BLANKET: ERROR', 5);
3337: END IF;
3338:
3339: x_return_status := fnd_api.g_ret_sts_error;
3340:
3341: IF l_header_id IS NOT NULL
3342: THEN
3343: oe_msg_pub.reset_msg_context ('HEADER');

Line 3354: x_return_status := fnd_api.g_ret_sts_error;

3350: THEN
3351: oe_debug_pub.ADD ('UPDATE_QUOTE_BLANKET: LOCK EXC', 5);
3352: END IF;
3353:
3354: x_return_status := fnd_api.g_ret_sts_error;
3355:
3356: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_error)
3357: THEN
3358: fnd_message.set_name ('ONT', 'OE_LOCK_ROW_ALREADY_LOCKED');

Line 3375: x_return_status := fnd_api.g_ret_sts_unexp_error;

3371: THEN
3372: oe_debug_pub.ADD ('UPDATE_QUOTE_BLANKET: UNEXP ERROR', 5);
3373: END IF;
3374:
3375: x_return_status := fnd_api.g_ret_sts_unexp_error;
3376:
3377: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3378: THEN
3379: oe_msg_pub.add_exc_msg (g_pkg_name, 'Update_Quote_Blanket');

Line 3504: RAISE fnd_api.g_exc_unexpected_error;

3500: THEN
3501: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
3502: THEN
3503: oe_msg_pub.add_exc_msg (g_pkg_name, 'Create_WorkItem_Upgrade');
3504: RAISE fnd_api.g_exc_unexpected_error;
3505: END IF;
3506: END create_workitem_upgrade;
3507:
3508: PROCEDURE createstart_hdrinternal (

Line 3564: WHEN fnd_api.g_exc_error

3560: THEN
3561: oe_debug_pub.ADD ('EXITING CREATESTART_HDRPROCESSINTERNAL');
3562: END IF;
3563: EXCEPTION
3564: WHEN fnd_api.g_exc_error
3565: THEN
3566: RAISE;
3567: WHEN OTHERS
3568: THEN

Line 3572: RAISE fnd_api.g_exc_unexpected_error;

3568: THEN
3569: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
3570: THEN
3571: oe_msg_pub.add_exc_msg (g_pkg_name, 'CreateStart_HdrInternal');
3572: RAISE fnd_api.g_exc_unexpected_error;
3573: END IF;
3574: END createstart_hdrinternal;
3575:
3576: /* ----------------------------------------------------------

Line 3720: WHEN fnd_api.g_exc_error

3716: THEN
3717: oe_debug_pub.ADD ('EXITING CREATE_HDRWORKITEMINTERNAL');
3718: END IF;
3719: EXCEPTION
3720: WHEN fnd_api.g_exc_error
3721: THEN
3722: RAISE;
3723: WHEN OTHERS
3724: THEN

Line 3728: RAISE fnd_api.g_exc_unexpected_error;

3724: THEN
3725: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
3726: THEN
3727: oe_msg_pub.add_exc_msg (g_pkg_name, 'Create_HdrWorkItemInternal');
3728: RAISE fnd_api.g_exc_unexpected_error;
3729: END IF;
3730: END create_hdrworkiteminternal;
3731:
3732: PROCEDURE set_negotiate_hdr_user_key (

Line 3762: RAISE fnd_api.g_exc_unexpected_error;

3758: THEN
3759: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
3760: THEN
3761: oe_msg_pub.add_exc_msg (g_pkg_name, 'Set_Negotiate_Hdr_User_Key');
3762: RAISE fnd_api.g_exc_unexpected_error;
3763: END IF;
3764: END set_negotiate_hdr_user_key;
3765:
3766: PROCEDURE set_blanket_hdr_user_key (

Line 3785: RAISE fnd_api.g_exc_unexpected_error;

3781: THEN
3782: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
3783: THEN
3784: oe_msg_pub.add_exc_msg (g_pkg_name, 'Set_Blanket_Hdr_User_Key');
3785: RAISE fnd_api.g_exc_unexpected_error;
3786: END IF;
3787: END set_blanket_hdr_user_key;
3788:
3789: /******************************

Line 4951: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

4947: END check_credit_hold;
4948:
4949: PROCEDURE complete_eligible_and_book (
4950: p_api_version_number IN NUMBER,
4951: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
4952: p_header_id IN NUMBER,
4953: x_return_status OUT NOCOPY VARCHAR2,
4954: x_msg_count OUT NOCOPY NUMBER,
4955: x_msg_data OUT NOCOPY VARCHAR2

Line 5137: WHEN fnd_api.g_exc_error

5133: END IF; -- book_eligible%NOTFOUND
5134: END IF; -- l_booked_flag = 'N'
5135: END IF; -- l_activity_Cur%NOTFOUND
5136: EXCEPTION
5137: WHEN fnd_api.g_exc_error
5138: THEN
5139: x_return_status := fnd_api.g_ret_sts_error;
5140:
5141: IF (book_eligible%ISOPEN)

Line 5139: x_return_status := fnd_api.g_ret_sts_error;

5135: END IF; -- l_activity_Cur%NOTFOUND
5136: EXCEPTION
5137: WHEN fnd_api.g_exc_error
5138: THEN
5139: x_return_status := fnd_api.g_ret_sts_error;
5140:
5141: IF (book_eligible%ISOPEN)
5142: THEN
5143: CLOSE book_eligible;

Line 5150: WHEN fnd_api.g_exc_unexpected_error

5146: oe_msg_pub.count_and_get (p_count => x_msg_count,
5147: p_data => x_msg_data
5148: );
5149: oe_msg_pub.reset_msg_context (p_entity_code => 'HEADER');
5150: WHEN fnd_api.g_exc_unexpected_error
5151: THEN
5152: x_return_status := fnd_api.g_ret_sts_unexp_error;
5153:
5154: IF (book_eligible%ISOPEN)

Line 5152: x_return_status := fnd_api.g_ret_sts_unexp_error;

5148: );
5149: oe_msg_pub.reset_msg_context (p_entity_code => 'HEADER');
5150: WHEN fnd_api.g_exc_unexpected_error
5151: THEN
5152: x_return_status := fnd_api.g_ret_sts_unexp_error;
5153:
5154: IF (book_eligible%ISOPEN)
5155: THEN
5156: CLOSE book_eligible;

Line 5165: x_return_status := fnd_api.g_ret_sts_unexp_error;

5161: );
5162: oe_msg_pub.reset_msg_context (p_entity_code => 'HEADER');
5163: WHEN OTHERS
5164: THEN
5165: x_return_status := fnd_api.g_ret_sts_unexp_error;
5166:
5167: IF (book_eligible%ISOPEN)
5168: THEN
5169: CLOSE book_eligible;