DBA Data[Home] [Help]

APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_SECURITY_PVT

Line 85: (select pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') menu_id

81: fnd_grants fg,
82: fnd_objects fob,
83: per_all_people_f per,
84: wf_roles wfr,
85: (select pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') menu_id
86: from dual) prmry_contact_menu
87: where fob.obj_name = 'ORGANIZATION'
88: and res_denorm.resource_id = l_resource_id
89: and l_start_date between res_denorm.resource_effective_start_date and res_denorm.resource_effective_end_date

Line 107: (select pa_security_pvt.get_menu_id('PA_PRM_RES_AUTH') menu_id

103: fnd_grants fg,
104: fnd_objects fob,
105: wf_roles wfr,
106: per_people_f per,
107: (select pa_security_pvt.get_menu_id('PA_PRM_RES_AUTH') menu_id
108: from dual) res_auth_menu
109: where fob.obj_name = 'ORGANIZATION'
110: and res_denorm.resource_id = l_resource_id
111: and fg.instance_pk1_value = to_char(res_denorm.resource_organization_id)

Line 131: (select pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') menu_id

127: from
128: fnd_grants fg2,
129: fnd_objects fob2,
130: wf_roles wfr2,
131: (select pa_security_pvt.get_menu_id('PA_PRM_RES_PRMRY_CONTACT') menu_id
132: from dual) prmry_contact_menu,
133: per_people_f per2
134: where fob.obj_name = 'ORGANIZATION'
135: and fg2.instance_pk1_value = to_char(res_denorm.resource_organization_id)

Line 2327: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

2323:
2324: l_return_status := FND_API.G_RET_STS_SUCCESS;
2325: l_ret_code := 'T';
2326:
2327: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
2328: x_ret_code => l_ret_code
2329: , x_return_status => l_return_status
2330: , x_msg_count => l_msg_count
2331: , x_msg_data => l_msg_data

Line 4041: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

4037: IF l_debug_mode = 'Y' THEN
4038: pa_debug.write(l_module, 'Checking Project Level Security for PA_ASN_BASIC_INFO_ED', l_log_level);
4039: END IF ;
4040:
4041: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
4042: x_ret_code => l_ret_code
4043: , x_return_status => l_return_status
4044: , x_msg_count => l_msg_count
4045: , x_msg_data => l_msg_data

Line 4068: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

4064: l_privilege := 'PA_ASN_BASIC_INFO_ED';
4065: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
4066: l_object_key := l_req_rec.requirement_id;
4067:
4068: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
4069: x_ret_code => l_ret_code
4070: , x_return_status => l_return_status
4071: , x_msg_count => l_msg_count
4072: , x_msg_data => l_msg_data

Line 4104: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

4100: IF l_debug_mode = 'Y' THEN
4101: pa_debug.write(l_module, 'Checking Project Level Security for PA_CREATE_CANDIDATES', l_log_level);
4102: END IF ;
4103:
4104: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
4105: x_ret_code => l_ret_code
4106: , x_return_status => l_return_status
4107: , x_msg_count => l_msg_count
4108: , x_msg_data => l_msg_data

Line 4131: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

4127: l_privilege := 'PA_CREATE_CANDIDATES';
4128: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
4129: l_object_key := l_req_rec.requirement_id;
4130:
4131: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
4132: x_ret_code => l_ret_code
4133: , x_return_status => l_return_status
4134: , x_msg_count => l_msg_count
4135: , x_msg_data => l_msg_data

Line 4167: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

4163: IF l_debug_mode = 'Y' THEN
4164: pa_debug.write(l_module, 'Checking Project Level Security for PA_ASN_FCST_INFO_ED', l_log_level);
4165: END IF ;
4166:
4167: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
4168: x_ret_code => l_ret_code
4169: , x_return_status => l_return_status
4170: , x_msg_count => l_msg_count
4171: , x_msg_data => l_msg_data

Line 4194: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

4190: l_privilege := 'PA_ASN_FCST_INFO_ED';
4191: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
4192: l_object_key := l_req_rec.requirement_id;
4193:
4194: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
4195: x_ret_code => l_ret_code
4196: , x_return_status => l_return_status
4197: , x_msg_count => l_msg_count
4198: , x_msg_data => l_msg_data

Line 4231: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

4227: IF l_debug_mode = 'Y' THEN
4228: pa_debug.write(l_module, 'Checking Project Level Security for PA_ASN_FCST_INFO_BILL_ED', l_log_level);
4229: END IF ;
4230:
4231: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
4232: x_ret_code => l_ret_code
4233: , x_return_status => l_return_status
4234: , x_msg_count => l_msg_count
4235: , x_msg_data => l_msg_data

Line 4258: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

4254: l_privilege := 'PA_ASN_FCST_INFO_BILL_ED';
4255: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
4256: l_object_key := l_req_rec.requirement_id;
4257:
4258: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
4259: x_ret_code => l_ret_code
4260: , x_return_status => l_return_status
4261: , x_msg_count => l_msg_count
4262: , x_msg_data => l_msg_data

Line 4294: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

4290: IF l_debug_mode = 'Y' THEN
4291: pa_debug.write(l_module, 'Checking Project Level Security for PA_ASN_FCST_INFO_TP_ED', l_log_level);
4292: END IF ;
4293:
4294: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
4295: x_ret_code => l_ret_code
4296: , x_return_status => l_return_status
4297: , x_msg_count => l_msg_count
4298: , x_msg_data => l_msg_data

Line 4321: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

4317: l_privilege := 'PA_ASN_FCST_INFO_TP_ED';
4318: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
4319: l_object_key := l_req_rec.requirement_id;
4320:
4321: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
4322: x_ret_code => l_ret_code
4323: , x_return_status => l_return_status
4324: , x_msg_count => l_msg_count
4325: , x_msg_data => l_msg_data

Line 4355: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

4351: IF l_debug_mode = 'Y' THEN
4352: pa_debug.write(l_module,'Checking Team template security', l_log_level);
4353: END IF ;
4354:
4355: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
4356: x_ret_code => l_ret_code
4357: , x_return_status => l_return_status
4358: , x_msg_count => l_msg_count
4359: , x_msg_data => l_msg_data

Line 4885: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

4881:
4882: l_return_status := FND_API.G_RET_STS_SUCCESS;
4883: l_ret_code := 'T';
4884:
4885: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
4886: x_ret_code => l_ret_code
4887: , x_return_status => l_return_status
4888: , x_msg_count => l_msg_count
4889: , x_msg_data => l_msg_data

Line 5502: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

5498:
5499: l_return_status := FND_API.G_RET_STS_SUCCESS;
5500: l_ret_code := 'T';
5501:
5502: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
5503: x_ret_code => l_ret_code
5504: , x_return_status => l_return_status
5505: , x_msg_count => l_msg_count
5506: , x_msg_data => l_msg_data

Line 5966: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

5962:
5963: l_return_status := FND_API.G_RET_STS_SUCCESS;
5964: l_ret_code := 'T';
5965:
5966: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
5967: x_ret_code => l_ret_code
5968: , x_return_status => l_return_status
5969: , x_msg_count => l_msg_count
5970: , x_msg_data => l_msg_data

Line 7599: PA_SECURITY_PVT.CHECK_CONFIRM_ASMT

7595: IF l_debug_mode = 'Y' THEN
7596: pa_debug.write(l_module, 'Checking Resource Authority', l_log_level);
7597: END IF;
7598:
7599: PA_SECURITY_PVT.CHECK_CONFIRM_ASMT
7600: (p_project_id => l_asgn_rec.project_id
7601: , p_resource_id => l_asgn_rec.resource_id
7602: , p_resource_name => null
7603: , p_privilege => l_privilege

Line 7619: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

7615: IF l_debug_mode = 'Y' THEN
7616: pa_debug.write(l_module, 'Checking Project Security', l_log_level);
7617: END IF;
7618:
7619: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
7620: x_ret_code => l_ret_code
7621: , x_return_status => l_return_status
7622: , x_msg_count => l_msg_count
7623: , x_msg_data => l_msg_data

Line 9100: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

9096: pa_debug.write(l_module, 'Checking Project Level Security for PA_ASN_BASIC_INFO_ED', l_log_level);
9097: END IF ;
9098:
9099: l_before_api_msg_count := FND_MSG_PUB.COUNT_MSG;
9100: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
9101: x_ret_code => l_ret_code
9102: , x_return_status => l_return_status
9103: , x_msg_count => l_msg_count
9104: , x_msg_data => l_msg_data

Line 9134: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

9130: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
9131: l_object_key := l_asgn_rec.assignment_id;
9132:
9133: l_before_api_msg_count := FND_MSG_PUB.COUNT_MSG;
9134: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
9135: x_ret_code => l_ret_code
9136: , x_return_status => l_return_status
9137: , x_msg_count => l_msg_count
9138: , x_msg_data => l_msg_data

Line 9176: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

9172: pa_debug.write(l_module, 'Checking Project Level Security for PA_ASN_FCST_INFO_ED', l_log_level);
9173: END IF ;
9174:
9175: l_before_api_msg_count := FND_MSG_PUB.COUNT_MSG;
9176: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
9177: x_ret_code => l_ret_code
9178: , x_return_status => l_return_status
9179: , x_msg_count => l_msg_count
9180: , x_msg_data => l_msg_data

Line 9209: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

9205: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
9206: l_object_key := l_asgn_rec.assignment_id;
9207:
9208: l_before_api_msg_count := FND_MSG_PUB.COUNT_MSG;
9209: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
9210: x_ret_code => l_ret_code
9211: , x_return_status => l_return_status
9212: , x_msg_count => l_msg_count
9213: , x_msg_data => l_msg_data

Line 9246: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

9242: pa_debug.write(l_module, 'Checking Project Level Security for PA_ASN_FCST_INFO_BILL_ED', l_log_level);
9243: END IF ;
9244:
9245: l_before_api_msg_count := FND_MSG_PUB.COUNT_MSG;
9246: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
9247: x_ret_code => l_ret_code
9248: , x_return_status => l_return_status
9249: , x_msg_count => l_msg_count
9250: , x_msg_data => l_msg_data

Line 9274: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

9270: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
9271: l_object_key := l_asgn_rec.assignment_id;
9272:
9273: l_before_api_msg_count := FND_MSG_PUB.COUNT_MSG;
9274: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
9275: x_ret_code => l_ret_code
9276: , x_return_status => l_return_status
9277: , x_msg_count => l_msg_count
9278: , x_msg_data => l_msg_data

Line 9310: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

9306: pa_debug.write(l_module, 'Checking Project Level Security for PA_ASN_FCST_INFO_TP_ED', l_log_level);
9307: END IF ;
9308:
9309: l_before_api_msg_count := FND_MSG_PUB.COUNT_MSG;
9310: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
9311: x_ret_code => l_ret_code
9312: , x_return_status => l_return_status
9313: , x_msg_count => l_msg_count
9314: , x_msg_data => l_msg_data

Line 9338: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

9334: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
9335: l_object_key := l_asgn_rec.assignment_id;
9336:
9337: l_before_api_msg_count := FND_MSG_PUB.COUNT_MSG;
9338: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
9339: x_ret_code => l_ret_code
9340: , x_return_status => l_return_status
9341: , x_msg_count => l_msg_count
9342: , x_msg_data => l_msg_data

Line 9942: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

9938:
9939: l_return_status := FND_API.G_RET_STS_SUCCESS;
9940: l_ret_code := 'T';
9941:
9942: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
9943: x_ret_code => l_ret_code
9944: , x_return_status => l_return_status
9945: , x_msg_count => l_msg_count
9946: , x_msg_data => l_msg_data

Line 9957: PA_SECURITY_PVT.CHECK_CONFIRM_ASMT(

9953:
9954: l_return_status := FND_API.G_RET_STS_SUCCESS;
9955: l_ret_code := 'T';
9956:
9957: PA_SECURITY_PVT.CHECK_CONFIRM_ASMT(
9958: p_project_id => l_project_id
9959: , p_resource_id => l_resource_id
9960: , p_resource_name => null
9961: , p_privilege => 'PA_ADM_ASN_CONFIRM'

Line 10471: pa_security_pvt.check_confirm_asmt

10467: IF l_debug_mode = 'Y' THEN
10468: pa_debug.write(l_module, 'Checking for PA_ASN_CONFIRM privilege',l_log_level);
10469: END IF;
10470:
10471: pa_security_pvt.check_confirm_asmt
10472: (p_project_id => l_project_id
10473: ,p_resource_id => l_resource_id
10474: ,p_resource_name => null
10475: ,p_privilege => 'PA_ASN_CONFIRM'

Line 10489: pa_security_pvt.check_confirm_asmt

10485: IF l_debug_mode = 'Y' THEN
10486: pa_debug.write(l_module, 'Checking for PA_ADM_ASN_CONFIRM privilege',l_log_level);
10487: END IF;
10488:
10489: pa_security_pvt.check_confirm_asmt
10490: (p_project_id => l_project_id
10491: ,p_resource_id => l_resource_id
10492: ,p_resource_name => null
10493: ,p_privilege => 'PA_ADM_ASN_CONFIRM'

Line 11123: pa_debug.write(l_module, 'Calling PA_SECURITY_PVT.CHECK_USER_PRIVILEGE for Record = '||i||' with Following Values', l_debug_level);

11119: raise FND_API.G_EXC_ERROR;
11120: END IF;
11121:
11122: IF l_debug_mode = 'Y' THEN
11123: pa_debug.write(l_module, 'Calling PA_SECURITY_PVT.CHECK_USER_PRIVILEGE for Record = '||i||' with Following Values', l_debug_level);
11124: pa_debug.write(l_module, 'l_privilege :'|| l_privilege, l_debug_level);
11125: pa_debug.write(l_module, 'l_object_name :'||l_object_name, l_debug_level);
11126: pa_debug.write(l_module, 'l_object_key :'||l_object_key, l_debug_level);
11127: END IF;

Line 11133: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

11129: l_return_status := FND_API.G_RET_STS_SUCCESS;
11130: l_ret_code := 'T';
11131:
11132: -- Checking Security at project level or at Template level
11133: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
11134: x_ret_code => l_ret_code
11135: , x_return_status => l_return_status
11136: , x_msg_count => l_msg_count
11137: , x_msg_data => l_msg_data

Line 11144: pa_debug.write(l_module, 'Return Status from PA_SECURITY_PVT.CHECK_USER_PRIVILEGE for Record '||i||'is l_return_status '|| l_return_status , l_debug_level);

11140: , p_object_key => l_object_key
11141: , p_init_msg_list => FND_API.G_FALSE);
11142:
11143: IF l_debug_mode = 'Y' THEN
11144: pa_debug.write(l_module, 'Return Status from PA_SECURITY_PVT.CHECK_USER_PRIVILEGE for Record '||i||'is l_return_status '|| l_return_status , l_debug_level);
11145: pa_debug.write(l_module, 'l_ret_code ='|| l_ret_code , l_debug_level);
11146: END IF ;
11147:
11148: IF (nvl(l_ret_code, 'F') = 'F' OR l_return_status <> FND_API.G_RET_STS_SUCCESS)

Line 11157: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

11153: END IF ;
11154: l_privilege := 'PA_ASN_BASIC_INFO_ED';
11155: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
11156: l_object_key := l_requirement_id;
11157: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
11158: x_ret_code => l_ret_code
11159: , x_return_status => l_return_status
11160: , x_msg_count => l_msg_count
11161: , x_msg_data => l_msg_data

Line 11723: pa_debug.write(l_module, 'Calling PA_SECURITY_PVT.CHECK_USER_PRIVILEGE for Record '||i||'with Following Values', l_debug_level);

11719: raise FND_API.G_EXC_ERROR;
11720: END IF;
11721:
11722: IF l_debug_mode = 'Y' THEN
11723: pa_debug.write(l_module, 'Calling PA_SECURITY_PVT.CHECK_USER_PRIVILEGE for Record '||i||'with Following Values', l_debug_level);
11724: pa_debug.write(l_module, 'l_privilege'|| l_privilege, l_debug_level);
11725: pa_debug.write(l_module, 'l_object_name'||l_object_name, l_debug_level);
11726: pa_debug.write(l_module, 'l_object_key'||l_object_key, l_debug_level);
11727: END IF;

Line 11733: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

11729: l_return_status := FND_API.G_RET_STS_SUCCESS;
11730: l_ret_code := 'T';
11731:
11732: -- Checking Security at project level or at Template level
11733: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
11734: x_ret_code => l_ret_code
11735: , x_return_status => l_return_status
11736: , x_msg_count => l_msg_count
11737: , x_msg_data => l_msg_data

Line 11743: pa_debug.write(l_module, 'Return Status from PA_SECURITY_PVT.CHECK_USER_PRIVILEGE for Record '||i||'is l_return_status '|| l_return_status , l_debug_level);

11739: , p_object_name => l_object_name
11740: , p_object_key => l_object_key
11741: ,p_init_msg_list => FND_API.G_FALSE);
11742: IF l_debug_mode = 'Y' THEN
11743: pa_debug.write(l_module, 'Return Status from PA_SECURITY_PVT.CHECK_USER_PRIVILEGE for Record '||i||'is l_return_status '|| l_return_status , l_debug_level);
11744: pa_debug.write(l_module, 'l_ret_code'|| l_ret_code, l_debug_level);
11745: END IF ;
11746:
11747: IF (nvl(l_ret_code, 'F') = 'F' OR l_return_status <> FND_API.G_RET_STS_SUCCESS)

Line 11757: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

11753:
11754: l_privilege := 'PA_ASN_BASIC_INFO_ED';
11755: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
11756: l_object_key := l_requirement_id;
11757: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
11758: x_ret_code => l_ret_code
11759: , x_return_status => l_return_status
11760: , x_msg_count => l_msg_count
11761: , x_msg_data => l_msg_data

Line 12221: pa_debug.write(l_module, 'Calling PA_SECURITY_PVT.CHECK_USER_PRIVILEGE for Record '||i||'with Following Values', l_debug_level);

12217: raise FND_API.G_EXC_ERROR;
12218: END IF;
12219:
12220: IF l_debug_mode = 'Y' THEN
12221: pa_debug.write(l_module, 'Calling PA_SECURITY_PVT.CHECK_USER_PRIVILEGE for Record '||i||'with Following Values', l_debug_level);
12222: pa_debug.write(l_module, 'l_privilege'|| l_privilege, l_debug_level);
12223: pa_debug.write(l_module, 'l_object_name'||l_object_name, l_debug_level);
12224: pa_debug.write(l_module, 'l_object_key'||l_object_key, l_debug_level);
12225: END IF;

Line 12231: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

12227: l_return_status := FND_API.G_RET_STS_SUCCESS;
12228: l_ret_code := 'T';
12229:
12230: -- Checking Security at project level or at Template level
12231: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
12232: x_ret_code => l_ret_code
12233: , x_return_status => l_return_status
12234: , x_msg_count => l_msg_count
12235: , x_msg_data => l_msg_data

Line 12242: pa_debug.write(l_module, 'Return Status from PA_SECURITY_PVT.CHECK_USER_PRIVILEGE for Record '||i||'is l_return_status '|| l_return_status , l_debug_level);

12238: , p_object_key => l_object_key
12239: ,p_init_msg_list => FND_API.G_FALSE);
12240:
12241: IF l_debug_mode = 'Y' THEN
12242: pa_debug.write(l_module, 'Return Status from PA_SECURITY_PVT.CHECK_USER_PRIVILEGE for Record '||i||'is l_return_status '|| l_return_status , l_debug_level);
12243: pa_debug.write(l_module, 'l_ret_code'|| l_ret_code, l_debug_level);
12244: END IF ;
12245:
12246: IF (nvl(l_ret_code, 'F') = 'F' OR l_return_status <> FND_API.G_RET_STS_SUCCESS)

Line 12256: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

12252:
12253: l_privilege := 'PA_ASN_BASIC_INFO_ED';
12254: l_object_name := 'PA_PROJECT_ASSIGNMENTS';
12255: l_object_key := l_requirement_id;
12256: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
12257: x_ret_code => l_ret_code
12258: , x_return_status => l_return_status
12259: , x_msg_count => l_msg_count
12260: , x_msg_data => l_msg_data

Line 12801: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

12797:
12798: l_return_status := FND_API.G_RET_STS_SUCCESS;
12799: l_ret_code := 'T';
12800:
12801: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
12802: x_ret_code => l_ret_code
12803: , x_return_status => l_return_status
12804: , x_msg_count => l_msg_count
12805: , x_msg_data => l_msg_data

Line 12819: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

12815:
12816: l_return_status := FND_API.G_RET_STS_SUCCESS;
12817: l_ret_code := 'T';
12818:
12819: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
12820: x_ret_code => l_ret_code
12821: , x_return_status => l_return_status
12822: , x_msg_count => l_msg_count
12823: , x_msg_data => l_msg_data

Line 12860: PA_SECURITY_PVT.CHECK_CONFIRM_ASMT(p_project_id => -999,

12856: l_privilege_name := 'PA_NOMINATE_CANDIDATES';
12857: ELSE l_privilege_name := 'PA_NOMINATE_SELF_AS_CANDIDATE';
12858: END IF;
12859:
12860: PA_SECURITY_PVT.CHECK_CONFIRM_ASMT(p_project_id => -999,
12861: p_resource_id => l_candidate_in_rec.resource_id,
12862: p_resource_name => null,
12863: p_privilege => l_privilege_name,
12864: p_start_date => l_requirement_start_date,

Line 12877: pa_debug.write(l_module, 'After call of PA_SECURITY_PVT.CHECK_CONFIRM_ASMT', l_log_level);

12873: ,p_msg_name => 'PA_NO_RESOURCE_AUTHORITY' );
12874: END IF;
12875:
12876: IF l_debug_mode = 'Y' THEN
12877: pa_debug.write(l_module, 'After call of PA_SECURITY_PVT.CHECK_CONFIRM_ASMT', l_log_level);
12878: END IF;
12879:
12880: END IF;
12881:

Line 13374: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

13370:
13371: l_return_status := FND_API.G_RET_STS_SUCCESS;
13372: l_ret_code := 'T';
13373:
13374: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
13375: x_ret_code => l_ret_code
13376: , x_return_status => l_return_status
13377: , x_msg_count => l_msg_count
13378: , x_msg_data => l_msg_data

Line 13391: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

13387:
13388: l_return_status := FND_API.G_RET_STS_SUCCESS;
13389: l_ret_code := 'T';
13390:
13391: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
13392: x_ret_code => l_ret_code
13393: , x_return_status => l_return_status
13394: , x_msg_count => l_msg_count
13395: , x_msg_data => l_msg_data

Line 13818: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

13814:
13815: l_return_status := FND_API.G_RET_STS_SUCCESS;
13816: l_ret_code := 'T';
13817:
13818: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
13819: x_ret_code => l_ret_code
13820: , x_return_status => l_return_status
13821: , x_msg_count => l_msg_count
13822: , x_msg_data => l_msg_data

Line 13835: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

13831:
13832: l_return_status := FND_API.G_RET_STS_SUCCESS;
13833: l_ret_code := 'T';
13834:
13835: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
13836: x_ret_code => l_ret_code
13837: , x_return_status => l_return_status
13838: , x_msg_count => l_msg_count
13839: , x_msg_data => l_msg_data

Line 14290: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

14286:
14287: l_return_status := FND_API.G_RET_STS_SUCCESS;
14288: l_ret_code := 'T';
14289:
14290: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
14291: x_ret_code => l_ret_code
14292: , x_return_status => l_return_status
14293: , x_msg_count => l_msg_count
14294: , x_msg_data => l_msg_data

Line 14307: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

14303:
14304: l_return_status := FND_API.G_RET_STS_SUCCESS;
14305: l_ret_code := 'T';
14306:
14307: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
14308: x_ret_code => l_ret_code
14309: , x_return_status => l_return_status
14310: , x_msg_count => l_msg_count
14311: , x_msg_data => l_msg_data