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 1966: x_return_status := FND_API.G_RET_STS_SUCCESS;

1962: )
1963: IS
1964: l_return_value VARCHAR2(1) := 'N';
1965: BEGIN
1966: x_return_status := FND_API.G_RET_STS_SUCCESS;
1967: IF NVL( PA_CONTROL_ITEMS_UTILS.check_project_type_in_use(
1968: p_project_type_id => p_project_type_id ), 0 ) <> 0
1969: THEN
1970: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1970: x_return_status := FND_API.G_RET_STS_ERROR;

1966: x_return_status := FND_API.G_RET_STS_SUCCESS;
1967: IF NVL( PA_CONTROL_ITEMS_UTILS.check_project_type_in_use(
1968: p_project_type_id => p_project_type_id ), 0 ) <> 0
1969: THEN
1970: x_return_status := FND_API.G_RET_STS_ERROR;
1971: x_error_message_code :='PA_CI_PROJ_TYPE_IN_USE';
1972: END IF;
1973:
1974: -- 4537865

Line 1978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1974: -- 4537865
1975: EXCEPTION
1976: WHEN OTHERS THEN
1977: x_error_message_code := SQLERRM ;
1978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1979: RAISE;
1980: end check_delete_project_type_ok;
1981:
1982: /*Start: Addition of code for bug 2682806 */

Line 2004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2000: -- 4537865
2001: EXCEPTION
2002: WHEN OTHERS THEN
2003: x_error_message_code := SQLERRM ;
2004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2005: RAISE;
2006: end check_delete_class_catg_ok;
2007:
2008: Procedure check_delete_class_code_ok (

Line 2029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2025: -- 4537865
2026: EXCEPTION
2027: WHEN OTHERS THEN
2028: x_error_message_code := SQLERRM ;
2029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2030: RAISE;
2031: end check_delete_class_code_ok;
2032:
2033:

Line 2374: x_return_status := FND_API.G_RET_STS_ERROR ;

2370: p_value1 => l_segment_name,
2371: p_token2 => 'FLEXFIELD',
2372: p_value2 => p_flexfield_name);
2373: -- x_msg_data := 'FLEX-MISSING SEGMENT VALUE';
2374: x_return_status := FND_API.G_RET_STS_ERROR ;
2375: END IF;
2376:
2377: x_return_status := FND_API.G_RET_STS_SUCCESS;
2378:

Line 2377: x_return_status := FND_API.G_RET_STS_SUCCESS;

2373: -- x_msg_data := 'FLEX-MISSING SEGMENT VALUE';
2374: x_return_status := FND_API.G_RET_STS_ERROR ;
2375: END IF;
2376:
2377: x_return_status := FND_API.G_RET_STS_SUCCESS;
2378:
2379: EXCEPTION
2380: WHEN OTHERS THEN
2381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2377: x_return_status := FND_API.G_RET_STS_SUCCESS;
2378:
2379: EXCEPTION
2380: WHEN OTHERS THEN
2381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2382: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_UTILS',
2383: p_procedure_name => 'VALIDATE_DFF',
2384: p_error_text => SUBSTRB(SQLERRM,1,240));
2385: raise;