DBA Data[Home] [Help]

APPS.PA_FP_CONTROL_ITEMS_IMPACT_PKG dependencies on FND_API

Line 80: x_return_status := FND_API.G_RET_STS_SUCCESS;

76: l_cost_ci_plan_version_id pa_budget_versions.budget_version_id%TYPE;
77: l_rev_ci_plan_version_id pa_budget_versions.budget_version_id%TYPE;
78: BEGIN
79: FND_MSG_PUB.initialize;
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81: l_agreement_id := p_agreement_id;
82: IF p_pa_debug_mode = 'Y' THEN
83: PA_DEBUG.init_err_stack('p_button_pressed_from_page '||p_button_pressed_from_page);
84: END IF;

Line 149: x_return_status := FND_API.G_RET_STS_ERROR;

145: ,x_msg => 'no of approved plan types is zero'
146: ,x_log_level => 5);
147: END IF;
148:
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: IF p_button_pressed_from_page = 'COST_EDIT' THEN
151: l_message_name := 'PA_FP_CI_NO_APP_COST_PLAN';
152: END IF;
153: IF p_button_pressed_from_page = 'REVENUE_EDIT' THEN

Line 165: p_encoded => FND_API.G_TRUE,

161: p_msg_name => l_message_name );
162: x_msg_count := fnd_msg_pub.count_msg;
163: IF x_msg_count = 1 THEN
164: PA_INTERFACE_UTILS_PUB.Get_Messages (
165: p_encoded => FND_API.G_TRUE,
166: p_msg_index => 1,
167: p_msg_count => 1 ,
168: p_msg_data => l_msg_data ,
169: p_data => x_msg_data,

Line 273: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

269: x_return_status => x_return_status,
270: x_msg_count => x_msg_count,
271: x_msg_data =>x_msg_data
272: );
273: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
274: x_msg_count := fnd_msg_pub.count_msg;
275: IF x_msg_count = 1 THEN
276: PA_INTERFACE_UTILS_PUB.Get_Messages (
277: p_encoded => FND_API.G_TRUE,

Line 277: p_encoded => FND_API.G_TRUE,

273: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
274: x_msg_count := fnd_msg_pub.count_msg;
275: IF x_msg_count = 1 THEN
276: PA_INTERFACE_UTILS_PUB.Get_Messages (
277: p_encoded => FND_API.G_TRUE,
278: p_msg_index => 1,
279: p_msg_count => 1 ,
280: p_msg_data => l_msg_data ,
281: p_data => x_msg_data,

Line 308: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

304: x_return_status => x_return_status,
305: x_msg_count => x_msg_count,
306: x_msg_data =>x_msg_data
307: );
308: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
309: x_msg_count := fnd_msg_pub.count_msg;
310: IF x_msg_count = 1 THEN
311: PA_INTERFACE_UTILS_PUB.Get_Messages (
312: p_encoded => FND_API.G_TRUE,

Line 312: p_encoded => FND_API.G_TRUE,

308: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
309: x_msg_count := fnd_msg_pub.count_msg;
310: IF x_msg_count = 1 THEN
311: PA_INTERFACE_UTILS_PUB.Get_Messages (
312: p_encoded => FND_API.G_TRUE,
313: p_msg_index => 1,
314: p_msg_count => 1 ,
315: p_msg_data => l_msg_data ,
316: p_data => x_msg_data,

Line 366: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

362: x_agreement_id => l_agreement_id,
363: x_msg_count => x_msg_count,
364: x_msg_data => x_msg_data,
365: x_return_status => x_return_status );
366: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
367: x_msg_count := fnd_msg_pub.count_msg;
368: IF x_msg_count = 1 THEN
369: PA_INTERFACE_UTILS_PUB.Get_Messages (
370: p_encoded => FND_API.G_TRUE,

Line 370: p_encoded => FND_API.G_TRUE,

366: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
367: x_msg_count := fnd_msg_pub.count_msg;
368: IF x_msg_count = 1 THEN
369: PA_INTERFACE_UTILS_PUB.Get_Messages (
370: p_encoded => FND_API.G_TRUE,
371: p_msg_index => 1,
372: p_msg_count => 1 ,
373: p_msg_data => l_msg_data ,
374: p_data => x_msg_data,

Line 408: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

404: p_baseline_funding_flag => l_baseline_funding_flag);
405:
406: x_plan_version_id := ltrim(rtrim(l_bv_id));
407:
408: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
409: x_msg_count := fnd_msg_pub.count_msg;
410: IF x_msg_count = 1 THEN
411: PA_INTERFACE_UTILS_PUB.Get_Messages (
412: p_encoded => FND_API.G_TRUE,

Line 412: p_encoded => FND_API.G_TRUE,

408: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
409: x_msg_count := fnd_msg_pub.count_msg;
410: IF x_msg_count = 1 THEN
411: PA_INTERFACE_UTILS_PUB.Get_Messages (
412: p_encoded => FND_API.G_TRUE,
413: p_msg_index => 1,
414: p_msg_count => 1 ,
415: p_msg_data => l_msg_data ,
416: p_data => x_msg_data,

Line 474: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

470:
471: x_plan_version_id := ltrim(rtrim(l_bv_id));
472: --Bug 7497389
473: l_cost_ci_plan_version_id:=x_plan_version_id;
474: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
475: x_msg_count := fnd_msg_pub.count_msg;
476: IF x_msg_count = 1 THEN
477: PA_INTERFACE_UTILS_PUB.Get_Messages (
478: p_encoded => FND_API.G_TRUE,

Line 478: p_encoded => FND_API.G_TRUE,

474: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
475: x_msg_count := fnd_msg_pub.count_msg;
476: IF x_msg_count = 1 THEN
477: PA_INTERFACE_UTILS_PUB.Get_Messages (
478: p_encoded => FND_API.G_TRUE,
479: p_msg_index => 1,
480: p_msg_count => 1 ,
481: p_msg_data => l_msg_data ,
482: p_data => x_msg_data,

Line 526: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

522: x_agreement_id => l_agreement_id,
523: x_msg_count => x_msg_count,
524: x_msg_data => x_msg_data,
525: x_return_status => x_return_status );
526: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
527: x_msg_count := fnd_msg_pub.count_msg;
528: IF x_msg_count = 1 THEN
529: PA_INTERFACE_UTILS_PUB.Get_Messages (
530: p_encoded => FND_API.G_TRUE,

Line 530: p_encoded => FND_API.G_TRUE,

526: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
527: x_msg_count := fnd_msg_pub.count_msg;
528: IF x_msg_count = 1 THEN
529: PA_INTERFACE_UTILS_PUB.Get_Messages (
530: p_encoded => FND_API.G_TRUE,
531: p_msg_index => 1,
532: p_msg_count => 1 ,
533: p_msg_data => l_msg_data ,
534: p_data => x_msg_data,

Line 568: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

564:
565: x_plan_version_id := ltrim(rtrim(l_bv_id));
566: --Bug 7497389
567: l_rev_ci_plan_version_id:=x_plan_version_id;
568: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
569: x_msg_count := fnd_msg_pub.count_msg;
570: IF x_msg_count = 1 THEN
571: PA_INTERFACE_UTILS_PUB.Get_Messages (
572: p_encoded => FND_API.G_TRUE,

Line 572: p_encoded => FND_API.G_TRUE,

568: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
569: x_msg_count := fnd_msg_pub.count_msg;
570: IF x_msg_count = 1 THEN
571: PA_INTERFACE_UTILS_PUB.Get_Messages (
572: p_encoded => FND_API.G_TRUE,
573: p_msg_index => 1,
574: p_msg_count => 1 ,
575: p_msg_data => l_msg_data ,
576: p_data => x_msg_data,

Line 609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

605:
606: EXCEPTION
607: WHEN OTHERS THEN
608:
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
610: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_CONTROL_ITEMS_IMPACT_PKG',
611: p_procedure_name => 'MAINTAIN_CTRL_ITEM_VERSION',
612: p_error_text => SUBSTRB(SQLERRM,1,240));
613:

Line 664: x_return_status := FND_API.G_RET_STS_SUCCESS;

660: l_approved_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;
661: l_approved_cost_plan_type_flag pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;
662:
663: BEGIN
664: x_return_status := FND_API.G_RET_STS_SUCCESS;
665:
666: IF p_pa_debug_mode = 'Y' THEN
667: pa_debug.g_err_stage:= 'Entering Maintain_Plan_Version';
668: pa_debug.write('Maintain_Plan_Version',pa_debUg.g_err_stage,3);

Line 728: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

724: ,x_return_status => x_return_status
725: ,x_msg_count => x_msg_count
726: ,x_msg_data => x_msg_data );
727:
728: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
729: RETURN;
730: END IF;
731:
732: /* the version name and description is not shown in the pages

Line 754: x_return_status := FND_API.G_RET_STS_ERROR;

750: x_err_stage => l_err_stage,
751: x_err_stack => l_err_stack );
752:
753: IF (l_err_code <> 0) THEN
754: x_return_status := FND_API.G_RET_STS_ERROR;
755: RETURN;
756: END IF;
757:
758: PA_FP_AUTO_BASELINE_PKG.CREATE_BASELINED_VERSION(

Line 778: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

774: ,x_return_status => x_return_status
775: ,x_msg_count => x_msg_count
776: ,x_msg_data => x_msg_data
777: );
778: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
779: RETURN;
780: END IF;
781:
782: l_bv_id := l_plan_version_id;

Line 794: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

790: ,x_return_status => x_return_status
791: ,x_msg_count => x_msg_count
792: ,x_msg_data => x_msg_data );
793:
794: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
795: RETURN;
796: END IF;
797:
798:

Line 820: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

816: ,p_impacted_task_id => p_impacted_task_id
817: ,p_agreement_id => l_agreement_id);
818:
819: l_bv_id := l_plan_version_id;
820: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
821: RETURN;
822: END IF;
823: END IF;
824: END;

Line 860: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

856: ,p_entire_version => 'N'
857: ,x_return_status => x_return_status
858: ,x_msg_count => x_msg_count
859: ,x_msg_data => x_msg_data );
860: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
861: RETURN;
862: END IF;
863: SELECT PROJFUNC_RAW_COST,
864: PROJFUNC_BURDENED_COST,

Line 896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

892: x_plan_version_id := l_bv_id ;
893: EXCEPTION
894: WHEN OTHERS THEN
895:
896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
897: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_CONTROL_ITEMS_IMPACT_PKG',
898: p_procedure_name => 'Maintain_Plan_Version',
899: p_error_text => SUBSTRB(SQLERRM,1,240));
900:

Line 933: x_return_status := FND_API.G_RET_STS_SUCCESS;

929: ,x_msg => 'inside del API call'
930: ,x_log_level => 5);
931: END IF;
932:
933: x_return_status := FND_API.G_RET_STS_SUCCESS;
934:
935: IF p_init_msg_list = 'Y' THEN
936: FND_MSG_PUB.initialize;
937: END IF;

Line 971: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

967: x_return_status => x_return_status,
968: x_msg_count => x_msg_count,
969: x_msg_data => x_msg_data );
970:
971: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
972: ROLLBACK;
973: x_msg_count := fnd_msg_pub.count_msg;
974: IF x_msg_count = 1 THEN
975: PA_INTERFACE_UTILS_PUB.Get_Messages (

Line 976: p_encoded => FND_API.G_TRUE,

972: ROLLBACK;
973: x_msg_count := fnd_msg_pub.count_msg;
974: IF x_msg_count = 1 THEN
975: PA_INTERFACE_UTILS_PUB.Get_Messages (
976: p_encoded => FND_API.G_TRUE,
977: p_msg_index => 1,
978: p_msg_count => 1 ,
979: p_msg_data => l_msg_data ,
980: p_data => x_msg_data,

Line 1011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1007: IF p_pa_debug_mode = 'Y' THEN
1008: PA_DEBUG.Reset_Err_stack;
1009: END IF;
1010:
1011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1012: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_CONTROL_ITEMS_IMPACT_PKG',
1013: p_procedure_name => 'DELETE_CI_PLAN_VERSIONS',
1014: p_error_text => SUBSTRB(SQLERRM,1,240));
1015: