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

Line 27: p_encoded => FND_API.G_TRUE,

23: x_msg_count := FND_MSG_PUB.count_msg;
24:
25: FND_MSG_PUB.get (
26: p_msg_index => 1,
27: p_encoded => FND_API.G_TRUE,
28: p_data => l_data,
29: p_msg_index_out => l_msg_index_out );
30:
31: if l_data is not null then

Line 80: , x_commit IN VARCHAR2 := FND_API.G_FALSE)

76: , x_validation_mode IN VARCHAR2 DEFAULT 'U' --bug 2947492
77: , x_err_code IN OUT NOCOPY number --File.Sql.39 bug 4440895
78: , x_err_stage IN OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
79: , x_err_stack IN OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
80: , x_commit IN VARCHAR2 := FND_API.G_FALSE)
81: is
82:
83: old_stack varchar2(630);
84: status_code number;

Line 158: if((x_err_code <> 0) OR (l_delete_ok <> FND_API.G_TRUE)) then

154: x_errorcode => x_err_code ,
155: x_msg_count => x_msg_count ,
156: x_msg_data => x_msg_data );
157:
158: if((x_err_code <> 0) OR (l_delete_ok <> FND_API.G_TRUE)) then
159: x_err_code := 10;
160: x_err_stack := x_err_stack || '->check PA_EGO_WRAPPER_PUB.check_delete_project_ok '|| x_project_id;
161: if l_template_flag = 'Y' then
162: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

Line 183: if((x_err_code <> 0) OR (l_delete_ok <> FND_API.G_TRUE)) then

179: x_errorcode => x_err_code ,
180: x_msg_count => x_msg_count ,
181: x_msg_data => x_msg_data );
182:
183: if((x_err_code <> 0) OR (l_delete_ok <> FND_API.G_TRUE)) then
184: x_err_code := 20;
185: x_err_stack := x_err_stack || '->check PA_EGO_WRAPPER_PUB.check_delete_project_ok_eng '|| x_project_id;
186: if l_template_flag = 'Y' then
187: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

Line 223: ,p_calling_module => FND_API.G_MISS_CHAR

219:
220: -- Delete Resource Assignments
221: PA_ASSIGNMENTS_PUB.DELETE_PJR_TXNS
222: (p_project_id => x_project_id
223: ,p_calling_module => FND_API.G_MISS_CHAR
224: ,p_api_version => 1.0
225: ,p_init_msg_list => FND_API.G_FALSE
226: ,p_commit => FND_API.G_FALSE
227: ,p_validate_only => FND_API.G_FALSE

Line 225: ,p_init_msg_list => FND_API.G_FALSE

221: PA_ASSIGNMENTS_PUB.DELETE_PJR_TXNS
222: (p_project_id => x_project_id
223: ,p_calling_module => FND_API.G_MISS_CHAR
224: ,p_api_version => 1.0
225: ,p_init_msg_list => FND_API.G_FALSE
226: ,p_commit => FND_API.G_FALSE
227: ,p_validate_only => FND_API.G_FALSE
228: ,p_max_msg_count => FND_API.G_MISS_NUM
229: ,x_return_status => x_return_status

Line 226: ,p_commit => FND_API.G_FALSE

222: (p_project_id => x_project_id
223: ,p_calling_module => FND_API.G_MISS_CHAR
224: ,p_api_version => 1.0
225: ,p_init_msg_list => FND_API.G_FALSE
226: ,p_commit => FND_API.G_FALSE
227: ,p_validate_only => FND_API.G_FALSE
228: ,p_max_msg_count => FND_API.G_MISS_NUM
229: ,x_return_status => x_return_status
230: ,x_msg_count => x_msg_count

Line 227: ,p_validate_only => FND_API.G_FALSE

223: ,p_calling_module => FND_API.G_MISS_CHAR
224: ,p_api_version => 1.0
225: ,p_init_msg_list => FND_API.G_FALSE
226: ,p_commit => FND_API.G_FALSE
227: ,p_validate_only => FND_API.G_FALSE
228: ,p_max_msg_count => FND_API.G_MISS_NUM
229: ,x_return_status => x_return_status
230: ,x_msg_count => x_msg_count
231: ,x_msg_data => x_msg_data );

Line 228: ,p_max_msg_count => FND_API.G_MISS_NUM

224: ,p_api_version => 1.0
225: ,p_init_msg_list => FND_API.G_FALSE
226: ,p_commit => FND_API.G_FALSE
227: ,p_validate_only => FND_API.G_FALSE
228: ,p_max_msg_count => FND_API.G_MISS_NUM
229: ,x_return_status => x_return_status
230: ,x_msg_count => x_msg_count
231: ,x_msg_data => x_msg_data );
232:

Line 251: ,p_init_msg_list => FND_API.G_FALSE

247: LOOP
248:
249: PA_PROJECT_SUBTEAMS_PVT.Delete_Subteam
250: ( p_api_version => 1.0
251: ,p_init_msg_list => FND_API.G_FALSE
252: ,p_commit => FND_API.G_FALSE
253: ,p_validate_only => FND_API.G_FALSE
254: ,p_validation_level => FND_API.g_valid_level_full
255: -- ,p_calling_module => NULL

Line 252: ,p_commit => FND_API.G_FALSE

248:
249: PA_PROJECT_SUBTEAMS_PVT.Delete_Subteam
250: ( p_api_version => 1.0
251: ,p_init_msg_list => FND_API.G_FALSE
252: ,p_commit => FND_API.G_FALSE
253: ,p_validate_only => FND_API.G_FALSE
254: ,p_validation_level => FND_API.g_valid_level_full
255: -- ,p_calling_module => NULL
256: ,p_debug_mode => 'N'

Line 253: ,p_validate_only => FND_API.G_FALSE

249: PA_PROJECT_SUBTEAMS_PVT.Delete_Subteam
250: ( p_api_version => 1.0
251: ,p_init_msg_list => FND_API.G_FALSE
252: ,p_commit => FND_API.G_FALSE
253: ,p_validate_only => FND_API.G_FALSE
254: ,p_validation_level => FND_API.g_valid_level_full
255: -- ,p_calling_module => NULL
256: ,p_debug_mode => 'N'
257: ,p_max_msg_count => FND_API.G_MISS_NUM

Line 254: ,p_validation_level => FND_API.g_valid_level_full

250: ( p_api_version => 1.0
251: ,p_init_msg_list => FND_API.G_FALSE
252: ,p_commit => FND_API.G_FALSE
253: ,p_validate_only => FND_API.G_FALSE
254: ,p_validation_level => FND_API.g_valid_level_full
255: -- ,p_calling_module => NULL
256: ,p_debug_mode => 'N'
257: ,p_max_msg_count => FND_API.G_MISS_NUM
258: ,p_subteam_row_id => i.row_id

Line 257: ,p_max_msg_count => FND_API.G_MISS_NUM

253: ,p_validate_only => FND_API.G_FALSE
254: ,p_validation_level => FND_API.g_valid_level_full
255: -- ,p_calling_module => NULL
256: ,p_debug_mode => 'N'
257: ,p_max_msg_count => FND_API.G_MISS_NUM
258: ,p_subteam_row_id => i.row_id
259: ,p_subteam_id => i.project_subteam_id
260: ,p_record_version_number => FND_API.G_MISS_NUM
261: ,x_return_status => x_return_status

Line 260: ,p_record_version_number => FND_API.G_MISS_NUM

256: ,p_debug_mode => 'N'
257: ,p_max_msg_count => FND_API.G_MISS_NUM
258: ,p_subteam_row_id => i.row_id
259: ,p_subteam_id => i.project_subteam_id
260: ,p_record_version_number => FND_API.G_MISS_NUM
261: ,x_return_status => x_return_status
262: ,x_msg_count => x_msg_count
263: ,x_msg_data => x_msg_data );
264:

Line 295: , p_init_msg_list => FND_API.G_FALSE -- p_init_msg_list

291: v_null_char := to_char(NULL);
292: v_null_date := to_date(NULL);
293: PA_PROJECT_PARTIES_PUB.DELETE_PROJECT_PARTY(
294: p_api_version => 1.0 -- p_api_version
295: , p_init_msg_list => FND_API.G_FALSE -- p_init_msg_list
296: , p_commit => FND_API.G_FALSE -- p_commit --before it was passed TRUE.
297: , p_validate_only => FND_API.G_FALSE -- p_validate_only
298: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
299: , p_debug_mode => 'N' -- p_debug_mode

Line 296: , p_commit => FND_API.G_FALSE -- p_commit --before it was passed TRUE.

292: v_null_date := to_date(NULL);
293: PA_PROJECT_PARTIES_PUB.DELETE_PROJECT_PARTY(
294: p_api_version => 1.0 -- p_api_version
295: , p_init_msg_list => FND_API.G_FALSE -- p_init_msg_list
296: , p_commit => FND_API.G_FALSE -- p_commit --before it was passed TRUE.
297: , p_validate_only => FND_API.G_FALSE -- p_validate_only
298: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
299: , p_debug_mode => 'N' -- p_debug_mode
300: , p_record_version_number => v_null_number -- p_record_version_number

Line 297: , p_validate_only => FND_API.G_FALSE -- p_validate_only

293: PA_PROJECT_PARTIES_PUB.DELETE_PROJECT_PARTY(
294: p_api_version => 1.0 -- p_api_version
295: , p_init_msg_list => FND_API.G_FALSE -- p_init_msg_list
296: , p_commit => FND_API.G_FALSE -- p_commit --before it was passed TRUE.
297: , p_validate_only => FND_API.G_FALSE -- p_validate_only
298: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
299: , p_debug_mode => 'N' -- p_debug_mode
300: , p_record_version_number => v_null_number -- p_record_version_number
301: , p_calling_module => 'FORM' -- p_calling_module

Line 298: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level

294: p_api_version => 1.0 -- p_api_version
295: , p_init_msg_list => FND_API.G_FALSE -- p_init_msg_list
296: , p_commit => FND_API.G_FALSE -- p_commit --before it was passed TRUE.
297: , p_validate_only => FND_API.G_FALSE -- p_validate_only
298: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- p_validation_level
299: , p_debug_mode => 'N' -- p_debug_mode
300: , p_record_version_number => v_null_number -- p_record_version_number
301: , p_calling_module => 'FORM' -- p_calling_module
302: , p_project_id => x_project_id -- p_project_id

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

590: x_return_status => x_return_status,
591: x_msg_count => x_msg_count,
592: x_msg_data => x_msg_data );
593:
594: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
595: x_err_code := 40;
596: x_err_stack := x_err_stack || '->delete_project_attributes: '|| x_project_id;
597: if l_template_flag = 'Y' then
598: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

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

611: x_return_status => x_return_status,
612: x_msg_count => x_msg_count,
613: x_msg_data => x_msg_data );
614:
615: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
616: x_err_code := 50;
617: x_err_stack := x_err_stack || '->delete_retention_rules: '|| x_project_id;
618: if l_template_flag = 'Y' then
619: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

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

671: ,x_msg_count => x_msg_count
672: ,x_msg_data => x_msg_data
673: ,x_return_status => x_return_status );
674:
675: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
676: x_err_code := 60;
677: x_err_stack := x_err_stack || '->delete_project_structure: '|| x_project_id;
678: if l_template_flag = 'Y' then
679: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

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

692: ,x_msg_count => x_msg_count
693: ,x_msg_data => x_msg_data
694: ,x_return_status => x_return_status );
695:
696: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
697: x_err_code := 70;
698: x_err_stack := x_err_stack || '->delete_all_control_items: '|| x_project_id;
699: if l_template_flag = 'Y' then
700: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

Line 716: p_init_msg_list => FND_API.G_FALSE,

712: -- 30 Mar 2001. For Project Contracts.
713: -- Delete project structure relationship
714: PA_PROJ_STRUCTURE_PUB.DELETE_RELATIONSHIP(
715: p_api_version => 1.0,
716: p_init_msg_list => FND_API.G_FALSE,
717: p_commit => x_commit,
718: p_validate_only => FND_API.G_FALSE,
719: p_debug_mode => 'N',
720: p_task_id => null,

Line 718: p_validate_only => FND_API.G_FALSE,

714: PA_PROJ_STRUCTURE_PUB.DELETE_RELATIONSHIP(
715: p_api_version => 1.0,
716: p_init_msg_list => FND_API.G_FALSE,
717: p_commit => x_commit,
718: p_validate_only => FND_API.G_FALSE,
719: p_debug_mode => 'N',
720: p_task_id => null,
721: p_project_id => x_project_id,
722: x_return_status => x_return_status,

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

722: x_return_status => x_return_status,
723: x_msg_count => x_msg_count,
724: x_msg_data => x_msg_data
725: );
726: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
727: x_err_code := 80;
728: x_err_stack := x_err_stack || '->delete_relationship: '|| x_project_id;
729: if l_template_flag = 'Y' then
730: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

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

748: x_return_status => x_return_status ,
749: x_msg_count => x_msg_count ,
750: x_msg_data => x_msg_data );
751:
752: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
753: x_err_code := 90;
754: x_err_stack := x_err_stack || '->delete_all_item_assocs: '|| x_project_id;
755: if l_template_flag = 'Y' then
756: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

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

769: p_project_id => x_project_id
770: ,p_template_flag => l_template_flag
771: ,x_return_status => x_return_status );
772:
773: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
774: x_err_code := 100;
775: x_err_stack := x_err_stack || '->pa_project_ctx_search_pvt.delete_row: '|| x_project_id;
776: if l_template_flag = 'Y' then
777: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

Line 791: p_validate_only => FND_API.G_FALSE

787: -- Ext Attribute changes
788: -- Bug 2904327
789:
790: PA_USER_ATTR_PUB.DELETE_ALL_USER_ATTRS_DATA (
791: p_validate_only => FND_API.G_FALSE
792: ,p_project_id => x_project_id
793: ,x_return_status => x_return_status
794: ,x_msg_count => x_msg_count
795: ,x_msg_data => x_msg_data );

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

793: ,x_return_status => x_return_status
794: ,x_msg_count => x_msg_count
795: ,x_msg_data => x_msg_data );
796:
797: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
798: x_err_code := 105;
799: x_err_stack := x_err_stack || '->delete_all_user_attrs_data: '|| x_project_id;
800: if l_template_flag = 'Y' then
801: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

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

812: PA_PROJECT_SETS_PVT.delete_proj_from_proj_set(
813: p_project_id => x_project_id
814: ,x_return_status => x_return_status);
815:
816: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
817: x_err_code := 110;
818: x_err_stack := x_err_stack || '->delete_proj_from_proj_set: '|| x_project_id;
819: if l_template_flag = 'Y' then
820: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

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

833: ,x_return_status => x_return_status
834: ,x_msg_count => x_msg_count
835: ,x_msg_data => x_msg_data );
836:
837: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
838: x_err_code := 115;
839: x_err_stack := x_err_stack || '->Delete_Proj_To_Task_Assoc: '|| x_project_id;
840: if l_template_flag = 'Y' then
841: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

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

860: ,x_return_status => x_return_status
861: ,x_msg_count => x_msg_count
862: ,x_Msg_data => x_msg_data
863: );
864: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
865: RAISE FND_API.G_EXC_ERROR;
866: END IF;
867: END IF;
868: -- till here by skannoji

Line 865: RAISE FND_API.G_EXC_ERROR;

861: ,x_msg_count => x_msg_count
862: ,x_Msg_data => x_msg_data
863: );
864: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
865: RAISE FND_API.G_EXC_ERROR;
866: END IF;
867: END IF;
868: -- till here by skannoji
869:

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

871: Pa_Rbs_Utils.Delete_Proj_Specific_RBS( p_project_id => x_project_id
872: ,x_return_status => x_return_status
873: ,x_msg_count => x_msg_count
874: );
875: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
876: x_err_code := 120;
877: x_err_stack := x_err_stack || '->Delete_Proj_Specific_RBS: '|| x_project_id;
878: IF l_template_flag = 'Y' THEN
879: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

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

889: Pa_Planning_Resource_Utils.Delete_Proj_Specific_Resource( p_project_id => x_project_id
890: ,x_return_status => x_return_status
891: ,x_msg_count => x_msg_count
892: );
893: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
894: x_err_code := 125;
895: x_err_stack := x_err_stack || '->Delete_Proj_Specific_Resource: '|| x_project_id;
896: IF l_template_flag = 'Y' THEN
897: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

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

983: ,x_return_status => x_return_status
984: ,x_msg_count => x_msg_count
985: ,x_msg_data => x_msg_data
986: );
987: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
988: x_err_code := 130;
989: x_err_stack := x_err_stack || '->Delete_Version: '|| x_project_id;
990: IF l_template_flag = 'Y' THEN
991: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

Line 1025: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) then

1021: ,p_object_id => x_project_id
1022: ,x_msg_count =>x_msg_count
1023: ,x_msg_data =>x_msg_data
1024: ,x_return_status =>x_return_status);
1025: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1026: x_err_code := 150;
1027: x_err_stack := x_err_stack || '->Delete_Obj_Status_Changes: '|| x_project_id;
1028: IF l_template_flag = 'Y' THEN
1029: x_err_stage := pa_project_core.get_message_from_stack('PA_CANT_DELETE_TEMPLATE');

Line 1045: if x_commit = FND_API.G_TRUE then

1041: x_err_stack := old_stack;
1042:
1043: --Bug 3617393
1044: x_err_code := 0;
1045: if x_commit = FND_API.G_TRUE then
1046: commit;
1047: end if;
1048:
1049: exception

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

1944: x_return_status => x_return_status,
1945: x_msg_count => x_msg_count,
1946: x_msg_data => x_msg_data );
1947:
1948: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1949: --Added for bug 3617393
1950: x_err_code := 150;
1951: x_err_stack := x_err_stack || '->delete_retention_rules: '|| l_project_id;
1952: IF l_template_flag = 'Y' THEN

Line 1983: p_init_msg_list => FND_API.G_FALSE,

1979: -- Delete project structure relationship
1980: x_err_stage := 'Delete project structure relationship for task ';
1981: PA_PROJ_STRUCTURE_PUB.DELETE_RELATIONSHIP(
1982: p_api_version => 1.0,
1983: p_init_msg_list => FND_API.G_FALSE,
1984: p_commit => FND_API.G_TRUE,
1985: p_validate_only => FND_API.G_FALSE,
1986: p_debug_mode => 'N',
1987: p_task_id => x_TASK_ID,

Line 1984: p_commit => FND_API.G_TRUE,

1980: x_err_stage := 'Delete project structure relationship for task ';
1981: PA_PROJ_STRUCTURE_PUB.DELETE_RELATIONSHIP(
1982: p_api_version => 1.0,
1983: p_init_msg_list => FND_API.G_FALSE,
1984: p_commit => FND_API.G_TRUE,
1985: p_validate_only => FND_API.G_FALSE,
1986: p_debug_mode => 'N',
1987: p_task_id => x_TASK_ID,
1988: p_project_id => null,

Line 1985: p_validate_only => FND_API.G_FALSE,

1981: PA_PROJ_STRUCTURE_PUB.DELETE_RELATIONSHIP(
1982: p_api_version => 1.0,
1983: p_init_msg_list => FND_API.G_FALSE,
1984: p_commit => FND_API.G_TRUE,
1985: p_validate_only => FND_API.G_FALSE,
1986: p_debug_mode => 'N',
1987: p_task_id => x_TASK_ID,
1988: p_project_id => null,
1989: x_return_status => x_return_status,

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

1989: x_return_status => x_return_status,
1990: x_msg_count => x_msg_count,
1991: x_msg_data => x_msg_data
1992: );
1993: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1994: --Added for bug 3617393
1995: x_err_code := 160;
1996: x_err_stack := x_err_stack || '->DELETE_RELATIONSHIP: '|| l_project_id;
1997: IF l_template_flag = 'Y' THEN

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

2071: p_Alt_Task_Id => l_alt_task_Ids,
2072: x_return_status => x_return_status,
2073: x_msg_count => x_msg_count,
2074: x_msg_data => x_msg_data );
2075: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2076:
2077: x_err_code := 165;
2078: x_err_stack := x_err_stack || '->Delete_Alt_Task: '|| x_task_id;
2079: x_err_stage := 'Deleting Alternate tasks for the task failed :: '|| x_task_id;

Line 2127: x_return_status := FND_API.G_RET_STS_SUCCESS;

2123: begin
2124:
2125: SAVEPOINT delete_project_type;
2126:
2127: x_return_status := FND_API.G_RET_STS_SUCCESS;
2128:
2129: --No need to call this API here
2130: /* PA_PROJECT_UTILS.check_delete_project_type_ok(
2131: p_project_type_id => x_project_type_id

Line 2136: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

2132: ,x_return_status => x_return_status
2133: ,x_error_message_code => x_msg_data
2134: );
2135:
2136: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2137: THEN
2138: RETURN;
2139: END IF;
2140: */

Line 2148: x_return_status := FND_API.G_RET_STS_SUCCESS;

2144: where project_type_id = x_project_type_id;
2145:
2146: exception
2147: when others then
2148: x_return_status := FND_API.G_RET_STS_SUCCESS;
2149: rollback to delete_project;
2150: return;
2151: end delete_project_type;
2152:

Line 2173: x_return_status := FND_API.G_RET_STS_SUCCESS;

2169: begin
2170:
2171: SAVEPOINT delete_class_category;
2172:
2173: x_return_status := FND_API.G_RET_STS_SUCCESS;
2174:
2175: -- Delete class_category
2176: delete pa_class_categories
2177: where class_category = x_class_category

Line 2182: x_return_status := FND_API.G_RET_STS_SUCCESS;

2178: ;
2179:
2180: exception
2181: when others then
2182: x_return_status := FND_API.G_RET_STS_SUCCESS;
2183: rollback to delete_class_category;
2184: return;
2185: end delete_class_category;
2186:

Line 2208: x_return_status := FND_API.G_RET_STS_SUCCESS;

2204: begin
2205:
2206: SAVEPOINT delete_class_code;
2207:
2208: x_return_status := FND_API.G_RET_STS_SUCCESS;
2209:
2210: -- Delete class_category
2211: delete pa_class_codes
2212: where class_category = x_class_category

Line 2218: x_return_status := FND_API.G_RET_STS_SUCCESS;

2214: ;
2215:
2216: exception
2217: when others then
2218: x_return_status := FND_API.G_RET_STS_SUCCESS;
2219: rollback to delete_class_code;
2220: return;
2221: end delete_class_code;
2222: