DBA Data[Home] [Help]

APPS.PA_TASK_WORKFLOW_PKG dependencies on WF_CORE

Line 429: WF_CORE.CONTEXT('PA_TASK_APPROVAL_WF ','Start_Task_Aprv_Wf');

425: END IF;
426:
427: EXCEPTION
428: WHEN FND_API.G_EXC_ERROR THEN
429: WF_CORE.CONTEXT('PA_TASK_APPROVAL_WF ','Start_Task_Aprv_Wf');
430: RAISE;
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432: x_err_code := SQLCODE;
433: WF_CORE.CONTEXT('PA_TASK_APPROVAL_WF','Start_Task_Aprv_Wf');

Line 433: WF_CORE.CONTEXT('PA_TASK_APPROVAL_WF','Start_Task_Aprv_Wf');

429: WF_CORE.CONTEXT('PA_TASK_APPROVAL_WF ','Start_Task_Aprv_Wf');
430: RAISE;
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432: x_err_code := SQLCODE;
433: WF_CORE.CONTEXT('PA_TASK_APPROVAL_WF','Start_Task_Aprv_Wf');
434: RAISE;
435: WHEN OTHERS THEN
436: --b6694902_debug.debug('In Others Exception ');
437: --wf_engine.threshold := l_save_threshold;

Line 990: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Child_Task',itemtype, itemkey, to_char(actid), funcmode);

986: log_message('Task '||l_proj_element||' is a top/root task',3);
987: END IF;
988: EXCEPTION
989: WHEN FND_API.G_EXC_ERROR THEN
990: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Child_Task',itemtype, itemkey, to_char(actid), funcmode);
991: RAISE;
992:
993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
994: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Child_Task',itemtype, itemkey, to_char(actid), funcmode);

Line 994: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Child_Task',itemtype, itemkey, to_char(actid), funcmode);

990: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Child_Task',itemtype, itemkey, to_char(actid), funcmode);
991: RAISE;
992:
993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
994: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Child_Task',itemtype, itemkey, to_char(actid), funcmode);
995: RAISE;
996:
997: WHEN OTHERS THEN
998: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Child_Task',itemtype, itemkey, to_char(actid), funcmode);

Line 998: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Child_Task',itemtype, itemkey, to_char(actid), funcmode);

994: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Child_Task',itemtype, itemkey, to_char(actid), funcmode);
995: RAISE;
996:
997: WHEN OTHERS THEN
998: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Child_Task',itemtype, itemkey, to_char(actid), funcmode);
999: RAISE;
1000: END Is_Child_Task;
1001:
1002: -- If the task, which is submitted for Approval is a child task, this procedure verifies if its parent

Line 1086: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Parent_Task_Approved',itemtype, itemkey, to_char(actid), funcmode);

1082: resultout := wf_engine.eng_completed||':'||'F';
1083: END IF;
1084: EXCEPTION
1085: WHEN FND_API.G_EXC_ERROR THEN
1086: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Parent_Task_Approved',itemtype, itemkey, to_char(actid), funcmode);
1087: RAISE;
1088:
1089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1090: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Parent_Task_Approved',itemtype, itemkey, to_char(actid), funcmode);

Line 1090: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Parent_Task_Approved',itemtype, itemkey, to_char(actid), funcmode);

1086: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Parent_Task_Approved',itemtype, itemkey, to_char(actid), funcmode);
1087: RAISE;
1088:
1089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1090: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Parent_Task_Approved',itemtype, itemkey, to_char(actid), funcmode);
1091: RAISE;
1092:
1093: WHEN OTHERS THEN
1094: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Parent_Task_Approved',itemtype, itemkey, to_char(actid), funcmode);

Line 1094: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Parent_Task_Approved',itemtype, itemkey, to_char(actid), funcmode);

1090: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Parent_Task_Approved',itemtype, itemkey, to_char(actid), funcmode);
1091: RAISE;
1092:
1093: WHEN OTHERS THEN
1094: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Parent_Task_Approved',itemtype, itemkey, to_char(actid), funcmode);
1095: RAISE;
1096: END Is_Parent_Task_Approved;
1097:
1098: -- This procedure calls PA_TASKS_MAINT_PUB.CREATE_TASK API that populates pa_tasks.

Line 1324: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Post_Task',itemtype, itemkey, to_char(actid), funcmode);

1320: resultout := wf_engine.eng_completed||':'||'T';
1321: END IF;
1322: EXCEPTION
1323: WHEN FND_API.G_EXC_ERROR THEN
1324: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Post_Task',itemtype, itemkey, to_char(actid), funcmode);
1325: RAISE;
1326:
1327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1328: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Post_Task',itemtype, itemkey, to_char(actid), funcmode);

Line 1328: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Post_Task',itemtype, itemkey, to_char(actid), funcmode);

1324: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Post_Task',itemtype, itemkey, to_char(actid), funcmode);
1325: RAISE;
1326:
1327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1328: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Post_Task',itemtype, itemkey, to_char(actid), funcmode);
1329: RAISE;
1330:
1331: WHEN OTHERS THEN
1332: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Post_Task',itemtype, itemkey, to_char(actid), funcmode);

Line 1332: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Post_Task',itemtype, itemkey, to_char(actid), funcmode);

1328: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Post_Task',itemtype, itemkey, to_char(actid), funcmode);
1329: RAISE;
1330:
1331: WHEN OTHERS THEN
1332: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Post_Task',itemtype, itemkey, to_char(actid), funcmode);
1333: RAISE;
1334: END Post_Task;
1335:
1336: -- This is to update the task status to 'Pending' in case if the submitted task has

Line 1412: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Update_Task_Status',itemtype, itemkey, to_char(actid), funcmode);

1408: );
1409: END IF;
1410: EXCEPTION
1411: WHEN FND_API.G_EXC_ERROR THEN
1412: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Update_Task_Status',itemtype, itemkey, to_char(actid), funcmode);
1413: RAISE;
1414:
1415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1416: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Update_Task_Status',itemtype, itemkey, to_char(actid), funcmode);

Line 1416: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Update_Task_Status',itemtype, itemkey, to_char(actid), funcmode);

1412: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Update_Task_Status',itemtype, itemkey, to_char(actid), funcmode);
1413: RAISE;
1414:
1415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1416: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Update_Task_Status',itemtype, itemkey, to_char(actid), funcmode);
1417: RAISE;
1418:
1419: WHEN OTHERS THEN
1420: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Update_Task_Status',itemtype, itemkey, to_char(actid), funcmode);

Line 1420: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Update_Task_Status',itemtype, itemkey, to_char(actid), funcmode);

1416: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Update_Task_Status',itemtype, itemkey, to_char(actid), funcmode);
1417: RAISE;
1418:
1419: WHEN OTHERS THEN
1420: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Update_Task_Status',itemtype, itemkey, to_char(actid), funcmode);
1421: RAISE;
1422:
1423: END Update_Task_Status;
1424:

Line 1524: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Delete_Task',itemtype, itemkey, to_char(actid), funcmode);

1520: END LOOP;
1521:
1522: EXCEPTION
1523: WHEN FND_API.G_EXC_ERROR THEN
1524: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Delete_Task',itemtype, itemkey, to_char(actid), funcmode);
1525: RAISE;
1526:
1527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1528: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Delete_Task',itemtype, itemkey, to_char(actid), funcmode);

Line 1528: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Delete_Task',itemtype, itemkey, to_char(actid), funcmode);

1524: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Delete_Task',itemtype, itemkey, to_char(actid), funcmode);
1525: RAISE;
1526:
1527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1528: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Delete_Task',itemtype, itemkey, to_char(actid), funcmode);
1529: RAISE;
1530:
1531: WHEN OTHERS THEN
1532: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Delete_Task',itemtype, itemkey, to_char(actid), funcmode);

Line 1532: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Delete_Task',itemtype, itemkey, to_char(actid), funcmode);

1528: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Delete_Task',itemtype, itemkey, to_char(actid), funcmode);
1529: RAISE;
1530:
1531: WHEN OTHERS THEN
1532: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Delete_Task',itemtype, itemkey, to_char(actid), funcmode);
1533: RAISE;
1534:
1535: END Delete_Task;
1536:

Line 1656: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Verify_Task_Status',itemtype, itemkey, to_char(actid), funcmode);

1652: resultout := wf_engine.eng_completed||':'||'T';
1653: END IF;
1654: EXCEPTION
1655: WHEN FND_API.G_EXC_ERROR THEN
1656: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Verify_Task_Status',itemtype, itemkey, to_char(actid), funcmode);
1657: RAISE;
1658:
1659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1660: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Verify_Task_Status',itemtype, itemkey, to_char(actid), funcmode);

Line 1660: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Verify_Task_Status',itemtype, itemkey, to_char(actid), funcmode);

1656: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Verify_Task_Status',itemtype, itemkey, to_char(actid), funcmode);
1657: RAISE;
1658:
1659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1660: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Verify_Task_Status',itemtype, itemkey, to_char(actid), funcmode);
1661: RAISE;
1662:
1663: WHEN OTHERS THEN
1664: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Verify_Task_Status',itemtype, itemkey, to_char(actid), funcmode);

Line 1664: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Verify_Task_Status',itemtype, itemkey, to_char(actid), funcmode);

1660: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Verify_Task_Status',itemtype, itemkey, to_char(actid), funcmode);
1661: RAISE;
1662:
1663: WHEN OTHERS THEN
1664: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Verify_Task_Status',itemtype, itemkey, to_char(actid), funcmode);
1665: RAISE;
1666: END Verify_Task_Status;
1667:
1668: -- In case the change document is submitted for approval, we mark the change document to 'CI_SUBMITTED'

Line 1701: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Mark_CO_Status',itemtype, itemkey, to_char(actid), funcmode);

1697: resultout := wf_engine.eng_completed||':'||'T';
1698: END IF;
1699: EXCEPTION
1700: WHEN FND_API.G_EXC_ERROR THEN
1701: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Mark_CO_Status',itemtype, itemkey, to_char(actid), funcmode);
1702: RAISE;
1703:
1704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1705: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Mark_CO_Status',itemtype, itemkey, to_char(actid), funcmode);

Line 1705: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Mark_CO_Status',itemtype, itemkey, to_char(actid), funcmode);

1701: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Mark_CO_Status',itemtype, itemkey, to_char(actid), funcmode);
1702: RAISE;
1703:
1704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1705: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Mark_CO_Status',itemtype, itemkey, to_char(actid), funcmode);
1706: RAISE;
1707:
1708: WHEN OTHERS THEN
1709: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Mark_CO_Status',itemtype, itemkey, to_char(actid), funcmode);

Line 1709: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Mark_CO_Status',itemtype, itemkey, to_char(actid), funcmode);

1705: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Mark_CO_Status',itemtype, itemkey, to_char(actid), funcmode);
1706: RAISE;
1707:
1708: WHEN OTHERS THEN
1709: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Mark_CO_Status',itemtype, itemkey, to_char(actid), funcmode);
1710: RAISE;
1711: END Mark_CO_Status;
1712:
1713: -- This procedure is being called from Task Approval workflow when the Approver chooses

Line 1912: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Last_Task',itemtype, itemkey, to_char(actid), funcmode);

1908: resultout := wf_engine.eng_completed||':'||'T';
1909: END IF;
1910: EXCEPTION
1911: WHEN FND_API.G_EXC_ERROR THEN
1912: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Last_Task',itemtype, itemkey, to_char(actid), funcmode);
1913: RAISE;
1914:
1915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1916: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Last_Task',itemtype, itemkey, to_char(actid), funcmode);

Line 1916: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Last_Task',itemtype, itemkey, to_char(actid), funcmode);

1912: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Last_Task',itemtype, itemkey, to_char(actid), funcmode);
1913: RAISE;
1914:
1915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1916: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Last_Task',itemtype, itemkey, to_char(actid), funcmode);
1917: RAISE;
1918:
1919: WHEN OTHERS THEN
1920: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Last_Task',itemtype, itemkey, to_char(actid), funcmode);

Line 1920: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Last_Task',itemtype, itemkey, to_char(actid), funcmode);

1916: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Last_Task',itemtype, itemkey, to_char(actid), funcmode);
1917: RAISE;
1918:
1919: WHEN OTHERS THEN
1920: WF_CORE.CONTEXT('PA_TASK_WORKFLOW_PKG','Is_Last_Task',itemtype, itemkey, to_char(actid), funcmode);
1921: RAISE;
1922: END Is_Last_Task;
1923:
1924: END PA_TASK_WORKFLOW_PKG;