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.

[Home] [Help]

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 => FND_API.G_TRUE,
718: p_validate_only => FND_API.G_FALSE,
719: p_debug_mode => 'N',
720: p_task_id => null,

Line 717: p_commit => FND_API.G_TRUE,

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 => FND_API.G_TRUE,
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,

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 => FND_API.G_TRUE,
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 746: p_commit => FND_API.G_TRUE ,

742: PA_EGO_WRAPPER_PUB.delete_all_item_assocs(
743: p_api_version => 1.0 ,
744: p_project_id => x_project_id ,
745: p_init_msg_list => NULL ,
746: p_commit => FND_API.G_TRUE ,
747: x_errorcode => x_err_code ,
748: x_return_status => x_return_status ,
749: x_msg_count => x_msg_count ,
750: x_msg_data => x_msg_data );

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 977: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

973: ,x_return_status => x_return_status
974: ,x_msg_count => x_msg_count
975: ,x_msg_data => x_msg_data
976: );
977: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
978: x_err_code := 130;
979: x_err_stack := x_err_stack || '->Delete_Version: '|| x_project_id;
980: IF l_template_flag = 'Y' THEN
981: x_err_stage := pa_project_core.get_message_from_stack( 'PA_CANT_DELETE_TEMPLATE');

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

1011: ,p_object_id => x_project_id
1012: ,x_msg_count =>x_msg_count
1013: ,x_msg_data =>x_msg_data
1014: ,x_return_status =>x_return_status);
1015: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1016: x_err_code := 150;
1017: x_err_stack := x_err_stack || '->Delete_Obj_Status_Changes: '|| x_project_id;
1018: IF l_template_flag = 'Y' THEN
1019: x_err_stage := pa_project_core.get_message_from_stack('PA_CANT_DELETE_TEMPLATE');

Line 1035: if x_commit = FND_API.G_TRUE then

1031: x_err_stack := old_stack;
1032:
1033: --Bug 3617393
1034: x_err_code := 0;
1035: if x_commit = FND_API.G_TRUE then
1036: commit;
1037: end if;
1038:
1039: exception

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

1928: x_return_status => x_return_status,
1929: x_msg_count => x_msg_count,
1930: x_msg_data => x_msg_data );
1931:
1932: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1933: --Added for bug 3617393
1934: x_err_code := 150;
1935: x_err_stack := x_err_stack || '->delete_retention_rules: '|| l_project_id;
1936: IF l_template_flag = 'Y' THEN

Line 1967: p_init_msg_list => FND_API.G_FALSE,

1963: -- Delete project structure relationship
1964: x_err_stage := 'Delete project structure relationship for task ';
1965: PA_PROJ_STRUCTURE_PUB.DELETE_RELATIONSHIP(
1966: p_api_version => 1.0,
1967: p_init_msg_list => FND_API.G_FALSE,
1968: p_commit => FND_API.G_TRUE,
1969: p_validate_only => FND_API.G_FALSE,
1970: p_debug_mode => 'N',
1971: p_task_id => x_TASK_ID,

Line 1968: p_commit => FND_API.G_TRUE,

1964: x_err_stage := 'Delete project structure relationship for task ';
1965: PA_PROJ_STRUCTURE_PUB.DELETE_RELATIONSHIP(
1966: p_api_version => 1.0,
1967: p_init_msg_list => FND_API.G_FALSE,
1968: p_commit => FND_API.G_TRUE,
1969: p_validate_only => FND_API.G_FALSE,
1970: p_debug_mode => 'N',
1971: p_task_id => x_TASK_ID,
1972: p_project_id => null,

Line 1969: p_validate_only => FND_API.G_FALSE,

1965: PA_PROJ_STRUCTURE_PUB.DELETE_RELATIONSHIP(
1966: p_api_version => 1.0,
1967: p_init_msg_list => FND_API.G_FALSE,
1968: p_commit => FND_API.G_TRUE,
1969: p_validate_only => FND_API.G_FALSE,
1970: p_debug_mode => 'N',
1971: p_task_id => x_TASK_ID,
1972: p_project_id => null,
1973: x_return_status => x_return_status,

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

1973: x_return_status => x_return_status,
1974: x_msg_count => x_msg_count,
1975: x_msg_data => x_msg_data
1976: );
1977: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1978: --Added for bug 3617393
1979: x_err_code := 160;
1980: x_err_stack := x_err_stack || '->DELETE_RELATIONSHIP: '|| l_project_id;
1981: IF l_template_flag = 'Y' THEN

Line 2058: x_return_status := FND_API.G_RET_STS_SUCCESS;

2054: begin
2055:
2056: SAVEPOINT delete_project_type;
2057:
2058: x_return_status := FND_API.G_RET_STS_SUCCESS;
2059:
2060: --No need to call this API here
2061: /* PA_PROJECT_UTILS.check_delete_project_type_ok(
2062: p_project_type_id => x_project_type_id

Line 2067: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

2063: ,x_return_status => x_return_status
2064: ,x_error_message_code => x_msg_data
2065: );
2066:
2067: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2068: THEN
2069: RETURN;
2070: END IF;
2071: */

Line 2079: x_return_status := FND_API.G_RET_STS_SUCCESS;

2075: where project_type_id = x_project_type_id;
2076:
2077: exception
2078: when others then
2079: x_return_status := FND_API.G_RET_STS_SUCCESS;
2080: rollback to delete_project;
2081: return;
2082: end delete_project_type;
2083:

Line 2104: x_return_status := FND_API.G_RET_STS_SUCCESS;

2100: begin
2101:
2102: SAVEPOINT delete_class_category;
2103:
2104: x_return_status := FND_API.G_RET_STS_SUCCESS;
2105:
2106: -- Delete class_category
2107: delete pa_class_categories
2108: where class_category = x_class_category

Line 2113: x_return_status := FND_API.G_RET_STS_SUCCESS;

2109: ;
2110:
2111: exception
2112: when others then
2113: x_return_status := FND_API.G_RET_STS_SUCCESS;
2114: rollback to delete_class_category;
2115: return;
2116: end delete_class_category;
2117:

Line 2139: x_return_status := FND_API.G_RET_STS_SUCCESS;

2135: begin
2136:
2137: SAVEPOINT delete_class_code;
2138:
2139: x_return_status := FND_API.G_RET_STS_SUCCESS;
2140:
2141: -- Delete class_category
2142: delete pa_class_codes
2143: where class_category = x_class_category

Line 2149: x_return_status := FND_API.G_RET_STS_SUCCESS;

2145: ;
2146:
2147: exception
2148: when others then
2149: x_return_status := FND_API.G_RET_STS_SUCCESS;
2150: rollback to delete_class_code;
2151: return;
2152: end delete_class_code;
2153: