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

Line 256: msd_dem_common_utilities.log_message('UOM deleted. Please recreate the UOM');

252: fetch get_uom_metadata into l_table_name, l_column_name;
253:
254: if get_uom_metadata%notfound then
255: close get_uom_metadata;
256: msd_dem_common_utilities.log_message('UOM deleted. Please recreate the UOM');
257: msd_dem_common_utilities.log_debug('UOM deleted. Please recreate the UOM');
258: retcode := 1;
259: return;
260: end if;

Line 257: msd_dem_common_utilities.log_debug('UOM deleted. Please recreate the UOM');

253:
254: if get_uom_metadata%notfound then
255: close get_uom_metadata;
256: msd_dem_common_utilities.log_message('UOM deleted. Please recreate the UOM');
257: msd_dem_common_utilities.log_debug('UOM deleted. Please recreate the UOM');
258: retcode := 1;
259: return;
260: end if;
261:

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

276: ' and rownum < 2 ' ||
277: ')';
278:
279:
280: msd_dem_common_utilities.log_debug('p_instance_id ' || p_instance_id);
281: msd_dem_common_utilities.log_debug(l_stmt);
282:
283: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
284: execute immediate l_stmt using p_instance_id;

Line 281: msd_dem_common_utilities.log_debug(l_stmt);

277: ')';
278:
279:
280: msd_dem_common_utilities.log_debug('p_instance_id ' || p_instance_id);
281: msd_dem_common_utilities.log_debug(l_stmt);
282:
283: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
284: execute immediate l_stmt using p_instance_id;
285: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));

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

279:
280: msd_dem_common_utilities.log_debug('p_instance_id ' || p_instance_id);
281: msd_dem_common_utilities.log_debug(l_stmt);
282:
283: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
284: execute immediate l_stmt using p_instance_id;
285: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
286:
287: exception

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

281: msd_dem_common_utilities.log_debug(l_stmt);
282:
283: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
284: execute immediate l_stmt using p_instance_id;
285: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
286:
287: exception
288: when others then
289: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));

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

285: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
286:
287: exception
288: when others then
289: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
290: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
291: retcode := 1;
292:
293: end;

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

286:
287: exception
288: when others then
289: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
290: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
291: retcode := 1;
292:
293: end;
294:

Line 357: msd_dem_common_utilities.log_debug(l_stmt_new_uom_display_unit);

353: ' minus ' ||
354: ' select column_name from msd_dem_entities_inuse where ebs_entity = ''UOM'' )' ||
355: ' and rownum < 2';
356:
357: msd_dem_common_utilities.log_debug(l_stmt_new_uom_display_unit);
358: -- syenamar
359:
360: open get_new_uom_display_unit for l_stmt_new_uom_display_unit;
361: fetch get_new_uom_display_unit into new_uom;

Line 363: msd_dem_common_utilities.log_message('Seeded Display Units not Available');

359:
360: open get_new_uom_display_unit for l_stmt_new_uom_display_unit;
361: fetch get_new_uom_display_unit into new_uom;
362: if get_new_uom_display_unit%notfound then
363: msd_dem_common_utilities.log_message('Seeded Display Units not Available');
364: msd_dem_common_utilities.log_debug('Seeded Display Units not Available');
365: close get_new_uom_display_unit;
366: retcode := 1;
367: return;

Line 364: msd_dem_common_utilities.log_debug('Seeded Display Units not Available');

360: open get_new_uom_display_unit for l_stmt_new_uom_display_unit;
361: fetch get_new_uom_display_unit into new_uom;
362: if get_new_uom_display_unit%notfound then
363: msd_dem_common_utilities.log_message('Seeded Display Units not Available');
364: msd_dem_common_utilities.log_debug('Seeded Display Units not Available');
365: close get_new_uom_display_unit;
366: retcode := 1;
367: return;
368: end if;

Line 397: msd_dem_common_utilities.log_debug(l_stmt);

393: ,:7
394: ,:8
395: )';
396:
397: msd_dem_common_utilities.log_debug(l_stmt);
398:
399: execute immediate l_stmt using p_uom_code, new_uom.data_table, new_uom.data_field, sysdate, fnd_global.user_id, sysdate, fnd_global.user_id, fnd_global.user_id;
400:
401: l_stmt := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') ||

Line 405: msd_dem_common_utilities.log_debug(l_stmt);

401: l_stmt := 'update ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') ||
402: ' set display_units = :1 ' ||
403: ' where display_units_id = :2';
404:
405: msd_dem_common_utilities.log_debug(l_stmt);
406:
407: execute immediate l_stmt using p_uom_code, new_uom.display_units_id;
408:
409: l_stmt := 'insert into ' || get_lookup_value('MSD_DEM_TABLES', 'AVAIL_UNITS') ||

Line 421: msd_dem_common_utilities.log_debug(l_stmt);

417: ' from ' || get_lookup_value('MSD_DEM_TABLES', 'AVAIL_UNITS') ||
418: ' where display_units_id = :2 ' ||
419: ' )';
420:
421: msd_dem_common_utilities.log_debug(l_stmt);
422: execute immediate l_stmt using new_uom.display_units_id, new_uom.display_units_id;
423:
424: -- Bug#7199587 syenamar
425: -- Use component id obtained from lookup

Line 427: /*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') || '''';

423:
424: -- Bug#7199587 syenamar
425: -- Use component id obtained from lookup
426:
427: /*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') || '''';
428:
429: msd_dem_common_utilities.log_debug(l_stmt_get_component);
430:
431: open get_component for l_stmt_get_component;

Line 429: msd_dem_common_utilities.log_debug(l_stmt_get_component);

425: -- Use component id obtained from lookup
426:
427: /*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') || '''';
428:
429: msd_dem_common_utilities.log_debug(l_stmt_get_component);
430:
431: open get_component for l_stmt_get_component;
432: fetch get_component into l_component_id;
433: close get_component;*/

Line 436: l_component_id := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID',

432: fetch get_component into l_component_id;
433: close get_component;*/
434:
435: /* Bug#8224935 - APP ID */ -- nallkuma
436: l_component_id := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID',
437: 'COMP_DM',
438: 1,
439: 'dcm_product_id'));
440: l_stmt := 'insert into ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') ||

Line 443: msd_dem_common_utilities.log_debug(l_stmt);

439: 'dcm_product_id'));
440: l_stmt := 'insert into ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') ||
441: ' (dcm_product_id ,display_units_id) ' ||
442: ' (select :1, :2 from dual)';
443: msd_dem_common_utilities.log_debug(l_stmt);
444: execute immediate l_stmt using l_component_id,new_uom.display_units_id;
445:
446:
447: /*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') || '''';

Line 447: /*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') || '''';

443: msd_dem_common_utilities.log_debug(l_stmt);
444: execute immediate l_stmt using l_component_id,new_uom.display_units_id;
445:
446:
447: /*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') || '''';
448:
449: msd_dem_common_utilities.log_debug(l_stmt_get_component_sop);
450:
451: open get_component_sop for l_stmt_get_component_sop;

Line 449: msd_dem_common_utilities.log_debug(l_stmt_get_component_sop);

445:
446:
447: /*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') || '''';
448:
449: msd_dem_common_utilities.log_debug(l_stmt_get_component_sop);
450:
451: open get_component_sop for l_stmt_get_component_sop;
452: fetch get_component_sop into l_component_id_sop;
453: close get_component_sop;*/

Line 456: l_component_id_sop := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID',

452: fetch get_component_sop into l_component_id_sop;
453: close get_component_sop;*/
454:
455: /* Bug#8224935 - APP ID */ -- nallkuma
456: l_component_id_sop := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID',
457: 'COMP_SOP',
458: 1,
459: 'dcm_product_id'));
460: l_stmt := 'insert into ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') ||

Line 463: msd_dem_common_utilities.log_debug(l_stmt);

459: 'dcm_product_id'));
460: l_stmt := 'insert into ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') ||
461: ' (dcm_product_id ,display_units_id) ' ||
462: ' (select :1, :2 from dual)';
463: msd_dem_common_utilities.log_debug(l_stmt);
464: execute immediate l_stmt using l_component_id_sop,new_uom.display_units_id;
465: -- syenamar
466:
467: else

Line 473: msd_dem_common_utilities.log_debug(l_stmt);

469: l_stmt := 'update msd_dem_entities_inuse set table_name = (select data_table from ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') || ' where display_units = :1)' ||
470: ', column_name = (select data_field from ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') || ' where display_units = :2)' ||
471: 'where ebs_entity = ''UOM'' and demantra_entity = ''DISPLAY_UNIT'' and internal_name = :3';
472:
473: msd_dem_common_utilities.log_debug(l_stmt);
474:
475: execute immediate l_stmt using p_uom_code, p_uom_code, p_uom_code;
476:
477: end if;

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

477: end if;
478:
479: exception
480: when others then
481: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
482: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
483: retcode := 1;
484:
485: end;

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

478:
479: exception
480: when others then
481: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
482: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
483: retcode := 1;
484:
485: end;
486:

Line 553: msd_dem_common_utilities.log_message('Populating UOM: ' || l_uom_code);

549:
550: fetch get_uom_code into l_uom_code;
551: exit when get_uom_code%notfound;
552:
553: msd_dem_common_utilities.log_message('Populating UOM: ' || l_uom_code);
554: msd_dem_common_utilities.log_debug('Populating UOM: ' || l_uom_code);
555:
556: l_list2 := replace(l_list2, l_uom_code||',' , '');
557:

Line 554: msd_dem_common_utilities.log_debug('Populating UOM: ' || l_uom_code);

550: fetch get_uom_code into l_uom_code;
551: exit when get_uom_code%notfound;
552:
553: msd_dem_common_utilities.log_message('Populating UOM: ' || l_uom_code);
554: msd_dem_common_utilities.log_debug('Populating UOM: ' || l_uom_code);
555:
556: l_list2 := replace(l_list2, l_uom_code||',' , '');
557:
558: process_uom(retcode, l_uom_code);

Line 561: msd_dem_common_utilities.log_message('Failed processing UOM: ' || l_uom_code);

557:
558: process_uom(retcode, l_uom_code);
559:
560: if retcode = -1 or retcode = 1 then
561: msd_dem_common_utilities.log_message('Failed processing UOM: ' || l_uom_code);
562: msd_dem_common_utilities.log_debug('Failed Processing UOM: ' || l_uom_code);
563: goto continue;
564: end if;
565:

Line 562: msd_dem_common_utilities.log_debug('Failed Processing UOM: ' || l_uom_code);

558: process_uom(retcode, l_uom_code);
559:
560: if retcode = -1 or retcode = 1 then
561: msd_dem_common_utilities.log_message('Failed processing UOM: ' || l_uom_code);
562: msd_dem_common_utilities.log_debug('Failed Processing UOM: ' || l_uom_code);
563: goto continue;
564: end if;
565:
566: populate_uom(retcode, l_uom_code, p_instance_id);

Line 579: msd_dem_common_utilities.log_message('Following UOM''s dont exist in source: ' || l_list2);

575: l_list2 := rtrim(l_list2, ',');
576:
577: if l_list2 is not null then
578: retcode := 1;
579: msd_dem_common_utilities.log_message('Following UOM''s dont exist in source: ' || l_list2);
580: msd_dem_common_utilities.log_debug('Following UOM''s dont exist in source: ' || l_list2);
581: end if;
582:
583: exception

Line 580: msd_dem_common_utilities.log_debug('Following UOM''s dont exist in source: ' || l_list2);

576:
577: if l_list2 is not null then
578: retcode := 1;
579: msd_dem_common_utilities.log_message('Following UOM''s dont exist in source: ' || l_list2);
580: msd_dem_common_utilities.log_debug('Following UOM''s dont exist in source: ' || l_list2);
581: end if;
582:
583: exception
584: when others then

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

581: end if;
582:
583: exception
584: when others then
585: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
586: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
587: retcode := 1;
588:
589: end;

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

582:
583: exception
584: when others then
585: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
586: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
587: retcode := 1;
588:
589: end;
590:

Line 610: msd_dem_common_utilities.log_debug('Instance_type : ' || l_instance_type);

606: l_instance_type := null;
607:
608: x_inst_type_sql := ' select instance_type from msc_apps_instances where instance_id = ' || p_instance_id ;
609: execute immediate x_inst_type_sql into l_instance_type ;
610: msd_dem_common_utilities.log_debug('Instance_type : ' || l_instance_type);
611:
612: if l_instance_type in (1,2,4) then /* Non-Legacy Instances */ -- Bug#8367471 nallkuma
613: l_instance_type := ' 4 ' ;
614: else /* Legacy Instances */

Line 633: msd_dem_common_utilities.log_message('Cannot find query to get UOM conversions from source');

629: null);
630:
631: if l_stmt is null then
632:
633: msd_dem_common_utilities.log_message('Cannot find query to get UOM conversions from source');
634: msd_dem_common_utilities.log_debug('Cannot find query to get UOM conversions from source');
635: retcode := -1;
636: return;
637:

Line 634: msd_dem_common_utilities.log_debug('Cannot find query to get UOM conversions from source');

630:
631: if l_stmt is null then
632:
633: msd_dem_common_utilities.log_message('Cannot find query to get UOM conversions from source');
634: msd_dem_common_utilities.log_debug('Cannot find query to get UOM conversions from source');
635: retcode := -1;
636: return;
637:
638: end if;

Line 640: msd_dem_common_utilities.log_debug('Query: ' || l_stmt);

636: return;
637:
638: end if;
639:
640: msd_dem_common_utilities.log_debug('Query: ' || l_stmt);
641:
642: msd_dem_common_utilities.log_debug('p_instance_id ' || p_instance_id);
643:
644: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));

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

638: end if;
639:
640: msd_dem_common_utilities.log_debug('Query: ' || l_stmt);
641:
642: msd_dem_common_utilities.log_debug('p_instance_id ' || p_instance_id);
643:
644: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
645: execute immediate l_stmt;
646: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));

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

640: msd_dem_common_utilities.log_debug('Query: ' || l_stmt);
641:
642: msd_dem_common_utilities.log_debug('p_instance_id ' || p_instance_id);
643:
644: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
645: execute immediate l_stmt;
646: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
647:
648: exception

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

642: msd_dem_common_utilities.log_debug('p_instance_id ' || p_instance_id);
643:
644: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
645: execute immediate l_stmt;
646: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
647:
648: exception
649: when others then
650: errbuf := substr(SQLERRM,1,150);

Line 651: msd_dem_common_utilities.log_message(errbuf);

647:
648: exception
649: when others then
650: errbuf := substr(SQLERRM,1,150);
651: msd_dem_common_utilities.log_message(errbuf);
652: msd_dem_common_utilities.log_debug(errbuf);
653: retcode := -1;
654:
655:

Line 652: msd_dem_common_utilities.log_debug(errbuf);

648: exception
649: when others then
650: errbuf := substr(SQLERRM,1,150);
651: msd_dem_common_utilities.log_message(errbuf);
652: msd_dem_common_utilities.log_debug(errbuf);
653: retcode := -1;
654:
655:
656: end;

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

666:
667: begin
668:
669: if p_include_all = 1 and (p_include_uom_list is not null or p_exclude_uom_list is not null) then
670: msd_dem_common_utilities.log_message('Cannot specify both collect all and include or exclude list');
671: msd_dem_common_utilities.log_debug('Cannot specify both collect all and include or exclude list');
672: retcode := -1;
673: return;
674: end if;

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

667: begin
668:
669: if p_include_all = 1 and (p_include_uom_list is not null or p_exclude_uom_list is not null) then
670: msd_dem_common_utilities.log_message('Cannot specify both collect all and include or exclude list');
671: msd_dem_common_utilities.log_debug('Cannot specify both collect all and include or exclude list');
672: retcode := -1;
673: return;
674: end if;
675:

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

674: end if;
675:
676: if p_include_all = 2 and p_include_uom_list is null and p_exclude_uom_list is null then
677:
678: msd_dem_common_utilities.log_message('Exactly one of the parameters Include UOM''s or Exclude UOM''s must be specified, when Collect All UOM''s is No');
679: msd_dem_common_utilities.log_debug('Exactly one of the parameters Include UOM''s or Exclude UOM''s must be specified, when Collect All UOM''s is No');
680: retcode := -1;
681: return;
682:

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

675:
676: if p_include_all = 2 and p_include_uom_list is null and p_exclude_uom_list is null then
677:
678: msd_dem_common_utilities.log_message('Exactly one of the parameters Include UOM''s or Exclude UOM''s must be specified, when Collect All UOM''s is No');
679: msd_dem_common_utilities.log_debug('Exactly one of the parameters Include UOM''s or Exclude UOM''s must be specified, when Collect All UOM''s is No');
680: retcode := -1;
681: return;
682:
683: end if;

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

683: end if;
684:
685: if p_include_all = 2 and p_include_uom_list is not null and p_exclude_uom_list is not null then
686:
687: msd_dem_common_utilities.log_message('Should not specify both include and exclude list');
688: msd_dem_common_utilities.log_debug('Should not specify both include and exclude list');
689: retcode := -1;
690: return;
691:

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

684:
685: if p_include_all = 2 and p_include_uom_list is not null and p_exclude_uom_list is not null then
686:
687: msd_dem_common_utilities.log_message('Should not specify both include and exclude list');
688: msd_dem_common_utilities.log_debug('Should not specify both include and exclude list');
689: retcode := -1;
690: return;
691:
692: end if;

Line 694: msd_dem_common_utilities.log_message('Collecting UOM''s');

690: return;
691:
692: end if;
693:
694: msd_dem_common_utilities.log_message('Collecting UOM''s');
695: msd_dem_common_utilities.log_debug('Collecting UOM''s');
696:
697: msd_dem_common_utilities.log_message('Collecting UOM conversions from source');
698: msd_dem_common_utilities.log_debug('Collecting UOM conversions from source');

Line 695: msd_dem_common_utilities.log_debug('Collecting UOM''s');

691:
692: end if;
693:
694: msd_dem_common_utilities.log_message('Collecting UOM''s');
695: msd_dem_common_utilities.log_debug('Collecting UOM''s');
696:
697: msd_dem_common_utilities.log_message('Collecting UOM conversions from source');
698: msd_dem_common_utilities.log_debug('Collecting UOM conversions from source');
699: collect_from_source(errbuf, retcode, p_instance_id);

Line 697: msd_dem_common_utilities.log_message('Collecting UOM conversions from source');

693:
694: msd_dem_common_utilities.log_message('Collecting UOM''s');
695: msd_dem_common_utilities.log_debug('Collecting UOM''s');
696:
697: msd_dem_common_utilities.log_message('Collecting UOM conversions from source');
698: msd_dem_common_utilities.log_debug('Collecting UOM conversions from source');
699: collect_from_source(errbuf, retcode, p_instance_id);
700:
701: if retcode = -1 then

Line 698: msd_dem_common_utilities.log_debug('Collecting UOM conversions from source');

694: msd_dem_common_utilities.log_message('Collecting UOM''s');
695: msd_dem_common_utilities.log_debug('Collecting UOM''s');
696:
697: msd_dem_common_utilities.log_message('Collecting UOM conversions from source');
698: msd_dem_common_utilities.log_debug('Collecting UOM conversions from source');
699: collect_from_source(errbuf, retcode, p_instance_id);
700:
701: if retcode = -1 then
702: goto error_handle;

Line 706: msd_dem_common_utilities.log_message('Populating UOM''s in Demand Planning components');

702: goto error_handle;
703: end if;
704:
705:
706: msd_dem_common_utilities.log_message('Populating UOM''s in Demand Planning components');
707: msd_dem_common_utilities.log_debug('Populating UOM''s in Demand Planning components');
708: populate_demantra_uom_table(errbuf, retcode, p_instance_id, p_include_uom_list, p_exclude_uom_list);
709:
710: commit;

Line 707: msd_dem_common_utilities.log_debug('Populating UOM''s in Demand Planning components');

703: end if;
704:
705:
706: msd_dem_common_utilities.log_message('Populating UOM''s in Demand Planning components');
707: msd_dem_common_utilities.log_debug('Populating UOM''s in Demand Planning components');
708: populate_demantra_uom_table(errbuf, retcode, p_instance_id, p_include_uom_list, p_exclude_uom_list);
709:
710: commit;
711:

Line 723: msd_dem_common_utilities.log_message(errbuf);

719:
720: exception
721: when others then
722: errbuf := substr(SQLERRM,1,150);
723: msd_dem_common_utilities.log_message(errbuf);
724: msd_dem_common_utilities.log_debug(errbuf);
725: retcode := -1;
726:
727:

Line 724: msd_dem_common_utilities.log_debug(errbuf);

720: exception
721: when others then
722: errbuf := substr(SQLERRM,1,150);
723: msd_dem_common_utilities.log_message(errbuf);
724: msd_dem_common_utilities.log_debug(errbuf);
725: retcode := -1;
726:
727:
728: end;