eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FPA_SECURITY_PVT dependencies on PA_SECURITY_PVT

Line 1: package body FPA_SECURITY_PVT as

1: package body FPA_SECURITY_PVT as
2: /* $Header: FPAVSECB.pls 120.4 2005/08/18 11:50:33 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'FPA_SECURITY_PVT';
5: G_APP_NAME CONSTANT VARCHAR2(3) := FPA_UTILITIES_PVT.G_APP_NAME;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'FPA_SECURITY_PVT';

1: package body FPA_SECURITY_PVT as
2: /* $Header: FPAVSECB.pls 120.4 2005/08/18 11:50:33 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'FPA_SECURITY_PVT';
5: G_APP_NAME CONSTANT VARCHAR2(3) := FPA_UTILITIES_PVT.G_APP_NAME;
6: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
7: L_API_NAME CONSTANT VARCHAR2(35) := 'SECURITY_PVT';
8:

Line 48: l_instance_set_id := PA_SECURITY_PVT.Get_Instance_Set_Id(p_instance_set_name);

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);
51:
52: open grants_csr(l_menu_id,

Line 50: l_menu_id := PA_SECURITY_PVT.get_menu_id_for_role(p_project_role_id);

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);
51:
52: open grants_csr(l_menu_id,
53: p_instance_type,
54: l_instance_set_id,

Line 76: 'FPA_SECURITY_PVT.Get_Grant',

72: x_grant_id := null;
73: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
74: FND_LOG.String(
75: FND_LOG.LEVEL_PROCEDURE,
76: 'FPA_SECURITY_PVT.Get_Grant',
77: x_instance_set_id||','||x_ret_code||','||x_ret_code);
78: raise;
79: end if;
80: END Get_Grant;

Line 95: g_key := PA_SECURITY_PVT.Get_Grantee_Key('USER');

91:
92: BEGIN
93: /* Changes for ATG mandate for deprecated parameter
94: if(p_person_id is null) then
95: g_key := PA_SECURITY_PVT.Get_Grantee_Key('USER');
96: else
97: g_key := PA_SECURITY_PVT.Get_Grantee_Key('PERSON',p_person_id, 'Y');
98: end if;
99: */

Line 97: g_key := PA_SECURITY_PVT.Get_Grantee_Key('PERSON',p_person_id, 'Y');

93: /* Changes for ATG mandate for deprecated parameter
94: if(p_person_id is null) then
95: g_key := PA_SECURITY_PVT.Get_Grantee_Key('USER');
96: else
97: g_key := PA_SECURITY_PVT.Get_Grantee_Key('PERSON',p_person_id, 'Y');
98: end if;
99: */
100: /*
101: if (not fnd_function.test(p_privilege)) then

Line 128: 'FPA_SECURITY_PVT.Check_User_Previlege',

124: WHEN OTHERS THEN
125: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
126: FND_LOG.String(
127: FND_LOG.LEVEL_PROCEDURE,
128: 'FPA_SECURITY_PVT.Check_User_Previlege',
129: p_privilege||','||p_object_name||','||p_object_id);
130: end if;
131: return 'U';
132: END Check_User_Previlege;

Line 147: g_key := PA_SECURITY_PVT.Get_Grantee_Key('USER');

143:
144: BEGIN
145: /* Changes for ATG mandate for deprecated parameter
146: if(p_person_id is null) then
147: g_key := PA_SECURITY_PVT.Get_Grantee_Key('USER');
148: else
149: g_key := PA_SECURITY_PVT.Get_Grantee_Key('PERSON',p_person_id, 'Y');
150: end if;
151: */

Line 149: g_key := PA_SECURITY_PVT.Get_Grantee_Key('PERSON',p_person_id, 'Y');

145: /* Changes for ATG mandate for deprecated parameter
146: if(p_person_id is null) then
147: g_key := PA_SECURITY_PVT.Get_Grantee_Key('USER');
148: else
149: g_key := PA_SECURITY_PVT.Get_Grantee_Key('PERSON',p_person_id, 'Y');
150: end if;
151: */
152: /*
153: if (not fnd_function.test(p_privilege)) then

Line 184: 'FPA_SECURITY_PVT.Check_User_Previlege',

180: WHEN OTHERS THEN
181: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
182: FND_LOG.String(
183: FND_LOG.LEVEL_PROCEDURE,
184: 'FPA_SECURITY_PVT.Check_User_Previlege',
185: p_privilege||','||p_object_name||','||p_object_id);
186: end if;
187: return 'U';
188: END Check_Privilege;

Line 297: p_msg_log => 'Entering fpa_security_pvt.grant_role',

293: p_init_msg_list => p_init_msg_list,
294: l_api_version => l_api_version,
295: p_api_version => p_api_version,
296: p_api_type => G_API_TYPE,
297: p_msg_log => 'Entering fpa_security_pvt.grant_role',
298: x_return_status => x_return_status);
299:
300: -- check if activity started successfully
301: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

Line 309: l_grantee_key:= PA_SECURITY_PVT.Get_Grantee_Key(

305: l_msg_log := 'start_activity';
306: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
307: end if;
308:
309: l_grantee_key:= PA_SECURITY_PVT.Get_Grantee_Key(
310: p_source_type,
311: p_party_id,
312: 'Y');
313:

Line 338: l_secured_role_menu := PA_SECURITY_PVT.Get_Menu_Name(p_project_role_id);

334: return;
335:
336: end if;
337:
338: l_secured_role_menu := PA_SECURITY_PVT.Get_Menu_Name(p_project_role_id);
339:
340: if l_secured_role_menu is null then
341: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
342: FPA_UTILITIES_PVT.SET_MESSAGE(

Line 348: l_instance_set_id := PA_SECURITY_PVT.Get_Instance_Set_Id(p_object_set);

344: , p_msg_name => 'PA_INVALID_PROJECT_ROLE');
345: -- l_msg_log := p_portfolio_party_id;
346: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
347: end if;
348: l_instance_set_id := PA_SECURITY_PVT.Get_Instance_Set_Id(p_object_set);
349:
350:
351: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
352:

Line 504: p_msg_log => 'Entering fpa_security_pvt.grant_role',

500: p_init_msg_list => p_init_msg_list,
501: l_api_version => l_api_version,
502: p_api_version => p_api_version,
503: p_api_type => G_API_TYPE,
504: p_msg_log => 'Entering fpa_security_pvt.grant_role',
505: x_return_status => x_return_status);
506:
507: -- check if activity started successfully
508: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

Line 537: l_grantee_key:= PA_SECURITY_PVT.Get_Grantee_Key(

533: return;
534:
535: end if;
536:
537: l_grantee_key:= PA_SECURITY_PVT.Get_Grantee_Key(
538: p_source_type,
539: p_party_id,
540: 'Y');
541:

Line 584: l_msg_log := 'fpa_security_pvt.revoke_grant '||l_grant_id;

580: end if;
581:
582: -- check if activity started successfully
583: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
584: l_msg_log := 'fpa_security_pvt.revoke_grant '||l_grant_id;
585: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
586: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
587: l_msg_log := 'fpa_security_pvt.revoke_grant '||l_grant_id;
588: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;

Line 587: l_msg_log := 'fpa_security_pvt.revoke_grant '||l_grant_id;

583: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
584: l_msg_log := 'fpa_security_pvt.revoke_grant '||l_grant_id;
585: raise FPA_UTILITIES_PVT.G_EXCEPTION_UNEXPECTED_ERROR;
586: elsif (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_ERROR) then
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;

Line 712: p_msg_log => 'Entering fpa_security_pvt.create_portfolio_user',

708: p_init_msg_list => p_init_msg_list,
709: l_api_version => l_api_version,
710: p_api_version => p_api_version,
711: p_api_type => G_API_TYPE,
712: p_msg_log => 'Entering fpa_security_pvt.create_portfolio_user',
713: x_return_status => x_return_status);
714:
715: -- check if activity started successfully
716: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

Line 738: l_role := PA_SECURITY_PVT.get_proj_role_name(p_project_role_id);

734: end if;
735: */
736: if (Get_Role(p_project_role_id) = G_OWNER AND Get_Owner(p_object_id) is not null) then
737: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_ERROR;
738: l_role := PA_SECURITY_PVT.get_proj_role_name(p_project_role_id);
739: FPA_UTILITIES_PVT.SET_MESSAGE(
740: p_app_name => g_app_name
741: , p_msg_name => 'FPA_SEC_OWNER_ROLE_EXISTS'
742: , p_token1 => 'ROLE'

Line 918: p_msg_log => 'Entering fpa_security_pvt.update_portfolio_user',

914: p_init_msg_list => p_init_msg_list,
915: l_api_version => l_api_version,
916: p_api_version => p_api_version,
917: p_api_type => G_API_TYPE,
918: p_msg_log => 'Entering fpa_security_pvt.update_portfolio_user',
919: x_return_status => x_return_status);
920:
921: -- check if activity started successfully
922: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

Line 1189: p_msg_log => 'Entering fpa_security_pvt.update_portfolio_owner',

1185: p_init_msg_list => p_init_msg_list,
1186: l_api_version => l_api_version,
1187: p_api_version => p_api_version,
1188: p_api_type => G_API_TYPE,
1189: p_msg_log => 'Entering fpa_security_pvt.update_portfolio_owner',
1190: x_return_status => x_return_status);
1191:
1192: -- check if activity started successfully
1193: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

Line 1215: p_msg_log => 'Exiting fpa_security_pvt.update_portfolio_owner',

1211: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
1212: FPA_UTILITIES_PVT.END_ACTIVITY(
1213: p_api_name => l_api_name,
1214: p_pkg_name => G_PKG_NAME,
1215: p_msg_log => 'Exiting fpa_security_pvt.update_portfolio_owner',
1216: x_msg_count => x_msg_count,
1217: x_msg_data => x_msg_data);
1218: end if;
1219:

Line 1428: p_msg_log => 'Entering fpa_security_pvt.delete_portfolio_user',

1424: p_init_msg_list => p_init_msg_list,
1425: l_api_version => l_api_version,
1426: p_api_version => p_api_version,
1427: p_api_type => G_API_TYPE,
1428: p_msg_log => 'Entering fpa_security_pvt.delete_portfolio_user',
1429: x_return_status => x_return_status);
1430:
1431: -- check if activity started successfully
1432: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

Line 1481: l_instance_set_id := pa_security_pvt.get_instance_set_id(p_instance_set_name);

1477: l_msg_log := 'FPA_SEC_DELETE_FAILED '||p_portfolio_party_id;
1478: raise FPA_UTILITIES_PVT.G_EXCEPTION_ERROR;
1479: end if;
1480:
1481: l_instance_set_id := pa_security_pvt.get_instance_set_id(p_instance_set_name);
1482:
1483: Revoke_Role(p_api_version => l_api_version,
1484: p_init_msg_list => p_init_msg_list,
1485: p_project_role_id => l_role_id,

Line 1506: p_msg_log => 'end fpa_security_pvt.Delete_Portfolio_User',

1502:
1503: FPA_UTILITIES_PVT.END_ACTIVITY(
1504: p_api_name => l_api_name,
1505: p_pkg_name => G_PKG_NAME,
1506: p_msg_log => 'end fpa_security_pvt.Delete_Portfolio_User',
1507: x_msg_count => x_msg_count,
1508: x_msg_data => x_msg_data);
1509:
1510:

Line 1544: end FPA_SECURITY_PVT;

1540: p_api_type => G_API_TYPE);
1541:
1542: END Delete_Portfolio_User;
1543:
1544: end FPA_SECURITY_PVT;