[Home] [Help]
77: RETURN;
78: END IF;
79:
80: -- Check if the Route is existing and in Draft status
81: AHL_RM_ROUTE_UTIL.validate_route_status
82: (
83: p_route_id,
84: l_msg_data,
85: l_return_status
152: p_x_route_operation_rec.operation_id <> FND_API.G_MISS_NUM ) OR
153: ( p_x_route_operation_rec.concatenated_segments IS NOT NULL AND
154: p_x_route_operation_rec.concatenated_segments <> FND_API.G_MISS_CHAR ) ) THEN
155:
156: AHL_RM_ROUTE_UTIL.validate_operation
157: (
158: x_return_status => l_return_status,
159: x_msg_data => l_msg_data,
160: p_concatenated_segments => p_x_route_operation_rec.concatenated_segments,
609:
610: CLOSE get_active_operation;
611:
612: -- Validate whether the longest Duration specified for the operation Resource is longer than associated Route Time Span.
613: AHL_RM_ROUTE_UTIL.validate_rt_op_res_duration
614: (
615: x_return_status => l_return_status,
616: x_msg_data => l_msg_data,
617: p_route_id => p_route_id,
767: END IF;
768:
769: -- This is to be added before calling validate_api_inputs()
770: -- Validate Application Usage
771: AHL_RM_ROUTE_UTIL.validate_ApplnUsage
772: (
773: p_object_id => p_route_id,
774: p_association_type => 'ROUTE' ,
775: x_return_status => x_return_status,
820: IF ( p_x_route_operation_tbl(i).operation_id IS NULL OR
821: p_x_route_operation_tbl(i).operation_id = FND_API.G_MISS_NUM )
822: THEN
823: -- Function to convert Operation number, operation revision to id
824: AHL_RM_ROUTE_UTIL.Operation_Number_To_Id
825: (
826: p_operation_number => p_x_route_operation_tbl(i).concatenated_segments,
827: p_operation_revision => p_x_route_operation_tbl(i).revision_number,
828: x_operation_id => p_x_route_operation_tbl(i).operation_id,
833: fnd_log.string
834: (
835: fnd_log.level_statement,
836: 'ahl.plsql.'||g_pkg_name||'.'||g_api_name||':',
837: 'Error in AHL_RM_ROUTE_UTIL.Operation_Number_To_Id API'
838: );
839: END IF;
840: RAISE FND_API.G_EXC_ERROR;
841: END IF;