[Home] [Help]
177: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PUB.Exceute_Create_Assignment.begin'
178: ,x_msg => 'Work type is not valid'
179: ,x_log_level => 5);
180:
181: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
182: ,p_msg_name => 'PA_INVALID_WORK_TYPE');
183: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
184:
185:
203:
204: IF p_assignment_type = 'OPEN_ASSIGNMENT' THEN
205: FND_PROFILE.Get('PA_START_OPEN_ASGMT_STATUS',l_assignment_rec.status_code);
206: IF l_assignment_rec.status_code IS NULL THEN
207: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
208: ,p_msg_name => 'PA_START_STATUS_NOT_DEFINED');
209: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
210: END IF;
211: END IF;
212:
213: IF (p_assignment_type = 'STAFFED_ASSIGNMENT' OR p_assignment_type = 'STAFFED_ADMIN_ASSIGNMENT') THEN
214: FND_PROFILE.Get('PA_START_STAFFED_ASGMT_STATUS',l_assignment_rec.status_code);
215: IF l_assignment_rec.status_code IS NULL THEN
216: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
217: ,p_msg_name => 'PA_START_STATUS_NOT_DEFINED');
218: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
219: END IF;
220: END IF;
340: -- OR l_assignment_rec.staffing_owner_person_id IS NULL
341:
342: THEN
343:
344: pa_assignment_utils.Get_Default_Staffing_Owner
345: ( p_project_id => l_assignment_rec.project_id
346: ,p_exp_org_id => null
347: ,x_person_id => l_assignment_rec.staffing_owner_person_id
348: ,x_person_name => l_person_name
512: l_assignment_rec.end_date := p_end_date;
513:
514:
515: -- Retrieve default staffing owner person id
516: pa_assignment_utils.Get_Default_Staffing_Owner
517: ( p_project_id => p_project_id
518: ,p_exp_org_id => null
519: ,x_person_id => l_assignment_rec.staffing_owner_person_id
520: ,x_person_name => l_person_name
791: END IF;
792:
793: -- Bug 3466411
794: -- Retrieve default staffing owner person id
795: pa_assignment_utils.Get_Default_Staffing_Owner
796: ( p_project_id => l_assignment_rec.project_id
797: ,p_exp_org_id => null
798: ,x_person_id => l_assignment_rec.staffing_owner_person_id
799: ,x_person_name => l_person_name
1056: FETCH check_team_template_wf INTO l_workflow_in_progress_flag;
1057: CLOSE check_team_template_wf;
1058:
1059: IF l_workflow_in_progress_flag='Y' THEN
1060: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1061: ,p_msg_name => 'PA_NO_REQ_WF');
1062: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1063: x_return_status := FND_API.G_RET_STS_ERROR;
1064: END IF;
1101:
1102: --dbms_output.put_line('error_message_code :'||l_error_message_code);
1103:
1104: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1105: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1106: ,p_msg_name => l_error_message_code);
1107: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1108: END IF;
1109: l_return_status := FND_API.G_MISS_CHAR;
1138: --
1139: IF (l_assignment_rec.assignment_type = 'STAFFED_ADMIN_ASSIGNMENT' AND
1140: l_admin_flag <> 'Y') OR
1141: (l_assignment_rec.assignment_type = 'STAFFED_ASSIGNMENT' AND l_admin_flag = 'Y') THEN
1142: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1143: ,p_msg_name => 'PA_CREATE_ADMIN_RESTRICT');
1144: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1145: END IF; --staffed admin or staffed assignment with admin project
1146:
1172: IF l_unassigned_time IS NULL THEN
1173: l_unassigned_time := PA_PROJECT_UTILS.is_unassigned_time_project(l_assignment_rec.project_id);
1174: END IF;
1175: IF l_unassigned_time = 'Y' THEN
1176: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1177: ,p_msg_name => 'PA_NO_ASGMT_UNASSIGN_TIME_PROJ');
1178: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1179: END IF;
1180:
1185: x_err_code => l_error_message_code
1186: );
1187:
1188: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1189: PA_ASSIGNMENT_UTILS.Add_Message(
1190: p_app_short_name => 'PA'
1191: ,p_msg_name => l_error_message_code
1192: );
1193: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1200:
1201: --Check that start_date <= end_date
1202: --
1203: IF l_assignment_rec.start_date > l_assignment_rec.end_date THEN
1204: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1205: ,p_msg_name => 'PA_INVALID_START_DATE');
1206: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1207: END IF;
1208:
1240: END IF;
1241: -- Bug: 4537865
1242:
1243: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1244: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1245: ,p_msg_name => l_error_message_code);
1246: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1247: l_assignment_rec.resource_id := NULL;
1248: END IF;
1291: ,x_status_code => l_assignment_rec.status_code
1292: ,x_return_status => l_return_status
1293: ,x_error_message_code => l_error_message_code);
1294: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1295: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1296: , p_msg_name => l_error_message_code);
1297: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1298: END IF;
1299: l_return_status := FND_API.G_MISS_CHAR;
1401: END IF;
1402: -- Bug: 4537865
1403:
1404: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1405: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1406: , p_msg_name => l_error_message_code );
1407: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1408: END IF;
1409: l_return_status := FND_API.G_MISS_CHAR;
1426: ,x_country_code => l_location_country_code
1427: ,x_return_status => l_return_status
1428: ,x_error_message_code => l_error_message_code );
1429: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1430: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1431: ,p_msg_name => l_error_message_code );
1432: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1433: END IF;
1434: l_return_status := FND_API.G_MISS_CHAR;
1435: l_error_message_code := FND_API.G_MISS_CHAR;
1436: -- if country is not passed in, but region/city is passed in, give an error.
1437: ELSIF (p_location_city IS NOT NULL AND p_location_city <> FND_API.G_MISS_CHAR) OR
1438: (p_location_region IS NOT NULL AND p_location_region <> FND_API.G_MISS_CHAR) THEN
1439: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1440: ,p_msg_name => 'PA_COUNTRY_INVALID');
1441: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1442: END IF;
1443:
1453: ,x_valid => l_valid_flag
1454: ,x_return_status => l_return_status
1455: ,x_error_message_code => l_error_message_code );
1456: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1457: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1458: ,p_msg_name => l_error_message_code );
1459: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1460: END IF;
1461: l_return_status := FND_API.G_MISS_CHAR;
1466: ,x_valid => l_valid_flag
1467: ,x_return_status => l_return_status
1468: ,x_error_message_code => l_error_message_code );
1469: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1470: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1471: ,p_msg_name => l_error_message_code );
1472: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1473: END IF;
1474: l_return_status := FND_API.G_MISS_CHAR;
1476:
1477: -- Check that max job level is >= min job level
1478: --
1479: IF l_assignment_rec.min_resource_job_level > l_assignment_rec.max_resource_job_level THEN
1480: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1481: ,p_msg_name => 'PA_MIN_JL_GREATER_THAN_MAX');
1482: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1483: END IF;
1484:
1488:
1489: IF p_number_of_requirements - ROUND(p_number_of_requirements) <> 0
1490: OR p_number_of_requirements < 1 THEN
1491:
1492: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1493: ,p_msg_name => 'PA_INVALID_REQ_COPIES_NO' );
1494: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1495: END IF;
1496:
1532: ,x_return_status => l_return_status
1533: ,x_error_message_code => l_error_message_code );
1534: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1535:
1536: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1537: ,p_msg_name => l_error_message_code );
1538: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1539: END IF;
1540: l_return_status := FND_API.G_MISS_CHAR;
1550:
1551: /* Bug 2887390 : Added the following condition */
1552: IF (l_assignment_rec.calendar_type = 'PROJECT' AND l_assignment_rec.calendar_id is NULL)
1553: THEN
1554: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1555: ,p_msg_name => 'PA_INVALID_CAL_PROJ_SETUP' );
1556:
1557: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1558: END IF;
1601: -- Bug:4537865
1602:
1603: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1604:
1605: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1606: ,p_msg_name => l_error_message_code );
1607: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1608:
1609:
1637:
1638:
1639:
1640: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1641: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1642: ,p_msg_name => l_error_message_code );
1643: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1644: END IF;
1645: l_return_status := FND_API.G_MISS_CHAR;
1658: ,x_return_status => l_return_status
1659: ,x_error_message_code => l_error_message_code);
1660:
1661: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1662: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1663: ,p_msg_name => l_error_message_code );
1664: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1665: END IF;
1666: l_return_status := FND_API.G_MISS_CHAR;
1683: ,x_sys_link_func => l_assignment_rec.expenditure_type_class
1684: ,x_return_status => l_return_status
1685: ,x_error_message_code=> l_error_message_code) ;
1686: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1687: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1688: ,p_msg_name => l_error_message_code );
1689: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1690: END IF;
1691: l_return_status := FND_API.G_MISS_CHAR;
1698: OPEN get_expenditure_type_class;
1699: FETCH get_expenditure_type_class INTO l_assignment_rec.expenditure_type_class;
1700:
1701: IF get_expenditure_type_class%NOTFOUND THEN
1702: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1703: ,p_msg_name => 'PA_EXPTYPE_INVALID' );
1704: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1705: END IF;
1706: CLOSE get_expenditure_type_class;
1722: -- 5130421 : We shd check both l_return_status and also l_valid_flag
1723: -- This is because of a bug in Check_Exp_Type_Sys_Link_Combo code
1724: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1725: IF l_valid_flag <> 'Y' THEN
1726: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1727: ,p_msg_name => 'PA_EXPTYPE_SYSLINK_INVALID' );
1728: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1729: END IF;
1730: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1727: ,p_msg_name => 'PA_EXPTYPE_SYSLINK_INVALID' );
1728: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1729: END IF;
1730: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1731: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1732: ,p_msg_name => l_error_message_code );
1733: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1734: END IF;
1735: l_return_status := FND_API.G_MISS_CHAR;
1737: END IF; -- end of checking expenditure type and expenditure type class
1738:
1739: -- Bug 5130421 : Validate expense limit to be positive
1740: IF (l_assignment_rec.expense_limit < 0) THEN
1741: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1742: ,p_msg_name => 'PA_EXPENSE_LIMIT_INVALID' );
1743: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1744: END IF;
1745: -- End Bug 5130421
1749: IF (l_assignment_rec.staffing_priority_code IS NOT NULL AND
1750: l_assignment_rec.staffing_priority_code <> FND_API.G_MISS_CHAR) OR
1751: (p_staffing_priority_name IS NOT NULL AND p_staffing_priority_name <> FND_API.G_MISS_CHAR) THEN
1752:
1753: PA_ASSIGNMENT_UTILS.Check_STF_PriorityName_Or_Code (p_staffing_priority_code => l_assignment_rec.staffing_priority_code
1754: ,p_staffing_priority_name => p_staffing_priority_name
1755: ,p_check_id_flag => PA_STARTUP.G_Check_ID_Flag
1756: --,x_staffing_priority_code => l_assignment_rec.staffing_priority_code Bug:4537865
1757: ,x_staffing_priority_code => l_new_staffing_priority_code --Bug:4537865
1762: l_assignment_rec.staffing_priority_code := l_new_staffing_priority_code;
1763: END IF;
1764: -- Bug: 4537865
1765: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1766: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1767: ,p_msg_name => l_error_message_code );
1768: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1769: END IF;
1770: l_return_status := FND_API.G_MISS_CHAR;
1789: ,x_error_message_code => l_error_message_code
1790: );
1791:
1792: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1793: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1794: ,p_msg_name => l_error_message_code );
1795: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1796: END IF;
1797: l_return_status := FND_API.G_MISS_CHAR;
1887:
1888: ELSE -- IF ( l_valid_assign_start_flag = 'Y' )
1889: -- l_profile_begin_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY'); /* commenting for For Bug 7304151 */
1890: l_profile_begin_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY', 'NLS_DATE_LANGUAGE=AMERICAN'); /*Adding For Bug 7304151 */
1891: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1892: ,p_msg_name => 'PA_INVALID_ASSIGN_START_DATE'
1893: ,p_token1 => 'PROFILE_DATE'
1894: ,p_value1 => l_profile_begin_date );
1895: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2372: FETCH check_record_version INTO l_assignment_rec.assignment_row_id;
2373:
2374: IF l_mass_wf_in_progress_flag = 'Y' THEN
2375:
2376: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
2377: ,p_msg_name => 'PA_ASSIGNMENT_WF');
2378: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2379:
2380: ELSIF check_record_version%NOTFOUND THEN
3343: if ((p_bill_rate_override <> FND_API.G_MISS_NUM AND p_bill_rate_override IS NOT NULL)
3344: OR (p_discount_percentage <> FND_API.G_MISS_NUM AND p_discount_percentage IS NOT NULL))
3345: then
3346: if (p_rate_disc_reason_code IS NULL OR p_rate_disc_reason_code = FND_API.G_MISS_CHAR) then
3347: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
3348: ,p_msg_name => 'PA_RATE_DISC_REASON_REQUIRED');
3349: --PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
3350: x_return_status := FND_API.G_RET_STS_ERROR;
3351:
4524: CLOSE check_team_template_wf;
4525:
4526: IF l_workflow_in_progress_flag='Y' THEN
4527:
4528: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
4529: ,p_msg_name => 'PA_NO_REQ_WF');
4530: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4531: x_return_status := FND_API.G_RET_STS_ERROR;
4532: END IF;
4546: FETCH check_project_assignment_wf INTO l_mass_wf_in_progress_flag;
4547: CLOSE check_project_assignment_wf;
4548:
4549: IF l_mass_wf_in_progress_flag = 'Y' THEN
4550: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
4551: ,p_msg_name => 'PA_ASSIGNMENT_WF');
4552: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4553: x_return_status := FND_API.G_RET_STS_ERROR;
4554: END IF;
4565: IF l_project_system_status_code = 'OPEN_ASGMT_FILLED' OR
4566: l_project_system_status_code = 'OPEN_ASGMT_CANCEL' OR
4567: l_project_system_status_code = 'STAFFED_ASGMT_CANCEL' THEN
4568:
4569: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
4570: ,p_msg_name => 'PA_UPDATE_CAN_FILL_ASMT');
4571: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4572: x_return_status := FND_API.G_RET_STS_ERROR;
4573: END IF;
4742:
4743: /* Bug 2887390 : Added the following condition */
4744: IF (l_assignment_rec.calendar_type = 'PROJECT' AND l_assignment_rec.calendar_id is NULL)
4745: THEN
4746: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
4747: ,p_msg_name => 'PA_INVALID_CAL_PROJ_SETUP' );
4748: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4749: END IF;
4750: IF (l_calendar_name <> FND_API.G_MISS_CHAR AND l_calendar_name IS NOT NULL) OR
5391: IF (l_assignment_rec.staffing_priority_code IS NOT NULL AND
5392: l_assignment_rec.staffing_priority_code <> FND_API.G_MISS_CHAR) OR
5393: (p_staffing_priority_name IS NOT NULL AND p_staffing_priority_name <> FND_API.G_MISS_CHAR) THEN
5394:
5395: PA_ASSIGNMENT_UTILS.Check_STF_PriorityName_Or_Code (p_staffing_priority_code => l_assignment_rec.staffing_priority_code
5396: ,p_staffing_priority_name => p_staffing_priority_name
5397: ,p_check_id_flag => PA_STARTUP.G_Check_ID_Flag
5398: --,x_staffing_priority_code => l_assignment_rec.staffing_priority_code Bug: 4537865
5399: ,x_staffing_priority_code => l_new_staffing_priority_code -- Bug: 4537865
5510: -- 5130421 : We shd check both l_return_status and also l_valid_flag
5511: -- This is because of a bug in Check_Exp_Type_Sys_Link_Combo code
5512: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5513: IF l_valid_flag <> 'Y' THEN
5514: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
5515: ,p_msg_name => 'PA_EXPTYPE_SYSLINK_INVALID' );
5516: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5517: END IF;
5518: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5515: ,p_msg_name => 'PA_EXPTYPE_SYSLINK_INVALID' );
5516: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5517: END IF;
5518: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5519: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
5520: ,p_msg_name => l_error_message_code );
5521: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5522: END IF;
5523: l_return_status := FND_API.G_MISS_CHAR;
5992:
5993: --dbms_output.put_line('mass_wf_in_progress_flag='||l_mass_wf_in_progress_flag);
5994:
5995: IF l_mass_wf_in_progress_flag = 'Y' THEN
5996: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
5997: ,p_msg_name => 'PA_ASSIGNMENT_WF');
5998: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5999: x_return_status := FND_API.G_RET_STS_ERROR;
6000:
6298: FND_PROFILE.Get('PA_START_OPEN_ASGMT_STATUS',l_assignment_rec.status_code);
6299:
6300: IF l_assignment_rec.status_code IS NULL THEN
6301:
6302: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
6303: ,p_msg_name => 'PA_START_STATUS_NOT_DEFINED');
6304: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
6305:
6306: END IF;
6484:
6485: IF (p_assignment_type = 'OPEN_ASSIGNMENT') THEN
6486: FND_PROFILE.Get('PA_START_OPEN_ASGMT_STATUS',l_status_code);
6487: IF l_status_code IS NULL THEN
6488: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
6489: ,p_msg_name => 'PA_START_STATUS_NOT_DEFINED');
6490: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
6491: END IF;
6492: END IF;
6493:
6494: IF (p_assignment_type = 'STAFFED_ASSIGNMENT' OR p_assignment_type = 'STAFFED_ADMIN_ASSIGNMENT') THEN
6495: FND_PROFILE.Get('PA_START_STAFFED_ASGMT_STATUS',l_status_code);
6496: IF l_status_code IS NULL THEN
6497: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
6498: ,p_msg_name => 'PA_START_STATUS_NOT_DEFINED');
6499: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
6500: END IF;
6501: END IF;
6772:
6773:
6774: -- Default Staffing Owner for the assignments
6775: IF p_assignment_type = 'STAFFED_ASSIGNMENT' THEN
6776: pa_assignment_utils.Get_Default_Staffing_Owner
6777: ( p_project_id => p_project_id
6778: ,p_exp_org_id => p_expenditure_org_id
6779: ,x_person_id => l_staffing_owner_person_id
6780: ,x_person_name => l_staffing_owner_name