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.EDR_INDEXED_XML_UTIL dependencies on FND_MESSAGE

Line 122: fnd_message.set_name( 'EDR', 'EDR_PLS_IXE_BUILD_END' );

118: commit;
119:
120: -- Bug 3196897: start:
121: l_time_str := fnd_date.Date_To_DisplayDT(sysdate, fnd_timezones.Get_Server_Timezone_Code);
122: fnd_message.set_name( 'EDR', 'EDR_PLS_IXE_BUILD_END' );
123: fnd_message.set_token( 'FINISH_TIME', l_time_str );
124: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
125:
126: -- note: fnd_profile.defined( NAME ) return false if profile exist with no value

Line 123: fnd_message.set_token( 'FINISH_TIME', l_time_str );

119:
120: -- Bug 3196897: start:
121: l_time_str := fnd_date.Date_To_DisplayDT(sysdate, fnd_timezones.Get_Server_Timezone_Code);
122: fnd_message.set_name( 'EDR', 'EDR_PLS_IXE_BUILD_END' );
123: fnd_message.set_token( 'FINISH_TIME', l_time_str );
124: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
125:
126: -- note: fnd_profile.defined( NAME ) return false if profile exist with no value
127: -- note: if profile not exist, fnd_profile.Save() will fail and return false

Line 124: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );

120: -- Bug 3196897: start:
121: l_time_str := fnd_date.Date_To_DisplayDT(sysdate, fnd_timezones.Get_Server_Timezone_Code);
122: fnd_message.set_name( 'EDR', 'EDR_PLS_IXE_BUILD_END' );
123: fnd_message.set_token( 'FINISH_TIME', l_time_str );
124: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
125:
126: -- note: fnd_profile.defined( NAME ) return false if profile exist with no value
127: -- note: if profile not exist, fnd_profile.Save() will fail and return false
128: IF fnd_profile.Save( G_PROFILE_SYNC_TIME, l_time_str, 'SITE' ) THEN

Line 131: fnd_message.set_name( 'EDR', 'EDR_GENERAL_UPDATE_FAIL' );

127: -- note: if profile not exist, fnd_profile.Save() will fail and return false
128: IF fnd_profile.Save( G_PROFILE_SYNC_TIME, l_time_str, 'SITE' ) THEN
129: commit; -- need commit for the profile to take immediate effect
130: ELSE
131: fnd_message.set_name( 'EDR', 'EDR_GENERAL_UPDATE_FAIL' );
132: fnd_message.set_token( 'OBJECT_NAME', G_PROFILE_SYNC_TIME );
133: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
134: END IF;
135: -- Bug 3196897: end:

Line 132: fnd_message.set_token( 'OBJECT_NAME', G_PROFILE_SYNC_TIME );

128: IF fnd_profile.Save( G_PROFILE_SYNC_TIME, l_time_str, 'SITE' ) THEN
129: commit; -- need commit for the profile to take immediate effect
130: ELSE
131: fnd_message.set_name( 'EDR', 'EDR_GENERAL_UPDATE_FAIL' );
132: fnd_message.set_token( 'OBJECT_NAME', G_PROFILE_SYNC_TIME );
133: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
134: END IF;
135: -- Bug 3196897: end:
136:

Line 133: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );

129: commit; -- need commit for the profile to take immediate effect
130: ELSE
131: fnd_message.set_name( 'EDR', 'EDR_GENERAL_UPDATE_FAIL' );
132: fnd_message.set_token( 'OBJECT_NAME', G_PROFILE_SYNC_TIME );
133: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
134: END IF;
135: -- Bug 3196897: end:
136:
137: exception

Line 161: fnd_message.set_name('EDR', 'EDR_PLS_IXE_SYNC_START');

157: l_time_str varchar2(30);
158:
159: BEGIN
160:
161: fnd_message.set_name('EDR', 'EDR_PLS_IXE_SYNC_START');
162: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');
163: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
164:
165: ctx_ddl.sync_index ( 'EDR_PSIG_TEXTINDEX' );

Line 162: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');

158:
159: BEGIN
160:
161: fnd_message.set_name('EDR', 'EDR_PLS_IXE_SYNC_START');
162: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');
163: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
164:
165: ctx_ddl.sync_index ( 'EDR_PSIG_TEXTINDEX' );
166:

Line 163: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );

159: BEGIN
160:
161: fnd_message.set_name('EDR', 'EDR_PLS_IXE_SYNC_START');
162: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');
163: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
164:
165: ctx_ddl.sync_index ( 'EDR_PSIG_TEXTINDEX' );
166:
167: -- Bug 3196897: start:

Line 169: fnd_message.set_name( 'EDR', 'EDR_PLS_IXE_SYNC_END' );

165: ctx_ddl.sync_index ( 'EDR_PSIG_TEXTINDEX' );
166:
167: -- Bug 3196897: start:
168: l_time_str := fnd_date.Date_To_DisplayDT(sysdate, fnd_timezones.Get_Server_Timezone_Code);
169: fnd_message.set_name( 'EDR', 'EDR_PLS_IXE_SYNC_END' );
170: fnd_message.set_token( 'FINISH_TIME', l_time_str );
171: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
172:
173: -- note: fnd_profile.defined( NAME ) return false if profile exist with no value

Line 170: fnd_message.set_token( 'FINISH_TIME', l_time_str );

166:
167: -- Bug 3196897: start:
168: l_time_str := fnd_date.Date_To_DisplayDT(sysdate, fnd_timezones.Get_Server_Timezone_Code);
169: fnd_message.set_name( 'EDR', 'EDR_PLS_IXE_SYNC_END' );
170: fnd_message.set_token( 'FINISH_TIME', l_time_str );
171: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
172:
173: -- note: fnd_profile.defined( NAME ) return false if profile exist with no value
174: -- note: if profile not exist, fnd_profile.Save() will fail and return false

Line 171: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );

167: -- Bug 3196897: start:
168: l_time_str := fnd_date.Date_To_DisplayDT(sysdate, fnd_timezones.Get_Server_Timezone_Code);
169: fnd_message.set_name( 'EDR', 'EDR_PLS_IXE_SYNC_END' );
170: fnd_message.set_token( 'FINISH_TIME', l_time_str );
171: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
172:
173: -- note: fnd_profile.defined( NAME ) return false if profile exist with no value
174: -- note: if profile not exist, fnd_profile.Save() will fail and return false
175: IF fnd_profile.Save( G_PROFILE_SYNC_TIME, l_time_str, 'SITE' ) THEN

Line 178: fnd_message.set_name( 'EDR', 'EDR_GENERAL_UPDATE_FAIL' );

174: -- note: if profile not exist, fnd_profile.Save() will fail and return false
175: IF fnd_profile.Save( G_PROFILE_SYNC_TIME, l_time_str, 'SITE' ) THEN
176: commit; -- need commit to take immediate effect
177: ELSE
178: fnd_message.set_name( 'EDR', 'EDR_GENERAL_UPDATE_FAIL' );
179: fnd_message.set_token( 'OBJECT_NAME', G_PROFILE_SYNC_TIME );
180: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
181: END IF;
182: -- Bug 3196897: end:

Line 179: fnd_message.set_token( 'OBJECT_NAME', G_PROFILE_SYNC_TIME );

175: IF fnd_profile.Save( G_PROFILE_SYNC_TIME, l_time_str, 'SITE' ) THEN
176: commit; -- need commit to take immediate effect
177: ELSE
178: fnd_message.set_name( 'EDR', 'EDR_GENERAL_UPDATE_FAIL' );
179: fnd_message.set_token( 'OBJECT_NAME', G_PROFILE_SYNC_TIME );
180: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
181: END IF;
182: -- Bug 3196897: end:
183:

Line 180: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );

176: commit; -- need commit to take immediate effect
177: ELSE
178: fnd_message.set_name( 'EDR', 'EDR_GENERAL_UPDATE_FAIL' );
179: fnd_message.set_token( 'OBJECT_NAME', G_PROFILE_SYNC_TIME );
180: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
181: END IF;
182: -- Bug 3196897: end:
183:
184: EXCEPTION

Line 212: fnd_message.set_name( 'EDR', 'EDR_PLS_PARAM_INVALID' );

208: -- check the valid parameter for optimization level
209: IF p_optimize_level is null THEN
210: l_opt_level := ctx_ddl.optlevel_full;
211: ELSIF upper(p_optimize_level) not in ('FAST','FULL') then
212: fnd_message.set_name( 'EDR', 'EDR_PLS_PARAM_INVALID' );
213: fnd_message.set_token( 'PLSPROC', 'EDR_INDEXED_XML_UTIL.Optimize_Index' );
214: fnd_message.set_token( 'PARAM', 'p_optimize_level' );
215: fnd_message.set_token( 'VALUE', p_optimize_level );
216: raise_application_error(-20000, fnd_message.get);

Line 213: fnd_message.set_token( 'PLSPROC', 'EDR_INDEXED_XML_UTIL.Optimize_Index' );

209: IF p_optimize_level is null THEN
210: l_opt_level := ctx_ddl.optlevel_full;
211: ELSIF upper(p_optimize_level) not in ('FAST','FULL') then
212: fnd_message.set_name( 'EDR', 'EDR_PLS_PARAM_INVALID' );
213: fnd_message.set_token( 'PLSPROC', 'EDR_INDEXED_XML_UTIL.Optimize_Index' );
214: fnd_message.set_token( 'PARAM', 'p_optimize_level' );
215: fnd_message.set_token( 'VALUE', p_optimize_level );
216: raise_application_error(-20000, fnd_message.get);
217: ELSE l_opt_level := p_optimize_level;

Line 214: fnd_message.set_token( 'PARAM', 'p_optimize_level' );

210: l_opt_level := ctx_ddl.optlevel_full;
211: ELSIF upper(p_optimize_level) not in ('FAST','FULL') then
212: fnd_message.set_name( 'EDR', 'EDR_PLS_PARAM_INVALID' );
213: fnd_message.set_token( 'PLSPROC', 'EDR_INDEXED_XML_UTIL.Optimize_Index' );
214: fnd_message.set_token( 'PARAM', 'p_optimize_level' );
215: fnd_message.set_token( 'VALUE', p_optimize_level );
216: raise_application_error(-20000, fnd_message.get);
217: ELSE l_opt_level := p_optimize_level;
218: END IF;

Line 215: fnd_message.set_token( 'VALUE', p_optimize_level );

211: ELSIF upper(p_optimize_level) not in ('FAST','FULL') then
212: fnd_message.set_name( 'EDR', 'EDR_PLS_PARAM_INVALID' );
213: fnd_message.set_token( 'PLSPROC', 'EDR_INDEXED_XML_UTIL.Optimize_Index' );
214: fnd_message.set_token( 'PARAM', 'p_optimize_level' );
215: fnd_message.set_token( 'VALUE', p_optimize_level );
216: raise_application_error(-20000, fnd_message.get);
217: ELSE l_opt_level := p_optimize_level;
218: END IF;
219: fnd_message.set_name('EDR', 'EDR_PLS_IXE_OPTIM_LEVEL');

Line 216: raise_application_error(-20000, fnd_message.get);

212: fnd_message.set_name( 'EDR', 'EDR_PLS_PARAM_INVALID' );
213: fnd_message.set_token( 'PLSPROC', 'EDR_INDEXED_XML_UTIL.Optimize_Index' );
214: fnd_message.set_token( 'PARAM', 'p_optimize_level' );
215: fnd_message.set_token( 'VALUE', p_optimize_level );
216: raise_application_error(-20000, fnd_message.get);
217: ELSE l_opt_level := p_optimize_level;
218: END IF;
219: fnd_message.set_name('EDR', 'EDR_PLS_IXE_OPTIM_LEVEL');
220: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');

Line 219: fnd_message.set_name('EDR', 'EDR_PLS_IXE_OPTIM_LEVEL');

215: fnd_message.set_token( 'VALUE', p_optimize_level );
216: raise_application_error(-20000, fnd_message.get);
217: ELSE l_opt_level := p_optimize_level;
218: END IF;
219: fnd_message.set_name('EDR', 'EDR_PLS_IXE_OPTIM_LEVEL');
220: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');
221: fnd_message.set_token('IXE_OPT_LEVEL', l_opt_level );
222: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
223:

Line 220: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');

216: raise_application_error(-20000, fnd_message.get);
217: ELSE l_opt_level := p_optimize_level;
218: END IF;
219: fnd_message.set_name('EDR', 'EDR_PLS_IXE_OPTIM_LEVEL');
220: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');
221: fnd_message.set_token('IXE_OPT_LEVEL', l_opt_level );
222: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
223:
224: -- check the valid parameter for the time spent in each running of optimization

Line 221: fnd_message.set_token('IXE_OPT_LEVEL', l_opt_level );

217: ELSE l_opt_level := p_optimize_level;
218: END IF;
219: fnd_message.set_name('EDR', 'EDR_PLS_IXE_OPTIM_LEVEL');
220: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');
221: fnd_message.set_token('IXE_OPT_LEVEL', l_opt_level );
222: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
223:
224: -- check the valid parameter for the time spent in each running of optimization
225: IF p_duration is null THEN

Line 222: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );

218: END IF;
219: fnd_message.set_name('EDR', 'EDR_PLS_IXE_OPTIM_LEVEL');
220: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');
221: fnd_message.set_token('IXE_OPT_LEVEL', l_opt_level );
222: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
223:
224: -- check the valid parameter for the time spent in each running of optimization
225: IF p_duration is null THEN
226: l_maxtime := ctx_ddl.maxtime_unlimited;

Line 230: fnd_message.set_name( 'EDR', 'EDR_PLS_PARAM_INVALID' );

226: l_maxtime := ctx_ddl.maxtime_unlimited;
227: ELSE
228: IF trunc(p_duration) <> p_duration or p_duration < 0
229: or p_duration > ctx_ddl.maxtime_unlimited THEN
230: fnd_message.set_name( 'EDR', 'EDR_PLS_PARAM_INVALID' );
231: fnd_message.set_token( 'PLSPROC', 'EDR_INDEXED_XML_UTIL.Optimize_Index' );
232: fnd_message.set_token( 'PARAM', 'p_duration' );
233: fnd_message.set_token( 'VALUE', p_duration );
234: Raise_application_error(-20000, fnd_message.get);

Line 231: fnd_message.set_token( 'PLSPROC', 'EDR_INDEXED_XML_UTIL.Optimize_Index' );

227: ELSE
228: IF trunc(p_duration) <> p_duration or p_duration < 0
229: or p_duration > ctx_ddl.maxtime_unlimited THEN
230: fnd_message.set_name( 'EDR', 'EDR_PLS_PARAM_INVALID' );
231: fnd_message.set_token( 'PLSPROC', 'EDR_INDEXED_XML_UTIL.Optimize_Index' );
232: fnd_message.set_token( 'PARAM', 'p_duration' );
233: fnd_message.set_token( 'VALUE', p_duration );
234: Raise_application_error(-20000, fnd_message.get);
235: END IF;

Line 232: fnd_message.set_token( 'PARAM', 'p_duration' );

228: IF trunc(p_duration) <> p_duration or p_duration < 0
229: or p_duration > ctx_ddl.maxtime_unlimited THEN
230: fnd_message.set_name( 'EDR', 'EDR_PLS_PARAM_INVALID' );
231: fnd_message.set_token( 'PLSPROC', 'EDR_INDEXED_XML_UTIL.Optimize_Index' );
232: fnd_message.set_token( 'PARAM', 'p_duration' );
233: fnd_message.set_token( 'VALUE', p_duration );
234: Raise_application_error(-20000, fnd_message.get);
235: END IF;
236: END IF;

Line 233: fnd_message.set_token( 'VALUE', p_duration );

229: or p_duration > ctx_ddl.maxtime_unlimited THEN
230: fnd_message.set_name( 'EDR', 'EDR_PLS_PARAM_INVALID' );
231: fnd_message.set_token( 'PLSPROC', 'EDR_INDEXED_XML_UTIL.Optimize_Index' );
232: fnd_message.set_token( 'PARAM', 'p_duration' );
233: fnd_message.set_token( 'VALUE', p_duration );
234: Raise_application_error(-20000, fnd_message.get);
235: END IF;
236: END IF;
237:

Line 234: Raise_application_error(-20000, fnd_message.get);

230: fnd_message.set_name( 'EDR', 'EDR_PLS_PARAM_INVALID' );
231: fnd_message.set_token( 'PLSPROC', 'EDR_INDEXED_XML_UTIL.Optimize_Index' );
232: fnd_message.set_token( 'PARAM', 'p_duration' );
233: fnd_message.set_token( 'VALUE', p_duration );
234: Raise_application_error(-20000, fnd_message.get);
235: END IF;
236: END IF;
237:
238: IF p_optimize_level = 'FAST' THEN

Line 248: fnd_message.set_name('EDR', 'EDR_PLS_IXE_OPTIM_TIME');

244: l_maxtime := trunc( p_duration );
245: END IF;
246: END IF;
247: IF l_maxtime is not null THEN
248: fnd_message.set_name('EDR', 'EDR_PLS_IXE_OPTIM_TIME');
249: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');
250: fnd_message.set_token('IXE_OPT_TIME', l_maxtime );
251: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
252: END IF;

Line 249: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');

245: END IF;
246: END IF;
247: IF l_maxtime is not null THEN
248: fnd_message.set_name('EDR', 'EDR_PLS_IXE_OPTIM_TIME');
249: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');
250: fnd_message.set_token('IXE_OPT_TIME', l_maxtime );
251: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
252: END IF;
253:

Line 250: fnd_message.set_token('IXE_OPT_TIME', l_maxtime );

246: END IF;
247: IF l_maxtime is not null THEN
248: fnd_message.set_name('EDR', 'EDR_PLS_IXE_OPTIM_TIME');
249: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');
250: fnd_message.set_token('IXE_OPT_TIME', l_maxtime );
251: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
252: END IF;
253:
254: ctx_ddl.optimize_index( 'EDR_PSIG_TEXTINDEX', l_opt_level, l_maxtime );

Line 251: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );

247: IF l_maxtime is not null THEN
248: fnd_message.set_name('EDR', 'EDR_PLS_IXE_OPTIM_TIME');
249: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');
250: fnd_message.set_token('IXE_OPT_TIME', l_maxtime );
251: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
252: END IF;
253:
254: ctx_ddl.optimize_index( 'EDR_PSIG_TEXTINDEX', l_opt_level, l_maxtime );
255: fnd_message.set_name('EDR', 'EDR_PLS_IXE_OPTIM_END');

Line 255: fnd_message.set_name('EDR', 'EDR_PLS_IXE_OPTIM_END');

251: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
252: END IF;
253:
254: ctx_ddl.optimize_index( 'EDR_PSIG_TEXTINDEX', l_opt_level, l_maxtime );
255: fnd_message.set_name('EDR', 'EDR_PLS_IXE_OPTIM_END');
256: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');
257: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
258:
259: EXCEPTION

Line 256: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');

252: END IF;
253:
254: ctx_ddl.optimize_index( 'EDR_PSIG_TEXTINDEX', l_opt_level, l_maxtime );
255: fnd_message.set_name('EDR', 'EDR_PLS_IXE_OPTIM_END');
256: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');
257: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
258:
259: EXCEPTION
260: when others then

Line 257: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );

253:
254: ctx_ddl.optimize_index( 'EDR_PSIG_TEXTINDEX', l_opt_level, l_maxtime );
255: fnd_message.set_name('EDR', 'EDR_PLS_IXE_OPTIM_END');
256: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');
257: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
258:
259: EXCEPTION
260: when others then
261: errbuf := substr(sqlerrm, 1, 240);