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: msd_dem_common_utilities.log_debug(l_stmt);

128: || ' ,' || get_lookup_value('MSD_DEM_TABLES', 'TRANSFER_QUERY') || ' tq '
129: || ' where tl.name = :1 '
130: || ' and tq.transfer_id = tl.id) and tqs.series_id = ' || l_series_id;
131:
132: msd_dem_common_utilities.log_debug(l_stmt);
133:
134: execute immediate l_stmt using fnd_profile.value('MSD_DEM_PRICE_LIST_PROFILE');
135:
136: <>

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

138: null;
139:
140: exception
141: when others then
142: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
143: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
144: retcode := 1;
145:
146: end;

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

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

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

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

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

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

Line 228: msd_dem_common_utilities.log_debug(l_stmt_new_prl_display_unit);

224: ' minus ' ||
225: ' select distinct display_units_id from ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') || ' ' || ')' ||
226: ' and display_units like ''%EBSPRICELIST%'' and rownum < 2';
227:
228: msd_dem_common_utilities.log_debug(l_stmt_new_prl_display_unit);
229:
230:
231: open get_new_prl_display_unit for l_stmt_new_prl_display_unit;
232: fetch get_new_prl_display_unit into new_prl;

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

230:
231: open get_new_prl_display_unit for l_stmt_new_prl_display_unit;
232: fetch get_new_prl_display_unit into new_prl;
233: if get_new_prl_display_unit%notfound then
234: msd_dem_common_utilities.log_message('Seeded Display Units for Price List not Available');
235: msd_dem_common_utilities.log_debug('Seeded Display Units for Price List not Available');
236: close get_new_prl_display_unit;
237: retcode := 1;
238: return;

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

231: open get_new_prl_display_unit for l_stmt_new_prl_display_unit;
232: fetch get_new_prl_display_unit into new_prl;
233: if get_new_prl_display_unit%notfound then
234: msd_dem_common_utilities.log_message('Seeded Display Units for Price List not Available');
235: msd_dem_common_utilities.log_debug('Seeded Display Units for Price List not Available');
236: close get_new_prl_display_unit;
237: retcode := 1;
238: return;
239: end if;

Line 279: msd_dem_common_utilities.log_debug(l_stmt);

275: ,:7
276: ,:8
277: )';
278:
279: msd_dem_common_utilities.log_debug(l_stmt);
280:
281:
282: 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;
283:

Line 288: msd_dem_common_utilities.log_debug(l_stmt);

284: l_stmt := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') ||
285: ' set display_units = :1 ' ||
286: ' where display_units_id = :2';
287:
288: msd_dem_common_utilities.log_debug(l_stmt);
289:
290: execute immediate l_stmt using p_prl_code, new_prl.display_units_id;
291:
292: l_stmt := 'insert into ' || get_lookup_value('MSD_DEM_TABLES', 'AVAIL_UNITS') ||

Line 299: msd_dem_common_utilities.log_debug(l_stmt);

295: ' from ' || get_lookup_value('MSD_DEM_TABLES', 'GROUP_TABLES') ||
296: ' where group_type = 1 ' ||
297: ' )';
298:
299: msd_dem_common_utilities.log_debug(l_stmt);
300:
301: execute immediate l_stmt using new_prl.display_units_id;
302:
303: 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') || '''';

Line 303: 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') || '''';

299: msd_dem_common_utilities.log_debug(l_stmt);
300:
301: execute immediate l_stmt using new_prl.display_units_id;
302:
303: 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') || '''';
304:
305: msd_dem_common_utilities.log_debug(l_stmt_get_component);
306:
307: open get_component for l_stmt_get_component;

Line 305: msd_dem_common_utilities.log_debug(l_stmt_get_component);

301: execute immediate l_stmt using new_prl.display_units_id;
302:
303: 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') || '''';
304:
305: msd_dem_common_utilities.log_debug(l_stmt_get_component);
306:
307: open get_component for l_stmt_get_component;
308: fetch get_component into l_component_id;
309: close get_component;

Line 315: msd_dem_common_utilities.log_debug(l_stmt);

311: l_stmt := 'insert into ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') ||
312: ' (dcm_product_id ,display_units_id) ' ||
313: ' (select :1, :2 from dual)';
314:
315: msd_dem_common_utilities.log_debug(l_stmt);
316: execute immediate l_stmt using l_component_id,new_prl.display_units_id;
317:
318: l_stmt := 'insert into ' || get_lookup_value('MSD_DEM_TABLES', 'INDEXES_FOR_UNITS') ||
319: ' (display_units_id, real_value_id) ' ||

Line 324: msd_dem_common_utilities.log_debug(l_stmt);

320: ' (select :1, real_value_id from ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_INDEX') || ' dpi ' ||
321: ' where dpi.dcm_product_id = ' || l_component_id ||
322: ')';
323:
324: msd_dem_common_utilities.log_debug(l_stmt);
325:
326: execute immediate l_stmt using new_prl.display_units_id;
327:
328:

Line 330: 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') || '''';

326: execute immediate l_stmt using new_prl.display_units_id;
327:
328:
329:
330: 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') || '''';
331:
332: msd_dem_common_utilities.log_debug(l_stmt_get_component_sop);
333:
334: open get_component_sop for l_stmt_get_component_sop;

Line 332: msd_dem_common_utilities.log_debug(l_stmt_get_component_sop);

328:
329:
330: 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') || '''';
331:
332: msd_dem_common_utilities.log_debug(l_stmt_get_component_sop);
333:
334: open get_component_sop for l_stmt_get_component_sop;
335: fetch get_component_sop into l_component_id_sop;
336: close get_component_sop;

Line 342: msd_dem_common_utilities.log_debug(l_stmt);

338: l_stmt := 'insert into ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') ||
339: ' (dcm_product_id ,display_units_id) ' ||
340: ' (select :1, :2 from dual)';
341:
342: msd_dem_common_utilities.log_debug(l_stmt);
343: execute immediate l_stmt using l_component_id_sop,new_prl.display_units_id;
344:
345: l_stmt := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'COMPUTED_FIELDS')
346: || ' set computed_title = :1 '

Line 358: msd_dem_common_utilities.log_debug(l_stmt);

354: l_stmt := 'update msd_dem_entities_inuse set table_name = ''biio_ebs_price_list''' ||
355: ', column_name = (select data_field from ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') || ' where display_units = :1)' ||
356: 'where ebs_entity = ''PRL'' and demantra_entity = ''DISPLAY_UNIT'' and internal_name = :2';
357:
358: msd_dem_common_utilities.log_debug(l_stmt);
359:
360: execute immediate l_stmt using p_prl_code, p_prl_code; */
361:
362: end if;

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

364:
365:
366: exception
367: when others then
368: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
369: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
370: retcode := 1;
371:
372: end;

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

365:
366: exception
367: when others then
368: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
369: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
370: retcode := 1;
371:
372: end;
373:

Line 403: msd_dem_common_utilities.log_debug(l_stmt);

399: || ' ,' || get_lookup_value('MSD_DEM_TABLES', 'TRANSFER_QUERY') || ' tq '
400: || ' where tl.name = :1 '
401: || ' and tq.transfer_id = tl.id)';
402:
403: msd_dem_common_utilities.log_debug(l_stmt);
404:
405: execute immediate l_stmt using fnd_profile.value('MSD_DEM_PRICE_LIST_PROFILE');
406:
407:

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

445:
446: fetch get_prl_code into l_prl_code;
447: exit when get_prl_code%notfound;
448:
449: msd_dem_common_utilities.log_message('Populating Price List: ' || l_prl_code);
450: msd_dem_common_utilities.log_debug('Populating Price List: ' || l_prl_code);
451:
452: l_list2 := replace(l_list2, l_prl_code||',' , '');
453:

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

446: fetch get_prl_code into l_prl_code;
447: exit when get_prl_code%notfound;
448:
449: msd_dem_common_utilities.log_message('Populating Price List: ' || l_prl_code);
450: msd_dem_common_utilities.log_debug('Populating Price List: ' || l_prl_code);
451:
452: l_list2 := replace(l_list2, l_prl_code||',' , '');
453:
454: process_prl(retcode, l_prl_code);

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

453:
454: process_prl(retcode, l_prl_code);
455:
456: if retcode = -1 or retcode = 1 then
457: msd_dem_common_utilities.log_message('Failed processing Price List: ' || l_prl_code);
458: msd_dem_common_utilities.log_debug('Failed Processing Price List: ' || l_prl_code);
459: was_retcode_1 := retcode;
460: goto continue;
461: end if;

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

454: process_prl(retcode, l_prl_code);
455:
456: if retcode = -1 or retcode = 1 then
457: msd_dem_common_utilities.log_message('Failed processing Price List: ' || l_prl_code);
458: msd_dem_common_utilities.log_debug('Failed Processing Price List: ' || l_prl_code);
459: was_retcode_1 := retcode;
460: goto continue;
461: end if;
462:

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

478: l_list2 := rtrim(l_list2, ',');
479:
480: if l_list2 is not null then
481: retcode := 1;
482: msd_dem_common_utilities.log_message('Following Price Lists dont exist in source: ' || l_list2);
483: msd_dem_common_utilities.log_debug('Following Price Lists dont exist in source: ' || l_list2);
484: end if;
485:
486:

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

479:
480: if l_list2 is not null then
481: retcode := 1;
482: msd_dem_common_utilities.log_message('Following Price Lists dont exist in source: ' || l_list2);
483: msd_dem_common_utilities.log_debug('Following Price Lists dont exist in source: ' || l_list2);
484: end if;
485:
486:
487: exception

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

485:
486:
487: exception
488: when others then
489: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
490: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
491: retcode := 1;
492:
493: end;

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

486:
487: exception
488: when others then
489: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
490: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
491: retcode := 1;
492:
493: end;
494:

Line 551: 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);

547: unacc_list := rtrim(unacc_list, ',');
548: unacc_list := replace(unacc_list, '''', '');
549:
550: if unacc_list is not null then
551: 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);
552: 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);
553:
554: if acc_list is not null then
555: retcode := 1;

Line 552: 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);

548: unacc_list := replace(unacc_list, '''', '');
549:
550: if unacc_list is not null then
551: 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);
552: 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);
553:
554: if acc_list is not null then
555: retcode := 1;
556: else

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

566: end if;
567:
568: exception
569: when others then
570: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
571: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
572: retcode := -1;
573:
574: end;

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

567:
568: exception
569: when others then
570: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
571: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
572: retcode := -1;
573:
574: end;
575:

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

603: filter_from_list(errbuf, retcode, p_instance_id, p_include_prl_list, p_exclude_prl_list);
604:
605:
606: if retcode = -1 then
607: msd_dem_common_utilities.log_message('Price list collection cannot continue as no price lists are selected in the price list form');
608: msd_dem_common_utilities.log_debug('Price list collection cannot continue as no price lists are selected in the price list form');
609: retcode := -1;
610: return;
611: end if;

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

604:
605:
606: if retcode = -1 then
607: msd_dem_common_utilities.log_message('Price list collection cannot continue as no price lists are selected in the price list form');
608: msd_dem_common_utilities.log_debug('Price list collection cannot continue as no price lists are selected in the price list form');
609: retcode := -1;
610: return;
611: end if;
612:

Line 614: 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.');

610: return;
611: end if;
612:
613: if retcode = 0 then
614: 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.');
615: 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.');
616: retcode := 0;
617: return;
618: end if;

Line 615: 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.');

611: end if;
612:
613: if retcode = 0 then
614: 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.');
615: 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.');
616: retcode := 0;
617: return;
618: end if;
619:

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

650: l_key_values,
651: 0,
652: null);
653:
654: msd_dem_common_utilities.log_debug('Bind variables: ');
655: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
656: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
657:
658: msd_dem_common_utilities.log_debug('Executed Statement: ');

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

651: 0,
652: null);
653:
654: msd_dem_common_utilities.log_debug('Bind variables: ');
655: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
656: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
657:
658: msd_dem_common_utilities.log_debug('Executed Statement: ');
659: msd_dem_common_utilities.log_debug(l_stmt);

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

652: null);
653:
654: msd_dem_common_utilities.log_debug('Bind variables: ');
655: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
656: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
657:
658: msd_dem_common_utilities.log_debug('Executed Statement: ');
659: msd_dem_common_utilities.log_debug(l_stmt);
660:

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

654: msd_dem_common_utilities.log_debug('Bind variables: ');
655: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
656: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
657:
658: msd_dem_common_utilities.log_debug('Executed Statement: ');
659: msd_dem_common_utilities.log_debug(l_stmt);
660:
661: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
662: execute immediate l_stmt;

Line 659: msd_dem_common_utilities.log_debug(l_stmt);

655: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
656: msd_dem_common_utilities.log_debug('p_instance_id: ' || p_instance_id);
657:
658: msd_dem_common_utilities.log_debug('Executed Statement: ');
659: msd_dem_common_utilities.log_debug(l_stmt);
660:
661: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
662: execute immediate l_stmt;
663: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));

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

657:
658: msd_dem_common_utilities.log_debug('Executed Statement: ');
659: msd_dem_common_utilities.log_debug(l_stmt);
660:
661: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
662: execute immediate l_stmt;
663: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
664:
665: exception

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

659: msd_dem_common_utilities.log_debug(l_stmt);
660:
661: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
662: execute immediate l_stmt;
663: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
664:
665: exception
666: when others then
667: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));

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

663: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
664:
665: exception
666: when others then
667: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
668: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
669: retcode := -1;
670:
671: end;

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

664:
665: exception
666: when others then
667: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
668: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
669: retcode := -1;
670:
671: end;
672:

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

690: begin
691:
692: msd_dem_push_setup_parameters.push_setup_parameters(errbuf, retcode, p_instance_id, '-999');
693: if retcode = -1 then
694: msd_dem_common_utilities.log_message('Push Setup Parameters Failed');
695: msd_dem_common_utilities.log_debug('Push Setup Parameters Failed');
696: goto final;
697: end if;
698:

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

691:
692: msd_dem_push_setup_parameters.push_setup_parameters(errbuf, retcode, p_instance_id, '-999');
693: if retcode = -1 then
694: msd_dem_common_utilities.log_message('Push Setup Parameters Failed');
695: msd_dem_common_utilities.log_debug('Push Setup Parameters Failed');
696: goto final;
697: end if;
698:
699: if p_include_all = 1 and (p_include_prl_list is not null or p_exclude_prl_list is not null) then

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

696: goto final;
697: end if;
698:
699: if p_include_all = 1 and (p_include_prl_list is not null or p_exclude_prl_list is not null) then
700: msd_dem_common_utilities.log_message('Cannot specify both collect all and include or exclude list');
701: msd_dem_common_utilities.log_debug('Cannot specify both collect all and include or exclude list');
702: retcode := -1;
703: return;
704: end if;

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

697: end if;
698:
699: if p_include_all = 1 and (p_include_prl_list is not null or p_exclude_prl_list is not null) then
700: msd_dem_common_utilities.log_message('Cannot specify both collect all and include or exclude list');
701: msd_dem_common_utilities.log_debug('Cannot specify both collect all and include or exclude list');
702: retcode := -1;
703: return;
704: end if;
705:

Line 708: 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');

704: end if;
705:
706: if p_include_all = 2 and p_include_prl_list is null and p_exclude_prl_list is null then
707:
708: 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');
709: 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');
710: retcode := -1;
711: return;
712:

Line 709: 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');

705:
706: if p_include_all = 2 and p_include_prl_list is null and p_exclude_prl_list is null then
707:
708: 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');
709: 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');
710: retcode := -1;
711: return;
712:
713: end if;

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

713: end if;
714:
715: if p_include_all = 2 and p_include_prl_list is not null and p_exclude_prl_list is not null then
716:
717: msd_dem_common_utilities.log_message('Should not specify both include and exclude list');
718: msd_dem_common_utilities.log_debug('Should not specify both include and exclude list');
719: retcode := -1;
720: return;
721:

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

714:
715: if p_include_all = 2 and p_include_prl_list is not null and p_exclude_prl_list is not null then
716:
717: msd_dem_common_utilities.log_message('Should not specify both include and exclude list');
718: msd_dem_common_utilities.log_debug('Should not specify both include and exclude list');
719: retcode := -1;
720: return;
721:
722: end if;

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

721:
722: end if;
723:
724: 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
725: msd_dem_common_utilities.log_message('From Date should not be greater than To Date');
726: msd_dem_common_utilities.log_debug('From Date should not be greater than To Date');
727: retcode := -1;
728: return;
729: end if;

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

722: end if;
723:
724: 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
725: msd_dem_common_utilities.log_message('From Date should not be greater than To Date');
726: msd_dem_common_utilities.log_debug('From Date should not be greater than To Date');
727: retcode := -1;
728: return;
729: end if;
730:

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

727: retcode := -1;
728: return;
729: end if;
730:
731: msd_dem_common_utilities.log_message('Collecting Price Lists');
732: msd_dem_common_utilities.log_debug('Collecting Price Lists');
733:
734: msd_dem_common_utilities.log_message('Collecting Price Lists from source');
735: msd_dem_common_utilities.log_debug('Collecting Price Lists from source');

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

728: return;
729: end if;
730:
731: msd_dem_common_utilities.log_message('Collecting Price Lists');
732: msd_dem_common_utilities.log_debug('Collecting Price Lists');
733:
734: msd_dem_common_utilities.log_message('Collecting Price Lists from source');
735: msd_dem_common_utilities.log_debug('Collecting Price Lists from source');
736: collect_from_source(errbuf, retcode, p_instance_id, p_include_prl_list, p_exclude_prl_list);

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

730:
731: msd_dem_common_utilities.log_message('Collecting Price Lists');
732: msd_dem_common_utilities.log_debug('Collecting Price Lists');
733:
734: msd_dem_common_utilities.log_message('Collecting Price Lists from source');
735: msd_dem_common_utilities.log_debug('Collecting Price Lists from source');
736: collect_from_source(errbuf, retcode, p_instance_id, p_include_prl_list, p_exclude_prl_list);
737:
738: if retcode = -1 then

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

731: msd_dem_common_utilities.log_message('Collecting Price Lists');
732: msd_dem_common_utilities.log_debug('Collecting Price Lists');
733:
734: msd_dem_common_utilities.log_message('Collecting Price Lists from source');
735: msd_dem_common_utilities.log_debug('Collecting Price Lists from source');
736: collect_from_source(errbuf, retcode, p_instance_id, p_include_prl_list, p_exclude_prl_list);
737:
738: if retcode = -1 then
739: return;

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

740: end if;
741:
742: retcode_store := retcode;
743:
744: msd_dem_common_utilities.log_message('Populating Price Lists in Demand Planning components');
745: msd_dem_common_utilities.log_debug('Populating Price Lists in Demand Planning components');
746: 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),
747: 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')));
748:

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

741:
742: retcode_store := retcode;
743:
744: msd_dem_common_utilities.log_message('Populating Price Lists in Demand Planning components');
745: msd_dem_common_utilities.log_debug('Populating Price Lists in Demand Planning components');
746: 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),
747: 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')));
748:
749:

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

753: || ' ,' || get_lookup_value('MSD_DEM_TABLES', 'TRANSFER_QUERY') || ' tq '
754: || ' WHERE tl.name = ''' || fnd_profile.value('MSD_DEM_PRICE_LIST_PROFILE') || ''''
755: || ' AND tq.transfer_id = tl.id';
756:
757: msd_dem_common_utilities.log_debug ('Get data profile id stmt : ' || x_stmt);
758: EXECUTE IMMEDIATE x_stmt INTO x_profile_id;
759:
760: x_stmt := 'BEGIN '
761: || fnd_profile.value('MSD_DEM_SCHEMA') || '.'

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

762: || 'API_NOTIFY_APS_INTEGRATION('
763: || x_profile_id
764: ||'); end;';
765:
766: msd_dem_common_utilities.log_debug ('Refresh data profile stmt : ' || x_stmt);
767: EXECUTE IMMEDIATE x_stmt;
768:
769: EXCEPTION
770: WHEN OTHERS THEN

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

767: EXECUTE IMMEDIATE x_stmt;
768:
769: EXCEPTION
770: WHEN OTHERS THEN
771: msd_dem_common_utilities.log_message('WARNING: Failed to update the price list data profile');
772: END;
773:
774: commit;
775:

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

786: null;
787:
788: exception
789: when others then
790: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
791: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
792: retcode := -1;
793:
794: end;

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

787:
788: exception
789: when others then
790: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
791: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
792: retcode := -1;
793:
794: end;
795:

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

830: end if;
831:
832: /*l_list := p_list || ',';*/
833:
834: msd_dem_common_utilities.log_message('Deleting Price Lists');
835: msd_dem_common_utilities.log_debug('Deleting Price Lists');
836:
837: l_list := p_list;
838:

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

831:
832: /*l_list := p_list || ',';*/
833:
834: msd_dem_common_utilities.log_message('Deleting Price Lists');
835: msd_dem_common_utilities.log_debug('Deleting Price Lists');
836:
837: l_list := p_list;
838:
839: while length(l_list) > 0 loop

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

847: fetch entities_inuse_cur into l_internal_name,l_column_name;
848: close entities_inuse_cur;
849:
850: if l_internal_name is null then
851: msd_dem_common_utilities.log_message('Price List ' || cur_str || ' does not exist in Demantra');
852: msd_dem_common_utilities.log_debug('Price List ' || cur_str || ' does not exist in Demantra');
853: goto continue;
854: end if;
855:

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

848: close entities_inuse_cur;
849:
850: if l_internal_name is null then
851: msd_dem_common_utilities.log_message('Price List ' || cur_str || ' does not exist in Demantra');
852: msd_dem_common_utilities.log_debug('Price List ' || cur_str || ' does not exist in Demantra');
853: goto continue;
854: end if;
855:
856: begin

Line 862: msd_dem_common_utilities.log_message(l_stmt_prl_display_unit_id);

858: l_stmt_prl_display_unit_id := 'select display_units_id ' ||
859: ' from ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') ||
860: ' where display_units = ''' || l_internal_name || '''';
861:
862: msd_dem_common_utilities.log_message(l_stmt_prl_display_unit_id);
863: msd_dem_common_utilities.log_debug(l_stmt_prl_display_unit_id);
864:
865: open get_prl_display_unit_id for l_stmt_prl_display_unit_id;
866: fetch get_prl_display_unit_id into l_display_unit_id;

Line 863: msd_dem_common_utilities.log_debug(l_stmt_prl_display_unit_id);

859: ' from ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') ||
860: ' where display_units = ''' || l_internal_name || '''';
861:
862: msd_dem_common_utilities.log_message(l_stmt_prl_display_unit_id);
863: msd_dem_common_utilities.log_debug(l_stmt_prl_display_unit_id);
864:
865: open get_prl_display_unit_id for l_stmt_prl_display_unit_id;
866: fetch get_prl_display_unit_id into l_display_unit_id;
867: close get_prl_display_unit_id;

Line 872: msd_dem_common_utilities.log_message(l_stmt_deletes);

868:
869: l_stmt_deletes := 'delete from ' || get_lookup_value('MSD_DEM_TABLES', 'AVAIL_UNITS') ||
870: ' where display_units_id = :1';
871:
872: msd_dem_common_utilities.log_message(l_stmt_deletes);
873: msd_dem_common_utilities.log_debug(l_stmt_deletes);
874:
875: execute immediate l_stmt_deletes using l_display_unit_id;
876:

Line 873: msd_dem_common_utilities.log_debug(l_stmt_deletes);

869: l_stmt_deletes := 'delete from ' || get_lookup_value('MSD_DEM_TABLES', 'AVAIL_UNITS') ||
870: ' where display_units_id = :1';
871:
872: msd_dem_common_utilities.log_message(l_stmt_deletes);
873: msd_dem_common_utilities.log_debug(l_stmt_deletes);
874:
875: execute immediate l_stmt_deletes using l_display_unit_id;
876:
877: l_stmt_deletes := 'delete from ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') ||

Line 880: msd_dem_common_utilities.log_message(l_stmt_deletes);

876:
877: l_stmt_deletes := 'delete from ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') ||
878: ' where display_units_id = :1';
879:
880: msd_dem_common_utilities.log_message(l_stmt_deletes);
881: msd_dem_common_utilities.log_debug(l_stmt_deletes);
882:
883: execute immediate l_stmt_deletes using l_display_unit_id;
884:

Line 881: msd_dem_common_utilities.log_debug(l_stmt_deletes);

877: l_stmt_deletes := 'delete from ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') ||
878: ' where display_units_id = :1';
879:
880: msd_dem_common_utilities.log_message(l_stmt_deletes);
881: msd_dem_common_utilities.log_debug(l_stmt_deletes);
882:
883: execute immediate l_stmt_deletes using l_display_unit_id;
884:
885: l_stmt_deletes := 'delete from ' || get_lookup_value('MSD_DEM_TABLES', 'INDEXES_FOR_UNITS') ||

Line 888: msd_dem_common_utilities.log_message(l_stmt_deletes);

884:
885: l_stmt_deletes := 'delete from ' || get_lookup_value('MSD_DEM_TABLES', 'INDEXES_FOR_UNITS') ||
886: ' where display_units_id = :1';
887:
888: msd_dem_common_utilities.log_message(l_stmt_deletes);
889: msd_dem_common_utilities.log_debug(l_stmt_deletes);
890:
891: execute immediate l_stmt_deletes using l_display_unit_id;
892:

Line 889: msd_dem_common_utilities.log_debug(l_stmt_deletes);

885: l_stmt_deletes := 'delete from ' || get_lookup_value('MSD_DEM_TABLES', 'INDEXES_FOR_UNITS') ||
886: ' where display_units_id = :1';
887:
888: msd_dem_common_utilities.log_message(l_stmt_deletes);
889: msd_dem_common_utilities.log_debug(l_stmt_deletes);
890:
891: execute immediate l_stmt_deletes using l_display_unit_id;
892:
893: l_stmt_updates := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') ||

Line 896: msd_dem_common_utilities.log_message(l_stmt_updates);

892:
893: l_stmt_updates := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') ||
894: ' set display_units = :1 where display_units_id = :2';
895:
896: msd_dem_common_utilities.log_message(l_stmt_updates);
897: msd_dem_common_utilities.log_debug(l_stmt_updates);
898:
899: execute immediate l_stmt_updates using l_column_name, l_display_unit_id;
900:

Line 897: msd_dem_common_utilities.log_debug(l_stmt_updates);

893: l_stmt_updates := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') ||
894: ' set display_units = :1 where display_units_id = :2';
895:
896: msd_dem_common_utilities.log_message(l_stmt_updates);
897: msd_dem_common_utilities.log_debug(l_stmt_updates);
898:
899: execute immediate l_stmt_updates using l_column_name, l_display_unit_id;
900:
901: l_stmt_updates := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'COMPUTED_FIELDS') ||

Line 905: msd_dem_common_utilities.log_message(l_stmt_updates);

901: l_stmt_updates := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'COMPUTED_FIELDS') ||
902: ' set computed_title = :1 ' ||
903: ' where computed_name = :2 ';
904:
905: msd_dem_common_utilities.log_message(l_stmt_updates);
906: msd_dem_common_utilities.log_debug(l_stmt_updates);
907:
908: execute immediate l_stmt_updates using l_column_name, l_column_name;
909:

Line 906: msd_dem_common_utilities.log_debug(l_stmt_updates);

902: ' set computed_title = :1 ' ||
903: ' where computed_name = :2 ';
904:
905: msd_dem_common_utilities.log_message(l_stmt_updates);
906: msd_dem_common_utilities.log_debug(l_stmt_updates);
907:
908: execute immediate l_stmt_updates using l_column_name, l_column_name;
909:
910: l_stmt_deletes := 'delete from msd_dem_entities_inuse' ||

Line 913: msd_dem_common_utilities.log_message(l_stmt_deletes);

909:
910: l_stmt_deletes := 'delete from msd_dem_entities_inuse' ||
911: ' where internal_name = :1 and ebs_entity = ''PRL''';
912:
913: msd_dem_common_utilities.log_message(l_stmt_deletes);
914: msd_dem_common_utilities.log_debug(l_stmt_deletes);
915:
916: execute immediate l_stmt_deletes using l_internal_name;
917:

Line 914: msd_dem_common_utilities.log_debug(l_stmt_deletes);

910: l_stmt_deletes := 'delete from msd_dem_entities_inuse' ||
911: ' where internal_name = :1 and ebs_entity = ''PRL''';
912:
913: msd_dem_common_utilities.log_message(l_stmt_deletes);
914: msd_dem_common_utilities.log_debug(l_stmt_deletes);
915:
916: execute immediate l_stmt_deletes using l_internal_name;
917:
918: l_stmt_updates := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'SALES_DATA') ||

Line 921: msd_dem_common_utilities.log_message(l_stmt_updates);

917:
918: l_stmt_updates := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'SALES_DATA') ||
919: ' set ' || l_column_name || ' = null';
920:
921: msd_dem_common_utilities.log_message(l_stmt_updates);
922: msd_dem_common_utilities.log_debug(l_stmt_updates);
923:
924: execute immediate l_stmt_updates;
925:

Line 922: msd_dem_common_utilities.log_debug(l_stmt_updates);

918: l_stmt_updates := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'SALES_DATA') ||
919: ' set ' || l_column_name || ' = null';
920:
921: msd_dem_common_utilities.log_message(l_stmt_updates);
922: msd_dem_common_utilities.log_debug(l_stmt_updates);
923:
924: execute immediate l_stmt_updates;
925:
926: commit;

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

924: execute immediate l_stmt_updates;
925:
926: commit;
927:
928: msd_dem_common_utilities.log_message('Deleted price list ' || l_internal_name);
929: msd_dem_common_utilities.log_debug('Deleted price list ' || l_internal_name);
930:
931: exception
932: when others then

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

925:
926: commit;
927:
928: msd_dem_common_utilities.log_message('Deleted price list ' || l_internal_name);
929: msd_dem_common_utilities.log_debug('Deleted price list ' || l_internal_name);
930:
931: exception
932: when others then
933: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));

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

929: msd_dem_common_utilities.log_debug('Deleted price list ' || l_internal_name);
930:
931: exception
932: when others then
933: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
934: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
935: msd_dem_common_utilities.log_message('Failed deleting price list ' || l_internal_name);
936: msd_dem_common_utilities.log_debug('Failed deleting price list ' || l_internal_name);
937: retcode := 1;

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

930:
931: exception
932: when others then
933: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
934: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
935: msd_dem_common_utilities.log_message('Failed deleting price list ' || l_internal_name);
936: msd_dem_common_utilities.log_debug('Failed deleting price list ' || l_internal_name);
937: retcode := 1;
938:

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

931: exception
932: when others then
933: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
934: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
935: msd_dem_common_utilities.log_message('Failed deleting price list ' || l_internal_name);
936: msd_dem_common_utilities.log_debug('Failed deleting price list ' || l_internal_name);
937: retcode := 1;
938:
939: end;

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

932: when others then
933: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
934: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
935: msd_dem_common_utilities.log_message('Failed deleting price list ' || l_internal_name);
936: msd_dem_common_utilities.log_debug('Failed deleting price list ' || l_internal_name);
937: retcode := 1;
938:
939: end;
940:

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

946: retcode := 0;
947:
948: exception
949: when others then
950: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
951: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
952: retcode := -1;
953:
954: end;

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

947:
948: exception
949: when others then
950: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
951: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
952: retcode := -1;
953:
954: end;
955: