DBA Data[Home] [Help]

APPS.PA_FP_CONTROL_ITEMS_IMPACT_PKG dependencies on FND_API

Line 77: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 146: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 162: p_encoded => FND_API.G_TRUE,

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

Line 269: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

265: x_return_status => x_return_status,
266: x_msg_count => x_msg_count,
267: x_msg_data =>x_msg_data
268: );
269: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
270: x_msg_count := fnd_msg_pub.count_msg;
271: IF x_msg_count = 1 THEN
272: PA_INTERFACE_UTILS_PUB.Get_Messages (
273: p_encoded => FND_API.G_TRUE,

Line 273: p_encoded => FND_API.G_TRUE,

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

Line 304: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

300: x_return_status => x_return_status,
301: x_msg_count => x_msg_count,
302: x_msg_data =>x_msg_data
303: );
304: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
305: x_msg_count := fnd_msg_pub.count_msg;
306: IF x_msg_count = 1 THEN
307: PA_INTERFACE_UTILS_PUB.Get_Messages (
308: p_encoded => FND_API.G_TRUE,

Line 308: p_encoded => FND_API.G_TRUE,

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

Line 362: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

358: x_agreement_id => l_agreement_id,
359: x_msg_count => x_msg_count,
360: x_msg_data => x_msg_data,
361: x_return_status => x_return_status );
362: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
363: x_msg_count := fnd_msg_pub.count_msg;
364: IF x_msg_count = 1 THEN
365: PA_INTERFACE_UTILS_PUB.Get_Messages (
366: p_encoded => FND_API.G_TRUE,

Line 366: p_encoded => FND_API.G_TRUE,

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

Line 404: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 408: p_encoded => FND_API.G_TRUE,

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

Line 461: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

457:
458: x_plan_version_id := ltrim(rtrim(l_bv_id));
459: --Bug 7497389
460: l_cost_ci_plan_version_id:=x_plan_version_id;
461: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
462: x_msg_count := fnd_msg_pub.count_msg;
463: IF x_msg_count = 1 THEN
464: PA_INTERFACE_UTILS_PUB.Get_Messages (
465: p_encoded => FND_API.G_TRUE,

Line 465: p_encoded => FND_API.G_TRUE,

461: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
462: x_msg_count := fnd_msg_pub.count_msg;
463: IF x_msg_count = 1 THEN
464: PA_INTERFACE_UTILS_PUB.Get_Messages (
465: p_encoded => FND_API.G_TRUE,
466: p_msg_index => 1,
467: p_msg_count => 1 ,
468: p_msg_data => l_msg_data ,
469: p_data => x_msg_data,

Line 501: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

497: x_agreement_id => l_agreement_id,
498: x_msg_count => x_msg_count,
499: x_msg_data => x_msg_data,
500: x_return_status => x_return_status );
501: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
502: x_msg_count := fnd_msg_pub.count_msg;
503: IF x_msg_count = 1 THEN
504: PA_INTERFACE_UTILS_PUB.Get_Messages (
505: p_encoded => FND_API.G_TRUE,

Line 505: p_encoded => FND_API.G_TRUE,

501: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
502: x_msg_count := fnd_msg_pub.count_msg;
503: IF x_msg_count = 1 THEN
504: PA_INTERFACE_UTILS_PUB.Get_Messages (
505: p_encoded => FND_API.G_TRUE,
506: p_msg_index => 1,
507: p_msg_count => 1 ,
508: p_msg_data => l_msg_data ,
509: p_data => x_msg_data,

Line 543: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

539:
540: x_plan_version_id := ltrim(rtrim(l_bv_id));
541: --Bug 7497389
542: l_rev_ci_plan_version_id:=x_plan_version_id;
543: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
544: x_msg_count := fnd_msg_pub.count_msg;
545: IF x_msg_count = 1 THEN
546: PA_INTERFACE_UTILS_PUB.Get_Messages (
547: p_encoded => FND_API.G_TRUE,

Line 547: p_encoded => FND_API.G_TRUE,

543: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
544: x_msg_count := fnd_msg_pub.count_msg;
545: IF x_msg_count = 1 THEN
546: PA_INTERFACE_UTILS_PUB.Get_Messages (
547: p_encoded => FND_API.G_TRUE,
548: p_msg_index => 1,
549: p_msg_count => 1 ,
550: p_msg_data => l_msg_data ,
551: p_data => x_msg_data,

Line 584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

580:
581: EXCEPTION
582: WHEN OTHERS THEN
583:
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
585: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_CONTROL_ITEMS_IMPACT_PKG',
586: p_procedure_name => 'MAINTAIN_CTRL_ITEM_VERSION',
587: p_error_text => SUBSTRB(SQLERRM,1,240));
588:

Line 634: x_return_status := FND_API.G_RET_STS_SUCCESS;

630: l_err_stage varchar2(1000) := null;
631: l_err_stack varchar2(1000) := null;
632: lx_cur_work_bv_id NUMBER;
633: BEGIN
634: x_return_status := FND_API.G_RET_STS_SUCCESS;
635:
636: IF p_pa_debug_mode = 'Y' THEN
637: pa_debug.g_err_stage:= 'Entering Maintain_Plan_Version';
638: pa_debug.write('Maintain_Plan_Version',pa_debUg.g_err_stage,3);

Line 681: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

677: ,x_return_status => x_return_status
678: ,x_msg_count => x_msg_count
679: ,x_msg_data => x_msg_data );
680:
681: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
682: RETURN;
683: END IF;
684:
685: /* the version name and description is not shown in the pages

Line 704: x_return_status := FND_API.G_RET_STS_ERROR;

700: x_err_stage => l_err_stage,
701: x_err_stack => l_err_stack );
702:
703: IF (l_err_code <> 0) THEN
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: RETURN;
706: END IF;
707:
708: PA_FP_AUTO_BASELINE_PKG.CREATE_BASELINED_VERSION(

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: l_bv_id := l_plan_version_id;

Line 744: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

740: ,x_return_status => x_return_status
741: ,x_msg_count => x_msg_count
742: ,x_msg_data => x_msg_data );
743:
744: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
745: RETURN;
746: END IF;
747:
748:

Line 770: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

766: ,p_impacted_task_id => p_impacted_task_id
767: ,p_agreement_id => l_agreement_id);
768:
769: l_bv_id := l_plan_version_id;
770: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
771: RETURN;
772: END IF;
773: END IF;
774: END;

Line 810: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

806: ,p_entire_version => 'N'
807: ,x_return_status => x_return_status
808: ,x_msg_count => x_msg_count
809: ,x_msg_data => x_msg_data );
810: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
811: RETURN;
812: END IF;
813: SELECT PROJFUNC_RAW_COST,
814: PROJFUNC_BURDENED_COST,

Line 846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

842: x_plan_version_id := l_bv_id ;
843: EXCEPTION
844: WHEN OTHERS THEN
845:
846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
847: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_CONTROL_ITEMS_IMPACT_PKG',
848: p_procedure_name => 'Maintain_Plan_Version',
849: p_error_text => SUBSTRB(SQLERRM,1,240));
850:

Line 883: x_return_status := FND_API.G_RET_STS_SUCCESS;

879: ,x_msg => 'inside del API call'
880: ,x_log_level => 5);
881: END IF;
882:
883: x_return_status := FND_API.G_RET_STS_SUCCESS;
884:
885: IF p_init_msg_list = 'Y' THEN
886: FND_MSG_PUB.initialize;
887: END IF;

Line 921: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

917: x_return_status => x_return_status,
918: x_msg_count => x_msg_count,
919: x_msg_data => x_msg_data );
920:
921: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
922: ROLLBACK;
923: x_msg_count := fnd_msg_pub.count_msg;
924: IF x_msg_count = 1 THEN
925: PA_INTERFACE_UTILS_PUB.Get_Messages (

Line 926: p_encoded => FND_API.G_TRUE,

922: ROLLBACK;
923: x_msg_count := fnd_msg_pub.count_msg;
924: IF x_msg_count = 1 THEN
925: PA_INTERFACE_UTILS_PUB.Get_Messages (
926: p_encoded => FND_API.G_TRUE,
927: p_msg_index => 1,
928: p_msg_count => 1 ,
929: p_msg_data => l_msg_data ,
930: p_data => x_msg_data,

Line 961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

957: IF p_pa_debug_mode = 'Y' THEN
958: PA_DEBUG.Reset_Err_stack;
959: END IF;
960:
961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
962: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_CONTROL_ITEMS_IMPACT_PKG',
963: p_procedure_name => 'DELETE_CI_PLAN_VERSIONS',
964: p_error_text => SUBSTRB(SQLERRM,1,240));
965: