2267: l_r VARCHAR2(2000);
2268: BEGIN
2269:
2270: -- DEFINE ID COLUMNS
2271: fnd_flex_descval.set_context_value(p_attribute_category);
2272: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2273: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2274: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2275: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2268: BEGIN
2269:
2270: -- DEFINE ID COLUMNS
2271: fnd_flex_descval.set_context_value(p_attribute_category);
2272: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2273: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2274: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2275: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2276: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2269:
2270: -- DEFINE ID COLUMNS
2271: fnd_flex_descval.set_context_value(p_attribute_category);
2272: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2273: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2274: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2275: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2276: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2277: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2270: -- DEFINE ID COLUMNS
2271: fnd_flex_descval.set_context_value(p_attribute_category);
2272: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2273: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2274: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2275: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2276: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2277: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2278: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2271: fnd_flex_descval.set_context_value(p_attribute_category);
2272: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2273: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2274: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2275: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2276: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2277: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2278: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2279: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2272: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2273: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2274: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2275: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2276: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2277: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2278: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2279: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2280: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2273: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2274: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2275: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2276: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2277: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2278: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2279: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2280: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2281: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2274: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2275: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2276: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2277: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2278: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2279: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2280: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2281: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2282: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2275: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2276: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2277: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2278: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2279: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2280: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2281: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2282: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2283: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2276: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2277: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2278: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2279: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2280: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2281: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2282: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2283: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2284: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13);
2277: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2278: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2279: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2280: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2281: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2282: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2283: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2284: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13);
2285: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14);
2278: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2279: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2280: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2281: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2282: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2283: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2284: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13);
2285: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14);
2286: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15);
2279: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2280: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2281: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2282: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2283: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2284: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13);
2285: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14);
2286: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15);
2287:
2280: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2281: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2282: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2283: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2284: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13);
2285: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14);
2286: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15);
2287:
2288: -- VALIDATE
2281: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2282: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2283: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2284: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13);
2285: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14);
2286: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15);
2287:
2288: -- VALIDATE
2289: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name)) then
2282: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2283: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2284: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13);
2285: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14);
2286: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15);
2287:
2288: -- VALIDATE
2289: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name)) then
2290: p_RETURN_msg := 'VALID: ' || fnd_flex_descval.concatenated_ids;
2285: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14);
2286: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15);
2287:
2288: -- VALIDATE
2289: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name)) then
2290: p_RETURN_msg := 'VALID: ' || fnd_flex_descval.concatenated_ids;
2291: p_validate_status := 'Y';
2292: ELSE
2293: p_RETURN_msg := 'INVALID: ' || fnd_flex_descval.error_message;
2286: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15);
2287:
2288: -- VALIDATE
2289: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name)) then
2290: p_RETURN_msg := 'VALID: ' || fnd_flex_descval.concatenated_ids;
2291: p_validate_status := 'Y';
2292: ELSE
2293: p_RETURN_msg := 'INVALID: ' || fnd_flex_descval.error_message;
2294: p_validate_status := 'N';
2289: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name)) then
2290: p_RETURN_msg := 'VALID: ' || fnd_flex_descval.concatenated_ids;
2291: p_validate_status := 'Y';
2292: ELSE
2293: p_RETURN_msg := 'INVALID: ' || fnd_flex_descval.error_message;
2294: p_validate_status := 'N';
2295: END IF;
2296: EXCEPTION -- 4537865
2297: WHEN OTHERS THEN