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.PA_STAFFED_ASSIGNMENT_PVT dependencies on FND_API

Line 10: ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR

6:
7: PROCEDURE Create_Staffed_Assignment
8: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
9: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
10: ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
12: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
13: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

Line 11: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM

7: PROCEDURE Create_Staffed_Assignment
8: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
9: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
10: ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
12: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
13: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
15: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development

Line 12: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

8: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
9: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
10: ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
12: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
13: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
15: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
16: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM

Line 13: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

9: ,p_asgn_creation_mode IN VARCHAR2 := 'FULL'
10: ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
12: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
13: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
15: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
16: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
17: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 14: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

10: ,p_unfilled_assignment_status IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
11: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
12: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
13: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
15: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
16: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
17: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
18: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 15: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development

11: ,p_resource_source_id IN NUMBER := FND_API.G_MISS_NUM
12: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
13: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
15: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
16: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
17: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
18: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
19: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895

Line 16: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM

12: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
13: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
15: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
16: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
17: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
18: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
19: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
20: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895

Line 17: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

13: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
14: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
15: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
16: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
17: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
18: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
19: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
20: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
21: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895

Line 18: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

14: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
15: ,p_sum_tasks_flag IN VARCHAR2 := FND_API.G_FALSE -- FP.M Development
16: ,p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE := FND_API.G_MISS_NUM
17: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
18: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
19: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
20: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
21: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
22: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 57: l_project_parties_error_exists VARCHAR2(1) := FND_API.G_FALSE;

53: l_asgn_text VARCHAR2(30);
54: l_allow_asgmt VARCHAR2(1);
55: l_work_type_id NUMBER;
56: l_raw_revenue NUMBER;
57: l_project_parties_error_exists VARCHAR2(1) := FND_API.G_FALSE;
58: l_check_resource VARCHAR2(1);
59: l_proj_asgmt_res_format_id NUMBER;
60: l_person_id NUMBER;
61: l_task_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 176: x_return_status := FND_API.G_RET_STS_SUCCESS ;

172:
173: BEGIN
174:
175: -- 4537865 : Initialize the return_status
176: x_return_status := FND_API.G_RET_STS_SUCCESS ;
177:
178: -- Initialize the Error Stack
179: PA_DEBUG.set_err_stack('PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment');
180: --dbms_output.put_line('create staffed assignment');

Line 206: IF (l_assignment_rec.project_id IS NULL OR l_assignment_rec.project_id = FND_API.G_MISS_NUM) THEN

202: --
203: --
204: -- Check that mandatory project id exists
205: --
206: IF (l_assignment_rec.project_id IS NULL OR l_assignment_rec.project_id = FND_API.G_MISS_NUM) THEN
207: PA_UTILS.Add_Message( p_app_short_name => 'PA'
208: ,p_msg_name => 'PA_PROJ_ID_REQUIRED_FOR_ASGN'
209: ,p_token1 => 'ASGNTYPE'
210: ,p_value1 => l_asgn_text);

Line 211: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

207: PA_UTILS.Add_Message( p_app_short_name => 'PA'
208: ,p_msg_name => 'PA_PROJ_ID_REQUIRED_FOR_ASGN'
209: ,p_token1 => 'ASGNTYPE'
210: ,p_value1 => l_asgn_text);
211: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
212: RETURN;
213: END IF;
214:
215: --

Line 219: l_assignment_rec.assignment_name = FND_API.G_MISS_CHAR THEN

215: --
216: -- Check that mandatory assignment name exists
217: --
218: IF l_assignment_rec.assignment_name IS NULL OR
219: l_assignment_rec.assignment_name = FND_API.G_MISS_CHAR THEN
220: PA_UTILS.Add_Message( p_app_short_name => 'PA'
221: ,p_msg_name => 'PA_NAME_REQUIRED_FOR_ASGN');
222: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
223: END IF;

Line 222: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

218: IF l_assignment_rec.assignment_name IS NULL OR
219: l_assignment_rec.assignment_name = FND_API.G_MISS_CHAR THEN
220: PA_UTILS.Add_Message( p_app_short_name => 'PA'
221: ,p_msg_name => 'PA_NAME_REQUIRED_FOR_ASGN');
222: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
223: END IF;
224:
225: --
226: -- Check that mandatory project role exists

Line 229: OR l_assignment_rec.project_role_id = FND_API.G_MISS_NUM THEN

225: --
226: -- Check that mandatory project role exists
227: --
228: IF l_assignment_rec.project_role_id IS NULL
229: OR l_assignment_rec.project_role_id = FND_API.G_MISS_NUM THEN
230: PA_UTILS.Add_Message( p_app_short_name => 'PA'
231: ,p_msg_name => 'PA_PROJ_ROLE_REQUIRED_FOR_ASGN'
232: ,p_token1 => 'ASGNTYPE'
233: ,p_value1 => l_asgn_text);

Line 234: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

230: PA_UTILS.Add_Message( p_app_short_name => 'PA'
231: ,p_msg_name => 'PA_PROJ_ROLE_REQUIRED_FOR_ASGN'
232: ,p_token1 => 'ASGNTYPE'
233: ,p_value1 => l_asgn_text);
234: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
235: END IF;
236:
237: --
238: --Check p_work_type_id IS NOT NULL

Line 241: OR l_assignment_rec.work_type_id = FND_API.G_MISS_NUM

237: --
238: --Check p_work_type_id IS NOT NULL
239: --
240: IF l_assignment_rec.work_type_id IS NULL
241: OR l_assignment_rec.work_type_id = FND_API.G_MISS_NUM
242: OR l_assignment_rec.work_type_id = 0 THEN
243:
244: PA_UTILS.Add_Message( p_app_short_name => 'PA'
245: ,p_msg_name => 'PA_WORK_TYPE_REQUIRED_FOR_ASGN' );

Line 246: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

242: OR l_assignment_rec.work_type_id = 0 THEN
243:
244: PA_UTILS.Add_Message( p_app_short_name => 'PA'
245: ,p_msg_name => 'PA_WORK_TYPE_REQUIRED_FOR_ASGN' );
246: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
247:
248: ELSE
249: --
250: --check for indirect project, only non-billable work types

Line 258: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

254: ,P_PROJECT_ID => l_assignment_rec.project_id
255: ,P_TASK_ID => NULL
256: ,X_RETURN_STATUS => l_return_status
257: ,X_ERROR_MESSAGE_CODE => l_error_message_code);
258: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
259: PA_UTILS.Add_Message( p_app_short_name => 'PA'
260: ,p_msg_name => l_error_message_code );
261: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
262: END IF;

Line 261: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

257: ,X_ERROR_MESSAGE_CODE => l_error_message_code);
258: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
259: PA_UTILS.Add_Message( p_app_short_name => 'PA'
260: ,p_msg_name => l_error_message_code );
261: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
262: END IF;
263:
264: END IF;
265:

Line 274: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

270: PA_UTILS.Add_Message( p_app_short_name => 'PA'
271: ,p_msg_name => 'PA_INVALID_ASGN_STARTING_STUS'
272: ,p_token1 => 'ASGNTYPE'
273: ,p_value1 => l_asgn_text);
274: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
275: END IF;
276:
277: -- Check Action allowed status (check that it is allowed to have a staffed assignment for a project or open assignment)
278:

Line 288: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

284: p_project_id => l_assignment_rec.project_id,
285: p_add_message => 'Y');
286:
287: IF l_allow_asgmt = 'N' THEN
288: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
289: RETURN; -- Fix for bug#9033815
290: END IF; --l_allow_asgmt := 'N'
291:
292: END IF; --p_assignment_rec.project_id is NOT NULL

Line 301: IF (l_assignment_rec.location_id IS NULL OR l_assignment_rec.location_id = FND_API.G_MISS_NUM)

297: -- If all the location input parameters are null then default location from project
298: -- If location details are passed then get the location id for the for the given location parameters
299: -- If the location does not already exist then create it
300: --
301: IF (l_assignment_rec.location_id IS NULL OR l_assignment_rec.location_id = FND_API.G_MISS_NUM)
302: AND (p_location_city IS NULL OR p_location_city = FND_API.G_MISS_CHAR)
303: AND (p_location_region IS NULL OR p_location_region = FND_API.G_MISS_CHAR)
304: AND (p_location_country_code IS NULL OR p_location_country_code = FND_API.G_MISS_CHAR)
305: THEN

Line 302: AND (p_location_city IS NULL OR p_location_city = FND_API.G_MISS_CHAR)

298: -- If location details are passed then get the location id for the for the given location parameters
299: -- If the location does not already exist then create it
300: --
301: IF (l_assignment_rec.location_id IS NULL OR l_assignment_rec.location_id = FND_API.G_MISS_NUM)
302: AND (p_location_city IS NULL OR p_location_city = FND_API.G_MISS_CHAR)
303: AND (p_location_region IS NULL OR p_location_region = FND_API.G_MISS_CHAR)
304: AND (p_location_country_code IS NULL OR p_location_country_code = FND_API.G_MISS_CHAR)
305: THEN
306:

Line 303: AND (p_location_region IS NULL OR p_location_region = FND_API.G_MISS_CHAR)

299: -- If the location does not already exist then create it
300: --
301: IF (l_assignment_rec.location_id IS NULL OR l_assignment_rec.location_id = FND_API.G_MISS_NUM)
302: AND (p_location_city IS NULL OR p_location_city = FND_API.G_MISS_CHAR)
303: AND (p_location_region IS NULL OR p_location_region = FND_API.G_MISS_CHAR)
304: AND (p_location_country_code IS NULL OR p_location_country_code = FND_API.G_MISS_CHAR)
305: THEN
306:
307: --bug 1795160: no need to get location from project, location not required.

Line 304: AND (p_location_country_code IS NULL OR p_location_country_code = FND_API.G_MISS_CHAR)

300: --
301: IF (l_assignment_rec.location_id IS NULL OR l_assignment_rec.location_id = FND_API.G_MISS_NUM)
302: AND (p_location_city IS NULL OR p_location_city = FND_API.G_MISS_CHAR)
303: AND (p_location_region IS NULL OR p_location_region = FND_API.G_MISS_CHAR)
304: AND (p_location_country_code IS NULL OR p_location_country_code = FND_API.G_MISS_CHAR)
305: THEN
306:
307: --bug 1795160: no need to get location from project, location not required.
308: /*

Line 323: ELSIF l_assignment_rec.location_id IS NULL OR l_assignment_rec.location_id = FND_API.G_MISS_NUM THEN

319: END IF;
320:
321:
322: --only call get_location if location_id IS NULL
323: ELSIF l_assignment_rec.location_id IS NULL OR l_assignment_rec.location_id = FND_API.G_MISS_NUM THEN
324:
325: PA_LOCATION_UTILS.Get_Location( p_city => p_location_city
326: ,p_region => p_location_region
327: ,p_country_code => p_location_country_code

Line 332: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

328: ,x_location_id => l_assignment_rec.location_id
329: ,x_error_message_code => l_error_message_code
330: ,x_return_status => l_return_status );
331:
332: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
333: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
334: ,p_msg_name => l_error_message_code );
335: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
336: END IF;

Line 335: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

331:
332: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
333: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
334: ,p_msg_name => l_error_message_code );
335: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
336: END IF;
337:
338: END IF;
339:

Line 363: l_assignment_rec.project_id <> FND_API.G_MISS_NUM THEN

359: l_resource_source_id := p_resource_source_id;
360:
361: --Additional Check: If Project Id is not present, no need to run the following program that depends on it.
362: IF l_assignment_rec.project_id IS NOT NULL AND
363: l_assignment_rec.project_id <> FND_API.G_MISS_NUM THEN
364:
365: --If resource id exist, get the resource_source_id, and use it to create project party
366: IF (l_assignment_rec.resource_id IS NOT NULL AND l_assignment_rec.resource_id <> FND_API.G_MISS_NUM) AND
367: (l_resource_source_id IS NULL OR l_resource_source_id =FND_API.G_MISS_NUM) THEN

Line 366: IF (l_assignment_rec.resource_id IS NOT NULL AND l_assignment_rec.resource_id <> FND_API.G_MISS_NUM) AND

362: IF l_assignment_rec.project_id IS NOT NULL AND
363: l_assignment_rec.project_id <> FND_API.G_MISS_NUM THEN
364:
365: --If resource id exist, get the resource_source_id, and use it to create project party
366: IF (l_assignment_rec.resource_id IS NOT NULL AND l_assignment_rec.resource_id <> FND_API.G_MISS_NUM) AND
367: (l_resource_source_id IS NULL OR l_resource_source_id =FND_API.G_MISS_NUM) THEN
368:
369: --Log Message
370: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 367: (l_resource_source_id IS NULL OR l_resource_source_id =FND_API.G_MISS_NUM) THEN

363: l_assignment_rec.project_id <> FND_API.G_MISS_NUM THEN
364:
365: --If resource id exist, get the resource_source_id, and use it to create project party
366: IF (l_assignment_rec.resource_id IS NOT NULL AND l_assignment_rec.resource_id <> FND_API.G_MISS_NUM) AND
367: (l_resource_source_id IS NULL OR l_resource_source_id =FND_API.G_MISS_NUM) THEN
368:
369: --Log Message
370: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
371: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment.res_source_id'

Line 381: IF (l_assignment_rec.project_party_id = FND_API.G_MISS_NUM OR l_assignment_rec.project_party_id IS NULL) AND

377: CLOSE get_resource_source_id;
378: END IF;
379:
380:
381: IF (l_assignment_rec.project_party_id = FND_API.G_MISS_NUM OR l_assignment_rec.project_party_id IS NULL) AND
382: (l_assignment_rec.project_role_id IS NOT NULL AND l_assignment_rec.project_role_id <> FND_API.G_MISS_NUM) AND
383: (l_resource_source_id IS NOT NULL AND l_resource_source_id <>FND_API.G_MISS_NUM) THEN
384:
385: --dbms_output.put_line('*****calling create_project_party');

Line 382: (l_assignment_rec.project_role_id IS NOT NULL AND l_assignment_rec.project_role_id <> FND_API.G_MISS_NUM) AND

378: END IF;
379:
380:
381: IF (l_assignment_rec.project_party_id = FND_API.G_MISS_NUM OR l_assignment_rec.project_party_id IS NULL) AND
382: (l_assignment_rec.project_role_id IS NOT NULL AND l_assignment_rec.project_role_id <> FND_API.G_MISS_NUM) AND
383: (l_resource_source_id IS NOT NULL AND l_resource_source_id <>FND_API.G_MISS_NUM) THEN
384:
385: --dbms_output.put_line('*****calling create_project_party');
386: --dbms_output.put_line('*****resource_source_id:'||l_resource_source_id);

Line 383: (l_resource_source_id IS NOT NULL AND l_resource_source_id <>FND_API.G_MISS_NUM) THEN

379:
380:
381: IF (l_assignment_rec.project_party_id = FND_API.G_MISS_NUM OR l_assignment_rec.project_party_id IS NULL) AND
382: (l_assignment_rec.project_role_id IS NOT NULL AND l_assignment_rec.project_role_id <> FND_API.G_MISS_NUM) AND
383: (l_resource_source_id IS NOT NULL AND l_resource_source_id <>FND_API.G_MISS_NUM) THEN
384:
385: --dbms_output.put_line('*****calling create_project_party');
386: --dbms_output.put_line('*****resource_source_id:'||l_resource_source_id);
387: --dbms_output.put_line('*****resource_id:'||l_assignment_rec.resource_id);

Line 409: ,p_commit => FND_API.G_FALSE

405: ,p_calling_module => 'ASSIGNMENT'
406: ,p_project_end_date => NULL
407: ,p_end_date_active => l_assignment_rec.end_date
408: ,p_validate_only => p_validate_only
409: ,p_commit => FND_API.G_FALSE
410: ,x_project_party_id => l_assignment_rec.project_party_id
411: ,x_resource_id => l_assignment_rec.resource_id
412: ,x_assignment_id => l_pp_assignment_id
413: ,x_wf_type => l_wf_type

Line 424: ( p_commit => FND_API.G_FALSE

420: */ -- Commented this call for Bug 6631033
421: /* Added the call below for Bug 6631033. This is the same API being called from
422: Add key Members page */
423: PA_PROJECT_PARTIES_PUB.Create_Project_Party_Wrp
424: ( p_commit => FND_API.G_FALSE
425: ,p_validate_only => p_validate_only
426: ,p_object_id => l_assignment_rec.project_id
427: ,p_object_type => 'PA_PROJECTS'
428: ,p_project_role_id => l_assignment_rec.project_role_id

Line 463: IF (x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN

459: --dbms_output.put_line('proj party resource id is '||l_assignment_rec.resource_id);
460: --dbms_output.put_line('proj party id is '||l_assignment_rec.project_party_id);
461: --dbms_output.put_line('number of error '||l_msg_count);
462:
463: IF (x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
464: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
465: l_project_parties_error_exists := FND_API.G_TRUE;
466: END IF;
467:

Line 464: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

460: --dbms_output.put_line('proj party id is '||l_assignment_rec.project_party_id);
461: --dbms_output.put_line('number of error '||l_msg_count);
462:
463: IF (x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
464: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
465: l_project_parties_error_exists := FND_API.G_TRUE;
466: END IF;
467:
468: END IF; --end of create project party check

Line 465: l_project_parties_error_exists := FND_API.G_TRUE;

461: --dbms_output.put_line('number of error '||l_msg_count);
462:
463: IF (x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
464: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
465: l_project_parties_error_exists := FND_API.G_TRUE;
466: END IF;
467:
468: END IF; --end of create project party check
469:

Line 471: IF (l_assignment_rec.resource_id <> FND_API.G_MISS_NUM) THEN

467:
468: END IF; --end of create project party check
469:
470: --Assign out parameter: resource id
471: IF (l_assignment_rec.resource_id <> FND_API.G_MISS_NUM) THEN
472: x_resource_id := l_assignment_rec.resource_id;
473: END IF;
474:
475: --Bug 2229861: Check if the resource records are pulled into

Line 477: l_check_resource := FND_API.G_RET_STS_SUCCESS;

473: END IF;
474:
475: --Bug 2229861: Check if the resource records are pulled into
476: -- pa_resources_denorm table on the assignment start date
477: l_check_resource := FND_API.G_RET_STS_SUCCESS;
478:
479: PA_RESOURCE_UTILS.Validate_Person (
480: p_person_id => l_resource_source_id
481: ,p_start_date => l_assignment_rec.start_date

Line 490: IF l_check_resource <> FND_API.G_RET_STS_SUCCESS THEN

486: ,x_msg => 'validate person, status='||l_check_resource
487: ,x_log_level => li_message_level);
488: END IF;
489:
490: IF l_check_resource <> FND_API.G_RET_STS_SUCCESS THEN
491: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
492: -- bug 4091194 : This person is invalid for the assignment.
493: -- Set it to null to avoid further process.
494: l_assignment_rec.resource_id := NULL;

Line 491: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

487: ,x_log_level => li_message_level);
488: END IF;
489:
490: IF l_check_resource <> FND_API.G_RET_STS_SUCCESS THEN
491: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
492: -- bug 4091194 : This person is invalid for the assignment.
493: -- Set it to null to avoid further process.
494: l_assignment_rec.resource_id := NULL;
495: END IF;

Line 502: (l_assignment_rec.fcst_tp_amount_type = FND_API.G_MISS_CHAR) OR

498: --IF it has not been defaulted already OR
499: --IF it is copying from an assignment into a requirement AND
500: --IF IT IS NOT a template requirement.
501: IF (((l_assignment_rec.fcst_tp_amount_type IS NULL) OR
502: (l_assignment_rec.fcst_tp_amount_type = FND_API.G_MISS_CHAR) OR
503: (p_asgn_creation_mode = 'COPY' AND l_assignment_rec.source_assignment_type <> 'OPEN_ASSIGNMENT')) AND
504: (l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM)) THEN
505:
506: --dbms_output.put_line('calling assignment default');

Line 504: (l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM)) THEN

500: --IF IT IS NOT a template requirement.
501: IF (((l_assignment_rec.fcst_tp_amount_type IS NULL) OR
502: (l_assignment_rec.fcst_tp_amount_type = FND_API.G_MISS_CHAR) OR
503: (p_asgn_creation_mode = 'COPY' AND l_assignment_rec.source_assignment_type <> 'OPEN_ASSIGNMENT')) AND
504: (l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM)) THEN
505:
506: --dbms_output.put_line('calling assignment default');
507: --Log Message
508: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 533: IF PA_STARTUP.G_Calling_Application = 'PLSQL' AND l_assignment_rec.expenditure_type IS NOT NULL AND l_assignment_rec.expenditure_type <> FND_API.G_MISS_CHAR

529: x_msg_data => l_msg_data
530: );
531:
532: -- Bug 5130421 : Expenditure type and class can be passed in, so don't default if passed from PLSQL
533: IF PA_STARTUP.G_Calling_Application = 'PLSQL' AND l_assignment_rec.expenditure_type IS NOT NULL AND l_assignment_rec.expenditure_type <> FND_API.G_MISS_CHAR
534: AND l_assignment_rec.expenditure_type_class IS NOT NULL AND l_assignment_rec.expenditure_type_class IS NOT NULL
535: THEN
536: null;
537: ELSE

Line 544: IF l_assignment_rec.work_type_id IS NOT NULL AND l_assignment_rec.work_type_id <> FND_API.G_MISS_NUM THEN

540: END IF;
541:
542: -- fcst tp amount type shd get default from work type
543: -- it was getting default from the default work type
544: IF l_assignment_rec.work_type_id IS NOT NULL AND l_assignment_rec.work_type_id <> FND_API.G_MISS_NUM THEN
545: Pa_Fp_Org_Fcst_Utils.Get_Tp_Amount_Type(
546: p_project_id => l_assignment_rec.project_id,
547: p_work_type_id => l_assignment_rec.work_type_id,
548: x_tp_amount_type => l_fcst_tp_amount_type_tmp,

Line 584: IF (l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM) AND

580: --
581: -- Get bill rate and bill rate currency code, and markup percent
582: -- if this is not an admin assignment
583: --
584: IF (l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM) AND
585: l_project_parties_error_exists <> FND_API.G_TRUE AND
586: l_check_resource = FND_API.G_RET_STS_SUCCESS AND
587: l_assignment_rec.assignment_type <> 'STAFFED_ADMIN_ASSIGNMENT' AND
588: l_resource_source_id IS NOT NULL THEN

Line 585: l_project_parties_error_exists <> FND_API.G_TRUE AND

581: -- Get bill rate and bill rate currency code, and markup percent
582: -- if this is not an admin assignment
583: --
584: IF (l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM) AND
585: l_project_parties_error_exists <> FND_API.G_TRUE AND
586: l_check_resource = FND_API.G_RET_STS_SUCCESS AND
587: l_assignment_rec.assignment_type <> 'STAFFED_ADMIN_ASSIGNMENT' AND
588: l_resource_source_id IS NOT NULL THEN
589:

Line 586: l_check_resource = FND_API.G_RET_STS_SUCCESS AND

582: -- if this is not an admin assignment
583: --
584: IF (l_assignment_rec.project_id IS NOT NULL AND l_assignment_rec.project_id <> FND_API.G_MISS_NUM) AND
585: l_project_parties_error_exists <> FND_API.G_TRUE AND
586: l_check_resource = FND_API.G_RET_STS_SUCCESS AND
587: l_assignment_rec.assignment_type <> 'STAFFED_ADMIN_ASSIGNMENT' AND
588: l_resource_source_id IS NOT NULL THEN
589:
590: --Log Message

Line 625: IF (p_assignment_rec.resource_list_member_id = FND_API.G_MISS_NUM OR

621: ,x_log_level => li_message_level);
622: END IF;
623:
624: -- FP.M Development
625: IF (p_assignment_rec.resource_list_member_id = FND_API.G_MISS_NUM OR
626: p_assignment_rec.resource_list_member_id IS NULL) AND
627: p_assignment_rec.project_id <> FND_API.G_MISS_NUM AND
628: l_assignment_rec.resource_id IS NOT NULL THEN
629: begin

Line 627: p_assignment_rec.project_id <> FND_API.G_MISS_NUM AND

623:
624: -- FP.M Development
625: IF (p_assignment_rec.resource_list_member_id = FND_API.G_MISS_NUM OR
626: p_assignment_rec.resource_list_member_id IS NULL) AND
627: p_assignment_rec.project_id <> FND_API.G_MISS_NUM AND
628: l_assignment_rec.resource_id IS NOT NULL THEN
629: begin
630:
631: SELECT proj_asgmt_res_format_id

Line 653: IF l_proj_asgmt_res_format_id = FND_API.G_MISS_NUM THEN

649: when others then
650: null;
651: end;
652:
653: IF l_proj_asgmt_res_format_id = FND_API.G_MISS_NUM THEN
654: l_proj_asgmt_res_format_id := NULL;
655: END IF;
656:
657: l_person_id_tmp := l_person_id;

Line 658: IF l_person_id_tmp = FND_API.G_MISS_NUM THEN

654: l_proj_asgmt_res_format_id := NULL;
655: END IF;
656:
657: l_person_id_tmp := l_person_id;
658: IF l_person_id_tmp = FND_API.G_MISS_NUM THEN
659: l_person_id_tmp := NULL;
660: END IF;
661:
662: l_fcst_job_id_tmp := l_assignment_rec.fcst_job_id;

Line 663: IF l_fcst_job_id_tmp = FND_API.G_MISS_NUM THEN

659: l_person_id_tmp := NULL;
660: END IF;
661:
662: l_fcst_job_id_tmp := l_assignment_rec.fcst_job_id;
663: IF l_fcst_job_id_tmp = FND_API.G_MISS_NUM THEN
664: l_fcst_job_id_tmp := NULL;
665: END IF;
666:
667: l_expenditure_type_tmp := l_assignment_rec.expenditure_type;

Line 668: IF l_expenditure_type_tmp = FND_API.G_MISS_CHAR THEN

664: l_fcst_job_id_tmp := NULL;
665: END IF;
666:
667: l_expenditure_type_tmp := l_assignment_rec.expenditure_type;
668: IF l_expenditure_type_tmp = FND_API.G_MISS_CHAR THEN
669: l_expenditure_type_tmp := NULL;
670: END IF;
671:
672: l_project_role_id_tmp := l_assignment_rec.project_role_id;

Line 673: IF l_project_role_id_tmp = FND_API.G_MISS_NUM THEN

669: l_expenditure_type_tmp := NULL;
670: END IF;
671:
672: l_project_role_id_tmp := l_assignment_rec.project_role_id;
673: IF l_project_role_id_tmp = FND_API.G_MISS_NUM THEN
674: l_project_role_id_tmp := NULL;
675: END IF;
676:
677: l_assignment_name_tmp := l_assignment_rec.assignment_name;

Line 678: IF l_assignment_name_tmp = FND_API.G_MISS_CHAR THEN

674: l_project_role_id_tmp := NULL;
675: END IF;
676:
677: l_assignment_name_tmp := l_assignment_rec.assignment_name;
678: IF l_assignment_name_tmp = FND_API.G_MISS_CHAR THEN
679: l_assignment_name_tmp := NULL;
680: END IF;
681:
682: -- For Staffed Assignment only, get organization from resource before

Line 814: IF l_ret_code = FND_API.G_FALSE THEN

810: x_return_status => l_return_status,
811: x_msg_count => l_msg_count,
812: x_msg_data => l_msg_data);
813:
814: IF l_ret_code = FND_API.G_FALSE THEN
815: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
816: ,p_msg_name => 'PA_ADD_ADMIN_ASMT_SECURITY' );
817: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
818: END IF;

Line 817: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

813:
814: IF l_ret_code = FND_API.G_FALSE THEN
815: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
816: ,p_msg_name => 'PA_ADD_ADMIN_ASMT_SECURITY' );
817: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
818: END IF;
819:
820: END IF;
821: END IF;

Line 860: IF l_ret_code = FND_API.G_FALSE THEN

856: x_msg_count => l_msg_count,
857: x_msg_data => l_msg_data);
858: END IF;
859:
860: IF l_ret_code = FND_API.G_FALSE THEN
861: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
862: ,p_msg_name => 'PA_ASGN_CONFIRM_NOT_ALLOWED' );
863: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
864: END IF;

Line 863: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

859:
860: IF l_ret_code = FND_API.G_FALSE THEN
861: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
862: ,p_msg_name => 'PA_ASGN_CONFIRM_NOT_ALLOWED' );
863: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
864: END IF;
865:
866: END IF;
867:

Line 874: IF l_assignment_rec.resource_id IS NOT NULL AND l_assignment_rec.resource_id <> FND_API.G_MISS_NUM THEN

870: --DBMS_OUTPUT.Put_Line('Debug stage 1');
871:
872: --cross charge validation.
873:
874: IF l_assignment_rec.resource_id IS NOT NULL AND l_assignment_rec.resource_id <> FND_API.G_MISS_NUM THEN
875:
876: --dbms_output.put_line('cc resource id: '||l_assignment_rec.resource_id);
877: --dbms_output.put_line('cc start date: '||l_assignment_rec.start_date);
878: --dbms_output.put_line('cc end date: '||l_assignment_rec.end_date);

Line 894: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

890: x_cc_ok => l_cc_ok,
891: x_return_status => l_return_status,
892: x_error_message_code => l_error_message_code);
893:
894: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
895: PA_UTILS.Add_Message( p_app_short_name => 'PA'
896: ,p_msg_name => l_error_message_code);
897: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
898: END IF;

Line 897: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

893:
894: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
895: PA_UTILS.Add_Message( p_app_short_name => 'PA'
896: ,p_msg_name => l_error_message_code);
897: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
898: END IF;
899: --dbms_output.put_line('l_cc_ok: '||l_cc_ok);
900: IF l_cc_ok <> 'Y' THEN
901: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 903: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

899: --dbms_output.put_line('l_cc_ok: '||l_cc_ok);
900: IF l_cc_ok <> 'Y' THEN
901: PA_UTILS.Add_Message( p_app_short_name => 'PA'
902: ,p_msg_name => 'CROSS_CHARGE_VALIDATION_FAILED');
903: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
904: END IF;
905:
906: END IF;
907:

Line 926: AND l_project_parties_error_exists <> FND_API.G_TRUE -- 6210780

922: --dbms_output.put_line('before calling insert row');
923:
924: /*Adding changes for Bug 5918412 to get calendar id when the calendar_type = 'RESOURCE'*/
925: IF (l_assignment_rec.calendar_type = 'RESOURCE')
926: AND l_project_parties_error_exists <> FND_API.G_TRUE -- 6210780
927: AND l_assignment_rec.resource_id IS NOT NULL -- 6210780
928: THEN
929:
930: l_assignment_rec.calendar_id := pa_schedule_utils.get_res_calendar(p_resource_id => l_assignment_rec.resource_id ,

Line 936: IF (p_validate_only <> FND_API.G_TRUE AND FND_MSG_PUB.Count_Msg = 0) THEN

932: p_end_date => l_assignment_rec.end_date);
933: END IF ;
934: /*Changes end for Bug 5918412 */
935:
936: IF (p_validate_only <> FND_API.G_TRUE AND FND_MSG_PUB.Count_Msg = 0) THEN
937:
938:
939: --Log Message
940: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 1049: FND_API.G_MISS_NUM THEN

1045: -- ( 'R' -> based on resource , 'A' -> based on open assignment, 'P' -> project , 'O' -> others
1046:
1047:
1048: IF l_assignment_rec.source_assignment_id IS NOT NULL AND l_assignment_rec.source_assignment_id <>
1049: FND_API.G_MISS_NUM THEN
1050:
1051: l_schedule_basis_flag := 'A';
1052:
1053: ELSIF l_assignment_rec.calendar_type = 'PROJECT' THEN

Line 1100: IF p_budget_version_id IS NOT NULL AND p_budget_version_id <> FND_API.G_MISS_NUM AND

1096: ,x_msg => 'budget_version_id'||p_budget_version_id
1097: ,x_log_level => li_message_level);
1098: END IF;
1099:
1100: IF p_budget_version_id IS NOT NULL AND p_budget_version_id <> FND_API.G_MISS_NUM AND
1101: l_assignment_rec.resource_list_member_id IS NOT NULL AND
1102: l_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM THEN
1103:
1104: OPEN get_bu_resource_assignments;

Line 1102: l_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM THEN

1098: END IF;
1099:
1100: IF p_budget_version_id IS NOT NULL AND p_budget_version_id <> FND_API.G_MISS_NUM AND
1101: l_assignment_rec.resource_list_member_id IS NOT NULL AND
1102: l_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM THEN
1103:
1104: OPEN get_bu_resource_assignments;
1105: FETCH get_bu_resource_assignments
1106: BULK COLLECT INTO l_task_assignment_id_tbl,

Line 1116: l_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM THEN

1112: ELSE
1113:
1114: /*Added this IF for bug 7492618*/
1115: IF l_assignment_rec.resource_list_member_id IS NOT NULL AND
1116: l_assignment_rec.resource_list_member_id <> FND_API.G_MISS_NUM THEN
1117:
1118: OPEN get_td_resource_assignments;
1119: FETCH get_td_resource_assignments
1120: BULK COLLECT INTO l_task_assignment_id_tbl,

Line 1214: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1210: );
1211:
1212: /* Added calc_init_transfer_price for bug 3051110 */
1213:
1214: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1215: PA_ASSIGNMENTS_PVT.Calc_Init_Transfer_Price
1216: (p_assignment_id =>l_assignment_rec.assignment_id,
1217: p_start_date => l_assignment_rec.start_date,
1218: p_debug_mode => P_DEBUG_MODE,

Line 1226: END IF; -- IF (p_validate_only <> FND_API.G_TRUE AND FND_MSG_PUB.Count_Msg = 0)

1222:
1223: x_return_status := l_return_status;
1224: END IF;
1225:
1226: END IF; -- IF (p_validate_only <> FND_API.G_TRUE AND FND_MSG_PUB.Count_Msg = 0)
1227:
1228: -- Reset the error stack when returning to the calling program
1229: PA_DEBUG.Reset_err_stack;
1230:

Line 1246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1242: -- Set the excetption Message and the stack
1243: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1244: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1245: --
1246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1247: RAISE; -- This is optional depending on the needs
1248:
1249: END Create_Staffed_Assignment;
1250:

Line 1255: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

1251:
1252:
1253: PROCEDURE Update_Staffed_Assignment
1254: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
1255: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1256: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1257: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1258: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1259: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 1256: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR

1252:
1253: PROCEDURE Update_Staffed_Assignment
1254: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
1255: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1256: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1257: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1258: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1259: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1260: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1257: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR

1253: PROCEDURE Update_Staffed_Assignment
1254: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
1255: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1256: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1257: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1258: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1259: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1260: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1261: ) IS

Line 1258: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1254: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
1255: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1256: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1257: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1258: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1259: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1260: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1261: ) IS
1262:

Line 1259: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

1255: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
1256: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
1257: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
1258: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1259: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1260: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1261: ) IS
1262:
1263: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;

Line 1458: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1454:
1455: BEGIN
1456:
1457: -- 4537865 : Initialize the return_status
1458: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1459:
1460: -- Initialize the Error Stack
1461: PA_DEBUG.set_err_stack('PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment');
1462:

Line 1487: IF p_assignment_rec.resource_id = FND_API.G_MISS_NUM THEN

1483: l_cur_resource_list_member_id,
1484: l_cur_project_role_id;
1485: CLOSE get_cur_asgmt_attributes;
1486:
1487: IF p_assignment_rec.resource_id = FND_API.G_MISS_NUM THEN
1488: l_assignment_rec.resource_id := l_cur_resource_id;
1489: END IF;
1490:
1491: IF P_DEBUG_MODE = 'Y' THEN

Line 1497: IF p_assignment_rec.project_role_id = FND_API.G_MISS_NUM THEN

1493: ,x_msg => 'l_asgmt_rec.resource_id='||l_assignment_rec.resource_id
1494: ,x_log_level => li_message_level);
1495: END IF;
1496:
1497: IF p_assignment_rec.project_role_id = FND_API.G_MISS_NUM THEN
1498: l_assignment_rec.project_role_id := l_cur_project_role_id;
1499: END IF;
1500:
1501: --Log Message

Line 1509: p_assignment_rec.project_id <> FND_API.G_MISS_NUM THEN

1505: ,x_log_level => 5);
1506: END IF;
1507:
1508: IF l_cur_resource_list_member_id IS NOT NULL AND
1509: p_assignment_rec.project_id <> FND_API.G_MISS_NUM THEN
1510:
1511: -- get the mandatory attributes of planning resource
1512: OPEN get_res_mand_attributes;
1513: FETCH get_res_mand_attributes INTO

Line 1522: IF l_assignment_rec.resource_id <> FND_API.G_MISS_NUM THEN

1518: l_cur_role_flag;
1519: CLOSE get_res_mand_attributes;
1520:
1521: -- check if mandatory attributes are changed
1522: IF l_assignment_rec.resource_id <> FND_API.G_MISS_NUM THEN
1523: select person_id
1524: into l_person_id
1525: from pa_resource_txn_attributes
1526: WHERE resource_id = l_assignment_rec.resource_id;

Line 1535: l_assignment_rec.resource_id <> FND_API.G_MISS_NUM AND

1531: ,x_log_level => li_message_level);
1532: END IF;
1533:
1534: IF (l_cur_res_type_flag = 'Y' AND
1535: l_assignment_rec.resource_id <> FND_API.G_MISS_NUM AND
1536: l_assignment_rec.resource_id <> l_cur_resource_id) OR
1537: (l_cur_res_type_flag = 'Y' AND
1538: p_assignment_rec.fcst_job_id <> FND_API.G_MISS_NUM AND
1539: p_assignment_rec.fcst_job_id <> l_cur_fcst_job_id) OR

Line 1538: p_assignment_rec.fcst_job_id <> FND_API.G_MISS_NUM AND

1534: IF (l_cur_res_type_flag = 'Y' AND
1535: l_assignment_rec.resource_id <> FND_API.G_MISS_NUM AND
1536: l_assignment_rec.resource_id <> l_cur_resource_id) OR
1537: (l_cur_res_type_flag = 'Y' AND
1538: p_assignment_rec.fcst_job_id <> FND_API.G_MISS_NUM AND
1539: p_assignment_rec.fcst_job_id <> l_cur_fcst_job_id) OR
1540: (l_cur_orgn_flag = 'Y' AND
1541: p_assignment_rec.expenditure_organization_id <> FND_API.G_MISS_NUM AND
1542: p_assignment_rec.expenditure_organization_id <> l_cur_exp_org_id) OR

Line 1541: p_assignment_rec.expenditure_organization_id <> FND_API.G_MISS_NUM AND

1537: (l_cur_res_type_flag = 'Y' AND
1538: p_assignment_rec.fcst_job_id <> FND_API.G_MISS_NUM AND
1539: p_assignment_rec.fcst_job_id <> l_cur_fcst_job_id) OR
1540: (l_cur_orgn_flag = 'Y' AND
1541: p_assignment_rec.expenditure_organization_id <> FND_API.G_MISS_NUM AND
1542: p_assignment_rec.expenditure_organization_id <> l_cur_exp_org_id) OR
1543: (l_cur_fin_cat_flag = 'Y' AND
1544: p_assignment_rec.expenditure_type <> FND_API.G_MISS_CHAR AND
1545: p_assignment_rec.expenditure_type <> l_cur_expenditure_type) OR

Line 1544: p_assignment_rec.expenditure_type <> FND_API.G_MISS_CHAR AND

1540: (l_cur_orgn_flag = 'Y' AND
1541: p_assignment_rec.expenditure_organization_id <> FND_API.G_MISS_NUM AND
1542: p_assignment_rec.expenditure_organization_id <> l_cur_exp_org_id) OR
1543: (l_cur_fin_cat_flag = 'Y' AND
1544: p_assignment_rec.expenditure_type <> FND_API.G_MISS_CHAR AND
1545: p_assignment_rec.expenditure_type <> l_cur_expenditure_type) OR
1546: (l_cur_role_flag = 'Y' AND
1547: p_assignment_rec.project_role_id <> FND_API.G_MISS_NUM AND
1548: p_assignment_rec.project_role_id <> l_cur_project_role_id) OR

Line 1547: p_assignment_rec.project_role_id <> FND_API.G_MISS_NUM AND

1543: (l_cur_fin_cat_flag = 'Y' AND
1544: p_assignment_rec.expenditure_type <> FND_API.G_MISS_CHAR AND
1545: p_assignment_rec.expenditure_type <> l_cur_expenditure_type) OR
1546: (l_cur_role_flag = 'Y' AND
1547: p_assignment_rec.project_role_id <> FND_API.G_MISS_NUM AND
1548: p_assignment_rec.project_role_id <> l_cur_project_role_id) OR
1549: (l_cur_role_flag = 'Y' AND
1550: p_assignment_rec.assignment_name <> FND_API.G_MISS_CHAR AND
1551: p_assignment_rec.assignment_name <> l_cur_assignment_name) THEN

Line 1550: p_assignment_rec.assignment_name <> FND_API.G_MISS_CHAR AND

1546: (l_cur_role_flag = 'Y' AND
1547: p_assignment_rec.project_role_id <> FND_API.G_MISS_NUM AND
1548: p_assignment_rec.project_role_id <> l_cur_project_role_id) OR
1549: (l_cur_role_flag = 'Y' AND
1550: p_assignment_rec.assignment_name <> FND_API.G_MISS_CHAR AND
1551: p_assignment_rec.assignment_name <> l_cur_assignment_name) THEN
1552: --Log Message
1553: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1554: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'

Line 1581: IF l_proj_asgmt_res_format_id = FND_API.G_MISS_NUM THEN

1577: when others then
1578: null;
1579: end;
1580:
1581: IF l_proj_asgmt_res_format_id = FND_API.G_MISS_NUM THEN
1582: l_proj_asgmt_res_format_id := NULL;
1583: END IF;
1584: */
1585: l_person_id_tmp := l_person_id;

Line 1586: IF l_person_id_tmp = FND_API.G_MISS_NUM THEN

1582: l_proj_asgmt_res_format_id := NULL;
1583: END IF;
1584: */
1585: l_person_id_tmp := l_person_id;
1586: IF l_person_id_tmp = FND_API.G_MISS_NUM THEN
1587: l_person_id_tmp := NULL;
1588: END IF;
1589:
1590: l_fcst_job_id_tmp := l_assignment_rec.fcst_job_id;

Line 1591: IF l_fcst_job_id_tmp = FND_API.G_MISS_NUM THEN

1587: l_person_id_tmp := NULL;
1588: END IF;
1589:
1590: l_fcst_job_id_tmp := l_assignment_rec.fcst_job_id;
1591: IF l_fcst_job_id_tmp = FND_API.G_MISS_NUM THEN
1592: l_fcst_job_id_tmp := NULL;
1593: END IF;
1594:
1595: l_expenditure_type_tmp := l_assignment_rec.expenditure_type;

Line 1596: IF l_expenditure_type_tmp = FND_API.G_MISS_CHAR THEN

1592: l_fcst_job_id_tmp := NULL;
1593: END IF;
1594:
1595: l_expenditure_type_tmp := l_assignment_rec.expenditure_type;
1596: IF l_expenditure_type_tmp = FND_API.G_MISS_CHAR THEN
1597: l_expenditure_type_tmp := NULL;
1598: END IF;
1599:
1600: l_project_role_id_tmp := l_assignment_rec.project_role_id;

Line 1601: IF l_project_role_id_tmp = FND_API.G_MISS_NUM THEN

1597: l_expenditure_type_tmp := NULL;
1598: END IF;
1599:
1600: l_project_role_id_tmp := l_assignment_rec.project_role_id;
1601: IF l_project_role_id_tmp = FND_API.G_MISS_NUM THEN
1602: l_project_role_id_tmp := NULL;
1603: END IF;
1604:
1605: l_assignment_name_tmp := l_assignment_rec.assignment_name;

Line 1606: IF l_assignment_name_tmp = FND_API.G_MISS_CHAR THEN

1602: l_project_role_id_tmp := NULL;
1603: END IF;
1604:
1605: l_assignment_name_tmp := l_assignment_rec.assignment_name;
1606: IF l_assignment_name_tmp = FND_API.G_MISS_CHAR THEN
1607: l_assignment_name_tmp := NULL;
1608: END IF;
1609:
1610: -- For Staffed Assignment only, get organization from resource before

Line 1855: ,p_named_role => FND_API.G_MISS_CHAR

1851: ,p_task_version_id_tbl => l_task_version_id_tbl
1852: ,p_budget_version_id_tbl => l_budget_version_id_tbl
1853: ,p_struct_version_id_tbl => l_struct_version_id_tbl
1854: ,p_project_assignment_id => -1
1855: ,p_named_role => FND_API.G_MISS_CHAR
1856: ,x_return_status => l_return_status
1857: );
1858: END IF;
1859:

Line 1871: ELSIF p_assignment_rec.assignment_name <> FND_API.G_MISS_CHAR AND

1867:
1868: END IF; --IF l_assignment_rec.resource_list_member_id IS NOT NULL THEN
1869:
1870: -- IF mandatory attributes are NOT changed
1871: ELSIF p_assignment_rec.assignment_name <> FND_API.G_MISS_CHAR AND
1872: p_assignment_rec.assignment_name <> l_cur_assignment_name THEN
1873:
1874: --Log Message
1875: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 1921: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

1917: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1918: ,p_msg_name => 'PA_ASGN_ID_REQUIRED_FOR_ASG'
1919: ,p_token1 => 'ASGNTYPE'
1920: ,p_value1 => l_asgn_text);
1921: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1922: END IF;
1923:
1924: --
1925: --Get assignment text from message to be used as values for token

Line 1937: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

1933: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1934: ,p_msg_name => 'PA_PROJ_ID_REQUIRED_FOR_ASGN'
1935: ,p_token1 => 'ASGNTYPE'
1936: ,p_value1 => l_asgn_text);
1937: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1938: END IF;
1939:
1940:
1941: --

Line 1949: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

1945: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1946: ,p_msg_name => 'PA_ASGN_NAME_REQUIRED_FOR_ASG'
1947: ,p_token1 => 'ASGNTYPE'
1948: ,p_value1 => l_asgn_text);
1949: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1950: END IF;
1951:
1952:
1953: --

Line 1961: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

1957: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1958: ,p_msg_name => 'PA_PROJ_ROLE_REQUIRED_FOR_ASGN'
1959: ,p_token1 => 'ASGNTYPE'
1960: ,p_value1 => l_asgn_text);
1961: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1962: END IF;
1963:
1964: --
1965: --Check p_work_type_id IS NOT NULL

Line 1971: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

1967: IF l_assignment_rec.work_type_id IS NULL THEN
1968: --dbms_output.put_line('WORK TYPE INVALID');
1969: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1970: ,p_msg_name => 'PA_WORK_TYPE_REQUIRED_FOR_ASGN' );
1971: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1972:
1973: END IF;
1974:
1975: -- Get the location id for the p_location_id for the given location parameters

Line 1977: IF (p_location_country_code IS NOT NULL AND p_location_country_code <> FND_API.G_MISS_CHAR) THEN

1973: END IF;
1974:
1975: -- Get the location id for the p_location_id for the given location parameters
1976: -- If the location does not already exsists, then create it
1977: IF (p_location_country_code IS NOT NULL AND p_location_country_code <> FND_API.G_MISS_CHAR) THEN
1978: PA_LOCATION_UTILS.Get_Location( p_city => p_location_city
1979: ,p_region => p_location_region
1980: ,p_country_code => p_location_country_code
1981: ,x_location_id => l_assignment_rec.location_id

Line 1985: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1981: ,x_location_id => l_assignment_rec.location_id
1982: ,x_error_message_code => l_msg_data
1983: ,x_return_status => l_return_status );
1984:
1985: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1986: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
1987: ,p_msg_name => l_msg_data );
1988: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1989: END IF;

Line 1988: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

1984:
1985: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1986: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
1987: ,p_msg_name => l_msg_data );
1988: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1989: END IF;
1990: END IF;
1991:
1992: /*

Line 1995: -- l_assignment_rec.location_id = FND_API.G_MISS_NUM

1991:
1992: /*
1993: -- commenting this out for mass update
1994: -- should not null out location id if
1995: -- l_assignment_rec.location_id = FND_API.G_MISS_NUM
1996:
1997: -- for single update, if location_country_name is passed in as null
1998: -- then null out location id (in pa_assignment_pub)
1999:

Line 2002: IF l_assignment_rec.location_id = FND_API.G_MISS_NUM AND PA_STARTUP.G_Calling_Application = 'SELF_SERVICE' THEN

1998: -- then null out location id (in pa_assignment_pub)
1999:
2000: --Bug 1795160: when user empty the location fields, the location id need to be nulled out.
2001: --If in self-service mode, and still no location id by now, then set it to NULL
2002: IF l_assignment_rec.location_id = FND_API.G_MISS_NUM AND PA_STARTUP.G_Calling_Application = 'SELF_SERVICE' THEN
2003: l_assignment_rec.location_id := NULL;
2004: END IF;
2005: */
2006:

Line 2020: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2016:
2017: PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History ( p_assignment_id => l_assignment_rec.assignment_id
2018: ,x_change_id => l_change_id
2019: ,x_return_status => l_return_status);
2020: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2021: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2022: END IF;
2023: l_return_status := FND_API.G_MISS_CHAR;
2024: END IF;

Line 2021: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

2017: PA_ASSIGNMENT_APPROVAL_PVT.Insert_Into_Assignment_History ( p_assignment_id => l_assignment_rec.assignment_id
2018: ,x_change_id => l_change_id
2019: ,x_return_status => l_return_status);
2020: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2021: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2022: END IF;
2023: l_return_status := FND_API.G_MISS_CHAR;
2024: END IF;
2025:

Line 2023: l_return_status := FND_API.G_MISS_CHAR;

2019: ,x_return_status => l_return_status);
2020: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2021: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2022: END IF;
2023: l_return_status := FND_API.G_MISS_CHAR;
2024: END IF;
2025:
2026:
2027: --Log Message

Line 2049: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2045: --end if;
2046: /* end bug 8233045 */
2047: -- added for bug: 4537865
2048:
2049: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2050: l_assignment_rec.apprvl_status_code := l_new_status_code;
2051: END IF;
2052:
2053: -- added for Bug: 4537865

Line 2055: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2051: END IF;
2052:
2053: -- added for Bug: 4537865
2054:
2055: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2056: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2057: END IF;
2058: l_return_status := FND_API.G_MISS_CHAR;
2059:

Line 2056: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

2052:
2053: -- added for Bug: 4537865
2054:
2055: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2056: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2057: END IF;
2058: l_return_status := FND_API.G_MISS_CHAR;
2059:
2060: IF (p_validate_only = FND_API.G_FALSE AND PA_ASSIGNMENTS_PUB.g_error_exists <> FND_API.G_TRUE) THEN

Line 2058: l_return_status := FND_API.G_MISS_CHAR;

2054:
2055: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2056: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2057: END IF;
2058: l_return_status := FND_API.G_MISS_CHAR;
2059:
2060: IF (p_validate_only = FND_API.G_FALSE AND PA_ASSIGNMENTS_PUB.g_error_exists <> FND_API.G_TRUE) THEN
2061:
2062: --Log Message

Line 2060: IF (p_validate_only = FND_API.G_FALSE AND PA_ASSIGNMENTS_PUB.g_error_exists <> FND_API.G_TRUE) THEN

2056: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2057: END IF;
2058: l_return_status := FND_API.G_MISS_CHAR;
2059:
2060: IF (p_validate_only = FND_API.G_FALSE AND PA_ASSIGNMENTS_PUB.g_error_exists <> FND_API.G_TRUE) THEN
2061:
2062: --Log Message
2063: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2064: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.update_row'

Line 2152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2148: -- Set the excetption Message and the stack
2149: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
2150: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2151: --
2152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2153: RAISE; -- This is optional depending on the needs
2154:
2155: END Update_Staffed_Assignment;
2156:

Line 2160: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM

2156:
2157:
2158: PROCEDURE Delete_Staffed_Assignment
2159: ( p_assignment_row_id IN ROWID --(Bug-1851096)
2160: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
2161: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
2162: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM
2163: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
2164: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 2161: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM

2157:
2158: PROCEDURE Delete_Staffed_Assignment
2159: ( p_assignment_row_id IN ROWID --(Bug-1851096)
2160: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
2161: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
2162: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM
2163: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
2164: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2165: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 2162: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM

2158: PROCEDURE Delete_Staffed_Assignment
2159: ( p_assignment_row_id IN ROWID --(Bug-1851096)
2160: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
2161: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
2162: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM
2163: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
2164: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2165: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2166: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2163: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR

2159: ( p_assignment_row_id IN ROWID --(Bug-1851096)
2160: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
2161: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
2162: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM
2163: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
2164: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2165: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2166: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2167: ) IS

Line 2164: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

2160: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE := FND_API.G_MISS_NUM
2161: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
2162: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM
2163: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
2164: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2165: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2166: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2167: ) IS
2168:

Line 2165: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

2161: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
2162: ,p_project_party_id IN pa_project_parties.project_party_id%TYPE := FND_API.G_MISS_NUM
2163: ,p_calling_module IN VARCHAR2 := FND_API.G_MISS_CHAR
2164: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2165: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2166: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2167: ) IS
2168:
2169: l_return_status VARCHAR2(1);

Line 2189: x_return_status := FND_API.G_RET_STS_SUCCESS;

2185:
2186: BEGIN
2187:
2188: -- 4537865 : Initialize the return_status
2189: x_return_status := FND_API.G_RET_STS_SUCCESS;
2190: -- Initialize the Error Stack
2191: PA_DEBUG.set_err_stack('PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment');
2192:
2193: --Log Message

Line 2216: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2212: ,p_new_end_date => l_end_date
2213: ,x_error_message_code => l_error_message_code
2214: ,x_return_status => l_return_status);
2215:
2216: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2217: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2218: ,p_msg_name => l_error_message_code);
2219: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2220:

Line 2219: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

2215:
2216: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2217: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2218: ,p_msg_name => l_error_message_code);
2219: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2220:
2221: END IF;
2222: l_return_status := NULL;
2223:

Line 2224: IF (p_validate_only = FND_API.G_FALSE AND PA_ASSIGNMENTS_PUB.g_error_exists <> FND_API.G_TRUE) THEN

2220:
2221: END IF;
2222: l_return_status := NULL;
2223:
2224: IF (p_validate_only = FND_API.G_FALSE AND PA_ASSIGNMENTS_PUB.g_error_exists <> FND_API.G_TRUE) THEN
2225:
2226: --Log Message
2227: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2228: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment.del_schedules'

Line 2239: ,p_perm_delete => FND_API.G_TRUE --Added for bug 4389372

2235: --
2236:
2237: PA_SCHEDULE_PVT.Delete_Asgn_Schedules
2238: ( p_assignment_id => p_assignment_id
2239: ,p_perm_delete => FND_API.G_TRUE --Added for bug 4389372
2240: ,x_return_status => l_return_status
2241: ,x_msg_count => l_msg_count
2242: ,x_msg_data => l_msg_data
2243: );

Line 2292: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2288:
2289: --
2290: --Delete any related record in history table and any related record in wf table
2291: --
2292: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2293: PA_ASSIGNMENTS_HISTORY_PKG.Delete_By_Assignment ( p_assignment_id =>p_assignment_id
2294: ,x_return_status => x_return_status);
2295:
2296: PA_ASGMT_WFSTD.Delete_Assignment_WF_Records (p_assignment_id => p_assignment_id,

Line 2313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2309: -- Set the excetption Message and the stack
2310: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment'
2311: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2312: --
2313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2314: RAISE; -- This is optional depending on the needs
2315:
2316: END Delete_Staffed_Assignment;
2317: