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

Line 13: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE

9: -- Type : Public
10: -- Pre-reqs : None.
11: -- Parameters :
12: -- p_api_version IN NUMBER Required Default = 1.0
13: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
14: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
15: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
16: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
17: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'

Line 14: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE

10: -- Pre-reqs : None.
11: -- Parameters :
12: -- p_api_version IN NUMBER Required Default = 1.0
13: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
14: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
15: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
16: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
17: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
18: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 15: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE

11: -- Parameters :
12: -- p_api_version IN NUMBER Required Default = 1.0
13: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
14: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
15: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
16: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
17: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
18: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
19: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 16: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

12: -- p_api_version IN NUMBER Required Default = 1.0
13: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
14: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
15: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
16: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
17: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
18: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
19: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
20: -- p_project_id IN NUMBER Required

Line 19: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

15: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
16: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
17: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
18: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
19: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
20: -- p_project_id IN NUMBER Required
21: -- p_buffer IN NUMBER Optional Default = FND_API.G_MISS_NUM
22: -- x_return_status OUT VARCHAR2 Required
23: -- x_msg_count OUT NUMBER Required

Line 21: -- p_buffer IN NUMBER Optional Default = FND_API.G_MISS_NUM

17: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
18: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
19: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
20: -- p_project_id IN NUMBER Required
21: -- p_buffer IN NUMBER Optional Default = FND_API.G_MISS_NUM
22: -- x_return_status OUT VARCHAR2 Required
23: -- x_msg_count OUT NUMBER Required
24: -- x_msg_data OUT VARCHAR2 Optional
25:

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

24: -- x_msg_data OUT VARCHAR2 Optional
25:
26: PROCEDURE COPY_PROJECT_DATES
27: ( p_api_version IN NUMBER := 1.0
28: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
29: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
30: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
31: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
32: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

25:
26: PROCEDURE COPY_PROJECT_DATES
27: ( p_api_version IN NUMBER := 1.0
28: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
29: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
30: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
31: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
32: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
33: ,p_debug_mode IN VARCHAR2 := 'N'

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

26: PROCEDURE COPY_PROJECT_DATES
27: ( p_api_version IN NUMBER := 1.0
28: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
29: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
30: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
31: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
32: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
33: ,p_debug_mode IN VARCHAR2 := 'N'
34: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

27: ( p_api_version IN NUMBER := 1.0
28: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
29: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
30: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
31: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
32: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
33: ,p_debug_mode IN VARCHAR2 := 'N'
34: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
35: ,p_project_id IN NUMBER

Line 34: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

30: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
31: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
32: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
33: ,p_debug_mode IN VARCHAR2 := 'N'
34: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
35: ,p_project_id IN NUMBER
36: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
37: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
38: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 288: if p_commit = FND_API.G_TRUE then

284: if (p_debug_mode = 'Y') then
285: pa_debug.debug('PA_PROJECT_DATES_PUB.Copy_Project_Dates BEGIN');
286: end if;
287:
288: if p_commit = FND_API.G_TRUE then
289: savepoint copy_project_dates;
290: end if;
291:
292: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 292: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

288: if p_commit = FND_API.G_TRUE then
289: savepoint copy_project_dates;
290: end if;
291:
292: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
293: raise FND_API.G_EXC_UNEXPECTED_ERROR;
294: end if;
295:
296: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then

Line 293: raise FND_API.G_EXC_UNEXPECTED_ERROR;

289: savepoint copy_project_dates;
290: end if;
291:
292: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
293: raise FND_API.G_EXC_UNEXPECTED_ERROR;
294: end if;
295:
296: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
297: FND_MSG_PUB.initialize;

Line 296: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then

292: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
293: raise FND_API.G_EXC_UNEXPECTED_ERROR;
294: end if;
295:
296: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
297: FND_MSG_PUB.initialize;
298: end if;
299:
300: --select structure version id

Line 415: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

411: p_process_flag1 => 'Y',
412: p_partial_process_flag1 => 'N',
413: p_process_rollup_flag1 => 'Y');
414:
415: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
416: x_msg_count := FND_MSG_PUB.count_msg;
417: if x_msg_count = 1 then
418: pa_interface_utils_pub.get_messages
419: (p_encoded => FND_API.G_TRUE,

Line 419: (p_encoded => FND_API.G_TRUE,

415: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
416: x_msg_count := FND_MSG_PUB.count_msg;
417: if x_msg_count = 1 then
418: pa_interface_utils_pub.get_messages
419: (p_encoded => FND_API.G_TRUE,
420: p_msg_index => 1,
421: p_msg_count => l_msg_count,
422: p_msg_data => l_msg_data,
423: p_data => l_data,

Line 427: raise FND_API.G_EXC_ERROR;

423: p_data => l_data,
424: p_msg_index_out => l_msg_index_out);
425: x_msg_data := l_data;
426: end if;
427: raise FND_API.G_EXC_ERROR;
428: end if;
429:
430: --Bug 3919138 : Sort the rollup table by wbs_level in ascending order.
431: --This is necessary because update_task api below must be called with the parent tasks

Line 494: ,p_commit => FND_API.G_FALSE

490: CLOSE get_proj_record_ver_number;
491:
492: PA_PROJECT_DATES_PUB.Update_Project_Dates (
493: p_init_msg_list => p_init_msg_list
494: ,p_commit => FND_API.G_FALSE
495: ,p_validate_only => FND_API.G_FALSE -- Bug 2786525
496: ,p_calling_module => p_calling_module
497: ,p_debug_mode => p_debug_mode
498: ,p_project_id => p_project_id

Line 495: ,p_validate_only => FND_API.G_FALSE -- Bug 2786525

491:
492: PA_PROJECT_DATES_PUB.Update_Project_Dates (
493: p_init_msg_list => p_init_msg_list
494: ,p_commit => FND_API.G_FALSE
495: ,p_validate_only => FND_API.G_FALSE -- Bug 2786525
496: ,p_calling_module => p_calling_module
497: ,p_debug_mode => p_debug_mode
498: ,p_project_id => p_project_id
499: ,p_date_type => 'TRANSACTION'

Line 507: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

503: ,x_return_status => l_return_status
504: ,x_msg_count => l_msg_count
505: ,x_msg_data => l_msg_data );
506:
507: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
508: x_msg_count := FND_MSG_PUB.count_msg;
509: if x_msg_count = 1 then
510: pa_interface_utils_pub.get_messages
511: (p_encoded => FND_API.G_TRUE,

Line 511: (p_encoded => FND_API.G_TRUE,

507: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
508: x_msg_count := FND_MSG_PUB.count_msg;
509: if x_msg_count = 1 then
510: pa_interface_utils_pub.get_messages
511: (p_encoded => FND_API.G_TRUE,
512: p_msg_index => 1,
513: p_msg_count => l_msg_count,
514: p_msg_data => l_msg_data,
515: p_data => l_data,

Line 519: raise FND_API.G_EXC_ERROR;

515: p_data => l_data,
516: p_msg_index_out => l_msg_index_out);
517: x_msg_data := l_data;
518: end if;
519: raise FND_API.G_EXC_ERROR;
520: end if;
521:
522: EXIT;
523: END IF;

Line 582: ,p_commit => FND_API.G_FALSE

578:
579: /* End of changes for bug 5665772 */
580: PA_TASKS_MAINT_PUB.Update_Task (
581: p_init_msg_list => p_init_msg_list
582: ,p_commit => FND_API.G_FALSE
583: ,p_validate_only => p_validate_only
584: ,p_calling_module => p_calling_module
585: ,p_debug_mode => p_debug_mode
586: ,p_project_id => p_project_id

Line 605: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

601:
602: END IF;
603:
604: --bug 2868685
605: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
606: x_msg_count := FND_MSG_PUB.count_msg;
607: if x_msg_count = 1 then
608: pa_interface_utils_pub.get_messages
609: (p_encoded => FND_API.G_TRUE,

Line 609: (p_encoded => FND_API.G_TRUE,

605: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
606: x_msg_count := FND_MSG_PUB.count_msg;
607: if x_msg_count = 1 then
608: pa_interface_utils_pub.get_messages
609: (p_encoded => FND_API.G_TRUE,
610: p_msg_index => 1,
611: p_msg_count => l_msg_count,
612: p_msg_data => l_msg_data,
613: p_data => l_data,

Line 617: raise FND_API.G_EXC_ERROR;

613: p_data => l_data,
614: p_msg_index_out => l_msg_index_out);
615: x_msg_data := l_data;
616: end if;
617: raise FND_API.G_EXC_ERROR;
618: end if;
619: --bug 2868685
620:
621: EXIT when l_cnt = l_rollup_table.Last;

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

642: x_return_status => l_return_status,
643: x_msg_count => l_msg_count,
644: x_msg_data => l_msg_data);
645:
646: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
647: PA_UTILS.ADD_MESSAGE('PA', l_msg_data);
648: END IF;
649:
650: END IF;

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

660: x_return_status => l_return_status,
661: x_msg_count => l_msg_count,
662: x_msg_data => l_msg_data);
663:
664: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
665: PA_UTILS.ADD_MESSAGE('PA', l_msg_data);
666: END IF;
667:
668: END IF;

Line 675: p_encoded => FND_API.G_TRUE,

671: IF (l_msg_count > 0) THEN
672: x_msg_count := l_msg_count;
673: IF (x_msg_count = 1) THEN
674: pa_interface_utils_pub.get_messages(
675: p_encoded => FND_API.G_TRUE,
676: p_msg_index => 1,
677: p_data => l_data,
678: p_msg_index_out => l_msg_index_out);
679: x_msg_data := l_data;

Line 681: RAISE FND_API.G_EXC_ERROR;

677: p_data => l_data,
678: p_msg_index_out => l_msg_index_out);
679: x_msg_data := l_data;
680: END IF;
681: RAISE FND_API.G_EXC_ERROR;
682: END IF;
683:
684: EXIT when l_tcnt = l_task_dates.Last;
685: l_tcnt := l_task_dates.NEXT(l_tcnt);

Line 705: -- (p_encoded => FND_API.G_TRUE,

701: -- if l_msg_count > 0 then
702: -- x_msg_count := l_msg_count;
703: -- if x_msg_count = 1 then
704: -- pa_interface_utils_pub.get_messages
705: -- (p_encoded => FND_API.G_TRUE,
706: -- p_msg_index => 1,
707: -- p_msg_count => l_msg_count,
708: -- p_msg_data => l_msg_data,
709: -- p_data => l_data,

Line 713: -- raise FND_API.G_EXC_ERROR;

709: -- p_data => l_data,
710: -- p_msg_index_out => l_msg_index_out);
711: -- x_msg_data := l_data;
712: -- end if;
713: -- raise FND_API.G_EXC_ERROR;
714: -- end if;
715:
716: -- Loop through all of the tasks in this project and copy the appropriate dates
717: -- OPEN task_csr;

Line 739: -- (p_encoded => FND_API.G_TRUE,

735: --
736: -- x_msg_count := FND_MSG_PUB.count_msg;
737: --
738: -- pa_interface_utils_pub.get_messages
739: -- (p_encoded => FND_API.G_TRUE,
740: -- p_msg_index => 1,
741: -- p_msg_count => l_msg_count,
742: -- p_msg_data => l_msg_data,
743: -- p_data => l_data,

Line 747: -- raise FND_API.G_EXC_ERROR;

743: -- p_data => l_data,
744: -- p_msg_index_out => l_msg_index_out);
745: -- x_msg_data := l_data;
746: --
747: -- raise FND_API.G_EXC_ERROR;
748: -- else
749: -- CLOSE latest_published_ver_csr;
750: --
751: -- OPEN get_task_sch_dates_csr(l_structure_version_id, l_task_id);

Line 770: -- if(p_buffer <> FND_API.G_MISS_NUM) AND (p_buffer IS NOT NULL) then

766: -- FETCH get_task_bas_dates_csr INTO l_task_start_date, l_task_finish_date;
767: -- CLOSE get_task_bas_dates_csr;
768: -- end if;
769: --
770: -- if(p_buffer <> FND_API.G_MISS_NUM) AND (p_buffer IS NOT NULL) then
771: -- l_task_start_date := l_task_start_date + p_buffer;
772: -- l_task_finish_date := l_task_finish_date + p_buffer;
773: -- end if;
774: --

Line 777: -- ,p_commit => FND_API.G_FALSE

773: -- end if;
774: --
775: -- PA_TASKS_MAINT_PUB.Update_Task (
776: -- p_init_msg_list => p_init_msg_list
777: -- ,p_commit => FND_API.G_FALSE
778: -- ,p_validate_only => p_validate_only
779: -- ,p_calling_module => p_calling_module
780: -- ,p_debug_mode => p_debug_mode
781: -- ,p_project_id => p_project_id

Line 790: -- if l_return_status <> FND_API.G_RET_STS_SUCCESS then

786: -- ,x_return_status => l_return_status
787: -- ,x_msg_count => l_msg_count
788: -- ,x_msg_data => l_msg_data );
789: --
790: -- if l_return_status <> FND_API.G_RET_STS_SUCCESS then
791: -- x_msg_count := FND_MSG_PUB.count_msg;
792: -- if x_msg_count = 1 then
793: -- pa_interface_utils_pub.get_messages
794: -- (p_encoded => FND_API.G_TRUE,

Line 794: -- (p_encoded => FND_API.G_TRUE,

790: -- if l_return_status <> FND_API.G_RET_STS_SUCCESS then
791: -- x_msg_count := FND_MSG_PUB.count_msg;
792: -- if x_msg_count = 1 then
793: -- pa_interface_utils_pub.get_messages
794: -- (p_encoded => FND_API.G_TRUE,
795: -- p_msg_index => 1,
796: -- p_msg_count => l_msg_count,
797: -- p_msg_data => l_msg_data,
798: -- p_data => l_data,

Line 802: -- raise FND_API.G_EXC_ERROR;

798: -- p_data => l_data,
799: -- p_msg_index_out => l_msg_index_out);
800: -- x_msg_data := l_data;
801: -- end if;
802: -- raise FND_API.G_EXC_ERROR;
803: -- end if;
804: -- END LOOP;
805:
806: -- Now copy over project level dates

Line 829: -- if(p_buffer <> FND_API.G_MISS_NUM) AND (p_buffer IS NOT NULL) then

825: -- FETCH get_proj_bas_dates_csr INTO l_proj_start_date, l_proj_finish_date;
826: -- CLOSE get_proj_bas_dates_csr;
827: -- end if;
828:
829: -- if(p_buffer <> FND_API.G_MISS_NUM) AND (p_buffer IS NOT NULL) then
830: -- l_proj_start_date := l_proj_start_date + p_buffer;
831: -- l_proj_finish_date := l_proj_finish_date + p_buffer;
832: -- end if;
833:

Line 836: -- ,p_commit => FND_API.G_FALSE

832: -- end if;
833:
834: -- PA_PROJECT_DATES_PUB.Update_Project_Dates (
835: -- p_init_msg_list => p_init_msg_list
836: -- ,p_commit => FND_API.G_FALSE
837: -- ,p_validate_only => p_validate_only
838: -- ,p_calling_module => p_calling_module
839: -- ,p_debug_mode => p_debug_mode
840: -- ,p_project_id => p_project_id

Line 849: -- if l_return_status <> FND_API.G_RET_STS_SUCCESS then

845: -- ,x_return_status => l_return_status
846: -- ,x_msg_count => l_msg_count
847: -- ,x_msg_data => l_msg_data );
848:
849: -- if l_return_status <> FND_API.G_RET_STS_SUCCESS then
850: -- x_msg_count := FND_MSG_PUB.count_msg;
851: -- if x_msg_count = 1 then
852: -- pa_interface_utils_pub.get_messages
853: -- (p_encoded => FND_API.G_TRUE,

Line 853: -- (p_encoded => FND_API.G_TRUE,

849: -- if l_return_status <> FND_API.G_RET_STS_SUCCESS then
850: -- x_msg_count := FND_MSG_PUB.count_msg;
851: -- if x_msg_count = 1 then
852: -- pa_interface_utils_pub.get_messages
853: -- (p_encoded => FND_API.G_TRUE,
854: -- p_msg_index => 1,
855: -- p_msg_count => l_msg_count,
856: -- p_msg_data => l_msg_data,
857: -- p_data => l_data,

Line 861: -- raise FND_API.G_EXC_ERROR;

857: -- p_data => l_data,
858: -- p_msg_index_out => l_msg_index_out);
859: -- x_msg_data := l_data;
860: -- end if;
861: -- raise FND_API.G_EXC_ERROR;
862: -- end if;
863:
864: x_return_status := FND_API.G_RET_STS_SUCCESS;
865:

Line 864: x_return_status := FND_API.G_RET_STS_SUCCESS;

860: -- end if;
861: -- raise FND_API.G_EXC_ERROR;
862: -- end if;
863:
864: x_return_status := FND_API.G_RET_STS_SUCCESS;
865:
866: if p_commit = FND_API.G_TRUE then
867: commit work;
868: end if;

Line 866: if p_commit = FND_API.G_TRUE then

862: -- end if;
863:
864: x_return_status := FND_API.G_RET_STS_SUCCESS;
865:
866: if p_commit = FND_API.G_TRUE then
867: commit work;
868: end if;
869:
870: if (p_debug_mode = 'Y') then

Line 875: when FND_API.G_EXC_ERROR then

871: pa_debug.debug('PA_PROJECT_DATES_PUB.Copy_Project_Dates END');
872: end if;
873:
874: EXCEPTION
875: when FND_API.G_EXC_ERROR then
876: if p_commit = FND_API.G_TRUE then
877: rollback to copy_project_dates;
878: end if;
879: x_return_status := FND_API.G_RET_STS_ERROR;

Line 876: if p_commit = FND_API.G_TRUE then

872: end if;
873:
874: EXCEPTION
875: when FND_API.G_EXC_ERROR then
876: if p_commit = FND_API.G_TRUE then
877: rollback to copy_project_dates;
878: end if;
879: x_return_status := FND_API.G_RET_STS_ERROR;
880: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 879: x_return_status := FND_API.G_RET_STS_ERROR;

875: when FND_API.G_EXC_ERROR then
876: if p_commit = FND_API.G_TRUE then
877: rollback to copy_project_dates;
878: end if;
879: x_return_status := FND_API.G_RET_STS_ERROR;
880: when FND_API.G_EXC_UNEXPECTED_ERROR then
881: if p_commit = FND_API.G_TRUE then
882: rollback to copy_project_dates;
883: end if;

Line 880: when FND_API.G_EXC_UNEXPECTED_ERROR then

876: if p_commit = FND_API.G_TRUE then
877: rollback to copy_project_dates;
878: end if;
879: x_return_status := FND_API.G_RET_STS_ERROR;
880: when FND_API.G_EXC_UNEXPECTED_ERROR then
881: if p_commit = FND_API.G_TRUE then
882: rollback to copy_project_dates;
883: end if;
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 881: if p_commit = FND_API.G_TRUE then

877: rollback to copy_project_dates;
878: end if;
879: x_return_status := FND_API.G_RET_STS_ERROR;
880: when FND_API.G_EXC_UNEXPECTED_ERROR then
881: if p_commit = FND_API.G_TRUE then
882: rollback to copy_project_dates;
883: end if;
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
885: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PUB',

Line 884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

880: when FND_API.G_EXC_UNEXPECTED_ERROR then
881: if p_commit = FND_API.G_TRUE then
882: rollback to copy_project_dates;
883: end if;
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
885: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PUB',
886: p_procedure_name => 'Copy_Project_Dates',
887: p_error_text => SUBSTRB(SQLERRM,1,240));
888: when OTHERS then

Line 889: if p_commit = FND_API.G_TRUE then

885: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PUB',
886: p_procedure_name => 'Copy_Project_Dates',
887: p_error_text => SUBSTRB(SQLERRM,1,240));
888: when OTHERS then
889: if p_commit = FND_API.G_TRUE then
890: rollback to copy_project_dates;
891: end if;
892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
893: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PUB',

Line 892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

888: when OTHERS then
889: if p_commit = FND_API.G_TRUE then
890: rollback to copy_project_dates;
891: end if;
892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
893: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PUB',
894: p_procedure_name => 'Copy_Project_Dates',
895: p_error_text => SUBSTRB(SQLERRM,1,240));
896: raise;

Line 905: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE

901: -- Type : Public
902: -- Pre-reqs : None.
903: -- Parameters :
904: -- p_api_version IN NUMBER Required Default = 1.0
905: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
906: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
907: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
908: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
909: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'

Line 906: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE

902: -- Pre-reqs : None.
903: -- Parameters :
904: -- p_api_version IN NUMBER Required Default = 1.0
905: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
906: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
907: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
908: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
909: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
910: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 907: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE

903: -- Parameters :
904: -- p_api_version IN NUMBER Required Default = 1.0
905: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
906: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
907: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
908: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
909: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
910: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
911: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 908: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

904: -- p_api_version IN NUMBER Required Default = 1.0
905: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
906: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
907: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
908: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
909: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
910: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
911: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
912: -- p_project_id IN NUMBER Required

Line 911: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

907: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
908: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
909: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
910: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
911: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
912: -- p_project_id IN NUMBER Required
913: -- p_date_type IN VARCHAR2 Required
914: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
915: -- p_finish_date IN DATE Optional Default = FND_API.G_MISS_DATE

Line 914: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE

910: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
911: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
912: -- p_project_id IN NUMBER Required
913: -- p_date_type IN VARCHAR2 Required
914: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
915: -- p_finish_date IN DATE Optional Default = FND_API.G_MISS_DATE
916: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
917: -- x_return_status OUT VARCHAR2 Required
918: -- x_msg_count OUT NUMBER Required

Line 915: -- p_finish_date IN DATE Optional Default = FND_API.G_MISS_DATE

911: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
912: -- p_project_id IN NUMBER Required
913: -- p_date_type IN VARCHAR2 Required
914: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
915: -- p_finish_date IN DATE Optional Default = FND_API.G_MISS_DATE
916: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
917: -- x_return_status OUT VARCHAR2 Required
918: -- x_msg_count OUT NUMBER Required
919: -- x_msg_data OUT VARCHAR2 Optional

Line 916: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM

912: -- p_project_id IN NUMBER Required
913: -- p_date_type IN VARCHAR2 Required
914: -- p_start_date IN DATE Optional Default = FND_API.G_MISS_DATE
915: -- p_finish_date IN DATE Optional Default = FND_API.G_MISS_DATE
916: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
917: -- x_return_status OUT VARCHAR2 Required
918: -- x_msg_count OUT NUMBER Required
919: -- x_msg_data OUT VARCHAR2 Optional
920:

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

919: -- x_msg_data OUT VARCHAR2 Optional
920:
921: PROCEDURE UPDATE_PROJECT_DATES
922: ( p_api_version IN NUMBER := 1.0
923: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
924: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
925: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
926: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
927: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

920:
921: PROCEDURE UPDATE_PROJECT_DATES
922: ( p_api_version IN NUMBER := 1.0
923: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
924: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
925: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
926: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
927: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
928: ,p_debug_mode IN VARCHAR2 := 'N'

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

921: PROCEDURE UPDATE_PROJECT_DATES
922: ( p_api_version IN NUMBER := 1.0
923: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
924: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
925: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
926: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
927: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
928: ,p_debug_mode IN VARCHAR2 := 'N'
929: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

922: ( p_api_version IN NUMBER := 1.0
923: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
924: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
925: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
926: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
927: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
928: ,p_debug_mode IN VARCHAR2 := 'N'
929: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
930: ,p_project_id IN NUMBER

Line 929: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

925: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
926: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
927: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
928: ,p_debug_mode IN VARCHAR2 := 'N'
929: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
930: ,p_project_id IN NUMBER
931: ,p_date_type IN VARCHAR2
932: ,p_start_date IN DATE := FND_API.G_MISS_DATE
933: ,p_finish_date IN DATE := FND_API.G_MISS_DATE

Line 932: ,p_start_date IN DATE := FND_API.G_MISS_DATE

928: ,p_debug_mode IN VARCHAR2 := 'N'
929: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
930: ,p_project_id IN NUMBER
931: ,p_date_type IN VARCHAR2
932: ,p_start_date IN DATE := FND_API.G_MISS_DATE
933: ,p_finish_date IN DATE := FND_API.G_MISS_DATE
934: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
935: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
936: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 933: ,p_finish_date IN DATE := FND_API.G_MISS_DATE

929: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
930: ,p_project_id IN NUMBER
931: ,p_date_type IN VARCHAR2
932: ,p_start_date IN DATE := FND_API.G_MISS_DATE
933: ,p_finish_date IN DATE := FND_API.G_MISS_DATE
934: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
935: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
936: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
937: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

930: ,p_project_id IN NUMBER
931: ,p_date_type IN VARCHAR2
932: ,p_start_date IN DATE := FND_API.G_MISS_DATE
933: ,p_finish_date IN DATE := FND_API.G_MISS_DATE
934: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
935: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
936: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
937: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
938: )

Line 957: if p_commit = FND_API.G_TRUE then

953: if (p_debug_mode = 'Y') then
954: pa_debug.debug('PA_PROJECT_DATES_PUB.Update_Project_Dates BEGIN');
955: end if;
956:
957: if p_commit = FND_API.G_TRUE then
958: savepoint update_project_dates;
959: end if;
960:
961: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 961: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

957: if p_commit = FND_API.G_TRUE then
958: savepoint update_project_dates;
959: end if;
960:
961: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
962: raise FND_API.G_EXC_UNEXPECTED_ERROR;
963: end if;
964:
965: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then

Line 962: raise FND_API.G_EXC_UNEXPECTED_ERROR;

958: savepoint update_project_dates;
959: end if;
960:
961: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
962: raise FND_API.G_EXC_UNEXPECTED_ERROR;
963: end if;
964:
965: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
966: FND_MSG_PUB.initialize;

Line 965: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then

961: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
962: raise FND_API.G_EXC_UNEXPECTED_ERROR;
963: end if;
964:
965: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
966: FND_MSG_PUB.initialize;
967: end if;
968:
969:

Line 980: (p_encoded => FND_API.G_TRUE,

976: if l_msg_count > 0 then
977: x_msg_count := l_msg_count;
978: if x_msg_count = 1 then
979: pa_interface_utils_pub.get_messages
980: (p_encoded => FND_API.G_TRUE,
981: p_msg_index => 1,
982: p_msg_count => l_msg_count,
983: p_msg_data => l_msg_data,
984: p_data => l_data,

Line 988: raise FND_API.G_EXC_ERROR;

984: p_data => l_data,
985: p_msg_index_out => l_msg_index_out);
986: x_msg_data := l_data;
987: end if;
988: raise FND_API.G_EXC_ERROR;
989: end if;
990:
991: PA_PROJECT_DATES_PVT.UPDATE_PROJECT_DATES
992: ( p_commit => FND_API.G_FALSE

Line 992: ( p_commit => FND_API.G_FALSE

988: raise FND_API.G_EXC_ERROR;
989: end if;
990:
991: PA_PROJECT_DATES_PVT.UPDATE_PROJECT_DATES
992: ( p_commit => FND_API.G_FALSE
993: ,p_validate_only => p_validate_only
994: ,p_validation_level => p_validation_level
995: ,p_calling_module => p_calling_module
996: ,p_debug_mode => p_debug_mode

Line 1007: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1003: ,x_return_status => l_return_status
1004: ,x_msg_count => l_msg_count
1005: ,x_msg_data => l_msg_data );
1006:
1007: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1008: x_msg_count := FND_MSG_PUB.count_msg;
1009: if x_msg_count = 1 then
1010: pa_interface_utils_pub.get_messages
1011: (p_encoded => FND_API.G_TRUE,

Line 1011: (p_encoded => FND_API.G_TRUE,

1007: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1008: x_msg_count := FND_MSG_PUB.count_msg;
1009: if x_msg_count = 1 then
1010: pa_interface_utils_pub.get_messages
1011: (p_encoded => FND_API.G_TRUE,
1012: p_msg_index => 1,
1013: p_msg_count => l_msg_count,
1014: p_msg_data => l_msg_data,
1015: p_data => l_data,

Line 1019: raise FND_API.G_EXC_ERROR;

1015: p_data => l_data,
1016: p_msg_index_out => l_msg_index_out);
1017: x_msg_data := l_data;
1018: end if;
1019: raise FND_API.G_EXC_ERROR;
1020: end if;
1021:
1022: x_return_status := FND_API.G_RET_STS_SUCCESS;
1023:

Line 1022: x_return_status := FND_API.G_RET_STS_SUCCESS;

1018: end if;
1019: raise FND_API.G_EXC_ERROR;
1020: end if;
1021:
1022: x_return_status := FND_API.G_RET_STS_SUCCESS;
1023:
1024: if p_commit = FND_API.G_TRUE then
1025: commit work;
1026: end if;

Line 1024: if p_commit = FND_API.G_TRUE then

1020: end if;
1021:
1022: x_return_status := FND_API.G_RET_STS_SUCCESS;
1023:
1024: if p_commit = FND_API.G_TRUE then
1025: commit work;
1026: end if;
1027:
1028: if (p_debug_mode = 'Y') then

Line 1033: when FND_API.G_EXC_ERROR then

1029: pa_debug.debug('PA_PROJECT_DATES_PUB.Update_Project_Dates END');
1030: end if;
1031:
1032: EXCEPTION
1033: when FND_API.G_EXC_ERROR then
1034: if p_commit = FND_API.G_TRUE then
1035: rollback to update_project_dates;
1036: end if;
1037: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1034: if p_commit = FND_API.G_TRUE then

1030: end if;
1031:
1032: EXCEPTION
1033: when FND_API.G_EXC_ERROR then
1034: if p_commit = FND_API.G_TRUE then
1035: rollback to update_project_dates;
1036: end if;
1037: x_return_status := FND_API.G_RET_STS_ERROR;
1038: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1037: x_return_status := FND_API.G_RET_STS_ERROR;

1033: when FND_API.G_EXC_ERROR then
1034: if p_commit = FND_API.G_TRUE then
1035: rollback to update_project_dates;
1036: end if;
1037: x_return_status := FND_API.G_RET_STS_ERROR;
1038: when FND_API.G_EXC_UNEXPECTED_ERROR then
1039: if p_commit = FND_API.G_TRUE then
1040: rollback to update_project_dates;
1041: end if;

Line 1038: when FND_API.G_EXC_UNEXPECTED_ERROR then

1034: if p_commit = FND_API.G_TRUE then
1035: rollback to update_project_dates;
1036: end if;
1037: x_return_status := FND_API.G_RET_STS_ERROR;
1038: when FND_API.G_EXC_UNEXPECTED_ERROR then
1039: if p_commit = FND_API.G_TRUE then
1040: rollback to update_project_dates;
1041: end if;
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1039: if p_commit = FND_API.G_TRUE then

1035: rollback to update_project_dates;
1036: end if;
1037: x_return_status := FND_API.G_RET_STS_ERROR;
1038: when FND_API.G_EXC_UNEXPECTED_ERROR then
1039: if p_commit = FND_API.G_TRUE then
1040: rollback to update_project_dates;
1041: end if;
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PUB',

Line 1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1038: when FND_API.G_EXC_UNEXPECTED_ERROR then
1039: if p_commit = FND_API.G_TRUE then
1040: rollback to update_project_dates;
1041: end if;
1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PUB',
1044: p_procedure_name => 'Update_Project_Dates',
1045: p_error_text => SUBSTRB(SQLERRM,1,240));
1046: when OTHERS then

Line 1047: if p_commit = FND_API.G_TRUE then

1043: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PUB',
1044: p_procedure_name => 'Update_Project_Dates',
1045: p_error_text => SUBSTRB(SQLERRM,1,240));
1046: when OTHERS then
1047: if p_commit = FND_API.G_TRUE then
1048: rollback to update_project_dates;
1049: end if;
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PUB',

Line 1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1046: when OTHERS then
1047: if p_commit = FND_API.G_TRUE then
1048: rollback to update_project_dates;
1049: end if;
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_DATES_PUB',
1052: p_procedure_name => 'Update_Project_Dates',
1053: p_error_text => SUBSTRB(SQLERRM,1,240));
1054: raise;