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_CONDITION_PKG dependencies on AME_CONDITION_PKG

Line 1: package body ame_condition_pkg as

1: package body ame_condition_pkg as
2: /* $Header: ameocond.pkb 120.4 2006/12/26 13:19:15 avarri noship $ */
3: function getAttributeId(conditionIdIn in integer) return integer as
4: attributeId integer;
5: begin

Line 17: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

13: return(attributeId);
14: exception
15: when others then
16: rollback;
17: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
18: routineNameIn => 'getAttributeId',
19: exceptionNumberIn => sqlcode,
20: exceptionStringIn => '(condition ID ' ||
21: conditionIdIn||

Line 46: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

42: return(attributeName);
43: exception
44: when others then
45: rollback;
46: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
47: routineNameIn => 'getAttributeName',
48: exceptionNumberIn => sqlcode,
49: exceptionStringIn => '(condition ID ' ||
50: conditionIdIn||

Line 75: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

71: return(attributeType);
72: exception
73: when others then
74: rollback;
75: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
76: routineNameIn => 'getAttributeType',
77: exceptionNumberIn => sqlcode,
78: exceptionStringIn => '(condition ID ' ||
79: conditionIdIn||

Line 100: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

96: return(conditionType);
97: exception
98: when others then
99: rollback;
100: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
101: routineNameIn => 'getConditionType',
102: exceptionNumberIn => sqlcode,
103: exceptionStringIn => '(condition ID ' ||
104: conditionIdIn||

Line 137: ame_util.runtimeException(packageNamein => 'ame_condition_pkg',

133: return(conditionKey);
134: exception
135: when others then
136: rollback;
137: ame_util.runtimeException(packageNamein => 'ame_condition_pkg',
138: routineNamein => 'getConditionKey',
139: exceptionNumberIn => sqlcode,
140: exceptionStringIn => '(condition ID ' ||
141: conditionIdIn||

Line 163: ame_util.runtimeException(packageNamein => 'ame_condition_pkg',

159: end if;
160: exception
161: when others then
162: rollback;
163: ame_util.runtimeException(packageNamein => 'ame_condition_pkg',
164: routineNamein => 'conditionKeyExists',
165: exceptionNumberIn => sqlcode,
166: exceptionStringIn => '(condition Key ' ||
167: conditionKeyIn ||

Line 213: ame_util.runtimeException(packageNamein => 'ame_condition_pkg',

209: return(newConditionKey);
210: exception
211: when others then
212: rollback;
213: ame_util.runtimeException(packageNamein => 'ame_condition_pkg',
214: routineNamein => 'getNextConditionKey',
215: exceptionNumberIn => sqlcode,
216: exceptionStringIn => '(condition Key ' ||
217: newConditionKey ||

Line 261: ame_condition_pkg.getParameterOne(conditionIdIn => conditionIdIn);

257: begin
258: conditionType := getConditionType(conditionIdIn => conditionIdIn);
259: if(conditionType = ame_util.listModConditionType) then
260: approverType :=
261: ame_condition_pkg.getParameterOne(conditionIdIn => conditionIdIn);
262: approverName :=
263: ame_condition_pkg.getParameterTwo(conditionIdIn => conditionIdIn);
264: approverDescription :=
265: ame_approver_type_pkg.getApproverDescription(nameIn => approverName);

Line 263: ame_condition_pkg.getParameterTwo(conditionIdIn => conditionIdIn);

259: if(conditionType = ame_util.listModConditionType) then
260: approverType :=
261: ame_condition_pkg.getParameterOne(conditionIdIn => conditionIdIn);
262: approverName :=
263: ame_condition_pkg.getParameterTwo(conditionIdIn => conditionIdIn);
264: approverDescription :=
265: ame_approver_type_pkg.getApproverDescription(nameIn => approverName);
266: if(approverType = ame_util.finalApprover) then
267: return(ame_util.getLabel(ame_util.perFndAppId,'AME_FINAL_APPROVER_IS') ||' '|| approverDescription);

Line 461: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

457: return(description);
458: exception
459: when others then
460: rollback;
461: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
462: routineNameIn => 'getDescription',
463: exceptionNumberIn => sqlcode,
464: exceptionStringIn => '(condition ID ' ||
465: conditionIdIn ||

Line 485: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

481: return(includeLowerLimit);
482: exception
483: when others then
484: rollback;
485: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
486: routineNameIn => 'getIncludeLowerLimit',
487: exceptionNumberIn => sqlcode,
488: exceptionStringIn => '(condition ID ' ||
489: conditionIdIn||

Line 509: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

505: return(includeUpperLimit);
506: exception
507: when others then
508: rollback;
509: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
510: routineNameIn => 'getIncludeUpperLimit',
511: exceptionNumberIn => sqlcode,
512: exceptionStringIn => '(condition ID ' ||
513: conditionIdIn||

Line 544: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

540: rollback;
541: return(false);
542: when others then
543: rollback;
544: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
545: routineNameIn => 'isStringAttributeType',
546: exceptionNumberIn => sqlcode,
547: exceptionStringIn => '(condition ID ' ||
548: conditionIdIn||

Line 568: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

564: return(parameterOne);
565: exception
566: when others then
567: rollback;
568: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
569: routineNameIn => 'getParameterOne',
570: exceptionNumberIn => sqlcode,
571: exceptionStringIn => '(condition ID ' ||
572: conditionIdIn||

Line 592: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

588: return(parameterTwo);
589: exception
590: when others then
591: rollback;
592: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
593: routineNameIn => 'getParameterTwo',
594: exceptionNumberIn => sqlcode,
595: exceptionStringIn => '(condition ID ' ||
596: conditionIdIn||

Line 616: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

612: return(parameterThree);
613: exception
614: when others then
615: rollback;
616: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
617: routineNameIn => 'getParameterThree',
618: exceptionNumberIn => sqlcode,
619: exceptionStringIn => '(condition ID ' ||
620: conditionIdIn||

Line 640: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

636: return(startDate);
637: exception
638: when others then
639: rollback;
640: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
641: routineNameIn => 'getStartDate',
642: exceptionNumberIn => sqlcode,
643: exceptionStringIn => '(condition ID ' ||
644: conditionIdIn||

Line 664: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

660: return(conditionType);
661: exception
662: when others then
663: rollback;
664: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
665: routineNameIn => 'getType',
666: exceptionNumberIn => sqlcode,
667: exceptionStringIn => '(condition ID ' ||
668: conditionIdIn||

Line 690: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

686: return(stringStartDate);
687: exception
688: when others then
689: rollback;
690: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
691: routineNameIn => 'getVersionStartDate',
692: exceptionNumberIn => sqlcode,
693: exceptionStringIn => '(condition ID ' ||
694: conditionIdIn||

Line 722: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

718: return(false);
719: exception
720: when others then
721: rollback;
722: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
723: routineNameIn => 'isConditionUsage',
724: exceptionNumberIn => sqlcode,
725: exceptionStringIn => '(condition ID ' ||
726: conditionIdIn||

Line 762: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

758: return(false);
759: exception
760: when others then
761: rollback;
762: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
763: routineNameIn => 'isInUseByOtherApps',
764: exceptionNumberIn => sqlcode,
765: exceptionStringIn => '(condition ID ' ||
766: conditionIdIn||

Line 791: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

787: return(false);
788: exception
789: when others then
790: rollback;
791: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
792: routineNameIn => 'isInUse',
793: exceptionNumberIn => sqlcode,
794: exceptionStringIn => '(condition ID ' ||
795: conditionIdIn||

Line 833: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

829: return(false);
830: exception
831: when others then
832: rollback;
833: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
834: routineNameIn => 'lineItemIsInUse',
835: exceptionNumberIn => sqlcode,
836: exceptionStringIn => sqlerrm);
837: raise;

Line 1100: ame_util.runtimeException(packageNamein => 'ame_condition_pkg',

1096: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1097: messageNameIn => 'AME_400362_COND_KEY_LONG',
1098: tokenNameOneIn => 'COLUMN_LENGTH',
1099: tokenValueOneIn => 100);
1100: ame_util.runtimeException(packageNamein => 'ame_condition_pkg',
1101: routineNamein => 'new',
1102: exceptionNumberIn => errorCode,
1103: exceptionStringIn => errorMessage);
1104: raise_application_error(errorCode,

Line 1113: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1109: errorCode := -20001;
1110: errorMessage :=
1111: ame_util.getMessage(applicationShortNameIn => 'PER',
1112: messageNameIn => 'AME_400182_CON_STR_VAL_COMMA');
1113: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1114: routineNameIn => 'new',
1115: exceptionNumberIn => errorCode,
1116: exceptionStringIn => errorMessage);
1117: raise_application_error(errorCode,

Line 1126: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1122: errorCode := -20001;
1123: errorMessage :=
1124: ame_util.getMessage(applicationShortNameIn => 'PER',
1125: messageNameIn => 'AME_400183_CON_ALRDY_EXISTS');
1126: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1127: routineNameIn => 'new',
1128: exceptionNumberIn => errorCode,
1129: exceptionStringIn => errorMessage);
1130: raise_application_error(errorCode,

Line 1141: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1137: messageNameIn => 'AME_400184_CON_LWR_LMT_LONG',
1138: tokenNameOneIn => 'COLUMN_LENGTH',
1139: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_conditions',
1140: columnNameIn => 'parameter_one'));
1141: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1142: routineNameIn => 'new',
1143: exceptionNumberIn => errorCode,
1144: exceptionStringIn => errorMessage);
1145: raise_application_error(errorCode,

Line 1157: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1153: messageNameIn => 'AME_400185_CON_UPP_LMT_LONG',
1154: tokenNameOneIn => 'COLUMN_LENGTH',
1155: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_conditions',
1156: columnNameIn => 'parameter_two'));
1157: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1158: routineNameIn => 'new',
1159: exceptionNumberIn => errorCode,
1160: exceptionStringIn => errorMessage);
1161: raise_application_error(errorCode,

Line 1173: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1169: messageNameIn => 'AME_400185_CON_UPP_LMT_LONG',
1170: tokenNameOneIn => 'COLUMN_LENGTH',
1171: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_conditions',
1172: columnNameIn => 'parameter_three'));
1173: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1174: routineNameIn => 'new',
1175: exceptionNumberIn => errorCode,
1176: exceptionStringIn => errorMessage);
1177: raise_application_error(errorCode,

Line 1189: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1185: messageNameIn => 'AME_400184_CON_LWR_LMT_LONG',
1186: tokenNameOneIn => 'COLUMN_LENGTH',
1187: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_conditions',
1188: columnNameIn => 'include_lower_limit'));
1189: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1190: routineNameIn => 'new',
1191: exceptionNumberIn => errorCode,
1192: exceptionStringIn => errorMessage);
1193: raise_application_error(errorCode,

Line 1205: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1201: messageNameIn => 'AME_400185_CON_UPP_LMT_LONG',
1202: tokenNameOneIn => 'COLUMN_LENGTH',
1203: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_conditions',
1204: columnNameIn => 'include_upper_limit'));
1205: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1206: routineNameIn => 'new',
1207: exceptionNumberIn => errorCode,
1208: exceptionStringIn => errorMessage);
1209: raise_application_error(errorCode,

Line 1218: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1214: errorCode := -20001;
1215: errorMessage :=
1216: ame_util.getMessage(applicationShortNameIn => 'PER',
1217: messageNameIn => 'AME_400186_CON_START_LESS_END');
1218: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1219: routineNameIn => 'new',
1220: exceptionNumberIn => errorCode,
1221: exceptionStringIn => errorMessage);
1222: raise_application_error(errorCode,

Line 1231: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1227: errorCode := -20001;
1228: errorMessage :=
1229: ame_util.getMessage(applicationShortNameIn => 'PER',
1230: messageNameIn => 'AME_400187_CON_LWR_LESS_UPP');
1231: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1232: routineNameIn => 'new',
1233: exceptionNumberIn => errorCode,
1234: exceptionStringIn => errorMessage);
1235: raise_application_error(errorCode,

Line 1244: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1240: errorCode := -20001;
1241: errorMessage :=
1242: ame_util.getMessage(applicationShortNameIn => 'PER',
1243: messageNameIn => 'AME_400188_CON_LMT_VAL_YES');
1244: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1245: routineNameIn => 'new',
1246: exceptionNumberIn => errorCode,
1247: exceptionStringIn => errorMessage);
1248: raise_application_error(errorCode,

Line 1253: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1249: errorMessage);
1250: return(null);
1251: when others then
1252: rollback;
1253: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1254: routineNameIn => 'new',
1255: exceptionNumberIn => sqlcode,
1256: exceptionStringIn => '(condition ID ' ||
1257: conditionIdIn||

Line 1333: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1329: errorCode := -20001;
1330: errorMessage :=
1331: ame_util.getMessage(applicationShortNameIn => 'PER',
1332: messageNameIn => 'AME_400189_CON_RULE_USES');
1333: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1334: routineNameIn => 'newConditionUsage',
1335: exceptionNumberIn => errorCode,
1336: exceptionStringIn => errorMessage);
1337: raise_application_error(errorCode,

Line 1342: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1338: errorMessage);
1339: return(false);
1340: when others then
1341: rollback;
1342: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1343: routineNameIn => 'newConditionUsage',
1344: exceptionNumberIn => sqlcode,
1345: exceptionStringIn => '(condition ID ' ||
1346: conditionIdIn||

Line 1413: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1409: messageNameIn => 'AME_400190_CON_STR_VAL_LONG',
1410: tokenNameOneIn => 'COLUMN_LENGTH',
1411: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_string_values',
1412: columnNameIn => 'string_value'));
1413: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1414: routineNameIn => 'newStringValue',
1415: exceptionNumberIn => errorCode,
1416: exceptionStringIn => errorMessage);
1417: raise_application_error(errorCode,

Line 1422: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1418: errorMessage);
1419: return(false);
1420: when others then
1421: rollback;
1422: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1423: routineNameIn => 'newStringValue',
1424: exceptionNumberIn => sqlcode,
1425: exceptionStringIn => '(condition ID ' ||
1426: conditionIdIn||

Line 1608: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1604: errorCode := -20001;
1605: errorMessage :=
1606: ame_util.getMessage(applicationShortNameIn => 'PER',
1607: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
1608: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1609: routineNameIn => 'change',
1610: exceptionNumberIn => errorCode,
1611: exceptionStringIn => errorMessage);
1612: raise_application_error(errorCode,

Line 1623: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1619: errorCode := -20001;
1620: errorMessage :=
1621: ame_util.getMessage(applicationShortNameIn => 'PER',
1622: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
1623: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1624: routineNameIn => 'change',
1625: exceptionNumberIn => errorCode,
1626: exceptionStringIn => errorMessage);
1627: raise_application_error(errorCode,

Line 1635: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1631: errorCode := -20001;
1632: errorMessage :=
1633: ame_util.getMessage(applicationShortNameIn => 'PER',
1634: messageNameIn => 'AME_400191_CON_EXISTS_NEW');
1635: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1636: routineNameIn => 'change',
1637: exceptionNumberIn => errorCode,
1638: exceptionStringIn => errorMessage);
1639: raise_application_error(errorCode,

Line 1646: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1642: rollback;
1643: if(startDateCursor%isOpen) then
1644: close startDateCursor;
1645: end if;
1646: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1647: routineNameIn => 'change',
1648: exceptionNumberIn => sqlcode,
1649: exceptionStringIn => '(condition ID ' ||
1650: conditionIdIn||

Line 1691: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1687: nvl(end_date - ame_util.oneSecond, sysdate) ;
1688: exception
1689: when others then
1690: rollback;
1691: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1692: routineNameIn => 'getAllProperties',
1693: exceptionNumberIn => sqlcode,
1694: exceptionStringIn => '(condition ID ' ||
1695: conditionIdIn||

Line 1770: conditionDescriptionsOut(tempOutputIndex) := ame_condition_pkg.getDescription(conditionId);

1766: conditionTypesOut(tempOutputIndex) := conditionType;
1767: attributeIdsOut(tempOutputIndex) := to_char(attributeId);
1768: attributeNamesOut(tempOutputIndex) := attributeName;
1769: attributeTypesOut(tempOutputIndex) := attributeType;
1770: conditionDescriptionsOut(tempOutputIndex) := ame_condition_pkg.getDescription(conditionId);
1771: tempOutputIndex := tempOutputIndex + 1;
1772: end loop;
1773: close conditionCursor;
1774: exception

Line 1779: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1775: when others then
1776: if conditionCursor%isopen then
1777: close conditionCursor;
1778: end if;
1779: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1780: routineNameIn => 'getAuthPreConditions',
1781: exceptionNumberIn => sqlcode,
1782: exceptionStringIn => '(application ID ' ||
1783: applicationIdIn||

Line 1804: ame_condition_pkg.getDescription(condition_id) description

1800: conditionTypeIn in varchar2,
1801: lineItemIn in varchar2) is
1802: select
1803: condition_id id,
1804: ame_condition_pkg.getDescription(condition_id) description
1805: from ame_conditions,
1806: ame_attributes
1807: where
1808: ame_conditions.attribute_id = ame_attributes.attribute_id and

Line 1835: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1831: end loop;
1832: exception
1833: when others then
1834: rollback;
1835: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1836: routineNameIn => 'getAttributesConditions',
1837: exceptionNumberIn => sqlcode,
1838: exceptionStringIn => sqlerrm);
1839: conditionIdsOut := ame_util.emptyStringList;

Line 1854: ame_condition_pkg.getDescription(ame_conditions.condition_id) description

1850: conditionTypeIn in varchar2,
1851: itemClassIdIn in integer) is
1852: select
1853: ame_conditions.condition_id id,
1854: ame_condition_pkg.getDescription(ame_conditions.condition_id) description
1855: from ame_conditions,
1856: ame_attributes
1857: where
1858: ame_conditions.attribute_id = ame_attributes.attribute_id and

Line 1888: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1884: end loop;
1885: exception
1886: when others then
1887: rollback;
1888: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1889: routineNameIn => 'getAttributesConditions1',
1890: exceptionNumberIn => sqlcode,
1891: exceptionStringIn => sqlerrm);
1892: conditionIdsOut := ame_util.emptyStringList;

Line 1908: ame_condition_pkg.getDescription(condition_id) description

1904: lineItemIn in varchar2,
1905: itemClassIdIn in integer) is
1906: select
1907: condition_id id,
1908: ame_condition_pkg.getDescription(condition_id) description
1909: from ame_conditions,
1910: ame_attributes
1911: where
1912: ame_conditions.attribute_id = ame_attributes.attribute_id and

Line 1941: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1937: end loop;
1938: exception
1939: when others then
1940: rollback;
1941: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1942: routineNameIn => 'getAttributesConditions2',
1943: exceptionNumberIn => sqlcode,
1944: exceptionStringIn => sqlerrm);
1945: conditionIdsOut := ame_util.emptyStringList;

Line 1996: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

1992: end loop;
1993: exception
1994: when others then
1995: rollback;
1996: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1997: routineNameIn => 'getApplicationsUsingCondition',
1998: exceptionNumberIn => sqlcode,
1999: exceptionStringIn => '(condition ID ' ||
2000: conditionIdIn||

Line 2017: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

2013: end loop;
2014: exception
2015: when others then
2016: rollback;
2017: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
2018: routineNameIn => 'getDescriptions',
2019: exceptionNumberIn => sqlcode,
2020: exceptionStringIn => sqlerrm);
2021: descriptionsOut := ame_util.emptyLongStringList;

Line 2031: if ame_condition_pkg.getConditionType(conditionIdIn => conditionIdsIn(i)) = ame_util.listModConditionType then

2027: conditionIdCount integer;
2028: begin
2029: conditionIdCount := conditionIdsIn.count;
2030: for i in 1..conditionIdCount loop
2031: if ame_condition_pkg.getConditionType(conditionIdIn => conditionIdsIn(i)) = ame_util.listModConditionType then
2032: detailUrlsOut(i) := null;
2033: else
2034: if ame_condition_pkg.getAttributeType(conditionIdIn => conditionIdsIn(i)) = ame_util.stringAttributeType then
2035: detailUrlsOut(i) := (ame_util.getPlsqlDadPath ||

Line 2034: if ame_condition_pkg.getAttributeType(conditionIdIn => conditionIdsIn(i)) = ame_util.stringAttributeType then

2030: for i in 1..conditionIdCount loop
2031: if ame_condition_pkg.getConditionType(conditionIdIn => conditionIdsIn(i)) = ame_util.listModConditionType then
2032: detailUrlsOut(i) := null;
2033: else
2034: if ame_condition_pkg.getAttributeType(conditionIdIn => conditionIdsIn(i)) = ame_util.stringAttributeType then
2035: detailUrlsOut(i) := (ame_util.getPlsqlDadPath ||
2036: 'ame_conditions_ui.getDetails?conditionIdIn=' ||
2037: conditionIdsIn(i) ||
2038: '&applicationIdIn=' ||

Line 2048: ame_util.runtimeException(packageNamein => 'ame_condition_pkg',

2044: end loop;
2045: exception
2046: when others then
2047: rollback;
2048: ame_util.runtimeException(packageNamein => 'ame_condition_pkg',
2049: routineNamein => 'getDetailUrls',
2050: exceptionNumberIn => sqlcode,
2051: exceptionStringIn => sqlerrm);
2052: detailUrlsOut := ame_util.emptyLongStringList;

Line 2080: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

2076: end loop;
2077: exception
2078: when others then
2079: rollback;
2080: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
2081: routineNameIn => 'getLMConditions',
2082: exceptionNumberIn => sqlcode,
2083: exceptionStringIn => sqlerrm);
2084: conditionIdOut := ame_util.emptyIdList;

Line 2125: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

2121: end loop;
2122: exception
2123: when others then
2124: rollback;
2125: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
2126: routineNameIn => 'getLMDescriptions',
2127: exceptionNumberIn => sqlcode,
2128: exceptionStringIn => sqlerrm);
2129: conditionIdsOut := ame_util.emptyStringList;

Line 2171: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

2167: end loop;
2168: exception
2169: when others then
2170: rollback;
2171: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
2172: routineNameIn => 'getLMDescriptions2',
2173: exceptionNumberIn => sqlcode,
2174: exceptionStringIn => sqlerrm);
2175: conditionIdsOut := ame_util.emptyStringList;

Line 2218: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

2214: end loop;
2215: exception
2216: when others then
2217: rollback;
2218: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
2219: routineNameIn => 'getLMDescriptions3',
2220: exceptionNumberIn => sqlcode,
2221: exceptionStringIn => sqlerrm);
2222: conditionIdsOut := ame_util.emptyStringList;

Line 2255: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

2251: errorCode := -20001;
2252: errorMessage :=
2253: ame_util.getMessage(applicationShortNameIn => 'PER',
2254: messageNameIn => 'AME_400192_CON_STR_VAL_NOT_DEF');
2255: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
2256: routineNameIn => 'getStringValueList',
2257: exceptionNumberIn => errorCode,
2258: exceptionStringIn => errorMessage);
2259: stringValueListOut := ame_util.emptyLongestStringList;

Line 2264: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

2260: raise_application_error(errorCode,
2261: errorMessage);
2262: when others then
2263: rollback;
2264: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
2265: routineNameIn => 'getStringValueList',
2266: exceptionNumberIn => sqlcode,
2267: exceptionStringIn => '(condition ID ' ||
2268: conditionIdIn||

Line 2309: conditionType := ame_condition_pkg.getType(conditionIdIn => conditionIdIn);

2305: if(isInUse(conditionIdIn)) then
2306: raise inUseException;
2307: end if;
2308: currentUserId := ame_util.getCurrentUserId;
2309: conditionType := ame_condition_pkg.getType(conditionIdIn => conditionIdIn);
2310: if versionStartDateIn = startDate then
2311: if conditionType <> ame_util.listModConditionType then
2312: attributeType := ame_condition_pkg.getAttributeType(conditionIdIn => conditionIdIn);
2313: if(attributeType = ame_util.stringAttributeType) then

Line 2312: attributeType := ame_condition_pkg.getAttributeType(conditionIdIn => conditionIdIn);

2308: currentUserId := ame_util.getCurrentUserId;
2309: conditionType := ame_condition_pkg.getType(conditionIdIn => conditionIdIn);
2310: if versionStartDateIn = startDate then
2311: if conditionType <> ame_util.listModConditionType then
2312: attributeType := ame_condition_pkg.getAttributeType(conditionIdIn => conditionIdIn);
2313: if(attributeType = ame_util.stringAttributeType) then
2314: update ame_string_values
2315: set
2316: last_updated_by = currentUserId,

Line 2352: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

2348: errorCode := -20001;
2349: errorMessage :=
2350: ame_util.getMessage(applicationShortNameIn => 'PER',
2351: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
2352: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
2353: routineNameIn => 'remove',
2354: exceptionNumberIn => errorCode,
2355: exceptionStringIn => errorMessage);
2356: raise_application_error(errorCode,

Line 2367: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

2363: errorCode := -20001;
2364: errorMessage :=
2365: ame_util.getMessage(applicationShortNameIn => 'PER',
2366: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
2367: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
2368: routineNameIn => 'remove',
2369: exceptionNumberIn => errorCode,
2370: exceptionStringIn => errorMessage);
2371: raise_application_error(errorCode,

Line 2379: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

2375: errorCode := -20001;
2376: errorMessage :=
2377: ame_util.getMessage(applicationShortNameIn => 'PER',
2378: messageNameIn => 'AME_400193_CON_IN USE');
2379: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
2380: routineNameIn => 'remove',
2381: exceptionNumberIn => errorCode,
2382: exceptionStringIn => errorMessage);
2383: raise_application_error(errorCode,

Line 2390: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

2386: rollback;
2387: if(startDateCursor%isOpen) then
2388: close startDateCursor;
2389: end if;
2390: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
2391: routineNameIn => 'remove',
2392: exceptionNumberIn => sqlcode,
2393: exceptionStringIn => '(condition ID ' ||
2394: conditionIdIn||

Line 2459: ame_util.runtimeException(packageNamein => 'ame_condition_pkg',

2455: errorCode := -20001;
2456: errorMessage :=
2457: ame_util.getMessage(applicationShortNameIn => 'PER',
2458: messageNameIn => 'AME_400212_RUL_PROP_EXISTS');
2459: ame_util.runtimeException(packageNamein => 'ame_condition_pkg',
2460: routineNamein => 'removeConditionUsage',
2461: exceptionNumberIn => errorCode,
2462: exceptionStringIn => errorMessage);
2463: raise_application_error(errorCode,

Line 2467: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

2463: raise_application_error(errorCode,
2464: errorMessage);
2465: when others then
2466: rollback;
2467: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
2468: routineNameIn => 'removeConditionUsage',
2469: exceptionNumberIn => sqlcode,
2470: exceptionStringIn => '(condition ID ' ||
2471: conditionIdIn||

Line 2531: conditionType := ame_condition_pkg.getType(conditionIdIn => conditionIdIn);

2527: string_value = stringValueListIn(i) and
2528: processingDate between start_date and
2529: nvl(end_date - ame_util.oneSecond, processingDate) ;
2530: end loop;
2531: conditionType := ame_condition_pkg.getType(conditionIdIn => conditionIdIn);
2532: conditionKey := ame_condition_pkg.getConditionKey(conditionIdIn => conditionIdIn);
2533: attributeId := ame_condition_pkg.getAttributeId(conditionIdIn => conditionIdIn);
2534: parameterOne := ame_condition_pkg.getParameterOne(conditionIdIn => conditionIdIn);
2535: parameterTwo := ame_condition_pkg.getParameterTwo(conditionIdIn => conditionIdIn);

Line 2532: conditionKey := ame_condition_pkg.getConditionKey(conditionIdIn => conditionIdIn);

2528: processingDate between start_date and
2529: nvl(end_date - ame_util.oneSecond, processingDate) ;
2530: end loop;
2531: conditionType := ame_condition_pkg.getType(conditionIdIn => conditionIdIn);
2532: conditionKey := ame_condition_pkg.getConditionKey(conditionIdIn => conditionIdIn);
2533: attributeId := ame_condition_pkg.getAttributeId(conditionIdIn => conditionIdIn);
2534: parameterOne := ame_condition_pkg.getParameterOne(conditionIdIn => conditionIdIn);
2535: parameterTwo := ame_condition_pkg.getParameterTwo(conditionIdIn => conditionIdIn);
2536: parameterThree := ame_condition_pkg.getParameterThree(conditionIdIn => conditionIdIn);

Line 2533: attributeId := ame_condition_pkg.getAttributeId(conditionIdIn => conditionIdIn);

2529: nvl(end_date - ame_util.oneSecond, processingDate) ;
2530: end loop;
2531: conditionType := ame_condition_pkg.getType(conditionIdIn => conditionIdIn);
2532: conditionKey := ame_condition_pkg.getConditionKey(conditionIdIn => conditionIdIn);
2533: attributeId := ame_condition_pkg.getAttributeId(conditionIdIn => conditionIdIn);
2534: parameterOne := ame_condition_pkg.getParameterOne(conditionIdIn => conditionIdIn);
2535: parameterTwo := ame_condition_pkg.getParameterTwo(conditionIdIn => conditionIdIn);
2536: parameterThree := ame_condition_pkg.getParameterThree(conditionIdIn => conditionIdIn);
2537: includeLowerLimit := ame_condition_pkg.getIncludeLowerLimit(conditionIdIn => conditionIdIn);

Line 2534: parameterOne := ame_condition_pkg.getParameterOne(conditionIdIn => conditionIdIn);

2530: end loop;
2531: conditionType := ame_condition_pkg.getType(conditionIdIn => conditionIdIn);
2532: conditionKey := ame_condition_pkg.getConditionKey(conditionIdIn => conditionIdIn);
2533: attributeId := ame_condition_pkg.getAttributeId(conditionIdIn => conditionIdIn);
2534: parameterOne := ame_condition_pkg.getParameterOne(conditionIdIn => conditionIdIn);
2535: parameterTwo := ame_condition_pkg.getParameterTwo(conditionIdIn => conditionIdIn);
2536: parameterThree := ame_condition_pkg.getParameterThree(conditionIdIn => conditionIdIn);
2537: includeLowerLimit := ame_condition_pkg.getIncludeLowerLimit(conditionIdIn => conditionIdIn);
2538: includeUpperLimit := ame_condition_pkg.getIncludeUpperLimit(conditionIdIn => conditionIdIn);

Line 2535: parameterTwo := ame_condition_pkg.getParameterTwo(conditionIdIn => conditionIdIn);

2531: conditionType := ame_condition_pkg.getType(conditionIdIn => conditionIdIn);
2532: conditionKey := ame_condition_pkg.getConditionKey(conditionIdIn => conditionIdIn);
2533: attributeId := ame_condition_pkg.getAttributeId(conditionIdIn => conditionIdIn);
2534: parameterOne := ame_condition_pkg.getParameterOne(conditionIdIn => conditionIdIn);
2535: parameterTwo := ame_condition_pkg.getParameterTwo(conditionIdIn => conditionIdIn);
2536: parameterThree := ame_condition_pkg.getParameterThree(conditionIdIn => conditionIdIn);
2537: includeLowerLimit := ame_condition_pkg.getIncludeLowerLimit(conditionIdIn => conditionIdIn);
2538: includeUpperLimit := ame_condition_pkg.getIncludeUpperLimit(conditionIdIn => conditionIdIn);
2539: update ame_conditions

Line 2536: parameterThree := ame_condition_pkg.getParameterThree(conditionIdIn => conditionIdIn);

2532: conditionKey := ame_condition_pkg.getConditionKey(conditionIdIn => conditionIdIn);
2533: attributeId := ame_condition_pkg.getAttributeId(conditionIdIn => conditionIdIn);
2534: parameterOne := ame_condition_pkg.getParameterOne(conditionIdIn => conditionIdIn);
2535: parameterTwo := ame_condition_pkg.getParameterTwo(conditionIdIn => conditionIdIn);
2536: parameterThree := ame_condition_pkg.getParameterThree(conditionIdIn => conditionIdIn);
2537: includeLowerLimit := ame_condition_pkg.getIncludeLowerLimit(conditionIdIn => conditionIdIn);
2538: includeUpperLimit := ame_condition_pkg.getIncludeUpperLimit(conditionIdIn => conditionIdIn);
2539: update ame_conditions
2540: set

Line 2537: includeLowerLimit := ame_condition_pkg.getIncludeLowerLimit(conditionIdIn => conditionIdIn);

2533: attributeId := ame_condition_pkg.getAttributeId(conditionIdIn => conditionIdIn);
2534: parameterOne := ame_condition_pkg.getParameterOne(conditionIdIn => conditionIdIn);
2535: parameterTwo := ame_condition_pkg.getParameterTwo(conditionIdIn => conditionIdIn);
2536: parameterThree := ame_condition_pkg.getParameterThree(conditionIdIn => conditionIdIn);
2537: includeLowerLimit := ame_condition_pkg.getIncludeLowerLimit(conditionIdIn => conditionIdIn);
2538: includeUpperLimit := ame_condition_pkg.getIncludeUpperLimit(conditionIdIn => conditionIdIn);
2539: update ame_conditions
2540: set
2541: last_updated_by = currentUserId,

Line 2538: includeUpperLimit := ame_condition_pkg.getIncludeUpperLimit(conditionIdIn => conditionIdIn);

2534: parameterOne := ame_condition_pkg.getParameterOne(conditionIdIn => conditionIdIn);
2535: parameterTwo := ame_condition_pkg.getParameterTwo(conditionIdIn => conditionIdIn);
2536: parameterThree := ame_condition_pkg.getParameterThree(conditionIdIn => conditionIdIn);
2537: includeLowerLimit := ame_condition_pkg.getIncludeLowerLimit(conditionIdIn => conditionIdIn);
2538: includeUpperLimit := ame_condition_pkg.getIncludeUpperLimit(conditionIdIn => conditionIdIn);
2539: update ame_conditions
2540: set
2541: last_updated_by = currentUserId,
2542: last_update_date = processingDate,

Line 2573: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

2569: errorCode := -20001;
2570: errorMessage :=
2571: ame_util.getMessage(applicationShortNameIn => 'PER',
2572: messageNameIn => 'AME_400143_ACT_OBJECT_CHNGED');
2573: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
2574: routineNameIn => 'removeStringValue',
2575: exceptionNumberIn => errorCode,
2576: exceptionStringIn => errorMessage);
2577: raise_application_error(errorCode,

Line 2588: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

2584: errorCode := -20001;
2585: errorMessage :=
2586: ame_util.getMessage(applicationShortNameIn => 'PER',
2587: messageNameIn => 'AME_400145_ACT_OBJECT_DELETED');
2588: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
2589: routineNameIn => 'removeStringValue',
2590: exceptionNumberIn => errorCode,
2591: exceptionStringIn => errorMessage);
2592: raise_application_error(errorCode,

Line 2599: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

2595: rollback;
2596: if(startDateCursor%isOpen) then
2597: close startDateCursor;
2598: end if;
2599: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
2600: routineNameIn => 'removeStringValue',
2601: exceptionNumberIn => sqlcode,
2602: exceptionStringIn => '(condition ID ' ||
2603: conditionIdIn||

Line 2608: end ame_condition_pkg;

2604: ') ' ||
2605: sqlerrm);
2606: raise;
2607: end removeStringValue;
2608: end ame_condition_pkg;