1: PACKAGE BODY AME_ATTRIBUTE_USAGES_API AS
2: /* $Header: ameauapi.pkb 120.3 2006/03/10 07:19:52 pvelugul noship $ */
3: X_AME_INSTALLATION_LEVEL varchar2(255);
4:
5: function CALCULATE_USE_COUNT
108: end if;
109: return(NEW_USE_COUNT);
110: exception
111: when others then
112: ame_util.runtimeException('ame_attribute_usages_api',
113: 'CALCULATE_USE_COUNT',
114: sqlcode,
115: sqlerrm);
116: raise;
156: end if;
157: return(true);
158: exception
159: when others then
160: ame_util.runtimeException('ame_attribute_usages_api',
161: 'IS_SEED_USG_RULE_MODIFIED',
162: sqlcode,
163: sqlerrm);
164: raise;
318: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
319: and APPLICATION_ID = X_APPLICATION_ID;
320: exception
321: when others then
322: ame_util.runtimeException('ame_attribute_usages_api',
323: 'RECTIFY_RULE_MOD_SEED_USAGE',
324: sqlcode,
325: sqlerrm);
326: raise;
353: when invalidIsStaticException then
354: errorCode := -20001;
355: errorMessage :=
356: 'OAM is attempting to upload an attribute usage that is neither static or dynamic. ';
357: ame_util.runtimeException(packageNameIn => 'ame_attribute_usages_api',
358: routineNameIn => 'validate_is_static',
359: exceptionNumberIn => errorCode,
360: exceptionStringIn => errorMessage);
361: raise_application_error(errorCode,
360: exceptionStringIn => errorMessage);
361: raise_application_error(errorCode,
362: errorMessage);
363: when others then
364: ame_util.runtimeException('ame_attribute_usages_api',
365: 'validate_is_static',
366: sqlcode,
367: sqlerrm);
368: raise;
386: when invalidRejectionException then
387: errorCode := -20001;
388: errorMessage :=
389: 'OAM is attempting to upload a REJECTION RESPONSE attribute with an invalid usage. ';
390: ame_util.runtimeException(packageNameIn => 'ame_attribute_usages_api',
391: routineNameIn => 'validate_rejection',
392: exceptionNumberIn => errorCode,
393: exceptionStringIn => errorMessage);
394: raise_application_error(errorCode,
393: exceptionStringIn => errorMessage);
394: raise_application_error(errorCode,
395: errorMessage);
396: when others then
397: ame_util.runtimeException('ame_attribute_usages_api',
398: 'validate_rejection',
399: sqlcode,
400: sqlerrm);
401: raise;
903: end if;
904: end;
905: exception
906: when others then
907: ame_util.runtimeException('ame_attribute_usages_api',
908: 'load_row',
909: sqlcode,
910: sqlerrm);
911: raise;
941: ,X_CUSTOM_MODE => X_CUSTOM_MODE
942: );
943: end if;
944: end LOAD_SEED_ROW;
945: END AME_ATTRIBUTE_USAGES_API;