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

Line 137: fnd_file.put_line(fnd_file.log,l_err_msg);

133: fnd_message.set_token('ORGCODE', l_organization_code);
134: l_err_msg := FND_MESSAGE.Get;
135: l_err_msg := substrb('CSTPPCIC : ' || l_err_msg,1,240);
136: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
137: fnd_file.put_line(fnd_file.log,l_err_msg);
138: RETURN;
139: END IF;
140:
141: EXCEPTION

Line 173: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Global Variables... ');

169: l_user_id := FND_GLOBAL.user_id;
170: l_program_id := FND_GLOBAL.conc_program_id;
171: l_login_id := FND_GLOBAL.conc_login_id;
172:
173: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Global Variables... ');
174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'request_id... '||to_char(l_request_id));
175: FND_FILE.PUT_LINE(FND_FILE.LOG, 'prog_appl_id... '||to_char(l_prog_appl_id));
176: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id... '||to_char(l_user_id));
177: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id... '||to_char(l_program_id));

Line 174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'request_id... '||to_char(l_request_id));

170: l_program_id := FND_GLOBAL.conc_program_id;
171: l_login_id := FND_GLOBAL.conc_login_id;
172:
173: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Global Variables... ');
174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'request_id... '||to_char(l_request_id));
175: FND_FILE.PUT_LINE(FND_FILE.LOG, 'prog_appl_id... '||to_char(l_prog_appl_id));
176: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id... '||to_char(l_user_id));
177: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id... '||to_char(l_program_id));
178: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id... '||to_char(l_login_id));

Line 175: FND_FILE.PUT_LINE(FND_FILE.LOG, 'prog_appl_id... '||to_char(l_prog_appl_id));

171: l_login_id := FND_GLOBAL.conc_login_id;
172:
173: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Global Variables... ');
174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'request_id... '||to_char(l_request_id));
175: FND_FILE.PUT_LINE(FND_FILE.LOG, 'prog_appl_id... '||to_char(l_prog_appl_id));
176: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id... '||to_char(l_user_id));
177: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id... '||to_char(l_program_id));
178: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id... '||to_char(l_login_id));
179:

Line 176: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id... '||to_char(l_user_id));

172:
173: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Global Variables... ');
174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'request_id... '||to_char(l_request_id));
175: FND_FILE.PUT_LINE(FND_FILE.LOG, 'prog_appl_id... '||to_char(l_prog_appl_id));
176: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id... '||to_char(l_user_id));
177: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id... '||to_char(l_program_id));
178: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id... '||to_char(l_login_id));
179:
180: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Arguments... ');

Line 177: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id... '||to_char(l_program_id));

173: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Global Variables... ');
174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'request_id... '||to_char(l_request_id));
175: FND_FILE.PUT_LINE(FND_FILE.LOG, 'prog_appl_id... '||to_char(l_prog_appl_id));
176: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id... '||to_char(l_user_id));
177: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id... '||to_char(l_program_id));
178: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id... '||to_char(l_login_id));
179:
180: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Arguments... ');
181: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity: '|| TO_CHAR(p_legal_entity));

Line 178: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id... '||to_char(l_login_id));

174: FND_FILE.PUT_LINE(FND_FILE.LOG, 'request_id... '||to_char(l_request_id));
175: FND_FILE.PUT_LINE(FND_FILE.LOG, 'prog_appl_id... '||to_char(l_prog_appl_id));
176: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id... '||to_char(l_user_id));
177: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id... '||to_char(l_program_id));
178: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id... '||to_char(l_login_id));
179:
180: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Arguments... ');
181: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity: '|| TO_CHAR(p_legal_entity));
182: FND_FILE.PUT_LINE(FND_FILE.LOG, 'From Cost Type: '

Line 180: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Arguments... ');

176: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id... '||to_char(l_user_id));
177: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id... '||to_char(l_program_id));
178: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id... '||to_char(l_login_id));
179:
180: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Arguments... ');
181: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity: '|| TO_CHAR(p_legal_entity));
182: FND_FILE.PUT_LINE(FND_FILE.LOG, 'From Cost Type: '
183: || TO_CHAR(p_from_cost_type_id));
184: FND_FILE.PUT_LINE(FND_FILE.LOG, 'From Cost Group: '

Line 181: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity: '|| TO_CHAR(p_legal_entity));

177: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id... '||to_char(l_program_id));
178: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id... '||to_char(l_login_id));
179:
180: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Arguments... ');
181: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity: '|| TO_CHAR(p_legal_entity));
182: FND_FILE.PUT_LINE(FND_FILE.LOG, 'From Cost Type: '
183: || TO_CHAR(p_from_cost_type_id));
184: FND_FILE.PUT_LINE(FND_FILE.LOG, 'From Cost Group: '
185: || TO_CHAR(p_from_cost_group_id));

Line 182: FND_FILE.PUT_LINE(FND_FILE.LOG, 'From Cost Type: '

178: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id... '||to_char(l_login_id));
179:
180: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Arguments... ');
181: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity: '|| TO_CHAR(p_legal_entity));
182: FND_FILE.PUT_LINE(FND_FILE.LOG, 'From Cost Type: '
183: || TO_CHAR(p_from_cost_type_id));
184: FND_FILE.PUT_LINE(FND_FILE.LOG, 'From Cost Group: '
185: || TO_CHAR(p_from_cost_group_id));
186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Period: ' || TO_CHAR(p_period_id));

Line 184: FND_FILE.PUT_LINE(FND_FILE.LOG, 'From Cost Group: '

180: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Arguments... ');
181: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Legal Entity: '|| TO_CHAR(p_legal_entity));
182: FND_FILE.PUT_LINE(FND_FILE.LOG, 'From Cost Type: '
183: || TO_CHAR(p_from_cost_type_id));
184: FND_FILE.PUT_LINE(FND_FILE.LOG, 'From Cost Group: '
185: || TO_CHAR(p_from_cost_group_id));
186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Period: ' || TO_CHAR(p_period_id));
187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'To Organization: ' || TO_CHAR(p_to_org_id));
188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'To Cost Type: '

Line 186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Period: ' || TO_CHAR(p_period_id));

182: FND_FILE.PUT_LINE(FND_FILE.LOG, 'From Cost Type: '
183: || TO_CHAR(p_from_cost_type_id));
184: FND_FILE.PUT_LINE(FND_FILE.LOG, 'From Cost Group: '
185: || TO_CHAR(p_from_cost_group_id));
186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Period: ' || TO_CHAR(p_period_id));
187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'To Organization: ' || TO_CHAR(p_to_org_id));
188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'To Cost Type: '
189: || TO_CHAR(p_to_cost_type_id));
190: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Material Subelement: '

Line 187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'To Organization: ' || TO_CHAR(p_to_org_id));

183: || TO_CHAR(p_from_cost_type_id));
184: FND_FILE.PUT_LINE(FND_FILE.LOG, 'From Cost Group: '
185: || TO_CHAR(p_from_cost_group_id));
186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Period: ' || TO_CHAR(p_period_id));
187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'To Organization: ' || TO_CHAR(p_to_org_id));
188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'To Cost Type: '
189: || TO_CHAR(p_to_cost_type_id));
190: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Material Subelement: '
191: || TO_CHAR(p_material));

Line 188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'To Cost Type: '

184: FND_FILE.PUT_LINE(FND_FILE.LOG, 'From Cost Group: '
185: || TO_CHAR(p_from_cost_group_id));
186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Period: ' || TO_CHAR(p_period_id));
187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'To Organization: ' || TO_CHAR(p_to_org_id));
188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'To Cost Type: '
189: || TO_CHAR(p_to_cost_type_id));
190: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Material Subelement: '
191: || TO_CHAR(p_material));
192: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Material Overhead Subelement: '

Line 190: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Material Subelement: '

186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Period: ' || TO_CHAR(p_period_id));
187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'To Organization: ' || TO_CHAR(p_to_org_id));
188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'To Cost Type: '
189: || TO_CHAR(p_to_cost_type_id));
190: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Material Subelement: '
191: || TO_CHAR(p_material));
192: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Material Overhead Subelement: '
193: || TO_CHAR(p_material_overhead));
194: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Resource Subelement: '

Line 192: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Material Overhead Subelement: '

188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'To Cost Type: '
189: || TO_CHAR(p_to_cost_type_id));
190: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Material Subelement: '
191: || TO_CHAR(p_material));
192: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Material Overhead Subelement: '
193: || TO_CHAR(p_material_overhead));
194: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Resource Subelement: '
195: || TO_CHAR(p_resource));
196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Outside Processing Subelement: '

Line 194: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Resource Subelement: '

190: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Material Subelement: '
191: || TO_CHAR(p_material));
192: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Material Overhead Subelement: '
193: || TO_CHAR(p_material_overhead));
194: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Resource Subelement: '
195: || TO_CHAR(p_resource));
196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Outside Processing Subelement: '
197: || TO_CHAR(p_outside_processing));
198: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Overhead Subelement: '

Line 196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Outside Processing Subelement: '

192: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Material Overhead Subelement: '
193: || TO_CHAR(p_material_overhead));
194: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Resource Subelement: '
195: || TO_CHAR(p_resource));
196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Outside Processing Subelement: '
197: || TO_CHAR(p_outside_processing));
198: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Overhead Subelement: '
199: || TO_CHAR(p_overhead));
200: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Copy Option: ' || TO_CHAR(p_copy_option));

Line 198: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Overhead Subelement: '

194: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Resource Subelement: '
195: || TO_CHAR(p_resource));
196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Outside Processing Subelement: '
197: || TO_CHAR(p_outside_processing));
198: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Overhead Subelement: '
199: || TO_CHAR(p_overhead));
200: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Copy Option: ' || TO_CHAR(p_copy_option));
201: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Range: ' || TO_CHAR(p_range));
202: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Dummy: ' || TO_CHAR(p_item_dummy));

Line 200: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Copy Option: ' || TO_CHAR(p_copy_option));

196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Outside Processing Subelement: '
197: || TO_CHAR(p_outside_processing));
198: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Overhead Subelement: '
199: || TO_CHAR(p_overhead));
200: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Copy Option: ' || TO_CHAR(p_copy_option));
201: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Range: ' || TO_CHAR(p_range));
202: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Dummy: ' || TO_CHAR(p_item_dummy));
203: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Dummy: '
204: || TO_CHAR(p_category_dummy));

Line 201: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Range: ' || TO_CHAR(p_range));

197: || TO_CHAR(p_outside_processing));
198: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Overhead Subelement: '
199: || TO_CHAR(p_overhead));
200: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Copy Option: ' || TO_CHAR(p_copy_option));
201: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Range: ' || TO_CHAR(p_range));
202: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Dummy: ' || TO_CHAR(p_item_dummy));
203: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Dummy: '
204: || TO_CHAR(p_category_dummy));
205: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Item: '

Line 202: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Dummy: ' || TO_CHAR(p_item_dummy));

198: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Overhead Subelement: '
199: || TO_CHAR(p_overhead));
200: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Copy Option: ' || TO_CHAR(p_copy_option));
201: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Range: ' || TO_CHAR(p_range));
202: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Dummy: ' || TO_CHAR(p_item_dummy));
203: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Dummy: '
204: || TO_CHAR(p_category_dummy));
205: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Item: '
206: || TO_CHAR(p_specific_item_id));

Line 203: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Dummy: '

199: || TO_CHAR(p_overhead));
200: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Copy Option: ' || TO_CHAR(p_copy_option));
201: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Range: ' || TO_CHAR(p_range));
202: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Dummy: ' || TO_CHAR(p_item_dummy));
203: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Dummy: '
204: || TO_CHAR(p_category_dummy));
205: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Item: '
206: || TO_CHAR(p_specific_item_id));
207: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Set: '

Line 205: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Item: '

201: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Range: ' || TO_CHAR(p_range));
202: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Dummy: ' || TO_CHAR(p_item_dummy));
203: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Dummy: '
204: || TO_CHAR(p_category_dummy));
205: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Item: '
206: || TO_CHAR(p_specific_item_id));
207: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Set: '
208: || TO_CHAR(p_category_set_id));
209:

Line 207: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Set: '

203: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Dummy: '
204: || TO_CHAR(p_category_dummy));
205: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Item: '
206: || TO_CHAR(p_specific_item_id));
207: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Set: '
208: || TO_CHAR(p_category_set_id));
209:
210: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Validate Flag: '
211: || p_category_validate_flag);

Line 210: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Validate Flag: '

206: || TO_CHAR(p_specific_item_id));
207: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Set: '
208: || TO_CHAR(p_category_set_id));
209:
210: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Validate Flag: '
211: || p_category_validate_flag);
212: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Structure: '
213: || TO_CHAR(p_category_structure));
214: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category: '

Line 212: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Structure: '

208: || TO_CHAR(p_category_set_id));
209:
210: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Validate Flag: '
211: || p_category_validate_flag);
212: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Structure: '
213: || TO_CHAR(p_category_structure));
214: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category: '
215: || TO_CHAR(p_category_id));
216: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Updated by: '

Line 214: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category: '

210: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Validate Flag: '
211: || p_category_validate_flag);
212: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Structure: '
213: || TO_CHAR(p_category_structure));
214: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category: '
215: || TO_CHAR(p_category_id));
216: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Updated by: '
217: || TO_CHAR(p_last_updated_by));
218: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Full Validate: '

Line 216: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Updated by: '

212: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Structure: '
213: || TO_CHAR(p_category_structure));
214: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category: '
215: || TO_CHAR(p_category_id));
216: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Updated by: '
217: || TO_CHAR(p_last_updated_by));
218: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Full Validate: '
219: || TO_CHAR(p_full_validate));
220:

Line 218: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Full Validate: '

214: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category: '
215: || TO_CHAR(p_category_id));
216: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Updated by: '
217: || TO_CHAR(p_last_updated_by));
218: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Full Validate: '
219: || TO_CHAR(p_full_validate));
220:
221:
222: IF p_full_validate = 1 THEN

Line 516: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

512: INTO l_master_org_id
513: FROM cst_cost_groups ccg
514: WHERE ccg.cost_group_id = p_from_cost_group_id;
515:
516: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
517: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Master Org: ' || TO_CHAR(l_master_org_id));
518: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
519:
520: IF p_copy_option = 1 THEN

Line 517: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Master Org: ' || TO_CHAR(l_master_org_id));

513: FROM cst_cost_groups ccg
514: WHERE ccg.cost_group_id = p_from_cost_group_id;
515:
516: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
517: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Master Org: ' || TO_CHAR(l_master_org_id));
518: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
519:
520: IF p_copy_option = 1 THEN
521:

Line 518: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

514: WHERE ccg.cost_group_id = p_from_cost_group_id;
515:
516: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
517: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Master Org: ' || TO_CHAR(l_master_org_id));
518: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
519:
520: IF p_copy_option = 1 THEN
521:
522:

Line 523: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Merge and Update Costs');

519:
520: IF p_copy_option = 1 THEN
521:
522:
523: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Merge and Update Costs');
524: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
525:
526: --------------------------------------------------------------------------
527: -- Merge and update existing costs

Line 524: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

520: IF p_copy_option = 1 THEN
521:
522:
523: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Merge and Update Costs');
524: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
525:
526: --------------------------------------------------------------------------
527: -- Merge and update existing costs
528: -- Logic:

Line 577: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)

573:
574: l_row_count := 0;
575: l_row_count := SQL%ROWCOUNT;
576:
577: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)
578: ||' Rows deleted from CICD');
579:
580: --------------------------------------------------------------------------
581: -- step 2> Copying rollup flags, then Deleting existing cost information from CIC

Line 629: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)

625:
626: l_row_count := 0;
627: l_row_count := SQL%ROWCOUNT;
628:
629: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)
630: ||' Rollup Flags backed up from CIC to CICI');
631:
632: l_stmt_num := 40;
633:

Line 661: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)

657:
658: l_row_count := 0;
659: l_row_count := SQL%ROWCOUNT;
660:
661: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)
662: ||' Rows deleted from CIC');
663:
664:
665: --------------------------------------------------------------------------

Line 817: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)

813:
814: l_row_count := 0;
815: l_row_count := SQL%ROWCOUNT;
816:
817: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)
818: ||' Rows Inserted into CIC');
819:
820: l_stmt_num := 55;
821:

Line 828: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)

824:
825: l_row_count := 0;
826: l_row_count := SQL%ROWCOUNT;
827:
828: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)
829: ||' Backup Rows deleted from CICI');
830:
831: --------------------------------------------------------------------------
832: -- step 4> Getting costs from CPICD having the cost_layer_id

Line 923: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)

919:
920: l_row_count := 0;
921: l_row_count := SQL%ROWCOUNT;
922:
923: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)
924: ||' Rows Inserted into CICD: ');
925:
926:
927: END IF; -- If p_copy_option

Line 932: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert New Cost Information Only');

928:
929:
930: IF p_copy_option = 2 THEN
931:
932: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert New Cost Information Only');
933:
934: --------------------------------------------------------------------------
935: -- New Cost Information Only
936: -- Logic:

Line 1098: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)

1094:
1095: l_row_count := 0;
1096: l_row_count := SQL%ROWCOUNT;
1097:
1098: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)
1099: ||' Rows Inserted into CIC');
1100:
1101:
1102:

Line 1212: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)

1208:
1209: l_row_count := 0;
1210: l_row_count := SQL%ROWCOUNT;
1211:
1212: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)
1213: ||' Rows Inserted into CICD');
1214:
1215: END IF; -- If p_copy_option = 2
1216:

Line 1220: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Remove and Replace Cost Information');

1216:
1217:
1218: IF p_copy_option = 3 THEN
1219:
1220: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Remove and Replace Cost Information');
1221: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1222:
1223: --------------------------------------------------------------------------
1224: --Remove and replace all cost information

Line 1221: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

1217:
1218: IF p_copy_option = 3 THEN
1219:
1220: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Remove and Replace Cost Information');
1221: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1222:
1223: --------------------------------------------------------------------------
1224: --Remove and replace all cost information
1225: -- Logic:

Line 1262: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)

1258:
1259: l_row_count := 0;
1260: l_row_count := SQL%ROWCOUNT;
1261:
1262: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)
1263: ||' Rows deleted from CICD');
1264:
1265:
1266: --------------------------------------------------------------------------

Line 1315: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)

1311:
1312: l_row_count := 0;
1313: l_row_count := SQL%ROWCOUNT;
1314:
1315: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)
1316: ||' Rollup Flags backed up from CIC to CICI');
1317:
1318:
1319: l_stmt_num := 100;

Line 1342: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)

1338:
1339: l_row_count := 0;
1340: l_row_count := SQL%ROWCOUNT;
1341:
1342: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)
1343: ||' Rows deleted from CIC');
1344:
1345:
1346: --------------------------------------------------------------------------

Line 1498: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)

1494:
1495: l_row_count := 0;
1496: l_row_count := SQL%ROWCOUNT;
1497:
1498: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)
1499: ||' Rows Inserted into CIC');
1500:
1501: l_stmt_num := 115;
1502:

Line 1509: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)

1505:
1506: l_row_count := 0;
1507: l_row_count := SQL%ROWCOUNT;
1508:
1509: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)
1510: ||' Backup Rows deleted from CICI');
1511:
1512: --------------------------------------------------------------------------
1513: -- step 4> Getting costs from CPICD having the cost_layer_id

Line 1605: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)

1601:
1602: l_row_count := 0;
1603: l_row_count := SQL%ROWCOUNT;
1604:
1605: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)
1606: ||' Rows Inserted into CICD');
1607:
1608:
1609: END IF; -- If p_copy_option = 3

Line 1626: fnd_file.put_line(fnd_file.log,l_err_msg);

1622: l_err_msg := FND_MESSAGE.Get;
1623: l_err_msg := substrb('CSTPPCIC.copy_item_period_cost('|| to_char(l_stmt_num)|| ')' || ' : (' || to_char(l_err_num) || '):'|| l_err_code ||' : '||l_err_msg,1,240);
1624:
1625: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
1626: fnd_file.put_line(fnd_file.log,l_err_msg);
1627:
1628: WHEN cst_fail_parameters THEN
1629:
1630: l_err_num := 30001;

Line 1638: fnd_file.put_line(fnd_file.log,l_err_msg);

1634: l_err_msg := FND_MESSAGE.Get;
1635: l_err_msg := substrb('CSTPPCIC.copy_item_period_cost('|| to_char(l_stmt_num)|| ')' || ' : (' || to_char(l_err_num) || '):'|| l_err_code ||' : '||l_err_msg,1,240);
1636:
1637: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
1638: fnd_file.put_line(fnd_file.log,l_err_msg);
1639:
1640: WHEN OTHERS THEN
1641:
1642: l_err_num := 30001;

Line 1650: fnd_file.put_line(fnd_file.log,l_err_msg);

1646: l_err_msg := FND_MESSAGE.Get;
1647: l_err_msg := substrb('CSTPPCIC.copy_item_period_cost('|| to_char(l_stmt_num)|| ')' || ' : (' || to_char(l_err_num) || '):'|| l_err_code ||' : '||l_err_msg,1,240);
1648:
1649: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
1650: fnd_file.put_line(fnd_file.log,l_err_msg);
1651:
1652: END copy_item_period_cost;
1653:
1654: END CSTPPCIC;