2479: l_r VARCHAR2(2000);
2480: BEGIN
2481:
2482: -- DEFINE ID COLUMNS
2483: fnd_flex_descval.set_context_value(p_attribute_category);
2484: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2485: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2486: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2487: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2480: BEGIN
2481:
2482: -- DEFINE ID COLUMNS
2483: fnd_flex_descval.set_context_value(p_attribute_category);
2484: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2485: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2486: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2487: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2488: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2481:
2482: -- DEFINE ID COLUMNS
2483: fnd_flex_descval.set_context_value(p_attribute_category);
2484: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2485: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2486: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2487: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2488: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2489: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2482: -- DEFINE ID COLUMNS
2483: fnd_flex_descval.set_context_value(p_attribute_category);
2484: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2485: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2486: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2487: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2488: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2489: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2490: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2483: fnd_flex_descval.set_context_value(p_attribute_category);
2484: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2485: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2486: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2487: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2488: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2489: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2490: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2491: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2484: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
2485: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2486: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2487: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2488: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2489: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2490: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2491: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2492: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2485: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
2486: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2487: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2488: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2489: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2490: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2491: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2492: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2493: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2486: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
2487: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2488: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2489: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2490: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2491: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2492: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2493: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2494: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2487: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
2488: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2489: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2490: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2491: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2492: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2493: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2494: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2495: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2488: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
2489: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2490: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2491: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2492: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2493: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2494: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2495: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2496: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13);
2489: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
2490: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2491: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2492: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2493: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2494: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2495: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2496: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13);
2497: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14);
2490: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
2491: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2492: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2493: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2494: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2495: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2496: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13);
2497: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14);
2498: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15);
2491: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
2492: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2493: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2494: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2495: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2496: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13);
2497: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14);
2498: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15);
2499:
2492: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
2493: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2494: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2495: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2496: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13);
2497: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14);
2498: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15);
2499:
2500: -- VALIDATE
2493: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
2494: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2495: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2496: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13);
2497: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14);
2498: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15);
2499:
2500: -- VALIDATE
2501: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name)) then
2494: fnd_flex_descval.set_column_value('ATTRIBUTE11', p_attribute11);
2495: fnd_flex_descval.set_column_value('ATTRIBUTE12', p_attribute12);
2496: fnd_flex_descval.set_column_value('ATTRIBUTE13', p_attribute13);
2497: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14);
2498: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15);
2499:
2500: -- VALIDATE
2501: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name)) then
2502: p_RETURN_msg := 'VALID: ' || fnd_flex_descval.concatenated_ids;
2497: fnd_flex_descval.set_column_value('ATTRIBUTE14', p_attribute14);
2498: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15);
2499:
2500: -- VALIDATE
2501: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name)) then
2502: p_RETURN_msg := 'VALID: ' || fnd_flex_descval.concatenated_ids;
2503: p_validate_status := 'Y';
2504: ELSE
2505: p_RETURN_msg := 'INVALID: ' || fnd_flex_descval.error_message;
2498: fnd_flex_descval.set_column_value('ATTRIBUTE15', p_attribute15);
2499:
2500: -- VALIDATE
2501: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name)) then
2502: p_RETURN_msg := 'VALID: ' || fnd_flex_descval.concatenated_ids;
2503: p_validate_status := 'Y';
2504: ELSE
2505: p_RETURN_msg := 'INVALID: ' || fnd_flex_descval.error_message;
2506: p_validate_status := 'N';
2501: IF (fnd_flex_descval.validate_desccols( 'PA',p_desc_flex_name)) then
2502: p_RETURN_msg := 'VALID: ' || fnd_flex_descval.concatenated_ids;
2503: p_validate_status := 'Y';
2504: ELSE
2505: p_RETURN_msg := 'INVALID: ' || fnd_flex_descval.error_message;
2506: p_validate_status := 'N';
2507: END IF;
2508: EXCEPTION -- 4537865
2509: WHEN OTHERS THEN