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_API2 dependencies on AME_UTIL

Line 163: errorMessage ame_util.longestStringType;

159:
160: X_CONDITION_KEY_CHECK NUMBER;
161: X_ATTR_CREATED_BY NUMBER;
162: errorCode integer;
163: errorMessage ame_util.longestStringType;
164: begin
165: if X_AME_INSTALLATION_LEVEL is not null then
166: open CSR_CHECK_CONDITION_KEY (
167: X_CONDITION_KEY

Line 221: ame_util.runtimeException(packageNameIn => 'ame_conditions_api2',

217: when duplicateCondKeyException then
218: errorMessage :=
219: 'OAM is attempting to upload a duplicate condition key.';
220: errorCode := -20001;
221: ame_util.runtimeException(packageNameIn => 'ame_conditions_api2',
222: routineNameIn => 'key_to_ids_2',
223: exceptionNumberIn => errorCode,
224: exceptionStringIn => errorMessage);
225: raise;

Line 227: ame_util.runtimeException('ame_conditions_api2',

223: exceptionNumberIn => errorCode,
224: exceptionStringIn => errorMessage);
225: raise;
226: when others then
227: ame_util.runtimeException('ame_conditions_api2',
228: 'key_to_ids_2',
229: sqlcode,
230: sqlerrm);
231: raise;

Line 246: errorMessage ame_util.longestStringType;

242: ) is
243: invalidConditionTypeException exception;
244: invalidCondAttrTypeException exception;
245: errorCode integer;
246: errorMessage ame_util.longestStringType;
247: X_ATTRIBUTE_TYPE varchar2(20);
248: X_PARAMETER_ONE_DATE date;
249: X_PARAMETER_TWO_DATE date;
250: X_PARAMETER_ONE_NUMBER number;

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

257: and sysdate between START_DATE
258: and nvl(END_DATE-(1/86400), sysdate);
259:
260: if X_CONDITION_TYPE not in
261: (ame_util.ordinaryConditionType , ame_util.exceptionConditionType) then
262: raise invalidConditionTypeException;
263: end if;
264:
265: if X_ATTRIBUTE_TYPE = ame_util.booleanAttributeType then

Line 265: if X_ATTRIBUTE_TYPE = ame_util.booleanAttributeType then

261: (ame_util.ordinaryConditionType , ame_util.exceptionConditionType) then
262: raise invalidConditionTypeException;
263: end if;
264:
265: if X_ATTRIBUTE_TYPE = ame_util.booleanAttributeType then
266: if (X_PARAMETER_ONE not in
267: (ame_util.booleanAttributeTrue, ame_util.booleanAttributeFalse))
268: or (X_PARAMETER_ONE is null)
269: or (X_PARAMETER_TWO is not null)

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

263: end if;
264:
265: if X_ATTRIBUTE_TYPE = ame_util.booleanAttributeType then
266: if (X_PARAMETER_ONE not in
267: (ame_util.booleanAttributeTrue, ame_util.booleanAttributeFalse))
268: or (X_PARAMETER_ONE is null)
269: or (X_PARAMETER_TWO is not null)
270: or (X_PARAMETER_THREE is not null)
271: or (X_INCLUDE_UPPER_LIMIT is not null)

Line 279: if X_ATTRIBUTE_TYPE = ame_util.numberAttributeType then

275: raise invalidCondAttrTypeException;
276: end if;
277: end if;
278:
279: if X_ATTRIBUTE_TYPE = ame_util.numberAttributeType then
280: if (X_INCLUDE_LOWER_LIMIT is not null
281: and (X_INCLUDE_LOWER_LIMIT not in
282: (ame_util.booleanTrue,ame_util.booleanFalse)))
283: or (X_INCLUDE_UPPER_LIMIT is not null

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

278:
279: if X_ATTRIBUTE_TYPE = ame_util.numberAttributeType then
280: if (X_INCLUDE_LOWER_LIMIT is not null
281: and (X_INCLUDE_LOWER_LIMIT not in
282: (ame_util.booleanTrue,ame_util.booleanFalse)))
283: or (X_INCLUDE_UPPER_LIMIT is not null
284: and (X_INCLUDE_UPPER_LIMIT not in
285: (ame_util.booleanTrue,ame_util.booleanFalse))) then
286: errorMessage :=

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

281: and (X_INCLUDE_LOWER_LIMIT not in
282: (ame_util.booleanTrue,ame_util.booleanFalse)))
283: or (X_INCLUDE_UPPER_LIMIT is not null
284: and (X_INCLUDE_UPPER_LIMIT not in
285: (ame_util.booleanTrue,ame_util.booleanFalse))) then
286: errorMessage :=
287: 'OAM is attempting to upload an invalid number attribute condition.';
288: raise invalidCondAttrTypeException;
289: end if;

Line 302: if X_ATTRIBUTE_TYPE = ame_util.currencyAttributeType then

298: from dual;
299: end if;
300: end if;
301:
302: if X_ATTRIBUTE_TYPE = ame_util.currencyAttributeType then
303: if (X_INCLUDE_LOWER_LIMIT is not null
304: and (X_INCLUDE_LOWER_LIMIT not in
305: (ame_util.booleanTrue,ame_util.booleanFalse)))
306: or (X_INCLUDE_UPPER_LIMIT is not null

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

301:
302: if X_ATTRIBUTE_TYPE = ame_util.currencyAttributeType then
303: if (X_INCLUDE_LOWER_LIMIT is not null
304: and (X_INCLUDE_LOWER_LIMIT not in
305: (ame_util.booleanTrue,ame_util.booleanFalse)))
306: or (X_INCLUDE_UPPER_LIMIT is not null
307: and (X_INCLUDE_UPPER_LIMIT not in
308: (ame_util.booleanTrue,ame_util.booleanFalse)))
309: or X_PARAMETER_THREE is null then

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

304: and (X_INCLUDE_LOWER_LIMIT not in
305: (ame_util.booleanTrue,ame_util.booleanFalse)))
306: or (X_INCLUDE_UPPER_LIMIT is not null
307: and (X_INCLUDE_UPPER_LIMIT not in
308: (ame_util.booleanTrue,ame_util.booleanFalse)))
309: or X_PARAMETER_THREE is null then
310: errorMessage :=
311: 'OAM is attempting to upload an invalid currency attribute condition.';
312: raise invalidCondAttrTypeException;

Line 326: if X_ATTRIBUTE_TYPE = ame_util.dateAttributeType then

322: from dual;
323: end if;
324: end if;
325:
326: if X_ATTRIBUTE_TYPE = ame_util.dateAttributeType then
327: if (X_INCLUDE_LOWER_LIMIT is not null
328: and (X_INCLUDE_LOWER_LIMIT not in
329: (ame_util.booleanTrue,ame_util.booleanFalse)))
330: or (X_INCLUDE_UPPER_LIMIT is not null

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

325:
326: if X_ATTRIBUTE_TYPE = ame_util.dateAttributeType then
327: if (X_INCLUDE_LOWER_LIMIT is not null
328: and (X_INCLUDE_LOWER_LIMIT not in
329: (ame_util.booleanTrue,ame_util.booleanFalse)))
330: or (X_INCLUDE_UPPER_LIMIT is not null
331: and (X_INCLUDE_UPPER_LIMIT not in
332: (ame_util.booleanTrue,ame_util.booleanFalse))) then
333: errorMessage :=

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

328: and (X_INCLUDE_LOWER_LIMIT not in
329: (ame_util.booleanTrue,ame_util.booleanFalse)))
330: or (X_INCLUDE_UPPER_LIMIT is not null
331: and (X_INCLUDE_UPPER_LIMIT not in
332: (ame_util.booleanTrue,ame_util.booleanFalse))) then
333: errorMessage :=
334: 'OAM is attempting to upload an invalid date attribute condition.';
335: raise invalidCondAttrTypeException;
336: end if;

Line 349: if X_ATTRIBUTE_TYPE = ame_util.stringAttributeType then

345: from dual;
346: end if;
347: end if;
348:
349: if X_ATTRIBUTE_TYPE = ame_util.stringAttributeType then
350: if (X_PARAMETER_ONE is not null)
351: or (X_PARAMETER_TWO is not null)
352: or (X_PARAMETER_THREE is not null)
353: or (X_INCLUDE_LOWER_LIMIT is not null)

Line 365: ame_util.runtimeException(packageNameIn => 'ame_conditions_api2',

361: when invalidConditionTypeException then
362: errorMessage :=
363: 'OAM is attempting to upload an invalid condition type.';
364: errorCode := -20001;
365: ame_util.runtimeException(packageNameIn => 'ame_conditions_api2',
366: routineNameIn => 'validate_condition',
367: exceptionNumberIn => errorCode,
368: exceptionStringIn => errorMessage);
369: raise_application_error(errorCode,

Line 373: ame_util.runtimeException(packageNameIn => 'ame_conditions_api2',

369: raise_application_error(errorCode,
370: errorMessage);
371: when invalidCondAttrTypeException then
372: errorCode := -20001;
373: ame_util.runtimeException(packageNameIn => 'ame_conditions_api2',
374: routineNameIn => 'validate_condition',
375: exceptionNumberIn => errorCode,
376: exceptionStringIn => errorMessage);
377: raise_application_error(errorCode,

Line 383: ame_util.runtimeException(packageNameIn => 'ame_conditions_api2',

379: when invalid_number then
380: errorMessage :=
381: 'OAM is attempting to upload an invalid number or currency attribute condition.';
382: errorCode := -20001;
383: ame_util.runtimeException(packageNameIn => 'ame_conditions_api2',
384: routineNameIn => 'validate_condition',
385: exceptionNumberIn => errorCode,
386: exceptionStringIn => errorMessage);
387: raise_application_error(errorCode,

Line 391: ame_util.runtimeException('ame_conditions_api2',

387: raise_application_error(errorCode,
388: errorMessage);
389:
390: when others then
391: ame_util.runtimeException('ame_conditions_api2',
392: 'validate_condition',
393: sqlcode,
394: sqlerrm);
395: raise;

Line 698: ame_util.runtimeException('ame_conditions_api2',

694: exception
695: when duplicateCondKeyException then
696: null;
697: when others then
698: ame_util.runtimeException('ame_conditions_api2',
699: 'load_row',
700: sqlcode,
701: sqlerrm);
702: raise;