DBA Data[Home] [Help]

APPS.PA_WORKPLAN_WORKFLOW dependencies on FND_API

Line 21: x_return_status := FND_API.g_ret_sts_success;

17: )
18: IS
19: l_item_key NUMBER;
20: BEGIN
21: x_return_status := FND_API.g_ret_sts_success;
22:
23: select pa_workflow_itemkey_s.nextval
24: into l_item_key
25: from dual;

Line 45: IF x_return_status = FND_API.g_ret_sts_success THEN

41: x_return_status
42: );
43:
44:
45: IF x_return_status = FND_API.g_ret_sts_success THEN
46: WF_ENGINE.startProcess(p_item_type,
47: x_item_key);
48: END IF;
49:

Line 54: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

50: EXCEPTION
51: WHEN OTHERS THEN
52: x_msg_count :=1;
53: x_msg_data:= substrb(SQLERRM, 1, 2000); -- 4537865 : Replaced substr with substrb
54: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
55: x_item_key := NULL ; -- 4537865
56: END START_WORKFLOW;
57:
58:

Line 70: x_return_status := FND_API.G_RET_STS_SUCCESS;

66: )
67: IS
68:
69: BEGIN
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71:
72: WF_ENGINE.ABORTPROCESS(p_item_type,
73: p_item_key);
74: EXCEPTION

Line 78: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

74: EXCEPTION
75: WHEN OTHERS THEN
76: x_msg_count :=1;
77: x_msg_data:= substrb(SQLERRM, 1, 2000); -- 4537865 : Replaced substr with substrb
78: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
79: END CANCEL_WORKFLOW;
80:
81:
82: procedure check_workplan_status

Line 351: IF (l_return_status = FND_API.g_ret_sts_success) THEN

347: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_return_status='||l_return_status, x_Log_Level=> 3);
348: END IF;
349:
350:
351: IF (l_return_status = FND_API.g_ret_sts_success) THEN
352: wf_engine.SetItemAttrNumber(itemtype, itemkey,
353: 'RECORD_VERSION_NUMBER',l_record_version_num+1);
354: END IF;
355:

Line 432: p_encoded => Fnd_Api.G_FALSE

428: IF l_debug_mode = 'Y' THEN
429: pa_debug.write(x_Module=>'PA_WORKPLAN_WORKFLOW.CHANGE_STATUS_APPROVED', x_Msg => 'l_return_status='||l_return_status, x_Log_Level=> 3);
430: for i in 1..fnd_msg_pub.count_msg loop
431: pa_interface_utils_pub.get_messages (
432: p_encoded => Fnd_Api.G_FALSE
433: ,p_data => l_data
434: ,p_msg_index => i
435: ,p_msg_count => l_msg_count
436: ,p_msg_data => l_msg_data

Line 698: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

694: ,x_msg_count => l_msg_count
695: ,x_msg_data => l_msg_data
696: );
697:
698: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
699: WF_NOTIFICATION.WriteToClob(document, 'Content Generation failed');
700: dbms_lob.writeappend(document, 255, substr(Sqlerrm, 255));
701: end if;
702:

Line 753: x_return_status := FND_API.G_RET_STS_SUCCESS;

749: is_wf_running_rec is_wf_running%ROWTYPE ;
750:
751: BEGIN
752: x_msg_count := 0;
753: x_return_status := FND_API.G_RET_STS_SUCCESS;
754: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
755:
756: IF l_debug_mode = 'Y' THEN
757: PA_DEBUG.set_curr_function( p_function => 'START_PROJECT_EXECUTION_WF',

Line 779: -- x_return_status := FND_API.G_RET_STS_ERROR;

775: IF nvl(l_wf_enabled,'N') = 'N' THEN
776: -- Stop further processing and return .
777: -- PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
778: -- p_msg_name => 'PA_PS_CREATE_WF_FAILED');
779: -- x_return_status := FND_API.G_RET_STS_ERROR;
780: RETURN ;
781: END IF ;
782:
783:

Line 834: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

830:
831: wf_engine.startprocess(l_item_type
832: ,to_char(p_project_id));
833:
834: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
835: --update pa_wf_process_table
836: PA_WORKFLOW_UTILS.INSERT_WF_PROCESSES
837: (
838: p_wf_type_code => 'PROJECT'

Line 852: x_return_status := FND_API.G_RET_STS_ERROR;

848:
849: IF (l_err_code <> 0) THEN
850: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
851: p_msg_name => 'PA_PS_CREATE_WF_FAILED');
852: x_return_status := FND_API.G_RET_STS_ERROR;
853: END IF;
854:
855: ELSE
856: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 858: x_return_status := FND_API.G_RET_STS_ERROR;

854:
855: ELSE
856: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
857: p_msg_name => 'PA_PS_CREATE_WF_FAILED');
858: x_return_status := FND_API.G_RET_STS_ERROR;
859: END IF;
860:
861: EXCEPTION
862: WHEN OTHERS THEN

Line 865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

861: EXCEPTION
862: WHEN OTHERS THEN
863: x_msg_count :=1;
864: x_msg_data:= substrb(SQLERRM, 1, 2000); -- 4537865 : Replaced substr with substrb
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866: /* 5369295 -- Added fnd_msg_pub.add_exc_msg() for bug 5366726 */
867: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_WORKFLOW',
868: p_procedure_name => 'START_PROJECT_EXECUTION_WF',
869: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 885: x_return_status := FND_API.g_ret_sts_success;

881:
882: l_item_type VARCHAR2(30) := 'PAPRJEX' ;
883:
884: BEGIN
885: x_return_status := FND_API.g_ret_sts_success;
886:
887: WF_ENGINE.AbortProcess(l_item_type
888: , to_char(p_project_id)
889: );

Line 901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

897: EXCEPTION
898: WHEN OTHERS THEN
899: x_msg_count :=1;
900: x_msg_data:= substrb(SQLERRM, 1, 2000); -- 4537865 : Replaced substr with substrb
901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
902: END CANCEL_PROJECT_EXECUTION_WF ;
903:
904: PROCEDURE START_TASK_EXECUTION_WF
905: ( itemtype in varchar2

Line 1145: x_return_status := FND_API.G_RET_STS_ERROR;

1141: FETCH task_info INTO task_info_rec ;
1142: CLOSE task_info ;
1143:
1144: IF nvl(task_info_rec.enable_wf_flag,'N') = 'N' THEN
1145: x_return_status := FND_API.G_RET_STS_ERROR;
1146: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
1147: ,p_msg_name => 'PA_WF_IS_NOT_ENABLED_TASK');
1148: RETURN ;
1149: END IF ;

Line 1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ; -- 4537865

1212: EXCEPTION
1213: WHEN OTHERS THEN
1214: x_msg_count := 1; -- 4537865
1215: x_msg_data := SUBSTRB(SQLERRM,1,240); -- 4537865
1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ; -- 4537865
1217: RAISE ;
1218: END RESTART_TASK_EXECUTION_WF ;
1219:
1220:

Line 1249: x_return_status := FND_API.g_ret_sts_success;

1245: get_item_type_rec get_item_type%ROWTYPE ;
1246:
1247: BEGIN
1248:
1249: x_return_status := FND_API.g_ret_sts_success;
1250: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1251:
1252: IF l_debug_mode = 'Y' THEN
1253: Pa_Debug.g_err_stage:= 'CANCEL_TASK_EXECUTION_WF : Cancel Task Execution Workflow';

Line 1280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1276: EXCEPTION
1277: WHEN OTHERS THEN
1278: x_msg_count :=1;
1279: x_msg_data:= substrb(SQLERRM, 1, 2000); -- 4537865 : Replaced substr with substrb
1280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1281: END CANCEL_TASK_EXECUTION_WF ;
1282:
1283:
1284: PROCEDURE IS_PROJECT_CLOSED