163: -- dictionary stack. Then, add it to the API message list.
164:
165: FND_MESSAGE.Set_Encoded(FND_FLEX_DESCVAL.Encoded_Error_Message);
166:
167: OE_MSG_PUB.Add;
168:
169: -- Derive return status.
170:
171: IF FND_FLEX_DESCVAL.value_error OR
193:
194: WHEN NO_DATA_FOUND THEN
195:
196:
197: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
198: THEN
199:
200: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DESC_FLEX');
201:
196:
197: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
198: THEN
199:
200: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DESC_FLEX');
201:
202: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
203: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
204: OE_Order_Util.Get_Attribute_Name('DESC_FLEX'));
201:
202: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
203: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
204: OE_Order_Util.Get_Attribute_Name('DESC_FLEX'));
205: OE_MSG_PUB.Add;
206: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
207:
208: END IF;
209:
202: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
203: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
204: OE_Order_Util.Get_Attribute_Name('DESC_FLEX'));
205: OE_MSG_PUB.Add;
206: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
207:
208: END IF;
209:
210:
211: RETURN FALSE;
212:
213: WHEN OTHERS THEN
214:
215: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
216: THEN
217: OE_MSG_PUB.Add_Exc_Msg
218: ( G_PKG_NAME
219: , 'Desc_Flex'
213: WHEN OTHERS THEN
214:
215: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
216: THEN
217: OE_MSG_PUB.Add_Exc_Msg
218: ( G_PKG_NAME
219: , 'Desc_Flex'
220: );
221: END IF;
249:
250: WHEN NO_DATA_FOUND THEN
251:
252:
253: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
254: THEN
255:
256: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'HEADER_ID');
257:
252:
253: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
254: THEN
255:
256: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'HEADER_ID');
257:
258: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
259: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
260: OE_Order_Util.Get_Attribute_Name('HEADER_ID'));
257:
258: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
259: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
260: OE_Order_Util.Get_Attribute_Name('HEADER_ID'));
261: OE_MSG_PUB.Add;
262: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
263:
264: END IF;
265:
258: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
259: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
260: OE_Order_Util.Get_Attribute_Name('HEADER_ID'));
261: OE_MSG_PUB.Add;
262: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
263:
264: END IF;
265:
266:
267: RETURN FALSE;
268:
269: WHEN OTHERS THEN
270:
271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
272: THEN
273: OE_MSG_PUB.Add_Exc_Msg
274: ( G_PKG_NAME
275: , 'Header'
269: WHEN OTHERS THEN
270:
271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
272: THEN
273: OE_MSG_PUB.Add_Exc_Msg
274: ( G_PKG_NAME
275: , 'Header'
276: );
277: END IF;
306: EXCEPTION
307:
308: WHEN NO_DATA_FOUND THEN
309:
310: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
311: THEN
312:
313: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_UPDATED_BY');
314:
309:
310: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
311: THEN
312:
313: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_UPDATED_BY');
314:
315: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
316: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
317: OE_Order_Util.Get_Attribute_Name('last_updated_by'));
314:
315: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
316: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
317: OE_Order_Util.Get_Attribute_Name('last_updated_by'));
318: OE_MSG_PUB.Add;
319: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
320:
321: END IF;
322:
315: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
316: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
317: OE_Order_Util.Get_Attribute_Name('last_updated_by'));
318: OE_MSG_PUB.Add;
319: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
320:
321: END IF;
322:
323:
324: RETURN FALSE;
325:
326: WHEN OTHERS THEN
327:
328: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
329: THEN
330: OE_MSG_PUB.Add_Exc_Msg
331: ( G_PKG_NAME
332: , 'Last_Updated_By'
326: WHEN OTHERS THEN
327:
328: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
329: THEN
330: OE_MSG_PUB.Add_Exc_Msg
331: ( G_PKG_NAME
332: , 'Last_Updated_By'
333: );
334: END IF;
363: EXCEPTION
364:
365: WHEN NO_DATA_FOUND THEN
366:
367: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
368: THEN
369:
370: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_UPDATE_DATE');
371:
366:
367: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
368: THEN
369:
370: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_UPDATE_DATE');
371:
372: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
373: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
374: OE_Order_Util.Get_Attribute_Name('last_update_date'));
371:
372: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
373: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
374: OE_Order_Util.Get_Attribute_Name('last_update_date'));
375: OE_MSG_PUB.Add;
376: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
377:
378: END IF;
379:
372: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
373: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
374: OE_Order_Util.Get_Attribute_Name('last_update_date'));
375: OE_MSG_PUB.Add;
376: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
377:
378: END IF;
379:
380:
381: RETURN FALSE;
382:
383: WHEN OTHERS THEN
384:
385: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
386: THEN
387: OE_MSG_PUB.Add_Exc_Msg
388: ( G_PKG_NAME
389: , 'Last_Update_Date'
383: WHEN OTHERS THEN
384:
385: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
386: THEN
387: OE_MSG_PUB.Add_Exc_Msg
388: ( G_PKG_NAME
389: , 'Last_Update_Date'
390: );
391: END IF;
420: EXCEPTION
421:
422: WHEN NO_DATA_FOUND THEN
423:
424: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
425: THEN
426:
427: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_UPDATE_LOGIN');
428:
423:
424: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
425: THEN
426:
427: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_UPDATE_LOGIN');
428:
429: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
430: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
431: OE_Order_Util.Get_Attribute_Name('last_update_login'));
428:
429: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
430: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
431: OE_Order_Util.Get_Attribute_Name('last_update_login'));
432: OE_MSG_PUB.Add;
433: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
434:
435: END IF;
436:
429: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
430: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
431: OE_Order_Util.Get_Attribute_Name('last_update_login'));
432: OE_MSG_PUB.Add;
433: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
434:
435: END IF;
436:
437:
438: RETURN FALSE;
439:
440: WHEN OTHERS THEN
441:
442: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
443: THEN
444: OE_MSG_PUB.Add_Exc_Msg
445: ( G_PKG_NAME
446: , 'Last_Update_Login'
440: WHEN OTHERS THEN
441:
442: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
443: THEN
444: OE_MSG_PUB.Add_Exc_Msg
445: ( G_PKG_NAME
446: , 'Last_Update_Login'
447: );
448: END IF;
477: EXCEPTION
478:
479: WHEN NO_DATA_FOUND THEN
480:
481: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
482: THEN
483:
484: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROGRAM_APPLICATION_ID');
485:
480:
481: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
482: THEN
483:
484: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROGRAM_APPLICATION_ID');
485:
486: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
487: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
488: OE_Order_Util.Get_Attribute_Name('program_application_id'));
485:
486: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
487: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
488: OE_Order_Util.Get_Attribute_Name('program_application_id'));
489: OE_MSG_PUB.Add;
490: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
491:
492: END IF;
493:
486: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
487: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
488: OE_Order_Util.Get_Attribute_Name('program_application_id'));
489: OE_MSG_PUB.Add;
490: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
491:
492: END IF;
493:
494:
495: RETURN FALSE;
496:
497: WHEN OTHERS THEN
498:
499: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
500: THEN
501: OE_MSG_PUB.Add_Exc_Msg
502: ( G_PKG_NAME
503: , 'Program_Application'
497: WHEN OTHERS THEN
498:
499: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
500: THEN
501: OE_MSG_PUB.Add_Exc_Msg
502: ( G_PKG_NAME
503: , 'Program_Application'
504: );
505: END IF;
534: EXCEPTION
535:
536: WHEN NO_DATA_FOUND THEN
537:
538: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
539: THEN
540:
541: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROGRAM_ID');
542:
537:
538: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
539: THEN
540:
541: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROGRAM_ID');
542:
543: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
544: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
545: OE_Order_Util.Get_Attribute_Name('program_id'));
542:
543: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
544: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
545: OE_Order_Util.Get_Attribute_Name('program_id'));
546: OE_MSG_PUB.Add;
547: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
548:
549: END IF;
550:
543: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
544: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
545: OE_Order_Util.Get_Attribute_Name('program_id'));
546: OE_MSG_PUB.Add;
547: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
548:
549: END IF;
550:
551:
552: RETURN FALSE;
553:
554: WHEN OTHERS THEN
555:
556: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
557: THEN
558: OE_MSG_PUB.Add_Exc_Msg
559: ( G_PKG_NAME
560: , 'Program'
554: WHEN OTHERS THEN
555:
556: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
557: THEN
558: OE_MSG_PUB.Add_Exc_Msg
559: ( G_PKG_NAME
560: , 'Program'
561: );
562: END IF;
591: EXCEPTION
592:
593: WHEN NO_DATA_FOUND THEN
594:
595: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
596: THEN
597:
598: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROGRAM_UPDATE_DATE');
599:
594:
595: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
596: THEN
597:
598: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROGRAM_UPDATE_DATE');
599:
600: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
601: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
602: OE_Order_Util.Get_Attribute_Name('program_update_date'));
599:
600: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
601: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
602: OE_Order_Util.Get_Attribute_Name('program_update_date'));
603: OE_MSG_PUB.Add;
604: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
605:
606: END IF;
607:
600: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
601: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
602: OE_Order_Util.Get_Attribute_Name('program_update_date'));
603: OE_MSG_PUB.Add;
604: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
605:
606: END IF;
607:
608:
609: RETURN FALSE;
610:
611: WHEN OTHERS THEN
612:
613: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
614: THEN
615: OE_MSG_PUB.Add_Exc_Msg
616: ( G_PKG_NAME
617: , 'Program_Update_Date'
611: WHEN OTHERS THEN
612:
613: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
614: THEN
615: OE_MSG_PUB.Add_Exc_Msg
616: ( G_PKG_NAME
617: , 'Program_Update_Date'
618: );
619: END IF;
648: EXCEPTION
649:
650: WHEN NO_DATA_FOUND THEN
651:
652: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
653: THEN
654:
655: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'REQUEST_ID');
656:
651:
652: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
653: THEN
654:
655: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'REQUEST_ID');
656:
657: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
658: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
659: OE_Order_Util.Get_Attribute_Name('request_id'));
656:
657: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
658: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
659: OE_Order_Util.Get_Attribute_Name('request_id'));
660: OE_MSG_PUB.Add;
661: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
662:
663: END IF;
664:
657: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
658: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
659: OE_Order_Util.Get_Attribute_Name('request_id'));
660: OE_MSG_PUB.Add;
661: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
662:
663: END IF;
664:
665:
666: RETURN FALSE;
667:
668: WHEN OTHERS THEN
669:
670: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
671: THEN
672: OE_MSG_PUB.Add_Exc_Msg
673: ( G_PKG_NAME
674: , 'Request'
668: WHEN OTHERS THEN
669:
670: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
671: THEN
672: OE_MSG_PUB.Add_Exc_Msg
673: ( G_PKG_NAME
674: , 'Request'
675: );
676: END IF;
705: EXCEPTION
706:
707: WHEN NO_DATA_FOUND THEN
708:
709: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
710: THEN
711:
712: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICE_ADJUSTMENT_ID');
713:
708:
709: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
710: THEN
711:
712: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICE_ADJUSTMENT_ID');
713:
714: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
715: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
716: OE_Order_Util.Get_Attribute_Name('price_adjustment_id'));
713:
714: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
715: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
716: OE_Order_Util.Get_Attribute_Name('price_adjustment_id'));
717: OE_MSG_PUB.Add;
718: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
719:
720: END IF;
721:
714: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
715: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
716: OE_Order_Util.Get_Attribute_Name('price_adjustment_id'));
717: OE_MSG_PUB.Add;
718: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
719:
720: END IF;
721:
722:
723: RETURN FALSE;
724:
725: WHEN OTHERS THEN
726:
727: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
728: THEN
729: OE_MSG_PUB.Add_Exc_Msg
730: ( G_PKG_NAME
731: , 'Price_Adjustment'
725: WHEN OTHERS THEN
726:
727: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
728: THEN
729: OE_MSG_PUB.Add_Exc_Msg
730: ( G_PKG_NAME
731: , 'Price_Adjustment'
732: );
733: END IF;
762: EXCEPTION
763:
764: WHEN NO_DATA_FOUND THEN
765:
766: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
767: THEN
768:
769: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DISCOUNT_ID');
770:
765:
766: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
767: THEN
768:
769: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DISCOUNT_ID');
770:
771: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
772: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
773: OE_Order_Util.Get_Attribute_Name('discount_id'));
770:
771: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
772: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
773: OE_Order_Util.Get_Attribute_Name('discount_id'));
774: OE_MSG_PUB.Add;
775: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
776:
777: END IF;
778:
771: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
772: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
773: OE_Order_Util.Get_Attribute_Name('discount_id'));
774: OE_MSG_PUB.Add;
775: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
776:
777: END IF;
778:
779:
780: RETURN FALSE;
781:
782: WHEN OTHERS THEN
783:
784: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
785: THEN
786: OE_MSG_PUB.Add_Exc_Msg
787: ( G_PKG_NAME
788: , 'Discount'
782: WHEN OTHERS THEN
783:
784: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
785: THEN
786: OE_MSG_PUB.Add_Exc_Msg
787: ( G_PKG_NAME
788: , 'Discount'
789: );
790: END IF;
820: EXCEPTION
821:
822: WHEN NO_DATA_FOUND THEN
823:
824: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
825: THEN
826:
827: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DISCOUNT_LINE_ID');
828:
823:
824: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
825: THEN
826:
827: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DISCOUNT_LINE_ID');
828:
829: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
830: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
831: OE_Order_Util.Get_Attribute_Name('discount_line_id'));
828:
829: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
830: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
831: OE_Order_Util.Get_Attribute_Name('discount_line_id'));
832: OE_MSG_PUB.Add;
833: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
834:
835: END IF;
836:
829: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
830: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
831: OE_Order_Util.Get_Attribute_Name('discount_line_id'));
832: OE_MSG_PUB.Add;
833: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
834:
835: END IF;
836:
837:
838: RETURN FALSE;
839:
840: WHEN OTHERS THEN
841:
842: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
843: THEN
844: OE_MSG_PUB.Add_Exc_Msg
845: ( G_PKG_NAME
846: , 'Discount_Line'
840: WHEN OTHERS THEN
841:
842: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
843: THEN
844: OE_MSG_PUB.Add_Exc_Msg
845: ( G_PKG_NAME
846: , 'Discount_Line'
847: );
848: END IF;
877: EXCEPTION
878:
879: WHEN NO_DATA_FOUND THEN
880:
881: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
882: THEN
883:
884: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'AUTOMATIC_FLAG');
885:
880:
881: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
882: THEN
883:
884: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'AUTOMATIC_FLAG');
885:
886: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
887: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
888: OE_Order_Util.Get_Attribute_Name('automatic_flag'));
885:
886: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
887: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
888: OE_Order_Util.Get_Attribute_Name('automatic_flag'));
889: OE_MSG_PUB.Add;
890: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
891:
892: END IF;
893:
886: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
887: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
888: OE_Order_Util.Get_Attribute_Name('automatic_flag'));
889: OE_MSG_PUB.Add;
890: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
891:
892: END IF;
893:
894:
895: RETURN FALSE;
896:
897: WHEN OTHERS THEN
898:
899: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
900: THEN
901: OE_MSG_PUB.Add_Exc_Msg
902: ( G_PKG_NAME
903: , 'Automatic'
897: WHEN OTHERS THEN
898:
899: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
900: THEN
901: OE_MSG_PUB.Add_Exc_Msg
902: ( G_PKG_NAME
903: , 'Automatic'
904: );
905: END IF;
946: EXCEPTION
947:
948: WHEN NO_DATA_FOUND THEN
949:
950: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
951: THEN
952:
953: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PERCENT');
954:
949:
950: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
951: THEN
952:
953: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PERCENT');
954:
955: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
956: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
957: OE_Order_Util.Get_Attribute_Name('percent'));
954:
955: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
956: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
957: OE_Order_Util.Get_Attribute_Name('percent'));
958: OE_MSG_PUB.Add;
959: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
960:
961: END IF;
962:
955: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
956: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
957: OE_Order_Util.Get_Attribute_Name('percent'));
958: OE_MSG_PUB.Add;
959: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
960:
961: END IF;
962:
963:
964: RETURN FALSE;
965:
966: WHEN OTHERS THEN
967:
968: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
969: THEN
970: OE_MSG_PUB.Add_Exc_Msg
971: ( G_PKG_NAME
972: , 'Percent'
966: WHEN OTHERS THEN
967:
968: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
969: THEN
970: OE_MSG_PUB.Add_Exc_Msg
971: ( G_PKG_NAME
972: , 'Percent'
973: );
974: END IF;
1003: EXCEPTION
1004:
1005: WHEN NO_DATA_FOUND THEN
1006:
1007: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1008: THEN
1009:
1010: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LINE_ID');
1011:
1006:
1007: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1008: THEN
1009:
1010: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LINE_ID');
1011:
1012: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1013: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1014: OE_Order_Util.Get_Attribute_Name('line_id'));
1011:
1012: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1013: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1014: OE_Order_Util.Get_Attribute_Name('line_id'));
1015: OE_MSG_PUB.Add;
1016: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1017:
1018: END IF;
1019:
1012: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1013: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1014: OE_Order_Util.Get_Attribute_Name('line_id'));
1015: OE_MSG_PUB.Add;
1016: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1017:
1018: END IF;
1019:
1020:
1021: RETURN FALSE;
1022:
1023: WHEN OTHERS THEN
1024:
1025: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1026: THEN
1027: OE_MSG_PUB.Add_Exc_Msg
1028: ( G_PKG_NAME
1029: , 'Line'
1023: WHEN OTHERS THEN
1024:
1025: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1026: THEN
1027: OE_MSG_PUB.Add_Exc_Msg
1028: ( G_PKG_NAME
1029: , 'Line'
1030: );
1031: END IF;
1051: END IF;
1052:
1053: if p_applied_flag not in ('Y','N') then
1054:
1055: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1056: THEN
1057:
1058: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'APPLIED_FLAG');
1059:
1054:
1055: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1056: THEN
1057:
1058: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'APPLIED_FLAG');
1059:
1060: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1061: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1062: OE_Order_Util.Get_Attribute_Name('Applied_Flag'));
1059:
1060: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1061: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1062: OE_Order_Util.Get_Attribute_Name('Applied_Flag'));
1063: OE_MSG_PUB.Add;
1064: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1065:
1066: END IF;
1067: RETURN FALSE;
1060: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1061: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1062: OE_Order_Util.Get_Attribute_Name('Applied_Flag'));
1063: OE_MSG_PUB.Add;
1064: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1065:
1066: END IF;
1067: RETURN FALSE;
1068: End if;
1072: EXCEPTION
1073:
1074: WHEN NO_DATA_FOUND THEN
1075:
1076: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1077: THEN
1078:
1079: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'APPLIED_FLAG');
1080:
1075:
1076: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1077: THEN
1078:
1079: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'APPLIED_FLAG');
1080:
1081: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1082: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1083: OE_Order_Util.Get_Attribute_Name('Applied_Flag'));
1080:
1081: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1082: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1083: OE_Order_Util.Get_Attribute_Name('Applied_Flag'));
1084: OE_MSG_PUB.Add;
1085: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1086:
1087: END IF;
1088:
1081: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1082: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1083: OE_Order_Util.Get_Attribute_Name('Applied_Flag'));
1084: OE_MSG_PUB.Add;
1085: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1086:
1087: END IF;
1088:
1089:
1090: RETURN FALSE;
1091:
1092: WHEN OTHERS THEN
1093:
1094: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1095: THEN
1096: OE_MSG_PUB.Add_Exc_Msg
1097: ( G_PKG_NAME
1098: , 'Applied_Flag'
1092: WHEN OTHERS THEN
1093:
1094: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1095: THEN
1096: OE_MSG_PUB.Add_Exc_Msg
1097: ( G_PKG_NAME
1098: , 'Applied_Flag'
1099: );
1100: END IF;
1138: EXCEPTION
1139:
1140: WHEN NO_DATA_FOUND THEN
1141:
1142: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1143: THEN
1144:
1145: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHANGE_REASON_CODE');
1146:
1141:
1142: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1143: THEN
1144:
1145: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHANGE_REASON_CODE');
1146:
1147: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1148: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1149: OE_Order_Util.Get_Attribute_Name('Change_Reason_Code'));
1146:
1147: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1148: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1149: OE_Order_Util.Get_Attribute_Name('Change_Reason_Code'));
1150: OE_MSG_PUB.Add;
1151: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1152:
1153: END IF;
1154:
1147: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1148: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1149: OE_Order_Util.Get_Attribute_Name('Change_Reason_Code'));
1150: OE_MSG_PUB.Add;
1151: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1152:
1153: END IF;
1154:
1155:
1156: RETURN FALSE;
1157:
1158: WHEN OTHERS THEN
1159:
1160: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1161: THEN
1162: OE_MSG_PUB.Add_Exc_Msg
1163: ( G_PKG_NAME
1164: , 'Change_Reason_Code'
1158: WHEN OTHERS THEN
1159:
1160: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1161: THEN
1162: OE_MSG_PUB.Add_Exc_Msg
1163: ( G_PKG_NAME
1164: , 'Change_Reason_Code'
1165: );
1166: END IF;
1191: EXCEPTION
1192:
1193: WHEN NO_DATA_FOUND THEN
1194:
1195: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1196: THEN
1197:
1198: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHANGE_REASON_TEXT');
1199:
1194:
1195: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1196: THEN
1197:
1198: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHANGE_REASON_TEXT');
1199:
1200: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1201: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1202: OE_Order_Util.Get_Attribute_Name('Change_Reason_Text'));
1199:
1200: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1201: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1202: OE_Order_Util.Get_Attribute_Name('Change_Reason_Text'));
1203: OE_MSG_PUB.Add;
1204: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1205:
1206: END IF;
1207:
1200: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1201: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1202: OE_Order_Util.Get_Attribute_Name('Change_Reason_Text'));
1203: OE_MSG_PUB.Add;
1204: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1205:
1206: END IF;
1207:
1208:
1209: RETURN FALSE;
1210:
1211: WHEN OTHERS THEN
1212:
1213: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1214: THEN
1215: OE_MSG_PUB.Add_Exc_Msg
1216: ( G_PKG_NAME
1217: , 'Change_Reason_Text'
1211: WHEN OTHERS THEN
1212:
1213: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1214: THEN
1215: OE_MSG_PUB.Add_Exc_Msg
1216: ( G_PKG_NAME
1217: , 'Change_Reason_Text'
1218: );
1219: END IF;
1249: EXCEPTION
1250:
1251: WHEN NO_DATA_FOUND THEN
1252:
1253: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1254: THEN
1255:
1256: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LIST_HEADER_ID');
1257:
1252:
1253: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1254: THEN
1255:
1256: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LIST_HEADER_ID');
1257:
1258: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1259: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1260: OE_Order_Util.Get_Attribute_Name('List_Header_id'));
1257:
1258: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1259: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1260: OE_Order_Util.Get_Attribute_Name('List_Header_id'));
1261: OE_MSG_PUB.Add;
1262: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1263:
1264: END IF;
1265:
1258: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1259: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1260: OE_Order_Util.Get_Attribute_Name('List_Header_id'));
1261: OE_MSG_PUB.Add;
1262: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1263:
1264: END IF;
1265:
1266:
1267: RETURN FALSE;
1268:
1269: WHEN OTHERS THEN
1270:
1271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1272: THEN
1273: OE_MSG_PUB.Add_Exc_Msg
1274: ( G_PKG_NAME
1275: , 'List_Header_id'
1269: WHEN OTHERS THEN
1270:
1271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1272: THEN
1273: OE_MSG_PUB.Add_Exc_Msg
1274: ( G_PKG_NAME
1275: , 'List_Header_id'
1276: );
1277: END IF;
1307: EXCEPTION
1308:
1309: WHEN NO_DATA_FOUND THEN
1310:
1311: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1312: THEN
1313:
1314: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LIST_LINE_ID');
1315:
1310:
1311: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1312: THEN
1313:
1314: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LIST_LINE_ID');
1315:
1316: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1317: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1318: OE_Order_Util.Get_Attribute_Name('List_Line_id'));
1315:
1316: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1317: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1318: OE_Order_Util.Get_Attribute_Name('List_Line_id'));
1319: OE_MSG_PUB.Add;
1320: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1321:
1322: END IF;
1323:
1316: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1317: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1318: OE_Order_Util.Get_Attribute_Name('List_Line_id'));
1319: OE_MSG_PUB.Add;
1320: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1321:
1322: END IF;
1323:
1324:
1325: RETURN FALSE;
1326:
1327: WHEN OTHERS THEN
1328:
1329: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1330: THEN
1331: OE_MSG_PUB.Add_Exc_Msg
1332: ( G_PKG_NAME
1333: , 'List_Line_id'
1327: WHEN OTHERS THEN
1328:
1329: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1330: THEN
1331: OE_MSG_PUB.Add_Exc_Msg
1332: ( G_PKG_NAME
1333: , 'List_Line_id'
1334: );
1335: END IF;
1364: EXCEPTION
1365:
1366: WHEN NO_DATA_FOUND THEN
1367:
1368: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1369: THEN
1370:
1371: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LIST_LINE_TYPE_CODE');
1372:
1367:
1368: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1369: THEN
1370:
1371: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LIST_LINE_TYPE_CODE');
1372:
1373: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1374: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1375: OE_Order_Util.Get_Attribute_Name('List_Line_Type_code'));
1372:
1373: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1374: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1375: OE_Order_Util.Get_Attribute_Name('List_Line_Type_code'));
1376: OE_MSG_PUB.Add;
1377: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1378:
1379: END IF;
1380:
1373: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1374: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1375: OE_Order_Util.Get_Attribute_Name('List_Line_Type_code'));
1376: OE_MSG_PUB.Add;
1377: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1378:
1379: END IF;
1380:
1381:
1382: RETURN FALSE;
1383:
1384: WHEN OTHERS THEN
1385:
1386: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1387: THEN
1388: OE_MSG_PUB.Add_Exc_Msg
1389: ( G_PKG_NAME
1390: , 'List_Line_Type_code'
1384: WHEN OTHERS THEN
1385:
1386: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1387: THEN
1388: OE_MSG_PUB.Add_Exc_Msg
1389: ( G_PKG_NAME
1390: , 'List_Line_Type_code'
1391: );
1392: END IF;
1423: EXCEPTION
1424:
1425: WHEN NO_DATA_FOUND THEN
1426:
1427: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1428: THEN
1429:
1430: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Pricing_Phase_id');
1431:
1426:
1427: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1428: THEN
1429:
1430: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Pricing_Phase_id');
1431:
1432: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1433: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1434: OE_Order_Util.Get_Attribute_Name('Pricing_Phase_id'));
1431:
1432: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1433: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1434: OE_Order_Util.Get_Attribute_Name('Pricing_Phase_id'));
1435: OE_MSG_PUB.Add;
1436: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1437:
1438: END IF;
1439:
1432: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1433: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1434: OE_Order_Util.Get_Attribute_Name('Pricing_Phase_id'));
1435: OE_MSG_PUB.Add;
1436: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1437:
1438: END IF;
1439:
1440:
1441: RETURN FALSE;
1442:
1443: WHEN OTHERS THEN
1444:
1445: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1446: THEN
1447: OE_MSG_PUB.Add_Exc_Msg
1448: ( G_PKG_NAME
1449: , 'Pricing_Phase_id'
1443: WHEN OTHERS THEN
1444:
1445: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1446: THEN
1447: OE_MSG_PUB.Add_Exc_Msg
1448: ( G_PKG_NAME
1449: , 'Pricing_Phase_id'
1450: );
1451: END IF;
1481: EXCEPTION
1482:
1483: WHEN NO_DATA_FOUND THEN
1484:
1485: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1486: THEN
1487:
1488: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ADJUSTED_AMOUNT');
1489:
1484:
1485: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1486: THEN
1487:
1488: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ADJUSTED_AMOUNT');
1489:
1490: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1491: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1492: OE_Order_Util.Get_Attribute_Name('ADJUSTED_AMOUNT'));
1489:
1490: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1491: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1492: OE_Order_Util.Get_Attribute_Name('ADJUSTED_AMOUNT'));
1493: OE_MSG_PUB.Add;
1494: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1495:
1496: END IF;
1497:
1490: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1491: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1492: OE_Order_Util.Get_Attribute_Name('ADJUSTED_AMOUNT'));
1493: OE_MSG_PUB.Add;
1494: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1495:
1496: END IF;
1497:
1498:
1499: RETURN FALSE;
1500:
1501: WHEN OTHERS THEN
1502:
1503: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1504: THEN
1505: OE_MSG_PUB.Add_Exc_Msg
1506: ( G_PKG_NAME
1507: , 'Adjusted_Amount'
1501: WHEN OTHERS THEN
1502:
1503: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1504: THEN
1505: OE_MSG_PUB.Add_Exc_Msg
1506: ( G_PKG_NAME
1507: , 'Adjusted_Amount'
1508: );
1509: END IF;
1540: EXCEPTION
1541:
1542: WHEN NO_DATA_FOUND THEN
1543:
1544: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1545: THEN
1546:
1547: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MODIFIED_FROM');
1548:
1543:
1544: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1545: THEN
1546:
1547: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MODIFIED_FROM');
1548:
1549: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1550: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1551: OE_Order_Util.Get_Attribute_Name('Modified_From'));
1548:
1549: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1550: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1551: OE_Order_Util.Get_Attribute_Name('Modified_From'));
1552: OE_MSG_PUB.Add;
1553: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1554:
1555: END IF;
1556:
1549: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1550: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1551: OE_Order_Util.Get_Attribute_Name('Modified_From'));
1552: OE_MSG_PUB.Add;
1553: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1554:
1555: END IF;
1556:
1557:
1558: RETURN FALSE;
1559:
1560: WHEN OTHERS THEN
1561:
1562: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1563: THEN
1564: OE_MSG_PUB.Add_Exc_Msg
1565: ( G_PKG_NAME
1566: , 'Modified_From'
1560: WHEN OTHERS THEN
1561:
1562: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1563: THEN
1564: OE_MSG_PUB.Add_Exc_Msg
1565: ( G_PKG_NAME
1566: , 'Modified_From'
1567: );
1568: END IF;
1597: EXCEPTION
1598:
1599: WHEN NO_DATA_FOUND THEN
1600:
1601: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1602: THEN
1603:
1604: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MODIFIED_TO');
1605:
1600:
1601: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1602: THEN
1603:
1604: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MODIFIED_TO');
1605:
1606: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1607: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1608: OE_Order_Util.Get_Attribute_Name('Modified_To'));
1605:
1606: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1607: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1608: OE_Order_Util.Get_Attribute_Name('Modified_To'));
1609: OE_MSG_PUB.Add;
1610: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1611:
1612: END IF;
1613:
1606: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1607: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1608: OE_Order_Util.Get_Attribute_Name('Modified_To'));
1609: OE_MSG_PUB.Add;
1610: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1611:
1612: END IF;
1613:
1614:
1615: RETURN FALSE;
1616:
1617: WHEN OTHERS THEN
1618:
1619: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1620: THEN
1621: OE_MSG_PUB.Add_Exc_Msg
1622: ( G_PKG_NAME
1623: , 'Modified_To'
1617: WHEN OTHERS THEN
1618:
1619: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1620: THEN
1621: OE_MSG_PUB.Add_Exc_Msg
1622: ( G_PKG_NAME
1623: , 'Modified_To'
1624: );
1625: END IF;
1655: EXCEPTION
1656:
1657: WHEN NO_DATA_FOUND THEN
1658:
1659: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1660: THEN
1661:
1662: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MODIFIER_MECHANISM_TYPE_CODE');
1663:
1658:
1659: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1660: THEN
1661:
1662: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MODIFIER_MECHANISM_TYPE_CODE');
1663:
1664: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1666: OE_Order_Util.Get_Attribute_Name('Modifier_mechanism_type_code'));
1663:
1664: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1666: OE_Order_Util.Get_Attribute_Name('Modifier_mechanism_type_code'));
1667: OE_MSG_PUB.Add;
1668: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1669:
1670: END IF;
1671:
1664: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1666: OE_Order_Util.Get_Attribute_Name('Modifier_mechanism_type_code'));
1667: OE_MSG_PUB.Add;
1668: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1669:
1670: END IF;
1671:
1672:
1673: RETURN FALSE;
1674:
1675: WHEN OTHERS THEN
1676:
1677: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1678: THEN
1679: OE_MSG_PUB.Add_Exc_Msg
1680: ( G_PKG_NAME
1681: , 'Modifier_mechanism_type_code'
1675: WHEN OTHERS THEN
1676:
1677: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1678: THEN
1679: OE_MSG_PUB.Add_Exc_Msg
1680: ( G_PKG_NAME
1681: , 'Modifier_mechanism_type_code'
1682: );
1683: END IF;
1714: EXCEPTION
1715:
1716: WHEN NO_DATA_FOUND THEN
1717:
1718: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1719: THEN
1720:
1721: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OPERAND');
1722:
1717:
1718: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1719: THEN
1720:
1721: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OPERAND');
1722:
1723: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1724: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1725: OE_Order_Util.Get_Attribute_Name('Operand'));
1722:
1723: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1724: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1725: OE_Order_Util.Get_Attribute_Name('Operand'));
1726: OE_MSG_PUB.Add;
1727: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1728:
1729: END IF;
1730:
1723: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1724: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1725: OE_Order_Util.Get_Attribute_Name('Operand'));
1726: OE_MSG_PUB.Add;
1727: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1728:
1729: END IF;
1730:
1731:
1732: RETURN FALSE;
1733:
1734: WHEN OTHERS THEN
1735:
1736: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1737: THEN
1738: OE_MSG_PUB.Add_Exc_Msg
1739: ( G_PKG_NAME
1740: , 'Operand'
1734: WHEN OTHERS THEN
1735:
1736: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1737: THEN
1738: OE_MSG_PUB.Add_Exc_Msg
1739: ( G_PKG_NAME
1740: , 'Operand'
1741: );
1742: END IF;
1772: EXCEPTION
1773:
1774: WHEN NO_DATA_FOUND THEN
1775:
1776: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1777: THEN
1778:
1779: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ARITHMETIC_OPERATOR');
1780:
1775:
1776: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1777: THEN
1778:
1779: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ARITHMETIC_OPERATOR');
1780:
1781: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1782: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1783: OE_Order_Util.Get_Attribute_Name('Arithmetic_Operator'));
1780:
1781: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1782: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1783: OE_Order_Util.Get_Attribute_Name('Arithmetic_Operator'));
1784: OE_MSG_PUB.Add;
1785: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1786:
1787: END IF;
1788:
1781: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1782: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1783: OE_Order_Util.Get_Attribute_Name('Arithmetic_Operator'));
1784: OE_MSG_PUB.Add;
1785: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1786:
1787: END IF;
1788:
1789:
1790: RETURN FALSE;
1791:
1792: WHEN OTHERS THEN
1793:
1794: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1795: THEN
1796: OE_MSG_PUB.Add_Exc_Msg
1797: ( G_PKG_NAME
1798: , 'Arithmetic_operator'
1792: WHEN OTHERS THEN
1793:
1794: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1795: THEN
1796: OE_MSG_PUB.Add_Exc_Msg
1797: ( G_PKG_NAME
1798: , 'Arithmetic_operator'
1799: );
1800: END IF;
1828:
1829: WHEN NO_DATA_FOUND THEN
1830:
1831:
1832: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1833: THEN
1834:
1835: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'List_Line_NO');
1836:
1831:
1832: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1833: THEN
1834:
1835: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'List_Line_NO');
1836:
1837: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1838: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1839: OE_Order_Util.Get_Attribute_Name('List_Line_NO'));
1836:
1837: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1838: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1839: OE_Order_Util.Get_Attribute_Name('List_Line_NO'));
1840: OE_MSG_PUB.Add;
1841: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1842:
1843: END IF;
1844:
1837: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1838: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1839: OE_Order_Util.Get_Attribute_Name('List_Line_NO'));
1840: OE_MSG_PUB.Add;
1841: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1842:
1843: END IF;
1844:
1845:
1846: RETURN FALSE;
1847:
1848: WHEN OTHERS THEN
1849:
1850: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1851: THEN
1852: OE_MSG_PUB.Add_Exc_Msg
1853: ( G_PKG_NAME
1854: , 'List Line NO'
1848: WHEN OTHERS THEN
1849:
1850: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1851: THEN
1852: OE_MSG_PUB.Add_Exc_Msg
1853: ( G_PKG_NAME
1854: , 'List Line NO'
1855: );
1856: END IF;
1883:
1884: WHEN NO_DATA_FOUND THEN
1885:
1886:
1887: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1888: THEN
1889:
1890: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Source_System_Code');
1891:
1886:
1887: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1888: THEN
1889:
1890: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Source_System_Code');
1891:
1892: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1893: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1894: OE_Order_Util.Get_Attribute_Name('Source_System_Code'));
1891:
1892: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1893: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1894: OE_Order_Util.Get_Attribute_Name('Source_System_Code'));
1895: OE_MSG_PUB.Add;
1896: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1897:
1898: END IF;
1899:
1892: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1893: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1894: OE_Order_Util.Get_Attribute_Name('Source_System_Code'));
1895: OE_MSG_PUB.Add;
1896: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1897:
1898: END IF;
1899:
1900:
1901: RETURN FALSE;
1902:
1903: WHEN OTHERS THEN
1904:
1905: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1906: THEN
1907: OE_MSG_PUB.Add_Exc_Msg
1908: ( G_PKG_NAME
1909: , 'Source System Code'
1903: WHEN OTHERS THEN
1904:
1905: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1906: THEN
1907: OE_MSG_PUB.Add_Exc_Msg
1908: ( G_PKG_NAME
1909: , 'Source System Code'
1910: );
1911: END IF;
1938:
1939: WHEN NO_DATA_FOUND THEN
1940:
1941:
1942: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1943: THEN
1944:
1945: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Benefit_Qty');
1946:
1941:
1942: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1943: THEN
1944:
1945: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Benefit_Qty');
1946:
1947: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1948: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1949: OE_Order_Util.Get_Attribute_Name('Benefit_Qty'));
1946:
1947: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1948: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1949: OE_Order_Util.Get_Attribute_Name('Benefit_Qty'));
1950: OE_MSG_PUB.Add;
1951: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1952:
1953: END IF;
1954:
1947: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1948: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1949: OE_Order_Util.Get_Attribute_Name('Benefit_Qty'));
1950: OE_MSG_PUB.Add;
1951: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1952:
1953: END IF;
1954:
1955:
1956: RETURN FALSE;
1957:
1958: WHEN OTHERS THEN
1959:
1960: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1961: THEN
1962: OE_MSG_PUB.Add_Exc_Msg
1963: ( G_PKG_NAME
1964: , 'Benefit Qty'
1958: WHEN OTHERS THEN
1959:
1960: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1961: THEN
1962: OE_MSG_PUB.Add_Exc_Msg
1963: ( G_PKG_NAME
1964: , 'Benefit Qty'
1965: );
1966: END IF;
1993:
1994: WHEN NO_DATA_FOUND THEN
1995:
1996:
1997: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1998: THEN
1999:
2000: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Benefit_UOM_Code');
2001:
1996:
1997: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1998: THEN
1999:
2000: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Benefit_UOM_Code');
2001:
2002: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2003: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2004: OE_Order_Util.Get_Attribute_Name('Benefit_UOM_Code'));
2001:
2002: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2003: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2004: OE_Order_Util.Get_Attribute_Name('Benefit_UOM_Code'));
2005: OE_MSG_PUB.Add;
2006: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2007:
2008: END IF;
2009:
2002: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2003: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2004: OE_Order_Util.Get_Attribute_Name('Benefit_UOM_Code'));
2005: OE_MSG_PUB.Add;
2006: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2007:
2008: END IF;
2009:
2010:
2011: RETURN FALSE;
2012:
2013: WHEN OTHERS THEN
2014:
2015: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2016: THEN
2017: OE_MSG_PUB.Add_Exc_Msg
2018: ( G_PKG_NAME
2019: , 'Benefit UOM Code '
2013: WHEN OTHERS THEN
2014:
2015: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2016: THEN
2017: OE_MSG_PUB.Add_Exc_Msg
2018: ( G_PKG_NAME
2019: , 'Benefit UOM Code '
2020: );
2021: END IF;
2048:
2049: WHEN NO_DATA_FOUND THEN
2050:
2051:
2052: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2053: THEN
2054:
2055: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Print_On_Invoice_Flag');
2056:
2051:
2052: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2053: THEN
2054:
2055: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Print_On_Invoice_Flag');
2056:
2057: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2058: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2059: OE_Order_Util.Get_Attribute_Name('Print_On_Invoice_Flag'));
2056:
2057: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2058: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2059: OE_Order_Util.Get_Attribute_Name('Print_On_Invoice_Flag'));
2060: OE_MSG_PUB.Add;
2061: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2062:
2063: END IF;
2064:
2057: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2058: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2059: OE_Order_Util.Get_Attribute_Name('Print_On_Invoice_Flag'));
2060: OE_MSG_PUB.Add;
2061: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2062:
2063: END IF;
2064:
2065:
2066: RETURN FALSE;
2067:
2068: WHEN OTHERS THEN
2069:
2070: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2071: THEN
2072: OE_MSG_PUB.Add_Exc_Msg
2073: ( G_PKG_NAME
2074: , 'Print On Invoice Flag'
2068: WHEN OTHERS THEN
2069:
2070: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2071: THEN
2072: OE_MSG_PUB.Add_Exc_Msg
2073: ( G_PKG_NAME
2074: , 'Print On Invoice Flag'
2075: );
2076: END IF;
2103:
2104: WHEN NO_DATA_FOUND THEN
2105:
2106:
2107: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2108: THEN
2109:
2110: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Expiration_Date');
2111:
2106:
2107: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2108: THEN
2109:
2110: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Expiration_Date');
2111:
2112: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2113: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2114: OE_Order_Util.Get_Attribute_Name('Expiration_Date'));
2111:
2112: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2113: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2114: OE_Order_Util.Get_Attribute_Name('Expiration_Date'));
2115: OE_MSG_PUB.Add;
2116: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2117:
2118: END IF;
2119:
2112: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2113: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2114: OE_Order_Util.Get_Attribute_Name('Expiration_Date'));
2115: OE_MSG_PUB.Add;
2116: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2117:
2118: END IF;
2119:
2120:
2121: RETURN FALSE;
2122:
2123: WHEN OTHERS THEN
2124:
2125: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2126: THEN
2127: OE_MSG_PUB.Add_Exc_Msg
2128: ( G_PKG_NAME
2129: , 'Expiration Date'
2123: WHEN OTHERS THEN
2124:
2125: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2126: THEN
2127: OE_MSG_PUB.Add_Exc_Msg
2128: ( G_PKG_NAME
2129: , 'Expiration Date'
2130: );
2131: END IF;
2158:
2159: WHEN NO_DATA_FOUND THEN
2160:
2161:
2162: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2163: THEN
2164:
2165: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Rebate_Transaction_Type_Code');
2166:
2161:
2162: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2163: THEN
2164:
2165: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Rebate_Transaction_Type_Code');
2166:
2167: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2168: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2169: OE_Order_Util.Get_Attribute_Name('Rebate_Transaction_Type_Code'));
2166:
2167: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2168: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2169: OE_Order_Util.Get_Attribute_Name('Rebate_Transaction_Type_Code'));
2170: OE_MSG_PUB.Add;
2171: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2172:
2173: END IF;
2174:
2167: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2168: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2169: OE_Order_Util.Get_Attribute_Name('Rebate_Transaction_Type_Code'));
2170: OE_MSG_PUB.Add;
2171: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2172:
2173: END IF;
2174:
2175:
2176: RETURN FALSE;
2177:
2178: WHEN OTHERS THEN
2179:
2180: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2181: THEN
2182: OE_MSG_PUB.Add_Exc_Msg
2183: ( G_PKG_NAME
2184: , 'Rebate Transaction Type Code'
2178: WHEN OTHERS THEN
2179:
2180: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2181: THEN
2182: OE_MSG_PUB.Add_Exc_Msg
2183: ( G_PKG_NAME
2184: , 'Rebate Transaction Type Code'
2185: );
2186: END IF;
2213:
2214: WHEN NO_DATA_FOUND THEN
2215:
2216:
2217: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2218: THEN
2219:
2220: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Rebate_Transaction_Reference');
2221:
2216:
2217: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2218: THEN
2219:
2220: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Rebate_Transaction_Reference');
2221:
2222: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2223: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2224: OE_Order_Util.Get_Attribute_Name('Rebate_Transaction_Reference'));
2221:
2222: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2223: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2224: OE_Order_Util.Get_Attribute_Name('Rebate_Transaction_Reference'));
2225: OE_MSG_PUB.Add;
2226: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2227:
2228: END IF;
2229:
2222: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2223: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2224: OE_Order_Util.Get_Attribute_Name('Rebate_Transaction_Reference'));
2225: OE_MSG_PUB.Add;
2226: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2227:
2228: END IF;
2229:
2230:
2231: RETURN FALSE;
2232:
2233: WHEN OTHERS THEN
2234:
2235: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2236: THEN
2237: OE_MSG_PUB.Add_Exc_Msg
2238: ( G_PKG_NAME
2239: , 'Rebate_Transaction_Reference'
2233: WHEN OTHERS THEN
2234:
2235: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2236: THEN
2237: OE_MSG_PUB.Add_Exc_Msg
2238: ( G_PKG_NAME
2239: , 'Rebate_Transaction_Reference'
2240: );
2241: END IF;
2268:
2269: WHEN NO_DATA_FOUND THEN
2270:
2271:
2272: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2273: THEN
2274:
2275: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Rebate_Payment_System_Code');
2276:
2271:
2272: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2273: THEN
2274:
2275: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Rebate_Payment_System_Code');
2276:
2277: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2278: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2279: OE_Order_Util.Get_Attribute_Name('Rebate_Payment_System_Code'));
2276:
2277: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2278: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2279: OE_Order_Util.Get_Attribute_Name('Rebate_Payment_System_Code'));
2280: OE_MSG_PUB.Add;
2281: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2282:
2283: END IF;
2284:
2277: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2278: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2279: OE_Order_Util.Get_Attribute_Name('Rebate_Payment_System_Code'));
2280: OE_MSG_PUB.Add;
2281: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2282:
2283: END IF;
2284:
2285:
2286: RETURN FALSE;
2287:
2288: WHEN OTHERS THEN
2289:
2290: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2291: THEN
2292: OE_MSG_PUB.Add_Exc_Msg
2293: ( G_PKG_NAME
2294: , 'Rebate Payment System Code'
2288: WHEN OTHERS THEN
2289:
2290: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2291: THEN
2292: OE_MSG_PUB.Add_Exc_Msg
2293: ( G_PKG_NAME
2294: , 'Rebate Payment System Code'
2295: );
2296: END IF;
2323:
2324: WHEN NO_DATA_FOUND THEN
2325:
2326:
2327: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2328: THEN
2329:
2330: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Redeemed_Date');
2331:
2326:
2327: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2328: THEN
2329:
2330: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Redeemed_Date');
2331:
2332: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2333: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2334: OE_Order_Util.Get_Attribute_Name('Redeemed_Date'));
2331:
2332: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2333: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2334: OE_Order_Util.Get_Attribute_Name('Redeemed_Date'));
2335: OE_MSG_PUB.Add;
2336: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2337:
2338: END IF;
2339:
2332: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2333: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2334: OE_Order_Util.Get_Attribute_Name('Redeemed_Date'));
2335: OE_MSG_PUB.Add;
2336: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2337:
2338: END IF;
2339:
2340:
2341: RETURN FALSE;
2342:
2343: WHEN OTHERS THEN
2344:
2345: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2346: THEN
2347: OE_MSG_PUB.Add_Exc_Msg
2348: ( G_PKG_NAME
2349: , 'Redeemed Date'
2343: WHEN OTHERS THEN
2344:
2345: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2346: THEN
2347: OE_MSG_PUB.Add_Exc_Msg
2348: ( G_PKG_NAME
2349: , 'Redeemed Date'
2350: );
2351: END IF;
2378:
2379: WHEN NO_DATA_FOUND THEN
2380:
2381:
2382: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2383: THEN
2384:
2385: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Redeemed_Flag');
2386:
2381:
2382: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2383: THEN
2384:
2385: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Redeemed_Flag');
2386:
2387: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2388: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2389: OE_Order_Util.Get_Attribute_Name('Redeemed_Flag'));
2386:
2387: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2388: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2389: OE_Order_Util.Get_Attribute_Name('Redeemed_Flag'));
2390: OE_MSG_PUB.Add;
2391: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2392:
2393: END IF;
2394:
2387: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2388: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2389: OE_Order_Util.Get_Attribute_Name('Redeemed_Flag'));
2390: OE_MSG_PUB.Add;
2391: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2392:
2393: END IF;
2394:
2395:
2396: RETURN FALSE;
2397:
2398: WHEN OTHERS THEN
2399:
2400: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2401: THEN
2402: OE_MSG_PUB.Add_Exc_Msg
2403: ( G_PKG_NAME
2404: , 'Redeemed Flag'
2398: WHEN OTHERS THEN
2399:
2400: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2401: THEN
2402: OE_MSG_PUB.Add_Exc_Msg
2403: ( G_PKG_NAME
2404: , 'Redeemed Flag'
2405: );
2406: END IF;
2433:
2434: WHEN NO_DATA_FOUND THEN
2435:
2436:
2437: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2438: THEN
2439:
2440: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Accrual_Flag');
2441:
2436:
2437: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2438: THEN
2439:
2440: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Accrual_Flag');
2441:
2442: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2443: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2444: OE_Order_Util.Get_Attribute_Name('Accrual_Flag'));
2441:
2442: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2443: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2444: OE_Order_Util.Get_Attribute_Name('Accrual_Flag'));
2445: OE_MSG_PUB.Add;
2446: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2447:
2448: END IF;
2449:
2442: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2443: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2444: OE_Order_Util.Get_Attribute_Name('Accrual_Flag'));
2445: OE_MSG_PUB.Add;
2446: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2447:
2448: END IF;
2449:
2450:
2451: RETURN FALSE;
2452:
2453: WHEN OTHERS THEN
2454:
2455: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2456: THEN
2457: OE_MSG_PUB.Add_Exc_Msg
2458: ( G_PKG_NAME
2459: , 'Accrual Flag'
2453: WHEN OTHERS THEN
2454:
2455: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2456: THEN
2457: OE_MSG_PUB.Add_Exc_Msg
2458: ( G_PKG_NAME
2459: , 'Accrual Flag'
2460: );
2461: END IF;
2488:
2489: WHEN NO_DATA_FOUND THEN
2490:
2491:
2492: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2493: THEN
2494:
2495: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'range_break_quantity');
2496:
2491:
2492: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2493: THEN
2494:
2495: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'range_break_quantity');
2496:
2497: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2498: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2499: OE_Order_Util.Get_Attribute_Name('range_break_quantity'));
2496:
2497: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2498: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2499: OE_Order_Util.Get_Attribute_Name('range_break_quantity'));
2500: OE_MSG_PUB.Add;
2501: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2502:
2503: END IF;
2504:
2497: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2498: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2499: OE_Order_Util.Get_Attribute_Name('range_break_quantity'));
2500: OE_MSG_PUB.Add;
2501: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2502:
2503: END IF;
2504:
2505:
2506: RETURN FALSE;
2507:
2508: WHEN OTHERS THEN
2509:
2510: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2511: THEN
2512: OE_MSG_PUB.Add_Exc_Msg
2513: ( G_PKG_NAME
2514: , 'range_break_quantity'
2508: WHEN OTHERS THEN
2509:
2510: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2511: THEN
2512: OE_MSG_PUB.Add_Exc_Msg
2513: ( G_PKG_NAME
2514: , 'range_break_quantity'
2515: );
2516: END IF;
2543:
2544: WHEN NO_DATA_FOUND THEN
2545:
2546:
2547: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2548: THEN
2549:
2550: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'accrual_conversion_rate');
2551:
2546:
2547: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2548: THEN
2549:
2550: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'accrual_conversion_rate');
2551:
2552: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2553: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2554: OE_Order_Util.Get_Attribute_Name('accrual_conversion_rate'));
2551:
2552: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2553: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2554: OE_Order_Util.Get_Attribute_Name('accrual_conversion_rate'));
2555: OE_MSG_PUB.Add;
2556: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2557:
2558: END IF;
2559:
2552: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2553: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2554: OE_Order_Util.Get_Attribute_Name('accrual_conversion_rate'));
2555: OE_MSG_PUB.Add;
2556: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2557:
2558: END IF;
2559:
2560:
2561: RETURN FALSE;
2562:
2563: WHEN OTHERS THEN
2564:
2565: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2566: THEN
2567: OE_MSG_PUB.Add_Exc_Msg
2568: ( G_PKG_NAME
2569: , 'accrual_conversion_rate'
2563: WHEN OTHERS THEN
2564:
2565: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2566: THEN
2567: OE_MSG_PUB.Add_Exc_Msg
2568: ( G_PKG_NAME
2569: , 'accrual_conversion_rate'
2570: );
2571: END IF;
2598:
2599: WHEN NO_DATA_FOUND THEN
2600:
2601:
2602: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2603: THEN
2604:
2605: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'pricing_group_sequence');
2606:
2601:
2602: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2603: THEN
2604:
2605: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'pricing_group_sequence');
2606:
2607: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2609: OE_Order_Util.Get_Attribute_Name('pricing_group_sequence'));
2606:
2607: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2609: OE_Order_Util.Get_Attribute_Name('pricing_group_sequence'));
2610: OE_MSG_PUB.Add;
2611: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2612:
2613: END IF;
2614:
2607: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2609: OE_Order_Util.Get_Attribute_Name('pricing_group_sequence'));
2610: OE_MSG_PUB.Add;
2611: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2612:
2613: END IF;
2614:
2615:
2616: RETURN FALSE;
2617:
2618: WHEN OTHERS THEN
2619:
2620: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2621: THEN
2622: OE_MSG_PUB.Add_Exc_Msg
2623: ( G_PKG_NAME
2624: , 'pricing_group_sequence'
2618: WHEN OTHERS THEN
2619:
2620: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2621: THEN
2622: OE_MSG_PUB.Add_Exc_Msg
2623: ( G_PKG_NAME
2624: , 'pricing_group_sequence'
2625: );
2626: END IF;
2653:
2654: WHEN NO_DATA_FOUND THEN
2655:
2656:
2657: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2658: THEN
2659:
2660: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'modifier_level_code');
2661:
2656:
2657: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2658: THEN
2659:
2660: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'modifier_level_code');
2661:
2662: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2663: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2664: OE_Order_Util.Get_Attribute_Name('modifier_level_code'));
2661:
2662: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2663: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2664: OE_Order_Util.Get_Attribute_Name('modifier_level_code'));
2665: OE_MSG_PUB.Add;
2666: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2667:
2668: END IF;
2669:
2662: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2663: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2664: OE_Order_Util.Get_Attribute_Name('modifier_level_code'));
2665: OE_MSG_PUB.Add;
2666: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2667:
2668: END IF;
2669:
2670:
2671: RETURN FALSE;
2672:
2673: WHEN OTHERS THEN
2674:
2675: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2676: THEN
2677: OE_MSG_PUB.Add_Exc_Msg
2678: ( G_PKG_NAME
2679: , 'modifier_level_code'
2673: WHEN OTHERS THEN
2674:
2675: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2676: THEN
2677: OE_MSG_PUB.Add_Exc_Msg
2678: ( G_PKG_NAME
2679: , 'modifier_level_code'
2680: );
2681: END IF;
2708:
2709: WHEN NO_DATA_FOUND THEN
2710:
2711:
2712: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2713: THEN
2714:
2715: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'price_break_type_code');
2716:
2711:
2712: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2713: THEN
2714:
2715: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'price_break_type_code');
2716:
2717: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2718: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2719: OE_Order_Util.Get_Attribute_Name('price_break_type_code'));
2716:
2717: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2718: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2719: OE_Order_Util.Get_Attribute_Name('price_break_type_code'));
2720: OE_MSG_PUB.Add;
2721: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2722:
2723: END IF;
2724:
2717: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2718: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2719: OE_Order_Util.Get_Attribute_Name('price_break_type_code'));
2720: OE_MSG_PUB.Add;
2721: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2722:
2723: END IF;
2724:
2725:
2726: RETURN FALSE;
2727:
2728: WHEN OTHERS THEN
2729:
2730: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2731: THEN
2732: OE_MSG_PUB.Add_Exc_Msg
2733: ( G_PKG_NAME
2734: , 'price_break_type_code'
2728: WHEN OTHERS THEN
2729:
2730: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2731: THEN
2732: OE_MSG_PUB.Add_Exc_Msg
2733: ( G_PKG_NAME
2734: , 'price_break_type_code'
2735: );
2736: END IF;
2763:
2764: WHEN NO_DATA_FOUND THEN
2765:
2766:
2767: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2768: THEN
2769:
2770: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'substitution_attribute');
2771:
2766:
2767: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2768: THEN
2769:
2770: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'substitution_attribute');
2771:
2772: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2773: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2774: OE_Order_Util.Get_Attribute_Name('substitution_attribute'));
2771:
2772: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2773: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2774: OE_Order_Util.Get_Attribute_Name('substitution_attribute'));
2775: OE_MSG_PUB.Add;
2776: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2777:
2778: END IF;
2779:
2772: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2773: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2774: OE_Order_Util.Get_Attribute_Name('substitution_attribute'));
2775: OE_MSG_PUB.Add;
2776: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2777:
2778: END IF;
2779:
2780:
2781: RETURN FALSE;
2782:
2783: WHEN OTHERS THEN
2784:
2785: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2786: THEN
2787: OE_MSG_PUB.Add_Exc_Msg
2788: ( G_PKG_NAME
2789: , 'substitution_attribute'
2783: WHEN OTHERS THEN
2784:
2785: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2786: THEN
2787: OE_MSG_PUB.Add_Exc_Msg
2788: ( G_PKG_NAME
2789: , 'substitution_attribute'
2790: );
2791: END IF;
2818:
2819: WHEN NO_DATA_FOUND THEN
2820:
2821:
2822: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2823: THEN
2824:
2825: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'proration_type_code');
2826:
2821:
2822: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2823: THEN
2824:
2825: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'proration_type_code');
2826:
2827: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2828: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2829: OE_Order_Util.Get_Attribute_Name('proration_type_code'));
2826:
2827: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2828: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2829: OE_Order_Util.Get_Attribute_Name('proration_type_code'));
2830: OE_MSG_PUB.Add;
2831: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2832:
2833: END IF;
2834:
2827: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2828: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2829: OE_Order_Util.Get_Attribute_Name('proration_type_code'));
2830: OE_MSG_PUB.Add;
2831: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2832:
2833: END IF;
2834:
2835:
2836: RETURN FALSE;
2837:
2838: WHEN OTHERS THEN
2839:
2840: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2841: THEN
2842: OE_MSG_PUB.Add_Exc_Msg
2843: ( G_PKG_NAME
2844: , 'proration_type_code'
2838: WHEN OTHERS THEN
2839:
2840: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2841: THEN
2842: OE_MSG_PUB.Add_Exc_Msg
2843: ( G_PKG_NAME
2844: , 'proration_type_code'
2845: );
2846: END IF;
2874: EXCEPTION
2875:
2876: WHEN NO_DATA_FOUND THEN
2877:
2878: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2879: THEN
2880:
2881: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UPDATED_FLAG');
2882:
2877:
2878: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2879: THEN
2880:
2881: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UPDATED_FLAG');
2882:
2883: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2884: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2885: OE_Order_Util.Get_Attribute_Name('Updated_Flag'));
2882:
2883: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2884: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2885: OE_Order_Util.Get_Attribute_Name('Updated_Flag'));
2886: OE_MSG_PUB.Add;
2887: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2888:
2889: END IF;
2890:
2883: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2884: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2885: OE_Order_Util.Get_Attribute_Name('Updated_Flag'));
2886: OE_MSG_PUB.Add;
2887: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2888:
2889: END IF;
2890:
2891:
2892: RETURN FALSE;
2893:
2894: WHEN OTHERS THEN
2895:
2896: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2897: THEN
2898: OE_MSG_PUB.Add_Exc_Msg
2899: ( G_PKG_NAME
2900: , 'Updated_Flag'
2894: WHEN OTHERS THEN
2895:
2896: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2897: THEN
2898: OE_MSG_PUB.Add_Exc_Msg
2899: ( G_PKG_NAME
2900: , 'Updated_Flag'
2901: );
2902: END IF;
2932: EXCEPTION
2933:
2934: WHEN NO_DATA_FOUND THEN
2935:
2936: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2937: THEN
2938:
2939: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UPDATE_ALLOWED');
2940:
2935:
2936: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2937: THEN
2938:
2939: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UPDATE_ALLOWED');
2940:
2941: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2942: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2943: OE_Order_Util.Get_Attribute_Name('Update_Allowed'));
2940:
2941: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2942: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2943: OE_Order_Util.Get_Attribute_Name('Update_Allowed'));
2944: OE_MSG_PUB.Add;
2945: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2946:
2947: END IF;
2948:
2941: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2942: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2943: OE_Order_Util.Get_Attribute_Name('Update_Allowed'));
2944: OE_MSG_PUB.Add;
2945: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2946:
2947: END IF;
2948:
2949:
2950: RETURN FALSE;
2951:
2952: WHEN OTHERS THEN
2953:
2954: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2955: THEN
2956: OE_MSG_PUB.Add_Exc_Msg
2957: ( G_PKG_NAME
2958: , 'Update_Allowed'
2952: WHEN OTHERS THEN
2953:
2954: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2955: THEN
2956: OE_MSG_PUB.Add_Exc_Msg
2957: ( G_PKG_NAME
2958: , 'Update_Allowed'
2959: );
2960: END IF;
2990: EXCEPTION
2991:
2992: WHEN NO_DATA_FOUND THEN
2993:
2994: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2995: THEN
2996:
2997: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREATED_BY');
2998:
2993:
2994: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2995: THEN
2996:
2997: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREATED_BY');
2998:
2999: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3000: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3001: OE_Order_Util.Get_Attribute_Name('created_by'));
2998:
2999: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3000: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3001: OE_Order_Util.Get_Attribute_Name('created_by'));
3002: OE_MSG_PUB.Add;
3003: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
3004:
3005: END IF;
3006:
2999: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3000: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3001: OE_Order_Util.Get_Attribute_Name('created_by'));
3002: OE_MSG_PUB.Add;
3003: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
3004:
3005: END IF;
3006:
3007:
3008: RETURN FALSE;
3009:
3010: WHEN OTHERS THEN
3011:
3012: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3013: THEN
3014: OE_MSG_PUB.Add_Exc_Msg
3015: ( G_PKG_NAME
3016: , 'Created_By'
3010: WHEN OTHERS THEN
3011:
3012: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3013: THEN
3014: OE_MSG_PUB.Add_Exc_Msg
3015: ( G_PKG_NAME
3016: , 'Created_By'
3017: );
3018: END IF;
3047: EXCEPTION
3048:
3049: WHEN NO_DATA_FOUND THEN
3050:
3051: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3052: THEN
3053:
3054: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREATION_DATE');
3055:
3050:
3051: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3052: THEN
3053:
3054: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREATION_DATE');
3055:
3056: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3057: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3058: OE_Order_Util.Get_Attribute_Name('creation_date'));
3055:
3056: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3057: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3058: OE_Order_Util.Get_Attribute_Name('creation_date'));
3059: OE_MSG_PUB.Add;
3060: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
3061:
3062: END IF;
3063:
3056: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3057: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3058: OE_Order_Util.Get_Attribute_Name('creation_date'));
3059: OE_MSG_PUB.Add;
3060: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
3061:
3062: END IF;
3063:
3064:
3065: RETURN FALSE;
3066:
3067: WHEN OTHERS THEN
3068:
3069: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3070: THEN
3071: OE_MSG_PUB.Add_Exc_Msg
3072: ( G_PKG_NAME
3073: , 'Creation_Date'
3067: WHEN OTHERS THEN
3068:
3069: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3070: THEN
3071: OE_MSG_PUB.Add_Exc_Msg
3072: ( G_PKG_NAME
3073: , 'Creation_Date'
3074: );
3075: END IF;
3106: EXCEPTION
3107:
3108: WHEN NO_DATA_FOUND THEN
3109:
3110: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3111: THEN
3112:
3113: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OVERRIDE_FLAG');
3114:
3109:
3110: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3111: THEN
3112:
3113: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OVERRIDE_FLAG');
3114:
3115: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3116: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3117: OE_Order_Util.Get_Attribute_Name('override_flag'));
3114:
3115: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3116: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3117: OE_Order_Util.Get_Attribute_Name('override_flag'));
3118: OE_MSG_PUB.Add;
3119: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
3120:
3121: END IF;
3122:
3115: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3116: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3117: OE_Order_Util.Get_Attribute_Name('override_flag'));
3118: OE_MSG_PUB.Add;
3119: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
3120:
3121: END IF;
3122:
3123:
3124: RETURN FALSE;
3125:
3126: WHEN OTHERS THEN
3127:
3128: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3129: THEN
3130: OE_MSG_PUB.Add_Exc_Msg
3131: ( G_PKG_NAME
3132: , 'override_flag'
3126: WHEN OTHERS THEN
3127:
3128: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3129: THEN
3130: OE_MSG_PUB.Add_Exc_Msg
3131: ( G_PKG_NAME
3132: , 'override_flag'
3133: );
3134: END IF;
3164: EXCEPTION
3165:
3166: WHEN NO_DATA_FOUND THEN
3167:
3168: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3169: THEN
3170:
3171: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'REQUEST_DATE');
3172:
3167:
3168: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3169: THEN
3170:
3171: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'REQUEST_DATE');
3172:
3173: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3174: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3175: OE_Order_Util.Get_Attribute_Name('request_date'));
3172:
3173: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3174: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3175: OE_Order_Util.Get_Attribute_Name('request_date'));
3176: OE_MSG_PUB.Add;
3177: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
3178:
3179: END IF;
3180:
3173: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3174: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3175: OE_Order_Util.Get_Attribute_Name('request_date'));
3176: OE_MSG_PUB.Add;
3177: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
3178:
3179: END IF;
3180:
3181:
3182: RETURN FALSE;
3183:
3184: WHEN OTHERS THEN
3185:
3186: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3187: THEN
3188: OE_MSG_PUB.Add_Exc_Msg
3189: ( G_PKG_NAME
3190: , 'Request_Date'
3184: WHEN OTHERS THEN
3185:
3186: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3187: THEN
3188: OE_MSG_PUB.Add_Exc_Msg
3189: ( G_PKG_NAME
3190: , 'Request_Date'
3191: );
3192: END IF;
3217: IS
3218: l_column_value VARCHAR2(240) := null;
3219: BEGIN
3220:
3221: -- OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONTEXT');
3222:
3223: IF (p_attribute1 = FND_API.G_MISS_CHAR)
3224: AND (p_attribute2 = FND_API.G_MISS_CHAR)
3225: AND (p_attribute3 = FND_API.G_MISS_CHAR)
3465:
3466: WHEN OTHERS THEN
3467:
3468:
3469: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3470: THEN
3471:
3472: OE_MSG_PUB.Add_Exc_Msg
3473: ( G_PKG_NAME
3468:
3469: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3470: THEN
3471:
3472: OE_MSG_PUB.Add_Exc_Msg
3473: ( G_PKG_NAME
3474: , 'Price_Adj_Desc_Flex');
3475: END IF;
3476: