APPS.MSD_DEM_UPDATE_LEVEL_CODES dependencies on MSD_DEM_COMMON_UTILITIES

Line 19: msd_dem_common_utilities.log_message('Updating Memeber Codes in Sales Data for ' || p_level );

15: l_stmt varchar2(4000);
16:
17: begin
18:
19: msd_dem_common_utilities.log_message('Updating Memeber Codes in Sales Data for ' || p_level );
20: msd_dem_common_utilities.log_debug('Updating Memeber Codes in Sales Data' || p_level );
21:
22: l_stmt := null;
23:

Line 20: msd_dem_common_utilities.log_debug('Updating Memeber Codes in Sales Data' || p_level );

16:
17: begin
18:
19: msd_dem_common_utilities.log_message('Updating Memeber Codes in Sales Data for ' || p_level );
20: msd_dem_common_utilities.log_debug('Updating Memeber Codes in Sales Data' || p_level );
21:
22: l_stmt := null;
23:
24: dbms_output.put_line(p_dest_table_name || p_dest_column_name || p_src_coulmn_name || p_instance_id);

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

32: l_stmt := replace(l_stmt, 'SRC_COLUMN', p_src_coulmn_name);
33:
34: end if;
35:
36: msd_dem_common_utilities.log_debug('Executed Statement: ');
37: msd_dem_common_utilities.log_debug(l_stmt);
38:
39: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') );
40: execute immediate l_stmt using p_instance_id;

Line 37: msd_dem_common_utilities.log_debug(l_stmt);

33:
34: end if;
35:
36: msd_dem_common_utilities.log_debug('Executed Statement: ');
37: msd_dem_common_utilities.log_debug(l_stmt);
38:
39: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') );
40: execute immediate l_stmt using p_instance_id;
41: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') );

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

35:
36: msd_dem_common_utilities.log_debug('Executed Statement: ');
37: msd_dem_common_utilities.log_debug(l_stmt);
38:
39: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') );
40: execute immediate l_stmt using p_instance_id;
41: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') );
42:
43: commit;

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

37: msd_dem_common_utilities.log_debug(l_stmt);
38:
39: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') );
40: execute immediate l_stmt using p_instance_id;
41: msd_dem_common_utilities.log_debug('End Time: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') );
42:
43: commit;
44:
45: retcode := 0;

Line 50: msd_dem_common_utilities.log_message(errbuf);

46:
47: exception
48: when others then
49: errbuf := substr(SQLERRM,1,150);
50: msd_dem_common_utilities.log_message(errbuf);
51: msd_dem_common_utilities.log_debug(errbuf);
52: retcode := -1;
53:
54: end;

Line 51: msd_dem_common_utilities.log_debug(errbuf);

47: exception
48: when others then
49: errbuf := substr(SQLERRM,1,150);
50: msd_dem_common_utilities.log_message(errbuf);
51: msd_dem_common_utilities.log_debug(errbuf);
52: retcode := -1;
53:
54: end;
55: