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 58: msd_dem_common_utilities.log_message('Push Setup Parameters Failed');

54:
55: if l_instance_type in (1,2,4) then
56: msd_dem_push_setup_parameters.push_setup_parameters(ERRBUF, RETCODE, p_instance_id, '-999');
57: if retcode = -1 then
58: msd_dem_common_utilities.log_message('Push Setup Parameters Failed');
59: msd_dem_common_utilities.log_debug('Push Setup Parameters Failed');
60: return;
61: end if;
62: else

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

55: if l_instance_type in (1,2,4) then
56: msd_dem_push_setup_parameters.push_setup_parameters(ERRBUF, RETCODE, p_instance_id, '-999');
57: if retcode = -1 then
58: msd_dem_common_utilities.log_message('Push Setup Parameters Failed');
59: msd_dem_common_utilities.log_debug('Push Setup Parameters Failed');
60: return;
61: end if;
62: else
63: LOG_MESSAGE('Push Setup Parameters will not be called since this is a pure legacy instance');

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

320: --Final commit
321: commit;
322:
323: /* Get the sales staging table name */ -- syenamar Bug#6459492
324: l_dest_table := msd_dem_common_utilities.get_lookup_value('MSD_DEM_DM_STAGING_TABLES','SALES_STAGING_TABLE');
325:
326: IF (l_dest_table is NULL)
327: THEN
328: RETCODE := -1;

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

326: IF (l_dest_table is NULL)
327: THEN
328: RETCODE := -1;
329: ERRBUF := 'Unable to find the sales staging tables.';
330: msd_dem_common_utilities.log_message ('MSD_DEM_PROCESS_SALES_DATA.LAUNCH - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
331: msd_dem_common_utilities.log_message (ERRBUF);
332: RETURN;
333: END IF;
334:

Line 331: msd_dem_common_utilities.log_message (ERRBUF);

327: THEN
328: RETCODE := -1;
329: ERRBUF := 'Unable to find the sales staging tables.';
330: msd_dem_common_utilities.log_message ('MSD_DEM_PROCESS_SALES_DATA.LAUNCH - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
331: msd_dem_common_utilities.log_message (ERRBUF);
332: RETURN;
333: END IF;
334:
335: msd_dem_common_utilities.log_debug ('Begin: Delete from sales staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

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

331: msd_dem_common_utilities.log_message (ERRBUF);
332: RETURN;
333: END IF;
334:
335: msd_dem_common_utilities.log_debug ('Begin: Delete from sales staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
336:
337: /* Truncate the sales staging table */
338: msd_dem_common_utilities.log_debug ('Deleting data from ERR table - ' || l_dest_table ||'_err');
339: lv_sql_stmt := 'TRUNCATE TABLE ' || l_dest_table ||'_err';

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

334:
335: msd_dem_common_utilities.log_debug ('Begin: Delete from sales staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
336:
337: /* Truncate the sales staging table */
338: msd_dem_common_utilities.log_debug ('Deleting data from ERR table - ' || l_dest_table ||'_err');
339: lv_sql_stmt := 'TRUNCATE TABLE ' || l_dest_table ||'_err';
340: EXECUTE IMMEDIATE lv_sql_stmt;
341:
342: msd_dem_common_utilities.log_debug ('End: Delete from ERR table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); -- syenamar

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

338: msd_dem_common_utilities.log_debug ('Deleting data from ERR table - ' || l_dest_table ||'_err');
339: lv_sql_stmt := 'TRUNCATE TABLE ' || l_dest_table ||'_err';
340: EXECUTE IMMEDIATE lv_sql_stmt;
341:
342: msd_dem_common_utilities.log_debug ('End: Delete from ERR table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); -- syenamar
343:
344: LOG_MESSAGE ('***************** Exiting from the procedure - LAUNCH **********');
345:
346: EXCEPTION