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.

[Home] [Help]

APPS.PA_TASK_WORKFLOW_PKG dependencies on FND_API

Line 428: WHEN FND_API.G_EXC_ERROR THEN

424: x_err_stack := l_err_stack;
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;

Line 431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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');
434: RAISE;
435: WHEN OTHERS THEN

Line 438: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

434: RAISE;
435: WHEN OTHERS THEN
436: --b6694902_debug.debug('In Others Exception ');
437: --wf_engine.threshold := l_save_threshold;
438: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: FND_MSG_PUB.Add_Exc_Msg
440: ( p_pkg_name => 'PA_TASK_APPROVAL_PKG'
441: , p_procedure_name => 'Start_Task_Aprv_Wf'
442: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')

Line 565: PA_PAGE_CONTENTS_PUB.Create_Page_Contents(p_init_msg_list => fnd_api.g_false

561: log_message('Creating the page content' ,3);
562:
563: -- Creating new page content in pa_page_contents.
564: log_message('Before calling PA_PAGE_CONTENTS_PUB.create_page_contents' ,3);
565: PA_PAGE_CONTENTS_PUB.Create_Page_Contents(p_init_msg_list => fnd_api.g_false
566: ,p_validate_only => fnd_api.g_false
567: ,p_object_type => 'PA_TASK_APPROVAL_WF'
568: ,p_pk1_value => p_task_id
569: ,p_pk2_value => NULL

Line 566: ,p_validate_only => fnd_api.g_false

562:
563: -- Creating new page content in pa_page_contents.
564: log_message('Before calling PA_PAGE_CONTENTS_PUB.create_page_contents' ,3);
565: PA_PAGE_CONTENTS_PUB.Create_Page_Contents(p_init_msg_list => fnd_api.g_false
566: ,p_validate_only => fnd_api.g_false
567: ,p_object_type => 'PA_TASK_APPROVAL_WF'
568: ,p_pk1_value => p_task_id
569: ,p_pk2_value => NULL
570: ,x_page_content_id => l_page_content_id

Line 841: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

837: ,x_return_status => l_return_status
838: ,x_msg_count => l_msg_count
839: ,x_msg_data => l_msg_data);
840:
841: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
842: WF_NOTIFICATION.WriteToClob(document, 'Content Generation failed');
843: DBMS_LOB.writeappend(document, 255, SUBSTR(l_msg_data, 255));
844: END IF;
845: ELSE

Line 989: WHEN FND_API.G_EXC_ERROR THEN

985: resultout := wf_engine.eng_completed||':'||'F';
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

Line 993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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);
995: RAISE;
996:
997: WHEN OTHERS THEN

Line 1085: WHEN FND_API.G_EXC_ERROR THEN

1081: log_message('Parent Task '||l_parent_task_id||' of task '||l_proj_element||' is not yet approved',3);
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

Line 1089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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);
1091: RAISE;
1092:
1093: WHEN OTHERS THEN

Line 1237: ,p_init_msg_list => FND_API.G_FALSE

1233: log_message('Before calling PA_TASKS_MAINT_PUB.CREATE_TASK',3);
1234: PA_TASKS_MAINT_PUB.CREATE_TASK
1235: (
1236: p_calling_module => 'SELF_SERVICE'
1237: ,p_init_msg_list => FND_API.G_FALSE
1238: ,p_debug_mode => 'Y'
1239: ,p_project_id => l_project_id
1240: ,p_reference_task_id => l_parent_task_id
1241: ,p_peer_or_sub => 'SUB'

Line 1323: WHEN FND_API.G_EXC_ERROR THEN

1319: END LOOP;
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

Line 1327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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);
1329: RAISE;
1330:
1331: WHEN OTHERS THEN

Line 1411: WHEN FND_API.G_EXC_ERROR THEN

1407: ,avalue => l_content_id
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

Line 1415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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);
1417: RAISE;
1418:
1419: WHEN OTHERS THEN

Line 1523: WHEN FND_API.G_EXC_ERROR THEN

1519: END LOOP;
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

Line 1527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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);
1529: RAISE;
1530:
1531: WHEN OTHERS THEN

Line 1655: WHEN FND_API.G_EXC_ERROR THEN

1651: log_message('There is no task pending for Approval, which is used in this Change document',3);
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

Line 1659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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);
1661: RAISE;
1662:
1663: WHEN OTHERS THEN

Line 1700: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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);
1706: RAISE;
1707:
1708: WHEN OTHERS THEN

Line 1911: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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);
1917: RAISE;
1918:
1919: WHEN OTHERS THEN