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

Line 123: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');

119: return;
120: END IF;
121:
122: l_table_name := 'BIM_R_LOCATIONS';
123: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
124: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
125: fnd_file.put_line(fnd_file.log,fnd_message.get);
126:
127: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' ||l_schema||'.BIM_R_LOCATIONS';

Line 124: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

120: END IF;
121:
122: l_table_name := 'BIM_R_LOCATIONS';
123: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
124: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
125: fnd_file.put_line(fnd_file.log,fnd_message.get);
126:
127: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' ||l_schema||'.BIM_R_LOCATIONS';
128:

Line 125: fnd_file.put_line(fnd_file.log,fnd_message.get);

121:
122: l_table_name := 'BIM_R_LOCATIONS';
123: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
124: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
125: fnd_file.put_line(fnd_file.log,fnd_message.get);
126:
127: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' ||l_schema||'.BIM_R_LOCATIONS';
128:
129: l_table_name := 'BIM_R_LOCATIONS';

Line 130: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

126:
127: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' ||l_schema||'.BIM_R_LOCATIONS';
128:
129: l_table_name := 'BIM_R_LOCATIONS';
130: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
131: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
132: fnd_file.put_line(fnd_file.log,fnd_message.get);
133:
134: /* The INSERT statement to populate BIM_R_LOCATIONS table begins here */

Line 131: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

127: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' ||l_schema||'.BIM_R_LOCATIONS';
128:
129: l_table_name := 'BIM_R_LOCATIONS';
130: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
131: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
132: fnd_file.put_line(fnd_file.log,fnd_message.get);
133:
134: /* The INSERT statement to populate BIM_R_LOCATIONS table begins here */
135:

Line 132: fnd_file.put_line(fnd_file.log,fnd_message.get);

128:
129: l_table_name := 'BIM_R_LOCATIONS';
130: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
131: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
132: fnd_file.put_line(fnd_file.log,fnd_message.get);
133:
134: /* The INSERT statement to populate BIM_R_LOCATIONS table begins here */
135:
136: INSERT

Line 149: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');

145: AND country_code is not null;
146:
147:
148: l_table_name := 'BIM_R_LOCATIONS';
149: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
150: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
151: fnd_file.put_line(fnd_file.log,fnd_message.get);
152:
153: -- Analyze the bim_r_locations table

Line 150: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

146:
147:
148: l_table_name := 'BIM_R_LOCATIONS';
149: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
150: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
151: fnd_file.put_line(fnd_file.log,fnd_message.get);
152:
153: -- Analyze the bim_r_locations table
154: DBMS_STATS.gather_table_stats('BIM','BIM_R_LOCATIONS', estimate_percent => 5,

Line 151: fnd_file.put_line(fnd_file.log,fnd_message.get);

147:
148: l_table_name := 'BIM_R_LOCATIONS';
149: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
150: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
151: fnd_file.put_line(fnd_file.log,fnd_message.get);
152:
153: -- Analyze the bim_r_locations table
154: DBMS_STATS.gather_table_stats('BIM','BIM_R_LOCATIONS', estimate_percent => 5,
155: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);

Line 163: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');

159: BIM_UTL_PKG.DROP_INDEX('BIM_R_SOURCE_CODES');
160:
161:
162: l_table_name := 'BIM_R_SOURCE_CODES';
163: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
164: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
165: fnd_file.put_line(fnd_file.log,fnd_message.get);
166:
167: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' ||l_schema||'.BIM_R_SOURCE_CODES';

Line 164: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

160:
161:
162: l_table_name := 'BIM_R_SOURCE_CODES';
163: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
164: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
165: fnd_file.put_line(fnd_file.log,fnd_message.get);
166:
167: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' ||l_schema||'.BIM_R_SOURCE_CODES';
168:

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

161:
162: l_table_name := 'BIM_R_SOURCE_CODES';
163: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
164: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
165: fnd_file.put_line(fnd_file.log,fnd_message.get);
166:
167: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' ||l_schema||'.BIM_R_SOURCE_CODES';
168:
169:

Line 171: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

167: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' ||l_schema||'.BIM_R_SOURCE_CODES';
168:
169:
170: l_table_name := 'BIM_R_SOURCE_CODES';
171: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
172: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
173: fnd_file.put_line(fnd_file.log,fnd_message.get);
174:
175: /* The INSERT statement to populate BIM_R_SOURCE_CODES table begins here */

Line 172: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

168:
169:
170: l_table_name := 'BIM_R_SOURCE_CODES';
171: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
172: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
173: fnd_file.put_line(fnd_file.log,fnd_message.get);
174:
175: /* The INSERT statement to populate BIM_R_SOURCE_CODES table begins here */
176:

Line 173: fnd_file.put_line(fnd_file.log,fnd_message.get);

169:
170: l_table_name := 'BIM_R_SOURCE_CODES';
171: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
172: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
173: fnd_file.put_line(fnd_file.log,fnd_message.get);
174:
175: /* The INSERT statement to populate BIM_R_SOURCE_CODES table begins here */
176:
177: INSERT /*+ append parallel(SRC,1) */

Line 314: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');

310:
311: --dbms_output.put_Line('JUST A F T E R THE MAIN INSERT STATMENT for bim_r_source_codes');
312:
313: l_table_name := 'BIM_R_SOURCE_CODES';
314: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
315: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
316: fnd_file.put_line(fnd_file.log,fnd_message.get);
317:
318: /* Analyze the bim_r_source_codes table */

Line 315: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

311: --dbms_output.put_Line('JUST A F T E R THE MAIN INSERT STATMENT for bim_r_source_codes');
312:
313: l_table_name := 'BIM_R_SOURCE_CODES';
314: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
315: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
316: fnd_file.put_line(fnd_file.log,fnd_message.get);
317:
318: /* Analyze the bim_r_source_codes table */
319: DBMS_STATS.gather_table_stats('BIM','BIM_R_SOURCE_CODES', estimate_percent => 5,

Line 316: fnd_file.put_line(fnd_file.log,fnd_message.get);

312:
313: l_table_name := 'BIM_R_SOURCE_CODES';
314: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
315: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
316: fnd_file.put_line(fnd_file.log,fnd_message.get);
317:
318: /* Analyze the bim_r_source_codes table */
319: DBMS_STATS.gather_table_stats('BIM','BIM_R_SOURCE_CODES', estimate_percent => 5,
320: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);

Line 325: fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');

321:
322: /* Recreating Indexes */
323: BIM_UTL_PKG.CREATE_INDEX('BIM_R_SOURCE_CODES');
324:
325: fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');
326: fnd_message.set_token('PROGRAM_NAME','Populating Source Codes',FALSE);
327: fnd_file.put_line(fnd_file.log,fnd_message.get);
328:
329:

Line 326: fnd_message.set_token('PROGRAM_NAME','Populating Source Codes',FALSE);

322: /* Recreating Indexes */
323: BIM_UTL_PKG.CREATE_INDEX('BIM_R_SOURCE_CODES');
324:
325: fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');
326: fnd_message.set_token('PROGRAM_NAME','Populating Source Codes',FALSE);
327: fnd_file.put_line(fnd_file.log,fnd_message.get);
328:
329:
330:

Line 327: fnd_file.put_line(fnd_file.log,fnd_message.get);

323: BIM_UTL_PKG.CREATE_INDEX('BIM_R_SOURCE_CODES');
324:
325: fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');
326: fnd_message.set_token('PROGRAM_NAME','Populating Source Codes',FALSE);
327: fnd_file.put_line(fnd_file.log,fnd_message.get);
328:
329:
330:
331: /* Standard call to get message count and if count is 1, get message info */