DBA Data[Home] [Help]

APPS.OE_BULK_CACHE dependencies on FND_API

Line 143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

139: END IF;
140:
141: EXCEPTION
142: WHEN OTHERS THEN
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
144: IF OE_BULK_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
145: THEN
146: OE_BULK_MSG_PUB.Add_Exc_Msg
147: (G_PKG_NAME, 'Get_Address');

Line 378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

374: OE_BULK_MSG_PUB.Add_Exc_Msg
375: ( G_PKG_NAME
376: ,'Load_Order_Type'
377: );
378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
379: END Load_Order_Type;
380:
381: FUNCTION Load_Line_Type
382: ( p_key IN NUMBER

Line 439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

435: OE_BULK_MSG_PUB.Add_Exc_Msg
436: ( G_PKG_NAME
437: ,'Load_Line_Type'
438: );
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: END Load_Line_Type;
441:
442: FUNCTION Load_Agreement
443: ( p_key IN NUMBER

Line 558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

554: OE_BULK_MSG_PUB.Add_Exc_Msg
555: ( G_PKG_NAME
556: ,'Load_Agreement'
557: );
558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
559: END Load_Agreement;
560:
561: FUNCTION Load_Item
562: ( p_key1 IN NUMBER

Line 871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

867: OE_BULK_MSG_PUB.Add_Exc_Msg
868: ( G_PKG_NAME
869: , 'Load_Item'
870: );
871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
872:
873: IF l_debug_level > 0 THEN
874: oe_debug_pub.add( 'pal4 ' , 3 ) ;
875: END IF;

Line 1031: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1027: l_region2 => l_region2,
1028: l_region3 => l_region3,
1029: x_return_status => l_return_status);
1030:
1031: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1032: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1033: END IF;
1034: END IF;
1035:

Line 1032: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1028: l_region3 => l_region3,
1029: x_return_status => l_return_status);
1030:
1031: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1032: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1033: END IF;
1034: END IF;
1035:
1036: RETURN MOD(p_key,G_BINARY_LIMIT);

Line 1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1057: OE_BULK_MSG_PUB.Add_Exc_Msg
1058: ( G_PKG_NAME
1059: , 'Load_Ship_To'
1060: );
1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1062: END Load_Ship_To;
1063:
1064: FUNCTION Load_Sold_To
1065: ( p_key IN NUMBER

Line 1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1171: OE_BULK_MSG_PUB.Add_Exc_Msg
1172: ( G_PKG_NAME
1173: , 'Load_Sold_To'
1174: );
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: END Load_Sold_To;
1177:
1178: --{Bug 5054618
1179: FUNCTION Load_End_Customer

Line 1320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1316: OE_BULK_MSG_PUB.Add_Exc_Msg
1317: ( G_PKG_NAME
1318: , 'Load_End_Customer_To'
1319: );
1320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1321: END Load_End_customer;
1322:
1323: /*end customer changes */
1324:

Line 1507: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1503: l_region2 => l_region2,
1504: l_region3 => l_region3,
1505: x_return_status => l_return_status);
1506:
1507: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1509: END IF;
1510:
1511:

Line 1508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1504: l_region3 => l_region3,
1505: x_return_status => l_return_status);
1506:
1507: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1509: END IF;
1510:
1511:
1512:

Line 1541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1537: OE_BULK_MSG_PUB.Add_Exc_Msg
1538: ( G_PKG_NAME
1539: , 'Load_Sold_To_Site'
1540: );
1541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1542: END Load_End_Customer_Site;
1543:
1544: --Bug 5054618}
1545:

Line 1660: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1656: l_region2 => l_region2,
1657: l_region3 => l_region3,
1658: x_return_status => l_return_status);
1659:
1660: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1662: END IF;
1663: END IF;
1664:

Line 1661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1657: l_region3 => l_region3,
1658: x_return_status => l_return_status);
1659:
1660: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1662: END IF;
1663: END IF;
1664:
1665:

Line 1691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1687: OE_BULK_MSG_PUB.Add_Exc_Msg
1688: ( G_PKG_NAME
1689: , 'Load_Invoice_To'
1690: );
1691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1692: END Load_Invoice_To;
1693: /*sdatti*/
1694: FUNCTION Load_Sold_To_Site
1695: ( p_key IN NUMBER

Line 1808: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1804: l_region2 => l_region2,
1805: l_region3 => l_region3,
1806: x_return_status => l_return_status);
1807:
1808: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1810: END IF;
1811: END IF;
1812:

Line 1809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1805: l_region3 => l_region3,
1806: x_return_status => l_return_status);
1807:
1808: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1810: END IF;
1811: END IF;
1812:
1813:

Line 1839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1835: OE_BULK_MSG_PUB.Add_Exc_Msg
1836: ( G_PKG_NAME
1837: , 'Load_Sold_To_Site'
1838: );
1839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1840: END Load_Sold_To_Site;
1841: /*sdatti*/
1842: FUNCTION Load_Salesrep
1843: ( p_key IN NUMBER

Line 1898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1894: OE_BULK_MSG_PUB.Add_Exc_Msg
1895: ( G_PKG_NAME
1896: , 'Load_Salesrep'
1897: );
1898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1899: END Load_Salesrep;
1900:
1901: FUNCTION Load_Ship_From
1902: ( p_key IN NUMBER

Line 1979: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1975: l_region2 => l_region2,
1976: l_region3 => l_region3,
1977: x_return_status => l_return_status);
1978:
1979: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1981: END IF;
1982:
1983: G_SHIP_FROM_TBL(p_key).address1 := SUBSTR(l_addr1,0,30);

Line 1980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1976: l_region3 => l_region3,
1977: x_return_status => l_return_status);
1978:
1979: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1981: END IF;
1982:
1983: G_SHIP_FROM_TBL(p_key).address1 := SUBSTR(l_addr1,0,30);
1984: G_SHIP_FROM_TBL(p_key).address2 := SUBSTR(l_addr2,0,30);

Line 2021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2017: OE_BULK_MSG_PUB.Add_Exc_Msg
2018: ( G_PKG_NAME
2019: , 'Load_Ship_From'
2020: );
2021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2022: END Load_Ship_From;
2023:
2024: FUNCTION Load_Price_List
2025: ( p_key IN NUMBER

Line 2082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2078: OE_BULK_MSG_PUB.Add_Exc_Msg
2079: ( G_PKG_NAME
2080: , 'Load_Price_List'
2081: );
2082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2083: END Load_Price_List;
2084:
2085: FUNCTION IS_CC_REQUIRED
2086: ( p_key IN NUMBER

Line 2194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2190: OE_BULK_MSG_PUB.Add_Exc_Msg
2191: ( G_PKG_NAME
2192: ,'Load_Loc_Info'
2193: );
2194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2195: END Load_Loc_Info;
2196:
2197: FUNCTION Load_Tax_Attributes
2198: ( p_key IN VARCHAR2,

Line 2291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2287: OE_BULK_MSG_PUB.Add_Exc_Msg
2288: ( G_PKG_NAME
2289: ,'Load_Person'
2290: );
2291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2292: END Load_Person;
2293:
2294:
2295: