DBA Data[Home] [Help]

APPS.PA_FORECAST_ITEMS_GEN_WF_PKG dependencies on FND_API

Line 44: x_return_status := FND_API.G_RET_STS_SUCCESS;

40: l_err_stage VARCHAR2(2000);
41: l_err_stack VARCHAR2(2000);
42:
43: BEGIN
44: x_return_status := FND_API.G_RET_STS_SUCCESS;
45:
46: -- User lock for the given assignment id
47: /* l_lock_for := 'ASGMT'; Fixed bug#1612856
48: IF ( NVL(p_assignment_id,0) <> 0 ) THEN

Line 273: x_return_status := FND_API.G_RET_STS_ERROR;

269: wf_engine.threshold := l_save_thresh;
270: EXCEPTION
271: WHEN l_cannot_acquire_lock THEN
272: PA_FORECAST_ITEMS_UTILS.log_message('Unable to set lock for ' || to_char(p_assignment_id));
273: x_return_status := FND_API.G_RET_STS_ERROR;
274:
275: -- COMMIT;
276: END Launch_WorkFlow_Fi_Gen;
277:

Line 383: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

379: x_msg_count => l_x_msg_count,
380: x_msg_data => l_x_msg_data );
381: END IF;
382:
383: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
384: p_result := 'COMPLETE:S';
385: ELSIF (l_x_return_status = FND_API.G_RET_STS_ERROR ) THEN
386: ROLLBACK to l_forecast_item_gen ;
387: WF_ENGINE.SetItemAttrText

Line 385: ELSIF (l_x_return_status = FND_API.G_RET_STS_ERROR ) THEN

381: END IF;
382:
383: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
384: p_result := 'COMPLETE:S';
385: ELSIF (l_x_return_status = FND_API.G_RET_STS_ERROR ) THEN
386: ROLLBACK to l_forecast_item_gen ;
387: WF_ENGINE.SetItemAttrText
388: ( itemtype => p_item_type
389: , itemkey => p_item_key

Line 395: ELSIF (l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

391: , avalue => l_x_msg_data
392: );
393:
394: p_result := 'COMPLETE:F';
395: ELSIF (l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
396: ROLLBACK to l_forecast_item_gen ;
397: WF_ENGINE.SetItemAttrText
398: ( itemtype => p_item_type
399: , itemkey => p_item_key

Line 423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

419:
420: RETURN;
421:
422: EXCEPTION
423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
424: -- Setting the attribute value for Error
425: WF_ENGINE.SetItemAttrText
426: ( itemtype => p_item_type
427: , itemkey => p_item_key