DBA Data[Home] [Help]

APPS.OE_BULK_CACHE dependencies on OE_BULK_MSG_PUB

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

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

Line 145: OE_BULK_MSG_PUB.Add_Exc_Msg

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

Line 373: OE_BULK_MSG_PUB.Add_Exc_Msg

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

Line 434: OE_BULK_MSG_PUB.Add_Exc_Msg

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

Line 553: OE_BULK_MSG_PUB.Add_Exc_Msg

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

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

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

Line 866: OE_BULK_MSG_PUB.Add_Exc_Msg

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

Line 1056: OE_BULK_MSG_PUB.Add_Exc_Msg

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

Line 1170: OE_BULK_MSG_PUB.Add_Exc_Msg

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

Line 1315: OE_BULK_MSG_PUB.Add_Exc_Msg

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

Line 1536: OE_BULK_MSG_PUB.Add_Exc_Msg

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

Line 1686: OE_BULK_MSG_PUB.Add_Exc_Msg

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

Line 1834: OE_BULK_MSG_PUB.Add_Exc_Msg

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

Line 1893: OE_BULK_MSG_PUB.Add_Exc_Msg

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

Line 2016: OE_BULK_MSG_PUB.Add_Exc_Msg

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

Line 2077: OE_BULK_MSG_PUB.Add_Exc_Msg

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

Line 2189: OE_BULK_MSG_PUB.Add_Exc_Msg

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

Line 2286: OE_BULK_MSG_PUB.Add_Exc_Msg

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