138: where request_id=p_request_id;
139:
140: exception
141: when others then
142: FND_MESSAGE.set_name('IA', 'IA_NO_REQUEST_FOUND'); -- Error: Unable to find request id, REQUEST_ID
143: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
144: l_error_message := FND_MESSAGE.Get;
145: raise localException;
146: end;
139:
140: exception
141: when others then
142: FND_MESSAGE.set_name('IA', 'IA_NO_REQUEST_FOUND'); -- Error: Unable to find request id, REQUEST_ID
143: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
144: l_error_message := FND_MESSAGE.Get;
145: raise localException;
146: end;
147:
140: exception
141: when others then
142: FND_MESSAGE.set_name('IA', 'IA_NO_REQUEST_FOUND'); -- Error: Unable to find request id, REQUEST_ID
143: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
144: l_error_message := FND_MESSAGE.Get;
145: raise localException;
146: end;
147:
148: if (l_status is NULL or l_status <> IA_WF_UTIL_PKG.HeaderStatusSubmitted) then
145: raise localException;
146: end;
147:
148: if (l_status is NULL or l_status <> IA_WF_UTIL_PKG.HeaderStatusSubmitted) then
149: FND_MESSAGE.set_name('IA', 'IA_INVALID_STATUS_FOR_START_WF'); -- Error: You can not submit the request id, REQUEST_ID. The status of request must be set to Submitted in order for Workflow to initiate the request.
150: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
151: l_error_message := FND_MESSAGE.Get;
152: raise localException;
153: end if;
146: end;
147:
148: if (l_status is NULL or l_status <> IA_WF_UTIL_PKG.HeaderStatusSubmitted) then
149: FND_MESSAGE.set_name('IA', 'IA_INVALID_STATUS_FOR_START_WF'); -- Error: You can not submit the request id, REQUEST_ID. The status of request must be set to Submitted in order for Workflow to initiate the request.
150: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
151: l_error_message := FND_MESSAGE.Get;
152: raise localException;
153: end if;
154:
147:
148: if (l_status is NULL or l_status <> IA_WF_UTIL_PKG.HeaderStatusSubmitted) then
149: FND_MESSAGE.set_name('IA', 'IA_INVALID_STATUS_FOR_START_WF'); -- Error: You can not submit the request id, REQUEST_ID. The status of request must be set to Submitted in order for Workflow to initiate the request.
150: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
151: l_error_message := FND_MESSAGE.Get;
152: raise localException;
153: end if;
154:
155:
193: l_receiving_approver_name_disp);
194:
195: exception
196: when others then
197: FND_MESSAGE.set_name('IA', 'IA_NO_PERSON_FOUND'); -- Error: Unable to find person id, PERSON_ID
198: FND_MESSAGE.set_token('PERSON_ID', l_person_id);
199: l_error_message := FND_MESSAGE.Get;
200: raise localException;
201: end;
194:
195: exception
196: when others then
197: FND_MESSAGE.set_name('IA', 'IA_NO_PERSON_FOUND'); -- Error: Unable to find person id, PERSON_ID
198: FND_MESSAGE.set_token('PERSON_ID', l_person_id);
199: l_error_message := FND_MESSAGE.Get;
200: raise localException;
201: end;
202:
195: exception
196: when others then
197: FND_MESSAGE.set_name('IA', 'IA_NO_PERSON_FOUND'); -- Error: Unable to find person id, PERSON_ID
198: FND_MESSAGE.set_token('PERSON_ID', l_person_id);
199: l_error_message := FND_MESSAGE.Get;
200: raise localException;
201: end;
202:
203:
216: and rownum < 2;
217:
218: exception
219: when others then
220: FND_MESSAGE.set_name('IA', 'IA_NO_BOOK_FOUND'); -- Error: Unable to find book, BOOK_TYPE_CODE with book class of Corporate
221: FND_MESSAGE.set_token('BOOK_TYPE_CODE', l_book_type_code);
222: l_error_message := FND_MESSAGE.Get;
223: raise localException;
224: end;
217:
218: exception
219: when others then
220: FND_MESSAGE.set_name('IA', 'IA_NO_BOOK_FOUND'); -- Error: Unable to find book, BOOK_TYPE_CODE with book class of Corporate
221: FND_MESSAGE.set_token('BOOK_TYPE_CODE', l_book_type_code);
222: l_error_message := FND_MESSAGE.Get;
223: raise localException;
224: end;
225:
218: exception
219: when others then
220: FND_MESSAGE.set_name('IA', 'IA_NO_BOOK_FOUND'); -- Error: Unable to find book, BOOK_TYPE_CODE with book class of Corporate
221: FND_MESSAGE.set_token('BOOK_TYPE_CODE', l_book_type_code);
222: l_error_message := FND_MESSAGE.Get;
223: raise localException;
224: end;
225:
226: end if;
237: and application_id=IA_WF_UTIL_PKG.GetApplicationID;
238:
239: exception
240: when others then
241: FND_MESSAGE.set_name('IA', 'IA_NO_RESPONSIBILITY_FOUND'); -- Error: Unable to find responsibility id, RESPONSIBILITY_ID
242: FND_MESSAGE.set_token('RESPONSIBILITY_ID', l_responsibility_id);
243: l_error_message := FND_MESSAGE.Get;
244: raise localException;
245: end;
238:
239: exception
240: when others then
241: FND_MESSAGE.set_name('IA', 'IA_NO_RESPONSIBILITY_FOUND'); -- Error: Unable to find responsibility id, RESPONSIBILITY_ID
242: FND_MESSAGE.set_token('RESPONSIBILITY_ID', l_responsibility_id);
243: l_error_message := FND_MESSAGE.Get;
244: raise localException;
245: end;
246:
239: exception
240: when others then
241: FND_MESSAGE.set_name('IA', 'IA_NO_RESPONSIBILITY_FOUND'); -- Error: Unable to find responsibility id, RESPONSIBILITY_ID
242: FND_MESSAGE.set_token('RESPONSIBILITY_ID', l_responsibility_id);
243: l_error_message := FND_MESSAGE.Get;
244: raise localException;
245: end;
246:
247: -----------------------------------------------------
275: l_rule_id := IA_WF_UTIL_PKG.GetRuleID(p_responsibility_id => l_responsibility_id);
276:
277: exception
278: when others then
279: FND_MESSAGE.set_name('IA', 'IA_NO_RULE_ASSIGNED'); -- Error: No rule has been defined for responsibility id, RESPONSIBILITY_ID.
280: FND_MESSAGE.set_token('RESPONSIBILITY_ID', l_responsibility_id);
281: l_error_message := FND_MESSAGE.Get;
282: raise localException;
283: end;
276:
277: exception
278: when others then
279: FND_MESSAGE.set_name('IA', 'IA_NO_RULE_ASSIGNED'); -- Error: No rule has been defined for responsibility id, RESPONSIBILITY_ID.
280: FND_MESSAGE.set_token('RESPONSIBILITY_ID', l_responsibility_id);
281: l_error_message := FND_MESSAGE.Get;
282: raise localException;
283: end;
284:
277: exception
278: when others then
279: FND_MESSAGE.set_name('IA', 'IA_NO_RULE_ASSIGNED'); -- Error: No rule has been defined for responsibility id, RESPONSIBILITY_ID.
280: FND_MESSAGE.set_token('RESPONSIBILITY_ID', l_responsibility_id);
281: l_error_message := FND_MESSAGE.Get;
282: raise localException;
283: end;
284:
285:
287: debugInfo := 'Initialize rule setup';
288: -----------------------------------------------------
289: if (not IA_WF_UTIL_PKG.ResetRuleSetup(p_rule_id => l_rule_id,
290: p_book_type_code => l_book_type_code) ) then
291: FND_MESSAGE.set_name('IA', 'IA_RULE_RETRIEVAL_ERROR'); -- Error: Unable to find rule id, RULE_ID
292: FND_MESSAGE.set_token('RULE_ID', l_rule_id);
293: l_error_message := FND_MESSAGE.Get;
294: raise localException;
295: end if;
288: -----------------------------------------------------
289: if (not IA_WF_UTIL_PKG.ResetRuleSetup(p_rule_id => l_rule_id,
290: p_book_type_code => l_book_type_code) ) then
291: FND_MESSAGE.set_name('IA', 'IA_RULE_RETRIEVAL_ERROR'); -- Error: Unable to find rule id, RULE_ID
292: FND_MESSAGE.set_token('RULE_ID', l_rule_id);
293: l_error_message := FND_MESSAGE.Get;
294: raise localException;
295: end if;
296:
289: if (not IA_WF_UTIL_PKG.ResetRuleSetup(p_rule_id => l_rule_id,
290: p_book_type_code => l_book_type_code) ) then
291: FND_MESSAGE.set_name('IA', 'IA_RULE_RETRIEVAL_ERROR'); -- Error: Unable to find rule id, RULE_ID
292: FND_MESSAGE.set_token('RULE_ID', l_rule_id);
293: l_error_message := FND_MESSAGE.Get;
294: raise localException;
295: end if;
296:
297: -----------------------------------------------------
314: -----------------------------------------------------
315: debugInfo := 'Clear all AME PL/SQL session context and approvals for the transaciton ID';
316: -----------------------------------------------------
317: if (not IA_AME_REQUEST_PKG.InitializeAME(RequestId => p_request_id)) then
318: FND_MESSAGE.set_name('IA', 'IA_AME_INITIALIZE_ERROR'); -- Error: Error occurred when initializing a session for Oracle Approvals Management.
319: l_error_message := FND_MESSAGE.Get;
320: raise localException;
321: end if;
322: */
315: debugInfo := 'Clear all AME PL/SQL session context and approvals for the transaciton ID';
316: -----------------------------------------------------
317: if (not IA_AME_REQUEST_PKG.InitializeAME(RequestId => p_request_id)) then
318: FND_MESSAGE.set_name('IA', 'IA_AME_INITIALIZE_ERROR'); -- Error: Error occurred when initializing a session for Oracle Approvals Management.
319: l_error_message := FND_MESSAGE.Get;
320: raise localException;
321: end if;
322: */
323:
342: where request_id = p_request_id;
343:
344: exception
345: when others then
346: FND_MESSAGE.set_name('IA', 'IA_HEADER_STATUS_UPDATE_ERROR'); -- Error: Unable to update the status for request id, REQUEST_ID
347: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
348: l_error_message := FND_MESSAGE.Get;
349: raise localException;
350: end;
343:
344: exception
345: when others then
346: FND_MESSAGE.set_name('IA', 'IA_HEADER_STATUS_UPDATE_ERROR'); -- Error: Unable to update the status for request id, REQUEST_ID
347: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
348: l_error_message := FND_MESSAGE.Get;
349: raise localException;
350: end;
351:
344: exception
345: when others then
346: FND_MESSAGE.set_name('IA', 'IA_HEADER_STATUS_UPDATE_ERROR'); -- Error: Unable to update the status for request id, REQUEST_ID
347: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
348: l_error_message := FND_MESSAGE.Get;
349: raise localException;
350: end;
351:
352: /****************************
365: process => IA_WF_UTIL_PKG.WF_MainProcess);
366:
367: exception
368: when others then
369: FND_MESSAGE.set_name('IA', 'IA_WF_CREATE_PROCESS_ERROR'); -- Error: Unable to create a workflow process for request id, REQUEST_ID
370: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
371: l_error_message := FND_MESSAGE.Get;
372: raise localException;
373: end;
366:
367: exception
368: when others then
369: FND_MESSAGE.set_name('IA', 'IA_WF_CREATE_PROCESS_ERROR'); -- Error: Unable to create a workflow process for request id, REQUEST_ID
370: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
371: l_error_message := FND_MESSAGE.Get;
372: raise localException;
373: end;
374:
367: exception
368: when others then
369: FND_MESSAGE.set_name('IA', 'IA_WF_CREATE_PROCESS_ERROR'); -- Error: Unable to create a workflow process for request id, REQUEST_ID
370: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
371: l_error_message := FND_MESSAGE.Get;
372: raise localException;
373: end;
374:
375:
391: userkey => p_request_id); -- p_request_id);
392:
393: exception
394: when others then
395: FND_MESSAGE.set_name('IA', 'IA_WF_SET_SYSTEM_ATTRS_ERROR'); -- Error: Unable to set the workflow system attributes for request id, REQUEST_ID
396: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
397: l_error_message := FND_MESSAGE.Get;
398: raise localWFException;
399: end;
392:
393: exception
394: when others then
395: FND_MESSAGE.set_name('IA', 'IA_WF_SET_SYSTEM_ATTRS_ERROR'); -- Error: Unable to set the workflow system attributes for request id, REQUEST_ID
396: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
397: l_error_message := FND_MESSAGE.Get;
398: raise localWFException;
399: end;
400:
393: exception
394: when others then
395: FND_MESSAGE.set_name('IA', 'IA_WF_SET_SYSTEM_ATTRS_ERROR'); -- Error: Unable to set the workflow system attributes for request id, REQUEST_ID
396: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
397: l_error_message := FND_MESSAGE.Get;
398: raise localWFException;
399: end;
400:
401:
522: avalue => IA_WF_UTIL_PKG.GetLookupMeaning(p_lookup_type=>'REQ_HDR_STATUS',
523: p_lookup_code=>IA_WF_UTIL_PKG.HeaderStatusPendingApproval));
524: exception
525: when others then
526: FND_MESSAGE.set_name('IA', 'IA_WF_SET_ATTRIBUTE_ERROR'); -- Error: Unable to set the workflow attribute ATTRIBUTE for request id, REQUEST_ID
527: FND_MESSAGE.set_token('ATTRIBUTE', l_attribute);
528: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
529: l_error_message := FND_MESSAGE.Get;
530: raise localWFException;
523: p_lookup_code=>IA_WF_UTIL_PKG.HeaderStatusPendingApproval));
524: exception
525: when others then
526: FND_MESSAGE.set_name('IA', 'IA_WF_SET_ATTRIBUTE_ERROR'); -- Error: Unable to set the workflow attribute ATTRIBUTE for request id, REQUEST_ID
527: FND_MESSAGE.set_token('ATTRIBUTE', l_attribute);
528: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
529: l_error_message := FND_MESSAGE.Get;
530: raise localWFException;
531: end;
524: exception
525: when others then
526: FND_MESSAGE.set_name('IA', 'IA_WF_SET_ATTRIBUTE_ERROR'); -- Error: Unable to set the workflow attribute ATTRIBUTE for request id, REQUEST_ID
527: FND_MESSAGE.set_token('ATTRIBUTE', l_attribute);
528: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
529: l_error_message := FND_MESSAGE.Get;
530: raise localWFException;
531: end;
532:
525: when others then
526: FND_MESSAGE.set_name('IA', 'IA_WF_SET_ATTRIBUTE_ERROR'); -- Error: Unable to set the workflow attribute ATTRIBUTE for request id, REQUEST_ID
527: FND_MESSAGE.set_token('ATTRIBUTE', l_attribute);
528: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
529: l_error_message := FND_MESSAGE.Get;
530: raise localWFException;
531: end;
532:
533:
543: itemkey => l_itemkey);
544:
545: exception
546: when others then
547: FND_MESSAGE.set_name('IA', 'IA_WF_START_PROCESS_ERROR'); -- Error: Unable to start a workflow process for request id, REQUEST_ID
548: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
549: l_error_message := FND_MESSAGE.Get;
550: raise localWFException;
551: end;
544:
545: exception
546: when others then
547: FND_MESSAGE.set_name('IA', 'IA_WF_START_PROCESS_ERROR'); -- Error: Unable to start a workflow process for request id, REQUEST_ID
548: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
549: l_error_message := FND_MESSAGE.Get;
550: raise localWFException;
551: end;
552:
545: exception
546: when others then
547: FND_MESSAGE.set_name('IA', 'IA_WF_START_PROCESS_ERROR'); -- Error: Unable to start a workflow process for request id, REQUEST_ID
548: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
549: l_error_message := FND_MESSAGE.Get;
550: raise localWFException;
551: end;
552:
553: commit;
712: aname => 'APPROVALS_REQUIRED',
713: avalue => l_approvals_required);
714: exception
715: when others then
716: FND_MESSAGE.set_name('IA', 'IA_WF_SET_ATTRIBUTE_ERROR'); -- Error: Unable to set the workflow attribute ATTRIBUTE for request id, REQUEST_ID
717: FND_MESSAGE.set_token('ATTRIBUTE', l_attribute);
718: FND_MESSAGE.set_token('REQUEST_ID', itemkey);
719: l_error_message := FND_MESSAGE.Get;
720: raise localWFException;
713: avalue => l_approvals_required);
714: exception
715: when others then
716: FND_MESSAGE.set_name('IA', 'IA_WF_SET_ATTRIBUTE_ERROR'); -- Error: Unable to set the workflow attribute ATTRIBUTE for request id, REQUEST_ID
717: FND_MESSAGE.set_token('ATTRIBUTE', l_attribute);
718: FND_MESSAGE.set_token('REQUEST_ID', itemkey);
719: l_error_message := FND_MESSAGE.Get;
720: raise localWFException;
721: end;
714: exception
715: when others then
716: FND_MESSAGE.set_name('IA', 'IA_WF_SET_ATTRIBUTE_ERROR'); -- Error: Unable to set the workflow attribute ATTRIBUTE for request id, REQUEST_ID
717: FND_MESSAGE.set_token('ATTRIBUTE', l_attribute);
718: FND_MESSAGE.set_token('REQUEST_ID', itemkey);
719: l_error_message := FND_MESSAGE.Get;
720: raise localWFException;
721: end;
722:
715: when others then
716: FND_MESSAGE.set_name('IA', 'IA_WF_SET_ATTRIBUTE_ERROR'); -- Error: Unable to set the workflow attribute ATTRIBUTE for request id, REQUEST_ID
717: FND_MESSAGE.set_token('ATTRIBUTE', l_attribute);
718: FND_MESSAGE.set_token('REQUEST_ID', itemkey);
719: l_error_message := FND_MESSAGE.Get;
720: raise localWFException;
721: end;
722:
723: result := 'COMPLETE:'||l_approvals_required;
817: ,ChainPhase => l_chain_phase -- IN OUT
818: ,Approver => tempApprover
819: ,NoMoreApproverFlag => l_no_more_approver_flag )) then
820:
821: FND_MESSAGE.set_name('IA', 'IA_AME_NEXT_APPROVER_ERROR'); -- Error: Error occurred when fetching a next approver from Oracle Approval Management.
822: l_error_message := FND_MESSAGE.Get;
823: raise localException;
824: end if;
825:
818: ,Approver => tempApprover
819: ,NoMoreApproverFlag => l_no_more_approver_flag )) then
820:
821: FND_MESSAGE.set_name('IA', 'IA_AME_NEXT_APPROVER_ERROR'); -- Error: Error occurred when fetching a next approver from Oracle Approval Management.
822: l_error_message := FND_MESSAGE.Get;
823: raise localException;
824: end if;
825:
826: l_approver_id := tempApprover.person_id;
1028: and status=IA_WF_UTIL_PKG.ApprovalStatusPendingApproval;
1029:
1030: exception
1031: when others then
1032: FND_MESSAGE.set_name('IA', 'IA_NO_REQUEST_FOUND'); -- Error: Unable to find request id, REQUEST_ID
1033: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
1034: l_error_message := FND_MESSAGE.Get;
1035: raise localException;
1036: end;
1029:
1030: exception
1031: when others then
1032: FND_MESSAGE.set_name('IA', 'IA_NO_REQUEST_FOUND'); -- Error: Unable to find request id, REQUEST_ID
1033: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
1034: l_error_message := FND_MESSAGE.Get;
1035: raise localException;
1036: end;
1037:
1030: exception
1031: when others then
1032: FND_MESSAGE.set_name('IA', 'IA_NO_REQUEST_FOUND'); -- Error: Unable to find request id, REQUEST_ID
1033: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
1034: l_error_message := FND_MESSAGE.Get;
1035: raise localException;
1036: end;
1037:
1038: -----------------------------------------------------
1056: where grp_id_view.group_id = wfn.group_id;
1057:
1058: exception
1059: when others then
1060: FND_MESSAGE.set_name('IA', 'IA_NO_NOTIFICATION_FOUND'); -- Error: Unable to find the notification for request id, REQUEST_ID
1061: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
1062: l_error_message := FND_MESSAGE.Get;
1063: raise localException;
1064: end;
1057:
1058: exception
1059: when others then
1060: FND_MESSAGE.set_name('IA', 'IA_NO_NOTIFICATION_FOUND'); -- Error: Unable to find the notification for request id, REQUEST_ID
1061: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
1062: l_error_message := FND_MESSAGE.Get;
1063: raise localException;
1064: end;
1065:
1058: exception
1059: when others then
1060: FND_MESSAGE.set_name('IA', 'IA_NO_NOTIFICATION_FOUND'); -- Error: Unable to find the notification for request id, REQUEST_ID
1061: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);
1062: l_error_message := FND_MESSAGE.Get;
1063: raise localException;
1064: end;
1065:
1066: -----------------------------------------------------
1229: if (not IA_AME_REQUEST_PKG.GetAllApprovers(RequestID => l_request_id,
1230: ReleasingApprovers => tempReleasingApprovers,
1231: ReceivingApprovers => tempReceivingApprovers) ) then
1232:
1233: FND_MESSAGE.set_name('IA', 'IA_AME_NEXT_APPROVER_ERROR');
1234: l_error_message := FND_MESSAGE.Get;
1235: raise localException;
1236: end if;
1237:
1230: ReleasingApprovers => tempReleasingApprovers,
1231: ReceivingApprovers => tempReceivingApprovers) ) then
1232:
1233: FND_MESSAGE.set_name('IA', 'IA_AME_NEXT_APPROVER_ERROR');
1234: l_error_message := FND_MESSAGE.Get;
1235: raise localException;
1236: end if;
1237:
1238: Repopulate_Approvers_List(p_request_id => l_request_id,
1739:
1740: if (not IA_AME_REQUEST_PKG.UpdateApprovalStatus(RequestId => l_request_id
1741: ,ChainPhase => l_chain_phase
1742: ,Approver => tempApprover)) then
1743: FND_MESSAGE.set_name('IA', 'IA_AME_UPDATE_STATUS_ERROR'); -- Error occurred when updating approval status in AME.
1744: l_error_message := FND_MESSAGE.Get;
1745: raise localException;
1746: end if;
1747: end if;
1740: if (not IA_AME_REQUEST_PKG.UpdateApprovalStatus(RequestId => l_request_id
1741: ,ChainPhase => l_chain_phase
1742: ,Approver => tempApprover)) then
1743: FND_MESSAGE.set_name('IA', 'IA_AME_UPDATE_STATUS_ERROR'); -- Error occurred when updating approval status in AME.
1744: l_error_message := FND_MESSAGE.Get;
1745: raise localException;
1746: end if;
1747: end if;
1748:
1884: if (not IA_AME_REQUEST_PKG.UpdateApprovalStatus(RequestId => l_request_id
1885: ,ChainPhase => l_chain_phase
1886: ,Approver => tempApprover
1887: ,Forwardee => tempDelegatee)) then
1888: FND_MESSAGE.set_name('IA', 'IA_AME_UPDATE_STATUS_ERROR'); -- Error occurred when updating approval status in Oracle Approval Management.
1889: l_error_message := FND_MESSAGE.Get;
1890: raise localException;
1891: end if;
1892: end if;
1885: ,ChainPhase => l_chain_phase
1886: ,Approver => tempApprover
1887: ,Forwardee => tempDelegatee)) then
1888: FND_MESSAGE.set_name('IA', 'IA_AME_UPDATE_STATUS_ERROR'); -- Error occurred when updating approval status in Oracle Approval Management.
1889: l_error_message := FND_MESSAGE.Get;
1890: raise localException;
1891: end if;
1892: end if;
1893:
2005: = IA_WF_UTIL_PKG.ApprovalMethodHierarchy ) then
2006: if (not IA_AME_REQUEST_PKG.UpdateApprovalStatus(RequestId => l_request_id
2007: ,ChainPhase => l_chain_phase
2008: ,Approver => tempApprover)) then
2009: FND_MESSAGE.set_name('IA', 'IA_AME_UPDATE_STATUS_ERROR'); -- Error occurred when updating approval status in Oracle Approvals Management.
2010: l_error_message := FND_MESSAGE.Get;
2011: raise localException;
2012: end if;
2013: end if;
2006: if (not IA_AME_REQUEST_PKG.UpdateApprovalStatus(RequestId => l_request_id
2007: ,ChainPhase => l_chain_phase
2008: ,Approver => tempApprover)) then
2009: FND_MESSAGE.set_name('IA', 'IA_AME_UPDATE_STATUS_ERROR'); -- Error occurred when updating approval status in Oracle Approvals Management.
2010: l_error_message := FND_MESSAGE.Get;
2011: raise localException;
2012: end if;
2013: end if;
2014: