[Home] [Help]
336: BEGIN
337: Debug_Msg('Started Get_Gdsn_Intf_Rows');
338: Debug_Msg('Initializing the fnd error stack');
339: -- initializing the fnd error stack
340: FND_MSG_PUB.Initialize;
341:
342: FOR i IN c_uom_code LOOP
343: l_uom_tbl(i.APPLICATION_COLUMN_NAME) := i.UOM_CODE;
344: END LOOP;
351: EXCEPTION WHEN l_conversion_error THEN
352: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_TRADE_ITEM_A_CONSUMER_UNIT');
353: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
354: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
355: FND_MSG_PUB.ADD;
356: END;
357:
358: BEGIN
359: l_single_row_attrs.GROSS_WEIGHT := j.GROSS_WEIGHT;
364: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'GROSS_WEIGHT');
365: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
366: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
367: FND_MESSAGE.Set_Token('ATTR_VALUE', j.GROSS_WEIGHT);
368: FND_MSG_PUB.ADD;
369: END;
370:
371: l_single_row_attrs.UOM_GROSS_WEIGHT := l_uom_tbl('GROSS_WEIGHT');
372:
376: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'EFFECTIVE_DATE');
377: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
378: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
379: FND_MESSAGE.Set_Token('ATTR_VALUE', j.EFFECTIVE_DATE);
380: FND_MSG_PUB.ADD;
381: END;
382:
383: BEGIN
384: l_single_row_attrs.END_AVAILABILITY_DATE_TIME := j.END_AVAILABILITY_DATE_TIME;
386: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'END_AVAILABILITY_DATE_TIME');
387: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
388: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
389: FND_MESSAGE.Set_Token('ATTR_VALUE', j.END_AVAILABILITY_DATE_TIME);
390: FND_MSG_PUB.ADD;
391: END;
392:
393: BEGIN
394: l_single_row_attrs.START_AVAILABILITY_DATE_TIME := j.START_AVAILABILITY_DATE_TIME;
396: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'START_AVAILABILITY_DATE_TIME');
397: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
398: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
399: FND_MESSAGE.Set_Token('ATTR_VALUE', j.START_AVAILABILITY_DATE_TIME);
400: FND_MSG_PUB.ADD;
401: END;
402:
403: BEGIN
404: l_single_row_attrs.BRAND_NAME := j.BRAND_NAME;
406: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'BRAND_NAME');
407: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
408: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
409: FND_MESSAGE.Set_Token('ATTR_VALUE', j.BRAND_NAME);
410: FND_MSG_PUB.ADD;
411: END;
412:
413: BEGIN
414: l_single_row_attrs.IS_TRADE_ITEM_A_BASE_UNIT := j.IS_TRADE_ITEM_A_BASE_UNIT;
416: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_TRADE_ITEM_A_BASE_UNIT');
417: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
418: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
419: FND_MESSAGE.Set_Token('ATTR_VALUE', j.IS_TRADE_ITEM_A_BASE_UNIT);
420: FND_MSG_PUB.ADD;
421: END;
422:
423: BEGIN
424: l_single_row_attrs.IS_TRADE_ITEM_A_VARIABLE_UNIT := j.IS_TRADE_ITEM_A_VARIABLE_UNIT;
426: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_TRADE_ITEM_A_VARIABLE_UNIT');
427: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
428: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
429: FND_MESSAGE.Set_Token('ATTR_VALUE', j.IS_TRADE_ITEM_A_VARIABLE_UNIT);
430: FND_MSG_PUB.ADD;
431: END;
432:
433: BEGIN
434: l_single_row_attrs.IS_PACK_MARKED_WITH_EXP_DATE := j.IS_PACK_MARKED_WITH_EXP_DATE;
436: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_PACK_MARKED_WITH_EXP_DATE');
437: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
438: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
439: FND_MESSAGE.Set_Token('ATTR_VALUE', j.IS_PACK_MARKED_WITH_EXP_DATE);
440: FND_MSG_PUB.ADD;
441: END;
442:
443: BEGIN
444: l_single_row_attrs.IS_PACK_MARKED_WITH_GREEN_DOT := j.IS_PACK_MARKED_WITH_GREEN_DOT;
446: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_PACK_MARKED_WITH_GREEN_DOT');
447: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
448: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
449: FND_MESSAGE.Set_Token('ATTR_VALUE', j.IS_PACK_MARKED_WITH_GREEN_DOT);
450: FND_MSG_PUB.ADD;
451: END;
452:
453: BEGIN
454: l_single_row_attrs.IS_PACK_MARKED_WITH_INGRED := j.IS_PACK_MARKED_WITH_INGRED;
456: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_PACK_MARKED_WITH_INGRED');
457: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
458: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
459: FND_MESSAGE.Set_Token('ATTR_VALUE', j.IS_PACK_MARKED_WITH_INGRED);
460: FND_MSG_PUB.ADD;
461: END;
462:
463: BEGIN
464: l_single_row_attrs.IS_PACKAGE_MARKED_AS_REC := j.IS_PACKAGE_MARKED_AS_REC;
466: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_PACKAGE_MARKED_AS_REC');
467: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
468: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
469: FND_MESSAGE.Set_Token('ATTR_VALUE', j.IS_PACKAGE_MARKED_AS_REC);
470: FND_MSG_PUB.ADD;
471: END;
472:
473: BEGIN
474: l_single_row_attrs.IS_PACKAGE_MARKED_RET := j.IS_PACKAGE_MARKED_RET;
476: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_PACKAGE_MARKED_RET');
477: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
478: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
479: FND_MESSAGE.Set_Token('ATTR_VALUE', j.IS_PACKAGE_MARKED_RET);
480: FND_MSG_PUB.ADD;
481: END;
482:
483: BEGIN
484: l_single_row_attrs.STACKING_FACTOR := j.STACKING_FACTOR;
489: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'STACKING_FACTOR');
490: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
491: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
492: FND_MESSAGE.Set_Token('ATTR_VALUE', j.STACKING_FACTOR);
493: FND_MSG_PUB.ADD;
494: END;
495:
496: BEGIN
497: l_single_row_attrs.STACKING_WEIGHT_MAXIMUM := j.STACKING_WEIGHT_MAXIMUM;
502: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'STACKING_WEIGHT_MAXIMUM');
503: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
504: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
505: FND_MESSAGE.Set_Token('ATTR_VALUE', j.STACKING_WEIGHT_MAXIMUM);
506: FND_MSG_PUB.ADD;
507: END;
508:
509: l_single_row_attrs.UOM_STACKING_WEIGHT_MAXIMUM := l_uom_tbl('STACKING_WEIGHT_MAXIMUM');
510:
517: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'ORDERING_LEAD_TIME');
518: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
519: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
520: FND_MESSAGE.Set_Token('ATTR_VALUE', j.ORDERING_LEAD_TIME);
521: FND_MSG_PUB.ADD;
522: END;
523:
524: l_single_row_attrs.UOM_ORDERING_LEAD_TIME := l_uom_tbl('ORDERING_LEAD_TIME');
525:
532: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'ORDER_QUANTITY_MAX');
533: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
534: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
535: FND_MESSAGE.Set_Token('ATTR_VALUE', j.ORDER_QUANTITY_MAX);
536: FND_MSG_PUB.ADD;
537: END;
538:
539: BEGIN
540: l_single_row_attrs.ORDER_QUANTITY_MIN := j.ORDER_QUANTITY_MIN;
545: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'ORDER_QUANTITY_MIN');
546: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
547: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
548: FND_MESSAGE.Set_Token('ATTR_VALUE', j.ORDER_QUANTITY_MIN);
549: FND_MSG_PUB.ADD;
550: END;
551:
552: BEGIN
553: l_single_row_attrs.ORDER_QUANTITY_MULTIPLE := j.ORDER_QUANTITY_MULTIPLE;
558: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'ORDER_QUANTITY_MULTIPLE');
559: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
560: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
561: FND_MESSAGE.Set_Token('ATTR_VALUE', j.ORDER_QUANTITY_MULTIPLE);
562: FND_MSG_PUB.ADD;
563: END;
564:
565: BEGIN
566: l_single_row_attrs.ORDER_SIZING_FACTOR := j.ORDER_SIZING_FACTOR;
571: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'ORDER_SIZING_FACTOR');
572: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
573: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
574: FND_MESSAGE.Set_Token('ATTR_VALUE', j.ORDER_SIZING_FACTOR);
575: FND_MSG_PUB.ADD;
576: END;
577:
578: BEGIN
579: l_single_row_attrs.EFFECTIVE_START_DATE := j.EFFECTIVE_START_DATE;
581: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'EFFECTIVE_START_DATE');
582: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
583: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
584: FND_MESSAGE.Set_Token('ATTR_VALUE', j.EFFECTIVE_START_DATE);
585: FND_MSG_PUB.ADD;
586: END;
587:
588: BEGIN
589: l_single_row_attrs.CATALOG_PRICE := j.CATALOG_PRICE;
594: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'CATALOG_PRICE');
595: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
596: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
597: FND_MESSAGE.Set_Token('ATTR_VALUE', j.CATALOG_PRICE);
598: FND_MSG_PUB.ADD;
599: END;
600:
601: BEGIN
602: l_single_row_attrs.EFFECTIVE_END_DATE := j.EFFECTIVE_END_DATE;
604: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'EFFECTIVE_END_DATE');
605: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
606: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
607: FND_MESSAGE.Set_Token('ATTR_VALUE', j.EFFECTIVE_END_DATE);
608: FND_MSG_PUB.ADD;
609: END;
610:
611: BEGIN
612: l_single_row_attrs.SUGGESTED_RETAIL_PRICE := j.SUGGESTED_RETAIL_PRICE;
617: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'SUGGESTED_RETAIL_PRICE');
618: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
619: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
620: FND_MESSAGE.Set_Token('ATTR_VALUE', j.SUGGESTED_RETAIL_PRICE);
621: FND_MSG_PUB.ADD;
622: END;
623:
624: BEGIN
625: l_single_row_attrs.MATERIAL_SAFETY_DATA_SHEET_NO := j.MATERIAL_SAFETY_DATA_SHEET_NO;
627: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'MATERIAL_SAFETY_DATA_SHEET_NO');
628: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
629: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
630: FND_MESSAGE.Set_Token('ATTR_VALUE', j.MATERIAL_SAFETY_DATA_SHEET_NO);
631: FND_MSG_PUB.ADD;
632: END;
633:
634: BEGIN
635: l_single_row_attrs.HAS_BATCH_NUMBER := j.HAS_BATCH_NUMBER;
637: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'HAS_BATCH_NUMBER');
638: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
639: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
640: FND_MESSAGE.Set_Token('ATTR_VALUE', j.HAS_BATCH_NUMBER);
641: FND_MSG_PUB.ADD;
642: END;
643:
644: BEGIN
645: l_single_row_attrs.IS_NON_SOLD_TRADE_RET_FLAG := j.IS_NON_SOLD_TRADE_RET_FLAG;
647: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_NON_SOLD_TRADE_RET_FLAG');
648: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
649: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
650: FND_MESSAGE.Set_Token('ATTR_VALUE', j.IS_NON_SOLD_TRADE_RET_FLAG);
651: FND_MSG_PUB.ADD;
652: END;
653:
654: BEGIN
655: l_single_row_attrs.IS_TRADE_ITEM_MAR_REC_FLAG := j.IS_TRADE_ITEM_MAR_REC_FLAG;
657: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_TRADE_ITEM_MAR_REC_FLAG');
658: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
659: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
660: FND_MESSAGE.Set_Token('ATTR_VALUE', j.IS_TRADE_ITEM_MAR_REC_FLAG);
661: FND_MSG_PUB.ADD;
662: END;
663:
664: BEGIN
665: l_single_row_attrs.DIAMETER := j.DIAMETER;
670: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DIAMETER');
671: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
672: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
673: FND_MESSAGE.Set_Token('ATTR_VALUE', j.DIAMETER);
674: FND_MSG_PUB.ADD;
675: END;
676:
677: l_single_row_attrs.UOM_DIAMETER := l_uom_tbl('DIAMETER');
678:
685: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DRAINED_WEIGHT');
686: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
687: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
688: FND_MESSAGE.Set_Token('ATTR_VALUE', j.DRAINED_WEIGHT);
689: FND_MSG_PUB.ADD;
690: END;
691:
692: l_single_row_attrs.UOM_DRAINED_WEIGHT := l_uom_tbl('DRAINED_WEIGHT');
693:
697: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'GENERIC_INGREDIENT');
698: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
699: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
700: FND_MESSAGE.Set_Token('ATTR_VALUE', j.GENERIC_INGREDIENT);
701: FND_MSG_PUB.ADD;
702: END;
703:
704: BEGIN
705: l_single_row_attrs.GENERIC_INGREDIENT_STRGTH := j.GENERIC_INGREDIENT_STRGTH;
710: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'GENERIC_INGREDIENT_STRGTH');
711: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
712: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
713: FND_MESSAGE.Set_Token('ATTR_VALUE', j.GENERIC_INGREDIENT_STRGTH);
714: FND_MSG_PUB.ADD;
715: END;
716:
717: l_single_row_attrs.UOM_GENERIC_INGREDIENT_STRGTH := l_uom_tbl('GENERIC_INGREDIENT_STRGTH');
718:
722: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'INGREDIENT_STRENGTH');
723: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
724: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
725: FND_MESSAGE.Set_Token('ATTR_VALUE', j.INGREDIENT_STRENGTH);
726: FND_MSG_PUB.ADD;
727: END;
728:
729: BEGIN
730: l_single_row_attrs.IS_NET_CONTENT_DEC_FLAG := j.IS_NET_CONTENT_DEC_FLAG;
732: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_NET_CONTENT_DEC_FLAG');
733: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
734: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
735: FND_MESSAGE.Set_Token('ATTR_VALUE', j.IS_NET_CONTENT_DEC_FLAG);
736: FND_MSG_PUB.ADD;
737: END;
738:
739: BEGIN
740: l_single_row_attrs.NET_CONTENT := j.NET_CONTENT;
745: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'NET_CONTENT');
746: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
747: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
748: FND_MESSAGE.Set_Token('ATTR_VALUE', j.NET_CONTENT);
749: FND_MSG_PUB.ADD;
750: END;
751:
752: BEGIN
753: l_single_row_attrs.UOM_NET_CONTENT := j.UOM_NET_CONTENT;
755: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'UOM_NET_CONTENT');
756: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
757: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
758: FND_MESSAGE.Set_Token('ATTR_VALUE', j.UOM_NET_CONTENT);
759: FND_MSG_PUB.ADD;
760: END;
761:
762: BEGIN
763: l_single_row_attrs.PEG_HORIZONTAL := j.PEG_HORIZONTAL;
768: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'PEG_HORIZONTAL');
769: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
770: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
771: FND_MESSAGE.Set_Token('ATTR_VALUE', j.PEG_HORIZONTAL);
772: FND_MSG_PUB.ADD;
773: END;
774:
775: l_single_row_attrs.UOM_PEG_HORIZONTAL := l_uom_tbl('PEG_HORIZONTAL');
776:
783: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'PEG_VERTICAL');
784: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
785: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
786: FND_MESSAGE.Set_Token('ATTR_VALUE', j.PEG_VERTICAL);
787: FND_MSG_PUB.ADD;
788: END;
789:
790: l_single_row_attrs.UOM_PEG_VERTICAL := l_uom_tbl('PEG_VERTICAL');
791:
795: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'CONSUMER_AVAIL_DATE_TIME');
796: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
797: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
798: FND_MESSAGE.Set_Token('ATTR_VALUE', j.CONSUMER_AVAIL_DATE_TIME);
799: FND_MSG_PUB.ADD;
800: END;
801:
802: BEGIN
803: l_single_row_attrs.DEL_TO_DIST_CNTR_TEMP_MAX := j.DEL_TO_DIST_CNTR_TEMP_MAX;
808: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DEL_TO_DIST_CNTR_TEMP_MAX');
809: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
810: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
811: FND_MESSAGE.Set_Token('ATTR_VALUE', j.DEL_TO_DIST_CNTR_TEMP_MAX);
812: FND_MSG_PUB.ADD;
813: END;
814:
815: BEGIN
816: l_single_row_attrs.UOM_DEL_TO_DIST_CNTR_TEMP_MAX := j.UOM_DEL_TO_DIST_CNTR_TEMP_MAX;
818: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'UOM_DEL_TO_DIST_CNTR_TEMP_MAX');
819: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
820: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
821: FND_MESSAGE.Set_Token('ATTR_VALUE', j.UOM_DEL_TO_DIST_CNTR_TEMP_MAX);
822: FND_MSG_PUB.ADD;
823: END;
824:
825: BEGIN
826: l_single_row_attrs.DEL_TO_DIST_CNTR_TEMP_MIN := j.DEL_TO_DIST_CNTR_TEMP_MIN;
831: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DEL_TO_DIST_CNTR_TEMP_MIN');
832: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
833: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
834: FND_MESSAGE.Set_Token('ATTR_VALUE', j.DEL_TO_DIST_CNTR_TEMP_MIN);
835: FND_MSG_PUB.ADD;
836: END;
837:
838: BEGIN
839: l_single_row_attrs.UOM_DEL_TO_DIST_CNTR_TEMP_MIN := j.UOM_DEL_TO_DIST_CNTR_TEMP_MIN;
841: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'UOM_DEL_TO_DIST_CNTR_TEMP_MIN');
842: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
843: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
844: FND_MESSAGE.Set_Token('ATTR_VALUE', j.UOM_DEL_TO_DIST_CNTR_TEMP_MIN);
845: FND_MSG_PUB.ADD;
846: END;
847:
848: BEGIN
849: l_single_row_attrs.DELIVERY_TO_MRKT_TEMP_MAX := j.DELIVERY_TO_MRKT_TEMP_MAX;
854: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DELIVERY_TO_MRKT_TEMP_MAX');
855: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
856: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
857: FND_MESSAGE.Set_Token('ATTR_VALUE', j.DELIVERY_TO_MRKT_TEMP_MAX);
858: FND_MSG_PUB.ADD;
859: END;
860:
861: BEGIN
862: l_single_row_attrs.UOM_DELIVERY_TO_MRKT_TEMP_MAX := j.UOM_DELIVERY_TO_MRKT_TEMP_MAX;
864: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'UOM_DELIVERY_TO_MRKT_TEMP_MAX');
865: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
866: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
867: FND_MESSAGE.Set_Token('ATTR_VALUE', j.UOM_DELIVERY_TO_MRKT_TEMP_MAX);
868: FND_MSG_PUB.ADD;
869: END;
870:
871: BEGIN
872: l_single_row_attrs.DELIVERY_TO_MRKT_TEMP_MIN := j.DELIVERY_TO_MRKT_TEMP_MIN;
877: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DELIVERY_TO_MRKT_TEMP_MIN');
878: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
879: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
880: FND_MESSAGE.Set_Token('ATTR_VALUE', j.DELIVERY_TO_MRKT_TEMP_MIN);
881: FND_MSG_PUB.ADD;
882: END;
883:
884: BEGIN
885: l_single_row_attrs.UOM_DELIVERY_TO_MRKT_TEMP_MIN := j.UOM_DELIVERY_TO_MRKT_TEMP_MIN;
887: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'UOM_DELIVERY_TO_MRKT_TEMP_MIN');
888: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
889: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
890: FND_MESSAGE.Set_Token('ATTR_VALUE', j.UOM_DELIVERY_TO_MRKT_TEMP_MIN);
891: FND_MSG_PUB.ADD;
892: END;
893:
894: BEGIN
895: l_single_row_attrs.SUB_BRAND := j.SUB_BRAND;
897: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'SUB_BRAND');
898: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
899: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
900: FND_MESSAGE.Set_Token('ATTR_VALUE', j.SUB_BRAND);
901: FND_MSG_PUB.ADD;
902: END;
903:
904: BEGIN
905: l_single_row_attrs.EANUCC_CODE := j.EANUCC_CODE;
907: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'EANUCC_CODE');
908: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
909: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
910: FND_MESSAGE.Set_Token('ATTR_VALUE', j.EANUCC_CODE);
911: FND_MSG_PUB.ADD;
912: END;
913:
914: BEGIN
915: l_single_row_attrs.EANUCC_TYPE := j.EANUCC_TYPE;
917: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'EANUCC_TYPE');
918: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
919: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
920: FND_MESSAGE.Set_Token('ATTR_VALUE', j.EANUCC_TYPE);
921: FND_MSG_PUB.ADD;
922: END;
923:
924: BEGIN
925: l_single_row_attrs.RETAIL_PRICE_ON_TRADE_ITEM := j.RETAIL_PRICE_ON_TRADE_ITEM;
930: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'RETAIL_PRICE_ON_TRADE_ITEM');
931: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
932: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
933: FND_MESSAGE.Set_Token('ATTR_VALUE', j.RETAIL_PRICE_ON_TRADE_ITEM);
934: FND_MSG_PUB.ADD;
935: END;
936:
937: BEGIN
938: l_single_row_attrs.QUANTITY_OF_COMP_LAY_ITEM := j.QUANTITY_OF_COMP_LAY_ITEM;
943: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'QUANTITY_OF_COMP_LAY_ITEM');
944: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
945: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
946: FND_MESSAGE.Set_Token('ATTR_VALUE', j.QUANTITY_OF_COMP_LAY_ITEM);
947: FND_MSG_PUB.ADD;
948: END;
949:
950: BEGIN
951: l_single_row_attrs.QUANITY_OF_ITEM_IN_LAYER := j.QUANITY_OF_ITEM_IN_LAYER;
956: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'QUANITY_OF_ITEM_IN_LAYER');
957: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
958: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
959: FND_MESSAGE.Set_Token('ATTR_VALUE', j.QUANITY_OF_ITEM_IN_LAYER);
960: FND_MSG_PUB.ADD;
961: END;
962:
963: BEGIN
964: l_single_row_attrs.QUANTITY_OF_ITEM_INNER_PACK := j.QUANTITY_OF_ITEM_INNER_PACK;
969: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'QUANTITY_OF_ITEM_INNER_PACK');
970: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
971: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
972: FND_MESSAGE.Set_Token('ATTR_VALUE', j.QUANTITY_OF_ITEM_INNER_PACK);
973: FND_MSG_PUB.ADD;
974: END;
975:
976: BEGIN
977: l_single_row_attrs.QUANTITY_OF_INNER_PACK := j.QUANTITY_OF_INNER_PACK;
982: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'QUANTITY_OF_INNER_PACK');
983: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
984: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
985: FND_MESSAGE.Set_Token('ATTR_VALUE', j.QUANTITY_OF_INNER_PACK);
986: FND_MSG_PUB.ADD;
987: END;
988:
989: BEGIN
990: l_single_row_attrs.BRAND_OWNER_GLN := j.BRAND_OWNER_GLN;
992: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'BRAND_OWNER_GLN');
993: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
994: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
995: FND_MESSAGE.Set_Token('ATTR_VALUE', j.BRAND_OWNER_GLN);
996: FND_MSG_PUB.ADD;
997: END;
998:
999: BEGIN
1000: l_single_row_attrs.BRAND_OWNER_NAME := j.BRAND_OWNER_NAME;
1002: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'BRAND_OWNER_NAME');
1003: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1004: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1005: FND_MESSAGE.Set_Token('ATTR_VALUE', j.BRAND_OWNER_NAME);
1006: FND_MSG_PUB.ADD;
1007: END;
1008:
1009: BEGIN
1010: l_single_row_attrs.STORAGE_HANDLING_TEMP_MAX := j.STORAGE_HANDLING_TEMP_MAX;
1015: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'STORAGE_HANDLING_TEMP_MAX');
1016: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1017: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1018: FND_MESSAGE.Set_Token('ATTR_VALUE', j.STORAGE_HANDLING_TEMP_MAX);
1019: FND_MSG_PUB.ADD;
1020: END;
1021:
1022: BEGIN
1023: l_single_row_attrs.UOM_STORAGE_HANDLING_TEMP_MAX := j.UOM_STORAGE_HANDLING_TEMP_MAX;
1025: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'UOM_STORAGE_HANDLING_TEMP_MAX');
1026: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1027: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1028: FND_MESSAGE.Set_Token('ATTR_VALUE', j.UOM_STORAGE_HANDLING_TEMP_MAX);
1029: FND_MSG_PUB.ADD;
1030: END;
1031:
1032: BEGIN
1033: l_single_row_attrs.STORAGE_HANDLING_TEMP_MIN := j.STORAGE_HANDLING_TEMP_MIN;
1038: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'STORAGE_HANDLING_TEMP_MIN');
1039: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1040: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1041: FND_MESSAGE.Set_Token('ATTR_VALUE', j.STORAGE_HANDLING_TEMP_MIN);
1042: FND_MSG_PUB.ADD;
1043: END;
1044:
1045: BEGIN
1046: l_single_row_attrs.UOM_STORAGE_HANDLING_TEMP_MIN := j.UOM_STORAGE_HANDLING_TEMP_MIN;
1048: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'UOM_STORAGE_HANDLING_TEMP_MIN');
1049: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1050: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1051: FND_MESSAGE.Set_Token('ATTR_VALUE', j.UOM_STORAGE_HANDLING_TEMP_MIN);
1052: FND_MSG_PUB.ADD;
1053: END;
1054:
1055: BEGIN
1056: l_single_row_attrs.TRADE_ITEM_COUPON := j.TRADE_ITEM_COUPON;
1061: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'TRADE_ITEM_COUPON');
1062: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1063: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1064: FND_MESSAGE.Set_Token('ATTR_VALUE', j.TRADE_ITEM_COUPON);
1065: FND_MSG_PUB.ADD;
1066: END;
1067:
1068: BEGIN
1069: l_single_row_attrs.DEGREE_OF_ORIGINAL_WORT := j.DEGREE_OF_ORIGINAL_WORT;
1071: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DEGREE_OF_ORIGINAL_WORT');
1072: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1073: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1074: FND_MESSAGE.Set_Token('ATTR_VALUE', j.DEGREE_OF_ORIGINAL_WORT);
1075: FND_MSG_PUB.ADD;
1076: END;
1077:
1078: BEGIN
1079: l_single_row_attrs.FAT_PERCENT_IN_DRY_MATTER := j.FAT_PERCENT_IN_DRY_MATTER;
1084: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'FAT_PERCENT_IN_DRY_MATTER');
1085: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1086: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1087: FND_MESSAGE.Set_Token('ATTR_VALUE', j.FAT_PERCENT_IN_DRY_MATTER);
1088: FND_MSG_PUB.ADD;
1089: END;
1090:
1091: BEGIN
1092: l_single_row_attrs.PERCENT_OF_ALCOHOL_BY_VOL := j.PERCENT_OF_ALCOHOL_BY_VOL;
1097: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'PERCENT_OF_ALCOHOL_BY_VOL');
1098: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1099: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1100: FND_MESSAGE.Set_Token('ATTR_VALUE', j.PERCENT_OF_ALCOHOL_BY_VOL);
1101: FND_MSG_PUB.ADD;
1102: END;
1103:
1104: BEGIN
1105: l_single_row_attrs.ISBN_NUMBER := j.ISBN_NUMBER;
1107: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'ISBN_NUMBER');
1108: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1109: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1110: FND_MESSAGE.Set_Token('ATTR_VALUE', j.ISBN_NUMBER);
1111: FND_MSG_PUB.ADD;
1112: END;
1113:
1114: BEGIN
1115: l_single_row_attrs.ISSN_NUMBER := j.ISSN_NUMBER;
1117: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'ISSN_NUMBER');
1118: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1119: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1120: FND_MESSAGE.Set_Token('ATTR_VALUE', j.ISSN_NUMBER);
1121: FND_MSG_PUB.ADD;
1122: END;
1123:
1124: BEGIN
1125: l_single_row_attrs.IS_INGREDIENT_IRRADIATED := j.IS_INGREDIENT_IRRADIATED;
1127: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_INGREDIENT_IRRADIATED');
1128: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1129: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1130: FND_MESSAGE.Set_Token('ATTR_VALUE', j.IS_INGREDIENT_IRRADIATED);
1131: FND_MSG_PUB.ADD;
1132: END;
1133:
1134: BEGIN
1135: l_single_row_attrs.IS_RAW_MATERIAL_IRRADIATED := j.IS_RAW_MATERIAL_IRRADIATED;
1137: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_RAW_MATERIAL_IRRADIATED');
1138: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1139: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1140: FND_MESSAGE.Set_Token('ATTR_VALUE', j.IS_RAW_MATERIAL_IRRADIATED);
1141: FND_MSG_PUB.ADD;
1142: END;
1143:
1144: BEGIN
1145: l_single_row_attrs.IS_TRADE_ITEM_GENETICALLY_MOD := j.IS_TRADE_ITEM_GENETICALLY_MOD;
1147: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_TRADE_ITEM_GENETICALLY_MOD');
1148: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1149: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1150: FND_MESSAGE.Set_Token('ATTR_VALUE', j.IS_TRADE_ITEM_GENETICALLY_MOD);
1151: FND_MSG_PUB.ADD;
1152: END;
1153:
1154: BEGIN
1155: l_single_row_attrs.IS_TRADE_ITEM_IRRADIATED := j.IS_TRADE_ITEM_IRRADIATED;
1157: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_TRADE_ITEM_IRRADIATED');
1158: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1159: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1160: FND_MESSAGE.Set_Token('ATTR_VALUE', j.IS_TRADE_ITEM_IRRADIATED);
1161: FND_MSG_PUB.ADD;
1162: END;
1163:
1164: BEGIN
1165: l_single_row_attrs.SECURITY_TAG_LOCATION := j.SECURITY_TAG_LOCATION;
1167: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'SECURITY_TAG_LOCATION');
1168: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1169: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1170: FND_MESSAGE.Set_Token('ATTR_VALUE', j.SECURITY_TAG_LOCATION);
1171: FND_MSG_PUB.ADD;
1172: END;
1173:
1174: BEGIN
1175: l_single_row_attrs.URL_FOR_WARRANTY := j.URL_FOR_WARRANTY;
1177: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'URL_FOR_WARRANTY');
1178: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1179: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1180: FND_MESSAGE.Set_Token('ATTR_VALUE', j.URL_FOR_WARRANTY);
1181: FND_MSG_PUB.ADD;
1182: END;
1183:
1184: BEGIN
1185: l_single_row_attrs.NESTING_INCREMENT := j.NESTING_INCREMENT;
1190: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'NESTING_INCREMENT');
1191: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1192: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1193: FND_MESSAGE.Set_Token('ATTR_VALUE', j.NESTING_INCREMENT);
1194: FND_MSG_PUB.ADD;
1195: END;
1196:
1197: l_single_row_attrs.UOM_NESTING_INCREMENT := l_uom_tbl('NESTING_INCREMENT');
1198:
1202: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_TRADE_ITEM_RECALLED');
1203: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1204: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1205: FND_MESSAGE.Set_Token('ATTR_VALUE', j.IS_TRADE_ITEM_RECALLED);
1206: FND_MSG_PUB.ADD;
1207: END;
1208:
1209: BEGIN
1210: l_single_row_attrs.MODEL_NUMBER := j.MODEL_NUMBER;
1212: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'MODEL_NUMBER');
1213: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1214: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1215: FND_MESSAGE.Set_Token('ATTR_VALUE', j.MODEL_NUMBER);
1216: FND_MSG_PUB.ADD;
1217: END;
1218:
1219: BEGIN
1220: l_single_row_attrs.PIECES_PER_TRADE_ITEM := j.PIECES_PER_TRADE_ITEM;
1225: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'PIECES_PER_TRADE_ITEM');
1226: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1227: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1228: FND_MESSAGE.Set_Token('ATTR_VALUE', j.PIECES_PER_TRADE_ITEM);
1229: FND_MSG_PUB.ADD;
1230: END;
1231:
1232: l_single_row_attrs.UOM_PIECES_PER_TRADE_ITEM := l_uom_tbl('PIECES_PER_TRADE_ITEM');
1233:
1237: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DEPT_OF_TRNSPRT_DANG_GOODS_NUM');
1238: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1239: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1240: FND_MESSAGE.Set_Token('ATTR_VALUE', j.DEPT_OF_TRNSPRT_DANG_GOODS_NUM);
1241: FND_MSG_PUB.ADD;
1242: END;
1243:
1244: BEGIN
1245: l_single_row_attrs.RETURN_GOODS_POLICY := j.RETURN_GOODS_POLICY;
1247: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'RETURN_GOODS_POLICY');
1248: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1249: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1250: FND_MESSAGE.Set_Token('ATTR_VALUE', j.RETURN_GOODS_POLICY);
1251: FND_MSG_PUB.ADD;
1252: END;
1253:
1254: BEGIN
1255: l_single_row_attrs.IS_OUT_OF_BOX_PROVIDED := j.IS_OUT_OF_BOX_PROVIDED;
1257: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_OUT_OF_BOX_PROVIDED');
1258: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1259: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1260: FND_MESSAGE.Set_Token('ATTR_VALUE', j.IS_OUT_OF_BOX_PROVIDED);
1261: FND_MSG_PUB.ADD;
1262: END;
1263:
1264: BEGIN
1265: l_single_row_attrs.INVOICE_NAME := j.INVOICE_NAME;
1267: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'INVOICE_NAME');
1268: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1269: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1270: FND_MESSAGE.Set_Token('ATTR_VALUE', j.INVOICE_NAME);
1271: FND_MSG_PUB.ADD;
1272: END;
1273:
1274: BEGIN
1275: l_single_row_attrs.DESCRIPTIVE_SIZE := j.DESCRIPTIVE_SIZE;
1277: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DESCRIPTIVE_SIZE');
1278: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1279: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1280: FND_MESSAGE.Set_Token('ATTR_VALUE', j.DESCRIPTIVE_SIZE);
1281: FND_MSG_PUB.ADD;
1282: END;
1283:
1284: BEGIN
1285: l_single_row_attrs.FUNCTIONAL_NAME := j.FUNCTIONAL_NAME;
1287: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'FUNCTIONAL_NAME');
1288: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1289: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1290: FND_MESSAGE.Set_Token('ATTR_VALUE', j.FUNCTIONAL_NAME);
1291: FND_MSG_PUB.ADD;
1292: END;
1293:
1294: BEGIN
1295: l_single_row_attrs.TRADE_ITEM_FORM_DESCRIPTION := j.TRADE_ITEM_FORM_DESCRIPTION;
1297: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'TRADE_ITEM_FORM_DESCRIPTION');
1298: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1299: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1300: FND_MESSAGE.Set_Token('ATTR_VALUE', j.TRADE_ITEM_FORM_DESCRIPTION);
1301: FND_MSG_PUB.ADD;
1302: END;
1303:
1304: BEGIN
1305: l_single_row_attrs.WARRANTY_DESCRIPTION := j.WARRANTY_DESCRIPTION;
1307: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'WARRANTY_DESCRIPTION');
1308: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1309: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1310: FND_MESSAGE.Set_Token('ATTR_VALUE', j.WARRANTY_DESCRIPTION);
1311: FND_MSG_PUB.ADD;
1312: END;
1313:
1314: BEGIN
1315: l_single_row_attrs.TRADE_ITEM_FINISH_DESCRIPTION := j.TRADE_ITEM_FINISH_DESCRIPTION;
1317: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'TRADE_ITEM_FINISH_DESCRIPTION');
1318: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1319: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1320: FND_MESSAGE.Set_Token('ATTR_VALUE', j.TRADE_ITEM_FINISH_DESCRIPTION);
1321: FND_MSG_PUB.ADD;
1322: END;
1323:
1324: BEGIN
1325: l_single_row_attrs.DESCRIPTION_SHORT := j.DESCRIPTION_SHORT;
1327: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DESCRIPTION_SHORT');
1328: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1329: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1330: FND_MESSAGE.Set_Token('ATTR_VALUE', j.DESCRIPTION_SHORT);
1331: FND_MSG_PUB.ADD;
1332: END;
1333:
1334: BEGIN
1335: l_single_row_attrs.IS_BARCODE_SYMBOLOGY_DERIVABLE := j.IS_BARCODE_SYMBOLOGY_DERIVABLE;
1337: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_BARCODE_SYMBOLOGY_DERIVABLE');
1338: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1339: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1340: FND_MESSAGE.Set_Token('ATTR_VALUE', j.IS_BARCODE_SYMBOLOGY_DERIVABLE);
1341: FND_MSG_PUB.ADD;
1342: END;
1343: END LOOP; -- end loop single row attributes
1344:
1345: Debug_Msg('Finished Populating local array for Single Row Attributes');
1353: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'MANUFACTURER_GLN');
1354: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1355: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1356: FND_MESSAGE.Set_Token('ATTR_VALUE', j.MANUFACTURER_GLN);
1357: FND_MSG_PUB.ADD;
1358: END;
1359:
1360: BEGIN
1361: l_multi_row_attrs(k).MANUFACTURER_ID := j.MANUFACTURER_ID;
1366: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'MANUFACTURER_ID');
1367: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1368: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1369: FND_MESSAGE.Set_Token('ATTR_VALUE', j.MANUFACTURER_ID);
1370: FND_MSG_PUB.ADD;
1371: END;
1372:
1373: BEGIN
1374: l_multi_row_attrs(k).BAR_CODE_TYPE := j.BAR_CODE_TYPE;
1376: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'BAR_CODE_TYPE');
1377: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1378: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1379: FND_MESSAGE.Set_Token('ATTR_VALUE', j.BAR_CODE_TYPE);
1380: FND_MSG_PUB.ADD;
1381: END;
1382:
1383: BEGIN
1384: l_multi_row_attrs(k).COLOR_CODE_LIST_AGENCY := j.COLOR_CODE_LIST_AGENCY;
1386: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'COLOR_CODE_LIST_AGENCY');
1387: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1388: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1389: FND_MESSAGE.Set_Token('ATTR_VALUE', j.COLOR_CODE_LIST_AGENCY);
1390: FND_MSG_PUB.ADD;
1391: END;
1392:
1393: BEGIN
1394: l_multi_row_attrs(k).COLOR_CODE_VALUE := j.COLOR_CODE_VALUE;
1396: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'COLOR_CODE_VALUE');
1397: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1398: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1399: FND_MESSAGE.Set_Token('ATTR_VALUE', j.COLOR_CODE_VALUE);
1400: FND_MSG_PUB.ADD;
1401: END;
1402:
1403: BEGIN
1404: l_multi_row_attrs(k).CLASS_OF_DANGEROUS_CODE := j.CLASS_OF_DANGEROUS_CODE;
1406: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'CLASS_OF_DANGEROUS_CODE');
1407: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1408: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1409: FND_MESSAGE.Set_Token('ATTR_VALUE', j.CLASS_OF_DANGEROUS_CODE);
1410: FND_MSG_PUB.ADD;
1411: END;
1412:
1413: BEGIN
1414: l_multi_row_attrs(k).DANGEROUS_GOODS_MARGIN_NUMBER := j.DANGEROUS_GOODS_MARGIN_NUMBER;
1416: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'DANGEROUS_GOODS_MARGIN_NUMBER');
1417: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1418: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1419: FND_MESSAGE.Set_Token('ATTR_VALUE', j.DANGEROUS_GOODS_MARGIN_NUMBER);
1420: FND_MSG_PUB.ADD;
1421: END;
1422:
1423: BEGIN
1424: l_multi_row_attrs(k).DANGEROUS_GOODS_HAZARDOUS_CODE := j.DANGEROUS_GOODS_HAZARDOUS_CODE;
1426: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'DANGEROUS_GOODS_HAZARDOUS_CODE');
1427: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1428: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1429: FND_MESSAGE.Set_Token('ATTR_VALUE', j.DANGEROUS_GOODS_HAZARDOUS_CODE);
1430: FND_MSG_PUB.ADD;
1431: END;
1432:
1433: BEGIN
1434: l_multi_row_attrs(k).DANGEROUS_GOODS_PACK_GROUP := j.DANGEROUS_GOODS_PACK_GROUP;
1436: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'DANGEROUS_GOODS_PACK_GROUP');
1437: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1438: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1439: FND_MESSAGE.Set_Token('ATTR_VALUE', j.DANGEROUS_GOODS_PACK_GROUP);
1440: FND_MSG_PUB.ADD;
1441: END;
1442:
1443: BEGIN
1444: l_multi_row_attrs(k).DANGEROUS_GOODS_REG_CODE := j.DANGEROUS_GOODS_REG_CODE;
1446: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'DANGEROUS_GOODS_REG_CODE');
1447: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1448: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1449: FND_MESSAGE.Set_Token('ATTR_VALUE', j.DANGEROUS_GOODS_REG_CODE);
1450: FND_MSG_PUB.ADD;
1451: END;
1452:
1453: BEGIN
1454: l_multi_row_attrs(k).DANGEROUS_GOODS_SHIPPING_NAME := j.DANGEROUS_GOODS_SHIPPING_NAME;
1456: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'DANGEROUS_GOODS_SHIPPING_NAME');
1457: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1458: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1459: FND_MESSAGE.Set_Token('ATTR_VALUE', j.DANGEROUS_GOODS_SHIPPING_NAME);
1460: FND_MSG_PUB.ADD;
1461: END;
1462:
1463: BEGIN
1464: l_multi_row_attrs(k).UNITED_NATIONS_DANG_GOODS_NO := j.UNITED_NATIONS_DANG_GOODS_NO;
1469: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'UNITED_NATIONS_DANG_GOODS_NO');
1470: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1471: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1472: FND_MESSAGE.Set_Token('ATTR_VALUE', j.UNITED_NATIONS_DANG_GOODS_NO);
1473: FND_MSG_PUB.ADD;
1474: END;
1475:
1476: BEGIN
1477: l_multi_row_attrs(k).FLASH_POINT_TEMP := j.FLASH_POINT_TEMP;
1482: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'FLASH_POINT_TEMP');
1483: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1484: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1485: FND_MESSAGE.Set_Token('ATTR_VALUE', j.FLASH_POINT_TEMP);
1486: FND_MSG_PUB.ADD;
1487: END;
1488:
1489: BEGIN
1490: l_multi_row_attrs(k).UOM_FLASH_POINT_TEMP := j.UOM_FLASH_POINT_TEMP;
1492: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'UOM_FLASH_POINT_TEMP');
1493: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1494: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1495: FND_MESSAGE.Set_Token('ATTR_VALUE', j.UOM_FLASH_POINT_TEMP);
1496: FND_MSG_PUB.ADD;
1497: END;
1498:
1499: BEGIN
1500: l_multi_row_attrs(k).COUNTRY_OF_ORIGIN := j.COUNTRY_OF_ORIGIN;
1502: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'COUNTRY_OF_ORIGIN');
1503: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1504: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1505: FND_MESSAGE.Set_Token('ATTR_VALUE', j.COUNTRY_OF_ORIGIN);
1506: FND_MSG_PUB.ADD;
1507: END;
1508:
1509: BEGIN
1510: l_multi_row_attrs(k).HARMONIZED_TARIFF_SYS_ID_CODE := j.HARMONIZED_TARIFF_SYS_ID_CODE;
1515: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'HARMONIZED_TARIFF_SYS_ID_CODE');
1516: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1517: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1518: FND_MESSAGE.Set_Token('ATTR_VALUE', j.HARMONIZED_TARIFF_SYS_ID_CODE);
1519: FND_MSG_PUB.ADD;
1520: END;
1521:
1522: BEGIN
1523: l_multi_row_attrs(k).SIZE_CODE_LIST_AGENCY := j.SIZE_CODE_LIST_AGENCY;
1525: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'SIZE_CODE_LIST_AGENCY');
1526: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1527: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1528: FND_MESSAGE.Set_Token('ATTR_VALUE', j.SIZE_CODE_LIST_AGENCY);
1529: FND_MSG_PUB.ADD;
1530: END;
1531:
1532: BEGIN
1533: l_multi_row_attrs(k).SIZE_CODE_VALUE := j.SIZE_CODE_VALUE;
1535: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'SIZE_CODE_VALUE');
1536: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1537: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1538: FND_MESSAGE.Set_Token('ATTR_VALUE', j.SIZE_CODE_VALUE);
1539: FND_MSG_PUB.ADD;
1540: END;
1541:
1542: BEGIN
1543: l_multi_row_attrs(k).HANDLING_INSTRUCTIONS_CODE := j.HANDLING_INSTRUCTIONS_CODE;
1545: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'HANDLING_INSTRUCTIONS_CODE');
1546: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1547: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1548: FND_MESSAGE.Set_Token('ATTR_VALUE', j.HANDLING_INSTRUCTIONS_CODE);
1549: FND_MSG_PUB.ADD;
1550: END;
1551:
1552: BEGIN
1553: l_multi_row_attrs(k).DANGEROUS_GOODS_TECHNICAL_NAME := j.DANGEROUS_GOODS_TECHNICAL_NAME;
1555: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'DANGEROUS_GOODS_TECHNICAL_NAME');
1556: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1557: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1558: FND_MESSAGE.Set_Token('ATTR_VALUE', j.DANGEROUS_GOODS_TECHNICAL_NAME);
1559: FND_MSG_PUB.ADD;
1560: END;
1561:
1562: BEGIN
1563: l_multi_row_attrs(k).DELIVERY_METHOD_INDICATOR := j.DELIVERY_METHOD_INDICATOR;
1565: l_attr_name := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'DELIVERY_METHOD_INDICATOR');
1566: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_LENGTH_INVALID');
1567: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr_name);
1568: FND_MESSAGE.Set_Token('ATTR_VALUE', j.DELIVERY_METHOD_INDICATOR);
1569: FND_MSG_PUB.ADD;
1570: END;
1571:
1572: k := k + 1;
1573: END LOOP; -- end loop multi row attributes
1575: Debug_Msg('Finished Populating local array for Multi Row Attributes');
1576: x_singe_row_attrs_rec := l_single_row_attrs ;
1577: x_multi_row_attrs_tbl := l_multi_row_attrs ;
1578:
1579: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
1580: IF x_msg_count > 0 THEN
1581: x_return_status := 'E';
1582: ELSE
1583: x_return_status := 'S';
1662:
1663: Debug_Msg('Marked Item as error in Interface table');
1664: IF l_msg_count > 0 AND l_return_status <> 'U' THEN
1665: FOR cnt IN 1..l_msg_count LOOP
1666: Debug_Msg('Error msg - '||cnt ||': '|| FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F'));
1667: l_msg_text := FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F');
1668: ERROR_HANDLER.Add_Error_Message
1669: (
1670: p_message_text => l_msg_text
1663: Debug_Msg('Marked Item as error in Interface table');
1664: IF l_msg_count > 0 AND l_return_status <> 'U' THEN
1665: FOR cnt IN 1..l_msg_count LOOP
1666: Debug_Msg('Error msg - '||cnt ||': '|| FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F'));
1667: l_msg_text := FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F');
1668: ERROR_HANDLER.Add_Error_Message
1669: (
1670: p_message_text => l_msg_text
1671: ,p_application_id => 'EGO'
1730: Debug_Msg('Marked Item as error in Interface table');
1731:
1732: IF l_msg_count > 0 AND l_return_status <> 'U' THEN
1733: FOR cnt IN 1..l_msg_count LOOP
1734: Debug_Msg('Error msg - '||cnt ||': '|| FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F'));
1735: l_msg_text := FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F');
1736: ERROR_HANDLER.Add_Error_Message
1737: (
1738: p_message_text => l_msg_text
1731:
1732: IF l_msg_count > 0 AND l_return_status <> 'U' THEN
1733: FOR cnt IN 1..l_msg_count LOOP
1734: Debug_Msg('Error msg - '||cnt ||': '|| FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F'));
1735: l_msg_text := FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F');
1736: ERROR_HANDLER.Add_Error_Message
1737: (
1738: p_message_text => l_msg_text
1739: ,p_application_id => 'EGO'
1941: l_continue := true;
1942: Debug_Msg('Starting GDSN Attributes Validations for Item,Org='||p_inventory_item_id||','||p_organization_id);
1943: Debug_Msg('Initializing the fnd error stack');
1944: -- initializing the fnd error stack
1945: FND_MSG_PUB.Initialize;
1946:
1947: Debug_Msg('Checking if Item is GDSN Enabled item');
1948:
1949: BEGIN
1971:
1972: IF NVL(l_gdsn_outbound_flag, 'N') = 'N' THEN
1973: Debug_Msg('Item is not a GDSN Enabled item, so returning');
1974: FND_MESSAGE.Set_Name('EGO', 'EGO_NOT_UCCNET_ITEM');
1975: FND_MSG_PUB.ADD;
1976: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
1977: x_return_status := 'E';
1978: RETURN;
1979: END IF;
1972: IF NVL(l_gdsn_outbound_flag, 'N') = 'N' THEN
1973: Debug_Msg('Item is not a GDSN Enabled item, so returning');
1974: FND_MESSAGE.Set_Name('EGO', 'EGO_NOT_UCCNET_ITEM');
1975: FND_MSG_PUB.ADD;
1976: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
1977: x_return_status := 'E';
1978: RETURN;
1979: END IF;
1980:
2011: IF l_trade_item_desc IS NULL
2012: THEN
2013: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_MISSING');
2014: FND_MESSAGE.Set_Token('ATTR_NAME', l_gtid_disp);
2015: FND_MSG_PUB.ADD;
2016: l_continue := FALSE;
2017: END IF;
2018:
2019: -- 2. If trade item descriptor is not BASE_UNIT_OR_EACH then check for attributes (which are non editable)
2030: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'ISSN_NUMBER');
2031: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2032: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2033: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2034: FND_MSG_PUB.ADD;
2035: END IF;
2036:
2037: IF NVL(p_singe_row_attrs_rec.ISBN_NUMBER, G_MISS_CHAR) <> G_MISS_CHAR
2038: OR (NVL(p_singe_row_attrs_rec.ISBN_NUMBER, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2041: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'ISBN_NUMBER');
2042: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2043: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2044: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2045: FND_MSG_PUB.ADD;
2046: END IF;
2047:
2048: IF NVL(p_singe_row_attrs_rec.PERCENT_OF_ALCOHOL_BY_VOL, G_MISS_NUM) <> G_MISS_NUM
2049: OR (NVL(p_singe_row_attrs_rec.PERCENT_OF_ALCOHOL_BY_VOL, -1) <> G_MISS_NUM AND
2052: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'PERCENT_OF_ALCOHOL_BY_VOL');
2053: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2054: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2055: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2056: FND_MSG_PUB.ADD;
2057: END IF;
2058:
2059: IF NVL(p_singe_row_attrs_rec.STORAGE_HANDLING_TEMP_MAX, G_MISS_NUM) <> G_MISS_NUM
2060: OR (NVL(p_singe_row_attrs_rec.STORAGE_HANDLING_TEMP_MAX, -1) <> G_MISS_NUM AND
2063: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'STORAGE_HANDLING_TEMP_MAX');
2064: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2065: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2066: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2067: FND_MSG_PUB.ADD;
2068: END IF;
2069:
2070: IF NVL(p_singe_row_attrs_rec.UOM_STORAGE_HANDLING_TEMP_MAX, G_MISS_CHAR) <> G_MISS_CHAR
2071: OR (NVL(p_singe_row_attrs_rec.UOM_STORAGE_HANDLING_TEMP_MAX, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2074: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'STORAGE_HANDLING_TEMP_MAX');
2075: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2076: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2077: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2078: FND_MSG_PUB.ADD;
2079: END IF;
2080:
2081: IF NVL(p_singe_row_attrs_rec.STORAGE_HANDLING_TEMP_MIN, G_MISS_NUM) <> G_MISS_NUM
2082: OR (NVL(p_singe_row_attrs_rec.STORAGE_HANDLING_TEMP_MIN, -1) <> G_MISS_NUM AND
2085: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'STORAGE_HANDLING_TEMP_MIN');
2086: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2087: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2088: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2089: FND_MSG_PUB.ADD;
2090: END IF;
2091:
2092: IF NVL(p_singe_row_attrs_rec.UOM_STORAGE_HANDLING_TEMP_MIN, G_MISS_CHAR) <> G_MISS_CHAR
2093: OR (NVL(p_singe_row_attrs_rec.UOM_STORAGE_HANDLING_TEMP_MIN, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2096: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'STORAGE_HANDLING_TEMP_MIN');
2097: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2098: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2099: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2100: FND_MSG_PUB.ADD;
2101: END IF;
2102:
2103: IF NVL(p_singe_row_attrs_rec.FAT_PERCENT_IN_DRY_MATTER, G_MISS_NUM) <> G_MISS_NUM
2104: OR (NVL(p_singe_row_attrs_rec.FAT_PERCENT_IN_DRY_MATTER, -1) <> G_MISS_NUM AND
2107: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'FAT_PERCENT_IN_DRY_MATTER');
2108: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2109: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2110: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2111: FND_MSG_PUB.ADD;
2112: END IF;
2113:
2114: IF NVL(p_singe_row_attrs_rec.DELIVERY_TO_MRKT_TEMP_MAX, G_MISS_NUM) <> G_MISS_NUM
2115: OR (NVL(p_singe_row_attrs_rec.DELIVERY_TO_MRKT_TEMP_MAX, -1) <> G_MISS_NUM AND
2118: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DELIVERY_TO_MRKT_TEMP_MAX');
2119: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2120: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2121: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2122: FND_MSG_PUB.ADD;
2123: END IF;
2124:
2125: IF NVL(p_singe_row_attrs_rec.UOM_DELIVERY_TO_MRKT_TEMP_MAX, G_MISS_CHAR) <> G_MISS_CHAR
2126: OR (NVL(p_singe_row_attrs_rec.UOM_DELIVERY_TO_MRKT_TEMP_MAX, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2129: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'UOM_DELIVERY_TO_MRKT_TEMP_MAX');
2130: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2131: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2132: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2133: FND_MSG_PUB.ADD;
2134: END IF;
2135:
2136: IF NVL(p_singe_row_attrs_rec.DEL_TO_DIST_CNTR_TEMP_MIN, G_MISS_NUM) <> G_MISS_NUM
2137: OR (NVL(p_singe_row_attrs_rec.DEL_TO_DIST_CNTR_TEMP_MIN, -1) <> G_MISS_NUM AND
2140: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DEL_TO_DIST_CNTR_TEMP_MIN');
2141: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2142: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2143: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2144: FND_MSG_PUB.ADD;
2145: END IF;
2146:
2147: IF NVL(p_singe_row_attrs_rec.UOM_DEL_TO_DIST_CNTR_TEMP_MIN, G_MISS_CHAR) <> G_MISS_CHAR
2148: OR (NVL(p_singe_row_attrs_rec.UOM_DEL_TO_DIST_CNTR_TEMP_MIN, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2151: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DEL_TO_DIST_CNTR_TEMP_MIN');
2152: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2153: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2154: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2155: FND_MSG_PUB.ADD;
2156: END IF;
2157:
2158: IF NVL(p_singe_row_attrs_rec.DEL_TO_DIST_CNTR_TEMP_MAX, G_MISS_NUM) <> G_MISS_NUM
2159: OR (NVL(p_singe_row_attrs_rec.DEL_TO_DIST_CNTR_TEMP_MAX, -1) <> G_MISS_NUM AND
2162: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DEL_TO_DIST_CNTR_TEMP_MAX');
2163: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2164: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2165: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2166: FND_MSG_PUB.ADD;
2167: END IF;
2168:
2169: IF NVL(p_singe_row_attrs_rec.UOM_DEL_TO_DIST_CNTR_TEMP_MAX, G_MISS_CHAR) <> G_MISS_CHAR
2170: OR (NVL(p_singe_row_attrs_rec.UOM_DEL_TO_DIST_CNTR_TEMP_MAX, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2173: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DEL_TO_DIST_CNTR_TEMP_MAX');
2174: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2175: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2176: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2177: FND_MSG_PUB.ADD;
2178: END IF;
2179:
2180: IF NVL(p_singe_row_attrs_rec.DELIVERY_TO_MRKT_TEMP_MIN, G_MISS_NUM) <> G_MISS_NUM
2181: OR (NVL(p_singe_row_attrs_rec.DELIVERY_TO_MRKT_TEMP_MIN, -1) <> G_MISS_NUM AND
2184: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DELIVERY_TO_MRKT_TEMP_MIN');
2185: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2186: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2187: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2188: FND_MSG_PUB.ADD;
2189: END IF;
2190:
2191: IF NVL(p_singe_row_attrs_rec.UOM_DELIVERY_TO_MRKT_TEMP_MIN, G_MISS_CHAR) <> G_MISS_CHAR
2192: OR (NVL(p_singe_row_attrs_rec.UOM_DELIVERY_TO_MRKT_TEMP_MIN, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2195: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DELIVERY_TO_MRKT_TEMP_MIN');
2196: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2197: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2198: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2199: FND_MSG_PUB.ADD;
2200: END IF;
2201:
2202: IF NVL(p_singe_row_attrs_rec.IS_PACK_MARKED_WITH_GREEN_DOT, G_MISS_CHAR) <> G_MISS_CHAR
2203: OR (NVL(p_singe_row_attrs_rec.IS_PACK_MARKED_WITH_GREEN_DOT, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2206: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_PACK_MARKED_WITH_GREEN_DOT');
2207: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2208: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2209: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2210: FND_MSG_PUB.ADD;
2211: END IF;
2212:
2213: IF NVL(p_singe_row_attrs_rec.IS_PACK_MARKED_WITH_INGRED, G_MISS_CHAR) <> G_MISS_CHAR
2214: OR (NVL(p_singe_row_attrs_rec.IS_PACK_MARKED_WITH_INGRED, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2217: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_PACK_MARKED_WITH_INGRED');
2218: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2219: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2220: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2221: FND_MSG_PUB.ADD;
2222: END IF;
2223:
2224: IF NVL(p_singe_row_attrs_rec.IS_INGREDIENT_IRRADIATED, G_MISS_CHAR) <> G_MISS_CHAR
2225: OR (NVL(p_singe_row_attrs_rec.IS_INGREDIENT_IRRADIATED, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2228: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_INGREDIENT_IRRADIATED');
2229: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2230: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2231: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2232: FND_MSG_PUB.ADD;
2233: END IF;
2234:
2235: IF NVL(p_singe_row_attrs_rec.IS_RAW_MATERIAL_IRRADIATED, G_MISS_CHAR) <> G_MISS_CHAR
2236: OR (NVL(p_singe_row_attrs_rec.IS_RAW_MATERIAL_IRRADIATED, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2239: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_RAW_MATERIAL_IRRADIATED');
2240: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2241: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2242: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2243: FND_MSG_PUB.ADD;
2244: END IF;
2245:
2246: IF NVL(p_singe_row_attrs_rec.IS_TRADE_ITEM_GENETICALLY_MOD, G_MISS_CHAR) <> G_MISS_CHAR
2247: OR (NVL(p_singe_row_attrs_rec.IS_TRADE_ITEM_GENETICALLY_MOD, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2250: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_TRADE_ITEM_GENETICALLY_MOD');
2251: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2252: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2253: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2254: FND_MSG_PUB.ADD;
2255: END IF;
2256:
2257: IF NVL(p_singe_row_attrs_rec.IS_TRADE_ITEM_IRRADIATED, G_MISS_CHAR) <> G_MISS_CHAR
2258: OR (NVL(p_singe_row_attrs_rec.IS_TRADE_ITEM_IRRADIATED, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2261: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_TRADE_ITEM_IRRADIATED');
2262: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2263: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2264: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2265: FND_MSG_PUB.ADD;
2266: END IF;
2267:
2268: IF NVL(p_singe_row_attrs_rec.SUB_BRAND, G_MISS_CHAR) <> G_MISS_CHAR
2269: OR (NVL(p_singe_row_attrs_rec.SUB_BRAND, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2272: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'SUB_BRAND');
2273: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2274: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2275: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2276: FND_MSG_PUB.ADD;
2277: END IF;
2278:
2279: IF NVL(p_singe_row_attrs_rec.TRADE_ITEM_COUPON, G_MISS_NUM) <> G_MISS_NUM
2280: OR (NVL(p_singe_row_attrs_rec.TRADE_ITEM_COUPON, -1) <> G_MISS_NUM AND
2283: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'TRADE_ITEM_COUPON');
2284: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2285: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2286: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2287: FND_MSG_PUB.ADD;
2288: END IF;
2289:
2290: IF NVL(p_singe_row_attrs_rec.TRADE_ITEM_FORM_DESCRIPTION, G_MISS_CHAR) <> G_MISS_CHAR
2291: OR (NVL(p_singe_row_attrs_rec.TRADE_ITEM_FORM_DESCRIPTION, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2294: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'TRADE_ITEM_FORM_DESCRIPTION');
2295: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2296: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2297: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2298: FND_MSG_PUB.ADD;
2299: END IF;
2300:
2301: IF NVL(p_singe_row_attrs_rec.HAS_BATCH_NUMBER, G_MISS_CHAR) <> G_MISS_CHAR
2302: OR (NVL(p_singe_row_attrs_rec.HAS_BATCH_NUMBER, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2305: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'HAS_BATCH_NUMBER');
2306: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2307: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2308: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2309: FND_MSG_PUB.ADD;
2310: END IF;
2311:
2312: IF NVL(p_singe_row_attrs_rec.IS_NON_SOLD_TRADE_RET_FLAG, G_MISS_CHAR) <> G_MISS_CHAR
2313: OR (NVL(p_singe_row_attrs_rec.IS_NON_SOLD_TRADE_RET_FLAG, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2316: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_NON_SOLD_TRADE_RET_FLAG');
2317: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2318: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2319: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2320: FND_MSG_PUB.ADD;
2321: END IF;
2322:
2323: IF NVL(p_singe_row_attrs_rec.IS_TRADE_ITEM_MAR_REC_FLAG, G_MISS_CHAR) <> G_MISS_CHAR
2324: OR (NVL(p_singe_row_attrs_rec.IS_TRADE_ITEM_MAR_REC_FLAG, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2327: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_TRADE_ITEM_MAR_REC_FLAG');
2328: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2329: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2330: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2331: FND_MSG_PUB.ADD;
2332: END IF;
2333:
2334: IF NVL(p_singe_row_attrs_rec.IS_PACK_MARKED_WITH_EXP_DATE, G_MISS_CHAR) <> G_MISS_CHAR
2335: OR (NVL(p_singe_row_attrs_rec.IS_PACK_MARKED_WITH_EXP_DATE, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2338: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'IS_PACK_MARKED_WITH_EXP_DATE');
2339: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2340: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2341: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2342: FND_MSG_PUB.ADD;
2343: END IF;
2344:
2345: IF NVL(p_singe_row_attrs_rec.FUNCTIONAL_NAME, G_MISS_CHAR) <> G_MISS_CHAR
2346: OR (NVL(p_singe_row_attrs_rec.FUNCTIONAL_NAME, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2349: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'FUNCTIONAL_NAME');
2350: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2351: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2352: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2353: FND_MSG_PUB.ADD;
2354: END IF;
2355:
2356: IF NVL(p_singe_row_attrs_rec.BRAND_OWNER_GLN, G_MISS_CHAR) <> G_MISS_CHAR
2357: OR (NVL(p_singe_row_attrs_rec.BRAND_OWNER_GLN, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2360: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'BRAND_OWNER_GLN');
2361: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2362: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2363: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2364: FND_MSG_PUB.ADD;
2365: END IF;
2366:
2367: IF NVL(p_singe_row_attrs_rec.BRAND_OWNER_NAME, G_MISS_CHAR) <> G_MISS_CHAR
2368: OR (NVL(p_singe_row_attrs_rec.BRAND_OWNER_NAME, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2371: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'BRAND_OWNER_NAME');
2372: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2373: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2374: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2375: FND_MSG_PUB.ADD;
2376: END IF;
2377:
2378: IF NVL(p_singe_row_attrs_rec.DIAMETER, G_MISS_NUM) <> G_MISS_NUM
2379: OR (NVL(p_singe_row_attrs_rec.DIAMETER, -1) <> G_MISS_NUM AND
2382: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DIAMETER');
2383: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2384: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2385: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2386: FND_MSG_PUB.ADD;
2387: END IF;
2388:
2389: IF NVL(p_singe_row_attrs_rec.DRAINED_WEIGHT, G_MISS_NUM) <> G_MISS_NUM
2390: OR (NVL(p_singe_row_attrs_rec.DRAINED_WEIGHT, -1) <> G_MISS_NUM AND
2393: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DRAINED_WEIGHT');
2394: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2395: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2396: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2397: FND_MSG_PUB.ADD;
2398: END IF;
2399:
2400: IF NVL(p_singe_row_attrs_rec.PEG_HORIZONTAL, G_MISS_NUM) <> G_MISS_NUM
2401: OR (NVL(p_singe_row_attrs_rec.PEG_HORIZONTAL, -1) <> G_MISS_NUM AND
2404: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'PEG_HORIZONTAL');
2405: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2406: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2407: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2408: FND_MSG_PUB.ADD;
2409: END IF;
2410:
2411: IF NVL(p_singe_row_attrs_rec.PEG_VERTICAL, G_MISS_NUM) <> G_MISS_NUM
2412: OR (NVL(p_singe_row_attrs_rec.PEG_VERTICAL, -1) <> G_MISS_NUM AND
2415: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'PEG_VERTICAL');
2416: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2417: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2418: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2419: FND_MSG_PUB.ADD;
2420: END IF;
2421:
2422: IF NVL(p_singe_row_attrs_rec.GENERIC_INGREDIENT, G_MISS_CHAR) <> G_MISS_CHAR
2423: OR (NVL(p_singe_row_attrs_rec.GENERIC_INGREDIENT, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2426: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'GENERIC_INGREDIENT');
2427: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2428: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2429: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2430: FND_MSG_PUB.ADD;
2431: END IF;
2432:
2433: IF NVL(p_singe_row_attrs_rec.GENERIC_INGREDIENT_STRGTH, G_MISS_NUM) <> G_MISS_NUM
2434: OR (NVL(p_singe_row_attrs_rec.GENERIC_INGREDIENT_STRGTH, -1) <> G_MISS_NUM AND
2437: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'GENERIC_INGREDIENT_STRGTH');
2438: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2439: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2440: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2441: FND_MSG_PUB.ADD;
2442: END IF;
2443:
2444: IF NVL(p_singe_row_attrs_rec.INGREDIENT_STRENGTH, G_MISS_CHAR) <> G_MISS_CHAR
2445: OR (NVL(p_singe_row_attrs_rec.INGREDIENT_STRENGTH, G_MISS_CHAR||'@') <> G_MISS_CHAR AND
2448: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'INGREDIENT_STRENGTH');
2449: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2450: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2451: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2452: FND_MSG_PUB.ADD;
2453: END IF;
2454:
2455: -- validating for multi row attributes
2456: -- validating the passed parameters
2462: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'SIZE_CODE_VALUE');
2463: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2464: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2465: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2466: FND_MSG_PUB.ADD;
2467: END IF;
2468:
2469: IF NVL(p_multi_row_attrs_tbl(l_index).SIZE_CODE_LIST_AGENCY, G_MISS_CHAR) <> G_MISS_CHAR THEN
2470: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'SIZE_CODE_LIST_AGENCY');
2470: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'SIZE_CODE_LIST_AGENCY');
2471: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2472: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2473: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2474: FND_MSG_PUB.ADD;
2475: END IF;
2476:
2477: IF NVL(p_multi_row_attrs_tbl(l_index).COUNTRY_OF_ORIGIN, G_MISS_CHAR) <> G_MISS_CHAR THEN
2478: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'COUNTRY_OF_ORIGIN');
2478: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'COUNTRY_OF_ORIGIN');
2479: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2480: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2481: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2482: FND_MSG_PUB.ADD;
2483: END IF;
2484:
2485: IF NVL(p_multi_row_attrs_tbl(l_index).MANUFACTURER_ID, G_MISS_NUM) <> G_MISS_NUM THEN
2486: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'MANUFACTURER_ID');
2486: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'MANUFACTURER_ID');
2487: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2488: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2489: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2490: FND_MSG_PUB.ADD;
2491: END IF;
2492:
2493: IF NVL(p_multi_row_attrs_tbl(l_index).MANUFACTURER_GLN, G_MISS_CHAR) <> G_MISS_CHAR THEN
2494: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'MANUFACTURER_GLN');
2494: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'MANUFACTURER_GLN');
2495: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2496: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2497: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2498: FND_MSG_PUB.ADD;
2499: END IF;
2500:
2501: IF NVL(p_multi_row_attrs_tbl(l_index).HANDLING_INSTRUCTIONS_CODE, G_MISS_CHAR) <> G_MISS_CHAR THEN
2502: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'HANDLING_INSTRUCTIONS_CODE');
2502: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'HANDLING_INSTRUCTIONS_CODE');
2503: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2504: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2505: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2506: FND_MSG_PUB.ADD;
2507: END IF;
2508:
2509: IF NVL(p_multi_row_attrs_tbl(l_index).COLOR_CODE_LIST_AGENCY, G_MISS_CHAR) <> G_MISS_CHAR THEN
2510: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'COLOR_CODE_LIST_AGENCY');
2510: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'COLOR_CODE_LIST_AGENCY');
2511: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2512: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2513: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2514: FND_MSG_PUB.ADD;
2515: END IF;
2516:
2517: IF NVL(p_multi_row_attrs_tbl(l_index).COLOR_CODE_VALUE, G_MISS_CHAR) <> G_MISS_CHAR THEN
2518: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'COLOR_CODE_VALUE');
2518: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'COLOR_CODE_VALUE');
2519: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTR_NOT_EDITABLE');
2520: FND_MESSAGE.Set_Token('GTID', l_gtid_disp);
2521: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2522: FND_MSG_PUB.ADD;
2523: END IF;
2524: END IF; -- if i.transaction_type <> 'DELETE'
2525: l_index := p_multi_row_attrs_tbl.NEXT(l_index);
2526: END LOOP; -- end loop while
2537: EXCEPTION WHEN VALUE_ERROR THEN
2538: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'BRAND_OWNER_GLN');
2539: FND_MESSAGE.Set_Name('EGO', 'EGO_BGLN_NOT_NUMBER');
2540: FND_MESSAGE.Set_Token('BGLN', l_attr1_disp);
2541: FND_MSG_PUB.ADD;
2542: l_bgln_valid := FALSE;
2543: END;
2544: END IF; -- 3.
2545:
2549: AND LENGTH(p_singe_row_attrs_rec.BRAND_OWNER_GLN) <> 13 THEN
2550: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'BRAND_OWNER_GLN');
2551: FND_MESSAGE.Set_Name('EGO', 'EGO_BGLN_INCORRECT_LENGTH');
2552: FND_MESSAGE.Set_Token('BGLN', l_attr1_disp);
2553: FND_MSG_PUB.ADD;
2554: l_bgln_valid := FALSE;
2555: END IF; -- 4.
2556:
2557: -- 5. BrandOwnerGLN must have a valid check digit
2560: AND Is_Check_Digit_Invalid(p_singe_row_attrs_rec.BRAND_OWNER_GLN) THEN
2561: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'BRAND_OWNER_GLN');
2562: FND_MESSAGE.Set_Name('EGO', 'EGO_BGLN_CHECKDIGIT_INVALID');
2563: FND_MESSAGE.Set_Token('BGLN', l_attr1_disp);
2564: FND_MSG_PUB.ADD;
2565: END IF; -- 5.
2566:
2567: -- 6. BrandOwnerGLN and BrandOwnerName must co-exist
2568: Debug_Msg('6. BrandOwnerGLN and BrandOwnerName must co-exist');
2579: l_attr2_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'BRAND_OWNER_NAME');
2580: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTRS_MUST_COEXIST');
2581: FND_MESSAGE.Set_Token('ATTR1', l_attr1_disp);
2582: FND_MESSAGE.Set_Token('ATTR2', l_attr2_disp);
2583: FND_MSG_PUB.ADD;
2584: END IF; -- 6.
2585:
2586: -- 7. EanuccCode and EanuccType must co-exist
2587: Debug_Msg('7. EanuccCode and EanuccType must co-exist');
2598: l_attr2_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'EANUCC_TYPE');
2599: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTRS_MUST_COEXIST');
2600: FND_MESSAGE.Set_Token('ATTR1', l_attr1_disp);
2601: FND_MESSAGE.Set_Token('ATTR2', l_attr2_disp);
2602: FND_MSG_PUB.ADD;
2603: END IF; -- 7.
2604:
2605: -- 8. EanuccCode must be number
2606: Debug_Msg('8. EanuccCode must be number');
2611: EXCEPTION WHEN VALUE_ERROR THEN
2612: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'EANUCC_CODE');
2613: FND_MESSAGE.Set_Name('EGO', 'EGO_EANUCC_CODE_INVALID_NUMBER');
2614: FND_MESSAGE.Set_Token('EANUCC_CODE', l_attr1_disp);
2615: FND_MSG_PUB.ADD;
2616: l_eanucc_valid := FALSE;
2617: END;
2618: END IF; -- 8.
2619:
2671: FND_MESSAGE.Set_Name('EGO', 'EGO_EANUCC_CODE_INVALID_LENGTH');
2672: FND_MESSAGE.Set_Token('EANUCC_CODE', l_attr1_disp);
2673: FND_MESSAGE.Set_Token('LENGTH', l_eanucc_code_req_length);
2674: FND_MESSAGE.Set_Token('EANUCC_TYPE', l_attr2_disp);
2675: FND_MSG_PUB.ADD;
2676: l_eanucc_valid := FALSE;
2677: END IF;
2678: END IF; -- 9.
2679:
2682: IF SUBSTR(p_singe_row_attrs_rec.EANUCC_CODE, 1, 3) IN ('098', '099') THEN
2683: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'EANUCC_CODE');
2684: FND_MESSAGE.Set_Name('EGO', 'EGO_EANUCC_1TO3DIGIT_INVALID');
2685: FND_MESSAGE.Set_Token('EANUCC_CODE', l_attr1_disp);
2686: FND_MSG_PUB.ADD;
2687: l_eanucc_valid := FALSE;
2688: END IF; -- 10.
2689:
2690: -- 11. EanuccCode must have a valid check digit
2693: AND Is_Check_Digit_Invalid(p_singe_row_attrs_rec.EANUCC_CODE) THEN
2694: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'EANUCC_CODE');
2695: FND_MESSAGE.Set_Name('EGO', 'EGO_EANUCC_CHECKDIGIT_INVALID');
2696: FND_MESSAGE.Set_Token('EANUCC_CODE', l_attr1_disp);
2697: FND_MSG_PUB.ADD;
2698: l_eanucc_valid := FALSE;
2699: END IF; -- 11.
2700:
2701: -- 12. EanuccCode and EanuccType must be unique
2716: FND_MESSAGE.Set_Name('EGO', 'EGO_EANUCC_NOT_UNIQUE');
2717: FND_MESSAGE.Set_Token('EANUCC_CODE', l_attr1_disp);
2718: FND_MESSAGE.Set_Token('EANUCC_TYPE', l_attr2_disp);
2719: FND_MESSAGE.Set_Token('ITEM', l_item_number);
2720: FND_MSG_PUB.ADD;
2721: END IF;
2722: EXCEPTION WHEN NO_DATA_FOUND THEN
2723: IF NVL(G_CALLED_FROM_INTF, 'N') = 'Y' THEN
2724: BEGIN
2746: FND_MESSAGE.Set_Name('EGO', 'EGO_EANUCC_NOT_UNIQUE');
2747: FND_MESSAGE.Set_Token('EANUCC_CODE', l_attr1_disp);
2748: FND_MESSAGE.Set_Token('EANUCC_TYPE', l_attr2_disp);
2749: FND_MESSAGE.Set_Token('ITEM', l_item_number);
2750: FND_MSG_PUB.ADD;
2751: EXCEPTION WHEN NO_DATA_FOUND THEN
2752: NULL;
2753: END;
2754: END IF; --IF NVL(G_CALLED_FROM_INTF, 'N') = 'Y' THEN
2765: l_attr2_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'CATALOG_PRICE');
2766: FND_MESSAGE.Set_Name('EGO', 'EGO_EFFSTARTDT_REQD');
2767: FND_MESSAGE.Set_Token('EFF_ST_DT', l_attr1_disp);
2768: FND_MESSAGE.Set_Token('RETAIL_CATALOG', l_attr2_disp);
2769: FND_MSG_PUB.ADD;
2770: END IF; -- 13.
2771:
2772: -- 14. If Suggested Retail Price is specified, Effective Start Date has to be specified
2773: Debug_Msg('14. If Suggested Retail Price is specified, Effective Start Date has to be specified');
2779: l_attr2_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'SUGGESTED_RETAIL_PRICE');
2780: FND_MESSAGE.Set_Name('EGO', 'EGO_EFFSTARTDT_REQD');
2781: FND_MESSAGE.Set_Token('EFF_ST_DT', l_attr1_disp);
2782: FND_MESSAGE.Set_Token('RETAIL_CATALOG', l_attr2_disp);
2783: FND_MSG_PUB.ADD;
2784: END IF; -- 14.
2785:
2786: -- validating multi row attributes
2787: IF p_multi_row_attrs_tbl.FIRST IS NOT NULL THEN
2850: IF NVL(p_multi_row_attrs_tbl(l_index).CLASS_OF_DANGEROUS_CODE, G_MISS_CHAR) = G_MISS_CHAR THEN
2851: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'CLASS_OF_DANGEROUS_CODE');
2852: FND_MESSAGE.Set_Name('EGO', 'EGO_MISSING_HAZ_ATTR');
2853: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2854: FND_MSG_PUB.ADD;
2855: END IF;
2856:
2857: IF (p_multi_row_attrs_tbl(l_index).DANGEROUS_GOODS_MARGIN_NUMBER = G_MISS_CHAR OR
2858: (p_multi_row_attrs_tbl(l_index).DANGEROUS_GOODS_MARGIN_NUMBER IS NULL
2861: THEN
2862: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'DANGEROUS_GOODS_MARGIN_NUMBER');
2863: FND_MESSAGE.Set_Name('EGO', 'EGO_MISSING_HAZ_ATTR');
2864: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2865: FND_MSG_PUB.ADD;
2866: END IF;
2867:
2868: IF (p_multi_row_attrs_tbl(l_index).DANGEROUS_GOODS_HAZARDOUS_CODE = G_MISS_CHAR OR
2869: (p_multi_row_attrs_tbl(l_index).DANGEROUS_GOODS_HAZARDOUS_CODE IS NULL
2872: THEN
2873: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'DANGEROUS_GOODS_HAZARDOUS_CODE');
2874: FND_MESSAGE.Set_Name('EGO', 'EGO_MISSING_HAZ_ATTR');
2875: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2876: FND_MSG_PUB.ADD;
2877: END IF;
2878:
2879: IF (p_multi_row_attrs_tbl(l_index).DANGEROUS_GOODS_PACK_GROUP = G_MISS_CHAR OR
2880: (p_multi_row_attrs_tbl(l_index).DANGEROUS_GOODS_PACK_GROUP IS NULL
2883: THEN
2884: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'DANGEROUS_GOODS_PACK_GROUP');
2885: FND_MESSAGE.Set_Name('EGO', 'EGO_MISSING_HAZ_ATTR');
2886: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2887: FND_MSG_PUB.ADD;
2888: END IF;
2889:
2890: IF (p_multi_row_attrs_tbl(l_index).DANGEROUS_GOODS_REG_CODE = G_MISS_CHAR OR
2891: (p_multi_row_attrs_tbl(l_index).DANGEROUS_GOODS_REG_CODE IS NULL
2894: THEN
2895: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'DANGEROUS_GOODS_REG_CODE');
2896: FND_MESSAGE.Set_Name('EGO', 'EGO_MISSING_HAZ_ATTR');
2897: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2898: FND_MSG_PUB.ADD;
2899: END IF;
2900:
2901: IF (p_multi_row_attrs_tbl(l_index).DANGEROUS_GOODS_SHIPPING_NAME = G_MISS_CHAR OR
2902: (p_multi_row_attrs_tbl(l_index).DANGEROUS_GOODS_SHIPPING_NAME IS NULL
2905: THEN
2906: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'DANGEROUS_GOODS_SHIPPING_NAME');
2907: FND_MESSAGE.Set_Name('EGO', 'EGO_MISSING_HAZ_ATTR');
2908: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2909: FND_MSG_PUB.ADD;
2910: END IF;
2911:
2912: IF (p_multi_row_attrs_tbl(l_index).UNITED_NATIONS_DANG_GOODS_NO = G_MISS_NUM OR
2913: (p_multi_row_attrs_tbl(l_index).UNITED_NATIONS_DANG_GOODS_NO IS NULL
2916: THEN
2917: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'UNITED_NATIONS_DANG_GOODS_NO');
2918: FND_MESSAGE.Set_Name('EGO', 'EGO_MISSING_HAZ_ATTR');
2919: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2920: FND_MSG_PUB.ADD;
2921: END IF;
2922:
2923: IF (p_multi_row_attrs_tbl(l_index).FLASH_POINT_TEMP = G_MISS_NUM OR
2924: (p_multi_row_attrs_tbl(l_index).FLASH_POINT_TEMP IS NULL
2927: THEN
2928: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'FLASH_POINT_TEMP');
2929: FND_MESSAGE.Set_Name('EGO', 'EGO_MISSING_HAZ_ATTR');
2930: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2931: FND_MSG_PUB.ADD;
2932: END IF;
2933:
2934: IF (p_multi_row_attrs_tbl(l_index).UOM_FLASH_POINT_TEMP = G_MISS_CHAR OR
2935: (p_multi_row_attrs_tbl(l_index).UOM_FLASH_POINT_TEMP IS NULL
2938: THEN
2939: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'UOM_FLASH_POINT_TEMP');
2940: FND_MESSAGE.Set_Name('EGO', 'EGO_MISSING_HAZ_ATTR');
2941: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2942: FND_MSG_PUB.ADD;
2943: END IF;
2944:
2945: IF (p_multi_row_attrs_tbl(l_index).DANGEROUS_GOODS_TECHNICAL_NAME = G_MISS_CHAR OR
2946: (p_multi_row_attrs_tbl(l_index).DANGEROUS_GOODS_TECHNICAL_NAME IS NULL
2949: THEN
2950: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'DANGEROUS_GOODS_TECHNICAL_NAME');
2951: FND_MESSAGE.Set_Name('EGO', 'EGO_MISSING_HAZ_ATTR');
2952: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
2953: FND_MSG_PUB.ADD;
2954: END IF;
2955: END IF; -- 15.
2956:
2957: -- 16. ColorCodeListAgency and ColorCodeValue must co-exist
2967: l_attr2_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'COLOR_CODE_VALUE');
2968: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTRS_MUST_COEXIST');
2969: FND_MESSAGE.Set_Token('ATTR1', l_attr1_disp);
2970: FND_MESSAGE.Set_Token('ATTR2', l_attr2_disp);
2971: FND_MSG_PUB.ADD;
2972: END IF; -- 16.
2973:
2974: -- 17. Size Code value and Size Code List Agency must coexist
2975: Debug_Msg('17. Size Code value and Size Code List Agency must coexist');
2984: l_attr2_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'SIZE_CODE_VALUE');
2985: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTRS_MUST_COEXIST');
2986: FND_MESSAGE.Set_Token('ATTR1', l_attr1_disp);
2987: FND_MESSAGE.Set_Token('ATTR2', l_attr2_disp);
2988: FND_MSG_PUB.ADD;
2989: END IF; -- 17.
2990:
2991: -- 18. ManufacturerGLN and ManufacturerName must coexist
2992: Debug_Msg('18. ManufacturerGLN and ManufacturerName must coexist');
3023: l_attr2_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'MANUFACTURER_ID');
3024: FND_MESSAGE.Set_Name('EGO', 'EGO_ATTRS_MUST_COEXIST');
3025: FND_MESSAGE.Set_Token('ATTR1', l_attr1_disp);
3026: FND_MESSAGE.Set_Token('ATTR2', l_attr2_disp);
3027: FND_MSG_PUB.ADD;
3028: END IF; -- 18.
3029:
3030: -- 19. ManufacturerGLN must be a number
3031: Debug_Msg('19. ManufacturerGLN must be a number');
3037: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'MANUFACTURER_GLN');
3038: FND_MESSAGE.Set_Name('EGO', 'EGO_MGLN_NOT_NUMBER');
3039: FND_MESSAGE.Set_Token('MGLN_VALUE', p_multi_row_attrs_tbl(l_index).MANUFACTURER_GLN);
3040: FND_MESSAGE.Set_Token('MGLN', l_attr1_disp);
3041: FND_MSG_PUB.ADD;
3042: l_mgln_valid := FALSE;
3043: END;
3044: END IF; -- 19.
3045:
3050: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'MANUFACTURER_GLN');
3051: FND_MESSAGE.Set_Name('EGO', 'EGO_MGLN_INCORRECT_LENGTH');
3052: FND_MESSAGE.Set_Token('MGLN_VALUE', p_multi_row_attrs_tbl(l_index).MANUFACTURER_GLN);
3053: FND_MESSAGE.Set_Token('MGLN', l_attr1_disp);
3054: FND_MSG_PUB.ADD;
3055: l_mgln_valid := FALSE;
3056: END IF; -- 20.
3057:
3058: -- 21. ManufacturerGLN must have a valid check digit
3062: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_MULTI_ATTRS', 'MANUFACTURER_GLN');
3063: FND_MESSAGE.Set_Name('EGO', 'EGO_MGLN_CHECKDIGIT_INVALID');
3064: FND_MESSAGE.Set_Token('MGLN_VALUE', p_multi_row_attrs_tbl(l_index).MANUFACTURER_GLN);
3065: FND_MESSAGE.Set_Token('MGLN', l_attr1_disp);
3066: FND_MSG_PUB.ADD;
3067: END IF; -- 21.
3068: l_index := p_multi_row_attrs_tbl.NEXT(l_index);
3069: END LOOP; -- multi row validations
3070: END IF;
3078: THEN
3079: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'NET_CONTENT');
3080: FND_MESSAGE.Set_Name('EGO', 'EGO_UOM_REQD');
3081: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
3082: FND_MSG_PUB.ADD;
3083: END IF; -- 22.
3084:
3085: -- 23. Uom is required for GROSS_WEIGHT
3086: Debug_Msg('23. Uom is required for GROSS_WEIGHT');
3088: AND NVL(p_singe_row_attrs_rec.UOM_GROSS_WEIGHT, G_MISS_CHAR) = G_MISS_CHAR THEN
3089: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'GROSS_WEIGHT');
3090: FND_MESSAGE.Set_Name('EGO', 'EGO_UOM_REQD');
3091: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
3092: FND_MSG_PUB.ADD;
3093: END IF; -- 23.
3094:
3095: -- 24. Uom is required for PEG_VERTICAL
3096: Debug_Msg('24. Uom is required for PEG_VERTICAL');
3098: AND NVL(p_singe_row_attrs_rec.UOM_PEG_VERTICAL, G_MISS_CHAR) = G_MISS_CHAR THEN
3099: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'PEG_VERTICAL');
3100: FND_MESSAGE.Set_Name('EGO', 'EGO_UOM_REQD');
3101: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
3102: FND_MSG_PUB.ADD;
3103: END IF; -- 24.
3104:
3105: -- 25. Uom is required for PEG_HORIZONTAL
3106: Debug_Msg('25. Uom is required for PEG_HORIZONTAL');
3108: AND NVL(p_singe_row_attrs_rec.UOM_PEG_HORIZONTAL, G_MISS_CHAR) = G_MISS_CHAR THEN
3109: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'PEG_HORIZONTAL');
3110: FND_MESSAGE.Set_Name('EGO', 'EGO_UOM_REQD');
3111: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
3112: FND_MSG_PUB.ADD;
3113: END IF; -- 25.
3114:
3115: -- 26. Uom is required for DRAINED_WEIGHT
3116: Debug_Msg('26. Uom is required for DRAINED_WEIGHT');
3118: AND NVL(p_singe_row_attrs_rec.UOM_DRAINED_WEIGHT, G_MISS_CHAR) = G_MISS_CHAR THEN
3119: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DRAINED_WEIGHT');
3120: FND_MESSAGE.Set_Name('EGO', 'EGO_UOM_REQD');
3121: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
3122: FND_MSG_PUB.ADD;
3123: END IF; -- 26.
3124:
3125: -- 27. Uom is required for DIAMETER
3126: Debug_Msg('27. Uom is required for DIAMETER');
3128: AND NVL(p_singe_row_attrs_rec.UOM_DIAMETER, G_MISS_CHAR) = G_MISS_CHAR THEN
3129: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DIAMETER');
3130: FND_MESSAGE.Set_Name('EGO', 'EGO_UOM_REQD');
3131: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
3132: FND_MSG_PUB.ADD;
3133: END IF; -- 27.
3134:
3135: -- 28. Uom is required for ORDERING_LEAD_TIME
3136: Debug_Msg('28. Uom is required for ORDERING_LEAD_TIME');
3138: AND NVL(p_singe_row_attrs_rec.UOM_ORDERING_LEAD_TIME, G_MISS_CHAR) = G_MISS_CHAR THEN
3139: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'ORDERING_LEAD_TIME');
3140: FND_MESSAGE.Set_Name('EGO', 'EGO_UOM_REQD');
3141: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
3142: FND_MSG_PUB.ADD;
3143: END IF; -- 28.
3144:
3145: -- 29. Uom is required for GENERIC_INGREDIENT_STRGTH
3146: Debug_Msg('29. Uom is required for GENERIC_INGREDIENT_STRGTH');
3148: AND NVL(p_singe_row_attrs_rec.UOM_GENERIC_INGREDIENT_STRGTH, G_MISS_CHAR) = G_MISS_CHAR THEN
3149: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'GENERIC_INGREDIENT_STRGTH');
3150: FND_MESSAGE.Set_Name('EGO', 'EGO_UOM_REQD');
3151: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
3152: FND_MSG_PUB.ADD;
3153: END IF; -- 29.
3154:
3155: -- 30. Uom is required for STACKING_WEIGHT_MAXIMUM
3156: Debug_Msg('30. Uom is required for STACKING_WEIGHT_MAXIMUM');
3158: AND NVL(p_singe_row_attrs_rec.UOM_STACKING_WEIGHT_MAXIMUM, G_MISS_CHAR) = G_MISS_CHAR THEN
3159: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'STACKING_WEIGHT_MAXIMUM');
3160: FND_MESSAGE.Set_Name('EGO', 'EGO_UOM_REQD');
3161: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
3162: FND_MSG_PUB.ADD;
3163: END IF; -- 30.
3164:
3165: -- 31. Uom is required for PIECES_PER_TRADE_ITEM
3166: Debug_Msg('31. Uom is required for PIECES_PER_TRADE_ITEM');
3168: AND NVL(p_singe_row_attrs_rec.UOM_PIECES_PER_TRADE_ITEM, G_MISS_CHAR) = G_MISS_CHAR THEN
3169: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'PIECES_PER_TRADE_ITEM');
3170: FND_MESSAGE.Set_Name('EGO', 'EGO_UOM_REQD');
3171: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
3172: FND_MSG_PUB.ADD;
3173: END IF; -- 31.
3174:
3175: -- 32. Uom is required for NESTING_INCREMENT
3176: Debug_Msg('32. Uom is required for NESTING_INCREMENT');
3178: AND NVL(p_singe_row_attrs_rec.UOM_NESTING_INCREMENT, G_MISS_CHAR) = G_MISS_CHAR THEN
3179: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'NESTING_INCREMENT');
3180: FND_MESSAGE.Set_Name('EGO', 'EGO_UOM_REQD');
3181: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
3182: FND_MSG_PUB.ADD;
3183: END IF; -- 32.
3184:
3185: -- 33. Uom is required for DEL_TO_DIST_CNTR_TEMP_MIN
3186: Debug_Msg('33. Uom is required for DEL_TO_DIST_CNTR_TEMP_MIN');
3192: THEN
3193: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DEL_TO_DIST_CNTR_TEMP_MIN');
3194: FND_MESSAGE.Set_Name('EGO', 'EGO_UOM_REQD');
3195: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
3196: FND_MSG_PUB.ADD;
3197: END IF; -- 33.
3198:
3199: -- 34. Uom is required for DEL_TO_DIST_CNTR_TEMP_MAX
3200: Debug_Msg('34. Uom is required for DEL_TO_DIST_CNTR_TEMP_MAX');
3206: THEN
3207: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DEL_TO_DIST_CNTR_TEMP_MAX');
3208: FND_MESSAGE.Set_Name('EGO', 'EGO_UOM_REQD');
3209: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
3210: FND_MSG_PUB.ADD;
3211: END IF; -- 34.
3212:
3213: -- 35. Uom is required for DELIVERY_TO_MRKT_TEMP_MIN
3214: Debug_Msg('35. Uom is required for DELIVERY_TO_MRKT_TEMP_MIN');
3220: THEN
3221: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DELIVERY_TO_MRKT_TEMP_MIN');
3222: FND_MESSAGE.Set_Name('EGO', 'EGO_UOM_REQD');
3223: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
3224: FND_MSG_PUB.ADD;
3225: END IF; -- 35.
3226:
3227: -- 36. Uom is required for DELIVERY_TO_MRKT_TEMP_MAX
3228: Debug_Msg('36. Uom is required for DELIVERY_TO_MRKT_TEMP_MAX');
3234: THEN
3235: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DELIVERY_TO_MRKT_TEMP_MAX');
3236: FND_MESSAGE.Set_Name('EGO', 'EGO_UOM_REQD');
3237: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
3238: FND_MSG_PUB.ADD;
3239: END IF; -- 36.
3240:
3241: -- 37. Uom is required for STORAGE_HANDLING_TEMP_MIN
3242: Debug_Msg('37. Uom is required for STORAGE_HANDLING_TEMP_MIN');
3248: THEN
3249: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'STORAGE_HANDLING_TEMP_MIN');
3250: FND_MESSAGE.Set_Name('EGO', 'EGO_UOM_REQD');
3251: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
3252: FND_MSG_PUB.ADD;
3253: END IF; -- 37.
3254:
3255: -- 38. Uom is required for STORAGE_HANDLING_TEMP_MAX
3256: Debug_Msg('38. Uom is required for STORAGE_HANDLING_TEMP_MAX');
3262: THEN
3263: l_attr1_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'STORAGE_HANDLING_TEMP_MAX');
3264: FND_MESSAGE.Set_Name('EGO', 'EGO_UOM_REQD');
3265: FND_MESSAGE.Set_Token('ATTR_NAME', l_attr1_disp);
3266: FND_MSG_PUB.ADD;
3267: END IF; -- 38.
3268:
3269: -- 39. start_availability_date_time can not be greater than end_availability_date_time
3270: Debug_Msg('39. START_AVAILABILITY_DATE_TIME can not be greater than END_AVAILABILITY_DATE_TIME');
3291: l_attr2_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'END_AVAILABILITY_DATE_TIME');
3292: FND_MESSAGE.Set_Name('EGO', 'EGO_MIN_GT_MAX');
3293: FND_MESSAGE.Set_Token('MIN_ATTR', l_attr1_disp);
3294: FND_MESSAGE.Set_Token('MAX_ATTR', l_attr2_disp);
3295: FND_MSG_PUB.ADD;
3296: END IF; -- 39.
3297:
3298: -- 40. EFFECTIVE_START_DATE can not be greater than EFFECTIVE_END_DATE
3299: Debug_Msg('40. EFFECTIVE_START_DATE can not be greater than EFFECTIVE_END_DATE');
3319: l_attr2_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'EFFECTIVE_END_DATE');
3320: FND_MESSAGE.Set_Name('EGO', 'EGO_MIN_GT_MAX');
3321: FND_MESSAGE.Set_Token('MIN_ATTR', l_attr1_disp);
3322: FND_MESSAGE.Set_Token('MAX_ATTR', l_attr2_disp);
3323: FND_MSG_PUB.ADD;
3324: END IF; -- 40.
3325:
3326: -- 41. order_quantity_min can not be greater than order_quantity_max
3327: Debug_Msg('41. ORDER_QUANTITY_MIN can not be greater than ORDER_QUANTITY_MAX');
3347: l_attr2_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'ORDER_QUANTITY_MAX');
3348: FND_MESSAGE.Set_Name('EGO', 'EGO_MIN_GT_MAX');
3349: FND_MESSAGE.Set_Token('MIN_ATTR', l_attr1_disp);
3350: FND_MESSAGE.Set_Token('MAX_ATTR', l_attr2_disp);
3351: FND_MSG_PUB.ADD;
3352: END IF; -- 41.
3353:
3354: -- 42. DEL_TO_DIST_CNTR_TEMP_MIN can not be greater than DEL_TO_DIST_CNTR_TEMP_MAX
3355: Debug_Msg('42. DEL_TO_DIST_CNTR_TEMP_MIN can not be greater than DEL_TO_DIST_CNTR_TEMP_MAX');
3375: l_attr2_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DEL_TO_DIST_CNTR_TEMP_MAX');
3376: FND_MESSAGE.Set_Name('EGO', 'EGO_MIN_GT_MAX');
3377: FND_MESSAGE.Set_Token('MIN_ATTR', l_attr1_disp);
3378: FND_MESSAGE.Set_Token('MAX_ATTR', l_attr2_disp);
3379: FND_MSG_PUB.ADD;
3380: END IF; -- 42.
3381:
3382: -- 42.1. uom for DEL_TO_DIST_CNTR_TEMP_MIN must be same that of DEL_TO_DIST_CNTR_TEMP_MAX
3383: Debug_Msg('42.1. uom for DEL_TO_DIST_CNTR_TEMP_MIN must be same that of DEL_TO_DIST_CNTR_TEMP_MAX');
3403: l_attr2_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DEL_TO_DIST_CNTR_TEMP_MAX');
3404: FND_MESSAGE.Set_Name('EGO', 'EGO_UOM_MUST_BE_SAME');
3405: FND_MESSAGE.Set_Token('ATTR1', l_attr1_disp);
3406: FND_MESSAGE.Set_Token('ATTR2', l_attr2_disp);
3407: FND_MSG_PUB.ADD;
3408: END IF; -- 42.1.
3409:
3410: -- 43. DELIVERY_TO_MRKT_TEMP_MIN can not be greater than DELIVERY_TO_MRKT_TEMP_MAX
3411: Debug_Msg('43. DELIVERY_TO_MRKT_TEMP_MIN can not be greater than DELIVERY_TO_MRKT_TEMP_MAX');
3431: l_attr2_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DELIVERY_TO_MRKT_TEMP_MAX');
3432: FND_MESSAGE.Set_Name('EGO', 'EGO_MIN_GT_MAX');
3433: FND_MESSAGE.Set_Token('MIN_ATTR', l_attr1_disp);
3434: FND_MESSAGE.Set_Token('MAX_ATTR', l_attr2_disp);
3435: FND_MSG_PUB.ADD;
3436: END IF; -- 43.
3437:
3438: -- 43.1. uom for DELIVERY_TO_MRKT_TEMP_MIN must be same that of DELIVERY_TO_MRKT_TEMP_MAX
3439: Debug_Msg('43.1. uom for DELIVERY_TO_MRKT_TEMP_MIN must be same that of DELIVERY_TO_MRKT_TEMP_MAX');
3459: l_attr2_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'DELIVERY_TO_MRKT_TEMP_MAX');
3460: FND_MESSAGE.Set_Name('EGO', 'EGO_UOM_MUST_BE_SAME');
3461: FND_MESSAGE.Set_Token('ATTR1', l_attr1_disp);
3462: FND_MESSAGE.Set_Token('ATTR2', l_attr2_disp);
3463: FND_MSG_PUB.ADD;
3464: END IF; -- 43.1.
3465:
3466: -- 44. STORAGE_HANDLING_TEMP_MIN can not be greater than STORAGE_HANDLING_TEMP_MAX
3467: Debug_Msg('44. STORAGE_HANDLING_TEMP_MIN can not be greater than STORAGE_HANDLING_TEMP_MAX');
3487: l_attr2_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'STORAGE_HANDLING_TEMP_MAX');
3488: FND_MESSAGE.Set_Name('EGO', 'EGO_MIN_GT_MAX');
3489: FND_MESSAGE.Set_Token('MIN_ATTR', l_attr1_disp);
3490: FND_MESSAGE.Set_Token('MAX_ATTR', l_attr2_disp);
3491: FND_MSG_PUB.ADD;
3492: END IF; -- 44.
3493:
3494: -- 44.1. uom for STORAGE_HANDLING_TEMP_MIN must be same that of STORAGE_HANDLING_TEMP_MAX
3495: Debug_Msg('44.1. uom for STORAGE_HANDLING_TEMP_MIN must be same that of STORAGE_HANDLING_TEMP_MAX');
3515: l_attr2_disp := Get_Attribute_Display_Name('EGO_ITEM_GTIN_ATTRS', 'STORAGE_HANDLING_TEMP_MAX');
3516: FND_MESSAGE.Set_Name('EGO', 'EGO_UOM_MUST_BE_SAME');
3517: FND_MESSAGE.Set_Token('ATTR1', l_attr1_disp);
3518: FND_MESSAGE.Set_Token('ATTR2', l_attr2_disp);
3519: FND_MSG_PUB.ADD;
3520: END IF; -- 44.1.
3521: END IF; -- IF l_continue THEN
3522:
3523: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
3519: FND_MSG_PUB.ADD;
3520: END IF; -- 44.1.
3521: END IF; -- IF l_continue THEN
3522:
3523: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
3524: IF x_msg_count > 0 THEN
3525: x_return_status := 'E';
3526: ELSE
3527: x_return_status := 'S';
3809: x_return_status := l_return_status;
3810: x_msg_count := l_msg_count;
3811: x_msg_data := l_msg_data;
3812: FOR cnt IN 1..l_msg_count LOOP
3813: Debug_Msg('Error msg - '||cnt ||': '|| FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F'));
3814: END LOOP;
3815: Debug_Msg('Error msg - '|| l_msg_data);
3816: ELSE
3817: x_return_status := l_return_status;
4138: x_msg_count := l_msg_count;
4139: x_msg_data := l_msg_data;
4140: IF l_msg_count > 0 AND l_return_status <> 'U' THEN
4141: FOR cnt IN 1..l_msg_count LOOP
4142: Debug_Msg('Error msg - '||cnt ||': '|| FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F'));
4143: l_msg_text := FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F');
4144: ERROR_HANDLER.Add_Error_Message
4145: (
4146: p_message_text => l_msg_text
4139: x_msg_data := l_msg_data;
4140: IF l_msg_count > 0 AND l_return_status <> 'U' THEN
4141: FOR cnt IN 1..l_msg_count LOOP
4142: Debug_Msg('Error msg - '||cnt ||': '|| FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F'));
4143: l_msg_text := FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F');
4144: ERROR_HANDLER.Add_Error_Message
4145: (
4146: p_message_text => l_msg_text
4147: ,p_application_id => 'EGO'
5912: x_return_status := l_return_status;
5913: x_msg_count := l_msg_count;
5914: x_msg_data := l_msg_data;
5915: FOR cnt IN 1..l_msg_count LOOP
5916: Debug_Msg('Error msg - '||cnt ||': '|| FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F'));
5917: END LOOP;
5918: Debug_Msg('Error msg - '|| l_msg_data);
5919: ELSIF l_return_status = 'S' THEN
5920: Debug_Msg('Singe Row Attributes (and deletion of multi-row attributes) processing is successful');