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_CONDITIONS

Line 1: PACKAGE BODY AME_CONDITIONS_API2 AS

1: PACKAGE BODY AME_CONDITIONS_API2 AS
2: /* $Header: amecnapi.pkb 120.2 2006/07/12 07:24:01 pvelugul noship $ */
3: duplicateCondKeyException exception;
4: X_AME_INSTALLATION_LEVEL varchar2(255);
5: procedure OWNER_TO_WHO (

Line 39: from AME_CONDITIONS

35: (
36: X_CONDITION_KEY in VARCHAR2
37: ) is
38: select CONDITION_ID, CREATED_BY
39: from AME_CONDITIONS
40: where CONDITION_KEY = X_CONDITION_KEY;
41:
42: cursor CSR_IS_ATTRIBUTE_SEED
43: (

Line 121: from AME_CONDITIONS

117: (
118: X_CONDITION_KEY in VARCHAR2
119: ) is
120: select CONDITION_ID
121: from AME_CONDITIONS
122: where CONDITION_KEY = X_CONDITION_KEY;
123: cursor CSR_CONDITION_KEY
124: (
125: X_CONDITION_ID in NUMBER

Line 128: from AME_CONDITIONS

124: (
125: X_CONDITION_ID in NUMBER
126: ) is
127: select CONDITION_KEY
128: from AME_CONDITIONS
129: where CONDITION_ID = X_CONDITION_ID;
130:
131: cursor CSR_CONDITION_COUNT
132: (

Line 136: from AME_CONDITIONS

132: (
133: X_CONDITION_ID in NUMBER
134: ) is
135: select count(*)
136: from AME_CONDITIONS
137: where CONDITION_ID = X_CONDITION_ID;
138: cursor CSR_IS_ATTRIBUTE_SEED
139: (
140: X_ATTRIBUTE_ID in VARCHAR2

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 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 420: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_CONDITIONS.'||X_CONDITION_KEY,lockhandle => lockHandle);

416: returnValue integer;
417:
418: begin
419:
420: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_CONDITIONS.'||X_CONDITION_KEY,lockhandle => lockHandle);
421: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0,release_on_commit => true);
422: if returnValue = 0 then
423: insert into AME_CONDITIONS
424: (

Line 423: insert into AME_CONDITIONS

419:
420: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_CONDITIONS.'||X_CONDITION_KEY,lockhandle => lockHandle);
421: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0,release_on_commit => true);
422: if returnValue = 0 then
423: insert into AME_CONDITIONS
424: (
425: CONDITION_ID,
426: CONDITION_KEY,
427: CONDITION_TYPE,

Line 443: ame_conditions_s.nextval,

439: START_DATE,
440: END_DATE,
441: OBJECT_VERSION_NUMBER
442: ) select
443: ame_conditions_s.nextval,
444: X_CONDITION_KEY,
445: X_CONDITION_TYPE,
446: X_ATTRIBUTE_ID,
447: X_PARAMETER_ONE,

Line 462: from AME_CONDITIONS

458: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
459: X_OBJECT_VERSION_NUMBER
460: from sys.dual
461: where not exists (select NULL
462: from AME_CONDITIONS
463: where CONDITION_KEY = X_CONDITION_KEY);
464: end if;
465: end INSERT_ROW;
466:

Line 489: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_CONDITIONS.'||X_CONDITION_ID,lockhandle => lockHandle);

485: lockHandle varchar2(500);
486: returnValue integer;
487: begin
488:
489: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_CONDITIONS.'||X_CONDITION_ID,lockhandle => lockHandle);
490: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0,release_on_commit => true);
491: insert into AME_CONDITIONS
492: (
493: CONDITION_ID,

Line 491: insert into AME_CONDITIONS

487: begin
488:
489: DBMS_LOCK.ALLOCATE_UNIQUE (lockname =>'AME_CONDITIONS.'||X_CONDITION_ID,lockhandle => lockHandle);
490: returnValue := DBMS_LOCK.REQUEST(lockhandle => lockHandle,timeout => 0,release_on_commit => true);
491: insert into AME_CONDITIONS
492: (
493: CONDITION_ID,
494: CONDITION_KEY,
495: CONDITION_TYPE,

Line 530: from AME_CONDITIONS

526: AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
527: X_OBJECT_VERSION_NUMBER
528: from sys.dual
529: where not exists (select NULL
530: from AME_CONDITIONS
531: where CONDITION_ID = X_CONDITION_ID);
532:
533: end INSERT_ROW_2;
534:

Line 539: delete from AME_CONDITIONS

535: procedure DELETE_ROW (
536: X_CONDITION_KEY in VARCHAR2
537: ) is
538: begin
539: delete from AME_CONDITIONS
540: where CONDITION_KEY = X_CONDITION_KEY;
541:
542: if (sql%notfound) then
543: raise no_data_found;

Line 568: X_EXISTING_CONDITION_KEY ame_conditions.condition_key%type:=null;

564: X_CONDITION_COUNT NUMBER:=0;
565: X_CONDITION_KEY2 VARCHAR2(100);
566: X_CUSTOM_DETECT BOOLEAN := false;
567: X_CREATED_BY NUMBER;
568: X_EXISTING_CONDITION_KEY ame_conditions.condition_key%type:=null;
569: X_LAST_UPDATED_BY NUMBER;
570: X_LAST_UPDATE_LOGIN NUMBER;
571: begin
572: X_AME_INSTALLATION_LEVEL := fnd_profile.value('AME_INSTALLATION_LEVEL');

Line 608: update AME_CONDITIONS

604: if AME_SEED_UTILITY.IS_SEED_USER(X_OWNER) and
605: (X_ATTRIBUTE_ID is not null) and
606: (X_CONDITION_ID_LOAD is not null) and
607: X_CUSTOM_DETECT then
608: update AME_CONDITIONS
609: set CONDITION_KEY = '@' || X_CONDITION_KEY
610: where CONDITION_KEY = X_CONDITION_KEY;
611: INSERT_ROW (
612: X_CONDITION_KEY,

Line 688: update AME_CONDITIONS

684: if (X_ATTRIBUTE_ID is not null) and
685: (X_CONDITION_COUNT > 0) and
686: (X_EXISTING_CONDITION_KEY is not null) and
687: (X_EXISTING_CONDITION_KEY <> X_CONDITION_KEY) then
688: update AME_CONDITIONS
689: set CONDITION_KEY = X_CONDITION_KEY
690: where CONDITION_KEY = X_EXISTING_CONDITION_KEY
691: and CONDITION_ID = X_CONDITION_ID;
692: end if;

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;

Line 705: END AME_CONDITIONS_API2;

701: sqlerrm);
702: raise;
703: end LOAD_ROW;
704: --
705: END AME_CONDITIONS_API2;