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.MSD_DEM_CREATE_DEM_SEED dependencies on DBMS_OUTPUT

Line 69: dbms_output.put_line('Demantra Schema is not set');

65: DEMANTRA_SCHEMA := fnd_profile.value('MSD_DEM_SCHEMA');
66: /*DEMANTRA_SCHEMA := 'dmtra_template';*/
67:
68: if DEMANTRA_SCHEMA is null then
69: dbms_output.put_line('Demantra Schema is not set');
70: return;
71: end if;
72:
73: if p_start_no is null or p_start_no < 0 then

Line 74: dbms_output.put_line('Please enter a valid Starting Number');

70: return;
71: end if;
72:
73: if p_start_no is null or p_start_no < 0 then
74: dbms_output.put_line('Please enter a valid Starting Number');
75: return;
76: end if;
77:
78: if p_num_entities <= 0 then

Line 79: dbms_output.put_line('Please enter a valid number for Number of entities');

75: return;
76: end if;
77:
78: if p_num_entities <= 0 then
79: dbms_output.put_line('Please enter a valid number for Number of entities');
80: return;
81: end if;
82:
83: if p_num_entities > 100 then

Line 84: dbms_output.put_line('Please enter number of entities < 100');

80: return;
81: end if;
82:
83: if p_num_entities > 100 then
84: dbms_output.put_line('Please enter number of entities < 100');
85: return;
86: end if;
87:
88: if P_entity_type <> 0 and P_entity_type <> 1 and P_entity_type <> 2 and P_entity_type <> 3 then

Line 89: dbms_output.put_line('Please enter Entity Type as 1 (UOM), 2 (CURRENCY), 3 (PRICE LIST) , 0 (ALL) ');

85: return;
86: end if;
87:
88: if P_entity_type <> 0 and P_entity_type <> 1 and P_entity_type <> 2 and P_entity_type <> 3 then
89: dbms_output.put_line('Please enter Entity Type as 1 (UOM), 2 (CURRENCY), 3 (PRICE LIST) , 0 (ALL) ');
90: return;
91: end if;
92:
93:

Line 94: dbms_output.put_line('Start Number = ' || p_start_no || ', Number of entities = ' || p_num_entities);

90: return;
91: end if;
92:
93:
94: dbms_output.put_line('Start Number = ' || p_start_no || ', Number of entities = ' || p_num_entities);
95:
96:
97: if p_entity_type = 0 or p_entity_type = 1 then
98:

Line 99: dbms_output.put_line('Starting Creation of Display Units for UOMs');

95:
96:
97: if p_entity_type = 0 or p_entity_type = 1 then
98:
99: dbms_output.put_line('Starting Creation of Display Units for UOMs');
100: l_index := 0;
101: while l_index < p_num_entities
102: loop
103: l_ebs_entity_name := UOM_NAME || (p_start_no + l_index);

Line 104: dbms_output.put_line('Creating Display Unit for UOM, ' || l_ebs_entity_name);

100: l_index := 0;
101: while l_index < p_num_entities
102: loop
103: l_ebs_entity_name := UOM_NAME || (p_start_no + l_index);
104: dbms_output.put_line('Creating Display Unit for UOM, ' || l_ebs_entity_name);
105: l_stmt_get_code := ' select display_units from ' || DEMANTRA_SCHEMA || '.display_units ' ||
106: ' where display_units = ''' || l_ebs_entity_name || '''' ;
107: l_dem_entity_name := '';
108:

Line 109: dbms_output.put_line(l_stmt_get_code);

105: l_stmt_get_code := ' select display_units from ' || DEMANTRA_SCHEMA || '.display_units ' ||
106: ' where display_units = ''' || l_ebs_entity_name || '''' ;
107: l_dem_entity_name := '';
108:
109: dbms_output.put_line(l_stmt_get_code);
110: open get_code for l_stmt_get_code;
111: fetch get_code into l_dem_entity_name;
112: close get_code;
113:

Line 115: dbms_output.put_line('Display Unit ' || l_ebs_entity_name || ' exists. Skipping....');

111: fetch get_code into l_dem_entity_name;
112: close get_code;
113:
114: if l_dem_entity_name = l_ebs_entity_name then
115: dbms_output.put_line('Display Unit ' || l_ebs_entity_name || ' exists. Skipping....');
116: else
117:
118: l_stmt := ' alter table ' || DEMANTRA_SCHEMA || '.t_ep_item ' ||
119: ' add ( ' || l_ebs_entity_name || ' NUMBER default null) ';

Line 120: dbms_output.put_line(l_stmt);

116: else
117:
118: l_stmt := ' alter table ' || DEMANTRA_SCHEMA || '.t_ep_item ' ||
119: ' add ( ' || l_ebs_entity_name || ' NUMBER default null) ';
120: dbms_output.put_line(l_stmt);
121:
122: begin
123: execute immediate l_stmt;
124: exception

Line 126: dbms_output.put_line('Display Unit ' || l_ebs_entity_name || ' failed in alter statement');

122: begin
123: execute immediate l_stmt;
124: exception
125: when others then
126: dbms_output.put_line('Display Unit ' || l_ebs_entity_name || ' failed in alter statement');
127: dbms_output.put_line(substr(SQLERRM,1,250));
128: goto continue;
129: end;
130:

Line 127: dbms_output.put_line(substr(SQLERRM,1,250));

123: execute immediate l_stmt;
124: exception
125: when others then
126: dbms_output.put_line('Display Unit ' || l_ebs_entity_name || ' failed in alter statement');
127: dbms_output.put_line(substr(SQLERRM,1,250));
128: goto continue;
129: end;
130:
131: l_stmt_display_unit_id := ' select max(display_units_id)+1 from ' || DEMANTRA_SCHEMA || '.display_units ';

Line 133: dbms_output.put_line(l_stmt_display_unit_id);

129: end;
130:
131: l_stmt_display_unit_id := ' select max(display_units_id)+1 from ' || DEMANTRA_SCHEMA || '.display_units ';
132:
133: dbms_output.put_line(l_stmt_display_unit_id);
134: open get_display_unit_id for l_stmt_display_unit_id;
135: fetch get_display_unit_id into l_display_unit_id;
136: close get_display_unit_id;
137: dbms_output.put_line(l_display_unit_id);

Line 137: dbms_output.put_line(l_display_unit_id);

133: dbms_output.put_line(l_stmt_display_unit_id);
134: open get_display_unit_id for l_stmt_display_unit_id;
135: fetch get_display_unit_id into l_display_unit_id;
136: close get_display_unit_id;
137: dbms_output.put_line(l_display_unit_id);
138:
139: l_stmt := ' insert into ' || DEMANTRA_SCHEMA || '.display_units ' ||
140: ' (DISPLAY_UNITS_ID, DISPLAY_UNITS, DATA_TABLE, DATA_FIELD, DATA_EXPRESSION) ' ||
141: ' values (:1,:2,''t_ep_item'',:3,NULL) ';

Line 142: dbms_output.put_line(l_stmt);

138:
139: l_stmt := ' insert into ' || DEMANTRA_SCHEMA || '.display_units ' ||
140: ' (DISPLAY_UNITS_ID, DISPLAY_UNITS, DATA_TABLE, DATA_FIELD, DATA_EXPRESSION) ' ||
141: ' values (:1,:2,''t_ep_item'',:3,NULL) ';
142: dbms_output.put_line(l_stmt);
143: execute immediate l_stmt using l_display_unit_id, l_ebs_entity_name, l_ebs_entity_name;
144:
145: dbms_output.put_line('Display Unit ' || l_ebs_entity_name || ' created');
146: <>

Line 145: dbms_output.put_line('Display Unit ' || l_ebs_entity_name || ' created');

141: ' values (:1,:2,''t_ep_item'',:3,NULL) ';
142: dbms_output.put_line(l_stmt);
143: execute immediate l_stmt using l_display_unit_id, l_ebs_entity_name, l_ebs_entity_name;
144:
145: dbms_output.put_line('Display Unit ' || l_ebs_entity_name || ' created');
146: <>
147: null;
148: end if;
149: l_index := l_index + 1;

Line 152: dbms_output.put_line('Completed Creation of Display Units for UOMs');

148: end if;
149: l_index := l_index + 1;
150: end loop;
151: commit;
152: dbms_output.put_line('Completed Creation of Display Units for UOMs');
153:
154: end if;
155:
156: if p_entity_type = 0 or p_entity_type = 2 then

Line 158: dbms_output.put_line('Starting Creation of Indexes for Currency');

154: end if;
155:
156: if p_entity_type = 0 or p_entity_type = 2 then
157:
158: dbms_output.put_line('Starting Creation of Indexes for Currency');
159: l_index := 0;
160: while l_index < p_num_entities
161: loop
162: l_ebs_entity_name := CURRENCY_NAME || (p_start_no + l_index);

Line 164: dbms_output.put_line('Creating Index for Currency, ' || l_ebs_entity_name);

160: while l_index < p_num_entities
161: loop
162: l_ebs_entity_name := CURRENCY_NAME || (p_start_no + l_index);
163:
164: dbms_output.put_line('Creating Index for Currency, ' || l_ebs_entity_name);
165: l_stmt_get_code := ' select real_value from ' || DEMANTRA_SCHEMA || '.real_values ' ||
166: ' where real_value = ''' || l_ebs_entity_name || '''' ;
167:
168: l_dem_entity_name := '';

Line 170: dbms_output.put_line(l_stmt_get_code);

166: ' where real_value = ''' || l_ebs_entity_name || '''' ;
167:
168: l_dem_entity_name := '';
169:
170: dbms_output.put_line(l_stmt_get_code);
171:
172: open get_code for l_stmt_get_code;
173: fetch get_code into l_dem_entity_name;
174: close get_code;

Line 177: dbms_output.put_line('Index ' || l_ebs_entity_name || ' exists. Skipping....');

173: fetch get_code into l_dem_entity_name;
174: close get_code;
175:
176: if l_dem_entity_name = l_ebs_entity_name then
177: dbms_output.put_line('Index ' || l_ebs_entity_name || ' exists. Skipping....');
178: else
179:
180: begin
181: l_stmt := ' create table ' || DEMANTRA_SCHEMA || '.' || l_ebs_entity_name ||

Line 183: dbms_output.put_line(l_stmt);

179:
180: begin
181: l_stmt := ' create table ' || DEMANTRA_SCHEMA || '.' || l_ebs_entity_name ||
182: ' (INDEX_DATE DATE, INDEX_VALUE NUMBER(10,5)) ';
183: dbms_output.put_line(l_stmt);
184: execute immediate l_stmt;
185: exception
186: when others then
187: dbms_output.put_line('Real Value ' || l_ebs_entity_name || ' failed in create statement');

Line 187: dbms_output.put_line('Real Value ' || l_ebs_entity_name || ' failed in create statement');

183: dbms_output.put_line(l_stmt);
184: execute immediate l_stmt;
185: exception
186: when others then
187: dbms_output.put_line('Real Value ' || l_ebs_entity_name || ' failed in create statement');
188: dbms_output.put_line(substr(SQLERRM,1,250));
189: goto continue1;
190: end;
191:

Line 188: dbms_output.put_line(substr(SQLERRM,1,250));

184: execute immediate l_stmt;
185: exception
186: when others then
187: dbms_output.put_line('Real Value ' || l_ebs_entity_name || ' failed in create statement');
188: dbms_output.put_line(substr(SQLERRM,1,250));
189: goto continue1;
190: end;
191:
192: l_stmt := ' insert into ' || DEMANTRA_SCHEMA || '.real_values ' ||

Line 195: dbms_output.put_line(l_stmt);

191:
192: l_stmt := ' insert into ' || DEMANTRA_SCHEMA || '.real_values ' ||
193: ' (REAL_VALUE_ID, REAL_VALUE, REAL_TABLE, CALCULATION_TYPE, IS_DEFAULT) ' ||
194: ' values (' || DEMANTRA_SCHEMA || '.' || REAL_VALUES_SEQ || '.nextval,:1,:2,2,NULL) ';
195: dbms_output.put_line(l_stmt);
196: execute immediate l_stmt using l_ebs_entity_name, l_ebs_entity_name;
197:
198:
199: dbms_output.put_line('Index ' || l_ebs_entity_name || ' created');

Line 199: dbms_output.put_line('Index ' || l_ebs_entity_name || ' created');

195: dbms_output.put_line(l_stmt);
196: execute immediate l_stmt using l_ebs_entity_name, l_ebs_entity_name;
197:
198:
199: dbms_output.put_line('Index ' || l_ebs_entity_name || ' created');
200:
201: <>
202: null;
203: end if;

Line 207: dbms_output.put_line('Completed Creation of Indexes for Currency');

203: end if;
204: l_index := l_index + 1;
205: end loop;
206: commit;
207: dbms_output.put_line('Completed Creation of Indexes for Currency');
208:
209: end if;
210:
211: if p_entity_type = 0 or p_entity_type = 3 then

Line 218: dbms_output.put_line('Demand Management component is null');

214:
215: /*DM_COMPONENT := 'Demand Management';*/
216:
217: if DM_COMPONENT is null then
218: dbms_output.put_line('Demand Management component is null');
219: return;
220: end if;
221:
222: l_stmt_get_component := 'select dcm_product_id from ' || DEMANTRA_SCHEMA || '.dcm_products where product_name = ''' || DM_COMPONENT || '''';

Line 223: dbms_output.put_line(l_stmt_get_component);

219: return;
220: end if;
221:
222: l_stmt_get_component := 'select dcm_product_id from ' || DEMANTRA_SCHEMA || '.dcm_products where product_name = ''' || DM_COMPONENT || '''';
223: dbms_output.put_line(l_stmt_get_component);
224:
225: open get_component for l_stmt_get_component;
226: fetch get_component into l_component_id;
227: close get_component;

Line 229: dbms_output.put_line(l_component_id);

225: open get_component for l_stmt_get_component;
226: fetch get_component into l_component_id;
227: close get_component;
228:
229: dbms_output.put_line(l_component_id);
230:
231: l_stmt_user_id := 'select user_id from ' || DEMANTRA_SCHEMA || '.user_id where lower(user_name) = ''dm''';
232: dbms_output.put_line(l_stmt_user_id);
233:

Line 232: dbms_output.put_line(l_stmt_user_id);

228:
229: dbms_output.put_line(l_component_id);
230:
231: l_stmt_user_id := 'select user_id from ' || DEMANTRA_SCHEMA || '.user_id where lower(user_name) = ''dm''';
232: dbms_output.put_line(l_stmt_user_id);
233:
234: open get_user_id for l_stmt_user_id;
235: fetch get_user_id into l_user_id;
236: close get_user_id;

Line 237: dbms_output.put_line(l_user_id);

233:
234: open get_user_id for l_stmt_user_id;
235: fetch get_user_id into l_user_id;
236: close get_user_id;
237: dbms_output.put_line(l_user_id);
238:
239: l_stmt_query_id := 'select tq.id from ' ||
240: DEMANTRA_SCHEMA || '.transfer_list tl, ' ||
241: DEMANTRA_SCHEMA || '.transfer_query tq ' ||

Line 244: dbms_output.put_line(l_stmt_query_id);

240: DEMANTRA_SCHEMA || '.transfer_list tl, ' ||
241: DEMANTRA_SCHEMA || '.transfer_query tq ' ||
242: ' where name like ''EBS Price List''' ||
243: ' and tq.transfer_id = tl.id ' ;
244: dbms_output.put_line(l_stmt_query_id);
245:
246: open get_query_id for l_stmt_query_id;
247: fetch get_query_id into l_query_id;
248: close get_query_id;

Line 249: dbms_output.put_line(l_query_id);

245:
246: open get_query_id for l_stmt_query_id;
247: fetch get_query_id into l_query_id;
248: close get_query_id;
249: dbms_output.put_line(l_query_id);
250:
251:
252: dbms_output.put_line('Starting Creation of Display Units for Price Lists');
253: l_index := 0;

Line 252: dbms_output.put_line('Starting Creation of Display Units for Price Lists');

248: close get_query_id;
249: dbms_output.put_line(l_query_id);
250:
251:
252: dbms_output.put_line('Starting Creation of Display Units for Price Lists');
253: l_index := 0;
254: while l_index < p_num_entities
255: loop
256: l_ebs_entity_name := PRICELIST_NAME || (p_start_no + l_index);

Line 257: dbms_output.put_line('Creating Display Unit for Price List, ' || l_ebs_entity_name);

253: l_index := 0;
254: while l_index < p_num_entities
255: loop
256: l_ebs_entity_name := PRICELIST_NAME || (p_start_no + l_index);
257: dbms_output.put_line('Creating Display Unit for Price List, ' || l_ebs_entity_name);
258: l_stmt_get_code := ' select display_units from ' || DEMANTRA_SCHEMA || '.display_units ' ||
259: ' where display_units = ''' || l_ebs_entity_name || '''' ;
260:
261: l_dem_entity_name := '';

Line 263: dbms_output.put_line(l_stmt_get_code);

259: ' where display_units = ''' || l_ebs_entity_name || '''' ;
260:
261: l_dem_entity_name := '';
262:
263: dbms_output.put_line(l_stmt_get_code);
264: open get_code for l_stmt_get_code;
265: fetch get_code into l_dem_entity_name;
266: close get_code;
267:

Line 269: dbms_output.put_line('Display Unit ' || l_ebs_entity_name || ' exists. Skipping....');

265: fetch get_code into l_dem_entity_name;
266: close get_code;
267:
268: if l_dem_entity_name = l_ebs_entity_name then
269: dbms_output.put_line('Display Unit ' || l_ebs_entity_name || ' exists. Skipping....');
270: else
271:
272: begin
273: l_stmt := ' alter table ' || DEMANTRA_SCHEMA || '.sales_data ' ||

Line 275: dbms_output.put_line(l_stmt);

271:
272: begin
273: l_stmt := ' alter table ' || DEMANTRA_SCHEMA || '.sales_data ' ||
274: ' add (' || l_ebs_entity_name || ' NUMBER default null) ';
275: dbms_output.put_line(l_stmt);
276: execute immediate l_stmt;
277:
278: l_stmt := ' alter table ' || DEMANTRA_SCHEMA || '.' || INTG_TABLE ||
279: ' add (' || l_ebs_entity_name || ' NUMBER default null) ';

Line 280: dbms_output.put_line(l_stmt);

276: execute immediate l_stmt;
277:
278: l_stmt := ' alter table ' || DEMANTRA_SCHEMA || '.' || INTG_TABLE ||
279: ' add (' || l_ebs_entity_name || ' NUMBER default null) ';
280: dbms_output.put_line(l_stmt);
281: execute immediate l_stmt;
282:
283: exception
284: when others then

Line 285: dbms_output.put_line('Display Unit for Price List ' || l_ebs_entity_name || ' failed in alter statement');

281: execute immediate l_stmt;
282:
283: exception
284: when others then
285: dbms_output.put_line('Display Unit for Price List ' || l_ebs_entity_name || ' failed in alter statement');
286: dbms_output.put_line(substr(SQLERRM,1,250));
287: goto continue2;
288: end;
289:

Line 286: dbms_output.put_line(substr(SQLERRM,1,250));

282:
283: exception
284: when others then
285: dbms_output.put_line('Display Unit for Price List ' || l_ebs_entity_name || ' failed in alter statement');
286: dbms_output.put_line(substr(SQLERRM,1,250));
287: goto continue2;
288: end;
289:
290: l_stmt_display_unit_id := ' select max(display_units_id)+1 from ' || DEMANTRA_SCHEMA || '.display_units ';

Line 292: dbms_output.put_line(l_stmt_display_unit_id);

288: end;
289:
290: l_stmt_display_unit_id := ' select max(display_units_id)+1 from ' || DEMANTRA_SCHEMA || '.display_units ';
291:
292: dbms_output.put_line(l_stmt_display_unit_id);
293: open get_display_unit_id for l_stmt_display_unit_id;
294: fetch get_display_unit_id into l_display_unit_id;
295: close get_display_unit_id;
296: dbms_output.put_line(l_display_unit_id);

Line 296: dbms_output.put_line(l_display_unit_id);

292: dbms_output.put_line(l_stmt_display_unit_id);
293: open get_display_unit_id for l_stmt_display_unit_id;
294: fetch get_display_unit_id into l_display_unit_id;
295: close get_display_unit_id;
296: dbms_output.put_line(l_display_unit_id);
297:
298: l_stmt := ' insert into ' || DEMANTRA_SCHEMA || '.display_units ' ||
299: ' (DISPLAY_UNITS_ID, DISPLAY_UNITS, DATA_TABLE, DATA_FIELD, DATA_EXPRESSION) ' ||
300: ' values (:1,:2,''sales_data'',:3,NULL) ';

Line 301: dbms_output.put_line(l_stmt);

297:
298: l_stmt := ' insert into ' || DEMANTRA_SCHEMA || '.display_units ' ||
299: ' (DISPLAY_UNITS_ID, DISPLAY_UNITS, DATA_TABLE, DATA_FIELD, DATA_EXPRESSION) ' ||
300: ' values (:1,:2,''sales_data'',:3,NULL) ';
301: dbms_output.put_line(l_stmt);
302: execute immediate l_stmt using l_display_unit_id, l_ebs_entity_name, l_ebs_entity_name;
303:
304: l_stmt_series_id := 'select ' || DEMANTRA_SCHEMA || '.' || COMPUTED_FIELDS_SEQ || '.nextval from dual';
305:

Line 306: dbms_output.put_line(l_stmt_series_id);

302: execute immediate l_stmt using l_display_unit_id, l_ebs_entity_name, l_ebs_entity_name;
303:
304: l_stmt_series_id := 'select ' || DEMANTRA_SCHEMA || '.' || COMPUTED_FIELDS_SEQ || '.nextval from dual';
305:
306: dbms_output.put_line(l_stmt_series_id);
307: open get_series_id for l_stmt_series_id;
308: fetch get_series_id into l_series_id;
309: close get_series_id;
310: dbms_output.put_line(l_series_id);

Line 310: dbms_output.put_line(l_series_id);

306: dbms_output.put_line(l_stmt_series_id);
307: open get_series_id for l_stmt_series_id;
308: fetch get_series_id into l_series_id;
309: close get_series_id;
310: dbms_output.put_line(l_series_id);
311:
312: l_stmt_disp_order_id := ' select max(disp_order)+1 from ' || DEMANTRA_SCHEMA || '.computed_fields ';
313:
314: dbms_output.put_line(l_stmt_disp_order_id);

Line 314: dbms_output.put_line(l_stmt_disp_order_id);

310: dbms_output.put_line(l_series_id);
311:
312: l_stmt_disp_order_id := ' select max(disp_order)+1 from ' || DEMANTRA_SCHEMA || '.computed_fields ';
313:
314: dbms_output.put_line(l_stmt_disp_order_id);
315: open get_disp_order_id for l_stmt_disp_order_id;
316: fetch get_disp_order_id into l_disp_order_id;
317: close get_disp_order_id;
318: dbms_output.put_line(l_disp_order_id);

Line 318: dbms_output.put_line(l_disp_order_id);

314: dbms_output.put_line(l_stmt_disp_order_id);
315: open get_disp_order_id for l_stmt_disp_order_id;
316: fetch get_disp_order_id into l_disp_order_id;
317: close get_disp_order_id;
318: dbms_output.put_line(l_disp_order_id);
319:
320:
321: l_stmt_comp := 'INSERT INTO ' || DEMANTRA_SCHEMA || '.COMPUTED_FIELDS("FORECAST_TYPE_ID", "COMPUTED_NAME", "EXP_TEMPLATE", "DISP_COLOR", "DISP_LSTYLE", "DISP_LSYMBOL", ' ||
322: ' "PRINT_COLOR", "PRINT_LSTYLE", "PRINT_LSYMBOL", "DISP_ORDER", "INFO_TYPE", "TABLE_FORMAT", ' ||

Line 343: dbms_output.put_line('Inserting into computed_fields');

339: ' NULL, NULL, 3, NULL, NULL, ''branch_data'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,' ||
340: ' NULL, 0, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1, ''Avg'', ' ||
341: ' NULL, 0, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, 0, 3, NULL, 1, 0)';
342:
343: dbms_output.put_line('Inserting into computed_fields');
344: execute immediate l_stmt_comp using l_ebs_entity_name, l_disp_order_id, l_ebs_entity_name, lower(l_ebs_entity_name) ;
345:
346:
347: l_stmt := 'insert into ' || DEMANTRA_SCHEMA || '.dcm_products_series' ||

Line 357: dbms_output.put_line(l_stmt);

353: l_stmt := 'insert into ' || DEMANTRA_SCHEMA || '.user_security_series ' ||
354: ' (user_id, series_id ) ' ||
355: ' values (:1, :2)';
356:
357: dbms_output.put_line(l_stmt);
358:
359: execute immediate l_stmt using l_user_id, l_series_id;
360:
361:

Line 367: dbms_output.put_line(l_stmt);

363: || '(id, series_id, load_option, purge_option)'
364: || ' values '
365: || ' (:1,:2,2,0)';
366:
367: dbms_output.put_line(l_stmt);
368: execute immediate l_stmt using l_query_id, l_series_id;
369:
370: dbms_output.put_line('Display Unit for Price List' || l_ebs_entity_name || ' created');
371:

Line 370: dbms_output.put_line('Display Unit for Price List' || l_ebs_entity_name || ' created');

366:
367: dbms_output.put_line(l_stmt);
368: execute immediate l_stmt using l_query_id, l_series_id;
369:
370: dbms_output.put_line('Display Unit for Price List' || l_ebs_entity_name || ' created');
371:
372: <>
373: null;
374: end if;

Line 378: dbms_output.put_line('Completed Creation of Display Units for Price Lists');

374: end if;
375: l_index := l_index + 1;
376: end loop;
377: commit;
378: dbms_output.put_line('Completed Creation of Display Units for Price Lists');
379:
380: end if;
381:
382: exception

Line 384: dbms_output.put_line(substr(SQLERRM,1,150));

380: end if;
381:
382: exception
383: when others then
384: dbms_output.put_line(substr(SQLERRM,1,150));
385: retcode := 1;
386:
387: retcode := 0;
388: