1: package body ame_test_utility_pkg as
2: /* $Header: ametestutility.pkb 120.7 2011/05/17 11:41:53 nchinnam noship $ */
3: --+
4: function isValidApprover(attributeIdIn in number
5: ,attributeValueIn in varchar2)
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 || ' ';
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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||
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
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)
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
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:
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
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;