1010: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute14='||p_Attribute14, FALSE);
1011: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute15='||p_Attribute15, FALSE);
1012: end if;
1013:
1014: fnd_flex_descval.set_column_value('ATTRIBUTE_CATEGORY', p_AttributeCategory);
1015: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_Attribute1);
1016: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_Attribute2);
1017: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_Attribute3);
1018: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_Attribute4);
1011: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute15='||p_Attribute15, FALSE);
1012: end if;
1013:
1014: fnd_flex_descval.set_column_value('ATTRIBUTE_CATEGORY', p_AttributeCategory);
1015: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_Attribute1);
1016: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_Attribute2);
1017: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_Attribute3);
1018: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_Attribute4);
1019: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_Attribute5);
1012: end if;
1013:
1014: fnd_flex_descval.set_column_value('ATTRIBUTE_CATEGORY', p_AttributeCategory);
1015: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_Attribute1);
1016: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_Attribute2);
1017: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_Attribute3);
1018: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_Attribute4);
1019: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_Attribute5);
1020: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_Attribute6);
1013:
1014: fnd_flex_descval.set_column_value('ATTRIBUTE_CATEGORY', p_AttributeCategory);
1015: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_Attribute1);
1016: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_Attribute2);
1017: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_Attribute3);
1018: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_Attribute4);
1019: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_Attribute5);
1020: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_Attribute6);
1021: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_Attribute7);
1014: fnd_flex_descval.set_column_value('ATTRIBUTE_CATEGORY', p_AttributeCategory);
1015: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_Attribute1);
1016: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_Attribute2);
1017: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_Attribute3);
1018: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_Attribute4);
1019: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_Attribute5);
1020: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_Attribute6);
1021: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_Attribute7);
1022: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_Attribute8);
1015: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_Attribute1);
1016: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_Attribute2);
1017: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_Attribute3);
1018: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_Attribute4);
1019: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_Attribute5);
1020: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_Attribute6);
1021: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_Attribute7);
1022: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_Attribute8);
1023: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_Attribute9);
1016: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_Attribute2);
1017: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_Attribute3);
1018: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_Attribute4);
1019: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_Attribute5);
1020: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_Attribute6);
1021: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_Attribute7);
1022: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_Attribute8);
1023: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_Attribute9);
1024: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_Attribute10);
1017: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_Attribute3);
1018: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_Attribute4);
1019: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_Attribute5);
1020: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_Attribute6);
1021: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_Attribute7);
1022: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_Attribute8);
1023: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_Attribute9);
1024: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_Attribute10);
1025: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_Attribute11);
1018: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_Attribute4);
1019: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_Attribute5);
1020: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_Attribute6);
1021: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_Attribute7);
1022: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_Attribute8);
1023: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_Attribute9);
1024: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_Attribute10);
1025: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_Attribute11);
1026: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_Attribute12);
1019: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_Attribute5);
1020: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_Attribute6);
1021: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_Attribute7);
1022: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_Attribute8);
1023: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_Attribute9);
1024: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_Attribute10);
1025: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_Attribute11);
1026: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_Attribute12);
1027: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_Attribute13);
1020: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_Attribute6);
1021: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_Attribute7);
1022: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_Attribute8);
1023: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_Attribute9);
1024: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_Attribute10);
1025: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_Attribute11);
1026: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_Attribute12);
1027: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_Attribute13);
1028: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_Attribute14);
1021: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_Attribute7);
1022: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_Attribute8);
1023: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_Attribute9);
1024: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_Attribute10);
1025: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_Attribute11);
1026: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_Attribute12);
1027: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_Attribute13);
1028: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_Attribute14);
1029: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_Attribute15);
1022: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_Attribute8);
1023: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_Attribute9);
1024: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_Attribute10);
1025: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_Attribute11);
1026: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_Attribute12);
1027: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_Attribute13);
1028: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_Attribute14);
1029: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_Attribute15);
1030:
1023: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_Attribute9);
1024: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_Attribute10);
1025: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_Attribute11);
1026: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_Attribute12);
1027: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_Attribute13);
1028: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_Attribute14);
1029: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_Attribute15);
1030:
1031: IF FND_FLEX_DESCVAL.validate_desccols(p_FlexFieldAppShortName, p_FlexFieldName) THEN
1024: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_Attribute10);
1025: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_Attribute11);
1026: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_Attribute12);
1027: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_Attribute13);
1028: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_Attribute14);
1029: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_Attribute15);
1030:
1031: IF FND_FLEX_DESCVAL.validate_desccols(p_FlexFieldAppShortName, p_FlexFieldName) THEN
1032: IF (NVL(LENGTH(FND_FLEX_DESCVAL.concatenated_ids),0) > 1) THEN
1025: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_Attribute11);
1026: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_Attribute12);
1027: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_Attribute13);
1028: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_Attribute14);
1029: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_Attribute15);
1030:
1031: IF FND_FLEX_DESCVAL.validate_desccols(p_FlexFieldAppShortName, p_FlexFieldName) THEN
1032: IF (NVL(LENGTH(FND_FLEX_DESCVAL.concatenated_ids),0) > 1) THEN
1033: return(FND_FLEX_DESCVAL.concatenated_ids);
1027: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_Attribute13);
1028: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_Attribute14);
1029: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_Attribute15);
1030:
1031: IF FND_FLEX_DESCVAL.validate_desccols(p_FlexFieldAppShortName, p_FlexFieldName) THEN
1032: IF (NVL(LENGTH(FND_FLEX_DESCVAL.concatenated_ids),0) > 1) THEN
1033: return(FND_FLEX_DESCVAL.concatenated_ids);
1034: ELSE
1035: return(FND_FLEX_DESCVAL.concatenated_values);
1028: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_Attribute14);
1029: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_Attribute15);
1030:
1031: IF FND_FLEX_DESCVAL.validate_desccols(p_FlexFieldAppShortName, p_FlexFieldName) THEN
1032: IF (NVL(LENGTH(FND_FLEX_DESCVAL.concatenated_ids),0) > 1) THEN
1033: return(FND_FLEX_DESCVAL.concatenated_ids);
1034: ELSE
1035: return(FND_FLEX_DESCVAL.concatenated_values);
1036: END IF;
1029: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_Attribute15);
1030:
1031: IF FND_FLEX_DESCVAL.validate_desccols(p_FlexFieldAppShortName, p_FlexFieldName) THEN
1032: IF (NVL(LENGTH(FND_FLEX_DESCVAL.concatenated_ids),0) > 1) THEN
1033: return(FND_FLEX_DESCVAL.concatenated_ids);
1034: ELSE
1035: return(FND_FLEX_DESCVAL.concatenated_values);
1036: END IF;
1037: ELSE
1031: IF FND_FLEX_DESCVAL.validate_desccols(p_FlexFieldAppShortName, p_FlexFieldName) THEN
1032: IF (NVL(LENGTH(FND_FLEX_DESCVAL.concatenated_ids),0) > 1) THEN
1033: return(FND_FLEX_DESCVAL.concatenated_ids);
1034: ELSE
1035: return(FND_FLEX_DESCVAL.concatenated_values);
1036: END IF;
1037: ELSE
1038: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1039: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '*************************************************', FALSE);
1037: ELSE
1038: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1039: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '*************************************************', FALSE);
1040: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* An error has occured so we will call ', FALSE);
1041: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* FND_FLEX_DESCVAL.error_segment to detemine ', FALSE);
1042: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* which segment contains the error. ', FALSE);
1043: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '*************************************************', FALSE);
1044: end if;
1045:
1043: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '*************************************************', FALSE);
1044: end if;
1045:
1046:
1047: error_segment := FND_FLEX_DESCVAL.error_segment;
1048: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1049: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'error_segment = ' || error_segment, FALSE);
1050: end if;
1051: RAISE errors_received;
1057: end if;
1058:
1059: EXCEPTION
1060: WHEN errors_received THEN
1061: error_msg := fnd_flex_descval.error_message;
1062: s :=1;
1063: e := 200;
1064:
1065: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN