eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_CONDITIONS_API dependencies on AME_UTIL

Line 96: errorMessage ame_util.longestStringType;

92: ) is
93: invalidConditionTypeException exception;
94: invalidCondAttrTypeException exception;
95: errorCode integer;
96: errorMessage ame_util.longestStringType;
97: X_ATTRIBUTE_TYPE varchar2(20);
98: X_PARAMETER_ONE_DATE date;
99: X_PARAMETER_TWO_DATE date;
100: X_PARAMETER_ONE_NUMBER number;

Line 111: (ame_util.ordinaryConditionType , ame_util.exceptionConditionType) then

107: and sysdate between START_DATE
108: and nvl(END_DATE-(1/86400), sysdate);
109:
110: if X_CONDITION_TYPE not in
111: (ame_util.ordinaryConditionType , ame_util.exceptionConditionType) then
112: raise invalidConditionTypeException;
113: end if;
114:
115: if X_ATTRIBUTE_TYPE = ame_util.booleanAttributeType then

Line 115: if X_ATTRIBUTE_TYPE = ame_util.booleanAttributeType then

111: (ame_util.ordinaryConditionType , ame_util.exceptionConditionType) then
112: raise invalidConditionTypeException;
113: end if;
114:
115: if X_ATTRIBUTE_TYPE = ame_util.booleanAttributeType then
116: if (X_PARAMETER_ONE not in
117: (ame_util.booleanAttributeTrue, ame_util.booleanAttributeFalse))
118: or (X_PARAMETER_ONE is null)
119: or (X_PARAMETER_TWO is not null)

Line 117: (ame_util.booleanAttributeTrue, ame_util.booleanAttributeFalse))

113: end if;
114:
115: if X_ATTRIBUTE_TYPE = ame_util.booleanAttributeType then
116: if (X_PARAMETER_ONE not in
117: (ame_util.booleanAttributeTrue, ame_util.booleanAttributeFalse))
118: or (X_PARAMETER_ONE is null)
119: or (X_PARAMETER_TWO is not null)
120: or (X_PARAMETER_THREE is not null)
121: or (X_INCLUDE_UPPER_LIMIT is not null)

Line 129: if X_ATTRIBUTE_TYPE = ame_util.numberAttributeType then

125: raise invalidCondAttrTypeException;
126: end if;
127: end if;
128:
129: if X_ATTRIBUTE_TYPE = ame_util.numberAttributeType then
130: if (X_INCLUDE_LOWER_LIMIT is not null
131: and (X_INCLUDE_LOWER_LIMIT not in
132: (ame_util.booleanTrue,ame_util.booleanFalse)))
133: or (X_INCLUDE_UPPER_LIMIT is not null

Line 132: (ame_util.booleanTrue,ame_util.booleanFalse)))

128:
129: if X_ATTRIBUTE_TYPE = ame_util.numberAttributeType then
130: if (X_INCLUDE_LOWER_LIMIT is not null
131: and (X_INCLUDE_LOWER_LIMIT not in
132: (ame_util.booleanTrue,ame_util.booleanFalse)))
133: or (X_INCLUDE_UPPER_LIMIT is not null
134: and (X_INCLUDE_UPPER_LIMIT not in
135: (ame_util.booleanTrue,ame_util.booleanFalse))) then
136: errorMessage :=

Line 135: (ame_util.booleanTrue,ame_util.booleanFalse))) then

131: and (X_INCLUDE_LOWER_LIMIT not in
132: (ame_util.booleanTrue,ame_util.booleanFalse)))
133: or (X_INCLUDE_UPPER_LIMIT is not null
134: and (X_INCLUDE_UPPER_LIMIT not in
135: (ame_util.booleanTrue,ame_util.booleanFalse))) then
136: errorMessage :=
137: 'OAM is attempting to upload an invalid number attribute condition.';
138: raise invalidCondAttrTypeException;
139: end if;

Line 152: if X_ATTRIBUTE_TYPE = ame_util.currencyAttributeType then

148: from dual;
149: end if;
150: end if;
151:
152: if X_ATTRIBUTE_TYPE = ame_util.currencyAttributeType then
153: if (X_INCLUDE_LOWER_LIMIT is not null
154: and (X_INCLUDE_LOWER_LIMIT not in
155: (ame_util.booleanTrue,ame_util.booleanFalse)))
156: or (X_INCLUDE_UPPER_LIMIT is not null

Line 155: (ame_util.booleanTrue,ame_util.booleanFalse)))

151:
152: if X_ATTRIBUTE_TYPE = ame_util.currencyAttributeType then
153: if (X_INCLUDE_LOWER_LIMIT is not null
154: and (X_INCLUDE_LOWER_LIMIT not in
155: (ame_util.booleanTrue,ame_util.booleanFalse)))
156: or (X_INCLUDE_UPPER_LIMIT is not null
157: and (X_INCLUDE_UPPER_LIMIT not in
158: (ame_util.booleanTrue,ame_util.booleanFalse)))
159: or X_PARAMETER_THREE is null then

Line 158: (ame_util.booleanTrue,ame_util.booleanFalse)))

154: and (X_INCLUDE_LOWER_LIMIT not in
155: (ame_util.booleanTrue,ame_util.booleanFalse)))
156: or (X_INCLUDE_UPPER_LIMIT is not null
157: and (X_INCLUDE_UPPER_LIMIT not in
158: (ame_util.booleanTrue,ame_util.booleanFalse)))
159: or X_PARAMETER_THREE is null then
160: errorMessage :=
161: 'OAM is attempting to upload an invalid currency attribute condition.';
162: raise invalidCondAttrTypeException;

Line 176: if X_ATTRIBUTE_TYPE = ame_util.dateAttributeType then

172: from dual;
173: end if;
174: end if;
175:
176: if X_ATTRIBUTE_TYPE = ame_util.dateAttributeType then
177: if (X_INCLUDE_LOWER_LIMIT is not null
178: and (X_INCLUDE_LOWER_LIMIT not in
179: (ame_util.booleanTrue,ame_util.booleanFalse)))
180: or (X_INCLUDE_UPPER_LIMIT is not null

Line 179: (ame_util.booleanTrue,ame_util.booleanFalse)))

175:
176: if X_ATTRIBUTE_TYPE = ame_util.dateAttributeType then
177: if (X_INCLUDE_LOWER_LIMIT is not null
178: and (X_INCLUDE_LOWER_LIMIT not in
179: (ame_util.booleanTrue,ame_util.booleanFalse)))
180: or (X_INCLUDE_UPPER_LIMIT is not null
181: and (X_INCLUDE_UPPER_LIMIT not in
182: (ame_util.booleanTrue,ame_util.booleanFalse))) then
183: errorMessage :=

Line 182: (ame_util.booleanTrue,ame_util.booleanFalse))) then

178: and (X_INCLUDE_LOWER_LIMIT not in
179: (ame_util.booleanTrue,ame_util.booleanFalse)))
180: or (X_INCLUDE_UPPER_LIMIT is not null
181: and (X_INCLUDE_UPPER_LIMIT not in
182: (ame_util.booleanTrue,ame_util.booleanFalse))) then
183: errorMessage :=
184: 'OAM is attempting to upload an invalid date attribute condition.';
185: raise invalidCondAttrTypeException;
186: end if;

Line 199: if X_ATTRIBUTE_TYPE = ame_util.stringAttributeType then

195: from dual;
196: end if;
197: end if;
198:
199: if X_ATTRIBUTE_TYPE = ame_util.stringAttributeType then
200: if (X_PARAMETER_ONE is not null)
201: or (X_PARAMETER_TWO is not null)
202: or (X_PARAMETER_THREE is not null)
203: or (X_INCLUDE_LOWER_LIMIT is not null)

Line 215: ame_util.runtimeException(packageNameIn => 'ame_conditions_api',

211: when invalidConditionTypeException then
212: errorMessage :=
213: 'OAM is attempting to upload an invalid condition type.';
214: errorCode := -20001;
215: ame_util.runtimeException(packageNameIn => 'ame_conditions_api',
216: routineNameIn => 'validate_condition',
217: exceptionNumberIn => errorCode,
218: exceptionStringIn => errorMessage);
219: raise_application_error(errorCode,

Line 223: ame_util.runtimeException(packageNameIn => 'ame_conditions_api',

219: raise_application_error(errorCode,
220: errorMessage);
221: when invalidCondAttrTypeException then
222: errorCode := -20001;
223: ame_util.runtimeException(packageNameIn => 'ame_conditions_api',
224: routineNameIn => 'validate_condition',
225: exceptionNumberIn => errorCode,
226: exceptionStringIn => errorMessage);
227: raise_application_error(errorCode,

Line 233: ame_util.runtimeException(packageNameIn => 'ame_conditions_api',

229: when invalid_number then
230: errorMessage :=
231: 'OAM is attempting to upload an invalid number or currency attribute condition.';
232: errorCode := -20001;
233: ame_util.runtimeException(packageNameIn => 'ame_conditions_api',
234: routineNameIn => 'validate_condition',
235: exceptionNumberIn => errorCode,
236: exceptionStringIn => errorMessage);
237: raise_application_error(errorCode,

Line 241: ame_util.runtimeException('ame_conditions_api',

237: raise_application_error(errorCode,
238: errorMessage);
239:
240: when others then
241: ame_util.runtimeException('ame_conditions_api',
242: 'validate_condition',
243: sqlcode,
244: sqlerrm);
245: raise;

Line 370: ame_util.runtimeException('ame_conditions_api',

366: end loop;
367: return(X_NEW_CONDITION_KEY);
368: exception
369: when others then
370: ame_util.runtimeException('ame_conditions_api',
371: 'create_condition_key',
372: sqlcode,
373: sqlerrm);
374: raise;

Line 451: ame_util.runtimeException('ame_conditions_api',

447: -- do not update or insert.
448: end;
449: exception
450: when others then
451: ame_util.runtimeException('ame_conditions_api',
452: 'load_row',
453: sqlcode,
454: sqlerrm);
455: raise;