eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_ATTRIBUTE_UTIL dependencies on FND_MESSAGE

Line 74: --nvl(CODE.DESCRIPTION,VAL.ATTR_VALUE || ' (' || fnd_message.get_String('PV','PV_INVALID_VALUE') || ')') "CodeName",

70: --ENTY.LOV_STRING "lovString",
71: 'VAL.ATTR_VALUE "attrValue", '||
72: 'VAL.ATTR_VALUE_EXTN "attrValueExtn", '||
73: --CODE.DESCRIPTION "CodeName",
74: --nvl(CODE.DESCRIPTION,VAL.ATTR_VALUE || ' (' || fnd_message.get_String('PV','PV_INVALID_VALUE') || ')') "CodeName",
75: 'case when VAL.ATTR_VALUE is null then '''' '||
76: ' when CODE.ATTR_CODE = VAL.ATTR_VALUE then CODE.DESCRIPTION '||
77: ' else VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'' '||
78: ' end ' ||

Line 77: ' else VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'' '||

73: --CODE.DESCRIPTION "CodeName",
74: --nvl(CODE.DESCRIPTION,VAL.ATTR_VALUE || ' (' || fnd_message.get_String('PV','PV_INVALID_VALUE') || ')') "CodeName",
75: 'case when VAL.ATTR_VALUE is null then '''' '||
76: ' when CODE.ATTR_CODE = VAL.ATTR_VALUE then CODE.DESCRIPTION '||
77: ' else VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'' '||
78: ' end ' ||
79: ' "CodeName", '||
80:
81: 'VAL.LAST_UPDATE_DATE "date" ' ||

Line 280: --'nvl(CODE.DESCRIPTION,VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'') "CodeName", ' ||

276: 'ATTR.DISPLAY_STYLE "displayStyle", '||
277: 'VAL.ATTR_VALUE "attrValue", '||
278: 'VAL.ATTR_VALUE_EXTN "attrValueExtn", '||
279: --'CODE.DESCRIPTION "CodeName", '||
280: --'nvl(CODE.DESCRIPTION,VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'') "CodeName", ' ||
281: --'decode(CODE.DESCRIPTION,null,'',VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'') "CodeName", ' ||
282: 'case when VAL.ATTR_VALUE is null then '''' ' ||
283: 'when CODE.ATTR_CODE = VAL.ATTR_VALUE then CODE.DESCRIPTION ' ||
284: 'else VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'' ' ||

Line 281: --'decode(CODE.DESCRIPTION,null,'',VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'') "CodeName", ' ||

277: 'VAL.ATTR_VALUE "attrValue", '||
278: 'VAL.ATTR_VALUE_EXTN "attrValueExtn", '||
279: --'CODE.DESCRIPTION "CodeName", '||
280: --'nvl(CODE.DESCRIPTION,VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'') "CodeName", ' ||
281: --'decode(CODE.DESCRIPTION,null,'',VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'') "CodeName", ' ||
282: 'case when VAL.ATTR_VALUE is null then '''' ' ||
283: 'when CODE.ATTR_CODE = VAL.ATTR_VALUE then CODE.DESCRIPTION ' ||
284: 'else VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'' ' ||
285: ' end ' ||

Line 284: 'else VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'' ' ||

280: --'nvl(CODE.DESCRIPTION,VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'') "CodeName", ' ||
281: --'decode(CODE.DESCRIPTION,null,'',VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'') "CodeName", ' ||
282: 'case when VAL.ATTR_VALUE is null then '''' ' ||
283: 'when CODE.ATTR_CODE = VAL.ATTR_VALUE then CODE.DESCRIPTION ' ||
284: 'else VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'' ' ||
285: ' end ' ||
286:
287: ' "CodeName", ' ||
288:

Line 317: --'nvl(CODE.DESCRIPTION,VAL.ATTR_TEXT || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'') "CodeName", ' ||

313: 'ATTR.DISPLAY_STYLE "displayStyle", '||
314: 'DECODE(ATTR.RETURN_TYPE, ' || '''' || 'NUMBER' || '''' || ', to_char(VAL.attr_value), VAL.attr_text) "attrValue", '||
315: '''' || '' || '''' || ' "attrValueExtn", '||
316: --'CODE.DESCRIPTION "CodeName", '||
317: --'nvl(CODE.DESCRIPTION,VAL.ATTR_TEXT || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'') "CodeName", ' ||
318: 'case when VAL.ATTR_TEXT is null then '''' ' ||
319: 'when CODE.ATTR_CODE = VAL.ATTR_TEXT then CODE.DESCRIPTION ' ||
320: 'else VAL.ATTR_TEXT || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'' ' ||
321: ' end ' ||

Line 320: 'else VAL.ATTR_TEXT || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'' ' ||

316: --'CODE.DESCRIPTION "CodeName", '||
317: --'nvl(CODE.DESCRIPTION,VAL.ATTR_TEXT || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'') "CodeName", ' ||
318: 'case when VAL.ATTR_TEXT is null then '''' ' ||
319: 'when CODE.ATTR_CODE = VAL.ATTR_TEXT then CODE.DESCRIPTION ' ||
320: 'else VAL.ATTR_TEXT || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'' ' ||
321: ' end ' ||
322:
323: ' "CodeName", ' ||
324:

Line 380: --'nvl(CODE.DESCRIPTION,VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'') "CodeName", ' ||

376: 'ATTR.DISPLAY_STYLE displayStyle, ' ||
377: 'VAL.ATTR_VALUE attrValue, ' ||
378: 'VAL.ATTR_VALUE_EXTN attrValueExtn, ' ||
379: --'CODE.DESCRIPTION CodeName, ' ||
380: --'nvl(CODE.DESCRIPTION,VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'') "CodeName", ' ||
381: 'case when VAL.ATTR_VALUE is null then '''' ' ||
382: 'when CODE.ATTR_CODE = VAL.ATTR_VALUE then CODE.DESCRIPTION ' ||
383: 'else VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'' ' ||
384: ' end ' ||

Line 383: 'else VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'' ' ||

379: --'CODE.DESCRIPTION CodeName, ' ||
380: --'nvl(CODE.DESCRIPTION,VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'') "CodeName", ' ||
381: 'case when VAL.ATTR_VALUE is null then '''' ' ||
382: 'when CODE.ATTR_CODE = VAL.ATTR_VALUE then CODE.DESCRIPTION ' ||
383: 'else VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'' ' ||
384: ' end ' ||
385:
386: ' CodeName, ' ||
387:

Line 423: --'nvl(CODE.DESCRIPTION,VAL.ATTR_TEXT || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'') "CodeName", ' ||

419: 'ATTR.DISPLAY_STYLE "displayStyle", '||
420: 'DECODE(ATTR.RETURN_TYPE, ' || '''' || 'NUMBER' || '''' || ', to_char(VAL.attr_value), VAL.attr_text) "attrValue", '||
421: '''' || '' || '''' || ' "attrValueExtn", '||
422: --'CODE.DESCRIPTION "CodeName", '||
423: --'nvl(CODE.DESCRIPTION,VAL.ATTR_TEXT || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'') "CodeName", ' ||
424: 'case when VAL.ATTR_TEXT is null then '''' ' ||
425: 'when CODE.ATTR_CODE = VAL.ATTR_TEXT then CODE.DESCRIPTION ' ||
426: 'else VAL.ATTR_TEXT || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'' ' ||
427: ' end ' ||

Line 426: 'else VAL.ATTR_TEXT || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'' ' ||

422: --'CODE.DESCRIPTION "CodeName", '||
423: --'nvl(CODE.DESCRIPTION,VAL.ATTR_TEXT || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'') "CodeName", ' ||
424: 'case when VAL.ATTR_TEXT is null then '''' ' ||
425: 'when CODE.ATTR_CODE = VAL.ATTR_TEXT then CODE.DESCRIPTION ' ||
426: 'else VAL.ATTR_TEXT || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'' ' ||
427: ' end ' ||
428:
429: ' "CodeName", ' ||
430:

Line 833: return code || ' (' || fnd_message.get_String('PV','PV_INVALID_VALUE') || ')';

829:
830: --if(rtrim(code) = '' or code = null) then
831: -- return '';
832: --else
833: return code || ' (' || fnd_message.get_String('PV','PV_INVALID_VALUE') || ')';
834: --end if;
835:
836: END MAP_CODE_TO_VALUE;
837:

Line 874: l_attr_value:= code || ' (' || fnd_message.get_String('PV','PV_INVALID_VALUE') || ')';

870:
871: exception
872: when others then
873: --dbms_output.put_line('error:' || SQLERRM);
874: l_attr_value:= code || ' (' || fnd_message.get_String('PV','PV_INVALID_VALUE') || ')';
875: end;
876:
877: if l_attr_value is not null then
878: return l_attr_value;

Line 881: return code || ' (' || fnd_message.get_String('PV','PV_INVALID_VALUE') || ')';

877: if l_attr_value is not null then
878: return l_attr_value;
879: end if;
880:
881: return code || ' (' || fnd_message.get_String('PV','PV_INVALID_VALUE') || ')';
882:
883:
884: END MAP_CODE_TO_VALUE1;
885: