486: -- Populate the v_attributex variables to get ready to do validation
487: populate_v_attributes();
488:
489: -- Validate the DFF
490: fnd_flex_descval.set_context_value(v_desc_flex_context_name);
491: fnd_flex_descval.set_column_value('ATTRIBUTE1', v_attribute1);
492: fnd_flex_descval.set_column_value('ATTRIBUTE2', v_attribute2);
493: fnd_flex_descval.set_column_value('ATTRIBUTE3', v_attribute3);
494: fnd_flex_descval.set_column_value('ATTRIBUTE4', v_attribute4);
487: populate_v_attributes();
488:
489: -- Validate the DFF
490: fnd_flex_descval.set_context_value(v_desc_flex_context_name);
491: fnd_flex_descval.set_column_value('ATTRIBUTE1', v_attribute1);
492: fnd_flex_descval.set_column_value('ATTRIBUTE2', v_attribute2);
493: fnd_flex_descval.set_column_value('ATTRIBUTE3', v_attribute3);
494: fnd_flex_descval.set_column_value('ATTRIBUTE4', v_attribute4);
495: fnd_flex_descval.set_column_value('ATTRIBUTE5', v_attribute5);
488:
489: -- Validate the DFF
490: fnd_flex_descval.set_context_value(v_desc_flex_context_name);
491: fnd_flex_descval.set_column_value('ATTRIBUTE1', v_attribute1);
492: fnd_flex_descval.set_column_value('ATTRIBUTE2', v_attribute2);
493: fnd_flex_descval.set_column_value('ATTRIBUTE3', v_attribute3);
494: fnd_flex_descval.set_column_value('ATTRIBUTE4', v_attribute4);
495: fnd_flex_descval.set_column_value('ATTRIBUTE5', v_attribute5);
496: fnd_flex_descval.set_column_value('ATTRIBUTE6', v_attribute6);
489: -- Validate the DFF
490: fnd_flex_descval.set_context_value(v_desc_flex_context_name);
491: fnd_flex_descval.set_column_value('ATTRIBUTE1', v_attribute1);
492: fnd_flex_descval.set_column_value('ATTRIBUTE2', v_attribute2);
493: fnd_flex_descval.set_column_value('ATTRIBUTE3', v_attribute3);
494: fnd_flex_descval.set_column_value('ATTRIBUTE4', v_attribute4);
495: fnd_flex_descval.set_column_value('ATTRIBUTE5', v_attribute5);
496: fnd_flex_descval.set_column_value('ATTRIBUTE6', v_attribute6);
497: fnd_flex_descval.set_column_value('ATTRIBUTE7', v_attribute7);
490: fnd_flex_descval.set_context_value(v_desc_flex_context_name);
491: fnd_flex_descval.set_column_value('ATTRIBUTE1', v_attribute1);
492: fnd_flex_descval.set_column_value('ATTRIBUTE2', v_attribute2);
493: fnd_flex_descval.set_column_value('ATTRIBUTE3', v_attribute3);
494: fnd_flex_descval.set_column_value('ATTRIBUTE4', v_attribute4);
495: fnd_flex_descval.set_column_value('ATTRIBUTE5', v_attribute5);
496: fnd_flex_descval.set_column_value('ATTRIBUTE6', v_attribute6);
497: fnd_flex_descval.set_column_value('ATTRIBUTE7', v_attribute7);
498: fnd_flex_descval.set_column_value('ATTRIBUTE8', v_attribute8);
491: fnd_flex_descval.set_column_value('ATTRIBUTE1', v_attribute1);
492: fnd_flex_descval.set_column_value('ATTRIBUTE2', v_attribute2);
493: fnd_flex_descval.set_column_value('ATTRIBUTE3', v_attribute3);
494: fnd_flex_descval.set_column_value('ATTRIBUTE4', v_attribute4);
495: fnd_flex_descval.set_column_value('ATTRIBUTE5', v_attribute5);
496: fnd_flex_descval.set_column_value('ATTRIBUTE6', v_attribute6);
497: fnd_flex_descval.set_column_value('ATTRIBUTE7', v_attribute7);
498: fnd_flex_descval.set_column_value('ATTRIBUTE8', v_attribute8);
499: fnd_flex_descval.set_column_value('ATTRIBUTE9', v_attribute9);
492: fnd_flex_descval.set_column_value('ATTRIBUTE2', v_attribute2);
493: fnd_flex_descval.set_column_value('ATTRIBUTE3', v_attribute3);
494: fnd_flex_descval.set_column_value('ATTRIBUTE4', v_attribute4);
495: fnd_flex_descval.set_column_value('ATTRIBUTE5', v_attribute5);
496: fnd_flex_descval.set_column_value('ATTRIBUTE6', v_attribute6);
497: fnd_flex_descval.set_column_value('ATTRIBUTE7', v_attribute7);
498: fnd_flex_descval.set_column_value('ATTRIBUTE8', v_attribute8);
499: fnd_flex_descval.set_column_value('ATTRIBUTE9', v_attribute9);
500: fnd_flex_descval.set_column_value('ATTRIBUTE10', v_attribute10);
493: fnd_flex_descval.set_column_value('ATTRIBUTE3', v_attribute3);
494: fnd_flex_descval.set_column_value('ATTRIBUTE4', v_attribute4);
495: fnd_flex_descval.set_column_value('ATTRIBUTE5', v_attribute5);
496: fnd_flex_descval.set_column_value('ATTRIBUTE6', v_attribute6);
497: fnd_flex_descval.set_column_value('ATTRIBUTE7', v_attribute7);
498: fnd_flex_descval.set_column_value('ATTRIBUTE8', v_attribute8);
499: fnd_flex_descval.set_column_value('ATTRIBUTE9', v_attribute9);
500: fnd_flex_descval.set_column_value('ATTRIBUTE10', v_attribute10);
501:
494: fnd_flex_descval.set_column_value('ATTRIBUTE4', v_attribute4);
495: fnd_flex_descval.set_column_value('ATTRIBUTE5', v_attribute5);
496: fnd_flex_descval.set_column_value('ATTRIBUTE6', v_attribute6);
497: fnd_flex_descval.set_column_value('ATTRIBUTE7', v_attribute7);
498: fnd_flex_descval.set_column_value('ATTRIBUTE8', v_attribute8);
499: fnd_flex_descval.set_column_value('ATTRIBUTE9', v_attribute9);
500: fnd_flex_descval.set_column_value('ATTRIBUTE10', v_attribute10);
501:
502: /* Start of Bug 3064318 */
495: fnd_flex_descval.set_column_value('ATTRIBUTE5', v_attribute5);
496: fnd_flex_descval.set_column_value('ATTRIBUTE6', v_attribute6);
497: fnd_flex_descval.set_column_value('ATTRIBUTE7', v_attribute7);
498: fnd_flex_descval.set_column_value('ATTRIBUTE8', v_attribute8);
499: fnd_flex_descval.set_column_value('ATTRIBUTE9', v_attribute9);
500: fnd_flex_descval.set_column_value('ATTRIBUTE10', v_attribute10);
501:
502: /* Start of Bug 3064318 */
503: IF (FND_FLEX_DESCVAL.validate_desccols('PA', 'PA_EXPENDITURE_ITEMS_DESC_FLEX', 'D', sysdate)) THEN
496: fnd_flex_descval.set_column_value('ATTRIBUTE6', v_attribute6);
497: fnd_flex_descval.set_column_value('ATTRIBUTE7', v_attribute7);
498: fnd_flex_descval.set_column_value('ATTRIBUTE8', v_attribute8);
499: fnd_flex_descval.set_column_value('ATTRIBUTE9', v_attribute9);
500: fnd_flex_descval.set_column_value('ATTRIBUTE10', v_attribute10);
501:
502: /* Start of Bug 3064318 */
503: IF (FND_FLEX_DESCVAL.validate_desccols('PA', 'PA_EXPENDITURE_ITEMS_DESC_FLEX', 'D', sysdate)) THEN
504:
499: fnd_flex_descval.set_column_value('ATTRIBUTE9', v_attribute9);
500: fnd_flex_descval.set_column_value('ATTRIBUTE10', v_attribute10);
501:
502: /* Start of Bug 3064318 */
503: IF (FND_FLEX_DESCVAL.validate_desccols('PA', 'PA_EXPENDITURE_ITEMS_DESC_FLEX', 'D', sysdate)) THEN
504:
505: for j in 1 ..10 Loop
506: p_segment_column_name(j) := ltrim(rtrim(FND_FLEX_DESCVAL.segment_column_name(j)));
507: l_attribute(j) := rtrim(FND_FLEX_DESCVAL.segment_id(j)); --Bug#6506638: Removed ltrim()
502: /* Start of Bug 3064318 */
503: IF (FND_FLEX_DESCVAL.validate_desccols('PA', 'PA_EXPENDITURE_ITEMS_DESC_FLEX', 'D', sysdate)) THEN
504:
505: for j in 1 ..10 Loop
506: p_segment_column_name(j) := ltrim(rtrim(FND_FLEX_DESCVAL.segment_column_name(j)));
507: l_attribute(j) := rtrim(FND_FLEX_DESCVAL.segment_id(j)); --Bug#6506638: Removed ltrim()
508:
509: If p_segment_column_name(j) = 'ATTRIBUTE1' Then
510: p_attribute1 := l_attribute(j);
503: IF (FND_FLEX_DESCVAL.validate_desccols('PA', 'PA_EXPENDITURE_ITEMS_DESC_FLEX', 'D', sysdate)) THEN
504:
505: for j in 1 ..10 Loop
506: p_segment_column_name(j) := ltrim(rtrim(FND_FLEX_DESCVAL.segment_column_name(j)));
507: l_attribute(j) := rtrim(FND_FLEX_DESCVAL.segment_id(j)); --Bug#6506638: Removed ltrim()
508:
509: If p_segment_column_name(j) = 'ATTRIBUTE1' Then
510: p_attribute1 := l_attribute(j);
511: ElsIf p_segment_column_name(j) = 'ATTRIBUTE2' Then
540: p_attribute9 := v_attribute9;
541: p_attribute10 := v_attribute10; Commented for Bug 3064318 */
542: /* End of Bug 3064318 */
543: ELSE
544: X_error_message := FND_FLEX_DESCVAL.error_message;
545: X_status_code := 'PA_DFF_VALIDATION_FAILED';
546: RAISE INVALID_DATA;
547: END IF;
548: