APPS.INV_LOC_WMS_PUB dependencies on FND_FLEX_DESCVAL

Line 193: fnd_flex_descval.set_column_value(

189:
190: IF p_attributes_tbl.EXISTS(SUBSTR(l_segments_dr.application_column_name(i)
191: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9)) THEN
192: --DBMS_output.put_line('setting column values');
193: fnd_flex_descval.set_column_value(
194: l_segments_dr.application_column_name(i)
195: , p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
196: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
197: );

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

195: , p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
196: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
197: );
198: ELSE
199: fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i), l_null_char_val);
200: END IF;
201:
202: v_index := v_index + 1;
203: END LOOP;

Line 221: fnd_flex_descval.set_context_value(l_context);

217: /*Get the context for the item passed */
218: IF p_attribute_category IS NOT NULL THEN
219: l_context := p_attribute_category;
220: /* Set flex context for validation of the value set */
221: fnd_flex_descval.set_context_value(l_context);
222:
223:
224: --DBMS_output.put_line('The value of INV context is ' || l_context);
225:

Line 263: fnd_flex_descval.set_column_value(

259: END IF;
260:
261: IF p_attributes_tbl.EXISTS(SUBSTR(l_segments_dr.application_column_name(i)
262: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9)) THEN
263: fnd_flex_descval.set_column_value(
264: l_segments_dr.application_column_name(i)
265: , p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
266: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
267: );

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

265: , p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
266: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
267: );
268: ELSE
269: fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i), l_null_char_val);
270: END IF;
271:
272: v_index := v_index + 1;
273: END LOOP;

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

272: v_index := v_index + 1;
273: END LOOP;
274:
275: END IF;
276: /*Make a call to FND_FLEX_DESCVAL.validate_desccols */
277: IF (l_global_nsegments > 0 AND p_attribute_Category IS NULL ) THEN
278: --DBMS_output.put_line('global segments > 0');
279: l_context := l_contexts_dr.context_code(l_global_context);
280: fnd_flex_descval.set_context_value(l_context);

Line 280: fnd_flex_descval.set_context_value(l_context);

276: /*Make a call to FND_FLEX_DESCVAL.validate_desccols */
277: IF (l_global_nsegments > 0 AND p_attribute_Category IS NULL ) THEN
278: --DBMS_output.put_line('global segments > 0');
279: l_context := l_contexts_dr.context_code(l_global_context);
280: fnd_flex_descval.set_context_value(l_context);
281: end if;
282: IF( l_global_nsegments > 0 OR p_attribute_category IS NOT NULL )
283: then
284: --DBMS_output.put_line('global segments > 0 or attrib cat is not null');

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

281: end if;
282: IF( l_global_nsegments > 0 OR p_attribute_category IS NOT NULL )
283: then
284: --DBMS_output.put_line('global segments > 0 or attrib cat is not null');
285: IF fnd_flex_descval.validate_desccols(appl_short_name => 'INV', desc_flex_name => 'MTL_ITEM_LOCATIONS', values_or_ids => 'I'
286: , validation_date => SYSDATE) THEN
287:
288: --DBMS_output.put_line('Value set validation successful');
289:

Line 293: error_segment := fnd_flex_descval.error_segment;

289:
290: NULL;
291: ELSE
292:
293: error_segment := fnd_flex_descval.error_segment;
294: --DBMS_output.put_line('Value set validation failed for segment ' || error_segment);
295: RAISE errors_received;
296:
297: END IF;

Line 304: error_msg := fnd_flex_descval.error_message;

300:
301: EXCEPTION
302: WHEN errors_received THEN
303: x_return_status := fnd_api.g_ret_sts_error;
304: error_msg := fnd_flex_descval.error_message;
305: s := 1;
306: e := 200;
307:
308: --DBMS_output.put_line('Here are the error messages: ');