DBA Data[Home] [Help]

APPS.WSH_FLEXFIELD_UTILS dependencies on FND_FLEX_DESCVAL

Line 256: FND_FLEX_DESCVAL.set_context_value(l_flexinfo.default_context_value);

252: END LOOP;
253:
254: -- Added for bug 2353335
255: --BugFix 4995455 replaced global context with default
256: FND_FLEX_DESCVAL.set_context_value(l_flexinfo.default_context_value);
257:
258: FOR i IN 1..l_glbl_segments.nsegments LOOP
259: fnd_flex_descval.set_column_value(l_glbl_segments.application_column_name(i),'');
260: END LOOP;

Line 259: fnd_flex_descval.set_column_value(l_glbl_segments.application_column_name(i),'');

255: --BugFix 4995455 replaced global context with default
256: FND_FLEX_DESCVAL.set_context_value(l_flexinfo.default_context_value);
257:
258: FOR i IN 1..l_glbl_segments.nsegments LOOP
259: fnd_flex_descval.set_column_value(l_glbl_segments.application_column_name(i),'');
260: END LOOP;
261:
262: --BugFix 4995455 added for loop to populate the default segement
263: FOR i IN 1..l_segments.nsegments LOOP

Line 264: fnd_flex_descval.set_column_value(l_segments.application_column_name(i),'');

260: END LOOP;
261:
262: --BugFix 4995455 added for loop to populate the default segement
263: FOR i IN 1..l_segments.nsegments LOOP
264: fnd_flex_descval.set_column_value(l_segments.application_column_name(i),'');
265: END LOOP;
266:
267: -- Bug# 5603974: Considering Automotive TP DFF attributes also.
268: --Before call to validate');

Line 269: IF FND_FLEX_DESCVAL.validate_desccols( 'WSH', l_table_name, 'D', SYSDATE) then

265: END LOOP;
266:
267: -- Bug# 5603974: Considering Automotive TP DFF attributes also.
268: --Before call to validate');
269: IF FND_FLEX_DESCVAL.validate_desccols( 'WSH', l_table_name, 'D', SYSDATE) then
270: --{
271: n := fnd_flex_descval.segment_count;
272: FOR i in 1..n LOOP
273: --{

Line 271: n := fnd_flex_descval.segment_count;

267: -- Bug# 5603974: Considering Automotive TP DFF attributes also.
268: --Before call to validate');
269: IF FND_FLEX_DESCVAL.validate_desccols( 'WSH', l_table_name, 'D', SYSDATE) then
270: --{
271: n := fnd_flex_descval.segment_count;
272: FOR i in 1..n LOOP
273: --{
274: IF l_debug_on THEN
275: WSH_DEBUG_SV.log(l_module_name,'fnd_flex_descval.segment_column_name(i))',fnd_flex_descval.segment_column_name(i));

Line 275: WSH_DEBUG_SV.log(l_module_name,'fnd_flex_descval.segment_column_name(i))',fnd_flex_descval.segment_column_name(i));

271: n := fnd_flex_descval.segment_count;
272: FOR i in 1..n LOOP
273: --{
274: IF l_debug_on THEN
275: WSH_DEBUG_SV.log(l_module_name,'fnd_flex_descval.segment_column_name(i))',fnd_flex_descval.segment_column_name(i));
276: END if;
277: IF( upper(substr(fnd_flex_descval.segment_column_name(i), 1, 2)) = 'TP' ) THEN
278: --{
279: IF( upper(substr(fnd_flex_descval.segment_column_name(i), 1, 12))

Line 277: IF( upper(substr(fnd_flex_descval.segment_column_name(i), 1, 2)) = 'TP' ) THEN

273: --{
274: IF l_debug_on THEN
275: WSH_DEBUG_SV.log(l_module_name,'fnd_flex_descval.segment_column_name(i))',fnd_flex_descval.segment_column_name(i));
276: END if;
277: IF( upper(substr(fnd_flex_descval.segment_column_name(i), 1, 2)) = 'TP' ) THEN
278: --{
279: IF( upper(substr(fnd_flex_descval.segment_column_name(i), 1, 12))
280: = 'TP_ATTRIBUTE' AND upper(fnd_flex_descval.segment_column_name(i))
281: <> 'TP_ATTRIBUTE_CATEGORY') Then

Line 279: IF( upper(substr(fnd_flex_descval.segment_column_name(i), 1, 12))

275: WSH_DEBUG_SV.log(l_module_name,'fnd_flex_descval.segment_column_name(i))',fnd_flex_descval.segment_column_name(i));
276: END if;
277: IF( upper(substr(fnd_flex_descval.segment_column_name(i), 1, 2)) = 'TP' ) THEN
278: --{
279: IF( upper(substr(fnd_flex_descval.segment_column_name(i), 1, 12))
280: = 'TP_ATTRIBUTE' AND upper(fnd_flex_descval.segment_column_name(i))
281: <> 'TP_ATTRIBUTE_CATEGORY') Then
282: k := k + 1;
283: g_def_attribute_values(g_def_attributes(j).first_segment + k - 1).attribute_index := (to_number(substr(fnd_flex_descval.segment_column_name(i),13)));

Line 280: = 'TP_ATTRIBUTE' AND upper(fnd_flex_descval.segment_column_name(i))

276: END if;
277: IF( upper(substr(fnd_flex_descval.segment_column_name(i), 1, 2)) = 'TP' ) THEN
278: --{
279: IF( upper(substr(fnd_flex_descval.segment_column_name(i), 1, 12))
280: = 'TP_ATTRIBUTE' AND upper(fnd_flex_descval.segment_column_name(i))
281: <> 'TP_ATTRIBUTE_CATEGORY') Then
282: k := k + 1;
283: g_def_attribute_values(g_def_attributes(j).first_segment + k - 1).attribute_index := (to_number(substr(fnd_flex_descval.segment_column_name(i),13)));
284: -- bug 5948562, segment value - used for display, segment id - should be stored in db to prevent any format issues.

Line 283: g_def_attribute_values(g_def_attributes(j).first_segment + k - 1).attribute_index := (to_number(substr(fnd_flex_descval.segment_column_name(i),13)));

279: IF( upper(substr(fnd_flex_descval.segment_column_name(i), 1, 12))
280: = 'TP_ATTRIBUTE' AND upper(fnd_flex_descval.segment_column_name(i))
281: <> 'TP_ATTRIBUTE_CATEGORY') Then
282: k := k + 1;
283: g_def_attribute_values(g_def_attributes(j).first_segment + k - 1).attribute_index := (to_number(substr(fnd_flex_descval.segment_column_name(i),13)));
284: -- bug 5948562, segment value - used for display, segment id - should be stored in db to prevent any format issues.
285: g_def_attribute_values(g_def_attributes(j).first_segment + k - 1).segment_value := fnd_flex_descval.segment_id(i);
286: END IF;
287:

Line 285: g_def_attribute_values(g_def_attributes(j).first_segment + k - 1).segment_value := fnd_flex_descval.segment_id(i);

281: <> 'TP_ATTRIBUTE_CATEGORY') Then
282: k := k + 1;
283: g_def_attribute_values(g_def_attributes(j).first_segment + k - 1).attribute_index := (to_number(substr(fnd_flex_descval.segment_column_name(i),13)));
284: -- bug 5948562, segment value - used for display, segment id - should be stored in db to prevent any format issues.
285: g_def_attribute_values(g_def_attributes(j).first_segment + k - 1).segment_value := fnd_flex_descval.segment_id(i);
286: END IF;
287:
288: ELSE
289: IF( upper(substr(fnd_flex_descval.segment_column_name(i), 1, 9))

Line 289: IF( upper(substr(fnd_flex_descval.segment_column_name(i), 1, 9))

285: g_def_attribute_values(g_def_attributes(j).first_segment + k - 1).segment_value := fnd_flex_descval.segment_id(i);
286: END IF;
287:
288: ELSE
289: IF( upper(substr(fnd_flex_descval.segment_column_name(i), 1, 9))
290: = 'ATTRIBUTE' AND upper(fnd_flex_descval.segment_column_name(i))
291: <> 'ATTRIBUTE_CATEGORY') Then
292:
293: k := k + 1;

Line 290: = 'ATTRIBUTE' AND upper(fnd_flex_descval.segment_column_name(i))

286: END IF;
287:
288: ELSE
289: IF( upper(substr(fnd_flex_descval.segment_column_name(i), 1, 9))
290: = 'ATTRIBUTE' AND upper(fnd_flex_descval.segment_column_name(i))
291: <> 'ATTRIBUTE_CATEGORY') Then
292:
293: k := k + 1;
294: g_def_attribute_values(g_def_attributes(j).first_segment + k - 1).attribute_index := (to_number(substr(fnd_flex_descval.segment_column_name(i),10)));

Line 294: g_def_attribute_values(g_def_attributes(j).first_segment + k - 1).attribute_index := (to_number(substr(fnd_flex_descval.segment_column_name(i),10)));

290: = 'ATTRIBUTE' AND upper(fnd_flex_descval.segment_column_name(i))
291: <> 'ATTRIBUTE_CATEGORY') Then
292:
293: k := k + 1;
294: g_def_attribute_values(g_def_attributes(j).first_segment + k - 1).attribute_index := (to_number(substr(fnd_flex_descval.segment_column_name(i),10)));
295: IF l_debug_on THEN
296: WSH_DEBUG_SV.log(l_module_name,'The segments value is',fnd_flex_descval.segment_value(i));
297: WSH_DEBUG_SV.log(l_module_name,'The segment id is',fnd_flex_descval.segment_id(i));
298: END IF;

Line 296: WSH_DEBUG_SV.log(l_module_name,'The segments value is',fnd_flex_descval.segment_value(i));

292:
293: k := k + 1;
294: g_def_attribute_values(g_def_attributes(j).first_segment + k - 1).attribute_index := (to_number(substr(fnd_flex_descval.segment_column_name(i),10)));
295: IF l_debug_on THEN
296: WSH_DEBUG_SV.log(l_module_name,'The segments value is',fnd_flex_descval.segment_value(i));
297: WSH_DEBUG_SV.log(l_module_name,'The segment id is',fnd_flex_descval.segment_id(i));
298: END IF;
299: -- bug 5948562, segment value - used for display, segment id - should be stored in db to prevent any format issues.
300: g_def_attribute_values(g_def_attributes(j).first_segment + k - 1).segment_value := fnd_flex_descval.segment_id(i);

Line 297: WSH_DEBUG_SV.log(l_module_name,'The segment id is',fnd_flex_descval.segment_id(i));

293: k := k + 1;
294: g_def_attribute_values(g_def_attributes(j).first_segment + k - 1).attribute_index := (to_number(substr(fnd_flex_descval.segment_column_name(i),10)));
295: IF l_debug_on THEN
296: WSH_DEBUG_SV.log(l_module_name,'The segments value is',fnd_flex_descval.segment_value(i));
297: WSH_DEBUG_SV.log(l_module_name,'The segment id is',fnd_flex_descval.segment_id(i));
298: END IF;
299: -- bug 5948562, segment value - used for display, segment id - should be stored in db to prevent any format issues.
300: g_def_attribute_values(g_def_attributes(j).first_segment + k - 1).segment_value := fnd_flex_descval.segment_id(i);
301: END IF;

Line 300: g_def_attribute_values(g_def_attributes(j).first_segment + k - 1).segment_value := fnd_flex_descval.segment_id(i);

296: WSH_DEBUG_SV.log(l_module_name,'The segments value is',fnd_flex_descval.segment_value(i));
297: WSH_DEBUG_SV.log(l_module_name,'The segment id is',fnd_flex_descval.segment_id(i));
298: END IF;
299: -- bug 5948562, segment value - used for display, segment id - should be stored in db to prevent any format issues.
300: g_def_attribute_values(g_def_attributes(j).first_segment + k - 1).segment_value := fnd_flex_descval.segment_id(i);
301: END IF;
302: --}TP check
303: END IF;
304: --}

Line 308: WSH_DEBUG_SV.log(l_module_name,'ERROR_SEGMENT',fnd_flex_descval.error_segment);

304: --}
305: END LOOP;
306: ELSE
307: IF l_debug_on THEN
308: WSH_DEBUG_SV.log(l_module_name,'ERROR_SEGMENT',fnd_flex_descval.error_segment);
309: WSH_DEBUG_SV.log(l_module_name,'ERROR_MESSAGE',fnd_flex_descval.error_message);
310: END IF;
311: --} validate_desccols
312: END IF;

Line 309: WSH_DEBUG_SV.log(l_module_name,'ERROR_MESSAGE',fnd_flex_descval.error_message);

305: END LOOP;
306: ELSE
307: IF l_debug_on THEN
308: WSH_DEBUG_SV.log(l_module_name,'ERROR_SEGMENT',fnd_flex_descval.error_segment);
309: WSH_DEBUG_SV.log(l_module_name,'ERROR_MESSAGE',fnd_flex_descval.error_message);
310: END IF;
311: --} validate_desccols
312: END IF;
313: -- End of fix for bug 2353335