DBA Data[Home] [Help]

APPS.IA_WF_REQUEST_PKG dependencies on FND_MESSAGE

Line 142: FND_MESSAGE.set_name('IA', 'IA_NO_REQUEST_FOUND'); -- Error: Unable to find request id, REQUEST_ID

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;

Line 143: FND_MESSAGE.set_token('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;
147:

Line 144: l_error_message := FND_MESSAGE.Get;

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

Line 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.

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;

Line 150: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);

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:

Line 151: l_error_message := FND_MESSAGE.Get;

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:

Line 197: FND_MESSAGE.set_name('IA', 'IA_NO_PERSON_FOUND'); -- Error: Unable to find person id, PERSON_ID

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;

Line 198: FND_MESSAGE.set_token('PERSON_ID', l_person_id);

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:

Line 199: l_error_message := FND_MESSAGE.Get;

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:

Line 220: FND_MESSAGE.set_name('IA', 'IA_NO_BOOK_FOUND'); -- Error: Unable to find book, BOOK_TYPE_CODE with book class of Corporate

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;

Line 221: FND_MESSAGE.set_token('BOOK_TYPE_CODE', l_book_type_code);

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:

Line 222: l_error_message := FND_MESSAGE.Get;

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;

Line 241: FND_MESSAGE.set_name('IA', 'IA_NO_RESPONSIBILITY_FOUND'); -- Error: Unable to find responsibility id, RESPONSIBILITY_ID

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;

Line 242: FND_MESSAGE.set_token('RESPONSIBILITY_ID', l_responsibility_id);

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:

Line 243: l_error_message := FND_MESSAGE.Get;

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: -----------------------------------------------------

Line 279: FND_MESSAGE.set_name('IA', 'IA_NO_RULE_ASSIGNED'); -- Error: No rule has been defined for responsibility id, RESPONSIBILITY_ID.

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;

Line 280: FND_MESSAGE.set_token('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;
284:

Line 281: l_error_message := FND_MESSAGE.Get;

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:

Line 291: FND_MESSAGE.set_name('IA', 'IA_RULE_RETRIEVAL_ERROR'); -- Error: Unable to find rule id, RULE_ID

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;

Line 292: FND_MESSAGE.set_token('RULE_ID', l_rule_id);

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:

Line 293: l_error_message := FND_MESSAGE.Get;

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: -----------------------------------------------------

Line 318: FND_MESSAGE.set_name('IA', 'IA_AME_INITIALIZE_ERROR'); -- Error: Error occurred when initializing a session for Oracle Approvals Management.

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: */

Line 319: l_error_message := FND_MESSAGE.Get;

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:

Line 346: FND_MESSAGE.set_name('IA', 'IA_HEADER_STATUS_UPDATE_ERROR'); -- Error: Unable to update the status for request id, REQUEST_ID

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;

Line 347: FND_MESSAGE.set_token('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;
351:

Line 348: l_error_message := FND_MESSAGE.Get;

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: /****************************

Line 369: FND_MESSAGE.set_name('IA', 'IA_WF_CREATE_PROCESS_ERROR'); -- Error: Unable to create a workflow process for request id, REQUEST_ID

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;

Line 370: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);

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:

Line 371: l_error_message := FND_MESSAGE.Get;

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:

Line 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

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;

Line 396: FND_MESSAGE.set_token('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;
400:

Line 397: l_error_message := FND_MESSAGE.Get;

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:

Line 526: FND_MESSAGE.set_name('IA', 'IA_WF_SET_ATTRIBUTE_ERROR'); -- Error: Unable to set the workflow attribute ATTRIBUTE for request id, REQUEST_ID

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;

Line 527: FND_MESSAGE.set_token('ATTRIBUTE', l_attribute);

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;

Line 528: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);

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:

Line 529: l_error_message := FND_MESSAGE.Get;

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:

Line 547: FND_MESSAGE.set_name('IA', 'IA_WF_START_PROCESS_ERROR'); -- Error: Unable to start a workflow process for request id, REQUEST_ID

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;

Line 548: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);

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:

Line 549: l_error_message := FND_MESSAGE.Get;

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;

Line 716: FND_MESSAGE.set_name('IA', 'IA_WF_SET_ATTRIBUTE_ERROR'); -- Error: Unable to set the workflow attribute ATTRIBUTE for request id, REQUEST_ID

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;

Line 717: FND_MESSAGE.set_token('ATTRIBUTE', l_attribute);

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;

Line 718: FND_MESSAGE.set_token('REQUEST_ID', itemkey);

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:

Line 719: l_error_message := FND_MESSAGE.Get;

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;

Line 821: FND_MESSAGE.set_name('IA', 'IA_AME_NEXT_APPROVER_ERROR'); -- Error: Error occurred when fetching a next approver from Oracle Approval Management.

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:

Line 822: l_error_message := FND_MESSAGE.Get;

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;

Line 1032: FND_MESSAGE.set_name('IA', 'IA_NO_REQUEST_FOUND'); -- Error: Unable to find request id, REQUEST_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;

Line 1033: FND_MESSAGE.set_token('REQUEST_ID', p_request_id);

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:

Line 1034: l_error_message := FND_MESSAGE.Get;

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: -----------------------------------------------------

Line 1060: FND_MESSAGE.set_name('IA', 'IA_NO_NOTIFICATION_FOUND'); -- Error: Unable to find the notification for request id, REQUEST_ID

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;

Line 1061: FND_MESSAGE.set_token('REQUEST_ID', p_request_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;
1065:

Line 1062: l_error_message := FND_MESSAGE.Get;

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: -----------------------------------------------------

Line 1233: FND_MESSAGE.set_name('IA', 'IA_AME_NEXT_APPROVER_ERROR');

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:

Line 1234: l_error_message := FND_MESSAGE.Get;

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,

Line 1743: FND_MESSAGE.set_name('IA', 'IA_AME_UPDATE_STATUS_ERROR'); -- Error occurred when updating approval status in AME.

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;

Line 1744: l_error_message := FND_MESSAGE.Get;

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:

Line 1888: FND_MESSAGE.set_name('IA', 'IA_AME_UPDATE_STATUS_ERROR'); -- Error occurred when updating approval status in Oracle Approval Management.

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;

Line 1889: l_error_message := FND_MESSAGE.Get;

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:

Line 2009: FND_MESSAGE.set_name('IA', 'IA_AME_UPDATE_STATUS_ERROR'); -- Error occurred when updating approval status in Oracle Approvals Management.

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;

Line 2010: l_error_message := FND_MESSAGE.Get;

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: