APPS.PA_PROJECT_UTILS dependencies on FND_API

Line 1133: FND_API.G_RET_STS_SUCCESS) THEN

1129: -- Check if contract is associated to the project
1130: IF ( pa_install.is_product_installed('OKE')) THEN
1131: x_err_stage := 'Check contract association for project '||x_project_id;
1132: IF (PA_PROJ_STRUCTURE_PUB.CHECK_SUBPROJ_CONTRACT_ASSO(x_project_id) <>
1133: FND_API.G_RET_STS_SUCCESS) THEN
1134: x_err_code := 170;
1135: x_err_stage := 'PA_STRUCT_PJ_HAS_CONTRACT';
1136: return;
1137: END IF;

Line 1193: p_init_msg_list => FND_API.G_TRUE,

1189: -- Check to see if the project has been used in Sourcing i.e PON
1190:
1191: PON_PROJECTS_INTEGRATION_GRP.CHECK_DELETE_PROJECT_OK(
1192: p_api_version => 1.0,
1193: p_init_msg_list => FND_API.G_TRUE,
1194: p_project_id => x_project_id,
1195: x_return_status => l_return_status,
1196: x_msg_count => l_msg_count,
1197: x_msg_data => l_msg_data );

Line 1205: IF NVL(l_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN

1201: -- message as well.
1202: -- The message is also set in the message stack. All we need to do is return from here as we are doing
1203: -- for other earlier checks.
1204:
1205: IF NVL(l_return_status , FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
1206: x_err_code := 300;
1207: x_err_stage := l_msg_data; -- 'PON_PROJECT_USED_NO_DELETE';
1208: return;
1209: END IF;

Line 1978: x_return_status := FND_API.G_RET_STS_SUCCESS;

1974: )
1975: IS
1976: l_return_value VARCHAR2(1) := 'N';
1977: BEGIN
1978: x_return_status := FND_API.G_RET_STS_SUCCESS;
1979: IF NVL( PA_CONTROL_ITEMS_UTILS.check_project_type_in_use(
1980: p_project_type_id => p_project_type_id ), 0 ) <> 0
1981: THEN
1982: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1982: x_return_status := FND_API.G_RET_STS_ERROR;

1978: x_return_status := FND_API.G_RET_STS_SUCCESS;
1979: IF NVL( PA_CONTROL_ITEMS_UTILS.check_project_type_in_use(
1980: p_project_type_id => p_project_type_id ), 0 ) <> 0
1981: THEN
1982: x_return_status := FND_API.G_RET_STS_ERROR;
1983: x_error_message_code :='PA_CI_PROJ_TYPE_IN_USE';
1984: END IF;
1985:
1986: -- 4537865

Line 1990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1986: -- 4537865
1987: EXCEPTION
1988: WHEN OTHERS THEN
1989: x_error_message_code := SQLERRM ;
1990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1991: RAISE;
1992: end check_delete_project_type_ok;
1993:
1994: /*Start: Addition of code for bug 2682806 */

Line 2016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2012: -- 4537865
2013: EXCEPTION
2014: WHEN OTHERS THEN
2015: x_error_message_code := SQLERRM ;
2016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2017: RAISE;
2018: end check_delete_class_catg_ok;
2019:
2020: Procedure check_delete_class_code_ok (

Line 2041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2037: -- 4537865
2038: EXCEPTION
2039: WHEN OTHERS THEN
2040: x_error_message_code := SQLERRM ;
2041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2042: RAISE;
2043: end check_delete_class_code_ok;
2044:
2045:

Line 2386: x_return_status := FND_API.G_RET_STS_ERROR ;

2382: p_value1 => l_segment_name,
2383: p_token2 => 'FLEXFIELD',
2384: p_value2 => p_flexfield_name);
2385: -- x_msg_data := 'FLEX-MISSING SEGMENT VALUE';
2386: x_return_status := FND_API.G_RET_STS_ERROR ;
2387: END IF;
2388:
2389: x_return_status := FND_API.G_RET_STS_SUCCESS;
2390:

Line 2389: x_return_status := FND_API.G_RET_STS_SUCCESS;

2385: -- x_msg_data := 'FLEX-MISSING SEGMENT VALUE';
2386: x_return_status := FND_API.G_RET_STS_ERROR ;
2387: END IF;
2388:
2389: x_return_status := FND_API.G_RET_STS_SUCCESS;
2390:
2391: EXCEPTION
2392: WHEN OTHERS THEN
2393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2389: x_return_status := FND_API.G_RET_STS_SUCCESS;
2390:
2391: EXCEPTION
2392: WHEN OTHERS THEN
2393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2394: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_UTILS',
2395: p_procedure_name => 'VALIDATE_DFF',
2396: p_error_text => SUBSTRB(SQLERRM,1,240));
2397: raise;