DBA Data[Home] [Help]

APPS.QP_ID_TO_VALUE dependencies on OE_MSG_PUB

Line 202: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

198: EXCEPTION
199:
200: WHEN NO_DATA_FOUND THEN
201:
202: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
203: THEN
204:
205: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
206: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');

Line 207: oe_msg_pub.Add;

203: THEN
204:
205: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
206: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');
207: oe_msg_pub.Add;
208:
209: END IF;
210:
211: RETURN NULL;

Line 215: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

211: RETURN NULL;
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: , 'Automatic'

Line 217: oe_msg_pub.Add_Exc_Msg

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: , 'Automatic'
220: );
221: END IF;

Line 251: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

247: EXCEPTION
248:
249: WHEN NO_DATA_FOUND THEN
250:
251: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
252: THEN
253:
254: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
255: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency');

Line 256: oe_msg_pub.Add;

252: THEN
253:
254: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
255: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency');
256: oe_msg_pub.Add;
257:
258: END IF;
259:
260: RETURN NULL;

Line 264: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

260: RETURN NULL;
261:
262: WHEN OTHERS THEN
263:
264: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
265: THEN
266: oe_msg_pub.Add_Exc_Msg
267: ( G_PKG_NAME
268: , 'Currency'

Line 266: oe_msg_pub.Add_Exc_Msg

262: WHEN OTHERS THEN
263:
264: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
265: THEN
266: oe_msg_pub.Add_Exc_Msg
267: ( G_PKG_NAME
268: , 'Currency'
269: );
270: END IF;

Line 300: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

296: EXCEPTION
297:
298: WHEN NO_DATA_FOUND THEN
299:
300: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
301: THEN
302:
303: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
304: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_lines');

Line 305: oe_msg_pub.Add;

301: THEN
302:
303: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
304: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_lines');
305: oe_msg_pub.Add;
306:
307: END IF;
308:
309: RETURN NULL;

Line 313: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

309: RETURN NULL;
310:
311: WHEN OTHERS THEN
312:
313: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
314: THEN
315: oe_msg_pub.Add_Exc_Msg
316: ( G_PKG_NAME
317: , 'Discount_Lines'

Line 315: oe_msg_pub.Add_Exc_Msg

311: WHEN OTHERS THEN
312:
313: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
314: THEN
315: oe_msg_pub.Add_Exc_Msg
316: ( G_PKG_NAME
317: , 'Discount_Lines'
318: );
319: END IF;

Line 349: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

345: EXCEPTION
346:
347: WHEN NO_DATA_FOUND THEN
348:
349: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
350: THEN
351:
352: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
353: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');

Line 354: oe_msg_pub.Add;

350: THEN
351:
352: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
353: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
354: oe_msg_pub.Add;
355:
356: END IF;
357:
358: RETURN NULL;

Line 362: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

358: RETURN NULL;
359:
360: WHEN OTHERS THEN
361:
362: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
363: THEN
364: oe_msg_pub.Add_Exc_Msg
365: ( G_PKG_NAME
366: , 'Freight_Terms'

Line 364: oe_msg_pub.Add_Exc_Msg

360: WHEN OTHERS THEN
361:
362: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
363: THEN
364: oe_msg_pub.Add_Exc_Msg
365: ( G_PKG_NAME
366: , 'Freight_Terms'
367: );
368: END IF;

Line 399: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

395: EXCEPTION
396:
397: WHEN NO_DATA_FOUND THEN
398:
399: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
400: THEN
401:
402: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
403: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');

Line 404: oe_msg_pub.Add;

400: THEN
401:
402: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
403: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
404: oe_msg_pub.Add;
405:
406: END IF;
407:
408: RETURN NULL;

Line 412: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

408: RETURN NULL;
409:
410: WHEN OTHERS THEN
411:
412: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
413: THEN
414: oe_msg_pub.Add_Exc_Msg
415: ( G_PKG_NAME
416: , 'List_Header'

Line 414: oe_msg_pub.Add_Exc_Msg

410: WHEN OTHERS THEN
411:
412: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
413: THEN
414: oe_msg_pub.Add_Exc_Msg
415: ( G_PKG_NAME
416: , 'List_Header'
417: );
418: END IF;

Line 447: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

443: EXCEPTION
444:
445: WHEN NO_DATA_FOUND THEN
446:
447: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
448: THEN
449:
450: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
451: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_type');

Line 452: oe_msg_pub.Add;

448: THEN
449:
450: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
451: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_type');
452: oe_msg_pub.Add;
453:
454: END IF;
455:
456: RETURN NULL;

Line 460: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

456: RETURN NULL;
457:
458: WHEN OTHERS THEN
459:
460: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
461: THEN
462: oe_msg_pub.Add_Exc_Msg
463: ( G_PKG_NAME
464: , 'List_Type'

Line 462: oe_msg_pub.Add_Exc_Msg

458: WHEN OTHERS THEN
459:
460: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
461: THEN
462: oe_msg_pub.Add_Exc_Msg
463: ( G_PKG_NAME
464: , 'List_Type'
465: );
466: END IF;

Line 496: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

492: EXCEPTION
493:
494: WHEN NO_DATA_FOUND THEN
495:
496: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
497: THEN
498:
499: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
500: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prorate');

Line 501: oe_msg_pub.Add;

497: THEN
498:
499: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
500: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prorate');
501: oe_msg_pub.Add;
502:
503: END IF;
504:
505: RETURN NULL;

Line 509: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

505: RETURN NULL;
506:
507: WHEN OTHERS THEN
508:
509: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
510: THEN
511: oe_msg_pub.Add_Exc_Msg
512: ( G_PKG_NAME
513: , 'Prorate'

Line 511: oe_msg_pub.Add_Exc_Msg

507: WHEN OTHERS THEN
508:
509: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
510: THEN
511: oe_msg_pub.Add_Exc_Msg
512: ( G_PKG_NAME
513: , 'Prorate'
514: );
515: END IF;

Line 545: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

541: EXCEPTION
542:
543: WHEN NO_DATA_FOUND THEN
544:
545: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
546: THEN
547:
548: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
549: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_method');

Line 550: oe_msg_pub.Add;

546: THEN
547:
548: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
549: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_method');
550: oe_msg_pub.Add;
551:
552: END IF;
553:
554: RETURN NULL;

Line 558: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

554: RETURN NULL;
555:
556: WHEN OTHERS THEN
557:
558: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
559: THEN
560: oe_msg_pub.Add_Exc_Msg
561: ( G_PKG_NAME
562: , 'Ship_Method'

Line 560: oe_msg_pub.Add_Exc_Msg

556: WHEN OTHERS THEN
557:
558: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
559: THEN
560: oe_msg_pub.Add_Exc_Msg
561: ( G_PKG_NAME
562: , 'Ship_Method'
563: );
564: END IF;

Line 594: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

590: EXCEPTION
591:
592: WHEN NO_DATA_FOUND THEN
593:
594: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
595: THEN
596:
597: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
598: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','terms');

Line 599: oe_msg_pub.Add;

595: THEN
596:
597: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
598: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','terms');
599: oe_msg_pub.Add;
600:
601: END IF;
602:
603: RETURN NULL;

Line 607: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

603: RETURN NULL;
604:
605: WHEN OTHERS THEN
606:
607: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
608: THEN
609: oe_msg_pub.Add_Exc_Msg
610: ( G_PKG_NAME
611: , 'Terms'

Line 609: oe_msg_pub.Add_Exc_Msg

605: WHEN OTHERS THEN
606:
607: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
608: THEN
609: oe_msg_pub.Add_Exc_Msg
610: ( G_PKG_NAME
611: , 'Terms'
612: );
613: END IF;

Line 643: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

639: EXCEPTION
640:
641: WHEN NO_DATA_FOUND THEN
642:
643: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
644: THEN
645:
646: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
647: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_uom');

Line 648: oe_msg_pub.Add;

644: THEN
645:
646: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
647: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_uom');
648: oe_msg_pub.Add;
649:
650: END IF;
651:
652: RETURN NULL;

Line 656: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

652: RETURN NULL;
653:
654: WHEN OTHERS THEN
655:
656: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
657: THEN
658: oe_msg_pub.Add_Exc_Msg
659: ( G_PKG_NAME
660: , 'Base_Uom'

Line 658: oe_msg_pub.Add_Exc_Msg

654: WHEN OTHERS THEN
655:
656: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
657: THEN
658: oe_msg_pub.Add_Exc_Msg
659: ( G_PKG_NAME
660: , 'Base_Uom'
661: );
662: END IF;

Line 697: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

693: EXCEPTION
694:
695: WHEN NO_DATA_FOUND THEN
696:
697: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
698: THEN
699:
700: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
701: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','generate_using_formula');

Line 702: oe_msg_pub.Add;

698: THEN
699:
700: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
701: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','generate_using_formula');
702: oe_msg_pub.Add;
703:
704: END IF;
705:
706: RETURN NULL;

Line 710: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

706: RETURN NULL;
707:
708: WHEN OTHERS THEN
709:
710: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
711: THEN
712: oe_msg_pub.Add_Exc_Msg
713: ( G_PKG_NAME
714: , 'Generate_Using_Formula'

Line 712: oe_msg_pub.Add_Exc_Msg

708: WHEN OTHERS THEN
709:
710: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
711: THEN
712: oe_msg_pub.Add_Exc_Msg
713: ( G_PKG_NAME
714: , 'Generate_Using_Formula'
715: );
716: END IF;

Line 746: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

742: EXCEPTION
743:
744: WHEN NO_DATA_FOUND THEN
745:
746: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
747: THEN
748:
749: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
750: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','gl_class');

Line 751: oe_msg_pub.Add;

747: THEN
748:
749: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
750: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','gl_class');
751: oe_msg_pub.Add;
752:
753: END IF;
754:
755: RETURN NULL;

Line 759: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

755: RETURN NULL;
756:
757: WHEN OTHERS THEN
758:
759: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
760: THEN
761: oe_msg_pub.Add_Exc_Msg
762: ( G_PKG_NAME
763: , 'Gl_Class'

Line 761: oe_msg_pub.Add_Exc_Msg

757: WHEN OTHERS THEN
758:
759: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
760: THEN
761: oe_msg_pub.Add_Exc_Msg
762: ( G_PKG_NAME
763: , 'Gl_Class'
764: );
765: END IF;

Line 795: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

791: EXCEPTION
792:
793: WHEN NO_DATA_FOUND THEN
794:
795: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
796: THEN
797:
798: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
799: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');

Line 800: oe_msg_pub.Add;

796: THEN
797:
798: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
799: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');
800: oe_msg_pub.Add;
801:
802: END IF;
803:
804: RETURN NULL;

Line 808: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

804: RETURN NULL;
805:
806: WHEN OTHERS THEN
807:
808: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
809: THEN
810: oe_msg_pub.Add_Exc_Msg
811: ( G_PKG_NAME
812: , 'Inventory_Item'

Line 810: oe_msg_pub.Add_Exc_Msg

806: WHEN OTHERS THEN
807:
808: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
809: THEN
810: oe_msg_pub.Add_Exc_Msg
811: ( G_PKG_NAME
812: , 'Inventory_Item'
813: );
814: END IF;

Line 844: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

840: EXCEPTION
841:
842: WHEN NO_DATA_FOUND THEN
843:
844: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
845: THEN
846:
847: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
848: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');

Line 849: oe_msg_pub.Add;

845: THEN
846:
847: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
848: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');
849: oe_msg_pub.Add;
850:
851: END IF;
852:
853: RETURN NULL;

Line 857: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

853: RETURN NULL;
854:
855: WHEN OTHERS THEN
856:
857: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
858: THEN
859: oe_msg_pub.Add_Exc_Msg
860: ( G_PKG_NAME
861: , 'List_Line'

Line 859: oe_msg_pub.Add_Exc_Msg

855: WHEN OTHERS THEN
856:
857: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
858: THEN
859: oe_msg_pub.Add_Exc_Msg
860: ( G_PKG_NAME
861: , 'List_Line'
862: );
863: END IF;

Line 898: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

894: EXCEPTION
895:
896: WHEN NO_DATA_FOUND THEN
897:
898: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
899: THEN
900:
901: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
902: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_type');

Line 903: oe_msg_pub.Add;

899: THEN
900:
901: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
902: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_type');
903: oe_msg_pub.Add;
904:
905: END IF;
906:
907: RETURN NULL;

Line 911: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

907: RETURN NULL;
908:
909: WHEN OTHERS THEN
910:
911: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
912: THEN
913: oe_msg_pub.Add_Exc_Msg
914: ( G_PKG_NAME
915: , 'List_Line_Type'

Line 913: oe_msg_pub.Add_Exc_Msg

909: WHEN OTHERS THEN
910:
911: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
912: THEN
913: oe_msg_pub.Add_Exc_Msg
914: ( G_PKG_NAME
915: , 'List_Line_Type'
916: );
917: END IF;

Line 947: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

943: EXCEPTION
944:
945: WHEN NO_DATA_FOUND THEN
946:
947: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
948: THEN
949:
950: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
951: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_price_uom');

Line 952: oe_msg_pub.Add;

948: THEN
949:
950: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
951: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_price_uom');
952: oe_msg_pub.Add;
953:
954: END IF;
955:
956: RETURN NULL;

Line 960: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

956: RETURN NULL;
957:
958: WHEN OTHERS THEN
959:
960: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
961: THEN
962: oe_msg_pub.Add_Exc_Msg
963: ( G_PKG_NAME
964: , 'List_Price_Uom'

Line 962: oe_msg_pub.Add_Exc_Msg

958: WHEN OTHERS THEN
959:
960: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
961: THEN
962: oe_msg_pub.Add_Exc_Msg
963: ( G_PKG_NAME
964: , 'List_Price_Uom'
965: );
966: END IF;

Line 996: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

992: EXCEPTION
993:
994: WHEN NO_DATA_FOUND THEN
995:
996: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
997: THEN
998:
999: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1000: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','modifier_level');

Line 1001: oe_msg_pub.Add;

997: THEN
998:
999: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1000: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','modifier_level');
1001: oe_msg_pub.Add;
1002:
1003: END IF;
1004:
1005: RETURN NULL;

Line 1009: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1005: RETURN NULL;
1006:
1007: WHEN OTHERS THEN
1008:
1009: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1010: THEN
1011: oe_msg_pub.Add_Exc_Msg
1012: ( G_PKG_NAME
1013: , 'Modifier_Level'

Line 1011: oe_msg_pub.Add_Exc_Msg

1007: WHEN OTHERS THEN
1008:
1009: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1010: THEN
1011: oe_msg_pub.Add_Exc_Msg
1012: ( G_PKG_NAME
1013: , 'Modifier_Level'
1014: );
1015: END IF;

Line 1046: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

1042: EXCEPTION
1043:
1044: WHEN NO_DATA_FOUND THEN
1045:
1046: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
1047: THEN
1048:
1049: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1050: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');

Line 1051: oe_msg_pub.Add;

1047: THEN
1048:
1049: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1050: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');
1051: oe_msg_pub.Add;
1052:
1053: END IF;
1054:
1055: RETURN NULL;

Line 1059: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1055: RETURN NULL;
1056:
1057: WHEN OTHERS THEN
1058:
1059: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1060: THEN
1061: oe_msg_pub.Add_Exc_Msg
1062: ( G_PKG_NAME
1063: , 'Organization'

Line 1061: oe_msg_pub.Add_Exc_Msg

1057: WHEN OTHERS THEN
1058:
1059: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1060: THEN
1061: oe_msg_pub.Add_Exc_Msg
1062: ( G_PKG_NAME
1063: , 'Organization'
1064: );
1065: END IF;

Line 1096: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

1092: EXCEPTION
1093:
1094: WHEN NO_DATA_FOUND THEN
1095:
1096: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
1097: THEN
1098:
1099: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1100: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');

Line 1101: oe_msg_pub.Add;

1097: THEN
1098:
1099: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1100: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');
1101: oe_msg_pub.Add;
1102:
1103: END IF;
1104:
1105: RETURN NULL;

Line 1109: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1105: RETURN NULL;
1106:
1107: WHEN OTHERS THEN
1108:
1109: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1110: THEN
1111: oe_msg_pub.Add_Exc_Msg
1112: ( G_PKG_NAME
1113: , 'Organization'

Line 1111: oe_msg_pub.Add_Exc_Msg

1107: WHEN OTHERS THEN
1108:
1109: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1110: THEN
1111: oe_msg_pub.Add_Exc_Msg
1112: ( G_PKG_NAME
1113: , 'Organization'
1114: );
1115: END IF;

Line 1145: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

1141: EXCEPTION
1142:
1143: WHEN NO_DATA_FOUND THEN
1144:
1145: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
1146: THEN
1147:
1148: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1149: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override');

Line 1150: oe_msg_pub.Add;

1146: THEN
1147:
1148: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1149: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override');
1150: oe_msg_pub.Add;
1151:
1152: END IF;
1153:
1154: RETURN NULL;

Line 1158: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1154: RETURN NULL;
1155:
1156: WHEN OTHERS THEN
1157:
1158: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1159: THEN
1160: oe_msg_pub.Add_Exc_Msg
1161: ( G_PKG_NAME
1162: , 'Override'

Line 1160: oe_msg_pub.Add_Exc_Msg

1156: WHEN OTHERS THEN
1157:
1158: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1159: THEN
1160: oe_msg_pub.Add_Exc_Msg
1161: ( G_PKG_NAME
1162: , 'Override'
1163: );
1164: END IF;

Line 1199: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

1195: EXCEPTION
1196:
1197: WHEN NO_DATA_FOUND THEN
1198:
1199: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
1200: THEN
1201:
1202: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1203: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_break_type');

Line 1204: oe_msg_pub.Add;

1200: THEN
1201:
1202: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1203: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_break_type');
1204: oe_msg_pub.Add;
1205:
1206: END IF;
1207:
1208: RETURN NULL;

Line 1212: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1208: RETURN NULL;
1209:
1210: WHEN OTHERS THEN
1211:
1212: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1213: THEN
1214: oe_msg_pub.Add_Exc_Msg
1215: ( G_PKG_NAME
1216: , 'Price_Break_Type'

Line 1214: oe_msg_pub.Add_Exc_Msg

1210: WHEN OTHERS THEN
1211:
1212: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1213: THEN
1214: oe_msg_pub.Add_Exc_Msg
1215: ( G_PKG_NAME
1216: , 'Price_Break_Type'
1217: );
1218: END IF;

Line 1253: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

1249: EXCEPTION
1250:
1251: WHEN NO_DATA_FOUND THEN
1252:
1253: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
1254: THEN
1255:
1256: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1257: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_by_formula');

Line 1258: oe_msg_pub.Add;

1254: THEN
1255:
1256: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1257: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_by_formula');
1258: oe_msg_pub.Add;
1259:
1260: END IF;
1261:
1262: RETURN NULL;

Line 1266: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1262: RETURN NULL;
1263:
1264: WHEN OTHERS THEN
1265:
1266: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1267: THEN
1268: oe_msg_pub.Add_Exc_Msg
1269: ( G_PKG_NAME
1270: , 'Price_By_Formula'

Line 1268: oe_msg_pub.Add_Exc_Msg

1264: WHEN OTHERS THEN
1265:
1266: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1267: THEN
1268: oe_msg_pub.Add_Exc_Msg
1269: ( G_PKG_NAME
1270: , 'Price_By_Formula'
1271: );
1272: END IF;

Line 1302: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

1298: EXCEPTION
1299:
1300: WHEN NO_DATA_FOUND THEN
1301:
1302: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
1303: THEN
1304:
1305: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1306: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','primary_uom');

Line 1307: oe_msg_pub.Add;

1303: THEN
1304:
1305: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1306: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','primary_uom');
1307: oe_msg_pub.Add;
1308:
1309: END IF;
1310:
1311: RETURN NULL;

Line 1315: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1311: RETURN NULL;
1312:
1313: WHEN OTHERS THEN
1314:
1315: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1316: THEN
1317: oe_msg_pub.Add_Exc_Msg
1318: ( G_PKG_NAME
1319: , 'Primary_Uom'

Line 1317: oe_msg_pub.Add_Exc_Msg

1313: WHEN OTHERS THEN
1314:
1315: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1316: THEN
1317: oe_msg_pub.Add_Exc_Msg
1318: ( G_PKG_NAME
1319: , 'Primary_Uom'
1320: );
1321: END IF;

Line 1351: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

1347: EXCEPTION
1348:
1349: WHEN NO_DATA_FOUND THEN
1350:
1351: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
1352: THEN
1353:
1354: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1355: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','print_on_invoice');

Line 1356: oe_msg_pub.Add;

1352: THEN
1353:
1354: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1355: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','print_on_invoice');
1356: oe_msg_pub.Add;
1357:
1358: END IF;
1359:
1360: RETURN NULL;

Line 1364: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1360: RETURN NULL;
1361:
1362: WHEN OTHERS THEN
1363:
1364: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1365: THEN
1366: oe_msg_pub.Add_Exc_Msg
1367: ( G_PKG_NAME
1368: , 'Print_On_Invoice'

Line 1366: oe_msg_pub.Add_Exc_Msg

1362: WHEN OTHERS THEN
1363:
1364: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1365: THEN
1366: oe_msg_pub.Add_Exc_Msg
1367: ( G_PKG_NAME
1368: , 'Print_On_Invoice'
1369: );
1370: END IF;

Line 1400: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

1396: EXCEPTION
1397:
1398: WHEN NO_DATA_FOUND THEN
1399:
1400: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
1401: THEN
1402:
1403: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1404: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rebate_subtype');

Line 1405: oe_msg_pub.Add;

1401: THEN
1402:
1403: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1404: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rebate_subtype');
1405: oe_msg_pub.Add;
1406:
1407: END IF;
1408:
1409: RETURN NULL;

Line 1413: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1409: RETURN NULL;
1410:
1411: WHEN OTHERS THEN
1412:
1413: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1414: THEN
1415: oe_msg_pub.Add_Exc_Msg
1416: ( G_PKG_NAME
1417: , 'Rebate_Subtype'

Line 1415: oe_msg_pub.Add_Exc_Msg

1411: WHEN OTHERS THEN
1412:
1413: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1414: THEN
1415: oe_msg_pub.Add_Exc_Msg
1416: ( G_PKG_NAME
1417: , 'Rebate_Subtype'
1418: );
1419: END IF;

Line 1449: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

1445: EXCEPTION
1446:
1447: WHEN NO_DATA_FOUND THEN
1448:
1449: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
1450: THEN
1451:
1452: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1453: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rebate_transaction_type');

Line 1454: oe_msg_pub.Add;

1450: THEN
1451:
1452: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1453: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rebate_transaction_type');
1454: oe_msg_pub.Add;
1455:
1456: END IF;
1457:
1458: RETURN NULL;

Line 1462: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1458: RETURN NULL;
1459:
1460: WHEN OTHERS THEN
1461:
1462: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1463: THEN
1464: oe_msg_pub.Add_Exc_Msg
1465: ( G_PKG_NAME
1466: , 'Rebate_Transaction_Type'

Line 1464: oe_msg_pub.Add_Exc_Msg

1460: WHEN OTHERS THEN
1461:
1462: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1463: THEN
1464: oe_msg_pub.Add_Exc_Msg
1465: ( G_PKG_NAME
1466: , 'Rebate_Transaction_Type'
1467: );
1468: END IF;

Line 1498: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

1494: EXCEPTION
1495:
1496: WHEN NO_DATA_FOUND THEN
1497:
1498: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
1499: THEN
1500:
1501: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1502: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','related_item');

Line 1503: oe_msg_pub.Add;

1499: THEN
1500:
1501: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1502: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','related_item');
1503: oe_msg_pub.Add;
1504:
1505: END IF;
1506:
1507: RETURN NULL;

Line 1511: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1507: RETURN NULL;
1508:
1509: WHEN OTHERS THEN
1510:
1511: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1512: THEN
1513: oe_msg_pub.Add_Exc_Msg
1514: ( G_PKG_NAME
1515: , 'Related_Item'

Line 1513: oe_msg_pub.Add_Exc_Msg

1509: WHEN OTHERS THEN
1510:
1511: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1512: THEN
1513: oe_msg_pub.Add_Exc_Msg
1514: ( G_PKG_NAME
1515: , 'Related_Item'
1516: );
1517: END IF;

Line 1547: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

1543: EXCEPTION
1544:
1545: WHEN NO_DATA_FOUND THEN
1546:
1547: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
1548: THEN
1549:
1550: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1551: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','relationship_type');

Line 1552: oe_msg_pub.Add;

1548: THEN
1549:
1550: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1551: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','relationship_type');
1552: oe_msg_pub.Add;
1553:
1554: END IF;
1555:
1556: RETURN NULL;

Line 1560: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1556: RETURN NULL;
1557:
1558: WHEN OTHERS THEN
1559:
1560: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1561: THEN
1562: oe_msg_pub.Add_Exc_Msg
1563: ( G_PKG_NAME
1564: , 'Relationship_Type'

Line 1562: oe_msg_pub.Add_Exc_Msg

1558: WHEN OTHERS THEN
1559:
1560: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1561: THEN
1562: oe_msg_pub.Add_Exc_Msg
1563: ( G_PKG_NAME
1564: , 'Relationship_Type'
1565: );
1566: END IF;

Line 1596: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

1592: EXCEPTION
1593:
1594: WHEN NO_DATA_FOUND THEN
1595:
1596: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
1597: THEN
1598:
1599: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1600: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reprice');

Line 1601: oe_msg_pub.Add;

1597: THEN
1598:
1599: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1600: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reprice');
1601: oe_msg_pub.Add;
1602:
1603: END IF;
1604:
1605: RETURN NULL;

Line 1609: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1605: RETURN NULL;
1606:
1607: WHEN OTHERS THEN
1608:
1609: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1610: THEN
1611: oe_msg_pub.Add_Exc_Msg
1612: ( G_PKG_NAME
1613: , 'Reprice'

Line 1611: oe_msg_pub.Add_Exc_Msg

1607: WHEN OTHERS THEN
1608:
1609: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1610: THEN
1611: oe_msg_pub.Add_Exc_Msg
1612: ( G_PKG_NAME
1613: , 'Reprice'
1614: );
1615: END IF;

Line 1645: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

1641: EXCEPTION
1642:
1643: WHEN NO_DATA_FOUND THEN
1644:
1645: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
1646: THEN
1647:
1648: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1649: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_reason');

Line 1650: oe_msg_pub.Add;

1646: THEN
1647:
1648: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1649: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_reason');
1650: oe_msg_pub.Add;
1651:
1652: END IF;
1653:
1654: RETURN NULL;

Line 1658: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1654: RETURN NULL;
1655:
1656: WHEN OTHERS THEN
1657:
1658: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1659: THEN
1660: oe_msg_pub.Add_Exc_Msg
1661: ( G_PKG_NAME
1662: , 'Revision_Reason'

Line 1660: oe_msg_pub.Add_Exc_Msg

1656: WHEN OTHERS THEN
1657:
1658: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1659: THEN
1660: oe_msg_pub.Add_Exc_Msg
1661: ( G_PKG_NAME
1662: , 'Revision_Reason'
1663: );
1664: END IF;

Line 1694: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

1690: EXCEPTION
1691:
1692: WHEN NO_DATA_FOUND THEN
1693:
1694: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
1695: THEN
1696:
1697: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1698: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','comparison_operator');

Line 1699: oe_msg_pub.Add;

1695: THEN
1696:
1697: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1698: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','comparison_operator');
1699: oe_msg_pub.Add;
1700:
1701: END IF;
1702:
1703: RETURN NULL;

Line 1707: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1703: RETURN NULL;
1704:
1705: WHEN OTHERS THEN
1706:
1707: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1708: THEN
1709: oe_msg_pub.Add_Exc_Msg
1710: ( G_PKG_NAME
1711: , 'Comparison_Operator'

Line 1709: oe_msg_pub.Add_Exc_Msg

1705: WHEN OTHERS THEN
1706:
1707: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1708: THEN
1709: oe_msg_pub.Add_Exc_Msg
1710: ( G_PKG_NAME
1711: , 'Comparison_Operator'
1712: );
1713: END IF;

Line 1742: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

1738: EXCEPTION
1739:
1740: WHEN NO_DATA_FOUND THEN
1741:
1742: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
1743: THEN
1744:
1745: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1746: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','created_from_rule');

Line 1747: oe_msg_pub.Add;

1743: THEN
1744:
1745: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1746: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','created_from_rule');
1747: oe_msg_pub.Add;
1748:
1749: END IF;
1750:
1751: RETURN NULL;

Line 1755: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1751: RETURN NULL;
1752:
1753: WHEN OTHERS THEN
1754:
1755: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1756: THEN
1757: oe_msg_pub.Add_Exc_Msg
1758: ( G_PKG_NAME
1759: , 'Created_From_Rule'

Line 1757: oe_msg_pub.Add_Exc_Msg

1753: WHEN OTHERS THEN
1754:
1755: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1756: THEN
1757: oe_msg_pub.Add_Exc_Msg
1758: ( G_PKG_NAME
1759: , 'Created_From_Rule'
1760: );
1761: END IF;

Line 1791: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

1787: EXCEPTION
1788:
1789: WHEN NO_DATA_FOUND THEN
1790:
1791: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
1792: THEN
1793:
1794: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1795: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','excluder');

Line 1796: oe_msg_pub.Add;

1792: THEN
1793:
1794: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1795: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','excluder');
1796: oe_msg_pub.Add;
1797:
1798: END IF;
1799:
1800: RETURN NULL;

Line 1804: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1800: RETURN NULL;
1801:
1802: WHEN OTHERS THEN
1803:
1804: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1805: THEN
1806: oe_msg_pub.Add_Exc_Msg
1807: ( G_PKG_NAME
1808: , 'Excluder'

Line 1806: oe_msg_pub.Add_Exc_Msg

1802: WHEN OTHERS THEN
1803:
1804: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1805: THEN
1806: oe_msg_pub.Add_Exc_Msg
1807: ( G_PKG_NAME
1808: , 'Excluder'
1809: );
1810: END IF;

Line 1841: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

1837: EXCEPTION
1838:
1839: WHEN NO_DATA_FOUND THEN
1840:
1841: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
1842: THEN
1843:
1844: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1845: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier');

Line 1846: oe_msg_pub.Add;

1842: THEN
1843:
1844: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1845: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier');
1846: oe_msg_pub.Add;
1847:
1848: END IF;
1849:
1850: RETURN NULL;

Line 1854: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1850: RETURN NULL;
1851:
1852: WHEN OTHERS THEN
1853:
1854: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1855: THEN
1856: oe_msg_pub.Add_Exc_Msg
1857: ( G_PKG_NAME
1858: , 'Qualifier'

Line 1856: oe_msg_pub.Add_Exc_Msg

1852: WHEN OTHERS THEN
1853:
1854: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1855: THEN
1856: oe_msg_pub.Add_Exc_Msg
1857: ( G_PKG_NAME
1858: , 'Qualifier'
1859: );
1860: END IF;

Line 1891: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

1887: EXCEPTION
1888:
1889: WHEN NO_DATA_FOUND THEN
1890:
1891: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
1892: THEN
1893:
1894: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1895: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_rule');

Line 1896: oe_msg_pub.Add;

1892: THEN
1893:
1894: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1895: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_rule');
1896: oe_msg_pub.Add;
1897:
1898: END IF;
1899:
1900: RETURN NULL;

Line 1904: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1900: RETURN NULL;
1901:
1902: WHEN OTHERS THEN
1903:
1904: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1905: THEN
1906: oe_msg_pub.Add_Exc_Msg
1907: ( G_PKG_NAME
1908: , 'Qualifier_Rule'

Line 1906: oe_msg_pub.Add_Exc_Msg

1902: WHEN OTHERS THEN
1903:
1904: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1905: THEN
1906: oe_msg_pub.Add_Exc_Msg
1907: ( G_PKG_NAME
1908: , 'Qualifier_Rule'
1909: );
1910: END IF;

Line 1940: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

1936: EXCEPTION
1937:
1938: WHEN NO_DATA_FOUND THEN
1939:
1940: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
1941: THEN
1942:
1943: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1944: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accumulate');

Line 1945: oe_msg_pub.Add;

1941: THEN
1942:
1943: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1944: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accumulate');
1945: oe_msg_pub.Add;
1946:
1947: END IF;
1948:
1949: RETURN NULL;

Line 1953: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1949: RETURN NULL;
1950:
1951: WHEN OTHERS THEN
1952:
1953: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1954: THEN
1955: oe_msg_pub.Add_Exc_Msg
1956: ( G_PKG_NAME
1957: , 'Accumulate'

Line 1955: oe_msg_pub.Add_Exc_Msg

1951: WHEN OTHERS THEN
1952:
1953: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1954: THEN
1955: oe_msg_pub.Add_Exc_Msg
1956: ( G_PKG_NAME
1957: , 'Accumulate'
1958: );
1959: END IF;

Line 1989: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

1985: EXCEPTION
1986:
1987: WHEN NO_DATA_FOUND THEN
1988:
1989: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
1990: THEN
1991:
1992: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1993: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute');

Line 1994: oe_msg_pub.Add;

1990: THEN
1991:
1992: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
1993: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute');
1994: oe_msg_pub.Add;
1995:
1996: END IF;
1997:
1998: RETURN NULL;

Line 2002: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1998: RETURN NULL;
1999:
2000: WHEN OTHERS THEN
2001:
2002: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2003: THEN
2004: oe_msg_pub.Add_Exc_Msg
2005: ( G_PKG_NAME
2006: , 'Pricing_Attribute'

Line 2004: oe_msg_pub.Add_Exc_Msg

2000: WHEN OTHERS THEN
2001:
2002: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2003: THEN
2004: oe_msg_pub.Add_Exc_Msg
2005: ( G_PKG_NAME
2006: , 'Pricing_Attribute'
2007: );
2008: END IF;

Line 2038: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

2034: EXCEPTION
2035:
2036: WHEN NO_DATA_FOUND THEN
2037:
2038: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2039: THEN
2040:
2041: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
2042: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','product_uom');

Line 2043: oe_msg_pub.Add;

2039: THEN
2040:
2041: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
2042: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','product_uom');
2043: oe_msg_pub.Add;
2044:
2045: END IF;
2046:
2047: RETURN NULL;

Line 2051: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2047: RETURN NULL;
2048:
2049: WHEN OTHERS THEN
2050:
2051: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2052: THEN
2053: oe_msg_pub.Add_Exc_Msg
2054: ( G_PKG_NAME
2055: , 'Product_Uom'

Line 2053: oe_msg_pub.Add_Exc_Msg

2049: WHEN OTHERS THEN
2050:
2051: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2052: THEN
2053: oe_msg_pub.Add_Exc_Msg
2054: ( G_PKG_NAME
2055: , 'Product_Uom'
2056: );
2057: END IF;

Line 2087: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

2083: EXCEPTION
2084:
2085: WHEN NO_DATA_FOUND THEN
2086:
2087: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2088: THEN
2089:
2090: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
2091: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');

Line 2092: oe_msg_pub.Add;

2088: THEN
2089:
2090: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
2091: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');
2092: oe_msg_pub.Add;
2093:
2094: END IF;
2095:
2096: RETURN NULL;

Line 2100: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2096: RETURN NULL;
2097:
2098: WHEN OTHERS THEN
2099:
2100: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2101: THEN
2102: oe_msg_pub.Add_Exc_Msg
2103: ( G_PKG_NAME
2104: , 'Header'

Line 2102: oe_msg_pub.Add_Exc_Msg

2098: WHEN OTHERS THEN
2099:
2100: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2101: THEN
2102: oe_msg_pub.Add_Exc_Msg
2103: ( G_PKG_NAME
2104: , 'Header'
2105: );
2106: END IF;

Line 2136: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

2132: EXCEPTION
2133:
2134: WHEN NO_DATA_FOUND THEN
2135:
2136: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2137: THEN
2138:
2139: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
2140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line');

Line 2141: oe_msg_pub.Add;

2137: THEN
2138:
2139: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
2140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line');
2141: oe_msg_pub.Add;
2142:
2143: END IF;
2144:
2145: RETURN NULL;

Line 2149: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2145: RETURN NULL;
2146:
2147: WHEN OTHERS THEN
2148:
2149: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2150: THEN
2151: oe_msg_pub.Add_Exc_Msg
2152: ( G_PKG_NAME
2153: , 'Line'

Line 2151: oe_msg_pub.Add_Exc_Msg

2147: WHEN OTHERS THEN
2148:
2149: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2150: THEN
2151: oe_msg_pub.Add_Exc_Msg
2152: ( G_PKG_NAME
2153: , 'Line'
2154: );
2155: END IF;

Line 2185: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

2181: EXCEPTION
2182:
2183: WHEN NO_DATA_FOUND THEN
2184:
2185: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2186: THEN
2187:
2188: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
2189: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_price_attrib');

Line 2190: oe_msg_pub.Add;

2186: THEN
2187:
2188: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
2189: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_price_attrib');
2190: oe_msg_pub.Add;
2191:
2192: END IF;
2193:
2194: RETURN NULL;

Line 2198: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2194: RETURN NULL;
2195:
2196: WHEN OTHERS THEN
2197:
2198: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2199: THEN
2200: oe_msg_pub.Add_Exc_Msg
2201: ( G_PKG_NAME
2202: , 'Order_Price_Attrib'

Line 2200: oe_msg_pub.Add_Exc_Msg

2196: WHEN OTHERS THEN
2197:
2198: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2199: THEN
2200: oe_msg_pub.Add_Exc_Msg
2201: ( G_PKG_NAME
2202: , 'Order_Price_Attrib'
2203: );
2204: END IF;

Line 2237: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

2233: EXCEPTION
2234:
2235: WHEN NO_DATA_FOUND THEN
2236:
2237: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2238: THEN
2239:
2240: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
2241: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula');

Line 2242: oe_msg_pub.Add;

2238: THEN
2239:
2240: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
2241: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula');
2242: oe_msg_pub.Add;
2243:
2244: END IF;
2245:
2246: RETURN NULL;

Line 2250: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2246: RETURN NULL;
2247:
2248: WHEN OTHERS THEN
2249:
2250: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2251: THEN
2252: oe_msg_pub.Add_Exc_Msg
2253: ( G_PKG_NAME
2254: , 'Price_Formula'

Line 2252: oe_msg_pub.Add_Exc_Msg

2248: WHEN OTHERS THEN
2249:
2250: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2251: THEN
2252: oe_msg_pub.Add_Exc_Msg
2253: ( G_PKG_NAME
2254: , 'Price_Formula'
2255: );
2256: END IF;

Line 2286: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

2282: EXCEPTION
2283:
2284: WHEN NO_DATA_FOUND THEN
2285:
2286: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2287: THEN
2288:
2289: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
2290: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula_line');

Line 2291: oe_msg_pub.Add;

2287: THEN
2288:
2289: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
2290: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula_line');
2291: oe_msg_pub.Add;
2292:
2293: END IF;
2294:
2295: RETURN NULL;

Line 2299: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2295: RETURN NULL;
2296:
2297: WHEN OTHERS THEN
2298:
2299: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2300: THEN
2301: oe_msg_pub.Add_Exc_Msg
2302: ( G_PKG_NAME
2303: , 'Price_Formula_Line'

Line 2301: oe_msg_pub.Add_Exc_Msg

2297: WHEN OTHERS THEN
2298:
2299: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2300: THEN
2301: oe_msg_pub.Add_Exc_Msg
2302: ( G_PKG_NAME
2303: , 'Price_Formula_Line'
2304: );
2305: END IF;

Line 2334: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

2330: EXCEPTION
2331:
2332: WHEN NO_DATA_FOUND THEN
2333:
2334: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2335: THEN
2336:
2337: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
2338: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula_line_type');

Line 2339: oe_msg_pub.Add;

2335: THEN
2336:
2337: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
2338: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula_line_type');
2339: oe_msg_pub.Add;
2340:
2341: END IF;
2342:
2343: RETURN NULL;

Line 2347: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2343: RETURN NULL;
2344:
2345: WHEN OTHERS THEN
2346:
2347: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2348: THEN
2349: oe_msg_pub.Add_Exc_Msg
2350: ( G_PKG_NAME
2351: , 'Price_Formula_Line_Type'

Line 2349: oe_msg_pub.Add_Exc_Msg

2345: WHEN OTHERS THEN
2346:
2347: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2348: THEN
2349: oe_msg_pub.Add_Exc_Msg
2350: ( G_PKG_NAME
2351: , 'Price_Formula_Line_Type'
2352: );
2353: END IF;

Line 2383: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

2379: EXCEPTION
2380:
2381: WHEN NO_DATA_FOUND THEN
2382:
2383: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2384: THEN
2385:
2386: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
2387: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_line');

Line 2388: oe_msg_pub.Add;

2384: THEN
2385:
2386: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
2387: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_line');
2388: oe_msg_pub.Add;
2389:
2390: END IF;
2391:
2392: RETURN NULL;

Line 2396: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2392: RETURN NULL;
2393:
2394: WHEN OTHERS THEN
2395:
2396: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2397: THEN
2398: oe_msg_pub.Add_Exc_Msg
2399: ( G_PKG_NAME
2400: , 'Price_List_Line'

Line 2398: oe_msg_pub.Add_Exc_Msg

2394: WHEN OTHERS THEN
2395:
2396: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2397: THEN
2398: oe_msg_pub.Add_Exc_Msg
2399: ( G_PKG_NAME
2400: , 'Price_List_Line'
2401: );
2402: END IF;

Line 2431: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

2427: EXCEPTION
2428:
2429: WHEN NO_DATA_FOUND THEN
2430:
2431: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2432: THEN
2433:
2434: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
2435: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','arithmetic_operator');

Line 2436: oe_msg_pub.Add;

2432: THEN
2433:
2434: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
2435: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','arithmetic_operator');
2436: oe_msg_pub.Add;
2437:
2438: END IF;
2439:
2440: RETURN NULL;

Line 2444: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2440: RETURN NULL;
2441:
2442: WHEN OTHERS THEN
2443:
2444: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2445: THEN
2446: oe_msg_pub.Add_Exc_Msg
2447: ( G_PKG_NAME
2448: , 'Arithmetic_Operator'

Line 2446: oe_msg_pub.Add_Exc_Msg

2442: WHEN OTHERS THEN
2443:
2444: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2445: THEN
2446: oe_msg_pub.Add_Exc_Msg
2447: ( G_PKG_NAME
2448: , 'Arithmetic_Operator'
2449: );
2450: END IF;

Line 2480: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

2476: EXCEPTION
2477:
2478: WHEN NO_DATA_FOUND THEN
2479:
2480: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2481: THEN
2482:
2483: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
2484: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_modifier_list');

Line 2485: oe_msg_pub.Add;

2481: THEN
2482:
2483: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
2484: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_modifier_list');
2485: oe_msg_pub.Add;
2486:
2487: END IF;
2488:
2489: RETURN NULL;

Line 2493: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2489: RETURN NULL;
2490:
2491: WHEN OTHERS THEN
2492:
2493: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2494: THEN
2495: oe_msg_pub.Add_Exc_Msg
2496: ( G_PKG_NAME
2497: , 'Price_Modifier_List'

Line 2495: oe_msg_pub.Add_Exc_Msg

2491: WHEN OTHERS THEN
2492:
2493: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2494: THEN
2495: oe_msg_pub.Add_Exc_Msg
2496: ( G_PKG_NAME
2497: , 'Price_Modifier_List'
2498: );
2499: END IF;

Line 2530: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2526: EXCEPTION
2527:
2528: WHEN NO_DATA_FOUND THEN
2529:
2530: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2531: THEN
2532:
2533: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
2534: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');

Line 2535: OE_MSG_PUB.Add;

2531: THEN
2532:
2533: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
2534: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');
2535: OE_MSG_PUB.Add;
2536:
2537: END IF;
2538:
2539: RETURN NULL;

Line 2543: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2539: RETURN NULL;
2540:
2541: WHEN OTHERS THEN
2542:
2543: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2544: THEN
2545: OE_MSG_PUB.Add_Exc_Msg
2546: ( G_PKG_NAME
2547: , 'Accounting_Rule'

Line 2545: OE_MSG_PUB.Add_Exc_Msg

2541: WHEN OTHERS THEN
2542:
2543: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2544: THEN
2545: OE_MSG_PUB.Add_Exc_Msg
2546: ( G_PKG_NAME
2547: , 'Accounting_Rule'
2548: );
2549: END IF;

Line 2581: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2577: EXCEPTION
2578:
2579: WHEN NO_DATA_FOUND THEN
2580:
2581: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2582: THEN
2583:
2584: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
2585: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');

Line 2586: OE_MSG_PUB.Add;

2582: THEN
2583:
2584: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
2585: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
2586: OE_MSG_PUB.Add;
2587:
2588: END IF;
2589:
2590: RETURN NULL;

Line 2594: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2590: RETURN NULL;
2591:
2592: WHEN OTHERS THEN
2593:
2594: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2595: THEN
2596: OE_MSG_PUB.Add_Exc_Msg
2597: ( G_PKG_NAME
2598: , 'Agreement'

Line 2596: OE_MSG_PUB.Add_Exc_Msg

2592: WHEN OTHERS THEN
2593:
2594: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2595: THEN
2596: OE_MSG_PUB.Add_Exc_Msg
2597: ( G_PKG_NAME
2598: , 'Agreement'
2599: );
2600: END IF;

Line 2632: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2628: EXCEPTION
2629:
2630: WHEN NO_DATA_FOUND THEN
2631:
2632: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2633: THEN
2634:
2635: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
2636: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');

Line 2637: OE_MSG_PUB.Add;

2633: THEN
2634:
2635: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
2636: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
2637: OE_MSG_PUB.Add;
2638:
2639: END IF;
2640:
2641: RETURN NULL;

Line 2645: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2641: RETURN NULL;
2642:
2643: WHEN OTHERS THEN
2644:
2645: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2646: THEN
2647: OE_MSG_PUB.Add_Exc_Msg
2648: ( G_PKG_NAME
2649: , 'Freight_Terms'

Line 2647: OE_MSG_PUB.Add_Exc_Msg

2643: WHEN OTHERS THEN
2644:
2645: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2646: THEN
2647: OE_MSG_PUB.Add_Exc_Msg
2648: ( G_PKG_NAME
2649: , 'Freight_Terms'
2650: );
2651: END IF;

Line 2680: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2676: EXCEPTION
2677:
2678: WHEN NO_DATA_FOUND THEN
2679:
2680: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2681: THEN
2682:
2683: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
2684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');

Line 2685: OE_MSG_PUB.Add;

2681: THEN
2682:
2683: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
2684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');
2685: OE_MSG_PUB.Add;
2686:
2687: END IF;
2688:
2689: RETURN NULL;

Line 2693: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2689: RETURN NULL;
2690:
2691: WHEN OTHERS THEN
2692:
2693: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2694: THEN
2695: OE_MSG_PUB.Add_Exc_Msg
2696: ( G_PKG_NAME
2697: , 'Invoice_To_Contact'

Line 2695: OE_MSG_PUB.Add_Exc_Msg

2691: WHEN OTHERS THEN
2692:
2693: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2694: THEN
2695: OE_MSG_PUB.Add_Exc_Msg
2696: ( G_PKG_NAME
2697: , 'Invoice_To_Contact'
2698: );
2699: END IF;

Line 2729: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2725: EXCEPTION
2726:
2727: WHEN NO_DATA_FOUND THEN
2728:
2729: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2730: THEN
2731:
2732: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
2733: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');

Line 2734: OE_MSG_PUB.Add;

2730: THEN
2731:
2732: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
2733: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');
2734: OE_MSG_PUB.Add;
2735:
2736: END IF;
2737:
2738: RETURN NULL;

Line 2742: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2738: RETURN NULL;
2739:
2740: WHEN OTHERS THEN
2741:
2742: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2743: THEN
2744: OE_MSG_PUB.Add_Exc_Msg
2745: ( G_PKG_NAME
2746: , 'Invoicing_Rule'

Line 2744: OE_MSG_PUB.Add_Exc_Msg

2740: WHEN OTHERS THEN
2741:
2742: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2743: THEN
2744: OE_MSG_PUB.Add_Exc_Msg
2745: ( G_PKG_NAME
2746: , 'Invoicing_Rule'
2747: );
2748: END IF;

Line 2779: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2775: EXCEPTION
2776:
2777: WHEN NO_DATA_FOUND THEN
2778:
2779: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2780: THEN
2781:
2782: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
2783: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term');

Line 2784: OE_MSG_PUB.Add;

2780: THEN
2781:
2782: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
2783: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term');
2784: OE_MSG_PUB.Add;
2785:
2786: END IF;
2787:
2788: RETURN NULL;

Line 2792: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2788: RETURN NULL;
2789:
2790: WHEN OTHERS THEN
2791:
2792: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2793: THEN
2794: OE_MSG_PUB.Add_Exc_Msg
2795: ( G_PKG_NAME
2796: , 'Payment_Term'

Line 2794: OE_MSG_PUB.Add_Exc_Msg

2790: WHEN OTHERS THEN
2791:
2792: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2793: THEN
2794: OE_MSG_PUB.Add_Exc_Msg
2795: ( G_PKG_NAME
2796: , 'Payment_Term'
2797: );
2798: END IF;

Line 2828: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2824: EXCEPTION
2825:
2826: WHEN NO_DATA_FOUND THEN
2827:
2828: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2829: THEN
2830:
2831: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
2832: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');

Line 2833: OE_MSG_PUB.Add;

2829: THEN
2830:
2831: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
2832: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
2833: OE_MSG_PUB.Add;
2834:
2835: END IF;
2836:
2837: RETURN NULL;

Line 2841: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2837: RETURN NULL;
2838:
2839: WHEN OTHERS THEN
2840:
2841: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2842: THEN
2843: OE_MSG_PUB.Add_Exc_Msg
2844: ( G_PKG_NAME
2845: , 'Price_List'

Line 2843: OE_MSG_PUB.Add_Exc_Msg

2839: WHEN OTHERS THEN
2840:
2841: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2842: THEN
2843: OE_MSG_PUB.Add_Exc_Msg
2844: ( G_PKG_NAME
2845: , 'Price_List'
2846: );
2847: END IF;

Line 2878: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2874: EXCEPTION
2875:
2876: WHEN NO_DATA_FOUND THEN
2877:
2878: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2879: THEN
2880:
2881: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
2882: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');

Line 2883: OE_MSG_PUB.Add;

2879: THEN
2880:
2881: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
2882: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
2883: OE_MSG_PUB.Add;
2884:
2885: END IF;
2886:
2887: RETURN NULL;

Line 2891: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2887: RETURN NULL;
2888:
2889: WHEN OTHERS THEN
2890:
2891: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2892: THEN
2893: OE_MSG_PUB.Add_Exc_Msg
2894: ( G_PKG_NAME
2895: , 'Salesrep'

Line 2893: OE_MSG_PUB.Add_Exc_Msg

2889: WHEN OTHERS THEN
2890:
2891: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2892: THEN
2893: OE_MSG_PUB.Add_Exc_Msg
2894: ( G_PKG_NAME
2895: , 'Salesrep'
2896: );
2897: END IF;

Line 2928: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2924: EXCEPTION
2925:
2926: WHEN NO_DATA_FOUND THEN
2927:
2928: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2929: THEN
2930:
2931: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
2932: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_contact');

Line 2933: OE_MSG_PUB.Add;

2929: THEN
2930:
2931: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
2932: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_contact');
2933: OE_MSG_PUB.Add;
2934:
2935: END IF;
2936:
2937: RETURN NULL;

Line 2941: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2937: RETURN NULL;
2938:
2939: WHEN OTHERS THEN
2940:
2941: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2942: THEN
2943: OE_MSG_PUB.Add_Exc_Msg
2944: ( G_PKG_NAME
2945: , 'Agreement_Contact'

Line 2943: OE_MSG_PUB.Add_Exc_Msg

2939: WHEN OTHERS THEN
2940:
2941: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2942: THEN
2943: OE_MSG_PUB.Add_Exc_Msg
2944: ( G_PKG_NAME
2945: , 'Agreement_Contact'
2946: );
2947: END IF;

Line 2979: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2975: EXCEPTION
2976:
2977: WHEN NO_DATA_FOUND THEN
2978:
2979: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2980: THEN
2981:
2982: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
2983: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_type');

Line 2984: OE_MSG_PUB.Add;

2980: THEN
2981:
2982: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
2983: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_type');
2984: OE_MSG_PUB.Add;
2985:
2986: END IF;
2987:
2988: RETURN NULL;

Line 2992: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2988: RETURN NULL;
2989:
2990: WHEN OTHERS THEN
2991:
2992: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2993: THEN
2994: OE_MSG_PUB.Add_Exc_Msg
2995: ( G_PKG_NAME
2996: , 'Agreement_Type'

Line 2994: OE_MSG_PUB.Add_Exc_Msg

2990: WHEN OTHERS THEN
2991:
2992: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2993: THEN
2994: OE_MSG_PUB.Add_Exc_Msg
2995: ( G_PKG_NAME
2996: , 'Agreement_Type'
2997: );
2998: END IF;

Line 3031: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3027: EXCEPTION
3028:
3029: WHEN NO_DATA_FOUND THEN
3030:
3031: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3032: THEN
3033:
3034: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
3035: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_contact');

Line 3036: OE_MSG_PUB.Add;

3032: THEN
3033:
3034: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
3035: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_contact');
3036: OE_MSG_PUB.Add;
3037:
3038: END IF;
3039:
3040: RETURN NULL;

Line 3044: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3040: RETURN NULL;
3041:
3042: WHEN OTHERS THEN
3043:
3044: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3045: THEN
3046: OE_MSG_PUB.Add_Exc_Msg
3047: ( G_PKG_NAME
3048: , 'Invoice_Contact'

Line 3046: OE_MSG_PUB.Add_Exc_Msg

3042: WHEN OTHERS THEN
3043:
3044: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3045: THEN
3046: OE_MSG_PUB.Add_Exc_Msg
3047: ( G_PKG_NAME
3048: , 'Invoice_Contact'
3049: );
3050: END IF;

Line 3083: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3079: EXCEPTION
3080:
3081: WHEN NO_DATA_FOUND THEN
3082:
3083: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3084: THEN
3085:
3086: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
3087: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_site_use');

Line 3088: OE_MSG_PUB.Add;

3084: THEN
3085:
3086: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
3087: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_site_use');
3088: OE_MSG_PUB.Add;
3089:
3090: END IF;
3091:
3092: RETURN NULL;

Line 3096: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3092: RETURN NULL;
3093:
3094: WHEN OTHERS THEN
3095:
3096: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3097: THEN
3098: OE_MSG_PUB.Add_Exc_Msg
3099: ( G_PKG_NAME
3100: , 'Invoice_To_Site_Use'

Line 3098: OE_MSG_PUB.Add_Exc_Msg

3094: WHEN OTHERS THEN
3095:
3096: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3097: THEN
3098: OE_MSG_PUB.Add_Exc_Msg
3099: ( G_PKG_NAME
3100: , 'Invoice_To_Site_Use'
3101: );
3102: END IF;

Line 3133: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3129: EXCEPTION
3130:
3131: WHEN NO_DATA_FOUND THEN
3132:
3133: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3134: THEN
3135:
3136: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
3137: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_arule');

Line 3138: OE_MSG_PUB.Add;

3134: THEN
3135:
3136: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
3137: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_arule');
3138: OE_MSG_PUB.Add;
3139:
3140: END IF;
3141:
3142: RETURN NULL;

Line 3146: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3142: RETURN NULL;
3143:
3144: WHEN OTHERS THEN
3145:
3146: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3147: THEN
3148: OE_MSG_PUB.Add_Exc_Msg
3149: ( G_PKG_NAME
3150: , 'Override_Arule'

Line 3148: OE_MSG_PUB.Add_Exc_Msg

3144: WHEN OTHERS THEN
3145:
3146: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3147: THEN
3148: OE_MSG_PUB.Add_Exc_Msg
3149: ( G_PKG_NAME
3150: , 'Override_Arule'
3151: );
3152: END IF;

Line 3185: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3181: EXCEPTION
3182:
3183: WHEN NO_DATA_FOUND THEN
3184:
3185: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3186: THEN
3187:
3188: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
3189: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_irule');

Line 3190: OE_MSG_PUB.Add;

3186: THEN
3187:
3188: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
3189: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_irule');
3190: OE_MSG_PUB.Add;
3191:
3192: END IF;
3193:
3194: RETURN NULL;

Line 3198: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3194: RETURN NULL;
3195:
3196: WHEN OTHERS THEN
3197:
3198: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3199: THEN
3200: OE_MSG_PUB.Add_Exc_Msg
3201: ( G_PKG_NAME
3202: , 'Override_Irule'

Line 3200: OE_MSG_PUB.Add_Exc_Msg

3196: WHEN OTHERS THEN
3197:
3198: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3199: THEN
3200: OE_MSG_PUB.Add_Exc_Msg
3201: ( G_PKG_NAME
3202: , 'Override_Irule'
3203: );
3204: END IF;

Line 3235: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3231: EXCEPTION
3232:
3233: WHEN NO_DATA_FOUND THEN
3234:
3235: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3236: THEN
3237:
3238: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
3239: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_reason');

Line 3240: OE_MSG_PUB.Add;

3236: THEN
3237:
3238: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
3239: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_reason');
3240: OE_MSG_PUB.Add;
3241:
3242: END IF;
3243:
3244: RETURN NULL;

Line 3248: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3244: RETURN NULL;
3245:
3246: WHEN OTHERS THEN
3247:
3248: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3249: THEN
3250: OE_MSG_PUB.Add_Exc_Msg
3251: ( G_PKG_NAME
3252: , 'Revision_Reason'

Line 3250: OE_MSG_PUB.Add_Exc_Msg

3246: WHEN OTHERS THEN
3247:
3248: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3249: THEN
3250: OE_MSG_PUB.Add_Exc_Msg
3251: ( G_PKG_NAME
3252: , 'Revision_Reason'
3253: );
3254: END IF;

Line 3285: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3281: EXCEPTION
3282:
3283: WHEN NO_DATA_FOUND THEN
3284:
3285: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3286: THEN
3287:
3288: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
3289: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_method');

Line 3290: OE_MSG_PUB.Add;

3286: THEN
3287:
3288: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
3289: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_method');
3290: OE_MSG_PUB.Add;
3291:
3292: END IF;
3293:
3294: RETURN NULL;

Line 3298: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3294: RETURN NULL;
3295:
3296: WHEN OTHERS THEN
3297:
3298: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3299: THEN
3300: OE_MSG_PUB.Add_Exc_Msg
3301: ( G_PKG_NAME
3302: , 'Ship_Method'

Line 3300: OE_MSG_PUB.Add_Exc_Msg

3296: WHEN OTHERS THEN
3297:
3298: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3299: THEN
3300: OE_MSG_PUB.Add_Exc_Msg
3301: ( G_PKG_NAME
3302: , 'Ship_Method'
3303: );
3304: END IF;

Line 3335: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3331: EXCEPTION
3332:
3333: WHEN NO_DATA_FOUND THEN
3334:
3335: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3336: THEN
3337:
3338: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
3339: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_source');

Line 3340: OE_MSG_PUB.Add;

3336: THEN
3337:
3338: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
3339: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_source');
3340: OE_MSG_PUB.Add;
3341:
3342: END IF;
3343:
3344: RETURN NULL;

Line 3348: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3344: RETURN NULL;
3345:
3346: WHEN OTHERS THEN
3347:
3348: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3349: THEN
3350: OE_MSG_PUB.Add_Exc_Msg
3351: ( G_PKG_NAME
3352: , 'Agreement_Source'

Line 3350: OE_MSG_PUB.Add_Exc_Msg

3346: WHEN OTHERS THEN
3347:
3348: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3349: THEN
3350: OE_MSG_PUB.Add_Exc_Msg
3351: ( G_PKG_NAME
3352: , 'Agreement_Source'
3353: );
3354: END IF;

Line 3386: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3382: EXCEPTION
3383:
3384: WHEN NO_DATA_FOUND THEN
3385:
3386: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3387: THEN
3388:
3389: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
3390: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','term');

Line 3391: OE_MSG_PUB.Add;

3387: THEN
3388:
3389: fnd_message.set_name('QP','QP_ID_TO_VALUE_ERROR');
3390: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','term');
3391: OE_MSG_PUB.Add;
3392:
3393: END IF;
3394:
3395: RETURN NULL;

Line 3399: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3395: RETURN NULL;
3396:
3397: WHEN OTHERS THEN
3398:
3399: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3400: THEN
3401: OE_MSG_PUB.Add_Exc_Msg
3402: ( G_PKG_NAME
3403: , 'Term'

Line 3401: OE_MSG_PUB.Add_Exc_Msg

3397: WHEN OTHERS THEN
3398:
3399: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3400: THEN
3401: OE_MSG_PUB.Add_Exc_Msg
3402: ( G_PKG_NAME
3403: , 'Term'
3404: );
3405: END IF;

Line 3435: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3431: EXCEPTION
3432:
3433: WHEN NO_DATA_FOUND THEN
3434:
3435: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3436: THEN
3437:
3438: fnd_message.set_name('QP','QP_ID_TO__VALUE_ERROR');
3439: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','customer');

Line 3440: OE_MSG_PUB.Add;

3436: THEN
3437:
3438: fnd_message.set_name('QP','QP_ID_TO__VALUE_ERROR');
3439: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','customer');
3440: OE_MSG_PUB.Add;
3441:
3442: END IF;
3443:
3444: RETURN NULL;

Line 3448: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3444: RETURN NULL;
3445:
3446: WHEN OTHERS THEN
3447:
3448: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3449: THEN
3450: OE_MSG_PUB.Add_Exc_Msg
3451: ( G_PKG_NAME
3452: , 'Customer'

Line 3450: OE_MSG_PUB.Add_Exc_Msg

3446: WHEN OTHERS THEN
3447:
3448: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3449: THEN
3450: OE_MSG_PUB.Add_Exc_Msg
3451: ( G_PKG_NAME
3452: , 'Customer'
3453: );
3454: END IF;

Line 3486: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3482: EXCEPTION
3483:
3484: WHEN NO_DATA_FOUND THEN
3485:
3486: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3487: THEN
3488:
3489: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
3490: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_exceed_action');

Line 3491: OE_MSG_PUB.Add;

3487: THEN
3488:
3489: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
3490: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_exceed_action');
3491: OE_MSG_PUB.Add;
3492:
3493: END IF;
3494:
3495: RETURN NULL;

Line 3499: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3495: RETURN NULL;
3496:
3497: WHEN OTHERS THEN
3498:
3499: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3500: THEN
3501: OE_MSG_PUB.Add_Exc_Msg
3502: ( G_PKG_NAME
3503: , 'Limit_Exceed_Action'

Line 3501: OE_MSG_PUB.Add_Exc_Msg

3497: WHEN OTHERS THEN
3498:
3499: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3500: THEN
3501: OE_MSG_PUB.Add_Exc_Msg
3502: ( G_PKG_NAME
3503: , 'Limit_Exceed_Action'
3504: );
3505: END IF;

Line 3535: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3531: EXCEPTION
3532:
3533: WHEN NO_DATA_FOUND THEN
3534:
3535: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3536: THEN
3537:
3538: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
3539: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit');

Line 3540: OE_MSG_PUB.Add;

3536: THEN
3537:
3538: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
3539: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit');
3540: OE_MSG_PUB.Add;
3541:
3542: END IF;
3543:
3544: RETURN NULL;

Line 3548: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3544: RETURN NULL;
3545:
3546: WHEN OTHERS THEN
3547:
3548: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3549: THEN
3550: OE_MSG_PUB.Add_Exc_Msg
3551: ( G_PKG_NAME
3552: , 'Limit'

Line 3550: OE_MSG_PUB.Add_Exc_Msg

3546: WHEN OTHERS THEN
3547:
3548: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3549: THEN
3550: OE_MSG_PUB.Add_Exc_Msg
3551: ( G_PKG_NAME
3552: , 'Limit'
3553: );
3554: END IF;

Line 3584: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3580: EXCEPTION
3581:
3582: WHEN NO_DATA_FOUND THEN
3583:
3584: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3585: THEN
3586:
3587: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
3588: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_level');

Line 3589: OE_MSG_PUB.Add;

3585: THEN
3586:
3587: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
3588: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_level');
3589: OE_MSG_PUB.Add;
3590:
3591: END IF;
3592:
3593: RETURN NULL;

Line 3597: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3593: RETURN NULL;
3594:
3595: WHEN OTHERS THEN
3596:
3597: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3598: THEN
3599: OE_MSG_PUB.Add_Exc_Msg
3600: ( G_PKG_NAME
3601: , 'Limit_Level'

Line 3599: OE_MSG_PUB.Add_Exc_Msg

3595: WHEN OTHERS THEN
3596:
3597: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3598: THEN
3599: OE_MSG_PUB.Add_Exc_Msg
3600: ( G_PKG_NAME
3601: , 'Limit_Level'
3602: );
3603: END IF;

Line 3633: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3629: EXCEPTION
3630:
3631: WHEN NO_DATA_FOUND THEN
3632:
3633: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3634: THEN
3635:
3636: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
3637: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','comparison_operator');

Line 3638: OE_MSG_PUB.Add;

3634: THEN
3635:
3636: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
3637: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','comparison_operator');
3638: OE_MSG_PUB.Add;
3639:
3640: END IF;
3641:
3642: RETURN NULL;

Line 3646: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3642: RETURN NULL;
3643:
3644: WHEN OTHERS THEN
3645:
3646: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3647: THEN
3648: OE_MSG_PUB.Add_Exc_Msg
3649: ( G_PKG_NAME
3650: , 'Comparison_Operator'

Line 3648: OE_MSG_PUB.Add_Exc_Msg

3644: WHEN OTHERS THEN
3645:
3646: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3647: THEN
3648: OE_MSG_PUB.Add_Exc_Msg
3649: ( G_PKG_NAME
3650: , 'Comparison_Operator'
3651: );
3652: END IF;

Line 3682: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3678: EXCEPTION
3679:
3680: WHEN NO_DATA_FOUND THEN
3681:
3682: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3683: THEN
3684:
3685: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
3686: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_attribute');

Line 3687: OE_MSG_PUB.Add;

3683: THEN
3684:
3685: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
3686: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_attribute');
3687: OE_MSG_PUB.Add;
3688:
3689: END IF;
3690:
3691: RETURN NULL;

Line 3695: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3691: RETURN NULL;
3692:
3693: WHEN OTHERS THEN
3694:
3695: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3696: THEN
3697: OE_MSG_PUB.Add_Exc_Msg
3698: ( G_PKG_NAME
3699: , 'Limit_Attribute'

Line 3697: OE_MSG_PUB.Add_Exc_Msg

3693: WHEN OTHERS THEN
3694:
3695: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3696: THEN
3697: OE_MSG_PUB.Add_Exc_Msg
3698: ( G_PKG_NAME
3699: , 'Limit_Attribute'
3700: );
3701: END IF;

Line 3731: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3727: EXCEPTION
3728:
3729: WHEN NO_DATA_FOUND THEN
3730:
3731: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3732: THEN
3733:
3734: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
3735: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_balance');

Line 3736: OE_MSG_PUB.Add;

3732: THEN
3733:
3734: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
3735: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_balance');
3736: OE_MSG_PUB.Add;
3737:
3738: END IF;
3739:
3740: RETURN NULL;

Line 3744: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3740: RETURN NULL;
3741:
3742: WHEN OTHERS THEN
3743:
3744: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3745: THEN
3746: OE_MSG_PUB.Add_Exc_Msg
3747: ( G_PKG_NAME
3748: , 'Limit_Balance'

Line 3746: OE_MSG_PUB.Add_Exc_Msg

3742: WHEN OTHERS THEN
3743:
3744: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3745: THEN
3746: OE_MSG_PUB.Add_Exc_Msg
3747: ( G_PKG_NAME
3748: , 'Limit_Balance'
3749: );
3750: END IF;

Line 3780: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3776: EXCEPTION
3777:
3778: WHEN NO_DATA_FOUND THEN
3779:
3780: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3781: THEN
3782:
3783: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
3784: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_currency');

Line 3785: OE_MSG_PUB.Add;

3781: THEN
3782:
3783: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
3784: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_currency');
3785: OE_MSG_PUB.Add;
3786:
3787: END IF;
3788:
3789: RETURN NULL;

Line 3793: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3789: RETURN NULL;
3790:
3791: WHEN OTHERS THEN
3792:
3793: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3794: THEN
3795: OE_MSG_PUB.Add_Exc_Msg
3796: ( G_PKG_NAME
3797: , 'Base_Currency'

Line 3795: OE_MSG_PUB.Add_Exc_Msg

3791: WHEN OTHERS THEN
3792:
3793: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3794: THEN
3795: OE_MSG_PUB.Add_Exc_Msg
3796: ( G_PKG_NAME
3797: , 'Base_Currency'
3798: );
3799: END IF;

Line 3829: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3825: EXCEPTION
3826:
3827: WHEN NO_DATA_FOUND THEN
3828:
3829: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3830: THEN
3831:
3832: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
3833: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_header');

Line 3834: OE_MSG_PUB.Add;

3830: THEN
3831:
3832: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
3833: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_header');
3834: OE_MSG_PUB.Add;
3835:
3836: END IF;
3837:
3838: RETURN NULL;

Line 3842: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3838: RETURN NULL;
3839:
3840: WHEN OTHERS THEN
3841:
3842: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3843: THEN
3844: OE_MSG_PUB.Add_Exc_Msg
3845: ( G_PKG_NAME
3846: , 'Currency_Header'

Line 3844: OE_MSG_PUB.Add_Exc_Msg

3840: WHEN OTHERS THEN
3841:
3842: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3843: THEN
3844: OE_MSG_PUB.Add_Exc_Msg
3845: ( G_PKG_NAME
3846: , 'Currency_Header'
3847: );
3848: END IF;

Line 3879: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3875: EXCEPTION
3876:
3877: WHEN NO_DATA_FOUND THEN
3878:
3879: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3880: THEN
3881:
3882: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
3883: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_markup_formula');

Line 3884: OE_MSG_PUB.Add;

3880: THEN
3881:
3882: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
3883: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_markup_formula');
3884: OE_MSG_PUB.Add;
3885:
3886: END IF;
3887:
3888: RETURN NULL;

Line 3892: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3888: RETURN NULL;
3889:
3890: WHEN OTHERS THEN
3891:
3892: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3893: THEN
3894: OE_MSG_PUB.Add_Exc_Msg
3895: ( G_PKG_NAME
3896: , 'base_Markup_Formula'

Line 3894: OE_MSG_PUB.Add_Exc_Msg

3890: WHEN OTHERS THEN
3891:
3892: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3893: THEN
3894: OE_MSG_PUB.Add_Exc_Msg
3895: ( G_PKG_NAME
3896: , 'base_Markup_Formula'
3897: );
3898: END IF;

Line 3930: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3926: EXCEPTION
3927:
3928: WHEN NO_DATA_FOUND THEN
3929:
3930: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3931: THEN
3932:
3933: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
3934: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','row');

Line 3935: OE_MSG_PUB.Add;

3931: THEN
3932:
3933: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
3934: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','row');
3935: OE_MSG_PUB.Add;
3936:
3937: END IF;
3938:
3939: RETURN NULL;

Line 3943: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3939: RETURN NULL;
3940:
3941: WHEN OTHERS THEN
3942:
3943: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3944: THEN
3945: OE_MSG_PUB.Add_Exc_Msg
3946: ( G_PKG_NAME
3947: , 'Row'

Line 3945: OE_MSG_PUB.Add_Exc_Msg

3941: WHEN OTHERS THEN
3942:
3943: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3944: THEN
3945: OE_MSG_PUB.Add_Exc_Msg
3946: ( G_PKG_NAME
3947: , 'Row'
3948: );
3949: END IF;

Line 3979: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3975: EXCEPTION
3976:
3977: WHEN NO_DATA_FOUND THEN
3978:
3979: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3980: THEN
3981:
3982: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
3983: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_detail');

Line 3984: OE_MSG_PUB.Add;

3980: THEN
3981:
3982: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
3983: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_detail');
3984: OE_MSG_PUB.Add;
3985:
3986: END IF;
3987:
3988: RETURN NULL;

Line 3992: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3988: RETURN NULL;
3989:
3990: WHEN OTHERS THEN
3991:
3992: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3993: THEN
3994: OE_MSG_PUB.Add_Exc_Msg
3995: ( G_PKG_NAME
3996: , 'Currency_Detail'

Line 3994: OE_MSG_PUB.Add_Exc_Msg

3990: WHEN OTHERS THEN
3991:
3992: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3993: THEN
3994: OE_MSG_PUB.Add_Exc_Msg
3995: ( G_PKG_NAME
3996: , 'Currency_Detail'
3997: );
3998: END IF;

Line 4028: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

4024: EXCEPTION
4025:
4026: WHEN NO_DATA_FOUND THEN
4027:
4028: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4029: THEN
4030:
4031: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4032: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','markup_formula');

Line 4033: OE_MSG_PUB.Add;

4029: THEN
4030:
4031: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4032: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','markup_formula');
4033: OE_MSG_PUB.Add;
4034:
4035: END IF;
4036:
4037: RETURN NULL;

Line 4041: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4037: RETURN NULL;
4038:
4039: WHEN OTHERS THEN
4040:
4041: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4042: THEN
4043: OE_MSG_PUB.Add_Exc_Msg
4044: ( G_PKG_NAME
4045: , 'Markup_Formula'

Line 4043: OE_MSG_PUB.Add_Exc_Msg

4039: WHEN OTHERS THEN
4040:
4041: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4042: THEN
4043: OE_MSG_PUB.Add_Exc_Msg
4044: ( G_PKG_NAME
4045: , 'Markup_Formula'
4046: );
4047: END IF;

Line 4077: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

4073: EXCEPTION
4074:
4075: WHEN NO_DATA_FOUND THEN
4076:
4077: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4078: THEN
4079:
4080: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4081: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_currency');

Line 4082: OE_MSG_PUB.Add;

4078: THEN
4079:
4080: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4081: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_currency');
4082: OE_MSG_PUB.Add;
4083:
4084: END IF;
4085:
4086: RETURN NULL;

Line 4090: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4086: RETURN NULL;
4087:
4088: WHEN OTHERS THEN
4089:
4090: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4091: THEN
4092: OE_MSG_PUB.Add_Exc_Msg
4093: ( G_PKG_NAME
4094: , 'To_Currency'

Line 4092: OE_MSG_PUB.Add_Exc_Msg

4088: WHEN OTHERS THEN
4089:
4090: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4091: THEN
4092: OE_MSG_PUB.Add_Exc_Msg
4093: ( G_PKG_NAME
4094: , 'To_Currency'
4095: );
4096: END IF;

Line 4126: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

4122: EXCEPTION
4123:
4124: WHEN NO_DATA_FOUND THEN
4125:
4126: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4127: THEN
4128:
4129: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4130: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','enabled');

Line 4131: OE_MSG_PUB.Add;

4127: THEN
4128:
4129: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4130: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','enabled');
4131: OE_MSG_PUB.Add;
4132:
4133: END IF;
4134:
4135: RETURN NULL;

Line 4139: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4135: RETURN NULL;
4136:
4137: WHEN OTHERS THEN
4138:
4139: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4140: THEN
4141: OE_MSG_PUB.Add_Exc_Msg
4142: ( G_PKG_NAME
4143: , 'Enabled'

Line 4141: OE_MSG_PUB.Add_Exc_Msg

4137: WHEN OTHERS THEN
4138:
4139: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4140: THEN
4141: OE_MSG_PUB.Add_Exc_Msg
4142: ( G_PKG_NAME
4143: , 'Enabled'
4144: );
4145: END IF;

Line 4175: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

4171: EXCEPTION
4172:
4173: WHEN NO_DATA_FOUND THEN
4174:
4175: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4176: THEN
4177:
4178: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4179: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prc_context');

Line 4180: OE_MSG_PUB.Add;

4176: THEN
4177:
4178: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4179: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prc_context');
4180: OE_MSG_PUB.Add;
4181:
4182: END IF;
4183:
4184: RETURN NULL;

Line 4188: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4184: RETURN NULL;
4185:
4186: WHEN OTHERS THEN
4187:
4188: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4189: THEN
4190: OE_MSG_PUB.Add_Exc_Msg
4191: ( G_PKG_NAME
4192: , 'Prc_Context'

Line 4190: OE_MSG_PUB.Add_Exc_Msg

4186: WHEN OTHERS THEN
4187:
4188: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4189: THEN
4190: OE_MSG_PUB.Add_Exc_Msg
4191: ( G_PKG_NAME
4192: , 'Prc_Context'
4193: );
4194: END IF;

Line 4224: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

4220: EXCEPTION
4221:
4222: WHEN NO_DATA_FOUND THEN
4223:
4224: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4225: THEN
4226:
4227: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4228: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded');

Line 4229: OE_MSG_PUB.Add;

4225: THEN
4226:
4227: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4228: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded');
4229: OE_MSG_PUB.Add;
4230:
4231: END IF;
4232:
4233: RETURN NULL;

Line 4237: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4233: RETURN NULL;
4234:
4235: WHEN OTHERS THEN
4236:
4237: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4238: THEN
4239: OE_MSG_PUB.Add_Exc_Msg
4240: ( G_PKG_NAME
4241: , 'Seeded'

Line 4239: OE_MSG_PUB.Add_Exc_Msg

4235: WHEN OTHERS THEN
4236:
4237: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4238: THEN
4239: OE_MSG_PUB.Add_Exc_Msg
4240: ( G_PKG_NAME
4241: , 'Seeded'
4242: );
4243: END IF;

Line 4273: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

4269: EXCEPTION
4270:
4271: WHEN NO_DATA_FOUND THEN
4272:
4273: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4274: THEN
4275:
4276: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4277: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded_valueset');

Line 4278: OE_MSG_PUB.Add;

4274: THEN
4275:
4276: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4277: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded_valueset');
4278: OE_MSG_PUB.Add;
4279:
4280: END IF;
4281:
4282: RETURN NULL;

Line 4286: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4282: RETURN NULL;
4283:
4284: WHEN OTHERS THEN
4285:
4286: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4287: THEN
4288: OE_MSG_PUB.Add_Exc_Msg
4289: ( G_PKG_NAME
4290: , 'Seeded_Valueset'

Line 4288: OE_MSG_PUB.Add_Exc_Msg

4284: WHEN OTHERS THEN
4285:
4286: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4287: THEN
4288: OE_MSG_PUB.Add_Exc_Msg
4289: ( G_PKG_NAME
4290: , 'Seeded_Valueset'
4291: );
4292: END IF;

Line 4322: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

4318: EXCEPTION
4319:
4320: WHEN NO_DATA_FOUND THEN
4321:
4322: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4323: THEN
4324:
4325: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4326: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','segment');

Line 4327: OE_MSG_PUB.Add;

4323: THEN
4324:
4325: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4326: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','segment');
4327: OE_MSG_PUB.Add;
4328:
4329: END IF;
4330:
4331: RETURN NULL;

Line 4335: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4331: RETURN NULL;
4332:
4333: WHEN OTHERS THEN
4334:
4335: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4336: THEN
4337: OE_MSG_PUB.Add_Exc_Msg
4338: ( G_PKG_NAME
4339: , 'Segment'

Line 4337: OE_MSG_PUB.Add_Exc_Msg

4333: WHEN OTHERS THEN
4334:
4335: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4336: THEN
4337: OE_MSG_PUB.Add_Exc_Msg
4338: ( G_PKG_NAME
4339: , 'Segment'
4340: );
4341: END IF;

Line 4371: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

4367: EXCEPTION
4368:
4369: WHEN NO_DATA_FOUND THEN
4370:
4371: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4372: THEN
4373:
4374: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4375: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','user_valueset');

Line 4376: OE_MSG_PUB.Add;

4372: THEN
4373:
4374: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4375: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','user_valueset');
4376: OE_MSG_PUB.Add;
4377:
4378: END IF;
4379:
4380: RETURN NULL;

Line 4384: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4380: RETURN NULL;
4381:
4382: WHEN OTHERS THEN
4383:
4384: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4385: THEN
4386: OE_MSG_PUB.Add_Exc_Msg
4387: ( G_PKG_NAME
4388: , 'User_Valueset'

Line 4386: OE_MSG_PUB.Add_Exc_Msg

4382: WHEN OTHERS THEN
4383:
4384: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4385: THEN
4386: OE_MSG_PUB.Add_Exc_Msg
4387: ( G_PKG_NAME
4388: , 'User_Valueset'
4389: );
4390: END IF;

Line 4420: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

4416: EXCEPTION
4417:
4418: WHEN NO_DATA_FOUND THEN
4419:
4420: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4421: THEN
4422:
4423: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4424: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','lookup');

Line 4425: OE_MSG_PUB.Add;

4421: THEN
4422:
4423: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4424: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','lookup');
4425: OE_MSG_PUB.Add;
4426:
4427: END IF;
4428:
4429: RETURN NULL;

Line 4433: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4429: RETURN NULL;
4430:
4431: WHEN OTHERS THEN
4432:
4433: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4434: THEN
4435: OE_MSG_PUB.Add_Exc_Msg
4436: ( G_PKG_NAME
4437: , 'Lookup'

Line 4435: OE_MSG_PUB.Add_Exc_Msg

4431: WHEN OTHERS THEN
4432:
4433: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4434: THEN
4435: OE_MSG_PUB.Add_Exc_Msg
4436: ( G_PKG_NAME
4437: , 'Lookup'
4438: );
4439: END IF;

Line 4469: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

4465: EXCEPTION
4466:
4467: WHEN NO_DATA_FOUND THEN
4468:
4469: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4470: THEN
4471:
4472: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4473: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte');

Line 4474: OE_MSG_PUB.Add;

4470: THEN
4471:
4472: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4473: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte');
4474: OE_MSG_PUB.Add;
4475:
4476: END IF;
4477:
4478: RETURN NULL;

Line 4482: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4478: RETURN NULL;
4479:
4480: WHEN OTHERS THEN
4481:
4482: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4483: THEN
4484: OE_MSG_PUB.Add_Exc_Msg
4485: ( G_PKG_NAME
4486: , 'Pte'

Line 4484: OE_MSG_PUB.Add_Exc_Msg

4480: WHEN OTHERS THEN
4481:
4482: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4483: THEN
4484: OE_MSG_PUB.Add_Exc_Msg
4485: ( G_PKG_NAME
4486: , 'Pte'
4487: );
4488: END IF;

Line 4518: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

4514: EXCEPTION
4515:
4516: WHEN NO_DATA_FOUND THEN
4517:
4518: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4519: THEN
4520:
4521: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4522: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','request_type');

Line 4523: OE_MSG_PUB.Add;

4519: THEN
4520:
4521: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4522: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','request_type');
4523: OE_MSG_PUB.Add;
4524:
4525: END IF;
4526:
4527: RETURN NULL;

Line 4531: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4527: RETURN NULL;
4528:
4529: WHEN OTHERS THEN
4530:
4531: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4532: THEN
4533: OE_MSG_PUB.Add_Exc_Msg
4534: ( G_PKG_NAME
4535: , 'Request_Type'

Line 4533: OE_MSG_PUB.Add_Exc_Msg

4529: WHEN OTHERS THEN
4530:
4531: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4532: THEN
4533: OE_MSG_PUB.Add_Exc_Msg
4534: ( G_PKG_NAME
4535: , 'Request_Type'
4536: );
4537: END IF;

Line 4567: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

4563: EXCEPTION
4564:
4565: WHEN NO_DATA_FOUND THEN
4566:
4567: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4568: THEN
4569:
4570: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4571: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte_source_system');

Line 4572: OE_MSG_PUB.Add;

4568: THEN
4569:
4570: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4571: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte_source_system');
4572: OE_MSG_PUB.Add;
4573:
4574: END IF;
4575:
4576: RETURN NULL;

Line 4580: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4576: RETURN NULL;
4577:
4578: WHEN OTHERS THEN
4579:
4580: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4581: THEN
4582: OE_MSG_PUB.Add_Exc_Msg
4583: ( G_PKG_NAME
4584: , 'Pte_Source_System'

Line 4582: OE_MSG_PUB.Add_Exc_Msg

4578: WHEN OTHERS THEN
4579:
4580: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4581: THEN
4582: OE_MSG_PUB.Add_Exc_Msg
4583: ( G_PKG_NAME
4584: , 'Pte_Source_System'
4585: );
4586: END IF;

Line 4616: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

4612: EXCEPTION
4613:
4614: WHEN NO_DATA_FOUND THEN
4615:
4616: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4617: THEN
4618:
4619: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4620: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','segment_pte');

Line 4621: OE_MSG_PUB.Add;

4617: THEN
4618:
4619: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4620: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','segment_pte');
4621: OE_MSG_PUB.Add;
4622:
4623: END IF;
4624:
4625: RETURN NULL;

Line 4629: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4625: RETURN NULL;
4626:
4627: WHEN OTHERS THEN
4628:
4629: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4630: THEN
4631: OE_MSG_PUB.Add_Exc_Msg
4632: ( G_PKG_NAME
4633: , 'Segment_Pte'

Line 4631: OE_MSG_PUB.Add_Exc_Msg

4627: WHEN OTHERS THEN
4628:
4629: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4630: THEN
4631: OE_MSG_PUB.Add_Exc_Msg
4632: ( G_PKG_NAME
4633: , 'Segment_Pte'
4634: );
4635: END IF;

Line 4665: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

4661: EXCEPTION
4662:
4663: WHEN NO_DATA_FOUND THEN
4664:
4665: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4666: THEN
4667:
4668: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4669: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','attribute_sourcing');

Line 4670: OE_MSG_PUB.Add;

4666: THEN
4667:
4668: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4669: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','attribute_sourcing');
4670: OE_MSG_PUB.Add;
4671:
4672: END IF;
4673:
4674: RETURN NULL;

Line 4678: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4674: RETURN NULL;
4675:
4676: WHEN OTHERS THEN
4677:
4678: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4679: THEN
4680: OE_MSG_PUB.Add_Exc_Msg
4681: ( G_PKG_NAME
4682: , 'Attribute_Sourcing'

Line 4680: OE_MSG_PUB.Add_Exc_Msg

4676: WHEN OTHERS THEN
4677:
4678: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4679: THEN
4680: OE_MSG_PUB.Add_Exc_Msg
4681: ( G_PKG_NAME
4682: , 'Attribute_Sourcing'
4683: );
4684: END IF;

Line 4714: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

4710: EXCEPTION
4711:
4712: WHEN NO_DATA_FOUND THEN
4713:
4714: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4715: THEN
4716:
4717: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4718: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','functional_area');

Line 4719: OE_MSG_PUB.Add;

4715: THEN
4716:
4717: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4718: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','functional_area');
4719: OE_MSG_PUB.Add;
4720:
4721: END IF;
4722:
4723: RETURN NULL;

Line 4727: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4723: RETURN NULL;
4724:
4725: WHEN OTHERS THEN
4726:
4727: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4728: THEN
4729: OE_MSG_PUB.Add_Exc_Msg
4730: ( G_PKG_NAME
4731: , 'Functional_Area'

Line 4729: OE_MSG_PUB.Add_Exc_Msg

4725: WHEN OTHERS THEN
4726:
4727: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4728: THEN
4729: OE_MSG_PUB.Add_Exc_Msg
4730: ( G_PKG_NAME
4731: , 'Functional_Area'
4732: );
4733: END IF;

Line 4763: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

4759: EXCEPTION
4760:
4761: WHEN NO_DATA_FOUND THEN
4762:
4763: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4764: THEN
4765:
4766: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4767: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte_sourcesystem_fnarea');

Line 4768: OE_MSG_PUB.Add;

4764: THEN
4765:
4766: FND_MESSAGE.SET_NAME('QP','QP_ID_TO_VALUE_ERROR');
4767: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte_sourcesystem_fnarea');
4768: OE_MSG_PUB.Add;
4769:
4770: END IF;
4771:
4772: RETURN NULL;

Line 4776: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4772: RETURN NULL;
4773:
4774: WHEN OTHERS THEN
4775:
4776: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4777: THEN
4778: OE_MSG_PUB.Add_Exc_Msg
4779: ( G_PKG_NAME
4780: , 'Pte_Sourcesystem_Fnarea'

Line 4778: OE_MSG_PUB.Add_Exc_Msg

4774: WHEN OTHERS THEN
4775:
4776: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4777: THEN
4778: OE_MSG_PUB.Add_Exc_Msg
4779: ( G_PKG_NAME
4780: , 'Pte_Sourcesystem_Fnarea'
4781: );
4782: END IF;