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 2326: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 4040: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 4067: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 4103: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 4130: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 4166: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 4193: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 4230: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 4257: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 4293: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 4320: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 4354: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 4884: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 5501: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 5965: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 7597: PA_SECURITY_PVT.CHECK_CONFIRM_ASMT

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

Line 7617: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 9098: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 9132: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 9174: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 9207: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 9244: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 9272: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 9308: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 9336: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 9940: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 9955: PA_SECURITY_PVT.CHECK_CONFIRM_ASMT(

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

Line 10469: pa_security_pvt.check_confirm_asmt

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

Line 10487: pa_security_pvt.check_confirm_asmt

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

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

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

Line 11131: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 11142: 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);

11138: , p_object_key => l_object_key
11139: , p_init_msg_list => FND_API.G_FALSE);
11140:
11141: IF l_debug_mode = 'Y' THEN
11142: 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);
11143: pa_debug.write(l_module, 'l_ret_code ='|| l_ret_code , l_debug_level);
11144: END IF ;
11145:
11146: IF (nvl(l_ret_code, 'F') = 'F' OR l_return_status <> FND_API.G_RET_STS_SUCCESS)

Line 11155: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

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

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

Line 11731: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 11741: 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);

11737: , p_object_name => l_object_name
11738: , p_object_key => l_object_key
11739: ,p_init_msg_list => FND_API.G_FALSE);
11740: IF l_debug_mode = 'Y' THEN
11741: 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);
11742: pa_debug.write(l_module, 'l_ret_code'|| l_ret_code, l_debug_level);
11743: END IF ;
11744:
11745: IF (nvl(l_ret_code, 'F') = 'F' OR l_return_status <> FND_API.G_RET_STS_SUCCESS)

Line 11755: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

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

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

Line 12229: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 12240: 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);

12236: , p_object_key => l_object_key
12237: ,p_init_msg_list => FND_API.G_FALSE);
12238:
12239: IF l_debug_mode = 'Y' THEN
12240: 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);
12241: pa_debug.write(l_module, 'l_ret_code'|| l_ret_code, l_debug_level);
12242: END IF ;
12243:
12244: IF (nvl(l_ret_code, 'F') = 'F' OR l_return_status <> FND_API.G_RET_STS_SUCCESS)

Line 12254: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 12799: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

Line 12817: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

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

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

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

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

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

Line 13353: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

13349:
13350: l_return_status := FND_API.G_RET_STS_SUCCESS;
13351: l_ret_code := 'T';
13352:
13353: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
13354: x_ret_code => l_ret_code
13355: , x_return_status => l_return_status
13356: , x_msg_count => l_msg_count
13357: , x_msg_data => l_msg_data

Line 13370: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

13366:
13367: l_return_status := FND_API.G_RET_STS_SUCCESS;
13368: l_ret_code := 'T';
13369:
13370: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
13371: x_ret_code => l_ret_code
13372: , x_return_status => l_return_status
13373: , x_msg_count => l_msg_count
13374: , x_msg_data => l_msg_data

Line 13780: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

13776:
13777: l_return_status := FND_API.G_RET_STS_SUCCESS;
13778: l_ret_code := 'T';
13779:
13780: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
13781: x_ret_code => l_ret_code
13782: , x_return_status => l_return_status
13783: , x_msg_count => l_msg_count
13784: , x_msg_data => l_msg_data

Line 13797: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

13793:
13794: l_return_status := FND_API.G_RET_STS_SUCCESS;
13795: l_ret_code := 'T';
13796:
13797: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
13798: x_ret_code => l_ret_code
13799: , x_return_status => l_return_status
13800: , x_msg_count => l_msg_count
13801: , x_msg_data => l_msg_data

Line 14252: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

14248:
14249: l_return_status := FND_API.G_RET_STS_SUCCESS;
14250: l_ret_code := 'T';
14251:
14252: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
14253: x_ret_code => l_ret_code
14254: , x_return_status => l_return_status
14255: , x_msg_count => l_msg_count
14256: , x_msg_data => l_msg_data

Line 14269: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(

14265:
14266: l_return_status := FND_API.G_RET_STS_SUCCESS;
14267: l_ret_code := 'T';
14268:
14269: PA_SECURITY_PVT.CHECK_USER_PRIVILEGE(
14270: x_ret_code => l_ret_code
14271: , x_return_status => l_return_status
14272: , x_msg_count => l_msg_count
14273: , x_msg_data => l_msg_data