DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_CREATE_VER_GLOBAL dependencies on FND_API

Line 171: x_return_status := FND_API.G_RET_STS_SUCCESS;

167: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
168: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
169: is
170: BEGIN
171: x_return_status := FND_API.G_RET_STS_SUCCESS;
172: G_PROJECT_ID := p_project_id;
173:
174: EXCEPTION
175: WHEN OTHERS THEN

Line 176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

172: G_PROJECT_ID := p_project_id;
173:
174: EXCEPTION
175: WHEN OTHERS THEN
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
177: x_msg_count := 1;
178: x_msg_data := SQLERRM;
179: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_CREATE_VER_GLOBAL',
180: p_procedure_name => 'set_project_id');

Line 190: x_return_status := FND_API.G_RET_STS_SUCCESS;

186: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
187: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
188: is
189: BEGIN
190: x_return_status := FND_API.G_RET_STS_SUCCESS;
191: G_FIN_PLAN_TYPE_ID := p_fin_plan_type_id;
192:
193: EXCEPTION
194: WHEN OTHERS THEN

Line 195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

191: G_FIN_PLAN_TYPE_ID := p_fin_plan_type_id;
192:
193: EXCEPTION
194: WHEN OTHERS THEN
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: x_msg_count := 1;
197: x_msg_data := SQLERRM;
198: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_CREATE_VER_GLOBAL',
199: p_procedure_name => 'set_fin_plan_type_id');

Line 209: x_return_status := FND_API.G_RET_STS_SUCCESS;

205: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
206: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
207: is
208: BEGIN
209: x_return_status := FND_API.G_RET_STS_SUCCESS;
210: G_BUDGET_VERSION_ID := p_budget_version_id;
211:
212: EXCEPTION
213: WHEN OTHERS THEN

Line 214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

210: G_BUDGET_VERSION_ID := p_budget_version_id;
211:
212: EXCEPTION
213: WHEN OTHERS THEN
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
215: x_msg_count := 1;
216: x_msg_data := SQLERRM;
217: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_CREATE_VER_GLOBAL',
218: p_procedure_name => 'set_budget_version_id');

Line 240: x_return_status := FND_API.G_RET_STS_SUCCESS;

236: BEGIN
237: IF P_PA_DEBUG_MODE = 'Y' THEN
238: pa_debug.init_err_stack('pa_fin_plan_create_ver_global.set_global_values');
239: END IF;
240: x_return_status := FND_API.G_RET_STS_SUCCESS;
241: G_PROJECT_ID := p_project_id;
242: G_FIN_PLAN_TYPE_ID := p_fin_plan_type_id;
243: G_BUDGET_VERSION_ID := p_budget_version_id;
244:

Line 260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

256: end if;
257: pa_debug.reset_err_stack;
258: EXCEPTION
259: WHEN OTHERS THEN
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261: x_msg_count := 1;
262: x_msg_data := SQLERRM;
263: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_CREATE_VER_GLOBAL',
264: p_procedure_name => 'set_global_values');

Line 304: if l_return_status=FND_API.G_RET_STS_SUCCESS then

300: x_fcst_end_date => l_fcst_end_date,
301: x_org_id => l_org_id,
302: x_return_status => l_return_status,
303: x_err_code => l_error_msg_code);
304: if l_return_status=FND_API.G_RET_STS_SUCCESS then
305: x_period_start_date := l_fcst_start_date;
306: x_period_end_date := l_fcst_end_date;
307: x_return_status := FND_API.G_RET_STS_SUCCESS;
308: end if;

Line 307: x_return_status := FND_API.G_RET_STS_SUCCESS;

303: x_err_code => l_error_msg_code);
304: if l_return_status=FND_API.G_RET_STS_SUCCESS then
305: x_period_start_date := l_fcst_start_date;
306: x_period_end_date := l_fcst_end_date;
307: x_return_status := FND_API.G_RET_STS_SUCCESS;
308: end if;
309: END get_start_end_period;
310:
311: /* ========================================================

Line 349: x_return_status := FND_API.G_RET_STS_SUCCESS;

345: IF P_PA_DEBUG_MODE = 'Y' THEN
346: pa_debug.init_err_stack('pa_fin_plan_create_ver_global.Create_Versions_Init');
347: END IF;
348: x_msg_count := 0;
349: x_return_status := FND_API.G_RET_STS_SUCCESS;
350:
351: select
352: nvl(pt.org_project_flag, 'N')
353: into

Line 404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

400: pa_debug.reset_err_stack;
401:
402: exception
403: when others then
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405: x_msg_count := 1;
406: x_msg_data := SQLERRM;
407: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fin_plan_create_ver_global',
408: p_procedure_name => 'Create_Versions_Init');