APPS.PA_PROJECT_CORE1 dependencies on PA_LOCATION_UTILS

Line 969: pa_location_utils.check_location_exists

965: -- Location validation
966: if x_country_code is not null then
967: --EH changes
968: BEGIN
969: pa_location_utils.check_location_exists
970: ( p_country_code => x_country_code,
971: p_city => x_city,
972: p_region => x_region,
973: x_return_status => l_return_status,

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

975: IF l_return_status <> 'S'
976: THEN
977: x_err_code := 770;
978: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CHK_LOC_EXISTS');
979: x_err_stack := x_err_stack||'->pa_location_utils.check_location_exists';
980: rollback to copy_project;
981: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
982: return;
983: END IF;

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

985: x_err_code := 770;
986: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
987: -- IF x_err_stage IS NULL
988: -- THEN
989: x_err_stage := 'API: '||'pa_location_utils.check_location_exists'||
990: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
991: -- END IF;
992: rollback to copy_project;
993: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

Line 1026: pa_location_utils.Get_ORG_Location_Details

1022: -- l_country_name VARCHAR2(2000);
1023:
1024: --EH Changes
1025: BEGIN
1026: pa_location_utils.Get_ORG_Location_Details
1027: (p_organization_id => x_organization_id,
1028: x_country_name => l_country_name,
1029: x_city => l_city,
1030: x_region => l_region,

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

1039: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_GET_ORG_LOC_DTLS');
1040: ELSE
1041: x_err_stage := x_error_message_code; --bug fix 2680591
1042: END IF;
1043: x_err_stack := x_err_stack||'->pa_location_utils.Get_ORG_Location_Details';
1044: rollback to copy_project;
1045: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
1046: return;
1047: END IF;

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

1049: x_err_code := 780;
1050: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
1051: -- IF x_error_message_code IS NULL
1052: -- THEN
1053: x_err_stage := 'API: '||'pa_location_utils.Get_ORG_Location_Details'||
1054: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
1055: -- END IF;
1056: rollback to copy_project;
1057: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534

Line 1063: pa_location_utils.check_location_exists(

1059: END;
1060:
1061: --EH Changes
1062: BEGIN
1063: pa_location_utils.check_location_exists(
1064: p_country_code => l_country_code,
1065: p_city => l_city,
1066: p_region => l_region,
1067: x_return_status => l_return_status,

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

1069: IF l_return_status <> 'S'
1070: THEN
1071: x_err_code := 775;
1072: x_err_stage := pa_project_core1.get_message_from_stack( 'PA_ERR_CHK_LOC_EXISTS');
1073: x_err_stack := x_err_stack||'->pa_location_utils.check_location_exists';
1074: rollback to copy_project;
1075: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
1076: return;
1077: END IF;

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

1079: x_err_code := 775;
1080: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
1081: -- IF x_err_stage IS NULL
1082: -- THEN
1083: x_err_stage := 'API: '||'pa_location_utils.check_location_exists'||
1084: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
1085: -- END IF;
1086: rollback to copy_project;
1087: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534