eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TASK_WORKFLOW_PKG dependencies on PA_TASK_WORKFLOW_PKG

Line 1: PACKAGE BODY PA_TASK_WORKFLOW_PKG as

1: PACKAGE BODY PA_TASK_WORKFLOW_PKG as
2: /* $Header: PATSKWFB.pls 120.4.12010000.2 2009/08/11 07:25:53 anuragar noship $ */
3:
4: p_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: g_error_message VARCHAR2(1000) :='';

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 1271: PA_TASK_WORKFLOW_PKG.Start_Task_Aprv_Wf (

1267: -- This is to raise notification for all child tasks which are in submitted status when the parent task is approved.
1268: FOR parent_task IN C1(l_task_id) LOOP
1269: FOR child_task IN C2(parent_task.element_version_id, l_project_id) LOOP
1270:
1271: PA_TASK_WORKFLOW_PKG.Start_Task_Aprv_Wf (
1272: 'PATASKWF'
1273: ,'PA_TASK_APPROVAL_WF'
1274: ,l_project_id
1275: ,child_task.task_id

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 1631: PA_TASK_WORKFLOW_PKG.Start_Task_Aprv_Wf (

1627: IF l_max_notification_id IS NOT NULL THEN
1628: UPDATE WF_NOTIFICATIONS
1629: SET status = 'CLOSED'
1630: WHERE notification_id = l_max_notification_id;
1631: PA_TASK_WORKFLOW_PKG.Start_Task_Aprv_Wf (
1632: 'PATASKWF'
1633: ,'PA_TASK_APPROVAL_WF'
1634: ,l_project_id
1635: ,c_task_rec.task_id

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;

Line 1924: END PA_TASK_WORKFLOW_PKG;

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;