APPS.PA_R_PROJECT_RESOURCES_PVT dependencies on PA_R_PROJECT_RESOURCES_PVT

Line 1: PACKAGE BODY PA_R_PROJECT_RESOURCES_PVT

1: PACKAGE BODY PA_R_PROJECT_RESOURCES_PVT
2: -- $Header: PARCPRVB.pls 120.20.12010000.12 2010/02/10 06:27:01 amehrotr ship $
3: AS
4:
5: --Global Variables

Line 6: G_pkg_name VARCHAR2(30) := 'PA_R_PROJECT_RESOURCES_PVT';

2: -- $Header: PARCPRVB.pls 120.20.12010000.12 2010/02/10 06:27:01 amehrotr ship $
3: AS
4:
5: --Global Variables
6: G_pkg_name VARCHAR2(30) := 'PA_R_PROJECT_RESOURCES_PVT';
7:
8: --Variable for insert multiple assignment information for a resource.
9: G_p_id NUMBER := 0;
10: G_count NUMBER := 0;

Line 1118: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Insert_into_CRM'

1114: X_CRM_RESOURCE_ID := NULL ; -- 4537865 RESET OUT PARAM
1115: WHEN OTHERS THEN
1116: X_CRM_RESOURCE_ID := NULL ; -- 4537865 RESET OUT PARAM
1117: -- Set the exception Message and the stack
1118: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Insert_into_CRM'
1119: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1121: RAISE;
1122: END INSERT_INTO_CRM;

Line 1308: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Insert_into_PA'

1304: PA_DEBUG.Reset_Err_Stack;
1305: EXCEPTION
1306: WHEN OTHERS THEN
1307: -- Set the exception Message and the stack
1308: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Insert_into_PA'
1309: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1311: -- 4537865
1312: x_resource_id := NULL ;

Line 1383: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Check_OU'

1379: PA_DEBUG.Reset_Err_Stack;
1380: EXCEPTION
1381: WHEN OTHERS THEN
1382: -- Set the exception Message and the stack
1383: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Check_OU'
1384: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1386: -- 4537865
1387: x_exp_ou := NULL ;

Line 1793: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Create_Internal_Resource'

1789: -- 4537865
1790: x_resource_id := NULL ;
1791: WHEN OTHERS THEN
1792: -- Set the exception Message and the stack
1793: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Create_Internal_Resource'
1794: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1796: -- 4537865
1797: x_resource_id := NULL ;

Line 1925: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Create_External_Resource'

1921: -- 4537865
1922: x_resource_id := NULL ;
1923: WHEN OTHERS THEN
1924: -- Set the exception Message and the stack
1925: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Create_External_Resource'
1926: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1928: -- 4537865
1929: x_resource_id := NULL ;

Line 3645: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Create_Resource'

3641: WHEN OTHERS THEN
3642:
3643: /*Adding For bug 4087022*/
3644: l_excep := 'Y' ;
3645: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Create_Resource'
3646: ,p_procedure_name =>'Create_Resource' );
3647: /*For bug 4087022*/
3648:
3649: IF p_commit = fnd_api.g_true THEN

Line 3821: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Create_Resource'

3817: IF p_commit = fnd_api.g_true THEN
3818: log_message('rollback in outer exception block');
3819: ROLLBACK TO res_pvt_create_resource; -- line 3005
3820: END IF;
3821: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Create_Resource'
3822: ,p_procedure_name =>PA_DEBUG.G_Err_Stack );
3823: X_RETURN_STATUS := fnd_api.g_ret_sts_unexp_error;
3824: -- 4537865
3825: x_resource_id := NULL ;

Line 4055: wf_core.context('pa_r_project_resources_pvt',

4051:
4052: EXCEPTION
4053:
4054: WHEN OTHERS THEN
4055: wf_core.context('pa_r_project_resources_pvt',
4056: 'create_future_crm_resource',
4057: itemtype,
4058: itemkey,
4059: to_char(actid),

Line 4130: END PA_R_PROJECT_RESOURCES_PVT;

4126: END LOOP;
4127: RETURN L_USER_PERSON_TYPE;
4128: END GET_USER_PERSON_TYPE;
4129:
4130: END PA_R_PROJECT_RESOURCES_PVT;