DBA Data[Home] [Help]

APPS.FPA_SECURITY_PVT dependencies on FND_API

Line 46: l_grant_exists := FND_API.G_FALSE;

42: l_grant_id FND_GRANTS.GRANT_GUID%TYPE := null;
43:
44: BEGIN
45:
46: l_grant_exists := FND_API.G_FALSE;
47:
48: l_instance_set_id := PA_SECURITY_PVT.Get_Instance_Set_Id(p_instance_set_name);
49: x_instance_set_id := l_instance_set_id;
50: l_menu_id := PA_SECURITY_PVT.get_menu_id_for_role(p_project_role_id);

Line 102: return FND_API.G_FALSE;

98: end if;
99: */
100: /*
101: if (not fnd_function.test(p_privilege)) then
102: return FND_API.G_FALSE;
103: end if;
104: */
105:
106:

Line 154: return FND_API.G_FALSE;

150: end if;
151: */
152: /*
153: if (not fnd_function.test(p_privilege)) then
154: return FND_API.G_FALSE;
155: end if;
156: */
157:
158:

Line 323: if(l_exists = FND_API.G_TRUE) then

319: x_instance_set_id => l_instance_set_id,
320: x_grant_id => l_grant_id,
321: x_ret_code => l_exists);
322:
323: if(l_exists = FND_API.G_TRUE) then
324:
325: FPA_UTILITIES_PVT.END_ACTIVITY(
326: p_api_name => l_api_name,
327: p_pkg_name => G_PKG_NAME,

Line 370: if l_success <> FND_API.G_TRUE then

366: x_success => l_success,
367: x_errorcode => l_error_code);
368:
369:
370: if l_success <> FND_API.G_TRUE then
371: if l_error_code > 0 then
372: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
373: else
374: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR;

Line 524: if(l_exists = FND_API.G_TRUE) then

520:
521: fetch parties_csr into l_exists;
522: close parties_csr;
523:
524: if(l_exists = FND_API.G_TRUE) then
525:
526: FPA_UTILITIES_PVT.END_ACTIVITY(
527: p_api_name => l_api_name,
528: p_pkg_name => G_PKG_NAME,

Line 553: if(l_exists = FND_API.G_FALSE) then

549: x_instance_set_id => l_instance_set_id,
550: x_grant_id => l_grant_id,
551: x_ret_code => l_exists);
552:
553: if(l_exists = FND_API.G_FALSE) then
554: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
555: l_user := Get_party_Name(p_party_id);
556: FPA_UTILITIES_PVT.SET_MESSAGE(
557: p_app_name => g_app_name

Line 573: if l_success <> FND_API.G_TRUE then

569: p_grant_guid => l_grant_id,
570: x_success => l_success,
571: x_errorcode => l_error_code);
572:
573: if l_success <> FND_API.G_TRUE then
574: -- x_revoked := FND_API.G_FALSE;
575: if l_error_code > 0 then
576: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
577: else

Line 574: -- x_revoked := FND_API.G_FALSE;

570: x_success => l_success,
571: x_errorcode => l_error_code);
572:
573: if l_success <> FND_API.G_TRUE then
574: -- x_revoked := FND_API.G_FALSE;
575: if l_error_code > 0 then
576: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
577: else
578: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR;

Line 591: --x_revoked := FND_API.G_TRUE;

587: l_msg_log := 'fpa_security_pvt.revoke_grant '||l_grant_id;
588: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
589: end if;
590:
591: --x_revoked := FND_API.G_TRUE;
592:
593: FPA_UTILITIES_PVT.END_ACTIVITY(
594: p_api_name => l_api_name,
595: p_pkg_name => G_PKG_NAME,

Line 637: l_flag varchar2(1) := FND_API.G_FALSE;

633:
634: FUNCTION check_user(p_person_id IN NUMBER,
635: p_portfolio_id IN NUMBER)
636: RETURN BOOLEAN IS
637: l_flag varchar2(1) := FND_API.G_FALSE;
638: cursor PORTFOLIO_USER_CSR(P_PERSON_ID IN VARCHAR2,
639: P_PORTFOLIO_ID IN NUMBER) is
640: SELECT 'T'
641: FROM PA_PROJECT_PARTIES

Line 650: if(l_flag = FND_API.G_TRUE) then

646: BEGIN
647: open PORTFOLIO_USER_CSR(p_person_id, p_portfolio_id);
648: fetch PORTFOLIO_USER_CSR into l_flag;
649: close PORTFOLIO_USER_CSR;
650: if(l_flag = FND_API.G_TRUE) then
651: return true;
652: else
653: return false;
654: end if;

Line 749: p_commit => FND_API.G_FALSE,

745: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
746: end if;
747:
748: PA_PROJECT_PARTIES_PVT.Create_Project_Party(
749: p_commit => FND_API.G_FALSE,
750: p_validate_only => FND_API.G_FALSE,
751: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
752: p_debug_Mode => 'N',
753: p_object_ID => p_object_id,

Line 750: p_validate_only => FND_API.G_FALSE,

746: end if;
747:
748: PA_PROJECT_PARTIES_PVT.Create_Project_Party(
749: p_commit => FND_API.G_FALSE,
750: p_validate_only => FND_API.G_FALSE,
751: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
752: p_debug_Mode => 'N',
753: p_object_ID => p_object_id,
754: p_object_Type => G_PORTFOLIO,

Line 751: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

747:
748: PA_PROJECT_PARTIES_PVT.Create_Project_Party(
749: p_commit => FND_API.G_FALSE,
750: p_validate_only => FND_API.G_FALSE,
751: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
752: p_debug_Mode => 'N',
753: p_object_ID => p_object_id,
754: p_object_Type => G_PORTFOLIO,
755: p_resource_Type_ID => 101,

Line 978: p_commit => FND_API.G_FALSE,

974: */
975:
976: /*
977: PA_PROJECT_PARTIES_PVT.UPDATE_PROJECT_PARTY(
978: p_commit => FND_API.G_FALSE,
979: p_validate_only => FND_API.G_FALSE,
980: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
981: p_debug_mode => 'N',
982: p_object_id => l_object_id,

Line 979: p_validate_only => FND_API.G_FALSE,

975:
976: /*
977: PA_PROJECT_PARTIES_PVT.UPDATE_PROJECT_PARTY(
978: p_commit => FND_API.G_FALSE,
979: p_validate_only => FND_API.G_FALSE,
980: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
981: p_debug_mode => 'N',
982: p_object_id => l_object_id,
983: p_object_type => l_object_type,

Line 980: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

976: /*
977: PA_PROJECT_PARTIES_PVT.UPDATE_PROJECT_PARTY(
978: p_commit => FND_API.G_FALSE,
979: p_validate_only => FND_API.G_FALSE,
980: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
981: p_debug_mode => 'N',
982: p_object_id => l_object_id,
983: p_object_type => l_object_type,
984: p_project_role_id => p_project_role_id,

Line 1017: FND_API.G_VALID_LEVEL_FULL,

1013: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1014: */
1015:
1016: pa_project_parties_utils.validate_project_party(
1017: FND_API.G_VALID_LEVEL_FULL,
1018: 'N',
1019: l_object_id,
1020: l_object_type,
1021: p_project_role_id,

Line 1240: p_commit => FND_API.G_FALSE,

1236:
1237: /*
1238:
1239: PA_PROJECT_PARTIES_PVT.UPDATE_PROJECT_PARTY(
1240: p_commit => FND_API.G_FALSE,
1241: p_validate_only => FND_API.G_FALSE,
1242: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1243: p_debug_mode => 'N',
1244: p_object_id => l_object_id,

Line 1241: p_validate_only => FND_API.G_FALSE,

1237: /*
1238:
1239: PA_PROJECT_PARTIES_PVT.UPDATE_PROJECT_PARTY(
1240: p_commit => FND_API.G_FALSE,
1241: p_validate_only => FND_API.G_FALSE,
1242: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1243: p_debug_mode => 'N',
1244: p_object_id => l_object_id,
1245: p_object_type => l_object_type,

Line 1242: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1238:
1239: PA_PROJECT_PARTIES_PVT.UPDATE_PROJECT_PARTY(
1240: p_commit => FND_API.G_FALSE,
1241: p_validate_only => FND_API.G_FALSE,
1242: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1243: p_debug_mode => 'N',
1244: p_object_id => l_object_id,
1245: p_object_type => l_object_type,
1246: p_project_role_id => p_project_role_id,

Line 1416: l_exists := FND_API.G_FALSE;

1412: l_api_version CONSTANT NUMBER := 1.0;
1413: l_msg_log VARCHAR2(2000) := null;
1414: ----------------------------------------------------------------------------
1415: BEGIN
1416: l_exists := FND_API.G_FALSE;
1417:
1418: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1419: -- call START_ACTIVITY to create savepoint, check compatibility
1420: -- and initialize message list

Line 1469: if(l_exists = FND_API.G_TRUE) then

1465: fetch verify_delete_csr into l_exists;
1466: close verify_delete_csr;
1467:
1468:
1469: if(l_exists = FND_API.G_TRUE) then
1470: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
1471: l_user := Get_party_Name(l_party_id);
1472: FPA_UTILITIES_PVT.SET_MESSAGE(
1473: p_app_name => g_app_name