2619: l_r VARCHAR2(2000);
2620: BEGIN
2621:
2622: -- DEFINE ID COLUMNS
2623: fnd_flex_descval.set_context_value(p_attribute_category);
2624: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2625: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2626: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2627: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2620: BEGIN
2621:
2622: -- DEFINE ID COLUMNS
2623: fnd_flex_descval.set_context_value(p_attribute_category);
2624: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2625: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2626: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2627: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2628: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2621:
2622: -- DEFINE ID COLUMNS
2623: fnd_flex_descval.set_context_value(p_attribute_category);
2624: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2625: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2626: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2627: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2628: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2629: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2622: -- DEFINE ID COLUMNS
2623: fnd_flex_descval.set_context_value(p_attribute_category);
2624: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2625: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2626: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2627: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2628: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2629: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2630: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2623: fnd_flex_descval.set_context_value(p_attribute_category);
2624: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2625: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2626: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2627: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2628: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2629: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2630: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2631: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2624: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2625: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2626: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2627: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2628: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2629: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2630: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2631: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2632: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2625: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2626: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2627: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2628: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2629: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2630: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2631: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2632: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2633: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2626: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2627: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2628: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2629: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2630: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2631: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2632: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2633: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2634: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2627: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2628: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2629: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2630: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2631: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2632: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2633: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2634: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2635: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2628: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2629: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2630: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2631: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2632: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2633: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2634: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2635: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2636: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13);
2629: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2630: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2631: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2632: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2633: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2634: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2635: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2636: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13);
2637: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14);
2630: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2631: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2632: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2633: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2634: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2635: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2636: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13);
2637: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14);
2638: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15);
2631: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2632: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2633: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2634: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2635: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2636: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13);
2637: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14);
2638: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15);
2639: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16);
2632: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2633: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2634: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2635: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2636: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13);
2637: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14);
2638: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15);
2639: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16);
2640: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17);
2633: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2634: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2635: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2636: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13);
2637: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14);
2638: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15);
2639: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16);
2640: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17);
2641: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18);
2634: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2635: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2636: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13);
2637: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14);
2638: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15);
2639: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16);
2640: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17);
2641: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18);
2642: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19);
2635: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2636: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13);
2637: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14);
2638: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15);
2639: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16);
2640: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17);
2641: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18);
2642: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19);
2643: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20);
2636: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13);
2637: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14);
2638: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15);
2639: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16);
2640: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17);
2641: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18);
2642: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19);
2643: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20);
2644: fnd_flex_descval.set_column_value('ATTRIBUTE21', p_attribute21);
2637: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14);
2638: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15);
2639: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16);
2640: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17);
2641: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18);
2642: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19);
2643: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20);
2644: fnd_flex_descval.set_column_value('ATTRIBUTE21', p_attribute21);
2645: fnd_flex_descval.set_column_value('ATTRIBUTE22', p_attribute22);
2638: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15);
2639: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16);
2640: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17);
2641: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18);
2642: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19);
2643: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20);
2644: fnd_flex_descval.set_column_value('ATTRIBUTE21', p_attribute21);
2645: fnd_flex_descval.set_column_value('ATTRIBUTE22', p_attribute22);
2646: fnd_flex_descval.set_column_value('ATTRIBUTE23', p_attribute23);
2639: fnd_flex_descval.set_column_value('ATTRIBUTE16', p_attribute16);
2640: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17);
2641: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18);
2642: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19);
2643: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20);
2644: fnd_flex_descval.set_column_value('ATTRIBUTE21', p_attribute21);
2645: fnd_flex_descval.set_column_value('ATTRIBUTE22', p_attribute22);
2646: fnd_flex_descval.set_column_value('ATTRIBUTE23', p_attribute23);
2647: fnd_flex_descval.set_column_value('ATTRIBUTE24', p_attribute24);
2640: fnd_flex_descval.set_column_value('ATTRIBUTE17', p_attribute17);
2641: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18);
2642: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19);
2643: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20);
2644: fnd_flex_descval.set_column_value('ATTRIBUTE21', p_attribute21);
2645: fnd_flex_descval.set_column_value('ATTRIBUTE22', p_attribute22);
2646: fnd_flex_descval.set_column_value('ATTRIBUTE23', p_attribute23);
2647: fnd_flex_descval.set_column_value('ATTRIBUTE24', p_attribute24);
2648: fnd_flex_descval.set_column_value('ATTRIBUTE25', p_attribute25);
2641: fnd_flex_descval.set_column_value('ATTRIBUTE18', p_attribute18);
2642: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19);
2643: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20);
2644: fnd_flex_descval.set_column_value('ATTRIBUTE21', p_attribute21);
2645: fnd_flex_descval.set_column_value('ATTRIBUTE22', p_attribute22);
2646: fnd_flex_descval.set_column_value('ATTRIBUTE23', p_attribute23);
2647: fnd_flex_descval.set_column_value('ATTRIBUTE24', p_attribute24);
2648: fnd_flex_descval.set_column_value('ATTRIBUTE25', p_attribute25);
2649:
2642: fnd_flex_descval.set_column_value('ATTRIBUTE19', p_attribute19);
2643: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20);
2644: fnd_flex_descval.set_column_value('ATTRIBUTE21', p_attribute21);
2645: fnd_flex_descval.set_column_value('ATTRIBUTE22', p_attribute22);
2646: fnd_flex_descval.set_column_value('ATTRIBUTE23', p_attribute23);
2647: fnd_flex_descval.set_column_value('ATTRIBUTE24', p_attribute24);
2648: fnd_flex_descval.set_column_value('ATTRIBUTE25', p_attribute25);
2649:
2650: -- VALIDATE
2643: fnd_flex_descval.set_column_value('ATTRIBUTE20', p_attribute20);
2644: fnd_flex_descval.set_column_value('ATTRIBUTE21', p_attribute21);
2645: fnd_flex_descval.set_column_value('ATTRIBUTE22', p_attribute22);
2646: fnd_flex_descval.set_column_value('ATTRIBUTE23', p_attribute23);
2647: fnd_flex_descval.set_column_value('ATTRIBUTE24', p_attribute24);
2648: fnd_flex_descval.set_column_value('ATTRIBUTE25', p_attribute25);
2649:
2650: -- VALIDATE
2651: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name)) then
2644: fnd_flex_descval.set_column_value('ATTRIBUTE21', p_attribute21);
2645: fnd_flex_descval.set_column_value('ATTRIBUTE22', p_attribute22);
2646: fnd_flex_descval.set_column_value('ATTRIBUTE23', p_attribute23);
2647: fnd_flex_descval.set_column_value('ATTRIBUTE24', p_attribute24);
2648: fnd_flex_descval.set_column_value('ATTRIBUTE25', p_attribute25);
2649:
2650: -- VALIDATE
2651: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name)) then
2652: p_RETURN_msg := 'VALID: ' || fnd_flex_descval.concatenated_ids;
2647: fnd_flex_descval.set_column_value('ATTRIBUTE24', p_attribute24);
2648: fnd_flex_descval.set_column_value('ATTRIBUTE25', p_attribute25);
2649:
2650: -- VALIDATE
2651: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name)) then
2652: p_RETURN_msg := 'VALID: ' || fnd_flex_descval.concatenated_ids;
2653: p_validate_status := 'Y';
2654: ELSE
2655: p_RETURN_msg := 'INVALID: ' || fnd_flex_descval.error_message;
2648: fnd_flex_descval.set_column_value('ATTRIBUTE25', p_attribute25);
2649:
2650: -- VALIDATE
2651: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name)) then
2652: p_RETURN_msg := 'VALID: ' || fnd_flex_descval.concatenated_ids;
2653: p_validate_status := 'Y';
2654: ELSE
2655: p_RETURN_msg := 'INVALID: ' || fnd_flex_descval.error_message;
2656: p_validate_status := 'N';
2651: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name)) then
2652: p_RETURN_msg := 'VALID: ' || fnd_flex_descval.concatenated_ids;
2653: p_validate_status := 'Y';
2654: ELSE
2655: p_RETURN_msg := 'INVALID: ' || fnd_flex_descval.error_message;
2656: p_validate_status := 'N';
2657: END IF;
2658: END validate_flex_fields;
2659: