Rem drv:
Rem
Rem $Header: sdk_global_pkgdef.sql 31-jul-2007.05:44:38 pchebrol Exp $
Rem
Rem sdk_global_pkgdef.sql
Rem
Rem Copyright (c) 2002, 2007, Oracle. All rights reserved.
Rem
Rem NAME
Rem sdk_global_pkgdef.sql -
Rem
Rem DESCRIPTION
Rem
Rem
Rem NOTES
Rem
Rem
Rem MODIFIED (MM/DD/YY)
Rem pchebrol 06/22/07 - Backport shianand_core_5121288 from main
Rem pchebrol 06/21/07 -
Rem jsadras 07/21/07 - add timezone compare function
Rem jsadras 07/30/07 - Backport jsadras_bug-5092508 from main
Rem pshishir 05/18/07 -
Rem sbhagwat 09/19/06 - Retroactive blackout
Rem rpatti 08/14/06 - XbranchMerge rpatti_bug-4769518 from main
Rem rpatti 08/14/06 - XbranchMerge rpatti_bug-4769518 from main
Rem aragarwa 08/17/06 - Adding error codes for CS overwrite.
Rem mswamyt 08/24/06 - adding constants for event correlation
Rem rmaggarw 08/21/06 - add EVENT_LOCK_ERR
Rem rkpandey 07/31/06 - Add Exceptions to Monitoring Standards
Rem rmaggarw 08/10/06 - Event bus constants
Rem skini 08/14/06 - Exception for subscribe
Rem rpatti 08/09/06 - add new target type property remotely monitored
Rem lefeng 07/17/06 - bug 5074716: job owner must be registered
Rem lefeng 08/02/06 - Backport lefeng_bug-5074716 from main
Rem neearora 07/24/06 - project 21470. Added IGNORE_VIOLATION exception
Rem sthiruna 08/03/06 - Copying 10.2.0.3 CS changes from
Rem EMCORE_MAIN_LINUX
Rem lefeng 07/17/06 - bug 5074716: job owner must be registered
Rem rreilly 07/14/06 -
Rem aragarwa 07/11/06 - Adding CS_NOT_EXIST error for export.
Rem nmathuri 06/22/06 - Add Error messages for User Model
Rem vkhizder 06/05/06 - add metadata change exception for dmql
Rem neearora 05/04/06 - LOB callback project. Add constant
Rem G_LOADER_LOB_CALLBACK
Rem pshishir 05/04/06 -
Rem vkhizder 05/05/06 - more DMQL constants
Rem yxie 01/03/06 - add formsapp target type
Rem smodh 01/05/06 - add exceptions and predefined category names
Rem for target type categorization.
Rem vkhizder 04/24/06 - adding DMQL constants
Rem aragarwa 04/06/06 - Modifying CS policy doesn't exist error
Rem aragarwa 03/21/06 - Adding Message for Compliance standard already
Rem exist.
Rem kmanicka 02/23/06 - bug 5056981 add exception job_using_jobtype_delete
Rem skkunise 02/08/06 - Business category
Rem niramach 02/06/06 - Add constants for config standard evaluation
Rem exceptions.
Rem niramach 01/09/06 - 10.3 Work start: Add constants related to configuration
Rem standards.
Rem hbadheka 01/03/06 - add author/external metric
Rem jsadras 11/09/05 - db character set function
Rem rpinnama 09/23/05 - Fix 4595139 : Obtain settings lock before
Rem updating the settings
Rem rpinnama 09/02/05 - Add max_type_meta_ver constant
Rem gan 08/15/05 - add repo severity opt code
Rem mfidanbo 08/19/05 - add test_response metric constant
Rem vesriniv 07/30/05 - add customization support
Rem lgloyd 07/28/05 - add report error
Rem tyhorton 07/27/05 - correcting reporting framework error codes
Rem ramalhot 07/26/05 - added const g_repos_id_param_name
Rem rkpandey 07/25/05 - Bug 4502846: Add AGENT_LOCK_BUSY_ERR
Rem rmaggarw 07/26/05 - add constant for sharedfs loader
Rem rpinnama 07/25/05 - Fix 4415154 : Add invalid unreach clear
Rem exception
Rem pmodi 07/22/05 - Bug:4365302 - Add constant for broken reason
Rem neearora 07/20/05 - Bug 4500972. Added constant for PRE_UPLOAD_CALLBACK
Rem and POST_UPLOAD_CALLBACK
Rem pkantawa 07/07/05 - Fix 4348291: add error for delete execution
Rem failure
Rem kmanicka 06/17/05 - oms based encryption key
Rem jsadras 07/20/05 - add oracle error constants
Rem gan 07/18/05 - add constant for callback
Rem rdabbott 07/08/05 - fix 3262285: add start/end time error
Rem neearora 07/03/05 - Bug 4453451. Added constant for oracle error
Rem code
Rem pmodi 06/28/05 - Bug:4408959 - Constant for metric_error and
Rem metric_warning
Rem rpatti 06/27/05 - add disallow templates type property
Rem neearora 06/22/05 - Added exception for AGENT_DELETION_IN_PROG and
Rem for STALE_TARGET_ADDTION_EXCEPTION
Rem aaitghez 07/06/05 - adding target relocation error codes
Rem gsbhatia 07/01/05 - New repmgr header impl
Rem gan 06/22/05 -
Rem skini 06/18/05 - Add new message for curtailing end time
Rem neearora 06/13/05 - Added exception for Invalid EMD_URL
Rem rpinnama 06/23/05 - Add callback type for TZRGN_UPDATE callbacks
Rem jsadras 05/20/05 - add property change callback type
Rem jpyang 05/26/05 - add EM__SYS__
Rem rpinnama 05/24/05 - Define well known author names
Rem lhan 05/09/05 - Add annotation type for CM
Rem dtsao 04/29/05 - add constant for red grp
Rem rmarripa 05/20/05 - add error code
Rem rpinnama 04/22/05 - Add overlapping metric error
Rem gan 04/20/05 - add service exception
Rem rmarripa 04/08/05 - add key beacon remove message
Rem dcawley 04/07/05 - Add message for sql injection
Rem rpinnama 04/11/05 - Add severity_threshold
Rem pkantawa 04/05/05 - Add code for reassign job failure
Rem pmodi 04/06/05 - Add callback type for metric key value remove
Rem vkarpura 03/31/05 - Moving IAS v102010 to IAS module
Rem jsadras 03/27/05 - Bug:4148621, Remove row_exists
Rem ramalhot 03/23/05 - exception member_tgt_does_not_exist added
Rem neearora 03/24/05 - Created new exception type
Rem gan 03/22/05 - add service/system exception
Rem mfidanbo 03/18/05 - remove tgt_sysdate
Rem pkantawa 03/10/05 - add error code for delete job failure
Rem gan 03/17/05 - add exception for empty key
Rem jsadras 03/10/05 - add target_metaver callback constant
Rem pkantawa 03/02/05 - Add exception for invalid job step
Rem shianand 03/01/05 - Added Audit Error Codes
Rem dtsao 02/23/05 - Add ANY_TARGET_TYPE
Rem dcawley 02/17/05 - Change message text
Rem kmanicka 02/10/05 - Bug 4100454 add proper messages for suspend / resume job
Rem andyao 02/16/05 - add exception if the destination metric/column
Rem is not found for the given target type
Rem niramach 02/03/05 - exempt->suppress conversions
Rem jsadras 02/13/05 - g_threshold_min/max
Rem streddy 02/11/05 - Added baseline property
Rem rpinnama 02/03/05 - Add schema owner parameter name
Rem aholser 02/08/05 - increment emrep ver
Rem gan 02/04/05 - check agg svc type
Rem vkarpura 01/25/05 - Adding WC RG Type
Rem vkarpura 01/20/05 - Adding custom IAS RG types
Rem rkpandey 01/17/05 - Added constant for Metric type CLOB/BLOB
Rem pkantawa 01/12/05 - Rollback changes made in previous txn
Rem rpinnama 01/03/05 - Add tgttype_addition callback
Rem bram 12/30/04 - Added G_ASM_TARGET_TYPE,G_SID_PROPERTY_NAME,G_OSM_PROPERTY_NAME
Rem dcawley 12/23/04 - Add error for invalid grant to public role
Rem pkantawa 12/20/04 - Fix 4074662: Change name and description of
Rem constant
Rem dcawley 12/09/04 - Limit annotation types
Rem dcawley 12/02/04 - Fix annotation constants
Rem mfidanbo 12/01/04 - add tgt_sysdate
Rem rpinnama 11/30/04 - Add invalid operation error code
Rem rpinnama 12/02/04 - Cutover to use object types
Rem groyal 11/10/04 - Add Storage functional category
Rem streddy 11/08/04 - Redundancy group constant change
Rem jsadras 11/09/04 - on-demand
Rem streddy 11/04/04 - Add is_aggregate property
Rem ramalhot 10/15/04 - cyclic_membership_assoc_err added
Rem vkhizder 10/04/04 - adding ecm framework error code
Rem asawant 08/31/04 - Adding severity trigger error codes.
Rem streddy 10/07/04 - Add eval-func missing error
Rem rpinnama 10/11/04 - Add constants for object types
Rem gan 10/01/04 - add system constants
Rem streddy 10/03/04 - Service metric category name changes
Rem gan 09/28/04 - add service exception
Rem jriel 09/30/04 - notification constants to reflect current
Rem reality
Rem jabramso 09/28/04 - Add report errors
Rem kmanicka 09/20/04 - added G_DEFAULT_TARGET_OWNER
Rem rpinnama 09/23/04 -
Rem shuberma 09/15/04 - Adding emdrep type meta ver global value.
Rem rpinnama 09/20/04 - Add new usage types
Rem rpinnama 09/22/04 - Add template copy constant
Rem dcawley 09/14/04 - Add errors for reports and templates
Rem rmarripa 09/10/04 - code review comments
Rem rmarripa 08/27/04 - Add Generic Service Error Codes
Rem pshishir 09/07/04 - Add CA
Rem gan 09/01/04 - add constant
Rem rpinnama 08/30/04 - Add metric/policy doesnot exist exceptions
Rem vkarpura 09/16/04 - Adding nw AS Target types
Rem ckumar 09/03/04 - Redundancy group constants added
Rem ramalhot 08/18/04 - target pre delete callback const added
Rem streddy 08/10/04 - Added service categories
Rem rmenon 08/02/04 - added storage reports errors
Rem rpinnama 08/04/04 - Create an ALLZERO guid
Rem rpinnama 08/03/04 - Add no_such_policy, no_sucn_template errors
Rem rzkrishn 07/30/04 - globals for RELOCATION_CALLBACK
Rem rpinnama 07/28/04 - Create min/max constants for metric_types
Rem ashugupt 07/28/04 - Added error definitions job create ui
Rem groyal 07/09/04 - Fix violation exemption codes
Rem ramalhot 07/06/04 - assoc related exception added
Rem rpinnama 06/20/04 - Add schedule constants
Rem rzazueta 04/13/04 - Add target_deletion_error
Rem jsadras 03/17/04 - Added blkout_create_failed and job_create_failed
Rem jsadras 03/16/04 -
Rem rdabbott 11/17/03 - fix 3260449: security - only show jobs on
Rem targets the user can view
Rem skini 11/13/03 - Add new error for editing expired jobs
Rem dsahrawa 11/12/03 - add error code for restart-failed jobs
Rem rzazueta 10/29/03 - Add elapsed_time_msec function
Rem rpinnama 10/15/03 - Add new error for severities received during
Rem rpinnama 09/25/03 - Add more target types
Rem xshen 09/16/03 - Add job_ui exceptions
Rem skini 09/10/03 - Add job_suspended_err
Rem skini 09/08/03 - Add cluster member property
Rem skini 08/15/03 - Credential-related errors
Rem streddy 07/10/03 - Added annotation types
Rem streddy 06/30/03 - Added cluster_member property
Rem mgoodric 06/13/03 - added COPY_SNAPSHOT
Rem streddy 04/29/03 - Added non-master agent error
Rem aholser 04/04/03 - change rep type
Rem streddy 03/03/03 - Added G_METRIC_TYPE_REPOS_EVENT
Rem skini 04/09/03 - Add new target type for rac database
Rem skini 03/20/03 - Add error code for invalid job type
Rem mgoodric 03/15/03 - Add ECM framework error codes
Rem dcawley 02/27/03 - Add message for schedule change
Rem dcawley 02/19/03 - Change message for mail gateway
Rem streddy 02/14/03 - Added monitoring mode constants
Rem aholser 02/18/03 - add oc4j target
Rem hakali 01/21/03 - do not comment insufficient_previliges_err
Rem hakali 01/21/03 - remove duplicate def for insufficient_privileges
Rem skini 02/19/03 - Code review changes
Rem skini 02/17/03 - Add new exception code for move_target
Rem rpinnama 02/14/03 - Define agent date format
Rem skini 11/18/02 - Add invalid schedule error
Rem yaofeng 10/30/02 - Fixed bug 2640150
Rem rpinnama 11/08/02 - Add duplicate target exception
Rem rpinnama 11/05/02 - Add beacon and listener target types
Rem rpatti 10/21/02 - add err code for dup. blkouts
Rem ysun 10/21/02 - Add RAC related types
Rem dcawley 10/07/02 - Add message for callbacks in User Model
Rem tjaiswal 10/07/02 - Add api for comp key guid generation
Rem skini 09/12/02 - New exception codes for job locking
Rem rpinnama 09/18/02 - Add check_overlap function
Rem rpinnama 09/12/02 - Add timezone translation functions
Rem rpatti 08/29/02 - add blackout ui err codes
Rem skini 08/26/02 - BLACKOUT_START_PROCESSING error
Rem skini 08/26/02 - Add BLACKOUT_STOP_PENDING
Rem skini 08/27/02 - Add INVALID_EVENT_NAME error
Rem dcawley 08/14/02 - Change email subject
Rem tjaiswal 08/16/02 - Remove duplicate exceptions
Rem dcawley 08/08/02 - Add Add G_NOTIF_STATUS_NO_TARGET
Rem rpinnama 08/02/02 -
Rem dcawley 08/06/02 - Add constant for oracle_emdrep
Rem skini 08/05/02 - New blackout codes
Rem skini 07/31/02 - More blackout errors
Rem skini 07/26/02 - New exceptions for blackouts
Rem rpinnama 07/31/02 - Add metric type constants
Rem rpinnama 07/22/02 - Add new errors and exceptions
Rem skini 07/02/02 - Make delete_target asynchronous
Rem skini 07/02/02 - Make delete_target asynchronous
Rem rpinnama 07/08/02 - Add constants for notification statuses
Rem rpinnama 06/25/02 - Add severity and ping error messages
Rem snakai 06/23/02 - add new severity for beacon availability
Rem dcawley 06/15/02 - Add message for locking in user model
Rem rpinnama 06/05/02 - Add constants for Response and Status.
Rem rpinnama 06/03/02 - Add availability states and severity states.
Rem dcawley 05/20/02 - Add messages for notification.
Rem tjaiswal 05/17/02 - Add constants for multiple notif devices
Rem rpinnama 05/15/02 - rpinnama_reorg_rep_scripts
Rem rpinnama 05/15/02 - Restructured.
Rem dcawley 04/17/02 - Change message for setting email gateway.
Rem dcawley 03/14/02 - Add messages for PL/SQl handler.
Rem dcawley 02/21/02 - Add email test message.
Rem dcawley 02/13/02 - Add exceptions for Notifications and Collections.
Rem tjaiswal 02/13/02 - Add constants for target baselines
Rem skini 02/03/02 - Add invalid_params_err
Rem skini 01/24/02 - Introduce invalid schedule errors
Rem skini 01/18/02 - Add new error code for job security exception
Rem dcawley 01/16/02 - Add exception for when user exists.
Rem dcawley 01/14/02 - Add group exception.
Rem skini 12/26/01 - Error code for Incorrectly specified parameters
Rem dcawley 12/13/01 - Add message for circular roles;.
Rem dcawley 12/07/01 - Add message for already exists.
Rem dcawley 12/04/01 - Add messages for User Model.
Rem dcawley 11/28/01 - Add messages for User Model.
Rem skini 11/18/01 - More job system error codes
Rem skini 11/05/01 - Add error codes for job restart
Rem skini 10/24/01 - Merged skini_cleanup_global
Rem skini 10/24/01 - reorganize global
Rem skini 10/24/01 - Add pragmas
Rem rpatti 10/24/01 - add err code for dup target
Rem skini 10/22/01 - New job system error codes
Rem tjaiswal 10/22/01 - Add misc constants
Rem skini 10/15/01 - New error codes
Rem tjaiswal 10/15/01 - Add snmp_test_failed EXCEPTION
Rem rpinnama 10/15/01 - Rollback TIMESTAMP WITH TIMEZONE changes
Rem tjaiswal 10/09/01 - Add messages for test smtp host
Rem skini 10/05/01 - Add job system exception codes
Rem rpatti 09/14/01 - add internal timestamp format constant
Rem aholser 09/11/01 - Merge
Rem aholser 09/02/01 - misc
Rem tjaiswal 09/01/01 - Add constants for notif pl/sql
Rem aholser 08/29/01 - add target globals
Rem aholser 08/16/01 - Created
Rem
CREATE OR REPLACE PACKAGE mgmt_global AS
--
-- This format is to be used for internal conversions.
G_INTERNAL_DATE_FORMAT VARCHAR2(32) := 'DD-MON-YYYY HH24:MI:SS';
--
-- By default, this format is used by date strings sent by Agent
G_AGENT_DATE_FORMAT VARCHAR2(32) := 'YYYY-MM-DD HH24:MI:SS';
G_FALSE NUMBER(1) := 0;
G_TRUE NUMBER(1) := 1;
MAX_COMMIT NUMBER := 1000;
-- Well known parameter names
G_SCHEMA_OWNER_PARAM_NAME CONSTANT VARCHAR2(32) := 'EM_SCHEMA_OWNER';
G_REPOS_ID_PARAM_NAME CONSTANT VARCHAR2(32) := 'EM_REPOSITORY_ID';
-- Please keep the error codes, exceptions, error messages, and pragmas
-- for each exception together. It will also be nice if you can
-- briefly document each error code you add.
G_DAY CONSTANT NUMBER(1) := 1;
G_WEEK CONSTANT NUMBER(1) := 7;
G_MONTH CONSTANT NUMBER(2) := 31;
-- All zero GUID
G_ALL_ZERO_GUID CONSTANT RAW(16) := HEXTORAW('00000000000000000000000000000000');
-- Metric types
G_METRIC_TYPE_MIN CONSTANT NUMBER(2) := 0;
G_METRIC_TYPE_NUMBER CONSTANT NUMBER(2) := 0;
G_METRIC_TYPE_STRING CONSTANT NUMBER(2) := 1;
G_METRIC_TYPE_TABLE CONSTANT NUMBER(2) := 2;
G_METRIC_TYPE_RAW CONSTANT NUMBER(2) := 3;
G_METRIC_TYPE_EXTERNAL CONSTANT NUMBER(2) := 4;
G_METRIC_TYPE_REPOS_TABLE CONSTANT NUMBER(2) := 5;
G_METRIC_TYPE_REPOS_NUMBER CONSTANT NUMBER(2) := 6;
G_METRIC_TYPE_REPOS_STRING CONSTANT NUMBER(2) := 7;
G_METRIC_TYPE_REPOS_EVENT CONSTANT NUMBER(2) := 8;
G_METRIC_TYPE_CLOB CONSTANT NUMBER(2) := 9;
G_METRIC_TYPE_BLOB CONSTANT NUMBER(2) := 10;
G_METRIC_TYPE_MAX CONSTANT NUMBER(2) := 10;
-- metric usage types
-- Usage types 2, 3, 4 are obsolete
G_USAGE_MIN CONSTANT NUMBER(1) := 0;
G_USAGE_VIEW_COLLECT CONSTANT NUMBER(1) := 0;
G_USAGE_REALTIME_ONLY CONSTANT NUMBER(1) := 1;
G_USAGE_DISPLAY_ONLY CONSTANT NUMBER(1) := 2;
G_USAGE_MULTI_KEY CONSTANT NUMBER(1) := 3;
G_USAGE_COLLECT_ONLY CONSTANT NUMBER(1) := 4;
G_USAGE_HIDDEN CONSTANT NUMBER(1) := 5;
G_USAGE_HIDDEN_COLLECT CONSTANT NUMBER(1) := 6;
G_USAGE_COLLECT_UPLOAD CONSTANT NUMBER(1) := 7;
G_USAGE_MAX CONSTANT NUMBER(1) := 7;
-- metric key values
G_METRIC_KEY_TRUE CONSTANT NUMBER(1) := 1;
G_METRIC_KEY_FALSE CONSTANT NUMBER(1) := 0;
-- Metric source types for repository metrics
G_METRIC_SOURCE_MIN CONSTANT NUMBER(1) := 1;
G_METRIC_SOURCE_OLD_PLSQL CONSTANT NUMBER(1) := 1;
G_METRIC_SOURCE_PLSQL CONSTANT NUMBER(1) := 2;
G_METRIC_SOURCE_QUERY CONSTANT NUMBER(1) := 3;
G_METRIC_SOURCE_BULK_PLSQL CONSTANT NUMBER(1) := 4;
G_METRIC_SOURCE_SEVEVAL_PLSQL CONSTANT NUMBER(1) := 5;
G_METRIC_SOURCE_MAX CONSTANT NUMBER(1) := 5;
-- Availability states
G_STATUS_DOWN CONSTANT NUMBER(1) := 0;
G_STATUS_UP CONSTANT NUMBER(1) := 1;
G_STATUS_ERROR CONSTANT NUMBER(1) := 2;
G_STATUS_AGENT_DOWN CONSTANT NUMBER(1) := 3;
G_STATUS_UNREACHABLE CONSTANT NUMBER(1) := 4;
G_STATUS_BLACKOUT CONSTANT NUMBER(1) := 5;
G_STATUS_UNKNOWN CONSTANT NUMBER(1) := 6;
-- Severity codes
G_SEVERITY_COMMENT CONSTANT NUMBER(2) := 10;
G_SEVERITY_CLEAR CONSTANT NUMBER(2) := 15;
G_SEVERITY_INFORMATIONAL CONSTANT NUMBER(2) := 18;
G_SEVERITY_WARNING CONSTANT NUMBER(2) := 20;
G_SEVERITY_CRITICAL CONSTANT NUMBER(2) := 25;
G_SEVERITY_UNREACHABLE_CLEAR CONSTANT NUMBER(3) := 115;
G_SEVERITY_UNREACHABLE_START CONSTANT NUMBER(3) := 125;
G_SEVERITY_BLACKOUT_END CONSTANT NUMBER(3) := 215;
G_SEVERITY_BLACKOUT_START CONSTANT NUMBER(3) := 225;
G_SEVERITY_ERROR_END CONSTANT NUMBER(3) := 315;
G_SEVERITY_ERROR_START CONSTANT NUMBER(3) := 325;
G_SEVERITY_NO_BEACONS CONSTANT NUMBER(3) := 425;
G_SEVERITY_UNKNOWN CONSTANT NUMBER(3) := 515;
-- Object types used for policies, metric thresholds, credentials and corrective actions
G_OBJECT_TYPE_DEFAULT CONSTANT NUMBER(1) := 1;
G_OBJECT_TYPE_TARGET CONSTANT NUMBER(1) := 2;
G_OBJECT_TYPE_TEMPLATE CONSTANT NUMBER(1) := 3;
G_OBJECT_TYPE_TEMPLATE_COPY CONSTANT NUMBER(1) := 4;
G_OBJECT_TYPE_MNTR_SET_COPY CONSTANT NUMBER(1) := 5;
-- Severity types
G_SEVERITY_TYPE_THRESHOLD CONSTANT NUMBER(2) := 0;
G_SEVERITY_TYPE_AVAILABILITY CONSTANT NUMBER(2) := 1;
-- Resource severity type is not being used
G_SEVERITY_TYPE_RESOURCE CONSTANT NUMBER(2) := 2;
G_SEVERITY_TYPE_POLICY CONSTANT NUMBER(2) := 3;
G_SEVERITY_TYPE_CS_POLICY CONSTANT NUMBER(2) := 4;
-- Violation suppression codes
G_SUPPRESS_MIN CONSTANT NUMBER(1) := 0;
G_SUPPRESS_NONE CONSTANT NUMBER(1) := 0;
G_SUPPRESS_MANUAL CONSTANT NUMBER(1) := 1;
G_SUPPRESS_DATE CONSTANT NUMBER(1) := 2;
G_SUPPRESS_NEXTEVAL CONSTANT NUMBER(1) := 3;
G_SUPPRESS_MAX CONSTANT NUMBER(1) := 3;
-- Policy types
G_TYPE_THRESHOLD_METRIC CONSTANT NUMBER(2) := 1;
G_TYPE_POLICY CONSTANT NUMBER(2) := 2;
G_TYPE_CS_POLICY CONSTANT NUMBER(2) := 3;
-- Policy condition types
G_CONDITION_MIN CONSTANT NUMBER(1) := 1;
G_CONDITION_THRESHOLD CONSTANT NUMBER(1) := 1;
G_CONDITION_SQL CONSTANT NUMBER(1) := 2;
G_CONDITION_PLSQL CONSTANT NUMBER(1) := 3;
G_CONDITION_MAX CONSTANT NUMBER(1) := 3;
-- Policy association object types
G_CONFIG_DEFAULT CONSTANT NUMBER(1) := G_OBJECT_TYPE_DEFAULT;
G_CONFIG_TARGET CONSTANT NUMBER(1) := G_OBJECT_TYPE_TARGET;
G_CONFIG_TEMPLATE CONSTANT NUMBER(1) := G_OBJECT_TYPE_TEMPLATE;
G_CONFIG_TEMPLATE_COPY CONSTANT NUMBER(1) := G_OBJECT_TYPE_TEMPLATE_COPY;
G_CONFIG_MNTR_SET_COPY CONSTANT NUMBER(1) := G_OBJECT_TYPE_MNTR_SET_COPY;
-- Policy importance levels
G_IMPORTANCE_HIGH CONSTANT NUMBER(1) := 1;
G_IMPORTANCE_NORMAL CONSTANT NUMBER(1) := 2;
G_IMPORTANCE_LOW CONSTANT NUMBER(1) := 3;
-- Availability metric
G_AVAIL_METRIC_NAME CONSTANT VARCHAR2(32) := 'Response';
G_AVAIL_METRIC_COLUMN CONSTANT VARCHAR2(32) := 'Status';
G_AVAIL_TEST_METRIC_NAME CONSTANT VARCHAR2(32) := 'test_response';
--General External Metrics
G_EXTERNAL_METRIC_NAME CONSTANT VARCHAR2(64) := 'GenericExternalAlertMetric' ;
G_EXTERNAL_METRIC_COLUMN CONSTANT VARCHAR2(64) := 'Alert' ;
-- Constant for metric_error and metric_warn
G_METRIC_ERROR_TYPE_ERROR CONSTANT NUMBER(1) := 0;
G_METRIC_ERROR_TYPE_WARN CONSTANT NUMBER(1) := 1;
-- Default target owner
G_DEFAULT_TARGET_OWNER CONSTANT VARCHAR2(256) := '';
-- Well known target types.
G_HOST_TARGET_TYPE CONSTANT VARCHAR2(32) := 'host';
G_AGENT_TARGET_TYPE CONSTANT VARCHAR2(32) := 'oracle_emd';
G_DATABASE_TARGET_TYPE CONSTANT VARCHAR2(32) := 'oracle_database';
G_LISTENER_TARGET_TYPE CONSTANT VARCHAR2(32) := 'oracle_listener';
G_REPOSITORY_TARGET_TYPE CONSTANT VARCHAR2(32) := 'oracle_emrep';
G_BEACON_TARGET_TYPE CONSTANT VARCHAR2(32) := 'oracle_beacon';
G_COMPOSITE_TARGET_TYPE CONSTANT VARCHAR2(32) := 'composite';
G_HOST_GROUP_TARGET_TYPE CONSTANT VARCHAR2(32) := 'host_group';
G_DATABASE_GROUP_TARGET_TYPE CONSTANT VARCHAR2(32) := 'oracle_database_group';
G_CLUSTER_TARGET_TYPE CONSTANT VARCHAR2(32) := 'cluster';
G_RAC_DATABASE_TARGET_TYPE CONSTANT VARCHAR2(32) := 'rac_database';
G_REDUNDANCY_GROUP_TARGET_TYPE CONSTANT VARCHAR2(64) := 'generic_redundancy_group';
G_IAS_TARGET_TYPE CONSTANT VARCHAR2(32) := 'oracle_ias';
G_WEBSITE_TARGET_TYPE CONSTANT VARCHAR2(32) := 'website';
G_FORMSAPP_TARGET_TYPE CONSTANT VARCHAR2(32) := 'formsapp';
G_HTTP_SERVER_TARGET_TYPE CONSTANT VARCHAR2(32) := 'oracle_apache';
G_WEBCACHE_TARGET_TYPE CONSTANT VARCHAR2(32) := 'oracle_webcache';
G_OC4J_TARGET_TYPE CONSTANT VARCHAR2(32) := 'oc4j';
G_BC4J_TARGET_TYPE CONSTANT VARCHAR2(32) := 'oracle_bc4j';
G_LDAP_TARGET_TYPE CONSTANT VARCHAR2(32) := 'oracle_ldap';
G_SSO_SERVER_TARGET_TYPE CONSTANT VARCHAR2(32) := 'oracle_sso_server';
G_PORTAL_TARGET_TYPE CONSTANT VARCHAR2(32) := 'oracle_portal';
G_APPLICATION_TARGET_TYPE CONSTANT VARCHAR2(32) := 'oracle_application';
G_APPS_SYSTEM_TARGET_TYPE CONSTANT VARCHAR2(32) := 'oracle_apps_system';
G_ASM_TARGET_TYPE CONSTANT VARCHAR2(32) := 'osm_instance';
--constant for property name
G_SID_PROPERTY_NAME CONSTANT VARCHAR2(32) := 'SID';
G_OSM_PROPERTY_NAME CONSTANT VARCHAR2(32) := 'OSMInstance';
--Constant for target property type 'INSTANCE'
G_INSTANCE_PROP_TYPE CONSTANT VARCHAR2(32) := 'INSTANCE';
-- Constants for target type properties
G_IS_AGGREGATE_PROP CONSTANT VARCHAR2(32) := 'is_aggregate';
G_IS_GROUP_PROP CONSTANT VARCHAR2(32) := 'is_group';
G_IS_COMPOSITE_PROP CONSTANT VARCHAR2(32) := 'is_composite';
G_IS_REDUNDANCY_GROUP_PROP CONSTANT VARCHAR2(32) := 'is_cluster';
G_IS_CLUSTER_PROP CONSTANT VARCHAR2(32) := 'is_cluster';
G_DISPLAY_NAME_PROP CONSTANT VARCHAR2(32) := 'typeDisplayName';
G_MEMBER_TYPE_PROP CONSTANT VARCHAR2(32) := 'baseMemberType';
G_DERIVED_STATUS_PROP CONSTANT VARCHAR2(32) := 'memberDerivedStatus';
G_DERIVED_ALERT_PROP CONSTANT VARCHAR2(32) := 'memberDerivedAlert';
G_IS_BASELINEABLE_PROP CONSTANT VARCHAR2(32) := 'IsBaselineable';
G_DISALLOW_REDUNDANCY_GROUP CONSTANT VARCHAR2(32) := 'disallow_redundancy_group';
G_DISALLOW_TEMPLATE_PROP CONSTANT VARCHAR2(32) := 'disallow_template';
-- acceptable values 1(yes), 0 (no)
G_REMOTELY_MONITORED_PROP CONSTANT VARCHAR2(32) := 'remotely_monitored';
-- Cluster membership association
G_CLUSTER_MEMBER_ASSOC CONSTANT VARCHAR2(32) := 'cluster_member';
-- Cluster member target type property
G_CLUSTER_MEMBER_TYPE_PROP CONSTANT VARCHAR2(32) := 'member_target_type';
-- Static target names
G_MANAGEMENT_SYSTEM CONSTANT VARCHAR2(256) := 'Management Services and Repository';
-- EM__SYS__ prefix for cross type alert messages
G_EM_SYS_PREFIX CONSTANT VARCHAR(25) := 'EM__SYS__';
-- Max and min type meta versions
G_MIN_TYPE_META_VER CONSTANT VARCHAR2(8) := '1.0';
G_MAX_TYPE_META_VER CONSTANT VARCHAR2(8) := '99.99999';
-- Current Type_Meta_Ver value for the repository target.
G_MGMT_SYS_TYPE_META_VER CONSTANT VARCHAR2(10) := '3.0';
-- Service prop and Generic service type
G_IS_SERVICE_PROP CONSTANT VARCHAR2(256) := 'is_service';
G_IS_AGGREGATE_SERVICE_PROP CONSTANT VARCHAR2(256) := 'is_aggregate_service';
G_GENERIC_SERVICE_TYPE CONSTANT VARCHAR2(256) := 'generic_service';
G_AGGREGATE_SERVICE_TYPE CONSTANT VARCHAR2(256) := 'aggregate_service';
G_USAGE_METRIC CONSTANT VARCHAR2(256) := 'Usage';
G_RESPONSETIME_METRIC CONSTANT VARCHAR2(256) := 'ResponseTime';
--System prop and generic system type
G_IS_SYSTEM_PROP CONSTANT VARCHAR2(256) := 'is_system';
G_GENERIC_SYSTEM_TYPE constant VARCHAR2(256) := 'generic_system';
-- Service Beacon constants
G_PARTICIPATES_IN_AVAIL CONSTANT VARCHAR2(64) := 'participates_in_availability';
G_PARTICIPATES_AS_LOCAL CONSTANT VARCHAR2(64) := 'participates_as_local_beacon';
G_BOTH_LOCAL_AND_AVAIL_BCN CONSTANT VARCHAR2(64) := 'both_avail_and_local_beacon';
-- Schedule frequency constants
G_SCHED_FREQUENCY_ONE_TIME CONSTANT NUMBER(1) := 1;
G_SCHED_FREQUENCY_INTERVAL CONSTANT NUMBER(1) := 2;
G_SCHED_FREQUENCY_DAILY CONSTANT NUMBER(1) := 3;
G_SCHED_FREQUENCY_WEEKLY CONSTANT NUMBER(1) := 4;
G_SCHED_FREQUENCY_MONTHLY CONSTANT NUMBER(1) := 5;
G_SCHED_FREQUENCY_YEARLY CONSTANT NUMBER(1) := 6;
G_SCHED_FREQUENCY_ONDEMAND CONSTANT NUMBER(1) := 7;
-- Notification statuses for the severity
G_NOTIF_STATUS_NEW CONSTANT NUMBER(1) := 1;
G_NOTIF_STATUS_IGNORE CONSTANT NUMBER(1) := 2;
G_NOTIF_STATUS_RCA_CAUSE CONSTANT NUMBER(1) := 3;
G_NOTIF_STATUS_RCA_NO_CAUSE CONSTANT NUMBER(1) := 4;
-- The collection threshold operators
G_THRESHOLD_MIN CONSTANT NUMBER(1) := 0;
G_THRESHOLD_GT CONSTANT NUMBER(1) := 0;
G_THRESHOLD_EQ CONSTANT NUMBER(1) := 1;
G_THRESHOLD_LT CONSTANT NUMBER(1) := 2;
G_THRESHOLD_LE CONSTANT NUMBER(1) := 3;
G_THRESHOLD_GE CONSTANT NUMBER(1) := 4;
G_THRESHOLD_CONTAINS CONSTANT NUMBER(1) := 5;
G_THRESHOLD_NE CONSTANT NUMBER(1) := 6;
G_THRESHOLD_MATCH CONSTANT NUMBER(1) := 7;
G_THRESHOLD_MAX CONSTANT NUMBER(1) := 7;
-- Target monitoring modes
G_MON_MODE_DEFAULT CONSTANT NUMBER(1) := 0;
G_MON_MODE_OMS_MEDIATED CONSTANT NUMBER(1) := 1;
G_MON_MODE_AGENT_MEDIATED CONSTANT NUMBER(1) := 2;
--Oracle error codes.
G_ORA_SHUTDOWN CONSTANT NUMBER(4) := -1089;
G_ORA_RESOURCE_BUSY CONSTANT NUMBER(2) := -54 ;
G_ORA_DEADLOCK CONSTANT NUMBER(4) := -60;
G_ORA_PACKAGE_DISCARDED CONSTANT NUMBER(4) := -4068 ;
G_ORA_PROGRAM_NOT_FOUND CONSTANT NUMBER(4) := -6508 ;
-- The logging levels for mgmt_system_error_log
G_ERROR CONSTANT VARCHAR2(16) := 'ERROR';
G_WARN CONSTANT VARCHAR2(16) := 'WARN';
G_INFO CONSTANT VARCHAR2(16) := 'INFO';
G_DEBUG CONSTANT VARCHAR2(16) := 'DEBUG';
-- List of annotation sources
G_ANNOTATION_SOURCE_SEVERITY CONSTANT NUMBER := 1;
G_ANNOTATION_SOURCE_JOB CONSTANT NUMBER := 3;
G_ANNOTATION_SOURCE_CM CONSTANT NUMBER := 4;
-- List of Callback types
G_ASSOC_ADD_CALLBACK CONSTANT NUMBER(2) := 1;
G_ASSOC_DELETE_CALLBACK CONSTANT NUMBER(2) := 2;
G_TARGET_ADD_CALLBACK CONSTANT NUMBER(2) := 3;
G_TARGET_DELTE_CALLBACK CONSTANT NUMBER(2) := 4;
G_TARGET_RELOCATION_CALLBACK CONSTANT NUMBER(2) := 5;
G_TARGET_POST_ADD_CALLBACK CONSTANT NUMBER(2) := 6;
G_TARGET_POST_DEL_CALLBACK CONSTANT NUMBER(2) := 7;
G_TARGET_PRE_DEL_CALLBACK CONSTANT NUMBER(2) := 8;
G_TGTTYPE_ADD_CALLBACK CONSTANT NUMBER(2) := 9;
G_TARGET_METAVER_UPD_CALLBACK CONSTANT NUMBER(2) := 10;
G_METRIC_KEYVAL_DEL_CALLBACK CONSTANT NUMBER(2) := 11;
G_TARGET_PROP_UPD_CALLBACK CONSTANT NUMBER(2) := 12;
G_TZRGN_UPDATE_CALLBACK CONSTANT NUMBER(2) := 13;
G_METRIC_METADATA_REG_CALLBACK CONSTANT NUMBER(2) := 14;
G_PRE_UPLOAD_CALLBACK CONSTANT NUMBER(2) := 15;
G_POST_UPLOAD_CALLBACK CONSTANT NUMBER(2) := 16;
G_CLUSTER_CRS_EVENT_CALLBACK CONSTANT NUMBER(2) := 18;
-- List of Functional categories
G_CATEGORY_CLASS_FUNCTIONAL CONSTANT VARCHAR2(32) := 'Functional';
G_FUNC_CATEGORY_FAULT CONSTANT VARCHAR2(32) := 'Fault';
G_FUNC_CATEGORY_WORKLOAD_VOL CONSTANT VARCHAR2(32) := 'Workload Volume';
G_FUNC_CATEGORY_WORKLOAD_TYPE CONSTANT VARCHAR2(32) := 'Workload Type';
G_FUNC_CATEGORY_PERFORMANCE CONSTANT VARCHAR2(32) := 'Performance';
G_FUNC_CATEGORY_CAPACITY CONSTANT VARCHAR2(32) := 'Capacity';
G_FUNC_CATEGORY_CONFIGURATION CONSTANT VARCHAR2(32) := 'Configuration';
G_FUNC_CATEGORY_SECURITY CONSTANT VARCHAR2(32) := 'Security';
G_FUNC_CATEGORY_STORAGE CONSTANT VARCHAR2(32) := 'Storage';
G_FUNC_CATEGORY_UNCLASSIFIED CONSTANT VARCHAR2(32) := 'Unclassified';
-- List of Service categories
G_CATEGORY_CLASS_SERVICE CONSTANT VARCHAR2(16) := 'Service';
G_SERVICE_CATEGORY_USAGE CONSTANT VARCHAR2(16) := 'Usage';
G_SERVICE_CATEGORY_PERFORMANCE CONSTANT VARCHAR2(32) := 'Performance';
G_SERVICE_CATEGORY_BUSINESS CONSTANT VARCHAR2(16) := 'Business';
-- G_SERVICE_CATEGORY_RESPONSE is obsolete.
-- Use G_SERVICE_CATEGORY_PERFORMANCE instead.
G_SERVICE_CATEGORY_RESPONSE CONSTANT VARCHAR2(16) := 'Response';
-- Target Broken reason constant. ZERO indicates clear target
G_NOT_BROKEN CONSTANT NUMBER := 0;
G_BROKEN_MISSING_PROPS CONSTANT NUMBER := 1;
G_BROKEN_NO_METADATA CONSTANT NUMBER := 2;
G_BROKEN_DYNAMIC_PROP_ERROR CONSTANT NUMBER := 4;
G_BROKEN_DYNAMIC_PROP_MISSING CONSTANT NUMBER := 8;
G_BROKEN_NO_TARGET_NAME CONSTANT NUMBER := 16;
G_BROKEN_NOT_SAVED CONSTANT NUMBER := 32;
G_BROKEN_TEST_METRIC_ERROR CONSTANT NUMBER := 64;
G_BROKEN_DYNAMIC_PROP_TOOSLOW CONSTANT NUMBER := 128;
G_BROKEN_DISABLED CONSTANT NUMBER := 256;
G_BROKEN_UNMONITORED CONSTANT NUMBER := 512;
G_BROKEN_CATG_DYN_PROP_ERROR CONSTANT NUMBER := 1024;
-- Repository severity eval optimization code
G_REPO_SEV_OPT_NONE CONSTANT NUMBER := 0;
G_REPO_SEV_OPT_AND CONSTANT NUMBER := 1;
G_REPO_SEV_OPT_OR CONSTANT NUMBER := 2;
-- Oracle Errors
immediate_shutdown_in_prog EXCEPTION;
PRAGMA EXCEPTION_INIT(immediate_shutdown_in_prog, -1089);
resource_busy EXCEPTION;
PRAGMA EXCEPTION_INIT(resource_busy, -54);
deadlock EXCEPTION;
PRAGMA EXCEPTION_INIT(deadlock, -60);
plsql_package_discarded EXCEPTION ;
PRAGMA EXCEPTION_INIT(plsql_package_discarded,-4068) ;
plsql_program_not_found EXCEPTION ;
PRAGMA EXCEPTION_INIT(plsql_program_not_found,-6508) ;
-- Customization specific constants
------- Page Names
G_GROUPS_SYSTEM_EDIT_MEMBERS CONSTANT VARCHAR2(64) := 'GROUPS_SYSTEM_HOME_PAGE.EDIT_MEMBERS';
G_GENSVC_EDIT_SYSTEM CONSTANT VARCHAR2(64) :='GENERAL_PAGE';
------- Customization Names
G_ALLOW_MEMBER_EDIT CONSTANT VARCHAR2(32) := 'ALLOW_MEMBER_EDIT';
------- Condition Names
G_TYPE CONSTANT VARCHAR2(32) := 'type';
G_TARGET CONSTANT VARCHAR2(32) := 'target';
-- List of well known policy authors
G_AUTHOR_ORACLE CONSTANT VARCHAR2(16) := 'ORACLE';
G_AUTHOR_EXTERNAL CONSTANT VARCHAR2(20) := '$EXTERNAL$' ;
-- Error codes from relocation sql package
SRC_DEST_SAME_AGENT_ERR CONSTANT INTEGER := -20001;
INSUFFICIENT_PRIV_RELOC_ERR CONSTANT INTEGER := -20002;
VERSION_MISMATCH_RELOC_ERR CONSTANT INTEGER := -20003;
MULTI_AGENT_TARGET_RELOC_ERR CONSTANT INTEGER := -20004;
RELOC_CALLBACK_EXEC_ERR CONSTANT INTEGER := -20005;
RELOC_CALLBACK_EXISTS_ERR CONSTANT INTEGER := -20006;
SRC_AGENT_NOT_MONITORING_ERR CONSTANT INTEGER := -20007;
INVALID_USER_PWD_ERR CONSTANT INTEGER := -20197;
invalid_user_pwd EXCEPTION;
INVALID_USER_PWD_ERR_M CONSTANT VARCHAR2(32) := 'Invalid user name or password';
PRAGMA EXCEPTION_INIT(invalid_user_pwd, -20197);
INVALID_GRANT_TO_PUBLIC_ERR CONSTANT INTEGER := -20198;
INVALID_GRANT_TO_PUBLIC_ERR_M CONSTANT VARCHAR2(64) := 'Only Super Users can grant/revoke to/from the PUBLIC role';
invalid_grant_to_public EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_grant_to_public, -20198);
REPORT_DOES_NOT_EXIST_ERR CONSTANT INTEGER := -20199;
report_does_not_exist EXCEPTION;
PRAGMA EXCEPTION_INIT(report_does_not_exist, -20199);
INVALID_USER_NAME_ERR CONSTANT INTEGER := -20200;
invalid_user_name EXCEPTION;
INVALID_USER_NAME_ERR_M CONSTANT VARCHAR2(150) := 'Invalid user name - must be less than 31 characters, begin with alpha and contain only alphanumeric or underscore';
PRAGMA EXCEPTION_INIT(invalid_user_name, -20200);
INVALID_PASSWORD_ERR CONSTANT INTEGER := -20201;
invalid_password EXCEPTION;
INVALID_PASSWORD_ERR_M CONSTANT VARCHAR2(150) := 'Invalid password - must be less than 31 characters, begin with alpha and contain only alphanumeric or underscore';
PRAGMA EXCEPTION_INIT(invalid_password, -20201);
DUPLICATE_USER_ERR CONSTANT INTEGER := -20202;
duplicate_user EXCEPTION;
DUPLICATE_USER_ERR_M CONSTANT VARCHAR2(30) := 'Duplicate user name: ';
PRAGMA EXCEPTION_INIT(duplicate_user, -20202);
INVALID_ROLE_NAME_ERR CONSTANT INTEGER := -20203;
invalid_role_name EXCEPTION;
INVALID_ROLE_NAME_ERR_M CONSTANT VARCHAR2(150) := 'Invalid role name - must be less than 26 characters, begin with alpha and contain only alphanumeric or underscore';
PRAGMA EXCEPTION_INIT(invalid_role_name, -20203);
USER_DOES_NOT_EXIST_ERR CONSTANT INTEGER := -20204;
user_does_not_exist EXCEPTION;
USER_DOES_NOT_EXIST_ERR_M CONSTANT VARCHAR2(30) := 'User does not exist: ';
PRAGMA EXCEPTION_INIT(user_does_not_exist, -20204);
ROLE_DOES_NOT_EXIST_ERR CONSTANT INTEGER := -20205;
role_does_not_exist EXCEPTION;
ROLE_DOES_NOT_EXIST_ERR_M CONSTANT VARCHAR2(30) := 'Role does not exist: ';
PRAGMA EXCEPTION_INIT(role_does_not_exist, -20205);
TARGET_DOES_NOT_EXIST_ERR CONSTANT INTEGER := -20206;
target_does_not_exist EXCEPTION;
TARGET_DOES_NOT_EXIST_ERR_M CONSTANT VARCHAR2(30) := 'Target does not exist: ';
PRAGMA EXCEPTION_INIT(target_does_not_exist, -20206);
INVALID_DESCRIPTION_ERR CONSTANT INTEGER := -20207;
invalid_description EXCEPTION;
INVALID_DESCRIPTION_ERR_M CONSTANT VARCHAR2(100):= 'Invalid description - can be no longer than 64 characters';
PRAGMA EXCEPTION_INIT(invalid_description, -20207);
DELETE_ALL_TARGETS_ERR CONSTANT INTEGER := -20208;
delete_all_targets EXCEPTION;
DELETE_ALL_TARGETS_ERR_M CONSTANT VARCHAR2(50) := 'Cannot delete the all targets role';
PRAGMA EXCEPTION_INIT(delete_all_targets, -20208);
EDIT_ALL_TARGETS_ERR CONSTANT INTEGER := -20209;
edit_all_targets EXCEPTION;
EDIT_ALL_TARGETS_ERR_M CONSTANT VARCHAR2(50) := 'Cannot edit the all targets role';
PRAGMA EXCEPTION_INIT(edit_all_targets, -20209);
DELETE_SUPERUSER_ERR CONSTANT INTEGER := -20210;
delete_superuser EXCEPTION;
DELETE_SUPERUSER_ERR_M CONSTANT VARCHAR2(50) := 'Cannot drop the repository owner';
PRAGMA EXCEPTION_INIT(delete_superuser, -20210);
DUPLICATE_ROLE_NAME_ERR CONSTANT INTEGER := -20211;
duplicate_role EXCEPTION;
DUPLICATE_ROLE_NAME_ERR_M CONSTANT VARCHAR2(30) := 'Duplicate role name';
PRAGMA EXCEPTION_INIT(duplicate_role, -20211);
EMAIL_TEST_FAILED_ERR CONSTANT INTEGER := -20212;
email_test_failed EXCEPTION;
EMAIL_TEST_FAILED_ERR_M CONSTANT VARCHAR2(30) := 'Email test failed: ';
PRAGMA EXCEPTION_INIT(email_test_failed, -20212);
PROGRAM_TEST_FAILED_ERR CONSTANT INTEGER := -20213;
program_test_failed EXCEPTION;
PROGRAM_TEST_FAILED_ERR_M CONSTANT VARCHAR2(30) := 'Program test failed: ';
PRAGMA EXCEPTION_INIT(program_test_failed, -20213);
CALLBACK_FAILED_ERR CONSTANT INTEGER := -20214;
CALLBACK_FAILED_ERR_M CONSTANT VARCHAR2(16) := 'Failed to call: ';
SNMP_TEST_FAILED_ERR CONSTANT INTEGER := -20215;
snmp_test_failed EXCEPTION;
SNMP_TEST_FAILED_ERR_M CONSTANT VARCHAR2(30) := 'SNMP Host test failed: ';
PRAGMA EXCEPTION_INIT(snmp_test_failed, -20215);
MODIFY_FAILED_ERR CONSTANT INTEGER := -20217;
modify_failed EXCEPTION;
PRAGMA EXCEPTION_INIT(modify_failed, -20217);
MODIFY_FAILED_ERR_M CONSTANT VARCHAR2(20) := 'Failed to modify: ';
DROP_FAILED_ERR CONSTANT INTEGER := -20218;
drop_failed EXCEPTION;
PRAGMA EXCEPTION_INIT(drop_failed, -20218);
DROP_FAILED_ERR_M CONSTANT VARCHAR2(20) := 'Failed to drop: ';
GRANT_FAILED_ERR CONSTANT INTEGER := -20219;
grant_failed EXCEPTION;
PRAGMA EXCEPTION_INIT(grant_failed, -20219);
GRANT_FAILED_ERR_M CONSTANT VARCHAR2(20) := 'Failed to grant: ';
REVOKE_FAILED_ERR CONSTANT INTEGER := -20220;
revoke_failed EXCEPTION;
PRAGMA EXCEPTION_INIT(revoke_failed, -20220);
REVOKE_FAILED_ERR_M CONSTANT VARCHAR2(20) := 'Failed to revoke: ';
INSUFFICIENT_PRIVILEGES_ERR CONSTANT INTEGER := -20221;
insufficient_privileges EXCEPTION;
PRAGMA EXCEPTION_INIT(insufficient_privileges, -20221);
INSUFFICIENT_PRIVILEGES_ERR_M CONSTANT VARCHAR2(30) := 'Insufficient privileges: ';
INVALID_PRIVILEGE_TYPE_ERR CONSTANT INTEGER := -20222;
invalid_privilege_type EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_privilege_type, -20222);
INVALID_PRIVILEGE_TYPE_ERR_M CONSTANT VARCHAR2(30) := 'Invalid privilege type: ';
INVALID_PRIVILEGE_ERR CONSTANT INTEGER := -20223;
invalid_privilege EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_privilege, -20223);
INVALID_PRIVILEGE_ERR_M CONSTANT VARCHAR2(20) := 'Invalid privilege: ';
INVALID_TARGET_ERR CONSTANT INTEGER := -20224;
invalid_target EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_target, -20224);
INVALID_TARGET_ERR_M CONSTANT VARCHAR2(20) := 'Invalid target: ';
PRIV_DOES_NOT_EXIST_ERR CONSTANT INTEGER := -20225;
priv_does_not_exist EXCEPTION;
PRAGMA EXCEPTION_INIT(priv_does_not_exist, -20225);
PRIV_DOES_NOT_EXIST_ERR_M CONSTANT VARCHAR2(30) := 'Privilege does not exist: ';
CANT_DROP_YOURSELF_ERR CONSTANT INTEGER := -20226;
cant_drop_yourself EXCEPTION;
PRAGMA EXCEPTION_INIT(cant_drop_yourself, -20226);
CANT_DROP_YOURSELF_ERR_M CONSTANT VARCHAR2(30) := 'Not allowed to drop yourself';
ALREADY_EXISTS_ERR CONSTANT INTEGER := -20227;
already_exists EXCEPTION;
PRAGMA EXCEPTION_INIT(already_exists, -20227);
ALREADY_EXISTS_ERR_M CONSTANT VARCHAR2(30) := ' already exists';
CIRCULAR_ROLE_ERR CONSTANT INTEGER := -20228;
circular_role EXCEPTION;
PRAGMA EXCEPTION_INIT(circular_role, -20228);
CIRCULAR_ROLE_ERR_M CONSTANT VARCHAR2(30) := 'Circular role grant detected';
INVALID_GROUP_ERR CONSTANT INTEGER := -20229;
invalid_group EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_group, -20229);
INVALID_GROUP_ERR_M CONSTANT VARCHAR2(15) := 'Invalid group: ';
CREATE_FAILED_ERR CONSTANT INTEGER := -20230;
create_failed EXCEPTION;
PRAGMA EXCEPTION_INIT(create_failed, -20230);
CREATE_FAILED_ERR_M CONSTANT VARCHAR2(20) := 'Failed to create: ';
USER_EXISTS_ERR CONSTANT INTEGER := -20231;
user_exists EXCEPTION;
PRAGMA EXCEPTION_INIT(user_exists, -20231);
USER_EXISTS_ERR_M CONSTANT VARCHAR2(30) := 'A user with same name exists: ';
ROLE_EXISTS_ERR CONSTANT INTEGER := -20232;
role_exists EXCEPTION;
PRAGMA EXCEPTION_INIT(role_exists, -20232);
ROLE_EXISTS_ERR_M CONSTANT VARCHAR2(30) := 'A role with same name exists: ';
-- Invalid parmameters to an sdk call
INVALID_PARAMS_ERR CONSTANT INTEGER := -20233;
invalid_params EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_params, -20233);
-- duplicate baseline name
DUPLICATE_BASELINE_NAME_ERR CONSTANT INTEGER := -20234;
duplicate_baseline_name EXCEPTION;
PRAGMA EXCEPTION_INIT(duplicate_baseline_name, -20234);
DUPLICATE_BASELINE_NAME_ERR_M CONSTANT VARCHAR2(30) := 'Duplicate baseline name';
-- baseline does not exist
BASELINE_DOES_NOT_EXIST_ERR CONSTANT INTEGER := -20235;
baseline_does_not_exist EXCEPTION;
PRAGMA EXCEPTION_INIT(baseline_does_not_exist, -20235);
BASELINE_DOES_NOT_EXIST_ERR_M CONSTANT VARCHAR2(30) := 'Baseline does not exist';
-- duplicate device name
DUPLICATE_DEVICE_NAME_ERR CONSTANT INTEGER := -20236;
duplicate_device_name EXCEPTION;
PRAGMA EXCEPTION_INIT(duplicate_device_name, -20236);
DUPLICATE_DEVICE_NAME_ERR_M CONSTANT VARCHAR2(30) := 'Duplicate device name';
-- device does not exist
DEVICE_DOES_NOT_EXIST_ERR CONSTANT INTEGER := -20237;
device_does_not_exist EXCEPTION;
PRAGMA EXCEPTION_INIT(device_does_not_exist, -20237);
DEVICE_DOES_NOT_EXIST_ERR_M CONSTANT VARCHAR2(30) := 'Device does not exist';
-- A target is already being deleted
TARGET_BEING_DELETED_ERR CONSTANT INTEGER := -20238;
target_being_deleted EXCEPTION;
PRAGMA EXCEPTION_INIT(target_being_deleted, -20238);
-- The move_target() API was called to move a target, but the
-- emd url is already being changed
TARGET_BEING_MOVED_ERR CONSTANT NUMBER := -20239;
target_being_moved EXCEPTION;
PRAGMA EXCEPTION_INIT(target_being_moved, -20239);
-- Constants for Collections
BAD_THRESHOLD_ERR CONSTANT INTEGER := -20240;
BAD_THRESHOLD_ERR_M CONSTANT VARCHAR2(30) := 'Bad threshold defined for: ';
COLLECTION_ERR CONSTANT INTEGER := -20241;
COLLECTION_ERR_M CONSTANT VARCHAR2(40) := 'Error occurred with collection for: ';
-- End Constants for Collections
-- Default target type
ANY_TARGET_TYPE CONSTANT VARCHAR2(1) := '*';
-- A target cannot be deleted
TARGET_CANNOT_BE_DELETED_ERR CONSTANT INTEGER := -20242;
target_cannot_be_deleted EXCEPTION;
PRAGMA EXCEPTION_INIT(target_cannot_be_deleted, -20242);
-- Exception if All Member Target Types are not of same type
NOT_SAME_TARGET_TYPE_ERR CONSTANT INTEGER := -20243;
NOT_SAME_TARGET_TYPE EXCEPTION;
NOT_SAME_TARGET_TYPE_ERR_M CONSTANT VARCHAR2(100) := 'Target Type NOT of same type: ';
PRAGMA EXCEPTION_INIT(NOT_SAME_TARGET_TYPE, -20243);
-- Exception if Target Type is of Non-Allowed Target type
NON_ALLOWED_TARGET_TYPE_ERR CONSTANT INTEGER := -20244;
NON_ALLOWED_TARGET_TYPE EXCEPTION;
NON_ALLOWED_TARGET_TYPE_ERR_M CONSTANT VARCHAR2(100) := 'Generic redundancy group not supported for target type:';
PRAGMA EXCEPTION_INIT(NON_ALLOWED_TARGET_TYPE, -20244);
MEMBER_DOES_NOT_EXIST_ERR CONSTANT INTEGER := -20245;
member_does_not_exist EXCEPTION;
MEMBER_DOES_NOT_EXIST_ERR_M CONSTANT VARCHAR2(40) := 'Member target does not exist: ';
PRAGMA EXCEPTION_INIT(member_does_not_exist, -20245);
-- target type for meta version does not exist
TARGET_TYPE_VER_NOT_EXIST_ERR CONSTANT INTEGER := -20246;
type_ver_not_exist EXCEPTION;
TGT_TYPE_VER_NOT_EXIST_ERR_M CONSTANT VARCHAR2(45) := 'Target type for meta version does not exist: ';
PRAGMA EXCEPTION_INIT(type_ver_not_exist, -20246);
-- EMD_URL sent be Agent is Invalid
INVALID_EMD_URL_ERR CONSTANT INTEGER := -20247;
invalid_emd_url EXCEPTION;
INVALID_EMD_URL_ERR_M CONSTANT VARCHAR2(20) := 'EMD_URL is invalid: ';
PRAGMA EXCEPTION_INIT(invalid_emd_url, -20247);
-- EM Key is missing
MISSING_EM_KEY_ERR CONSTANT INTEGER := -20248;
missing_em_key EXCEPTION;
MISSING_EM_KEY_ERR_M CONSTANT VARCHAR2(45) := 'EM Key is missing: ';
PRAGMA EXCEPTION_INIT(missing_em_key, -20248);
-- EM Key is invalid
INVALID_EM_KEY_ERR CONSTANT INTEGER := -20249;
invalid_em_key EXCEPTION;
INVALID_EM_KEY_ERR_M CONSTANT VARCHAR2(45) := 'EM Key is invalid: ';
PRAGMA EXCEPTION_INIT(invalid_em_key, -20249);
-- Could not obtain load designator lock
LOAD_DESIGNATOR_LOCK_ERR CONSTANT INTEGER := -20250;
load_designator_lock EXCEPTION;
LOAD_DESIGNATOR_LOCK_ERR_M CONSTANT VARCHAR2(45) := 'Error locking load designator: ';
PRAGMA EXCEPTION_INIT(load_designator_lock, -20250);
-- Could not release load designator lock
LOAD_DESIGNATOR_RELEASE_ERR CONSTANT INTEGER := -20251;
load_designator_release EXCEPTION;
LOAD_DESIGNATOR_RELEASE_ERR_M CONSTANT VARCHAR2(45) := 'Error releasing lock on load designator: ';
PRAGMA EXCEPTION_INIT(load_designator_release, -20251);
-- Constants for notification rules
-- rule does not exist
RULE_DOES_NOT_EXIST_ERR CONSTANT INTEGER := -20300;
rule_does_not_exist EXCEPTION;
PRAGMA EXCEPTION_INIT(rule_does_not_exist, -20300);
RULE_DOES_NOT_EXIST_ERR_M CONSTANT VARCHAR2(30) := 'Rule does not exist';
-- duplicate rule name
DUPLICATE_RULE_NAME_ERR CONSTANT INTEGER := -20301;
duplicate_rule_name EXCEPTION;
PRAGMA EXCEPTION_INIT(duplicate_rule_name, -20301);
DUPLICATE_RULE_NAME_ERR_M CONSTANT VARCHAR2(30) := 'Duplicate rule name';
-- invalid rule data
INVALID_RULE_DATA_ERR CONSTANT INTEGER := -20302;
invalid_rule_data EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_rule_data, -20302);
INVALID_RULE_DATA_ERR_M CONSTANT VARCHAR2(30) := 'Invalid rule data';
-- invalid privileges
-- INSUFFICIENT_PRIVELEGES_ERR CONSTANT INTEGER := -20303;
-- insufficient_privileges EXCEPTION;
-- PRAGMA EXCEPTION_INIT(insufficient_privileges, -20303);
-- INSUFFICIENT_PRIVELEGES_ERR_M CONSTANT VARCHAR2(30) := 'Insufficient privileges';
UNEXPECTED_ERR CONSTANT INTEGER := -20304;
UNEXPECTED_ERR_M CONSTANT VARCHAR2(26) := 'Unexpected error during: ';
NO_EMAIL_GATEWAY_ERR CONSTANT INTEGER := -20305;
NO_EMAIL_GATEWAY_ERR_M CONSTANT VARCHAR2(100) := 'An Outgoing Mail Server must be defined under Notification Methods on the Setup Page.';
EMAIL_SENT CONSTANT INTEGER := -20306;
EMAIL_SENT_MSG CONSTANT VARCHAR2(29) := ' has been notified by E-mail';
PROGRAM_CALLED CONSTANT INTEGER := -20307;
PROGRAM_CALLED_MSG CONSTANT VARCHAR2(17) := ' has been called';
PROGRAM_ERR CONSTANT INTEGER := -20308;
PROGRAM_ERR_M CONSTANT VARCHAR2(15) := 'Error calling: ';
SNMP_TRAP_SENT CONSTANT INTEGER := -20309;
SNMP_TRAP_SENT_MSG CONSTANT VARCHAR2(20) := 'SNMP Trap sent to: ';
SNMP_TRAP_ERR CONSTANT INTEGER := -20310;
SNMP_TRAP_ERR_M CONSTANT VARCHAR2(29) := 'Error sending SNMP Trap to: ';
VIEW_PERMISSION_ERR CONSTANT INTEGER := -20311;
VIEW_PERMISSION_ERR_M CONSTANT VARCHAR2(43) := ' does not have permission to view target: ';
NOT_AVAILABLE CONSTANT INTEGER := -20312;
NOT_AVAILABLE_MSG CONSTANT VARCHAR2(38) := 'Currently scheduled to be unavailable';
NOTIFICATION_DISCARDED_ERR CONSTANT INTEGER := -20313;
NOTIFICATION_DISCARDED_ERR_M CONSTANT VARCHAR2(38) := 'Notification has been discarded for: ';
NOTIFICATION_EMAIL_SUBJECT CONSTANT INTEGER := -20314;
NOTIFICATION_EMAIL_SUBJECT_MSG CONSTANT VARCHAR2(10) := 'EM Alert: ';
NOTIFICATION_TEST_SUBJECT CONSTANT INTEGER := -20315;
NOTIFICATION_TEST_SUBJECT_MSG CONSTANT VARCHAR2(40) := 'EM Test Message';
NOTIFICATION_EMAIL_TEST CONSTANT INTEGER := -20316;
NOTIFICATION_EMAIL_TEST_MSG CONSTANT VARCHAR2(186) := 'This is a test email message from Oracle Enterprise Manager. Receiving this message indicates a successful configuration of your email address and the mail server in Enterprise Manager.';
NOTIFICATION_PROGRAM_TEST CONSTANT INTEGER := -20317;
NOTIFICATION_PROGRAM_TEST_MSG CONSTANT VARCHAR2(154) := 'This is a test message from Oracle Enterprise Manager. Receiving this message indicates a successful configuration of your program in Enterprise Manager.';
NOTIFICATION_SNMP_TEST CONSTANT INTEGER := -20318;
NOTIFICATION_SNMP_TEST_MSG CONSTANT VARCHAR2(160) := 'This is a test message from Oracle Enterprise Manager. Receiving this message indicates a successful configuration of your SNMP Console in Enterprise Manager.';
NOTIFICATION_PLSQL_TEST CONSTANT INTEGER := -20319;
NOTIFICATION_PLSQL_TEST_MSG CONSTANT VARCHAR2(164) := 'This is a test message from Oracle Enterprise Manager. Receiving this message indicates a successful configuration of your PL/SQL procedure in Enterprise Manager.';
NOTIFICATION_UNKNOWN_HOST CONSTANT INTEGER := -20320;
NOTIFICATION_UNKNOWN_HOST_MSG CONSTANT VARCHAR2(14) := 'Unknown host: ';
NOTIFICATION_NO_SMTP_SRV CONSTANT INTEGER := -20321;
NOTIFICATION_NO_SMTP_SRV_MSG CONSTANT VARCHAR2(30) := 'No SMTP Server found on: ';
NOTIFICATION_CONN_TIMEOUT CONSTANT INTEGER := -20322;
NOTIFICATION_CONN_TIMEOUT_MSG CONSTANT VARCHAR2(30) := 'Connection attempt timed out.';
NOTIFICATION_CONN_ERR CONSTANT INTEGER := -20323;
NOTIFICATION_CONN_ERR_MSG CONSTANT VARCHAR2(30) := 'Error occurred connecting to: ';
NOTIFICATION_NOGATEWAY_ERR CONSTANT INTEGER := -20324;
NOTIFICATION_NOGATEWAY_ERR_MSG CONSTANT VARCHAR2(32) := 'No gateway has been specified.';
NOTIFICATION_EMAIL_ERR CONSTANT INTEGER := -20325;
NOTIFICATION_EMAIL_ERR_MSG CONSTANT VARCHAR2(23) := 'Error sending email to ';
NOTIFICATION_SCHEDULE_UPDATE CONSTANT INTEGER := -20326;
NOTIFICATION_SCHEDULE_UPDATE_M CONSTANT VARCHAR2(34) := 'Notification schedule updated by ';
-- end constants for notification rules, user preferences
-- misc constants for targets, metrics
NO_SUCH_METRIC_ERR CONSTANT NUMBER := -20216;
no_such_metric_found EXCEPTION;
PRAGMA EXCEPTION_INIT(no_such_metric_found, -20216);
NO_SUCH_METRIC_ERR_M CONSTANT VARCHAR2(30) := 'Metric not found';
-- end constants for targets, metrics
------- Job System error codes
-- A job was submitted with an invalid (non-existent) job type
INVALID_JOB_TYPE_ERR CONSTANT INTEGER := -20400;
invalid_job_type EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_job_type, -20400);
-- Could not submit a job: another job with same name exists
JOB_EXISTS_ERR CONSTANT INTEGER := -20401;
job_exists EXCEPTION;
PRAGMA EXCEPTION_INIT(job_exists, -20401);
-- Could not submit a job: one or more required parameter(s) missing
JOB_PARAM_MISSING_ERR CONSTANT INTEGER := -20402;
job_param_missing EXCEPTION;
PRAGMA EXCEPTION_INIT(job_param_missing, -20402);
-- The specified job does not exist
INVALID_JOB_ERR CONSTANT INTEGER := -20403;
invalid_job EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_job, -20403);
-- The parameter source could not fetch a parameter: missing or invalid
-- source parameters
INVALID_PARAMS_IN_SRC_ERR CONSTANT INTEGER := -20404;
invalid_params_in_param_src EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_params_in_param_src, -20404);
-- The sql parameter source encountered an error while executing a sql
-- statement
SQL_EXECUTION_ERR CONSTANT INTEGER := -20405;
sql_execution_error EXCEPTION;
PRAGMA EXCEPTION_INIT(sql_execution_error, -20405);
-- One or more input targets were invalid while submitting a job
INVALID_TARGETS_ERR CONSTANT INTEGER := -20406;
invalid_targets_in_job EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_targets_in_job, -20406);
-- The checkValues parameter source encountered one or more incorrect
-- values for parameters
INCORRECT_VALUES_ERR CONSTANT INTEGER := -20407;
incorrect_values EXCEPTION;
PRAGMA EXCEPTION_INIT(incorrect_values, -20407);
-- An attempt was made to suspend a job that was already completed
SUSPEND_FINISHED_JOB_ERR CONSTANT INTEGER := -20408;
suspend_finished_job EXCEPTION;
PRAGMA EXCEPTION_INIT(suspend_finished_job, -20408);
-- An attempt was made to restart an invalid job, or a job that
-- had no failed/aborted executions
RESTART_INVALID_JOB_ERR CONSTANT INTEGER := -20409;
restart_invalid_job EXCEPTION;
PRAGMA EXCEPTION_INIT(restart_invalid_job, -20409);
-- The schedule for a job was invalid
INVALID_SCHEDULE_ERR CONSTANT INTEGER := -20410;
invalid_schedule EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_schedule, -20410);
-- One or more job parameter(s) was incorrectly specified
INVALID_PARAM_ERR CONSTANT INTEGER := -20411;
invalid_parameter EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_parameter, -20411);
-- User does not have enough privileges to submit the job
INSUFFICIENT_JOB_PRIVS_ERR CONSTANT INTEGER := -20412;
insufficient_job_privs EXCEPTION;
PRAGMA EXCEPTION_INIT(insufficient_job_privs, -20412);
-- Invalid parameters in security information
INVALID_PARAMS_IN_SEC_ERR CONSTANT INTEGER := -20413;
invalid_params_in_sec EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_params_in_sec, -20413);
-- Cannot remove an active execution
ACTIVE_EXECUTIONS_EXIST_ERR CONSTANT INTEGER := -20414;
active_executions_exist EXCEPTION;
PRAGMA EXCEPTION_INIT(active_executions_exist, -20414);
-- Execution does not exist
INVALID_EXECUTION_ERR CONSTANT INTEGER := -20415;
invalid_execution EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_execution, -20415);
-- A purge policy already exists
PURGE_POLICY_EXISTS_ERR CONSTANT INTEGER := -20416;
purge_policy_exists EXCEPTION;
PRAGMA EXCEPTION_INIT(purge_policy_exists, -20416);
-- Invalid purge criterion
INVALID_PURGE_CRITERION_ERR CONSTANT INTEGER := -20417;
invalid_purge_criterion EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_purge_criterion, -20417);
-- Invalid event: either the event name or the parameters
-- were incorrect
INVALID_EVENT_ERR CONSTANT INTEGER := -20418;
invalid_event EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_event, -20418);
-- Could not acquire an execution lock
EXEC_LOCK_ERR CONSTANT INTEGER := -20419;
exec_lock EXCEPTION;
PRAGMA EXCEPTION_INIT(exec_lock, -20419);
-- Invalid parameters in lock information
INVALID_PARAMS_IN_LOCK_ERR CONSTANT INTEGER := -20420;
invalid_params_in_lock EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_params_in_lock, -20420);
-- Invalid job type
INVALID_JOBTYPE_ERR CONSTANT INTEGER := -20421;
invalid_job_type EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_job_type, -20421);
-- The job is suspended; cannot suspend/resume an individual execution
JOB_SUSPENDED_ERR CONSTANT INTEGER := -20422;
job_suspended EXCEPTION;
PRAGMA EXCEPTION_INIT(job_suspended, -20422);
-- An attempt was made to restart a job which was
-- already restarted and failed on the restart.
RESTART_RESTART_FAILED_JOB_ERR CONSTANT INTEGER := -20423;
restart_restart_failed_job EXCEPTION;
PRAGMA EXCEPTION_INIT(restart_restart_failed_job, -20423);
-- An attempt was made to edit a job whose schedule has expired
EDIT_EXPIRED_JOB_ERR CONSTANT INTEGER := -20424;
edit_expired_job EXCEPTION;
PRAGMA EXCEPTION_INIT(edit_expired_job, -20424);
--Cannot create jobs if user has been deleted
JOB_CREATE_FAILED_ERR CONSTANT INTEGER := -20425 ;
job_create_failed EXCEPTION ;
PRAGMA EXCEPTION_INIT(job_create_failed, -20425);
-- Cannot suspend job: job currently stopped
JOB_SUSPEND_STOPPED_ERR CONSTANT INTEGER := -20426;
job_suspend_stopped EXCEPTION;
PRAGMA EXCEPTION_INIT(job_suspend_stopped, -20426);
-- job type marked as non-suspendable
JOBTYPE_NON_SUSPEND_ERR CONSTANT INTEGER := -20427;
jobtype_non_suspend EXCEPTION;
PRAGMA EXCEPTION_INIT(jobtype_non_suspend, -20427);
-- Cannot suspend execution: job currently suspended
EXEC_JOB_SUSPENDED_ERR CONSTANT INTEGER := -20428;
exec_job_suspended EXCEPTION;
PRAGMA EXCEPTION_INIT(exec_job_suspended, -20428);
-- Cannot suspend finished executions
EXEC_SUSPEND_FINISHED_ERR CONSTANT INTEGER := -20429;
exec_suspend_finished EXCEPTION;
PRAGMA EXCEPTION_INIT(exec_suspend_finished, -20429);
-- Cannot suspend execution: execution currently suspended
EXEC_SUSPENDED_ERR CONSTANT INTEGER := -20430;
exec_suspended EXCEPTION;
PRAGMA EXCEPTION_INIT(exec_suspended, -20430);
-- Attempt to resume a job that was not suspended
JOB_RESUME_NOT_SUSPENDED_ERR CONSTANT INTEGER := -20431;
job_resume_not_suspended EXCEPTION;
PRAGMA EXCEPTION_INIT(job_resume_not_suspended, -20431);
-- Attempt to resume an execution when the job was suspended
EXEC_RESUME_JOB_SUSPENDED_ERR CONSTANT INTEGER := -20432;
exec_resume_job_suspended EXCEPTION;
PRAGMA EXCEPTION_INIT(exec_resume_job_suspended, -20432);
-- Attempt tp resume an execution that was not suspended
EXEC_RESUME_NOT_SUSP_ERR CONSTANT INTEGER := -20433;
exec_resume_not_susp EXCEPTION;
PRAGMA EXCEPTION_INIT(exec_resume_not_susp, -20433);
-- Step does not exist
INVALID_STEP_ERR CONSTANT INTEGER := -20434;
invalid_step EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_step, -20434);
--error during deleting job from DeleteJob jobtype
DELETE_JOB_COMPLETE_ERR CONSTANT INTEGER := -20435;
delete_job_complete EXCEPTION;
PRAGMA EXCEPTION_INIT(delete_job_complete, -20435);
-- Error reassining a job
REASSIGN_JOB_ERR CONSTANT INTEGER := -20436;
reassign_job EXCEPTION;
PRAGMA EXCEPTION_INIT(reassign_job, -20436);
JOB_REASSIGNED_ERR CONSTANT INTEGER := -20437;
job_reassigned EXCEPTION;
PRAGMA EXCEPTION_INIT(job_reassigned, -20437);
EXEC_JOB_REASSIGNED_ERR CONSTANT INTEGER := -20438;
exec_job_reassigned EXCEPTION;
PRAGMA EXCEPTION_INIT(exec_job_reassigned, -20438);
-- Invalid end time, there are scheduled executions
-- beyond the end time
INVAL_END_TIME_SCH_EXECS_ERR CONSTANT INTEGER := -20439;
invalid_end_time_sch_execs EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_end_time_sch_execs, -20439);
--error during target post-delete callback
JOB_TARGET_POST_DELETE_ERR CONSTANT INTEGER := -20440;
job_target_post_delete EXCEPTION;
PRAGMA EXCEPTION_INIT(job_target_post_delete, -20440);
-- no target specified
NO_TARGET_SPECIFIED_ERR CONSTANT INTEGER := -20441;
no_target_specified EXCEPTION;
PRAGMA EXCEPTION_INIT(no_target_specified, -20441);
NO_TARGET_SPECIFIED_ERR_M CONSTANT VARCHAR2(35) := 'Target list of the job is empty';
-- start or end time invalid
START_END_TIME_INVALID_ERR CONSTANT INTEGER := -20442;
start_end_time_invalid EXCEPTION;
PRAGMA EXCEPTION_INIT(start_end_time_invalid, -20442);
START_END_TIME_INVALID_ERR_M CONSTANT VARCHAR2(40) := 'Invalid start/end time in the schedule';
--An attempt was made to restart an execution when either the job or the job type
--is marked non-restartable
RESTART_INVALID_ERR CONSTANT INTEGER := -20443;
restart_invalid EXCEPTION;
PRAGMA EXCEPTION_INIT(restart_invalid, -20443);
--An attempt was made to restart an execution for which some of the
--targets have been deleted
RESTART_DELETED_TARGETS_ERR CONSTANT INTEGER := -20444;
restart_deleted_targets EXCEPTION;
PRAGMA EXCEPTION_INIT(restart_deleted_targets, -20444);
--An attempt was made to delete a jobtype which is currently being used by some jobs
JOB_USING_JOBTYPE_DELETE_ERR CONSTANT INTEGER := -20445;
job_using_jobtype_delete EXCEPTION;
PRAGMA EXCEPTION_INIT(job_using_jobtype_delete, -20445);
--The owner submitting the job is not registered
UNREGISTERED_OWNER_ERR CONSTANT INTEGER := -20446;
unregistered_owner EXCEPTION;
PRAGMA EXCEPTION_INIT(unregistered_owner, -20446);
UNREGISTERED_OWNER_ERR_M CONSTANT VARCHAR2(50) := 'The owner of the job is not registered';
------------------------
-- Job UI Error Codes --
------------------------
INVALID_FLATTENING_INPUT_ERR CONSTANT INTEGER := -20451;
invalid_flattening_input EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_flattening_input, -20451);
ONLY_ONE_TARGET_ERR CONSTANT INTEGER := -20452;
only_one_target_input EXCEPTION;
PRAGMA EXCEPTION_INIT(only_one_target_input, -20452);
ONLY_ONE_TARGET_ERR_M CONSTANT VARCHAR2(60) := 'Only one target may be selected for this operation.';
-- Invalid credential metadata for job type
INVALID_JOB_CRED_ERR CONSTANT INTEGER := -20453;
invalid_job_cred EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_job_cred, -20453);
INVALID_JOB_CRED_ERR_M CONSTANT VARCHAR2(60) := 'The credential metadata for the job type is invalid: ';
--If the step is not in executing status
STEP_NOT_EXECUTING_ERR CONSTANT INTEGER := -20454;
step_not_executing EXCEPTION;
PRAGMA EXCEPTION_INIT(step_not_executing, -20454);
STEP_NOT_EXECUTING_ERR_M CONSTANT VARCHAR2(60) := 'The step is not in running state.';
--If the user does not have access to kill step
INVALID_STEP_ACCESS_ERR CONSTANT INTEGER := -20455;
invalid_step_access EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_step_access, -20455);
INVALID_STEP_ACCESS_ERR_M CONSTANT VARCHAR2(60) := 'The current user does not have access to kill the step.';
--If the step is not of the type that is dispatched to agent
STEP_NOT_FOR_AGENT_ERR CONSTANT INTEGER := -20456;
step_not_for_agent EXCEPTION;
PRAGMA EXCEPTION_INIT(step_not_for_agent, -20456);
STEP_NOT_FOR_AGENT_ERR_M CONSTANT VARCHAR2(60) := 'The step is not of the type that is dispatched to agent.';
------- End job system error codes
---------------------------------------------------------------------------
--Audit Frame work Error Codes BEGIN
--Error Codes from -20480 to -20499
---------------------------------------------------------------------------
INVALID_AUDIT_MODE_ERR CONSTANT INTEGER := -20480;
invalid_audit_mode EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_audit_mode, -20480);
INVALID_AUDIT_FILE_PATH_ERR CONSTANT INTEGER := -20481;
invalid_audit_file_path EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_audit_file_path, -20481);
INVALID_AUDIT_LEVEL_ERR CONSTANT INTEGER := -20482;
invalid_audit_level EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_audit_level, -20482);
FOUND_AUDIT_OP_CODE_ERR CONSTANT INTEGER := -20483;
found_audit_op_code EXCEPTION;
PRAGMA EXCEPTION_INIT(found_audit_op_code, -20483);
INVALID_AUDIT_OP_CODE_ERR CONSTANT INTEGER := -20484;
invalid_audit_op_code EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_audit_op_code, -20484);
INVALID_AUDIT_OPERATION_ERR CONSTANT INTEGER := -20485;
invalid_audit_operation EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_audit_operation, -20485);
NOT_FOUND_AUDIT_OP_CODE_ERR CONSTANT INTEGER := -20486;
not_found_audit_op_code EXCEPTION;
PRAGMA EXCEPTION_INIT(not_found_audit_op_code, -20486);
INVALID_AUDIT_DESTINATION_ERR CONSTANT INTEGER := -20487;
invalid_audit_destination EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_audit_destination, -20487);
INVALID_AUDIT_DIR_ERR CONSTANT INTEGER := -20488;
invalid_audit_dir EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_audit_dir, -20488);
DUPLICATE_AUD_OBJ_ERR CONSTANT INTEGER := -20490;
duplicate_aud_obj EXCEPTION;
PRAGMA EXCEPTION_INIT(duplicate_aud_obj, -20490);
AUD_OBJ_DOES_NOT_EXIST_ERR CONSTANT INTEGER := -20491;
aud_obj_does_not_exist EXCEPTION;
PRAGMA EXCEPTION_INIT(aud_obj_does_not_exist, -20491);
---------------------------------------------------------------------------
--Audit Frame work Error Codes END
--Error Codes from -20480 to -20499
---------------------------------------------------------------------------
TARGET_ALREADY_EXISTS_ERR CONSTANT INTEGER := -20500;
target_already_exists EXCEPTION;
PRAGMA EXCEPTION_INIT(target_already_exists, -20500);
TARGET_ALREADY_EXISTS_ERR_M CONSTANT VARCHAR2(30) := 'Target Already exists: ';
DUPLICATE_TARGET_ERR CONSTANT INTEGER := -20501;
duplicate_target EXCEPTION;
PRAGMA EXCEPTION_INIT(duplicate_target, -20501);
DUPLICATE_TARGET_ERR_M CONSTANT VARCHAR2(32) := 'Duplicate target : ';
MULTIPLE_AGENTS_PER_URL_ERR CONSTANT INTEGER := -20502;
multiple_agents_per_url EXCEPTION;
PRAGMA EXCEPTION_INIT(multiple_agents_per_url, -20502);
MULTIPLE_AGENTS_PER_URL_ERR_M CONSTANT VARCHAR2(64) := 'Multiple agents detected for : ';
ACTION_NOT_SUPP_ERR CONSTANT INTEGER := -20503;
action_not_supp EXCEPTION;
PRAGMA EXCEPTION_INIT(action_not_supp, -20503);
ACTION_NOT_SUPP_ERR_M CONSTANT VARCHAR2(64) := 'The requested action is not supported.';
---------------------------------------------------------------------------
--IP (Report) System error codes BEGIN
--Error Codes from -20580 to -20599
---------------------------------------------------------------------------
-- A report was submitted with an invalid (non-existent) report id
INVALID_IP_REPORT_ERR CONSTANT INTEGER := -20580;
invalid_ip_report EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_ip_report, -20580);
-- A report was submitted with an invalid (non-existent) report id
IP_REPORT_DOES_NOT_EXIST_ERR CONSTANT INTEGER := -20581;
ip_report_does_not_exist EXCEPTION;
PRAGMA EXCEPTION_INIT(ip_report_does_not_exist, -20581);
-- Access to report denied
IP_REPORT_ACCESS_DENIED_ERR CONSTANT INTEGER := -20582;
ip_report_access_denied EXCEPTION;
PRAGMA EXCEPTION_INIT(ip_report_access_denied, -20582);
---------------------------------------------------------------------------
--IP (Report) System error codes END
--Error Codes from -20580 to -20599
---------------------------------------------------------------------------
----
---- Trigger related error codes.
----
--
-- Inserting target metadata or severity/metric data when target is delete pending
--
-- On receiving this error during insert, the loader doesnot perform the update.
-- As this is a common occurrence during target deletion, these errors are
-- not logged into the system error log.
--
TARGET_DELETION_IN_PROG_ERR CONSTANT INTEGER := -20600;
target_deletion_in_prog EXCEPTION;
PRAGMA EXCEPTION_INIT(target_deletion_in_prog, -20600);
TARGET_DELETION_IN_PROG_ERR_M CONSTANT VARCHAR2(128) := 'The specified target is in the process of being deleted.';
--
-- Duplicate error/severity/blackout records
--
-- On receiving this error, during insert, the loader doesnt perform an update
-- As this is a common occurrence, these errors are *not* logged into
-- the system error log.
--
DUPLICATE_RECORD_ERR CONSTANT INTEGER := -20601;
duplicate_record EXCEPTION;
PRAGMA EXCEPTION_INIT(duplicate_record, -20601);
DUPLICATE_RECORD_ERR_M CONSTANT VARCHAR2(128) := 'Duplicate record.';
--
-- Update error.
-- On receiving this error, the loader skips the record and continues with the next one
-- As this is a common occurrence, these errors are *not* logged into the system error log.
--
UPDATE_RECORD_ERR CONSTANT INTEGER := -20602;
update_record EXCEPTION;
PRAGMA EXCEPTION_INIT(update_record, -20602);
UPDATE_RECORD_ERR_M CONSTANT VARCHAR2(128) := 'Updating these records is not supported.';
--
-- Update timezone region error.
-- On receiving this error, the loader sends a FATAL error to the agent to stop.
--
UPDATE_TZRGN_ERR CONSTANT INTEGER := -20603;
update_tzrgn EXCEPTION;
PRAGMA EXCEPTION_INIT(update_tzrgn, -20603);
UPDATE_TZRGN_ERR_M CONSTANT VARCHAR2(128) := 'Updating timezone region of a target is not supported. Use mgmt_target.set_agent_tzrgn() API to modify the timezone region.';
--
-- Overlapping metric/default collection definitions detected.
-- On receiving this error, the loader skips the record and continues with the next one
-- As this is not a common occurrence, these errors are logged into the system error log.
--
OVERLAPPING_CATPROP_DEF_ERR CONSTANT INTEGER := -20604;
overlapping_catprop_def EXCEPTION;
PRAGMA EXCEPTION_INIT(overlapping_catprop_def, -20604);
OVERLAPPING_CATPROP_DEF_ERR_M CONSTANT VARCHAR2(256) := 'Metric or default collection definition with overlapping category property values is detected. Overlap detected while inserting : ';
--- Severity insert trigger error codes
--
-- Agent Lock Busy
-- On receiving this error, the loader skips the severity file.
-- This is to handle the case where loader is already processing a severity file and
-- agent sends another severity file. When loader attempts to load the new severity file
-- it gets this exception while acquiring a db lock for the agent.
--
-- THIS CODE MUST NOT BE USED FOR OTHER PURPOSES AS THE SEVERITY FILE WILL NOT BE
-- SAVED IN THE ERRORS DIRECTORY.
--
AGENT_LOCK_BUSY_ERR CONSTANT INTEGER := -20609;
agent_lock_busy EXCEPTION;
PRAGMA EXCEPTION_INIT(agent_lock_busy, -20609);
AGENT_LOCK_BUSY_ERR_M CONSTANT VARCHAR2(128) := 'Error obtaining upload lock on emd_url:';
--
-- Invalid severity code
-- On receiving this error, the loader skips the record and continues with the next one
-- As this is not a common occurrence, these errors are logged into the system error log.
--
INVALID_SEVERITY_CODE_ERR CONSTANT INTEGER := -20610;
invalid_severity_code EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_severity_code, -20610);
INVALID_SEVERITY_CODE_ERR_M CONSTANT VARCHAR2(128) := 'Invalid severity code for : ';
--
-- Inconsistant severity code.
-- On receiving this error, the loader skips the record and continues with the next one
-- As this is not a common occurrence, these errors are logged into the system error log.
--
INCONSISTANT_SEVERITY_ERR CONSTANT INTEGER := -20611;
inconsistant_severity EXCEPTION;
PRAGMA EXCEPTION_INIT(inconsistant_severity, -20611);
INCONSISTANT_SEVERITY_ERR_M CONSTANT VARCHAR2(128) := 'Inconsistant severity is being inserted for : ';
--
-- Internal severity error.
-- On receiving this error, the loader skips the record and continues with the next one
-- As this is not a common occurrence, these errors are logged into the system error log.
--
INTERNAL_SEVERITY_ERR CONSTANT INTEGER := -20612;
internal_severity EXCEPTION;
PRAGMA EXCEPTION_INIT(internal_severity, -20612);
INTERNAL_SEVERITY_ERR_M CONSTANT VARCHAR2(128) := 'Internal error processing severity.';
--
-- Unknown target.
-- On receiving this error, the loader skips the record and continues with the next one
-- As this is not a common occurrence, these errors are logged into the system error log.
--
UNKNOWN_TARGET_ERR CONSTANT INTEGER := -20613;
unknown_target EXCEPTION;
PRAGMA EXCEPTION_INIT(unknown_target, -20613);
UNKNOWN_TARGET_ERR_M CONSTANT VARCHAR2(128) := 'Severity for unknown target. ';
--
-- Unknown target.
-- On receiving this error, the loader skips the record and continues with the next one
-- As this is not a common occurrence, these errors are logged into the system error log.
--
NON_MASTER_AGENT_ERR CONSTANT INTEGER := -20614;
non_master_agent EXCEPTION;
PRAGMA EXCEPTION_INIT(non_master_agent, -20614);
NON_MASTER_AGENT_ERR_M CONSTANT VARCHAR2(128) := 'Severity loaded from a non-master agent for the target. ';
--
-- Severity received during blackout
-- On receiving this error, the loader skips the record and continues with the next one
-- As this is not a common occurrence, these errors are logged into the system error log.
--
SEVERITY_IN_BLACKOUT_ERR CONSTANT INTEGER := -20615;
severity_in_blackout EXCEPTION;
PRAGMA EXCEPTION_INIT(severity_in_blackout, -20615);
SEVERITY_IN_BLACKOUT_ERR_M CONSTANT VARCHAR2(128) := 'Severity received during blackout for : ';
-- When there is no record found for severity configured target guid, policy_guid,
-- collection_name, key value and key operator in MGMT_POLICY_ASSOC_CFG
--
SEVERITY_CFG_MISSING_ERR CONSTANT INTEGER := -20616;
severity_cfg_missing EXCEPTION;
PRAGMA EXCEPTION_INIT(severity_cfg_missing, -20616);
SEVERITY_CFG_MISSING_ERR_M CONSTANT VARCHAR2(128) := 'Severity has missing configuration ';
-- Severity received out of order. Severity timestamp is smaller than marker
-- timestamp.
-- On receiving this exception, the loader will request that the agent execute
-- a discard state on the associated target.
--
SEVERITY_OUT_ORDER_ERR CONSTANT INTEGER := -20617;
serverity_out_order EXCEPTION;
PRAGMA EXCEPTION_INIT(serverity_out_order, -20617);
SEVERITY_OUT_ORDER_ERR_M CONSTANT VARCHAR2(128) := 'Severity timestamp is smaller than current marker.';
-- Agent is being deleted.
-- On receiveing this error send the FATAL Error
-- back to agent to shut it down.
AGENT_DELETION_IN_PROG_ERR CONSTANT INTEGER := -20618;
agent_deletion_in_prog EXCEPTION;
PRAGMA EXCEPTION_INIT(agent_deletion_in_prog, -20618);
AGENT_DELETION_IN_PROG_ERR_M CONSTANT VARCHAR2(256) := 'The specified agent is in the process of being deleted from the repository, wait for deletion to complete before restarting the agent.';
-- Target is already deleted and OMS receives a meta data file to add the same target with old time stamp
-- On encountering such a scenario thrwo stale_target_addtion_exception. This exception will be ignored by OMS
STALE_TARGET_ADDITION_ERR CONSTANT INTEGER := -20619;
stale_target_addtion_exception EXCEPTION;
PRAGMA EXCEPTION_INIT(stale_target_addtion_exception, -20619);
STALE_TARGET_ADDITION_ERR_M CONSTANT VARCHAR2(256) := 'Load timestamp of the specified target is before the delete_complete_time. This record wil not be processed.';
-- This exception is do indicate loader that severiy record
-- need not be saved to the database.
IGNORE_SEVERITY_ERR CONSTANT INTEGER := -20620;
ignore_severity_exception EXCEPTION;
PRAGMA EXCEPTION_INIT(ignore_severity_exception, -20620);
IGNORE_SEVERITY_ERR_M CONSTANT VARCHAR2(256) := 'Ignore severity error. This record will not be saved in the repository';
-- END trigger releated error codes
-- Target Associations related error codes
-- blocked error codes from 20621 to 20630
ASSOC_ALREADY_EXIST_ERR CONSTANT INTEGER := -20621;
assoc_already_exist EXCEPTION;
PRAGMA EXCEPTION_INIT(assoc_already_exist, -20621);
ASSOC_DOES_NOT_EXIST_ERR CONSTANT INTEGER := -20622;
assoc_does_not_exist EXCEPTION;
PRAGMA EXCEPTION_INIT(assoc_does_not_exist, -20622);
ASSOC_DEF_ALREADY_EXIST_ERR CONSTANT INTEGER := -20623;
assoc_def_already_exist EXCEPTION;
PRAGMA EXCEPTION_INIT(assoc_def_already_exist, -20623);
ASSOC_DEF_DOES_NOT_EXIST_ERR CONSTANT INTEGER := -20624;
assoc_def_does_not_exist EXCEPTION;
PRAGMA EXCEPTION_INIT(assoc_def_does_not_exist, -20624);
CYCLIC_MEMBER_ASSOC_ERR CONSTANT INTEGER := -20625;
cyclic_member_assoc EXCEPTION;
PRAGMA EXCEPTION_INIT(cyclic_member_assoc, -20625);
-- END Associations related error codes
-- BEGIN severity related error codes
-- Reserving error codes from 20631 to 20650
-- Target is already deleted and OMS receives a meta data file to add the same target with old time stamp
-- On encountering such a scenario thrwo stale_target_addtion_exception. This exception will be ignored by OMS
INVALID_UNRCH_CLR_VIOL_ERR CONSTANT INTEGER := -20631;
invalid_unrch_clr_viol EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_unrch_clr_viol, -20631);
INVALID_UNRCH_CLR_VIOL_ERR_M CONSTANT VARCHAR2(256) :=
'Invalid Agent Unreachable Clear violation received for : ';
-- END severity related error codes
-- BEGIN blackout-related error codes
--
-- Invalid "blackout reason"
INVALID_BLACKOUT_REASON_ERR CONSTANT INTEGER := -20700;
invalid_blackout_reason EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_blackout_reason, -20700);
-- Invalid blackout (blackout does not exist)
INVALID_BLACKOUT_ERR CONSTANT INTEGER := -20701;
invalid_blackout EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_blackout, -20701);
-- Attempt to stop a blackout that is already stopped
-- or in the process of being stopped
BLACKOUT_STOPPED_ERR CONSTANT INTEGER := -20702;
blackout_stopped EXCEPTION;
PRAGMA EXCEPTION_INIT(blackout_stopped, -20702);
-- The blackout doesn't exist
BLACKOUT_NOT_EXIST_ERR CONSTANT INTEGER := -20703;
blackout_not_exist EXCEPTION;
PRAGMA EXCEPTION_INIT(blackout_not_exist, -20703);
-- Attempt to perform an operation (such as delete) on
-- an active blackout
BLACKOUT_NOT_STOPPED_ERR CONSTANT INTEGER := -20704;
blackout_not_stopped EXCEPTION;
PRAGMA EXCEPTION_INIT(blackout_not_stopped, -20704);
-- Attempt to edit/stop a blackout whose last edits
-- have not yet been completed
BLACKOUT_PENDING_EDIT_ERR CONSTANT INTEGER := -20705;
blackout_pending_edit EXCEPTION;
PRAGMA EXCEPTION_INIT(blackout_pending_edit, -20705);
-- Attempt to edit/stop a blackout that is already
-- pending stop
BLACKOUT_STOP_PENDING_ERR CONSTANT INTEGER := -20706;
blackout_stop_pending EXCEPTION;
PRAGMA EXCEPTION_INIT(blackout_stop_pending, -20706);
BLACKOUT_STOP_FAILED_ERR CONSTANT INTEGER := -20707;
blackout_stop_failed EXCEPTION;
PRAGMA EXCEPTION_INIT(blackout_stop_failed, -20707);
BLACKOUT_START_PROCESS_ERR CONSTANT INTEGER := -20708;
blackout_start_process EXCEPTION;
PRAGMA EXCEPTION_INIT(blackout_start_process, -20708);
BLKOUT_NOT_CREATED_USER_ERR CONSTANT INTEGER := -20709;
blkout_not_created_user EXCEPTION;
PRAGMA EXCEPTION_INIT(blkout_not_created_user, -20709);
BLKOUT_STARTED_AT_AGENT_ERR CONSTANT INTEGER := -20710;
blkout_started_at_agent EXCEPTION;
PRAGMA EXCEPTION_INIT(blkout_started_at_agent, -20710);
BLKOUT_INVALID_STATE_MOD_ERR CONSTANT INTEGER := -20711;
blkout_invalid_state_mod EXCEPTION;
PRAGMA EXCEPTION_INIT(blkout_invalid_state_mod, -20711);
BLKOUT_INVALID_STATE_DEL_ERR CONSTANT INTEGER := -20712;
blkout_invalid_state_del EXCEPTION;
PRAGMA EXCEPTION_INIT(blkout_invalid_state_del, -20712);
BLKOUT_INVALID_STATE_STOP_ERR CONSTANT INTEGER := -20713;
blkout_invalid_state_stop EXCEPTION;
PRAGMA EXCEPTION_INIT(blkout_invalid_state_stop, -20713);
BLKOUT_NO_PRIVS_SEL_TGTS_ERR CONSTANT INTEGER := -20714;
blkout_no_privs_sel_tgts EXCEPTION;
PRAGMA EXCEPTION_INIT(blkout_no_privs_sel_tgts, -20714);
BLKOUT_NO_PRIVS_HOST_TGTS_ERR CONSTANT INTEGER := -20715;
blkout_no_privs_host_tgts EXCEPTION;
PRAGMA EXCEPTION_INIT(blkout_no_privs_host_tgts, -20715);
BLKOUT_ALREADY_EXISTS_ERR CONSTANT INTEGER := -20716;
blkout_already_exists EXCEPTION;
PRAGMA EXCEPTION_INIT(blkout_already_exists, -20716);
-- Invalid blackout schedule
BLK_INVALID_SCHEDULE_ERR CONSTANT INTEGER := -20717;
blk_invalid_schedule EXCEPTION;
PRAGMA EXCEPTION_INIT(blk_invalid_schedule, -20717);
-- Cannot create blackout error
BLKOUT_CREATE_FAILED_ERR CONSTANT INTEGER := -20718;
blkout_create_failed EXCEPTION;
PRAGMA EXCEPTION_INIT(blkout_create_failed, -20718);
-- END blackout-related error codes
-- BEGIN Policy framework error codes
POLICY_DOES_NOT_EXIST_ERR CONSTANT INTEGER := -20750;
policy_does_not_exist EXCEPTION;
PRAGMA EXCEPTION_INIT(policy_does_not_exist, -20750);
METRIC_SETTINGS_LOCK_BUSY_ERR CONSTANT INTEGER := -20751;
metric_settings_lock_busy EXCEPTION;
PRAGMA EXCEPTION_INIT(metric_settings_lock_busy, -20751);
METRIC_SETTINGS_LOCK_BUSY_ERRM CONSTANT VARCHAR2(128) := 'Error obtaining metric settings lock for :';
-- END Policy framework error codes
-- BEGIN Template framework error codes
TEMPLATE_DOES_NOT_EXIST_ERR CONSTANT INTEGER := -20775;
template_does_not_exist EXCEPTION;
PRAGMA EXCEPTION_INIT(template_does_not_exist, -20775);
TEMPLATE_ALREADY_EXISTS_ERR CONSTANT INTEGER := -20776;
template_already_exists EXCEPTION;
PRAGMA EXCEPTION_INIT(template_already_exists, -20776);
TEMPLATE_COPY_NOT_FOUND_ERR CONSTANT INTEGER := -20777;
template_copy_not_found EXCEPTION;
PRAGMA EXCEPTION_INIT(template_copy_not_found, -20777);
-- END Template framework error codes
-- BEGIN ECM Framework error codes
SNAPSHOT_LOCK_ERR CONSTANT INTEGER := -20800;
snapshot_lock EXCEPTION;
PRAGMA EXCEPTION_INIT(snapshot_lock, -20800);
SNAPSHOT_MISSING_ERR CONSTANT INTEGER := -20801;
snapshot_missing EXCEPTION;
PRAGMA EXCEPTION_INIT(snapshot_missing, -20801);
-- problems updating ECM metadata materialized view(s)
ECM_METADATA_UPDATE_ERR CONSTANT INTEGER := -20802;
ecm_metadata_update EXCEPTION;
PRAGMA EXCEPTION_INIT(ecm_metadata_update, -20802);
-- END ECM Framework error codes
-- BEGIN storage reports error codes
STORAGE_SNAPSHOT_MISSING_ERR CONSTANT INTEGER := -20850;
storage_snapshot_missing EXCEPTION;
PRAGMA EXCEPTION_INIT(storage_snapshot_missing, -20850);
STORAGE_SNAPSHOT_MISSING_ERR_M CONSTANT VARCHAR2(128) :=
'Missing storage snapshot for: ';
-- END storage reports error codes
-- BEGIN Credential framework error codes
-- Invalid credential set
INVALID_CRED_SET_ERR CONSTANT INTEGER := -20900;
invalid_cred_set EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_cred_set, -20900);
-- END Credential framework error codes
---------------------------------------------------------------------------
--Generic Service Error Codes BEGIN
-- Error Codes from -20901 to -20999
---------------------------------------------------------------------------
INVALID_CRIT_COMPONENTS_ERR CONSTANT INTEGER := -20901;
invalid_crit_components EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_crit_components, -20901);
INVALID_CRIT_COMPONENTS_ERR_M CONSTANT VARCHAR2(128) :=
'One or more critical components are not part of System';
INVALID_TEST_DEFINITION_ERR CONSTANT INTEGER := -20903;
invalid_test_definition EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_test_definition, -20903);
INVALID_TEST_DEFINITION_ERR_M CONSTANT VARCHAR2(128) :=
'Invalid Transaction';
INVALID_SVC_AVAIL_COMP_ERR CONSTANT INTEGER := -20905;
invalid_svc_avail_comp EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_svc_avail_comp, -20905);
INVALID_SVC_AVAIL_COMP_ERR_M CONSTANT VARCHAR2(128) :=
'Invalid Service availability computation mechanism. Service can only have either System based or test based availability ';
INVALID_METRIC_DEP_ERR CONSTANT INTEGER := -20906;
invalid_metric_dep EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_metric_dep, -20906);
INVALID_METRIC_DEP_ERR_M CONSTANT VARCHAR2(128) :=
'Invalid metric dependency setup ';
MISSING_EVAL_FUNC_ERR CONSTANT INTEGER := -20907;
missing_eval_func EXCEPTION;
PRAGMA EXCEPTION_INIT(missing_eval_func, -20907);
MISSING_EVAL_FUNC_ERR_M CONSTANT VARCHAR2(128) :=
'Metric evaluation function not registered ';
INVALID_METRIC_PROM_ERR CONSTANT INTEGER := -20908;
invalid_metric_prom EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_metric_prom, -20908);
INVALID_METRIC_PROM_ERR_M CONSTANT VARCHAR2(128) :=
'Invalid default metric promotion definition ';
INVALID_AGG_SVC_TYPE_ERR CONSTANT INTEGER := -20909;
invalid_agg_svc_type EXCEPTION;
PRAGMA EXCEPTION_INIT(invalid_agg_svc_type, -20909);
INVALID_AGG_SVC_TYPE_ERR_M CONSTANT VARCHAR2(128) :=
'The type is not a valid aggregate service type ';
EMPTY_KEY_VALUE_ERR CONSTANT INTEGER := -20910;
empty_key_value EXCEPTION;
PRAGMA EXCEPTION_INIT(empty_key_value, -20910);
EMPTY_KEY_VALUE_ERR_M CONSTANT VARCHAR2(128) :=
'Key value is missing ';
LOOP_CONTAINMENT_ERR constant INTEGER := -20911;
loop_containment EXCEPTION;
PRAGMA EXCEPTION_INIT(loop_containment, -20911);
LOOP_CONTAINMENT_ERR_M constant VARCHAR2(128) :=
'A system can not contain services that are currently running on the system itself ';
CANNOT_DELETE_KEY_BCN_ERR constant INTEGER := -20912;
cannot_delete_key_bcn EXCEPTION;
PRAGMA EXCEPTION_INIT(cannot_delete_key_bcn, -20912);
CANNOT_DELETE_KEY_BCN_ERR_M constant VARCHAR2(128) :=
'Key beacon association can not be removed from a service.';
BCN_ASSOC_DOES_NOT_EXIST_ERR constant INTEGER := -20913;
bcn_assoc_does_not_exist EXCEPTION;
PRAGMA EXCEPTION_INIT(bcn_assoc_does_not_exist, -20913);
BCN_ASSOC_DOES_NOT_EXIST_ERR_M constant VARCHAR2(128) :=
'Beacon association with the service does not exist.';
KEY_ALREADY_EXITS_ERR constant INTEGER := -20914;
key_already_exists EXCEPTION;
PRAGMA EXCEPTION_INIT(key_already_exists, -20914);
KEY_ALREADY_EXITS_ERR_M constant VARCHAR2(128) :=
'Another metric or collection exists with the same name for this target.';
ASSOC_BCN_TEST_NOT_SUPP_ERR constant INTEGER := -20915;
assoc_bcn_test_not_supp EXCEPTION;
PRAGMA EXCEPTION_INIT(assoc_bcn_test_not_supp, -20915);
ASSOC_BCN_TEST_NOT_SUPP_ERR_M constant VARCHAR2(128) :=
'Beacon versions do not support test type.';
TEST_METADATA_READ_ERR constant INTEGER := -20916;
test_metadata_read_error EXCEPTION;
PRAGMA EXCEPTION_INIT(test_metadata_read_error, -20916);
TEST_METADATA_READ_ERROR_M constant VARCHAR2(128) :=
'Unable to read test metadata ';
---------------------------------------------------------------------------
--Generic Service Error Codes END
---------------------------------------------------------------------------
---------------------------------------------------------------------------
-- Customization UI Error Codes BEGIN
-- Error Codes from -21801 to -21899
---------------------------------------------------------------------------
-- A request to add an existing page to customization framework
PAGE_NAME_ALREADY_EXISTS_ERR INTEGER := -20951;
page_name_already_exists EXCEPTION;
PAGE_NAME_ALREADY_EXISTS_M CONSTANT VARCHAR2(56) := 'Page already exist in the meatadata table';
PRAGMA EXCEPTION_INIT(page_name_already_exists, -20951);
-- A request to get customziation information for a non-existent page
NO_SUCH_PAGE_EXISTS_ERR INTEGER := -20952;
no_such_page_exists EXCEPTION;
NO_SUCH_PAGE_EXISTS_M CONSTANT VARCHAR2(56) := 'Page doesnt exist in the metadata table';
PRAGMA EXCEPTION_INIT(no_such_page_exists, -20952);
-- A request to add a condition information to an invalid customization
INVALID_CUSTOMIZATION_NAME_ERR INTEGER := -20953;
invalid_customization_name EXCEPTION;
INVALID_CUSTOMIZATION_NAME_M CONSTANT VARCHAR2(56) := 'Customization doesnt exist in the metadata table';
PRAGMA EXCEPTION_INIT(invalid_customization_name, -20953);
-- A request to add a customization with a invalid condition information
INVALID_CONDITION_NAME_ERR INTEGER := -20954;
invalid_condition_name EXCEPTION;
INVALID_CONDITION_NAME_M CONSTANT VARCHAR2(56) := 'Condition doesnt exist in the metadata table';
PRAGMA EXCEPTION_INIT(invalid_condition_name, -20954);
-- A request to add a already existing customization
CUSTOMIZATION_EXISTS_ERR INTEGER := -20955;
customization_exists EXCEPTION;
CUSTOMIZATION_EXISTS_M CONSTANT VARCHAR2(56) := 'Customization already exists';
PRAGMA EXCEPTION_INIT(customization_exists, -20955);
-- A request to add a already existing condition
CONDITION_ALREADY_EXISTS_ERR INTEGER := -20956;
condition_already_exists EXCEPTION;
CONDITION_ALREADY_EXISTS_M CONSTANT VARCHAR2(56) := 'Condition already exists';
PRAGMA EXCEPTION_INIT(condition_already_exists, -20956);
-----------------------------------------------------------------------------
--Configuration Standard Error Code Start
--Error codes frm 20960 to 20980
---------------------------------------------------------------------------
CS_DOES_NOT_EXIST_ERR CONSTANT INTEGER := -20960;
cs_does_not_exist EXCEPTION;
CS_DOES_NOT_EXIST_ERR_M CONSTANT VARCHAR2(50) := 'Configuration Standard does not exist:';
PRAGMA EXCEPTION_INIT(cs_does_not_exist, -20960);
NO_METRICS_FOUND_ERR CONSTANT INTEGER := -20961;
no_metrics_found EXCEPTION;
NO_METRICS_FOUND_ERR_M CONSTANT VARCHAR2(50) := 'No Metrics found for collection:';
PRAGMA EXCEPTION_INIT(no_metrics_found, -20961);
CS_ALREADY_EXISTS_ERR CONSTANT INTEGER := -20962;
cs_already_exists EXCEPTION;
CS_ALREADY_EXISTS_ERR_M CONSTANT VARCHAR2(50) := 'Configuration Standard already exist';
PRAGMA EXCEPTION_INIT(cs_already_exists, -20962);
CS_POLICY_RULE_TAG_ERR CONSTANT INTEGER := -20963;
cs_policy_rule_tag EXCEPTION;
CS_POLICY_RULE_TAG_ERR_M CONSTANT VARCHAR2(50) := 'CS contains a policy rule with 11g tags';
PRAGMA EXCEPTION_INIT(cs_policy_rule_tag, -20963);
-----------------------------------------------------------------------------
--Configuration Standard Error Code End
---------------------------------------------------------------------------
-----------------------------------------------------------------------------
-- Framework security Error Code start -20971 -20980
-----------------------------------------------------------------------------
PROCESS_INIT_EX_ERR CONSTANT INTEGER := -20971;
PROCESS_INIT_EX EXCEPTION;
PRAGMA EXCEPTION_INIT(PROCESS_INIT_EX, -20971);
PROCESS_AUTH_EX_ERR CONSTANT INTEGER := -20972;
PROCESS_AUTH_EX EXCEPTION;
PRAGMA EXCEPTION_INIT(PROCESS_AUTH_EX, -20972);
PROCESS_DOWNLOAD_EX_ERR CONSTANT INTEGER := -20973;
PROCESS_DOWNLOAD_EX EXCEPTION;
PRAGMA EXCEPTION_INIT(PROCESS_DOWNLOAD_EX, -20973);
INVALID_REG_PWD_ERR CONSTANT INTEGER := -20974;
INVALID_REG_PWD_EX EXCEPTION;
INVALID_REG_PWD_ERR_M CONSTANT VARCHAR2(128) := 'Invalid registartion password.';
PRAGMA EXCEPTION_INIT(INVALID_REG_PWD_EX, -20974);
-----------------------------------------------------------------------------
-- Framework security Error Code End
-----------------------------------------------------------------------------
---------------------------------------------------------------------------
-- Customization UI Error Codes END
---------------------------------------------------------------------------
-----------------------------------------------------------------------------
--Retroactive blackout Error Code Starts
--Error codes from 20981 to 20985
---------------------------------------------------------------------------
NO_RBK_PARAMETER_FOUND_ERR CONSTANT INTEGER := -20981;
no_rbk_parameter_found EXCEPTION;
NO_RBK_PARAMETER_FOUND_ERR_M CONSTANT VARCHAR2(50) := 'Retroactive blackout configuration not found';
PRAGMA EXCEPTION_INIT(no_rbk_parameter_found, -20981);
RBK_DISABLED_ERR CONSTANT INTEGER := -20982;
rbk_disabled EXCEPTION;
RBK_DISABLED_ERR_M CONSTANT VARCHAR2(50) := 'Retroactive blackout feature is disabled';
PRAGMA EXCEPTION_INIT(rbk_disabled, -20982);
-----------------------------------------------------------------------------
--Retroactive blackout Error Code END
---------------------------------------------------------------------------
--
-- ADJUST_TZ function
--
-- PURPOSE: This function adjusts the given date from a given source
-- timezone region to the destination timezone region.
-- IN parameters:
-- date: DATE The date that is to be adjusted.
-- src_tzrgn_in VARCHAR2 The source region of the date
-- dst_tzrgn_in VARCHAR2 The destination region of the date
--
-- OUT parameters:
-- No out parameters
-- RETURNS:
-- DATE: The adjusted date in the destination region
--
FUNCTION ADJUST_TZ(date_in DATE,
src_tzrgn_in VARCHAR2,
dst_tzrgn_in VARCHAR2)
RETURN DATE;
--
-- SYSDATE_TZRGN function
--
-- PURPOSE: This function returns the sysdate in the specified
-- timezone region.
--
-- IN parameters:
-- tzrgn_in VARCHAR2 : The timezone region on which SYSDATE is required
--
-- OUT parameters:
-- No out parameters
--
-- RETURNS:
-- DATE: The SYSDATE in the tzrgn_in timezone
--
FUNCTION SYSDATE_TZRGN(tzrgn_in VARCHAR2)
RETURN DATE;
--
-- SYSDATE_UTC function
--
-- PURPOSE: This function returns the date in the GMT timezone.
--
-- IN parameters:
-- No in parameters
--
-- OUT parameters:
-- No out parameters
--
-- RETURNS:
-- DATE: The SYSDATE in GMT timezone.
--
FUNCTION SYSDATE_UTC
RETURN DATE;
--
-- TO_UTC function
--
-- PURPOSE: This function converts the given date and timezone region
-- to UTC timezone
--
-- IN parameters:
-- date_in DATE : The date that needs to be converted to UTC
-- src_tzrgn_in VARCHAR2 : The timezone region of the date_in
--
-- OUT parameters:
-- No out parameters
--
-- RETURNS:
-- DATE: The date_in adjusted to UTC
--
FUNCTION TO_UTC(date_in DATE, src_tzrgn_in VARCHAR2)
RETURN DATE;
--
-- FROM_UTC function
--
-- PURPOSE: This function returns the date in dst_tzrgn_in timezone
-- for a given date in UTC timezone.
--
-- IN parameters:
-- utc_date_in DATE : The date in UTC timezone
-- dst_tzrgn_in VARCHAR2 : The timezone region of the returned date
--
-- OUT parameters:
-- No out parameters
--
-- RETURNS:
-- DATE: The date in dst_tzrgn_in timezone.
--
FUNCTION FROM_UTC(utc_date_in DATE, dst_tzrgn_in VARCHAR2)
RETURN DATE;
--
-- CHECK_OVERLAP function
--
-- PURPOSE: This function detects timezone overlap
-- for a given date in and timezone
--
-- IN parameters:
-- date_in DATE : The date to be checked for overlap
-- tzrgn_in VARCHAR2 : The timezone region of the date
--
-- OUT parameters:
-- No out parameters
--
-- RETURNS:
-- INTEGER : 0 if no overlap,
-- -1 of overlap
--
FUNCTION CHECK_OVERLAP(date_in DATE,
tzrgn_in VARCHAR2)
RETURN INTEGER;
--
-- GET_COMPOSITE_KEY_GUID function
--
-- PURPOSE: This function returns the composite key guid based on the key
-- part values in the string array - key_part_values_in
--
-- The composite key guid generation is based on the following algorithm:
--
-- GUID = MD5(a0 + ';' + a1 + ';' + ... an)
-- where an is the last non null piece
--
-- If pieces = [NULL, NULL, NULL]
-- GUID = MD5("")
--
-- If pieces = [NULL, 'foo', NULL]
-- GUID = MD5(";foo")
--
-- If pieces = [foo, NULL, NULL)
-- GUID = MD5("foo")
--
-- If pieces = [NULL,NULL,foo]
-- GUID = MD5(";;foo")
--
-- If the string array - key_part_values_in is null, an exception will be thrown
-- If key_part_values_in[i] is null or empty, it will be treated as null
-- based on the algorithm above.
--
-- IN parameters:
-- key_part_values_in SMP_EMD_STRING_ARRAY : The array of the key part
-- values of the composite key
--
-- OUT parameters:
-- No out parameters
--
-- RETURNS:
-- RAW(16) : the composite key guid
--
-- ERROR codes:
-- INVALID_PARAMS_ERR: invalid params error if key_part_values_in is null
--
FUNCTION GET_COMPOSITE_KEY_GUID(key_part_values_in IN SMP_EMD_STRING_ARRAY)
RETURN mgmt_metrics_composite_keys.composite_key%TYPE;
--
-- ELAPSED_TIME_MSEC function
--
-- PURPOSE: This function returns the elapsed time between two timestamps
-- in milliseconds.
--
-- IN parameters:
-- start_timestamp_in TIMESTAMP: The start timestamp
-- end_timestamp_in TIMESTAMP: The end timestamp
--
-- OUT parameters:
-- No out parameters
--
-- RETURNS:
-- NUMBER: The number of milliseconds
--
FUNCTION ELAPSED_TIME_MSEC(start_timestamp_in TIMESTAMP, end_timestamp_in TIMESTAMP)
RETURN NUMBER;
-- is_equivalent function
--
-- PURPOSE:This function returns 1 if the timezones are equivalent else 0
--
-- In Parameters:
-- p_timezone1 : First timezone
-- p_timezone2 : Second timezone
--
-- We do not have a straightforward way of finding the timezone equivalence.
-- What we do instead is check if the cast of sysdate in the two timezones
-- retrieve the same time.
-- For Example;
-- Cast(systimestamp at time zone 'US/Pacific') =
--Cast(systimestamp at time zone 'America/Los_Angeles')
-- .
-- To make sure the timezones will give same time across Daylight savings, we
-- could cast the first day of every month in the timezones and make sure they
-- will return same date.
FUNCTION is_equivalent_tz(p_timezone1 IN VARCHAR2,
p_timezone2 IN VARCHAR2)
RETURN NUMBER ;
--
END mgmt_global;
/
show errors;