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

Line 53: p_retcode := 0; /* Should be changed to proper constants from msd_dem_common_utilities */

49:
50:
51: -- zia: changed retcode to 0, since 1 means warning
52: --p_retcode := 1 ;
53: p_retcode := 0; /* Should be changed to proper constants from msd_dem_common_utilities */
54:
55: Exception
56: when others then
57: p_dblink := null ;

Line 58: p_retcode := -1 ; /* Should be changed to proper constants from msd_dem_common_utilities */

54:
55: Exception
56: when others then
57: p_dblink := null ;
58: p_retcode := -1 ; /* Should be changed to proper constants from msd_dem_common_utilities */
59:
60:
61: End get_db_link ;
62:

Line 100: msd_dem_common_utilities.log_debug('In procedure: get_query');

96: and mdeq.entity_name = p_entity_name;
97:
98: begin
99:
100: msd_dem_common_utilities.log_debug('In procedure: get_query');
101: get_db_link(p_instance_id, v_srdblink, retcode);
102:
103: /*msd_dem_common_utilities.log_message();*/
104: msd_dem_common_utilities.log_debug('The instance dblink for this query will be: '|| v_srdblink );

Line 103: /msd_dem_common_utilities.log_message();/

99:
100: msd_dem_common_utilities.log_debug('In procedure: get_query');
101: get_db_link(p_instance_id, v_srdblink, retcode);
102:
103: /*msd_dem_common_utilities.log_message();*/
104: msd_dem_common_utilities.log_debug('The instance dblink for this query will be: '|| v_srdblink );
105:
106:
107: open c_get_part1_query;

Line 104: msd_dem_common_utilities.log_debug('The instance dblink for this query will be: '|| v_srdblink );

100: msd_dem_common_utilities.log_debug('In procedure: get_query');
101: get_db_link(p_instance_id, v_srdblink, retcode);
102:
103: /*msd_dem_common_utilities.log_message();*/
104: msd_dem_common_utilities.log_debug('The instance dblink for this query will be: '|| v_srdblink );
105:
106:
107: open c_get_part1_query;
108: fetch c_get_part1_query into l_part1_query;

Line 125: /msd_dem_common_utilities.log_debug('The final query is: ' || l_final_query ); /

121: l_final_query := replace(l_final_query, 'C_ADD_WHERE_CLAUSE', nvl(p_add_where_clause, ' 1 = 1 '));
122:
123: l_final_query := replace(l_final_query, 'DBLINK', v_srdblink);
124:
125: /*msd_dem_common_utilities.log_debug('The final query is: ' || l_final_query ); */
126:
127: query := l_final_query;
128:
129: exception

Line 131: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));

127: query := l_final_query;
128:
129: exception
130: when others then
131: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
132: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
133: retcode := -1;
134:
135: end get_query;

Line 132: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));

128:
129: exception
130: when others then
131: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
132: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
133: retcode := -1;
134:
135: end get_query;
136:

Line 167: msd_dem_common_utilities.log_debug('In procedure: msd_dem_query_utilities.get_query2');

163: c_get_parts c_get_cursor;
164:
165: begin
166:
167: msd_dem_common_utilities.log_debug('In procedure: msd_dem_query_utilities.get_query2');
168: get_db_link(p_instance_id, v_srdblink, retcode);
169:
170: /*msd_dem_common_utilities.log_message();*/
171: msd_dem_common_utilities.log_debug('The instance dblink for this query will be: '|| v_srdblink );

Line 170: /msd_dem_common_utilities.log_message();/

166:
167: msd_dem_common_utilities.log_debug('In procedure: msd_dem_query_utilities.get_query2');
168: get_db_link(p_instance_id, v_srdblink, retcode);
169:
170: /*msd_dem_common_utilities.log_message();*/
171: msd_dem_common_utilities.log_debug('The instance dblink for this query will be: '|| v_srdblink );
172:
173: open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part1 = mdq.query_id and mdeq.entity_name = p_entity_name;
174: fetch c_get_parts into l_part1_query;

Line 171: msd_dem_common_utilities.log_debug('The instance dblink for this query will be: '|| v_srdblink );

167: msd_dem_common_utilities.log_debug('In procedure: msd_dem_query_utilities.get_query2');
168: get_db_link(p_instance_id, v_srdblink, retcode);
169:
170: /*msd_dem_common_utilities.log_message();*/
171: msd_dem_common_utilities.log_debug('The instance dblink for this query will be: '|| v_srdblink );
172:
173: open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part1 = mdq.query_id and mdeq.entity_name = p_entity_name;
174: fetch c_get_parts into l_part1_query;
175: close c_get_parts;

Line 215: msd_dem_common_utilities.log_debug('key=' || key ||' value='||value || ' i = ' ||i);

211: value:=substr(keys_values,pos2+1,pos3-pos2-1);
212: exit when (instr(keys_values,'$',1,i+1)=0);
213: l_final_query := replace(l_final_query, key,value);
214: query := replace(query, key,value);
215: msd_dem_common_utilities.log_debug('key=' || key ||' value='||value || ' i = ' ||i);
216: end loop;
217: l_final_query := replace(l_final_query,'C_SOURCE_VIEW_NAME',cv_name);
218: query := replace(query,'C_DBLINK',v_srdblink);
219: query := replace(query,'C_SOURCE_VIEW_NAME',cv_name);

Line 227: msd_dem_common_utilities.log_debug('The query is: ' || l_final_query );

223: l_final_query:='
224: begin
225: MSD_DEM_SR_UTIL.EXECUTE_REMOTE_QUERY'||v_srdblink||'('''||l_final_query||''');
226: end;';
227: msd_dem_common_utilities.log_debug('The query is: ' || l_final_query );
228: execute immediate l_final_query;
229:
230: /* Check if the view created is VALID or NOT */
231: begin

Line 238: msd_dem_common_utilities.log_message ('Error: msd_dem_query_utilities.get_query2 - ');

234: when no_data_found then
235: null;
236: when others then
237: retcode := -1;
238: msd_dem_common_utilities.log_message ('Error: msd_dem_query_utilities.get_query2 - ');
239: msd_dem_common_utilities.log_message ('The source view ' || cv_name || ' was not created sucessfully');
240: end;
241: else
242: msd_dem_common_utilities.log_message('In msd_dem_query_utilities.get_query - ');

Line 239: msd_dem_common_utilities.log_message ('The source view ' || cv_name || ' was not created sucessfully');

235: null;
236: when others then
237: retcode := -1;
238: msd_dem_common_utilities.log_message ('Error: msd_dem_query_utilities.get_query2 - ');
239: msd_dem_common_utilities.log_message ('The source view ' || cv_name || ' was not created sucessfully');
240: end;
241: else
242: msd_dem_common_utilities.log_message('In msd_dem_query_utilities.get_query - ');
243: msd_dem_common_utilities.log_message('Custom View ' || cv_name || ' used.');

Line 242: msd_dem_common_utilities.log_message('In msd_dem_query_utilities.get_query - ');

238: msd_dem_common_utilities.log_message ('Error: msd_dem_query_utilities.get_query2 - ');
239: msd_dem_common_utilities.log_message ('The source view ' || cv_name || ' was not created sucessfully');
240: end;
241: else
242: msd_dem_common_utilities.log_message('In msd_dem_query_utilities.get_query - ');
243: msd_dem_common_utilities.log_message('Custom View ' || cv_name || ' used.');
244: end if;
245: exception
246: when others then

Line 243: msd_dem_common_utilities.log_message('Custom View ' || cv_name || ' used.');

239: msd_dem_common_utilities.log_message ('The source view ' || cv_name || ' was not created sucessfully');
240: end;
241: else
242: msd_dem_common_utilities.log_message('In msd_dem_query_utilities.get_query - ');
243: msd_dem_common_utilities.log_message('Custom View ' || cv_name || ' used.');
244: end if;
245: exception
246: when others then
247: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));

Line 247: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));

243: msd_dem_common_utilities.log_message('Custom View ' || cv_name || ' used.');
244: end if;
245: exception
246: when others then
247: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
248: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
249: retcode := -1;
250:
251: end get_query2;

Line 248: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));

244: end if;
245: exception
246: when others then
247: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));
248: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
249: retcode := -1;
250:
251: end get_query2;
252: