APPS.INV_SERIAL_NUMBER_ATTR dependencies on FND_FLEX_DESCVAL

Line 199: fnd_flex_descval.set_column_value(

195: END IF;
196:
197: IF p_attributes_tbl.EXISTS(SUBSTR(l_segments_dr.application_column_name(i)
198: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9)) THEN
199: fnd_flex_descval.set_column_value(
200: l_segments_dr.application_column_name(i)
201: , p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
202: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
203: );

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

201: , p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
202: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
203: );
204: ELSE
205: fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i), l_null_char_val);
206: END IF;
207:
208: --fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i),p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i),INSTR(l_segments_dr.application_column_name(i),'ATTRIBUTE')+9)));
209: v_index := v_index + 1;

Line 208: --fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i),p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i),INSTR(l_segments_dr.application_column_name(i),'ATTRIBUTE')+9)));

204: ELSE
205: fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i), l_null_char_val);
206: END IF;
207:
208: --fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i),p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i),INSTR(l_segments_dr.application_column_name(i),'ATTRIBUTE')+9)));
209: v_index := v_index + 1;
210: END LOOP;
211:
212: IF l_enabled_seg_name.COUNT > 0 THEN

Line 228: fnd_flex_descval.set_context_value(l_context);

224: /*Get the context for the item passed */
225: IF l_default_attr_category IS NOT NULL THEN
226: l_context := l_default_attr_category;
227: /* Set flex context for validation of the value set */
228: fnd_flex_descval.set_context_value(l_context);
229:
230: IF g_debug = 1 THEN
231: print_debug('The value of INV context is ' || l_context);
232: END IF;

Line 268: fnd_flex_descval.set_column_value(

264: END IF;
265:
266: IF p_attributes_tbl.EXISTS(SUBSTR(l_segments_dr.application_column_name(i)
267: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9)) THEN
268: fnd_flex_descval.set_column_value(
269: l_segments_dr.application_column_name(i)
270: , p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
271: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
272: );

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

270: , p_attributes_tbl(SUBSTR(l_segments_dr.application_column_name(i)
271: , INSTR(l_segments_dr.application_column_name(i), 'ATTRIBUTE') + 9))
272: );
273: ELSE
274: fnd_flex_descval.set_column_value(l_segments_dr.application_column_name(i), l_null_char_val);
275: END IF;
276:
277: v_index := v_index + 1;
278: END LOOP;

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

306: v_index1 := p_attributes_tbl.NEXT(v_index1);
307: l_chk_flag := 0;
308: END LOOP;*/
309:
310: /*Make a call to FND_FLEX_DESCVAL.validate_desccols */
311: IF fnd_flex_descval.validate_desccols(appl_short_name => 'INV', desc_flex_name => 'MTL_SERIAL_NUMBERS', values_or_ids => 'I', validation_date => SYSDATE) THEN
312: IF g_debug = 1 THEN
313: print_debug('Value set validation successful');
314: END IF;

Line 311: IF fnd_flex_descval.validate_desccols(appl_short_name => 'INV', desc_flex_name => 'MTL_SERIAL_NUMBERS', values_or_ids => 'I', validation_date => SYSDATE) THEN

307: l_chk_flag := 0;
308: END LOOP;*/
309:
310: /*Make a call to FND_FLEX_DESCVAL.validate_desccols */
311: IF fnd_flex_descval.validate_desccols(appl_short_name => 'INV', desc_flex_name => 'MTL_SERIAL_NUMBERS', values_or_ids => 'I', validation_date => SYSDATE) THEN
312: IF g_debug = 1 THEN
313: print_debug('Value set validation successful');
314: END IF;
315: ELSE

Line 317: error_segment := fnd_flex_descval.error_segment;

313: print_debug('Value set validation successful');
314: END IF;
315: ELSE
316: IF g_debug = 1 THEN
317: error_segment := fnd_flex_descval.error_segment;
318: print_debug('Value set validation failed for segment ' || error_segment);
319: RAISE errors_received;
320: END IF;
321: END IF;

Line 398: error_msg := fnd_flex_descval.error_message;

394: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
395:
396: WHEN errors_received THEN
397: x_return_status := FND_API.G_RET_STS_ERROR;
398: error_msg := fnd_flex_descval.error_message;
399: s := 1;
400: e := 200;
401:
402: print_debug('Here are the error messages: ');