264: IF c_site_use_id2%ISOPEN then
265: CLOSE c_site_use_id2;
266: END IF;
267:
268: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
269: THEN
270:
271: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
272: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_site_id');
269: THEN
270:
271: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
272: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_site_id');
273: OE_MSG_PUB.Add;
274:
275: END IF;
276: RETURN FND_API.G_MISS_NUM;
277:
284: IF c_site_use_id2%ISOPEN then
285: CLOSE c_site_use_id2;
286: END IF;
287:
288: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
289: THEN
290: OE_MSG_PUB.Add_Exc_Msg
291: ( G_PKG_NAME
292: , 'end_cstomer_site_id'
286: END IF;
287:
288: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
289: THEN
290: OE_MSG_PUB.Add_Exc_Msg
291: ( G_PKG_NAME
292: , 'end_cstomer_site_id'
293: );
294: END IF;
324: EXCEPTION
325:
326: WHEN NO_DATA_FOUND THEN
327:
328: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
329: THEN
330:
331: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
332: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_contact_id');
329: THEN
330:
331: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
332: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_contact_id');
333: OE_MSG_PUB.Add;
334:
335: END IF;
336:
337: RETURN FND_API.G_MISS_NUM;
337: RETURN FND_API.G_MISS_NUM;
338:
339: WHEN OTHERS THEN
340:
341: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
342: THEN
343: OE_MSG_PUB.Add_Exc_Msg
344: ( G_PKG_NAME
345: , 'End_customer_contact'
339: WHEN OTHERS THEN
340:
341: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
342: THEN
343: OE_MSG_PUB.Add_Exc_Msg
344: ( G_PKG_NAME
345: , 'End_customer_contact'
346: );
347: END IF;