DBA Data[Home] [Help]

APPS.WSH_UTIL_VALIDATE dependencies on FND_FLEX_KEY_API

Line 1673: ffield FND_FLEX_KEY_API.FLEXFIELD_TYPE;

1669:
1670: delimiter_null exception;
1671: wrong_combination exception;
1672:
1673: ffield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
1674: fstruct FND_FLEX_KEY_API.STRUCTURE_TYPE;
1675: slist FND_FLEX_KEY_API.SEGMENT_LIST;
1676: fsegment FND_FLEX_KEY_API.SEGMENT_TYPE;
1677:

Line 1674: fstruct FND_FLEX_KEY_API.STRUCTURE_TYPE;

1670: delimiter_null exception;
1671: wrong_combination exception;
1672:
1673: ffield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
1674: fstruct FND_FLEX_KEY_API.STRUCTURE_TYPE;
1675: slist FND_FLEX_KEY_API.SEGMENT_LIST;
1676: fsegment FND_FLEX_KEY_API.SEGMENT_TYPE;
1677:
1678: nsegs NUMBER;

Line 1675: slist FND_FLEX_KEY_API.SEGMENT_LIST;

1671: wrong_combination exception;
1672:
1673: ffield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
1674: fstruct FND_FLEX_KEY_API.STRUCTURE_TYPE;
1675: slist FND_FLEX_KEY_API.SEGMENT_LIST;
1676: fsegment FND_FLEX_KEY_API.SEGMENT_TYPE;
1677:
1678: nsegs NUMBER;
1679: charcol VARCHAR2(70);

Line 1676: fsegment FND_FLEX_KEY_API.SEGMENT_TYPE;

1672:
1673: ffield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
1674: fstruct FND_FLEX_KEY_API.STRUCTURE_TYPE;
1675: slist FND_FLEX_KEY_API.SEGMENT_LIST;
1676: fsegment FND_FLEX_KEY_API.SEGMENT_TYPE;
1677:
1678: nsegs NUMBER;
1679: charcol VARCHAR2(70);
1680: numbcol NUMBER;

Line 1730: fnd_flex_key_api.set_session_mode(session_mode =>'seed_data');

1726: If l_debug_on THEN
1727: wsh_debug_sv.logmsg(l_module_name, 'Calling set session mode');
1728: END IF;
1729:
1730: fnd_flex_key_api.set_session_mode(session_mode =>'seed_data');
1731:
1732: If l_debug_on THEN
1733: wsh_debug_sv.logmsg(l_module_name, 'Calling find flexfield');
1734: END IF;

Line 1737: ffield := fnd_flex_key_api.find_flexfield(p_app_short_name, p_key_flx_code);

1733: wsh_debug_sv.logmsg(l_module_name, 'Calling find flexfield');
1734: END IF;
1735:
1736:
1737: ffield := fnd_flex_key_api.find_flexfield(p_app_short_name, p_key_flx_code);
1738: fstruct := fnd_flex_key_api.find_structure(ffield, p_struct_number);
1739: fnd_flex_key_api.get_segments(ffield, fstruct, TRUE, nsegs, slist);
1740:
1741: delimiter := fnd_flex_ext.get_delimiter(

Line 1738: fstruct := fnd_flex_key_api.find_structure(ffield, p_struct_number);

1734: END IF;
1735:
1736:
1737: ffield := fnd_flex_key_api.find_flexfield(p_app_short_name, p_key_flx_code);
1738: fstruct := fnd_flex_key_api.find_structure(ffield, p_struct_number);
1739: fnd_flex_key_api.get_segments(ffield, fstruct, TRUE, nsegs, slist);
1740:
1741: delimiter := fnd_flex_ext.get_delimiter(
1742: application_short_name => p_app_short_name,

Line 1739: fnd_flex_key_api.get_segments(ffield, fstruct, TRUE, nsegs, slist);

1735:
1736:
1737: ffield := fnd_flex_key_api.find_flexfield(p_app_short_name, p_key_flx_code);
1738: fstruct := fnd_flex_key_api.find_structure(ffield, p_struct_number);
1739: fnd_flex_key_api.get_segments(ffield, fstruct, TRUE, nsegs, slist);
1740:
1741: delimiter := fnd_flex_ext.get_delimiter(
1742: application_short_name => p_app_short_name,
1743: key_flex_code => p_key_flx_code,

Line 1755: fsegment := fnd_flex_key_api.find_segment(ffield, fstruct, slist(i));

1751: IF (delimiter IS NOT NULL) THEN
1752: concat_string := '';
1753:
1754: FOR i IN 1..nsegs LOOP
1755: fsegment := fnd_flex_key_api.find_segment(ffield, fstruct, slist(i));
1756: charcol := fsegment.column_name;
1757: if l_debug_on then
1758: wsh_debug_sv.log(l_module_name, 'charcol', charcol);
1759: end if;

Line 1833: WSH_DEBUG_SV.log(l_module_name, 'Exception:', fnd_flex_key_api.message);

1829: END IF;
1830: --
1831: WHEN others THEN
1832: IF l_debug_on THEN
1833: WSH_DEBUG_SV.log(l_module_name, 'Exception:', fnd_flex_key_api.message);
1834: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1835: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1836: END IF;
1837: END Validate_Flexfields;