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.GCS_CREATE_DYN_INDEX_PKG dependencies on FND_FILE

Line 44: fnd_file.put_line(fnd_file.log, 'Index to be dropped not found');

40: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.drop_index, body, index_name);
41:
42: EXCEPTION
43: WHEN NO_INDEX THEN
44: fnd_file.put_line(fnd_file.log, 'Index to be dropped not found');
45: WHEN OTHERS THEN
46: x_errbuf := substr( SQLERRM, 1, 2000);
47: x_retcode := '2';
48: END Drop_Index;

Line 75: fnd_file.put_line(fnd_file.log, 'Beginning of Generate EPB Index');

71:
72: BEGIN
73:
74: --Bugfix 5498824: Adding additional logging information
75: fnd_file.put_line(fnd_file.log, 'Beginning of Generate EPB Index');
76:
77: SELECT epb_table_name
78: INTO l_data_table
79: FROM gcs_system_options;

Line 86: fnd_file.put_line(fnd_file.log, 'Data will be written to table: ' || l_data_table);

82: INTO l_table_owner
83: FROM fnd_oracle_userid
84: WHERE oracle_id = 274;
85:
86: fnd_file.put_line(fnd_file.log, 'Data will be written to table: ' || l_data_table);
87:
88: --Bugfix 5498824: Remove the index initialization and search in data directionary
89: --l_index := l_data_table || '_U1';
90:

Line 101: fnd_file.put_line(fnd_file.log, 'Number of rows in data table: ' || rowcount);

97: AND column_property_code = 'PROCESSING_KEY';
98: */
99: EXECUTE IMMEDIATE 'select count(1) from ' || l_data_table INTO rowcount;
100:
101: fnd_file.put_line(fnd_file.log, 'Number of rows in data table: ' || rowcount);
102:
103: --Bugfix 5498824- No longer check if processing key has been setup. If there are no rows in the table always re-initialize
104: IF (rowcount = 0) THEN
105:

Line 135: fnd_file.put_line(fnd_file.log, 'Starting to Drop Indices');

131: FROM GCS_EPB_DIM_MAPS
132: WHERE enabled_flag = 'Y'
133: );
134:
135: fnd_file.put_line(fnd_file.log, 'Starting to Drop Indices');
136: --Bugfix 5499824: Using cursor to determine indices to drop
137: FOR v_indices in c_index_names(l_data_table,
138: l_table_owner) LOOP
139:

Line 140: fnd_file.put_line(fnd_file.log, 'Starting to drop index: ' || v_indices.index_name);

136: --Bugfix 5499824: Using cursor to determine indices to drop
137: FOR v_indices in c_index_names(l_data_table,
138: l_table_owner) LOOP
139:
140: fnd_file.put_line(fnd_file.log, 'Starting to drop index: ' || v_indices.index_name);
141:
142: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,
143: v_indices.owner,
144: ad_ddl.drop_index,

Line 148: fnd_file.put_line(fnd_file.log, 'Completed dropping of index');

144: ad_ddl.drop_index,
145: 'DROP INDEX ' || v_indices.index_name,
146: v_indices.index_name);
147:
148: fnd_file.put_line(fnd_file.log, 'Completed dropping of index');
149:
150: END LOOP;
151: fnd_file.put_line(fnd_file.log, 'Completed Dropping Indices');
152: -- generate the index

Line 151: fnd_file.put_line(fnd_file.log, 'Completed Dropping Indices');

147:
148: fnd_file.put_line(fnd_file.log, 'Completed dropping of index');
149:
150: END LOOP;
151: fnd_file.put_line(fnd_file.log, 'Completed Dropping Indices');
152: -- generate the index
153: body:= ' CREATE UNIQUE INDEX ' || l_data_table || '_P ON ' || l_data_table || ' ( ';
154: FOR active_dims IN epb_dims LOOP
155: body := body || active_dims.colname || ', ';

Line 162: fnd_file.put_line(fnd_file.log, '<<<<<<<<<>>>>>>>>>>>>>>>>>>>>');

158: body := substr(body, 1, len-2);
159: body:= body || ' )';
160: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, l_table_owner, ad_ddl.create_index, body, l_data_table || '_P');
161: ELSE
162: fnd_file.put_line(fnd_file.log, '<<<<<<<<<>>>>>>>>>>>>>>>>>>>>');
163: fnd_file.put_line(fnd_file.log, 'The indices and processing key on ' || l_data_table || ' were not regenerated since data already exists in the table.');
164: fnd_file.put_line(fnd_file.log, 'If you are ok with the analytical reporting setup, please ignore this warning. Otherwise, please undo the data in the tables');
165: fnd_file.put_line(fnd_file.log, 'and re-run Module Initialization.');
166: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>');

Line 163: fnd_file.put_line(fnd_file.log, 'The indices and processing key on ' || l_data_table || ' were not regenerated since data already exists in the table.');

159: body:= body || ' )';
160: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, l_table_owner, ad_ddl.create_index, body, l_data_table || '_P');
161: ELSE
162: fnd_file.put_line(fnd_file.log, '<<<<<<<<<>>>>>>>>>>>>>>>>>>>>');
163: fnd_file.put_line(fnd_file.log, 'The indices and processing key on ' || l_data_table || ' were not regenerated since data already exists in the table.');
164: fnd_file.put_line(fnd_file.log, 'If you are ok with the analytical reporting setup, please ignore this warning. Otherwise, please undo the data in the tables');
165: fnd_file.put_line(fnd_file.log, 'and re-run Module Initialization.');
166: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>');
167: RETURN 'WARNING';

Line 164: fnd_file.put_line(fnd_file.log, 'If you are ok with the analytical reporting setup, please ignore this warning. Otherwise, please undo the data in the tables');

160: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, l_table_owner, ad_ddl.create_index, body, l_data_table || '_P');
161: ELSE
162: fnd_file.put_line(fnd_file.log, '<<<<<<<<<>>>>>>>>>>>>>>>>>>>>');
163: fnd_file.put_line(fnd_file.log, 'The indices and processing key on ' || l_data_table || ' were not regenerated since data already exists in the table.');
164: fnd_file.put_line(fnd_file.log, 'If you are ok with the analytical reporting setup, please ignore this warning. Otherwise, please undo the data in the tables');
165: fnd_file.put_line(fnd_file.log, 'and re-run Module Initialization.');
166: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>');
167: RETURN 'WARNING';
168: END IF;

Line 165: fnd_file.put_line(fnd_file.log, 'and re-run Module Initialization.');

161: ELSE
162: fnd_file.put_line(fnd_file.log, '<<<<<<<<<>>>>>>>>>>>>>>>>>>>>');
163: fnd_file.put_line(fnd_file.log, 'The indices and processing key on ' || l_data_table || ' were not regenerated since data already exists in the table.');
164: fnd_file.put_line(fnd_file.log, 'If you are ok with the analytical reporting setup, please ignore this warning. Otherwise, please undo the data in the tables');
165: fnd_file.put_line(fnd_file.log, 'and re-run Module Initialization.');
166: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>');
167: RETURN 'WARNING';
168: END IF;
169:

Line 166: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>');

162: fnd_file.put_line(fnd_file.log, '<<<<<<<<<>>>>>>>>>>>>>>>>>>>>');
163: fnd_file.put_line(fnd_file.log, 'The indices and processing key on ' || l_data_table || ' were not regenerated since data already exists in the table.');
164: fnd_file.put_line(fnd_file.log, 'If you are ok with the analytical reporting setup, please ignore this warning. Otherwise, please undo the data in the tables');
165: fnd_file.put_line(fnd_file.log, 'and re-run Module Initialization.');
166: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>');
167: RETURN 'WARNING';
168: END IF;
169:
170: RETURN 'SUCCESS';

Line 174: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>');

170: RETURN 'SUCCESS';
171:
172: EXCEPTION
173: WHEN OTHERS THEN
174: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>');
175: fnd_file.put_line(fnd_file.log, SQLERRM);
176: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>');
177: RETURN 'WARNING';
178: END;

Line 175: fnd_file.put_line(fnd_file.log, SQLERRM);

171:
172: EXCEPTION
173: WHEN OTHERS THEN
174: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>');
175: fnd_file.put_line(fnd_file.log, SQLERRM);
176: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>');
177: RETURN 'WARNING';
178: END;
179:

Line 176: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>');

172: EXCEPTION
173: WHEN OTHERS THEN
174: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>');
175: fnd_file.put_line(fnd_file.log, SQLERRM);
176: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>');
177: RETURN 'WARNING';
178: END;
179:
180: PROCEDURE Create_Index( x_errbuf OUT NOCOPY VARCHAR2,

Line 201: fnd_file.put_line(fnd_file.log, 'Starting to Drop Indices');

197: -- Bugfix 5498824: Status of EPB Code Generation
198: l_status_code VARCHAR2(30);
199: BEGIN
200:
201: fnd_file.put_line(fnd_file.log, 'Starting to Drop Indices');
202: -- Drop indexes before we recreate them
203: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_INTERCO_ELM_TRX_U1');
204: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_HISTORICAL_RATES_U1');
205: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_TRANSLATION_GT_U1');

Line 210: fnd_file.put_line(fnd_file.log, 'Completed Dropping Indices');

206: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_ENTRY_LINES_U1');
207: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_AD_TRIAL_BALANCES_U1');
208: -- Bugfix 4281391 : Added dropping of index GCS_BAL_INTERFACE_T_U1
209: GCS_CREATE_DYN_INDEX_PKG.Drop_Index(x_errbuf, x_retcode, 'GCS_BAL_INTERFACE_T_U1');
210: fnd_file.put_line(fnd_file.log, 'Completed Dropping Indices');
211:
212: index_list := rtrim(GCS_DYNAMIC_UTIL_PKG.index_col_list(collist), ', ');
213: IF index_list IS NOT NULL THEN
214: index_list := ', ' || index_list;

Line 217: fnd_file.put_line(fnd_file.log, 'Starting to Create Indices');

213: IF index_list IS NOT NULL THEN
214: index_list := ', ' || index_list;
215: END IF;
216:
217: fnd_file.put_line(fnd_file.log, 'Starting to Create Indices');
218: fnd_file.put_line(fnd_file.log, 'Generating GCS_INTERCO_ELM_TRX_U1');
219: -- Recreate the indices
220: body:= ' CREATE UNIQUE INDEX GCS_INTERCO_ELM_TRX_U1 ON GCS_INTERCO_ELM_TRX (hierarchy_id, src_entity_id, target_entity_id,';
221: body:= body || 'cal_period_id, company_cost_center_org_id, intercompany_id, line_item_id';

Line 218: fnd_file.put_line(fnd_file.log, 'Generating GCS_INTERCO_ELM_TRX_U1');

214: index_list := ', ' || index_list;
215: END IF;
216:
217: fnd_file.put_line(fnd_file.log, 'Starting to Create Indices');
218: fnd_file.put_line(fnd_file.log, 'Generating GCS_INTERCO_ELM_TRX_U1');
219: -- Recreate the indices
220: body:= ' CREATE UNIQUE INDEX GCS_INTERCO_ELM_TRX_U1 ON GCS_INTERCO_ELM_TRX (hierarchy_id, src_entity_id, target_entity_id,';
221: body:= body || 'cal_period_id, company_cost_center_org_id, intercompany_id, line_item_id';
222: body := body || index_list || ')';

Line 225: fnd_file.put_line(fnd_file.log, 'Generating GCS_HISTORICAL_RATES_U1');

221: body:= body || 'cal_period_id, company_cost_center_org_id, intercompany_id, line_item_id';
222: body := body || index_list || ')';
223: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.create_index, body, 'GCS_INTERCO_ELM_TRX_U1');
224:
225: fnd_file.put_line(fnd_file.log, 'Generating GCS_HISTORICAL_RATES_U1');
226: body:= ' CREATE UNIQUE INDEX GCS_HISTORICAL_RATES_U1 ON GCS_HISTORICAL_RATES (hierarchy_id, entity_id, from_currency, to_currency, update_flag, ';
227: body:= body || 'cal_period_id, company_cost_center_org_id, intercompany_id, line_item_id';
228: body := body || index_list || ')';
229: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.create_index, body, 'GCS_HISTORICAL_RATES_U1');

Line 231: fnd_file.put_line(fnd_file.log, 'Generating GCS_TRANSLATION_GT_U1');

227: body:= body || 'cal_period_id, company_cost_center_org_id, intercompany_id, line_item_id';
228: body := body || index_list || ')';
229: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.create_index, body, 'GCS_HISTORICAL_RATES_U1');
230:
231: fnd_file.put_line(fnd_file.log, 'Generating GCS_TRANSLATION_GT_U1');
232: body:= ' CREATE UNIQUE INDEX GCS_TRANSLATION_GT_U1 ON GCS_TRANSLATION_GT (';
233: body:= body || 'company_cost_center_org_id, intercompany_id, line_item_id';
234: body := body || index_list || ')';
235: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.create_index, body, 'GCS_TRANSLATION_GT_U1');

Line 237: fnd_file.put_line(fnd_file.log, 'Generating GCS_ENTRY_LINES_U1');

233: body:= body || 'company_cost_center_org_id, intercompany_id, line_item_id';
234: body := body || index_list || ')';
235: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.create_index, body, 'GCS_TRANSLATION_GT_U1');
236:
237: fnd_file.put_line(fnd_file.log, 'Generating GCS_ENTRY_LINES_U1');
238: body:= ' CREATE UNIQUE INDEX GCS_ENTRY_LINES_U1 ON GCS_ENTRY_LINES (entry_id, ';
239: body:= body || 'company_cost_center_org_id, intercompany_id, line_item_id';
240: --Bugfix 5532657: Added entry_line_number to the unique index
241: body := body || index_list || ', entry_line_number)';

Line 244: fnd_file.put_line(fnd_file.log, 'Generating GCS_AD_TRIAL_BALANCES_U1');

240: --Bugfix 5532657: Added entry_line_number to the unique index
241: body := body || index_list || ', entry_line_number)';
242: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.create_index, body, 'GCS_ENTRY_LINES_U1');
243:
244: fnd_file.put_line(fnd_file.log, 'Generating GCS_AD_TRIAL_BALANCES_U1');
245: body:= ' CREATE UNIQUE INDEX GCS_AD_TRIAL_BALANCES_U1 ON GCS_AD_TRIAL_BALANCES (ad_transaction_id, trial_balance_seq, ';
246: body:= body || 'company_cost_center_org_id, intercompany_id, line_item_id';
247: body := body || index_list || ')';
248: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.create_index, body, 'GCS_AD_TRIAL_BALANCES_U1');

Line 250: fnd_file.put_line(fnd_file.log, 'Generating GCS_BAL_INTERFACE_T_U1');

246: body:= body || 'company_cost_center_org_id, intercompany_id, line_item_id';
247: body := body || index_list || ')';
248: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.create_index, body, 'GCS_AD_TRIAL_BALANCES_U1');
249:
250: fnd_file.put_line(fnd_file.log, 'Generating GCS_BAL_INTERFACE_T_U1');
251: Generate_Data_Sub_Index(collist);
252: body := ' CREATE UNIQUE INDEX GCS_BAL_INTERFACE_T_U1 ON GCS_BAL_INTERFACE_T ( ' || collist || ') ';
253: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.create_index, body, 'GCS_BAL_INTERFACE_T_U1');
254:

Line 255: fnd_file.put_line(fnd_file.log, 'Completed Creation of Indices');

251: Generate_Data_Sub_Index(collist);
252: body := ' CREATE UNIQUE INDEX GCS_BAL_INTERFACE_T_U1 ON GCS_BAL_INTERFACE_T ( ' || collist || ') ';
253: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.create_index, body, 'GCS_BAL_INTERFACE_T_U1');
254:
255: fnd_file.put_line(fnd_file.log, 'Completed Creation of Indices');
256:
257: fnd_file.put_line(fnd_file.log, 'Starting to Generate PL/SQL Packages');
258:
259: -- Check if system options is set

Line 257: fnd_file.put_line(fnd_file.log, 'Starting to Generate PL/SQL Packages');

253: ad_ddl.do_ddl(GCS_DYNAMIC_UTIL_PKG.g_applsys_username, 'GCS', ad_ddl.create_index, body, 'GCS_BAL_INTERFACE_T_U1');
254:
255: fnd_file.put_line(fnd_file.log, 'Completed Creation of Indices');
256:
257: fnd_file.put_line(fnd_file.log, 'Starting to Generate PL/SQL Packages');
258:
259: -- Check if system options is set
260: SELECT nvl(fch_global_vs_combo_id, -1)
261: INTO l_sys_option

Line 265: fnd_file.put_line(fnd_file.log, 'Generating Dimension Transfer');

261: INTO l_sys_option
262: FROM gcs_system_options;
263:
264: IF l_sys_option <> -1 THEN
265: fnd_file.put_line(fnd_file.log, 'Generating Dimension Transfer');
266: GCS_BUILD_EPB_DIM_TR_PKG.build_epb_dimtr_pkg;
267: END IF;
268:
269: --Bugfix 5498824: Removing the reference to ln_item_hierarchy_obj_id

Line 275: fnd_file.put_line(fnd_file.log, 'Generating EPB/FCH Data Transfer');

271: INTO l_epb_table
272: FROM gcs_system_options;
273:
274: IF ( l_epb_table <> 'INVALID' ) THEN
275: fnd_file.put_line(fnd_file.log, 'Generating EPB/FCH Data Transfer');
276: GCS_BUILD_EPB_DATA_TR_PKG.build_epb_datatr_pkg;
277: fnd_file.put_line(fnd_file.log, 'Generating Index and Processing key for data table');
278: l_status_code := generate_epb_index;
279: ELSE

Line 277: fnd_file.put_line(fnd_file.log, 'Generating Index and Processing key for data table');

273:
274: IF ( l_epb_table <> 'INVALID' ) THEN
275: fnd_file.put_line(fnd_file.log, 'Generating EPB/FCH Data Transfer');
276: GCS_BUILD_EPB_DATA_TR_PKG.build_epb_datatr_pkg;
277: fnd_file.put_line(fnd_file.log, 'Generating Index and Processing key for data table');
278: l_status_code := generate_epb_index;
279: ELSE
280: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>');
281: fnd_file.put_line(fnd_file.log, 'Please make sure you complete the analytical reporting step in Foundation prior to running Consolidation');

Line 280: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>');

276: GCS_BUILD_EPB_DATA_TR_PKG.build_epb_datatr_pkg;
277: fnd_file.put_line(fnd_file.log, 'Generating Index and Processing key for data table');
278: l_status_code := generate_epb_index;
279: ELSE
280: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>');
281: fnd_file.put_line(fnd_file.log, 'Please make sure you complete the analytical reporting step in Foundation prior to running Consolidation');
282: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>');
283: l_status_code := 'WARNING';
284: END IF;

Line 281: fnd_file.put_line(fnd_file.log, 'Please make sure you complete the analytical reporting step in Foundation prior to running Consolidation');

277: fnd_file.put_line(fnd_file.log, 'Generating Index and Processing key for data table');
278: l_status_code := generate_epb_index;
279: ELSE
280: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>');
281: fnd_file.put_line(fnd_file.log, 'Please make sure you complete the analytical reporting step in Foundation prior to running Consolidation');
282: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>');
283: l_status_code := 'WARNING';
284: END IF;
285:

Line 282: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>');

278: l_status_code := generate_epb_index;
279: ELSE
280: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>');
281: fnd_file.put_line(fnd_file.log, 'Please make sure you complete the analytical reporting step in Foundation prior to running Consolidation');
282: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>');
283: l_status_code := 'WARNING';
284: END IF;
285:
286: fnd_file.put_line(fnd_file.log, 'Generating Aggregation');

Line 286: fnd_file.put_line(fnd_file.log, 'Generating Aggregation');

282: fnd_file.put_line(fnd_file.log, '<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>');
283: l_status_code := 'WARNING';
284: END IF;
285:
286: fnd_file.put_line(fnd_file.log, 'Generating Aggregation');
287: GCS_AGGREGATION_DYN_BUILD_PKG.create_package;
288:
289: fnd_file.put_line(fnd_file.log, 'Generating Data Preparation');
290: GCS_DATA_PREP_PKG.create_process(x_errbuf, x_retcode);

Line 289: fnd_file.put_line(fnd_file.log, 'Generating Data Preparation');

285:
286: fnd_file.put_line(fnd_file.log, 'Generating Aggregation');
287: GCS_AGGREGATION_DYN_BUILD_PKG.create_package;
288:
289: fnd_file.put_line(fnd_file.log, 'Generating Data Preparation');
290: GCS_DATA_PREP_PKG.create_process(x_errbuf, x_retcode);
291:
292: fnd_file.put_line(fnd_file.log, 'Generating Balances Processor');
293: GCS_BUILD_FEM_POSTING_PKG.create_package;

Line 292: fnd_file.put_line(fnd_file.log, 'Generating Balances Processor');

288:
289: fnd_file.put_line(fnd_file.log, 'Generating Data Preparation');
290: GCS_DATA_PREP_PKG.create_process(x_errbuf, x_retcode);
291:
292: fnd_file.put_line(fnd_file.log, 'Generating Balances Processor');
293: GCS_BUILD_FEM_POSTING_PKG.create_package;
294:
295: fnd_file.put_line(fnd_file.log, 'Generating Intercompany');
296: GCS_INTERCO_DYN_BUILD_PKG.Interco_Create_Package(x_errbuf, x_retcode);

Line 295: fnd_file.put_line(fnd_file.log, 'Generating Intercompany');

291:
292: fnd_file.put_line(fnd_file.log, 'Generating Balances Processor');
293: GCS_BUILD_FEM_POSTING_PKG.create_package;
294:
295: fnd_file.put_line(fnd_file.log, 'Generating Intercompany');
296: GCS_INTERCO_DYN_BUILD_PKG.Interco_Create_Package(x_errbuf, x_retcode);
297:
298: fnd_file.put_line(fnd_file.log, 'Generating Period Initialization');
299: GCS_PERIOD_INIT_DYN_BUILD_PKG.create_package;

Line 298: fnd_file.put_line(fnd_file.log, 'Generating Period Initialization');

294:
295: fnd_file.put_line(fnd_file.log, 'Generating Intercompany');
296: GCS_INTERCO_DYN_BUILD_PKG.Interco_Create_Package(x_errbuf, x_retcode);
297:
298: fnd_file.put_line(fnd_file.log, 'Generating Period Initialization');
299: GCS_PERIOD_INIT_DYN_BUILD_PKG.create_package;
300:
301: fnd_file.put_line(fnd_file.log, 'Generating Balancing Routine');
302: GCS_TEMPLATES_PKG.create_dynamic_pkg(x_errbuf, x_retcode);

Line 301: fnd_file.put_line(fnd_file.log, 'Generating Balancing Routine');

297:
298: fnd_file.put_line(fnd_file.log, 'Generating Period Initialization');
299: GCS_PERIOD_INIT_DYN_BUILD_PKG.create_package;
300:
301: fnd_file.put_line(fnd_file.log, 'Generating Balancing Routine');
302: GCS_TEMPLATES_PKG.create_dynamic_pkg(x_errbuf, x_retcode);
303:
304: -- Bugfix 5707630: Start
305: fnd_file.put_line(fnd_file.log, 'Generating Translation');

Line 305: fnd_file.put_line(fnd_file.log, 'Generating Translation');

301: fnd_file.put_line(fnd_file.log, 'Generating Balancing Routine');
302: GCS_TEMPLATES_PKG.create_dynamic_pkg(x_errbuf, x_retcode);
303:
304: -- Bugfix 5707630: Start
305: fnd_file.put_line(fnd_file.log, 'Generating Translation');
306: GCS_TRANS_HRATES_DYN_BUILD_PKG.create_package(x_errbuf, x_retcode);
307:
308: fnd_file.put_line(fnd_file.log, 'Generating Translation for Historical Rates');
309: GCS_TRANS_RE_DYN_BUILD_PKG.create_package(x_errbuf, x_retcode);

Line 308: fnd_file.put_line(fnd_file.log, 'Generating Translation for Historical Rates');

304: -- Bugfix 5707630: Start
305: fnd_file.put_line(fnd_file.log, 'Generating Translation');
306: GCS_TRANS_HRATES_DYN_BUILD_PKG.create_package(x_errbuf, x_retcode);
307:
308: fnd_file.put_line(fnd_file.log, 'Generating Translation for Historical Rates');
309: GCS_TRANS_RE_DYN_BUILD_PKG.create_package(x_errbuf, x_retcode);
310: -- Bugfix 5707630: End
311:
312: fnd_file.put_line(fnd_file.log, 'Generating Translation for Retained Earnings');

Line 312: fnd_file.put_line(fnd_file.log, 'Generating Translation for Retained Earnings');

308: fnd_file.put_line(fnd_file.log, 'Generating Translation for Historical Rates');
309: GCS_TRANS_RE_DYN_BUILD_PKG.create_package(x_errbuf, x_retcode);
310: -- Bugfix 5707630: End
311:
312: fnd_file.put_line(fnd_file.log, 'Generating Translation for Retained Earnings');
313: GCS_TRANS_DYN_BUILD_PKG.create_package(x_errbuf, x_retcode);
314:
315: fnd_file.put_line(fnd_file.log, 'Generating Data Submission');
316: GCS_DATASUB_DYNAMIC_PKG.create_datasub_utility_pkg(x_errbuf, x_retcode);

Line 315: fnd_file.put_line(fnd_file.log, 'Generating Data Submission');

311:
312: fnd_file.put_line(fnd_file.log, 'Generating Translation for Retained Earnings');
313: GCS_TRANS_DYN_BUILD_PKG.create_package(x_errbuf, x_retcode);
314:
315: fnd_file.put_line(fnd_file.log, 'Generating Data Submission');
316: GCS_DATASUB_DYNAMIC_PKG.create_datasub_utility_pkg(x_errbuf, x_retcode);
317:
318: fnd_file.put_line(fnd_file.log, 'Generating XML Generation Package');
319: GCS_XML_DYNAMIC_PKG.create_xml_utility_pkg(x_errbuf, x_retcode);

Line 318: fnd_file.put_line(fnd_file.log, 'Generating XML Generation Package');

314:
315: fnd_file.put_line(fnd_file.log, 'Generating Data Submission');
316: GCS_DATASUB_DYNAMIC_PKG.create_datasub_utility_pkg(x_errbuf, x_retcode);
317:
318: fnd_file.put_line(fnd_file.log, 'Generating XML Generation Package');
319: GCS_XML_DYNAMIC_PKG.create_xml_utility_pkg(x_errbuf, x_retcode);
320:
321: fnd_file.put_line(fnd_file.log, 'Manipulating XML Publisher Data Templates');
322: GCS_DATA_TEMPLATE_UTIL_PKG.gcs_replace_dt_proc(x_errbuf, x_retcode);

Line 321: fnd_file.put_line(fnd_file.log, 'Manipulating XML Publisher Data Templates');

317:
318: fnd_file.put_line(fnd_file.log, 'Generating XML Generation Package');
319: GCS_XML_DYNAMIC_PKG.create_xml_utility_pkg(x_errbuf, x_retcode);
320:
321: fnd_file.put_line(fnd_file.log, 'Manipulating XML Publisher Data Templates');
322: GCS_DATA_TEMPLATE_UTIL_PKG.gcs_replace_dt_proc(x_errbuf, x_retcode);
323:
324: fnd_file.put_line(fnd_file.log, 'Generating Web-ADI');
325: retwebadi := GCS_WEBADI_PKG.execute_event(NULL, event);

Line 324: fnd_file.put_line(fnd_file.log, 'Generating Web-ADI');

320:
321: fnd_file.put_line(fnd_file.log, 'Manipulating XML Publisher Data Templates');
322: GCS_DATA_TEMPLATE_UTIL_PKG.gcs_replace_dt_proc(x_errbuf, x_retcode);
323:
324: fnd_file.put_line(fnd_file.log, 'Generating Web-ADI');
325: retwebadi := GCS_WEBADI_PKG.execute_event(NULL, event);
326:
327: --Bugfix 5190565: Calling Rules Processor Utility to Inser Data
328: fnd_file.put_line(fnd_file.log, 'Generating Rules Process Utility');

Line 328: fnd_file.put_line(fnd_file.log, 'Generating Rules Process Utility');

324: fnd_file.put_line(fnd_file.log, 'Generating Web-ADI');
325: retwebadi := GCS_WEBADI_PKG.execute_event(NULL, event);
326:
327: --Bugfix 5190565: Calling Rules Processor Utility to Inser Data
328: fnd_file.put_line(fnd_file.log, 'Generating Rules Process Utility');
329: gcs_rp_util_build_pkg.create_rp_utility_pkg( p_errbuf => x_errbuf , p_retcode => x_retcode);
330:
331: fnd_file.put_line(fnd_file.log, 'Completed Generation of PL/SQL Packages');
332:

Line 331: fnd_file.put_line(fnd_file.log, 'Completed Generation of PL/SQL Packages');

327: --Bugfix 5190565: Calling Rules Processor Utility to Inser Data
328: fnd_file.put_line(fnd_file.log, 'Generating Rules Process Utility');
329: gcs_rp_util_build_pkg.create_rp_utility_pkg( p_errbuf => x_errbuf , p_retcode => x_retcode);
330:
331: fnd_file.put_line(fnd_file.log, 'Completed Generation of PL/SQL Packages');
332:
333:
334: fnd_file.put_line(fnd_file.log, 'Generating Data Submission Trial Balance View');
335: GCS_DYN_TB_VIEW_PKG.create_view(x_errbuf, x_retcode);

Line 334: fnd_file.put_line(fnd_file.log, 'Generating Data Submission Trial Balance View');

330:
331: fnd_file.put_line(fnd_file.log, 'Completed Generation of PL/SQL Packages');
332:
333:
334: fnd_file.put_line(fnd_file.log, 'Generating Data Submission Trial Balance View');
335: GCS_DYN_TB_VIEW_PKG.create_view(x_errbuf, x_retcode);
336: fnd_file.put_line(fnd_file.log, 'Completed Generation of Views');
337:
338:

Line 336: fnd_file.put_line(fnd_file.log, 'Completed Generation of Views');

332:
333:
334: fnd_file.put_line(fnd_file.log, 'Generating Data Submission Trial Balance View');
335: GCS_DYN_TB_VIEW_PKG.create_view(x_errbuf, x_retcode);
336: fnd_file.put_line(fnd_file.log, 'Completed Generation of Views');
337:
338:
339: x_retcode := '0';
340:

Line 353: fnd_file.put_line(fnd_file.log, 'Fatal Error Occurred : ' || SQLERRM);

349: EXCEPTION
350: WHEN OTHERS THEN
351: x_errbuf := substr( SQLERRM, 1, 2000);
352: x_retcode := '2';
353: fnd_file.put_line(fnd_file.log, 'Fatal Error Occurred : ' || SQLERRM);
354: l_ret_status := fnd_concurrent.set_completion_status(
355: status => 'ERROR',
356: message => NULL);
357: