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.7 2011/05/18 11:27:40 nchinnam ship $ */
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 464: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1807: ame_condition_pkg.getDescription(condition_id) description

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

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

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

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

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

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

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

Line 1911: ame_condition_pkg.getDescription(condition_id) description

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2611: end ame_condition_pkg;

2607: ') ' ||
2608: sqlerrm);
2609: raise;
2610: end removeStringValue;
2611: end ame_condition_pkg;