2959: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
2960: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2961: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2962: ,p_debug_mode IN VARCHAR2 :='N'
2963: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2964: ,p_project_id IN NUMBER
2965: ,p_task_id IN NUMBER
2966: ,p_as_of_date IN DATE
2967: ,P_txn_cost IN NUMBER
6558: FUNCTION get_bcws (p_project_id IN NUMBER
6559: ,p_object_id IN NUMBER
6560: ,p_proj_element_id IN NUMBER
6561: ,p_as_of_date IN DATE
6562: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6563: ,p_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6564: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
6565: ,p_scheduled_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
6566: ,p_prj_currency_code IN VARCHAR2 := null --bug 3824042
6559: ,p_object_id IN NUMBER
6560: ,p_proj_element_id IN NUMBER
6561: ,p_as_of_date IN DATE
6562: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6563: ,p_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6564: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
6565: ,p_scheduled_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
6566: ,p_prj_currency_code IN VARCHAR2 := null --bug 3824042
6567: ,p_structure_type IN VARCHAR2 := 'WORKPLAN' --maansari4/10
6560: ,p_proj_element_id IN NUMBER
6561: ,p_as_of_date IN DATE
6562: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6563: ,p_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6564: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
6565: ,p_scheduled_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
6566: ,p_prj_currency_code IN VARCHAR2 := null --bug 3824042
6567: ,p_structure_type IN VARCHAR2 := 'WORKPLAN' --maansari4/10
6568: ) RETURN NUMBER
6561: ,p_as_of_date IN DATE
6562: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
6563: ,p_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6564: ,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
6565: ,p_scheduled_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
6566: ,p_prj_currency_code IN VARCHAR2 := null --bug 3824042
6567: ,p_structure_type IN VARCHAR2 := 'WORKPLAN' --maansari4/10
6568: ) RETURN NUMBER
6569: IS
6671: get_plan_value(p_project_id,p_structure_version_id,p_proj_element_id,p_as_of_date );
6672: END IF;
6673: --bug 6664716
6674:
6675: if (p_rollup_method IS NOT NULL and p_rollup_method <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) then
6676:
6677: if p_rollup_method = 'EFFORT' then
6678: --bug 3824042
6679: --l_return_bcws := trunc((nvl(c2rec.labor_hours,0)+nvl(c2rec.equipment_hours,0)),2);
9514: WHEN FND_API.G_EXC_ERROR THEN
9515: x_return_status := FND_API.G_RET_STS_ERROR;
9516: x_msg_count := FND_MSG_PUB.Count_Msg;
9517: If x_msg_count = 1 THEN
9518: pa_interface_utils_pub.get_messages
9519: (p_encoded => FND_API.G_TRUE,
9520: p_msg_index => 1,
9521: p_msg_count => x_msg_count,
9522: p_msg_data => x_msg_data,
9540: x_return_status := FND_API.G_RET_STS_ERROR;
9541: x_msg_data := 'PA_PROG_INSUFFICIENT_PARA';
9542: x_msg_count := FND_MSG_PUB.Count_Msg;
9543: If x_msg_count = 1 THEN
9544: pa_interface_utils_pub.get_messages
9545: (p_encoded => FND_API.G_TRUE,
9546: p_msg_index => 1,
9547: p_msg_count => x_msg_count,
9548: p_msg_data => x_msg_data,
9566: x_msg_data := SUBSTR(SQLERRM,1,120);
9567: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROGRESS_UTILS',
9568: p_procedure_name => 'Get_Res_Rate_Burden_Multiplier');
9569: If x_msg_count = 1 THEN
9570: pa_interface_utils_pub.get_messages
9571: (p_encoded => FND_API.G_TRUE,
9572: p_msg_index => 1,
9573: p_msg_count => x_msg_count,
9574: p_msg_data => x_msg_data,