226: --detect if ame full patch has been applied
227: X_AME_INSTALLATION_LEVEL:=fnd_profile.value('AME_INSTALLATION_LEVEL');
228: if X_AME_INSTALLATION_LEVEL is not null then
229: if (X_ATTRIBUTE_NAME in (
230: ame_util.transactionDateAttribute,
231: ame_util.transactionGroupAttribute,
232: ame_util.transactionOrgAttribute,
233: ame_util.transactionRequestorAttribute,
234: ame_util.transactionReqUserAttribute,
227: X_AME_INSTALLATION_LEVEL:=fnd_profile.value('AME_INSTALLATION_LEVEL');
228: if X_AME_INSTALLATION_LEVEL is not null then
229: if (X_ATTRIBUTE_NAME in (
230: ame_util.transactionDateAttribute,
231: ame_util.transactionGroupAttribute,
232: ame_util.transactionOrgAttribute,
233: ame_util.transactionRequestorAttribute,
234: ame_util.transactionReqUserAttribute,
235: ame_util.transactionSetOfBooksAttribute
228: if X_AME_INSTALLATION_LEVEL is not null then
229: if (X_ATTRIBUTE_NAME in (
230: ame_util.transactionDateAttribute,
231: ame_util.transactionGroupAttribute,
232: ame_util.transactionOrgAttribute,
233: ame_util.transactionRequestorAttribute,
234: ame_util.transactionReqUserAttribute,
235: ame_util.transactionSetOfBooksAttribute
236: ) and
229: if (X_ATTRIBUTE_NAME in (
230: ame_util.transactionDateAttribute,
231: ame_util.transactionGroupAttribute,
232: ame_util.transactionOrgAttribute,
233: ame_util.transactionRequestorAttribute,
234: ame_util.transactionReqUserAttribute,
235: ame_util.transactionSetOfBooksAttribute
236: ) and
237: X_ACTION_TYPE_NAME = 'MANDATORY_ATTRIBUTE') then
230: ame_util.transactionDateAttribute,
231: ame_util.transactionGroupAttribute,
232: ame_util.transactionOrgAttribute,
233: ame_util.transactionRequestorAttribute,
234: ame_util.transactionReqUserAttribute,
235: ame_util.transactionSetOfBooksAttribute
236: ) and
237: X_ACTION_TYPE_NAME = 'MANDATORY_ATTRIBUTE') then
238: return;
231: ame_util.transactionGroupAttribute,
232: ame_util.transactionOrgAttribute,
233: ame_util.transactionRequestorAttribute,
234: ame_util.transactionReqUserAttribute,
235: ame_util.transactionSetOfBooksAttribute
236: ) and
237: X_ACTION_TYPE_NAME = 'MANDATORY_ATTRIBUTE') then
238: return;
239: end if;
241: -- checking for EVALUATE_PRIORITIES_PER_LINE_ITEM
242: -- and USE_RESTRICTIVE_LINE_ITEM_EVALUATION attributes
243: -- being uploaded
244: --
245: if X_ATTRIBUTE_NAME = ame_util.evalPrioritiesPerLIAttribute
246: then X_LINE_ATTRIBUTE_NAME := ame_util.evalPrioritiesPerItemAttribute;
247: end if;
248: if X_ATTRIBUTE_NAME = ame_util.restrictiveLIEvalAttribute
249: then X_LINE_ATTRIBUTE_NAME := ame_util.restrictiveItemEvalAttribute;
242: -- and USE_RESTRICTIVE_LINE_ITEM_EVALUATION attributes
243: -- being uploaded
244: --
245: if X_ATTRIBUTE_NAME = ame_util.evalPrioritiesPerLIAttribute
246: then X_LINE_ATTRIBUTE_NAME := ame_util.evalPrioritiesPerItemAttribute;
247: end if;
248: if X_ATTRIBUTE_NAME = ame_util.restrictiveLIEvalAttribute
249: then X_LINE_ATTRIBUTE_NAME := ame_util.restrictiveItemEvalAttribute;
250: end if;
244: --
245: if X_ATTRIBUTE_NAME = ame_util.evalPrioritiesPerLIAttribute
246: then X_LINE_ATTRIBUTE_NAME := ame_util.evalPrioritiesPerItemAttribute;
247: end if;
248: if X_ATTRIBUTE_NAME = ame_util.restrictiveLIEvalAttribute
249: then X_LINE_ATTRIBUTE_NAME := ame_util.restrictiveItemEvalAttribute;
250: end if;
251: end if;
252:
245: if X_ATTRIBUTE_NAME = ame_util.evalPrioritiesPerLIAttribute
246: then X_LINE_ATTRIBUTE_NAME := ame_util.evalPrioritiesPerItemAttribute;
247: end if;
248: if X_ATTRIBUTE_NAME = ame_util.restrictiveLIEvalAttribute
249: then X_LINE_ATTRIBUTE_NAME := ame_util.restrictiveItemEvalAttribute;
250: end if;
251: end if;
252:
253: if X_AME_INSTALLATION_LEVEL is null then
250: end if;
251: end if;
252:
253: if X_AME_INSTALLATION_LEVEL is null then
254: if X_ATTRIBUTE_NAME in (ame_util.useWorkflowAttribute
255: ,ame_util.rejectionResponseAttribute
256: ,'REPEAT_SUBSTITUTIONS'
257: ,ame_util.nonDefStartingPointPosAttr
258: ,ame_util.nonDefPosStructureAttr
251: end if;
252:
253: if X_AME_INSTALLATION_LEVEL is null then
254: if X_ATTRIBUTE_NAME in (ame_util.useWorkflowAttribute
255: ,ame_util.rejectionResponseAttribute
256: ,'REPEAT_SUBSTITUTIONS'
257: ,ame_util.nonDefStartingPointPosAttr
258: ,ame_util.nonDefPosStructureAttr
259: ,ame_util.transactionReqPositionAttr
253: if X_AME_INSTALLATION_LEVEL is null then
254: if X_ATTRIBUTE_NAME in (ame_util.useWorkflowAttribute
255: ,ame_util.rejectionResponseAttribute
256: ,'REPEAT_SUBSTITUTIONS'
257: ,ame_util.nonDefStartingPointPosAttr
258: ,ame_util.nonDefPosStructureAttr
259: ,ame_util.transactionReqPositionAttr
260: ,ame_util.topPositionIdAttribute)then
261: return;
254: if X_ATTRIBUTE_NAME in (ame_util.useWorkflowAttribute
255: ,ame_util.rejectionResponseAttribute
256: ,'REPEAT_SUBSTITUTIONS'
257: ,ame_util.nonDefStartingPointPosAttr
258: ,ame_util.nonDefPosStructureAttr
259: ,ame_util.transactionReqPositionAttr
260: ,ame_util.topPositionIdAttribute)then
261: return;
262: end if;
255: ,ame_util.rejectionResponseAttribute
256: ,'REPEAT_SUBSTITUTIONS'
257: ,ame_util.nonDefStartingPointPosAttr
258: ,ame_util.nonDefPosStructureAttr
259: ,ame_util.transactionReqPositionAttr
260: ,ame_util.topPositionIdAttribute)then
261: return;
262: end if;
263: if (X_ATTRIBUTE_NAME in (
256: ,'REPEAT_SUBSTITUTIONS'
257: ,ame_util.nonDefStartingPointPosAttr
258: ,ame_util.nonDefPosStructureAttr
259: ,ame_util.transactionReqPositionAttr
260: ,ame_util.topPositionIdAttribute)then
261: return;
262: end if;
263: if (X_ATTRIBUTE_NAME in (
264: ame_util.transactionDateAttribute,
260: ,ame_util.topPositionIdAttribute)then
261: return;
262: end if;
263: if (X_ATTRIBUTE_NAME in (
264: ame_util.transactionDateAttribute,
265: ame_util.transactionGroupAttribute,
266: ame_util.transactionOrgAttribute,
267: ame_util.transactionRequestorAttribute,
268: ame_util.transactionReqUserAttribute,
261: return;
262: end if;
263: if (X_ATTRIBUTE_NAME in (
264: ame_util.transactionDateAttribute,
265: ame_util.transactionGroupAttribute,
266: ame_util.transactionOrgAttribute,
267: ame_util.transactionRequestorAttribute,
268: ame_util.transactionReqUserAttribute,
269: ame_util.transactionSetOfBooksAttribute
262: end if;
263: if (X_ATTRIBUTE_NAME in (
264: ame_util.transactionDateAttribute,
265: ame_util.transactionGroupAttribute,
266: ame_util.transactionOrgAttribute,
267: ame_util.transactionRequestorAttribute,
268: ame_util.transactionReqUserAttribute,
269: ame_util.transactionSetOfBooksAttribute
270: ) and
263: if (X_ATTRIBUTE_NAME in (
264: ame_util.transactionDateAttribute,
265: ame_util.transactionGroupAttribute,
266: ame_util.transactionOrgAttribute,
267: ame_util.transactionRequestorAttribute,
268: ame_util.transactionReqUserAttribute,
269: ame_util.transactionSetOfBooksAttribute
270: ) and
271: X_ACTION_TYPE_NAME <> 'MANDATORY_ATTRIBUTE') then
264: ame_util.transactionDateAttribute,
265: ame_util.transactionGroupAttribute,
266: ame_util.transactionOrgAttribute,
267: ame_util.transactionRequestorAttribute,
268: ame_util.transactionReqUserAttribute,
269: ame_util.transactionSetOfBooksAttribute
270: ) and
271: X_ACTION_TYPE_NAME <> 'MANDATORY_ATTRIBUTE') then
272: return;
265: ame_util.transactionGroupAttribute,
266: ame_util.transactionOrgAttribute,
267: ame_util.transactionRequestorAttribute,
268: ame_util.transactionReqUserAttribute,
269: ame_util.transactionSetOfBooksAttribute
270: ) and
271: X_ACTION_TYPE_NAME <> 'MANDATORY_ATTRIBUTE') then
272: return;
273: end if;
274: -- checking for EVALUATE_PRIORITIES_PER_ITEM
275: -- and USE_RESTRICTIVE_ITEM_EVALUATION attributes
276: -- being uploaded
277: --
278: if X_ATTRIBUTE_NAME = ame_util.evalPrioritiesPerItemAttribute
279: then X_LINE_ATTRIBUTE_NAME := ame_util.evalPrioritiesPerLIAttribute;
280: end if;
281: if X_ATTRIBUTE_NAME = ame_util.restrictiveItemEvalAttribute
282: then X_LINE_ATTRIBUTE_NAME := ame_util.restrictiveLIEvalAttribute;
275: -- and USE_RESTRICTIVE_ITEM_EVALUATION attributes
276: -- being uploaded
277: --
278: if X_ATTRIBUTE_NAME = ame_util.evalPrioritiesPerItemAttribute
279: then X_LINE_ATTRIBUTE_NAME := ame_util.evalPrioritiesPerLIAttribute;
280: end if;
281: if X_ATTRIBUTE_NAME = ame_util.restrictiveItemEvalAttribute
282: then X_LINE_ATTRIBUTE_NAME := ame_util.restrictiveLIEvalAttribute;
283: end if;
277: --
278: if X_ATTRIBUTE_NAME = ame_util.evalPrioritiesPerItemAttribute
279: then X_LINE_ATTRIBUTE_NAME := ame_util.evalPrioritiesPerLIAttribute;
280: end if;
281: if X_ATTRIBUTE_NAME = ame_util.restrictiveItemEvalAttribute
282: then X_LINE_ATTRIBUTE_NAME := ame_util.restrictiveLIEvalAttribute;
283: end if;
284: end if;
285: -- retrieve information for the current row
278: if X_ATTRIBUTE_NAME = ame_util.evalPrioritiesPerItemAttribute
279: then X_LINE_ATTRIBUTE_NAME := ame_util.evalPrioritiesPerLIAttribute;
280: end if;
281: if X_ATTRIBUTE_NAME = ame_util.restrictiveItemEvalAttribute
282: then X_LINE_ATTRIBUTE_NAME := ame_util.restrictiveLIEvalAttribute;
283: end if;
284: end if;
285: -- retrieve information for the current row
286: KEY_TO_IDS (
355: end if;
356:
357: exception
358: when others then
359: ame_util.runtimeException('ame_mandatory_attributes_api',
360: 'load_row',
361: sqlcode,
362: sqlerrm);
363: raise;