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.9.12020000.3 2013/04/02 07:05:10 speddi 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 1653: -- G_Proj_number_Gen_Mode Varchar2(30) := PA_PROJECT_UTILS.GetProjNumMode;

1649: -- If using server side PL/SQL or a client side PL/SQL through Oracle forms,
1650: -- the best way to make use of this function is to define a package variable
1651: -- in your package specification and assign the default value.
1652: -- For example in the package specification
1653: -- G_Proj_number_Gen_Mode Varchar2(30) := PA_PROJECT_UTILS.GetProjNumMode;
1654:
1655: l_proj_number_mode VARCHAR2(30);
1656: CURSOR l_get_proj_number_csr IS
1657: SELECT user_defined_project_num_code

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

1674: -- If using server side PL/SQL or a client side PL/SQL through Oracle forms,
1675: -- the best way to make use of this function is to define a package variable
1676: -- in your package specification and assign the default value.
1677: -- For example in the package specification
1678: -- G_Proj_number_Gen_Type Varchar2(30) := PA_PROJECT_UTILS.GetProjNumType;
1679:
1680: l_proj_number_type VARCHAR2(30);
1681: CURSOR l_get_proj_type_csr IS
1682: SELECT manual_project_num_type

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

2390:
2391: EXCEPTION
2392: WHEN OTHERS THEN
2393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2394: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_UTILS',
2395: p_procedure_name => 'VALIDATE_DFF',
2396: p_error_text => SUBSTRB(SQLERRM,1,240));
2397: raise;
2398: END VALIDATE_DFF;

Line 2421: END PA_PROJECT_UTILS;

2417: WHEN OTHERS THEN
2418: RETURN -999;
2419: END get_person_id;
2420:
2421: END PA_PROJECT_UTILS;