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.7 2008/11/16 19:24:40 kjai 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.7 2008/11/16 19:24:40 kjai 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 3631: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Create_Resource'

3627: WHEN OTHERS THEN
3628:
3629: /*Adding For bug 4087022*/
3630: l_excep := 'Y' ;
3631: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Create_Resource'
3632: ,p_procedure_name =>'Create_Resource' );
3633: /*For bug 4087022*/
3634:
3635: IF p_commit = fnd_api.g_true THEN

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

3803: IF p_commit = fnd_api.g_true THEN
3804: log_message('rollback in outer exception block');
3805: ROLLBACK TO res_pvt_create_resource; -- line 3005
3806: END IF;
3807: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_R_PROJECT_RESOURCES_PVT.Create_Resource'
3808: ,p_procedure_name =>PA_DEBUG.G_Err_Stack );
3809: X_RETURN_STATUS := fnd_api.g_ret_sts_unexp_error;
3810: -- 4537865
3811: x_resource_id := NULL ;

Line 4038: wf_core.context('pa_r_project_resources_pvt',

4034:
4035: EXCEPTION
4036:
4037: WHEN OTHERS THEN
4038: wf_core.context('pa_r_project_resources_pvt',
4039: 'create_future_crm_resource',
4040: itemtype,
4041: itemkey,
4042: to_char(actid),

Line 4058: END PA_R_PROJECT_RESOURCES_PVT;

4054: resultout := wf_engine.eng_completed||':'||'F';
4055:
4056: END create_future_crm_resource;
4057:
4058: END PA_R_PROJECT_RESOURCES_PVT;