[Home] [Help]
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: END IF;
138: -- Debug Message
139:
140: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': Start');
141:
142: --Initialize message list if p_init_msg_list is TRUE.
143: IF FND_API.To_Boolean (p_init_msg_list) THEN
144: FND_MSG_PUB.initialize;
151: p_approval_rec.action_performed_by);
152:
153: FETCH csr_curr_approver INTO l_approval_access_id, l_approver_id, l_user_name;
154:
155: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_approval_access_id : ' || l_approval_access_id);
156: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_approver_id : ' || l_approver_id);
157: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_user_name : ' || l_user_name);
158: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.action_performed_by : ' || p_approval_rec.action_performed_by);
159: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_type : ' || p_approval_rec.object_type);
152:
153: FETCH csr_curr_approver INTO l_approval_access_id, l_approver_id, l_user_name;
154:
155: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_approval_access_id : ' || l_approval_access_id);
156: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_approver_id : ' || l_approver_id);
157: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_user_name : ' || l_user_name);
158: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.action_performed_by : ' || p_approval_rec.action_performed_by);
159: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_type : ' || p_approval_rec.object_type);
160: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_id : ' || p_approval_rec.object_id);
153: FETCH csr_curr_approver INTO l_approval_access_id, l_approver_id, l_user_name;
154:
155: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_approval_access_id : ' || l_approval_access_id);
156: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_approver_id : ' || l_approver_id);
157: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_user_name : ' || l_user_name);
158: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.action_performed_by : ' || p_approval_rec.action_performed_by);
159: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_type : ' || p_approval_rec.object_type);
160: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_id : ' || p_approval_rec.object_id);
161:
154:
155: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_approval_access_id : ' || l_approval_access_id);
156: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_approver_id : ' || l_approver_id);
157: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_user_name : ' || l_user_name);
158: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.action_performed_by : ' || p_approval_rec.action_performed_by);
159: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_type : ' || p_approval_rec.object_type);
160: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_id : ' || p_approval_rec.object_id);
161:
162: UPDATE DPP_APPROVAL_ACCESS
155: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_approval_access_id : ' || l_approval_access_id);
156: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_approver_id : ' || l_approver_id);
157: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_user_name : ' || l_user_name);
158: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.action_performed_by : ' || p_approval_rec.action_performed_by);
159: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_type : ' || p_approval_rec.object_type);
160: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_id : ' || p_approval_rec.object_id);
161:
162: UPDATE DPP_APPROVAL_ACCESS
163: SET action_code = p_approval_rec.action_code
156: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_approver_id : ' || l_approver_id);
157: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_user_name : ' || l_user_name);
158: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.action_performed_by : ' || p_approval_rec.action_performed_by);
159: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_type : ' || p_approval_rec.object_type);
160: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_id : ' || p_approval_rec.object_id);
161:
162: UPDATE DPP_APPROVAL_ACCESS
163: SET action_code = p_approval_rec.action_code
164: , action_date = SYSDATE
169:
170: CLOSE csr_curr_approver;
171: IF l_approver_found = 'N' THEN
172:
173: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'it comes here l_approver_found : '||l_approver_found);
174:
175: -- get current approval level
176: OPEN csr_approver_level (p_approval_rec.object_type, p_approval_rec.object_id);
177: FETCH csr_approver_level INTO l_approver_level;
218: CLOSE csr_check_reassign_level;
219:
220: -- Debug Message
221:
222: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approval done by user in approval list? ' || l_approver_found );
223: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approver User Id ' || p_approval_rec.action_performed_by );
224: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approver Action ' || p_approval_rec.action_code );
225: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approver Type ' || l_approver_type );
226: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Act Approver User Id ' || l_act_approver_id );
219:
220: -- Debug Message
221:
222: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approval done by user in approval list? ' || l_approver_found );
223: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approver User Id ' || p_approval_rec.action_performed_by );
224: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approver Action ' || p_approval_rec.action_code );
225: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approver Type ' || l_approver_type );
226: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Act Approver User Id ' || l_act_approver_id );
227: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Act Approver Person/User Id ' || l_approver_id );
220: -- Debug Message
221:
222: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approval done by user in approval list? ' || l_approver_found );
223: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approver User Id ' || p_approval_rec.action_performed_by );
224: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approver Action ' || p_approval_rec.action_code );
225: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approver Type ' || l_approver_type );
226: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Act Approver User Id ' || l_act_approver_id );
227: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Act Approver Person/User Id ' || l_approver_id );
228: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Minimum Reassign Level ' || l_min_reassign_level );
221:
222: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approval done by user in approval list? ' || l_approver_found );
223: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approver User Id ' || p_approval_rec.action_performed_by );
224: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approver Action ' || p_approval_rec.action_code );
225: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approver Type ' || l_approver_type );
226: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Act Approver User Id ' || l_act_approver_id );
227: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Act Approver Person/User Id ' || l_approver_id );
228: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Minimum Reassign Level ' || l_min_reassign_level );
229: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_action_code ' || l_action_code );
222: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approval done by user in approval list? ' || l_approver_found );
223: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approver User Id ' || p_approval_rec.action_performed_by );
224: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approver Action ' || p_approval_rec.action_code );
225: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approver Type ' || l_approver_type );
226: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Act Approver User Id ' || l_act_approver_id );
227: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Act Approver Person/User Id ' || l_approver_id );
228: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Minimum Reassign Level ' || l_min_reassign_level );
229: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_action_code ' || l_action_code );
230:
223: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approver User Id ' || p_approval_rec.action_performed_by );
224: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approver Action ' || p_approval_rec.action_code );
225: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approver Type ' || l_approver_type );
226: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Act Approver User Id ' || l_act_approver_id );
227: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Act Approver Person/User Id ' || l_approver_id );
228: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Minimum Reassign Level ' || l_min_reassign_level );
229: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_action_code ' || l_action_code );
230:
231: /*
224: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approver Action ' || p_approval_rec.action_code );
225: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approver Type ' || l_approver_type );
226: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Act Approver User Id ' || l_act_approver_id );
227: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Act Approver Person/User Id ' || l_approver_id );
228: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Minimum Reassign Level ' || l_min_reassign_level );
229: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_action_code ' || l_action_code );
230:
231: /*
232: Check for minimum Reassign Level is added because , if it is 0 then the case is No AME Rule was
225: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Approver Type ' || l_approver_type );
226: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Act Approver User Id ' || l_act_approver_id );
227: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Act Approver Person/User Id ' || l_approver_id );
228: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Minimum Reassign Level ' || l_min_reassign_level );
229: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_action_code ' || l_action_code );
230:
231: /*
232: Check for minimum Reassign Level is added because , if it is 0 then the case is No AME Rule was
233: found for Transaction and Default approver was found from profile
234: */
235: if l_min_reassign_level <> 0 AND l_action_code is NULL then
236: -- Update AME with approvers action
237:
238: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Inside if l_min_reassign_level <> 0 AND l_action_code is NULL then' );
239:
240: l_ame_approver_rec.orig_system_id := l_approver_id;
241:
242: IF p_approval_rec.action_code = 'REJECT' THEN
240: l_ame_approver_rec.orig_system_id := l_approver_id;
241:
242: IF p_approval_rec.action_code = 'REJECT' THEN
243:
244: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'IF p_approval_rec.action_code = REJECT THEN' );
245:
246: -- Rejection of Request
247: l_ame_approver_rec.approval_status := AME_UTIL.rejectStatus;
248:
247: l_ame_approver_rec.approval_status := AME_UTIL.rejectStatus;
248:
249: ELSIF p_approval_rec.action_code = 'APPROVE' THEN
250:
251: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'ELSIF p_approval_rec.action_code = APPROVE THEN' );
252:
253: -- Approval of Request
254: l_ame_approver_rec.approval_status := AME_UTIL.approvedStatus;
255: END IF;
270: ,transactionTypeIn => p_approval_rec.object_type
271: );
272: end if; -- End if minimum reassign Level not 0
273:
274: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Revoke Access ' || p_approval_rec.action_code );
275:
276: -- Revoke_Access - Revoke acces to previous appprovers in the chain
277: Revoke_Access(
278: p_api_version => p_api_version
291: END IF;
292:
293: -- Debug Message
294:
295: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': End');
296:
297: --Standard call to get message count and if count=1, get the message
298: FND_MSG_PUB.Count_And_Get (
299: p_encoded => FND_API.G_FALSE,
405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
406: END IF;
407: -- Debug Message
408:
409: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': Start');
410:
411: --Initialize message list if p_init_msg_list is TRUE.
412: IF FND_API.To_Boolean (p_init_msg_list) THEN
413: FND_MSG_PUB.initialize;
421:
422: -- increment approval level by 1 for next approval;
423: l_approver_level := l_approver_level + 1;
424:
425: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_application_id:'|| l_application_id);
426: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_id:'|| p_approval_rec.object_id);
427: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_type:'|| p_approval_rec.object_type);
428:
429: -- Get Approver list from Approvals Manager
422: -- increment approval level by 1 for next approval;
423: l_approver_level := l_approver_level + 1;
424:
425: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_application_id:'|| l_application_id);
426: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_id:'|| p_approval_rec.object_id);
427: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_type:'|| p_approval_rec.object_type);
428:
429: -- Get Approver list from Approvals Manager
430: AME_API2.getNextApprovers4(applicationIdIn => l_application_id,
423: l_approver_level := l_approver_level + 1;
424:
425: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_application_id:'|| l_application_id);
426: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_id:'|| p_approval_rec.object_id);
427: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_type:'|| p_approval_rec.object_type);
428:
429: -- Get Approver list from Approvals Manager
430: AME_API2.getNextApprovers4(applicationIdIn => l_application_id,
431: transactionTypeIn => p_approval_rec.object_type,
434: nextApproversOut => l_next_approver);
435:
436: FOR i IN 1..l_next_approver.COUNT LOOP
437:
438: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.name : ' || l_next_approver(i).name);
439: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.orig_system : ' || l_next_approver(i).orig_system);
440: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.orig_system_id : ' || l_next_approver(i).orig_system_id);
441: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.display_name : ' || l_next_approver(i).display_name);
442: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.approver_category : ' || l_next_approver(i).approver_category);
435:
436: FOR i IN 1..l_next_approver.COUNT LOOP
437:
438: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.name : ' || l_next_approver(i).name);
439: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.orig_system : ' || l_next_approver(i).orig_system);
440: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.orig_system_id : ' || l_next_approver(i).orig_system_id);
441: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.display_name : ' || l_next_approver(i).display_name);
442: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.approver_category : ' || l_next_approver(i).approver_category);
443: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.api_insertion : ' || l_next_approver(i).api_insertion);
436: FOR i IN 1..l_next_approver.COUNT LOOP
437:
438: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.name : ' || l_next_approver(i).name);
439: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.orig_system : ' || l_next_approver(i).orig_system);
440: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.orig_system_id : ' || l_next_approver(i).orig_system_id);
441: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.display_name : ' || l_next_approver(i).display_name);
442: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.approver_category : ' || l_next_approver(i).approver_category);
443: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.api_insertion : ' || l_next_approver(i).api_insertion);
444: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.authority : ' || l_next_approver(i).authority);
437:
438: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.name : ' || l_next_approver(i).name);
439: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.orig_system : ' || l_next_approver(i).orig_system);
440: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.orig_system_id : ' || l_next_approver(i).orig_system_id);
441: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.display_name : ' || l_next_approver(i).display_name);
442: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.approver_category : ' || l_next_approver(i).approver_category);
443: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.api_insertion : ' || l_next_approver(i).api_insertion);
444: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.authority : ' || l_next_approver(i).authority);
445: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.approval_status : ' || l_next_approver(i).approval_status);
438: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.name : ' || l_next_approver(i).name);
439: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.orig_system : ' || l_next_approver(i).orig_system);
440: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.orig_system_id : ' || l_next_approver(i).orig_system_id);
441: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.display_name : ' || l_next_approver(i).display_name);
442: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.approver_category : ' || l_next_approver(i).approver_category);
443: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.api_insertion : ' || l_next_approver(i).api_insertion);
444: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.authority : ' || l_next_approver(i).authority);
445: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.approval_status : ' || l_next_approver(i).approval_status);
446: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.action_type_id : ' || l_next_approver(i).action_type_id);
439: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.orig_system : ' || l_next_approver(i).orig_system);
440: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.orig_system_id : ' || l_next_approver(i).orig_system_id);
441: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.display_name : ' || l_next_approver(i).display_name);
442: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.approver_category : ' || l_next_approver(i).approver_category);
443: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.api_insertion : ' || l_next_approver(i).api_insertion);
444: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.authority : ' || l_next_approver(i).authority);
445: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.approval_status : ' || l_next_approver(i).approval_status);
446: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.action_type_id : ' || l_next_approver(i).action_type_id);
447: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.group_or_chain_id : ' || l_next_approver(i).group_or_chain_id);
440: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.orig_system_id : ' || l_next_approver(i).orig_system_id);
441: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.display_name : ' || l_next_approver(i).display_name);
442: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.approver_category : ' || l_next_approver(i).approver_category);
443: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.api_insertion : ' || l_next_approver(i).api_insertion);
444: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.authority : ' || l_next_approver(i).authority);
445: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.approval_status : ' || l_next_approver(i).approval_status);
446: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.action_type_id : ' || l_next_approver(i).action_type_id);
447: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.group_or_chain_id : ' || l_next_approver(i).group_or_chain_id);
448: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.occurrence : ' || l_next_approver(i).occurrence);
441: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.display_name : ' || l_next_approver(i).display_name);
442: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.approver_category : ' || l_next_approver(i).approver_category);
443: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.api_insertion : ' || l_next_approver(i).api_insertion);
444: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.authority : ' || l_next_approver(i).authority);
445: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.approval_status : ' || l_next_approver(i).approval_status);
446: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.action_type_id : ' || l_next_approver(i).action_type_id);
447: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.group_or_chain_id : ' || l_next_approver(i).group_or_chain_id);
448: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.occurrence : ' || l_next_approver(i).occurrence);
449: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.source : ' || l_next_approver(i).source);
442: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.approver_category : ' || l_next_approver(i).approver_category);
443: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.api_insertion : ' || l_next_approver(i).api_insertion);
444: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.authority : ' || l_next_approver(i).authority);
445: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.approval_status : ' || l_next_approver(i).approval_status);
446: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.action_type_id : ' || l_next_approver(i).action_type_id);
447: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.group_or_chain_id : ' || l_next_approver(i).group_or_chain_id);
448: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.occurrence : ' || l_next_approver(i).occurrence);
449: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.source : ' || l_next_approver(i).source);
450: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_class : ' || l_next_approver(i).item_class);
443: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.api_insertion : ' || l_next_approver(i).api_insertion);
444: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.authority : ' || l_next_approver(i).authority);
445: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.approval_status : ' || l_next_approver(i).approval_status);
446: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.action_type_id : ' || l_next_approver(i).action_type_id);
447: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.group_or_chain_id : ' || l_next_approver(i).group_or_chain_id);
448: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.occurrence : ' || l_next_approver(i).occurrence);
449: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.source : ' || l_next_approver(i).source);
450: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_class : ' || l_next_approver(i).item_class);
451: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_id: ' || l_next_approver(i).item_id);
444: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.authority : ' || l_next_approver(i).authority);
445: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.approval_status : ' || l_next_approver(i).approval_status);
446: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.action_type_id : ' || l_next_approver(i).action_type_id);
447: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.group_or_chain_id : ' || l_next_approver(i).group_or_chain_id);
448: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.occurrence : ' || l_next_approver(i).occurrence);
449: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.source : ' || l_next_approver(i).source);
450: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_class : ' || l_next_approver(i).item_class);
451: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_id: ' || l_next_approver(i).item_id);
452: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_class_order_number : ' || l_next_approver(i).item_class_order_number);
445: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.approval_status : ' || l_next_approver(i).approval_status);
446: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.action_type_id : ' || l_next_approver(i).action_type_id);
447: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.group_or_chain_id : ' || l_next_approver(i).group_or_chain_id);
448: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.occurrence : ' || l_next_approver(i).occurrence);
449: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.source : ' || l_next_approver(i).source);
450: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_class : ' || l_next_approver(i).item_class);
451: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_id: ' || l_next_approver(i).item_id);
452: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_class_order_number : ' || l_next_approver(i).item_class_order_number);
453: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_order_number : ' || l_next_approver(i).item_order_number);
446: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.action_type_id : ' || l_next_approver(i).action_type_id);
447: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.group_or_chain_id : ' || l_next_approver(i).group_or_chain_id);
448: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.occurrence : ' || l_next_approver(i).occurrence);
449: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.source : ' || l_next_approver(i).source);
450: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_class : ' || l_next_approver(i).item_class);
451: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_id: ' || l_next_approver(i).item_id);
452: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_class_order_number : ' || l_next_approver(i).item_class_order_number);
453: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_order_number : ' || l_next_approver(i).item_order_number);
454: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.sub_list_order_number : ' || l_next_approver(i).sub_list_order_number);
447: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.group_or_chain_id : ' || l_next_approver(i).group_or_chain_id);
448: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.occurrence : ' || l_next_approver(i).occurrence);
449: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.source : ' || l_next_approver(i).source);
450: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_class : ' || l_next_approver(i).item_class);
451: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_id: ' || l_next_approver(i).item_id);
452: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_class_order_number : ' || l_next_approver(i).item_class_order_number);
453: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_order_number : ' || l_next_approver(i).item_order_number);
454: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.sub_list_order_number : ' || l_next_approver(i).sub_list_order_number);
455: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.action_type_order_number : ' || l_next_approver(i).action_type_order_number);
448: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.occurrence : ' || l_next_approver(i).occurrence);
449: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.source : ' || l_next_approver(i).source);
450: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_class : ' || l_next_approver(i).item_class);
451: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_id: ' || l_next_approver(i).item_id);
452: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_class_order_number : ' || l_next_approver(i).item_class_order_number);
453: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_order_number : ' || l_next_approver(i).item_order_number);
454: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.sub_list_order_number : ' || l_next_approver(i).sub_list_order_number);
455: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.action_type_order_number : ' || l_next_approver(i).action_type_order_number);
456: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.group_or_chain_order_number : ' || l_next_approver(i).group_or_chain_order_number);
449: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.source : ' || l_next_approver(i).source);
450: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_class : ' || l_next_approver(i).item_class);
451: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_id: ' || l_next_approver(i).item_id);
452: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_class_order_number : ' || l_next_approver(i).item_class_order_number);
453: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_order_number : ' || l_next_approver(i).item_order_number);
454: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.sub_list_order_number : ' || l_next_approver(i).sub_list_order_number);
455: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.action_type_order_number : ' || l_next_approver(i).action_type_order_number);
456: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.group_or_chain_order_number : ' || l_next_approver(i).group_or_chain_order_number);
457: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.member_order_number : ' || l_next_approver(i).member_order_number);
450: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_class : ' || l_next_approver(i).item_class);
451: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_id: ' || l_next_approver(i).item_id);
452: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_class_order_number : ' || l_next_approver(i).item_class_order_number);
453: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_order_number : ' || l_next_approver(i).item_order_number);
454: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.sub_list_order_number : ' || l_next_approver(i).sub_list_order_number);
455: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.action_type_order_number : ' || l_next_approver(i).action_type_order_number);
456: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.group_or_chain_order_number : ' || l_next_approver(i).group_or_chain_order_number);
457: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.member_order_number : ' || l_next_approver(i).member_order_number);
458: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.approver_order_number : ' || l_next_approver(i).approver_order_number);
451: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_id: ' || l_next_approver(i).item_id);
452: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_class_order_number : ' || l_next_approver(i).item_class_order_number);
453: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_order_number : ' || l_next_approver(i).item_order_number);
454: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.sub_list_order_number : ' || l_next_approver(i).sub_list_order_number);
455: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.action_type_order_number : ' || l_next_approver(i).action_type_order_number);
456: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.group_or_chain_order_number : ' || l_next_approver(i).group_or_chain_order_number);
457: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.member_order_number : ' || l_next_approver(i).member_order_number);
458: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.approver_order_number : ' || l_next_approver(i).approver_order_number);
459:
452: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_class_order_number : ' || l_next_approver(i).item_class_order_number);
453: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_order_number : ' || l_next_approver(i).item_order_number);
454: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.sub_list_order_number : ' || l_next_approver(i).sub_list_order_number);
455: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.action_type_order_number : ' || l_next_approver(i).action_type_order_number);
456: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.group_or_chain_order_number : ' || l_next_approver(i).group_or_chain_order_number);
457: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.member_order_number : ' || l_next_approver(i).member_order_number);
458: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.approver_order_number : ' || l_next_approver(i).approver_order_number);
459:
460: END LOOP;
453: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.item_order_number : ' || l_next_approver(i).item_order_number);
454: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.sub_list_order_number : ' || l_next_approver(i).sub_list_order_number);
455: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.action_type_order_number : ' || l_next_approver(i).action_type_order_number);
456: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.group_or_chain_order_number : ' || l_next_approver(i).group_or_chain_order_number);
457: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.member_order_number : ' || l_next_approver(i).member_order_number);
458: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.approver_order_number : ' || l_next_approver(i).approver_order_number);
459:
460: END LOOP;
461:
454: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.sub_list_order_number : ' || l_next_approver(i).sub_list_order_number);
455: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.action_type_order_number : ' || l_next_approver(i).action_type_order_number);
456: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.group_or_chain_order_number : ' || l_next_approver(i).group_or_chain_order_number);
457: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.member_order_number : ' || l_next_approver(i).member_order_number);
458: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_next_approver.approver_order_number : ' || l_next_approver(i).approver_order_number);
459:
460: END LOOP;
461:
462: --IF l_next_approver.person_id IS NULL AND
463: -- l_next_approver.user_id IS NULL AND
464: -- l_next_approver.approval_status IS NULL
465: --THEN
466:
467: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Get_Approvers:l_approvalProcessCompleteYNOut ' || l_approvalProcessCompleteYNOut);
468:
469: IF l_approvalProcessCompleteYNOut=ame_util2.completeNoApprovers THEN
470:
471: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'AME did not return any approvers in AME_API.getNextApprover call');
467: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Get_Approvers:l_approvalProcessCompleteYNOut ' || l_approvalProcessCompleteYNOut);
468:
469: IF l_approvalProcessCompleteYNOut=ame_util2.completeNoApprovers THEN
470:
471: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'AME did not return any approvers in AME_API.getNextApprover call');
472:
473: -- If first approval, get default approver from profile
474: IF p_approval_rec.action_code = 'SUBMIT' THEN
475:
472:
473: -- If first approval, get default approver from profile
474: IF p_approval_rec.action_code = 'SUBMIT' THEN
475:
476: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Defulting to 1 as default approver');
477:
478: -- Get default approver
479: x_approvers := approvers_tbl_type ();
480: x_approvers.extend;
489: END IF;
490: -- If final approval, convey that information
491: IF p_approval_rec.action_code = 'APPROVE' THEN
492:
493: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Setting to final approval');
494:
495: x_final_approval_flag := 'Y';
496: END IF;
497: ELSE
495: x_final_approval_flag := 'Y';
496: END IF;
497: ELSE
498:
499: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Get_Approvers : l_next_approver.COUNT ' || l_next_approver.COUNT);
500: FOR i IN 1..l_next_approver.COUNT LOOP
501: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Get_Approvers : l_next_approver.orig_system ' || l_next_approver(i).orig_system);
502: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Get_Approvers : l_next_approver.orig_system_id ' || l_next_approver(i).orig_system_id);
503: END LOOP;
497: ELSE
498:
499: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Get_Approvers : l_next_approver.COUNT ' || l_next_approver.COUNT);
500: FOR i IN 1..l_next_approver.COUNT LOOP
501: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Get_Approvers : l_next_approver.orig_system ' || l_next_approver(i).orig_system);
502: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Get_Approvers : l_next_approver.orig_system_id ' || l_next_approver(i).orig_system_id);
503: END LOOP;
504:
505: IF l_approvalProcessCompleteYNOut = ame_util.booleanTrue THEN
498:
499: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Get_Approvers : l_next_approver.COUNT ' || l_next_approver.COUNT);
500: FOR i IN 1..l_next_approver.COUNT LOOP
501: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Get_Approvers : l_next_approver.orig_system ' || l_next_approver(i).orig_system);
502: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Get_Approvers : l_next_approver.orig_system_id ' || l_next_approver(i).orig_system_id);
503: END LOOP;
504:
505: IF l_approvalProcessCompleteYNOut = ame_util.booleanTrue THEN
506: x_final_approval_flag := 'Y';
513:
514: FOR i IN 1..l_next_approver.COUNT LOOP
515: l_currApprRec := l_next_approver(i);
516:
517: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'getapprovers inside for loop l_currApprRec.orig_system ' || l_currApprRec.orig_system);
518:
519: x_approvers.extend;
520: IF (l_currApprRec.orig_system = 'FND_USR') then
521: x_approvers(i).approver_type := 'USER';
630: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
631: END IF;
632: -- Debug Message
633:
634: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': Start');
635:
636: --Initialize message list if p_init_msg_list is TRUE.
637: IF FND_API.To_Boolean (p_init_msg_list) THEN
638: FND_MSG_PUB.initialize;
639: END IF;
640: --Initialize API return status to sucess
641: x_return_status := FND_API.G_RET_STS_SUCCESS;
642:
643: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_application_id:'|| l_application_id);
644: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_id:'|| p_approval_rec.object_id);
645: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_type:'|| p_approval_rec.object_type);
646:
647: --Get all the approvers for this transaction from Approvals Manager
640: --Initialize API return status to sucess
641: x_return_status := FND_API.G_RET_STS_SUCCESS;
642:
643: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_application_id:'|| l_application_id);
644: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_id:'|| p_approval_rec.object_id);
645: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_type:'|| p_approval_rec.object_type);
646:
647: --Get all the approvers for this transaction from Approvals Manager
648: ame_api2.getAllApprovers7
641: x_return_status := FND_API.G_RET_STS_SUCCESS;
642:
643: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_application_id:'|| l_application_id);
644: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_id:'|| p_approval_rec.object_id);
645: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_type:'|| p_approval_rec.object_type);
646:
647: --Get all the approvers for this transaction from Approvals Manager
648: ame_api2.getAllApprovers7
649: (applicationIdIn => l_application_id
651: ,transactionIdIn => p_approval_rec.object_id
652: ,approvalProcessCompleteYNOut => l_approvalProcessCompleteYNOut
653: ,approversOut => l_approversOut);
654:
655: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'ame_api2.getAllApprovers7 l_approversOut.COUNT : '|| l_approversOut.COUNT);
656: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'ame_api2.getAllApprovers7 l_approvalProcessCompleteYNOut : '|| l_approvalProcessCompleteYNOut);
657:
658: IF l_approversOut.COUNT = 0 THEN --No approver found in AME
659:
652: ,approvalProcessCompleteYNOut => l_approvalProcessCompleteYNOut
653: ,approversOut => l_approversOut);
654:
655: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'ame_api2.getAllApprovers7 l_approversOut.COUNT : '|| l_approversOut.COUNT);
656: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'ame_api2.getAllApprovers7 l_approvalProcessCompleteYNOut : '|| l_approvalProcessCompleteYNOut);
657:
658: IF l_approversOut.COUNT = 0 THEN --No approver found in AME
659:
660: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'AME did not return any approvers in AME_API.getAllApprovers call');
656: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'ame_api2.getAllApprovers7 l_approvalProcessCompleteYNOut : '|| l_approvalProcessCompleteYNOut);
657:
658: IF l_approversOut.COUNT = 0 THEN --No approver found in AME
659:
660: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'AME did not return any approvers in AME_API.getAllApprovers call');
661: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Get the default approver from the profile value');
662:
663: -- Get default approver from profile (default approver)
664: IF p_approval_rec.object_type = 'PRICE PROTECTION' THEN
657:
658: IF l_approversOut.COUNT = 0 THEN --No approver found in AME
659:
660: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'AME did not return any approvers in AME_API.getAllApprovers call');
661: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Get the default approver from the profile value');
662:
663: -- Get default approver from profile (default approver)
664: IF p_approval_rec.object_type = 'PRICE PROTECTION' THEN
665: l_approver_id := to_number(fnd_profile.value('DPP_TXN_DEFAULT_APPROVER'));
690: ELSE
691: FND_MESSAGE.set_name('DPP', 'DPP_AME_NO_APP');
692: FND_MSG_PUB.add;
693:
694: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'No default approver set for the object type : '||p_approval_rec.object_type);
695:
696: END IF;
697: ELSE -- Approver set up found in AME
698:
695:
696: END IF;
697: ELSE -- Approver set up found in AME
698:
699: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'AME returned approvers');
700:
701: --Assign the value to the out table type
702: FOR i IN l_approversOut.FIRST..l_approversOut.LAST LOOP
703: --Check if the person id is returned
702: FOR i IN l_approversOut.FIRST..l_approversOut.LAST LOOP
703: --Check if the person id is returned
704: IF l_approversOut(i).orig_system_id IS NOT NULL THEN
705:
706: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Person ID : '||l_approversOut(i).orig_system_id);
707: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Orig System : '||l_approversOut(i).orig_system);
708:
709: BEGIN
710: SELECT email_address
703: --Check if the person id is returned
704: IF l_approversOut(i).orig_system_id IS NOT NULL THEN
705:
706: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Person ID : '||l_approversOut(i).orig_system_id);
707: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Orig System : '||l_approversOut(i).orig_system);
708:
709: BEGIN
710: SELECT email_address
711: INTO l_approver_email
712: FROM wf_roles
713: WHERE orig_system_id = l_approversOut(i).orig_system_id
714: AND orig_system = l_approversOut(i).orig_system;
715:
716: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_approver_email ' || l_approver_email);
717:
718: EXCEPTION
719: WHEN NO_DATA_FOUND THEN
720: l_approver_email := NULL;
730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
731: END;
732: ELSE -- Both the person id and the user id are null
733:
734: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'No details retrieved for the Approver ');
735:
736: FND_MESSAGE.set_name('DPP', 'DPP_NO_APP_DETAIL');
737: FND_MSG_PUB.add;
738: l_approver_email := NULL;
794: END LOOP;
795: END IF;
796: -- Debug Message
797:
798: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': End');
799:
800: --Standard call to get message count and if count=1, get the message
801: FND_MSG_PUB.Count_And_Get (
802: p_encoded => FND_API.G_FALSE,
893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
894: END IF;
895: -- Debug Message
896:
897: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': Start');
898:
899: --Initialize message list if p_init_msg_list is TRUE.
900: IF FND_API.To_Boolean (p_init_msg_list) THEN
901: FND_MSG_PUB.initialize;
910: );
911:
912: -- Debug Message
913:
914: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': End');
915:
916: --Standard call to get message count and if count=1, get the message
917: FND_MSG_PUB.Count_And_Get (
918: p_encoded => FND_API.G_FALSE,
1012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1013: END IF;
1014: -- Debug Message
1015:
1016: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': Start');
1017:
1018: --Initialize message list if p_init_msg_list is TRUE.
1019: IF FND_API.To_Boolean (p_init_msg_list) THEN
1020: FND_MSG_PUB.initialize;
1040:
1041: -- Validate if the approvers record is valid
1042: FOR i in 1..p_approvers.count LOOP
1043:
1044: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'i ' || i);
1045: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'add access for loop if approver type ' || p_approvers(i).approver_type);
1046:
1047: IF p_approvers(i).approver_type <> 'USER' and p_approvers(i).approver_type <> 'PERSON' THEN
1048: IF DPP_ERROR_ON THEN
1041: -- Validate if the approvers record is valid
1042: FOR i in 1..p_approvers.count LOOP
1043:
1044: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'i ' || i);
1045: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'add access for loop if approver type ' || p_approvers(i).approver_type);
1046:
1047: IF p_approvers(i).approver_type <> 'USER' and p_approvers(i).approver_type <> 'PERSON' THEN
1048: IF DPP_ERROR_ON THEN
1049: dpp_utility_pvt.error_message('OZF_APPROVER_NOT_USER');
1065: FOR i in 1..p_approvers.count LOOP
1066:
1067: BEGIN
1068:
1069: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'before Inserting data into DPP_APPROVAL_ACCESS table');
1070: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_approval_access_id ' || l_approval_access_id);
1071: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'G_USER_ID ' || G_USER_ID);
1072: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'G_LOGIN_ID ' || G_LOGIN_ID);
1073: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_type ' || p_approval_rec.object_type);
1066:
1067: BEGIN
1068:
1069: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'before Inserting data into DPP_APPROVAL_ACCESS table');
1070: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_approval_access_id ' || l_approval_access_id);
1071: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'G_USER_ID ' || G_USER_ID);
1072: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'G_LOGIN_ID ' || G_LOGIN_ID);
1073: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_type ' || p_approval_rec.object_type);
1074: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_id ' || p_approval_rec.object_id);
1067: BEGIN
1068:
1069: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'before Inserting data into DPP_APPROVAL_ACCESS table');
1070: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_approval_access_id ' || l_approval_access_id);
1071: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'G_USER_ID ' || G_USER_ID);
1072: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'G_LOGIN_ID ' || G_LOGIN_ID);
1073: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_type ' || p_approval_rec.object_type);
1074: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_id ' || p_approval_rec.object_id);
1075: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approvers(i).approver_level ' || p_approvers(i).approver_level);
1068:
1069: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'before Inserting data into DPP_APPROVAL_ACCESS table');
1070: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_approval_access_id ' || l_approval_access_id);
1071: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'G_USER_ID ' || G_USER_ID);
1072: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'G_LOGIN_ID ' || G_LOGIN_ID);
1073: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_type ' || p_approval_rec.object_type);
1074: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_id ' || p_approval_rec.object_id);
1075: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approvers(i).approver_level ' || p_approvers(i).approver_level);
1076: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approvers(i).approver_type ' || p_approvers(i).approver_type);
1069: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'before Inserting data into DPP_APPROVAL_ACCESS table');
1070: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_approval_access_id ' || l_approval_access_id);
1071: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'G_USER_ID ' || G_USER_ID);
1072: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'G_LOGIN_ID ' || G_LOGIN_ID);
1073: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_type ' || p_approval_rec.object_type);
1074: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_id ' || p_approval_rec.object_id);
1075: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approvers(i).approver_level ' || p_approvers(i).approver_level);
1076: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approvers(i).approver_type ' || p_approvers(i).approver_type);
1077: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approvers(i).approver_id ' || p_approvers(i).approver_id);
1070: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_approval_access_id ' || l_approval_access_id);
1071: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'G_USER_ID ' || G_USER_ID);
1072: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'G_LOGIN_ID ' || G_LOGIN_ID);
1073: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_type ' || p_approval_rec.object_type);
1074: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_id ' || p_approval_rec.object_id);
1075: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approvers(i).approver_level ' || p_approvers(i).approver_level);
1076: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approvers(i).approver_type ' || p_approvers(i).approver_type);
1077: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approvers(i).approver_id ' || p_approvers(i).approver_id);
1078: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_workflow_itemkey ' || l_workflow_itemkey);
1071: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'G_USER_ID ' || G_USER_ID);
1072: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'G_LOGIN_ID ' || G_LOGIN_ID);
1073: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_type ' || p_approval_rec.object_type);
1074: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_id ' || p_approval_rec.object_id);
1075: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approvers(i).approver_level ' || p_approvers(i).approver_level);
1076: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approvers(i).approver_type ' || p_approvers(i).approver_type);
1077: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approvers(i).approver_id ' || p_approvers(i).approver_id);
1078: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_workflow_itemkey ' || l_workflow_itemkey);
1079:
1072: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'G_LOGIN_ID ' || G_LOGIN_ID);
1073: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_type ' || p_approval_rec.object_type);
1074: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_id ' || p_approval_rec.object_id);
1075: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approvers(i).approver_level ' || p_approvers(i).approver_level);
1076: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approvers(i).approver_type ' || p_approvers(i).approver_type);
1077: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approvers(i).approver_id ' || p_approvers(i).approver_id);
1078: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_workflow_itemkey ' || l_workflow_itemkey);
1079:
1080: INSERT INTO DPP_APPROVAL_ACCESS(
1073: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_type ' || p_approval_rec.object_type);
1074: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_id ' || p_approval_rec.object_id);
1075: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approvers(i).approver_level ' || p_approvers(i).approver_level);
1076: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approvers(i).approver_type ' || p_approvers(i).approver_type);
1077: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approvers(i).approver_id ' || p_approvers(i).approver_id);
1078: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_workflow_itemkey ' || l_workflow_itemkey);
1079:
1080: INSERT INTO DPP_APPROVAL_ACCESS(
1081: approval_access_id
1074: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approval_rec.object_id ' || p_approval_rec.object_id);
1075: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approvers(i).approver_level ' || p_approvers(i).approver_level);
1076: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approvers(i).approver_type ' || p_approvers(i).approver_type);
1077: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'p_approvers(i).approver_id ' || p_approvers(i).approver_id);
1078: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_workflow_itemkey ' || l_workflow_itemkey);
1079:
1080: INSERT INTO DPP_APPROVAL_ACCESS(
1081: approval_access_id
1082: ,object_version_number
1108: ,'Y'
1109: ,l_workflow_itemkey
1110: );
1111:
1112: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'after Inserting data into DPP_APPROVAL_ACCESS table');
1113:
1114: EXCEPTION
1115: WHEN OTHERS THEN
1116: IF DPP_ERROR_ON THEN
1126: COMMIT WORK;
1127: END IF;
1128: -- Debug Message
1129:
1130: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': End');
1131:
1132: --Standard call to get message count and if count=1, get the message
1133: FND_MSG_PUB.Count_And_Get (
1134: p_encoded => FND_API.G_FALSE,
1250: -- Update records in DPP_APPROVAL_ACCESS_all to revoke access
1251: OPEN csr_curr_approvers(p_object_type, p_object_id);
1252: LOOP
1253:
1254: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'inside revoke access');
1255:
1256: FETCH csr_curr_approvers INTO l_approval_access_id;
1257: EXIT WHEN csr_curr_approvers%NOTFOUND;
1258:
1255:
1256: FETCH csr_curr_approvers INTO l_approval_access_id;
1257: EXIT WHEN csr_curr_approvers%NOTFOUND;
1258:
1259: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'inside revoke access l_approval_access_id > ' || l_approval_access_id);
1260:
1261: -- Update approval access table to revoke access
1262: UPDATE DPP_APPROVAL_ACCESS
1263: SET approval_access_flag = 'N'
1270:
1271: --Standard check of commit
1272: IF FND_API.To_Boolean ( p_commit ) THEN
1273:
1274: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Inside Commit ');
1275:
1276: COMMIT WORK;
1277: END IF;
1278: -- Debug Message
1276: COMMIT WORK;
1277: END IF;
1278: -- Debug Message
1279:
1280: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': End');
1281:
1282: --Standard call to get message count and if count=1, get the message
1283: FND_MSG_PUB.Count_And_Get (
1284: p_encoded => FND_API.G_FALSE,
1479: SAVEPOINT Raise_Event_PVT;
1480:
1481: l_event := Check_Event(p_event_name);
1482:
1483: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Event : ' || l_event);
1484:
1485: --dpp_utility_pvt.error_message('Event Name', l_event);
1486:
1487: IF l_event = 'NOTFOUND' THEN
1507: l_parameter_list.extend;
1508: l_parameter_list(3) := l_parameter_t;
1509: -- Debug Message
1510:
1511: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Event Raise :' || p_event_name);
1512: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Event Key :' || p_event_key);
1513:
1514: -- Raise business event
1515: Wf_Event.Raise
1508: l_parameter_list(3) := l_parameter_t;
1509: -- Debug Message
1510:
1511: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Event Raise :' || p_event_name);
1512: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Event Key :' || p_event_key);
1513:
1514: -- Raise business event
1515: Wf_Event.Raise
1516: ( p_event_name => p_event_name,
1518: p_parameters => l_parameter_list,
1519: p_event_data => NULL);
1520: -- Debug Message
1521:
1522: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'event raised....');
1523:
1524: EXCEPTION
1525: WHEN FND_API.G_EXC_ERROR THEN
1526: ROLLBACK TO Raise_Event_PVT;
1658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1659: END IF;
1660: -- Debug Message
1661:
1662: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': Start');
1663:
1664: --Initialize message list if p_init_msg_list is TRUE.
1665: IF FND_API.To_Boolean (p_init_msg_list) THEN
1666: FND_MSG_PUB.initialize;
1673: ELSE
1674: l_user_role := l_user_role; -- p_user_role;
1675: END IF;
1676:
1677: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Before constructing message ' || l_user_role || ' ' || l_object_id || ' ' || l_status);
1678:
1679: /*
1680: If Approved Status , Chek if it if Final Approval or Not
1681: if Final Approval Then Send Approved Notification else Send Submitted Notification
1697: END LOOP;
1698: l_role_list := substr(l_role_list,2);
1699: -- END IF;
1700:
1701: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Users List for sending notification' || l_role_list);
1702:
1703: -- users returned from the search
1704: IF length(l_role_list) <> 0 THEN
1705: l_item_key := l_msg_type||'|'||l_msg_name||'|'||l_object_id||
1704: IF length(l_role_list) <> 0 THEN
1705: l_item_key := l_msg_type||'|'||l_msg_name||'|'||l_object_id||
1706: '|'||to_char(sysdate,'YYYYMMDDHH24MISS');
1707:
1708: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_item_key ' || l_item_key );
1709:
1710: IF l_object_type = 'PRICE PROTECTION' THEN
1711: l_item_type := 'DPPTXAPP';
1712: END IF;
1710: IF l_object_type = 'PRICE PROTECTION' THEN
1711: l_item_type := 'DPPTXAPP';
1712: END IF;
1713:
1714: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Creating process for itemtype:' || l_item_type || ' itemkey: ' || l_item_key);
1715:
1716: -- Create WF process to send notification
1717: wf_engine.CreateProcess ( ItemType => l_item_type,
1718: ItemKey => l_item_key,
1718: ItemKey => l_item_key,
1719: process => 'NOOP_PROCESS',
1720: user_key => l_item_key);
1721:
1722: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Executing msg callback' || l_msg_callback_api );
1723:
1724: -- execute callback api to set the message attributes
1725: EXECUTE IMMEDIATE 'BEGIN ' ||
1726: l_msg_callback_api || '(:itemtype, :itemkey, :transaction_header_id, :status); ' ||
1726: l_msg_callback_api || '(:itemtype, :itemkey, :transaction_header_id, :status); ' ||
1727: 'END;'
1728: USING l_item_type, l_item_key, l_object_id, l_status;
1729:
1730: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Adding adhoc users' || l_role_list );
1731:
1732: -- create an adhoc role with named after itemkey
1733: l_adhoc_role := l_item_key;
1734:
1737: role_users => l_role_list);
1738:
1739: l_context := l_msg_type || ':' || l_item_key || ':';
1740:
1741: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Sending Notification to adhoc role ' || l_msg_type || ' ' || l_msg_name);
1742: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Sent notification to role : ' || l_adhoc_role);
1743:
1744: -- set the message to be sent
1745: l_group_notify_id := wf_notification.sendGroup(
1738:
1739: l_context := l_msg_type || ':' || l_item_key || ':';
1740:
1741: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Sending Notification to adhoc role ' || l_msg_type || ' ' || l_msg_name);
1742: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Sent notification to role : ' || l_adhoc_role);
1743:
1744: -- set the message to be sent
1745: l_group_notify_id := wf_notification.sendGroup(
1746: role => l_adhoc_role,
1751: context => l_context,
1752: send_comment => NULL,
1753: priority => NULL );
1754:
1755: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Sending notification to role : ' || l_adhoc_role);
1756: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Using message: ' || l_msg_name || '. Notify id: ' || l_group_notify_id );
1757:
1758: -- start the notification process to send message
1759: wf_engine.StartProcess(itemtype => l_item_type,
1752: send_comment => NULL,
1753: priority => NULL );
1754:
1755: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Sending notification to role : ' || l_adhoc_role);
1756: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Using message: ' || l_msg_name || '. Notify id: ' || l_group_notify_id );
1757:
1758: -- start the notification process to send message
1759: wf_engine.StartProcess(itemtype => l_item_type,
1760: itemkey => l_item_key);
1776: END IF;
1777:
1778: -- Debug Message
1779:
1780: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': End');
1781:
1782: --Standard call to get message count and if count=1, get the message
1783: FND_MSG_PUB.Count_And_Get (
1784: p_encoded => FND_API.G_FALSE,
1894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1895: END IF;
1896: -- Debug Message
1897:
1898: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': Start');
1899:
1900: --Initialize message list if p_init_msg_list is TRUE.
1901: IF FND_API.To_Boolean (p_init_msg_list) THEN
1902: FND_MSG_PUB.initialize;
1933:
1934: IF p_approval_rec.action_code = 'APPROVE' OR
1935: p_approval_rec.action_code = 'REJECT' THEN
1936:
1937: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Update User Action ' || p_approval_rec.action_code );
1938:
1939: -- Update_User_Action - Update the user action in approval table
1940: Update_User_Action(
1941: p_api_version => p_api_version
1960: -- If the request is submitted/approved - get next approvers
1961: IF p_approval_rec.action_code = 'SUBMIT' OR
1962: p_approval_rec.action_code = 'APPROVE' THEN
1963:
1964: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Get Approvers ' || p_approval_rec.action_code );
1965:
1966: -- Get_Approvers - List of Approvers or Default Approver
1967: Get_Approvers(
1968: p_api_version => p_api_version
1974: ,p_approval_rec => p_approval_rec
1975: ,x_approvers => l_approvers_tbl
1976: ,x_final_approval_flag => l_final_approval_flag);
1977:
1978: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'After Get_Approvers >> ' || l_approvers_tbl.count );
1979:
1980: IF l_return_status = FND_API.g_ret_sts_error THEN
1981: RAISE FND_API.g_exc_error;
1982: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1987: -- Add access to users who have approval privileges
1988: IF p_approval_rec.action_code = 'SUBMIT' OR
1989: p_approval_rec.action_code = 'APPROVE' THEN
1990:
1991: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Add Access ' || p_approval_rec.action_code );
1992:
1993: IF l_final_approval_flag <> 'Y' THEN
1994: --If no Approver Found Do not add record in Access table
1995: -- FOR i IN 1..l_approvers_tbl.COUNT LOOP
2011: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2012: RAISE FND_API.g_exc_unexpected_error;
2013: END IF;
2014:
2015: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Access Added ' || x_return_status );
2016:
2017: END IF; --End if some Approver is found
2018: -- END LOOP;
2019: END IF;
2023: IF p_approval_rec.object_type = 'PRICE PROTECTION' THEN
2024:
2025: l_event_name := 'oracle.apps.dpp.request.Transaction.approval';
2026:
2027: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'assigning the event name :'||l_event_name);
2028:
2029: END IF;
2030:
2031: l_event_key := p_approval_rec.object_type || ':' || p_approval_rec.object_id || ':' || to_char(sysdate, 'DD:MON:YYYY HH:MI:SS');
2029: END IF;
2030:
2031: l_event_key := p_approval_rec.object_type || ':' || p_approval_rec.object_id || ':' || to_char(sysdate, 'DD:MON:YYYY HH:MI:SS');
2032:
2033: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'process_user_action l_final_approval_flag : '|| l_final_approval_flag);
2034: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'process_user_action p_approval_rec.action_code : '|| p_approval_rec.action_code);
2035:
2036: IF p_approval_rec.object_type = 'PRICE PROTECTION' THEN
2037: IF l_final_approval_flag <> 'Y' or p_approval_rec.action_code <> 'APPROVE' THEN
2030:
2031: l_event_key := p_approval_rec.object_type || ':' || p_approval_rec.object_id || ':' || to_char(sysdate, 'DD:MON:YYYY HH:MI:SS');
2032:
2033: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'process_user_action l_final_approval_flag : '|| l_final_approval_flag);
2034: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'process_user_action p_approval_rec.action_code : '|| p_approval_rec.action_code);
2035:
2036: IF p_approval_rec.object_type = 'PRICE PROTECTION' THEN
2037: IF l_final_approval_flag <> 'Y' or p_approval_rec.action_code <> 'APPROVE' THEN
2038: -- Raise_Event -> Event_Subscription -> Send_Notification
2070: WHERE transaction_header_id = p_approval_rec.object_id;
2071:
2072: IF SQL%ROWCOUNT = 0 THEN
2073: x_return_status := FND_API.G_RET_STS_ERROR;
2074: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column transaction_status in dpp_transaction_headers_all Table');
2075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2076: END IF;
2077:
2078: DPP_EXECUTIONPROCESS_PVT.Update_HeaderLog(
2115: retcode,
2116: l_org_id,
2117: l_txn_number
2118: );
2119: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Return status for Initiate_ExecutionProcess : ' || errbuff),1,4000));
2120:
2121: IF retcode = 0 THEN
2122: x_final_approval_flag := 'A';
2123:
2120:
2121: IF retcode = 0 THEN
2122: x_final_approval_flag := 'A';
2123:
2124: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Transaction is made Active ');
2125:
2126: ELSE
2127:
2128: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Initiate_ExecutionProcess Errored out. Transaction not made Active ');
2124: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Transaction is made Active ');
2125:
2126: ELSE
2127:
2128: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Initiate_ExecutionProcess Errored out. Transaction not made Active ');
2129:
2130: END IF; --retcode = 0
2131: ELSE
2132:
2129:
2130: END IF; --retcode = 0
2131: ELSE
2132:
2133: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Transaction is Future dated and hence not made Active ');
2134:
2135: END IF; --l_effective_date <= sysdate
2136: END IF; --x_final_approval_flag := 'Y'
2137: --Standard check of commit
2139: COMMIT WORK;
2140: END IF;
2141: -- Debug Message
2142:
2143: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': End');
2144:
2145: --Standard call to get message count and if count=1, get the message
2146: FND_MSG_PUB.Count_And_Get (
2147: p_encoded => FND_API.G_FALSE,