110: l_wf_process varchar2(30);
111:
112: BEGIN
113:
114: x_return_status := FND_API.G_RET_STS_SUCCESS;
115:
116: -- Validate item type and process
117: --
118:
166: end loop;
167:
168: EXCEPTION
169: WHEN OTHERS THEN
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
171:
172: END Process_catch_all_rec;
173:
174: Procedure Get_workflow_details
183: l_wf_process varchar2(30);
184:
185: BEGIN
186:
187: x_return_status := FND_API.G_RET_STS_SUCCESS;
188:
189: select WORKFLOW_ITEM_TYPE
190: , WORKFLOW_PROCESS_NAME
191: INTO x_WORKFLOW_ITEM_TYPE
197: WHEN NO_DATA_FOUND THEN
198: x_error_message := 'NODATA';
199: WHEN OTHERS THEN
200: x_error_message := 'NODATA';
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
202:
203: END Get_workflow_details;
204:
205: Procedure Start_Workflow_Process
213: l_wf_item_key NUMBER;
214:
215: BEGIN
216:
217: x_return_status := FND_API.G_RET_STS_SUCCESS;
218:
219: -- Validate item type and process
220: --
221:
220: --
221:
222: IF p_item_type IS NULL
223: OR p_wf_process IS NULL THEN
224: x_return_status := FND_API.G_RET_STS_ERROR;
225:
226: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log(' No Workflow or process found ' );
227:
228: RETURN;
280: commit;
281:
282: EXCEPTION
283: WHEN OTHERS THEN
284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
285: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log ('Erro Stating workflow '||SQLERRM);
286:
287: END Start_Workflow_Process;
288: