301: RETURN TRUE;
302: EXCEPTION
303: WHEN NO_DATA_FOUND THEN
304:
305: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
306: THEN
307:
308: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_ID');
309:
304:
305: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
306: THEN
307:
308: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_ID');
309:
310: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
311: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
312: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_ID')||':validation:'||to_char(p_end_customer_id));
309:
310: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
311: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
312: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_ID')||':validation:'||to_char(p_end_customer_id));
313: OE_MSG_PUB.Add;
314: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
315:
316: END IF;
317:
310: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
311: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
312: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_ID')||':validation:'||to_char(p_end_customer_id));
313: OE_MSG_PUB.Add;
314: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
315:
316: END IF;
317:
318: RETURN FALSE;
318: RETURN FALSE;
319:
320: WHEN OTHERS THEN
321:
322: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
323: THEN
324: OE_MSG_PUB.Add_Exc_Msg
325: ( G_PKG_NAME
326: , 'END_CUSOTMER'
320: WHEN OTHERS THEN
321:
322: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
323: THEN
324: OE_MSG_PUB.Add_Exc_Msg
325: ( G_PKG_NAME
326: , 'END_CUSOTMER'
327: );
328: END IF;
348: RETURN TRUE;
349: EXCEPTION
350: WHEN NO_DATA_FOUND THEN
351:
352: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
353: THEN
354:
355: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_CONTACT_ID');
356:
351:
352: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
353: THEN
354:
355: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_CONTACT_ID');
356:
357: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
358: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
359: OE_Order_Util.Get_Attribute_Name('end_customer_contact_id'));
356:
357: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
358: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
359: OE_Order_Util.Get_Attribute_Name('end_customer_contact_id'));
360: OE_MSG_PUB.Add;
361: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
362:
363: END IF;
364:
357: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
358: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
359: OE_Order_Util.Get_Attribute_Name('end_customer_contact_id'));
360: OE_MSG_PUB.Add;
361: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
362:
363: END IF;
364:
365:
366: RETURN FALSE;
367:
368: WHEN OTHERS THEN
369:
370: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
371: THEN
372: OE_MSG_PUB.Add_Exc_Msg
373: ( G_PKG_NAME
374: , 'End_Customer_Contact'
368: WHEN OTHERS THEN
369:
370: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
371: THEN
372: OE_MSG_PUB.Add_Exc_Msg
373: ( G_PKG_NAME
374: , 'End_Customer_Contact'
375: );
376: END IF;
416: END IF;
417:
418: EXCEPTION
419: WHEN NO_DATA_FOUND THEN
420: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
421: THEN
422:
423: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_SITE_USE_ID');
424:
419: WHEN NO_DATA_FOUND THEN
420: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
421: THEN
422:
423: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_SITE_USE_ID');
424:
425: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
426: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
427: OE_Order_Util.Get_Attribute_Name('end_customer_site_use_id'));
424:
425: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
426: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
427: OE_Order_Util.Get_Attribute_Name('end_customer_site_use_id'));
428: OE_MSG_PUB.Add;
429: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
430:
431: END IF;
432:
425: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
426: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
427: OE_Order_Util.Get_Attribute_Name('end_customer_site_use_id'));
428: OE_MSG_PUB.Add;
429: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
430:
431: END IF;
432:
433:
434: RETURN FALSE;
435:
436: WHEN OTHERS THEN
437:
438: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
439: THEN
440: OE_MSG_PUB.Add_Exc_Msg
441: ( G_PKG_NAME
442: , 'END_CUSTOMER_SITE_USE_ID'
436: WHEN OTHERS THEN
437:
438: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
439: THEN
440: OE_MSG_PUB.Add_Exc_Msg
441: ( G_PKG_NAME
442: , 'END_CUSTOMER_SITE_USE_ID'
443: );
444: END IF;
465: RETURN TRUE;
466: EXCEPTION
467: WHEN NO_DATA_FOUND THEN
468:
469: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
470: THEN
471:
472: OE_DEBUG_PUB.ADD('Validation failed for IB_INSTALLED_AT_LOCATION in OEBLHDRB.pls');
473: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_INSTALLED_AT_LOCATION');
469: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
470: THEN
471:
472: OE_DEBUG_PUB.ADD('Validation failed for IB_INSTALLED_AT_LOCATION in OEBLHDRB.pls');
473: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_INSTALLED_AT_LOCATION');
474:
475: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
477: OE_Order_Util.Get_Attribute_Name('ib_installed_at_location'));
474:
475: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
477: OE_Order_Util.Get_Attribute_Name('ib_installed_at_location'));
478: OE_MSG_PUB.Add;
479: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
480:
481: END IF;
482:
475: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
477: OE_Order_Util.Get_Attribute_Name('ib_installed_at_location'));
478: OE_MSG_PUB.Add;
479: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
480:
481: END IF;
482:
483:
484: RETURN FALSE;
485:
486: WHEN OTHERS THEN
487:
488: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
489: THEN
490: OE_MSG_PUB.Add_Exc_Msg
491: ( G_PKG_NAME
492: , 'IB_INSTALLED_AT_LOCATION'
486: WHEN OTHERS THEN
487:
488: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
489: THEN
490: OE_MSG_PUB.Add_Exc_Msg
491: ( G_PKG_NAME
492: , 'IB_INSTALLED_AT_LOCATION'
493: );
494: END IF;
517: RETURN TRUE;
518: EXCEPTION
519: WHEN NO_DATA_FOUND THEN
520:
521: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
522: THEN
523:
524: OE_DEBUG_PUB.ADD('Validation failed for IB_INSTALLED_AT_LOCATION in OEBLHDRB.pls');
525: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_INSTALLED_AT_LOCATION');
521: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
522: THEN
523:
524: OE_DEBUG_PUB.ADD('Validation failed for IB_INSTALLED_AT_LOCATION in OEBLHDRB.pls');
525: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_INSTALLED_AT_LOCATION');
526:
527: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
528: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
529: OE_Order_Util.Get_Attribute_Name('ib_installed_at_location'));
526:
527: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
528: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
529: OE_Order_Util.Get_Attribute_Name('ib_installed_at_location'));
530: OE_MSG_PUB.Add;
531: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
532:
533: END IF;
534:
527: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
528: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
529: OE_Order_Util.Get_Attribute_Name('ib_installed_at_location'));
530: OE_MSG_PUB.Add;
531: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
532:
533: END IF;
534:
535:
536: RETURN FALSE;
537:
538: WHEN OTHERS THEN
539:
540: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
541: THEN
542: OE_MSG_PUB.Add_Exc_Msg
543: ( G_PKG_NAME
544: , 'IB_INSTALLED_AT_LOCATION'
538: WHEN OTHERS THEN
539:
540: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
541: THEN
542: OE_MSG_PUB.Add_Exc_Msg
543: ( G_PKG_NAME
544: , 'IB_INSTALLED_AT_LOCATION'
545: );
546: END IF;
574: RETURN TRUE;
575: EXCEPTION
576: WHEN NO_DATA_FOUND THEN
577:
578: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
579: THEN
580:
581: OE_DEBUG_PUB.ADD('Validation failed for IB_CURRENT_LOCATION in OEBLHDRB.pls');
582: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_CURRENT_LOCATION');
578: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
579: THEN
580:
581: OE_DEBUG_PUB.ADD('Validation failed for IB_CURRENT_LOCATION in OEBLHDRB.pls');
582: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_CURRENT_LOCATION');
583:
584: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
585: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
586: OE_Order_Util.Get_Attribute_Name('ib_current_location'));
583:
584: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
585: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
586: OE_Order_Util.Get_Attribute_Name('ib_current_location'));
587: OE_MSG_PUB.Add;
588: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
589:
590: END IF;
591:
584: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
585: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
586: OE_Order_Util.Get_Attribute_Name('ib_current_location'));
587: OE_MSG_PUB.Add;
588: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
589:
590: END IF;
591:
592:
593: RETURN FALSE;
594:
595: WHEN OTHERS THEN
596:
597: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
598: THEN
599: OE_MSG_PUB.Add_Exc_Msg
600: ( G_PKG_NAME
601: , 'IB_CURRENT_LOCATION'
595: WHEN OTHERS THEN
596:
597: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
598: THEN
599: OE_MSG_PUB.Add_Exc_Msg
600: ( G_PKG_NAME
601: , 'IB_CURRENT_LOCATION'
602: );
603: END IF;
1897: p_header_rec.conversion_rate(i) IS NOT NULL
1898: THEN
1899: l_return_status := FND_API.G_RET_STS_ERROR;
1900: FND_MESSAGE.SET_NAME('ONT','OE_VALIDATION_CONV_TYPE');
1901: OE_MSG_PUB.ADD;
1902:
1903: END IF; -- END of checks based on conversion type
1904:
1905: