APPS.BIM_SOURCE_CODE_PKG dependencies on FND_FILE

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 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 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 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 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 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 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 */