[Home] [Help]
168:
169: IF p_assignment_type = 'OPEN_ASSIGNMENT' THEN
170: FND_PROFILE.Get('PA_START_OPEN_ASGMT_STATUS',l_assignment_rec.status_code);
171: IF l_assignment_rec.status_code IS NULL THEN
172: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
173: ,p_msg_name => 'PA_START_STATUS_NOT_DEFINED');
174: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
175: END IF;
176: END IF;
177:
178: IF (p_assignment_type = 'STAFFED_ASSIGNMENT' OR p_assignment_type = 'STAFFED_ADMIN_ASSIGNMENT') THEN
179: FND_PROFILE.Get('PA_START_STAFFED_ASGMT_STATUS',l_assignment_rec.status_code);
180: IF l_assignment_rec.status_code IS NULL THEN
181: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
182: ,p_msg_name => 'PA_START_STATUS_NOT_DEFINED');
183: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
184: END IF;
185: END IF;
305: -- OR l_assignment_rec.staffing_owner_person_id IS NULL
306:
307: THEN
308:
309: pa_assignment_utils.Get_Default_Staffing_Owner
310: ( p_project_id => l_assignment_rec.project_id
311: ,p_exp_org_id => null
312: ,x_person_id => l_assignment_rec.staffing_owner_person_id
313: ,x_person_name => l_person_name
477: l_assignment_rec.end_date := p_end_date;
478:
479:
480: -- Retrieve default staffing owner person id
481: pa_assignment_utils.Get_Default_Staffing_Owner
482: ( p_project_id => p_project_id
483: ,p_exp_org_id => null
484: ,x_person_id => l_assignment_rec.staffing_owner_person_id
485: ,x_person_name => l_person_name
756: END IF;
757:
758: -- Bug 3466411
759: -- Retrieve default staffing owner person id
760: pa_assignment_utils.Get_Default_Staffing_Owner
761: ( p_project_id => l_assignment_rec.project_id
762: ,p_exp_org_id => null
763: ,x_person_id => l_assignment_rec.staffing_owner_person_id
764: ,x_person_name => l_person_name
1021: FETCH check_team_template_wf INTO l_workflow_in_progress_flag;
1022: CLOSE check_team_template_wf;
1023:
1024: IF l_workflow_in_progress_flag='Y' THEN
1025: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1026: ,p_msg_name => 'PA_NO_REQ_WF');
1027: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1028: x_return_status := FND_API.G_RET_STS_ERROR;
1029: END IF;
1066:
1067: --dbms_output.put_line('error_message_code :'||l_error_message_code);
1068:
1069: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1070: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1071: ,p_msg_name => l_error_message_code);
1072: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1073: END IF;
1074: l_return_status := FND_API.G_MISS_CHAR;
1103: --
1104: IF (l_assignment_rec.assignment_type = 'STAFFED_ADMIN_ASSIGNMENT' AND
1105: l_admin_flag <> 'Y') OR
1106: (l_assignment_rec.assignment_type = 'STAFFED_ASSIGNMENT' AND l_admin_flag = 'Y') THEN
1107: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1108: ,p_msg_name => 'PA_CREATE_ADMIN_RESTRICT');
1109: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1110: END IF; --staffed admin or staffed assignment with admin project
1111:
1137: IF l_unassigned_time IS NULL THEN
1138: l_unassigned_time := PA_PROJECT_UTILS.is_unassigned_time_project(l_assignment_rec.project_id);
1139: END IF;
1140: IF l_unassigned_time = 'Y' THEN
1141: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1142: ,p_msg_name => 'PA_NO_ASGMT_UNASSIGN_TIME_PROJ');
1143: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1144: END IF;
1145:
1150: x_err_code => l_error_message_code
1151: );
1152:
1153: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1154: PA_ASSIGNMENT_UTILS.Add_Message(
1155: p_app_short_name => 'PA'
1156: ,p_msg_name => l_error_message_code
1157: );
1158: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1165:
1166: --Check that start_date <= end_date
1167: --
1168: IF l_assignment_rec.start_date > l_assignment_rec.end_date THEN
1169: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1170: ,p_msg_name => 'PA_INVALID_START_DATE');
1171: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1172: END IF;
1173:
1205: END IF;
1206: -- Bug: 4537865
1207:
1208: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1209: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1210: ,p_msg_name => l_error_message_code);
1211: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1212: l_assignment_rec.resource_id := NULL;
1213: END IF;
1256: ,x_status_code => l_assignment_rec.status_code
1257: ,x_return_status => l_return_status
1258: ,x_error_message_code => l_error_message_code);
1259: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1260: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1261: , p_msg_name => l_error_message_code);
1262: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1263: END IF;
1264: l_return_status := FND_API.G_MISS_CHAR;
1366: END IF;
1367: -- Bug: 4537865
1368:
1369: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1370: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1371: , p_msg_name => l_error_message_code );
1372: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1373: END IF;
1374: l_return_status := FND_API.G_MISS_CHAR;
1391: ,x_country_code => l_location_country_code
1392: ,x_return_status => l_return_status
1393: ,x_error_message_code => l_error_message_code );
1394: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1395: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1396: ,p_msg_name => l_error_message_code );
1397: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1398: END IF;
1399: l_return_status := FND_API.G_MISS_CHAR;
1400: l_error_message_code := FND_API.G_MISS_CHAR;
1401: -- if country is not passed in, but region/city is passed in, give an error.
1402: ELSIF (p_location_city IS NOT NULL AND p_location_city <> FND_API.G_MISS_CHAR) OR
1403: (p_location_region IS NOT NULL AND p_location_region <> FND_API.G_MISS_CHAR) THEN
1404: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1405: ,p_msg_name => 'PA_COUNTRY_INVALID');
1406: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1407: END IF;
1408:
1418: ,x_valid => l_valid_flag
1419: ,x_return_status => l_return_status
1420: ,x_error_message_code => l_error_message_code );
1421: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1422: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1423: ,p_msg_name => l_error_message_code );
1424: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1425: END IF;
1426: l_return_status := FND_API.G_MISS_CHAR;
1431: ,x_valid => l_valid_flag
1432: ,x_return_status => l_return_status
1433: ,x_error_message_code => l_error_message_code );
1434: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1435: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1436: ,p_msg_name => l_error_message_code );
1437: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1438: END IF;
1439: l_return_status := FND_API.G_MISS_CHAR;
1441:
1442: -- Check that max job level is >= min job level
1443: --
1444: IF l_assignment_rec.min_resource_job_level > l_assignment_rec.max_resource_job_level THEN
1445: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1446: ,p_msg_name => 'PA_MIN_JL_GREATER_THAN_MAX');
1447: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1448: END IF;
1449:
1453:
1454: IF p_number_of_requirements - ROUND(p_number_of_requirements) <> 0
1455: OR p_number_of_requirements < 1 THEN
1456:
1457: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1458: ,p_msg_name => 'PA_INVALID_REQ_COPIES_NO' );
1459: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1460: END IF;
1461:
1497: ,x_return_status => l_return_status
1498: ,x_error_message_code => l_error_message_code );
1499: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1500:
1501: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1502: ,p_msg_name => l_error_message_code );
1503: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1504: END IF;
1505: l_return_status := FND_API.G_MISS_CHAR;
1515:
1516: /* Bug 2887390 : Added the following condition */
1517: IF (l_assignment_rec.calendar_type = 'PROJECT' AND l_assignment_rec.calendar_id is NULL)
1518: THEN
1519: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1520: ,p_msg_name => 'PA_INVALID_CAL_PROJ_SETUP' );
1521:
1522: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1523: END IF;
1554: END IF;
1555: -- Bug:4537865
1556:
1557: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1558: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1559: ,p_msg_name => l_error_message_code );
1560: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1561: END IF;
1562: l_return_status := FND_API.G_MISS_CHAR;
1588:
1589:
1590:
1591: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1592: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1593: ,p_msg_name => l_error_message_code );
1594: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1595: END IF;
1596: l_return_status := FND_API.G_MISS_CHAR;
1609: ,x_return_status => l_return_status
1610: ,x_error_message_code => l_error_message_code);
1611:
1612: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1613: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1614: ,p_msg_name => l_error_message_code );
1615: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1616: END IF;
1617: l_return_status := FND_API.G_MISS_CHAR;
1634: ,x_sys_link_func => l_assignment_rec.expenditure_type_class
1635: ,x_return_status => l_return_status
1636: ,x_error_message_code=> l_error_message_code) ;
1637: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1638: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1639: ,p_msg_name => l_error_message_code );
1640: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1641: END IF;
1642: l_return_status := FND_API.G_MISS_CHAR;
1649: OPEN get_expenditure_type_class;
1650: FETCH get_expenditure_type_class INTO l_assignment_rec.expenditure_type_class;
1651:
1652: IF get_expenditure_type_class%NOTFOUND THEN
1653: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1654: ,p_msg_name => 'PA_EXPTYPE_INVALID' );
1655: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1656: END IF;
1657: CLOSE get_expenditure_type_class;
1673: -- 5130421 : We shd check both l_return_status and also l_valid_flag
1674: -- This is because of a bug in Check_Exp_Type_Sys_Link_Combo code
1675: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1676: IF l_valid_flag <> 'Y' THEN
1677: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1678: ,p_msg_name => 'PA_EXPTYPE_SYSLINK_INVALID' );
1679: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1680: END IF;
1681: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1678: ,p_msg_name => 'PA_EXPTYPE_SYSLINK_INVALID' );
1679: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1680: END IF;
1681: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1682: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1683: ,p_msg_name => l_error_message_code );
1684: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1685: END IF;
1686: l_return_status := FND_API.G_MISS_CHAR;
1688: END IF; -- end of checking expenditure type and expenditure type class
1689:
1690: -- Bug 5130421 : Validate expense limit to be positive
1691: IF (l_assignment_rec.expense_limit < 0) THEN
1692: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1693: ,p_msg_name => 'PA_EXPENSE_LIMIT_INVALID' );
1694: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1695: END IF;
1696: -- End Bug 5130421
1700: IF (l_assignment_rec.staffing_priority_code IS NOT NULL AND
1701: l_assignment_rec.staffing_priority_code <> FND_API.G_MISS_CHAR) OR
1702: (p_staffing_priority_name IS NOT NULL AND p_staffing_priority_name <> FND_API.G_MISS_CHAR) THEN
1703:
1704: PA_ASSIGNMENT_UTILS.Check_STF_PriorityName_Or_Code (p_staffing_priority_code => l_assignment_rec.staffing_priority_code
1705: ,p_staffing_priority_name => p_staffing_priority_name
1706: ,p_check_id_flag => PA_STARTUP.G_Check_ID_Flag
1707: --,x_staffing_priority_code => l_assignment_rec.staffing_priority_code Bug:4537865
1708: ,x_staffing_priority_code => l_new_staffing_priority_code --Bug:4537865
1713: l_assignment_rec.staffing_priority_code := l_new_staffing_priority_code;
1714: END IF;
1715: -- Bug: 4537865
1716: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1717: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1718: ,p_msg_name => l_error_message_code );
1719: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1720: END IF;
1721: l_return_status := FND_API.G_MISS_CHAR;
1740: ,x_error_message_code => l_error_message_code
1741: );
1742:
1743: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1744: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
1745: ,p_msg_name => l_error_message_code );
1746: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1747: END IF;
1748: l_return_status := FND_API.G_MISS_CHAR;
1838:
1839: ELSE -- IF ( l_valid_assign_start_flag = 'Y' )
1840: -- l_profile_begin_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY'); /* commenting for For Bug 7304151 */
1841: l_profile_begin_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY', 'NLS_DATE_LANGUAGE=AMERICAN'); /*Adding For Bug 7304151 */
1842: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1843: ,p_msg_name => 'PA_INVALID_ASSIGN_START_DATE'
1844: ,p_token1 => 'PROFILE_DATE'
1845: ,p_value1 => l_profile_begin_date );
1846: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2307: FETCH check_record_version INTO l_assignment_rec.assignment_row_id;
2308:
2309: IF l_mass_wf_in_progress_flag = 'Y' THEN
2310:
2311: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
2312: ,p_msg_name => 'PA_ASSIGNMENT_WF');
2313: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2314:
2315: ELSIF check_record_version%NOTFOUND THEN
3259: if ((p_bill_rate_override <> FND_API.G_MISS_NUM AND p_bill_rate_override IS NOT NULL)
3260: OR (p_discount_percentage <> FND_API.G_MISS_NUM AND p_discount_percentage IS NOT NULL))
3261: then
3262: if (p_rate_disc_reason_code IS NULL OR p_rate_disc_reason_code = FND_API.G_MISS_CHAR) then
3263: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
3264: ,p_msg_name => 'PA_RATE_DISC_REASON_REQUIRED');
3265: --PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
3266: x_return_status := FND_API.G_RET_STS_ERROR;
3267:
3598: FETCH check_team_template_wf INTO l_workflow_in_progress_flag;
3599: CLOSE check_team_template_wf;
3600:
3601: IF l_workflow_in_progress_flag='Y' THEN
3602: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
3603: ,p_msg_name => 'PA_NO_REQ_WF');
3604: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
3605: x_return_status := FND_API.G_RET_STS_ERROR;
3606: END IF;
3619: FETCH check_project_assignment_wf INTO l_mass_wf_in_progress_flag;
3620: CLOSE check_project_assignment_wf;
3621:
3622: IF l_mass_wf_in_progress_flag = 'Y' THEN
3623: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
3624: ,p_msg_name => 'PA_ASSIGNMENT_WF');
3625: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
3626: x_return_status := FND_API.G_RET_STS_ERROR;
3627: END IF;
3640: IF l_project_system_status_code = 'OPEN_ASGMT_FILLED' OR
3641: l_project_system_status_code = 'OPEN_ASGMT_CANCEL' OR
3642: l_project_system_status_code = 'STAFFED_ASGMT_CANCEL' THEN
3643:
3644: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
3645: ,p_msg_name => 'PA_UPDATE_CAN_FILL_ASMT');
3646: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
3647: x_return_status := FND_API.G_RET_STS_ERROR;
3648: END IF;
3798:
3799: /* Bug 2887390 : Added the following condition */
3800: IF (l_assignment_rec.calendar_type = 'PROJECT' AND l_assignment_rec.calendar_id is NULL)
3801: THEN
3802: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
3803: ,p_msg_name => 'PA_INVALID_CAL_PROJ_SETUP' );
3804:
3805: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
3806: END IF;
4422: IF (l_assignment_rec.staffing_priority_code IS NOT NULL AND
4423: l_assignment_rec.staffing_priority_code <> FND_API.G_MISS_CHAR) OR
4424: (p_staffing_priority_name IS NOT NULL AND p_staffing_priority_name <> FND_API.G_MISS_CHAR) THEN
4425:
4426: PA_ASSIGNMENT_UTILS.Check_STF_PriorityName_Or_Code (p_staffing_priority_code => l_assignment_rec.staffing_priority_code
4427: ,p_staffing_priority_name => p_staffing_priority_name
4428: ,p_check_id_flag => PA_STARTUP.G_Check_ID_Flag
4429: --,x_staffing_priority_code => l_assignment_rec.staffing_priority_code Bug: 4537865
4430: ,x_staffing_priority_code => l_new_staffing_priority_code -- Bug: 4537865
4537: -- 5130421 : We shd check both l_return_status and also l_valid_flag
4538: -- This is because of a bug in Check_Exp_Type_Sys_Link_Combo code
4539: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4540: IF l_valid_flag <> 'Y' THEN
4541: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
4542: ,p_msg_name => 'PA_EXPTYPE_SYSLINK_INVALID' );
4543: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4544: END IF;
4545: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4542: ,p_msg_name => 'PA_EXPTYPE_SYSLINK_INVALID' );
4543: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4544: END IF;
4545: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4546: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
4547: ,p_msg_name => l_error_message_code );
4548: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4549: END IF;
4550: l_return_status := FND_API.G_MISS_CHAR;
5016:
5017: --dbms_output.put_line('mass_wf_in_progress_flag='||l_mass_wf_in_progress_flag);
5018:
5019: IF l_mass_wf_in_progress_flag = 'Y' THEN
5020: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
5021: ,p_msg_name => 'PA_ASSIGNMENT_WF');
5022: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5023: x_return_status := FND_API.G_RET_STS_ERROR;
5024:
5322: FND_PROFILE.Get('PA_START_OPEN_ASGMT_STATUS',l_assignment_rec.status_code);
5323:
5324: IF l_assignment_rec.status_code IS NULL THEN
5325:
5326: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
5327: ,p_msg_name => 'PA_START_STATUS_NOT_DEFINED');
5328: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5329:
5330: END IF;
5508:
5509: IF (p_assignment_type = 'OPEN_ASSIGNMENT') THEN
5510: FND_PROFILE.Get('PA_START_OPEN_ASGMT_STATUS',l_status_code);
5511: IF l_status_code IS NULL THEN
5512: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
5513: ,p_msg_name => 'PA_START_STATUS_NOT_DEFINED');
5514: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5515: END IF;
5516: END IF;
5517:
5518: IF (p_assignment_type = 'STAFFED_ASSIGNMENT' OR p_assignment_type = 'STAFFED_ADMIN_ASSIGNMENT') THEN
5519: FND_PROFILE.Get('PA_START_STAFFED_ASGMT_STATUS',l_status_code);
5520: IF l_status_code IS NULL THEN
5521: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
5522: ,p_msg_name => 'PA_START_STATUS_NOT_DEFINED');
5523: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5524: END IF;
5525: END IF;
5796:
5797:
5798: -- Default Staffing Owner for the assignments
5799: IF p_assignment_type = 'STAFFED_ASSIGNMENT' THEN
5800: pa_assignment_utils.Get_Default_Staffing_Owner
5801: ( p_project_id => p_project_id
5802: ,p_exp_org_id => p_expenditure_org_id
5803: ,x_person_id => l_staffing_owner_person_id
5804: ,x_person_name => l_staffing_owner_name