DBA Data[Home] [Help]

APPS.PA_FP_SHORTCUTS_PKG dependencies on FND_API

Line 52: x_return_status := FND_API.G_RET_STS_SUCCESS;

48:
49:
50: BEGIN
51: FND_MSG_PUB.initialize;
52: x_return_status := FND_API.G_RET_STS_SUCCESS;
53:
54: IF P_PA_DEBUG_MODE = 'Y' THEN
55: pa_debug.init_err_stack('PA_FP_SHORTCUTS_PKG.identify_plan_version_id');
56: pa_debug.write( x_module => l_module,

Line 118: x_return_status := FND_API.G_RET_STS_ERROR;

114: FROM
115: Pa_Projects_All WHERE Project_Id = p_project_id;
116: EXCEPTION
117: WHEN NO_DATA_FOUND THEN
118: x_return_status := FND_API.G_RET_STS_ERROR;
119: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
120: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
121: IF fnd_msg_pub.count_msg = 1 THEN
122: PA_INTERFACE_UTILS_PUB.Get_Messages (

Line 123: p_encoded => FND_API.G_TRUE,

119: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
120: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
121: IF fnd_msg_pub.count_msg = 1 THEN
122: PA_INTERFACE_UTILS_PUB.Get_Messages (
123: p_encoded => FND_API.G_TRUE,
124: p_msg_index => 1,
125: p_msg_count => 1 ,
126: p_msg_data => l_msg_data ,
127: p_data => l_data,

Line 234: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

230: x_redirect_url => x_redirect_url,
231: x_return_status => x_return_status,
232: x_msg_count => x_msg_count,
233: x_msg_data => x_msg_data );
234: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
235: IF p_pa_debug_mode = 'Y' THEN
236: PA_DEBUG.Reset_Err_stack;
237: END IF;
238: RETURN;

Line 251: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

247: x_redirect_url => x_redirect_url,
248: x_return_status => x_return_status,
249: x_msg_count => x_msg_count,
250: x_msg_data => x_msg_data );
251: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
252: IF p_pa_debug_mode = 'Y' THEN
253: PA_DEBUG.Reset_Err_stack;
254: END IF;
255: RETURN;

Line 289: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

285: x_redirect_url => x_redirect_url,
286: x_return_status => x_return_status,
287: x_msg_count => x_msg_count,
288: x_msg_data => x_msg_data );
289: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
290: IF p_pa_debug_mode = 'Y' THEN
291: PA_DEBUG.Reset_Err_stack;
292: END IF;
293: RETURN;

Line 306: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

302: x_redirect_url => x_redirect_url,
303: x_return_status => x_return_status,
304: x_msg_count => x_msg_count,
305: x_msg_data => x_msg_data );
306: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
307: IF p_pa_debug_mode = 'Y' THEN
308: PA_DEBUG.Reset_Err_stack;
309: END IF;
310: RETURN;

Line 351: x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

347: x_msg_count => x_msg_count,
348: x_msg_data => x_msg_data );
349: px_fin_plan_type_id := l_fin_plan_type_id;
350: IF x_redirect_url IS NOT NULL OR
351: x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
352: IF p_pa_debug_mode = 'Y' THEN
353: PA_DEBUG.Reset_Err_stack;
354: END IF;
355: RETURN;

Line 375: x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

371: x_msg_count => x_msg_count,
372: x_msg_data => x_msg_data );
373: px_fin_plan_type_id := l_fin_plan_type_id;
374: IF x_redirect_url IS NOT NULL OR
375: x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
376: IF p_pa_debug_mode = 'Y' THEN
377: PA_DEBUG.Reset_Err_stack;
378: END IF;
379: RETURN;

Line 467: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

463: x_msg_data => x_msg_data );
464:
465: l_bdgt_version_id := x_budget_version_id; /*Added for bug 4089561. If its a 'COST_AND_REV_SAME' case then
466: paRevContextVersionId should also be set equal to x_budget_version_id derived above.*/
467: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
468: IF p_pa_debug_mode = 'Y' THEN
469: PA_DEBUG.Reset_Err_stack;
470: END IF;
471: RETURN;

Line 486: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

482: x_msg_data => x_msg_data );
483:
484: l_bdgt_version_id := -99; /*Added for bug 4089561. If its not 'COST_AND_REV_SAME' case then
485: paRevContextVersionId should be set equal to -99*/
486: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
487: IF p_pa_debug_mode = 'Y' THEN
488: PA_DEBUG.Reset_Err_stack;
489: END IF;
490: RETURN;

Line 535: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

531: x_return_status => x_return_status,
532: x_msg_count => x_msg_count,
533: x_msg_data => x_msg_data );
534:
535: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
536: IF p_pa_debug_mode = 'Y' THEN
537: PA_DEBUG.Reset_Err_stack;
538: END IF;
539: RETURN;

Line 606: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

602: x_msg_count => x_msg_count,
603: x_msg_data => x_msg_data );
604:
605:
606: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
607: IF p_pa_debug_mode = 'Y' THEN
608: PA_DEBUG.Reset_Err_stack;
609: END IF;
610: RETURN;

Line 626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

622: IF p_pa_debug_mode = 'Y' THEN
623: PA_DEBUG.Reset_Err_stack;
624: END IF;
625:
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_SHORTCUTS_PKG',
628: p_procedure_name => 'IDENTIFY_PLAN_VERSION_ID',
629: p_error_text => SUBSTRB(SQLERRM,1,240));
630:

Line 691: x_return_status := FND_API.G_RET_STS_SUCCESS;

687:
688: approved_revenue_rec approved_revenue_csr%ROWTYPE;
689:
690: BEGIN
691: x_return_status := FND_API.G_RET_STS_SUCCESS;
692: IF P_PA_DEBUG_MODE = 'Y' THEN
693: pa_debug.init_err_stack('PA_FP_SHORTCUTS_PKG.get_app_budget_pt_id');
694: pa_debug.write( x_module => l_module,
695: x_msg => 'checking for approved budget',

Line 786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

782: IF p_pa_debug_mode = 'Y' THEN
783: PA_DEBUG.Reset_Err_stack;
784: END IF;
785:
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_SHORTCUTS_PKG',
788: p_procedure_name => 'GET_APP_BUDGET_PT_ID',
789: p_error_text => SUBSTRB(SQLERRM,1,240));
790:

Line 850: x_return_status := FND_API.G_RET_STS_SUCCESS;

846:
847: primary_revenue_rec primary_revenue_csr%ROWTYPE;
848:
849: BEGIN
850: x_return_status := FND_API.G_RET_STS_SUCCESS;
851: IF P_PA_DEBUG_MODE = 'Y' THEN
852: pa_debug.init_err_stack('PA_FP_SHORTCUTS_PKG.get_fcst_plan_type_id');
853: pa_debug.write( x_module => l_module,
854: x_msg => 'checking for primary forecast plan type',

Line 943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

939: IF p_pa_debug_mode = 'Y' THEN
940: PA_DEBUG.Reset_Err_stack;
941: END IF;
942:
943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
944: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_SHORTCUTS_PKG',
945: p_procedure_name => 'GET_FCST_PLAN_TYPE_ID',
946: p_error_text => SUBSTRB(SQLERRM,1,240));
947:

Line 986: x_return_status := FND_API.G_RET_STS_SUCCESS;

982: l_fp_opt_id pa_proj_fp_options.proj_fp_options_id%type;
983: /* l_process_wbs_flag pa_budget_versions.process_update_wbs_flag%TYPE; * 3604167 */
984: l_editable_flag VARCHAR2(1) := 'Y';
985: BEGIN
986: x_return_status := FND_API.G_RET_STS_SUCCESS;
987: l_webadi_enabled_flag := nvl(FND_PROFILE.value('PA_FP_WEBADI_ENABLE'), 'N');
988:
989: SAVEPOINT lock_cw_version_PH;
990:

Line 1097: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1093: X_return_status => x_return_status,
1094: X_msg_count => x_msg_count,
1095: X_msg_data => x_msg_data);
1096:
1097: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1098: IF p_pa_debug_mode = 'Y' THEN
1099: PA_DEBUG.Reset_Err_stack;
1100: END IF;
1101: RETURN;

Line 1181: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1177: x_return_status => x_return_status,
1178: x_msg_count => x_msg_count,
1179: x_msg_data => x_msg_data);
1180:
1181: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1182: IF p_pa_debug_mode = 'Y' THEN
1183: PA_DEBUG.Reset_Err_stack;
1184: END IF;
1185: RETURN;

Line 1254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1250: IF p_pa_debug_mode = 'Y' THEN
1251: PA_DEBUG.Reset_Err_stack;
1252: END IF;
1253:
1254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1255: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_SHORTCUTS_PKG',
1256: p_procedure_name => 'GET_CW_VERSION',
1257: p_error_text => SUBSTRB(SQLERRM,1,240));
1258: