APPS.PA_PROJECT_UTILS dependencies on PA_PROJECT_UTILS

Line 1: package body PA_PROJECT_UTILS as

1: package body PA_PROJECT_UTILS as
2: -- $Header: PAXPUTLB.pls 120.8 2007/02/06 10:19:48 dthakker ship $
3:
4:
5: --

Line 14: l_pkg_name VARCHAR2(30) := 'PA_PROJECT_UTILS';

10: -- project status.
11: -- HISTORY
12: -- 16-OCT-95 R. Chiu Created
13: --
14: l_pkg_name VARCHAR2(30) := 'PA_PROJECT_UTILS';
15: procedure get_project_status_code (x_project_status IN varchar2
16: , x_project_status_code OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
17: , x_err_code IN OUT NOCOPY number --File.Sql.39 bug 4440895
18: , x_err_stage IN OUT NOCOPY varchar2 --File.Sql.39 bug 4440895

Line 1051: pa_project_utils.check_created_proj_reference(x_project_id);

1047:
1048: -- Check if project id is referenced by other projects
1049: x_err_stage := 'check project reference for '|| x_project_id;
1050: status_code :=
1051: pa_project_utils.check_created_proj_reference(x_project_id);
1052: if ( status_code = 1 ) then
1053: x_err_code := 120;
1054: x_err_stage := 'PA_PROJ_CREATED_REF_EXIST';
1055: return;

Line 1641: -- G_Proj_number_Gen_Mode Varchar2(30) := PA_PROJECT_UTILS.GetProjNumMode;

1637: -- If using server side PL/SQL or a client side PL/SQL through Oracle forms,
1638: -- the best way to make use of this function is to define a package variable
1639: -- in your package specification and assign the default value.
1640: -- For example in the package specification
1641: -- G_Proj_number_Gen_Mode Varchar2(30) := PA_PROJECT_UTILS.GetProjNumMode;
1642:
1643: l_proj_number_mode VARCHAR2(30);
1644: CURSOR l_get_proj_number_csr IS
1645: SELECT user_defined_project_num_code

Line 1666: -- G_Proj_number_Gen_Type Varchar2(30) := PA_PROJECT_UTILS.GetProjNumType;

1662: -- If using server side PL/SQL or a client side PL/SQL through Oracle forms,
1663: -- the best way to make use of this function is to define a package variable
1664: -- in your package specification and assign the default value.
1665: -- For example in the package specification
1666: -- G_Proj_number_Gen_Type Varchar2(30) := PA_PROJECT_UTILS.GetProjNumType;
1667:
1668: l_proj_number_type VARCHAR2(30);
1669: CURSOR l_get_proj_type_csr IS
1670: SELECT manual_project_num_type

Line 2382: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_UTILS',

2378:
2379: EXCEPTION
2380: WHEN OTHERS THEN
2381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2382: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_UTILS',
2383: p_procedure_name => 'VALIDATE_DFF',
2384: p_error_text => SUBSTRB(SQLERRM,1,240));
2385: raise;
2386: END VALIDATE_DFF;

Line 2388: END PA_PROJECT_UTILS;

2384: p_error_text => SUBSTRB(SQLERRM,1,240));
2385: raise;
2386: END VALIDATE_DFF;
2387:
2388: END PA_PROJECT_UTILS;