DBA Data[Home] [Help]

APPS.OE_BULK_CACHE dependencies on OE_BULK_MSG_PUB

Line 144: IF OE_BULK_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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');
148: END IF;

Line 146: OE_BULK_MSG_PUB.Add_Exc_Msg

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');
148: END IF;
149: END Get_Address;
150:

Line 374: OE_BULK_MSG_PUB.Add_Exc_Msg

370: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
371: END IF;
372: G_ORDER_TYPE_TBL.DELETE(p_key);
373: END IF;
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;

Line 435: OE_BULK_MSG_PUB.Add_Exc_Msg

431: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
432: END IF;
433: G_LINE_TYPE_TBL.DELETE(p_key);
434: END IF;
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;

Line 554: OE_BULK_MSG_PUB.Add_Exc_Msg

550: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
551: END IF;
552: G_AGREEMENT_TBL.DELETE(p_key);
553: END IF;
554: OE_BULK_MSG_PUB.Add_Exc_Msg
555: ( G_PKG_NAME
556: ,'Load_Agreement'
557: );
558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 855: OE_BULK_MSG_PUB.add('Y','ERROR');

851:
852: /*IF OE_Bulk_Order_PVT.G_PROCESS_INSTALLED_FLAG = 'Y' -- INVCONV take out
853: AND INV_GMI_RSV_BRANCH.Is_Org_Process_Org(p_key2) THEN
854: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
855: OE_BULK_MSG_PUB.add('Y','ERROR');
856: RAISE NO_DATA_FOUND;
857: END IF; */
858:
859: WHEN OTHERS THEN

Line 867: OE_BULK_MSG_PUB.Add_Exc_Msg

863: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
864: END IF;
865: G_ITEM_TBL.DELETE(p_key1);
866: END IF;
867: OE_BULK_MSG_PUB.Add_Exc_Msg
868: ( G_PKG_NAME
869: , 'Load_Item'
870: );
871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1057: OE_BULK_MSG_PUB.Add_Exc_Msg

1053: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
1054: END IF;
1055: G_SHIP_TO_TBL.DELETE(MOD(p_key,G_BINARY_LIMIT));
1056: END IF;
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;

Line 1171: OE_BULK_MSG_PUB.Add_Exc_Msg

1167: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
1168: END IF;
1169: G_SOLD_TO_TBL.DELETE(MOD(p_key,G_BINARY_LIMIT));
1170: END IF;
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;

Line 1316: OE_BULK_MSG_PUB.Add_Exc_Msg

1312: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
1313: END IF;
1314: G_END_CUSTOMER_TBL.DELETE(MOD(p_key,G_BINARY_LIMIT));
1315: END IF;
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;

Line 1537: OE_BULK_MSG_PUB.Add_Exc_Msg

1533: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
1534: END IF;
1535: G_SOLD_TO_SITE_TBL.DELETE(MOD(p_key,G_BINARY_LIMIT));
1536: END IF;
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;

Line 1687: OE_BULK_MSG_PUB.Add_Exc_Msg

1683: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
1684: END IF;
1685: G_INVOICE_TO_TBL.DELETE(MOD(p_key,G_BINARY_LIMIT));
1686: END IF;
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;

Line 1835: OE_BULK_MSG_PUB.Add_Exc_Msg

1831: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
1832: END IF;
1833: G_SOLD_TO_SITE_TBL.DELETE(MOD(p_key,G_BINARY_LIMIT));
1834: END IF;
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;

Line 1894: OE_BULK_MSG_PUB.Add_Exc_Msg

1890: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
1891: END IF;
1892: G_SALESREP_TBL.DELETE(p_key);
1893: END IF;
1894: OE_BULK_MSG_PUB.Add_Exc_Msg
1895: ( G_PKG_NAME
1896: , 'Load_Salesrep'
1897: );
1898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2017: OE_BULK_MSG_PUB.Add_Exc_Msg

2013: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
2014: END IF;
2015: G_SHIP_FROM_TBL.DELETE(p_key);
2016: END IF;
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;

Line 2078: OE_BULK_MSG_PUB.Add_Exc_Msg

2074: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
2075: END IF;
2076: G_PRICE_LIST_TBL.DELETE(p_key);
2077: END IF;
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;

Line 2190: OE_BULK_MSG_PUB.Add_Exc_Msg

2186: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
2187: END IF;
2188: G_LOC_INFO_TBL.DELETE(MOD(p_key,G_BINARY_LIMIT));
2189: END IF;
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;

Line 2287: OE_BULK_MSG_PUB.Add_Exc_Msg

2283: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
2284: END IF;
2285: G_PERSON_TBL.DELETE(p_key);
2286: END IF;
2287: OE_BULK_MSG_PUB.Add_Exc_Msg
2288: ( G_PKG_NAME
2289: ,'Load_Person'
2290: );
2291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;