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

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

58: -- bug#8367471(fp for bug#6087699) nallkuma
59: if l_instance_type in (1,2,4) then
60: msd_dem_push_setup_parameters.push_setup_parameters(ERRBUF, RETCODE, p_instance_id, '-999');
61: if retcode = -1 then
62: msd_dem_common_utilities.log_message('Push Setup Parameters Failed');
63: msd_dem_common_utilities.log_debug('Push Setup Parameters Failed');
64: return;
65: end if;
66: else

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

59: if l_instance_type in (1,2,4) then
60: msd_dem_push_setup_parameters.push_setup_parameters(ERRBUF, RETCODE, p_instance_id, '-999');
61: if retcode = -1 then
62: msd_dem_common_utilities.log_message('Push Setup Parameters Failed');
63: msd_dem_common_utilities.log_debug('Push Setup Parameters Failed');
64: return;
65: end if;
66: else
67: /* Calling push_legacy_setup_parameters() procedure in case of pure legacy instance */

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

66: else
67: /* Calling push_legacy_setup_parameters() procedure in case of pure legacy instance */
68: msd_dem_push_setup_parameters.push_legacy_setup_parameters(ERRBUF, RETCODE, p_instance_id);
69: if retcode = -1 then
70: msd_dem_common_utilities.log_message('Push Legacy Setup Parameters Failed');
71: msd_dem_common_utilities.log_debug('Push Legacy Setup Parameters Failed');
72: return;
73: end if;
74: end if;

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

67: /* Calling push_legacy_setup_parameters() procedure in case of pure legacy instance */
68: msd_dem_push_setup_parameters.push_legacy_setup_parameters(ERRBUF, RETCODE, p_instance_id);
69: if retcode = -1 then
70: msd_dem_common_utilities.log_message('Push Legacy Setup Parameters Failed');
71: msd_dem_common_utilities.log_debug('Push Legacy Setup Parameters Failed');
72: return;
73: end if;
74: end if;
75:

Line 90: l_schema_name := substr(msd_dem_common_utilities.get_lookup_value('MSD_DEM_DM_STAGING_TABLES','SALES_STAGING_TABLE')

86: end if;
87: */
88:
89: -- bug#8367504 nallkuma
90: l_schema_name := substr(msd_dem_common_utilities.get_lookup_value('MSD_DEM_DM_STAGING_TABLES','SALES_STAGING_TABLE')
91: , 1
92: , instr(msd_dem_common_utilities.get_lookup_value('MSD_DEM_DM_STAGING_TABLES','SALES_STAGING_TABLE'), '.')-1) ;
93:
94: LOG_MESSAGE('Fetched the schema name as : '||l_schema_name);

Line 92: , instr(msd_dem_common_utilities.get_lookup_value('MSD_DEM_DM_STAGING_TABLES','SALES_STAGING_TABLE'), '.')-1) ;

88:
89: -- bug#8367504 nallkuma
90: l_schema_name := substr(msd_dem_common_utilities.get_lookup_value('MSD_DEM_DM_STAGING_TABLES','SALES_STAGING_TABLE')
91: , 1
92: , instr(msd_dem_common_utilities.get_lookup_value('MSD_DEM_DM_STAGING_TABLES','SALES_STAGING_TABLE'), '.')-1) ;
93:
94: LOG_MESSAGE('Fetched the schema name as : '||l_schema_name);
95:
96: l_dem_version := fnd_profile.value('MSD_DEM_VERSION');

Line 237: IF (msd_dem_common_utilities.is_use_new_site_format <> 0)

233: END IF;
234:
235: EXECUTE IMMEDIATE lv_sql_stmt;
236:
237: IF (msd_dem_common_utilities.is_use_new_site_format <> 0)
238: THEN
239:
240: lv_sql_stmt :=
241: ' UPDATE '||l_schema_name||'.'||'t_src_sales_tmpl t1 '

Line 415: msd_dem_common_utilities.log_debug ('Begin Insert dummy rows for new items into the staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

411:
412: commit;
413:
414: /* Insert dummy rows in the staging table for new items */
415: msd_dem_common_utilities.log_debug ('Begin Insert dummy rows for new items into the staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
416:
417: msd_dem_collect_history_data.insert_dummy_rows (
418: errbuf,
419: retcode,

Line 425: msd_dem_common_utilities.log_message ('Warning(1): msd_dem_process_sales_data.launch - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

421: p_instance_id);
422:
423: IF (retcode = 1)
424: THEN
425: msd_dem_common_utilities.log_message ('Warning(1): msd_dem_process_sales_data.launch - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
426: msd_dem_common_utilities.log_message ('Error while inserting dummy rows into the sales staging table for new items. ');
427: END IF;
428:
429:

Line 426: msd_dem_common_utilities.log_message ('Error while inserting dummy rows into the sales staging table for new items. ');

422:
423: IF (retcode = 1)
424: THEN
425: msd_dem_common_utilities.log_message ('Warning(1): msd_dem_process_sales_data.launch - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
426: msd_dem_common_utilities.log_message ('Error while inserting dummy rows into the sales staging table for new items. ');
427: END IF;
428:
429:
430: msd_dem_common_utilities.log_debug ('End Insert dummy rows for new items into the staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

Line 430: msd_dem_common_utilities.log_debug ('End Insert dummy rows for new items into the staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

426: msd_dem_common_utilities.log_message ('Error while inserting dummy rows into the sales staging table for new items. ');
427: END IF;
428:
429:
430: msd_dem_common_utilities.log_debug ('End Insert dummy rows for new items into the staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
431:
432:
433: --Final commit
434: commit;

Line 437: l_dest_table := msd_dem_common_utilities.get_lookup_value('MSD_DEM_DM_STAGING_TABLES','SALES_STAGING_TABLE');

433: --Final commit
434: commit;
435:
436: /* Get the sales staging table name */ -- syenamar Bug#6459492
437: l_dest_table := msd_dem_common_utilities.get_lookup_value('MSD_DEM_DM_STAGING_TABLES','SALES_STAGING_TABLE');
438:
439: IF (l_dest_table is NULL)
440: THEN
441: RETCODE := -1;

Line 443: msd_dem_common_utilities.log_message ('MSD_DEM_PROCESS_SALES_DATA.LAUNCH - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

439: IF (l_dest_table is NULL)
440: THEN
441: RETCODE := -1;
442: ERRBUF := 'Unable to find the sales staging tables.';
443: msd_dem_common_utilities.log_message ('MSD_DEM_PROCESS_SALES_DATA.LAUNCH - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
444: msd_dem_common_utilities.log_message (ERRBUF);
445: RETURN;
446: END IF;
447:

Line 444: msd_dem_common_utilities.log_message (ERRBUF);

440: THEN
441: RETCODE := -1;
442: ERRBUF := 'Unable to find the sales staging tables.';
443: msd_dem_common_utilities.log_message ('MSD_DEM_PROCESS_SALES_DATA.LAUNCH - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
444: msd_dem_common_utilities.log_message (ERRBUF);
445: RETURN;
446: END IF;
447:
448: IF (l_schema_name <> 'MSD' ) then -- BUG#8367504 nallkuma

Line 450: msd_dem_common_utilities.log_debug ('Begin: Delete from sales staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

446: END IF;
447:
448: IF (l_schema_name <> 'MSD' ) then -- BUG#8367504 nallkuma
449:
450: msd_dem_common_utilities.log_debug ('Begin: Delete from sales staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
451:
452: /* Truncate the sales staging table */
453: msd_dem_common_utilities.log_debug ('Deleting data from ERR table - ' || l_dest_table ||'_err');
454: lv_sql_stmt := 'TRUNCATE TABLE ' || l_dest_table ||'_err';

Line 453: msd_dem_common_utilities.log_debug ('Deleting data from ERR table - ' || l_dest_table ||'_err');

449:
450: msd_dem_common_utilities.log_debug ('Begin: Delete from sales staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
451:
452: /* Truncate the sales staging table */
453: msd_dem_common_utilities.log_debug ('Deleting data from ERR table - ' || l_dest_table ||'_err');
454: lv_sql_stmt := 'TRUNCATE TABLE ' || l_dest_table ||'_err';
455: EXECUTE IMMEDIATE lv_sql_stmt;
456:
457: msd_dem_common_utilities.log_debug ('End: Delete from ERR table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); -- syenamar

Line 457: msd_dem_common_utilities.log_debug ('End: Delete from ERR table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); -- syenamar

453: msd_dem_common_utilities.log_debug ('Deleting data from ERR table - ' || l_dest_table ||'_err');
454: lv_sql_stmt := 'TRUNCATE TABLE ' || l_dest_table ||'_err';
455: EXECUTE IMMEDIATE lv_sql_stmt;
456:
457: msd_dem_common_utilities.log_debug ('End: Delete from ERR table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); -- syenamar
458:
459: End if;
460:
461: LOG_MESSAGE ('***************** Exiting from the procedure - LAUNCH **********');