2171:
2172: --*********************************************************
2173: --* set the context value *
2174: --*********************************************************
2175: FND_FLEX_DESCVAL.set_context_value(p_context_value);
2176: --*********************************************************
2177: --* set the address attributes value *
2178: --*********************************************************
2179: fnd_flex_descval.set_column_value('ADDRESS1', p_address1 );
2175: FND_FLEX_DESCVAL.set_context_value(p_context_value);
2176: --*********************************************************
2177: --* set the address attributes value *
2178: --*********************************************************
2179: fnd_flex_descval.set_column_value('ADDRESS1', p_address1 );
2180: fnd_flex_descval.set_column_value('ADDRESS2', p_address2 );
2181: fnd_flex_descval.set_column_value('ADDRESS3', p_address3 );
2182: fnd_flex_descval.set_column_value('ADDRESS4', p_address4 );
2183: fnd_flex_descval.set_column_value('ADDRESS_LINES_PHONETIC', p_address_lines_phonetic );
2176: --*********************************************************
2177: --* set the address attributes value *
2178: --*********************************************************
2179: fnd_flex_descval.set_column_value('ADDRESS1', p_address1 );
2180: fnd_flex_descval.set_column_value('ADDRESS2', p_address2 );
2181: fnd_flex_descval.set_column_value('ADDRESS3', p_address3 );
2182: fnd_flex_descval.set_column_value('ADDRESS4', p_address4 );
2183: fnd_flex_descval.set_column_value('ADDRESS_LINES_PHONETIC', p_address_lines_phonetic );
2184: fnd_flex_descval.set_column_value('CITY', p_city );
2177: --* set the address attributes value *
2178: --*********************************************************
2179: fnd_flex_descval.set_column_value('ADDRESS1', p_address1 );
2180: fnd_flex_descval.set_column_value('ADDRESS2', p_address2 );
2181: fnd_flex_descval.set_column_value('ADDRESS3', p_address3 );
2182: fnd_flex_descval.set_column_value('ADDRESS4', p_address4 );
2183: fnd_flex_descval.set_column_value('ADDRESS_LINES_PHONETIC', p_address_lines_phonetic );
2184: fnd_flex_descval.set_column_value('CITY', p_city );
2185: fnd_flex_descval.set_column_value('COUNTY', p_county );
2178: --*********************************************************
2179: fnd_flex_descval.set_column_value('ADDRESS1', p_address1 );
2180: fnd_flex_descval.set_column_value('ADDRESS2', p_address2 );
2181: fnd_flex_descval.set_column_value('ADDRESS3', p_address3 );
2182: fnd_flex_descval.set_column_value('ADDRESS4', p_address4 );
2183: fnd_flex_descval.set_column_value('ADDRESS_LINES_PHONETIC', p_address_lines_phonetic );
2184: fnd_flex_descval.set_column_value('CITY', p_city );
2185: fnd_flex_descval.set_column_value('COUNTY', p_county );
2186: fnd_flex_descval.set_column_value('STATE', p_state );
2179: fnd_flex_descval.set_column_value('ADDRESS1', p_address1 );
2180: fnd_flex_descval.set_column_value('ADDRESS2', p_address2 );
2181: fnd_flex_descval.set_column_value('ADDRESS3', p_address3 );
2182: fnd_flex_descval.set_column_value('ADDRESS4', p_address4 );
2183: fnd_flex_descval.set_column_value('ADDRESS_LINES_PHONETIC', p_address_lines_phonetic );
2184: fnd_flex_descval.set_column_value('CITY', p_city );
2185: fnd_flex_descval.set_column_value('COUNTY', p_county );
2186: fnd_flex_descval.set_column_value('STATE', p_state );
2187: fnd_flex_descval.set_column_value('PROVINCE', p_province );
2180: fnd_flex_descval.set_column_value('ADDRESS2', p_address2 );
2181: fnd_flex_descval.set_column_value('ADDRESS3', p_address3 );
2182: fnd_flex_descval.set_column_value('ADDRESS4', p_address4 );
2183: fnd_flex_descval.set_column_value('ADDRESS_LINES_PHONETIC', p_address_lines_phonetic );
2184: fnd_flex_descval.set_column_value('CITY', p_city );
2185: fnd_flex_descval.set_column_value('COUNTY', p_county );
2186: fnd_flex_descval.set_column_value('STATE', p_state );
2187: fnd_flex_descval.set_column_value('PROVINCE', p_province );
2188: fnd_flex_descval.set_column_value('POSTAL_CODE', p_postal_code);
2181: fnd_flex_descval.set_column_value('ADDRESS3', p_address3 );
2182: fnd_flex_descval.set_column_value('ADDRESS4', p_address4 );
2183: fnd_flex_descval.set_column_value('ADDRESS_LINES_PHONETIC', p_address_lines_phonetic );
2184: fnd_flex_descval.set_column_value('CITY', p_city );
2185: fnd_flex_descval.set_column_value('COUNTY', p_county );
2186: fnd_flex_descval.set_column_value('STATE', p_state );
2187: fnd_flex_descval.set_column_value('PROVINCE', p_province );
2188: fnd_flex_descval.set_column_value('POSTAL_CODE', p_postal_code);
2189: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1 );
2182: fnd_flex_descval.set_column_value('ADDRESS4', p_address4 );
2183: fnd_flex_descval.set_column_value('ADDRESS_LINES_PHONETIC', p_address_lines_phonetic );
2184: fnd_flex_descval.set_column_value('CITY', p_city );
2185: fnd_flex_descval.set_column_value('COUNTY', p_county );
2186: fnd_flex_descval.set_column_value('STATE', p_state );
2187: fnd_flex_descval.set_column_value('PROVINCE', p_province );
2188: fnd_flex_descval.set_column_value('POSTAL_CODE', p_postal_code);
2189: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1 );
2190: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2 );
2183: fnd_flex_descval.set_column_value('ADDRESS_LINES_PHONETIC', p_address_lines_phonetic );
2184: fnd_flex_descval.set_column_value('CITY', p_city );
2185: fnd_flex_descval.set_column_value('COUNTY', p_county );
2186: fnd_flex_descval.set_column_value('STATE', p_state );
2187: fnd_flex_descval.set_column_value('PROVINCE', p_province );
2188: fnd_flex_descval.set_column_value('POSTAL_CODE', p_postal_code);
2189: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1 );
2190: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2 );
2191: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3 );
2184: fnd_flex_descval.set_column_value('CITY', p_city );
2185: fnd_flex_descval.set_column_value('COUNTY', p_county );
2186: fnd_flex_descval.set_column_value('STATE', p_state );
2187: fnd_flex_descval.set_column_value('PROVINCE', p_province );
2188: fnd_flex_descval.set_column_value('POSTAL_CODE', p_postal_code);
2189: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1 );
2190: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2 );
2191: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3 );
2192: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4 );
2185: fnd_flex_descval.set_column_value('COUNTY', p_county );
2186: fnd_flex_descval.set_column_value('STATE', p_state );
2187: fnd_flex_descval.set_column_value('PROVINCE', p_province );
2188: fnd_flex_descval.set_column_value('POSTAL_CODE', p_postal_code);
2189: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1 );
2190: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2 );
2191: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3 );
2192: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4 );
2193: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5 );
2186: fnd_flex_descval.set_column_value('STATE', p_state );
2187: fnd_flex_descval.set_column_value('PROVINCE', p_province );
2188: fnd_flex_descval.set_column_value('POSTAL_CODE', p_postal_code);
2189: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1 );
2190: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2 );
2191: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3 );
2192: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4 );
2193: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5 );
2194: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6 );
2187: fnd_flex_descval.set_column_value('PROVINCE', p_province );
2188: fnd_flex_descval.set_column_value('POSTAL_CODE', p_postal_code);
2189: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1 );
2190: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2 );
2191: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3 );
2192: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4 );
2193: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5 );
2194: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6 );
2195: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7 );
2188: fnd_flex_descval.set_column_value('POSTAL_CODE', p_postal_code);
2189: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1 );
2190: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2 );
2191: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3 );
2192: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4 );
2193: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5 );
2194: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6 );
2195: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7 );
2196: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8 );
2189: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1 );
2190: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2 );
2191: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3 );
2192: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4 );
2193: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5 );
2194: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6 );
2195: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7 );
2196: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8 );
2197: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9 );
2190: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2 );
2191: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3 );
2192: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4 );
2193: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5 );
2194: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6 );
2195: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7 );
2196: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8 );
2197: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9 );
2198: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10 );
2191: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3 );
2192: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4 );
2193: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5 );
2194: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6 );
2195: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7 );
2196: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8 );
2197: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9 );
2198: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10 );
2199: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11 );
2192: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4 );
2193: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5 );
2194: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6 );
2195: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7 );
2196: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8 );
2197: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9 );
2198: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10 );
2199: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11 );
2200: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12 );
2193: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5 );
2194: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6 );
2195: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7 );
2196: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8 );
2197: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9 );
2198: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10 );
2199: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11 );
2200: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12 );
2201: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13 );
2194: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6 );
2195: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7 );
2196: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8 );
2197: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9 );
2198: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10 );
2199: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11 );
2200: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12 );
2201: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13 );
2202: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14 );
2195: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7 );
2196: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8 );
2197: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9 );
2198: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10 );
2199: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11 );
2200: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12 );
2201: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13 );
2202: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14 );
2203: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15 );
2196: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8 );
2197: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9 );
2198: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10 );
2199: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11 );
2200: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12 );
2201: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13 );
2202: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14 );
2203: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15 );
2204: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16 );
2197: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9 );
2198: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10 );
2199: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11 );
2200: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12 );
2201: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13 );
2202: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14 );
2203: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15 );
2204: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16 );
2205: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17 );
2198: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10 );
2199: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11 );
2200: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12 );
2201: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13 );
2202: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14 );
2203: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15 );
2204: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16 );
2205: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17 );
2206: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18 );
2199: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11 );
2200: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12 );
2201: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13 );
2202: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14 );
2203: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15 );
2204: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16 );
2205: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17 );
2206: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18 );
2207: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19 );
2200: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12 );
2201: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13 );
2202: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14 );
2203: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15 );
2204: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16 );
2205: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17 );
2206: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18 );
2207: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19 );
2208: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20 );
2201: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13 );
2202: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14 );
2203: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15 );
2204: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16 );
2205: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17 );
2206: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18 );
2207: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19 );
2208: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20 );
2209: fnd_flex_descval.set_column_value('POSTAL_PLUS4_CODE', p_postal_plu4_code); -- added against bug 7671107
2202: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14 );
2203: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15 );
2204: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16 );
2205: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17 );
2206: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18 );
2207: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19 );
2208: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20 );
2209: fnd_flex_descval.set_column_value('POSTAL_PLUS4_CODE', p_postal_plu4_code); -- added against bug 7671107
2210:
2203: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15 );
2204: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16 );
2205: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17 );
2206: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18 );
2207: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19 );
2208: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20 );
2209: fnd_flex_descval.set_column_value('POSTAL_PLUS4_CODE', p_postal_plu4_code); -- added against bug 7671107
2210:
2211: IF FND_FLEX_DESCVAL.validate_desccols(
2204: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16 );
2205: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17 );
2206: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18 );
2207: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19 );
2208: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20 );
2209: fnd_flex_descval.set_column_value('POSTAL_PLUS4_CODE', p_postal_plu4_code); -- added against bug 7671107
2210:
2211: IF FND_FLEX_DESCVAL.validate_desccols(
2212: appl_short_name,
2205: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17 );
2206: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18 );
2207: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19 );
2208: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20 );
2209: fnd_flex_descval.set_column_value('POSTAL_PLUS4_CODE', p_postal_plu4_code); -- added against bug 7671107
2210:
2211: IF FND_FLEX_DESCVAL.validate_desccols(
2212: appl_short_name,
2213: desc_flex_name,
2207: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19 );
2208: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20 );
2209: fnd_flex_descval.set_column_value('POSTAL_PLUS4_CODE', p_postal_plu4_code); -- added against bug 7671107
2210:
2211: IF FND_FLEX_DESCVAL.validate_desccols(
2212: appl_short_name,
2213: desc_flex_name,
2214: values_or_ids,
2215: validation_date)
2221: END IF;
2222:
2223: EXCEPTION
2224: WHEN errors_received THEN
2225: error_msg := fnd_flex_descval.encoded_error_message;
2226: FND_MESSAGE.SET_ENCODED(error_msg);
2227: FND_MSG_PUB.Add;
2228: return l_return;
2229: WHEN others THEN
2312:
2313: --*********************************************************
2314: --* set the context value *
2315: --*********************************************************
2316: FND_FLEX_DESCVAL.set_context_value(p_context_value);
2317: --*********************************************************
2318: --* set the attributes value *
2319: --*********************************************************
2320: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1 );
2316: FND_FLEX_DESCVAL.set_context_value(p_context_value);
2317: --*********************************************************
2318: --* set the attributes value *
2319: --*********************************************************
2320: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1 );
2321: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2 );
2322: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3 );
2323: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4 );
2324: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5 );
2317: --*********************************************************
2318: --* set the attributes value *
2319: --*********************************************************
2320: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1 );
2321: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2 );
2322: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3 );
2323: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4 );
2324: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5 );
2325: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6 );
2318: --* set the attributes value *
2319: --*********************************************************
2320: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1 );
2321: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2 );
2322: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3 );
2323: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4 );
2324: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5 );
2325: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6 );
2326: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7 );
2319: --*********************************************************
2320: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1 );
2321: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2 );
2322: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3 );
2323: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4 );
2324: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5 );
2325: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6 );
2326: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7 );
2327: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8 );
2320: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1 );
2321: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2 );
2322: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3 );
2323: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4 );
2324: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5 );
2325: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6 );
2326: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7 );
2327: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8 );
2328: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9 );
2321: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2 );
2322: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3 );
2323: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4 );
2324: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5 );
2325: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6 );
2326: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7 );
2327: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8 );
2328: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9 );
2329: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10 );
2322: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3 );
2323: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4 );
2324: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5 );
2325: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6 );
2326: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7 );
2327: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8 );
2328: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9 );
2329: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10 );
2330: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11 );
2323: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4 );
2324: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5 );
2325: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6 );
2326: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7 );
2327: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8 );
2328: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9 );
2329: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10 );
2330: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11 );
2331: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12 );
2324: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5 );
2325: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6 );
2326: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7 );
2327: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8 );
2328: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9 );
2329: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10 );
2330: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11 );
2331: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12 );
2332: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13 );
2325: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6 );
2326: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7 );
2327: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8 );
2328: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9 );
2329: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10 );
2330: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11 );
2331: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12 );
2332: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13 );
2333: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14 );
2326: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7 );
2327: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8 );
2328: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9 );
2329: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10 );
2330: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11 );
2331: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12 );
2332: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13 );
2333: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14 );
2334: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15 );
2327: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8 );
2328: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9 );
2329: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10 );
2330: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11 );
2331: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12 );
2332: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13 );
2333: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14 );
2334: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15 );
2335: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16 );
2328: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9 );
2329: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10 );
2330: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11 );
2331: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12 );
2332: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13 );
2333: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14 );
2334: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15 );
2335: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16 );
2336: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17 );
2329: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10 );
2330: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11 );
2331: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12 );
2332: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13 );
2333: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14 );
2334: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15 );
2335: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16 );
2336: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17 );
2337: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18 );
2330: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11 );
2331: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12 );
2332: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13 );
2333: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14 );
2334: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15 );
2335: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16 );
2336: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17 );
2337: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18 );
2338: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19 );
2331: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12 );
2332: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13 );
2333: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14 );
2334: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15 );
2335: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16 );
2336: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17 );
2337: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18 );
2338: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19 );
2339: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20 );
2332: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13 );
2333: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14 );
2334: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15 );
2335: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16 );
2336: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17 );
2337: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18 );
2338: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19 );
2339: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20 );
2340: IF p_desc_flex_name <> 'HZ_PARTY_SITES' THEN
2333: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14 );
2334: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15 );
2335: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16 );
2336: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17 );
2337: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18 );
2338: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19 );
2339: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20 );
2340: IF p_desc_flex_name <> 'HZ_PARTY_SITES' THEN
2341: fnd_flex_descval.set_column_value('ATTRIBUTE21', p_attribute21 );
2334: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15 );
2335: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16 );
2336: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17 );
2337: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18 );
2338: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19 );
2339: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20 );
2340: IF p_desc_flex_name <> 'HZ_PARTY_SITES' THEN
2341: fnd_flex_descval.set_column_value('ATTRIBUTE21', p_attribute21 );
2342: fnd_flex_descval.set_column_value('ATTRIBUTE22', p_attribute22 );
2335: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16 );
2336: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17 );
2337: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18 );
2338: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19 );
2339: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20 );
2340: IF p_desc_flex_name <> 'HZ_PARTY_SITES' THEN
2341: fnd_flex_descval.set_column_value('ATTRIBUTE21', p_attribute21 );
2342: fnd_flex_descval.set_column_value('ATTRIBUTE22', p_attribute22 );
2343: fnd_flex_descval.set_column_value('ATTRIBUTE23', p_attribute23 );
2337: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18 );
2338: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19 );
2339: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20 );
2340: IF p_desc_flex_name <> 'HZ_PARTY_SITES' THEN
2341: fnd_flex_descval.set_column_value('ATTRIBUTE21', p_attribute21 );
2342: fnd_flex_descval.set_column_value('ATTRIBUTE22', p_attribute22 );
2343: fnd_flex_descval.set_column_value('ATTRIBUTE23', p_attribute23 );
2344: fnd_flex_descval.set_column_value('ATTRIBUTE24', p_attribute24 );
2345: END IF;
2338: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19 );
2339: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20 );
2340: IF p_desc_flex_name <> 'HZ_PARTY_SITES' THEN
2341: fnd_flex_descval.set_column_value('ATTRIBUTE21', p_attribute21 );
2342: fnd_flex_descval.set_column_value('ATTRIBUTE22', p_attribute22 );
2343: fnd_flex_descval.set_column_value('ATTRIBUTE23', p_attribute23 );
2344: fnd_flex_descval.set_column_value('ATTRIBUTE24', p_attribute24 );
2345: END IF;
2346:
2339: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20 );
2340: IF p_desc_flex_name <> 'HZ_PARTY_SITES' THEN
2341: fnd_flex_descval.set_column_value('ATTRIBUTE21', p_attribute21 );
2342: fnd_flex_descval.set_column_value('ATTRIBUTE22', p_attribute22 );
2343: fnd_flex_descval.set_column_value('ATTRIBUTE23', p_attribute23 );
2344: fnd_flex_descval.set_column_value('ATTRIBUTE24', p_attribute24 );
2345: END IF;
2346:
2347: IF FND_FLEX_DESCVAL.validate_desccols(
2340: IF p_desc_flex_name <> 'HZ_PARTY_SITES' THEN
2341: fnd_flex_descval.set_column_value('ATTRIBUTE21', p_attribute21 );
2342: fnd_flex_descval.set_column_value('ATTRIBUTE22', p_attribute22 );
2343: fnd_flex_descval.set_column_value('ATTRIBUTE23', p_attribute23 );
2344: fnd_flex_descval.set_column_value('ATTRIBUTE24', p_attribute24 );
2345: END IF;
2346:
2347: IF FND_FLEX_DESCVAL.validate_desccols(
2348: appl_short_name,
2343: fnd_flex_descval.set_column_value('ATTRIBUTE23', p_attribute23 );
2344: fnd_flex_descval.set_column_value('ATTRIBUTE24', p_attribute24 );
2345: END IF;
2346:
2347: IF FND_FLEX_DESCVAL.validate_desccols(
2348: appl_short_name,
2349: desc_flex_name,
2350: values_or_ids,
2351: validation_date)
2357: END IF;
2358:
2359: EXCEPTION
2360: WHEN errors_received THEN
2361: error_msg := fnd_flex_descval.encoded_error_message;
2362: FND_MESSAGE.SET_ENCODED(error_msg);
2363: FND_MSG_PUB.Add;
2364: return l_return;
2365: WHEN others THEN