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_FILE

Line 34: fnd_file.put_line(FND_FILE.LOG,'Index dropped for refresh');

30: begin
31: begin
32: l_str:= 'drop index edr_psig_textindex';
33: execute immediate l_str;
34: fnd_file.put_line(FND_FILE.LOG,'Index dropped for refresh');
35: exception
36: when no_index then
37: fnd_file.put_line(FND_FILE.LOG,'Index does not exist. Creating index for the first time.');
38: end;

Line 37: fnd_file.put_line(FND_FILE.LOG,'Index does not exist. Creating index for the first time.');

33: execute immediate l_str;
34: fnd_file.put_line(FND_FILE.LOG,'Index dropped for refresh');
35: exception
36: when no_index then
37: fnd_file.put_line(FND_FILE.LOG,'Index does not exist. Creating index for the first time.');
38: end;
39:
40: begin
41: Ctx_Ddl.Drop_Section_Group

Line 44: fnd_file.put_line(FND_FILE.LOG,'Section group dropped for refresh');

40: begin
41: Ctx_Ddl.Drop_Section_Group
42: ( group_name => 'edr_section_group'
43: );
44: fnd_file.put_line(FND_FILE.LOG,'Section group dropped for refresh');
45: exception
46: when no_ctx_object then
47: fnd_file.put_line(FND_FILE.LOG,'Section group does not exist');
48: end;

Line 47: fnd_file.put_line(FND_FILE.LOG,'Section group does not exist');

43: );
44: fnd_file.put_line(FND_FILE.LOG,'Section group dropped for refresh');
45: exception
46: when no_ctx_object then
47: fnd_file.put_line(FND_FILE.LOG,'Section group does not exist');
48: end;
49:
50: begin
51: ctx_ddl.drop_preference('edrlex');

Line 52: fnd_file.put_line(FND_FILE.LOG,'Lexer preference dropped');

48: end;
49:
50: begin
51: ctx_ddl.drop_preference('edrlex');
52: fnd_file.put_line(FND_FILE.LOG,'Lexer preference dropped');
53: exception
54: when no_ctx_object then
55: fnd_file.put_line(FND_FILE.LOG,'Lexer preference does not exist.');
56: end;

Line 55: fnd_file.put_line(FND_FILE.LOG,'Lexer preference does not exist.');

51: ctx_ddl.drop_preference('edrlex');
52: fnd_file.put_line(FND_FILE.LOG,'Lexer preference dropped');
53: exception
54: when no_ctx_object then
55: fnd_file.put_line(FND_FILE.LOG,'Lexer preference does not exist.');
56: end;
57:
58: Ctx_Ddl.Create_Section_Group
59: (group_name => 'edr_section_group',

Line 61: fnd_file.put_line(FND_FILE.LOG,'Section group created ');

57:
58: Ctx_Ddl.Create_Section_Group
59: (group_name => 'edr_section_group',
60: group_type => 'xml_section_group');
61: fnd_file.put_line(FND_FILE.LOG,'Section group created ');
62:
63: ctx_ddl.create_preference('edrlex','BASIC_LEXER');
64:
65: --Bug 2783886: Start

Line 76: fnd_file.put_line(FND_FILE.LOG,'Wordlist preference dropped');

72: --FYI we are now putting a wild card at the end of ALL queries
73:
74: begin
75: ctx_ddl.drop_preference('edrwordlist');
76: fnd_file.put_line(FND_FILE.LOG,'Wordlist preference dropped');
77: exception
78: when no_ctx_object then
79: fnd_file.put_line(FND_FILE.LOG,'Wordlist preference does not exist.');
80: end;

Line 79: fnd_file.put_line(FND_FILE.LOG,'Wordlist preference does not exist.');

75: ctx_ddl.drop_preference('edrwordlist');
76: fnd_file.put_line(FND_FILE.LOG,'Wordlist preference dropped');
77: exception
78: when no_ctx_object then
79: fnd_file.put_line(FND_FILE.LOG,'Wordlist preference does not exist.');
80: end;
81:
82: ctx_ddl.create_preference('edrwordlist', 'BASIC_WORDLIST');
83: ctx_ddl.set_attribute('edrwordlist','PREFIX_INDEX','YES');

Line 89: fnd_file.put_line(FND_FILE.LOG,'Lexer preference created');

85: ctx_ddl.set_attribute('edrwordlist','PREFIX_MAX_LENGTH', 64);
86:
87: --Bug 2783886: End
88:
89: fnd_file.put_line(FND_FILE.LOG,'Lexer preference created');
90: open c1;
91: loop
92: fetch c1 into l_section_name, l_tag, l_status;
93: exit when c1%notfound;

Line 96: fnd_file.put_line(FND_FILE.LOG,'Activated section: '||l_section_name);

92: fetch c1 into l_section_name, l_tag, l_status;
93: exit when c1%notfound;
94: if (l_status = 'N') then
95: update edr_idx_xml_element_b set status = 'I' where index_tag = l_tag;
96: fnd_file.put_line(FND_FILE.LOG,'Activated section: '||l_section_name);
97: end if;
98: Ctx_Ddl.Add_zone_Section
99: (group_name =>'edr_section_group',
100: section_name =>l_section_name,

Line 103: fnd_file.put_line(FND_FILE.LOG,'Created section: '||l_section_name);

99: (group_name =>'edr_section_group',
100: section_name =>l_section_name,
101: tag =>l_tag
102: );
103: fnd_file.put_line(FND_FILE.LOG,'Created section: '||l_section_name);
104: end loop;
105: close c1;
106:
107: fnd_file.put_line(FND_FILE.LOG,'Sections created for indexed xml elements');

Line 107: fnd_file.put_line(FND_FILE.LOG,'Sections created for indexed xml elements');

103: fnd_file.put_line(FND_FILE.LOG,'Created section: '||l_section_name);
104: end loop;
105: close c1;
106:
107: fnd_file.put_line(FND_FILE.LOG,'Sections created for indexed xml elements');
108: OPEN get_table_owner;
109: FETCH get_table_owner into l_owner;
110: CLOSE get_table_owner;
111: l_str:= 'create index edr_psig_textindex on '||l_owner||'.edr_psig_documents(psig_xml) '||

Line 116: fnd_file.put_line(FND_FILE.LOG,'Index created successfully');

112: 'indextype is ctxsys.context parameters '||
113: '(''LEXER edrlex FILTER ctxsys.null_filter SECTION GROUP edr_section_group'')';
114:
115: execute immediate l_str;
116: fnd_file.put_line(FND_FILE.LOG,'Index created successfully');
117:
118: commit;
119:
120: -- Bug 3196897: start:

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 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 140: fnd_file.put_line(FND_FILE.LOG,'An error occured with the following error message. '||

136:
137: exception
138: when OTHERS then
139: rollback;
140: fnd_file.put_line(FND_FILE.LOG,'An error occured with the following error message. '||
141: 'Please rerun the job after correcting the cause of error');
142: fnd_file.put_line(FND_FILE.LOG,SQLERRM(SQLCODE));
143:
144: END CREATE_INDEX;

Line 142: fnd_file.put_line(FND_FILE.LOG,SQLERRM(SQLCODE));

138: when OTHERS then
139: rollback;
140: fnd_file.put_line(FND_FILE.LOG,'An error occured with the following error message. '||
141: 'Please rerun the job after correcting the cause of error');
142: fnd_file.put_line(FND_FILE.LOG,SQLERRM(SQLCODE));
143:
144: END CREATE_INDEX;
145:
146:

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 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 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 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 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 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);