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