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_COLLECT_PRICE_LISTS dependencies on MSD_DEM_COMMON_UTILITIES

Line 81: msd_dem_common_utilities.log_message('Price List deleted. Please recreate the Price List');

77: fetch get_prl_metadata into l_table_name, l_column_name;
78:
79: if get_prl_metadata%notfound then
80: close get_prl_metadata;
81: msd_dem_common_utilities.log_message('Price List deleted. Please recreate the Price List');
82: msd_dem_common_utilities.log_debug('Price List deleted. Please recreate the Price List');
83: retcode := 1;
84: return;
85: end if;

Line 82: msd_dem_common_utilities.log_debug('Price List deleted. Please recreate the Price List');

78:
79: if get_prl_metadata%notfound then
80: close get_prl_metadata;
81: msd_dem_common_utilities.log_message('Price List deleted. Please recreate the Price List');
82: msd_dem_common_utilities.log_debug('Price List deleted. Please recreate the Price List');
83: retcode := 1;
84: return;
85: end if;
86:

Line 102: msd_dem_common_utilities.log_debug('Bind variables: ');

98:
99: l_stmt := replace(l_stmt, 'COLUMNNAME', l_column_name);
100:
101:
102: msd_dem_common_utilities.log_debug('Bind variables: ');
103: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
104: msd_dem_common_utilities.log_debug('p_start_date: ' || p_start_date);
105: msd_dem_common_utilities.log_debug('p_end_date: ' || p_end_date);
106: msd_dem_common_utilities.log_debug('p_prl_code: ' || p_prl_code);

Line 103: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);

99: l_stmt := replace(l_stmt, 'COLUMNNAME', l_column_name);
100:
101:
102: msd_dem_common_utilities.log_debug('Bind variables: ');
103: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
104: msd_dem_common_utilities.log_debug('p_start_date: ' || p_start_date);
105: msd_dem_common_utilities.log_debug('p_end_date: ' || p_end_date);
106: msd_dem_common_utilities.log_debug('p_prl_code: ' || p_prl_code);
107:

Line 104: msd_dem_common_utilities.log_debug('p_start_date: ' || p_start_date);

100:
101:
102: msd_dem_common_utilities.log_debug('Bind variables: ');
103: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
104: msd_dem_common_utilities.log_debug('p_start_date: ' || p_start_date);
105: msd_dem_common_utilities.log_debug('p_end_date: ' || p_end_date);
106: msd_dem_common_utilities.log_debug('p_prl_code: ' || p_prl_code);
107:
108: msd_dem_common_utilities.log_debug('Executed Statement: ');

Line 105: msd_dem_common_utilities.log_debug('p_end_date: ' || p_end_date);

101:
102: msd_dem_common_utilities.log_debug('Bind variables: ');
103: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
104: msd_dem_common_utilities.log_debug('p_start_date: ' || p_start_date);
105: msd_dem_common_utilities.log_debug('p_end_date: ' || p_end_date);
106: msd_dem_common_utilities.log_debug('p_prl_code: ' || p_prl_code);
107:
108: msd_dem_common_utilities.log_debug('Executed Statement: ');
109: msd_dem_common_utilities.log_debug(l_stmt);

Line 106: msd_dem_common_utilities.log_debug('p_prl_code: ' || p_prl_code);

102: msd_dem_common_utilities.log_debug('Bind variables: ');
103: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
104: msd_dem_common_utilities.log_debug('p_start_date: ' || p_start_date);
105: msd_dem_common_utilities.log_debug('p_end_date: ' || p_end_date);
106: msd_dem_common_utilities.log_debug('p_prl_code: ' || p_prl_code);
107:
108: msd_dem_common_utilities.log_debug('Executed Statement: ');
109: msd_dem_common_utilities.log_debug(l_stmt);
110:

Line 108: msd_dem_common_utilities.log_debug('Executed Statement: ');

104: msd_dem_common_utilities.log_debug('p_start_date: ' || p_start_date);
105: msd_dem_common_utilities.log_debug('p_end_date: ' || p_end_date);
106: msd_dem_common_utilities.log_debug('p_prl_code: ' || p_prl_code);
107:
108: msd_dem_common_utilities.log_debug('Executed Statement: ');
109: msd_dem_common_utilities.log_debug(l_stmt);
110:
111: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') );
112: execute immediate l_stmt using p_start_date, p_end_date, p_prl_code ;

Line 109: msd_dem_common_utilities.log_debug(l_stmt);

105: msd_dem_common_utilities.log_debug('p_end_date: ' || p_end_date);
106: msd_dem_common_utilities.log_debug('p_prl_code: ' || p_prl_code);
107:
108: msd_dem_common_utilities.log_debug('Executed Statement: ');
109: msd_dem_common_utilities.log_debug(l_stmt);
110:
111: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') );
112: execute immediate l_stmt using p_start_date, p_end_date, p_prl_code ;
113: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));

Line 111: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') );

107:
108: msd_dem_common_utilities.log_debug('Executed Statement: ');
109: msd_dem_common_utilities.log_debug(l_stmt);
110:
111: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') );
112: execute immediate l_stmt using p_start_date, p_end_date, p_prl_code ;
113: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
114:
115: l_stmt_get_series_id := 'select forecast_type_id from ' || get_lookup_value('MSD_DEM_TABLES', 'COMPUTED_FIELDS') ||

Line 113: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));

109: msd_dem_common_utilities.log_debug(l_stmt);
110:
111: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') );
112: execute immediate l_stmt using p_start_date, p_end_date, p_prl_code ;
113: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
114:
115: l_stmt_get_series_id := 'select forecast_type_id from ' || get_lookup_value('MSD_DEM_TABLES', 'COMPUTED_FIELDS') ||
116: ' where computed_name = ''' || l_column_name || '''';
117:

Line 132: || ' where tq.transfer_id = ' || msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'INTG_INF_EBS_PRICE_LIST', 1, 'id')

128: /* Bug# 8224935 - APP ID */
129: l_stmt := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'TRANSFER_QUERY_SERIES') || ' tqs set tqs.load_option = 0, tqs.purge_option = 0 '
130: || ' where tqs.id = (select tq.id from '
131: || get_lookup_value('MSD_DEM_TABLES', 'TRANSFER_QUERY') || ' tq '
132: || ' where tq.transfer_id = ' || msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'INTG_INF_EBS_PRICE_LIST', 1, 'id')
133: || ') and tqs.series_id = ' || l_series_id;
134:
135: msd_dem_common_utilities.log_debug(l_stmt);
136:

Line 135: msd_dem_common_utilities.log_debug(l_stmt);

131: || get_lookup_value('MSD_DEM_TABLES', 'TRANSFER_QUERY') || ' tq '
132: || ' where tq.transfer_id = ' || msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'INTG_INF_EBS_PRICE_LIST', 1, 'id')
133: || ') and tqs.series_id = ' || l_series_id;
134:
135: msd_dem_common_utilities.log_debug(l_stmt);
136:
137: execute immediate l_stmt;
138: -- syenamar
139:

Line 146: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));

142: null;
143:
144: exception
145: when others then
146: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
147: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
148: retcode := 1;
149:
150: end;

Line 147: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));

143:
144: exception
145: when others then
146: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
147: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
148: retcode := 1;
149:
150: end;
151:

Line 218: msd_dem_common_utilities.log_message('Seeded Display Unit with name ' || p_prl_code || ' exist in Demantra. This Price List will not created');

214:
215: if l_verify_entities_inuse is null then
216:
217: if l_get_seeded_unit is not null then
218: msd_dem_common_utilities.log_message('Seeded Display Unit with name ' || p_prl_code || ' exist in Demantra. This Price List will not created');
219: msd_dem_common_utilities.log_debug('Seeded Display Unit with name ' || p_prl_code || ' exist in Demantra. This Price List will not created');
220: retcode := 1;
221: return;
222: end if;

Line 219: msd_dem_common_utilities.log_debug('Seeded Display Unit with name ' || p_prl_code || ' exist in Demantra. This Price List will not created');

215: if l_verify_entities_inuse is null then
216:
217: if l_get_seeded_unit is not null then
218: msd_dem_common_utilities.log_message('Seeded Display Unit with name ' || p_prl_code || ' exist in Demantra. This Price List will not created');
219: msd_dem_common_utilities.log_debug('Seeded Display Unit with name ' || p_prl_code || ' exist in Demantra. This Price List will not created');
220: retcode := 1;
221: return;
222: end if;
223:

Line 238: msd_dem_common_utilities.log_debug(l_stmt_new_prl_display_unit);

234: ' minus ' ||
235: ' select column_name from msd_dem_entities_inuse where ebs_entity = ''PRL'' )' ||
236: ' and rownum < 2';
237:
238: msd_dem_common_utilities.log_debug(l_stmt_new_prl_display_unit);
239: -- syenamar
240:
241: open get_new_prl_display_unit for l_stmt_new_prl_display_unit;
242: fetch get_new_prl_display_unit into new_prl;

Line 244: msd_dem_common_utilities.log_message('Seeded Display Units for Price List not Available');

240:
241: open get_new_prl_display_unit for l_stmt_new_prl_display_unit;
242: fetch get_new_prl_display_unit into new_prl;
243: if get_new_prl_display_unit%notfound then
244: msd_dem_common_utilities.log_message('Seeded Display Units for Price List not Available');
245: msd_dem_common_utilities.log_debug('Seeded Display Units for Price List not Available');
246: close get_new_prl_display_unit;
247: retcode := 1;
248: return;

Line 245: msd_dem_common_utilities.log_debug('Seeded Display Units for Price List not Available');

241: open get_new_prl_display_unit for l_stmt_new_prl_display_unit;
242: fetch get_new_prl_display_unit into new_prl;
243: if get_new_prl_display_unit%notfound then
244: msd_dem_common_utilities.log_message('Seeded Display Units for Price List not Available');
245: msd_dem_common_utilities.log_debug('Seeded Display Units for Price List not Available');
246: close get_new_prl_display_unit;
247: retcode := 1;
248: return;
249: end if;

Line 257: || ' where tq.transfer_id = ' || msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'INTG_INF_EBS_PRICE_LIST', 1, 'id');

253: /* Bug# 8224935 - APP ID */
254: l_stmt_get_profile_table := 'select tq.table_name from '
255: --|| get_lookup_value('MSD_DEM_TABLES', 'TRANSFER_LIST') || ' tl ' || ' ,'
256: || get_lookup_value('MSD_DEM_TABLES', 'TRANSFER_QUERY') || ' tq '
257: || ' where tq.transfer_id = ' || msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'INTG_INF_EBS_PRICE_LIST', 1, 'id');
258:
259:
260: open get_profile_table for l_stmt_get_profile_table;
261: fetch get_profile_table into l_profile_table_name;

Line 291: msd_dem_common_utilities.log_debug(l_stmt);

287: ,:7
288: ,:8
289: )';
290:
291: msd_dem_common_utilities.log_debug(l_stmt);
292:
293:
294: execute immediate l_stmt using p_prl_code, l_profile_table_name, new_prl.data_field, sysdate, nvl(fnd_global.user_id,-1), sysdate, nvl(fnd_global.user_id,-1), fnd_global.user_id;
295:

Line 300: msd_dem_common_utilities.log_debug(l_stmt);

296: l_stmt := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') ||
297: ' set display_units = :1 ' ||
298: ' where display_units_id = :2';
299:
300: msd_dem_common_utilities.log_debug(l_stmt);
301:
302: execute immediate l_stmt using p_prl_code, new_prl.display_units_id;
303:
304: -- syenamar

Line 317: msd_dem_common_utilities.log_debug(l_stmt);

313: ' from ' || get_lookup_value('MSD_DEM_TABLES', 'AVAIL_UNITS') ||
314: ' where display_units_id = :2 ' ||
315: ' )';
316:
317: msd_dem_common_utilities.log_debug(l_stmt);
318:
319: execute immediate l_stmt using new_prl.display_units_id, new_prl.display_units_id;
320: -- syenamar
321:

Line 322: /*l_stmt_get_component := 'select dcm_product_id from ' ||get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS') || ' where product_name = ''' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_COMPONENTS', 'DEMAND_MANAGEMENT') || '''';

318:
319: execute immediate l_stmt using new_prl.display_units_id, new_prl.display_units_id;
320: -- syenamar
321:
322: /*l_stmt_get_component := 'select dcm_product_id from ' ||get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS') || ' where product_name = ''' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_COMPONENTS', 'DEMAND_MANAGEMENT') || '''';
323:
324: msd_dem_common_utilities.log_debug(l_stmt_get_component);
325:
326: open get_component for l_stmt_get_component;

Line 324: msd_dem_common_utilities.log_debug(l_stmt_get_component);

320: -- syenamar
321:
322: /*l_stmt_get_component := 'select dcm_product_id from ' ||get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS') || ' where product_name = ''' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_COMPONENTS', 'DEMAND_MANAGEMENT') || '''';
323:
324: msd_dem_common_utilities.log_debug(l_stmt_get_component);
325:
326: open get_component for l_stmt_get_component;
327: fetch get_component into l_component_id;
328: close get_component;*/

Line 331: l_component_id := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'COMP_DM', 1, 'dcm_product_id'));

327: fetch get_component into l_component_id;
328: close get_component;*/
329:
330: /* Bug# 8224935 - APP ID */
331: l_component_id := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'COMP_DM', 1, 'dcm_product_id'));
332: l_stmt := 'insert into ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') ||
333: ' (dcm_product_id ,display_units_id) ' ||
334: ' (select :1, :2 from dual)';
335:

Line 336: msd_dem_common_utilities.log_debug(l_stmt);

332: l_stmt := 'insert into ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') ||
333: ' (dcm_product_id ,display_units_id) ' ||
334: ' (select :1, :2 from dual)';
335:
336: msd_dem_common_utilities.log_debug(l_stmt);
337: execute immediate l_stmt using l_component_id,new_prl.display_units_id;
338:
339: l_stmt := 'insert into ' || get_lookup_value('MSD_DEM_TABLES', 'INDEXES_FOR_UNITS') ||
340: ' (display_units_id, real_value_id) ' ||

Line 345: msd_dem_common_utilities.log_debug(l_stmt);

341: ' (select :1, real_value_id from ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_INDEX') || ' dpi ' ||
342: ' where dpi.dcm_product_id = ' || l_component_id ||
343: ')';
344:
345: msd_dem_common_utilities.log_debug(l_stmt);
346:
347: execute immediate l_stmt using new_prl.display_units_id;
348:
349:

Line 351: /*l_stmt_get_component_sop := 'select dcm_product_id from ' ||get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS') || ' where product_name = ''' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_COMPONENTS', 'SOP') || '''';

347: execute immediate l_stmt using new_prl.display_units_id;
348:
349:
350:
351: /*l_stmt_get_component_sop := 'select dcm_product_id from ' ||get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS') || ' where product_name = ''' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_COMPONENTS', 'SOP') || '''';
352:
353: msd_dem_common_utilities.log_debug(l_stmt_get_component_sop);
354:
355: open get_component_sop for l_stmt_get_component_sop;

Line 353: msd_dem_common_utilities.log_debug(l_stmt_get_component_sop);

349:
350:
351: /*l_stmt_get_component_sop := 'select dcm_product_id from ' ||get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS') || ' where product_name = ''' || msd_dem_common_utilities.get_lookup_value('MSD_DEM_COMPONENTS', 'SOP') || '''';
352:
353: msd_dem_common_utilities.log_debug(l_stmt_get_component_sop);
354:
355: open get_component_sop for l_stmt_get_component_sop;
356: fetch get_component_sop into l_component_id_sop;
357: close get_component_sop;*/

Line 360: l_component_id_sop := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'COMP_SOP', 1, 'dcm_product_id'));

356: fetch get_component_sop into l_component_id_sop;
357: close get_component_sop;*/
358:
359: /* Bug# 8224935 - APP ID */
360: l_component_id_sop := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'COMP_SOP', 1, 'dcm_product_id'));
361: l_stmt := 'insert into ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') ||
362: ' (dcm_product_id ,display_units_id) ' ||
363: ' (select :1, :2 from dual)';
364:

Line 365: msd_dem_common_utilities.log_debug(l_stmt);

361: l_stmt := 'insert into ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') ||
362: ' (dcm_product_id ,display_units_id) ' ||
363: ' (select :1, :2 from dual)';
364:
365: msd_dem_common_utilities.log_debug(l_stmt);
366: execute immediate l_stmt using l_component_id_sop,new_prl.display_units_id;
367: --syenamar
368:
369: l_stmt := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'COMPUTED_FIELDS')

Line 382: msd_dem_common_utilities.log_debug(l_stmt);

378: l_stmt := 'update msd_dem_entities_inuse set table_name = ''biio_ebs_price_list''' ||
379: ', column_name = (select data_field from ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') || ' where display_units = :1)' ||
380: 'where ebs_entity = ''PRL'' and demantra_entity = ''DISPLAY_UNIT'' and internal_name = :2';
381:
382: msd_dem_common_utilities.log_debug(l_stmt);
383:
384: execute immediate l_stmt using p_prl_code, p_prl_code; */
385:
386: end if;

Line 392: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));

388:
389:
390: exception
391: when others then
392: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
393: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
394: retcode := 1;
395:
396: end;

Line 393: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));

389:
390: exception
391: when others then
392: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
393: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
394: retcode := 1;
395:
396: end;
397:

Line 425: || ' where tq.transfer_id = ' || msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'INTG_INF_EBS_PRICE_LIST', 1, 'id')

421: /* Bug# 8224935 - APP ID */
422: l_stmt := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'TRANSFER_QUERY_SERIES') || ' tqs set tqs.load_option = 2, tqs.purge_option = 0 '
423: || ' where tqs.id = (select tq.id from '
424: || get_lookup_value('MSD_DEM_TABLES', 'TRANSFER_QUERY') || ' tq '
425: || ' where tq.transfer_id = ' || msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'INTG_INF_EBS_PRICE_LIST', 1, 'id')
426: || ')';
427:
428: msd_dem_common_utilities.log_debug(l_stmt);
429:

Line 428: msd_dem_common_utilities.log_debug(l_stmt);

424: || get_lookup_value('MSD_DEM_TABLES', 'TRANSFER_QUERY') || ' tq '
425: || ' where tq.transfer_id = ' || msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'INTG_INF_EBS_PRICE_LIST', 1, 'id')
426: || ')';
427:
428: msd_dem_common_utilities.log_debug(l_stmt);
429:
430: execute immediate l_stmt;-- using fnd_profile.value('MSD_DEM_PRICE_LIST_PROFILE');
431: -- syenamar
432:

Line 474: msd_dem_common_utilities.log_message('Populating Price List: ' || l_prl_code);

470:
471: fetch get_prl_code into l_prl_code;
472: exit when get_prl_code%notfound;
473:
474: msd_dem_common_utilities.log_message('Populating Price List: ' || l_prl_code);
475: msd_dem_common_utilities.log_debug('Populating Price List: ' || l_prl_code);
476:
477: l_list2 := replace(l_list2, l_prl_code||',' , '');
478:

Line 475: msd_dem_common_utilities.log_debug('Populating Price List: ' || l_prl_code);

471: fetch get_prl_code into l_prl_code;
472: exit when get_prl_code%notfound;
473:
474: msd_dem_common_utilities.log_message('Populating Price List: ' || l_prl_code);
475: msd_dem_common_utilities.log_debug('Populating Price List: ' || l_prl_code);
476:
477: l_list2 := replace(l_list2, l_prl_code||',' , '');
478:
479: process_prl(retcode, l_prl_code);

Line 482: msd_dem_common_utilities.log_message('Failed processing Price List: ' || l_prl_code);

478:
479: process_prl(retcode, l_prl_code);
480:
481: if retcode = -1 or retcode = 1 then
482: msd_dem_common_utilities.log_message('Failed processing Price List: ' || l_prl_code);
483: msd_dem_common_utilities.log_debug('Failed Processing Price List: ' || l_prl_code);
484: was_retcode_1 := retcode;
485: goto continue;
486: end if;

Line 483: msd_dem_common_utilities.log_debug('Failed Processing Price List: ' || l_prl_code);

479: process_prl(retcode, l_prl_code);
480:
481: if retcode = -1 or retcode = 1 then
482: msd_dem_common_utilities.log_message('Failed processing Price List: ' || l_prl_code);
483: msd_dem_common_utilities.log_debug('Failed Processing Price List: ' || l_prl_code);
484: was_retcode_1 := retcode;
485: goto continue;
486: end if;
487:

Line 507: msd_dem_common_utilities.log_message('Following Price Lists dont exist in source: ' || l_list2);

503: l_list2 := rtrim(l_list2, ',');
504:
505: if l_list2 is not null then
506: retcode := 1;
507: msd_dem_common_utilities.log_message('Following Price Lists dont exist in source: ' || l_list2);
508: msd_dem_common_utilities.log_debug('Following Price Lists dont exist in source: ' || l_list2);
509: end if;
510:
511:

Line 508: msd_dem_common_utilities.log_debug('Following Price Lists dont exist in source: ' || l_list2);

504:
505: if l_list2 is not null then
506: retcode := 1;
507: msd_dem_common_utilities.log_message('Following Price Lists dont exist in source: ' || l_list2);
508: msd_dem_common_utilities.log_debug('Following Price Lists dont exist in source: ' || l_list2);
509: end if;
510:
511:
512: exception

Line 514: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));

510:
511:
512: exception
513: when others then
514: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
515: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
516: retcode := 1;
517:
518: end;

Line 515: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));

511:
512: exception
513: when others then
514: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
515: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
516: retcode := 1;
517:
518: end;
519:

Line 576: msd_dem_common_utilities.log_message('The following price list names are not collected as they dont exist in the price list form or excluded by the user: ' || unacc_list);

572: unacc_list := rtrim(unacc_list, ',');
573: unacc_list := replace(unacc_list, '''', '');
574:
575: if unacc_list is not null then
576: msd_dem_common_utilities.log_message('The following price list names are not collected as they dont exist in the price list form or excluded by the user: ' || unacc_list);
577: msd_dem_common_utilities.log_debug('The following price list names are not collected as they dont exist in the price list form or excluded by the user: ' || unacc_list);
578:
579: if acc_list is not null then
580: retcode := 1;

Line 577: msd_dem_common_utilities.log_debug('The following price list names are not collected as they dont exist in the price list form or excluded by the user: ' || unacc_list);

573: unacc_list := replace(unacc_list, '''', '');
574:
575: if unacc_list is not null then
576: msd_dem_common_utilities.log_message('The following price list names are not collected as they dont exist in the price list form or excluded by the user: ' || unacc_list);
577: msd_dem_common_utilities.log_debug('The following price list names are not collected as they dont exist in the price list form or excluded by the user: ' || unacc_list);
578:
579: if acc_list is not null then
580: retcode := 1;
581: else

Line 592: msd_dem_common_utilities.log_message('In filter_from_list procedure - retcode: '|| retcode);-- nallkuma bug#13857980

588:
589: if retcode <> -1 and retcode <> 1 then
590: retcode := 0;
591: end if;
592: msd_dem_common_utilities.log_message('In filter_from_list procedure - retcode: '|| retcode);-- nallkuma bug#13857980
593:
594: exception
595: when others then
596: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));

Line 596: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));

592: msd_dem_common_utilities.log_message('In filter_from_list procedure - retcode: '|| retcode);-- nallkuma bug#13857980
593:
594: exception
595: when others then
596: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
597: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
598: retcode := -1;
599:
600: end;

Line 597: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));

593:
594: exception
595: when others then
596: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
597: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
598: retcode := -1;
599:
600: end;
601:

Line 633: msd_dem_common_utilities.log_message('Price list collection cannot continue as no price lists are selected in the price list form');

629: filter_from_list(errbuf, retcode, p_instance_id, p_include_prl_list, p_exclude_prl_list);
630:
631:
632: if retcode = -1 then
633: msd_dem_common_utilities.log_message('Price list collection cannot continue as no price lists are selected in the price list form');
634: msd_dem_common_utilities.log_debug('Price list collection cannot continue as no price lists are selected in the price list form');
635: retcode := -1;
636: return;
637: end if;

Line 634: msd_dem_common_utilities.log_debug('Price list collection cannot continue as no price lists are selected in the price list form');

630:
631:
632: if retcode = -1 then
633: msd_dem_common_utilities.log_message('Price list collection cannot continue as no price lists are selected in the price list form');
634: msd_dem_common_utilities.log_debug('Price list collection cannot continue as no price lists are selected in the price list form');
635: retcode := -1;
636: return;
637: end if;
638:

Line 640: msd_dem_common_utilities.log_message('Include Price List does not contain any price list among the price lists, which are selected in the price list form.');

636: return;
637: end if;
638:
639: if retcode = 0 then
640: msd_dem_common_utilities.log_message('Include Price List does not contain any price list among the price lists, which are selected in the price list form.');
641: msd_dem_common_utilities.log_debug('Include Price List does not contain any price list among the price lists, which are selected in the price list form.');
642: retcode := 0;
643: return;
644: end if;

Line 641: msd_dem_common_utilities.log_debug('Include Price List does not contain any price list among the price lists, which are selected in the price list form.');

637: end if;
638:
639: if retcode = 0 then
640: msd_dem_common_utilities.log_message('Include Price List does not contain any price list among the price lists, which are selected in the price list form.');
641: msd_dem_common_utilities.log_debug('Include Price List does not contain any price list among the price lists, which are selected in the price list form.');
642: retcode := 0;
643: return;
644: end if;
645:

Line 680: msd_dem_common_utilities.log_debug('Bind variables: ');

676: l_key_values,
677: 0,
678: null);
679:
680: msd_dem_common_utilities.log_debug('Bind variables: ');
681: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
682: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
683:
684: msd_dem_common_utilities.log_debug('Executed Statement: ');

Line 681: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);

677: 0,
678: null);
679:
680: msd_dem_common_utilities.log_debug('Bind variables: ');
681: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
682: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
683:
684: msd_dem_common_utilities.log_debug('Executed Statement: ');
685: msd_dem_common_utilities.log_debug(l_stmt);

Line 682: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);

678: null);
679:
680: msd_dem_common_utilities.log_debug('Bind variables: ');
681: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
682: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
683:
684: msd_dem_common_utilities.log_debug('Executed Statement: ');
685: msd_dem_common_utilities.log_debug(l_stmt);
686:

Line 684: msd_dem_common_utilities.log_debug('Executed Statement: ');

680: msd_dem_common_utilities.log_debug('Bind variables: ');
681: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
682: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
683:
684: msd_dem_common_utilities.log_debug('Executed Statement: ');
685: msd_dem_common_utilities.log_debug(l_stmt);
686:
687: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
688: execute immediate l_stmt;

Line 685: msd_dem_common_utilities.log_debug(l_stmt);

681: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
682: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
683:
684: msd_dem_common_utilities.log_debug('Executed Statement: ');
685: msd_dem_common_utilities.log_debug(l_stmt);
686:
687: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
688: execute immediate l_stmt;
689: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));

Line 687: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));

683:
684: msd_dem_common_utilities.log_debug('Executed Statement: ');
685: msd_dem_common_utilities.log_debug(l_stmt);
686:
687: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
688: execute immediate l_stmt;
689: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
690: msd_dem_common_utilities.log_message('In collect_from_source procedure - retcode: '|| retcode);-- nallkuma bug#13857980
691:

Line 689: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));

685: msd_dem_common_utilities.log_debug(l_stmt);
686:
687: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
688: execute immediate l_stmt;
689: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
690: msd_dem_common_utilities.log_message('In collect_from_source procedure - retcode: '|| retcode);-- nallkuma bug#13857980
691:
692: exception
693: when others then

Line 690: msd_dem_common_utilities.log_message('In collect_from_source procedure - retcode: '|| retcode);-- nallkuma bug#13857980

686:
687: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
688: execute immediate l_stmt;
689: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
690: msd_dem_common_utilities.log_message('In collect_from_source procedure - retcode: '|| retcode);-- nallkuma bug#13857980
691:
692: exception
693: when others then
694: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));

Line 694: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));

690: msd_dem_common_utilities.log_message('In collect_from_source procedure - retcode: '|| retcode);-- nallkuma bug#13857980
691:
692: exception
693: when others then
694: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
695: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
696: retcode := -1;
697:
698: end;

Line 695: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));

691:
692: exception
693: when others then
694: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
695: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
696: retcode := -1;
697:
698: end;
699:

Line 742: msd_dem_common_utilities.log_message('Push Setup Parameters Failed');

738: -- bug#8367471 nallkuma
739: if l_instance_type in (1,2,4) then
740: msd_dem_push_setup_parameters.push_setup_parameters(ERRBUF, RETCODE, p_instance_id, '-999');
741: if retcode = -1 then
742: msd_dem_common_utilities.log_message('Push Setup Parameters Failed');
743: msd_dem_common_utilities.log_debug('Push Setup Parameters Failed');
744: return;
745: end if;
746: else

Line 743: msd_dem_common_utilities.log_debug('Push Setup Parameters Failed');

739: if l_instance_type in (1,2,4) then
740: msd_dem_push_setup_parameters.push_setup_parameters(ERRBUF, RETCODE, p_instance_id, '-999');
741: if retcode = -1 then
742: msd_dem_common_utilities.log_message('Push Setup Parameters Failed');
743: msd_dem_common_utilities.log_debug('Push Setup Parameters Failed');
744: return;
745: end if;
746: else
747: /* Calling push_legacy_setup_parameters() procedure in case of pure legacy instance */

Line 750: msd_dem_common_utilities.log_message('Push Legacy Setup Parameters Failed');

746: else
747: /* Calling push_legacy_setup_parameters() procedure in case of pure legacy instance */
748: msd_dem_push_setup_parameters.push_legacy_setup_parameters(ERRBUF, RETCODE, p_instance_id);
749: if retcode = -1 then
750: msd_dem_common_utilities.log_message('Push Legacy Setup Parameters Failed');
751: msd_dem_common_utilities.log_debug('Push Legacy Setup Parameters Failed');
752: return;
753: end if;
754: end if;

Line 751: msd_dem_common_utilities.log_debug('Push Legacy Setup Parameters Failed');

747: /* Calling push_legacy_setup_parameters() procedure in case of pure legacy instance */
748: msd_dem_push_setup_parameters.push_legacy_setup_parameters(ERRBUF, RETCODE, p_instance_id);
749: if retcode = -1 then
750: msd_dem_common_utilities.log_message('Push Legacy Setup Parameters Failed');
751: msd_dem_common_utilities.log_debug('Push Legacy Setup Parameters Failed');
752: return;
753: end if;
754: end if;
755:

Line 758: msd_dem_common_utilities.log_message('Cannot specify both collect all and include or exclude list');

754: end if;
755:
756:
757: if p_include_all = 1 and (p_include_prl_list is not null or p_exclude_prl_list is not null) then
758: msd_dem_common_utilities.log_message('Cannot specify both collect all and include or exclude list');
759: msd_dem_common_utilities.log_debug('Cannot specify both collect all and include or exclude list');
760: retcode := -1;
761: return;
762: end if;

Line 759: msd_dem_common_utilities.log_debug('Cannot specify both collect all and include or exclude list');

755:
756:
757: if p_include_all = 1 and (p_include_prl_list is not null or p_exclude_prl_list is not null) then
758: msd_dem_common_utilities.log_message('Cannot specify both collect all and include or exclude list');
759: msd_dem_common_utilities.log_debug('Cannot specify both collect all and include or exclude list');
760: retcode := -1;
761: return;
762: end if;
763:

Line 766: msd_dem_common_utilities.log_message('Exactly one of the parameters Include Price Lists or Exclude Price Lists must be specified, when Collect All Price Lists is No');

762: end if;
763:
764: if p_include_all = 2 and p_include_prl_list is null and p_exclude_prl_list is null then
765:
766: msd_dem_common_utilities.log_message('Exactly one of the parameters Include Price Lists or Exclude Price Lists must be specified, when Collect All Price Lists is No');
767: msd_dem_common_utilities.log_debug('Exactly one of the parameters Include Price Lists or Exclude Price Lists must be specified, when Collect All Price Lists is No');
768: retcode := -1;
769: return;
770:

Line 767: msd_dem_common_utilities.log_debug('Exactly one of the parameters Include Price Lists or Exclude Price Lists must be specified, when Collect All Price Lists is No');

763:
764: if p_include_all = 2 and p_include_prl_list is null and p_exclude_prl_list is null then
765:
766: msd_dem_common_utilities.log_message('Exactly one of the parameters Include Price Lists or Exclude Price Lists must be specified, when Collect All Price Lists is No');
767: msd_dem_common_utilities.log_debug('Exactly one of the parameters Include Price Lists or Exclude Price Lists must be specified, when Collect All Price Lists is No');
768: retcode := -1;
769: return;
770:
771: end if;

Line 775: msd_dem_common_utilities.log_message('Should not specify both include and exclude list');

771: end if;
772:
773: if p_include_all = 2 and p_include_prl_list is not null and p_exclude_prl_list is not null then
774:
775: msd_dem_common_utilities.log_message('Should not specify both include and exclude list');
776: msd_dem_common_utilities.log_debug('Should not specify both include and exclude list');
777: retcode := -1;
778: return;
779:

Line 776: msd_dem_common_utilities.log_debug('Should not specify both include and exclude list');

772:
773: if p_include_all = 2 and p_include_prl_list is not null and p_exclude_prl_list is not null then
774:
775: msd_dem_common_utilities.log_message('Should not specify both include and exclude list');
776: msd_dem_common_utilities.log_debug('Should not specify both include and exclude list');
777: retcode := -1;
778: return;
779:
780: end if;

Line 783: msd_dem_common_utilities.log_message('From Date should not be greater than To Date');

779:
780: end if;
781:
782: if nvl(fnd_date.canonical_to_date(p_start_date), to_date('01-01-1900', 'DD-MM-YYYY')) > nvl(fnd_date.canonical_to_date(p_end_date), to_date('01-01-4000', 'DD-MM-YYYY')) then
783: msd_dem_common_utilities.log_message('From Date should not be greater than To Date');
784: msd_dem_common_utilities.log_debug('From Date should not be greater than To Date');
785: retcode := -1;
786: return;
787: end if;

Line 784: msd_dem_common_utilities.log_debug('From Date should not be greater than To Date');

780: end if;
781:
782: if nvl(fnd_date.canonical_to_date(p_start_date), to_date('01-01-1900', 'DD-MM-YYYY')) > nvl(fnd_date.canonical_to_date(p_end_date), to_date('01-01-4000', 'DD-MM-YYYY')) then
783: msd_dem_common_utilities.log_message('From Date should not be greater than To Date');
784: msd_dem_common_utilities.log_debug('From Date should not be greater than To Date');
785: retcode := -1;
786: return;
787: end if;
788:

Line 789: msd_dem_common_utilities.log_message('Collecting Price Lists');

785: retcode := -1;
786: return;
787: end if;
788:
789: msd_dem_common_utilities.log_message('Collecting Price Lists');
790: msd_dem_common_utilities.log_debug('Collecting Price Lists');
791:
792: msd_dem_common_utilities.log_message('Collecting Price Lists from source');
793: msd_dem_common_utilities.log_debug('Collecting Price Lists from source');

Line 790: msd_dem_common_utilities.log_debug('Collecting Price Lists');

786: return;
787: end if;
788:
789: msd_dem_common_utilities.log_message('Collecting Price Lists');
790: msd_dem_common_utilities.log_debug('Collecting Price Lists');
791:
792: msd_dem_common_utilities.log_message('Collecting Price Lists from source');
793: msd_dem_common_utilities.log_debug('Collecting Price Lists from source');
794: collect_from_source(errbuf, retcode, p_instance_id, p_include_prl_list, p_exclude_prl_list);

Line 792: msd_dem_common_utilities.log_message('Collecting Price Lists from source');

788:
789: msd_dem_common_utilities.log_message('Collecting Price Lists');
790: msd_dem_common_utilities.log_debug('Collecting Price Lists');
791:
792: msd_dem_common_utilities.log_message('Collecting Price Lists from source');
793: msd_dem_common_utilities.log_debug('Collecting Price Lists from source');
794: collect_from_source(errbuf, retcode, p_instance_id, p_include_prl_list, p_exclude_prl_list);
795:
796: if retcode = -1 then

Line 793: msd_dem_common_utilities.log_debug('Collecting Price Lists from source');

789: msd_dem_common_utilities.log_message('Collecting Price Lists');
790: msd_dem_common_utilities.log_debug('Collecting Price Lists');
791:
792: msd_dem_common_utilities.log_message('Collecting Price Lists from source');
793: msd_dem_common_utilities.log_debug('Collecting Price Lists from source');
794: collect_from_source(errbuf, retcode, p_instance_id, p_include_prl_list, p_exclude_prl_list);
795:
796: if retcode = -1 then
797: return;

Line 802: msd_dem_common_utilities.log_message('Populating Price Lists in Demand Planning components');

798: end if;
799:
800: retcode_store := retcode;
801:
802: msd_dem_common_utilities.log_message('Populating Price Lists in Demand Planning components');
803: msd_dem_common_utilities.log_debug('Populating Price Lists in Demand Planning components');
804: populate_demantra_prl_table(errbuf, retcode, p_instance_id, p_include_prl_list, p_exclude_prl_list, nvl(fnd_date.canonical_to_date(p_start_date),
805: to_date('01-01-1900', 'DD-MM-YYYY')), nvl(fnd_date.canonical_to_date(p_end_date), to_date('01-01-4000', 'DD-MM-YYYY')));
806:

Line 803: msd_dem_common_utilities.log_debug('Populating Price Lists in Demand Planning components');

799:
800: retcode_store := retcode;
801:
802: msd_dem_common_utilities.log_message('Populating Price Lists in Demand Planning components');
803: msd_dem_common_utilities.log_debug('Populating Price Lists in Demand Planning components');
804: populate_demantra_prl_table(errbuf, retcode, p_instance_id, p_include_prl_list, p_exclude_prl_list, nvl(fnd_date.canonical_to_date(p_start_date),
805: to_date('01-01-1900', 'DD-MM-YYYY')), nvl(fnd_date.canonical_to_date(p_end_date), to_date('01-01-4000', 'DD-MM-YYYY')));
806:
807: commit;

Line 816: || ' WHERE tq.transfer_id = ' || msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'INTG_INF_EBS_PRICE_LIST', 1, 'id');

812:
813: /* Bug# 8224935 - APP ID */
814: x_stmt:= 'SELECT tq.id FROM '
815: || get_lookup_value('MSD_DEM_TABLES', 'TRANSFER_QUERY') || ' tq '
816: || ' WHERE tq.transfer_id = ' || msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'INTG_INF_EBS_PRICE_LIST', 1, 'id');
817:
818: msd_dem_common_utilities.log_debug ('Get data profile id stmt : ' || x_stmt);
819: EXECUTE IMMEDIATE x_stmt INTO x_profile_id;
820: -- syenamar

Line 818: msd_dem_common_utilities.log_debug ('Get data profile id stmt : ' || x_stmt);

814: x_stmt:= 'SELECT tq.id FROM '
815: || get_lookup_value('MSD_DEM_TABLES', 'TRANSFER_QUERY') || ' tq '
816: || ' WHERE tq.transfer_id = ' || msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'INTG_INF_EBS_PRICE_LIST', 1, 'id');
817:
818: msd_dem_common_utilities.log_debug ('Get data profile id stmt : ' || x_stmt);
819: EXECUTE IMMEDIATE x_stmt INTO x_profile_id;
820: -- syenamar
821:
822: x_stmt := 'BEGIN '

Line 828: msd_dem_common_utilities.log_debug ('Refresh data profile stmt : ' || x_stmt);

824: || 'API_NOTIFY_APS_INTEGRATION('
825: || x_profile_id
826: ||'); end;';
827:
828: msd_dem_common_utilities.log_debug ('Refresh data profile stmt : ' || x_stmt);
829: EXECUTE IMMEDIATE x_stmt;
830:
831: EXCEPTION
832: WHEN OTHERS THEN

Line 833: msd_dem_common_utilities.log_message('WARNING: Failed to update the price list data profile');

829: EXECUTE IMMEDIATE x_stmt;
830:
831: EXCEPTION
832: WHEN OTHERS THEN
833: msd_dem_common_utilities.log_message('WARNING: Failed to update the price list data profile');
834: END;
835:
836: commit;
837:

Line 838: msd_dem_common_utilities.log_message('In collect_price_lists procedure - retcode: '|| retcode);-- nallkuma bug#13857980

834: END;
835:
836: commit;
837:
838: msd_dem_common_utilities.log_message('In collect_price_lists procedure - retcode: '|| retcode);-- nallkuma bug#13857980
839:
840: if retcode <> -1 and retcode <> 1 then
841: retcode := 0;
842: end if;

Line 861: msd_dem_common_utilities.log_debug('Begin - CTO Price');

857: /* CTO - One of the EBS Price List should also be loaded into CTO Data */
858: IF (fnd_profile.value('MSD_DEM_INCLUDE_DEPENDENT_DEMAND') = 1)
859: THEN
860:
861: msd_dem_common_utilities.log_debug('Begin - CTO Price');
862:
863: /* Get the price list column that should be used to copy from MSD_DEM_PRICE_LIST */
864:
865: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');

Line 868: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '

864:
865: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');
866: IF (x_schema IS NULL)
867: THEN
868: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '
869: || ' Unable to get Demantra schema name ');
870: retcode := -1;
871: RETURN;
872: END IF;

Line 876: || ' WHERE ' || msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'SERIES_UNIT_PRICE', 2, null);

872: END IF;
873:
874: /* Bug# 8224935 - APP ID */
875: x_stmt := 'SELECT dbname FROM ' || x_schema || '.computed_fields '
876: || ' WHERE ' || msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'SERIES_UNIT_PRICE', 2, null);
877: msd_dem_common_utilities.log_debug (x_stmt);
878:
879: EXECUTE IMMEDIATE x_stmt INTO x_price_list_col;
880:

Line 877: msd_dem_common_utilities.log_debug (x_stmt);

873:
874: /* Bug# 8224935 - APP ID */
875: x_stmt := 'SELECT dbname FROM ' || x_schema || '.computed_fields '
876: || ' WHERE ' || msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'SERIES_UNIT_PRICE', 2, null);
877: msd_dem_common_utilities.log_debug (x_stmt);
878:
879: EXECUTE IMMEDIATE x_stmt INTO x_price_list_col;
880:
881: IF (x_price_list_col IS NULL)

Line 883: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '

879: EXECUTE IMMEDIATE x_stmt INTO x_price_list_col;
880:
881: IF (x_price_list_col IS NULL)
882: THEN
883: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '
884: || ' Price List Column name is null ');
885: retcode := -1;
886: RETURN;
887: END IF;

Line 889: msd_dem_common_utilities.log_debug('Truncate staging table for cto price - BIIO_CTO_OPTION_PRICE ');

885: retcode := -1;
886: RETURN;
887: END IF;
888:
889: msd_dem_common_utilities.log_debug('Truncate staging table for cto price - BIIO_CTO_OPTION_PRICE ');
890: msd_dem_query_utilities.truncate_table (
891: x_errbuf,
892: x_retcode,
893: 'BIIO_CTO_OPTION_PRICE',

Line 898: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '

894: 1,
895: 1);
896: IF (x_retcode = -1)
897: THEN
898: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '
899: || ' Failed to truncate BIIO_CTO_OPTION_PRICE');
900: retcode := -1;
901: errbuf := x_errbuf;
902: RETURN;

Line 905: msd_dem_common_utilities.log_debug('Truncate staging table for cto price - BIIO_CTO_OPTION_PRICE_ERR ');

901: errbuf := x_errbuf;
902: RETURN;
903: END IF;
904:
905: msd_dem_common_utilities.log_debug('Truncate staging table for cto price - BIIO_CTO_OPTION_PRICE_ERR ');
906: msd_dem_query_utilities.truncate_table (
907: x_errbuf,
908: x_retcode,
909: 'BIIO_CTO_OPTION_PRICE_ERR',

Line 914: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '

910: 1,
911: 1);
912: IF (x_retcode = -1)
913: THEN
914: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '
915: || ' Failed to truncate BIIO_CTO_OPTION_PRICE_ERR');
916: retcode := -1;
917: errbuf := x_errbuf;
918: RETURN;

Line 931: msd_dem_common_utilities.log_debug (x_stmt);

927: || x_price_list_col || ' '
928: || ' FROM ' || x_schema || '.MSD_DEM_PRICE_LIST '
929: || ' WHERE ' || x_price_list_col || ' IS NOT NULL ';
930:
931: msd_dem_common_utilities.log_debug (x_stmt);
932: msd_dem_common_utilities.log_debug ('Query start time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
933: EXECUTE IMMEDIATE x_stmt;
934: x_num_rows := SQL%ROWCOUNT;
935: COMMIT;

Line 932: msd_dem_common_utilities.log_debug ('Query start time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

928: || ' FROM ' || x_schema || '.MSD_DEM_PRICE_LIST '
929: || ' WHERE ' || x_price_list_col || ' IS NOT NULL ';
930:
931: msd_dem_common_utilities.log_debug (x_stmt);
932: msd_dem_common_utilities.log_debug ('Query start time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
933: EXECUTE IMMEDIATE x_stmt;
934: x_num_rows := SQL%ROWCOUNT;
935: COMMIT;
936: msd_dem_common_utilities.log_debug ('Query end time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

Line 936: msd_dem_common_utilities.log_debug ('Query end time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

932: msd_dem_common_utilities.log_debug ('Query start time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
933: EXECUTE IMMEDIATE x_stmt;
934: x_num_rows := SQL%ROWCOUNT;
935: COMMIT;
936: msd_dem_common_utilities.log_debug ('Query end time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
937: msd_dem_common_utilities.log_debug ('Number of rows inserted - ' || to_char(x_num_rows));
938:
939: msd_dem_common_utilities.log_debug('End - CTO Price');
940:

Line 937: msd_dem_common_utilities.log_debug ('Number of rows inserted - ' || to_char(x_num_rows));

933: EXECUTE IMMEDIATE x_stmt;
934: x_num_rows := SQL%ROWCOUNT;
935: COMMIT;
936: msd_dem_common_utilities.log_debug ('Query end time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
937: msd_dem_common_utilities.log_debug ('Number of rows inserted - ' || to_char(x_num_rows));
938:
939: msd_dem_common_utilities.log_debug('End - CTO Price');
940:
941: ELSE

Line 939: msd_dem_common_utilities.log_debug('End - CTO Price');

935: COMMIT;
936: msd_dem_common_utilities.log_debug ('Query end time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
937: msd_dem_common_utilities.log_debug ('Number of rows inserted - ' || to_char(x_num_rows));
938:
939: msd_dem_common_utilities.log_debug('End - CTO Price');
940:
941: ELSE
942: msd_dem_common_utilities.log_debug ('msd_dem_collect_price_lists.collect_price_lists - INFO - '
943: || 'Include Dependent Demand is set to No. Hence no action taken for CTO Price');

Line 942: msd_dem_common_utilities.log_debug ('msd_dem_collect_price_lists.collect_price_lists - INFO - '

938:
939: msd_dem_common_utilities.log_debug('End - CTO Price');
940:
941: ELSE
942: msd_dem_common_utilities.log_debug ('msd_dem_collect_price_lists.collect_price_lists - INFO - '
943: || 'Include Dependent Demand is set to No. Hence no action taken for CTO Price');
944: END IF;
945:
946: /* Populate Scenario Price Staging Table if present */

Line 953: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR(2) - '

949: x_price_list_col := NULL;
950: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');
951: IF (x_schema IS NULL)
952: THEN
953: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR(2) - '
954: || ' Unable to get Demantra schema name ');
955: retcode := -1;
956: RETURN;
957: END IF;

Line 961: msd_dem_common_utilities.log_debug (x_stmt);

957: END IF;
958:
959: x_stmt := 'SELECT count(1) FROM dba_objects WHERE owner = upper(''' || x_schema || ''') AND object_type = ''TABLE'' '
960: || ' AND object_name IN (''BIIO_SCENARIO_PRICE'', ''BIIO_SCENARIO_PRICE_ERR'') ';
961: msd_dem_common_utilities.log_debug (x_stmt);
962: EXECUTE IMMEDIATE x_stmt INTO x_num_rows;
963:
964: IF (x_num_rows = 2)
965: THEN

Line 967: msd_dem_common_utilities.log_debug('Begin - Scenario Price');

963:
964: IF (x_num_rows = 2)
965: THEN
966:
967: msd_dem_common_utilities.log_debug('Begin - Scenario Price');
968:
969: /* Get the price list column that should be used to copy from MSD_DEM_PRICE_LIST */
970: x_stmt := 'SELECT dbname FROM ' || x_schema || '.computed_fields '
971: || ' WHERE ' || msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'SERIES_UNIT_PRICE', 2, null);

Line 971: || ' WHERE ' || msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'SERIES_UNIT_PRICE', 2, null);

967: msd_dem_common_utilities.log_debug('Begin - Scenario Price');
968:
969: /* Get the price list column that should be used to copy from MSD_DEM_PRICE_LIST */
970: x_stmt := 'SELECT dbname FROM ' || x_schema || '.computed_fields '
971: || ' WHERE ' || msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'SERIES_UNIT_PRICE', 2, null);
972: msd_dem_common_utilities.log_debug (x_stmt);
973:
974: EXECUTE IMMEDIATE x_stmt INTO x_price_list_col;
975:

Line 972: msd_dem_common_utilities.log_debug (x_stmt);

968:
969: /* Get the price list column that should be used to copy from MSD_DEM_PRICE_LIST */
970: x_stmt := 'SELECT dbname FROM ' || x_schema || '.computed_fields '
971: || ' WHERE ' || msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'SERIES_UNIT_PRICE', 2, null);
972: msd_dem_common_utilities.log_debug (x_stmt);
973:
974: EXECUTE IMMEDIATE x_stmt INTO x_price_list_col;
975:
976: IF (x_price_list_col IS NULL)

Line 978: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '

974: EXECUTE IMMEDIATE x_stmt INTO x_price_list_col;
975:
976: IF (x_price_list_col IS NULL)
977: THEN
978: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '
979: || ' Price List Column name is null ');
980: retcode := -1;
981: RETURN;
982: END IF;

Line 984: msd_dem_common_utilities.log_debug('Truncate staging table for cto price - BIIO_SCENARIO_PRICE ');

980: retcode := -1;
981: RETURN;
982: END IF;
983:
984: msd_dem_common_utilities.log_debug('Truncate staging table for cto price - BIIO_SCENARIO_PRICE ');
985: msd_dem_query_utilities.truncate_table (
986: x_errbuf,
987: x_retcode,
988: 'BIIO_SCENARIO_PRICE',

Line 993: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '

989: 1,
990: 1);
991: IF (x_retcode = -1)
992: THEN
993: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '
994: || ' Failed to truncate BIIO_SCENARIO_PRICE');
995: retcode := -1;
996: errbuf := x_errbuf;
997: RETURN;

Line 1000: msd_dem_common_utilities.log_debug('Truncate staging table for cto price - BIIO_SCENARIO_PRICE_ERR ');

996: errbuf := x_errbuf;
997: RETURN;
998: END IF;
999:
1000: msd_dem_common_utilities.log_debug('Truncate staging table for cto price - BIIO_SCENARIO_PRICE_ERR ');
1001: msd_dem_query_utilities.truncate_table (
1002: x_errbuf,
1003: x_retcode,
1004: 'BIIO_SCENARIO_PRICE_ERR',

Line 1009: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '

1005: 1,
1006: 1);
1007: IF (x_retcode = -1)
1008: THEN
1009: msd_dem_common_utilities.log_message ('msd_dem_collect_price_lists.collect_price_lists - ERROR - '
1010: || ' Failed to truncate BIIO_SCENARIO_PRICE_ERR');
1011: retcode := -1;
1012: errbuf := x_errbuf;
1013: RETURN;

Line 1026: msd_dem_common_utilities.log_debug (x_stmt);

1022: || x_price_list_col || ' '
1023: || ' FROM ' || x_schema || '.MSD_DEM_PRICE_LIST '
1024: || ' WHERE ' || x_price_list_col || ' IS NOT NULL ';
1025:
1026: msd_dem_common_utilities.log_debug (x_stmt);
1027: msd_dem_common_utilities.log_debug ('Query start time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1028: EXECUTE IMMEDIATE x_stmt;
1029: x_num_rows := SQL%ROWCOUNT;
1030: COMMIT;

Line 1027: msd_dem_common_utilities.log_debug ('Query start time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1023: || ' FROM ' || x_schema || '.MSD_DEM_PRICE_LIST '
1024: || ' WHERE ' || x_price_list_col || ' IS NOT NULL ';
1025:
1026: msd_dem_common_utilities.log_debug (x_stmt);
1027: msd_dem_common_utilities.log_debug ('Query start time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1028: EXECUTE IMMEDIATE x_stmt;
1029: x_num_rows := SQL%ROWCOUNT;
1030: COMMIT;
1031: msd_dem_common_utilities.log_debug ('Query end time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

Line 1031: msd_dem_common_utilities.log_debug ('Query end time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1027: msd_dem_common_utilities.log_debug ('Query start time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1028: EXECUTE IMMEDIATE x_stmt;
1029: x_num_rows := SQL%ROWCOUNT;
1030: COMMIT;
1031: msd_dem_common_utilities.log_debug ('Query end time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1032: msd_dem_common_utilities.log_debug ('Number of rows inserted - ' || to_char(x_num_rows));
1033:
1034: msd_dem_common_utilities.log_debug('End - Scenario Price');
1035:

Line 1032: msd_dem_common_utilities.log_debug ('Number of rows inserted - ' || to_char(x_num_rows));

1028: EXECUTE IMMEDIATE x_stmt;
1029: x_num_rows := SQL%ROWCOUNT;
1030: COMMIT;
1031: msd_dem_common_utilities.log_debug ('Query end time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1032: msd_dem_common_utilities.log_debug ('Number of rows inserted - ' || to_char(x_num_rows));
1033:
1034: msd_dem_common_utilities.log_debug('End - Scenario Price');
1035:
1036: ELSE

Line 1034: msd_dem_common_utilities.log_debug('End - Scenario Price');

1030: COMMIT;
1031: msd_dem_common_utilities.log_debug ('Query end time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1032: msd_dem_common_utilities.log_debug ('Number of rows inserted - ' || to_char(x_num_rows));
1033:
1034: msd_dem_common_utilities.log_debug('End - Scenario Price');
1035:
1036: ELSE
1037: msd_dem_common_utilities.log_debug ('msd_dem_collect_price_lists.collect_price_lists - INFO - '
1038: || 'Staging tables for Scenario Price not found. Hence no action taken for Scenario Price');

Line 1037: msd_dem_common_utilities.log_debug ('msd_dem_collect_price_lists.collect_price_lists - INFO - '

1033:
1034: msd_dem_common_utilities.log_debug('End - Scenario Price');
1035:
1036: ELSE
1037: msd_dem_common_utilities.log_debug ('msd_dem_collect_price_lists.collect_price_lists - INFO - '
1038: || 'Staging tables for Scenario Price not found. Hence no action taken for Scenario Price');
1039:
1040: END IF;
1041:

Line 1044: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));

1040: END IF;
1041:
1042: exception
1043: when others then
1044: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
1045: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
1046: retcode := -1;
1047:
1048: end;

Line 1045: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));

1041:
1042: exception
1043: when others then
1044: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
1045: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
1046: retcode := -1;
1047:
1048: end;
1049:

Line 1088: msd_dem_common_utilities.log_message('Deleting Price Lists');

1084: end if;
1085:
1086: /*l_list := p_list || ',';*/
1087:
1088: msd_dem_common_utilities.log_message('Deleting Price Lists');
1089: msd_dem_common_utilities.log_debug('Deleting Price Lists');
1090:
1091: l_list := p_list;
1092:

Line 1089: msd_dem_common_utilities.log_debug('Deleting Price Lists');

1085:
1086: /*l_list := p_list || ',';*/
1087:
1088: msd_dem_common_utilities.log_message('Deleting Price Lists');
1089: msd_dem_common_utilities.log_debug('Deleting Price Lists');
1090:
1091: l_list := p_list;
1092:
1093: while length(l_list) > 0 loop

Line 1105: msd_dem_common_utilities.log_message('Price List ' || cur_str || ' does not exist in Demantra');

1101: fetch entities_inuse_cur into l_internal_name,l_column_name;
1102: close entities_inuse_cur;
1103:
1104: if l_internal_name is null then
1105: msd_dem_common_utilities.log_message('Price List ' || cur_str || ' does not exist in Demantra');
1106: msd_dem_common_utilities.log_debug('Price List ' || cur_str || ' does not exist in Demantra');
1107: goto continue;
1108: end if;
1109:

Line 1106: msd_dem_common_utilities.log_debug('Price List ' || cur_str || ' does not exist in Demantra');

1102: close entities_inuse_cur;
1103:
1104: if l_internal_name is null then
1105: msd_dem_common_utilities.log_message('Price List ' || cur_str || ' does not exist in Demantra');
1106: msd_dem_common_utilities.log_debug('Price List ' || cur_str || ' does not exist in Demantra');
1107: goto continue;
1108: end if;
1109:
1110: begin

Line 1116: msd_dem_common_utilities.log_message(l_stmt_prl_display_unit_id);

1112: l_stmt_prl_display_unit_id := 'select display_units_id ' ||
1113: ' from ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') ||
1114: ' where display_units = ''' || l_internal_name || '''';
1115:
1116: msd_dem_common_utilities.log_message(l_stmt_prl_display_unit_id);
1117: msd_dem_common_utilities.log_debug(l_stmt_prl_display_unit_id);
1118:
1119: open get_prl_display_unit_id for l_stmt_prl_display_unit_id;
1120: fetch get_prl_display_unit_id into l_display_unit_id;

Line 1117: msd_dem_common_utilities.log_debug(l_stmt_prl_display_unit_id);

1113: ' from ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') ||
1114: ' where display_units = ''' || l_internal_name || '''';
1115:
1116: msd_dem_common_utilities.log_message(l_stmt_prl_display_unit_id);
1117: msd_dem_common_utilities.log_debug(l_stmt_prl_display_unit_id);
1118:
1119: open get_prl_display_unit_id for l_stmt_prl_display_unit_id;
1120: fetch get_prl_display_unit_id into l_display_unit_id;
1121: close get_prl_display_unit_id;

Line 1126: msd_dem_common_utilities.log_message(l_stmt_deletes);

1122:
1123: l_stmt_deletes := 'delete from ' || get_lookup_value('MSD_DEM_TABLES', 'AVAIL_UNITS') ||
1124: ' where display_units_id = :1';
1125:
1126: msd_dem_common_utilities.log_message(l_stmt_deletes);
1127: msd_dem_common_utilities.log_debug(l_stmt_deletes);
1128:
1129: execute immediate l_stmt_deletes using l_display_unit_id;
1130:

Line 1127: msd_dem_common_utilities.log_debug(l_stmt_deletes);

1123: l_stmt_deletes := 'delete from ' || get_lookup_value('MSD_DEM_TABLES', 'AVAIL_UNITS') ||
1124: ' where display_units_id = :1';
1125:
1126: msd_dem_common_utilities.log_message(l_stmt_deletes);
1127: msd_dem_common_utilities.log_debug(l_stmt_deletes);
1128:
1129: execute immediate l_stmt_deletes using l_display_unit_id;
1130:
1131: l_stmt_deletes := 'delete from ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') ||

Line 1134: msd_dem_common_utilities.log_message(l_stmt_deletes);

1130:
1131: l_stmt_deletes := 'delete from ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') ||
1132: ' where display_units_id = :1';
1133:
1134: msd_dem_common_utilities.log_message(l_stmt_deletes);
1135: msd_dem_common_utilities.log_debug(l_stmt_deletes);
1136:
1137: execute immediate l_stmt_deletes using l_display_unit_id;
1138:

Line 1135: msd_dem_common_utilities.log_debug(l_stmt_deletes);

1131: l_stmt_deletes := 'delete from ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') ||
1132: ' where display_units_id = :1';
1133:
1134: msd_dem_common_utilities.log_message(l_stmt_deletes);
1135: msd_dem_common_utilities.log_debug(l_stmt_deletes);
1136:
1137: execute immediate l_stmt_deletes using l_display_unit_id;
1138:
1139: l_stmt_deletes := 'delete from ' || get_lookup_value('MSD_DEM_TABLES', 'INDEXES_FOR_UNITS') ||

Line 1142: msd_dem_common_utilities.log_message(l_stmt_deletes);

1138:
1139: l_stmt_deletes := 'delete from ' || get_lookup_value('MSD_DEM_TABLES', 'INDEXES_FOR_UNITS') ||
1140: ' where display_units_id = :1';
1141:
1142: msd_dem_common_utilities.log_message(l_stmt_deletes);
1143: msd_dem_common_utilities.log_debug(l_stmt_deletes);
1144:
1145: execute immediate l_stmt_deletes using l_display_unit_id;
1146:

Line 1143: msd_dem_common_utilities.log_debug(l_stmt_deletes);

1139: l_stmt_deletes := 'delete from ' || get_lookup_value('MSD_DEM_TABLES', 'INDEXES_FOR_UNITS') ||
1140: ' where display_units_id = :1';
1141:
1142: msd_dem_common_utilities.log_message(l_stmt_deletes);
1143: msd_dem_common_utilities.log_debug(l_stmt_deletes);
1144:
1145: execute immediate l_stmt_deletes using l_display_unit_id;
1146:
1147: l_stmt_updates := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') ||

Line 1150: msd_dem_common_utilities.log_message(l_stmt_updates);

1146:
1147: l_stmt_updates := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') ||
1148: ' set display_units = :1 where display_units_id = :2';
1149:
1150: msd_dem_common_utilities.log_message(l_stmt_updates);
1151: msd_dem_common_utilities.log_debug(l_stmt_updates);
1152:
1153: execute immediate l_stmt_updates using l_column_name, l_display_unit_id;
1154:

Line 1151: msd_dem_common_utilities.log_debug(l_stmt_updates);

1147: l_stmt_updates := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') ||
1148: ' set display_units = :1 where display_units_id = :2';
1149:
1150: msd_dem_common_utilities.log_message(l_stmt_updates);
1151: msd_dem_common_utilities.log_debug(l_stmt_updates);
1152:
1153: execute immediate l_stmt_updates using l_column_name, l_display_unit_id;
1154:
1155: l_stmt_updates := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'COMPUTED_FIELDS') ||

Line 1159: msd_dem_common_utilities.log_message(l_stmt_updates);

1155: l_stmt_updates := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'COMPUTED_FIELDS') ||
1156: ' set computed_title = :1 ' ||
1157: ' where computed_name = :2 ';
1158:
1159: msd_dem_common_utilities.log_message(l_stmt_updates);
1160: msd_dem_common_utilities.log_debug(l_stmt_updates);
1161:
1162: execute immediate l_stmt_updates using l_column_name, l_column_name;
1163:

Line 1160: msd_dem_common_utilities.log_debug(l_stmt_updates);

1156: ' set computed_title = :1 ' ||
1157: ' where computed_name = :2 ';
1158:
1159: msd_dem_common_utilities.log_message(l_stmt_updates);
1160: msd_dem_common_utilities.log_debug(l_stmt_updates);
1161:
1162: execute immediate l_stmt_updates using l_column_name, l_column_name;
1163:
1164: l_stmt_deletes := 'delete from msd_dem_entities_inuse' ||

Line 1167: msd_dem_common_utilities.log_message(l_stmt_deletes);

1163:
1164: l_stmt_deletes := 'delete from msd_dem_entities_inuse' ||
1165: ' where internal_name = :1 and ebs_entity = ''PRL''';
1166:
1167: msd_dem_common_utilities.log_message(l_stmt_deletes);
1168: msd_dem_common_utilities.log_debug(l_stmt_deletes);
1169:
1170: execute immediate l_stmt_deletes using l_internal_name;
1171:

Line 1168: msd_dem_common_utilities.log_debug(l_stmt_deletes);

1164: l_stmt_deletes := 'delete from msd_dem_entities_inuse' ||
1165: ' where internal_name = :1 and ebs_entity = ''PRL''';
1166:
1167: msd_dem_common_utilities.log_message(l_stmt_deletes);
1168: msd_dem_common_utilities.log_debug(l_stmt_deletes);
1169:
1170: execute immediate l_stmt_deletes using l_internal_name;
1171:
1172: l_stmt_updates := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'SALES_DATA') ||

Line 1175: msd_dem_common_utilities.log_message(l_stmt_updates);

1171:
1172: l_stmt_updates := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'SALES_DATA') ||
1173: ' set ' || l_column_name || ' = null';
1174:
1175: msd_dem_common_utilities.log_message(l_stmt_updates);
1176: msd_dem_common_utilities.log_debug(l_stmt_updates);
1177:
1178: execute immediate l_stmt_updates;
1179:

Line 1176: msd_dem_common_utilities.log_debug(l_stmt_updates);

1172: l_stmt_updates := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'SALES_DATA') ||
1173: ' set ' || l_column_name || ' = null';
1174:
1175: msd_dem_common_utilities.log_message(l_stmt_updates);
1176: msd_dem_common_utilities.log_debug(l_stmt_updates);
1177:
1178: execute immediate l_stmt_updates;
1179:
1180: commit;

Line 1182: msd_dem_common_utilities.log_message('Deleted price list ' || l_internal_name);

1178: execute immediate l_stmt_updates;
1179:
1180: commit;
1181:
1182: msd_dem_common_utilities.log_message('Deleted price list ' || l_internal_name);
1183: msd_dem_common_utilities.log_debug('Deleted price list ' || l_internal_name);
1184:
1185: exception
1186: when others then

Line 1183: msd_dem_common_utilities.log_debug('Deleted price list ' || l_internal_name);

1179:
1180: commit;
1181:
1182: msd_dem_common_utilities.log_message('Deleted price list ' || l_internal_name);
1183: msd_dem_common_utilities.log_debug('Deleted price list ' || l_internal_name);
1184:
1185: exception
1186: when others then
1187: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));

Line 1187: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));

1183: msd_dem_common_utilities.log_debug('Deleted price list ' || l_internal_name);
1184:
1185: exception
1186: when others then
1187: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
1188: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
1189: msd_dem_common_utilities.log_message('Failed deleting price list ' || l_internal_name);
1190: msd_dem_common_utilities.log_debug('Failed deleting price list ' || l_internal_name);
1191: retcode := 1;

Line 1188: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));

1184:
1185: exception
1186: when others then
1187: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
1188: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
1189: msd_dem_common_utilities.log_message('Failed deleting price list ' || l_internal_name);
1190: msd_dem_common_utilities.log_debug('Failed deleting price list ' || l_internal_name);
1191: retcode := 1;
1192:

Line 1189: msd_dem_common_utilities.log_message('Failed deleting price list ' || l_internal_name);

1185: exception
1186: when others then
1187: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
1188: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
1189: msd_dem_common_utilities.log_message('Failed deleting price list ' || l_internal_name);
1190: msd_dem_common_utilities.log_debug('Failed deleting price list ' || l_internal_name);
1191: retcode := 1;
1192:
1193: end;

Line 1190: msd_dem_common_utilities.log_debug('Failed deleting price list ' || l_internal_name);

1186: when others then
1187: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
1188: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
1189: msd_dem_common_utilities.log_message('Failed deleting price list ' || l_internal_name);
1190: msd_dem_common_utilities.log_debug('Failed deleting price list ' || l_internal_name);
1191: retcode := 1;
1192:
1193: end;
1194:

Line 1204: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));

1200: retcode := 0;
1201:
1202: exception
1203: when others then
1204: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
1205: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
1206: retcode := -1;
1207:
1208: end;

Line 1205: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));

1201:
1202: exception
1203: when others then
1204: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
1205: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
1206: retcode := -1;
1207:
1208: end;
1209: