3469: */
3470: if(engProcessPriorities) then
3471: processRelativePriorities;
3472: end if;
3473: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
3474: if engAppRuleIds.count = 0 then
3475: fnd_log.string
3476: (fnd_log.level_statement
3477: ,'ame_engine.evaluateRules'
3471: processRelativePriorities;
3472: end if;
3473: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
3474: if engAppRuleIds.count = 0 then
3475: fnd_log.string
3476: (fnd_log.level_statement
3477: ,'ame_engine.evaluateRules'
3478: ,'*********** No Rules Applicable ************'
3479: );
3472: end if;
3473: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
3474: if engAppRuleIds.count = 0 then
3475: fnd_log.string
3476: (fnd_log.level_statement
3477: ,'ame_engine.evaluateRules'
3478: ,'*********** No Rules Applicable ************'
3479: );
3480: else
3478: ,'*********** No Rules Applicable ************'
3479: );
3480: else
3481: for i in 1 .. engAppRuleIds.count loop
3482: fnd_log.string
3483: (fnd_log.level_statement
3484: ,'ame_engine.evaluateRules'
3485: ,'Applicable Rule ::: ' || engAppRuleIds(i)
3486: );
3479: );
3480: else
3481: for i in 1 .. engAppRuleIds.count loop
3482: fnd_log.string
3483: (fnd_log.level_statement
3484: ,'ame_engine.evaluateRules'
3485: ,'Applicable Rule ::: ' || engAppRuleIds(i)
3486: );
3487: end loop;
4107: engAttributeVariant(tempAttributeId) := ame_util.booleanTrue;
4108: engAttributeQueries(tempAttributeId) := queryStrings(i);
4109: end if;
4110: end if;
4111: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4112: fnd_log.string
4113: (fnd_log.level_statement
4114: ,'ame_engine.fetchAttributeValues'
4115: ,'Attribute ::: ' || engAttributeNames(tempAttributeId) || '(' || tempAttributeId || ')'
4108: engAttributeQueries(tempAttributeId) := queryStrings(i);
4109: end if;
4110: end if;
4111: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4112: fnd_log.string
4113: (fnd_log.level_statement
4114: ,'ame_engine.fetchAttributeValues'
4115: ,'Attribute ::: ' || engAttributeNames(tempAttributeId) || '(' || tempAttributeId || ')'
4116: );
4109: end if;
4110: end if;
4111: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4112: fnd_log.string
4113: (fnd_log.level_statement
4114: ,'ame_engine.fetchAttributeValues'
4115: ,'Attribute ::: ' || engAttributeNames(tempAttributeId) || '(' || tempAttributeId || ')'
4116: );
4117: end if;
4158: else
4159: engAttributeValues2(tempAttributeValueIndex) := null;
4160: engAttributeValues3(tempAttributeValueIndex) := null;
4161: end if;
4162: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4163: fnd_log.string
4164: (fnd_log.level_statement
4165: ,'ame_engine.fetchAttributeValues'
4166: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4159: engAttributeValues2(tempAttributeValueIndex) := null;
4160: engAttributeValues3(tempAttributeValueIndex) := null;
4161: end if;
4162: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4163: fnd_log.string
4164: (fnd_log.level_statement
4165: ,'ame_engine.fetchAttributeValues'
4166: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4167: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4160: engAttributeValues3(tempAttributeValueIndex) := null;
4161: end if;
4162: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4163: fnd_log.string
4164: (fnd_log.level_statement
4165: ,'ame_engine.fetchAttributeValues'
4166: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4167: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4168: );
4173: tempAttributeValueIndex := tempAttributeValueIndex + 1;
4174: engAttributeValues1(tempAttributeValueIndex) := null;
4175: engAttributeValues2(tempAttributeValueIndex) := null;
4176: engAttributeValues3(tempAttributeValueIndex) := null;
4177: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4178: fnd_log.string
4179: (fnd_log.level_statement
4180: ,'ame_engine.fetchAttributeValues'
4181: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4174: engAttributeValues1(tempAttributeValueIndex) := null;
4175: engAttributeValues2(tempAttributeValueIndex) := null;
4176: engAttributeValues3(tempAttributeValueIndex) := null;
4177: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4178: fnd_log.string
4179: (fnd_log.level_statement
4180: ,'ame_engine.fetchAttributeValues'
4181: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4182: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4175: engAttributeValues2(tempAttributeValueIndex) := null;
4176: engAttributeValues3(tempAttributeValueIndex) := null;
4177: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4178: fnd_log.string
4179: (fnd_log.level_statement
4180: ,'ame_engine.fetchAttributeValues'
4181: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4182: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4183: );
4207: tempAttributeValueIndex := tempAttributeValueIndex + 1;
4208: engAttributeValues1(tempAttributeValueIndex) := tempAttributeValue1;
4209: engAttributeValues2(tempAttributeValueIndex) := tempAttributeValue2;
4210: engAttributeValues3(tempAttributeValueIndex) := tempAttributeValue3;
4211: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4212: fnd_log.string
4213: (fnd_log.level_statement
4214: ,'ame_engine.fetchAttributeValues'
4215: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4208: engAttributeValues1(tempAttributeValueIndex) := tempAttributeValue1;
4209: engAttributeValues2(tempAttributeValueIndex) := tempAttributeValue2;
4210: engAttributeValues3(tempAttributeValueIndex) := tempAttributeValue3;
4211: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4212: fnd_log.string
4213: (fnd_log.level_statement
4214: ,'ame_engine.fetchAttributeValues'
4215: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4216: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4209: engAttributeValues2(tempAttributeValueIndex) := tempAttributeValue2;
4210: engAttributeValues3(tempAttributeValueIndex) := tempAttributeValue3;
4211: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4212: fnd_log.string
4213: (fnd_log.level_statement
4214: ,'ame_engine.fetchAttributeValues'
4215: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4216: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4217: );
4297: else
4298: engAttributeValues2(tempAttributeValueIndex) := null;
4299: engAttributeValues3(tempAttributeValueIndex) := null;
4300: end if;
4301: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4302: fnd_log.string
4303: (fnd_log.level_statement
4304: ,'ame_engine.fetchAttributeValues'
4305: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4298: engAttributeValues2(tempAttributeValueIndex) := null;
4299: engAttributeValues3(tempAttributeValueIndex) := null;
4300: end if;
4301: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4302: fnd_log.string
4303: (fnd_log.level_statement
4304: ,'ame_engine.fetchAttributeValues'
4305: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4306: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4299: engAttributeValues3(tempAttributeValueIndex) := null;
4300: end if;
4301: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4302: fnd_log.string
4303: (fnd_log.level_statement
4304: ,'ame_engine.fetchAttributeValues'
4305: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4306: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4307: );
4325: if(testTransNonCurrencyCursor%isopen) then
4326: close testTransNonCurrencyCursor;
4327: end if;
4328: tempAttributeName := ame_attribute_pkg.getName(attributeIdIn => tempAttributeId);
4329: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4330: fnd_log.string
4331: (fnd_log.level_statement
4332: ,'ame_engine.fetchAttributeValues'
4333: ,'Attribute ::: ' || tempAttributeName || '(' || tempAttributeId || ')'||
4326: close testTransNonCurrencyCursor;
4327: end if;
4328: tempAttributeName := ame_attribute_pkg.getName(attributeIdIn => tempAttributeId);
4329: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4330: fnd_log.string
4331: (fnd_log.level_statement
4332: ,'ame_engine.fetchAttributeValues'
4333: ,'Attribute ::: ' || tempAttributeName || '(' || tempAttributeId || ')'||
4334: 'attribute returned ::'||tempAttributeValues1.count||'rows but the number of items for the '||
4327: end if;
4328: tempAttributeName := ame_attribute_pkg.getName(attributeIdIn => tempAttributeId);
4329: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4330: fnd_log.string
4331: (fnd_log.level_statement
4332: ,'ame_engine.fetchAttributeValues'
4333: ,'Attribute ::: ' || tempAttributeName || '(' || tempAttributeId || ')'||
4334: 'attribute returned ::'||tempAttributeValues1.count||'rows but the number of items for the '||
4335: 'itemclass ::'||engItemCounts(tempItemClassIndex)
4361: close testTransNonCurrencyCursor;
4362: end if;
4363: tempAttributeName := ame_attribute_pkg.getName(attributeIdIn => tempAttributeId);
4364: errorMessage := sqlerrm;
4365: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4366: fnd_log.string
4367: (fnd_log.level_statement
4368: ,'ame_engine.fetchAttributeValues'
4369: ,'Attribute ::: ' || tempAttributeName || '(' || tempAttributeId || '),error:'||errorMessage
4362: end if;
4363: tempAttributeName := ame_attribute_pkg.getName(attributeIdIn => tempAttributeId);
4364: errorMessage := sqlerrm;
4365: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4366: fnd_log.string
4367: (fnd_log.level_statement
4368: ,'ame_engine.fetchAttributeValues'
4369: ,'Attribute ::: ' || tempAttributeName || '(' || tempAttributeId || '),error:'||errorMessage
4370: );
4363: tempAttributeName := ame_attribute_pkg.getName(attributeIdIn => tempAttributeId);
4364: errorMessage := sqlerrm;
4365: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4366: fnd_log.string
4367: (fnd_log.level_statement
4368: ,'ame_engine.fetchAttributeValues'
4369: ,'Attribute ::: ' || tempAttributeName || '(' || tempAttributeId || '),error:'||errorMessage
4370: );
4371: end if;
4567: engAttributeVariant(tempAttributeId) := ame_util.booleanTrue;
4568: engAttributeQueries(tempAttributeId) := queryStrings(i);
4569: end if;
4570: end if;
4571: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4572: fnd_log.string
4573: (fnd_log.level_statement
4574: ,'ame_engine.fetchOtherAttributeValues'
4575: ,'Attribute ::: ' || engAttributeNames(tempAttributeId) || '(' || tempAttributeId || ')'
4568: engAttributeQueries(tempAttributeId) := queryStrings(i);
4569: end if;
4570: end if;
4571: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4572: fnd_log.string
4573: (fnd_log.level_statement
4574: ,'ame_engine.fetchOtherAttributeValues'
4575: ,'Attribute ::: ' || engAttributeNames(tempAttributeId) || '(' || tempAttributeId || ')'
4576: );
4569: end if;
4570: end if;
4571: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4572: fnd_log.string
4573: (fnd_log.level_statement
4574: ,'ame_engine.fetchOtherAttributeValues'
4575: ,'Attribute ::: ' || engAttributeNames(tempAttributeId) || '(' || tempAttributeId || ')'
4576: );
4577: end if;
4618: else
4619: engAttributeValues2(tempAttributeValueIndex) := null;
4620: engAttributeValues3(tempAttributeValueIndex) := null;
4621: end if;
4622: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4623: fnd_log.string
4624: (fnd_log.level_statement
4625: ,'ame_engine.fetchOtherAttributeValues'
4626: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4619: engAttributeValues2(tempAttributeValueIndex) := null;
4620: engAttributeValues3(tempAttributeValueIndex) := null;
4621: end if;
4622: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4623: fnd_log.string
4624: (fnd_log.level_statement
4625: ,'ame_engine.fetchOtherAttributeValues'
4626: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4627: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4620: engAttributeValues3(tempAttributeValueIndex) := null;
4621: end if;
4622: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4623: fnd_log.string
4624: (fnd_log.level_statement
4625: ,'ame_engine.fetchOtherAttributeValues'
4626: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4627: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4628: );
4633: tempAttributeValueIndex := tempAttributeValueIndex + 1;
4634: engAttributeValues1(tempAttributeValueIndex) := null;
4635: engAttributeValues2(tempAttributeValueIndex) := null;
4636: engAttributeValues3(tempAttributeValueIndex) := null;
4637: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4638: fnd_log.string
4639: (fnd_log.level_statement
4640: ,'ame_engine.fetchOtherAttributeValues'
4641: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4634: engAttributeValues1(tempAttributeValueIndex) := null;
4635: engAttributeValues2(tempAttributeValueIndex) := null;
4636: engAttributeValues3(tempAttributeValueIndex) := null;
4637: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4638: fnd_log.string
4639: (fnd_log.level_statement
4640: ,'ame_engine.fetchOtherAttributeValues'
4641: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4642: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4635: engAttributeValues2(tempAttributeValueIndex) := null;
4636: engAttributeValues3(tempAttributeValueIndex) := null;
4637: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4638: fnd_log.string
4639: (fnd_log.level_statement
4640: ,'ame_engine.fetchOtherAttributeValues'
4641: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4642: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4643: );
4667: tempAttributeValueIndex := tempAttributeValueIndex + 1;
4668: engAttributeValues1(tempAttributeValueIndex) := tempAttributeValue1;
4669: engAttributeValues2(tempAttributeValueIndex) := tempAttributeValue2;
4670: engAttributeValues3(tempAttributeValueIndex) := tempAttributeValue3;
4671: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4672: fnd_log.string
4673: (fnd_log.level_statement
4674: ,'ame_engine.fetchOtherAttributeValues'
4675: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4668: engAttributeValues1(tempAttributeValueIndex) := tempAttributeValue1;
4669: engAttributeValues2(tempAttributeValueIndex) := tempAttributeValue2;
4670: engAttributeValues3(tempAttributeValueIndex) := tempAttributeValue3;
4671: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4672: fnd_log.string
4673: (fnd_log.level_statement
4674: ,'ame_engine.fetchOtherAttributeValues'
4675: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4676: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4669: engAttributeValues2(tempAttributeValueIndex) := tempAttributeValue2;
4670: engAttributeValues3(tempAttributeValueIndex) := tempAttributeValue3;
4671: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4672: fnd_log.string
4673: (fnd_log.level_statement
4674: ,'ame_engine.fetchOtherAttributeValues'
4675: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4676: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4677: );
4757: else
4758: engAttributeValues2(tempAttributeValueIndex) := null;
4759: engAttributeValues3(tempAttributeValueIndex) := null;
4760: end if;
4761: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4762: fnd_log.string
4763: (fnd_log.level_statement
4764: ,'ame_engine.fetchOtherAttributeValues'
4765: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4758: engAttributeValues2(tempAttributeValueIndex) := null;
4759: engAttributeValues3(tempAttributeValueIndex) := null;
4760: end if;
4761: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4762: fnd_log.string
4763: (fnd_log.level_statement
4764: ,'ame_engine.fetchOtherAttributeValues'
4765: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4766: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4759: engAttributeValues3(tempAttributeValueIndex) := null;
4760: end if;
4761: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4762: fnd_log.string
4763: (fnd_log.level_statement
4764: ,'ame_engine.fetchOtherAttributeValues'
4765: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4766: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4767: );
5233: engItemClassItemIdIndexes(i) := null;
5234: end if;
5235: end if;
5236: end if;
5237: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
5238: fnd_log.string
5239: (fnd_log.level_statement
5240: ,'ame_engine.fetchItemClassData'
5241: ,'Item Class ::' || engItemClassNames(i) ||
5234: end if;
5235: end if;
5236: end if;
5237: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
5238: fnd_log.string
5239: (fnd_log.level_statement
5240: ,'ame_engine.fetchItemClassData'
5241: ,'Item Class ::' || engItemClassNames(i) ||
5242: ':' || 'has ' || ':' || engItemCounts(i) || ':items'
5235: end if;
5236: end if;
5237: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
5238: fnd_log.string
5239: (fnd_log.level_statement
5240: ,'ame_engine.fetchItemClassData'
5241: ,'Item Class ::' || engItemClassNames(i) ||
5242: ':' || 'has ' || ':' || engItemCounts(i) || ':items'
5243: );
5467: l_name_out varchar2(400);
5468: l_display_name_out varchar2(500);
5469: l_appr_type varchar2(100);
5470: begin
5471: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
5472: fnd_log.string
5473: (fnd_log.level_statement
5474: ,'ame_engine.fetchRuntimeGroup'
5475: ,'evaluating the group::'||ame_approval_group_pkg.getName(approvalGroupIdIn => groupIdIn
5468: l_display_name_out varchar2(500);
5469: l_appr_type varchar2(100);
5470: begin
5471: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
5472: fnd_log.string
5473: (fnd_log.level_statement
5474: ,'ame_engine.fetchRuntimeGroup'
5475: ,'evaluating the group::'||ame_approval_group_pkg.getName(approvalGroupIdIn => groupIdIn
5476: ,effectiveDateIn => engEffectiveRuleDate)
5469: l_appr_type varchar2(100);
5470: begin
5471: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
5472: fnd_log.string
5473: (fnd_log.level_statement
5474: ,'ame_engine.fetchRuntimeGroup'
5475: ,'evaluating the group::'||ame_approval_group_pkg.getName(approvalGroupIdIn => groupIdIn
5476: ,effectiveDateIn => engEffectiveRuleDate)
5477: );
5709: end if;
5710: end;
5711: end if;
5712: end loop;
5713: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
5714: fnd_log.string
5715: (fnd_log.level_statement
5716: ,'ame_engine.fetchRuntimeGroup'
5717: ,'Completed the group evaluation::'||ame_approval_group_pkg.getName(approvalGroupIdIn => groupIdIn
5710: end;
5711: end if;
5712: end loop;
5713: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
5714: fnd_log.string
5715: (fnd_log.level_statement
5716: ,'ame_engine.fetchRuntimeGroup'
5717: ,'Completed the group evaluation::'||ame_approval_group_pkg.getName(approvalGroupIdIn => groupIdIn
5718: ,effectiveDateIn => engEffectiveRuleDate)
5711: end if;
5712: end loop;
5713: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
5714: fnd_log.string
5715: (fnd_log.level_statement
5716: ,'ame_engine.fetchRuntimeGroup'
5717: ,'Completed the group evaluation::'||ame_approval_group_pkg.getName(approvalGroupIdIn => groupIdIn
5718: ,effectiveDateIn => engEffectiveRuleDate)
5719: );
10109: authorityIn => ame_util.postApprover);
10110: engInsertedApproverList(i).action_type_order_number := getNullActionTypeOrderNumber;
10111: engInsertedApproverList(i).group_or_chain_order_number := 1;
10112: end if;
10113: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10114: fnd_log.string
10115: (fnd_log.level_statement
10116: ,'ame_engine.processAdhocInsertions'
10117: ,'Adhoc Insertion approver(absolute order) ::: ' || engInsertedApproverList(i).name
10110: engInsertedApproverList(i).action_type_order_number := getNullActionTypeOrderNumber;
10111: engInsertedApproverList(i).group_or_chain_order_number := 1;
10112: end if;
10113: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10114: fnd_log.string
10115: (fnd_log.level_statement
10116: ,'ame_engine.processAdhocInsertions'
10117: ,'Adhoc Insertion approver(absolute order) ::: ' || engInsertedApproverList(i).name
10118: );
10111: engInsertedApproverList(i).group_or_chain_order_number := 1;
10112: end if;
10113: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10114: fnd_log.string
10115: (fnd_log.level_statement
10116: ,'ame_engine.processAdhocInsertions'
10117: ,'Adhoc Insertion approver(absolute order) ::: ' || engInsertedApproverList(i).name
10118: );
10119: end if;
10173: engInsertedApproverList(i).sub_list_order_number := engStApprovers(tempIndex).sub_list_order_number;
10174: engInsertedApproverList(i).action_type_order_number := engStApprovers(tempIndex).action_type_order_number;
10175: engInsertedApproverList(i).group_or_chain_order_number :=
10176: engStApprovers(tempIndex).group_or_chain_order_number;
10177: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10178: fnd_log.string
10179: (fnd_log.level_statement
10180: ,'ame_engine.processAdhocInsertions'
10181: ,'Adhoc Insertion approver(after/before approver) ::: ' || engInsertedApproverList(i).name
10174: engInsertedApproverList(i).action_type_order_number := engStApprovers(tempIndex).action_type_order_number;
10175: engInsertedApproverList(i).group_or_chain_order_number :=
10176: engStApprovers(tempIndex).group_or_chain_order_number;
10177: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10178: fnd_log.string
10179: (fnd_log.level_statement
10180: ,'ame_engine.processAdhocInsertions'
10181: ,'Adhoc Insertion approver(after/before approver) ::: ' || engInsertedApproverList(i).name
10182: );
10175: engInsertedApproverList(i).group_or_chain_order_number :=
10176: engStApprovers(tempIndex).group_or_chain_order_number;
10177: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10178: fnd_log.string
10179: (fnd_log.level_statement
10180: ,'ame_engine.processAdhocInsertions'
10181: ,'Adhoc Insertion approver(after/before approver) ::: ' || engInsertedApproverList(i).name
10182: );
10183: end if;
10523: /* asynchronous parallel approver functionality */
10524: if engInsertionOrderTypeList(i) = ame_util.firstPreApprover or
10525: engInsertionOrderTypeList(i) = ame_util.firstPostApprover then
10526: engInsertedApproverList(i).action_type_id := -1;
10527: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10528: fnd_log.string
10529: (fnd_log.level_statement
10530: ,'ame_engine.processAdhocInsertions'
10531: ,'Adhoc Insertion approver(first pre/first post approver) ::: ' || engInsertedApproverList(i).name
10524: if engInsertionOrderTypeList(i) = ame_util.firstPreApprover or
10525: engInsertionOrderTypeList(i) = ame_util.firstPostApprover then
10526: engInsertedApproverList(i).action_type_id := -1;
10527: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10528: fnd_log.string
10529: (fnd_log.level_statement
10530: ,'ame_engine.processAdhocInsertions'
10531: ,'Adhoc Insertion approver(first pre/first post approver) ::: ' || engInsertedApproverList(i).name
10532: );
10525: engInsertionOrderTypeList(i) = ame_util.firstPostApprover then
10526: engInsertedApproverList(i).action_type_id := -1;
10527: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10528: fnd_log.string
10529: (fnd_log.level_statement
10530: ,'ame_engine.processAdhocInsertions'
10531: ,'Adhoc Insertion approver(first pre/first post approver) ::: ' || engInsertedApproverList(i).name
10532: );
10533: end if;
10541: ,insertionOrderIn => engInsertionOrderList(i));
10542: elsif engInsertionOrderTypeList(i) = ame_util.lastPreApprover or
10543: engInsertionOrderTypeList(i) = ame_util.lastPostApprover then
10544: engInsertedApproverList(i).action_type_id := -2;
10545: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10546: fnd_log.string
10547: (fnd_log.level_statement
10548: ,'ame_engine.processAdhocInsertions'
10549: ,'Adhoc Insertion approver(last pre/last post approver) ::: ' || engInsertedApproverList(i).name
10542: elsif engInsertionOrderTypeList(i) = ame_util.lastPreApprover or
10543: engInsertionOrderTypeList(i) = ame_util.lastPostApprover then
10544: engInsertedApproverList(i).action_type_id := -2;
10545: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10546: fnd_log.string
10547: (fnd_log.level_statement
10548: ,'ame_engine.processAdhocInsertions'
10549: ,'Adhoc Insertion approver(last pre/last post approver) ::: ' || engInsertedApproverList(i).name
10550: );
10543: engInsertionOrderTypeList(i) = ame_util.lastPostApprover then
10544: engInsertedApproverList(i).action_type_id := -2;
10545: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10546: fnd_log.string
10547: (fnd_log.level_statement
10548: ,'ame_engine.processAdhocInsertions'
10549: ,'Adhoc Insertion approver(last pre/last post approver) ::: ' || engInsertedApproverList(i).name
10550: );
10551: end if;
10580: engStApprovers(j).item_class = parameterFields(3) and
10581: (j = engStApproversCount or
10582: engStApprovers(j + 1).item_id <> parameterFields(2) or
10583: engStApprovers(j + 1).item_class <> parameterFields(3))) then
10584: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10585: fnd_log.string
10586: (fnd_log.level_statement
10587: ,'ame_engine.processAdhocInsertions'
10588: ,'Adhoc Insertion approver(displaced) ::: ' || engInsertedApproverList(displacedInserteeIndexes(i)).name
10581: (j = engStApproversCount or
10582: engStApprovers(j + 1).item_id <> parameterFields(2) or
10583: engStApprovers(j + 1).item_class <> parameterFields(3))) then
10584: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10585: fnd_log.string
10586: (fnd_log.level_statement
10587: ,'ame_engine.processAdhocInsertions'
10588: ,'Adhoc Insertion approver(displaced) ::: ' || engInsertedApproverList(displacedInserteeIndexes(i)).name
10589: );
10582: engStApprovers(j + 1).item_id <> parameterFields(2) or
10583: engStApprovers(j + 1).item_class <> parameterFields(3))) then
10584: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10585: fnd_log.string
10586: (fnd_log.level_statement
10587: ,'ame_engine.processAdhocInsertions'
10588: ,'Adhoc Insertion approver(displaced) ::: ' || engInsertedApproverList(displacedInserteeIndexes(i)).name
10589: );
10590: end if;
10599: exit;
10600: end if;
10601: end loop;
10602: if(tempBoolean) then
10603: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10604: fnd_log.string
10605: (fnd_log.level_statement
10606: ,'ame_engine.processAdhocInsertions'
10607: ,'Adhoc Insertion approver(displaced) ::: ' || engInsertedApproverList(displacedInserteeIndexes(i)).name
10600: end if;
10601: end loop;
10602: if(tempBoolean) then
10603: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10604: fnd_log.string
10605: (fnd_log.level_statement
10606: ,'ame_engine.processAdhocInsertions'
10607: ,'Adhoc Insertion approver(displaced) ::: ' || engInsertedApproverList(displacedInserteeIndexes(i)).name
10608: );
10601: end loop;
10602: if(tempBoolean) then
10603: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10604: fnd_log.string
10605: (fnd_log.level_statement
10606: ,'ame_engine.processAdhocInsertions'
10607: ,'Adhoc Insertion approver(displaced) ::: ' || engInsertedApproverList(displacedInserteeIndexes(i)).name
10608: );
10609: end if;
10677: engStProductionsTable(tempIndex).variable_name := engAppParameters(i);
10678: engStProductionsTable(tempIndex).variable_value := engAppParameterTwos(i);
10679: engStProductionsTable(tempIndex).item_class := getHandlerItemClassName;
10680: engStProductionsTable(tempIndex).item_id := getHandlerItemId;
10681: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10682: fnd_log.string
10683: (fnd_log.level_statement
10684: ,'ame_engine.processActionType'
10685: ,'Transaction Production ::: ' || engStProductionsTable(tempIndex).variable_name || '/' || engStProductionsTable(tempIndex).variable_value
10678: engStProductionsTable(tempIndex).variable_value := engAppParameterTwos(i);
10679: engStProductionsTable(tempIndex).item_class := getHandlerItemClassName;
10680: engStProductionsTable(tempIndex).item_id := getHandlerItemId;
10681: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10682: fnd_log.string
10683: (fnd_log.level_statement
10684: ,'ame_engine.processActionType'
10685: ,'Transaction Production ::: ' || engStProductionsTable(tempIndex).variable_name || '/' || engStProductionsTable(tempIndex).variable_value
10686: );
10679: engStProductionsTable(tempIndex).item_class := getHandlerItemClassName;
10680: engStProductionsTable(tempIndex).item_id := getHandlerItemId;
10681: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10682: fnd_log.string
10683: (fnd_log.level_statement
10684: ,'ame_engine.processActionType'
10685: ,'Transaction Production ::: ' || engStProductionsTable(tempIndex).variable_name || '/' || engStProductionsTable(tempIndex).variable_value
10686: );
10687: end if;
10695: /*
10696: Call the handler for action types other than the production-rule action type.
10697: (Per-approver productions get handled later.)
10698: */
10699: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10700: fnd_log.string
10701: (fnd_log.level_statement
10702: ,'ame_engine.processActionType'
10703: ,'Processing Action Type ::: ' || engAppActionTypeIds(engAppHandlerFirstIndex)
10696: Call the handler for action types other than the production-rule action type.
10697: (Per-approver productions get handled later.)
10698: */
10699: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10700: fnd_log.string
10701: (fnd_log.level_statement
10702: ,'ame_engine.processActionType'
10703: ,'Processing Action Type ::: ' || engAppActionTypeIds(engAppHandlerFirstIndex)
10704: );
10697: (Per-approver productions get handled later.)
10698: */
10699: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10700: fnd_log.string
10701: (fnd_log.level_statement
10702: ,'ame_engine.processActionType'
10703: ,'Processing Action Type ::: ' || engAppActionTypeIds(engAppHandlerFirstIndex)
10704: );
10705: end if;
10707: 'begin ' ||
10708: getActionTypePackageName(actionTypeIdIn => engAppActionTypeIds(engAppHandlerFirstIndex)) ||
10709: '.handler; end;';
10710: end if;
10711: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10712: fnd_log.string
10713: (fnd_log.level_statement
10714: ,'ame_engine.processActionType'
10715: ,'Completed processing the action Type ::: ' || engAppActionTypeIds(engAppHandlerFirstIndex)
10708: getActionTypePackageName(actionTypeIdIn => engAppActionTypeIds(engAppHandlerFirstIndex)) ||
10709: '.handler; end;';
10710: end if;
10711: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10712: fnd_log.string
10713: (fnd_log.level_statement
10714: ,'ame_engine.processActionType'
10715: ,'Completed processing the action Type ::: ' || engAppActionTypeIds(engAppHandlerFirstIndex)
10716: );
10709: '.handler; end;';
10710: end if;
10711: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10712: fnd_log.string
10713: (fnd_log.level_statement
10714: ,'ame_engine.processActionType'
10715: ,'Completed processing the action Type ::: ' || engAppActionTypeIds(engAppHandlerFirstIndex)
10716: );
10717: end if;
10767: engStApprovers(j).item_class = engDeletedApproverList(i).item_class) then
10768: engStApprovers(j).approval_status := ame_util.suppressedStatus;
10769: engStApprovers(j).source := ame_util.apiSuppression;
10770: processSuppressDeviation(j,i);
10771: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10772: fnd_log.string
10773: (fnd_log.level_statement
10774: ,'ame_engine.processSuppressions'
10775: ,'Suppressed approver ::: ' || engStApprovers(j).name
10768: engStApprovers(j).approval_status := ame_util.suppressedStatus;
10769: engStApprovers(j).source := ame_util.apiSuppression;
10770: processSuppressDeviation(j,i);
10771: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10772: fnd_log.string
10773: (fnd_log.level_statement
10774: ,'ame_engine.processSuppressions'
10775: ,'Suppressed approver ::: ' || engStApprovers(j).name
10776: );
10769: engStApprovers(j).source := ame_util.apiSuppression;
10770: processSuppressDeviation(j,i);
10771: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10772: fnd_log.string
10773: (fnd_log.level_statement
10774: ,'ame_engine.processSuppressions'
10775: ,'Suppressed approver ::: ' || engStApprovers(j).name
10776: );
10777: end if;
11081: */
11082: if(engStApprovers(j).approval_status is null and
11083: engStApprovers(j).source not like ame_util.specialForwardInsertion || '%') then
11084: engStApprovers(j).approval_status := ame_util.repeatedStatus;
11085: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11086: fnd_log.string
11087: (fnd_log.level_statement
11088: ,'ame_engine.processRepeatedApprovers'
11089: ,'Repeated Approver ::: ' || engStApprovers(j).name
11082: if(engStApprovers(j).approval_status is null and
11083: engStApprovers(j).source not like ame_util.specialForwardInsertion || '%') then
11084: engStApprovers(j).approval_status := ame_util.repeatedStatus;
11085: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11086: fnd_log.string
11087: (fnd_log.level_statement
11088: ,'ame_engine.processRepeatedApprovers'
11089: ,'Repeated Approver ::: ' || engStApprovers(j).name
11090: );
11083: engStApprovers(j).source not like ame_util.specialForwardInsertion || '%') then
11084: engStApprovers(j).approval_status := ame_util.repeatedStatus;
11085: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11086: fnd_log.string
11087: (fnd_log.level_statement
11088: ,'ame_engine.processRepeatedApprovers'
11089: ,'Repeated Approver ::: ' || engStApprovers(j).name
11090: );
11091: end if;
11234: end if;
11235: if(currentLastItemIndex is not null) then
11236: /* Process the current item's rules. */
11237: if processOnlyProductionsIn then
11238: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11239: fnd_log.string
11240: (fnd_log.level_statement
11241: ,'ame_engine.processRules'
11242: ,'Processing only production rules'
11235: if(currentLastItemIndex is not null) then
11236: /* Process the current item's rules. */
11237: if processOnlyProductionsIn then
11238: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11239: fnd_log.string
11240: (fnd_log.level_statement
11241: ,'ame_engine.processRules'
11242: ,'Processing only production rules'
11243: );
11236: /* Process the current item's rules. */
11237: if processOnlyProductionsIn then
11238: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11239: fnd_log.string
11240: (fnd_log.level_statement
11241: ,'ame_engine.processRules'
11242: ,'Processing only production rules'
11243: );
11244: end if;
11243: );
11244: end if;
11245: ruleTypeUpperLimit := 1;
11246: else
11247: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11248: fnd_log.string
11249: (fnd_log.level_statement
11250: ,'ame_engine.processRules'
11251: ,'Processing all rules'
11244: end if;
11245: ruleTypeUpperLimit := 1;
11246: else
11247: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11248: fnd_log.string
11249: (fnd_log.level_statement
11250: ,'ame_engine.processRules'
11251: ,'Processing all rules'
11252: );
11245: ruleTypeUpperLimit := 1;
11246: else
11247: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11248: fnd_log.string
11249: (fnd_log.level_statement
11250: ,'ame_engine.processRules'
11251: ,'Processing all rules'
11252: );
11253: end if;
11305: exit;
11306: end if;
11307: currentIndex := currentIndex + 1;
11308: end loop;
11309: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11310: if engStApprovers.count = 0 then
11311: fnd_log.string
11312: (fnd_log.level_statement
11313: ,'ame_engine.processRules'
11307: currentIndex := currentIndex + 1;
11308: end loop;
11309: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11310: if engStApprovers.count = 0 then
11311: fnd_log.string
11312: (fnd_log.level_statement
11313: ,'ame_engine.processRules'
11314: ,'**************** No Approvers ******************'
11315: );
11308: end loop;
11309: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11310: if engStApprovers.count = 0 then
11311: fnd_log.string
11312: (fnd_log.level_statement
11313: ,'ame_engine.processRules'
11314: ,'**************** No Approvers ******************'
11315: );
11316: else
11314: ,'**************** No Approvers ******************'
11315: );
11316: else
11317: for i in 1 .. engStApprovers.count loop
11318: fnd_log.string
11319: (fnd_log.level_statement
11320: ,'ame_engine.processRules'
11321: ,'Approver ::: ' || engStApprovers(i).name
11322: );
11315: );
11316: else
11317: for i in 1 .. engStApprovers.count loop
11318: fnd_log.string
11319: (fnd_log.level_statement
11320: ,'ame_engine.processRules'
11321: ,'Approver ::: ' || engStApprovers(i).name
11322: );
11323: end loop;
11538: adjustMemberOrderNumbers is false */
11539: tempSurrogateApprover.member_order_number := engStApprovers(tempIndex).member_order_number;
11540: tempSurrogateApprover.approver_order_number := engStApprovers(tempIndex).approver_order_number;
11541: /* tempSurrogateApprover.approver_order_number also gets set later. */
11542: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11543: fnd_log.string
11544: (fnd_log.level_statement
11545: ,'ame_engine.processUnresponsiveApprovers'
11546: ,'Unresponsive approver ::: ' || engStApprovers(tempIndex).name || ' Surrogate ::: ' || tempSurrogateApprover.name
11539: tempSurrogateApprover.member_order_number := engStApprovers(tempIndex).member_order_number;
11540: tempSurrogateApprover.approver_order_number := engStApprovers(tempIndex).approver_order_number;
11541: /* tempSurrogateApprover.approver_order_number also gets set later. */
11542: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11543: fnd_log.string
11544: (fnd_log.level_statement
11545: ,'ame_engine.processUnresponsiveApprovers'
11546: ,'Unresponsive approver ::: ' || engStApprovers(tempIndex).name || ' Surrogate ::: ' || tempSurrogateApprover.name
11547: );
11540: tempSurrogateApprover.approver_order_number := engStApprovers(tempIndex).approver_order_number;
11541: /* tempSurrogateApprover.approver_order_number also gets set later. */
11542: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11543: fnd_log.string
11544: (fnd_log.level_statement
11545: ,'ame_engine.processUnresponsiveApprovers'
11546: ,'Unresponsive approver ::: ' || engStApprovers(tempIndex).name || ' Surrogate ::: ' || tempSurrogateApprover.name
11547: );
11548: end if;
12273: transactionIdIn => transactionIdIn,
12274: ameApplicationIdIn => ameApplicationIdIn,
12275: fndApplicationIdIn => fndApplicationIdIn,
12276: transactionTypeIdIn => transactionTypeIdIn);
12277: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12278: fnd_log.string
12279: (fnd_log.level_statement
12280: ,'ame_engine.updateTransactionState'
12281: ,'AME Application Id ::: ' || engAmeApplicationId
12274: ameApplicationIdIn => ameApplicationIdIn,
12275: fndApplicationIdIn => fndApplicationIdIn,
12276: transactionTypeIdIn => transactionTypeIdIn);
12277: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12278: fnd_log.string
12279: (fnd_log.level_statement
12280: ,'ame_engine.updateTransactionState'
12281: ,'AME Application Id ::: ' || engAmeApplicationId
12282: );
12275: fndApplicationIdIn => fndApplicationIdIn,
12276: transactionTypeIdIn => transactionTypeIdIn);
12277: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12278: fnd_log.string
12279: (fnd_log.level_statement
12280: ,'ame_engine.updateTransactionState'
12281: ,'AME Application Id ::: ' || engAmeApplicationId
12282: );
12283: fnd_log.string
12279: (fnd_log.level_statement
12280: ,'ame_engine.updateTransactionState'
12281: ,'AME Application Id ::: ' || engAmeApplicationId
12282: );
12283: fnd_log.string
12284: (fnd_log.level_statement
12285: ,'ame_engine.updateTransactionState'
12286: ,'AME Transaction Id ::: ' || engTransactionId
12287: );
12280: ,'ame_engine.updateTransactionState'
12281: ,'AME Application Id ::: ' || engAmeApplicationId
12282: );
12283: fnd_log.string
12284: (fnd_log.level_statement
12285: ,'ame_engine.updateTransactionState'
12286: ,'AME Transaction Id ::: ' || engTransactionId
12287: );
12288: end if;
12310: processRules(processOnlyProductionsIn => false);
12311: elsif(processProductionRulesIn) then
12312: processRules(processOnlyProductionsIn => true);
12313: end if;
12314: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12315: fnd_log.string
12316: (fnd_log.level_statement
12317: ,'ame_engine.updateTransactionState'
12318: ,'Approver count after processRules ::: ' || engStApprovers.count
12311: elsif(processProductionRulesIn) then
12312: processRules(processOnlyProductionsIn => true);
12313: end if;
12314: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12315: fnd_log.string
12316: (fnd_log.level_statement
12317: ,'ame_engine.updateTransactionState'
12318: ,'Approver count after processRules ::: ' || engStApprovers.count
12319: );
12312: processRules(processOnlyProductionsIn => true);
12313: end if;
12314: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12315: fnd_log.string
12316: (fnd_log.level_statement
12317: ,'ame_engine.updateTransactionState'
12318: ,'Approver count after processRules ::: ' || engStApprovers.count
12319: );
12320: end if;
12320: end if;
12321: if(updateCurrentApproverListIn or
12322: updateOldApproverListIn) then
12323: processAdHocInsertions;
12324: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12325: fnd_log.string
12326: (fnd_log.level_statement
12327: ,'ame_engine.updateTransactionState'
12328: ,'Approver count after processAdHocInsertions ::: ' || engStApprovers.count
12321: if(updateCurrentApproverListIn or
12322: updateOldApproverListIn) then
12323: processAdHocInsertions;
12324: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12325: fnd_log.string
12326: (fnd_log.level_statement
12327: ,'ame_engine.updateTransactionState'
12328: ,'Approver count after processAdHocInsertions ::: ' || engStApprovers.count
12329: );
12322: updateOldApproverListIn) then
12323: processAdHocInsertions;
12324: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12325: fnd_log.string
12326: (fnd_log.level_statement
12327: ,'ame_engine.updateTransactionState'
12328: ,'Approver count after processAdHocInsertions ::: ' || engStApprovers.count
12329: );
12330: end if;
12328: ,'Approver count after processAdHocInsertions ::: ' || engStApprovers.count
12329: );
12330: end if;
12331: processUnresponsiveApprovers;
12332: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12333: fnd_log.string
12334: (fnd_log.level_statement
12335: ,'ame_engine.updateTransactionState'
12336: ,'Approver count after processUnresponsiveApprovers ::: ' || engStApprovers.count
12329: );
12330: end if;
12331: processUnresponsiveApprovers;
12332: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12333: fnd_log.string
12334: (fnd_log.level_statement
12335: ,'ame_engine.updateTransactionState'
12336: ,'Approver count after processUnresponsiveApprovers ::: ' || engStApprovers.count
12337: );
12330: end if;
12331: processUnresponsiveApprovers;
12332: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12333: fnd_log.string
12334: (fnd_log.level_statement
12335: ,'ame_engine.updateTransactionState'
12336: ,'Approver count after processUnresponsiveApprovers ::: ' || engStApprovers.count
12337: );
12338: end if;
12337: );
12338: end if;
12339: if engRepeatSubstitutions then
12340: repeatSubstitutions;
12341: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12342: fnd_log.string
12343: (fnd_log.level_statement
12344: ,'ame_engine.updateTransactionState'
12345: ,'Approver count after repeatSubstitutions ::: ' || engStApprovers.count
12338: end if;
12339: if engRepeatSubstitutions then
12340: repeatSubstitutions;
12341: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12342: fnd_log.string
12343: (fnd_log.level_statement
12344: ,'ame_engine.updateTransactionState'
12345: ,'Approver count after repeatSubstitutions ::: ' || engStApprovers.count
12346: );
12339: if engRepeatSubstitutions then
12340: repeatSubstitutions;
12341: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12342: fnd_log.string
12343: (fnd_log.level_statement
12344: ,'ame_engine.updateTransactionState'
12345: ,'Approver count after repeatSubstitutions ::: ' || engStApprovers.count
12346: );
12347: end if;
12351: processSuppressions must precede processRepeatedApprovers, because the latter procedure needs to see
12352: any approver deletions, to aggregate approvers correctly.
12353: */
12354: processSuppressions;
12355: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12356: fnd_log.string
12357: (fnd_log.level_statement
12358: ,'ame_engine.updateTransactionState'
12359: ,'Approver count after processSuppressions ::: ' || engStApprovers.count
12352: any approver deletions, to aggregate approvers correctly.
12353: */
12354: processSuppressions;
12355: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12356: fnd_log.string
12357: (fnd_log.level_statement
12358: ,'ame_engine.updateTransactionState'
12359: ,'Approver count after processSuppressions ::: ' || engStApprovers.count
12360: );
12353: */
12354: processSuppressions;
12355: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12356: fnd_log.string
12357: (fnd_log.level_statement
12358: ,'ame_engine.updateTransactionState'
12359: ,'Approver count after processSuppressions ::: ' || engStApprovers.count
12360: );
12361: end if;
12363: processSuppressions must precede processRepeatedApprovers so every approver in engStApprovers still
12364: has non-null item_class and item_id fields.
12365: */
12366: processRepeatedApprovers;
12367: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12368: fnd_log.string
12369: (fnd_log.level_statement
12370: ,'ame_engine.updateTransactionState'
12371: ,'Approver count after processRepeatedApprovers ::: ' || engStApprovers.count
12364: has non-null item_class and item_id fields.
12365: */
12366: processRepeatedApprovers;
12367: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12368: fnd_log.string
12369: (fnd_log.level_statement
12370: ,'ame_engine.updateTransactionState'
12371: ,'Approver count after processRepeatedApprovers ::: ' || engStApprovers.count
12372: );
12365: */
12366: processRepeatedApprovers;
12367: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12368: fnd_log.string
12369: (fnd_log.level_statement
12370: ,'ame_engine.updateTransactionState'
12371: ,'Approver count after processRepeatedApprovers ::: ' || engStApprovers.count
12372: );
12373: end if;
12387: ,engStApprovalProcessCompleteYN
12388: ,engStApprovers);
12389: end if;
12390: end if;
12391: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12392: if engStApprovers.count = 0 then
12393: fnd_log.string
12394: (fnd_log.level_statement
12395: ,'ame_engine.updateTransactionState'
12389: end if;
12390: end if;
12391: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12392: if engStApprovers.count = 0 then
12393: fnd_log.string
12394: (fnd_log.level_statement
12395: ,'ame_engine.updateTransactionState'
12396: ,'**************** No Approvers ******************'
12397: );
12390: end if;
12391: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
12392: if engStApprovers.count = 0 then
12393: fnd_log.string
12394: (fnd_log.level_statement
12395: ,'ame_engine.updateTransactionState'
12396: ,'**************** No Approvers ******************'
12397: );
12398: else
12396: ,'**************** No Approvers ******************'
12397: );
12398: else
12399: for i in 1 .. engStApprovers.count loop
12400: fnd_log.string
12401: (fnd_log.level_statement
12402: ,'ame_engine.updateTransactionState'
12403: ,'Approver ::: ' || engStApprovers(i).name || ' Order Number ::: ' || engStApprovers(i).approver_order_number
12404: );
12397: );
12398: else
12399: for i in 1 .. engStApprovers.count loop
12400: fnd_log.string
12401: (fnd_log.level_statement
12402: ,'ame_engine.updateTransactionState'
12403: ,'Approver ::: ' || engStApprovers(i).name || ' Order Number ::: ' || engStApprovers(i).approver_order_number
12404: );
12405: end loop;