DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_VIEW_GLOBAL dependencies on FND_API

Line 44: x_return_status := FND_API.G_RET_STS_SUCCESS;

40: l_org_id NUMBER;
41:
42: BEGIN
43:
44: x_return_status := FND_API.G_RET_STS_SUCCESS;
45:
46: pa_fin_plan_view_global.G_FP_VIEW_VERSION_ID := p_orgfcst_version_id;
47:
48: select project_id

Line 118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

114:
115:
116: EXCEPTION
117: WHEN OTHERS THEN
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
119: x_msg_count := 1;
120: x_msg_data := SQLERRM;
121: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_VIEW_GLOBAL',
122: p_procedure_name => 'pa_fp_set_orgfcst_version_id');

Line 136: x_return_status:= FND_API.G_RET_STS_SUCCESS;

132: )
133: IS
134:
135: BEGIN
136: x_return_status:= FND_API.G_RET_STS_SUCCESS;
137: pa_fin_plan_view_global.G_FP_ADJ_REASON_CODE := p_adj_reason_code;
138:
139: begin
140: select pe.adjustment_comments

Line 152: -- x_return_status := FND_API.G_RET_STS_ERROR;

148: and pe.ADJUSTMENT_REASON_CODE = pa_fin_plan_view_global.Get_Adj_Reason_Code();
149:
150: exception
151: when no_data_found then
152: -- x_return_status := FND_API.G_RET_STS_ERROR;
153: x_adj_comments := null;
154: end;
155:
156: EXCEPTION

Line 159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

155:
156: EXCEPTION
157:
158: WHEN OTHERS THEN
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160: x_msg_count := 1;
161: x_msg_data := SQLERRM;
162: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_VIEW_GLOBAL',
163: p_procedure_name => 'pa_fp_viewby_set_globals');

Line 187: x_return_status := FND_API.G_RET_STS_SUCCESS;

183: l_start_date VARCHAR2(30);
184:
185: BEGIN
186:
187: x_return_status := FND_API.G_RET_STS_SUCCESS;
188:
189: pa_fin_plan_view_global.G_FP_AMOUNT_TYPE_CODE := p_amount_type_code;
190: pa_fin_plan_view_global.G_FP_RA_ID := p_resource_assignment_id;
191: l_budget_version_id := p_budget_version_id;

Line 208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

204:
205:
206: EXCEPTION
207: WHEN OTHERS THEN
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209: x_msg_count := 1;
210: x_msg_data := SQLERRM;
211: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_VIEW_GLOBAL',
212: p_procedure_name => 'pa_fp_viewby_set_globals');

Line 248: x_return_status := FND_API.G_RET_STS_SUCCESS;

244: l_format_mask nls_session_parameters.value%TYPE;
245:
246: BEGIN
247:
248: x_return_status := FND_API.G_RET_STS_SUCCESS;
249:
250: /* Bug Fix 4373890
251: As a part of GSCC error fixes, modified the following statement
252: by adding the format mask

Line 693: x_return_status := FND_API.G_RET_STS_SUCCESS;

689: l_number_of_periods NUMBER;
690:
691: BEGIN
692:
693: x_return_status := FND_API.G_RET_STS_SUCCESS;
694:
695:
696:
697:

Line 7696: x_return_status := FND_API.G_RET_STS_ERROR;

7692: else
7693:
7694: PA_UTILS.Add_message ( p_app_short_name => 'PA',
7695: p_msg_name => l_err_msg_code);
7696: x_return_status := FND_API.G_RET_STS_ERROR;
7697:
7698:
7699: end if;
7700: