331: end if;
332:
333: EXCEPTION
334:
335: when FND_API.G_EXC_ERROR or FND_API.G_EXC_UNEXPECTED_ERROR then
336: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
337: raise;
338:
339: when others then
411: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);
412:
413: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
414: 'Invalid Approval Request Item: '||l_request_item_code);
415: raise FND_API.G_EXC_UNEXPECTED_ERROR;
416:
417: end if;
418:
419: -- Finished Checking Approval Items
423: end if;
424:
425: EXCEPTION
426:
427: when FND_API.G_EXC_ERROR or FND_API.G_EXC_UNEXPECTED_ERROR then
428: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
429: raise;
430:
431: when others then
502: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);
503:
504: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
505: 'Invalid Approval Request Item: '||l_request_item_code);
506: raise FND_API.G_EXC_UNEXPECTED_ERROR;
507:
508: end if;
509:
510: -- Finished Initializing Approval Items
514: end if;
515:
516: EXCEPTION
517:
518: when FND_API.G_EXC_ERROR or FND_API.G_EXC_UNEXPECTED_ERROR then
519: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
520: raise;
521:
522: when others then
597: if (l_next_approver_rec.approval_status = AME_UTIL.exceptionStatus) then
598:
599: FND_MESSAGE.set_name('FEM', 'FEM_WF_APPR_NEXT_APPR_ERR');
600: FND_MSG_PUB.Add;
601: raise FND_API.G_EXC_ERROR;
602:
603: end if;
604:
605: if (l_next_approver_rec.person_id is not null) then
679: end if;
680:
681: EXCEPTION
682:
683: when FND_API.G_EXC_ERROR or FND_API.G_EXC_UNEXPECTED_ERROR then
684: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
685: raise;
686:
687: when others then
744: end if;
745:
746: EXCEPTION
747:
748: when FND_API.G_EXC_ERROR or FND_API.G_EXC_UNEXPECTED_ERROR then
749: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
750: raise;
751:
752: when others then
809: end if;
810:
811: EXCEPTION
812:
813: when FND_API.G_EXC_ERROR or FND_API.G_EXC_UNEXPECTED_ERROR then
814: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
815: raise;
816:
817: when others then
874: end if;
875:
876: EXCEPTION
877:
878: when FND_API.G_EXC_ERROR or FND_API.G_EXC_UNEXPECTED_ERROR then
879: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
880: raise;
881:
882: when others then
993:
994: -- Invalid Original System for Old Approver
995: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
996: 'Invalid Original System for Old Approver: '||l_old_approver_orig_system);
997: raise FND_API.G_EXC_UNEXPECTED_ERROR;
998:
999: end if;
1000:
1001: -- Get the new approver name for the forwarded notification
1026: else
1027:
1028: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
1029: 'Invalid Original System for New Approver: '||l_new_approver_orig_system);
1030: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1031:
1032: end if;
1033:
1034: -- Default some values from forwarding approver record
1095: end if;
1096:
1097: EXCEPTION
1098:
1099: when FND_API.G_EXC_ERROR or FND_API.G_EXC_UNEXPECTED_ERROR then
1100: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
1101: raise;
1102:
1103: when others then
1174: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);
1175:
1176: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
1177: 'Invalid Approval Request Item: '||l_request_item_code);
1178: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1179:
1180: end if;
1181:
1182: -- Success in Setting Submitted State
1186: end if;
1187:
1188: EXCEPTION
1189:
1190: when FND_API.G_EXC_ERROR or FND_API.G_EXC_UNEXPECTED_ERROR then
1191: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
1192: raise;
1193:
1194: when others then
1273: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);
1274:
1275: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
1276: 'Invalid Approval Request Item: '||l_request_item_code);
1277: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1278:
1279: end if;
1280:
1281: -- Success in Setting Approved State
1285: end if;
1286:
1287: EXCEPTION
1288:
1289: when FND_API.G_EXC_ERROR or FND_API.G_EXC_UNEXPECTED_ERROR then
1290: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
1291: raise;
1292:
1293: when others then
1364: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);
1365:
1366: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
1367: 'Invalid Approval Request Item: '||l_request_item_code);
1368: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1369:
1370: end if;
1371:
1372: -- Success in Setting Rejected State
1376: end if;
1377:
1378: EXCEPTION
1379:
1380: when FND_API.G_EXC_ERROR or FND_API.G_EXC_UNEXPECTED_ERROR then
1381: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
1382: raise;
1383:
1384: when others then
1442: end if;
1443:
1444: EXCEPTION
1445:
1446: when FND_API.G_EXC_ERROR or FND_API.G_EXC_UNEXPECTED_ERROR then
1447: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
1448: raise;
1449:
1450: when others then
1507: end if;
1508:
1509: EXCEPTION
1510:
1511: when FND_API.G_EXC_ERROR or FND_API.G_EXC_UNEXPECTED_ERROR then
1512: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
1513: raise;
1514:
1515: when others then
1620: end if;
1621:
1622: EXCEPTION
1623:
1624: when FND_API.G_EXC_ERROR or FND_API.G_EXC_UNEXPECTED_ERROR then
1625: BuildErrorMsg(l_api_name, p_item_type, p_item_key, p_act_id);
1626: raise;
1627:
1628: when others then
1722: else
1723:
1724: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
1725: 'Invalid Approver Original System: '||l_approver_orig_system);
1726: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1727:
1728: end if;
1729:
1730: END UpdateApproval;
1781: p_item_type, p_item_key, G_REQUEST_ITEM_CODE);
1782:
1783: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
1784: 'Invalid Approval Request Item: '||l_request_item_code);
1785: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1786:
1787: end if;
1788:
1789: l_request_id := WF_ENGINE.GetItemAttrNumber(
1864: else
1865:
1866: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
1867: 'Approval Request ID cannot be NULL');
1868: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1869:
1870: end if;
1871:
1872: if (l_request_type_code is not null) then
1886: else
1887:
1888: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
1889: 'Approval Request Type cannot be NULL');
1890: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1891:
1892: end if;
1893:
1894: else
1894: else
1895:
1896: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name,
1897: 'Invalid Event Name: '||l_event_name);
1898: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1899:
1900: end if;
1901:
1902: END InitApprovalRequestInternal;