158: 'Errors when updating AS_SALES_CREDITS_DENORM');
159: RAISE;
160: end;
161:
162: -- AS_INTERNAL_FORECASTS
163: begin
164: UTL_FILE.Put_Line(l_file_ptr, 'Updating AS_INTERNAL_FORECASTS');
165: update AS_INTERNAL_FORECASTS
166: set salesforce_id = l_to_resource_id
160: end;
161:
162: -- AS_INTERNAL_FORECASTS
163: begin
164: UTL_FILE.Put_Line(l_file_ptr, 'Updating AS_INTERNAL_FORECASTS');
165: update AS_INTERNAL_FORECASTS
166: set salesforce_id = l_to_resource_id
167: where salesforce_id = l_resource_id;
168: exception
161:
162: -- AS_INTERNAL_FORECASTS
163: begin
164: UTL_FILE.Put_Line(l_file_ptr, 'Updating AS_INTERNAL_FORECASTS');
165: update AS_INTERNAL_FORECASTS
166: set salesforce_id = l_to_resource_id
167: where salesforce_id = l_resource_id;
168: exception
169: when others then
167: where salesforce_id = l_resource_id;
168: exception
169: when others then
170: UTL_FILE.Put_Line(l_file_ptr,
171: 'Errors when updating AS_INTERNAL_FORECASTS');
172: RAISE;
173: end;
174:
175: -- AS_FORECAST_WORKSHEETS