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 30: fnd_file.put_line(FND_FILE.LOG,'Index dropped for refresh');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

99: fnd_file.put_line(FND_FILE.LOG,'Created section: '||l_section_name);
100: end loop;
101: close c1;
102:
103: fnd_file.put_line(FND_FILE.LOG,'Sections created for indexed xml elements');
104:
105: l_str:= 'create index edr_psig_textindex on edr_psig_documents(psig_xml) '||
106: 'indextype is ctxsys.context parameters '||
107: '(''LEXER edrlex FILTER ctxsys.null_filter SECTION GROUP edr_section_group'')';

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

106: 'indextype is ctxsys.context parameters '||
107: '(''LEXER edrlex FILTER ctxsys.null_filter SECTION GROUP edr_section_group'')';
108:
109: execute immediate l_str;
110: fnd_file.put_line(FND_FILE.LOG,'Index created successfully');
111:
112: commit;
113:
114: -- Bug 3196897: start:

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

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

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

123: commit; -- need commit for the profile to take immediate effect
124: ELSE
125: fnd_message.set_name( 'EDR', 'EDR_GENERAL_UPDATE_FAIL' );
126: fnd_message.set_token( 'OBJECT_NAME', G_PROFILE_SYNC_TIME );
127: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
128: END IF;
129: -- Bug 3196897: end:
130:
131: exception

Line 134: fnd_file.put_line(FND_FILE.LOG,'An error occured with the following error message. '||

130:
131: exception
132: when OTHERS then
133: rollback;
134: fnd_file.put_line(FND_FILE.LOG,'An error occured with the following error message. '||
135: 'Please rerun the job after correcting the cause of error');
136: fnd_file.put_line(FND_FILE.LOG,SQLERRM(SQLCODE));
137:
138: END CREATE_INDEX;

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

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

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

153: BEGIN
154:
155: fnd_message.set_name('EDR', 'EDR_PLS_IXE_SYNC_START');
156: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');
157: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
158:
159: ctx_ddl.sync_index ( 'EDR_PSIG_TEXTINDEX' );
160:
161: -- Bug 3196897: start:

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

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

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

170: commit; -- need commit to take immediate effect
171: ELSE
172: fnd_message.set_name( 'EDR', 'EDR_GENERAL_UPDATE_FAIL' );
173: fnd_message.set_token( 'OBJECT_NAME', G_PROFILE_SYNC_TIME );
174: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
175: END IF;
176: -- Bug 3196897: end:
177:
178: EXCEPTION

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

212: END IF;
213: fnd_message.set_name('EDR', 'EDR_PLS_IXE_OPTIM_LEVEL');
214: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');
215: fnd_message.set_token('IXE_OPT_LEVEL', l_opt_level );
216: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
217:
218: -- check the valid parameter for the time spent in each running of optimization
219: IF p_duration is null THEN
220: l_maxtime := ctx_ddl.maxtime_unlimited;

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

241: IF l_maxtime is not null THEN
242: fnd_message.set_name('EDR', 'EDR_PLS_IXE_OPTIM_TIME');
243: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');
244: fnd_message.set_token('IXE_OPT_TIME', l_maxtime );
245: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
246: END IF;
247:
248: ctx_ddl.optimize_index( 'EDR_PSIG_TEXTINDEX', l_opt_level, l_maxtime );
249: fnd_message.set_name('EDR', 'EDR_PLS_IXE_OPTIM_END');

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

247:
248: ctx_ddl.optimize_index( 'EDR_PSIG_TEXTINDEX', l_opt_level, l_maxtime );
249: fnd_message.set_name('EDR', 'EDR_PLS_IXE_OPTIM_END');
250: fnd_message.set_token('XML_INDEX', 'EDR_PSIG_TEXTINDEX');
251: fnd_file.put_line( FND_FILE.LOG, fnd_message.get );
252:
253: EXCEPTION
254: when others then
255: errbuf := substr(sqlerrm, 1, 240);