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

Line 47: msd_dem_common_utilities.log_debug ('Check for unique index MSD_DEM_DPT_REP_USG_HIST_U1');

43:
44: /* 10224184 - Check and drop unique indexes before data load */
45: IF instr(file_name,'DptRepUsgHist')>0 THEN
46:
47: msd_dem_common_utilities.log_debug ('Check for unique index MSD_DEM_DPT_REP_USG_HIST_U1');
48: OPEN c_check_ui(C_DR_UI);
49: FETCH c_check_ui INTO x_is_present;
50: CLOSE c_check_ui;
51:

Line 54: msd_dem_common_utilities.log_debug ('Found unique index MSD_DEM_DPT_REP_USG_HIST_U1');

50: CLOSE c_check_ui;
51:
52: IF (x_is_present = 1) THEN
53:
54: msd_dem_common_utilities.log_debug ('Found unique index MSD_DEM_DPT_REP_USG_HIST_U1');
55:
56: OPEN c_get_ui(C_DR_UI);
57: FETCH c_get_ui INTO x_owner;
58: CLOSE c_get_ui;

Line 61: msd_dem_common_utilities.log_debug ('Executing sql - ' || x_sql);

57: FETCH c_get_ui INTO x_owner;
58: CLOSE c_get_ui;
59:
60: x_sql := 'DROP INDEX ' || x_owner || '.' || C_DR_UI;
61: msd_dem_common_utilities.log_debug ('Executing sql - ' || x_sql);
62: EXECUTE IMMEDIATE x_sql;
63: msd_dem_common_utilities.log_message ('Dropped unique index ' || C_DR_UI);
64:
65: END IF;

Line 63: msd_dem_common_utilities.log_message ('Dropped unique index ' || C_DR_UI);

59:
60: x_sql := 'DROP INDEX ' || x_owner || '.' || C_DR_UI;
61: msd_dem_common_utilities.log_debug ('Executing sql - ' || x_sql);
62: EXECUTE IMMEDIATE x_sql;
63: msd_dem_common_utilities.log_message ('Dropped unique index ' || C_DR_UI);
64:
65: END IF;
66:
67: END IF;

Line 71: msd_dem_common_utilities.log_debug ('Check for unique index MSD_DEM_FLD_SER_USG_HIST_U1');

67: END IF;
68:
69: IF instr(file_name,'FldSerUsgHist')>0 THEN
70:
71: msd_dem_common_utilities.log_debug ('Check for unique index MSD_DEM_FLD_SER_USG_HIST_U1');
72: OPEN c_check_ui(C_FS_UI);
73: FETCH c_check_ui INTO x_is_present;
74: CLOSE c_check_ui;
75:

Line 78: msd_dem_common_utilities.log_debug ('Found unique index MSD_DEM_FLD_SER_USG_HIST_U1');

74: CLOSE c_check_ui;
75:
76: IF (x_is_present = 1) THEN
77:
78: msd_dem_common_utilities.log_debug ('Found unique index MSD_DEM_FLD_SER_USG_HIST_U1');
79:
80: OPEN c_get_ui(C_FS_UI);
81: FETCH c_get_ui INTO x_owner;
82: CLOSE c_get_ui;

Line 85: msd_dem_common_utilities.log_debug ('Executing sql - ' || x_sql);

81: FETCH c_get_ui INTO x_owner;
82: CLOSE c_get_ui;
83:
84: x_sql := 'DROP INDEX ' || x_owner || '.' || C_FS_UI;
85: msd_dem_common_utilities.log_debug ('Executing sql - ' || x_sql);
86: EXECUTE IMMEDIATE x_sql;
87: msd_dem_common_utilities.log_message ('Dropped unique index ' || C_FS_UI);
88:
89: END IF;

Line 87: msd_dem_common_utilities.log_message ('Dropped unique index ' || C_FS_UI);

83:
84: x_sql := 'DROP INDEX ' || x_owner || '.' || C_FS_UI;
85: msd_dem_common_utilities.log_debug ('Executing sql - ' || x_sql);
86: EXECUTE IMMEDIATE x_sql;
87: msd_dem_common_utilities.log_message ('Dropped unique index ' || C_FS_UI);
88:
89: END IF;
90:
91: END IF;

Line 95: msd_dem_common_utilities.log_debug ('Check for unique index MSD_DEM_SRP_RET_HIST_U1');

91: END IF;
92:
93: IF instr(file_name,'SerPartRetHist')>0 THEN
94:
95: msd_dem_common_utilities.log_debug ('Check for unique index MSD_DEM_SRP_RET_HIST_U1');
96: OPEN c_check_ui(C_SR_UI);
97: FETCH c_check_ui INTO x_is_present;
98: CLOSE c_check_ui;
99:

Line 102: msd_dem_common_utilities.log_debug ('Found unique index MSD_DEM_SRP_RET_HIST_U1');

98: CLOSE c_check_ui;
99:
100: IF (x_is_present = 1) THEN
101:
102: msd_dem_common_utilities.log_debug ('Found unique index MSD_DEM_SRP_RET_HIST_U1');
103:
104: OPEN c_get_ui(C_SR_UI);
105: FETCH c_get_ui INTO x_owner;
106: CLOSE c_get_ui;

Line 109: msd_dem_common_utilities.log_debug ('Executing sql - ' || x_sql);

105: FETCH c_get_ui INTO x_owner;
106: CLOSE c_get_ui;
107:
108: x_sql := 'DROP INDEX ' || x_owner || '.' || C_SR_UI;
109: msd_dem_common_utilities.log_debug ('Executing sql - ' || x_sql);
110: EXECUTE IMMEDIATE x_sql;
111: msd_dem_common_utilities.log_message ('Dropped unique index ' || C_SR_UI);
112:
113: END IF;

Line 111: msd_dem_common_utilities.log_message ('Dropped unique index ' || C_SR_UI);

107:
108: x_sql := 'DROP INDEX ' || x_owner || '.' || C_SR_UI;
109: msd_dem_common_utilities.log_debug ('Executing sql - ' || x_sql);
110: EXECUTE IMMEDIATE x_sql;
111: msd_dem_common_utilities.log_message ('Dropped unique index ' || C_SR_UI);
112:
113: END IF;
114:
115: END IF;

Line 220: msd_dem_common_utilities.log_message ('msd_srp_ssl_rs.run_rs - ERROR ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

216: EXCEPTION
217: WHEN OTHERS THEN
218: retcode := -1;
219: errbuf := substr(SQLERRM,1,150);
220: msd_dem_common_utilities.log_message ('msd_srp_ssl_rs.run_rs - ERROR ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
221: msd_dem_common_utilities.log_message ('Error while submitting request for collecting usage history');
222: msd_dem_common_utilities.log_message (errbuf);
223: raise l_submit_failed;
224:

Line 221: msd_dem_common_utilities.log_message ('Error while submitting request for collecting usage history');

217: WHEN OTHERS THEN
218: retcode := -1;
219: errbuf := substr(SQLERRM,1,150);
220: msd_dem_common_utilities.log_message ('msd_srp_ssl_rs.run_rs - ERROR ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
221: msd_dem_common_utilities.log_message ('Error while submitting request for collecting usage history');
222: msd_dem_common_utilities.log_message (errbuf);
223: raise l_submit_failed;
224:
225: END;

Line 222: msd_dem_common_utilities.log_message (errbuf);

218: retcode := -1;
219: errbuf := substr(SQLERRM,1,150);
220: msd_dem_common_utilities.log_message ('msd_srp_ssl_rs.run_rs - ERROR ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
221: msd_dem_common_utilities.log_message ('Error while submitting request for collecting usage history');
222: msd_dem_common_utilities.log_message (errbuf);
223: raise l_submit_failed;
224:
225: END;
226:

Line 235: msd_dem_common_utilities.log_message(errbuf);

231: retcode := 0;
232: exception
233: when l_submit_failed then
234: errbuf := 'Launching Request Set failed for SRP Streams';
235: msd_dem_common_utilities.log_message(errbuf);
236: msd_dem_common_utilities.log_debug(errbuf);
237: retcode := -1;
238: when others then
239: errbuf := substr(SQLERRM,1,150);

Line 236: msd_dem_common_utilities.log_debug(errbuf);

232: exception
233: when l_submit_failed then
234: errbuf := 'Launching Request Set failed for SRP Streams';
235: msd_dem_common_utilities.log_message(errbuf);
236: msd_dem_common_utilities.log_debug(errbuf);
237: retcode := -1;
238: when others then
239: errbuf := substr(SQLERRM,1,150);
240: msd_dem_common_utilities.log_message(errbuf);

Line 240: msd_dem_common_utilities.log_message(errbuf);

236: msd_dem_common_utilities.log_debug(errbuf);
237: retcode := -1;
238: when others then
239: errbuf := substr(SQLERRM,1,150);
240: msd_dem_common_utilities.log_message(errbuf);
241: msd_dem_common_utilities.log_debug(errbuf);
242: retcode := -1;
243:
244: end;

Line 241: msd_dem_common_utilities.log_debug(errbuf);

237: retcode := -1;
238: when others then
239: errbuf := substr(SQLERRM,1,150);
240: msd_dem_common_utilities.log_message(errbuf);
241: msd_dem_common_utilities.log_debug(errbuf);
242: retcode := -1;
243:
244: end;
245: