APPS.PA_PROGRESS_REPORT_WORKFLOW dependencies on FND_API

Line 106: x_return_status := FND_API.G_RET_STS_SUCCESS;

102: from dual;
103:
104: x_item_key := To_char(l_item_key);
105:
106: x_return_status := FND_API.G_RET_STS_SUCCESS;
107:
108:
109: --debug_msg ( 'before WF_ENGINE createProcess: ' || p_Process_Name);
110:

Line 127: IF x_return_status = FND_API.g_ret_sts_success then

123: , x_msg_data
124: , x_return_status
125: );
126:
127: IF x_return_status = FND_API.g_ret_sts_success then
128:
129: --debug_msg ( 'before WF_ENGINE startProcess' );
130: --debug_msg ( 'startProcess: item_type = ' || p_item_type || ' item_key = ' || x_Item_Key );
131:

Line 175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

171:
172:
173: x_msg_count := 1;
174: x_msg_data := substr(SQLERRM,1,2000);
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176:
177: RAISE;
178:
179: END start_workflow;

Line 202: x_return_status := FND_API.G_RET_STS_SUCCESS;

198:
199: BEGIN
200:
201:
202: x_return_status := FND_API.G_RET_STS_SUCCESS;
203:
204: --debug_msg ( 'after client cancel_workflow call' );
205:
206: IF (x_return_status = FND_API.g_ret_sts_success) THEN

Line 206: IF (x_return_status = FND_API.g_ret_sts_success) THEN

202: x_return_status := FND_API.G_RET_STS_SUCCESS;
203:
204: --debug_msg ( 'after client cancel_workflow call' );
205:
206: IF (x_return_status = FND_API.g_ret_sts_success) THEN
207: WF_ENGINE.AbortProcess( p_Item_Type
208: , p_Item_Key
209: );
210:

Line 225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

221: --debug_msg ( 'Exception in Cancel_Wf ' || substr(SQLERRM,1,2000) );
222:
223: x_msg_count := 1;
224: x_msg_data := substr(SQLERRM,1,2000);
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: RAISE;
227: END Cancel_workflow;
228:
229: /********************************************************************

Line 249: x_return_status := FND_API.G_RET_STS_SUCCESS;

245: IS
246:
247: BEGIN
248:
249: x_return_status := FND_API.G_RET_STS_SUCCESS;
250:
251:
252: --debug_msg ('before web url = ');
253:

Line 269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

265: WHEN OTHERS THEN
266: --debug_msg ( 'Exception in Get_Wf_Url ' || substr(SQLERRM,1,2000) );
267: x_msg_count := 1;
268: x_msg_data := substr(SQLERRM,1,2000);
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: RAISE;
271:
272: END get_workflow_url;
273:

Line 764: x_return_status := FND_API.G_RET_STS_SUCCESS;

760: INTO l_item_key
761: from dual;
762:
763:
764: x_return_status := FND_API.G_RET_STS_SUCCESS;
765:
766:
767: -- create the workflow process
768:

Line 942: IF x_return_status = FND_API.g_ret_sts_success then

938:
939: -- ready to start the workflow
940:
941: --debug_msg_s1 ('after workflow 1' || x_return_status);
942: IF x_return_status = FND_API.g_ret_sts_success then
943:
944:
945: --debug_msg_s1 ('after workflow 1: start process');
946:

Line 978: x_return_status := FND_API.G_RET_STS_ERROR;

974:
975: IF l_err_code <> 0 THEN
976: PA_UTILS.Add_Message( p_app_short_name => 'PA'
977: ,p_msg_name => 'PA_PR_CREATE_WF_FAILED');
978: x_return_status := FND_API.G_RET_STS_ERROR;
979:
980: END IF;
981:
982:

Line 994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

990:
991: --debug_msg_s1 ('after workflow 1: exception' || substr(SQLERRM,1,2000));
992: x_msg_count := 1;
993: x_msg_data := substr(SQLERRM,1,2000);
994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
995:
996: RAISE;
997:
998: END start_action_set_workflow;

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

2679: ,x_return_status => l_return_status
2680: ,x_msg_count => l_msg_count
2681: ,x_msg_data => l_msg_data
2682: );
2683: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
2684: WF_NOTIFICATION.WriteToClob(document, 'Report Content Generation failed');
2685: dbms_lob.writeappend(document, 255, substr(Sqlerrm, 255));
2686: end if;
2687: