2995: arp_util.debug('ar_deposit_lib_pvt.Validate_Desc_Flexfield() -' );
2996:
2997: IF p_desc_flex_name = 'RA_CUSTOMER_TRX' THEN /* bug 5467021 if-else condition added and get_flex_title called in set_token*/
2998:
2999: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);
3000: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_desc_flex_rec.attribute1);
3001: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_desc_flex_rec.attribute2);
3002: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
3003: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
2996:
2997: IF p_desc_flex_name = 'RA_CUSTOMER_TRX' THEN /* bug 5467021 if-else condition added and get_flex_title called in set_token*/
2998:
2999: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);
3000: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_desc_flex_rec.attribute1);
3001: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_desc_flex_rec.attribute2);
3002: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
3003: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
3004: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
2997: IF p_desc_flex_name = 'RA_CUSTOMER_TRX' THEN /* bug 5467021 if-else condition added and get_flex_title called in set_token*/
2998:
2999: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);
3000: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_desc_flex_rec.attribute1);
3001: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_desc_flex_rec.attribute2);
3002: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
3003: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
3004: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
3005: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
2998:
2999: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);
3000: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_desc_flex_rec.attribute1);
3001: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_desc_flex_rec.attribute2);
3002: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
3003: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
3004: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
3005: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
3006: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
2999: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);
3000: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_desc_flex_rec.attribute1);
3001: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_desc_flex_rec.attribute2);
3002: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
3003: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
3004: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
3005: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
3006: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
3007: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
3000: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_desc_flex_rec.attribute1);
3001: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_desc_flex_rec.attribute2);
3002: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
3003: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
3004: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
3005: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
3006: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
3007: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
3008: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
3001: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_desc_flex_rec.attribute2);
3002: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
3003: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
3004: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
3005: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
3006: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
3007: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
3008: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
3009: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
3002: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_desc_flex_rec.attribute3);
3003: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
3004: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
3005: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
3006: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
3007: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
3008: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
3009: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
3010: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
3003: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_desc_flex_rec.attribute4);
3004: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
3005: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
3006: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
3007: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
3008: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
3009: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
3010: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
3011: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
3004: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_desc_flex_rec.attribute5);
3005: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
3006: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
3007: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
3008: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
3009: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
3010: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
3011: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
3012: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
3005: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_desc_flex_rec.attribute6);
3006: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
3007: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
3008: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
3009: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
3010: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
3011: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
3012: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
3013: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_desc_flex_rec.attribute14);
3006: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_desc_flex_rec.attribute7);
3007: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
3008: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
3009: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
3010: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
3011: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
3012: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
3013: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_desc_flex_rec.attribute14);
3014: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_desc_flex_rec.attribute15);
3007: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_desc_flex_rec.attribute8);
3008: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
3009: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
3010: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
3011: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
3012: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
3013: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_desc_flex_rec.attribute14);
3014: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_desc_flex_rec.attribute15);
3015: IF ( NOT fnd_flex_descval.validate_desccols('AR',p_desc_flex_name,'I') ) /*Bug 3291481*/
3008: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_desc_flex_rec.attribute9);
3009: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
3010: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
3011: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
3012: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
3013: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_desc_flex_rec.attribute14);
3014: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_desc_flex_rec.attribute15);
3015: IF ( NOT fnd_flex_descval.validate_desccols('AR',p_desc_flex_name,'I') ) /*Bug 3291481*/
3016: THEN
3009: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_desc_flex_rec.attribute10);
3010: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
3011: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
3012: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
3013: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_desc_flex_rec.attribute14);
3014: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_desc_flex_rec.attribute15);
3015: IF ( NOT fnd_flex_descval.validate_desccols('AR',p_desc_flex_name,'I') ) /*Bug 3291481*/
3016: THEN
3017:
3010: fnd_flex_descval.set_column_value('ATTRIBUTE11',p_desc_flex_rec.attribute11);
3011: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
3012: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
3013: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_desc_flex_rec.attribute14);
3014: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_desc_flex_rec.attribute15);
3015: IF ( NOT fnd_flex_descval.validate_desccols('AR',p_desc_flex_name,'I') ) /*Bug 3291481*/
3016: THEN
3017:
3018: FND_MESSAGE.SET_NAME('AR', 'AR_RAPI_DESC_FLEX_INVALID');
3011: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_desc_flex_rec.attribute12);
3012: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_desc_flex_rec.attribute13);
3013: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_desc_flex_rec.attribute14);
3014: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_desc_flex_rec.attribute15);
3015: IF ( NOT fnd_flex_descval.validate_desccols('AR',p_desc_flex_name,'I') ) /*Bug 3291481*/
3016: THEN
3017:
3018: FND_MESSAGE.SET_NAME('AR', 'AR_RAPI_DESC_FLEX_INVALID');
3019: -- FND_MESSAGE.SET_TOKEN('DFF_NAME',p_desc_flex_name);
3021: FND_MSG_PUB.ADD ;
3022: p_return_status := FND_API.G_RET_STS_ERROR;
3023: END IF;
3024:
3025: l_count := fnd_flex_descval.segment_count;
3026:
3027: FOR i in 1..l_count LOOP
3028: l_col_name := fnd_flex_descval.segment_column_name(i);
3029:
3024:
3025: l_count := fnd_flex_descval.segment_count;
3026:
3027: FOR i in 1..l_count LOOP
3028: l_col_name := fnd_flex_descval.segment_column_name(i);
3029:
3030: /*Bug 3291481, replaced fnd_flex_descval.segment_value with fnd_flex_descval.segment_id*/
3031:
3032: IF l_col_name = 'ATTRIBUTE1' THEN
3026:
3027: FOR i in 1..l_count LOOP
3028: l_col_name := fnd_flex_descval.segment_column_name(i);
3029:
3030: /*Bug 3291481, replaced fnd_flex_descval.segment_value with fnd_flex_descval.segment_id*/
3031:
3032: IF l_col_name = 'ATTRIBUTE1' THEN
3033: p_desc_flex_rec.attribute1 := fnd_flex_descval.segment_id(i);
3034: ELSIF l_col_name = 'ATTRIBUTE_CATEGORY' THEN
3029:
3030: /*Bug 3291481, replaced fnd_flex_descval.segment_value with fnd_flex_descval.segment_id*/
3031:
3032: IF l_col_name = 'ATTRIBUTE1' THEN
3033: p_desc_flex_rec.attribute1 := fnd_flex_descval.segment_id(i);
3034: ELSIF l_col_name = 'ATTRIBUTE_CATEGORY' THEN
3035: p_desc_flex_rec.attribute_category := fnd_flex_descval.segment_id(i);
3036: ELSIF l_col_name = 'ATTRIBUTE2' THEN
3037: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_id(i);
3031:
3032: IF l_col_name = 'ATTRIBUTE1' THEN
3033: p_desc_flex_rec.attribute1 := fnd_flex_descval.segment_id(i);
3034: ELSIF l_col_name = 'ATTRIBUTE_CATEGORY' THEN
3035: p_desc_flex_rec.attribute_category := fnd_flex_descval.segment_id(i);
3036: ELSIF l_col_name = 'ATTRIBUTE2' THEN
3037: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_id(i);
3038: ELSIF l_col_name = 'ATTRIBUTE3' THEN
3039: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_id(i);
3033: p_desc_flex_rec.attribute1 := fnd_flex_descval.segment_id(i);
3034: ELSIF l_col_name = 'ATTRIBUTE_CATEGORY' THEN
3035: p_desc_flex_rec.attribute_category := fnd_flex_descval.segment_id(i);
3036: ELSIF l_col_name = 'ATTRIBUTE2' THEN
3037: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_id(i);
3038: ELSIF l_col_name = 'ATTRIBUTE3' THEN
3039: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_id(i);
3040: ELSIF l_col_name = 'ATTRIBUTE4' THEN
3041: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_id(i);
3035: p_desc_flex_rec.attribute_category := fnd_flex_descval.segment_id(i);
3036: ELSIF l_col_name = 'ATTRIBUTE2' THEN
3037: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_id(i);
3038: ELSIF l_col_name = 'ATTRIBUTE3' THEN
3039: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_id(i);
3040: ELSIF l_col_name = 'ATTRIBUTE4' THEN
3041: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_id(i);
3042: ELSIF l_col_name = 'ATTRIBUTE5' THEN
3043: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_id(i);
3037: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_id(i);
3038: ELSIF l_col_name = 'ATTRIBUTE3' THEN
3039: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_id(i);
3040: ELSIF l_col_name = 'ATTRIBUTE4' THEN
3041: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_id(i);
3042: ELSIF l_col_name = 'ATTRIBUTE5' THEN
3043: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_id(i);
3044: ELSIF l_col_name = 'ATTRIBUTE6' THEN
3045: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_id(i);
3039: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_id(i);
3040: ELSIF l_col_name = 'ATTRIBUTE4' THEN
3041: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_id(i);
3042: ELSIF l_col_name = 'ATTRIBUTE5' THEN
3043: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_id(i);
3044: ELSIF l_col_name = 'ATTRIBUTE6' THEN
3045: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_id(i);
3046: ELSIF l_col_name = 'ATTRIBUTE7' THEN
3047: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_id(i);
3041: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_id(i);
3042: ELSIF l_col_name = 'ATTRIBUTE5' THEN
3043: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_id(i);
3044: ELSIF l_col_name = 'ATTRIBUTE6' THEN
3045: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_id(i);
3046: ELSIF l_col_name = 'ATTRIBUTE7' THEN
3047: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_id(i);
3048: ELSIF l_col_name = 'ATTRIBUTE8' THEN
3049: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_id(i);
3043: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_id(i);
3044: ELSIF l_col_name = 'ATTRIBUTE6' THEN
3045: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_id(i);
3046: ELSIF l_col_name = 'ATTRIBUTE7' THEN
3047: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_id(i);
3048: ELSIF l_col_name = 'ATTRIBUTE8' THEN
3049: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_id(i);
3050: ELSIF l_col_name = 'ATTRIBUTE9' THEN
3051: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_id(i);
3045: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_id(i);
3046: ELSIF l_col_name = 'ATTRIBUTE7' THEN
3047: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_id(i);
3048: ELSIF l_col_name = 'ATTRIBUTE8' THEN
3049: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_id(i);
3050: ELSIF l_col_name = 'ATTRIBUTE9' THEN
3051: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_id(i);
3052: ELSIF l_col_name = 'ATTRIBUTE10' THEN
3053: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_id(i);
3047: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_id(i);
3048: ELSIF l_col_name = 'ATTRIBUTE8' THEN
3049: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_id(i);
3050: ELSIF l_col_name = 'ATTRIBUTE9' THEN
3051: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_id(i);
3052: ELSIF l_col_name = 'ATTRIBUTE10' THEN
3053: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_id(i);
3054: ELSIF l_col_name = 'ATTRIBUTE11' THEN
3055: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_id(i);
3049: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_id(i);
3050: ELSIF l_col_name = 'ATTRIBUTE9' THEN
3051: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_id(i);
3052: ELSIF l_col_name = 'ATTRIBUTE10' THEN
3053: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_id(i);
3054: ELSIF l_col_name = 'ATTRIBUTE11' THEN
3055: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_id(i);
3056: ELSIF l_col_name = 'ATTRIBUTE12' THEN
3057: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_id(i);
3051: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_id(i);
3052: ELSIF l_col_name = 'ATTRIBUTE10' THEN
3053: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_id(i);
3054: ELSIF l_col_name = 'ATTRIBUTE11' THEN
3055: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_id(i);
3056: ELSIF l_col_name = 'ATTRIBUTE12' THEN
3057: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_id(i);
3058: ELSIF l_col_name = 'ATTRIBUTE13' THEN
3059: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_id(i);
3053: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_id(i);
3054: ELSIF l_col_name = 'ATTRIBUTE11' THEN
3055: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_id(i);
3056: ELSIF l_col_name = 'ATTRIBUTE12' THEN
3057: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_id(i);
3058: ELSIF l_col_name = 'ATTRIBUTE13' THEN
3059: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_id(i);
3060: ELSIF l_col_name = 'ATTRIBUTE14' THEN
3061: p_desc_flex_rec.attribute14 := fnd_flex_descval.segment_id(i);
3055: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_id(i);
3056: ELSIF l_col_name = 'ATTRIBUTE12' THEN
3057: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_id(i);
3058: ELSIF l_col_name = 'ATTRIBUTE13' THEN
3059: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_id(i);
3060: ELSIF l_col_name = 'ATTRIBUTE14' THEN
3061: p_desc_flex_rec.attribute14 := fnd_flex_descval.segment_id(i);
3062: ELSIF l_col_name = 'ATTRIBUTE15' THEN
3063: p_desc_flex_rec.attribute15 := fnd_flex_descval.segment_id(i);
3057: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_id(i);
3058: ELSIF l_col_name = 'ATTRIBUTE13' THEN
3059: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_id(i);
3060: ELSIF l_col_name = 'ATTRIBUTE14' THEN
3061: p_desc_flex_rec.attribute14 := fnd_flex_descval.segment_id(i);
3062: ELSIF l_col_name = 'ATTRIBUTE15' THEN
3063: p_desc_flex_rec.attribute15 := fnd_flex_descval.segment_id(i);
3064: END IF;
3065:
3059: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_id(i);
3060: ELSIF l_col_name = 'ATTRIBUTE14' THEN
3061: p_desc_flex_rec.attribute14 := fnd_flex_descval.segment_id(i);
3062: ELSIF l_col_name = 'ATTRIBUTE15' THEN
3063: p_desc_flex_rec.attribute15 := fnd_flex_descval.segment_id(i);
3064: END IF;
3065:
3066: IF i > l_count THEN
3067: EXIT;
3069: END LOOP;
3070: /* Below coded added for bug 5467021. Assigning appropriate columns values based on flex field name before call to fnd api for validation */
3071:
3072: ELSIF p_desc_flex_name = 'RA_INTERFACE_HEADER' THEN
3073: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);
3074:
3075: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE1',
3076: p_desc_flex_rec.attribute1);
3077: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE2',
3071:
3072: ELSIF p_desc_flex_name = 'RA_INTERFACE_HEADER' THEN
3073: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);
3074:
3075: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE1',
3076: p_desc_flex_rec.attribute1);
3077: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE2',
3078: p_desc_flex_rec.attribute2);
3079: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE3',
3073: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);
3074:
3075: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE1',
3076: p_desc_flex_rec.attribute1);
3077: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE2',
3078: p_desc_flex_rec.attribute2);
3079: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE3',
3080: p_desc_flex_rec.attribute3);
3081: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE4',
3075: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE1',
3076: p_desc_flex_rec.attribute1);
3077: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE2',
3078: p_desc_flex_rec.attribute2);
3079: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE3',
3080: p_desc_flex_rec.attribute3);
3081: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE4',
3082: p_desc_flex_rec.attribute4);
3083: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE5',
3077: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE2',
3078: p_desc_flex_rec.attribute2);
3079: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE3',
3080: p_desc_flex_rec.attribute3);
3081: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE4',
3082: p_desc_flex_rec.attribute4);
3083: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE5',
3084: p_desc_flex_rec.attribute5);
3085: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE6',
3079: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE3',
3080: p_desc_flex_rec.attribute3);
3081: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE4',
3082: p_desc_flex_rec.attribute4);
3083: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE5',
3084: p_desc_flex_rec.attribute5);
3085: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE6',
3086: p_desc_flex_rec.attribute6);
3087: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE7',
3081: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE4',
3082: p_desc_flex_rec.attribute4);
3083: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE5',
3084: p_desc_flex_rec.attribute5);
3085: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE6',
3086: p_desc_flex_rec.attribute6);
3087: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE7',
3088: p_desc_flex_rec.attribute7);
3089: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE8',
3083: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE5',
3084: p_desc_flex_rec.attribute5);
3085: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE6',
3086: p_desc_flex_rec.attribute6);
3087: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE7',
3088: p_desc_flex_rec.attribute7);
3089: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE8',
3090: p_desc_flex_rec.attribute8);
3091: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE9',
3085: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE6',
3086: p_desc_flex_rec.attribute6);
3087: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE7',
3088: p_desc_flex_rec.attribute7);
3089: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE8',
3090: p_desc_flex_rec.attribute8);
3091: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE9',
3092: p_desc_flex_rec.attribute9);
3093: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE10',
3087: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE7',
3088: p_desc_flex_rec.attribute7);
3089: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE8',
3090: p_desc_flex_rec.attribute8);
3091: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE9',
3092: p_desc_flex_rec.attribute9);
3093: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE10',
3094: p_desc_flex_rec.attribute10);
3095: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE11',
3089: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE8',
3090: p_desc_flex_rec.attribute8);
3091: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE9',
3092: p_desc_flex_rec.attribute9);
3093: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE10',
3094: p_desc_flex_rec.attribute10);
3095: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE11',
3096: p_desc_flex_rec.attribute11);
3097: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE12',
3091: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE9',
3092: p_desc_flex_rec.attribute9);
3093: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE10',
3094: p_desc_flex_rec.attribute10);
3095: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE11',
3096: p_desc_flex_rec.attribute11);
3097: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE12',
3098: p_desc_flex_rec.attribute12);
3099: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE13',
3093: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE10',
3094: p_desc_flex_rec.attribute10);
3095: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE11',
3096: p_desc_flex_rec.attribute11);
3097: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE12',
3098: p_desc_flex_rec.attribute12);
3099: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE13',
3100: p_desc_flex_rec.attribute13);
3101: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE14',
3095: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE11',
3096: p_desc_flex_rec.attribute11);
3097: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE12',
3098: p_desc_flex_rec.attribute12);
3099: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE13',
3100: p_desc_flex_rec.attribute13);
3101: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE14',
3102: p_desc_flex_rec.attribute14);
3103: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE15',
3097: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE12',
3098: p_desc_flex_rec.attribute12);
3099: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE13',
3100: p_desc_flex_rec.attribute13);
3101: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE14',
3102: p_desc_flex_rec.attribute14);
3103: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE15',
3104: p_desc_flex_rec.attribute15);
3105:
3099: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE13',
3100: p_desc_flex_rec.attribute13);
3101: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE14',
3102: p_desc_flex_rec.attribute14);
3103: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE15',
3104: p_desc_flex_rec.attribute15);
3105:
3106:
3107: IF ( NOT fnd_flex_descval.validate_desccols('AR',p_desc_flex_name,'I') )
3103: fnd_flex_descval.set_column_value('INTERFACE_HEADER_ATTRIBUTE15',
3104: p_desc_flex_rec.attribute15);
3105:
3106:
3107: IF ( NOT fnd_flex_descval.validate_desccols('AR',p_desc_flex_name,'I') )
3108: THEN
3109: FND_MESSAGE.SET_NAME('AR', 'AR_RAPI_DESC_FLEX_INVALID');
3110: FND_MESSAGE.SET_TOKEN('DFF_NAME',p_desc_flex_name||' - Flex Field Name : "' ||get_flex_title('RA_INTERFACE_HEADER')||'"');
3111: FND_MSG_PUB.ADD ;
3111: FND_MSG_PUB.ADD ;
3112: p_return_status := FND_API.G_RET_STS_ERROR;
3113: END IF;
3114:
3115: l_count := fnd_flex_descval.segment_count;
3116:
3117:
3118: FOR i in 1..l_count LOOP
3119: l_col_name := fnd_flex_descval.segment_column_name(i);
3115: l_count := fnd_flex_descval.segment_count;
3116:
3117:
3118: FOR i in 1..l_count LOOP
3119: l_col_name := fnd_flex_descval.segment_column_name(i);
3120:
3121: IF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE1' THEN
3122: p_desc_flex_rec.attribute1 := fnd_flex_descval.segment_id(i);
3123: ELSIF l_col_name = 'INTERFACE_HEADER_CONTEXT' THEN
3118: FOR i in 1..l_count LOOP
3119: l_col_name := fnd_flex_descval.segment_column_name(i);
3120:
3121: IF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE1' THEN
3122: p_desc_flex_rec.attribute1 := fnd_flex_descval.segment_id(i);
3123: ELSIF l_col_name = 'INTERFACE_HEADER_CONTEXT' THEN
3124: p_desc_flex_rec.attribute_category := fnd_flex_descval.segment_id(i);
3125: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE2' THEN
3126: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_id(i);
3120:
3121: IF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE1' THEN
3122: p_desc_flex_rec.attribute1 := fnd_flex_descval.segment_id(i);
3123: ELSIF l_col_name = 'INTERFACE_HEADER_CONTEXT' THEN
3124: p_desc_flex_rec.attribute_category := fnd_flex_descval.segment_id(i);
3125: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE2' THEN
3126: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_id(i);
3127: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE3' THEN
3128: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_id(i);
3122: p_desc_flex_rec.attribute1 := fnd_flex_descval.segment_id(i);
3123: ELSIF l_col_name = 'INTERFACE_HEADER_CONTEXT' THEN
3124: p_desc_flex_rec.attribute_category := fnd_flex_descval.segment_id(i);
3125: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE2' THEN
3126: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_id(i);
3127: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE3' THEN
3128: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_id(i);
3129: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE4' THEN
3130: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_id(i);
3124: p_desc_flex_rec.attribute_category := fnd_flex_descval.segment_id(i);
3125: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE2' THEN
3126: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_id(i);
3127: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE3' THEN
3128: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_id(i);
3129: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE4' THEN
3130: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_id(i);
3131: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE5' THEN
3132: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_id(i);
3126: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_id(i);
3127: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE3' THEN
3128: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_id(i);
3129: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE4' THEN
3130: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_id(i);
3131: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE5' THEN
3132: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_id(i);
3133: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE6' THEN
3134: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_id(i);
3128: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_id(i);
3129: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE4' THEN
3130: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_id(i);
3131: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE5' THEN
3132: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_id(i);
3133: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE6' THEN
3134: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_id(i);
3135: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE7' THEN
3136: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_id(i);
3130: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_id(i);
3131: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE5' THEN
3132: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_id(i);
3133: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE6' THEN
3134: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_id(i);
3135: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE7' THEN
3136: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_id(i);
3137: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE8' THEN
3138: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_id(i);
3132: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_id(i);
3133: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE6' THEN
3134: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_id(i);
3135: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE7' THEN
3136: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_id(i);
3137: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE8' THEN
3138: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_id(i);
3139: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE9' THEN
3140: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_id(i);
3134: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_id(i);
3135: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE7' THEN
3136: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_id(i);
3137: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE8' THEN
3138: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_id(i);
3139: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE9' THEN
3140: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_id(i);
3141: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE10' THEN
3142: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_id(i);
3136: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_id(i);
3137: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE8' THEN
3138: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_id(i);
3139: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE9' THEN
3140: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_id(i);
3141: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE10' THEN
3142: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_id(i);
3143: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE11' THEN
3144: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_id(i);
3138: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_id(i);
3139: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE9' THEN
3140: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_id(i);
3141: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE10' THEN
3142: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_id(i);
3143: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE11' THEN
3144: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_id(i);
3145: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE12' THEN
3146: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_id(i);
3140: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_id(i);
3141: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE10' THEN
3142: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_id(i);
3143: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE11' THEN
3144: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_id(i);
3145: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE12' THEN
3146: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_id(i);
3147: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE13' THEN
3148: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_id(i);
3142: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_id(i);
3143: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE11' THEN
3144: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_id(i);
3145: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE12' THEN
3146: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_id(i);
3147: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE13' THEN
3148: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_id(i);
3149: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE14' THEN
3150: p_desc_flex_rec.attribute14 := fnd_flex_descval.segment_id(i);
3144: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_id(i);
3145: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE12' THEN
3146: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_id(i);
3147: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE13' THEN
3148: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_id(i);
3149: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE14' THEN
3150: p_desc_flex_rec.attribute14 := fnd_flex_descval.segment_id(i);
3151: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE15' THEN
3152: p_desc_flex_rec.attribute15 := fnd_flex_descval.segment_id(i);
3146: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_id(i);
3147: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE13' THEN
3148: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_id(i);
3149: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE14' THEN
3150: p_desc_flex_rec.attribute14 := fnd_flex_descval.segment_id(i);
3151: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE15' THEN
3152: p_desc_flex_rec.attribute15 := fnd_flex_descval.segment_id(i);
3153: END IF;
3154:
3148: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_id(i);
3149: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE14' THEN
3150: p_desc_flex_rec.attribute14 := fnd_flex_descval.segment_id(i);
3151: ELSIF l_col_name = 'INTERFACE_HEADER_ATTRIBUTE15' THEN
3152: p_desc_flex_rec.attribute15 := fnd_flex_descval.segment_id(i);
3153: END IF;
3154:
3155: IF i > l_count THEN
3156: EXIT;
3157: END IF;
3158: END LOOP;
3159:
3160: ELSIF p_desc_flex_name = 'RA_INTERFACE_LINES' THEN
3161: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);
3162:
3163: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE1',
3164: p_desc_flex_rec.attribute1);
3165: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE2',
3159:
3160: ELSIF p_desc_flex_name = 'RA_INTERFACE_LINES' THEN
3161: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);
3162:
3163: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE1',
3164: p_desc_flex_rec.attribute1);
3165: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE2',
3166: p_desc_flex_rec.attribute2);
3167: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE3',
3161: fnd_flex_descval.set_context_value(p_desc_flex_rec.attribute_category);
3162:
3163: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE1',
3164: p_desc_flex_rec.attribute1);
3165: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE2',
3166: p_desc_flex_rec.attribute2);
3167: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE3',
3168: p_desc_flex_rec.attribute3);
3169: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE4',
3163: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE1',
3164: p_desc_flex_rec.attribute1);
3165: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE2',
3166: p_desc_flex_rec.attribute2);
3167: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE3',
3168: p_desc_flex_rec.attribute3);
3169: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE4',
3170: p_desc_flex_rec.attribute4);
3171: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE5',
3165: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE2',
3166: p_desc_flex_rec.attribute2);
3167: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE3',
3168: p_desc_flex_rec.attribute3);
3169: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE4',
3170: p_desc_flex_rec.attribute4);
3171: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE5',
3172: p_desc_flex_rec.attribute5);
3173: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE6',
3167: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE3',
3168: p_desc_flex_rec.attribute3);
3169: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE4',
3170: p_desc_flex_rec.attribute4);
3171: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE5',
3172: p_desc_flex_rec.attribute5);
3173: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE6',
3174: p_desc_flex_rec.attribute6);
3175: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE7',
3169: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE4',
3170: p_desc_flex_rec.attribute4);
3171: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE5',
3172: p_desc_flex_rec.attribute5);
3173: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE6',
3174: p_desc_flex_rec.attribute6);
3175: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE7',
3176: p_desc_flex_rec.attribute7);
3177: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE8',
3171: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE5',
3172: p_desc_flex_rec.attribute5);
3173: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE6',
3174: p_desc_flex_rec.attribute6);
3175: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE7',
3176: p_desc_flex_rec.attribute7);
3177: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE8',
3178: p_desc_flex_rec.attribute8);
3179: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE9',
3173: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE6',
3174: p_desc_flex_rec.attribute6);
3175: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE7',
3176: p_desc_flex_rec.attribute7);
3177: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE8',
3178: p_desc_flex_rec.attribute8);
3179: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE9',
3180: p_desc_flex_rec.attribute9);
3181: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE10',
3175: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE7',
3176: p_desc_flex_rec.attribute7);
3177: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE8',
3178: p_desc_flex_rec.attribute8);
3179: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE9',
3180: p_desc_flex_rec.attribute9);
3181: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE10',
3182: p_desc_flex_rec.attribute10);
3183: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE11',
3177: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE8',
3178: p_desc_flex_rec.attribute8);
3179: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE9',
3180: p_desc_flex_rec.attribute9);
3181: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE10',
3182: p_desc_flex_rec.attribute10);
3183: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE11',
3184: p_desc_flex_rec.attribute11);
3185: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE12',
3179: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE9',
3180: p_desc_flex_rec.attribute9);
3181: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE10',
3182: p_desc_flex_rec.attribute10);
3183: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE11',
3184: p_desc_flex_rec.attribute11);
3185: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE12',
3186: p_desc_flex_rec.attribute12);
3187: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE13',
3181: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE10',
3182: p_desc_flex_rec.attribute10);
3183: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE11',
3184: p_desc_flex_rec.attribute11);
3185: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE12',
3186: p_desc_flex_rec.attribute12);
3187: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE13',
3188: p_desc_flex_rec.attribute13);
3189: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE14',
3183: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE11',
3184: p_desc_flex_rec.attribute11);
3185: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE12',
3186: p_desc_flex_rec.attribute12);
3187: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE13',
3188: p_desc_flex_rec.attribute13);
3189: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE14',
3190: p_desc_flex_rec.attribute14);
3191: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE15',
3185: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE12',
3186: p_desc_flex_rec.attribute12);
3187: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE13',
3188: p_desc_flex_rec.attribute13);
3189: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE14',
3190: p_desc_flex_rec.attribute14);
3191: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE15',
3192: p_desc_flex_rec.attribute15);
3193:
3187: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE13',
3188: p_desc_flex_rec.attribute13);
3189: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE14',
3190: p_desc_flex_rec.attribute14);
3191: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE15',
3192: p_desc_flex_rec.attribute15);
3193:
3194:
3195: IF ( NOT fnd_flex_descval.validate_desccols('AR',p_desc_flex_name,'I') )
3191: fnd_flex_descval.set_column_value('INTERFACE_LINE_ATTRIBUTE15',
3192: p_desc_flex_rec.attribute15);
3193:
3194:
3195: IF ( NOT fnd_flex_descval.validate_desccols('AR',p_desc_flex_name,'I') )
3196: THEN
3197: FND_MESSAGE.SET_NAME('AR', 'AR_RAPI_DESC_FLEX_INVALID');
3198: FND_MESSAGE.SET_TOKEN('DFF_NAME',p_desc_flex_name||' - Flex Field Name : "' ||get_flex_title('RA_INTERFACE_LINES')||'"');
3199: FND_MSG_PUB.ADD ;
3199: FND_MSG_PUB.ADD ;
3200: p_return_status := FND_API.G_RET_STS_ERROR;
3201: END IF;
3202:
3203: l_count := fnd_flex_descval.segment_count;
3204:
3205:
3206: FOR i in 1..l_count LOOP
3207: l_col_name := fnd_flex_descval.segment_column_name(i);
3203: l_count := fnd_flex_descval.segment_count;
3204:
3205:
3206: FOR i in 1..l_count LOOP
3207: l_col_name := fnd_flex_descval.segment_column_name(i);
3208:
3209: IF l_col_name = 'INTERFACE_LINE_ATTRIBUTE1' THEN
3210: p_desc_flex_rec.attribute1 := fnd_flex_descval.segment_id(i);
3211: ELSIF l_col_name = 'INTERFACE_LINE_CONTEXT' THEN
3206: FOR i in 1..l_count LOOP
3207: l_col_name := fnd_flex_descval.segment_column_name(i);
3208:
3209: IF l_col_name = 'INTERFACE_LINE_ATTRIBUTE1' THEN
3210: p_desc_flex_rec.attribute1 := fnd_flex_descval.segment_id(i);
3211: ELSIF l_col_name = 'INTERFACE_LINE_CONTEXT' THEN
3212: p_desc_flex_rec.attribute_category := fnd_flex_descval.segment_id(i);
3213: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE2' THEN
3214: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_id(i);
3208:
3209: IF l_col_name = 'INTERFACE_LINE_ATTRIBUTE1' THEN
3210: p_desc_flex_rec.attribute1 := fnd_flex_descval.segment_id(i);
3211: ELSIF l_col_name = 'INTERFACE_LINE_CONTEXT' THEN
3212: p_desc_flex_rec.attribute_category := fnd_flex_descval.segment_id(i);
3213: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE2' THEN
3214: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_id(i);
3215: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE3' THEN
3216: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_id(i);
3210: p_desc_flex_rec.attribute1 := fnd_flex_descval.segment_id(i);
3211: ELSIF l_col_name = 'INTERFACE_LINE_CONTEXT' THEN
3212: p_desc_flex_rec.attribute_category := fnd_flex_descval.segment_id(i);
3213: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE2' THEN
3214: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_id(i);
3215: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE3' THEN
3216: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_id(i);
3217: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE4' THEN
3218: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_id(i);
3212: p_desc_flex_rec.attribute_category := fnd_flex_descval.segment_id(i);
3213: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE2' THEN
3214: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_id(i);
3215: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE3' THEN
3216: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_id(i);
3217: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE4' THEN
3218: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_id(i);
3219: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE5' THEN
3220: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_id(i);
3214: p_desc_flex_rec.attribute2 := fnd_flex_descval.segment_id(i);
3215: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE3' THEN
3216: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_id(i);
3217: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE4' THEN
3218: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_id(i);
3219: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE5' THEN
3220: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_id(i);
3221: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE6' THEN
3222: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_id(i);
3216: p_desc_flex_rec.attribute3 := fnd_flex_descval.segment_id(i);
3217: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE4' THEN
3218: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_id(i);
3219: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE5' THEN
3220: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_id(i);
3221: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE6' THEN
3222: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_id(i);
3223: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE7' THEN
3224: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_id(i);
3218: p_desc_flex_rec.attribute4 := fnd_flex_descval.segment_id(i);
3219: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE5' THEN
3220: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_id(i);
3221: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE6' THEN
3222: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_id(i);
3223: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE7' THEN
3224: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_id(i);
3225: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE8' THEN
3226: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_id(i);
3220: p_desc_flex_rec.attribute5 := fnd_flex_descval.segment_id(i);
3221: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE6' THEN
3222: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_id(i);
3223: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE7' THEN
3224: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_id(i);
3225: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE8' THEN
3226: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_id(i);
3227: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE9' THEN
3228: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_id(i);
3222: p_desc_flex_rec.attribute6 := fnd_flex_descval.segment_id(i);
3223: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE7' THEN
3224: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_id(i);
3225: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE8' THEN
3226: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_id(i);
3227: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE9' THEN
3228: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_id(i);
3229: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE10' THEN
3230: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_id(i);
3224: p_desc_flex_rec.attribute7 := fnd_flex_descval.segment_id(i);
3225: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE8' THEN
3226: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_id(i);
3227: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE9' THEN
3228: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_id(i);
3229: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE10' THEN
3230: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_id(i);
3231: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE11' THEN
3232: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_id(i);
3226: p_desc_flex_rec.attribute8 := fnd_flex_descval.segment_id(i);
3227: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE9' THEN
3228: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_id(i);
3229: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE10' THEN
3230: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_id(i);
3231: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE11' THEN
3232: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_id(i);
3233: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE12' THEN
3234: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_id(i);
3228: p_desc_flex_rec.attribute9 := fnd_flex_descval.segment_id(i);
3229: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE10' THEN
3230: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_id(i);
3231: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE11' THEN
3232: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_id(i);
3233: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE12' THEN
3234: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_id(i);
3235: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE13' THEN
3236: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_id(i);
3230: p_desc_flex_rec.attribute10 := fnd_flex_descval.segment_id(i);
3231: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE11' THEN
3232: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_id(i);
3233: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE12' THEN
3234: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_id(i);
3235: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE13' THEN
3236: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_id(i);
3237: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE14' THEN
3238: p_desc_flex_rec.attribute14 := fnd_flex_descval.segment_id(i);
3232: p_desc_flex_rec.attribute11 := fnd_flex_descval.segment_id(i);
3233: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE12' THEN
3234: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_id(i);
3235: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE13' THEN
3236: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_id(i);
3237: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE14' THEN
3238: p_desc_flex_rec.attribute14 := fnd_flex_descval.segment_id(i);
3239: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE15' THEN
3240: p_desc_flex_rec.attribute15 := fnd_flex_descval.segment_id(i);
3234: p_desc_flex_rec.attribute12 := fnd_flex_descval.segment_id(i);
3235: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE13' THEN
3236: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_id(i);
3237: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE14' THEN
3238: p_desc_flex_rec.attribute14 := fnd_flex_descval.segment_id(i);
3239: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE15' THEN
3240: p_desc_flex_rec.attribute15 := fnd_flex_descval.segment_id(i);
3241: END IF;
3242:
3236: p_desc_flex_rec.attribute13 := fnd_flex_descval.segment_id(i);
3237: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE14' THEN
3238: p_desc_flex_rec.attribute14 := fnd_flex_descval.segment_id(i);
3239: ELSIF l_col_name = 'INTERFACE_LINE_ATTRIBUTE15' THEN
3240: p_desc_flex_rec.attribute15 := fnd_flex_descval.segment_id(i);
3241: END IF;
3242:
3243: IF i > l_count THEN
3244: EXIT;