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_QUERY_UTILITIES

Line 1: PACKAGE BODY MSD_DEM_QUERY_UTILITIES AS

1: PACKAGE BODY MSD_DEM_QUERY_UTILITIES AS
2: /* $Header: msddemqutlb.pls 120.6 2011/12/08 09:08:08 rissingh ship $ */
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 468: msd_dem_common_utilities.log_debug ('Entering: msd_dem_query_utilities.execute_query - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

464: x_value VARCHAR2(500) := NULL;
465:
466: BEGIN
467:
468: msd_dem_common_utilities.log_debug ('Entering: msd_dem_query_utilities.execute_query - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
469:
470: /* Log the parameters */
471: msd_dem_common_utilities.log_debug (' Entity Name - ' || p_entity_name);
472: msd_dem_common_utilities.log_debug (' Instance Id - ' || to_char(p_sr_instance_id));

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

537: EXECUTE IMMEDIATE x_query;
538: COMMIT;
539: msd_dem_common_utilities.log_debug ('Query End Time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
540:
541: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_query_utilities.execute_query - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
542:
543: retcode := 0;
544:
545: EXCEPTION

Line 550: msd_dem_common_utilities.log_message ('Exception(1): msd_dem_query_utilities.execute_query - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

546: WHEN OTHERS THEN
547: errbuf := substr(SQLERRM,1,150);
548: retcode := -1;
549:
550: msd_dem_common_utilities.log_message ('Exception(1): msd_dem_query_utilities.execute_query - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
551: msd_dem_common_utilities.log_message (errbuf);
552: RETURN;
553:
554: END EXECUTE_QUERY;

Line 579: msd_dem_common_utilities.log_debug ('Entering: msd_dem_query_utilities.truncate_table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

575:
576:
577: BEGIN
578:
579: msd_dem_common_utilities.log_debug ('Entering: msd_dem_query_utilities.truncate_table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
580:
581: /* Log the parameters */
582: msd_dem_common_utilities.log_debug (' Table Name - ' || p_table_name);
583: msd_dem_common_utilities.log_debug (' Owner - ' || to_char(p_owner));

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

611: COMMIT;
612: END IF;
613: msd_dem_common_utilities.log_debug ('Query End Time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
614:
615: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_query_utilities.truncate_table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
616:
617: retcode := 0;
618:
619: EXCEPTION

Line 624: msd_dem_common_utilities.log_message ('Exception(1): msd_dem_query_utilities.truncate_table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

620: WHEN OTHERS THEN
621: errbuf := substr(SQLERRM,1,150);
622: retcode := -1;
623:
624: msd_dem_common_utilities.log_message ('Exception(1): msd_dem_query_utilities.truncate_table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
625: msd_dem_common_utilities.log_message (errbuf);
626: RETURN;
627:
628: END TRUNCATE_TABLE;

Line 631: END MSD_DEM_QUERY_UTILITIES;

627:
628: END TRUNCATE_TABLE;
629:
630:
631: END MSD_DEM_QUERY_UTILITIES;
632: