DBA Data[Home] [Help]

APPS.AME_ENGINE dependencies on FND_LOG

Line 3433: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

3429: */
3430: if(engProcessPriorities) then
3431: processRelativePriorities;
3432: end if;
3433: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
3434: if engAppRuleIds.count = 0 then
3435: fnd_log.string
3436: (fnd_log.level_statement
3437: ,'ame_engine.evaluateRules'

Line 3435: fnd_log.string

3431: processRelativePriorities;
3432: end if;
3433: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
3434: if engAppRuleIds.count = 0 then
3435: fnd_log.string
3436: (fnd_log.level_statement
3437: ,'ame_engine.evaluateRules'
3438: ,'*********** No Rules Applicable ************'
3439: );

Line 3436: (fnd_log.level_statement

3432: end if;
3433: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
3434: if engAppRuleIds.count = 0 then
3435: fnd_log.string
3436: (fnd_log.level_statement
3437: ,'ame_engine.evaluateRules'
3438: ,'*********** No Rules Applicable ************'
3439: );
3440: else

Line 3442: fnd_log.string

3438: ,'*********** No Rules Applicable ************'
3439: );
3440: else
3441: for i in 1 .. engAppRuleIds.count loop
3442: fnd_log.string
3443: (fnd_log.level_statement
3444: ,'ame_engine.evaluateRules'
3445: ,'Applicable Rule ::: ' || engAppRuleIds(i)
3446: );

Line 3443: (fnd_log.level_statement

3439: );
3440: else
3441: for i in 1 .. engAppRuleIds.count loop
3442: fnd_log.string
3443: (fnd_log.level_statement
3444: ,'ame_engine.evaluateRules'
3445: ,'Applicable Rule ::: ' || engAppRuleIds(i)
3446: );
3447: end loop;

Line 4071: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

4067: engAttributeVariant(tempAttributeId) := ame_util.booleanTrue;
4068: engAttributeQueries(tempAttributeId) := queryStrings(i);
4069: end if;
4070: end if;
4071: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4072: fnd_log.string
4073: (fnd_log.level_statement
4074: ,'ame_engine.fetchAttributeValues'
4075: ,'Attribute ::: ' || engAttributeNames(tempAttributeId) || '(' || tempAttributeId || ')'

Line 4072: fnd_log.string

4068: engAttributeQueries(tempAttributeId) := queryStrings(i);
4069: end if;
4070: end if;
4071: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4072: fnd_log.string
4073: (fnd_log.level_statement
4074: ,'ame_engine.fetchAttributeValues'
4075: ,'Attribute ::: ' || engAttributeNames(tempAttributeId) || '(' || tempAttributeId || ')'
4076: );

Line 4073: (fnd_log.level_statement

4069: end if;
4070: end if;
4071: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4072: fnd_log.string
4073: (fnd_log.level_statement
4074: ,'ame_engine.fetchAttributeValues'
4075: ,'Attribute ::: ' || engAttributeNames(tempAttributeId) || '(' || tempAttributeId || ')'
4076: );
4077: end if;

Line 4122: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

4118: else
4119: engAttributeValues2(tempAttributeValueIndex) := null;
4120: engAttributeValues3(tempAttributeValueIndex) := null;
4121: end if;
4122: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4123: fnd_log.string
4124: (fnd_log.level_statement
4125: ,'ame_engine.fetchAttributeValues'
4126: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||

Line 4123: fnd_log.string

4119: engAttributeValues2(tempAttributeValueIndex) := null;
4120: engAttributeValues3(tempAttributeValueIndex) := null;
4121: end if;
4122: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4123: fnd_log.string
4124: (fnd_log.level_statement
4125: ,'ame_engine.fetchAttributeValues'
4126: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4127: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'

Line 4124: (fnd_log.level_statement

4120: engAttributeValues3(tempAttributeValueIndex) := null;
4121: end if;
4122: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4123: fnd_log.string
4124: (fnd_log.level_statement
4125: ,'ame_engine.fetchAttributeValues'
4126: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4127: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4128: );

Line 4137: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

4133: tempAttributeValueIndex := tempAttributeValueIndex + 1;
4134: engAttributeValues1(tempAttributeValueIndex) := null;
4135: engAttributeValues2(tempAttributeValueIndex) := null;
4136: engAttributeValues3(tempAttributeValueIndex) := null;
4137: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4138: fnd_log.string
4139: (fnd_log.level_statement
4140: ,'ame_engine.fetchAttributeValues'
4141: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||

Line 4138: fnd_log.string

4134: engAttributeValues1(tempAttributeValueIndex) := null;
4135: engAttributeValues2(tempAttributeValueIndex) := null;
4136: engAttributeValues3(tempAttributeValueIndex) := null;
4137: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4138: fnd_log.string
4139: (fnd_log.level_statement
4140: ,'ame_engine.fetchAttributeValues'
4141: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4142: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'

Line 4139: (fnd_log.level_statement

4135: engAttributeValues2(tempAttributeValueIndex) := null;
4136: engAttributeValues3(tempAttributeValueIndex) := null;
4137: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4138: fnd_log.string
4139: (fnd_log.level_statement
4140: ,'ame_engine.fetchAttributeValues'
4141: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4142: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4143: );

Line 4171: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

4167: tempAttributeValueIndex := tempAttributeValueIndex + 1;
4168: engAttributeValues1(tempAttributeValueIndex) := tempAttributeValue1;
4169: engAttributeValues2(tempAttributeValueIndex) := tempAttributeValue2;
4170: engAttributeValues3(tempAttributeValueIndex) := tempAttributeValue3;
4171: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4172: fnd_log.string
4173: (fnd_log.level_statement
4174: ,'ame_engine.fetchAttributeValues'
4175: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||

Line 4172: fnd_log.string

4168: engAttributeValues1(tempAttributeValueIndex) := tempAttributeValue1;
4169: engAttributeValues2(tempAttributeValueIndex) := tempAttributeValue2;
4170: engAttributeValues3(tempAttributeValueIndex) := tempAttributeValue3;
4171: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4172: fnd_log.string
4173: (fnd_log.level_statement
4174: ,'ame_engine.fetchAttributeValues'
4175: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4176: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'

Line 4173: (fnd_log.level_statement

4169: engAttributeValues2(tempAttributeValueIndex) := tempAttributeValue2;
4170: engAttributeValues3(tempAttributeValueIndex) := tempAttributeValue3;
4171: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4172: fnd_log.string
4173: (fnd_log.level_statement
4174: ,'ame_engine.fetchAttributeValues'
4175: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4176: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4177: );

Line 4261: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

4257: else
4258: engAttributeValues2(tempAttributeValueIndex) := null;
4259: engAttributeValues3(tempAttributeValueIndex) := null;
4260: end if;
4261: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4262: fnd_log.string
4263: (fnd_log.level_statement
4264: ,'ame_engine.fetchAttributeValues'
4265: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||

Line 4262: fnd_log.string

4258: engAttributeValues2(tempAttributeValueIndex) := null;
4259: engAttributeValues3(tempAttributeValueIndex) := null;
4260: end if;
4261: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4262: fnd_log.string
4263: (fnd_log.level_statement
4264: ,'ame_engine.fetchAttributeValues'
4265: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4266: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'

Line 4263: (fnd_log.level_statement

4259: engAttributeValues3(tempAttributeValueIndex) := null;
4260: end if;
4261: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4262: fnd_log.string
4263: (fnd_log.level_statement
4264: ,'ame_engine.fetchAttributeValues'
4265: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4266: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4267: );

Line 4289: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

4285: if(testTransNonCurrencyCursor%isopen) then
4286: close testTransNonCurrencyCursor;
4287: end if;
4288: tempAttributeName := ame_attribute_pkg.getName(attributeIdIn => tempAttributeId);
4289: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4290: fnd_log.string
4291: (fnd_log.level_statement
4292: ,'ame_engine.fetchAttributeValues'
4293: ,'Attribute ::: ' || tempAttributeName || '(' || tempAttributeId || ')'||

Line 4290: fnd_log.string

4286: close testTransNonCurrencyCursor;
4287: end if;
4288: tempAttributeName := ame_attribute_pkg.getName(attributeIdIn => tempAttributeId);
4289: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4290: fnd_log.string
4291: (fnd_log.level_statement
4292: ,'ame_engine.fetchAttributeValues'
4293: ,'Attribute ::: ' || tempAttributeName || '(' || tempAttributeId || ')'||
4294: 'attribute returned ::'||tempAttributeValues1.count||'rows but the number of items for the '||

Line 4291: (fnd_log.level_statement

4287: end if;
4288: tempAttributeName := ame_attribute_pkg.getName(attributeIdIn => tempAttributeId);
4289: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4290: fnd_log.string
4291: (fnd_log.level_statement
4292: ,'ame_engine.fetchAttributeValues'
4293: ,'Attribute ::: ' || tempAttributeName || '(' || tempAttributeId || ')'||
4294: 'attribute returned ::'||tempAttributeValues1.count||'rows but the number of items for the '||
4295: 'itemclass ::'||engItemCounts(tempItemClassIndex)

Line 4325: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

4321: close testTransNonCurrencyCursor;
4322: end if;
4323: tempAttributeName := ame_attribute_pkg.getName(attributeIdIn => tempAttributeId);
4324: errorMessage := sqlerrm;
4325: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4326: fnd_log.string
4327: (fnd_log.level_statement
4328: ,'ame_engine.fetchAttributeValues'
4329: ,'Attribute ::: ' || tempAttributeName || '(' || tempAttributeId || '),error:'||errorMessage

Line 4326: fnd_log.string

4322: end if;
4323: tempAttributeName := ame_attribute_pkg.getName(attributeIdIn => tempAttributeId);
4324: errorMessage := sqlerrm;
4325: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4326: fnd_log.string
4327: (fnd_log.level_statement
4328: ,'ame_engine.fetchAttributeValues'
4329: ,'Attribute ::: ' || tempAttributeName || '(' || tempAttributeId || '),error:'||errorMessage
4330: );

Line 4327: (fnd_log.level_statement

4323: tempAttributeName := ame_attribute_pkg.getName(attributeIdIn => tempAttributeId);
4324: errorMessage := sqlerrm;
4325: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4326: fnd_log.string
4327: (fnd_log.level_statement
4328: ,'ame_engine.fetchAttributeValues'
4329: ,'Attribute ::: ' || tempAttributeName || '(' || tempAttributeId || '),error:'||errorMessage
4330: );
4331: end if;

Line 4531: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

4527: engAttributeVariant(tempAttributeId) := ame_util.booleanTrue;
4528: engAttributeQueries(tempAttributeId) := queryStrings(i);
4529: end if;
4530: end if;
4531: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4532: fnd_log.string
4533: (fnd_log.level_statement
4534: ,'ame_engine.fetchOtherAttributeValues'
4535: ,'Attribute ::: ' || engAttributeNames(tempAttributeId) || '(' || tempAttributeId || ')'

Line 4532: fnd_log.string

4528: engAttributeQueries(tempAttributeId) := queryStrings(i);
4529: end if;
4530: end if;
4531: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4532: fnd_log.string
4533: (fnd_log.level_statement
4534: ,'ame_engine.fetchOtherAttributeValues'
4535: ,'Attribute ::: ' || engAttributeNames(tempAttributeId) || '(' || tempAttributeId || ')'
4536: );

Line 4533: (fnd_log.level_statement

4529: end if;
4530: end if;
4531: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4532: fnd_log.string
4533: (fnd_log.level_statement
4534: ,'ame_engine.fetchOtherAttributeValues'
4535: ,'Attribute ::: ' || engAttributeNames(tempAttributeId) || '(' || tempAttributeId || ')'
4536: );
4537: end if;

Line 4582: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

4578: else
4579: engAttributeValues2(tempAttributeValueIndex) := null;
4580: engAttributeValues3(tempAttributeValueIndex) := null;
4581: end if;
4582: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4583: fnd_log.string
4584: (fnd_log.level_statement
4585: ,'ame_engine.fetchOtherAttributeValues'
4586: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||

Line 4583: fnd_log.string

4579: engAttributeValues2(tempAttributeValueIndex) := null;
4580: engAttributeValues3(tempAttributeValueIndex) := null;
4581: end if;
4582: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4583: fnd_log.string
4584: (fnd_log.level_statement
4585: ,'ame_engine.fetchOtherAttributeValues'
4586: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4587: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'

Line 4584: (fnd_log.level_statement

4580: engAttributeValues3(tempAttributeValueIndex) := null;
4581: end if;
4582: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4583: fnd_log.string
4584: (fnd_log.level_statement
4585: ,'ame_engine.fetchOtherAttributeValues'
4586: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4587: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4588: );

Line 4597: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

4593: tempAttributeValueIndex := tempAttributeValueIndex + 1;
4594: engAttributeValues1(tempAttributeValueIndex) := null;
4595: engAttributeValues2(tempAttributeValueIndex) := null;
4596: engAttributeValues3(tempAttributeValueIndex) := null;
4597: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4598: fnd_log.string
4599: (fnd_log.level_statement
4600: ,'ame_engine.fetchOtherAttributeValues'
4601: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||

Line 4598: fnd_log.string

4594: engAttributeValues1(tempAttributeValueIndex) := null;
4595: engAttributeValues2(tempAttributeValueIndex) := null;
4596: engAttributeValues3(tempAttributeValueIndex) := null;
4597: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4598: fnd_log.string
4599: (fnd_log.level_statement
4600: ,'ame_engine.fetchOtherAttributeValues'
4601: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4602: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'

Line 4599: (fnd_log.level_statement

4595: engAttributeValues2(tempAttributeValueIndex) := null;
4596: engAttributeValues3(tempAttributeValueIndex) := null;
4597: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4598: fnd_log.string
4599: (fnd_log.level_statement
4600: ,'ame_engine.fetchOtherAttributeValues'
4601: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4602: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4603: );

Line 4631: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

4627: tempAttributeValueIndex := tempAttributeValueIndex + 1;
4628: engAttributeValues1(tempAttributeValueIndex) := tempAttributeValue1;
4629: engAttributeValues2(tempAttributeValueIndex) := tempAttributeValue2;
4630: engAttributeValues3(tempAttributeValueIndex) := tempAttributeValue3;
4631: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4632: fnd_log.string
4633: (fnd_log.level_statement
4634: ,'ame_engine.fetchOtherAttributeValues'
4635: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||

Line 4632: fnd_log.string

4628: engAttributeValues1(tempAttributeValueIndex) := tempAttributeValue1;
4629: engAttributeValues2(tempAttributeValueIndex) := tempAttributeValue2;
4630: engAttributeValues3(tempAttributeValueIndex) := tempAttributeValue3;
4631: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4632: fnd_log.string
4633: (fnd_log.level_statement
4634: ,'ame_engine.fetchOtherAttributeValues'
4635: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4636: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'

Line 4633: (fnd_log.level_statement

4629: engAttributeValues2(tempAttributeValueIndex) := tempAttributeValue2;
4630: engAttributeValues3(tempAttributeValueIndex) := tempAttributeValue3;
4631: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4632: fnd_log.string
4633: (fnd_log.level_statement
4634: ,'ame_engine.fetchOtherAttributeValues'
4635: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4636: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4637: );

Line 4721: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

4717: else
4718: engAttributeValues2(tempAttributeValueIndex) := null;
4719: engAttributeValues3(tempAttributeValueIndex) := null;
4720: end if;
4721: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4722: fnd_log.string
4723: (fnd_log.level_statement
4724: ,'ame_engine.fetchOtherAttributeValues'
4725: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||

Line 4722: fnd_log.string

4718: engAttributeValues2(tempAttributeValueIndex) := null;
4719: engAttributeValues3(tempAttributeValueIndex) := null;
4720: end if;
4721: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4722: fnd_log.string
4723: (fnd_log.level_statement
4724: ,'ame_engine.fetchOtherAttributeValues'
4725: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4726: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'

Line 4723: (fnd_log.level_statement

4719: engAttributeValues3(tempAttributeValueIndex) := null;
4720: end if;
4721: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
4722: fnd_log.string
4723: (fnd_log.level_statement
4724: ,'ame_engine.fetchOtherAttributeValues'
4725: ,'Attribute Value :' || engAttributeValues1(tempAttributeValueIndex) ||
4726: ':' || engAttributeValues2(tempAttributeValueIndex) || ':' || engAttributeValues3(tempAttributeValueIndex) || ':'
4727: );

Line 5197: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

5193: engItemClassItemIdIndexes(i) := null;
5194: end if;
5195: end if;
5196: end if;
5197: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
5198: fnd_log.string
5199: (fnd_log.level_statement
5200: ,'ame_engine.fetchItemClassData'
5201: ,'Item Class ::' || engItemClassNames(i) ||

Line 5198: fnd_log.string

5194: end if;
5195: end if;
5196: end if;
5197: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
5198: fnd_log.string
5199: (fnd_log.level_statement
5200: ,'ame_engine.fetchItemClassData'
5201: ,'Item Class ::' || engItemClassNames(i) ||
5202: ':' || 'has ' || ':' || engItemCounts(i) || ':items'

Line 5199: (fnd_log.level_statement

5195: end if;
5196: end if;
5197: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
5198: fnd_log.string
5199: (fnd_log.level_statement
5200: ,'ame_engine.fetchItemClassData'
5201: ,'Item Class ::' || engItemClassNames(i) ||
5202: ':' || 'has ' || ':' || engItemCounts(i) || ':items'
5203: );

Line 5364: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

5360: tempApproverType ame_util.stringType;
5361: tempApproverId ame_util.stringType;
5362: tempname wf_roles.name%type;
5363: begin
5364: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
5365: fnd_log.string
5366: (fnd_log.level_statement
5367: ,'ame_engine.fetchRuntimeGroup'
5368: ,'evaluating the group::'||ame_approval_group_pkg.getName(approvalGroupIdIn => groupIdIn

Line 5365: fnd_log.string

5361: tempApproverId ame_util.stringType;
5362: tempname wf_roles.name%type;
5363: begin
5364: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
5365: fnd_log.string
5366: (fnd_log.level_statement
5367: ,'ame_engine.fetchRuntimeGroup'
5368: ,'evaluating the group::'||ame_approval_group_pkg.getName(approvalGroupIdIn => groupIdIn
5369: ,effectiveDateIn => engEffectiveRuleDate)

Line 5366: (fnd_log.level_statement

5362: tempname wf_roles.name%type;
5363: begin
5364: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
5365: fnd_log.string
5366: (fnd_log.level_statement
5367: ,'ame_engine.fetchRuntimeGroup'
5368: ,'evaluating the group::'||ame_approval_group_pkg.getName(approvalGroupIdIn => groupIdIn
5369: ,effectiveDateIn => engEffectiveRuleDate)
5370: );

Line 5512: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

5508: engGroupMemberOrigSystems(outputIndex) := origSystems(i);
5509: engGroupMemberOrigSystemIds(outputIndex) := origSystemIds(i);
5510: end if;
5511: end loop;
5512: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
5513: fnd_log.string
5514: (fnd_log.level_statement
5515: ,'ame_engine.fetchRuntimeGroup'
5516: ,'Completed the group evaluation::'||ame_approval_group_pkg.getName(approvalGroupIdIn => groupIdIn

Line 5513: fnd_log.string

5509: engGroupMemberOrigSystemIds(outputIndex) := origSystemIds(i);
5510: end if;
5511: end loop;
5512: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
5513: fnd_log.string
5514: (fnd_log.level_statement
5515: ,'ame_engine.fetchRuntimeGroup'
5516: ,'Completed the group evaluation::'||ame_approval_group_pkg.getName(approvalGroupIdIn => groupIdIn
5517: ,effectiveDateIn => engEffectiveRuleDate)

Line 5514: (fnd_log.level_statement

5510: end if;
5511: end loop;
5512: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
5513: fnd_log.string
5514: (fnd_log.level_statement
5515: ,'ame_engine.fetchRuntimeGroup'
5516: ,'Completed the group evaluation::'||ame_approval_group_pkg.getName(approvalGroupIdIn => groupIdIn
5517: ,effectiveDateIn => engEffectiveRuleDate)
5518: );

Line 9684: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

9680: authorityIn => ame_util.postApprover);
9681: engInsertedApproverList(i).action_type_order_number := getNullActionTypeOrderNumber;
9682: engInsertedApproverList(i).group_or_chain_order_number := 1;
9683: end if;
9684: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
9685: fnd_log.string
9686: (fnd_log.level_statement
9687: ,'ame_engine.processAdhocInsertions'
9688: ,'Adhoc Insertion approver(absolute order) ::: ' || engInsertedApproverList(i).name

Line 9685: fnd_log.string

9681: engInsertedApproverList(i).action_type_order_number := getNullActionTypeOrderNumber;
9682: engInsertedApproverList(i).group_or_chain_order_number := 1;
9683: end if;
9684: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
9685: fnd_log.string
9686: (fnd_log.level_statement
9687: ,'ame_engine.processAdhocInsertions'
9688: ,'Adhoc Insertion approver(absolute order) ::: ' || engInsertedApproverList(i).name
9689: );

Line 9686: (fnd_log.level_statement

9682: engInsertedApproverList(i).group_or_chain_order_number := 1;
9683: end if;
9684: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
9685: fnd_log.string
9686: (fnd_log.level_statement
9687: ,'ame_engine.processAdhocInsertions'
9688: ,'Adhoc Insertion approver(absolute order) ::: ' || engInsertedApproverList(i).name
9689: );
9690: end if;

Line 9748: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

9744: engInsertedApproverList(i).sub_list_order_number := engStApprovers(tempIndex).sub_list_order_number;
9745: engInsertedApproverList(i).action_type_order_number := engStApprovers(tempIndex).action_type_order_number;
9746: engInsertedApproverList(i).group_or_chain_order_number :=
9747: engStApprovers(tempIndex).group_or_chain_order_number;
9748: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
9749: fnd_log.string
9750: (fnd_log.level_statement
9751: ,'ame_engine.processAdhocInsertions'
9752: ,'Adhoc Insertion approver(after/before approver) ::: ' || engInsertedApproverList(i).name

Line 9749: fnd_log.string

9745: engInsertedApproverList(i).action_type_order_number := engStApprovers(tempIndex).action_type_order_number;
9746: engInsertedApproverList(i).group_or_chain_order_number :=
9747: engStApprovers(tempIndex).group_or_chain_order_number;
9748: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
9749: fnd_log.string
9750: (fnd_log.level_statement
9751: ,'ame_engine.processAdhocInsertions'
9752: ,'Adhoc Insertion approver(after/before approver) ::: ' || engInsertedApproverList(i).name
9753: );

Line 9750: (fnd_log.level_statement

9746: engInsertedApproverList(i).group_or_chain_order_number :=
9747: engStApprovers(tempIndex).group_or_chain_order_number;
9748: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
9749: fnd_log.string
9750: (fnd_log.level_statement
9751: ,'ame_engine.processAdhocInsertions'
9752: ,'Adhoc Insertion approver(after/before approver) ::: ' || engInsertedApproverList(i).name
9753: );
9754: end if;

Line 10098: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

10094: /* asynchronous parallel approver functionality */
10095: if engInsertionOrderTypeList(i) = ame_util.firstPreApprover or
10096: engInsertionOrderTypeList(i) = ame_util.firstPostApprover then
10097: engInsertedApproverList(i).action_type_id := -1;
10098: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10099: fnd_log.string
10100: (fnd_log.level_statement
10101: ,'ame_engine.processAdhocInsertions'
10102: ,'Adhoc Insertion approver(first pre/first post approver) ::: ' || engInsertedApproverList(i).name

Line 10099: fnd_log.string

10095: if engInsertionOrderTypeList(i) = ame_util.firstPreApprover or
10096: engInsertionOrderTypeList(i) = ame_util.firstPostApprover then
10097: engInsertedApproverList(i).action_type_id := -1;
10098: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10099: fnd_log.string
10100: (fnd_log.level_statement
10101: ,'ame_engine.processAdhocInsertions'
10102: ,'Adhoc Insertion approver(first pre/first post approver) ::: ' || engInsertedApproverList(i).name
10103: );

Line 10100: (fnd_log.level_statement

10096: engInsertionOrderTypeList(i) = ame_util.firstPostApprover then
10097: engInsertedApproverList(i).action_type_id := -1;
10098: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10099: fnd_log.string
10100: (fnd_log.level_statement
10101: ,'ame_engine.processAdhocInsertions'
10102: ,'Adhoc Insertion approver(first pre/first post approver) ::: ' || engInsertedApproverList(i).name
10103: );
10104: end if;

Line 10116: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

10112: ,insertionOrderIn => engInsertionOrderList(i));
10113: elsif engInsertionOrderTypeList(i) = ame_util.lastPreApprover or
10114: engInsertionOrderTypeList(i) = ame_util.lastPostApprover then
10115: engInsertedApproverList(i).action_type_id := -2;
10116: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10117: fnd_log.string
10118: (fnd_log.level_statement
10119: ,'ame_engine.processAdhocInsertions'
10120: ,'Adhoc Insertion approver(last pre/last post approver) ::: ' || engInsertedApproverList(i).name

Line 10117: fnd_log.string

10113: elsif engInsertionOrderTypeList(i) = ame_util.lastPreApprover or
10114: engInsertionOrderTypeList(i) = ame_util.lastPostApprover then
10115: engInsertedApproverList(i).action_type_id := -2;
10116: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10117: fnd_log.string
10118: (fnd_log.level_statement
10119: ,'ame_engine.processAdhocInsertions'
10120: ,'Adhoc Insertion approver(last pre/last post approver) ::: ' || engInsertedApproverList(i).name
10121: );

Line 10118: (fnd_log.level_statement

10114: engInsertionOrderTypeList(i) = ame_util.lastPostApprover then
10115: engInsertedApproverList(i).action_type_id := -2;
10116: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10117: fnd_log.string
10118: (fnd_log.level_statement
10119: ,'ame_engine.processAdhocInsertions'
10120: ,'Adhoc Insertion approver(last pre/last post approver) ::: ' || engInsertedApproverList(i).name
10121: );
10122: end if;

Line 10155: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

10151: engStApprovers(j).item_class = parameterFields(3) and
10152: (j = engStApproversCount or
10153: engStApprovers(j + 1).item_id <> parameterFields(2) or
10154: engStApprovers(j + 1).item_class <> parameterFields(3))) then
10155: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10156: fnd_log.string
10157: (fnd_log.level_statement
10158: ,'ame_engine.processAdhocInsertions'
10159: ,'Adhoc Insertion approver(displaced) ::: ' || engInsertedApproverList(displacedInserteeIndexes(i)).name

Line 10156: fnd_log.string

10152: (j = engStApproversCount or
10153: engStApprovers(j + 1).item_id <> parameterFields(2) or
10154: engStApprovers(j + 1).item_class <> parameterFields(3))) then
10155: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10156: fnd_log.string
10157: (fnd_log.level_statement
10158: ,'ame_engine.processAdhocInsertions'
10159: ,'Adhoc Insertion approver(displaced) ::: ' || engInsertedApproverList(displacedInserteeIndexes(i)).name
10160: );

Line 10157: (fnd_log.level_statement

10153: engStApprovers(j + 1).item_id <> parameterFields(2) or
10154: engStApprovers(j + 1).item_class <> parameterFields(3))) then
10155: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10156: fnd_log.string
10157: (fnd_log.level_statement
10158: ,'ame_engine.processAdhocInsertions'
10159: ,'Adhoc Insertion approver(displaced) ::: ' || engInsertedApproverList(displacedInserteeIndexes(i)).name
10160: );
10161: end if;

Line 10174: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

10170: exit;
10171: end if;
10172: end loop;
10173: if(tempBoolean) then
10174: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10175: fnd_log.string
10176: (fnd_log.level_statement
10177: ,'ame_engine.processAdhocInsertions'
10178: ,'Adhoc Insertion approver(displaced) ::: ' || engInsertedApproverList(displacedInserteeIndexes(i)).name

Line 10175: fnd_log.string

10171: end if;
10172: end loop;
10173: if(tempBoolean) then
10174: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10175: fnd_log.string
10176: (fnd_log.level_statement
10177: ,'ame_engine.processAdhocInsertions'
10178: ,'Adhoc Insertion approver(displaced) ::: ' || engInsertedApproverList(displacedInserteeIndexes(i)).name
10179: );

Line 10176: (fnd_log.level_statement

10172: end loop;
10173: if(tempBoolean) then
10174: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10175: fnd_log.string
10176: (fnd_log.level_statement
10177: ,'ame_engine.processAdhocInsertions'
10178: ,'Adhoc Insertion approver(displaced) ::: ' || engInsertedApproverList(displacedInserteeIndexes(i)).name
10179: );
10180: end if;

Line 10244: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

10240: engStProductionsTable(tempIndex).variable_name := engAppParameters(i);
10241: engStProductionsTable(tempIndex).variable_value := engAppParameterTwos(i);
10242: engStProductionsTable(tempIndex).item_class := getHandlerItemClassName;
10243: engStProductionsTable(tempIndex).item_id := getHandlerItemId;
10244: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10245: fnd_log.string
10246: (fnd_log.level_statement
10247: ,'ame_engine.processActionType'
10248: ,'Transaction Production ::: ' || engStProductionsTable(tempIndex).variable_name || '/' || engStProductionsTable(tempIndex).variable_value

Line 10245: fnd_log.string

10241: engStProductionsTable(tempIndex).variable_value := engAppParameterTwos(i);
10242: engStProductionsTable(tempIndex).item_class := getHandlerItemClassName;
10243: engStProductionsTable(tempIndex).item_id := getHandlerItemId;
10244: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10245: fnd_log.string
10246: (fnd_log.level_statement
10247: ,'ame_engine.processActionType'
10248: ,'Transaction Production ::: ' || engStProductionsTable(tempIndex).variable_name || '/' || engStProductionsTable(tempIndex).variable_value
10249: );

Line 10246: (fnd_log.level_statement

10242: engStProductionsTable(tempIndex).item_class := getHandlerItemClassName;
10243: engStProductionsTable(tempIndex).item_id := getHandlerItemId;
10244: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10245: fnd_log.string
10246: (fnd_log.level_statement
10247: ,'ame_engine.processActionType'
10248: ,'Transaction Production ::: ' || engStProductionsTable(tempIndex).variable_name || '/' || engStProductionsTable(tempIndex).variable_value
10249: );
10250: end if;

Line 10262: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

10258: /*
10259: Call the handler for action types other than the production-rule action type.
10260: (Per-approver productions get handled later.)
10261: */
10262: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10263: fnd_log.string
10264: (fnd_log.level_statement
10265: ,'ame_engine.processActionType'
10266: ,'Processing Action Type ::: ' || engAppActionTypeIds(engAppHandlerFirstIndex)

Line 10263: fnd_log.string

10259: Call the handler for action types other than the production-rule action type.
10260: (Per-approver productions get handled later.)
10261: */
10262: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10263: fnd_log.string
10264: (fnd_log.level_statement
10265: ,'ame_engine.processActionType'
10266: ,'Processing Action Type ::: ' || engAppActionTypeIds(engAppHandlerFirstIndex)
10267: );

Line 10264: (fnd_log.level_statement

10260: (Per-approver productions get handled later.)
10261: */
10262: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10263: fnd_log.string
10264: (fnd_log.level_statement
10265: ,'ame_engine.processActionType'
10266: ,'Processing Action Type ::: ' || engAppActionTypeIds(engAppHandlerFirstIndex)
10267: );
10268: end if;

Line 10274: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

10270: 'begin ' ||
10271: getActionTypePackageName(actionTypeIdIn => engAppActionTypeIds(engAppHandlerFirstIndex)) ||
10272: '.handler; end;';
10273: end if;
10274: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10275: fnd_log.string
10276: (fnd_log.level_statement
10277: ,'ame_engine.processActionType'
10278: ,'Completed processing the action Type ::: ' || engAppActionTypeIds(engAppHandlerFirstIndex)

Line 10275: fnd_log.string

10271: getActionTypePackageName(actionTypeIdIn => engAppActionTypeIds(engAppHandlerFirstIndex)) ||
10272: '.handler; end;';
10273: end if;
10274: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10275: fnd_log.string
10276: (fnd_log.level_statement
10277: ,'ame_engine.processActionType'
10278: ,'Completed processing the action Type ::: ' || engAppActionTypeIds(engAppHandlerFirstIndex)
10279: );

Line 10276: (fnd_log.level_statement

10272: '.handler; end;';
10273: end if;
10274: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10275: fnd_log.string
10276: (fnd_log.level_statement
10277: ,'ame_engine.processActionType'
10278: ,'Completed processing the action Type ::: ' || engAppActionTypeIds(engAppHandlerFirstIndex)
10279: );
10280: end if;

Line 10334: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

10330: engStApprovers(j).item_class = engDeletedApproverList(i).item_class) then
10331: engStApprovers(j).approval_status := ame_util.suppressedStatus;
10332: engStApprovers(j).source := ame_util.apiSuppression;
10333: processSuppressDeviation(j,i);
10334: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10335: fnd_log.string
10336: (fnd_log.level_statement
10337: ,'ame_engine.processSuppressions'
10338: ,'Suppressed approver ::: ' || engStApprovers(j).name

Line 10335: fnd_log.string

10331: engStApprovers(j).approval_status := ame_util.suppressedStatus;
10332: engStApprovers(j).source := ame_util.apiSuppression;
10333: processSuppressDeviation(j,i);
10334: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10335: fnd_log.string
10336: (fnd_log.level_statement
10337: ,'ame_engine.processSuppressions'
10338: ,'Suppressed approver ::: ' || engStApprovers(j).name
10339: );

Line 10336: (fnd_log.level_statement

10332: engStApprovers(j).source := ame_util.apiSuppression;
10333: processSuppressDeviation(j,i);
10334: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10335: fnd_log.string
10336: (fnd_log.level_statement
10337: ,'ame_engine.processSuppressions'
10338: ,'Suppressed approver ::: ' || engStApprovers(j).name
10339: );
10340: end if;

Line 10649: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

10645: */
10646: if(engStApprovers(j).approval_status is null and
10647: engStApprovers(j).source not like ame_util.specialForwardInsertion || '%') then
10648: engStApprovers(j).approval_status := ame_util.repeatedStatus;
10649: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10650: fnd_log.string
10651: (fnd_log.level_statement
10652: ,'ame_engine.processRepeatedApprovers'
10653: ,'Repeated Approver ::: ' || engStApprovers(j).name

Line 10650: fnd_log.string

10646: if(engStApprovers(j).approval_status is null and
10647: engStApprovers(j).source not like ame_util.specialForwardInsertion || '%') then
10648: engStApprovers(j).approval_status := ame_util.repeatedStatus;
10649: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10650: fnd_log.string
10651: (fnd_log.level_statement
10652: ,'ame_engine.processRepeatedApprovers'
10653: ,'Repeated Approver ::: ' || engStApprovers(j).name
10654: );

Line 10651: (fnd_log.level_statement

10647: engStApprovers(j).source not like ame_util.specialForwardInsertion || '%') then
10648: engStApprovers(j).approval_status := ame_util.repeatedStatus;
10649: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10650: fnd_log.string
10651: (fnd_log.level_statement
10652: ,'ame_engine.processRepeatedApprovers'
10653: ,'Repeated Approver ::: ' || engStApprovers(j).name
10654: );
10655: end if;

Line 10801: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

10797: end if;
10798: if(currentLastItemIndex is not null) then
10799: /* Process the current item's rules. */
10800: if processOnlyProductionsIn then
10801: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10802: fnd_log.string
10803: (fnd_log.level_statement
10804: ,'ame_engine.processRules'
10805: ,'Processing only production rules'

Line 10802: fnd_log.string

10798: if(currentLastItemIndex is not null) then
10799: /* Process the current item's rules. */
10800: if processOnlyProductionsIn then
10801: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10802: fnd_log.string
10803: (fnd_log.level_statement
10804: ,'ame_engine.processRules'
10805: ,'Processing only production rules'
10806: );

Line 10803: (fnd_log.level_statement

10799: /* Process the current item's rules. */
10800: if processOnlyProductionsIn then
10801: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10802: fnd_log.string
10803: (fnd_log.level_statement
10804: ,'ame_engine.processRules'
10805: ,'Processing only production rules'
10806: );
10807: end if;

Line 10810: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

10806: );
10807: end if;
10808: ruleTypeUpperLimit := 1;
10809: else
10810: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10811: fnd_log.string
10812: (fnd_log.level_statement
10813: ,'ame_engine.processRules'
10814: ,'Processing all rules'

Line 10811: fnd_log.string

10807: end if;
10808: ruleTypeUpperLimit := 1;
10809: else
10810: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10811: fnd_log.string
10812: (fnd_log.level_statement
10813: ,'ame_engine.processRules'
10814: ,'Processing all rules'
10815: );

Line 10812: (fnd_log.level_statement

10808: ruleTypeUpperLimit := 1;
10809: else
10810: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10811: fnd_log.string
10812: (fnd_log.level_statement
10813: ,'ame_engine.processRules'
10814: ,'Processing all rules'
10815: );
10816: end if;

Line 10872: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

10868: exit;
10869: end if;
10870: currentIndex := currentIndex + 1;
10871: end loop;
10872: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10873: if engStApprovers.count = 0 then
10874: fnd_log.string
10875: (fnd_log.level_statement
10876: ,'ame_engine.processRules'

Line 10874: fnd_log.string

10870: currentIndex := currentIndex + 1;
10871: end loop;
10872: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10873: if engStApprovers.count = 0 then
10874: fnd_log.string
10875: (fnd_log.level_statement
10876: ,'ame_engine.processRules'
10877: ,'**************** No Approvers ******************'
10878: );

Line 10875: (fnd_log.level_statement

10871: end loop;
10872: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
10873: if engStApprovers.count = 0 then
10874: fnd_log.string
10875: (fnd_log.level_statement
10876: ,'ame_engine.processRules'
10877: ,'**************** No Approvers ******************'
10878: );
10879: else

Line 10881: fnd_log.string

10877: ,'**************** No Approvers ******************'
10878: );
10879: else
10880: for i in 1 .. engStApprovers.count loop
10881: fnd_log.string
10882: (fnd_log.level_statement
10883: ,'ame_engine.processRules'
10884: ,'Approver ::: ' || engStApprovers(i).name
10885: );

Line 10882: (fnd_log.level_statement

10878: );
10879: else
10880: for i in 1 .. engStApprovers.count loop
10881: fnd_log.string
10882: (fnd_log.level_statement
10883: ,'ame_engine.processRules'
10884: ,'Approver ::: ' || engStApprovers(i).name
10885: );
10886: end loop;

Line 11105: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

11101: adjustMemberOrderNumbers is false */
11102: tempSurrogateApprover.member_order_number := engStApprovers(tempIndex).member_order_number;
11103: tempSurrogateApprover.approver_order_number := engStApprovers(tempIndex).approver_order_number;
11104: /* tempSurrogateApprover.approver_order_number also gets set later. */
11105: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11106: fnd_log.string
11107: (fnd_log.level_statement
11108: ,'ame_engine.processUnresponsiveApprovers'
11109: ,'Unresponsive approver ::: ' || engStApprovers(tempIndex).name || ' Surrogate ::: ' || tempSurrogateApprover.name

Line 11106: fnd_log.string

11102: tempSurrogateApprover.member_order_number := engStApprovers(tempIndex).member_order_number;
11103: tempSurrogateApprover.approver_order_number := engStApprovers(tempIndex).approver_order_number;
11104: /* tempSurrogateApprover.approver_order_number also gets set later. */
11105: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11106: fnd_log.string
11107: (fnd_log.level_statement
11108: ,'ame_engine.processUnresponsiveApprovers'
11109: ,'Unresponsive approver ::: ' || engStApprovers(tempIndex).name || ' Surrogate ::: ' || tempSurrogateApprover.name
11110: );

Line 11107: (fnd_log.level_statement

11103: tempSurrogateApprover.approver_order_number := engStApprovers(tempIndex).approver_order_number;
11104: /* tempSurrogateApprover.approver_order_number also gets set later. */
11105: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11106: fnd_log.string
11107: (fnd_log.level_statement
11108: ,'ame_engine.processUnresponsiveApprovers'
11109: ,'Unresponsive approver ::: ' || engStApprovers(tempIndex).name || ' Surrogate ::: ' || tempSurrogateApprover.name
11110: );
11111: end if;

Line 11806: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

11802: transactionIdIn => transactionIdIn,
11803: ameApplicationIdIn => ameApplicationIdIn,
11804: fndApplicationIdIn => fndApplicationIdIn,
11805: transactionTypeIdIn => transactionTypeIdIn);
11806: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11807: fnd_log.string
11808: (fnd_log.level_statement
11809: ,'ame_engine.updateTransactionState'
11810: ,'AME Application Id ::: ' || engAmeApplicationId

Line 11807: fnd_log.string

11803: ameApplicationIdIn => ameApplicationIdIn,
11804: fndApplicationIdIn => fndApplicationIdIn,
11805: transactionTypeIdIn => transactionTypeIdIn);
11806: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11807: fnd_log.string
11808: (fnd_log.level_statement
11809: ,'ame_engine.updateTransactionState'
11810: ,'AME Application Id ::: ' || engAmeApplicationId
11811: );

Line 11808: (fnd_log.level_statement

11804: fndApplicationIdIn => fndApplicationIdIn,
11805: transactionTypeIdIn => transactionTypeIdIn);
11806: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11807: fnd_log.string
11808: (fnd_log.level_statement
11809: ,'ame_engine.updateTransactionState'
11810: ,'AME Application Id ::: ' || engAmeApplicationId
11811: );
11812: fnd_log.string

Line 11812: fnd_log.string

11808: (fnd_log.level_statement
11809: ,'ame_engine.updateTransactionState'
11810: ,'AME Application Id ::: ' || engAmeApplicationId
11811: );
11812: fnd_log.string
11813: (fnd_log.level_statement
11814: ,'ame_engine.updateTransactionState'
11815: ,'AME Transaction Id ::: ' || engTransactionId
11816: );

Line 11813: (fnd_log.level_statement

11809: ,'ame_engine.updateTransactionState'
11810: ,'AME Application Id ::: ' || engAmeApplicationId
11811: );
11812: fnd_log.string
11813: (fnd_log.level_statement
11814: ,'ame_engine.updateTransactionState'
11815: ,'AME Transaction Id ::: ' || engTransactionId
11816: );
11817: end if;

Line 11843: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

11839: processRules(processOnlyProductionsIn => false);
11840: elsif(processProductionRulesIn) then
11841: processRules(processOnlyProductionsIn => true);
11842: end if;
11843: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11844: fnd_log.string
11845: (fnd_log.level_statement
11846: ,'ame_engine.updateTransactionState'
11847: ,'Approver count after processRules ::: ' || engStApprovers.count

Line 11844: fnd_log.string

11840: elsif(processProductionRulesIn) then
11841: processRules(processOnlyProductionsIn => true);
11842: end if;
11843: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11844: fnd_log.string
11845: (fnd_log.level_statement
11846: ,'ame_engine.updateTransactionState'
11847: ,'Approver count after processRules ::: ' || engStApprovers.count
11848: );

Line 11845: (fnd_log.level_statement

11841: processRules(processOnlyProductionsIn => true);
11842: end if;
11843: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11844: fnd_log.string
11845: (fnd_log.level_statement
11846: ,'ame_engine.updateTransactionState'
11847: ,'Approver count after processRules ::: ' || engStApprovers.count
11848: );
11849: end if;

Line 11853: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

11849: end if;
11850: if(updateCurrentApproverListIn or
11851: updateOldApproverListIn) then
11852: processAdHocInsertions;
11853: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11854: fnd_log.string
11855: (fnd_log.level_statement
11856: ,'ame_engine.updateTransactionState'
11857: ,'Approver count after processAdHocInsertions ::: ' || engStApprovers.count

Line 11854: fnd_log.string

11850: if(updateCurrentApproverListIn or
11851: updateOldApproverListIn) then
11852: processAdHocInsertions;
11853: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11854: fnd_log.string
11855: (fnd_log.level_statement
11856: ,'ame_engine.updateTransactionState'
11857: ,'Approver count after processAdHocInsertions ::: ' || engStApprovers.count
11858: );

Line 11855: (fnd_log.level_statement

11851: updateOldApproverListIn) then
11852: processAdHocInsertions;
11853: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11854: fnd_log.string
11855: (fnd_log.level_statement
11856: ,'ame_engine.updateTransactionState'
11857: ,'Approver count after processAdHocInsertions ::: ' || engStApprovers.count
11858: );
11859: end if;

Line 11861: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

11857: ,'Approver count after processAdHocInsertions ::: ' || engStApprovers.count
11858: );
11859: end if;
11860: processUnresponsiveApprovers;
11861: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11862: fnd_log.string
11863: (fnd_log.level_statement
11864: ,'ame_engine.updateTransactionState'
11865: ,'Approver count after processUnresponsiveApprovers ::: ' || engStApprovers.count

Line 11862: fnd_log.string

11858: );
11859: end if;
11860: processUnresponsiveApprovers;
11861: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11862: fnd_log.string
11863: (fnd_log.level_statement
11864: ,'ame_engine.updateTransactionState'
11865: ,'Approver count after processUnresponsiveApprovers ::: ' || engStApprovers.count
11866: );

Line 11863: (fnd_log.level_statement

11859: end if;
11860: processUnresponsiveApprovers;
11861: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11862: fnd_log.string
11863: (fnd_log.level_statement
11864: ,'ame_engine.updateTransactionState'
11865: ,'Approver count after processUnresponsiveApprovers ::: ' || engStApprovers.count
11866: );
11867: end if;

Line 11870: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

11866: );
11867: end if;
11868: if engRepeatSubstitutions then
11869: repeatSubstitutions;
11870: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11871: fnd_log.string
11872: (fnd_log.level_statement
11873: ,'ame_engine.updateTransactionState'
11874: ,'Approver count after repeatSubstitutions ::: ' || engStApprovers.count

Line 11871: fnd_log.string

11867: end if;
11868: if engRepeatSubstitutions then
11869: repeatSubstitutions;
11870: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11871: fnd_log.string
11872: (fnd_log.level_statement
11873: ,'ame_engine.updateTransactionState'
11874: ,'Approver count after repeatSubstitutions ::: ' || engStApprovers.count
11875: );

Line 11872: (fnd_log.level_statement

11868: if engRepeatSubstitutions then
11869: repeatSubstitutions;
11870: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11871: fnd_log.string
11872: (fnd_log.level_statement
11873: ,'ame_engine.updateTransactionState'
11874: ,'Approver count after repeatSubstitutions ::: ' || engStApprovers.count
11875: );
11876: end if;

Line 11884: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

11880: processSuppressions must precede processRepeatedApprovers, because the latter procedure needs to see
11881: any approver deletions, to aggregate approvers correctly.
11882: */
11883: processSuppressions;
11884: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11885: fnd_log.string
11886: (fnd_log.level_statement
11887: ,'ame_engine.updateTransactionState'
11888: ,'Approver count after processSuppressions ::: ' || engStApprovers.count

Line 11885: fnd_log.string

11881: any approver deletions, to aggregate approvers correctly.
11882: */
11883: processSuppressions;
11884: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11885: fnd_log.string
11886: (fnd_log.level_statement
11887: ,'ame_engine.updateTransactionState'
11888: ,'Approver count after processSuppressions ::: ' || engStApprovers.count
11889: );

Line 11886: (fnd_log.level_statement

11882: */
11883: processSuppressions;
11884: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11885: fnd_log.string
11886: (fnd_log.level_statement
11887: ,'ame_engine.updateTransactionState'
11888: ,'Approver count after processSuppressions ::: ' || engStApprovers.count
11889: );
11890: end if;

Line 11896: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

11892: processSuppressions must precede processRepeatedApprovers so every approver in engStApprovers still
11893: has non-null item_class and item_id fields.
11894: */
11895: processRepeatedApprovers;
11896: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11897: fnd_log.string
11898: (fnd_log.level_statement
11899: ,'ame_engine.updateTransactionState'
11900: ,'Approver count after processRepeatedApprovers ::: ' || engStApprovers.count

Line 11897: fnd_log.string

11893: has non-null item_class and item_id fields.
11894: */
11895: processRepeatedApprovers;
11896: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11897: fnd_log.string
11898: (fnd_log.level_statement
11899: ,'ame_engine.updateTransactionState'
11900: ,'Approver count after processRepeatedApprovers ::: ' || engStApprovers.count
11901: );

Line 11898: (fnd_log.level_statement

11894: */
11895: processRepeatedApprovers;
11896: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11897: fnd_log.string
11898: (fnd_log.level_statement
11899: ,'ame_engine.updateTransactionState'
11900: ,'Approver count after processRepeatedApprovers ::: ' || engStApprovers.count
11901: );
11902: end if;

Line 11920: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then

11916: ,engStApprovalProcessCompleteYN
11917: ,engStApprovers);
11918: end if;
11919: end if;
11920: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11921: if engStApprovers.count = 0 then
11922: fnd_log.string
11923: (fnd_log.level_statement
11924: ,'ame_engine.updateTransactionState'

Line 11922: fnd_log.string

11918: end if;
11919: end if;
11920: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11921: if engStApprovers.count = 0 then
11922: fnd_log.string
11923: (fnd_log.level_statement
11924: ,'ame_engine.updateTransactionState'
11925: ,'**************** No Approvers ******************'
11926: );

Line 11923: (fnd_log.level_statement

11919: end if;
11920: if fnd_log.g_current_runtime_level <= fnd_log.level_statement then
11921: if engStApprovers.count = 0 then
11922: fnd_log.string
11923: (fnd_log.level_statement
11924: ,'ame_engine.updateTransactionState'
11925: ,'**************** No Approvers ******************'
11926: );
11927: else

Line 11929: fnd_log.string

11925: ,'**************** No Approvers ******************'
11926: );
11927: else
11928: for i in 1 .. engStApprovers.count loop
11929: fnd_log.string
11930: (fnd_log.level_statement
11931: ,'ame_engine.updateTransactionState'
11932: ,'Approver ::: ' || engStApprovers(i).name || ' Order Number ::: ' || engStApprovers(i).approver_order_number
11933: );

Line 11930: (fnd_log.level_statement

11926: );
11927: else
11928: for i in 1 .. engStApprovers.count loop
11929: fnd_log.string
11930: (fnd_log.level_statement
11931: ,'ame_engine.updateTransactionState'
11932: ,'Approver ::: ' || engStApprovers(i).name || ' Order Number ::: ' || engStApprovers(i).approver_order_number
11933: );
11934: end loop;