DBA Data[Home] [Help]

APPS.OE_BULK_CACHE dependencies on FND_API

Line 142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1030: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1506: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1659: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1807: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1978: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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