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_LEVEL_TYPES dependencies on FND_GLOBAL

Line 194: v_collect_level_type || fnd_global.local_chr(10) || l_stmt || fnd_global.local_chr(10) ||

190: delete_duplicates(retcode);
191: end if;
192:
193: msd_dem_common_utilities.log_debug('Insert statement for populating temporary table for ' ||
194: v_collect_level_type || fnd_global.local_chr(10) || l_stmt || fnd_global.local_chr(10) ||
195: 'Instance: ' || p_instance_id || fnd_global.local_chr(10));
196:
197: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10));
198: execute immediate l_stmt;

Line 195: 'Instance: ' || p_instance_id || fnd_global.local_chr(10));

191: end if;
192:
193: msd_dem_common_utilities.log_debug('Insert statement for populating temporary table for ' ||
194: v_collect_level_type || fnd_global.local_chr(10) || l_stmt || fnd_global.local_chr(10) ||
195: 'Instance: ' || p_instance_id || fnd_global.local_chr(10));
196:
197: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10));
198: execute immediate l_stmt;
199: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10));

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

193: msd_dem_common_utilities.log_debug('Insert statement for populating temporary table for ' ||
194: v_collect_level_type || fnd_global.local_chr(10) || l_stmt || fnd_global.local_chr(10) ||
195: 'Instance: ' || p_instance_id || fnd_global.local_chr(10));
196:
197: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10));
198: execute immediate l_stmt;
199: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10));
200:
201: retcode := 0;

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

195: 'Instance: ' || p_instance_id || fnd_global.local_chr(10));
196:
197: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10));
198: execute immediate l_stmt;
199: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10));
200:
201: retcode := 0;
202:
203: exception

Line 282: msd_dem_common_utilities.log_debug('Insert statement for populating Demantra staging table for ' || v_collect_level_type || fnd_global.local_chr(10) || l_stmt || fnd_global.local_chr(10));

278: end if;
279:
280: end if;
281:
282: msd_dem_common_utilities.log_debug('Insert statement for populating Demantra staging table for ' || v_collect_level_type || fnd_global.local_chr(10) || l_stmt || fnd_global.local_chr(10));
283: IF (p_collect_level_type = 2)
284: THEN
285: msd_dem_common_utilities.log_debug('Bind Variables - ');
286: msd_dem_common_utilities.log_debug('Master Organization Id - ' || to_char(l_master_org));

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

286: msd_dem_common_utilities.log_debug('Master Organization Id - ' || to_char(l_master_org));
287: msd_dem_common_utilities.log_debug('Category Set Id - ' || to_char(l_category_set_id));
288: END IF;
289:
290: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10));
291: IF (p_collect_level_type = 1)
292: THEN
293: execute immediate l_stmt;
294: ELSIF (p_collect_level_type = 2)

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

327: EXECUTE IMMEDIATE l_stmt;
328: end if;
329:
330: END IF;
331: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10));
332:
333: commit;
334:
335: retcode := 0;

Line 493: msd_dem_common_utilities.log_debug('Truncate Statement for ' || v_collect_level_type || fnd_global.local_chr(10) || l_stmt || fnd_global.local_chr(10));

489: retcode := -1;
490: return;
491: end if;
492:
493: msd_dem_common_utilities.log_debug('Truncate Statement for ' || v_collect_level_type || fnd_global.local_chr(10) || l_stmt || fnd_global.local_chr(10));
494:
495:
496: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10));
497: execute immediate l_stmt;

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

492:
493: msd_dem_common_utilities.log_debug('Truncate Statement for ' || v_collect_level_type || fnd_global.local_chr(10) || l_stmt || fnd_global.local_chr(10));
494:
495:
496: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10));
497: execute immediate l_stmt;
498: execute immediate l_stmt || '_err'; --saravan Bug# 6357056
499: msd_dem_common_utilities.log_debug('Truncated'|| l_stmt || '_err'||'Table'); -- saravan
500: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10));

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

496: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10));
497: execute immediate l_stmt;
498: execute immediate l_stmt || '_err'; --saravan Bug# 6357056
499: msd_dem_common_utilities.log_debug('Truncated'|| l_stmt || '_err'||'Table'); -- saravan
500: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10));
501:
502: retcode := 0;
503:
504: exception

Line 692: msd_dem_common_utilities.log_message('Collecting '|| v_collect_level_type || fnd_global.local_chr(10));

688: End if ;
689:
690: select decode(p_collect_level_type, 1 , 'Locations', 2, 'Items') into v_collect_level_type from dual;
691:
692: msd_dem_common_utilities.log_message('Collecting '|| v_collect_level_type || fnd_global.local_chr(10));
693: msd_dem_common_utilities.log_debug('Collecting '|| v_collect_level_type || fnd_global.local_chr(10));
694:
695: msd_dem_common_utilities.log_message('Step 1: Cleaning up staging tables for ' || v_collect_level_type || fnd_global.local_chr(10));
696: msd_dem_common_utilities.log_debug('Step 1: Cleaning up staging tables for ' || v_collect_level_type || fnd_global.local_chr(10));

Line 693: msd_dem_common_utilities.log_debug('Collecting '|| v_collect_level_type || fnd_global.local_chr(10));

689:
690: select decode(p_collect_level_type, 1 , 'Locations', 2, 'Items') into v_collect_level_type from dual;
691:
692: msd_dem_common_utilities.log_message('Collecting '|| v_collect_level_type || fnd_global.local_chr(10));
693: msd_dem_common_utilities.log_debug('Collecting '|| v_collect_level_type || fnd_global.local_chr(10));
694:
695: msd_dem_common_utilities.log_message('Step 1: Cleaning up staging tables for ' || v_collect_level_type || fnd_global.local_chr(10));
696: msd_dem_common_utilities.log_debug('Step 1: Cleaning up staging tables for ' || v_collect_level_type || fnd_global.local_chr(10));
697: truncate_tables(errbuf,retcode,p_collect_level_type);

Line 695: msd_dem_common_utilities.log_message('Step 1: Cleaning up staging tables for ' || v_collect_level_type || fnd_global.local_chr(10));

691:
692: msd_dem_common_utilities.log_message('Collecting '|| v_collect_level_type || fnd_global.local_chr(10));
693: msd_dem_common_utilities.log_debug('Collecting '|| v_collect_level_type || fnd_global.local_chr(10));
694:
695: msd_dem_common_utilities.log_message('Step 1: Cleaning up staging tables for ' || v_collect_level_type || fnd_global.local_chr(10));
696: msd_dem_common_utilities.log_debug('Step 1: Cleaning up staging tables for ' || v_collect_level_type || fnd_global.local_chr(10));
697: truncate_tables(errbuf,retcode,p_collect_level_type);
698:
699: if retcode = -1 then

Line 696: msd_dem_common_utilities.log_debug('Step 1: Cleaning up staging tables for ' || v_collect_level_type || fnd_global.local_chr(10));

692: msd_dem_common_utilities.log_message('Collecting '|| v_collect_level_type || fnd_global.local_chr(10));
693: msd_dem_common_utilities.log_debug('Collecting '|| v_collect_level_type || fnd_global.local_chr(10));
694:
695: msd_dem_common_utilities.log_message('Step 1: Cleaning up staging tables for ' || v_collect_level_type || fnd_global.local_chr(10));
696: msd_dem_common_utilities.log_debug('Step 1: Cleaning up staging tables for ' || v_collect_level_type || fnd_global.local_chr(10));
697: truncate_tables(errbuf,retcode,p_collect_level_type);
698:
699: if retcode = -1 then
700: return;

Line 703: msd_dem_common_utilities.log_message('Step 2: Populating Temporary Tables ' || v_collect_level_type || fnd_global.local_chr(10));

699: if retcode = -1 then
700: return;
701: end if;
702:
703: msd_dem_common_utilities.log_message('Step 2: Populating Temporary Tables ' || v_collect_level_type || fnd_global.local_chr(10));
704: msd_dem_common_utilities.log_debug('Step 2: Populating Temporary Tables ' || v_collect_level_type || fnd_global.local_chr(10));
705: populate_temporary_tables(errbuf,retcode,p_instance_id,p_collect_level_type, p_plan_id);
706:
707: if retcode = -1 then

Line 704: msd_dem_common_utilities.log_debug('Step 2: Populating Temporary Tables ' || v_collect_level_type || fnd_global.local_chr(10));

700: return;
701: end if;
702:
703: msd_dem_common_utilities.log_message('Step 2: Populating Temporary Tables ' || v_collect_level_type || fnd_global.local_chr(10));
704: msd_dem_common_utilities.log_debug('Step 2: Populating Temporary Tables ' || v_collect_level_type || fnd_global.local_chr(10));
705: populate_temporary_tables(errbuf,retcode,p_instance_id,p_collect_level_type, p_plan_id);
706:
707: if retcode = -1 then
708: return;

Line 711: msd_dem_common_utilities.log_message('Step 3: Populating Demantra Staging Tables ' || v_collect_level_type || fnd_global.local_chr(10));

707: if retcode = -1 then
708: return;
709: end if;
710:
711: msd_dem_common_utilities.log_message('Step 3: Populating Demantra Staging Tables ' || v_collect_level_type || fnd_global.local_chr(10));
712: msd_dem_common_utilities.log_debug('Step 3: Populating Demantra Staging Tables ' || v_collect_level_type || fnd_global.local_chr(10));
713: populate_demantra_staging(errbuf,retcode, p_instance_id, p_collect_level_type, p_plan_id);
714:
715: if retcode = -1 then

Line 712: msd_dem_common_utilities.log_debug('Step 3: Populating Demantra Staging Tables ' || v_collect_level_type || fnd_global.local_chr(10));

708: return;
709: end if;
710:
711: msd_dem_common_utilities.log_message('Step 3: Populating Demantra Staging Tables ' || v_collect_level_type || fnd_global.local_chr(10));
712: msd_dem_common_utilities.log_debug('Step 3: Populating Demantra Staging Tables ' || v_collect_level_type || fnd_global.local_chr(10));
713: populate_demantra_staging(errbuf,retcode, p_instance_id, p_collect_level_type, p_plan_id);
714:
715: if retcode = -1 then
716: return;

Line 736: msd_dem_common_utilities.log_message('Step 4: Updating Demantra Item Staging Table for item_type level' || fnd_global.local_chr(10));

732: /* Call Custom Hook for Item/Location */
733: IF (p_collect_level_type = 2) /* ITEM */
734: THEN
735:
736: msd_dem_common_utilities.log_message('Step 4: Updating Demantra Item Staging Table for item_type level' || fnd_global.local_chr(10));
737: msd_dem_common_utilities.log_debug('Step 4: Updating Demantra Item Staging Table for item_type level' || fnd_global.local_chr(10));
738: populate_item_type(errbuf,retcode);
739:
740: IF retcode = -1 THEN

Line 737: msd_dem_common_utilities.log_debug('Step 4: Updating Demantra Item Staging Table for item_type level' || fnd_global.local_chr(10));

733: IF (p_collect_level_type = 2) /* ITEM */
734: THEN
735:
736: msd_dem_common_utilities.log_message('Step 4: Updating Demantra Item Staging Table for item_type level' || fnd_global.local_chr(10));
737: msd_dem_common_utilities.log_debug('Step 4: Updating Demantra Item Staging Table for item_type level' || fnd_global.local_chr(10));
738: populate_item_type(errbuf,retcode);
739:
740: IF retcode = -1 THEN
741: RETURN;