89: X_RULE_TYPE in NUMBER
90: ) is
91: invalidRuleTypeException exception;
92: errorCode integer;
93: errorMessage ame_util.longestStringType;
94: begin
95: --ame_util.productionRuleType is not a valid rule type for 1159 ame.
96: if (X_RULE_TYPE <> ame_util.authorityRuleType)
97: and (X_RULE_TYPE <> ame_util.exceptionRuleType)
91: invalidRuleTypeException exception;
92: errorCode integer;
93: errorMessage ame_util.longestStringType;
94: begin
95: --ame_util.productionRuleType is not a valid rule type for 1159 ame.
96: if (X_RULE_TYPE <> ame_util.authorityRuleType)
97: and (X_RULE_TYPE <> ame_util.exceptionRuleType)
98: and (X_RULE_TYPE <> ame_util.listModRuleType)
99: and (X_RULE_TYPE <> ame_util.substitutionRuleType)
92: errorCode integer;
93: errorMessage ame_util.longestStringType;
94: begin
95: --ame_util.productionRuleType is not a valid rule type for 1159 ame.
96: if (X_RULE_TYPE <> ame_util.authorityRuleType)
97: and (X_RULE_TYPE <> ame_util.exceptionRuleType)
98: and (X_RULE_TYPE <> ame_util.listModRuleType)
99: and (X_RULE_TYPE <> ame_util.substitutionRuleType)
100: and (X_RULE_TYPE <> ame_util.preListGroupRuleType)
93: errorMessage ame_util.longestStringType;
94: begin
95: --ame_util.productionRuleType is not a valid rule type for 1159 ame.
96: if (X_RULE_TYPE <> ame_util.authorityRuleType)
97: and (X_RULE_TYPE <> ame_util.exceptionRuleType)
98: and (X_RULE_TYPE <> ame_util.listModRuleType)
99: and (X_RULE_TYPE <> ame_util.substitutionRuleType)
100: and (X_RULE_TYPE <> ame_util.preListGroupRuleType)
101: and (X_RULE_TYPE <> ame_util.postListGroupRuleType)
94: begin
95: --ame_util.productionRuleType is not a valid rule type for 1159 ame.
96: if (X_RULE_TYPE <> ame_util.authorityRuleType)
97: and (X_RULE_TYPE <> ame_util.exceptionRuleType)
98: and (X_RULE_TYPE <> ame_util.listModRuleType)
99: and (X_RULE_TYPE <> ame_util.substitutionRuleType)
100: and (X_RULE_TYPE <> ame_util.preListGroupRuleType)
101: and (X_RULE_TYPE <> ame_util.postListGroupRuleType)
102: and (
95: --ame_util.productionRuleType is not a valid rule type for 1159 ame.
96: if (X_RULE_TYPE <> ame_util.authorityRuleType)
97: and (X_RULE_TYPE <> ame_util.exceptionRuleType)
98: and (X_RULE_TYPE <> ame_util.listModRuleType)
99: and (X_RULE_TYPE <> ame_util.substitutionRuleType)
100: and (X_RULE_TYPE <> ame_util.preListGroupRuleType)
101: and (X_RULE_TYPE <> ame_util.postListGroupRuleType)
102: and (
103: (X_RULE_TYPE <> ame_util.productionRuleType
96: if (X_RULE_TYPE <> ame_util.authorityRuleType)
97: and (X_RULE_TYPE <> ame_util.exceptionRuleType)
98: and (X_RULE_TYPE <> ame_util.listModRuleType)
99: and (X_RULE_TYPE <> ame_util.substitutionRuleType)
100: and (X_RULE_TYPE <> ame_util.preListGroupRuleType)
101: and (X_RULE_TYPE <> ame_util.postListGroupRuleType)
102: and (
103: (X_RULE_TYPE <> ame_util.productionRuleType
104: and X_AME_INSTALLATION_LEVEL is not null)
97: and (X_RULE_TYPE <> ame_util.exceptionRuleType)
98: and (X_RULE_TYPE <> ame_util.listModRuleType)
99: and (X_RULE_TYPE <> ame_util.substitutionRuleType)
100: and (X_RULE_TYPE <> ame_util.preListGroupRuleType)
101: and (X_RULE_TYPE <> ame_util.postListGroupRuleType)
102: and (
103: (X_RULE_TYPE <> ame_util.productionRuleType
104: and X_AME_INSTALLATION_LEVEL is not null)
105: or (X_AME_INSTALLATION_LEVEL is null)
99: and (X_RULE_TYPE <> ame_util.substitutionRuleType)
100: and (X_RULE_TYPE <> ame_util.preListGroupRuleType)
101: and (X_RULE_TYPE <> ame_util.postListGroupRuleType)
102: and (
103: (X_RULE_TYPE <> ame_util.productionRuleType
104: and X_AME_INSTALLATION_LEVEL is not null)
105: or (X_AME_INSTALLATION_LEVEL is null)
106: ) then
107: raise invalidRuleTypeException;
109: exception
110: when invalidRuleTypeException then
111: errorCode := -20001;
112: errorMessage := 'OAM is attempting to upload an invalid rule type. ';
113: ame_util.runtimeException(packageNameIn => 'ame_action_type_usages_api',
114: routineNameIn => 'validate_rule_type',
115: exceptionNumberIn => errorCode,
116: exceptionStringIn => errorMessage);
117: raise_application_error(errorCode,
116: exceptionStringIn => errorMessage);
117: raise_application_error(errorCode,
118: errorMessage);
119: when others then
120: ame_util.runtimeException('ame_action_type_usages_api',
121: 'validate_rule_type',
122: sqlcode,
123: sqlerrm);
124: raise;
268: end if;
269: end;
270: exception
271: when others then
272: ame_util.runtimeException('ame_action_types_usages_api',
273: 'load_row',
274: sqlcode,
275: sqlerrm);
276: raise;