202: -- Call the API. Notice that we are doing a quiet commit by setting
203: -- the commit flag
204: CS_Workflow_PUB.Launch_Servereq_Workflow (
205: p_api_version => 1.0,
206: p_init_msg_list => FND_API.G_TRUE,
207: p_commit => FND_API.G_TRUE,
208: p_return_status => l_return_status,
209: p_msg_count => l_msg_count,
210: p_msg_data => l_msg_data,
203: -- the commit flag
204: CS_Workflow_PUB.Launch_Servereq_Workflow (
205: p_api_version => 1.0,
206: p_init_msg_list => FND_API.G_TRUE,
207: p_commit => FND_API.G_TRUE,
208: p_return_status => l_return_status,
209: p_msg_count => l_msg_count,
210: p_msg_data => l_msg_data,
211: p_request_number => p_request_number,
212: p_initiator_user_id => p_initiator_user_id,
213: p_initiator_resp_id => p_initiator_resp_id,
214: p_initiator_resp_appl_id=> p_initiator_resp_appl_id,
215: p_itemkey => l_itemkey,
216: p_nowait => FND_API.G_TRUE );
217:
218: -- Check for possible errors returned by the API
219: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
220: raise l_API_ERROR;
215: p_itemkey => l_itemkey,
216: p_nowait => FND_API.G_TRUE );
217:
218: -- Check for possible errors returned by the API
219: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
220: raise l_API_ERROR;
221: END IF;
222:
223: l_pos := INSTR(l_itemkey, '-');
255: -- Call the API. Notice that we are doing a quiet commit by setting
256: -- the commit flag
257: CS_Workflow_PUB.Cancel_Servereq_Workflow (
258: p_api_version => 1.0,
259: p_init_msg_list => FND_API.G_TRUE,
260: p_commit => FND_API.G_TRUE,
261: p_return_status => l_return_status,
262: p_msg_count => l_msg_count,
263: p_msg_data => l_msg_data,
256: -- the commit flag
257: CS_Workflow_PUB.Cancel_Servereq_Workflow (
258: p_api_version => 1.0,
259: p_init_msg_list => FND_API.G_TRUE,
260: p_commit => FND_API.G_TRUE,
261: p_return_status => l_return_status,
262: p_msg_count => l_msg_count,
263: p_msg_data => l_msg_data,
264: p_request_number => p_request_number,
265: p_wf_process_id => p_wf_process_id,
266: p_user_id => p_user_id );
267:
268: -- Check for possible errors returned by the API
269: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
270: raise l_API_ERROR;
271: END IF;
272:
273: EXCEPTION
306: -- Call the API. Notice that we are doing a quiet commit by setting
307: -- the commit flag
308: CS_Workflow_PUB.Cancel_Servereq_Workflow (
309: p_api_version => 1.0,
310: p_init_msg_list => FND_API.G_TRUE,
311: p_commit => FND_API.G_TRUE,
312: p_return_status => l_return_status,
313: p_msg_count => x_msg_count,
314: p_msg_data => x_msg_data,
307: -- the commit flag
308: CS_Workflow_PUB.Cancel_Servereq_Workflow (
309: p_api_version => 1.0,
310: p_init_msg_list => FND_API.G_TRUE,
311: p_commit => FND_API.G_TRUE,
312: p_return_status => l_return_status,
313: p_msg_count => x_msg_count,
314: p_msg_data => x_msg_data,
315: p_request_number => p_request_number,
316: p_wf_process_id => p_wf_process_id,
317: p_user_id => p_user_id );
318:
319: -- Check for possible errors returned by the API
320: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
321: raise l_API_ERROR;
322: END IF;
323:
324: EXCEPTION
408: SAVEPOINT Start_Action_Workflow;
409:
410: -- Determine whether this call is made from the Dispatch window
411: IF (p_launched_by_dispatch = 'Y') THEN
412: l_launched_by_dispatch := FND_API.G_TRUE;
413: ELSE
414: l_launched_by_dispatch := FND_API.G_FALSE;
415: END IF;
416: -- Call the API. Notice that we are doing a quiet commit by setting
410: -- Determine whether this call is made from the Dispatch window
411: IF (p_launched_by_dispatch = 'Y') THEN
412: l_launched_by_dispatch := FND_API.G_TRUE;
413: ELSE
414: l_launched_by_dispatch := FND_API.G_FALSE;
415: END IF;
416: -- Call the API. Notice that we are doing a quiet commit by setting
417: -- the commit flag
418:
430:
431: /*CS_Workflow_PUB.launch_Action_Workflow
432: (
433: p_api_version => 1.0,
434: p_init_msg_list => FND_API.G_TRUE,
435: p_commit => FND_API.G_TRUE,
436: p_return_status => l_return_status,
437: p_msg_count => l_msg_count,
438: p_msg_data => l_msg_data,
431: /*CS_Workflow_PUB.launch_Action_Workflow
432: (
433: p_api_version => 1.0,
434: p_init_msg_list => FND_API.G_TRUE,
435: p_commit => FND_API.G_TRUE,
436: p_return_status => l_return_status,
437: p_msg_count => l_msg_count,
438: p_msg_data => l_msg_data,
439: p_request_id => p_request_id,
442: p_initiator_resp_id => p_initiator_resp_id,
443: p_initiator_resp_appl_id => p_initiator_resp_appl_id,
444: p_launched_by_dispatch => l_launched_by_dispatch,
445: p_itemkey => l_itemkey,
446: p_nowait => FND_API.G_TRUE
447: );*/
448:
449: -- Check for possible errors returned by the API
450: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
446: p_nowait => FND_API.G_TRUE
447: );*/
448:
449: -- Check for possible errors returned by the API
450: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
451: RAISE l_exc_api_error;
452: END IF;
453:
454: l_pos := INSTR(l_itemkey, '-');
497: -- Call the API. Notice that we are doing a quiet commit by setting
498: -- the commit flag
499: CS_Workflow_PUB.Cancel_Action_Workflow
500: ( p_api_version => 1.0,
501: p_init_msg_list => FND_API.G_TRUE,
502: p_commit => FND_API.G_TRUE,
503: p_return_status => l_return_status,
504: p_msg_count => l_msg_count,
505: p_msg_data => l_msg_data,
498: -- the commit flag
499: CS_Workflow_PUB.Cancel_Action_Workflow
500: ( p_api_version => 1.0,
501: p_init_msg_list => FND_API.G_TRUE,
502: p_commit => FND_API.G_TRUE,
503: p_return_status => l_return_status,
504: p_msg_count => l_msg_count,
505: p_msg_data => l_msg_data,
506: p_request_id => p_request_id,
510: p_launched_by_dispatch => l_launched_by_dispatch
511: );
512:
513: -- Check for possible errors returned by the API
514: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
515: RAISE l_exc_api_error;
516: END IF;
517:
518: IF FND_API.To_Boolean(l_launched_by_dispatch) THEN
514: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
515: RAISE l_exc_api_error;
516: END IF;
517:
518: IF FND_API.To_Boolean(l_launched_by_dispatch) THEN
519: p_launched_by_dispatch := 'Y';
520: ELSE
521: p_launched_by_dispatch := 'N';
522: END IF;
723:
724:
725: CS_Workflow_PUB.Launch_Servereq_Workflow (
726: p_api_version => 1.0,
727: p_init_msg_list => FND_API.G_TRUE,
728: p_commit => FND_API.G_TRUE,
729: p_return_status => l_return_status,
730: p_msg_count => x_msg_count,
731: p_msg_data => x_msg_data,
724:
725: CS_Workflow_PUB.Launch_Servereq_Workflow (
726: p_api_version => 1.0,
727: p_init_msg_list => FND_API.G_TRUE,
728: p_commit => FND_API.G_TRUE,
729: p_return_status => l_return_status,
730: p_msg_count => x_msg_count,
731: p_msg_data => x_msg_data,
732: p_request_number => p_request_number,
733: p_initiator_user_id => p_initiator_user_id,
734: p_initiator_resp_id => p_initiator_resp_id,
735: p_initiator_resp_appl_id=> p_initiator_resp_appl_id,
736: p_itemkey => l_itemkey,
737: p_nowait => FND_API.G_TRUE );
738:
739: -- Check for possible errors returned by the API
740: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
741: raise l_API_ERROR;
736: p_itemkey => l_itemkey,
737: p_nowait => FND_API.G_TRUE );
738:
739: -- Check for possible errors returned by the API
740: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
741: raise l_API_ERROR;
742: END IF;
743:
744: l_pos := INSTR(l_itemkey, '-');