APPS.INV_LOC_WMS_PUB dependencies on FND_FLEX_DESCVAL

Line 141: fnd_flex_descval.set_column_value(

137:
138: IF p_attributes_tbl.EXISTS(SUBSTR(l_segments_dr.application_column_name(i)
139: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9)) THEN
140: --DBMS_output.put_line('setting column values');
141: fnd_flex_descval.set_column_value(
142: l_segments_dr.application_column_name(i)
143: , p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
144: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
145: );

Line 147: fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i), l_null_char_val);

143: , p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
144: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
145: );
146: ELSE
147: fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i), l_null_char_val);
148: END IF;
149:
150: v_index := v_index + 1;
151: END LOOP;

Line 169: fnd_flex_descval.set_context_value(l_context);

165: /*Get the context for the item passed */
166: IF p_attribute_category IS NOT NULL THEN
167: l_context := p_attribute_category;
168: /* Set flex context for validation of the value set */
169: fnd_flex_descval.set_context_value(l_context);
170:
171:
172: --DBMS_output.put_line('The value of INV context is ' || l_context);
173:

Line 211: fnd_flex_descval.set_column_value(

207: END IF;
208:
209: IF p_attributes_tbl.EXISTS(SUBSTR(l_segments_dr.application_column_name(i)
210: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9)) THEN
211: fnd_flex_descval.set_column_value(
212: l_segments_dr.application_column_name(i)
213: , p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
214: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
215: );

Line 217: fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i), l_null_char_val);

213: , p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
214: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
215: );
216: ELSE
217: fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i), l_null_char_val);
218: END IF;
219:
220: v_index := v_index + 1;
221: END LOOP;

Line 224: /*Make a call to FND_FLEX_DESCVAL.validate_desccols */

220: v_index := v_index + 1;
221: END LOOP;
222:
223: END IF;
224: /*Make a call to FND_FLEX_DESCVAL.validate_desccols */
225: IF (l_global_nsegments > 0 AND p_attribute_Category IS NULL ) THEN
226: --DBMS_output.put_line('global segments > 0');
227: l_context := l_contexts_dr.context_code(l_global_context);
228: fnd_flex_descval.set_context_value(l_context);

Line 228: fnd_flex_descval.set_context_value(l_context);

224: /*Make a call to FND_FLEX_DESCVAL.validate_desccols */
225: IF (l_global_nsegments > 0 AND p_attribute_Category IS NULL ) THEN
226: --DBMS_output.put_line('global segments > 0');
227: l_context := l_contexts_dr.context_code(l_global_context);
228: fnd_flex_descval.set_context_value(l_context);
229: end if;
230: IF( l_global_nsegments > 0 OR p_attribute_category IS NOT NULL )
231: then
232: --DBMS_output.put_line('global segments > 0 or attrib cat is not null');

Line 233: IF fnd_flex_descval.validate_desccols(appl_short_name => 'INV', desc_flex_name => 'MTL_ITEM_LOCATIONS', values_or_ids => 'I'

229: end if;
230: IF( l_global_nsegments > 0 OR p_attribute_category IS NOT NULL )
231: then
232: --DBMS_output.put_line('global segments > 0 or attrib cat is not null');
233: IF fnd_flex_descval.validate_desccols(appl_short_name => 'INV', desc_flex_name => 'MTL_ITEM_LOCATIONS', values_or_ids => 'I'
234: , validation_date => SYSDATE) THEN
235:
236: --DBMS_output.put_line('Value set validation successful');
237:

Line 241: error_segment := fnd_flex_descval.error_segment;

237:
238: NULL;
239: ELSE
240:
241: error_segment := fnd_flex_descval.error_segment;
242: --DBMS_output.put_line('Value set validation failed for segment ' || error_segment);
243: RAISE errors_received;
244:
245: END IF;

Line 252: error_msg := fnd_flex_descval.error_message;

248:
249: EXCEPTION
250: WHEN errors_received THEN
251: x_return_status := fnd_api.g_ret_sts_error;
252: error_msg := fnd_flex_descval.error_message;
253: s := 1;
254: e := 200;
255:
256: --DBMS_output.put_line('Here are the error messages: ');