DBA Data[Home] [Help]

APPS.PA_BUDGET_INTG_WF dependencies on FND_API

Line 127: x_return_status := FND_API.G_RET_STS_SUCCESS;

123: -- Initialize Workflow, Messaging and Apps Globals ---------------------------
124:
125: --pa_fck_util.debug_msg('PAWFBUIB: BEGIN PA_BUDGET_INTG_WF.Start_Budget_Intg_WF');
126:
127: x_return_status := FND_API.G_RET_STS_SUCCESS;
128:
129: fnd_msg_pub.initialize;
130:
131: x_msg_count := 0;

Line 377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

373:
374: EXCEPTION
375: WHEN OTHERS THEN
376: wf_engine.threshold := l_save_threshold;
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: FND_MSG_PUB.Add_Exc_Msg
379: ( p_pkg_name => 'PA_BUDGET_INTG_WF'
380: , p_procedure_name => 'START_BUDGET_INTG_WF'
381: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')

Line 586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

582: );
583:
584: IF (l_err_code <> 0)
585: THEN
586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
587: END IF;
588:
589: -- -----------------------------------------------
590:

Line 656: l_return_status := FND_API.G_RET_STS_ERROR;

652: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
653: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
654: FND_MSG_PUB.add;
655: END IF;
656: l_return_status := FND_API.G_RET_STS_ERROR;
657:
658: ELSE
659: -- Process App Error
660: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 667: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

663: (p_pkg_name => 'PA_BUDGET_WF'
664: , p_procedure_name => 'START_BUDGET_WF'
665: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
666: END IF;
667: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
668: END IF; --(l_err_code > 0)
669:
670: END IF; --(l_err_code <> 0 )
671:

Line 735: IF (l_return_status = FND_API.G_RET_STS_SUCCESS)

731: -- cancel the workflow. ORA errors should be rare, however.
732:
733: -- bug 1929871, 19-SEP-2001, jwhite --------------------------
734: -- Added code to update the commitment budget, IF ANY
735: IF (l_return_status = FND_API.G_RET_STS_SUCCESS)
736: THEN
737: -- Success!
738:
739: -- Update Draft Cost Budget Version Id

Line 786: IF (l_return_status = FND_API.G_RET_STS_SUCCESS)

782: END IF; --NOT FIRED, Budget Approval WF; Update WF Status Code
783:
784:
785: -- Conditionally Process Notification Messages
786: IF (l_return_status = FND_API.G_RET_STS_SUCCESS)
787: THEN
788: -- Success!
789:
790: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_BU_INTG_SUCCESS');

Line 841: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)

837: p_msg_data => l_msg_data
838: );
839:
840: -- Hard ORA error. WF FAILURE! Notification will Route to Projects Sys Admin.
841: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
842: THEN
843:
844: -- Set WF Status for FAILURE. Route to Sys Admin
845: resultout := wf_engine.eng_completed||':'||'F';

Line 854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN -- R12 MOAC: Added unexpected error exception

850:
851: --pa_fck_util.debug_msg('PAWFBUIB: END PA_BUDGET_INTG_WF.Process_Bgt_Intg');
852:
853: EXCEPTION
854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN -- R12 MOAC: Added unexpected error exception
855: WF_CORE.CONTEXT
856: ('PA_BUDGET_INTG_MP',
857: 'Process_Bgt_Intg',
858: itemtype,

Line 965: (p_encoded => FND_API.G_FALSE,

961: IF i > 5 THEN
962: EXIT;
963: END IF;
964: pa_interface_utils_pub.get_messages
965: (p_encoded => FND_API.G_FALSE,
966: p_msg_index => i,
967: p_msg_count => p_msg_count ,
968: p_msg_data => p_msg_data ,
969: p_data => l_data,

Line 1019: x_return_status := FND_API.G_RET_STS_SUCCESS;

1015:
1016: BEGIN
1017:
1018: -- Assume Success
1019: x_return_status := FND_API.G_RET_STS_SUCCESS;
1020:
1021: -- Conditionally Populate wf_status_code
1022: IF (p_wf_result_code = 'SUCCESS')
1023: THEN

Line 1037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1033:
1034: EXCEPTION
1035: WHEN OTHERS
1036: THEN
1037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1038: FND_MSG_PUB.Add_Exc_Msg
1039: ( p_pkg_name => 'PA_BUDGET_INTG_WF'
1040: , p_procedure_name => 'SET_WF_STATUS_CODE'
1041: , p_error_text => 'ORA-'||LPAD(substr(SQLCODE,2),5,'0')