APPS.PA_PROJECT_CORE1 dependencies on PA_LOCATION_UTILS

Line 981: pa_location_utils.check_location_exists

977: -- Location validation
978: if x_country_code is not null then
979: --EH changes
980: BEGIN
981: pa_location_utils.check_location_exists
982: ( p_country_code => x_country_code,
983: p_city => x_city,
984: p_region => x_region,
985: x_return_status => l_return_status,

Line 991: x_err_stack := x_err_stack||'->pa_location_utils.check_location_exists';

987: IF l_return_status <> 'S'
988: THEN
989: x_err_code := 770;
990: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CHK_LOC_EXISTS');
991: x_err_stack := x_err_stack||'->pa_location_utils.check_location_exists';
992: rollback to copy_project;
993: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
994: return;
995: END IF;

Line 1001: x_err_stage := 'API: '||'pa_location_utils.check_location_exists'||

997: x_err_code := 770;
998: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
999: -- IF x_err_stage IS NULL
1000: -- THEN
1001: x_err_stage := 'API: '||'pa_location_utils.check_location_exists'||
1002: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
1003: -- END IF;
1004: rollback to copy_project;
1005: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

Line 1038: pa_location_utils.Get_ORG_Location_Details

1034: -- l_country_name VARCHAR2(2000);
1035:
1036: --EH Changes
1037: BEGIN
1038: pa_location_utils.Get_ORG_Location_Details
1039: (p_organization_id => x_organization_id,
1040: x_country_name => l_country_name,
1041: x_city => l_city,
1042: x_region => l_region,

Line 1055: x_err_stack := x_err_stack||'->pa_location_utils.Get_ORG_Location_Details';

1051: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_GET_ORG_LOC_DTLS');
1052: ELSE
1053: x_err_stage := x_error_message_code; --bug fix 2680591
1054: END IF;
1055: x_err_stack := x_err_stack||'->pa_location_utils.Get_ORG_Location_Details';
1056: rollback to copy_project;
1057: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
1058: return;
1059: END IF;

Line 1065: x_err_stage := 'API: '||'pa_location_utils.Get_ORG_Location_Details'||

1061: x_err_code := 780;
1062: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
1063: -- IF x_error_message_code IS NULL
1064: -- THEN
1065: x_err_stage := 'API: '||'pa_location_utils.Get_ORG_Location_Details'||
1066: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
1067: -- END IF;
1068: rollback to copy_project;
1069: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

Line 1075: pa_location_utils.check_location_exists(

1071: END;
1072:
1073: --EH Changes
1074: BEGIN
1075: pa_location_utils.check_location_exists(
1076: p_country_code => l_country_code,
1077: p_city => l_city,
1078: p_region => l_region,
1079: x_return_status => l_return_status,

Line 1085: x_err_stack := x_err_stack||'->pa_location_utils.check_location_exists';

1081: IF l_return_status <> 'S'
1082: THEN
1083: x_err_code := 775;
1084: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CHK_LOC_EXISTS');
1085: x_err_stack := x_err_stack||'->pa_location_utils.check_location_exists';
1086: rollback to copy_project;
1087: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
1088: return;
1089: END IF;

Line 1095: x_err_stage := 'API: '||'pa_location_utils.check_location_exists'||

1091: x_err_code := 775;
1092: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
1093: -- IF x_err_stage IS NULL
1094: -- THEN
1095: x_err_stage := 'API: '||'pa_location_utils.check_location_exists'||
1096: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
1097: -- END IF;
1098: rollback to copy_project;
1099: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534