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_STATUS_PUB dependencies on FND_API

Line 23: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

19: g_task_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- Bug 4218507
20:
21: PROCEDURE UPDATE_PROGRESS
22: ( p_api_version_number IN NUMBER
23: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
24: , p_commit IN VARCHAR2 := FND_API.G_FALSE
25: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
26: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
27: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

20:
21: PROCEDURE UPDATE_PROGRESS
22: ( p_api_version_number IN NUMBER
23: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
24: , p_commit IN VARCHAR2 := FND_API.G_FALSE
25: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
26: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
27: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
28: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 258: p_return_status := FND_API.G_RET_STS_SUCCESS;

254: pa_debug.write(x_Module=>'PA_STATUS_PUB.UPDATE_PROGRESS', x_Msg => 'p_actual_effort_to_date='||p_actual_effort_to_date, x_Log_Level=> 3);
255: END IF;
256:
257:
258: p_return_status := FND_API.G_RET_STS_SUCCESS;
259: -- We have p_populate_pji_tables as paramter because we can not populate PJI tables in Execute update_task_progress
260: -- as we do not have structure version id there.
261: -- If user passes intentionally as N and calls singule update_progress then we will set it as Y
262: IF(G_bulk_load_flag = 'Y') THEN

Line 264: IF FND_API.to_boolean(p_init_msg_list) THEN

260: -- as we do not have structure version id there.
261: -- If user passes intentionally as N and calls singule update_progress then we will set it as Y
262: IF(G_bulk_load_flag = 'Y') THEN
263: l_project_id_out := p_project_id;
264: IF FND_API.to_boolean(p_init_msg_list) THEN
265: FND_MSG_PUB.initialize;
266: END IF;
267: l_populate_pji_tables := p_populate_pji_tables;
268: l_rollup_entire_wbs := p_rollup_entire_wbs;

Line 279: , p_commit => FND_API.G_FALSE --Bug 3754134

275: END IF;
276:
277: PA_STATUS_PUB.Project_Level_Validations
278: ( p_api_version_number => p_api_version_number
279: , p_commit => FND_API.G_FALSE --Bug 3754134
280: , p_init_msg_list => p_init_msg_list
281: , p_msg_count => p_msg_count
282: , p_msg_data => p_msg_data
283: , p_return_status => l_return_status

Line 292: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then

288: IF g1_debug_mode = 'Y' THEN
289: pa_debug.write(x_Module=>'PA_STATUS_PUB.UPDATE_PROGRESS', x_Msg => 'After Project_Level_Validations l_return_status='||l_return_status, x_Log_Level=> 3);
290: END IF;
291:
292: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
293: RAISE FND_API.G_EXC_ERROR;
294: END IF;
295: -- Bug 3627315 : Added code to validate date against the project structure
296: -- it won't be validated for each object

Line 293: RAISE FND_API.G_EXC_ERROR;

289: pa_debug.write(x_Module=>'PA_STATUS_PUB.UPDATE_PROGRESS', x_Msg => 'After Project_Level_Validations l_return_status='||l_return_status, x_Log_Level=> 3);
290: END IF;
291:
292: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
293: RAISE FND_API.G_EXC_ERROR;
294: END IF;
295: -- Bug 3627315 : Added code to validate date against the project structure
296: -- it won't be validated for each object
297: OPEN c_get_structure_information(l_project_id_out, p_structure_type);

Line 305: p_return_status := FND_API.G_RET_STS_ERROR;

301: /*IF PA_PROGRESS_UTILS.CHECK_VALID_AS_OF_DATE(TRUNC(p_as_of_date), l_project_id_out, l_str_id, 'PA_STRUCTURES', l_str_id ) = 'N'
302: THEN
303: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
304: ,p_msg_name => 'PA_TP_INV_AOD2');
305: p_return_status := FND_API.G_RET_STS_ERROR;
306: RAISE FND_API.G_EXC_ERROR;
307: END IF;*/
308: END IF;
309:

Line 306: RAISE FND_API.G_EXC_ERROR;

302: THEN
303: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
304: ,p_msg_name => 'PA_TP_INV_AOD2');
305: p_return_status := FND_API.G_RET_STS_ERROR;
306: RAISE FND_API.G_EXC_ERROR;
307: END IF;*/
308: END IF;
309:
310: -- User can pass task_id or task reference

Line 341: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

337: , p_pm_task_reference => p_pm_task_reference
338: , p_out_task_id => l_task_id_out
339: , p_return_status => l_return_status
340: );
341: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;

Line 342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

338: , p_out_task_id => l_task_id_out
339: , p_return_status => l_return_status
340: );
341: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;
346: l_object_type := 'PA_TASKS';

Line 343: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

339: , p_return_status => l_return_status
340: );
341: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;
346: l_object_type := 'PA_TASKS';
347: l_object_id := l_task_id_out;

Line 344: RAISE FND_API.G_EXC_ERROR;

340: );
341: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;
346: l_object_type := 'PA_TASKS';
347: l_object_id := l_task_id_out;
348: OPEN c_get_element_information(p_project_id, l_object_id, l_object_type, p_structure_type);

Line 360: p_return_status := FND_API.G_RET_STS_ERROR;

356:
357: IF p_object_type <> 'PA_ASSIGNMENTS' AND p_object_type <> 'PA_DELIVERABLES' AND p_object_type <> 'PA_TASKS' AND p_object_type <> 'PA_STRUCTURES' THEN
358: FND_MESSAGE.SET_NAME('PA','PA_PROG_WRONG_OBJ_TYPE');
359: FND_MSG_PUB.add;
360: p_return_status := FND_API.G_RET_STS_ERROR;
361: RAISE FND_API.G_EXC_ERROR;
362: ELSE
363: l_object_type := p_object_type;
364: END IF;

Line 361: RAISE FND_API.G_EXC_ERROR;

357: IF p_object_type <> 'PA_ASSIGNMENTS' AND p_object_type <> 'PA_DELIVERABLES' AND p_object_type <> 'PA_TASKS' AND p_object_type <> 'PA_STRUCTURES' THEN
358: FND_MESSAGE.SET_NAME('PA','PA_PROG_WRONG_OBJ_TYPE');
359: FND_MSG_PUB.add;
360: p_return_status := FND_API.G_RET_STS_ERROR;
361: RAISE FND_API.G_EXC_ERROR;
362: ELSE
363: l_object_type := p_object_type;
364: END IF;
365:

Line 369: p_return_status := FND_API.G_RET_STS_ERROR;

365:
366: IF ((l_object_type = 'PA_ASSIGNMENTS' OR l_object_type = 'PA_DELIVERABLES') AND p_structure_type = 'FINANCIAL') THEN
367: FND_MESSAGE.SET_NAME('PA','PA_PROG_ASGN_DEL_NOT_ALLOW_STR');
368: FND_MSG_PUB.add;
369: p_return_status := FND_API.G_RET_STS_ERROR;
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372:
373: IF p_object_type = 'PA_TASKS' THEN

Line 370: RAISE FND_API.G_EXC_ERROR;

366: IF ((l_object_type = 'PA_ASSIGNMENTS' OR l_object_type = 'PA_DELIVERABLES') AND p_structure_type = 'FINANCIAL') THEN
367: FND_MESSAGE.SET_NAME('PA','PA_PROG_ASGN_DEL_NOT_ALLOW_STR');
368: FND_MSG_PUB.add;
369: p_return_status := FND_API.G_RET_STS_ERROR;
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372:
373: IF p_object_type = 'PA_TASKS' THEN
374: IF ((p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_task_id IS NOT NULL)

Line 385: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

381: , p_pm_task_reference => p_pm_task_reference
382: , p_out_task_id => l_task_id_out
383: , p_return_status => l_return_status
384: );
385: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
388: RAISE FND_API.G_EXC_ERROR;
389: END IF;

Line 386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

382: , p_out_task_id => l_task_id_out
383: , p_return_status => l_return_status
384: );
385: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
388: RAISE FND_API.G_EXC_ERROR;
389: END IF;
390: END IF;

Line 387: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

383: , p_return_status => l_return_status
384: );
385: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
388: RAISE FND_API.G_EXC_ERROR;
389: END IF;
390: END IF;
391: IF ((p_object_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_object_id IS NOT NULL)

Line 388: RAISE FND_API.G_EXC_ERROR;

384: );
385: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
388: RAISE FND_API.G_EXC_ERROR;
389: END IF;
390: END IF;
391: IF ((p_object_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_object_id IS NOT NULL)
392: OR (p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND p_pm_task_reference IS NOT NULL)) THEN

Line 402: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

398: , p_pm_task_reference => p_pm_task_reference
399: , p_out_task_id => l_task_id_out
400: , p_return_status => l_return_status
401: );
402: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
404: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
405: RAISE FND_API.G_EXC_ERROR;
406: END IF;

Line 403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

399: , p_out_task_id => l_task_id_out
400: , p_return_status => l_return_status
401: );
402: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
404: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
405: RAISE FND_API.G_EXC_ERROR;
406: END IF;
407: END IF;

Line 404: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

400: , p_return_status => l_return_status
401: );
402: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
404: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
405: RAISE FND_API.G_EXC_ERROR;
406: END IF;
407: END IF;
408:

Line 405: RAISE FND_API.G_EXC_ERROR;

401: );
402: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
404: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
405: RAISE FND_API.G_EXC_ERROR;
406: END IF;
407: END IF;
408:
409: l_object_type := p_object_type;

Line 422: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

418: ,p_deliverable_id => p_object_id
419: ,p_project_id => l_project_id_out
420: ,p_out_deliverable_id => l_object_id
421: ,p_return_status => l_return_status);
422: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
424: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
425: RAISE FND_API.G_EXC_ERROR;
426: END IF;

Line 423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

419: ,p_project_id => l_project_id_out
420: ,p_out_deliverable_id => l_object_id
421: ,p_return_status => l_return_status);
422: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
424: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
425: RAISE FND_API.G_EXC_ERROR;
426: END IF;
427: --Begin add for BUG 3746647, rtarway

Line 424: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

420: ,p_out_deliverable_id => l_object_id
421: ,p_return_status => l_return_status);
422: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
424: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
425: RAISE FND_API.G_EXC_ERROR;
426: END IF;
427: --Begin add for BUG 3746647, rtarway
428: OPEN c_get_del_ver_id(p_project_id, l_object_id);

Line 425: RAISE FND_API.G_EXC_ERROR;

421: ,p_return_status => l_return_status);
422: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
424: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
425: RAISE FND_API.G_EXC_ERROR;
426: END IF;
427: --Begin add for BUG 3746647, rtarway
428: OPEN c_get_del_ver_id(p_project_id, l_object_id);
429: FETCH c_get_del_ver_id into l_object_version_id;

Line 458: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

454: , p_pm_task_reference => p_pm_task_reference
455: , p_out_task_id => l_task_id_out
456: , p_return_status => l_return_status
457: );
458: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
461: RAISE FND_API.G_EXC_ERROR;
462: END IF;

Line 459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

455: , p_out_task_id => l_task_id_out
456: , p_return_status => l_return_status
457: );
458: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
461: RAISE FND_API.G_EXC_ERROR;
462: END IF;
463: END IF;

Line 460: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

456: , p_return_status => l_return_status
457: );
458: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
461: RAISE FND_API.G_EXC_ERROR;
462: END IF;
463: END IF;
464: --end Added by rtarway for BUG 3872176

Line 461: RAISE FND_API.G_EXC_ERROR;

457: );
458: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
461: RAISE FND_API.G_EXC_ERROR;
462: END IF;
463: END IF;
464: --end Added by rtarway for BUG 3872176
465:

Line 500: p_return_status := FND_API.G_RET_STS_ERROR;

496: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
497: p_msg_name => 'PA_TP_INV_ASSGN_AMG',
498: P_TOKEN1 => 'OBJECT_ID',
499: P_VALUE1 => p_object_id);
500: p_return_status := FND_API.G_RET_STS_ERROR;
501: RAISE FND_API.G_EXC_ERROR;
502: END IF;
503: -- Here if hidden assignment, then we are just returning
504: -- We could have even thrown an erroe message of Invalid Assignment

Line 501: RAISE FND_API.G_EXC_ERROR;

497: p_msg_name => 'PA_TP_INV_ASSGN_AMG',
498: P_TOKEN1 => 'OBJECT_ID',
499: P_VALUE1 => p_object_id);
500: p_return_status := FND_API.G_RET_STS_ERROR;
501: RAISE FND_API.G_EXC_ERROR;
502: END IF;
503: -- Here if hidden assignment, then we are just returning
504: -- We could have even thrown an erroe message of Invalid Assignment
505: -- But we are not doing this right now as MSP is sending all assignments

Line 526: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

522: ,x_pa_task_assignment_id => l_object_id
523: --Added by rtarway for BUG 3872176
524: ,p_published_version_flag => l_published_version_flag
525: ,x_return_status => l_return_status );
526: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
528: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
529: RAISE FND_API.G_EXC_ERROR;
530: END IF;

Line 527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

523: --Added by rtarway for BUG 3872176
524: ,p_published_version_flag => l_published_version_flag
525: ,x_return_status => l_return_status );
526: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
528: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
529: RAISE FND_API.G_EXC_ERROR;
530: END IF;
531: -- Bug 3799841 Returned l_object_id would be resource_assignment_id, we nned to change this to RLM id

Line 528: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

524: ,p_published_version_flag => l_published_version_flag
525: ,x_return_status => l_return_status );
526: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
528: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
529: RAISE FND_API.G_EXC_ERROR;
530: END IF;
531: -- Bug 3799841 Returned l_object_id would be resource_assignment_id, we nned to change this to RLM id
532: OPEN c_get_rlm_id(l_project_id_out, l_object_id, l_structure_version_id, l_task_version_id);

Line 529: RAISE FND_API.G_EXC_ERROR;

525: ,x_return_status => l_return_status );
526: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
528: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
529: RAISE FND_API.G_EXC_ERROR;
530: END IF;
531: -- Bug 3799841 Returned l_object_id would be resource_assignment_id, we nned to change this to RLM id
532: OPEN c_get_rlm_id(l_project_id_out, l_object_id, l_structure_version_id, l_task_version_id);
533: FETCH c_get_rlm_id INTO l_rlm_id;

Line 566: p_return_status := FND_API.G_RET_STS_ERROR;

562: or ( l_structure_version_id is null AND l_object_type <> 'PA_DELIVERABLES' )
563: ) THEN
564: FND_MESSAGE.SET_NAME('PA','PA_TP_INV_PROJ_STRUC_INFO');
565: FND_MSG_PUB.add;
566: p_return_status := FND_API.G_RET_STS_ERROR;
567: RAISE FND_API.G_EXC_ERROR;
568: END IF;
569: -- Bug 4218507 Added g_task_version_id_tbl
570: IF l_object_type = 'PA_DELIVERABLES' AND l_task_version_id IS NOT NULL THEN

Line 567: RAISE FND_API.G_EXC_ERROR;

563: ) THEN
564: FND_MESSAGE.SET_NAME('PA','PA_TP_INV_PROJ_STRUC_INFO');
565: FND_MSG_PUB.add;
566: p_return_status := FND_API.G_RET_STS_ERROR;
567: RAISE FND_API.G_EXC_ERROR;
568: END IF;
569: -- Bug 4218507 Added g_task_version_id_tbl
570: IF l_object_type = 'PA_DELIVERABLES' AND l_task_version_id IS NOT NULL THEN
571: l_unique_record := 'Y';

Line 607: ,p_commit => FND_API.G_FALSE --Bug 3754134

603:
604: PA_PROGRESS_PUB.populate_pji_tab_for_plan(
605: p_api_version => p_api_version_number
606: ,p_init_msg_list => p_init_msg_list
607: ,p_commit => FND_API.G_FALSE --Bug 3754134
608: ,p_calling_module => 'AMG'
609: ,p_project_id => l_project_id_out
610: ,p_structure_version_id => l_structure_version_id
611: ,p_baselined_str_ver_id => l_baselined_str_ver_id --maansari6/28 bug 3673618

Line 617: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then

613: ,x_msg_count => l_msg_count
614: ,x_msg_data => l_msg_data
615: );
616:
617: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
618: RAISE FND_API.G_EXC_ERROR;
619: END IF;
620: END IF;
621:

Line 618: RAISE FND_API.G_EXC_ERROR;

614: ,x_msg_data => l_msg_data
615: );
616:
617: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
618: RAISE FND_API.G_EXC_ERROR;
619: END IF;
620: END IF;
621:
622: IF (p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN

Line 731: p_return_status := FND_API.G_RET_STS_ERROR;

727: IF (l_object_type = 'PA_ASSIGNMENTS' OR l_object_type = 'PA_DELIVERABLES')
728: THEN
729: PA_UTILS.ADD_MESSAGE('PA', 'PA_PROG_BACKDATE_NOT_ALLOW',
730: 'OBJECT_ID', l_object_id);
731: p_return_status := FND_API.G_RET_STS_ERROR;
732: RAISE FND_API.G_EXC_ERROR;
733: END IF;
734: l_progress_mode := 'BACKDATED';
735: END IF;

Line 732: RAISE FND_API.G_EXC_ERROR;

728: THEN
729: PA_UTILS.ADD_MESSAGE('PA', 'PA_PROG_BACKDATE_NOT_ALLOW',
730: 'OBJECT_ID', l_object_id);
731: p_return_status := FND_API.G_RET_STS_ERROR;
732: RAISE FND_API.G_EXC_ERROR;
733: END IF;
734: l_progress_mode := 'BACKDATED';
735: END IF;
736: ELSE

Line 760: p_return_status := FND_API.G_RET_STS_ERROR;

756: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
757: ,p_msg_name => 'PA_TP_INV_AOD2'
758: ,p_token1 => 'AS_OF_DATE'
759: ,p_value1 => l_as_of_date);
760: p_return_status := FND_API.G_RET_STS_ERROR;
761: RAISE FND_API.G_EXC_ERROR;
762: END IF;
763: END IF;
764: if (l_object_type = 'PA_ASSIGNMENTS')then

Line 761: RAISE FND_API.G_EXC_ERROR;

757: ,p_msg_name => 'PA_TP_INV_AOD2'
758: ,p_token1 => 'AS_OF_DATE'
759: ,p_value1 => l_as_of_date);
760: p_return_status := FND_API.G_RET_STS_ERROR;
761: RAISE FND_API.G_EXC_ERROR;
762: END IF;
763: END IF;
764: if (l_object_type = 'PA_ASSIGNMENTS')then
765: IF PA_PROGRESS_UTILS.CHECK_VALID_AS_OF_DATE(TRUNC(l_as_of_date), l_project_id_out, l_object_id, l_object_type, l_task_id ) = 'N'

Line 772: p_return_status := FND_API.G_RET_STS_ERROR;

768: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
769: ,p_msg_name => 'PA_TP_INV_AOD2'
770: ,p_token1 => 'AS_OF_DATE'
771: ,p_value1 => l_as_of_date);
772: p_return_status := FND_API.G_RET_STS_ERROR;
773: RAISE FND_API.G_EXC_ERROR;
774: END IF;
775: END IF;
776: end if;

Line 773: RAISE FND_API.G_EXC_ERROR;

769: ,p_msg_name => 'PA_TP_INV_AOD2'
770: ,p_token1 => 'AS_OF_DATE'
771: ,p_value1 => l_as_of_date);
772: p_return_status := FND_API.G_RET_STS_ERROR;
773: RAISE FND_API.G_EXC_ERROR;
774: END IF;
775: END IF;
776: end if;
777: end if;

Line 820: p_commit => FND_API.G_FALSE, --Bug 3754134 instead passing p_commit pass false

816: if (l_progress_mode = 'FUTURE') then
817: PA_PROGRESS_PUB.UPDATE_PROGRESS(
818: p_api_version => p_api_version_number,
819: p_init_msg_list => p_init_msg_list,
820: p_commit => FND_API.G_FALSE, --Bug 3754134 instead passing p_commit pass false
821: p_action => 'PUBLISH',
822: P_rollup_entire_wbs_flag => l_rollup_entire_wbs,
823: p_progress_mode => l_progress_mode,
824: p_calling_module => 'AMG',

Line 860: p_commit => FND_API.G_FALSE,

856: elsif (l_progress_mode = 'BACKDATED') then
857: PA_PROGRESS_PUB.UPDATE_PROGRESS(
858: p_api_version => p_api_version_number,
859: p_init_msg_list => p_init_msg_list,
860: p_commit => FND_API.G_FALSE,
861: p_action => 'PUBLISH',
862: P_rollup_entire_wbs_flag => l_rollup_entire_wbs,
863: p_progress_mode => l_progress_mode,
864: p_calling_module => 'AMG',

Line 895: IF (p_return_status = FND_API.G_RET_STS_SUCCESS )

891: pa_debug.write(x_Module=>'PA_STATUS_PUB.UPDATE_PROGRESS', x_Msg => 'After call of PA_PROGRESS_PUB.UPDATE_PROGRESS p_return_status='||p_return_status, x_Log_Level=> 3);
892: END IF;
893:
894:
895: IF (p_return_status = FND_API.G_RET_STS_SUCCESS )
896: then
897: IF FND_API.to_boolean(p_commit)
898: THEN
899: COMMIT;

Line 897: IF FND_API.to_boolean(p_commit)

893:
894:
895: IF (p_return_status = FND_API.G_RET_STS_SUCCESS )
896: then
897: IF FND_API.to_boolean(p_commit)
898: THEN
899: COMMIT;
900: END IF;
901: ELSE

Line 910: WHEN FND_API.G_EXC_ERROR THEN

906: );
907: END IF;
908:
909: EXCEPTION
910: WHEN FND_API.G_EXC_ERROR THEN
911:
912: p_return_status := FND_API.G_RET_STS_ERROR;
913: ROLLBACK TO Update_Progress_Pub;
914:

Line 912: p_return_status := FND_API.G_RET_STS_ERROR;

908:
909: EXCEPTION
910: WHEN FND_API.G_EXC_ERROR THEN
911:
912: p_return_status := FND_API.G_RET_STS_ERROR;
913: ROLLBACK TO Update_Progress_Pub;
914:
915: FND_MSG_PUB.Count_And_Get
916: ( p_count => p_msg_count

Line 920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

916: ( p_count => p_msg_count
917: , p_data => p_msg_data
918: );
919:
920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
921:
922: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
923: ROLLBACK TO Update_Progress_Pub;
924:

Line 922: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

918: );
919:
920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
921:
922: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
923: ROLLBACK TO Update_Progress_Pub;
924:
925: FND_MSG_PUB.Count_And_Get
926: ( p_count => p_msg_count

Line 933: p_return_status := FND_API.G_RET_STS_ERROR ;

929:
930:
931: WHEN ROW_ALREADY_LOCKED THEN
932:
933: p_return_status := FND_API.G_RET_STS_ERROR ;
934: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
935: THEN
936: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED');
937: FND_MESSAGE.SET_TOKEN('ENTITY', 'PERCENT_COMPLETE');

Line 948: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

944: );
945:
946: WHEN OTHERS THEN
947:
948: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
949: ROLLBACK TO Update_Progress_Pub;
950:
951: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
952: FND_MSG_PUB.Add_Exc_Msg

Line 987: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

983: --
984:
985: PROCEDURE Update_Earned_Value
986: (p_api_version_number IN NUMBER
987: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
988: , p_commit IN VARCHAR2 := FND_API.G_FALSE
989: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
990: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
991: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

984:
985: PROCEDURE Update_Earned_Value
986: (p_api_version_number IN NUMBER
987: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
988: , p_commit IN VARCHAR2 := FND_API.G_FALSE
989: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
990: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
991: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
992: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 1074: p_return_status := FND_API.G_RET_STS_SUCCESS;

1070: BEGIN
1071:
1072: SAVEPOINT Update_Earned_Value_Pub;
1073:
1074: p_return_status := FND_API.G_RET_STS_SUCCESS;
1075:
1076: IF NOT FND_API.Compatible_API_Call ( l_api_version_number ,
1077: p_api_version_number ,
1078: l_api_name,

Line 1076: IF NOT FND_API.Compatible_API_Call ( l_api_version_number ,

1072: SAVEPOINT Update_Earned_Value_Pub;
1073:
1074: p_return_status := FND_API.G_RET_STS_SUCCESS;
1075:
1076: IF NOT FND_API.Compatible_API_Call ( l_api_version_number ,
1077: p_api_version_number ,
1078: l_api_name,
1079: G_PKG_NAME)
1080: THEN

Line 1081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1077: p_api_version_number ,
1078: l_api_name,
1079: G_PKG_NAME)
1080: THEN
1081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1082: END IF;
1083:
1084: --Uncommented the following code as the fix of Bug 5632178
1085: /* Moved from below for Advanced Project Security Changes. Bug 2471668*/

Line 1095: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1091: , p_return_status => l_return_status
1092: );
1093:
1094:
1095: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;

Line 1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1092: );
1093:
1094:
1095: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;
1100: --End of changes for bug 5632178

Line 1097: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1093:
1094:
1095: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;
1100: --End of changes for bug 5632178
1101:

Line 1098: RAISE FND_API.G_EXC_ERROR;

1094:
1095: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;
1100: --End of changes for bug 5632178
1101:
1102: l_user_id := FND_GLOBAL.User_id;

Line 1126: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1122: p_msg_data => l_msg_data,
1123: p_return_status => l_return_status,
1124: p_function_allowed => l_function_allowed );
1125:
1126: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1127: THEN
1128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1129:
1130: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

Line 1128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1124: p_function_allowed => l_function_allowed );
1125:
1126: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1127: THEN
1128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1129:
1130: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1131: THEN
1132: RAISE FND_API.G_EXC_ERROR;

Line 1130: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

1126: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1127: THEN
1128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1129:
1130: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1131: THEN
1132: RAISE FND_API.G_EXC_ERROR;
1133: END IF;
1134: IF l_function_allowed = 'N' THEN

Line 1132: RAISE FND_API.G_EXC_ERROR;

1128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1129:
1130: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1131: THEN
1132: RAISE FND_API.G_EXC_ERROR;
1133: END IF;
1134: IF l_function_allowed = 'N' THEN
1135: FND_MESSAGE.SET_NAME('PA','PA_FUNCTION_SECURITY_ENFORCED');
1136: FND_MSG_PUB.add;

Line 1137: p_return_status := FND_API.G_RET_STS_ERROR;

1133: END IF;
1134: IF l_function_allowed = 'N' THEN
1135: FND_MESSAGE.SET_NAME('PA','PA_FUNCTION_SECURITY_ENFORCED');
1136: FND_MSG_PUB.add;
1137: p_return_status := FND_API.G_RET_STS_ERROR;
1138: RAISE FND_API.G_EXC_ERROR;
1139: END IF;
1140:
1141: IF FND_API.to_boolean(p_init_msg_list)

Line 1138: RAISE FND_API.G_EXC_ERROR;

1134: IF l_function_allowed = 'N' THEN
1135: FND_MESSAGE.SET_NAME('PA','PA_FUNCTION_SECURITY_ENFORCED');
1136: FND_MSG_PUB.add;
1137: p_return_status := FND_API.G_RET_STS_ERROR;
1138: RAISE FND_API.G_EXC_ERROR;
1139: END IF;
1140:
1141: IF FND_API.to_boolean(p_init_msg_list)
1142: THEN

Line 1141: IF FND_API.to_boolean(p_init_msg_list)

1137: p_return_status := FND_API.G_RET_STS_ERROR;
1138: RAISE FND_API.G_EXC_ERROR;
1139: END IF;
1140:
1141: IF FND_API.to_boolean(p_init_msg_list)
1142: THEN
1143: FND_MSG_PUB.initialize;
1144: END IF;
1145:

Line 1158: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1154: , p_return_status => l_return_status
1155: );
1156:
1157:
1158: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1160: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1161: RAISE FND_API.G_EXC_ERROR;
1162: END IF;

Line 1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1155: );
1156:
1157:
1158: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1160: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1161: RAISE FND_API.G_EXC_ERROR;
1162: END IF;
1163: */

Line 1160: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1156:
1157:
1158: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1160: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1161: RAISE FND_API.G_EXC_ERROR;
1162: END IF;
1163: */
1164:

Line 1161: RAISE FND_API.G_EXC_ERROR;

1157:
1158: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1160: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1161: RAISE FND_API.G_EXC_ERROR;
1162: END IF;
1163: */
1164:
1165: IF pa_security.allow_query (x_project_id => l_project_id_out ) = 'N' THEN

Line 1172: p_return_status := FND_API.G_RET_STS_ERROR;

1168: -- Hence, cannot update the project.Raise error
1169:
1170: FND_MESSAGE.SET_NAME('PA','PA_PROJECT_SECURITY_ENFORCED');
1171: FND_MSG_PUB.add;
1172: p_return_status := FND_API.G_RET_STS_ERROR;
1173: RAISE FND_API.G_EXC_ERROR;
1174: ELSE
1175: -- If the user has query privileges, then check whether
1176: -- update privileges are also available

Line 1173: RAISE FND_API.G_EXC_ERROR;

1169:
1170: FND_MESSAGE.SET_NAME('PA','PA_PROJECT_SECURITY_ENFORCED');
1171: FND_MSG_PUB.add;
1172: p_return_status := FND_API.G_RET_STS_ERROR;
1173: RAISE FND_API.G_EXC_ERROR;
1174: ELSE
1175: -- If the user has query privileges, then check whether
1176: -- update privileges are also available
1177: IF pa_security.allow_update (x_project_id => l_project_id_out ) = 'N'

Line 1185: p_return_status := FND_API.G_RET_STS_ERROR;

1181: -- Hence , raise error
1182:
1183: FND_MESSAGE.SET_NAME('PA','PA_PROJECT_SECURITY_ENFORCED');
1184: FND_MSG_PUB.add;
1185: p_return_status := FND_API.G_RET_STS_ERROR;
1186: RAISE FND_API.G_EXC_ERROR;
1187: END IF;
1188: END IF;
1189:

Line 1186: RAISE FND_API.G_EXC_ERROR;

1182:
1183: FND_MESSAGE.SET_NAME('PA','PA_PROJECT_SECURITY_ENFORCED');
1184: FND_MSG_PUB.add;
1185: p_return_status := FND_API.G_RET_STS_ERROR;
1186: RAISE FND_API.G_EXC_ERROR;
1187: END IF;
1188: END IF;
1189:
1190: IF (p_task_id = 0) THEN

Line 1206: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1202: , p_return_status => l_return_status
1203: );
1204:
1205:
1206: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1208: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1209: RAISE FND_API.G_EXC_ERROR;
1210: END IF;

Line 1207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1203: );
1204:
1205:
1206: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1208: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1209: RAISE FND_API.G_EXC_ERROR;
1210: END IF;
1211: END IF;

Line 1208: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1204:
1205:
1206: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1208: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1209: RAISE FND_API.G_EXC_ERROR;
1210: END IF;
1211: END IF;
1212:

Line 1209: RAISE FND_API.G_EXC_ERROR;

1205:
1206: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1208: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1209: RAISE FND_API.G_EXC_ERROR;
1210: END IF;
1211: END IF;
1212:
1213: -- ---------------------------------------------------------------

Line 1234: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1230: , p_return_status => l_return_status
1231: );
1232:
1233:
1234: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1236: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1237: RAISE FND_API.G_EXC_ERROR;
1238: END IF;

Line 1235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1231: );
1232:
1233:
1234: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1236: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1237: RAISE FND_API.G_EXC_ERROR;
1238: END IF;
1239:

Line 1236: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1232:
1233:
1234: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1236: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1237: RAISE FND_API.G_EXC_ERROR;
1238: END IF;
1239:
1240: END IF;

Line 1237: RAISE FND_API.G_EXC_ERROR;

1233:
1234: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1236: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1237: RAISE FND_API.G_EXC_ERROR;
1238: END IF;
1239:
1240: END IF;
1241:

Line 1249: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1245: p_out_resource_list_id => l_resource_list_id_out,
1246: p_return_status => l_return_status
1247: );
1248:
1249: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1251: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1252: RAISE FND_API.G_EXC_ERROR;
1253: END IF;

Line 1250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1246: p_return_status => l_return_status
1247: );
1248:
1249: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1251: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1252: RAISE FND_API.G_EXC_ERROR;
1253: END IF;
1254:

Line 1251: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1247: );
1248:
1249: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1251: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1252: RAISE FND_API.G_EXC_ERROR;
1253: END IF;
1254:
1255: PA_RESOURCE_PUB.Convert_alias_to_id

Line 1252: RAISE FND_API.G_EXC_ERROR;

1248:
1249: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1251: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1252: RAISE FND_API.G_EXC_ERROR;
1253: END IF;
1254:
1255: PA_RESOURCE_PUB.Convert_alias_to_id
1256: ( p_resource_list_id => l_resource_list_id_out

Line 1262: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1258: , p_out_resource_list_member_id => l_resource_list_member_id_out
1259: , p_return_status => l_return_status
1260: );
1261:
1262: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1264: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1265: RAISE FND_API.G_EXC_ERROR;
1266: END IF;

Line 1263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1259: , p_return_status => l_return_status
1260: );
1261:
1262: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1264: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1265: RAISE FND_API.G_EXC_ERROR;
1266: END IF;
1267:

Line 1264: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1260: );
1261:
1262: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1264: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1265: RAISE FND_API.G_EXC_ERROR;
1266: END IF;
1267:
1268: END IF;

Line 1265: RAISE FND_API.G_EXC_ERROR;

1261:
1262: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1264: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1265: RAISE FND_API.G_EXC_ERROR;
1266: END IF;
1267:
1268: END IF;
1269:

Line 1421: RAISE FND_API.G_EXC_ERROR;

1417: THEN
1418: FND_MESSAGE.SET_NAME('PA','PA_EV_INSERT_ERROR');
1419: FND_MSG_PUB.Add;
1420: END IF;
1421: RAISE FND_API.G_EXC_ERROR;
1422: END IF;
1423:
1424: IF FND_API.to_boolean(p_commit)
1425: THEN

Line 1424: IF FND_API.to_boolean(p_commit)

1420: END IF;
1421: RAISE FND_API.G_EXC_ERROR;
1422: END IF;
1423:
1424: IF FND_API.to_boolean(p_commit)
1425: THEN
1426: COMMIT;
1427: END IF;
1428:

Line 1431: WHEN FND_API.G_EXC_ERROR THEN

1427: END IF;
1428:
1429:
1430: EXCEPTION
1431: WHEN FND_API.G_EXC_ERROR THEN
1432: p_return_status := FND_API.G_RET_STS_ERROR;
1433: ROLLBACK TO Update_Earned_Value_Pub;
1434:
1435: FND_MSG_PUB.Count_And_Get

Line 1432: p_return_status := FND_API.G_RET_STS_ERROR;

1428:
1429:
1430: EXCEPTION
1431: WHEN FND_API.G_EXC_ERROR THEN
1432: p_return_status := FND_API.G_RET_STS_ERROR;
1433: ROLLBACK TO Update_Earned_Value_Pub;
1434:
1435: FND_MSG_PUB.Count_And_Get
1436: ( p_count => p_msg_count

Line 1440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1436: ( p_count => p_msg_count
1437: ,p_data => p_msg_data
1438: );
1439:
1440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1441: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1442: ROLLBACK TO Update_Earned_Value_Pub;
1443:
1444: FND_MSG_PUB.Count_And_Get

Line 1441: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1437: ,p_data => p_msg_data
1438: );
1439:
1440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1441: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1442: ROLLBACK TO Update_Earned_Value_Pub;
1443:
1444: FND_MSG_PUB.Count_And_Get
1445: ( p_count => p_msg_count

Line 1451: p_return_status := FND_API.G_RET_STS_ERROR ;

1447: );
1448:
1449: WHEN ROW_ALREADY_LOCKED THEN
1450:
1451: p_return_status := FND_API.G_RET_STS_ERROR ;
1452:
1453: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1454: THEN
1455: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED');

Line 1465: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1461:
1462:
1463: WHEN OTHERS THEN
1464:
1465: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1466: ROLLBACK TO Update_Earned_Value_Pub;
1467:
1468: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1469: FND_MSG_PUB.Add_Exc_Msg

Line 1485: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1481: END Update_Earned_Value;
1482:
1483: PROCEDURE Init_Update_Task_Progress
1484: (p_api_version_number IN NUMBER
1485: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1486: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1487: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1488: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1489: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

1482:
1483: PROCEDURE Init_Update_Task_Progress
1484: (p_api_version_number IN NUMBER
1485: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1486: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1487: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1488: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1489: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1490: )

Line 1495: IF FND_API.to_boolean(p_init_msg_list)

1491: IS
1492: l_api_name CONSTANT VARCHAR2(30) := 'Init_Update_Task_Progress';
1493:
1494: BEGIN
1495: IF FND_API.to_boolean(p_init_msg_list)
1496: THEN
1497: FND_MSG_PUB.initialize;
1498: END IF;
1499:

Line 1500: p_return_status := FND_API.G_RET_STS_SUCCESS;

1496: THEN
1497: FND_MSG_PUB.initialize;
1498: END IF;
1499:
1500: p_return_status := FND_API.G_RET_STS_SUCCESS;
1501:
1502: G_TASK_PROGRESS_in_tbl.delete;
1503: G_TASK_PROGRESS_tbl_count := 0;
1504:

Line 1505: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) then

1501:
1502: G_TASK_PROGRESS_in_tbl.delete;
1503: G_TASK_PROGRESS_tbl_count := 0;
1504:
1505: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) then
1506: FND_MSG_PUB.Count_And_Get
1507: ( p_count => p_msg_count
1508: ,p_data => p_msg_data
1509: );

Line 1512: WHEN FND_API.G_EXC_ERROR THEN

1508: ,p_data => p_msg_data
1509: );
1510: END IF;
1511: EXCEPTION
1512: WHEN FND_API.G_EXC_ERROR THEN
1513: p_return_status := FND_API.G_RET_STS_ERROR;
1514: FND_MSG_PUB.Count_And_Get
1515: ( p_count => p_msg_count
1516: ,p_data => p_msg_data

Line 1513: p_return_status := FND_API.G_RET_STS_ERROR;

1509: );
1510: END IF;
1511: EXCEPTION
1512: WHEN FND_API.G_EXC_ERROR THEN
1513: p_return_status := FND_API.G_RET_STS_ERROR;
1514: FND_MSG_PUB.Count_And_Get
1515: ( p_count => p_msg_count
1516: ,p_data => p_msg_data
1517: );

Line 1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1514: FND_MSG_PUB.Count_And_Get
1515: ( p_count => p_msg_count
1516: ,p_data => p_msg_data
1517: );
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1520: FND_MSG_PUB.Count_And_Get
1521: ( p_count => p_msg_count
1522: ,p_data => p_msg_data

Line 1519: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1515: ( p_count => p_msg_count
1516: ,p_data => p_msg_data
1517: );
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1520: FND_MSG_PUB.Count_And_Get
1521: ( p_count => p_msg_count
1522: ,p_data => p_msg_data
1523: );

Line 1525: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1521: ( p_count => p_msg_count
1522: ,p_data => p_msg_data
1523: );
1524: WHEN OTHERS THEN
1525: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1526: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1527: FND_MSG_PUB.Add_Exc_Msg
1528: ( G_PKG_NAME
1529: , l_api_name

Line 1541: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1537: END Init_Update_Task_Progress;
1538:
1539: PROCEDURE Load_Task_Progress
1540: (p_api_version_number IN NUMBER
1541: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1542: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1543: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1544: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1545: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

1538:
1539: PROCEDURE Load_Task_Progress
1540: (p_api_version_number IN NUMBER
1541: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1542: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1543: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1544: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1545: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1546: ,p_structure_type IN VARCHAR2 := 'FINANCIAL'

Line 1618: IF FND_API.to_boolean(p_init_msg_list)

1614: IF g1_debug_mode = 'Y' THEN
1615: pa_debug.init_err_stack ('PA_PROGRESS_PUB.LOAD_TASK_PROGRESS');
1616: END IF;
1617:
1618: IF FND_API.to_boolean(p_init_msg_list)
1619: THEN
1620: FND_MSG_PUB.initialize;
1621: END IF;
1622:

Line 1623: p_return_status := FND_API.G_RET_STS_SUCCESS;

1619: THEN
1620: FND_MSG_PUB.initialize;
1621: END IF;
1622:
1623: p_return_status := FND_API.G_RET_STS_SUCCESS;
1624:
1625: IF(G_TASK_PROGRESS_tbl_count = 0) THEN
1626: G_PROJECT_ID := P_PROJECT_ID;
1627: G_pm_project_reference := P_pm_project_reference;

Line 1984: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) then

1980: -- G_TASK_PROGRESS_in_tbl(G_TASK_PROGRESS_tbl_count).PROGRESS_MODE := l_progress_mode;
1981:
1982: END LOOP;
1983:
1984: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) then
1985: FND_MSG_PUB.Count_And_Get
1986: ( p_count => p_msg_count
1987: ,p_data => p_msg_data
1988: );

Line 1991: WHEN FND_API.G_EXC_ERROR THEN

1987: ,p_data => p_msg_data
1988: );
1989: END IF;
1990: EXCEPTION
1991: WHEN FND_API.G_EXC_ERROR THEN
1992: p_return_status := FND_API.G_RET_STS_ERROR;
1993: FND_MSG_PUB.Count_And_Get
1994: ( p_count => p_msg_count
1995: ,p_data => p_msg_data

Line 1992: p_return_status := FND_API.G_RET_STS_ERROR;

1988: );
1989: END IF;
1990: EXCEPTION
1991: WHEN FND_API.G_EXC_ERROR THEN
1992: p_return_status := FND_API.G_RET_STS_ERROR;
1993: FND_MSG_PUB.Count_And_Get
1994: ( p_count => p_msg_count
1995: ,p_data => p_msg_data
1996: );

Line 1997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1993: FND_MSG_PUB.Count_And_Get
1994: ( p_count => p_msg_count
1995: ,p_data => p_msg_data
1996: );
1997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1998: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1999: FND_MSG_PUB.Count_And_Get
2000: ( p_count => p_msg_count
2001: ,p_data => p_msg_data

Line 1998: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1994: ( p_count => p_msg_count
1995: ,p_data => p_msg_data
1996: );
1997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1998: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1999: FND_MSG_PUB.Count_And_Get
2000: ( p_count => p_msg_count
2001: ,p_data => p_msg_data
2002: );

Line 2004: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2000: ( p_count => p_msg_count
2001: ,p_data => p_msg_data
2002: );
2003: WHEN OTHERS THEN
2004: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2005: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2006: FND_MSG_PUB.Add_Exc_Msg
2007: ( G_PKG_NAME
2008: , l_api_name

Line 2019: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2015: END Load_Task_Progress;
2016:
2017: PROCEDURE Execute_Update_Task_Progress
2018: ( p_api_version_number IN NUMBER
2019: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2020: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2021: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2022: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2023: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

2016:
2017: PROCEDURE Execute_Update_Task_Progress
2018: ( p_api_version_number IN NUMBER
2019: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2020: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2021: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2022: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2023: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2024: )

Line 2138: IF FND_API.to_boolean(p_init_msg_list)

2134: l_progress_err_index NUMBER := 0;
2135:
2136: BEGIN
2137:
2138: IF FND_API.to_boolean(p_init_msg_list)
2139: THEN
2140: FND_MSG_PUB.initialize;
2141: END IF;
2142: g1_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

Line 2146: p_return_status := FND_API.G_RET_STS_SUCCESS;

2142: g1_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
2143: savepoint Execute_Update_Task_Progress;
2144:
2145:
2146: p_return_status := FND_API.G_RET_STS_SUCCESS;
2147: -- Bug 3606627 : Added call of PA_STATUS_PUB.Project_Level_Validations
2148: PA_STATUS_PUB.Project_Level_Validations
2149: (p_api_version_number => p_api_version_number
2150: ,p_msg_count => p_msg_count

Line 2157: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then

2153: , p_project_id => G_PROJECT_ID
2154: , p_pm_project_reference => G_pm_project_reference
2155: , p_project_id_out => l_project_id_out
2156: );
2157: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2158: p_return_status := l_return_status;
2159: RAISE FND_API.G_EXC_ERROR;
2160: END IF;
2161:

Line 2159: RAISE FND_API.G_EXC_ERROR;

2155: , p_project_id_out => l_project_id_out
2156: );
2157: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2158: p_return_status := l_return_status;
2159: RAISE FND_API.G_EXC_ERROR;
2160: END IF;
2161:
2162: G_PROJECT_ID := l_project_id_out;
2163:

Line 2168: p_return_status := FND_API.G_RET_STS_ERROR;

2164:
2165: IF(G_TASK_PROGRESS_tbl_count = 0) THEN
2166: FND_MESSAGE.SET_NAME('PA','PA_NO_TASK_PROGRESS_UPDATE');
2167: FND_MSG_PUB.add;
2168: p_return_status := FND_API.G_RET_STS_ERROR;
2169: RAISE FND_API.G_EXC_ERROR;
2170: -- Bug 3606627 : Changed the following if condition to >=1 from =1
2171: ELSIF(G_TASK_PROGRESS_tbl_count >= 1) THEN
2172: --G_bulk_load_flag := 'N'; Bug 3606627

Line 2169: RAISE FND_API.G_EXC_ERROR;

2165: IF(G_TASK_PROGRESS_tbl_count = 0) THEN
2166: FND_MESSAGE.SET_NAME('PA','PA_NO_TASK_PROGRESS_UPDATE');
2167: FND_MSG_PUB.add;
2168: p_return_status := FND_API.G_RET_STS_ERROR;
2169: RAISE FND_API.G_EXC_ERROR;
2170: -- Bug 3606627 : Changed the following if condition to >=1 from =1
2171: ELSIF(G_TASK_PROGRESS_tbl_count >= 1) THEN
2172: --G_bulk_load_flag := 'N'; Bug 3606627
2173: G_bulk_load_flag := 'Y'; -- Bug 3606627

Line 2188: p_return_status := FND_API.G_RET_STS_ERROR;

2184: /* IF PA_PROGRESS_UTILS.CHECK_VALID_AS_OF_DATE( TRUNC(g_as_of_date), l_project_id_out, l_structure_id, 'PA_STRUCTURES', l_structure_id --Bug 3764224 ) = 'N'
2185: THEN
2186: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2187: ,p_msg_name => 'PA_TP_INV_AOD2');
2188: p_return_status := FND_API.G_RET_STS_ERROR;
2189: RAISE FND_API.G_EXC_ERROR;
2190: END IF; */
2191:
2192: l_baselined_str_ver_id := PA_PROJECT_STRUCTURE_UTILS.Get_Baseline_Struct_Ver(l_project_id_out); --maansari6/28 bug 3673618

Line 2189: RAISE FND_API.G_EXC_ERROR;

2185: THEN
2186: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2187: ,p_msg_name => 'PA_TP_INV_AOD2');
2188: p_return_status := FND_API.G_RET_STS_ERROR;
2189: RAISE FND_API.G_EXC_ERROR;
2190: END IF; */
2191:
2192: l_baselined_str_ver_id := PA_PROJECT_STRUCTURE_UTILS.Get_Baseline_Struct_Ver(l_project_id_out); --maansari6/28 bug 3673618
2193:

Line 2205: ,p_commit => FND_API.G_FALSE --Bug 3754134

2201: AND l_baselined_str_ver_id IS NOT NULL THEN --maansari6/28 bug 3673618
2202: PA_PROGRESS_PUB.populate_pji_tab_for_plan(
2203: p_api_version => p_api_version_number
2204: ,p_init_msg_list => p_init_msg_list
2205: ,p_commit => FND_API.G_FALSE --Bug 3754134
2206: ,p_calling_module => 'AMG'
2207: ,p_project_id => l_project_id_out
2208: ,p_structure_version_id => l_structure_version_id
2209: ,p_baselined_str_ver_id => l_baselined_str_ver_id --maansari6/28 bug 3673618

Line 2215: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then

2211: ,x_msg_count => l_msg_count
2212: ,x_msg_data => l_msg_data
2213: );
2214:
2215: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2216: RAISE FND_API.G_EXC_ERROR;
2217: END IF;
2218: END IF;
2219: g_task_version_id_tbl.delete; -- Bug 4218507

Line 2216: RAISE FND_API.G_EXC_ERROR;

2212: ,x_msg_data => l_msg_data
2213: );
2214:
2215: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2216: RAISE FND_API.G_EXC_ERROR;
2217: END IF;
2218: END IF;
2219: g_task_version_id_tbl.delete; -- Bug 4218507
2220: i := G_TASK_PROGRESS_in_tbl.first;

Line 2315: ,p_commit => FND_API.G_FALSE -- Bug 3754134 Added this

2311: PA_STATUS_PUB.UPDATE_PROGRESS
2312: (p_api_version_number => p_api_version_number
2313: ,p_msg_count => l_msg_count
2314: ,p_msg_data => l_msg_data
2315: ,p_commit => FND_API.G_FALSE -- Bug 3754134 Added this
2316: ,p_return_status => l_return_status
2317: , p_project_id => l_project_id_out
2318: , p_pm_project_reference => g_pm_project_reference
2319: , p_task_id => l_task_id

Line 2349: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2345: , p_populate_pji_tables => 'N' -- bug 3606627
2346: , p_rollup_entire_wbs => 'Y' -- bug 3606627
2347: );
2348:
2349: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2350: p_return_status := l_return_status;
2351:
2352: FND_MSG_PUB.get (
2353: p_msg_index => l_msg_count,

Line 2354: p_encoded => FND_API.G_FALSE,

2350: p_return_status := l_return_status;
2351:
2352: FND_MSG_PUB.get (
2353: p_msg_index => l_msg_count,
2354: p_encoded => FND_API.G_FALSE,
2355: p_data => l_data,
2356: p_msg_index_out => l_msg_index_out );
2357:
2358: IF l_data IS NOT NULL THEN

Line 2413: p_return_status := FND_API.G_RET_STS_ERROR;

2409: ,p_token1 => 'TASK_NAME'
2410: ,p_value1 => G_TASK_PROGRESS_in_tbl(i).TASK_NAME
2411: ,p_token2 => 'TASK_NUMBER'
2412: ,p_value2 => G_TASK_PROGRESS_in_tbl(i).TASK_NUMBER);
2413: p_return_status := FND_API.G_RET_STS_ERROR;
2414: RAISE FND_API.G_EXC_ERROR;
2415: ELSE
2416: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2417: ,p_msg_name => 'PA_TP_STATUS_NOT_DEFINED_AMG'

Line 2414: RAISE FND_API.G_EXC_ERROR;

2410: ,p_value1 => G_TASK_PROGRESS_in_tbl(i).TASK_NAME
2411: ,p_token2 => 'TASK_NUMBER'
2412: ,p_value2 => G_TASK_PROGRESS_in_tbl(i).TASK_NUMBER);
2413: p_return_status := FND_API.G_RET_STS_ERROR;
2414: RAISE FND_API.G_EXC_ERROR;
2415: ELSE
2416: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2417: ,p_msg_name => 'PA_TP_STATUS_NOT_DEFINED_AMG'
2418: ,p_token1 => 'TASK_ID'

Line 2421: p_return_status := FND_API.G_RET_STS_ERROR;

2417: ,p_msg_name => 'PA_TP_STATUS_NOT_DEFINED_AMG'
2418: ,p_token1 => 'TASK_ID'
2419: ,p_value1 => G_TASK_PROGRESS_in_tbl(i).TASK_ID
2420: );
2421: p_return_status := FND_API.G_RET_STS_ERROR;
2422: RAISE FND_API.G_EXC_ERROR;
2423: END IF;
2424:
2425: * Commenting ends for bug 10146713 */

Line 2422: RAISE FND_API.G_EXC_ERROR;

2418: ,p_token1 => 'TASK_ID'
2419: ,p_value1 => G_TASK_PROGRESS_in_tbl(i).TASK_ID
2420: );
2421: p_return_status := FND_API.G_RET_STS_ERROR;
2422: RAISE FND_API.G_EXC_ERROR;
2423: END IF;
2424:
2425: * Commenting ends for bug 10146713 */
2426:

Line 2439: p_return_status := FND_API.G_RET_STS_ERROR;

2435: ELSE
2436: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2437: ,p_msg_name => 'PA_TP_STATUS_NOT_DEFINED' --Bug 6530100 MSP Messages
2438: );
2439: p_return_status := FND_API.G_RET_STS_ERROR;
2440: RAISE FND_API.G_EXC_ERROR;
2441: END IF;
2442: /* New code for Bug 10146713 ends */
2443:

Line 2440: RAISE FND_API.G_EXC_ERROR;

2436: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
2437: ,p_msg_name => 'PA_TP_STATUS_NOT_DEFINED' --Bug 6530100 MSP Messages
2438: );
2439: p_return_status := FND_API.G_RET_STS_ERROR;
2440: RAISE FND_API.G_EXC_ERROR;
2441: END IF;
2442: /* New code for Bug 10146713 ends */
2443:
2444: END IF;

Line 2469: RAISE FND_API.G_EXC_ERROR;

2465: END IF;
2466:
2467: IF (l_raise_exception = 'E' )
2468: THEN
2469: RAISE FND_API.G_EXC_ERROR;
2470: ELSIF l_raise_exception = 'U'
2471: THEN
2472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2473: END IF;

Line 2472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2468: THEN
2469: RAISE FND_API.G_EXC_ERROR;
2470: ELSIF l_raise_exception = 'U'
2471: THEN
2472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2473: END IF;
2474: --maansari6/28 bug 3673618
2475:
2476:

Line 2530: RAISE FND_API.G_EXC_ERROR;

2526: WHEN OTHERS THEN
2527: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STATUS_PUB',
2528: p_procedure_name => 'execute_update_progress',
2529: p_error_text => SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP:'||SQLERRM,1,120));
2530: RAISE FND_API.G_EXC_ERROR;
2531: END;
2532: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2533: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2534: p_msg_name => l_msg_data);

Line 2532: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2528: p_procedure_name => 'execute_update_progress',
2529: p_error_text => SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP:'||SQLERRM,1,120));
2530: RAISE FND_API.G_EXC_ERROR;
2531: END;
2532: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2533: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2534: p_msg_name => l_msg_data);
2535: p_return_status := 'E';
2536: RAISE FND_API.G_EXC_ERROR;

Line 2536: RAISE FND_API.G_EXC_ERROR;

2532: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2533: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2534: p_msg_name => l_msg_data);
2535: p_return_status := 'E';
2536: RAISE FND_API.G_EXC_ERROR;
2537: END IF;
2538: END IF;
2539: -- Bug 4186007 Begin
2540: BEGIN

Line 2548: RAISE FND_API.G_EXC_ERROR;

2544: WHEN OTHERS THEN
2545: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STATUS_PUB',
2546: p_procedure_name => 'EXECUTE_UPDATE_TASK_PROGRESS',
2547: p_error_text => SUBSTRB('Call of PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE Failed:'||SQLERRM,1,120));
2548: RAISE FND_API.G_EXC_ERROR;
2549: END;
2550:
2551: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2552: p_return_status := l_return_status;

Line 2551: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then

2547: p_error_text => SUBSTRB('Call of PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE Failed:'||SQLERRM,1,120));
2548: RAISE FND_API.G_EXC_ERROR;
2549: END;
2550:
2551: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2552: p_return_status := l_return_status;
2553: RAISE FND_API.G_EXC_ERROR;
2554: END IF;
2555:

Line 2553: RAISE FND_API.G_EXC_ERROR;

2549: END;
2550:
2551: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2552: p_return_status := l_return_status;
2553: RAISE FND_API.G_EXC_ERROR;
2554: END IF;
2555:
2556:
2557: l_base_struct_ver_id := pa_project_structure_utils.get_baseline_struct_ver(l_project_id_out);

Line 2590: RAISE FND_API.G_EXC_ERROR;

2586: WHEN OTHERS THEN
2587: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STATUS_PUB',
2588: p_procedure_name => 'EXECUTE_UPDATE_TASK_PROGRESS',
2589: p_error_text => SUBSTRB('Call of PJI_FM_XBS_ACCUM_UTILS.populate_workplan_data: failed'||SQLERRM,1,120));
2590: RAISE FND_API.G_EXC_ERROR;
2591: END;
2592: */
2593:
2594: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then

Line 2594: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then

2590: RAISE FND_API.G_EXC_ERROR;
2591: END;
2592: */
2593:
2594: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2595: p_return_status := l_return_status;
2596: RAISE FND_API.G_EXC_ERROR;
2597: END IF;
2598:

Line 2596: RAISE FND_API.G_EXC_ERROR;

2592: */
2593:
2594: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2595: p_return_status := l_return_status;
2596: RAISE FND_API.G_EXC_ERROR;
2597: END IF;
2598:
2599: -- Bug 4186007 End
2600:

Line 2604: ,p_commit => FND_API.G_FALSE -- Bug 3754134 instead of passing p_commit passing fasle

2600:
2601:
2602: PA_PROGRESS_PVT.ROLLUP_PROGRESS_PVT(
2603: p_init_msg_list => p_init_msg_list
2604: ,p_commit => FND_API.G_FALSE -- Bug 3754134 instead of passing p_commit passing fasle
2605: ,p_calling_module => 'AMG' --bug 3673618
2606: ,p_project_id => l_project_id_out
2607: ,p_structure_version_id => l_structure_version_id
2608: ,p_as_of_date => trunc(g_as_of_date) -- 5294838

Line 2618: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then

2614: ,x_return_status => l_return_status
2615: ,x_msg_count => l_msg_count
2616: ,x_msg_data => l_msg_data);
2617:
2618: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2619: p_return_status := l_return_status;
2620: RAISE FND_API.G_EXC_ERROR;
2621: END IF;
2622:

Line 2620: RAISE FND_API.G_EXC_ERROR;

2616: ,x_msg_data => l_msg_data);
2617:
2618: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2619: p_return_status := l_return_status;
2620: RAISE FND_API.G_EXC_ERROR;
2621: END IF;
2622:
2623: PA_PROGRESS_PUB.ROLLUP_FUTURE_PROGRESS_PVT(
2624: p_project_id => l_project_id_out

Line 2641: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then

2637: ,x_msg_count => l_msg_count
2638: ,x_msg_data => l_msg_data
2639: );
2640:
2641: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2642: p_return_status := l_return_status;
2643: RAISE FND_API.G_EXC_ERROR;
2644: END IF;
2645: -- Bug 3606627 End

Line 2643: RAISE FND_API.G_EXC_ERROR;

2639: );
2640:
2641: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2642: p_return_status := l_return_status;
2643: RAISE FND_API.G_EXC_ERROR;
2644: END IF;
2645: -- Bug 3606627 End
2646: END IF; --(G_TASK_PROGRESS_tbl_count >= 1) THEN Bug 3606627 : Added Ebd IF here itself
2647: -- BUG 4080922 Adding Program Rollup Code : rtarway

Line 2671: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

2667: IF g1_debug_mode = 'Y' THEN
2668: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_PROGRESS', x_Msg => 'After Calling program_rollup_pvt l_return_status='||l_return_status, x_Log_Level=> 3);
2669: END IF;
2670:
2671: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2672: p_return_status := l_return_status;
2673: RAISE FND_API.G_EXC_ERROR;
2674: END IF;
2675:

Line 2673: RAISE FND_API.G_EXC_ERROR;

2669: END IF;
2670:
2671: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2672: p_return_status := l_return_status;
2673: RAISE FND_API.G_EXC_ERROR;
2674: END IF;
2675:
2676: END IF;
2677: -- End Add 4080922

Line 2692: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then

2688: , p_project_id => G_PROJECT_ID
2689: , p_pm_project_reference => G_pm_project_reference
2690: , p_project_id_out => l_project_id_out
2691: );
2692: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2693: p_return_status := l_return_status;
2694: RAISE FND_API.G_EXC_ERROR;
2695: END IF;
2696: G_PROJECT_ID := l_project_id_out;

Line 2694: RAISE FND_API.G_EXC_ERROR;

2690: , p_project_id_out => l_project_id_out
2691: );
2692: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2693: p_return_status := l_return_status;
2694: RAISE FND_API.G_EXC_ERROR;
2695: END IF;
2696: G_PROJECT_ID := l_project_id_out;
2697:
2698: l_structure_version_id := PA_PROJECT_STRUCTURE_UTILS.get_latest_wp_version(l_project_id_out);

Line 2730: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then

2726: p_return_status => l_return_status,
2727: p_msg_count => p_msg_count,
2728: p_msg_data => p_msg_data
2729: );
2730: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2731: p_return_status := l_return_status;
2732: RAISE FND_API.G_EXC_ERROR;
2733: END IF;
2734:

Line 2732: RAISE FND_API.G_EXC_ERROR;

2728: p_msg_data => p_msg_data
2729: );
2730: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2731: p_return_status := l_return_status;
2732: RAISE FND_API.G_EXC_ERROR;
2733: END IF;
2734:
2735: IF(l_rollup_flag = 'Y') then
2736: PA_PROGRESS_PUB.ROLLUP_TASK_PROGRESSES(

Line 2748: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then

2744: p_return_status => l_return_status,
2745: p_msg_count => p_msg_count,
2746: p_msg_data => p_msg_data
2747: );
2748: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2749: p_return_status := l_return_status;
2750: RAISE FND_API.G_EXC_ERROR;
2751: END IF;
2752: */

Line 2750: RAISE FND_API.G_EXC_ERROR;

2746: p_msg_data => p_msg_data
2747: );
2748: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2749: p_return_status := l_return_status;
2750: RAISE FND_API.G_EXC_ERROR;
2751: END IF;
2752: */
2753:
2754:

Line 2771: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then

2767: p_return_status => l_return_status,
2768: p_msg_count => p_msg_count,
2769: p_msg_data => p_msg_data
2770: );
2771: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2772: p_return_status := l_return_status;
2773: RAISE FND_API.G_EXC_ERROR;
2774: END IF;
2775:

Line 2773: RAISE FND_API.G_EXC_ERROR;

2769: p_msg_data => p_msg_data
2770: );
2771: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2772: p_return_status := l_return_status;
2773: RAISE FND_API.G_EXC_ERROR;
2774: END IF;
2775:
2776: Commented out for Progress Management Changes. Bug # 3420093. */
2777:

Line 2794: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then

2790: x_return_status => l_return_status,
2791: x_msg_count => p_msg_count,
2792: x_msg_data => p_msg_data
2793: );
2794: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2795: p_return_status := l_return_status;
2796: RAISE FND_API.G_EXC_ERROR;
2797: END IF;
2798: */

Line 2796: RAISE FND_API.G_EXC_ERROR;

2792: x_msg_data => p_msg_data
2793: );
2794: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2795: p_return_status := l_return_status;
2796: RAISE FND_API.G_EXC_ERROR;
2797: END IF;
2798: */
2799:
2800: /* Progress Management Changes. Bug # 3420093. */

Line 2848: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then

2844: ,x_return_status => l_return_status
2845: ,x_msg_count => l_msg_count
2846: ,x_msg_data => l_msg_data
2847: );
2848: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2849: p_return_status := l_return_status;
2850: RAISE FND_API.G_EXC_ERROR;
2851: END IF;
2852:

Line 2850: RAISE FND_API.G_EXC_ERROR;

2846: ,x_msg_data => l_msg_data
2847: );
2848: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2849: p_return_status := l_return_status;
2850: RAISE FND_API.G_EXC_ERROR;
2851: END IF;
2852:
2853: IF ( NVL( l_lowest_level_task, 'N' ) = 'Y' )
2854: THEN

Line 2861: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

2857: ,p_element_version_id => l_object_version_id
2858: ,x_return_status => l_return_status
2859: ,x_msg_count => l_msg_count
2860: ,x_msg_data => l_msg_data );
2861: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
2862: THEN
2863: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2864: p_msg_name => l_msg_data
2865: );

Line 2868: RAISE FND_API.G_EXC_ERROR;

2864: p_msg_name => l_msg_data
2865: );
2866: p_msg_data := l_msg_data;
2867: p_return_status := 'E';
2868: RAISE FND_API.G_EXC_ERROR;
2869: END IF;
2870: begin
2871: Select ppev1.proj_element_id
2872: into l_structure_id

Line 2885: p_validate_only => FND_API.G_FALSE

2881: AND
2882: (PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_project_id_out) = 'Y')) THEN
2883: --copy to transaction dates
2884: PA_PROJECT_DATES_PUB.COPY_PROJECT_DATES(
2885: p_validate_only => FND_API.G_FALSE
2886: ,p_project_id => l_project_id_out
2887: ,x_return_status => l_return_status
2888: ,x_msg_count => l_msg_count
2889: ,x_msg_data => l_msg_data);

Line 2916: IF (p_return_status = FND_API.G_RET_STS_SUCCESS )

2912: and nvl(COMPLETED_PERCENTAGE,0) = nvl(eff_rollup_percent_comp, -1);
2913:
2914: /* bug 6917961 */
2915:
2916: IF (p_return_status = FND_API.G_RET_STS_SUCCESS )
2917: then
2918: IF FND_API.to_boolean(p_commit)
2919: THEN
2920: COMMIT;

Line 2918: IF FND_API.to_boolean(p_commit)

2914: /* bug 6917961 */
2915:
2916: IF (p_return_status = FND_API.G_RET_STS_SUCCESS )
2917: then
2918: IF FND_API.to_boolean(p_commit)
2919: THEN
2920: COMMIT;
2921: END IF;
2922: ELSE

Line 2933: WHEN FND_API.G_EXC_ERROR THEN

2929: G_bulk_load_flag :='N';
2930: G_TASK_PROGRESS_in_tbl.delete;
2931: G_TASK_PROGRESS_tbl_count := 0;
2932: EXCEPTION
2933: WHEN FND_API.G_EXC_ERROR THEN
2934: p_return_status := FND_API.G_RET_STS_ERROR;
2935: ROLLBACK TO Execute_Update_Task_Progress;
2936: FND_MSG_PUB.Count_And_Get
2937: ( p_count => p_msg_count

Line 2934: p_return_status := FND_API.G_RET_STS_ERROR;

2930: G_TASK_PROGRESS_in_tbl.delete;
2931: G_TASK_PROGRESS_tbl_count := 0;
2932: EXCEPTION
2933: WHEN FND_API.G_EXC_ERROR THEN
2934: p_return_status := FND_API.G_RET_STS_ERROR;
2935: ROLLBACK TO Execute_Update_Task_Progress;
2936: FND_MSG_PUB.Count_And_Get
2937: ( p_count => p_msg_count
2938: ,p_data => p_msg_data

Line 2943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2939: );
2940: G_bulk_load_flag :='N';
2941: G_TASK_PROGRESS_in_tbl.delete;
2942: G_TASK_PROGRESS_tbl_count := 0;
2943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2944: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2945: ROLLBACK TO Execute_Update_Task_Progress;
2946: FND_MSG_PUB.Count_And_Get
2947: ( p_count => p_msg_count

Line 2944: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2940: G_bulk_load_flag :='N';
2941: G_TASK_PROGRESS_in_tbl.delete;
2942: G_TASK_PROGRESS_tbl_count := 0;
2943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2944: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2945: ROLLBACK TO Execute_Update_Task_Progress;
2946: FND_MSG_PUB.Count_And_Get
2947: ( p_count => p_msg_count
2948: ,p_data => p_msg_data

Line 2954: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2950: G_bulk_load_flag :='N';
2951: G_TASK_PROGRESS_in_tbl.delete;
2952: G_TASK_PROGRESS_tbl_count := 0;
2953: WHEN OTHERS THEN
2954: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2955: ROLLBACK TO Execute_Update_Task_Progress;
2956: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2957: FND_MSG_PUB.Add_Exc_Msg
2958: ( G_PKG_NAME

Line 2974: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2970:
2971:
2972: PROCEDURE Project_Level_Validations
2973: (p_api_version_number IN NUMBER
2974: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2975: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2976: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2977: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2978: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

2971:
2972: PROCEDURE Project_Level_Validations
2973: (p_api_version_number IN NUMBER
2974: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2975: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2976: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2977: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2978: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2979: , p_project_id IN NUMBER

Line 3003: IF FND_API.to_boolean(p_init_msg_list)

2999: l_date_computed DATE;
3000:
3001:
3002: BEGIN
3003: IF FND_API.to_boolean(p_init_msg_list)
3004: THEN
3005: FND_MSG_PUB.initialize;
3006: END IF;
3007:

Line 3008: p_return_status := FND_API.G_RET_STS_SUCCESS;

3004: THEN
3005: FND_MSG_PUB.initialize;
3006: END IF;
3007:
3008: p_return_status := FND_API.G_RET_STS_SUCCESS;
3009:
3010:
3011: IF NOT FND_API.Compatible_API_Call ( l_api_version_number ,
3012: p_api_version_number ,

Line 3011: IF NOT FND_API.Compatible_API_Call ( l_api_version_number ,

3007:
3008: p_return_status := FND_API.G_RET_STS_SUCCESS;
3009:
3010:
3011: IF NOT FND_API.Compatible_API_Call ( l_api_version_number ,
3012: p_api_version_number ,
3013: l_api_name,
3014: G_PKG_NAME)
3015:

Line 3017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3013: l_api_name,
3014: G_PKG_NAME)
3015:
3016: THEN
3017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3018: END IF;
3019:
3020: --Moved from below for project security changes. --Bug 2471668
3021:

Line 3030: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3026: , p_return_status => l_return_status
3027: );
3028:
3029:
3030: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3032: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3033: RAISE FND_API.G_EXC_ERROR;
3034: END IF;

Line 3031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3027: );
3028:
3029:
3030: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3032: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3033: RAISE FND_API.G_EXC_ERROR;
3034: END IF;
3035: p_project_id_out := l_project_id_out;

Line 3032: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

3028:
3029:
3030: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3032: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3033: RAISE FND_API.G_EXC_ERROR;
3034: END IF;
3035: p_project_id_out := l_project_id_out;
3036:

Line 3033: RAISE FND_API.G_EXC_ERROR;

3029:
3030: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3032: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3033: RAISE FND_API.G_EXC_ERROR;
3034: END IF;
3035: p_project_id_out := l_project_id_out;
3036:
3037: --Bug 2471668

Line 3064: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

3060: p_return_status => l_return_status,
3061: p_function_allowed => l_function_allowed );
3062:
3063:
3064: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3065: THEN
3066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3067:
3068: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

Line 3066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3062:
3063:
3064: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3065: THEN
3066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3067:
3068: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3069: THEN
3070: RAISE FND_API.G_EXC_ERROR;

Line 3068: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

3064: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3065: THEN
3066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3067:
3068: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3069: THEN
3070: RAISE FND_API.G_EXC_ERROR;
3071: END IF;
3072: IF l_function_allowed = 'N' THEN

Line 3070: RAISE FND_API.G_EXC_ERROR;

3066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3067:
3068: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3069: THEN
3070: RAISE FND_API.G_EXC_ERROR;
3071: END IF;
3072: IF l_function_allowed = 'N' THEN
3073: FND_MESSAGE.SET_NAME('PA','PA_FUNCTION_SECURITY_ENFORCED');
3074: FND_MSG_PUB.add;

Line 3075: p_return_status := FND_API.G_RET_STS_ERROR;

3071: END IF;
3072: IF l_function_allowed = 'N' THEN
3073: FND_MESSAGE.SET_NAME('PA','PA_FUNCTION_SECURITY_ENFORCED');
3074: FND_MSG_PUB.add;
3075: p_return_status := FND_API.G_RET_STS_ERROR;
3076: RAISE FND_API.G_EXC_ERROR;
3077: END IF;
3078: IF FND_API.to_boolean(p_init_msg_list)
3079: THEN

Line 3076: RAISE FND_API.G_EXC_ERROR;

3072: IF l_function_allowed = 'N' THEN
3073: FND_MESSAGE.SET_NAME('PA','PA_FUNCTION_SECURITY_ENFORCED');
3074: FND_MSG_PUB.add;
3075: p_return_status := FND_API.G_RET_STS_ERROR;
3076: RAISE FND_API.G_EXC_ERROR;
3077: END IF;
3078: IF FND_API.to_boolean(p_init_msg_list)
3079: THEN
3080: FND_MSG_PUB.initialize;

Line 3078: IF FND_API.to_boolean(p_init_msg_list)

3074: FND_MSG_PUB.add;
3075: p_return_status := FND_API.G_RET_STS_ERROR;
3076: RAISE FND_API.G_EXC_ERROR;
3077: END IF;
3078: IF FND_API.to_boolean(p_init_msg_list)
3079: THEN
3080: FND_MSG_PUB.initialize;
3081: END IF;
3082:

Line 3092: p_return_status := FND_API.G_RET_STS_ERROR;

3088: -- Hence, cannot update the project.Raise error
3089:
3090: FND_MESSAGE.SET_NAME('PA','PA_PROJECT_SECURITY_ENFORCED');
3091: FND_MSG_PUB.add;
3092: p_return_status := FND_API.G_RET_STS_ERROR;
3093: RAISE FND_API.G_EXC_ERROR;
3094: ELSE
3095: -- If the user has query privileges, then check whether
3096: -- update privileges are also available

Line 3093: RAISE FND_API.G_EXC_ERROR;

3089:
3090: FND_MESSAGE.SET_NAME('PA','PA_PROJECT_SECURITY_ENFORCED');
3091: FND_MSG_PUB.add;
3092: p_return_status := FND_API.G_RET_STS_ERROR;
3093: RAISE FND_API.G_EXC_ERROR;
3094: ELSE
3095: -- If the user has query privileges, then check whether
3096: -- update privileges are also available
3097: IF pa_security.allow_update (x_project_id => l_project_id_out ) = 'N'

Line 3105: p_return_status := FND_API.G_RET_STS_ERROR;

3101: -- Hence , raise error
3102:
3103: FND_MESSAGE.SET_NAME('PA','PA_PROJECT_SECURITY_ENFORCED');
3104: FND_MSG_PUB.add;
3105: p_return_status := FND_API.G_RET_STS_ERROR;
3106: RAISE FND_API.G_EXC_ERROR;
3107: END IF;
3108: END IF;
3109:

Line 3106: RAISE FND_API.G_EXC_ERROR;

3102:
3103: FND_MESSAGE.SET_NAME('PA','PA_PROJECT_SECURITY_ENFORCED');
3104: FND_MSG_PUB.add;
3105: p_return_status := FND_API.G_RET_STS_ERROR;
3106: RAISE FND_API.G_EXC_ERROR;
3107: END IF;
3108: END IF;
3109:
3110: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) then

Line 3110: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) then

3106: RAISE FND_API.G_EXC_ERROR;
3107: END IF;
3108: END IF;
3109:
3110: IF (p_return_status <> FND_API.G_RET_STS_SUCCESS ) then
3111: FND_MSG_PUB.Count_And_Get
3112: ( p_count => p_msg_count
3113: ,p_data => p_msg_data
3114: );

Line 3117: WHEN FND_API.G_EXC_ERROR THEN

3113: ,p_data => p_msg_data
3114: );
3115: END IF;
3116: EXCEPTION
3117: WHEN FND_API.G_EXC_ERROR THEN
3118: p_return_status := FND_API.G_RET_STS_ERROR;
3119: FND_MSG_PUB.Count_And_Get
3120: ( p_count => p_msg_count
3121: ,p_data => p_msg_data

Line 3118: p_return_status := FND_API.G_RET_STS_ERROR;

3114: );
3115: END IF;
3116: EXCEPTION
3117: WHEN FND_API.G_EXC_ERROR THEN
3118: p_return_status := FND_API.G_RET_STS_ERROR;
3119: FND_MSG_PUB.Count_And_Get
3120: ( p_count => p_msg_count
3121: ,p_data => p_msg_data
3122: );

Line 3123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3119: FND_MSG_PUB.Count_And_Get
3120: ( p_count => p_msg_count
3121: ,p_data => p_msg_data
3122: );
3123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3124: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3125: FND_MSG_PUB.Count_And_Get
3126: ( p_count => p_msg_count
3127: ,p_data => p_msg_data

Line 3124: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3120: ( p_count => p_msg_count
3121: ,p_data => p_msg_data
3122: );
3123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3124: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3125: FND_MSG_PUB.Count_And_Get
3126: ( p_count => p_msg_count
3127: ,p_data => p_msg_data
3128: );

Line 3130: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3126: ( p_count => p_msg_count
3127: ,p_data => p_msg_data
3128: );
3129: WHEN OTHERS THEN
3130: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3131: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3132: FND_MSG_PUB.Add_Exc_Msg
3133: ( G_PKG_NAME
3134: , l_api_name

Line 3148: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

3144: /* Progress Management Changes. Bug # 3420093. */
3145:
3146: PROCEDURE update_task_progress_amg
3147: ( p_api_version IN NUMBER :=1.0
3148: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
3149: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
3150: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
3151: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
3152: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

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

3145:
3146: PROCEDURE update_task_progress_amg
3147: ( p_api_version IN NUMBER :=1.0
3148: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
3149: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
3150: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
3151: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
3152: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
3153: ,p_debug_mode IN VARCHAR2 :='N'

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

3146: PROCEDURE update_task_progress_amg
3147: ( p_api_version IN NUMBER :=1.0
3148: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
3149: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
3150: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
3151: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
3152: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
3153: ,p_debug_mode IN VARCHAR2 :='N'
3154: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 3151: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

3147: ( p_api_version IN NUMBER :=1.0
3148: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
3149: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
3150: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
3151: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
3152: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
3153: ,p_debug_mode IN VARCHAR2 :='N'
3154: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3155: ,p_progress_mode IN VARCHAR2 := 'FUTURE'

Line 3170: IF FND_API.to_boolean(p_init_msg_list)

3166: l_task_progress_rec PA_PROGRESS_PUB.PA_TASK_PROGRESS_LIST_REC_TYPE;
3167: l_return_status VARCHAR2(1);
3168: l_api_name VARCHAR2(30) := 'update_task_progress_amg';
3169: begin
3170: IF FND_API.to_boolean(p_init_msg_list)
3171: THEN
3172: FND_MSG_PUB.initialize;
3173: END IF;
3174:

Line 3175: x_return_status := FND_API.G_RET_STS_SUCCESS;

3171: THEN
3172: FND_MSG_PUB.initialize;
3173: END IF;
3174:
3175: x_return_status := FND_API.G_RET_STS_SUCCESS;
3176:
3177: -- Setting context for the temporary fin_plan table.
3178:
3179: PA_PROGRESS_PUB.populate_pji_tab_for_plan(

Line 3195: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3191: ,x_msg_data => x_msg_data
3192: );
3193:
3194: -- 4537865 : Included check for x_return_status
3195: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3197: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3198: RAISE FND_API.G_EXC_ERROR;
3199: END IF;

Line 3196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3192: );
3193:
3194: -- 4537865 : Included check for x_return_status
3195: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3197: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3198: RAISE FND_API.G_EXC_ERROR;
3199: END IF;
3200:

Line 3197: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3193:
3194: -- 4537865 : Included check for x_return_status
3195: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3197: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3198: RAISE FND_API.G_EXC_ERROR;
3199: END IF;
3200:
3201: -- Call Update progress for each task with P_rollup_entire_wbs_flag = 'N' and p_calling_module = 'AMG'.

Line 3198: RAISE FND_API.G_EXC_ERROR;

3194: -- 4537865 : Included check for x_return_status
3195: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3197: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3198: RAISE FND_API.G_EXC_ERROR;
3199: END IF;
3200:
3201: -- Call Update progress for each task with P_rollup_entire_wbs_flag = 'N' and p_calling_module = 'AMG'.
3202:

Line 3262: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3258: ,x_msg_count => x_msg_count
3259: ,x_msg_data => x_msg_data
3260: );
3261: -- 4537865 : Included check for x_return_status
3262: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3264: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3265: RAISE FND_API.G_EXC_ERROR;
3266: END IF;

Line 3263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3259: ,x_msg_data => x_msg_data
3260: );
3261: -- 4537865 : Included check for x_return_status
3262: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3264: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3265: RAISE FND_API.G_EXC_ERROR;
3266: END IF;
3267: end loop;

Line 3264: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3260: );
3261: -- 4537865 : Included check for x_return_status
3262: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3264: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3265: RAISE FND_API.G_EXC_ERROR;
3266: END IF;
3267: end loop;
3268:

Line 3265: RAISE FND_API.G_EXC_ERROR;

3261: -- 4537865 : Included check for x_return_status
3262: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3264: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3265: RAISE FND_API.G_EXC_ERROR;
3266: END IF;
3267: end loop;
3268:
3269: -- Call rollup_progress_pvt api for the entire structure.

Line 3282: if (x_return_status <> fnd_api.g_ret_sts_success ) then

3278: ,x_return_status => x_return_status
3279: ,x_msg_count => x_msg_count
3280: ,x_msg_data => x_msg_data);
3281:
3282: if (x_return_status <> fnd_api.g_ret_sts_success ) then
3283: fnd_msg_pub.count_and_get
3284: (p_count => x_msg_count
3285: ,p_data => x_msg_data);
3286: end if;

Line 3290: when fnd_api.g_exc_error then

3286: end if;
3287:
3288: exception
3289:
3290: when fnd_api.g_exc_error then
3291: x_return_status := fnd_api.g_ret_sts_error;
3292: fnd_msg_pub.count_and_get
3293: (p_count => x_msg_count
3294: ,p_data => x_msg_data);

Line 3291: x_return_status := fnd_api.g_ret_sts_error;

3287:
3288: exception
3289:
3290: when fnd_api.g_exc_error then
3291: x_return_status := fnd_api.g_ret_sts_error;
3292: fnd_msg_pub.count_and_get
3293: (p_count => x_msg_count
3294: ,p_data => x_msg_data);
3295: when fnd_api.g_exc_unexpected_error then

Line 3295: when fnd_api.g_exc_unexpected_error then

3291: x_return_status := fnd_api.g_ret_sts_error;
3292: fnd_msg_pub.count_and_get
3293: (p_count => x_msg_count
3294: ,p_data => x_msg_data);
3295: when fnd_api.g_exc_unexpected_error then
3296: x_return_status := fnd_api.g_ret_sts_unexp_error;
3297: fnd_msg_pub.count_and_get
3298: (p_count => x_msg_count
3299: ,p_data => x_msg_data);

Line 3296: x_return_status := fnd_api.g_ret_sts_unexp_error;

3292: fnd_msg_pub.count_and_get
3293: (p_count => x_msg_count
3294: ,p_data => x_msg_data);
3295: when fnd_api.g_exc_unexpected_error then
3296: x_return_status := fnd_api.g_ret_sts_unexp_error;
3297: fnd_msg_pub.count_and_get
3298: (p_count => x_msg_count
3299: ,p_data => x_msg_data);
3300: when others then

Line 3301: x_return_status := fnd_api.g_ret_sts_unexp_error;

3297: fnd_msg_pub.count_and_get
3298: (p_count => x_msg_count
3299: ,p_data => x_msg_data);
3300: when others then
3301: x_return_status := fnd_api.g_ret_sts_unexp_error;
3302: if fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) then
3303: fnd_msg_pub.add_exc_msg(g_pkg_name,l_api_name);
3304: end if;
3305: fnd_msg_pub.count_and_get

Line 3317: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE

3313: -- =================================================================
3314:
3315: PROCEDURE UPDATE_PROGRESS_BULK(
3316: p_api_version IN NUMBER :=1.0
3317: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
3318: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
3319: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
3320: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
3321: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

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

3314:
3315: PROCEDURE UPDATE_PROGRESS_BULK(
3316: p_api_version IN NUMBER :=1.0
3317: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
3318: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
3319: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
3320: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
3321: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
3322: ,p_calling_mode IN VARCHAR2 := null

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

3315: PROCEDURE UPDATE_PROGRESS_BULK(
3316: p_api_version IN NUMBER :=1.0
3317: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
3318: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
3319: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
3320: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
3321: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
3322: ,p_calling_mode IN VARCHAR2 := null
3323: ,p_debug_mode IN VARCHAR2 :='N'

Line 3320: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

3316: p_api_version IN NUMBER :=1.0
3317: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
3318: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
3319: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
3320: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
3321: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
3322: ,p_calling_mode IN VARCHAR2 := null
3323: ,p_debug_mode IN VARCHAR2 :='N'
3324: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 3388: RAISE FND_API.G_EXC_ERROR;

3384: exception
3385: when no_data_found then
3386: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3387: p_msg_name => 'PA_LITE_API_CANT_USE');
3388: RAISE FND_API.G_EXC_ERROR;
3389: when others then
3390: raise;
3391: end;
3392:

Line 3400: RAISE FND_API.G_EXC_ERROR;

3396: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
3397: PA_PROJECT_PVT.CONC_LOCK_PROJECT(p_project_id,'PROGRESS',x_msg_data,x_return_status);
3398: IF x_return_status <> 'S'
3399: THEN
3400: RAISE FND_API.G_EXC_ERROR;
3401: ELSE
3402: PA_PROJECT_PVT.LOG_ROLLUP_EVENT(p_project_id,p_structure_version_id,'PROGRESS');
3403: --PA_PROJECT_PVT.LOG_TASK_LEVEL_EVENT(p_pa_project_id,p_pa_task_id,p_structure_version_id,'PROGRESS');
3404: END IF;

Line 3477: WHEN FND_API.G_EXC_ERROR THEN

3473: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
3474: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
3475: END IF;
3476: EXCEPTION
3477: WHEN FND_API.G_EXC_ERROR THEN
3478: x_return_status := FND_API.G_RET_STS_ERROR ;
3479: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
3480: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
3481: END IF;

Line 3478: x_return_status := FND_API.G_RET_STS_ERROR ;

3474: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
3475: END IF;
3476: EXCEPTION
3477: WHEN FND_API.G_EXC_ERROR THEN
3478: x_return_status := FND_API.G_RET_STS_ERROR ;
3479: IF (PA_PROJECT_PUB.G_ROLLUP_DEFER='Y') THEN
3480: PA_PROJECT_PVT.CONC_RELEASE_LOCK_PROJECT(p_project_id);
3481: END IF;
3482: FND_MSG_PUB.Count_And_Get

Line 3486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3482: FND_MSG_PUB.Count_And_Get
3483: ( p_count => x_msg_count ,
3484: p_data => x_msg_data );
3485: when OTHERS then
3486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3488: FND_MSG_PUB.add_exc_msg
3489: ( p_pkg_name => G_PKG_NAME
3490: , p_procedure_name => 'UPDATE_PROGRESS_BULK' );