APPS.QP_VALUE_TO_ID dependencies on OE_MSG_PUB

Line 64: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

60: EXCEPTION
61:
62: WHEN NO_DATA_FOUND THEN
63:
64: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
65: THEN
66:
67: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
68: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Flex_Meaning_To_Value_Id');

Line 69: OE_MSG_PUB.Add;

65: THEN
66:
67: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
68: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Flex_Meaning_To_Value_Id');
69: OE_MSG_PUB.Add;
70:
71: END IF;
72:
73: WHEN OTHERS THEN

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

71: END IF;
72:
73: WHEN OTHERS THEN
74:
75: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
76: THEN
77: OE_MSG_PUB.Add_Exc_Msg
78: ( G_PKG_NAME
79: , 'Flex_Meaning_To_Value_Id'

Line 77: OE_MSG_PUB.Add_Exc_Msg

73: WHEN OTHERS THEN
74:
75: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
76: THEN
77: OE_MSG_PUB.Add_Exc_Msg
78: ( G_PKG_NAME
79: , 'Flex_Meaning_To_Value_Id'
80: );
81: END IF;

Line 307: oe_msg_pub.Add;

303: -- Error getting combination id.
304: -- Function has already pushed a message on the stack. Add to
305: -- the API message list.
306:
307: oe_msg_pub.Add;
308: l_id := FND_API.G_MISS_NUM;
309:
310: END IF;
311:

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

314: EXCEPTION
315:
316: WHEN OTHERS THEN
317:
318: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
319: THEN
320: oe_msg_pub.Add_Exc_Msg
321: ( G_PKG_NAME
322: , 'Key_Flex'

Line 320: oe_msg_pub.Add_Exc_Msg

316: WHEN OTHERS THEN
317:
318: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
319: THEN
320: oe_msg_pub.Add_Exc_Msg
321: ( G_PKG_NAME
322: , 'Key_Flex'
323: );
324: END IF;

Line 358: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

354: EXCEPTION
355:
356: WHEN NO_DATA_FOUND THEN
357:
358: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
359: THEN
360:
361: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
362: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic_flag');

Line 363: oe_msg_pub.Add;

359: THEN
360:
361: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
362: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic_flag');
363: oe_msg_pub.Add;
364:
365: END IF;
366:
367: RETURN FND_API.G_MISS_CHAR;

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

367: RETURN FND_API.G_MISS_CHAR;
368:
369: WHEN OTHERS THEN
370:
371: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
372: THEN
373: oe_msg_pub.Add_Exc_Msg
374: ( G_PKG_NAME
375: , 'Automatic'

Line 373: oe_msg_pub.Add_Exc_Msg

369: WHEN OTHERS THEN
370:
371: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
372: THEN
373: oe_msg_pub.Add_Exc_Msg
374: ( G_PKG_NAME
375: , 'Automatic'
376: );
377: END IF;

Line 408: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

404: EXCEPTION
405:
406: WHEN NO_DATA_FOUND THEN
407:
408: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
409: THEN
410:
411: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
412: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_code');

Line 413: oe_msg_pub.Add;

409: THEN
410:
411: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
412: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_code');
413: oe_msg_pub.Add;
414:
415: END IF;
416:
417: RETURN FND_API.G_MISS_CHAR;

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

417: RETURN FND_API.G_MISS_CHAR;
418:
419: WHEN OTHERS THEN
420:
421: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
422: THEN
423: oe_msg_pub.Add_Exc_Msg
424: ( G_PKG_NAME
425: , 'Currency'

Line 423: oe_msg_pub.Add_Exc_Msg

419: WHEN OTHERS THEN
420:
421: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
422: THEN
423: oe_msg_pub.Add_Exc_Msg
424: ( G_PKG_NAME
425: , 'Currency'
426: );
427: END IF;

Line 458: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

454: EXCEPTION
455:
456: WHEN NO_DATA_FOUND THEN
457:
458: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
459: THEN
460:
461: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
462: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_lines_flag');

Line 463: oe_msg_pub.Add;

459: THEN
460:
461: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
462: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_lines_flag');
463: oe_msg_pub.Add;
464:
465: END IF;
466:
467: RETURN FND_API.G_MISS_CHAR;

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

467: RETURN FND_API.G_MISS_CHAR;
468:
469: WHEN OTHERS THEN
470:
471: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
472: THEN
473: oe_msg_pub.Add_Exc_Msg
474: ( G_PKG_NAME
475: , 'Discount_Lines'

Line 473: oe_msg_pub.Add_Exc_Msg

469: WHEN OTHERS THEN
470:
471: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
472: THEN
473: oe_msg_pub.Add_Exc_Msg
474: ( G_PKG_NAME
475: , 'Discount_Lines'
476: );
477: END IF;

Line 508: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

504: EXCEPTION
505:
506: WHEN NO_DATA_FOUND THEN
507:
508: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
509: THEN
510:
511: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
512: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms_code');

Line 513: oe_msg_pub.Add;

509: THEN
510:
511: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
512: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms_code');
513: oe_msg_pub.Add;
514:
515: END IF;
516:
517: RETURN FND_API.G_MISS_CHAR;

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

517: RETURN FND_API.G_MISS_CHAR;
518:
519: WHEN OTHERS THEN
520:
521: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
522: THEN
523: oe_msg_pub.Add_Exc_Msg
524: ( G_PKG_NAME
525: , 'Freight_Terms'

Line 523: oe_msg_pub.Add_Exc_Msg

519: WHEN OTHERS THEN
520:
521: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
522: THEN
523: oe_msg_pub.Add_Exc_Msg
524: ( G_PKG_NAME
525: , 'Freight_Terms'
526: );
527: END IF;

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

554: EXCEPTION
555:
556: WHEN NO_DATA_FOUND THEN
557:
558: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
559: THEN
560:
561: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
562: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header_id');

Line 563: oe_msg_pub.Add;

559: THEN
560:
561: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
562: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header_id');
563: oe_msg_pub.Add;
564:
565: END IF;
566:
567: RETURN FND_API.G_MISS_NUM;

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

567: RETURN FND_API.G_MISS_NUM;
568:
569: WHEN OTHERS THEN
570:
571: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
572: THEN
573: oe_msg_pub.Add_Exc_Msg
574: ( G_PKG_NAME
575: , 'List_Header'

Line 573: oe_msg_pub.Add_Exc_Msg

569: WHEN OTHERS THEN
570:
571: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
572: THEN
573: oe_msg_pub.Add_Exc_Msg
574: ( G_PKG_NAME
575: , 'List_Header'
576: );
577: END IF;

Line 608: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

604: EXCEPTION
605:
606: WHEN NO_DATA_FOUND THEN
607:
608: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
609: THEN
610:
611: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
612: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_type_code');

Line 613: oe_msg_pub.Add;

609: THEN
610:
611: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
612: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_type_code');
613: oe_msg_pub.Add;
614:
615: END IF;
616:
617: RETURN FND_API.G_MISS_CHAR;

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

617: RETURN FND_API.G_MISS_CHAR;
618:
619: WHEN OTHERS THEN
620:
621: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
622: THEN
623: oe_msg_pub.Add_Exc_Msg
624: ( G_PKG_NAME
625: , 'List_Type'

Line 623: oe_msg_pub.Add_Exc_Msg

619: WHEN OTHERS THEN
620:
621: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
622: THEN
623: oe_msg_pub.Add_Exc_Msg
624: ( G_PKG_NAME
625: , 'List_Type'
626: );
627: END IF;

Line 658: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

654: EXCEPTION
655:
656: WHEN NO_DATA_FOUND THEN
657:
658: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
659: THEN
660:
661: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
662: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prorate_flag');

Line 663: oe_msg_pub.Add;

659: THEN
660:
661: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
662: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prorate_flag');
663: oe_msg_pub.Add;
664:
665: END IF;
666:
667: RETURN FND_API.G_MISS_CHAR;

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

667: RETURN FND_API.G_MISS_CHAR;
668:
669: WHEN OTHERS THEN
670:
671: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
672: THEN
673: oe_msg_pub.Add_Exc_Msg
674: ( G_PKG_NAME
675: , 'Prorate'

Line 673: oe_msg_pub.Add_Exc_Msg

669: WHEN OTHERS THEN
670:
671: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
672: THEN
673: oe_msg_pub.Add_Exc_Msg
674: ( G_PKG_NAME
675: , 'Prorate'
676: );
677: END IF;

Line 708: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

704: EXCEPTION
705:
706: WHEN NO_DATA_FOUND THEN
707:
708: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
709: THEN
710:
711: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
712: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_method_code');

Line 713: oe_msg_pub.Add;

709: THEN
710:
711: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
712: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_method_code');
713: oe_msg_pub.Add;
714:
715: END IF;
716:
717: RETURN FND_API.G_MISS_CHAR;

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

717: RETURN FND_API.G_MISS_CHAR;
718:
719: WHEN OTHERS THEN
720:
721: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
722: THEN
723: oe_msg_pub.Add_Exc_Msg
724: ( G_PKG_NAME
725: , 'Ship_Method'

Line 723: oe_msg_pub.Add_Exc_Msg

719: WHEN OTHERS THEN
720:
721: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
722: THEN
723: oe_msg_pub.Add_Exc_Msg
724: ( G_PKG_NAME
725: , 'Ship_Method'
726: );
727: END IF;

Line 758: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

754: EXCEPTION
755:
756: WHEN NO_DATA_FOUND THEN
757:
758: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
759: THEN
760:
761: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
762: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','terms_id');

Line 763: oe_msg_pub.Add;

759: THEN
760:
761: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
762: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','terms_id');
763: oe_msg_pub.Add;
764:
765: END IF;
766:
767: RETURN FND_API.G_MISS_NUM;

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

767: RETURN FND_API.G_MISS_NUM;
768:
769: WHEN OTHERS THEN
770:
771: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
772: THEN
773: oe_msg_pub.Add_Exc_Msg
774: ( G_PKG_NAME
775: , 'Terms'

Line 773: oe_msg_pub.Add_Exc_Msg

769: WHEN OTHERS THEN
770:
771: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
772: THEN
773: oe_msg_pub.Add_Exc_Msg
774: ( G_PKG_NAME
775: , 'Terms'
776: );
777: END IF;

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

804: EXCEPTION
805:
806: WHEN NO_DATA_FOUND THEN
807:
808: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
809: THEN
810:
811: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
812: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_uom_code');

Line 813: oe_msg_pub.Add;

809: THEN
810:
811: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
812: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_uom_code');
813: oe_msg_pub.Add;
814:
815: END IF;
816:
817: RETURN FND_API.G_MISS_CHAR;

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

817: RETURN FND_API.G_MISS_CHAR;
818:
819: WHEN OTHERS THEN
820:
821: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
822: THEN
823: oe_msg_pub.Add_Exc_Msg
824: ( G_PKG_NAME
825: , 'Base_Uom'

Line 823: oe_msg_pub.Add_Exc_Msg

819: WHEN OTHERS THEN
820:
821: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
822: THEN
823: oe_msg_pub.Add_Exc_Msg
824: ( G_PKG_NAME
825: , 'Base_Uom'
826: );
827: END IF;

Line 858: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

854: EXCEPTION
855:
856: WHEN NO_DATA_FOUND THEN
857:
858: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
859: THEN
860:
861: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
862: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','generate_using_formula_id');

Line 863: oe_msg_pub.Add;

859: THEN
860:
861: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
862: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','generate_using_formula_id');
863: oe_msg_pub.Add;
864:
865: END IF;
866:
867: RETURN FND_API.G_MISS_NUM;

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

867: RETURN FND_API.G_MISS_NUM;
868:
869: WHEN OTHERS THEN
870:
871: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
872: THEN
873: oe_msg_pub.Add_Exc_Msg
874: ( G_PKG_NAME
875: , 'Generate_Using_Formula'

Line 873: oe_msg_pub.Add_Exc_Msg

869: WHEN OTHERS THEN
870:
871: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
872: THEN
873: oe_msg_pub.Add_Exc_Msg
874: ( G_PKG_NAME
875: , 'Generate_Using_Formula'
876: );
877: END IF;

Line 908: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

904: EXCEPTION
905:
906: WHEN NO_DATA_FOUND THEN
907:
908: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
909: THEN
910:
911: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
912: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item_id');

Line 913: oe_msg_pub.Add;

909: THEN
910:
911: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
912: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item_id');
913: oe_msg_pub.Add;
914:
915: END IF;
916:
917: RETURN FND_API.G_MISS_NUM;

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

917: RETURN FND_API.G_MISS_NUM;
918:
919: WHEN OTHERS THEN
920:
921: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
922: THEN
923: oe_msg_pub.Add_Exc_Msg
924: ( G_PKG_NAME
925: , 'Inventory_Item'

Line 923: oe_msg_pub.Add_Exc_Msg

919: WHEN OTHERS THEN
920:
921: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
922: THEN
923: oe_msg_pub.Add_Exc_Msg
924: ( G_PKG_NAME
925: , 'Inventory_Item'
926: );
927: END IF;

Line 958: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

954: EXCEPTION
955:
956: WHEN NO_DATA_FOUND THEN
957:
958: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
959: THEN
960:
961: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
962: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_id');

Line 963: oe_msg_pub.Add;

959: THEN
960:
961: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
962: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_id');
963: oe_msg_pub.Add;
964:
965: END IF;
966:
967: RETURN FND_API.G_MISS_NUM;

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

967: RETURN FND_API.G_MISS_NUM;
968:
969: WHEN OTHERS THEN
970:
971: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
972: THEN
973: oe_msg_pub.Add_Exc_Msg
974: ( G_PKG_NAME
975: , 'List_Line'

Line 973: oe_msg_pub.Add_Exc_Msg

969: WHEN OTHERS THEN
970:
971: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
972: THEN
973: oe_msg_pub.Add_Exc_Msg
974: ( G_PKG_NAME
975: , 'List_Line'
976: );
977: END IF;

Line 1008: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

1004: EXCEPTION
1005:
1006: WHEN NO_DATA_FOUND THEN
1007:
1008: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1009: THEN
1010:
1011: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1012: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_type_code');

Line 1013: oe_msg_pub.Add;

1009: THEN
1010:
1011: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1012: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_type_code');
1013: oe_msg_pub.Add;
1014:
1015: END IF;
1016:
1017: RETURN FND_API.G_MISS_CHAR;

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

1017: RETURN FND_API.G_MISS_CHAR;
1018:
1019: WHEN OTHERS THEN
1020:
1021: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1022: THEN
1023: oe_msg_pub.Add_Exc_Msg
1024: ( G_PKG_NAME
1025: , 'List_Line_Type'

Line 1023: oe_msg_pub.Add_Exc_Msg

1019: WHEN OTHERS THEN
1020:
1021: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1022: THEN
1023: oe_msg_pub.Add_Exc_Msg
1024: ( G_PKG_NAME
1025: , 'List_Line_Type'
1026: );
1027: END IF;

Line 1058: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

1054: EXCEPTION
1055:
1056: WHEN NO_DATA_FOUND THEN
1057:
1058: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1059: THEN
1060:
1061: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1062: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_price_uom_code');

Line 1063: oe_msg_pub.Add;

1059: THEN
1060:
1061: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1062: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_price_uom_code');
1063: oe_msg_pub.Add;
1064:
1065: END IF;
1066:
1067: RETURN FND_API.G_MISS_CHAR;

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

1067: RETURN FND_API.G_MISS_CHAR;
1068:
1069: WHEN OTHERS THEN
1070:
1071: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1072: THEN
1073: oe_msg_pub.Add_Exc_Msg
1074: ( G_PKG_NAME
1075: , 'List_Price_Uom'

Line 1073: oe_msg_pub.Add_Exc_Msg

1069: WHEN OTHERS THEN
1070:
1071: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1072: THEN
1073: oe_msg_pub.Add_Exc_Msg
1074: ( G_PKG_NAME
1075: , 'List_Price_Uom'
1076: );
1077: END IF;

Line 1108: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

1104: EXCEPTION
1105:
1106: WHEN NO_DATA_FOUND THEN
1107:
1108: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1109: THEN
1110:
1111: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','modifier_level_code');

Line 1113: oe_msg_pub.Add;

1109: THEN
1110:
1111: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','modifier_level_code');
1113: oe_msg_pub.Add;
1114:
1115: END IF;
1116:
1117: RETURN FND_API.G_MISS_CHAR;

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

1117: RETURN FND_API.G_MISS_CHAR;
1118:
1119: WHEN OTHERS THEN
1120:
1121: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1122: THEN
1123: oe_msg_pub.Add_Exc_Msg
1124: ( G_PKG_NAME
1125: , 'Modifier_Level'

Line 1123: oe_msg_pub.Add_Exc_Msg

1119: WHEN OTHERS THEN
1120:
1121: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1122: THEN
1123: oe_msg_pub.Add_Exc_Msg
1124: ( G_PKG_NAME
1125: , 'Modifier_Level'
1126: );
1127: END IF;

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

1154: EXCEPTION
1155:
1156: WHEN NO_DATA_FOUND THEN
1157:
1158: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1159: THEN
1160:
1161: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization_id');

Line 1163: oe_msg_pub.Add;

1159: THEN
1160:
1161: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization_id');
1163: oe_msg_pub.Add;
1164:
1165: END IF;
1166:
1167: RETURN FND_API.G_MISS_NUM;

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

1167: RETURN FND_API.G_MISS_NUM;
1168:
1169: WHEN OTHERS THEN
1170:
1171: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1172: THEN
1173: oe_msg_pub.Add_Exc_Msg
1174: ( G_PKG_NAME
1175: , 'Organization'

Line 1173: oe_msg_pub.Add_Exc_Msg

1169: WHEN OTHERS THEN
1170:
1171: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1172: THEN
1173: oe_msg_pub.Add_Exc_Msg
1174: ( G_PKG_NAME
1175: , 'Organization'
1176: );
1177: END IF;

Line 1208: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

1204: EXCEPTION
1205:
1206: WHEN NO_DATA_FOUND THEN
1207:
1208: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1209: THEN
1210:
1211: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1212: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_flag');

Line 1213: oe_msg_pub.Add;

1209: THEN
1210:
1211: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1212: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_flag');
1213: oe_msg_pub.Add;
1214:
1215: END IF;
1216:
1217: RETURN FND_API.G_MISS_CHAR;

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

1217: RETURN FND_API.G_MISS_CHAR;
1218:
1219: WHEN OTHERS THEN
1220:
1221: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1222: THEN
1223: oe_msg_pub.Add_Exc_Msg
1224: ( G_PKG_NAME
1225: , 'Override'

Line 1223: oe_msg_pub.Add_Exc_Msg

1219: WHEN OTHERS THEN
1220:
1221: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1222: THEN
1223: oe_msg_pub.Add_Exc_Msg
1224: ( G_PKG_NAME
1225: , 'Override'
1226: );
1227: END IF;

Line 1258: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

1254: EXCEPTION
1255:
1256: WHEN NO_DATA_FOUND THEN
1257:
1258: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1259: THEN
1260:
1261: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1262: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_break_type_code');

Line 1263: oe_msg_pub.Add;

1259: THEN
1260:
1261: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1262: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_break_type_code');
1263: oe_msg_pub.Add;
1264:
1265: END IF;
1266:
1267: RETURN FND_API.G_MISS_CHAR;

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

1267: RETURN FND_API.G_MISS_CHAR;
1268:
1269: WHEN OTHERS THEN
1270:
1271: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1272: THEN
1273: oe_msg_pub.Add_Exc_Msg
1274: ( G_PKG_NAME
1275: , 'Price_Break_Type'

Line 1273: oe_msg_pub.Add_Exc_Msg

1269: WHEN OTHERS THEN
1270:
1271: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1272: THEN
1273: oe_msg_pub.Add_Exc_Msg
1274: ( G_PKG_NAME
1275: , 'Price_Break_Type'
1276: );
1277: END IF;

Line 1308: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

1304: EXCEPTION
1305:
1306: WHEN NO_DATA_FOUND THEN
1307:
1308: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1309: THEN
1310:
1311: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1312: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_by_formula_id');

Line 1313: oe_msg_pub.Add;

1309: THEN
1310:
1311: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1312: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_by_formula_id');
1313: oe_msg_pub.Add;
1314:
1315: END IF;
1316:
1317: RETURN FND_API.G_MISS_NUM;

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

1317: RETURN FND_API.G_MISS_NUM;
1318:
1319: WHEN OTHERS THEN
1320:
1321: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1322: THEN
1323: oe_msg_pub.Add_Exc_Msg
1324: ( G_PKG_NAME
1325: , 'Price_By_Formula'

Line 1323: oe_msg_pub.Add_Exc_Msg

1319: WHEN OTHERS THEN
1320:
1321: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1322: THEN
1323: oe_msg_pub.Add_Exc_Msg
1324: ( G_PKG_NAME
1325: , 'Price_By_Formula'
1326: );
1327: END IF;

Line 1358: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

1354: EXCEPTION
1355:
1356: WHEN NO_DATA_FOUND THEN
1357:
1358: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1359: THEN
1360:
1361: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1362: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','primary_uom_flag');

Line 1363: oe_msg_pub.Add;

1359: THEN
1360:
1361: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1362: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','primary_uom_flag');
1363: oe_msg_pub.Add;
1364:
1365: END IF;
1366:
1367: RETURN FND_API.G_MISS_CHAR;

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

1367: RETURN FND_API.G_MISS_CHAR;
1368:
1369: WHEN OTHERS THEN
1370:
1371: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1372: THEN
1373: oe_msg_pub.Add_Exc_Msg
1374: ( G_PKG_NAME
1375: , 'Primary_Uom'

Line 1373: oe_msg_pub.Add_Exc_Msg

1369: WHEN OTHERS THEN
1370:
1371: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1372: THEN
1373: oe_msg_pub.Add_Exc_Msg
1374: ( G_PKG_NAME
1375: , 'Primary_Uom'
1376: );
1377: END IF;

Line 1408: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

1404: EXCEPTION
1405:
1406: WHEN NO_DATA_FOUND THEN
1407:
1408: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1409: THEN
1410:
1411: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1412: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','print_on_invoice_flag');

Line 1413: oe_msg_pub.Add;

1409: THEN
1410:
1411: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1412: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','print_on_invoice_flag');
1413: oe_msg_pub.Add;
1414:
1415: END IF;
1416:
1417: RETURN FND_API.G_MISS_CHAR;

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

1417: RETURN FND_API.G_MISS_CHAR;
1418:
1419: WHEN OTHERS THEN
1420:
1421: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1422: THEN
1423: oe_msg_pub.Add_Exc_Msg
1424: ( G_PKG_NAME
1425: , 'Print_On_Invoice'

Line 1423: oe_msg_pub.Add_Exc_Msg

1419: WHEN OTHERS THEN
1420:
1421: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1422: THEN
1423: oe_msg_pub.Add_Exc_Msg
1424: ( G_PKG_NAME
1425: , 'Print_On_Invoice'
1426: );
1427: END IF;

Line 1458: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

1454: EXCEPTION
1455:
1456: WHEN NO_DATA_FOUND THEN
1457:
1458: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1459: THEN
1460:
1461: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1462: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rebate_trxn_type_code');

Line 1463: oe_msg_pub.Add;

1459: THEN
1460:
1461: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1462: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rebate_trxn_type_code');
1463: oe_msg_pub.Add;
1464:
1465: END IF;
1466:
1467: RETURN FND_API.G_MISS_CHAR;

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

1467: RETURN FND_API.G_MISS_CHAR;
1468:
1469: WHEN OTHERS THEN
1470:
1471: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1472: THEN
1473: oe_msg_pub.Add_Exc_Msg
1474: ( G_PKG_NAME
1475: , 'Rebate_Transaction_Type'

Line 1473: oe_msg_pub.Add_Exc_Msg

1469: WHEN OTHERS THEN
1470:
1471: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1472: THEN
1473: oe_msg_pub.Add_Exc_Msg
1474: ( G_PKG_NAME
1475: , 'Rebate_Transaction_Type'
1476: );
1477: END IF;

Line 1508: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

1504: EXCEPTION
1505:
1506: WHEN NO_DATA_FOUND THEN
1507:
1508: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1509: THEN
1510:
1511: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1512: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','related_item_id');

Line 1513: oe_msg_pub.Add;

1509: THEN
1510:
1511: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1512: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','related_item_id');
1513: oe_msg_pub.Add;
1514:
1515: END IF;
1516:
1517: RETURN FND_API.G_MISS_NUM;

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

1517: RETURN FND_API.G_MISS_NUM;
1518:
1519: WHEN OTHERS THEN
1520:
1521: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1522: THEN
1523: oe_msg_pub.Add_Exc_Msg
1524: ( G_PKG_NAME
1525: , 'Related_Item'

Line 1523: oe_msg_pub.Add_Exc_Msg

1519: WHEN OTHERS THEN
1520:
1521: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1522: THEN
1523: oe_msg_pub.Add_Exc_Msg
1524: ( G_PKG_NAME
1525: , 'Related_Item'
1526: );
1527: END IF;

Line 1558: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

1554: EXCEPTION
1555:
1556: WHEN NO_DATA_FOUND THEN
1557:
1558: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1559: THEN
1560:
1561: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1562: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','relationship_type_id');

Line 1563: oe_msg_pub.Add;

1559: THEN
1560:
1561: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1562: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','relationship_type_id');
1563: oe_msg_pub.Add;
1564:
1565: END IF;
1566:
1567: RETURN FND_API.G_MISS_NUM;

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

1567: RETURN FND_API.G_MISS_NUM;
1568:
1569: WHEN OTHERS THEN
1570:
1571: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1572: THEN
1573: oe_msg_pub.Add_Exc_Msg
1574: ( G_PKG_NAME
1575: , 'Relationship_Type'

Line 1573: oe_msg_pub.Add_Exc_Msg

1569: WHEN OTHERS THEN
1570:
1571: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1572: THEN
1573: oe_msg_pub.Add_Exc_Msg
1574: ( G_PKG_NAME
1575: , 'Relationship_Type'
1576: );
1577: END IF;

Line 1608: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

1604: EXCEPTION
1605:
1606: WHEN NO_DATA_FOUND THEN
1607:
1608: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1609: THEN
1610:
1611: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1612: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reprice_flag');

Line 1613: oe_msg_pub.Add;

1609: THEN
1610:
1611: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1612: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reprice_flag');
1613: oe_msg_pub.Add;
1614:
1615: END IF;
1616:
1617: RETURN FND_API.G_MISS_CHAR;

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

1617: RETURN FND_API.G_MISS_CHAR;
1618:
1619: WHEN OTHERS THEN
1620:
1621: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1622: THEN
1623: oe_msg_pub.Add_Exc_Msg
1624: ( G_PKG_NAME
1625: , 'Reprice'

Line 1623: oe_msg_pub.Add_Exc_Msg

1619: WHEN OTHERS THEN
1620:
1621: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1622: THEN
1623: oe_msg_pub.Add_Exc_Msg
1624: ( G_PKG_NAME
1625: , 'Reprice'
1626: );
1627: END IF;

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

1654: EXCEPTION
1655:
1656: WHEN NO_DATA_FOUND THEN
1657:
1658: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1659: THEN
1660:
1661: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1662: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_reason_code');

Line 1663: oe_msg_pub.Add;

1659: THEN
1660:
1661: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1662: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_reason_code');
1663: oe_msg_pub.Add;
1664:
1665: END IF;
1666:
1667: RETURN FND_API.G_MISS_CHAR;

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

1667: RETURN FND_API.G_MISS_CHAR;
1668:
1669: WHEN OTHERS THEN
1670:
1671: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1672: THEN
1673: oe_msg_pub.Add_Exc_Msg
1674: ( G_PKG_NAME
1675: , 'Revision_Reason'

Line 1673: oe_msg_pub.Add_Exc_Msg

1669: WHEN OTHERS THEN
1670:
1671: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1672: THEN
1673: oe_msg_pub.Add_Exc_Msg
1674: ( G_PKG_NAME
1675: , 'Revision_Reason'
1676: );
1677: END IF;

Line 1708: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

1704: EXCEPTION
1705:
1706: WHEN NO_DATA_FOUND THEN
1707:
1708: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1709: THEN
1710:
1711: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1712: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','comparison_operator_code');

Line 1713: oe_msg_pub.Add;

1709: THEN
1710:
1711: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1712: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','comparison_operator_code');
1713: oe_msg_pub.Add;
1714:
1715: END IF;
1716:
1717: RETURN FND_API.G_MISS_CHAR;

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

1717: RETURN FND_API.G_MISS_CHAR;
1718:
1719: WHEN OTHERS THEN
1720:
1721: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1722: THEN
1723: oe_msg_pub.Add_Exc_Msg
1724: ( G_PKG_NAME
1725: , 'Comparison_Operator'

Line 1723: oe_msg_pub.Add_Exc_Msg

1719: WHEN OTHERS THEN
1720:
1721: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1722: THEN
1723: oe_msg_pub.Add_Exc_Msg
1724: ( G_PKG_NAME
1725: , 'Comparison_Operator'
1726: );
1727: END IF;

Line 1758: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

1754: EXCEPTION
1755:
1756: WHEN NO_DATA_FOUND THEN
1757:
1758: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1759: THEN
1760:
1761: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1762: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','created_from_rule_id');

Line 1763: oe_msg_pub.Add;

1759: THEN
1760:
1761: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1762: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','created_from_rule_id');
1763: oe_msg_pub.Add;
1764:
1765: END IF;
1766:
1767: RETURN FND_API.G_MISS_NUM;

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

1767: RETURN FND_API.G_MISS_NUM;
1768:
1769: WHEN OTHERS THEN
1770:
1771: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1772: THEN
1773: oe_msg_pub.Add_Exc_Msg
1774: ( G_PKG_NAME
1775: , 'Created_From_Rule'

Line 1773: oe_msg_pub.Add_Exc_Msg

1769: WHEN OTHERS THEN
1770:
1771: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1772: THEN
1773: oe_msg_pub.Add_Exc_Msg
1774: ( G_PKG_NAME
1775: , 'Created_From_Rule'
1776: );
1777: END IF;

Line 1808: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

1804: EXCEPTION
1805:
1806: WHEN NO_DATA_FOUND THEN
1807:
1808: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1809: THEN
1810:
1811: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1812: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','excluder_flag');

Line 1813: oe_msg_pub.Add;

1809: THEN
1810:
1811: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1812: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','excluder_flag');
1813: oe_msg_pub.Add;
1814:
1815: END IF;
1816:
1817: RETURN FND_API.G_MISS_CHAR;

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

1817: RETURN FND_API.G_MISS_CHAR;
1818:
1819: WHEN OTHERS THEN
1820:
1821: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1822: THEN
1823: oe_msg_pub.Add_Exc_Msg
1824: ( G_PKG_NAME
1825: , 'Excluder'

Line 1823: oe_msg_pub.Add_Exc_Msg

1819: WHEN OTHERS THEN
1820:
1821: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1822: THEN
1823: oe_msg_pub.Add_Exc_Msg
1824: ( G_PKG_NAME
1825: , 'Excluder'
1826: );
1827: END IF;

Line 1858: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

1854: EXCEPTION
1855:
1856: WHEN NO_DATA_FOUND THEN
1857:
1858: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1859: THEN
1860:
1861: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1862: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_id');

Line 1863: oe_msg_pub.Add;

1859: THEN
1860:
1861: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1862: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_id');
1863: oe_msg_pub.Add;
1864:
1865: END IF;
1866:
1867: RETURN FND_API.G_MISS_NUM;

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

1867: RETURN FND_API.G_MISS_NUM;
1868:
1869: WHEN OTHERS THEN
1870:
1871: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1872: THEN
1873: oe_msg_pub.Add_Exc_Msg
1874: ( G_PKG_NAME
1875: , 'Qualifier'

Line 1873: oe_msg_pub.Add_Exc_Msg

1869: WHEN OTHERS THEN
1870:
1871: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1872: THEN
1873: oe_msg_pub.Add_Exc_Msg
1874: ( G_PKG_NAME
1875: , 'Qualifier'
1876: );
1877: END IF;

Line 1908: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

1904: EXCEPTION
1905:
1906: WHEN NO_DATA_FOUND THEN
1907:
1908: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1909: THEN
1910:
1911: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1912: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_rule_id');

Line 1913: oe_msg_pub.Add;

1909: THEN
1910:
1911: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1912: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_rule_id');
1913: oe_msg_pub.Add;
1914:
1915: END IF;
1916:
1917: RETURN FND_API.G_MISS_NUM;

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

1917: RETURN FND_API.G_MISS_NUM;
1918:
1919: WHEN OTHERS THEN
1920:
1921: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1922: THEN
1923: oe_msg_pub.Add_Exc_Msg
1924: ( G_PKG_NAME
1925: , 'Qualifier_Rule'

Line 1923: oe_msg_pub.Add_Exc_Msg

1919: WHEN OTHERS THEN
1920:
1921: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1922: THEN
1923: oe_msg_pub.Add_Exc_Msg
1924: ( G_PKG_NAME
1925: , 'Qualifier_Rule'
1926: );
1927: END IF;

Line 1958: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

1954: EXCEPTION
1955:
1956: WHEN NO_DATA_FOUND THEN
1957:
1958: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1959: THEN
1960:
1961: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1962: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accumulate_flag');

Line 1963: oe_msg_pub.Add;

1959: THEN
1960:
1961: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
1962: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accumulate_flag');
1963: oe_msg_pub.Add;
1964:
1965: END IF;
1966:
1967: RETURN FND_API.G_MISS_CHAR;

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

1967: RETURN FND_API.G_MISS_CHAR;
1968:
1969: WHEN OTHERS THEN
1970:
1971: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1972: THEN
1973: oe_msg_pub.Add_Exc_Msg
1974: ( G_PKG_NAME
1975: , 'Accumulate'

Line 1973: oe_msg_pub.Add_Exc_Msg

1969: WHEN OTHERS THEN
1970:
1971: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1972: THEN
1973: oe_msg_pub.Add_Exc_Msg
1974: ( G_PKG_NAME
1975: , 'Accumulate'
1976: );
1977: END IF;

Line 2010: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

2006: EXCEPTION
2007:
2008: WHEN NO_DATA_FOUND THEN
2009:
2010: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2011: THEN
2012:
2013: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2014: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute');

Line 2015: oe_msg_pub.Add;

2011: THEN
2012:
2013: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2014: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute');
2015: oe_msg_pub.Add;
2016:
2017: END IF;
2018:
2019: RETURN FND_API.G_MISS_NUM;

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

2019: RETURN FND_API.G_MISS_NUM;
2020:
2021: WHEN OTHERS THEN
2022:
2023: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2024: THEN
2025: oe_msg_pub.Add_Exc_Msg
2026: ( G_PKG_NAME
2027: , 'Pricing_Attribute'

Line 2025: oe_msg_pub.Add_Exc_Msg

2021: WHEN OTHERS THEN
2022:
2023: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2024: THEN
2025: oe_msg_pub.Add_Exc_Msg
2026: ( G_PKG_NAME
2027: , 'Pricing_Attribute'
2028: );
2029: END IF;

Line 2082: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

2078: EXCEPTION
2079:
2080: WHEN NO_DATA_FOUND THEN
2081:
2082: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2083: THEN
2084:
2085: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2086: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attr_value_from');

Line 2087: oe_msg_pub.Add;

2083: THEN
2084:
2085: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2086: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attr_value_from');
2087: oe_msg_pub.Add;
2088:
2089: END IF;
2090:
2091: RETURN FND_API.G_MISS_NUM;

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

2091: RETURN FND_API.G_MISS_NUM;
2092:
2093: WHEN OTHERS THEN
2094:
2095: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2096: THEN
2097: oe_msg_pub.Add_Exc_Msg
2098: ( G_PKG_NAME
2099: , 'Pricing_Attr_Value_From'

Line 2097: oe_msg_pub.Add_Exc_Msg

2093: WHEN OTHERS THEN
2094:
2095: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2096: THEN
2097: oe_msg_pub.Add_Exc_Msg
2098: ( G_PKG_NAME
2099: , 'Pricing_Attr_Value_From'
2100: );
2101: END IF;

Line 2154: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

2150: EXCEPTION
2151:
2152: WHEN NO_DATA_FOUND THEN
2153:
2154: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2155: THEN
2156:
2157: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2158: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attr_value_to');

Line 2159: oe_msg_pub.Add;

2155: THEN
2156:
2157: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2158: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attr_value_to');
2159: oe_msg_pub.Add;
2160:
2161: END IF;
2162:
2163: RETURN FND_API.G_MISS_NUM;

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

2163: RETURN FND_API.G_MISS_NUM;
2164:
2165: WHEN OTHERS THEN
2166:
2167: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2168: THEN
2169: oe_msg_pub.Add_Exc_Msg
2170: ( G_PKG_NAME
2171: , 'Pricing_Attr_Value_to'

Line 2169: oe_msg_pub.Add_Exc_Msg

2165: WHEN OTHERS THEN
2166:
2167: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2168: THEN
2169: oe_msg_pub.Add_Exc_Msg
2170: ( G_PKG_NAME
2171: , 'Pricing_Attr_Value_to'
2172: );
2173: END IF;

Line 2206: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

2202: EXCEPTION
2203:
2204: WHEN NO_DATA_FOUND THEN
2205:
2206: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2207: THEN
2208:
2209: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2210: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_attribute');

Line 2211: oe_msg_pub.Add;

2207: THEN
2208:
2209: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2210: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_attribute');
2211: oe_msg_pub.Add;
2212:
2213: END IF;
2214:
2215: RETURN FND_API.G_MISS_NUM;

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

2215: RETURN FND_API.G_MISS_NUM;
2216:
2217: WHEN OTHERS THEN
2218:
2219: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2220: THEN
2221: oe_msg_pub.Add_Exc_Msg
2222: ( G_PKG_NAME
2223: , 'Qualifier_Attribute'

Line 2221: oe_msg_pub.Add_Exc_Msg

2217: WHEN OTHERS THEN
2218:
2219: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2220: THEN
2221: oe_msg_pub.Add_Exc_Msg
2222: ( G_PKG_NAME
2223: , 'Qualifier_Attribute'
2224: );
2225: END IF;

Line 2279: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

2275: EXCEPTION
2276:
2277: WHEN NO_DATA_FOUND THEN
2278:
2279: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2280: THEN
2281:
2282: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2283: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_attr_value');

Line 2284: oe_msg_pub.Add;

2280: THEN
2281:
2282: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2283: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_attr_value');
2284: oe_msg_pub.Add;
2285:
2286: END IF;
2287:
2288: RETURN FND_API.G_MISS_NUM;

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

2288: RETURN FND_API.G_MISS_NUM;
2289:
2290: WHEN OTHERS THEN
2291:
2292: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2293: THEN
2294: oe_msg_pub.Add_Exc_Msg
2295: ( G_PKG_NAME
2296: , 'Qualifier_Attr_Value'

Line 2294: oe_msg_pub.Add_Exc_Msg

2290: WHEN OTHERS THEN
2291:
2292: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2293: THEN
2294: oe_msg_pub.Add_Exc_Msg
2295: ( G_PKG_NAME
2296: , 'Qualifier_Attr_Value'
2297: );
2298: END IF;

Line 2350: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

2346: EXCEPTION
2347:
2348: WHEN NO_DATA_FOUND THEN
2349:
2350: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2351: THEN
2352:
2353: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2354: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_attr_value_to');

Line 2355: oe_msg_pub.Add;

2351: THEN
2352:
2353: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2354: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_attr_value_to');
2355: oe_msg_pub.Add;
2356:
2357: END IF;
2358:
2359: RETURN FND_API.G_MISS_NUM;

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

2359: RETURN FND_API.G_MISS_NUM;
2360:
2361: WHEN OTHERS THEN
2362:
2363: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2364: THEN
2365: oe_msg_pub.Add_Exc_Msg
2366: ( G_PKG_NAME
2367: , 'Qualifier_Attr_Value_To'

Line 2365: oe_msg_pub.Add_Exc_Msg

2361: WHEN OTHERS THEN
2362:
2363: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2364: THEN
2365: oe_msg_pub.Add_Exc_Msg
2366: ( G_PKG_NAME
2367: , 'Qualifier_Attr_Value_To'
2368: );
2369: END IF;

Line 2400: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

2396: EXCEPTION
2397:
2398: WHEN NO_DATA_FOUND THEN
2399:
2400: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2401: THEN
2402:
2403: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2404: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','product_uom_code');

Line 2405: oe_msg_pub.Add;

2401: THEN
2402:
2403: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2404: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','product_uom_code');
2405: oe_msg_pub.Add;
2406:
2407: END IF;
2408:
2409: RETURN FND_API.G_MISS_CHAR;

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

2409: RETURN FND_API.G_MISS_CHAR;
2410:
2411: WHEN OTHERS THEN
2412:
2413: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2414: THEN
2415: oe_msg_pub.Add_Exc_Msg
2416: ( G_PKG_NAME
2417: , 'Product_Uom'

Line 2415: oe_msg_pub.Add_Exc_Msg

2411: WHEN OTHERS THEN
2412:
2413: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2414: THEN
2415: oe_msg_pub.Add_Exc_Msg
2416: ( G_PKG_NAME
2417: , 'Product_Uom'
2418: );
2419: END IF;

Line 2450: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

2446: EXCEPTION
2447:
2448: WHEN NO_DATA_FOUND THEN
2449:
2450: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2451: THEN
2452:
2453: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2454: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header_id');

Line 2455: oe_msg_pub.Add;

2451: THEN
2452:
2453: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2454: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header_id');
2455: oe_msg_pub.Add;
2456:
2457: END IF;
2458:
2459: RETURN FND_API.G_MISS_NUM;

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

2459: RETURN FND_API.G_MISS_NUM;
2460:
2461: WHEN OTHERS THEN
2462:
2463: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2464: THEN
2465: oe_msg_pub.Add_Exc_Msg
2466: ( G_PKG_NAME
2467: , 'Header'

Line 2465: oe_msg_pub.Add_Exc_Msg

2461: WHEN OTHERS THEN
2462:
2463: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2464: THEN
2465: oe_msg_pub.Add_Exc_Msg
2466: ( G_PKG_NAME
2467: , 'Header'
2468: );
2469: END IF;

Line 2500: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

2496: EXCEPTION
2497:
2498: WHEN NO_DATA_FOUND THEN
2499:
2500: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2501: THEN
2502:
2503: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2504: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_id');

Line 2505: oe_msg_pub.Add;

2501: THEN
2502:
2503: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2504: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_id');
2505: oe_msg_pub.Add;
2506:
2507: END IF;
2508:
2509: RETURN FND_API.G_MISS_NUM;

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

2509: RETURN FND_API.G_MISS_NUM;
2510:
2511: WHEN OTHERS THEN
2512:
2513: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2514: THEN
2515: oe_msg_pub.Add_Exc_Msg
2516: ( G_PKG_NAME
2517: , 'Line'

Line 2515: oe_msg_pub.Add_Exc_Msg

2511: WHEN OTHERS THEN
2512:
2513: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2514: THEN
2515: oe_msg_pub.Add_Exc_Msg
2516: ( G_PKG_NAME
2517: , 'Line'
2518: );
2519: END IF;

Line 2550: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

2546: EXCEPTION
2547:
2548: WHEN NO_DATA_FOUND THEN
2549:
2550: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2551: THEN
2552:
2553: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2554: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_price_attrib_id');

Line 2555: oe_msg_pub.Add;

2551: THEN
2552:
2553: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2554: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_price_attrib_id');
2555: oe_msg_pub.Add;
2556:
2557: END IF;
2558:
2559: RETURN FND_API.G_MISS_NUM;

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

2559: RETURN FND_API.G_MISS_NUM;
2560:
2561: WHEN OTHERS THEN
2562:
2563: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2564: THEN
2565: oe_msg_pub.Add_Exc_Msg
2566: ( G_PKG_NAME
2567: , 'Order_Price_Attrib'

Line 2565: oe_msg_pub.Add_Exc_Msg

2561: WHEN OTHERS THEN
2562:
2563: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2564: THEN
2565: oe_msg_pub.Add_Exc_Msg
2566: ( G_PKG_NAME
2567: , 'Order_Price_Attrib'
2568: );
2569: END IF;

Line 2601: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

2597: EXCEPTION
2598:
2599: WHEN NO_DATA_FOUND THEN
2600:
2601: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2602: THEN
2603:
2604: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2605: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula_id');

Line 2606: oe_msg_pub.Add;

2602: THEN
2603:
2604: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2605: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula_id');
2606: oe_msg_pub.Add;
2607:
2608: END IF;
2609:
2610: RETURN FND_API.G_MISS_NUM;

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

2610: RETURN FND_API.G_MISS_NUM;
2611:
2612: WHEN OTHERS THEN
2613:
2614: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2615: THEN
2616: oe_msg_pub.Add_Exc_Msg
2617: ( G_PKG_NAME
2618: , 'Price_Formula'

Line 2616: oe_msg_pub.Add_Exc_Msg

2612: WHEN OTHERS THEN
2613:
2614: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2615: THEN
2616: oe_msg_pub.Add_Exc_Msg
2617: ( G_PKG_NAME
2618: , 'Price_Formula'
2619: );
2620: END IF;

Line 2651: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

2647: EXCEPTION
2648:
2649: WHEN NO_DATA_FOUND THEN
2650:
2651: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2652: THEN
2653:
2654: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2655: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula_line_id');

Line 2656: oe_msg_pub.Add;

2652: THEN
2653:
2654: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2655: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_formula_line_id');
2656: oe_msg_pub.Add;
2657:
2658: END IF;
2659:
2660: RETURN FND_API.G_MISS_NUM;

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

2660: RETURN FND_API.G_MISS_NUM;
2661:
2662: WHEN OTHERS THEN
2663:
2664: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2665: THEN
2666: oe_msg_pub.Add_Exc_Msg
2667: ( G_PKG_NAME
2668: , 'Price_Formula_Line'

Line 2666: oe_msg_pub.Add_Exc_Msg

2662: WHEN OTHERS THEN
2663:
2664: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2665: THEN
2666: oe_msg_pub.Add_Exc_Msg
2667: ( G_PKG_NAME
2668: , 'Price_Formula_Line'
2669: );
2670: END IF;

Line 2701: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

2697: EXCEPTION
2698:
2699: WHEN NO_DATA_FOUND THEN
2700:
2701: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2702: THEN
2703:
2704: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2705: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','formula_line_type_code');

Line 2706: oe_msg_pub.Add;

2702: THEN
2703:
2704: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2705: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','formula_line_type_code');
2706: oe_msg_pub.Add;
2707:
2708: END IF;
2709:
2710: RETURN FND_API.G_MISS_CHAR;

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

2710: RETURN FND_API.G_MISS_CHAR;
2711:
2712: WHEN OTHERS THEN
2713:
2714: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2715: THEN
2716: oe_msg_pub.Add_Exc_Msg
2717: ( G_PKG_NAME
2718: , 'Price_Formula_Line_Type'

Line 2716: oe_msg_pub.Add_Exc_Msg

2712: WHEN OTHERS THEN
2713:
2714: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2715: THEN
2716: oe_msg_pub.Add_Exc_Msg
2717: ( G_PKG_NAME
2718: , 'Price_Formula_Line_Type'
2719: );
2720: END IF;

Line 2751: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

2747: EXCEPTION
2748:
2749: WHEN NO_DATA_FOUND THEN
2750:
2751: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2752: THEN
2753:
2754: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2755: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_line_id');

Line 2756: oe_msg_pub.Add;

2752: THEN
2753:
2754: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2755: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_line_id');
2756: oe_msg_pub.Add;
2757:
2758: END IF;
2759:
2760: RETURN FND_API.G_MISS_NUM;

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

2760: RETURN FND_API.G_MISS_NUM;
2761:
2762: WHEN OTHERS THEN
2763:
2764: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2765: THEN
2766: oe_msg_pub.Add_Exc_Msg
2767: ( G_PKG_NAME
2768: , 'Price_List_Line'

Line 2766: oe_msg_pub.Add_Exc_Msg

2762: WHEN OTHERS THEN
2763:
2764: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2765: THEN
2766: oe_msg_pub.Add_Exc_Msg
2767: ( G_PKG_NAME
2768: , 'Price_List_Line'
2769: );
2770: END IF;

Line 2801: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

2797: EXCEPTION
2798:
2799: WHEN NO_DATA_FOUND THEN
2800:
2801: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2802: THEN
2803:
2804: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2805: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_modifier_list_id');

Line 2806: oe_msg_pub.Add;

2802: THEN
2803:
2804: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2805: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_modifier_list_id');
2806: oe_msg_pub.Add;
2807:
2808: END IF;
2809:
2810: RETURN FND_API.G_MISS_NUM;

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

2810: RETURN FND_API.G_MISS_NUM;
2811:
2812: WHEN OTHERS THEN
2813:
2814: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2815: THEN
2816: oe_msg_pub.Add_Exc_Msg
2817: ( G_PKG_NAME
2818: , 'Price_Modifier_List'

Line 2816: oe_msg_pub.Add_Exc_Msg

2812: WHEN OTHERS THEN
2813:
2814: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2815: THEN
2816: oe_msg_pub.Add_Exc_Msg
2817: ( G_PKG_NAME
2818: , 'Price_Modifier_List'
2819: );
2820: END IF;

Line 2851: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2847: EXCEPTION
2848:
2849: WHEN NO_DATA_FOUND THEN
2850:
2851: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2852: THEN
2853:
2854: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2855: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_exceed_action_code');

Line 2856: OE_MSG_PUB.Add;

2852: THEN
2853:
2854: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2855: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_exceed_action_code');
2856: OE_MSG_PUB.Add;
2857:
2858: END IF;
2859:
2860: RETURN FND_API.G_MISS_CHAR;

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

2860: RETURN FND_API.G_MISS_CHAR;
2861:
2862: WHEN OTHERS THEN
2863:
2864: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2865: THEN
2866: OE_MSG_PUB.Add_Exc_Msg
2867: ( G_PKG_NAME
2868: , 'Limit_Exceed_Action'

Line 2866: OE_MSG_PUB.Add_Exc_Msg

2862: WHEN OTHERS THEN
2863:
2864: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2865: THEN
2866: OE_MSG_PUB.Add_Exc_Msg
2867: ( G_PKG_NAME
2868: , 'Limit_Exceed_Action'
2869: );
2870: END IF;

Line 2901: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2897: EXCEPTION
2898:
2899: WHEN NO_DATA_FOUND THEN
2900:
2901: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2902: THEN
2903:
2904: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2905: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_id');

Line 2906: OE_MSG_PUB.Add;

2902: THEN
2903:
2904: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2905: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_id');
2906: OE_MSG_PUB.Add;
2907:
2908: END IF;
2909:
2910: RETURN FND_API.G_MISS_NUM;

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

2910: RETURN FND_API.G_MISS_NUM;
2911:
2912: WHEN OTHERS THEN
2913:
2914: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2915: THEN
2916: OE_MSG_PUB.Add_Exc_Msg
2917: ( G_PKG_NAME
2918: , 'Limit'

Line 2916: OE_MSG_PUB.Add_Exc_Msg

2912: WHEN OTHERS THEN
2913:
2914: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2915: THEN
2916: OE_MSG_PUB.Add_Exc_Msg
2917: ( G_PKG_NAME
2918: , 'Limit'
2919: );
2920: END IF;

Line 2951: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2947: EXCEPTION
2948:
2949: WHEN NO_DATA_FOUND THEN
2950:
2951: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2952: THEN
2953:
2954: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2955: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_level_code');

Line 2956: OE_MSG_PUB.Add;

2952: THEN
2953:
2954: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
2955: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_level_code');
2956: OE_MSG_PUB.Add;
2957:
2958: END IF;
2959:
2960: RETURN FND_API.G_MISS_CHAR;

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

2960: RETURN FND_API.G_MISS_CHAR;
2961:
2962: WHEN OTHERS THEN
2963:
2964: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2965: THEN
2966: OE_MSG_PUB.Add_Exc_Msg
2967: ( G_PKG_NAME
2968: , 'Limit_Level'

Line 2966: OE_MSG_PUB.Add_Exc_Msg

2962: WHEN OTHERS THEN
2963:
2964: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2965: THEN
2966: OE_MSG_PUB.Add_Exc_Msg
2967: ( G_PKG_NAME
2968: , 'Limit_Level'
2969: );
2970: END IF;

Line 3001: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2997: EXCEPTION
2998:
2999: WHEN NO_DATA_FOUND THEN
3000:
3001: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3002: THEN
3003:
3004: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3005: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','comparison_operator_code');

Line 3006: OE_MSG_PUB.Add;

3002: THEN
3003:
3004: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3005: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','comparison_operator_code');
3006: OE_MSG_PUB.Add;
3007:
3008: END IF;
3009:
3010: RETURN FND_API.G_MISS_CHAR;

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

3010: RETURN FND_API.G_MISS_CHAR;
3011:
3012: WHEN OTHERS THEN
3013:
3014: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3015: THEN
3016: OE_MSG_PUB.Add_Exc_Msg
3017: ( G_PKG_NAME
3018: , 'Comparison_Operator'

Line 3016: OE_MSG_PUB.Add_Exc_Msg

3012: WHEN OTHERS THEN
3013:
3014: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3015: THEN
3016: OE_MSG_PUB.Add_Exc_Msg
3017: ( G_PKG_NAME
3018: , 'Comparison_Operator'
3019: );
3020: END IF;

Line 3051: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3047: EXCEPTION
3048:
3049: WHEN NO_DATA_FOUND THEN
3050:
3051: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3052: THEN
3053:
3054: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3055: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_attribute_id');

Line 3056: OE_MSG_PUB.Add;

3052: THEN
3053:
3054: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3055: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_attribute_id');
3056: OE_MSG_PUB.Add;
3057:
3058: END IF;
3059:
3060: RETURN FND_API.G_MISS_NUM;

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

3060: RETURN FND_API.G_MISS_NUM;
3061:
3062: WHEN OTHERS THEN
3063:
3064: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3065: THEN
3066: OE_MSG_PUB.Add_Exc_Msg
3067: ( G_PKG_NAME
3068: , 'Limit_Attribute'

Line 3066: OE_MSG_PUB.Add_Exc_Msg

3062: WHEN OTHERS THEN
3063:
3064: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3065: THEN
3066: OE_MSG_PUB.Add_Exc_Msg
3067: ( G_PKG_NAME
3068: , 'Limit_Attribute'
3069: );
3070: END IF;

Line 3101: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3097: EXCEPTION
3098:
3099: WHEN NO_DATA_FOUND THEN
3100:
3101: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3102: THEN
3103:
3104: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3105: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_balance_id');

Line 3106: OE_MSG_PUB.Add;

3102: THEN
3103:
3104: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3105: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_balance_id');
3106: OE_MSG_PUB.Add;
3107:
3108: END IF;
3109:
3110: RETURN FND_API.G_MISS_NUM;

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

3110: RETURN FND_API.G_MISS_NUM;
3111:
3112: WHEN OTHERS THEN
3113:
3114: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3115: THEN
3116: OE_MSG_PUB.Add_Exc_Msg
3117: ( G_PKG_NAME
3118: , 'Limit_Balance'

Line 3116: OE_MSG_PUB.Add_Exc_Msg

3112: WHEN OTHERS THEN
3113:
3114: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3115: THEN
3116: OE_MSG_PUB.Add_Exc_Msg
3117: ( G_PKG_NAME
3118: , 'Limit_Balance'
3119: );
3120: END IF;

Line 3151: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3147: EXCEPTION
3148:
3149: WHEN NO_DATA_FOUND THEN
3150:
3151: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3152: THEN
3153:
3154: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3155: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_currency_code');

Line 3156: OE_MSG_PUB.Add;

3152: THEN
3153:
3154: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3155: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_currency_code');
3156: OE_MSG_PUB.Add;
3157:
3158: END IF;
3159:
3160: RETURN FND_API.G_MISS_CHAR;

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

3160: RETURN FND_API.G_MISS_CHAR;
3161:
3162: WHEN OTHERS THEN
3163:
3164: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3165: THEN
3166: OE_MSG_PUB.Add_Exc_Msg
3167: ( G_PKG_NAME
3168: , 'Base_Currency'

Line 3166: OE_MSG_PUB.Add_Exc_Msg

3162: WHEN OTHERS THEN
3163:
3164: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3165: THEN
3166: OE_MSG_PUB.Add_Exc_Msg
3167: ( G_PKG_NAME
3168: , 'Base_Currency'
3169: );
3170: END IF;

Line 3201: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3197: EXCEPTION
3198:
3199: WHEN NO_DATA_FOUND THEN
3200:
3201: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3202: THEN
3203:
3204: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3205: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_header_id');

Line 3206: OE_MSG_PUB.Add;

3202: THEN
3203:
3204: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3205: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_header_id');
3206: OE_MSG_PUB.Add;
3207:
3208: END IF;
3209:
3210: RETURN FND_API.G_MISS_NUM;

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

3210: RETURN FND_API.G_MISS_NUM;
3211:
3212: WHEN OTHERS THEN
3213:
3214: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3215: THEN
3216: OE_MSG_PUB.Add_Exc_Msg
3217: ( G_PKG_NAME
3218: , 'Currency_Header'

Line 3216: OE_MSG_PUB.Add_Exc_Msg

3212: WHEN OTHERS THEN
3213:
3214: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3215: THEN
3216: OE_MSG_PUB.Add_Exc_Msg
3217: ( G_PKG_NAME
3218: , 'Currency_Header'
3219: );
3220: END IF;

Line 3252: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3248: EXCEPTION
3249:
3250: WHEN NO_DATA_FOUND THEN
3251:
3252: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3253: THEN
3254:
3255: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3256: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','row_id');

Line 3257: OE_MSG_PUB.Add;

3253: THEN
3254:
3255: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3256: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','row_id');
3257: OE_MSG_PUB.Add;
3258:
3259: END IF;
3260:
3261: RETURN FND_API.G_MISS_NUM;

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

3261: RETURN FND_API.G_MISS_NUM;
3262:
3263: WHEN OTHERS THEN
3264:
3265: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3266: THEN
3267: OE_MSG_PUB.Add_Exc_Msg
3268: ( G_PKG_NAME
3269: , 'Row'

Line 3267: OE_MSG_PUB.Add_Exc_Msg

3263: WHEN OTHERS THEN
3264:
3265: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3266: THEN
3267: OE_MSG_PUB.Add_Exc_Msg
3268: ( G_PKG_NAME
3269: , 'Row'
3270: );
3271: END IF;

Line 3304: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3300: EXCEPTION
3301:
3302: WHEN NO_DATA_FOUND THEN
3303:
3304: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3305: THEN
3306:
3307: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3308: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_detail_id');

Line 3309: OE_MSG_PUB.Add;

3305: THEN
3306:
3307: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3308: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency_detail_id');
3309: OE_MSG_PUB.Add;
3310:
3311: END IF;
3312:
3313: RETURN FND_API.G_MISS_NUM;

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

3313: RETURN FND_API.G_MISS_NUM;
3314:
3315: WHEN OTHERS THEN
3316:
3317: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3318: THEN
3319: OE_MSG_PUB.Add_Exc_Msg
3320: ( G_PKG_NAME
3321: , 'Currency_Detail'

Line 3319: OE_MSG_PUB.Add_Exc_Msg

3315: WHEN OTHERS THEN
3316:
3317: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3318: THEN
3319: OE_MSG_PUB.Add_Exc_Msg
3320: ( G_PKG_NAME
3321: , 'Currency_Detail'
3322: );
3323: END IF;

Line 3354: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3350: EXCEPTION
3351:
3352: WHEN NO_DATA_FOUND THEN
3353:
3354: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3355: THEN
3356:
3357: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3358: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','markup_formula_id');

Line 3359: OE_MSG_PUB.Add;

3355: THEN
3356:
3357: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3358: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','markup_formula_id');
3359: OE_MSG_PUB.Add;
3360:
3361: END IF;
3362:
3363: RETURN FND_API.G_MISS_NUM;

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

3363: RETURN FND_API.G_MISS_NUM;
3364:
3365: WHEN OTHERS THEN
3366:
3367: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3368: THEN
3369: OE_MSG_PUB.Add_Exc_Msg
3370: ( G_PKG_NAME
3371: , 'Markup_Formula'

Line 3369: OE_MSG_PUB.Add_Exc_Msg

3365: WHEN OTHERS THEN
3366:
3367: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3368: THEN
3369: OE_MSG_PUB.Add_Exc_Msg
3370: ( G_PKG_NAME
3371: , 'Markup_Formula'
3372: );
3373: END IF;

Line 3405: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3401: EXCEPTION
3402:
3403: WHEN NO_DATA_FOUND THEN
3404:
3405: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3406: THEN
3407:
3408: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3409: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_markup_formula_id');

Line 3410: OE_MSG_PUB.Add;

3406: THEN
3407:
3408: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3409: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_markup_formula_id');
3410: OE_MSG_PUB.Add;
3411:
3412: END IF;
3413:
3414: RETURN FND_API.G_MISS_NUM;

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

3414: RETURN FND_API.G_MISS_NUM;
3415:
3416: WHEN OTHERS THEN
3417:
3418: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3419: THEN
3420: OE_MSG_PUB.Add_Exc_Msg
3421: ( G_PKG_NAME
3422: , 'Base_Markup_Formula'

Line 3420: OE_MSG_PUB.Add_Exc_Msg

3416: WHEN OTHERS THEN
3417:
3418: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3419: THEN
3420: OE_MSG_PUB.Add_Exc_Msg
3421: ( G_PKG_NAME
3422: , 'Base_Markup_Formula'
3423: );
3424: END IF;

Line 3455: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3451: EXCEPTION
3452:
3453: WHEN NO_DATA_FOUND THEN
3454:
3455: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3456: THEN
3457:
3458: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3459: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_currency_code');

Line 3460: OE_MSG_PUB.Add;

3456: THEN
3457:
3458: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3459: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_currency_code');
3460: OE_MSG_PUB.Add;
3461:
3462: END IF;
3463:
3464: RETURN FND_API.G_MISS_CHAR;

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

3464: RETURN FND_API.G_MISS_CHAR;
3465:
3466: WHEN OTHERS THEN
3467:
3468: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3469: THEN
3470: OE_MSG_PUB.Add_Exc_Msg
3471: ( G_PKG_NAME
3472: , 'To_Currency'

Line 3470: OE_MSG_PUB.Add_Exc_Msg

3466: WHEN OTHERS THEN
3467:
3468: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3469: THEN
3470: OE_MSG_PUB.Add_Exc_Msg
3471: ( G_PKG_NAME
3472: , 'To_Currency'
3473: );
3474: END IF;

Line 3505: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3501: EXCEPTION
3502:
3503: WHEN NO_DATA_FOUND THEN
3504:
3505: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3506: THEN
3507:
3508: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3509: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','enabled_flag');

Line 3510: OE_MSG_PUB.Add;

3506: THEN
3507:
3508: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3509: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','enabled_flag');
3510: OE_MSG_PUB.Add;
3511:
3512: END IF;
3513:
3514: RETURN FND_API.G_MISS_CHAR;

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

3514: RETURN FND_API.G_MISS_CHAR;
3515:
3516: WHEN OTHERS THEN
3517:
3518: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3519: THEN
3520: OE_MSG_PUB.Add_Exc_Msg
3521: ( G_PKG_NAME
3522: , 'Enabled'

Line 3520: OE_MSG_PUB.Add_Exc_Msg

3516: WHEN OTHERS THEN
3517:
3518: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3519: THEN
3520: OE_MSG_PUB.Add_Exc_Msg
3521: ( G_PKG_NAME
3522: , 'Enabled'
3523: );
3524: END IF;

Line 3555: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3551: EXCEPTION
3552:
3553: WHEN NO_DATA_FOUND THEN
3554:
3555: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3556: THEN
3557:
3558: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3559: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prc_context_id');

Line 3560: OE_MSG_PUB.Add;

3556: THEN
3557:
3558: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3559: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prc_context_id');
3560: OE_MSG_PUB.Add;
3561:
3562: END IF;
3563:
3564: RETURN FND_API.G_MISS_NUM;

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

3564: RETURN FND_API.G_MISS_NUM;
3565:
3566: WHEN OTHERS THEN
3567:
3568: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3569: THEN
3570: OE_MSG_PUB.Add_Exc_Msg
3571: ( G_PKG_NAME
3572: , 'Prc_Context'

Line 3570: OE_MSG_PUB.Add_Exc_Msg

3566: WHEN OTHERS THEN
3567:
3568: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3569: THEN
3570: OE_MSG_PUB.Add_Exc_Msg
3571: ( G_PKG_NAME
3572: , 'Prc_Context'
3573: );
3574: END IF;

Line 3605: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3601: EXCEPTION
3602:
3603: WHEN NO_DATA_FOUND THEN
3604:
3605: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3606: THEN
3607:
3608: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3609: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded_flag');

Line 3610: OE_MSG_PUB.Add;

3606: THEN
3607:
3608: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3609: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded_flag');
3610: OE_MSG_PUB.Add;
3611:
3612: END IF;
3613:
3614: RETURN FND_API.G_MISS_CHAR;

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

3614: RETURN FND_API.G_MISS_CHAR;
3615:
3616: WHEN OTHERS THEN
3617:
3618: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3619: THEN
3620: OE_MSG_PUB.Add_Exc_Msg
3621: ( G_PKG_NAME
3622: , 'Seeded'

Line 3620: OE_MSG_PUB.Add_Exc_Msg

3616: WHEN OTHERS THEN
3617:
3618: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3619: THEN
3620: OE_MSG_PUB.Add_Exc_Msg
3621: ( G_PKG_NAME
3622: , 'Seeded'
3623: );
3624: END IF;

Line 3655: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3651: EXCEPTION
3652:
3653: WHEN NO_DATA_FOUND THEN
3654:
3655: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3656: THEN
3657:
3658: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3659: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded_valueset_id');

Line 3660: OE_MSG_PUB.Add;

3656: THEN
3657:
3658: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3659: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded_valueset_id');
3660: OE_MSG_PUB.Add;
3661:
3662: END IF;
3663:
3664: RETURN FND_API.G_MISS_NUM;

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

3664: RETURN FND_API.G_MISS_NUM;
3665:
3666: WHEN OTHERS THEN
3667:
3668: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3669: THEN
3670: OE_MSG_PUB.Add_Exc_Msg
3671: ( G_PKG_NAME
3672: , 'Seeded_Valueset'

Line 3670: OE_MSG_PUB.Add_Exc_Msg

3666: WHEN OTHERS THEN
3667:
3668: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3669: THEN
3670: OE_MSG_PUB.Add_Exc_Msg
3671: ( G_PKG_NAME
3672: , 'Seeded_Valueset'
3673: );
3674: END IF;

Line 3705: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3701: EXCEPTION
3702:
3703: WHEN NO_DATA_FOUND THEN
3704:
3705: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3706: THEN
3707:
3708: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3709: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','segment_id');

Line 3710: OE_MSG_PUB.Add;

3706: THEN
3707:
3708: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3709: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','segment_id');
3710: OE_MSG_PUB.Add;
3711:
3712: END IF;
3713:
3714: RETURN FND_API.G_MISS_NUM;

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

3714: RETURN FND_API.G_MISS_NUM;
3715:
3716: WHEN OTHERS THEN
3717:
3718: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3719: THEN
3720: OE_MSG_PUB.Add_Exc_Msg
3721: ( G_PKG_NAME
3722: , 'Segment'

Line 3720: OE_MSG_PUB.Add_Exc_Msg

3716: WHEN OTHERS THEN
3717:
3718: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3719: THEN
3720: OE_MSG_PUB.Add_Exc_Msg
3721: ( G_PKG_NAME
3722: , 'Segment'
3723: );
3724: END IF;

Line 3755: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3751: EXCEPTION
3752:
3753: WHEN NO_DATA_FOUND THEN
3754:
3755: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3756: THEN
3757:
3758: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3759: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','user_valueset_id');

Line 3760: OE_MSG_PUB.Add;

3756: THEN
3757:
3758: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3759: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','user_valueset_id');
3760: OE_MSG_PUB.Add;
3761:
3762: END IF;
3763:
3764: RETURN FND_API.G_MISS_NUM;

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

3764: RETURN FND_API.G_MISS_NUM;
3765:
3766: WHEN OTHERS THEN
3767:
3768: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3769: THEN
3770: OE_MSG_PUB.Add_Exc_Msg
3771: ( G_PKG_NAME
3772: , 'User_Valueset'

Line 3770: OE_MSG_PUB.Add_Exc_Msg

3766: WHEN OTHERS THEN
3767:
3768: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3769: THEN
3770: OE_MSG_PUB.Add_Exc_Msg
3771: ( G_PKG_NAME
3772: , 'User_Valueset'
3773: );
3774: END IF;

Line 3805: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3801: EXCEPTION
3802:
3803: WHEN NO_DATA_FOUND THEN
3804:
3805: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3806: THEN
3807:
3808: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3809: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','lookup_code');

Line 3810: OE_MSG_PUB.Add;

3806: THEN
3807:
3808: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3809: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','lookup_code');
3810: OE_MSG_PUB.Add;
3811:
3812: END IF;
3813:
3814: RETURN FND_API.G_MISS_CHAR;

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

3814: RETURN FND_API.G_MISS_CHAR;
3815:
3816: WHEN OTHERS THEN
3817:
3818: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3819: THEN
3820: OE_MSG_PUB.Add_Exc_Msg
3821: ( G_PKG_NAME
3822: , 'Lookup'

Line 3820: OE_MSG_PUB.Add_Exc_Msg

3816: WHEN OTHERS THEN
3817:
3818: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3819: THEN
3820: OE_MSG_PUB.Add_Exc_Msg
3821: ( G_PKG_NAME
3822: , 'Lookup'
3823: );
3824: END IF;

Line 3855: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3851: EXCEPTION
3852:
3853: WHEN NO_DATA_FOUND THEN
3854:
3855: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3856: THEN
3857:
3858: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3859: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte_code');

Line 3860: OE_MSG_PUB.Add;

3856: THEN
3857:
3858: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3859: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte_code');
3860: OE_MSG_PUB.Add;
3861:
3862: END IF;
3863:
3864: RETURN FND_API.G_MISS_CHAR;

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

3864: RETURN FND_API.G_MISS_CHAR;
3865:
3866: WHEN OTHERS THEN
3867:
3868: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3869: THEN
3870: OE_MSG_PUB.Add_Exc_Msg
3871: ( G_PKG_NAME
3872: , 'Pte'

Line 3870: OE_MSG_PUB.Add_Exc_Msg

3866: WHEN OTHERS THEN
3867:
3868: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3869: THEN
3870: OE_MSG_PUB.Add_Exc_Msg
3871: ( G_PKG_NAME
3872: , 'Pte'
3873: );
3874: END IF;

Line 3905: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3901: EXCEPTION
3902:
3903: WHEN NO_DATA_FOUND THEN
3904:
3905: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3906: THEN
3907:
3908: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3909: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','request_type_code');

Line 3910: OE_MSG_PUB.Add;

3906: THEN
3907:
3908: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3909: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','request_type_code');
3910: OE_MSG_PUB.Add;
3911:
3912: END IF;
3913:
3914: RETURN FND_API.G_MISS_CHAR;

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

3914: RETURN FND_API.G_MISS_CHAR;
3915:
3916: WHEN OTHERS THEN
3917:
3918: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3919: THEN
3920: OE_MSG_PUB.Add_Exc_Msg
3921: ( G_PKG_NAME
3922: , 'Request_Type'

Line 3920: OE_MSG_PUB.Add_Exc_Msg

3916: WHEN OTHERS THEN
3917:
3918: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3919: THEN
3920: OE_MSG_PUB.Add_Exc_Msg
3921: ( G_PKG_NAME
3922: , 'Request_Type'
3923: );
3924: END IF;

Line 3955: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3951: EXCEPTION
3952:
3953: WHEN NO_DATA_FOUND THEN
3954:
3955: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3956: THEN
3957:
3958: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3959: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte_source_system_id');

Line 3960: OE_MSG_PUB.Add;

3956: THEN
3957:
3958: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
3959: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte_source_system_id');
3960: OE_MSG_PUB.Add;
3961:
3962: END IF;
3963:
3964: RETURN FND_API.G_MISS_NUM;

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

3964: RETURN FND_API.G_MISS_NUM;
3965:
3966: WHEN OTHERS THEN
3967:
3968: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3969: THEN
3970: OE_MSG_PUB.Add_Exc_Msg
3971: ( G_PKG_NAME
3972: , 'Pte_Source_System'

Line 3970: OE_MSG_PUB.Add_Exc_Msg

3966: WHEN OTHERS THEN
3967:
3968: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3969: THEN
3970: OE_MSG_PUB.Add_Exc_Msg
3971: ( G_PKG_NAME
3972: , 'Pte_Source_System'
3973: );
3974: END IF;

Line 4005: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4001: EXCEPTION
4002:
4003: WHEN NO_DATA_FOUND THEN
4004:
4005: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4006: THEN
4007:
4008: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
4009: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','segment_pte_id');

Line 4010: OE_MSG_PUB.Add;

4006: THEN
4007:
4008: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
4009: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','segment_pte_id');
4010: OE_MSG_PUB.Add;
4011:
4012: END IF;
4013:
4014: RETURN FND_API.G_MISS_NUM;

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

4014: RETURN FND_API.G_MISS_NUM;
4015:
4016: WHEN OTHERS THEN
4017:
4018: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4019: THEN
4020: OE_MSG_PUB.Add_Exc_Msg
4021: ( G_PKG_NAME
4022: , 'Segment_Pte'

Line 4020: OE_MSG_PUB.Add_Exc_Msg

4016: WHEN OTHERS THEN
4017:
4018: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4019: THEN
4020: OE_MSG_PUB.Add_Exc_Msg
4021: ( G_PKG_NAME
4022: , 'Segment_Pte'
4023: );
4024: END IF;

Line 4055: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4051: EXCEPTION
4052:
4053: WHEN NO_DATA_FOUND THEN
4054:
4055: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4056: THEN
4057:
4058: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
4059: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','attribute_sourcing_id');

Line 4060: OE_MSG_PUB.Add;

4056: THEN
4057:
4058: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
4059: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','attribute_sourcing_id');
4060: OE_MSG_PUB.Add;
4061:
4062: END IF;
4063:
4064: RETURN FND_API.G_MISS_NUM;

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

4064: RETURN FND_API.G_MISS_NUM;
4065:
4066: WHEN OTHERS THEN
4067:
4068: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4069: THEN
4070: OE_MSG_PUB.Add_Exc_Msg
4071: ( G_PKG_NAME
4072: , 'Attribute_Sourcing'

Line 4070: OE_MSG_PUB.Add_Exc_Msg

4066: WHEN OTHERS THEN
4067:
4068: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4069: THEN
4070: OE_MSG_PUB.Add_Exc_Msg
4071: ( G_PKG_NAME
4072: , 'Attribute_Sourcing'
4073: );
4074: END IF;

Line 4105: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4101: EXCEPTION
4102:
4103: WHEN NO_DATA_FOUND THEN
4104:
4105: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4106: THEN
4107:
4108: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
4109: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','functional_area_id');

Line 4110: OE_MSG_PUB.Add;

4106: THEN
4107:
4108: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
4109: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','functional_area_id');
4110: OE_MSG_PUB.Add;
4111:
4112: END IF;
4113:
4114: RETURN FND_API.G_MISS_NUM;

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

4114: RETURN FND_API.G_MISS_NUM;
4115:
4116: WHEN OTHERS THEN
4117:
4118: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4119: THEN
4120: OE_MSG_PUB.Add_Exc_Msg
4121: ( G_PKG_NAME
4122: , 'Functional_Area'

Line 4120: OE_MSG_PUB.Add_Exc_Msg

4116: WHEN OTHERS THEN
4117:
4118: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4119: THEN
4120: OE_MSG_PUB.Add_Exc_Msg
4121: ( G_PKG_NAME
4122: , 'Functional_Area'
4123: );
4124: END IF;

Line 4155: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4151: EXCEPTION
4152:
4153: WHEN NO_DATA_FOUND THEN
4154:
4155: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4156: THEN
4157:
4158: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
4159: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte_sourcesystem_fnarea_id');

Line 4160: OE_MSG_PUB.Add;

4156: THEN
4157:
4158: FND_MESSAGE.SET_NAME('QP','QP_VALUE_TO_ID_ERROR');
4159: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte_sourcesystem_fnarea_id');
4160: OE_MSG_PUB.Add;
4161:
4162: END IF;
4163:
4164: RETURN FND_API.G_MISS_NUM;

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

4164: RETURN FND_API.G_MISS_NUM;
4165:
4166: WHEN OTHERS THEN
4167:
4168: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4169: THEN
4170: OE_MSG_PUB.Add_Exc_Msg
4171: ( G_PKG_NAME
4172: , 'Pte_Sourcesystem_Fnarea'

Line 4170: OE_MSG_PUB.Add_Exc_Msg

4166: WHEN OTHERS THEN
4167:
4168: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4169: THEN
4170: OE_MSG_PUB.Add_Exc_Msg
4171: ( G_PKG_NAME
4172: , 'Pte_Sourcesystem_Fnarea'
4173: );
4174: END IF;

Line 4206: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4202: EXCEPTION
4203:
4204: WHEN NO_DATA_FOUND THEN
4205:
4206: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4207: THEN
4208:
4209: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4210: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule_id');

Line 4211: OE_MSG_PUB.Add;

4207: THEN
4208:
4209: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4210: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule_id');
4211: OE_MSG_PUB.Add;
4212:
4213: END IF;
4214:
4215: RETURN FND_API.G_MISS_NUM;

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

4215: RETURN FND_API.G_MISS_NUM;
4216:
4217: WHEN OTHERS THEN
4218:
4219: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4220: THEN
4221: OE_MSG_PUB.Add_Exc_Msg
4222: ( G_PKG_NAME
4223: , 'Accounting_Rule'

Line 4221: OE_MSG_PUB.Add_Exc_Msg

4217: WHEN OTHERS THEN
4218:
4219: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4220: THEN
4221: OE_MSG_PUB.Add_Exc_Msg
4222: ( G_PKG_NAME
4223: , 'Accounting_Rule'
4224: );
4225: END IF;

Line 4258: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4254: EXCEPTION
4255:
4256: WHEN NO_DATA_FOUND THEN
4257:
4258: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4259: THEN
4260:
4261: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4262: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Agreement_Contact_Id');

Line 4263: OE_MSG_PUB.Add;

4259: THEN
4260:
4261: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4262: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Agreement_Contact_Id');
4263: OE_MSG_PUB.Add;
4264:
4265: END IF;
4266:
4267: RETURN FND_API.G_MISS_CHAR;

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

4267: RETURN FND_API.G_MISS_CHAR;
4268:
4269: WHEN OTHERS THEN
4270:
4271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4272: THEN
4273: OE_MSG_PUB.Add_Exc_Msg
4274: ( G_PKG_NAME
4275: , 'Agreement_Contact'

Line 4273: OE_MSG_PUB.Add_Exc_Msg

4269: WHEN OTHERS THEN
4270:
4271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4272: THEN
4273: OE_MSG_PUB.Add_Exc_Msg
4274: ( G_PKG_NAME
4275: , 'Agreement_Contact'
4276: );
4277: END IF;

Line 4309: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4305: EXCEPTION
4306:
4307: WHEN NO_DATA_FOUND THEN
4308:
4309: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4310: THEN
4311:
4312: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4313: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_id');

Line 4314: OE_MSG_PUB.Add;

4310: THEN
4311:
4312: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4313: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_id');
4314: OE_MSG_PUB.Add;
4315:
4316: END IF;
4317:
4318: RETURN FND_API.G_MISS_NUM;

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

4318: RETURN FND_API.G_MISS_NUM;
4319:
4320: WHEN OTHERS THEN
4321:
4322: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4323: THEN
4324: OE_MSG_PUB.Add_Exc_Msg
4325: ( G_PKG_NAME
4326: , 'Agreement'

Line 4324: OE_MSG_PUB.Add_Exc_Msg

4320: WHEN OTHERS THEN
4321:
4322: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4323: THEN
4324: OE_MSG_PUB.Add_Exc_Msg
4325: ( G_PKG_NAME
4326: , 'Agreement'
4327: );
4328: END IF;

Line 4359: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4355: EXCEPTION
4356:
4357: WHEN NO_DATA_FOUND THEN
4358:
4359: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4360: THEN
4361:
4362: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4363: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Agreement_Type_Code');

Line 4364: OE_MSG_PUB.Add;

4360: THEN
4361:
4362: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4363: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Agreement_Type_Code');
4364: OE_MSG_PUB.Add;
4365:
4366: END IF;
4367:
4368: RETURN FND_API.G_MISS_CHAR;

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

4368: RETURN FND_API.G_MISS_CHAR;
4369:
4370: WHEN OTHERS THEN
4371:
4372: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4373: THEN
4374: OE_MSG_PUB.Add_Exc_Msg
4375: ( G_PKG_NAME
4376: , 'Agreement_Type'

Line 4374: OE_MSG_PUB.Add_Exc_Msg

4370: WHEN OTHERS THEN
4371:
4372: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4373: THEN
4374: OE_MSG_PUB.Add_Exc_Msg
4375: ( G_PKG_NAME
4376: , 'Agreement_Type'
4377: );
4378: END IF;

Line 4409: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4405: EXCEPTION
4406:
4407: WHEN NO_DATA_FOUND THEN
4408:
4409: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4410: THEN
4411:
4412: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4413: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Customer_Id');

Line 4414: OE_MSG_PUB.Add;

4410: THEN
4411:
4412: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4413: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Customer_Id');
4414: OE_MSG_PUB.Add;
4415:
4416: END IF;
4417:
4418: RETURN FND_API.G_MISS_CHAR;

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

4418: RETURN FND_API.G_MISS_CHAR;
4419:
4420: WHEN OTHERS THEN
4421:
4422: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4423: THEN
4424: OE_MSG_PUB.Add_Exc_Msg
4425: ( G_PKG_NAME
4426: , 'Customer'

Line 4424: OE_MSG_PUB.Add_Exc_Msg

4420: WHEN OTHERS THEN
4421:
4422: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4423: THEN
4424: OE_MSG_PUB.Add_Exc_Msg
4425: ( G_PKG_NAME
4426: , 'Customer'
4427: );
4428: END IF;

Line 4459: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4455: EXCEPTION
4456:
4457: WHEN NO_DATA_FOUND THEN
4458:
4459: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4460: THEN
4461:
4462: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4463: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Invoice_Contact_Id');

Line 4464: OE_MSG_PUB.Add;

4460: THEN
4461:
4462: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4463: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Invoice_Contact_Id');
4464: OE_MSG_PUB.Add;
4465:
4466: END IF;
4467:
4468: RETURN FND_API.G_MISS_CHAR;

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

4468: RETURN FND_API.G_MISS_CHAR;
4469:
4470: WHEN OTHERS THEN
4471:
4472: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4473: THEN
4474: OE_MSG_PUB.Add_Exc_Msg
4475: ( G_PKG_NAME
4476: , 'Invoice_Contact'

Line 4474: OE_MSG_PUB.Add_Exc_Msg

4470: WHEN OTHERS THEN
4471:
4472: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4473: THEN
4474: OE_MSG_PUB.Add_Exc_Msg
4475: ( G_PKG_NAME
4476: , 'Invoice_Contact'
4477: );
4478: END IF;

Line 4509: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4505: EXCEPTION
4506:
4507: WHEN NO_DATA_FOUND THEN
4508:
4509: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4510: THEN
4511:
4512: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4513: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Invoice_To_Site_Use_Id');

Line 4514: OE_MSG_PUB.Add;

4510: THEN
4511:
4512: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4513: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Invoice_To_Site_Use_Id');
4514: OE_MSG_PUB.Add;
4515:
4516: END IF;
4517:
4518: RETURN FND_API.G_MISS_CHAR;

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

4518: RETURN FND_API.G_MISS_CHAR;
4519:
4520: WHEN OTHERS THEN
4521:
4522: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4523: THEN
4524: OE_MSG_PUB.Add_Exc_Msg
4525: ( G_PKG_NAME
4526: , 'Invoice_To_Site_Use'

Line 4524: OE_MSG_PUB.Add_Exc_Msg

4520: WHEN OTHERS THEN
4521:
4522: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4523: THEN
4524: OE_MSG_PUB.Add_Exc_Msg
4525: ( G_PKG_NAME
4526: , 'Invoice_To_Site_Use'
4527: );
4528: END IF;

Line 4559: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4555: EXCEPTION
4556:
4557: WHEN NO_DATA_FOUND THEN
4558:
4559: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4560: THEN
4561:
4562: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4563: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule_id');

Line 4564: OE_MSG_PUB.Add;

4560: THEN
4561:
4562: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4563: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule_id');
4564: OE_MSG_PUB.Add;
4565:
4566: END IF;
4567:
4568: RETURN FND_API.G_MISS_NUM;

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

4568: RETURN FND_API.G_MISS_NUM;
4569:
4570: WHEN OTHERS THEN
4571:
4572: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4573: THEN
4574: OE_MSG_PUB.Add_Exc_Msg
4575: ( G_PKG_NAME
4576: , 'Invoicing_Rule'

Line 4574: OE_MSG_PUB.Add_Exc_Msg

4570: WHEN OTHERS THEN
4571:
4572: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4573: THEN
4574: OE_MSG_PUB.Add_Exc_Msg
4575: ( G_PKG_NAME
4576: , 'Invoicing_Rule'
4577: );
4578: END IF;

Line 4609: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4605: EXCEPTION
4606:
4607: WHEN NO_DATA_FOUND THEN
4608:
4609: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4610: THEN
4611:
4612: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4613: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Override_Arule_Flag');

Line 4614: OE_MSG_PUB.Add;

4610: THEN
4611:
4612: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4613: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Override_Arule_Flag');
4614: OE_MSG_PUB.Add;
4615:
4616: END IF;
4617:
4618: RETURN FND_API.G_MISS_CHAR;

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

4618: RETURN FND_API.G_MISS_CHAR;
4619:
4620: WHEN OTHERS THEN
4621:
4622: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4623: THEN
4624: OE_MSG_PUB.Add_Exc_Msg
4625: ( G_PKG_NAME
4626: , 'Override_Arule'

Line 4624: OE_MSG_PUB.Add_Exc_Msg

4620: WHEN OTHERS THEN
4621:
4622: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4623: THEN
4624: OE_MSG_PUB.Add_Exc_Msg
4625: ( G_PKG_NAME
4626: , 'Override_Arule'
4627: );
4628: END IF;

Line 4660: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4656: EXCEPTION
4657:
4658: WHEN NO_DATA_FOUND THEN
4659:
4660: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4661: THEN
4662:
4663: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4664: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Override_Irule_Flag');

Line 4665: OE_MSG_PUB.Add;

4661: THEN
4662:
4663: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4664: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Override_Irule_Flag');
4665: OE_MSG_PUB.Add;
4666:
4667: END IF;
4668:
4669: RETURN FND_API.G_MISS_CHAR;

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

4669: RETURN FND_API.G_MISS_CHAR;
4670:
4671: WHEN OTHERS THEN
4672:
4673: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4674: THEN
4675: OE_MSG_PUB.Add_Exc_Msg
4676: ( G_PKG_NAME
4677: , 'Override_Irule'

Line 4675: OE_MSG_PUB.Add_Exc_Msg

4671: WHEN OTHERS THEN
4672:
4673: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4674: THEN
4675: OE_MSG_PUB.Add_Exc_Msg
4676: ( G_PKG_NAME
4677: , 'Override_Irule'
4678: );
4679: END IF;

Line 4711: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4707: EXCEPTION
4708:
4709: WHEN NO_DATA_FOUND THEN
4710:
4711: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4712: THEN
4713:
4714: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4715: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_id');

Line 4716: OE_MSG_PUB.Add;

4712: THEN
4713:
4714: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4715: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_id');
4716: OE_MSG_PUB.Add;
4717:
4718: END IF;
4719:
4720: RETURN FND_API.G_MISS_NUM;

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

4720: RETURN FND_API.G_MISS_NUM;
4721:
4722: WHEN OTHERS THEN
4723:
4724: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4725: THEN
4726: OE_MSG_PUB.Add_Exc_Msg
4727: ( G_PKG_NAME
4728: , 'Price_List'

Line 4726: OE_MSG_PUB.Add_Exc_Msg

4722: WHEN OTHERS THEN
4723:
4724: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4725: THEN
4726: OE_MSG_PUB.Add_Exc_Msg
4727: ( G_PKG_NAME
4728: , 'Price_List'
4729: );
4730: END IF;

Line 4762: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4758: EXCEPTION
4759:
4760: WHEN NO_DATA_FOUND THEN
4761:
4762: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4763: THEN
4764:
4765: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4766: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep_id');

Line 4767: OE_MSG_PUB.Add;

4763: THEN
4764:
4765: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4766: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep_id');
4767: OE_MSG_PUB.Add;
4768:
4769: END IF;
4770:
4771: RETURN FND_API.G_MISS_NUM;

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

4771: RETURN FND_API.G_MISS_NUM;
4772:
4773: WHEN OTHERS THEN
4774:
4775: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4776: THEN
4777: OE_MSG_PUB.Add_Exc_Msg
4778: ( G_PKG_NAME
4779: , 'Salesrep'

Line 4777: OE_MSG_PUB.Add_Exc_Msg

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

Line 4813: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4809: EXCEPTION
4810:
4811: WHEN NO_DATA_FOUND THEN
4812:
4813: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4814: THEN
4815:
4816: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4817: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ship_Method_Code');

Line 4818: OE_MSG_PUB.Add;

4814: THEN
4815:
4816: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4817: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ship_Method_Code');
4818: OE_MSG_PUB.Add;
4819:
4820: END IF;
4821:
4822: RETURN FND_API.G_MISS_CHAR;

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

4822: RETURN FND_API.G_MISS_CHAR;
4823:
4824: WHEN OTHERS THEN
4825:
4826: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4827: THEN
4828: OE_MSG_PUB.Add_Exc_Msg
4829: ( G_PKG_NAME
4830: , 'Ship_Method'

Line 4828: OE_MSG_PUB.Add_Exc_Msg

4824: WHEN OTHERS THEN
4825:
4826: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4827: THEN
4828: OE_MSG_PUB.Add_Exc_Msg
4829: ( G_PKG_NAME
4830: , 'Ship_Method'
4831: );
4832: END IF;

Line 4863: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4859: EXCEPTION
4860:
4861: WHEN NO_DATA_FOUND THEN
4862:
4863: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4864: THEN
4865:
4866: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4867: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Agreement_Source_Code');

Line 4868: OE_MSG_PUB.Add;

4864: THEN
4865:
4866: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4867: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Agreement_Source_Code');
4868: OE_MSG_PUB.Add;
4869:
4870: END IF;
4871:
4872: RETURN FND_API.G_MISS_CHAR;

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

4872: RETURN FND_API.G_MISS_CHAR;
4873:
4874: WHEN OTHERS THEN
4875:
4876: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4877: THEN
4878: OE_MSG_PUB.Add_Exc_Msg
4879: ( G_PKG_NAME
4880: , 'Agreement_Source'

Line 4878: OE_MSG_PUB.Add_Exc_Msg

4874: WHEN OTHERS THEN
4875:
4876: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4877: THEN
4878: OE_MSG_PUB.Add_Exc_Msg
4879: ( G_PKG_NAME
4880: , 'Agreement_Source'
4881: );
4882: END IF;

Line 4914: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4910: EXCEPTION
4911:
4912: WHEN NO_DATA_FOUND THEN
4913:
4914: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4915: THEN
4916:
4917: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4918: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Term_Id');

Line 4919: OE_MSG_PUB.Add;

4915: THEN
4916:
4917: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4918: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Term_Id');
4919: OE_MSG_PUB.Add;
4920:
4921: END IF;
4922:
4923: RETURN FND_API.G_MISS_CHAR;

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

4923: RETURN FND_API.G_MISS_CHAR;
4924:
4925: WHEN OTHERS THEN
4926:
4927: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4928: THEN
4929: OE_MSG_PUB.Add_Exc_Msg
4930: ( G_PKG_NAME
4931: , 'Term'

Line 4929: OE_MSG_PUB.Add_Exc_Msg

4925: WHEN OTHERS THEN
4926:
4927: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4928: THEN
4929: OE_MSG_PUB.Add_Exc_Msg
4930: ( G_PKG_NAME
4931: , 'Term'
4932: );
4933: END IF;

Line 4995: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4991: EXCEPTION
4992:
4993: WHEN NO_DATA_FOUND THEN
4994:
4995: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4996: THEN
4997:
4998: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4999: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Flex_Meaning_To_Value_Id');

Line 5000: OE_MSG_PUB.Add;

4996: THEN
4997:
4998: fnd_message.set_name('QP','QP_VALUE_TO_ID_ERROR');
4999: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Flex_Meaning_To_Value_Id');
5000: OE_MSG_PUB.Add;
5001:
5002: END IF;
5003:
5004: WHEN OTHERS THEN

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

5002: END IF;
5003:
5004: WHEN OTHERS THEN
5005:
5006: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5007: THEN
5008: OE_MSG_PUB.Add_Exc_Msg
5009: ( G_PKG_NAME
5010: , 'Flex_Meaning_To_Value_Id'

Line 5008: OE_MSG_PUB.Add_Exc_Msg

5004: WHEN OTHERS THEN
5005:
5006: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5007: THEN
5008: OE_MSG_PUB.Add_Exc_Msg
5009: ( G_PKG_NAME
5010: , 'Flex_Meaning_To_Value_Id'
5011: );
5012: END IF;