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.WIP_DIAG_DATA_COLL dependencies on FND_PROFILE

Line 5038: profile_val fnd_profile_option_values.profile_option_value%type ;

5034:
5035:
5036: procedure checkWipProfiles is
5037:
5038: profile_val fnd_profile_option_values.profile_option_value%type ;
5039:
5040: begin
5041:
5042: row_limit := 1000;

Line 5049: fnd_profile.get('USER_ID', l_user_id);

5045:
5046: l_url := 'http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT' || '&' || 'p_id=67009.1' ;
5047: l_desc := 'Oracle Work in Process Documentation - Release 11i' ;
5048:
5049: fnd_profile.get('USER_ID', l_user_id);
5050: fnd_profile.get('USER_NAME', l_user_name);
5051: fnd_profile.get('RESP_ID', l_resp_id);
5052: fnd_profile.get('RESP_NAME', l_resp_name);
5053:

Line 5050: fnd_profile.get('USER_NAME', l_user_name);

5046: l_url := 'http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT' || '&' || 'p_id=67009.1' ;
5047: l_desc := 'Oracle Work in Process Documentation - Release 11i' ;
5048:
5049: fnd_profile.get('USER_ID', l_user_id);
5050: fnd_profile.get('USER_NAME', l_user_name);
5051: fnd_profile.get('RESP_ID', l_resp_id);
5052: fnd_profile.get('RESP_NAME', l_resp_name);
5053:
5054: if l_user_id is null then

Line 5051: fnd_profile.get('RESP_ID', l_resp_id);

5047: l_desc := 'Oracle Work in Process Documentation - Release 11i' ;
5048:
5049: fnd_profile.get('USER_ID', l_user_id);
5050: fnd_profile.get('USER_NAME', l_user_name);
5051: fnd_profile.get('RESP_ID', l_resp_id);
5052: fnd_profile.get('RESP_NAME', l_resp_name);
5053:
5054: if l_user_id is null then
5055: l_user_id_string := '0' ;

Line 5052: fnd_profile.get('RESP_NAME', l_resp_name);

5048:
5049: fnd_profile.get('USER_ID', l_user_id);
5050: fnd_profile.get('USER_NAME', l_user_name);
5051: fnd_profile.get('RESP_ID', l_resp_id);
5052: fnd_profile.get('RESP_NAME', l_resp_name);
5053:
5054: if l_user_id is null then
5055: l_user_id_string := '0' ;
5056: else

Line 5070: ' from fnd_profile_option_values fpov , '||

5066: /*
5067: sqltxt := 'select substr(fpo.user_profile_option_name, 1, 60) Profile ,decode(substr(fpov.profile_option_value, 1, 52), ''1'', ''Yes'', ''2'', ''No'', substr(fpov.profile_option_value,1, 52)) Value, '||
5068:
5069: ' decode(fpov.level_id, 10001, ''Site'', 10002, ''Appl'', 10003, ''Resp'', 10004, ''User'', ''None'') lvl '||
5070: ' from fnd_profile_option_values fpov , '||
5071: ' fnd_profile_options_vl fpo ' ||
5072: ' where fpo.application_id = fpov.application_id ' ||
5073: ' and fpo.profile_option_id = fpov.profile_option_id ' ||
5074: ' and (fpov.application_id = 706 '||

Line 5071: ' fnd_profile_options_vl fpo ' ||

5067: sqltxt := 'select substr(fpo.user_profile_option_name, 1, 60) Profile ,decode(substr(fpov.profile_option_value, 1, 52), ''1'', ''Yes'', ''2'', ''No'', substr(fpov.profile_option_value,1, 52)) Value, '||
5068:
5069: ' decode(fpov.level_id, 10001, ''Site'', 10002, ''Appl'', 10003, ''Resp'', 10004, ''User'', ''None'') lvl '||
5070: ' from fnd_profile_option_values fpov , '||
5071: ' fnd_profile_options_vl fpo ' ||
5072: ' where fpo.application_id = fpov.application_id ' ||
5073: ' and fpo.profile_option_id = fpov.profile_option_id ' ||
5074: ' and (fpov.application_id = 706 '||
5075: ' and fpov.profile_option_id in ( ' ||

Line 5077: ' from fnd_profile_options_vl fpovl ' ||

5073: ' and fpo.profile_option_id = fpov.profile_option_id ' ||
5074: ' and (fpov.application_id = 706 '||
5075: ' and fpov.profile_option_id in ( ' ||
5076: ' select fpovl.profile_option_id ' ||
5077: ' from fnd_profile_options_vl fpovl ' ||
5078: ' where fpovl.application_id = 706 ' ||
5079: ' and fpovl.start_date_active <= sysdate ' ||
5080: ' and nvl(fpovl.end_date_active,sysdate) >= sysdate) ' ||
5081: ' or (fpov.application_id = 704 and fpov.profile_option_id = 1260)) ' ||

Line 5114: reportStr := 'FND Profiles' ;

5110: /* Fix for #5757345. in following if */
5111:
5112: if (release_level in ('11.5.10' , '11.5.10.1', '11.5.10.2')) then
5113:
5114: reportStr := 'FND Profiles' ;
5115: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5116:
5117: -- Check FND Profile for WIP Debugging
5118: reportStr := 'FND Profiles - FND: Debug Log Enabled' ;

Line 5117: -- Check FND Profile for WIP Debugging

5113:
5114: reportStr := 'FND Profiles' ;
5115: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5116:
5117: -- Check FND Profile for WIP Debugging
5118: reportStr := 'FND Profiles - FND: Debug Log Enabled' ;
5119: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5120: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_ENABLED');
5121:

Line 5118: reportStr := 'FND Profiles - FND: Debug Log Enabled' ;

5114: reportStr := 'FND Profiles' ;
5115: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5116:
5117: -- Check FND Profile for WIP Debugging
5118: reportStr := 'FND Profiles - FND: Debug Log Enabled' ;
5119: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5120: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_ENABLED');
5121:
5122: reportStr := 'FND Profiles - FND: Debug Log FileName' ;

Line 5122: reportStr := 'FND Profiles - FND: Debug Log FileName' ;

5118: reportStr := 'FND Profiles - FND: Debug Log Enabled' ;
5119: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5120: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_ENABLED');
5121:
5122: reportStr := 'FND Profiles - FND: Debug Log FileName' ;
5123: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5124: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_FILENAME');
5125:
5126: reportStr := 'FND Profiles - FND: Debug Log Level' ;

Line 5126: reportStr := 'FND Profiles - FND: Debug Log Level' ;

5122: reportStr := 'FND Profiles - FND: Debug Log FileName' ;
5123: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5124: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_FILENAME');
5125:
5126: reportStr := 'FND Profiles - FND: Debug Log Level' ;
5127: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5128: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_LEVEL');
5129:
5130: reportStr := 'FND Profiles - FND: Debug Log Module' ;

Line 5130: reportStr := 'FND Profiles - FND: Debug Log Module' ;

5126: reportStr := 'FND Profiles - FND: Debug Log Level' ;
5127: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5128: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_LEVEL');
5129:
5130: reportStr := 'FND Profiles - FND: Debug Log Module' ;
5131: JTF_DIAGNOSTIC_COREAPI.SectionPrint(reportStr) ;
5132: JTF_DIAGNOSTIC_COREAPI.Display_Profiles(0, 'AFLOG_MODULE');
5133:
5134: reportStr := 'Following profiles are not used from 11.5.10 onwards' ;