APPS.MSD_DEM_QUERY_UTILITIES dependencies on MSD_DEM_QUERY_UTILITIES

Line 1: PACKAGE BODY MSD_DEM_QUERY_UTILITIES AS

1: PACKAGE BODY MSD_DEM_QUERY_UTILITIES AS
2: /* $Header: msddemqutlb.pls 120.2.12000000.2 2007/09/24 11:14:56 nallkuma noship $ */
3:
4: v_srdblink varchar2(100);
5:

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 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 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 286: log_debug ('Entering: msd_dem_query_utilities.get_query2 - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

282: x_view_name VARCHAR2(100) := NULL;
283: x_is_view_valid NUMBER := NULL;
284:
285: BEGIN
286: log_debug ('Entering: msd_dem_query_utilities.get_query2 - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
287:
288: IF (p_series_type = 1)
289: THEN
290: get_db_link(p_instance_id, v_srdblink, retcode);

Line 293: log_message ('Error(1): msd_dem_query_utilities.get_query2 - Unable to get db_link' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

289: THEN
290: get_db_link(p_instance_id, v_srdblink, retcode);
291: IF (retcode = -1)
292: THEN
293: log_message ('Error(1): msd_dem_query_utilities.get_query2 - Unable to get db_link' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
294: query := NULL;
295: RETURN;
296: END IF;
297: ELSE

Line 420: log_message ('Error(2): msd_dem_query_utilities.get_query2 - ');

416: WHEN NO_DATA_FOUND THEN
417: NULL;
418: WHEN OTHERS THEN
419: retcode := -1;
420: log_message ('Error(2): msd_dem_query_utilities.get_query2 - ');
421: log_message ('The source view ' || x_view_name || ' was not created sucessfully');
422: END;
423: ELSE
424: log_message('Custom View ' || x_view_name || ' used.');

Line 427: log_debug ('Exiting: msd_dem_query_utilities.get_query2 - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

423: ELSE
424: log_message('Custom View ' || x_view_name || ' used.');
425: END IF;
426:
427: log_debug ('Exiting: msd_dem_query_utilities.get_query2 - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
428:
429: EXCEPTION
430: WHEN OTHERS THEN
431: log_message (substr(SQLERRM,1,150));

Line 437: END MSD_DEM_QUERY_UTILITIES;

433:
434: END GET_QUERY3;
435:
436:
437: END MSD_DEM_QUERY_UTILITIES;
438: