258: END IF;
259: CLOSE c_get_exists;
260:
261: -- Validate flexfield values
262: FND_FLEX_DESCVAL.set_context_value(p_category);
263:
264: i := 0;
265: IF p_category IS NOT NULL THEN
266: i := i +1;
281: --the block is deleted and replaced by new code
282: /*
283: IF l_count >= i THEN
284: i := i + 1;
285: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
286: END IF;
287: */
288: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
289: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
284: i := i + 1;
285: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
286: END IF;
287: */
288: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
289: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
290: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
291: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
292: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
285: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
286: END IF;
287: */
288: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
289: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
290: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
291: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
292: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
293: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
286: END IF;
287: */
288: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
289: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
290: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
291: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
292: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
293: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
294: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
287: */
288: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
289: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
290: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
291: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
292: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
293: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
294: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
295: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
288: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_attribute1);
289: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
290: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
291: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
292: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
293: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
294: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
295: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
296: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
289: fnd_flex_descval.set_column_value('ATTRIBUTE2', p_attribute2);
290: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
291: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
292: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
293: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
294: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
295: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
296: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
297: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
290: fnd_flex_descval.set_column_value('ATTRIBUTE3', p_attribute3);
291: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
292: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
293: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
294: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
295: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
296: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
297: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
298:
291: fnd_flex_descval.set_column_value('ATTRIBUTE4', p_attribute4);
292: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
293: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
294: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
295: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
296: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
297: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
298:
299: --Check for validity of the flexfield data
292: fnd_flex_descval.set_column_value('ATTRIBUTE5', p_attribute5);
293: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
294: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
295: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
296: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
297: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
298:
299: --Check for validity of the flexfield data
300: --For bug 3581517 this check is now moved inside the top if
293: fnd_flex_descval.set_column_value('ATTRIBUTE6', p_attribute6);
294: fnd_flex_descval.set_column_value('ATTRIBUTE7', p_attribute7);
295: fnd_flex_descval.set_column_value('ATTRIBUTE8', p_attribute8);
296: fnd_flex_descval.set_column_value('ATTRIBUTE9', p_attribute9);
297: fnd_flex_descval.set_column_value('ATTRIBUTE10', p_attribute10);
298:
299: --Check for validity of the flexfield data
300: --For bug 3581517 this check is now moved inside the top if
301: --block (l_count>0) instead of doing an unguarded check
298:
299: --Check for validity of the flexfield data
300: --For bug 3581517 this check is now moved inside the top if
301: --block (l_count>0) instead of doing an unguarded check
302: IF NOT (FND_FLEX_DESCVAL.validate_desccols('EDR',
303: 'EDR_FILE_ATTRIBUTES',
304: 'V',
305: SYSDATE))
306: THEN