DBA Data[Home] [Help]

APPS.AME_RULES_API2 dependencies on AME_UTIL

Line 166: errorMessage ame_util.longestStringType;

162: and sysdate between aat.start_date and
163: nvl(aat.end_date - (1/86400),sysdate);
164: X_RULE_KEY_CHECK NUMBER;
165: errorCode integer;
166: errorMessage ame_util.longestStringType;
167: begin
168: if X_AME_INSTALLATION_LEVEL is null then
169: X_EXISTING_RULE_KEY:= null;
170: X_ITEM_CLASS_ID:= null;

Line 214: ame_util.runtimeException(packageNameIn => 'ame_rules_api2',

210: exception
211: when duplicateRuleKeyException then
212: errorCode := -20001;
213: errorMessage := 'OAM is attempting to upload a duplicate rule key. ';
214: ame_util.runtimeException(packageNameIn => 'ame_rules_api2',
215: routineNameIn => 'key_to_ids_2',
216: exceptionNumberIn => errorCode,
217: exceptionStringIn => errorMessage);
218: raise;

Line 220: ame_util.runtimeException('ame_rules_api2',

216: exceptionNumberIn => errorCode,
217: exceptionStringIn => errorMessage);
218: raise;
219: when others then
220: ame_util.runtimeException('ame_rules_api2',
221: 'key_to_ids_2',
222: sqlcode,
223: sqlerrm);
224: raise;

Line 232: errorMessage ame_util.longestStringType;

228: X_RULE_TYPE in NUMBER
229: ) is
230: invalidRuleTypeException exception;
231: errorCode integer;
232: errorMessage ame_util.longestStringType;
233: begin
234: X_AME_INSTALLATION_LEVEL:= fnd_profile.value('AME_INSTALLATION_LEVEL');
235: if X_AME_INSTALLATION_LEVEL is null then
236: if (X_RULE_TYPE not in (ame_util.authorityRuleType

Line 236: if (X_RULE_TYPE not in (ame_util.authorityRuleType

232: errorMessage ame_util.longestStringType;
233: begin
234: X_AME_INSTALLATION_LEVEL:= fnd_profile.value('AME_INSTALLATION_LEVEL');
235: if X_AME_INSTALLATION_LEVEL is null then
236: if (X_RULE_TYPE not in (ame_util.authorityRuleType
237: ,ame_util.exceptionRuleType
238: ,ame_util.preListGroupRuleType
239: ,ame_util.postListGroupRuleType
240: )) then

Line 237: ,ame_util.exceptionRuleType

233: begin
234: X_AME_INSTALLATION_LEVEL:= fnd_profile.value('AME_INSTALLATION_LEVEL');
235: if X_AME_INSTALLATION_LEVEL is null then
236: if (X_RULE_TYPE not in (ame_util.authorityRuleType
237: ,ame_util.exceptionRuleType
238: ,ame_util.preListGroupRuleType
239: ,ame_util.postListGroupRuleType
240: )) then
241: raise invalidRuleTypeException;

Line 238: ,ame_util.preListGroupRuleType

234: X_AME_INSTALLATION_LEVEL:= fnd_profile.value('AME_INSTALLATION_LEVEL');
235: if X_AME_INSTALLATION_LEVEL is null then
236: if (X_RULE_TYPE not in (ame_util.authorityRuleType
237: ,ame_util.exceptionRuleType
238: ,ame_util.preListGroupRuleType
239: ,ame_util.postListGroupRuleType
240: )) then
241: raise invalidRuleTypeException;
242: end if;

Line 239: ,ame_util.postListGroupRuleType

235: if X_AME_INSTALLATION_LEVEL is null then
236: if (X_RULE_TYPE not in (ame_util.authorityRuleType
237: ,ame_util.exceptionRuleType
238: ,ame_util.preListGroupRuleType
239: ,ame_util.postListGroupRuleType
240: )) then
241: raise invalidRuleTypeException;
242: end if;
243: else

Line 244: if (X_RULE_TYPE not in (ame_util.authorityRuleType

240: )) then
241: raise invalidRuleTypeException;
242: end if;
243: else
244: if (X_RULE_TYPE not in (ame_util.authorityRuleType
245: ,ame_util.exceptionRuleType
246: ,ame_util.preListGroupRuleType
247: ,ame_util.postListGroupRuleType
248: ,ame_util.productionRuleType

Line 245: ,ame_util.exceptionRuleType

241: raise invalidRuleTypeException;
242: end if;
243: else
244: if (X_RULE_TYPE not in (ame_util.authorityRuleType
245: ,ame_util.exceptionRuleType
246: ,ame_util.preListGroupRuleType
247: ,ame_util.postListGroupRuleType
248: ,ame_util.productionRuleType
249: )) then

Line 246: ,ame_util.preListGroupRuleType

242: end if;
243: else
244: if (X_RULE_TYPE not in (ame_util.authorityRuleType
245: ,ame_util.exceptionRuleType
246: ,ame_util.preListGroupRuleType
247: ,ame_util.postListGroupRuleType
248: ,ame_util.productionRuleType
249: )) then
250: raise invalidRuleTypeException;

Line 247: ,ame_util.postListGroupRuleType

243: else
244: if (X_RULE_TYPE not in (ame_util.authorityRuleType
245: ,ame_util.exceptionRuleType
246: ,ame_util.preListGroupRuleType
247: ,ame_util.postListGroupRuleType
248: ,ame_util.productionRuleType
249: )) then
250: raise invalidRuleTypeException;
251: end if;

Line 248: ,ame_util.productionRuleType

244: if (X_RULE_TYPE not in (ame_util.authorityRuleType
245: ,ame_util.exceptionRuleType
246: ,ame_util.preListGroupRuleType
247: ,ame_util.postListGroupRuleType
248: ,ame_util.productionRuleType
249: )) then
250: raise invalidRuleTypeException;
251: end if;
252: end if;

Line 257: ame_util.runtimeException(packageNameIn => 'ame_rules_api2',

253: exception
254: when invalidRuleTypeException then
255: errorCode := -20001;
256: errorMessage := 'OAM is attempting to upload an invalid rule type. ';
257: ame_util.runtimeException(packageNameIn => 'ame_rules_api2',
258: routineNameIn => 'validate_rule_type',
259: exceptionNumberIn => errorCode,
260: exceptionStringIn => errorMessage);
261: raise_application_error(errorCode,

Line 264: ame_util.runtimeException('ame_rules_api2',

260: exceptionStringIn => errorMessage);
261: raise_application_error(errorCode,
262: errorMessage);
263: when others then
264: ame_util.runtimeException('ame_rules_api2',
265: 'validate_rule_type',
266: sqlcode,
267: sqlerrm);
268: raise;

Line 504: ame_util.headerItemClassName,

500: --to header or lineitem item class
501: if X_AME_INSTALLATION_LEVEL is null then
502: if X_ITEM_CLASS_NAME is not null
503: and X_ITEM_CLASS_NAME not in(
504: ame_util.headerItemClassName,
505: ame_util.lineItemItemClassName
506: ) then
507: return;
508: elsif X_ACTION_TYPE_NAME in ('pre-chain-of-authority approvals',

Line 505: ame_util.lineItemItemClassName

501: if X_AME_INSTALLATION_LEVEL is null then
502: if X_ITEM_CLASS_NAME is not null
503: and X_ITEM_CLASS_NAME not in(
504: ame_util.headerItemClassName,
505: ame_util.lineItemItemClassName
506: ) then
507: return;
508: elsif X_ACTION_TYPE_NAME in ('pre-chain-of-authority approvals',
509: 'post-chain-of-authority approvals',

Line 627: ame_util.runtimeException('ame_rules_api2',

623: exception
624: when duplicateRuleKeyException then
625: null;
626: when others then
627: ame_util.runtimeException('ame_rules_api2',
628: 'load_row',
629: sqlcode,
630: sqlerrm);
631: raise;