DBA Data[Home] [Help]

APPS.PA_PROJECT_STUS_UTILS dependencies on FND_API

Line 828: x_return_status := FND_API.G_RET_STS_SUCCESS;

824: WHERE project_status_name = p_status_name
825: AND status_type = p_status_type
826: AND trunc(sysdate) between trunc(start_date_active) and trunc(nvl(end_date_active,sysdate));
827: END IF;
828: x_return_status := FND_API.G_RET_STS_SUCCESS;
829:
830: EXCEPTION
831: WHEN NO_DATA_FOUND THEN
832: x_return_status := FND_API.G_RET_STS_ERROR;

Line 832: x_return_status := FND_API.G_RET_STS_ERROR;

828: x_return_status := FND_API.G_RET_STS_SUCCESS;
829:
830: EXCEPTION
831: WHEN NO_DATA_FOUND THEN
832: x_return_status := FND_API.G_RET_STS_ERROR;
833: x_error_message_code := 'PA_STATUS_INVALID_AMBIGUOUS';
834: WHEN TOO_MANY_ROWS THEN
835: x_return_status := FND_API.G_RET_STS_ERROR;
836: x_error_message_code := 'PA_STATUS_INVALID_AMBIGUOUS';

Line 835: x_return_status := FND_API.G_RET_STS_ERROR;

831: WHEN NO_DATA_FOUND THEN
832: x_return_status := FND_API.G_RET_STS_ERROR;
833: x_error_message_code := 'PA_STATUS_INVALID_AMBIGUOUS';
834: WHEN TOO_MANY_ROWS THEN
835: x_return_status := FND_API.G_RET_STS_ERROR;
836: x_error_message_code := 'PA_STATUS_INVALID_AMBIGUOUS';
837: WHEN OTHERS THEN
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
839: x_error_message_code := SQLERRM; -- 4537865

Line 838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

834: WHEN TOO_MANY_ROWS THEN
835: x_return_status := FND_API.G_RET_STS_ERROR;
836: x_error_message_code := 'PA_STATUS_INVALID_AMBIGUOUS';
837: WHEN OTHERS THEN
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
839: x_error_message_code := SQLERRM; -- 4537865
840: x_status_code := NULL ; -- 4537865
841: RAISE;
842: END Check_Status_Name_or_Code;

Line 864: x_return_status := FND_API.G_RET_STS_SUCCESS;

860: FROM pa_project_statuses
861: WHERE project_status_code = p_status_code
862: AND status_type = p_status_type;
863:
864: x_return_status := FND_API.G_RET_STS_SUCCESS;
865:
866: EXCEPTION
867: WHEN NO_DATA_FOUND THEN
868: x_return_status := FND_API.G_RET_STS_ERROR;

Line 868: x_return_status := FND_API.G_RET_STS_ERROR;

864: x_return_status := FND_API.G_RET_STS_SUCCESS;
865:
866: EXCEPTION
867: WHEN NO_DATA_FOUND THEN
868: x_return_status := FND_API.G_RET_STS_ERROR;
869: x_error_message_code := 'PA_STATUS_INVALID_AMBIGUOUS';
870: -- 4537865
871: x_wf_success_status_code := NULL ;
872: x_wf_failure_status_code := NULL ;

Line 874: x_return_status := FND_API.G_RET_STS_ERROR;

870: -- 4537865
871: x_wf_success_status_code := NULL ;
872: x_wf_failure_status_code := NULL ;
873: WHEN TOO_MANY_ROWS THEN
874: x_return_status := FND_API.G_RET_STS_ERROR;
875: x_error_message_code := 'PA_STATUS_INVALID_AMBIGUOUS';
876: -- 4537865
877: x_wf_success_status_code := NULL ;
878: x_wf_failure_status_code := NULL ;

Line 880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

876: -- 4537865
877: x_wf_success_status_code := NULL ;
878: x_wf_failure_status_code := NULL ;
879: WHEN OTHERS THEN
880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
881: -- 4537865
882: x_wf_success_status_code := NULL ;
883: x_wf_failure_status_code := NULL ;
884: x_error_message_code := SQLERRM;