DBA Data[Home] [Help]

APPS.AME_TEST_UTILITY_PKG dependencies on AME_TEST_UTILITY_PKG

Line 1: package body ame_test_utility_pkg as

1: package body ame_test_utility_pkg as
2: /* $Header: ametestutility.pkb 120.4.12010000.2 2008/08/05 05:15:44 ubhat ship $ */
3: --+
4: function isValidApprover(attributeIdIn in number
5: ,attributeValueIn in varchar2)

Line 22: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',

18: end if;
19: return '';
20: exception
21: when others then
22: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',
23: routineNameIn => 'isValidApprover',
24: exceptionNumberIn => sqlcode,
25: exceptionStringIn => sqlerrm);
26: return sqlerrm || ' ';

Line 44: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',

40: and nvl(end_date - ame_util.oneSecond, sysdate);
41: return actionTypeName;
42: exception
43: when others then
44: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',
45: routineNameIn => 'getActionTypeName',
46: exceptionNumberIn => sqlcode,
47: exceptionStringIn => sqlerrm);
48: raise;

Line 63: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',

59: and sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate);
60: return actionTypeName;
61: exception
62: when others then
63: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',
64: routineNameIn => 'getApproverGroupName',
65: exceptionNumberIn => sqlcode,
66: exceptionStringIn => sqlerrm);
67: raise;

Line 77: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',

73: begin
74: return statusIn;
75: exception
76: when others then
77: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',
78: routineNameIn => 'getApprovalStatusDesc',
79: exceptionNumberIn => sqlcode,
80: exceptionStringIn => sqlerrm);
81: raise;

Line 101: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',

97: exception
98: when no_data_found then
99: return null;
100: when others then
101: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',
102: routineNameIn => 'getApprovalCategoryDesc',
103: exceptionNumberIn => sqlcode,
104: exceptionStringIn => sqlerrm);
105: raise;

Line 123: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',

119: and nvl(end_date_active, trunc(sysdate));
120: return(authorityDesc);
121: exception
122: when others then
123: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',
124: routineNameIn => 'getAuthorityDesc',
125: exceptionNumberIn => sqlcode,
126: exceptionStringIn => sqlerrm);
127: raise;

Line 137: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',

133: begin
134: return apiInsertionIn;
135: exception
136: when others then
137: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',
138: routineNameIn => 'getApiInsertionDesc',
139: exceptionNumberIn => sqlcode,
140: exceptionStringIn => sqlerrm);
141: raise;

Line 158: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',

154: and nvl(end_date_active, trunc(sysdate));
155: return origSystemDesc;
156: exception
157: when others then
158: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',
159: routineNameIn => 'getOrigSystemDesc',
160: exceptionNumberIn => sqlcode,
161: exceptionStringIn => sqlerrm);
162: raise;

Line 180: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',

176: and nvl(end_date_active, trunc(sysdate));
177: return ruleTypeDesc;
178: exception
179: when others then
180: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',
181: routineNameIn => 'getRuleTypeDesc',
182: exceptionNumberIn => sqlcode,
183: exceptionStringIn => sqlerrm);
184: raise;

Line 202: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',

198: and nvl(end_date - ame_util.oneSecond, sysdate);
199: return getApprovalCategoryDesc(ruleTypeCode);
200: exception
201: when others then
202: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',
203: routineNameIn => 'getRuleType',
204: exceptionNumberIn => sqlcode,
205: exceptionStringIn => sqlerrm);
206: raise;

Line 231: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',

227: end;
228: return getApprovalCategoryDesc(categoryCode);
229: exception
230: when others then
231: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',
232: routineNameIn => 'getRuleCategory',
233: exceptionNumberIn => sqlcode,
234: exceptionStringIn => sqlerrm);
235: raise;

Line 266: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',

262: end loop;
263: return conditionsList;
264: exception
265: when others then
266: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',
267: routineNameIn => 'getConditionsList',
268: exceptionNumberIn => sqlcode,
269: exceptionStringIn => sqlerrm);
270: raise;

Line 287: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',

283: return(itemName);
284: exception
285: when others then
286: rollback;
287: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',
288: routineNameIn => 'getItemClassNameById',
289: exceptionNumberIn => sqlcode,
290: exceptionStringIn => sqlerrm);
291: raise;

Line 307: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',

303: nvl(end_date - ame_util.oneSecond, sysdate) ;
304: return(itemName);
305: exception
306: when others then
307: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',
308: routineNameIn => 'getItemClassName',
309: exceptionNumberIn => sqlcode,
310: exceptionStringIn => sqlerrm);
311: raise;

Line 342: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',

338: end loop;
339: return actionsList;
340: exception
341: when others then
342: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',
343: routineNameIn => 'getActionsList',
344: exceptionNumberIn => sqlcode,
345: exceptionStringIn => sqlerrm);
346: raise;

Line 362: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',

358: and nvl(end_date - ame_util.oneSecond, sysdate);
359: return ruleDesc;
360: exception
361: when others then
362: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',
363: routineNameIn => 'getRuleDescription',
364: exceptionNumberIn => sqlcode,
365: exceptionStringIn => sqlerrm);
366: raise;

Line 387: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',

383: end loop;
384: return sourceDesc;
385: exception
386: when others then
387: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',
388: routineNameIn => 'getSourceDesc',
389: exceptionNumberIn => sqlcode,
390: exceptionStringIn => sqlerrm);
391: raise;

Line 418: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',

414: end if;
415: return retValue;
416: exception
417: When others then
418: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',
419: routineNameIn => 'isAttributesExist',
420: exceptionNumberIn => sqlcode,
421: exceptionStringIn => sqlerrm);
422: raise;

Line 621: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',

617: end loop;
618: exception
619: when others then
620: rollback;
621: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',
622: routineNameIn => 'getNonMandAttributes',
623: exceptionNumberIn => sqlcode,
624: exceptionStringIn => '(application ID ' ||
625: applicationIdIn||

Line 987: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',

983: return;
984: end if;
985: exception
986: When others then
987: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',
988: routineNameIn => 'populateRealTransAttributes',
989: exceptionNumberIn => sqlcode,
990: exceptionStringIn => sqlerrm);
991: if sqlcode = -20001 then

Line 1051: itemClassName := ame_test_utility_pkg.getItemClassNameById(ruleItemClassIds(i));

1047: ,ruleDescriptionsOut => ruleDescriptions);
1048:
1049: for i in 1 .. itemIds.count loop
1050: if(ruleItemClassIds(i) is not null) then
1051: itemClassName := ame_test_utility_pkg.getItemClassNameById(ruleItemClassIds(i));
1052: else
1053: itemClassName := null;
1054: end if;
1055: ruleObject := ame_rule(ruleIds(i)

Line 1080: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',

1076: end loop;
1077: rulesOut := rulesList;
1078: exception
1079: When others then
1080: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',
1081: routineNameIn => 'getApplicableRules',
1082: exceptionNumberIn => sqlcode,
1083: exceptionStringIn => sqlerrm);
1084: if sqlcode = -20001 then

Line 1200: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',

1196: end loop;
1197: approversOut := approverObjList;
1198: exception
1199: When others then
1200: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',
1201: routineNameIn => 'getApprovers',
1202: exceptionNumberIn => sqlcode,
1203: exceptionStringIn => sqlerrm);
1204:

Line 1262: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',

1258:
1259: end loop;
1260: exception
1261: When others then
1262: ame_util.runtimeException(packageNameIn => 'ame_test_utility_pkg',
1263: routineNameIn => 'getTransactionProductions',
1264: exceptionNumberIn => sqlcode,
1265: exceptionStringIn => sqlerrm);
1266: if sqlcode = -20001 then

Line 1274: end ame_test_utility_pkg;

1270: fnd_message.set_name('PER','AME_400692_ENGINE_ERROR');
1271: errString := fnd_message.get;
1272: end if;
1273: end getTransactionProductions;
1274: end ame_test_utility_pkg;