8517: print_debug('Actual Value is ' ||
8518: l_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
8519: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9)), 4);
8520:
8521: fnd_flex_descval.set_column_value(
8522: l_segments_dr.application_column_name(i)
8523: , l_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
8524: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
8525: );
8523: , l_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
8524: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
8525: );
8526: ELSE
8527: fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i), l_null_char_val);
8528: END IF;
8529: v_index := v_index + 1;
8530: END LOOP;
8531:
8542: /*Get the context for the item passed */
8543: IF x_attribute_category IS NOT NULL THEN
8544: l_context := x_attribute_category;
8545: /* Set flex context for validation of the value set */
8546: fnd_flex_descval.set_context_value(l_context);
8547: print_debug('The value of INV context is ' || l_context, 4);
8548:
8549: /* Prepare the context_r type */
8550: l_context_r.flexfield := l_dflex_r;
8566:
8567: IF l_attributes_tbl.EXISTS(SUBSTR(l_segments_dr.application_column_name(i)
8568: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9)) THEN
8569:
8570: fnd_flex_descval.set_column_value(
8571: l_segments_dr.application_column_name(i)
8572: , l_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
8573: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
8574: );
8572: , l_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
8573: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
8574: );
8575: ELSE
8576: fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i), l_null_char_val);
8577: END IF;
8578: v_index := v_index + 1;
8579: END LOOP;
8580: END IF;
8581:
8582: IF (l_global_nsegments > 0 AND x_attribute_Category IS NULL ) THEN
8583: print_debug('global segments > 0', 4);
8584: l_context := l_contexts_dr.context_code(l_global_context);
8585: fnd_flex_descval.set_context_value(l_context);
8586: End if;
8587:
8588: IF fnd_flex_descval.validate_desccols(appl_short_name => 'PO',
8589: desc_flex_name => 'RCV_SHIPMENT_HEADERS', values_or_ids => 'I'
8584: l_context := l_contexts_dr.context_code(l_global_context);
8585: fnd_flex_descval.set_context_value(l_context);
8586: End if;
8587:
8588: IF fnd_flex_descval.validate_desccols(appl_short_name => 'PO',
8589: desc_flex_name => 'RCV_SHIPMENT_HEADERS', values_or_ids => 'I'
8590: , validation_date => SYSDATE) THEN
8591: print_debug('Value set validation successful', 4);
8592: ELSE
8589: desc_flex_name => 'RCV_SHIPMENT_HEADERS', values_or_ids => 'I'
8590: , validation_date => SYSDATE) THEN
8591: print_debug('Value set validation successful', 4);
8592: ELSE
8593: error_segment := fnd_flex_descval.error_segment;
8594: print_debug('The error segment is : ' || fnd_flex_descval.error_segment, 4);
8595: RAISE errors_received;
8596: END IF;
8597:
8590: , validation_date => SYSDATE) THEN
8591: print_debug('Value set validation successful', 4);
8592: ELSE
8593: error_segment := fnd_flex_descval.error_segment;
8594: print_debug('The error segment is : ' || fnd_flex_descval.error_segment, 4);
8595: RAISE errors_received;
8596: END IF;
8597:
8598: x_concatenated_val := fnd_flex_descval.concatenated_values;
8594: print_debug('The error segment is : ' || fnd_flex_descval.error_segment, 4);
8595: RAISE errors_received;
8596: END IF;
8597:
8598: x_concatenated_val := fnd_flex_descval.concatenated_values;
8599: print_debug('The concatenated values is : ' || x_concatenated_val , 4);
8600:
8601: /** Retrun the VALUES to java */
8602: /** This Part of code is kept for future Use **********
8607: l_attrib_num := SUBSTR(l_enabled_seg_name(i)
8608: , INSTR(l_enabled_seg_name(i), 'ATTRIBUTE') + 9);
8609:
8610: if l_attrib_num = 1 then
8611: x_val_attribute1 := fnd_flex_descval.Segment_Value(i);
8612: End if;
8613: if l_attrib_num = 2 then
8614: x_val_attribute2 := fnd_flex_descval.Segment_Value(i);
8615: End if;
8610: if l_attrib_num = 1 then
8611: x_val_attribute1 := fnd_flex_descval.Segment_Value(i);
8612: End if;
8613: if l_attrib_num = 2 then
8614: x_val_attribute2 := fnd_flex_descval.Segment_Value(i);
8615: End if;
8616: if l_attrib_num = 3 then
8617: x_val_attribute3 := fnd_flex_descval.Segment_Value(i);
8618: End if;
8613: if l_attrib_num = 2 then
8614: x_val_attribute2 := fnd_flex_descval.Segment_Value(i);
8615: End if;
8616: if l_attrib_num = 3 then
8617: x_val_attribute3 := fnd_flex_descval.Segment_Value(i);
8618: End if;
8619: if l_attrib_num = 4 then
8620: x_val_attribute4 := fnd_flex_descval.Segment_Value(i);
8621: End if;
8616: if l_attrib_num = 3 then
8617: x_val_attribute3 := fnd_flex_descval.Segment_Value(i);
8618: End if;
8619: if l_attrib_num = 4 then
8620: x_val_attribute4 := fnd_flex_descval.Segment_Value(i);
8621: End if;
8622: if l_attrib_num = 5 then
8623: x_val_attribute5 := fnd_flex_descval.Segment_Value(i);
8624: End if;
8619: if l_attrib_num = 4 then
8620: x_val_attribute4 := fnd_flex_descval.Segment_Value(i);
8621: End if;
8622: if l_attrib_num = 5 then
8623: x_val_attribute5 := fnd_flex_descval.Segment_Value(i);
8624: End if;
8625: if l_attrib_num =6 then
8626: x_val_attribute6 := fnd_flex_descval.Segment_Value(i);
8627: End if;
8622: if l_attrib_num = 5 then
8623: x_val_attribute5 := fnd_flex_descval.Segment_Value(i);
8624: End if;
8625: if l_attrib_num =6 then
8626: x_val_attribute6 := fnd_flex_descval.Segment_Value(i);
8627: End if;
8628: if l_attrib_num = 7 then
8629: x_val_attribute7 := fnd_flex_descval.Segment_Value(i);
8630: End if;
8625: if l_attrib_num =6 then
8626: x_val_attribute6 := fnd_flex_descval.Segment_Value(i);
8627: End if;
8628: if l_attrib_num = 7 then
8629: x_val_attribute7 := fnd_flex_descval.Segment_Value(i);
8630: End if;
8631: if l_attrib_num =8 then
8632: x_val_attribute8 := fnd_flex_descval.Segment_Value(i);
8633: End if;
8628: if l_attrib_num = 7 then
8629: x_val_attribute7 := fnd_flex_descval.Segment_Value(i);
8630: End if;
8631: if l_attrib_num =8 then
8632: x_val_attribute8 := fnd_flex_descval.Segment_Value(i);
8633: End if;
8634: if l_attrib_num = 9 then
8635: x_val_attribute9 := fnd_flex_descval.Segment_Value(i);
8636: End if;
8631: if l_attrib_num =8 then
8632: x_val_attribute8 := fnd_flex_descval.Segment_Value(i);
8633: End if;
8634: if l_attrib_num = 9 then
8635: x_val_attribute9 := fnd_flex_descval.Segment_Value(i);
8636: End if;
8637: if l_attrib_num = 10 then
8638: x_val_attribute10 := fnd_flex_descval.Segment_Value(i);
8639: End if;
8634: if l_attrib_num = 9 then
8635: x_val_attribute9 := fnd_flex_descval.Segment_Value(i);
8636: End if;
8637: if l_attrib_num = 10 then
8638: x_val_attribute10 := fnd_flex_descval.Segment_Value(i);
8639: End if;
8640: if l_attrib_num = 11 then
8641: x_val_attribute11 := fnd_flex_descval.Segment_Value(i);
8642: End if;
8637: if l_attrib_num = 10 then
8638: x_val_attribute10 := fnd_flex_descval.Segment_Value(i);
8639: End if;
8640: if l_attrib_num = 11 then
8641: x_val_attribute11 := fnd_flex_descval.Segment_Value(i);
8642: End if;
8643: if l_attrib_num = 12 then
8644: x_val_attribute12 := fnd_flex_descval.Segment_Value(i);
8645: End if;
8640: if l_attrib_num = 11 then
8641: x_val_attribute11 := fnd_flex_descval.Segment_Value(i);
8642: End if;
8643: if l_attrib_num = 12 then
8644: x_val_attribute12 := fnd_flex_descval.Segment_Value(i);
8645: End if;
8646: if l_attrib_num = 13 then
8647: x_val_attribute13 := fnd_flex_descval.Segment_Value(i);
8648: End if;
8643: if l_attrib_num = 12 then
8644: x_val_attribute12 := fnd_flex_descval.Segment_Value(i);
8645: End if;
8646: if l_attrib_num = 13 then
8647: x_val_attribute13 := fnd_flex_descval.Segment_Value(i);
8648: End if;
8649: if l_attrib_num = 14 then
8650: x_val_attribute14 := fnd_flex_descval.Segment_Value(i);
8651: End if;
8646: if l_attrib_num = 13 then
8647: x_val_attribute13 := fnd_flex_descval.Segment_Value(i);
8648: End if;
8649: if l_attrib_num = 14 then
8650: x_val_attribute14 := fnd_flex_descval.Segment_Value(i);
8651: End if;
8652: if l_attrib_num = 15 then
8653: x_val_attribute15 := fnd_flex_descval.Segment_Value(i);
8654: End if;
8649: if l_attrib_num = 14 then
8650: x_val_attribute14 := fnd_flex_descval.Segment_Value(i);
8651: End if;
8652: if l_attrib_num = 15 then
8653: x_val_attribute15 := fnd_flex_descval.Segment_Value(i);
8654: End if;
8655: EXCEPTION
8656: WHEN OTHERS THEN NULL;
8657: END;